在数据框中搜索重复项(Python)

import pandas as pd

# 创建一个示例数据框
data = {'Name': ['John', 'Mike', 'Sarah', 'Mike', 'John'],
        'Age': [28, 32, 25, 32, 28],
        'City': ['New York', 'Los Angeles', 'Chicago', 'Los Angeles', 'New York']}
df = pd.DataFrame(data)

# 搜索重复项
duplicates = df.duplicated()

# 打印重复项
print(df[duplicates])

   Name  Age         City
3  Mike   32  Los Angeles
4  John   28     New York

import pandas as pd

# 创建一个示例数据框
data = {'Name': ['John', 'Mike', 'Sarah', 'Mike', 'John'],
        'Age': [28, 32, 25, 32, 28],
        'City': ['New York', 'Los Angeles', 'Chicago', 'Los Angeles', 'New York']}
df = pd.DataFrame(data)

# 删除重复项
df = df.drop_duplicates()

# 打印结果
print(df)

   Name  Age         City
0  John   28     New York
1  Mike   32  Los Angeles
2  Sarah  25      Chicago