[R] problem with Dates
Gabor Grothendieck
ggrothendieck at gmail.com
Thu Mar 19 12:31:17 CET 2009
Try this (and read R News 4/1):
Lines <- "6/4/1992 12:00:00 AM
2/13/1992 12:00:00 AM
6/19/1992 12:00:00 AM
2/11/1992 12:00:00 AM
6/22/1992 12:00:00 AM
10/3/1991 12:00:00 AM
5/12/1992 12:00:00 AM
7/11/1991 12:00:00 AM
2/6/1992 12:00:00 AM
10/4/1991 12:00:00 AM
1/31/1992 12:00:00 AM
6/9/1992 12:00:00 AM
10/9/1991 12:00:00 AM
6/10/1992 12:00:00 AM
7/19/1991 12:00:00 AM
7/18/1991 12:00:00 AM
9/20/1991 12:00:00 AM
8/6/1992 12:00:00 AM
8/12/1992 12:00:00 AM
8/19/1992 12:00:00 AM
7/12/1991 12:00:00 AM
6/5/1992 12:00:00 AM
2/7/1992 12:00:00 AM
7/1/1992 12:00:00 AM
8/7/1992 12:00:00 AM
8/13/1992 12:00:00 AM"
library(chron)
DF <- read.table(textConnection(Lines), as.is = TRUE)
# they are all dates so we don't need the time component
# Here we use chron class since that accepts
# mm/dd/yyyy format by default
dd <- as.chron(DF[[1]])
dd[1] - dd[2]
min(dd)
# or use Date class
DD <- as.Date(dd)
DD[1] - DD[2]
min(DD)
On Thu, Mar 19, 2009 at 2:20 AM, venkata kirankumar
<kiran4u2all at gmail.com> wrote:
> Hi all,
> I am strugling with date formates and caliculating diferent operations like
> different between 2 dates and
> getting minimum in vector of dates
>
> that is i m working with dates in formate "6/22/1992 12:00:00 AM"
> and the vector is
>
> [1] 6/4/1992 12:00:00 AM 2/13/1992 12:00:00 AM 6/19/1992 12:00:00 AM
> [4] 2/11/1992 12:00:00 AM 6/22/1992 12:00:00 AM 10/3/1991 12:00:00 AM
> [7] 5/12/1992 12:00:00 AM 7/11/1991 12:00:00 AM 2/6/1992 12:00:00 AM
> [10] 10/4/1991 12:00:00 AM 1/31/1992 12:00:00 AM 6/9/1992 12:00:00 AM
> [13] 10/9/1991 12:00:00 AM 6/10/1992 12:00:00 AM 7/19/1991 12:00:00 AM
> [16] 7/18/1991 12:00:00 AM 9/20/1991 12:00:00 AM 8/6/1992 12:00:00 AM
> [19] 8/12/1992 12:00:00 AM 8/19/1992 12:00:00 AM 7/12/1991 12:00:00 AM
> [22] 6/5/1992 12:00:00 AM 2/7/1992 12:00:00 AM 7/1/1992 12:00:00 AM
> [25] 8/7/1992 12:00:00 AM 8/13/1992 12:00:00 AM
>
> and here i have to get least date (means first initial date) and i have to
> get difference between that date to all other dates in vector
>
> i tried with functins like
>
> formate()
> and round() but its not woking on this formate of data
>
> can any one help me out to solve this
>
>
> thanks in advance
>
> [[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