/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

0 vote274 views1 answer
Get file in file zip python
Python
21 votes273 views1 answer
Jupyter ignore warnings
Python
0 vote277 views1 answer
Table pandas to postgresql
Python
1 vote259 views1 answer
Django template tags capitalize
Python
1 vote281 views1 answer
Django get model class from queryset
Python Django
0 vote296 views1 answer
Python discord know message from bot
Python
0 vote266 views1 answer
Python n range num list
Python
0 vote266 views1 answer
Creating venv on vscode linux
Python
1 vote263 views1 answer
Apostrophe in python
Python
18 votes291 views4 answers
Python strip newline from string
Python

Share