先将excel的列数据提取出来存到text变量里
data = pd.read_excel(r'C:\Users\Administrator\Desktop\近半年数据.xlsx')
a=data["招投标关键词"]
text=[]
n=0
for i in a:
text.append(i)
n+=1
将变量text从list转换为str,用逗号分隔
text= ",".join(str(i) for i in text)
导入包
from wordcloud import WordCloud
import PIL.Image as Image
import cv2 # pip install opencv-python
使用背景图111.jpg
设置字体msyh
mask=cv2.imread(r'C:\Users\Administrator\Desktop\111.jpg')
wordcloud=WordCloud(font_path="C:/Windows/Fonts/msyh.ttc",background_color="white",mask=mask).generate(text)
image=wordcloud.to_image() #生成图片
image.show()