Split based on Regex python

Question

I have a string like below

"‘‘Apple’’ It is create by Steve Jobs (He was fired and get hired) ‘‘Microsoft’’ Bill Gates was the richest man in the world ‘‘Oracle’’ It is a database company"

I am able to manage to use regex to create groups of Apple, Microsoft and Oracle by using ‘‘(.*?)’’ but how should I extract the other sentence part to list?

What I want to create

companyList = ['Apple','Microsoft','Oracle']

descriptionList = ['It is create by Steve Jobs (He was fired and get hired)','Bill Gates was the richest man in the world','It is a database company']

Thank you in advance

So, if the input is ‘‘Apple’’ or ‘‘AAPL’’ It is create by Steve Jobs (He was fired and get hired) ‘‘Microsoft’’ Bill Gates was the richest man in the world ‘‘Oracle’’ It is a database company, what is the expected output? Also, can there be any ‘ or ’ inside ‘‘...’’? — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Aug 20, 2019 at 10:04

Tim Biegeleisen · Accepted Answer · 2019-08-20 06:40:55Z

3

One option is to use re.findall with the following pattern:

‘‘(.*?)’’ (.*?)(?= ‘‘|$)

This will capture, in separate groups, the company name and description, for each match found in the input. Note that we use the lookahead (?= ‘‘|$) as the end of the current description, which either occurs at the start of the next entry, or the end of the input.

inp = "‘‘Apple’’ It is create by Steve Jobs (He was fired and get hired) ‘‘Microsoft’’ Bill Gates was the richest man in the world ‘‘Oracle’’ It is a database company"
matches = re.findall('‘‘(.*?)’’ (.*?)(?= ‘‘|$)', inp)
companyList = [row[0] for row in matches]
descriptionList = [row[1] for row in matches]
print(companyList)
print(descriptionList)

This prints:

['Apple', 'Microsoft', 'Oracle']
['It is create by Steve Jobs (He was fired and get hired)',
 'Bill Gates was the richest man in the world', 'It is a database company']

answered Aug 20, 2019 at 6:40

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

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

1 Comment

Tomerikoo Over a year ago

Another way of getting the final lists (no double iteration): companyList, desriptionList = (list(group) for group in zip(*matches))

Collectives™ on Stack Overflow

Split based on Regex python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related