How tobeyfung/780-transit works
This repository is a city-level transportation convenience analysis, not a reusable software service. Its main workflow combines population, transit funding, ridership, and walkability data into a city-year panel, calculates an equally weighted 0–100 score, and compares cities by size, growth, components, and region. The notebook is the analysis runtime; the README documents the findings and intended uses. Relationships below follow the README because no source excerpts were provided, so implementation details beyond that documentation are omitted.
Main entry points: A03-Transportation-Convenience-Across-US cities.ipynb Clean and join data · population_2020.xlsx Population estimates · 2024 TS1.1 Total Funding Time Series.xlsx Transit funding · ridership.xlsx Transit ridership
Components 10
Data inputs
- Population estimates
data/population_2020.xlsx - Transit funding
data/2024 TS1.1 Total Funding Time Series.xlsx - Transit ridership
data/ridership.xlsx - Walkability index
data/2017_2023_walkability_index.csv.zip - Geographic sources
Analysis workflow
- Clean and join data
A03-Transportation-Convenience-Across-US cities.ipynb - Convenience score
A03-Transportation-Convenience-Across-US cities.ipynb - City comparisons
A03-Transportation-Convenience-Across-US cities.ipynb
Results and use
- Findings and charts
A03-Transportation-Convenience-Across-US cities.ipynb
Other components
- Movers and analysts
Connections 9
- Clean and join data → Population estimates: joins population
README.md - Clean and join data → Transit funding: joins funding
README.md - Clean and join data → Transit ridership: joins ridership
README.md - Clean and join data → Walkability index: joins walkability
README.md - Clean and join data → Geographic sources: spatially joins
README.md - Clean and join data → Convenience score: produces panel for
README.md - Convenience score → City comparisons: scores cities for
README.md - City comparisons → Findings and charts: summarizes results
README.md - Findings and charts → Movers and analysts: informs decisions
README.md