通过R自动将数据帧中缺少的行添加到现有数据帧中

# 创建两个数据框
df1 <- data.frame(ID = c(1, 2, 3), Name = c("Alice", "Bob", "Charlie"))
df2 <- data.frame(ID = c(2, 3, 4), Age = c(25, 30, 35))

# 使用merge()函数合并数据框
merged_df <- merge(df1, df2, by = "ID", all = TRUE)

# 输出合并后的数据框
print(merged_df)

  ID   Name Age
1  1  Alice  NA
2  2    Bob  25
3  3 Charlie  30
4  4     NA  35

# 安装并加载dplyr包
install.packages("dplyr")
library(dplyr)

# 创建两个数据框
df1 <- data.frame(ID = c(1, 2, 3), Name = c("Alice", "Bob", "Charlie"))
df2 <- data.frame(ID = c(2, 3, 4), Age = c(25, 30, 35))

# 使用left_join()函数合并数据框
merged_df <- left_join(df1, df2, by = "ID")

# 输出合并后的数据框
print(merged_df)

  ID   Name Age
1  1  Alice  NA
2  2    Bob  25
3  3 Charlie  30