Extract specific values from JSON using Python

Question

I'm trying to figure out a way to display only the name and id from each object. I checked a lot of answers here already but I'm new to Python and I don't really know how to do this. This is my JSON file:

{"tags": [
    {
      "tagGroup": "Named Tags",
      "lastConfig": null,
      "notes": null,
      "color": "#ffcc33ff",
      "name": "tag 3",
      "lastConfigTS": null,
      "fwVersion": null,
      "id": "a4da22e0296b"
    },
    {
      "tagGroup": "Named Tags",
      "lastConfig": null,
      "notes": null,
      "color": "#ff00ccdd",
      "name": "tag 4",
      "lastConfigTS": null,
      "fwVersion": null,
      "id": "a4da22e04235"
    },
    {
      "tagGroup": "Named Tags",
      "lastConfig": null,
      "notes": null,
      "color": "#ff00cccc",
      "name": "tag 5",
      "lastConfigTS": null,
      "fwVersion": null,
      "id": "a4da22e02225"
    }
  ]}

This is my current code:

import json
    from pprint import pprint

    with open('tags.json') as f:
        data = json.load(f)

    pprint(data["tags"][0]["id"])

I can get it to print only the first id, but I don't really know where to go from here. Is there a way to print only all of name and id values?

So the 0 in your pprint is the index. Increment that number to get to the other json indexes — Rashid 'Lee' Ibrahim
– Rashid 'Lee' Ibrahim, Commented Jun 4, 2019 at 2:24

Rashid 'Lee' Ibrahim · Accepted Answer · 2019-06-04 02:28:12Z

2

Simply iterating through the list of dictionaries should do the trick for you.

import json
from pprint import pprint

with open('tags.json') as f:
    data = json.load(f)
for tag in data["tags"]:
    pprint(tag["id"])
    pprint(tag["name"])

edited Jun 4, 2019 at 2:28

Rashid 'Lee' Ibrahim

1,3921 gold badge9 silver badges27 bronze badges

answered Jun 4, 2019 at 2:24

Thomas Burke

1,40511 silver badges21 bronze badges

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

1 Comment

lineal Over a year ago

Thank you, it's exactly what I needed.

Collectives™ on Stack Overflow

Extract specific values from JSON using Python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related