On Mon, Dec 6, 2010 at 6:52 AM, Ted Zeng (曾振兴) <zengzhenx...@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
______________________________________________
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.
