r - How to group date as day

Question

I'm trying to convert the date to something like DAY1, DAY2, DAY3, instead of normal Monday, Tuesday, Wednesday.

rbind(DWReport__04,DWReport__05,DWReport__06,
          DWReport__07,DWReport__08,DWReport__09,
          DWReport__10,DWReport__11,DWReport__12,
          DWReport__13) %>%
           mutate( DAY = day(as.Date(Date, "%d/%m/%Y")))

can anyone help with adjustment on the code ?

Answer 1

I think you've done the hard bit already.

Where you have mutate( DAY = day(as.Date(Date, "%d/%m/%Y")))

I believe you could just use: mutate(DAY = paste0("DAY", day(as.Date(Date, "%d/%m/%Y"))))