Data Cleaning Exercises

Pro exercise

Prices that might be in cents

Shelf prices are normally between 1 and 100. A price of 1299 is most likely 12.99 typed in cents, but it could be a real premium item, so flag it for review instead of dividing by 100 or deleting it.

  • outliers
  • units
  • flags

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