1. Learn
    2. /
  2. Courses
    3. /
  3. Reshaping Data with tidyr

Exercise

Multiple variables per column

Being a busy person, you don't want to spend too much time on Netflix, so you decide to crunch some numbers on TV show and movie durations before deciding what to watch. You've managed to obtain a dataset named netflix_df, but its duration column has an issue. It contains strings with both a value and unit of duration ("min" or "Season").

You'll tidy this dataset so that each variable gets its own column.

As will always be the case in this course, the tidyr package has been pre-loaded for you.

Instructions

100 XP
  • Inspect netflix_df by typing its name directly in the R console and hitting Enter to see what string separates the value from the unit in the duration column.
  • Separate the duration column over two variables named value and unit. Pass the string separating the number from the unit to the sep argument.