python读取mysql数据绘制条形图
作者:薛定谔的DBA 时间:2024-01-26 16:15:07
本文实例为大家分享了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 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,'2014-08-30' union all
select 9,'III',3,20,60,'2015-02-25' union all
select 10,'JJJ',10,15,150,'2015-11-02';
python 绘图分析:
# -*- coding: utf-8 -*-
#import numpy
import MySQLdb
import plotly.plotly
import plotly.graph_objs as pg
host = "localhost"
port = 3306
user = "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 ,执行脚本 python bartest.py ,生成 html 文件如下:
来源:https://blog.csdn.net/kk185800961/article/details/78593466
标签:python,条形图


猜你喜欢
python读取配置文件方式(ini、yaml、xml)
2022-10-12 05:07:29
微信小程序 调用微信授权窗口相关问题解决
2024-04-18 10:08:44

python中dir函数用法分析
2023-09-05 10:23:09
Python进阶篇之正则表达式常用语法总结
2022-03-27 08:45:18

python使用PyFetion来发送短信的例子
2022-08-22 09:43:54
学用代码片段
2011-09-06 19:37:35
使用MyISAM表和InnoDB的一些记录
2009-12-20 18:21:00
Python实现针对中文排序的方法
2022-04-20 23:21:51
PHP后台实现微信小程序登录
2024-03-14 22:17:25

在Python的Tornado框架中实现简单的在线代理的教程
2021-12-31 08:51:39
Dreamweaver使用技巧--让css使网页图片半透明
2010-09-05 21:13:00

Python中如何替换字典中的值
2022-10-04 21:21:35
IDEA连接不上MySQL端口号占用的解决
2024-01-24 14:49:21

vue父子组件的互相传值和调用
2024-04-09 10:47:51
分享一个pycharm专业版安装的永久使用方法
2023-04-27 17:26:34

Python必须了解的35个关键词
2023-05-20 07:37:33
数字人组件反写[asp组件开发实例3]
2009-06-09 13:16:00

学习python处理python编码问题
2022-06-23 22:18:42
Python抓取移动App数据使用mitmweb监听请求与响应
2022-03-24 21:09:29

python机器学习混淆矩阵及confusion matrix函数使用
2023-03-08 18:14:12
