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
2024-01-01 to 2025-10-31
Peak Hour
5 PM
47,217 trips
Median Trip
9.4 min
Typical ride duration
Longest Distance
12.57 mi
5 Ave & 67 St →
Broadway & W 122 St
Broadway & W 122 St
Historical Analysis
Comprehensive analysis of 529,093 trips from 2024-01-01 to 2025-10-31.
- Temporal patterns (hourly, daily, seasonal)
- User behavior (members vs casual riders)
- Peak usage times and commute patterns
- Bike type preferences (classic vs electric)
Live Station Status
Real-time availability data for all 7 Columbia area stations, updated every 3 minutes.
- Current bike availability (classic & e-bike)
- Available docking spaces
- Interactive map visualization
- Station status indicators
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
Methodology
Data Source: Citi Bike System Data (publicly available monthly CSV files)
Data Processing: Filtered 529,908 trips where either start or end station is within the Columbia University area. Removed anomalies and incorrect data.
Analysis Tools: Python (pandas, plotly), Jupyter notebooks for exploratory analysis, Next.js/React for web visualization
Time Period: 2024-01-01 to 2025-10-31 (670 days)
View Detailed Methodology →