Attribute将dict导出为csv文件时引发错误



我肯定是太盲目了。在这里的一些帖子的帮助下(感谢大家),我能够一步一步地走得更远。

我读取了一个xls文件,将其移动到dict中(我需要进行操作,即稍后删除一些列),并将其写成csv。

我的代码:

wb = xlrd.open_workbook(args.inname)
sheet = wb.sheet_by_index(0)
# read header values into the list
keys = [sheet.cell(0, col_index).value for col_index in xrange(sheet.ncols)]
print "keys are", keys
mydict = []
for row_index in xrange(1, sheet.nrows):
    d = {keys[col_index]: sheet.cell(row_index, col_index).value
        for col_index in xrange(sheet.ncols)}
    mydict.append(d)
with open('mycsvfile.csv','wb') as f:
    w = csv.writer(f, quoting=csv.QUOTE_ALL)
    w.writerow(mydict.keys())
    w.writerow(mydict.values())

但这给了我以下错误:

Traceback (most recent call last):
  File "xls2csv.py", line 80, in <module>
    main()
  File "xls2csv.py", line 53, in main
    w.writerow(mydict.keys())
AttributeError: 'list' object has no attribute 'keys'

有趣的是:"打印"键是",键确实正确打印了所有键…

mydict是一个列表:将行mydict = []更改为mydict = {}。然后它崩溃是因为dict结构中不存在append方法。要在dict中附加值,可以使用mydict = {1:2}mydict[1] = 2。提高dict技能的最佳方法是打开python控制台并尝试所有方法。也可以将列表放入dict值:
>>> mydict = {}
>>> mydict['namelist'] = [1,2,3]
>>> mydict['namelist'].append(4)
>>> mydict
{'namelist': [1, 2, 3, 4]}

最新更新