df = pd.DataFrame(dict(A=[0,1,2,3], C=["Ghana","Nigeria","Africa","South Africa"]))
df[~df.C.str.contains("Africa")]
I want to delete the row with with only "Africa" without deleting the row with "South Africa"
Asked
Active
Viewed 12 times
0
mozway
- 194,879
- 13
- 39
- 75
-
simply `df[df['C'].ne('Africa')]`? – mozway Jun 08 '22 at 09:48
-
or would you match other combinations with "Africa", just not "South Africa"? – mozway Jun 08 '22 at 09:49