import pandas as pd
# 模拟校友数据
data = {
'name': ['张三', '李四', '王五'],
'active_score': [85, 90, 75],
'contribution': [10, 15, 5]
}
df = pd.DataFrame(data)
df['total_score'] = df['active_score'] * 0.6 + df['contribution'] * 0.4
df = df.sort_values(by='total_score', ascending=False)
print(df)