Calculate sum across rows and columns in Pandas DataFrame
Sum across rows and columns:
import pandas as pd df = pd.DataFrame([[10, 20, 30, 40], [7, 14, 21, 28], [5, 5, 0, 0]], columns=['Apple', 'Orange', 'Banana', 'Pear'], index=['Basket1', 'Basket2', 'Basket3']) df['Sum Basket'] = df.sum(axis=1) df.loc['Sum Fruit'] = df.sum() print(df)
C:\pandas>python example40.py Apple Orange Banana Pear Sum Basket Basket1 10 20 30 40 100 Basket2 7 14 21 28 70 Basket3 5 5 0 0 10 Sum Fruit 22 39 51 68 180 C:\pandas>
2018-10-29T19:19:34+05:30
2018-10-29T19:19:34+05:30
Amit Arora
Amit Arora
Python Programming Tutorial
Python
Practical Solution