Pandas根据重复行获取列值

import pandas as pd

# 创建示例数据
data = {'Name': ['John', 'Emma', 'John', 'Emma', 'John'],
        'Age': [25, 28, 25, 28, 25],
        'City': ['New York', 'London', 'Paris', 'Tokyo', 'Berlin']}
df = pd.DataFrame(data)

# 判断重复的行
duplicate_rows = df.duplicated()

# 获取重复行对应的列值
duplicate_names = df.loc[duplicate_rows, 'Name']
duplicate_ages = df.loc[duplicate_rows, 'Age']
duplicate_cities = df.loc[duplicate_rows, 'City']

print("重复的姓名：", duplicate_names.tolist())
print("重复的年龄：", duplicate_ages.tolist())
print("重复的城市：", duplicate_cities.tolist())