Delete Row from Pandas DataFrame based on cell value

Question

How can i delete a row in a Pandas Dataframe, based on a cell value without giving a specific column name?

For example:

I have this DataFrame and i want to delete all rows where a cell contains the value 'd'.

So I end up with the DataFrame

  A B C D
2 1 3 4 0
4 3 2 1 7

Is there a way to achive this? My google skills only found solutions where a specific column name is required.

MaxU - stand with Ukraine · Accepted Answer · 2017-06-17 15:58:44Z

5

you can do it this way:

df = df[~df.select_dtypes(['object']).eq('d').any(1)]

Result:

In [23]: df
Out[23]:
   A  B  C  D
2  1  3  4  0
4  3  2  1  7

answered Jun 17, 2017 at 15:58

212k37 gold badges402 silver badges436 bronze badges

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

Comments

Scott Boston · Accepted Answer · 2017-06-17 16:05:27Z

3

Another way you could do it to use astype, ne and all:

df[df.astype(str).ne('d').all(axis=1)]

Output:

   A  B  C  D
2  1  3  4  0
4  3  2  1  7

Another way:

df.where(df.values != 'd').dropna()

Output:

   A  B  C  D
2  1  3  4  0
4  3  2  1  7

answered Jun 17, 2017 at 16:05

Scott Boston

154k15 gold badges160 silver badges207 bronze badges