/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 vote301 views1 answer
Adding extra fields to user model django
Python Django
-3 votes223 views2 answers
Mean
Python
0 vote194 views1 answer
Pyspark import stringtype
Python
0 vote208 views1 answer
Delete history django simple
Python
20 votes216 views1 answer
ParserError: Error tokenizing data. C error: Expected 1 fields in line 87, saw 2
Python
2 votes195 views1 answer
Python only numbers in string
Python
0 vote203 views1 answer
Python remove suffix
Python
0 vote237 views1 answer
Area of a right angle triangle in python
Python
-1 vote206 views1 answer
How to sort by date in .csv
Python
0 vote201 views1 answer
Ticklabels are not centered heatmap
Python

Share