Python tools for Extraction, Transformation and Loading of Euroleague and Eurocup data.
A Python tool that fetches json files from the responses of the API with endpoint https://live.euroleague.net/api/, and URI parameters Header, Boxscore, ShootingGraphic, Points, Comparison and PlaybyPlay.
Folders that include samples of the json files that are fetched by the api_requests tool.
Folders that include samples of the csv files that are created by the tables_to_csv tool. The complete csv files exist in Kaggle and are regularly updated https://www.kaggle.com/datasets/babissamothrakis/euroleague-datasets
A few images for the documentation of the project.
A Python tool that loads the fetched json files of the API responses to a PostgreSQL database.
A Python tool that creates one csv file for each available table of the PostgreSQL database.