R&D Personnel And Researchers In Business Enterprise Sector By Size Class And Sex

Eurostat code: rd_p_perssize · (1980 - 2023)

@eurostat.rd_p_perssize

Table List

2 tables(206.92 KB)

R&D Personnel And Researchers In Business Enterprise Sector By Size Class And Sex - Raw

R&D Personnel And Researchers In Business Enterprise Sector By Size Class And Sex - Unpivoted

R&D Personnel And Researchers In Business Enterprise Sector By Size Class And Sex - Unpivoted

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

88.15 KB
15565 rows
8 columns

freq Freq	prof_pos Prof Pos	sizeclas Sizeclas	unit Unit	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Researchers	Total	Full-time equivalent (FTE)	Total	Hungary	1980	14993
Annual	Researchers	Total	Full-time equivalent (FTE)	Total	Japan	1980	184889
Annual	Researchers	Total	Full-time equivalent (FTE)	Total	Poland	1980	65500
Annual	Total	Total	Full-time equivalent (FTE)	Total	Spain	1980	12303
Annual	Total	Total	Full-time equivalent (FTE)	Total	Hungary	1980	14993
Annual	Total	Total	Full-time equivalent (FTE)	Total	Japan	1980	349480
Annual	Total	Total	Full-time equivalent (FTE)	Total	Poland	1980	65500
Annual	Researchers	Total	Full-time equivalent (FTE)	Total	Austria	1981	2886
Annual	Researchers	Total	Full-time equivalent (FTE)	Total	Belgium	1981	5152
Annual	Researchers	Total	Full-time equivalent (FTE)	Total	Germany	1981	77017


CREATE TABLE tidy (
  "freq" VARCHAR,
  "prof_pos" VARCHAR,
  "sizeclas" VARCHAR,
  "unit" VARCHAR,
  "sex" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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