Hello, can you help me? Allowed to import all libraries and use Python 3.2 csv files for testing. file1.csv: https://drive.google.com/file/d/1XB9CDdO_lx5Bmj0hoq_xjKAgJK6-MHOI/view file2.csv: https://drive.google.com/file/d/1qtQjP-nA29Dv0BU-rj3arqCAQkoR5Z_Y/view
Using Python 3+, allowing to import any libraries. You are asked to develop a program which processes the CSV file and checks 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 asks the user to enter the name of the activity (example: Assignment1). The program locates the "Assignment1" in the first row. The program extracts student IDs and all grades in that column, and displays the student IDs who don't have a grade for that activity.
Apply partial search. If the user enters "Assignment", the program extracts all columns which have the keyword "Assignment" and counts the number of submitted activities/total number of activities. Then, it displays them as follows:
Student ID No of submitted Assignment
H22222 4/8
433333 8/8
144444 0/8