sort Dataset based on 1 date variable and 2 string variables

Question

I want to able to sort a dataset in the following way: String variable (ascending), date variable (descending) and string variable (ascending). The date variable was a POSIXt object which i converted into a date using (as.date()). I am able to sort based on the sting variables(both of which as in ascending) but unable to sort based on date, i get an error message stating that it not a vector or that I cannot use a - (minus) sign.

Please produce a reproducible example https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example — Wietze314, Sep 26 '19 at 19:32

score 0 · Accepted Answer · answered Sep 26 '19 at 19:58

You can use desc() from dplyr

library(dplyr)
data <- expand.grid(date = seq.Date(Sys.Date() - days(10), Sys.Date(), "days"),
            string1 = diamonds$color %>% levels() %>% unique(),
            string2 = diamonds$cut %>% levels() %>% unique()
       )
data %>% 
  arrange(desc(date), string1, string2)

sort Dataset based on 1 date variable and 2 string variables

1 Answers1