CATEGORICAL_MAPPING
Maps one or more categorical values to numeric or other values
Parameters
-
sourceColumn– The name of an existing column.categoryMap– A JSON-encoded string representing a map of values to categories.deleteOtherRows– Iftrue, all non-mapped rows will be removed from the dataset.other– When provided, all non-mapped values will be replaced by this value.keepOthers– If true, all non-mapped values will remain the same.mapType– The data type of the mapped column.targetColumn– The name of a column to contain the results.
Example
{
"Action": {
"Operation": "CATEGORICAL_MAPPING",
"Parameters": {
"categoryMap": "{\"United States of America\":\"1\",\"Canada\":\"2\",\"Cuba\":\"3\",\"Haiti\":\"4\",\"Dominican Republic\":\"5\"}",
"deleteOtherRows": "false",
"keepOthers": "true",
"mapType": "NUMERIC",
"sourceColumn": "state_name",
"targetColumn": "state_name_mapped"
}
}
}