Loopy is the PCS data processing system. It is capable of preprocessing the PCS source files, extracting data from excel sheets, inserting data into CapTop database, and sending report emails. The figure below abstracts the structures of the Loopy system.
- Python 2.7
- HTML.py - Formatting html tables for email reports
- xlrd - Parsing excel sheets
- Before running the scripts, make changes to the database connection file in ./Credentials
- Run Loopy.py directly