Data Cleaning Exercises

Reference · Visual workspace

Map values with a dictionary in Visual workspace

Replace each spelling with its approved value using a reviewed dictionary, and decide what happens to unmapped values.

When to use it

Categories with many spellings for one meaning.

How

Add step → Rules → Map values. One pair per line (from => to). Choose whether unmapped values are kept or quarantined.

Map 7 values in channel (unmapped → unmapped_channel)
  • Missing values pass through unchanged; require a value first if needed.

Pitfalls

  • Keeping unmapped values unchanged.
  • Mapping before normalizing.
  • Guessing mappings for unseen spellings.

Lesson: Map categories with an approved dictionary

Practise it: Map channels with an approved dictionary