On May 23, 2011, at 5:16 PM, David Winsemius wrote:
On May 23, 2011, at 4:31 PM, Ben Bolker wrote:
Heiman, Thomas J. <theiman <at> mitre.org> writes:
tmp <- read.table("baltimore.csv", sep = " ") ##This is timeseries 2
z <- zoo(tmp[, 2:20], as.Date(as.character(tmp[, 1]), format = ))
In this file you have no separators in the dates so the format would
be "%Y%m%d". It's also not a csv file .... no commas
tmp1 <- read.table("baltimorefludata.csv", sep = " ") ##This is
timeseries 1
z2 <- zoo(tmp[,2], as.Date(tmp[, 1]), format = ))
For this one the format would be "%m/%d/%Y". There also appeared to
be no whitespace after some of the entries, so you might need
utils::read.fwf()
OH. They were tabs. And there was a header line... so
> tmp1
V1
1 Date\tCount
2 9/28/2003\t1505
3 10/5/2003\t1535
Try instead:
> tmp1 <- read.table("~/Downloads/timeseries1sample.txt", sep = "\t",
header =TRUE) ##This is timeseries 1
> tmp1$Date <- as.Date(as.character(tmp1$Date), format="%m/%d/%Y")
> tmp1
Date Count
1 2003-09-28 1505
2 2003-10-05 1535
3 2003-10-12 1549
4 2003-10-19 1466
Then use zoo.
I think you need format="%m/%d/%Y"
David Winsemius, MD
West Hartford, CT
______________________________________________
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.