/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

12 votes400 views5 answers
Append python
Python
3 votes394 views1 answer
Flask give port number
Python Flask
0 vote327 views1 answer
AttributeError: module 'skimage' has no attribute 'segmentation'
Python
0 vote344 views1 answer
DataFrame changed by function
Python
0 vote398 views1 answer
Django never_cache example
Python Django
0 vote375 views1 answer
How to convert cost to float in python
Python
0 vote388 views1 answer
Python window icon on task bar
Python
1 vote376 views1 answer
Exception: ROM is missing for space_invaders, see https://github.com/openai/atari-py#roms for instructions site:stackoverflow.com
Python
1 vote338 views1 answer
Find nth root of m using python
Python
0 vote391 views1 answer
Pyqt5 open tab
Python

Share