Day-to-day Rates For Euro Area Countries - Annual Data

Eurostat code: irt_h_ddmr_a · (1970 - 2014)

@eurostat.irt_h_ddmr_a

Table List

2 tables(40.66 KB)

Day-to-day Rates For Euro Area Countries - Annual Data - Raw

Day-to-day Rates For Euro Area Countries - Annual Data - Unpivoted

Day-to-day Rates For Euro Area Countries - Annual Data - Unpivoted

@eurostat.irt_h_ddmr_a.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.

7.39 KB
334 rows
5 columns

freq Freq	int_rt Int Rt	geo Geo	time_period Time Period	value Value
Annual	Day-to-day rate	Belgium	1970	6.26296
Annual	Day-to-day rate	Luxembourg	1970	6.26296
Annual	Day-to-day rate	Belgium	1971	3.71271
Annual	Day-to-day rate	Luxembourg	1971	3.71271
Annual	Day-to-day rate	Belgium	1972	2.5106
Annual	Day-to-day rate	Luxembourg	1972	2.5106
Annual	Day-to-day rate	Belgium	1973	4.81348
Annual	Day-to-day rate	Germany	1973	10.23249
Annual	Day-to-day rate	France	1973	8.7263
Annual	Day-to-day rate	Ireland	1973	11.88504


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

Share link

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