Renaming values in a column

KNIME Extensions
1

Hello,
I have a column named Grade and the values are A,B,C,D,E,F. These are like the categories to the respective cell values.
Now I want to re-code them as
A=1
B=2
C=3
.
F=6
I need to represent them numerically do to a requirement.
Please help me with that.
Thanks,
Pruthvi

2

Hi @pruthvi1286

You want to look at the Category To Number node. It takes nominal data and maps the categories to integers.

3

Hi,
oh okay thanks. But how do I know what am I encoding ?Isn’t there any way I can define the re-coding parameters.

1 Like
4

The original String information is not lost, you can use the Number To Category (Apply) node to do the reverse.

If you want to define the integers that should replace the strings yourself you can use the String Replace (Dictionary) node.

Here’s an example: category_to_number_example.knwf (15.1 KB)

image

1 Like
5

Thanks a lot !

6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.