🎉 🎉 RAPIDMINER 9.10 IS OUT!!! 🎉🎉

Download the latest version helping analytics teams accelerate time-to-value for streaming and IIOT use cases.

CLICK HERE TO DOWNLOAD

Top N by Grouped Fields

apabonokapabonok Member Posts: 2 Newbie
Hi!  I'm new in Rapidminer.  With this set of data:

Country, Customer, Sales
----------  ------------- ------------
Country1, C, 100
Country1, B, 90
Country1, A, 80
Country1, D, 70
Country1, H, 60
Country2, X, 1000
Country2, P, 900
Country2, Z, 800
Country2, W, 700
Country2, M, 600


I want Top 3 of Customer by each Country. This:

Country, Customer, Sales
----------  ------------- ------------
Country1, C, 100
Country1, B, 90
Country1, A, 80
Country2, X, 1000
Country2, P, 900
Country2, Z, 800

Pls, help me. 

Answers

  • mschmitzmschmitz Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,054  RM Data Scientist
    Hi,
    Group Into Collection, Loop Collection and Filter Example Range should do the trick. Maybe check out this video: for some quick explanation of Group Into Collection.

    BR,
    Martin



    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
    lionelderkrikorMarcoBarradasapabonok
  • apabonokapabonok Member Posts: 2 Newbie
    Wonderful! Yes, that it works for me!!!!  Thank you!!!!
    mschmitz
Sign In or Register to comment.