Advertisement
Guest User

Untitled

a guest
Sep 2nd, 2014
169
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. days = []
  2. df = turnstile_weather
  3.  
  4. def day(date):
  5. return datetime.strftime(datetime.strptime(date,'%Y-%m-%d').date(),'%a')
  6.  
  7. for date in turnstile_weather['DATEn']:
  8. days.append(day(date))
  9.  
  10. df['Days'] = days
  11. df['UNIT_int'] = df['UNIT'].str.strip('R').astype(int)
  12. grouping = df.groupby(['UNIT_int', 'Days']).sum()
  13. print grouping
  14. #group = pandas.melt(grouping, id_vars = 'UNIT', value_name = 'ENTRIESn_hourly', var_name = 'Day')
  15. plot = ggplot(grouping, aes('UNIT_int', 'ENTRIESn_hourly',
  16. colour='day_week')) + \
  17. geom_point(alpha=.1) + \
  18. ggtitle('Subway Ridership for Days of the Week') + \
  19. xlab('UNIT Number') + \
  20. ylab('Entries Per Hour')
  21. return plot
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement