Guest User

Untitled

a guest
Feb 24th, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. df = pd.read_csv("Data.csv")
  2.  
  3. df['DATE'] = pd.DatetimeIndex(df['DATE'], format='%M/%D/%Y')
  4.  
  5. df['Year'] = df['DATE'].dt.year
  6. df['Month'] = df['DATE'].dt.month
  7. df['Day'] = df['DATE'].dt.day
  8.  
  9. (df
  10. .assign(MONTH=df['DATE'].dt.strftime('(%m) %B (%y)'))
  11. .groupby(['NAME', 'MONTH', 'Year'], as_index=False)['SNOW']
  12. .agg({'AVERAGE': 'mean'})
  13. )
  14.  
  15. if 'Year' == '2016':
  16. df = pd.to_csv('average2016.csv', index=False)
  17. else:
  18. df = pd.to_csv('average2017.csv', index=False)
  19.  
  20. if df.loc[df['Year'] == 2016]:
  21. df = pd.to_csv('average2016.csv', index=False)
  22.  
  23. else:
  24. df = pd.to_csv('average2017.csv', index=False)
  25.  
  26. df = pd.Series(['1/1/2016'])
  27.  
  28. if df.item():
Add Comment
Please, Sign In to add comment