很多数据是以Timestamp为index的。
open close diff
2010-01-04 11.48 11.29 0
2010-01-05 11.28 11.07 0
2010-01-06 11.10 11.46 0
2010-01-07 11.48 11.07 0
2010-01-08 11.00 10.79 0
如果要选取的特定时间段的数据,并能用2010-01-04,也不能直接用0。
index里存的是一个时间戳。
df.index[0]
Out[16]: Timestamp('2010-01-04 00:00:00')
所以,将index写成时间戳格式就可以了。
df['2010-01-04':'2010-01-07']
Out[24]:
open close diff
2010-01-04 11.48 11.29 0
2010-01-05 11.28 11.07 0
2010-01-06 11.10 11.46 0
2010-01-07 11.48 11.07 0
或者,
df['2010-01-04 00:00:00':'2010-01-07 00:00:00']
Out[14]:
open close diff
2010-01-04 11.48 11.29 0
2010-01-05 11.28 11.07 0
2010-01-06 11.10 11.46 0
2010-01-07 11.48 11.07 0