pandas get hour of all timestamps code example

Example 1: taking hour information from time in pandas

sales['datehour'] = sales['date'].dt.hour

Example 2: pandas set hour for timestamp

In [18]: ts
Out[18]: Timestamp('2014-11-12 13:35:00')

In [19]: ts.replace(hour=0)
Out[19]: Timestamp('2014-11-12 00:35:00')