I have an attribute of type string data. As seen below. Because he has a name that has so many kinds. But from the whole data, some have the same name. I want to manipulate the attribute into a number. Does Knime have nodes that can help solve my problem faster?
What is your expected output in this case? “
manipulate the attribute into a number” is somewhat vague.
Yeah. I want to manipulate the attribute into a classifiable number. Thanks for corrected
if you mean that KOSONG = 1, MTS AL = 2 etc. etc. you could follow these steps:
use a remove duplicate filter on your row
then a counter generator, so that each single value is given a value
finally, use a joiner node to assign the numeric value to your input column.
Hope it helps.
Have a nice day,
@ganieaku you could use the:
and convert strings to numbers and store the ‘dictionary’ to re-use it later
There are more advanced methods also
If you are interested in that you could check out the preparation section of my machine learning collection. About tools like vtreat (
vtreat for KNIME! – Win Vector LLC) for example. Also the relevant KNIME workflow ( Techniques for Dimensionality Reduction – KNIME Hub) which has a section about t-sne but I do not know if the methods are being stored in a way to reproduce them. The linked paper goes to a broken page …
Also there is a (quite complete) set called “the poor man’s ML Ops” that I …
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.