use zoo package with multiple column data sets

Readers,

I am trying to use the zoo package with an array of data:

file1:
hh:mm:ss ? ? ? ?1
hh:mm:ss ? ? ? ?2
hh:mm:ss ? ? ? ?3
hh:mm:ss ? ? ? ?4

file2:
hh:mm:ss ? ? ? ?11 ? ? ?55
hh:mm:ss ? ? ? ?22 ? ? ?66
hh:mm:ss ? ? ? ?33 ? ? ?77
hh:mm:ss ? ? ? ?44 ? ? ?88

I wanted to merge these data set so I tried the following commands:

library(chron)
library(zoo)
z1<-read.zoo("path/to/file1.csv",header=TRUE,sep=",",FUN=times)
z2<-read.zoo("path/to/file2.csv",header=TRUE,sep=",",FUN=times)
z3<-(na.approx(merge(z1,z2),time(z1)))
plot(z3$z1,z3$z2[3])

Warning message:
some methods for ?zoo? objects do not work if the index entries in
?order.by? are not unique in: zoo(rval, ix)

z3<-(na.approx(merge(z1,z2),time(z1)))

Error in merge.zoo(z1, z2) : series cannot be merged with non-unique
index entries in a series

I have read the document vignette 'zoo' but section 2.1 does not show
an example of the syntax for the command 'order.by'.

How to use the zoo package where the variable z2 contains many columns of data?

Yours,

rhelpatconference.jabber.org
r251

Lines <- "01:01:01        11      55

library(zoo)
library(chron)
z <- read.zoo(textConnection(Lines), FUN = times)
z

Assuming my documentation is correct, my version shows faq 1 to refer
to duplicate times but if file2 is:

01:01:01 ? ? ? ?11 ? ? ?55
01:01:04 ? ? ? ?22 ? ? ?66
01:01:07 ? ? ? ?33 ? ? ?77
01:01:10 ? ? ? ?44 ? ? ?88

I cannot see what is duplicate? If I create two new files:

file3:
01:01:01 ? ? ? ?11
01:01:04 ? ? ? ?22
01:01:07 ? ? ? ?33
01:01:10 ? ? ? ?44

file4:
01:01:01 ? ? ? ?55
01:01:04 ? ? ? ?66
01:01:07 ? ? ? ?77
01:01:10 ? ? ? ?88

The previous commands work:

z1<-read.zoo("path/to/file1.csv",header=TRUE,sep=",",FUN=times)
z2<-read.zoo("path/to/file3.csv",header=TRUE,sep=",",FUN=times)
z3<-(na.approx(merge(z1,z2),time(z1)))
plot(z3$z1,z3$z2)

and:

z1<-read.zoo("path/to/file1.csv",header=TRUE,sep=",",FUN=times)
z2<-read.zoo("path/to/file4.csv",header=TRUE,sep=",",FUN=times)
z3<-(na.approx(merge(z1,z2),time(z1)))
plot(z3$z1,z3$z2)

Shouldn't I be able to have one file containing all the columns I want
to make graphs, instead of having to create numerous files of only two
columns of data?

library(chron)
library(zoo)
z1<-read.zoo("~/path/to/test1.csv",header=TRUE,sep=",",FUN=times)
z2<-read.zoo("~/path/to/test2.csv",header=TRUE,sep=",",FUN=times)
z3<-(na.approx(merge(z1,z2),time(z1)))

z3<-(na.approx(merge(z1,z2[,2]),time(z1)))

z3<-(na.approx(merge(z1,z2[,3]),time(z1)))

z4<-read.zoo(textConnection(z2),FUN=times)

library(chron)
library(zoo)
z1<-read.zoo("~/path/to/test1.csv",header=TRUE,sep=",",FUN=times)
z2<-read.zoo("~/path/to/test2.csv",header=TRUE,sep=",",FUN=times)
z3<-(na.approx(merge(z1,z2),time(z1)))

Error in approx(along[!na], y[!na], along[na], ...) :
? ? ? ?need at least two non-NA values to interpolate

z3<-(na.approx(merge(z1,z2[,2]),time(z1)))

Error in approx(along[!na], y[!na], along[na], ...) :
? ? ? ?need at least two non-NA values to interpolate

z3<-(na.approx(merge(z1,z2[,3]),time(z1)))

Error in `[.zoo`(z2, , 3) : subscript out of bounds

z4<-read.zoo(textConnection(z2),FUN=times)

Error in textConnection(z2) : invalid 'text' argument