For my application to the Data School, I created a Tableau viz using publicly available data from Citi Bike. Working on this project led me to some interesting findings which I'd like to share.
Firstly, I discovered that Citi Bike changed what data they released over the years. Up until February 2020 and they included ridership demographics (age and gender) in their dataset. From March 2020 onward these demographics stats have been excluded. For this reason I focused on February 2020 for my project.
One finding that jumped out at me was the gender breakdown: nearly 80% riders are male. I filtered my map of Citi Bike docks to look for neighborhood trends. The neighborhood with the least female ridership, around 10%, was Midtown Manhattan, while the only neighborhoods with above 30% female ridership were in northern Brooklyn. I'd imagine the Midtown riders were mostly office works commuting.
The average rider age was 39 years old, but this also varied by neighborhood. Central Park had the oldest riders, averaging 47 years old, while the youngest riders averaging 33 years old were in Bushwick, Brooklyn. I'd imagine the Central Park riders were mostly people biking for leisure.
Systemwide, the average trip duration was about 8 and a half minutes and under 1 mile. As you might expect, the departure neighborhood with the longest average rides by both time and duration was also one of the furthest from Manhattan in Sunset Park, Brooklyn (25 minutes and nearly 2 miles).
Monday through Friday, peak times were at 8am and 5pm, suggesting that many riders are using Citi Bike to get to and from work during the week. On Saturdays and Sundays we see the most rides between 1pm and 3pm, suggesting there are more leisure riders out on the weekends.
Explore the viz for yourself at https://public.tableau.com/app/profile/alan.grunberg/viz/OneMonthofCitiBikeRevised/Dashboard3 and see what interesting stats you can find!
