Data Cleaning Exercises

Pro exercise

Two code systems in one column

A country column mixes two-letter codes (DE) and three-letter codes (DEU). Translate both to the two-letter standard with the reference table, which lists every accepted code including the two-letter ones themselves.

  • mappings
  • standards
  • lookups

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