使用R中的新数据帧更新旧数据帧

# 创建旧数据帧
old_df <- data.frame(ID = c(1, 2, 3),
                     Name = c("John", "Jane", "Tom"),
                     Age = c(25, 30, 35))

# 创建新数据帧
new_df <- data.frame(ID = c(2, 3, 4),
                     Name = c("Mary", "David", "Linda"),
                     Age = c(28, 33, 40))

# 使用merge()函数更新旧数据帧
updated_df <- merge(old_df, new_df, by = "ID", all = TRUE)

# 输出更新后的数据帧
print(updated_df)

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

# 创建旧数据帧
old_df <- data.frame(ID = c(1, 2, 3),
                     Name = c("John", "Jane", "Tom"),
                     Age = c(25, 30, 35))

# 创建新数据帧
new_df <- data.frame(ID = c(2, 3, 4),
                     Name = c("Mary", "David", "Linda"),
                     Age = c(28, 33, 40))

# 使用left_join()函数更新旧数据帧
updated_df <- left_join(old_df, new_df, by = "ID")

# 输出更新后的数据帧
print(updated_df)