Cleaned a 1,000-row messy HR by Yash RajCleaned a 1,000-row messy HR by Yash Raj

Cleaned a 1,000-row messy HR

Portfolio project
Yash Raj
Cleaned a 1,000-row messy HR dataset using PostgreSQL, handling inconsistent missing values, whitespace, mixed numeric/text data, and five different date formats. Built a reproducible SQL pipeline using CASE, regex, TRIM, type casting, and TO_DATE(), followed by validation checks to ensure the cleaned data remained accurate and analysis-ready.

0 likes · 0 views · Aug 9, 2026

Cleaned a 1,000-row messy HR dataset using PostgreSQL, handling inconsistent missing values, whitespace, mixed numeric/text data, and five different date for...

Tags