Course Content

# Analyzing and Visualizing Real-World Data

2. Preprocessing Data: Part II

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.

# 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?

Course Content

# Analyzing and Visualizing Real-World Data

2. Preprocessing Data: Part II

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.

# 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?