Advertisement
Guest User

Untitled

a guest
Nov 2nd, 2016
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. from datetime import datetime
  2. import pandas as pd
  3.  
  4. def same_day(date_string):
  5. return datetime.strptime(date_string, "%m/%d/%Y %H:%M:%S").strftime('%m-%d')
  6.  
  7. df = pd.read_csv('/home/kk/Desktop/JUHU sit.csv', index_col=[0],parse_dates=[0], usecols=[0,1,2])
  8. ********calculate per day
  9. print (df.index.strftime('%d%m%H'))
  10. print (df.groupby([df.index.strftime('%d%m%H')]).mean())
  11.  
  12. #****** exporting in CSV format
  13. df.reset_index().to_csv('/home/kk/Desktop/JUHUAvg.csv')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement