Merge Data Frames by Two ID Columns in R (2 Examples) | merge() vs. join() Function of dplyr Package

R code of this video:

ID2 = letters[1:5],
x1 = c(4, 1, 6, 7, 8),
x2 = 9)

ID2 = letters[3:7],
y1 = c(4, 4, 5, 1, 1),
y2 = 5)

data_merge1 ＜- merge(data1, data2, by = c("ID1", "ID2")) # Applying merge() function

library("dplyr") # Load dplyr package

data_merge2 ＜- inner_join(data1, data2, by = c("ID1", "ID2")) # Applying inner_join() function

Follow me on Social Media:

[robertjones]

You have a very effective teaching style which I appreciate. Clear concise practical examples. Thank you.

[kelseymariel]

Love your channel. I’m new to R and will need to merge two data frames shortly for a project I am doing. This was an excellent primer on the prices. Thank you!

[paulalezama]

Thank you, these are helpful overall. Though, I wish people will explain how to solve problems, all of the examples are so neat that one encounters issues and have not idea how to solve.

[agsoutas]

Thanks for the tutorial Joachim, always great for keeping my R skills sharp!!

[djrisks]

Thanks for this. I'm new to R, and I was able to understand this.

[bridgettsmith]

Thank you for the video. I enjoyed this quick lesson

[Enjoytheshow-]

hey Globe, if I merge data frames by either ID1 or ID2, is it possible? Now I have two datasets. Some people gave their phone number, some people gave their email address, some people gave both, some people put their email address into the cell of phone number. I have merge these two data set.

[yousif_alyousifi]

If the names of the columns are the same in both data frames. Can we use rbind or we would use the merge function?

[seagul]

My merge works and there is a new file with all the columns but not data. (it worked in a different merge)