SQLDAXExcelPython
Leaderboard
groupby and mergeMedium20 points

Rank within each group

Set result to Category, ProductName and each product's price rank within its category, where 1 is the highest price.

Show solutionLifetime

Real Python running in your browser through Pyodide, with pandas available. Nothing you type is sent to a server unless you save a score.

Python
Loading editor…

Press Ctrl+Enter or Run to see the result here.