Skip to content

RK-K2/Excel-Report--Python

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Excel-Report--Python

Basic Excel reporting using Python Pandas and Numpy

We receive multiple feeds from different vendors and like to see if all the files that received were within SLA. We can determine if the vendor met the SLA by comparing the Input arrival time and SLA time. This notebook will compare the Input arrival time and SLA time and create a new column SLA-CHECK with "Y"/"N." For easy identification and reporting, the column can be color coded. The same details can be exported to excel and share with the stakeholders.

Following Libraries used:

Pandas -> For reading excel numpy -> For condition

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors