Only in python No panda You will design a program that manages student records at a university. You will need to use a n

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Only in python No panda You will design a program that manages student records at a university. You will need to use a n

Post by answerhappygod »

Only in python No panda
You will design a program that manages student records at auniversity. You will need to use a number of concepts that youlearned in class including: use of classes, use of dictionaries andinput and output of comma delimited csv files. Input: a)StudentsMajorsList.csv -- contains items listed by row. Each rowcontains student ID, last name, first name, major, and optionally adisciplinary action indicator b) GPAList.csv -- contains itemslisted by row. Each row contains student ID and the student GPA. c)GraduationDatesList.csv – contains items listed by row. Each rowcontains student ID and graduation date. ExampleStudentsMajorsList.csv, GPAList.csv and GraduationDatesList.csv areprovided for reference. Your code will be expected to work with anygroup of input files of the appropriate format. Names, majors, GPAsand graduation dates can and will likely be different from theexamples provided. THIS PROJECT IS TO ASSESS YOUR ABILITY TO USEWHAT YOU HAVE LEARNED IN THIS CLASS. THE USE OF TECHNIQUES THAT AREBEYOND THE SCOPE OF THIS CLASS IS EXPLICITLY FORBIDDEN. INPARTICULAR, THE USE OF LAMBDA, PANDAS, ITEMGETTER OR DATABASES WILLRESULT IN AN AUTOMATIC 0. Required Output: Processed InventoryReports: a. FullRoster.csv -- all the items listed by row with alltheir information . The items should be sorted alphabetically bystudent last name. Each row should contain student ID, major, firstname, last name, GPA, graduation date and indicate if disciplinaryaction was taken. The student attributes must appear in this orderin each row. b. List per major, i.eComputerInformationSystemsStudents.csv -- there should be a filefor each major and the major needs to be in the file name, thespaces in the major name should be eliminated for the file name.Each row of the file should contain student ID, last name, firstname, graduation date, and indicate if disciplinary action wastaken. The students should be sorted by their student ID. c.ScholarshipCandidates.csv – should contain a list of all eligiblestudents with GPAs > 3.8. Students who have graduated or havehad disciplinary action taken are not eligible. Each row shouldcontain: student ID, last name, first name, major, and GPA. Thestudents must appear in the order of GPA from highest to lowest. d.DisciplinedStudents.csv –all students that have been disciplined.Each row should contain: student ID, last name, first name, andgraduation date. The students must appear in the order ofgraduation date from oldest to most recent.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply