Convert string into JSON in Python

Question

I have this simplify array to be converted into JSON. For some reason, it does not working.

import json
arr = "[{u'symbol': u'YTLREIT', u'code': u'5109', u'name': u'YTL HOSPITALITY REIT'}]"
data = json.loads(arr)

The error I received,

ValueError: Expecting property name: line 1 column 3 (char 2)

Where is this data coming from?

alecxe
– alecxe

2016-01-31 04:19:10 +00:00
Commented Jan 31, 2016 at 4:19 — alecxe
– alecxe, Commented Jan 31, 2016 at 4:19

geckob · Accepted Answer · 2016-01-31 06:51:21Z

3

This is not a valid JSON, but you can load with ast.literal_eval():

>>> from ast import literal_eval
>>> literal_eval(arr)
[{u'symbol': u'YTLREIT', u'code': u'5109', u'name': u'YTL HOSPITALITY REIT'}]

edited Jan 31, 2016 at 6:51

geckob

8,2085 gold badges36 silver badges43 bronze badges

answered Jan 31, 2016 at 4:17

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

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

4 Comments

geckob Over a year ago

Thanks. It works! It looks like a valid JSON. What makes it not a valid JSON?

alecxe Over a year ago

@geckob the extra u sign before the quotes and the quotes themselves - they have to be double quotes. It actually looks like a string representation of a list. If you have control over the tool produced it, you should tweak it to produce a valid JSON - if Python, json.dump or json.dumps.

Namita Maharanwar Over a year ago

@alecxe What is the reason behind putting double quote ? why not single quote?

PM 2Ring Over a year ago

@NamitaMaharanwar: That's just JSON syntax. Strings must be delimited with double quotes.

Collectives™ on Stack Overflow

Convert string into JSON in Python

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