/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

2 votes147 views1 answer
Django load model by name
Python
9 votes150 views2 answers
How to install packages inside thepython script
Python
1 vote165 views4 answers
How to input in a list in python
Python
0 vote182 views1 answer
Get a colomn of csv in pandas
Python
1 vote119 views1 answer
Float to binary python
Python
14 votes159 views3 answers
Flask link stylesheet
Python
0 vote230 views1 answer
Django only certain columns from database
Python Django
0 vote160 views1 answer
Calculate mape python
Python
0 vote175 views1 answer
Djangobook.com jwd django restfremwork plugin
Python
0 vote191 views1 answer
Index from multiindex pandas
Python

Share