๐Ÿงน Data Preprocessing Lab

Prep your ingredients! Clean, chop, and measure before cooking.

Cleaning Your Ingredients

Just like washing vegetables before cooking, we need to clean our data! Remove dirt, fix inconsistencies, standardize formats.

IDNameAgeSalaryEmail
1Alice2550,000alice@email.com
2BOB30$60000bob@EMAIL.COM
3charliethirty-five75000charlie@email
4Diana 2855kdiana@email.com
๐Ÿ”ค

Standardize Text

BOB โ†’ Bob, charlie โ†’ Charlie. Consistent capitalization!

๐Ÿ”ข

Fix Formats

$60000 โ†’ 60000, 55k โ†’ 55000. Remove symbols, convert to numbers!

โœ‚๏ธ

Trim Spaces

"Diana " โ†’ "Diana". Remove extra whitespace!