Is there a way to use the round date to next trading day while keeping both date and variable columns in R?

152 Views Asked by At

How can I round the dates in the date column to the following business day? So each Saturday, Sunday and holiday should be transformed to the following business day. Furthermore, how can we include the output from the other columns as well in the transformation to following business days?

I tried this with the bizdays function:

TestDates <- RawTweetDataWSentiment
View(TestDates)

bizdays.options$set(default.calendar="UnitedKingdom/ANBIMA")

cal <- create.calendar("UnitedKingdom/ANBIMA", holidays=holidaysANBIMA, weekdays=c("saturday", "sunday"))

adjust.next(TestDates$Date, cal)

TestDates1 <- adjust.next(TestDates$Date, cal)
View(TestDates1)

This however only returns the date column

Does anyone know how to do this in R?

0

There are 0 best solutions below