I am trying to merge cross-listed courses into one line. I am unsure how to solve this issue in R. I have two datasets and what I call a “crosswalk” (I am not sure that is the correct term). Dataset1 lists courses a college offers, and Dataset2 contains courses offered by other colleges on the same campus. The crosswalk shows courses taught under multiple course numbers. For example, BIOS775 and STAT771 are considered cross-listed because they cover the same material.

I must devise a way to match these courses and determine their total counts. I have a list of cross-listed courses—the term, instructor, building, sections, and room for these courses to match correctly.

Since I don’t have any R code to present. Here is a link to the data and how I will need it to look at the end. The names of our instructors have been removed for privacy.

I understand that this poses many nuanced issues. If someone can show me the matching part, I can take it from there. Any help you can provide is greatly appreciated.