time.m<- as.matrix(read.table(text='
"08:00:20.799" "08:00:20.799" "08:00:20.799" "08:00:20.799" "08:00:20.799"
"08:00:21.996" "08:00:22.071" "08:00:23.821" "08:00:24.370" "08:00:25.573"
"08:00:29.200" "08:00:29.200" "08:00:29.591" "08:00:30.368" "08:00:30.536"
"08:00:31.073" "08:00:31.372" "08:00:31.384" "08:00:31.403" "08:00:31.867"
"08:00:31.867" "08:00:31.867" "08:00:31.971" "08:00:34.571" "08:00:34.571"
',sep="",header=FALSE,stringsAsFactors=FALSE))
colnames(time.m)<- NULL
op<- options(digits.secs=3)
res<-data.frame(lapply(seq_len(ncol(time.m)),function(i)
strptime(time.m[,i],"%H:%M:%OS")))
colnames(res)<- paste0("X",1:5)
str(res)
#'data.frame': 5 obs. of 5 variables:
# $ X1: POSIXct, format: "2013-04-26 08:00:20.799" "2013-04-26 08:00:21.996" ...
# $ X2: POSIXct, format: "2013-04-26 08:00:20.799" "2013-04-26 08:00:22.071" ...
# $ X3: POSIXct, format: "2013-04-26 08:00:20.799" "2013-04-26 08:00:23.821" ...
# $ X4: POSIXct, format: "2013-04-26 08:00:20.799" "2013-04-26 08:00:24.369" ...
# $ X5: POSIXct, format: "2013-04-26 08:00:20.799" "2013-04-26 08:00:25.572" ...
options(op)
A.K.
----- Original Message -----
From: hh wt <horace...@gmail.com>
To: r-help@r-project.org
Cc:
Sent: Friday, April 26, 2013 1:51 PM
Subject: [R] converting character matrix to POSIXct matrix
I thought this is a common question but rseek/google searches don't yield
any relevant hit.
I have a matrix of character strings, which are time stamps,
> time.m[1:5,1:5]
[,1] [,2] [,3] [,4] [,5]
[1,] "08:00:20.799" "08:00:20.799" "08:00:20.799" "08:00:20.799"
"08:00:20.799"
[2,] "08:00:21.996" "08:00:22.071" "08:00:23.821" "08:00:24.370"
"08:00:25.573"
[3,] "08:00:29.200" "08:00:29.200" "08:00:29.591" "08:00:30.368"
"08:00:30.536"
[4,] "08:00:31.073" "08:00:31.372" "08:00:31.384" "08:00:31.403"
"08:00:31.867"
[5,] "08:00:31.867" "08:00:31.867" "08:00:31.971" "08:00:34.571"
"08:00:34.571"
And i would like to convert it to a POSIXct matrix. I tried this,
time1 = lapply(time.m, function(tt)strptime(tt, "%H:%M:%OS"))
but it yields a list.
Any tip is appreciated.
Horace
[[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.
______________________________________________
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.
