Extraction of hour from datetime object in Pandas-CodePudding

When I extract hours from 23.35 using dt.hour in pandas it returns 0. But i want to get 24. How to do that?

CodePudding user response：

Assuming this input:

s = pd.to_datetime(pd.Series(['00:10', '12:30', '23:35']))
0   2022-04-18 00:10:00
1   2022-04-18 12:30:00
2   2022-04-18 23:35:00
dtype: datetime64[ns]

hours

s.dt.hour
0     0
1    12
2    23
dtype: int64

An indeed, if you round:

s.dt.round('h').dt.hour
0     0
1    12
2     0
dtype: int64

what you can do it to convert rounded hour minutes

s.dt.hour.add(s.dt.minute/60).round().astype(int)
0     0
1    12
2    24
dtype: int64