Pandas: How to delete string with some value

Question

I have df

              subdomain search_engine search_term  
0                    vk.com          None        None  
1                    vk.com          None        None  
2              facebook.com          None        None  
3                    vk.com          None        None  
4                    vk.com          None        vkontakte

I need to get 4 vk.com None vkontakte

I try

df[~df.search_term.str == r"None"]

But it returns TypeError: bad operand type for unary ~: 'StringMethods'

@EdChum None - it's string. And when I use your example it doesn't delete anything — NineWasps
– NineWasps, Commented Jul 19, 2016 at 12:10
Then the cell element is not what you think it is can you show what df['search_term'].iloc[0] and type(df['search_term'].iloc[0]) returns — EdChum
– EdChum, Commented Jul 19, 2016 at 12:16

shivsn · Accepted Answer · 2016-07-19 13:11:36Z

1

I think this should do it:

In[75]:df[df.search_term.str.strip()!='None']
Out[75]: 
  subdomain search_engine search_term
4    vk.com          None   vkontakte

or will this work:

df[~df.search_term.str.match('None')]

edited Jul 19, 2016 at 13:11

answered Jul 19, 2016 at 12:38

shivsn

7,9141 gold badge28 silver badges34 bronze badges

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

6 Comments

NineWasps Over a year ago

I think I have some problem with my csv file. Nothing works

NineWasps Over a year ago

It didn't help. I have replaced this string to 0, but it didn't work too

shivsn Over a year ago

try the solution with str.match.

NineWasps Over a year ago

Can you say, why did it happen? df[~df.search_term.str.match('None')] this not works but df = df[~df.search_term.str.match('None')] works?

shivsn Over a year ago

what was the output when you ran the first statement without assigning it to df.

|

Collectives™ on Stack Overflow

Pandas: How to delete string with some value

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related