NATIONAL HIGHWAY TRAFFIC SAFETY ADMINISTRATION

Project 1 From Refocus

PROBLEM

The problem with this project is the high level of traffic accidents on the roads in every region and city.

GOAL

The goal of this project is to reduce the number of traffic accidents in the regions and cities.

Some questions that can be used as a reference are as follows:

1. Factors that increase accidents
2. Top 10 states with the highest number of accidents
3. Average number of accidents per day based on the time of the day
4. Percentage of accidents caused by drunk driving
5. Percentage of accidents in rural and urban areas
6. Number of accidents based on the day of the week

PROCESS

Before processing the data in PostgreSQL, the first and most important thing to do is to convert the time according to the time zone of each state.

Read More