python对excel数据可视化 plotly_Python利用Plotly实现对MySQL中的数据可视化

Mysql表数据：

demo.sql内容

create table demo(

id int

,product varchar(50)

,price decimal(18,2)

,quantity int

,amount decimal(18,2)

,orderdate datetime

);

insert into demo

select 1,'AAA',15.2,5,76,'2017-09-09' union all

select 2,'BBB',10,6,60,'2016-05-18' union all

select 3,'CCC',21,11,231,'2014-07-11' union all

select 4,'DDD',55,2,110,'2016-12-24' union all

select 5,'EEE',20,4,80,'2017-02-08' union all

select 6,'FFF',45,2,90,'2016-08-19' union all

select 7,'GGG',33,5,165,'2017-10-11' union all

select 8,'HHH',5,40,200,&