python嵌套字典的建立,在Python 2.7中创建嵌套的字典理解

I have a nested tuple returned from a MySQL cursor.fetchall() containing some results in the form (datetime.date, float). I need to separate these out in to a nested dictionary of the form [month/year][day of month] - so I would like to have a dictionary (say) readings which I would reference like readings['12/2011'][13] to get the reading for 13th day of the month '12/2011'. This is with a view to producing graphs showing the daily readings for multiple months overlaid.

My difficulty is that (I believe) I need to set up the first dimension of the dictionary with the unique month/year identifiers. I am currently getting a list of these via:

list(set(["%02d/%04d" % (z[0].month, z[0].year) for z in raw]))

where raw is a list of tuples returned from the database.

Now I can easily do this as a two stage process - set up the first dimenion of the dictionary then go through the data once more to set-up the second. I wondered though if there is a readable way to do both steps at once possibly with nested dictionary/list comprehensions.

I'd be graetful for any advice. Thank you.

解决方案

it seems difficult to do both levels in a concise oneliner, I propose you instead to use defaultdict like this:

res = defaultdict(dict)

for z in raw:

res["%02d/%04d"%(z[0].month, z[0].year)][z[0].day] = z