Data Cleaning Exercises

Guide · updated 2026-11-04

Email normalization policies

What is safe to change in an email address, and what isn't.

Safe changes

Trimming padding and lowercasing are safe under most policies because providers treat addresses case-insensitively in practice.

Unsafe changes

Removing dots or plus tags is provider-specific and can merge different people. Only do it if the policy explicitly says so.

Missing emails

A missing email never matches another missing email. Route those records to review.

Practise it