Arrange Months Chronologically

[Dan Mungai]

using dplyr to sort my data. however it is not arranging in months chronologically but alphabetically

[Brandon Hurr]

One of the easiest ways would be to convert your month column to an ordered factor and then arrange it. Or, if you only want to arrange it and not convert to a factor you could arrange it on the factor version of itself. See the answer on this SO post for a way to do it:

https://stackoverflow.com/questions/46129322/arranging-rows-in-custom-order-using-dplyr

df %>%
    arrange(factor(Reg, levels = LETTERS[c(3, 1, 2)]), desc(Res), desc(Pop))

You could use the built-in month.name and month.abb variables if your spellings match those values. Assuming your column is called month and they are the full month names something like this should work.

df %>%
    arrange(factor(month, levels = month.name))

On Sat, Jun 20, 2020 at 1:15 AM Dan Mungai <mungai...@gmail.com> wrote:

using dplyr to sort my data. however it is not arranging in months chronologically but alphabetically

--
You received this message because you are subscribed to the Google Groups "manipulatr" group.
To unsubscribe from this group and stop receiving emails from it, send an email to manipulatr+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/manipulatr/ef067c29-d994-434f-b133-e99edf102d22o%40googlegroups.com.