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
netflix
to adata.table
using theas.data.table()
(docs) function so that its rownames become a column named"series"
. - Right join the new
data.table
you've just created,netflix_dt
, toimdb
using thedata.table
join 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
___