Country Mapping Data.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Country & Nationality mapping\n",
    "\n",
    "In many instances we will need to be able to convert between country and nationality when connecting people and companies to countries.\n",
    "\n",
    "We have three different source files that we can use, natively stored as JSON we will convert them to pickles for reasy use within python. The 3 files are:\n",
    "\n",
    "- Country names to country code mappings\n",
    "- Country code to country name mappings\n",
    "- Nationality to country code mappings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import json\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Country codes to names"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "country_codes_2_names = json.load(open('data/clean_country_code_map.json', 'r'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'AD': 'ANDORRA',\n",
       " 'AE': 'UNITED ARAB EMIRATES',\n",
       " 'AF': 'AFGHANISTAN',\n",
       " 'AG': 'ANTIGUA & BARBUDA',\n",
       " 'AL': 'ALBANIA',\n",
       " 'AM': 'ARMENIA',\n",
       " 'AO': 'ANGOLA',\n",
       " 'AR': 'ARGENTINA',\n",
       " 'AS': 'AMERICAN SAMOA',\n",
       " 'AT': 'AUSTRIA',\n",
       " 'AU': 'AUSTRALIA',\n",
       " 'AW': 'ARUBA',\n",
       " 'AX': 'ÌÉLAND ISLANDS',\n",
       " 'AZ': 'AZERBAIJAN',\n",
       " 'BA': 'BOSNIA',\n",
       " 'BB': 'BARBADOS',\n",
       " 'BD': 'BANGLADESH',\n",
       " 'BE': 'BELGIUM',\n",
       " 'BG': 'BULGARIA',\n",
       " 'BH': 'BAHRAIN',\n",
       " 'BI': 'BURUNDI',\n",
       " 'BJ': 'BENIN',\n",
       " 'BM': 'BERMUDA',\n",
       " 'BN': 'BRUNEI',\n",
       " 'BO': 'BOLIVIA',\n",
       " 'BR': 'BRAZIL',\n",
       " 'BS': 'BAHAMAS',\n",
       " 'BT': 'BHUTAN',\n",
       " 'BW': 'BOTSWANA',\n",
       " 'BY': 'BELARUS',\n",
       " 'BZ': 'BELIZE',\n",
       " 'CA': 'CANADA',\n",
       " 'CD': 'CONGO - KINSHASA',\n",
       " 'CF': 'CENTRAL AFRICAN REPUBLIC',\n",
       " 'CG': 'CONGO - BRAZZAVILLE',\n",
       " 'CH': 'SWITZERLAND',\n",
       " 'CI': 'CÌ«TE D\\x89ÛªIVOIRE',\n",
       " 'CK': 'COOK ISLANDS',\n",
       " 'CL': 'CHILE',\n",
       " 'CM': 'CAMEROON',\n",
       " 'CN': 'CHINA',\n",
       " 'CO': 'COLOMBIA',\n",
       " 'CR': 'COSTA RICA',\n",
       " 'CU': 'CUBA',\n",
       " 'CY': 'CYPRUS',\n",
       " 'CZ': 'CZECHIA',\n",
       " 'DE': 'GERMANY',\n",
       " 'DJ': 'DJIBOUTI',\n",
       " 'DK': 'DENMARK',\n",
       " 'DM': 'DOMINICA',\n",
       " 'DO': 'DOMINICAN REPUBLIC',\n",
       " 'DQ': 'DQ',\n",
       " 'DZ': 'ALGERIA',\n",
       " 'EC': 'ECUADOR',\n",
       " 'EE': 'ESTONIA',\n",
       " 'EG': 'EGYPT',\n",
       " 'ER': 'ERITREA',\n",
       " 'ES': 'SPAIN',\n",
       " 'ET': 'ETHIOPIA',\n",
       " 'FI': 'FINLAND',\n",
       " 'FJ': 'FIJI',\n",
       " 'FR': 'FRANCE',\n",
       " 'GA': 'GABON',\n",
       " 'GB': 'UK',\n",
       " 'GD': 'GRENADA',\n",
       " 'GE': 'GEORGIA',\n",
       " 'GF': 'FRENCH GUIANA',\n",
       " 'GG': 'GUERNSEY',\n",
       " 'GH': 'GHANA',\n",
       " 'GI': 'GIBRALTAR',\n",
       " 'GM': 'GAMBIA',\n",
       " 'GN': 'GUINEA',\n",
       " 'GP': 'GUADELOUPE',\n",
       " 'GR': 'GREECE',\n",
       " 'GT': 'GUATEMALA',\n",
       " 'GW': 'GUINEA-BISSAU',\n",
       " 'GY': 'GUYANA',\n",
       " 'HK': 'HONG KONG',\n",
       " 'HN': 'HONDURAS',\n",
       " 'HR': 'CROATIA',\n",
       " 'HT': 'HAITI',\n",
       " 'HU': 'HUNGARY',\n",
       " 'ID': 'INDONESIA',\n",
       " 'IE': 'IRELAND',\n",
       " 'IL': 'ISRAEL',\n",
       " 'IM': 'ISLE OF MAN',\n",
       " 'IN': 'INDIA',\n",
       " 'IQ': 'IRAQ',\n",
       " 'IR': 'IRAN',\n",
       " 'IS': 'ICELAND',\n",
       " 'IT': 'ITALY',\n",
       " 'JM': 'JAMAICA',\n",
       " 'JO': 'JORDAN',\n",
       " 'JP': 'JAPAN',\n",
       " 'KE': 'KENYA',\n",
       " 'KG': 'KYRGYZSTAN',\n",
       " 'KH': 'CAMBODIA',\n",
       " 'KI': 'KIRIBATI',\n",
       " 'KN': 'ST. KITTS & NEVIS',\n",
       " 'KP': 'NORTH KOREA',\n",
       " 'KR': 'SOUTH KOREA',\n",
       " 'KW': 'KUWAIT',\n",
       " 'KY': 'CAYMAN ISLANDS',\n",
       " 'KZ': 'KAZAKHSTAN',\n",
       " 'LB': 'LEBANON',\n",
       " 'LC': 'ST. LUCIA',\n",
       " 'LI': 'LIECHTENSTEIN',\n",
       " 'LK': 'SRI LANKA',\n",
       " 'LR': 'LIBERIA',\n",
       " 'LS': 'LESOTHO',\n",
       " 'LT': 'LITHUANIA',\n",
       " 'LU': 'LUXEMBOURG',\n",
       " 'LV': 'LATVIA',\n",
       " 'LY': 'LIBYA',\n",
       " 'MA': 'MOROCCO',\n",
       " 'MD': 'MOLDOVA',\n",
       " 'ME': 'MONTENEGRO',\n",
       " 'MG': 'MADAGASCAR',\n",
       " 'MK': 'MACEDONIA',\n",
       " 'MM': 'MYANMAR',\n",
       " 'MN': 'MONGOLIA',\n",
       " 'MO': 'MACAU',\n",
       " 'MR': 'MAURITANIA',\n",
       " 'MT': 'MALTA',\n",
       " 'MU': 'MAURITIUS',\n",
       " 'MV': 'MALDIVES',\n",
       " 'MW': 'MALAWI',\n",
       " 'MX': 'MEXICO',\n",
       " 'MY': 'MALAYSIA',\n",
       " 'MZ': 'MOZAMBIQUE',\n",
       " 'NA': 'NAMIBIA',\n",
       " 'NE': 'NIGER',\n",
       " 'NG': 'NIGERIA',\n",
       " 'NI': 'NICARAGUA',\n",
       " 'NL': 'NETHERLANDS',\n",
       " 'NO': 'NORWAY',\n",
       " 'NP': 'NEPAL',\n",
       " 'NR': 'NAURU',\n",
       " 'NZ': 'NEW ZEALAND',\n",
       " 'OM': 'OMAN',\n",
       " 'PA': 'PANAMA',\n",
       " 'PE': 'PERU',\n",
       " 'PG': 'PAPUA NEW GUINEA',\n",
       " 'PH': 'PHILIPPINES',\n",
       " 'PK': 'PAKISTAN',\n",
       " 'PL': 'POLAND',\n",
       " 'PR': 'PUERTO RICO',\n",
       " 'PS': 'PALESTINE',\n",
       " 'PT': 'PORTUGAL',\n",
       " 'PY': 'PARAGUAY',\n",
       " 'QA': 'QATAR',\n",
       " 'RO': 'ROMANIA',\n",
       " 'RS': 'SERBIA',\n",
       " 'RU': 'RUSSIA',\n",
       " 'RW': 'RWANDA',\n",
       " 'SA': 'SAUDI ARABIA',\n",
       " 'SC': 'SEYCHELLES',\n",
       " 'SD': 'SUDAN',\n",
       " 'SE': 'SWEDEN',\n",
       " 'SG': 'SINGAPORE',\n",
       " 'SI': 'SLOVENIA',\n",
       " 'SK': 'SLOVAKIA',\n",
       " 'SL': 'SIERRA LEONE',\n",
       " 'SM': 'SAN MARINO',\n",
       " 'SN': 'SENEGAL',\n",
       " 'SO': 'SOMALIA',\n",
       " 'ST': 'SÌ£O TOMÌ© & PRÌ?NCIPE',\n",
       " 'SV': 'EL SALVADOR',\n",
       " 'SY': 'SYRIA',\n",
       " 'SZ': 'SWAZILAND',\n",
       " 'TG': 'TOGO',\n",
       " 'TH': 'THAILAND',\n",
       " 'TJ': 'TAJIKISTAN',\n",
       " 'TL': 'TIMOR-LESTE',\n",
       " 'TM': 'TURKMENISTAN',\n",
       " 'TN': 'TUNISIA',\n",
       " 'TO': 'TONGA',\n",
       " 'TR': 'TURKEY',\n",
       " 'TT': 'TRINIDAD & TOBAGO',\n",
       " 'TW': 'TAIWAN',\n",
       " 'TZ': 'TANZANIA',\n",
       " 'UA': 'UKRAINE',\n",
       " 'UG': 'UGANDA',\n",
       " 'US': 'US',\n",
       " 'UY': 'URUGUAY',\n",
       " 'UZ': 'UZBEKISTAN',\n",
       " 'VC': 'ST. VINCENT & GRENADINES',\n",
       " 'VE': 'VENEZUELA',\n",
       " 'VG': 'BRITISH VIRGIN ISLANDS',\n",
       " 'VN': 'VIETNAM',\n",
       " 'VU': 'VANUATU',\n",
       " 'XK': 'KOSOVO',\n",
       " 'YE': 'YEMEN',\n",
       " 'ZA': 'SOUTH AFRICA',\n",
       " 'ZM': 'ZAMBIA',\n",
       " 'ZW': 'ZIMBABWE'}"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "country_codes_2_names"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "pd.to_pickle(country_codes_2_names, \"data/clean_country_code_map.pkl\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Country names to codes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "country_names_2_codes = json.load(open(\"data/country_name_2_code_map.json\", \"r\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'afghanistan': 'AF',\n",
       " 'albania': 'AL',\n",
       " 'algeria': 'DZ',\n",
       " 'american samoa': 'AS',\n",
       " 'andorra': 'AD',\n",
       " 'angola': 'AO',\n",
       " 'antigua & barbuda': 'AG',\n",
       " 'argentina': 'AR',\n",
       " 'armenia': 'AM',\n",
       " 'aruba': 'AW',\n",
       " 'australia': 'AU',\n",
       " 'austria': 'AT',\n",
       " 'azerbaijan': 'AZ',\n",
       " 'bahamas': 'BS',\n",
       " 'bahrain': 'BH',\n",
       " 'bangladesh': 'BD',\n",
       " 'barbados': 'BB',\n",
       " 'belarus': 'BY',\n",
       " 'belgium': 'BE',\n",
       " 'belize': 'BZ',\n",
       " 'benin': 'BJ',\n",
       " 'bermuda': 'BM',\n",
       " 'bhutan': 'BT',\n",
       " 'bolivia': 'BO',\n",
       " 'bosnia': 'BA',\n",
       " 'botswana': 'BW',\n",
       " 'brazil': 'BR',\n",
       " 'british virgin islands': 'VG',\n",
       " 'brunei': 'BN',\n",
       " 'bulgaria': 'BG',\n",
       " 'burundi': 'BI',\n",
       " 'cambodia': 'KH',\n",
       " 'cameroon': 'CM',\n",
       " 'canada': 'CA',\n",
       " 'cayman islands': 'KY',\n",
       " 'central african republic': 'CF',\n",
       " 'channel islands': 'CHANNEL ISLANDS',\n",
       " 'chile': 'CL',\n",
       " 'china': 'CN',\n",
       " 'colombia': 'CO',\n",
       " 'congo - brazzaville': 'CG',\n",
       " 'congo - kinshasa': 'CD',\n",
       " 'cook islands': 'CK',\n",
       " 'costa rica': 'CR',\n",
       " 'croatia': 'HR',\n",
       " 'cuba': 'CU',\n",
       " 'cyprus': 'CY',\n",
       " 'czechia': 'CZ',\n",
       " 'cì«te d\\x89ûªivoire': 'CI',\n",
       " 'denmark': 'DK',\n",
       " 'djibouti': 'DJ',\n",
       " 'dominica': 'DM',\n",
       " 'dominican republic': 'DO',\n",
       " 'dq': 'DQ',\n",
       " 'ecuador': 'EC',\n",
       " 'egypt': 'EG',\n",
       " 'el salvador': 'SV',\n",
       " 'england': 'GB',\n",
       " 'england & wales': 'GB',\n",
       " 'england and wales': 'GB',\n",
       " 'eritrea': 'ER',\n",
       " 'estonia': 'EE',\n",
       " 'ethiopia': 'ET',\n",
       " 'fiji': 'FJ',\n",
       " 'finland': 'FI',\n",
       " 'france': 'FR',\n",
       " 'french guiana': 'GF',\n",
       " 'gabon': 'GA',\n",
       " 'gambia': 'GM',\n",
       " 'georgia': 'GE',\n",
       " 'germany': 'DE',\n",
       " 'ghana': 'GH',\n",
       " 'gibraltar': 'GI',\n",
       " 'great britain': 'GB',\n",
       " 'greece': 'GR',\n",
       " 'grenada': 'GD',\n",
       " 'guadeloupe': 'GP',\n",
       " 'guatemala': 'GT',\n",
       " 'guernsey': 'GG',\n",
       " 'guinea': 'GN',\n",
       " 'guinea-bissau': 'GW',\n",
       " 'guyana': 'GY',\n",
       " 'haiti': 'HT',\n",
       " 'honduras': 'HN',\n",
       " 'hong kong': 'HK',\n",
       " 'hungary': 'HU',\n",
       " 'iceland': 'IS',\n",
       " 'india': 'IN',\n",
       " 'indonesia': 'ID',\n",
       " 'iran': 'IR',\n",
       " 'iraq': 'IQ',\n",
       " 'ireland': 'IE',\n",
       " 'isle of man': 'IM',\n",
       " 'israel': 'IL',\n",
       " 'italy': 'IT',\n",
       " 'jamaica': 'JM',\n",
       " 'japan': 'JP',\n",
       " 'jersey': 'JE',\n",
       " 'jordan': 'JO',\n",
       " 'kazakhstan': 'KZ',\n",
       " 'kenya': 'KE',\n",
       " 'kiribati': 'KI',\n",
       " 'kosovo': 'XK',\n",
       " 'kuwait': 'KW',\n",
       " 'kyrgyzstan': 'KG',\n",
       " 'latvia': 'LV',\n",
       " 'lebanon': 'LB',\n",
       " 'lesotho': 'LS',\n",
       " 'liberia': 'LR',\n",
       " 'libya': 'LY',\n",
       " 'liechtenstein': 'LI',\n",
       " 'lithuania': 'LT',\n",
       " 'luxembourg': 'LU',\n",
       " 'macau': 'MO',\n",
       " 'macedonia': 'MK',\n",
       " 'madagascar': 'MG',\n",
       " 'malawi': 'MW',\n",
       " 'malaysia': 'MY',\n",
       " 'maldives': 'MV',\n",
       " 'malta': 'MT',\n",
       " 'mauritania': 'MR',\n",
       " 'mauritius': 'MU',\n",
       " 'mexico': 'MX',\n",
       " 'moldova': 'MD',\n",
       " 'mongolia': 'MN',\n",
       " 'montenegro': 'ME',\n",
       " 'morocco': 'MA',\n",
       " 'mozambique': 'MZ',\n",
       " 'myanmar': 'MM',\n",
       " 'namibia': 'NA',\n",
       " 'nan': nan,\n",
       " 'nauru': 'NR',\n",
       " 'nepal': 'NP',\n",
       " 'netherlands': 'NL',\n",
       " 'new zealand': 'NZ',\n",
       " 'nicaragua': 'NI',\n",
       " 'niger': 'NE',\n",
       " 'nigeria': 'NG',\n",
       " 'north korea': 'KP',\n",
       " 'northern ireland': 'GB',\n",
       " 'norway': 'NO',\n",
       " 'oman': 'OM',\n",
       " 'pakistan': 'PK',\n",
       " 'palestine': 'PS',\n",
       " 'panama': 'PA',\n",
       " 'papua new guinea': 'PG',\n",
       " 'paraguay': 'PY',\n",
       " 'peru': 'PE',\n",
       " 'philippines': 'PH',\n",
       " 'poland': 'PL',\n",
       " 'portugal': 'PT',\n",
       " 'puerto rico': 'PR',\n",
       " 'qatar': 'QA',\n",
       " 'republic of ghana': 'GH',\n",
       " 'romania': 'RO',\n",
       " 'russia': 'RU',\n",
       " 'rwanda': 'RW',\n",
       " 'san marino': 'SM',\n",
       " 'saudi arabia': 'SA',\n",
       " 'scotland': 'GB',\n",
       " 'scotland uk': 'GB',\n",
       " 'scotland united kingdom': 'GB',\n",
       " 'scotland, uk': 'GB',\n",
       " 'senegal': 'SN',\n",
       " 'serbia': 'RS',\n",
       " 'seychelles': 'SC',\n",
       " 'sierra leone': 'SL',\n",
       " 'singapore': 'SG',\n",
       " 'slovakia': 'SK',\n",
       " 'slovenia': 'SI',\n",
       " 'somalia': 'SO',\n",
       " 'south africa': 'ZA',\n",
       " 'south korea': 'KR',\n",
       " 'spain': 'ES',\n",
       " 'sri lanka': 'LK',\n",
       " 'st. kitts & nevis': 'KN',\n",
       " 'st. lucia': 'LC',\n",
       " 'st. vincent & grenadines': 'VC',\n",
       " 'sudan': 'SD',\n",
       " 'swaziland': 'SZ',\n",
       " 'sweden': 'SE',\n",
       " 'switzerland': 'CH',\n",
       " 'syria': 'SY',\n",
       " 'sì£o tomì© & prì?ncipe': 'ST',\n",
       " 'taiwan': 'TW',\n",
       " 'tajikistan': 'TJ',\n",
       " 'tanzania': 'TZ',\n",
       " 'thailand': 'TH',\n",
       " 'timor-leste': 'TL',\n",
       " 'togo': 'TG',\n",
       " 'tonga': 'TO',\n",
       " 'trinidad & tobago': 'TT',\n",
       " 'tunisia': 'TN',\n",
       " 'turkey': 'TR',\n",
       " 'turkmenistan': 'TM',\n",
       " 'uganda': 'UG',\n",
       " 'uk': 'GB',\n",
       " 'ukraine': 'UA',\n",
       " 'united arab emirates': 'AE',\n",
       " 'united kingdom': 'GB',\n",
       " 'united states': 'US',\n",
       " 'united states of america': 'US',\n",
       " 'uruguay': 'UY',\n",
       " 'us': 'US',\n",
       " 'usa': 'US',\n",
       " 'uzbekistan': 'UZ',\n",
       " 'vanuatu': 'VU',\n",
       " 'venezuela': 'VE',\n",
       " 'vietnam': 'VN',\n",
       " 'wales': 'GB',\n",
       " 'yemen': 'YE',\n",
       " 'zambia': 'ZM',\n",
       " 'zimbabwe': 'ZW',\n",
       " 'ìéland islands': 'AX'}"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "country_names_2_codes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "pd.to_pickle(country_names_2_codes, \"data/combined_country_map.pkl\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Nationality"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "nationality_2_codes = json.load(open(\"data/nationality_map.json\", \"r\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'british': 'GB',\n",
       " '(blank)': 'DQ',\n",
       " 'english': 'GB',\n",
       " 'irish': 'IE',\n",
       " 'polish': 'PL',\n",
       " 'indian': 'IN',\n",
       " 'chinese': 'CN',\n",
       " 'uk': 'GB',\n",
       " 'italian': 'IT',\n",
       " 'german': 'DE',\n",
       " 'romanian': 'RO',\n",
       " 'french': 'FR',\n",
       " 'pakistani': 'PK',\n",
       " 'scottish': 'GB',\n",
       " 'australian': 'AU',\n",
       " 'american': 'US',\n",
       " 'nigerian': 'NG',\n",
       " 'bulgarian': 'BG',\n",
       " 'spanish': 'ES',\n",
       " 'welsh': 'GB',\n",
       " 'united kingdom': 'GB',\n",
       " 'dutch': 'NL',\n",
       " 'lithuanian': 'LT',\n",
       " 'south african': 'ZA',\n",
       " 'swedish': 'SE',\n",
       " 'hungarian': 'HU',\n",
       " 'greek': 'GR',\n",
       " 'norwegian': 'NO',\n",
       " 'zimbabwean': 'ZW',\n",
       " 'portuguese': 'PT',\n",
       " 'new zealander': 'NZ',\n",
       " 'canadian': 'CA',\n",
       " 'turkish': 'TR',\n",
       " 'northern irish': 'GB',\n",
       " 'russian': 'RU',\n",
       " 'belgian': 'BE',\n",
       " 'danish': 'DK',\n",
       " 'malaysian': 'MY',\n",
       " 'bangladeshi': 'BD',\n",
       " 'austrian': 'AT',\n",
       " 'latvian': 'LV',\n",
       " 'usa': 'US',\n",
       " 'czech': 'CZ',\n",
       " 'swiss': 'CH',\n",
       " 'british citizen': 'GB',\n",
       " 'iranian': 'IR',\n",
       " 'ghanaian': 'GH',\n",
       " 'britsh': 'GB',\n",
       " 'ukrainian': 'UA',\n",
       " 'brazilian': 'BR',\n",
       " 'sri lankan': 'LK',\n",
       " 'japanese': 'JP',\n",
       " 'israeli': 'IL',\n",
       " 'slovak': 'SK',\n",
       " 'cypriot': 'CY',\n",
       " 'bristish': 'GB',\n",
       " 'united states': 'US',\n",
       " 'jamaican': 'JM',\n",
       " 'new zealand': 'NZ',\n",
       " 'egyptian': 'EG',\n",
       " 'kenyan': 'KE',\n",
       " 'brittish': 'GB',\n",
       " 'china': 'CN',\n",
       " 'finnish': 'FI',\n",
       " 'netherlands': 'NL',\n",
       " 'thai': 'TH',\n",
       " 'albanian': 'AL',\n",
       " 'singaporean': 'SG',\n",
       " 'nepalese': 'NP',\n",
       " 'romania': 'RO',\n",
       " 'estonian': 'EE',\n",
       " 'iraqi': 'IQ',\n",
       " 'croatian': 'HR',\n",
       " 'slovakian': 'SK',\n",
       " 'pakistan': 'PK',\n",
       " 'mexican': 'MX',\n",
       " 'south korean': 'KR',\n",
       " 'filipino': 'PH',\n",
       " 'nigeria': 'NG',\n",
       " 'maltese': 'MT',\n",
       " 'mauritian': 'MR',\n",
       " 'lebanese': 'LB',\n",
       " 'syrian': 'SY',\n",
       " 'uk citizen': 'GB',\n",
       " 'brtish': 'GB',\n",
       " 'afghan': 'AF',\n",
       " 'slovenian': 'SI',\n",
       " 'jamaica': 'JM',\n",
       " 'taiwanese': 'TW',\n",
       " 'united states of america': 'US',\n",
       " 'ukraine': 'UA',\n",
       " 'vietnamese': 'VN',\n",
       " 'srilankan': 'LK',\n",
       " 'britsih': 'GB',\n",
       " 'czech republic': 'CZ',\n",
       " 'portugese': 'PT',\n",
       " 'ugandan': 'UG',\n",
       " 'gb': 'GB',\n",
       " 'england': 'GB',\n",
       " 'india': 'IN',\n",
       " 'zambian': 'ZM',\n",
       " 'colombian': 'CO',\n",
       " 'british virgin islander': 'VG',\n",
       " 'france': 'FR',\n",
       " 'belgium': 'BE',\n",
       " 'italy': 'IT',\n",
       " 'jordanian': 'JO',\n",
       " 'saudi arabian': 'SA',\n",
       " 'spain': 'ES',\n",
       " 'venezuelan': 'VE',\n",
       " 'algerian': 'DZ',\n",
       " 'tanzanian': 'TZ',\n",
       " 'poland': 'PL',\n",
       " 'us': 'US',\n",
       " 'cameroonian': 'CM',\n",
       " 'serbian': 'RS',\n",
       " 'ireland': 'IE',\n",
       " 'malawian': 'MW',\n",
       " 'bulgaria': 'BG',\n",
       " 'germany': 'DE',\n",
       " 'libyan': 'LY',\n",
       " 'icelandic': 'IS',\n",
       " 'kuwaiti': 'KW',\n",
       " 'sierra leonean': 'SL',\n",
       " 'sudanese': 'SD',\n",
       " 'argentine': 'AR',\n",
       " 'bangladesh': 'BD',\n",
       " 'georgian': 'GE',\n",
       " 'moroccan': 'MA',\n",
       " 'philippine': 'PH',\n",
       " 'us citizen': 'US',\n",
       " 'white british': 'GB',\n",
       " 'belarusian': 'BY',\n",
       " 'ukranian': 'UA',\n",
       " 'lithuania': 'LT',\n",
       " 'somali': 'SO',\n",
       " 'hong kong': 'HK',\n",
       " 'moldovan': 'MD',\n",
       " 'zimbabwe': 'ZW',\n",
       " 'brirish': 'GB',\n",
       " 'tunisian': 'TN',\n",
       " 'korean': 'KR',\n",
       " 'portugal': 'PT',\n",
       " 'uk british': 'GB',\n",
       " 'australia': 'AU',\n",
       " 'bitish': 'GB',\n",
       " 'britiish': 'GB',\n",
       " 'u.k.': 'GB',\n",
       " 'great britain': 'GB',\n",
       " 'indonesian': 'ID',\n",
       " 'malaysia': 'MY',\n",
       " 'n irish': 'GB',\n",
       " 'azerbaijani': 'AZ',\n",
       " 'birtish': 'GB',\n",
       " 'brithish': 'GB',\n",
       " 'chilean': 'CL',\n",
       " 'gambian': 'GM',\n",
       " 'trinidad and tobago': 'TT',\n",
       " 'trinidadian': 'TT',\n",
       " 'slovakia': 'SK',\n",
       " 'sweden': 'SE',\n",
       " 'uzbek': 'UZ',\n",
       " 'armenian': 'AM',\n",
       " 'briish': 'GB',\n",
       " 'kosovan': 'XK',\n",
       " 'palestinian': 'PS',\n",
       " 'austria': 'AT',\n",
       " 'citizen of seychelles': 'SC',\n",
       " 'greece': 'GR',\n",
       " 'peruvian': 'PE',\n",
       " 'brit': 'GB',\n",
       " 'brtitish': 'GB',\n",
       " 'deutsch': 'DE',\n",
       " 'gbr': 'GB',\n",
       " 'netherland': 'NL',\n",
       " 'switzerland': 'CH',\n",
       " 'afghanistan': 'AF',\n",
       " 'ghanian': 'GH',\n",
       " 'latvia': 'LV',\n",
       " 'uzbekistan': 'UZ',\n",
       " 'saudi': 'SA',\n",
       " 'congolese': 'CD',\n",
       " 'kazakh': 'KZ',\n",
       " 'luxembourger': 'LU',\n",
       " 'btitish': 'GB',\n",
       " 'canada': 'CA',\n",
       " 'hellenic': 'GR',\n",
       " 'ivorian': 'CI',\n",
       " 'argentinian': 'AR',\n",
       " 'barbadian': 'BB',\n",
       " 'bri': 'GB',\n",
       " 'finland': 'FI',\n",
       " 'hungary': 'HU',\n",
       " 'united arab emirates': 'AE',\n",
       " 'briitish': 'GB',\n",
       " 'british/english': 'GB',\n",
       " 'nepali': 'NP',\n",
       " 'nigerien': 'NE',\n",
       " 'turkey': 'TR',\n",
       " 'britiah': 'GB',\n",
       " 'britis': 'GB',\n",
       " 'dominican': 'DO',\n",
       " 'kazakhstan': 'KZ',\n",
       " 'british english': 'GB',\n",
       " 'cyprus': 'CY',\n",
       " 'russian federation': 'RU',\n",
       " 'singapore': 'SG',\n",
       " 'south africa': 'ZA',\n",
       " 'bahraini': 'BH',\n",
       " 'biritish': 'GB',\n",
       " 'costa rican': 'CR',\n",
       " 'eritrean': 'ER',\n",
       " 'uk national': 'GB',\n",
       " 'vincentian': 'VC',\n",
       " 'brititsh': 'GB',\n",
       " 'icelander': 'IS',\n",
       " 'macedonian': 'MK',\n",
       " 'myanmar': 'MM',\n",
       " 'n. irish': 'GB',\n",
       " 'panamanian': 'PA',\n",
       " 'philippino': 'PH',\n",
       " 'sri lanka': 'LK',\n",
       " 'taiwan': 'TW',\n",
       " 'briitsh': 'GB',\n",
       " 'ghana': 'GH',\n",
       " 'iran': 'IR',\n",
       " 'n.irish': 'IR',\n",
       " 'philippines': 'PH',\n",
       " 'serbia and montenegro': 'RS',\n",
       " 'south korea': 'KR',\n",
       " 'brisith': 'GB',\n",
       " 'other': 'DQ',\n",
       " 'rumanian': 'RO',\n",
       " 'bosnian': 'BA',\n",
       " 'denmark': 'DK',\n",
       " 'iraq': 'IQ',\n",
       " 'kosovo': 'XK',\n",
       " 'madagascan': 'MG',\n",
       " 'qatari': 'QA',\n",
       " 'republic of china': 'CN',\n",
       " 'romainian': 'RO',\n",
       " 'yemeni': 'YE',\n",
       " 'belarus': 'BY',\n",
       " 'botswana': 'BW',\n",
       " 'brirtish': 'GB',\n",
       " 'britih': 'GB',\n",
       " 'british.': 'GB',\n",
       " 'nationality unknown': 'DQ',\n",
       " 'fijian': 'FJ',\n",
       " 'guyanese': 'GY',\n",
       " 'liechtenstein': 'LI',\n",
       " 'namibian': 'nan',\n",
       " 'norway': 'NO',\n",
       " 'slovak republic': 'SK',\n",
       " 'somalia': 'SO',\n",
       " 'st kitts and nevis': 'KN',\n",
       " 'afghani': 'AF',\n",
       " 'angolan': 'AO',\n",
       " 'argentina': 'AR',\n",
       " 'botswanan': 'BW',\n",
       " 'britisg': 'GB',\n",
       " 'ethiopian': 'ET',\n",
       " 'guinean': 'GN',\n",
       " 'israel': 'IL',\n",
       " 'italia': 'IT',\n",
       " 'liberian': 'LY',\n",
       " 'mongolian': 'MN',\n",
       " 'motswana': 'BW',\n",
       " 'republic of korea': 'KR',\n",
       " 'russia': 'RU',\n",
       " 'wales': 'GB',\n",
       " 'afgan': 'AF',\n",
       " 'austrailian': 'AU',\n",
       " 'biritsh': 'GB',\n",
       " 'britain': 'GB',\n",
       " 'cameroon': 'CM',\n",
       " 'cornish': 'GB',\n",
       " 'great british': 'GB',\n",
       " 'kuwait': 'KW',\n",
       " 'roumanian': 'RO',\n",
       " 'scots': 'GB',\n",
       " 'albania': 'AL',\n",
       " 'bahamian': 'BS',\n",
       " 'brisitsh': 'GB',\n",
       " 'britich': 'GB',\n",
       " 'britisch': 'GB',\n",
       " 'britrish': 'GB',\n",
       " 'emirati': 'AE',\n",
       " 'estonia': 'EE',\n",
       " 'mauritanian': 'MR',\n",
       " 'nan': 'DQ',\n",
       " 'saudi arabia': 'SA',\n",
       " 'scotish': 'GB',\n",
       " 'seychelles': 'SC',\n",
       " 'st. kitts and nevis': 'KN',\n",
       " 'swazi': 'SZ',\n",
       " 'syria': 'SY',\n",
       " 'turkmen': 'TM',\n",
       " 'u.s.a.': 'US',\n",
       " 'uruguayan': 'UY',\n",
       " 'vietnam': 'VN',\n",
       " 'argentinean': 'AR',\n",
       " 'brasilian': 'BR',\n",
       " 'citizen of mauritius': 'MU',\n",
       " 'eire': 'IE',\n",
       " 'eng': 'GB',\n",
       " 'hong kong sar': 'HK',\n",
       " 'kenya': 'KE',\n",
       " 'luxembourg': 'LU',\n",
       " 'mauritius': 'MU',\n",
       " 'nederlands': 'NL',\n",
       " 'northern ireland': 'GB',\n",
       " 'republic of ireland': 'IE',\n",
       " 'somalian': 'SO',\n",
       " 'belguim': 'BE',\n",
       " 'belizean': 'BZ',\n",
       " 'brazil': 'BR',\n",
       " 'british uk': 'GB',\n",
       " 'britishh': 'GB',\n",
       " 'brtitsh': 'GB',\n",
       " 'cuban': 'CU',\n",
       " 'cymro': 'GB',\n",
       " 'democratic republic of the congo': 'CD',\n",
       " 'ecuadorian': 'EC',\n",
       " 'egypt': 'EG',\n",
       " 'isreali': 'IL',\n",
       " 'moldovian': 'MD',\n",
       " 'nationality': 'DQ',\n",
       " 'omani': 'OM',\n",
       " 'portuguesa': 'PT',\n",
       " 'scotland': 'GB',\n",
       " 'senegalese': 'SN',\n",
       " 'spainish': 'ES',\n",
       " 'sudan': 'SD',\n",
       " 'the netherlands': 'NL',\n",
       " 'uae': 'AE',\n",
       " 'uganda': 'UG',\n",
       " 'united kingdon': 'GB',\n",
       " 'uzbekistani': 'UZ',\n",
       " 'bolivian': 'BO',\n",
       " 'britihs': 'GB',\n",
       " 'british national': 'GB',\n",
       " 'british national (overseas)': 'GB',\n",
       " 'british national overseas': 'GB',\n",
       " 'british subject': 'GB',\n",
       " 'brotish': 'GB',\n",
       " 'brtiish': 'GB',\n",
       " 'columbian': 'CO',\n",
       " 'costa rica': 'CR',\n",
       " 'ecuadorean': 'EC',\n",
       " 'engish': 'GB',\n",
       " 'englsih': 'GB',\n",
       " 'guernsey': 'GG',\n",
       " 'holland': 'NL',\n",
       " 'italien': 'IT',\n",
       " 'japan': 'JP',\n",
       " 'kurdish': 'TR',\n",
       " 'liberia': 'LR',\n",
       " 'moldavian': 'MD',\n",
       " 'morocco': 'MA',\n",
       " 'saint lucian': 'LC',\n",
       " 'slovenia': 'SI',\n",
       " 'thailand': 'TH',\n",
       " 'turkmenistan': 'TM',\n",
       " 'afganistan': 'AF',\n",
       " 'belorussian': 'BY',\n",
       " 'brfitish': 'GB',\n",
       " 'british asian': 'GB',\n",
       " 'britisih': 'GB',\n",
       " 'britush': 'GB',\n",
       " 'croat': 'HR',\n",
       " 'cymraes': 'GB',\n",
       " 'finish': 'GB',\n",
       " 'ghanain': 'GH',\n",
       " 'kosova': 'XK',\n",
       " 'kyrgyz': 'KG',\n",
       " 'luxembourgish': 'LU',\n",
       " 'maldivian': 'MV',\n",
       " 'moldova': 'MD',\n",
       " 'nepal': 'NP',\n",
       " 'phillipino': 'PH',\n",
       " 'portugeuse': 'PT',\n",
       " 'potuguese': 'PT',\n",
       " 'romana': 'RO',\n",
       " 'rwandan': 'RW',\n",
       " 'seychellois': 'SC',\n",
       " 'swede': 'SE',\n",
       " 'tajik': 'TH',\n",
       " 'unknown': 'DQ',\n",
       " 'algeria': 'DZ',\n",
       " 'b ritish': 'GB',\n",
       " 'beninese': 'BJ',\n",
       " 'bhutanese': 'BT',\n",
       " 'black british': 'GB',\n",
       " 'brisish': 'GB',\n",
       " 'brit/eng': 'GB',\n",
       " 'briti': 'GB',\n",
       " 'british - english': 'GB',\n",
       " 'british citizenship': 'GB',\n",
       " 'british cornish': 'GB',\n",
       " 'britisj': 'GB',\n",
       " 'britisn': 'GB',\n",
       " 'brtisih': 'GB',\n",
       " 'burmese': 'MM',\n",
       " 'cymro / cymraes': 'GB',\n",
       " 'czechoslovakian': 'CZ',\n",
       " 'egy': 'EG',\n",
       " 'englis': 'GB',\n",
       " 'espanola': 'ES',\n",
       " 'francaise': 'FR',\n",
       " 'guatemalan': 'GT',\n",
       " 'irani': 'IR',\n",
       " 'jamacian': 'JM',\n",
       " 'jordan': 'JO',\n",
       " 'malasian': 'MY',\n",
       " 'african': 'DQ',\n",
       " 'nederland': 'NL',\n",
       " 'nederlandse': 'NL',\n",
       " 'new zelander': 'NZ',\n",
       " 'nigerain': 'NG',\n",
       " 'paraguayan': 'PY',\n",
       " 'qatar': 'QA',\n",
       " 'singapore citizen': 'SG',\n",
       " 'slovene': 'SI',\n",
       " 'srilanka': 'LK',\n",
       " 'togolese': 'CD',\n",
       " 'tunesian': 'TN',\n",
       " 'turksih': 'TM',\n",
       " 'u k': 'GB',\n",
       " 'u.kingdom': 'GB',\n",
       " 'usa/uk': 'SA',\n",
       " 'welsh british': 'GB',\n",
       " 'west indian': 'IN',\n",
       " 'afghanistani': 'AF',\n",
       " 'american - usa': 'US',\n",
       " 'austrain': 'AU',\n",
       " 'azerbaijan': 'AZ',\n",
       " 'bahrain': 'BH',\n",
       " 'bosnia and herzegovinian': 'BA',\n",
       " 'briritsh': 'GB',\n",
       " 'bristol': 'GB',\n",
       " 'brithis': 'GB',\n",
       " 'brithsh': 'GB',\n",
       " 'britiash': 'GB',\n",
       " 'britidh': 'GB',\n",
       " 'britishi': 'GB',\n",
       " 'bruneian': 'BN',\n",
       " 'burundi': 'BI',\n",
       " 'cambodian': 'KH',\n",
       " 'central african republic': 'CF',\n",
       " 'chines': 'CN',\n",
       " 'chineses': 'CN',\n",
       " 'croatia': 'HR',\n",
       " 'croation': 'HR',\n",
       " 'cymreig': 'GB',\n",
       " 'dominican republic': 'DO',\n",
       " 'ecuador': 'EC',\n",
       " 'emaratis': 'AE',\n",
       " 'emirian': 'IE',\n",
       " 'english / british': 'GB',\n",
       " 'european': 'DQ',\n",
       " 'fiji': 'FJ',\n",
       " 'gabonese': 'GA',\n",
       " 'honduran': 'HN',\n",
       " 'hong kong chinese': 'HK',\n",
       " 'hong kong, china': 'HK',\n",
       " 'hongkong': 'HK',\n",
       " 'indain': 'IN',\n",
       " 'irish (roi)': 'IE',\n",
       " 'lativan': 'LV',\n",
       " 'lebanon': 'LB',\n",
       " 'lesotho': 'LS',\n",
       " 'libya': 'LY',\n",
       " 'manx': 'IM',\n",
       " 'montenegro': 'ME',\n",
       " 'morrocan': 'MA',\n",
       " 'new zealand citizen': 'NZ',\n",
       " 'newzealand': 'NZ',\n",
       " 'nicaraguan': 'NI',\n",
       " 'nothern irish': 'GB',\n",
       " 'phillipines': 'PH',\n",
       " 'republic of belarus': 'BY',\n",
       " 'roman': 'RO',\n",
       " 'romenian': 'RO',\n",
       " 'serbia': 'RS',\n",
       " 'sierra leone': 'SL',\n",
       " 'slovenija': 'SI',\n",
       " 'southafrican': 'ZA',\n",
       " 'spaniard': 'ES',\n",
       " 'st lucian': 'LC',\n",
       " 'sudani': 'SD',\n",
       " 'sweedish': 'SE',\n",
       " 'tajikistan': 'TJ',\n",
       " 'turk': 'TR',\n",
       " 'u k citizen': 'GB',\n",
       " 'u.k': 'GB',\n",
       " 'u.s.': 'US',\n",
       " 'ugandian': 'UG',\n",
       " 'uk scottish': 'GB',\n",
       " 'united kindom': 'GB',\n",
       " 'united kingdom national': 'GB',\n",
       " 'african american': 'US',\n",
       " 'amercian': 'US',\n",
       " 'america': 'US',\n",
       " 'anglo-italian': 'IT',\n",
       " 'arabic': 'DQ',\n",
       " 'austrialian': 'AU',\n",
       " 'bangaladeshi': 'BD',\n",
       " 'bangledeshi': 'BD',\n",
       " 'beitish': 'GB',\n",
       " 'belge': 'BE',\n",
       " 'belgiam': 'BE',\n",
       " 'belgum': 'BE',\n",
       " 'belize': 'BZ',\n",
       " 'bermudian': 'BM',\n",
       " 'bolivia': 'BO',\n",
       " 'brazillian': 'BR',\n",
       " 'breitish': 'GB',\n",
       " 'brith': 'GB',\n",
       " 'british-': 'GB',\n",
       " 'british / english': 'GB',\n",
       " 'british caribbean': 'GB',\n",
       " 'british citizens': 'GB',\n",
       " 'british national oversea': 'GB',\n",
       " 'british overseas': 'GB',\n",
       " 'british sikh': 'GB',\n",
       " 'british/african': 'GB',\n",
       " 'british/welsh': 'GB',\n",
       " 'britisjh': 'GB',\n",
       " 'britisk': 'GB',\n",
       " 'britisth': 'GB',\n",
       " 'britiswh': 'GB',\n",
       " 'britosh': 'GB',\n",
       " 'brritish': 'GB',\n",
       " 'brutish': 'GB',\n",
       " 'btritish': 'GB',\n",
       " 'candian': 'CA',\n",
       " 'chinese (prc)': 'CN',\n",
       " 'chinses': 'CN',\n",
       " 'chinsese': 'CN',\n",
       " 'colombia': 'CO',\n",
       " 'cuba': 'CU',\n",
       " 'czeck republic': 'CZ',\n",
       " 'czekish': 'CZ',\n",
       " 'dane': 'DK',\n",
       " 'danmark': 'DK',\n",
       " 'deutch': 'NL',\n",
       " 'arabian': 'DQ',\n",
       " 'egyption': 'EG',\n",
       " 'engkish': 'GB',\n",
       " 'engliah': 'GB',\n",
       " 'english british': 'GB',\n",
       " 'english/british': 'GB',\n",
       " 'ethiopia': 'ET',\n",
       " 'flipino': 'PH',\n",
       " 'franch': 'FR',\n",
       " 'frech': 'FR',\n",
       " 'gambia': 'GM',\n",
       " 'gibraltarian': 'GI',\n",
       " 'great britian': 'GB',\n",
       " 'hkg': 'HK',\n",
       " 'hungaryan': 'HU',\n",
       " 'indonesia': 'ID',\n",
       " 'irish republic': 'IE',\n",
       " 'irleand': 'IR',\n",
       " 'israili': 'IL',\n",
       " 'ivoirian': 'CI',\n",
       " 'ivory coast': 'CI',\n",
       " 'japenese': 'JP',\n",
       " 'jordinian': 'JO',\n",
       " 'kazakhstani': 'KZ',\n",
       " 'korea': 'KR',\n",
       " 'kosovon': 'XK',\n",
       " 'kyrgyzstan': 'KG',\n",
       " 'latvijas': 'LV',\n",
       " 'libian': 'LY',\n",
       " 'liechtensteiner': 'LI',\n",
       " 'lituanian': 'LT',\n",
       " 'luxembourgian': 'LU',\n",
       " 'madagascar': 'MG',\n",
       " 'malawi': 'MW',\n",
       " 'malian': 'MT',\n",
       " 'mexico': 'MX',\n",
       " 'monegasque': 'MN',\n",
       " 'montenegran': 'ME',\n",
       " 'mozambique': 'MZ',\n",
       " 'n. ireland': 'IE',\n",
       " 'n.ireland': 'GB',\n",
       " 'nagerian': 'NG',\n",
       " 'napalese': 'NP',\n",
       " 'nauruan': 'NR',\n",
       " 'netherlander': 'NL',\n",
       " 'north korean': 'KP',\n",
       " 'norwegain': 'NO',\n",
       " 'norweigan': 'NO',\n",
       " 'nz': 'NZ',\n",
       " 'pakinstain': 'PK',\n",
       " 'paksitani': 'PK',\n",
       " 'palestine': 'PS',\n",
       " 'philipines': 'PH',\n",
       " 'philipino': 'PH',\n",
       " 'portguese': 'PT',\n",
       " 'portugues': 'PT',\n",
       " 'channel islander': 'DQ',\n",
       " 'qatri': 'QA',\n",
       " 'republic of cyprus': 'CY',\n",
       " 'republic of india': 'IN',\n",
       " 'ritish': 'GB',\n",
       " 'rmanian': 'RO',\n",
       " 'romanians': 'RO',\n",
       " 'romanien': 'RO',\n",
       " 'saint vincent and th': 'VC',\n",
       " 'salvadorian': 'SV',\n",
       " 'singapore national': 'SG',\n",
       " 'solvakian': 'SK',\n",
       " 'south-african': 'ZA',\n",
       " 'spannish': 'ES',\n",
       " 'sri laknan': 'LK',\n",
       " 'sri-lankan': 'LK',\n",
       " 'st kitts & nevis': 'KN',\n",
       " 'suisse': 'CH',\n",
       " 'swedis': 'SE',\n",
       " 'swidish': 'SE',\n",
       " 'togo': 'TG',\n",
       " 'kashmiri': 'DQ',\n",
       " 'u s': 'US',\n",
       " 'u. k.': 'GB',\n",
       " 'ucrainian': 'UA',\n",
       " 'uk and swiss': 'CH',\n",
       " 'uk english': 'GB',\n",
       " 'uk/gb': 'CU',\n",
       " 'ukrainean': 'UA',\n",
       " 'united states citizen': 'US',\n",
       " 'untied kingdom': 'GB',\n",
       " 'uruguay': 'UY',\n",
       " 'venezuela': 'VE',\n",
       " 'welsh/british': 'GB',\n",
       " 'yemen': 'YE',\n",
       " 'yemenese': 'YE',\n",
       " 'yugoslavia': 'DQ',\n",
       " 'yugoslavian': 'DQ',\n",
       " 'zambia': 'ZM',\n",
       " 'zimbabawean': 'ZW',\n",
       " 'zimbabean': 'ZW',\n",
       " 'zimbabwian': 'ZW',\n",
       " 'zimbawean': 'ZW',\n",
       " 'mixed race - white / black afro caribbean': 'DQ',\n",
       " 'moorish': 'DQ',\n",
       " '.british': 'GB',\n",
       " 'nubian': 'DQ',\n",
       " 'afgani': 'AF',\n",
       " 'afghansitan': 'AF',\n",
       " 'albani': 'AL',\n",
       " 'albaninan': 'AL',\n",
       " 'americam': 'US',\n",
       " 'american (us)': 'US',\n",
       " 'american citizen': 'US',\n",
       " 'amrican': 'US',\n",
       " 'andorra': 'AD',\n",
       " 'andorran': 'AD',\n",
       " 'anglo/irish': 'IE',\n",
       " 'anglo/italian': 'IT',\n",
       " 'anglo-american': 'US',\n",
       " 'antigua and barbuda': 'AG',\n",
       " 'antiguan and barbudan': 'AG',\n",
       " 'director': 'DQ',\n",
       " 'arerbaijan': 'AZ',\n",
       " 'argentianian': 'AR',\n",
       " 'armemnian': 'AM',\n",
       " 'armenia': 'AM',\n",
       " 'asian british': 'GB',\n",
       " 'austalian': 'AU',\n",
       " 'austarlian': 'AU',\n",
       " 'austrailia': 'AU',\n",
       " 'australain': 'AU',\n",
       " 'australan': 'AU',\n",
       " 'australina': 'AU',\n",
       " 'australlian': 'AU',\n",
       " 'austriam': 'AT',\n",
       " 'austrian/american': 'AU',\n",
       " 'autralian': 'AU',\n",
       " 'awhite british': 'GB',\n",
       " 'bagladesh': 'BD',\n",
       " 'bagladeshi': 'BD',\n",
       " 'bahgladeshi': 'BD',\n",
       " 'balarus': 'BY',\n",
       " 'balinese': 'BJ',\n",
       " 'bangaladesh': 'BD',\n",
       " 'bangaldeshi': 'BD',\n",
       " 'bangla desh': 'BD',\n",
       " 'banglandesh': 'BD',\n",
       " 'banladesh': 'BD',\n",
       " 'barbados': 'BB',\n",
       " 'bartish': 'GB',\n",
       " 'batswana': 'BW',\n",
       " 'bejing': 'BJ',\n",
       " 'belarasian': 'BY',\n",
       " 'belarussian': 'BY',\n",
       " 'belg': 'BE',\n",
       " 'belgien': 'BE',\n",
       " 'belizian': 'BZ',\n",
       " 'belurus': 'BY',\n",
       " 'bermudan': 'BM',\n",
       " 'bfritish': 'GB',\n",
       " 'biitish': 'GB',\n",
       " 'birish': 'GB',\n",
       " 'birthish': 'GB',\n",
       " 'company director': 'DQ',\n",
       " 'birtsh': 'GB',\n",
       " 'bitish citizen': 'GB',\n",
       " 'bolgarian': 'BG',\n",
       " 'bolivan': 'BO',\n",
       " 'bosnia': 'BA',\n",
       " 'bosnia & herzegovinian': 'BA',\n",
       " 'bosnia and herzegovina': 'BA',\n",
       " 'bosnia and herzergov': 'BA',\n",
       " 'bosnian / herzegovinian': 'BA',\n",
       " 'br': 'BR',\n",
       " 'br5itish': 'GB',\n",
       " 'brasil': 'BR',\n",
       " 'brasilan': 'BR',\n",
       " 'brasileira': 'BR',\n",
       " 'braziian': 'BR',\n",
       " 'brazilean': 'BR',\n",
       " 'brazillan': 'BR',\n",
       " 'brirtsh': 'GB',\n",
       " 'brishish': 'GB',\n",
       " 'brisitish': 'GB',\n",
       " 'bristh': 'GB',\n",
       " 'bristiah': 'GB',\n",
       " 'bristih': 'GB',\n",
       " 'bristis': 'GB',\n",
       " 'bristish bangladeshi': 'GB',\n",
       " 'bristish citizen': 'GB',\n",
       " 'bristsh': 'GB',\n",
       " 'brit / english': 'GB',\n",
       " 'brit/scot': 'GB',\n",
       " 'brit6ish': 'GB',\n",
       " 'britash': 'GB',\n",
       " 'brithish english': 'GB',\n",
       " 'britinsh': 'GB',\n",
       " 'britiosh': 'GB',\n",
       " 'britisah': 'GB',\n",
       " 'britisb': 'GB',\n",
       " 'british - uk citizen': 'GB',\n",
       " 'british (bermudian)': 'GB',\n",
       " 'british (canada born)': 'GB',\n",
       " 'british (naturalised)': 'GB',\n",
       " 'british (scots)': 'GB',\n",
       " 'british (welsh)': 'GB',\n",
       " 'british / scottish': 'GB',\n",
       " 'british / welsh': 'GB',\n",
       " 'british /english': 'GB',\n",
       " 'british african': 'GB',\n",
       " 'british amercian': 'US',\n",
       " 'british bengali': 'GB',\n",
       " 'british citizenship/ukrainian': 'GB',\n",
       " 'british cityzen': 'GB',\n",
       " 'british citzen': 'GB',\n",
       " 'british european': 'GB',\n",
       " 'british norfolk': 'GB',\n",
       " 'british resident': 'GB',\n",
       " 'british scott': 'GB',\n",
       " 'british welsh': 'GB',\n",
       " 'british, english': 'GB',\n",
       " 'british,uk': 'GB',\n",
       " 'british/ english': 'GB',\n",
       " 'british/ eu national': 'GB',\n",
       " 'british/asian': 'GB',\n",
       " 'british/scottish': 'GB',\n",
       " 'british-american': 'GB',\n",
       " 'britishbritish': 'GB',\n",
       " 'britishcitizen': 'GB',\n",
       " 'britisht': 'GB',\n",
       " 'britishu': 'GB',\n",
       " 'british-united kingdom': 'GB',\n",
       " 'britiss': 'GB',\n",
       " 'britisy': 'GB',\n",
       " 'brititish': 'GB',\n",
       " 'briton': 'GB',\n",
       " 'brits': 'GB',\n",
       " 'britsh - english': 'GB',\n",
       " 'britshi': 'GB',\n",
       " 'britsish': 'GB',\n",
       " 'britsith': 'GB',\n",
       " 'brittiish': 'GB',\n",
       " 'brittsh': 'GB',\n",
       " 'brituish': 'GB',\n",
       " 'bruitish': 'GB',\n",
       " 'bruttish': 'GB',\n",
       " 'btittish': 'GB',\n",
       " 'btrish': 'GB',\n",
       " 'bugaria': 'BG',\n",
       " 'bulga': 'BG',\n",
       " 'bulgarien': 'BG',\n",
       " 'burma': 'MM',\n",
       " 'burundian': 'BI',\n",
       " 'cameronnian': 'CM',\n",
       " 'camerounian': 'CM',\n",
       " 'camerronian': 'CM',\n",
       " 'camoraian': 'CM',\n",
       " 'camreoon': 'CM',\n",
       " 'canadier': 'CA',\n",
       " 'candadian': 'CA',\n",
       " 'candanian': 'CA',\n",
       " 'caucasian british': 'GB',\n",
       " 'caymanian': 'KY',\n",
       " 'central african republic (car)': 'CF',\n",
       " 'manager': 'DQ',\n",
       " 'check': 'CZ',\n",
       " 'chile': 'CL',\n",
       " 'chin': 'CN',\n",
       " 'china (mainland)': 'CN',\n",
       " 'china prc': 'CN',\n",
       " 'china, p.r.': 'CN',\n",
       " 'chinese sar': 'CN',\n",
       " 'chiness': 'CN',\n",
       " 'chinesse': 'CN',\n",
       " 'chinise': 'CN',\n",
       " 'chnese': 'CN',\n",
       " 'citizen of muritius': 'MU',\n",
       " 'citizen of republic of cyprus': 'CY',\n",
       " 'citizen of trinidad and tobago': 'TT',\n",
       " 'doctor': 'DQ',\n",
       " 'commonwealth of domi': 'DO',\n",
       " 'congelese': 'CD',\n",
       " 'cook islander': 'CK',\n",
       " 'costarican': 'CR',\n",
       " 'costarrican': 'CR',\n",
       " 'cpriot': 'CY',\n",
       " 'crotian': 'HR',\n",
       " 'crypiot': 'CY',\n",
       " 'cymraeg': 'GB',\n",
       " 'cypriat': 'CY',\n",
       " 'cyprys': 'CY',\n",
       " 'czechoslakia': 'CZ',\n",
       " 'czechoslovakia': 'CZ',\n",
       " 'damascus': 'SY',\n",
       " 'democratic republic of congo': 'CD',\n",
       " 'denish': 'DK',\n",
       " 'djiboutian': 'DJ',\n",
       " 'dominica': 'DM',\n",
       " 'dominicano': 'DO',\n",
       " 'doutch': 'NL',\n",
       " 'durch': 'NL',\n",
       " 'dutch (netherlands)': 'NL',\n",
       " 'duth': 'NL',\n",
       " 'east timorese': 'TL',\n",
       " 'egyp': 'EG',\n",
       " 'ei': 'IE',\n",
       " 'el salvador': 'SV',\n",
       " 'emglish': 'GB',\n",
       " 'enghlish': 'GB',\n",
       " 'engilish': 'GB',\n",
       " 'engineer': 'GN',\n",
       " 'engl': 'GB',\n",
       " 'englaish': 'GB',\n",
       " 'englisg': 'GB',\n",
       " 'english - british': 'GB',\n",
       " 'english-british': 'GB',\n",
       " 'englisn': 'GB',\n",
       " 'englosh': 'GB',\n",
       " 'enlish': 'GB',\n",
       " 'estionian': 'EE',\n",
       " 'estonain': 'EE',\n",
       " 'estorian': 'EE',\n",
       " 'eu cech republic': 'CZ',\n",
       " 'european british': 'GB',\n",
       " 'eygiptian': 'EG',\n",
       " 'filipina': 'PH',\n",
       " 'filipino,': 'PH',\n",
       " 'filipno': 'PH',\n",
       " 'fillipino': 'PH',\n",
       " 'fillopino': 'PH',\n",
       " 'finn': 'FI',\n",
       " 'flemish': 'BE',\n",
       " 'fremch': 'FR',\n",
       " 'frenc': 'FR',\n",
       " 'frnech': 'FR',\n",
       " 'g b': 'GB',\n",
       " 'gamban': 'GA',\n",
       " 'gb citizen': 'GB',\n",
       " 'georgia': 'GE',\n",
       " 'georgien': 'GE',\n",
       " 'georgiev': 'GE',\n",
       " 'germ': 'DE',\n",
       " 'german national': 'DE',\n",
       " 'germna': 'DE',\n",
       " 'ghahanian': 'GH',\n",
       " 'ghananian': 'GH',\n",
       " 'ghanean': 'GH',\n",
       " 'ghanese': 'GH',\n",
       " 'great britain & usa': 'GB',\n",
       " 'greeck': 'GR',\n",
       " 'greek / hellenic': 'GR',\n",
       " 'guayanese': 'GF',\n",
       " 'guinea': 'GN',\n",
       " 'guinea bissau': 'GW',\n",
       " 'guinea conakry': 'GN',\n",
       " 'guinea-bissau': 'GW',\n",
       " 'guyana': 'GY',\n",
       " 'guyanan': 'GY',\n",
       " 'haitian citizen': 'HT',\n",
       " 'haungarian': 'HU',\n",
       " 'helenic greek': 'GR',\n",
       " 'hellenic (greek)': 'GR',\n",
       " 'hk': 'HK',\n",
       " 'hksar': 'EG',\n",
       " 'hong kong national': 'HK',\n",
       " 'hrvatsko': 'HR',\n",
       " 'hunagarian': 'HR',\n",
       " 'hunagrian': 'HR',\n",
       " 'hungairan': 'HU',\n",
       " 'hungerian': 'HU',\n",
       " 'hungry': 'HU',\n",
       " 'hyngarian': 'HU',\n",
       " 'iceland': 'IS',\n",
       " 'icleland': 'IS',\n",
       " 'i-kiribati': 'KI',\n",
       " \"i'm british\": 'GB',\n",
       " 'indean': 'IN',\n",
       " 'indian with ilr': 'IN',\n",
       " 'indin': 'IN',\n",
       " 'indina': 'IN',\n",
       " 'inidan': 'IN',\n",
       " 'inidian': 'IN',\n",
       " 'iraeli': 'IL',\n",
       " 'iranain': 'IR',\n",
       " 'irania': 'IR',\n",
       " 'iraqui': 'IQ',\n",
       " 'iriish': 'IE',\n",
       " 'iris': 'IE',\n",
       " 'irish national': 'IE',\n",
       " 'irish.': 'IE',\n",
       " 'isle of man': 'IM',\n",
       " 'israli': 'IL',\n",
       " 'accountant': 'DQ',\n",
       " 'italain': 'IT',\n",
       " 'italian?': 'IT',\n",
       " 'itallian': 'IT',\n",
       " 'itialian': 'IT',\n",
       " 'itlian': 'IT',\n",
       " 'ivoirienne': 'CI',\n",
       " 'jamacain': 'JM',\n",
       " 'jamacan': 'JM',\n",
       " 'jamaician': 'JM',\n",
       " 'jamaicsn': 'JM',\n",
       " 'jamiacan': 'JM',\n",
       " 'jamican': 'JM',\n",
       " 'commercial agent': 'DQ',\n",
       " 'it consultant': 'DQ',\n",
       " 'joardanian': 'JO',\n",
       " 'jordanien': 'JO',\n",
       " 'management control': 'DQ',\n",
       " 'owner': 'DQ',\n",
       " 'kazachstan': 'KZ',\n",
       " 'kazahstan': 'KZ',\n",
       " 'kenyian': 'KE',\n",
       " 'kirghiz': 'KG',\n",
       " 'kittitian': 'KN',\n",
       " 'kittitian, nevisian': 'KN',\n",
       " 'korean (south)': 'KR',\n",
       " 'kosivan': 'XK',\n",
       " 'kososvo': 'XK',\n",
       " 'kosovar': 'XK',\n",
       " 'kotri': 'DQ',\n",
       " 'kurdistan': 'TR',\n",
       " 'kyrghyz': 'KG',\n",
       " 'kyrgyztan': 'KG',\n",
       " 'latian': 'LV',\n",
       " 'leboneese': 'LB',\n",
       " 'liechtensteinerin': 'LI',\n",
       " 'lietuva': 'LT',\n",
       " 'lietuvos': 'LT',\n",
       " 'lirhuanian': 'LT',\n",
       " 'lithanian': 'LT',\n",
       " 'lithaunian': 'LT',\n",
       " 'lithhuanian': 'LT',\n",
       " 'lithiania': 'LT',\n",
       " 'lithianian': 'LT',\n",
       " 'lithiuan': 'LT',\n",
       " 'lithuainian': 'LT',\n",
       " 'lithuananian': 'LT',\n",
       " 'lithuaniam': 'LT',\n",
       " 'lithuanina': 'LT',\n",
       " 'lithuaninan': 'LT',\n",
       " 'lithuianian': 'LT',\n",
       " 'lithunanian': 'LT',\n",
       " 'lithunian': 'LT',\n",
       " 'lituania': 'LT',\n",
       " 'lituenian': 'LT',\n",
       " 'litvanian': 'LT',\n",
       " 'luthuania': 'LT',\n",
       " 'luthuanian': 'LT',\n",
       " 'luxemburgese': 'LU',\n",
       " 'macao': 'MO',\n",
       " 'malayasia': 'MY',\n",
       " 'malayasian': 'MY',\n",
       " 'malayian': 'MY',\n",
       " 'malta': 'MT',\n",
       " ...}"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nationality_2_codes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "pd.to_pickle(nationality_2_codes, \"data/nation_map.pkl\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Storing the countries back in Neo4j\n",
    "\n",
    "Now we can create country nodes in our graph ready to connect people and companies to"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from neo4j.v1 import GraphDatabase\n",
    "driver = GraphDatabase.driver(\"bolt://10.0.0.1:7687\", auth=(\"myusername\", \"mypassword\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "country_code_map = pd.read_pickle('./data/clean_country_code_map.pkl')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "First we create a list of all the new nodes we wish to create and their associated properties. Then we can connect to the neo4j database and run a Cypher command to insert and create new nodes; we use MERGE in case we have any duplicate entries."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "countryList = [{'code': k, 'name': v} for k, v in country_code_map.items()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "with driver.session() as session:\n",
    "    for key, value in clean_country_map.items():\n",
    "        session.run((\"UNWIND {list} AS d \"\n",
    "                     \"MERGE (c:Country {code: d.code, name: d.name})\"),\n",
    "                    {\"list\": countryList})"
   ]
  }
 ],
 "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.6.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}