Data Cleaning Exercises

Pro exercise

Zero degrees is a reading

A freezer log records temperatures from -50 to 60 °C. 0 and 0.0 are real readings, not missing values — but code that tests 'if value' or uses NULLIF(x, 0) quietly turns them into gaps.

  • validation
  • zero vs missing
  • ranges

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