Exercise

Separate a column

To create the week_ratings data, we first selected all the columns in ratings2 that contain data about the number of 7-day viewers in millions for each series, then we gathered those 10 columns into two columns.

In this exercise, you'll use the tidyr, dplyr, and readr packages (all are loaded) to tidy and plot the week_ratings data so we can read the x-axis, which labels each episode!

Instructions 1/3

XP

1
2
3

Add a line after the %>% in your code from the last set of gathering exercises to separate the existing column named episode into a new column also called episode.
Drop the extra part that always says "7day".
Print to view the result.

Take Hint (-9 XP)