2nd Exercise.ipynb

{
 "metadata": {
  "name": ""
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "heading",
     "level": 1,
     "metadata": {},
     "source": [
      "Data Analysis"
     ]
    },
    {
     "cell_type": "heading",
     "level": 2,
     "metadata": {},
     "source": [
      "2nd Exercise"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "1. Find the top 10 arrival airports in the world in 2013\n",
      "2. Print the top 10 arrival airports in the standard output, including the number of passengers.\n",
      "3. [E] Get the name of the city or airport corresponding to that airport\n"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "Necessary imports"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#pandas\n",
      "import numpy as np\n",
      "import pandas as pd\n",
      "\n",
      "#geographic data\n",
      "from GeoBases import GeoBase\n",
      "geo_o = GeoBase(data='ori_por', verbose=False)\n"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 1
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "converter functions for parsing in load time"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "def strip_field(data):\n",
      "    \"\"\"\n",
      "    strip white characters from input data if is string\n",
      "    \"\"\"\n",
      "    if type(data) == str:\n",
      "        return data.strip()\n",
      "    return data\n",
      "\n",
      "def to_date(data):\n",
      "    \"\"\"\n",
      "    converts input data in yyyy-mm-dd format to Pandas Timestamp object.\n",
      "    If it fails returns original object\n",
      "    \"\"\"\n",
      "    try:\n",
      "        return pd.Timestamp(data)\n",
      "    except:\n",
      "        return data\n",
      "    "
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 2
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "First, inspect the header of the file to get the field names that will be used.\n",
      "\n",
      "Taking in account the bug on multichar regex 'sep' field \n",
      "[pandas issue on 'sep'](https://github.com/pydata/pandas/issues/6607)\n",
      "\n",
      "there is the need to handle correctly the headers and transform the fields later"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#load first line of the bookings file to get names that will be parsed ...\n",
      "\n",
      "with open('bookings.csv') as f:\n",
      "    head = f.readline()\n",
      "    \n",
      "#split as the separator will do\n",
      "headers = head.split('^')\n",
      "for i in headers:\n",
      "    if 'arr_port' in i:\n",
      "        arr_port = i\n",
      "    elif 'pax' in i:\n",
      "        pax = i\n",
      "    elif 'off_time' in i:\n",
      "        off_time = i\n",
      "        \n",
      "#visual check of whitespaces\n",
      "print '\"'+arr_port+'\"'\n",
      "print '\"'+pax+'\"'\n",
      "print '\"'+off_time+'\"'"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "\"arr_port\"\n",
        "\"pax\"\n",
        "\"off_time           \"\n"
       ]
      }
     ],
     "prompt_number": 3
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#working with converter instead of multichar regex 'sep' field to avoid problem\n",
      "#https://github.com/pydata/pandas/issues/6607\n",
      "#load with the wrong name (with whitespaces)\n",
      "%time bks = pd.read_table('bookings.csv',sep='^', usecols=[arr_port, pax, off_time], converters={arr_port:strip_field, off_time: to_date})\n",
      "#now change column name\n",
      "bks.rename(columns=lambda x: x.strip(), inplace=True)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "CPU times: user 43.2 s, sys: 5.31 s, total: 48.5 s\n",
        "Wall time: 1min 33s\n"
       ]
      }
     ],
     "prompt_number": 4
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "Doing some visual checks on the data"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "bks.dtypes"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 5,
       "text": [
        "arr_port     object\n",
        "off_time     object\n",
        "pax         float64\n",
        "dtype: object"
       ]
      }
     ],
     "prompt_number": 5
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "bks.memory_usage(index=True)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 6,
       "text": [
        "Index       80000080\n",
        "arr_port    80000080\n",
        "off_time    80000080\n",
        "pax         80000080\n",
        "dtype: int64"
       ]
      }
     ],
     "prompt_number": 6
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#check strip worked correclty\n",
      "bks.arr_port[100]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 7,
       "text": [
        "'BKK'"
       ]
      }
     ],
     "prompt_number": 7
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#visual check\n",
      "bks.head()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>arr_port</th>\n",
        "      <th>off_time</th>\n",
        "      <th>pax</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td> LHR</td>\n",
        "      <td> 2013-03-07 11:33:37</td>\n",
        "      <td>-1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> CLT</td>\n",
        "      <td> 2013-04-12 22:05:40</td>\n",
        "      <td> 1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td> CLT</td>\n",
        "      <td> 2013-07-15 11:34:51</td>\n",
        "      <td> 1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td> SVO</td>\n",
        "      <td> 2013-04-25 16:06:31</td>\n",
        "      <td> 1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td> SVO</td>\n",
        "      <td> 2013-05-16 10:44:50</td>\n",
        "      <td> 1</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 8,
       "text": [
        "  arr_port             off_time  pax\n",
        "0      LHR  2013-03-07 11:33:37   -1\n",
        "1      CLT  2013-04-12 22:05:40    1\n",
        "2      CLT  2013-07-15 11:34:51    1\n",
        "3      SVO  2013-04-25 16:06:31    1\n",
        "4      SVO  2013-05-16 10:44:50    1"
       ]
      }
     ],
     "prompt_number": 8
    },
    {
     "cell_type": "heading",
     "level": 5,
     "metadata": {},
     "source": [
      "Obtain the top 10"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "obtain datatype in order to find out the things needed in the filter"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "ot = bks.off_time"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 9
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "ts = ot[0]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 10
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#find out type for filter (handling null data)\n",
      "type(ts)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 11,
       "text": [
        "pandas.tslib.Timestamp"
       ]
      }
     ],
     "prompt_number": 11
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#group by airport filtering by year 2013 and sum:\n",
      "#%time arrs = bks[bks.off_time.apply(filter_2013)].groupby('arr_port').sum()\n",
      "%time arrs = bks[bks.off_time.apply(lambda x: x.date().year == 2013 if (type(x) == pd.tslib.Timestamp ) else False)].groupby('arr_port').sum()\n",
      "#TODO sum only pax column, avoid using the timestamp column"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "CPU times: user 6.62 s, sys: 631 ms, total: 7.25 s\n",
        "Wall time: 7.34 s\n"
       ]
      }
     ],
     "prompt_number": 12
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "arrs.head()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>pax</th>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>arr_port</th>\n",
        "      <th></th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>AAB</th>\n",
        "      <td>   30</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>AAE</th>\n",
        "      <td>  810</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>AAL</th>\n",
        "      <td>  750</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>AAN</th>\n",
        "      <td>   20</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>AAQ</th>\n",
        "      <td> 1650</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 13,
       "text": [
        "           pax\n",
        "arr_port      \n",
        "AAB         30\n",
        "AAE        810\n",
        "AAL        750\n",
        "AAN         20\n",
        "AAQ       1650"
       ]
      }
     ],
     "prompt_number": 13
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "bks.head()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>arr_port</th>\n",
        "      <th>off_time</th>\n",
        "      <th>pax</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td> LHR</td>\n",
        "      <td> 2013-03-07 11:33:37</td>\n",
        "      <td>-1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> CLT</td>\n",
        "      <td> 2013-04-12 22:05:40</td>\n",
        "      <td> 1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td> CLT</td>\n",
        "      <td> 2013-07-15 11:34:51</td>\n",
        "      <td> 1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td> SVO</td>\n",
        "      <td> 2013-04-25 16:06:31</td>\n",
        "      <td> 1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td> SVO</td>\n",
        "      <td> 2013-05-16 10:44:50</td>\n",
        "      <td> 1</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 14,
       "text": [
        "  arr_port             off_time  pax\n",
        "0      LHR  2013-03-07 11:33:37   -1\n",
        "1      CLT  2013-04-12 22:05:40    1\n",
        "2      CLT  2013-07-15 11:34:51    1\n",
        "3      SVO  2013-04-25 16:06:31    1\n",
        "4      SVO  2013-05-16 10:44:50    1"
       ]
      }
     ],
     "prompt_number": 14
    },
    {
     "cell_type": "heading",
     "level": 6,
     "metadata": {},
     "source": [
      "Now actually obtain the top 10"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#sort inline for not copying\n",
      "%time arrs.sort('pax', ascending=False, inplace=True)\n",
      "#print\n",
      "top10 = arrs.head(10)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "CPU times: user 1.08 ms, sys: 131 \u00b5s, total: 1.21 ms\n",
        "Wall time: 858 \u00b5s\n"
       ]
      }
     ],
     "prompt_number": 15
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "top10"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>pax</th>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>arr_port</th>\n",
        "      <th></th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>LHR</th>\n",
        "      <td> 81439</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>LAX</th>\n",
        "      <td> 64230</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>LAS</th>\n",
        "      <td> 63190</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>MCO</th>\n",
        "      <td> 62290</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>JFK</th>\n",
        "      <td> 60060</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>CDG</th>\n",
        "      <td> 58080</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>SFO</th>\n",
        "      <td> 53710</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>MIA</th>\n",
        "      <td> 53020</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>BKK</th>\n",
        "      <td> 52660</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>DXB</th>\n",
        "      <td> 52230</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 16,
       "text": [
        "            pax\n",
        "arr_port       \n",
        "LHR       81439\n",
        "LAX       64230\n",
        "LAS       63190\n",
        "MCO       62290\n",
        "JFK       60060\n",
        "CDG       58080\n",
        "SFO       53710\n",
        "MIA       53020\n",
        "BKK       52660\n",
        "DXB       52230"
       ]
      }
     ],
     "prompt_number": 16
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "print(top10)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "            pax\n",
        "arr_port       \n",
        "LHR       81439\n",
        "LAX       64230\n",
        "LAS       63190\n",
        "MCO       62290\n",
        "JFK       60060\n",
        "CDG       58080\n",
        "SFO       53710\n",
        "MIA       53020\n",
        "BKK       52660\n",
        "DXB       52230\n"
       ]
      }
     ],
     "prompt_number": 17
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "Obtaining geographic information about the top 10"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#geographic data\n",
      "#recover arr_port as column\n",
      "for i in top10.index:\n",
      "    print (\"Code: %s, name: %s \"% (i.strip(),geo_o.get(i.strip(), 'name')))"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "Code: LHR, name: London Heathrow Airport \n",
        "Code: LAX, name: Los Angeles International Airport \n",
        "Code: LAS, name: Mc Carran International Airport \n",
        "Code: MCO, name: Orlando International Airport \n",
        "Code: JFK, name: John F Kennedy International Airport \n",
        "Code: CDG, name: Paris - Charles-de-Gaulle \n",
        "Code: SFO, name: San Francisco International Airport \n",
        "Code: MIA, name: Miami International Airport \n",
        "Code: BKK, name: Suvarnabhumi \n",
        "Code: DXB, name: Dubai International Airport \n"
       ]
      }
     ],
     "prompt_number": 18
    },
    {
     "cell_type": "heading",
     "level": 4,
     "metadata": {},
     "source": [
      "NOTES on the data:"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "There are negative sums, this might mean that the database extract is not complete or a problem arised"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "arrs.tail()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>pax</th>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>arr_port</th>\n",
        "      <th></th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>XWG</th>\n",
        "      <td>  -90</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>CXR</th>\n",
        "      <td> -120</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>FLW</th>\n",
        "      <td> -190</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>MZV</th>\n",
        "      <td> -350</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>AYQ</th>\n",
        "      <td>-1290</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 19,
       "text": [
        "           pax\n",
        "arr_port      \n",
        "XWG        -90\n",
        "CXR       -120\n",
        "FLW       -190\n",
        "MZV       -350\n",
        "AYQ      -1290"
       ]
      }
     ],
     "prompt_number": 19
    },
    {
     "cell_type": "heading",
     "level": 3,
     "metadata": {},
     "source": [
      "Pure python implementation"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#cleanup everything\n",
      "%reset\n",
      "import gc\n",
      "gc.collect()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "name": "stdout",
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "Once deleted, variables cannot be recovered. Proceed (y/[n])? y\n"
       ]
      },
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 20,
       "text": [
        "0"
       ]
      }
     ],
     "prompt_number": 20
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import datetime"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 21
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "get header and index that will be used for parsing data"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#get header\n",
      "headers = None\n",
      "with open('headbook.csv', 'r') as f:\n",
      "    for l in f:\n",
      "        fields = [i.strip() for i in l.split('^')]\n",
      "        if headers is None:\n",
      "            headers = fields\n",
      "            break\n",
      "\n",
      "#get IATA code index\n",
      "print headers.index('arr_port')\n",
      "#get timestamp index\n",
      "print headers.index('off_time')\n",
      "#get passengers index\n",
      "print headers.index('pax')\n"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "12\n",
        "33\n",
        "34\n"
       ]
      }
     ],
     "prompt_number": 22
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#define function that makes the processing\n",
      "def group_by_port(fname):\n",
      "    \"\"\"\n",
      "    Opens the file, parses it and makes the sum of passengers by arrival port\n",
      "    fname: name of the file containing the booking data\n",
      "    \"\"\"\n",
      "    arr_dict = {}\n",
      "    with open(fname, 'r') as f:\n",
      "        for l in f:\n",
      "            fields = [i.strip() for i in l.split('^')]\n",
      "            #be careful with empty fields \n",
      "            try:\n",
      "                #get destination IATA code\n",
      "                dst = fields[12]\n",
      "                #get passengers\n",
      "                psg = int(fields[34])\n",
      "                #get timestamp\n",
      "                ts = datetime.datetime.strptime(fields[33].split()[0], \"%Y-%m-%d\")\n",
      "                #sum\n",
      "                if dst not in arr_dict:\n",
      "                    arr_dict[dst] = 0\n",
      "                if ts.year == 2013:\n",
      "                    arr_dict[dst] += psg\n",
      "            except Exception as e:\n",
      "                #print (\"ERROR %s reading %s \" %(e,l))\n",
      "                pass\n",
      "    return arr_dict\n"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 23
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#arrival dictionary containing the airports IATA codes and the sum for year 2013\n",
      "%time arr_dict = group_by_port('bookings.csv')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "CPU times: user 2min 43s, sys: 4.99 s, total: 2min 48s\n",
        "Wall time: 2min 51s\n"
       ]
      }
     ],
     "prompt_number": 24
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "arr_dict"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 25,
       "text": [
        "{'AAB': 30,\n",
        " 'AAE': 810,\n",
        " 'AAL': 750,\n",
        " 'AAN': 20,\n",
        " 'AAQ': 1650,\n",
        " 'AAR': 500,\n",
        " 'ABA': 90,\n",
        " 'ABB': 40,\n",
        " 'ABE': 830,\n",
        " 'ABI': 150,\n",
        " 'ABJ': 2500,\n",
        " 'ABK': 0,\n",
        " 'ABQ': 4040,\n",
        " 'ABR': 0,\n",
        " 'ABS': 310,\n",
        " 'ABT': 290,\n",
        " 'ABV': 1880,\n",
        " 'ABX': 300,\n",
        " 'ABY': 90,\n",
        " 'ABZ': 3580,\n",
        " 'ACA': 690,\n",
        " 'ACC': 3530,\n",
        " 'ACE': 1550,\n",
        " 'ACH': 20,\n",
        " 'ACI': 40,\n",
        " 'ACK': 200,\n",
        " 'ACT': 160,\n",
        " 'ACV': 140,\n",
        " 'ACY': 190,\n",
        " 'ADA': 980,\n",
        " 'ADB': 2790,\n",
        " 'ADD': 5500,\n",
        " 'ADE': 550,\n",
        " 'ADL': 6970,\n",
        " 'ADQ': 390,\n",
        " 'ADZ': 2690,\n",
        " 'AEP': 7650,\n",
        " 'AER': 3270,\n",
        " 'AES': 750,\n",
        " 'AEX': 750,\n",
        " 'AFA': 170,\n",
        " 'AGA': 1490,\n",
        " 'AGB': 20,\n",
        " 'AGF': 60,\n",
        " 'AGH': 280,\n",
        " 'AGM': 0,\n",
        " 'AGP': 9440,\n",
        " 'AGR': 50,\n",
        " 'AGS': 620,\n",
        " 'AGT': 100,\n",
        " 'AGU': 800,\n",
        " 'AGX': 80,\n",
        " 'AHB': 1810,\n",
        " 'AHO': 770,\n",
        " 'AHU': 130,\n",
        " 'AJA': 1520,\n",
        " 'AJF': 570,\n",
        " 'AJI': 40,\n",
        " 'AJL': 340,\n",
        " 'AJR': 50,\n",
        " 'AJU': 110,\n",
        " 'AKF': 10,\n",
        " 'AKL': 12280,\n",
        " 'AKN': 110,\n",
        " 'AKX': 310,\n",
        " 'AKY': 0,\n",
        " 'ALA': 4520,\n",
        " 'ALB': 2260,\n",
        " 'ALC': 2660,\n",
        " 'ALF': 150,\n",
        " 'ALG': 10280,\n",
        " 'ALH': 320,\n",
        " 'ALO': 10,\n",
        " 'ALP': 0,\n",
        " 'ALS': 40,\n",
        " 'ALW': 60,\n",
        " 'AMA': 1120,\n",
        " 'AMD': 4490,\n",
        " 'AMH': 60,\n",
        " 'AMM': 11620,\n",
        " 'AMS': 28340,\n",
        " 'ANC': 4640,\n",
        " 'ANF': 1580,\n",
        " 'ANR': 150,\n",
        " 'ANU': 1920,\n",
        " 'ANX': 110,\n",
        " 'AOE': 60,\n",
        " 'AOI': 210,\n",
        " 'AOJ': 20,\n",
        " 'AOK': 100,\n",
        " 'AOO': 20,\n",
        " 'AOR': 30,\n",
        " 'APL': 230,\n",
        " 'APN': 10,\n",
        " 'APO': 60,\n",
        " 'APW': 720,\n",
        " 'AQI': 60,\n",
        " 'AQJ': 240,\n",
        " 'AQP': 1630,\n",
        " 'ARH': 610,\n",
        " 'ARI': 490,\n",
        " 'ARK': 150,\n",
        " 'ARM': 140,\n",
        " 'ARN': 20300,\n",
        " 'ART': 70,\n",
        " 'ASB': 260,\n",
        " 'ASE': 900,\n",
        " 'ASF': 300,\n",
        " 'ASM': 270,\n",
        " 'ASO': 110,\n",
        " 'ASP': 550,\n",
        " 'ASR': 350,\n",
        " 'ASU': 1400,\n",
        " 'ASW': 520,\n",
        " 'ATH': 21430,\n",
        " 'ATL': 38760,\n",
        " 'ATQ': 2270,\n",
        " 'ATW': 750,\n",
        " 'ATY': 0,\n",
        " 'ATZ': 280,\n",
        " 'AUA': 5060,\n",
        " 'AUG': 20,\n",
        " 'AUH': 7970,\n",
        " 'AUS': 11070,\n",
        " 'AVL': 830,\n",
        " 'AVP': 710,\n",
        " 'AWZ': 10,\n",
        " 'AXA': 10,\n",
        " 'AXD': 260,\n",
        " 'AXM': 540,\n",
        " 'AXP': 0,\n",
        " 'AXU': 440,\n",
        " 'AYQ': -1290,\n",
        " 'AYT': 4810,\n",
        " 'AZA': 210,\n",
        " 'AZN': 0,\n",
        " 'AZO': 420,\n",
        " 'AZR': 130,\n",
        " 'AZS': 50,\n",
        " 'BAH': 5560,\n",
        " 'BAL': 0,\n",
        " 'BAQ': 3330,\n",
        " 'BAV': -20,\n",
        " 'BAX': 120,\n",
        " 'BAY': 40,\n",
        " 'BBA': 200,\n",
        " 'BBB': 40,\n",
        " 'BBI': 840,\n",
        " 'BBK': 40,\n",
        " 'BBN': 30,\n",
        " 'BBO': 100,\n",
        " 'BCD': 230,\n",
        " 'BCM': 60,\n",
        " 'BCN': 38790,\n",
        " 'BDA': 1510,\n",
        " 'BDB': 170,\n",
        " 'BDJ': 20,\n",
        " 'BDL': 6050,\n",
        " 'BDO': 110,\n",
        " 'BDQ': 680,\n",
        " 'BDS': 1260,\n",
        " 'BDU': 120,\n",
        " 'BEB': 20,\n",
        " 'BEG': 5400,\n",
        " 'BEL': 330,\n",
        " 'BEN': 1280,\n",
        " 'BER': -20,\n",
        " 'BES': 1200,\n",
        " 'BET': 340,\n",
        " 'BEW': 110,\n",
        " 'BEY': 10360,\n",
        " 'BFD': 10,\n",
        " 'BFF': 20,\n",
        " 'BFL': 470,\n",
        " 'BFN': 580,\n",
        " 'BFS': 210,\n",
        " 'BGA': 2050,\n",
        " 'BGF': 50,\n",
        " 'BGI': 2200,\n",
        " 'BGM': 270,\n",
        " 'BGO': 5780,\n",
        " 'BGR': 530,\n",
        " 'BGW': 1050,\n",
        " 'BGY': 190,\n",
        " 'BHB': 70,\n",
        " 'BHD': 1300,\n",
        " 'BHE': 350,\n",
        " 'BHH': 290,\n",
        " 'BHI': 390,\n",
        " 'BHJ': 620,\n",
        " 'BHK': 70,\n",
        " 'BHM': 2810,\n",
        " 'BHO': 780,\n",
        " 'BHQ': 70,\n",
        " 'BHS': 30,\n",
        " 'BHU': 220,\n",
        " 'BHV': 90,\n",
        " 'BHX': 4220,\n",
        " 'BHY': 60,\n",
        " 'BIA': 920,\n",
        " 'BIL': 1070,\n",
        " 'BIM': 70,\n",
        " 'BIO': 4490,\n",
        " 'BIQ': 1110,\n",
        " 'BIS': 720,\n",
        " 'BJA': 760,\n",
        " 'BJF': 10,\n",
        " 'BJI': 30,\n",
        " 'BJL': 680,\n",
        " 'BJM': 890,\n",
        " 'BJR': 380,\n",
        " 'BJV': 960,\n",
        " 'BJX': 2010,\n",
        " 'BJZ': 40,\n",
        " 'BKG': 140,\n",
        " 'BKI': 1280,\n",
        " 'BKK': 52660,\n",
        " 'BKO': 1030,\n",
        " 'BKW': 20,\n",
        " 'BKZ': 50,\n",
        " 'BLA': 1410,\n",
        " 'BLI': 190,\n",
        " 'BLJ': 120,\n",
        " 'BLL': 2010,\n",
        " 'BLQ': 5690,\n",
        " 'BLR': 12380,\n",
        " 'BLZ': 130,\n",
        " 'BMA': 2720,\n",
        " 'BME': 400,\n",
        " 'BMI': 620,\n",
        " 'BNA': 8520,\n",
        " 'BND': 0,\n",
        " 'BNE': 18240,\n",
        " 'BNI': 40,\n",
        " 'BNK': 130,\n",
        " 'BNN': 250,\n",
        " 'BNS': 500,\n",
        " 'BOB': 160,\n",
        " 'BOD': 4510,\n",
        " 'BOG': 22470,\n",
        " 'BOI': 3110,\n",
        " 'BOJ': 240,\n",
        " 'BOM': 31430,\n",
        " 'BON': 410,\n",
        " 'BOO': 1050,\n",
        " 'BOS': 34680,\n",
        " 'BPN': 40,\n",
        " 'BPS': 260,\n",
        " 'BPT': 60,\n",
        " 'BQB': 10,\n",
        " 'BQK': 70,\n",
        " 'BQN': 530,\n",
        " 'BQS': 100,\n",
        " 'BRC': 1430,\n",
        " 'BRD': 70,\n",
        " 'BRE': 1840,\n",
        " 'BRI': 2600,\n",
        " 'BRL': 0,\n",
        " 'BRM': 750,\n",
        " 'BRN': 40,\n",
        " 'BRO': 410,\n",
        " 'BRS': 920,\n",
        " 'BRU': 19960,\n",
        " 'BRW': 110,\n",
        " 'BSB': 1920,\n",
        " 'BSK': 200,\n",
        " 'BSL': 1860,\n",
        " 'BSR': 730,\n",
        " 'BTH': 0,\n",
        " 'BTK': 20,\n",
        " 'BTM': 160,\n",
        " 'BTR': 1580,\n",
        " 'BTS': 20,\n",
        " 'BTU': 280,\n",
        " 'BTV': 1450,\n",
        " 'BUA': 20,\n",
        " 'BUD': 9480,\n",
        " 'BUF': 4580,\n",
        " 'BUL': 10,\n",
        " 'BUN': 0,\n",
        " 'BUQ': 1340,\n",
        " 'BUR': 2230,\n",
        " 'BUS': 290,\n",
        " 'BVB': 30,\n",
        " 'BVC': 180,\n",
        " 'BVE': 50,\n",
        " 'BWI': 13060,\n",
        " 'BWN': 320,\n",
        " 'BWT': 30,\n",
        " 'BXU': 30,\n",
        " 'BYC': 50,\n",
        " 'BZE': 1450,\n",
        " 'BZG': 40,\n",
        " 'BZN': 1400,\n",
        " 'BZO': 0,\n",
        " 'BZV': 1080,\n",
        " 'CAB': 160,\n",
        " 'CAE': 2320,\n",
        " 'CAG': 2160,\n",
        " 'CAI': 23090,\n",
        " 'CAK': 1530,\n",
        " 'CAL': 40,\n",
        " 'CAN': 10690,\n",
        " 'CAY': 510,\n",
        " 'CBB': 60,\n",
        " 'CBG': 0,\n",
        " 'CBH': 50,\n",
        " 'CBO': 60,\n",
        " 'CBQ': 100,\n",
        " 'CBR': 4440,\n",
        " 'CBT': 140,\n",
        " 'CCJ': 5430,\n",
        " 'CCP': 1890,\n",
        " 'CCS': 7210,\n",
        " 'CCU': 8550,\n",
        " 'CDG': 58080,\n",
        " 'CDV': 10,\n",
        " 'CEB': 2580,\n",
        " 'CEC': 10,\n",
        " 'CED': 0,\n",
        " 'CEG': 60,\n",
        " 'CEI': 660,\n",
        " 'CEK': 870,\n",
        " 'CEN': 240,\n",
        " 'CFE': 600,\n",
        " 'CFK': 60,\n",
        " 'CFN': 20,\n",
        " 'CFR': 110,\n",
        " 'CFS': 450,\n",
        " 'CFU': 620,\n",
        " 'CGB': 190,\n",
        " 'CGD': -30,\n",
        " 'CGH': 3360,\n",
        " 'CGI': 50,\n",
        " 'CGK': 10140,\n",
        " 'CGN': 5230,\n",
        " 'CGO': 680,\n",
        " 'CGP': 1210,\n",
        " 'CGQ': 560,\n",
        " 'CGR': 260,\n",
        " 'CGY': 240,\n",
        " 'CHA': 990,\n",
        " 'CHC': 4260,\n",
        " 'CHO': 860,\n",
        " 'CHQ': 1040,\n",
        " 'CHS': 4050,\n",
        " 'CHU': 10,\n",
        " 'CIC': 60,\n",
        " 'CID': 820,\n",
        " 'CIJ': 20,\n",
        " 'CIT': 340,\n",
        " 'CIU': 20,\n",
        " 'CIX': 640,\n",
        " 'CIY': 30,\n",
        " 'CJA': 290,\n",
        " 'CJB': 980,\n",
        " 'CJC': 1510,\n",
        " 'CJJ': 0,\n",
        " 'CJS': 550,\n",
        " 'CJU': 340,\n",
        " 'CKG': 820,\n",
        " 'CKS': 70,\n",
        " 'CKY': 1080,\n",
        " 'CLD': 80,\n",
        " 'CLE': 7300,\n",
        " 'CLJ': 750,\n",
        " 'CLL': 230,\n",
        " 'CLO': 5680,\n",
        " 'CLQ': 80,\n",
        " 'CLT': 16512,\n",
        " 'CLY': 290,\n",
        " 'CMB': 10230,\n",
        " 'CME': 410,\n",
        " 'CMF': 20,\n",
        " 'CMG': 10,\n",
        " 'CMH': 7300,\n",
        " 'CMI': 250,\n",
        " 'CMN': 11570,\n",
        " 'CMW': 0,\n",
        " 'CMX': 90,\n",
        " 'CND': 40,\n",
        " 'CNF': 2280,\n",
        " 'CNJ': 30,\n",
        " 'CNM': 20,\n",
        " 'CNQ': 140,\n",
        " 'CNS': 3240,\n",
        " 'CNX': 3450,\n",
        " 'CNY': 10,\n",
        " 'COD': 10,\n",
        " 'COK': 9500,\n",
        " 'COO': 990,\n",
        " 'COQ': 20,\n",
        " 'COR': 1810,\n",
        " 'COS': 2510,\n",
        " 'COU': 190,\n",
        " 'CPC': 340,\n",
        " 'CPD': 30,\n",
        " 'CPE': 420,\n",
        " 'CPH': 18810,\n",
        " 'CPO': 1040,\n",
        " 'CPQ': -20,\n",
        " 'CPR': 370,\n",
        " 'CPT': 13110,\n",
        " 'CRD': 690,\n",
        " 'CRI': 10,\n",
        " 'CRK': 170,\n",
        " 'CRL': 100,\n",
        " 'CRP': 700,\n",
        " 'CRW': 820,\n",
        " 'CSG': 330,\n",
        " 'CSX': 390,\n",
        " 'CSY': 20,\n",
        " 'CTA': 7090,\n",
        " 'CTC': 20,\n",
        " 'CTG': 6060,\n",
        " 'CTL': 10,\n",
        " 'CTM': 40,\n",
        " 'CTS': 2260,\n",
        " 'CTU': 1580,\n",
        " 'CUC': 1110,\n",
        " 'CUE': 910,\n",
        " 'CUL': 590,\n",
        " 'CUM': 10,\n",
        " 'CUN': 34980,\n",
        " 'CUR': 3220,\n",
        " 'CUU': 1040,\n",
        " 'CUZ': 3750,\n",
        " 'CVG': 6100,\n",
        " 'CVM': 70,\n",
        " 'CWA': 290,\n",
        " 'CWB': 950,\n",
        " 'CWC': 0,\n",
        " 'CWL': 240,\n",
        " 'CXB': 20,\n",
        " 'CXI': 0,\n",
        " 'CXJ': 10,\n",
        " 'CXR': -120,\n",
        " 'CYB': 60,\n",
        " 'CYS': 90,\n",
        " 'CYZ': 10,\n",
        " 'CZE': 30,\n",
        " 'CZL': 1730,\n",
        " 'CZM': 1620,\n",
        " 'CZX': 0,\n",
        " 'DAB': 1260,\n",
        " 'DAC': 10700,\n",
        " 'DAD': 660,\n",
        " 'DAL': 1340,\n",
        " 'DAM': 90,\n",
        " 'DAR': 3140,\n",
        " 'DAY': 3240,\n",
        " 'DBO': 160,\n",
        " 'DBQ': 60,\n",
        " 'DBV': 1460,\n",
        " 'DCA': 27550,\n",
        " 'DCM': 60,\n",
        " 'DCN': 20,\n",
        " 'DDG': 20,\n",
        " 'DEA': 110,\n",
        " 'DEC': 40,\n",
        " 'DED': 760,\n",
        " 'DEL': 32150,\n",
        " 'DEN': 30700,\n",
        " 'DFW': 41250,\n",
        " 'DGE': 60,\n",
        " 'DGO': 410,\n",
        " 'DGT': 180,\n",
        " 'DHM': 30,\n",
        " 'DHN': 370,\n",
        " 'DIB': 260,\n",
        " 'DIE': 30,\n",
        " 'DIG': 0,\n",
        " 'DIJ': 20,\n",
        " 'DIK': 160,\n",
        " 'DIL': 80,\n",
        " 'DIR': 160,\n",
        " 'DIU': 90,\n",
        " 'DIY': 540,\n",
        " 'DJE': 1530,\n",
        " 'DKR': 3870,\n",
        " 'DLA': 1030,\n",
        " 'DLC': 1170,\n",
        " 'DLG': 60,\n",
        " 'DLH': 460,\n",
        " 'DLM': 560,\n",
        " 'DLZ': 10,\n",
        " 'DMB': 20,\n",
        " 'DME': 12320,\n",
        " 'DMM': 7020,\n",
        " 'DMS': 180,\n",
        " 'DMU': 190,\n",
        " 'DND': 20,\n",
        " 'DNK': 600,\n",
        " 'DNZ': 150,\n",
        " 'DOH': 11350,\n",
        " 'DOK': 1020,\n",
        " 'DOM': 130,\n",
        " 'DPL': -10,\n",
        " 'DPO': 190,\n",
        " 'DPS': 10380,\n",
        " 'DQA': 40,\n",
        " 'DRO': 630,\n",
        " 'DRS': 1370,\n",
        " 'DRT': 40,\n",
        " 'DRW': 1400,\n",
        " 'DSM': 2910,\n",
        " 'DTM': 140,\n",
        " 'DTW': 17170,\n",
        " 'DUB': 11740,\n",
        " 'DUD': 1150,\n",
        " 'DUR': 6550,\n",
        " 'DUS': 16810,\n",
        " 'DUT': 80,\n",
        " 'DVL': 10,\n",
        " 'DVO': 430,\n",
        " 'DWC': 60,\n",
        " 'DWD': 10,\n",
        " 'DXB': 52230,\n",
        " 'DYG': 0,\n",
        " 'DYU': 430,\n",
        " 'DZA': 450,\n",
        " 'DZN': 10,\n",
        " 'EAM': 930,\n",
        " 'EAR': 90,\n",
        " 'EAS': 350,\n",
        " 'EAT': 160,\n",
        " 'EAU': 40,\n",
        " 'EBB': 2480,\n",
        " 'EBJ': 30,\n",
        " 'EBL': 910,\n",
        " 'ECN': 590,\n",
        " 'ECP': 980,\n",
        " 'EDI': 4580,\n",
        " 'EDL': 170,\n",
        " 'EFL': 80,\n",
        " 'EGC': 10,\n",
        " 'EGE': 560,\n",
        " 'EGM': 0,\n",
        " 'EGO': 50,\n",
        " 'EIN': 20,\n",
        " 'EIS': 360,\n",
        " 'EJA': 350,\n",
        " 'EJH': 20,\n",
        " 'EKO': 20,\n",
        " 'ELD': 0,\n",
        " 'ELH': 200,\n",
        " 'ELM': 380,\n",
        " 'ELP': 3070,\n",
        " 'ELQ': 450,\n",
        " 'ELS': 1340,\n",
        " 'ELU': 60,\n",
        " 'EMA': 140,\n",
        " 'EMD': 410,\n",
        " 'ENA': 170,\n",
        " 'ENU': 130,\n",
        " 'EOH': 340,\n",
        " 'EPR': 150,\n",
        " 'EQS': 20,\n",
        " 'ERC': 0,\n",
        " 'ERI': 280,\n",
        " 'ERS': 10,\n",
        " 'ERZ': 30,\n",
        " 'ESB': 3140,\n",
        " 'ESC': 60,\n",
        " 'ESM': 150,\n",
        " 'ESU': 20,\n",
        " 'ETH': 390,\n",
        " 'ETR': 110,\n",
        " 'ETZ': 190,\n",
        " 'EUG': 840,\n",
        " 'EUN': 50,\n",
        " 'EVE': 320,\n",
        " 'EVN': 2380,\n",
        " 'EVV': 530,\n",
        " 'EWN': 320,\n",
        " 'EWR': 33520,\n",
        " 'EXT': 170,\n",
        " 'EYP': 560,\n",
        " 'EYW': 1690,\n",
        " 'EZE': 10130,\n",
        " 'EZS': 20,\n",
        " 'FAE': 200,\n",
        " 'FAI': 1780,\n",
        " 'FAO': 1670,\n",
        " 'FAR': 760,\n",
        " 'FAT': 1480,\n",
        " 'FAY': 1360,\n",
        " 'FBM': 410,\n",
        " 'FCA': 210,\n",
        " 'FCO': 39920,\n",
        " 'FDE': 90,\n",
        " 'FDF': 2940,\n",
        " 'FDH': 230,\n",
        " 'FEG': 40,\n",
        " 'FEN': 40,\n",
        " 'FEZ': 230,\n",
        " 'FIH': 910,\n",
        " 'FKB': 170,\n",
        " 'FLA': -20,\n",
        " 'FLG': 350,\n",
        " 'FLL': 28670,\n",
        " 'FLN': 920,\n",
        " 'FLO': 370,\n",
        " 'FLR': 4300,\n",
        " 'FLW': -190,\n",
        " 'FMA': 100,\n",
        " 'FMN': 90,\n",
        " 'FMO': 400,\n",
        " 'FNA': 550,\n",
        " 'FNC': 2910,\n",
        " 'FNJ': 20,\n",
        " 'FNT': 500,\n",
        " 'FOC': 1230,\n",
        " 'FOR': 860,\n",
        " 'FPO': 1160,\n",
        " 'FRA': 30190,\n",
        " 'FRO': 360,\n",
        " 'FRS': 270,\n",
        " 'FRU': 1030,\n",
        " 'FRW': 160,\n",
        " 'FSC': 860,\n",
        " 'FSD': 1290,\n",
        " 'FSM': 290,\n",
        " 'FSP': 20,\n",
        " 'FSZ': 0,\n",
        " 'FTE': 980,\n",
        " 'FTU': 140,\n",
        " 'FUE': 1760,\n",
        " 'FUK': 860,\n",
        " 'FUN': 0,\n",
        " 'FUT': 20,\n",
        " 'FWA': 800,\n",
        " 'GAU': 1400,\n",
        " 'GAY': 30,\n",
        " 'GBE': 640,\n",
        " 'GCC': 100,\n",
        " 'GCI': 500,\n",
        " 'GCK': 30,\n",
        " 'GCM': 1730,\n",
        " 'GDE': 10,\n",
        " 'GDL': 7790,\n",
        " 'GDN': 2300,\n",
        " 'GDQ': 90,\n",
        " 'GDX': 60,\n",
        " 'GDZ': 230,\n",
        " 'GEG': 3730,\n",
        " 'GEO': 1980,\n",
        " 'GES': 110,\n",
        " 'GET': 400,\n",
        " 'GEV': 130,\n",
        " 'GFF': 70,\n",
        " 'GFK': 320,\n",
        " 'GFN': 20,\n",
        " 'GGA': 40,\n",
        " 'GGG': 20,\n",
        " 'GGT': 310,\n",
        " 'GGW': 20,\n",
        " 'GHA': 90,\n",
        " 'GHB': 20,\n",
        " 'GIB': 140,\n",
        " 'GIG': 8920,\n",
        " 'GIS': 210,\n",
        " 'GIZ': 1000,\n",
        " 'GJL': 10,\n",
        " 'GJT': 660,\n",
        " 'GKA': 80,\n",
        " 'GLA': 3330,\n",
        " 'GLH': 0,\n",
        " 'GLN': 40,\n",
        " 'GLT': 960,\n",
        " 'GMB': 40,\n",
        " 'GMP': 1510,\n",
        " 'GMR': 20,\n",
        " 'GMZ': 40,\n",
        " 'GND': 320,\n",
        " 'GNV': 650,\n",
        " 'GNY': 70,\n",
        " 'GOA': 1700,\n",
        " 'GOH': 40,\n",
        " 'GOI': 3450,\n",
        " 'GOJ': 680,\n",
        " 'GOP': 90,\n",
        " 'GOT': 4550,\n",
        " 'GOU': 30,\n",
        " 'GOV': 140,\n",
        " 'GPS': 800,\n",
        " 'GPT': 1500,\n",
        " 'GRB': 810,\n",
        " 'GRI': 80,\n",
        " 'GRJ': 800,\n",
        " 'GRK': 810,\n",
        " 'GRO': 60,\n",
        " 'GRR': 3040,\n",
        " 'GRU': 12780,\n",
        " 'GRV': 20,\n",
        " 'GRW': 60,\n",
        " 'GRX': 970,\n",
        " 'GRZ': 700,\n",
        " 'GSO': 3240,\n",
        " 'GSP': 2580,\n",
        " 'GST': 50,\n",
        " 'GTE': 30,\n",
        " 'GTF': 410,\n",
        " 'GTR': 140,\n",
        " 'GUA': 4130,\n",
        " 'GUC': 90,\n",
        " 'GUM': 1850,\n",
        " 'GUR': 70,\n",
        " 'GUW': 790,\n",
        " 'GVA': 12340,\n",
        " 'GWL': 0,\n",
        " 'GWT': 200,\n",
        " 'GXF': 80,\n",
        " 'GYD': 2720,\n",
        " 'GYE': 6350,\n",
        " 'GYN': 600,\n",
        " 'GZP': 180,\n",
        " 'GZT': 310,\n",
        " 'HAD': 100,\n",
        " 'HAH': 170,\n",
        " 'HAJ': 4960,\n",
        " 'HAK': 140,\n",
        " 'HAM': 14910,\n",
        " 'HAN': 3900,\n",
        " 'HAS': 720,\n",
        " 'HAU': 820,\n",
        " 'HAV': 6000,\n",
        " 'HBA': 2110,\n",
        " 'HBE': 2900,\n",
        " 'HCR': 20,\n",
        " 'HDG': -20,\n",
        " 'HDN': 260,\n",
        " 'HDS': 90,\n",
        " 'HDY': 550,\n",
        " 'HEA': 40,\n",
        " 'HEL': 11200,\n",
        " 'HER': 3520,\n",
        " 'HET': 10,\n",
        " 'HFE': 130,\n",
        " 'HFS': 10,\n",
        " 'HFT': 340,\n",
        " 'HGA': 20,\n",
        " 'HGH': 1520,\n",
        " 'HGR': 20,\n",
        " 'HGU': 320,\n",
        " 'HHH': 550,\n",
        " 'HID': 90,\n",
        " 'HIJ': 180,\n",
        " 'HIN': 30,\n",
        " 'HIR': 190,\n",
        " 'HJJ': 0,\n",
        " 'HJR': 130,\n",
        " 'HKD': 20,\n",
        " 'HKG': 28750,\n",
        " 'HKK': 60,\n",
        " 'HKN': 40,\n",
        " 'HKT': 11160,\n",
        " 'HLA': 860,\n",
        " 'HLD': 0,\n",
        " 'HLM': 120,\n",
        " 'HLN': 130,\n",
        " 'HLZ': 220,\n",
        " 'HMA': 50,\n",
        " 'HMB': 240,\n",
        " 'HME': 330,\n",
        " 'HMO': 1010,\n",
        " 'HMV': 20,\n",
        " 'HND': 2900,\n",
        " 'HNL': 21540,\n",
        " 'HOB': 10,\n",
        " 'HOD': 60,\n",
        " 'HOF': 20,\n",
        " 'HOG': 90,\n",
        " 'HOM': 30,\n",
        " 'HOR': 40,\n",
        " 'HOU': 3540,\n",
        " 'HOV': 170,\n",
        " 'HPH': 20,\n",
        " 'HPN': 1560,\n",
        " 'HRB': 360,\n",
        " 'HRE': 1580,\n",
        " 'HRG': 1170,\n",
        " 'HRI': 0,\n",
        " 'HRK': 220,\n",
        " 'HRL': 310,\n",
        " 'HSL': 0,\n",
        " 'HSN': 10,\n",
        " 'HSV': 1850,\n",
        " 'HTA': 130,\n",
        " 'HTI': 420,\n",
        " 'HTS': 130,\n",
        " 'HTY': 190,\n",
        " 'HUE': 10,\n",
        " 'HUH': 70,\n",
        " 'HUI': 40,\n",
        " 'HUU': 20,\n",
        " 'HUX': 120,\n",
        " 'HUY': 150,\n",
        " 'HVB': 160,\n",
        " 'HVG': 0,\n",
        " 'HVN': 140,\n",
        " 'HYD': 10790,\n",
        " 'HYN': 10,\n",
        " 'HYS': 20,\n",
        " 'IAD': 17960,\n",
        " 'IAH': 26730,\n",
        " 'IAM': 20,\n",
        " 'IAS': 680,\n",
        " 'IBA': 20,\n",
        " 'IBE': 410,\n",
        " 'IBZ': 3090,\n",
        " 'ICN': 16980,\n",
        " 'ICT': 2130,\n",
        " 'IDA': 250,\n",
        " 'IDR': 1440,\n",
        " 'IEV': 1280,\n",
        " 'IFN': -20,\n",
        " 'IFO': 40,\n",
        " 'IGD': 0,\n",
        " 'IGR': 2020,\n",
        " 'IGU': 2130,\n",
        " 'IKA': 2790,\n",
        " 'IKT': 510,\n",
        " 'ILD': 10,\n",
        " 'ILG': 60,\n",
        " 'ILM': 1220,\n",
        " 'ILO': 240,\n",
        " 'ILY': 0,\n",
        " 'IMF': 510,\n",
        " 'IMP': 180,\n",
        " 'IMT': 40,\n",
        " 'INC': 20,\n",
        " 'IND': 7940,\n",
        " 'INH': 70,\n",
        " 'INI': 80,\n",
        " 'INL': 30,\n",
        " 'INN': 570,\n",
        " 'INV': 290,\n",
        " 'IOA': 110,\n",
        " 'IOM': 160,\n",
        " 'IOS': 110,\n",
        " 'IPC': 390,\n",
        " 'IPH': 0,\n",
        " 'IPN': 0,\n",
        " 'IPT': 130,\n",
        " 'IQQ': 950,\n",
        " 'IQT': 1000,\n",
        " 'IRJ': 0,\n",
        " 'ISA': 520,\n",
        " 'ISB': 7430,\n",
        " 'ISE': 10,\n",
        " 'ISG': 90,\n",
        " 'ISN': 270,\n",
        " 'ISP': 540,\n",
        " 'IST': 41490,\n",
        " 'ISU': 260,\n",
        " 'ITH': 380,\n",
        " 'ITM': 600,\n",
        " 'ITO': 860,\n",
        " 'IUE': 180,\n",
        " 'IVC': 210,\n",
        " 'IVL': 370,\n",
        " 'IWK': 10,\n",
        " 'IXA': 310,\n",
        " 'IXB': 1000,\n",
        " 'IXC': 1260,\n",
        " 'IXD': 30,\n",
        " 'IXE': 1960,\n",
        " 'IXJ': 290,\n",
        " 'IXL': 300,\n",
        " 'IXM': 800,\n",
        " 'IXR': 570,\n",
        " 'IXS': 370,\n",
        " 'IXU': 830,\n",
        " 'IXZ': 630,\n",
        " 'IYK': 40,\n",
        " 'JAC': 1260,\n",
        " 'JAI': 1910,\n",
        " 'JAL': 80,\n",
        " 'JAN': 1490,\n",
        " 'JAV': 10,\n",
        " 'JAX': 7420,\n",
        " 'JBR': 20,\n",
        " 'JDH': 620,\n",
        " 'JED': 25300,\n",
        " 'JER': 980,\n",
        " 'JFK': 60060,\n",
        " 'JGA': 240,\n",
        " 'JHB': 170,\n",
        " 'JHG': 60,\n",
        " 'JHM': 230,\n",
        " 'JHS': 30,\n",
        " 'JIB': 330,\n",
        " 'JIJ': 30,\n",
        " 'JIK': 0,\n",
        " 'JJN': 170,\n",
        " 'JKG': 110,\n",
        " 'JKH': 450,\n",
        " 'JKL': 40,\n",
        " 'JLN': 80,\n",
        " 'JLR': 40,\n",
        " 'JMK': 900,\n",
        " 'JMU': -10,\n",
        " 'JNB': 21240,\n",
        " 'JNU': 480,\n",
        " 'JNX': 10,\n",
        " 'JOE': 80,\n",
        " 'JOG': 0,\n",
        " 'JOI': 60,\n",
        " 'JOS': 10,\n",
        " 'JPA': 70,\n",
        " 'JQA': 10,\n",
        " 'JRH': 70,\n",
        " 'JRO': 1380,\n",
        " 'JSI': -10,\n",
        " 'JST': 60,\n",
        " 'JSY': 20,\n",
        " 'JTC': 0,\n",
        " 'JTR': 1860,\n",
        " 'JTY': 40,\n",
        " 'JUB': 770,\n",
        " 'JUJ': 240,\n",
        " 'JUL': 390,\n",
        " 'JYV': 60,\n",
        " 'JZH': 50,\n",
        " 'KAC': 0,\n",
        " 'KAD': 10,\n",
        " 'KAJ': 80,\n",
        " 'KAN': 100,\n",
        " 'KAO': 260,\n",
        " 'KBL': 1420,\n",
        " 'KBP': 8140,\n",
        " 'KBR': 380,\n",
        " 'KBV': 2080,\n",
        " 'KCH': 770,\n",
        " 'KCM': 30,\n",
        " 'KDV': 200,\n",
        " 'KEF': 4030,\n",
        " 'KEJ': 260,\n",
        " 'KEM': 90,\n",
        " 'KGC': 60,\n",
        " 'KGD': 910,\n",
        " 'KGF': 140,\n",
        " 'KGI': 670,\n",
        " 'KGL': 1060,\n",
        " 'KGP': 10,\n",
        " 'KGS': 480,\n",
        " 'KGT': 20,\n",
        " 'KHG': 130,\n",
        " 'KHH': 1490,\n",
        " 'KHI': 4600,\n",
        " 'KHN': 90,\n",
        " 'KHS': 110,\n",
        " 'KHV': 1120,\n",
        " 'KID': 40,\n",
        " 'KIJ': 20,\n",
        " 'KIM': 510,\n",
        " 'KIN': 2760,\n",
        " 'KIS': 490,\n",
        " 'KIT': 40,\n",
        " 'KIV': 2230,\n",
        " 'KIX': 4210,\n",
        " 'KJA': 1100,\n",
        " 'KKC': 840,\n",
        " 'KKE': 10,\n",
        " 'KKJ': -20,\n",
        " 'KKN': 330,\n",
        " 'KLO': 90,\n",
        " 'KLR': 80,\n",
        " 'KLU': 170,\n",
        " 'KLV': 40,\n",
        " 'KLX': 0,\n",
        " 'KME': 160,\n",
        " 'KMG': 1000,\n",
        " 'KMI': 30,\n",
        " 'KMJ': 0,\n",
        " 'KMQ': 30,\n",
        " 'KMS': 20,\n",
        " 'KNS': 60,\n",
        " 'KNU': 30,\n",
        " 'KNX': 250,\n",
        " 'KOA': 6240,\n",
        " 'KOE': 80,\n",
        " 'KOI': 90,\n",
        " 'KOJ': 80,\n",
        " 'KOK': 140,\n",
        " 'KOZ': 20,\n",
        " 'KPO': 10,\n",
        " 'KRF': 20,\n",
        " 'KRK': 3000,\n",
        " 'KRN': 800,\n",
        " 'KRO': 60,\n",
        " 'KRP': 60,\n",
        " 'KRR': 2940,\n",
        " 'KRS': 920,\n",
        " 'KRT': 3010,\n",
        " 'KSA': 40,\n",
        " 'KSC': 450,\n",
        " 'KSD': 100,\n",
        " 'KSH': 50,\n",
        " 'KSM': 30,\n",
        " 'KSN': -20,\n",
        " 'KSQ': 10,\n",
        " 'KSU': 440,\n",
        " 'KSY': 60,\n",
        " 'KTA': 2150,\n",
        " 'KTE': 30,\n",
        " 'KTL': 0,\n",
        " 'KTM': 5970,\n",
        " 'KTN': 250,\n",
        " 'KTT': 260,\n",
        " 'KTW': 440,\n",
        " 'KUA': 180,\n",
        " 'KUF': 1690,\n",
        " 'KUH': 10,\n",
        " 'KUK': 30,\n",
        " 'KUL': 16670,\n",
        " 'KUN': 0,\n",
        " 'KUO': 310,\n",
        " 'KUS': 0,\n",
        " 'KUT': 20,\n",
        " 'KUU': -40,\n",
        " 'KVA': 210,\n",
        " 'KVD': 50,\n",
        " 'KVG': 30,\n",
        " 'KVL': 10,\n",
        " 'KVX': 20,\n",
        " 'KWA': 20,\n",
        " 'KWE': 130,\n",
        " 'KWG': 20,\n",
        " 'KWI': 7060,\n",
        " 'KWJ': 90,\n",
        " 'KWL': 210,\n",
        " 'KWN': 10,\n",
        " 'KYA': 70,\n",
        " 'KZN': 810,\n",
        " 'KZO': 310,\n",
        " 'KZR': 10,\n",
        " 'KZS': 40,\n",
        " 'LAD': 3270,\n",
        " 'LAE': 360,\n",
        " 'LAI': 70,\n",
        " 'LAN': 630,\n",
        " 'LAO': 270,\n",
        " 'LAP': 200,\n",
        " 'LAQ': 80,\n",
        " 'LAR': 20,\n",
        " 'LAS': 63190,\n",
        " 'LAU': -40,\n",
        " 'LAW': 240,\n",
        " 'LAX': 64230,\n",
        " 'LBA': 760,\n",
        " 'LBB': 760,\n",
        " 'LBD': 200,\n",
        " 'LBE': 30,\n",
        " 'LBF': -20,\n",
        " 'LBL': -10,\n",
        " 'LBS': 140,\n",
        " 'LBU': 390,\n",
        " 'LBV': 880,\n",
        " 'LCA': 4320,\n",
        " 'LCE': 40,\n",
        " 'LCG': 1120,\n",
        " 'LCH': 240,\n",
        " 'LCY': 7030,\n",
        " 'LDB': 410,\n",
        " 'LDE': 220,\n",
        " 'LDH': -10,\n",
        " 'LDU': 210,\n",
        " 'LEA': 310,\n",
        " 'LEB': 70,\n",
        " 'LED': 14220,\n",
        " 'LEH': 40,\n",
        " 'LEI': 470,\n",
        " 'LEJ': 990,\n",
        " 'LEN': -20,\n",
        " 'LET': 110,\n",
        " 'LEX': 1020,\n",
        " 'LFR': 40,\n",
        " 'LFT': 880,\n",
        " 'LFW': 290,\n",
        " 'LGA': 39302,\n",
        " 'LGB': 2000,\n",
        " 'LGK': 720,\n",
        " 'LGP': 40,\n",
        " 'LGQ': 510,\n",
        " 'LGW': 7700,\n",
        " 'LHE': 6320,\n",
        " 'LHR': 81439,\n",
        " 'LHW': 70,\n",
        " 'LIG': 80,\n",
        " 'LIH': 4470,\n",
        " 'LIL': 1150,\n",
        " 'LIM': 18420,\n",
        " 'LIN': 13520,\n",
        " 'LIR': 1680,\n",
        " 'LIS': 21230,\n",
        " 'LIT': 3040,\n",
        " 'LJG': 30,\n",
        " 'LJU': 1370,\n",
        " 'LKG': 20,\n",
        " 'LKL': 20,\n",
        " 'LKN': 170,\n",
        " 'LKO': 3360,\n",
        " 'LLA': 620,\n",
        " 'LLI': 40,\n",
        " 'LLW': 890,\n",
        " 'LMM': 150,\n",
        " 'LMN': 40,\n",
        " 'LMP': 170,\n",
        " 'LMT': 60,\n",
        " 'LNK': 520,\n",
        " 'LNY': 210,\n",
        " 'LNZ': 420,\n",
        " 'LOH': 110,\n",
        " 'LOK': 80,\n",
        " 'LOP': 280,\n",
        " 'LOS': 4520,\n",
        " 'LPA': 6060,\n",
        " 'LPB': 1270,\n",
        " 'LPI': 250,\n",
        " 'LPK': 10,\n",
        " 'LPL': 120,\n",
        " 'LPP': 30,\n",
        " 'LPQ': 510,\n",
        " 'LPT': 70,\n",
        " 'LRD': 230,\n",
        " 'LRE': 20,\n",
        " 'LRH': 40,\n",
        " 'LRM': 230,\n",
        " 'LRR': 0,\n",
        " 'LRS': 50,\n",
        " 'LRT': 220,\n",
        " 'LSA': 0,\n",
        " 'LSC': 450,\n",
        " 'LSE': 150,\n",
        " 'LSI': 170,\n",
        " 'LSP': 260,\n",
        " 'LST': 380,\n",
        " 'LTK': 40,\n",
        " 'LTN': 390,\n",
        " 'LTO': 130,\n",
        " 'LTX': 50,\n",
        " 'LUD': 0,\n",
        " 'LUG': 10,\n",
        " 'LUH': 20,\n",
        " 'LUM': 0,\n",
        " 'LUN': 1520,\n",
        " 'LUO': 80,\n",
        " 'LUQ': 80,\n",
        " 'LUX': 3090,\n",
        " 'LVI': 420,\n",
        " 'LWB': 100,\n",
        " 'LWO': 850,\n",
        " 'LWS': 70,\n",
        " 'LWY': 50,\n",
        " 'LXA': 50,\n",
        " 'LXG': 0,\n",
        " 'LXR': 400,\n",
        " 'LXS': 280,\n",
        " 'LYA': 20,\n",
        " 'LYC': 40,\n",
        " 'LYG': 0,\n",
        " 'LYH': 300,\n",
        " 'LYP': 140,\n",
        " 'LYR': 340,\n",
        " 'LYS': 8820,\n",
        " 'LZC': 80,\n",
        " 'LZH': 120,\n",
        " 'MAA': 14110,\n",
        " 'MAB': 100,\n",
        " 'MAD': 37850,\n",
        " 'MAF': 750,\n",
        " 'MAG': 140,\n",
        " 'MAH': 1000,\n",
        " 'MAJ': 10,\n",
        " 'MAM': 270,\n",
        " 'MAN': 8790,\n",
        " 'MAO': 710,\n",
        " 'MAR': 1160,\n",
        " 'MAS': 40,\n",
        " 'MAU': 0,\n",
        " 'MBA': 2530,\n",
        " 'MBI': 60,\n",
        " 'MBJ': 9080,\n",
        " 'MBS': 180,\n",
        " 'MCE': 0,\n",
        " 'MCI': 9550,\n",
        " 'MCK': 20,\n",
        " 'MCN': 20,\n",
        " 'MCO': 62290,\n",
        " 'MCP': 90,\n",
        " 'MCT': 6110,\n",
        " 'MCW': 40,\n",
        " 'MCX': 40,\n",
        " 'MCY': 240,\n",
        " 'MCZ': 40,\n",
        " 'MDC': 140,\n",
        " 'MDE': 6300,\n",
        " 'MDG': 90,\n",
        " 'MDL': 0,\n",
        " 'MDQ': 240,\n",
        " 'MDT': 2410,\n",
        " 'MDW': 3500,\n",
        " 'MDZ': 1730,\n",
        " 'MEC': 380,\n",
        " 'MED': 3210,\n",
        " 'MEH': 30,\n",
        " 'MEI': 20,\n",
        " 'MEL': 21990,\n",
        " 'MEM': 6170,\n",
        " 'MES': 220,\n",
        " 'MEX': 26400,\n",
        " 'MFE': 980,\n",
        " 'MFM': 2160,\n",
        " 'MFR': 640,\n",
        " 'MGA': 2340,\n",
        " 'MGB': 180,\n",
        " 'MGF': -10,\n",
        " 'MGM': 500,\n",
        " 'MGQ': 240,\n",
        " 'MGW': 20,\n",
        " 'MHC': 40,\n",
        " 'MHD': 660,\n",
        " 'MHH': 20,\n",
        " 'MHK': 180,\n",
        " 'MHQ': 80,\n",
        " 'MHT': 1760,\n",
        " 'MIA': 53020,\n",
        " 'MID': 920,\n",
        " 'MIM': 10,\n",
        " 'MIR': 910,\n",
        " 'MJF': 110,\n",
        " 'MJN': 0,\n",
        " 'MJT': 940,\n",
        " 'MJV': 110,\n",
        " 'MKE': 6870,\n",
        " 'MKG': 10,\n",
        " 'MKK': 80,\n",
        " 'MKM': 20,\n",
        " 'MKY': 770,\n",
        " 'MLA': 6530,\n",
        " 'MLB': 780,\n",
        " 'MLE': 4240,\n",
        " 'MLH': 530,\n",
        " 'MLI': 870,\n",
        " 'MLM': 300,\n",
        " 'MLN': 500,\n",
        " 'MLO': 100,\n",
        " 'MLU': 400,\n",
        " 'MLW': 10,\n",
        " 'MLX': 50,\n",
        " 'MME': 160,\n",
        " 'MMH': 20,\n",
        " 'MMK': 850,\n",
        " 'MMO': 100,\n",
        " 'MMU': 20,\n",
        " 'MMX': 1610,\n",
        " 'MNG': 20,\n",
        " 'MNL': 28920,\n",
        " 'MOB': 960,\n",
        " 'MOD': 40,\n",
        " 'MOL': 240,\n",
        " 'MOQ': 230,\n",
        " 'MOT': 570,\n",
        " 'MOV': 510,\n",
        " 'MOZ': -80,\n",
        " 'MPH': 80,\n",
        " 'MPL': 1140,\n",
        " 'MPM': 1590,\n",
        " 'MPN': 0,\n",
        " 'MQF': 140,\n",
        " 'MQL': 230,\n",
        " 'MQM': 230,\n",
        " 'MQN': 180,\n",
        " 'MQP': 520,\n",
        " 'MQT': 100,\n",
        " 'MQX': 300,\n",
        " 'MRA': 360,\n",
        " 'MRS': 9220,\n",
        " 'MRU': 8110,\n",
        " 'MRV': 1760,\n",
        " 'MRY': 640,\n",
        " 'MRZ': 50,\n",
        " 'MSE': 20,\n",
        " 'MSJ': 30,\n",
        " 'MSL': 10,\n",
        " 'MSN': 2430,\n",
        " 'MSO': 560,\n",
        " 'MSP': 19300,\n",
        " 'MSQ': 2550,\n",
        " 'MSR': 0,\n",
        " 'MSS': 20,\n",
        " 'MSU': 800,\n",
        " 'MSY': 14790,\n",
        " 'MSZ': 10,\n",
        " 'MTJ': 220,\n",
        " 'MTR': 1050,\n",
        " 'MTS': 190,\n",
        " 'MTT': 240,\n",
        " 'MTY': 4470,\n",
        " 'MUA': -60,\n",
        " 'MUB': 400,\n",
        " 'MUC': 29410,\n",
        " 'MUN': 500,\n",
        " 'MUR': 40,\n",
        " 'MUX': 250,\n",
        " 'MVD': 2100,\n",
        " 'MVR': 60,\n",
        " 'MVY': 90,\n",
        " 'MWA': 0,\n",
        " 'MWZ': 470,\n",
        " 'MXL': 190,\n",
        " 'MXP': 15770,\n",
        " 'MXX': 10,\n",
        " 'MXZ': 20,\n",
        " 'MYA': 60,\n",
        " 'MYD': 50,\n",
        " 'MYJ': -80,\n",
        " 'MYR': 2750,\n",
        " 'MYW': 120,\n",
        " 'MYY': 980,\n",
        " 'MZH': 40,\n",
        " 'MZL': 320,\n",
        " 'MZT': 840,\n",
        " 'MZV': -350,\n",
        " 'NAA': 30,\n",
        " 'NAG': 930,\n",
        " 'NAJ': 20,\n",
        " 'NAL': 80,\n",
        " 'NAN': 2850,\n",
        " 'NAO': 60,\n",
        " 'NAP': 4080,\n",
        " 'NAS': 5690,\n",
        " 'NAT': 880,\n",
        " 'NAV': 70,\n",
        " 'NBC': 380,\n",
        " 'NBE': 70,\n",
        " 'NBO': 7840,\n",
        " 'NCE': 13830,\n",
        " 'NCL': 1180,\n",
        " 'NCU': 70,\n",
        " 'NCY': 20,\n",
        " 'NDB': 10,\n",
        " 'NDG': 60,\n",
        " 'NDJ': 280,\n",
        " 'NDR': 260,\n",
        " 'NDU': 20,\n",
        " 'NGB': 240,\n",
        " 'NGO': 1790,\n",
        " 'NGS': 10,\n",
        " 'NGY': 0,\n",
        " 'NHA': 120,\n",
        " 'NIM': 460,\n",
        " 'NJC': 300,\n",
        " 'NJF': 400,\n",
        " 'NKC': 730,\n",
        " 'NKG': 1180,\n",
        " 'NLA': 530,\n",
        " 'NLD': 70,\n",
        " 'NLK': 240,\n",
        " 'NMA': 110,\n",
        " 'NNG': 650,\n",
        " 'NNY': 40,\n",
        " 'NOC': 10,\n",
        " 'NOJ': 10,\n",
        " 'NOS': 100,\n",
        " 'NOU': 1270,\n",
        " 'NOV': 40,\n",
        " 'NOZ': 270,\n",
        " 'NPE': 380,\n",
        " 'NPL': 360,\n",
        " 'NQN': 430,\n",
        " 'NQY': 40,\n",
        " 'NRK': 20,\n",
        " 'NRT': 15050,\n",
        " 'NSI': 740,\n",
        " 'NSK': 20,\n",
        " 'NSN': 260,\n",
        " 'NTE': 2440,\n",
        " 'NTG': 0,\n",
        " 'NTL': 510,\n",
        " 'NUE': 2850,\n",
        " 'NUX': 400,\n",
        " 'NVA': 490,\n",
        " 'NVI': 60,\n",
        " 'NVK': 60,\n",
        " 'NVT': 130,\n",
        " 'NWI': 330,\n",
        " 'NYM': 30,\n",
        " 'NYT': 20,\n",
        " 'NZH': 50,\n",
        " 'OAG': 100,\n",
        " 'OAJ': 560,\n",
        " 'OAK': 3370,\n",
        " 'OAX': 650,\n",
        " 'OBO': -60,\n",
        " 'OCC': 360,\n",
        " 'ODS': 1900,\n",
        " 'OER': 130,\n",
        " 'OGG': 7810,\n",
        " 'OGX': 20,\n",
        " 'OGZ': 160,\n",
        " 'OHH': 0,\n",
        " 'OIA': 0,\n",
        " 'OKA': 440,\n",
        " 'OKC': 4600,\n",
        " 'OLB': 1300,\n",
        " 'OLP': 110,\n",
        " 'OMA': 3930,\n",
        " 'OMD': 20,\n",
        " 'OME': 210,\n",
        " 'OMR': 150,\n",
        " 'OMS': 730,\n",
        " 'OND': 110,\n",
        " 'ONT': 2800,\n",
        " 'OOL': 1980,\n",
        " 'OPO': 5600,\n",
        " 'ORB': 10,\n",
        " 'ORD': 50740,\n",
        " 'ORF': 4370,\n",
        " 'ORK': 500,\n",
        " 'ORN': 2820,\n",
        " 'ORU': 10,\n",
        " 'ORY': 30000,\n",
        " 'OSD': 520,\n",
        " 'OSK': -10,\n",
        " 'OSL': 16450,\n",
        " 'OSM': 120,\n",
        " 'OSR': 10,\n",
        " 'OSS': 110,\n",
        " 'OSW': 20,\n",
        " 'OSY': 30,\n",
        " 'OTH': 70,\n",
        " 'OTP': 7430,\n",
        " 'OTZ': 90,\n",
        " 'OUA': 790,\n",
        " 'OUD': 1350,\n",
        " 'OUL': 590,\n",
        " 'OVB': 1600,\n",
        " 'OVD': 1010,\n",
        " 'OXB': 70,\n",
        " 'OZC': 0,\n",
        " 'OZH': 100,\n",
        " 'OZZ': 160,\n",
        " 'PAD': 170,\n",
        " 'PAG': 20,\n",
        " 'PAH': 30,\n",
        " 'PAP': 2370,\n",
        " 'PAS': 100,\n",
        " 'PAT': 1280,\n",
        " 'PAZ': 340,\n",
        " 'PBC': 90,\n",
        " 'PBD': 50,\n",
        " 'PBG': 10,\n",
        " 'PBI': 8040,\n",
        " 'PBM': 1210,\n",
        " 'PBO': 810,\n",
        " 'PCL': 210,\n",
        " 'PDG': 100,\n",
        " 'PDL': 1700,\n",
        " 'PDP': 360,\n",
        " 'PDS': 20,\n",
        " 'PDT': 20,\n",
        " 'PDX': 12170,\n",
        " 'PED': 10,\n",
        " 'PEE': 580,\n",
        " 'PEI': 1790,\n",
        " 'PEK': 21920,\n",
        " 'PEM': 300,\n",
        " 'PEN': 1640,\n",
        " 'PER': 11630,\n",
        " 'PEW': 1620,\n",
        " 'PFO': 170,\n",
        " 'PGA': 0,\n",
        " 'PGF': 250,\n",
        " 'PGV': 140,\n",
        " 'PHC': 770,\n",
        " 'PHE': 1030,\n",
        " 'PHF': 1010,\n",
        " 'PHL': 21580,\n",
        " 'PHO': 30,\n",
        " 'PHW': 60,\n",
        " 'PHX': 27700,\n",
        " 'PIA': 590,\n",
        " 'PIB': 50,\n",
        " 'PIH': 150,\n",
        " 'PIR': 50,\n",
        " 'PIS': 40,\n",
        " 'PIT': 10180,\n",
        " 'PIU': 1130,\n",
        " 'PIX': 290,\n",
        " 'PJG': 20,\n",
        " 'PKB': 40,\n",
        " 'PKC': 660,\n",
        " 'PKE': 70,\n",
        " 'PKU': 40,\n",
        " 'PKZ': 140,\n",
        " 'PLM': 40,\n",
        " 'PLN': 70,\n",
        " 'PLO': 140,\n",
        " 'PLQ': 300,\n",
        " 'PLS': 1580,\n",
        " 'PLU': 140,\n",
        " 'PLX': 20,\n",
        " 'PLZ': 2850,\n",
        " 'PMC': 1210,\n",
        " 'PMI': 12990,\n",
        " 'PMO': 3720,\n",
        " 'PMR': 520,\n",
        " 'PMV': 1960,\n",
        " 'PMW': 50,\n",
        " 'PMY': 40,\n",
        " 'PNA': 250,\n",
        " 'PNH': 1690,\n",
        " 'PNI': 70,\n",
        " 'PNK': 20,\n",
        " 'PNL': 120,\n",
        " 'PNP': 20,\n",
        " 'PNQ': 2360,\n",
        " 'PNR': 760,\n",
        " 'PNS': 3200,\n",
        " 'PNT': 20,\n",
        " 'POA': 1910,\n",
        " 'POL': 410,\n",
        " 'POM': 1380,\n",
        " 'POP': 640,\n",
        " 'POR': 60,\n",
        " 'POS': 3200,\n",
        " 'POZ': 830,\n",
        " 'PPG': 290,\n",
        " 'PPN': 140,\n",
        " 'PPP': 150,\n",
        " 'PPS': 60,\n",
        " 'PPT': 2090,\n",
        " 'PQC': 0,\n",
        " 'PQI': 90,\n",
        " 'PQQ': 300,\n",
        " 'PQS': 20,\n",
        " 'PRG': 13230,\n",
        " 'PRI': 120,\n",
        " 'PRN': 1360,\n",
        " 'PSA': 910,\n",
        " 'PSC': 1170,\n",
        " 'PSE': 40,\n",
        " 'PSG': 10,\n",
        " 'PSO': 800,\n",
        " 'PSP': 3620,\n",
        " 'PSR': 20,\n",
        " 'PSS': 260,\n",
        " 'PTG': 80,\n",
        " 'PTP': 3800,\n",
        " 'PTY': 7510,\n",
        " 'PUB': 20,\n",
        " 'PUF': 960,\n",
        " 'PUJ': 12770,\n",
        " 'PUQ': 810,\n",
        " 'PUS': 2020,\n",
        " 'PUU': 60,\n",
        " 'PUW': 30,\n",
        " 'PUY': 400,\n",
        " 'PVC': 20,\n",
        " 'PVD': 3410,\n",
        " 'PVG': 24350,\n",
        " 'PVH': 50,\n",
        " 'PVK': 0,\n",
        " 'PVR': 5480,\n",
        " 'PWM': 2160,\n",
        " 'PWQ': 180,\n",
        " 'PXM': 80,\n",
        " 'PXO': 200,\n",
        " 'PYH': 20,\n",
        " 'PZB': 170,\n",
        " 'PZH': 10,\n",
        " 'PZO': 1370,\n",
        " 'PZU': 10,\n",
        " 'QDU': 0,\n",
        " 'QJZ': 20,\n",
        " 'QKL': 540,\n",
        " 'QOW': 110,\n",
        " 'QQS': 240,\n",
        " 'QRO': 630,\n",
        " 'QRW': 70,\n",
        " 'QSF': 540,\n",
        " 'QUB': 20,\n",
        " 'QUO': 20,\n",
        " 'QYG': 90,\n",
        " 'RAB': 70,\n",
        " 'RAE': 210,\n",
        " 'RAH': 40,\n",
        " 'RAI': 730,\n",
        " 'RAJ': 950,\n",
        " 'RAK': 4320,\n",
        " 'RAO': 230,\n",
        " 'RAP': 1100,\n",
        " 'RAR': 470,\n",
        " 'RBA': 960,\n",
        " 'RBQ': 40,\n",
        " 'RBR': 30,\n",
        " 'RCB': 180,\n",
        " 'RCH': 480,\n",
        " 'RDD': 20,\n",
        " 'RDM': 410,\n",
        " 'RDU': 11210,\n",
        " 'RDZ': 50,\n",
        " 'REC': 930,\n",
        " 'REG': 890,\n",
        " 'REL': 200,\n",
        " 'REN': 140,\n",
        " 'REP': 770,\n",
        " 'RES': 200,\n",
        " 'REX': 290,\n",
        " 'RFP': 120,\n",
        " 'RGA': 80,\n",
        " 'RGI': 230,\n",
        " 'RGK': 50,\n",
        " 'RGL': 200,\n",
        " 'RGN': 3150,\n",
        " 'RGS': 10,\n",
        " 'RHD': 0,\n",
        " 'RHI': 50,\n",
        " 'RHO': 1910,\n",
        " 'RIB': 20,\n",
        " 'RIC': 4240,\n",
        " 'RIL': 0,\n",
        " 'RIW': 50,\n",
        " 'RIX': 4330,\n",
        " 'RIY': 140,\n",
        " 'RJA': 90,\n",
        " 'RJK': 0,\n",
        " 'RKD': 30,\n",
        " 'RKS': 170,\n",
        " 'RKT': 370,\n",
        " 'RMA': 610,\n",
        " 'RMF': 30,\n",
        " 'RMI': 160,\n",
        " 'RMQ': -50,\n",
        " 'RNB': 300,\n",
        " 'RNN': 100,\n",
        " 'RNO': 3440,\n",
        " 'RNS': 530,\n",
        " 'ROA': 1020,\n",
        " 'ROB': 370,\n",
        " 'ROC': 2990,\n",
        " 'ROK': 510,\n",
        " 'ROO': 20,\n",
        " 'ROP': 20,\n",
        " 'ROR': 60,\n",
        " 'ROS': 130,\n",
        " 'ROT': 390,\n",
        " 'ROV': 2830,\n",
        " 'ROW': 130,\n",
        " 'RPR': 1330,\n",
        " 'RRG': 20,\n",
        " 'RRS': 70,\n",
        " 'RSA': 20,\n",
        " 'RSD': 30,\n",
        " 'RSH': 40,\n",
        " 'RST': 580,\n",
        " 'RSU': 10,\n",
        " 'RSW': 11170,\n",
        " 'RTB': 350,\n",
        " 'RTM': 530,\n",
        " 'RUH': 18440,\n",
        " 'RUN': 2810,\n",
        " 'RUT': 50,\n",
        " 'RVK': 30,\n",
        " 'RVN': 560,\n",
        " 'RXS': -30,\n",
        " 'RYG': 120,\n",
        " 'RYK': 240,\n",
        " 'RZE': 360,\n",
        " 'SAB': 0,\n",
        " 'SAF': 320,\n",
        " 'SAH': 1080,\n",
        " 'SAL': 5060,\n",
        " 'SAN': 22310,\n",
        " 'SAP': 1320,\n",
        " 'SAT': 10140,\n",
        " 'SAV': 4020,\n",
        " 'SAW': 2310,\n",
        " 'SBA': 1240,\n",
        " 'SBH': 410,\n",
        " 'SBN': 530,\n",
        " 'SBP': 300,\n",
        " 'SBW': 440,\n",
        " 'SBY': 200,\n",
        " 'SBZ': 610,\n",
        " 'SCC': 20,\n",
        " 'SCE': 340,\n",
        " 'SCL': 10970,\n",
        " 'SCM': 20,\n",
        " 'SCN': 200,\n",
        " 'SCO': 570,\n",
        " 'SCQ': 160,\n",
        " 'SCU': 140,\n",
        " 'SCV': 20,\n",
        " 'SCW': 180,\n",
        " 'SCY': 60,\n",
        " 'SDD': 260,\n",
        " 'SDE': 230,\n",
        " 'SDF': 4290,\n",
        " 'SDJ': -80,\n",
        " 'SDK': 850,\n",
        " 'SDL': 390,\n",
        " 'SDN': 10,\n",
        " 'SDP': 0,\n",
        " 'SDQ': 7020,\n",
        " 'SDR': 430,\n",
        " 'SDU': 2600,\n",
        " 'SDY': 50,\n",
        " 'SEA': 30410,\n",
        " 'SEB': 350,\n",
        " 'SEZ': 2340,\n",
        " 'SFA': 870,\n",
        " 'SFG': 220,\n",
        " 'SFJ': 0,\n",
        " 'SFL': 140,\n",
        " 'SFN': 120,\n",
        " 'SFO': 53710,\n",
        " 'SFT': 300,\n",
        " 'SGC': 290,\n",
        " 'SGD': 50,\n",
        " 'SGF': 1190,\n",
        " 'SGN': 11270,\n",
        " 'SGU': 200,\n",
        " 'SHA': 1480,\n",
        " 'SHC': 30,\n",
        " 'SHD': 20,\n",
        " 'SHE': 980,\n",
        " 'SHJ': 810,\n",
        " 'SHP': 0,\n",
        " 'SHR': 80,\n",
        " 'SHV': 860,\n",
        " 'SHW': 100,\n",
        " 'SID': 670,\n",
        " 'SIN': 22904,\n",
        " 'SIP': 2120,\n",
        " 'SIT': 190,\n",
        " 'SJC': 7940,\n",
        " 'SJD': 6330,\n",
        " 'SJJ': 2040,\n",
        " 'SJO': 6100,\n",
        " 'SJP': 110,\n",
        " 'SJT': 210,\n",
        " 'SJU': 12590,\n",
        " 'SJW': 0,\n",
        " 'SJZ': 70,\n",
        " 'SKB': 440,\n",
        " 'SKD': 130,\n",
        " 'SKE': 50,\n",
        " 'SKG': 4980,\n",
        " 'SKK': 10,\n",
        " 'SKN': 110,\n",
        " 'SKP': 1350,\n",
        " 'SKT': 520,\n",
        " 'SKU': 20,\n",
        " 'SKZ': 20,\n",
        " 'SLA': 1420,\n",
        " 'SLC': 12770,\n",
        " 'SLI': 20,\n",
        " 'SLL': 840,\n",
        " 'SLM': 20,\n",
        " 'SLP': 810,\n",
        " 'SLU': 0,\n",
        " 'SLW': 410,\n",
        " 'SLY': 130,\n",
        " 'SLZ': 280,\n",
        " 'SMA': 80,\n",
        " 'SMF': 5820,\n",
        " 'SMI': 340,\n",
        " 'SMK': 10,\n",
        " 'SMR': 2160,\n",
        " 'SMS': 670,\n",
        " 'SMX': 20,\n",
        " 'SNA': 9950,\n",
        " 'SNE': -10,\n",
        " 'SNN': 1040,\n",
        " 'SNR': 100,\n",
        " 'SNU': 160,\n",
        " 'SOC': 10,\n",
        " 'SOF': 4870,\n",
        " 'SOG': 70,\n",
        " 'SOM': 10,\n",
        " 'SON': 120,\n",
        " 'SOU': 500,\n",
        " 'SPC': 710,\n",
        " 'SPI': 110,\n",
        " 'SPN': 400,\n",
        " 'SPP': 0,\n",
        " 'SPS': 130,\n",
        " 'SPU': 1340,\n",
        " 'SRE': 150,\n",
        " 'SRG': 160,\n",
        " 'SRP': 60,\n",
        " 'SRQ': 2180,\n",
        " 'SRZ': 30,\n",
        " 'SSA': 1680,\n",
        " 'SSG': 610,\n",
        " 'SSH': 2220,\n",
        " 'SSJ': 120,\n",
        " 'STD': 270,\n",
        " 'STI': 1250,\n",
        " 'STL': 12420,\n",
        " 'STM': 40,\n",
        " 'STN': 320,\n",
        " 'STR': 7110,\n",
        " 'STS': 140,\n",
        " 'STT': 3210,\n",
        " 'STV': 50,\n",
        " 'STW': 170,\n",
        " 'STX': 340,\n",
        " 'SUB': 880,\n",
        " 'SUF': 2770,\n",
        " 'SUG': -10,\n",
        " 'SUJ': 70,\n",
        " 'SUN': 70,\n",
        " 'SUV': 220,\n",
        " 'SUX': 70,\n",
        " 'SVA': 20,\n",
        " 'SVB': 60,\n",
        " 'SVD': 200,\n",
        " 'SVG': 4810,\n",
        " 'SVJ': 100,\n",
        " 'SVO': 20582,\n",
        " 'SVP': 60,\n",
        " 'SVQ': 2550,\n",
        " 'SVU': 40,\n",
        " 'SVX': 2360,\n",
        " 'SWA': 150,\n",
        " 'SWF': 320,\n",
        " 'SXB': 2170,\n",
        " 'SXF': 550,\n",
        " 'SXM': 2130,\n",
        " 'SXR': 630,\n",
        " 'SYD': 28720,\n",
        " 'SYR': 2930,\n",
        " 'SYX': 350,\n",
        " 'SYY': 40,\n",
        " 'SYZ': 250,\n",
        " 'SZA': 10,\n",
        " 'SZB': 30,\n",
        " 'SZF': 110,\n",
        " 'SZG': 1300,\n",
        " 'SZX': 1480,\n",
        " 'SZZ': 190,\n",
        " 'TAB': 1080,\n",
        " 'TAC': 140,\n",
        " 'TAE': 90,\n",
        " 'TAG': -20,\n",
        " 'TAI': 110,\n",
        " 'TAK': 80,\n",
        " 'TAM': 420,\n",
        " 'TAO': 2210,\n",
        " 'TAP': 250,\n",
        " 'TAS': 1600,\n",
        " 'TAY': 100,\n",
        " 'TBG': 20,\n",
        " 'TBN': 40,\n",
        " 'TBP': 390,\n",
        " 'TBS': 3030,\n",
        " 'TBU': 80,\n",
        " 'TBW': 30,\n",
        " 'TBZ': 60,\n",
        " 'TCB': 30,\n",
        " 'TCO': 260,\n",
        " 'TCQ': 440,\n",
        " 'TDD': 110,\n",
        " 'TDX': 30,\n",
        " 'TEB': 60,\n",
        " 'TEE': 80,\n",
        " 'TER': 540,\n",
        " 'TET': 450,\n",
        " 'TEX': 40,\n",
        " 'TFF': 30,\n",
        " 'TFN': 5520,\n",
        " 'TFS': 2060,\n",
        " 'TGD': 1450,\n",
        " 'TGG': 70,\n",
        " 'TGM': 10,\n",
        " 'TGR': 0,\n",
        " 'TGU': 1450,\n",
        " 'TGZ': 610,\n",
        " 'THE': 160,\n",
        " 'THR': 40,\n",
        " 'THS': 40,\n",
        " 'TIA': 2470,\n",
        " 'TIF': 600,\n",
        " 'TIH': 40,\n",
        " 'TIJ': 1120,\n",
        " 'TIM': 10,\n",
        " 'TIN': 40,\n",
        " 'TIP': 2760,\n",
        " 'TIR': 400,\n",
        " 'TIU': 10,\n",
        " 'TIV': 910,\n",
        " 'TIZ': 10,\n",
        " 'TJA': 40,\n",
        " 'TJM': 760,\n",
        " 'TJU': 60,\n",
        " 'TKG': 50,\n",
        " 'TKQ': 40,\n",
        " 'TKS': 30,\n",
        " 'TKU': 570,\n",
        " 'TLC': 430,\n",
        " 'TLE': 210,\n",
        " 'TLH': 1420,\n",
        " 'TLL': 2350,\n",
        " 'TLM': 680,\n",
        " 'TLN': 690,\n",
        " 'TLS': 7690,\n",
        " 'TLV': 17370,\n",
        " 'TMM': 140,\n",
        " 'TMP': 400,\n",
        " 'TMR': 20,\n",
        " 'TMS': 110,\n",
        " 'TMW': 140,\n",
        " 'TMX': 10,\n",
        " 'TNA': 340,\n",
        " 'TNG': 670,\n",
        " 'TNN': 0,\n",
        " 'TNR': 1420,\n",
        " 'TOD': 40,\n",
        " 'TOE': 180,\n",
        " 'TOF': 330,\n",
        " 'TOL': 190,\n",
        " 'TOS': 1630,\n",
        " 'TOY': 30,\n",
        " 'TPA': 19460,\n",
        " 'TPE': 12740,\n",
        " 'TPP': 470,\n",
        " 'TPQ': 30,\n",
        " 'TPS': 270,\n",
        " 'TRC': 460,\n",
        " 'TRD': 2940,\n",
        " 'TRF': 650,\n",
        " 'TRG': 190,\n",
        " 'TRI': 480,\n",
        " 'TRN': 2590,\n",
        " 'TRO': 20,\n",
        " 'TRS': 780,\n",
        " 'TRU': 1150,\n",
        " 'TRV': 6230,\n",
        " 'TRW': 140,\n",
        " 'TRZ': 860,\n",
        " 'TSA': 740,\n",
        " 'TSE': 3100,\n",
        " 'TSF': 20,\n",
        " 'TSN': 330,\n",
        " 'TSR': 870,\n",
        " 'TSV': 1360,\n",
        " 'TTN': 90,\n",
        " 'TUB': 10,\n",
        " 'TUC': 640,\n",
        " 'TUG': -10,\n",
        " 'TUI': 0,\n",
        " 'TUK': 60,\n",
        " 'TUL': 2710,\n",
        " 'TUN': 12910,\n",
        " 'TUO': 120,\n",
        " 'TUP': 40,\n",
        " 'TUS': 3800,\n",
        " 'TUU': 1250,\n",
        " 'TVC': 390,\n",
        " 'TVU': 100,\n",
        " 'TWF': 60,\n",
        " 'TWU': 310,\n",
        " 'TXK': 130,\n",
        " 'TXL': 29050,\n",
        " 'TYN': 50,\n",
        " 'TYR': 170,\n",
        " 'TYS': 2190,\n",
        " 'TZX': 290,\n",
        " 'UAH': 0,\n",
        " 'UAK': 10,\n",
        " 'UAQ': 270,\n",
        " 'UBP': 390,\n",
        " 'UDI': 280,\n",
        " 'UDJ': 30,\n",
        " 'UDR': 1100,\n",
        " 'UEL': 130,\n",
        " 'UET': 80,\n",
        " 'UFA': 850,\n",
        " 'UGC': 220,\n",
        " 'UIB': 90,\n",
        " 'UIO': 7730,\n",
        " 'UIP': 120,\n",
        " 'UKA': 20,\n",
        " 'UKB': 0,\n",
        " 'UKK': 440,\n",
        " 'UKS': 90,\n",
        " 'UKX': 20,\n",
        " 'ULH': 0,\n",
        " 'ULN': 910,\n",
        " 'ULV': 150,\n",
        " 'UME': 680,\n",
        " 'UNG': 20,\n",
        " 'UPG': -50,\n",
        " 'URA': 180,\n",
        " 'URC': 230,\n",
        " 'URT': 160,\n",
        " 'URY': 180,\n",
        " 'USH': 1850,\n",
        " 'USK': 50,\n",
        " 'USM': 6570,\n",
        " 'USN': 190,\n",
        " 'UTH': 280,\n",
        " 'UTN': 270,\n",
        " 'UTP': 10,\n",
        " 'UTT': 210,\n",
        " 'UUA': 10,\n",
        " 'UUD': 180,\n",
        " 'UUS': 580,\n",
        " 'UVF': 2100,\n",
        " 'UYU': 0,\n",
        " 'VAA': 860,\n",
        " 'VAI': 90,\n",
        " 'VAN': 90,\n",
        " 'VAR': 1290,\n",
        " 'VBY': 290,\n",
        " 'VCE': 10890,\n",
        " 'VCP': 180,\n",
        " 'VCS': 60,\n",
        " 'VCT': 0,\n",
        " 'VDE': 580,\n",
        " 'VDM': -20,\n",
        " 'VDS': 90,\n",
        " 'VDZ': 40,\n",
        " 'VEL': 20,\n",
        " 'VER': 1070,\n",
        " 'VFA': 310,\n",
        " 'VGA': 290,\n",
        " 'VGO': 1320,\n",
        " 'VHC': 60,\n",
        " 'VIE': 21580,\n",
        " 'VIG': 160,\n",
        " 'VII': 150,\n",
        " 'VIL': 300,\n",
        " 'VIX': 730,\n",
        " 'VKO': 4060,\n",
        " 'VLC': 5060,\n",
        " 'VLD': 300,\n",
        " 'VLI': 500,\n",
        " 'VLL': 60,\n",
        " 'VLN': 670,\n",
        " 'VLV': 0,\n",
        " 'VNO': 1910,\n",
        " 'VNS': 1320,\n",
        " 'VNX': 100,\n",
        " 'VOG': 540,\n",
        " 'VOL': 20,\n",
        " 'VOZ': 150,\n",
        " 'VPE': 40,\n",
        " 'VPS': 1450,\n",
        " 'VPY': 210,\n",
        " 'VQS': 80,\n",
        " 'VRA': 170,\n",
        " 'VRK': 80,\n",
        " 'VRN': 1830,\n",
        " 'VSA': 1040,\n",
        " 'VSG': 60,\n",
        " 'VTE': 920,\n",
        " 'VTZ': 1130,\n",
        " 'VUP': 370,\n",
        " 'VVC': 250,\n",
        " 'VVI': 1790,\n",
        " 'VVO': 1480,\n",
        " 'VVZ': 10,\n",
        " 'VXE': 350,\n",
        " 'VXO': 70,\n",
        " 'WAE': 80,\n",
        " 'WAG': 60,\n",
        " 'WAW': 10260,\n",
        " 'WBM': 20,\n",
        " 'WDH': 1480,\n",
        " 'WEH': 270,\n",
        " 'WEI': 100,\n",
        " 'WGA': 280,\n",
        " 'WHK': 90,\n",
        " 'WIC': 30,\n",
        " 'WLG': 3680,\n",
        " 'WLS': 100,\n",
        " 'WMN': 0,\n",
        " 'WNP': 20,\n",
        " 'WNZ': 580,\n",
        " 'WRE': 230,\n",
        " 'WRG': 20,\n",
        " 'WRO': 1420,\n",
        " 'WSZ': 50,\n",
        " 'WTL': 20,\n",
        " 'WUA': 0,\n",
        " 'WUH': 560,\n",
        " 'WUS': 10,\n",
        " 'WUX': 120,\n",
        " 'WVB': 200,\n",
        " 'WWK': 10,\n",
        " 'WYA': 110,\n",
        " 'WYS': 70,\n",
        " 'XAP': 40,\n",
        " 'XCH': 30,\n",
        " 'XDB': 130,\n",
        " 'XDS': 90,\n",
        " 'XER': 310,\n",
        " 'XFN': 20,\n",
        " 'XFW': 310,\n",
        " 'XHJ': 20,\n",
        " 'XIY': 720,\n",
        " 'XJN': 40,\n",
        " 'XJY': -10,\n",
        " 'XKH': 40,\n",
        " 'XMB': 200,\n",
        " 'XMN': 1670,\n",
        " 'XMS': 30,\n",
        " 'XNA': 2280,\n",
        " 'XNB': 210,\n",
        " 'XNN': -40,\n",
        " 'XOP': 0,\n",
        " 'XPG': 1570,\n",
        " 'XPJ': 0,\n",
        " 'XQE': 20,\n",
        " 'XQP': 20,\n",
        " 'XRF': 20,\n",
        " 'XRY': 690,\n",
        " 'XUZ': -20,\n",
        " 'XWG': -90,\n",
        " 'XYD': 190,\n",
        " 'XZI': 10,\n",
        " 'XZZ': 0,\n",
        " 'YAM': 150,\n",
        " 'YAY': -20,\n",
        " 'YBG': 30,\n",
        " 'YBL': 130,\n",
        " 'YCB': 50,\n",
        " 'YCD': 330,\n",
        " 'YCG': 60,\n",
        " 'YCO': 30,\n",
        " 'YCU': -20,\n",
        " 'YDF': 230,\n",
        " 'YEG': 4410,\n",
        " 'YEV': 0,\n",
        " 'YFB': 50,\n",
        " 'YFC': 440,\n",
        " 'YGJ': 0,\n",
        " 'YGK': 120,\n",
        " 'YGR': 0,\n",
        " 'YGW': 20,\n",
        " 'YGX': 10,\n",
        " 'YHD': 20,\n",
        " 'YHM': 90,\n",
        " 'YHO': 10,\n",
        " 'YHY': 0,\n",
        " 'YHZ': 2720,\n",
        " 'YIH': 10,\n",
        " 'YIP': 20,\n",
        " 'YIW': 270,\n",
        " 'YJE': 40,\n",
        " 'YKA': 210,\n",
        " 'YKF': 70,\n",
        " 'YKM': 30,\n",
        " 'YKQ': 50,\n",
        " 'YKS': 90,\n",
        " 'YKU': 20,\n",
        " 'YLL': 50,\n",
        " 'YLW': 1280,\n",
        " 'YMM': 890,\n",
        " 'YMN': 40,\n",
        " 'YMO': 20,\n",
        " 'YMT': 10,\n",
        " 'YNB': 500,\n",
        " 'YNJ': 360,\n",
        " 'YNT': 370,\n",
        " 'YNZ': 0,\n",
        " 'YOJ': 20,\n",
        " 'YOP': -10,\n",
        " 'YOW': 3630,\n",
        " 'YPR': 20,\n",
        " 'YPX': 20,\n",
        " 'YQB': 1480,\n",
        " 'YQD': 40,\n",
        " 'YQG': 160,\n",
        " 'YQK': 20,\n",
        " 'YQL': -10,\n",
        " 'YQM': 530,\n",
        " 'YQQ': 360,\n",
        " 'YQR': 1400,\n",
        " 'YQT': 550,\n",
        " 'YQU': 340,\n",
        " 'YQX': 150,\n",
        " 'YQY': 120,\n",
        " 'YQZ': 30,\n",
        " 'YRB': -20,\n",
        " 'YRL': 0,\n",
        " 'YRT': 30,\n",
        " 'YSB': 250,\n",
        " 'YSJ': 220,\n",
        " 'YTH': 40,\n",
        " 'YTM': 40,\n",
        " 'YTS': 130,\n",
        " 'YTY': 30,\n",
        " 'YTZ': 1290,\n",
        " 'YUD': 10,\n",
        " 'YUL': 13140,\n",
        " 'YUM': 350,\n",
        " 'YUY': 20,\n",
        " 'YVO': 120,\n",
        " 'YVP': 50,\n",
        " 'YVQ': 20,\n",
        " 'YVR': 14750,\n",
        " 'YWG': 2610,\n",
        " 'YWH': 20,\n",
        " 'YWK': 120,\n",
        " 'YWL': 20,\n",
        " 'YXC': 60,\n",
        " 'YXE': 890,\n",
        " 'YXH': 30,\n",
        " 'YXJ': 280,\n",
        " 'YXL': 20,\n",
        " 'YXN': 0,\n",
        " 'YXS': 330,\n",
        " 'YXT': 140,\n",
        " 'YXU': 450,\n",
        " 'YXX': 150,\n",
        " 'YXY': 210,\n",
        " 'YYB': 170,\n",
        " 'YYC': 9530,\n",
        " 'YYD': 270,\n",
        " 'YYE': 40,\n",
        " 'YYF': 120,\n",
        " 'YYG': 500,\n",
        " 'YYJ': 1180,\n",
        " 'YYQ': 20,\n",
        " 'YYR': 50,\n",
        " 'YYT': 1200,\n",
        " 'YYU': 0,\n",
        " 'YYZ': 23640,\n",
        " 'YZF': 300,\n",
        " 'YZP': 10,\n",
        " 'YZR': 20,\n",
        " 'YZV': 50,\n",
        " 'YZZ': 10,\n",
        " 'ZAD': 90,\n",
        " 'ZAG': 3490,\n",
        " 'ZAL': 90,\n",
        " 'ZAM': 80,\n",
        " 'ZAZ': 50,\n",
        " 'ZBF': 110,\n",
        " 'ZBL': 90,\n",
        " 'ZCL': 150,\n",
        " 'ZCO': 580,\n",
        " 'ZDH': 40,\n",
        " 'ZFQ': 40,\n",
        " 'ZFV': 120,\n",
        " 'ZHA': 0,\n",
        " 'ZIG': 40,\n",
        " 'ZIH': 680,\n",
        " 'ZLN': 0,\n",
        " 'ZLO': 490,\n",
        " 'ZNE': 1380,\n",
        " 'ZNZ': 940,\n",
        " 'ZOS': 40,\n",
        " 'ZQN': 1360,\n",
        " 'ZRH': 19050,\n",
        " 'ZSA': 10,\n",
        " 'ZSE': 10,\n",
        " 'ZTH': 50,\n",
        " 'ZUH': 40,\n",
        " 'ZVE': 40,\n",
        " 'ZVJ': 20,\n",
        " 'ZVK': 20,\n",
        " 'ZWE': 30,\n",
        " 'ZWS': 570,\n",
        " 'ZYL': 860,\n",
        " 'ZYN': 20,\n",
        " 'ZYR': 1020}"
       ]
      }
     ],
     "prompt_number": 25
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#sorting the dict into a value\n",
      "import operator\n",
      "%time sorted_arrs = sorted(arr_dict.items(), key=operator.itemgetter(1), reverse=True)\n"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "CPU times: user 1.24 ms, sys: 0 ns, total: 1.24 ms\n",
        "Wall time: 993 \u00b5s\n"
       ]
      }
     ],
     "prompt_number": 26
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "sorted_arrs"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 27,
       "text": [
        "[('LHR', 81439),\n",
        " ('LAX', 64230),\n",
        " ('LAS', 63190),\n",
        " ('MCO', 62290),\n",
        " ('JFK', 60060),\n",
        " ('CDG', 58080),\n",
        " ('SFO', 53710),\n",
        " ('MIA', 53020),\n",
        " ('BKK', 52660),\n",
        " ('DXB', 52230),\n",
        " ('ORD', 50740),\n",
        " ('IST', 41490),\n",
        " ('DFW', 41250),\n",
        " ('FCO', 39920),\n",
        " ('LGA', 39302),\n",
        " ('BCN', 38790),\n",
        " ('ATL', 38760),\n",
        " ('MAD', 37850),\n",
        " ('CUN', 34980),\n",
        " ('BOS', 34680),\n",
        " ('EWR', 33520),\n",
        " ('DEL', 32150),\n",
        " ('BOM', 31430),\n",
        " ('DEN', 30700),\n",
        " ('SEA', 30410),\n",
        " ('FRA', 30190),\n",
        " ('ORY', 30000),\n",
        " ('MUC', 29410),\n",
        " ('TXL', 29050),\n",
        " ('MNL', 28920),\n",
        " ('HKG', 28750),\n",
        " ('SYD', 28720),\n",
        " ('FLL', 28670),\n",
        " ('AMS', 28340),\n",
        " ('PHX', 27700),\n",
        " ('DCA', 27550),\n",
        " ('IAH', 26730),\n",
        " ('MEX', 26400),\n",
        " ('JED', 25300),\n",
        " ('PVG', 24350),\n",
        " ('YYZ', 23640),\n",
        " ('CAI', 23090),\n",
        " ('SIN', 22904),\n",
        " ('BOG', 22470),\n",
        " ('SAN', 22310),\n",
        " ('MEL', 21990),\n",
        " ('PEK', 21920),\n",
        " ('PHL', 21580),\n",
        " ('VIE', 21580),\n",
        " ('HNL', 21540),\n",
        " ('ATH', 21430),\n",
        " ('JNB', 21240),\n",
        " ('LIS', 21230),\n",
        " ('SVO', 20582),\n",
        " ('ARN', 20300),\n",
        " ('BRU', 19960),\n",
        " ('TPA', 19460),\n",
        " ('MSP', 19300),\n",
        " ('ZRH', 19050),\n",
        " ('CPH', 18810),\n",
        " ('RUH', 18440),\n",
        " ('LIM', 18420),\n",
        " ('BNE', 18240),\n",
        " ('IAD', 17960),\n",
        " ('TLV', 17370),\n",
        " ('DTW', 17170),\n",
        " ('ICN', 16980),\n",
        " ('DUS', 16810),\n",
        " ('KUL', 16670),\n",
        " ('CLT', 16512),\n",
        " ('OSL', 16450),\n",
        " ('MXP', 15770),\n",
        " ('NRT', 15050),\n",
        " ('HAM', 14910),\n",
        " ('MSY', 14790),\n",
        " ('YVR', 14750),\n",
        " ('LED', 14220),\n",
        " ('MAA', 14110),\n",
        " ('NCE', 13830),\n",
        " ('LIN', 13520),\n",
        " ('PRG', 13230),\n",
        " ('YUL', 13140),\n",
        " ('CPT', 13110),\n",
        " ('BWI', 13060),\n",
        " ('PMI', 12990),\n",
        " ('TUN', 12910),\n",
        " ('GRU', 12780),\n",
        " ('PUJ', 12770),\n",
        " ('SLC', 12770),\n",
        " ('TPE', 12740),\n",
        " ('SJU', 12590),\n",
        " ('STL', 12420),\n",
        " ('BLR', 12380),\n",
        " ('GVA', 12340),\n",
        " ('DME', 12320),\n",
        " ('AKL', 12280),\n",
        " ('PDX', 12170),\n",
        " ('DUB', 11740),\n",
        " ('PER', 11630),\n",
        " ('AMM', 11620),\n",
        " ('CMN', 11570),\n",
        " ('DOH', 11350),\n",
        " ('SGN', 11270),\n",
        " ('RDU', 11210),\n",
        " ('HEL', 11200),\n",
        " ('RSW', 11170),\n",
        " ('HKT', 11160),\n",
        " ('AUS', 11070),\n",
        " ('SCL', 10970),\n",
        " ('VCE', 10890),\n",
        " ('HYD', 10790),\n",
        " ('DAC', 10700),\n",
        " ('CAN', 10690),\n",
        " ('DPS', 10380),\n",
        " ('BEY', 10360),\n",
        " ('ALG', 10280),\n",
        " ('WAW', 10260),\n",
        " ('CMB', 10230),\n",
        " ('PIT', 10180),\n",
        " ('SAT', 10140),\n",
        " ('CGK', 10140),\n",
        " ('EZE', 10130),\n",
        " ('SNA', 9950),\n",
        " ('MCI', 9550),\n",
        " ('YYC', 9530),\n",
        " ('COK', 9500),\n",
        " ('BUD', 9480),\n",
        " ('AGP', 9440),\n",
        " ('MRS', 9220),\n",
        " ('MBJ', 9080),\n",
        " ('GIG', 8920),\n",
        " ('LYS', 8820),\n",
        " ('MAN', 8790),\n",
        " ('CCU', 8550),\n",
        " ('BNA', 8520),\n",
        " ('KBP', 8140),\n",
        " ('MRU', 8110),\n",
        " ('PBI', 8040),\n",
        " ('AUH', 7970),\n",
        " ('IND', 7940),\n",
        " ('SJC', 7940),\n",
        " ('NBO', 7840),\n",
        " ('OGG', 7810),\n",
        " ('GDL', 7790),\n",
        " ('UIO', 7730),\n",
        " ('LGW', 7700),\n",
        " ('TLS', 7690),\n",
        " ('AEP', 7650),\n",
        " ('PTY', 7510),\n",
        " ('ISB', 7430),\n",
        " ('OTP', 7430),\n",
        " ('JAX', 7420),\n",
        " ('CMH', 7300),\n",
        " ('CLE', 7300),\n",
        " ('CCS', 7210),\n",
        " ('STR', 7110),\n",
        " ('CTA', 7090),\n",
        " ('KWI', 7060),\n",
        " ('LCY', 7030),\n",
        " ('DMM', 7020),\n",
        " ('SDQ', 7020),\n",
        " ('ADL', 6970),\n",
        " ('MKE', 6870),\n",
        " ('USM', 6570),\n",
        " ('DUR', 6550),\n",
        " ('MLA', 6530),\n",
        " ('GYE', 6350),\n",
        " ('SJD', 6330),\n",
        " ('LHE', 6320),\n",
        " ('MDE', 6300),\n",
        " ('KOA', 6240),\n",
        " ('TRV', 6230),\n",
        " ('MEM', 6170),\n",
        " ('MCT', 6110),\n",
        " ('CVG', 6100),\n",
        " ('SJO', 6100),\n",
        " ('CTG', 6060),\n",
        " ('LPA', 6060),\n",
        " ('BDL', 6050),\n",
        " ('HAV', 6000),\n",
        " ('KTM', 5970),\n",
        " ('SMF', 5820),\n",
        " ('BGO', 5780),\n",
        " ('NAS', 5690),\n",
        " ('BLQ', 5690),\n",
        " ('CLO', 5680),\n",
        " ('OPO', 5600),\n",
        " ('BAH', 5560),\n",
        " ('TFN', 5520),\n",
        " ('ADD', 5500),\n",
        " ('PVR', 5480),\n",
        " ('CCJ', 5430),\n",
        " ('BEG', 5400),\n",
        " ('CGN', 5230),\n",
        " ('VLC', 5060),\n",
        " ('SAL', 5060),\n",
        " ('AUA', 5060),\n",
        " ('SKG', 4980),\n",
        " ('HAJ', 4960),\n",
        " ('SOF', 4870),\n",
        " ('SVG', 4810),\n",
        " ('AYT', 4810),\n",
        " ('ANC', 4640),\n",
        " ('OKC', 4600),\n",
        " ('KHI', 4600),\n",
        " ('EDI', 4580),\n",
        " ('BUF', 4580),\n",
        " ('GOT', 4550),\n",
        " ('LOS', 4520),\n",
        " ('ALA', 4520),\n",
        " ('BOD', 4510),\n",
        " ('AMD', 4490),\n",
        " ('BIO', 4490),\n",
        " ('LIH', 4470),\n",
        " ('MTY', 4470),\n",
        " ('CBR', 4440),\n",
        " ('YEG', 4410),\n",
        " ('ORF', 4370),\n",
        " ('RIX', 4330),\n",
        " ('RAK', 4320),\n",
        " ('LCA', 4320),\n",
        " ('FLR', 4300),\n",
        " ('SDF', 4290),\n",
        " ('CHC', 4260),\n",
        " ('MLE', 4240),\n",
        " ('RIC', 4240),\n",
        " ('BHX', 4220),\n",
        " ('KIX', 4210),\n",
        " ('GUA', 4130),\n",
        " ('NAP', 4080),\n",
        " ('VKO', 4060),\n",
        " ('CHS', 4050),\n",
        " ('ABQ', 4040),\n",
        " ('KEF', 4030),\n",
        " ('SAV', 4020),\n",
        " ('OMA', 3930),\n",
        " ('HAN', 3900),\n",
        " ('DKR', 3870),\n",
        " ('TUS', 3800),\n",
        " ('PTP', 3800),\n",
        " ('CUZ', 3750),\n",
        " ('GEG', 3730),\n",
        " ('PMO', 3720),\n",
        " ('WLG', 3680),\n",
        " ('YOW', 3630),\n",
        " ('PSP', 3620),\n",
        " ('ABZ', 3580),\n",
        " ('HOU', 3540),\n",
        " ('ACC', 3530),\n",
        " ('HER', 3520),\n",
        " ('MDW', 3500),\n",
        " ('ZAG', 3490),\n",
        " ('GOI', 3450),\n",
        " ('CNX', 3450),\n",
        " ('RNO', 3440),\n",
        " ('PVD', 3410),\n",
        " ('OAK', 3370),\n",
        " ('LKO', 3360),\n",
        " ('CGH', 3360),\n",
        " ('GLA', 3330),\n",
        " ('BAQ', 3330),\n",
        " ('LAD', 3270),\n",
        " ('AER', 3270),\n",
        " ('GSO', 3240),\n",
        " ('CNS', 3240),\n",
        " ('DAY', 3240),\n",
        " ('CUR', 3220),\n",
        " ('STT', 3210),\n",
        " ('MED', 3210),\n",
        " ('PNS', 3200),\n",
        " ('POS', 3200),\n",
        " ('RGN', 3150),\n",
        " ('ESB', 3140),\n",
        " ('DAR', 3140),\n",
        " ('BOI', 3110),\n",
        " ('TSE', 3100),\n",
        " ('IBZ', 3090),\n",
        " ('LUX', 3090),\n",
        " ('ELP', 3070),\n",
        " ('GRR', 3040),\n",
        " ('LIT', 3040),\n",
        " ('TBS', 3030),\n",
        " ('KRT', 3010),\n",
        " ('KRK', 3000),\n",
        " ('ROC', 2990),\n",
        " ('TRD', 2940),\n",
        " ('KRR', 2940),\n",
        " ('FDF', 2940),\n",
        " ('SYR', 2930),\n",
        " ('DSM', 2910),\n",
        " ('FNC', 2910),\n",
        " ('HND', 2900),\n",
        " ('HBE', 2900),\n",
        " ('NAN', 2850),\n",
        " ('NUE', 2850),\n",
        " ('PLZ', 2850),\n",
        " ('ROV', 2830),\n",
        " ('ORN', 2820),\n",
        " ('RUN', 2810),\n",
        " ('BHM', 2810),\n",
        " ('ONT', 2800),\n",
        " ('ADB', 2790),\n",
        " ('IKA', 2790),\n",
        " ('SUF', 2770),\n",
        " ('KIN', 2760),\n",
        " ('TIP', 2760),\n",
        " ('MYR', 2750),\n",
        " ('GYD', 2720),\n",
        " ('BMA', 2720),\n",
        " ('YHZ', 2720),\n",
        " ('TUL', 2710),\n",
        " ('ADZ', 2690),\n",
        " ('ALC', 2660),\n",
        " ('YWG', 2610),\n",
        " ('BRI', 2600),\n",
        " ('SDU', 2600),\n",
        " ('TRN', 2590),\n",
        " ('CEB', 2580),\n",
        " ('GSP', 2580),\n",
        " ('SVQ', 2550),\n",
        " ('MSQ', 2550),\n",
        " ('MBA', 2530),\n",
        " ('COS', 2510),\n",
        " ('ABJ', 2500),\n",
        " ('EBB', 2480),\n",
        " ('TIA', 2470),\n",
        " ('NTE', 2440),\n",
        " ('MSN', 2430),\n",
        " ('MDT', 2410),\n",
        " ('EVN', 2380),\n",
        " ('PAP', 2370),\n",
        " ('PNQ', 2360),\n",
        " ('SVX', 2360),\n",
        " ('TLL', 2350),\n",
        " ('SEZ', 2340),\n",
        " ('MGA', 2340),\n",
        " ('CAE', 2320),\n",
        " ('SAW', 2310),\n",
        " ('GDN', 2300),\n",
        " ('XNA', 2280),\n",
        " ('CNF', 2280),\n",
        " ('ATQ', 2270),\n",
        " ('CTS', 2260),\n",
        " ('ALB', 2260),\n",
        " ('BUR', 2230),\n",
        " ('KIV', 2230),\n",
        " ('SSH', 2220),\n",
        " ('TAO', 2210),\n",
        " ('BGI', 2200),\n",
        " ('TYS', 2190),\n",
        " ('SRQ', 2180),\n",
        " ('SXB', 2170),\n",
        " ('PWM', 2160),\n",
        " ('CAG', 2160),\n",
        " ('MFM', 2160),\n",
        " ('SMR', 2160),\n",
        " ('KTA', 2150),\n",
        " ('SXM', 2130),\n",
        " ('ICT', 2130),\n",
        " ('IGU', 2130),\n",
        " ('SIP', 2120),\n",
        " ('HBA', 2110),\n",
        " ('UVF', 2100),\n",
        " ('MVD', 2100),\n",
        " ('PPT', 2090),\n",
        " ('KBV', 2080),\n",
        " ('TFS', 2060),\n",
        " ('BGA', 2050),\n",
        " ('SJJ', 2040),\n",
        " ('PUS', 2020),\n",
        " ('IGR', 2020),\n",
        " ('BJX', 2010),\n",
        " ('BLL', 2010),\n",
        " ('LGB', 2000),\n",
        " ('GEO', 1980),\n",
        " ('OOL', 1980),\n",
        " ('IXE', 1960),\n",
        " ('PMV', 1960),\n",
        " ('ANU', 1920),\n",
        " ('BSB', 1920),\n",
        " ('JAI', 1910),\n",
        " ('POA', 1910),\n",
        " ('RHO', 1910),\n",
        " ('VNO', 1910),\n",
        " ('ODS', 1900),\n",
        " ('CCP', 1890),\n",
        " ('ABV', 1880),\n",
        " ('BSL', 1860),\n",
        " ('JTR', 1860),\n",
        " ('HSV', 1850),\n",
        " ('USH', 1850),\n",
        " ('GUM', 1850),\n",
        " ('BRE', 1840),\n",
        " ('VRN', 1830),\n",
        " ('COR', 1810),\n",
        " ('AHB', 1810),\n",
        " ('PEI', 1790),\n",
        " ('VVI', 1790),\n",
        " ('NGO', 1790),\n",
        " ('FAI', 1780),\n",
        " ('MRV', 1760),\n",
        " ('MHT', 1760),\n",
        " ('FUE', 1760),\n",
        " ('GCM', 1730),\n",
        " ('CZL', 1730),\n",
        " ('MDZ', 1730),\n",
        " ('PDL', 1700),\n",
        " ('GOA', 1700),\n",
        " ('PNH', 1690),\n",
        " ('KUF', 1690),\n",
        " ('EYW', 1690),\n",
        " ('SSA', 1680),\n",
        " ('LIR', 1680),\n",
        " ('XMN', 1670),\n",
        " ('FAO', 1670),\n",
        " ('AAQ', 1650),\n",
        " ('PEN', 1640),\n",
        " ('TOS', 1630),\n",
        " ('AQP', 1630),\n",
        " ('CZM', 1620),\n",
        " ('PEW', 1620),\n",
        " ('MMX', 1610),\n",
        " ('TAS', 1600),\n",
        " ('OVB', 1600),\n",
        " ('MPM', 1590),\n",
        " ('CTU', 1580),\n",
        " ('BTR', 1580),\n",
        " ('HRE', 1580),\n",
        " ('ANF', 1580),\n",
        " ('PLS', 1580),\n",
        " ('XPG', 1570),\n",
        " ('HPN', 1560),\n",
        " ('ACE', 1550),\n",
        " ('DJE', 1530),\n",
        " ('CAK', 1530),\n",
        " ('AJA', 1520),\n",
        " ('LUN', 1520),\n",
        " ('HGH', 1520),\n",
        " ('CJC', 1510),\n",
        " ('GMP', 1510),\n",
        " ('BDA', 1510),\n",
        " ('GPT', 1500),\n",
        " ('AGA', 1490),\n",
        " ('JAN', 1490),\n",
        " ('KHH', 1490),\n",
        " ('WDH', 1480),\n",
        " ('YQB', 1480),\n",
        " ('VVO', 1480),\n",
        " ('SZX', 1480),\n",
        " ('SHA', 1480),\n",
        " ('FAT', 1480),\n",
        " ('DBV', 1460),\n",
        " ('BTV', 1450),\n",
        " ('VPS', 1450),\n",
        " ('TGU', 1450),\n",
        " ('TGD', 1450),\n",
        " ('BZE', 1450),\n",
        " ('IDR', 1440),\n",
        " ('BRC', 1430),\n",
        " ('KBL', 1420),\n",
        " ('TLH', 1420),\n",
        " ('TNR', 1420),\n",
        " ('WRO', 1420),\n",
        " ('SLA', 1420),\n",
        " ('BLA', 1410),\n",
        " ('DRW', 1400),\n",
        " ('YQR', 1400),\n",
        " ('BZN', 1400),\n",
        " ('ASU', 1400),\n",
        " ('GAU', 1400),\n",
        " ('POM', 1380),\n",
        " ('JRO', 1380),\n",
        " ('ZNE', 1380),\n",
        " ('DRS', 1370),\n",
        " ('LJU', 1370),\n",
        " ('PZO', 1370),\n",
        " ('PRN', 1360),\n",
        " ('TSV', 1360),\n",
        " ('FAY', 1360),\n",
        " ('ZQN', 1360),\n",
        " ('OUD', 1350),\n",
        " ('SKP', 1350),\n",
        " ('SPU', 1340),\n",
        " ('BUQ', 1340),\n",
        " ('ELS', 1340),\n",
        " ('DAL', 1340),\n",
        " ('RPR', 1330),\n",
        " ('SAP', 1320),\n",
        " ('VGO', 1320),\n",
        " ('VNS', 1320),\n",
        " ('SZG', 1300),\n",
        " ('BHD', 1300),\n",
        " ('OLB', 1300),\n",
        " ('VAR', 1290),\n",
        " ('FSD', 1290),\n",
        " ('YTZ', 1290),\n",
        " ('BEN', 1280),\n",
        " ('PAT', 1280),\n",
        " ('BKI', 1280),\n",
        " ('YLW', 1280),\n",
        " ('IEV', 1280),\n",
        " ('NOU', 1270),\n",
        " ('LPB', 1270),\n",
        " ('IXC', 1260),\n",
        " ('JAC', 1260),\n",
        " ('BDS', 1260),\n",
        " ('DAB', 1260),\n",
        " ('TUU', 1250),\n",
        " ('STI', 1250),\n",
        " ('SBA', 1240),\n",
        " ('FOC', 1230),\n",
        " ('ILM', 1220),\n",
        " ('PBM', 1210),\n",
        " ('PMC', 1210),\n",
        " ('CGP', 1210),\n",
        " ('BES', 1200),\n",
        " ('YYT', 1200),\n",
        " ('SGF', 1190),\n",
        " ('NCL', 1180),\n",
        " ('YYJ', 1180),\n",
        " ('NKG', 1180),\n",
        " ('DLC', 1170),\n",
        " ('PSC', 1170),\n",
        " ('HRG', 1170),\n",
        " ('MAR', 1160),\n",
        " ('FPO', 1160),\n",
        " ('LIL', 1150),\n",
        " ('TRU', 1150),\n",
        " ('DUD', 1150),\n",
        " ('MPL', 1140),\n",
        " ('VTZ', 1130),\n",
        " ('PIU', 1130),\n",
        " ('AMA', 1120),\n",
        " ('LCG', 1120),\n",
        " ('TIJ', 1120),\n",
        " ('KHV', 1120),\n",
        " ('BIQ', 1110),\n",
        " ('CUC', 1110),\n",
        " ('KJA', 1100),\n",
        " ('UDR', 1100),\n",
        " ('RAP', 1100),\n",
        " ('SAH', 1080),\n",
        " ('CKY', 1080),\n",
        " ('TAB', 1080),\n",
        " ('BZV', 1080),\n",
        " ('VER', 1070),\n",
        " ('BIL', 1070),\n",
        " ('KGL', 1060),\n",
        " ('BOO', 1050),\n",
        " ('BGW', 1050),\n",
        " ('MTR', 1050),\n",
        " ('SNN', 1040),\n",
        " ('CHQ', 1040),\n",
        " ('VSA', 1040),\n",
        " ('CPO', 1040),\n",
        " ('CUU', 1040),\n",
        " ('FRU', 1030),\n",
        " ('DLA', 1030),\n",
        " ('PHE', 1030),\n",
        " ('BKO', 1030),\n",
        " ('ZYR', 1020),\n",
        " ('DOK', 1020),\n",
        " ('LEX', 1020),\n",
        " ('ROA', 1020),\n",
        " ('HMO', 1010),\n",
        " ('PHF', 1010),\n",
        " ('OVD', 1010),\n",
        " ('IXB', 1000),\n",
        " ('MAH', 1000),\n",
        " ('KMG', 1000),\n",
        " ('GIZ', 1000),\n",
        " ('IQT', 1000),\n",
        " ('CHA', 990),\n",
        " ('COO', 990),\n",
        " ('LEJ', 990),\n",
        " ('ECP', 980),\n",
        " ('CJB', 980),\n",
        " ('ADA', 980),\n",
        " ('SHE', 980),\n",
        " ('MFE', 980),\n",
        " ('MYY', 980),\n",
        " ('FTE', 980),\n",
        " ('JER', 980),\n",
        " ('GRX', 970),\n",
        " ('GLT', 960),\n",
        " ('PUF', 960),\n",
        " ('RBA', 960),\n",
        " ('BJV', 960),\n",
        " ('MOB', 960),\n",
        " ('CWB', 950),\n",
        " ('IQQ', 950),\n",
        " ('RAJ', 950),\n",
        " ('MJT', 940),\n",
        " ('ZNZ', 940),\n",
        " ('EAM', 930),\n",
        " ('NAG', 930),\n",
        " ('REC', 930),\n",
        " ('BRS', 920),\n",
        " ('FLN', 920),\n",
        " ('MID', 920),\n",
        " ('VTE', 920),\n",
        " ('KRS', 920),\n",
        " ('BIA', 920),\n",
        " ('PSA', 910),\n",
        " ('EBL', 910),\n",
        " ('FIH', 910),\n",
        " ('MIR', 910),\n",
        " ('KGD', 910),\n",
        " ('TIV', 910),\n",
        " ('CUE', 910),\n",
        " ('ULN', 910),\n",
        " ('JMK', 900),\n",
        " ('ASE', 900),\n",
        " ('REG', 890),\n",
        " ('BJM', 890),\n",
        " ('YXE', 890),\n",
        " ('YMM', 890),\n",
        " ('LLW', 890),\n",
        " ('SUB', 880),\n",
        " ('LFT', 880),\n",
        " ('NAT', 880),\n",
        " ('LBV', 880),\n",
        " ('MLI', 870),\n",
        " ('TSR', 870),\n",
        " ('SFA', 870),\n",
        " ('CEK', 870),\n",
        " ('HLA', 860),\n",
        " ('ZYL', 860),\n",
        " ('VAA', 860),\n",
        " ('FOR', 860),\n",
        " ('CHO', 860),\n",
        " ('FSC', 860),\n",
        " ('TRZ', 860),\n",
        " ('SHV', 860),\n",
        " ('FUK', 860),\n",
        " ('ITO', 860),\n",
        " ('MMK', 850),\n",
        " ('UFA', 850),\n",
        " ('SDK', 850),\n",
        " ('LWO', 850),\n",
        " ('BBI', 840),\n",
        " ('EUG', 840),\n",
        " ('KKC', 840),\n",
        " ('MZT', 840),\n",
        " ('SLL', 840),\n",
        " ('IXU', 830),\n",
        " ('POZ', 830),\n",
        " ('AVL', 830),\n",
        " ('ABE', 830),\n",
        " ('CKG', 820),\n",
        " ('HAU', 820),\n",
        " ('CRW', 820),\n",
        " ('CID', 820),\n",
        " ('GRB', 810),\n",
        " ('GRK', 810),\n",
        " ('PBO', 810),\n",
        " ('KZN', 810),\n",
        " ('PUQ', 810),\n",
        " ('SHJ', 810),\n",
        " ('AAE', 810),\n",
        " ('SLP', 810),\n",
        " ('AGU', 800),\n",
        " ('IXM', 800),\n",
        " ('GRJ', 800),\n",
        " ('PSO', 800),\n",
        " ('KRN', 800),\n",
        " ('FWA', 800),\n",
        " ('GPS', 800),\n",
        " ('MSU', 800),\n",
        " ('GUW', 790),\n",
        " ('OUA', 790),\n",
        " ('MLB', 780),\n",
        " ('TRS', 780),\n",
        " ('BHO', 780),\n",
        " ('KCH', 770),\n",
        " ('AHO', 770),\n",
        " ('REP', 770),\n",
        " ('MKY', 770),\n",
        " ('PHC', 770),\n",
        " ('JUB', 770),\n",
        " ('TJM', 760),\n",
        " ('PNR', 760),\n",
        " ('BJA', 760),\n",
        " ('FAR', 760),\n",
        " ('DED', 760),\n",
        " ('LBA', 760),\n",
        " ('LBB', 760),\n",
        " ('MAF', 750),\n",
        " ('AES', 750),\n",
        " ('AEX', 750),\n",
        " ('BRM', 750),\n",
        " ('ATW', 750),\n",
        " ('CLJ', 750),\n",
        " ('AAL', 750),\n",
        " ('NSI', 740),\n",
        " ('TSA', 740),\n",
        " ('BSR', 730),\n",
        " ('NKC', 730),\n",
        " ('RAI', 730),\n",
        " ('VIX', 730),\n",
        " ('OMS', 730),\n",
        " ('APW', 720),\n",
        " ('XIY', 720),\n",
        " ('HAS', 720),\n",
        " ('LGK', 720),\n",
        " ('BIS', 720),\n",
        " ('SPC', 710),\n",
        " ('MAO', 710),\n",
        " ('AVP', 710),\n",
        " ('GRZ', 700),\n",
        " ('CRP', 700),\n",
        " ('XRY', 690),\n",
        " ('TLN', 690),\n",
        " ('ACA', 690),\n",
        " ('CRD', 690),\n",
        " ('ZIH', 680),\n",
        " ('GOJ', 680),\n",
        " ('TLM', 680),\n",
        " ('IAS', 680),\n",
        " ('BJL', 680),\n",
        " ('CGO', 680),\n",
        " ('UME', 680),\n",
        " ('BDQ', 680),\n",
        " ('VLN', 670),\n",
        " ('SID', 670),\n",
        " ('TNG', 670),\n",
        " ('KGI', 670),\n",
        " ('SMS', 670),\n",
        " ('GJT', 660),\n",
        " ('MHD', 660),\n",
        " ('CEI', 660),\n",
        " ('PKC', 660),\n",
        " ('DAD', 660),\n",
        " ('GNV', 650),\n",
        " ('TRF', 650),\n",
        " ('OAX', 650),\n",
        " ('NNG', 650),\n",
        " ('MRY', 640),\n",
        " ('TUC', 640),\n",
        " ('POP', 640),\n",
        " ('GBE', 640),\n",
        " ('MFR', 640),\n",
        " ('CIX', 640),\n",
        " ('IXZ', 630),\n",
        " ('QRO', 630),\n",
        " ('DRO', 630),\n",
        " ('SXR', 630),\n",
        " ('LAN', 630),\n",
        " ('AGS', 620),\n",
        " ('CFU', 620),\n",
        " ('BMI', 620),\n",
        " ('JDH', 620),\n",
        " ('LLA', 620),\n",
        " ('BHJ', 620),\n",
        " ('SSG', 610),\n",
        " ('RMA', 610),\n",
        " ('SBZ', 610),\n",
        " ('TGZ', 610),\n",
        " ('ARH', 610),\n",
        " ('CFE', 600),\n",
        " ('DNK', 600),\n",
        " ('GYN', 600),\n",
        " ('ITM', 600),\n",
        " ('TIF', 600),\n",
        " ('ECN', 590),\n",
        " ('OUL', 590),\n",
        " ('PIA', 590),\n",
        " ('CUL', 590),\n",
        " ('UUS', 580),\n",
        " ('PEE', 580),\n",
        " ('VDE', 580),\n",
        " ('ZCO', 580),\n",
        " ('RST', 580),\n",
        " ('BFN', 580),\n",
        " ('WNZ', 580),\n",
        " ('IXR', 570),\n",
        " ('TKU', 570),\n",
        " ('MOT', 570),\n",
        " ('SCO', 570),\n",
        " ('ZWS', 570),\n",
        " ('AJF', 570),\n",
        " ('INN', 570),\n",
        " ('DLM', 560),\n",
        " ('OAJ', 560),\n",
        " ('RVN', 560),\n",
        " ('WUH', 560),\n",
        " ('EGE', 560),\n",
        " ('EYP', 560),\n",
        " ('MSO', 560),\n",
        " ('CGQ', 560),\n",
        " ('CJS', 550),\n",
        " ('YQT', 550),\n",
        " ('ADE', 550),\n",
        " ('FNA', 550),\n",
        " ('SXF', 550),\n",
        " ('HDY', 550),\n",
        " ('HHH', 550),\n",
        " ('ASP', 550),\n",
        " ('QSF', 540),\n",
        " ('TER', 540),\n",
        " ('ISP', 540),\n",
        " ('DIY', 540),\n",
        " ('AXM', 540),\n",
        " ('QKL', 540),\n",
        " ('VOG', 540),\n",
        " ('EVV', 530),\n",
        " ('NLA', 530),\n",
        " ('YQM', 530),\n",
        " ('SBN', 530),\n",
        " ('RTM', 530),\n",
        " ('MLH', 530),\n",
        " ('BQN', 530),\n",
        " ('BGR', 530),\n",
        " ('RNS', 530),\n",
        " ('LNK', 520),\n",
        " ('MQP', 520),\n",
        " ('ISA', 520),\n",
        " ('SKT', 520),\n",
        " ('ASW', 520),\n",
        " ('OSD', 520),\n",
        " ('PMR', 520),\n",
        " ('IMF', 510),\n",
        " ('MOV', 510),\n",
        " ('CAY', 510),\n",
        " ('LGQ', 510),\n",
        " ('NTL', 510),\n",
        " ('LPQ', 510),\n",
        " ('KIM', 510),\n",
        " ('IKT', 510),\n",
        " ('ROK', 510),\n",
        " ('VLI', 500),\n",
        " ('MLN', 500),\n",
        " ('ORK', 500),\n",
        " ('GCI', 500),\n",
        " ('BNS', 500),\n",
        " ('MGM', 500),\n",
        " ('YYG', 500),\n",
        " ('YNB', 500),\n",
        " ('MUN', 500),\n",
        " ('AAR', 500),\n",
        " ('FNT', 500),\n",
        " ('SOU', 500),\n",
        " ('NVA', 490),\n",
        " ('ZLO', 490),\n",
        " ('KIS', 490),\n",
        " ('ARI', 490),\n",
        " ('JNU', 480),\n",
        " ('TRI', 480),\n",
        " ('RCH', 480),\n",
        " ('KGS', 480),\n",
        " ('TPP', 470),\n",
        " ('LEI', 470),\n",
        " ('MWZ', 470),\n",
        " ('RAR', 470),\n",
        " ('BFL', 470),\n",
        " ('DLH', 460),\n",
        " ('TRC', 460),\n",
        " ('NIM', 460),\n",
        " ('LSC', 450),\n",
        " ('CFS', 450),\n",
        " ('TET', 450),\n",
        " ('JKH', 450),\n",
        " ('ELQ', 450),\n",
        " ('KSC', 450),\n",
        " ('DZA', 450),\n",
        " ('YXU', 450),\n",
        " ('UKK', 440),\n",
        " ('OKA', 440),\n",
        " ('SBW', 440),\n",
        " ('YFC', 440),\n",
        " ('KSU', 440),\n",
        " ('AXU', 440),\n",
        " ('SKB', 440),\n",
        " ('TCQ', 440),\n",
        " ('KTW', 440),\n",
        " ('NQN', 430),\n",
        " ('SDR', 430),\n",
        " ('DYU', 430),\n",
        " ('TLC', 430),\n",
        " ('DVO', 430),\n",
        " ('LNZ', 420),\n",
        " ('HTI', 420),\n",
        " ('AZO', 420),\n",
        " ('TAM', 420),\n",
        " ('LVI', 420),\n",
        " ('CPE', 420),\n",
        " ('POL', 410),\n",
        " ('BRO', 410),\n",
        " ('CME', 410),\n",
        " ('SBH', 410),\n",
        " ('EMD', 410),\n",
        " ('LDB', 410),\n",
        " ('RDM', 410),\n",
        " ('FBM', 410),\n",
        " ('IBE', 410),\n",
        " ('GTF', 410),\n",
        " ('BON', 410),\n",
        " ('DGO', 410),\n",
        " ('SLW', 410),\n",
        " ('SPN', 400),\n",
        " ('NUX', 400),\n",
        " ('PUY', 400),\n",
        " ('MLU', 400),\n",
        " ('LXR', 400),\n",
        " ('FMO', 400),\n",
        " ('BME', 400),\n",
        " ('GET', 400),\n",
        " ('TMP', 400),\n",
        " ('NJF', 400),\n",
        " ('MUB', 400),\n",
        " ('TIR', 400),\n",
        " ('ETH', 390),\n",
        " ('TVC', 390),\n",
        " ('ADQ', 390),\n",
        " ('SDL', 390),\n",
        " ('LTN', 390),\n",
        " ('IPC', 390),\n",
        " ('TBP', 390),\n",
        " ('JUL', 390),\n",
        " ('UBP', 390),\n",
        " ('BHI', 390),\n",
        " ('LBU', 390),\n",
        " ('CSX', 390),\n",
        " ('ROT', 390),\n",
        " ('LST', 380),\n",
        " ('NBC', 380),\n",
        " ('ELM', 380),\n",
        " ('NPE', 380),\n",
        " ('KBR', 380),\n",
        " ('BJR', 380),\n",
        " ('MEC', 380),\n",
        " ('ITH', 380),\n",
        " ('IXS', 370),\n",
        " ('RKT', 370),\n",
        " ('DHN', 370),\n",
        " ('FLO', 370),\n",
        " ('VUP', 370),\n",
        " ('IVL', 370),\n",
        " ('YNT', 370),\n",
        " ('CPR', 370),\n",
        " ('ROB', 370),\n",
        " ('RZE', 360),\n",
        " ('YQQ', 360),\n",
        " ('HRB', 360),\n",
        " ('FRO', 360),\n",
        " ('PDP', 360),\n",
        " ('MRA', 360),\n",
        " ('NPL', 360),\n",
        " ('EIS', 360),\n",
        " ('YNJ', 360),\n",
        " ('LAE', 360),\n",
        " ('OCC', 360),\n",
        " ('SEB', 350),\n",
        " ('EAS', 350),\n",
        " ('RTB', 350),\n",
        " ('SYX', 350),\n",
        " ('FLG', 350),\n",
        " ('YUM', 350),\n",
        " ('EJA', 350),\n",
        " ('BHE', 350),\n",
        " ('ASR', 350),\n",
        " ('VXE', 350),\n",
        " ('BET', 340),\n",
        " ('PAZ', 340),\n",
        " ('CJU', 340),\n",
        " ('YQU', 340),\n",
        " ('SCE', 340),\n",
        " ('EOH', 340),\n",
        " ('STX', 340),\n",
        " ('AJL', 340),\n",
        " ('LYR', 340),\n",
        " ('HFT', 340),\n",
        " ('TNA', 340),\n",
        " ('CPC', 340),\n",
        " ('SMI', 340),\n",
        " ('CIT', 340),\n",
        " ('KKN', 330),\n",
        " ('JIB', 330),\n",
        " ('HME', 330),\n",
        " ('BEL', 330),\n",
        " ('TSN', 330),\n",
        " ('NWI', 330),\n",
        " ('YXS', 330),\n",
        " ('TOF', 330),\n",
        " ('CSG', 330),\n",
        " ('YCD', 330),\n",
        " ('BWN', 320),\n",
        " ('SAF', 320),\n",
        " ('EVE', 320),\n",
        " ('STN', 320),\n",
        " ('SWF', 320),\n",
        " ('GND', 320),\n",
        " ('MZL', 320),\n",
        " ('ALH', 320),\n",
        " ('HGU', 320),\n",
        " ('GFK', 320),\n",
        " ('EWN', 320),\n",
        " ('IXA', 310),\n",
        " ('KZO', 310),\n",
        " ('TWU', 310),\n",
        " ('AKX', 310),\n",
        " ('XFW', 310),\n",
        " ('VFA', 310),\n",
        " ('HRL', 310),\n",
        " ('XER', 310),\n",
        " ('LEA', 310),\n",
        " ('GZT', 310),\n",
        " ('KUO', 310),\n",
        " ('GGT', 310),\n",
        " ('ABS', 310),\n",
        " ('IXL', 300),\n",
        " ('VLD', 300),\n",
        " ('PQQ', 300),\n",
        " ('MQX', 300),\n",
        " ('SBP', 300),\n",
        " ('MLM', 300),\n",
        " ('PEM', 300),\n",
        " ('LYH', 300),\n",
        " ('SFT', 300),\n",
        " ('YZF', 300),\n",
        " ('NJC', 300),\n",
        " ('ABX', 300),\n",
        " ('VIL', 300),\n",
        " ('ASF', 300),\n",
        " ('RNB', 300),\n",
        " ('PLQ', 300),\n",
        " ('IXJ', 290),\n",
        " ('VBY', 290),\n",
        " ('CWA', 290),\n",
        " ('BUS', 290),\n",
        " ('CJA', 290),\n",
        " ('INV', 290),\n",
        " ('CLY', 290),\n",
        " ('VGA', 290),\n",
        " ('FSM', 290),\n",
        " ('SGC', 290),\n",
        " ('REX', 290),\n",
        " ('LFW', 290),\n",
        " ('PIX', 290),\n",
        " ('ABT', 290),\n",
        " ('BHH', 290),\n",
        " ('TZX', 290),\n",
        " ('PPG', 290),\n",
        " ('AGH', 280),\n",
        " ('BTU', 280),\n",
        " ('LOP', 280),\n",
        " ('WGA', 280),\n",
        " ('ERI', 280),\n",
        " ('ATZ', 280),\n",
        " ('UDI', 280),\n",
        " ('LXS', 280),\n",
        " ('UTH', 280),\n",
        " ('NDJ', 280),\n",
        " ('YXJ', 280),\n",
        " ('SLZ', 280),\n",
        " ('MAM', 270),\n",
        " ('NOZ', 270),\n",
        " ('WEH', 270),\n",
        " ('STD', 270),\n",
        " ('TPS', 270),\n",
        " ('ISN', 270),\n",
        " ('FRS', 270),\n",
        " ('YYD', 270),\n",
        " ('UTN', 270),\n",
        " ('YIW', 270),\n",
        " ('UAQ', 270),\n",
        " ('LAO', 270),\n",
        " ('ASM', 270),\n",
        " ('BGM', 270),\n",
        " ('LSP', 260),\n",
        " ('PSS', 260),\n",
        " ('KAO', 260),\n",
        " ('BPS', 260),\n",
        " ('DIB', 260),\n",
        " ('NSN', 260),\n",
        " ('SDD', 260),\n",
        " ('CGR', 260),\n",
        " ('ISU', 260),\n",
        " ('HDN', 260),\n",
        " ('KEJ', 260),\n",
        " ('AXD', 260),\n",
        " ('TCO', 260),\n",
        " ('NDR', 260),\n",
        " ('KTT', 260),\n",
        " ('ASB', 260),\n",
        " ('PNA', 250),\n",
        " ('YSB', 250),\n",
        " ('CMI', 250),\n",
        " ('BNN', 250),\n",
        " ('KNX', 250),\n",
        " ('SYZ', 250),\n",
        " ('TAP', 250),\n",
        " ('PGF', 250),\n",
        " ('VVC', 250),\n",
        " ('KTN', 250),\n",
        " ('MUX', 250),\n",
        " ('LPI', 250),\n",
        " ('IDA', 250),\n",
        " ('NLK', 240),\n",
        " ('HMB', 240),\n",
        " ('CWL', 240),\n",
        " ('MOL', 240),\n",
        " ('RYK', 240),\n",
        " ('QQS', 240),\n",
        " ('ILO', 240),\n",
        " ('NGB', 240),\n",
        " ('MGQ', 240),\n",
        " ('JUJ', 240),\n",
        " ('JGA', 240),\n",
        " ('BOJ', 240),\n",
        " ('LAW', 240),\n",
        " ('MDQ', 240),\n",
        " ('CEN', 240),\n",
        " ('MCY', 240),\n",
        " ('LCH', 240),\n",
        " ('MTT', 240),\n",
        " ('CGY', 240),\n",
        " ('AQJ', 240),\n",
        " ('APL', 230),\n",
        " ('MQM', 230),\n",
        " ('MQL', 230),\n",
        " ('MOQ', 230),\n",
        " ('CLL', 230),\n",
        " ('RGI', 230),\n",
        " ('JHM', 230),\n",
        " ('YDF', 230),\n",
        " ('URC', 230),\n",
        " ('SDE', 230),\n",
        " ('GDZ', 230),\n",
        " ('WRE', 230),\n",
        " ('RAO', 230),\n",
        " ('FDH', 230),\n",
        " ('BCD', 230),\n",
        " ('LRD', 230),\n",
        " ('LRM', 230),\n",
        " ('FEZ', 230),\n",
        " ('HLZ', 220),\n",
        " ('YSJ', 220),\n",
        " ('SUV', 220),\n",
        " ('HRK', 220),\n",
        " ('LDE', 220),\n",
        " ('SFG', 220),\n",
        " ('MES', 220),\n",
        " ('BHU', 220),\n",
        " ('MTJ', 220),\n",
        " ('LRT', 220),\n",
        " ('UGC', 220),\n",
        " ('LNY', 210),\n",
        " ('OME', 210),\n",
        " ('PCL', 210),\n",
        " ('VPY', 210),\n",
        " ('LDU', 210),\n",
        " ('YKA', 210),\n",
        " ('UTT', 210),\n",
        " ('AZA', 210),\n",
        " ('GIS', 210),\n",
        " ('FCA', 210),\n",
        " ('AOI', 210),\n",
        " ('TLE', 210),\n",
        " ('IVC', 210),\n",
        " ('XNB', 210),\n",
        " ('YXY', 210),\n",
        " ('SJT', 210),\n",
        " ('RAE', 210),\n",
        " ('BFS', 210),\n",
        " ('KWL', 210),\n",
        " ('KVA', 210),\n",
        " ('BBA', 200),\n",
        " ('SCN', 200),\n",
        " ('BSK', 200),\n",
        " ('SBY', 200),\n",
        " ('RGL', 200),\n",
        " ('SVD', 200),\n",
        " ('WVB', 200),\n",
        " ('ELH', 200),\n",
        " ('SGU', 200),\n",
        " ('PXO', 200),\n",
        " ('RES', 200),\n",
        " ('REL', 200),\n",
        " ('GWT', 200),\n",
        " ('KDV', 200),\n",
        " ('FAE', 200),\n",
        " ('ACK', 200),\n",
        " ('LAP', 200),\n",
        " ('LBD', 200),\n",
        " ('XMB', 200),\n",
        " ('DPO', 190),\n",
        " ('DMU', 190),\n",
        " ('ETZ', 190),\n",
        " ('COU', 190),\n",
        " ('TRG', 190),\n",
        " ('HTY', 190),\n",
        " ('SIT', 190),\n",
        " ('XYD', 190),\n",
        " ('BLI', 190),\n",
        " ('SZZ', 190),\n",
        " ('ACY', 190),\n",
        " ('MXL', 190),\n",
        " ('TOL', 190),\n",
        " ('HIR', 190),\n",
        " ('BGY', 190),\n",
        " ('USN', 190),\n",
        " ('MTS', 190),\n",
        " ('CGB', 190),\n",
        " ('VCP', 180),\n",
        " ('MQN', 180),\n",
        " ('DMS', 180),\n",
        " ('SCW', 180),\n",
        " ('DGT', 180),\n",
        " ('IMP', 180),\n",
        " ('UUD', 180),\n",
        " ('URA', 180),\n",
        " ('URY', 180),\n",
        " ('MGB', 180),\n",
        " ('GZP', 180),\n",
        " ('MHK', 180),\n",
        " ('RCB', 180),\n",
        " ('KUA', 180),\n",
        " ('IUE', 180),\n",
        " ('TOE', 180),\n",
        " ('HIJ', 180),\n",
        " ('PWQ', 180),\n",
        " ('MBS', 180),\n",
        " ('BVC', 180),\n",
        " ('LSI', 170),\n",
        " ('LMP', 170),\n",
        " ('EDL', 170),\n",
        " ('AFA', 170),\n",
        " ('FKB', 170),\n",
        " ('PAD', 170),\n",
        " ('VRA', 170),\n",
        " ('RKS', 170),\n",
        " ('HOV', 170),\n",
        " ('KLU', 170),\n",
        " ('EXT', 170),\n",
        " ('JJN', 170),\n",
        " ('STW', 170),\n",
        " ('ENA', 170),\n",
        " ('HAH', 170),\n",
        " ('JHB', 170),\n",
        " ('LKN', 170),\n",
        " ('PFO', 170),\n",
        " ('PZB', 170),\n",
        " ('YYB', 170),\n",
        " ('TYR', 170),\n",
        " ('CRK', 170),\n",
        " ('BDB', 170),\n",
        " ('DBO', 160),\n",
        " ('SNU', 160),\n",
        " ('BTM', 160),\n",
        " ('RMI', 160),\n",
        " ('SRG', 160),\n",
        " ('IOM', 160),\n",
        " ('SCQ', 160),\n",
        " ('YQG', 160),\n",
        " ('EAT', 160),\n",
        " ('MME', 160),\n",
        " ('FRW', 160),\n",
        " ('DIK', 160),\n",
        " ('DIR', 160),\n",
        " ('BOB', 160),\n",
        " ('OZZ', 160),\n",
        " ('CAB', 160),\n",
        " ('OGZ', 160),\n",
        " ('URT', 160),\n",
        " ('HVB', 160),\n",
        " ('ACT', 160),\n",
        " ('VIG', 160),\n",
        " ('THE', 160),\n",
        " ('KME', 160),\n",
        " ('LSE', 150),\n",
        " ('YAM', 150),\n",
        " ('PIH', 150),\n",
        " ('SRE', 150),\n",
        " ('YQX', 150),\n",
        " ('DNZ', 150),\n",
        " ('ESM', 150),\n",
        " ('LMM', 150),\n",
        " ('SWA', 150),\n",
        " ('ZCL', 150),\n",
        " ('HUY', 150),\n",
        " ('YXX', 150),\n",
        " ('ALF', 150),\n",
        " ('ABI', 150),\n",
        " ('VII', 150),\n",
        " ('EPR', 150),\n",
        " ('OMR', 150),\n",
        " ('PPP', 150),\n",
        " ('ANR', 150),\n",
        " ('ARK', 150),\n",
        " ('VOZ', 150),\n",
        " ('ULV', 150),\n",
        " ('MAG', 140),\n",
        " ('MQF', 140),\n",
        " ('SCU', 140),\n",
        " ('KOK', 140),\n",
        " ('STS', 140),\n",
        " ('BKG', 140),\n",
        " ('GOV', 140),\n",
        " ('RIY', 140),\n",
        " ('HAK', 140),\n",
        " ('EMA', 140),\n",
        " ('LYP', 140),\n",
        " ('TRW', 140),\n",
        " ('CNQ', 140),\n",
        " ('TAC', 140),\n",
        " ('GIB', 140),\n",
        " ('REN', 140),\n",
        " ('PGV', 140),\n",
        " ('PPN', 140),\n",
        " ('SFL', 140),\n",
        " ('GTR', 140),\n",
        " ('HVN', 140),\n",
        " ('TMW', 140),\n",
        " ('TMM', 140),\n",
        " ('ACV', 140),\n",
        " ('YXT', 140),\n",
        " ('KGF', 140),\n",
        " ('DTM', 140),\n",
        " ('FTU', 140),\n",
        " ('CBT', 140),\n",
        " ('MDC', 140),\n",
        " ('LBS', 140),\n",
        " ('PKZ', 140),\n",
        " ('PLU', 140),\n",
        " ('PLO', 140),\n",
        " ('ARM', 140),\n",
        " ('SPS', 130),\n",
        " ('YBL', 130),\n",
        " ('HLN', 130),\n",
        " ('XDB', 130),\n",
        " ('DOM', 130),\n",
        " ('HJR', 130),\n",
        " ('ENU', 130),\n",
        " ('BNK', 130),\n",
        " ('GEV', 130),\n",
        " ('HTA', 130),\n",
        " ('HTS', 130),\n",
        " ('UEL', 130),\n",
        " ('AZR', 130),\n",
        " ('OER', 130),\n",
        " ('BLZ', 130),\n",
        " ('LTO', 130),\n",
        " ('AHU', 130),\n",
        " ('IPT', 130),\n",
        " ('YTS', 130),\n",
        " ('SKD', 130),\n",
        " ('NVT', 130),\n",
        " ('HFE', 130),\n",
        " ('TXK', 130),\n",
        " ('KWE', 130),\n",
        " ('SLY', 130),\n",
        " ('KHG', 130),\n",
        " ('ROS', 130),\n",
        " ('ROW', 130),\n",
        " ('HLM', 120),\n",
        " ('PNL', 120),\n",
        " ('PRI', 120),\n",
        " ('SSJ', 120),\n",
        " ('TUO', 120),\n",
        " ('ZFV', 120),\n",
        " ('UIP', 120),\n",
        " ('YQY', 120),\n",
        " ('YGK', 120),\n",
        " ('RYG', 120),\n",
        " ('WUX', 120),\n",
        " ('BAX', 120),\n",
        " ('RFP', 120),\n",
        " ('YWK', 120),\n",
        " ('YVO', 120),\n",
        " ('SFN', 120),\n",
        " ('HUX', 120),\n",
        " ('BLJ', 120),\n",
        " ('LZH', 120),\n",
        " ('YYF', 120),\n",
        " ('MYW', 120),\n",
        " ('NHA', 120),\n",
        " ('LPL', 120),\n",
        " ('SON', 120),\n",
        " ('OSM', 120),\n",
        " ('BDU', 120),\n",
        " ('SPI', 110),\n",
        " ('BEW', 110),\n",
        " ('OND', 110),\n",
        " ('CFR', 110),\n",
        " ('QOW', 110),\n",
        " ('WYA', 110),\n",
        " ('ETR', 110),\n",
        " ('TDD', 110),\n",
        " ('NMA', 110),\n",
        " ('LOH', 110),\n",
        " ('IOS', 110),\n",
        " ('IOA', 110),\n",
        " ('BRW', 110),\n",
        " ('AKN', 110),\n",
        " ('JKG', 110),\n",
        " ('AJU', 110),\n",
        " ('ZBF', 110),\n",
        " ('LET', 110),\n",
        " ('TAI', 110),\n",
        " ('MJF', 110),\n",
        " ('MJV', 110),\n",
        " ('SZF', 110),\n",
        " ('SKN', 110),\n",
        " ('TMS', 110),\n",
        " ('DEA', 110),\n",
        " ('OSS', 110),\n",
        " ('SJP', 110),\n",
        " ('ASO', 110),\n",
        " ('GES', 110),\n",
        " ('OLP', 110),\n",
        " ('ANX', 110),\n",
        " ('KHS', 110),\n",
        " ('BDO', 110),\n",
        " ('AGT', 100),\n",
        " ('MAB', 100),\n",
        " ('SNR', 100),\n",
        " ('NOS', 100),\n",
        " ('GCC', 100),\n",
        " ('BBO', 100),\n",
        " ('PAS', 100),\n",
        " ('PDG', 100),\n",
        " ('MQT', 100),\n",
        " ('WEI', 100),\n",
        " ('TVU', 100),\n",
        " ('MLO', 100),\n",
        " ('MMO', 100),\n",
        " ('KAN', 100),\n",
        " ('HAD', 100),\n",
        " ('LWB', 100),\n",
        " ('BQS', 100),\n",
        " ('TAY', 100),\n",
        " ('WLS', 100),\n",
        " ('FMA', 100),\n",
        " ('AOK', 100),\n",
        " ('KSD', 100),\n",
        " ('SHW', 100),\n",
        " ('SVJ', 100),\n",
        " ('OAG', 100),\n",
        " ('CBQ', 100),\n",
        " ('VNX', 100),\n",
        " ('OZH', 100),\n",
        " ('CRL', 100),\n",
        " ('RNN', 100),\n",
        " ('PQI', 90),\n",
        " ('TTN', 90),\n",
        " ('WHK', 90),\n",
        " ('UKS', 90),\n",
        " ('ISG', 90),\n",
        " ('GUC', 90),\n",
        " ('CYS', 90),\n",
        " ('XDS', 90),\n",
        " ('RJA', 90),\n",
        " ('UIB', 90),\n",
        " ('PBC', 90),\n",
        " ('EAR', 90),\n",
        " ('HOG', 90),\n",
        " ('KLO', 90),\n",
        " ('VAI', 90),\n",
        " ('VAN', 90),\n",
        " ('CMX', 90),\n",
        " ('KOI', 90),\n",
        " ('GOP', 90),\n",
        " ('GDQ', 90),\n",
        " ('YKS', 90),\n",
        " ('ZBL', 90),\n",
        " ('DIU', 90),\n",
        " ('VDS', 90),\n",
        " ('TAE', 90),\n",
        " ('FMN', 90),\n",
        " ('GHA', 90),\n",
        " ('HDS', 90),\n",
        " ('YHM', 90),\n",
        " ('KEM', 90),\n",
        " ('OTZ', 90),\n",
        " ('ZAL', 90),\n",
        " ('ZAD', 90),\n",
        " ('MDG', 90),\n",
        " ('MVY', 90),\n",
        " ('HID', 90),\n",
        " ('ABA', 90),\n",
        " ('ABY', 90),\n",
        " ('BHV', 90),\n",
        " ('KWJ', 90),\n",
        " ('MCP', 90),\n",
        " ('FDE', 90),\n",
        " ('KHN', 90),\n",
        " ('QYG', 90),\n",
        " ('DAM', 90),\n",
        " ('AGX', 80),\n",
        " ('GRI', 80),\n",
        " ('JOE', 80),\n",
        " ('JAL', 80),\n",
        " ('JLN', 80),\n",
        " ('VRK', 80),\n",
        " ('LOK', 80),\n",
        " ('PTG', 80),\n",
        " ('MPH', 80),\n",
        " ('TEE', 80),\n",
        " ('KLR', 80),\n",
        " ('INI', 80),\n",
        " ('KOJ', 80),\n",
        " ('KOE', 80),\n",
        " ('LIG', 80),\n",
        " ('KAJ', 80),\n",
        " ('CLD', 80),\n",
        " ('CLQ', 80),\n",
        " ('VQS', 80),\n",
        " ('RGA', 80),\n",
        " ('WAE', 80),\n",
        " ('NAL', 80),\n",
        " ('GXF', 80),\n",
        " ('UET', 80),\n",
        " ('PXM', 80),\n",
        " ('TAK', 80),\n",
        " ('LZC', 80),\n",
        " ('DIL', 80),\n",
        " ('MKK', 80),\n",
        " ('SHR', 80),\n",
        " ('TBU', 80),\n",
        " ('LUQ', 80),\n",
        " ('LUO', 80),\n",
        " ('ZAM', 80),\n",
        " ('GKA', 80),\n",
        " ('MHQ', 80),\n",
        " ('LAQ', 80),\n",
        " ('SMA', 80),\n",
        " ('DUT', 80),\n",
        " ('EFL', 80),\n",
        " ('KYA', 70),\n",
        " ('PNI', 70),\n",
        " ('NLD', 70),\n",
        " ('WYS', 70),\n",
        " ('CKS', 70),\n",
        " ('CVM', 70),\n",
        " ('QRW', 70),\n",
        " ('SUJ', 70),\n",
        " ('NBE', 70),\n",
        " ('BRD', 70),\n",
        " ('LHW', 70),\n",
        " ('INH', 70),\n",
        " ('NCU', 70),\n",
        " ('SUN', 70),\n",
        " ('SUX', 70),\n",
        " ('OXB', 70),\n",
        " ('TGG', 70),\n",
        " ('YKF', 70),\n",
        " ('NAV', 70),\n",
        " ('BQK', 70),\n",
        " ('RRS', 70),\n",
        " ('LEB', 70),\n",
        " ('GUR', 70),\n",
        " ('HUH', 70),\n",
        " ('SOG', 70),\n",
        " ('GNY', 70),\n",
        " ('OTH', 70),\n",
        " ('SJZ', 70),\n",
        " ('JRH', 70),\n",
        " ('LWS', 70),\n",
        " ('LAI', 70),\n",
        " ('BHK', 70),\n",
        " ('BHB', 70),\n",
        " ('BHQ', 70),\n",
        " ('LPT', 70),\n",
        " ('PKE', 70),\n",
        " ('BIM', 70),\n",
        " ('JPA', 70),\n",
        " ('GFF', 70),\n",
        " ('VXO', 70),\n",
        " ('RAB', 70),\n",
        " ('PLN', 70),\n",
        " ('ART', 70),\n",
        " ('AGF', 60),\n",
        " ('GRW', 60),\n",
        " ('GRO', 60),\n",
        " ('TJU', 60),\n",
        " ('LMT', 60),\n",
        " ('CFK', 60),\n",
        " ('JOI', 60),\n",
        " ('APO', 60),\n",
        " ('DBQ', 60),\n",
        " ('DLG', 60),\n",
        " ('TUK', 60),\n",
        " ('POR', 60),\n",
        " ('CYB', 60),\n",
        " ('VCS', 60),\n",
        " ('VLL', 60),\n",
        " ('DCM', 60),\n",
        " ('BCM', 60),\n",
        " ('SRP', 60),\n",
        " ('TEB', 60),\n",
        " ('TWF', 60),\n",
        " ('VSG', 60),\n",
        " ('SCY', 60),\n",
        " ('PUU', 60),\n",
        " ('KNS', 60),\n",
        " ('JYV', 60),\n",
        " ('BPT', 60),\n",
        " ('ILG', 60),\n",
        " ('WAG', 60),\n",
        " ('JHG', 60),\n",
        " ('NDG', 60),\n",
        " ('SVB', 60),\n",
        " ('SVP', 60),\n",
        " ('HOD', 60),\n",
        " ('ESC', 60),\n",
        " ('ELU', 60),\n",
        " ('AOE', 60),\n",
        " ('KSY', 60),\n",
        " ('TBZ', 60),\n",
        " ('NAO', 60),\n",
        " ('PHW', 60),\n",
        " ('NVK', 60),\n",
        " ('NVI', 60),\n",
        " ('KRP', 60),\n",
        " ('MYA', 60),\n",
        " ('AMH', 60),\n",
        " ('JST', 60),\n",
        " ('YXC', 60),\n",
        " ('VHC', 60),\n",
        " ('KGC', 60),\n",
        " ('CBB', 60),\n",
        " ('CBO', 60),\n",
        " ('MVR', 60),\n",
        " ('ALW', 60),\n",
        " ('BHY', 60),\n",
        " ('CEG', 60),\n",
        " ('GDX', 60),\n",
        " ('DGE', 60),\n",
        " ('HKK', 60),\n",
        " ('MBI', 60),\n",
        " ('PPS', 60),\n",
        " ('ROR', 60),\n",
        " ('YCG', 60),\n",
        " ('CIC', 60),\n",
        " ('AQI', 60),\n",
        " ('DWC', 60),\n",
        " ('KRO', 60),\n",
        " ('AGR', 50),\n",
        " ('BYC', 50),\n",
        " ('GST', 50),\n",
        " ('TKG', 50),\n",
        " ('HMA', 50),\n",
        " ('AJR', 50),\n",
        " ('PBD', 50),\n",
        " ('STV', 50),\n",
        " ('MYD', 50),\n",
        " ('RHI', 50),\n",
        " ('PVH', 50),\n",
        " ('MLX', 50),\n",
        " ('RIW', 50),\n",
        " ('LXA', 50),\n",
        " ('RGK', 50),\n",
        " ('YKQ', 50),\n",
        " ('ZTH', 50),\n",
        " ('RUT', 50),\n",
        " ('MRZ', 50),\n",
        " ('SDY', 50),\n",
        " ('YVP', 50),\n",
        " ('RDZ', 50),\n",
        " ('AZS', 50),\n",
        " ('SGD', 50),\n",
        " ('LTX', 50),\n",
        " ('KSH', 50),\n",
        " ('YZV', 50),\n",
        " ('EUN', 50),\n",
        " ('ZAZ', 50),\n",
        " ('SKE', 50),\n",
        " ('YYR', 50),\n",
        " ('WSZ', 50),\n",
        " ('PIB', 50),\n",
        " ('PIR', 50),\n",
        " ('BKZ', 50),\n",
        " ('LWY', 50),\n",
        " ('CBH', 50),\n",
        " ('YCB', 50),\n",
        " ('NZH', 50),\n",
        " ('YFB', 50),\n",
        " ('EGO', 50),\n",
        " ('TYN', 50),\n",
        " ('BGF', 50),\n",
        " ('YLL', 50),\n",
        " ('USK', 50),\n",
        " ('KVD', 50),\n",
        " ('BVE', 50),\n",
        " ('LRS', 50),\n",
        " ('CGI', 50),\n",
        " ('PMW', 50),\n",
        " ('JZH', 50),\n",
        " ('MAS', 40),\n",
        " ('TJA', 40),\n",
        " ('NOV', 40),\n",
        " ('CTM', 40),\n",
        " ('LMN', 40),\n",
        " ('TKQ', 40),\n",
        " ('BBB', 40),\n",
        " ('BJZ', 40),\n",
        " ('TUP', 40),\n",
        " ('IMT', 40),\n",
        " ('DQA', 40),\n",
        " ('JLR', 40),\n",
        " ('MOD', 40),\n",
        " ('BPN', 40),\n",
        " ('DRT', 40),\n",
        " ('AJI', 40),\n",
        " ('YQD', 40),\n",
        " ('TEX', 40),\n",
        " ('GMB', 40),\n",
        " ('GMZ', 40),\n",
        " ('KZS', 40),\n",
        " ('BRN', 40),\n",
        " ('DEC', 40),\n",
        " ('EAU', 40),\n",
        " ('KLV', 40),\n",
        " ('HOR', 40),\n",
        " ('ZDH', 40),\n",
        " ('ZVE', 40),\n",
        " ('GLN', 40),\n",
        " ('BAY', 40),\n",
        " ('VPE', 40),\n",
        " ('STM', 40),\n",
        " ('JKL', 40),\n",
        " ('GOH', 40),\n",
        " ('BNI', 40),\n",
        " ('SYY', 40),\n",
        " ('ZIG', 40),\n",
        " ('LYC', 40),\n",
        " ('YJE', 40),\n",
        " ('ZUH', 40),\n",
        " ('LEH', 40),\n",
        " ('CND', 40),\n",
        " ('JTY', 40),\n",
        " ('HUI', 40),\n",
        " ('XKH', 40),\n",
        " ('LFR', 40),\n",
        " ('LTK', 40),\n",
        " ('CAL', 40),\n",
        " ('RSH', 40),\n",
        " ('NQY', 40),\n",
        " ('KSA', 40),\n",
        " ('YTM', 40),\n",
        " ('YTH', 40),\n",
        " ('TBN', 40),\n",
        " ('BBK', 40),\n",
        " ('RBQ', 40),\n",
        " ('LGP', 40),\n",
        " ('XJN', 40),\n",
        " ('MHC', 40),\n",
        " ('ZOS', 40),\n",
        " ('NNY', 40),\n",
        " ('HEA', 40),\n",
        " ('YYE', 40),\n",
        " ('SVU', 40),\n",
        " ('PIS', 40),\n",
        " ('VDZ', 40),\n",
        " ('ACI', 40),\n",
        " ('LLI', 40),\n",
        " ('ZFQ', 40),\n",
        " ('BZG', 40),\n",
        " ('GGA', 40),\n",
        " ('ALS', 40),\n",
        " ('TOD', 40),\n",
        " ('ABB', 40),\n",
        " ('RAH', 40),\n",
        " ('YMN', 40),\n",
        " ('IFO', 40),\n",
        " ('PKU', 40),\n",
        " ('PKB', 40),\n",
        " ('MZH', 40),\n",
        " ('MUR', 40),\n",
        " ('MCZ', 40),\n",
        " ('MCX', 40),\n",
        " ('MCW', 40),\n",
        " ('THS', 40),\n",
        " ('THR', 40),\n",
        " ('KIT', 40),\n",
        " ('KID', 40),\n",
        " ('LCE', 40),\n",
        " ('PLM', 40),\n",
        " ('IYK', 40),\n",
        " ('PSE', 40),\n",
        " ('TIN', 40),\n",
        " ('TIH', 40),\n",
        " ('HKN', 40),\n",
        " ('XAP', 40),\n",
        " ('LRH', 40),\n",
        " ('PMY', 40),\n",
        " ('FEG', 40),\n",
        " ('FEN', 40),\n",
        " ('BWT', 30),\n",
        " ('IXD', 30),\n",
        " ('NYM', 30),\n",
        " ('YBG', 30),\n",
        " ('GCK', 30),\n",
        " ('XCH', 30),\n",
        " ('RMF', 30),\n",
        " ('BBN', 30),\n",
        " ('PAH', 30),\n",
        " ('KMI', 30),\n",
        " ('KMQ', 30),\n",
        " ('SRZ', 30),\n",
        " ('YRT', 30),\n",
        " ('TDX', 30),\n",
        " ('EBJ', 30),\n",
        " ('RVK', 30),\n",
        " ('RKD', 30),\n",
        " ('PUW', 30),\n",
        " ('TFF', 30),\n",
        " ('KNU', 30),\n",
        " ('YQZ', 30),\n",
        " ('ZWE', 30),\n",
        " ('CZE', 30),\n",
        " ('DHM', 30),\n",
        " ('UDJ', 30),\n",
        " ('GOU', 30),\n",
        " ('LJG', 30),\n",
        " ('YKM', 30),\n",
        " ('TPQ', 30),\n",
        " ('DIE', 30),\n",
        " ('JHS', 30),\n",
        " ('NAA', 30),\n",
        " ('HOM', 30),\n",
        " ('KCM', 30),\n",
        " ('CNJ', 30),\n",
        " ('JIJ', 30),\n",
        " ('YTY', 30),\n",
        " ('SHC', 30),\n",
        " ('TKS', 30),\n",
        " ('RSD', 30),\n",
        " ('AOR', 30),\n",
        " ('KSM', 30),\n",
        " ('SZB', 30),\n",
        " ('GTE', 30),\n",
        " ('PHO', 30),\n",
        " ('TCB', 30),\n",
        " ('XMS', 30),\n",
        " ('BJI', 30),\n",
        " ('INL', 30),\n",
        " ('RBR', 30),\n",
        " ('KUK', 30),\n",
        " ('YXH', 30),\n",
        " ('KTE', 30),\n",
        " ('MEH', 30),\n",
        " ('CPD', 30),\n",
        " ('YCO', 30),\n",
        " ('ERZ', 30),\n",
        " ('TOY', 30),\n",
        " ('HIN', 30),\n",
        " ('BHS', 30),\n",
        " ('AAB', 30),\n",
        " ('LBE', 30),\n",
        " ('BXU', 30),\n",
        " ('CIY', 30),\n",
        " ('GAY', 30),\n",
        " ('LPP', 30),\n",
        " ('TBW', 30),\n",
        " ('KVG', 30),\n",
        " ('BVB', 30),\n",
        " ('OSY', 30),\n",
        " ('WIC', 30),\n",
        " ('MSJ', 30),\n",
        " ('AGB', 20),\n",
        " ('NDU', 20),\n",
        " ('NYT', 20),\n",
        " ('BEB', 20),\n",
        " ('GRV', 20),\n",
        " ('CTC', 20),\n",
        " ('UKX', 20),\n",
        " ('UKA', 20),\n",
        " ('CFN', 20),\n",
        " ('PNP', 20),\n",
        " ('PNT', 20),\n",
        " ('PNK', 20),\n",
        " ('XQE', 20),\n",
        " ('XQP', 20),\n",
        " ('JBR', 20),\n",
        " ('HMV', 20),\n",
        " ('BTS', 20),\n",
        " ('BTK', 20),\n",
        " ('PDS', 20),\n",
        " ('PAG', 20),\n",
        " ('DCN', 20),\n",
        " ('BUA', 20),\n",
        " ('XRF', 20),\n",
        " ('PSR', 20),\n",
        " ('KMS', 20),\n",
        " ('HPH', 20),\n",
        " ('CXB', 20),\n",
        " ('SCM', 20),\n",
        " ('SCC', 20),\n",
        " ('SCV', 20),\n",
        " ('MNG', 20),\n",
        " ('YQK', 20),\n",
        " ('DND', 20),\n",
        " ('GMR', 20),\n",
        " ('LKL', 20),\n",
        " ('HOF', 20),\n",
        " ('ESU', 20),\n",
        " ('YGW', 20),\n",
        " ('JSY', 20),\n",
        " ('CMF', 20),\n",
        " ('ZVK', 20),\n",
        " ('ZVJ', 20),\n",
        " ('INC', 20),\n",
        " ('XFN', 20),\n",
        " ('AUG', 20),\n",
        " ('PUB', 20),\n",
        " ('XHJ', 20),\n",
        " ('KOZ', 20),\n",
        " ('NCY', 20),\n",
        " ('FNJ', 20),\n",
        " ('WTL', 20),\n",
        " ('KUT', 20),\n",
        " ('PVC', 20),\n",
        " ('PDT', 20),\n",
        " ('OGX', 20),\n",
        " ('YWL', 20),\n",
        " ('YWH', 20),\n",
        " ('NRK', 20),\n",
        " ('RIB', 20),\n",
        " ('EQS', 20),\n",
        " ('YKU', 20),\n",
        " ('COQ', 20),\n",
        " ('FSP', 20),\n",
        " ('MKM', 20),\n",
        " ('NSK', 20),\n",
        " ('LYA', 20),\n",
        " ('YVQ', 20),\n",
        " ('SVA', 20),\n",
        " ('LKG', 20),\n",
        " ('TRO', 20),\n",
        " ('RRG', 20),\n",
        " ('RDD', 20),\n",
        " ('CNM', 20),\n",
        " ('YUY', 20),\n",
        " ('TSF', 20),\n",
        " ('HUU', 20),\n",
        " ('HCR', 20),\n",
        " ('EKO', 20),\n",
        " ('DIJ', 20),\n",
        " ('YIP', 20),\n",
        " ('VEL', 20),\n",
        " ('QUB', 20),\n",
        " ('QUO', 20),\n",
        " ('IBA', 20),\n",
        " ('RSA', 20),\n",
        " ('TBG', 20),\n",
        " ('GHB', 20),\n",
        " ('AOO', 20),\n",
        " ('AOJ', 20),\n",
        " ('PYH', 20),\n",
        " ('YZR', 20),\n",
        " ('SHD', 20),\n",
        " ('MGW', 20),\n",
        " ('YHD', 20),\n",
        " ('LUH', 20),\n",
        " ('ZYN', 20),\n",
        " ('WBM', 20),\n",
        " ('EJH', 20),\n",
        " ('NAJ', 20),\n",
        " ('IAM', 20),\n",
        " ('SKU', 20),\n",
        " ('SKZ', 20),\n",
        " ('MHH', 20),\n",
        " ('DDG', 20),\n",
        " ('TMR', 20),\n",
        " ('KRF', 20),\n",
        " ('YYQ', 20),\n",
        " ('PJG', 20),\n",
        " ('HYS', 20),\n",
        " ('EIN', 20),\n",
        " ('YOJ', 20),\n",
        " ('ACH', 20),\n",
        " ('BKW', 20),\n",
        " ('YXL', 20),\n",
        " ('MEI', 20),\n",
        " ('KGT', 20),\n",
        " ('EZS', 20),\n",
        " ('WRG', 20),\n",
        " ('MMU', 20),\n",
        " ('LAR', 20),\n",
        " ('MMH', 20),\n",
        " ('MXZ', 20),\n",
        " ('SMX', 20),\n",
        " ('GGW', 20),\n",
        " ('GGG', 20),\n",
        " ('HGR', 20),\n",
        " ('HGA', 20),\n",
        " ('BFF', 20),\n",
        " ('YPR', 20),\n",
        " ('FUT', 20),\n",
        " ('YPX', 20),\n",
        " ('CSY', 20),\n",
        " ('UNG', 20),\n",
        " ('OMD', 20),\n",
        " ('DMB', 20),\n",
        " ('AAN', 20),\n",
        " ('KWA', 20),\n",
        " ('KWG', 20),\n",
        " ('SLM', 20),\n",
        " ('SLI', 20),\n",
        " ('MCN', 20),\n",
        " ('MCK', 20),\n",
        " ('GFN', 20),\n",
        " ('KIJ', 20),\n",
        " ('QJZ', 20),\n",
        " ('WNP', 20),\n",
        " ('PLX', 20),\n",
        " ('PQS', 20),\n",
        " ('YMO', 20),\n",
        " ('HKD', 20),\n",
        " ('KVX', 20),\n",
        " ('ROO', 20),\n",
        " ('OSW', 20),\n",
        " ('ROP', 20),\n",
        " ('BDJ', 20),\n",
        " ('LRE', 20),\n",
        " ('VOL', 20),\n",
        " ('CIJ', 20),\n",
        " ('MSS', 20),\n",
        " ('CIU', 20),\n",
        " ('MSE', 20),\n",
        " ('BJF', 10),\n",
        " ('JNX', 10),\n",
        " ('MAJ', 10),\n",
        " ('NOJ', 10),\n",
        " ('NOC', 10),\n",
        " ('KKE', 10),\n",
        " ('CTL', 10),\n",
        " ('ORB', 10),\n",
        " ('JAV', 10),\n",
        " ('APN', 10),\n",
        " ('DLZ', 10),\n",
        " ('TUB', 10),\n",
        " ('CYZ', 10),\n",
        " ('AWZ', 10),\n",
        " ('BUL', 10),\n",
        " ('KUH', 10),\n",
        " ('YUD', 10),\n",
        " ('KWN', 10),\n",
        " ('CXJ', 10),\n",
        " ('PBG', 10),\n",
        " ('KZR', 10),\n",
        " ('GJL', 10),\n",
        " ('HOB', 10),\n",
        " ('YGX', 10),\n",
        " ('WUS', 10),\n",
        " ('ORU', 10),\n",
        " ('CMG', 10),\n",
        " ('AKF', 10),\n",
        " ('BQB', 10),\n",
        " ('HFS', 10),\n",
        " ('KAD', 10),\n",
        " ('ISE', 10),\n",
        " ('UUA', 10),\n",
        " ('TGM', 10),\n",
        " ('MLW', 10),\n",
        " ('MIM', 10),\n",
        " ('HSN', 10),\n",
        " ('RGS', 10),\n",
        " ('GDE', 10),\n",
        " ('JOS', 10),\n",
        " ('WWK', 10),\n",
        " ('PED', 10),\n",
        " ('MKG', 10),\n",
        " ('SDN', 10),\n",
        " ('ILD', 10),\n",
        " ('VVZ', 10),\n",
        " ('COD', 10),\n",
        " ('KSQ', 10),\n",
        " ('CNY', 10),\n",
        " ('HUE', 10),\n",
        " ('KPO', 10),\n",
        " ('YIH', 10),\n",
        " ('RSU', 10),\n",
        " ('XZI', 10),\n",
        " ('NGS', 10),\n",
        " ('YZP', 10),\n",
        " ('YZZ', 10),\n",
        " ('UTP', 10),\n",
        " ('YHO', 10),\n",
        " ('LUG', 10),\n",
        " ('ZSE', 10),\n",
        " ('ZSA', 10),\n",
        " ('DZN', 10),\n",
        " ('AXA', 10),\n",
        " ('PZU', 10),\n",
        " ('IWK', 10),\n",
        " ('PZH', 10),\n",
        " ('SKK', 10),\n",
        " ('TMX', 10),\n",
        " ('HET', 10),\n",
        " ('NDB', 10),\n",
        " ('HYN', 10),\n",
        " ('KGP', 10),\n",
        " ('UAK', 10),\n",
        " ('JQA', 10),\n",
        " ('MXX', 10),\n",
        " ('CHU', 10),\n",
        " ('SMK', 10),\n",
        " ('ERS', 10),\n",
        " ('ALO', 10),\n",
        " ('EGC', 10),\n",
        " ('BFD', 10),\n",
        " ('LPK', 10),\n",
        " ('CEC', 10),\n",
        " ('SZA', 10),\n",
        " ('CRI', 10),\n",
        " ('DVL', 10),\n",
        " ('CDV', 10),\n",
        " ('PSG', 10),\n",
        " ('YMT', 10),\n",
        " ('SOC', 10),\n",
        " ('SOM', 10),\n",
        " ('TIZ', 10),\n",
        " ('TIU', 10),\n",
        " ('TIM', 10),\n",
        " ('KVL', 10),\n",
        " ('OSR', 10),\n",
        " ('CUM', 10),\n",
        " ('MSZ', 10),\n",
        " ('MSL', 10),\n",
        " ('DWD', 10),\n",
        " ('AGM', 0),\n",
        " ('SPP', 0),\n",
        " ('XPJ', 0),\n",
        " ('MAU', 0),\n",
        " ('VLV', 0),\n",
        " ('UKB', 0),\n",
        " ('JIK', 0),\n",
        " ('SAB', 0),\n",
        " ('JOG', 0),\n",
        " ('UYU', 0),\n",
        " ('BTH', 0),\n",
        " ('TUI', 0),\n",
        " ('AKY', 0),\n",
        " ('VCT', 0),\n",
        " ('CWC', 0),\n",
        " ('LSA', 0),\n",
        " ('OIA', 0),\n",
        " ('ABK', 0),\n",
        " ('YRL', 0),\n",
        " ('HLD', 0),\n",
        " ('RJK', 0),\n",
        " ('OHH', 0),\n",
        " ('CXI', 0),\n",
        " ('CJJ', 0),\n",
        " ('MPN', 0),\n",
        " ('HRI', 0),\n",
        " ('BRL', 0),\n",
        " ('KLX', 0),\n",
        " ('YGJ', 0),\n",
        " ('YGR', 0),\n",
        " ('WUA', 0),\n",
        " ('CMW', 0),\n",
        " ('GLH', 0),\n",
        " ('ERC', 0),\n",
        " ('BAL', 0),\n",
        " ('KAC', 0),\n",
        " ('RHD', 0),\n",
        " ('CZX', 0),\n",
        " ('HJJ', 0),\n",
        " ('ATY', 0),\n",
        " ('PVK', 0),\n",
        " ('TGR', 0),\n",
        " ('HSL', 0),\n",
        " ('RIL', 0),\n",
        " ('BND', 0),\n",
        " ('LXG', 0),\n",
        " ('YEV', 0),\n",
        " ('ILY', 0),\n",
        " ('DIG', 0),\n",
        " ('IRJ', 0),\n",
        " ('SDP', 0),\n",
        " ('LYG', 0),\n",
        " ('IPH', 0),\n",
        " ('FSZ', 0),\n",
        " ('ELD', 0),\n",
        " ('OZC', 0),\n",
        " ('AZN', 0),\n",
        " ('NGY', 0),\n",
        " ('MWA', 0),\n",
        " ('MJN', 0),\n",
        " ('PGA', 0),\n",
        " ('DYG', 0),\n",
        " ('XZZ', 0),\n",
        " ('IPN', 0),\n",
        " ('SFJ', 0),\n",
        " ('SHP', 0),\n",
        " ('JTC', 0),\n",
        " ('YHY', 0),\n",
        " ('LUD', 0),\n",
        " ('LUM', 0),\n",
        " ('HVG', 0),\n",
        " ('AXP', 0),\n",
        " ('GWL', 0),\n",
        " ('YYU', 0),\n",
        " ('WMN', 0),\n",
        " ('ZLN', 0),\n",
        " ('KUS', 0),\n",
        " ('KUN', 0),\n",
        " ('YXN', 0),\n",
        " ('SJW', 0),\n",
        " ('YNZ', 0),\n",
        " ('TNN', 0),\n",
        " ('QDU', 0),\n",
        " ('UAH', 0),\n",
        " ('IGD', 0),\n",
        " ('CBG', 0),\n",
        " ('NTG', 0),\n",
        " ('BZO', 0),\n",
        " ('MDL', 0),\n",
        " ('ALP', 0),\n",
        " ('XOP', 0),\n",
        " ('KTL', 0),\n",
        " ('EGM', 0),\n",
        " ('FUN', 0),\n",
        " ('CED', 0),\n",
        " ('ABR', 0),\n",
        " ('PQC', 0),\n",
        " ('SLU', 0),\n",
        " ('MCE', 0),\n",
        " ('BUN', 0),\n",
        " ('KMJ', 0),\n",
        " ('LRR', 0),\n",
        " ('MSR', 0),\n",
        " ('ZHA', 0),\n",
        " ('ULH', 0),\n",
        " ('DPL', -10),\n",
        " ('TUG', -10),\n",
        " ('JMU', -10),\n",
        " ('SUG', -10),\n",
        " ('YQL', -10),\n",
        " ('LDH', -10),\n",
        " ('SNE', -10),\n",
        " ('MGF', -10),\n",
        " ('XJY', -10),\n",
        " ('YOP', -10),\n",
        " ('JSI', -10),\n",
        " ('LBL', -10),\n",
        " ('OSK', -10),\n",
        " ('BER', -20),\n",
        " ('KKJ', -20),\n",
        " ('TAG', -20),\n",
        " ('YAY', -20),\n",
        " ('YRB', -20),\n",
        " ('XUZ', -20),\n",
        " ('FLA', -20),\n",
        " ('VDM', -20),\n",
        " ('LEN', -20),\n",
        " ('HDG', -20),\n",
        " ('KSN', -20),\n",
        " ('CPQ', -20),\n",
        " ('BAV', -20),\n",
        " ('LBF', -20),\n",
        " ('IFN', -20),\n",
        " ('YCU', -20),\n",
        " ('RXS', -30),\n",
        " ('CGD', -30),\n",
        " ('XNN', -40),\n",
        " ('LAU', -40),\n",
        " ('KUU', -40),\n",
        " ('RMQ', -50),\n",
        " ('UPG', -50),\n",
        " ('MUA', -60),\n",
        " ('OBO', -60),\n",
        " ('MOZ', -80),\n",
        " ('SDJ', -80),\n",
        " ('MYJ', -80),\n",
        " ('XWG', -90),\n",
        " ('CXR', -120),\n",
        " ('FLW', -190),\n",
        " ('MZV', -350),\n",
        " ('AYQ', -1290)]"
       ]
      }
     ],
     "prompt_number": 27
    },
    {
     "cell_type": "heading",
     "level": 4,
     "metadata": {},
     "source": [
      "Solution"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "for i in sorted_arrs[:10]:\n",
      "    print \"%s: %d\" %(i[0], i[1])"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "LHR: 81439\n",
        "LAX: 64230\n",
        "LAS: 63190\n",
        "MCO: 62290\n",
        "JFK: 60060\n",
        "CDG: 58080\n",
        "SFO: 53710\n",
        "MIA: 53020\n",
        "BKK: 52660\n",
        "DXB: 52230\n"
       ]
      }
     ],
     "prompt_number": 28
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "We can repeat to see the last elements, we observe also negative values"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "sorted_arrs[-5:]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 29,
       "text": [
        "[('XWG', -90), ('CXR', -120), ('FLW', -190), ('MZV', -350), ('AYQ', -1290)]"
       ]
      }
     ],
     "prompt_number": 29
    },
    {
     "cell_type": "heading",
     "level": 3,
     "metadata": {},
     "source": [
      "Conclusions"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "We can see that the values match with the solution with pandas\n",
      "\n",
      "The solution with pure python is longer and slower than with pandas, although it consumes less memory (with pandas we could work with other techniques to handle memory usage)"
     ]
    },
    {
     "cell_type": "heading",
     "level": 4,
     "metadata": {},
     "source": [
      "Top 10 Arrival airports"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "|    | code | Arrivals 2013 | Airport Name                         |\n",
      "|----|------|---------------|--------------------------------------|\n",
      "| 1  | LHR  | 81439         | London Heathrow Airport              |\n",
      "| 2  | LAX  | 64230         | Los Angeles International Airport    |\n",
      "| 3  | LAS  | 63190         | Mc Carran International Airport      |\n",
      "| 4  | MCO  | 62290         | Orlando International Airport        |\n",
      "| 5  | JFK  | 60060         | John F Kennedy International Airport |\n",
      "| 6  | CDG  | 58080         | Paris - Charles-de-Gaulle            |\n",
      "| 7  | SFO  | 53710         | San Francisco International Airport  |\n",
      "| 8  | MIA  | 53020         | Miami International Airport          |\n",
      "| 9  | BKK  | 52660         | Suvarnabhumi                         |\n",
      "| 10 | DXB  | 52230         | Dubai International Airport          |"
     ]
    }
   ],
   "metadata": {}
  }
 ]
}