Slave Voyages Estimates Pivot Tables.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "db3af1c3",
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import pandas as pd\n",
    "import plotly.graph_objects as go\n",
    "import ipywidgets as widgets\n",
    "import plotly.express as px\n",
    "import numpy as np\n",
    "import json\n",
    "import math\n",
    "pd.options.mode.chained_assignment = None  # default='warn'\n",
    "from app_secrets import headers\n",
    "\n",
    "base_url = 'https://voyages3-api.crc.rice.edu/'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "c7e1fcbe",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Get options to\n",
    "## 1. validate existence of selected vars\n",
    "## 2. retrieve datatypes and labels for later use\n",
    "r = requests.options(base_url + 'voyage?hierarchical=False&auto=False', headers=headers)\n",
    "options_dict = r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "3f4ea195",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Authorization': 'Token 3e9ed2e0fa70a1a5cb6f34eb7a30ebde208ecd8f'}"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "headers"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "fcecbe00",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'https://voyages3-api.crc.rice.edu/voyage/groupby'"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "url = base_url + 'voyage/groupby'\n",
    "url"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "68905b1b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Accra': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 772.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 339.0,\n",
       "  'Kingston': 1334.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': 240.0,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Africa., port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': 136.0,\n",
       "  'Barbados, port unspecified': 123480.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': 413.0,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 136699.0,\n",
       "  'Kingston': 65669.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': 1693.0,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': 200.0,\n",
       "  'Port Royal': 2312.0,\n",
       "  \"Saint Ann's Bay\": 195.0,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': 1112.0,\n",
       "  'Spanish Town': 562.0,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Alampo': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 136.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 452.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Alecuba': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': 535.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Ambriz': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 928.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': 4258.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Americas, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 1.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Andony': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 102.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Anguilla, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Anomabu': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 10223.0,\n",
       "  'Black River': 440.0,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': 119.0,\n",
       "  'Jamaica, port unspecified': 27344.0,\n",
       "  'Kingston': 41049.0,\n",
       "  'Lucea (a) St. Lucea': 341.0,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': 3161.0,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': 350.0,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': 230.0,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Antigua, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 23.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 36.0,\n",
       "  'Kingston': 35.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Ardra': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 8011.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 4310.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Bahamas, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 10.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Banana Islands': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 536.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 174.0,\n",
       "  'Kingston': 332.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': 205.0,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': 152.0,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " \"Bance Island (Ben's Island)\": {'Annotto Bay': nan,\n",
       "  'Antonia': 196.0,\n",
       "  'Barbados, port unspecified': 784.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': 2213.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': 389.0,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Barbados, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 220.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 508.0,\n",
       "  'Kingston': 261.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Bassa': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 1425.0,\n",
       "  'Black River': 146.0,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 1435.0,\n",
       "  'Kingston': 2610.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Benin': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 1293.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 3586.0,\n",
       "  'Kingston': 6288.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': 239.0,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Bermuda': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Bight of Benin, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 1468.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 1499.0,\n",
       "  'Kingston': 3639.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': 254.0,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Bight of Biafra and Gulf of Guinea Islands, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 6693.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 4376.0,\n",
       "  'Kingston': 12894.0,\n",
       "  'Lucea (a) St. Lucea': 325.0,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': 1719.0,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': 106.0,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Bights': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 153.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Bimbia': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 142.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Bissagos': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': 253.0,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Bissau': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 457.0,\n",
       "  'Kingston': 279.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Bonny': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 26166.0,\n",
       "  'Black River': 297.0,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': 511.0,\n",
       "  'Jamaica, port unspecified': 33344.0,\n",
       "  'Kingston': 80240.0,\n",
       "  'Lucea (a) St. Lucea': 569.0,\n",
       "  'Martha Brae': 667.0,\n",
       "  'Montego Bay': 20849.0,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': 363.0,\n",
       "  \"Saint Ann's Bay\": 185.0,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': 129.0,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Boston': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 9.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 10.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Brazil, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 210.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Cabinda': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 1930.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': 353.0,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 6936.0,\n",
       "  'Kingston': 3431.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Cacheu': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 169.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Calabar': {'Annotto Bay': nan,\n",
       "  'Antonia': 404.0,\n",
       "  'Barbados, port unspecified': 15926.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': 216.0,\n",
       "  'Jamaica, port unspecified': 14269.0,\n",
       "  'Kingston': 28524.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': 288.0,\n",
       "  'Montego Bay': 2594.0,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': 208.0,\n",
       "  'Port Royal': 290.0,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Calabary': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Cameroons': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 2687.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 1441.0,\n",
       "  'Kingston': 1483.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Cameroons River': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 384.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 176.0,\n",
       "  'Kingston': 368.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Cap Lopez': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 127.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': 244.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Cape Coast Castle': {'Annotto Bay': nan,\n",
       "  'Antonia': 303.0,\n",
       "  'Barbados, port unspecified': 13861.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 12428.0,\n",
       "  'Kingston': 16680.0,\n",
       "  'Lucea (a) St. Lucea': 637.0,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': 1572.0,\n",
       "  'Morant Bay': 113.0,\n",
       "  'Port Maria': 328.0,\n",
       "  'Port Royal': 370.0,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': 514.0,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Cape Lahou': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 546.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 125.0,\n",
       "  'Kingston': 424.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Cape Mount (Cape Grand Mount)': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 2278.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 2702.0,\n",
       "  'Kingston': 3382.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': 1414.0,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': 215.0,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Cape Verde Islands': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 161.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': 72.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Carolinas': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 7.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 2.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Cartagena': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 14.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Casamance': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 98.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Casnasonis (location undetermined)': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 287.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Charleston': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Congo North': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 297.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 350.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Congo River': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 749.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': 265.0,\n",
       "  'Jamaica, port unspecified': 328.0,\n",
       "  'Kingston': 9825.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Curaçao': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 209.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Demerara': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 25.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Dominica, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Drouin': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 180.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Elmina': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 587.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Epe': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 283.0,\n",
       "  'Kingston': 311.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'French Caribbean, colony unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': 31.0,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Gabon': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 1069.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 946.0,\n",
       "  'Kingston': 547.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': 566.0,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": 140.0,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': 122.0},\n",
       " 'Galam': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 40.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Gallinhas': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 176.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 902.0,\n",
       "  'Kingston': 483.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Gambia': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 11734.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 7159.0,\n",
       "  'Kingston': 4130.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': 318.0,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Gold Coast, Fr. definition': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 570.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Gold Coast, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 29586.0,\n",
       "  'Black River': 741.0,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': 611.0,\n",
       "  'Jamaica, port unspecified': 32394.0,\n",
       "  'Kingston': 50575.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': 1687.0,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': 416.0,\n",
       "  'Port Royal': 2150.0,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': 481.0,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Gorée': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 225.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 150.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Grand Mesurado': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 354.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 165.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Grand Sestos': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': 196.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Grenada, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Heneague': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': 51.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Hispaniola, unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': 31.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Iles Plantain': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 298.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Iles de Los': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 696.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 2308.0,\n",
       "  'Kingston': 1223.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': 987.0,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': 474.0,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Ivory Coast': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 283.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Jacquin': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 1822.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 487.0,\n",
       "  'Kingston': 620.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Jamaica, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 17.0,\n",
       "  'Kingston': 10.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Keta': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 453.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Kingston': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': 199.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': 95.0,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Kormantine': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 1461.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Lagos, Onim': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 474.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 522.0,\n",
       "  'Kingston': 2625.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': 326.0,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Loango': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 3264.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 2842.0,\n",
       "  'Kingston': 1792.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Luanda': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 147.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Lucea (a) St. Lucea': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 6.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Madagascar': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 5035.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 423.0,\n",
       "  'Kingston': 385.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Madeira': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 217.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Malembo': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 2545.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 2582.0,\n",
       "  'Kingston': 6547.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Mano': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 99.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Montserrat, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 61.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Morant Bay': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Mosquito Shore': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': 4.0,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Mozambique': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 100.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Nevis, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 22.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'New Calabar': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 6642.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 8241.0,\n",
       "  'Kingston': 7611.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': 228.0,\n",
       "  'Montego Bay': 3825.0,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': 427.0,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'New Providence': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'New York': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 8.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 26.0,\n",
       "  'Kingston': 22.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': 2.0,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'North Carolina, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': 2.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Philadelphia': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 1.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Popo': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 591.0,\n",
       "  'Black River': 412.0,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 1494.0,\n",
       "  'Kingston': 2012.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': 414.0,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Porto Novo': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 213.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 1324.0,\n",
       "  'Kingston': 1205.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Portuguese Guinea': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 280.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Providence Island': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 5.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Rhode Island, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': 7.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': 13.0,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Rio Nunez': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': 212.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Rio Pongo': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 160.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'River del Rey': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 254.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Roseau': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Saint-Louis': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 1596.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': 126.0,\n",
       "  'Jamaica, port unspecified': 1637.0,\n",
       "  'Kingston': 115.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Senegambia and offshore Atlantic, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 59.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 360.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': 265.0,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Settra Kru': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 58.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Sherbro': {'Annotto Bay': nan,\n",
       "  'Antonia': 280.0,\n",
       "  'Barbados, port unspecified': 749.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 514.0,\n",
       "  'Kingston': 593.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Sierra Leone estuary': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 6111.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 5411.0,\n",
       "  'Kingston': 6679.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': 263.0,\n",
       "  'Montego Bay': 1233.0,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': 195.0,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': 260.0,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Sierra Leone, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 474.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': 90.0,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'South Carolina, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 66.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Southeast Africa and Indian Ocean islands, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 47.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Soyo': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 114.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'St. Croix': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'St. Eustatius': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 8.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'St. Kitts, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 24.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 6.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'St. Lawrence': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 210.0,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'St. Marc': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'St. Paul': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 246.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'St. Vincent, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Suriname': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 18.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'São Tomé': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': 463.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': 280.0,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Tortola, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': nan,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'West Central Africa and St. Helena, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': 280.0,\n",
       "  'Barbados, port unspecified': 19580.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 32720.0,\n",
       "  'Kingston': 49192.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": 149.0,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Whydah': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 30838.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 31635.0,\n",
       "  'Kingston': 17759.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': 506.0,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': 851.0,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Wiamba': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 150.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': nan,\n",
       "  'Kingston': nan,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Windward + Ivory + Gold + Benin': {'Annotto Bay': 190.0,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 1856.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 1340.0,\n",
       "  'Kingston': 270.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Windward Coast (Nunez - Assini)': {'Annotto Bay': 214.0,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 2062.0,\n",
       "  'Black River': nan,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': nan,\n",
       "  'Jamaica, port unspecified': 208.0,\n",
       "  'Kingston': 1858.0,\n",
       "  'Lucea (a) St. Lucea': nan,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': nan,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': nan,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan},\n",
       " 'Windward Coast, port unspecified': {'Annotto Bay': nan,\n",
       "  'Antonia': nan,\n",
       "  'Barbados, port unspecified': 7867.0,\n",
       "  'Black River': 154.0,\n",
       "  'British Caribbean, colony unspecified': nan,\n",
       "  'Falmouth (Jam.)': 240.0,\n",
       "  'Jamaica, port unspecified': 6526.0,\n",
       "  'Kingston': 8776.0,\n",
       "  'Lucea (a) St. Lucea': 159.0,\n",
       "  'Martha Brae': nan,\n",
       "  'Montego Bay': 272.0,\n",
       "  'Morant Bay': nan,\n",
       "  'Port Maria': nan,\n",
       "  'Port Royal': nan,\n",
       "  \"Saint Ann's Bay\": nan,\n",
       "  'Santa Marta': nan,\n",
       "  'Savanna la Mar': nan,\n",
       "  'Spanish Town': 197.0,\n",
       "  'Veracruz': nan,\n",
       "  'West Indies (colony unspecified)': nan}}"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "json.loads(r.text)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "fabfb078",
   "metadata": {},
   "outputs": [],
   "source": [
    "pivot_table_categorical_vars=[\n",
    " 'voyage_ship__imputed_nationality__name',\n",
    " 'voyage_itinerary__imp_broad_region_voyage_begin__broad_region',\n",
    " 'voyage_itinerary__imp_region_voyage_begin__region',\n",
    " 'voyage_itinerary__imp_port_voyage_begin__place',\n",
    " 'voyage_itinerary__imp_principal_region_of_slave_purchase__region',\n",
    " 'voyage_itinerary__imp_principal_place_of_slave_purchase__place',\n",
    " 'voyage_itinerary__imp_principal_region_slave_dis__region',\n",
    " 'voyage_itinerary__imp_broad_region_slave_dis__broad_region',\n",
    " 'voyage_itinerary__imp_principal_port_slave_dis__place',\n",
    " 'voyage_dates__imp_arrival_at_port_of_dis_yyyy'\n",
    "]\n",
    "\n",
    "pivot_table_numerical_vars=[\n",
    " 'voyage_dates__length_middle_passage_days',\n",
    " 'voyage_slaves_numbers__imp_total_num_slaves_embarked',\n",
    " 'voyage_slaves_numbers__imp_total_num_slaves_disembarked'\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "46a23926",
   "metadata": {},
   "outputs": [],
   "source": [
    "colvar_options = [options_dict[i]['flatlabel'] for i in pivot_table_categorical_vars]\n",
    "\n",
    "colvar_emb = widgets.Dropdown(\n",
    "    options=colvar_options,\n",
    "    description=\"Columns\",\n",
    "    disabled=False,\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "8ca0d397",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "62702de887c84a5aae901559eb0c2fa3",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "Dropdown(description='Columns', options=('Ship : Imputed Ship Nationality : Name', 'Itinerary : Imputed broad …"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "colvar_emb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "dac651cc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Ship : Imputed Ship Nationality : Name'"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "colvar_emb.value"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "5a5c7ddc",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "rowvar_options = [options_dict[i]['flatlabel'] for i in pivot_table_categorical_vars]\n",
    "\n",
    "rowvar_emb = widgets.Dropdown(\n",
    "    options=rowvar_options,\n",
    "    description=\"Rows\",\n",
    "    disabled=False,\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "33030d77",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "5c9a610ea1374f0ebf7e20a19c0d9138",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "Dropdown(description='Rows', options=('Ship : Imputed Ship Nationality : Name', 'Itinerary : Imputed broad reg…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "rowvar_emb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "589b8152",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "cellvar_options = [options_dict[i]['flatlabel'] for i in pivot_table_numerical_vars]\n",
    "\n",
    "cellvar_emb = widgets.Dropdown(\n",
    "    options=cellvar_options,\n",
    "    description=\"Cells\",\n",
    "    disabled=False\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "883a5bb2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "e1afdebeac57462b8a9833bf7340d3bb",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "Dropdown(description='Cells', options=('Dates : Length of Middle Passage in (days) (VOYAGE)', 'voyage slaves n…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "cellvar_emb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "0b357876",
   "metadata": {},
   "outputs": [],
   "source": [
    "dropnavar_emb = widgets.Checkbox(\n",
    "    value=False,\n",
    "    description=\"Drop Empty?\",\n",
    "    disabled=False\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "4378ec15",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "3476cdb406fc43b9abdee9b0e28d2fb2",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "Checkbox(value=False, description='Drop Empty?')"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "dropnavar_emb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "df9fcc80",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['voyage_dates__length_middle_passage_days',\n",
       " 'voyage_slaves_numbers__imp_total_num_slaves_embarked',\n",
       " 'voyage_slaves_numbers__imp_total_num_slaves_disembarked']"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pivot_table_numerical_vars"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "08f06e4c",
   "metadata": {},
   "outputs": [],
   "source": [
    "url = base_url + 'voyage/groupby'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "bfafa43d",
   "metadata": {},
   "outputs": [],
   "source": [
    "data={ \n",
    "      'groupby_fields' : [\n",
    "          pivot_table_categorical_vars[rowvar_options.index(rowvar_emb.value)],\n",
    "          pivot_table_categorical_vars[colvar_options.index(colvar_emb.value)]\n",
    "      ],\n",
    "      'value_field_tuple':[\n",
    "          pivot_table_numerical_vars[cellvar_options.index(cellvar_emb.value)], 'average'],\n",
    "      'cachename':[\n",
    "          'voyage_pivot_tables']                    \n",
    "     }\n",
    "\n",
    "r = requests.post(url, data=data, headers=headers)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "4228025f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'groupby_fields': ['voyage_dates__imp_arrival_at_port_of_dis_yyyy',\n",
       "  'voyage_itinerary__imp_port_voyage_begin__place'],\n",
       " 'value_field_tuple': ['voyage_dates__length_middle_passage_days', 'average'],\n",
       " 'cachename': ['voyage_pivot_tables']}"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "ed748e8f",
   "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>Africa., port unspecified</th>\n",
       "      <th>Amelia Island</th>\n",
       "      <th>Americas, port unspecified</th>\n",
       "      <th>Amsterdam</th>\n",
       "      <th>Annapolis</th>\n",
       "      <th>Antigua, port unspecified</th>\n",
       "      <th>Antwerp</th>\n",
       "      <th>Azores</th>\n",
       "      <th>Bahia Honda</th>\n",
       "      <th>Bahia, port unspecified</th>\n",
       "      <th>...</th>\n",
       "      <th>Vigo</th>\n",
       "      <th>Virginia, port unspecified</th>\n",
       "      <th>Vitória</th>\n",
       "      <th>Vlissingen</th>\n",
       "      <th>Wales</th>\n",
       "      <th>Warren</th>\n",
       "      <th>Waterford</th>\n",
       "      <th>Whitehaven</th>\n",
       "      <th>Zeeland</th>\n",
       "      <th>Zuider Zee</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1970-01-01 00:25:19</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1970-01-01 00:25:26</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1970-01-01 00:25:32</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1970-01-01 00:25:35</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1970-01-01 00:25:41</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <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>1970-01-01 00:31:02</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1970-01-01 00:31:03</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1970-01-01 00:31:04</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1970-01-01 00:31:05</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1970-01-01 00:31:06</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</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>316 rows × 241 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Africa., port unspecified  Amelia Island  \\\n",
       "1970-01-01 00:25:19                        NaN            NaN   \n",
       "1970-01-01 00:25:26                        NaN            NaN   \n",
       "1970-01-01 00:25:32                        NaN            NaN   \n",
       "1970-01-01 00:25:35                        NaN            NaN   \n",
       "1970-01-01 00:25:41                        NaN            NaN   \n",
       "...                                        ...            ...   \n",
       "1970-01-01 00:31:02                        NaN            NaN   \n",
       "1970-01-01 00:31:03                        NaN            NaN   \n",
       "1970-01-01 00:31:04                        NaN            NaN   \n",
       "1970-01-01 00:31:05                        NaN            NaN   \n",
       "1970-01-01 00:31:06                        NaN            NaN   \n",
       "\n",
       "                     Americas, port unspecified  Amsterdam  Annapolis  \\\n",
       "1970-01-01 00:25:19                         NaN        NaN        NaN   \n",
       "1970-01-01 00:25:26                         NaN        NaN        NaN   \n",
       "1970-01-01 00:25:32                         NaN        NaN        NaN   \n",
       "1970-01-01 00:25:35                         NaN        NaN        NaN   \n",
       "1970-01-01 00:25:41                         NaN        NaN        NaN   \n",
       "...                                         ...        ...        ...   \n",
       "1970-01-01 00:31:02                         NaN        NaN        NaN   \n",
       "1970-01-01 00:31:03                         NaN        NaN        NaN   \n",
       "1970-01-01 00:31:04                         NaN        NaN        NaN   \n",
       "1970-01-01 00:31:05                         NaN        NaN        NaN   \n",
       "1970-01-01 00:31:06                         NaN        NaN        NaN   \n",
       "\n",
       "                     Antigua, port unspecified  Antwerp  Azores  Bahia Honda  \\\n",
       "1970-01-01 00:25:19                        NaN      NaN     NaN          NaN   \n",
       "1970-01-01 00:25:26                        NaN      NaN     NaN          NaN   \n",
       "1970-01-01 00:25:32                        NaN      NaN     NaN          NaN   \n",
       "1970-01-01 00:25:35                        NaN      NaN     NaN          NaN   \n",
       "1970-01-01 00:25:41                        NaN      NaN     NaN          NaN   \n",
       "...                                        ...      ...     ...          ...   \n",
       "1970-01-01 00:31:02                        NaN      NaN     NaN          NaN   \n",
       "1970-01-01 00:31:03                        NaN      NaN     NaN          NaN   \n",
       "1970-01-01 00:31:04                        NaN      NaN     NaN          NaN   \n",
       "1970-01-01 00:31:05                        NaN      NaN     NaN          NaN   \n",
       "1970-01-01 00:31:06                        NaN      NaN     NaN          NaN   \n",
       "\n",
       "                     Bahia, port unspecified  ...  Vigo  \\\n",
       "1970-01-01 00:25:19                      NaN  ...   NaN   \n",
       "1970-01-01 00:25:26                      NaN  ...   NaN   \n",
       "1970-01-01 00:25:32                      NaN  ...   NaN   \n",
       "1970-01-01 00:25:35                      NaN  ...   NaN   \n",
       "1970-01-01 00:25:41                      NaN  ...   NaN   \n",
       "...                                      ...  ...   ...   \n",
       "1970-01-01 00:31:02                      NaN  ...   NaN   \n",
       "1970-01-01 00:31:03                      NaN  ...   NaN   \n",
       "1970-01-01 00:31:04                      NaN  ...   NaN   \n",
       "1970-01-01 00:31:05                      NaN  ...   NaN   \n",
       "1970-01-01 00:31:06                      NaN  ...   NaN   \n",
       "\n",
       "                     Virginia, port unspecified  Vitória  Vlissingen  Wales  \\\n",
       "1970-01-01 00:25:19                         NaN      NaN         NaN    NaN   \n",
       "1970-01-01 00:25:26                         NaN      NaN         NaN    NaN   \n",
       "1970-01-01 00:25:32                         NaN      NaN         NaN    NaN   \n",
       "1970-01-01 00:25:35                         NaN      NaN         NaN    NaN   \n",
       "1970-01-01 00:25:41                         NaN      NaN         NaN    NaN   \n",
       "...                                         ...      ...         ...    ...   \n",
       "1970-01-01 00:31:02                         NaN      NaN         NaN    NaN   \n",
       "1970-01-01 00:31:03                         NaN      NaN         NaN    NaN   \n",
       "1970-01-01 00:31:04                         NaN      NaN         NaN    NaN   \n",
       "1970-01-01 00:31:05                         NaN      NaN         NaN    NaN   \n",
       "1970-01-01 00:31:06                         NaN      NaN         NaN    NaN   \n",
       "\n",
       "                     Warren  Waterford  Whitehaven  Zeeland  Zuider Zee  \n",
       "1970-01-01 00:25:19     NaN        NaN         NaN      NaN         NaN  \n",
       "1970-01-01 00:25:26     NaN        NaN         NaN      NaN         NaN  \n",
       "1970-01-01 00:25:32     NaN        NaN         NaN      NaN         NaN  \n",
       "1970-01-01 00:25:35     NaN        NaN         NaN      NaN         NaN  \n",
       "1970-01-01 00:25:41     NaN        NaN         NaN      NaN         NaN  \n",
       "...                     ...        ...         ...      ...         ...  \n",
       "1970-01-01 00:31:02     NaN        NaN         NaN      NaN         NaN  \n",
       "1970-01-01 00:31:03     NaN        NaN         NaN      NaN         NaN  \n",
       "1970-01-01 00:31:04     NaN        NaN         NaN      NaN         NaN  \n",
       "1970-01-01 00:31:05     NaN        NaN         NaN      NaN         NaN  \n",
       "1970-01-01 00:31:06     NaN        NaN         NaN      NaN         NaN  \n",
       "\n",
       "[316 rows x 241 columns]"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_json(r.text)\n",
    "df.reset_index()\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "5abb52e7",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "year_range_emb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9e7aa07f",
   "metadata": {},
   "outputs": [],
   "source": [
    "enslaving_nations_varlabel=options_dict['nation__name']['label']\n",
    "enslaving_nations=list(df_formatted[enslaving_nations_varlabel].unique())\n",
    "\n",
    "enslaving_nations_emb = widgets.SelectMultiple(\n",
    "    options=enslaving_nations,\n",
    "    value=enslaving_nations,\n",
    "    description=\"Cells\",\n",
    "    disabled=False\n",
    ")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "06e62edb",
   "metadata": {},
   "outputs": [],
   "source": [
    "enslaving_nations_emb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "7d2f933c",
   "metadata": {},
   "outputs": [],
   "source": [
    "enslaving_nations_emb.value"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "bcbda83b",
   "metadata": {},
   "outputs": [],
   "source": [
    "widgets.TwoByTwoLayout(top_left=rowvar_emb,top_right=colvar_emb,bottom_left=dropnavar_emb,bottom_right=cellvar_emb)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "14279468",
   "metadata": {},
   "outputs": [],
   "source": [
    "rowvar=rowvar_emb.value\n",
    "colvar=colvar_emb.value\n",
    "cellvar=cellvar_emb.value"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "73796196",
   "metadata": {},
   "outputs": [],
   "source": [
    "years=df_formatted['Year']\n",
    "max_epoch_length=year_range_emb.value[1]-year_range_emb.value[0]\n",
    "epoch_length_emb=widgets.IntSlider(value=max_epoch_length,min=1,max=max_epoch_length,description=\"Epoch Length:\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2311e606",
   "metadata": {},
   "outputs": [],
   "source": [
    "if 'Year' in rowvar:\n",
    "    display(epoch_length_emb)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "08c5299e",
   "metadata": {},
   "outputs": [],
   "source": [
    "selected_vars=list(set(list(cellvar_emb.value)+[colvar_emb.value]+[rowvar_emb.value]+['Year']))\n",
    "df_selected=df_formatted[selected_vars]\n",
    "df_selected = df_selected[df_selected['Year'].between(year_range_emb.value[0],year_range_emb.value[1])]\n",
    "df_selected = df_selected[df_selected[enslaving_nations_varlabel].isin(list(enslaving_nations_emb.value))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6b091259",
   "metadata": {},
   "outputs": [],
   "source": [
    "if rowvar=='Year':\n",
    "    bins=math.ceil((year_range_emb.value[1]-year_range_emb.value[0])/epoch_length_emb.value)\n",
    "    if bins!=1:\n",
    "        df_selected['Year']=pd.cut(df_selected['Year'],bins)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "dcc30a64",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Selects only the first of the 1-2 numeric vars\n",
    "df_selected[\"Year\"]=df_selected[\"Year\"].astype('str')\n",
    "fig = px.bar(df_selected, x=\"Year\",\n",
    "             y=cellvar[0], color=colvar\n",
    "             )\n",
    "fig.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ca075c31",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}