1、添加了最高值，最低值，平均值

#-*- codeing = utf-8 -*-
#@Time : 
#@Auther : fangqm
#@File : Testfang.py
#@Software : PyCharm

#pyecharts画图
import pandas as pd
from pandas import notnull
from pyecharts import options as opts
import pyecharts.options as opt
from pyecharts.charts import Line
#pyecharts画图
#pyecharts画图
excel_data = pd.read_excel("新能源000941.xlsx")
(
    Line(init_opts=opt.InitOpts(width='1000px', 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(),
               markline_opts=opts.MarkLineOpts(
                   data=[opts.MarkLineItem(type_="max", name="最大值"),
                         opts.MarkLineItem(type_="min", name="最小值"),
                         opts.MarkLineItem(type_="average", name="平均值")]
               ),
               )
    .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='test',
            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("zhexian08.html")