[R] calculating the difference between days?
arun
smartpink111 at yahoo.com
Tue Jul 10 19:52:41 CEST 2012
Hi,
Try this:
dat3<-read.table(text="
Begin_date End_date
01JAN2000:00:00:00:000 02FEB2002:00:00:00:000
24MAR2012:00:00:00:000 18MAY2012:00:00:00:000
01OCT2003:00:00:00:000 02FEB2004:00:00:00:000
01JAN2000:00:00:00:000 02FEB2000:00:00:00:000
01JAN2000:00:00:00:000 02FEB2000:00:00:00:000
",sep="",header=TRUE)
dat3$Begin_date<-strptime(dat3[,1],format="%d%b%Y:%H:%M:%S")
dat3$End_date<-strptime(dat3[,2],format="%d%b%Y:%H:%M:%S")
difftime(dat3[,1],dat3[,2])
Time differences in days
[1] -763.0000 -55.0000 -124.0417 -32.0000 -32.0000
attr(,"tzone")
[1] ""
A.K.
----- Original Message -----
From: C W <tmrsg11 at gmail.com>
To: r-help <r-help at r-project.org>
Cc:
Sent: Tuesday, July 10, 2012 1:22 PM
Subject: [R] calculating the difference between days?
Hi List,
I have one column of beginning dates and one column of ending dates, I want
to find their difference. And I want to ignore the trailing zeros,
basically everything after the first colon mark.
Begin_date End_date
01JAN2000:00:00:00:000 02FEB2002:00:00:00:000
24MAR2012:00:00:00:000 18MAY2012:00:00:00:000
01OCT2003:00:00:00:000 02FEB2004:00:00:00:000
01JAN2000:00:00:00:000 02FEB2000:00:00:00:000
01JAN2000:00:00:00:000 02FEB2000:00:00:00:000
Thanks,
Mike
[[alternative HTML version deleted]]
______________________________________________
R-help at 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.
More information about the R-help
mailing list