top of page
Mobile Dashboard - High Duration TTC Delays
Last Update: March 6th, 2020.
Tableau Dashboard
1) Project Goal
Project Goal
-
Design and create a mobile-optimized dashboard that tracks high-duration ( > 30 minutes) TTC delays.
2) Data Source & Preparation
Data Preparation
Data Sources
-
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.
Data Preparation
-
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.
bottom of page