[R] using its to import time series data with uneven dates
Whit Armstrong
whit at twinfieldscapital.com
Wed Jul 13 00:01:48 CEST 2005
You would probably do better to read in your data and reformat the
dates.
What date format is 2000.18790? The Its package uses POSIXct dates and
readcsvIts expects the formats to be "%Y-%m-%d" unless you've changed
the default format.
-----Original Message-----
From: r-help-bounces at stat.math.ethz.ch
[mailto:r-help-bounces at stat.math.ethz.ch] On Behalf Of Sheri Conner
Gausepohl
Sent: Tuesday, July 12, 2005 5:47 PM
To: r-help at stat.math.ethz.ch
Subject: [R] using its to import time series data with uneven dates
Good day:
I am trying to use
readcsvIts("nwr_data_qc.txt",informat=its.format("%Y%m%d%h%M
%Y"),header=TRUE,sep="",skip=0,row.names=NULL,as.is=TRUE,dec=".")
to read in a file (nwr_data_qc.txt) that looks like this:
Time Y M D H Min CO2
2000.18790 2000. 3. 9. 18. 30. 373.60
2000.20156 2000. 3. 14. 18. 30. 373.34
2000.22609 2000. 3. 23. 18. 0. 373.01
and R returns this:
Y M D H Min CO2
<NA> 2000 3 9 18 30 373.60
<NA> 2000 3 14 18 30 373.34
<NA> 2000 3 23 18 0 373.01
I have tried every format option on the help page. How can I read in my
decimal dates (e.g., 2000.18790)?
Note that these data (CO2) are irregularly spaced in time (Time).
Ultimately I would like to fit a trigonometric polynomial (first
harmonic) to these data in order to smooth them and obtain values
between measurements. Any suggestions you can provide on how to do this
would be much appreciated.
Thank you for your help.
Sheri
Sheri L. Conner Gausepohl
Graduate Research Assistant
Department of Atmospheric Science
Colorado State University
______________________________________________
R-help at stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide!
http://www.R-project.org/posting-guide.html
More information about the R-help
mailing list