Data Cleaning Exercises

Pro exercise

Remove resends before totals

A payment feed sometimes re-sends a payment. Revenue per merchant must count each payment once, so remove the resends (same payment_id) before summing — otherwise totals grow with every retry.

  • deduplication
  • aggregation
  • reconciliation

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