delete child json object python

Question

I am having a dynamic json (data) in python coming from a service, the service also gives me a dynamic string data keyToDelete where I will get the object to delete

for Example 1 lets say if the data value is as given below

{
  "categories": {
    "attributes": {
      "Alcohol": "full_bar",
      "Noise Level": "average",
      "Music": {
        "dj": false
      },
      "Attire": "casual",
      "Ambience": {
        "romantic": false,
        "intimate": false,
        "touristy": false,
        "hipster": false
      }
    }
  }
}

which means it should delete the Ambience object that comes under attributes, actual result should be like

{
  "categories": {
    "attributes": {
      "Alcohol": "full_bar",
      "Noise Level": "average",
      "Music": {
        "dj": false
      },
      "Attire": "casual"
    }
  }
}

but how to create the above deletion programmatically using python from dynamic keyToDelete

Can anyone please help me on this

Split your keytodelete with '.' . Iterate the list and delete the json — Niranj Rajasekaran
– Niranj Rajasekaran, Commented Nov 3, 2017 at 7:57
but how do we do the iteration....in the above two example the json to delete is the second child....but it may sometimes vary... — Alex Man
– Alex Man, Commented Nov 3, 2017 at 8:05

karthik reddy · Accepted Answer · 2017-11-03 10:29:13Z

4

please try this.

def deleteKey(data,keyList): if len(keyList) > 1: data[keyList[0]] = deleteKey(data[keyList[0]],keyList[1:]) else: del data[keyList[0]] return data deleteKey(data,keyToDelete.split("."))

edited Nov 3, 2017 at 10:29

answered Nov 3, 2017 at 8:14

karthik reddy

4794 silver badges13 bronze badges

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

Comments

taras · Accepted Answer · 2017-11-03 08:08:45Z

The idea is to iterate through dictionary and the remove the found key. Here is an example:

data = {
  "categories": {
    "imageData": {
      "Alcohol": "xyz123",
      "Noise Level": "average",
      "Music": {
        "dj": False
      },
      "Attire": "casual"
    }
  }
}

for toDelete in ['categories.imageData.Music.dj', 'categories.imageData.Attire']:
    # find keys
    path = toDelete.split('.')
    # remember last item. 
    # It is important to understand that stored value is a reference.
    # so when you delete the object by its key, you are modifying a referenced dictionary/object.
    item = data

    # iterate through all items except last one 
    # we want to delete the 'dj', not 'False' which is its value 
    for key in path[:-1]:
        item = item[key]

    del item[path[-1]]

print data

Result

{'categories': {'imageData': {'Music': {}, 'Alcohol': 'xyz123', 'Noise Level': 'average'}}}

Collectives™ on Stack Overflow

delete child json object python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related