python根据时间序列画折线图_pythonplotly制作接口响应耗时的时间序列表（TimeSeries）...

本人在做工作中，要对某一个接口的响应耗时进行一个长期的统计，由于之前的数据全都写在了数据库中，统计了半年多的数据。在学习了plotly的Time Series 时间序列图标之后，绘制了一张接口响应耗时的图标，分享代码，供大家参考。

下面是从数据库读取数据的java代码：

JSONObject data = new JSONObject();

ResultSet resultSet = MySqlTest.excuteQuerySql("SELECT DATE(create_time),AVG(elapsed_time) *1000 FROM request_record WHERE api_name in(\"/service/user/v3/login/mobile/v5\",\"/service/user/v3/login/mobile/v4\") GROUP BY DATE(create_time) ORDER BY DATE(create_time);");

while (resultSet.next()) {

String name = resultSet.getString(1);

double time = resultSet.getDouble(2);

data.put(name, time);

}

resultSet.close();

Save.saveJsonList(data, "apitime");

下面是读取文件的方法和生成表格的调用类的代码：

#!/usr/bin/python

# coding=utf-8

from first.date import DatePlot

class Fission:

x = []

y = []

z = []

def __init__(self):

print "欢迎使用fission类!"

def getData(self, name):

size = 0;

with open("/Users/Vicky/Documents/workspace/api_test/long/" + name + ".log") as apidata:

for i in apidata:

data = i.split("\r\n")[0]

time = float(data)

if time > 2: continue

self.z.append(data)

size += 1;

length = size;

for i in range(length):

self.x.append(name + "线程")

def getDataMarkLine(self, name):

with open("/Users/Vicky/Documents/workspace/api_test_najm/long/" + name + ".log") as apidata:

for i in apidata:

data = i.split("\r\n")[0].split("|")

day = data[0]

time = float(data[1])

self.x.append(day)

self.y.append(time)

return [self.x, self.y]

if __name__ == "__main__":

fission = Fission()

a = fission.getDataMarkLine("apitime")

DatePlot.MakePlot(a[0], a[1], "time")

下面是生成时间序列表的封装类（我保留了多条折现的方法以及注释了显示规定日期间隔数据的方法）：

#!/usr/bin/python

# coding=utf-8

import plotly.graph_objs as drive

import plotly.plotly

class DatePlot:

def __init__(self):

print "时间表格！"

@staticmethod

def MakePlot(x, y, titile):

a = drive.Scatter(

x=x,

y=y,

name="SSSSS",

line=dict(color='#17BECF'),

opacity=1

)

b = drive.Scatter(

x=["2016-02-20", "2016-02-21", "2016-02-23"],

y=[28.04, 20, 33],

name="AAAAA",

line=dict(color='#7F7F7F'),

opacity=0.8

)

data = [a]

layout = dict(

title=titile,

# xaxis=dict(

# range=['2018-07-01', '2018-07-20'])

)

fig = dict(data=data, layout=layout)

plotly.offline.plot(fig, filename=titile + ".html")

下面是效果图：

技术类文章精选

非技术文章精选

大咖风采

文章来源: www.oschina.net，作者：八音弦，版权归原作者所有，如需转载，请联系作者。

原文链接：https://my.oschina.net/u/3973795/blog/3120118