R help - Dec 2010 - as.xts error

Dear all,

I am using the as.xts function to transfer a data frame to the xts 

The following is the code and result:

a<-read.csv("price.csv")
a$Date<-as.POSIXct(a$Date)

str(a)
'data.frame':	15637 obs. of  2 variables:
 $ Date   : POSIXct, format: "2010-01-04 09:45:01" "2010-01-04
09:45:02"
"2010-01-04 09:45:03" ...
 $ bid_hsi: int  21850 21864 21864 21867 21859 21849 21849 21850 21854 21853
...

head(a)

              Date bid_hsi
1 2010-01-04 09:45:01   21850
2 2010-01-04 09:45:02   21864
3 2010-01-04 09:45:03   21864
4 2010-01-04 09:45:04   21867
5 2010-01-04 09:45:05   21859
6 2010-01-04 09:45:06   21849

p<-as.xts(a)
Error in as.POSIXlt.character(x, tz, ...) : 
  character string is not in a standard unambiguous format

Please help me to use the function as.xts correctly.

Thanks

Ted 


-- 
View this message in context:
http://r.789695.n4.nabble.com/as-xts-error-tp3074335p3074335.html
Sent from the R help mailing list archive at Nabble.com.

On Mon, Dec 6, 2010 at 6:52 AM, Ted Zeng (???) <zengzhenxing at gmail.com>
wrote:
>
> Dear all,
>
> I am using the as.xts function to transfer a data frame to the xts
>
> The following is the code and result:
>
> a<-read.csv("price.csv")
> a$Date<-as.POSIXct(a$Date)
>
> str(a)
> 'data.frame': ? 15637 obs. of ?2 variables:
> ?$ Date ? : POSIXct, format: "2010-01-04 09:45:01"
"2010-01-04 09:45:02"
> "2010-01-04 09:45:03" ...
> ?$ bid_hsi: int ?21850 21864 21864 21867 21859 21849 21849 21850 21854
21853
> ...
>
> head(a)
>
> ? ? ? ? ? ? ?Date bid_hsi
> 1 2010-01-04 09:45:01 ? 21850
> 2 2010-01-04 09:45:02 ? 21864
> 3 2010-01-04 09:45:03 ? 21864
> 4 2010-01-04 09:45:04 ? 21867
> 5 2010-01-04 09:45:05 ? 21859
> 6 2010-01-04 09:45:06 ? 21849
>
> p<-as.xts(a)
> Error in as.POSIXlt.character(x, tz, ...) :
> ?character string is not in a standard unambiguous format
>
> Please help me to use the function as.xts correctly.
>

Try this (you may need to modify the read.zoo arguments depending on
what the file looks like):

library(xts)
z <- read.zoo("price.csv", header = TRUE, sep = ",", tz =
"")
x <- as.xts(z)


-- 
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com