4

I am getting data in the following JSON format:

{
  address:[
    "test1"
  ],
  city:"test2",
  country:"test3",
  postal_code:"test4",
  state:"test5"
}

While I am trying to parse it via:

json.loads(data)

I am receiving an error: Expecting property name enclosed in double quotes

Is there a way to parse it in python ?

Thanks in advance,

vba_user
  • 115
  • 1
  • 2
  • 15
  • The double quotes are missing, for address, city and other fields. refer this https://stackoverflow.com/questions/39491420/python-jsonexpecting-property-name-enclosed-in-double-quotes – Pabdev Jul 16 '18 at 06:10

5 Answers5

8

It goes without saying that the better solution would be to fix the broken data at the source. But if you can't do that, you could try and fix the problem with a simple regex. Simple, as in "will fail if you throw anything more complicated at it", but likely sufficient as a quick and dirty solution:

import re
import json
with open("almost.json") as infile:
    jstring = infile.read()
data = json.loads(re.sub(r"(\w+):", r'"\1":', jstring))
Tim Pietzcker
  • 328,213
  • 58
  • 503
  • 561
6

The json standard needs the key with "", so you can't decode data with json module. However, you can do it with demjson (pip install demjson).

demjson.decode(data)
Joooeey
  • 3,394
  • 1
  • 35
  • 49
chui
  • 61
  • 2
  • This answer works well. I use `demjson` to parse any JSON that yields a json.JSONDecodeError with the normal decoder. – Jérémie Jun 13 '21 at 14:52
2

Your variables should be like "address" or "city".

{
  "address":[
    "test1"
  ],
  "city":"test2",
  "country":"test3",
  "postal_code":"test4",
  "state":"test5"
}
Türker Berke Yıldırım
  • 416
  • 4
  • 14
0

You can use json5. JSON5 extends the JSON data interchange format to make it slightly more usable.

import json5
JsonStr = """{
  address:[
    "test1"
  ],
  city:"test2",
  country:"test3",
  postal_code:"test4",
  state:"test5"
}"""

json5.loads(JsonStr)

out:

{'address': ['test1'],
 'city': 'test2',
 'country': 'test3',
 'postal_code': 'test4',
 'state': 'test5'}
x3mEr
  • 23
  • 6
-1

'''''''

{
  "address":[
  "test1"
  ],
"city":"test2",
"country":"test3",
"postal_code":"test4",
"state":"test5"

}

''''

Please change your code format to this , it will works

Kailas cyberonics
  • 1
  • 2