mpu.countries errors

[MartinThoma]

Potential errors: The en_name is what is currently in the dataset

                                          en_name                               CountryName
1                                   Åland Islands                             Aland Islands
27               Bonaire, Sint Eustatius and Saba                                       NaN
30                                  Bouvet Island                                       NaN
37                                     Cabo Verde                                Cape Verde
47                        Cocos (Keeling) Islands                             Cocos Islands
50                                          Congo                         Republic of Congo
53                                  Côte d'Ivoire                             Cote d'Ivoire
69                                       Eswatini                                 Swaziland
71                    Falkland Islands (Malvinas)                          Falkland Islands
76                                  French Guiana                                       NaN
78                    French Southern Territories       French Southern and Antarctic Lands
80                                         Gambia                                The Gambia
88                                     Guadeloupe                                       NaN
97                                       Holy See                              Vatican City
121              Lao People's Democratic Republic                                      Laos
130                                         Macao                                     Macau
139                                    Martinique                                       NaN
142                                       Mayotte                                       NaN
144                                    Micronesia            Federated States of Micronesia
153                                       Namibia                                Somaliland
155                                       Namibia                           Northern Cyprus
177                                      Pitcairn                          Pitcairn Islands
182                                       Réunion                                       NaN
186                              Saint Barthélemy                          Saint Barthelemy
187  Saint Helena, Ascension and Tristan da Cunha                              Saint Helena
190                    Saint Martin (French part)                              Saint Martin
202                     Sint Maarten (Dutch part)                              Sint Maarten
208  South Georgia and the South Sandwich Islands  South Georgia and South Sandwich Islands
214                        Svalbard and Jan Mayen                                  Svalbard
237          United States Minor Outlying Islands                 US Minor Outlying Islands
243                      Virgin Islands (British)                    British Virgin Islands
244                         Virgin Islands (U.S.)                         US Virgin Islands
250                                           NaN          Democratic Republic of the Congo
251                                           NaN                                    Kosovo

[MartinThoma]

For capitals: capital is what is there, CapitalName is from another source

>>> df_new[df_new['capital'] != df_new['CapitalName']][['capital', 'CapitalName']]
                       capital        CapitalName
8                          NaN                NaN
9                   St. John's       Saint John's
26                       Sucre             La Paz
27                  Kralendijk                NaN
30                         NaN                NaN
31                    Brasília           Brasilia
32                         NaN       Diego Garcia
39                     Yaoundé            Yaounde
46            Flying Fish Cove     The Settlement
48                      Bogotá             Bogota
52                    San José           San Jose
69                         NaN            Mbabane
72                    Tórshavn           Torshavn
76                     Cayenne                NaN
78                         NaN  Port-aux-Français
87                St. George's     Saint George's
88                 Basse-Terre                NaN
89                     Hagåtña            Hagatna
91              St. Peter Port   Saint Peter Port
96                         NaN                NaN
99                         NaN                NaN
101                  Reykjavík          Reykjavik
112                 St. Helier       Saint Helier
121                        NaN          Vientiane
130                        NaN                NaN
135                       Malé               Male
139                        NaN                NaN
142                        NaN                NaN
152                  Naypyidaw            Rangoon
153                   Windhoek           Hargeisa
155                   Windhoek      North Nicosia
159                     Nouméa             Noumea
170                  Ngerulmud           Melekeok
174                   Asunción           Asuncion
182                Saint-Denis                NaN
191                 St. Pierre       Saint-Pierre
195                   São Tomé           Sao Tome
208                  Grytviken  King Edward Point
211  Sri Jayawardenapura Kotte            Colombo
220                     Dodoma      Dar es Salaam
223                       Lomé               Lome
224                        NaN              Atafu
225                 Nukuʻalofa         Nuku'alofa
230              Cockburn Town         Grand Turk
233                       Kiev               Kyiv
237                        NaN   Washington, D.C.
240                  Port Vila          Port-Vila
246                   El Aaiún           El-Aaiún
247                      Sanaá              Sanaa
250                        NaN           Kinshasa
251                        NaN           Pristina

[MartinThoma]

    alpha-2 CountryCode
27       BQ         NaN
30       BV         NaN
76       GF         NaN
88       GP         NaN
139      MQ         NaN
142      YT         NaN
153     NaN         NaN
154     NaN         NaN
155     NaN         NaN
182      RE         NaN
250     NaN          CD
251     NaN          KO