/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

1 vote315 views3 answers
Python ssh connection
Python
0 vote263 views1 answer
Python second max in numpy array
Python
0 vote312 views1 answer
Db connection string timeout
Python
2 votes316 views2 answers
Convert np shape (a,) to (a,1)
Python
1 vote302 views1 answer
Python to mac executable
Python
23 votes304 views6 answers
How to install pyinstaller
Python
0 vote318 views1 answer
How to convert multi list into dict in python
Python
0 vote294 views1 answer
Max deviation in pandas
Python
4 votes292 views3 answers
Matplotlib xticks font size
Python
0 vote239 views1 answer
56
Python

Share