Work Related Fatality Study

Context

This project is conducted by HiCounselor.

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

On a high level, the following are the steps performed:

• Read the raw data from the .csv file provided.
• Clean the data as per our analysis requirement.
• Create a clean dataset which is ready for our analysis.
• Install and configure MySQL Database server.(Optional – while working on hicounselor’s sandbox machine this step is not required)
• Create the database(schema), user and import the cleaned dataset as a table.(Optional – while working on hicounselor’s sandbox machine this step is not required)
• Perform the analysis. (Done in two methods – using pandas dataframes, SQL queries)