Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- amount_of_insurance=pd.merge(data_for_rater["Enter Amount of Insurance"],
- df['Amount of Insurance'],
- how='left',
- left_on='Enter Amount of Insurance' ,
- right_on='Amount Of Insurance')
- concat_df=pd.concat([amount_of_insurance_df,data_territory],axis=1,sort=False)
- prod_concat=concat_df.groupby(level=0,axis=1).prod()
- input_data={'Group':[1,2,3,4,5],'Amount of Insurance':[28000,28000,28000,28000,28000],'Territory':[701,702,703,704,705]}
- data_amount_of_insurance={'Amount of Insurance':[28000,28000,28000,28000,28000],'Fire':[.10,.20,.30,.40,.50],'Water Weather':[.20,.30,.40,.50,.60]}
- data_territory={'Territory':[701,702,703,704,705],'Fire':[.94,.95,.96,.97,.98],'Water Weather':[.30,.40,.50,.60,.70]}
- input_df=pd.DataFrame(input_data)
- amount_of_insurance_df=pd.DataFrame(data_amount_of_insurance)
- territory_df=pd.DataFrame(data_territory)
- premium_output_data={'Group':[1,2,3,4,5],'Amount of Insurance':[28000,28000,28000,28000,28000],'Territory':[701,702,703,704,705],'Fire Premium':[0.094,0.19,0.288,0.388,0.49],'Water Weather Premium':[0.06,0.12,0.2,0.3,0.42],'Total Premium':[0.154,0.31,0.488,0.688,0.91]}
- premium_output_df=pd.DataFrame(premium_output_data)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement