From Raw Data to Processed Data
The data for the project is from Fatality Analysis Reporting System.
We decided which attributes to select (most of them), then downloaded the data for each year in excel and cleaned it. It took a while to fix all the problems in the original data, values were different during years and other problems..
Data was then imported in MySQL and optimized to work efficiently. By aggregating rows we managed to work on single crashes (and not vehicles and events) with aggregate columns.
We decided which attributes to select (most of them), then downloaded the data for each year in excel and cleaned it. It took a while to fix all the problems in the original data, values were different during years and other problems..
Data was then imported in MySQL and optimized to work efficiently. By aggregating rows we managed to work on single crashes (and not vehicles and events) with aggregate columns.