Question

Please in Python:

Studentlist.txt:

1237, Davis, Michael

1244, White, Ronald

2365, Smith, Jason

3458, Wilson, Robert

Gradebook.txt:

1237,1,87

1244,1,79

2365,1,86

2365,2,96

3458,1,88

3458,8,68

1237,2,84

1237,3,90

1244,4,96

1244,6,83

2365,3,73

2365,5,74

3458,7,70

3458,2,89

3458,3,77

2365,4,89

1237,4,78

1244,3,89

2365,6,86

3458,4,84

3458,5,93

1244,2,88

1237,5,86

2365,7,92

3458,6,67

1244,5,72

Modify the gradebook assignment that you created by combining the student records and

the grades into an array.

Calculate the average and grades from the info in the array.

Add the average and grade to the student record in the array.

After all the records have been processed and calculations are complete, print the array.

The complete program output is:

[['1237', 'Davis', 'Michael', '87', '84', '90', '78', '86', '85.0', 'B'], ['1244', 'White', 'Ronald',

'79', '96', '83', '89', '88', '72', '84.5', 'B'], ['2365', 'Smith', 'Jason', '86', '96', '73', '74', '89',

'86', '92', '85.14', 'B'], ['3458', 'Wilson', 'Robert', '88', '68', '70', '89', '77', '84', '93', '67',

'79.5', 'C']]

Do this program a section at a time.

Get the data from the student file and build the first part of the array (the student info)

Get the data from the grade file and append each of the scores to the correct student.

Compute the grade based on the scores. Will have to loop through using the length.

Add the computed average and grade to each student’s record.

Answer 1

// For any doubt, feel free to comment.

CODE with Comments:-

#List of Students
studentlist=[]

# Function to read student file
def read_students():
    f = open("Studentlist.txt", "r")
    for x in f:
        # Removing \n from end
        x = x.split("\n")
        x = x[0]
        # Splitting line by ,
        s = x.split(",")
        studentlist.append(s)
    f.close()

# Function to read Gradebook file
def read_gradebook():
    f = open("Gradebook.txt","r")
    for x in f:
        # Removing \n from end
        x = x.split("\n")
        x = x[0]
        # Splitting line by ,
        x = x.split(",")
        # Checking for student ID
        for j in studentlist:
            if j[0] == x[0]:
                j.append(x[2])

# Function to append average
def append_average():
    for x in studentlist:
        cnt=0
        sum=0
        # Calculating sum for all its marks
        for i in range(3,len(x)):
            cnt+=1
            sum=sum+(int(x[i]))
        aver = sum/cnt
        # Rounding average up to 2 decimal places
        aver = int(aver*100)
        aver = aver/100
        # Appending average
        x.append(str(aver))

# Function to append Grade
def append_grade():
    for x in studentlist:
        # Accessing the average
        aver = float(x[len(x)-1])
        # Deciding grade according to average
        if aver > 90 :
            x.append("A")
        elif aver > 80 :
            x.append("B")
        elif aver > 70 :
            x.append("C")


read_students()
read_gradebook()
append_average()
append_grade()
print(studentlist)
print()

for x in studentlist:
    print(x)

Code Snippets:-

Output:-