Question: he discussion board assignment for this week is about fitting a Prophet model to the imputed sales data. You may skip the model training and

he discussion board assignment for this week is about fitting a Prophet model to the imputed sales data. You may skip the model training and testing steps and proceed directly to fitting a Prophet model to each SKU using the entire imputed time series.
Follow these steps to complete the assignment:
Part I: Data Preparation
Begin by creating a new Jupyter Notebook to execute the required Python code. Ensure to incorporate comments for clarity.
Write a Python statement to import the data file Data Analytics Forecasting.xlsx Download Data Analytics Forecasting.xlsx, which serves as the dataset for the data analytics project. Make sure you import the necessary Python libraries.
Subset the data file to retain specific SKUs: S41948, S1A174, S1A0A2, S42048, and S42049.
For each SKU, employ the deletion method to eliminate the initial few years of data where a substantial number of entries contain missing values. Consider generating a time series plot to aid in determining the appropriate point to split the data.
If necessary, apply the linear imputation method to fill in the remaining missing values for each SKU.
For each SKU, save the imputed data to an Excel file. This imputed data will be used for building a Prophet model in Part II.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!