Question

Please include screenshot of coding and program running - Python. Thanks in advance!!

Task description You are given a student result data file (result.csv). It has columns ID: student id Assi ~ Ass4: assignment scores (out of 100); weight of assi, ass2, ass and ass4 is 5%, 15%, 5%, and 15%, respectively Exam: examination score (out of 120); weight is 60%. Hurdle is 40% of exam total (48) Total: weighted total result (5%" (ass1+ass3) + 15%" (ass2+ass4) + 60%"exam) ID Ass1 Ass2 Ass3 Ass4 Exam Total 89.1 95.1 74.3 89.8 91.3 50 82.5 54.4 81.3 98.8 85 90.5 63 82 92.5 88.9 94.5 63.9 90.4 95.9 65 52 31 37 79 63 42 53 2 4 5 (The above data is for demonstration purposes only. Please download the full version of result.csv.) To pass the unit, a student must achieve at least total >= 50 and exam score > 48. Total score has been provided in the.csv. There is no need for you to re-calculate it. Read students' result data from file result.csv, calculate and print . Average of ass1, ass2, ass3, ass4, exam and total column, respectively . Min of ass1, ass2, ass3, ass4, exam and total column, respectively » Max of ass1, ass2, ass3, ass4, exam and total column, respectively

Answer 1

Explanation::

• Code in PYTHON is given below
• Screenshot of the OUTPUT is given at the end of the code

Code in PYTHON::

import csv

ass1List=[]
ass2List=[]
ass3List=[]
ass4List=[]
examList=[]
totalList=[]
with open('data.csv') as csv_file:
    csv_reader = csv.reader(csv_file, delimiter=',')
    first = True
    index=0
    for row in csv_reader:
        if first:
            first=False
        else:
            ass1List.insert(index, row[1])
            ass2List.insert(index, row[2])
            ass3List.insert(index, row[3])
            ass4List.insert(index, row[4])
            examList.insert(index, row[5])
            totalList.insert(index, row[6])
            index=index+1



def calculateAverageMinMax(listArray):
    sum=float(listArray[0])
    minimum=float(listArray[0])
    maximum=float(listArray[0])
    for i in range(1,len(listArray)):
        val=float(listArray[i])
        sum=sum+val
        if val<minimum:
            minimum=val
        if val>maximum:
            maximum=val
    average=sum/len(listArray)
    return [average,minimum,maximum]



ass1Answer = calculateAverageMinMax(ass1List)
ass2Answer = calculateAverageMinMax(ass2List)
ass3Answer = calculateAverageMinMax(ass3List)
ass4Answer = calculateAverageMinMax(ass4List)
examAnswer = calculateAverageMinMax(examList)
totalAnswer = calculateAverageMinMax(totalList)

print("        AVERAGE   MINIMUM   MAXIMUM")
print("Ass1   ",ass1Answer[0],"   ",ass1Answer[1],"   ",ass1Answer[2])
print("Ass2   ",ass2Answer[0],"   ",ass2Answer[1],"   ",ass2Answer[2])
print("Ass3   ",ass3Answer[0],"   ",ass3Answer[1],"   ",ass3Answer[2])
print("Ass4   ",ass4Answer[0],"   ",ass4Answer[1],"   ",ass4Answer[2])
print("Exam   ",examAnswer[0],"   ",examAnswer[1],"   ",examAnswer[2])
print("Total  ",totalAnswer[0],"   ",totalAnswer[1],"   ",totalAnswer[2])

data.csv:

ID,Ass1,Ass2,Ass3,Ass4,Exam,Total
1,89.1,50,85,88.9,65,66
2,95.1,82.5,90.5,94.5,52,63
3,74.3,54.4,63,63.9,31,42
4,89.8,81.3,82,90.4,37,53
5,91.3,98.8,92.5,95.9,79,77

OUTPUT::

Please provide the feedback!!

C: \Users\ Bhushan\PycharmProjects\Graphics venv AVERAGE MINIMUM MAXIMUM 87.92 73.4 82.6 86.72 52.8 74.3 50.0 63.0 Ass1 Ass2 Ass3 Ass4 Exam Total 60.2 95.1 98.8 92.5 63.9 31.0 42.0 95.9 79.Θ Process finished with exit code

Thank You!!