Course Content
Analyzing and Visualizing Real-Life Data
2. Preprocessing Data: Part II
Analyzing and Visualizing Real-Life Data
The Most Profitable Periods
Good, now we know that the given data are weekly. Let's find out what weeks were the most profitable by comparing the total for each week.
Task
- Group the observations in the
df
dataframe by the'Date'
column values. - Select the
'Weekly_Sales'
column. - Calculate the total (sum) for each group.
- Sort values in descending order (not ascending).
Everything was clear?
Section 3. Chapter 5