Data Cleaning Exercises

Pro exercise

Keep the first delivery of each event

A device resends events when it loses its connection. Keep the first delivery of each event_id (earliest received instant, then smallest row_id) and report the resends.

  • deduplication
  • timestamps
  • survivor rules

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