Guest User

Untitled

a guest
Dec 4th, 2017
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. df1
  2.  
  3. EW WE DA dd AA
  4. 0 cheese fdwa waddcv 21.0 NaN
  5. 1 cheese dwadwad dwad 231.0 NaN
  6. 2 cheese dwa waddcv 3.0 NaN
  7.  
  8. df2
  9.  
  10. AD FA BA DA daw
  11. 0 Cheese 1.0 300.0 T T
  12. 1 dwadaw 3.0 400.0 21 31232
  13.  
  14.  
  15. df3 = df2[['AD', 'FA']].copy()
  16. print('FA')
  17.  
  18. time.sleep(1)
  19. df3.FA=np.where(df2.AD.isin(df1.EW),df3.FA,np.nan)
  20. print (df3)
  21.  
  22. I get:
  23.  
  24. AD FA
  25. 0 Cheese NaN
  26. 1 dwadaw NaN
  27. 2 NaN 4.0
  28. 3 NaN 5.0
  29. 4 NaN NaN
  30. 5 NaN NaN
  31. 6 NaN NaN
  32. 7 NaN NaN
  33. 8 NaN NaN
  34. 9 NaN NaN
  35.  
  36. When I want:
  37. AD FA
  38. 0 Cheese 1
Advertisement
Add Comment
Please, Sign In to add comment