how to sum columns in python code example

Example 1: python how to sum columns of an array

# Example usage 1:
import numpy as np
numpy_array = np.array([[1, 2, 3, 4, 5], 
                        [1, 2, 3, 4, 5],
                        [1, 2, 3, 4, 5]])
np.sum(numpy_array, axis=0)
--> array([ 3,  6,  9, 12, 15])

# Example usage 2 (without numpy):
array = [[1, 2, 3, 4, 5],
         [1, 2, 3, 4, 5],
         [1, 2, 3, 4, 5]]
[sum(x) for x in zip(*array)]
--> [3, 6, 9, 12, 15]

Example 2: sum of a column in pandas

Total = df['MyColumn'].sum()
print (Total)
319

Example 3: python column = sum of list of columns

list_of_my_columns = ['Col A', 'Col E', 'Col Z']
df['Sum'] = df[list_of_my_columns].sum(axis=1)

Tags:

Misc Example