问题遇到的现象和发生背景
用pyechrts无法显示数据,复制官网的代码,只有数据改成了自己的,最后只能显示坐标轴但是没有数据
问题相关代码,请勿粘贴截图
from flask import Blueprint, render_template,Request
import pandas as pd
from pyecharts.charts import Line
from pyecharts import options as opts
import json
bp=Blueprint("干旱",name,url_prefix="/drought")
data={}
#category1=[]
#value=[]
io=r'C:\Users\86137\Desktop\python\统计.xlsx'
work_book = pd.read_excel(io,sheet_name=0,header=0,index_col=[0],usecols=[0,1,2,3,4,5,6,7],skiprows=[range(1,43)])
category1=work_book.index.to_list()
value1 = work_book.values.tolist()
L=(
Line(init_opts=opts.InitOpts(width="1680px", height="800px"))
.add_xaxis(xaxis_data=category1)
.add_yaxis(
series_name="",
y_axis=[value2[6] for value2 in value1],
yaxis_index=0,
is_smooth=True,
is_symbol_show=False,
)
.set_global_opts(
title_opts=opts.TitleOpts(title="Beijing AQI"),
tooltip_opts=opts.TooltipOpts(trigger="axis"),
datazoom_opts=[
opts.DataZoomOpts(yaxis_index=0),
opts.DataZoomOpts(type_="inside", yaxis_index=0),
],
visualmap_opts=opts.VisualMapOpts(
pos_top="10",
pos_right="10",
is_piecewise=True,
out_of_range={"color": "#999"},
),
xaxis_opts=opts.AxisOpts(type_="category"),
yaxis_opts=opts.AxisOpts(
type_="value",
name_location="start",
min_=0,
max_=500,
is_scale=True,
axistick_opts=opts.AxisTickOpts(is_inside=False),
),
)
.render("beijing_aqi.html")
)
运行结果及报错内容
我的解答思路和尝试过的方法
以为是pandas导出数据的类型问题,但是发现已经是列表的,不知道哪里错了