Options

Group by operator

ratheesanratheesan Member Posts: 68 Maven
in Help
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.

Answers

  • Options
    IngoRMIngoRM Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University Professor Posts: 1,751 RM Founder
    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
Sign In or Register to comment.