我正在尝试获取一个自包含的示例代码,用于使用pandas和QTableView同时获取可编辑单元格视图。
为此,我在跟进早期讨论: Pandas df in editable QTableView: remove check boxes 虽然那个讨论中的答案和建议的修改有助于摆脱复选框,但那里讨论的代码对我仍不起作用(python 2.7)。
当我使用下面的代码修改单元格时,单元格中显示的内容是:PtQt4.PtCore.QtVariant object at ...
我使用的软件包版本是:
Pandas: 0.20.2 Pyside 1.2.4 Qt version: 4.8.4 SIP version: 4.14.4 PyQt version: 4.10
为此,我在跟进早期讨论: Pandas df in editable QTableView: remove check boxes 虽然那个讨论中的答案和建议的修改有助于摆脱复选框,但那里讨论的代码对我仍不起作用(python 2.7)。
当我使用下面的代码修改单元格时,单元格中显示的内容是:PtQt4.PtCore.QtVariant object at ...
我使用的软件包版本是:
Pandas: 0.20.2 Pyside 1.2.4 Qt version: 4.8.4 SIP version: 4.14.4 PyQt version: 4.10
import sys
from PyQt4 import QtCore, QtGui
import pandas as pd
Qt = QtCore.Qt
class PandasModelEditable(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=QtCore.Qt.DisplayRole):
if index.isValid():
if role == QtCore.Qt.DisplayRole or role == QtCore.Qt.EditRole:
return unicode(self._data.iloc[index.row(), index.column()])
return None
def headerData(self, section, orientation, role=QtCore.Qt.DisplayRole):
if role != QtCore.Qt.DisplayRole:
return None
if orientation == QtCore.Qt.Horizontal:
try:
return '%s' % unicode(self._data.columns.tolist()[section])
except (IndexError,):
return unicode()
elif orientation == QtCore.Qt.Vertical:
try:
return '%s' % unicode(self._data.index.tolist()[section])
except (IndexError,):
return unicode()
def flags(self, index):
return QtCore.Qt.ItemIsEnabled | QtCore.Qt.ItemIsSelectable | \
QtCore.Qt.ItemIsEditable
def setData(self, index, value, role=QtCore.Qt.EditRole):
if index.isValid():
self._data.iloc[index.row(), index.column()] = value
if self.data(index, QtCore.Qt.DisplayRole) == value:
self.dataChanged.emit(index, index)
return True
return False
if __name__ == '__main__':
application = QtGui.QApplication(sys.argv)
view = QtGui.QTableView()
df = pd.DataFrame([[1, 2, 3], [4, 5, 6]], columns=['a', 'b', 'c'], index=['x', 'y'])
model = PandasModelEditable(df)
view.setModel(model)
view.show()
sys.exit(application.exec_())