Firstly, I am sorry if my question is so basic but I am new to STATA. I am trying to analyze hotel responses to customers on an online travelling platform. I collected 9 years of data and ordered it on a monthly basis. However, some data is missing because either some hotels did not provide a response in a single month or they started providing responses years later, which leads to unbalanced data. The data looks like this;
| Hotel | Date | Average Response Length | Average Response Speed | Average Customer Rating |
| A | 2010-1-1 | 100 | 5 | 4.2 |
| A | 2010-5-1 | 120 | 4 | 4.3 |
| A | 2010-8-1 | 110 | 6 | 4.5 |
| A | 2010-9-1 | 150 | 1 | 3.8 |
| A | 2010-10-1 | 155 | 3 | 3.9 |
| B | 2016-6-1 | 250 | 5 | 4.1 |
| B | 2016-7-1 | 240 | 7 | 4.5 |
| B | 2016-8-1 | 290 | 2 | 4.6 |
| C | 2012-1-1 | 120 | 4 | 4.3 |
| C | 2012-2-1 | 150 | 7 | 4.2 |
| C | 2012-4-1 | 140 | 5 | 4.3 |
So, my question is whether I can apply an unbalanced panel approach to this type of data. As such, there are lots of missing values annually between panels, and monthly within panels. P.S. The data is large and more continuous than the example above (each panel has at least one 6 consecutive observations).
Thank you in advance, and again sorry if I occupy you with a basic question.
0 Response to Monthly panel data with missing values of annual between panels, and monthly within panels
Post a Comment