Data Cleaning Exercises

Pro exercise

Pick the current row, then filter

List the orders that are open right now. Each order has a status history, so first take each order's latest status and only then keep the open ones; filtering first would resurrect orders that have since closed.

  • order of operations
  • deduplication
  • timestamps

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