🛡️Data is processed locally – We cannot see your data
Cat Mapping
Upload a dataset to begin
Supported formats: .csv,.xlsx,.xls,.xlsm,.xlsb,.tsv
AboutCat Mapping
Rename or group specific values (e.g., US -> USA).Category: Transformation & LogicStandardizing country codes where a form allowed free text ("US", "U.S.A.", "United States") into one canonical "USA" valueGrouping dozens of specific job titles into a handful of broader department categoriesRenaming legacy status codes ("1", "2", "3") into readable labels ("Open", "Pending", "Closed")
The Cat Mapping tool is compatible with:.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.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.
Frequently Asked Questions:
What's a typical use case?
Standardizing inconsistent category labels, for example mapping "US", "U.S.", and "United States" all onto a single "USA" value.
Can I map many values at once?
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.