Multi-key, single-key
In addition to locations, you will work with the teachers dataset in this exercise. It contains information about the teacher for each subject. The teacher of each subject does not change between semesters. Your goal is to build a new data.table containing the room allocation for each subject, using the teachers and locations data.tables.
This exercise is part of the course
Joining Data with data.table in R
Exercise instructions
- Identify the key column(s) for joining
teachersandlocationsand assign it as a character vector in the formc("teachers_join_key" = "locations_join_key")to thejoin_keyvariable. - Using the
data.tablesyntax, right joinlocationstoteachersusing thejoin_keyvariable.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Identify and set the keys
join_key <- ___
# Right join
___