'Merging 2 dataframes by common column values under a common column name in R

I want to merge two data frames that have the same column name and some similar values. I.e

         Dataframe 1                                  Dataframe 2
    ID    COLOUR   FRUIT                        ID    SHAPE   STATUS 
    A     Yellow   Apple                        A     Circle   On
    B     Blue     Banana                       B     Square   On
    C     Purple   Apple                        D     Triangle Off
    D     Orange   Grapes

I want to 1) compare the IDs of these two datagrams and keep the ones that occur in both data frames and remove the ones that don't overlap. 2) Combine the two data frames using the common values of the ID column. I tried to make the ID column into rownames, but since some of the IDs are duplicated in each of these data frames, I was unable to do that.

Any help is appreciated.

Thank you in advance!

Solution 1:^[1]

We are looking for a inner join here:

library(dplyr)

inner_join(`Dataframe 1`, `Datadrame 2`, by = 'ID')

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	GuedesBF

'Merging 2 dataframes by common column values under a common column name in R

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]