Chapman

An interactive, CLI-based program to do ETL work and data migrations with a variety of formats.

Key Tools Used

• Python3

• Pandas

• SQL Alchemy

• Psycopg2

  *See requirements.txt for more info.

Sample Data

The data directory has various files with mock data to seed the database tables (see etl_db.sql) with.

Program Execution

• Create a venv, and activate it.
• Run pip install -r requirements.txt to install dependencies.
• Run main.py, and select from the options provided.