Question

Can someone help me with this problem? I have been struggling with Python 3 for a while now and not even the professor would help me solve this problem. I have to import a file called grades.csv and use error handling for a mid-semester report. please help me, I have been having trouble understand import csv. You don't have to check for errors or anything like that. I just have to display the mid-semester report

This project will have you using error handling and file handling to display mid semester report with percentage of student work and their grade. The 'Students.csv file contains students name, exam1 score, exam 2 score, assignment 1 and assignment 2 scores as well. All tasks are out of 100 each. The 'Students' are .csv, you may find using the csv module easier to use. However, you can always read in a line and use. split. Requirements • Ask the user for the name of the file to open. It should continually ask until the user responds with a file that can be opened. The user may enter quit and the program will exit • You will need to read each row in the following order (Name, Exam 1, Exam 2, Assignment 1, and Assignment 2). • You will need to calculate student percentage in each section as follow. • Exam 1 worth 10% of total grade. o Exam 2 worth 10% of total grade. o Assignment 1 worth 5% of total grade. o Assignment 2 worth 5% of total grade. • Total percentage ( out of 30%) is Exam1%+Exam2%+Assignemt1%+Assignment2% You will need to calculate an estimate for student grade as follow Student percent score (out of 100%) = (Total percentage/30)*100 You will need also to display student grade depending on the following: 'A' is 91% and above o 'B' is 81%- to 90% 'B-' is 71%-80% o 'C' is 61%-70% o 'F' is <=60 You will read data from Students.csv and output all the above requirements to Students_grade.csv (Name,Exam1 score, Exam2 score, Assignment1 score, Assignment2 Score, Exam 1%, Exam2%, Assignment1%, Assignment2%, Total% out of 30%, Total% out of 100%, Grade).

Answer 1

Python csv module provides 2 main different reading functions : reader() and DictrRader().

I recommend that you use DictReader() as it will give you dictionaries which have column names as keys.

Code for loading data :

import csv

file_name = "Students.csv"

csv_in = open(file_name, 'r', newline='')

data = csv.DictReader(csv_in, delimiter=',')  #read data from specified file

Once the data is loaded, you can iterate through all rows simply by using for rows in data as shown below:

[17] DEM! import csv file_name = "Students.csv" csv_in = open(file_name, 'r', newline=")|| data = csv.DictReader(csv_in, delimiter=',') #read data from specified file for row in data: print (row) {'name': 'abc', 'exami': '70', 'exam2': '90', 'assgni': '80', 'assgn2': '82'} {'name': 'xyz', 'exami': '75', 'exam2': '75', 'assgni': '80', 'assgn2': '74'}

And you can access particular columns using them as dictionary keys, For example if i want to calculate total score of exam1 & exam2 for all students, i can do:

for row in data: print (row) row["exam_total"] = float(row["exam1"])+float(row["exam2"]) print("Total of exams: ",row["exam_total"]]|| 160.0 {'name': 'abc', 'examl': '70', 'exam2': '99', 'assgni': '80', 'assgn2': '82'} Total of exams: {'name': 'xyz', 'exami': '75', 'exam2': '75', 'assgni': '80', 'assgn2': '74'} Total of exams: 150.0

This way, you can complete all your required calculations. I hope this solves your query.

(*Note: Please up-vote if you find it helpful. If any doubt, please let me know in the comments)