Get Hour from timestamp (date) in pandas python

dt.hour  is the inbuilt method to get hour from timestamp (date) in Pandas Python.  Let’s see how to

  • Get the hour from timestamp (date) in pandas python

First lets create the dataframe


import pandas as pd
import numpy as np
import datetime

date1 = pd.Series(pd.date_range('2012-1-1 11:20:00', periods=7, freq='H'))
df = pd.DataFrame(dict(date_given=date1))
print(df)

so the resultant dataframe will be

Get Hour from timestamp (date) in pandas python

hour function gets hour value of the timestamp

 


df['hour_of_timestamp'] = df['date_given'].dt.hour
print(df)

so the resultant dataframe will be

Get Hour from timestamp (date) in pandas python 2

 

 

Get Hour from timestamp (date) in pandas python                                                                                                           Get Hour from timestamp (date) in pandas python

Author

  • Sridhar Venkatachalam

    With close to 10 years on Experience in data science and machine learning Have extensively worked on programming languages like R, Python (Pandas), SAS, Pyspark.