CATEGORICAL_MAPPING - Amazon Glue DataBrew
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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"
        }
    }
}