End to End Project - Forecast Sales Quantities (Optional)

#1
  1. Consider only sales values greater than 20
  2. Divide the dataset into 2 years of training set and last 1 year of test set.
  3. Take a log transformation of the sales value (dependent variable)

I did not understand.

Please tell me How can i do it?

How can i divide the dataset into 2 years of training set and test set?

Please tell me the number 2.
Please reply.

#2

Hi, both the datasets “Historical sales values” and “Historical Disposable Personal Income values” contains a date-time column. You need to separate the time, and then divide the datasets based on the year value. Here’s an article on how to convert a datetime column to a date only column:

Hope this helps.