Exercise

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 school
  • guardians: 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.

Instructions 1/4

undefined XP
    1
    2
    3
    4

Use the merge() function to full join guardians to students using the "name" column as the join key. Do the results look correct?