The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Binomnal attributes from polynominal one
frankstyle
Member Posts: 3 
Contributor I
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!
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!
0
Answers
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