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")