def getDataFile(self): DataFileInput, filetype = QFileDialog.getOpenFileName( self, "选取文件", "~/", "Excel Files (*.xlsx);;Excel 2003 Files (*.xls);;CSV Files (*.csv)" ) # 设置文件扩展名过滤,注意用双分号间隔 # print(DataFileInput,filetype) if ("csv" in DataFileInput): self.raw = pd.read_csv(DataFileInput) elif ("xls" in DataFileInput): self.raw = pd.read_excel(DataFileInput) # print(self.raw) self.model = PandasModel(self.raw) self.tableView.setModel(self.model) flag = 0 ItemsAvalibale = self.model._df.columns.values.tolist() ItemsToTest = [ 'Label', 'Marker', 'Color', 'Size', 'Alpha', 'Style', 'Width' ] ItemsToAdd = [] Sentecne = 'You need to add ' print(ItemsAvalibale, '\n', ItemsToTest) for i in ItemsToTest: if i not in ItemsAvalibale: ItemsToAdd.append(i) Sentecne = Sentecne + i + ', ' flag = flag + 1 Sentecne = Sentecne + " to your data, set up now?" if flag != 0: buttonReply = QMessageBox.question( self, 'Message', Sentecne, QMessageBox.Yes | QMessageBox.No, QMessageBox.No) if buttonReply == QMessageBox.Yes: self.SetUpDataFile() else: reply = QMessageBox.warning( self, 'Warning', "Data can't be used without setting up Label,Color,Size and so on." )
def getDataFile(self): DataFileInput, filetype = QFileDialog.getOpenFileName( self, "选取文件", "~/", "Excel Files (*.xlsx);;Excel 2003 Files (*.xls);;CSV Files (*.csv)" ) # 设置文件扩展名过滤,注意用双分号间隔 #print(DataFileInput,filetype) if ("csv" in DataFileInput): self.raw = pd.read_csv(DataFileInput) elif ("xls" in DataFileInput): self.raw = pd.read_excel(DataFileInput) #print(self.raw) self.model = PandasModel(self.raw) self.tableView.setModel(self.model)
def setupUi( self, MainWindow, ): MainWindow.setObjectName("MainWindow") MainWindow.resize(800, 500) self.model = PandasModel(self.raw) self.main_widget = QWidget(self) self.centralwidget = QtWidgets.QWidget(MainWindow) self.centralwidget.setObjectName("centralwidget") MainWindow.setCentralWidget(self.centralwidget) self.tableView = CustomQTableView(self.centralwidget) self.tableView.setGeometry(QtCore.QRect(10, 10, 780, 384)) self.tableView.setObjectName("tableView") self.tableView.setSortingEnabled(True) self.pushButtonOpen = QtWidgets.QPushButton(self.centralwidget) self.pushButtonOpen.setGeometry(QtCore.QRect(20, 404, 110, 32)) self.pushButtonOpen.setObjectName("pushButtonOpen") self.pushButtonSave = QtWidgets.QPushButton(self.centralwidget) self.pushButtonSave.setGeometry(QtCore.QRect(150, 404, 110, 32)) self.pushButtonSave.setObjectName("pushButtonSave") self.pushButtonSort = QtWidgets.QPushButton(self.centralwidget) self.pushButtonSort.setGeometry(QtCore.QRect(280, 404, 110, 32)) self.pushButtonSort.setObjectName("pushButtonSort") self.pushButtonQuit = QtWidgets.QPushButton(self.centralwidget) self.pushButtonQuit.setGeometry(QtCore.QRect(410, 404, 110, 32)) self.pushButtonQuit.setObjectName("pushButtonQuit") self.menubar = QtWidgets.QMenuBar(MainWindow) self.menubar.setGeometry(QtCore.QRect(0, 0, 800, 22)) self.menubar.setNativeMenuBar(False) self.menubar.setObjectName("menubar") self.menuFile = QtWidgets.QMenu(self.menubar) self.menuFile.setObjectName("menuFile") self.menuGeoChem = QtWidgets.QMenu(self.menubar) self.menuGeoChem.setObjectName("menuGeoChem") self.menuStructure = QtWidgets.QMenu(self.menubar) self.menuStructure.setObjectName("menuStructure") self.menuCalc = QtWidgets.QMenu(self.menubar) self.menuCalc.setObjectName("menuCalc") self.menuMore = QtWidgets.QMenu(self.menubar) self.menuMore.setObjectName("menuMore") self.menuHelp = QtWidgets.QMenu(self.menubar) self.menuHelp.setObjectName("menuHelp") MainWindow.setMenuBar(self.menubar) self.statusbar = QtWidgets.QStatusBar(MainWindow) self.statusbar.setObjectName("statusbar") MainWindow.setStatusBar(self.statusbar) self.actionOpen = QtWidgets.QAction(MainWindow) self.actionOpen.setObjectName("actionOpen") self.actionOpen.setShortcut('Ctrl+O') self.actionSave = QtWidgets.QAction(MainWindow) self.actionSave.setObjectName("actionSave") self.actionSave.setShortcut('Ctrl+S') self.actionInstruction = QtWidgets.QAction(MainWindow) self.actionInstruction.setObjectName("actionInstruction") self.actionWebsite = QtWidgets.QAction(MainWindow) self.actionWebsite.setObjectName("actionWebsite") self.actionTAS = QtWidgets.QAction(MainWindow) self.actionTAS.setObjectName("actionTAS") self.actionTrace = QtWidgets.QAction(MainWindow) self.actionTrace.setObjectName("actionTrace") self.actionRee = QtWidgets.QAction(MainWindow) self.actionRee.setObjectName("actionRee") self.actionPearce = QtWidgets.QAction(MainWindow) self.actionPearce.setObjectName("actionPearce") self.actionHarker = QtWidgets.QAction(MainWindow) self.actionHarker.setObjectName("actionHarker") self.actionStereo = QtWidgets.QAction(MainWindow) self.actionStereo.setObjectName("actionStereo") self.actionRose = QtWidgets.QAction(MainWindow) self.actionRose.setObjectName("actionRose") self.actionQFL = QtWidgets.QAction(MainWindow) self.actionQFL.setObjectName("actionQFL") self.actionQmFLt = QtWidgets.QAction(MainWindow) self.actionQmFLt.setObjectName("actionQmFLt") self.actionCIPW = QtWidgets.QAction(MainWindow) self.actionCIPW.setObjectName("actionCIPW") self.actionZirconCe = QtWidgets.QAction(MainWindow) self.actionZirconCe.setObjectName("actionZirconCe") self.actionQAPF = QtWidgets.QAction(MainWindow) self.actionQAPF.setObjectName("actionQAPF") self.actionMudStone = QtWidgets.QAction(MainWindow) self.actionMudStone.setObjectName("actionMudStone") self.actionXY = QtWidgets.QAction(MainWindow) self.actionXY.setObjectName("actionXY") self.actionXYZ = QtWidgets.QAction(MainWindow) self.actionXYZ.setObjectName("actionXYZ") self.actionMagic = QtWidgets.QAction(MainWindow) self.actionMagic.setObjectName("actionMagic") self.menuFile.addAction(self.actionOpen) self.menuFile.addAction(self.actionSave) self.menuGeoChem.addAction(self.actionTAS) self.menuGeoChem.addAction(self.actionTrace) self.menuGeoChem.addAction(self.actionRee) self.menuGeoChem.addAction(self.actionPearce) self.menuGeoChem.addAction(self.actionHarker) self.menuStructure.addAction(self.actionStereo) self.menuStructure.addAction(self.actionRose) self.menuStructure.addAction(self.actionQFL) self.menuStructure.addAction(self.actionQmFLt) self.menuCalc.addAction(self.actionCIPW) self.menuCalc.addAction(self.actionZirconCe) self.menuMore.addAction(self.actionMudStone) self.menuMore.addAction(self.actionQAPF) self.menuMore.addAction(self.actionXY) self.menuMore.addAction(self.actionXYZ) self.menuMore.addAction(self.actionMagic) self.menuHelp.addAction(self.actionInstruction) self.menuHelp.addAction(self.actionWebsite) self.menubar.addAction(self.menuFile.menuAction()) self.menubar.addSeparator() self.menubar.addAction(self.menuGeoChem.menuAction()) self.menubar.addSeparator() self.menubar.addAction(self.menuStructure.menuAction()) self.menubar.addSeparator() self.menubar.addAction(self.menuCalc.menuAction()) self.menubar.addSeparator() self.menubar.addAction(self.menuMore.menuAction()) self.menubar.addSeparator() self.menubar.addAction(self.menuHelp.menuAction()) self.menubar.addSeparator() self.retranslateUi(MainWindow) QtCore.QMetaObject.connectSlotsByName(MainWindow) self.actionTAS.triggered.connect(self.TAS) self.actionTrace.triggered.connect(self.Trace) self.actionRee.triggered.connect(self.REE) self.actionPearce.triggered.connect(self.Pearce) self.actionHarker.triggered.connect(self.Harker) self.actionQAPF.triggered.connect(self.QAPF) self.actionStereo.triggered.connect(self.Stereo) self.actionRose.triggered.connect(self.Rose) self.actionQFL.triggered.connect(self.QFL) self.actionQmFLt.triggered.connect(self.QmFLt) self.actionCIPW.triggered.connect(self.CIPW) self.actionZirconCe.triggered.connect(self.Zircon) self.actionOpen.triggered.connect(self.getDataFile) self.actionSave.triggered.connect(self.saveDataFile) self.actionWebsite.triggered.connect(self.gowebsite) self.actionXY.triggered.connect(self.XY) self.actionXYZ.triggered.connect(self.XYZ) self.actionMagic.triggered.connect(self.Magic) self.actionMudStone.triggered.connect(self.Mud) self.pushButtonOpen.clicked.connect(self.getDataFile) self.pushButtonSave.clicked.connect(self.saveDataFile) self.pushButtonSort.clicked.connect(self.SetUpDataFile) self.pushButtonQuit.clicked.connect(qApp.quit) self.actionQuit = QtWidgets.QAction('Quit', self) self.actionQuit.setShortcut('Ctrl+Q') self.actionQuit.setObjectName("actionQuit") self.actionQuit.triggered.connect(qApp.quit)
def setupUi(self, MainWindow,): self.w = MyPopup() self.w.setGeometry(QtCore.QRect(100, 100, 532, 600)) self.zirconpop=Zircon() MainWindow.setObjectName("MainWindow") MainWindow.resize(800, 800) self.model = PandasModel(self.raw) self.main_widget = QWidget(self) self.centralwidget = QtWidgets.QWidget(MainWindow) self.centralwidget.setObjectName("centralwidget") self.tableView = CustomQTableView(self.centralwidget) self.tableView.setGeometry(QtCore.QRect(10, 10, 780, 384)) self.tableView.setObjectName("tableView") self.tableView.setSortingEnabled(True) self.pushButtonOpen = QtWidgets.QPushButton(self.centralwidget) self.pushButtonOpen.setGeometry(QtCore.QRect(30, 404, 110, 32)) self.pushButtonOpen.setObjectName("pushButtonOpen") self.pushButtonSave = QtWidgets.QPushButton(self.centralwidget) self.pushButtonSave.setGeometry(QtCore.QRect(30, 444, 110, 32)) self.pushButtonSave.setObjectName("pushButtonSave") self.pushButtonTAS = QtWidgets.QPushButton(self.centralwidget) self.pushButtonTAS.setGeometry(QtCore.QRect(150, 404, 110, 32)) self.pushButtonTAS.setObjectName("pushButtonTAS") self.pushButtonZircon = QtWidgets.QPushButton(self.centralwidget) self.pushButtonZircon.setGeometry(QtCore.QRect(150, 444, 110, 32)) self.pushButtonZircon.setObjectName("pushButtonZircon") self.pushButtonCIPW = QtWidgets.QPushButton(self.centralwidget) self.pushButtonCIPW.setGeometry(QtCore.QRect(150, 484, 110, 32)) self.pushButtonCIPW.setObjectName("pushButtonCIPW") self.pushButtonStereo = QtWidgets.QPushButton(self.centralwidget) self.pushButtonStereo.setGeometry(QtCore.QRect(410, 404, 110, 32)) self.pushButtonStereo.setObjectName("pushButtonStereo") self.pushButtonTrace = QtWidgets.QPushButton(self.centralwidget) self.pushButtonTrace.setGeometry(QtCore.QRect(280, 444, 110, 32)) self.pushButtonTrace.setObjectName("pushButtonTrace") self.pushButtonTrace2 = QtWidgets.QPushButton(self.centralwidget) self.pushButtonTrace2.setGeometry(QtCore.QRect(280, 484, 110, 32)) self.pushButtonTrace2.setObjectName("pushButtonTrace2") self.pushButtonREE = QtWidgets.QPushButton(self.centralwidget) self.pushButtonREE.setGeometry(QtCore.QRect(280, 404, 110, 32)) self.pushButtonREE.setObjectName("pushButtonREE") self.pushButtonRose = QtWidgets.QPushButton(self.centralwidget) self.pushButtonRose.setGeometry(QtCore.QRect(410, 444, 110, 32)) self.pushButtonRose.setObjectName("pushButtonRose") self.pushButtonMudStone = QtWidgets.QPushButton(self.centralwidget) self.pushButtonMudStone.setGeometry(QtCore.QRect(540, 404, 110, 32)) self.pushButtonMudStone.setObjectName("pushButtonMudStone") self.pushButtonQFL= QtWidgets.QPushButton(self.centralwidget) self.pushButtonQFL.setGeometry(QtCore.QRect(540, 444, 110, 32)) self.pushButtonQFL.setObjectName("pushButtonQFL") self.pushButtonQmFLt= QtWidgets.QPushButton(self.centralwidget) self.pushButtonQmFLt.setGeometry(QtCore.QRect(540, 484, 110, 32)) self.pushButtonQmFLt.setObjectName("pushButtonQmFLt") self.pushButtonQAPF= QtWidgets.QPushButton(self.centralwidget) self.pushButtonQAPF.setGeometry(QtCore.QRect(540, 524, 110, 32)) self.pushButtonQAPF.setObjectName("pushButtonQAPF") MainWindow.setCentralWidget(self.centralwidget) self.menubar = QtWidgets.QMenuBar(MainWindow) self.menubar.setGeometry(QtCore.QRect(0, 0, 800, 22)) self.menubar.setNativeMenuBar(False) self.menubar.setObjectName("menubar") self.menuFile = QtWidgets.QMenu(self.menubar) self.menuFile.setObjectName("menuFile") self.menuHelp = QtWidgets.QMenu(self.menubar) self.menuHelp.setObjectName("menuHelp") self.menuPlot = QtWidgets.QMenu(self.menubar) self.menuPlot.setObjectName("menuPlot") self.menuCalc = QtWidgets.QMenu(self.menubar) self.menuCalc.setObjectName("menuCalc") self.menuDIY = QtWidgets.QMenu(self.menubar) self.menuDIY.setObjectName("menuDIY") MainWindow.setMenuBar(self.menubar) self.statusbar = QtWidgets.QStatusBar(MainWindow) self.statusbar.setObjectName("statusbar") MainWindow.setStatusBar(self.statusbar) self.actionOpen = QtWidgets.QAction(MainWindow) self.actionOpen.setObjectName("actionOpen") self.actionSave = QtWidgets.QAction(MainWindow) self.actionSave.setObjectName("actionSave") self.actionInstruction = QtWidgets.QAction(MainWindow) self.actionInstruction.setObjectName("actionInstruction") self.actionWebsite = QtWidgets.QAction(MainWindow) self.actionWebsite.setObjectName("actionWebsite") self.menuFile.addAction(self.actionOpen) self.menuFile.addAction(self.actionSave) self.menuHelp.addAction(self.actionInstruction) self.menuHelp.addAction(self.actionWebsite) self.menubar.addAction(self.menuFile.menuAction()) self.menubar.addAction(self.menuHelp.menuAction()) self.retranslateUi(MainWindow) QtCore.QMetaObject.connectSlotsByName(MainWindow) self.pushButtonOpen.clicked.connect(self.getDataFile) self.actionOpen.triggered.connect(self.getDataFile) self.pushButtonSave.clicked.connect(self.saveDataFile) self.actionSave.triggered.connect(self.saveDataFile) self.pushButtonZircon.clicked.connect(self.Zircon) self.pushButtonTAS.clicked.connect(self.TAS) self.pushButtonREE.clicked.connect(self.REE) self.pushButtonTrace.clicked.connect(self.Trace) self.pushButtonTrace2.clicked.connect(self.Trace2) self.pushButtonStereo.clicked.connect(self.Stereo) self.pushButtonRose.clicked.connect(self.Rose) self.pushButtonMudStone.clicked.connect(self.Mud) self.pushButtonQFL.clicked.connect(self.QFL) self.pushButtonQmFLt.clicked.connect(self.QmFLt) self.pushButtonCIPW.clicked.connect(self.CIPW) self.pushButtonQAPF.clicked.connect(self.QAPF)