Data Cleaning Exercises

Glossary

Controlled vocabulary

An approved list of category values that every record must use.

Free-typed categories drift: Email, e-mail, EMAIL. Map variants to the approved values with a reviewed dictionary and quarantine anything unmapped instead of guessing a nearest match.

Related: Boolean parsing, Validation rule