I was thinking about the two kinds of cyclists in the data set, customers and subscribers. The former, probably mostly tourists, get an access card for a few days, while the latter have a yearly subscription and presumably cycle regularly. So the subscribers should be in better shape than the customers, right? Let’s find out!
We calculate the pace for a trip between two stations as the duration of a person’s trip, divided by the average time the trip takes.
Unmistakably, subscribers are faster. So they’re better in shape, right? Not necessarily. They might also just know some shortcuts or a customer, likely being a tourist, might enjoy the scenic route between two stations more often. A way to (partially) answer this question is to look at differences within the group of subscribers, for which we know the zip code, and see if there are differences between the zip codes. Locals should know the better shortcuts than outsiders.
Let’s first find out what the fastest zip code is. We want a reasonable number of trips to sample from and a small standard deviation of paces, such that we can make statements with some certainty. This means we have to filter our data.
The good people from Pleasanton (94588) seem to outperform the rest a significant number of times. Do they know a shortcut?
Source: local data frame [5 x 4] Start.Station End.Station Count 1 Steuart at Market 2nd at Townsend 169 2 2nd at Townsend Steuart at Market 138 3 Broadway St at Battery St Market at Sansome 79 4 Market at Sansome 2nd at South Park 79 5 Embarcadero at Sansome Steuart at Market 52 Variables not shown: Average Pace (dbl)
The route between Steuart at Market and 2nd at Townsend is so far from their home, that it’s safe to assume that Pleasantoneans don’t know a particular good short cut. The fastest route (you can convince yourself on google maps) is also the scenic one. However, the relatively large and almost equal number of trips in both directions could mean that one particularly adept cyclist from Pleasanton makes up most of the faster-than-average trips. Whoever you are, keep pushing on!