r - 聚合多个时间序列
问题描述
我试图通过将 30 个时间序列组合到 1 个整体序列来简化我的时间序列数据。换句话说,我想改变我的数据:
Province Date Confirmed
1 Anhui 2020-01-21 0
2 Anhui 2020-01-22 0
3 Anhui 2020-01-23 0
4 Anhui 2020-01-24 6
5 Anhui 2020-01-25 24
6 Anhui 2020-01-26 45
7 Anhui 2020-01-27 55
8 Anhui 2020-01-28 91
9 Anhui 2020-01-29 137
10 Anhui 2020-01-30 200
11 Anhui 2020-01-31 237
12 Anhui 2020-02-01 297
13 Anhui 2020-02-02 340
14 Anhui 2020-02-03 408
15 Anhui 2020-02-04 480
16 Anhui 2020-02-05 530
17 Anhui 2020-02-06 591
18 Anhui 2020-02-07 665
19 Anhui 2020-02-08 733
20 Anhui 2020-02-09 779
21 Anhui 2020-02-10 830
22 Anhui 2020-02-11 860
23 Anhui 2020-02-12 889
24 Beijing 2020-01-21 5
25 Beijing 2020-01-22 5
26 Beijing 2020-01-23 10
27 Beijing 2020-01-24 20
28 Beijing 2020-01-25 35
29 Beijing 2020-01-26 47
30 Beijing 2020-01-27 59
类似于:
Date Confirmed
2020-01-21 5
2020-01-22 0
2020-01-23 10
2020-01-24 26
2020-01-25 59
2020-01-26 92
.
.
.
基本上我想在各自的日期之前为每个省添加所有“确认”值。有人可以指导我吗?
解决方案
我们可以用aggregate
aggregate(Confirmed ~ Date, df1, sum)
如果 'Province' 也是一个分组列
aggregate(Confirmed ~ Date + Province, df1, sum)
推荐阅读
- dockerfile - 镜像构建后容器中的数据挂载可见,但其中没有数据
- sql - 如何聚合来自动态表查询的查询结果
- google-sheets - 将单元格与其他单元格进行比较并返回差异
- python - 3D CNN 中的 Input_shape
- c# - 手榴弹在错误的位置生成
- python - I'm getting module 'cv2.cv2' has no attribute 'legacy' ERROR. How can I fix it?
- c# - EF Core duplicate keys: The instance of entity type '' cannot be tracked because another instance with the key value '' is already being tracked
- python - The python code isn't showing desired output , where is the problem?
- typescript - useStore() method always leading to undefined value within components
- javascript - Stop Cron Job inside the scheduler Node.js