/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 vote313 views2 answers
How to do date time formatting with strftime in python
Python
39 votes321 views6 answers
Pandas print all columns
Python
0 vote310 views1 answer
Flatten columns after pivot pandas
Python
0 vote327 views1 answer
Drop first column read_csv
Python
10 votes312 views1 answer
Is not none python
Python
3 votes307 views2 answers
Find minimum and maximum element in an array
Python
2 votes314 views1 answer
Sqlite operational error no such column
Python
0 vote330 views1 answer
Settings.debug django
Python
11 votes366 views5 answers
Pandas dataframe delete column
Python
0 vote296 views1 answer
How to resume request downloads
Python

Share