How to parse values from a specific key of multiple JSON objects python

Question

I am trying to parse the key "tags" from the below JSON.

data = [{
    "12233":{
    "title": "The Title",
    "id": "12233",
    "tags": ["tag1", "tag2", "tag3"],
    },
    "122223":{
    "title": "The Title",
    "id": "122223",
    "tags": ["tag4", "tag5", "tag6"],
    },
    "122344":{
    "title": "The Title",
    "id": "122344",
    "tags": ["tag7", "tag8", "tag9"],
    }
}]

I have tried this so far,

data = data[0]
tags_list = []

for tags in data:
    tags_list.append(tags["122344"])

print(tags_list)

But it only extracts the first object, I want the result to be like this,

tags_list = ["tag1", "tag2", "tag3", "tag4", "tag5", "tag6","tag7", "tag8", "tag9"]

try using list compression

sarath ravi
– sarath ravi

2021-09-02 13:28:04 +00:00
Commented Sep 2, 2021 at 13:28 — sarath ravi
– sarath ravi, Commented Sep 2, 2021 at 13:28

Niel Godfrey P. Ponciano · Accepted Answer · 2021-09-02 15:14:02Z

3

is this will solve your problem?

tags_list = [item for k in data for t in k for item in k[t]['tags']]

edited Sep 2, 2021 at 15:14

Niel Godfrey P. Ponciano

10.8k1 gold badge24 silver badges32 bronze badges

answered Sep 2, 2021 at 13:35

sarath ravi

4811 gold badge4 silver badges15 bronze badges

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

Comments

eroot163pi · Accepted Answer · 2021-09-02 14:11:03Z

1

Use itemgetter on all values of dictionary data[0] and sum all items to empty list []

from operator import itemgetter

data = [{
    "12233":{
    "title": "The Title",
    "id": "12233",
    "tags": ["tag1", "tag2", "tag3"],
    },
    "122223":{
    "title": "The Title",
    "id": "122223",
    "tags": ["tag4", "tag5", "tag6"],
    },
    "122344":{
    "title": "The Title",
    "id": "122344",
    "tags": ["tag7", "tag8", "tag9"],
    }
}]

tag_getter = itemgetter('tags')
# map to get list of all tags
# Adding all the list of tags to []
sum(map(tag_getter, data[0].values()), [])

['tag1', 'tag2', 'tag3', 'tag4', 'tag5', 'tag6', 'tag7', 'tag8', 'tag9']

If you want to merge all tags from all the entries of list then use

from operator import itemgetter
tag_getter = itemgetter('tags')
def all_tags(d):
    return sum(map(tag_getter, d.values()), [])
sum(map(all_tags, data), [])

edited Sep 2, 2021 at 14:11

answered Sep 2, 2021 at 13:51

eroot163pi

1,8451 gold badge14 silver badges26 bronze badges

1 Comment

accdias Over a year ago

Lambdas in Python are designed to be anonymous functions. There is no sense in assign one to a variable, making it a named function. It is considered bad practice. If you need that, define a function instead. See (stackoverflow.com/a/25010243/6789321) and (python.org/dev/peps/pep-0008/#programming-recommendations).

Arkistarvh Kltzuonstev · Accepted Answer · 2021-09-02 13:29:00Z

0

In stead of a single loop, you need two loops to iterate over the inner dictionaries. Try this :

tags_list = []
for k in data:
    for t in k:
        tags_list.extend(k[t]['tags'])

Output tags_list :

['tag1', 'tag2', 'tag3', 'tag4', 'tag5', 'tag6', 'tag7', 'tag8', 'tag9']

answered Sep 2, 2021 at 13:29

Arkistarvh Kltzuonstev

6,9837 gold badges32 silver badges62 bronze badges

Collectives™ on Stack Overflow

How to parse values from a specific key of multiple JSON objects python

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related