Pandas sum

import pandas as pd

data = {'Month': ['Jan ','Feb ','Mar ','Apr ','May ','Jun '],
        'Bill Commission': [1500,2200,3500,1800,3000,2800],
        'Maria Commission': [3200,4100,2500,3000,4700,3400], 
        'Jack Commission': [1700,3100,3300,2700,2400,3100]
        }

df = pd.DataFrame(data,columns=['Month','Bill Commission','Maria Commission','Jack Commission'])
sum_column = df.sum(axis=0)
print (sum_column)

Source: datatofish.com

Pandas sum

# select numeric columns and calculate the sums
sums = df.select_dtypes(pd.np.number).sum().rename('total')

# append sums to the data frame
df.append(sums)
#         X  MyColumn      Y      Z
#0        A      84.0   13.0   69.0
#1        B      76.0   77.0  127.0
#2        C      28.0   69.0   16.0
#3        D      28.0   28.0   31.0
#4        E      19.0   20.0   85.0
#5        F      84.0  193.0   70.0
#total  NaN     319.0  400.0  398.0

Source: stackoverflow.com

Pandas sum

df.at['Total', 'MyColumn'] = df['MyColumn'].sum()
print (df)
         X  MyColumn      Y      Z
0        A      84.0   13.0   69.0
1        B      76.0   77.0  127.0
2        C      28.0   69.0   16.0
3        D      28.0   28.0   31.0
4        E      19.0   20.0   85.0
5        F      84.0  193.0   70.0
Total  NaN     319.0    NaN    NaN

Source: stackoverflow.com

Pandas sum

import pandas as pd

data = {'Month': ['Jan ','Feb ','Mar ','Apr ','May ','Jun '],
        'Bill Commission': [1500,2200,3500,1800,3000,2800],
        'Maria Commission': [3200,4100,2500,3000,4700,3400], 
        'Jack Commission': [1700,3100,3300,2700,2400,3100]
        }

df = pd.DataFrame(data,columns=['Month','Bill Commission','Maria Commission','Jack Commission'])
print (df)

Source: datatofish.com

Pandas sum

>>> sum(ugds)16200904.0>>> ugds.sum()16200904.0

Source: medium.com

Similar codes

0 vote302 views1 answer
How to run a seaborn plot on pycharm
Python
1 vote287 views1 answer
Replace the jinja template value inside the dictionary python
Python
5 votes279 views1 answer
How to override save method in django
Python
5 votes288 views1 answer
Resize imshow opencv python
Python
0 vote301 views1 answer
How to modify name of email from divi
Python
4 votes278 views2 answers
How to make a screen in pygame
Python
0 vote336 views1 answer
Then generate Django project from the project template of cookiecutter
Python Django
5 votes295 views3 answers
Update in django orm
Python
4 votes283 views1 answer
How to save matplotlib figure to png
Python
4 votes339 views3 answers
Django Change Password
Python Django