Data Cleaning Exercises

Pro exercise

An unticked checkbox is blank

A web form exports a checkbox as 'on' when ticked and nothing when unticked. For the optional newsletter box, blank therefore means false — a documented exception to 'missing is unknown'. For the required terms box, blank means not accepted.

  • missing values
  • booleans
  • documented defaults

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