Compares a csv file of participants to the csv file of students in enrolled in the lab section. Students in the lab section that are not listed in the participants did not attend the session.
Some students forget to change their zoom name to their full name. This program tries to match ambiguous students to their real names.
-
Download the participants list csv file from zoom (instructions) (see formatting guidelines).
-
Add that csv file to the
student_files/participants
directory. Ensure that this file is the only file in that directory. Participant files from previous labs can be kept in thestudent_files/participants/previous
directory. -
Obtain a csv file that lists all the students in the lab section (see formatting guidelines).
-
Put the csv file (see formatting guidelines) of all students in the lab section in the
student_files/all_students
directory. Ensure that this file is the only file in that directory. -
Run
app.py
.
No blank lines unless it's a single blank line at the beginning or end of the file.
First line: Name (Original Name),User Email,Total Duration (Minutes),Guest
Next lines: comma-separated values with each comma-separated value corresponding to a column
Students' full names column: first non digit column, values are in the form
"<last_name>,<first_name>"
or "<last_name>,<first_name> <middle_name>"
TODO