How to Integrate PyQt6 with Pandas

In this PyQt6 article we want to learn How to Integrate PyQt6 with Pandas, so PyQt6 is powerful GUI framework for creating desktop applications, and Pandas is popular data manipulation library for Python. integrating these two can be incredibly useful, as it allows you to build desktop applications that can handle and display large amounts of data. in this article we want to talk about integrating PyQt6 with Pandas.

How to Integrate PyQt6 with Pandas

First of all we need to install required libraries, and we can use pip for the installation

pip install PyQt6
pip install pandas

1 2	pip install PyQt6 pip install pandas

This is the complete code for this article

import sys
import pandas as pd
from PyQt6.QtWidgets import QMainWindow, QApplication, QTableWidget, QTableWidgetItem

class MyApp(QMainWindow):
    def __init__(self):
        super().__init__()
        self.setWindowTitle('My PyQt6 App')
        self.setGeometry(100, 100, 800, 600)

        # Create a Pandas DataFrame
        data = {'Name': ['John', 'Mike', 'Sarah'],
                'Age': [32, 24, 28],
                'Occupation': ['Engineer', 'Teacher', 'Doctor']}
        df = pd.DataFrame(data)

        # Add a table to the main window
        self.table = QTableWidget()
        self.setCentralWidget(self.table)

        # Populate the table with data from the DataFrame
        self.table.setColumnCount(len(df.columns))
        self.table.setRowCount(len(df.index))
        for i in range(len(df.index)):
            for j in range(len(df.columns)):
                self.table.setItem(i, j, QTableWidgetItem(str(df.iloc[i, j])))

if __name__ == '__main__':
    app = QApplication(sys.argv)
    myapp = MyApp()
    myapp.show()
    sys.exit(app.exec())

import sys

import pandas as pd

from PyQt6.QtWidgets import QMainWindow, QApplication, QTableWidget, QTableWidgetItem

class MyApp(QMainWindow):

def __init__(self):

super().__init__()

self.setWindowTitle('My PyQt6 App')

self.setGeometry(100, 100, 800, 600)

# Create a Pandas DataFrame

data = {'Name': ['John', 'Mike', 'Sarah'],

'Age': [32, 24, 28],

'Occupation': ['Engineer', 'Teacher', 'Doctor']}

df = pd.DataFrame(data)

# Add a table to the main window

self.table = QTableWidget()

self.setCentralWidget(self.table)

# Populate the table with data from the DataFrame

self.table.setColumnCount(len(df.columns))

self.table.setRowCount(len(df.index))

for i in range(len(df.index)):

for j in range(len(df.columns)):

self.table.setItem(i, j, QTableWidgetItem(str(df.iloc[i, j])))

if __name__ == '__main__':

app = QApplication(sys.argv)

myapp = MyApp()

myapp.show()

sys.exit(app.exec())

So in the above code we have our Pandas DataFrame. for the purposes of this tutorial we want to create simple DataFrame with three columns.

data = {'Name': ['Geekscoders', 'Mike', 'Sarah'],
                'Age': [32, 24, 28],
                'Occupation': ['Engineer', 'Teacher', 'Doctor']}
        df = pd.DataFrame(data)

data = {'Name': ['Geekscoders', 'Mike', 'Sarah'],

'Age': [32, 24, 28],

'Occupation': ['Engineer', 'Teacher', 'Doctor']}

df = pd.DataFrame(data)

Now that we have our DataFrame we can start creating our PyQt6 application. we want to start by creating a class that extends from QMainWindow:

class MyWindow(QMainWindow):
    def __init__(self):
        super().__init__()
        self.setWindowTitle('Geekscoders.com')
        self.setGeometry(100, 100, 800, 600)

class MyWindow(QMainWindow):

def __init__(self):

super().__init__()

self.setWindowTitle('Geekscoders.com')

self.setGeometry(100, 100, 800, 600)

Next we want to add table to our PyQt6 application that displays our Pandas DataFrame. To do this, we want to use QTableWidget class:

self.table = QTableWidget()
self.setCentralWidget(self.table)

1 2	self.table = QTableWidget() self.setCentralWidget(self.table)

Run the complete code and this will be the result

Learn More on Python GUI

Qt Designer Tool in PyQt6

How to Use Stylesheets in Python PyQt6

How to Integrate PyQt6 with Pandas

Learn More on Python GUI

Leave a Comment Cancel reply