User Story: As a developer, I have a database filled with all relevant driver and rider data.

Data Origin

We were able to track down a list of course offerings from an IBM website: https://zos.latech.edu/courses/maincampussumm.html

Process

From this we saved this html file and converted it to a csv, we then used multiple scripts to refine and filter the data down. We are then used two python libraries to add this data to the postgresql server psycopg2: https://pypi.org/project/psycopg2/ and pandas: https://pypi.org/project/pandas/

Location

all scripts are located in the in the db\UniJetScript\ folder. these scripts are in working condition, in order to run them the only changes that must be made is the addition of a hostname and password to connect to the database

Example

all scripts are similar in nature to the following one: