Course Content
Analyzing and Visualizing Real-World Data
Analyzing and Visualizing Real-World Data
2. Preprocessing Data: Part II
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
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
Everything was clear?
Thanks for your feedback!
Section 3. Chapter 2
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
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
Everything was clear?
Thanks for your feedback!
Section 3. Chapter 2