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

3 votes181 views1 answer
Pandas date missing from datetime
Python
2 votes233 views3 answers
Python random number generator no duplicates
Python
5 votes229 views1 answer
Convert jupyter notebook to python cmd line
Python
0 vote257 views1 answer
Write multiple DataFrames to Excel files
Python
0 vote225 views1 answer
Logistic regression python family binomial
Python
0 vote229 views3 answers
How to replace zero with null in python
Python
0 vote241 views1 answer
How to get a row of a dataframe with subset columns in python
Python
37 votes232 views5 answers
Run python file from cmd
Python
0 vote192 views1 answer
Split string with first numerical value in python
Python
25 votes283 views6 answers
Pickle python
Python