Pandas: Delete Row if cell contains specific text

Question

this code in pandas does not work. I want it to delete the row if the column contains any of the text/numbers provided Currently I can only get it to work if the cell matches the exact text being passed in my code .. as in it only deletes cells that say Fin* not Finance or Finly...

df2 = df[df.Team != 'Fin*']

Answer 1

You can using startswith

df[~df.Team.str.startswith('Fin')]

Or

df[~df.Team.str.contains('Fin')]

Answer 2

import pandas as pd
df = pd.DataFrame(dict(A=[1,2,3,4], C=["abc","def","abcdef", "lmn"]))

df:

    A   C
0   1   abc
1   2   def
2   3   abcdef
3   4   lmn

df[df.C.str.contains("abc") == False]

OR as suggested by @RafaelC

df[~df.C.str.contains("abc")]

Output:

    A   C
1   2   def
3   4   lmn