I'm merging two excel sheets with sample data. Both sheets have a common column that I will be merging the data by (ex: student name). The problem I have is one of my sheets has 100 names whereas the other has 105 names. How can I determine what the extra 5 names are?
When I try to merge the two sheets together in R, I get this error message:
Error in data.frame(..., check.names = FALSE) :
arguments imply differing number of rows: 105, 100
I figured how to merge the 100 names and all of their data; however, I need to identify who was not included in the merge.