Data Cleaning Exercises

Glossary

Quarantine

Moving an invalid row to an exceptions table with a reason, instead of deleting it.

Quarantined rows are evidence. With numbered rules, a row gets the first reason that applies, and clean plus quarantined rows must add up to the input.

Related: Reconciliation, Validation rule