AVERAGE - AWS Glue DataBrew

AVERAGE

Calculates the average of the values in the source columns and returns the result in a new column. Any non-number is ignored.

Parameters
  • sourceColumns – A JSON-encoded string representing a list of existing columns.

  • targetColumn – A name for the newly created column.

Example

{ "RecipeAction": { "Operation": "AVERAGE", "Parameters": { "sourceColumns": "[\"age\",\"weight_kg\",\"height_cm\"]", "targetColumn": "AVERAGE Column 1" } } }