Electricity And Gas Prices For Households, ENP-East Countries

Eurostat code: enpe_nrg_prchh · (2005 - 2023)

@eurostat.enpe_nrg_prchh

Table List

2 tables(20.23 KB)

Electricity And Gas Prices For Households, ENP-East Countries - Raw

Electricity And Gas Prices For Households, ENP-East Countries - Unpivoted

Electricity And Gas Prices For Households, ENP-East Countries - Unpivoted

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

4.87 KB
136 rows
6 columns

freq Freq	siec Siec	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Electricity	Euro per kilowatt-hour	Armenia	2005
Annual	Electricity	Euro per kilowatt-hour	Belarus	2005
Annual	Electricity	Euro per kilowatt-hour	Georgia	2005
Annual	Gas	Euro per gigajoule	Armenia	2005
Annual	Gas	Euro per gigajoule	Belarus	2005	1
Annual	Gas	Euro per gigajoule	Georgia	2005	4
Annual	Electricity	Euro per kilowatt-hour	Armenia	2006
Annual	Electricity	Euro per kilowatt-hour	Belarus	2006
Annual	Electricity	Euro per kilowatt-hour	Georgia	2006
Annual	Gas	Euro per gigajoule	Armenia	2006


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

Share link

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