Data Cleaning Exercises

Glossary

Exception report

The list of rows that failed a rule, each with the reason, kept next to the clean output.

Every rejected row should be explainable: which rule failed first and what value caused it. An exception report lets the data owner fix sources, and lets you prove that clean rows plus exceptions add back up to the input.

Related: Quarantine, Reconciliation, Validation rule