如何合并R中具有不同列名的两个数据集？

# 创建示例数据集
df1 <- data.frame(id = 1:3, name = c("Alice", "Bob", "Charlie"))
df2 <- data.frame(id = 1:3, age = c(25, 30, 35), city = c("New York", "Los Angeles", "Chicago"))

# 合并数据集
merged_df <- merge(df1, df2, by = "id")

# 查看合并后的数据集
print(merged_df)

install.packages("dplyr")
library(dplyr)

# 创建示例数据集
df1 <- data.frame(id = 1:3, name = c("Alice", "Bob", "Charlie"))
df2 <- data.frame(id = 1:3, age = c(25, 30, 35), city = c("New York", "Los Angeles", "Chicago"))

# 使用left_join()合并数据集
merged_df <- left_join(df1, df2, by = "id")

# 查看合并后的数据集
print(merged_df)

# 重命名df2中的列名
df2 <- rename(df2, id = ID)

# 然后进行合并
merged_df <- merge(df1, df2, by = "id")

# 将df1中的id列转换为数值型
df1$id <- as.numeric(df1$id)

# 然后进行合并
merged_df <- merge(df1, df2, by = "id")