从大型pandas数据帧中设置QAbstractTableModel中选定列的格式

import pandas as pd
from PyQt5.QtCore import QAbstractTableModel, Qt

class DataFrameModel(QAbstractTableModel):
    def __init__(self, data):
        super().__init__()
        self._data = data

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

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

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

    def headerData(self, section, orientation, role=Qt.DisplayRole):
        if role == Qt.DisplayRole:
            if orientation == Qt.Horizontal:
                return str(self._data.columns[section])
            elif orientation == Qt.Vertical:
                return str(self._data.index[section])
        return None

def set_column_format(dataframe, column_index, format):
    column_name = dataframe.columns[column_index]
    dataframe[column_name] = dataframe[column_name].map(format.format)

data = pd.read_csv('data.csv')  # 根据实际数据路径进行修改
model = DataFrameModel(data)

set_column_format(data, column_index, format)

model = DataFrameModel(data)