Keys with different names
You have been contracted by a local school to perform some analysis using their internal databases. Two of those datasets are available in your R session:
students
: contains information about the students attending the schoolguardians
: contains information about the adult who is the primary point of contact for the school for each student.
Your goal is to build a new data.table
containing all the information about the guardian for each student.
This exercise is part of the course
Joining Data with data.table in R
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Full join
___