The Most Profitable Store
Since we want to find the most profitable stores based on the given data, we need to group the observations in the df
dataframe by the 'Store'
column values and calculate the total (sum) of the 'Weekly_Sales'
column for each group. Finally, we need to sort the resulting values in descending order.
Swipe to start coding
- Group the observations in the
df
dataframe by the'Store'
column values. - Select the
'Weekly_Sales'
column. - Calculate the total (sum) for each group.
- Sort the resulting values in descending order (not ascending).
Solution
Thanks for your feedback!
single
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 3.45
The Most Profitable Store
Swipe to show menu
Since we want to find the most profitable stores based on the given data, we need to group the observations in the df
dataframe by the 'Store'
column values and calculate the total (sum) of the 'Weekly_Sales'
column for each group. Finally, we need to sort the resulting values in descending order.
Swipe to start coding
- Group the observations in the
df
dataframe by the'Store'
column values. - Select the
'Weekly_Sales'
column. - Calculate the total (sum) for each group.
- Sort the resulting values in descending order (not ascending).
Solution
Thanks for your feedback!
Awesome!
Completion rate improved to 3.45single