我正在try 合并/加入两个收件箱df
和df2
.
df
是从在每个position
(第4、第10、第12、.)处切割的字符载体生成的字符)变成string
.初始的载体看起来像这样
vec1 <- paste(df$string, collapse = "")
.
df2
的name
对应于vec1
中的一些字符.例如,vec1
中的第三个和第五个字符是P
和A
,而names
分别是pear
和apple
.
df <- data.frame("position" = c(4, 10, 12, 20, 27, 30),
"string" = c("MPPA", "APARLA", "LA", "LGLGLWLG", "ALAGGPG", "RGC"))
df2 <- data.frame("character" = c("P", "A", "L", "A", "P", "G"),
"position" = c(3, 5, 9, 21, 26, 29),
"name" = c("pear", "apple", "lemon", "apricot", "peach", "grape"))
我想将df
和df2
合并为df3
,以显示df
中的string
有name
,如下所示.什么是做到这一点的好方法?
df3 <- data.frame("position" = c(4, 10, 12, 20, 27, 30),
"string" = c("MPPA", "APARLA", "LA", "LGLGLWLG", "ALAGGPG", "RGC"),
"name" = c("pear", "apple, lemon", NA, NA, "apricot, peach", "grape"))