def getSleepDate(data): firstDatetime = data.ix[0]['datetime'] if time(12,00) <= firstDatetime.time()<=time(23,59): return firstDatetime.date() else: return (firstDatetime - pd.DateOffset(1)).date()