Read a JSON file containing unicode data

Question

Here is the content of my JSON file

cat ./myfile.json

{u'Records': [{u'eventVersion': u'2.0', }]}

How do I read this JSON file?

I tried reading the file with the following code,

def Read_json_file(jsonFile):
   jsonDy = {}
   if os.path.exists(jsonFile):
      with open(jsonFile, 'rt') as fin:
         jsonDy = json.load(fin)
   else:
      print("JSON file not available ->",
                                 jsonFile)
      sys.exit(1)
   print("jsonDy -> ", jsonDy)

But getting the following error,

Traceback (most recent call last):
  File "a.py", line 125, in <module>
    Main()
  File "a.py", line 18, in Main
    content = Read_json_file(eventFile)
  File "a.py", line 44, in Read_json_file
    jsonDy = json.load(fin)
  File "/usr/lib64/python2.7/json/__init__.py", line 290, in load
    **kw)
  File "/usr/lib64/python2.7/json/__init__.py", line 338, in loads
    return _default_decoder.decode(s)
  File "/usr/lib64/python2.7/json/decoder.py", line 365, in decode
    obj, end = self.raw_decode(s, idx=_w(s, 0).end())
  File "/usr/lib64/python2.7/json/decoder.py", line 381, in raw_decode
    obj, end = self.scan_once(s, idx)
ValueError: Expecting property name: line 1 column 2 (char 1)

What I understand is here u' represents the unicode notation, but not sure how to read this file

PS : I am using Python 2.7

Try json.loads() instead.

Vaibhav Bajaj
– Vaibhav Bajaj

2016-08-02 17:42:20 +00:00
Commented Aug 2, 2016 at 17:42 — Vaibhav Bajaj
– Vaibhav Bajaj, Commented Aug 2, 2016 at 17:42

Lex Scarisbrick · Accepted Answer · 2016-08-02 17:45:17Z

3

That's not a valid JSON structure. It's a string representation of Python data structure. The appropriate JSON structure would be:

{"Records": [{"eventVersion": "2.0"}]}

It looks like something is writing the JSON with the output of json.loads instead of json.dumps.

answered Aug 2, 2016 at 17:45

Lex Scarisbrick

1,6001 gold badge25 silver badges32 bronze badges

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

Comments

Marlon Abeykoon · Accepted Answer · 2016-08-02 17:43:11Z

1

Try this,

import simplejson as json
w = json.dumps({u'Records': [{u'eventVersion': u'2.0', }]})
print json.loads(w)

or use:

import json
w = json.dumps({u'Records': [{u'eventVersion': u'2.0', }]})
print json.loads(w)

I have dumped to json to recreate the issue. You can just use json.loads

answered Aug 2, 2016 at 17:43

Marlon Abeykoon

12.6k4 gold badges60 silver badges78 bronze badges

4 Comments

Raj Over a year ago

Here is my current code ; with open(jsonFile, 'rt') as fin: jsonDy = json.loads(fin.read())...but getting the following error...

Traceback (most recent call last):     content = Read_json_file(eventFile)     jsonDy = json.loads(fin.read())     obj, end = self.scan_once(s, idx) ValueError: Expecting property name: line 1 column 2 (char 1)

Marlon Abeykoon Over a year ago

json.loads(fin.read().replace("\'", '"')) Can you try this and tell me?

Raj Over a year ago

Tried that....But, Getting the same error ; For the moment ; I have changed my file to have a valid JSON content...as @Lex have pointed out...that resolved my current road block with testing...

Raj Over a year ago

Might be helpful to someone in the same scenario...although not sure if this is an elegant solution. This works though....json.loads(fin.read().replace("u'", '"').replace("'", '"'))

Collectives™ on Stack Overflow

Read a JSON file containing unicode data

2 Answers 2

Comments

4 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Related