I have two dataframes. I want to eliminate rows from first dataframe which has matching string in another dataframe.
I tried pd.merge()
but was unable to get the required results.
For example:
df1 =
websites
0 https://www.google.com
1 https://www.abcd.com
2 http://en.wikipedia.org
df2 =
blacklist_website
0 google
1 yahoo
2 wikipedia
The final dataframe should be like this :
result
0 https://www.abcd.com