/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 votes240 views1 answer
Python USD to Euro Converter
Python
0 vote257 views1 answer
How to separate string in python by blank line
Python
0 vote240 views1 answer
Python select from list by condition
Python
1 vote247 views1 answer
Read csv python without id
Python
1 vote231 views1 answer
Mean Kurtosis of all rows pandas
Python
0 vote282 views2 answers
Django rest framework foreign key relation giving error in serializer
Python Django
0 vote260 views1 answer
Write a Python program to get the Fibonacci series between 0 to 50. Note : The Fibonacci Sequence is the series of numbers
Python
0 vote253 views1 answer
Sqlite3 python parameterized query insert into
Python
3 votes263 views1 answer
Word pattern python
Python
0 vote251 views1 answer
Pandas column string first n characters
Python

Share