Python Script

python version 3.10.4

• python 3 script to read input_refresh_template sheet of provided excel (Analytics Template for Exercise.xlsx) and generate the output file as shown in output_31_days_report sheet

• Expected input in Analytics Template for Exercise (sheet name) input_refresh_template

• Expected output in Analytics Template for Exercise (sheet name) output_31_days_report

• Handle the empty file

• Handle the wrong sheet name

• Handle the wrong formatting of the end date and site id indexing

How To Run Script

python script.py

Run Pytest

pytest test.py