Convert datetime to the cloest time point

Question

I have a dateset as below.

                      dummy                
datetime
2015-10-25 06:00:00      1 
2015-04-05 20:00:00      1 
2015-11-24 00:00:00      1 
2015-08-18 08:00:00      1 
2015-10-21 12:00:00      1

I want to change the datetime to the cloest predefined time point, say 00:00:00 and 12:00:00

                      dummy                
datetime
2015-10-25 00:00:00      1 
2015-04-05 12:00:00      1 
2015-11-24 00:00:00      1 
2015-08-18 00:00:00      1 
2015-10-21 12:00:00      1

Check https://stackoverflow.com/q/32723150/4636715 for rounding up to closest top/bottom of hour. — vahdet, Mar 14 '19 at 06:25

jezrael · Accepted Answer · 2019-03-14T07:21:55.270

2

Here is possible use DatetimeIndex.floor:

df.index = df.index.floor('12H')
print (df)
                     dummy
datetime                  
2015-10-25 00:00:00      1
2015-04-05 12:00:00      1
2015-11-24 00:00:00      1
2015-08-18 00:00:00      1
2015-10-21 12:00:00      1

edited Mar 14 '19 at 07:21

answered Mar 14 '19 at 06:27

jezrael

822,522
95
1,334
1,252

Convert datetime to the cloest time point

1 Answers1