Error in na.fail.default(as.ts(x)) : missing values in object in time series forecasting

r time-series analytics forecasting
Deb picture Deb · Jul 30, 2017 · Viewed 16.4k times · Source

I am trying to perform fit diagnostic on a salesData forecast using 

acf(SalesDataFC$residuals)

however I am getting an error:

salesDataFC$residuals

         Jan         Feb         Mar         Apr         May

2012 NA NA NA NA NA

2013 1.00454060 0.74436890 0.59266194 0.53535119 0.18350112

2014 1.99667197 -3.32464848 0.28314025 2.30886777 7.90332419

2015 1.71499831 -0.52401427 0.34252510 -1.64516043 2.77034325

         Jun         Jul         Aug         Sep         Oct

2012 NA NA NA NA NA

2013 0.05094251 -0.22804463 -1.91518053 2.58830624 0.26477677

2014 4.40433679 0.32271024 1.57947031 1.43734334 -3.20311270

2015 -2.20471818 -0.90067401 -3.44177911 5.48261863 -2.98716442

         Nov         Dec

2012 NA NA

2013 -4.73145658 4.89403358

2014 2.11005638 -2.66661403

2015 0.01368218 1.55215790

acf(salesDataFC$residuals)

Error in na.fail.default(as.ts(x)) : missing values in object

Answer

Deb picture Deb · Jul 30, 2017

here I was missing to check the missing values i.e. NA. hence na.action = na.pass will be used after acf(salesDataFC$residuals). so the command goes like acf(salesDataFC$residuals, na.action = na.pass).

Related questions

Plotting two variables as lines using ggplot2 on the same graph

A very newbish question, but say I have data like this: test_data <- data.frame( var0 = 100 + c(0, cumsum(runif(49, -20, 20))), var1 = 150 + c(0, cumsum(runif(49, -10, 10))), date = seq(as.Date("2002-01-01"), by="1 month", length.out=100) ) How can I …

Read More
How to convert dataframe into time series?

I have one csv file in which I have 2 closing prices of stock(on daily basis) Dates Bajaj_close Hero_close 3/14/2013 1854.8 1669.1 3/15/2013 1850.3 1684.45 3/18/2013 1812.1 1690.5 3/19/2013 1835.9 1645.6 3/20/2013 1840 1651.15 3/21/2013 1755.3 1623.3 3/22/2013 1820.65 1659.6 3/25/2013 1802.5 1617.7 3/26/2013 1801.25 1571.85 3/28/2013 1799.55 1542 I want to convert above data into time series format. (start date is 3/14/2013 and end date is 3/13/2015) I have …

Read More
Converting a data frame to xts

I'm trying to convert a data frame to xts object using the as.xts()-method. Here is my input dataframe q: q t x 1 2006-01-01 00:00:00 1 2 2006-01-01 01:00:00 2 3 2006-01-01 02:00:00 3 str(q) 'data.frame': 10 obs. of 2 variables: $ t: POSIXct, format: "2006…

Read More