ID1 | ID2 | ID3 | time | value |
3 | 145834 | 211552 | 2001/10/26 14:00 | 80 |
3 | 145834 | 211552 | 2001/10/26 15:00 | 200 |
3 | 145834 | 211552 | 2001/10/26 16:00 | 45 |
3 | 145834 | 211552 | 2001/10/26 17:00 | 60 |
6 | 107064 | 228232 | 1975/5/30 22:00 | 140 |
6 | 107064 | 228232 | 1975/5/30 23:00 | 160 |
6 | 107064 | 228232 | 1975/5/31 0:00 | 120 |
6 | 107064 | 228232 | 1975/5/31 1:00 | 140 |
6 | 107064 | 228232 | 1975/5/31 2:00 | 100 |
6 | 107064 | 228232 | 1975/5/31 3:00 | 100 |
6 | 107064 | 228232 | 1975/5/31 4:00 | 70 |
6 | 107064 | 228232 | 1975/5/31 5:00 | 70 |
6 | 107064 | 228232 | 1975/5/31 6:00 | 70 |
6 | 107064 | 228232 | 1975/5/31 7:00 | 50 |
6 | 107064 | 228232 | 1975/5/31 8:00 | 60 |
6 | 107064 | 228232 | 1975/5/31 9:00 | 35 |
6 | 107064 | 228232 | 1975/5/31 10:00 | 30 |
6 | 107064 | 228232 | 1975/5/31 11:00 | 25 |
6 | 107064 | 228232 | 1975/5/31 12:00 | 65 |
6 | 107064 | 228232 | 1975/5/31 13:00 | 65 |
6 | 107064 | 228232 | 1975/5/31 14:00 | 70 |
6 | 107064 | 228232 | 1975/5/31 15:00 | 80 |
6 | 107064 | 228232 | 1975/5/31 16:00 | 80 |
6 | 107064 | 228232 | 1975/5/31 17:00 | 90 |
6 | 107064 | 228232 | 1975/5/31 18:00 | 85 |
6 | 107064 | 228232 | 1975/5/31 19:00 | 55 |
6 | 107064 | 228232 | 1975/5/31 20:00 | 100 |
6 | 107064 | 228232 | 1975/5/31 21:00 | 80 |
6 | 107064 | 228232 | 1975/5/31 22:00 | 80 |
6 | 107064 | 228232 | 1975/5/31 23:00 | 80 |
如上表所示,有三个id,现在我想要计算着三个id相同时的各value的总和。但有时间限定,求的是前24小时内的总和。但是有些时间跨度超过了24小时,那么超过的部分舍弃不要,只取24小时求和;有些时间跨度不足24小时,不足的部分由前面的总和均数乘以所缺的时间来补上。这在R语言该怎么做呢?怎么写循环语句?新手求教!