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 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.