Pandas duplicate data between 2 dates
you can move in all row data and check data_start is preset start duplicated and when present the date_end can you exit the loop
Thanks
I'm trying to find a method of duplicating all of the data in a row for every month between dates. Start date and end date.
This is the dataset:




ID
Start
End




1007
2022-03-01
2022-08-01


1008
2019-11-01
2020-02-01




What I would like to do is repeat the row, incrementing the date, every month between the start and end values.
Example outcome:




ID
Start
End




1007
2022-03-01
2022-08-01


1007
2022-04-01
2022-08-01


1007
2022-05-01
2022-08-01


1007
2022-06-01
2022-08-01


1007
2022-07-01
2022-08-01


1007
2022-08-01
2022-08-01


1008
2019-11-01
2020-02-01


1008
2019-12-01
2020-02-01


1008
2020-01-01
2020-02-01


1008
2020-02-01
2020-02-01




Thanks