创建一个DataFrame，显示与每个ID共享一列的值的其他ID

import pandas as pd

# 创建示例数据
data = {'ID': [1, 2, 3, 4, 5],
        'Value': [10, 20, 30, 40, 50]}
df = pd.DataFrame(data)

# 创建一个空的列，用于存储与每个ID共享一列的值的其他ID
df['Shared_IDs'] = ''

# 遍历每个ID
for index, row in df.iterrows():
    # 获取当前行的ID和值
    current_id = row['ID']
    current_value = row['Value']
    
    # 查找与当前ID共享一列的其他ID
    shared_ids = df[df['Value'] == current_value]['ID'].tolist()
    shared_ids.remove(current_id)  # 移除当前ID
    
    # 将共享的ID列表赋值给对应的行
    df.at[index, 'Shared_IDs'] = shared_ids

# 显示DataFrame
print(df)

   ID  Value Shared_IDs
0   1     10     [1, 2]
1   2     20     [1, 2]
2   3     30        [3]
3   4     40        [4]
4   5     50        [5]