1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
| > df1 <- data.frame(c1 = c("Sample_100", "Sample_101", "Sample_102"))
> df1
c1
1 Sample_100
2 Sample_101
3 Sample_102
> df2 <- data.frame(c2 = c("300100", "300101", "300102"))
> df2
c2
1 300100
2 300101
3 300102
> df1$code1 <- substr(df1$c1, nchar(df1$c1) - 2, nchar(df1$c1))
> df1
c1 code1
1 Sample_100 100
2 Sample_101 101
3 Sample_102 102
> df2$code2 <- substr(df2$c2, nchar(df2$c2) - 2, nchar(df2$c2))
> df2
c2 code2
1 300100 100
2 300101 101
3 300102 102
> merge(df1, df2, by.x = "code1", by.y = "code2")
code1 c1 c2
1 100 Sample_100 300100
2 101 Sample_101 300101
3 102 Sample_102 300102
> |
Partager