import jieba
import wordcloud#导入wordcloud.jieba模块
from PIL import Image
import numpy as np
import matplotlib.pyplot as plt
from openpyxl import load_workbook
wb = load_workbook('京东评论-当前商品最近评论.xlsx')#打开文本对象
ws =wb.worksheets[0]
content =''
for row in range(2,ws.max_row+1):
content += ws['d'+str(row)].value
# print(content)
txt_1 = jieba.lcut(content)
txt_2 = ' '.join(txt_1)
f = open("stopwords.txt",'r',encoding='UTF-8')
# print(f.read())
s_list = []
for i in f.readlines():
s_list.append(i.strip())
f.close()
for line in s_list:
txt_2 = txt_2.replace(line,'')
photo = np.array(Image.open('心形.png'))
w = wordcloud.WordCloud(font_path="C:\Windows\Fonts\simkai.ttf",background_color='white', mask=photo)
w.generate(txt_2)
w.to_file("ciyun1.png")
plt.imshow(w)
plt.axis('off')
plt.show()
