如何在Tablewidget中将数据从一个文件转移到另一个文件

import csv
from PyQt5.QtWidgets import QApplication, QMainWindow, QTableWidget, QTableWidgetItem

# 读取源文件数据
source_file = 'source.csv'
data = []
with open(source_file, 'r') as file:
    csv_reader = csv.reader(file)
    for row in csv_reader:
        data.append(row)

# 创建应用程序和主窗口
app = QApplication([])
window = QMainWindow()

# 创建Tablewidget并加载数据
table_widget = QTableWidget(window)
table_widget.setRowCount(len(data))
table_widget.setColumnCount(len(data[0]))
for i, row in enumerate(data):
    for j, value in enumerate(row):
        item = QTableWidgetItem(value)
        table_widget.setItem(i, j, item)

# 创建目标文件并将数据写入
target_file = 'target.csv'
with open(target_file, 'w', newline='') as file:
    csv_writer = csv.writer(file)
    for i in range(table_widget.rowCount()):
        row = []
        for j in range(table_widget.columnCount()):
            item = table_widget.item(i, j)
            if item is not None:
                row.append(item.text())
            else:
                row.append('')
        csv_writer.writerow(row)

# 显示窗口
window.show()
app.exec_()