Category to Number

This node takes columns with nominal data and maps every category to an integer. For your convenience, you can process multiple columns with this node. However, these columns are processed separately as if you would use a single Category To Number node for every column.

Options

Columns
Include the columns that should be processed. You can only include columns with nominal data.
Append columns
If checked, the computed columns will be appended to the input table. Otherwise the computed columns replace the columns in the include list.
Column suffix
The column name of the computed columns are the name of the column in the input appended by this suffix.
Start value
The category in the first row will be mapped to this value.
Increment
The i-th category is mapped to the value i * Increment + Start value.
Max. categories
Processing is interrupted for inputs with more than categories than max. categories.
Default value
This value is used when the PMML model is applied. It defines the value used when the input is not found in the mapping. Leave it empty to assign a missing cell in this case.
Map missing to
Missing cells are mapped to this value. You can enter any integer. If empty, missing cells will be mapped to missing cells.

Input Ports

Icon
Data

Output Ports

Icon
Data with transformed columns
Icon
PMML port object that includes the performed operations.

Views

This node has no views

Workflows

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.