Data Cleaning Exercises

Glossary

Identifier

A value that names a thing (a code, an id). Compared exactly, never as a number.

Identifiers should be stored as text, compared exactly, and never rounded, trimmed internally, or reformatted unless a rule says so.

Related: Leading zeros, Entity resolution