About

This canvas performs a comprehensive transit route performance analysis for Mountain Line's Flagstaff bus system, using data cleaning, exploratory data analysis, and linear regression to identify underperforming routes (those generating fewer riders than their operational investment suggests) versus extension candidates (routes delivering strong ridership relative to operational cost). The workflow loads 2025 service statistics, cleans and standardizes route data, computes efficiency metrics like deadhead ratios and trips-per-revenue-hour, builds a predictive model, and visualizes the performance gaps to inform strategic service decisions.