Plotly express
Setup
Import data
2699
108
Zambia
1199
48
Italy
1324
53
Kyrgyz Republic
1299
52
Kenya
1274
51
Kazakhstan
2649
106
Vietnam
1249
50
Japan
1224
49
Jamaica
1174
47
Israel
1374
55
Lithuania
Dataset definitions
0
country
Standardized country name (from PWT)
1
year
Year
2
Y
GDP
3
K
Physical Capital
4
pop
Population
5
L
Labor Force
6
s
Years of Schooling
7
alpha_it
Variable Capital Share
8
GDPpc
GDP per capita
9
lp
Labor Productivity
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
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
468
China
2008
1068
India
2008
1093
Indonesia
2008
474
China
2014
1074
India
2014
1099
Indonesia
2014
1000
41
Hong Kong
1150
47
Israel
1225
50
Japan
1975
80
Saudi Arabia
2050
83
Singapore
2300
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
6.5
2.9
1991
6.6
2.91
1992
6.71
2.92
1993
6.81
2.93
1994
6.92
2.95
1995
7.02
2.96
1996
7.11
2.96
1997
7.2
2.96
1998
7.29
2.96
1999
7.38
2.96
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
8.54
8.56
std
1.19
1.19
min
6.16
6.2
25%
7.57
7.59
50%
8.68
8.71
75%
9.6
9.63
max
10.49
10.51
<ipython-input-39-e24b465a3f55>: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.
df1_gdppc_wide.std().round(2).plot();
loc
0
8.1303272
8.1708374
1
8.8438606
8.8517218
2
8.964241
9.0307903
3
8.1737623
8.1513538
4
10.187983
10.216832
5
10.117168
10.14943
6
7.249866
7.2520657
7
10.079113
10.107697
8
7.0329933
7.0541086
9
7.6487226
7.686933
isin
450
19
China
451
19
China
452
19
China
453
19
China
454
19
China
455
19
China
456
19
China
457
19
China
458
19
China
459
19
China