Filter by hour in Pandas

Question

How can I filter a DataFrame indexed by datetime so that I get only the entries within certain hours of every day?

I am looking for something equivalent to the following R code for an xts object

df["09:00:00::17:00:00"]

Answer 1

You want the between_time method: http://pandas.pydata.org/pandas-docs/dev/generated/pandas.DataFrame.between_time.html#pandas.DataFrame.between_time

Answer 2

Hope this helps: df[(df.Time > '08:00') & (df.Time < '08:05')]