Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Instructions for submission The area of a triangle is given by the formula Area = 1/2 * Base * Height. Using the IDLE development environment, create a Python script named t_area.py . Your script...

Instructions Assignment 3: Movie Review Part 2 (PHP) What you need to do ? Apply PHP basic control and data structures to create dynamic web pages ? Apply PHP to handle files Requirements For this...

JBR-07575; No of Pages 12 Journal of Business Research xxx (2012) xxx-xxx Contents lists available at SciVerse ScienceDirect Journal of Business Research Organizational innovation as an enabler of...

Web Pages and HTML scope of this lab, which focuses on the basics of what's going on underneath. TextEdit on MacOSX or any equivalent program." Or search for them from the 'go' menu. Do not use Word...

I am so lost with all of this and the worst part it is due in an hour and a half. I don't know what to do please help. In this course you will have the opportunity to apply the concepts learned to a...

Using the case study below: Memo to the Project Sponsor. In the memo, outline the following: a. Recommendations for managing the project - should leverage the scope management plan and scope...

Please answer quickly if possible!!!!! thank you!! Soccer Tournament Simulator (soccer_tournament.py) Your friend is a member of the UVM Women's Soccer Team and they have a tournament coming up....

Mates Rates Rent-A-Car ( just do the part a) using visual studio code (C#) Criteria sheet - Par A Example supplementary files (readme.pdf) Example supplementary files (class-diagram.pdf) Assignment...

Any help with this would be greatly appreciated! An HR Payroll System Computers are great at storing and manipulating data. For this project, you will write code that keeps track of Human Resources...

On June 30, a company paid a premium of $2,400 for one year of insurance coverage, which started on July 1. The company has a calendar year-end. Which of the following statements about this situation...

During 2020, Spokane Ltd. purchased the net assets of Tacoma Corp. for $635,000. On the date of the transaction, Tacoma reported $200,000 in liabilities. As well, the fair value of Tacomas assets...

11. The cumulative frequency curves below show the average typing speeds, x words per minute, of two groups of people, A and B, and the number of people whose typing speeds are less than or equal to...

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

1. The International Labour Organization. The International Labour Organization (ILO) has established labor standards for 150 countries represented by the organization. Locate the Web site for the...

9. Assess the strategy of Wal-Mart in China where the company has recognized unions in all 62 stores, to its strategy in the United States, which is to combat any type of union representation.

5. Although multinational corporations seem to be growing in size and influence, what must occur before transnational collective bargaining can be effectively carried out?