Data Cleaning Exercises

Pro exercise

Build a duplicate review queue

Don't merge customers automatically. Group records that share a normalized email into candidate groups for a person to review, listing the lowest record ID as the proposed master and how many records each group holds.

  • entity resolution
  • blocking
  • aggregation

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