Eurozone Economic Data Analysis

This repository contains Jupyter notebooks that visually analyze Eurozone's Economic data as provided by the Eurostat, the ECB, the OECD, and Yahoo-Finance. The analysis is carried out using Pandas, Matplotlib and a combination of Eurostat, SDMX, and yfinance libraries for data retrieval via APIs.

So far I created the following notebooks (following a given link lets you see the most recent run of its notebook, I aim to refresh results monthly):

• Analysis of consumer prices inflation, wage inflation, level of risk-free interest rates, and GDP, plus a similar analysis for the the US by way of comparison
• Analysis of Eurozone Past, Current, and Future Riskfree Rates, plus a similar analysis for the US
• Analysis of Participation, Employment, Unemployment, Job-vacancy, and Unfilled Vacancies to Population Rates, plus a similar analysis for the US by way of comparison
• Analysis of Eurozone Money Supply, plus a similar analysis for the US
• Analysis of Quantitative Easing and Tapering by the ECB
• Analysis of Eurozone GDP, its composition by industry, and trends in its make-up, plus a similar analysis for the US
• Analysis of Eurozone Labor productivity (incl. comparison with that in the US)
• Analysis of disposable income and savings rates of Eurozone individuals, plus a similar analysis for the US
• Analysis for Stoxx Europe 600 Banks Index & Analysis for the AEX Index, plus a similar analysis of US Stock Market, including various metrics on the S&P 500 Index

Requirements

You'll need python3 and pip. brew install python will do if you are on macOS. You can even forgo installing anything and run these notebooks in Google cloud, as I outline below.

In case you opt for a local installation, the rest of the dependencies can be installed as follows:

python3 -m pip install -r requirements.txt

NB: I use Yahoo-Finance data in the Current_Riskfree_Rates_Eurozone.ipynb notebook. I switched fully to yfinance for working with Yahoo-Finance data due to its better maintenance and frequent new releases.

How to run locally

If you want to run the notebooks locally on your laptop, clone the repo and cd into its directory, e.g.:

git clone -l -s https://github.com/ilchen/EU_Economic_Data_Analysis.git
cd EU_Economic_Data_Analysis

run one of the below commands depending on which notebook you are interested in:

jupyter notebook HICP_and_ECB_Rates.ipynb

or

jupyter notebook Current_Riskfree_Rates_Eurozone.ipynb

or

jupyter notebook Unemployment_and_Participation_Rates_Eurozone.ipynb

or

jupyter notebook Money_Supply_Eurozone.ipynb

or

jupyter notebook Quantitative_Easing_and_Tapering_Eurozone.ipynb

or

jupyter notebook GDP_Composition_Eurozone.ipynb

or

jupyter notebook Labor_Productivity.ipynb

or

jupyter notebook Disposable_Income_and_Savings_Eurozone.ipynb

or

jupyter notebook Stock_Market_Stoxx_Europe_Banks.ipynb

or

jupyter notebook Stock_Market_NL.ipynb

How to run in Google cloud

You can also run these notebooks in Google cloud. This way you don't need to install anything locally. This takes just a few seconds:

1. Go to Google Colaboratory in your browser
2. In the modal window that appears select GitHub
3. Enter the URL of this repository's notebook, e.g.: https://github.com/ilchen/EU_Economic_Data_Analysis/blob/main/HICP_and_ECB_Rates.ipynb or https://github.com/ilchen/EU_Economic_Data_Analysis/blob/main/Current_Riskfree_Rates_Eurozone.ipynb or https://github.com/ilchen/EU_Economic_Data_Analysis/blob/main/Unemployment_and_Participation_Rates_Eurozone.ipynb or https://github.com/ilchen/EU_Economic_Data_Analysis/blob/main/Money_Supply_Eurozone.ipynb or https://github.com/ilchen/EU_Economic_Data_Analysis/blob/main/Quantitative_Easing_and_Tapering_Eurozone.ipynb or https://github.com/ilchen/EU_Economic_Data_Analysis/blob/main/GDP_Composition_Eurozone.ipynb or https://github.com/ilchen/EU_Economic_Data_Analysis/blob/main/Labor_Productivity.ipynb or https://github.com/ilchen/EU_Economic_Data_Analysis/blob/main/Disposable_Income_and_Savings_Eurozone.ipynb or https://github.com/ilchen/EU_Economic_Data_Analysis/blob/main/Stock_Market_Stoxx_Europe_Banks.ipynb or https://github.com/ilchen/EU_Economic_Data_Analysis/blob/main/Stock_Market_NL.ipynb
4. Click the search icon
5. Enjoy
   In some of the notebooks I make use of additional python code I developed (e.g. Current_Riskfree_Rates_Eurozone.ipynb) or dependencies that are not by default provisioned in Google Colaboratory. When running these notebooks in Colaboratory, it's important to clone this repository and cd to it. I crated a commented out cell at the beginning of these notebooks to make it easier. Please don't forget to uncomment its content and run it first. E.g. here's one from Current_Riskfree_Rates_Eurozone.ipynb:

# Uncomment if running in Google Colaboratory, otherwise the import of the curves module in the cell below will fail
#!git clone -l -s https://github.com/ilchen/EU_Economic_Data_Analysis.git cloned-repo
#%cd cloned-repo

# Install the latest version of pandas-datareader and yfinance
# !pip install pandas-datareader -U
# !pip install yfinance -U