CommencerCommencer gratuitement

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.

Cet exercice fait partie du cours

Joining Data with data.table in R

Afficher le cours

Instructions

  • Identify the key column(s) for joining teachers and locations and assign it as a character vector in the form c("teachers_join_key" = "locations_join_key") to the join_key variable.
  • Using the data.table syntax, right join locations to teachers using the join_key variable.

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

# Identify and set the keys
join_key <- ___

# Right join
___
Modifier et exécuter le code