使用部分匹配的字符串合并两个data.frame

# 创建两个示例的data.frame
df1 <- data.frame(ID = c(1, 2, 3),
                  Name = c("Alice", "Bob", "Charlie"),
                  Score = c(90, 85, 95))

df2 <- data.frame(ID = c(1, 2, 4),
                  Age = c(25, 30, 20),
                  Grade = c("A", "B", "C"))

# 使用merge()函数合并两个data.frame
merged_df <- merge(df1, df2, by = "ID", all = TRUE)

# 输出合并后的data.frame
print(merged_df)

  ID    Name Score Age Grade
1  1   Alice    90  25     A
2  2     Bob    85  30     B
3  3 Charlie    95  NA  <NA>
4  4    <NA>    NA  20     C