Python programming only

4. The csv file Grades includes the grades for 10 quizzes for a number of students. Write a program that reads the content of this file and performs the following tasks: a. It computes the average grades for each student and writes the name of the students and the average (rounded to two decimal places) in another csv file; add titles Student and Average for columns A and B. Add a blank line after the last students name. b. It computes the average grade for each Quiz. It writes the name of the quiz, e.g., Quiz01 in Column A and the average (rounded to two decimal places) in column B. c. Include an error handling feature in case the input file does not exist.

program template:

from csv import reader, writer

infile = open("Grades.csv") csvReader = reader(infile)

outfile = open("GradeOutfile.csv", "w", encoding="utf-8", newline = '') # Encoding csvWriter = writer(outfile)

#program here

infile.close() outfile.close()

Grade.csv file:

drive link to file ( https://drive.google.com/file/d/1i53RjK5_hgzIklQUdxJmEbEVdL4apqci/view?usp=sharing ) you can download the Grades.csv file from here as well.

Allen, Brian Almond, Mackenzie Almond, Steven Beese, Catherine Beese, Mary Kay Bowman, Luke Bowman, Sean Brading, Olivia Brewer, Annie Brinkley, Carson Brinkley, Mary Anni Cook, Chris Cook, Sue Ann Croft, Ben Davis, Aaron Eason, Megan Cason, Tyler Evans, Emily Farlow, Derek Jackson, Billy Bob Hanson, Noah Harrell, Rafael Hemandez, Marica Hernandez, Thomas Horton, Robin Huckins, Meredith Huckins, Virginia Hurleycutt, Addison Jackson, Rina Jacobson, Hannah Johnson, Nate Jones, Claire Jones, Goerge Henry Lowe, Maddie Lowe, Tabitha MacDonald, Lucas MacDonald, Sari Mallison, Henry Marino, James Martin, Brendan Mayfield, Elizabeth Murray, Mallory Murray, Taylor Noon, Joshua Padgett, Jenna Reckard, Bailey Robbins, Lindsey Ropers, Katie Sanchez, Jakob Scott, Anna Sealock, Edward Shepherd, Brianna Shortt, Ashley Sprinkle, Hope Stanfield, Adam Stonefield, Amrutha Surimers, Caleb Summers, Zack Thompson, Griffin Vance, Jonny Volansky, Patrick Walston, Amaya White, Nicole Qui01 QuizO2 Quiz 70 82 83 98 78 76 79 91 97 86 73 79 88 82 86 75 95 70 72 85 82 90 99 85 731 91 761 87 77 77 89 79 78 92 99 84 93 98 74 91 97 94 99 85 97 921 100 77 81 21 94 77 82 70 94 99 73 99 100 95 88 96 81 89 98 72 99 87 SO 80 86 741 78 87 95 79 92 82 819 84 89 71 75 93 95 71 85 91 97 96 97 73 814 75 87 93 70 97 97 77 93 70 88 97 98 70 97 92 87 881 721 891 721 741 881 96 74 981 90 88 811 75 Quiz04 Qui05 Quiz06 Quizo7 QUIZOR Quir09 84 83 85 78 97 83 90 78 871 76 88 921 85 73 813 94 79 85 98 81 71 88 88 87 94 96 77 93 91 81 99 92 836 81 75 75 74 81 71 84 93 90 76 781 78 781 82 71 791 75 781 98 97 76 93 77 91 91 98 711 71 97 85 87 79 93 94 88 79 100 84 90 78 80 99 87 93 88 73 97 73 77 92 78 79 791 95 87 90 72 71 86 92 97 100 80 70 86 941 71 94 89 97 95 96 100 79 90 85 89 81 721 92 100 96 85 851 75 92 86 78 93 961 100 76 90 76 82 93 89 81 100 731 87 83 80 B2 94 99 75 74 70 95 80 80 94 760 96 79 84 72 73 94 75 100 B4 91 88 86 70 84 89 83 93 76 99 73 75 71 90 99 100 83 91 82 81 79 78 73 841 87 921 98 93 78 99 86 241 99 75 89 74 81 75 79 76 881 91 83 79 91 97 79 79 86 815 819 76 721 98 92 751 74 79 89 92 81 73 98 87 95 95 86 971 77 74 98 95 88 100 95 94 76 88 82 75 73 90 85 B4 91 72 96 77 89 96 92 87 99 98 99 73 84 941 73 70 98 87 82 92 97 100 80 89 84 84 73 99 72 86 87 87 85 76 70 78 28 92 98 74 74 91 87 87 85 100 34 70 92 70 94 72 94 86 79 87 86 72 84 85 99 73 94 100 80 931 97 95 B8 71 88 96 89 82 73 91 72 90 72 96 96 94 78 98 91 $1 B& 98 97 89 92 99 89 78 91 85 94 83 89 73 75 751 991 77 97 84 85 83 85 98 79 84 100 771 811 86 99 88 93 981 981 831 91 75 70 72 82 911 971 86 89 74 89 891 751 94 791 Quiz 10 971 95 701 70 76 87 814 81 77 86 83 74 79 781 73 821 72 73 83 94 71 70 85 70 97 76 73 98 84 92 87 72 721 951 97 95 85 99 80 9.3 991 91 82 83 94 70 771 94 76 74 97 817 90 911 94 96 960 911 100 100 791 741 84 71 92 100 901 80 7 72 93 741 92 96 701 851 74 97 77 77 77 74 89 81 77 71 70 821 89 721 97 95 91 89 71 80 96 87 74 71 721 99 77 85 92 71 78 81 72 87 911 831 701 90 84 75 89 97 971 91 80 76 991 741 861 87 100