JSON parsing in Python without explicitly accessing keys

Question

JSON data:

[
 {
  "id": 2,
  "name": "An ice sculpture",
  "price": 12.50,
 },

 {
  "id": 3,
  "name": "A blue mouse",
  "price": 25.50,
 }
]

Expected output:

id - 2
name - An ice sculpture
price - 12.50

Something similar for id = 3.

Update

What I did so far:

content = urllib.request.urlopen(url).read().decode('utf-8')
content = content.replace("//" , "").strip() #there is a // at the beginning
obj = json.loads(content)
for obj in content:
    for key, value in obj.items():
        print (obj.key, obj.value)

Error:

File "test.py", line 22, in get
for key, value in obj.items():
AttributeError: 'str' object has no attribute 'items'

I've seen mostly data is accessed directly using the attribute keys like obj[0]["id"] outputs 2. Is there any way I can get the expected output without accessing the keys explicitly?

What is obj? It looks like a list, but you seem to think it's a dictionary — OneCricketeer
– OneCricketeer, Commented Nov 26, 2016 at 17:48
What do you mean of without accessing the keys explicitly? — Mohammad
– Mohammad, Commented Nov 26, 2016 at 17:52
@mohammad In obj[0]["id"] I have to mention the key "id' to retrieve its value. I want it to be in a generalized form. — AlphaQ
– AlphaQ, Commented Nov 26, 2016 at 18:04

Daniel Roseman · Accepted Answer · 2016-11-26 17:49:07Z

3

You have a list of dictionaries. Your code would work, as long as you iterate through the outer list:

for obj in my_json_data:
    for key, value in obj.items():
         print (obj.key, obj.value)

answered Nov 26, 2016 at 17:49

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

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

8 Comments

Daniel Roseman Over a year ago

Why are you asking me? You were the one that posted it in the question.

AlphaQ Over a year ago

No, I'm getting an error that str object has no attribute items. I think there is a data type error. And, I've edited my question with additional code.

OneCricketeer Over a year ago

@AlphaQ - you showed the JSON in your question. If you'd like more help, you need to add the URL so we can reproduce the actual problems you're having

Daniel Roseman Over a year ago

There's no way that this code doesn't work while my_json_data[0]['id'] does.

Daniel Roseman Over a year ago

But that shows that your object is a string. So content[0]["id"] cannot possibly have worked.

|

Mike Tung · Accepted Answer · 2016-11-26 17:55:38Z

0

you should try this

data = [
 {
  "id": 2,
  "name": "An ice sculpture",
  "price": 12.50,
 },

 {
  "id": 3,
  "name": "A blue mouse",
  "price": 25.50,
 }
]

for json_data in data:
    for k, v in json_data.items():
        print('{} - {}'.format(k,v))

answered Nov 26, 2016 at 17:55

Mike Tung

4,8411 gold badge19 silver badges25 bronze badges

1 Comment

Mike Tung Over a year ago

how about the print statement where I actually got the format OP requested?

Collectives™ on Stack Overflow

JSON parsing in Python without explicitly accessing keys

Update

2 Answers 2

8 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Update

2 Answers 2

8 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related