Group by operator

ratheesanratheesan Member Posts: 68 Maven
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,in sas\sql its like select  corr(height,weight) group by state.How can I perform this task in RM.



  • IngoRMIngoRM Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University Professor Posts: 1,751 RM Founder

    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.

Sign In or Register to comment.