Delete string from dataframe with condition using pandas

Question

I have data

                                          event_address           event_time  
0      https://mail.yandex.ru/clck=2230&uid=1189231...  2016-06-14 03:05:19   
1      https://mail.yandex.ru/?ncrnd=2230&uid=1189231...  2016-06-14 03:05:23   
2      https://mail.yandex.ru/clck=2230&uid=1189231...  2016-06-14 03:05:24   
3        http://mail.yandex.ru/?win=219&clid=2257587-216  2016-06-14 03:04:52   
4       https://mail.yandex.ru/?win=219&clid=2257587-216  2016-06-14 03:04:52   
5                     https://mail.yandex.ru/?ncrnd=2230  2016-06-14 03:05:12   
6      https://mail.yandex.ru/?ncrnd=2230&uid=1189231...  2016-06-14 03:05:25

I want to delete str, where url contain yandex.ru/clck. Desire output

                                          event_address           event_time    
1      https://mail.yandex.ru/?ncrnd=2230&uid=1189231...  2016-06-14 03:05:23      
3        http://mail.yandex.ru/?win=219&clid=2257587-216  2016-06-14 03:04:52   
4       https://mail.yandex.ru/?win=219&clid=2257587-216  2016-06-14 03:04:52   
5                     https://mail.yandex.ru/?ncrnd=2230  2016-06-14 03:05:12   
6      https://mail.yandex.ru/?ncrnd=2230&uid=1189231...  2016-06-14 03:05:25

I try use ~df[df.event_address.str.contains("yandex.ru/clck")]but it return

TypeError: bad operand type for unary ~: 'unicode'

Possible duplicate of stackoverflow.com/questions/35939552/… — Moon Cheesez
– Moon Cheesez, Commented Jun 23, 2016 at 15:01
And of stackoverflow.com/questions/37991058/… with just a ~ at the right place. — ysearka
– ysearka, Commented Jun 23, 2016 at 16:22

MaxU - stand with Ukraine · Accepted Answer · 2016-06-23 15:03:59Z

2

try this:

df[~df.event_address.str.contains(r"yandex.ru/clck")]

demo:

In [167]: df[~df.event_address.str.contains(r"yandex.ru/clck")]
Out[167]:
                                      event_address
1    https://mail.yandex.ru/?ncrnd=2230&uid=1189231
3   http://mail.yandex.ru/?win=219&clid=2257587-216
4  https://mail.yandex.ru/?win=219&clid=2257587-216
5                https://mail.yandex.ru/?ncrnd=2230
6    https://mail.yandex.ru/?ncrnd=2230&uid=1189231

In [168]: df
Out[168]:
                                      event_address
0      https://mail.yandex.ru/clck=2230&uid=1189231
1    https://mail.yandex.ru/?ncrnd=2230&uid=1189231
2      https://mail.yandex.ru/clck=2230&uid=1189231
3   http://mail.yandex.ru/?win=219&clid=2257587-216
4  https://mail.yandex.ru/?win=219&clid=2257587-216
5                https://mail.yandex.ru/?ncrnd=2230
6    https://mail.yandex.ru/?ncrnd=2230&uid=1189231

edited Jun 23, 2016 at 15:03

answered Jun 23, 2016 at 15:00

MaxU - stand with Ukraine

212k37 gold badges402 silver badges436 bronze badges

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

3 Comments

MaxU - stand with Ukraine Over a year ago

@ldevyataykina, yes, it does - see the demo in my answer

ysearka Over a year ago

I loved these comments! @Idevyataykina don't forget to accept the answer :)

NineWasps Over a year ago

@ysearka, sometimes, When the correct answer is ready, I can't do it, because It should take about 20 minutes after answer. Acception is done)

Collectives™ on Stack Overflow

Delete string from dataframe with condition using pandas

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related