我正在使用一个每周数据框架,我想在其中总结每日数据
我有两个数据帧:
df:
{'start_date': {0: Timestamp('2018-11-05 00:00:00'),
1: Timestamp('2018-11-12 00:00:00'),
2: Timestamp('2018-11-19 00:00:00'),
3: Timestamp('2018-11-26 00:00:00'),
4: Timestamp('2018-12-03 00:00:00'),
5: Timestamp('2018-12-10 00:00:00'),
6: Timestamp('2018-12-17 00:00:00'),
7: Timestamp('2018-12-24 00:00:00'),
8: Timestamp('2018-12-31 00:00:00'),
9: Timestamp('2019-01-07 00:00:00'),
10: Timestamp('2019-01-14 00:00:00'),
11: Timestamp('2019-01-21 00:00:00'),
12: Timestamp('2019-01-28 00:00:00')},
'woy': {0: 45,
1: 46,
2: 47,
3: 48,
4: 49,
5: 50,
6: 51,
7: 52,
8: 1,
9: 2,
10: 3,
11: 4,
12: 5}}
df_学校_vac:
{'timestamp_area_A': {0: Timestamp('2018-12-22 00:00:00'),
1: Timestamp('2018-12-23 00:00:00'),
2: Timestamp('2018-12-24 00:00:00'),
3: Timestamp('2018-12-25 00:00:00'),
4: Timestamp('2018-12-26 00:00:00'),
5: Timestamp('2018-12-27 00:00:00'),
6: Timestamp('2018-12-28 00:00:00'),
7: Timestamp('2018-12-29 00:00:00'),
8: Timestamp('2018-12-30 00:00:00'),
9: Timestamp('2018-12-31 00:00:00'),
10: Timestamp('2019-01-01 00:00:00'),
11: Timestamp('2019-01-02 00:00:00'),
12: Timestamp('2019-01-03 00:00:00'),
13: Timestamp('2019-01-04 00:00:00'),
14: Timestamp('2019-01-05 00:00:00'),
15: Timestamp('2019-01-06 00:00:00')},
'vacation_name': {0: 'Vacances de Noël',
1: 'Vacances de Noël',
2: 'Vacances de Noël',
3: 'Vacances de Noël',
4: 'Vacances de Noël',
5: 'Vacances de Noël',
6: 'Vacances de Noël',
7: 'Vacances de Noël',
8: 'Vacances de Noël',
9: 'Vacances de Noël',
10: 'Vacances de Noël',
11: 'Vacances de Noël',
12: 'Vacances de Noël',
13: 'Vacances de Noël',
14: 'Vacances de Noël',
15: 'Vacances de Noël'},
'woy': {0: 51,
1: 51,
2: 52,
3: 52,
4: 52,
5: 52,
6: 52,
7: 52,
8: 52,
9: 1,
10: 1,
11: 1,
12: 1,
13: 1,
14: 1,
15: 1}}
考虑在 dfl ChansVac星期一周开始计数,然后使用周水平DF:运行左结合^ {CD2>}:
相关问题 更多 >
编程相关推荐