REPLACE_WITH_MODE - 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).

REPLACE_WITH_MODE

Replaces each invalid value in a column with the mode of all other values.

Parameters
  • sourceColumn – The name of an existing column.

  • columnDataType – The data type of the column. This type must be number.

  • modeType – How to resolve tie values in the data. This value must be MINIMUM, NONE, AVERAGE, or MAXIMUM.

Example

{ "RecipeAction": { "Operation": "REPLACE_WITH_MODE", "Parameters": { "columnDataType": "number", "modeType": "MAXIMUM", "sourceColumn": "height_cm" } } }