$12\mathrm{.}9$ LAB: Course Grade$12\mathrm{.}9$ LAB: Course Grade

Write a program that reads the student information from a tab separated values $($tsv$)$ file. The program then creates a text file that records the course grades of the students. Each row of the tsv file contains the Last Name, First Name, Midterm$1$ score, Midterm$2$ score, and the Final score of a student. A sample of the student information is provided in StudentInfo.tsv$.$ Assume the number of students is at least $1$ and at most $20.$ Assume also the last names and first names do not contain whitespaces.

The program performs the following tasks:

Read the file name of the tsv file from the user.

Open the tsv file and read the student information.

Compute the average exam score of each student.

Assign a letter grade to each student based on the average exam score in the following scale:

A: $90=$ x

B: $80=$ x $<mtext></mtext><mn>9</mn><mn>0</mn>$

C: $70=$ x $<mtext></mtext><mn>8</mn><mn>0</mn>$

D: $60=$ x $<mtext></mtext><mn>7</mn><mn>0</mn>$

F: x $<mtext></mtext><mn>6</mn><mn>0</mn>$

Compute the average of each exam.

Output the last names, first names, exam scores, and letter grades of the students into a text file named report.txt$.$ Output one student per row and separate the values with a tab character.

Output the average of each exam, with two digits after the decimal point, at the end of report.txt$.$ Hint: Use the format specification to set the precision of the output.

Ex: If the input of the program is:

StudentInfo.tsv

and the contents of StudentInfo.tsv are:

Barrett Edan $704559$

Bradshaw Reagan $969788$

Charlton Caius $739480$

Mayo Tyrese $886136$

Stern Brenda $908645$

the file report.txt should contain:

Barrett Edan $704559$ F

Bradshaw Reagan $969788$ A

Charlton Caius $739480$ B

Mayo Tyrese $886136$ D

Stern Brenda $908645$ C

Averages: midterm$183\mathrm{.}40,$ midterm$276\mathrm{.}60,$ final $61\mathrm{.}60$

Write a program that reads the student information from a tab separated values $($tsv$)$ file. The program then creates a text file that records the course grades of the students. Each row of the tsv file contains the Last Name, First Name, Midterm$1$ score, Midterm$2$ score, and the Final score of a student. A sample of the student information is provided in StudentInfo.tsv$.$ Assume the number of students is at least $1$ and at most $20.$ Assume also the last names and first names do not contain whitespaces.

The program performs the following tasks:

Read the file name of the tsv file from the user.

Open the tsv file and read the student information.

Compute the average exam score of each student.

Assign a letter grade to each student based on the average exam score in the following scale:

A: $90=$ x

B: $80=$ x $<mtext></mtext><mn>9</mn><mn>0</mn>$

C: $70=$ x $<mtext></mtext><mn>8</mn><mn>0</mn>$

D: $60=$ x $<mtext></mtext><mn>7</mn><mn>0</mn>$

F: x $<mtext></mtext><mn>6</mn><mn>0</mn>$

Compute the average of each exam.

Output the last names, first names, exam scores, and letter grades of the students into a text file named report.txt$.$ Output one student per row and separate the values with a tab character.

Output the average of each exam, with two digits after the decimal point, at the end of report.txt$.$ Hint: Use the format specification to set the precision of the output.

Ex: If the input of the program is:

StudentInfo.tsv

and the contents of StudentInfo.tsv are:

Barrett Edan $704559$

Bradshaw Reagan $969788$

Charlton Caius $739480$

Mayo Tyrese $886136$

Stern Brenda $908645$

the file report.txt should contain:

Barrett Edan $704559$ F

Bradshaw Reagan $969788$ A

Charlton Caius $739480$ B

Mayo Tyrese $886136$ D

Stern Brenda $908645$ C

Averages: midterm$183\mathrm{.}40,$ midterm$276\mathrm{.}60,$ final $61\mathrm{.}60$

my code: def calculate$\_$grade$($score$)$:

if score $>=90$:

return $\text{'}$A$\text{'}$

elif score $>=80$:

return $\text{'}$B$\text{'}$

elif score $>=70$:

return $\text{'}$C$\text{'}$

elif score $>=60$:

return $\text{'}$D$\text{'}$

else:

return $\text{'}$F$\text{'}$

def main$()$:

file$\_$name $=$ input$("$Enter the name of the TSV file: $")$

try:

with open$($file$\_$name, $\text{'}$r$\text{'})$ as file:

lines $=$ file.readlines$()$

student$\_$grades $=[]$

for line in lines:

parts $=$ line.strip$().$split$()$ # Changed this line

last$\_$name, first$\_$name, midterm$1,$ midterm$2,$ final $=$ parts

midterm$1=$ int$($midterm$1)$

midterm$2=$ int$($midterm$2)$

final $=$ int$($final$)$

average$\_$score $=($midterm$1+$ midterm$2+$ final$)/3$

letter$\_$grade $=$ calculate$\_$grade$($average$\_$score$)$

student$\_$grades.append$(($last$\_$name, first$\_$name, midterm$1,$ midterm$2,$ final, letter$\_$grade$))$

with open$(\text{'}$report$.$txt$\text{'},\text{'}$w$\text{'})$ as report$\_$file:

for student in student$\_$grades:

report$\_$file.write$(\text{'}\backslash$t$\text{'}.$join$($map$($str$,$ student$))+\text{'}$

$\text{'})$

# Calculate averages

midterm$1\_$avg $=$ sum$($student$[2]$ for student in student$\_$grades$)/$ len$($student$\_$grades$)$

midterm$2\_$avg $=$ sum$($student$[3]$ for student in student$\_$grades$)/$ len$($student$\_$grades$)$

final$\_$avg $=$ sum$($student$[4]$ for student in student$\_$grades$)/$ len$($student$\_$grades$)$

report$\_$file.

error im getting in picture attached. in python please!