Filter to get max value from each group?

[matthew_swanson]

i have a dataset where i need to get the max from each group, is there a tool that can help me do this?

input

key	column1	column2
1	red	3
2	red	4
3	green	7
4	green	8
5	blue	6
6	blue	2

desired output:

key	column1	column2
2	red	4
3	green	8
5	blue	6

[matthew_swanson]

i have a dataset where i need to get the max from each group, is there a tool that can help me do this?

input

key	column1	column2
1	red	3
2	red	4
3	green	7
4	green	8
5	blue	6
6	blue	2

desired output:

key	column1	column2
2	red	4
3	green	8
5	blue	6

[marcusblackhill]

Hey @matthew_swanson !

You can do it with summarize tool, groupby the column 1 and select column 2 to get the max.

Hope that helps!

[matthew_swanson]

@marcusmontenegro Almost. ive managed to get the summarize tool to return the max value for each group, but i cant figure out how to make it return the key for that row.. the value itself is only going to be helpful if i know which row it came from

[marcusblackhill · Accepted solution]

Gotcha, see if that attached example helps