SQLDAXExcelPython
Leaderboard
groupby and mergeMedium20 points

Several aggregates in one groupby

For each Category in products, set result to the number of products, the average UnitPrice and the highest UnitPrice.

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.