How can i fill qtablewidget(pyqt5) with mongodb datas

Working with Data
6

def loaddata(self):

    self.table.setColumnCount(self.numcolumn)
    self.table.setRowCount(self.numrow)
    self.table.setColumnHidden(0, True)


    for i in range(self.table.rowCount()):
        self.table.removeRow(i)

    db = client['kisiler']
    collection = db['muvekkiller']
    ducuments = collection.find()
    list_cur=list(ducuments)
    df=DataFrame(list_cur)
    #print(df)

    nRows,nColumns=df.shape
    self.table.setColumnCount(nColumns)
    self.table.setRowCount(nRows)

    self.table.setHorizontalHeaderLabels(df.head())
    for i in range(self.table.rowCount()):
        for j in range(self.table.columnCount()):
            self.table.setItem(i,j,QTableWidgetItem(str(df.iloc[i,j])))
1 Like