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

: Data

Output Ports

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

Popular Predecessors

Popular Successors

Views

This node has no views

Workflows

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.

Installation

To use this node in KNIME, install the extension KNIME Base nodes from the below update site following our NodePit Product and Node Installation Guide:

v5.3

A zipped version of the software site can be downloaded here.

Plugin provider: KNIME AG, Zurich, Switzerland

Plugin version: 5.3.3.v202410291553

On NodePit since: 2024-07-09

Last update: 2024-11-21

Tags: Streamable

KNIME versions: Since v3.6

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!