Data preparation for Tableau using Python

Clean and transform data and write file to .csv, .xlsx or GeoJSON to be used as a data source for Tableau dashboards and visualizations.

OECD - Convert ISO3 codes to country names

• Get country names from ISO-3 codes for datasets from OECD Data using country converter.
• Notebook: Convert ISO3 to country names

Unemployment rates in the EU

• explore data frame containing information on unemployment rates in the EU from 2002 to 2022
• get couintry names, rename columns, convert to datetime
• libraries used: pandas, numpy, country_converter
• Viz: Unemployment rates in the EU

Inflation rates in OECD countries

• explore dataset about quarterly inflation rates in OECD countries between 20128-2023
• get country names, select subset of columns, convert to datetime, replace values where country is OECD
• libraries used: pandas, numpy, country_converter
• Viz: Inflation in OECD countries

Country, continent and ISO-3 convert - Global Passport Index

• Notebook: Country, continent and ISO convert
• Get ISO-3 codes and continent from country names using country_converter
• Libraries used: pandas, numpy, country_converter
• Viz: The Henley Passport Index

Water fountains in Zürich

• Notebook: Water fountains
• explore two datasets containing information on water fountains in Zürich
• select and extract columns of interest and create new data frame
• libraries used: pandas, geopandas, matplotlib
• Viz: Public water fountains in Zürich

Anna Mándoki, 4 Aug 2023