Save a Python dictionary in JSON format

Question

I have some data in the following variables,

want to store the python dictionary in the following JSON format,

{
  'name': {
  'Address': '123 abc, IN, 50012',
  'Phone': '123456',
  },
  'name2': {
  'Address': '123 abc, IN, 50012',
  'Phone': '123456',
  },
}

Updated JSON format(Required in this format)

{
  "name":[
  {"Address": "123 abc, IN, 50012"},
  {"Phone": "123456"}
  ],
  "name2": [
  {"Address": "123 abc, IN, 50012"},
  {"Phone": "123456"}
  ]
}

But I managed only to get the JSON in this format,

{"phone": "123456738", "address": "address1,", "name": "name1"}
{"phone": "123456178", "address": "address2,", "name": "name2"}
{"phone": "123452678", "address": "address3,", "name": "name3"}

below is my code

#getting data and adding to dict
dict_list = []
for data in all_data:
    dict = {}
    dict["phone"] = phone.strip()
    dict["address"] = address.strip()
    dict["name"] = name.strip()
    dict_list.append(dict)

#writing to json file
with open('data.json', 'w') as outfile:
  for details in dict_list:
    r = json.dumps(details)
    loaded_r = json.loads(r)
    json.dump(loaded_r, outfile)

The Json you are trying to achieve is not valid(not in correct format) — Mohit Harshan, Feb 18 '19 at 09:39
comment above is right: there's an extra comma that json doesn't accept. BTW you mean to use `indent` parameter? — Jean-François Fabre, Feb 18 '19 at 09:43
You should use the JSON library instead of trying to do this manually. Check out this link from the python documentation - https://docs.python.org/3.6/library/json.html — Nick, Feb 18 '19 at 09:45
@Jean-FrançoisFabre I have updated the required JSON format — Mann, Feb 18 '19 at 10:04
Possible duplicate of [Storing Python dictionaries](https://stackoverflow.com/questions/7100125/storing-python-dictionaries) — taurus05, Feb 18 '19 at 10:18

score 0 · Answer 1 · answered Feb 18 '19 at 10:11

you want to convert the inner dictionary to a list of dictionaries containing only one key & value. Doable with some comprehension syntax:

in_dict = {
  'name': {
  'Address': '123 abc, IN, 50012',
  'Phone': '123456',
  },
  'name2': {
  'Address': '123 abc, IN, 50012',
  'Phone': '123456',
  },
}

out_dict = {k : [{k2:v2} for k2,v2 in v.items()] for k,v in in_dict.items()}

For each key,value (dictionary) pair, iterate on items of the sub-dict and create 1 dictionary per key,value in a list.

result:

>>> out_dict
{'name': [{'Address': '123 abc, IN, 50012'}, {'Phone': '123456'}],
 'name2': [{'Address': '123 abc, IN, 50012'}, {'Phone': '123456'}]}

Save a Python dictionary in JSON format

1 Answers1