/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 vote173 views1 answer
Sort array python by column
Python
0 vote163 views1 answer
Pyqt5 date-edity
Python
0 vote208 views1 answer
Best way to access nested key in python
Python
0 vote264 views2 answers
Scikit learn decistion tree
Python
0 vote248 views1 answer
Field 'id' expected a number but got <django.db.models.fields.related_descriptors.create_forward_many_to_many_manager.<locals>.ManyRelatedManager object at 0x7fb02044de80>
Python Django
2 votes189 views1 answer
Python can't subtract offset-naive and offset-aware datetimes
Python
3 votes163 views2 answers
Otp generation in python
Python
0 vote177 views1 answer
How to add a key and a value to a dictionary in python\
Python
0 vote165 views1 answer
Hungarian algorithm python
Python
0 vote169 views2 answers
Python manual elif
Python

Share