/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 vote251 views1 answer
How to create a custom function in python
Python
0 vote303 views1 answer
Python PyDrive service account credentials
Python
0 vote204 views1 answer
How to loop through glob.iglob iterator
Python
0 vote222 views1 answer
How to capitalize every item in a list python
Python
1 vote188 views1 answer
Django group by date from datetime field
Python
0 vote174 views1 answer
New sytax in python 3
Python
2 votes205 views1 answer
Python check if string is date format
Python
0 vote189 views1 answer
Radice n esima python
Python
1 vote175 views1 answer
Python how to create attribute of class while iterating a list
Python
5 votes178 views3 answers
Convert list to dataframe
Python

Share