Data Cleaning Exercises

Glossary

Data profiling

Measuring a table before cleaning it: row counts, missing values, distinct values, ranges and patterns per column.

A profile turns guesses into evidence: how many rows are blank, which values repeat, whether an id is unique. Profile all rows, not a preview sample, because rare problems hide outside the first screen.

Related: Data dictionary, Outlier, Missing value (null)