《Python数据可视化之Matplotlib与Pyecharts》之条形图
《Python数据可视化之Matplotlib与Pyecharts》之条形图
为了分析该企业在各省市商品订单数量,绘制了各个省市商品订单量的条形图,Python代码如下:
# -*- coding: utf-8 -*-
#声明Notebook类型,必须在引入pyecharts.charts等模块前声明
from pyecharts.globals import CurrentConfig, NotebookType
CurrentConfig.NOTEBOOK_TYPE = NotebookType.JUPYTER_LAB
from pyecharts import options as opts
from pyecharts.charts import Bar, Page
from impala.dbapi import connect
#提取Hadoop集群数据
v1 = []
v2 = []
conn = connect(host='192.168.1.7', port=10000, database='sales',auth_mechanism='NOSASL', user='root')
cur = conn.cursor()
sql_num = "select province,count(cust_id) from orders group by province"
cur.execute(sql_num)
sh = cur.fetchall()
for s i