Python Pandas regex match

Asked Dec 01 '22 at 11:23

Active Dec 01 '22 at 11:25

Viewed 24 times

I have some text like test text 1 (something xxx) in excel file. I am trying to match everything inside the bracket () including the brackets

Below Pandas code that i use is not matching any record.

regex_pat = re.compile(r"\(.*$") df['column'].str.match(regex_pat)

But the same pattern \(.*$is working in notepad++ regex search. DO i need to change anything here.

edited Dec 01 '22 at 11:25

asked Dec 01 '22 at 11:23

Rameshwaran

Depending on your mode, `$` can match the end of the string of the end of the line. Which is your case? Can't you use simply `$[^()]*$`? – logi-kal Dec 01 '22 at 11:28
If you just need what is inside `()` with nothing before or after, then this `$([^)]+)$` should be enough – Buttered_Toast Dec 01 '22 at 11:29
Use `str.contains` since `str.match` only searches at the string start. – Wiktor Stribiżew Dec 01 '22 at 11:30

0 Answers0