How can i retrieve a specific data from a json object and add in to an new array

Question

I want to make a new array and add some specific keys and values of the json object into the new array. My code adds only the value and not the key. Can someone help me?

CourseGroupCategoriesGroups=[{'GroupId': 11799, 'Name': 'Group 1', 'Description': {'Text': '', 'Html': ''}, 'Enrollments': [264, 265, 266, 50795, 50798]}, {'GroupId': 11928, 'Name': 'Group2', 'Description': {'Text': '', 'Html': ''}, 'Enrollments': [49039, 49040, 49063, 49076, 50720, 50765, 50791]}]
GroupMembership =[]

for record in CourseGroupCategoriesGroups:
    GroupMembership.append(record['Name'])  

print(GroupMembership)

Hi there I want to make a new array and add some specific keys and valyes of the json object in to the new array. My code adds only the value and not the key. Can someone help me ? — Abdullah, Dec 04 '19 at 13:45
But This is a shorten list, I have iterate through 100 items. So I want to make a new json object and add some of the information for CourseGroupCategoriesGroups and some from some other list. — Abdullah, Dec 04 '19 at 13:50
Does this answer your question? [How to extract nested JSON data?](https://stackoverflow.com/questions/57875259/how-to-extract-nested-json-data) Check my answer where I explain in detail how to address this subject. — Celius Stingher, Dec 04 '19 at 13:52

score 1 · Accepted Answer · answered Dec 04 '19 at 13:50

1

just add the names you want before the value:

GroupMembership =[]

for record in CourseGroupCategoriesGroups:
    GroupMembership.append({"Name": record['Name']})

answered Dec 04 '19 at 13:50

Bendik Knapstad

1,409
1
9
18

Ok thanks so now Name is the key and record['Name'] is the value right ? – Abdullah Dec 04 '19 at 13:52

score 1 · Answer 2 · answered Dec 04 '19 at 13:51

Here is a solution:

GroupMembership =[]

for record in CourseGroupCategoriesGroups:
    GroupMembership.append({"GroupId": record["GroupId"], "Name": record["Name"]})

You could also use a list comprehension:

GroupMembership = [{"GroupId": record["GroupId"], "Name": record["Name"]} for record in CourseGroupCategoriesGroups]

score 0 · Answer 3 · answered Dec 04 '19 at 13:53

0

GroupMembership.append({"Name": CourseGroupCategoriesGroups[0]['Name']})

answered Dec 04 '19 at 13:53

rajvi

150
11

How can i retrieve a specific data from a json object and add in to an new array

3 Answers3