MySQL-Project-Data-Cleaning-and-EDA

Hello and thank you for taking a look at my MySQL projects!

What's included

Layoffs CSV file

Original excel master file containing data regarding layoffs by global companies from the years 2021 to 2023.

Data Cleaning with MySQL - Project 1

A data set of company layoffs by global companies from the years 2021 to 2023 has been provided, project objective is to clean the data using MySQL to:

1. Remove any Duplicates

2. Standardise the Data (Removing any spelling mistakes etc.)

3. Removing any Null or Blank Values

4. Removal of any irrelevant columns or rows.

Exploratory Data Analysis (EDA) with MySQL - Project 2

Using the previously cleaned data set, EDA analysis is performed with the aim of gaining new insights based on the data received.