regex pattern to match whole word or word followed by another

user_16129209 0
Viewed 58

I'm starting to learn regex in order to match words in python columns and replace them for other values.

df['col1']=df['col1'].str.replace(r'(?i)unlimi+\w*', 'Unlimited', regex=True)

This pattern serves to match different variations of the world Unlimited. But I have some values in the column that have not only one word, but two or more: ex:

[Unlimited, Unlimited (on-net), Unlimited (on-off-net)]`

I was wondering if there is a way to match all of the words in the previous example with a single regex line.

pandas python regex
1 Answers

You can use

df['col1']=df['col1'].str.replace(r'(?i)unlimi\w*(?:\s*\([^()]*\))?', 'Unlimited', regex=True)

See the regex demo.

The (?i)unlimi\w*(?:\s*\([^()]*\))? regex matches

  • (?i) - the regex to the right is case insensitive
  • unlimi - a fixed string
  • \w* - zero or more word chars
  • (?:\s*\([^()]*\))? - an optional sequence of
    • \s* - zero or more whitespaces
    • \( - a ( char
    • [^()]* - zero or more chars other than ( and )
    • \) - a ) char.
user_38329700
Related