/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 vote110 views1 answer
Tkinter new line in text
Python
0 vote106 views1 answer
Python pandas get labels
Python
2 votes287 views1 answer
Radio button pyqt
Python
4 votes149 views1 answer
Django slug int url mapping
Python Django
2 votes102 views1 answer
Python for loop m to n
Python
5 votes142 views2 answers
Importing python module from different directory
Python
-1 vote120 views1 answer
Check for null values in rows pyspark
Python
2 votes121 views1 answer
Selenium python enter text
Python
-2 votes98 views1 answer
Nodejs print
Python
-1 vote138 views3 answers
Try using .loc[row_indexer,col_indexer] = value instead
Python

Share