[R] Date conversion

Sundar Dorai-Raj sdorairaj at gmail.com
Thu Mar 5 18:14:42 CET 2009


Hi,

There are possibly several ways to do this. My approach would be:

dates <- strptime(as.character(DATE), "%d%b%Y")
year <- dates$year + 1900
week <- floor(dates$yday/365 * 52)

HTH,

--sundar

On Thu, Mar 5, 2009 at 8:58 AM, Pele <drdionc at yahoo.com> wrote:
>
> Hi R users,
>
> I have a factor variable called date as shown below:  Can anyone share the
> best / most efficient way to extract year and week (e.g.  year = 2006, week
> = 52 for first record, etc..)?  My data set has 1 million records.
>
> DATE
> 11DEC2006
> 11SEP2006
> 01APR2007
> 02DEC2007
>
>
> Thanks in advance for any help!
> --
> View this message in context: http://www.nabble.com/Date-conversion-tp22355788p22355788.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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