1、销售数据可视化
import pandas as pd
from pyecharts.charts import *
from pyecharts import options as opts
df = pd.read_excel("D:\pycharm\pythonProject\day17/销售数据.xlsx")
title = Pie(init_opts=opts.InitOpts(chart_id='0'))
title.set_global_opts(title_opts=opts.TitleOpts("销售数据可视化大屏",
title_textstyle_opts=opts.TextStyleOpts(font_size=40),
pos_left='center'),
)
print(df.dtypes)
df["订单-年份"] = df["订单日期"].dt.year
df["订单-月份"] = df["订单日期"].dt.month
time_sale = pd.pivot_table(
data=df,
index="订单-月份",
columns="订单-年份",
values="利润",
aggfunc='sum'
)
print(time_sale)
line = Line(init_opts=opts.InitOpts(chart_id='1'))
line.add_xaxis(time_sale.index.astype(str).tolist())
for col in time_sale.columns:
line.add_yaxis(
series_name=str(col),
y_axis