Pandas: delete string with condition

Question

I have df

ID     url     code
111    vk.com   1
111    twitter.com   1
222    facebook.com   1
222    vk.com    1
222    avito.ru   3

Desire output:

ID     url     code
111    vk.com   1
222    facebook.com   1
222    avito.ru     3

I need to delete string, if previous code is equal to this string and ID is equal to this string.

DocZerø · Accepted Answer · 2016-08-09 12:10:30Z

2

You can use drop_duplicates() and specify a subset of columns to use.

df.drop_duplicates(['ID', 'code'], keep='first')

This will only consider the ID and code column and will keep the first occurrence, removing the other duplicates.

answered Aug 9, 2016 at 12:10

DocZerø

8,61511 gold badges44 silver badges75 bronze badges

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

1 Answer 1