The Most Profitable Store | Analyzing Data

Course Content

Analyzing and Visualizing Real-World 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.

1. Group the observations in the `df` dataframe by the `'Store'` column values.
2. Select the `'Weekly_Sales'` column.
3. Calculate the total (sum) for each group.
4. Sort the resulting values in descending order (not ascending).

Everything was clear?

Section 3. Chapter 2

Course Content

Analyzing and Visualizing Real-World 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.

1. Group the observations in the `df` dataframe by the `'Store'` column values.
2. Select the `'Weekly_Sales'` column.