计算机毕业设计：基于python招聘数据分析系统+可视化大屏 +Flask框架（建议收藏）_python flask数据大屏框架

博主介绍：✌全网粉丝10W+,前互联网大厂软件研发、集结硕博英豪成立工作室。专注于计算机相关专业毕业设计项目实战6年之久，选择我们就是选择放心、选择安心毕业✌

毕业设计：2023-2024年计算机专业毕业设计选题汇总（建议收藏）

毕业设计：2023-2024年最新最全计算机专业毕设选题推荐汇总

1、项目介绍

技术栈：
Python语言、Flask框架、MySQL数据库、HTML、可视化大屏

2、项目界面

（1）数据可视化分析

（2）学历可视化分析

（3）热门岗位可视化分析

（4）招聘数据

（5）个人信息页面

（6）注册登录界面

3、项目说明

Flask招聘数据采集分析可视化系统是一个基于Flask框架开发的应用程序，旨在帮助用户高效地采集、分析和可视化招聘数据。

该系统具有以下主要功能和特点：

1. 数据采集：系统能够自动从各大招聘网站抓取招聘信息，包括职位名称、公司名称、薪资待遇、工作地点等关键信息。用户可以根据自己的需求设置抓取的时间范围、关键词等参数。

2. 数据分析：系统能够对采集到的数据进行多维度的分析，包括职位数量、薪资分布、热门行业等。用户可以通过图表和统计数据快速了解招聘市场的趋势和变化，并做出相应的决策。

3. 可视化展示：系统提供丰富的可视化图表，如柱状图、饼图、折线图等，帮助用户直观地展示和比较不同指标之间的关系和变化趋势。用户可以根据自己的需求自定义图表样式和展示方式。

4. 用户管理：系统支持用户注册、登录和权限管理，保护用户数据的安全性和隐私性。用户可以根据自己的角色和权限访问和管理系统的功能和数据。

5. 可扩展性：系统基于Flask框架开发，具有良好的可扩展性和灵活性。用户可以根据自己的需求定制和扩展系统的功能和界面。

通过使用Flask招聘数据采集分析可视化系统，用户可以更加高效地获取和分析招聘数据，及时把握市场动态，为招聘决策提供有力支持。

4、核心代码

from flask import Flask,request,url_for, jsonify
import pymysql
from flask_cors import *
import pandas as pd
from collections import Counter

app = Flask(__name__)
app.config['JSON_AS_ASCII'] = False
CORS(app, supports_credentials=True)

from flask.json import JSONEncoder as _JSONEncoder

class JSONEncoder(_JSONEncoder):
    def default(self, o):
        import decimal
        if isinstance(o, decimal.Decimal):

            return float(o)

        super(JSONEncoder, self).default(o)
app.json_encoder = JSONEncoder

@app.route('/page2',methods=['GET'])
def page2():
    if(len(request.args)!=0):
        data_year = request.args['year']
        data_top = request.args['top']
        sql = "SELECT `name`,box_office from films WHERE `year` = "+data_year+" ORDER BY box_office DESC LIMIT 0," +data_top
    else:
        sql = "SELECT sum(1),'老用户'  from orders where left(`Order Date`,4) = '2014'" \
              " UNION SELECT SUM(1),'新用户' from orders where left(`Order Date`,4) = '2017'"
    conn = pymysql.connect(host='127.0.0.1', user='root', password='123456', port=3306, db='zhaopin',
                           charset='utf8')

    cursor = conn.cursor()
    cursor.execute(sql)
    values = cursor.fetchall()
    jsondata = {}
    datas = []
    for index,i in enumerate(values):
        mydict = {}
        mydict["value"] = i[0]
        mydict["name"] = i[1]
        datas.append(mydict)
    jsondata['datas'] = datas
    j = jsonify(jsondata)
    cursor.close()
    conn.close()
    return j

@app.route('/page3',methods=['GET'])
def page3():
    if(len(request.args)!=0):
        data_type = request.args['type']
        sql = "SELECT SUM(1) from orders where left(`Order Date`,4) = '2014' and `Category` LIKE '%" + data_type + "%' " \
              " UNION SELECT SUM(1) from orders where left(`Order Date`,4) = '2015' and `Category` LIKE '%" + data_type + "%' " \
              " UNION SELECT SUM(1) from orders where left(`Order Date`,4) = '2016' and `Category` LIKE '%" + data_type + "%' " \
              " UNION SELECT SUM(1) from orders where left(`Order Date`,4) = '2017' and `Category` LIKE '%" + data_type + "%' "
    else:
        sql = "SELECT SUM(1) from search_data where  education LIKE '%大专%'"  \
              " UNION SELECT SUM(1) from search_data where  education LIKE '%本科%'"  \
              " UNION SELECT SUM(1) from search_data where  education LIKE '%硕士%'"  \
              " UNION SELECT SUM(1) from search_data where  education LIKE '%2年经验%'"
    conn = pymysql.connect(host='127.0.0.1', user='root', password='123456', port=3306, db='zhaopin',
                           charset='utf8')

    cursor = conn.cursor()
    cursor.execute(sql)
    values = cursor.fetchall()
    jsondata = {}
    xd = []
    for index,i in enumerate(values):
        xd.append(i[0])
    jsondata['data'] = xd
    j = jsonify(jsondata)
    cursor.close()
    conn.close()
    return j


@app.route('/page4',methods=['GET'])
def page4():
    data_year = ''
    if(len(request.args)!=0):
        data_year = request.args['year']
        data_top = int(request.args['top'])
    else:
        data_top = 10
    sql = "SELECT SUM(Discount) from orders where Region LIKE '%East%' " \
          "UNION SELECT SUM(Discount) from orders where Region LIKE '%South%'" \
          " UNION SELECT SUM(Discount) from orders where Region LIKE '%West%'" \
          "UNION SELECT SUM(Discount) from orders where Region LIKE '%Central%'"
    conn = pymysql.connect(host='127.0.0.1', user='root', password='123456', port=3306, db='zhaopin',
                           charset='utf8')
    cursor = conn.cursor()
    cursor.execute(sql)
    values = cursor.fetchall()
    jsondata = {}
    xd = []
    yd = ['East', 'South', 'West', 'Central']
    datas = []
    for index, i in enumerate(values):
        mydict = {}
        mydict["value"] = i[0]
        mydict["name"] = yd[index]
        datas.append(mydict)
        xd.append(i[0])
    jsondata['categories'] = yd
    jsondata['data'] = xd
    jsondata['datas'] = datas
    j = jsonify(jsondata)
    cursor.close()
    conn.close()
    return j

@app.route('/data',methods=['GET'])
def data():
    limit = int(request.args['limit'])
    page = int(request.args['page'])
    page = (page-1)*limit
    conn = pymysql.connect(host='127.0.0.1', user='root', password='123456', port=3306, db='zhaopin',
                           charset='utf8')

    cursor = conn.cursor()
    cursor.execute("select count(*) from search_data");
    count = cursor.fetchall()
    cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
    cursor.execute("select * from search_data limit "+str(page)+","+str(limit));
    data_dict = []
    result = cursor.fetchall()
    for field in result:
        data_dict.append(field)
    table_result = {"code": 0, "msg": None, "count": count[0], "data": data_dict}
    cursor.close()
    conn.close()
    return jsonify(table_result)



@app.route('/addUser',methods=['POST'])
def addUser():
    get_json = request.get_json()
    name = get_json['name']
    password = get_json['password']
    conn = pymysql.connect(host='127.0.0.1', user='root', password='123456', port=3306, db='zhaopin',
                           charset='utf8')
    cursor = conn.cursor()
    sql = "insert into `user` values(null,'"+name+"','"+password+"')"
    cursor.execute(sql);
    conn.commit()
    table_result = {"code": 200, "msg": "成功"}
    cursor.close()
    conn.close()
    return jsonify(table_result)

@app.route('/loginByPassword',methods=['POST'])
def loginByPassword():
    get_json = request.get_json()
    name = get_json['name']
    password = get_json['password']
    conn = pymysql.connect(host='127.0.0.1', user='root', password='123456', port=3306, db='zhaopin', charset='utf8')
    cursor = conn.cursor()
    cursor.execute("select count(*) from `user` where `name` = '" + name +"' and password = '" + password+"'");
    count = cursor.fetchall()
    if(count[0][0] != 0):
        table_result = {"code": 200, "msg": "成功"}
    else:
        table_result = {"code": 500, "msg": "失败"}
    cursor.close()
    conn.close()
    return jsonify(table_result)
    
if __name__ == "__main__":
   app.run(port=5000)


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177