Python flask + Mysql +Echarts 绘制词云图（笔记）_echarts 词云图 flask

作者：小小林熬夜学编程 | 2024-03-22 08:45:48

踩

echarts 词云图 flask

步骤一：建立Myslq数据库连接


import json
 
import pymysql
 
class Mysql(object):
    # 创建 Mysql 类的实例时自动调用
    def __init__(self):
        # 建立MySQL数据库连接
        self.conn = pymysql.connect(host='localhost', user='root', password='1234', database='Design', charset="utf8")
        # 创建了一个游标对象cursor，用于执行SQL命令
        self.cursor = self.conn.cursor()
 
    # 这个方法使得 Mysql 类的实例可以作为上下文管理器使用
    def __enter__(self):
        return self
 
    # 负责关闭游标和数据库连接
    def __exit__(self, exc_type, exc_val, exc_tb):
        self.cursor.close()
        self.conn.close()
 
    # 返回的结果是一个元组列表，每个元组代表NameWordCount表中的一行数据。
 
 
    def get_word_count(self):
        sql = 'select word,count from NameWordCount order by count desc limit 400;'
        self.cursor.execute(sql)
        return self.cursor.fetchall()

步骤二：开发Flask应用

这段代码是一个使用Flask框架编写的简单Web应用程序。这个Web应用程序提供了一个界面来展示词云，并且通过POST请求返回了词频统计的JSON数据，这些数据是用于生成词云的。


from flask import Flask, send_from_directory, jsonify
from flask import render_template
 
from mysql import Mysql
 
app = Flask(__name__)
 
@app.route('/ciyun')
def getdata():
# 使用 render_template 函数渲染 ciyun.html 模板
    return render_template('ciyun.html')
@app.route('/data', methods=['POST'])
def myciyun():
# 创建了一个 Mysql 类的实例，用于与MySQL数据库建立连接。
    db = Mysql()
# 调用 db.house() 方法，执行SQL查询并获取结果。
    item = db.get_word_count()
 
    word = []
    count = []
    for data in item:
        word.append(data[0])
        count.append(data[1])
    return jsonify(word=word, count=count)
 
if __name__ == '__main__':
    app.run(debug=True)	#debug=True发生错误时会返回发生错误的地方

步骤三：创建前端页面（ciyun.html ）


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>数据可视化</title>
  <script src="/static/js/echarts.min.js"></script>
  <script src="/static/jquery.min.js"></script>
  <script src="/static/echarts-wordcloud.min.js"></script>
 
</head>
<body>
<div id="main" style="width:100%;height: 800px;border: 1px solid black"></div>
 
<script type="text/javascript">
    var myChart = echarts.init(document.getElementById('main'));
    var app={
        word1:[],
        count1:[]
    };
    $(document).ready(function () {
        getData();
    });
    function getData() {
        $.ajax({
            url: '/data',
            data: {},
            type: 'POST',
            async: false,
            dataType: 'json',
            success: function (data) {
                app.word1 = data.word;
                app.count1 = data.count;
            }
        });
    }
    getData();
    var word=[];
    for(var i = 0;i<app.word1.length;i++){
        word.push({
            name:app.word1[i],
            value: app.count1[i]
        })
    }
    var pic = {
        //china图片
        image: "data:image/jpeg;base64,/9j/4AAQSkZJRgABAQEAAAAAAAD/4QAuRXhpZgAATU0AKgAAAAgAAkAAAAMAAAABADUAAEABAAEAAAABAAAAAAAAAAD/2wBDAAoHBwkHBgoJCAkLCwoMDxkQDw4ODx4WFxIZJCAmJSMgIyIoLTkwKCo2KyIjMkQyNjs9QEBAJjBGS0U+Sjk/QD3/2wBDAQsLCw8NDx0QEB09KSMpPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT3/wAARCAFfAdoDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2JmIJ5pNzetD9TSUALub1o3N60lFAC7m9aNzetJRQAu5vWjc3rSUUALub1o3N60lFAC7m9aNzetJRQAu5vWjc3rSUUALub1o3N60lFAC7m9aNzetJRQAu5vWjc3rSUUALub1o3N60lFAC7m9aNzetJRQAu5vWjc3rSUUALub1o3N60lFAC7m9aNzetJRQAu5vWjc3rSUUALub1o3N60lFAC7m9aNzetJRQAu5vWjc3rSUUALub1o3N60lFAC7m9aNzetJRQAu5vWjc3rSUUALub1o3N60lFAC7m9aNzetJRQAu5vWjc3rSUUALub1o3N60lFAC7m9aNzetJRQAu5vWjc3rSUUALub1o3N60lFAC7m9akqKpaAI36mkpX6mkoAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooqOeWO3head1jjjUs7scBQOcn2FAEmCelQ3F3b2oLXNxDCB3kkCj9a+f/iB8S7zxDqhg0m4mtdMgJVPLco0x/vNjt6D0964OWaWZ90sjSN6sxJ/WgD6ivPHvhexyLjXLLI6qkm8/+O5rS0nWLDXLJbvS7qO5t26Mh6H0I6g+xxXyPWroXiTVPDd39o0m7e3c8MByrj3U8GgD6xorwjTfjprMLKupWVpdJn5mQGNsfhx+le16VqdrrWmQahYyCS3nQOjf0PoQeMe1AFyiiigAooooAKKKKACiiigAqWoqloAjfqaSlfqaSgAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACq97ZW+pWU1peRCW3mXZIhJG4dxxViua8feKf8AhEPDMl+iJJcu4igRzwWPc+oABOKAPJvjF4d0rw7qWmppFpFarLC5kRCckhuCcn3/AErzeruqarea1qEt7qE7T3Epyzsf0HoPYVSoAKKKKACvWfgZr1wmq3WhySFrWSIzxqf4XBAOPqD+leTVv+B9e/4RrxfYag/+pR9kv+43DfkDn8KAPqeikUq6hlIZSMhhzkUtABRRRQAUUUUAFFFFABUtRVLQBG/U0lK/U0lABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUVnah4g0rSryC01C/gtp7gExLK23cB3z0H44rQDAgMpBUjgg9aAFrwn45a59r8Q2ukxtlLKPfIAf435/RQPzr2DXvE+leGLT7Tq12sKn7kY5d/91ep/l718x+JdX/t3xJqGphWVbmZnVW6hew/AYoAy6KKKACiiigAooooA+k/hTrEmseArNp23S2rG2Zs8kL938dpA/CuzryL4B3+bPV7AnlHjnUfUFT/ACFeu0AFFFFABRRRQAUUUUAFS1FUtAEb9TSUr9TSUAFFFFABRRRQAUUUUAFFFFABRRRQAUUVynib4g6Noei3dxbajZ3N7GpWKCOVWLOeBkDsDyfpQB1dFfOlv8XfE3n2RurwSQwTiSQKgVpl7qxHUYz/APXr6DsL631KxhvLOUS286h0dT1B/r2oAsUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABVe+vYdOsLi8um2QW8ZkkbHRQMmrFc38QpPK+H+tt62rL+eB/WgD538WeJLjxT4hudTuAQHO2KMn/VoPur/X6k1LofjbX/Dg2aZqM0cWP9Sx3oP+AnIH4VgUUAWr/UrvVbx7q/uZbid/vSSNuJ/z6VVoooAKKKKACiiigAooooA1tA8S6p4Yu3udIufIkkXY/wAoYMOuCCK7Wx+OevwYF5aWN0vc7TGT+Rx+leaUUAfRfhT4saJ4j2W90w029PAjmb5GP+y/9Dj8a7uvjmvcfgf4inv7C+0i7mkla22yws53bUPBXnsCAce9AHqtFFFABRUc8sVvC0s8iRRLyzuQoH1JpLe4iuoI57d1kikXcjqchge49jQBLUtRVLQBG/U0lK/U0lABRRRQAUUUUAFFFFABRRRQAUVwvjT4oWvg/W4tOaya8cxCSUrLt2ZPA6cnAz+IrPsvjj4euGVbq1vrbJ5Yqrgfkc/pQB2Hi7Un0jwjqt9CP3kVsxT2Y8D8ic18p19A/EjxzoH/AAiN7p0GoR3N1eQgRJAd+M4OSRwBj159q+fqACu38BfEq78GLJbSQm809/m8kybTG3cqcd/SuIooA+g9L+NPh3UJo4biO7snkYLmRAyjPHJB4+uK9Dr45r6g+H2uf8JB4J066Zt0yJ5E3rvTj9Rg/jQB01FFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABWB4602bV/BOrWVsrNNJCTGqjlip3AfjjFb9FAHyTc6Dqtpn7Tpl7FjrvgZf5iui8I/DLWvFLLN5ZsrA9bmZSNw/2V6t+g96+lMn1NFAHzx8QfhlN4RijvdPklu9OICyO4G6JvfHGD2P4fXgK+wp7eG6ge3uI1kikUo6OMhgex9q+StXspNM1e7s5o2ieGVkKMOmDx+mKAKVFFFABRRRQAUUUUAFFFFABXc/CjxTaeGPE7nUGEdrdxeU8x6RkHIJ9sjH41w1FAH1E/xC8KxwtKddsiqjJCvlvwXqTXCeIvjpFHvh8O2PmN0+0XXA/BB/Uj6V4xRQBr654q1nxJKX1W/mnGciMthF+ijgV9O+HbgXXhnS5x0ktIm4/3RXz98LvC8HifxYI76PzLO1jM8q5wGwQAp9iT+QNfSCIsaBI1VUUYUKMAD29hQA+paiqWgCN+ppKV+ppKACiiigAooooAKKKKACori4itbaW4nYJFEpd2PYAZNS1h+NozL4G1tembOXB/4DQB80eI9Yk8QeIL3U5c5uJSyqf4V6KPwAArMoooAKKKKACiiigAr2v4B3Ltp+sWxYlEljkVfQkEH89o/KvFK9n+AkAW31ecypmRo41jyN3AJJx6fMBQB6/RRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUVDdXUFjay3N1MkMES7pJHOAo75ry/XfjpYwCWLQ7CW5cZCzTnYn129T+OKAOj+IXxAtvB1h5UGybVZl/dRHpGP77e3t3+leRT/F/wAXzfd1FIv+ucCD+lcpqOo3WrX815fTNNcTNud2PJ/z6VUoA6aX4keLZvva7dj/AHCF/kKw7/UbvVLprm/uJbidgAZJW3McdOaq0UAFFFFABRRRQAUUUUAFFFFABRRRQAUUVd0jTJ9a1a10+1XdNcyCNfbPf6AZP4UAe1fAzR/svhq81N1w95NsU4/gT/7In8q9PqlpOmQaLpFrp1qMQ20YjX3x3+pOT+NXaACpaiqWgCN+ppKV+ppKACiiigAooooAKp6rLeW+mXE2nW6XF0iFoonbAcjtn1NXKBwRQB886r8ZvFN2Xjge3sF6bYYssPxbP9K5HUvEWr6uSdR1K7uc/wAMkpI/LpV/x5pn9j+N9WtAuEFwXQf7LfMP0aueoAKKKKACiiigAooooAKkgnlt5VkgkeORejISpH4io6KAOy0j4reKtIUIL/7XGOi3S+Z+vX9a29M+OeuQXm7UrS0urduqRqY2H0PP65rzKigD6a8O/Erw74j2Rw3gtbo/8u9zhCT7HofwP4V1lfHNeifDP4hXWia1BYapeSyaXcfu8SsSIGP3WHoM8EdMHPagD6CooooAKKKKACiiigAooooAKKKKACiiigAooooA8v8Aiv8AEO98N3dvpWiTLFdFPMnlKhigP3VAPAJ5P0xWFoXx1u4dsWvaelwnea3Ox/xXofwxWZ8ZvDjaX4pGqLN5kWpAvtZvmRlABGPTpj8u1ec0Adf45+IWoeMbkx5NvpsbZitgevoz+p/Qdq5CiigAooooAKKKKACiiigAooooAKKKKACiiigArQ0PSZte1m1023ZEluX2KznAFZ9W9LuZbLVbS5gYrLFMroR2IINAH0jofw70HRtCGnSWMN7vwZ5Z4wWkb1/2QOwHT680/Q/h74f8O6u+pabaNHcFSqhnLLHnrtz0PbvXT5zg+oooAKKKKACpaiqWgCN+ppKV+ppKACiiigAooooAKKKR3WNC7kKijcxPYCgD55+NE8E3j+VYQN8VvGkpB6tjP8iK4CtTxLqh1vxLqOo54uJ2dfZc8fpisugAooooAKKKKACiiigAooooAKKKKACiiigD3D4X/EyK9t7fQdbkEd1GBHbXDHAlA6Kx7N2z3+vX1bBr46BIII4IrfHjzxOI1jGu34RQFAEpGAKAPqbB9DRhvQ/lXylJ4w8Qy/f1zUj/ANvL/wCNV38QaxJ9/Vb9vrcOf60AfWuD6GivlDTPFWtaRerd2Op3KSjqTIWDexB4I+tes+FPjZaXey28SQi0lPAuYgTGfqvVfwyPpQB6tRVWw1Ky1SETafdwXUZH3oZA38qtUAFFFVL/AFOy0q3M+oXcFrEP4pXCj9ev4UAW6K841f426BYT+VYwXOoYPzSIPLX8M8n8qpL8etJ/i0i+B9pENAHqlcf46+IVj4MtzENtzqci5itgeF/2n9B7dT+teeav8ddUuQ6aTp9vZqekkpMjj+QB/OvMru6nvrqS5upXmnlbc8jnJY+5oAtazrV94g1KW+1O4aeeQ8k9FHoB2HsKz6KKACiiigAooooAKKKKACiiigAooooAKKKKACiiigByI0jhUUszHAAHJro/BPhO98W6/FbW4McMRD3ExXiNQf5noBXd/CLwBcC9TxBq9uY441zZxOMFmP8AGR2AHTPUnNer6ZotjpEl49jAsP2ybzpVUYBfGMj06Zx6k0AX/T2GKKKKACiiigAqWoqloAjfqaSlfqaSgAoorIfxXoEd5LaS6zYR3ETFHjecKVYdue4oA16K5Pxf8QNL8MaIbmK4gvLqTK28MUgbe3qcdFH/ANbvXjd/8XfFt9wt+lqp7W8Sr+pyaAPYvGvxE03wWEhmR7q+lXctvGQMDsWPYH8TxXjHib4neIPEoeFrj7HZtwbe2O0Ef7TdW/l7Vy17fXOpXb3V7PJcXEhy0kjZLVXoAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAJrW8uLGYTWlxLBKOjxOVI/EV2mi/GDxPpW1Li4j1CEfw3S5P8A30MH881wtFAHpOtfG3XdQj8vTYYNOUjBdf3j59ieB+X41wF/qV5qlwbjULqa5lbq8rlj+tVaKACiiigAooooAKKKKACiiigAooooAKKKKACiuo8CeDZ/GWti2UtHZwjfczAfdXsB7n/E13njz4V6Vovg2S90aOX7RaMJJXlk3GROh9hjg8e9AHjdFFFABV/R9Gvde1OKw02AzXEpwFHYdyT2A9a2/Cnw81vxYVltYBBZE4N1Nwn4d2P0/MV7x4O8Faf4M08w2g826kH7+5Zfmk9h6KPT+ZoA8M1b4XeKdLvBANNkvFb7stqN6H/D8cV7J8OvDY03wbZw6tpMEV8jPv8AMiUvjcSMn6GuzooAKKKKACiiigAooooAKlqKpaAI36mkpX6mkHUUAeK/Fjx7rNj4im0TTL1rW2ijXzDCNrszDJ+bqOo6YryV2aRyzEsx5JJ5Nbnjia4uPG2ry3cbRStcv8jDkAHA/QCsGgAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoorQ0LRrnxBrNrptmuZrh9oJ6KO7H2AyfwoAz67fwP8M9Q8YILt5VtNND7TMwyzkdQi9/TJwPrXd23wG0yO9D3GrXU1sOsSxhGP8AwL0/CvStP0+30rT4LKyiEVtAgREHYD/Oc0AUvDXhrT/CulLY6ajBN253Y5eRvUn/ADivIvi948/tS7bQdMlzZ27f6RIp/wBbIP4fov6n6V7m7rGhdjhVGScdK8u1D4aweM/Fbas8B0zSSq/IseyW6bkl9v8AADwMnk4zjnNAHjuieH9S8RXq2mlWklxL32jhR6kngD616Bo/wN1eW4jbVrq1t4Aw3pGxdyvcDjAP417LpGi6foNgtnpdrHbQL/Cg5Y+pPUn3NX6AILO1gsLOG1tYhFBCgSNFHCgVPRRQAUUUUAFFFFABRRRQAUUUUAFS1FUtAEb9TSUr9TSUAZ1z4f0i+vDdXml2U9wwAaWSBWYge59K+X/E9gumeKNTs0UIkN1IqKOy7jj9MV9WXEjQwSSJE8zqpYRpgM3sM8ZPvXzT8QrXUZPE97ql5o95p0N1IConTjO0Z+YcEnBPFAHKUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAVr+GPENz4X1231O0VXkiyCjdHU8Ee2R3rIooA+qPDPjPR/FlsH025XzguXtnOJE/DuPcZFb1fJfh7WJPD+v2Wpw5LW0ocqD95e4/EZH417bqnxr0G30kXGnJNdXkgIW2dCmw/wC23TH0zn2oA9H5or5d1Px94h1TWU1OTUZoZ4jmJYTtSMegX09c5z3zXa6b8b9bNqTcaLDeeQoM0sZZMD1OAQM/gKAPbaKpaTdz32k2t1dW/wBmmmiWRod27ZnnGfUcVdoAKKKKACiiigAooooAKKKKACiiigAqWoqloAjfqaSlfqaSgAqlqmj2GuWotNUtY7qAMHCSdAw7/Xk/nV2igD5Q8VWEOleKdTsbVHSCC5dI1fqFB4/SsivrHWvDWk69azw6jYwyeeoVpAoEnHTDdcivObr4C2bXyNaaxNHaE/MkkQZx9GGB+YoA8UpSpViGBBHYivprw/8ADbw34e2vb2K3Nwv/AC3uf3jZ9h0H4Co/HHgHTPFVhLKY4bbUUT93d4xgD+9j7wxn6UAfNFFSToiTOkb+YgYhWxjcPWo6ACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoAJIA6mivS/hV8PY/Ecp1fVkJsLeTbHH089x1z/sjj6nj1oAPh78Mp9S1q5TxNptxDZ28QO1yYy7k8YI6jAPT2r2fSfDWk6FZS2emWEUEEv8ArFxu39uc9a1PT26e1FADadRRQAUUUUAFFFFABRRRQAUUUUAFFFFABUtRVLQBG/U0lK/U0lABRRRQAUUUUAFecfFrxyfD2nto1pGTeX8B3Sk8RxnK8epOCPauv8VLdt4U1QacZRefZn8kw5D7gMjGO9fLV9c3d1cs1/NPLOvysZmLMPbmgCtRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFeseAfi5DpFlbaRrVqEtIRsjuYF5Qf7S9/qOfY15PRQB9hRSJNCksbB45FDKw5yDzn8akriPhJrn9s+BraKRt09gxtnyew5X/x0gfhXb0AFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFS1FUtAEb9TSUr9TSUAFFFFABRRRQBh6z4s07QdXsLHUXaD7aHKXD8RLt7Fj0JrwX4m67pXiHxc97o4YxiMRySkYErDPzAemMDnrivUfjfDE3geKV490kd2gRsfdyDn88V8/UAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAd/8JPFkHhvxDJb38nl2d+oQuTwjg/KT7ckZ96+hv/1jFfL+iXPhm72Wmu2MtoG4F9ZyMSp/2kbII+mD7GvoHwfp13pWkJayanHqdkoBs7gDD+WeinqGA7EfSgDoKKKKACiiigAooooAKKKKACiiigAooooAKlqKpaAI36mkpX6mkoAKKKKACiiigChrWj2ev6TPp2oRl7acYYA4PByCD2IIrzjxJ8D7CazD+Hbh7e5Qf6u4fckn49VP5j6V6tRQB8k6xomoaBfNZ6payW0y/wALjhh6g9CPcVn19a61oOneIbI2mqWqXERPGRyp9QeoP0qhf+A/DOpAi50W03EYLRp5bfmuKAPlmiu/+IHwwuvCge/sXNxpRYDJ+/DnoG9R2yPxxXAUAFFFFABRRRQAUUUUAFFFFABRRSgFiABkntQAlFSzW0ttIY54nicAEq6kEZGRwfaoqACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigDR0bQdS8Q3gttKs5bmTvtHC+5PQD619C/DvwpqfhPRmtdT1EXIchkt0GUg9cMeTn04FfPsfiPVoLNbS31CeC3U5EcD+WM+p24yfc17d8I/EuseIdOuV1a7t7lbcKEPWYZzjeRxjg9eaAPRKKKKACiiigAooooAKKKKACiiigAooooAKlqKpaAI36mkpX6mkoAKKKKACiiigAooooAKKKKAK1/YwanYT2V3GJLedDG6+oP9e9ebeMfhHFPo1pbeFLS1hkidmmeaQ+ZIMYA3H8eOBXqVFAHyf4g8M6p4Yu0ttXt/IkkXcnzqwYdM8E1k19Ya54X0jxJD5erWMVwQpVZCMOg9mHI9a85T4B237zfrkvJPl7bccemeefwxQB4rRXqx+Amp/aSo1ez8ns5Rtx/4D/9eqXjX4XQeEPC8N4t7Ne3stykOFQKgBDdByScgd/woA82or3b4efCm10/Tvt3iW0iuLu4T5baVdywKfUf3v5dOtaup/B3wtqG5oLeexc97eU4B+jZH8qAPnSprW1nvrmO2tYXmmkbakaDLMfQCvXrb4Cgai5utYzYg/uxHH+8Ye+eAfpn8K9D8OeCdD8K/NpdkqzEbWnkO+Qj6npn0GKAOL8CfB+305Y9Q8Sxx3N2eUtD80cf+9/ePt0HvXfWvhfQ7G6FzaaPYwzgYEiQKCPp6Vq0UAeM/HDw8Gv7LVbS3uJJpkMc5RCUAXG0kjoTnHPYV4+cjI719jZNYGp+B/D2sSXM17pdu89yu2SYDDjHQg9iPUdcc5oA+WKK2/E/hm+8L6tPZ3kMgRXKwzFCFlX1B78EfSsSgAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAr6W+GOjQ6X4K0+YWscN1dwiSZ1GDIMkrn3CkfnXmnwl8BweIZrjVNXgEunQgxRxtkCVyOenYA/mRXu8USW8KQwqFjjUIqjsBwPyoAkooooAKKKKACiiigAooooAKKKKACiiigAqWoqloAjfqaSlfqaSgAooooAKKKKACiiigAooooAKKKKACiiigApjosgAdVYAggEZwR/UU+igAooooAKKKKACiiigAooooA83+OVktx4Nt7okB7a6XHuGBBH6A/hXgNex/G3xbbzJH4ctdskkbia5cHOwgcJ9ecn04rxygAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACui8LeCdU8WF209UMUUqRyszDK7j1x6AZP4Vzte5/A7QZbHS9R1K5ikikuJFhRXBU7VGc4PqWH5UAei6NpNtoWkW2m2S7YLdAi+repPuTk/jV6iigAooooAKKKKACiiigAooooAKKKKACiiigAqWoqloAjfqaSlfqaSgAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKyfFOrNofhbUtRQgPbwM0ZI/j6L+pFa1YXjDw6/irQm0pbr7LFLKjSuFySqnOB75A60AfLdxPLdTyTzyNJLIxd3Y5LE8kmoq948Q/Cbw/png3UZLK2mkvYLdpEnklYkleTwOOgPavB6ACiiigAooooAKKKKACiiigAooooAKKKKACiiigAopyK0jhVBZjwABya9I8KfBvVtSu4ptejNhYjDMm4ea49AB93PqenpQAz4e/DPUNT1q2vdZsZYNMiAl/fLt849QoHXB659K9/wD5DgAdqjijWCFIoxiONQqjPQDgVJQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFS1FUtAEb9TSUr9TSUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAhAdSrAFW6gjrXzX8UrHTdN8cXNrpMCwRoimVEPyiQjJwOwwRxX0rXLeK/AGj+KLW4aS0hh1GRf3d2owwbtux94duc8UAfMVbFh4X1nU4IJ7TTbqS3nlESTLGSm7OOvp79K7Cb4LaxaaBeX91d2yz28bSLbplywUZPzcYOB7/hXpPwidm+HNgDuG15QM9xvOPw5oA8sl+DXilNTFqsNs8RyftIlAjH1/iB9sVo6F8D9Xurtv7bnisrZGwfLYSPIPbsB7n8q93ooA5GP4W+E49KFidKV16mZmPmk+u8fyHHtXnPjz4SReHdJuNX0m8llt4CC8EygsqkgZDDqBnuK90qtqNjDqem3NjcjMNxE0bgehGPzHWgD5CorvvEPwg8RaTdSf2fbnUrTOUlhxux7p1z9MimD4QeJ/7JmvGt41mjYAWpcGR1xkkdvbHXg0AcJRWrqfhvVdFtLe51OyltY7kkRCUbWbGM/L1HUdat6R4G8Ra7EkthpNxJDIMrKw2IR6hm6/hQBz9X9P0a91OGea0gkkitgpnZBnYrHAOPSu/074F63cYbUL6ztF7hSZG/Tj9a9O8D+BLXwRbXSQXUl1LdFfMd1CjjPAA7cnrmgDwi88Ba7beIJtIisZbieMBg0S5V0JADA+nI+nNddb/AjV5LVGn1KzinLnfHhmCr6hh1PtgfWvc6KAOE8I/CfSvC93HfzTPf3sf3HdQqRn1C+vuSa7uiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACpaiqWgCN+ppKV+ppKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAEIBBBAII5BHWhEWNAqKqqowFA4FLRQAUUUUAFFFFABRRRQB5z8ZvDtxrHh231C1VpX09y0kQ/iRsAke4IH4E122hSx3GgafJBbPaxtbptgdSpi+X7uD6dK0KKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKlqKpaAI36mkpxBJz60mw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACUUuw+1Gw+1ACVLUew+1OyPegD/2Q=="
 
		}
		 var maskImage = new Image();
    maskImage.src = pic.image
 
option = {
    title: {
        text: '房源名称词云图',
        x: 'center',
        textStyle: {
            fontSize: 25
        }
    },
    backgroundColor: '#F7F7F7',
    tooltip: {
        show: true
    },
    series: [{
        type: 'wordCloud',
<!--        要绘制的“云”的形状。可用的形状有(circle)圆形(默认)、(cardioid)心形，(diamond)菱形，(triangle-forward)三角形向前，(triangle)三角形，(pentagon)五边形和(star)星形。*/-->
<!--        shape: 'pentagon',-->
 
<!--    通过一个轮廓图像，来自定义词云的形状(白色区域将被排除在绘制文本之外)-->
        maskImage: maskImage,
<!--    词云的文字字号范围-->
        sizeRange: [10, 70],
        width:750,
        height:800,
        textStyle: {
            fontFamily: 'sans-serif',
            fontWeight: 'bold',
            color: function () {
                // Random color
                return 'rgb(' + [
                    Math.round(Math.random() * 160),
                    Math.round(Math.random() * 160),
                    Math.round(Math.random() * 160)
                ].join(',') + ')';
            }
        },
        emphasis: {
            focus: 'self',
            textStyle: {
                textShadowBlur: 10,
                textShadowColor: '#333'
            }
        },
        data: word
    }]
};
 myChart.setOption(option);
 //随着屏幕大小调节图表
            window.addEventListener("resize", () => {
                myChart.resize();
            });
</script>
 
</body>
</html>

步骤四：运行Flask应用并查看词云图

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/小小林熬夜学编程/article/detail/286668

Python flask + Mysql +Echarts 绘制词云图（笔记）_echarts 词云图 flask

目录

步骤一：建立Myslq数据库连接

步骤二：开发Flask应用

步骤三：创建前端页面（ciyun.html ）

步骤四：运行Flask应用并查看词云图