TypeError: bad operand type for unary ~: float
df = df[~df["column"].str.contains("Total")]
TypeError: bad operand type for unary ~: 'float'
Why does .str.contains() return a float? What should I be doing here?
Solution 1:
I think there are NaNs values, so need specify parameter na:
df = pd.DataFrame({
'column': ['Total','a',np.nan],
'B': list(range(3))
})
print (df)
column B
0 Total 0
1 a 1
2 NaN 2
df = df[~df["column"].str.contains("Total", na=False)]
print (df)
column B
1 a 1
2 NaN 2