Pandas create multiple columns through multiple regex capture groups

Question

I have a column in a dataframe that looks like this:

COMPRA DE MANTENIMIENTO INSUMOS OT:15424 PLACA:TSW894 OC:28826

and I want to create two new columns in this way:

df[['OT','OC']] = df['FAC_DESC'].str.extract(r'(OT\S*)(OC\S*)')

But is not working, (both columns fill with NaN's)only works when I use only one capture group or when I use '?' between the capture groups, but only catch the last group. I believe I'm missing something...

Henry Yik · Accepted Answer · 2020-03-02 04:30:06Z

4

The easiest way is to modify your regex pattern to also match the words between OT and OC by adding .*:

df = pd.DataFrame({"col":["COMPRA DE MANTENIMIENTO INSUMOS OT:15424 PLACA:TSW894 OC:28826"]})

df[['OT','OC']] = df['col'].str.extract(r'(OT\S*).*(OC\S*)')

print (df)

                                                 col        OT        OC
0  COMPRA DE MANTENIMIENTO INSUMOS OT:15424 PLACA...  OT:15424  OC:28826

answered Mar 2, 2020 at 4:30

Henry Yik

22.6k5 gold badges21 silver badges44 bronze badges

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

Collectives™ on Stack Overflow

Pandas create multiple columns through multiple regex capture groups

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