Guest User

Untitled

a guest
Jan 21st, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. import datetime
  2. import pandas as pd
  3. import numpy as np
  4.  
  5. dates = pd.date_range(datetime.datetime(2012, 4, 5, 11,
  6. 0),datetime.datetime(2012, 4, 7, 7, 0),freq='5H')
  7.  
  8. var1 = np.random.sample(dates.size) * 10.0
  9. var2 = np.random.sample(dates.size) * 10.0
  10. df = pd.DataFrame(data={'var1': var1, 'var2': var2}, index=dates)
  11.  
  12. df1=df.resample('D').mean()
  13.  
  14. count
  15. 3
  16. 5
  17. 7
  18.  
  19. df1=df.resample('D').agg(['mean','count'])
  20. print (df1)
  21. var1 var2
  22. mean count mean count
  23. 2012-04-05 3.992166 3 4.968410 3
  24. 2012-04-06 6.843105 5 6.193568 5
  25. 2012-04-07 4.568436 1 3.135089 1
Add Comment
Please, Sign In to add comment