def get_df(self):
tickets_list = ["时间",
"机组运行模式",
"液压系统压力",
"液压泵1开",
"液压泵2开",
"顺时针偏航",
"逆时针偏航",
"偏航制动出口压力1",
"偏航制动出口压力2",
"偏航制动入口压力1",
"偏航制动入口压力2",
"偏航半释放阀",
"液压主泵处油温",
"液压泵出口压力",
"液压回油口油温",
"叶轮锁定压力1",
"叶轮锁定压力2",
"叶轮锁蓄能器压力1",
"叶轮锁蓄能器压力2"
]
self.project_name = str(os.path.basename(gl.now_file)).split(".")[-2].split("_")[0][:5]
self.tickets = cores.get_en_tickets("../db/tickets.my", self.project_name, tickets_list)
# self.tickets = [li[1] is not None for li in self.tickets]
for li in self.tickets:
if li is not None:
self.tickets[self.tickets.index(li)] = li[1]
else:
self.tickets[self.tickets.index(li)] = False
if gl.df is None:
self.df = cores.read_csv(gl.now_file, tickets_list)
self.df.insert(0, "time", pd.to_datetime(self.df[self.tickets[0]]))
else:
self.df = gl.df
def read_df(self):
# # # 拿到file和tickets
file = self.data["file_name"]
self.tickets = [i for i in self.data["y_tickets"]]
self.tickets.append(self.data["x_ticket"])
# # # 拿到英文标签，与中文标签对应
project_name = str(
os.path.basename(file)).split(".")[-2].split("_")[0][:5]
self.en = cores.get_en_tickets("../db/tickets.my", project_name,
self.tickets)
for index, li in zip(range(len(self.en)), self.en):
if li is not None:
self.en[index] = li[1]
else:
self.en[index] = False
self.df = cores.read_csv(file=file, tickets=self.tickets)
if "时间" in self.tickets:
index = self.tickets.index("时间")
self.df[self.en[index]] = self.df[self.en[index]].apply(
lambda x: time.mktime(time.strptime(x, '%Y-%m-%d %H:%M:%S')))
self.df["time"] = self.df[self.en[index]].map(
lambda x: pd.Timestamp(x, unit="s"))
self.df.set_index("time", inplace=True)
self.df = self.df.resample("%ds" % self.r_s).mean()
else:
self.df["time"] = pd.date_range('1/1/2021 0:00:00',
freq='S',
periods=self.df.shape[0])
self.df.set_index("time", inplace=True)
self.df = self.df.resample("%ds" % self.r_s).mean()
self.df.set_index(self.en[-1], inplace=True)
self.y_number = len(self.tickets[:-1])
def get_df(self):
tickets_list = [
"时间", "机组运行模式", "变频器主机igbt温度", "变频器从机igbt温度", "变流器发电机转速", "叶轮速度2",
"变频器主机冷却液温度", "变频器主机风扇运行1", "变频器主机水泵运行", "变频器从机冷却液温度",
"变频器从机风扇运行1", "变频器从机水泵运行", "变频器主机冷却液压力", "变频器从机冷却液压力"
]
self.project_name = str(os.path.basename(
gl.now_file)).split(".")[-2].split("_")[0][:5]
self.tickets = cores.get_en_tickets("../db/tickets.my",
self.project_name, tickets_list)
# self.tickets = [li[1] is not None for li in self.tickets]
for li in self.tickets:
if li is not None:
self.tickets[self.tickets.index(li)] = li[1]
else:
self.tickets[self.tickets.index(li)] = False
if gl.df is None:
self.df = cores.read_csv(gl.now_file, tickets_list)
self.df.insert(0, "time", pd.to_datetime(self.df[self.tickets[0]]))
else:
self.df = gl.df
def get_df(self):
tickets_list = [
"时间", "机组运行模式", "变桨驱动柜温度1", "变桨驱动柜温度2", "变桨驱动柜温度3", "桨叶角度1A",
"桨叶角度2A", "桨叶角度3A", "桨叶角度1B", "桨叶角度2B", "桨叶角度3B", "叶轮速度1", "叶轮速度2",
"风速", "变桨电机温度1", "变桨电机温度2", "变桨电机温度3", "变桨驱动柜散热器温度1",
"变桨驱动柜散热器温度2", "变桨驱动柜散热器温度3", "变桨后备电源柜温度1", "变桨后备电源柜温度2",
"变桨后备电源柜温度3"
]
self.project_name = str(os.path.basename(
gl.now_file)).split(".")[-2].split("_")[0][:5]
self.tickets = cores.get_en_tickets("../db/tickets.my",
self.project_name, tickets_list)
for li in self.tickets:
if li is not None:
self.tickets[self.tickets.index(li)] = li[1]
else:
self.tickets[self.tickets.index(li)] = False
if gl.df is None:
self.df = cores.read_csv(gl.now_file, tickets_list)
self.df.insert(0, "time", pd.to_datetime(self.df[self.tickets[0]]))
else:
self.df = gl.df
def get_df(self):
tickets_list = [
"时间", "机组运行模式", "塔基变压器温度", "塔筒第一层平台温度", "塔基柜温度", "机舱高压柜温度", "机舱温度",
"机舱低压柜温度", "变频器温度1", "变频器温度2", "变频器温度3", "变频器温度4", "变频器温度5",
"变频器温度6", "变频器温度7", "变频器温度8", "变频器温度9", "变频器温度10", "变频器温度11",
"变频器温度12", "变频器温度13", "变频器温度14", "变频器温度15", "变频器温度16", "变频器温度17"
]
self.project_name = str(os.path.basename(
gl.now_file)).split(".")[-2].split("_")[0][:5]
self.tickets = cores.get_en_tickets("../db/tickets.my",
self.project_name, tickets_list)
# self.tickets = [li[1] is not None for li in self.tickets]
for li in self.tickets:
if li is not None:
self.tickets[self.tickets.index(li)] = li[1]
else:
self.tickets[self.tickets.index(li)] = False
if gl.df is None:
self.df = cores.read_csv(gl.now_file, tickets_list)
self.df.insert(0, "time", pd.to_datetime(self.df[self.tickets[0]]))
else:
self.df = gl.df
def get_df(self):
tickets_list = ["时间",
"机组运行模式",
"发电机绕组温度1",
"发电机绕组温度2",
"发电机绕组温度3",
"发电机绕组温度4",
"发电机绕组温度5",
"发电机绕组温度6",
"发电机齿轮箱侧轴承温度",
"发电机机舱侧轴承温度",
"变流器功率",
"发电机空空冷内循环入口温度1",
"发电机空空冷内循环入口温度2",
"发电机空空冷内循环出口温度1",
"发电机空空冷内循环出口温度2",
"发电机空空冷外循环入口温度1",
"发电机空空冷外循环入口温度2",
"发电机空空冷外循环出口温度1",
"发电机空空冷外循环出口温度2"
]
self.project_name = str(os.path.basename(gl.now_file)).split(".")[-2].split("_")[0][:5]
self.tickets = cores.get_en_tickets("../db/tickets.my", self.project_name, tickets_list)
for li in self.tickets:
if li is not None:
self.tickets[self.tickets.index(li)] = li[1]
else:
self.tickets[self.tickets.index(li)] = False
if gl.df is None:
# self.tickets = [li[1] is not None for li in self.tickets]
self.df = cores.read_csv(gl.now_file, tickets_list)
self.df.insert(0, "time", pd.to_datetime(self.df[self.tickets[0]]))
else:
self.df = gl.df
def run(self):
gl.df = None
gl.df = cores.read_csv(self.file)
gl.df.insert(0, "time", pd.to_datetime(gl.df["时间"]))
self.over_signal.emit(True)