在pandas数据框中的特定时间之间选择数据

在pandas数据框中的特定时间之间选择数据

In [7]: index = date_range(‘20131009 08:30’,‘20131010 10:05’,freq=‘5T’)

In [8]: df = Dataframe(randn(len(index),2),columns=list('AB'),index=index)In [9]: dfOut[9]: <class 'pandas.core.frame.Dataframe'>DatetimeIndex: 308 entries, 2013-10-09 08:30:00 to 2013-10-10 10:05:00Freq: 5TData columns (total 2 columns):A    308  non-null valuesB    308  non-null valuesdtypes: float64(2)In [10]: df.between_time('9:00','10:00')Out[10]:       A         B2013-10-09 09:00:00 -0.664639  1.5974532013-10-09 09:05:00  1.197290 -0.5006212013-10-09 09:10:00  1.470186 -0.9635532013-10-09 09:15:00  0.181314 -0.2424152013-10-09 09:20:00  0.969427 -1.1566092013-10-09 09:25:00  0.261473  0.4139262013-10-09 09:30:00 -0.003698  0.0549532013-10-09 09:35:00  0.418147 -0.4172912013-10-09 09:40:00  0.413565 -1.0962342013-10-09 09:45:00  0.460293  1.2002772013-10-09 09:50:00 -0.702444 -0.0415972013-10-09 09:55:00  0.548385 -0.8323822013-10-09 10:00:00 -0.526582  0.7583782013-10-10 09:00:00  0.926738  0.1782042013-10-10 09:05:00 -1.178534  0.1842052013-10-10 09:10:00  1.408258  0.9485262013-10-10 09:15:00  0.523318  0.3273902013-10-10 09:20:00 -0.193174  0.8632942013-10-10 09:25:00  1.355610 -2.1608642013-10-10 09:30:00  1.930622  0.1746832013-10-10 09:35:00  0.273551  0.8706822013-10-10 09:40:00  0.974756 -0.3277632013-10-10 09:45:00  1.808285  0.0802672013-10-10 09:50:00  0.842119  0.3686892013-10-10 09:55:00  1.065585  0.8020032013-10-10 10:00:00 -0.324894  0.781885