Conditional subset with two variables at once?

General
,
#1

Hello,

I have dataframe df1, how can I keep it's rows only if both Name1 and Name2 appear in df2?

Illustration below:

image
image848×294 4.92 KB

I've tried subsetting but can't make it work with two variables at once. I want to perform the action, "df3 is df1 but only where df1$Name1 and df1$Name2 both exist as columns of df2.

Thanks!

#2

Try this:

library(dplyr)
name_list <- colnames(df2)
df1 %>% 
  filter(Name1 %in% name_list, Name2 %in% name_list) -> df1_subset

Let me know if it works!

1 Like
#4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

#3

This worked beautifully. Thanks for the help, Erica!