[Solved] Forecasting basis the historical figures
You need to join those two dataframes to perform multiplication of two columns. merged_df = segmentallocation.merge(second,on=[‘year’,’month’],how=’left’,suffixes=[”,’_second’]) for c in interested_columns: merged_df[‘allocation’+str(c)] = merged_df[‘%of allocation’+str(c)] * merged_df[c] merged_df year month segment x y z k %of allocationx %of allocationy %of allocationz %of allocationk x_second y_second z_second k_second allocationx allocationy allocationz allocationk 0 2018 FEB A 2094663 … Read more