Answer Happy

please i need a code for a function that can read excel files
for each student which contains his grades and etc... and then it
will read in specific the only major courses and extract them as
shown in the picture of Figure 4: Major transcript I have
uploaded a picture for the sample figure 4 please
follow Figure 4: Major transcript AND YOU HAVE DATA TO
ASSUME
1 Level 2 U 3 U 4 U 5 U 6 U 7 U 8 U 9 U 10 U 11 U 12 U 13 U 14 U 15 U 16 U 17 U 18 U 19 U 20 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 G 36 G 37 G N 3 4 6 7 8 Degree Term courseNar courselD courseTyp creditHou Grade 1 CourseA1 CA1 BS1 Major 3 75 BS1 1 CourseA6 CA6 Minor 76 BS1 1 CourseA2 CA2 Major 77 BS1 2 CourseA11CA11 Major 78 BS1 2 CourseA16 CA16 Minor 60 BS1 2 CourseA12 CA12 Major 81 BS1 3 CourseA21CA21 Major 82 BS1 3 CourseA26 CA26 Minor 81 BS1 3 CourseA22 CA22 Major 82 BS1 4 CourseA31CA31 83 Major Minor BS1 4 CourseA36 CA36 78 BS1 4 CourseA32 CA32 Major 79 BS1 5 CourseA41CA41 Major 81 BS1 5 CourseA4€ CA46 Minor 82 BS1 5 CourseA42 CA42 Major 83 BS1 6 CourseA51CA51 Major 79 BS1 6 CourseA5€ CA56 Minor 76 BS1 6 CourseA52 CA52 Major 95 BS1 7 CourseA61CA61 Major 81 BS1 7 CourseA6€ CA66 Minor 82 BS1 7 CourseA62 CA62 Major 83 BS1 8 CourseA16 CA16 Minor 90 BS1 8 CourseA72 CA72 Major 78 M1 1 CourseP1 CP1 79 Major Minor M1 1 CourseP6 CP6 90 M1 2 CourseP11 CP11 Major 81 M1 2 CourseP16 CP16 Minor 82 M1 3 CourseP21 CP21 83 M1 3 CourseP26 CP26 Major Minor Major 84 M1 4 CourseP31 CP31 85 M1 4 CourseP36 CP36 Minor 80 M1 4 CourseP38 CP38 Minor 81 D1 1 CourseX1 CX1 82 Major Minor D1 1 CourseX6 CX6 83 D1 2 CourseX11 CX11 Major 96 D1 2 CourseX16 CX16 Minor 84 1.0 4 3 34 3 3 4 3 343 3 4 3 3 3 Awwwww 3 3 3 3 4 3 www ww 3 3 3 3 3 3 ww 3 3 mmmm 3 3 3 3 mm 3 9
1 2 3 4 5 6 7 8 9 10 11 12 1 Serial 3 4 College stdID Name 1 2.01E+08 Ibrahim At College1 2 2.01E+08 Ibrahim At College1 3 2.01E+08 Ibrahim At College1 4 2.01E+08 Ali Moham College2 5 2.01E+08 Ahmed Ali College3 6 2.01E+08 Ahmed Ali College1 7 2.01E+08 Mohamma College4 8 2.01E+08 Mohamma College4 9 2.01E+08 Kamal Abd College5 2 5 6 Departmer Level C1Departn U C1Departn G C1Departn G C2Departn U C3Departn G C1Departn G C4Departn U C4Departn G C5Departn G 7 Degree BS1 M1 D1 BS1 M1 M2 BS1 M1 D1 8 9 10 Major Minor Terms C1D1Majo C1D1Mino C1D1Majo C1D1Mino C1D1Majo C1D1Mino C2D1Majo C2D1Mino C3D1Majo C3D1Mino C1D1Majo C1D1Mino C4D2Majo C4D2Mino C4D2Majo C4D2Mino C5D1Majo C5D1Mino 8 4 6 7 4 3003 8 7 11
5. Major Transcript Feature - def majorTranscriptFeature(): 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. 2 Name: College: Major: Level: ************** course ID c1 c2 Major Average = Term 1 course name course 1 course 2 *********** Term 2 stdID: Department: Minor: Number of terms: ********** credit hours grade 3 80 4 90 Overall Average = ********* credit hours grade 3 95 3 85 Overall Average = ===== course ID course name course 3 c3 c4 course 4 Major 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 (i.e. std202006000MajorTranscript.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.