Write a dictionary of dictionaries to csv in python

Question

I have a dictionary of dictionaries that I would like to write out to csv. my dictionary looks like:

dict={
    object1:
        {
            time1:[value1,value2],
            time2:[value3,value4]
        },
    object2:
        {
            time1:[value5,value6],time2[value7,value8]
        }
    }

I would like it to write out as:

object1

time1, value1, value2

time2, value3, value4

object2

time1, value5, value6

time2, value7, value8

Thus far, I can only figure out how to write the key/value pairs out csv using the following code:

writer = csv.writer(open('test.csv','wb'))
for key, value in Dict.items():
    writer.writerow([key,value])

So it looks like:

objcet1,{
    time1:[value1,value2],time2:[value3,value4]
}

objcet2,{
    time1:[value5,value6],time2:[value7,value8]
}

I have tried writing just the outer keys (keys labeled object1 and object2) using

writer = csv.writer(open('test.csv','wb'))
for key, value in Dict.key():
    writer.writerow([key])

but it just writes out a blank file. I think If I could figure out how to write the outer keys by themselves, I would be able to write out the csv as I want. Does anyone have any suggestions?

Anas Bouayed · Accepted Answer · 2016-11-01 22:51:57Z

2

I personally recommend using Excel, I have been working on .csv files, but ended up using .xlsx.

import xlsxwriter
workbook = xlsxwriter.Workbook('File.xlsx')
worksheet = workbook.add_worksheet()                            
row = 0
col = 0
for key in dictionary.keys():
    row += 1
    worksheet.write(row, col, key)
    for item in dictionary[key]:
        worksheet.write(row, col + 1, item)
        worksheet.write(row, col + 2, dictionary[key][item][0])
        row += 1

workbook.close()

And there you can change the columns and the rows increment so that you get the excel table you want to. You can even export it as a .csv file afterwards from Excel.

answered Nov 1, 2016 at 22:51

Anas Bouayed

1191 gold badge1 silver badge11 bronze badges

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

Comments

Julien Vivenot · Accepted Answer · 2012-11-15 22:01:31Z

1

Your expected output format looks very surprising and does not look like a sensible csv format.

However, this would result in exactly what you seem to be looking for :

>>> mydict = {'object1':{'time1':['value1','value2'],'time 2':['value3','value4']},'object2':{'time1':['value5','value6'],'time2':['value7','value8']}}

>>> print "\n".join(["%s %s " % (k, " ".join([", ".join([k1]+v1) for (k1,v1) in v.iteritems()])) for (k,v) in mydict.iteritems()])

object1 time1, value1, value2 time2, value3, value4 
object2 time1, value5, value6 time2, value7, value8

answered Nov 15, 2012 at 22:01

Julien Vivenot

2,25013 silver badges17 bronze badges

1 Comment

roskakori Over a year ago

This solution only works as long the values do not contain any characters that require CSV escaping, in particular commas, quotes and linefeeds. Using csv.writerow() would ensure that everything is escaped properly.

Gerrat · Accepted Answer · 2012-11-15 22:08:19Z

1

Try this:

import csv

writer = csv.writer(open('test.csv','wb'))
d={'object1':{'time1':['value1','value2'],'time2':['value3','value4']},
   'object2':{'time1':['value5','value6'],'time2':['value7','value8']}}
for key, value in d.iteritems():
    ln = [key]
    for ik, iv in value.iteritems():
        ln.append(ik)
        ln.extend([v for v in iv])
    writer.writerow(ln)

answered Nov 15, 2012 at 22:08

Gerrat

29.9k9 gold badges78 silver badges104 bronze badges

1 Comment

user1828018 Over a year ago

Thank you both for your help. Both of these suggestions output: object1, time1, value1, value2, time2, value3, value4 object2, time1, value5, value6, time2, value7, value8 and I am looking for: object1 time1, value1, value2 time2, value3, value4 object2 time1, value5, value6 time2, value7, value8 I'll take what you provided me, and see if I can tweak it to get what I want. If you have any suggestions, that would be great too. Thanks again!

Collectives™ on Stack Overflow

Write a dictionary of dictionaries to csv in python

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related