Using SQL queries to extract data from a PostgreSQL database

Table of contents TL;DR Making use of SQLAlchemy and SQL queries, I extract EU industry production data for further analysis from the PostgreSQL database where I previously stored it. Long Description Building on the previous projects, I use SQLAlchemy to connect to a local PostgreSQL database that contains as a table an EU industry production…

 Continue reading

Storing a pandas dataframe in a PostgreSQL database

Table of contents TL;DR Paragraph I store EU industry production data in a PostgreSQL database using the SQLAlchemy package. Long Description Building on the previous project, I download an EU industry production dataset from the EU Open Data Portal, put it in a pandas dataframe, and store it in a PostgreSQL database. Using such a…

 Continue reading

Automated data retrieval from an online repository to harness free data sources

Table of contents TL;DR I obtain monthly EU industry production data from the European Union Open Data Portal through an API. Long Description Using the Python requests package, I access the API of the European Union Open Data Portal and search for the monthly EU industry production dataset. I learn which commands to use to…

 Continue reading