On Wed, Jun 16, 2010 at 8:36 AM, Gabor Grothendieck
<ggrothendi...@gmail.com> wrote:
> On Wed, Jun 16, 2010 at 7:58 AM, skan <juanp...@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@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.
