mirror of
https://github.com/apache/superset.git
synced 2026-07-28 09:32:28 +00:00
Compare commits
2 Commits
dependabot
...
adopt/3356
| Author | SHA1 | Date | |
|---|---|---|---|
|
2e4722e0f8 | ||
|
|
11aacbbe52 |
@@ -86,6 +86,7 @@
|
||||
"Israel",
|
||||
"Italy",
|
||||
"Italy (regions)",
|
||||
"Italy (regions and autonomous provinces)",
|
||||
"Ivory Coast",
|
||||
"Japan",
|
||||
"Jordan",
|
||||
|
||||
@@ -79,7 +79,7 @@
|
||||
"source": [
|
||||
"## Download Data\n",
|
||||
"\n",
|
||||
"Download datasets (_Admin 0 - Countries_ in [1:10](https://www.naturalearthdata.com/downloads/10m-cultural-vectors/), and _Admin 1 – States, Provinces_ in 1:10 and [1:50](https://www.naturalearthdata.com/downloads/50m-cultural-vectors/)) from Natural Earch Data:"
|
||||
"Download datasets (_Admin 0 - Countries_ in [1:10](https://www.naturalearthdata.com/downloads/10m-cultural-vectors/), and _Admin 1 \u2013 States, Provinces_ in 1:10 and [1:50](https://www.naturalearthdata.com/downloads/50m-cultural-vectors/)) from Natural Earth Data:"
|
||||
]
|
||||
},
|
||||
{
|
||||
@@ -513,7 +513,7 @@
|
||||
" </tr>\n",
|
||||
" </tbody>\n",
|
||||
"</table>\n",
|
||||
"<p>9 rows × 121 columns</p>\n",
|
||||
"<p>9 rows \u00d7 121 columns</p>\n",
|
||||
"</div>"
|
||||
],
|
||||
"text/plain": [
|
||||
@@ -843,33 +843,33 @@
|
||||
" <td>11.0</td>\n",
|
||||
" <td>11.0</td>\n",
|
||||
" <td>Q34617</td>\n",
|
||||
" <td>سان بيير وميكلون</td>\n",
|
||||
" <td>সাঁ পিয়ের ও মিকলোঁ</td>\n",
|
||||
" <td>\u0633\u0627\u0646 \u0628\u064a\u064a\u0631 \u0648\u0645\u064a\u0643\u0644\u0648\u0646</td>\n",
|
||||
" <td>\u09b8\u09be\u0981 \u09aa\u09bf\u09af\u09bc\u09c7\u09b0 \u0993 \u09ae\u09bf\u0995\u09b2\u09cb\u0981</td>\n",
|
||||
" <td>Saint-Pierre und Miquelon</td>\n",
|
||||
" <td>Saint Pierre and Miquelon</td>\n",
|
||||
" <td>San Pedro y Miquelón</td>\n",
|
||||
" <td>San Pedro y Miquel\u00f3n</td>\n",
|
||||
" <td>Saint-Pierre-et-Miquelon</td>\n",
|
||||
" <td>Σαιν-Πιερ και Μικελόν</td>\n",
|
||||
" <td>सन्त पियर और मिकलान</td>\n",
|
||||
" <td>Saint-Pierre és Miquelon</td>\n",
|
||||
" <td>\u03a3\u03b1\u03b9\u03bd-\u03a0\u03b9\u03b5\u03c1 \u03ba\u03b1\u03b9 \u039c\u03b9\u03ba\u03b5\u03bb\u03cc\u03bd</td>\n",
|
||||
" <td>\u0938\u0928\u094d\u0924 \u092a\u093f\u092f\u0930 \u0914\u0930 \u092e\u093f\u0915\u0932\u093e\u0928</td>\n",
|
||||
" <td>Saint-Pierre \u00e9s Miquelon</td>\n",
|
||||
" <td>Saint Pierre dan Miquelon</td>\n",
|
||||
" <td>Saint-Pierre e Miquelon</td>\n",
|
||||
" <td>サンピエール島・ミクロン島</td>\n",
|
||||
" <td>생피에르 미클롱</td>\n",
|
||||
" <td>\u30b5\u30f3\u30d4\u30a8\u30fc\u30eb\u5cf6\u30fb\u30df\u30af\u30ed\u30f3\u5cf6</td>\n",
|
||||
" <td>\uc0dd\ud53c\uc5d0\ub974 \ubbf8\ud074\ub871</td>\n",
|
||||
" <td>Saint-Pierre en Miquelon</td>\n",
|
||||
" <td>Saint-Pierre i Miquelon</td>\n",
|
||||
" <td>Saint-Pierre e Miquelon</td>\n",
|
||||
" <td>Сен-Пьер и Микелон</td>\n",
|
||||
" <td>\u0421\u0435\u043d-\u041f\u044c\u0435\u0440 \u0438 \u041c\u0438\u043a\u0435\u043b\u043e\u043d</td>\n",
|
||||
" <td>Saint-Pierre och Miquelon</td>\n",
|
||||
" <td>Saint Pierre ve Miquelon</td>\n",
|
||||
" <td>Saint-Pierre và Miquelon</td>\n",
|
||||
" <td>圣皮埃尔和密克隆</td>\n",
|
||||
" <td>Saint-Pierre v\u00e0 Miquelon</td>\n",
|
||||
" <td>\u5723\u76ae\u57c3\u5c14\u548c\u5bc6\u514b\u9686</td>\n",
|
||||
" <td>1159315673</td>\n",
|
||||
" <td>סן-פייר ומיקלון</td>\n",
|
||||
" <td>Сен-П'єр і Мікелон</td>\n",
|
||||
" <td>سینٹ پیئر و میکیلون</td>\n",
|
||||
" <td>سن پیر و میکلن</td>\n",
|
||||
" <td>聖皮埃與密克隆群島</td>\n",
|
||||
" <td>\u05e1\u05df-\u05e4\u05d9\u05d9\u05e8 \u05d5\u05de\u05d9\u05e7\u05dc\u05d5\u05df</td>\n",
|
||||
" <td>\u0421\u0435\u043d-\u041f'\u0454\u0440 \u0456 \u041c\u0456\u043a\u0435\u043b\u043e\u043d</td>\n",
|
||||
" <td>\u0633\u06cc\u0646\u0679 \u067e\u06cc\u0626\u0631 \u0648 \u0645\u06cc\u06a9\u06cc\u0644\u0648\u0646</td>\n",
|
||||
" <td>\u0633\u0646 \u067e\u06cc\u0631 \u0648 \u0645\u06cc\u06a9\u0644\u0646</td>\n",
|
||||
" <td>\u8056\u76ae\u57c3\u8207\u5bc6\u514b\u9686\u7fa4\u5cf6</td>\n",
|
||||
" <td>NaN</td>\n",
|
||||
" <td>NaN</td>\n",
|
||||
" <td>None</td>\n",
|
||||
@@ -968,33 +968,33 @@
|
||||
" <td>11.0</td>\n",
|
||||
" <td>11.0</td>\n",
|
||||
" <td>NaN</td>\n",
|
||||
" <td>ميكلون ولانغليد</td>\n",
|
||||
" <td>মিকুইলন-ল্যাংলেড</td>\n",
|
||||
" <td>\u0645\u064a\u0643\u0644\u0648\u0646 \u0648\u0644\u0627\u0646\u063a\u0644\u064a\u062f</td>\n",
|
||||
" <td>\u09ae\u09bf\u0995\u09c1\u0987\u09b2\u09a8-\u09b2\u09cd\u09af\u09be\u0982\u09b2\u09c7\u09a1</td>\n",
|
||||
" <td>Miquelon-Langlade</td>\n",
|
||||
" <td>Miquelon-Langlade</td>\n",
|
||||
" <td>Miquelón-Langlade</td>\n",
|
||||
" <td>Miquel\u00f3n-Langlade</td>\n",
|
||||
" <td>Miquelon-Langlade</td>\n",
|
||||
" <td>Μικελόν-Λαγκλέιντ</td>\n",
|
||||
" <td>मिकेलॉन-लैंगलेड</td>\n",
|
||||
" <td>\u039c\u03b9\u03ba\u03b5\u03bb\u03cc\u03bd-\u039b\u03b1\u03b3\u03ba\u03bb\u03ad\u03b9\u03bd\u03c4</td>\n",
|
||||
" <td>\u092e\u093f\u0915\u0947\u0932\u0949\u0928-\u0932\u0948\u0902\u0917\u0932\u0947\u0921</td>\n",
|
||||
" <td>Miquelon-Langlade</td>\n",
|
||||
" <td>Miquelon-Langlade</td>\n",
|
||||
" <td>Miquelon-Langlade</td>\n",
|
||||
" <td>ミクロン＝ラングラード</td>\n",
|
||||
" <td>미클롱-랭글레이드</td>\n",
|
||||
" <td>\u30df\u30af\u30ed\u30f3\uff1d\u30e9\u30f3\u30b0\u30e9\u30fc\u30c9</td>\n",
|
||||
" <td>\ubbf8\ud074\ub871-\ub7ad\uae00\ub808\uc774\ub4dc</td>\n",
|
||||
" <td>Miquelon-Langlade</td>\n",
|
||||
" <td>Miquelon-Langlade</td>\n",
|
||||
" <td>Miquelão-Langlade</td>\n",
|
||||
" <td>Микелон-Ланглад</td>\n",
|
||||
" <td>Miquel\u00e3o-Langlade</td>\n",
|
||||
" <td>\u041c\u0438\u043a\u0435\u043b\u043e\u043d-\u041b\u0430\u043d\u0433\u043b\u0430\u0434</td>\n",
|
||||
" <td>Miquelon-Langlade</td>\n",
|
||||
" <td>Miquelon-Langlade</td>\n",
|
||||
" <td>Miquelon-Langlade</td>\n",
|
||||
" <td>密克隆-朗格拉德</td>\n",
|
||||
" <td>\u5bc6\u514b\u9686-\u6717\u683c\u62c9\u5fb7</td>\n",
|
||||
" <td>1159315961</td>\n",
|
||||
" <td>מירה</td>\n",
|
||||
" <td>Міквелон-Лангладе</td>\n",
|
||||
" <td>میکیولون لینگلاڈے</td>\n",
|
||||
" <td>میکوئلون-لانگلید</td>\n",
|
||||
" <td>密克隆-朗格拉德</td>\n",
|
||||
" <td>\u05de\u05d9\u05e8\u05d4</td>\n",
|
||||
" <td>\u041c\u0456\u043a\u0432\u0435\u043b\u043e\u043d-\u041b\u0430\u043d\u0433\u043b\u0430\u0434\u0435</td>\n",
|
||||
" <td>\u0645\u06cc\u06a9\u06cc\u0648\u0644\u0648\u0646 \u0644\u06cc\u0646\u06af\u0644\u0627\u0688\u06d2</td>\n",
|
||||
" <td>\u0645\u06cc\u06a9\u0648\u0626\u0644\u0648\u0646-\u0644\u0627\u0646\u06af\u0644\u06cc\u062f</td>\n",
|
||||
" <td>\u5bc6\u514b\u9686-\u6717\u683c\u62c9\u5fb7</td>\n",
|
||||
" <td>NaN</td>\n",
|
||||
" <td>NaN</td>\n",
|
||||
" <td>None</td>\n",
|
||||
@@ -1084,48 +1084,48 @@
|
||||
"2177 PM.97501 NaN NaN 1.0 fra SB00 NaN \n",
|
||||
"\n",
|
||||
" min_label max_label min_zoom wikidataid name_ar \\\n",
|
||||
"2176 11.0 11.0 11.0 Q34617 سان بيير وميكلون \n",
|
||||
"2177 11.0 11.0 11.0 NaN ميكلون ولانغليد \n",
|
||||
"2176 11.0 11.0 11.0 Q34617 \u0633\u0627\u0646 \u0628\u064a\u064a\u0631 \u0648\u0645\u064a\u0643\u0644\u0648\u0646 \n",
|
||||
"2177 11.0 11.0 11.0 NaN \u0645\u064a\u0643\u0644\u0648\u0646 \u0648\u0644\u0627\u0646\u063a\u0644\u064a\u062f \n",
|
||||
"\n",
|
||||
" name_bn name_de \\\n",
|
||||
"2176 সাঁ পিয়ের ও মিকলোঁ Saint-Pierre und Miquelon \n",
|
||||
"2177 মিকুইলন-ল্যাংলেড Miquelon-Langlade \n",
|
||||
"2176 \u09b8\u09be\u0981 \u09aa\u09bf\u09af\u09bc\u09c7\u09b0 \u0993 \u09ae\u09bf\u0995\u09b2\u09cb\u0981 Saint-Pierre und Miquelon \n",
|
||||
"2177 \u09ae\u09bf\u0995\u09c1\u0987\u09b2\u09a8-\u09b2\u09cd\u09af\u09be\u0982\u09b2\u09c7\u09a1 Miquelon-Langlade \n",
|
||||
"\n",
|
||||
" name_en name_es \\\n",
|
||||
"2176 Saint Pierre and Miquelon San Pedro y Miquelón \n",
|
||||
"2177 Miquelon-Langlade Miquelón-Langlade \n",
|
||||
"2176 Saint Pierre and Miquelon San Pedro y Miquel\u00f3n \n",
|
||||
"2177 Miquelon-Langlade Miquel\u00f3n-Langlade \n",
|
||||
"\n",
|
||||
" name_fr name_el name_hi \\\n",
|
||||
"2176 Saint-Pierre-et-Miquelon Σαιν-Πιερ και Μικελόν सन्त पियर और मिकलान \n",
|
||||
"2177 Miquelon-Langlade Μικελόν-Λαγκλέιντ मिकेलॉन-लैंगलेड \n",
|
||||
"2176 Saint-Pierre-et-Miquelon \u03a3\u03b1\u03b9\u03bd-\u03a0\u03b9\u03b5\u03c1 \u03ba\u03b1\u03b9 \u039c\u03b9\u03ba\u03b5\u03bb\u03cc\u03bd \u0938\u0928\u094d\u0924 \u092a\u093f\u092f\u0930 \u0914\u0930 \u092e\u093f\u0915\u0932\u093e\u0928 \n",
|
||||
"2177 Miquelon-Langlade \u039c\u03b9\u03ba\u03b5\u03bb\u03cc\u03bd-\u039b\u03b1\u03b3\u03ba\u03bb\u03ad\u03b9\u03bd\u03c4 \u092e\u093f\u0915\u0947\u0932\u0949\u0928-\u0932\u0948\u0902\u0917\u0932\u0947\u0921 \n",
|
||||
"\n",
|
||||
" name_hu name_id \\\n",
|
||||
"2176 Saint-Pierre és Miquelon Saint Pierre dan Miquelon \n",
|
||||
"2176 Saint-Pierre \u00e9s Miquelon Saint Pierre dan Miquelon \n",
|
||||
"2177 Miquelon-Langlade Miquelon-Langlade \n",
|
||||
"\n",
|
||||
" name_it name_ja name_ko \\\n",
|
||||
"2176 Saint-Pierre e Miquelon サンピエール島・ミクロン島 생피에르 미클롱 \n",
|
||||
"2177 Miquelon-Langlade ミクロン＝ラングラード 미클롱-랭글레이드 \n",
|
||||
"2176 Saint-Pierre e Miquelon \u30b5\u30f3\u30d4\u30a8\u30fc\u30eb\u5cf6\u30fb\u30df\u30af\u30ed\u30f3\u5cf6 \uc0dd\ud53c\uc5d0\ub974 \ubbf8\ud074\ub871 \n",
|
||||
"2177 Miquelon-Langlade \u30df\u30af\u30ed\u30f3\uff1d\u30e9\u30f3\u30b0\u30e9\u30fc\u30c9 \ubbf8\ud074\ub871-\ub7ad\uae00\ub808\uc774\ub4dc \n",
|
||||
"\n",
|
||||
" name_nl name_pl \\\n",
|
||||
"2176 Saint-Pierre en Miquelon Saint-Pierre i Miquelon \n",
|
||||
"2177 Miquelon-Langlade Miquelon-Langlade \n",
|
||||
"\n",
|
||||
" name_pt name_ru name_sv \\\n",
|
||||
"2176 Saint-Pierre e Miquelon Сен-Пьер и Микелон Saint-Pierre och Miquelon \n",
|
||||
"2177 Miquelão-Langlade Микелон-Ланглад Miquelon-Langlade \n",
|
||||
"2176 Saint-Pierre e Miquelon \u0421\u0435\u043d-\u041f\u044c\u0435\u0440 \u0438 \u041c\u0438\u043a\u0435\u043b\u043e\u043d Saint-Pierre och Miquelon \n",
|
||||
"2177 Miquel\u00e3o-Langlade \u041c\u0438\u043a\u0435\u043b\u043e\u043d-\u041b\u0430\u043d\u0433\u043b\u0430\u0434 Miquelon-Langlade \n",
|
||||
"\n",
|
||||
" name_tr name_vi name_zh \\\n",
|
||||
"2176 Saint Pierre ve Miquelon Saint-Pierre và Miquelon 圣皮埃尔和密克隆 \n",
|
||||
"2177 Miquelon-Langlade Miquelon-Langlade 密克隆-朗格拉德 \n",
|
||||
"2176 Saint Pierre ve Miquelon Saint-Pierre v\u00e0 Miquelon \u5723\u76ae\u57c3\u5c14\u548c\u5bc6\u514b\u9686 \n",
|
||||
"2177 Miquelon-Langlade Miquelon-Langlade \u5bc6\u514b\u9686-\u6717\u683c\u62c9\u5fb7 \n",
|
||||
"\n",
|
||||
" ne_id name_he name_uk name_ur \\\n",
|
||||
"2176 1159315673 סן-פייר ומיקלון Сен-П'єр і Мікелон سینٹ پیئر و میکیلون \n",
|
||||
"2177 1159315961 מירה Міквелон-Лангладе میکیولون لینگلاڈے \n",
|
||||
"2176 1159315673 \u05e1\u05df-\u05e4\u05d9\u05d9\u05e8 \u05d5\u05de\u05d9\u05e7\u05dc\u05d5\u05df \u0421\u0435\u043d-\u041f'\u0454\u0440 \u0456 \u041c\u0456\u043a\u0435\u043b\u043e\u043d \u0633\u06cc\u0646\u0679 \u067e\u06cc\u0626\u0631 \u0648 \u0645\u06cc\u06a9\u06cc\u0644\u0648\u0646 \n",
|
||||
"2177 1159315961 \u05de\u05d9\u05e8\u05d4 \u041c\u0456\u043a\u0432\u0435\u043b\u043e\u043d-\u041b\u0430\u043d\u0433\u043b\u0430\u0434\u0435 \u0645\u06cc\u06a9\u06cc\u0648\u0644\u0648\u0646 \u0644\u06cc\u0646\u06af\u0644\u0627\u0688\u06d2 \n",
|
||||
"\n",
|
||||
" name_fa name_zht FCLASS_ISO FCLASS_US FCLASS_FR FCLASS_RU \\\n",
|
||||
"2176 سن پیر و میکلن 聖皮埃與密克隆群島 NaN NaN None NaN \n",
|
||||
"2177 میکوئلون-لانگلید 密克隆-朗格拉德 NaN NaN None NaN \n",
|
||||
"2176 \u0633\u0646 \u067e\u06cc\u0631 \u0648 \u0645\u06cc\u06a9\u0644\u0646 \u8056\u76ae\u57c3\u8207\u5bc6\u514b\u9686\u7fa4\u5cf6 NaN NaN None NaN \n",
|
||||
"2177 \u0645\u06cc\u06a9\u0648\u0626\u0644\u0648\u0646-\u0644\u0627\u0646\u06af\u0644\u06cc\u062f \u5bc6\u514b\u9686-\u6717\u683c\u62c9\u5fb7 NaN NaN None NaN \n",
|
||||
"\n",
|
||||
" FCLASS_ES FCLASS_CN FCLASS_TW FCLASS_IN FCLASS_NP FCLASS_PK FCLASS_DE \\\n",
|
||||
"2176 NaN NaN NaN NaN NaN NaN NaN \n",
|
||||
@@ -1241,7 +1241,7 @@
|
||||
" 'costa rica',\n",
|
||||
" 'croatia',\n",
|
||||
" 'cuba',\n",
|
||||
" 'curaçao',\n",
|
||||
" 'cura\u00e7ao',\n",
|
||||
" 'cyprus',\n",
|
||||
" 'czech republic',\n",
|
||||
" 'denmark',\n",
|
||||
@@ -1254,7 +1254,7 @@
|
||||
" 'equatorial guinea',\n",
|
||||
" 'eritrea',\n",
|
||||
" 'estonia',\n",
|
||||
" # 'eswatini', # not sure why this doesn't work — Swaziland isn't available to alias, either.\n",
|
||||
" # 'eswatini', # not sure why this doesn't work \u2014 Swaziland isn't available to alias, either.\n",
|
||||
" 'ethiopia',\n",
|
||||
" 'falkland islands',\n",
|
||||
" 'faroe islands',\n",
|
||||
@@ -1354,7 +1354,7 @@
|
||||
" 'portugal',\n",
|
||||
" 'puerto rico',\n",
|
||||
" 'qatar',\n",
|
||||
" # 'réunion', # part of France, in Natural Earth data\n",
|
||||
" # 'r\u00e9union', # part of France, in Natural Earth data\n",
|
||||
" 'republic of serbia',\n",
|
||||
" 'romania',\n",
|
||||
" 'russia',\n",
|
||||
@@ -1437,6 +1437,7 @@
|
||||
" 'france_regions',\n",
|
||||
" 'france_overseas',\n",
|
||||
" 'italy_regions',\n",
|
||||
" 'italy_regions_and_autonomous_provinces',\n",
|
||||
" 'philippines_regions',\n",
|
||||
" 'turkey_regions'\n",
|
||||
"]\n",
|
||||
@@ -1792,34 +1793,34 @@
|
||||
" <td>9.0</td>\n",
|
||||
" <td>1159320473</td>\n",
|
||||
" <td>Q8646</td>\n",
|
||||
" <td>هونغ كونغ</td>\n",
|
||||
" <td>হংকং</td>\n",
|
||||
" <td>\u0647\u0648\u0646\u063a \u0643\u0648\u0646\u063a</td>\n",
|
||||
" <td>\u09b9\u0982\u0995\u0982</td>\n",
|
||||
" <td>Hongkong</td>\n",
|
||||
" <td>Hong Kong</td>\n",
|
||||
" <td>Hong Kong</td>\n",
|
||||
" <td>هنگ کنگ</td>\n",
|
||||
" <td>\u0647\u0646\u06af \u06a9\u0646\u06af</td>\n",
|
||||
" <td>Hong Kong</td>\n",
|
||||
" <td>Χονγκ Κονγκ</td>\n",
|
||||
" <td>הונג קונג</td>\n",
|
||||
" <td>हांगकांग</td>\n",
|
||||
" <td>\u03a7\u03bf\u03bd\u03b3\u03ba \u039a\u03bf\u03bd\u03b3\u03ba</td>\n",
|
||||
" <td>\u05d4\u05d5\u05e0\u05d2 \u05e7\u05d5\u05e0\u05d2</td>\n",
|
||||
" <td>\u0939\u093e\u0902\u0917\u0915\u093e\u0902\u0917</td>\n",
|
||||
" <td>Hongkong</td>\n",
|
||||
" <td>Hong Kong</td>\n",
|
||||
" <td>Hong Kong</td>\n",
|
||||
" <td>香港</td>\n",
|
||||
" <td>홍콩</td>\n",
|
||||
" <td>\u9999\u6e2f</td>\n",
|
||||
" <td>\ud64d\ucf69</td>\n",
|
||||
" <td>Hongkong</td>\n",
|
||||
" <td>Hongkong</td>\n",
|
||||
" <td>Hong Kong</td>\n",
|
||||
" <td>Гонконг</td>\n",
|
||||
" <td>\u0413\u043e\u043d\u043a\u043e\u043d\u0433</td>\n",
|
||||
" <td>Hongkong</td>\n",
|
||||
" <td>Hong Kong</td>\n",
|
||||
" <td>Гонконг</td>\n",
|
||||
" <td>ہانگ کانگ</td>\n",
|
||||
" <td>Hồng Kông</td>\n",
|
||||
" <td>香港</td>\n",
|
||||
" <td>香港</td>\n",
|
||||
" <td>\u0413\u043e\u043d\u043a\u043e\u043d\u0433</td>\n",
|
||||
" <td>\u06c1\u0627\u0646\u06af \u06a9\u0627\u0646\u06af</td>\n",
|
||||
" <td>H\u1ed3ng K\u00f4ng</td>\n",
|
||||
" <td>\u9999\u6e2f</td>\n",
|
||||
" <td>\u9999\u6e2f</td>\n",
|
||||
" <td>MULTIPOLYGON (((114.22983 22.55581, 114.23471 ...</td>\n",
|
||||
" <td>香港特别行政区</td>\n",
|
||||
" <td>\u9999\u6e2f\u7279\u522b\u884c\u653f\u533a</td>\n",
|
||||
" <td>CN-91</td>\n",
|
||||
" </tr>\n",
|
||||
" <tr>\n",
|
||||
@@ -1846,34 +1847,34 @@
|
||||
" <td>8.0</td>\n",
|
||||
" <td>1159321335</td>\n",
|
||||
" <td>Q865</td>\n",
|
||||
" <td>تايوان</td>\n",
|
||||
" <td>তাইওয়ান</td>\n",
|
||||
" <td>\u062a\u0627\u064a\u0648\u0627\u0646</td>\n",
|
||||
" <td>\u09a4\u09be\u0987\u0993\u09af\u09bc\u09be\u09a8</td>\n",
|
||||
" <td>Republik China</td>\n",
|
||||
" <td>Taiwan</td>\n",
|
||||
" <td>República de China</td>\n",
|
||||
" <td>تایوان</td>\n",
|
||||
" <td>Taïwan</td>\n",
|
||||
" <td>Δημοκρατία της Κίνας</td>\n",
|
||||
" <td>טאיוואן</td>\n",
|
||||
" <td>चीनी गणराज्य</td>\n",
|
||||
" <td>Kínai Köztársaság</td>\n",
|
||||
" <td>Rep\u00fablica de China</td>\n",
|
||||
" <td>\u062a\u0627\u06cc\u0648\u0627\u0646</td>\n",
|
||||
" <td>Ta\u00efwan</td>\n",
|
||||
" <td>\u0394\u03b7\u03bc\u03bf\u03ba\u03c1\u03b1\u03c4\u03af\u03b1 \u03c4\u03b7\u03c2 \u039a\u03af\u03bd\u03b1\u03c2</td>\n",
|
||||
" <td>\u05d8\u05d0\u05d9\u05d5\u05d5\u05d0\u05df</td>\n",
|
||||
" <td>\u091a\u0940\u0928\u0940 \u0917\u0923\u0930\u093e\u091c\u094d\u092f</td>\n",
|
||||
" <td>K\u00ednai K\u00f6zt\u00e1rsas\u00e1g</td>\n",
|
||||
" <td>Taiwan</td>\n",
|
||||
" <td>Taiwan</td>\n",
|
||||
" <td>中華民国</td>\n",
|
||||
" <td>중화민국</td>\n",
|
||||
" <td>\u4e2d\u83ef\u6c11\u56fd</td>\n",
|
||||
" <td>\uc911\ud654\ubbfc\uad6d</td>\n",
|
||||
" <td>Taiwan</td>\n",
|
||||
" <td>Republika Chińska</td>\n",
|
||||
" <td>Republika Chi\u0144ska</td>\n",
|
||||
" <td>Taiwan</td>\n",
|
||||
" <td>Тайвань</td>\n",
|
||||
" <td>\u0422\u0430\u0439\u0432\u0430\u043d\u044c</td>\n",
|
||||
" <td>Taiwan</td>\n",
|
||||
" <td>Çin Cumhuriyeti</td>\n",
|
||||
" <td>Республіка Китай</td>\n",
|
||||
" <td>تائیوان</td>\n",
|
||||
" <td>Đài Loan</td>\n",
|
||||
" <td>中华民国</td>\n",
|
||||
" <td>中華民國</td>\n",
|
||||
" <td>\u00c7in Cumhuriyeti</td>\n",
|
||||
" <td>\u0420\u0435\u0441\u043f\u0443\u0431\u043b\u0456\u043a\u0430 \u041a\u0438\u0442\u0430\u0439</td>\n",
|
||||
" <td>\u062a\u0627\u0626\u06cc\u0648\u0627\u0646</td>\n",
|
||||
" <td>\u0110\u00e0i Loan</td>\n",
|
||||
" <td>\u4e2d\u534e\u6c11\u56fd</td>\n",
|
||||
" <td>\u4e2d\u83ef\u6c11\u570b</td>\n",
|
||||
" <td>MULTIPOLYGON (((121.90577 24.9501, 121.83473 2...</td>\n",
|
||||
" <td>中国台湾</td>\n",
|
||||
" <td>\u4e2d\u56fd\u53f0\u6e7e</td>\n",
|
||||
" <td>CN-71</td>\n",
|
||||
" </tr>\n",
|
||||
" <tr>\n",
|
||||
@@ -1900,34 +1901,34 @@
|
||||
" <td>9.0</td>\n",
|
||||
" <td>1159320475</td>\n",
|
||||
" <td>Q14773</td>\n",
|
||||
" <td>ماكاو</td>\n",
|
||||
" <td>মাকাও</td>\n",
|
||||
" <td>\u0645\u0627\u0643\u0627\u0648</td>\n",
|
||||
" <td>\u09ae\u09be\u0995\u09be\u0993</td>\n",
|
||||
" <td>Macau</td>\n",
|
||||
" <td>Macau</td>\n",
|
||||
" <td>Macao</td>\n",
|
||||
" <td>ماکائو</td>\n",
|
||||
" <td>\u0645\u0627\u06a9\u0627\u0626\u0648</td>\n",
|
||||
" <td>Macao</td>\n",
|
||||
" <td>Μακάου</td>\n",
|
||||
" <td>מקאו</td>\n",
|
||||
" <td>मकाउ</td>\n",
|
||||
" <td>Makaó</td>\n",
|
||||
" <td>\u039c\u03b1\u03ba\u03ac\u03bf\u03c5</td>\n",
|
||||
" <td>\u05de\u05e7\u05d0\u05d5</td>\n",
|
||||
" <td>\u092e\u0915\u093e\u0909</td>\n",
|
||||
" <td>Maka\u00f3</td>\n",
|
||||
" <td>Makau</td>\n",
|
||||
" <td>Macao</td>\n",
|
||||
" <td>マカオ</td>\n",
|
||||
" <td>마카오</td>\n",
|
||||
" <td>\u30de\u30ab\u30aa</td>\n",
|
||||
" <td>\ub9c8\uce74\uc624</td>\n",
|
||||
" <td>Macau</td>\n",
|
||||
" <td>Makau</td>\n",
|
||||
" <td>Macau</td>\n",
|
||||
" <td>Макао</td>\n",
|
||||
" <td>\u041c\u0430\u043a\u0430\u043e</td>\n",
|
||||
" <td>Macao</td>\n",
|
||||
" <td>Makao</td>\n",
|
||||
" <td>Аоминь</td>\n",
|
||||
" <td>مکاؤ</td>\n",
|
||||
" <td>\u0410\u043e\u043c\u0438\u043d\u044c</td>\n",
|
||||
" <td>\u0645\u06a9\u0627\u0624</td>\n",
|
||||
" <td>Ma Cao</td>\n",
|
||||
" <td>澳门</td>\n",
|
||||
" <td>澳門</td>\n",
|
||||
" <td>\u6fb3\u95e8</td>\n",
|
||||
" <td>\u6fb3\u9580</td>\n",
|
||||
" <td>MULTIPOLYGON (((113.5586 22.16303, 113.56943 2...</td>\n",
|
||||
" <td>澳门特别行政区</td>\n",
|
||||
" <td>\u6fb3\u95e8\u7279\u522b\u884c\u653f\u533a</td>\n",
|
||||
" <td>CN-92</td>\n",
|
||||
" </tr>\n",
|
||||
" </tbody>\n",
|
||||
@@ -1951,34 +1952,34 @@
|
||||
"2 4 3 MO 20070017 5 0.0 4.0 \n",
|
||||
"\n",
|
||||
" max_label ne_id wikidataid name_ar name_bn name_de \\\n",
|
||||
"0 9.0 1159320473 Q8646 هونغ كونغ হংকং Hongkong \n",
|
||||
"1 8.0 1159321335 Q865 تايوان তাইওয়ান Republik China \n",
|
||||
"2 9.0 1159320475 Q14773 ماكاو মাকাও Macau \n",
|
||||
"0 9.0 1159320473 Q8646 \u0647\u0648\u0646\u063a \u0643\u0648\u0646\u063a \u09b9\u0982\u0995\u0982 Hongkong \n",
|
||||
"1 8.0 1159321335 Q865 \u062a\u0627\u064a\u0648\u0627\u0646 \u09a4\u09be\u0987\u0993\u09af\u09bc\u09be\u09a8 Republik China \n",
|
||||
"2 9.0 1159320475 Q14773 \u0645\u0627\u0643\u0627\u0648 \u09ae\u09be\u0995\u09be\u0993 Macau \n",
|
||||
"\n",
|
||||
" name_en name_es name_fa name_fr name_el \\\n",
|
||||
"0 Hong Kong Hong Kong هنگ کنگ Hong Kong Χονγκ Κονγκ \n",
|
||||
"1 Taiwan República de China تایوان Taïwan Δημοκρατία της Κίνας \n",
|
||||
"2 Macau Macao ماکائو Macao Μακάου \n",
|
||||
"0 Hong Kong Hong Kong \u0647\u0646\u06af \u06a9\u0646\u06af Hong Kong \u03a7\u03bf\u03bd\u03b3\u03ba \u039a\u03bf\u03bd\u03b3\u03ba \n",
|
||||
"1 Taiwan Rep\u00fablica de China \u062a\u0627\u06cc\u0648\u0627\u0646 Ta\u00efwan \u0394\u03b7\u03bc\u03bf\u03ba\u03c1\u03b1\u03c4\u03af\u03b1 \u03c4\u03b7\u03c2 \u039a\u03af\u03bd\u03b1\u03c2 \n",
|
||||
"2 Macau Macao \u0645\u0627\u06a9\u0627\u0626\u0648 Macao \u039c\u03b1\u03ba\u03ac\u03bf\u03c5 \n",
|
||||
"\n",
|
||||
" name_he name_hi name_hu name_id name_it name_ja \\\n",
|
||||
"0 הונג קונג हांगकांग Hongkong Hong Kong Hong Kong 香港 \n",
|
||||
"1 טאיוואן चीनी गणराज्य Kínai Köztársaság Taiwan Taiwan 中華民国 \n",
|
||||
"2 מקאו मकाउ Makaó Makau Macao マカオ \n",
|
||||
"0 \u05d4\u05d5\u05e0\u05d2 \u05e7\u05d5\u05e0\u05d2 \u0939\u093e\u0902\u0917\u0915\u093e\u0902\u0917 Hongkong Hong Kong Hong Kong \u9999\u6e2f \n",
|
||||
"1 \u05d8\u05d0\u05d9\u05d5\u05d5\u05d0\u05df \u091a\u0940\u0928\u0940 \u0917\u0923\u0930\u093e\u091c\u094d\u092f K\u00ednai K\u00f6zt\u00e1rsas\u00e1g Taiwan Taiwan \u4e2d\u83ef\u6c11\u56fd \n",
|
||||
"2 \u05de\u05e7\u05d0\u05d5 \u092e\u0915\u093e\u0909 Maka\u00f3 Makau Macao \u30de\u30ab\u30aa \n",
|
||||
"\n",
|
||||
" name_ko name_nl name_pl name_pt name_ru name_sv \\\n",
|
||||
"0 홍콩 Hongkong Hongkong Hong Kong Гонконг Hongkong \n",
|
||||
"1 중화민국 Taiwan Republika Chińska Taiwan Тайвань Taiwan \n",
|
||||
"2 마카오 Macau Makau Macau Макао Macao \n",
|
||||
"0 \ud64d\ucf69 Hongkong Hongkong Hong Kong \u0413\u043e\u043d\u043a\u043e\u043d\u0433 Hongkong \n",
|
||||
"1 \uc911\ud654\ubbfc\uad6d Taiwan Republika Chi\u0144ska Taiwan \u0422\u0430\u0439\u0432\u0430\u043d\u044c Taiwan \n",
|
||||
"2 \ub9c8\uce74\uc624 Macau Makau Macau \u041c\u0430\u043a\u0430\u043e Macao \n",
|
||||
"\n",
|
||||
" name_tr name_uk name_ur name_vi name_zh_x name_zht \\\n",
|
||||
"0 Hong Kong Гонконг ہانگ کانگ Hồng Kông 香港 香港 \n",
|
||||
"1 Çin Cumhuriyeti Республіка Китай تائیوان Đài Loan 中华民国 中華民國 \n",
|
||||
"2 Makao Аоминь مکاؤ Ma Cao 澳门 澳門 \n",
|
||||
"0 Hong Kong \u0413\u043e\u043d\u043a\u043e\u043d\u0433 \u06c1\u0627\u0646\u06af \u06a9\u0627\u0646\u06af H\u1ed3ng K\u00f4ng \u9999\u6e2f \u9999\u6e2f \n",
|
||||
"1 \u00c7in Cumhuriyeti \u0420\u0435\u0441\u043f\u0443\u0431\u043b\u0456\u043a\u0430 \u041a\u0438\u0442\u0430\u0439 \u062a\u0627\u0626\u06cc\u0648\u0627\u0646 \u0110\u00e0i Loan \u4e2d\u534e\u6c11\u56fd \u4e2d\u83ef\u6c11\u570b \n",
|
||||
"2 Makao \u0410\u043e\u043c\u0438\u043d\u044c \u0645\u06a9\u0627\u0624 Ma Cao \u6fb3\u95e8 \u6fb3\u9580 \n",
|
||||
"\n",
|
||||
" geometry name_zh_y iso_3166_2 \n",
|
||||
"0 MULTIPOLYGON (((114.22983 22.55581, 114.23471 ... 香港特别行政区 CN-91 \n",
|
||||
"1 MULTIPOLYGON (((121.90577 24.9501, 121.83473 2... 中国台湾 CN-71 \n",
|
||||
"2 MULTIPOLYGON (((113.5586 22.16303, 113.56943 2... 澳门特别行政区 CN-92 "
|
||||
"0 MULTIPOLYGON (((114.22983 22.55581, 114.23471 ... \u9999\u6e2f\u7279\u522b\u884c\u653f\u533a CN-91 \n",
|
||||
"1 MULTIPOLYGON (((121.90577 24.9501, 121.83473 2... \u4e2d\u56fd\u53f0\u6e7e CN-71 \n",
|
||||
"2 MULTIPOLYGON (((113.5586 22.16303, 113.56943 2... \u6fb3\u95e8\u7279\u522b\u884c\u653f\u533a CN-92 "
|
||||
]
|
||||
},
|
||||
"execution_count": 14,
|
||||
@@ -1995,7 +1996,7 @@
|
||||
"china_sars = china_sars.merge(pd.DataFrame(\n",
|
||||
" data={\n",
|
||||
" \"name_en\": [\"Taiwan\", \"Hong Kong\", \"Macau\"],\n",
|
||||
" \"name_zh\": [\"中国台湾\", \"香港特别行政区\", \"澳门特别行政区\"],\n",
|
||||
" \"name_zh\": [\"\u4e2d\u56fd\u53f0\u6e7e\", \"\u9999\u6e2f\u7279\u522b\u884c\u653f\u533a\", \"\u6fb3\u95e8\u7279\u522b\u884c\u653f\u533a\"],\n",
|
||||
" \"iso_3166_2\": [\"CN-71\", \"CN-91\", \"CN-92\"],\n",
|
||||
" },\n",
|
||||
"), on=\"name_en\", how=\"left\")\n",
|
||||
@@ -2120,7 +2121,7 @@
|
||||
" }\n",
|
||||
")[[\"geometry\", \"iso_3166_2\", \"name\"]].copy()\n",
|
||||
"\n",
|
||||
"# Convert MA01 → MA-01\n",
|
||||
"# Convert MA01 \u2192 MA-01\n",
|
||||
"morocco_copy[\"iso_3166_2\"] = morocco_copy[\n",
|
||||
" \"iso_3166_2\"\n",
|
||||
"].str.replace(\n",
|
||||
@@ -2158,7 +2159,7 @@
|
||||
"source": [
|
||||
"#### Finland\n",
|
||||
"\n",
|
||||
"- The Åland Islands (ISO country code AX) is an autonomous region of Finland, and carries the ISO-3166 code FI-01."
|
||||
"- The \u00c5land Islands (ISO country code AX) is an autonomous region of Finland, and carries the ISO-3166 code FI-01."
|
||||
]
|
||||
},
|
||||
{
|
||||
@@ -2174,12 +2175,12 @@
|
||||
"outputs": [],
|
||||
"source": [
|
||||
"finland_aland = df_admin0_10m.loc[\n",
|
||||
" df_admin0_10m.name_en.isin(['Åland']),\n",
|
||||
" df_admin0_10m.name_en.isin(['\u00c5land']),\n",
|
||||
" [x for x in df_admin0_10m.columns if x in df.columns]\n",
|
||||
"]\n",
|
||||
"finland_aland = finland_aland.merge(pd.DataFrame(\n",
|
||||
" data={\n",
|
||||
" \"name_en\": [\"Åland\"],\n",
|
||||
" \"name_en\": [\"\u00c5land\"],\n",
|
||||
" \"name_fi\": [\"Ahvenanmaan maakunta\"],\n",
|
||||
" \"iso_3166_2\": [\"FI-01\"],\n",
|
||||
" },\n",
|
||||
@@ -2846,34 +2847,34 @@
|
||||
"\n",
|
||||
"# Turkey city name corrections\n",
|
||||
"# Fix completely wrong spellings\n",
|
||||
"replace_column('name', turkey, 'Kinkkale', 'Kırıkkale')\n",
|
||||
"replace_column('name', turkey, 'Kinkkale', 'K\u0131r\u0131kkale')\n",
|
||||
"replace_column('name', turkey, 'Zinguldak', 'Zonguldak')\n",
|
||||
"replace_column('name', turkey, 'K. Maras', 'Kahramanmaraş')\n",
|
||||
"replace_column('name', turkey, 'K. Maras', 'Kahramanmara\u015f')\n",
|
||||
"\n",
|
||||
"# Fix missing Turkish characters\n",
|
||||
"replace_column('name', turkey, 'Adiyaman', 'Adıyaman')\n",
|
||||
"replace_column('name', turkey, 'Agri', 'Ağrı')\n",
|
||||
"replace_column('name', turkey, 'Aydin', 'Aydın')\n",
|
||||
"replace_column('name', turkey, 'Balikesir', 'Balıkesir')\n",
|
||||
"replace_column('name', turkey, 'Çankiri', 'Çankırı')\n",
|
||||
"replace_column('name', turkey, 'Diyarbakir', 'Diyarbakır')\n",
|
||||
"replace_column('name', turkey, 'Elazig', 'Elâzığ')\n",
|
||||
"replace_column('name', turkey, 'Eskisehir', 'Eskişehir')\n",
|
||||
"replace_column('name', turkey, 'Gümüshane', 'Gümüşhane')\n",
|
||||
"replace_column('name', turkey, 'Hakkari', 'Hakkâri')\n",
|
||||
"replace_column('name', turkey, 'Istanbul', 'İstanbul')\n",
|
||||
"replace_column('name', turkey, 'Izmir', 'İzmir')\n",
|
||||
"replace_column('name', turkey, 'Iğdir', 'Iğdır')\n",
|
||||
"replace_column('name', turkey, 'Kirklareli', 'Kırklareli')\n",
|
||||
"replace_column('name', turkey, 'Kirsehir', 'Kırşehir')\n",
|
||||
"replace_column('name', turkey, 'Mugla', 'Muğla')\n",
|
||||
"replace_column('name', turkey, 'Mus', 'Muş')\n",
|
||||
"replace_column('name', turkey, 'Nevsehir', 'Nevşehir')\n",
|
||||
"replace_column('name', turkey, 'Nigde', 'Niğde')\n",
|
||||
"replace_column('name', turkey, 'Sanliurfa', 'Şanlıurfa')\n",
|
||||
"replace_column('name', turkey, 'Sirnak', 'Şırnak')\n",
|
||||
"replace_column('name', turkey, 'Tekirdag', 'Tekirdağ')\n",
|
||||
"replace_column('name', turkey, 'Usak', 'Uşak')\n",
|
||||
"replace_column('name', turkey, 'Adiyaman', 'Ad\u0131yaman')\n",
|
||||
"replace_column('name', turkey, 'Agri', 'A\u011fr\u0131')\n",
|
||||
"replace_column('name', turkey, 'Aydin', 'Ayd\u0131n')\n",
|
||||
"replace_column('name', turkey, 'Balikesir', 'Bal\u0131kesir')\n",
|
||||
"replace_column('name', turkey, '\u00c7ankiri', '\u00c7ank\u0131r\u0131')\n",
|
||||
"replace_column('name', turkey, 'Diyarbakir', 'Diyarbak\u0131r')\n",
|
||||
"replace_column('name', turkey, 'Elazig', 'El\u00e2z\u0131\u011f')\n",
|
||||
"replace_column('name', turkey, 'Eskisehir', 'Eski\u015fehir')\n",
|
||||
"replace_column('name', turkey, 'G\u00fcm\u00fcshane', 'G\u00fcm\u00fc\u015fhane')\n",
|
||||
"replace_column('name', turkey, 'Hakkari', 'Hakk\u00e2ri')\n",
|
||||
"replace_column('name', turkey, 'Istanbul', '\u0130stanbul')\n",
|
||||
"replace_column('name', turkey, 'Izmir', '\u0130zmir')\n",
|
||||
"replace_column('name', turkey, 'I\u011fdir', 'I\u011fd\u0131r')\n",
|
||||
"replace_column('name', turkey, 'Kirklareli', 'K\u0131rklareli')\n",
|
||||
"replace_column('name', turkey, 'Kirsehir', 'K\u0131r\u015fehir')\n",
|
||||
"replace_column('name', turkey, 'Mugla', 'Mu\u011fla')\n",
|
||||
"replace_column('name', turkey, 'Mus', 'Mu\u015f')\n",
|
||||
"replace_column('name', turkey, 'Nevsehir', 'Nev\u015fehir')\n",
|
||||
"replace_column('name', turkey, 'Nigde', 'Ni\u011fde')\n",
|
||||
"replace_column('name', turkey, 'Sanliurfa', '\u015eanl\u0131urfa')\n",
|
||||
"replace_column('name', turkey, 'Sirnak', '\u015e\u0131rnak')\n",
|
||||
"replace_column('name', turkey, 'Tekirdag', 'Tekirda\u011f')\n",
|
||||
"replace_column('name', turkey, 'Usak', 'U\u015fak')\n",
|
||||
"turkey_copy = turkey.copy()"
|
||||
]
|
||||
},
|
||||
@@ -2906,18 +2907,18 @@
|
||||
"\n",
|
||||
"# Region names corresponding to NUTS-1\n",
|
||||
"\n",
|
||||
"region_name_dict = {'TR1':'İstanbul',\n",
|
||||
" 'TR2':'Batı Marmara',\n",
|
||||
"region_name_dict = {'TR1':'\u0130stanbul',\n",
|
||||
" 'TR2':'Bat\u0131 Marmara',\n",
|
||||
" 'TR3':'Ege',\n",
|
||||
" 'TR4':'Doğu Marmara',\n",
|
||||
" 'TR5':'Batı Anadolu',\n",
|
||||
" 'TR4':'Do\u011fu Marmara',\n",
|
||||
" 'TR5':'Bat\u0131 Anadolu',\n",
|
||||
" 'TR6':'Akdeniz',\n",
|
||||
" 'TR7':'Orta Anadolu',\n",
|
||||
" 'TR8':'Batı Karadeniz',\n",
|
||||
" 'TR9':'Doğu Karadeniz',\n",
|
||||
" 'TRA':'Kuzeydoğu Anadolu',\n",
|
||||
" 'TRC':'Güneydoğu Anadolu',\n",
|
||||
" 'TRB':'Ortadoğu Anadolu'\n",
|
||||
" 'TR8':'Bat\u0131 Karadeniz',\n",
|
||||
" 'TR9':'Do\u011fu Karadeniz',\n",
|
||||
" 'TRA':'Kuzeydo\u011fu Anadolu',\n",
|
||||
" 'TRC':'G\u00fcneydo\u011fu Anadolu',\n",
|
||||
" 'TRB':'Ortado\u011fu Anadolu'\n",
|
||||
" }\n",
|
||||
"\n",
|
||||
"\n",
|
||||
@@ -3130,8 +3131,8 @@
|
||||
"france_copy = france.copy()\n",
|
||||
"reposition(france_copy, france.name=='Guadeloupe', 57.4, 25.4, 1.5, 1.5)\n",
|
||||
"reposition(france_copy, france.name=='Martinique', 58.4, 27.1, 1.5, 1.5)\n",
|
||||
"reposition(france_copy, france.name=='Guyane française', 52, 37.7, 0.35, 0.35)\n",
|
||||
"reposition(france_copy, france.name=='La Réunion', -55, 62.8, 1.5, 1.5)\n",
|
||||
"reposition(france_copy, france.name=='Guyane fran\u00e7aise', 52, 37.7, 0.35, 0.35)\n",
|
||||
"reposition(france_copy, france.name=='La R\u00e9union', -55, 62.8, 1.5, 1.5)\n",
|
||||
"reposition(france_copy, france.name=='Mayotte', -43, 54.3, 1.5, 1.5)\n",
|
||||
"\n",
|
||||
"not speed_run and france_copy.plot(figsize=(8, 8), **plot_styles)"
|
||||
@@ -3258,8 +3259,8 @@
|
||||
"france_overseas = france.copy()\n",
|
||||
"reposition(france_overseas, france.name=='Guadeloupe', 53.2, 29, 1.5, 1.5)\n",
|
||||
"reposition(france_overseas, france.name=='Martinique', 52.8, 27.5, 1.5, 1.5)\n",
|
||||
"reposition(france_overseas, france.name=='Guyane française', 45, 35.5, 0.3, 0.3)\n",
|
||||
"reposition(france_overseas, france.name=='La Réunion', -58.2, 60.5, 1.5, 1.5)\n",
|
||||
"reposition(france_overseas, france.name=='Guyane fran\u00e7aise', 45, 35.5, 0.3, 0.3)\n",
|
||||
"reposition(france_overseas, france.name=='La R\u00e9union', -58.2, 60.5, 1.5, 1.5)\n",
|
||||
"reposition(france_overseas, france.name=='Mayotte', -50.5, 52.2, 2, 2)\n",
|
||||
"\n",
|
||||
"# Tahiti\n",
|
||||
@@ -3302,7 +3303,7 @@
|
||||
"france_overseas = pd.concat([france_overseas, saint_martin_data], ignore_index=True)\n",
|
||||
"reposition(france_overseas, france_overseas.admin=='Saint Martin', 54.8, 30.3, 5, 5)\n",
|
||||
"\n",
|
||||
"# Saint Barthélémy\n",
|
||||
"# Saint Barth\u00e9l\u00e9my\n",
|
||||
"saint_barthelemy_data = df[(df['admin'] == 'Saint Barthelemy')]\n",
|
||||
"france_overseas = pd.concat([france_overseas, saint_barthelemy_data], ignore_index=True)\n",
|
||||
"reposition(france_overseas, france_overseas.admin=='Saint Barthelemy', 54.5, 30, 8, 8)\n",
|
||||
@@ -3318,13 +3319,13 @@
|
||||
"france_overseas = pd.concat([france_overseas, paris_and_littlecrowndpts_copy], ignore_index=True)\n",
|
||||
"\n",
|
||||
"# Update metadata properly\n",
|
||||
"france_overseas.loc[france_overseas['name'] == 'Windward Islands', ['name', 'iso_3166_2']] = ['Polynésie française', 'FR-PF']\n",
|
||||
"france_overseas.loc[france_overseas['name'] == 'Archipel des Kerguelen', ['name', 'iso_3166_2']] = ['Terres australes et antarctiques françaises', 'FR-TF']\n",
|
||||
"france_overseas.loc[france_overseas['name'] == 'Windward Islands', ['name', 'iso_3166_2']] = ['Polyn\u00e9sie fran\u00e7aise', 'FR-PF']\n",
|
||||
"france_overseas.loc[france_overseas['name'] == 'Archipel des Kerguelen', ['name', 'iso_3166_2']] = ['Terres australes et antarctiques fran\u00e7aises', 'FR-TF']\n",
|
||||
"france_overseas.loc[france_overseas['admin'] == 'Wallis and Futuna', ['name', 'iso_3166_2']] = ['Wallis et Futuna', 'FR-WF']\n",
|
||||
"france_overseas.loc[france_overseas['admin'] == 'New Caledonia', ['name', 'iso_3166_2']] = ['Nouvelle-Calédonie', 'FR-NC']\n",
|
||||
"france_overseas.loc[france_overseas['admin'] == 'New Caledonia', ['name', 'iso_3166_2']] = ['Nouvelle-Cal\u00e9donie', 'FR-NC']\n",
|
||||
"france_overseas.loc[france_overseas['admin'] == 'Saint Pierre and Miquelon', ['name', 'iso_3166_2']] = ['Saint-Pierre-et-Miquelon', 'FR-PM']\n",
|
||||
"france_overseas.loc[france_overseas['admin'] == 'Saint Martin', ['name', 'iso_3166_2']] = ['Saint-Martin', 'FR-MF']\n",
|
||||
"france_overseas.loc[france_overseas['admin'] == 'Saint Barthelemy', ['name', 'iso_3166_2']] = ['Saint-Barthélémy', 'FR-BL']\n",
|
||||
"france_overseas.loc[france_overseas['admin'] == 'Saint Barthelemy', ['name', 'iso_3166_2']] = ['Saint-Barth\u00e9l\u00e9my', 'FR-BL']\n",
|
||||
"\n",
|
||||
"# Plot data\n",
|
||||
"france_overseas = france_overseas.rename(columns={'NAME_1': 'name','ISO': 'iso_3166_2'})\n",
|
||||
@@ -3398,6 +3399,35 @@
|
||||
"not speed_run and italy_regions.plot(figsize=(10, 7), **plot_styles)"
|
||||
]
|
||||
},
|
||||
{
|
||||
"cell_type": "markdown",
|
||||
"metadata": {},
|
||||
"source": [
|
||||
"#### Italy Regions and Autonomous Provinces"
|
||||
]
|
||||
},
|
||||
{
|
||||
"cell_type": "code",
|
||||
"execution_count": null,
|
||||
"metadata": {},
|
||||
"outputs": [],
|
||||
"source": [
|
||||
"trento_and_bozen = df[(df.admin == 'Italy') & (df.iso_3166_2.isin(['IT-TN', 'IT-BZ']))][['geometry','iso_3166_2','name']]\n",
|
||||
"\n",
|
||||
"italy_regions_and_autonomous_provinces = pd.concat([italy_regions, trento_and_bozen])\n",
|
||||
"\n",
|
||||
"italy_regions_and_autonomous_provinces = italy_regions_and_autonomous_provinces[italy_regions_and_autonomous_provinces['iso_3166_2'] != 'IT-32']"
|
||||
]
|
||||
},
|
||||
{
|
||||
"cell_type": "code",
|
||||
"execution_count": null,
|
||||
"metadata": {},
|
||||
"outputs": [],
|
||||
"source": [
|
||||
"not speed_run and italy_regions_and_autonomous_provinces.plot(figsize=(10, 7), **plot_styles)"
|
||||
]
|
||||
},
|
||||
{
|
||||
"cell_type": "markdown",
|
||||
"metadata": {
|
||||
@@ -3830,86 +3860,86 @@
|
||||
"output_type": "stream",
|
||||
"text": [
|
||||
"Kon Tum\n",
|
||||
"Đắk Nông\n",
|
||||
"Đắk Lắk\n",
|
||||
"\u0110\u1eafk N\u00f4ng\n",
|
||||
"\u0110\u1eafk L\u1eafk\n",
|
||||
"Gia Lai\n",
|
||||
"Bình Phước\n",
|
||||
"Tây Ninh\n",
|
||||
"B\u00ecnh Ph\u01b0\u1edbc\n",
|
||||
"T\u00e2y Ninh\n",
|
||||
"Long An\n",
|
||||
"Đồng Tháp\n",
|
||||
"\u0110\u1ed3ng Th\u00e1p\n",
|
||||
"An Giang\n",
|
||||
"Kiên Giang\n",
|
||||
"Điện Biên\n",
|
||||
"Sơn La\n",
|
||||
"Thanh Hóa\n",
|
||||
"Nghệ An\n",
|
||||
"Hà Tĩnh\n",
|
||||
"Quảng Bình\n",
|
||||
"Quảng Trị\n",
|
||||
"Thừa Thiên - Huế\n",
|
||||
"Quảng Nam\n",
|
||||
"Hà Giang\n",
|
||||
"Cao Bằng\n",
|
||||
"Lào Cai\n",
|
||||
"Lai Châu\n",
|
||||
"Lạng Sơn\n",
|
||||
"Quảng Ninh\n",
|
||||
"Sóc Trăng\n",
|
||||
"Tiền Giang\n",
|
||||
"Bà Rịa - Vũng Tàu\n",
|
||||
"Thành phố Hồ Chí Minh\n",
|
||||
"Khánh Hòa\n",
|
||||
"Cà Mau\n",
|
||||
"Bạc Liêu\n",
|
||||
"Hậu Giang\n",
|
||||
"Vĩnh Long\n",
|
||||
"Trà Vinh\n",
|
||||
"Bến Tre\n",
|
||||
"Đồng Nai\n",
|
||||
"Bình Thuận\n",
|
||||
"Ninh Thuận\n",
|
||||
"Phú Yên\n",
|
||||
"Bình Định\n",
|
||||
"Quảng Ngãi\n",
|
||||
"Đà Nẵng\n",
|
||||
"Ninh Bình\n",
|
||||
"Nam Định\n",
|
||||
"Thái Bình\n",
|
||||
"Hải Phòng\n",
|
||||
"Hòa Bình\n",
|
||||
"Tuyên Quang\n",
|
||||
"Yên Bái\n",
|
||||
"Vĩnh Phúc\n",
|
||||
"Phú Thọ\n",
|
||||
"Hà Nội\n",
|
||||
"Bắc Kạn\n",
|
||||
"Hưng Yên\n",
|
||||
"Bắc Ninh\n",
|
||||
"Bắc Giang\n",
|
||||
"Thái Nguyên\n",
|
||||
"Hải Dương\n",
|
||||
"Hà Nam\n",
|
||||
"Bình Dương\n",
|
||||
"Lâm Đồng\n",
|
||||
"Cần Thơ\n"
|
||||
"Ki\u00ean Giang\n",
|
||||
"\u0110i\u1ec7n Bi\u00ean\n",
|
||||
"S\u01a1n La\n",
|
||||
"Thanh H\u00f3a\n",
|
||||
"Ngh\u1ec7 An\n",
|
||||
"H\u00e0 T\u0129nh\n",
|
||||
"Qu\u1ea3ng B\u00ecnh\n",
|
||||
"Qu\u1ea3ng Tr\u1ecb\n",
|
||||
"Th\u1eeba Thi\u00ean - Hu\u1ebf\n",
|
||||
"Qu\u1ea3ng Nam\n",
|
||||
"H\u00e0 Giang\n",
|
||||
"Cao B\u1eb1ng\n",
|
||||
"L\u00e0o Cai\n",
|
||||
"Lai Ch\u00e2u\n",
|
||||
"L\u1ea1ng S\u01a1n\n",
|
||||
"Qu\u1ea3ng Ninh\n",
|
||||
"S\u00f3c Tr\u0103ng\n",
|
||||
"Ti\u1ec1n Giang\n",
|
||||
"B\u00e0 R\u1ecba - V\u0169ng T\u00e0u\n",
|
||||
"Th\u00e0nh ph\u1ed1 H\u1ed3 Ch\u00ed Minh\n",
|
||||
"Kh\u00e1nh H\u00f2a\n",
|
||||
"C\u00e0 Mau\n",
|
||||
"B\u1ea1c Li\u00eau\n",
|
||||
"H\u1eadu Giang\n",
|
||||
"V\u0129nh Long\n",
|
||||
"Tr\u00e0 Vinh\n",
|
||||
"B\u1ebfn Tre\n",
|
||||
"\u0110\u1ed3ng Nai\n",
|
||||
"B\u00ecnh Thu\u1eadn\n",
|
||||
"Ninh Thu\u1eadn\n",
|
||||
"Ph\u00fa Y\u00ean\n",
|
||||
"B\u00ecnh \u0110\u1ecbnh\n",
|
||||
"Qu\u1ea3ng Ng\u00e3i\n",
|
||||
"\u0110\u00e0 N\u1eb5ng\n",
|
||||
"Ninh B\u00ecnh\n",
|
||||
"Nam \u0110\u1ecbnh\n",
|
||||
"Th\u00e1i B\u00ecnh\n",
|
||||
"H\u1ea3i Ph\u00f2ng\n",
|
||||
"H\u00f2a B\u00ecnh\n",
|
||||
"Tuy\u00ean Quang\n",
|
||||
"Y\u00ean B\u00e1i\n",
|
||||
"V\u0129nh Ph\u00fac\n",
|
||||
"Ph\u00fa Th\u1ecd\n",
|
||||
"H\u00e0 N\u1ed9i\n",
|
||||
"B\u1eafc K\u1ea1n\n",
|
||||
"H\u01b0ng Y\u00ean\n",
|
||||
"B\u1eafc Ninh\n",
|
||||
"B\u1eafc Giang\n",
|
||||
"Th\u00e1i Nguy\u00ean\n",
|
||||
"H\u1ea3i D\u01b0\u01a1ng\n",
|
||||
"H\u00e0 Nam\n",
|
||||
"B\u00ecnh D\u01b0\u01a1ng\n",
|
||||
"L\u00e2m \u0110\u1ed3ng\n",
|
||||
"C\u1ea7n Th\u01a1\n"
|
||||
]
|
||||
}
|
||||
],
|
||||
"source": [
|
||||
"vietnam = df[df.admin == 'Vietnam']\n",
|
||||
"vietnam_copy = vietnam.copy()\n",
|
||||
"replace_column('name', vietnam_copy, 'Ðong Tháp', 'Đồng Tháp')\n",
|
||||
"replace_column('name', vietnam_copy, 'Son La', 'Sơn La')\n",
|
||||
"replace_column('name', vietnam_copy, 'Ha Tinh', 'Hà Tĩnh')\n",
|
||||
"replace_column('name', vietnam_copy, 'Quàng Nam', 'Quảng Nam')\n",
|
||||
"replace_column('name', vietnam_copy, 'Lai Chau', 'Lai Châu')\n",
|
||||
"replace_column('name', vietnam_copy, 'Hồ Chí Minh city', 'Thành phố Hồ Chí Minh')\n",
|
||||
"replace_column('name', vietnam_copy, 'Hau Giang', 'Hậu Giang')\n",
|
||||
"replace_column('name', vietnam_copy, 'Ha Noi', 'Hà Nội')\n",
|
||||
"replace_column('name', vietnam_copy, 'Can Tho', 'Cần Thơ')\n",
|
||||
"replace_column('name', vietnam_copy, 'Đông Nam Bộ', 'Đồng Nai')\n",
|
||||
"replace_column('name', vietnam_copy, 'Đông Bắc', 'Bắc Kạn')\n",
|
||||
"replace_column('name', vietnam_copy, 'Đồng Bằng Sông Hồng', 'Hưng Yên')\n",
|
||||
"replace_column('name', vietnam_copy, '\u00d0ong Th\u00e1p', '\u0110\u1ed3ng Th\u00e1p')\n",
|
||||
"replace_column('name', vietnam_copy, 'Son La', 'S\u01a1n La')\n",
|
||||
"replace_column('name', vietnam_copy, 'Ha Tinh', 'H\u00e0 T\u0129nh')\n",
|
||||
"replace_column('name', vietnam_copy, 'Qu\u00e0ng Nam', 'Qu\u1ea3ng Nam')\n",
|
||||
"replace_column('name', vietnam_copy, 'Lai Chau', 'Lai Ch\u00e2u')\n",
|
||||
"replace_column('name', vietnam_copy, 'H\u1ed3 Ch\u00ed Minh city', 'Th\u00e0nh ph\u1ed1 H\u1ed3 Ch\u00ed Minh')\n",
|
||||
"replace_column('name', vietnam_copy, 'Hau Giang', 'H\u1eadu Giang')\n",
|
||||
"replace_column('name', vietnam_copy, 'Ha Noi', 'H\u00e0 N\u1ed9i')\n",
|
||||
"replace_column('name', vietnam_copy, 'Can Tho', 'C\u1ea7n Th\u01a1')\n",
|
||||
"replace_column('name', vietnam_copy, '\u0110\u00f4ng Nam B\u1ed9', '\u0110\u1ed3ng Nai')\n",
|
||||
"replace_column('name', vietnam_copy, '\u0110\u00f4ng B\u1eafc', 'B\u1eafc K\u1ea1n')\n",
|
||||
"replace_column('name', vietnam_copy, '\u0110\u1ed3ng B\u1eb1ng S\u00f4ng H\u1ed3ng', 'H\u01b0ng Y\u00ean')\n",
|
||||
"for i in vietnam_copy['name']:\n",
|
||||
" print(i)"
|
||||
]
|
||||
@@ -3945,6 +3975,7 @@
|
||||
" \"turkey\": turkey_copy,\n",
|
||||
" \"turkey_regions\": turkey_regions,\n",
|
||||
" \"italy_regions\": italy_regions,\n",
|
||||
" \"italy_regions_and_autonomous_provinces\": italy_regions_and_autonomous_provinces,\n",
|
||||
" \"philippines_regions\": philippines_regions,\n",
|
||||
" \"latvia\": latvia_copy,\n",
|
||||
" \"netherlands\": netherlands_copy,\n",
|
||||
@@ -3977,7 +4008,7 @@
|
||||
"aruba has only one subdivision - removing from countries array\n",
|
||||
"british indian ocean territory has only one subdivision - removing from countries array\n",
|
||||
"cayman islands has only one subdivision - removing from countries array\n",
|
||||
"curaçao has only one subdivision - removing from countries array\n",
|
||||
"cura\u00e7ao has only one subdivision - removing from countries array\n",
|
||||
"falkland islands has only one subdivision - removing from countries array\n",
|
||||
"faroe islands has only one subdivision - removing from countries array\n",
|
||||
"gibraltar has only one subdivision - removing from countries array\n",
|
||||
@@ -4001,7 +4032,7 @@
|
||||
"aruba has only one subdivision - removing from countries array\n",
|
||||
"british indian ocean territory has only one subdivision - removing from countries array\n",
|
||||
"cayman islands has only one subdivision - removing from countries array\n",
|
||||
"curaçao has only one subdivision - removing from countries array\n",
|
||||
"cura\u00e7ao has only one subdivision - removing from countries array\n",
|
||||
"falkland islands has only one subdivision - removing from countries array\n",
|
||||
"faroe islands has only one subdivision - removing from countries array\n",
|
||||
"gibraltar has only one subdivision - removing from countries array\n",
|
||||
@@ -4478,6 +4509,9 @@
|
||||
" if (x === 'italy_regions') {\n",
|
||||
" return [x, 'Italy (regions)'];\n",
|
||||
" }\n",
|
||||
" if (x === 'italy_regions_and_autonomous_provinces') {\n",
|
||||
" return [x, 'Italy (regions and autonomous provinces)'];\n",
|
||||
" }\n",
|
||||
" if (x === 'france_regions') {\n",
|
||||
" return [x, 'France (regions)'];\n",
|
||||
" }\n",
|
||||
@@ -4512,6 +4546,7 @@
|
||||
"# Replace underscores with spaces and title-case each country name\n",
|
||||
"formatted_countries = [country.replace(\"_\", \" \") for country in countries_combined]\n",
|
||||
"formatted_countries = [country.upper() if country in {\"usa\", \"uk\"} else country.title() for country in formatted_countries]\n",
|
||||
"formatted_countries = [country.replace(\" Regions And Autonomous Provinces\",\" (regions and autonomous provinces)\") for country in formatted_countries]\n",
|
||||
"formatted_countries = [country.replace(\" Regions\",\" (regions)\") for country in formatted_countries]\n",
|
||||
"formatted_countries = [country.replace(\" Overseas\",\" (with overseas)\") for country in formatted_countries]\n",
|
||||
"\n",
|
||||
|
||||
@@ -103,6 +103,7 @@ import iran from './countries/iran.geojson';
|
||||
import israel from './countries/israel.geojson';
|
||||
import italy from './countries/italy.geojson';
|
||||
import italy_regions from './countries/italy_regions.geojson';
|
||||
import italy_regions_and_autonomous_provinces from './countries/italy_regions_and_autonomous_provinces.geojson';
|
||||
import ivory_coast from './countries/ivory_coast.geojson';
|
||||
import japan from './countries/japan.geojson';
|
||||
import jordan from './countries/jordan.geojson';
|
||||
@@ -306,6 +307,7 @@ export const countries = {
|
||||
israel,
|
||||
italy,
|
||||
italy_regions,
|
||||
italy_regions_and_autonomous_provinces,
|
||||
ivory_coast,
|
||||
japan,
|
||||
jordan,
|
||||
@@ -430,6 +432,9 @@ export const countryOptions = Object.keys(countries).map(x => {
|
||||
if (x === 'italy_regions') {
|
||||
return [x, 'Italy (regions)'];
|
||||
}
|
||||
if (x === 'italy_regions_and_autonomous_provinces') {
|
||||
return [x, 'Italy (regions and autonomous provinces)'];
|
||||
}
|
||||
if (x === 'france_regions') {
|
||||
return [x, 'France (regions)'];
|
||||
}
|
||||
|
||||
File diff suppressed because one or more lines are too long
Reference in New Issue
Block a user