/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 vote197 views2 answers
Beautifulsoup docs
Python
0 vote235 views1 answer
How to customize simplejwt error response message in django restframework
Python Django
0 vote204 views1 answer
Python seeded random
Python
1 vote209 views1 answer
FileNotFoundError: [Errno 2] No such file or directory: 'E:\\Work\\Geeky_B\\NWIS_DEMO\\dist\\ttest_spacy\\thinc\\neural\\_custom_kernels.cu' [1192] Failed to execute script ttest_spacy + pyinstaller
Python
1 vote214 views1 answer
Handle queries in ListView django
Python
0 vote203 views1 answer
How to get parent model object based on child model filter in django
Python
2 votes212 views2 answers
What does if __name_=="_main__": do?
Python
2 votes212 views1 answer
Simple bmi calculator using python
Python
0 vote223 views1 answer
Django python base 64 encode
Python Django
4 votes212 views1 answer
How to calculate rmse in linear regression python
Python

Share