[R] Recombining Mon and Year values

[Eric Berger]

An alternative that does not use the zoo package but uses the built-in
constant month.abb

df1 <- data.frame(Year = c(2021, 2021, 2021),
                   Mon = c("Mar", "Jan", "Apr"))

df1$mon_year <- df1$Year*100 + sapply(df1$Mon, \(x) match(x,month.abb))

sort(df1$mon_year)

On Wed, May 17, 2023 at 2:48 AM Jeff Newmiller <jdnewmil using dcn.davis.ca.us> wrote:
>
> I don't use lubridate, but that package works with Date and POSIXt types, which I do use. Just remember to include a day when converting (1st of month is typical), and use an output format to hide the day when you plot.
>
> On May 16, 2023 1:29:27 PM PDT, Jeff Reichman <reichmanj using sbcglobal.net> wrote:
> >R Help
> >
> >
> >
> >I have a data.frame where I've broken out the year <dbl> and an ordered
> >month <ord> values. But I need to recombine them so I can graph mon-year in
> >order but when I recombine I lose the month order and the results are
> >plotted alphabetical.
> >
> >
> >
> >Year        month  mon_year
> >
> ><dbl>     <ord>
> >
> >2021     Mar        Mar-2021
> >
> >2021     Jan         Jan-2021
> >
> >2021     Apr         Apr-2021
> >
> >
> >
> >So do I need to convert the months back to an integer then recombine to
> >plot.
> >
> >
> >
> >Jeff Reichman
> >
> >
> >       [[alternative HTML version deleted]]
> >
> >______________________________________________
> >R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> >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.
>
> --
> Sent from my phone. Please excuse my brevity.
>
> ______________________________________________
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.