Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

******************************************* PYTHON ********************************************** Please DONT POST ANYTHING if you cant do it fully and if you are not sure from your answer !!!!!!!! ************ I

******************************************* PYTHON **********************************************

Please DONT POST ANYTHING if you cant do it fully and if you are not sure from your answer !!!!!!!!

************ I want full answer *************

Thanks In Advance

image text in transcribed

image text in transcribed

1. Implement the Student_Record Processor ADT given below: A student record processor is used to extract student records from external storage. The five data components of the individual records are extracted and stored in a storage object specific for this collection of student records stored in CSV format. In CSV format, each field is separated usually with a comma character. Note that the CSV files used in this problem will contain column names on the very first line (STUDENT_ID, NAME, CLASS, GPA). For example, the input CSV file may contain the following information: CLASS, Sophomore, Junior Senior Senior Freshman, Freshman, Sophomore, Senior Sophomore, Junior Sophomore, GPA 3.01 2.85 STUDENTID, LNAME, FNAME, 10015, 10167, 10175, 10188, 10200, 10208, 10226, 10334, 10387 10400, 10485 Smith, John, Jones, Wendy, Smith, Jane, Wales, Sam, Roberts,Sally., Green, Nelson, Amy, Robert3,Jane, Taylor, Susan, Logan, Mark, Broum, Jessica, 3.25 4. 00 3.95 2.95 Patrick 2.15 3.33 2.91 Spaces do not matter. However, you will need to consume them in your program using str.strip Student_Record Processor: Student_Record_Processor( input source Creates a student reader instance for extracting student records from a given input source--usually a file path. The input must be in CSV format. open() Opens a connection to the input source and prepares it for extracting student records. If a connection cannot be opened, an exception is raised close(: Closes the connection to the input source. If the connection is not currently open, an exception is raised fetch _next(): Extracts the next student record from the input source and returns a reference to a storage object containing the data. None is returned when there are no additional records to be extracted. An exception is raised if the connection to the input source was previously closed 1. Implement the Student_Record Processor ADT given below: A student record processor is used to extract student records from external storage. The five data components of the individual records are extracted and stored in a storage object specific for this collection of student records stored in CSV format. In CSV format, each field is separated usually with a comma character. Note that the CSV files used in this problem will contain column names on the very first line (STUDENT_ID, NAME, CLASS, GPA). For example, the input CSV file may contain the following information: CLASS, Sophomore, Junior Senior Senior Freshman, Freshman, Sophomore, Senior Sophomore, Junior Sophomore, GPA 3.01 2.85 STUDENTID, LNAME, FNAME, 10015, 10167, 10175, 10188, 10200, 10208, 10226, 10334, 10387 10400, 10485 Smith, John, Jones, Wendy, Smith, Jane, Wales, Sam, Roberts,Sally., Green, Nelson, Amy, Robert3,Jane, Taylor, Susan, Logan, Mark, Broum, Jessica, 3.25 4. 00 3.95 2.95 Patrick 2.15 3.33 2.91 Spaces do not matter. However, you will need to consume them in your program using str.strip Student_Record Processor: Student_Record_Processor( input source Creates a student reader instance for extracting student records from a given input source--usually a file path. The input must be in CSV format. open() Opens a connection to the input source and prepares it for extracting student records. If a connection cannot be opened, an exception is raised close(: Closes the connection to the input source. If the connection is not currently open, an exception is raised fetch _next(): Extracts the next student record from the input source and returns a reference to a storage object containing the data. None is returned when there are no additional records to be extracted. An exception is raised if the connection to the input source was previously closed

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_2

Step: 3

blur-text-image_3

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

Database Concepts

Authors: David Kroenke

4th Edition

0136086535, 9780136086536

More Books

Students also viewed these Databases questions

Question

How does the concept of hegemony relate to culture?

Answered: 1 week ago