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

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,282 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!!!!
    MartinLiebig
Sign In or Register to comment.