Export To Import Ratio

Eurostat code: egi_tr1 · (2007 - 2023)

@eurostat.egi_tr1

Table List

2 tables(22.81 KB)

Export To Import Ratio - Unpivoted

@eurostat.egi_tr1.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.79 KB
649 rows
5 columns

freq Freq	indic_et Indic Et	geo Geo	time_period Time Period	value Value
Annual	Export/import ratio	Albania	2007	0.51
Annual	Export/import ratio	Austria	2007	1.09
Annual	Export/import ratio	Bosnia and Herzegovina	2007	0.48
Annual	Export/import ratio	Belgium	2007	1.05
Annual	Export/import ratio	Bulgaria	2007	0.74
Annual	Export/import ratio	Switzerland	2007	1.23
Annual	Export/import ratio	Cyprus	2007	0.92
Annual	Export/import ratio	Czechia	2007	1.04
Annual	Export/import ratio	Germany	2007	1.18
Annual	Export/import ratio	Denmark	2007	1.06


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

Share link

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