how to remove key/value pair in a json file in python

Question

{
    "duncan_long": {
        "id": "drekaner",
        "name": "Duncan Long",
        "favorite_color": "Blue"
    },
    "kelsea_head": {
        "id": "wagshark",
        "name": "Kelsea Head",
        "favorite_color": "Ping"
    },
    "phoenix_knox": {
        "id": "jikininer",
        "name": "Phoenix Knox",
        "favorite_color": "Green"
    },
    "adina_norton": {
        "id": "slimewagner",
        "name": "Adina Norton",
        "favorite_color": "Red"
    }
}

I am trying to Return a JSON list of all the users excluding the id of the user

d = json.loads(your_json); for k, v in d.items(): del v['id']; d[k] = v — Maximilian Peters, Nov 27 '20 at 19:22
Do you want to remove those items from the actual json file? — John Gordon, Nov 27 '20 at 19:29
Does this answer your question? [Delete an element in a JSON object](https://stackoverflow.com/questions/36606930/delete-an-element-in-a-json-object) — sahasrara62, Nov 27 '20 at 19:31

lmiguelvargasf · Answer 1 · 2020-11-27T19:30:11.807

Assuming your the file in which you have your JSON is called file.json:

import json
with open('file.json') as f:
    d = json.loads(f)
    for key, value in d.items():
        del value['id']
        d[key] = value

Alternative you can use the following:

import json
with open('file.json') as f:
    d = json.loads(f)
    for key, value in d.items():
        value.pop('id', None) // this will not crash if the element has no key 'id'

Greg Eremeev · Answer 2 · 2020-11-27T19:30:02.370

1

import json


with open('file.json') as fin:
    your_structure = json.load(fin)

for value in your_structure.values():
    value.pop('id', None)

edited Nov 27 '20 at 19:30

answered Nov 27 '20 at 19:24

Greg Eremeev

1,760
5
23
33

how to remove key/value pair in a json file in python

2 Answers2