Hi,
I have a csv file with different datatypes:
2009-01-01, character1, 10, 20.1
2009-01-02, character2, 11, 21.1
(I have attached the file to this post)
I read this file with read.zoo as I want a zoo/xts timeseries:
> t = read.zoo("./data.txt", sep=",", dec = ".", header=FALSE)
If I look at the zoo data all integer/numeric columns are read as
character:
> str(t)
‘zoo’ series from 2009-01-01 to 2009-01-02
Data: chr [1:2, 1:3] " character1" " character2" "10" "11" "20.1" "21.1"
- attr(*, "dimnames")=List of 2
..$ : NULL
..$ : chr [1:3] "V2" "V3" "V4"
Index: Class 'Date' num [1:2] 14245 14246
So I try the colClasses parameter with read.zoo but it looks like this does
not make any difference:
> t1 = read.zoo("./data.txt", sep=",", dec = ".", header=FALSE,
colClasses=c("Date", "character", "integer", "numeric"))
> str(t1)
‘zoo’ series from 2009-01-01 to 2009-01-02
Data: chr [1:2, 1:3] " character1" " character2" "10" "11" "20.1" "21.1"
- attr(*, "dimnames")=List of 2
..$ : NULL
..$ : chr [1:3] "V2" "V3" "V4"
Index: Class 'Date' num [1:2] 14245 14246
Why does read.zoo ignores the colClasses parameter and how do I get
integer/numeric data into my zoo series?
Regards,
-Mark-
2009-01-01, character1, 10, 20.1
2009-01-02, character2, 11, 21.1
______________________________________________
R-help@r-project.org mailing list
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.
