Table of contents TL;DR I specify the software versions that I used for the analysis of the EU industry production dataset and provide links to the Github repository where the Jupyter notebooks are stored. Project Background For the analysis of the EU industry production dataset that is summarized here, I made use of various software…
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…
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…
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…