Question 4) You are asked to develop a program which process the csv file and check each activity (quiz, midterm, lab,...) and displays a list of students who missed that activity. You can develop a web application or console application in Python which : Ask user to enter the name of activity (example : Assignment1) The program locate the Assignment1 in the first row

The program extract student-ids and all grades on that column, and display this students id who dont have grade for that activity. Bonus: Apply partial search. If use enter Assignment, the program extract all Assignment1,2,3,4,5,... (collects all columns which have the keyword Assignment), and count the number of submitted activity/total number of activity, then display them as follow:

student id. |. Number of assignment

111222 | 4/8

11122222 | 0/8

222333. | 8/8

Student ID Lab+Class Activity - Oct 10: Class Activiti Lab: Oct11 [Total Pt Oct15:Class Activitie Lab:Oct16 [Total Pts Class Activity Oct17 Lab-Oct18 [Total Pts Oct22, Class Activity Lab-Oct23 [Total Pts Class Activity: OCT 2. Lab-Oct25 [Total Pts Final Project [Total I Final Project Do 147618193 10 10 10 10 10 10 10 10 9 10 10 96 141102194 9 10 10 10 10 10 10 10 10 9 10 89 147619191 10 10 10 10 10 8 10 9 8 8 9 75 147620199 10 10 10 10 10 10 10 10 10 10 10 96 147616198 105721100 10 10 10 10 10 10 10 10 10 10 10 92 34978130 10 10 10 10 10 10 10 10 10 9 10 95 147622195 10 10 8 10 10 10 8 8 9 9 10 94 72119100 10 10 8 10 10 10 9 10 9 00 9 93 147623193 10 10 10 10 10 10 10 9 9 00 10 87 147624191 10 10 10 10 9 7 00 4 80 147625198 10 10 10 10 10 10 10 10 9 00 9 92 147626196 10 10 10 10 10 9 10 8 9 10 85 147627194 7 3 7 2 3 8 00 6 80 147628192 10 10 9 10 10 10 10 10 9 00 9 92 147639199 10 10 10 10 10 10 10 10 10 9 10 90 147641195 10 10 9 10 10 10 10 10 9 9 9 92 147642193 10 10 10 10 10 10 10 10 10 10 10 95 147645196 10 10 10 10 10 10 10 10 10 10 10 94 Student ID Lab+Class Activity - Oct 10: Class Activiti Lab: Oct11 [Total Pt Oct15:Class Activitie Lab:Oct16 [Total Pts Class Activity Oct17 Lab-Oct18 [Total Pts Oct22, Class Activity Lab-Oct23 [Total Pts Class Activity: OCT 2. Lab-Oct25 [Total Pts Final Project [Total I Final Project Do 147618193 10 10 10 10 10 10 10 10 9 10 10 96 141102194 9 10 10 10 10 10 10 10 10 9 10 89 147619191 10 10 10 10 10 8 10 9 8 8 9 75 147620199 10 10 10 10 10 10 10 10 10 10 10 96 147616198 105721100 10 10 10 10 10 10 10 10 10 10 10 92 34978130 10 10 10 10 10 10 10 10 10 9 10 95 147622195 10 10 8 10 10 10 8 8 9 9 10 94 72119100 10 10 8 10 10 10 9 10 9 00 9 93 147623193 10 10 10 10 10 10 10 9 9 00 10 87 147624191 10 10 10 10 9 7 00 4 80 147625198 10 10 10 10 10 10 10 10 9 00 9 92 147626196 10 10 10 10 10 9 10 8 9 10 85 147627194 7 3 7 2 3 8 00 6 80 147628192 10 10 9 10 10 10 10 10 9 00 9 92 147639199 10 10 10 10 10 10 10 10 10 9 10 90 147641195 10 10 9 10 10 10 10 10 9 9 9 92 147642193 10 10 10 10 10 10 10 10 10 10 10 95 147645196 10 10 10 10 10 10 10 10 10 10 10 94