Setup
Import data
0
1
Albania
1
1
Albania
2
1
Albania
3
1
Albania
4
1
Albania
5
1
Albania
6
1
Albania
7
1
Albania
8
1
Albania
9
1
Albania
Dataset definitions
20
log_GDPpc
Trend (HP400) of log of GDP per capita
21
log_lp
Trend (HP400) of log of labor productivity
22
log_ky
Trend (HP400) of log of Capital-Output Ratio
23
log_h
Trend (HP400) of log of Human Capital
24
log_tfp
Trend (HP400) of log of Aggregate Efficiency
25
region
Regional group (Classification of the UN)
26
hi1990
High income country (as of 1990, World Bank classification)
27
isocode
ISO code from the PWT9.0
Descriptive statistics
count
2700
2700
mean
54.5
2002
std
31.18
7.21
min
1
1990
25%
27.75
1996
50%
54.5
2002
75%
81.25
2008
max
108
2014
Prepare data
select
0
Albania
1990
1
Albania
1991
2
Albania
1992
3
Albania
1993
4
Albania
1994
5
Albania
1995
6
Albania
1996
7
Albania
1997
8
Albania
1998
9
Albania
1999
query
24
Albania
Europe
49
Algeria
Africa
74
Argentina
Americas
99
Armenia
Asia
124
Australia
Oceania
149
Austria
Europe
174
Bangladesh
Asia
199
Belgium
Europe
224
Benin
Africa
249
Bolivia
Americas
450
China
1990
451
China
1991
452
China
1992
453
China
1993
454
China
1994
455
China
1995
456
China
1996
457
China
1997
458
China
1998
459
China
1999
474
China
2014
1249
Japan
2014
2574
United States
2014
1024
41
Hong Kong
1174
47
Israel
1249
50
Japan
1999
80
Saudi Arabia
2074
83
Singapore
2324
93
Taiwan
groupby
Africa
2014
7.85
Americas
2014
9.37
Asia
2014
9.37
Europe
2014
10.34
Oceania
2014
10.58
Africa
0
0.9
Americas
0
0.77
Asia
0
0.99
Europe
0
0.46
Oceania
0
0.23
Africa
7.85
0.9
Americas
9.37
0.77
Asia
9.37
0.99
Europe
10.34
0.46
Oceania
10.58
0.23
1990
9784
9475.93
1991
9691.21
9439.95
1992
9853.91
9812.31
1993
9807.26
9836.8
1994
10085.57
10243.55
1995
10444.12
10574.49
1996
10720.07
10815.95
1997
11163.58
11445.26
1998
11435.84
11924.91
1999
11808.07
12478.18
pivot_table
0
Albania
Europe
1
Algeria
Africa
2
Argentina
Americas
3
Armenia
Asia
4
Australia
Oceania
5
Austria
Europe
6
Bangladesh
Asia
7
Belgium
Europe
8
Benin
Africa
9
Bolivia
Americas
count
108
108
mean
6.5
6.6
std
2.9
2.91
min
0.89
0.92
25%
4.16
4.27
50%
6.98
7.14
75%
8.79
8.94
max
12.2
12.28
<ipython-input-84-cc31e97f6c18>:1: FutureWarning:
Dropping of nuisance columns in DataFrame reductions (with 'numeric_only=None') is deprecated; in a future version this will raise TypeError. Select only valid columns before calling the reduction.
loc
0
9.4794703
9.5531235
1
5.6700468
5.6431899
2
8.7291193
8.860137
3
10.43533
10.44917
4
11.07401
11.13605
5
8.9735966
9.0365973
6
4.479104
4.6311288
7
10.28909
10.34962
8
3.114677
3.236423
9
8.2890062
8.3287563
isin
1225
50
Japan
1226
50
Japan
1227
50
Japan
1228
50
Japan
1229
50
Japan
1230
50
Japan
1231
50
Japan
1232
50
Japan
1233
50
Japan
1234
50
Japan