Replace string by match to another data frame

Question

I want to replace the strings in column ID of df2 with the column genus of df1 based on the matching string in column species in df1. Any tips appreciated, especially dplyr. Maybe left_join?

> df1
             genus                 species
1  Orthobunyavirus           Variola virus
2 Alphatorquevirus     Torque teno virus 6
3     Yatapoxvirus Yaba-like disease virus

.

> df2
                       ID
1           Variola virus
2     Torque teno virus 6
3 Yaba-like disease virus

.

desired out
                         ID
1           Orthobunyavirus
2          Alphatorquevirus
3              Yatapoxvirus

> dput(df1)
structure(list(genus = c("Orthobunyavirus", "Alphatorquevirus", 
"Yatapoxvirus"), species = c("Variola virus", "Torque teno virus 6", 
"Yaba-like disease virus")), class = "data.frame", row.names = c(NA, 
-3L))
> dput(df2)
structure(list(ID = c("Variola virus", "Torque teno virus 6", 
"Yaba-like disease virus")), class = "data.frame", row.names = c(NA, 
-3L))

Allan Cameron · Accepted Answer · 2022-09-29 09:59:04Z

3

You could simply use match

df2$ID <- df1$genus[match(df2$ID, df1$species)]

df2
#>                 ID
#> 1  Orthobunyavirus
#> 2 Alphatorquevirus
#> 3     Yatapoxvirus

edited Sep 29, 2022 at 9:59

answered Sep 29, 2022 at 9:50

Allan Cameron

178k7 gold badges70 silver badges118 bronze badges

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

Comments

PGSA · Accepted Answer · 2022-09-29 09:56:41Z

1

df2$ID <- df1$genus[match(df2$ID,df1$species)]

replaces it, removing your original df2 data

df3 <- data.frame(ID = df1$genus[match(df2$ID,df1$species)])

creates a third df with the results.

answered Sep 29, 2022 at 9:56

PGSA

3,1011 gold badge10 silver badges24 bronze badges

Collectives™ on Stack Overflow

Replace string by match to another data frame

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