Parsing nested json without definite key name in python

Question

I have a nested json as shown below. I am trying to get the values of city and label from the below json.

   {
      "5c7a3dd5-29e4-4f5b-9dc8-d2d451906cf1": {
        "id": "1d14eba1-de9e-4e53-9e9e-619432fd815b",
        "opinion_id": "3063e6ff-1483-4daf-8e80-41afa43b6348",
        "paragraph_id": "e6d419fe-5017-47f6-acf1-0e74034aed4a",
        "position": 7,
        "city": "Berlin.",
        "label": "Capital"
      },
      "0c0adcad-992f-4c30-aa58-7bf539f8d649": {
        "case_id": "6f6e70f7-3257-4f26-a8fa-8cf0e5f97920",
        "opinion_id": "71b435ff-112c-470b-a36b-c552e54a5605",
        "paragraph_id": "e6d419fe-5017-47f6-acf1-0e74034aed4a",
        "position": 3,
        "city": "Frankfurt.",
        "label": "Economic Capital"
      },
      "de968cdf-d865-4049-9f7d-f9a68be27432": {
        "case_id": "2d749a58-412c-4bc8-b268-7d5f7bec3d9a",
        "opinion_id": "1836c972-d6f7-420b-ba33-8f863cfca482",
        "paragraph_id": "e6d419fe-5017-47f6-acf1-0e74034aed4a",
        "position": 4,
        "city": "Paris.",
        "label": "Capital"
      }
    }

What i have tried is to loop through the json and extract the values on to a list of dict. Its throwing me an keyerror. I kind of understand. If the keys of the outerjson were same, then I could have used text = jsonData['KEY'][i]["city"]

with open(json_file_name) as input:
    jsonData = json.load(input)
    JSONLength = len(jsonData)
    data = []
    classes = dict()
    for i in range(0, JSONLength):
        text = jsonData[i]["city"]
        label = jsonData[i]["label"]
        print(text)
        print(label)
        data += [(classes[label], text)]

Maurice Meyer · Accepted Answer · 2020-09-16 09:27:55Z

1

Iterate over the dict's values:

with open(json_file_name) as input:
    jsonData = json.load(input)
    data = [(values['city'], values['label']) for values in jsonData.values()]
    print(data

)

Out:

[('Berlin.', 'Capital'), ('Frankfurt.', 'Economic Capital'), ('Paris.', 'Capital')]

answered Sep 16, 2020 at 9:27

Maurice Meyer

18.2k4 gold badges35 silver badges54 bronze badges

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

1 Comment

Shijith Over a year ago

This will fail if one of those inner dictionaries does not have either city or label key. So it is always better to use dictionary.get('city')

Ajay A · Accepted Answer · 2020-09-16 09:27:46Z

1

Try this

with open(json_file_name) as input:
    jsonData = json.load(input)
    for k, v in jsonData.items():
        print(k) # prints dynamic key
        print(v) # prints its corresponding obj
        print(v['city']) # will print city of the particular key
        print(v['label']) # will print label of the particular key

answered Sep 16, 2020 at 9:27

Ajay A

1,0531 gold badge9 silver badges20 bronze badges

Comments

balderman · Accepted Answer · 2020-09-16 09:28:34Z

1

try

data =   {
      "5c7a3dd5-29e4-4f5b-9dc8-d2d451906cf1": {
        "id": "1d14eba1-de9e-4e53-9e9e-619432fd815b",
        "opinion_id": "3063e6ff-1483-4daf-8e80-41afa43b6348",
        "paragraph_id": "e6d419fe-5017-47f6-acf1-0e74034aed4a",
        "position": 7,
        "city": "Berlin.",
        "label": "Capital"
      },
      "0c0adcad-992f-4c30-aa58-7bf539f8d649": {
        "case_id": "6f6e70f7-3257-4f26-a8fa-8cf0e5f97920",
        "opinion_id": "71b435ff-112c-470b-a36b-c552e54a5605",
        "paragraph_id": "e6d419fe-5017-47f6-acf1-0e74034aed4a",
        "position": 3,
        "city": "Frankfurt.",
        "label": "Economic Capital"
      },
      "de968cdf-d865-4049-9f7d-f9a68be27432": {
        "case_id": "2d749a58-412c-4bc8-b268-7d5f7bec3d9a",
        "opinion_id": "1836c972-d6f7-420b-ba33-8f863cfca482",
        "paragraph_id": "e6d419fe-5017-47f6-acf1-0e74034aed4a",
        "position": 4,
        "city": "Paris.",
        "label": "Capital"
      }
    }
    
city_n_label = [(x['city'],x['label']) for x in data.values()]
print(city_n_label)

output

[('Berlin.', 'Capital'), ('Frankfurt.', 'Economic Capital'), ('Paris.', 'Capital')]

answered Sep 16, 2020 at 9:28

balderman

24k8 gold badges39 silver badges60 bronze badges

1 Comment

Shijith Over a year ago

This will fail if one of those inner dictionaries does not have either city or label key. So it is always better to use dictionary.get('city')

Collectives™ on Stack Overflow

Parsing nested json without definite key name in python

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest