从部分匹配变量值的向量返回字符串
从部分匹配变量值的向量返回字符串
提问于 2018-06-05 02:13:29
我有一个字符串向量：
keywords <- c("kw 1", "kw2", "kw3", "kw4", "kw5", "kw6", "kw7", "kw8",
"kw 9 kw", "kw10", "kw11", "kw12", "kw13", "kw14", "kw15")和具有空列关键字的数据框：
df <- data.frame("Description" = c("blabla kw10", "blabla kw15","blabla kw 1",
"blabla kw13", "blabla kw7", "kw2 bla", "kw8 blabla","bla kw11 bla",
"blabla kw10","blakw 9 kw", "blablakw4", "blakw 1bla"),
"Keyword" = NA)我需要找到一种方法来查找关键字向量中的字符串，该字符串与描述变量中的值部分匹配，并从关键字向量中返回该匹配字符串作为df数据帧中关键字列的值。
我需要此结果
df <- data.frame("Description" = c("blabla kw10", "blabla kw15","blabla kw 1",
"blabla kw13", "blabla kw7", "kw2 bla", "kw8 blabla","bla kw11 bla",
"blabla kw10","blakw 9 kw", "blablakw4", "blakw 1bla"),
"Keyword" = c("kw10", "kw15", "kw 1", "kw13", "kw7", "kw2", "kw8", "kw11", "kw10", "kw 9 kw", "kw4", "kw 1"))您能为此提出任何解决方案吗？
编辑：
keywords2矢量和df2数据帧的可重现示例：
keywords2 <- c("cartucho", "MOLDE", "FILTRO", "BOMBA", "MOTOR")
df2 <- data.frame("Description" = c("CULATA PARA MOTOR", "BOMBA CENTRIFUGA PARA LIQUIDOS",
" CARTUCHO FILTRANTE", "APARATO FILTRO MONITOR", "MOLDES PARA QUESO",
"BOMBA PERISTALTICA", "MOLDE CON TAPA Y DESUERADOR",
"APARATO FILTRO DE MEMBRANA", "BOMBA DE VACIO"),
"Keyword" = NA)预期结果：
df2 <- data.frame("Description" = c("CULATA PARA MOTOR", "BOMBA CENTRIFUGA PARA LIQUIDOS",
" CARTUCHO FILTRANTE", "APARATO FILTRO MONITOR", "MOLDES PARA QUESO",
"BOMBA PERISTALTICA", "MOLDE CON TAPA Y DESUERADOR",
"APARATO FILTRO DE MEMBRANA", "BOMBA DE VACIO"),
"Keyword" = c("MOTOR", "BOMBA", "cartucho", "FILTRO", "MOLDE", "BOMBA", "MOLDE", "FILTRO", "BOMBA")页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/50686493
复制相关文章
相似问题
腾讯云开发者
