python中loc中的条件错误

Question

我有一个如下的日期框架

mydf = pd.DataFrame({'month':[2,3,7,8],'day':[29,24,20,29]})
>>> mydf
   day  month
0   29      2
1   24      3
2   20      7
3   29      8

>>> leapdf =  mydf.loc[(mydf['month'] == 2) & (mydf['day'] == 29) ]
>>> leapdf
   day  month
0   29      2

>>> otherdf =  mydf.loc[(mydf['month'] != 2) & (mydf['day'] != 29) ]
>>> otherdf
   day  month
1   24      3
2   20      7

除此之外，我希望第29天和第8个月也包括在内。但不包括在内。谁能告诉我错误是什么

谢谢

Answer 1

对于or，您需要|：

otherdf =  mydf.loc[(mydf['month'] != 2) | (mydf['day'] != 29) ]

什么是相同的：

otherdf =  mydf.loc[~((mydf['month'] == 2) & (mydf['day'] == 29)) ]
print (otherdf)
   day  month
1   24      3
2   20      7
3   29      8