PLEASE DO NOT COPY AND PASTE FROM CHEGG; IF YOU DO, I WILL REPORT YOU.

PROBLEM DESCRIPTION: The given csv file (.e. student_data.csv) entails data from the Gradebook of a fictitious version of the course: SYST/CYSE-130. Overall students completed 3 Quizzes, 3 Tests, and 2 Exams. A subsection of the data is shown in the table below. Q2 6.1 G-ID GOM0011 GOMO039 GOMO067 GOMO095 GOM0123 GOMO151 First_Name Last_Name Q1 Wayne Green 9.8 Leigh Wood 9.51 Katrina Coleman 6.2 Lee Butler 9.02 Stephanie 9.91 Claire Lewis 7.85 9.34 8.61 7.81 6.16 6.8 Q3 T1 9.18 11.69 6.75 14.26 7.29 11.23 5.19 12.95 7.34 13.74 8.46 10.93 T2 11.4 14.53 11.93 13.39 14.94 T3 12.55 10.03 14.33 13.5 12.4 Ex1 Ex2 23.94 24.93 21.9 19.48 24.5 21.93 20.88 20.2 22.82 23.67 21 24.95 Bell 14.48 8.05 REQUIREMENTS: Write a Python program that shall read the given data, and generate a new csv file with name 'graded_data.csv'. This new file shall have 2 additional columns containing each student's total score and final grade. Use "Total" and "Grade" as headers for the new columns. To calculate a student's total score; take the sum of the best two quizzes, the best two tests and the 2 exam scores (i.e. drop the least scores on the quizzes and the tests). Additionally, the total score should be round to the nearest whole number. To calculate a student's grade, compare their calculated total score against the following criteria: 90-100= A, 80-89= B, 70-79= C, 60-69=D 59 or less F As an example, the total score and grade for a single record in the new graded_data.csv file shall be as shown below. G-ID First_Name Last_Name Q1 Q2 Q3 T2 T3 Ex1 Total Grade GOM0001 Matt Amissah 9.990 14.99 10.0 25.0 24.99 100 T1 EX2 10.0 15.0 A