In python, Im not getting an output for this code.import csvtsv_name=input("Enter tsv file name : ")tsv_file=open(tsv_name)read_tsv = csv.reader(tsv_file, delimiter="\t")f=open("report.txt","w")student_cnt=0m1_avrg=0m2_avrg=0fexam_avrg=0for row in read_tsv:student_cnt+=1lname=row[0]fname=row[1]m1=int(row[2])m2=int(row[3])fexam=int(row[4])avrg=(m1+m2+fexam)/3grade=" "if(avrg>=90.0):grade="A"elif(avrg>=80.0):grade="B"elif(avrg>=70.0):grade="C"elif(avrg >=60.0):grade="D"else:grade="F"f.write("%s\t%s\t%d\t%d\t%d\t%s\n"%(lname,fname,m1,m2,fexam,grade))m1_avrg+=m1m2_avrg+=m2fexam_avrg+=fexamm1_avrg=(m1_avrg/student_cnt)m2_avrg=(m2_avrg/student_cnt)fexam_avrg=(fexam_avrg/student_cnt)f.write("Averages: midterm1 {0:.2f},\tmidterm2 {1:.2f},\tfinal {2:.2f}".format(m1_avrg,m2_avrg,fexam_avrg))f.close() 14.5 LAB^: Course GradeWrite a program that reads the student information from a comma separated values (csv) file. The program then creates a text file thatrecords the course grades of the students. Each row of the file contains the Last Name, First Name, Midterm1 score, Midterm2 score, andthe Final score of a student each separated by a comma. A sample of the student information is provided in Studentlnfo.txt. Assume thenumber of students is at least 1 and at most 20. The program performs the following tasks:• Read the file name of the file from the user.Open the text 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:o A: 90 =< xo B: 80 =< x < 90o C: 70 =< x < 80o D: 60 =< x < 70o F:x< 60• 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 onestudent 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 precision sub-specifierto format the output.Ex: If the input of the program is:StudentInfo.txtand the contents of Studentlnfo.txt are:Barrett,Edan,70,45,59Bradshaw, Reagan, 96,97,88Charlton, Caius,73,94, 80Mayo, Tyrese, 88,61,36Stern, Brenda,90,86,45the file report.txt should contain:BarrettEdan704559 FBradshawReagan969788ACharltonCaius739480BMayoTyrese886136 DSternBrenda068645Averages: Midterm1 83.40, Midterm2 76.60, Final 61.60

Answered: In python, Im not getting an output for…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

100%

In python, Im not getting an output for this code.

import csv

tsv_name=input("Enter tsv file name : ")
tsv_file=open(tsv_name)
read_tsv = csv.reader(tsv_file, delimiter="\t")
f=open("report.txt","w")
student_cnt=0
m1_avrg=0
m2_avrg=0
fexam_avrg=0
for row in read_tsv:
student_cnt+=1
lname=row[0]
fname=row[1]
m1=int(row[2])
m2=int(row[3])
fexam=int(row[4])
avrg=(m1+m2+fexam)/3
grade=" "
if(avrg>=90.0):
grade="A"
elif(avrg>=80.0):
grade="B"
elif(avrg>=70.0):
grade="C"
elif(avrg >=60.0):
grade="D"
else:
grade="F"

f.write("%s\t%s\t%d\t%d\t%d\t%s\n"%(lname,fname,m1,m2,fexam,grade))

m1_avrg+=m1
m2_avrg+=m2
fexam_avrg+=fexam

m1_avrg=(m1_avrg/student_cnt)
m2_avrg=(m2_avrg/student_cnt)
fexam_avrg=(fexam_avrg/student_cnt)

f.write("Averages: midterm1 {0:.2f},\tmidterm2 {1:.2f},\tfinal {2:.2f}".format(m1_avrg,m2_avrg,fexam_avrg))
f.close()

14.5 LAB^: Course Grade
Write a program that reads the student information from a comma separated values (csv) file. The program then creates a text file that
records the course grades of the students. Each row of the file contains the Last Name, First Name, Midterm1 score, Midterm2 score, and
the Final score of a student each separated by a comma. A sample of the student information is provided in Studentlnfo.txt. Assume the
number of students is at least 1 and at most 20. The program performs the following tasks:
• Read the file name of the file from the user.
Open the text 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:
o A: 90 =< x
o B: 80 =< x < 90
o C: 70 =< x < 80
o D: 60 =< x < 70
o F:x< 60
• 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 precision sub-specifier
to format the output.
Ex: If the input of the program is:
StudentInfo.txt
and the contents of Studentlnfo.txt are:
Barrett,Edan,70,45,59
Bradshaw, Reagan, 96,97,88
Charlton, Caius,73,94, 80
Mayo, Tyrese, 88,61,36
Stern, Brenda,90,86,45
the file report.txt should contain:
Barrett
Edan
70
45
59 F
Bradshaw
Reagan
96
97
88
A
Charlton
Caius
73
94
80
B
Mayo
Tyrese
88
61
36 D
Stern
Brenda
06
86
45
Averages: Midterm1 83.40, Midterm2 76.60, Final 61.60

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions