基于excel数据绘制饼图

基于excel数据绘制饼图

# 导入库
import openpyxl
from pyecharts.charts import Bar,Pie
from pyecharts import options

# 1.导入数据
wb = openpyxl.open("files/data1.xlsx")
sheet =wb.active
# 经验要求
data = {}
m_r = sheet.max_row
m_c = sheet.max_column
for x in range(2,m_r+1):
    value = sheet.cell(x, 7).value
    if value not in data:
        data[value] = 1
    else:
        data[value] += 1

# 构建饼图
pie_data =[]
for x in data:
    pie_data.append((x, data[x]))

# 2.制作图表
# 1)构建饼图并配置
pie = Pie()
pie.add(
    "数据分析岗位经验要求",
    pie_data,
    radius=("20%",'80%'),
    rosetype='radius'
        )
pie.set_global_opts(
    legend_opts=options.LegendOpts(
        is_show=False,
    ),
    title_opts=options.TitleOpts(
        title="数据分析工作岗位经验要求",
        pos_left="350",
    )
)
pie.set_series_opts(
    label_opts=options.LabelOpts(
        formatter='{b}: {d}%'
    )
)
# 3.渲染
pie.render("files/经验要求饼图.html")

展示成果