Transposing forecasts results from nnetar function and turn them into a data frame
Hi Paul, It looks like the information that is printed is in: TSModelForecast$mean If str(TSModelForecast$mean) returns something like a list with two components, you can probably use something like this: paste(format(TSModelForecast$mean$Date,"%b-%Y"), TSModelForecast$mean$Forecast,sep="-",collapse="\n") It also might be in TSModelForecast$fitted Jim
On Fri, Mar 17, 2017 at 5:34 AM, Paul Bernal <paulbernal07 at gmail.com> wrote:
Dear friends, I am currently using R version 3.3.3 (64-bit) and used the following code to generate forecasts:
library(forecast) library(tseries)
?tseries? version: 0.10-35
?tseries? is a package for time series analysis and computational
finance.
See ?library(help="tseries")? for details.
DAT<-read.csv("TrainingData.csv")
TSdata<-ts(DAT[,1], start=c(1994,10), frequency=12)
TSmodel<-nnetar(TSdata)
TSmodelForecast<-forecast(TSmodel, h=24)
TSmodelForecast
The problem is that the output comes in this fashion:
Jan Feb Mar Apr May Jun Jul Aug
Sep Oct
2017 10 20 15 40 9 8 21 21
19 18
2018 34 15 7 6 10 11
The format I would like to have is the following:
Date Forecast
Jan-2017 10
Feb-2017 20
Mar-2017 15
Apr-2017 40
May-2017 9
Jun-2017 8
Jul-2017 21
Aug-2017 21
Sep-2017 19
etc etc
Is there a way to make the results look like this?
Attached is a dataset as a reference.
Best regards,
Paul
______________________________________________ R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.