Python dataframe - how to round datatime series to the next business day at a specific time

Question

Hi all

I have a column of datetime in a Python dataframe. These dates consist of non-busess days such as times on Saturdays and Sundays, and I would like to round these dates to, say, 10am of the next business day.

For example, if(dt.weekday = =6 | dt.weekday ==7), then the next business day at 10:00.

Is this possible??

Answer 1

So you are using pandas DataFrames? Which format do your datetime objects have? And could you please send your code, this would be very helpful. Btw, what you describe is possible, if I understood it right.
In the example, the python syntax should be:

# example code begin
if dt.weekday == 6 or dt.weekday == 7:
# \t some code
# example code end