如果具有
Dateas
datetime类型,则可以使用
dayofweek获取星期几并基于该日期进行查询。
仅选择星期一:
df[df.index.get_level_values('Date').dayofweek == 0]选择星期一和星期五以外的日期:
import numpy as npdf[np.in1d(df.index.get_level_values('Date').dayofweek, [1,2,3,5,6])]# Col1 Col2 Col3 Col4# Date Two #2015-05-14 10 81.370003 6.11282 39.753 44.950001#11 80.419998 6.03380 39.289 44.750000#C3 80.879997 6.00746 41.249 44.360001#2015-05-19 3 80.629997 6.10465 41.047 40.980000#S9 80.550003 6.14370 41.636 42.790001#2015-05-21 19 80.480003 6.16096 42.137 43.680000


