python 生成简单的词云

from matplotlib import pyplot
from wordcloud import WordCloud,ImageColorGenerator
import jieba,pymysql
from scipy.misc import imread  # 这是一个处理图像的函数

conn = pymysql.connect(
            host = '127.0.0.1',
            port = 3306,
            database = 'learn',
            user = 'root',
            password = 'root',
            charset = 'utf8'
        )
cursor = conn.cursor()
sql = "select name from beijing"
cursor.execute(sql)
results = cursor.fetchall()
rets = ''
for ret in results:
    # print (ret)
    try:
        rets += str(ret[0])
        # print(rets)
    except:
        continue

# 开始拼接字符串
jieba.add_word('python爬虫工程师')
jieba.add_word('python开发工程师')
jieba.add_word('Python全栈工程师')
result = jieba.cut(rets, cut_all = False)
result = "/".join(result)
# 云图渲染
back_color = imread('2.jpg')
wc = WordCloud(background_color='white',  # 背景颜色
               max_words=1000,  # 最大词数
               mask=back_color,  # 以该参数值作图绘制词云，这个参数不为空时，width和height会被忽略
               max_font_size=100,  # 显示字体的最大值
               font_path="msyh.ttc",  # 解决显示口字型乱码问题，可进入C:/Windows/Fonts/目录更换字体
               random_state=42,  # 为每个词返回一个PIL颜色
               )
wc.generate(result)

# 基于彩色图像生成相应彩色
image_colors = ImageColorGenerator(back_color)
# 数学渲染
pyplot.axis('off')# 关闭x,y轴
pyplot.imshow(wc) # 将云图添加到图片中渲染
pyplot.show()# 显示图片