AX For those who, like me, has got problem with quoted numbers, spaces and duplicates with Pandas:. Longitude and Latitude are now floating, it removes double quotes and strip strings, and it also removes duplicates by keeping the first one.
The new dataframe has length instead of Skip to content. Sign in Sign up. Instantly share code, notes, and snippets. Last active Dec 17, Code Revisions 4 Stars Forks Embed What would you like to do?
Embed Embed this gist in your website. Share Copy sharable link for this gist. Learn more about clone URLs. Download ZIP. This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters Show hidden characters. Copy link. This is brilliant! Should it be merged? Great, thanks! Can you add south sudan?? Trinidad and Tobago appears two times. This is very helpful, thank you very much! Great job mate, I was really looking for this list! In this way, you can be sure that your database is always using the most up-to-date information from ISO. ISO has three parts: codes for countries, codes for subdivisions and formerly used codes codes that were once used to describe countries but are no longer in use.
The country codes can be represented either as a two-letter code alpha-2 which is recommended as the general-purpose code, a three-letter code alpha-3 which is more closely related to the country name and a three-digit numeric code numeric-3 which can be useful if you need to avoid using Latin script.
The codes for subdivisions are represented as the alpha-2 code for the country, followed by up to three characters. Names and codes for subdivisions are usually taken from relevant official national information sources. The formerly used codes are four-letter codes alpha How the alpha-4 codes are constructed depends on the reason why the country name has been removed.
Read more about the different types of codes in the Glossary for ISO For more information, visit the ISO Store. ISO is regularly updated to reflect changes in country names and subdivisions.
The numeric country code is assigned by the UN. As a general rule, the ISO Maintenance Agency does not assign official country code elements to other geopolitical areas or countries that are not member states of the UN. To be considered, some criteria, amongst others, include that the area be physically separated from its parent country and outside its territorial waters. Even if all criteria are met, the ISO Maintenance Agency may decide not to assign a code element, for example, due to the very limited number of official alpha-2 code elements available.
0コメント