I have an excel file with 3,000 rows where each row represents a product with its monthly sales in the columns (about 5 years worth of monthly sales).
I have gone through a tutorial on how to make an LSTM forecast.
I have seen some videos on how to import selected rows.
I learned how to use np.savetxt(‘107084.csv’, df_proj, delimiter=’,’)
But what I need is to select every row in the excel file individually, create a forecast for each and put the forecast into a new excel file or into individual csv files that i can later merge into a single file.
Also the exported data is this:
without the month column.
I need guidance please.