/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 vote166 views1 answer
Sum of all substrings of a number
Python
0 vote127 views1 answer
Check if variable is defined in python
Python
0 vote119 views1 answer
How to set time limit for receiving data in socket python
Python
0 vote143 views2 answers
Python assert
Python
1 vote137 views1 answer
Install serial python
Python
11 votes129 views4 answers
Macos set default python version
Python
0 vote114 views1 answer
Ios iterate through dictionary
Python
0 vote202 views1 answer
Compress tarfile python
Python
0 vote125 views1 answer
Create dataframe pyspark
Python
0 vote122 views1 answer
Scrfoll with selenium python
Python

Share