[R] FW: getting time series into r

[David Winsemius]

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