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
Group by operator
Maven
Hi,
I have three attributes state,height,weight.Here state is string and other two are numeric.My objective is to calculate correlation between height and weight group by state.ie,in sas\sql its like select corr(height,weight) group by state.How can I perform this task in RM.
Thanks
Ratheesan.
I have three attributes state,height,weight.Here state is string and other two are numeric.My objective is to calculate correlation between height and weight group by state.ie,in sas\sql its like select corr(height,weight) group by state.How can I perform this task in RM.
Thanks
Ratheesan.
0
Answers
my first idea was of course the aggregation operator but since you are calculating an aggregated value based on two columns for each group-by-value separately, it is probably the best idea to use the operator "Loop Values" for this. This board here is for general discussions about data mining, please post RapidMiner specific questions in the forum board "Data Mining / ETL / BI Processes". There people are more likely to help you with such a concrete problem.
Cheers,
Ingo