Best way to navigate a nested JSON in Python?
I have tried different for loops trying to iterate through this JSON and I cant figure out how to do it. I have a list of numbers and want to compare it to the "key" values under each object of "data" (For example, Aatrox, Ahri, Akali, and so on) and if the numbers match store the "name" value in another list.
Example: listOfNumbers = [266, 166, 123, 283]
266 and 166 would match the "key" in the Aatrox and Akshan objects respectively so I would want to pull that name and store it in a list.
I understant this JSON is mostly accessed by key values rather than being indexed so Im not sure how I would iterate through all the "data" objects in a for loop(s).
JSON im referencing:
{
"type": "champion",
"format": "standAloneComplex",
"version": "12.2.1",
"data": {
"Aatrox": {
"version": "12.2.1",
"id": "Aatrox",
"key": "266",
"name": "Aatrox",
"title": "the Darkin Blade",
"blurb": "Once honored defenders of Shurima against the Void, Aatrox and his brethren would eventually become an even greater threat to Runeterra, and were defeated only by cunning mortal sorcery. But after centuries of imprisonment, Aatrox was the first to find...",
"info": {
"attack": 8,
"defense": 4,
"magic": 3,
"difficulty": 4
},
"image": {
"full": "Aatrox.png",
"sprite": "champion0.png",
"group": "champion",
"x": 0,
"y": 0,
"w": 48,
"h": 48
},
"tags": [
"Fighter",
"Tank"
],
"partype": "Blood Well",
"stats": {
"hp": 580,
"hpperlevel": 90,
"mp": 0,
"mpperlevel": 0,
"movespeed": 345,
"armor": 38,
"armorperlevel": 3.25,
"spellblock": 32,
"spellblockperlevel": 1.25,
"attackrange": 175,
"hpregen": 3,
"hpregenperlevel": 1,
"mpregen": 0,
"mpregenperlevel": 0,
"crit": 0,
"critperlevel": 0,
"attackdamage": 60,
"attackdamageperlevel": 5,
"attackspeedperlevel": 2.5,
"attackspeed": 0.651
}
},
"Ahri": {
"version": "12.2.1",
"id": "Ahri",
"key": "103",
"name": "Ahri",
"title": "the Nine-Tailed Fox",
"blurb": "Innately connected to the latent power of Runeterra, Ahri is a vastaya who can reshape magic into orbs of raw energy. She revels in toying with her prey by manipulating their emotions before devouring their life essence. Despite her predatory nature...",
"info": {
"attack": 3,
"defense": 4,
"magic": 8,
"difficulty": 5
},
"image": {
"full": "Ahri.png",
"sprite": "champion0.png",
"group": "champion",
"x": 48,
"y": 0,
"w": 48,
"h": 48
},
"tags": [
"Mage",
"Assassin"
],
"partype": "Mana",
"stats": {
"hp": 526,
"hpperlevel": 92,
"mp": 418,
"mpperlevel": 25,
"movespeed": 330,
"armor": 21,
"armorperlevel": 3.5,
"spellblock": 30,
"spellblockperlevel": 0.5,
"attackrange": 550,
"hpregen": 5.5,
"hpregenperlevel": 0.6,
"mpregen": 8,
"mpregenperlevel": 0.8,
"crit": 0,
"critperlevel": 0,
"attackdamage": 53,
"attackdamageperlevel": 3,
"attackspeedperlevel": 2,
"attackspeed": 0.668
}
},
"Akali": {
"version": "12.2.1",
"id": "Akali",
"key": "84",
"name": "Akali",
"title": "the Rogue Assassin",
"blurb": "Abandoning the Kinkou Order and her title of the Fist of Shadow, Akali now strikes alone, ready to be the deadly weapon her people need. Though she holds onto all she learned from her master Shen, she has pledged to defend Ionia from its enemies, one...",
"info": {
"attack": 5,
"defense": 3,
"magic": 8,
"difficulty": 7
},
"image": {
"full": "Akali.png",
"sprite": "champion0.png",
"group": "champion",
"x": 96,
"y": 0,
"w": 48,
"h": 48
},
"tags": [
"Assassin"
],
"partype": "Energy",
"stats": {
"hp": 500,
"hpperlevel": 105,
"mp": 200,
"mpperlevel": 0,
"movespeed": 345,
"armor": 23,
"armorperlevel": 3.5,
"spellblock": 37,
"spellblockperlevel": 1.25,
"attackrange": 125,
"hpregen": 9,
"hpregenperlevel": 0.9,
"mpregen": 50,
"mpregenperlevel": 0,
"crit": 0,
"critperlevel": 0,
"attackdamage": 62,
"attackdamageperlevel": 3.3,
"attackspeedperlevel": 3.2,
"attackspeed": 0.625
}
},
"Akshan": {
"version": "12.2.1",
"id": "Akshan",
"key": "166",
"name": "Akshan",
"title": "the Rogue Sentinel",
"blurb": "Raising an eyebrow in the face of danger, Akshan fights evil with dashing charisma, righteous vengeance, and a conspicuous lack of shirts. He is highly skilled in the art of stealth combat, able to evade the eyes of his enemies and reappear when they...",
"info": {
"attack": 0,
"defense": 0,
"magic": 0,
"difficulty": 0
},
"image": {
"full": "Akshan.png",
"sprite": "champion0.png",
"group": "champion",
"x": 144,
"y": 0,
"w": 48,
"h": 48
},
"tags": [
"Marksman",
"Assassin"
],
"partype": "Mana",
"stats": {
"hp": 560,
"hpperlevel": 90,
"mp": 350,
"mpperlevel": 40,
"movespeed": 330,
"armor": 26,
"armorperlevel": 3,
"spellblock": 30,
"spellblockperlevel": 0.5,
"attackrange": 500,
"hpregen": 3.75,
"hpregenperlevel": 0.65,
"mpregen": 8.175,
"mpregenperlevel": 0.7,
"crit": 0,
"critperlevel": 0,
"attackdamage": 52,
"attackdamageperlevel": 3.5,
"attackspeedperlevel": 4,
"attackspeed": 0.638
}
}
}
}
You simply iterate over the values of the dictionary, check whether the value of the 'key' item is in your list and if that's the case, append the value of the 'name' item to your output list.
Let jsonObj be your JSON object presented in your question. Then this code should work:
listOfNumbers = [266, 166, 123, 283]
names = []
for value in jsonObj['data'].values():
if value['key'] in listOfNumbers:
names.append(value['name'])
JSON objects in Python are just dictionaries. So, you better familiarize yourself with Python's dict.
There have lot's of solution you can try this one too I think it will perfectly work for your solution
import json
#Load your json or manually declare your json here
with open('yourfile.json') as f:
Data= json.load(f)
#This the main code for accesing the value and get the result
Temp_Data=Data['data']
result_list=[]
listOfNumbers =[266,166,123,283]
for data,data_info in Temp_Data.items():
key_value=int(Temp_Data[data]['key'])
if key_value in listOfNumbers:
result_list.append(data)
print(result_list)