def __setFilter__(self): self.insertRow(0) for idx, header in enumerate(self.columns): if header in ['번호', '설정']: item = QTableWidgetItem('') item.setFlags(Qt.ItemIsEditable) self.setItem(0, idx, item) elif header == '개월수': items = self.dataFrame[header].drop_duplicates().tolist() i = 0 p = [] for item in items: try: items[i] = int(item) except: p.append(i) i += 1 p.reverse() for i in p: items.pop(i) items.sort() items = ['전체'] + [str(item) for item in items] CbxFilterInTable(idx, items, self) elif header == '사업비': items = self.dataFrame[header].drop_duplicates().tolist() i = 0 p = [] for item in items: item = item.replace(',', '') try: items[i] = int(item) except: p.append(i) i += 1 p.reverse() for i in p: items.pop(i) items.sort() items = ['전체'] + [format(item, ',') for item in items] CbxFilterInTable(idx, items, self) else: items = self.dataFrame[header].drop_duplicates().tolist() if '' in items: items.remove('') items.sort() items = ['전체'] + items CbxFilterInTable(idx, items, self)
def __setFilter__(self): self.insertRow(0) for idx, header in enumerate(self.columns): items = self.dataFrame[header].drop_duplicates().tolist() if '' in items: items.remove('') items.sort() items = ['전체'] + items CbxFilterInTable(idx, items, self)
def __setFilter__(self): self.insertRow(0) for idx, header in enumerate(self.columns): if idx == 0: item = QTableWidgetItem('') item.setFlags(Qt.ItemIsEditable) self.setItem(0, idx, item) elif idx == 7: items = [ '전체' ] + self.dataFrame['적용상태_사업'].drop_duplicates().tolist() CbxFilterInTable(idx, items, self) else: items = self.dataFrame[header].drop_duplicates().tolist() if '' in items: items.remove('') items.sort() items = ['전체'] + items CbxFilterInTable(idx, items, self)
def __setFilter__(self): self.insertRow(0) for idx, header in enumerate(self.columns): if header in ['수정한날짜', '비밀번호', '설정']: item = QTableWidgetItem('') item.setFlags(Qt.ItemIsEditable) self.setItem(0, idx, item) else: items = ['전체'] + self.dataFrame[header].drop_duplicates().tolist() CbxFilterInTable(idx, items, self)
def __setFilter__(self): self.insertRow(0) for idx, header in enumerate(self.columns): if header in ['번호', '수정한날짜', '설정']: item = QTableWidgetItem('') item.setFlags(Qt.ItemIsEditable) self.setItem(0, idx, item) else: items = self.dataFrame[header].tolist() items.remove(items[0]) items.remove(items[-1]) items = ['전체'] + list(tuple(set(items))) CbxFilterInTable(idx, items, self)
def __setFilter__(self): self.insertRow(0) for idx, header in enumerate(self.columns): items = ['전체'] + self.dataFrame[header].drop_duplicates().tolist() CbxFilterInTable(idx, items, self)
def __setFilter__(self): self.insertRow(0) for idx, header in enumerate(self.columns): if header in ['비밀번호', '설정']: item = QTableWidgetItem('') item.setFlags(Qt.ItemIsEditable) self.setItem(0, idx, item) elif header == '주민등록번호': items = self.dataFrame[header].drop_duplicates().tolist() i = 0 p = [] for item in items: item = item.replace('-', '') try: items[i] = int(item) except: p.append(i) i += 1 p.reverse() for i in p: items.pop(i) items.sort() for i, item in enumerate(items): if len(str(item)) != 7: items[i] = '0' * (7 - len(str(item))) + str(item) items = ['전체'] + [ f"{str(item)[:6]}-{str(item)[6]}" for item in items ] CbxFilterInTable(idx, items, self) elif header == '연락처': items = self.dataFrame[header].drop_duplicates().tolist() i = 0 p = [] for item in items: item = item.replace('-', '') try: items[i] = int(item) except: p.append(i) i += 1 p.reverse() for i in p: items.pop(i) items.sort() items = ['전체'] + [ f"0{str(item)[:2]}-{str(item)[2:6]}-{str(item)[6:]}" for item in items ] CbxFilterInTable(idx, items, self) elif header == '과학기술인등록번호': items = self.dataFrame[header].drop_duplicates().tolist() i = 0 p = [] for item in items: try: items[i] = int(item) except: p.append(i) i += 1 p.reverse() for i in p: items.pop(i) items.sort() items = ['전체'] + [str(item) for item in items] CbxFilterInTable(idx, items, self) else: items = self.dataFrame[header].drop_duplicates().tolist() if '' in items: items.remove('') items.sort() items = ['전체'] + items CbxFilterInTable(idx, items, self)