Heat Pumps - Technical Characteristics By Technology And Climate

Eurostat code: nrg_ind_hptctc · (2004 - 2023)

@eurostat.nrg_ind_hptctc

Table List

2 tables(148.21 KB)

Heat Pumps - Technical Characteristics By Technology And Climate - Raw

Heat Pumps - Technical Characteristics By Technology And Climate - Unpivoted

Heat Pumps - Technical Characteristics By Technology And Climate - Unpivoted

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

56.98 KB
172032 rows
7 columns

freq Freq	plant_tec Plant Tec	hp_tech Hp Tech	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Installed thermal capacity	Aerothermal - air-air electrical - average climate	Gigawatt	Albania	2004
Annual	Installed thermal capacity	Aerothermal - air-air electrical - average climate	Gigawatt	Austria	2004
Annual	Installed thermal capacity	Aerothermal - air-air electrical - average climate	Gigawatt	Bosnia and Herzegovina	2004
Annual	Installed thermal capacity	Aerothermal - air-air electrical - average climate	Gigawatt	Belgium	2004	0.004
Annual	Installed thermal capacity	Aerothermal - air-air electrical - average climate	Gigawatt	Bulgaria	2004
Annual	Installed thermal capacity	Aerothermal - air-air electrical - average climate	Gigawatt	Cyprus	2004
Annual	Installed thermal capacity	Aerothermal - air-air electrical - average climate	Gigawatt	Czechia	2004
Annual	Installed thermal capacity	Aerothermal - air-air electrical - average climate	Gigawatt	Germany	2004
Annual	Installed thermal capacity	Aerothermal - air-air electrical - average climate	Gigawatt	Denmark	2004	0.342
Annual	Installed thermal capacity	Aerothermal - air-air electrical - average climate	Gigawatt	Euro area – 20 countries (from 2023)	2004	0.121


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

Share link

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