pandas :从指定列中删除具有特定字符串的行

In [91]: df = pd.DataFrame(dict(A=[5,3,5,6], C=[“foo”,“bar”,“fooXYZbar”, “bat”]))

In [92]: df
Out[92]:
A C
0 5 foo
1 3 bar
2 5 fooXYZbar
3 6 bat

In [93]: df=df[~df.C.str.contains(“XYZ”)]
Out[93]:
A C
0 5 foo
1 3 bar
3 6 bat