R语言-merge()的使用

with_love77

墨衍会员 · AI 创作全网分发码龄10年

关注

转载最新推荐文章于 2025-08-24 11:08:36 发布 2.7w 阅读 AI 写同款· GEO 优化 ›

限时加码！20+主流AI编程工具免费用购周边加赠Coding Plan Lite，Claude Code、Cursor等即刻畅享，学习进阶更高效！阅读详情

df1 = data.frame(CustomerId=c(1:6),Product=c(rep("Toaster",3),rep("Radio",3)))

df2 = data.frame(CustomerId=c(2,4,6,7),State=c(rep("Alabama",3),rep("Ohio",1)))

> df1
CustomerId Product
1 1 Toaster
2 2 Toaster
3 3 Toaster
4 4 Radio
5 5 Radio
6 6 Radio

> df2
CustomerId State
1 2 Alabama
2 4 Alabama
3 6 Alabama
4 7 Ohio

> merge(df1, df2, all=TRUE) #取并集，重复的不加(cbind重复的显示重复)
CustomerId Product State
1 1 Toaster <NA>
2 2 Toaster Alabama
3 3 Toaster <NA>
4 4 Radio Alabama
5 5 Radio <NA>
6 6 Radio Alabama
7 7 <NA> Ohio

#full join的效果

> merge(df1,df2,all=FALSE)#取交集
CustomerId Product State
1 2 Toaster Alabama
2 4 Radio Alabama
3 6 Radio Alabama

> merge(df2,df1,all=FALSE)#只是列先后的区别
CustomerId State Product
1 2 Alabama Toaster
2 4 Alabama Radio
3 6 Alabama Radio

> merge(df1, df2, all.x=TRUE)#以df1所拥有的显示

CustomerId Product State
1 1 Toaster <NA>
2 2 Toaster Alabama
3 3 Toaster <NA>
4 4 Radio Alabama
5 5 Radio <NA>
6 6 Radio Alabama

#left join的效果

df1
id heights sex
1 2 62 f
2 3 65 m
3 4 71 f
4 5 71 f
5 7 67 m
> df2
id weights sex
1 1 147 f
2 2 113 f
3 6 168 m
4 7 135 m
5 8 142 f
6 9 159 f
7 10 160 f
> merge(df1,df2)#有两个及以上相同的列，合并则会自动选择两个均相同的，结果同merge(df1, df2, by = c("id", "sex"))
id sex heights weights
1 2 f 62 113
2 7 m 67 135