Rear View Mirror
  • About
  • How to Use the Application
  • Download and Install
  • Team Roles
  • Data
  • Findings
  • Weekly Update
  • Q&A

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.
Picture
Powered by Create your own unique website with customizable templates.