my data is like this. i have to use this as index for xts in R.
"01/04/2013 09:00:01.265381"
"01/04/2013 09:00:01.265717"
"01/04/2013 09:00:01.266342"
"01/04/2013 09:00:01.266342"
"01/04/2013 09:00:01.266342"
> as.POSIXct(sk,format="%Y%m%d %H:%M:%S.%f")
this outputs al nas
please give me suggestions.
Hi,
here it is the answer:
1. first, you have to set the following option, otherwise R is not able to read the decimal seconds:
` options(digits.secs = 6) `
2. you need to input the CORRECT format for your dates:
`as.POSIXlt("01/04/2013 09:00:01.266342", format = "%d/%m/%Y %H:%M:%OS", tz = "GMT")`
I assumed that your data is in the format "day/month"; if it is the other way around,
just replace the "%d%m" portion above with"%m%d";
in addition, the "O" before "S" at the end is needed to tell R to read (now that it has been enabled) the decimal seconds.
NB: if you do not input the time zone (`tz`) R will use by default your local setting.
Now, you can easily work with xts.
Hi,
I would like to add a second options; however, you need the "RcppBDT" package, the version on Github (the one from CRAN does not have yet this function).
```
require(RcppBDT)
options("digits.secs"=6)
s
- Badges
- Science topic
- Similar topics
- Mathematics
- Statistics
- Statistical Software
- R