R help - Feb 2011 - help needed for strptime "000000" !

JESSICA wrote:
> 
> 
> I have a text file stored in notepad:
> 
> DATE                         TIME     Q
> 2004-11-01	233311	1
> 2004-11-01	234227	1
> ...
> I  run 
> 
> x<-read.table("C:/R/Sample.txt",header=T)
> then get a table 
> 
> ...
> I am trying to 
> 
> strptime(x$TIME,"%H%M%S")
> 
> and get : 
> 
>  [1] "2011-02-16 23:33:11" "2011-02-16 23:42:27"
"2011-02-16 23:43:27"
>  [4] "2011-02-16 23:47:34" NA                    NA
>  [7] NA                    NA                    NA                   
> [10] NA                    NA                    NA      
> 
> 
Try (but I a note sure what to do with the DATE column.
Dieter

x<-read.table("datesample.txt",
  colClasses=c("Date","character","integer"),
header=T)
class(x$TIME)= "POSIXct"
strptime(x$TIME,"%H%M%S") 

-- 
View this message in context:
http://r.789695.n4.nabble.com/help-needed-for-strptime-000000-tp3309588p3309664.html
Sent from the R help mailing list archive at Nabble.com.

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.