Python ile Grafik Çizimi

# Excel dosyasını yükleyip grafik elde etmek.
import sys
import matplotlib
matplotlib.use("Qt5Agg")
import pandas as pd
from PyQt5.QtWidgets import *
from PyQt5.QtGui import *
from matplotlib.backends.backend_qt5agg import FigureCanvasQTAgg,
NavigationToolbar2QT as NavigationToolbar
from matplotlib.figure import Figure
from collections import Counter
from functools import partial
import warnings

class help_(QWidget):
    def __init__(self):
        super().__init__()
        self.textEdit = QLabel('Excel dosyası ekleyiniz.\n'
                               'Cikis yapmak icin exit tiklayiniz.')
        self.layout = QHBoxLayout()
        self.layout.addWidget(self.textEdit)
        self.setLayout(self.layout)
        self.setWindowTitle('Help Window')
        self.setGeometry(350,200,200,100)

class MplCanvas(FigureCanvasQTAgg):
    def __init__(self, parent=None, width=5, height=4, dpi=100) -> object:
        fig = Figure(figsize=(width, height), dpi=dpi)
        self.axes = fig.add_subplot(111)
        super(MplCanvas, self).__init__(fig)

class analiz(QMainWindow):
    def __init__(self):
        super(analiz, self).__init__()
        self._createAction()
        self._cretaMenuBar()
        self._connectActions()

    def _cretaMenuBar(self):
        self.setWindowTitle("Loads Excel")
        self.setGeometry(200,190,770, 598)
        menuBar = self.menuBar()
        fileMenu = QMenu("&File", self)
        fileMenu.addAction(self.newAction)
        fileMenu.addAction(self.openAction)
        fileMenu.addAction(self.saveAction)
        fileMenu.addSeparator()
        fileMenu.addAction(self.exitAction)
        menuBar.addMenu(fileMenu)

        editMenu = menuBar.addMenu("&Edit")
        editMenu.addAction(self.copyAction)
        editMenu.addAction(self.pasteAction)
        editMenu.addAction(self.cutAction)
        editMenu.addSeparator()
        findMenu = editMenu.addMenu("Find and Replace")
        findMenu.addAction("Find...")
        findMenu.addAction("Replace...")

        graphMenu = menuBar.addMenu("Graph")
        graphMenu.addAction(self.graphMenuAction)

        helpMenu = menuBar.addMenu("&Help")
        helpMenu.addAction(self.aboutAction)
        self.openRecentMenu = fileMenu.addMenu("Open Recent")
        self.show()
    def _createAction(self):
        self.newAction = QAction("&New", self)
        self.openAction = QAction("&Open...", self)
        self.saveAction = QAction("&Save...", self)
        self.exitAction = QAction("&Exit...", self)
        self.copyAction = QAction("&Copy...", self)
        self.pasteAction = QAction("&Paste...", self)
        self.cutAction = QAction("&Cut...", self)
        self.aboutAction = QAction("&About...", self)

        self.newAction.setShortcut("Ctrl+N")
        self.openAction.setShortcut("Ctrl+O")
        self.saveAction.setShortcut("Ctrl+S")

        self.copyAction.setShortcut(QKeySequence.Copy)
        self.pasteAction.setShortcut(QKeySequence.Paste)
        self.copyAction.setShortcut(QKeySequence.Cut)

        self.graphMenuAction = QAction("Draw Graph", self)
    def _connectActions(self):
        self.newAction.triggered.connect(self.newFile)
        self.openAction.triggered.connect(self.openFile)
        self.saveAction.triggered.connect(self.saveFile)
        self.exitAction.triggered.connect(self.close)

        self.copyAction.triggered.connect(self.copyContent)
        self.pasteAction.triggered.connect(self.pasteContent)
        self.cutAction.triggered.connect(self.cutContent)

        self.aboutAction.triggered.connect(self.aboutContent)
        self.openRecentMenu.aboutToShow.connect(
        self.populateOpenRecent)

        self.graphMenuAction.triggered.connect(self.grafik)
    def newFile(self):
        self.centralWidget.setText("<b>File > New </b> Clicked")
    def openFile(self):
        # self.centralWidget.setText("<b>File > Open </b> Clicked")
        self.fname = QFileDialog.getOpenFileName(self, "Open File")
        self.file = ",".join(self.fname).split(",")[0].replace("/", "\\")
        # test = open(self.file, "r")
        # print(test)
        # with test:
        #     text = pd.read_excel(self.file)
        #     print(text)
    def saveFile(self):
        self.centralWidget.setText("<b>File > Save </b> Clicked")
    def copyContent(self):
        self.centralWidget.setText("<b>File > Copy </b> Clicked")
    def pasteContent(self):
        self.centralWidget.setText("<b>File > Paste </b> Clicked")
    def cutContent(self):
        self.centralWidget.setText("<b>File > Cut </b> Clicked")
    def aboutContent(self):
        # self.centralWidget.setText("<b>File > About </b> Clicked")
        self.w1 = help_()
        self.w1.show()
    def populateOpenRecent(self):
        self.openRecentMenu.clear()
        actions = []
        filenames = [f"File-{n}" for n in range(5)]
        for filename in filenames:
            action = QAction(filename, self)
            action.triggered.connect(partial(self.openRecentFile, filename))
            actions.append(action)
        self.openRecentMenu.addActions(actions)

    def grafik(self):
        with warnings.catch_warnings(record=True):
            warnings.simplefilter("always")
            self.df = pd.read_excel(self.file)

        text1, ok = QInputDialog.getText(self, 
        'X Coords Start position', 'Enter Row Number')
        text2, ok = QInputDialog.getText(self, 
        'X Coords Start position', 'Enter Column Number')

        # text3, ok = QInputDialog.getText(self, 
          'Y Coords Start position', 'Enter Column Number')
        # text4, ok = QInputDialog.getText(self, 
          'Y Coords Stop position', 'Enter Column Number')
        # text5, ok = QInputDialog.getText(self, 
          'Y Coords start position', 'Enter Row Number')
        ok = True
        if ok:
            self.sutun = int(text2)
            self.satir = int(text1)
            self.namesRow = self.df.iloc[self.satir:, self.sutun]
            # self.basSutun = int(text3)
            # self.bitSutun = int(text4)
            # self.basSatir = int(text5)
            # self.values = self.veri.iloc[self.basSatir:, 
              self.basSutun:self.bitSutun]
        x = Counter(self.namesRow)
        self.listt1 = []
        self.listt2 = []

        for value in set(self.namesRow):
            self.listt1.append(value)
            self.listt2.append(x[value])

        sc = MplCanvas(self, width=5, height=4, dpi=100)
        sc.axes.bar(self.listt1, self.listt2)

        # Grafikte degrleri yazmak için yapıldı.
        for i, txt in enumerate(self.listt2):
            sc.axes.annotate(txt, (self.listt1[i], self.listt2[i]))

        toolbar = NavigationToolbar(sc, self)
        layout = QVBoxLayout()
        layout.addWidget(toolbar)
        layout.addWidget(sc)

        widget = QWidget()
        widget.setLayout(layout)
        self.setCentralWidget(widget)
        self.show()

if __name__ == '__main__':
    app = QApplication(sys.argv)
    w = analiz()
    app.exec_()