=== countries === (242, 169) EPSG:4326 Polygon 123 MultiPolygon 119 Name: count, dtype: int64 === countries.head() === name iso3 continent pop_est gdp_musd geometry 0 Zimbabwe ZWE Africa 14645468.0 21440 POLYGON ((31.28789 -22.40205, 31.19727 -22.344... 1 Zambia ZMB Africa 17861030.0 23309 POLYGON ((30.39609 -15.64307, 30.25068 -15.643... 2 Yemen YEM Asia 29161922.0 22581 MULTIPOLYGON (((53.08564 16.64839, 52.58145 16... 3 Vietnam VNM Asia 96462106.0 261921 MULTIPOLYGON (((104.06396 10.39082, 104.08301 ... 4 Venezuela VEN South America 28515829.0 482359 MULTIPOLYGON (((-60.82119 9.13838, -60.94141 9... === largest countries by area === name area_km2 pop_est density Russia 16913027.1 144373535.0 8.5 Antarctica 12126825.6 4490.0 0.0 Canada 9894148.9 37589262.0 3.8 United States of America 9460566.8 328239523.0 34.7 China 9392194.5 1397715000.0 148.8 === joined.head() === city city_pop name continent 0 Bombo 75000 Uganda Africa 1 Fort Portal 42670 Uganda Africa 13 Jinja 301619 Uganda Africa 14 Arua 250000 Uganda Africa 15 Mbale 402368 Uganda Africa === unmatched places === 94 of 1251 places fall outside every country polygon === recovered with sjoin_nearest === 92 recovered within 25 km city city_pop name dist_m 1226 New York 19040000 United States of America 1478.0 1228 Istanbul 10061000 Turkey 869.0 1233 Lagos 9466000 Nigeria 1576.0 1250 Hong Kong 7206000 Hong Kong 1327.0 1171 Salvador 3484000 Brazil 927.0 === countries with the most 1M+ cities === cities_1m city_pop name China 67 198833000 India 42 140258000 United States of America 40 132086838 Brazil 18 71900406 Russia 11 25533000 Japan 8 61636000 Nigeria 7 20462000 Indonesia 7 20886000 === continents === pop_est gdp_musd area_km2 density continent Asia 4,565,778,126.0 33555734 31,231,657.3 146.2 Africa 1,307,986,092.3 2459078 30,053,513.8 43.5 Europe 746,437,653.0 21642328 22,900,334.1 32.6 North America 585,351,846.0 25115795 24,230,324.1 24.2 South America 427,066,661.0 3852015 17,702,395.3 24.1 Oceania 42,430,881.0 1663441 8,539,629.5 5.0 Antarctica 4,490.0 898 12,126,825.6 0.0 === saved === natural_earth_analysis.gpkg 3.12 MB