Data Cleaning Exercises

Pro exercise

Count tags that look alike

Blog tags were typed on phones and pasted from the web: Café, café with a combining accent, café padded with a no-break space. Count uses per tag after Unicode trimming, NFC and lower case, so one tag isn't split into three rows.

  • unicode
  • normalization
  • aggregation

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