Process of Exploring Citibike Data

Page 1

Citibike Data Findings Wanting Yu


Issues around citibike

Problems around Citibike ·∙ Inventory problems ·∙ Pricing Strategy ·∙ Coverage ·∙ Ciability/ Insurance (safety) ·∙ $3.6M city costs ·∙ Weather/Seasonality ·∙ Docking/ Technology ·∙ Knowledge gap ·∙ Corp Finance structure-­‐ impacts program. ·∙ Membership citibikes


Data variables The data includes: o Trip Duration (seconds) o Start Time and Date o Stop Time and Date o Start Station Name o End Station Name o Station ID o Station Lat/Long o Bike ID o User Type (Customer = 24-­‐hour pass or 7-­‐day pass user; Subscriber = Annual Member) o Gender (Zero=unknown; 1=male; 2=female) o Year of Birth


Male 76.3% v.s Female 23.7% According to Citi Bike’s public data, men are riding more – far more – than women, averaging 3 times more rides. Of subscriber-­‐ based rides in January through July 2014, men took 76.3% of all trips, and women 23.7%. What is the cause of this disparity, and how can it be resolved?


Gender How To Ride A Bike In A Dress/skirt Without Flashing Your Underwear?


Live Station Feed Data Live data is only available in JSON format


ConvertCSV.com Converted JSON to CSV.







Safety Women typically attribute reduced cycling numbers to safety among car traffic, and considering Citi Bike’s distribution across some of the most congested parts of Manhattan and Brooklyn, lower female participation makes sense.


Female v.s Male ridership

http://cdb.io/1blEfF5


NYPD Motor Vehicle Collisions



Do women attribute reduced cycling numbers to safety among car traffic? Further analysis of the gender divide by bike share station shows that bike stations in Manhattan are predominantly used by men, while Brooklyn are more proportionately popular among women. Of the top ten areas for each gender, women preferred the Brooklyn residential neighborhoods of Fort Greene and Clinton Hill, while men were overwhelmingly represented in bustling midtown Manhattan. Women also chose areas with fewer lanes of traffic, more limited truck traffic, fewer collision-­‐based cyclist injuries in recent memory, and in some cases, fast access to bridge entrances; men most often chose areas with more traffic, some truck traffic, some collision-­‐based cyclist injuries, and, typically, connectivity to major transit hubs.









Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.