R Match two string columns between two different dataframes

Question

I have 'df1' with data that look like this:

Object	Thing
apple tini	drink
vodka cran	beverage
tom collins	alcohol
arnie palmer	cocktail

And I have 'df2' with data that look like this:

Object1	Thing1
apple tini	drink
vodka cran	bever
tom collins	alc
arnie palmer	cocktail

I am looking to check and see if Object and Thing from df1 match any Object1 and Thing1 from df2, and if they do match, a 1 is created in a new column in df1 and if they don't, a 0 is created, so that it looks like this:

Object	Thing	Value
apple tini	drink	1
vodka cran	beverage	0
tom collins	alc	0
arnie palmer	cocktail	1

Note that columns are intentionally different in case they don't match is the actual dataframe.

Thank you!

dcsuka · Accepted Answer · 2022-08-31 22:43:22Z

1

Making an extra column and then left_joining solves this:

library(tidyverse)

df3 <- mutate(df2, Value = 1)

left_join(df1, df3, by=c("Object" = "Object1",
                         "Thing" = "Thing1")) %>%
  mutate(Value = replace_na(Value, 0))

#    Object    Thing Value
# 1    tini    drink     1
# 2    cran beverage     0
# 3 collins  alcohol     0
# 4  palmer cocktail     1

answered Aug 31, 2022 at 22:43

dcsuka

3,0073 gold badges8 silver badges28 bronze badges

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

1 Comment

Jacob Over a year ago

My dataset is quite large, so I could be missing something, but it seems to work just fine. Will update if I see any issues. Thank you very much!

Collectives™ on Stack Overflow

R Match two string columns between two different dataframes

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related