Extract substring from text using python

Question

I have some values in a column that looks like this:

{"template":{"module":[{"id":"module-12","header":[{"id":"title","value":"Cycle in Comfort","decorators":[]}],"paragraph":[{"id":"description","value":["This folding exercise bike features a heavily-padded seat and backrest for your comfort."]

Is there any way I can extract information from it and paste it in other columns? Information that need to be extracted:

module-12
Cycle in Comfort
This folding exercise bike features a heavily-padded seat and backrest for your comfort

Any advice on extracting the needed information?

adir abargil · Accepted Answer · 2020-11-16 18:55:06Z

1

assuming your dictionary object name mydict :

item = mydict["template"]['module'][0]
module_12 = item['id']
header = item['header'][0]
cycle = header['value']
paragraph = item['paragraph'][0]
text = paragraph['value']

print(module_12)
>>> module-12
print(module_12)
>>> Cycle in Comfort
print(module_12)
>>> This folding exercise bike features a heavily-padded seat and backrest for your comfort

answered Nov 16, 2020 at 18:55

adir abargil

5,7453 gold badges23 silver badges29 bronze badges

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

3 Comments

Isa Over a year ago

thank you! considering that I may have a maximum of 5 module number with different information, in there a way to extract all those modules and information and to paste this info to other columns once is extracted?

Isa Over a year ago

some information may repeat and I need to extract it and paste in other columns

adir abargil Over a year ago

I think you should open new question... iam still not quite sure what do you mean

Collectives™ on Stack Overflow

Extract substring from text using python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related