import pandas as pd df = pd.read_csv('Nowcoder.csv') sub_df = df[df['Level'] ==7] seven = sub_df['Achievement_value']/df['Achievement_value'].sum() print(seven)