Pandas Delete String from 1 dataframe if it exist in a list [duplicate]

Question

I have a data frame with keywords and a list of words which if exist in that data frame then should be deleted.

Only the word should be deleted not the column or row from the data frame.

Here is the Dataframe I have. I have a list of words as well as a pandas series of it. I want to drop only the words which are on that list from the keywords.

enter image description here

It will be better if you can post your data frame and your expected data frame — WIND.Knight
– WIND.Knight, Commented Oct 28, 2017 at 3:09

kjmerf · Accepted Answer · 2017-10-28 05:21:20Z

0

You could loop through it like this:

import pandas as pd

df = pd.DataFrame([['www.test.com', ['test', 'joke']],
                   ['www.google.com', ['jacket', 'coffee', 'second']],
                   ['www.stackoverflow.com', ['word', 'another']]],
                   columns = ['URL', 'keywords'])

values = ['test', 'ten', 'second', 'stackoverflow']


for index, row in df.iterrows():
    for word in row['keywords']:
        if word in values:
            row['keywords'].remove(word)

print(df)

#output

                     URL          keywords
0           www.test.com            [joke]
1         www.google.com  [jacket, coffee]
2  www.stackoverflow.com   [word, another]

edited Oct 28, 2017 at 5:21

answered Oct 28, 2017 at 4:18

kjmerf

4,3853 gold badges24 silver badges29 bronze badges

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

5 Comments

karancraze Over a year ago

This code gives every single value from the dataframe. But unable to enter the if statement.

kjmerf Over a year ago

Works for me. See the full example given. Update above.

karancraze Over a year ago

I did not want to delete the whole row. Want to delete just the keyword from its list.

kjmerf Over a year ago

@karancraze. Now try it

karancraze Over a year ago

Thanks a lot. It works now. You saved me.

Collectives™ on Stack Overflow

Pandas Delete String from 1 dataframe if it exist in a list [duplicate]

1 Answer 1

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Linked

Related