如何在R中基于存储全名对应关系的第三数据框合并两个击杀得分数据框
实现代码
首先构造和你示例一致的测试数据,方便直接运行验证:
# 构造三个测试数据框 kills1 <- data.frame( first_name = c("Matt", "John", "Chris"), first_kill = c(5, 6, 4), stringsAsFactors = FALSE ) kills2 <- data.frame( last_name = c("Wick", "Damon", "Rock"), last_kill = c(10, 3, 9), stringsAsFactors = FALSE ) fullnames <- data.frame( first_name = c("John", "Matt", "Chris"), last_name = c("Wick", "Damon", "Rock"), stringsAsFactors = FALSE )
基础R写法
# 第一步:关联姓名对应表和名对应的击杀得分 merge1 <- merge(fullnames, kills1, by = "first_name") # 第二步:关联姓氏对应的击杀得分 merge2 <- merge(merge1, kills2, by = "last_name") # 第三步:拼接全名,提取目标列 allkills <- data.frame( fullname = paste(merge2$first_name, merge2$last_name), first_kill = merge2$first_kill, last_kill = merge2$last_kill, stringsAsFactors = FALSE ) # 如需转换为你示例中的字符矩阵格式,额外执行: allkills_matrix <- as.matrix(allkills)
dplyr 简洁写法
library(dplyr) allkills <- fullnames %>% # 关联名对应击杀得分 left_join(kills1, by = "first_name") %>% # 关联姓氏对应击杀得分 left_join(kills2, by = "last_name") %>% # 生成全名字段 mutate(fullname = paste(first_name, last_name)) %>% # 按需求顺序选择输出列 select(fullname, first_kill, last_kill)
运行后得到的结果和你给出的期望输出完全匹配。
内容的提问来源于stack exchange,提问作者Mike de Groot
相关产品推荐
相关产品推荐

