This deepnote is an inspiration from my exemplary data science lecturer, Professor Carlos Mendez
#Here is a motivational video to all future data scientists from the famous Swedish physician and academia Hans Rosling's
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
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
#Here is a video to understand how pandas work, enjoy!
select
#Subset your data and tailor make to your preferences
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
1275
Kenya
4.7802682
1276
Kenya
4.8770199
1277
Kenya
4.973773
1278
Kenya
5.0705252
1279
Kenya
5.1672778
1280
Kenya
5.26403
1281
Kenya
5.3485351
1282
Kenya
5.4330401
1283
Kenya
5.5175438
1284
Kenya
5.6020479
324
Burundi
2014
649
Democratic Republic of Congo
2014
1299
Kenya
2014
1974
Rwanda
2014
2374
Tanzania
2014
2499
Uganda
2014
25
2
Algeria
200
9
Benin
300
13
Burundi
350
15
Cameroon
400
17
Central African Republic
500
21
Congo
550
23
Cote d'Ivoire
625
26
Democratic Republic of Congo
725
30
Egypt
875
36
Ghana
groupby
Africa
2014
3758.65
Americas
2014
14866.46
Asia
2014
17677.28
Europe
2014
32943.2
Oceania
2014
38651.73
Africa
0
3675.67
Americas
0
11908.32
Asia
0
16765.34
Europe
0
14573.41
Oceania
0
6984.17
Africa
2.4
0.5
Americas
3.22
0.56
Asia
3.35
0.71
Europe
4.04
0.41
Oceania
3.89
0.28
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
Visualize data
#Here is a video to simplify visualization , take a look !