Data Cleaning Exercises

Pro exercise

Turn sentinel codes into missing values

A sensor export writes -999 when no reading was taken. Treat that code and blanks as missing, keep real readings (including negatives), and quarantine anything that isn't a whole number.

  • missing values
  • sentinels
  • type conversion

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