Data structure recipe steps

Use these recipe steps to tabulate and summarize data from different perspectives, or to perform advanced functions.

Topics

• NEST_TO_ARRAY
• NEST_TO_MAP
• NEST_TO_STRUCT
• UNNEST_ARRAY
• UNNEST_MAP
• UNNEST_STRUCT
• UNNEST_STRUCT_N
• GROUP_BY
• JOIN
• PIVOT
• SCALE
• TRANSPOSE
• UNION
• UNPIVOT

SCALE

Scales or normalizes the range of data in a numeric column.

Parameters

• sourceColumn — The name of an existing column.

• strategy — The operation to be applied to the column values:

  • MIN_MAX — Rescales the values into a range of [0,1].

  • SCALE_BETWEEN — Rescales the values into a range of two specified values.

  • MEAN_NORMALIZATION — Rescales the data to have a mean (μ) of 0 and standard deviation (σ) of 1 within a range of [-1, 1].

  • Z_SCORE — Linearly scales data values to have a mean (μ) of 0 and standard deviation (σ) of 1. Best for handling outliers.

• targetColumn — The name of a column to contain the results.

Example

{
    "Action": {
        "Operation": "NORMALIZATION",
        "Parameters": {
            "sourceColumn": "all_votes",
            "strategy": "MIN_MAX",
            "targetColumn": "all_votes_normalized"
        }
    }
}