如何删除重复的熊猫

CREATE TABLE pandas (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    age INT,
    gender CHAR(1)
);

SELECT name, COUNT(*)
FROM pandas
GROUP BY name
HAVING COUNT(*) > 1;

DELETE FROM pandas
WHERE id NOT IN (
    SELECT MIN(id)
    FROM pandas
    GROUP BY name
);

class Panda:
    def __init__(self, name, age, gender):
        self.name = name
        self.age = age
        self.gender = gender

pandas = [
    Panda('Ailuropoda melanoleuca', 5, 'M'),
    Panda('Ailuropoda melanoleuca', 3, 'F'),
    Panda('Ailuropoda melanoleuca', 5, 'M')
]

# 使用集合去重
unique_pandas = list({(panda.name, panda.age, panda.gender): panda for panda in pandas}.values())

import os
import hashlib

def hash_file(file_path):
    hasher = hashlib.md5()
    with open(file_path, 'rb') as f:
        buf = f.read(65536)
        while buf:
            hasher.update(buf)
            buf = f.read(65536)
    return hasher.hexdigest()

def find_duplicates(directory):
    hashes = {}
    duplicates = []
    for root, _, files in os.walk(directory):
        for filename in files:
            file_path = os.path.join(root, filename)
            file_hash = hash_file(file_path)
            if file_hash in hashes:
                duplicates.append(file_path)
            else:
                hashes[file_hash] = file_path
    return duplicates

# 删除重复文件
duplicates = find_duplicates('/path/to/panda/images')
for duplicate in duplicates:
    os.remove(duplicate)