# 一个工作簿有两张表sheet1和sheet2
sheet1 = data.frame(x = c(1, 2), y =c(6, 7))
sheet2 = data.frame(x = c(3, 4, 5), y =c(8, 9, 10))
# 把两张表的数据汇总到一张表里
result1 = data.frame(
x = c(1, 2, 3, 4, 5),
y = c(6, 7, 8, 9, 10)
)
result1缺失了一些信息,比如每行数据的数据来源。
我希望的结果是
result2 = data.frame(
x = c(1, 2, 3, 4, 5),
y = c(6, 7, 8, 9, 10),
src = c("sheet1", "sheet1", "sheet2", "sheet2", "sheet2")
)