Hubway Half a Million Trip Data

Here's my submission to the Hubway Data Visualization Challenge. Please vote: http://hubwaydatachallenge.org/submission/37/

Transcript

1. Registered user age between 17 and 80 HUBWAY TRIP DATA Hubway Data Visualization Challenge 2012 Female Male 95 stations 552,073 trips in 431 days 30,546,812 station status updates 25% of registered users are Female Average Trip Duration 28 minutes 20000 40000 60000 80000 100000 120000 17 24 31 38 45 52 59 66 73 80 User Age Number of User 64% trips by registered users Registered Casual Saturday Friday Thursday Wednesday Tuesday Monday Sunday 37 30 22 21 19 37 42 Average Trip Duration by Day, in Minutes 0 5 10 15 20 25 30 35 40 11pm 10pm 9pm 8pm 7pm 6pm 5pm 4pm 3pm 2pm 1pm 12pm 11am 10am 9am 8am 7am 6am 5am 4am 3am 2am 1am 12am Time of the Day User Average Age Average User Age by Trip Starting Time Average night owls are below 30 years old Hubway Users in the U.S. 350,762 0 Average age: 36 Where do the users come from? Hubway Users in Massachusetts 0 100 1,000 10,000 53,470 Cumulative Trips based on Zip Codes Bicycles Are Everywhere Users are from everywhere, and centralized around Boston 02134 02218 02114 02113 02115 02116 02215 Top preferred places to live 0 1000 2000 3000 Aug. Sep. O ct. N ov. D ec. 0 1000 2000 3000 Number of Trips Date 0 1000 2000 3000 2011 Jan. 2012 Feb. M ar. Apr. M ay Jun. 2012 Jul. Aug. Sep. O ct. Day Trips Night Trips Overall Trip Count per Day Basis July 28, 2011 -- October 1, 2012 1st 2011 2012 Spring Summer Fall Winter Day Night Day trips are always more popular Especially in the Summer Business has grown a lot in 2012 Station Trip Count per Day Basis July 28, 2011 -- October 1, 2012 Top 3 Most Popular Stations 1 2 3 South Station TD Garden Boston Public Library Top 3 Stations by Number of Trips have huge potentials among the newly established stations Harvard Square @ Mass Ave MIT Mass Ave In addition, + Cumulative Trips based on Zip Codes UMass Boston JFK / UMASS overall receive the fewest customers. & However, they are both new. Give them more time to catch up. New Balance - 38 Guest St. station A real bad performer is the 1148 trips in 429 days = Well below the average of 20 trips/day per station Less than 3 trips/day Station Location versus Median Household Income Top and bottom performed stations are NOT correlated with median household income. Beibei Yang 2012 byang1@cs.uml.edu Based on the Hubway Trip history Data. Made for the Hubway Data Visualization Challenge.