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

Question

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!

Sweepy Dodo · Accepted Answer · 2022-11-27 17:23:50Z

3

library(data.table)

# set as data.table
lapply(list(df1, df2), \(i) setDT(i))

# inner join
df1[df2, on=.(ID), nomatch=0]

edited Nov 27, 2022 at 17:23

answered Feb 3, 2022 at 22:00

Sweepy Dodo

1,89114 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

GuedesBF · Accepted Answer · 2022-02-03 22:01:22Z

2

We are looking for a inner join here:

library(dplyr)

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

answered Feb 3, 2022 at 22:01

GuedesBF

9,9515 gold badges23 silver badges42 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related