Skip to main content

Varicent ELT Help Center

Standard Scaler

Abstract

Standardize numeric columns by subtracting the mean and scaling to unit variance.

Use the Standard Scaler tool when you want to scale values without specifying a range. Standardize numeric columns by subtracting the mean and scaling to unit variance.

This tool scales a numeric column so that values fall within a range where the mean is set to 0 and the standard deviation is set to 1. If you want to scale values between a given range, use the Min Max scaler.

Input

The Standard Scaler tool requires one data input.

Configuration

Use the following configuration options to configure the Standard Scaler tool.

Configuring the Standard Scaler tool

  1. Go to the Pipes module from the side navigation bar.

  2. From the Pipes tab, click an existing pipe to open, or create a new pipe. To create a new pipe, read the Creating a pipe documentation.

  3. In the Pipe builder, add at least one data source to your pipe. For more information on adding a data source, see the Data tool.

  4. Click symon_add_icon.png + Tool.

    The Tools modal opens where you can add tools, such as the Aggregate tool to your pipe.

  5. In the Tools modal, search for Standard Scaler and then click + Add tool.

    Tip

    You can also find the Standard Scaler tool in the Calculate section.

  6. Click the tool node and drag the line to the next tool to connect the tools. If you need to undo the action, click the line and then click Unlink.

  7. In the configuration pane, select the target column in your dataset.

    Note

    The column must be a numeric column.