Using python to read an array from a JSON file

Question

I have this JSON file:

[
{
id: "29",
name: "abc",
email: "[email protected]",
data: "2016-05-03"
},
{
id: "17",
name: "ghi",
email: "[email protected]",
data: "2016-05-12"
},
{
id: "12",
name: "qwe",
email: "[email protected]",
data: "2016-04-11"
}
]

I wrote this script:

with open('C:/Users/L30607/Desktop/FYP/FourthMay-AllStudents-stackoverflow.json') as json_data:
    d = json.load(json_data)
    json_data.close()
    pprint(d)

How do I parse the file and extract the array?

I want to get:

d = [{id: "29",name: "abc",email: "[email protected]",data: "2016-05-03"},{id: "17",name: "ghi",email: "[email protected]",data: "2016-05-12"},{id: "12",name: "qwe",email: "[email protected]",data: "2016-04-11"}]

@AKS Yes. It says that in loads return _default_decoder.decode(s) — m1995
– m1995, Commented Jun 16, 2016 at 5:01
What are the problems you have? Your question lacks any error description and (apart from a few lines) the minimal example code. Also, have you tried just searching for examples online and adapting them? — Ulrich Eckhardt
– Ulrich Eckhardt, Commented Jun 16, 2016 at 5:10
Small suggestion: don't close files with json_data.close() when you are already inside the with block, as it already closes the file for you at the block ending. — Matheus Portela
– Matheus Portela, Commented Jun 23, 2016 at 13:15

Moon Cheesez · Accepted Answer · 2016-06-16 05:03:53Z

2

Your JSON is not formatted properly. I put validated it in https://jsonformatter.curiousconcept.com/ and it shows that your keys are not wrapped in quotes. This is what it should be:

[  
   {  
      "id":"29",
      "name":"abc",
      "email":"[email protected]",
      "data":"2016-05-03"
   },
   {  
      "id":"17",
      "name":"ghi",
      "email":"[email protected]",
      "data":"2016-05-12"
   },
   {  
      "id":"12",
      "name":"qwe",
      "email":"[email protected]",
      "data":"2016-04-11"
   }
]

I re-ran your code and it worked well.

answered Jun 16, 2016 at 5:03

Moon Cheesez

2,7213 gold badges28 silver badges41 bronze badges

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

Comments

Harsha Biyani · Accepted Answer · 2016-06-16 05:14:34Z

0

Your json should be like :

[{
    "id": "29",
    "name": "abc",
    "email": "[email protected]",
    "data": "2016-05-03"
}, {
    "id": "17",
    "name": "ghi",
    "email": "[email protected]",
    "data": "2016-05-12"
}, {
    "id": "12",
    "name": "qwe",
    "email": "[email protected]",
    "data": "2016-04-11"
}]

String should be inside quotes. Then only it becomes as valid JSON. You can validate your JSON : Validate JSON

answered Jun 16, 2016 at 5:14

Harsha Biyani

7,28810 gold badges42 silver badges64 bronze badges

Comments

Hassan Mehmood · Accepted Answer · 2016-06-16 05:17:51Z

0

Always validate your json from http://jsonlint.com/ if you get any errors. In your case you are not giving Keys as string.

edited Jun 16, 2016 at 5:17

answered Jun 16, 2016 at 5:06

Hassan Mehmood

1,4122 gold badges14 silver badges23 bronze badges

Comments

Dhia · Accepted Answer · 2016-06-23 13:12:19Z

0

This is the error:

Traceback (most recent call last): File "C:/Users/L30607/PycharmProjects/untitled1/333.py", line 36, in d = json.load(json_data) File "C:\Python27\lib\json__init__.py", line 291, in load **kw) File "C:\Python27\lib\json__init__.py", line 339, in loads return _default_decoder.decode(s) File "C:\Python27\lib\json\decoder.py", line 364, in decode obj, end = self.raw_decode(s, idx=_w(s, 0).end()) File "C:\Python27\lib\json\decoder.py", line 380, in raw_decode obj, end = self.scan_once(s, idx) ValueError: Expecting property name: line 3 column 1 (char 4)

edited Jun 23, 2016 at 13:12

Dhia

10.7k11 gold badges62 silver badges70 bronze badges

answered Jun 16, 2016 at 5:04

m1995

113 bronze badges

1 Comment

Moon Cheesez Over a year ago

Please do not add errors in the answers section, instead, edit your question and include the error.

Collectives™ on Stack Overflow

Using python to read an array from a JSON file

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related