I want to read as a date rows like this:
YEAR MONTH DAY HOUR MINUTES SECS
2013 DEC 20 00 13 18.5
I have tried a lot of options and nothing!
Is there any explanation, any solution?
Thank you.
What have you tried?
There are many solutions, have you found as.Date, as.POSIXct, paste, strptime etc?
#create some sample date
dat
Another option is ISOdate. Here you have to convert "DEC" to a numeric value.
num.month
Do as below, where I gave a timezone also, which is generally a good idea.
> d strptime(d, "%Y %b %d %H %M %OS", tz="UTC")
[1] "2013-12-20 00:13:18.5 UTC"
Eik, your ISO suggestion was helpful, since there exist also other data at every row and by that way I managed to store time in ISO and common format.
My difficulties:
1)I hadn't set the Sys.setlocale, so -->NA
2)I put %S instead of %OS for seconds format
Dan, since R reads and automatically puts the names V1,V2,... strptime() has extra preparation, thank you, it is useful for other situations.
So, participating in RG is valuable!
Thank you guys!
Hm, Eik, look here:
Original data
>dat[1,]
V1 V2 V3 V4 V5 V6 V7 V8 V9 V10
1 1997 JAN 1 2 59 32 38.11 23.83 4 2.2
I apply the commands:
dat
with ISOdate you don't have to set the locale.
Anyway, I can't reproduce your error,
num.month
If I don't use the command read.table().
All commands and outputs:
> rm(list=ls())
> dat num.month names(num.month) num.month["JAN"]
JAN
1
> tt dat[1,]
V1 V2 V3 V4 V5 V6 V7 V8 V9 V10
1 1997 JAN 1 2 59 32 38.11 23.83 4 2.2
> tt[1]
[1] "1997-06-01 02:59:32 GMT"
****That's all.
Otherwise, everything is fine.
Thanks Eik.
What does
str(dat$V2)
give you? I guess there is an issue with an automatic factor conversion with a possible reordering of levels. Using stringsAsFactors=F as an option in either read.table or read.csv (which is actually a wrapper for read.table to conveniently read in 'comma separated values') should overcome this issue.
Eik, you are right. Before:
Factor w/ 13 levels "","APR","AUG",..: 6 6 6 6 6 6 6 6 6 6 ...
After your stringsAsFactors=F:
chr [1:7778] "JAN" "JAN" "JAN" "JAN" "JAN" "JAN" "JAN" "JAN" "JAN" "JAN" "JAN" "JAN" "JAN" "JAN" ...
and the problem disappeared.
Thanks!
- Badges
- Science topic
- Similar topics
- Mathematics
- Statistics
- Statistical Software
- R