我有以下数据框:
| id | date_start | date_end | reporting_month | reporting_month_number | months_length |
|---|---|---|---|---|---|
| 1 | 2022-03-31 23:56:22 | 2022-05-01 23:56:22 | 2022-03 | 1 | 3 |
| 2 | 2022-03-31 23:48:48 | 2022-06-01 23:48:48 | 2022-03 | 1 | 4 |
| 3 | 2022-03-31 23:47:36 | 2022-08-01 23:47:36 | 2022-03 | 1 | 6 |
我想要拆分每个id行，这样从日期reporting_month开始，我就可以为months_length个ID行中的每一个分配一行，如下所示:
| id | date_start | date_end | reporting_month | reporting_month_number | months_length |
|---|---|---|---|---|---|
| 1 | 2022-03-31 23:56:22 | 2022-05-01 23:56:22 | 2022-03 | 1 | 3 |
| 1 | 2022-03-31 23:56:22 | 2022-05-01 23:56:22 | 2022-04 | 2 | 3 |
| 1 | 2022-03-31 23:56:22 | 2022-05-01 23:56:22 | 2022-05 | 3 | 3 |
| 2 | 2022-03-31 23:48:48 | 2022-06-01 23:48:48 | 2022-03 | 1 | 4 |
| 2 | 2022-03-31 23:48:48 | 2022-06-01 23:48:48 | 2022-03 | 2 | 4 |
| 2 | 2022-03-31 23:48:48 | 2022-06-01 23:48:48 | 2022-04 | 3 | 4 |
| 2 | 2022-03-31 23:48:48 | 2022-06-01 23:48:48 | 2022-05 | 4 | 4 |
| 3 | 2022-03-31 23:47:36 | 2022-08-01 23:47:36 | 2022-03 | 1 | 6 |
| 3 | 2022-03-31 23:47:36 | 2022-08-01 23:47:36 | 2022-04 | 2 | 6 |
| 3 | 2022-03-31 23:47:36 | 2022-08-01 23:47:36 | 2022-05 | 3 | 6 |
| 3 | 2022-03-31 23:47:36 | 2022-08-01 23:47:36 | 2022-06 | 4 | 6 |
| 3 | 2022-03-31 23:47:36 | 2022-08-01 23:47:36 | 2022-07 | 5 | 6 |
| 3 | 2022-03-31 23:47:36 | 2022-08-01 23:47:36 | 2022-08 | 6 | 6 |
我try 了几种方法，但似乎都达不到我的目标.
有谁对如何实现这一点有什么建议吗？
谢谢.