I am trying to determine whether there is an entry in a Pandas column that has a particular value. I tried to do this with if x in df['id']
. I thought this was working, except when I fed it a value that I knew was not in the column 43 in df['id']
it still returned True
. When I subset to a data frame only containing entries matching the missing id df[df['id'] == 43]
there are, obviously, no entries in it. How to I determine if a column in a Pandas data frame contains a particular value and why doesn’t my current method work? (FYI, I have the same problem when I use the implementation in this answer to a similar question).