X01. Introduction to APIs.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from IPython.display import YouTubeVideo"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# X01: Introduction to APIs"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "In this section of the course we'll look at API's and how we can use them with Python. For many people APIs can be a bit of a mystery, but there's nothing to fear - as with most things, the concept is actually quite simple once you cut away the jargon."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## What is an API?"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "API stands for Application Program Interface and a popular technical definition is this:\n",
    "\n",
    "<i>'A set of functions and procedures that allow the creation of applications which access the features or data of an operating system, application, or other service.'</i>\n",
    "    \n",
    "However on a more simple level, you can think of it as:\n",
    "\n",
    "<i>'How computers, apps, or pieces of software communicate with one another'</i>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<img src = img/API.png>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "API's can take many forms and you may not have realised it but you've been using APIs throughout this training course through libraries such as <a href = \"http://pandas.pydata.org/pandas-docs/stable/api.html\">Pandas</a>, <a href = \"http://matplotlib.org/api/\">Matplotlib</a> and <a href = \"https://stanford.edu/~mwaskom/software/seaborn/api.html\">Seaborn</a>. These are all examples of software APIs where the interface that your computer is using to communicate with the software library is of course Python!\n",
    "\n",
    "In this lesson we're going to be looking at how we can use Python to interact with web based APIs."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## What can you use web based APIs for?"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "You can use web based APIs for a variety of things including:\n",
    "\n",
    "* Making requests to use a particular service (e.g. embedding Google Maps on your website)\n",
    "* Making requests for data (e.g. using the <a href = \"https://api.tfl.gov.uk/\">TfL API</a>)\n",
    "* Performing an action (e.g. Posting to twitter or authenticating a user)\n",
    "\n",
    "Most APIs have an authentication system to regulate access so in most cases you'll need to register and get an API key.\n",
    "\n",
    "In terms of There are two main types of web based APIs that you're likely to come across... Representational State Transfer (REST) and  Simple Object Access Protocol (SOAP). In this lesson we're going to be focussing on using REST  APIs and the following video gives an excellent introduction:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "image/jpeg": "/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAUDBAsKCAoKCgoKCg0KCggKCgoKCgoKCAoKCgoKCgoN\nCgoKChALCgoOCggIDRUNDhERExMTCg0WGBYSGBASExIBBQUFCAcIDwkJDxQUEBUUFBQUFRQUFBQV\nFBUUFBQUFBQUFBQUFBUVFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFP/AABEIAWgB4AMBIgACEQED\nEQH/xAAdAAEAAgIDAQEAAAAAAAAAAAAABgcFCAEDBAIJ/8QAWRAAAQMCAwMEDAURBwIFBQEAAQAC\nAwQRBRIhBgcxE0FRYRgiNVJUcXSBkZSz1RQykqGxCBUWMzRCU3JzgpOissHS0/AXI2LD0eHxo8Ik\nJUPU5DZjg4S0RP/EABoBAQADAQEBAAAAAAAAAAAAAAABAgMEBQb/xAAvEQEAAgICAQIEBQMFAQAA\nAAAAAQIDEQQhEjFBBRMiURQyYXGhUpHwYnKBscEG/9oADAMBAAIRAxEAPwDTJERAREQEREBERARE\nQEREBERAREQEREBERAREQEREBERAREQEREBERAREQEREBERAREQEREBERAREQEREBERAREQEREBE\nRAREQEREBERAREQEREBERAREQEREBERAREQEREBERAREQEREBERAREQEREBERAREQEREBERAREQE\nREBERAREQEREBERAREQEREBERAREQEREBFsz2FWPeGYN6xXe7k7CrHvDMG9YrvdyDWZFsz2FWPeG\nYN6xXe7k7CrHvDMG9YrvdyDWZFsz2FWPeGYN6xXe7k7CrHvDMG9YrvdyDWZFsz2FWPeGYN6xXe7k\n7CrHvDMG9YrvdyDWZFsz2FWPeGYN6xXe7k7CrHvDMG9YrvdyDWZFsz2FWPeGYN6xXe7k7CrHvDMG\n9YrvdyDWZFsz2FWPeGYN6xXe7k7CrHvDMG9YrvdyDWZFsz2FWPeGYN6xXe7k7CrHvDMG9YrvdyDW\nZFsz2FWPeGYN6xXe7k7CrHvDMG9YrvdyDWZFsz2FWPeGYN6xXe7k7CrHvDMG9YrvdyDWZFsz2FWP\neGYN6xXe7k7CrHvDMG9YrvdyDWZFsz2FWPeGYN6xXe7k7CrHvDMG9YrvdyDWZFsz2FWPeGYN6xXe\n7k7CrHvDMG9YrvdyDWZFsz2FWPeGYN6xXe7k7CrHvDMG9YrvdyDWZFsz2FWPeGYN6xXe7k7CrHvD\nMG9YrvdyDWZFsz2FWPeGYN6xXe7k7CrHvDMG9YrvdyDWZFsz2FWPeGYN6xXe7k7CrHvDMG9Yrvdy\nDWZFsz2FWPeGYN6xXe7k7CrHvDMG9YrvdyDWZFsz2FWPeGYN6xXe7k7CrHvDMG9YrvdyDWZFsz2F\nWPeGYN6xXe7k7CrHvDMG9YrvdyDWZFsz2FWPeGYN6xXe7k7CrHvDMG9YrvdyDWZFsz2FWPeGYN6x\nXe7k7CrHvDMG9YrvdyDWZFsz2FWPeGYN6xXe7k7CrHvDMG9YrvdyDWZFsz2FWPeGYN6xXe7k7CrH\nvDMG9YrvdyDWZFsz2FWPeGYN6xXe7k7CrHvDMG9YrvdyDWZFsz2FWPeGYN6xXe7k7CrHvDMG9Yrv\ndyDWZFsz2FWPeGYN6xXe7k7CrHvDMG9YrvdyDWZFsz2FWPeGYN6xXe7k7CrHvDMG9YrvdyDWZFsz\n2FWPeGYL6xXe7k7CrHvDMF9YrvdyDWZFsz2FWPeGYL6xXe7k7CrHvDMF9YrvdyDf9ERAREQEREBE\nRAREQEREBERAREQEREBERAREQEREBERAREQEREBERAREQEREBERAREQERddVUMjY58j2sa0Xc97g\n1jR0uc42A6yg7EVO7xN/FLRuMVFH8OkHGTlOTom/iyBrnTH8RuU98qtxP6o/FHtLWRUkJPB0cMr5\nB4nSyujJ6zH5lXyhaKzLbKWQNaXOIaGgkucQGgDiSToAoy/eJhIfkOKUAdcgg1UIsRpqS+w8/FaV\nbU7yq+ua5lZUzTMccxY55EVxw/uYw2IEc1miyib5LjMzUdRNx+aTYqs2laKQ/Q2i2ww+V2WKvo5H\nG1msqYXOdfhlAf21+pZI4lEJhAZGCRzS5kbjle9rfjGMH44Gly29ri9l+bra6Ro0eSD0EgHp8R6i\npPgm11S2IRfCZTG1zC1hcbwuaQWui1tG4GxDmFrhzEHVR5zBFNv0FRa6brt+hbJHS4k7MC5rRVDi\nWusGulGmrXfGcOI1IzNJff2F4lFMDycrJQDxY4HmBsQOBAcPSFat4t6K2rNfV7UReR9QeVDARrYW\n5wAC55t4nQjqzhXVetERAREQEREHBRcrgohyiIiUV2g29paSofBK2bNHlJysBaQ5geLEvF9HW8YK\nlLTcXHOqW33U+XEWu5pKeM3/AMTXyNP6oZ6VbWzNRylFTSd/TwOPjdG0n5yg6tp8eiooRLNnyue2\nMZAHOLi1zhoSNLMcudmcdirYTNDmyh7mEPAa4OaAToCeZwUI381NoqWLvpJZP0bWt/zivvcPU3p6\nqLvZY5P0jMv+QgsaR4aCTwAJPiGpUY2d26pqydsELZszg5wzsaGgNFzch58XnWV2tn5Ogq387aeo\nI8fJuy/PZVbuOp718j+aOncPznyRgfqtegtPaXHIqKHlpg8tztZ2gDnXdcjQkadqV8bL7QRV0TpY\nQ8NZIYznaGnMGtdoATpZ4Ud32dzB5RD9D159xX3BP5U/2MCCwEREBERAREQEREBERAREQEWIrdpq\nSKUxSVEbHtIDmE9sC4AjS3OHA+dZdAREQEREBERAREQEREBERAREQERdFfVxwxPlle2NkbS973kN\nY1o1JcToAgw23m2NJhVKamskyt4MY2zppXd7Gy4ueGpIAvqQtPN5O9KuxaR+skcJceTiblETGg9r\nroS6x1de58QCb7Nu5MVxF0jnjkI3PZSRWs1kV7Zy34xkfbMS7XWwsBZQQ1RJADmjm7a/z5QbeJYz\nbbWK6fLYCT28mp5m5pHHx2IA9JXnqqLntNfqsL+a5KylPTve25JcAR9rflI82Uj0tXZLDGBo934k\nzQR+ljdbzOATyW8Ee5NzeOZw/wAQII8/+yfF7dutuI4OA6RbiB/V+KyLqdrrhpMbua/xPFpw+ZeB\nhLX9uLEHW+rXC9jzdane0a07HxgEHTJLoehknMeoEr5giLZB48p6NdB8+i4klAjfGL2Lmlp6Lfvs\nAshLVNEDH6Z3ObcfivBv8yrKYe2CJ0kZA+NDYjpLCB84/cp1uy2wmop4Jo5HAZ2iSPM7I6wc0hwB\ns4We42PCxsRqoHDijYqoPB0c0scB4tCekcV9HEmtleG2DXNjmb1OIZmHpLx6VhNZ3uG0TGtS31l2\nmp20nwp80bWZbi0jbEngA64uT5uldezlfE6F1U58bA4OkJLmtDIib5nm/ag2HG3atjuAQVozFj4e\n9mYOcGAAjlbZ337UuLW3ygaZQQT3yuHdlg1NVa1M0xzuafg8FQyMDQZeVfPOwONw4jK1/E6khdEZ\nJ25/lxENkcOxyKZxa02IsRG7SpLTwc6D7ZEw82cNPSBpfKLA7F4I2jpxFG972D4rXNpxl8ToIYw7\nSw1BOnFZ5bMhERAREQEKIgIiIKs39U/bUknVUMJ/Rub/AN6l+7GfPhNKehj2fo5Hx/QwLDb8afNh\n8b/wdQy/4rmSNP6xYu7cpPmwwt/BzzM9IZJ/moItvslL8Qp4R97C35Usrh9EbPSudxdRlrKiLv4Q\n/wA8Ugb/AJxXRtP/AH+0zGcQ2oo2fmsEb5Pn5RcbFHkNo3x8A6aui/N/vHs9PJs9KCwN6k+TCak9\n8ImfLlY0/qlyi24Wn7Wrk6TAwfmiRzv22ehZXfdPlw5jfwlRE0+IMkf9LGr63JU+XDXO/CVErvM1\nrI/pjd6UHO+zuYPKIfoevPuK+4J/Kn+xgXo32dzB5RD9D159xX3BP5U/2MCCwEXjq8Vgj+2Twx/j\nysb+04L7oMQimBdDLFKBoTFI2QA9ZaSAg9KIvLU4lDG7LJNEw96+RjXegm6D1IvB9e6bwmn/AE0f\n8S76SvilJEcschGpDHteQOvKTZB6FWW9raOqpauJlPM6JroA4gNjdd3KPF+3YTwaPQrJqJ2saXPc\n1jRa7nODWi5sLkmw1IHnVNb6aqOSthdG9kgFOASxzXgHlJDYlpOtiEFs7M1DpKKlkeczn09O97tB\nmc6NrnGwFhcknRZBR3ZPF6duH0jXVEDS2lpg4GWMOBETAQQXXBB5lIWm4uNb8COCDlERBUW2mx9b\nNik08VOXxukhc1/KwNuGxxtd2rpQ4WLXcRzK3V5JsUgY8sdPC1wsCx0jA8E2Iu0uvqCPSvWgIuir\nrI4rGSRkd+Gd7WX8WYi68/17pvCaf9NH/Eg96Ly02JQyOyxzRPPeskY53oabr1ICIiAi+ZZA1pc4\nhoGpLiA0eMnQLxfXum8Jp/00f8SD3ovB9e6bwmn/AE0f8S9zHggEEEEXBBuCOojiEHKIiAiIg+ZH\nhrS5xAABJJ0AA1JJ5gAtRfqgN5rsTnMFO6RlJTuIDS7I2pma77bI0DNkaQMjDe1sxs42bdv1SO0/\nwTB3wMcRJWXhuNHRwf8ArPv97cWjB43kFuGmmOJVAIHHKNGtbx/0uTdY3tudQ1x195fTYWuHbOc8\n3+K0WbfxcT411xvBdkAseYdPiJ5/QvRRxZyxrYwy50JGZ/8AXiCsbZjYJpDZJ7m+oBt5uAWN8sUj\nt14uPbJPSCYfTvy52BwcDYgajxOaeIPX86yNVgcsxBEZBsLEXv8APxHjVvQYIwfFjB4XNgFkI8PL\nRwAtzcVxW5n2enT4Z13KlvsXlAs+M6i1wNRpofmXxLsrK+wLLm1i7vraXI763Or2hpL8bdemq+/r\nczvfHoqfjJbR8Np7qKZu9cQczrE8BY/SvDV7ByAaG9uGqvyehaek+Yf6rG1WFaXAt1EJ+Mutb4di\na/V+ys7Bq0nxa2WBrI3tsHAgtu3zf7H6VsVW4SSLW18yiuNbPNcCHsHjA/rVbY+b/U483w3X5ZU5\nR1ORwOhsb6i4PRpz+dWfu921hj0qZZ2Dtu0hhD4i06nPkrKd/VYEgcdSAoVtLs4+A3bfKb2IHDxr\nG0jHW0NuvLmPo4rvi0WjcPKvS1J8ZbW7AY/h9QSynkOc5QXHFMRw7MT0NlqpMzmgDtrHiACFeGzV\nhHYcrYWsZKgVPok5RzyPxtVpHut27mwiobJHIXNsQ+BxlZFITbUtFxmFhqtuN1u8WDFIA7lGtls0\nviyFgaSNQ1xkeJBfgbtP+EK1Z77Y3iU6REWrMREQEREBERBGN6dPnwmpHO0RvH5krHH9UOUb3DT3\nhq4+9khf+ka5v+Sp1tPTcrRVMff087R4zG4D57Kq9y9eIpay/AUvLHxQu19qg42L/v8AaR8nENmr\npfzf7xjPRnZ6FxtL/cbTNfwDqijf+bI2Nkh9PKLv3E0+arqJTrkgawnrleHen+5K+N+EJZXwyt0z\nQNsf8UUjzf0PZ6EGV39T9pSR986d/wAgRtHtCpXuyp+TwmlHSx0n6V7pB8zwq8321ofU0wHAUolH\n/wCV7v3RBW1gVNyVLBF+DhhZ8hjW/uQRPfZ3MHlEP0PVd7J7IVNdA90MkTY2yFjmSSSNu/IxxORk\nbmntXtFzrorE32dzB5RD9D159xX3BP5U/wBjAgj0W6ao556ceISH6WhYvc9UObisQaSBIyZrx0tE\nbngHxOY0q9VQu6HutTfiz+wkQXpWyFsT3Di1j3DxhpI+ha+7IYG7Eap0ZlyOLHzOke0yFxDmA37Y\nEkmS97rYWoizsc06BzXNNuNiLfvUW2R2FhoZzNHLM8mN0dpMmWzi037VgN+0HpQRT+yN/hjP0B/m\nqKfA30GLsibJmdDPTjlGgszB/JucLXNgWyFpF9RfpWwSovbf/wCoJPKKP9iBBbu2WEGsopadrgwy\nclZzgS0ZJWSaga8GEedUftls46gmZE+RshfGJLtBaAMzm215+1Ww6pzfn93Q+TD2siD4wzdhLPTx\nTCoiaJoo5ACxxIEjA4A2OpGZXFSR5Y2N45WtbfxAD9yx2x3c6j8lpfYsWVQEREFEbw+7s35Wk9jA\nr3VE7w+7s35Wk9jAr2QUJti11VjkkTn2L6mOma4jMI2l7Y22bcaDNmsLXJPTdST+yN/hjP0B/mqP\n7ZB9JjjpXsJDamKqYOAkYHtkGV1ulrm31sQehXLs7jkNZCJYH5hoHNOkkbu9e2+h+Y8QSNUFFbYY\nE7DqpsYlzuEbJmyMaYy0lzwLdsSCDHe9+dbA0EhdFG48XMY4+MtBP0qE7f7CSV9UJmTMjAhZHlc1\nxN2ukde4PDtx6FN6OLJGxh1ysY2/McoA/cg7UREFXb+ah1qSO5yu5d7m8znN5MNJ8Qe+34xWLwDd\no6ppYpxUtYJWB+Uwlxbfmvygv6FYW2WyEWIOiMskrOSEgbyeTXPlJvmae8HDpWXwTD201PFA0uc2\nJgYC62YgdNgBfzIKg2p3dOo6SSoNS2QR8n2giLSc8jI/jcobWz34cykm4mpcaaojJJbHIxzBzN5R\npzAdAJYDbpJPOVnt7Hcep/8A1/8A+iJRvcN9rq/x4P2XoLNREQEReTGa5tPTzTv+LDFJK7psxpcb\ndZtZJGrH1Vu0/wALxMUkTgYqNmWS1rGck8rd3QwZGa8CHqnnMbYEMzG3aknTxgcAPp6V6to6vlaq\nR0nbF8j3lt9M7nZjm01sSvfRwmSzTl1tew1AvoB0D5yuK15iNu3HT2STdHgYe90zwCW2tfgCf65l\nbUFF5/66FHt3FAGRcOOp0t4raqbQRFutl5PIyTaz6Di0itdOmGkJ4D5v9l6BRAcbAi2lwXei9/mX\nY52mpH7l9Mtppx/r9ywdrrbRtBOo1830hffwZtvjAen/AEXY09AHHgux8Rte/DiOf0cVA8T6ZvT8\nzv8AReWWIdNvGD+5e2U21+mwWOqZxzuHjsfRwTtMPJU0wJ0sfFY/MsNiNBfTKPmWWfKC74wPRxH0\nhdUo4c45jzK6LK72twYOgeLAnj/oqmlpnRuOUuHiP7lsbiVIHtcOkG3+niVU7TYLkeTa3HXqHOu7\ni5vHqXj/ABDB5fVCHR11vtjWm3G7SD4zlsfOVKt122k+G17Jqd12OIEkbjmY5hOoIJ0PXcehRKvZ\nZxbfrB5x4jzhdFLMWu4jQ2JsAfmXo+24eNPrqX6N4JiDKinimjILZGNcCCCNRqLg20NwvYqY+pSx\nIyYY+IuJDHucGmxaCT22U8QCbacPOTe51vWdxtz2jU6ERFZAiIgIiIBC12wib4LLWx9NNW0vnJDP\npYtiVrxt3ByeJ1jemZ7/ADS2l/70E/3D01qeql7+Zkf6Nmb/AD117+aa8VJL3r5o/wBI1rh7ErOb\nnafJhUbvwkk7z5nmMfNGF1756bPhbnfgpoH+kmL/ADkFXYlL8Kq6OPjeHDaY9ZLIwfnkK2FWvm7y\nDlMVpGnW0gf+hY6QezC2DQQffZ3MHlEP0PXn3FfcE/lT/YwL0b7O5g8oh+h68+4r7gn8qf7GBBYC\noXdD3WpvxZ/YSK+lQu6HutTfiz+wkQXfjNXyNNNNa/JRSyW6eTYXW8+VUng1VieIzvEVXNmDc7gK\nh8EYFwO1awho1I0AVxbY9zqzyWq9i9VnuL+7Z/J/8xiD7+xTG/CpfXpv4lFKqmmixNsdS4vlbPTC\nRznmQkkxlt3u1d2haNei3MtiVRe2/wD9QSeUUf7ECC9FTm/P7uh8mHtZFcapzfn93Q+TD2siCztj\nu51H5LS+xYsqsVsd3Oo/JaX2LFlUBERBRO8Pu7N+VpPYwK9lRO8Pu7N+VpPYwK9kGL2lwGGth5Kd\nt7XLHjSSNx52OtpzaG4NtQVTmKYbWYNVCRjjlJsyZoPIzN45JW30NhfITzXadLiZzbwpW4n8D5CP\nL8LZT587s2V0ojzWta9jeyntfRsmjdFKxr2PFnNcLgj9xBsQRqCAQgwGxG2MNezLpHM0XfCTxHO6\nM/fs+cc/MTJlQO3WEfW3EA2CR4s1k8Tv/UjJc8AZvvrGM684NjfUm+KCYvijedC9jHEc13NB/eg7\nkREFbb5Nop4HwwQSOiD2Okkew5ZD22VoDhq0Czibam48+DoNnsZlijlZVTZZWMkZeumByvaHNuM2\nhsQu3fr92U/5A+0crK2N7m0XklJ7FiCptpdn8UhpZJKmokfE3Jna6rllabva1t2ONnWeWnqtfmUi\n3Dfa6v8AHg/ZepJvY7j1P/6//wDREo3uG+11f48H7L0FmoiICr36oXFzS4DO4XvK+GIEc13Zz5iI\ny385WEqc+qzlaMHhaQTeqDmjmLmwzAX+XfzKmT8srU9YalxDM4vN+2cdba6n0qX7L0Be8ZRcXGvO\nfGozTvvlBBda5069VZW7nDXSEG2VuhPTp0BcHItqr0ePXcrI2VpiGAm40tb6SsrNPY24nh1f7oxz\nY2ixHDnPVzlYmavaX2Lhpzjm8y8me3vY4097y5xAvbz2sfMuxlBfn16VgZNqqWF13vcbaGwB9Guq\nzeD7YUkxs3M3vXPbYu8VirRj2tOWIdr6Nw4X/wBUbDzFSEsa6O7TmvzjgvLLQkC484Uzin2a0yVl\nihS83MF8y0XV6Vkq57mt0A+j+hxURxRlS7Rj3gXPAajo5uCp4xCLW325rw1pIuNPMF4RLY2vx/ri\nsPJg9c8kx8o6x4PaQPTmHzLpqaGsaAHwSi1tWkOb6NP66VZjOT9EiDri2mvTwWE2nwgSx2001H/K\n8ja+VhGdtgOIcC13o5j41m6SoErbi2nMpjr0ROrdSonaeiDHubY2B06v9lH3xc6t3eThN28qxvN2\nw6VWVm3sRo48edpXr4MnlV4HJw+F2zX1Gda11NWRG2djon3sA4teC03I1cAWc+mq2EWsP1G1m1lW\nxxs7kGFunxm59deq7dP91s8uuno4b+oiIrqCIiAiIgKjd8dPkxV7vwsUEnoaYv8AJV5LB7Q7J0tZ\nIJKiMvc1gYCJJGdqC5wFmOAOrnelB2bEU/J4bSNtY/B4SR0Oe0Pd+s4rr2/p+Uwurb0QSPHjiHKD\n52BZqKMNaGgWDQAB0ACw+ZcVEQexzHC7Xtc1w6Q4WI9BQUpuXp82KZvwcEz/ADksj+iUq7lhNntl\naWje59PGWOe3I4mR7+1ve3buNtQFm0EH32dzB5RD9D159xX3BP5U/wBjApljmEQ1cXJVDM7Mwflz\nPZ2wvY3jcDznnXxgOCQUcbo6ePk2ueXuGd77uLWtveRziNGN04aIMiqF3Q91qb8Wf2EivpR/BtjK\nKmmbNBAWPYHBruVnfbM0tPavkLT2pI1CD27WtJw+sAFyaWqAA4kmJ9lS+7jaOKgqJJJWyPD4sgEQ\nYTfM12ud7RazVfai0273DnPLjT2uSS1sszGeZrZAGjqFggwr97FNzU9QfHyQ+iQqvsUxRtViwqGt\nLBLPTENdYuGXkma204sJ86uSk2KoI+FJEfygMvtS5fEuw9A6blfgwDg5jhkkljYCy2W0bJBGB2o0\nAt6UEjVPb9GH4bAbaGnsDzEtkeT6MzfSFcKx+N4LBVsDKiJsgBu29w5pPHK9pDm36iggGB7zaeCl\nghdDUEwwwxuLRFlJjja0kXkva7TxVmU8mZjXD75rXC/HUX/eoud3eG+DH9PU/wA5SmJga0NGgaAA\nOoCw4oPpERBRO8Pu7N+VpPYwK9lgMR2Oop6h1RLCXSOLHF/KzNuWBrW9q2QN0DG83Ms+goHaCfkM\ndkleHWirmTOAAzljZWy9qCQLllrXI4hT/wDtXo/wNX8iD/3CkuObK0lW/PPA17rAZw58byBwzOjc\n0ut13WP/ALO8N8GP6ep/nIKo3jY/HXVYnibIxohZGRKGh12ukcT2j3C1njn6VfGEsLaeJpFiIogR\nzghgBWFoNhqCKRsjKZuZpBbnklkAI1ByySObcHW9lI0BERBUG/Vp+F055jA4A81xIb/tD0rI4FvM\npoKSnhMNS50UEETiGxZC6ONrSWkzXy3abXAU8x/AqesYGVEQkDSS03c17SeOV7CHAGwuL2NhfgsR\nDu9w5pv8Gv8AjSzuHoMlvmQQvbTeFDV0UtOyGVpk5KznlmUZJWSG4a4nUMI86yG4b7XV/jwfsvUw\nm2PoXRmM0kIDrXLG5JNCHC0rLSDVo4O14cCV6dn9n6ejDxTR8mJC0v7eR9y24H2x7rcTwQZRERAV\nOfVZQ/8Ak8Mlr5KkN6gHxSG/Wbxi3jVxqofqs3H6wgAfGqo9bXsBFMfNrYLPL+VanrDVDC23I0vr\noP68yv7d1Q5KYPIN3BoF+jnsqF2cjPLtv0t0WzGCxWp42ga5B6SF5fMn2e38Pj3YTHcSJJa0XAdY\nkC7iehq6cP2YnqTo/kI73eeMp6s3AX6uHSpFQYYI+2eNbucSee/T5uheLGNqhDkDLkvvybWAOleB\n+DYdA0DXM6wXFWnenozaNdvk7vKRou7lHnnJcAB12DbLth2ZpYxpmGvEkHXmVb4tvCrXOgyRtDKn\nlzGX1ojcGxfG5cNe1kB0Ng7jzdC9sWO1LY4ZHuAEzQ5rXymQ2PC5eA5vHjqFvbBeO5Z48+O8+NVp\n4YBFoCSNBx6PmBWYqKjQ24W0KhWA4mTE0SCz9bg83RrwII1BGhBC9dfihFmgcAue30+jrrTbNS1Q\nJHC/jXDalocAbD5goi7FSCSetYbH9pLDP23xQ3K1pc57yerg0C1yfNclXpG4/VW1NLFmxeFtwZOo\n5WucD6AvMMagedJQPxw5g9LmgKq8drg+licJqwds/lo6ZzYpQCx3JFl47uY2QDNfXossLsLncIOV\nr6gOy1BquWjvA0tIEDYuULnSl99RYWANiumvG3G9w5LcqKW8fGVuYxSQTCzxc98CNfOOPzqJOovg\n9TlbmySaNd16WBt5wvFS4y5kmQtcztiA4NdyMnQWtPbRnqPzqTNlzsF9ecHifov6Fz26nt1Rq3cM\nXtJS8pTSN/wkj0X/AHKhcUGWXovr57rYmrjuxw6jx8S1/wBqGZZHjoe7r5yF1cO3cw8z4jXqJbLf\nUl4c19PJVub27CYGu6W/HIPWM9vFbz32qZ+pCjIwIuItnnkc13fNHaekOa8K5l61Y1DwrTuRERWV\nEREBERARdNXVxxAGSRkYJsC9zWAnjYFxFzYFeb6903hNP+mj/iQe9F4Pr3TeE0/6aP8AiXbTYnDI\n7LHNE896yRjnadQN0HqREQEREBERAREQEREBERAREQERfE8rWNc97g1rQXOc4hrWtaLuLnHQAAEk\nlB9ovDQYzTzOyQ1EErgC4timjkcGggE5WuJtdzRfrC9yAiLxzYtAxxa6eFrhoWulYHA9YLrhB7EX\ng+vdN4TT/po/4k+vdN4TT/po/wCJB70XxBK17Q5jg4Hg5pDmnxEaFcyyBrS5xDQ0Euc4gNAGpJJ0\nAA50H0i8tJiMMjssc0UhAuWskY51rgXs0k2uRr1hepAReOoxWBji188LHDi10rGuHjBdcL4+vdN4\nTT/po/4kHvReSmxOCR2Vk8L3Hg1kjHOPmBuvWgKD79cJFTgNYDpyMfwkG2v9weUcB0ZmNc3zqcKA\nb39paaKmfSStnl5QNMrIGxuIjuHFrzI9oGYDgLmx5r655bRFZ20xY73tqkTM/o1N2Up71Udha72+\nkaf6rY6haAGf4QPmVC7DQXq4rg25TxH+tFfTzZeLyrd9PoOFSYidvLtJUktLG3JcCOnQ9PUo9g+y\nkrZ/hAnPKkEZnEEBunahpaWhotwtzLL1VQQ69r/6dS6JMRkt2rbdGv7h+9YY7anbtnFNo8YhHdoN\n3tOXumkcC9zszg08mzMbk9q0NaLnXgBxWBqMIL5h/wCo1th29yQBp2vMABzKVVMcj3kvvboK76WC\nws1vo1Wtssyvi4fj66h0YRBl0AsGizegDq6Au+qcOfzrImABoFtTzc/oXzJhOZt7Hn/rxrl3uXdS\nIYN5DswFj4lhpIixztD5uZSGbCzG4Obc9INr+JdUDmTFwFmube7XaO81+KvXfsreseksdhk7Wnt2\ng9Rbx8//AApVhk9I5uUstc3y3dkJ6x98o8KQX5+i9ri6748PHR6FtGTXcMLcfcMviuGREXDBqNAA\nc3V134LHYczI4s1tzX5gvqCnezhI7xO1+lfRzEnNr1ql++2fy7U6fdWB9N1Q22MIE8wvpnJ05rkq\n9ZBpb51TG0tG6TEZImi5kflI/f6Fvw51Zwc2k2pER92yP1H9aHbPCEhwMFTUjUHK5sjuUBYecZnO\nB6COvW5VqTu8r58I5KSOaa2ZmaMEmncDxa+Muy2JzAOAuCbiy2zgkDmtcODgHDxEXH0r18OWL+jy\nObwMnG8Zv7/5p9oiLZwCIiAiIgrzft9xU/lI9lKoRslsPNXQGaOSJgEjo7Pz5rta11+1aRbtwpvv\n2+4qfykeylXo3H9zpPKZfZwoIx/ZPU/h6f8A6n8tRTaXB5KCqETntL2NZI18RcMpNy0tJAIcC291\nsaqP3z91HfkIf+5Bc+FTF8ET3cXxxuPRdzQT85XpXiwH7kp/yEPs2r2oCIiAiIgIiICIsdtLiRpq\nSaoDc5iZmyk5Q7UC17G3HoQZFFEd322DsQdODCIuRER0kL82cvHOxtrZPnUuQEREBRnelVcnhNSe\nd7WRDr5R7WO/ULj5lJlXe/WqtSQRX1knL/G2Njgf1pWHzBBCt1FVyeLQcwkEsZ/Ojc5v67GK+Vrv\nHF8Dq6GUmwLaGr/Ne4Od5rNd6VsQgLX3byLNi9S0Wu6cNF+F3Bo19K2CVBbY925vKo/pYgzf9k9T\n+Hp/+p/AvJjO7aop6eWd0sBbExzyG8pmIaL6XZa6u1YPb/uXWfkJf2UEA3E1ThPUQ3OQxtky8weH\nBtwOYlrrHpyt6ArD237mVvktT7JyrbcX92z+T/5jFZO23cyt8lqfZOQVhuN7pS+SS+2gVp7XVToq\nCqkYcrmQTOa7na4MNiOsHXzKrNx3dGXySX20CszbzuZWeTzfslBSOyWzslfM+ON7GuawyOdJm17Z\nrTqASXXffVSf+yep/D0//U/lrjcZ93TeTH2sauNBrptVgMmH1DYnvaX5GTNfEXDLd72tsSAQ4GMm\n46lfezVS6WippX6ukp6eRx6XPja53zkqpt+HdJnksPtZ1aexnc2i8kpPYsQZZVJt83LjEjZDnilg\nicYyG2a4h0fautnA7RpIvbUq21Tm9AObjVzwkpYyz81xv87T6VzcqN1j93t/AI3yZj/TKJ4vs+yK\ntpZ4m5WOdkNgAM5Olx/ophWxWNuoLGSxf3THODj/AHkRDb6Cx0NukaqQ4jDwOmoFl4943D282Pwy\nfujssOvAmw83iXzFBznXoAFrf7rLxw3K9cdCOe3i/wBj+5UrWZdNclax2jUtIT13TDSWOcLDRpPD\n0fuWXrWBjSejxf1wXlgDeTLzcXFgTxt0qPdre1ZqxmJ4hS0MDqutky8w0LnkngGtALifEvnYvbqm\nr4pfg/KOa117yROYb8O1J0d5ibKPbT4pS3y1YjnaL5GOaT1agaAXsuzZvaSgyiGMNhPxRkADR1AW\nACR1X07Z3rHnvfX2/wAl6t4e2EVGyMuikebntY23OvO93Bo5l4sBxuCvi5RkUkD+JZK2zvGCBYt6\n19bY4rTQxuaQJnEcSRp4udQvCNrQJLPddnAd8BzAu4kaKfHdfTtEXrF9zPX2WDSQOEobbtHatPMC\neKzRw5zTosdhWJxzwtyOBtwIOoI6Qszg+JB393Jo9tvE4dI6VXWmkZPZ4pacnSy8wiN7aqXR0IcL\n9P8AWixFfSZD02VtTCl8lbdMJLHb+tVE6fBP/M5agjtWR3Fhe73i3zAEqa1Xxeg/OsDSOJqyc2jc\nt2cAbjj1q1JmJ6c1KRbJES8+O6wv1HCG1hYjtwNRc2WzmEMy08LeiKIehgC1j2o7aeJg+LNJCzTh\nq8D962lY0AADgAAPEF6vD93B/wDRz9OOv+6f+nKIi7Xy4iIgIiIK837fcVP5SPZSr0bj+50nlMvs\n4V59+33FT+Uj2Uq+9zlQ2LCZ5HnK2Oed73WJs1kUTnGw1NgDwQWAqP3z91HfkIf+5WF/aPh34Z/6\nCb+BVdvLxaKrrjNA4uZyUbblrmm7c19HAHnCC8sB+5Kf8hD7Nq9q8eBC1LAD+Bh/Yaq33ubU1ENW\n2ngldC1sbHvLNHuc4u4u4hoa0aC2pN76WC1EVMCgx7pq/WI/5q8WL1OL0jWyTy1MTS4NaXTNcC6x\ndazXnmaTqLaIL0RR7d5jD6vD4pZbF93seQAA4scQHWGgJblJtpe9rcFg98G0U9KyCOB3JmblS6QA\nZw2PIMrbg2uZL3Gva9aCeoqSoIsbmjbLG+qex4zNcJ2AEHnsZAfSurFpcYpo+VnkqY25g3MZmuGY\n3sLNeTzHmQXko/vH7lVf5I/SF5d1+OSVlDnmOZ8cr4nPsBns1jwSALA5ZANOhQTb6LEuVqyfhPwb\nO/i/+55K+na5vi8OZB79wv2ys/FpfpmVrLXbZWOuJk+A8tezOV5F2XTtsmbUX+/t51a+6+OtDJ/h\n3LXzR8nyzsxtZ2bLqeeyCZIiICp7fpVF1ZBENeTgLgP8UryLeO0LfSFcKpXaQ/CdpAziBU0sdv8A\nDEI+UHpbKg7t9GGCJ1Fbh8GMHmgLbe2KtXZyr5ajp5eeSGF58bmAu+e6hm/OmvRQyW+1zhp6mvjf\nf9ZjFld0dVymEwi9zG6aM+aRzm/qPYglqoLbHu3N5VH9LFfqoLbHu3N5VH9LEF+rB7f9y6z8hL+y\ns4sHt/3LrPyEv7KCutxf3bP5P/mMVk7bdzK3yWp9k5VtuL+7Z/J/8xisnbbuZW+S1PsnIKw3Hd0Z\nfJJfbQK2cfoPhFLNBmycrG+PPlzZcwtfLcXtfhcKptx3dGXySX20CudBDdhNhzh875fhHLZ4zHl5\nHk7Xc1178q6/xbWtzqZIozvE2lFDSktI5WW7IRobH755B4tYCD1ktHOgrXfLWMkxM5HB3JQxxPtw\nDw+R5F+ewkbfoNxxBVv7MU7o6GljeLOjp6djh0ObE1pHpBVT7p9mzVVJqpgXRwvzdtc8rP8AGFyf\njBtw834kt43KulAUC3w4RykUFSB20ErWuI/BynLr4pCwfnFT1eTGKIT08sJ/9Rjm36CR2p8YdY+Z\nZ5aeVZh1cLkTgzVyR7T/AB7/AMKCqsfD+UiBALBoD1c/SpyHZoYjw7Uf1qop9a4Ty0hjAmtycjTo\nY3tJDgOAsXAqVUrb08Y6APQvGtvepfZcu1LXrNfR15bG/p6l7pH3YSBw6RbmXjyaaeYDguawuEJt\nqbcOZZeXjDK0b0rDbnbBkdQW3NmWzDmc61w3xA2uofiu8N8rS1vajmA/eViNoIHT1T7ng6UuJ++d\ncnh02HzL14Dg9Pnjie5vKSE5Yr3leP8AC0akWB16lFdfvKbZLb9YiEWqWyyuLrucdT5vGvdg2Byu\ne12tyRa1r8Ra+unjVx4Ru+zhjWwvbnBcxziGNIHWbnntwWfwvdwY4zJGxpOtw+QudpzgNZYDzraI\ntLLyw1t9d4/urfGtmJXRXcASBx59OHE6j0qvcawmSNxAaR0Aen0akrZhuykpYMxY0C2gDncSOJdb\np6F01+xTOWMWdubk+VcHMbmte17X+Lc8Uik173/CMufjz9MWa0Ybic9P8UuF/GFncP22naWuJJLD\ncdfDQ+MKaba00FLAJamFnJuc9t4wOVAaR2xaLCxuOe6hFZhcbo+VgdnjdqHWLS3ho4dNiotO43Md\nfdWJ11S22wmwuOtqqWOZhuHjUc4cNHAjmsQQvrFGkuI/5UM+p9jLaao1uzlrs6NWNzea4v5ypjWy\nXfm5rG5672WU/Zr77YOrOuvFQjHq2SJ0wjaXFwZYN46X1txOjuZTjFHW5+Jt8yw2FOj+ETFwDnBr\nQ0noN73+ZTT1X34zEvTudwV9bW0pmHa07vhLgeI5MjIOjWUx+YOWyKgW5nBDDTSVDxZ1S4ZB0Qx3\nDPlOc93WC1T1e3x6eNHzfxflfPzzr0jqP/f5ERFu8sREQEREFeb9vuKn8pHspV27lYw7DJWuFw6o\nma4HgQYogQfMV1b9vuKn8pHspV6Nx/c6TymX2cKCrpMLZDiJpqguEbJ+Se5pDXiMus19y0gdq5r+\nHBWvhu7KiieHu5aaxBDJntMdxwu2ONuYdRuDz3UT34YVkqoqgDSdhY/8pFYAk9Jjc0f/AIyrD2Ax\nX4Vh0EhN3BvJydPKR9oSet1g/wDOCDPKjd9HdN/5CH6HK8lR2+Yf+aO/Iw/9yC7oPit8Q+hQDfr9\nwweUt9jKo43eZXgAchTaf/Zn/nrE7V7WVVfEyKaKNoY8SAxRStdmDXN1L5HC1nnm6EFkbmu5TPys\n/wC2o9v7ac1Eea1UL817wKUbpqR8WFxiRhYXOleA4WOVzrtNuIuNdVmto8EhrIDDM24vdrho9jwC\nA5h5iLnjcG5BBCDFbsK2OTDKdrHtcYmBkjQe2Y4X0cOI6QefmXTvXw6WooOThjdI7lonZW2vYB1z\nqesKtcVwyswaqEjHHKTZkzQeRlbxySsvoSBfITzXadLi0NiNsYa9mXSOZou+Enj0ujP37PnHPzEh\n490GGTU1FKyeN0TjUveGutctMULQdDwu1w8yye8fuVV/kj9IUgUf3j9yqv8AJH6QghO4X7ZWfi0v\n0zK1lVO4X7ZWfi0v0zK1kBERAJVJbtf/ABOO8v8A4qupP5+Zo+edvoVs7XVfI0FVIDYtgmy/jFhD\nP1i1VnuOaxtRUyvc1uWKONuZwbflHFxtc6/aW/MgnO9Om5TCam3FgjkHVycjHO/UDlHNw9VeCqh7\nyWOX9Iws/wAhTTHZoZqWeLlYv72GaP7Yz79jm9PWqu3HVeWvkjPCWncfG5j2EfqukQXOtfdvJMuL\n1Lh97OHC/C7Q06+hbBKgdsxfGpgdb1MYIPAi7OKDOf2sVP4Cn/6n8a8mM7yZ6inlgdDA1srHMJbn\nzAOFtLvtdW79Y6bwan/Qx/wp9Y6bwan/AEMf8KCtNxNK4z1E1jkEbY83MXlwdYHnIa256MzekKw9\ntu5lb5LU+ycsrBE1jQ1jQ0Dg1oDWjxAaBYrbbuZW+S1PsnIKw3Hd0ZfJJfbQK51TG47ujL5JL7aB\nXOgKg9pamTEcXLMwGab4NDf4rI2vLQbfKeeskdCvxUDs33ci8td7RyC8sEw2Omp44IhZsbbDpJ4u\nc7pc5xLj1lexEQEREEB3iYG4yCWKNzg8DO2KNz3OkFxdwYDbtcuvUV4KLM2nja5rmuHauDhlykaE\nEHUHTgVZqhNc4NmqYzwEuYAWGsoD7cbk9sTfSwI4rg5GCInyj3e1wuba2sc+3owsrrG17dBPDU6L\n7fwtwvoT/X0rrqngOGnzheSapINgbc3i6LLzrae7EbVTtZhAhrDcaOeS3hwdrY8/pXb9gYZUQ4hA\nXiZhbJe92kjg0tP3ttNLKXbeUscgjk0zXbrzX61kcLcOSa24NtNOGi5sd5paZha9a2iNxuPtKM4t\nXYpO1obU/BcrnODoIrO15nOc4gjjwaObnF1g5tma+RuWTFcRlaSTkNXUlhJ1PaumLeJPMpzimI8g\ndW3B5+vjb0LDO2zaHZcvHnPMOfoXVHMiDHx8X9EIr/ZzK5tjPUajW7nEEdBDjYrvwzY2ajcXQSzR\nOe0sc9srmFzCbkEMIuL66rPVu2ti1rGi1tTx15/+F0uxmSYhrb2J4/8APBVtzNNpxU1rxh4Jdlfh\nBYKyV84jHase4ubbTjzngNTdcYrgwaOSiaGtcWgZQBa2mmnBSqmju0XNso15+HFfDcr6iPW2U305\n+iyxyZLXYxSN9M1s7hrKOjZAwC9ruIHAk385Xc91h6V8Xe55ItlA431J8Vui66q2rDW2AuTp1C3H\nVWr6I8dsTih7ax5ucrx7L7N1NY+YwwkjO1pkL2Nja4anNc34OHxQV5tocQsCR08em+h9CtjcRQuj\nwvlHE/38r5B4gAy/HiS0+hdXFx+d+/Rx8/kzgpE19f1TXBqPkaaGG+bkooo79ORobfz2XqRF7b5S\nZ3OxERECIiAiIgrzft9xU/lI9lKvRuP7nSeUy+zhXn37fcVP5SPZSr0bj+50nlMvs4UGT3pYX8Iw\nyawu6G07PHHfPbpJiMgt0kKHbjMVyyz0pOjwJo+jM2zJPOWmM+KMq2HC4sdQdCDwIWv4vhmMc9qa\no8ZMDv3mCT0lBsCqN30d03/kIfocrxa4EAg3B1BHAjqVH76O6j/yEP0OQXdB8VviH0L4q6uOIAyS\nMjBNgXuawE8bAuI1sD6FjYdpqINH/jaTgP8A/TD0fjqEb5cWp56OFsNRBMRUBxbFLHI4N5KUXIa4\nkC5Av1hBZVLUMkbmje17dRmY4ObccdWmyxO021NPQmMTl4MgeW5WF2jMoN7cPjBYfc13KZ+Vn/bU\nb39fbaP8Sp+mJBY8D4a2kDi0SRTsvle3i08Lg6g3F+kEAqodvNj34c9tRTyO5LOMjs1p4X6louNX\nDQ2eNeY9Lp7sLj9JHhtKySrpmObE0OY+eJr2nXRzS64PUVit7mM002H5IamCV3LRHLHNG99gHXOV\nribajVBIN2mPPraHlJbcpHI6F7gAA8taxwdYaAlsjb20uDaw0HdvH7lVf5I/SFgNxfc+byuT2FOs\n/vG7lVf5I/SEEJ3C/bKz8Wl+mZWsqd3MYpBTvqjPNHDnbT5eUe1mbKZb2zHW2YelWthmKQ1AcYJo\n5Q0gOMb2vDSeF7HTgUHsREQQ3fJVZMKe38NLDGPM7lT80JVZ7L7EVFdCZonQNaHuj/vXPa4loaSQ\nGxOGXtgOPEFS/fzVdrSQ9LppT+aGsb7R/oUn3VU3J4TT34vEkh688ji39TIgr7+ymt/CUf6Sb/26\nxmxWalxuFjyLsqJKd9icpc7PBpcAluZwIuBzK/FQ28QGnxqaRo+LJBUN6zljef1w5BfKoLbHu3N5\nVH9LFfkbgQCNQQCD0g6hUHtj3bm8qj+liC/UREBYfbbuZW+S1PsnLMLD7bdzK3yWp9k5BWG47ujL\n5JL7aBXOqY3Hd0ZfJJfbQK50BVxhe7qWLEGVRnjIbOZsgY7MQXF1r3tfVWOq9w7ec2Wpjg+Cubyk\n0cOblQQM7wy9smtr3sgsJERAREQFFNuYyxzZgLgjI4W101HjuNPMpWvBj9Dy9PJHzlpLDexDxq3X\nmBOh6iVnlr5VmGuDJ8u8WVU+XO4uLuF/vToLk2FyQebmXVa5LxwI5/8AQcVE9o66SKbJqwMfkflz\nkmRuhabXbof64Lzt2oGQjMbNuBpz3tcd9Y31614d4nfb7KmSPHpldpagOjLb249tlsQAOA61FcHx\n98bw3MXWIAB6/R8wXh2kxV+oaRYm9+IIHDjzXGvWFEGVRzXuSSTrzn/RYxj8vVPzYjpbGK4zHMwh\n3EZjpwBtp16Kssfrspswkm+p8WnR4/QurD6h5do4m/G19SOherEcPNnEi97WPP5vQopiitty1id1\n+kwasltmd217XGnDjzcFK8JxxrdDpxOUHUW6DzgKvYA5jrE6G2nDX9yyE9UWx8dL+cHxq+TFEyrW\n8RVOKnaTM0hpsbAgk3vbXmtouqm2maXNy3Bv21uHNe/SOtVq6s0OvMOdfOH1mSQE9I466fT/AMK8\nYHPPIrC95MXDI2EP0eHE3It2oub9VisbiGMtc0vzHKOAGoI4ei6g9HWCRjQHOFsx+Np2x5+i4HRq\nvHidcX5GglrGC3WS254eMJWi/wA6IjaUOlMz2QtBc7MGgD76STgA3jwcAtpdmcO+DUcEGn91FGw2\nvYuDRmOupubnVUF9TxssaqqdVzBxjgN23HaOnuLDXnaAHacNOlbHL1OHj8a+X3fO/E8/neKx7CIi\n7XliIiAiIgIiII7t5sz9cIY4uW5HJJymbk+Uv2jm2tnbb49735l2bDbO/AKZ0PK8tmldJm5Pk7Zm\nsbbLnd3nG/Os8iAoVtxsCK6oE7Z+RPJtY4cjygdlJIdflW2NnW5+AU1RB4cAonQUsML5OVMTGx8p\nlyZg3Rva5nWIaGjib2vzqP7c7DR18jZRKYZGtDC7IJGOYCSMzMzTcFztQefW9haXIgqz+yI+HD1X\n/wCSuW7otda3TntTWPmPwg29CtJEHg2fwmOkpo6eK+WMHV2rnFxLnOcQLXLiTpp0aLG7bbKx4hGx\nr3OjfGXGORoDrZrZg5p+M05WniDdo14gyFEFWf2RHw4eq/8AyUG6I+Gj1b/5CtNEGK2WwKOipmwR\nXIuXOe62Z73WuTbQaBoA6GjjxXuxGjZNDJFILtkY5jhwOVwsbHmOvHmXeiCr5t0YzHLWkDmDqcOc\nB1uEzQT4gFKdgdlPrcyZvLctyrmOvyfJ5coI/COve/UpOiAiIghe3WwzsQqGS/CeSDIhGGcjymoc\n9xdm5ZvHMBa33qlWD0Qgp4YQbiGKKMOtbNkaG3tc2va/nXqRAUJ242B+H1InFQIbRMjLeR5S5a55\nzZuVbbR4FrfeqbIg82E0xip4onOzmOOOMvtlzljQ0uy3Nr2va54qEYzu4M9c+q+FBueVsnJ8hmtb\nLpn5cX+LxtzqwEQEREBePHKHl6aaDNk5aKWLNbNlztLb5bi9r3tcL2IghewuwhoKl03wkTZonRZe\nR5O2Z8b75uVdf7Xa1ufqU0REBVxhm7AxVUU/wwO5OeObJ8HtmySB+XNy5te1r2PiVjogIiICIiAi\nIgo76oTBBHKyqa0hszbSFjdBK0/HeGi/bNcAXHvQqpdVtaNQGga5mAsBNuJyi7iOvpW1e2FI2WIM\neAWvD2m/+ID/AEWsu3GyUtHI45SWXc5rhr2vG1x0dBXjcquss/Z9DwMm8MfdF8Qq3OzdBsA4jtje\n9+YAanisPEG3IBNw519CAGjo891k5wDGbtc3XMBlIJvc3vdYN1WGvJtcc99Tc3GvpPoVIpvem3n4\n9yy1JMGFpFxrrrYW+lemqrwQbHiDx1FuPmUVZiAzEXOjb69I1t5+Kx1bixD7DhrY8VP4eZlaObFY\nZqeotfhc8Ofx3XZPUBzPj6kgcLN4fTzKLSV7ib9HHmHSuz65E5dNAWk9fjW04WP4yJ2yNbJoGjnF\nz1W/4Rl7ajXTx68PFosfy5L5Dbja3i428a98MoA/xHXrsRbUcy0iunL8zysz9HUZGtINrjttONtO\nB0J1NgstgeGvqZQ1jCRe+o5+e54cRwHQsFhtO+oc2OMG4+Mb9qDp/toP3K7N3+DNgMDAAXGSIPdz\nkucAbc9tVjbUf3dcTMx/wvbY3A2UNFFTxtAytaX2++kIGd3nIWYRF60Rrp85M7nciIilAiIgIiIC\nIiAiIgIiICIiAiIgIiICIiAiIgIiICIiAiIgIiICIiAiIgIiICIiAiIgIiICIiAiLC1u1VHHUOpn\nVDDMxoc+JmaSSNp+KZBGDyWbmz2vzXUTMR3KYiZnUPTjw7Rv437ioZtDhrJ2OjeL5um2lujnBWad\njXwi9m5Wg9rf454i5toPEPSvLU666X6+C8vPet7bj0e1xMdqV1ZR+1OxDyS1hBHEtcTmIaON2gnj\n126VVe0uEFt8wcDcADj/AMrbGqhzA6cb3HG/j6lX212yIqAS1oabW0sDb5WULnrM1np2WrExO2uM\nzQDcttYOaPNa2vTa4WOFMAe2N72sBx/qytTG9iy0kZLWJ4ktubcxcbFYQ7CykDtRe979sdObXKuu\nuWNduK/HnfSAyw69QHBc07bOGgsOOlxdT2r2IexovcnoDR8+vzrqoNiZJJMt9Ba+X43HpPE+K6tG\nan3Z/h7/AGRIRaki5PHRZ/ZPZ6apkGUXF7OJBsBz6qc7N7uzmBdbKD8U834w0vw4fRwVj0GEMp4w\n2NoFujTx6DRZWzR7N6cf7sFsxs+2ABrQTqCSdNbanr4KZYGzLUU46Z4PaNXmpqbUm5PVfReqB4bN\nE4/eywu8zZGk/MFzeX1R+7tmmqTH6SutERe8+VEREBERAREQEREBERAREQEREBERAREQEREBERAR\nEQEREBERAREQEREBERAREQEREBERARYvaTaKkoIuVrKmGmZzOmkazMehgJu93U0EqlNtPqn6GHM3\nD6eWrdzTS3p6bxhrgZ326CxnjU6F/qvN4O+LC8MbI11QyonYHWpadwkfnH3sr23jg1tfOc1uDXcF\nqTt9vkxXE8zZqp0UTr/+GprwQW6HZXGSVp6JHPCrxs2qnSF07V/VF4tVtkjjdFRMfmA+DNPLhh5u\nXe4uDrffxhh6LL63B48DUzwvJL5rShzjdzyNH3J1Ltb+cqki9ZDA8TfTzxzxGz4ntc09Y5j1EXB8\nayz4/mUmjbj5flZIs3xwUAM8YXolKhm67a6PEKJksZANrSMvqx/OD+7qUrfJcrwtTSPGfWH0NdWn\nyh8zWOi8UzNV6ZX/APK6XAjW1+sKYlpNemKxHDmSfGa11j2psMwPUfMsYzAmB1+PjFvRlIs7rUmy\nghcOh6/nVtM43DBjAow0/GcTzPeCB4yGi/DnuV00WEMZfKADe9gTlB6rjVZ8xeP6f3r5cwBW0ids\nWYcvHj515pAXXGn+nTdZGePTm69NF0Fg6FSW1IfMTdAvJibe1WRAsFjK8E9qFjaVt9utu3eJU7AI\nHwzZOEVU1xa5o+9E0ZEjHdDnZwOhTDdfveo8Vcad4NFWM0ko53tJcRxNPLo2dvma7nLQNVAqumAB\nJ0ABNzwtzrWLbvE2zYhPIyxaX2B5iG6X9IXpfD897zNbdw8f4jgx0jyr1O36Qovzq2Q3g4jQTMmp\nq2dhZazHSPkp3tH3skDncm9hHVcXuCDqtpt1H1RNFXllPXgYfUOs0Pc69BK46DJK43hcT95JpwAe\n4r1PF5S70QG+oRVBERAREQEREBERAREQEREBERAREQEREBERAREQEREBERAREQERfFRM1jS97msa\n0Euc4hrWgcSXHQDrKD7RVntVvzwajLm/CTVPb95SM5UHxTEtgPmeqv2l+qoOraKga3vZKqUv9MMQ\nb80hU+Mm2zixuPY9S0cfKVdTBTN5nTSsjB6m5iC49QuVpPtLv6xqquPhhp2n7yla2C3ikaDN+uq5\nxHFpZpHSSyPke74z3uL5HfjOcS4+cqfFG24+1v1SOFU120zaitdqAWM5CnuOmSaz7dbY3Kl9tfqj\n8VqszacxULDwbTtzz26HVEoJv1xtjOipJ0hXwpHuxfFpqmUy1M0s7zxklkfJJ53PJcfSvE59183S\n6kcXXFlyuLqB9Fchy+SVwpE23U7cvwusD9XRPs2aMHiO+aO/b8/Bba7P41FVwMnglbKx4uHNN7dR\nHFpHO06haKtKz+x219Xh0vKUszmXIzxntoZLd+w6HxixHMQuTkcWMvcert43MnF1PcN3wLjrX2Iy\nOdVDsFvzoqgNZW3o5NBmN3Urj05wLx/ni3+JW7Q1kc0YkikZKx2rXxuD4z4nNuD5l5l8F6esPYpy\naZI6klZccAuljQBx+gr220XnkpweF/FzKkQttw61vjfQugvb4/66l9OpT0r5ZSc1rehNtIrGnnlY\nXLokYBp8yyro8o14rGzAud/XBVk8oiHS5mh/rVeSSLXzcSslNZouSGgC5JNgB1k8FRm9/e1G0Ppc\nOfncbtlqR8RvMWwn74/4uA5rqceC2SdQ5snIrSNy8+/Hb8Na6hpXXce1qJG8G9LGnvuk8yowm6+n\nvLiSSSTqSeJPOSVwRZe3gw1xV8YeHnzWy23L6zLlsi+CuAtmK2d1G+/EcHDIQ4VlK2w+CzuN429F\nPMLuh/FIcwczRe62s3Y73sMxgNZBNyNQRrR1FmVF+fk9ck457xkkDiG8F+fgPiXdFKWkEEgghzSD\nYgjUEEagg6ghEv09RaZbtPqjsQog2GtAxGEWAdI7JXMaNNJgCJtPwoLifvwtmt3e8/DcYYPglQ0S\nkXdSzWirGW4/3RJzgc74y9vWq+ImaIigEREBERAREQEREBERAREQEREBERAREQEREBERARFU++Pf\nJT4Yx8NMWT1OrTYh0EB5+UyntpB3g4c5HAzEbEm3n7xaTB4c0x5SVzSYqZjgJH2++cT9rjvpmIPP\nYOIIWm28/efW4rKTUSnICTHTsu2nj6MrL9s7/G67uvmUe2u2jmq6h808jpHyOLnPcbudzDxADQAa\nAAAWAUce65VojSHbJUOPErqJXyEUpLri6FcXUIcri6FcIOSuAuUUkOEK5QlEuAFwuQvlEObL6aUY\nuXBABWTwDH6qjfylLUTU7ucxPLQ78do7V46nArFrm6iTelv7Pb/sShAFQyCrA53N5Gb5cfaH5Cnu\nB/VCUT7CogqKc85aGzR+Yts/9Vaxri6ytx8dvZvTlZK+ktzsN3sYRMNMQhZw0lzQn/qtas/QbXYd\nJ8XEKJ3iqoL/ALa0TXBWM8Kk+8uivxC8e0N48f22w2Fl319GOoVET3H81ri4+YKttoN+VBACKcSV\nTrEXa0xxX63SC5HiBWsl+hcJXhY49e1b868pxt9vQrsSBY9whi/AxXAP5R3xn/MOpQZLLldVaRWN\nQ5LXm07kuuQuLLkBWVCuLLkrhQBXKIhL7BXop6ksc1zSQWkOa4EhzXA3BaRqCDzheUFcgoP1CRaA\ndmrj3geDer13vFOzVx7wPBvV673iqJb/AKLQDs1ce8Dwb1eu94p2auPeB4N6vXe8UG/6LQDs1ce8\nDwb1eu94p2auPeB4N6vXe8UG/wCi0A7NXHvA8G9XrveKdmrj3geDer13vFBv+i0A7NXHvA8G9Xrv\neKdmrj3geDer13vFBv8AotAOzVx7wPBvV673inZq494Hg3q9d7xQb/otAOzVx7wPBvV673inZq49\n4Hg3q9d7xQb/AKLQDs1ce8Dwb1eu94p2auPeB4N6vXe8UG/6LQDs1ce8Dwb1eu94p2auPeB4N6vX\ne8UG/wCi0A7NXHvA8G9XrveKdmrj3geDer13vFBv+i0A7NXHvA8G9XrveKdmrj3geDer13vFBv8A\notAOzVx7wPBvV673inZq494Hg3q9d7xQbI/VTbwJqCnio6Z5ifUtc+aVpyyNivlDIyDdrnkPu4ag\nN046ah4niDn63Uf3hb7cRxepdUVUdIHOtpFHM1jQAA1rQ+odZoA6ec8bqKHbCfvIfkv/AJitE6Qm\n7ivgqFfZfP3kPyX/AMxcfZdN3kPyX/zFPlAmyKE/ZdN3kXyX/wAxPsum7yL5L/5ibE1RQr7LZu8i\n+S/+YuDtbN3kXyX/AMabE1XKhX2Wzd5F8l/8a4+y2bvIvkv/AJijaU2sllCfssm7yL5L/wCYn2Wz\nd5F8l/8AMTaE0IRQv7LZu8i+S/8AmJ9lk3eRfJf/ADE2aTQLmyhX2WTd5F8l/wDGuDtZN3kXyX/x\nqdmk2C+lCBtZN3sXyX/xp9ls3exfJf8AxqNwaTZLKE/ZbN3kXyX/AMafZbN3sXyX/wAxNpTgL5co\nT9ls3eRfJf8Axrn7LZu8i+S/+Ym4QmhK4soZ9l03eRfJf/MT7LZu8i+S/wDmKdwlM7IoWdrJu8i+\nS/8AmJ9lk3eRfJf/ABp5CZooX9lc3eRfJf8Axp9lc3eRfJf/ABqJmBNUUL+yybvIvkv/AI0O1k3e\nRfJf/Gp8kJouCoZ9lk3eRfJf/GuPssm72L5L/wCNNpTW6KFfZXN3sXyX/wAa5+yybvYvkv8A41G4\nQma5UL+yybvYvkv/AI0+yybvIvkv/jTcJR9ERVBERAREQEREBERAREQEREBERAREQEREBERAREQE\nREBERAREQEREBERAREQEREBERAREQEREBERAREQEREBERAREQEREBERAREQEREBERAREQEREBERA\nREQEREBERAREQEREBERAREQEREBERAREQEREBERAREQEREBERAREQEREBERAREQEREBERAREQERE\nBERAREQEREBERAREQEREBERAREQEREBERAREQEREBERAREQEREBERAREQEREBERAREQEREBERARE\nQEREBERAREQEREBERAREQEREBERAREQf/9k=\n",
      "text/html": [
       "\n",
       "        <iframe\n",
       "            width=\"800\"\n",
       "            height=\"600\"\n",
       "            src=\"https://www.youtube.com/embed/7YcW25PHnAA\"\n",
       "            frameborder=\"0\"\n",
       "            allowfullscreen\n",
       "        ></iframe>\n",
       "        "
      ],
      "text/plain": [
       "<IPython.lib.display.YouTubeVideo at 0x458cc50>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "YouTubeVideo(\"7YcW25PHnAA\",width=800,height=600)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Breaking down an API request"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<img src = \"img/structure.png\">"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Any API requests that you make have a distinct structure as follows:\n",
    "\n",
    "* URL: The location of the API. Can also contain parameters relating to the request such as the API key.\n",
    "* Method: What we want the API to do:\n",
    "    GET - Retrieves a resource\n",
    "    POST - Creates a new resource\n",
    "    PUT - Edits an existing resource\n",
    "    DELETE - Deletes a resource\n",
    "* Headers: The parameters of the transaction with the API.\n",
    "* Body: Contains the content of the API request\n",
    "\n",
    "In making an API request, we'll also need to be aware of something called an <b>API endpoint</b> which the the URL location of where our API request will end up. These are called endpoints simply because they go at the end of the URL. APIs can have multiple endpoints for different resources.\n",
    "\n",
    "We'll also need to be aware of something called a <b>Query String</b>. This is some text that is appended to the API endpoint location and allows us to set parameters for our API request."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## The API Response"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Once our API request has been made, we'll receive a response in the following format:\n",
    "\n",
    "* Header: As beforem the parameters of the transaction with the API\n",
    "* Response: A 3 digit code that indicates the status of our request. Some common codes are as follows:\n",
    "\n",
    "    <b>200</b> Successful<br/>\n",
    "    <b>300</b> Multiple Choices<br/>\n",
    "    <b>301</b> Moved Permanently<br/>\n",
    "    <b>302</b> Found<br/>\n",
    "    <b>304</b> Not Modified<br/>\n",
    "    <b>307</b> Temporary Redirect<br/>\n",
    "    <b>400</b> Bad Request<br/>\n",
    "    <b>401</b> Unauthorized<br/>\n",
    "    <b>403</b> Forbidden<br/>\n",
    "    <b>404</b> Not Found<br/>\n",
    "    <b>410</b> Gone<br/>\n",
    "    <b>500</b> Internal Server Error<br/>\n",
    "    <b>501</b> Not Implemented<br/>\n",
    "    <b>503</b> Service Unavailable<br/>\n",
    "    <b>550</b> Permission denied<br/>\n",
    "\n",
    "A full list of what they mean can be found here <a href = \"https://www.smartlabsoftware.com/ref/http-status-codes.htm\">here</a>.\n",
    "\n",
    "The two most common are 200 (where your request has been successful) and 404 (where the URL doesn'r exist).\n",
    "\n",
    "The response from REST APIs will usually be in JSON format."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "## An Example API Request"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "We're going to look at a <a href = \"http://darwin.hacktrain.com/\">REST API built by Alejandro Saucedo at Hacktrain</a> to interface with the <a href = \"http://www.nationalrail.co.uk/100296.aspx\">DARWIN</a> service which is the GB rail industry’s official train running information engine. This is a nice simple API to get us started! Note that every API is slightly different and some trial and error will be required to make it work.\n",
    "\n",
    "We're going to explore the API through the <a href = \"http://darwin.hacktrain.com/docs/\">Hacktrain console</a> first, before the interfacing with it using Python."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Using Python to make API requests"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We can make and receive API requests using Python via a package called <a href = \"http://docs.python-requests.org/en/master/\">Requests</a>."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<img src = \"img/Requests.png\">"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Requests describes itself as an elegant and simple HTTP library for Python, built for human beings. It's included as part of the Anaconda installation so you don't need to do anything. We'll also import the DataFrame class from pandas so we can handle the response from the API."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import requests\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Once you understand how APIs work, Requests is really easy to use. To illustrate this we're going to make a request to the Hacktrain API above. First we'll need to input some parameters:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "url   = 'http://darwin.hacktrain.com/api/train/'                       # The Location of the API\n",
    "values= {'apiKey':'b05cc6d2-7704-4350-a44f-062b59ba39c5','rows':'10'}  # A Dictionary for our API key and limiting the rows to 50\n",
    "stat  = 'EUS'\t\t\t\t\t\t\t\t\t                       # The API parameter for Station"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "r = requests.get(url+stat,params=values)                               # Makes the request and assigns it to the r object."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Lets explore what we can do with our r object:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'destinations': [{'stationCode': 'VIC', 'stationName': 'London Victoria'}],\n",
       "  'estimatedArrivalTime': '11:32',\n",
       "  'estimatedDepartureTime': None,\n",
       "  'operatorCode': 'SN',\n",
       "  'operatorName': 'Southern',\n",
       "  'origins': [{'stationCode': 'LIT', 'stationName': 'Littlehampton'},\n",
       "   {'stationCode': 'ORE', 'stationName': 'Ore'}],\n",
       "  'platform': '16',\n",
       "  'scheduledArrivalTime': '10:58',\n",
       "  'scheduledDepartureTime': None,\n",
       "  'serviceId': 'C3KZLGwpc5mVqAXtLqqddA=='},\n",
       " {'destinations': [{'stationCode': 'VIC', 'stationName': 'London Victoria'}],\n",
       "  'estimatedArrivalTime': '11:28',\n",
       "  'estimatedDepartureTime': None,\n",
       "  'operatorCode': 'GX',\n",
       "  'operatorName': 'Gatwick Express',\n",
       "  'origins': [{'stationCode': 'BTN', 'stationName': 'Brighton'}],\n",
       "  'platform': '13',\n",
       "  'scheduledArrivalTime': '11:15',\n",
       "  'scheduledDepartureTime': None,\n",
       "  'serviceId': 'n3kC7sg34VNjLZykLpUTAA=='},\n",
       " {'destinations': [{'stationCode': 'HHE', 'stationName': 'Haywards Heath'},\n",
       "   {'stationCode': 'EBN', 'stationName': 'Eastbourne'}],\n",
       "  'estimatedArrivalTime': None,\n",
       "  'estimatedDepartureTime': 'Delayed',\n",
       "  'operatorCode': 'SN',\n",
       "  'operatorName': 'Southern',\n",
       "  'origins': [{'stationCode': 'VIC', 'stationName': 'London Victoria'}],\n",
       "  'platform': None,\n",
       "  'scheduledArrivalTime': None,\n",
       "  'scheduledDepartureTime': '11:17',\n",
       "  'serviceId': 'TO/B+Bk0xEzA8hpsA3qH7w=='},\n",
       " {'destinations': [{'stationCode': 'VIC', 'stationName': 'London Victoria'}],\n",
       "  'estimatedArrivalTime': '11:27',\n",
       "  'estimatedDepartureTime': None,\n",
       "  'operatorCode': 'SN',\n",
       "  'operatorName': 'Southern',\n",
       "  'origins': [{'stationCode': 'TON', 'stationName': 'Tonbridge'}],\n",
       "  'platform': '19',\n",
       "  'scheduledArrivalTime': '11:21',\n",
       "  'scheduledDepartureTime': None,\n",
       "  'serviceId': 'V5E4j3rgqvUbvH2XIu3EGg=='},\n",
       " {'destinations': [{'stationCode': 'EGR', 'stationName': 'East Grinstead'}],\n",
       "  'estimatedArrivalTime': None,\n",
       "  'estimatedDepartureTime': '11:26',\n",
       "  'operatorCode': 'SN',\n",
       "  'operatorName': 'Southern',\n",
       "  'origins': [{'stationCode': 'VIC', 'stationName': 'London Victoria'}],\n",
       "  'platform': '19',\n",
       "  'scheduledArrivalTime': None,\n",
       "  'scheduledDepartureTime': '11:23',\n",
       "  'serviceId': 'NRLBTcKaGOuGuBOgaUXjow=='},\n",
       " {'destinations': [{'stationCode': 'ORP', 'stationName': 'Orpington'}],\n",
       "  'estimatedArrivalTime': None,\n",
       "  'estimatedDepartureTime': 'On time',\n",
       "  'operatorCode': 'SE',\n",
       "  'operatorName': 'Southeastern',\n",
       "  'origins': [{'stationCode': 'VIC', 'stationName': 'London Victoria'}],\n",
       "  'platform': '3',\n",
       "  'scheduledArrivalTime': None,\n",
       "  'scheduledDepartureTime': '11:25',\n",
       "  'serviceId': 'GoOUoNeF5ksNZx3kjYmYdQ=='},\n",
       " {'destinations': [{'stationCode': 'VIC', 'stationName': 'London Victoria'}],\n",
       "  'estimatedArrivalTime': '11:49',\n",
       "  'estimatedDepartureTime': None,\n",
       "  'operatorCode': 'SN',\n",
       "  'operatorName': 'Southern',\n",
       "  'origins': [{'stationCode': 'BTN', 'stationName': 'Brighton'}],\n",
       "  'platform': '17',\n",
       "  'scheduledArrivalTime': '11:25',\n",
       "  'scheduledDepartureTime': None,\n",
       "  'serviceId': 'bQkpxR48G80VMQ2bh6s5uw=='},\n",
       " {'destinations': [{'stationCode': 'VIC', 'stationName': 'London Victoria'}],\n",
       "  'estimatedArrivalTime': '11:45',\n",
       "  'estimatedDepartureTime': None,\n",
       "  'operatorCode': 'SN',\n",
       "  'operatorName': 'Southern',\n",
       "  'origins': [{'stationCode': 'LIT', 'stationName': 'Littlehampton'},\n",
       "   {'stationCode': 'LWS', 'stationName': 'Lewes'}],\n",
       "  'platform': '15',\n",
       "  'scheduledArrivalTime': '11:28',\n",
       "  'scheduledDepartureTime': None,\n",
       "  'serviceId': 'GXblagTnx/oDJRfdDgkaCw=='},\n",
       " {'destinations': [{'stationCode': 'VIC', 'stationName': 'London Victoria'}],\n",
       "  'estimatedArrivalTime': '11:30',\n",
       "  'estimatedDepartureTime': None,\n",
       "  'operatorCode': 'SE',\n",
       "  'operatorName': 'Southeastern',\n",
       "  'origins': [{'stationCode': 'DFD', 'stationName': 'Dartford'}],\n",
       "  'platform': '7',\n",
       "  'scheduledArrivalTime': '11:28',\n",
       "  'scheduledDepartureTime': None,\n",
       "  'serviceId': 'yR/smJQbZ9UWWH8HvZLwpQ=='},\n",
       " {'destinations': [{'stationCode': 'VIC', 'stationName': 'London Victoria'}],\n",
       "  'estimatedArrivalTime': 'On time',\n",
       "  'estimatedDepartureTime': None,\n",
       "  'operatorCode': 'SN',\n",
       "  'operatorName': 'Southern',\n",
       "  'origins': [{'stationCode': 'EPD', 'stationName': 'Epsom Downs'}],\n",
       "  'platform': '10',\n",
       "  'scheduledArrivalTime': '11:28',\n",
       "  'scheduledDepartureTime': None,\n",
       "  'serviceId': 'I2Kd72hdIex0854KNiCeaA=='}]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.request           # The type of request we made\n",
    "r.status_code       # The 3 digit API response code\n",
    "r.reason            # The decode for the API response reason code\n",
    "r.headers           # The headers associated with the API response\n",
    "r.cookies           # Shows any cookies related to the API response\n",
    "r.url               # The URL of the API response\n",
    "r.text              # The content (body) of the response in text format\n",
    "r.json()            # The content (body) of the response in JSON format"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "JSON isn't designed for humans, but we can pass the JSON object to the pandas DataFrame class to display the information in a more meaningful format:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>destinations</th>\n",
       "      <th>estimatedArrivalTime</th>\n",
       "      <th>estimatedDepartureTime</th>\n",
       "      <th>operatorCode</th>\n",
       "      <th>operatorName</th>\n",
       "      <th>origins</th>\n",
       "      <th>platform</th>\n",
       "      <th>scheduledArrivalTime</th>\n",
       "      <th>scheduledDepartureTime</th>\n",
       "      <th>serviceId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'stationName': 'London Victoria', 'stationCo...</td>\n",
       "      <td>11:32</td>\n",
       "      <td>None</td>\n",
       "      <td>SN</td>\n",
       "      <td>Southern</td>\n",
       "      <td>[{'stationName': 'Littlehampton', 'stationCode...</td>\n",
       "      <td>16</td>\n",
       "      <td>10:58</td>\n",
       "      <td>None</td>\n",
       "      <td>C3KZLGwpc5mVqAXtLqqddA==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>[{'stationName': 'London Victoria', 'stationCo...</td>\n",
       "      <td>11:28</td>\n",
       "      <td>None</td>\n",
       "      <td>GX</td>\n",
       "      <td>Gatwick Express</td>\n",
       "      <td>[{'stationName': 'Brighton', 'stationCode': 'B...</td>\n",
       "      <td>13</td>\n",
       "      <td>11:15</td>\n",
       "      <td>None</td>\n",
       "      <td>n3kC7sg34VNjLZykLpUTAA==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>[{'stationName': 'Haywards Heath', 'stationCod...</td>\n",
       "      <td>None</td>\n",
       "      <td>Delayed</td>\n",
       "      <td>SN</td>\n",
       "      <td>Southern</td>\n",
       "      <td>[{'stationName': 'London Victoria', 'stationCo...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:17</td>\n",
       "      <td>TO/B+Bk0xEzA8hpsA3qH7w==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>[{'stationName': 'London Victoria', 'stationCo...</td>\n",
       "      <td>11:27</td>\n",
       "      <td>None</td>\n",
       "      <td>SN</td>\n",
       "      <td>Southern</td>\n",
       "      <td>[{'stationName': 'Tonbridge', 'stationCode': '...</td>\n",
       "      <td>19</td>\n",
       "      <td>11:21</td>\n",
       "      <td>None</td>\n",
       "      <td>V5E4j3rgqvUbvH2XIu3EGg==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>[{'stationName': 'East Grinstead', 'stationCod...</td>\n",
       "      <td>None</td>\n",
       "      <td>11:26</td>\n",
       "      <td>SN</td>\n",
       "      <td>Southern</td>\n",
       "      <td>[{'stationName': 'London Victoria', 'stationCo...</td>\n",
       "      <td>19</td>\n",
       "      <td>None</td>\n",
       "      <td>11:23</td>\n",
       "      <td>NRLBTcKaGOuGuBOgaUXjow==</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        destinations estimatedArrivalTime  \\\n",
       "0  [{'stationName': 'London Victoria', 'stationCo...                11:32   \n",
       "1  [{'stationName': 'London Victoria', 'stationCo...                11:28   \n",
       "2  [{'stationName': 'Haywards Heath', 'stationCod...                 None   \n",
       "3  [{'stationName': 'London Victoria', 'stationCo...                11:27   \n",
       "4  [{'stationName': 'East Grinstead', 'stationCod...                 None   \n",
       "\n",
       "  estimatedDepartureTime operatorCode     operatorName  \\\n",
       "0                   None           SN         Southern   \n",
       "1                   None           GX  Gatwick Express   \n",
       "2                Delayed           SN         Southern   \n",
       "3                   None           SN         Southern   \n",
       "4                  11:26           SN         Southern   \n",
       "\n",
       "                                             origins platform  \\\n",
       "0  [{'stationName': 'Littlehampton', 'stationCode...       16   \n",
       "1  [{'stationName': 'Brighton', 'stationCode': 'B...       13   \n",
       "2  [{'stationName': 'London Victoria', 'stationCo...     None   \n",
       "3  [{'stationName': 'Tonbridge', 'stationCode': '...       19   \n",
       "4  [{'stationName': 'London Victoria', 'stationCo...       19   \n",
       "\n",
       "  scheduledArrivalTime scheduledDepartureTime                 serviceId  \n",
       "0                10:58                   None  C3KZLGwpc5mVqAXtLqqddA==  \n",
       "1                11:15                   None  n3kC7sg34VNjLZykLpUTAA==  \n",
       "2                 None                  11:17  TO/B+Bk0xEzA8hpsA3qH7w==  \n",
       "3                11:21                   None  V5E4j3rgqvUbvH2XIu3EGg==  \n",
       "4                 None                  11:23  NRLBTcKaGOuGuBOgaUXjow==  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame(r.json())\n",
    "df.head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We can tidy the dataframe with a for loop and a list comprehension as follows:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>Origin Station</th>\n",
       "      <th>Destination Station</th>\n",
       "      <th>scheduledArrivalTime</th>\n",
       "      <th>estimatedArrivalTime</th>\n",
       "      <th>scheduledDepartureTime</th>\n",
       "      <th>estimatedDepartureTime</th>\n",
       "      <th>operatorName</th>\n",
       "      <th>serviceId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Littlehampton</td>\n",
       "      <td>London Victoria</td>\n",
       "      <td>10:58</td>\n",
       "      <td>11:32</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Southern</td>\n",
       "      <td>C3KZLGwpc5mVqAXtLqqddA==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Brighton</td>\n",
       "      <td>London Victoria</td>\n",
       "      <td>11:15</td>\n",
       "      <td>11:28</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Gatwick Express</td>\n",
       "      <td>n3kC7sg34VNjLZykLpUTAA==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>London Victoria</td>\n",
       "      <td>Haywards Heath</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:17</td>\n",
       "      <td>Delayed</td>\n",
       "      <td>Southern</td>\n",
       "      <td>TO/B+Bk0xEzA8hpsA3qH7w==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Tonbridge</td>\n",
       "      <td>London Victoria</td>\n",
       "      <td>11:21</td>\n",
       "      <td>11:27</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Southern</td>\n",
       "      <td>V5E4j3rgqvUbvH2XIu3EGg==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>London Victoria</td>\n",
       "      <td>East Grinstead</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:23</td>\n",
       "      <td>11:26</td>\n",
       "      <td>Southern</td>\n",
       "      <td>NRLBTcKaGOuGuBOgaUXjow==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>London Victoria</td>\n",
       "      <td>Orpington</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:25</td>\n",
       "      <td>On time</td>\n",
       "      <td>Southeastern</td>\n",
       "      <td>GoOUoNeF5ksNZx3kjYmYdQ==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Brighton</td>\n",
       "      <td>London Victoria</td>\n",
       "      <td>11:25</td>\n",
       "      <td>11:49</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Southern</td>\n",
       "      <td>bQkpxR48G80VMQ2bh6s5uw==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Littlehampton</td>\n",
       "      <td>London Victoria</td>\n",
       "      <td>11:28</td>\n",
       "      <td>11:45</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Southern</td>\n",
       "      <td>GXblagTnx/oDJRfdDgkaCw==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Dartford</td>\n",
       "      <td>London Victoria</td>\n",
       "      <td>11:28</td>\n",
       "      <td>11:30</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Southeastern</td>\n",
       "      <td>yR/smJQbZ9UWWH8HvZLwpQ==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Epsom Downs</td>\n",
       "      <td>London Victoria</td>\n",
       "      <td>11:28</td>\n",
       "      <td>On time</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Southern</td>\n",
       "      <td>I2Kd72hdIex0854KNiCeaA==</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Origin Station Destination Station scheduledArrivalTime  \\\n",
       "0    Littlehampton     London Victoria                10:58   \n",
       "1         Brighton     London Victoria                11:15   \n",
       "2  London Victoria      Haywards Heath                 None   \n",
       "3        Tonbridge     London Victoria                11:21   \n",
       "4  London Victoria      East Grinstead                 None   \n",
       "5  London Victoria           Orpington                 None   \n",
       "6         Brighton     London Victoria                11:25   \n",
       "7    Littlehampton     London Victoria                11:28   \n",
       "8         Dartford     London Victoria                11:28   \n",
       "9      Epsom Downs     London Victoria                11:28   \n",
       "\n",
       "  estimatedArrivalTime scheduledDepartureTime estimatedDepartureTime  \\\n",
       "0                11:32                   None                   None   \n",
       "1                11:28                   None                   None   \n",
       "2                 None                  11:17                Delayed   \n",
       "3                11:27                   None                   None   \n",
       "4                 None                  11:23                  11:26   \n",
       "5                 None                  11:25                On time   \n",
       "6                11:49                   None                   None   \n",
       "7                11:45                   None                   None   \n",
       "8                11:30                   None                   None   \n",
       "9              On time                   None                   None   \n",
       "\n",
       "      operatorName                 serviceId  \n",
       "0         Southern  C3KZLGwpc5mVqAXtLqqddA==  \n",
       "1  Gatwick Express  n3kC7sg34VNjLZykLpUTAA==  \n",
       "2         Southern  TO/B+Bk0xEzA8hpsA3qH7w==  \n",
       "3         Southern  V5E4j3rgqvUbvH2XIu3EGg==  \n",
       "4         Southern  NRLBTcKaGOuGuBOgaUXjow==  \n",
       "5     Southeastern  GoOUoNeF5ksNZx3kjYmYdQ==  \n",
       "6         Southern  bQkpxR48G80VMQ2bh6s5uw==  \n",
       "7         Southern  GXblagTnx/oDJRfdDgkaCw==  \n",
       "8     Southeastern  yR/smJQbZ9UWWH8HvZLwpQ==  \n",
       "9         Southern  I2Kd72hdIex0854KNiCeaA==  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Origin Station'] = ''\n",
    "df['Destination Station'] = ''\t\t\t\t\t# Blank variables to populate\n",
    "\n",
    "for x in df.index.values:\t\t\t\t\t\t# List comprehension to clean origin / destination variables\n",
    "\tdf['Origin Station'][x] = df['origins'][x][0]['stationName']\n",
    "\tdf['Destination Station'][x] = df['destinations'][x][0]['stationName']\n",
    "\n",
    "df.drop(['origins','destinations','platform','operatorCode'],axis=1,inplace=True)\n",
    "df = df[['Origin Station','Destination Station','scheduledArrivalTime','estimatedArrivalTime','scheduledDepartureTime','estimatedDepartureTime','operatorName','serviceId']]\n",
    "\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We can combine our code with a for loop and a list of some stations in London as follows:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Query Code</th>\n",
       "      <th>Origin Station</th>\n",
       "      <th>Destination Station</th>\n",
       "      <th>scheduledArrivalTime</th>\n",
       "      <th>estimatedArrivalTime</th>\n",
       "      <th>scheduledDepartureTime</th>\n",
       "      <th>estimatedDepartureTime</th>\n",
       "      <th>operatorName</th>\n",
       "      <th>serviceId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>VIC</td>\n",
       "      <td>Littlehampton</td>\n",
       "      <td>London Victoria</td>\n",
       "      <td>10:58</td>\n",
       "      <td>11:32</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Southern</td>\n",
       "      <td>C3KZLGwpc5mVqAXtLqqddA==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>VIC</td>\n",
       "      <td>Brighton</td>\n",
       "      <td>London Victoria</td>\n",
       "      <td>11:15</td>\n",
       "      <td>11:29</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Gatwick Express</td>\n",
       "      <td>n3kC7sg34VNjLZykLpUTAA==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>VIC</td>\n",
       "      <td>London Victoria</td>\n",
       "      <td>Haywards Heath</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:17</td>\n",
       "      <td>Delayed</td>\n",
       "      <td>Southern</td>\n",
       "      <td>TO/B+Bk0xEzA8hpsA3qH7w==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>VIC</td>\n",
       "      <td>Tonbridge</td>\n",
       "      <td>London Victoria</td>\n",
       "      <td>11:21</td>\n",
       "      <td>11:27</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Southern</td>\n",
       "      <td>V5E4j3rgqvUbvH2XIu3EGg==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>VIC</td>\n",
       "      <td>Brighton</td>\n",
       "      <td>London Victoria</td>\n",
       "      <td>11:25</td>\n",
       "      <td>11:50</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Southern</td>\n",
       "      <td>bQkpxR48G80VMQ2bh6s5uw==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>VIC</td>\n",
       "      <td>Epsom Downs</td>\n",
       "      <td>London Victoria</td>\n",
       "      <td>11:28</td>\n",
       "      <td>On time</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Southern</td>\n",
       "      <td>I2Kd72hdIex0854KNiCeaA==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>VIC</td>\n",
       "      <td>Dartford</td>\n",
       "      <td>London Victoria</td>\n",
       "      <td>11:28</td>\n",
       "      <td>11:30</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Southeastern</td>\n",
       "      <td>yR/smJQbZ9UWWH8HvZLwpQ==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>VIC</td>\n",
       "      <td>Littlehampton</td>\n",
       "      <td>London Victoria</td>\n",
       "      <td>11:28</td>\n",
       "      <td>11:44</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Southern</td>\n",
       "      <td>GXblagTnx/oDJRfdDgkaCw==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>VIC</td>\n",
       "      <td>London Victoria</td>\n",
       "      <td>Brighton</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:30</td>\n",
       "      <td>11:35</td>\n",
       "      <td>Gatwick Express</td>\n",
       "      <td>Qv57M9Mh4/5doFwRxWPTYg==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>VIC</td>\n",
       "      <td>Gatwick Airport</td>\n",
       "      <td>London Victoria</td>\n",
       "      <td>11:30</td>\n",
       "      <td>11:46</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Gatwick Express</td>\n",
       "      <td>3WO/KprwB2c0RGAU997eBQ==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>WAT</td>\n",
       "      <td>Reading</td>\n",
       "      <td>London Waterloo</td>\n",
       "      <td>11:25</td>\n",
       "      <td>11:27</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>South West Trains</td>\n",
       "      <td>+2VqxTigVzNP/gtTpoBAkw==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>WAT</td>\n",
       "      <td>Dorking</td>\n",
       "      <td>London Waterloo</td>\n",
       "      <td>11:25</td>\n",
       "      <td>11:27</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>South West Trains</td>\n",
       "      <td>HmIKPaDMZ/yTCi5e41rrqA==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>WAT</td>\n",
       "      <td>London Waterloo</td>\n",
       "      <td>Strawberry Hill</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:27</td>\n",
       "      <td>On time</td>\n",
       "      <td>South West Trains</td>\n",
       "      <td>ahJgyDIIPUSURJa5W/EtjQ==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>WAT</td>\n",
       "      <td>Weybridge</td>\n",
       "      <td>London Waterloo</td>\n",
       "      <td>11:27</td>\n",
       "      <td>On time</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>South West Trains</td>\n",
       "      <td>F1jXwBoklj864NEy4SpdSg==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>WAT</td>\n",
       "      <td>London Waterloo</td>\n",
       "      <td>Windsor &amp; Eton Riverside</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:28</td>\n",
       "      <td>On time</td>\n",
       "      <td>South West Trains</td>\n",
       "      <td>NeoSZU2cHiADtEhIFvX7mw==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>WAT</td>\n",
       "      <td>London Waterloo</td>\n",
       "      <td>Portsmouth Harbour</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:30</td>\n",
       "      <td>On time</td>\n",
       "      <td>South West Trains</td>\n",
       "      <td>cbE1sJN3fxaC4V9GBN5dmw==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>WAT</td>\n",
       "      <td>Hampton Court</td>\n",
       "      <td>London Waterloo</td>\n",
       "      <td>11:31</td>\n",
       "      <td>On time</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>South West Trains</td>\n",
       "      <td>PPFnm1qXpTg+wm89iJs51g==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>WAT</td>\n",
       "      <td>London Waterloo</td>\n",
       "      <td>London Waterloo</td>\n",
       "      <td>11:32</td>\n",
       "      <td>On time</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>South West Trains</td>\n",
       "      <td>FNbiiv9VvKZKJ/uzyNP0hQ==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>WAT</td>\n",
       "      <td>London Waterloo</td>\n",
       "      <td>Guildford</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:33</td>\n",
       "      <td>On time</td>\n",
       "      <td>South West Trains</td>\n",
       "      <td>yaXTy244yx7MZJOn17Th4g==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>WAT</td>\n",
       "      <td>London Waterloo</td>\n",
       "      <td>Teddington</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:33</td>\n",
       "      <td>On time</td>\n",
       "      <td>South West Trains</td>\n",
       "      <td>/Ao/tLmf4yIWpFjhebEW2g==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>PAD</td>\n",
       "      <td>London Paddington</td>\n",
       "      <td>Great Malvern</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:20</td>\n",
       "      <td>Delayed</td>\n",
       "      <td>Great Western Railway</td>\n",
       "      <td>PzUjHwo+IGlsJGCetT/5mA==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>PAD</td>\n",
       "      <td>Penzance</td>\n",
       "      <td>London Paddington</td>\n",
       "      <td>11:24</td>\n",
       "      <td>11:28</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Great Western Railway</td>\n",
       "      <td>8somNgWjdcj2hLBODp5+Vg==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>PAD</td>\n",
       "      <td>London Paddington</td>\n",
       "      <td>Radley</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:27</td>\n",
       "      <td>On time</td>\n",
       "      <td>Great Western Railway</td>\n",
       "      <td>p6qSlFBLYo6HTUAWbDRMBQ==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>PAD</td>\n",
       "      <td>Moreton-in-Marsh</td>\n",
       "      <td>London Paddington</td>\n",
       "      <td>11:29</td>\n",
       "      <td>11:31</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Great Western Railway</td>\n",
       "      <td>h2wPETwPdL93TvqkQsikew==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>PAD</td>\n",
       "      <td>London Paddington</td>\n",
       "      <td>Bristol Temple Meads</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:30</td>\n",
       "      <td>On time</td>\n",
       "      <td>Great Western Railway</td>\n",
       "      <td>flVGmjhp0Gk4oV7uG+ipGw==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>PAD</td>\n",
       "      <td>Carmarthen</td>\n",
       "      <td>London Paddington</td>\n",
       "      <td>11:32</td>\n",
       "      <td>11:38</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Great Western Railway</td>\n",
       "      <td>84kjHfnaiFduTfh9tPY09g==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>PAD</td>\n",
       "      <td>London Paddington</td>\n",
       "      <td>Exeter St Davids</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:33</td>\n",
       "      <td>On time</td>\n",
       "      <td>Great Western Railway</td>\n",
       "      <td>ED64ifW8K17Qo9sFjLQU+w==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>PAD</td>\n",
       "      <td>London Paddington</td>\n",
       "      <td>Heathrow Airport T123</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:33</td>\n",
       "      <td>On time</td>\n",
       "      <td>Heathrow Connect</td>\n",
       "      <td>dgnE2qdBp7Dhm/f3yp5zxQ==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>PAD</td>\n",
       "      <td>Oxford</td>\n",
       "      <td>London Paddington</td>\n",
       "      <td>11:33</td>\n",
       "      <td>On time</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Great Western Railway</td>\n",
       "      <td>TDQ4dBRLG4QSFN0tVyFb3A==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>PAD</td>\n",
       "      <td>Heathrow Airport T5</td>\n",
       "      <td>London Paddington</td>\n",
       "      <td>11:35</td>\n",
       "      <td>On time</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Heathrow Express</td>\n",
       "      <td>N3UcCAcZsjHS7ZZpJkeUtg==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>EUS</td>\n",
       "      <td>Birmingham New Street</td>\n",
       "      <td>London Euston</td>\n",
       "      <td>11:27</td>\n",
       "      <td>On time</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>London Midland</td>\n",
       "      <td>021LmXSTQgcyx+MdK9TxJw==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>EUS</td>\n",
       "      <td>London Euston</td>\n",
       "      <td>Glasgow Central</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:30</td>\n",
       "      <td>On time</td>\n",
       "      <td>Virgin Trains</td>\n",
       "      <td>jNDUUfocPKqUAyUHD+Bbiw==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>EUS</td>\n",
       "      <td>Watford Junction</td>\n",
       "      <td>London Euston</td>\n",
       "      <td>11:30</td>\n",
       "      <td>On time</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>London Overground</td>\n",
       "      <td>TVsRYsBn2vxVeeO+pq2PtQ==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>EUS</td>\n",
       "      <td>London Euston</td>\n",
       "      <td>Tring</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:34</td>\n",
       "      <td>On time</td>\n",
       "      <td>London Midland</td>\n",
       "      <td>xvPVlG1r93UH2X0WlIOyVA==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>EUS</td>\n",
       "      <td>Glasgow Central</td>\n",
       "      <td>London Euston</td>\n",
       "      <td>11:34</td>\n",
       "      <td>11:52</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Virgin Trains</td>\n",
       "      <td>wr8J2q6aCGvoeAaENVW2LQ==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>EUS</td>\n",
       "      <td>London Euston</td>\n",
       "      <td>Watford Junction</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:37</td>\n",
       "      <td>On time</td>\n",
       "      <td>London Overground</td>\n",
       "      <td>9XpfWYXbHXzEKpmNJD3njg==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>EUS</td>\n",
       "      <td>Chester</td>\n",
       "      <td>London Euston</td>\n",
       "      <td>11:39</td>\n",
       "      <td>On time</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Virgin Trains</td>\n",
       "      <td>UcxjcnUEphLKNhAfBWxVhw==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>EUS</td>\n",
       "      <td>London Euston</td>\n",
       "      <td>Manchester Piccadilly</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:40</td>\n",
       "      <td>On time</td>\n",
       "      <td>Virgin Trains</td>\n",
       "      <td>XCtYBosshukp62Qzu0nibg==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>EUS</td>\n",
       "      <td>Tring</td>\n",
       "      <td>London Euston</td>\n",
       "      <td>11:41</td>\n",
       "      <td>On time</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>London Midland</td>\n",
       "      <td>pn2YrrZqJGu2syXhWnRYrA==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>EUS</td>\n",
       "      <td>London Euston</td>\n",
       "      <td>Glasgow Central</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:43</td>\n",
       "      <td>On time</td>\n",
       "      <td>Virgin Trains</td>\n",
       "      <td>5B5NNzwPFvR2keK8MdNT/A==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>LBG</td>\n",
       "      <td>Hayes (Kent)</td>\n",
       "      <td>London Cannon Street</td>\n",
       "      <td>11:26</td>\n",
       "      <td>On time</td>\n",
       "      <td>11:26</td>\n",
       "      <td>On time</td>\n",
       "      <td>Southeastern</td>\n",
       "      <td>J7Go6oJPNX+SCHZlnANueg==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>LBG</td>\n",
       "      <td>London Bridge</td>\n",
       "      <td>Horsham</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:27</td>\n",
       "      <td>11:29</td>\n",
       "      <td>Southern</td>\n",
       "      <td>ULtOAOx5F6upCk+gHRYaXQ==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>LBG</td>\n",
       "      <td>London Cannon Street</td>\n",
       "      <td>Slade Green</td>\n",
       "      <td>11:27</td>\n",
       "      <td>On time</td>\n",
       "      <td>11:28</td>\n",
       "      <td>On time</td>\n",
       "      <td>Southeastern</td>\n",
       "      <td>z4RhS+kM07tDuAfl72NRaQ==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>LBG</td>\n",
       "      <td>Redhill</td>\n",
       "      <td>London Bridge</td>\n",
       "      <td>11:28</td>\n",
       "      <td>On time</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Southern</td>\n",
       "      <td>C29vZEzOGhtVw0IQrMP0Eg==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>LBG</td>\n",
       "      <td>London Bridge</td>\n",
       "      <td>Caterham</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:30</td>\n",
       "      <td>On time</td>\n",
       "      <td>Southern</td>\n",
       "      <td>8dUyqtoxnlCh2MRSiRhoXA==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>LBG</td>\n",
       "      <td>London Cannon Street</td>\n",
       "      <td>Dartford</td>\n",
       "      <td>11:30</td>\n",
       "      <td>On time</td>\n",
       "      <td>11:31</td>\n",
       "      <td>On time</td>\n",
       "      <td>Southeastern</td>\n",
       "      <td>JVbPWxl5dt5bj8DfniVttg==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>LBG</td>\n",
       "      <td>London Cannon Street</td>\n",
       "      <td>London Cannon Street</td>\n",
       "      <td>11:32</td>\n",
       "      <td>On time</td>\n",
       "      <td>11:32</td>\n",
       "      <td>On time</td>\n",
       "      <td>Southeastern</td>\n",
       "      <td>9BEDPXkOCsjx7JRYY1DIYA==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>LBG</td>\n",
       "      <td>Caterham</td>\n",
       "      <td>London Bridge</td>\n",
       "      <td>11:32</td>\n",
       "      <td>On time</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Southern</td>\n",
       "      <td>IKZJRTPW1ace8h2jvxPQ0g==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>LBG</td>\n",
       "      <td>London Cannon Street</td>\n",
       "      <td>Hayes (Kent)</td>\n",
       "      <td>11:33</td>\n",
       "      <td>On time</td>\n",
       "      <td>11:34</td>\n",
       "      <td>On time</td>\n",
       "      <td>Southeastern</td>\n",
       "      <td>4RcKgmFcz7qD/PzVJolQcQ==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>LBG</td>\n",
       "      <td>Brighton</td>\n",
       "      <td>London Bridge</td>\n",
       "      <td>11:35</td>\n",
       "      <td>On time</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Thameslink</td>\n",
       "      <td>srkQwENAdPF5m22VmfUjsg==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SRA</td>\n",
       "      <td>London Liverpool Street</td>\n",
       "      <td>Shenfield</td>\n",
       "      <td>11:27</td>\n",
       "      <td>On time</td>\n",
       "      <td>11:27</td>\n",
       "      <td>On time</td>\n",
       "      <td>TFL Rail</td>\n",
       "      <td>ZTO2vFqLW9gpeXBkpfP2NA==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SRA</td>\n",
       "      <td>Shenfield</td>\n",
       "      <td>London Liverpool Street</td>\n",
       "      <td>11:28</td>\n",
       "      <td>On time</td>\n",
       "      <td>11:29</td>\n",
       "      <td>On time</td>\n",
       "      <td>TFL Rail</td>\n",
       "      <td>D49Pe9/j9Ot7sGn7hKZDvg==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SRA</td>\n",
       "      <td>Richmond</td>\n",
       "      <td>Stratford (London)</td>\n",
       "      <td>11:29</td>\n",
       "      <td>On time</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>London Overground</td>\n",
       "      <td>AY3efidnMJ+1V7Vh8XpP+g==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SRA</td>\n",
       "      <td>Stratford (London)</td>\n",
       "      <td>Bishops Stortford</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:30</td>\n",
       "      <td>On time</td>\n",
       "      <td>Abellio Greater Anglia</td>\n",
       "      <td>7qu1MaZ3A90ZU/ekh+4ksw==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SRA</td>\n",
       "      <td>Stratford (London)</td>\n",
       "      <td>Clapham Junction</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:35</td>\n",
       "      <td>On time</td>\n",
       "      <td>London Overground</td>\n",
       "      <td>h8dkG0rH3gYoInyzDSrHHA==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>SRA</td>\n",
       "      <td>Colchester Town</td>\n",
       "      <td>London Liverpool Street</td>\n",
       "      <td>11:36</td>\n",
       "      <td>On time</td>\n",
       "      <td>11:36</td>\n",
       "      <td>On time</td>\n",
       "      <td>Abellio Greater Anglia</td>\n",
       "      <td>+3abLa6+2M1QojLjFOFRow==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>SRA</td>\n",
       "      <td>London Liverpool Street</td>\n",
       "      <td>Shenfield</td>\n",
       "      <td>11:37</td>\n",
       "      <td>On time</td>\n",
       "      <td>11:37</td>\n",
       "      <td>On time</td>\n",
       "      <td>TFL Rail</td>\n",
       "      <td>z/5nahIFbnJZN6v9CYuPNg==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>SRA</td>\n",
       "      <td>London Liverpool Street</td>\n",
       "      <td>Norwich</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11:38</td>\n",
       "      <td>On time</td>\n",
       "      <td>Abellio Greater Anglia</td>\n",
       "      <td>+huaEyUt6giaiwJDxGamng==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>SRA</td>\n",
       "      <td>Southend Victoria</td>\n",
       "      <td>London Liverpool Street</td>\n",
       "      <td>11:39</td>\n",
       "      <td>On time</td>\n",
       "      <td>11:39</td>\n",
       "      <td>On time</td>\n",
       "      <td>Abellio Greater Anglia</td>\n",
       "      <td>dGrB/wg9kBmcH6xbpY+P6w==</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>SRA</td>\n",
       "      <td>Shenfield</td>\n",
       "      <td>London Liverpool Street</td>\n",
       "      <td>11:38</td>\n",
       "      <td>On time</td>\n",
       "      <td>11:39</td>\n",
       "      <td>On time</td>\n",
       "      <td>TFL Rail</td>\n",
       "      <td>W3vmDT1wczh1/wKiEM8t9A==</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>90 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Query Code           Origin Station       Destination Station  \\\n",
       "0         VIC            Littlehampton           London Victoria   \n",
       "1         VIC                 Brighton           London Victoria   \n",
       "2         VIC          London Victoria            Haywards Heath   \n",
       "3         VIC                Tonbridge           London Victoria   \n",
       "4         VIC                 Brighton           London Victoria   \n",
       "5         VIC              Epsom Downs           London Victoria   \n",
       "6         VIC                 Dartford           London Victoria   \n",
       "7         VIC            Littlehampton           London Victoria   \n",
       "8         VIC          London Victoria                  Brighton   \n",
       "9         VIC          Gatwick Airport           London Victoria   \n",
       "0         WAT                  Reading           London Waterloo   \n",
       "1         WAT                  Dorking           London Waterloo   \n",
       "2         WAT          London Waterloo           Strawberry Hill   \n",
       "3         WAT                Weybridge           London Waterloo   \n",
       "4         WAT          London Waterloo  Windsor & Eton Riverside   \n",
       "5         WAT          London Waterloo        Portsmouth Harbour   \n",
       "6         WAT            Hampton Court           London Waterloo   \n",
       "7         WAT          London Waterloo           London Waterloo   \n",
       "8         WAT          London Waterloo                 Guildford   \n",
       "9         WAT          London Waterloo                Teddington   \n",
       "0         PAD        London Paddington             Great Malvern   \n",
       "1         PAD                 Penzance         London Paddington   \n",
       "2         PAD        London Paddington                    Radley   \n",
       "3         PAD         Moreton-in-Marsh         London Paddington   \n",
       "4         PAD        London Paddington      Bristol Temple Meads   \n",
       "5         PAD               Carmarthen         London Paddington   \n",
       "6         PAD        London Paddington          Exeter St Davids   \n",
       "7         PAD        London Paddington     Heathrow Airport T123   \n",
       "8         PAD                   Oxford         London Paddington   \n",
       "9         PAD      Heathrow Airport T5         London Paddington   \n",
       "..        ...                      ...                       ...   \n",
       "0         EUS    Birmingham New Street             London Euston   \n",
       "1         EUS            London Euston           Glasgow Central   \n",
       "2         EUS         Watford Junction             London Euston   \n",
       "3         EUS            London Euston                     Tring   \n",
       "4         EUS          Glasgow Central             London Euston   \n",
       "5         EUS            London Euston          Watford Junction   \n",
       "6         EUS                  Chester             London Euston   \n",
       "7         EUS            London Euston     Manchester Piccadilly   \n",
       "8         EUS                    Tring             London Euston   \n",
       "9         EUS            London Euston           Glasgow Central   \n",
       "0         LBG             Hayes (Kent)      London Cannon Street   \n",
       "1         LBG            London Bridge                   Horsham   \n",
       "2         LBG     London Cannon Street               Slade Green   \n",
       "3         LBG                  Redhill             London Bridge   \n",
       "4         LBG            London Bridge                  Caterham   \n",
       "5         LBG     London Cannon Street                  Dartford   \n",
       "6         LBG     London Cannon Street      London Cannon Street   \n",
       "7         LBG                 Caterham             London Bridge   \n",
       "8         LBG     London Cannon Street              Hayes (Kent)   \n",
       "9         LBG                 Brighton             London Bridge   \n",
       "0         SRA  London Liverpool Street                 Shenfield   \n",
       "1         SRA                Shenfield   London Liverpool Street   \n",
       "2         SRA                 Richmond        Stratford (London)   \n",
       "3         SRA       Stratford (London)         Bishops Stortford   \n",
       "4         SRA       Stratford (London)          Clapham Junction   \n",
       "5         SRA          Colchester Town   London Liverpool Street   \n",
       "6         SRA  London Liverpool Street                 Shenfield   \n",
       "7         SRA  London Liverpool Street                   Norwich   \n",
       "8         SRA        Southend Victoria   London Liverpool Street   \n",
       "9         SRA                Shenfield   London Liverpool Street   \n",
       "\n",
       "   scheduledArrivalTime estimatedArrivalTime scheduledDepartureTime  \\\n",
       "0                 10:58                11:32                   None   \n",
       "1                 11:15                11:29                   None   \n",
       "2                  None                 None                  11:17   \n",
       "3                 11:21                11:27                   None   \n",
       "4                 11:25                11:50                   None   \n",
       "5                 11:28              On time                   None   \n",
       "6                 11:28                11:30                   None   \n",
       "7                 11:28                11:44                   None   \n",
       "8                  None                 None                  11:30   \n",
       "9                 11:30                11:46                   None   \n",
       "0                 11:25                11:27                   None   \n",
       "1                 11:25                11:27                   None   \n",
       "2                  None                 None                  11:27   \n",
       "3                 11:27              On time                   None   \n",
       "4                  None                 None                  11:28   \n",
       "5                  None                 None                  11:30   \n",
       "6                 11:31              On time                   None   \n",
       "7                 11:32              On time                   None   \n",
       "8                  None                 None                  11:33   \n",
       "9                  None                 None                  11:33   \n",
       "0                  None                 None                  11:20   \n",
       "1                 11:24                11:28                   None   \n",
       "2                  None                 None                  11:27   \n",
       "3                 11:29                11:31                   None   \n",
       "4                  None                 None                  11:30   \n",
       "5                 11:32                11:38                   None   \n",
       "6                  None                 None                  11:33   \n",
       "7                  None                 None                  11:33   \n",
       "8                 11:33              On time                   None   \n",
       "9                 11:35              On time                   None   \n",
       "..                  ...                  ...                    ...   \n",
       "0                 11:27              On time                   None   \n",
       "1                  None                 None                  11:30   \n",
       "2                 11:30              On time                   None   \n",
       "3                  None                 None                  11:34   \n",
       "4                 11:34                11:52                   None   \n",
       "5                  None                 None                  11:37   \n",
       "6                 11:39              On time                   None   \n",
       "7                  None                 None                  11:40   \n",
       "8                 11:41              On time                   None   \n",
       "9                  None                 None                  11:43   \n",
       "0                 11:26              On time                  11:26   \n",
       "1                  None                 None                  11:27   \n",
       "2                 11:27              On time                  11:28   \n",
       "3                 11:28              On time                   None   \n",
       "4                  None                 None                  11:30   \n",
       "5                 11:30              On time                  11:31   \n",
       "6                 11:32              On time                  11:32   \n",
       "7                 11:32              On time                   None   \n",
       "8                 11:33              On time                  11:34   \n",
       "9                 11:35              On time                   None   \n",
       "0                 11:27              On time                  11:27   \n",
       "1                 11:28              On time                  11:29   \n",
       "2                 11:29              On time                   None   \n",
       "3                  None                 None                  11:30   \n",
       "4                  None                 None                  11:35   \n",
       "5                 11:36              On time                  11:36   \n",
       "6                 11:37              On time                  11:37   \n",
       "7                  None                 None                  11:38   \n",
       "8                 11:39              On time                  11:39   \n",
       "9                 11:38              On time                  11:39   \n",
       "\n",
       "   estimatedDepartureTime            operatorName                 serviceId  \n",
       "0                    None                Southern  C3KZLGwpc5mVqAXtLqqddA==  \n",
       "1                    None         Gatwick Express  n3kC7sg34VNjLZykLpUTAA==  \n",
       "2                 Delayed                Southern  TO/B+Bk0xEzA8hpsA3qH7w==  \n",
       "3                    None                Southern  V5E4j3rgqvUbvH2XIu3EGg==  \n",
       "4                    None                Southern  bQkpxR48G80VMQ2bh6s5uw==  \n",
       "5                    None                Southern  I2Kd72hdIex0854KNiCeaA==  \n",
       "6                    None            Southeastern  yR/smJQbZ9UWWH8HvZLwpQ==  \n",
       "7                    None                Southern  GXblagTnx/oDJRfdDgkaCw==  \n",
       "8                   11:35         Gatwick Express  Qv57M9Mh4/5doFwRxWPTYg==  \n",
       "9                    None         Gatwick Express  3WO/KprwB2c0RGAU997eBQ==  \n",
       "0                    None       South West Trains  +2VqxTigVzNP/gtTpoBAkw==  \n",
       "1                    None       South West Trains  HmIKPaDMZ/yTCi5e41rrqA==  \n",
       "2                 On time       South West Trains  ahJgyDIIPUSURJa5W/EtjQ==  \n",
       "3                    None       South West Trains  F1jXwBoklj864NEy4SpdSg==  \n",
       "4                 On time       South West Trains  NeoSZU2cHiADtEhIFvX7mw==  \n",
       "5                 On time       South West Trains  cbE1sJN3fxaC4V9GBN5dmw==  \n",
       "6                    None       South West Trains  PPFnm1qXpTg+wm89iJs51g==  \n",
       "7                    None       South West Trains  FNbiiv9VvKZKJ/uzyNP0hQ==  \n",
       "8                 On time       South West Trains  yaXTy244yx7MZJOn17Th4g==  \n",
       "9                 On time       South West Trains  /Ao/tLmf4yIWpFjhebEW2g==  \n",
       "0                 Delayed   Great Western Railway  PzUjHwo+IGlsJGCetT/5mA==  \n",
       "1                    None   Great Western Railway  8somNgWjdcj2hLBODp5+Vg==  \n",
       "2                 On time   Great Western Railway  p6qSlFBLYo6HTUAWbDRMBQ==  \n",
       "3                    None   Great Western Railway  h2wPETwPdL93TvqkQsikew==  \n",
       "4                 On time   Great Western Railway  flVGmjhp0Gk4oV7uG+ipGw==  \n",
       "5                    None   Great Western Railway  84kjHfnaiFduTfh9tPY09g==  \n",
       "6                 On time   Great Western Railway  ED64ifW8K17Qo9sFjLQU+w==  \n",
       "7                 On time        Heathrow Connect  dgnE2qdBp7Dhm/f3yp5zxQ==  \n",
       "8                    None   Great Western Railway  TDQ4dBRLG4QSFN0tVyFb3A==  \n",
       "9                    None        Heathrow Express  N3UcCAcZsjHS7ZZpJkeUtg==  \n",
       "..                    ...                     ...                       ...  \n",
       "0                    None          London Midland  021LmXSTQgcyx+MdK9TxJw==  \n",
       "1                 On time           Virgin Trains  jNDUUfocPKqUAyUHD+Bbiw==  \n",
       "2                    None       London Overground  TVsRYsBn2vxVeeO+pq2PtQ==  \n",
       "3                 On time          London Midland  xvPVlG1r93UH2X0WlIOyVA==  \n",
       "4                    None           Virgin Trains  wr8J2q6aCGvoeAaENVW2LQ==  \n",
       "5                 On time       London Overground  9XpfWYXbHXzEKpmNJD3njg==  \n",
       "6                    None           Virgin Trains  UcxjcnUEphLKNhAfBWxVhw==  \n",
       "7                 On time           Virgin Trains  XCtYBosshukp62Qzu0nibg==  \n",
       "8                    None          London Midland  pn2YrrZqJGu2syXhWnRYrA==  \n",
       "9                 On time           Virgin Trains  5B5NNzwPFvR2keK8MdNT/A==  \n",
       "0                 On time            Southeastern  J7Go6oJPNX+SCHZlnANueg==  \n",
       "1                   11:29                Southern  ULtOAOx5F6upCk+gHRYaXQ==  \n",
       "2                 On time            Southeastern  z4RhS+kM07tDuAfl72NRaQ==  \n",
       "3                    None                Southern  C29vZEzOGhtVw0IQrMP0Eg==  \n",
       "4                 On time                Southern  8dUyqtoxnlCh2MRSiRhoXA==  \n",
       "5                 On time            Southeastern  JVbPWxl5dt5bj8DfniVttg==  \n",
       "6                 On time            Southeastern  9BEDPXkOCsjx7JRYY1DIYA==  \n",
       "7                    None                Southern  IKZJRTPW1ace8h2jvxPQ0g==  \n",
       "8                 On time            Southeastern  4RcKgmFcz7qD/PzVJolQcQ==  \n",
       "9                    None              Thameslink  srkQwENAdPF5m22VmfUjsg==  \n",
       "0                 On time                TFL Rail  ZTO2vFqLW9gpeXBkpfP2NA==  \n",
       "1                 On time                TFL Rail  D49Pe9/j9Ot7sGn7hKZDvg==  \n",
       "2                    None       London Overground  AY3efidnMJ+1V7Vh8XpP+g==  \n",
       "3                 On time  Abellio Greater Anglia  7qu1MaZ3A90ZU/ekh+4ksw==  \n",
       "4                 On time       London Overground  h8dkG0rH3gYoInyzDSrHHA==  \n",
       "5                 On time  Abellio Greater Anglia  +3abLa6+2M1QojLjFOFRow==  \n",
       "6                 On time                TFL Rail  z/5nahIFbnJZN6v9CYuPNg==  \n",
       "7                 On time  Abellio Greater Anglia  +huaEyUt6giaiwJDxGamng==  \n",
       "8                 On time  Abellio Greater Anglia  dGrB/wg9kBmcH6xbpY+P6w==  \n",
       "9                 On time                TFL Rail  W3vmDT1wczh1/wKiEM8t9A==  \n",
       "\n",
       "[90 rows x 9 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# List of station codes to iterate through:\n",
    "\n",
    "stat_list  = ['VIC','WAT','PAD','LST','CLJ','KGX','EUS','LBG','SRA']\n",
    "\n",
    "# Creating a blank dataframe to which we can append our results:\n",
    "\n",
    "df = pd.DataFrame(columns=['Query Code','Origin Station','Destination Station','scheduledArrivalTime','estimatedArrivalTime',\n",
    "                           'scheduledDepartureTime','estimatedDepartureTime','operatorName','serviceId'])\n",
    "\n",
    "# For loop to make the  request and clean the results:\n",
    "\n",
    "for stat in stat_list:\n",
    "\tr = requests.get(url+stat,params=values)         # Makes the request\n",
    "\tdf_stat = pd.DataFrame(r.json()) \t\t # Creates a dataframe based upon the response data\n",
    "\n",
    "\tdf_stat['Origin Station'] = ''\n",
    "\tdf_stat['Destination Station'] = ''\n",
    "\tdf_stat['Query Code'] = stat\t\n",
    "\n",
    "\tfor x in df_stat.index.values:\t\t\t\t\t\t# List comprehension to clean origin / destination variables\n",
    "\t\tdf_stat['Origin Station'][x] = df_stat['origins'][x][0]['stationName']\n",
    "\t\tdf_stat['Destination Station'][x] = df_stat['destinations'][x][0]['stationName']\n",
    "\n",
    "\tdf_stat.drop(['origins','destinations','platform','operatorCode'],axis=1,inplace=True)\n",
    "\tdf_stat = df_stat[['Query Code','Origin Station','Destination Station','scheduledArrivalTime','estimatedArrivalTime','scheduledDepartureTime','estimatedDepartureTime','operatorName','serviceId']]\n",
    "\tdf = pd.concat([df,df_stat])\n",
    "    \n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Further Reading"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<a href = \"https://zapier.com/learn/apis/chapter-2-protocols/\">Introduction to APIs</a><br/>\n",
    "<a href = \"http://docs.python-requests.org/en/master/user/quickstart/\">Requests API reference</a><br/>\n",
    "<a href = \"http://blog.smartbear.com/apis/understanding-soap-and-rest-basics/\">REST vs SOAP</a><br/>\n",
    "<a href = \"https://dev.socrata.com/docs/endpoints.html\">API Endpoints</a><br/>\n",
    "<a href = \"https://www.smartlabsoftware.com/ref/http-status-codes.htm\">HTTP Status Codes</a><br/>"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}