How do I combine two data-frames based on two columns?

Question

I know I can use the plyr and its friends to combine dataframes, and merge as well, but so far I don't know how to merge two dataframes with multiple columns based on 2 columns?

user_10630705 · Answer

You can also use the join command (dplyr).

For example:

new_dataset <- dataset1 %>% right_join(dataset2, by=c("column1","column2"))

How do I combine two data-frames based on two columns?

3 Answers