import pandas as pd df = pd.read_csv('Nowcoder.csv') true_per = df.query("Num_of_exercise > 10")['Num_of_exercise'] / df.query("Num_of_exercise > 10")['Number_of_submissions'] print(true_per.round(3).max())