Drop row in pandas if it contains condition

Question

I am trying to drop rows in pandas based on whether or not it contains "/" in the cells in column "Price". I have referred to the question: Drop rows in pandas if they contains "???".

As such, I have tried both codes:

df = df[~df["Price"].str.contains('/')]

and

df = df[~df["Price"].str.contains('/',regex=False)]

However, both codes give the error: AttributeError: Can only use .str accessor with string values!

For reference, the first few rows of my dataframe is as follows:

 Fruit Price 0 Apple 3 1 Apple 2/3 2 Banana 2 3 Orange 6/7

May I know what went wrong and how can I fix this problem? Thank you very much!

Call dtype and see what's its dtype and try casting to string if its not a string using astype — sushanth
– sushanth, Commented Jun 17, 2020 at 17:09
Oh it is an object. I've tried to use astype but it's still an object — jenna_the_antenna
– jenna_the_antenna, Commented Jun 17, 2020 at 17:09

NYC Coder · Accepted Answer · 2020-06-17 17:08:51Z

1

Try this:

df = df[~df['Price'].astype(str).str.contains('/')] print(df) Fruit Price 0 Apple 3 2 Banana 2

answered Jun 17, 2020 at 17:08

NYC Coder

7,6443 gold badges14 silver badges25 bronze badges

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

Comments

dper · Accepted Answer · 2020-06-17 17:09:33Z

You need to convert the price column to string first and then apply this operation. I believe that price column doesn't have datatype string

df['Price'] = df['Price'].astype(str)

and then try

df = df[~df["Price"].str.contains('/',regex=False)]

Collectives™ on Stack Overflow

Drop row in pandas if it contains condition

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related