Mass Shooting Analysis

Crime scene tape

Overview

The number of mass shootings in the United States have been increasing within the last few years. This has been a hot topic amongst news organizations and politicians. This case study was developed to explore the distribution of mass shootings across the United States.

Tools, Skills, Techniques

  • Python
  • Tableau
  • Data Wrangling & Merging
  • Deriving Variables
  • Exploratory Visual Analysis
  • Geospatial Analysis
  • Machine Learning
  • Time-Series Analysis
  • Visualization & Storytelling

The biggest challenge with this project is obtaining a dataset that has all the variables that I wanted to explore. There was so much that I wanted to explore with this project, which I was unable to do due to time constraints. I plan on revising this project to keep it up to date and add additional analysis.

The number of mass shootings in the United States have been increasing within the last few years. This has been a hot topic amongst news organizations and politicians. This case study was developed to explore the distribution of mass shootings across the United States.

Tools, Skills, Techniques

  • Python
  • Tableau
  • Data Wrangling & Merging
  • Deriving Variables
  • Exploratory Visual Analysis
  • Geospatial Analysis
  • Machine Learning
  • Time-Series Analysis
  • Visualization & Storytelling

The biggest challenge with this project is obtaining a dataset that has all the variables that I wanted to explore. There was so much that I wanted to explore with this project, which I was unable to do due to time constraints. I plan on revising this project to keep it up to date and add additional analysis.

Define Key Questions & Goals

Data Collection

The dataset is collected by the Gun Violence Archive (GVA), whose mission is to document incidents of gun violence and gun crime nationally to provide independent, verified data to those who need to use it in their research, advocacy, or writing. The data contains mass shooting incidents within the United States from 2014 to 2023.

Data Cleaning

I started with a dataset for each of the years from 2014 to 2023. These were combined into one dataset as each one had the same number of variables. During the data cleaning process, I removed two variables that were not relevant to the analysis and renamed variables for readability. No duplicate or missing variables found.

Data Analysis

Distribution of mass shootings
Mass shooting incidents by city/county
Number of mass shootings by region
Time-series analysis
No items found.

Interpret Results

Conclusion

  • Illinois, California, and Texas are the top 3 states with the highest mass shootings.
  • Chicago has been the top city with the highest mass shootings since 2014.
  • The Southern region has the highest amount of mass shootings.  

Limitations

  • This data was limited to the number of variables and the time frame. Further insights could be gleaned from the addition of past data and additional suspect variables.

Next Steps

  • As the number of mass shootings continues to increase, further factors should be analyzed. These can include the mental capacity of the suspect, as well as age and race. The dataset will continue to be updated and additional variables will be added to conduct further analysis.

Other Projects

Let's work together!

I’m always looking for ways to solve problems or to exchange ideas. Feel free to send me a message. I aim to respond within one business day. Hope to hear from you!

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.