This repository contains .ipynb file of an analysis of the MBTA's Green B line service and its level of consistency using BigQuery.
Barrett Ratzlaff, Divyesh Sai Annavarapu, Emre Can Baykurt, Kathy Xu, Phunsok Norboo
We investigate first an overview of the MBTA light rail/subway system and measure it's reliability/consistency via the headway metric. After that, we focused on the Green B line and tried to identify "problem stations". We then performed a calculation to get a sense of how headway changed from station to station. This led to us noting that the stations with the most inconsistent headway tended to be at intersections that were abnormally structured, affecting traffic and the train's speed.
https://public.tableau.com/app/profile/barrett.ratzlaff/viz/MBTAHeadwayDashboard/EDADashboard?publish=yes https://public.tableau.com/app/profile/barrett.ratzlaff/viz/Green-BLineConsistencyDashboard/ConsistencyofGreenBLineServicein2024?publish=yes
This project uses the MIT license, people are free to work on the file and contribute. The file is not a finished product, and it would be interesting to see what insights others can identify.