使用pandas统计关系表中的相互关注人数

import pandas as pd

data = pd.read_csv('关系表.csv')

mutual_followers = pd.DataFrame(columns=['User', 'Mutual Followers'])

for index, row in data.iterrows():
    user = row['User']
    followers = row['Followers']
    following = row['Following']
    
    mutual_count = len(set(followers) & set(following))
    
    mutual_followers = mutual_followers.append({'User': user, 'Mutual Followers': mutual_count}, ignore_index=True)

mutual_followers = mutual_followers.sort_values(by='Mutual Followers', ascending=False)

print(mutual_followers.head())