Filter nlargest of Group

[ActionAndi]

Hi there,

is there a Knime way to filter out the top n largest values of a group?
In Python/Pandas I’d use this one here:

df.groupby('GroupCol')['ValCol'].nlargest(2)

Andreas

[gonhaddock]

Hello @ActionAndi

‘Top k Selector’ node can do the task:

Top k Selector

You could combine with Group By or Group Loop Start depending on the use case.

BR

[duristef]

Hi @ActionAndi ,
Here’s a test table with alpha labels and random int

If this is the result you want (2 largest values per group)

you could use a workflow like this one
KNIME_temp.knwf (10.4 KB)

[gonhaddock]

@duristef
Ranking by Groups is a good approach indeed.

[ActionAndi]

@duristef: This is pretty neat! Thanks a lot!

@gonhaddock: Your Solution is working good as well! Thanks you too!