Extract month and year from a zoo::yearmon object

by

Use the format() method for objects of class "yearmon". Here is your example date (properly created!)

date1 <- as.yearmon("Mar 2012", "%b %Y")

Then we can extract the date parts as required:

> format(date1, "%b") ## Month, char, abbreviated
[1] "Mar"
> format(date1, "%Y") ## Year with century
[1] "2012"
> 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.

> as.numeric(format(date1, "%m"))
[1] 3
> as.numeric(format(date1, "%Y"))
[1] 2012

See ?yearmon and ?strftime for details – the latter explains the placeholder characters you can use.

More Related Contents:

  1. Converting year and month (“yyyy-mm” format) to a date?
  2. Replacing NAs with latest non-NA value
  3. How to prevent ifelse() from turning Date objects into numeric objects
  4. Convert date-time string to class Date
  5. Replace NA with previous or next value, by group, using dplyr
  6. Changing date format in R
  7. Basic lag in R vector/dataframe
  8. Split date-time column into Date and time variables
  9. Find which season a particular date belongs to
  10. as.Date with dates in format m/d/y in R
  11. as.Date returning NA while converting from ‘ddmmmyyyy’
  12. Adaptive moving average – top performance in R
  13. R: How to handle times without dates?
  14. Extract Month and Year From Date in R
  15. Extracting time from POSIXct
  16. Format for ordinal dates (day of month with suffixes -st, -nd, -rd, -th)
  17. How to sort a data frame by date
  18. Converting date in Year.decimal form in R
  19. How to subtract years?
  20. Creating regular 15-minute time-series from irregular time-series
  21. Subsetting a dataframe for a specified month and year
  22. Replace -inf, NaN and NA values with zero in a dataset in R
  23. R: merge two irregular time series
  24. Convert integer as “20160119” to different columns of “day” “year” “month”
  25. R not finding package even after package installation
  26. change a column from birth date to age in r
  27. use rollapply and zoo to calculate rolling average of a column of variables
  28. Convert two-digit years to four-digit years with correct century
  29. Is there a _fast_ way to run a rolling regression inside data.table?
  30. optimized rolling functions on irregular time series with time-based window

Leave a Comment