Advertisement
Guest User

Untitled

a guest
Jun 27th, 2019
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. df = df.set_index('timestamp')
  2. print(df.head())
  3.  
  4. timestamp id value
  5. 2018-12-31 23:00:00 5c8fea84763aae175afda38b 98.587768
  6. 2018-12-31 23:10:00 5c8fea84763aae175afda38b 107.232742
  7. 2018-12-31 23:20:00 5c8fea84763aae175afda38b 104.224153
  8. 2018-12-31 23:30:00 5c8fea84763aae175afda38b 104.090750
  9. 2018-12-31 23:40:00 5c8fea84763aae175afda38b 99.357023
  10.  
  11. df = df.resample('D').agg(['min', 'max', 'mean'], columns=['value'])
  12.  
  13. timestamp min max mean
  14. 2018-12-31 98.587768 107.641060 103.522250
  15. 2019-01-01 88.396180 109.506622 100.135128
  16. 2019-01-02 85.857570 112.420754 99.839120
  17. 2019-01-03 87.565014 113.419561 99.734654
  18. 2019-01-04 88.902704 112.186989 99.764259
  19.  
  20. df.resample('D').agg({'id': 'first', 'value': ['mean', 'max']})
  21.  
  22. id value
  23. first mean max
  24. timestamp
  25. 2018-12-31 5c8fea84763aae175afda38b 102.698487 107.232742
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement