Binomnal attributes from polynominal one

frankstyle

Hi everybody, I'm pretty new to RapidMiner, but feel it is a great tool.
I really don't know how to solve a couple of data conversion tasks, I'm sure here there are many experts that can help me :-)

1) how can I create many binominal attributes starting from a polynominal attribute? I mean, I have this attribute:
color
white
orange
black
...and I want to convert it to 3 binominal attributes
white    orange  black
1          0            0
0          1            0
0          0            1

2) next, I love the aggregate operator, but it seems to me it doesn't work like the SQL-one. I.e., in RapidMiner it loses all the attributes it hasn't aggregated or grouped.... how can I get in RapidMiner something like this (silly) SQL statement?

SELECT name,birthday,email,SUM(monthlysalary) as totalsalary FROM mytable GROUP BY email

Thank you so much for your help!

MariusHelf

Hi,

your first issue is solved by the Nominal to Numerical operator.

Your SQL statement is not valid, at least not in the SQL dialect I know (MySQL, MSSQL, ...). As in RapidMiner, in SQL you can't select anything that is not used for grouping or part of an aggregation function.

Best regards,
Marius