Extract Month and Year From Date in R

Question

I have tried a number of methods to no avail  I have data in terms of a date  YYYY-MM-DD  and am trying to get in terms of just the month and year  such as  MM-YYYY or YYYY-MM   Ultimately  I would like it to look like this   ID    Date         Month Yr 1     2004-02-06   2004-02 2     2006-03-14   2006-03 3     2007-07-16   2007-07                          I am doing this in hopes of plotting money earned on average in a month  from a number of orders  over a period of time  Any help  or a push in the right direction would be much appreciated

User · Answer

The data table package introduced the IDate class some time ago and zoo-package-like functions to retrieve months  days  etc  Check  IDate   so  you can extract the desired info now in the following ways  require data table  df  lt - data frame id   1 3                   date   c  quot 2004-02-06 quot     quot 2006-03-14 quot     quot 2007-07-16 quot    setDT df  df    date    as IDate date      instead of as Date   df    yrmn    paste0 year date    -   month date     df    yrmn2    format date    Y- m

User · Answer

Use substring   d    2004-02-06  substr d 0 7   gt  2004-02

User · Answer

Here s another solution using a package solely dedicated to working with dates and times in R   library tidyverse  library lubridate    df  lt - tibble ID   1 3  Date   c  quot 2004-02-06 quot     quot 2006-03-14 quot    quot 2007-07-16 quot       gt    A tibble  3 x 2   gt       ID Date         gt     lt int gt   lt chr gt         gt  1     1 2004-02-06   gt  2     2 2006-03-14   gt  3     3 2007-07-16  df   gt     mutate      Date   ymd Date       Month Yr   format ISO8601 Date  precision    quot ym quot         gt    A tibble  3 x 3   gt       ID Date       Month Yr   gt     lt int gt   lt date gt       lt chr gt       gt  1     1 2004-02-06 2004-02    gt  2     2 2006-03-14 2006-03    gt  3     3 2007-07-16 2007-07  Created on 2020-09-01 by the reprex package  v0 3 0

User · Answer

This will add a new column to your data frame with the specified format   df Month Yr  lt - format as Date df Date     Y- m    df   gt    ID       Date Month Yr   gt  1  1 2004-02-06  2004-02   gt  2  2 2006-03-14  2006-03   gt  3  3 2007-07-16  2007-07    your data sample   df  lt - data frame  ID 1 3 Date   c  2004-02-06     2006-03-14     2007-07-16       a simple example   dates  lt -  2004-02-06   format as Date dates     Y- m    gt   2004-02    side note  the data table approach can be quite faster in case you re working with a big dataset   library data table  setDT df    Month Yr    format as Date Date     Y- m

User · Answer

The zoo package has the function of as yearmon can help to convert  require zoo   df ym lt -as yearmon df date   quot  Y  m quot

[r] Extract Month and Year From Date in R

Examples related to r

Examples related to date