How to round off timestamp column to upper minute in pandas

Question

I have dataframe with timestamp values and i want to round off the timestamp to upper minute.

But i am not getting the desired output. I have used the following link to do the same:

 [1]: http://stackoverflow.com/questions/32344533/how-do-i-round-datetime-column-to-nearest-quarter-hour/32344636

how can i do that using pandas?

example:  output:
05:06:34  05:07
05:09:43  05:10

A [Minimal, Complete, and Verifiable](http://stackoverflow.com/help/mcve) example makes it easier for us to help you. — Stephen Rauch, Mar 06 '17 at 07:44
I think it is answered [here](http://stackoverflow.com/q/42619947/2901002) — jezrael, Mar 06 '17 at 08:12
@StephenRauch But i want to round off based on seconds value. — , Mar 06 '17 at 09:01

score 0 · Accepted Answer · answered Mar 06 '17 at 15:38

You can write a function that will round up to the nearest minute:

Code:

import datetime as dt
def round_up_to_minute(timestamp):
    return timestamp + dt.timedelta(
        seconds=60-timestamp.second,
        microseconds=-timestamp.microsecond)

Test Code:

To apply it to a dataframe, you can do something like:

now = dt.datetime.now()
now_plus = now + dt.timedelta(minutes=1)
df = pd.DataFrame(data=[[now, now], [now_plus, now_plus]],
                  columns=['datetime', 'datetime_rounded'])

df['datetime_rounded'] = df['datetime_rounded'].apply(round_up_to_minute)

print(df)

Results:

                 datetime    datetime_rounded
0 2017-03-06 07:36:54.794 2017-03-06 07:37:00
1 2017-03-06 07:37:54.794 2017-03-06 07:38:00

How to round off timestamp column to upper minute in pandas

1 Answers1