我正在尝试将随机生成的字符串和数字的字典写入excel文件.我几乎成功但有一个小问题.我字典的结构如下：

Age: 11, Names Count: 3, Names: nizbh,xyovj,clier

该字典是通过文本文件获得的数据生成的.它根据年龄汇总所有内容,如果两个人的年龄相同,则将它们分组到一个列表中.我正在尝试将此数据写入excel文件.到目前为止,我已经编写了这段代码.

import xlsxwriter

lines = []

workbook = xlsxwriter.Workbook('demo.xlsx')

worksheet = workbook.add_worksheet()

with open ("input2.txt") as input_fd:

lines = input_fd.readlines()

age_and_names = {}

for line in lines:

name,age = line.strip().split(",")

if not age in age_and_names:

age_and_names[age]=[]

age_and_names[age].append(name)

print age_and_names

for key in sorted(age_and_names):

print "Age: {}, Names Count: {}, Names: {}".format(key, len(age_and_names[key]), ",".join(age_and_names[key]))

row=0

col=0

for key in sorted(age_and_names):#.keys():

row += 1

worksheet.write(row, col, key)

for item in age_and_names[key]:

worksheet.write(row, col+1, len(age_and_names[key]))

worksheet.write(row, col+1, item)

row+=1

workbook.close()

但实际上这是做什么的(在excel文件中)：

11 nizbh

xyovj

clier

我应该怎么做让它看起来像这样？

Age Name Count Names

11 3 nizbh, xyovj, clier

最佳答案 问题确实存在于两个for循环中.我干涉并和他们一起玩,直到我到达答案.他们工作正常.感谢你们！

用这个替换最后的for循环：

for key in sorted(age_and_names):#.keys():

row+=1

worksheet.write(row, col, key)

worksheet.write(row, col+1, len(age_and_names[key]))

worksheet.write(row, col+2, ",".join(age_and_names[key]))

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?

解决方案

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.