Not using panda python, please The CVS files “references” data are…

Question Answered step-by-step Not using panda python, please The CVS files “references” data are… Not using panda python, pleaseThe CVS files “references” data are listed down below   You will design a program that manages student records at a university. You will need to use a number of concepts that you learned in class including the use of classes, use of dictionaries, and input and output of comma-delimited CSV files. Required Output: 1) Interactive Inventory Query Capability a. Query the user of an item by asking for a major and GPA with a single query. i. Print a message(“No such student”) if the major is not on the roster, more than one major or GPA is submitted. Ignore any other words, so “smart Computer Science student 3.5” is treated the same as “Computer Science 3.5”.ii. Print “Your student(s):” with the student ID, first name, last item, and GPA. Do not provide students that have graduated or had disciplinary action. List all the students within 0.1 of the requested GPA.iii. Also print “You may, also, consider:” and provide information about the same student type within 0.25 of the requested GPA. Do not provide students that have graduated or had disciplinary action.iv. If there were no students who satisfied neither ii nor iii above – provide the information about the student within the requested major with the closest GPA to that requested. Do not provide students that have graduated or had disciplinary action.v. After outputting for one query, query the user again. Allow ‘q’ to quit. Input: a) StudentsMajorsList.csv — contains items listed by row. Each row contains student ID, last name, first name, major, and optionally a disciplinary action indicatorb) GPAList.csv — contains items listed by row. Each row contains the student ID and the student GPA.c) GraduationDatesList.csv – contains items listed by row. Each row contains the student ID and graduation date. Example StudentsMajorsList.csv, GPAList.csv, and GraduationDatesList.csv are provided for reference. Your code will be expected to work with any group of input files of the appropriate format. Names, majors, GPAs, and graduation dates can and will likely be different from the examples provided.You can reuse parts of your code from Part 1.Required Output: 1) Interactive Inventory Query Capability a. Query the user of an item by asking for a major and GPA with a single query. i. Print a message(“No such student”) if the major is not on the roster, more than one major or GPA is submitted. Ignore any other words, so “smart Computer Science student 3.5” is treated the same as “Computer Science 3.5”.ii. Print “Your student(s):” with the student ID, first name, last item, and GPA. Do not provide students that have graduated or had disciplinary action. List all the students within 0.1 of the requested GPA.iii. Also print “You may, also, consider:” and provide information about the same student type within 0.25 of the requested GPA. Do not provide students that have graduated or had disciplinary action.iv. If there were no students who satisfied neither ii nor iii above – provide the information about the student within the requested major with the closest GPA to that requested. Do not provide students that have graduated or had disciplinary action.v. After outputting for one query, query the user again. Allow ‘q’ to quit.Image transcription textElectrical …… 305671Jones BobEngineering …. Computer 987621WongChen Science Computer … Show more… Show moreIf u need my part 1 one code  op1 = open(“FullRoster.csv”, mode=”w”)op3 = open(“ScholarshipCandidates.csv”, mode= “w”)op4 = open(“DisciplinedStudents.csv”,mode= “w”)major = “StudentsMajorsList.csv”grade = “GPAList.csv”graduation_date = “GraduationDatesList.csv”with open(major) as file1: data1 = file1.read().splitlines()with open(grade) as file2: data2 = file2.read().splitlines()with open(graduation_date) as file3: data3 = file3.read().splitlines()for a, b, c in zip(data1, data2, data3): x = a.split(“,”) y = b.split(“,”) z = c.split(“,”) op1.write(x[0] + “, ” + x[2] + “, ” + y[-1] + “, ” + x[1] + “, ” + z[-1] + “, ” + x[4]) op1.write(“n”)for a, b, c in zip(data1, data2, data3): x = a.split(“,”) y = b.split(“,”) z = c.split(“,”) major.replace(” “,””) op2 = open(major+”ComputerInformationSystemsStudents.csv”, mode= “w”) op2.write(x[0] + “, ” + x[2] + “, ” + y[-1] + “, ” + x[1] + “, ” + z[-1] + “, ” + x[4]) op2.write(“n”) op2.close()for a, b, c in zip(data1, data2, data3): x = a.split(“,”) y = b.split(“,”) z = c.split(“,”) if float(y[-1]) > 3.8: op3.write(x[0] + “, ” + x[1] + “, ” + x[2] + “, ” + x[3] + “, ” + y[-1]) op3.write(“n”)for a, b, c in zip(data1, data2, data3): x = a.split(“,”) y = b.split(“,”) z = c.split(“,”) if a[-1] == “Y”: op4.write(x[0] + “, ” + x[1] + “, ” + x[2] + “, ” + z[-1]) op4.write(“n”) op1.close()op3.close()op4.close() Computer Science Engineering & Technology Python Programming CSCI S-7 Share QuestionEmailCopy link Comments (0)