The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 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.
Options

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

  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,525 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
  • Options
    apabonokapabonok Member Posts: 2 Newbie
    Wonderful! Yes, that it works for me!!!!  Thank you!!!!
Sign In or Register to comment.