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.

Views

This node has no views

Workflows

• Credit Scoring Model(diksha kumari)KNIME Hub
• (test) credit score modelKNIME Hub
• 00_Keras_Transfer_LearningKNIME Hub
• 00_Keras_Transfer_LearningKNIME Hub
• 01 Train a Feed Forward Neural NetworkKNIME Hub
• Show all 576 workflows

Links

• Replace all the non-numeric values with 1 - and all the blanks with 0by mlauber71 on 2018-09-30

  forum.knime.com/p/48239
• Renaming values in a columnby oole on 2019-02-14

  forum.knime.com/p/54543

Developers