I want to coduct a forecast analysis on my dataset. Some insights into the dataset:
- I have 10 Products each having a specific Id Number. These numbers are random and dont have any pattern.
- Each product has data starting from the year 2016 till 2018 for each month. So, 36 Observation Points for each product.
All these products are present in a single dataset in the column format and a total of 300 rows (certain products have missing data):
Column names: Prod_Id Year Month Sales_data
Would appreciate a guidance on the optimal approach that can be taken?
I am thinking of the following:
- Create a new vector with the unique Product_Ids and use its length to create a Loop
- Perform the forecast Analysis for one of the products and contain it in a Loop for other variables.
I am absolutely new to R and would appreciate any help/suggestions.