[R] reading in time series
tluedeke at excite.com
Thu Jan 20 09:04:59 CET 2011
This is causing me great consternation, and I've spent too much time
floundering around on it.
My data is in the form of columns in Excel, with the first column being in
m/dd/yyyy hh:mm format. The spreadsheet is complicated (headers, merged
cells, lines w/o data); so I've tried various ways of exporting the data
into a text file for the R processing - CSV, spaced, etc. For example:
3/23/2010 20:55 -0.106559999 -0.121454561 -0.120300002 -0.111680001
3/23/2010 21:25 -0.099166997 -0.114189997 -0.112879999 -0.104647976
- or -
3/23/2010 20:55, -0.106559999, -0.121454561, -0.120300002, -0.111680001,
3/23/2010 21:25, -0.099166997, -0.114189997, -0.112879999, -0.104647976,
I can't seem to get R to recognize this data as a time/data column in
m/dd/yyyy hh:mm format followed by columns of data. There was a post on an
analogous topic a couple of years ago, but none of the proposed (and quite
complicated) solutions seemed to work for me.
Anyone know how to handle this?
View this message in context: http://r.789695.n4.nabble.com/reading-in-time-series-tp3225481p3225481.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help