Get Sum in Python – List, pandas DataFrame Column & Row (4 Examples)

my_lt = [10, 6, 2, 2, 15, 20, 3, 7, 4]      # Constructing a list in Python
print(my_lt)
# [10, 6, 2, 2, 15, 20, 3, 7, 4]

my_lt = [10, 6, 2, 2, 15, 20, 3, 7, 4] # Constructing a list in Python print(my_lt) # [10, 6, 2, 2, 15, 20, 3, 7, 4]

import numpy as np                          # Import NumPy library in Python

import numpy as np # Import NumPy library in Python

print(np.sum(my_lt))                        # Computing the sum of a list
# 69

print(np.sum(my_lt)) # Computing the sum of a list # 69

import pandas as pd                         # Import pandas

import pandas as pd # Import pandas

my_df = pd.DataFrame({'A':range(10, 17),    # Constructing a pandas DataFrame
                      'B':[6, 1, 8, 5, 3, 8, 9],
                      'C':range(2, 9),
                      'GRP':['gr1', 'gr2', 'gr1', 'gr3', 'gr1', 'gr2', 'gr3']})
print(my_df)
#     A  B  C  GRP
# 0  10  6  2  gr1
# 1  11  1  3  gr2
# 2  12  8  4  gr1
# 3  13  5  5  gr3
# 4  14  3  6  gr1
# 5  15  8  7  gr2
# 6  16  9  8  gr3

my_df = pd.DataFrame({'A':range(10, 17), # Constructing a pandas DataFrame 'B':[6, 1, 8, 5, 3, 8, 9], 'C':range(2, 9), 'GRP':['gr1', 'gr2', 'gr1', 'gr3', 'gr1', 'gr2', 'gr3']}) print(my_df) # A B C GRP # 0 10 6 2 gr1 # 1 11 1 3 gr2 # 2 12 8 4 gr1 # 3 13 5 5 gr3 # 4 14 3 6 gr1 # 5 15 8 7 gr2 # 6 16 9 8 gr3

print(my_df.sum())                          # Computing the sum of all columns
# A                         91
# B                         40
# C                         35
# GRP    gr1gr2gr1gr3gr1gr2gr3
# dtype: object

print(my_df.sum()) # Computing the sum of all columns # A 91 # B 40 # C 35 # GRP gr1gr2gr1gr3gr1gr2gr3 # dtype: object

print(my_df.groupby('GRP').sum())           # Computing the column sums by group
#       A   B   C
# GRP            
# gr1  36  17  12
# gr2  26   9  10
# gr3  29  14  13

print(my_df.groupby('GRP').sum()) # Computing the column sums by group # A B C # GRP # gr1 36 17 12 # gr2 26 9 10 # gr3 29 14 13

print(my_df.sum(axis = 1))                  # Computing the sum of all rows
# 0    18
# 1    15
# 2    24
# 3    23
# 4    23
# 5    30
# 6    33
# dtype: int64

print(my_df.sum(axis = 1)) # Computing the sum of all rows # 0 18 # 1 15 # 2 24 # 3 23 # 4 23 # 5 30 # 6 33 # dtype: int64