Hi R gourmets,
I am trying to convert an HTML table into an xts object. The table has
six columns, with the data of interest in a single row with each cell
containing a long, \n-delimited character string. Initially, I work with
these strings as elements in a list. This is necessary because the
strings in each cell do not translate into a regular matrix with
equal-length columns. Once I fix the entries, I'm ready to convert them
into an xts object. The first two columns of the original table contain
dates, and I want them to be of type "yearmon" in the xts object. The
other four columns have numeric data.
Here's my problem. If I convert the list into a data frame on the way to
making it an xlt, the first two columns correctly keep the data as the
yearmon class, but the remaining columns are converted to character
class. Alternatively, if I convert the list into a matrix on the way to
making the xlt, all six columns become numeric; the first two columns
lose their yearmon class.
How can I make an xlt from a list, such that the first two columns are
yearmon and the last four are numeric?
Thanks.
Marsh Feldman
P.S. Here is some sample code:
> #... input has been converted to a list of length 6; each element
is a vector, but they themselves are of different length
> #... fix the 6 vectors to have equal length
> mylist[1:2] <- lapply(mylist[1:2], as.yearmon) # Convert
the first two elements into yearmon class
> #... Now try one of the following; tindex is the time index in
yearmon format
> myxts <- as.xts(as.data.frame(mylist), order.by=tindex) # this
makes columns 3-6 of myxts all have class = character
> myxts <- as.xts(matrix(unlist(mylist), ncol=6), order.by=tindex)
# this makes myxts entirely numeric
I even tried using the following statement afterwards but
had no luck
> myxts[,1] <- as.yearmon(myxts[,1])
[[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.
