[免费]基于Python的影视数据可视化分析系统(Flask+echarts)【论文+源码+SQL脚本】

大家好，我是python222_小锋老师，看到一个不错的基于Python的影视数据可视化分析系统(Flask+echarts)，分享下哈。

项目视频演示

【免费】基于Python的爱奇艺影视电影数据可视化分析系统(Flask+echarts) Python毕业设计_哔哩哔哩_bilibili

系统展示

部分代码

<!DOCTYPE html>
<html lang="en"><head><meta charset="utf-8"><meta http-equiv="X-UA-Compatible" content="IE=edge"><meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"><meta name="description" content=""><meta name="author" content=""><title>登陆页面</title><!-- Custom fonts for this template--><link href="/static/vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css"><link href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i"rel="stylesheet"><!-- Custom styles for this template--><link href="/static/css/sb-admin-2.min.css" rel="stylesheet"></head><style>.bg-gradient-primary {{#background: url("/static/img/小狗.jpg");#} background: url("/static/img/熊猫背景.jpg");background-position: center;background-size: cover;}.bg-login-image {background: url("/static/img/熊猫.jpg");background-position: center;background-size: cover;}body {margin: 10px;font-family: Nunito, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji";font-size: 1rem;font-weight: 400;line-height: 1.5;color: #858796;text-align: left;background-color: #fff;}h1 {text-align: center;color: black;margin-top: 15px;}
</style><body class="bg-gradient-primary"><div class="container"><!-- Outer Row --><div class="row justify-content-center"><div class="col-xl-10 col-lg-12 col-md-9"><h1>爱奇艺节目收视率可视化系统的设计与实现</h1><div class="card o-hidden border-0 shadow-lg my-5"><div class="card-body p-0"><!-- Nested Row within Card Body --><div class="row"><div class="col-lg-6 d-none d-lg-block bg-login-image"></div><div class="col-lg-6"><div class="p-5"><div class="text-center"><h1 class="h4 text-gray-900 mb-4">登陆</h1></div><form class="user" method="post" action="/login"><div class="form-group"><input type="email" name="email" class="form-control form-control-user"id="exampleInputEmail" aria-describedby="emailHelp"placeholder="请输入邮箱"></div><div class="form-group"><input type="password" name="password" class="form-control form-control-user"id="exampleInputPassword" placeholder="请输入密码"></div><div class="form-group"><div class="custom-control custom-checkbox small"><input type="checkbox" class="custom-control-input" id="customCheck"><label class="custom-control-label" for="customCheck">记住我</label></div></div><button href="index.html" class="btn btn-primary btn-user btn-block">登陆</button></form><hr><div class="text-center"><a class="small" href="/register">跳转到注册页面</a>&nbsp;&nbsp;</div></div></div></div></div></div></div></div></div></body></html>

from flask import Flask, request, render_template, session, redirect, jsonify
from utils import query
from utils.getHomeData import *
from utils.getComments_cData import *
from utils.getActor_tData import *
from utils.getRate_tData import *
from utils.getHotness import *
from utils.getCommentData import *
from utils.getType_tData import *
from utils.getLikes import *
from utils.getHotness_duibi import *
from utils.getHotness_yuyue import *
import reapp = Flask(__name__)
app.secret_key = 'This is secret_key you know ?'@app.route('/login', methods=['GET', 'POST'])
def login():if request.method == 'GET':return render_template('login.html')elif request.method == 'POST':request.form = dict(request.form)def filter_fn(item):return request.form['email'] in itemusers = query.querys('select * from user where email = %s', [request.form['email']], 'select')filter_list = list(filter(filter_fn, users))if len(filter_list):if request.form['password'] == filter_list[0][2]:session['email'] = request.form['email']return redirect('/home')# return render_template('error.html', message='登陆成功！')else:return render_template('error.html', message='密码错误！')else:return render_template('error.html', message='不存在该用户！')@app.route('/loginout')
def loginout():session.clear()return redirect('/login')@app.route('/register', methods=['GET', 'POST'])
def register():if request.method == 'GET':return render_template('register.html')elif request.method == 'POST':request.form = dict(request.form)if request.form['password'] != request.form['passwordChecked']:return render_template('error.html', message='两次密码不符合！')def filter_fn(item):return request.form['email'] in itemusers = query.querys('select * from user', [], 'select')filter_list = list(filter(filter_fn, users))if len(filter_list):return render_template('error.html', message='该用户已被注册！')else:query.querys('insert into user(email,password) values (%s,%s)',[request.form['email'], request.form['password']])return redirect('/login')@app.route('/home', methods=['GET', 'POST'])
def home():email = session.get('email')maxMovieLen, maxRate, maxCasts, maxHotness, maxTypes, maxComment = getHomeData()typeEcharData = getTypesEcharData()row, columns = getRateEcharData()return render_template('index.html',email=email,maxMovieLen=maxMovieLen,maxRate=maxRate,maxCasts=maxCasts,maxHotness=maxHotness,maxTypes=maxTypes,maxComment=maxComment,typeEcharData=typeEcharData,row=row,columns=columns,)# 预约热度
@app.route('/hotness_yuyue_t')
def hotness_yuyue_t():email = session.get('email')row, columns = getHotnessData_yuyueTop10()return render_template('hotness_yuyue_t.html',email=email,row=row,columns=columns,)# 热度top10
@app.route('/hotness_t')
def hotness_t():email = session.get('email')row, columns = getHotnessDataTop10()return render_template('hotness_t.html',email=email,row=row,columns=columns,)# 讨论数
@app.route('/comment_t')
def comment_t():email = session.get('email')rowCasts, columnsCasts = getCommentDataTop10()return render_template('comment_t.html',email=email,rowCasts=rowCasts,columnsCasts=columnsCasts)# 热度过万
@app.route('/likes_t')
def likes_t():email = session.get('email')rowCasts, columnsCasts = getLikesDataTop10()return render_template('likes_t.html',email=email,rowCasts=rowCasts,columnsCasts=columnsCasts)# 网剧和电视剧热度对比
@app.route('/hotness_duibi_t')
def hotness_duibi_t():email = session.get('email')wangju_data, dianshiju_data = getHotnessData_duibi()  # 假设这样返回数据row_wangju, columns_wangju = wangju_datarow_dianshiju, columns_dianshiju = dianshiju_data# 将网剧和电视剧的数据都传递给模板return render_template('hotness_duibi_t.html',email=email,wangju_titles=row_wangju,wangju_hotness=columns_wangju,dianshiju_titles=row_dianshiju,dianshiju_hotness=columns_dianshiju)# 评分
@app.route('/rate_t/<type>', methods=['GET', 'POST'])
def rate_t(type):email = session.get('email')typeList = getAllTypes()row, columns = getAllRateDataByType(type)return render_template('rate_t.html',email=email,typeList=typeList,type=type,row=row,columns=columns,)# 三大类型
@app.route('/type_t')
def type_t():email = session.get('email')typesData_dianshiju = getTypeData_dianshiju()typesData_zoyi = getTypeData_zoyi()typesData_wangju = getTypeData_wangju()return render_template('type_t.html',email=email,typesData_dianshiju=typesData_dianshiju,typesData_zoyi=typesData_zoyi,typesData_wangju=typesData_wangju,)# 导演、演员
@app.route('/actor_t')
def actor_t():email = session.get('email')row, columns = getDirectorsDataTop20()rowCasts, columnsCasts = getCastsDataTop20()return render_template('actor_t.html',email=email,row=row,columns=columns,rowCasts=rowCasts,columnsCasts=columnsCasts)# 评论词云图
@app.route('/comments_c', methods=['GET', 'POST'])
def comments_c():email = session.get('email')if request.method == 'GET':return render_template('comments_c.html', email=email)else:resSrc, searchName = getCommentsImage(dict(request.form)['searchIpt'])return render_template('comments_c.html', email=email, resSrc=resSrc, searchName=searchName)# 演员名词云图
@app.route('/casts_c', methods=['GET', 'POST'])
def casts_c():email = session.get('email')return render_template('casts_c.html', email=email)@app.route('/')
def allRequest():return redirect('/login')# 定义了一个 Flask 应用的全局前置请求处理器（before request handler）
# 它会在每次请求到达 Flask 应用之前运行
@app.before_request
def before_requre():# 定义一个正则表达式模式，匹配以 '/static' 开头的路径pat = re.compile(r'^/static')# 如果请求的路径匹配 '/static' 开头，则不进行后续的检查，直接返回# 这意味着静态文件的请求不会被后续的认证逻辑所拦截if re.search(pat, request.path):return# 如果请求的路径是 "/login"，同样不进行后续的检查，直接返回# 这允许用户直接访问登录页面，而不需要先登录if request.path == "/login":return# 如果请求的路径是 '/register'，同样不进行后续的检查，直接返回# 假设 '/register' 是注册页面的路径，允许用户直接访问注册页面if request.path == '/register':return# 尝试从 session 中获取用户的电子邮件地址email = session.get('email')# 如果 session 中存在电子邮件地址（即用户已登录）if email:# 则不进行任何操作，返回 None 表示继续处理该请求return None# 如果 session 中不存在电子邮件地址（即用户未登录）# 则重定向用户到登录页面 '/login'return redirect('/login')if __name__ == '__main__':app.run()