Python Needed:

Making a dictionary from a csv file for student records.

1)Each student has two courses. The grade for each course has 50% for homework, 20% midterm, and 30% for the final exam. Calculate the final grade of each course. Create a text file called 'gpa.txt' and write the name of the student and their GPA in that file.

2)Create a nested dictionary called records where each student is a key. Each student is a dictionary that has multiple courses. Each course is a key in the student dictionary. Each course is a dictionary containing key homework: which is a list, midterm:, and final:

then

Give the user the ability to search the records for data of a student by printing their courses and the grades. Prompt the user: Type in student name. If no match: student not in our records. Ability to add/delete students, course, and modify the course and grades

this is the file I am working with:

B C J Final 100 82.8 72.2 75.4 70.6 53.3 70.6 61.6 67.2 75.4 60.7 64.8 73 1 Student Course 1 2 HW1 Hw2 3 Points PO 100 4 Aaron, Han 92.7 5 Babbage, 76.2 6 Baker, Russ 85.5 7 Banks, Ernie 88.6 8 Carroll, Lev 57.7 9 Cash, John 94.8 10 Corey, Pete 76.2 11 Darwin, Ch 94.8 12 Davis, Bett 79.3 13 Fishback, 78.3 14 Ford, Harri 95.8 15 Gates, Bill 84.5 16 Hitchcock, 78.3 17 Huckabee, 88.6 18 Joyce, Jam 93.7 19 Kennedy, E 94.8 20 King, Steph 96.8 21 Martin, Ste 82.4 22 Olson, Ken 67 23 Picasso, Pa 94.8 24 Presley, El 90.6 25 Rogers, Wi 94.8 26 Schweitzer 80.3 27 Steinbeck, 89.6 28 Thatcher, 92.7 29 Warren, Rii 100 30 Zola, Emile 98.9 31 D E F G H Course 2 Midterm Final Hw1 Hw2 Midterm 100 100 100 100 100 100 90 90 88.2 88 79.2 77.6 74 95 93.1 92 81.1 83 88 86.2 86 77.4 75.9 86 67 65.7 65 58.5 57.3 56 88 86.2 86 77.4 75.9 92 78 76.4 75 67.5 66.2 74 84 82.3 82 73.8 72.3 92 95 93.1 92 82.8 81.1 77 77 75.5 74 66.6 65.3 76 81 79.4 79 71.1 69.7 93 92 90.2 89 80.1 78.5 82 93 91.1 90 81 79.4 76 97 95.1 94 84.6 82.9 86 86 84.3 84 75.6 74.1 91 76 74.5 73 65.7 64.4 92 91 89.2 88 79.2 77.6 94 90 88.2 88 79.2 77.6 80 98 96 95 85.5 83.8 65 81 79.4 79 71.1 69.7 92 93 91.1 90 81 79.4 88 92 90.2 89 80.1 78.5 92 91 89.2 88 79.2 77.6 78 79 77.4 77 69.3 67.9 87 96 94.1 89 80.1 78.5 90 87 85.3 96 86.4 84.7 98 94 92.1 91 81.9 80.3 96 93 91.1 85 76.5 75 73.8 77.1 68.9 59.9 72.2 72.2 77.9 64.8 73.8 73 72.2 63.1 73 78.8 74.7 69.8 B C J Final 100 82.8 72.2 75.4 70.6 53.3 70.6 61.6 67.2 75.4 60.7 64.8 73 1 Student Course 1 2 HW1 Hw2 3 Points PO 100 4 Aaron, Han 92.7 5 Babbage, 76.2 6 Baker, Russ 85.5 7 Banks, Ernie 88.6 8 Carroll, Lev 57.7 9 Cash, John 94.8 10 Corey, Pete 76.2 11 Darwin, Ch 94.8 12 Davis, Bett 79.3 13 Fishback, 78.3 14 Ford, Harri 95.8 15 Gates, Bill 84.5 16 Hitchcock, 78.3 17 Huckabee, 88.6 18 Joyce, Jam 93.7 19 Kennedy, E 94.8 20 King, Steph 96.8 21 Martin, Ste 82.4 22 Olson, Ken 67 23 Picasso, Pa 94.8 24 Presley, El 90.6 25 Rogers, Wi 94.8 26 Schweitzer 80.3 27 Steinbeck, 89.6 28 Thatcher, 92.7 29 Warren, Rii 100 30 Zola, Emile 98.9 31 D E F G H Course 2 Midterm Final Hw1 Hw2 Midterm 100 100 100 100 100 100 90 90 88.2 88 79.2 77.6 74 95 93.1 92 81.1 83 88 86.2 86 77.4 75.9 86 67 65.7 65 58.5 57.3 56 88 86.2 86 77.4 75.9 92 78 76.4 75 67.5 66.2 74 84 82.3 82 73.8 72.3 92 95 93.1 92 82.8 81.1 77 77 75.5 74 66.6 65.3 76 81 79.4 79 71.1 69.7 93 92 90.2 89 80.1 78.5 82 93 91.1 90 81 79.4 76 97 95.1 94 84.6 82.9 86 86 84.3 84 75.6 74.1 91 76 74.5 73 65.7 64.4 92 91 89.2 88 79.2 77.6 94 90 88.2 88 79.2 77.6 80 98 96 95 85.5 83.8 65 81 79.4 79 71.1 69.7 92 93 91.1 90 81 79.4 88 92 90.2 89 80.1 78.5 92 91 89.2 88 79.2 77.6 78 79 77.4 77 69.3 67.9 87 96 94.1 89 80.1 78.5 90 87 85.3 96 86.4 84.7 98 94 92.1 91 81.9 80.3 96 93 91.1 85 76.5 75 73.8 77.1 68.9 59.9 72.2 72.2 77.9 64.8 73.8 73 72.2 63.1 73 78.8 74.7 69.8