题解 | #大佬用户成就值比例#

import pandas as pd

df = pd.read_csv("Nowcoder.csv", sep=",")
pd.set_option("display.width", 300)  # 设置字符显示宽度
pd.set_option("display.max_rows", None)  # 设置显示最大行
pd.set_option("display.max_columns", None) 
# find all level 7 
df1 = df[df['Level'] == 7]
# sum the total achievement value
sum_all = df['Achievement_value'].sum()
# find the ratio between the ach_value of level 7 and total ach_value
print(df1['Achievement_value']/sum_all)