Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. import numpy as np
  2. import pandas as pd
  3.  
  4.  
  5. data = pd.read_csv('c.csv')
  6. print(data)
  7. data['A'] = data['A'].apply(lambda x: np.nan if x in range(1,10,1) else x)
  8. data['B'] = data['B'].apply(lambda x: np.nan if x in range(10,20,1) else x)
  9. data['C'] = data['C'].apply(lambda x: np.nan if x in range(20,30,1) else x)
  10. print(data)
  11. data = data.dropna()
  12. print(data)
  13.  
  14. A B C
  15. 0 1 10 20
  16. 1 2 11 22
  17. 2 4 15 25
  18. 3 8 20 30
  19. 4 12 25 35
  20. 5 18 40 55
  21. 6 20 45 60
  22.  
  23. A B C
  24. 0 NaN NaN NaN
  25. 1 NaN NaN NaN
  26. 2 NaN NaN NaN
  27. 3 NaN 20.0 30.0
  28. 4 12.0 25.0 35.0
  29. 5 18.0 40.0 55.0
  30. 6 20.0 45.0 60.0
  31.  
  32. A B C
  33. 4 12.0 25.0 35.0
  34. 5 18.0 40.0 55.0
  35. 6 20.0 45.0 60.0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement