Notifications
Clear all

Find maximum number of scholarships without exceeding total value of 500000

1 Posts
1 Users
0 Reactions
180 Views
nobite
(@nobite)
New Member
Joined: 11 months ago
Posts: 1
Topic starter  

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


   
ReplyQuote

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Share: