How to iterate through an array and a list of tuples making a list of dictionaries in Python?

Question

In python how would you iterate through a list (column names) and a list of tuples (row values) in order to build a list of dictionaries? The keys always being generated from the first array and the values generated from each tuple?

col = ['id', 'username', 'email']
rows = [('1234', 'first', '[email protected]'), ('5678', 'second', '[email protected]')]

result = [{'id':'1234', 'username':'first', 'email':'[email protected]'},{'id':'5678', 'username':'second', 'email':'[email protected]'}]

Answer 1

Here's one way:

[dict(zip(col, row)) for row in rows]

How this works:

• The [... for row in rows] part loops through the rows list to construct a new list.
• zip(col, row) matches up corresponding items of col and row, so we end up with [('id', '1234'), ('username', 'first'), ...]
• Finally, dict(...) converts the list of tuples into a dictionary.