Data Cleaning Exercises

Glossary

Validation rule

A testable statement a value must satisfy, with a reason name for failures.

Examples: amount matches -?\d{1,10}(\.\d{1,2})?; status is one of shipped, pending, cancelled. Rules are checked in a declared order.

Related: Quarantine