0 ×

Numeric Binner

StreamableKNIME Base Nodes version 3.6.1.v201808311359 by KNIME AG, Zurich, Switzerland

For each column a number of intervals - known as bins - can be defined. Each of these bins is given a unique name (for this column), a defined range, and open or closed interval borders. They automatically ensure that the ranges are defined in descending order and that interval borders are consistent. In addition, each column is either replaced with the binned, string-type column, or a new binned, string-type column is appended.

Options

Select Column:
First select a column (left side) and then use the "Add" button (right side) to create the desired number of bins. Each bin can be modified in the lower part of this panel once it has been selected. Each interval has to be defined independently or can be removed using the "Remove" button. Note that the range as well as the bin borders can be automatically adjusted, if necessary. The first bin's left and the last bin's right value are automatically defined to infinitely cover the entire numeric axes in this direction. Furthermore, each bin's left and right value can be included or excluded from this bin by selecting the desired bracket: '[' or ']'.
Append new column:
If selected, a new column name can be specified. This name is given to the new binned column that is appended to the table; the input column remains unchanged in the data.

Input Ports

Data to define bins

Output Ports

Data with bins defined

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Update Site

To use this node in KNIME, install KNIME Base Nodes from the following update site:

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform.