# -*- codeing = utf-8 -*- # @Time : 11/3 9:59 # @Author : River # @File : mycharts.py # @Software : PyCharm from pyecharts import Pie from Include.commons.common import Common if __name__ == '__main__': common = Common() results = common.queryData( """select count(*) from bra where bra_size like '%A' union all select count(*) from bra where bra_size like '%B' union all select count(*) from bra where bra_size like '%C' union all select count(*) from bra where bra_size like '%D' union all select count(*) from bra where bra_size like '%E' union all select count(*) from bra where bra_size like '%F' union all select count(*) from bra where bra_size like '%G'""" ) # 获取每个罩杯数量 attr = ["A罩杯", 'G罩杯', "B罩杯", "C罩杯", "D罩杯", "E罩杯", "F罩杯"] v1 = [ results[0][0], results[6][0], results[1][0], results[2][0], results[3][0], results[4][0], results[5][0] ] pie = Pie("内衣罩杯", width=1300, height=620) pie.add("", attr, v1, is_label_show=True) pie.render('size.html') print('success') results = common.queryData(
# encoding: utf-8 # author zww from pyecharts import Radar from Include.commons.common import Common if __name__ == '__main__': common = Common() results = common.queryData("select * from squad") #获取四排战绩 # 初始化雷达图 schema = [("KD", 1.6), ("吃鸡率", 6), ("Top10", 45), ("场均伤害", 220), ("最多击杀", 9), ("爆头率", 35)] radar = Radar(width=1300, height=620) radar.config(schema) # 设置样例颜色 range_color = [ '#313695', '#a50026', '#74add1', '#fdae61', '#e0f3f8', '#ffffbf', '#fee090', '#f46d43' ] index = 0 for result in results: data = [[ str(result[3]), str(result[4]), str(result[5]), str(result[6]), str(result[8]), str(result[9]) ]] radar.add(result[2], data, item_color=range_color[index])