Guest User

Untitled

a guest
Nov 19th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. data1={'Policy Number':['FSH1235456','FSH7643643','CHH123124','CHH123145252','CHH124124'],'State':['FL','TX','GA','TX','TX'],'TERR':[1,2,3,4,5]}
  2.  
  3. data2={'TERR':[1,2,3,4,5],'CHH':[0,.15,.65,.35,.20],'FSH':[0,.15,.25,.35,.20]}
  4.  
  5. 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]}
  6.  
  7.  
  8. df1=pd.DataFrame(data1)
  9.  
  10. df2=pd.DataFrame(data2)
  11.  
  12. df3=pd.DataFrame(output)
  13.  
  14. if df1.State.any()=="TX":
  15. if df1["Policy Number"].str.contains("FSH").any():
  16. for i in df["TERR"]:
  17. df1['% TERR']=df2.loc[[i],["FSH"]]
  18.  
  19. print(df2.loc[[i],["FSH"]]
Add Comment
Please, Sign In to add comment