import pandas as pd
import functools
#STEP0: DEFINE DATA ELEMENTS- SCORE CARD AND STUDENT SCORES
#SCORE CARD DATA
score_card_data = {
        'subject_id': ['MATHS', 'SCIENCE', 'ARTS'],
        'bin_list': [[0,25,50,75,100], [0,20,40,60,80,100], [0,20,40,60,80,100]],
        'bin_value': [[1,2,3,4], [1,2,3,4,5], [3,4,5,6,7] ],
        'score_basis':[['STUDENT_ID','MATH_MARKS'],['STUDENT_ID','SCIENCE_MARKS'],['STUDENT_ID','ARTS_MARKS']],
        'score_output':[['MATHS_SCORE'],['SCIENCE_SCORE'],['ARTS_SCORE']]}
score_card_data = pd.DataFrame(score_card_data, columns = ['subject_id', 'bin_list', 'bin_value','score_basis','score_output'])


#STUDENT MARKS DATA
student_marks = {
        'STUDENT_ID': ['S1', 'S2', 'S3','S4','S5'],
        'MATH_MARKS': [10,15,25,65,75],
        'SCIENCE_MARKS': [8,15,20,35,85],
        'ARTS_MARKS':[55,90,95,88,99]}
student_marks = pd.DataFrame(student_marks, columns = ['STUDENT_ID', 'MATH_MARKS', 'SCIENCE_MARKS','ARTS_MARKS'])

list_subjects = (element.upper() for element in list(score_card_data['subject_id']))
for i,sub in enumerate(list_subjects) :
    print(("bins_{1:s}").format(i,sub))
    print("list(score_card_data.loc[score_card_data['subject_id'] == {1:s}, 'bin_list'])").format(i,sub)

bins_MATHS
list(score_card_data.loc[score_card_data['subject_id'] == MATHS, 'bin_list'])
bins_SCIENCE
list(score_card_data.loc[score_card_data['subject_id'] == SCIENCE, 'bin_list'])
bins_ARTS
list(score_card_data.loc[score_card_data['subject_id'] == ARTS, 'bin_list'])

bins_MATHS = list(score_card_data.loc[score_card_data['subject_id'] == 'MATHS', 'bin_list'])