I have the following data frame:

[Data frame](https://i.stack.imgur.com/sAjHy.png)

Here both Hotel\_id and Chef\_Id are unique(both can act as a primary key).

I need to fill the missing rows in Month\_Year column(should add consecutive month\_year between first and last date for each id and then forward fill other corresponding column values, I need something like this:

[Expected data frame](https://i.stack.imgur.com/tB1NA.png)

Here I have explained for a few id's but I need to apply this concept for every id in the data frame.

Please let me know the solution.

---

@r-beginners, Please find the below data for your reference:

```
Hotel_id    Month_Year      last_review_date
2400614     May-2015        March-2016
2400614     June-2015       March-2016
2400614     December-2015   March-2016
2400614     January-2016    March-2016
2400614     March-2016      March-2016
2400133     April-2016      May-2017
2400133     June-2016       May-2017
2400133     August-2016     May-2017
2400133     January-2017    May-2017
2400133     April-2017      May-2017
2400133     May-2017        May-2017
2400178     June-2015       April-2018
2400178     July-2016       April-2018
2400178     August-2016     April-2018
2400178     January-2017    April-2018
2400178     March-2017      April-2018
2400178     April-2018      April-2018

```