让我们说我有以下熊猫数据框:
+---------------------+---------+-------+-----+
| observed_cats_count | year | month | day |
+---------------------+---------+-------+-----+
| 2 | 2019 | 10 | 19 |
| 3 | 2019 | 10 | 18 |
| 5 | 2019 | 10 | 16 |
+---------------------+---------+-------+-----+
还有两个边界日期,例如2019-10-15
和2019-10-20
,我知道所有缺失的观测值都应具有observed_cats_count=0
。
如何为间隔中的所有缺失日期插入一行并获取以下数据框:
+---------------------+---------+-------+-----+
| observed_cats_count | year | month | day |
+---------------------+---------+-------+-----+
| 0 | 2019 | 10 | 20 |
| 2 | 2019 | 10 | 19 |
| 3 | 2019 | 10 | 18 |
| 0 | 2019 | 10 | 17 |
| 5 | 2019 | 10 | 16 |
| 0 | 2019 | 10 | 15 |
+---------------------+---------+-------+-----+