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
– Maximilian Peters, Commented Nov 27, 2020 at 19:22
Do you want to remove those items from the actual json file? — John Gordon
– John Gordon, Commented Nov 27, 2020 at 19:29
Does this answer your question? Delete an element in a JSON object — sahasrara62
– sahasrara62, Commented Nov 27, 2020 at 19:31

Community · Accepted Answer · 2024-02-28 10:08:19Z

4

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

import json
with open('file.json') as f:
    d = json.load(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.load(f)
    for key, value in d.items():
        value.pop('id', None) // this will not crash if the element has no key 'id'

edited Feb 28, 2024 at 10:08

CommunityBot

11 silver badge

answered Nov 27, 2020 at 19:24

lmiguelvargasf

71.2k55 gold badges231 silver badges239 bronze badges

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

Comments

Greg Eremeev · Accepted Answer · 2020-11-27 19:30:02Z

2

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, 2020 at 19:30

answered Nov 27, 2020 at 19:24

Greg Eremeev

1,8505 gold badges25 silver badges33 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related