The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

Top N by Grouped Fields

apabonokapabonok Member Posts: 2 Learner I
in Help
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, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 RM Data Scientist
    Hi,
    Group Into Collection, Loop Collection and Filter Example Range should do the trick. Maybe check out this video: https://www.youtube.com/watch?v=7szR0HdDVRg for some quick explanation of Group Into Collection.

    BR,
    Martin



    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • apabonokapabonok Member Posts: 2 Learner I
    Wonderful! Yes, that it works for me!!!!  Thank you!!!!
Sign In or Register to comment.