如果df[:'2012-01-07']
返回日期在以下的sub-DataFrame,20120107
返回日期在20120107以上的日期是什么?df['2012-01-07':]
不...
对我来说,它工作完美,但是在实际数据中可能需要按sort_index
以下方式排序索引:
df = pd.DataFrame({'a':[0,1,2,5,4]}, index=pd.date_range('2012-01-05', periods=5))
print (df)
#if need ascending sorting
df = df.sort_index()
a
2012-01-05 0
2012-01-06 1
2012-01-07 2
2012-01-08 5
2012-01-09 4
print (df[:'2012-01-07'])
a
2012-01-05 0
2012-01-06 1
2012-01-07 2
print (df['2012-01-07':])
a
2012-01-07 2
2012-01-08 5
2012-01-09 4
df = pd.DataFrame({'a':[0,1,2,5,4]}, index=pd.date_range('2012-01-05', periods=5))
#descending sorting
df = df.sort_index(ascending=False)
print (df)
a
2012-01-09 4
2012-01-08 5
2012-01-07 2
2012-01-06 1
2012-01-05 0
print (df[:'2012-01-07'])
a
2012-01-09 4
2012-01-08 5
print (df['2012-01-07':])
a
2012-01-07 2
2012-01-06 1
2012-01-05 0
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句