loop through json objects and add to dictionary with same key and append to list

Question

I want to loop through the json object and add the json values to dictionary and finally append that dictionary to list. For example:-

lists=[]
dicts={}
for objects in json:
   dicts["a"]= objects["abc"]
   dicts["b"] = objects["xyz"]
   lists.append(dicts)

Input data json:-

{ "json" : [ { 'abc'= 'string1', 'xyz='string2', 'a': 'name'}, { 'abc'= 'john', 'xyz='joe', 'a': 'name'},{ 'abc'= 'b', 'xyz='c', 'a': 'name'} ]}

Expectation for the output is list inside the dictionary like this:-

[{'a': 'string1','b': 'string2'}, {'a': 'john','b': 'joe'}]

How can i achieve this? Any help much appreciated!

Not an error but i am getting the same output every time, so my output is :-[{'a': 'string1','b': 'string2'}, {'a': 'string1','b': 'string2}]. So actually the values are updating in dictionary for same key. — khushali shah
– khushali shah, Commented Jun 6, 2019 at 8:13

Rakesh · Accepted Answer · 2019-06-06 08:15:40Z

1

Using dicts you are over-writing with the last value in json instead

Use:

results = []
for objects in json:
    results.append({"a": objects["abc"], "b": objects["xyz"]})

answered Jun 6, 2019 at 8:15

Rakesh

82.9k17 gold badges86 silver badges122 bronze badges

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

1 Comment

Thank you so much:) Its so easy if i think little much:).Thanks for the help.