python读取txt, jieba分词并统计词频后输出结果到Excel和txt文档
1
2
3
4
5
|
with open ( '1.txt' , 'r' ) as fp:
lines = fp.readlines()
res = [line.split()[ 1 ][ 9 :] for line in lines]
with open ( 'out.txt' , 'w+' ) as out:
out.write( '\n' .join(res))
|
#encoding=utf-8
import jieba
import jieba.posseg as pseg
import re
filename='result.txt'
fileneedCut='test.txt'
fn=open(fileneedCut,"r")
f=open(filename,"w+")
for line in fn.readlines():
words=pseg.cut(line)
for w in words:
print >>f,str(w)
f.close()
fn.close()
- import sys
- reload(sys)
- sys.setdefaultencoding('utf-8')
- import jieba
- import jieba.analyse
- import xlwt #写入Excel表的库
- if __name__=="__main__":
- wbk = xlwt.Workbook(encoding = 'ascii')
- sheet = wbk.add_sheet("wordCount")#Excel单元格名字
- word_lst = []
- key_list=[]
- for line in open('1.txt'):#1.txt是需要分词统计的文档
- item = line.strip('\n\r').split('\t') #制表格切分
- # print item
- tags = jieba.analyse.extract_tags(item[0]) #jieba分词
- for t in tags:
- word_lst.append(t)
- word_dict= {}
- with open("wordCount.txt",'w') as wf2: #打开文件
- for item in word_lst:
- if item not in word_dict: #统计数量
- word_dict[item] = 1
- else:
- word_dict[item] += 1
- orderList=list(word_dict.values())
- orderList.sort(reverse=True)
- # print orderList
- for i in range(len(orderList)):
- for key in word_dict:
- if word_dict[key]==orderList[i]:
- wf2.write(key+' '+str(word_dict[key])+'\n') #写入txt文档
- key_list.append(key)
- word_dict[key]=0
- for i in range(len(key_list)):
- sheet.write(i, 1, label = orderList[i])
- sheet.write(i, 0, label = key_list[i])
- wbk.save('wordCount.xls') #保存为 wordCount.xls文件
1.txt是你需要分词统计的文本内容,最后会生成wordCount.txt和wordCount.xls两个文件。下图是最后结果