How to extract element from array with regex?

Question

I would like to extract the first url from the array listed below. I want to use Python3 with regular expressions, but I can't match the string.

This is what I tried

import pandas as pd
import re


reg = "\['\S*"


myDataFrame = pd.read_csv('Refactored_Test_1.csv')

imageColumn = myDataFrame.loc[:,"image"]
print(imageColumn)

for element  in imageColumn: 
    print(element)

['https://ui.assets-asda.com/dm/asdagroceries/8000500217078_T1?defaultImage=asdagroceries/noImage&resMode=sharp2&id=nHnSx1&fmt=jpg&fit=constrain,1&wid=188&hei=188', 'https://ui.assets-asda.com/dm/asdagroceries/8000500217078_T2?defaultImage=asdagroceries/noImage&resMode=sharp2&id=PS8Sl2&fmt=jpg&fit=constrain,1&wid=188&hei=188']

Do you mean \['(\S+)' regex101.com/r/CxZ8NX/1 Or with lookarounds (?<=\[')\S+(?=') regex101.com/r/FeUu6L/1 — The fourth bird
– The fourth bird, Commented Jun 11, 2020 at 21:26

The fourth bird · Accepted Answer · 2020-06-11 21:30:47Z

1

You could use a capturing group and repeat the non whitespace char 1+ more times and match the ' that comes after it.

\['(\S+)'

Regex demo

If you want a match only, you could use lookarounds:

(?<=\[')\S+(?=')

Regex demo

answered Jun 11, 2020 at 21:30

The fourth bird

165k16 gold badges61 silver badges75 bronze badges

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

4 Comments

bibscy Over a year ago

And to extract it, it should be? imageColumn = imageColumn.str.extract(r'\['(\S+)')

The fourth bird Over a year ago

Like that I think you have to escape the quote r'\[\'(\S+)'

bibscy Over a year ago

I get "unexpected character after line error" imageColumn = imageColumn.str.extract(r'(?<=\[')\S+(?=')')

The fourth bird Over a year ago

Try escaping both single quotes imageColumn = imageColumn.str.extract(r'(?<=\[\')\S+(?=\')')

Collectives™ on Stack Overflow

How to extract element from array with regex?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related