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)