Question

I need this in Python Please!

The college IT department manager no longer wants to use spreadsheets to calculate grades. The manager has asked you to create a program that will input the teachers' files and output the students' grades.

In your Python environment, the program must read an input file formatted in CSV format, named input.csv. Each record contains data about a student and their corresponding grades.

The data will look similar to the following:

Student Name, assignment 1, assignment 2, assignment 3, assignment 4

John Adams, 90, 91, 99, 98

Paul Newman, 90, 92, 93, 94

Mary Smith, 95, 96, 99

Be careful to follow the output format exactly, including spacing. The output of your program must look like the following:

Student Assignment Average

John Adams    94.5

Compress your files into a ZIP folder.

Answer 1

Here is code:

import csv

import csv

def determine_grade(avg):
avg = int(avg)
if avg >= 90 and avg <= 100:
return 'A'
elif avg >= 80 and avg <= 89:
return 'B'
elif avg >= 70 and avg <= 79:
return 'C'
elif avg >= 60 and avg <= 69:
return 'D'
elif avg <= 60:
return 'F'

for r in (csv.reader(open("Q:\cpp\python\\file\grades.csv", 'r'))):
sum = 0
for i in range(1, len(r)):
sum += int(r[i])
avg = sum / (len(r) -1)
letter = determine_grade(avg)
print(r[0] ,"-", avg ," - ", letter)

grades.csv:

John Adams, 90, 91, 99, 98
Paul Newman, 90, 92, 93, 94
Mary Smith, 95, 96, 99

Output: