Cat Mapping
Upload a dataset to begin
Supported formats: .csv,.xlsx,.xls,.xlsm,.xlsb,.tsv
Sign in for free for unlimited files, no payment required.
About Cat Mapping
Rename or group specific values (e.g., US -> USA).
You define a lookup table of old-value-to-new-value pairs (for example "US" and "U.S." both mapping to "USA"), and the tool applies every mapping across the chosen column in a single pass, leaving unmapped values untouched. This is a manual, rule-based alternative to fuzzy matching, useful when you know exactly which variants exist and want deterministic control over the output labels.
Category: Transformation & LogicCommon Use Cases
- Standardizing country codes where a form allowed free text ("US", "U.S.A.", "United States") into one canonical "USA" value
- Grouping dozens of specific job titles into a handful of broader department categories
- Renaming legacy status codes ("1", "2", "3") into readable labels ("Open", "Pending", "Closed")
Key Features
- Define explicit old-value to new-value mapping rules
- Many-to-one grouping supported (multiple inputs mapping to one output)
- Unmapped values pass through unchanged
Use Regex Transform first if the inconsistent values follow a pattern you can capture programmatically; use Category Mapper when you need explicit, hand-picked control over specific value replacements, then run Encoding if the cleaned categories need to become numeric for modeling.
Frequently Asked Questions
Standardizing inconsistent category labels, for example mapping "US", "U.S.", and "United States" all onto a single "USA" value.
Yes, you define the full set of rename or group mappings and apply them in one pass.
A precise fix for analysts who know exactly which inconsistent labels need to be standardized and want full control over the result.
Read the related guide →