dates in R

An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-sig-mac/attachments/20101023/b6fd3fce/attachment.pl>
An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-sig-mac/attachments/20101023/021e5481/attachment.pl>
Hi list,

I am having trouble getting R to read and display dates correctly. My dates
are in the form of day (no space) month (no space) year, for example: 250706
and sometimes 50906.

Any guidance would be appreciated...Thanks.

(1) This question has nothing to do with Mac computers.  It should have been sent to r-help.

(2) The problem seems to me to be the inconsistency in the number of digits representing
"day",  To remedy this, paste on a zero and then remove redundant zeroes:

foo <- function(x) {
              x <- paste(0,x,sep="")
              x <- substr(x,nchar(x)-5,nchar(x))
              strptime(x,format="%d%m%y")
}

x <- c(250706,50906)
foo(x)
[1] "2006-07-25" "2006-09-05"

HTH.

     cheers,

           Rolf Turner

sirmeelo at gmail.com [sirmeelo at gmail.com] wrote:

Hi list,

I am having trouble getting R to read and display dates correctly.  
My dates
are in the form of day (no space) month (no space) year, for  
example: 250706
and sometimes 50906.

Any guidance would be appreciated...Thanks.

(1) This question has nothing to do with Mac computers.  It should  
have been sent to r-help.

(2) The problem seems to me to be the inconsistency in the number of  
digits representing
"day",  To remedy this, paste on a zero and then remove redundant  
zeroes:

foo <- function(x) {
             x <- paste(0,x,sep="")
             x <- substr(x,nchar(x)-5,nchar(x))
             strptime(x,format="%d%m%y")
}

x <- c(250706,50906)
foo(x)
[1] "2006-07-25" "2006-09-05"
All true. I have had to do steps equivalent to this, but learned from  
my experience. I now use colClasses to import dates as "character"  
rather than numeric.
David.
>
> HTH.
>
>     cheers,
>
>           Rolf Turner
> _______________________________________________
> R-SIG-Mac mailing list
> R-SIG-Mac at stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-mac
On Oct 23, 2010, at 2:09 PM, Turner Rolf wrote:

>
>
> sirmeelo at gmail.com [sirmeelo at gmail.com] wrote:
>
> Hi list,
>
> I am having trouble getting R to read and display dates correctly.
> My dates
> are in the form of day (no space) month (no space) year, for
> example: 250706
> and sometimes 50906.
>
> Any guidance would be appreciated...Thanks.
>
> (1) This question has nothing to do with Mac computers.  It should
> have been sent to r-help.
>
> (2) The problem seems to me to be the inconsistency in the number of
> digits representing
> "day",  To remedy this, paste on a zero and then remove redundant
> zeroes:
>
> foo <- function(x) {
>              x <- paste(0,x,sep="")
>              x <- substr(x,nchar(x)-5,nchar(x))
>              strptime(x,format="%d%m%y")
> }
>
> x <- c(250706,50906)
> foo(x)
> [1] "2006-07-25" "2006-09-05"

All true. I have had to do steps equivalent to this, but learned from
my experience. I now use colClasses to import dates as "character"
rather than numeric.

This will work unless the dates are whukked (Maori spelling --- I used to say "whucked" until
it was pointed out to me that there is no "c" in the Maori alphabet; this is a dodge to get around
the censorship imposed by "mailmarshal") up in the original file from which they
are imported. :-)

It is good to be a where that R is very powerful in its facilities for manipulating data and a little
understanding of R's capabilities can rescue you from almost any exigency.

    cheers,

         Rolf