Data Cleaning Exercises

Pro exercise

Map known variants, keep the rest

US states arrive as codes or full names. Map the listed full names to their codes and keep every other value unchanged; this mapping only standardizes known variants and rejects nothing.

  • mappings
  • text

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