country_stats.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from datetime import datetime,timedelta"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "countries = pd.read_csv('https://raw.githubusercontent.com/kazuhirokida/classification/master/JHU_Classification.csv',na_filter=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "jhu = pd.read_csv('https://github.com/kazuhirokida/covid-19/raw/master/countries.csv',na_filter=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "iso = pd.read_csv('https://raw.githubusercontent.com/kazuhirokida/classification/master/ISO.csv',na_filter=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "countries['Japanese'] = countries.ISO2.map(jhu.set_index('Code').Japanese.to_dict())\n",
    "countries['latlong'] = countries.ISO2.map(jhu.set_index('Code').latlong.to_dict())\n",
    "countries['Numeric'] = countries.ISO2.map(iso.set_index('Alpha-2 code').Numeric.to_dict())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "countries = countries.append(pd.Series({'ISO2':'VU','ISO3':'VUT','Country':'Vanuatu','Region':'Oceania',\n",
    "                      'Classification':'Developing','Japanese':'バヌアツ','latlong':'-17.734,168.323','Numeric':548}),ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "countries = countries.append(pd.Series({'ISO2':'WS','ISO3':'WSM','Country':'Samoa','Region':'Oceania',\n",
    "                      'Classification':'Developing','Japanese':'サモア','latlong':'-13.833,-171.75','Numeric':882}),ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ISO2</th>\n",
       "      <th>ISO3</th>\n",
       "      <th>Country</th>\n",
       "      <th>Region</th>\n",
       "      <th>Classification</th>\n",
       "      <th>Japanese</th>\n",
       "      <th>latlong</th>\n",
       "      <th>Numeric</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DZ</td>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Developing</td>\n",
       "      <td>アルジェリア</td>\n",
       "      <td>28.723,2.868</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AO</td>\n",
       "      <td>AGO</td>\n",
       "      <td>Angola</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Developing</td>\n",
       "      <td>アンゴラ</td>\n",
       "      <td>-12.768,15.743</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BJ</td>\n",
       "      <td>BEN</td>\n",
       "      <td>Benin</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Developing</td>\n",
       "      <td>ベナン</td>\n",
       "      <td>9.359,2.611</td>\n",
       "      <td>204.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BW</td>\n",
       "      <td>BWA</td>\n",
       "      <td>Botswana</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Developing</td>\n",
       "      <td>ボツワナ</td>\n",
       "      <td>-21.980,23.662</td>\n",
       "      <td>72.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BF</td>\n",
       "      <td>BFA</td>\n",
       "      <td>Burkina Faso</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Developing</td>\n",
       "      <td>ブルキナファソ</td>\n",
       "      <td>12.524,-1.855</td>\n",
       "      <td>854.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>PG</td>\n",
       "      <td>PNG</td>\n",
       "      <td>Papua New Guinea</td>\n",
       "      <td>Oceania</td>\n",
       "      <td>Developing</td>\n",
       "      <td>パプアニューギニア</td>\n",
       "      <td>-5.690,143.400</td>\n",
       "      <td>598.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>MH</td>\n",
       "      <td>MHL</td>\n",
       "      <td>Marshall Islands</td>\n",
       "      <td>Oceania</td>\n",
       "      <td>Developing</td>\n",
       "      <td>マーシャル諸島</td>\n",
       "      <td>7.106,171.194</td>\n",
       "      <td>584.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>SB</td>\n",
       "      <td>SLB</td>\n",
       "      <td>Solomon Islands</td>\n",
       "      <td>Oceania</td>\n",
       "      <td>Developing</td>\n",
       "      <td>ソロモン諸島</td>\n",
       "      <td>-9.441,159.974</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>VU</td>\n",
       "      <td>VUT</td>\n",
       "      <td>Vanuatu</td>\n",
       "      <td>Oceania</td>\n",
       "      <td>Developing</td>\n",
       "      <td>バヌアツ</td>\n",
       "      <td>-17.734,168.323</td>\n",
       "      <td>548.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>WS</td>\n",
       "      <td>WSM</td>\n",
       "      <td>Samoa</td>\n",
       "      <td>Oceania</td>\n",
       "      <td>Developing</td>\n",
       "      <td>サモア</td>\n",
       "      <td>-13.833,-171.75</td>\n",
       "      <td>882.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>225 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    ISO2 ISO3           Country   Region Classification   Japanese  \\\n",
       "0     DZ  DZA           Algeria   Africa     Developing     アルジェリア   \n",
       "1     AO  AGO            Angola   Africa     Developing       アンゴラ   \n",
       "2     BJ  BEN             Benin   Africa     Developing        ベナン   \n",
       "3     BW  BWA          Botswana   Africa     Developing       ボツワナ   \n",
       "4     BF  BFA      Burkina Faso   Africa     Developing    ブルキナファソ   \n",
       "..   ...  ...               ...      ...            ...        ...   \n",
       "220   PG  PNG  Papua New Guinea  Oceania     Developing  パプアニューギニア   \n",
       "221   MH  MHL  Marshall Islands  Oceania     Developing    マーシャル諸島   \n",
       "222   SB  SLB   Solomon Islands  Oceania     Developing     ソロモン諸島   \n",
       "223   VU  VUT           Vanuatu  Oceania     Developing       バヌアツ   \n",
       "224   WS  WSM             Samoa  Oceania     Developing        サモア   \n",
       "\n",
       "             latlong  Numeric  \n",
       "0       28.723,2.868     12.0  \n",
       "1     -12.768,15.743     24.0  \n",
       "2        9.359,2.611    204.0  \n",
       "3     -21.980,23.662     72.0  \n",
       "4      12.524,-1.855    854.0  \n",
       "..               ...      ...  \n",
       "220   -5.690,143.400    598.0  \n",
       "221    7.106,171.194    584.0  \n",
       "222   -9.441,159.974     90.0  \n",
       "223  -17.734,168.323    548.0  \n",
       "224  -13.833,-171.75    882.0  \n",
       "\n",
       "[225 rows x 8 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "un = pd.read_csv('https://population.un.org/wpp/Download/Files/1_Indicators%20(Standard)/CSV_FILES/WPP2019_TotalPopulationBySex.csv')\n",
    "un = un[(un.Time==2020)&(un.Variant=='Medium')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "countries['Region_j'] = countries.Region.map(\n",
    "    {'Africa':'アフリカ','Asia':'アジア','Cruise Liner':'クルーズ船','Europe':'欧州','Latin America and Caribbean':'南米','Middle East':'中東',\n",
    "     'North America':'北米','Oceania':'オセアニア'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ISO2</th>\n",
       "      <th>ISO3</th>\n",
       "      <th>Country</th>\n",
       "      <th>Region</th>\n",
       "      <th>Classification</th>\n",
       "      <th>Japanese</th>\n",
       "      <th>latlong</th>\n",
       "      <th>Numeric</th>\n",
       "      <th>Region_j</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>DP*</td>\n",
       "      <td>DP*</td>\n",
       "      <td>Diamond Princess</td>\n",
       "      <td>Cruise Liner</td>\n",
       "      <td>Other*</td>\n",
       "      <td>ダイヤモンド・プリンセス（クルーズ船）</td>\n",
       "      <td>34.000,143.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>クルーズ船</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>MS*</td>\n",
       "      <td>MSZ*</td>\n",
       "      <td>MS Zaandam</td>\n",
       "      <td>Cruise Liner</td>\n",
       "      <td>Other*</td>\n",
       "      <td>MSザーンダム（クルーズ船）</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>クルーズ船</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>CI*</td>\n",
       "      <td>CI*</td>\n",
       "      <td>Channel Islands</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Developed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>欧州</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>XK</td>\n",
       "      <td>XKX</td>\n",
       "      <td>Kosovo</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Developing</td>\n",
       "      <td>コソボ</td>\n",
       "      <td>42.662,21.158</td>\n",
       "      <td>NaN</td>\n",
       "      <td>欧州</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    ISO2  ISO3           Country        Region Classification  \\\n",
       "82   DP*   DP*  Diamond Princess  Cruise Liner         Other*   \n",
       "83   MS*  MSZ*        MS Zaandam  Cruise Liner         Other*   \n",
       "93   CI*   CI*   Channel Islands        Europe      Developed   \n",
       "113   XK   XKX            Kosovo        Europe     Developing   \n",
       "\n",
       "                Japanese         latlong  Numeric Region_j  \n",
       "82   ダイヤモンド・プリンセス（クルーズ船）  34.000,143.000      NaN    クルーズ船  \n",
       "83        MSザーンダム（クルーズ船）                      NaN    クルーズ船  \n",
       "93                   NaN             NaN      NaN       欧州  \n",
       "113                  コソボ   42.662,21.158      NaN       欧州  "
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countries[countries.Numeric.isna()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "who = pd.read_csv('https://covid19.who.int/WHO-COVID-19-global-data.csv',na_filter=False)\n",
    "who.columns = who.columns.str.replace(' ','')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "who_region = who[['Country_code','WHO_region']].drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "countries['Region_who'] = countries['ISO2'].map(who_region.set_index('Country_code').WHO_region.to_dict())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ISO2</th>\n",
       "      <th>ISO3</th>\n",
       "      <th>Country</th>\n",
       "      <th>Region</th>\n",
       "      <th>Classification</th>\n",
       "      <th>Japanese</th>\n",
       "      <th>latlong</th>\n",
       "      <th>Numeric</th>\n",
       "      <th>Region_j</th>\n",
       "      <th>Region_who</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>EH</td>\n",
       "      <td>ESH</td>\n",
       "      <td>Western Sahara</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Developing</td>\n",
       "      <td>西サハラ</td>\n",
       "      <td>24.860,-13.674</td>\n",
       "      <td>732.0</td>\n",
       "      <td>アフリカ</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>HK</td>\n",
       "      <td>HKG</td>\n",
       "      <td>Hong Kong</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Developing</td>\n",
       "      <td>香港</td>\n",
       "      <td>22.287,114.143</td>\n",
       "      <td>344.0</td>\n",
       "      <td>アジア</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>MO</td>\n",
       "      <td>MAC</td>\n",
       "      <td>Macau</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Developing</td>\n",
       "      <td>マカオ</td>\n",
       "      <td>22.159,113.564</td>\n",
       "      <td>446.0</td>\n",
       "      <td>アジア</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>TW</td>\n",
       "      <td>TWN</td>\n",
       "      <td>Taiwan*</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Developing</td>\n",
       "      <td>台湾</td>\n",
       "      <td>24.014,121.111</td>\n",
       "      <td>158.0</td>\n",
       "      <td>アジア</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>DP*</td>\n",
       "      <td>DP*</td>\n",
       "      <td>Diamond Princess</td>\n",
       "      <td>Cruise Liner</td>\n",
       "      <td>Other*</td>\n",
       "      <td>ダイヤモンド・プリンセス（クルーズ船）</td>\n",
       "      <td>34.000,143.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>クルーズ船</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>MS*</td>\n",
       "      <td>MSZ*</td>\n",
       "      <td>MS Zaandam</td>\n",
       "      <td>Cruise Liner</td>\n",
       "      <td>Other*</td>\n",
       "      <td>MSザーンダム（クルーズ船）</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>クルーズ船</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>CI*</td>\n",
       "      <td>CI*</td>\n",
       "      <td>Channel Islands</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Developed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>欧州</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>BQ</td>\n",
       "      <td>BES</td>\n",
       "      <td>Bonaire, Sint Eustatius and Saba</td>\n",
       "      <td>Latin America and Caribbean</td>\n",
       "      <td>Developing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>535.0</td>\n",
       "      <td>南米</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    ISO2  ISO3                           Country                       Region  \\\n",
       "54    EH   ESH                    Western Sahara                       Africa   \n",
       "63    HK   HKG                         Hong Kong                         Asia   \n",
       "69    MO   MAC                             Macau                         Asia   \n",
       "78    TW   TWN                           Taiwan*                         Asia   \n",
       "82   DP*   DP*                  Diamond Princess                 Cruise Liner   \n",
       "83   MS*  MSZ*                        MS Zaandam                 Cruise Liner   \n",
       "93   CI*   CI*                   Channel Islands                       Europe   \n",
       "149   BQ   BES  Bonaire, Sint Eustatius and Saba  Latin America and Caribbean   \n",
       "\n",
       "    Classification             Japanese         latlong  Numeric Region_j  \\\n",
       "54      Developing                 西サハラ  24.860,-13.674    732.0     アフリカ   \n",
       "63      Developing                   香港  22.287,114.143    344.0      アジア   \n",
       "69      Developing                  マカオ  22.159,113.564    446.0      アジア   \n",
       "78      Developing                   台湾  24.014,121.111    158.0      アジア   \n",
       "82          Other*  ダイヤモンド・プリンセス（クルーズ船）  34.000,143.000      NaN    クルーズ船   \n",
       "83          Other*       MSザーンダム（クルーズ船）                      NaN    クルーズ船   \n",
       "93       Developed                  NaN             NaN      NaN       欧州   \n",
       "149     Developing                  NaN             NaN    535.0       南米   \n",
       "\n",
       "    Region_who  \n",
       "54         NaN  \n",
       "63         NaN  \n",
       "69         NaN  \n",
       "78         NaN  \n",
       "82         NaN  \n",
       "83         NaN  \n",
       "93         NaN  \n",
       "149        NaN  "
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countries[countries.Region_who.isna()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "countries['population'] = countries.Numeric.map(un.set_index('LocID').PopTotal.to_dict())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "countries = countries.append(pd.Series({'ISO2':'NaN','ISO3':'NaN','Country':'Cruise Liner','Region':'Cruise Liner',\n",
    "                      'Classification':'Other*','Japanese':'クルーズ船などその他','latlong':'34.000,143.000','Region_j':'クルーズ船',\n",
    "                     'Numeric':'NaN'}),ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ISO2</th>\n",
       "      <th>ISO3</th>\n",
       "      <th>Country</th>\n",
       "      <th>Region</th>\n",
       "      <th>Classification</th>\n",
       "      <th>Japanese</th>\n",
       "      <th>latlong</th>\n",
       "      <th>Numeric</th>\n",
       "      <th>Region_j</th>\n",
       "      <th>Region_who</th>\n",
       "      <th>population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DZ</td>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Developing</td>\n",
       "      <td>アルジェリア</td>\n",
       "      <td>28.723,2.868</td>\n",
       "      <td>12</td>\n",
       "      <td>アフリカ</td>\n",
       "      <td>AFRO</td>\n",
       "      <td>43851.043</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AO</td>\n",
       "      <td>AGO</td>\n",
       "      <td>Angola</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Developing</td>\n",
       "      <td>アンゴラ</td>\n",
       "      <td>-12.768,15.743</td>\n",
       "      <td>24</td>\n",
       "      <td>アフリカ</td>\n",
       "      <td>AFRO</td>\n",
       "      <td>32866.268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BJ</td>\n",
       "      <td>BEN</td>\n",
       "      <td>Benin</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Developing</td>\n",
       "      <td>ベナン</td>\n",
       "      <td>9.359,2.611</td>\n",
       "      <td>204</td>\n",
       "      <td>アフリカ</td>\n",
       "      <td>AFRO</td>\n",
       "      <td>12123.198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BW</td>\n",
       "      <td>BWA</td>\n",
       "      <td>Botswana</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Developing</td>\n",
       "      <td>ボツワナ</td>\n",
       "      <td>-21.980,23.662</td>\n",
       "      <td>72</td>\n",
       "      <td>アフリカ</td>\n",
       "      <td>AFRO</td>\n",
       "      <td>2351.625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BF</td>\n",
       "      <td>BFA</td>\n",
       "      <td>Burkina Faso</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Developing</td>\n",
       "      <td>ブルキナファソ</td>\n",
       "      <td>12.524,-1.855</td>\n",
       "      <td>854</td>\n",
       "      <td>アフリカ</td>\n",
       "      <td>AFRO</td>\n",
       "      <td>20903.278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>MH</td>\n",
       "      <td>MHL</td>\n",
       "      <td>Marshall Islands</td>\n",
       "      <td>Oceania</td>\n",
       "      <td>Developing</td>\n",
       "      <td>マーシャル諸島</td>\n",
       "      <td>7.106,171.194</td>\n",
       "      <td>584</td>\n",
       "      <td>オセアニア</td>\n",
       "      <td>WPRO</td>\n",
       "      <td>59.194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>SB</td>\n",
       "      <td>SLB</td>\n",
       "      <td>Solomon Islands</td>\n",
       "      <td>Oceania</td>\n",
       "      <td>Developing</td>\n",
       "      <td>ソロモン諸島</td>\n",
       "      <td>-9.441,159.974</td>\n",
       "      <td>90</td>\n",
       "      <td>オセアニア</td>\n",
       "      <td>WPRO</td>\n",
       "      <td>686.878</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>VU</td>\n",
       "      <td>VUT</td>\n",
       "      <td>Vanuatu</td>\n",
       "      <td>Oceania</td>\n",
       "      <td>Developing</td>\n",
       "      <td>バヌアツ</td>\n",
       "      <td>-17.734,168.323</td>\n",
       "      <td>548</td>\n",
       "      <td>オセアニア</td>\n",
       "      <td>WPRO</td>\n",
       "      <td>307.150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>WS</td>\n",
       "      <td>WSM</td>\n",
       "      <td>Samoa</td>\n",
       "      <td>Oceania</td>\n",
       "      <td>Developing</td>\n",
       "      <td>サモア</td>\n",
       "      <td>-13.833,-171.75</td>\n",
       "      <td>882</td>\n",
       "      <td>オセアニア</td>\n",
       "      <td>WPRO</td>\n",
       "      <td>198.410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cruise Liner</td>\n",
       "      <td>Cruise Liner</td>\n",
       "      <td>Other*</td>\n",
       "      <td>クルーズ船などその他</td>\n",
       "      <td>34.000,143.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>クルーズ船</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>226 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    ISO2 ISO3           Country        Region Classification    Japanese  \\\n",
       "0     DZ  DZA           Algeria        Africa     Developing      アルジェリア   \n",
       "1     AO  AGO            Angola        Africa     Developing        アンゴラ   \n",
       "2     BJ  BEN             Benin        Africa     Developing         ベナン   \n",
       "3     BW  BWA          Botswana        Africa     Developing        ボツワナ   \n",
       "4     BF  BFA      Burkina Faso        Africa     Developing     ブルキナファソ   \n",
       "..   ...  ...               ...           ...            ...         ...   \n",
       "221   MH  MHL  Marshall Islands       Oceania     Developing     マーシャル諸島   \n",
       "222   SB  SLB   Solomon Islands       Oceania     Developing      ソロモン諸島   \n",
       "223   VU  VUT           Vanuatu       Oceania     Developing        バヌアツ   \n",
       "224   WS  WSM             Samoa       Oceania     Developing         サモア   \n",
       "225  NaN  NaN      Cruise Liner  Cruise Liner         Other*  クルーズ船などその他   \n",
       "\n",
       "             latlong Numeric Region_j Region_who  population  \n",
       "0       28.723,2.868      12     アフリカ       AFRO   43851.043  \n",
       "1     -12.768,15.743      24     アフリカ       AFRO   32866.268  \n",
       "2        9.359,2.611     204     アフリカ       AFRO   12123.198  \n",
       "3     -21.980,23.662      72     アフリカ       AFRO    2351.625  \n",
       "4      12.524,-1.855     854     アフリカ       AFRO   20903.278  \n",
       "..               ...     ...      ...        ...         ...  \n",
       "221    7.106,171.194     584    オセアニア       WPRO      59.194  \n",
       "222   -9.441,159.974      90    オセアニア       WPRO     686.878  \n",
       "223  -17.734,168.323     548    オセアニア       WPRO     307.150  \n",
       "224  -13.833,-171.75     882    オセアニア       WPRO     198.410  \n",
       "225   34.000,143.000     NaN    クルーズ船        NaN         NaN  \n",
       "\n",
       "[226 rows x 11 columns]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "#https://unstats.un.org/unsd/methodology/m49/overview/\n",
    "unsd = pd.read_csv('UNSD — Methodology.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "countries['ldc'] = countries['ISO3'].map(unsd.set_index('ISO-alpha3 Code')['Least Developed Countries (LDC)'].to_dict())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ISO2</th>\n",
       "      <th>ISO3</th>\n",
       "      <th>Country</th>\n",
       "      <th>Region</th>\n",
       "      <th>Classification</th>\n",
       "      <th>Japanese</th>\n",
       "      <th>latlong</th>\n",
       "      <th>Numeric</th>\n",
       "      <th>Region_j</th>\n",
       "      <th>Region_who</th>\n",
       "      <th>population</th>\n",
       "      <th>ldc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DZ</td>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Developing</td>\n",
       "      <td>アルジェリア</td>\n",
       "      <td>28.723,2.868</td>\n",
       "      <td>12</td>\n",
       "      <td>アフリカ</td>\n",
       "      <td>AFRO</td>\n",
       "      <td>43851.043</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AO</td>\n",
       "      <td>AGO</td>\n",
       "      <td>Angola</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Developing</td>\n",
       "      <td>アンゴラ</td>\n",
       "      <td>-12.768,15.743</td>\n",
       "      <td>24</td>\n",
       "      <td>アフリカ</td>\n",
       "      <td>AFRO</td>\n",
       "      <td>32866.268</td>\n",
       "      <td>x</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BJ</td>\n",
       "      <td>BEN</td>\n",
       "      <td>Benin</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Developing</td>\n",
       "      <td>ベナン</td>\n",
       "      <td>9.359,2.611</td>\n",
       "      <td>204</td>\n",
       "      <td>アフリカ</td>\n",
       "      <td>AFRO</td>\n",
       "      <td>12123.198</td>\n",
       "      <td>x</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BW</td>\n",
       "      <td>BWA</td>\n",
       "      <td>Botswana</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Developing</td>\n",
       "      <td>ボツワナ</td>\n",
       "      <td>-21.980,23.662</td>\n",
       "      <td>72</td>\n",
       "      <td>アフリカ</td>\n",
       "      <td>AFRO</td>\n",
       "      <td>2351.625</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BF</td>\n",
       "      <td>BFA</td>\n",
       "      <td>Burkina Faso</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Developing</td>\n",
       "      <td>ブルキナファソ</td>\n",
       "      <td>12.524,-1.855</td>\n",
       "      <td>854</td>\n",
       "      <td>アフリカ</td>\n",
       "      <td>AFRO</td>\n",
       "      <td>20903.278</td>\n",
       "      <td>x</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>MH</td>\n",
       "      <td>MHL</td>\n",
       "      <td>Marshall Islands</td>\n",
       "      <td>Oceania</td>\n",
       "      <td>Developing</td>\n",
       "      <td>マーシャル諸島</td>\n",
       "      <td>7.106,171.194</td>\n",
       "      <td>584</td>\n",
       "      <td>オセアニア</td>\n",
       "      <td>WPRO</td>\n",
       "      <td>59.194</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>SB</td>\n",
       "      <td>SLB</td>\n",
       "      <td>Solomon Islands</td>\n",
       "      <td>Oceania</td>\n",
       "      <td>Developing</td>\n",
       "      <td>ソロモン諸島</td>\n",
       "      <td>-9.441,159.974</td>\n",
       "      <td>90</td>\n",
       "      <td>オセアニア</td>\n",
       "      <td>WPRO</td>\n",
       "      <td>686.878</td>\n",
       "      <td>x</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>VU</td>\n",
       "      <td>VUT</td>\n",
       "      <td>Vanuatu</td>\n",
       "      <td>Oceania</td>\n",
       "      <td>Developing</td>\n",
       "      <td>バヌアツ</td>\n",
       "      <td>-17.734,168.323</td>\n",
       "      <td>548</td>\n",
       "      <td>オセアニア</td>\n",
       "      <td>WPRO</td>\n",
       "      <td>307.150</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>WS</td>\n",
       "      <td>WSM</td>\n",
       "      <td>Samoa</td>\n",
       "      <td>Oceania</td>\n",
       "      <td>Developing</td>\n",
       "      <td>サモア</td>\n",
       "      <td>-13.833,-171.75</td>\n",
       "      <td>882</td>\n",
       "      <td>オセアニア</td>\n",
       "      <td>WPRO</td>\n",
       "      <td>198.410</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cruise Liner</td>\n",
       "      <td>Cruise Liner</td>\n",
       "      <td>Other*</td>\n",
       "      <td>クルーズ船などその他</td>\n",
       "      <td>34.000,143.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>クルーズ船</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>226 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    ISO2 ISO3           Country        Region Classification    Japanese  \\\n",
       "0     DZ  DZA           Algeria        Africa     Developing      アルジェリア   \n",
       "1     AO  AGO            Angola        Africa     Developing        アンゴラ   \n",
       "2     BJ  BEN             Benin        Africa     Developing         ベナン   \n",
       "3     BW  BWA          Botswana        Africa     Developing        ボツワナ   \n",
       "4     BF  BFA      Burkina Faso        Africa     Developing     ブルキナファソ   \n",
       "..   ...  ...               ...           ...            ...         ...   \n",
       "221   MH  MHL  Marshall Islands       Oceania     Developing     マーシャル諸島   \n",
       "222   SB  SLB   Solomon Islands       Oceania     Developing      ソロモン諸島   \n",
       "223   VU  VUT           Vanuatu       Oceania     Developing        バヌアツ   \n",
       "224   WS  WSM             Samoa       Oceania     Developing         サモア   \n",
       "225  NaN  NaN      Cruise Liner  Cruise Liner         Other*  クルーズ船などその他   \n",
       "\n",
       "             latlong Numeric Region_j Region_who  population  ldc  \n",
       "0       28.723,2.868      12     アフリカ       AFRO   43851.043  NaN  \n",
       "1     -12.768,15.743      24     アフリカ       AFRO   32866.268    x  \n",
       "2        9.359,2.611     204     アフリカ       AFRO   12123.198    x  \n",
       "3     -21.980,23.662      72     アフリカ       AFRO    2351.625  NaN  \n",
       "4      12.524,-1.855     854     アフリカ       AFRO   20903.278    x  \n",
       "..               ...     ...      ...        ...         ...  ...  \n",
       "221    7.106,171.194     584    オセアニア       WPRO      59.194  NaN  \n",
       "222   -9.441,159.974      90    オセアニア       WPRO     686.878    x  \n",
       "223  -17.734,168.323     548    オセアニア       WPRO     307.150  NaN  \n",
       "224  -13.833,-171.75     882    オセアニア       WPRO     198.410  NaN  \n",
       "225   34.000,143.000     NaN    クルーズ船        NaN         NaN  NaN  \n",
       "\n",
       "[226 rows x 12 columns]"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "eu = ['アイルランド','イタリア','エストニア','オーストリア','オランダ','キプロス','ギリシャ',\n",
    "     'クロアチア','スウェーデン','スペイン','スロバキア','スロベニア','チェコ','デンマーク',\n",
    "     'ドイツ','ハンガリー','フィンランド','フランス','ブルガリア','ベルギー','ポーランド',\n",
    "     'ポルトガル','マルタ','ラトビア','リトアニア','ルーマニア','ルクセンブルク','英国']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [],
   "source": [
    "l = []\n",
    "\n",
    "for i in countries.Japanese:\n",
    "    if i in eu:\n",
    "        l.append('EU')\n",
    "    else:\n",
    "        l.append(np.nan)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "countries['EU_dummy'] = l"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ISO2</th>\n",
       "      <th>ISO3</th>\n",
       "      <th>Country</th>\n",
       "      <th>Region</th>\n",
       "      <th>Classification</th>\n",
       "      <th>Japanese</th>\n",
       "      <th>latlong</th>\n",
       "      <th>Numeric</th>\n",
       "      <th>Region_j</th>\n",
       "      <th>Region_who</th>\n",
       "      <th>population</th>\n",
       "      <th>ldc</th>\n",
       "      <th>EU_dummy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DZ</td>\n",
       "      <td>DZA</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Developing</td>\n",
       "      <td>アルジェリア</td>\n",
       "      <td>28.723,2.868</td>\n",
       "      <td>12</td>\n",
       "      <td>アフリカ</td>\n",
       "      <td>AFRO</td>\n",
       "      <td>43851.043</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AO</td>\n",
       "      <td>AGO</td>\n",
       "      <td>Angola</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Developing</td>\n",
       "      <td>アンゴラ</td>\n",
       "      <td>-12.768,15.743</td>\n",
       "      <td>24</td>\n",
       "      <td>アフリカ</td>\n",
       "      <td>AFRO</td>\n",
       "      <td>32866.268</td>\n",
       "      <td>x</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BJ</td>\n",
       "      <td>BEN</td>\n",
       "      <td>Benin</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Developing</td>\n",
       "      <td>ベナン</td>\n",
       "      <td>9.359,2.611</td>\n",
       "      <td>204</td>\n",
       "      <td>アフリカ</td>\n",
       "      <td>AFRO</td>\n",
       "      <td>12123.198</td>\n",
       "      <td>x</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BW</td>\n",
       "      <td>BWA</td>\n",
       "      <td>Botswana</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Developing</td>\n",
       "      <td>ボツワナ</td>\n",
       "      <td>-21.980,23.662</td>\n",
       "      <td>72</td>\n",
       "      <td>アフリカ</td>\n",
       "      <td>AFRO</td>\n",
       "      <td>2351.625</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BF</td>\n",
       "      <td>BFA</td>\n",
       "      <td>Burkina Faso</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Developing</td>\n",
       "      <td>ブルキナファソ</td>\n",
       "      <td>12.524,-1.855</td>\n",
       "      <td>854</td>\n",
       "      <td>アフリカ</td>\n",
       "      <td>AFRO</td>\n",
       "      <td>20903.278</td>\n",
       "      <td>x</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>MH</td>\n",
       "      <td>MHL</td>\n",
       "      <td>Marshall Islands</td>\n",
       "      <td>Oceania</td>\n",
       "      <td>Developing</td>\n",
       "      <td>マーシャル諸島</td>\n",
       "      <td>7.106,171.194</td>\n",
       "      <td>584</td>\n",
       "      <td>オセアニア</td>\n",
       "      <td>WPRO</td>\n",
       "      <td>59.194</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>SB</td>\n",
       "      <td>SLB</td>\n",
       "      <td>Solomon Islands</td>\n",
       "      <td>Oceania</td>\n",
       "      <td>Developing</td>\n",
       "      <td>ソロモン諸島</td>\n",
       "      <td>-9.441,159.974</td>\n",
       "      <td>90</td>\n",
       "      <td>オセアニア</td>\n",
       "      <td>WPRO</td>\n",
       "      <td>686.878</td>\n",
       "      <td>x</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>VU</td>\n",
       "      <td>VUT</td>\n",
       "      <td>Vanuatu</td>\n",
       "      <td>Oceania</td>\n",
       "      <td>Developing</td>\n",
       "      <td>バヌアツ</td>\n",
       "      <td>-17.734,168.323</td>\n",
       "      <td>548</td>\n",
       "      <td>オセアニア</td>\n",
       "      <td>WPRO</td>\n",
       "      <td>307.150</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>WS</td>\n",
       "      <td>WSM</td>\n",
       "      <td>Samoa</td>\n",
       "      <td>Oceania</td>\n",
       "      <td>Developing</td>\n",
       "      <td>サモア</td>\n",
       "      <td>-13.833,-171.75</td>\n",
       "      <td>882</td>\n",
       "      <td>オセアニア</td>\n",
       "      <td>WPRO</td>\n",
       "      <td>198.410</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cruise Liner</td>\n",
       "      <td>Cruise Liner</td>\n",
       "      <td>Other*</td>\n",
       "      <td>クルーズ船などその他</td>\n",
       "      <td>34.000,143.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>クルーズ船</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>226 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    ISO2 ISO3           Country        Region Classification    Japanese  \\\n",
       "0     DZ  DZA           Algeria        Africa     Developing      アルジェリア   \n",
       "1     AO  AGO            Angola        Africa     Developing        アンゴラ   \n",
       "2     BJ  BEN             Benin        Africa     Developing         ベナン   \n",
       "3     BW  BWA          Botswana        Africa     Developing        ボツワナ   \n",
       "4     BF  BFA      Burkina Faso        Africa     Developing     ブルキナファソ   \n",
       "..   ...  ...               ...           ...            ...         ...   \n",
       "221   MH  MHL  Marshall Islands       Oceania     Developing     マーシャル諸島   \n",
       "222   SB  SLB   Solomon Islands       Oceania     Developing      ソロモン諸島   \n",
       "223   VU  VUT           Vanuatu       Oceania     Developing        バヌアツ   \n",
       "224   WS  WSM             Samoa       Oceania     Developing         サモア   \n",
       "225  NaN  NaN      Cruise Liner  Cruise Liner         Other*  クルーズ船などその他   \n",
       "\n",
       "             latlong Numeric Region_j Region_who  population  ldc EU_dummy  \n",
       "0       28.723,2.868      12     アフリカ       AFRO   43851.043  NaN      NaN  \n",
       "1     -12.768,15.743      24     アフリカ       AFRO   32866.268    x      NaN  \n",
       "2        9.359,2.611     204     アフリカ       AFRO   12123.198    x      NaN  \n",
       "3     -21.980,23.662      72     アフリカ       AFRO    2351.625  NaN      NaN  \n",
       "4      12.524,-1.855     854     アフリカ       AFRO   20903.278    x      NaN  \n",
       "..               ...     ...      ...        ...         ...  ...      ...  \n",
       "221    7.106,171.194     584    オセアニア       WPRO      59.194  NaN      NaN  \n",
       "222   -9.441,159.974      90    オセアニア       WPRO     686.878    x      NaN  \n",
       "223  -17.734,168.323     548    オセアニア       WPRO     307.150  NaN      NaN  \n",
       "224  -13.833,-171.75     882    オセアニア       WPRO     198.410  NaN      NaN  \n",
       "225   34.000,143.000     NaN    クルーズ船        NaN         NaN  NaN      NaN  \n",
       "\n",
       "[226 rows x 13 columns]"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "countries.to_csv('country_stats.csv', encoding='utf_8_sig')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}