python - 从数据框列中删除特定的一天(Pandas)

Question

这是我的数据框(时间是索引):

                     price
time
2015-11-07 00:00:00   180.250000
2015-11-07 00:15:00   176.350000
2015-11-07 00:30:00   177.533333
2015-11-08 00:45:00   180.216667

我想删除“2015-11-07”当天的所有条目，所以我尝试了:

remove = df.loc['2015-11-07]
df.drop(remove)

但我收到此错误labels ['price'] not contains in axis

Answer 1

您需要通过名为remove的DataFrame的index进行删除:

remove = df.loc['2015-11-07']
print (remove)
                          price
time                           
2015-11-07 00:00:00  180.250000
2015-11-07 00:15:00  176.350000
2015-11-07 00:30:00  177.533333

print (df.drop(remove.index))
                          price
time                           
2015-11-08 00:45:00  180.216667

另一个解决方案:

idx = df.index.difference(df.loc['2015-11-07'].index)
print (idx)
DatetimeIndex(['2015-11-08 00:45:00'], dtype='datetime64[ns]', name='time', freq=None)

print (df.loc[idx])
                          price
time                           
2015-11-08 00:45:00  180.216667