R中基于多条件的两个数据帧的匹配值

# 创建两个示例数据帧
df1 <- data.frame(ID = c(1, 2, 3, 4),
                  Name = c("John", "Alice", "Bob", "Jane"),
                  Age = c(25, 30, 35, 40))

df2 <- data.frame(ID = c(2, 3, 4, 5),
                  Score = c(80, 85, 90, 95),
                  Grade = c("B", "A", "A", "A+"))

# 基于ID字段进行合并
merged_df <- merge(df1, df2, by = "ID")

# 打印合并结果
print(merged_df)

  ID Name Age Score Grade
1  2 Alice  30    80     B
2  3   Bob  35    85     A
3  4  Jane  40    90     A

library(dplyr)

# 基于ID字段进行合并
merged_df <- left_join(df1, df2, by = "ID")

# 打印合并结果
print(merged_df)