how to read a .csv file as time series using zoo?

Question

I am trying to read a .csv file into R as time series using zoo package.That's what I've written so far:

tbl<-as.xts(read.zoo("~//Documents//thesis research//myseries (version 1)2.csv",sep="/",header=T,format=%m/%d/%Y))

I 've got a following error message:

Error: unexpected SPECIAL in "tbl<-as.xts(read.zoo("~//Documents//thesis research//myseries (version 1)2.csv",sep="/",header=T,format=%m/%">

Any ideas how to solve this?

a paste of at least some of `myseries (version 1)2.csv` would help greatly. — hrbrmstr, Apr 18 '14 at 22:52

score 1 · Answer 1 · answered Apr 18 '14 at 20:12

1

Try putting format into " ", like this

format="%m/%d/%Y"

answered Apr 18 '14 at 20:12

bartektartanus

Thanks a lot for the tip,but now there is a different message saying: – user3546838 Apr 18 '14 at 20:56
tbl<-as.xts(read.zoo("~//Documents//thesis research//myseries (version 1)2.csv",sep="/",header=T,format="%m/%d/%Y")) Error in read.table(file, ...) : more columns than column names – user3546838 Apr 18 '14 at 20:56
Strange,my columns are-date,Y,X1,X2,X3,X4,X5,X6 – user3546838 Apr 18 '14 at 20:57
1

This explains how to ask a question on SO: http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example – G. Grothendieck Apr 18 '14 at 21:47

1 Answers1