Filtering Pandas DataFrames on dates

python datetime pandas filtering dataframe

If date column is the index, then use .loc for label based indexing or .iloc for positional indexing.

For example:

df.loc['2014-01-01':'2014-02-01']

If the column is not the index you have two choices:

See here for the general explanation

Note: .ix is deprecated.

python datetime pandas filtering dataframe

Previous answer is not correct in my experience, you can't pass it a simple string, needs to be a datetime object. So:

import datetime df.loc[datetime.date(year=2014,month=1,day=1):datetime.date(year=2014,month=2,day=1)]

python datetime pandas filtering dataframe

And if your dates are standardized by importing datetime package, you can simply use:

df[(df['date']>datetime.date(2016,1,1)) & (df['date']<datetime.date(2016,3,1))]

For standarding your date string using datetime package, you can use this function:

import datetimedatetime.datetime.strptime

CodeHunter