How to delete a row if string matches

Question

I have a DataFrame with a series that contains '@@@'. I want to delete rows containing this pattern.

I wrote the code for matching like this:

df[df['employee'].str.match('@', na = False)]

How do I delete the row if a match is found?

if this matches, just invert the condition `df[~df['employee'].str.match('@',na=False)]` — anky, Aug 09 '19 at 16:21
Possible duplicate of [search for "does-not-contain" on a dataframe in pandas](https://stackoverflow.com/questions/17097643/search-for-does-not-contain-on-a-dataframe-in-pandas) — Ankur Sinha, Aug 09 '19 at 20:35

score 1 · Accepted Answer · answered Aug 09 '19 at 16:39

1

Use pandas.DataFrame.drop:

df = df.drop(df[df['employee'].str.match('@',na=False)].index)

answered Aug 09 '19 at 16:39

snowneji

score 1 · Answer 2 · answered Aug 09 '19 at 20:21

1

From what I understand, you want to remove the rows that are filled with @@@ in the column employee. If that is correct, then try:

df = df.loc[df["employee"] != "@@@"]

answered Aug 09 '19 at 20:21

Arturo Sbr

2 Answers2