Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.41 KB | None | 0 0
  1. dataset = pd.read_csv('n.csv')
  2. data= pd.DataFrame(dataset,columns= ['date','time','temperature','humidity','wind'])
  3. data['time'] = pd.to_timedelta(data['time'])
  4. data['time'] -= data.at[0, 'time']
  5. data['time'] = data['time'].dt.total_seconds()
  6. data['time']= pd.to_datetime(data['time'], unit='s')
  7.  
  8. data = (data.set_index('time')
  9. .resample('60T').first()
  10. .reset_index()
  11. .reindex(columns=data.columns))
  12. data['time'] = data['time'].astype(np.int64) // 10**9
  13.  
  14. print(data)
  15.  
  16. date time temperature humidity wind
  17. 0 10/3/2018 0 63 0 0
  18. 1 10/3/2018 3600 63 0 2
  19. 2 10/3/2018 7200 104 11 0
  20. 3 10/3/2018 10800 93 0 50
  21. 4 10/3/2018 14400 177 0 2
  22. 5 10/3/2018 18000 133 0 0
  23. 6 10/3/2018 21600 70 0 0
  24. 7 10/4/2018 25200 210 50 20
  25. 8 10/5/2018 28800 170 20 40
  26. 9 10/3/2018 32400 127 0 50
  27. 10 10/3/2018 36000 205 0 0
  28. 11 10/3/2018 39600 298 0 0
  29. 12 10/3/2018 43200 234 0 0
  30. 13 10/3/2018 46800 148 0 20
  31. 14 10/3/2018 50400 135 0 0
  32. 15 10/3/2018 54000 100 0 50
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement