DATA CLEANING

[pinkysouji21]

DATA CLEANING (HANDLING INCONSISTENT TEXT)

-- 1. Standardizing text formats (e.g., HR, hr, Hr -> HR)
UPDATE your_table_name
SET column_name = UPPER(column_name)
WHERE column_name IN ('hr', 'Hr', 'h.r.');

-- 2. Trimming extra spaces using TRIM()
UPDATE your_table_name
SET column_name = TRIM(column_name);

-- 3. Fixing spelling variations and uniform naming
UPDATE your_table_name
SET column_name = CASE
WHEN column_name LIKE 'Eng%' THEN 'Engineering'
WHEN column_name = 'Mktg' THEN 'Marketing'
ELSE column_name
END;

-- 4. Ensuring uniform case across the entire column
UPDATE your_table_name
SET column_name = INITCAP(column_name); -- Or UPPER() / LOWER()