Data Cleaning Exercises

Pro exercise

Keep the current price per product

A price history has several rows per product. Validate prices, then keep the row that is current (latest valid_from, then smallest row_id) and report the rest as superseded.

  • deduplication
  • survivor rules
  • dates

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