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

From: Gabor Grothendieck <ggrothendieck_at_gmail.com>
Date: Wed, 16 Jun 2010 08:36:52 -0400

On Wed, Jun 16, 2010 at 7:58 AM, skan <juanpide_at_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))



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 - 12:39:16 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 - 13:40:32 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