我试图在几个月和几个小时内汇总(和)值,并重新排列汇总的数据,以便小时和月在不同的“轴”上。我希望小时是列标题,和月份是行标题,包含每个单元格中的求和值。下面是我的意思,通过一个虚拟数据示例(很明显,在实际数据中有12个月,24小时):
Month <- c(1,1,2,2,3,3,3,4,4,4,5,5,5,5,6,7,8,9,10,11,12)
Hour <- c(4,1,3,2,5,5,1,4,3,6,0,0,2,3,1,2,3,4,5,6,2)
Value <- c(0.1,0.4,0.02,0.1,0.1,0.2,0.02,0.01,0.01,0.02,0.1,0.