Data Cleaning Exercises

Pro exercise

Filter rows, then filter groups

List repeat customers: people with at least two paid orders, and what they spent. Unpaid orders must be removed before counting (WHERE), and customers with fewer than two paid orders after counting (HAVING). Doing either at the wrong stage changes who qualifies.

  • aggregation
  • where vs having
  • scope

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