\[\]
根据给定数据绘图,编写pyECharts代码如下所示:
code.python
import pandas as pd
from pyecharts.charts import Bar
from pyecharts import options as opts
df=pd.read_excel('07 销售收入.xlsx',engine='openpyxl',index_col=0)
categories = df.index.tolist() # 索引列作为横轴
# 1. 创建简单柱状图
bar = Bar()
bar.add_xaxis(categories)
# 2. 动态添加所有数据系列
for col in df.columns[0:]: # 从第1列开始
bar.add_yaxis('', df[col].tolist())
# 3. 配置图表
bar.set_global_opts(
title_opts=opts.TitleOpts(title="简单柱状图添加数据标签"),
toolbox_opts=opts.ToolboxOpts())
bar.set_series_opts(
label_opts=opts.LabelOpts(is_show=True),
markpoint_opts=opts.MarkPointOpts(
data=[
opts.MarkPointItem(type_="max", name="最大值"),
opts.MarkPointItem(type_="min", name="最小值"),
opts.MarkPointItem(type_="average", name="平均值"),
]
))
bar.render("barLabels.html")
运行代码,生成下图。
\[\]