Read JSON value with dynamic key using Python

Question

I want to read a JSON value using a dynamic key using Python. For example, I have a JSON in the following format

{
  "Personal": {
    "Address": {
      "City": "Newyork",
      "Country": "USA"
    }
  },
  "number": 123,
  "object": {
    "a": "b",
    "c": "d",
    "e": "f"
  }
}

If I enter a string as "Personal.Address.City", I need to get city value using Python.

what specific problem are you facing? spliting the keys? parsing the json? accessing an element in a json object using a key? using a loop? — njzk2
– njzk2, Commented Dec 9, 2019 at 5:31

Nick Lee · Accepted Answer · 2019-12-09 05:48:55Z

4

It seems like you have to split the key and look up level-by-level manually. I give two implementations below:

data = {
  "Personal": {
    "Address": {
      "City": "Newyork",
      "Country": "USA"
    }
  },
  "number": 123,
  "object": {
    "a": "b",
    "c": "d",
    "e": "f"
  }
}

key = 'Personal.Address.City'

def lookup_dot_separated_key(data, key):
    value = data
    for k in key.split('.'):
        value = value[k]
    return value

print(lookup_dot_separated_key(data, key))

def lookup_key_list(data, keys):
    if keys:
        return lookup_key_list(data[keys[0]], keys[1:])
    else:
        return data

print(lookup_key_list(data, key.split('.')))

edited Dec 9, 2019 at 5:48

answered Dec 9, 2019 at 5:38

Nick Lee

5,9893 gold badges32 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

Read JSON value with dynamic key using Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related