vivekagrawl / work-fatality-study

Work-Related Fatality Study: An In-depth Analysis using Python and MySQL

In this project, I worked on a real-world dataset to analyze fatal incidents that occurred in various workplaces. My goal was to clean the dataset, analyze the given dataset, and mine informational insights using Python and MySQL.

Project Description

The Work-Related Fatality Study was a comprehensive analysis of fatal incidents that occurred in various workplaces. The project aimed to examine and understand the factors contributing to work-related fatalities, identify trends and patterns, and provide insights to improve workplace safety measures.

Module 1: Data Pre-processing using Python

Task 1: Reading the data from csv

Task 2: Cleaning the dataset

Task 3: Exporting the cleaned dataset

Task 4: Generate tables using the cleaned dataset

Module 2: Analyzing Data using MYSQL

Task 1: What is the number of reported incidents?

Task 2: What is the year to year change for the number of fatal incidents?

Task 3: What is the number of fatalities that received a citation?

Task 4: What day of the week has the most fatalities and what is the overall percentage?

Task 5: What is the number of fatalities involving welding?

Task 6: Select the last 5 from the previous query: The task is to calculates the last 5 fatalities during welding.

Task 7: Select the top 5 states with the most fatal incidents.

Task 8: What are the top 5 states that had the most workplace fatalities from stabbings?

Task 9: What are the top 10 states that had the most workplace fatalities from shootings?

Task 10: What is the total number of shooting deaths per year?