/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 vote266 views1 answer
Python sklearn knn regression example
Python
16 votes257 views2 answers
How to fillna in all columns with their mean values
Python
-1 vote271 views1 answer
Print(shahzaib)
Python
22 votes280 views4 answers
Access first element of dictionary python
Python
0 vote284 views1 answer
Filter list of tuples python
Python
0 vote270 views1 answer
What is type
Python
1 vote274 views1 answer
Compile python to pyc
Python
1 vote294 views2 answers
React icon size
Python
0 vote268 views1 answer
Get only every 2 rows pandas
Python
31 votes266 views6 answers
Count list python
Python

Share