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

4 votes137 views4 answers
Download pdf python
Python
0 vote181 views1 answer
Django retrieveupdatedestroyapiview
Python
7 votes142 views3 answers
Sklearn random forest regressor
Python
0 vote129 views1 answer
List get both index and value.
Python
2 votes142 views1 answer
How to run python file in when windows startup
Python
1 vote168 views1 answer
Dot notation python
Python
34 votes130 views6 answers
Class python example
Python
10 votes142 views1 answer
Django new static files directory
Python
0 vote129 views1 answer
Python - change the bin size of an histogram+
Python
0 vote181 views2 answers
Pandas split column with tuple
Python