Aggregate binomial columns
Hello all,
I have a dataset that looks like:
User | Item
-------------
1 | Cheese
1 | Bread
2 | Milk
I'd like to mine the frequent item sets from this data. First thing I did was feed this to "Nominal to Binomial" which seems to work as expected, eg:
User | Cheese | Bread | Milk
------------------------------------------------------------
1 | true | false | false
1 | false | true | false
2 | false | false | true
What I now need to do is aggregate by user ID to generate:
User | Cheese | Bread | Milk
------------------------------------------------------------
1 | true | true | false
2 | false | false | true
I thought I could do this with the Aggregate operator, but that operator seems completely blind to the binomial columns; I can't find any way of selecting them.
What should I be doing here?
Thank you!
I have a dataset that looks like:
User | Item
-------------
1 | Cheese
1 | Bread
2 | Milk
I'd like to mine the frequent item sets from this data. First thing I did was feed this to "Nominal to Binomial" which seems to work as expected, eg:
User | Cheese | Bread | Milk
------------------------------------------------------------
1 | true | false | false
1 | false | true | false
2 | false | false | true
What I now need to do is aggregate by user ID to generate:
User | Cheese | Bread | Milk
------------------------------------------------------------
1 | true | true | false
2 | false | false | true
I thought I could do this with the Aggregate operator, but that operator seems completely blind to the binomial columns; I can't find any way of selecting them.
What should I be doing here?
Thank you!