Data Cleaning Exercises

Pro exercise

Repair garbled text with an approved list

Somewhere upstream, UTF-8 text was decoded as Windows-1252, so München became München. Apply the approved repair list, then validate cities against the reference table. Garbled values that aren't on the list are reported, not re-decoded on a guess.

  • encoding
  • mappings
  • validation

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