如何统一r中具有不同列的多个数据帧之间的列?

使用id绑定行,然后筛选所需的id,然后取消选择id

library(tidyverse)
df1 %>% bind_rows( df2, .id = "id" ) %>%
  filter( id == 2 ) %>%
  select( -id )

  a  b  c
1 1 NA 11
2 2 NA 12
3 3 NA 13
4 4 NA 14
5 5 NA 15

这是一个基r解

# Create skeleton data.frame based on df1
# and fill with NAs
df.new <- df1;
df.new[] <- NA;

# Fill with entries from df2
df.new[colnames(df2)] <- df2;
#  a  b  c
#1 1 NA 11
#2 2 NA 12
#3 3 NA 13
#4 4 NA 14
#5 5 NA 15

一个选项 base-R 可以通过使用 merge 在数据帧上,然后 intersect 列名上方为:

df_new <- merge(df1, df2)
df_new[,!(names(df_new) %in% intersect(names(df1), names(df2)))] <- NA
df_new
#   a  c  b
# 1 1 11 NA
# 2 2 12 NA
# 3 3 13 NA
# 4 4 14 NA
# 5 5 15 NA

一 dplyr 基于此的解决方案可以是:

library(dplyr)

merge(df1, df2) %>% 
  mutate_at(vars(-one_of(intersect(names(df1), names(df2)))),
                                      funs(replace(.,!is.na(.),NA)))

#   a  c  b
# 1 1 11 NA
# 2 2 12 NA
# 3 3 13 NA
# 4 4 14 NA
# 5 5 15 NA