Joining a data.frame
The netflix and imdb datasets have been loaded into your R session. Your goal is to add IMBD ratings to all series in the netflix dataset, but this time netflix has been loaded in as a data.frame instead of a data.table.
This exercise is part of the course
Joining Data with data.table in R
Exercise instructions
- Convert
netflixto adata.tableusing theas.data.table()(docs) function so that its rownames become a column named"series". - Right join the new
data.tableyou've just created,netflix_dt, toimdbusing thedata.tablejoin syntax.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Convert netflix to a data.table
netflix_dt <- ___
# Right join
___