CITI Bike Trip Data Analysis - Insights and Observations

Preliminary, time series, spatial, modeling, and safety analyses were conducted on CITI Bike trip data from 2013 to 2016. The data quality assessment led to the removal of outliers. Key observations include an increasing number of bike trips with a seasonal pattern, hot spots located in specific areas, territory analysis showing trip duration and frequency patterns within boroughs, and modeling analysis revealing trends by user demographics.

• Data Analysis
• CITI Bike
• Insights
• Observations
• Modeling

pnua Follow

Uploaded on Nov 20, 2024 | 0 Views

Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

Presentation Transcript

1. CITI Bike Trip Data Analysis CITI Bike Trip Data Analysis Team: SunnyBike Shefang Wang Chenhui Liu Tongge Huang

2. Summary Summary Outline: Preliminary Analysis Time Serious Analysis Spatial Analysis Modeling Analysis Safety Analysis Tools: Data:

3. Data Quality Data Quality Data from 2013/07 ~ 2016/09 # of rows 33,319,019 Two type of users Customer: within 30 mins Subscribers: within 45 mins Outliers to remove. ~3%

4. Preliminary Data Analysis Preliminary Data Analysis

5. Time Serious Analysis Time Serious Analysis Observations: Number of bike trips is increasing Seasonal pattern Peaks at Summer Lows at Winter

6. Spatial Analysis Spatial Analysis Hot Spots (Top 10) Analysis Hot Spots (Top 10) Analysis 2014 2013 2015 2016

7. Spatial Analysis Spatial Analysis Hot Spots (Top 10) Analysis Hot Spots (Top 10) Analysis Observations: Hot Spots are located at midtown Tech companies, SoHo shopping areas, 5th ave, etc. Wall Street financial districts

8. Territory Analysis Territory Analysis Trip Duration Trip Duration Observations: Within Borough takes lest time Queens to/from: Manhattan > Brooklyn > Queens

9. Territory Analysis Territory Analysis Trip Frequency Trip Frequency Observations: Most of trips were travelled within the borough # of trips ranking: Manhattan > Brooklyn > Queens

10. Modeling Analysis Modeling Analysis Observations: Trips duration is decreasing, since the # of bike station is increasing Male > Female Weekday > Weekend Summer > Winter Subscribed user > Short term Customer user Older people tend to ride longer

11. Safety Analysis Safety Analysis Observations: The # of Trips is increasing, whereas the # of bike accident is decreasing Therefore, CITI bike implementation does not jeopardized roadway bike safety

12. Thanks! Thanks!