Data Cleaning Exercises

Glossary

Missing value (null)

A cell where nothing was recorded. Different from empty text and from zero.

SQL calls it NULL; pandas shows NaN or <NA>. A missing value means unknown or not recorded, so it should not equal anything, including another missing value, and it should not be silently replaced by 0 or a placeholder.

Related: Empty string, Imputation, Null key