Extract month and year from a zoo yearmon object

Question

I have a yearmon object   require zoo  date1  lt - as yearmon  Mar 2012     b  Y   class date1     1   yearmon    How can I extract the month and year from this   month1  lt - fn date1  year1  lt - fn date1    What function should I use in place of fn

User · Answer

You can use format   library zoo  x  lt - as yearmon Sys time    format x   b    1   Mar  format x   Y    1   2012

User · Answer

The lubridate package is amazing for this kind of thing    gt  require lubridate   gt  month date1   1  3  gt  year date1   1  2012

User · Answer

The question did not state precisely what output is expected but assuming that for month you want the month number  January   1  and for the year you want the numeric 4 digit year then assuming that we have just run the code in the question   cycle date1      1  3 as integer date1      1  2012

User · Answer

For large vectors   y   as POSIXlt date1  year   1900      x year   years since 1900 m   as POSIXlt date1  mon   1          x mon   0   11

User · Answer

Use the format   method for objects of class  yearmon   Here is your example date  properly created    date1  lt - as yearmon  Mar 2012     b  Y     Then we can extract the date parts as required    gt  format date1    b      Month  char  abbreviated  1   Mar   gt  format date1    Y      Year with century  1   2012   gt  format date1    m      numeric month  1   03    These are returned as characters  Where appropriate  wrap in as numeric   if you want the year or numeric month as a numeric variable  e g    gt  as numeric format date1    m     1  3  gt  as numeric format date1    Y     1  2012   See  yearmon and  strftime for details - the latter explains the placeholder characters you can use

User · Answer

I know the OP is using zoo here  but I found this thread googling for a standard ts solution for the same problem  So I thought I d add a zoo-free answer for ts as well      create an example Date  date 1  lt - as Date  1990-01-01     extract year as numeric format date 1    Y      extract month as numeric format date 1    m

User · Answer

Having had a similar problem with data from 1800 to now  this worked for me   data2 date as character data2 date   lct  lt - Sys getlocale  LC TIME     Sys setlocale  LC TIME   C   data2 date lt - as Date data2 date  format     Y  m  d     and it works

[r] Extract month and year from a zoo::yearmon object

Examples related to r

Examples related to date

Examples related to zoo