Data Cleaning Exercises

Pro exercise

Deliver missing, not empty text

A contact handoff has optional nickname and phone fields. Downstream systems test for missing values, so an empty or whitespace-only field must be delivered as missing — not as an empty string, which looks the same in a spreadsheet and breaks the receiving system's checks.

  • delivery
  • missing values
  • text

Sign in with a Pro or Lifetime plan to open the rules, the dataset and the workspace.