Data Cleaning Exercises

Pro exercise

Below detection is not zero

A lab result column holds numbers and the code <LOD (below the limit of detection). That's two meanings in one text column: split it into a typed number and a true/false flag, instead of turning <LOD into 0 or throwing it away.

  • types
  • missing values
  • flags

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