Data Cleaning Exercises

Pro exercise

Key-value attributes to columns

Product attributes are stored one per row (key-value). Keep the latest value of each attribute, then spread color, size and material into columns. Unknown attribute names are out of scope.

  • pivot
  • survivor rules
  • reshaping

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