Python program (use any package necessary like Xlrd, openpyxl) and paste the code as the answer to this question.

A very interesting assignment:

Write a program that keeps tracks how many times a student has been late to class and outputs a number in the N.o days Late column in excel. Import file A and Import file B in your Python program.

When you look at them youd notice Student named Sanjay, Raamish, Rikesh and Danerys are present in both files as they were late yesterday and were late today.

Write a code that reads the excel file from yesterday (link will be given to you) and today and In the N.o days Late column lists the number of days students were late late to class. These students (Sanjay, Raamish, Rikesh and Danerys) should have 2 in the N.o days Late column as they were late both days and all other students should have 0 or 1.

Optional Also list the DAYS Sanjay was late along this is really easy to do because a date is provided in the excel files Python should spit out what Days he was late by itself.

Please find the links here

File A https://www.dropbox.com/s/gx7ix40v6bo0b30/Days%20Late%201.xlsx?dl=0

File B - https://www.dropbox.com/s/984mxbybhimkr59/Days%20Late%202.xlsx?dl=0

Paste your code below and please add a screenshot to show it worked (output)