/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 votes198 views1 answer
Find number of common element in two python array
Python
3 votes153 views1 answer
Change plot size matplotlib python
Python
0 vote154 views1 answer
Python list of datetimes as type string
Python
17 votes179 views5 answers
What is python used for
Python
2 votes156 views1 answer
Suppres tensorflow warnings
Python
12 votes161 views2 answers
Python how to return max num index
Python
0 vote157 views1 answer
Gematria python
Python
-1 vote170 views1 answer
Django cheat sheet pdf
Python
0 vote147 views1 answer
Pandas count all values in whole dataframe
Python
33 votes141 views4 answers
Split word python
Python

Share