问题描述:
代码:
importsys
reload(sys)
sys.setdefaultencoding('utf-8')
importjieba
importjieba.analyse
importopenpyxl
if__name__ =="__main__":
wbk = openpyxl.Workbook(encoding='ascii')
sheet = wbk.add_sheet("wordCount")
word_lst = []
key_list = []
forlineinopen('/home/frida/1.txt'):
item = line.strip('\n\r').split('\t')
# print item
tags = jieba.analyse.extract_tags(item[0])
fortintags:
word_lst.append(t)
word_dict = {}
withopen("/home/frida/wordCount.txt",'w')aswf2:
foriteminword_lst:
ifitemnot inword_dict:
word_dict[item] =1
else:
word_dict[item] +=1
orderList =list(word_dict.values())
orderList.sort(reverse=True)
# print orderList
foriinrange(len(orderList)):
forkeyinword_dict:
ifword_dict[key] == orderList:
wf2.write(key +' '+str(word_dict[key]) +'\n')
key_list.append(key)
word_dict[key] =0
foriinrange(len(key_list)):
sheet.write(i,1,label=orderList)
sheet.write(i,0,label=key_list)
wbk.save('wordCount_xls')
运行结果显示 line 16, in wbk = openpyxl.Workbook(encoding='ascii')TypeError: __init__() got an unexpected keyword argument 'encoding'
解决方法;
这是对workbook的描述,没有encoding参数
Init signature: Workbook(write_only=False, iso_dates=False)
Docstring: Workbook is the container for all other parts of the document.
File: c:\programdata\anaconda3\lib\site-packages\openpyxl\workbook\workbook.py
Type: type