Get values as a list of dictionaries from a JSON object in Python

Subash Chandran 27th January 2021 Leave a Comment

Advertisements

{
	"pb-IF4JVRcuLA==": {
		"name_html": "Soђสή",
		"mkc": 1,
		"kills": 14,
		"deaths": 4,
		"lastCharacter": "Spaz",
		"lastName": "Soђสή",
		"games": 3,
		"scores": 439,
		"aid": "pb - IF4JVRcuLA == "
	},
	"pb-IF4rVWseCg==": {
		"name_html": "Android48457626",
		"mkc": 0,
		"kills": 0,
		"deaths": 6,
		"lastCharacter": "Kronk",
		"lastName": "peo",
		"games": 3,
		"scores": 205,
		"aid": "pb - IF4rVWseCg == "
	}
}

Let’s take the JSON above as an example. I need the values as a list of dictionaries in Python.

import json

json_object = json.loads('{"pb-IF4JVRcuLA==":{"name_html":"s","mkc":1,"kills":14,"deaths":4,"lastCharacter":"Spaz","lastName":"s","games":3,"scores":439,"aid":"pb - IF4JVRcuLA == "},"pb-IF4rVWseCg==":{"name_html":"Android48457626","mkc":0,"kills":0,"deaths":6,"lastCharacter":"Kronk","lastName":"peo","games":3,"scores":205,"aid":"pb - IF4rVWseCg == "}}')
pairs = json_object.items()

res = []
for key, value in pairs:
    res.append(value)

print(res)

#[{u'name_html': u's', u'mkc': 1, u'kills': 14, u'deaths': 4, u'lastCharacter': u'Spaz', u'lastName': u's', u'games': 3, u'scores': 439, u'aid': u'pb - IF4JVRcuLA == '}, {u'name_html': u'Android48457626', u'mkc': 0, u'kills': 0, u'deaths': 6, u'lastCharacter': u'Kronk', u'lastName': u'peo', u'games': 3, u'scores': 205, u'aid': u'pb - IF4rVWseCg == '}]

This is how I did it.