Text Fields, Categorisation, and Feature Preparation

About 75-95 minutes of guided work.

By the end of this module you can find the categories a text column is secretly splitting, write a match that does not depend on how someone typed it, build CASE buckets that cannot silently swallow rows, and record your cleaning rules so the result can be reproduced.

Units

1. Unit 09.00: Case, whitespace, and the duplicate category
2. Unit 09.01: Matching with LIKE and its limits
3. Unit 09.02: CASE buckets and the missing ELSE
4. Unit 09.03: Splitting and extracting from messy fields
5. Unit 09.04: Documenting normalisation so results reproduce

Module work

• Activity
• Knowledge check
• Summary