11.7.2 不同类型商品销售情况分析
为了分析该企业不同类型商品的销售额情况,绘制了不同商品销售额的主题河流图,Python代码如下:
# -*- coding: utf-8 -*-
# -*- 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 Page, ThemeRiver
from impala.dbapi import connect
#连接Hadoop数据库
conn = connect(host='192.168.1.7', port=10000, database='sales',auth_mechanism='NOSASL',user='root')
cursor = conn.cursor()
#读取Hadoop表数据
sql_num = "SELECT order_date,ROUND(SUM(sales),2),category FROM orders WHERE order_date>='2019-10-01' and order_date<='2019-10-3