Why is there only 149 countries in the econ dataset?

[bajo1207]

It needs to have around 200 if we are gonna use it.

[ekaan]

That's the original dataset. We might then think of dropping this data because it didn't include all countries in the first place. There are 149 countries in total in that db

[VasLem]

That is very weird, which countries are missing?

[VasLem]

I need the 2 digits code from there too :sweat_smile:

[ekaan]

['AMERICAN SAMOA', 'ANGUILLA', 'ANTARCTICA', 'ANTIGUA AND BARBUDA', 'ARUBA', 'BAHAMAS', 'BARBADOS', 'BERMUDA', 'BOTSWANA', 'BOUVET ISLAND', 'BRITISH INDIAN OCEAN TERRITORY', 'CAPE VERDE', 'CAYMAN ISLANDS', 'CHRISTMAS ISLAND', 'COCOS (KEELING) ISLANDS', 'COMOROS', 'COOK ISLANDS', 'CUBA', 'DJIBOUTI', 'DOMINICA', 'DOMINICAN REPUBLIC', 'EQUATORIAL GUINEA', 'FALKLAND ISLANDS (MALVINAS)', 'FAROE ISLANDS', 'FIJI', 'FRENCH GUIANA', 'FRENCH POLYNESIA', 'FRENCH SOUTHERN TERRITORIES', 'GIBRALTAR', 'GRENADA', 'GUADELOUPE', 'GUAM', 'HAITI', 'HEARD ISLAND AND MCDONALD ISLANDS', 'HONG KONG', 'JAMAICA', 'KIRIBATI', 'LESOTHO', 'LIECHTENSTEIN', 'LUXEMBOURG', 'MACAO', 'MALDIVES', 'MARSHALL ISLANDS', 'MARTINIQUE', 'MAURITIUS', 'MAYOTTE', 'MICRONESIA, FEDERATED STATES OF', 'MOLDOVA, REPUBLIC OF', 'MONACO', 'MONTSERRAT', 'NAMIBIA', 'NAURU', 'NETHERLANDS ANTILLES', 'NEW CALEDONIA', 'NIUE', 'NORFOLK ISLAND', 'NORTHERN MARIANA ISLANDS', 'PALAU', 'PALESTINIAN TERRITORY, OCCUPIED', 'PAPUA NEW GUINEA', 'PITCAIRN', 'PUERTO RICO', 'RÉUNION', 'SAINT HELENA', 'SAINT KITTS AND NEVIS', 'SAINT LUCIA', 'SAINT PIERRE AND MIQUELON', 'SAINT VINCENT AND THE GRENADINES', 'SAMOA', 'SAN MARINO', 'SAO TOME AND PRINCIPE', 'SERBIA AND MONTENEGRO', 'SEYCHELLES', 'SOLOMON ISLANDS', 'SOUTH GEORGIA AND SOUTH SANDWICH ISLANDS', 'SRI LANKA', 'SVALBARD AND JAN MAYEN', 'SWAZILAND', 'TAIWAN, PROVINCE OF CHINA', 'TIMOR', 'TOKELAU', 'TONGA', 'TRINIDAD AND TOBAGO', 'TURKS AND CAICOS ISLANDS', 'TUVALU', 'UNITED STATES MINOR OUTLYING ISLANDS', 'VANUATU', 'VIRGIN ISLANDS, BRITISH', 'VIRGIN ISLANDS, U.S.', 'WALLIS AND FUTUNA', 'WESTERN SAHARA']

[ekaan]

But some of these countries are not official etc.

[ekaan]

['Antigua and Barbuda', 'The Bahamas', 'Barbados', 'Botswana', 'Comoros', 'Cabo Verde', 'Cuba', 'Djibouti', 'Dominica', 'Dominican Republic', 'Fiji', 'Micronesia', 'Equatorial Guinea', 'Grenada', 'Hong Kong SAR, China', 'Haiti', 'Jamaica', 'Kiribati', 'St. Kitts and Nevis', 'St. Lucia', 'Liechtenstein', 'Sri Lanka', 'Lesotho', 'Luxembourg', 'Monaco', 'Moldova', 'Maldives', 'Marshall Islands', 'Mauritius', 'Namibia', 'Nauru', 'Palau', 'Papua New Guinea', 'West Bank and Gaza', 'Solomon Islands', 'San Marino', 'South Sudan', 'São Tomé and Principe', 'Swaziland', 'Seychelles', 'Timor-Leste', 'Tonga', 'Trinidad and Tobago', 'Tuvalu', 'St. Vincent and the Grenadines', 'Vanuatu', 'Samoa']

[ekaan]

47 official countries are missing

[ekaan]

And these are the 2 digit codes:

['AG', 'BS', 'BB', 'BW', 'KM', 'CV', 'CU', 'DJ', 'DM', 'DO', 'FJ', 'FM', 'GQ', 'GD', 'HK', 'HT', 'JM', 'KI', 'KN', 'LC', 'LI', 'LK', 'LS', 'LU', 'MC', 'MD', 'MV', 'MH', 'MU', nan, 'NR', 'PW', 'PG', 'PS', 'SB', 'SM', 'SS', 'ST', 'SZ', 'SC', 'TL', 'TO', 'TT', 'TV', 'VC', 'VU', 'WS']

[VasLem]

Hm, maybe impute those using the other datasets? I dont know whether we got cities that belong to those countries.... we could incorporate them just for completeness

[bajo1207]

The econ dataset only contains two indicators. I don't see the need to spend more time trying to complete the data, when i'm sure that the wealth of a country is reflected in one of the other indicators that we have.

[VasLem]

Let's not use it.