/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

5 votes144 views10 answers
Online python to c converter
Python
0 vote140 views1 answer
-bash: /usr/local/bin/python3: no such file or directory
Python
-1 vote135 views1 answer
Groupby where only
Python
3 votes178 views3 answers
User input dictionary python
Python
0 vote124 views1 answer
400/15
Python
2 votes132 views1 answer
With font type stuff python turtle
Python
1 vote136 views1 answer
Python regex get string before character
Python
13 votes124 views3 answers
How to take user input in a list in python
Python
1 vote152 views3 answers
Making ckeditor django responsive
Python Django
0 vote121 views1 answer
Hsv to rgb python
Python

Share