Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- data1={'Policy Number':['FSH1235456','FSH7643643','CHH123124','CHH123145252','CHH124124'],'State':['FL','TX','GA','TX','TX'],'TERR':[1,2,3,4,5]}
- data2={'TERR':[1,2,3,4,5],'CHH':[0,.15,.65,.35,.20],'FSH':[0,.15,.25,.35,.20]}
- output={'Policy Number':['FSH1235456','FSH7643643','CHH123124','CHH123145252','CHH124124'],'State':['FL','TX','GA','TX','TX'],'TERR':[1,2,3,4,5],'Test':[0,.15,0,0,0]}
- df1=pd.DataFrame(data1)
- df2=pd.DataFrame(data2)
- df3=pd.DataFrame(output)
- if df1.State.any()=="TX":
- if df1["Policy Number"].str.contains("FSH").any():
- for i in df["TERR"]:
- df1['% TERR']=df2.loc[[i],["FSH"]]
- print(df2.loc[[i],["FSH"]]
Add Comment
Please, Sign In to add comment