Pandas: How can I check if a pandas dataframe contains a specific value?

Question

Specifically, I want to see if my pandas dataframe contains a False.

It's an nxn dataframe, where the indices are labels.

So if all values were True except for even one cell, then I would want to return False.

ℕʘʘḆḽḘ · Accepted Answer · 2016-06-30 00:22:15Z

1

your question is a bit confusing, but assuming that you want to know whether there is at least one False in your dataframe, you could simply use

mask = df.mycol == False
mask.value_counts()
mask.sum()
mask.sum() > 0

All will tell you the truth

answered Jun 30, 2016 at 0:22

ℕʘʘḆḽḘ

19.5k39 gold badges148 silver badges259 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Attila Tanyi · Accepted Answer · 2016-07-29 10:28:06Z

0

If you just want to scan your whole dataframe looking for a value, check df.values. It returns an array of all the rows in the dataframe.

value = False  # This is the value you're searching
df_contains_value = any([value in row for row in df.values])

answered Jul 29, 2016 at 10:28

Attila Tanyi

5,0845 gold badges29 silver badges35 bronze badges