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
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
Hello @ActionAndi
‘Top k Selector’ node can do the task:
You could combine with Group By or Group Loop Start depending on the use case.
BR
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)
@duristef: This is pretty neat! Thanks a lot!
@gonhaddock: Your Solution is working good as well! Thanks you too!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.