Flight.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "import pandas as pd\n",
    "import mplleaflet as ml\n",
    "import requests\n",
    "import fiona\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Flying from Miami to DC, we decided to play with the in flight wifi.\n",
    "\n",
    "American Airlines gives you the following json interface, we are going to try to put it on a map."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "At first we had trouble getting connected, the solution was to manually insert the DNS entry 172.19.134.2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{\n",
      "    \"Response\": {\n",
      "        \"flightInfo\": {\n",
      "            \"HSpeed\": 256.557,\n",
      "            \"VSpeed\": -0.77216,\n",
      "            \"abpVersion\": \"4.0.4\",\n",
      "            \"acpuVersion\": \"6.4.0\",\n",
      "            \"airlineCode\": \"AAL\",\n",
      "            \"airlineCodeIata\": \"AA\",\n",
      "            \"airlineName\": \"American Airlines\",\n",
      "            \"altitude\": 9443.618,\n",
      "            \"departureAirportCode\": \"KMIA\",\n",
      "            \"departureAirportCodeIata\": \"MIA\",\n",
      "            \"destination\": \"DCA\",\n",
      "            \"destinationAirportCode\": \"KDCA\",\n",
      "            \"destinationAirportCodeIata\": \"DCA\",\n",
      "            \"expectedArrival\": \"2016-06-06T13:28:00Z\",\n",
      "            \"flightNumberAlpha\": \"AAL\",\n",
      "            \"flightNumberInfo\": \"AAL1359\",\n",
      "            \"flightNumberNumeric\": 1359,\n",
      "            \"latitude\": 33.314,\n",
      "            \"localTime\": \"2016-06-06T12:18:03.336Z0:0\",\n",
      "            \"longitude\": -79.9612,\n",
      "            \"origin\": \"MIA\",\n",
      "            \"tailNumber\": \"N905AN\",\n",
      "            \"utcTime\": \"2016-06-06T12:18:03.336Z\",\n",
      "            \"videoService\": false\n",
      "        },\n",
      "        \"gogoFacts\": \"The Wright brothers\\\\' first flight (120 feet) could have taken place within the economy section of a Boeing 747-400.\",\n",
      "        \"serviceInfo\": {\n",
      "            \"quality\": \"Good\",\n",
      "            \"remaining\": 26460,\n",
      "            \"service\": \"Active\"\n",
      "        },\n",
      "        \"status\": 200\n",
      "    }\n",
      "}\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current\n",
      "                                 Dload  Upload   Total   Spent    Left  Speed\n",
      "\r",
      "  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0\r",
      "  0     0    0     0    0     0      0      0 --:--:--  0:00:01 --:--:--     0\r",
      "100   868  100   868    0     0    536      0  0:00:01  0:00:01 --:--:--   536\r",
      "100   868  100   868    0     0    536      0  0:00:01  0:00:01 --:--:--   536\n"
     ]
    }
   ],
   "source": [
    "%%bash\n",
    "curl http://airborne.gogoinflight.com/abp/ws/absServices/statusTray | python -m json.tool"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "url = 'http://airborne.gogoinflight.com/abp/ws/absServices/statusTray'\n",
    "r = requests.get(url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{u'Response': {u'flightInfo': {u'HSpeed': 256.557,\n",
       "   u'VSpeed': -0.77216,\n",
       "   u'abpVersion': u'4.0.4',\n",
       "   u'acpuVersion': u'6.4.0',\n",
       "   u'airlineCode': u'AAL',\n",
       "   u'airlineCodeIata': u'AA',\n",
       "   u'airlineName': u'American Airlines',\n",
       "   u'altitude': 9443.618,\n",
       "   u'departureAirportCode': u'KMIA',\n",
       "   u'departureAirportCodeIata': u'MIA',\n",
       "   u'destination': u'DCA',\n",
       "   u'destinationAirportCode': u'KDCA',\n",
       "   u'destinationAirportCodeIata': u'DCA',\n",
       "   u'expectedArrival': u'2016-06-06T13:28:00Z',\n",
       "   u'flightNumberAlpha': u'AAL',\n",
       "   u'flightNumberInfo': u'AAL1359',\n",
       "   u'flightNumberNumeric': 1359,\n",
       "   u'latitude': 33.314,\n",
       "   u'localTime': u'2016-06-06T12:18:03.336Z0:0',\n",
       "   u'longitude': -79.9612,\n",
       "   u'origin': u'MIA',\n",
       "   u'tailNumber': u'N905AN',\n",
       "   u'utcTime': u'2016-06-06T12:18:03.336Z',\n",
       "   u'videoService': False},\n",
       "  u'gogoFacts': u'In 1973, AA became the first major airline to employ a female pilot when Bonnie Tiburzi was hired to fly Boeing 727s.',\n",
       "  u'serviceInfo': {u'quality': u'Good',\n",
       "   u'remaining': 26460,\n",
       "   u'service': u'Active'},\n",
       "  u'status': 200}}"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Response</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>flightInfo</th>\n",
       "      <td>{u'origin': u'MIA', u'abpVersion': u'4.0.4', u...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>gogoFacts</th>\n",
       "      <td>In 1973, AA became the first major airline to ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>serviceInfo</th>\n",
       "      <td>{u'quality': u'Good', u'remaining': 26460, u's...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>status</th>\n",
       "      <td>200</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                      Response\n",
       "flightInfo   {u'origin': u'MIA', u'abpVersion': u'4.0.4', u...\n",
       "gogoFacts    In 1973, AA became the first major airline to ...\n",
       "serviceInfo  {u'quality': u'Good', u'remaining': 26460, u's...\n",
       "status                                                     200"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_json(r.text)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "info = pd.io.json.json_normalize(df['Response']['flightInfo'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>HSpeed</th>\n",
       "      <th>VSpeed</th>\n",
       "      <th>abpVersion</th>\n",
       "      <th>acpuVersion</th>\n",
       "      <th>airlineCode</th>\n",
       "      <th>airlineCodeIata</th>\n",
       "      <th>airlineName</th>\n",
       "      <th>altitude</th>\n",
       "      <th>departureAirportCode</th>\n",
       "      <th>departureAirportCodeIata</th>\n",
       "      <th>...</th>\n",
       "      <th>flightNumberAlpha</th>\n",
       "      <th>flightNumberInfo</th>\n",
       "      <th>flightNumberNumeric</th>\n",
       "      <th>latitude</th>\n",
       "      <th>localTime</th>\n",
       "      <th>longitude</th>\n",
       "      <th>origin</th>\n",
       "      <th>tailNumber</th>\n",
       "      <th>utcTime</th>\n",
       "      <th>videoService</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>256.557</td>\n",
       "      <td>-0.77216</td>\n",
       "      <td>4.0.4</td>\n",
       "      <td>6.4.0</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AA</td>\n",
       "      <td>American Airlines</td>\n",
       "      <td>9443.618</td>\n",
       "      <td>KMIA</td>\n",
       "      <td>MIA</td>\n",
       "      <td>...</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AAL1359</td>\n",
       "      <td>1359</td>\n",
       "      <td>33.314</td>\n",
       "      <td>2016-06-06T12:18:03.336Z0:0</td>\n",
       "      <td>-79.9612</td>\n",
       "      <td>MIA</td>\n",
       "      <td>N905AN</td>\n",
       "      <td>2016-06-06T12:18:03.336Z</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    HSpeed   VSpeed abpVersion acpuVersion airlineCode airlineCodeIata  \\\n",
       "0  256.557 -0.77216      4.0.4       6.4.0         AAL              AA   \n",
       "\n",
       "         airlineName  altitude departureAirportCode departureAirportCodeIata  \\\n",
       "0  American Airlines  9443.618                 KMIA                      MIA   \n",
       "\n",
       "       ...      flightNumberAlpha flightNumberInfo flightNumberNumeric  \\\n",
       "0      ...                    AAL          AAL1359                1359   \n",
       "\n",
       "  latitude                    localTime longitude  origin  tailNumber  \\\n",
       "0   33.314  2016-06-06T12:18:03.336Z0:0  -79.9612     MIA      N905AN   \n",
       "\n",
       "                    utcTime  videoService  \n",
       "0  2016-06-06T12:18:03.336Z         False  \n",
       "\n",
       "[1 rows x 24 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "info"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Let's make a funcion that takes in this data frame and appends the current data\n",
    "def flight(data=None, url='http://airborne.gogoinflight.com/abp/ws/absServices/statusTray'):\n",
    "    '''Returns a modified dataframe object'''\n",
    "    r = requests.get(url)\n",
    "    \n",
    "    new_data = pd.read_json(r.text)\n",
    "\n",
    "    info = pd.io.json.json_normalize(new_data['Response']['flightInfo'])\n",
    "        \n",
    "    if data is None:\n",
    "        data = info\n",
    "    else:\n",
    "        data = pd.concat([data, info])\n",
    "        \n",
    "    data.set_index('utcTime')\n",
    "\n",
    "    return data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df = flight()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>HSpeed</th>\n",
       "      <th>VSpeed</th>\n",
       "      <th>abpVersion</th>\n",
       "      <th>acpuVersion</th>\n",
       "      <th>airlineCode</th>\n",
       "      <th>airlineCodeIata</th>\n",
       "      <th>airlineName</th>\n",
       "      <th>altitude</th>\n",
       "      <th>departureAirportCode</th>\n",
       "      <th>departureAirportCodeIata</th>\n",
       "      <th>...</th>\n",
       "      <th>flightNumberAlpha</th>\n",
       "      <th>flightNumberInfo</th>\n",
       "      <th>flightNumberNumeric</th>\n",
       "      <th>latitude</th>\n",
       "      <th>localTime</th>\n",
       "      <th>longitude</th>\n",
       "      <th>origin</th>\n",
       "      <th>tailNumber</th>\n",
       "      <th>utcTime</th>\n",
       "      <th>videoService</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>256.557</td>\n",
       "      <td>-0.77216</td>\n",
       "      <td>4.0.4</td>\n",
       "      <td>6.4.0</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AA</td>\n",
       "      <td>American Airlines</td>\n",
       "      <td>9443.618</td>\n",
       "      <td>KMIA</td>\n",
       "      <td>MIA</td>\n",
       "      <td>...</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AAL1359</td>\n",
       "      <td>1359</td>\n",
       "      <td>33.314</td>\n",
       "      <td>2016-06-06T12:18:03.336Z0:0</td>\n",
       "      <td>-79.9612</td>\n",
       "      <td>MIA</td>\n",
       "      <td>N905AN</td>\n",
       "      <td>2016-06-06T12:18:03.336Z</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    HSpeed   VSpeed abpVersion acpuVersion airlineCode airlineCodeIata  \\\n",
       "0  256.557 -0.77216      4.0.4       6.4.0         AAL              AA   \n",
       "\n",
       "         airlineName  altitude departureAirportCode departureAirportCodeIata  \\\n",
       "0  American Airlines  9443.618                 KMIA                      MIA   \n",
       "\n",
       "       ...      flightNumberAlpha flightNumberInfo flightNumberNumeric  \\\n",
       "0      ...                    AAL          AAL1359                1359   \n",
       "\n",
       "  latitude                    localTime longitude  origin  tailNumber  \\\n",
       "0   33.314  2016-06-06T12:18:03.336Z0:0  -79.9612     MIA      N905AN   \n",
       "\n",
       "                    utcTime  videoService  \n",
       "0  2016-06-06T12:18:03.336Z         False  \n",
       "\n",
       "[1 rows x 24 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df = flight(data=df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>HSpeed</th>\n",
       "      <th>VSpeed</th>\n",
       "      <th>abpVersion</th>\n",
       "      <th>acpuVersion</th>\n",
       "      <th>airlineCode</th>\n",
       "      <th>airlineCodeIata</th>\n",
       "      <th>airlineName</th>\n",
       "      <th>altitude</th>\n",
       "      <th>departureAirportCode</th>\n",
       "      <th>departureAirportCodeIata</th>\n",
       "      <th>...</th>\n",
       "      <th>flightNumberAlpha</th>\n",
       "      <th>flightNumberInfo</th>\n",
       "      <th>flightNumberNumeric</th>\n",
       "      <th>latitude</th>\n",
       "      <th>localTime</th>\n",
       "      <th>longitude</th>\n",
       "      <th>origin</th>\n",
       "      <th>tailNumber</th>\n",
       "      <th>utcTime</th>\n",
       "      <th>videoService</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>256.557</td>\n",
       "      <td>-0.77216</td>\n",
       "      <td>4.0.4</td>\n",
       "      <td>6.4.0</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AA</td>\n",
       "      <td>American Airlines</td>\n",
       "      <td>9443.618</td>\n",
       "      <td>KMIA</td>\n",
       "      <td>MIA</td>\n",
       "      <td>...</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AAL1359</td>\n",
       "      <td>1359</td>\n",
       "      <td>33.314</td>\n",
       "      <td>2016-06-06T12:18:03.336Z0:0</td>\n",
       "      <td>-79.9612</td>\n",
       "      <td>MIA</td>\n",
       "      <td>N905AN</td>\n",
       "      <td>2016-06-06T12:18:03.336Z</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>256.557</td>\n",
       "      <td>-0.77216</td>\n",
       "      <td>4.0.4</td>\n",
       "      <td>6.4.0</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AA</td>\n",
       "      <td>American Airlines</td>\n",
       "      <td>9443.618</td>\n",
       "      <td>KMIA</td>\n",
       "      <td>MIA</td>\n",
       "      <td>...</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AAL1359</td>\n",
       "      <td>1359</td>\n",
       "      <td>33.314</td>\n",
       "      <td>2016-06-06T12:18:03.336Z0:0</td>\n",
       "      <td>-79.9612</td>\n",
       "      <td>MIA</td>\n",
       "      <td>N905AN</td>\n",
       "      <td>2016-06-06T12:18:03.336Z</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    HSpeed   VSpeed abpVersion acpuVersion airlineCode airlineCodeIata  \\\n",
       "0  256.557 -0.77216      4.0.4       6.4.0         AAL              AA   \n",
       "0  256.557 -0.77216      4.0.4       6.4.0         AAL              AA   \n",
       "\n",
       "         airlineName  altitude departureAirportCode departureAirportCodeIata  \\\n",
       "0  American Airlines  9443.618                 KMIA                      MIA   \n",
       "0  American Airlines  9443.618                 KMIA                      MIA   \n",
       "\n",
       "       ...      flightNumberAlpha flightNumberInfo flightNumberNumeric  \\\n",
       "0      ...                    AAL          AAL1359                1359   \n",
       "0      ...                    AAL          AAL1359                1359   \n",
       "\n",
       "  latitude                    localTime longitude  origin  tailNumber  \\\n",
       "0   33.314  2016-06-06T12:18:03.336Z0:0  -79.9612     MIA      N905AN   \n",
       "0   33.314  2016-06-06T12:18:03.336Z0:0  -79.9612     MIA      N905AN   \n",
       "\n",
       "                    utcTime  videoService  \n",
       "0  2016-06-06T12:18:03.336Z         False  \n",
       "0  2016-06-06T12:18:03.336Z         False  \n",
       "\n",
       "[2 rows x 24 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>HSpeed</th>\n",
       "      <th>VSpeed</th>\n",
       "      <th>abpVersion</th>\n",
       "      <th>acpuVersion</th>\n",
       "      <th>airlineCode</th>\n",
       "      <th>airlineCodeIata</th>\n",
       "      <th>airlineName</th>\n",
       "      <th>altitude</th>\n",
       "      <th>departureAirportCode</th>\n",
       "      <th>departureAirportCodeIata</th>\n",
       "      <th>...</th>\n",
       "      <th>expectedArrival</th>\n",
       "      <th>flightNumberAlpha</th>\n",
       "      <th>flightNumberInfo</th>\n",
       "      <th>flightNumberNumeric</th>\n",
       "      <th>latitude</th>\n",
       "      <th>localTime</th>\n",
       "      <th>longitude</th>\n",
       "      <th>origin</th>\n",
       "      <th>tailNumber</th>\n",
       "      <th>videoService</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>utcTime</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2016-06-06T12:18:03.336Z</th>\n",
       "      <td>256.557</td>\n",
       "      <td>-0.77216</td>\n",
       "      <td>4.0.4</td>\n",
       "      <td>6.4.0</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AA</td>\n",
       "      <td>American Airlines</td>\n",
       "      <td>9443.618</td>\n",
       "      <td>KMIA</td>\n",
       "      <td>MIA</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-06-06T13:28:00Z</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AAL1359</td>\n",
       "      <td>1359</td>\n",
       "      <td>33.314</td>\n",
       "      <td>2016-06-06T12:18:03.336Z0:0</td>\n",
       "      <td>-79.9612</td>\n",
       "      <td>MIA</td>\n",
       "      <td>N905AN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-06-06T12:18:03.336Z</th>\n",
       "      <td>256.557</td>\n",
       "      <td>-0.77216</td>\n",
       "      <td>4.0.4</td>\n",
       "      <td>6.4.0</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AA</td>\n",
       "      <td>American Airlines</td>\n",
       "      <td>9443.618</td>\n",
       "      <td>KMIA</td>\n",
       "      <td>MIA</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-06-06T13:28:00Z</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AAL1359</td>\n",
       "      <td>1359</td>\n",
       "      <td>33.314</td>\n",
       "      <td>2016-06-06T12:18:03.336Z0:0</td>\n",
       "      <td>-79.9612</td>\n",
       "      <td>MIA</td>\n",
       "      <td>N905AN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                           HSpeed   VSpeed abpVersion acpuVersion airlineCode  \\\n",
       "utcTime                                                                         \n",
       "2016-06-06T12:18:03.336Z  256.557 -0.77216      4.0.4       6.4.0         AAL   \n",
       "2016-06-06T12:18:03.336Z  256.557 -0.77216      4.0.4       6.4.0         AAL   \n",
       "\n",
       "                         airlineCodeIata        airlineName  altitude  \\\n",
       "utcTime                                                                 \n",
       "2016-06-06T12:18:03.336Z              AA  American Airlines  9443.618   \n",
       "2016-06-06T12:18:03.336Z              AA  American Airlines  9443.618   \n",
       "\n",
       "                         departureAirportCode departureAirportCodeIata  \\\n",
       "utcTime                                                                  \n",
       "2016-06-06T12:18:03.336Z                 KMIA                      MIA   \n",
       "2016-06-06T12:18:03.336Z                 KMIA                      MIA   \n",
       "\n",
       "                              ...            expectedArrival  \\\n",
       "utcTime                       ...                              \n",
       "2016-06-06T12:18:03.336Z      ...       2016-06-06T13:28:00Z   \n",
       "2016-06-06T12:18:03.336Z      ...       2016-06-06T13:28:00Z   \n",
       "\n",
       "                         flightNumberAlpha flightNumberInfo  \\\n",
       "utcTime                                                       \n",
       "2016-06-06T12:18:03.336Z               AAL          AAL1359   \n",
       "2016-06-06T12:18:03.336Z               AAL          AAL1359   \n",
       "\n",
       "                         flightNumberNumeric latitude  \\\n",
       "utcTime                                                 \n",
       "2016-06-06T12:18:03.336Z                1359   33.314   \n",
       "2016-06-06T12:18:03.336Z                1359   33.314   \n",
       "\n",
       "                                            localTime  longitude  origin  \\\n",
       "utcTime                                                                    \n",
       "2016-06-06T12:18:03.336Z  2016-06-06T12:18:03.336Z0:0   -79.9612     MIA   \n",
       "2016-06-06T12:18:03.336Z  2016-06-06T12:18:03.336Z0:0   -79.9612     MIA   \n",
       "\n",
       "                         tailNumber  videoService  \n",
       "utcTime                                            \n",
       "2016-06-06T12:18:03.336Z     N905AN         False  \n",
       "2016-06-06T12:18:03.336Z     N905AN         False  \n",
       "\n",
       "[2 rows x 23 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.set_index('utcTime')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAEACAYAAABI5zaHAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAADB5JREFUeJzt3F+IXNUdwPHvNBsFoamVhTwkkUAM/ikoKsZYEa9E6OpD\nAxYaom2xCs1LbF9KY3xo5sWWvBSRgIY0Sp/Mg/oQS0iw1cESTDSgMalJyG4byB8Rta1IEZol04dz\nkxknu7l3Zu7eTX77/cDC3L0nN8dD+O7dc2cESZIkSZIkSZIkSZIkSZKk0F4CPgUOXWLM88Bx4CBw\nex2TkiQN5z5SsKeL+8PArvz13cC+OiYlSRreUqaP+4vAmq7jo8DCmZ6QJGl636rgGouAk13Hp4DF\nFVxXkjSgKuIO0Og5bld0XUnSAEYquMZpYEnX8eL8e9+wbNmy9sTERAV/nSTNKRPADf3+oSru3HcC\nP8tfrwT+Q3p3zTdMTEzQbrf9arfZtGnTrM/hcvlyLVwL1+LSX8CyQcJc5s79FeB+YJS0t74JmJ+f\n20p6p8zDwDjwX+Dng0xEklSdMnFfW2LM+mEnIkmqTlUPVNWHLMtmewqXDdeiw7XocC2G1/sul5nU\nzvePJEklNRoNGKDV3rlLUkDGXZICMu6SFJBxl6SAjLskBWTcJSkg4y5JARl3SQrIuEtSQMZdkgIy\n7pIUkHGXpICMuyQFZNwlKSDjLkkBGXdJCsi4S1JAxl2SAjLukhSQcZekgIy7JAVk3CUpIOMuSQEZ\nd0kKyLhLUkDGXZICMu6SFJBxl6SAjLskBWTcJSkg4y5JARl3SQrIuEtSQMZdkgIqE/cx4ChwHNgw\nxflRYDfwIXAYeLyqyUmSBtMoOD8POAY8CJwG3gfWAke6xjSBq4GNpNAfAxYCkz3Xarfb7eFnLElz\nSKPRgOJWX6Tozn0FMA6cAM4CO4DVPWM+ARbkrxcAX3Bx2CVJNRopOL8IONl1fAq4u2fMNuAt4Azw\nbeDHlc1OkjSQoriX2Ud5hrTfngHLgDeB24Cvegc2m80Lr7MsI8uycrOUpDmi1WrRarWGvk7RPs5K\n0p76WH68ETgHbO4aswt4FtibH/+V9OD1QM+13HOXpD7N1J77AWA5sBS4ClgD7OwZc5T0wBXSg9Qb\ngX/0OxFJUnWKtmUmgfXAHtI7Z7aT3imzLj+/Ffgd8DJwkPTD4jfAv2ZispKkcvq+1R+C2zKS1KeZ\n2paRJF2BjLskBWTcJSkg4y5JARl3SQrIuEtSQMZdkgIy7pIUkHGXpICMuyQFZNwlKSDjLkkBGXdJ\nCsi4S1JAxl2SAjLukhSQcZekgIy7JAVk3CUpIOMuSQEZd0kKyLhLUkDGXZICMu6SFJBxl6SAjLsk\nBWTcJSkg4y5JARl3SQrIuEtSQMZdkgIy7pIUkHGXpICMuyQFZNwlKaAycR8DjgLHgQ3TjMmAD4DD\nQKuKiUmSBtcoOD8POAY8CJwG3gfWAke6xlwL7AV+AJwCRoHPp7hWu91uDztfSZpTGo0GFLf6IkV3\n7iuAceAEcBbYAazuGfMo8Bop7DB12CVJNSqK+yLgZNfxqfx73ZYD1wFvAweAn1Y2O0nSQEYKzpfZ\nR5kP3AGsAq4B3gX2kfboJUmzoCjup4ElXcdL6Gy/nHeStBXzdf71DnAbU8S92WxeeJ1lGVmW9Ttf\nSQqt1WrRarWGvk7RJv0I6YHqKuAM8B4XP1C9CdhCeqB6NbAfWAN83HMtH6hKUp8GfaBadOc+CawH\n9pDeObOdFPZ1+fmtpLdJ7gY+As4B27g47JKkGvX902AI3rlLUp9m6q2QkqQrkHGXpICMuyQFZNwl\nKSDjLkkBGXdJCsi4S1JAxl2SAjLukhSQcZekgIy7JAVk3CUpIOMuSQEZd0kKyLhLUkDGXZICMu6S\nFJBxl6SAjLskBWTcJSkg4y5JARl3SQrIuEtSQMZdkgIy7pIUkHGXpICMuyQFZNwlKSDjLkkBGXdJ\nCsi4S1JAxl2SAjLukhSQcZekgIy7JAVk3CUpoDJxHwOOAseBDZcYdxcwCTxSwbwkSUMoivs8YAsp\n8LcAa4Gbpxm3GdgNNKqcoCSpf0VxXwGMAyeAs8AOYPUU454CXgU+q3JykqTBFMV9EXCy6/hU/r3e\nMauBF/LjdjVTkyQNqijuZUL9HPB0PraB2zKSNOtGCs6fBpZ0HS8h3b13u5O0XQMwCjxE2sLZ2Xux\nZrN54XWWZWRZ1tdkJSm6VqtFq9Ua+jpFd9kjwDFgFXAGeI/0UPXINONfBt4AXp/iXLvddsdGkvrR\naDRggB2Rojv3SWA9sIf0jpjtpLCvy89v7fcvlCTNvDr3x71zl6Q+DXrn7idUJSkg4y5JARl3SQrI\nuEtSQMZdkgIy7pIUkHGXpICMuyQFZNwlKSDjLkkBGXdJCsi4S1JAxl2SAjLukhSQcZekgIy7JAVk\n3CUpIOMuSQEZd0kKyLhLUkDGXZICMu6SFJBxl6SAjLskBWTcJSkg4y5JARl3SQrIuEtSQMZdkgIy\n7pIUkHGXpICMuyQFZNwlKSDjLkkBGXdJCsi4S1JAZeM+BhwFjgMbpjj/GHAQ+AjYC9xayewkSQNp\nlBgzDzgGPAicBt4H1gJHusbcA3wMfEn6QdAEVvZcp91ut4ecriTNLY1GA8q1+hvK3LmvAMaBE8BZ\nYAewumfMu6SwA+wHFvc7EUlSdcrEfRFwsuv4VP696TwJ7BpmUpKk4YyUGNPPXsoDwBPAvVOdbDab\nF15nWUaWZX1cWpLia7VatFqtoa9TZh9nJWkPfSw/3gicAzb3jLsVeD0fNz7Fddxzl6Q+zeSe+wFg\nObAUuApYA+zsGXM9Kew/YeqwS5JqVGZbZhJYD+whvXNmO+mdMuvy81uB3wLfBV7Iv3eW9CBWkjQL\n+r7VH4LbMpLUp5nclpEkXWGMuyQFZNwlKSDjLkkBGXdJCsi4S1JAxl2SAjLukhSQcZekgIy7JAVk\n3CUpIOMuSQEZd0kKyLhLUkDGXZICMu6SFJBxl6SAjLskBWTcJSkg4y5JARl3SQrIuEtSQMZdkgIy\n7pIUkHGXpICMuyQFZNwlKSDjLkkBGXdJCsi4S1JAxl2SAjLukhSQcZekgIy7JAVk3CUpoDJxHwOO\nAseBDdOMeT4/fxC4vZqpSZIGVRT3ecAWUuBvAdYCN/eMeRi4AVgO/AJ4oeI5htNqtWZ7CpcN16LD\ntehwLYZXFPcVwDhwAjgL7ABW94z5IfCn/PV+4FpgYXVTjMd/uB2uRYdr0eFaDK8o7ouAk13Hp/Lv\nFY1ZPPzUJEmDKop7u+R1GgP+OUnSDOiNcq+VQJO05w6wETgHbO4a8yLQIm3ZQHr4ej/wac+1xoFl\ng09VkuakCdJzzUqN5BdeClwFfMjUD1R35a9XAvuqnoQkqXoPAcdId94b8++ty7/O25KfPwjcUevs\nJEmSJA3GDz11FK3FY6Q1+AjYC9xa39RqV+bfBcBdwCTwSB2TmgVl1iEDPgAOk55nRVW0FqPAbtJ2\n8GHg8dpmVr+XSM8pD11izKx2cx5pe2YpMJ/iPfq7ibtHX2Yt7gG+k78eY26vxflxbwF/Bn5U1+Rq\nVGYdrgX+TuftxKN1Ta5mZdaiCfw+fz0KfEF6DhjRfaRgTxf3vrtZ9f9bxg89dZRZi3eBL/PX+4n7\n+YAyawHwFPAq8FltM6tXmXV4FHiN9HkRgM/rmlzNyqzFJ8CC/PUCUtwna5pf3f4G/PsS5/vuZtVx\n90NPHWXWotuTdH4yR1P238VqOv/7ioiflSizDsuB64C3gQPAT+uZWu3KrMU24HvAGdJWxK/qmdpl\nqe9uVv0rjh966ujnv+kB4Ang3hmay2wrsxbPAU/nYxsUfwbjSlRmHeaT3nG2CriG9NvdPtJeayRl\n1uIZ0nZNRvqMzJvAbcBXMzety1pf3aw67qeBJV3HS+j8ejndmMX596IpsxaQHqJuI+25X+rXsitZ\nmbW4k84H4UZJb8E9C+yc8dnVp8w6nCRtxXydf71DClq0uJdZi+8Dz+avJ4B/AjeSfqOZa2a9m37o\nqaPMWlxP2ndcWevM6ldmLbq9TMx3y5RZh5uAv5AeOF5DesB2S31TrE2ZtfgDsCl/vZAU/+tqmt9s\nWEq5B6qz1k0/9NRRtBZ/JD0k+iD/eq/uCdaozL+L86LGHcqtw69J75g5BPyy1tnVq2gtRoE3SJ04\nRHrYHNUrpGcL/yP99vYEc7ebkiRJkiRJkiRJkiRJkiRJkiRJkq4E/we+jwyIuTI3ZAAAAABJRU5E\nrkJggg==\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x1141a4e50>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.hold(True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes.AxesSubplot at 0x11434f350>"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZIAAAEPCAYAAABoekJnAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAF+9JREFUeJzt3X+8VHWdx/HXACFIIpIKmD9Q1PxJgZploSNpq9b6o1XA\nrFjXXM0e1sN1H0macVfL9bePtk1T/LGWiZauPvTx2BAEJ01LFBFwlZQrZAhibZKa+QOc/eP7He8w\nnrl35p6Ze5jh9Xw85jHfc86cmc/xyn3f7/d7zhmQJEmSJEmSJEmSJEmSJEmSpG7dBiyMj+XxGeCk\nsvULgfXA2IT9hwNzgGeB2cCwJtcrSdqIXQ58J2H9PsBzVfa5FPhWbJ8DXNyEuiRJLSAHvACMSdh2\nEXBhlf2WAiNie2RcliRtgg4GHquybRmwV5Vtr5S1cxXLkqQ+NKCJ7z2H0FuodC5wb2yfCNya8JoD\ngTeAp2v4nGJ8SJIy0MwgObyGzz4OGJ+wbQrJAVOyhhBSLwGjgJeTXjRmzJhiZ2dnz5VKksp1ArvW\n+uJ+TSykJ4cBzwCrKtb3A04gnNlVzT3A1NieCtyd9KLOzk6KxWLbPqZPn555DR6fx+bxtd+D5Hnr\nqrIMksnAzIT1BxMm4FdUrJ8B7BfbFxN6PM8CE/GsLUnKTDOHtnpycpX1BeCghPWnlrX/TOjRSJIy\nlmWPRCnl8/msS2iqdj6+dj428Pg2NbmsC2iyYhzvkyTVKJfLQR35YI9EkpSKQSJJSsUgkSSlYpBI\nklIxSCRJqRgkkqRUDBJJUioGiSQpFYNEkpRKlvfakqSWVywWmTdvHitWrGD8+PGMGzcu65L6nLdI\nkaReKhaLnHzyGdxxRwH4OMXiHK644t84/fRTe9p1o1bvLVIMEknqpfnz5zNx4hT++tclwBCgk4ED\nP8batS8zePDgrMvrNe+1JUl9ZPXq1fTvvxchRADG0L//5rzyyitZltXnDBJJ6qXx48ezbt2jwENA\nkVzuWrbaaigjRozIurQ+ZZBIUi/tsMMO3HnnTxk69Hj69RvI6NH/ydy599K/f/+sS+tTzpFIUkrF\nYpG33nqLQYMGZV1KQzjZviGDRJLq5GS7JKlPGSSS2ta6detwVKL5DBJJbWft2rV85jNHM2jQ5my+\n+TB++MOrsy6prRkkktrO1Kln8Otfb8v69a/x5puPM23apdx///1Zl9W2sgqS24CF8bE8PgOcVLZ+\nIbAeGJuwfwewsux1RzS3XEmt5MEHf8Xbb38X2AzYjTfe+EcKhQezLqttZXXTxill7cuBtbH9s/gA\n2Ae4C1icsH8RuDI+JGkDW289grVrFwI7AkUGD17IyJGHZ11W28r67r85YBJwaMK2LxJ6Lt3tK0nv\nc/31V/G5zx1PsXgX/fr9np13fpNTTjkl67LaVta/jA8GrgAOSNi2DDgaeDph23TgZOAvwOPA2XT1\nasp5HYm0iers7GTevHkMHTqUY489ls022yzrklpGvdeRNLNHMgcYmbD+XODe2D4RuDXhNQcCb5Ac\nIgDXABfE9oWEMEr8c6Ojo+O9dj6fJ5/Pd1+1pLYwZswYxowZk3UZLaFQKFAoFHq9f5Y9kgGECfPx\nwKqKbVcBa4CLa3if0YRg2jdhmz0SSarTxtQj6clhwDO8P0T6AScAn+5m31HA6tg+DljS8OokSTXJ\n8jqSycDMhPUHAy8AKyrWzyD0XgAuIZzNtQg4BDirOSVKknqS9WR7szm0JbWIF198kZNOOo1Fixay\n0067cMst17DPPvtkXdYmybv/bsggkVrA+vXr2XPP/Xn++c+zfv2p5HL3MWxYB52dT7HVVltlXd4m\nx7v/Smo5K1eu5MUXX2b9+guAHSkWT+Xdd3djwYIFWZemGhgkkjK3xRZbsG7da0Dpu87fZt26VWyx\nxRZZlqUaGSSSMjd8+HBOP/10hgzJAxew+eaf5VOf2ocDDki6VlkbG+dIJG0UisUid955JwsWLGTX\nXXdh6tSpDBiQ9V2cNk1Otm/IIJGkOjnZLknqUwaJJCkVg0SSlIpBIklKxSCRJKVikEiSUjFIJEmp\nGCSSpFQMEklSKgaJJCkVg0SSlIpBIklKxSCRJKVikEiSUjFIJEmpGCSSpFQMEklSKlkFyW3AwvhY\nHp8BBgEzgcXA08C0KvsPB+YAzwKzgWHNLFaSVF1WQTIFGBcfd8ZHaT3AWGA/4DRgx4T9pxGCZHdg\nLtUDR5LUZFkPbeWASYReCMBqYAjQPz6/DbyasN/RwM2xfTNwbHPLlCRVk3WQTADWAJ1x+T5CcKwG\nVgCXAWsT9hsR9yM+j2hqlZKkqgY08b3nACMT1p8L3BvbJwK3lm37EjAYGEWYB3mIMHS1vJvPKcZH\noo6Ojvfa+XyefD7fY+GStCkpFAoUCoVe759rXCl1GwCsBMYDq+K6q4FHgFvi8g3ALOAXFfsuBfLA\nS4TQeQDYI+EzisVi1YyRJCXI5XJQRz5kObR1GPAMXSECISAmxvYQ4BPxNZXuAabG9lTg7ibVKEnq\nQZZBMpmuSfaSa4GBwBJgPnAj8FTcNoNwJhfAxcDhhNN/J8ZlSVIGshza6gsObUlSnVppaEuS1AYM\nEklSKgaJJCkVg0SSlIpBIklKxSCRJKVikEiSUjFIJEmpGCSSpFQMEklSKgaJJCkVg0SSlIpBIklK\nxSCRJKVikEiSUjFIJEmpGCSSpFQMEklSKgaJJCkVg0SSlIpBIklKxSCRJKVSS5AMAc4HZsTl3YDP\nN60iSVJLqSVIbgLeBg6Ky6uA76f83NuAhfGxPD4DDAJmAouBp4FpVfbvAFaWvccRKeuRJPXSgBpe\nMwaYBEyJy39twOdOKWtfDqytWD8WGEwIk1uBFyr2LwJXxockKUO1BMlbhF/qJWPiukbIEULq0Li8\nmjCU1j8+vw282s2+kqSM1TK01QHMArYn9A7mAec06PMnAGuAzrh8HyE4VgMrgMvo6q1UOhNYBNwA\nDGtQPZKkOtXSI5kNPAF8Ii5/A/hTDfvNAUYmrD8XuDe2TySEU8mXCL2fUcBw4CFgLmEepdw1wAWx\nfSFwBXBKUhEdHR3vtfP5PPl8vobSJWnTUSgUKBQKvd6/u+Gh/QhzEZWvL617otefGgwgTJiPJ0zg\nA1wNPALcEpdvIPSGftHN+4wmBNO+CduKxWLlIUiSupPL5aCO6YPueiRXEEJjMCFUFsf1Y4HHgU/2\nrsT3HAY8Q1eIACwFJhKCZAihF3RVwr6jCMNfAMcBS1LWIknqpe7mSPKESfBVhF7DfvExjg1/+ffW\nZMKpvuWuBQYSgmE+cCPwVNw2I9YBcAkh2BYBhwBnNaAeSVIv1NJ1eRrYq4Z1GyOHtiSpTo0c2ipZ\nDFxPGG7KAV8k9AQkSaopcQYDXyOcqgvwIOGsqTebVVQD2SORpDrV2yNp94v6DBJJqlMzhrYqr+GA\ncDbXLrV+iCSpfdUSJAeUtQcBxwMfak45kqRW09uhrSfoOhV3Y+bQliTVqRlDW+VXuPcD9ifcVFGS\npJqCpHSFO8A6ws0UJzWrIElSa6ml67IL8HzFup1JnoTf2Di0JUl1qndoq5bbyN9R4zpJ0iaou6Gt\nPQm3QRkGfIGuO/8OJZy9JUlSt0HyEeDvgS3jc8lrwKnNLEqS1DpqGQP7JPCbZhfSJM6RSFKdGnmL\nlHMIt2v/YcK2IuGbEjd2Bokk1amR15E8HZ8XJGzzt7MkCfCmjZKkCs24sv1eQg+k9KZF4C+Er9u9\nlta4nbwkqUlquY5kOfA6cB3h625fi8u7x2VJ0iaslq7L44T7ayWt+19g70YX1UAObUlSnZpxZfsQ\nYKey5Z3iOoC3a65MktSWapkjORt4iK77be0CnEEIk5ubVJckqUXU2nUZBOxBmGj/Ha0zwe7QliTV\nqVnf2X4Q4Y6/A+i6huQndVWWDYNEkurUjNN/byEMZz0JrC9bnyZIbiPcywvCTSHXAuOAgYRTivcD\n3gW+CfwqYf/hwO2E+ZoVhO9HWZuiHklSL9WSOM8Q7gLcrD/tLyeEwPeArxO+wvcUYBvgl4TvjK/8\n7EuBP8Xnc4CtgGkJ722PRJLq1Iyztp4CRvW2oB7kCL2JmXF5T+CB2P4jIWAqTz0GOJquif6bgWOb\nVJ8kqQe1DG1tQ7jv1nzgrbiuSPhlntYEYA3QGZcXxfedCexIGOLaHnisYr8RcT/i84gG1CJJ6oVa\ngqQjPpfGiHLUNsw1BxiZsP5cwm1XAE4Ebi3bdiOhV/I48HvgETacl0lS7K6ejo6O99r5fJ58Pt/D\n20nSpqVQKFAoFHq9f61jYCPpmquYD7zc60/sMgBYSZgTWVXlNQ8T5kuWVqxfCuSBlwjDbg8QTk+u\n5ByJJNWpGXMkk4BHgRNie35sp3UYYSK/PEQG03XV/OHAO7w/RADuAabG9lTg7gbUI0nqhVoSZzHh\nl36pF7INMBcYm/KzbyJ88+J1ZetGA7MIp/6uJPRG/hC3zQB+TPh+lOHAzwnzKCuofvqvPRJJqlMz\nLkhcQgiN0m/kfoRJ8X3rLS4DBokk1akZFyTOAu4jTIrngMmE6zskSaopcXLAF4BPE3olDwF3NbOo\nBrJHIkl1ata9tlqVQSJJdWrk0NbrVL8+owgMrb0sSVK7skciSdpAM64jkSSpKoNEkpSKQSJJSsUg\nkSSlYpBIklIxSCRJqRgkkqRUDBJJUioGiSQpFYNEkpSKQSJJSsUgkSSlYpBIklIxSCRJqRgkkqRU\nDBJJUioGiSQpFYNEkpRKVkFyG7AwPpbHZ4CBwE3AYuBJ4JAq+3cAK8ve44gm1ipJ6saAjD53Sln7\ncmBtbJ8KvAuMBbYBfgkcAFR+8XoRuDI+JEkZynpoKwdMAmbG5T2BB2L7j4SA2b+bfSVJGcs6SCYA\na4DOuLwIOBroD+wM7AdsX2XfM+PrbwCGNbdMSVI1zRzamgOMTFh/LnBvbJ8I3Fq27UZCr+Rx4PfA\nI8D6hPe4Brggti8ErgBOSSqio6PjvXY+nyefz9dYviRtGgqFAoVCodf7Zzk8NIAwYT4eWFXlNQ8T\nAmJpN+8zmhBM+yZsKxaLldMrkqTu5HI5qCMfshzaOgx4hg1DZDAwJLYPB94hOURGlbWPA5Y0o0BJ\nUs+yOmsLYDJdk+wlI4BZhDO3VgJfLts2gzCk9QRwCfAxwtlby4HTml2sJClZu5/55NCWJNWplYa2\nJEltwCCRJKVikEiSUjFIJEmpGCSSpFQMEklSKgaJJCkVg0SSlIpBIklKxSCRJKVikEiSUjFIJEmp\nGCSSpFQMEklSKgaJJCkVg0SSlIpBIklKxSCRJKVikEiSUjFIJEmpGCSSpFQGZF3AxuyJJ55g9uzZ\njB07lqOOOirrciRpo5TLuoAmKxaLxV7teN5553PRRVcCewO/Y8KEA3nwwdkNLU6SNka5XA7qyIes\nhrY+DswHFgKPAQeUbfs28BywFPhslf2HA3OAZ4HZwLBGFvf6669z0UWXAfNimc/x0EMLuP322xv5\nMZLUFrIKkkuB84FxwHfjMsBewOT4fARwNck1TiMEye7A3LjcMMuWLQMGAgfGNdsC41mwYEEjP0aS\n2kJWQbIa2DK2hwEvxvYxwEzgHWAFsIzQe6l0NHBzbN8MHNvI4vbYYw9yufXAPXHNs8CjHHrooY38\nGElqC1kFyTTgCuAF4DLCcBbAdsDKstetBD6csP8IYE1sr4nLDTNo0CCuu+4H5HInAiOBsXzlKydw\n5JFHNvJjJKktNPOsrTmE38KVzgO+ER93AScANwKHV3mfnmbLi929pqOj4712Pp8nn8/38HbBV7/6\nVY4//ngeffRR9t57b7bffvua9pOkVlMoFCgUCr3eP6uztl4FhpbVsJYw1FWa67g4Ps8CpgOPVuy/\nFMgDLwGjgAeAPRI+p9dnbUnSpqpVztpaBhwS2xMJkxAQJiWmEGa6dwZ2I5w2VekeYGpsTwXublql\nkqRuZdUj2R/4EbAZ8DfgDMKpwADnAv8ErAO+CdwX188AfgwsIJz++3NgR8Kk/CRCr6aSPRJJqlO9\nPRIvSJQkbaBVhrYkSW3CIJEkpWKQSJJSMUgkSakYJJKkVAwSSVIqBokkKRWDRJKUikEiSUrFIJEk\npWKQSJJSMUgkSakYJJKkVAwSSVIqBokkKRWDRJKUikEiSUrFIJEkpWKQSJJSMUgkSakYJJKkVAwS\nSVIqWQXJx4H5wELgMeCAsm3fBp4DlgKfrbJ/B7Ay7r8QOKJZhUqSupdVkFwKnA+MA74blwH2AibH\n5yOAq0musQhcGfcfB8xqcr0bpUKhkHUJTdXOx9fOxwYe36YmqyBZDWwZ28OAF2P7GGAm8A6wAlhG\n6L0kyTWxvpbQ7v8zt/PxtfOxgce3qRmQ0edOA34NXE4Is0/G9dsBvy173Urgw1Xe40zgK8DjwNnA\n2qZUKknqVjN7JHOAJQmPo4EbgG8AOwJnATd28z7FhHXXADsDHyP0bq5oWNWSpLpkNTz0KjC0rIa1\nhKGuaXHdxfF5FjAdeLSb9xoN3Avsm7BtGTAmZa2StKnpBHbNuoiePAEcEtufIZy5BWGS/UlgIKHH\n0Uly2I0qa58F3NqcMiVJG6v9Cb2MJ4HfEM68KjmX0JNYCvxd2foZwPjY/gmwGFgE3A2MaHK9kiRJ\nktS9QXT1cp4G/j2uv5DQc3kSmAvskEl16VQ7tpKzgXeB4X1cV6NUO74O2uPC0+5+fmcCzwBPAZf0\nfWkNUe34bqfrZ7c8PreaasfW3UXVraTa8X2UMFq0GLgH2CKT6jKyeXweQDiN+NNs+B/gTOD6vi6q\nQZKODUIwziL8Q23VIIHk45sO/EtmFTVW0vEdSji78QNx2zYZ1NUo1f7/LLkc+E6fVtQ4Scf2AF1D\n70fG5VaVdHyPARPi+pOBC7p7g3a719Yb8Xkg0B/4M/Ba2fYPAn/q66IaJOnYIFzh/61MKmqsyuN7\nJS63y4WnScd3OuEvwHfitj9mUFejVPv/E8LPcBLhYuNWlPSze4nki6pbUdLx7QY8FNffD/xDBnVl\nph+hi/YaXbddAfg+8AJhAn9YBnU1QtKxHQNcFdut3iNJOr7phDscLCJce9SqPztIPr6FhOG73wIF\nwkkoraravz2Ag+k6M7MVJR3bTsAfCL9XVtKaQ+YlScf3MOH3C4RRgVczqCtzWxL+ceYr1k8Dburz\nahqrdGxHxefS9TjLgQ9lVVQDlf/stiX8NZsDvkcIk1ZXfnxLgB/E9QcAz2dUUyMl/du7hnCafqsr\nP7b7gePi+hMIQ5Strvz4PgLcR7hzyHdp3ZGc1M4H/rVi3Y6ESc1Wdz5hvHkNIUCW03V/sm2zK6th\nkn52owm/eNtB6fh+Sdf1VBBOe2+HPwbKf34DCMNA22VXTkOVjq38L/Qc8Jdsymm4pH97u9P9ReFt\nNUeyNV1DH4OBwwlDB+VXZx5Da545knRsvyFcP7NzfKwkXGfzchYFplTtZzey7DXH0bpBUu347gYm\nxvW7E8ao/6/Pq0uv2vEBHEY4K21VBnU1QtKxPUkI/dIfAROBZ/u+tIao9rMrnfjRj/BH6zXdvUlW\nN21shlHAzYQD7wf8lHC67x2Ebtp6wpXyX8uqwBSqHVu5pHuStYpqx/cTwv3UioRe12lZFZhSteN7\nkHCfuSXA24SbkLai7v7/nEzrTrJD8rHdD/wz8CNgM+BvcbkVVfvZfRM4I77mTuC/sihOkiRJkiRJ\nkiRJkiRJkiRJkqSMvd7D9i3Z8Fql7YBfxPZHCXeKrVcH4asCpI1SO13ZLvWFni783IquC7kgXNF9\nQmyPI9wjrdGfKUlqIaWvJfgg4QrnBYQv/zk6rr+NcFvuhYQvqtqJcOX6Bwh3in05bpvE+3saTxHu\nBwdwHvA7wq28by173RjCPboeJ1wZ/5EGHpskqQ+UgqQ/XV+atjXwXGyXgqNkdNnyVOA/yrZNZ8Mg\nWUIIkv0I4TQofsZzdH3B11y67h93IO+/VY7U59rpXltSX+pH+FKqCYSvOd6OrtveV5PrYXvpNROA\n/wbejI974rYhwEF0zblAuNGjlCmDROqdkwg9kfGEG4IuJ/Qg6rGODecpS/sX2TBwSu1+hG+vG1dv\nsVIzOdku9c5QwnzHesJ3r+8U179G15BXpVcrtq0gBBHxeWdCiDwIHEvX0Nbny957OXB8XM4BY9Md\nhpSeQSLVp3QG1c8IX427GPgy4Ts3IHyfyMOE+Y5L4utL+zwA7EWYbD+BcHvu4YRJ9q8TJteJ228n\nfMXw/wDzyz7/JOAUwndiPEXXJL8kSZIkSZIkSZIkSZIkSZIkSZIkSZK08fp/h5z1OtMxFLcAAAAA\nSUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x114a0e4d0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "df.plot(x='latitude', y='longitude', kind='scatter')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<iframe src=\"data:text/html;base64,PGhlYWQ+CiAgICA8c2NyaXB0IHNyYz0iaHR0cHM6Ly9jZG5qcy5jbG91ZGZsYXJlLmNvbS9hamF4L2xpYnMvbGVhZmxldC8wLjcuMy9sZWFmbGV0LmpzIj48L3NjcmlwdD4KICAgIDxsaW5rIHJlbD0ic3R5bGVzaGVldCIgaHJlZj0iaHR0cHM6Ly9jZG5qcy5jbG91ZGZsYXJlLmNvbS9hamF4L2xpYnMvbGVhZmxldC8wLjcuMy9sZWFmbGV0LmNzcyIgLz4KICA8c3R5bGU+CiAgICAjbWFwYTA1ZGNhOGMyYTEzNGE0ZjkyMzNkMmUzMWNhYmY3MzEgewogICAgICBoZWlnaHQ6MTAwJTsKICAgIH0KICA8L3N0eWxlPiAKPC9oZWFkPgo8Ym9keT4KICA8ZGl2IGlkPSJtYXBhMDVkY2E4YzJhMTM0YTRmOTIzM2QyZTMxY2FiZjczMSI+PC9kaXY+CjxzY3JpcHQgdGV4dD0idGV4dC9qYXZhc2NyaXB0Ij4KdmFyIG1hcCA9IEwubWFwKCdtYXBhMDVkY2E4YzJhMTM0YTRmOTIzM2QyZTMxY2FiZjczMScpOwpMLnRpbGVMYXllcigKICAiaHR0cDovL3tzfS50aWxlLm9wZW5zdHJlZXRtYXAub3JnL3t6fS97eH0ve3l9LnBuZyIsCiAge21heFpvb206MTksIGF0dHJpYnV0aW9uOiAnPGEgaHJlZj0iaHR0cHM6Ly9naXRodWIuY29tL2p3YXNzL21wbGxlYWZsZXQiPm1wbGxlYWZsZXQ8L2E+IHwgTWFwIGRhdGEgKGMpIDxhIGhyZWY9Imh0dHA6Ly9vcGVuc3RyZWV0bWFwLm9yZyI+T3BlblN0cmVldE1hcDwvYT4gY29udHJpYnV0b3JzJ30pLmFkZFRvKG1hcCk7CnZhciBnakRhdGEgPSB7InR5cGUiOiAiRmVhdHVyZUNvbGxlY3Rpb24iLCAiZmVhdHVyZXMiOiBbXX07CgppZiAoZ2pEYXRhLmZlYXR1cmVzLmxlbmd0aCAhPSAwKSB7CiAgdmFyIGdqID0gTC5nZW9Kc29uKGdqRGF0YSwgewogICAgc3R5bGU6IGZ1bmN0aW9uIChmZWF0dXJlKSB7CiAgICAgIHJldHVybiBmZWF0dXJlLnByb3BlcnRpZXM7CiAgICB9LAogICAgcG9pbnRUb0xheWVyOiBmdW5jdGlvbiAoZmVhdHVyZSwgbGF0bG5nKSB7CiAgICAgIHZhciBpY29uID0gTC5kaXZJY29uKHsnaHRtbCc6IGZlYXR1cmUucHJvcGVydGllcy5odG1sLCAKICAgICAgICBpY29uQW5jaG9yOiBbZmVhdHVyZS5wcm9wZXJ0aWVzLmFuY2hvcl94LCAKICAgICAgICAgICAgICAgICAgICAgZmVhdHVyZS5wcm9wZXJ0aWVzLmFuY2hvcl95XSwgCiAgICAgICAgICBjbGFzc05hbWU6ICdlbXB0eSd9KTsgIC8vIFdoYXQgY2FuIEkgZG8gYWJvdXQgZW1wdHk/CiAgICAgIHJldHVybiBMLm1hcmtlcihsYXRsbmcsIHtpY29uOiBpY29ufSk7CiAgICB9CiAgfSk7CiAgZ2ouYWRkVG8obWFwKTsKICAKICBtYXAuZml0Qm91bmRzKGdqLmdldEJvdW5kcygpKTsKfSBlbHNlIHsKICBtYXAuc2V0VmlldyhbMCwgMF0sIDEpOwp9Cjwvc2NyaXB0Pgo8L2JvZHk+\" width=\"100%\" height=\"240\"></iframe>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ml.display()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df[['longitude', 'latitude', 'altitude']] = df[['longitude', 'latitude', 'altitude']].astype(float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>HSpeed</th>\n",
       "      <th>VSpeed</th>\n",
       "      <th>abpVersion</th>\n",
       "      <th>acpuVersion</th>\n",
       "      <th>airlineCode</th>\n",
       "      <th>airlineCodeIata</th>\n",
       "      <th>airlineName</th>\n",
       "      <th>altitude</th>\n",
       "      <th>departureAirportCode</th>\n",
       "      <th>departureAirportCodeIata</th>\n",
       "      <th>...</th>\n",
       "      <th>flightNumberAlpha</th>\n",
       "      <th>flightNumberInfo</th>\n",
       "      <th>flightNumberNumeric</th>\n",
       "      <th>latitude</th>\n",
       "      <th>localTime</th>\n",
       "      <th>longitude</th>\n",
       "      <th>origin</th>\n",
       "      <th>tailNumber</th>\n",
       "      <th>utcTime</th>\n",
       "      <th>videoService</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>256.557</td>\n",
       "      <td>-0.77216</td>\n",
       "      <td>4.0.4</td>\n",
       "      <td>6.4.0</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AA</td>\n",
       "      <td>American Airlines</td>\n",
       "      <td>9443.618</td>\n",
       "      <td>KMIA</td>\n",
       "      <td>MIA</td>\n",
       "      <td>...</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AAL1359</td>\n",
       "      <td>1359</td>\n",
       "      <td>33.314</td>\n",
       "      <td>2016-06-06T12:18:03.336Z0:0</td>\n",
       "      <td>-79.9612</td>\n",
       "      <td>MIA</td>\n",
       "      <td>N905AN</td>\n",
       "      <td>2016-06-06T12:18:03.336Z</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>256.557</td>\n",
       "      <td>-0.77216</td>\n",
       "      <td>4.0.4</td>\n",
       "      <td>6.4.0</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AA</td>\n",
       "      <td>American Airlines</td>\n",
       "      <td>9443.618</td>\n",
       "      <td>KMIA</td>\n",
       "      <td>MIA</td>\n",
       "      <td>...</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AAL1359</td>\n",
       "      <td>1359</td>\n",
       "      <td>33.314</td>\n",
       "      <td>2016-06-06T12:18:03.336Z0:0</td>\n",
       "      <td>-79.9612</td>\n",
       "      <td>MIA</td>\n",
       "      <td>N905AN</td>\n",
       "      <td>2016-06-06T12:18:03.336Z</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    HSpeed   VSpeed abpVersion acpuVersion airlineCode airlineCodeIata  \\\n",
       "0  256.557 -0.77216      4.0.4       6.4.0         AAL              AA   \n",
       "0  256.557 -0.77216      4.0.4       6.4.0         AAL              AA   \n",
       "\n",
       "         airlineName  altitude departureAirportCode departureAirportCodeIata  \\\n",
       "0  American Airlines  9443.618                 KMIA                      MIA   \n",
       "0  American Airlines  9443.618                 KMIA                      MIA   \n",
       "\n",
       "       ...      flightNumberAlpha flightNumberInfo flightNumberNumeric  \\\n",
       "0      ...                    AAL          AAL1359                1359   \n",
       "0      ...                    AAL          AAL1359                1359   \n",
       "\n",
       "  latitude                    localTime longitude  origin  tailNumber  \\\n",
       "0   33.314  2016-06-06T12:18:03.336Z0:0  -79.9612     MIA      N905AN   \n",
       "0   33.314  2016-06-06T12:18:03.336Z0:0  -79.9612     MIA      N905AN   \n",
       "\n",
       "                    utcTime  videoService  \n",
       "0  2016-06-06T12:18:03.336Z         False  \n",
       "0  2016-06-06T12:18:03.336Z         False  \n",
       "\n",
       "[2 rows x 24 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.set_index('utcTime')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import us"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "def get_states():\n",
    "    contiguous = [state for state in us.states.STATES if state.is_contiguous]\n",
    "    shapefiles = [state.shapefile_urls()['state'] for state in contiguous]\n",
    "\n",
    "    return dict(zip(contiguous, shapefiles))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{<State:Arizona>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_04_state10.zip',\n",
       " <State:Arkansas>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_05_state10.zip',\n",
       " <State:California>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_06_state10.zip',\n",
       " <State:Alabama>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_01_state10.zip',\n",
       " <State:Colorado>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_08_state10.zip',\n",
       " <State:Texas>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_48_state10.zip',\n",
       " <State:Utah>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_49_state10.zip',\n",
       " <State:Vermont>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_50_state10.zip',\n",
       " <State:Virginia>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_51_state10.zip',\n",
       " <State:Washington>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_53_state10.zip',\n",
       " <State:West Virginia>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_54_state10.zip',\n",
       " <State:Wisconsin>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_55_state10.zip',\n",
       " <State:Wyoming>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_56_state10.zip',\n",
       " <State:Rhode Island>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_44_state10.zip',\n",
       " <State:Mississippi>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_28_state10.zip',\n",
       " <State:Missouri>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_29_state10.zip',\n",
       " <State:Nebraska>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_31_state10.zip',\n",
       " <State:Montana>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_30_state10.zip',\n",
       " <State:Nevada>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_32_state10.zip',\n",
       " <State:New Hampshire>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_33_state10.zip',\n",
       " <State:New Mexico>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_35_state10.zip',\n",
       " <State:Pennsylvania>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_42_state10.zip',\n",
       " <State:New Jersey>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_34_state10.zip',\n",
       " <State:Massachusetts>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_25_state10.zip',\n",
       " <State:Ohio>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_39_state10.zip',\n",
       " <State:New York>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_36_state10.zip',\n",
       " <State:Minnesota>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_27_state10.zip',\n",
       " <State:Maine>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_23_state10.zip',\n",
       " <State:Oklahoma>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_40_state10.zip',\n",
       " <State:South Carolina>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_45_state10.zip',\n",
       " <State:Maryland>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_24_state10.zip',\n",
       " <State:North Carolina>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_37_state10.zip',\n",
       " <State:Oregon>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_41_state10.zip',\n",
       " <State:Indiana>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_18_state10.zip',\n",
       " <State:Tennessee>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_47_state10.zip',\n",
       " <State:Kentucky>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_21_state10.zip',\n",
       " <State:Iowa>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_19_state10.zip',\n",
       " <State:North Dakota>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_38_state10.zip',\n",
       " <State:Kansas>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_20_state10.zip',\n",
       " <State:Idaho>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_16_state10.zip',\n",
       " <State:South Dakota>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_46_state10.zip',\n",
       " <State:Florida>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_12_state10.zip',\n",
       " <State:Illinois>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_17_state10.zip',\n",
       " <State:Georgia>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_13_state10.zip',\n",
       " <State:Louisiana>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_22_state10.zip',\n",
       " <State:Michigan>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_26_state10.zip',\n",
       " <State:Delaware>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_10_state10.zip',\n",
       " <State:Connecticut>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_09_state10.zip',\n",
       " <State:District of Columbia>: u'http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_11_state10.zip'}"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def get_boundaries(states):\n",
    "    \"\"\"Takes in a dictionary with states and zip files, returns a dictionarty with states and boundaries\"\"\"\n",
    "    # Download zip file\n",
    "    # unzip it and open it with shapely\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current\n",
      "                                 Dload  Upload   Total   Spent    Left  Speed\n",
      "\r",
      "  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0\r",
      " 59  105k   59 64445    0     0  2577k      0 --:--:-- --:--:-- --:--:-- 2517k\r",
      "100  105k  100  105k    0     0   308k      0 --:--:-- --:--:-- --:--:--  308k\n"
     ]
    }
   ],
   "source": [
    "%%bash\n",
    "curl -O http://www2.census.gov/geo/tiger/TIGER2010/STATE/2010/tl_2010_04_state10.zip"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Archive:  tl_2010_04_state10.zip\n",
      "  inflating: tl_2010_04_state10.dbf  \n",
      "  inflating: tl_2010_04_state10.prj  \n",
      "  inflating: tl_2010_04_state10.shp  \n",
      "  inflating: tl_2010_04_state10.shp.xml  \n",
      "  inflating: tl_2010_04_state10.shx  \n"
     ]
    }
   ],
   "source": [
    "%%bash\n",
    "unzip tl_2010_04_state10.zip"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df = flight(data=df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "ERROR: Cell magic `%%show` not found.\n"
     ]
    }
   ],
   "source": [
    "%%show\n",
    "fiona.png\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "shp = fiona.open('tl_2010_04_state10.shp')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<open Collection 'tl_2010_04_state10.shp:tl_2010_04_state10', mode 'r' at 0x11456b890>"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "shp"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Next task, figure out how to plot things by reading this tutorial:\n",
    "    \n",
    "    http://sensitivecities.com/so-youd-like-to-make-a-map-using-python-EN.html"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df = flight(data=df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>HSpeed</th>\n",
       "      <th>VSpeed</th>\n",
       "      <th>abpVersion</th>\n",
       "      <th>acpuVersion</th>\n",
       "      <th>airlineCode</th>\n",
       "      <th>airlineCodeIata</th>\n",
       "      <th>airlineName</th>\n",
       "      <th>altitude</th>\n",
       "      <th>departureAirportCode</th>\n",
       "      <th>departureAirportCodeIata</th>\n",
       "      <th>...</th>\n",
       "      <th>flightNumberAlpha</th>\n",
       "      <th>flightNumberInfo</th>\n",
       "      <th>flightNumberNumeric</th>\n",
       "      <th>latitude</th>\n",
       "      <th>localTime</th>\n",
       "      <th>longitude</th>\n",
       "      <th>origin</th>\n",
       "      <th>tailNumber</th>\n",
       "      <th>utcTime</th>\n",
       "      <th>videoService</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>256.5570</td>\n",
       "      <td>-0.77216</td>\n",
       "      <td>4.0.4</td>\n",
       "      <td>6.4.0</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AA</td>\n",
       "      <td>American Airlines</td>\n",
       "      <td>9443.6180</td>\n",
       "      <td>KMIA</td>\n",
       "      <td>MIA</td>\n",
       "      <td>...</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AAL1359</td>\n",
       "      <td>1359</td>\n",
       "      <td>33.3140</td>\n",
       "      <td>2016-06-06T12:18:03.336Z0:0</td>\n",
       "      <td>-79.9612</td>\n",
       "      <td>MIA</td>\n",
       "      <td>N905AN</td>\n",
       "      <td>2016-06-06T12:18:03.336Z</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>256.5570</td>\n",
       "      <td>-0.77216</td>\n",
       "      <td>4.0.4</td>\n",
       "      <td>6.4.0</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AA</td>\n",
       "      <td>American Airlines</td>\n",
       "      <td>9443.6180</td>\n",
       "      <td>KMIA</td>\n",
       "      <td>MIA</td>\n",
       "      <td>...</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AAL1359</td>\n",
       "      <td>1359</td>\n",
       "      <td>33.3140</td>\n",
       "      <td>2016-06-06T12:18:03.336Z0:0</td>\n",
       "      <td>-79.9612</td>\n",
       "      <td>MIA</td>\n",
       "      <td>N905AN</td>\n",
       "      <td>2016-06-06T12:18:03.336Z</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>232.5731</td>\n",
       "      <td>-4.78536</td>\n",
       "      <td>4.0.4</td>\n",
       "      <td>6.4.0</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AA</td>\n",
       "      <td>American Airlines</td>\n",
       "      <td>7871.1553</td>\n",
       "      <td>KMIA</td>\n",
       "      <td>MIA</td>\n",
       "      <td>...</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AAL1359</td>\n",
       "      <td>1359</td>\n",
       "      <td>37.2739</td>\n",
       "      <td>2016-06-06T12:50:06.219Z0:0</td>\n",
       "      <td>-77.5992</td>\n",
       "      <td>MIA</td>\n",
       "      <td>N905AN</td>\n",
       "      <td>2016-06-06T12:50:06.219Z</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>209.0393</td>\n",
       "      <td>-6.77672</td>\n",
       "      <td>4.0.4</td>\n",
       "      <td>6.4.0</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AA</td>\n",
       "      <td>American Airlines</td>\n",
       "      <td>6322.4663</td>\n",
       "      <td>KMIA</td>\n",
       "      <td>MIA</td>\n",
       "      <td>...</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AAL1359</td>\n",
       "      <td>1359</td>\n",
       "      <td>37.6186</td>\n",
       "      <td>2016-06-06T12:53:08.306Z0:0</td>\n",
       "      <td>-77.4406</td>\n",
       "      <td>MIA</td>\n",
       "      <td>N905AN</td>\n",
       "      <td>2016-06-06T12:53:08.306Z</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>175.5390</td>\n",
       "      <td>-12.34440</td>\n",
       "      <td>4.0.4</td>\n",
       "      <td>6.4.0</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AA</td>\n",
       "      <td>American Airlines</td>\n",
       "      <td>4764.6340</td>\n",
       "      <td>KMIA</td>\n",
       "      <td>MIA</td>\n",
       "      <td>...</td>\n",
       "      <td>AAL</td>\n",
       "      <td>AAL1359</td>\n",
       "      <td>1359</td>\n",
       "      <td>38.0951</td>\n",
       "      <td>2016-06-06T12:58:02.449Z0:0</td>\n",
       "      <td>-77.2936</td>\n",
       "      <td>MIA</td>\n",
       "      <td>N905AN</td>\n",
       "      <td>2016-06-06T12:58:02.449Z</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     HSpeed    VSpeed abpVersion acpuVersion airlineCode airlineCodeIata  \\\n",
       "0  256.5570  -0.77216      4.0.4       6.4.0         AAL              AA   \n",
       "0  256.5570  -0.77216      4.0.4       6.4.0         AAL              AA   \n",
       "0  232.5731  -4.78536      4.0.4       6.4.0         AAL              AA   \n",
       "0  209.0393  -6.77672      4.0.4       6.4.0         AAL              AA   \n",
       "0  175.5390 -12.34440      4.0.4       6.4.0         AAL              AA   \n",
       "\n",
       "         airlineName   altitude departureAirportCode departureAirportCodeIata  \\\n",
       "0  American Airlines  9443.6180                 KMIA                      MIA   \n",
       "0  American Airlines  9443.6180                 KMIA                      MIA   \n",
       "0  American Airlines  7871.1553                 KMIA                      MIA   \n",
       "0  American Airlines  6322.4663                 KMIA                      MIA   \n",
       "0  American Airlines  4764.6340                 KMIA                      MIA   \n",
       "\n",
       "       ...      flightNumberAlpha flightNumberInfo flightNumberNumeric  \\\n",
       "0      ...                    AAL          AAL1359                1359   \n",
       "0      ...                    AAL          AAL1359                1359   \n",
       "0      ...                    AAL          AAL1359                1359   \n",
       "0      ...                    AAL          AAL1359                1359   \n",
       "0      ...                    AAL          AAL1359                1359   \n",
       "\n",
       "  latitude                    localTime longitude  origin  tailNumber  \\\n",
       "0  33.3140  2016-06-06T12:18:03.336Z0:0  -79.9612     MIA      N905AN   \n",
       "0  33.3140  2016-06-06T12:18:03.336Z0:0  -79.9612     MIA      N905AN   \n",
       "0  37.2739  2016-06-06T12:50:06.219Z0:0  -77.5992     MIA      N905AN   \n",
       "0  37.6186  2016-06-06T12:53:08.306Z0:0  -77.4406     MIA      N905AN   \n",
       "0  38.0951  2016-06-06T12:58:02.449Z0:0  -77.2936     MIA      N905AN   \n",
       "\n",
       "                    utcTime  videoService  \n",
       "0  2016-06-06T12:18:03.336Z         False  \n",
       "0  2016-06-06T12:18:03.336Z         False  \n",
       "0  2016-06-06T12:50:06.219Z         False  \n",
       "0  2016-06-06T12:53:08.306Z         False  \n",
       "0  2016-06-06T12:58:02.449Z         False  \n",
       "\n",
       "[5 rows x 24 columns]"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df.to_csv('miami-dca.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Flight.ipynb                \u001b[31mtl_2010_04_state10.prj\u001b[m\u001b[m*\r\n",
      "_map.html                   \u001b[31mtl_2010_04_state10.shp\u001b[m\u001b[m*\r\n",
      "fiona.png                   \u001b[31mtl_2010_04_state10.shp.xml\u001b[m\u001b[m*\r\n",
      "miami-dca.csv               \u001b[31mtl_2010_04_state10.shx\u001b[m\u001b[m*\r\n",
      "requirements.txt            tl_2010_04_state10.zip\r\n",
      "\u001b[31mtl_2010_04_state10.dbf\u001b[m\u001b[m*\r\n"
     ]
    }
   ],
   "source": [
    "ls"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      ",HSpeed,VSpeed,abpVersion,acpuVersion,airlineCode,airlineCodeIata,airlineName,altitude,departureAirportCode,departureAirportCodeIata,destination,destinationAirportCode,destinationAirportCodeIata,expectedArrival,flightNumberAlpha,flightNumberInfo,flightNumberNumeric,latitude,localTime,longitude,origin,tailNumber,utcTime,videoService\r\n",
      "0,256.557,-0.77216,4.0.4,6.4.0,AAL,AA,American Airlines,9443.618,KMIA,MIA,DCA,KDCA,DCA,2016-06-06T13:28:00Z,AAL,AAL1359,1359,33.314,2016-06-06T12:18:03.336Z0:0,-79.9612,MIA,N905AN,2016-06-06T12:18:03.336Z,False\r\n",
      "0,256.557,-0.77216,4.0.4,6.4.0,AAL,AA,American Airlines,9443.618,KMIA,MIA,DCA,KDCA,DCA,2016-06-06T13:28:00Z,AAL,AAL1359,1359,33.314,2016-06-06T12:18:03.336Z0:0,-79.9612,MIA,N905AN,2016-06-06T12:18:03.336Z,False\r\n",
      "0,232.5731,-4.78536,4.0.4,6.4.0,AAL,AA,American Airlines,7871.1553,KMIA,MIA,DCA,KDCA,DCA,2016-06-06T13:28:00Z,AAL,AAL1359,1359,37.2739,2016-06-06T12:50:06.219Z0:0,-77.5992,MIA,N905AN,2016-06-06T12:50:06.219Z,False\r\n",
      "0,209.0393,-6.77672,4.0.4,6.4.0,AAL,AA,American Airlines,6322.4663,KMIA,MIA,DCA,KDCA,DCA,2016-06-06T13:28:00Z,AAL,AAL1359,1359,37.6186,2016-06-06T12:53:08.306Z0:0,-77.4406,MIA,N905AN,2016-06-06T12:53:08.306Z,False\r\n",
      "0,175.539,-12.3444,4.0.4,6.4.0,AAL,AA,American Airlines,4764.634,KMIA,MIA,DCA,KDCA,DCA,2016-06-06T13:28:00Z,AAL,AAL1359,1359,38.0951,2016-06-06T12:58:02.449Z0:0,-77.2936,MIA,N905AN,2016-06-06T12:58:02.449Z,False\r\n"
     ]
    }
   ],
   "source": [
    "cat miami-dca.csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}