TypeError when using the query method on a pandas column

Question

Trying to query the DataFrame for only the rows under the 'Products' column that contain the string 'Microsoft'. The string 'Microsoft' appears as a standalone cell value as well as a comma-separated value in certain cells.

Query function worked before but now it's giving TypeError:

df = df.query("Products.str.contains('Eloqua', case=False)")

df["Products"].dtype returns Object and df["Products"].isna().sum() returns 0. Whats odd is above query worked before. I restarted the kernel a few times without any success. — Shah_z51
– Shah_z51, Commented Feb 7, 2023 at 3:26

mike · Accepted Answer · 2023-02-06 22:59:07Z

1

If df["Products"].dtype returns "Object" following should do it.

df = df[df.Products.str.contains('Microsoft', case = False)]

answered Feb 6, 2023 at 22:59

mike

1938 bronze badges

Sign up to request clarification or add additional context in comments.

that did it, thanks. Still cant understand why the query failed tho.