In [8]:
import pandas as pd
pd.options.display.html.table_schema = True
pd.options.display.max_rows = None
In [9]:
df = pd.read_csv("https://gist.githubusercontent.com/rgbkrk/a7984a8788a73e2afb8fd4b89c8ec6de/raw/db8d1db9f878ed448c3cac3eb3c9c0dc5e80891e/2015.csv")
In [16]:
df["Region"].unique()
Out[16]:
array(['Western Europe', 'North America', 'Australia and New Zealand',
'Middle East and Northern Africa', 'Latin America and Caribbean',
'Southeastern Asia', 'Central and Eastern Europe', 'Eastern Asia',
'Sub-Saharan Africa', 'Southern Asia'], dtype=object)
In [11]:
df = df.set_index("Country")
In [19]:
df[(df['Region'] == 'Central and Eastern Europe') | (df['Region'] == 'Sub-Saharan Africa')]
Out[19]:
Region
Happiness Rank
Happiness Score
Standard Error
Economy (GDP per Capita)
Family
Health (Life Expectancy)
Freedom
Trust (Government Corruption)
Generosity
Dystopia Residual
Country
Czech Republic
Central and Eastern Europe
31
6.505
0.04168
1.17898
1.20643
0.84483
0.46364
0.02652
0.10686
2.67782
Uzbekistan
Central and Eastern Europe
44
6.003
0.04361
0.63244
1.34043
0.59772
0.65821
0.30826
0.22837
2.23741
Slovakia
Central and Eastern Europe
45
5.995
0.04267
1.16891
1.26999
0.78902
0.31751
0.03431
0.16893
2.24639
Moldova
Central and Eastern Europe
52
5.889
0.03799
0.59448
1.01528
0.61826
0.32818
0.01615
0.20951
3.10712
Kazakhstan
Central and Eastern Europe
54
5.855
0.04114
1.12254
1.12241
0.64368
0.51649
0.08454
0.11827
2.24729
Slovenia
Central and Eastern Europe
55
5.848
0.04251
1.18498
1.27385
0.87337
0.60855
0.03787
0.25328
1.61583
Lithuania
Central and Eastern Europe
56
5.833
0.03843
1.14723
1.25745
0.73128
0.21342
0.01031
0.02641
2.44649
Belarus
Central and Eastern Europe
59
5.813
0.03938
1.03192
1.23289
0.73608
0.37938
0.19090
0.11046
2.13090
Poland
Central and Eastern Europe
60
5.791
0.04263
1.12555
1.27948
0.77903
0.53122
0.04212
0.16759
1.86565
Croatia
Central and Eastern Europe
62
5.759
0.04394
1.08254
0.79624
0.78805
0.25883
0.02430
0.05444
2.75414
Russia
Central and Eastern Europe
64
5.716
0.03135
1.13764
1.23617
0.66926
0.36679
0.03005
0.00199
2.27394
Kosovo
Central and Eastern Europe
69
5.589
0.05018
0.80148
0.81198
0.63132
0.24749
0.04741
0.28310
2.76579
Turkmenistan
Central and Eastern Europe
70
5.548
0.04175
0.95847
1.22668
0.53886
0.47610
0.30844
0.16979
1.86984
Mauritius
Sub-Saharan Africa
71
5.477
0.07197
1.00761
0.98521
0.70950
0.56066
0.07521
0.37744
1.76145
Estonia
Central and Eastern Europe
73
5.429
0.04013
1.15174
1.22791
0.77361
0.44888
0.15184
0.08680
1.58782
Kyrgyzstan
Central and Eastern Europe
77
5.286
0.03823
0.47428
1.15115
0.65088
0.43477
0.04232
0.30030
2.23270
Nigeria
Sub-Saharan Africa
78
5.268
0.04192
0.65435
0.90432
0.16007
0.34334
0.04030
0.27233
2.89319
Azerbaijan
Central and Eastern Europe
80
5.212
0.03363
1.02389
0.93793
0.64045
0.37030
0.16065
0.07799
2.00073
Montenegro
Central and Eastern Europe
82
5.192
0.05235
0.97438
0.90557
0.72521
0.18260
0.14296
0.16140
2.10017
Zambia
Sub-Saharan Africa
85
5.129
0.06988
0.47038
0.91612
0.29924
0.48827
0.12468
0.19591
2.63430
Romania
Central and Eastern Europe
86
5.124
0.06607
1.04345
0.88588
0.76890
0.35068
0.00649
0.13748
1.93129
Serbia
Central and Eastern Europe
87
5.123
0.04864
0.92053
1.00964
0.74836
0.20107
0.02617
0.19231
2.02500
Latvia
Central and Eastern Europe
89
5.098
0.04640
1.11312
1.09562
0.72437
0.29671
0.06332
0.18226
1.62215
Somaliland region
Sub-Saharan Africa
91
5.057
0.06161
0.18847
0.95152
0.43873
0.46582
0.39928
0.50318
2.11032
Macedonia
Central and Eastern Europe
93
5.007
0.05376
0.91851
1.00232
0.73545
0.33457
0.05327
0.22359
1.73933
Mozambique
Sub-Saharan Africa
94
4.971
0.07896
0.08308
1.02626
0.09131
0.34037
0.15603
0.22269
3.05137
Albania
Central and Eastern Europe
95
4.959
0.05013
0.87867
0.80434
0.81325
0.35733
0.06413
0.14272
1.89894
Bosnia and Herzegovina
Central and Eastern Europe
96
4.949
0.06913
0.83223
0.91916
0.79081
0.09245
0.00227
0.24808
2.06367
Lesotho
Sub-Saharan Africa
97
4.898
0.09438
0.37545
1.04103
0.07612
0.31767
0.12504
0.16388
2.79832
Swaziland
Sub-Saharan Africa
101
4.867
0.08742
0.71206
1.07284
0.07566
0.30658
0.03060
0.18259
2.48676
Hungary
Central and Eastern Europe
104
4.800
0.06107
1.12094
1.20215
0.75905
0.32112
0.02758
0.12800
1.24074
Tajikistan
Central and Eastern Europe
106
4.786
0.03198
0.39047
0.85563
0.57379
0.47216
0.15072
0.22974
2.11399
Ukraine
Central and Eastern Europe
111
4.681
0.04412
0.79907
1.20278
0.67390
0.25123
0.02961
0.15275
1.57140
South Africa
Sub-Saharan Africa
113
4.642
0.04585
0.92049
1.18468
0.27688
0.33207
0.08884
0.11973
1.71956
Ghana
Sub-Saharan Africa
114
4.633
0.04742
0.54558
0.67954
0.40132
0.42342
0.04355
0.23087
2.30919
Zimbabwe
Sub-Saharan Africa
115
4.610
0.04290
0.27100
1.03276
0.33475
0.25861
0.08079
0.18987
2.44191
Liberia
Sub-Saharan Africa
116
4.571
0.11068
0.07120
0.78968
0.34201
0.28531
0.06232
0.24362
2.77729
Sudan
Sub-Saharan Africa
118
4.550
0.06740
0.52107
1.01404
0.36878
0.10081
0.14660
0.19062
2.20857
Congo (Kinshasa)
Sub-Saharan Africa
120
4.517
0.03680
0.00000
1.00120
0.09806
0.22605
0.07625
0.24834
2.86712
Ethiopia
Sub-Saharan Africa
122
4.512
0.03780
0.19073
0.60406
0.44055
0.43450
0.15048
0.24325
2.44876
Sierra Leone
Sub-Saharan Africa
123
4.507
0.07068
0.33024
0.95571
0.00000
0.40840
0.08786
0.21488
2.51009
Mauritania
Sub-Saharan Africa
124
4.436
0.03947
0.45407
0.86908
0.35874
0.24232
0.17461
0.21900
2.11773
Kenya
Sub-Saharan Africa
125
4.419
0.04734
0.36471
0.99876
0.41435
0.42215
0.05839
0.37542
1.78555
Djibouti
Sub-Saharan Africa
126
4.369
0.08096
0.44025
0.59207
0.36291
0.46074
0.28105
0.18093
2.05125
Armenia
Central and Eastern Europe
127
4.350
0.04763
0.76821
0.77711
0.72990
0.19847
0.03900
0.07855
1.75873
Botswana
Sub-Saharan Africa
128
4.332
0.04934
0.99355
1.10464
0.04776
0.49495
0.12474
0.10461
1.46181
Georgia
Central and Eastern Europe
130
4.297
0.04221
0.74190
0.38562
0.72926
0.40577
0.38331
0.05547
1.59541
Malawi
Sub-Saharan Africa
131
4.292
0.06130
0.01604
0.41134
0.22562
0.43054
0.06977
0.33128
2.80791
Cameroon
Sub-Saharan Africa
133
4.252
0.04678
0.42250
0.88767
0.23402
0.49309
0.05786
0.20618
1.95071
Bulgaria
Central and Eastern Europe
134
4.218
0.04828
1.01216
1.10614
0.76649
0.30587
0.00872
0.11921
0.89991
Angola
Sub-Saharan Africa
137
4.033
0.04758
0.75778
0.86040
0.16683
0.10384
0.07122
0.12344
1.94939
Mali
Sub-Saharan Africa
138
3.995
0.05602
0.26074
1.03526
0.20583
0.38857
0.12352
0.18798
1.79293
Congo (Brazzaville)
Sub-Saharan Africa
139
3.989
0.06682
0.67866
0.66290
0.31051
0.41466
0.11686
0.12388
1.68135
Comoros
Sub-Saharan Africa
140
3.956
0.04797
0.23906
0.79273
0.36315
0.22917
0.19900
0.17441
1.95812
Uganda
Sub-Saharan Africa
141
3.931
0.04317
0.21102
1.13299
0.33861
0.45727
0.07267
0.29066
1.42766
Senegal
Sub-Saharan Africa
142
3.904
0.03608
0.36498
0.97619
0.43540
0.36772
0.10713
0.20843
1.44395
Gabon
Sub-Saharan Africa
143
3.896
0.04547
1.06024
0.90528
0.43372
0.31914
0.11091
0.06822
0.99895
Niger
Sub-Saharan Africa
144
3.845
0.03602
0.06940
0.77265
0.29707
0.47692
0.15639
0.19387
1.87877
Tanzania
Sub-Saharan Africa
146
3.781
0.05061
0.28520
1.00268
0.38215
0.32878
0.05747
0.34377
1.38079
Madagascar
Sub-Saharan Africa
147
3.681
0.03633
0.20824
0.66801
0.46721
0.19184
0.08124
0.21333
1.85100
Central African Republic
Sub-Saharan Africa
148
3.678
0.06112
0.07850
0.00000
0.06699
0.48879
0.08289
0.23835
2.72230
Chad
Sub-Saharan Africa
149
3.667
0.03830
0.34193
0.76062
0.15010
0.23501
0.05269
0.18386
1.94296
Guinea
Sub-Saharan Africa
150
3.656
0.03590
0.17417
0.46475
0.24009
0.37725
0.12139
0.28657
1.99172
Ivory Coast
Sub-Saharan Africa
151
3.655
0.05141
0.46534
0.77115
0.15185
0.46866
0.17922
0.20165
1.41723
Burkina Faso
Sub-Saharan Africa
152
3.587
0.04324
0.25812
0.85188
0.27125
0.39493
0.12832
0.21747
1.46494
Rwanda
Sub-Saharan Africa
154
3.465
0.03464
0.22208
0.77370
0.42864
0.59201
0.55191
0.22628
0.67042
Benin
Sub-Saharan Africa
155
3.340
0.03656
0.28665
0.35386
0.31910
0.48450
0.08010
0.18260
1.63328
Burundi
Sub-Saharan Africa
157
2.905
0.08658
0.01530
0.41587
0.22396
0.11850
0.10062
0.19727
1.83302
Togo
Sub-Saharan Africa
158
2.839
0.06727
0.20868
0.13995
0.28443
0.36453
0.10731
0.16681
1.56726
In [ ]:
In [ ]:
In [ ]:
Content source: jdfreder/nteract
Similar notebooks: