Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

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

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database And Expert Systems Applications 33rd International Conference Dexa 2022 Vienna Austria August 22 24 2022 Proceedings Part 1 Lncs 13426

Authors: Christine Strauss ,Alfredo Cuzzocrea ,Gabriele Kotsis ,A Min Tjoa ,Ismail Khalil

1st Edition

3031124227, 978-3031124228

More Books

Students explore these related Databases questions

Question

Define and measure service productivity.

Answered: 3 weeks ago