想问一下为什么词云图显示运行成功,但是却没有文字显示,只有方形的背景,也没有蒙版图案
显示这个 [42S22][1054] Unknown column 'missing_value' in 'field list'问题,但是我检查了数据库和列名都没有错
代码如下:
import jieba
from PIL.ImageColor import colormap
from matplotlib import pylab as plt
from wordcloud import WordCloud,ImageColorGenerator
import numpy as np
from imageio import imread
from PIL import Image
from pymysql import *
import json
def get_img(cname,targetImageSrc,resImageSrc):
con=connect(host='localhost',user='root',password='******',database='stockdata',port=3306,charset='utf8')
cusor=con.cursor()
sql = f"select cname from stockinfom"
cusor.execute(sql)
data=cusor.fetchall()
text=''
for i in data:
if i[0] !='':
tagArr=i
for j in tagArr:
text +=j
cusor.close()
con.close()
data_cut=jieba.cut(text,cut_all=False)
string=''.join(data_cut)
#图片
img =Image.open(targetImageSrc)
img_arr =np.array(img)
wc = WordCloud(
font_path='Deng.ttf',
mask=img_arr,
background_color='#97e2f5',
# mask = backgroud_Image, # 设置背景图片
colormap = 'Accent', # 设置文字颜色
)
wc.generate_from_text(string)
#绘制图片
# image_colors = ImageColorGenerator(img_arr) # 获取color
# plt.imshow(wc.recolor(color_func=image_colors),
# interpolation="bilinear") # 按照给定的图片颜色布局生成字体颜色,当wordcloud尺寸比image大时,返回默认的颜色
fig=plt.figure(1)
plt.axis('off')
plt.imshow(wc)
plt.savefig(resImageSrc,dpi=800)
get_img('cname','./big-screen-vue-datav-master/public/jiadian.png','./big-screen-vue-datav-master/public/Jiadian.png')