could you please create this program in python? chegg does not allow us to upload excel file so i attach content of the infile.csv file as text below.

COURSE CODE,COURSE NAME,METU CREDIT,GRADE,,,
2015-2016 Fall,,,,,,
,,,,,,
CEIT 111,INFORMATION TECHNOLOGY IN EDUCATION,4.00,BA ,,,
ENG 101,ENGLISH FOR ACADEMIC PURPOSES I,4.00,BB ,,,
MATH 125,BASIC MATHEMATICS I,4.00,BA ,,,
EDS 200,INTRODUCTION TO EDUCATION,3.00,AA ,,,
HIST 2205,HISTORY OF THE TURKISH REVOLUTION I,0.00,S ,,,
TURK 201,ELEMENTARY TURKISH,0.00,S ,,,
CumGPA:,GPA: ,TOT.CR: ,TOT.GR: ,,,
,,,,,,
2015-2016 Spring,,,,,,
,,,,,,
CEIT 112,INFORMATION TECHNOLOGY IN EDUCATION II,4.00,AA ,,,
CEIT 133,PROGRAMMING IN INTERNET ENVIRONMENT,4.00,AA ,,,
ENG 102,ENGLISH FOR ACADEMIC PURPOSES II,4.00,BB ,,,
MATH 126,BASIC MATHEMATICS II,4.00,BA ,,,
HIST 2206,HISTORY OF THE TURKISH REVOLUTION II,0.00,S ,,,
TURK 202,INTERMEDIATE TURKISH,0.00,S ,,,
CumGPA:,GPA: ,TOT.CR: ,TOT.GR: ,,,
,,,,,,
2016-2017 Fall,,,,,,
,,,,,,
PHYS 181,BASIC PHYSICS I,5.00,BA ,,,
CEIT 210,PROGRAMMING LANGUAGES I,4.00,AA ,,,

Using the given CSV file (infile.csv) in the attachment, read and store in a nested-dictionary, then using this structure printout the transcript of the student: NONAME. The output file must contain a column: TOT. CREDIT at right of GRADE column. As in sample semeester, all semesters must be outputted. (if you prefer you may output into a file also) The data must be stored in a nested-dictionary after each semester you must calculate and output: CumGPA: GPA: TOT.CR: TOT.GR: STAN: at the end of the output: CumGPA: GRAND TOTALS: TOT.CR: The sample output for each semester: 2017-2018 Spring COURSE CODE COURSE NAME CENG 301 ALGORITHMS AND DATA STRUCTURES CENG 305 OBJECT ORIENTED PROGRAMMING WITH JAVA CENG 443 INTRODUCTION TO OBJECT-ORIENTED PROG.LANG.AND SYSTEMS EDS 304 CLASSROOM MANAGEMENT METU CREDIT 3,00 3,00 13,00 GRADE BA JAA TOT. CREDIT 10,50 12,00 9,00 BB 3,00 12,00 STAN: HIGH HONOR CumGPA: 3,72 GPA: 3,67 TOT.CR: 18,00 TOT.GR:66,00 (ps: no need to put lines, dashed lines, etc., Also here the decimal points are separated by "," but it is not important you may put your own settings ("," or ".")) infile.csv 22 December 2020, 9:53 AM