Pandas模块使用 将数据库数据图形化显示趋势

import pandas as pd
import pymysql
import matplotlib.pyplot as plt
conn = pymysql.connect(“host”, “user”, “passwd”, “databases”)

读取数据库表数据

data = pd.read_sql(“select * from NB”, con=conn)

数据转化为列表

d = list(data.id)

x = []
y = []
z = []

这里是将数据等比例缩小 数据太大折线图不容易显示

q = list(data.time)
for i in q:
o = float(i)
l = o / 1000000000
x.append(l)

w = list(data.input)
for i in w:
u = int(i)
k = u / 1000000000 - 60500
y.append(k)

e = list(data.output)
for i in e:
u = int(i)
n = u / 10000000000 - 10800
z.append(n)

设置折线样式

plt.plot(d, y, “g–”)
plt.plot(d, z, “r–”)
plt.plot(d, x, “k–”)

设置x坐标轴的范围

plt.xlim(0, 400)
plt.ylim(0, 120)

设置X轴文字的标题

plt.xlabel(“id”)

设置Y轴文字的标题

plt.ylabel(“input&output”)

设置图表的标题

plt.title(“input & output table”)

plt.show()
print(“time数据”, len(x) , “input数据”, len(y) , “output数据”, len(z))
conn.close()