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
Hi @pruthvi1286
You want to look at the Category To Number node. It takes nominal data and maps the categories to integers.
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
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)
1 Like
Thanks a lot !
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.