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 vote172 views2 answers
Friends phoebe
Python
0 vote269 views1 answer
Django oauth toolkit permanent access token
Python Django
12 votes153 views3 answers
Get screen size python
Python
38 votes150 views3 answers
Remove python package
Python
7 votes144 views1 answer
Short if else in python
Python
0 vote137 views1 answer
Install simple audio in python
Python
-1 vote156 views1 answer
Create file in a specific directory python
Python
26 votes148 views1 answer
Dictionary from two lists
Python
0 vote177 views1 answer
Rom pathlib import Path # Build paths inside the project like this: BASE_DIR / 'subdir'. BASE_DIR = Path(__file__).resolve().parent.parent
Python
0 vote144 views1 answer
Save numpy arrayw with PIL
Python