/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

17 votes142 views5 answers
What is python used for
Python
1 vote149 views1 answer
How to run the server in django
Python Django
4 votes102 views4 answers
Printing hello world in python
Python
0 vote104 views2 answers
Not using first row as index pandas
Python
0 vote66 views1 answer
Python get text between two comma
Python
0 vote114 views1 answer
Module 'tensorflow' has no attribute 'InteractiveSession'
Python
0 vote116 views3 answers
OpenCV(3.4.11) Error: Assertion failed (_img.rows * _img.cols == vecSize) in CvCascadeImageReader::PosReader::get
Python
3 votes103 views3 answers
Remove x label matplotlib
Python
17 votes107 views10 answers
Time
Python
2 votes109 views2 answers
How to invert plot axis python
Python

Share