Course Content
Analyzing and Visualizing Real-Life Data
2. Preprocessing Data: Part II
Analyzing and Visualizing Real-Life Data
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.
Task
- 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).
Everything was clear?
Section 3. Chapter 2