Missing Indicator - Data Cleaning Step by Step

Add the Flag Beside the Value

Start with four pinned amount cells. The table uses (blank) to make the empty cells visible. Create a new amount_missing column. Keep amount unchanged: 0 stays 0, and blanks stay blank. The new feature is just a flag. It records where the missing values were before any later fill, filter, or model step.

Adding an exact true/false feature that marks blank amount cells while leaving the original amount column unchanged.

highlighted = computed this step

Input amount column

Start with 4 pinned amount cells, including blanks.

\text{amount cells}

Exact indicator rule

Create amount_missing: true for blanks, false for present values.

\text{missing indicator rule}

Add amount_missing

Keep amount unchanged; add the indicator beside it.

\text{amount plus missing flag}