Data CleaningEasy

How do you normalize string case and whitespace?

Seen at: Stripe · Salesforce · HubSpot

Your users.email column has values like 'Alice@Example.COM ', 'alice@example.com', ' alice@EXAMPLE.com'. Walk through how you'd normalize and dedupe.

Draft your answer

Saved to this browser only. Try it before you peek at the model answer.

Stuck? Peek at a hint

Reveals the model answer and the self-score rubric.

More data cleaning questions