Extract multiple substrings from a string in pandas

Question

I have a pandas Series where I have to extract all the substrings within parenthesis. A string might contain multiple such substrings as well as no such substrings as well. How can such a condition be handled

abc(def)ghi(jkl)aaa
jklmnopqr(jkl)
(ab)cde(ghi)
lmnoprst uvwxyz

If I use str.extract, I can obtain only one substring at a time from a string with a.str.extract('.*\((.*)\)'). So in effect, I miss the substring def.

How can this be solved.?

The desired outcome is

def
jkl
ab
ghi

@mr_mo I am getting asserion error 1 columns passed, passed data had 19 columns — Amrith Krishna
– Amrith Krishna, Commented Oct 8, 2018 at 14:59
@mr_mo- It was negligence from my side. I was using pandas 0.18. After updating to pandas 0.23 everything works fine as per the accepted answer below. Apologies from my side. — Amrith Krishna
– Amrith Krishna, Commented Oct 8, 2018 at 15:12

Scott Boston · Accepted Answer · 2018-10-08 15:05:53Z

2

Try:

df[0].str.extractall(r'\((\w+)\)')

Output:

           0
  match     
0 0      def
  1      jkl
1 0      jkl
2 0       ab
  1      ghi

answered Oct 8, 2018 at 15:05

Scott Boston

154k15 gold badges160 silver badges207 bronze badges

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

Collectives™ on Stack Overflow

Extract multiple substrings from a string in pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related