from pyecharts import options as optsfrom pyecharts.charts import Bar,Pie,Mapfrom pyecharts.faker import Fakerfrom linkdatabase import selectdatasql='SELECT 国家
,COUNT() FROM ww
GROUP BY 国家
HAVING COUNT()>10'data=selectdata(sql)xdata=[]ydata=[]for r in data: xdata.append(r[0]) ydata.append(r[1])print(xdata)print(ydata)def mybar(): c = ( Map() .add("五百强公司数", [list(z) for z in zip(Faker.country, Faker.values())], "world") .set_series_opts(label_opts=opts.LabelOpts(is_show=False)) .set_global_opts( title_opts=opts.TitleOpts(title="Map-世界地图"), visualmap_opts=opts.VisualMapOpts(max_=200), ) .render("map_world.html") )mybar()