transit-affordability-analysis
sadiegberg/transit-affordability-analysis
Analysis of 71 rides across Armenia, Kazakhstan, Kyrgyzstan, and Uzbekistan: fares, payment methods, and access (Excel + SQL)
transit-analysistransportation-datacost-analysistravel-loggingsql-analysisexcel-analysiscentral-asia
Summary
This repository contains a personal travel analysis project examining transit affordability across Armenia, Kazakhstan, Kyrgyzstan, and Uzbekistan. The author logged 71 rides, recording fare, payment method, duration, and notes. The core analysis was performed in Excel, with SQL queries used for verification and extension. The project explores how cost varies by transport mode, how metro fares compare across cities, the prevalence of cash vs. app payments, and how urban geography (density, sprawl) influences travel duration and cost per minute.