Boolean with python exact string match

Question

I want to select articles based on the Boolean condition as

(unemployment OR inflation) AND (covid19 OR uncertain) AND (tax OR spending OR bank)

I am looking to do it by exact string matching. I have given below codes below. The problem with the current code is that it gets me words as, taxes, taxable, taxpayers for the word "tax" Thanks in advance!!

df = data[['date', 'title', 'body_text']]

def wordestimaor(X):
  
    df['count'] = X.body_text.str.contains("covid19|uncertain")\
     & X.body_text.str.contains("unemployment|inflation")\
     & X.body_text.str.contains("|tax|spending|bank",case = False,regex= True) 
         return X.head(2)
wordestimaor(df)

score 1 · Accepted Answer · 2020-11-09 17:21:06Z

1

You need to write it with spaces on left and right, so it will find only full words (like instead of "covid19" you need to write " covid19 ").

But sometimes it can't work, like in this situation: "covid19," (with comma). You need to check these variants too. To do that, a function can be very useful.

symbols = [' ', ',', ';', '!', '?', '.']

def find_word(word):
    for smb in symbols:
        if X.body_text.str.contains(' ' + word + smb):
             return true
    return false

Edit: If the word is standing in the beginning of a sentence, it will start with a capital letter. So you can also check it.

edited Nov 9, 2020 at 17:21

answered Nov 9, 2020 at 17:10

user14513063

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

1 Comment

shafi Q Over a year ago

Yeap I just tried but I found it missing some of the original variables.

Collectives™ on Stack Overflow

Boolean with python exact string match

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related