Data Cleaning Exercises

Pro exercise

Unpivot quarterly sales, keeping zeros

Quarterly sales arrive with one column per quarter. Turn them into one row per store and quarter. A reported 0 is a real value; a missing quarter produces no row.

  • reshaping
  • missing values

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