How to merge the list of dictionary having keys and values

Question

I have list of dictionary below and merge all the dictionaries into one

 r = [{'Name': 'Dr. Tajwar Aamir MD',
      'Specialised and Location': 'Pediatrics, Princeton, NJ'},
     {'Name': 'Dr. Bernard Aaron', 'Specialised and Location': 'Health'},
     {'Name': 'Dr. Joseph Aaron MD',
      'Specialised and Location': 'Internal Medicine, Short Hills, NJ'},
     {'Name': 'Dr. Michael Aaron DO',
      'Specialised and Location': 'Cardiology, Neptune, NJ'}]

result =  {"Name": [], "Specialised and Location": [] for i in r}
#result["Name"].append(Name)
#result["Specialised and Location"].append(Specialised and Location)

Desired Output

{"Name":['Dr. Tajwar Aamir MD','Dr. Bernard Aaron','Dr. Joseph Aaron MD','Dr. Michael Aaron DO'],
"Specialised and Location":['Pediatrics, Princeton, NJ','Health','Internal Medicine, Short Hills, NJ','Cardiology, Neptune, NJ']}

ComplicatedPhenomenon · Answer 1 · 2019-08-07T12:50:08.790

0

r = [{'Name': 'Dr. Tajwar Aamir MD',
  'Specialised and Location': 'Pediatrics, Princeton, NJ'},
 {'Name': 'Dr. Bernard Aaron', 'Specialised and Location': 'Health'},
 {'Name': 'Dr. Joseph Aaron MD',
  'Specialised and Location': 'Internal Medicine, Short Hills, NJ'},
 {'Name': 'Dr. Michael Aaron DO',
  'Specialised and Location': 'Cardiology, Neptune, NJ'}]
result={'Name':[x['Name'] for x in r], 'Specialised and Location':[x['Specialised and Location'] for x in r]}
print(result)

Output

{'Name': ['Dr. Tajwar Aamir MD', 'Dr. Bernard Aaron', 'Dr. Joseph Aaron MD', 'Dr. Michael Aaron DO'], 'Specialised and Location': ['Pediatrics, Princeton, NJ', 'Health', 'Internal Medicine, Short Hills, NJ', 'Cardiology, Neptune, NJ']}

edited Aug 07 '19 at 12:50

answered Aug 07 '19 at 12:45

ComplicatedPhenomenon

4,055
2
18
45

KeyError: 'Specialised and Location' – Aug 07 '19 at 12:47
worked seperately result={'Name':[x['Name'] for x in r]} print(result).... result={'Specialised and Location':[x['Specialised and Location'] for x in r]} print(result) – Aug 07 '19 at 12:49
@maws I have no idea about your error. – ComplicatedPhenomenon Aug 07 '19 at 12:54

Rakesh · Accepted Answer · 2019-08-07T12:52:10.807

Use a simple for-loop

Ex:

r = [{'Name': 'Dr. Tajwar Aamir MD',
      'Specialised and Location': 'Pediatrics, Princeton, NJ'},
     {'Name': 'Dr. Bernard Aaron', 'Specialised and Location': 'Health'},
     {'Name': 'Dr. Joseph Aaron MD',
      'Specialised and Location': 'Internal Medicine, Short Hills, NJ'},
     {'Name': 'Dr. Michael Aaron DO',
      'Specialised and Location': 'Cardiology, Neptune, NJ'}]
result =  {"Name": [], "Specialised and Location": []}

for i in r:
    result["Name"].append(i["Name"])
    result["Specialised and Location"].append(i["Specialised and Location"])

print(result)

or

result =  {"Name": list(map(lambda d: d['Name'], r)), "Specialised and Location": list(map(lambda d: d['Specialised and Location'], r))}

Output:

{'Name': ['Dr. Tajwar Aamir MD',
          'Dr. Bernard Aaron',
          'Dr. Joseph Aaron MD',
          'Dr. Michael Aaron DO'],
 'Specialised and Location': ['Pediatrics, Princeton, NJ',
                              'Health',
                              'Internal Medicine, Short Hills, NJ',
                              'Cardiology, Neptune, NJ']}

score 0 · Answer 3 · answered Aug 07 '19 at 12:50

you can try:

from collections import defaultdict

my_dict = defaultdict(list)

for k, v in (item for e in r for item in e.items()):
    my_dict[k].append(v)

print(dict(my_dict))

# output: 
# {'Name': ['Dr. Tajwar Aamir MD', 'Dr. Bernard Aaron', 'Dr. Joseph Aaron MD', 'Dr. Michael Aaron DO'], 'Specialised and Location': ['Pediatrics, Princeton, NJ', 'Health', 'Internal Medicine, Short Hills, NJ', 'Cardiology, Neptune, NJ']}

How to merge the list of dictionary having keys and values

3 Answers3