Bringing an EU industry production dataframe into good shape

Table of contents TL;DR I use pandas dataframe methods to bring EU industry production data into a tidy format to facilitate further analysis. Long Description Here I use the Python packages SQLAlchemy and pandas to read in a subset of the EU industry production dataset from a local PostgreSQL database into a dataframe. I apply…

 Continue reading

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