I have a database that has a Week column. Weekday names are Sunday, Monday, Tuesday and only on. However, I would like to automatically change this to the following: Week = c("monday day","tuesday day","wednesday day","thursday day","friday day" "saturday","sunday day" ) .In this case below, as my database only has two days of the week, only Monday and Sunday will be changed. How to adjust this?
Test <- structure(list(date1 = as.Date(c("2021-11-01","2021-11-01","2021-11-01","2021-11-01")),
date2 = as.Date(c("2021-10-18","2021-10-18","2021-10-28","2021-10-30")),
Week = c("Monday", "monday", "Sunday", "Sunday"),
Category = c("FDE", "FDE", "FDE", "FDE"),
time = c(4, 6, 6, 3)), class = "data.frame",row.names = c(NA, -4L))