[R] character to time problem
John Kane
jrkrideau at yahoo.ca
Thu Jun 7 23:17:39 CEST 2007
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
More information about the R-help
mailing list