Options
Creating dummy variables from text columns
Hello,
is there a more efficient way to create dummy variables using Rapidminer?
Eg, I have to following data
And I would like it to look like this
I know I can do this with Generate Attributes' if function, but as I need to create more than 100 dummies, I was wondering if there is a quicker method.
Thanks a lot!
is there a more efficient way to create dummy variables using Rapidminer?
Eg, I have to following data
Col1;Col2 1;dog 2;cat 3;zebra |
Col1;dog;cat;zebra 1;1;0;0 2;0;1;0 3;0;0;1 |
Thanks a lot!
Tagged:
0
Answers
Not sure which one at the moment as I'm a little sleepy. Give both a try. ::)
thanks for the reply. However somehow I still cant manage to have the data converted into dummy variables using neither Pivot or Transpose.
Maybe the problem is the text format of the variables?
compare with example process).
If the value attribute is missing, you have to generate it: