Transform Nominal to Binominal

KNIME Analytics Platform
1

Hello,

i would like to know how to do a transformation like the following:
table is:

Attribute1 | Attribute2 |
A C
C B
B B

and should be transformed to

Attribute1 | Attribute2 | A | B | C |
A C 1 0 0
C B 0 0 1
B B 0 1 0

Is there a Node for this?

thanks in Advance

2

Hi,
we don’t have a special node doing this kind of transformation.

To simulate this behaviour use the following steps.

  1. Unpivoting. turn your two columnedtable into a kind of one column
  2. One2Many: Generate binary columns out of your newly created “combined” column
  3. GroupBy: Now group your rows again, using the old rowkey, using the maximum, for each binary column

(If you only have one column, instead of two to transform, you can do this without step 1 and 3, and only with step 2)

Greetz, Iris

3

i tried it, and it had worked thanks for the answer. now i can create assoc rules from this : )
thx alot for ur help.

greetings

Username