Pandas: delete string from df with condition

Asked Jul 22 '16 at 14:42

Active Jul 22 '16 at 14:42

Viewed 51 times

I have df

ID   url   date
1    vk.com    22.07.2016
2    twitter.com   22.07.2016
2    vk.com     22.07.2016
3    facebook.com    22.07.2016
4    forbes.com    22.07.2016

And I dave another df1

And I want delete string from df, if ID not in df1. Desire output:

ID   url   date
1    vk.com    22.07.2016
3    facebook.com    22.07.2016
4    forbes.com    22.07.2016

I try df[df.ID in df1['ID']] but it return TypeError: 'Series' objects are mutable, thus they cannot be hashed

asked Jul 22 '16 at 14:42

NineWasps

2,081
8
28
45

2

This is a dupe, basically you can do `df[df['ID'].isin(df1['ID'])]` – EdChum Jul 22 '16 at 14:46
@EdChum thank you! – NineWasps Jul 22 '16 at 14:54

Pandas: delete string from df with condition

0 Answers0