Data Cleaning Exercises

Pro exercise

Don't fill down unordered rows

An inventory export has blank aisles on some rows. In a printed report, a blank often means 'same as above', but this export's row order is arbitrary, so the row above says nothing about the aisle. Report the blanks instead of filling them down.

  • missing values
  • row order
  • validation

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