import datetime
now = datetime.datetime.now()
yesterday = now + datetime.timedelta(days=-1)
fmt = '%Y-%m-%d'
df.ix[yesterday.strftime(fmt):now.strftime(fmt)]
python pandas selecting values based on age