https://github.com/hxy-111/flask_douban
笔记
import pandas as pd
from flask import Flask, render_template
from pyecharts import options as opts
from pyecharts.charts import Bar, Line, Bar3D, Timeline, Page
from pyecharts.commons.utils import JsCode
from pyecharts.components import Table
from pyecharts.globals import CurrentConfig
from jinja2 import Markup, Environment, FileSystemLoader
import time
import os
import csv
import zipfile
import tarfile
class Pic:
def __init__(self, filename, title):
self.filename = filename
self.title = title
self.cell = []
self.rnti = []
self.total = 0
self.out_of_range = []
self.df = pd.read_csv(self.filename)
self.df = self.df.sort_values(by=['Time', 'RNTI'], ascending=[True, True])
self.rnti = self.df['RNTI'].unique().tolist()
self.cell = self.df['CellId'].unique().tolist()
groups = self.df.groupby(self.df.CellId)
self.frame = []
for i in range(len(self.cell)):
self.frame.append(groups.get_group(self.cell[i]))
def zip_process(self, folder):
print('解压中')
zip_obj = zipfile.ZipFile(self.filename)
zip_obj.extractall(folder)
zip_obj.close()
for file in os.listdir(folder):
print(file)
file = folder + '/' + file
if tarfile.is_tarfile(file):
tar_obj = tarfile.open(file)
tar_obj.extractall(folder)
tar_obj.close()
break
for dir in os.listdir(folder):
if 'lsugetreport' in dir and '.tar' not in dir:
self.lsugetreport = folder + '/' + dir
print('解压完成')
def read_data(self, frame):
rnti_list = frame['RNTI'].values.tolist()
rnti = frame['RNTI'].unique().tolist()
time_list = frame['Time'].values.tolist()
data_list = frame[self.title].values.tolist()
padding = [[None for i in range(len(data_list))] for i in range(len(rnti))] # 为所有点赋None值
for i in range(len(data_list)):
if data_list[i] != 'invalid':
padding[rnti.index(rnti_list[i])][time_list.index(time_list[i])] = float(data_list[i]) # 有数值点赋值
avg_list = []
small_pad = []
small_rnti = []
for i in range(len(padding)):
full_data = list(filter(None, padding[i]))
try:
avg = sum(full_data)/len(full_data)
avg = float(format(avg, '.1f'))
avg_list.append(avg)
for j in padding[i]:
if j is None or j == 'invalid':
continue
else:
j = float(format(j, '.1f'))
# if abs(float(j) - avg) / avg > 0.4:
if abs(float(j) - avg) > 5:
# percent = str(float(format(abs(float(j) - avg), '.2f'))*100) + '%'
percent = float(format(abs(float(j) - avg), '.2f'))
self.out_of_range.append([rnti_list[i], time_list[padding[i].index(j)], j, avg, percent])
if len(small_rnti) > 0 and small_rnti[-1] == rnti[i]:
pass
else:
small_pad.append(padding[i])
small_rnti.append(rnti[i])
self.csv_out(self.out_of_range, ['RNTI', 'Time', 'Data', 'Avg', 'OutPercent'], 'error/error' + str(time.time()) + '.csv')
except ZeroDivisionError:
pass
return [time_list, small_pad, small_rnti]
def csv_out(self, out_list, head, filename):
with open(filename, 'w', newline="") as f:
writer = csv.writer(f, delimiter=",")
writer.writerow(head)
writer.writerows(out_list)
def data_filter(self):
for i in self.frame:
self.read_data(self.frame[0])
def line_base(self):
# js_formatter = """function (params) {
# console.log(params);
# return 'THROUGHPUT ' +
# params.value + (params.seriesData.length ? '：' + params.seriesData[0].data : '');
# }"""
data = self.read_data(self.frame[0])
l1 = (
Line()
.add_xaxis(xaxis_data=data[0])
.set_global_opts(
legend_opts=opts.LegendOpts(),
axispointer_opts=opts.AxisPointerOpts(is_show=True, link=[{"xAxisIndex": "all"}]),
tooltip_opts=opts.TooltipOpts(trigger="axis", axis_pointer_type="cross"),
toolbox_opts=opts.ToolboxOpts(is_show=True),
xaxis_opts=opts.AxisOpts(type_="category", boundary_gap=False),
)
)
for i in range(len(data[2])):
l1.add_yaxis(series_name=str(data[2][i]),
symbol="emptyCircle",
is_symbol_show=False,
is_connect_nones=True,
y_axis=data[1][i],
label_opts=opts.LabelOpts(is_show=False),
)
l1.render("throughput.html")
return l1
def table_base(self):
table = Table()
headers = ['RNTI', 'Time', 'Data', 'Avg', 'OutPercent']
table.add(headers, self.out_of_range).set_global_opts(title_opts=opts.ComponentTitleOpts(title="异常点"))
return table
Copy
from flask import Flask, render_template
from pyecharts.charts import Bar, Line, Bar3D, Timeline, Page
from pyecharts.globals import CurrentConfig
from jinja2 import Markup, Environment, FileSystemLoader
import chart
# CurrentConfig.GLOBAL_ENV = Environment(loader=FileSystemLoader("./static/js/"))
CurrentConfig.ONLINE_HOST = "static/js/"
app = Flask(__name__, static_folder="static")
@app.route("/ulmcs")
def page_simple_layout0():
# a = chart.Pic('32ul/UE_MAC_THROUGHPUT_20220527112639426.csv', 'ulMACThroughput(Mbps)')
a = chart.Pic('32ul/UE_AVG_MCS_20220527112624464.csv', 'UeUlAvgMCS')
page = Page(layout=Page.SimplePageLayout)
page.add(
a.line_base(),
a.table_base(),
)
return Markup(page.render_embed())
@app.route('/ulbler')
def page_simple_layout():
# a = chart.Pic('32ul/UE_MAC_THROUGHPUT_20220527112639426.csv', 'ulMACThroughput(Mbps)')
a = chart.Pic('32ul/UE_AVG_MCS_20220527112624464.csv', 'UeUlAvgMCS')
page = Page(layout=Page.SimplePageLayout)
page.add(
a.line_base(),
a.table_base(),
)
return Markup(page.render_embed())
# @app.route("/dl")
# def page_simple_layout0():
# a = chart.Pic('32ul/UE_MAC_THROUGHPUT_20220527112639426.csv', 'ulMACThroughput(Mbps)')
# page = Page(layout=Page.SimplePageLayout)
# page.add(
# a.line_base(),
# a.table_base(),
# )
# return Markup(page.render_embed())
@app.route("/")
def index():
return render_template('login.html')
if __name__ == "__main__":
app.run('0.0.0.0', 5000, debug=True)
# app.run()
Copy
"Time","Sequence","gNB ID","Cell ID","CpfUeId","RNTI","CpId","RecordId","TaskId","PLMN","Drive Test User Type","CellDlAvgMCS","CellUlAvgMCS"
" 2022-08-09 10:59:00 950","389546","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:00 950","389411","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 10:59:01 950","393817","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 10:59:01 970","393952","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:02 950","398223","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.8"
" 2022-08-09 10:59:02 950","398358","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:03 970","402629","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.8"
" 2022-08-09 10:59:03 970","402764","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:04 950","407035","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 10:59:04 960","407170","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:05 950","411576","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:05 950","411441","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 10:59:06 950","415847","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.6"
" 2022-08-09 10:59:06 970","415982","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:07 950","420253","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 10:59:07 950","420388","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:08 970","424659","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 10:59:08 970","424794","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:09 950","429065","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.6"
" 2022-08-09 10:59:09 960","429200","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:10 950","433471","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.6"
" 2022-08-09 10:59:10 950","433606","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:11 950","437877","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 10:59:11 970","438012","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:12 950","442283","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.6"
" 2022-08-09 10:59:12 950","442418","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:13 970","446689","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 10:59:13 970","446824","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:14 950","451095","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 10:59:14 960","451230","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:15 950","455636","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:15 950","455501","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 10:59:16 950","459907","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.5"
" 2022-08-09 10:59:16 970","460042","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:17 950","464313","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 10:59:17 950","464448","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:18 970","468719","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 10:59:18 970","468854","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:19 950","473125","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.8"
" 2022-08-09 10:59:19 960","473260","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:20 950","477531","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.8"
" 2022-08-09 10:59:20 950","477666","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:21 950","481937","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 10:59:21 970","482072","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:22 950","486343","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 10:59:22 950","486478","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:23 970","490749","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 10:59:23 970","490884","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:24 950","495155","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 10:59:24 960","495290","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:25 950","499696","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:25 950","499561","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.8"
" 2022-08-09 10:59:26 950","503967","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.8"
" 2022-08-09 10:59:26 970","504102","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:27 950","508373","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.8"
" 2022-08-09 10:59:27 950","508508","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:28 970","512779","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 10:59:28 970","512914","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:29 950","517185","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.6"
" 2022-08-09 10:59:29 960","517320","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:30 950","521726","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:30 950","521591","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 10:59:31 950","525997","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.8"
" 2022-08-09 10:59:31 970","526132","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:32 950","530403","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 10:59:32 950","530538","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:33 970","534809","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.9"
" 2022-08-09 10:59:33 970","534944","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:34 950","539215","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.8"
" 2022-08-09 10:59:34 960","539350","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:35 950","543621","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.9"
" 2022-08-09 10:59:35 950","543756","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:36 950","548027","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.8"
" 2022-08-09 10:59:36 970","548162","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:37 950","552433","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.9"
" 2022-08-09 10:59:37 950","552568","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:38 970","556839","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.8"
" 2022-08-09 10:59:38 970","556974","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:39 950","561245","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.8"
" 2022-08-09 10:59:39 960","561380","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:40 950","565651","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 10:59:40 950","565786","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:41 950","570057","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 10:59:41 970","570192","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:42 950","574598","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:42 950","574463","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.8"
" 2022-08-09 10:59:43 970","579004","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:43 970","578869","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 10:59:44 950","583275","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 10:59:44 960","583410","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:45 950","587681","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.6"
" 2022-08-09 10:59:45 950","587816","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:46 950","592087","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 10:59:46 970","592222","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:47 950","596493","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 10:59:47 950","596628","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:48 970","601034","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:48 970","600899","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 10:59:49 950","605305","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.8"
" 2022-08-09 10:59:49 960","605440","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:50 950","609711","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.8"
" 2022-08-09 10:59:50 950","609846","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:51 950","614117","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 10:59:51 970","614252","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:52 950","618523","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 10:59:52 950","618658","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:53 970","622929","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.6"
" 2022-08-09 10:59:53 970","623064","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:54 950","627335","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 10:59:54 960","627470","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:55 950","631876","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:55 950","631741","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 10:59:56 950","636147","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 10:59:56 970","636282","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:57 950","640553","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 10:59:57 950","640688","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 10:59:58 970","644959","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 10:59:58 970","645094","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 10:59:59 950","649365","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.8"
" 2022-08-09 10:59:59 960","649500","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:00 950","653771","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 11:00:00 950","653906","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:01 950","658177","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.8"
" 2022-08-09 11:00:01 970","658312","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:02 950","662583","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 11:00:02 950","662718","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:03 970","667124","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:03 970","666989","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 11:00:04 950","671395","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 11:00:04 960","671530","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:05 950","675801","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 11:00:05 950","675936","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:06 950","680207","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 11:00:06 970","680342","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:07 950","684613","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 11:00:07 950","684748","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:08 970","689019","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 11:00:08 970","689154","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:09 950","693425","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.8"
" 2022-08-09 11:00:09 960","693560","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:10 950","697831","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 11:00:10 950","697966","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:11 950","702237","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 11:00:11 970","702372","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:12 950","706643","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 11:00:12 950","706778","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:13 970","711184","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:13 970","711049","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 11:00:14 950","715455","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.8"
" 2022-08-09 11:00:14 960","715590","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:15 950","719861","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.9"
" 2022-08-09 11:00:15 950","719996","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:16 950","724267","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 11:00:16 970","724402","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:17 950","728808","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:17 950","728673","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 11:00:18 970","733214","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:18 970","733079","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 11:00:19 950","737485","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.8"
" 2022-08-09 11:00:19 960","737620","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:20 950","741891","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 11:00:20 950","742026","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:21 950","746297","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 11:00:21 970","746432","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:22 950","750703","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.8"
" 2022-08-09 11:00:22 950","750838","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:23 970","755109","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.6"
" 2022-08-09 11:00:23 970","755244","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:24 950","759515","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 11:00:24 960","759650","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:25 950","763921","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 11:00:25 950","764056","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:26 950","768327","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 11:00:26 970","768462","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:27 950","772733","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 11:00:27 950","772868","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:28 970","777139","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.5"
" 2022-08-09 11:00:28 970","777274","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:29 950","781545","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.6"
" 2022-08-09 11:00:29 960","781680","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:30 950","785951","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.8"
" 2022-08-09 11:00:30 950","786086","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:31 950","790357","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.6"
" 2022-08-09 11:00:31 970","790492","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:32 950","794763","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 11:00:32 950","794898","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:33 970","799169","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.9"
" 2022-08-09 11:00:33 970","799304","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:34 950","803575","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.9"
" 2022-08-09 11:00:34 960","803710","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:35 950","807981","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 11:00:35 950","808116","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:36 950","812387","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.6"
" 2022-08-09 11:00:36 970","812522","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:37 950","816793","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 11:00:37 950","816928","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:38 970","821334","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:38 970","821199","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 11:00:39 950","825605","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.8"
" 2022-08-09 11:00:39 960","825740","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:40 950","830146","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:40 950","830011","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 11:00:41 950","834417","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 11:00:41 970","834552","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:42 950","838958","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:42 950","838823","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.8"
" 2022-08-09 11:00:43 970","843229","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.8"
" 2022-08-09 11:00:43 970","843364","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:44 950","847635","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.8"
" 2022-08-09 11:00:44 960","847770","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:45 950","852176","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:45 950","852041","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 11:00:46 950","856447","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.8"
" 2022-08-09 11:00:46 970","856582","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:47 950","860988","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:47 950","860853","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 11:00:48 970","865394","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:48 970","865259","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 11:00:49 950","869665","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 11:00:49 960","869800","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:50 950","874206","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:50 950","874071","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.8"
" 2022-08-09 11:00:51 950","878477","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 11:00:51 970","878612","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:52 950","882883","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 11:00:52 950","883018","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:53 970","887424","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:53 970","887289","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.6"
" 2022-08-09 11:00:54 950","891695","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 11:00:54 960","891830","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:55 950","896101","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.8"
" 2022-08-09 11:00:55 950","896236","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","invalid"
" 2022-08-09 11:00:56 950","900507","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","27.9","8.7"
" 2022-08-09 11:00:56 970","900642","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:57 950","904913","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.6"
" 2022-08-09 11:00:57 950","905048","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:58 970","909319","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.5"
" 2022-08-09 11:00:58 970","909454","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"
" 2022-08-09 11:00:59 950","913725","22247","1","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","8.7"
" 2022-08-09 11:00:59 960","913860","22247","2","4294967295","65535","0","0xffffffffffffffff","1879048193","46011","invalid","28.0","invalid"