Python creating nested dictionary from a List with repeating keys

Question

I am trying to convert the list to a dictionary. I have a list of list like this and some of the first values of mini lists are repeating:

list = [["DDS 500","A",300], ["DDS 500","B",100], ["AGB 850","C",250], ["AGB 850","B",350], ["UNI 100","D",900]]

The first value of mini lists will be key . Then, for each mini list second and third value will be the "value" for that key and the values also should be a dictionary. As a result, Final dictionary should be like this:

dict = { "DDS 500":{"A":300,"B":100}, "AGB 850":{"C":250,"B":350}, "UNI 100":{"D":900} }

Have you made any attempts to solve this issue? What exactly are you stuck on? — jordanm
– jordanm, Commented Mar 19, 2020 at 17:04
I tried to create the dictionary, but since some of the values in the list are repeated, it only gave the dictionary the value saw first. For example, ` dict = {"DDS 500: {" A ": 300}, .. ` @jordanm — snndmnsz
– snndmnsz, Commented Mar 19, 2020 at 17:07

Ch3steR · Accepted Answer · 2020-03-19 17:05:31Z

3

You can use collections.defaultdict

from collections import defaultdict

lst= [["DDS 500","A",300], ["DDS 500","B",100], ["AGB 850","C",250], ["AGB 850","B",350], ["UNI 100","D",900]]

out=defaultdict(dict)

for k,ik,iv in lst:
    out[k].update({ik:iv})

Output:

defaultdict(dict,
            {'DDS 500': {'A': 300, 'B': 100},
             'AGB 850': {'C': 250, 'B': 350},
             'UNI 100': {'D': 900}})

answered Mar 19, 2020 at 17:05

Ch3steR

20.8k4 gold badges34 silver badges66 bronze badges

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

Comments

kederrac · Accepted Answer · 2020-03-19 17:55:18Z

1

you can use dict.setdefault if you do not want to import any module:

result = {}

for k1, k2, v in my_list:
    result.setdefault(k1, {})[k2] = v
result

output:

{'DDS 500': {'A': 300, 'B': 100},
 'AGB 850': {'C': 250, 'B': 350},
 'UNI 100': {'D': 900}}

answered Mar 19, 2020 at 17:55

kederrac

17.4k6 gold badges36 silver badges58 bronze badges

Comments

Alain T. · Accepted Answer · 2020-03-19 22:09:06Z

1

You could do it in two steps: 1) create the dictionary with all keys and and empty dictionary as value, 2) merge the values as dictionaries into each key:

lst = [["DDS 500","A",300], ["DDS 500","B",100], ["AGB 850","C",250], ["AGB 850","B",350], ["UNI 100","D",900]]

d = { k:dict() for k,*_ in lst }
for k,*v in lst: d[k].update(dict([v]))

output:

print(d)

# {'DDS 500': {'A': 300, 'B': 100}, 'AGB 850': {'C': 250, 'B': 350}, 'UNI 100': {'D': 900}}

answered Mar 19, 2020 at 22:09

Alain T.

42.2k4 gold badges36 silver badges57 bronze badges

Collectives™ on Stack Overflow

Python creating nested dictionary from a List with repeating keys

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related