现在是 2020 年 1 月 12 日:参考链接:Merging a lot of data.frames [duplicate]merge.html当列名相同时第一种方法:df1 = data.frame(id = c('1','73','2','10','43'),
v1 = c(1,2,3,4,5))
df1
df2 = data.frame(id = c('7','23','57','2','62','96'),
v2 = c(1,2,3,4,5,6))
df2
df3 = data.frame(id = c('23','62'),
v3 = c(1,2))
df3
Reduce(function(x, y) merge(x, y, all=TRUE),
list(df1, df2, df3))
id v1 v2 v3
1 1 1 NA NA
2 10 4 NA NA
3 2 3 4 NA
4 43 5 NA NA
5 73 2 NA NA
6 23 NA 2 1
7 57 NA 3 NA
8 62 NA 5 2
9 7 NA 1 NA
10 96 NA 6 NA
# 或者
Reduce(function(...) merge(..., all=TRUE),
list(df1, df2, df3))
# 其实上面拆开就是拆开就是
merge(merge(df1, df2, by = 'id', all = T), df3,
by = 'id', all = T)第二种方法:插曲: 动态图见:R 语言中 dplyr 包 jion 函数之目前我看到过的最形象的教程inner_join(): 相当于交集left_join():字面意思
………………………………