pandas get hour from all timestamp 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')