🚦 Ottawa Traffic Accidents
Combined Ottawa traffic collision data with environment Canada's hourly weather data in order to create a data warehouse. Then, we explored the interplay between weather and traffic accidents, assessing various trends.
Introduction
This project was completed for CSI4142 (Introduction to Data Science) in a team of 2.
The City of Ottawa maintains details of traffic accidents in their open data portal
As well, Environment Canada maintains information about the hourly weather reports across Canada.
We want to create an integrated data mart in order to study the interplay between the weather and traffic accidents.
Data Staging
Before we can do analysis, we must stage the data.
High level data staging plan.
Analysis
