import pandas as pd df = pd.read_csv('Nowcoder.csv') df['成就值总和'] = df['Achievement_value'].sum() percentage = df.query("Level == 7")['Achievement_value'] / df['成就值总和'] print(percentage)