Exchange Rates

Eurostat code: med_ec9 · (2005 - 2019)

@eurostat.med_ec9

Table List

2 tables(17.89 KB)

Exchange Rates - Unpivoted

@eurostat.med_ec9.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

5.01 KB
113 rows
5 columns

freq Freq	currency Currency	geo Geo	time_period Time Period	value Value
Annual	Euro	Algeria	2005	91.163
Annual	Euro	Egypt	2005	7.189
Annual	Euro	Israel	2005	5.583
Annual	Euro	Jordan	2005	0.882
Annual	Euro	Lebanon	2005	1875.481
Annual	Euro	Libya	2005	1.628
Annual	Euro	Morocco	2005	11.021
Annual	Euro	Tunisia	2005	1.614
Annual	Euro	Algeria	2006	91.215
Annual	Euro	Egypt	2006	7.199


CREATE TABLE tidy (
  "freq" VARCHAR,
  "currency" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.