python cumulative sum code example

Example 1: cumulative sum in python

import pandas as pd
import numpy as np
  
# Create a dataframe
df1 = pd.DataFrame({"A":[None, 3, 8, 14], 
                   "B":[1, None, 4, 3], 
                   "C":[5, 3, 9,None]}) 
  
# Computing sum over Index axis
print(df1.cumsum(axis = 0, skipna = True))
#skipna exclude null values

Example 2: numpy element sum privous

>>> a
array([[1, 2, 3],
       [4, 5, 6]])
       
>>> np.cumsum(a,axis=0)      # sum over rows for each of the 3 columns
array([[1, 2, 3],
       [5, 7, 9]])
>>> np.cumsum(a,axis=1)      # sum over columns for each of the 2 rows
array([[ 1,  3,  6],
       [ 4,  9, 15]])