Lesson 1 of 0
In Progress

Challenge 9: US Accidents

Kedeisha May 22, 2023

Those who submit an entry will be eligible to win a free copy of any book related to data analysis by Packt! The more weeks you participate, the more chances you get to win!

There is no deadline for submission.


You are a data analyst and you have been tasked with summarizing data about accidents in the United States. Your manager would like the following questions answered.

Get the Data

Download dataset here.

Read in the data


  1. Is there any missing data? If so, visualize it in a plot.
  2. Remove any columns that you may find not useful for your analysis.
  3. Plot the top 10 cities with the most accidents.
  4. Plot the distribution of the start time.
  5. Is the distribution of accidents by hour the same on weekends as on weekdays?
  6. What is the distribution of start time on Sundays?
  7. Create a geographical plot to show accidents across a map of the United States.
  8. Among the top 100 cities in number of accidents, which states do they belong to most frequently?
  9. Which months have the most accidents?
  10. What is the trend of accidents year over year (decreasing/increasing?)
  11. Is the state of New York in the data?
  12. Come up with your own question and answer it
  13. Create a dashboard or application to showcase your insights!

Submission Instructions

Place a comment below the post with your submission, then make a LinkedIn or twitter post with a screenshot or PDF of your answers. You can explain your thought process if you’d like. Just make sure to tag the Data in Motion LLC LinkedIn page or Twitter page.