Sum of a column in pandas

Total = df['MyColumn'].sum()
print (Total)
319

Source: stackoverflow.com

Pandas ttable with sum totals

import numpy as np
import pandas as pd


df = pd.DataFrame({'a': [10,20],'b':[100,200],'c': ['a','b']})

df.loc['Column_Total']= df.sum(numeric_only=True, axis=0)
df.loc[:,'Row_Total'] = df.sum(numeric_only=True, axis=1)

print(df)

                 a      b    c  Row_Total
0             10.0  100.0    a      110.0
1             20.0  200.0    b      220.0
Column_Total  30.0  300.0  NaN      330.0

Source: stackoverflow.com

Similar codes

0 vote197 views1 answer
How to install packages offline? Ask Question
Python
0 vote177 views1 answer
Sys.path[0]
Python
1 vote179 views1 answer
Dataframe cut based on range
Python
29 votes185 views9 answers
Traduttore
Python
0 vote202 views1 answer
Pandas rename columns whitespace with underscore
Python
2 votes165 views2 answers
How to take input in python3 separated by space
Python
1 vote135 views1 answer
How to create a list of tuples in python
Python
1 vote171 views4 answers
Check internet speed using python
Python
2 votes172 views1 answer
Pip avticate venv
Python
-1 vote164 views1 answer
"scrapy shell" pass cookies to fetch
Python