The Mission
The objective of the project is to be able to extract the API information in JSON format using API calls 
using Python pipelines, store the information in an SQLite database and manipulate the information through a GUI application.
For all the information, you can go tho the project repository
The tools
- Python
- Request
- JSON
- Pandas
- PyQt5
- dotenv
- sqlite3
- statistics
- collections
Python Packages
The project is divided into three main areas: API Gateway, SQL Translator and GUI & Auxiliary Modules
API GATEWAY
Scripts were created using Python that are responsible for making requests, transforming data into a unified format and storing them in a specific data structure for future storage.
SQL Translator
Created an adapter and translator between Python and SQLite to abstract the storage and extraction of useful information.
GUI & Auxiliary Modules
Multiple modules have also been created for the general operation of the application, such as visual object builders, map creators and handlers of GeoJSON and demographic files from the Dutch Government.
Profile