I have a .csv file in the form:

ID        scholarship amount       applicant  experience
1          45000                           8
2          65000                           10
3          38000                           11
4          62000                           12
5          45000                           9
6          58000                           11
7          28000                           12
8          78000                           12
9          52500                           7
10         45000                           10

The question is write a code that finds maximum number of scholarships that can be offered without exceeding a total value of 500000. Only consider applicants with 10 or more years of experience.
I have tried df[df['applicant experience'] >=10] but still I am obtaining records with total scholarship amount above 500000. Please help