Only convert numeric columns to time series. This is a fundamental limitation of ts, xts, and zoo. --------------------------------------------------------------------------- Jeff Newmiller The ..... ..... Go Live... DCN:<jdnew...@dcn.davis.ca.us> Basics: ##.#. ##.#. Live Go... Live: OO#.. Dead: OO#.. Playing Research Engineer (Solar/Batteries O.O#. #.O#. with /Software/Embedded Controllers) .OO#. .OO#. rocks...1k --------------------------------------------------------------------------- Sent from my phone. Please excuse my brevity.
Noah Silverman <noahsilver...@ucla.edu> wrote: >Hello, > >I noticed something odd when working with data frames and xts objects. > >If I read in a CSV file, R creates a nice data.frame. This works well. > >If I then convert to an XTS object, I see that all the values in the >data are now quoted. My data is a mix of numeric and character. This >is usually seen when converting a data.frame to a matrix, as R will >treat all the data as the same class. (character) > >How can I ensure that R creates an XTS object that is still a >data.frame so that all the data are the correct type?? > > >In the example below, you can see how as.xts() creates an object with >the correct date and time index. Please notice how all the values are >now quoted indicating that R considers them a string. > >thee data read in "d" is a data.frame: >> str(d) >'data.frame': 248 obs. of 4 variables: > >However, converting to an XTS seems to break that. >Example: > >============================================= >d <- (read.csv(file.path(dataDir,thisFile), as.is=T)) >myXTS <- as.xts( d, order.by=as.POSIXct(strptime(paste(d$Date, d$Time), >'%m/%d/%y %H:%M'))) > >head(d) > Date Obsever Val.1 Time >1 10/12/09 PL 15 12:44 >2 10/12/09 PL 15 12:44 > >head(myXTS) > Date Obsever Val.1 Time >2009-10-12 12:44:00 "10/12/09" "PL" "15" "12:44" >2009-10-12 12:44:00 "10/12/09" "PL" "15" "12:44" >============================================= > > >-- >Noah Silverman >UCLA Department of Statistics >8208 Math Sciences Building >Los Angeles, CA 90095 > > > [[alternative HTML version deleted]] > >______________________________________________ >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. ______________________________________________ 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.