Re: [R] character to time problem

From: Gabor Grothendieck <ggrothendieck_at_gmail.com>
Date: Fri, 08 Jun 2007 11:15:31 -0400

The code in my post uses "Date" class, not POSIX. sort.POSIXlt is never invoked. Suggest you read the help desk article in R News 4/1 for more.

On 6/8/07, John Kane <jrkrideau_at_yahoo.ca> wrote:
> Looks much better. I seldom use dates for much and
> didn't think to look at the sort.POSIXlt function.
>
> If I understand this correctly the sort.POSIXlt with
> na.last = FALSE is dropping all the NAs. Very nice.
>
>
> --- Gabor Grothendieck <ggrothendieck_at_gmail.com>
> wrote:
>
> > Perhaps you want one of these:
> >
> > > sort(as.Date(aa$times, "%d/%m/%Y"))
> > [1] "1995-03-02" "2001-05-12" "2007-02-14"
> >
> > > sort(as.Date(aa$times, "%d/%m/%Y"), na.last =
> > TRUE)
> > [1] "1995-03-02" "2001-05-12" "2007-02-14" NA
> > NA
> > [6] NA
> >
> >
> > On 6/7/07, John Kane <jrkrideau_at_yahoo.ca> wrote:
> > > I am trying to clean up some dates and I am
> > clearly
> > > doing something wrong. I have laid out an example
> > > that seems to show what is happening with the
> > "real"
> > > data. The coding is lousy but it looks like it
> > > should have worked.
> > >
> > > Can anyone suggest a) why I am getting that NA
> > > appearing after the strptime() command and b) why
> > the
> > > NA is disappearing in the sort()? It happens with
> > > na.rm=TRUE and na.rm=FALSE
> > > -------------------------------------------------
> > > aa <- data.frame( c("12/05/2001", " ",
> > "30/02/1995",
> > > NA, "14/02/2007", "M" ) )
> > > names(aa) <- "times"
> > > aa[is.na(aa)] <- "M"
> > > aa[aa==" "] <- "M"
> > > bb <- unlist(subset(aa, aa[,1] !="M"))
> > > dates <- strptime(bb, "%d/%m/%Y")
> > > dates
> > > sort(dates)
> > > --------------------------------------------------
> > >
> > > Session Info
> > > R version 2.4.1 (2006-12-18)
> > > i386-pc-mingw32
> > >
> > > locale:
> > > LC_COLLATE=English_Canada.1252;
> > > LC_CTYPE=English_Canada.1252;
> > > LC_MONETARY=English_Canada.1252;
> > > LC_NUMERIC=C;LC_TIME=English_Canada.1252
> > >
> > > attached base packages:
> > > [1] "stats" "graphics" "grDevices" "utils"
> > > "datasets" "methods" "base"
> > >
> > > other attached packages:
> > > gdata Hmisc
> > > "2.3.1" "3.3-2"
> > >
> > > (Yes I know I'm out of date but I don't like
> > > upgrading just as I am finishing a project)
> > >
> > > Thanks
> > >
> > > ______________________________________________
> > > R-help_at_stat.math.ethz.ch 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.
> > >
> >
>
>
>
> Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail at http://mrd.mail.yahoo.com/try_beta?.intl=ca
>
>



R-help_at_stat.math.ethz.ch 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. Received on Fri 08 Jun 2007 - 15:42:48 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Sat 09 Jun 2007 - 11:31:44 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.