TypeError: bad operand type for unary ~: float

Question

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?

Answer 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