Deleting rows in Pandas Dataframe, when column values match tuples in a list

Question

I have a data frame

 index  col1  col2 col3
     0     1     3    5
     1    12     7   21
  ...    ...   ...  ...

I want to delete some rows, with the criteria being that the values in col1 and col2 show up in a certain list. Let the list be [(12,7),(100,34),...]. In this case, the row with index 1 would be deleted.

jezrael · Accepted Answer · 2021-12-08 10:29:50Z

3

Use Index.isin for test MultiIndex created by both columns by DataFrame.set_index, invert mask by ~ and filter in boolean indexing:

L = [(12,7),(100,34)]

df = df[~df.set_index(['col1','col2']).index.isin(L)]
print (df)
   col1  col2  col3
0     1     3     5

answered Dec 8, 2021 at 10:29

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Deleting rows in Pandas Dataframe, when column values match tuples in a list

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related