Question
Original Question was posted here - https://www.chegg.com/homework-help/questions-and-answers/python-program-use-package-necessary-like-xlrd-openpyxl-paste-code-answer-question-interes-q20521057 Problem - The person had to write to the Excel file something that wasn't done. You can use
Original Question was posted here - https://www.chegg.com/homework-help/questions-and-answers/python-program-use-package-necessary-like-xlrd-openpyxl-paste-code-answer-question-interes-q20521057
Problem - The person had to write to the Excel file something that wasn't done. You can use their code but use Python "openpyxl" or "xlsxwriter" package as you will not just be READING the excel file but also writing to the excel file in the N.o days Late column in excel.
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 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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started