Advertisement
Guest User

Untitled

a guest
Jul 17th, 2019
227
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. ranks = pd.read_csv("/tmp_file.csv")
  2. print(ranks)
  3. mask=(ranks["Date/Time"] > pd.Timestamp(start_time)) & (ranks["Date/Time"] < pd.Timestamp(end_time)) & (ranks["Op/sc"]>100)
  4. df = ranks.loc[mask]
  5. print(df)
  6. df.replace(regex=r'2019.*$', value='2018', inplace=True)
  7. print(df)
  8.  
  9. Date/Time Rank Op/sc
  10. 0 2019-03-18 03:07:57 0 6
  11. 1 2019-03-18 03:08:12 0 5
  12. 2 2019-03-18 03:08:27 0 4
  13. 3 2019-03-18 03:08:42 0 4
  14. 4 2019-03-18 03:08:57 0 7
  15.  
  16. Date/Time Rank Op/sc
  17. 25 2019-03-18 03:14:12 0 160
  18. 26 2019-03-18 03:14:27 0 103
  19. 27 2019-03-18 03:14:42 0 129
  20. 32 2019-03-18 03:15:57 0 119
  21.  
  22. Date/Time Rank Op/sc
  23. 25 2019-03-18 03:14:12 0 160
  24. 26 2019-03-18 03:14:27 0 103
  25. 27 2019-03-18 03:14:42 0 129
  26. 32 2019-03-18 03:15:57 0 119
  27.  
  28. ranks = pd.read_csv("/tmp_file.csv", parse_dates=['Date/Time'])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement