Nested object structure in json format

Question

The json structure

{
    "categories": [{
        "supercategory": "Bottle",
        "id": 1,
        "name": "Bottle"
    },
    {
        "supercategory": "Car",
        "id": 2,
        "name": "Car"
    }]
}

Is read by the following python script:

with open('file.json') as json_data:
    json_info = json.load(json_data)

At some later point, the same script tries to access the data structure in the following way:

json_info['1']['name']
json_info['2']['name']

Where the numbers refer to the "id" field in the json structure. Since that code is obviously inconsistent with the json structure: How do I have to change the json structure to make that work? (Assuming I can't change the script).

khelwood · Accepted Answer · 2018-03-26 15:18:26Z

6

For your code to work, you'll need something like this:

json_info = {
     "1": {"supercategory": "Bottle",
           "name": "Bottle"},
     "2": {"supercategory": "Car",
           "name": "Car"}
     }

edited Mar 26, 2018 at 15:18

khelwood

59.7k14 gold badges91 silver badges116 bronze badges

answered Mar 26, 2018 at 15:17

zipa

28k6 gold badges45 silver badges62 bronze badges

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

2 Comments

Aaron Brock Over a year ago

You out clicked me, my friend! But, you did win fair and square by 41 seconds, have an upvote!

zipa Over a year ago

@AaronN.Brock Thanks, upvoted you as soon as you posted :)

Aaron Brock · Accepted Answer · 2018-03-26 15:18:36Z

3

I think what you're looking for is something like this:

{
    "1": {
        "supercategory": "Bottle",
        "id": 1,
        "name": "Bottle"
    },
    "2": {
        "supercategory": "Car",
        "id": 2,
        "name": "Car"
    }
}

answered Mar 26, 2018 at 15:18

Aaron Brock

4,5762 gold badges29 silver badges46 bronze badges

Comments

Jimmy Lee Jones · Accepted Answer · 2018-03-26 15:27:18Z

0

Firsty, I would highly recommend using the 'get' method whenever accessing a dictionary in Python. It implicitly handles cases in which the given key(s) are not valid and prevents errors by returning null (or a default value). See this link for more info. So the code would be re-written as json_info.get('1',{}).get('name'). Note the default empty dictionary in the first get - this is to avoid None type errors. Second, if indeed you mean to access objects by their ID STRING (and not int) your JSON data structure would be:

{
  "1": {
    "supercategory": "Bottle",
    "name": "Bottle"
  },
  "2": {
    "supercategory": "Car",
    "name": "Car"
  }
}

answered Mar 26, 2018 at 15:27

Jimmy Lee Jones

9395 silver badges18 bronze badges

Collectives™ on Stack Overflow

Nested object structure in json format

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related