用于将行从一个CSV复制到另一个CSV并添加列的Python代码

import csv

def copy_csv_with_column(source_file, destination_file, column_name, column_value):
    with open(source_file, 'r') as source_csv, open(destination_file, 'w', newline='') as dest_csv:
        reader = csv.reader(source_csv)
        writer = csv.writer(dest_csv)
        
        # Read the header row from the source CSV
        header = next(reader)
        
        # Add the new column to the header
        header.append(column_name)
        
        # Write the modified header to the destination CSV
        writer.writerow(header)
        
        # Iterate over the rows in the source CSV
        for row in reader:
            # Add the column value to each row
            row.append(column_value)
            
            # Write the modified row to the destination CSV
            writer.writerow(row)

# Example usage
copy_csv_with_column('source.csv', 'destination.csv', 'New Column', 'Value')