/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 vote86 views1 answer
Torch concat two 1d tensor
Python
1 vote97 views1 answer
Python convert file into list
Python
29 votes104 views4 answers
How to remove all characters from a string in python
Python
5 votes95 views1 answer
For el index list python
Python
1 vote106 views1 answer
How to convert tuple into list in python
Python
5 votes92 views2 answers
Python how to put int into list
Python
5 votes158 views2 answers
How to draw image in tkinter
Python
1 vote97 views1 answer
Private instance attribute python
Python
0 vote92 views1 answer
Pandas fillna with median of column
Python
4 votes118 views2 answers
Python dump object print
Python

Share