Data Cleaning Exercises

Pro exercise

Units spelled many ways

Quantities come with units typed freely: kg, KGS, kilogram, g, grams, litre, pcs. Map the approved spellings to four unit codes, report units nobody approved, and total quantities per unit — never adding kilograms to grams.

  • mappings
  • units
  • aggregation

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