cumulate ratio pandas code example
Example 1: pandas cumulative sum column
import pandas as pd
from random import randint
df = pd.DataFrame(data=[{'duration': randint(0,3)} for _ in range(5)])
df.head()
# duration
# 0 0
# 1 2
# 2 1
# 3 0
# 4 3
df['cum_dur'] = df.duration.cumsum()
df.head()
# duration cum_dur
# 0 0 0
# 1 2 2
# 2 1 3
# 3 0 3
# 4 3 6
Example 2: cumulative percentaile pandas
df['cum_sum'] = df["val1"].cumsum()
df['cum_perc'] = round(100*df.cum_sum/df["val1"].sum(),2)