如何在存在行的情况下更新CSV文件的列，或者如何使用临时文件附加到相同的CSV

import csv
import tempfile
import shutil

def update_csv_column(csv_file, column_index, new_values):
    # Step 1: Read CSV file
    with open(csv_file, 'r') as file:
        reader = csv.reader(file)
        rows = list(reader)

    # Step 2: Update column data
    for row in rows:
        row[column_index] = new_values.get(row[column_index], row[column_index])

    # Step 3: Write to temporary file
    with tempfile.NamedTemporaryFile(mode='w', delete=False) as temp_file:
        writer = csv.writer(temp_file)
        writer.writerows(rows)

    # Step 4: Append to original CSV file
    with open(csv_file, 'a') as file:
        with open(temp_file.name, 'r') as temp:
            shutil.copyfileobj(temp, file)

    # Step 5: Delete temporary file
    os.remove(temp_file.name)

# Example usage
csv_file = 'data.csv'
column_index = 2
new_values = {'A': 'Apple', 'B': 'Banana', 'C': 'Cherry'}
update_csv_column(csv_file, column_index, new_values)