示例-我使用评论中的信息：
import pandas as pdimport StringIOimport datetimedata = '''time --- value1984-12-12 14:08:00 --- 11984-12-12 14:25:00 --- 21984-12-12 14:47:00 --- 41984-12-12 16:37:00 --- 31984-12-12 16:37:00 --- 91984-12-12 16:37:00 --- 51984-12-12 17:52:00 --- 31984-12-12 17:52:00 --- 71984-12-12 19:29:00 --- 2'''#------------------------------------------------df = pd.read_csv(StringIO.StringIO(data), sep=' --- ')df['time'] = pd.DatetimeIndex(df['time'])print "nDataframe:n", dfprint 'nIndex:', type(df.index)#------------------------------------------------df.set_index(keys='time', inplace=True)print "nDataframe:n", dfprint 'nIndex:', type(df.index)#------------------------------------------------start = datetime.time(14,50,0)end = datetime.time(18,0,0)print "nResult:n", df['value'].between_time(start, end)
结果：
Dataframe: time value0 1984-12-12 14:08:00 11 1984-12-12 14:25:00 22 1984-12-12 14:47:00 43 1984-12-12 16:37:00 34 1984-12-12 16:37:00 95 1984-12-12 16:37:00 56 1984-12-12 17:52:00 37 1984-12-12 17:52:00 78 1984-12-12 19:29:00 2Index: <class 'pandas.core.index.Int64Index'>Dataframe: valuetime1984-12-12 14:08:00 11984-12-12 14:25:00 21984-12-12 14:47:00 41984-12-12 16:37:00 31984-12-12 16:37:00 91984-12-12 16:37:00 51984-12-12 17:52:00 31984-12-12 17:52:00 71984-12-12 19:29:00 2Index: <class 'pandas.tseries.index.DatetimeIndex'>Result:time1984-12-12 16:37:00 31984-12-12 16:37:00 91984-12-12 16:37:00 51984-12-12 17:52:00 31984-12-12 17:52:00 7Name: value, dtype: int64
