Re: [R] working with zoo time index ??

From: Gabor Grothendieck <ggrothendieck_at_gmail.com>
Date: Wed, 16 Jun 2010 09:24:50 -0400

On Wed, Jun 16, 2010 at 8:36 AM, Gabor Grothendieck <ggrothendieck_at_gmail.com> wrote:
> On Wed, Jun 16, 2010 at 7:58 AM, skan <juanpide@gmail.com> wrote:
>>
>> Hi
>> thanks
>>
>>
>> Let say data are written like this:
>> 1990-01-01 10:01:00 ,  0.910
>> 1990-01-01 10:03:00 ,  0.905
>>
>> Would it be ok to read it with theses lines or is better to use your way?
>>
>> tmp <- read.table("demo2.txt", sep = ",")
>> z <- zoo(tmp[, 2], as.Date(as.chron(tmp[, 1]), format = "%Y-%m-%d
>> %H:%M:%S"))
>
> You want to avoid creating zoo objects that have duplicate times since
> they can't be merged.  This will read the data in and at the same time
> aggregate it by date using the first value among all values with the
> same date.
>
> Lines <- "1990-01-01 10:01:00 ,  0.910
> 1990-01-01 10:03:00 ,  0.905
> 1990-01-02 10:03:00 ,  0.895"
>
> library(zoo)
> z <- read.zoo(textConnection(Lines), sep = ",", FUN = as.Date,
>        aggregate = function(x) head(x, 1))
>

This can be reduced slightly to the following as it defaults to Date here:

z <- read.zoo(textConnection(Lines), sep = ",", aggregate = function(x) head(x, 1))



R-help_at_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. Received on Wed 16 Jun 2010 - 13:27:49 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 16 Jun 2010 - 19:40:33 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive