CATEGORICAL_MAPPING - AWS Glue DataBrew

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 – If true, 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"
        }
    }
}