Toronto Transit Commission (TTC) Subway Delays

Team Members:

• Nadia Iskandar
• Ivy Fong
• Shaohua Liu
• Jennifer Huynh

Project Description/Outline:

We will create an interactive dashboard to display TTC subway delay 2018 and 2019 data. Our dashboard will contain the following information:

1. Leaflet Map
   • Map of Toronto and TTC subway stations
   • Popups (on hover) displaying the name of the subway station, total number of delays in 2019, average delay time in 2019, total number of delays in 2018, and average delay time in 2018
2. Predictions
   • Dropdown filters: Subway line, station, direction, month, day of the week, and hour
   • Average delay time
   • Average wait time
3. Tableau Dashboard
   • Key facts about the TTC
   • Analysis of subway delays by hour, day of the week, and month
   • Analysis of subway delays by reason

Tools:

We will use the following:

1. Python - Pandas, SQLAlchemy, Flask
2. AWS PostgreSQL
3. HTML/CSS
4. JavaScript - Leaflet, D3
5. Tableau
6. Heroku

Data Sources:

1. City of Toronto Open Data - TTC monthly subway delay data: https://open.toronto.ca/dataset/ttc-subway-delay-data/
2. Wikipedia (multiple web pages) - TTC subway station coordinates (e.g. Bloor-Yonge station: https://en.wikipedia.org/wiki/Bloor%E2%80%93Yonge_station)
3. TTC Operating Statistics: https://www.ttc.ca/About_the_TTC/Operating_Statistics/2018/index.jsp

Screenshot: