Data Cleaning Exercises

Reference · Visual workspace

Change case in Visual workspace

Lowercase or uppercase every value so that spellings differing only in case compare equal.

When to use it

Categories, emails and country codes whose case carries no meaning under the rules.

How

Add step → Text → Change case. Choose lowercase or UPPERCASE.

Lowercase status
  • Apply after trimming so padding doesn't hide differences.

Pitfalls

  • Changing case where it carries meaning (some codes are case-sensitive).
  • Lowercasing names, which changes how people's names appear.

Practise it: Normalize emails under a declared policy