Extract values from string column in pandas dataframe

Question

I have a column in a dataframe which have a pattern as shown in the below example

id=1;name=x;color=blue;

I am trying to extract the value for name and store it in the same dataframe with column name as "name" and value is "x"

I tried the below code but it doesn't seem to work correctly

df['name'] = df['col'].str.extract("'name': '(.*?)'")

There are no quotes in the string, this will never match name': '(.*?)' — The fourth bird
– The fourth bird, Commented Mar 9, 2022 at 14:32

Wiktor Stribiżew · Accepted Answer · 2022-03-09 14:31:28Z

1

The 'name': '(.*?)' regex is meant to extract a string between 'name': ' and the next ' char. You do not have single quotes, nor : in your input.

You can use

df['name'] = df['col'].str.extract(r"name=([^;]*)")

See the regex demo, name=([^;]*) matches the name= as left-hand side context and extracts one or more chars other than a ; right after that into the name column.

answered Mar 9, 2022 at 14:31

Wiktor Stribiżew

631k41 gold badges502 silver badges632 bronze badges

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

Collectives™ on Stack Overflow

Extract values from string column in pandas dataframe

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