Data Cleaning Exercises

Pro exercise

Sizes have an order, letters don't

Deliver stock sorted by SKU and then by size from small to large. Sorted as text, sizes come out L, M, S, XL. Map the spellings to standard sizes, look up each size's rank, and sort by the rank.

  • ordinal categories
  • mappings
  • sorting

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