SQL-Data-Cleaning

Overview

This project demonstrates a detailed SQL data cleaning process using a raw sudent_id from student performance dataset. It focuses on transforming messy data into a structured format ready for analysis by handling missing values, standardizing formats, ensuring data integrity, and using a date cleaning AI assisted prompt that works in 3 steps fold.

Tools Used

SQL

Data Used

Donwload Here [messy data.zip]

1. Table creation and data import

Table.creation.and.data.import.mp4

2. Cleaning the entries of the table

Cleaning.table.entries.1.mp4

3. Cleaning the date and altering the date type

Cleaning.the.date.and.date.type.1.mp4

4. Ensuring duplicate removal

Ensuring.removal.of.duplicate.1.mp4

Cleaned data

cleaned data.zip