R-合并/合并具有相同名称但某些数据值等于零的列

# 创建两个数据框
df1 <- data.frame(ID = c(1, 2, 3),
                  Value1 = c(10, 20, 30),
                  Value2 = c(0, 0, 0))

df2 <- data.frame(ID = c(1, 2, 3),
                  Value1 = c(0, 0, 0),
                  Value2 = c(100, 200, 300))

# 合并具有相同名称但某些数据值等于零的列
merged_df <- merge(df1, df2, by = "ID")

# 输出合并后的结果
print(merged_df)

  ID Value1.x Value2.x Value1.y Value2.y
1  1       10        0        0      100
2  2       20        0        0      200
3  3       30        0        0      300