Fastest way to populate QTableView from Pandas data frame

by

Personally I would just create my own model class to make handling it somewhat easier.

For example:

import sys
from PyQt4 import QtCore, QtGui
Qt = QtCore.Qt

class PandasModel(QtCore.QAbstractTableModel):
    def __init__(self, data, parent=None):
        QtCore.QAbstractTableModel.__init__(self, parent)
        self._data = data

    def rowCount(self, parent=None):
        return len(self._data.values)

    def columnCount(self, parent=None):
        return self._data.columns.size

    def data(self, index, role=Qt.DisplayRole):
        if index.isValid():
            if role == Qt.DisplayRole:
                return QtCore.QVariant(str(
                    self._data.iloc[index.row()][index.column()]))
        return QtCore.QVariant()


if __name__ == '__main__':
    application = QtGui.QApplication(sys.argv)
    view = QtGui.QTableView()
    model = PandasModel(your_pandas_data)
    view.setModel(model)

    view.show()
    sys.exit(application.exec_())

More Related Contents:

  1. error when applying function to a series object
  2. How to group dataframe rows into list in pandas groupby
  3. Groupby value counts on the dataframe pandas
  4. Replace values in a pandas series via dictionary efficiently
  5. Pandas: Chained assignments [duplicate]
  6. Apply pandas function to column to create multiple new columns?
  7. Reading an Excel file in python using pandas
  8. Python Pandas: Get index of rows which column matches certain value
  9. Pandas deleting row with df.drop doesn’t work
  10. Random row selection in Pandas dataframe
  11. converting currency with $ to numbers in Python pandas
  12. Lookup Values by Corresponding Column Header in Pandas 1.2.0 or newer
  13. How to spread a column in a Pandas data frame
  14. Python Pandas write to sql with NaN values
  15. How to merge pandas on string contains?
  16. Pandas style function to highlight specific columns
  17. pandas.io.json.json_normalize with very nested json
  18. Python pandas convert datetime to timestamp effectively through dt accessor
  19. Checking if particular value (in cell) is NaN in pandas DataFrame not working using ix or iloc
  20. Time Series Analysis – unevenly spaced measures – pandas + statsmodels
  21. Move column by name to front of table in pandas
  22. matplotlib savefig() size control
  23. How can I check if a keyboard modifier is pressed (Shift, Ctrl, or Alt)?
  24. Is there a way to speed up handling large CSVs and dataframes in python?
  25. Add numpy array as column to Pandas data frame
  26. How to use ast.literal_eval in a pandas dataframe and handle exceptions
  27. Why is NaN considered as a float?
  28. Pandas Rolling Computations on Sliding Windows (Unevenly spaced)
  29. DataFrame object has no attribute append
  30. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13

Leave a Comment