The following node is available in the Open Source KNIME predictive analytics and data mining platform version 2.7.1. Discover over 1000 other nodes, as well as enterprise functionality at
http://knime.com.
Numeric Binner
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.
If the optional PMML inport is connected and contains preprocessing
operations in the TransformationDictionary the conversion operations
of this node are appended.
Dialog 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.
Ports
Input Ports
0 |
Data to define bins |
1 |
Optional PMML document to add the
binning operations to. |
Output Ports
0 |
Data with bins defined |
1 |
PMML document containing binning
parameters. |
This node is contained in KNIME Base Nodes
provided by KNIME GmbH, Konstanz, Germany.