1、excel表格类型

2、pyecharts代码

import pandas as pd
from pyecharts import options as opts
import pyecharts.options as opt
from pyecharts.charts import Line

//读取excel表格
excel_data = pd.read_excel("白酒.xls")
(
    Line(init_opts=opt.InitOpts(width='1500px', height='400px'))
    .add_xaxis(xaxis_data=excel_data["date"].tolist())
    .add_yaxis(series_name='北京', y_axis=excel_data["end"].tolist())
    .add_yaxis(series_name='上海', y_axis=excel_data["rate"].tolist())
    .set_global_opts(
        xaxis_opts=opts.AxisOpts(
            name='行业',
            name_location='middle',
            name_gap=20,
            #                 x轴名称的格式配置
            name_textstyle_opts=opts.TextStyleOpts(
                font_family='Times New Roman',
                font_size=14,
            ),
        ),
        yaxis_opts=opts.AxisOpts(
            name='淘汰公司总数',
            name_location='middle',
            name_gap=30,
            name_textstyle_opts=opts.TextStyleOpts(
                font_family='Times New Roman',
                font_size=14,
            ),
            axistick_opts=opts.AxisTickOpts(
                is_inside=True,  # 刻度线是否在内侧
            ),
            axislabel_opts=opts.LabelOpts(
                font_size=12,
                font_family='Times New Roman',
            ),
        ),

    )
).render("zhexian.html")