Hi thanks ! that works perfectly ! now I am wodering how to create a new
table ,
I run the codes:
x<-read.table("C:/R/DATA.txt",colClasses=c("Date","character","integer"),
header=T)
DateTime<-as.POSIXct(paste(x[,1],x[,2]),format="%Y-%m-%d%H%M%S")
and get :
"2004-11-01 23:33:11 GMT"
"2004-11-01 23:42:27 GMT"
“2004-11-01 23:43:27 GMT”
“2004-11-01 23:47:34 GMT”
“2004-11-02 00:01:57 GMT”
“2004-11-02 00:02:50 GMT”
“2004-11-02 00:05:23 GMT “
“2004-11-02 00:05:46 GMT “
“2004-11-02 00:05:06 GMT”
“2004-11-02 00:06:49 GMT”
“2004-11-02 00:09:21 GMT”
I want to create a new table which has two columns
DateTime Q
2004-11-01 23:33:11 1
2004-11-01 23:42:27 1
2004-11-01 23:43:27 1
2004-11-01 23:47:34 2
2004-11-02 00:01:57 3
2004-11-02 00:02:50 10
2004-11-02 00:05:23 16
2004-11-02 00:05:46 1
2004-11-02 00:05:06 2
2004-11-02 00:06:49 1
2004-11-02 00:09:21 3
I tried cbind(DateTime,x$Q) , but it failed , I know it is a little stupid
question but I still can not figure out how to get a new table like above.
Any help would be greatly appreciated !
--
View this message in context:
http://r.789695.n4.nabble.com/help-needed-for-strptime-000000-tp3309588p3310240.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
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.
