Re: [R] calculating the difference between days?
What's wrong with manipulating the results arun got? 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") # difference in days result <- difftime(dat3[,1],dat3[,2]) # difference in seconds ddays <- as.numeric(result/(24*3600)) ddays HTH, Jorge.- On Tue, Jul 10, 2012 at 3:55 PM, C W <> wrote: > When the days and time are identical, difftime() gives difference in secs. > I still want difference in days. > > Say, below my last row is identical > 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 > 24DEC2012:00:00:00:000 24DEC2012:00:00:00:000 > ",sep="",header=TRUE) > > -M > > On Tue, Jul 10, 2012 at 1:52 PM, arun wrote: > > > 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. -55. -124.0417 -32. -32. > > attr(,"tzone") > > [1] "" > > > > A.K. > > > > - Original Message - > > From: C W > > To: r-help > > 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@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. > > > > > > [[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. > [[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.
Re: [R] calculating the difference between days?
Actually, when specifying unit="days" inside difftime() will do. -M On Tue, Jul 10, 2012 at 3:55 PM, C W wrote: > When the days and time are identical, difftime() gives difference in secs. > I still want difference in days. > > Say, below my last row is identical > 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 > 24DEC2012:00:00:00:000 24DEC2012:00:00:00:000 > ",sep="",header=TRUE) > > -M > > On Tue, Jul 10, 2012 at 1:52 PM, arun wrote: > >> 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. -55. -124.0417 -32. -32. >> attr(,"tzone") >> [1] "" >> >> A.K. >> >> - Original Message - >> From: C W >> To: r-help >> 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@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. >> >> > [[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.
Re: [R] calculating the difference between days?
When the days and time are identical, difftime() gives difference in secs. I still want difference in days. Say, below my last row is identical 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 24DEC2012:00:00:00:000 24DEC2012:00:00:00:000 ",sep="",header=TRUE) -M On Tue, Jul 10, 2012 at 1:52 PM, arun wrote: > 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. -55. -124.0417 -32. -32. > attr(,"tzone") > [1] "" > > A.K. > > - Original Message - > From: C W > To: r-help > 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@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. > > [[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.
Re: [R] calculating the difference between days?
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. -55. -124.0417 -32. -32. attr(,"tzone") [1] "" A.K. - Original Message - From: C W To: r-help 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@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.
[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@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.