Group by operator

ratheesan

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.

IngoRM

Hi,

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