Filter Pandas DataFrame by time index

Solution 1:

You want df.loc[df.index < '2013-10-16 08:00:00'] since you're selecting by label (index) and not by value.

selecting by label