RAPIDMINER 9.7 BETA ANNOUNCEMENT
The beta program for the RapidMiner 9.7 release is now available. Lots of amazing new improvements including true version control!
"Polynominal to binominal and aggregate behaviour"
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:
...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!