Course Content
Analyzing and Visualizing Real-World Data
Analyzing and Visualizing Real-World Data
2. Preprocessing Data: Part II
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).
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?
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).
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?
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).
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?
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).