Imputing sales data

You've been asked to create a report that allows management to compare sales figures per quarter for two years. The problem is that the dataset (sales_df) contains missing values. You'll need to impute the values in the year column so that you can visualize the data.

The ggplot2 package has been pre-loaded for you.

Diese Übung ist Teil des Kurses

Reshaping Data with tidyr

Kurs anzeigen

Anleitung zur Übung

Inspect sales_df in the console, pay attention to the year column.
Use the fill() function to impute the year column in the correct direction.
Create a line plot where each year has a different color.

Interaktive Übung

Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.

sales_df %>% 
  # Impute the year column
  ___ %>%
  # Create a line plot with sales per quarter colored by year.
  ggplot(aes(x = ___, y = ___, color = ___, group = year)) +
  geom_line()

Code bearbeiten und ausführen