11周课后T1 使用pyecahrts完成课本P51编程T1

import pandas as pd
from pyecharts import options as opts     #导入pyecharts
from pyecharts.charts import Bar          #导入pyecharts.charts

data = pd.read_excel('成绩.xlsx',index_col=0)
data

#data数据显示

#画图
bar = (
    Bar(init_opts=opts.InitOpts(width="1000px",height="500px"))
    .add_xaxis(data.index.tolist())
    .add_yaxis("男生",data['男生'].tolist())
    .add_yaxis("女生",data['女生'].tolist())
    .set_global_opts(
        title_opts=opts.TitleOpts(title="高二男生、女生的平均成绩"),
        yaxis_opts=opts.AxisOpts(name="成绩",
                                name_location="center",
                                name_gap=40,
                                axislabel_opts={"rotate":30},
                                name_textstyle_opts=opts.TextStyleOpts(font_size=15)),
        xaxis_opts=opts.AxisOpts(name="科目",
                                name_location="center",
                                name_gap=40,
                                axislabel_opts={"rotate":30},
                                name_textstyle_opts=opts.TextStyleOpts(font_size=15)),
    )
    .render("高二男生女生的平均成绩.html")
)

#图像显示

 结果显示：高二男生女生的平均成绩.html