比较两个文件之间的第2列，并将输出与所有其他列一起打印

import csv

def compare_files(file1, file2):
    with open(file1, 'r') as f1, open(file2, 'r') as f2:
        reader1 = csv.reader(f1, delimiter=',')
        reader2 = csv.reader(f2, delimiter=',')

        header1 = next(reader1)
        header2 = next(reader2)

        # Find the index of the second column
        col_idx = header1.index('Column2')

        # Store the rows with the second column value from file1
        file1_rows = []
        for row in reader1:
            file1_rows.append(row)

        # Compare the second column value from file2 with file1
        for row in reader2:
            col_value = row[col_idx]
            for file1_row in file1_rows:
                if col_value == file1_row[col_idx]:
                    # Print all columns from both files
                    print(','.join(file1_row + row))
                    break

# Example usage
compare_files('file1.csv', 'file2.csv')