Pandas Complex Calculation Based On Other Columns

I have successfully created new columns based on arithmetic for other columns but now I have a more challenging need to first select elements based on matches of multiple columns t

Solution 1:

You could maybe use a rolling window. Something like this:

ind_df_qtrly['cumulative_tot_revnu'] = ind_df_qtrly['tot_revnu'].rolling(4).sum()

Documentation: pandas.DataFrame.rolling