搜索具有相同日期、时间(时间+/-30秒)和事件名称的重复行

SELECT date, time, event_name, COUNT(*) as count
FROM table_name
GROUP BY date, time, event_name
HAVING count > 1;

import csv

def find_duplicates(file_path):
    duplicates = {}
    with open(file_path, 'r') as file:
        reader = csv.reader(file)
        for row in reader:
            key = (row[0], row[1], row[2])  # Assuming date, time, event_name columns
            if key in duplicates:
                duplicates[key] += 1
            else:
                duplicates[key] = 1

    # Filter duplicates with count > 1
    duplicates = {key: value for key, value in duplicates.items() if value > 1}
    return duplicates

# Usage example
duplicates = find_duplicates('data.csv')
for key, value in duplicates.items():
    print(f"Duplicate rows with date {key[0]}, time {key[1]}, and event name {key[2]}: {value} occurrences")