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 |
Solved! Go to Solution.
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!
@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