Recombining Mon and Year values
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 at 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 at 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 at 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 at 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.