How to populate a dataframe in a QDialog using PyQT

Piyush

@jsulm Hi,
Actually the answer you gave was not relevant.

mrjj

Hi
To put a table on/in a Dialog.
You must have your own dialog. So subclass is highly relevant :)
There is no other way. Except table it self can be window. but then its not dialog like.

listview example
https://www.pythoncentral.io/pyside-pyqt-tutorial-qlistview-and-qstandarditemmodel/

dialog example
https://gist.github.com/justinfx/1951709

jsulm

@Piyush Please explain why it is not relevant?
You're trying to use QDialog to show a table. The standard QDialog does not know anything about your table. That's why you need to subclass QDialog and show the table there.

Piyush

@mrjj Hi,
So this is what I am trying to do. But getting an error. "My app object has no attribute set item"

self.ui.btn1.clicked.connect(self.Dialog)
def Dialog(self):
table = self.MyTable(data,5,3)
#table.setWindowFlags(table.windowFlags() | Qt.Window)
table.show()
self.table = table

def MyTable(self,data,*args):
     QTableWidget.__init__(self)
     self.data = data
     horHeaders = []
     for n, key in enumerate(sorted(self.data.keys())):
        horHeaders.append(key)
        for m, item in enumerate(self.data[key]):
            newitem = QTableWidgetItem(item)
            self.setItem(m, n, newitem)
            self.setHorizontalHeaderLabels(horHeaders)
     print horHeaders,newitem

mrjj

Hi
you must call setItem(m, n, newitem) on the QTableWidget not via Self since in this case Self seems to be app.

Piyush

@mrjj Hi,
I tried that too but getting an error: "TypeError: setItem(self, int, int, QTableWidgetItem): first argument of unbound method must have type 'QTableWidget'"

jsulm

@Piyush

QTableWidget.setItem(m, n, newitem)

Piyush

@jsulm Hi,
I have used the same line of code. But still I am getting the error: "TypeError: setItem(self, int, int, QTableWidgetItem): first argument of unbound method must have type 'QTableWidget'". Here is the snippet:

def Dialog(self):
     table = self.MyTable(data,5,3)
     table.show()
     self.table = table
     
def MyTable(self,data,*args):
     self.data = data
     horHeaders = []
     for n, key in enumerate(sorted(self.data.keys())):
        horHeaders.append(key)
        for m, item in enumerate(self.data[key]):
            newitem = QTableWidgetItem(item)
            QTableWidget.setItem(m, n, newitem)
            QTableWidget.setHorizontalHeaderLabels(horHeaders)
     print horHeaders,newitem

jsulm

@Piyush Maybe

super(QTableWidget, self).setItem(m, n, newitem)

JonB

@Piyush said in How to populate a dataframe in a QDialog using PyQT:

        QTableWidget.setItem(m, n, newitem)
        QTableWidget.setHorizontalHeaderLabels(horHeaders)

The left hand side for setItem()/setHorizontalHeaderLabels() must be your actual table (widget) variable. You are passing the class/type QTableWidget. Hence the error message.

Also while I'm here, your MyTable() does not return anything, and does not inherit from anything either.

Piyush

@jsulm said in How to populate a dataframe in a QDialog using PyQT:

super(QTableWidget, self).setItem(m, n, newitem)

Actually no, since super will call a class object.

Piyush

@JonB Hi,
Could you give me the code for that? Since I am not able to get it.

jsulm

@JonB Somehow I was thinking MyTable is a class derived from QTableWidget :-)

JonB

@Piyush
Well, (as usual for me) I don't really understand what it is you are trying to do or ask about.

Are you simply wishing to create a QDialog and then put a QTableWidget on it, so it's a dialog which has a table (among possibly other widgets) on it?

jsulm

@Piyush said in How to populate a dataframe in a QDialog using PyQT:

Could you give me the code for that? Since I am not able to get it.

In your dialog you should have an instance of QTableWidget, right?
Something like:

self.tableWidget = QTableWidget()

Then it would be

self.tableWidget.setItem(m, n, newitem)

Piyush

@JonB Exactly, I want a QDialog and then put a table on it.

Piyush

@jsulm I am getting empty/none table. Here is the code snippet:

def Dialog(self):
     table = self.MyTable(data,5,3)
     table.show()
     self.table = table
         
def MyTable(self,data,*args):
     self.data = data
     self.tableWidget = QTableWidget()
     horHeaders = []
     for n, key in enumerate(sorted(self.data.keys())):
        horHeaders.append(key)
        for m, item in enumerate(self.data[key]):
            newitem = QTableWidgetItem(item)
            self.tableWidget.setItem(m, n, newitem)
            self.tableWidget.setHorizontalHeaderLabels(horHeaders)

jsulm

@Piyush said in How to populate a dataframe in a QDialog using PyQT:

Exactly, I want a QDialog and then put a table on it.

So, did you create a table in your dialog? It is really hard to follow you as you do not provide much information.

jsulm

@Piyush You're not creating any rows/columns.
See http://doc.qt.io/qt-5/qtablewidget.html

tableWidget = new QTableWidget(this);
tableWidget->setRowCount(10);
tableWidget->setColumnCount(5);

JonB

@Piyush

OK, so I don't know what all the earlier discussion was about, but a QTableWidget is simply a QWidget like any other widget, and I presume you know how to add widgets to dialogs.

Your code will look like:

dlg = QDialog()
tbl = QTableWidget()
dlg.addWidget(tbl)
tbl.setHorizontalHeaderLabels(...)
tbl.setRowCount(...)
tbl.setColumnCount(...)
...
item = QTableWidgetItem(...)
tbl.setItem(m, n, item)

If you want to create a dedicated dialog for this, you might go:

class MyDialog(QDialog):
    def __init__(self, parent=None):
        super().__init__(parent)

        self.tbl = QTableWidget()
        self.addWidget(self.tbl)
        self.tbl.setHorizontalHeaderLabels(...)
        self.tbl.setRowCount(...)
        self.tbl.setColumnCount(...)
        ...
        item = QTableWidgetItem(...)
        self.tbl.setItem(m, n, item)

That's the skeleton outline. As @jsulm says, you need to create the actual rows/columns in the table (tbl.setRow/ColumnCount()) to hold the QTableWidgetItems you create.