The data states the HDI rank, the HDI index value, components of HDI Index(Life expectancy at Birth, Expected years of schooling, mean years of schooling and Gross National income per capita) for every country. In many countries through out the world the standards of living of people have improved over these past few decades but we need much more improvement and we need to understand how fast are we improving and where has each country reached in that process to reach a high HDI score. Thus, we need a prediction of where will we be going for the next couple of years so that the governments can work on the things which are lagging. The data will help us understand which countries stand where and what they have to work on to imporve in order to achieve a high level of HDI score.
# import pandas lib as pd
import pandas as pd
import openpyxl
# read by default 1st sheet of an excel file
dataframe1 = pd.read_excel('HDI.xlsx')
print(dataframe1)
HDI rank Country Human Development Index (HDI) \
0 1 Switzerland 0.962
1 2 Norway 0.961
2 3 Iceland 0.959
3 4 Hong Kong, China (SAR) 0.952
4 5 Australia 0.951
.. ... ... ...
186 187 Burundi 0.426
187 188 Central African Republic 0.404
188 189 Niger 0.400
189 190 Chad 0.394
190 191 South Sudan 0.385
Life expectancy at birth (years) Expected years of schooling (years) \
0 83.9872 16.500299
1 83.2339 18.185200
2 82.6782 19.163059
3 85.4734 17.278170
4 84.5265 21.054590
.. ... ...
186 61.6627 10.722722
187 53.8947 8.040172
188 61.5763 6.957112
189 52.5254 8.035914
190 54.9752 5.542510
Mean years of schooling (years) \
0 13.859660
1 13.003630
2 13.767170
3 12.226210
4 12.726820
.. ...
186 3.129267
187 4.334000
188 2.116717
189 2.573774
190 5.726140
Gross national income (GNI) per capita ((2017 PPP $)
0 66933.004540
1 64660.106220
2 55782.049810
3 62606.845400
4 49238.433350
.. ...
186 731.786709
187 966.058611
188 1239.866936
189 1364.169417
190 767.787000
[191 rows x 7 columns]
print(dataframe1.to_dict())
{'HDI rank': {0: 1, 1: 2, 2: 3, 3: 4, 4: 5, 5: 6, 6: 7, 7: 8, 8: 9, 9: 10, 10: 11, 11: 12, 12: 13, 13: 13, 14: 15, 15: 16, 16: 17, 17: 18, 18: 19, 19: 19, 20: 21, 21: 22, 22: 23, 23: 23, 24: 25, 25: 26, 26: 27, 27: 28, 28: 29, 29: 30, 30: 31, 31: 32, 32: 33, 33: 34, 34: 35, 35: 35, 36: 35, 37: 38, 38: 39, 39: 40, 40: 40, 41: 42, 42: 42, 43: 44, 44: 45, 45: 46, 46: 47, 47: 48, 48: 49, 49: 50, 50: 51, 51: 52, 52: 53, 53: 54, 54: 55, 55: 56, 56: 57, 57: 58, 58: 58, 59: 60, 60: 61, 61: 62, 62: 63, 63: 63, 64: 63, 65: 66, 66: 67, 67: 68, 68: 68, 69: 70, 70: 71, 71: 72, 72: 73, 73: 74, 74: 75, 75: 76, 76: 77, 77: 78, 78: 79, 79: 80, 80: 80, 81: 80, 82: 83, 83: 84, 84: 85, 85: 86, 86: 87, 87: 88, 88: 89, 89: 90, 90: 91, 91: 91, 92: 91, 93: 91, 94: 95, 95: 96, 96: 97, 97: 97, 98: 99, 99: 99, 100: 101, 101: 102, 102: 102, 103: 104, 104: 105, 105: 106, 106: 106, 107: 108, 108: 109, 109: 110, 110: 111, 111: 112, 112: 112, 113: 114, 114: 115, 115: 116, 116: 117, 117: 118, 118: 118, 119: 120, 120: 121, 121: 122, 122: 123, 123: 123, 124: 125, 125: 126, 126: 127, 127: 128, 128: 129, 129: 130, 130: 131, 131: 132, 132: 133, 133: 134, 134: 135, 135: 136, 136: 137, 137: 138, 138: 139, 139: 140, 140: 140, 141: 140, 142: 143, 143: 144, 144: 145, 145: 146, 146: 146, 147: 148, 148: 149, 149: 150, 150: 151, 151: 152, 152: 153, 153: 154, 154: 155, 155: 156, 156: 156, 157: 158, 158: 159, 159: 160, 160: 161, 161: 162, 162: 163, 163: 163, 164: 165, 165: 166, 166: 166, 167: 168, 168: 169, 169: 170, 170: 171, 171: 172, 172: 173, 173: 174, 174: 175, 175: 176, 176: 177, 177: 178, 178: 179, 179: 180, 180: 181, 181: 182, 182: 183, 183: 184, 184: 185, 185: 186, 186: 187, 187: 188, 188: 189, 189: 190, 190: 191}, 'Country': {0: 'Switzerland', 1: 'Norway', 2: 'Iceland', 3: 'Hong Kong, China (SAR)', 4: 'Australia', 5: 'Denmark', 6: 'Sweden', 7: 'Ireland', 8: 'Germany', 9: 'Netherlands', 10: 'Finland', 11: 'Singapore', 12: 'Belgium', 13: 'New Zealand', 14: 'Canada', 15: 'Liechtenstein', 16: 'Luxembourg', 17: 'United Kingdom', 18: 'Japan', 19: 'Korea (Republic of)', 20: 'United States', 21: 'Israel', 22: 'Malta', 23: 'Slovenia', 24: 'Austria', 25: 'United Arab Emirates', 26: 'Spain', 27: 'France', 28: 'Cyprus', 29: 'Italy', 30: 'Estonia', 31: 'Czechia', 32: 'Greece', 33: 'Poland', 34: 'Bahrain', 35: 'Lithuania', 36: 'Saudi Arabia', 37: 'Portugal', 38: 'Latvia', 39: 'Andorra', 40: 'Croatia', 41: 'Chile', 42: 'Qatar', 43: 'San Marino', 44: 'Slovakia', 45: 'Hungary', 46: 'Argentina', 47: 'Türkiye', 48: 'Montenegro', 49: 'Kuwait', 50: 'Brunei Darussalam', 51: 'Russian Federation', 52: 'Romania', 53: 'Oman', 54: 'Bahamas', 55: 'Kazakhstan', 56: 'Trinidad and Tobago', 57: 'Costa Rica', 58: 'Uruguay', 59: 'Belarus', 60: 'Panama', 61: 'Malaysia', 62: 'Georgia', 63: 'Mauritius', 64: 'Serbia', 65: 'Thailand', 66: 'Albania', 67: 'Bulgaria', 68: 'Grenada', 69: 'Barbados', 70: 'Antigua and Barbuda', 71: 'Seychelles', 72: 'Sri Lanka', 73: 'Bosnia and Herzegovina', 74: 'Saint Kitts and Nevis', 75: 'Iran (Islamic Republic of)', 76: 'Ukraine', 77: 'North Macedonia', 78: 'China', 79: 'Dominican Republic', 80: 'Moldova (Republic of)', 81: 'Palau', 82: 'Cuba', 83: 'Peru', 84: 'Armenia', 85: 'Mexico', 86: 'Brazil', 87: 'Colombia', 88: 'Saint Vincent and the Grenadines', 89: 'Maldives', 90: 'Algeria', 91: 'Azerbaijan', 92: 'Tonga', 93: 'Turkmenistan', 94: 'Ecuador', 95: 'Mongolia', 96: 'Egypt', 97: 'Tunisia', 98: 'Fiji', 99: 'Suriname', 100: 'Uzbekistan', 101: 'Dominica', 102: 'Jordan', 103: 'Libya', 104: 'Paraguay', 105: 'Palestine, State of', 106: 'Saint Lucia', 107: 'Guyana', 108: 'South Africa', 109: 'Jamaica', 110: 'Samoa', 111: 'Gabon', 112: 'Lebanon', 113: 'Indonesia', 114: 'Viet Nam', 115: 'Philippines', 116: 'Botswana', 117: 'Bolivia (Plurinational State of)', 118: 'Kyrgyzstan', 119: 'Venezuela (Bolivarian Republic of)', 120: 'Iraq', 121: 'Tajikistan', 122: 'Belize', 123: 'Morocco', 124: 'El Salvador', 125: 'Nicaragua', 126: 'Bhutan', 127: 'Cabo Verde', 128: 'Bangladesh', 129: 'Tuvalu', 130: 'Marshall Islands', 131: 'India', 132: 'Ghana', 133: 'Micronesia (Federated States of)', 134: 'Guatemala', 135: 'Kiribati', 136: 'Honduras', 137: 'Sao Tome and Principe', 138: 'Namibia', 139: "Lao People's Democratic Republic", 140: 'Timor-Leste', 141: 'Vanuatu', 142: 'Nepal', 143: 'Eswatini (Kingdom of)', 144: 'Equatorial Guinea', 145: 'Cambodia', 146: 'Zimbabwe', 147: 'Angola', 148: 'Myanmar', 149: 'Syrian Arab Republic', 150: 'Cameroon', 151: 'Kenya', 152: 'Congo', 153: 'Zambia', 154: 'Solomon Islands', 155: 'Comoros', 156: 'Papua New Guinea', 157: 'Mauritania', 158: "Côte d'Ivoire", 159: 'Tanzania (United Republic of)', 160: 'Pakistan', 161: 'Togo', 162: 'Haiti', 163: 'Nigeria', 164: 'Rwanda', 165: 'Benin', 166: 'Uganda', 167: 'Lesotho', 168: 'Malawi', 169: 'Senegal', 170: 'Djibouti', 171: 'Sudan', 172: 'Madagascar', 173: 'Gambia', 174: 'Ethiopia', 175: 'Eritrea', 176: 'Guinea-Bissau', 177: 'Liberia', 178: 'Congo (Democratic Republic of the)', 179: 'Afghanistan', 180: 'Sierra Leone', 181: 'Guinea', 182: 'Yemen', 183: 'Burkina Faso', 184: 'Mozambique', 185: 'Mali', 186: 'Burundi', 187: 'Central African Republic', 188: 'Niger', 189: 'Chad', 190: 'South Sudan'}, 'Human Development Index (HDI) ': {0: 0.962, 1: 0.961, 2: 0.959, 3: 0.952, 4: 0.951, 5: 0.948, 6: 0.947, 7: 0.945, 8: 0.942, 9: 0.941, 10: 0.94, 11: 0.939, 12: 0.937, 13: 0.937, 14: 0.936, 15: 0.935, 16: 0.93, 17: 0.929, 18: 0.925, 19: 0.925, 20: 0.921, 21: 0.919, 22: 0.918, 23: 0.918, 24: 0.916, 25: 0.911, 26: 0.905, 27: 0.903, 28: 0.896, 29: 0.895, 30: 0.89, 31: 0.889, 32: 0.887, 33: 0.876, 34: 0.875, 35: 0.875, 36: 0.875, 37: 0.866, 38: 0.863, 39: 0.858, 40: 0.858, 41: 0.855, 42: 0.855, 43: 0.853, 44: 0.848, 45: 0.846, 46: 0.842, 47: 0.838, 48: 0.832, 49: 0.831, 50: 0.829, 51: 0.822, 52: 0.821, 53: 0.816, 54: 0.812, 55: 0.811, 56: 0.81, 57: 0.809, 58: 0.809, 59: 0.808, 60: 0.805, 61: 0.803, 62: 0.802, 63: 0.802, 64: 0.802, 65: 0.8, 66: 0.796, 67: 0.795, 68: 0.795, 69: 0.79, 70: 0.788, 71: 0.785, 72: 0.782, 73: 0.78, 74: 0.777, 75: 0.774, 76: 0.773, 77: 0.77, 78: 0.768, 79: 0.767, 80: 0.767, 81: 0.767, 82: 0.764, 83: 0.762, 84: 0.759, 85: 0.758, 86: 0.754, 87: 0.752, 88: 0.751, 89: 0.747, 90: 0.745, 91: 0.745, 92: 0.745, 93: 0.745, 94: 0.74, 95: 0.739, 96: 0.731, 97: 0.731, 98: 0.73, 99: 0.73, 100: 0.727, 101: 0.72, 102: 0.72, 103: 0.718, 104: 0.717, 105: 0.715, 106: 0.715, 107: 0.714, 108: 0.713, 109: 0.709, 110: 0.707, 111: 0.706, 112: 0.706, 113: 0.705, 114: 0.703, 115: 0.699, 116: 0.693, 117: 0.692, 118: 0.692, 119: 0.691, 120: 0.686, 121: 0.685, 122: 0.683, 123: 0.683, 124: 0.675, 125: 0.667, 126: 0.666, 127: 0.662, 128: 0.661, 129: 0.641, 130: 0.639, 131: 0.633, 132: 0.632, 133: 0.628, 134: 0.627, 135: 0.624, 136: 0.621, 137: 0.618, 138: 0.615, 139: 0.607, 140: 0.607, 141: 0.607, 142: 0.602, 143: 0.597, 144: 0.596, 145: 0.593, 146: 0.593, 147: 0.586, 148: 0.585, 149: 0.577, 150: 0.576, 151: 0.575, 152: 0.571, 153: 0.565, 154: 0.564, 155: 0.558, 156: 0.558, 157: 0.556, 158: 0.55, 159: 0.549, 160: 0.544, 161: 0.539, 162: 0.535, 163: 0.535, 164: 0.534, 165: 0.525, 166: 0.525, 167: 0.514, 168: 0.512, 169: 0.511, 170: 0.509, 171: 0.508, 172: 0.501, 173: 0.5, 174: 0.498, 175: 0.492, 176: 0.483, 177: 0.481, 178: 0.479, 179: 0.478, 180: 0.477, 181: 0.465, 182: 0.455, 183: 0.449, 184: 0.446, 185: 0.428, 186: 0.426, 187: 0.404, 188: 0.4, 189: 0.394, 190: 0.385}, 'Life expectancy at birth (years)': {0: 83.9872, 1: 83.2339, 2: 82.6782, 3: 85.4734, 4: 84.5265, 5: 81.3753, 6: 82.9833, 7: 81.9976, 8: 80.6301, 9: 81.6873, 10: 82.0381, 11: 82.7545, 12: 81.8787, 13: 82.4513, 14: 82.6565, 15: 83.2575, 16: 82.6287, 17: 80.7422, 18: 84.7839, 19: 83.6978, 20: 77.1982, 21: 82.255, 22: 83.7769, 23: 80.6904, 24: 81.5797, 25: 78.7104, 26: 83.01, 27: 82.4988, 28: 81.2033, 29: 82.8502, 30: 77.1436, 31: 77.7283, 32: 80.1106, 33: 76.4572, 34: 78.7605, 35: 73.7201, 36: 76.936, 37: 81.0443, 38: 73.5786, 39: 80.3684, 40: 77.5804, 41: 78.9435, 42: 79.2716, 43: 80.8786, 44: 74.9101, 45: 74.5301, 46: 75.3899, 47: 76.0324, 48: 76.3426, 49: 78.6729, 50: 74.6424, 51: 69.419, 52: 74.1847, 53: 72.5406, 54: 71.5983, 55: 69.3622, 56: 72.9709, 57: 77.0232, 58: 75.4356, 59: 72.438, 60: 76.2233, 61: 74.8839, 62: 71.694, 63: 73.5552, 64: 74.1923, 65: 78.7154, 66: 76.4626, 67: 71.798, 68: 74.9362, 69: 77.5714, 70: 78.4968, 71: 71.2945, 72: 76.3991, 73: 75.3003, 74: 71.6822, 75: 73.8749, 76: 71.624, 77: 73.8415, 78: 78.2107, 79: 72.6146, 80: 68.8459, 81: 66.0204, 82: 73.6829, 83: 72.3769, 84: 72.0431, 85: 70.2127, 86: 72.7504, 87: 72.8296, 88: 69.6291, 89: 79.9182, 90: 76.3767, 91: 69.3658, 92: 70.9857, 93: 69.2644, 94: 73.67, 95: 70.9754, 96: 70.2207, 97: 73.7719, 98: 67.114, 99: 70.2743, 100: 70.8616, 101: 72.814, 102: 74.2563, 103: 71.9112, 104: 70.2617, 105: 73.4727, 106: 71.1114, 107: 65.6734, 108: 62.341, 109: 70.5003, 110: 72.7675, 111: 65.821, 112: 75.0472, 113: 67.5703, 114: 73.6181, 115: 69.2664, 116: 61.1409, 117: 63.6304, 118: 69.9774, 119: 70.5536, 120: 70.3779, 121: 71.5942, 122: 70.4697, 123: 74.0419, 124: 70.7479, 125: 73.8368, 126: 71.815, 127: 74.0518, 128: 72.3811, 129: 64.5466, 130: 65.2688, 131: 67.2398, 132: 63.7954, 133: 70.71, 134: 69.2368, 135: 67.4172, 136: 70.1229, 137: 67.5912, 138: 59.269, 139: 68.0608, 140: 67.7369, 141: 70.449, 142: 68.4495, 143: 57.0657, 144: 60.5943, 145: 69.5835, 146: 59.2531, 147: 61.6434, 148: 65.6716, 149: 72.0627, 150: 60.3334, 151: 61.427, 152: 63.5187, 153: 61.2234, 154: 70.3477, 155: 63.4174, 156: 65.3506, 157: 64.3636, 158: 58.5983, 159: 66.2007, 160: 66.0979, 161: 61.6194, 162: 63.1924, 163: 52.676, 164: 66.0722, 165: 59.821, 166: 62.7048, 167: 53.062, 168: 62.9044, 169: 67.0926, 170: 62.3049, 171: 65.2667, 172: 64.4853, 173: 62.083, 174: 64.9748, 175: 66.5358, 176: 59.6523, 177: 60.7472, 178: 59.193, 179: 61.9824, 180: 60.0624, 181: 58.8922, 182: 63.7534, 183: 59.2696, 184: 59.3247, 185: 58.9414, 186: 61.6627, 187: 53.8947, 188: 61.5763, 189: 52.5254, 190: 54.9752}, 'Expected years of schooling (years)': {0: 16.50029945, 1: 18.18519974, 2: 19.16305923, 3: 17.27816963, 4: 21.05459023, 5: 18.71479988, 6: 19.41852951, 7: 18.94522095, 8: 17.01013947, 9: 18.69316522, 10: 19.05192947, 11: 16.5243206, 12: 19.60421944, 13: 20.28388977, 14: 16.39625931, 15: 15.18157005, 16: 14.39813995, 17: 17.30971909, 18: 15.22162588, 19: 16.52173996, 20: 16.28097916, 21: 16.05088997, 22: 16.83856964, 23: 17.65492058, 24: 16.00795937, 25: 15.71769047, 26: 17.91690063, 27: 15.81206989, 28: 15.64826965, 29: 16.22678947, 30: 15.92895985, 31: 16.21968079, 32: 20.02878952, 33: 16.0271492, 34: 16.29755974, 35: 16.28506088, 36: 16.13549042, 37: 16.87122917, 38: 16.20252991, 39: 13.30023874, 40: 15.11209965, 41: 16.73130035, 42: 12.63722038, 43: 12.26613998, 44: 14.51303959, 45: 15.0336281, 46: 17.8748703, 47: 18.3382206, 48: 15.08160973, 49: 15.32443332, 50: 13.95178032, 51: 15.76636982, 52: 14.22990036, 53: 14.57349014, 54: 12.89945, 55: 15.76500034, 56: 14.53545292, 57: 16.54577065, 58: 16.83259964, 59: 15.16996956, 60: 13.05787868, 61: 13.34304047, 62: 15.56851959, 63: 15.17352977, 64: 14.40009022, 65: 15.88221913, 66: 14.44799995, 67: 13.89729023, 68: 18.66202035, 69: 15.71338458, 70: 14.18462641, 71: 13.94161034, 72: 14.13990486, 73: 13.8, 74: 15.42769157, 75: 14.61524963, 76: 14.95656854, 77: 13.62443234, 78: 14.2361149, 79: 14.46655802, 80: 14.43299961, 81: 15.78432, 82: 14.44305992, 83: 15.38773354, 84: 13.11676025, 85: 14.86443996, 86: 15.59906006, 87: 14.44274998, 88: 14.67220567, 89: 12.63560963, 90: 14.62689602, 91: 13.49689007, 92: 16.04857063, 93: 13.21039963, 94: 14.62423038, 95: 14.98034954, 96: 13.78649972, 97: 15.42538224, 98: 14.73679, 99: 13.03564357, 100: 12.47714043, 101: 13.3191862, 102: 10.64655972, 103: 12.85428, 104: 12.98799113, 105: 13.35801029, 106: 12.86610985, 107: 12.50272216, 108: 13.64371014, 109: 13.40492042, 110: 12.41885948, 111: 12.97731, 112: 11.28587, 113: 13.74889386, 114: 12.9519325, 115: 13.12656975, 116: 12.26513765, 117: 14.94697094, 118: 13.1953001, 119: 12.81608, 120: 12.08747317, 121: 11.65303618, 122: 12.99168968, 123: 14.15190983, 124: 12.67134767, 125: 12.64135783, 126: 13.22500478, 127: 12.55461444, 128: 12.44198036, 129: 9.40443, 130: 10.2393198, 131: 11.87462044, 132: 12.04778004, 133: 11.54947988, 134: 10.56245041, 135: 11.801993, 136: 10.13281417, 137: 13.36538506, 138: 11.92720692, 139: 10.13611031, 140: 12.616098, 141: 11.53531503, 142: 12.88694954, 143: 13.74434586, 144: 9.73494, 145: 11.46772, 146: 12.11096904, 147: 12.1721, 148: 10.90913752, 149: 9.164219856, 150: 13.10859922, 151: 10.69855835, 152: 12.33081527, 153: 10.92876021, 154: 10.32869027, 155: 11.92432393, 156: 10.36077074, 157: 9.376159668, 158: 10.67558002, 159: 9.221489906, 160: 8.658349991, 161: 12.95049378, 162: 9.7, 163: 10.12758388, 164: 11.23097038, 165: 10.76667976, 166: 10.14986994, 167: 12.04087801, 168: 12.67898523, 169: 8.963749886, 170: 7.43298, 171: 7.945187858, 172: 10.13499142, 173: 9.418626299, 174: 9.651071421, 175: 8.064524628, 176: 10.61306278, 177: 10.42078972, 178: 9.817864451, 179: 10.26384398, 180: 9.57339109, 181: 9.805297465, 182: 9.09871006, 183: 9.142100334, 184: 10.2191516, 185: 7.423037617, 186: 10.72272189, 187: 8.040171714, 188: 6.957111988, 189: 8.035914334, 190: 5.54251}, 'Mean years of schooling (years)': {0: 13.85966015, 1: 13.00362968, 2: 13.76716995, 3: 12.22620964, 4: 12.72681999, 5: 12.96049023, 6: 12.60972023, 7: 11.58222303, 8: 14.09096691, 9: 12.58162975, 10: 12.87362003, 11: 11.92488003, 12: 12.37567997, 13: 12.94468975, 14: 13.83442722, 15: 12.53854, 16: 13.01519217, 17: 13.4061203, 18: 13.36610034, 19: 12.51293027, 20: 13.68342972, 21: 13.3448664, 22: 12.21026039, 23: 12.80368042, 24: 12.25669003, 25: 12.69402981, 26: 10.60540009, 27: 11.61005974, 28: 12.44017029, 29: 10.7401104, 30: 13.54843044, 31: 12.86931038, 32: 11.40853024, 33: 13.1647501, 34: 11.04658985, 35: 13.49810028, 36: 11.31052971, 37: 9.575940132, 38: 13.25271988, 39: 10.55511952, 40: 12.19108434, 41: 10.9349663, 42: 9.99601145, 43: 10.80146027, 44: 12.91141987, 45: 12.24958992, 46: 11.14726927, 47: 8.63313961, 48: 12.17648306, 49: 7.328022618, 50: 9.18, 51: 12.77428805, 52: 11.27511978, 53: 11.65404034, 54: 12.64192386, 55: 12.34756189, 56: 11.61062419, 57: 8.804059982, 58: 8.982549667, 59: 12.14358044, 60: 10.54059029, 61: 10.64505959, 62: 12.82221985, 63: 10.42791048, 64: 11.36987019, 65: 8.697119713, 66: 11.28645502, 67: 11.41318035, 68: 9.032104, 69: 9.852700596, 70: 9.293740746, 71: 10.28312, 72: 10.82730007, 73: 10.53631973, 74: 8.662745, 75: 10.63645314, 76: 11.13142043, 77: 10.22815037, 78: 7.600118446, 79: 9.306864107, 80: 11.82159042, 81: 12.49143, 82: 12.49773438, 83: 9.885518863, 84: 11.33030033, 85: 9.221050262, 86: 8.128813955, 87: 8.862859726, 88: 10.83343029, 89: 7.322, 90: 8.069284397, 91: 10.5429697, 92: 11.392594, 93: 11.26139, 94: 8.817119598, 95: 9.423700333, 96: 9.573026174, 97: 7.431598614, 98: 10.92154799, 99: 9.77680063, 100: 11.89558983, 101: 8.142186, 102: 10.44668007, 103: 7.599985, 104: 8.861840248, 105: 9.938480377, 106: 8.545040131, 107: 8.617477, 108: 11.37316036, 109: 9.154628661, 110: 11.4038, 111: 9.436, 112: 8.718636, 113: 8.556509972, 114: 8.370280266, 115: 8.969099998, 116: 10.34, 117: 9.827750206, 118: 11.37410556, 119: 11.10727736, 120: 7.905593489, 121: 11.3333938, 122: 8.847599983, 123: 5.916, 124: 7.150929928, 125: 7.144, 126: 5.170262283, 127: 6.287719287, 128: 7.379059792, 129: 10.57310772, 130: 10.88313961, 131: 6.655109195, 132: 8.329886695, 133: 7.804956, 134: 5.681300163, 135: 7.984461822, 136: 7.088479996, 137: 6.215599435, 138: 7.192013277, 139: 5.374, 140: 5.43679, 141: 7.064846, 142: 5.121792742, 143: 5.596, 144: 5.910863, 145: 5.088, 146: 8.710908501, 147: 5.417390823, 148: 6.37680006, 149: 5.1, 150: 6.15131, 151: 6.652, 152: 6.166, 153: 7.187091494, 154: 5.711848, 155: 5.078649, 156: 4.74, 157: 4.918804891, 158: 5.199138977, 159: 6.37289871, 160: 4.536330223, 161: 5.016807367, 162: 5.554, 163: 7.181074153, 164: 4.425292358, 165: 4.304786445, 166: 5.730941566, 167: 6.010184707, 168: 4.489695385, 169: 2.937938258, 170: 4.1, 171: 3.82, 172: 5.120468534, 173: 4.637487411, 174: 3.201520681, 175: 4.8872352, 176: 3.583719, 177: 5.082, 178: 7.018696516, 179: 2.98506999, 180: 4.576081285, 181: 2.202125952, 182: 3.2, 183: 2.114962259, 184: 3.197641838, 185: 2.31, 186: 3.129266883, 187: 4.334, 188: 2.116717299, 189: 2.57377421, 190: 5.726140022}, 'Gross national income (GNI) per capita ((2017 PPP $)': {0: 66933.00454, 1: 64660.10622, 2: 55782.04981, 3: 62606.8454, 4: 49238.43335, 5: 60364.78595, 6: 54489.37401, 7: 76168.98443, 8: 54534.21682, 9: 55979.411, 10: 49452.16672, 11: 90918.64471, 12: 52293.39977, 13: 44057.31394, 14: 46807.98619, 15: 146829.7006, 16: 84649.47467, 17: 45224.76564, 18: 42274.29134, 19: 44500.93187, 20: 64765.21509, 21: 41523.74319, 22: 38884.45623, 23: 39746.01987, 24: 53618.67138, 25: 62573.59181, 26: 38353.60164, 27: 45937.05273, 28: 38188.42152, 29: 42839.51441, 30: 38048.26372, 31: 38745.21386, 32: 29002.48545, 33: 33033.96081, 34: 39497.24788, 35: 37931.30359, 36: 46111.55135, 37: 33154.53343, 38: 32803.23423, 39: 51166.62661, 40: 30132.28814, 41: 24563.24486, 42: 87134.13469, 43: 52653.82534, 44: 30690.48552, 45: 32789.01063, 46: 20925.26814, 47: 31032.80106, 48: 20838.80129, 49: 52919.76137, 50: 64489.53954, 51: 27166.30891, 52: 30027.29131, 53: 27054.32505, 54: 30486.18429, 55: 23942.81837, 56: 23392.02084, 57: 19974.27358, 58: 21268.88122, 59: 18848.96704, 60: 26956.83707, 61: 26657.94355, 62: 14664.16825, 63: 22025.34631, 64: 19123.02747, 65: 17030.15352, 66: 14131.11039, 67: 23078.95595, 68: 13483.5774, 69: 12306.341, 70: 16792.36595, 71: 25830.61775, 72: 12578.22055, 73: 15241.91465, 74: 23358.33212, 75: 13000.7117, 76: 13255.50977, 77: 15917.75283, 78: 17504.39969, 79: 17989.60037, 80: 14875.33189, 81: 13818.67869, 82: 7878.847482, 83: 12245.89366, 84: 13157.9939, 85: 17896.29498, 86: 14369.88848, 87: 14384.35666, 88: 11961.08792, 89: 15448.12788, 90: 10800.22546, 91: 14256.74456, 92: 6822.03125, 93: 13020.7155, 94: 10311.63273, 95: 10588.22532, 96: 11731.69056, 97: 10257.54477, 98: 9980.110866, 99: 12672.20033, 100: 7916.785725, 101: 11487.62422, 102: 9923.714974, 103: 15335.712, 104: 12349.286, 105: 6582.899416, 106: 12048.30381, 107: 22464.65734, 108: 12948.37325, 109: 8834.47567, 110: 5307.953374, 111: 13366.93455, 112: 9525.831467, 113: 11466.06836, 114: 7867.371345, 115: 8920.428468, 116: 16198.31841, 117: 8111.190194, 118: 4566.303831, 119: 4810.882621, 120: 9977.249073, 121: 4547.742427, 122: 6309.099778, 123: 7302.81917, 124: 8295.665889, 125: 5624.793595, 126: 9437.541512, 127: 6230.200199, 128: 5472.104781, 129: 6351.435899, 130: 4619.535393, 131: 6589.980037, 132: 5744.504017, 133: 3696.173945, 134: 8723.285317, 135: 4062.586034, 136: 5297.955301, 137: 4021.350815, 138: 8633.504452, 139: 7699.579617, 140: 4460.869435, 141: 3085.411633, 142: 3877.315444, 143: 7678.591873, 144: 12073.95993, 145: 4078.697154, 146: 3809.887158, 147: 5465.617791, 148: 3850.524234, 149: 4191.933893, 150: 3620.932408, 151: 4473.570344, 152: 2889.283521, 153: 3217.767739, 154: 2481.511362, 155: 3142.064119, 156: 4008.623573, 157: 5075.305711, 158: 5217.448516, 159: 2664.329096, 160: 4623.70543, 161: 2166.619062, 162: 2847.500746, 163: 4790.284425, 164: 2209.795202, 165: 3408.965923, 166: 2181.43651, 167: 2700.435748, 168: 1465.635064, 169: 3344.311825, 170: 5024.993944, 171: 3575.19084, 172: 1483.520983, 173: 2172.207664, 174: 2361.069604, 175: 1728.742667, 176: 1908.24159, 177: 1288.74235, 178: 1076.098781, 179: 1824.190915, 180: 1621.512579, 181: 2480.887182, 182: 1314.270189, 183: 2117.915916, 184: 1198.073924, 185: 2132.629443, 186: 731.7867086, 187: 966.0586107, 188: 1239.866936, 189: 1364.169417, 190: 767.787}}
The data is for 2021 and gives us a great idea on how to compare the data of the countries with very high index numbers and those with satosfactory or poor HDI numbers
We will use the HDI index numbers and create four categories (Very High Human Development(>0.85), High Human Development(>.70), Satisfactory Human Development(>.55) and Low Human Development(<.55). We will do the same thing for all the the components of HDI index. Doing this gives us a clear picture of which country is lagging in the which specific component of the HDI Index and which country belongs to which particluar category of Human Development.