I have about 10 million rows and trying to groupby my data in Power BI by several columns. I've tried to do this with Power Query editor with "Group By" button but the performance is taking about 15-20 minuts. Then to boost the performance I've tried Python Pandas groupby function but the result is showing only VALUES. My script is: data = data.groupby(['date', 'client ', 'product'] ).sum() Input data date client product qty total amount 07-05-2022 Client-1 Phone 5 5000 07-05-2022 Client-2 PC 8 8500 07-05-2022 Client-2 PC 8 8500 Output data qty total amount 5 5000 16 17000 as you can see groupby with python function is not working as expected. Could someone help me with this issue? Thanks in advance. Continue reading...
