Validate Required Values - Data Cleaning Step by Step

Flag Blank Required Values

Start with four pinned email cells. The column exists, but some row values are blank. The output keeps every original row and adds email_present. This is a validation check, not a fill or drop step.

Checking that a required column has nonblank cell values while keeping every row unchanged.

highlighted = computed this step

Input email column

Start with 4 pinned email rows, including blanks.

\text{email values}

Required-value rule

A required email value must be nonblank.

\text{required value rule}

Add email_present

Keep every row unchanged and add email_present.

\text{validation flag only}