This is assuming you are on a windows computer.
It is preferable to run this code in a python venv
by running:
py -m venv .venv
Thereafter, please install the dependencis using (basically only the pandas
and openpyxl
library):
pip install -r requirements.txt
Run the main script using:
py main.py
It will output the Rating Thresholds for Task 3 in stdout and create 2 files: restaurant_events.csv
and restaurants.csv
in the same folder.
Run the following for some basic unit tests to check the 2 output CSVs for the correct columns and if the first data is correct
py unit_tests.py
One possible way to run this script is to upload the data files to an AWS S3
and then run it with AWS Lambda
Alternatively, the files could be directly downloaded during the AWS Lambda
run-time.