Motivation
- Data has to be securely and efficiently added to a database to be accessed by Data Analysts and Scientists
Aims and Objectives
- Construction of data models using an ORM ideally SQL-Alchemy.
- Data manipulation
- Data Validation before data upload to the Database
- Python module that obtains different views from the database;
- Answer the qestions provided in the specification using the module constructed in objetive 4
Tools Used
- Python
- Object-Relational Mapping --> SQLAlchemy ORM
- Database --> PostgreSQL
- Data Manipulation --> Pandas