extract pattern from string in python unexpected result

Question

x = pd.Series(['CA1234567', 'QWCEC']) 
x.str.extract(r'(CA|US)\d{7}$')

the expected result is [CA1234567, Nan], but get [CA, Nan].

bigbounty · Accepted Answer · 2020-07-22 01:52:29Z

1

Choose the first group after the regex

In [105]: x = pd.Series(['CA1234567', 'QWCEC'])
     ...: x.str.extract(r'((CA|US)\d{7})$')[0].tolist()
Out[105]: ['CA1234567', nan]

answered Jul 22, 2020 at 1:52

bigbounty

17.5k7 gold badges45 silver badges76 bronze badges

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

Comments

rioV8 · Accepted Answer · 2020-07-22 01:51:25Z

1

Include the number in the capture group

x = pd.Series(['CA1234567', 'QWCEC']) 
x.str.extract(r'((CA|US)\d{7})$')

answered Jul 22, 2020 at 1:51

rioV8

29.7k4 gold badges48 silver badges68 bronze badges