/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

6 votes255 views2 answers
Python get current time in seconds
Python
0 vote268 views1 answer
Turn off subplot
Python
3 votes298 views3 answers
Tensorflow to numpy
Python
0 vote255 views1 answer
Python manually trigger exception
Python
2 votes252 views1 answer
Python read_excel index_col
Python
0 vote321 views1 answer
Gevent with flask
Python Flask
0 vote241 views3 answers
Python ascii to string
Python
0 vote254 views1 answer
Get random bright hex color python
Python
0 vote230 views1 answer
Console code page (437) differs from Windows code page (1252) 8-bit characters might not work correctly
Python
1 vote256 views2 answers
Django queryset unique values
Python

Share