Mobile Dashboard - High Duration TTC Delays
Last Update: March 6th, 2020.
1) Project Goal
Design and create a mobile-optimized dashboard that tracks high-duration ( > 30 minutes) TTC delays.
2) Data Source & Preparation
Data is from the Toronto Government's Open Data portal: open.toronto.ca.
Month-by-month result .xls files are from the "TTC Subway Delay Data" dataset.
Since the data was spread out over multiple Excel files covering multiple months/years, the files were first checked to determine whether the data structure was consistent for each one.
Then, the Python glob and Pandas libraries were used to go through each file and combine them into a single data source file.
Finally, the data was then imported into Tableau for visualization.