Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

NOT PANDAS PLEASE Using the given CSV file (infile.csv) in the attachment, read and store in a nested-dictionary, then using this structure printout the transcript

NOT PANDAS PLEASE

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 semester, 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:

image text in transcribed

Here is the infile.csv as text:

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 ,,,

CEIT 207,DESIGN AND USE OF INSTRUCTIONAL MATERIAL,3.00,BA ,,,

CEIT 213,COMPUTER HARDWARE,3.00,AA ,,,

EDS 220,EDUCATIONAL PSYCHOLOGY,3.00,AA ,,,

ENG 211,ACADEMIC ORAL PRESENTATION SKILLS,3.00,AA ,,,

CumGPA:,GPA: ,TOT.CR: ,TOT.GR: ,,,

,,,,,,

2016-2017 Spring,,,,,,

,,,,,,

PHYS 182,BASIC PHYSICS II,5.00,BA ,,,

CEIT 211,PROGRAMMING LANGUAGES II,4.00,AA ,,,

BA 401,FUNDAMENTALS OF ENTERPRENEURSHIP,3.00,BA ,,,

CEIT 216,PRINCIPLES AND METHODS OF INSTRUCTION,3.00,AA ,,,

CEIT 218,GRAPHICS AND ANIMATION IN EDUCATION,3.00,BA ,,,

CEIT 225,INSTRUCTIONAL DESIGN,3.00,BA ,,,

CEIT 390,DATABASE MANAGEMENT SYSTEMS,3.00,AA ,,,

CEIT 386,COMMUNITY SERVICE,2.00,AA ,,,

CumGPA:,GPA: ,TOT.CR: ,TOT.GR: ,,,

,,,,,,

2016-2017 Summer,,,,,,

,,,,,,

CEIT 313,USE OF OPERATING SYSTEMS,3.00,AA ,,,

CumGPA:,GPA: ,TOT.CR: ,TOT.GR: ,,,

,,,,,,

2017-2018 Fall,,,,,,

,,,,,,

CEIT 321,FOUNDATIONS OF DISTANCE EDUCATION,3.00,AA ,,,

CEIT 323,MULTIMEDIA DESIGN AND DEVELOPMENT,3.00,AA ,,,

CEIT 341,MEASUREMENT AND EVALUATION,3.00,AA ,,,

CEIT 360,INTRODUC. TO VISUAL DESIGN/BASIC ELEMENTS OF VIS. DES.,3.00,AA ,,,

CEIT 380,COMPUTER EDUCATION TEACHING METHODS I,3.00,BA ,,,

CENG 230,INTRODUCTION TO C PROGRAMMING,3.00,AA ,,,

CumGPA:,GPA: ,TOT.CR: ,TOT.GR: ,,,

,,,,,,

2017-2018 Spring,,,,,,

,,,,,,

CEIT 314,COMPUTER NETWORKS AND COMMUNICATIONS,3.00,BA ,,,

CEIT 382,COMPUTER EDUCATION TEACHING METHODS II,3.00,AA ,,,

CENG 301,ALGORITHMS AND DATA STRUCTURES,3.00,BA ,,,

CENG 305,OBJECT ORIENTED PROGRAMMING WITH JAVA,3.00,AA ,,,

CENG 443,INTRODUCTION TO OBJECT-ORIENTED PROG. LANG. AND SYSTEMS,3.00,BB ,,,

EDS 304,CLASSROOM MANAGEMENT,3.00,AA ,,,

CumGPA:,GPA: ,TOT.CR: ,TOT.GR: ,,,

,,,,,,

2018-2019 Fall,,,,,,

,,,,,,

CEIT 411,SCHOOL EXPERIENCE,3.00,AA ,,,

CEIT 419,WEB DESIGN,3.00,AA ,,,

CEIT 435,PROJECT DEVELOPMENT AND MANAGEMENT I,3.00,AA ,,,

CEIT 461,PROFESSIONAL PRACTICE I,3.00,AA ,,,

CEIT 421,RESEARCH METHODS,2.00,BB ,,,

CumGPA:,GPA: ,TOT.CR: ,TOT.GR: ,,,

,,,,,,

2018-2019 Spring,,,,,,

,,,,,,

CEIT 412,TEACHING PRACTICE,5.00,AA ,,,

CEIT 436,PROJECT DEVELOPMENT AND MANAGEMENT II,3.00,BA ,,,

CEIT 462,PROFESSIONAL PRACTICE II,3.00,AA ,,,

EDS 416,TURKISH EDUCATIONAL SYSTEM AND SCHOOL MANAGEMENT,3.00,BB ,,,

EDS 424,GUIDANCE,3.00,BA ,,,

CumGPA:,GPA: ,TOT.CR: ,TOT.GR: ,,,

,,,,,,

CumGPA: ,GRAND TOTALS:,,,,,

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts Of Database Management

Authors: Philip J. Pratt, Joseph J. Adamski

4th Edition

0619064625, 978-0619064624

More Books

Students also viewed these Databases questions