/Python/Pandas add a total row to dataframe

Pandas add a total row to dataframe

Add rows to dataframe pandas

df = df.append({'a':1, 'b':2}, ignore_index=True)

29

Pandas insert row

 df.loc[-1] = [2, 3, 4]  # adding a row
 df.index = df.index + 1  # shifting index
 df = df.sort_index()  # sorting by index

1

Source: stackoverflow.com

Pandas add a total row to dataframe

df.append(df.sum().rename('Total'))

0

Source: stackoverflow.com

Similar codes

0 vote147 views1 answer
Tuple count in python
Python
1 vote97 views4 answers
Create static library
Python
0 vote154 views1 answer
Sample one point from distribution python
Python
4 votes128 views2 answers
Empty array python
Python
11 votes127 views2 answers
List map lambda python
Python
0 vote130 views1 answer
Python output text
Python
2 votes145 views1 answer
All frequency offset in pandas
Python
2 votes171 views1 answer
Hyperlinks in jupyter notebook
Python
1 vote144 views1 answer
Python script to sort file content
Python
0 vote124 views1 answer
Python beautifulsoup write to file
Python

Share