python读取mysql数据绘制条形图

时间:2021-05-22

本文实例为大家分享了python读取mysql数据绘制条形图的具体代码,供大家参考,具体内容如下

Mysql 脚本示例:

create table demo( id int,product varchar(50),price decimal(18,2),quantity int,amount decimal(18,2),orderdate datetime);insert into demoselect 1,'AAA',15.2,5,76,'2017-09-09' union allselect 2,'BBB',10,6,60,'2016-05-18' union allselect 3,'CCC',21,11,231,'2014-07-11' union allselect 4,'DDD',55,2,110,'2016-12-24' union allselect 5,'EEE',20,4,80,'2017-02-08' union allselect 6,'FFF',45,2,90,'2016-08-19' union allselect 7,'GGG',33,5,165,'2017-10-11' union allselect 8,'HHH',5,40,200,'2014-08-30' union allselect 9,'III',3,20,60,'2015-02-25' union allselect 10,'JJJ',10,15,150,'2015-11-02';

python 绘图分析:

# -*- coding: utf-8 -*-#import numpyimport MySQLdbimport plotly.plotlyimport plotly.graph_objs as pg host = "localhost"port = 3306user = "root"passwd = "mysql"charset = "utf8"dbname = "test"conn = None try: conn = MySQLdb.Connection( host = host, port = port, user = user, passwd = passwd, db = dbname, charset = charset ) cur = conn.cursor(MySQLdb.cursors.DictCursor) cur.execute("select * from demo;") rows = cur.fetchall() #rows = numpy.array(rows) lists = [[],[],[],[]] for row in rows: lists[0].append(row["product"]) lists[1].append(row["price"]) lists[2].append(row["quantity"]) lists[3].append(row["amount"]) #print(lists) #print(lists[0]) #print(([x[0] for x in lists])) date_price = pg.Bar( x=lists[0], y=lists[1], name='价格') date_quantity = pg.Bar( x=lists[0], y=lists[2], name='数量') date_amount = pg.Bar( x=lists[0], y=lists[3], name='总价') data = [date_price, date_quantity, date_amount] #barmode = [stack,group,overlay,relative] layout = pg.Layout( barmode='group',title="各产品销售情况" ) fig = pg.Figure(data=data, layout=layout) plotly.offline.plot(fig, filename = "C:/Users/huangzecheng/Desktop/test.html") finally: if conn: conn.close()

将代码保存为文件 bartest.py ,执行脚本 pythonbartest.py ,生成 html 文件如下:

以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持。

声明:本页内容来源网络,仅供用户参考;我单位不保证亦不表示资料全面及准确无误,也不保证亦不表示这些资料为最新信息,如因任何原因,本网内容或者用户因倚赖本网内容造成任何损失或损害,我单位将不会负任何法律责任。如涉及版权问题,请提交至online#300.cn邮箱联系删除。

相关文章