Untitled0.ipynb

{
 "metadata": {
  "name": ""
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "<script type=\"text/javascript\">\n",
      "    on = \"View code\";\n",
      "    off = \"Hide code\"\n",
      "    function onoff(){\n",
      "      currentvalue = document.getElementById('onoff').value;\n",
      "      if(currentvalue == off){\n",
      "        document.getElementById(\"onoff\").value=on;\n",
      "          $('div.input').hide();\n",
      "          $('div.output_prompt').hide();\n",
      "      }else{\n",
      "        document.getElementById(\"onoff\").value=off;\n",
      "          $('div.input').show();\n",
      "          $('div.output_prompt').show();\n",
      "      }\n",
      "}\n",
      "    window.onload = onoff;\n",
      "</script>\n",
      "<input type=\"button\" value=\"Hide code\" id=\"onoff\" onclick=\"onoff();\">"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "%pylab inline"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "Populating the interactive namespace from numpy and matplotlib\n"
       ]
      }
     ],
     "prompt_number": 3
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import pandas as pd"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 4
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "dat = pd.io.excel.read_excel('volumes.xlsx','Sheet1')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 5
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "plot(dat.Baseline, dat.change,'.');"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "display_data",
       "png": "iVBORw0KGgoAAAANSUhEUgAAAYYAAAEACAYAAAC3adEgAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAF1pJREFUeJzt3X9sU+e9x/HPqZJ/ELCyrnGYzZVp4hAMIYlGzbQ7dFNB\nUqCDgdgiwgqhwO0UpJWOqtBV2hombQmbugm6RmqrTKqYWOH+UZI7kYyx1hQxkaxp0Kp6EqYNV7Hj\nRG1pNKCsQHjuHyleHxKYSRz/CO+XZMU5to+/fnJ8Pj7neR7HMcYYAQDwuXvSXQAAILMQDAAAC8EA\nALAQDAAAC8EAALAQDAAAS0LB0Nvbq4ceekjz5s3T/PnztW/fPknS+fPnVVlZqaKiIlVVVWlwcDD+\nmIaGBvl8PhUXF+vo0aPx5V1dXSopKZHP59P27duT/HIAAOOVUDDk5ubq17/+td577z2dOnVKL774\nov7+97+rsbFRlZWVOnPmjJYsWaLGxkZJUigU0sGDBxUKhdTe3q5t27bpxnSJuro6NTc3KxwOKxwO\nq729feJeHQDgjiUUDPn5+SorK5MkTZ06VXPnzlU0GlVra6tqa2slSbW1tTp8+LAkqaWlRTU1NcrN\nzZXX61VhYaE6OjoUi8V04cIFBQIBSdLGjRvjjwEAZIY77mM4d+6curu7tWjRIg0MDMjlckmSXC6X\nBgYGJEl9fX3yeDzxx3g8HkWj0RHL3W63otHoeF8DACCJ7igYLl68qLVr12rv3r2aNm2adZvjOHIc\nJ6nFAQBSLyfRO169elVr167Vhg0btHr1aknDRwn9/f3Kz89XLBZTXl6epOEjgd7e3vhjI5GIPB6P\n3G63IpGItdztdo94rsLCQr3//vtjflEAcDcqKCjQ2bNnx72ehI4YjDHasmWL/H6/nnzyyfjyVatW\n6dVXX5Ukvfrqq/HAWLVqlV577TVduXJFPT09CofDCgQCys/P1/Tp09XR0SFjjPbv3x9/zBe9//77\nMsZk1OW5555Lew3UNLnqoqa7o6b//m+j//ovo+XLjT75ZGLrStYH6oSOGE6ePKnf/e53WrBggcrL\nyyUND0d95plnVF1drebmZnm9Xh06dEiS5Pf7VV1dLb/fr5ycHDU1NcVPMzU1NWnTpk26fPmyVqxY\noWXLliXlhQBAJjpzRjp+fPj6449Ln+8mM1pCwfDNb35T169fH/W2Y8eOjbr82Wef1bPPPjti+de+\n9jW9++67d1AiAGSvKVOGfy5cKL38cnprSRQznxNUUVGR7hJGoKbEZWJd1JSYbK/pwAHpu9+V/vQn\n6d57J66mZHKMMRn3j3ocx1EGlgUAGS1Z+06OGAAAFoIBAGAhGAAAFoIBAGAhGAAAFoIBAGAhGAAA\nFoIBAGAhGAAAFoIBAGAhGAAAFoIBAGAhGAAAFoIBAGAhGAAAFoIBAGAhGAAAFoIBAGAhGAAAFoIB\nAGAhGAAAFoIBAGAhGAAAFoIBAGAhGAAAFoIBAGAhGAAAFoIBAGAhGAAAFoIBAGAhGAAAFoIBAGAh\nGAAAFoIBAGBJKBg2b94sl8ulkpKS+LL6+np5PB6Vl5ervLxcbW1t8dsaGhrk8/lUXFyso0ePxpd3\ndXWppKREPp9P27dvT+LLAAAkS0LB8Nhjj6m9vd1a5jiOduzYoe7ubnV3d2v58uWSpFAopIMHDyoU\nCqm9vV3btm2TMUaSVFdXp+bmZoXDYYXD4RHrBACkX0LBsHjxYs2YMWPE8hs7/C9qaWlRTU2NcnNz\n5fV6VVhYqI6ODsViMV24cEGBQECStHHjRh0+fHic5QMAkm1cfQwvvPCCSktLtWXLFg0ODkqS+vr6\n5PF44vfxeDyKRqMjlrvdbkWj0fE8PQBgAuSM9YF1dXX6yU9+Ikn68Y9/rKeeekrNzc1JK6y+vj5+\nvaKiQhUVFUlbNwBMBsFgUMFgMOnrHXMw5OXlxa9v3bpVK1eulDR8JNDb2xu/LRKJyOPxyO12KxKJ\nWMvdbvct1//FYAAAjHTzh+bdu3cnZb1jPpUUi8Xi119//fX4iKVVq1bptdde05UrV9TT06NwOKxA\nIKD8/HxNnz5dHR0dMsZo//79Wr169fhfAQAgqRI6YqipqdHx48f10UcfadasWdq9e7eCwaBOnz4t\nx3E0e/ZsvfTSS5Ikv9+v6upq+f1+5eTkqKmpSY7jSJKampq0adMmXb58WStWrNCyZcsm7pUBAMbE\nMaMNLUozx3FGHfEEALi1ZO07mfkMALAQDAAAC8EAALAQDAAAC8EAALAQDAAAC8EAALAQDAAAC8EA\nALAQDAAAC8EAALAQDAAAC8EAALAQDAAAC8EAALAQDAAAC8EAALAQDAAAC8EAALAQDAAAC8EAALAQ\nDAAAC8EAALAQDAAAC8EAALAQDAAAC8EAALAQDAAAC8EAALAQDAAAC8EAALAQDAAAC8EAALAQDAAA\nC8EAALAkFAybN2+Wy+VSSUlJfNn58+dVWVmpoqIiVVVVaXBwMH5bQ0ODfD6fiouLdfTo0fjyrq4u\nlZSUyOfzafv27Ul8GQCAZEkoGB577DG1t7dbyxobG1VZWakzZ85oyZIlamxslCSFQiEdPHhQoVBI\n7e3t2rZtm4wxkqS6ujo1NzcrHA4rHA6PWCcAIP0SCobFixdrxowZ1rLW1lbV1tZKkmpra3X48GFJ\nUktLi2pqapSbmyuv16vCwkJ1dHQoFovpwoULCgQCkqSNGzfGHwMAyBxj7mMYGBiQy+WSJLlcLg0M\nDEiS+vr65PF44vfzeDyKRqMjlrvdbkWj0bE+PQBggiSl89lxHDmOk4xVAQDSLGesD3S5XOrv71d+\nfr5isZjy8vIkDR8J9Pb2xu8XiUTk8XjkdrsViUSs5W63+5brr6+vj1+vqKhQRUXFWEsFgEkpGAwq\nGAwmfb2OudEz/G+cO3dOK1eu1LvvvitJ2rlzp+677z7t2rVLjY2NGhwcVGNjo0KhkNavX6/Ozk5F\no1EtXbpUZ8+eleM4WrRokfbt26dAIKBHHnlETzzxhJYtWzayKMdRgmUBAD6XrH1nQkcMNTU1On78\nuD766CPNmjVLP/3pT/XMM8+ourpazc3N8nq9OnTokCTJ7/erurpafr9fOTk5ampqip9mampq0qZN\nm3T58mWtWLFi1FAAAKRXwkcMqcQRAwDcuWTtO5n5DACwEAwAAAvBAACwEAwAAAvBAACwEAwAAAvB\nAACwEAwAAAvBAACwEAwAAAvBAACwEAwAAAvBAACwEAwAAAvBAACwEAwAAAvBAACwEAwAAAvBAACw\nEAwAAAvBAACwEAwAAAvBAACwEAwAAAvBAACwEAzIao8/LlVUSCtWSIOD6a4GmBwIBmS1M2ek48el\ntrbhkAAwfgQDstqUKcM/Fy6UXn45vbUAk4VjjDHpLuJmjuMoA8tCBhocHD5SePll6d57010NkF7J\n2ncSDAAwSSRr38mpJACAhWAAAFgIBgCAhWAAAFgIBgC3xSTCuw/BAOC2mER49xl3MHi9Xi1YsEDl\n5eUKBAKSpPPnz6uyslJFRUWqqqrS4Bc+ZjQ0NMjn86m4uFhHjx4d79MDmGBMIrz7jHsew+zZs9XV\n1aUvf/nL8WU7d+7UV77yFe3cuVN79uzRJ598osbGRoVCIa1fv15//etfFY1GtXTpUp05c0b33GPn\nE/MYgMzBJMLskVHzGG4upLW1VbW1tZKk2tpaHT58WJLU0tKimpoa5ebmyuv1qrCwUJ2dnckoAchK\n2XD+/t57pUOHCIW7ybiDwXEcLV26VAsXLtQrr7wiSRoYGJDL5ZIkuVwuDQwMSJL6+vrk8Xjij/V4\nPIpGo+MtAchanL9HJsoZ7wpOnjypmTNn6sMPP1RlZaWKi4ut2x3HkeM4t3z87W4DJjvO3yMTjTsY\nZs6cKUm6//77tWbNGnV2dsrlcqm/v1/5+fmKxWLKy8uTJLndbvX29sYfG4lE5Ha7R11vfX19/HpF\nRYUqKirGWyqQcQ4c4Pw9xi4YDCoYDCZ9vePqfP700081NDSkadOm6dKlS6qqqtJzzz2nY8eO6b77\n7tOuXbvU2NiowcFBq/O5s7Mz3vl89uzZEUcNdD4DwJ1L1r5zXEcMAwMDWrNmjSTp2rVr+t73vqeq\nqiotXLhQ1dXVam5ultfr1aFDhyRJfr9f1dXV8vv9ysnJUVNTE6eSACDD8LXbADBJZNRwVQDA5EEw\nAAAsBAMAwEIwAAAsBAPwuWz4egogFQgG4HOT9espCDzcKYIB+Nxk/XqKyRp4mDgEA/C5Awek735X\n+tOfJtfXU0zWwMPEYYIbMMnx/xTuHsnadxIMADBJMPMZADAhCAYAgIVgyHAMNUQ2YrvNbgRDhmOo\nIbIR2212IxgyHEMNkY3YbrMbo5IyHEMNkY3YbtOD4aoAAAvDVQEAE4JgQMoxYgXIbAQDUo4RK0Bm\nIxiQcoxYATIbnc9IOUasABODUUk3efzx4VMUU6YMf30yOxwAdxtGJd2E89YAkByTJhg4b317jAQC\nkKhJEwyT9b9vJQtHVAASlZPuApLl3nulQ4fSXUXm4ogKQKImTedzNkplh3miI4FuVxMd/EBmY1TS\nJFBRMXx6Rxo+DZYJRzy3qykT6wVSIVs+FDEqaRLIxNM7t6spE+sFUuFu66MjGNIoEzvMb1dTJtYL\npMLd9qHorj2VlC2HhgDSL1tm69PHME6cLwcw2dDHME7ZcmjIxLTswN8Jk0lWB8N43ozZcr78buv0\nylb8nTCZZPUEt//9X6m/f/j6Y49Jr7+e+GMnakJcsvsusuXI5m7H3wmTSVqOGNrb21VcXCyfz6c9\ne/aMeT2fffav65nSU5LsT47ZcmRzt+PvhMkk5Z3PQ0NDmjNnjo4dOya3260HH3xQv//97zV37tx/\nFZVgB0plpXTsmFRWJr35Zma8IVesGA6FhQvZSQBIraztfO7s7FRhYaG8Xq9yc3O1bt06tbS0jLjf\n/fdL//d/t1/X//zP8Ke0OwmFie4k5JMjgGyX8mCIRqOaNWtW/HePx6NoNDrifh99JBUU3H7nfaOf\n4E52wBPdSTiWmgAgk6S889lxnATvWa+hIek//1N68cUKVVRUJOX56SQEMFkEg0EFg8GkrzflweB2\nu9Xb2xv/vbe3Vx6PZ5R71us//kM6eTK5n74PHMiOGYwA8O9UVNgfmnfv3p2U9aa88/natWuaM2eO\n/vznP+urX/2qAoHAqJ3P5eVGb7zBzhsAEpWszueUHzHk5OToN7/5jR5++GENDQ1py5YtVijc8M47\nqa4MACDdxd+VBACTTdYOVwUAZDaCAQBgIRgAABaCAQBgIRgAABaCAQBgIRgAABaCAQBgIRgAABaC\nAQBgIRgAABaCAQBgIRgAABaCAQBgIRgAABaCAQBgIRgAABaCAQBgIRgAABaCAQBgIRgAABaCAQBg\nIRgAABaCAQBgIRgAABaCAQBgIRgAABaCAQBgIRgAABaCAQBgIRgAABaCAQBgIRgAABaCAQBgIRgA\nAJYxB0N9fb08Ho/Ky8tVXl6utra2+G0NDQ3y+XwqLi7W0aNH48u7urpUUlIin8+n7du3j69yAMCE\nGHMwOI6jHTt2qLu7W93d3Vq+fLkkKRQK6eDBgwqFQmpvb9e2bdtkjJEk1dXVqbm5WeFwWOFwWO3t\n7cl5FSkQDAbTXcII1JS4TKyLmhJDTak3rlNJN3b4X9TS0qKamhrl5ubK6/WqsLBQHR0disViunDh\nggKBgCRp48aNOnz48HiePqUycUOgpsRlYl3UlBhqSr1xBcMLL7yg0tJSbdmyRYODg5Kkvr4+eTye\n+H08Ho+i0eiI5W63W9FodDxPDwCYALcNhsrKSpWUlIy4tLa2qq6uTj09PTp9+rRmzpypp556KlU1\nAwAmkkmCnp4eM3/+fGOMMQ0NDaahoSF+28MPP2xOnTplYrGYKS4uji8/cOCA+f73vz/q+goKCowk\nLly4cOFyB5eCgoJk7NJNjsYoFotp5syZkqTXX39dJSUlkqRVq1Zp/fr12rFjh6LRqMLhsAKBgBzH\n0fTp09XR0aFAIKD9+/friSeeGHXdZ8+eHWtZAIBxGnMw7Nq1S6dPn5bjOJo9e7ZeeuklSZLf71d1\ndbX8fr9ycnLU1NQkx3EkSU1NTdq0aZMuX76sFStWaNmyZcl5FQCApHGMGWVoEQDgrpVRM5/b29tV\nXFwsn8+nPXv2pPS5vV6vFixYoPLy8viQ2vPnz6uyslJFRUWqqqqKj7ySbj2Jbzw2b94sl8sVPy03\n1hqSPZFwtLrSPcGxt7dXDz30kObNm6f58+dr3759ktLbXreqKZ1t9c9//lOLFi1SWVmZ/H6/fvSj\nH0lKbzvdqqZ0b1OSNDQ0pPLycq1cuVJSZrz/bq4pJe2UlJ6KJLh27ZopKCgwPT095sqVK6a0tNSE\nQqGUPb/X6zUff/yxtezpp582e/bsMcYY09jYaHbt2mWMMea9994zpaWl5sqVK6anp8cUFBSYoaGh\ncdfw1ltvmXfeeSfekX+nNVy/ft0YY8yDDz5oOjo6jDHGLF++3LS1tSW9rvr6evP888+PuG+q6orF\nYqa7u9sYY8yFCxdMUVGRCYVCaW2vW9WU7ra6dOmSMcaYq1evmkWLFpkTJ06kfbsaraZ0t5Mxxjz/\n/PNm/fr1ZuXKlcaYzHj/3VxTKtopY44YOjs7VVhYKK/Xq9zcXK1bt04tLS0prcHcdFattbVVtbW1\nkqTa2tr4hLzRJvF1dnaO+/kXL16sGTNmjLmGiZpIOFpd0sj2SmVd+fn5KisrkyRNnTpVc+fOVTQa\nTWt73aomKb1tNWXKFEnSlStXNDQ0pBkzZqR9uxqtJim97RSJRHTkyBFt3bo1Xke622m0mowxE95O\nGRMM0WhUs2bNiv9+Y2JcqjiOo6VLl2rhwoV65ZVXJEkDAwNyuVySJJfLpYGBAUm3nsQ3Ee60hlRO\nJMyUCY7nzp1Td3e3Fi1alDHtdaOmr3/965LS21bXr19XWVmZXC5X/FRXuttptJqk9LbTD3/4Q/3y\nl7/UPff8a7eY7nYarSbHcSa8nTImGG6MXEqXkydPqru7W21tbXrxxRd14sQJ63bHcW5bYyrq/3c1\npFKmTHC8ePGi1q5dq71792ratGnWbelqr4sXL+o73/mO9u7dq6lTp6a9re655x6dPn1akUhEb731\nlt58803r9nS00801BYPBtLbTH/7wB+Xl5am8vHzUT+NS6tvpVjWlop0yJhjcbrd6e3vjv/f29lop\nN9FuzMm4//77tWbNGnV2dsrlcqm/v1/S8LyNvLy8UWuNRCJyu90TUted1ODxeOR2uxWJRCa8try8\nvPgbZevWrfFTaams6+rVq1q7dq02bNig1atXS0p/e92o6dFHH43XlAltJUlf+tKX9Mgjj6irqyvt\n7XRzTW+//XZa2+kvf/mLWltbNXv2bNXU1OiNN97Qhg0b0tpOo9W0cePG1LTTuHpFkujq1avmgQce\nMD09Peazzz5LaefzpUuXzD/+8Q9jjDEXL1403/jGN8wf//hH8/TTT5vGxkZjzPCM7ps7nj777DPz\nwQcfmAceeCDeyTNeX5xFbowZUw2BQMCcOnXKXL9+PSmdX6PV1dfXF7/+q1/9ytTU1KS0ruvXr5sN\nGzaYJ5980lqezva6VU3pbKsPP/zQfPLJJ8YYYz799FOzePFic+zYsbS2061qisVi8fukY5u6IRgM\nmm9961vGmMx5/32xplRsTxkTDMYYc+TIEVNUVGQKCgrMz3/+85Q97wcffGBKS0tNaWmpmTdvXvy5\nP/74Y7NkyRLj8/lMZWVlfGM2xpif/exnpqCgwMyZM8e0t7cnpY5169aZmTNnmtzcXOPxeMxvf/vb\nMdXw9ttvm/nz55uCggLzgx/8IOl1NTc3mw0bNpiSkhKzYMEC8+1vf9v09/entK4TJ04Yx3FMaWmp\nKSsrM2VlZaatrS2t7TVaTUeOHElrW/3tb38z5eXlprS01JSUlJhf/OIXxpixbdsTXVO6t6kbgsFg\nfARQJrz/jDHmzTffjNf06KOPTng7McENAGDJmD4GAEBmIBgAABaCAQBgIRgAABaCAQBgIRgAABaC\nAQBgIRgAAJb/BxyTBBp3smgzAAAAAElFTkSuQmCC\n",
       "text": [
        "<matplotlib.figure.Figure at 0x106153610>"
       ]
      }
     ],
     "prompt_number": 8
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [],
     "language": "python",
     "metadata": {},
     "outputs": []
    }
   ],
   "metadata": {}
  }
 ]
}