Columbia Citi Bike Analysis
Comprehensive analysis of Citi Bike usage patterns around Columbia University, covering 529,093 trips from 2024-01-01 to 2025-10-31
Total Trips
529,093
Jan 2024 - Oct 2025
Peak Hour
5 PM
47,217 trips
Median Trip
9.4 min
Typical ride duration
Member Rides
82%
vs 18% casual
Historical Analysis
Comprehensive analysis of 529,093 trips from Jan 2024 to Oct 2025, exploring usage patterns and trends.
- Temporal patterns (hourly, daily, seasonal)
- User behavior (members vs casual riders)
- Peak usage times and commute patterns
- Bike type preferences (classic vs electric)
Demand Forecasting
XGBoost model predicting hourly bike demand for proactive station rebalancing and operational planning.
- R² = 0.722, MAE = 1.63 departures/hour
- 27 engineered features
- Academic calendar and temporal patterns
- Enables proactive rebalancing strategies
Live Station Status
Real-time availability data for all 7 Columbia area stations, updated every 3 minutes with interactive maps.
- Current bike availability (classic & e-bike)
- Available docking spaces
- Interactive map visualization
- Station status indicators
Methodology
Comprehensive data analysis using Citi Bike System Data from Jan 2024 to Oct 2025, analyzing station usage and rider behavior.
- 529,908 trips filtered for Columbia area
- Python (pandas, plotly) for analysis
- Next.js/React for visualization
- Jupyter notebooks for exploration
Columbia University Stations
• Broadway & W 122 St
• Morningside Dr & Amsterdam Ave
• W 120 St & Claremont Ave
• Amsterdam Ave & W 119 St
• W 116 St & Broadway
• W 116 St & Amsterdam Ave
• W 113 St & Broadway