mydict是一个列表:将行
我肯定是太盲目了。在这里的一些帖子的帮助下(感谢大家),我能够一步一步地走得更远。
我读取了一个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 = {}
。然后它崩溃是因为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]}