- Please I Need The Code For Functions 8 9 10 This Is A Picture Of The Output I Have Posted This Question More Than 5 T 1 (109.53 KiB) Viewed 58 times
- Please I Need The Code For Functions 8 9 10 This Is A Picture Of The Output I Have Posted This Question More Than 5 T 2 (95.02 KiB) Viewed 58 times
- Please I Need The Code For Functions 8 9 10 This Is A Picture Of The Output I Have Posted This Question More Than 5 T 3 (115.17 KiB) Viewed 58 times
- Please I Need The Code For Functions 8 9 10 This Is A Picture Of The Output I Have Posted This Question More Than 5 T 4 (131.24 KiB) Viewed 58 times
- Please I Need The Code For Functions 8 9 10 This Is A Picture Of The Output I Have Posted This Question More Than 5 T 5 (116.35 KiB) Viewed 58 times
- Please I Need The Code For Functions 8 9 10 This Is A Picture Of The Output I Have Posted This Question More Than 5 T 6 (109.69 KiB) Viewed 58 times
- Please I Need The Code For Functions 8 9 10 This Is A Picture Of The Output I Have Posted This Question More Than 5 T 7 (135.35 KiB) Viewed 58 times
- Please I Need The Code For Functions 8 9 10 This Is A Picture Of The Output I Have Posted This Question More Than 5 T 8 (111.96 KiB) Viewed 58 times
- Please I Need The Code For Functions 8 9 10 This Is A Picture Of The Output I Have Posted This Question More Than 5 T 9 (117.52 KiB) Viewed 58 times
they copy the code picture and post it as an answer! please
understand what I want. please i need the code for functions
8,9,10
- Please I Need The Code For Functions 8 9 10 This Is A Picture Of The Output I Have Posted This Question More Than 5 T 10 (123.18 KiB) Viewed 58 times
this is a link for the input files
https://docs.google.com/uc?export=downl ... 3lDNF1zJOs
Develop a menu driven complete program that can perform the illustrated features in Figure 1. This program works for an individual user (i.e. student) only; it can generate the transcript of the student into a file and it shows some statistics. Student Transcript Generation System 1. Student details 2. Statistics 3. Transcript based on major courses 4. Transcript based on minor courses 5. Full transcript 6. Previous transcript requests 7. Select another student 8. Terminate the system Enter Your Feature: Figure 1: Transcript generation system menu. 1 Description: The program starts by asking the user to select the student level: Undergraduate (U) or Graduate (G) option or Both (B) options. Also, under the G and B options, the user will be asked again for: Master (M) or Doctorate (D) or Both (BO). Once the user selects the option(s), it asks him for the student ID (stdID) (i.e. 202006000). Then, it will directly show the above menu for other options. Note that,If the user enters wrong ID, the program will keep asking him for the correct student ID based on the available ID's in the database. 1.1 Functions: Each feature has to be designed using a separate function and it might be called by other functions including the main function. The descriptions of the start function, and other functions are given below: 1. Start Feature - def startFeature(): This function allows the user to select the student level (i.e. U, G and B) and it asks also for the degree (i.e. M, D and BO) under the G and B options from the student level. Then, the system will sleep for few seconds and it will redirect you to the menu window as in Figure 1 and it will store the records of your selection. 2. Menu Feature - det menuFeature(): It contains the setup of the menu window including the eight features in Figure 1. If you need to show the menu in your program, you need to call this function and assign number for each feature as illustrated in the figure. 3. Details Feature - def detailsFeature(): It shows the detail of the student like name, stdID, number of terms, college, and department. Here, you need to show this information on the screen, each record in one line as in Figure 2. Also, you need to store this information with the same style in stdiDdetails.txt file (i.e. std202006000details.txt) at same path of your jupyter file. After showing and storing the records of the student, the program will clear all printed data on the screen, sleep for few seconds and redirect you to the menu window. 1
Name: stdID: Level(s): Number of terms: College(s): Department(s); Figure 2: Output of the details feature. Here, note that the student might select B and BO options, so, you need to adjust the number of terms, college, department) variables for showing more than one value in same line based on the number of levels and degrees. 4. Statistics Feature - def statisticsFeature(): It shows some statistics about the student's records based on the selected option(s) as shown in Figure 3. Undergraduate Level Overall average (major and minor) for all terms: Average (major and minor) of each term: Term 1: Term 2: Term n: Maximum grade(s) and in which term(s): Minimum grade(s) and in which term(s): Do you have any repeated course(s)? Graduate(M) Level Overall average (major and minor) for all terms: Average (major and minor) of each term: Term 1: Term 2: Term n: Maximum grade(s) and in which term(s): Minimum grade(s) and in which term(s): Do you have any repeated course(s)? Figure 3: Output of the statistics feature. Here, you need to show this information on the screen and you need to store them with the same style in stdiDstatistics.txt file (i.e. std202006000statistics.txt) at same path of your jupyter file. After showing and storing the records of the student, the program will clear all printed data on the screen, sleep for few seconds and redirect you to the menu window. 5. Major Transcript Feature - def major TranscriptFeature(): It shows the transcript of the student based on the major courses and the selected option(s) as shown in Figure 4. This transcript shows the major courses, the average of major courses in each term and the overall major average for all terms up to the last term.
Name: College: Major: : Level: stdID: Department: Minor Number of terms: Term 1 course ID course name c1 course 1 c2 course 2 Major Average credit hours grade 3 80 a 90 Overall Average Term 2 2 course ID course name c3 course 3 c4 course 4 Major Average- credit hours grade 3 95 3 85 Overall Average - ***** End of Transcript for Level (U) ( Figure 4: Major transcript. Here, you need to show this information on the screen and you need to store them with the same style in stdIDMajor Transcript.txt file (.e. std202006000Major Transcript.txt) at same path of your jupyter file. After showing and storing the records of the student, the program will clear all printed data on the screen, sleep for few seconds and redirect you to the menu window. 6. Minor Transcript Feature-def minor TranscriptFeature(): It shows the transcript of the student based on the minor courses as shown in Figure 5. This transcript shows the minor courses, the average of minor courses in each term and the overall minor average for all terms up to the last term. Name: College: Major: Level: stdiD: Department: Minor: Number of terms: Term 1 1 ******* course ID course name c6 course 6 c7 course 7 Minor Average - credit hours grade 3 3 80 4 90 Overall Average- Term 2 course ID c8 c9 course name course 8 course 9 SSSSSSSS credit hours grade 3 3 95 3 85 Overall Average Minor Average ************ End of Transcript for Level (U) Figure 5: Minor transcript. Here, you need to show this information on the screen and you need to store them in same style in stdiD Minor Transcript.txt file (i.e. std202006000Minor Transcript.txt) at same path of your jupyter file. After showing and storing the records of the student, the program will clear all printed data on the screen, sleep for few seconds and redirect you to the menu window. 7. Full Transcript Feature - def fullTranscriptFeature():
It shows the transcript of the student based on both minor and major courses as shown in Figure 6. This transcript shows the courses, the average of courses in each term and the overall average for all terms up to the last term. . Name: College: Major: Level: stdID: Department: Minor: Number of terms: : Term 1 course ID course name c1 course 1 c2 course 2 c6 course 6 cz course 7 Major Average = Term Average = credit hours grade 3 80 4 90 3 3 80 4. 90 Minor Average = Overall Average Term 2 course ID course name credit hours grade 63 course 3 3 95 c4 course 4 3 85 c8 course 8 3 95 c9 course 9 3 85 Major Average = Minor Average Term Average = Overall Average =========== ========= ************* End of Transcript for Level (U) BRO ESSESSESSES Figure 6: Full transcript. Here, you need to show this information on the screen and you need to store them in same style in stdiDFullTranscript.txt file (i.e. std202006000FullTranscript.txt) at same path of your jupyter file. After showing and storing the records of the student, the program will clear all printed data on the screen, sleep for few seconds and redirect you to the menu window. Note that for features (5, 6, and 7), the student can select B (U and G) and BO (M and D) options, so, you need to show all transcripts for the selected levels on the screen and store them in same file staring with the lowest level to the highest level. 8. Previous Requests Feature - def previous Requests Feature(): It shows the previous requests for this student. For example, student requested major transcript in previ- ous term and full transcript in this term, the output should be shown as in Figure 7: Request Date Time ESSERE Major Full 22/09/2020 12/02/2021 13:30 PM 14:30 PM Figure 7: Previous requests. Here, you need to show this information on the screen and you need to store them in same style in stdIDPrevious Requests.txt file (i.e. std202006000Previous Requests.txt) at same path of your jupyter file. After showing and storing the transcript of the student, the program will clear all printed data on the screen, sleep for few seconds and redirect you to the menu window. 9. New student Feature - def newStudentFeature(): This feature allows the user to start the program for another student after clearing all previous data on the screen.
10. Terminate Feature - def terminate Feature(): This feature allows the user to terminate the program and at same time it will show the number of requests during the session at the screen. 1.2 Inputs/Outputs: 1. Inputs: • Input data are .csv files. You are going to read.csv files in Figure 8, in order to use them as inputs. 201005000 201007000 201008000 201009000 x 201101000 studentDet ails Figure 8: Input files. • As a hint, you can use "numpy" module to read .csv file by calling numpy.loadtxt and passing the suitable variables. . Two main .csv files: first file is studentDetails.csv file which includes the students' IDs, names, colleges, and departments. The second file(s) is/are named by the student ID and it contains all student's records as in Figure 9 and Figure 10. 1 3 4 5 6 7 8 9 10 D F G H stdi Name College Department Level Degree Major Minor Terms 1201000000 Ibrahim Ahmed Nee College1 CiDepartment U 351 CIDIMO CID Minor 2 201006000 Ibrahim Ahmed Colleges ciDepartment 6 MI CID MajorM1 CIDIMinori 4 3 201006000 Ibrahim Ad None Colleges Clepartments G DI C101MDI CID Minori 6 4 201007000 Ali Mohamad Hadi College2 C2Departmenti U Si CAD. Majoris C2D Minors1 7 5 201008000 Ahmed Ali Mohammad College3 C30epartment MI C3D1MjM1 CID MINIM 4 5 20100800 Ahmed Ali Mohammad Colleges CiDepartment G M2 CID MajorM2 CIDIMINOM2 3 7 201009000 Mohammad Ibrahim All College C4Department2U 851 CAD2Majors1 CD Minors1 8 8 201009000 Mohammad Ibrahim A Colleget Department2G MI CAD MajorMI CAD2Minor 3 9 201101000 Kamal Abdallah Mohammad College CSDepartment1 G DI CS01Major: CSD Minor 7 Figure 9: studentDetails.csv Input file. 351 B H 1 Level Degree Term courseName courseID course Type creditHours Grade 2 U BS1 1 Course CA1 Major 3 3 1 Course A6 CA6 Minor 4 76 4 BS1 1 CourseA2 CAZ Major 3 77 5 BS1 2 Course A11 CA11 Major 3 78 6 BS1 2 CourseA16 CA16 Minor 4 60 7 B51 2 Course A12 CA12 Major 3 81 B 3 Course 21 CA21 Major 3 82 9 BS1 3 Course A26 CA26 Minor 4 81 10 U BS1 3 Course A22 CA22 Major 3 82 11 BS1 4 Course A31 CA31 Major 3 83 . CCCCCCCCC 乃 而 Emumb B51 Figure 10: one of the ID.csv Input file (.e. 201006000.csv). . You can build a separate function for data generation and processing. • You are not allowed to modify the input files manually. . You need to decide your input variables for all functions, I left them empty. 2. Outputs: • You are going to show your outputs based on the figures on the screen and you need to save outputs in .txt files with same style as we discussed it before for each function. • You can build a separate function for transcripts generation process.
2 Guidelines: 1. The lab praject should include the following items a) Dealing with diverse data type like strings, tinats and int. Invoting operationis dealing with files reading from files and writing to files. Id Using Lists/Dictionaries/sets/Tuples arty of these data structures or combination), (di Adding, removine, and modifying records le Sorting data based on a certain criteria fif it is needed. (t) Saving data at the end of the session to a file. 2. The lab project will be cone by teams of 2 students. However, cach student has to know about all tasks in the project and both students will be asked about the project individually 3. The students should know the following items: (a) Comments are important they are worth (worth 5% The code must use meaningful variable names and modular programming (worth 10%) ici Global variables are not allowed. Students should learn how to pass parameters to functions and receive results. Idi Students must submit a working program. Non working parts can be submitted separately. If a team submits anon working program, it loses 20% of the grade le User input must be validated by the programie vaid range and valid type Students will not be forced to use object oriented paradigm 5. Students are allowed to use the following modules (datetime, numpy, pandas, random, time, sys, os, math, Statistics, IPython.display. If you need to use other than these modules. you are required to get a permission first. 5. Your program must contain as many functions as needed. You need to divide your problem into small tasks and each task handled by a function as we explained in the description of the features 7. The deadline for submitting the lab graject is end of week fourteen (Saturday December 11, 2021 before midnight) 8. Submission will be through the blackboard only - assignment section you have only two attempts) and one Suomission per team is enough 3 Deliverable: 1. Each team has to submit: la) The code as a Jupyter notebook and you should use the template on the blackboard (LAS-C5-104Seco Groupłocipro. bl The report as part of the upyter notebook (LAB-ICS-204-SecXX-GroupOpbl. The report will describe how you solved the problem. In addition, you need to describe the different functons with their tasks and screen shots of their outputs (worth 5x) Ici Your Jupyter file should have the following lines at the heginning: W This work done by group $$: # Name of First Student, ID, Percentage of his work contribution. # Name of Second Student, ID, Percentage of his contribution. Figure 11: Start of your code
Calibri v 11 FO > General CH PA 27 O WÁS 2 Delete - V Paste V BT BIU kv $ % 8 Conditional Format as Cell Formatt ng Table Table Styles Styles Analyze Data v Sort & Find & v Filter Select Editing I Formal Calls Undo Clipboard Font Alignment Number E Analysis 120 : M N R S T U V Term в Degree ESI BS1 BSI BS1 BS1 BS1 es1 3 75 1 Level 2 U 3 U 4 U 5 U 5 U 6 U U 7 U U & U U 9 U 9 U 10 U 11 U U 12 U 13 U 14 U 15 U 16 U U 17 U U 18 U U 19 U 20 U U 21 U 22 U 23 U 24 U 25 G 26 G 27 G 28 G 29 G 30 G 31 G 32 G 33 G 34 G 35 6 26 G BS1 BS1 AS1 BS1 OS1 RS1 BS1 BS1 BS1 BS1 eS1 BS1 BS1 PS1 D F F F courseNair courseld course Type credit Hour: Grade 1 Course41 CA1 Major 3 75 1 Cours A6 CAG Minor 4 76 1 CourseA2 CAZ Major 3 77 2 Course411 CA11 Majar 3 78 2 CourscA16 CA16 Minor 4 60 2 Coursel2 CALZ Major 3 3 81 3 Caurse21 CA21 Majar 3 82 3 CourscA26 CA26 Minor 4. 81 3 3 CourseAZZ CAZZ Major 3 82 4 Caurse1 CA21 Majar 2 83 4 CoursCA36 CA36 Minor 4 4 78 4 Course432 CAD2 Major 3 79 5 Coursc441 CA41 Majar 2 81 5 CourseA45 CM45 Minor 4 82 5 Course442 0442 Major 3 6 CourscA51 CA51 Major 3 79 6 CourseA56 CA55 Minor 3 76 6 Course452 C452 Major 3 77 7 CoursCA61 CA61 Major 3 81 7 CourseA66 CA65 Minor 82 7 Caurse462 0462 Major 3 83 8 Coursel6 CA16 Minor 4. 90 & Course172 CAZZ Major 3 78 1 CourseP1 CP1 Majar 2 79 1 CoursePb CP Minor 3 80 2 CourseP11 CP11 Major 3 81 2 CourseP16 CP16 Minor 2 82 3 CourseP21 CP21 Major 3 CaurseP26 CP26 Minor 3 84 4 CourseP31 CP31 Major 3 85 4 CourseP36 CP36 Minor 3 80 4 CoursePa CP38 Minor 3 81 1 Coursexi CX1 Major 3 82 1 Coursexcx6 Minor 3 3 2 CourseX110X11 Maier 3 82 BS1 BSI M1 Mi M1 M1 MI M1 M1 MI M1 D1 DI ni 201006000 Accessibility Unavailable Ready 87% 32°C !! ENG 40 10X31 PM 0 5/5/2022 السماء صافية
hare X Calibri 11 - A A = PA Insert >T 2 General . L/ WÁ 29 0 0 2 Delete- V Paste в то B 三三三三三三 Sv Analyze $ % 9% 88 Conditional Format as Cel Formatt ng Table Table Styles Styles Sort & Find & Filter Select Formal Data Undo Clipboard Font Alignment Number E Calls Editing Analysis A1 ft Level T. L M N 0 P 0 R S 90 90 91 92 90 90 90 91 92 B с 1 Level Degree Term 2 U BS1 3 U BS1 4 U BS1 5 U BS1 GU BS1 7 U BS1 8 v BS1 9 U BS1 10 U BS1 11 U BS1 12 V BS1 13 U U BS1 14 U BS1 15 U BS1 16 U BS1 17 U BS1 18 U BS1 19 U BS1 20 V BS1 21 U BS1 22 U BS1 23 24 25 26 27 28 29 30 31 201007000 # Ready Accessibility: Unavailable: 32°C D E н courseNam courselD courseType credit Hour: Grade 1 Coursec1 CC1 Major 3 1 CourseC6 CC6 Minor 4 1 CourseC2 CC2 Major 3 2 CourseC11 CC11 Major 3 2 CourseC16 CC16 Minor 4 2 CourseCiz CC12 Major 3 3 CourseC21 CC21 Maior 3 3 CourseC26 CC26 Minor 4 3 CourseC22 CC22 Major 3 4 CourseC31 C031 Major 3 4 CourseC36 CC36 Minor 4 4 CourseC32 CC32 Major 3 5 CourseC41 CC41 Major 3 5 CourseC46 C646 Minor 4 5 CourseCAZ CC42 Major 3 6 CourseC51 CCS1 Major 3 6 CourseC56 CCS6 Minor 3 6 CourseC52 CCS2 Major 3 7 CourseC61 CC61 Major 3 7 CourseC66 CC6G Minor 3 7 CourseC62 CC62 Major 3 93 90 90 85 86 87 88 90 90 91 92 93 回田 100% 0 !! ENG 40 10:32 PM 5/6/2022 1 السماء صافية
X File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share X Insert Calibri - I A A A Σ = 11 5 General L/ WÁ @ 28 o 2x Delete V Paste B w I 三三三三三三 Analyze kv $ % 888 Conditional Format as Cel Formatt ng Table Table Styles Styles Sort & Find & Filter Select Data Eft i Formal Calls Undo Clipboard Font F Aliranmant Number E Editing Analysis A1 ft Level I L M N P 0 R S 80 81 G D E G н courseNam courselD courseType credit Hour: Grade 1 CourseQ1 001 Major 3 1 CourseQ5 CQ6 Minor 3 2 CourseQ11 0011 Major 3 2 Course016 2016 Minor 3 3 Course021 C021 Major 3 3 Course026 CO26 Minor 3 4 CourseQ31 C031 Major 3 4 CourseQ36 0036 Minor 3 4 Course038 C038 Minor 3 1 1 CourseR1 CR1 Major 3 1 CourseR6 CR5 Minor 3 2 CourseR11 CR11 Major 3 3 2 CourseR16 CR16 Minor 3 3 CourseR21 CR21 Major 3 3 CourseR25 CR26 Minor 3 82 83 78 79 80 81 82 85 87 88 89 90 90 B с ។ 1 Level Degree Term 2 M1 3 G M1 4 G M1 5 G 5 M1 6 G 6 M1 7 G MU BG M1 9 G M1 10 G M1 11 G M2 12 G MZ 13 G M2 14 G M2 15 G M2 16 G G MZ 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 201008000 Ready Accessibility Unavailable 32°C 回田 100% ENG 40 10-28 PM 5/5/2022 1 السماء صافية
x AutoSave it c) 5 201009000 - Search (Alt+Q) 4 X File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share X Insert Calibri - AI A A Σ = 11 >Tv 23 General ILA @ 2 Delete V V Paste B I A 三三三三三三 kv $ % 9 ) 98 Conditional Format as Cell Formatt ng Table Table Styles Styles Analyze Data Sort & Find & O Filter Select Editing If Formal Calls Undo Clipboard Font F Aliranmant Number E Analysis A1 ft Level I L M N P 0 R S 65 66 67 68 69 70 80 81 82 83 B с 1 Level Degree Term 2 U BS1 3 U BS1 4 U BS1 5 U BS1 GU BS1 7 U BS1 8 v BS1 9 U BS1 10 U BS1 11 U BS1 12 V BS1 13 U U BS1 14 U BS1 15 U BS1 16 U BS1 17 U BS1 18 U BS1 19 U BS1 20 V BS1 21 U BS1 22 U BS1 23 U BS1 24 U BS1 25 G M1 26 G M1 27 G M1 28 G M1 29 G M1 30 G M1 31 201009000 + Ready Accessibility Unavailable D D G н courseNam courselDcourseType credit Hour: Grade 1 Course 1 CE Major 3 1 CourseE6 CE6 Minor 4 1 CourseE2 CEZ Major 3 2 CourseE11 CE11 Major 3 2 CourseE16 CE16 Minor 4 2 CourseE12 CE12 Major 3 3 CourseE21 CE21 Major 3 3 CourseE26 CE26 Minor 4 3 CourseE22 CE22 Major 3 4 Coursel 31 CE31 Major 3 4 CourseE36 CE36 Minor 4 4 CourseE32 CE32 Major 3 5 CourseE41 CE41 Major 3 5 CourseE46 CE46 Minor 4 5 Course E42 CE42 Major 3 6 CourseE51 CE51 Major 3 6 CourseE56 CE56 Minor 3 6 CourseE32 CE32 Major 3 7 CourseE61 CE61 Major 3 7 Course E66 CEGO Minor 3 7 CourseE62 CE62 Major 3 8 CourseE76 CE76 Minor 3 8 Coursel 72 CE72 Major 3 1 Course51 CS1 Major 3 1 Course56 CS6 Minor 3 2 CourseS11 CS11 Major 3 2 CourseS16 CS16 Minor 3 3 Course521 CS21 Major 3 3 Course526 CS26 Minor 3 84 60 80 90 85 86 87 95 89 84 85 86 87 88 89 81 82 83 84 回田 100% 32°C 0 !! ENG 40 10:33 PM 5/6/2022 1 السماء صافية
x AutoSave c) 5 201101000 - Search (Alt+Q) X File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share X Insert Calibri - AI A A Σ = 11 >Tv 23 General DA 29 @ 2 Delete V Paste B I A Analyze = = = = kv $ %) 8 8 Conditional Format as Cel Formatt ng Table Table Styles Styles Sort & Find & Filter Select Data i Formal Calls Undo Clipboard Font F Aliranmant Number E Editing Analysis A1 ft Level I T L M N P 0 R S S 85 85 46 85 84 85 87 EEEEEEEEEBBBB D F G н courseNam courselD courseType credit Hour: Grade 1 CourseY1 CY1 Major 3 1 Course Y6 CY6 Minor 3 2 CourseY11 CY11 Major 3 2 CourseY16 CY16 Minor 3 3 CourseY21 CY21 Major 3 3 CourseY26 CY26 Minor 3 4 CourseY31 CY31 Major 3 4 CourseY36 CY36 Minor 3 5 CourseY41 CY41 Major 3 5 CourseY46 CY46 Minor 3 5 CourseY47 CY47 Minor 3 6 CourseY51 CY51 Major 3 3 6 CourseY56 CY56 Minor 3 6 CourseY57 CY57 Minor 3 7 CourseY67 CY67 Minor 3 85 90 85 96 92 85 HR 88 A B с 1 Level ។ Degree Term 2 D1 3 G D1 4 G D1 5 G D1 6 G 6 D1 7 G D1 8 G D1 9 G D1 10 G D1 11 G G D1 12 G D1 13 G D1 14 G D1 15 G D1 16 G D1 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 201101000 + Ready Accessibility: Unavailable: 32°C 回田 100% 0 !! ENG 40 10:35 PM 5/6/2022 1 السماء صافية
x AutoSave c) 5 studentDetails Search (Alt+Q) 14 X File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share X Calibri - A = Insert 11 Σ 23 >Tv IL/ General AY @ Paste 2 Delete - в 1 B 三三三三三 Analyze kv $ %) 8 8 Conditional Format as Cell Formatt ng Table Table Styles Styles Sort & Find & Filter Select Data i Formal Calls Undo Clipboard Font Alignment Number E Editing Analysis A1 K M N 0 P 0 R S 1 Serial 1 2 3 EX Xv ft Serial Р с D IstdID Name College Departmen Level 1 2.01E+08 Ibrahim Ah Collegel CIDepartmu 2 2.01E+08 Ibrahim Ah Collegel ClDepart. G 3 2.01E+08 Ibrahim Ah College1 C1Departm G 4 2.01E108 Ali Moham College2 C2Departor U 5 2.01E+08 Ahmed All College3 C3DepartG 6 2.01E+08 Ahmed Ali Collegel C1Departm G 7 2.01E+08 Mohamma College4 C4Departor U 8 8 2.01E+08 Mohamma College Departer G C4 9 9 2.01E+08 Kamal Abd. Colleges CS DepartmG G Degree BS1 M1 D1 BS1 Mi 4 H J Major Minor Terms CID Major C1D1 Minor C1D1 Major CIDI Minor C1D1Major C1D1Minor C2D1Major C2D1Minor C3D1 Major C3D1 Minan C1D1Major CIDI Minor C4D2Major CAD2Minor C4D2Major CAD2Minor CSD1 Major CSD1Minor 4 6 7 4 5 6 MZ B51 M1 D1 3 8 3 7 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 student Details Ready 回田 100% Accessibility: unavailable 32°C !! ENG 40 10:36 PM 5/6/2022 1 السماء صافية
Below is implementation of loading data and first 3 methods as per asked explanation is provided within comments. #importing all files Import pandas as pd Import numpy as np Import time studentDetails=pd.read_csv("studentDetails.csv") #loading dataset def startFeature(): print("Select the student level: For Graduate type G for undergraduate type U For both type BO") student_level=input() # input of student level if student_level=='G' or student_level=='B': print("Master: M or Doctrate: Dor Both“) inp=input() print("Enter stdID") inp=int(input() if stdid not in studentDetails.stdiD:# for invalid input id print("Enter valid studentid") time.sleep(5)# wait for few seconds menu Featurel) def menuFeature(): #menuscript as details provided print("Student Transcript Generation System") print("============ print("1. Student Details”) print("2. Statistics") print("3. Transcript based on major courses") print("4. Transcript based on minor courses") print("5. Full Transcript") print("6. Previous Transcript Request") print("7. Select another student") print("8. Terminate the system") print("=- print("Enter your feature") i=int(input()) # feature input if i==1:#if option 1 is selected call details feature detailsFeaturel) def detailsFeature(inp):# here inp is input student id studentDetails.set_index("stdID", inplace = True) # set dataset index as stdld print("Name:" student Details.get_value(inp, 'Name')) print("stdID:",inp) print("Level(s):", studentDetails.get_value(inp, 'Level')) print("Number of terms:",student Details.get_value(inp, 'Terms')) print("College(s):",studentDetails.get_value(inp, 'College')) print("Departments:", studentDetails.get_value(inp, 'Department)) startFeature()