#convert col fromt string to dt df['date_time'] = pd.to_datetime(df['date_time']) #boolean indexing on column day = i_94.copy()[(df['date_time'].dt.hour >= time_val) & (df['date_time'].dt.hour < time_val)] print(day.shape)