Leeds Cycle
Patterns Analysis
Analysis of ride volumes 2018–23 across 11 recording sites based on 1.2 million data points
& +80% daily completeness over a continuous 6 year period.
Summary
Analysis of ride volumes 2018–23 across 11 recording sites based on 1.2 million data points & +80% daily completeness over a continuous 6 year period.
Key Technologies
Python, Pandas, Tableau, R Studio & Google Sheets & AI tools (Claude) to accelerate workflow by creating python scripts to run locally in R Studio.
Key Findings
- Weekday peak hour is 5-6PM with 361K rides, 613% higher than the weekend peak hour 2-3PM with 51K rides.
- Eight out of eleven recording sites have seen ride volume fully recover post COVID.
- Weekday post COVID ride volume is up 3.7% whilst weekend is up 41.8% compared to pre COVID levels.
Skills Demonstrated
Python data analysis, pandas data manipulation, exploratory data analysis, data visualization, geospatial analysis, time series analysis, and data storytelling.