[Python] How do I go about creating an expected time column in a dataframe in Python?

I am analyzing bus route data where I have a table that has the times that the bus arrived at certain stops. I have a route schedule (from the bus website) with the expected times of the bus at each stop. Is there an efficient way to map the expected time at a certain stop based to what time is closest to the actual time the bus arrived at a stop?

Continue reading...