Data Cleaning Exercises

Pro exercise

The latest answer counts

People can resubmit a form, and only their last submission counts. Identify a person by normalized email within each form, compare submission times as instants across offsets, and report earlier submissions as replaced.

  • duplicates
  • timestamps
  • composite keys

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