/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

1 vote213 views1 answer
Python install ffpyplayer
Python
1 vote224 views3 answers
Flatmap python
Python
0 vote221 views1 answer
Renpy quickstart
Python
0 vote235 views1 answer
Django form custom validation
Python
2 votes243 views2 answers
Remove first item from list python
Python
5 votes240 views1 answer
Pandas read tsv
Python
1 vote220 views1 answer
How to add to hashmap python
Python
38 votes233 views2 answers
Pickle.load python
Python
1 vote227 views1 answer
Python head function show all columns
Python
0 vote242 views1 answer
Type object 'SparkContext' has no attribute '_jsc'
Python

Share