Hadoop豆瓣电影分析可视化源码

# -*- coding : utf-8 -*- # @Time : 2021/1/7 17:42 # @author : 王小王 # @Software : PyCharm # @File : 前10名电影类型评分.py # @CSDN : https://blog.csdn.net/weixin_47723732 from pyecharts import options as opts from pyecharts.charts import Bar from pyecharts.commons.utils import JsCode import pymysql conn = pymysql.connect( host='localhost', user='root', password='2211', database='jiaoxue', port=3306, charset='utf8' ) cur = conn.cursor() sql = "select typle as `类型`,ROUND(AVG(grade),2) as`平均评分` from `data` GROUP BY `类型` ORDER BY `平均评分` DESC LIMIT 10;" cur.execute(sql) data = cur.fetchall() a=[] b=[] for x in data: a.append(x[0]) for i in data: b.append(i[1]) conn.close() c = ( Bar() .add_xaxis(a) .add_yaxis("平均评分", b, category_gap="60%")#Y轴标签 .set_series_opts( itemstyle_opts={ "normal": { "color": JsCode( """new echarts.graphic.LinearGradient(0, 0, 0, 1, [{ offset: 0, color: 'rgba(0, 244, 255, 1)' }, { offset: 1, color: 'rgba(0, 77, 167, 1)' }], false)""" ), "barBorderRadius": [30, 30, 30, 30], "shadowColor": "rgb(0, 160, 221)", } } ) .set_global_opts(title_opts=opts.TitleOpts(title="综合评分前10名电影类型分析")) .render("综合评分前10名电影类型分析.html") ) print("请查收！")