Data Cleaning Exercises

Pro exercise

First and last order per customer

Build a customer summary with the first and last order date and the number of orders. Only real dates may count, and missing and invalid dates are reported separately.

  • dates
  • aggregation
  • validation

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