Guest User

Untitled

a guest
Jul 17th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.10 KB | None | 0 0
  1. 2002074266 2002074444
  2. TimeStamp Total Freq Total Freq
  3. HH:MM Pc Hz Pc Hz
  4. 06:50 3 10 7 13
  5. 06:55 4 11 8 14
  6. 07:00 5 12 9 15
  7.  
  8. df['TimeStamp'] = pd.to_datetime(df['TimeStamp'])
  9. df = df.set_index('TimeStamp')
  10.  
  11. df = pd.read_csv("Equipment.csv", header=[0,1], skiprows = 3, index_col=0)
  12.  
  13. df = pd.read_csv("Equipment.csv", header=[0,1], skiprows = [2], index_col=0)
  14.  
  15. print (df)
  16. 2002074266 2002074444
  17. Total Freq Total Freq
  18. 06:50 3 10 7 13
  19. 06:55 4 11 8 14
  20. 07:00 5 12 9 15
  21.  
  22. df.index = pd.to_datetime(df.index, format='%H:%M')
  23. df = df.resample('1min').ffill()
  24. print (df)
  25. 2002074266 2002074444
  26. Total Freq Total Freq
  27. 1900-01-01 06:50:00 3 10 7 13
  28. 1900-01-01 06:51:00 3 10 7 13
  29. 1900-01-01 06:52:00 3 10 7 13
  30. 1900-01-01 06:53:00 3 10 7 13
  31. 1900-01-01 06:54:00 3 10 7 13
  32. 1900-01-01 06:55:00 4 11 8 14
  33. 1900-01-01 06:56:00 4 11 8 14
  34. 1900-01-01 06:57:00 4 11 8 14
  35. 1900-01-01 06:58:00 4 11 8 14
  36. 1900-01-01 06:59:00 4 11 8 14
  37. 1900-01-01 07:00:00 5 12 9 15
  38.  
  39. df.index = pd.to_timedelta(df.index + ':00')
  40. df = df.resample('1min').ffill()
  41. print (df)
  42. 2002074266 2002074444
  43. Total Freq Total Freq
  44. 06:50:00 3 10 7 13
  45. 06:51:00 3 10 7 13
  46. 06:52:00 3 10 7 13
  47. 06:53:00 3 10 7 13
  48. 06:54:00 3 10 7 13
  49. 06:55:00 4 11 8 14
  50. 06:56:00 4 11 8 14
  51. 06:57:00 4 11 8 14
  52. 06:58:00 4 11 8 14
  53. 06:59:00 4 11 8 14
  54. 07:00:00 5 12 9 15
Add Comment
Please, Sign In to add comment