如何在插入表前检查csv文件是否有重复值

import csv

def check_csv_duplicates(file_path, column_index):
    values = set()
    duplicates = []
    
    with open(file_path, 'r') as csv_file:
        reader = csv.reader(csv_file)
        next(reader)  # Skip header row if exists
        
        for row_number, row in enumerate(reader, start=1):
            if row[column_index] in values:
                duplicates.append(row_number)
            else:
                values.add(row[column_index])
    
    if duplicates:
        print("Duplicate values found in rows:", duplicates)
        # Perform appropriate action for duplicate values
    else:
        print("No duplicate values found in the CSV file.")

# 示例用法
csv_file_path = "path/to/your/csv/file.csv"
column_to_check = 0  # 以第一列为例进行检查
check_csv_duplicates(csv_file_path, column_to_check)