Python program (use any package necessary like Xlrd, openpyxl) and paste the cod
ID: 3816060 • Letter: P
Question
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 you’d 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)
Explanation / Answer
def watchout_for_riaa_mpaa():
print "there are honeypot kesha songs on bittorrent that log IP " +
"addresses of seeders and leechers. Then comcast records strikes against " +
"that user and thus, the free internet was transmogified into " +
"a pay-per-view cable-tv enslavement device back in the 20th century."
import sys
import os
sys.path.append(os.path.abspath("/home/el/foo4/bittorrent"))
from riaa import *
watchout_for_riaa_mpaa()
el@apollo:/home/el/foo4$ python main.py
there are honeypot kesha songs on bittorrent
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.