Prep your ingredients! Clean, chop, and measure before cooking.
Just like washing vegetables before cooking, we need to clean our data! Remove dirt, fix inconsistencies, standardize formats.
| ID | Name | Age | Salary | |
|---|---|---|---|---|
| 1 | Alice | 25 | 50,000 | alice@email.com |
| 2 | BOB | 30 | $60000 | bob@EMAIL.COM |
| 3 | charlie | thirty-five | 75000 | charlie@email |
| 4 | Diana | 28 | 55k | diana@email.com |
BOB → Bob, charlie → Charlie. Consistent capitalization!
$60000 → 60000, 55k → 55000. Remove symbols, convert to numbers!
"Diana " → "Diana". Remove extra whitespace!