merge r语言daframe_R语言merge函数总结

写sql写习惯了，学R的时候也想用到类似sql里面的merge功能，看了r帮助文档后进行了一些总结

以r文档里面的例子来介绍，假如有这样两个数据框authors和books

authors

surname = I(c("Tukey", "Venables", "Tierney", "Ripley", "McNeil")),

nationality = c("US", "Australia", "US", "UK", "Australia"),

deceased = c("yes", rep("no", 4)))

books

name = I(c("Tukey", "Venables", "Tierney",

"Ripley", "Ripley", "McNeil", "R Core")),

title = c("Exploratory Data Analysis",

"Modern Applied Statistics ...",

"LISP-STAT",

"Spatial Statistics", "Stochastic Simulation",

"Interactive Data Analysis",

"An Introduction to R"),

other.author = c(NA, "Ripley", NA, NA, NA, NA,

"Venables & Smith"))

如果要实现类似sql里面的inner join 功能，则用代码

m1

如果要实现left join功能则用代码

m1

right join功能代码

m1

all join功能代码

m1

关于单变量匹配的总结就是这些，但对于多变量匹配呢，例如下面两个表，需要对k1,k2两个变量都相等的情况下匹配

x

y

匹配代码如下merge(x, y, by = c("k1","k2"))  #inner join