Programming, Data Structures And Algorithms Using Python - Week 5 Programming Assignment Jan-Jun 2022

 NPTEL PROGRAMMING ASSIGNMENTS

Programming, Data Structures And Algorithms Using Python

Week 5 Programming Assignment

Due Date of Submission 2022-03-03, 23:59 IST

Question:

The academic office at the Hogwarts School of Witchcraft and Wizardry has compiled data about students' grades. The data is provided as text from standard input in three parts: information about courses, information about students and information about grades. Each part has a specific line format, described below..

1. Information about courses
   Line format: Course Code~Course Name~Semester~Year~Instructor
2. Information about students
   Line format: Roll Number~Full Name
3. Information about grades
   Line format: Course Code~Semester~Year~Roll Number~Grade

The possible grades are A, AB, B, BC, C, CD and  D with corresponding grade points 10, 9, 8, 7, 6, 5 and 4. The grade point average of a student is the sum of his/her grade points divided by the number of courses. For instance, if a student has taken two courses with grades A and BC, the grade point average is 8.5 = (10+7)÷2. If a student has not completed any courses, the grade point average is defined to be 0.

You may assume that the data is internally consistent. For every grade, there is a corresponding course code and roll number in the input data.

Each section of the input starts with a line containing a single keyword. The first section begins with a line containing Courses. The second section begins with a line containing Students. The third section begins with a line containing Grades. The end of the input is marked by a line containing EndOfInput.

Write a Python program to read the data as described above and print out a line listing the grade point average for each student in the following format:


Roll Number~Full Name~Grade Point Average

Your output should be sorted by Roll Number. The grade point average should be rounded off to 2 digits after the decimal point. Use the built-in function round().

Here is a sample input and its corresponding output.


Input Format

Courses
TRAN~Transfiguration~1~2011-2012~Minerva McGonagall
CHAR~Charms~1~2011-2012~Filius Flitwick
Students
SLY2301~Hannah Abbott
SLY2302~Euan Abercrombie
SLY2303~Stewart Ackerley
SLY2304~Bertram Aubrey
SLY2305~Avery
SLY2306~Malcolm Baddock
SLY2307~Marcus Belby
SLY2308~Katie Bell
SLY2309~Sirius Orion Black
Grades
TRAN~1~2011-2012~SLY2301~AB
TRAN~1~2011-2012~SLY2302~B
TRAN~1~2011-2012~SLY2303~B
TRAN~1~2011-2012~SLY2305~A
TRAN~1~2011-2012~SLY2306~BC
TRAN~1~2011-2012~SLY2308~A
TRAN~1~2011-2012~SLY2309~AB
CHAR~1~2011-2012~SLY2301~A
CHAR~1~2011-2012~SLY2302~BC
CHAR~1~2011-2012~SLY2303~B
CHAR~1~2011-2012~SLY2305~BC
CHAR~1~2011-2012~SLY2306~C
CHAR~1~2011-2012~SLY2307~B
CHAR~1~2011-2012~SLY2308~AB
EndOfInput



Output Format

SLY2301~Hannah Abbott~9.5
SLY2302~Euan Abercrombie~7.5
SLY2303~Stewart Ackerley~8.0
SLY2304~Bertram Aubrey~0
SLY2305~Avery~8.5
SLY2306~Malcolm Baddock~6.5
SLY2307~Marcus Belby~8.0
SLY2308~Katie Bell~9.5
SLY2309~Sirius Orion Black~9.0

--Solution-- 

  Courses=[] while(True): i=input() if i=='Students': break Courses.append(i) Students=[] while(True): i=input() if i=='Grades': break Students.append(i) Grades=[] while(True): i=input() if i=='EndOfInput': break Grades.append(i) G=['A','AB','B','BC','C','CD','D'] l=10 for i in G: exec("%s = %d" % (i,l)) l-=1 lis=[] for i in range(len(Students)): n=0 m=0 x=0 for j in Grades: if Students[i][:7] in j: if j[-3]=='~': x+=1 if j[-2]+j[-1]=='AB': n+=AB if j[-2]+j[-1]=='BC': n+=BC if j[-2]+j[-1]=='CD': n+=CD if j[-2]=='~': x+=1 if j[-1]=='A': m+=A if j[-1]=='B': m+=B if j[-1]=='C': m+=C if j[-1]=='D': m+=D for j in range(1,10): if x==j: lis.append(Students[i]+'~'+str(round((n+m)/j,2))) if x==0: lis.append(Students[i]+'~'+str(0)) lis.sort() for i in lis: print(i)