Exploratory Data Analysis and Data Cleaning

Installation

This project does not require any installation. The code can be run directly in a SQL environment.

Usage

The code provided in the Exploratory Data Analysis and Data Cleaning files can be used to perform the following tasks:

1. Exploratory Data Analysis:

   • Find the maximum and minimum number of people laid off
   • Identify companies that laid off all their employees
   • Explore the total people laid off from each country
   • Rank countries based on the number of people laid off
   • Determine the period in which the layoffs occurred
   • Explore the total people laid off from each industry
   • Filter the data by year

2. Data Cleaning:

   • Create a backup table of the original data
   • Remove duplicate rows
   • Standardize the data (company names, industry, country)
   • Convert the date column to the correct data type
   • Handle blank and null values in the industry column
   • Remove unnecessary data

API

This project does not provide any API. It is a set of SQL queries for data exploration and cleaning.

Contributing

This project is not open for contributions at this time.

Testing

No formal testing procedures are provided for this project.