Analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Applications/anaconda/lib/python2.7/site-packages/pytz/__init__.py:29: UserWarning: Module argparse was already imported from /Applications/anaconda/lib/python2.7/argparse.pyc, but /Applications/anaconda/lib/python2.7/site-packages is being added to sys.path\n",
      "  from pkg_resources import resource_stream\n"
     ]
    }
   ],
   "source": [
    "# our first task is to grab only the 2012 and 2014 data\n",
    "\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "df = pd.read_csv('2014.csv')\n",
    "\n",
    "# first let's replace some dashes\n",
    "\n",
    "areas = ['Numeracy','Reading','Spelling','Writing','Grammar']\n",
    "years = ['3','5','7','9']\n",
    "for a in areas:\n",
    "    for y in years:\n",
    "        df['Year %s | %s'%(y,a)] = df['Year %s | %s'%(y,a)].replace('-',np.nan)\n",
    "        \n",
    "# now let's add an overall for each year group\n",
    "\n",
    "# First we make sure they are integers\n",
    "df[df.columns[-21:-1]] = df[df.columns[-21:-1]].astype('float')\n",
    "\n",
    "for y in years:\n",
    "    cols = []\n",
    "    for a in areas:\n",
    "        cols.append('Year %s | %s'%(y,a))\n",
    "    df['Year %s | Overall'%y] = df[cols].mean(axis=1)\n",
    "        \n",
    "now = df[df['Year'] == 2014]\n",
    "then = df[df['Year'] == 2012]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Schools with small improvements between year 3 in 2012 and year 5 in 2014\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name_x</th>\n",
       "      <th>Location_x</th>\n",
       "      <th>School sector_x</th>\n",
       "      <th>Year range_x</th>\n",
       "      <th>Full-time equivalent enrolments_x</th>\n",
       "      <th>Improv | 3-5</th>\n",
       "      <th>Year 5 | Overall_x</th>\n",
       "      <th>Year 3 | Overall_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>              Tintinara Area School, Tintinara, SA</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td> Government</td>\n",
       "      <td>    R-12</td>\n",
       "      <td> 101.4</td>\n",
       "      <td> 140.8</td>\n",
       "      <td> 512.4</td>\n",
       "      <td> 371.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>            Yankalilla Area School, Yankalilla, SA</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td> Government</td>\n",
       "      <td>    R-12</td>\n",
       "      <td> 364.2</td>\n",
       "      <td> 138.8</td>\n",
       "      <td> 494.6</td>\n",
       "      <td> 355.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>          Streaky Bay Area School, Streaky Bay, SA</td>\n",
       "      <td>       Remote</td>\n",
       "      <td> Government</td>\n",
       "      <td> U, R-12</td>\n",
       "      <td> 243.2</td>\n",
       "      <td> 135.8</td>\n",
       "      <td> 470.2</td>\n",
       "      <td> 334.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td> Evanston Gardens Primary School, Evanston Gard...</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td> Government</td>\n",
       "      <td>     R-7</td>\n",
       "      <td>   115</td>\n",
       "      <td> 134.6</td>\n",
       "      <td> 450.0</td>\n",
       "      <td> 315.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>              Yorketown Area School, Yorketown, SA</td>\n",
       "      <td>       Remote</td>\n",
       "      <td> Government</td>\n",
       "      <td>    R-12</td>\n",
       "      <td> 247.3</td>\n",
       "      <td> 130.0</td>\n",
       "      <td> 458.4</td>\n",
       "      <td> 328.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>           Paracombe Primary School, Paracombe, SA</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td> Government</td>\n",
       "      <td>     R-7</td>\n",
       "      <td>    67</td>\n",
       "      <td> 124.6</td>\n",
       "      <td> 506.4</td>\n",
       "      <td> 381.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>  John Hartley School (B-7), Smithfield Plains, SA</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td> Government</td>\n",
       "      <td>  U, R-7</td>\n",
       "      <td>   545</td>\n",
       "      <td> 123.4</td>\n",
       "      <td> 436.0</td>\n",
       "      <td> 312.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>         Felixstow Community School, Felixstow, SA</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td> Government</td>\n",
       "      <td>     R-7</td>\n",
       "      <td>    72</td>\n",
       "      <td> 122.0</td>\n",
       "      <td> 467.2</td>\n",
       "      <td> 345.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>           Padthaway Primary School, Padthaway, SA</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td> Government</td>\n",
       "      <td>     R-7</td>\n",
       "      <td>    49</td>\n",
       "      <td> 119.2</td>\n",
       "      <td> 463.2</td>\n",
       "      <td> 344.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td> Lonsdale Heights Primary School, Christie Down...</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td> Government</td>\n",
       "      <td>     R-7</td>\n",
       "      <td>    87</td>\n",
       "      <td> 118.6</td>\n",
       "      <td> 499.8</td>\n",
       "      <td> 381.2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              Name_x    Location_x  \\\n",
       "0               Tintinara Area School, Tintinara, SA    Provincial   \n",
       "1             Yankalilla Area School, Yankalilla, SA    Provincial   \n",
       "2           Streaky Bay Area School, Streaky Bay, SA        Remote   \n",
       "3  Evanston Gardens Primary School, Evanston Gard...  Metropolitan   \n",
       "4               Yorketown Area School, Yorketown, SA        Remote   \n",
       "5            Paracombe Primary School, Paracombe, SA    Provincial   \n",
       "6   John Hartley School (B-7), Smithfield Plains, SA  Metropolitan   \n",
       "7          Felixstow Community School, Felixstow, SA  Metropolitan   \n",
       "8            Padthaway Primary School, Padthaway, SA    Provincial   \n",
       "9  Lonsdale Heights Primary School, Christie Down...  Metropolitan   \n",
       "\n",
       "  School sector_x Year range_x Full-time equivalent enrolments_x  \\\n",
       "0      Government         R-12                             101.4   \n",
       "1      Government         R-12                             364.2   \n",
       "2      Government      U, R-12                             243.2   \n",
       "3      Government          R-7                               115   \n",
       "4      Government         R-12                             247.3   \n",
       "5      Government          R-7                                67   \n",
       "6      Government       U, R-7                               545   \n",
       "7      Government          R-7                                72   \n",
       "8      Government          R-7                                49   \n",
       "9      Government          R-7                                87   \n",
       "\n",
       "   Improv | 3-5  Year 5 | Overall_x  Year 3 | Overall_y  \n",
       "0         140.8               512.4               371.6  \n",
       "1         138.8               494.6               355.8  \n",
       "2         135.8               470.2               334.4  \n",
       "3         134.6               450.0               315.4  \n",
       "4         130.0               458.4               328.4  \n",
       "5         124.6               506.4               381.8  \n",
       "6         123.4               436.0               312.6  \n",
       "7         122.0               467.2               345.2  \n",
       "8         119.2               463.2               344.0  \n",
       "9         118.6               499.8               381.2  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Schools with small improvements between year 5 in 2012 and year 7 in 2014\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name_x</th>\n",
       "      <th>Location_x</th>\n",
       "      <th>School sector_x</th>\n",
       "      <th>Year range_x</th>\n",
       "      <th>Full-time equivalent enrolments_x</th>\n",
       "      <th>Improv | 5-7</th>\n",
       "      <th>Year 7 | Overall_x</th>\n",
       "      <th>Year 5 | Overall_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>           Echunga Primary School, Echunga, SA</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>     Government</td>\n",
       "      <td>    R-7</td>\n",
       "      <td>    71</td>\n",
       "      <td> 119.6</td>\n",
       "      <td> 610.6</td>\n",
       "      <td> 491.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>           Kaurna Plains School, Elizabeth, SA</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>     Government</td>\n",
       "      <td>   R-12</td>\n",
       "      <td>  63.7</td>\n",
       "      <td> 112.4</td>\n",
       "      <td> 472.8</td>\n",
       "      <td> 360.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>                 Robe Primary School, Robe, SA</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>     Government</td>\n",
       "      <td>    R-7</td>\n",
       "      <td>    87</td>\n",
       "      <td> 108.2</td>\n",
       "      <td> 602.4</td>\n",
       "      <td> 494.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>              Carlton School, Port Augusta, SA</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>     Government</td>\n",
       "      <td>    R-9</td>\n",
       "      <td>    60</td>\n",
       "      <td> 104.2</td>\n",
       "      <td> 460.4</td>\n",
       "      <td> 356.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td> Whyalla Stuart Campus R-7, Whyalla Stuart, SA</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>     Government</td>\n",
       "      <td>    R-7</td>\n",
       "      <td>   104</td>\n",
       "      <td>  98.0</td>\n",
       "      <td> 463.8</td>\n",
       "      <td> 365.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>     Willsden Primary School, Port Augusta, SA</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>     Government</td>\n",
       "      <td>    R-7</td>\n",
       "      <td>   143</td>\n",
       "      <td>  97.6</td>\n",
       "      <td> 474.0</td>\n",
       "      <td> 376.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>        Yankalilla Area School, Yankalilla, SA</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>     Government</td>\n",
       "      <td>   R-12</td>\n",
       "      <td> 364.2</td>\n",
       "      <td>  97.2</td>\n",
       "      <td> 517.0</td>\n",
       "      <td> 419.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>            North Ingle School, Ingle Farm, SA</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>     Government</td>\n",
       "      <td>    R-7</td>\n",
       "      <td>   139</td>\n",
       "      <td>  93.0</td>\n",
       "      <td> 526.0</td>\n",
       "      <td> 433.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td> Blair Athol North School B-7, Blair Athol, SA</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>     Government</td>\n",
       "      <td> U, R-7</td>\n",
       "      <td>   429</td>\n",
       "      <td>  91.0</td>\n",
       "      <td> 485.6</td>\n",
       "      <td> 394.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>                St Thomas School, Goodwood, SA</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td> Non-government</td>\n",
       "      <td>    R-7</td>\n",
       "      <td>   353</td>\n",
       "      <td>  90.2</td>\n",
       "      <td> 589.0</td>\n",
       "      <td> 498.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          Name_x    Location_x  \\\n",
       "0            Echunga Primary School, Echunga, SA    Provincial   \n",
       "1            Kaurna Plains School, Elizabeth, SA  Metropolitan   \n",
       "2                  Robe Primary School, Robe, SA    Provincial   \n",
       "3               Carlton School, Port Augusta, SA    Provincial   \n",
       "4  Whyalla Stuart Campus R-7, Whyalla Stuart, SA    Provincial   \n",
       "5      Willsden Primary School, Port Augusta, SA    Provincial   \n",
       "6         Yankalilla Area School, Yankalilla, SA    Provincial   \n",
       "7             North Ingle School, Ingle Farm, SA  Metropolitan   \n",
       "8  Blair Athol North School B-7, Blair Athol, SA  Metropolitan   \n",
       "9                 St Thomas School, Goodwood, SA  Metropolitan   \n",
       "\n",
       "  School sector_x Year range_x Full-time equivalent enrolments_x  \\\n",
       "0      Government          R-7                                71   \n",
       "1      Government         R-12                              63.7   \n",
       "2      Government          R-7                                87   \n",
       "3      Government          R-9                                60   \n",
       "4      Government          R-7                               104   \n",
       "5      Government          R-7                               143   \n",
       "6      Government         R-12                             364.2   \n",
       "7      Government          R-7                               139   \n",
       "8      Government       U, R-7                               429   \n",
       "9  Non-government          R-7                               353   \n",
       "\n",
       "   Improv | 5-7  Year 7 | Overall_x  Year 5 | Overall_y  \n",
       "0         119.6               610.6               491.0  \n",
       "1         112.4               472.8               360.4  \n",
       "2         108.2               602.4               494.2  \n",
       "3         104.2               460.4               356.2  \n",
       "4          98.0               463.8               365.8  \n",
       "5          97.6               474.0               376.4  \n",
       "6          97.2               517.0               419.8  \n",
       "7          93.0               526.0               433.0  \n",
       "8          91.0               485.6               394.6  \n",
       "9          90.2               589.0               498.8  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Schools with small improvements between year 7 in 2012 and year 9 in 2014\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name_x</th>\n",
       "      <th>Location_x</th>\n",
       "      <th>School sector_x</th>\n",
       "      <th>Year range_x</th>\n",
       "      <th>Full-time equivalent enrolments_x</th>\n",
       "      <th>Improv | 7-9</th>\n",
       "      <th>Year 9 | Overall_x</th>\n",
       "      <th>Year 7 | Overall_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>     Mount Barker Waldorf School, Mount Barker, SA</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td> Non-government</td>\n",
       "      <td>    R-12</td>\n",
       "      <td>   284</td>\n",
       "      <td> 81.6</td>\n",
       "      <td> 597.8</td>\n",
       "      <td> 516.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td> Booleroo Centre District School, Booleroo Cent...</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>     Government</td>\n",
       "      <td>    R-12</td>\n",
       "      <td> 230.2</td>\n",
       "      <td> 72.0</td>\n",
       "      <td> 611.4</td>\n",
       "      <td> 539.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>    Allendale East Area School, Allendale East, SA</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>     Government</td>\n",
       "      <td>    R-12</td>\n",
       "      <td>   199</td>\n",
       "      <td> 61.4</td>\n",
       "      <td> 629.6</td>\n",
       "      <td> 568.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>            Yankalilla Area School, Yankalilla, SA</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>     Government</td>\n",
       "      <td>    R-12</td>\n",
       "      <td> 364.2</td>\n",
       "      <td> 61.0</td>\n",
       "      <td> 560.6</td>\n",
       "      <td> 499.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>                      Clare High School, Clare, SA</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>     Government</td>\n",
       "      <td> U, 7-12</td>\n",
       "      <td> 490.6</td>\n",
       "      <td> 59.0</td>\n",
       "      <td> 569.6</td>\n",
       "      <td> 510.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>            St Michael's College, Henley Beach, SA</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td> Non-government</td>\n",
       "      <td>    R-12</td>\n",
       "      <td>  1616</td>\n",
       "      <td> 57.2</td>\n",
       "      <td> 585.0</td>\n",
       "      <td> 527.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>        Pedare Christian College, Golden Grove, SA</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td> Non-government</td>\n",
       "      <td>    R-12</td>\n",
       "      <td> 880.2</td>\n",
       "      <td> 56.6</td>\n",
       "      <td> 596.6</td>\n",
       "      <td> 540.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>                  Orroroo Area School, Orroroo, SA</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>     Government</td>\n",
       "      <td>    R-12</td>\n",
       "      <td> 125.2</td>\n",
       "      <td> 56.4</td>\n",
       "      <td> 581.4</td>\n",
       "      <td> 525.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>              Tintinara Area School, Tintinara, SA</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>     Government</td>\n",
       "      <td>    R-12</td>\n",
       "      <td> 101.4</td>\n",
       "      <td> 56.4</td>\n",
       "      <td> 596.0</td>\n",
       "      <td> 539.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>                  Eudunda Area School, Eudunda, SA</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>     Government</td>\n",
       "      <td>    R-12</td>\n",
       "      <td> 121.4</td>\n",
       "      <td> 55.6</td>\n",
       "      <td> 532.4</td>\n",
       "      <td> 476.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              Name_x    Location_x  \\\n",
       "0      Mount Barker Waldorf School, Mount Barker, SA    Provincial   \n",
       "1  Booleroo Centre District School, Booleroo Cent...    Provincial   \n",
       "2     Allendale East Area School, Allendale East, SA    Provincial   \n",
       "3             Yankalilla Area School, Yankalilla, SA    Provincial   \n",
       "4                       Clare High School, Clare, SA    Provincial   \n",
       "5             St Michael's College, Henley Beach, SA  Metropolitan   \n",
       "6         Pedare Christian College, Golden Grove, SA  Metropolitan   \n",
       "7                   Orroroo Area School, Orroroo, SA    Provincial   \n",
       "8               Tintinara Area School, Tintinara, SA    Provincial   \n",
       "9                   Eudunda Area School, Eudunda, SA    Provincial   \n",
       "\n",
       "  School sector_x Year range_x Full-time equivalent enrolments_x  \\\n",
       "0  Non-government         R-12                               284   \n",
       "1      Government         R-12                             230.2   \n",
       "2      Government         R-12                               199   \n",
       "3      Government         R-12                             364.2   \n",
       "4      Government      U, 7-12                             490.6   \n",
       "5  Non-government         R-12                              1616   \n",
       "6  Non-government         R-12                             880.2   \n",
       "7      Government         R-12                             125.2   \n",
       "8      Government         R-12                             101.4   \n",
       "9      Government         R-12                             121.4   \n",
       "\n",
       "   Improv | 7-9  Year 9 | Overall_x  Year 7 | Overall_y  \n",
       "0          81.6               597.8               516.2  \n",
       "1          72.0               611.4               539.4  \n",
       "2          61.4               629.6               568.2  \n",
       "3          61.0               560.6               499.6  \n",
       "4          59.0               569.6               510.6  \n",
       "5          57.2               585.0               527.8  \n",
       "6          56.6               596.6               540.0  \n",
       "7          56.4               581.4               525.0  \n",
       "8          56.4               596.0               539.6  \n",
       "9          55.6               532.4               476.8  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "from IPython.display import display\n",
    "cohorts = [5,7,9]\n",
    "\n",
    "for coh in cohorts:\n",
    "    \n",
    "    # let's grab the fourteen data that has year coh naplan scores\n",
    "    \n",
    "    #for a in areas:\n",
    "    #    now = now[now['Year %s | %s'%(str(coh),a)].notnull()]\n",
    "    \n",
    "    # now let's merge it with the twelve data with year (coh-2) scores\n",
    "    \n",
    "    #for a in areas:\n",
    "    #    then = then[then['Year %s | %s'%(str(coh-2),a)].notnull()]\n",
    "\n",
    "    newdf = pd.merge(now,then,on='SMCLID')\n",
    "    \n",
    "    # now let's see what the worst improvers are\n",
    "\n",
    "    newdf['Improv | %s-%s'%(str(coh-2),str(coh))] = newdf['Year %s | Overall_x'%str(coh)] - newdf['Year %s | Overall_y'%str(coh-2)]\n",
    "    print 'Schools with small improvements between year %s in 2012 and year %s in 2014'%(str(coh-2),str(coh))\n",
    "    display(newdf.sort('Improv | %s-%s'%(str(coh-2),str(coh)),ascending=False)[:10].reset_index()[['Name_x','Location_x','School sector_x','Year range_x','Full-time equivalent enrolments_x','Improv | %s-%s'%(str(coh-2),str(coh)),'Year %s | Overall_x'%str(coh),'Year %s | Overall_y'%str(coh-2)]])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Populating the interactive namespace from numpy and matplotlib\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x10da28550>"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": [
       "iVBORw0KGgoAAAANSUhEUgAAAY0AAAEQCAYAAABMXyhMAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\n",
       "AAALEgAACxIB0t1+/AAAIABJREFUeJztnX2cXVV5779PCKQJMSQTbwMqNVhEgVKQqxZb1ChC1Nui\n",
       "yC3VT7URKa2ipnQCBVK03KoRbRNp2qtelZpY0QtaQeytJCMlfdMCBqLhTUBJC62EmiGmvIWXee4f\n",
       "a53MmZlzzuxzzj5n7TXn9/181mf2+/6dlZ397PU8az3L3B0hhBCiCLNSCxBCCJEPMhpCCCEKI6Mh\n",
       "hBCiMDIaQgghCiOjIYQQojAyGkIIIQrTF6NhZn9pZjvNbHvdtiEzGzGzu81ss5ktrNt3kZndY2Z3\n",
       "mdkp/dAohBBievrV0vg88PpJ2y4ERtz9COD6uI6ZHQX8BnBUPOeTZqYWkRBCVIC+vIzd/R+Bhydt\n",
       "PhXYGJc3Am+Oy28CvuzuT7n7DuBe4OX90CmEEKI1Kb/gl7j7zri8E1gSl58DPFB33APAc/spTAgh\n",
       "RGMq4fbxkMukVT4T5ToRQogKMDvhvXea2cHu/qCZHQI8FLf/O3Bo3XHPi9smYGYyJEII0QHubp2e\n",
       "m9JoXAusAD4W/15Tt/1LZraO4JZ6IXBTowt088NTY2aXuPslqXV0ivSnRfrTkbN26P6Duy9Gw8y+\n",
       "DLwaeLaZ3Q98ELgUuMrMzgJ2AGcAuPsdZnYVcAfwNHCOz8xUvEtTC+iSpakFdMnS1AK6ZGlqAV2y\n",
       "NLWALliaWkBK+mI03P1tTXa9rsnxa4A1vVMkhBCiEyoRCB9QNqQW0CUbUgvokg2pBXTJhtQCumRD\n",
       "agFdsCG1gJRYrp4fM/OcYxpCCJGCbt+damkkwsyWpdbQDdKfFulPR87ay0BGQwghRGHknhJCiAFC\n",
       "7ikhhBB9Q0YjEbn7RaU/LdKfjpy1l4GMhhBCiMIopiGEEAOEYhpCCCH6hoxGInL3i0p/WqQ/HTlr\n",
       "LwMZDSGEEIVRTEMIIQYIxTSEEEL0DRmNROTuF5X+tEh/OnLWXgYyGkIIIQqjmIYQQgwQimkIIYTo\n",
       "GzIaicjdLyr9aZH+dOSsvQxkNIQQQhRGMQ0hhBggFNMQQgjRN2Q0EpG7X1T60yL96chZexnIaAgh\n",
       "hCiMYhpCCDFAKKYhhBCib8hoJCJ3v6j0p0X605Gz9jKQ0RBC9BwzW262eHMotjy1HtE5yWMaZnYR\n",
       "8HZgDNgOnAkcCFwJPB/YAZzh7rsnnaeYhhAZEIzEgqth/dywZeXjsOc0d9+UVtlgknVMw8yWAmcD\n",
       "x7v7McB+wFuBC4ERdz8CuD6uCyGyZGhVMBgrCGX93LBN5Ehq99Qe4ClgnpnNBuYB/wGcCmyMx2wE\n",
       "3pxGXu/I3S8q/WnJXT88uSi1gk7Jv+67Y3bKm7v7qJmtBf4NeBzY5O4jZrbE3XfGw3YCS5KJFEJ0\n",
       "yehaWHkiUOeeeuSqpJJExySNaZjZzwPfAF4J/BT4CvDXwJ+7+6K640bdfWjSuYppCJEJIa5Rc0mN\n",
       "rlU8Ix3dvjuTtjSAlwLfdvddAGb2NeAVwINmdrC7P2hmhwAPNTrZzDYQAuUAu4Ft7r4l7lsGoHWt\n",
       "az39OrAXRtdURc8grcfldxLYQZekbmkcC1wBvAx4AtgA3EToNbXL3T9mZhcCC939wknnZt3SMLNl\n",
       "df+hskP60yL96chZO2Te0nD375nZF4DvErrc3gJ8BngWcJWZnUXscptMpBBCiH0kH6fRKbm3NIQQ\n",
       "IgVZj9MQQgiRFzIaici9r7f0p0X605Gz9jKQ0RBCCFEYxTSEEGKAUExDCCFE35DRSETuflHpT4v0\n",
       "pyNn7WUgoyGEEKIwimkIIcQAoZiGEGJGYprtr5LIaCQid7+o9Kdlpuu3fbP9rTs5lAVXV8Vw5F73\n",
       "3ZI6y60QQjRgaBWsi7P9ATAXhlcBSqmeGLU0EpFzlkyQ/tRIfzpy1l4GamkIISpIo9n+9qxNKkkA\n",
       "amkkI3e/qPSnZabrDzP77TkNhkdC2XNaVWb7y73uu0UtDSFEJYlGohKGQoyjcRpCCDFAaJyGEEKI\n",
       "viGjkYjc/aLSnxbpT0fO2stARkMIIURhFNMQQogBQjENIYQQfUNGIxG5+0WlPy3Sn46ctZeBjIYQ\n",
       "QojCKKYhhBADhGIaQggh+oaMRiJy94tKf1qkPx05ay8DGQ0hhBCFUUxDCDFjCbP9Da0Ka6Nrq5Ip\n",
       "NyXdvjtlNISYgehlWT9l7Pr6OTkqk2I9FdkHws1soZl91czuNLM7zOyXzGzIzEbM7G4z22xmC1Pr\n",
       "LJvc/aLSn5ZW+qs8v3aN/tT/0KpgMFYQyvq544a0c3J/droludEA/gz4W3c/EvhF4C7gQmDE3Y8A\n",
       "ro/rQohC9OZlKQQknoTJzA4CXunuKwDc/Wngp2Z2KvDqeNhGYAszzHDkPs+w9KdF+ovQmyljc6/7\n",
       "bkka0zCz44D/A9wBHAtsBc4FHnD3RfEYA0Zr63XnKqYhRAOK+vIHIe4xCL+xXbp+d7p7sgK8FHgK\n",
       "eFlcvwz4EPDwpONGG5zrwAbgkljOBZbV7V9W8fXc9Ep/tdan038+zL8ZhjYDyxvvn/cEbPBQ5j0B\n",
       "nF8h/ZVdry1XRU9BvRsYf1967bhOSuqWxsHAd9z9sLh+InAR8ALgNe7+oJkdAtzg7i+edK57xi0N\n",
       "M1vmGTdzpT8t3eo3W7w5BMlXxC0bgeER912nlCJw2vvnW/85a4fMe0+5+4PA/WZ2RNz0OuB24BuM\n",
       "P80rgGsSyOspOT90IP2pSanfzJabLd4cSme9snKu/5y1l0HycRpmdizwOeAA4IfAmcB+wFXAzwE7\n",
       "gDPcffek87JuaQiRkk7HMLR7nmIK1UOD+zJlBjRxpT8hZehv54Ved+zxsG5xEbdWNDBfh/VzwpaV\n",
       "e2HPm9x9U871n7N26P7dmbTLrRCDRNW+uuP9p9VQN1hwLny6jTssXAOXzRk3MMyBc9cUuaeoLjIa\n",
       "icj5SwWkv10mvngBVp5oZh2ntOiv/qFVQffBBM/xuXX7Wo19mPX8Zttyfn5y1l4GMhpC9IXai3ff\n",
       "V/dcGF5Fwa/uXrRS2rvmduAC4GNx+VyAW2DP6ubn7f1XOG/x+Pp5cZvImSqkERlIcs9fI/39o0ku\n",
       "qfN7cM0mPaFG18LlY8FgrAD+lDCkatau1obm0dXw2N7g0vo0YfnR1fH+y7rRn5KctZdBy5aGmb0W\n",
       "OB04FHgG+AHwOXe/tw/ahJhBdJPSolEr5X1nAH/SuZ7iLZ8QuF60DTi+nTvEgPeb4O7YmnkseRxH\n",
       "dE9To2FmlxKcmNfHv/cBPwK+YmYfdfer+iNxZpK7X1T6277fJjM7Lb6YgT1dvkAPeLgcZUXZvRpW\n",
       "Xk0To9fM1dUs2N6v+u+FWy/3Z79bmna5NbPb3P0X4vJs4B/c/ZfNbBHwT+5+dB91NtKXdZdbIYrS\n",
       "i3khOrlmsxdwVeetqKqu1PQs9xTwPWBxXH4+8C91+27vJndJGYUu86ekLtTlicmxSH/f9S4PeaTG\n",
       "c0l1eu7U7Qu3woFbJ+8vfv2hzSF/lceywWFoc5n13+w3lK1rJj47DfR7N+e3immsAW4xs3uAFwHv\n",
       "iVbqZ6NBEUL0CZ/k5ikajG3V1deDy4yw/3837ApchbElZrYaFn4InjMLngbGTjKzD7j7mn5rEbTO\n",
       "cgssBl4GLEptHcu2lioqg1CafG3/hPi13uprHFgOCx4bz4S74DEafOUXPa4z/SyHBc+MX/vZDqs8\n",
       "bGt9j17qyrl0++5s2XvK3XcBu2rrZnaJu19SmsUSQiTgiMVwx9UhMD9EGHdxetx3WN1x0/ewGm+J\n",
       "jN0J7wXm7Oo+yF/P0CpYN6tOA3AtsH7WdONcvPTOBwLaH6fxpp6oGEBy7+st/Wkprn90bQgAbySU\n",
       "CwhTKtSmgB3dAp8FTo3ls4RthTTUjfW47HjY78iiLqx+1b+7b3LfdUoo5RiM3J+dbtGIcCFmMHVf\n",
       "21eEFsZGQhx9YzxiaBmsY/xLfjvw+WGzxcuC8Wg1tqS7Ue7FmDy+5byotZypW2tUIXaTDW36wvZL\n",
       "7Y8ryy+nojJIhSb+/YkxjetizGDCMaub9VrqVe+kxtq77+XVbt2k/jfr4bPgXZ3f4sKfAE5M/QN7\n",
       "9cNVVHIpdNDdtOh1Jr4wT/B2jMBMedn2y/hVpXT77mwV03g7cJmZ/ZuZfdzMXlJCw0ZEcveLSn9/\n",
       "aJYjqhP93sC/H/7uOQ2GR+C2PSFH1OkU8TBNPHd4pMjgwLoZ/9rKnVXGbIFlkcuz0ytaxTQecPeX\n",
       "xqlY3wp8MY4M/xLwZXe/uy8KhRhoDlwDR80NPYZ+hxDAHl4Fo6WNUfDx8Rpfh3fHrW8nJBh8rGXc\n",
       "wDuakwPgnFeZ2fdbGZnm53aXVn4q3eQFG0BaNGFubbDtWOBS4Ie5N7FUVKpemDJGYUkco1A/jmLC\n",
       "KPGO3ViNXTQL95QVP+jGBTR+7nUOb4lutAO3ll/X3bsAcyjdvjvb6j3l7t8jjAa/sDtTJYSYnkZj\n",
       "FM4dg91rG3x9vyqMll5Xm1p139d45z2DXvwsePfJ033Zt85JVds+trjRucWpn88DYOVxZra8XlM3\n",
       "PaC8YItJ0LKl8azUFrGX1jJ1If/8NdLfc40Nv/63hn3zb56674QpX/J0PKp7yOFX4pf9eOtm+vNq\n",
       "vbImb5/3BCx4YuJ60RxSLIeFz7RqqRT9nYPy7Eyj37s5v2lLw93/q1zzJIRoj4a+9tXtXaPYWAqf\n",
       "MHp67AQYexacHfeeB+xt0lJoen0mbZ8D770FhmOGicdGvGBLwAvN59GPMSMCNLgvGZ55Tn7p7z3e\n",
       "Mg3GIxdPmt9ib3BPbZwzvv7MYpjz/HbuB2wyW7QV1h8/yS3W7c8B5uxy33VKs72t3Uut5/MoShmD\n",
       "+HJ4dnpK6qZSqiaWikruhYnB29Vh8Nv8n8JBj8JBzwS30iqHBZMH7E2T6K9Y0Drc/8CtE4P19e6p\n",
       "eU8El9kJ07qjKOBeokWwuvj5+Y8rKeG58a7OT/0DUv3w1IX8/aLSXxH94y/DVT5xRPeS2OPodIdF\n",
       "T8bstqsLXLvNF/AqDzGHhVtrx8X9dTGMBROMxuT6L2OAXbjnwq3hdx64darmcgbxzYBnx7s5v9V0\n",
       "rzcUb6z4awseK8RA0KkbpLPzav78a4E/ZaJb6aPA7cAn9gcWw8qLzWxrq+t6oeywk2MIx8yC4V3j\n",
       "xw2tCj256mMa/YgxjB0Jl80l/Naryx3PIaB1TOPMvqkYQDxzv6j0N6fTwWjtnFdc/w+ZZEgKBYi9\n",
       "N11Qj691k52qf3LQ/5y9cMBis8Wb2zeezX5rOYP4cn/2uyZ1UylVE0tFpVelUzdI5+c1c08teCbE\n",
       "OHoy5WlLF9bU/fsmT2oaR2BfzOLArZNcW4ViD0XqjxZxkUEp3b471XsqEWa2zDP+YpH+tNTr933u\n",
       "pM+vCl1jzwVm7Rr/iu6+11HdfaP7bAgY/TAMLwt7JrqwxjWd+xWY/6wwY/TJwDFzYXiVme2t6Q/T\n",
       "uQ4Nx2uui+na57TffXb6loSX0ILK/dnplkoYDTPbD/guId/Vr5nZEHAl8HxgB3CGu+9OKFGINujU\n",
       "DdK5+6TVy7CT2esaxVYauc9gdBq329iB8OG4vIKQ02rCfVbDgo+EOT0AVn4Enrl3On2N8EKxmPIY\n",
       "2Dk4CjRl/lsfmkvDwBXAtXH948AfxOULgEvLbmKpqPSy0IEbhH1dWId+Ut8TKY326ebe8LivNr9F\n",
       "0fk2Fk6Y2zv81snHzP9p1bvGNquj1LoKavduzi/S0vi2md1H+PL/mrs/3J2ZmoiZPQ94I/ARgvGA\n",
       "MO/kq+PyRmALynclMsLbdIOMf8Wvr33Fz+uRtAK0GuVdz3Zgv+NCfiwoGPDfNs1+4ICnYPSMas/t\n",
       "Pbgj0Kc1Gu7+QjP7JUJ69D80szuAK939r0rS8AngfGBB3bYl7r4zLu8ElpR0r8qQu19U+sumvZdQ\n",
       "7/VvJ8yrAXBY/Du6BVaeBLV5eC4fg/Wz2uyttHqi/tF1wSVVYyWwZ127RreeXruNwnwaQ2VeMisK\n",
       "xTTc/UbgRjP7COElvxHo2miY2a8CD7n7rc0mNnF3NzNvcv4GQswDYDfhK2ZL3Lcsnl/JdeA4M6uM\n",
       "HulPrefJRXAn49wZtwX6q390C3zqZHg/cCTxRf4MzPsgnD0rTNS0fQz8x8Bzg5wtUXPoVgvsDWVP\n",
       "jDE8uQgeuaruBV7TvybM5fH+C8Lm//pY3NaRfmBOaLGdHQ3Vp04McQ72llc/AKMjcM6rwv0gdBF+\n",
       "bCRqSP481a/H5XdGaTvolgL+r4PiDb8J3EOIN/z3bnxidddeA9wP3Af8GHiUYIzuAg6OxxwC3NXg\n",
       "XC9Dg4pKFQoV8pE36braIPZw4NZ2u9Um0t6TqVvJtPtut+/OVtO91tgGHAf8MXCEu/+Bu2/tylJF\n",
       "3H21ux/q7ocR3F9/5+7vIAxtrbV5VwDXlHE/IaqKT5069cMwtKrZ9KbW4fSn7Z+3idCy8AXBZVXP\n",
       "nF1R865wzBcJAwnXzx13D81cvMH0uQNBAas0K/6dD8zvofV7NeO9p4aAbwF3A5uBhWVby9SF/PPX\n",
       "SH/vtBUYODdv8uC31dN99U533anXf7HDwvrBgrElMfHcTr7ue1X/RX/jTH12Cur3rs4vcINjgFuB\n",
       "f4tlK/ALuf/w1GUGPHjS39l9p3VpTPcSDvsvqNu/yhtlmm33uhM1LogZahu5qSZqb/dFHY6ff3P9\n",
       "dYrUS5l1nOOzU6J+7+b8IoHwzwDD7n4D7AuwfAb45QLniiZ4pXrutI/0t0+DwXEnmc3fBo/+dRgF\n",
       "DaHHUZGeOUfWLf8zrXsxtUst2eC1jXbeMnlODJ86qG5LcK3NXwP7E0anTx4guK9r8Ylm9mFYcHG7\n",
       "ubqa4T2eujX3Z79rClil7xXZlpu1VFHpd2n8pX9CI7fP6vbyOjWaCjVMCzvx/pPPm/MkLNozOWX6\n",
       "uM7rPKRXb2cujqZ5sFoMEGwUZO9N8FqlPy2N+8zsA4ReTQb8JvCjsozWoFK9cQLtIf1l8Rzg3Yyn\n",
       "NWduyOc02jAdxvgYhL33w3sfCcHoxw+D8w4fv+Yw8PThtQyxYdvkfFGPHgZzDo8p04GVH6l1gR0f\n",
       "X7F+bkj7ce4YsA32rPZpv/6bpmmfNEBwC7Cs/eqqANV5dtJQxGicSeg59bW4/o/Au3qmSIgZy+TB\n",
       "bucDRxB6Hu034Uhv4GKZ6N66E/jU48G4DK2CFYeHF/UuwrSvf7EAODmMJZhNcDdtBy4/Cca2wf4/\n",
       "C+uZOPfG8DCwxqe4m3aXOECuVgfvmQv/Shzwtw5WXkxJSRVFj5mmGTMbuCF1c6oXTSwVlRSFfbPL\n",
       "HfTMxGlYh7zZGAfGA7s/Ccd4nRvnwK3hegvj9K6Tg9e19SmuJp96rYV7iv+G6aZdbeyeanZ+q2uq\n",
       "lP4MelfnF7jB9TTo8pq6yGio9KP06mUWXvSNfPvTzWv97GgAvFGvqQbzZ9SMxlsa9YTyidedd0+x\n",
       "+ig6l3fNoMkQVKl0++4s4p56FNhuZiNxuXbTle21aUQ9uftFB0F/o1Tgk3v1dJ7naNauBhtvmXr+\n",
       "lJxUwCXADTTI/TQLzr0XVh7JPlfP9/eGNCBHzZl6u0WM95BaAXz+vul1T58jywv0Xsr5+clZexkU\n",
       "MRpfi8XjutUtixIY2Lz8laf1C7KIUWlON1OP3r0LbrsPZs8Cjp+4b9Yu2F0Xj3gsXnP7Glj5EsL/\n",
       "X+A84DHgzYShWIojiIIUbM7MAY4FfhE4IHXzqowmVlUKFco5pDL536bIILtW+1u7tqbbP93z0e6z\n",
       "E9xFJ0RX1XV1LrF25/xo/3kt8ltV+vVc412dX+AG/4OQVPDvY7kfeGPuP7wqpZ8J1lTa/beZLp1H\n",
       "83+7Mj8GWr1w23kZl/WstWsA9GFUrdIPo/ED4PC69Z8HfpD7D09diKkIcjUa5J9KoZD+6V/YzVoB\n",
       "vf137aT+U728G9fF/JtTPwP9rPsqlW7fnUViGnvcvX7O3h8BewqcJwrRjW9b9BpvEdT1Ps9J3S25\n",
       "6RXVxKLlaX6A2aeBnwOuipt+nZC4cATA3b/W5NSeYmbu7pbi3mWjQPjMo0GOpcdhT8f5lHJGdVEt\n",
       "un13FjEaG+Jiw95T7n5mpzfvhplkNMTMpGofA5P0bKlPkthrbVWri0Gm50ajquRuNHLv6y39aWlX\n",
       "f4OvfeBs6rrb7vvy78cLPuf6z1k7dP/unDamYWYvIEwWvLTueHf3Uzu9qRCDQLW+rmtjTg4mzGxw\n",
       "FPAv1CVJXAVs6m7siRgEigTCrwE+B3wDGIvb8myeVIicv1RA+qej1y/fzvRvBy4APhbXf5+pMf6G\n",
       "AxqvMFt8S5mGL+fnJ2ftZVDEaDzh7ut7rkSIGcX06Tb6y+jakOH2sllTU5LcMU2PvSMWw7tPVqtD\n",
       "AMwqcMyfm9klZvYKMzu+VnqubIYTZ0DMFulPS7v644t+29Q9d++qxTNC62hscZg/4zxgI+HvJQRD\n",
       "s37uuLutO3pZ/2a23Gzx5lBseQ+uv6zsa+ZEkZbG0cA7gNcw7p4irgshGtL78TfNYibNYym7V8PK\n",
       "qydp+s1xg7Hgaristm8Mxh6B310Apb93e4ZiMn2gwOjBH1KRfFNljmpUUel1oYf5lmgyunvq9nlP\n",
       "1Kcnb6ap8ajthVtzS/+Ra4aFPj+X3s35RVoa2wk5lHeWaKuEmPF4gRThndM0ZsL49k3AvDnwp9Gd\n",
       "vPJE2PPh4veYnDFXI8hFMffUIuAuM7sZ2Bu3uavLbVfMgL7e0p+UJxdNf8xnmDpP97kfgnUxllnv\n",
       "umnoTtvSqy7Dvav/vrgFM392uqOI0fijnqsQQrTJI1fByqOZ8pI/8PQQj2AW/EeD8148q1GPLp+a\n",
       "l2oLLLg4t9hAg9+h1lHJaES4EJkyNS3IgotDD6fthFn9nvwRzD4U1sdZ+1aOwdmz4oA+Qu+o4RH3\n",
       "XadMvfb8rXDM8fAc4HeAB5seK/KiZyPCzewRmg/ic3df0OlNhRDdjxivj5mYLd48McZxzCwYvg9G\n",
       "3zex9fDZi+GYlq6b2APpOHh33LICeHubv07MVJoaDXef308hg0buftEZoP98GDo5rPU/xcd419Az\n",
       "58I/A3edZGYfcPc1Bc8vVP+Tg/FmtnV6183QqhD3qB8EeO4Y7C4tNpDz85Oz9jIoEtMQYkYRXtjz\n",
       "PgTram6bBP76oVXBYHyRmNZjFqz8kJlt7UzHlADwWGhZTKSLHl3bFBsQQLE5wnvYX/hQ4AbgduA2\n",
       "YGXcPkSYr+NuYDOwsOy+xip9+fet5LzQ3fblL+N3hXNP8DLHFACrYeEz4bqrOh5XgaZnndGl23dn\n",
       "kTQiveQp4Pfd/WjgBOC9ZnYkcCEw4u5HANfHdZERdSNzTw5lwdW9SOnQb4r+rulTWYyuhe1j8Gng\n",
       "dMoZzjG0LOSW+g4h2N1Z2g933wR7ToPhkVA0YZKoI7XVm2QBrwFeB9wFLInbDgbuKttapi7kP89w\n",
       "S/1VHpkLLA8jpdv/ki7yuyjwpR6PeXL8mGfH0dtFdUyt/yrXebvPT5VLztqjfu/m/MrENMxsKfAS\n",
       "4EaCwaiNQN8JLEkkS8xAPPTl/wAMx0B42X35i2S4HVoF6/afFGy+3f3RLnRovnnReyphNMxsPvDX\n",
       "wO+5+3+ZjXchdnc3s4Zdf+NUtDvi6m5CsG5L3Lcsnl/J9dq2qugpWz+MjsA5rwJisPmcvfDYSP25\n",
       "ifXfDKM3t3s+EF/Md8YX86cehz1rp17/TmALUDvtyUUTe908uSgcU+NO4Ol9CUE7rP+90a20Klz/\n",
       "kat8PInhMuBldT3GRoC2f7+ef9/i7luqpGe69bj8TgI76JLkg/vMbH/gb4BvuvtlcdtdhCbgg2Z2\n",
       "CHCDu7940nnuGtxXabodh1BVpvtdNnVq1ccnxwWKHFO+5v7dT1SXbt+dSY2GhSbFRmCXu/9+3faP\n",
       "x20fM7MLCb2nLpx0btZGI/e+3tI/7fWnNZjdGNV29cfBfyePu8OajwbvBzk/Pzlrhx6OCO8Tv0IY\n",
       "avp9M7s1brsIuBS4yszOIjSnzkgjT4jO8ALjIYocI0TVSO6e6pTcWxpC9BO5p0SNrN1T3SCjIUR7\n",
       "zNQYk2iPbt+dqQf3DSx1vXGyRPrT0ol+d9/kvuuUUNIajJzrP2ftZSCjIYQQojByTwkhxAAh95QQ\n",
       "A8j0ua2E6A0yGonI3S8q/b2nmWEIy/O+XjQZZBUNTA7134yctZdB6nEaQogGjHeRbTRH99AqOHtO\n",
       "69xWRa4jRPvIaCQi5xGlIP29Z7qkh0eWdJ00VL/+m5Oz9jKQ0RAiO5TNVqRDvacSMQPy10h/D5lu\n",
       "BLcVnOO8qiPBq17/rchZO+Sfe0oI0QAPc37ENOdQP+dHMATzzwAenm5kd6vrCNEJamkIkRFVbTmI\n",
       "fFBLQ4iBopqBbTE4aJxGInLv6y39qdmSWkBX5Fz/OWsvAxkNIbJidG1wSV1HmEhp5eNhmxD9QTEN\n",
       "ITJDKc5FN2g+DSGEEIVRwsJMyd0vKv1pkf505Ky9DGQ0hBBCFEbuKSGEGCDknhIDQxVTfAsxaMho\n",
       "JCJ3v2i/9del+C40h0SB6y0rUV7fkf505Ky9DDQiXGSCRkILUQXU0khEzlkyQfpTI/3pyFl7Gail\n",
       "ITJBc0gIUQXU0khE7n7RfusPo573nAbDI6F0l9lV9Z+WnPXnrL0M1NIQ2RCNhGIYQiRE4zSEEGKA\n",
       "mLHjNMzs9WZ2l5ndY2YXpNYjhBCiokbDzPYD/gJ4PXAU8DYzOzKtqnLJ3S8q/WmR/nTkrL0MKmk0\n",
       "gJcD97r7Dnd/Cvi/wJsSaxJCiIGnqkbjucD9desPxG0zhtz7ekt/WqQ/HTlrL4OqGo08o/NCCDHD\n",
       "qWqX238HDq1bP5TQ2piAmW0AdsTV3cC22ldAze9Y4fVzM9Mr/dVal/5E6/UxjSroKaj3nVHyDrqk\n",
       "kl1uzWw28APgJOA/gJuAt7n7nXXHZN3l1syW5dzMlf60SH86ctYOM3i6VzN7A3AZsB9wubt/dNL+\n",
       "rI2GEEKkYMYajemQ0RBCiPaZsYP7Zjq59/WW/rRIfzpy1l4GMhpCCCEKI/eUEEIMEHJPCSGE6Bsy\n",
       "GonI3S9jaPrpAAAJ00lEQVQq/WmR/nTkrL0MZDSEEEIURjENIYQYIBTTEEII0TdkNBKRu19U+tMi\n",
       "/enIWXsZyGgIIYQojGIaQggxQCimIYQQom/IaCQid7+o9KdF+tORs/YykNEQQghRGMU0hBBigFBM\n",
       "QwghRN+Q0UhE7n5R6S9Fw3KzxZtDseVtnrusR7L6Qs76c9ZeBrNTCxBiEAlGYsHVsG5u2LLyRDM7\n",
       "zd03pVUmRGsU0xAiAWaLN8O6k2FF3LIRGB5x33VKSl1i5qOYhhBCiL4ho5GI3P2i0t8to2th5eOh\n",
       "hbGRsDy6tujZ6fV3R876c9ZeBoppCJEAd99kZqfB8KqwZc9axTNEDiimIYQQA4RiGkIIIfqGjEYi\n",
       "cveLSn9apD8dOWsvAxkNIYQQhVFMQwghBgjFNIQQQvSNZEbDzP7EzO40s++Z2dfM7KC6fReZ2T1m\n",
       "dpeZzcgRsrn7RaU/LdKfjpy1l0HKlsZm4Gh3Pxa4G7gIwMyOAn4DOAp4PfBJM5uJLaLjUgvoEulP\n",
       "i/SnI2ftXZPsZezuI+4+FldvBJ4Xl98EfNndn3L3HcC9wMsTSOw1C1ML6BLpT4v0pyNn7V1TlS/4\n",
       "dwF/G5efAzxQt+8B4Ll9VySEEGIKPU0jYmYjwMENdq1292/EY/4QeNLdv9TiUnl28WrN0tQCumRp\n",
       "agFdsjS1gC5ZmlpAlyxNLaALlqYWkJKkXW7N7J3A2cBJ7v5E3HYhgLtfGtevA/7I3W+cdO5MNCRC\n",
       "CNFzuulym8xomNnrgbXAq939J3XbjwK+RIhjPBf4FnC45zqgRAghZhAps9z+OXAAMGJmAN9x93Pc\n",
       "/Q4zuwq4A3gaOEcGQwghqkG2I8KFEEL0n6r0npqCmf2Mmd1oZtvM7A4z+2jcfomZPWBmt8byhrpz\n",
       "KjUo0Mz2ixprQf8hMxsxs7vNbLOZLaw7tlLaoaH+nOp+h5l9P+q8KW7Lpv6b6M+p/hea2VfjAN47\n",
       "zOyXMqv/yfpPyKH+zexFdfpuNbOfmtnKUuve3StbgHnx72zgX4ATgT8ChhscexSwDdif0LvhXmBW\n",
       "Yv3DwBXAtXH948AfxOULgEurqr2J/pzq/j5gaNK2bOq/if6c6n8j8K64PBs4KLP6b6Q/m/qPumYB\n",
       "PwYOLbPuK9vSAHD3x+LiAcB+wMNxvVHkv1KDAs3secAbgc8xrvdUwsNI/PvmuFwp7dBUv5FB3dcx\n",
       "WWs29R9pVNeVr38LKYFe6e5/CeDuT7v7T8mk/lvohwzqv47XAfe6+/2UWPeVNhpmNsvMtgE7gRvc\n",
       "/fa46/0WclZdXtfMqtqgwE8A5wNjdduWuPvOuLwTWBKXq6YdGut38qh7CFq/ZWbfNbOz47ac6r+R\n",
       "fsij/g8D/tPMPm9mt5jZZ83sQPKp/0b658V9OdR/jbcCX47LpdV9pY2Gu4+5+3GEFCOvspAo7FOE\n",
       "f9TjCE2vta0u0XORDTCzXwUecvdbafxlgoe2YSt9yXootNBf+bqv41fc/SXAG4D3mtkr63dWuf4j\n",
       "jfTnUv+zgeOBT7r78cCjwIX1B1S8/pvp/yR51D9mdgDwa8BXJu/rtu4rbTRqxKbh/wNe6u4PeYTg\n",
       "Oqk1pf6d4Lur8by4LQW/DJxqZvcRLP1rzeyvgJ1mdjCAmR0CPBSPr5J2aKz/C5nUPQDu/uP49z+B\n",
       "qwlac6n/hvozqv8HgAfc/ea4/lXCS/jBTOq/oX53/89M6h/Cx8bW+PxAic9+ZY2GmT271vwzs7nA\n",
       "ycCttR8eOQ3YHpevBd5qZgeY2WHAC4Gb+qm5hruvdvdD3f0wQhPx79z9HVHjinjYCuCauFwZ7dBU\n",
       "/2/Fh61GJesewMzmmdmz4vKBwCkErVnUfzP9OTz7AO7+IHC/mR0RN70OuB34BhnUfzP9udR/5G2M\n",
       "u6agxGc/5eC+6TgE2GghLfos4K/c/Xoz+4KZHUdoQt0H/C6AV3tQYE3HpcBVZnYWsAM4Ayqv3RjX\n",
       "/3EzO5bq1/0S4GoLg0ZnA1e4+2Yz+y551H8z/Tk9++8Hrohukh8CZxI6s+RQ/zBV/7uA9TnUf/zQ\n",
       "eB0hRVON0t49GtwnhBCiMJV1TwkhhKgeMhpCCCEKI6MhhBCiMDIaQgghCiOjIYQQojAyGkIIIQoj\n",
       "oyGywQL/aGHWx9q2Xzezb5Z4j9+IuYVuM7NLmxyz1MxuaLLvoDie4h4zu9fMNprZgrL0NcNCKvWh\n",
       "uPxIr+8nBhcZDZENcdDRu4F1ZjbHzOYDHwHO6eR6ZjZ70vpiQgrp17r7LwAHm9lr27zs5YTMoi90\n",
       "98MJg8A+14m+Vlob4E2WhSgVGQ2RFTHT8TcICeQ+CHwRuNjChF23mNmpsK818A9mtjWWV8Tty2Jr\n",
       "5euE1Bb1vAC4x913xfXrgdOLajOzwwk5lj5Ut/mPgZea2QvM7Mtm9sa64zeY2VssZHP+EzO7KbZy\n",
       "fqeB1tvitmssZL69zSZmvy2q8TQz+1ZcPsTMfmBmP9vudcTgUuU0IkI0438BtwBPAn9DyI11VsxV\n",
       "dmN8Ke4ETnb3vWb2QuBLwMvi+S8Bjnb3f5103XuBF5nZ8wlJ295MmJymKEcB2+rTMLj7mIX0/kcD\n",
       "VxLSN/xtTE/xWkIqit8Gdrv7y81sDvBPZra5idYz3f3hmI/tJjP7qrvX5pmZFne/Ohqq9wHLgQ+6\n",
       "+0PTnSdEDRkNkR3u/piZXQk8QngJ/5qZnRd3zyFk7XwQ+IuYK+sZQiK2Gjc1MBjEl/F7CC/3MeDb\n",
       "wM+3I22afd8E/iwajDcAfx+N2inAMWb2P+OxC4DDCbmAJmv9PTOrTaBzKJ0lx3s/oZX1bXe/ss1z\n",
       "xYAjoyFyZSwWA97i7vfU7zSzS4Afu/s7zGw/4Im63Y82u6i7/w2h9UJ0Ez3dhqY7gePMzGqtjZhw\n",
       "8zjgjmggthC+8M9gYhbS97n7yKTfsKxea1w/CTjB3Z+IwfifaUNfjUMJhnRJvVYhiqCYhsidTcDK\n",
       "2oqZvSQuLiC0NgB+i5BhdVpq/n0zWwS8hzaC2O5+L3ArcHHd5osJ8xr8KK5fSciY+krgurrfcE4t\n",
       "2G1mR9j4THH1LAAejgbjxcAJRbXViPe4nJDy/i7CPPBCFEZGQ+SME4LO+5vZ983sNkK8A8Isayti\n",
       "POFFBFdW/XnNuMzMbgf+CfhoNATtcBZwROxuey/BzXRW3f7NwKuAEXevtWI+R0hNfYuZbSfM0Dc7\n",
       "6qzXeh0w28zuAD4KfKeJhla/7yLgH9z92wSD8dtm9qJ2fqAYbJQaXYg2MbOlwOfd/TWJpQjRd9TS\n",
       "EEIIURgFwoXojEo30c3sGOALkzY/4e6vSKFHzBzknhJCCFEYuaeEEEIURkZDCCFEYWQ0hBBCFEZG\n",
       "QwghRGFkNIQQQhRGRkMIIURh/j+5577YfdpX0gAAAABJRU5ErkJggg==\n"
      ],
      "text/plain": [
       "<matplotlib.figure.Figure at 0x10da2b110>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "%pylab inline\n",
    "\n",
    "newdf['Full-time equivalent enrolments_x'] = newdf['Full-time equivalent enrolments_x'].replace(\"-\",np.NaN).astype('float')\n",
    "newdf.plot(kind='scatter',x='Year 9 | Overall_x',y='Improv | 7-9')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0_x</th>\n",
       "      <th>Average ICSEA value_x</th>\n",
       "      <th>Boys_x</th>\n",
       "      <th>Completed senior secondary school_x</th>\n",
       "      <th>Full-time equivalent enrolments_x</th>\n",
       "      <th>Full-time equivalent non-teaching staff_x</th>\n",
       "      <th>Full-time equivalent teaching staff_x</th>\n",
       "      <th>Girls_x</th>\n",
       "      <th>Indigenous students_x</th>\n",
       "      <th>Location_x</th>\n",
       "      <th>...</th>\n",
       "      <th>Year 9 | Numeracy_y</th>\n",
       "      <th>Year 9 | Reading_y</th>\n",
       "      <th>Year 9 | Spelling_y</th>\n",
       "      <th>Year 9 | Writing_y</th>\n",
       "      <th>Year range_y</th>\n",
       "      <th>Year 3 | Overall_y</th>\n",
       "      <th>Year 5 | Overall_y</th>\n",
       "      <th>Year 7 | Overall_y</th>\n",
       "      <th>Year 9 | Overall_y</th>\n",
       "      <th>Improv | 7-9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0  </th>\n",
       "      <td>    0</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 349</td>\n",
       "      <td>  61</td>\n",
       "      <td>  704.3</td>\n",
       "      <td> 22.3</td>\n",
       "      <td> 51.7</td>\n",
       "      <td> 365</td>\n",
       "      <td> 14%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> 563</td>\n",
       "      <td> 557</td>\n",
       "      <td> 561</td>\n",
       "      <td> 543</td>\n",
       "      <td>  U, R-12</td>\n",
       "      <td> 346.2</td>\n",
       "      <td> 454.8</td>\n",
       "      <td> 514.6</td>\n",
       "      <td> 555.8</td>\n",
       "      <td> 22.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1  </th>\n",
       "      <td>    7</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 382</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    735</td>\n",
       "      <td> 12.4</td>\n",
       "      <td> 38.8</td>\n",
       "      <td> 353</td>\n",
       "      <td>  0%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>      3-7</td>\n",
       "      <td> 416.4</td>\n",
       "      <td> 496.2</td>\n",
       "      <td> 548.6</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2  </th>\n",
       "      <td>   14</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 202</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    388</td>\n",
       "      <td> 13.7</td>\n",
       "      <td> 25.4</td>\n",
       "      <td> 186</td>\n",
       "      <td> 13%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>   U, R-7</td>\n",
       "      <td> 347.4</td>\n",
       "      <td> 441.4</td>\n",
       "      <td> 509.4</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3  </th>\n",
       "      <td>   21</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 191</td>\n",
       "      <td> NaN</td>\n",
       "      <td>  399.2</td>\n",
       "      <td>  3.9</td>\n",
       "      <td> 21.5</td>\n",
       "      <td> 209</td>\n",
       "      <td>  3%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>      R-7</td>\n",
       "      <td> 409.0</td>\n",
       "      <td> 487.0</td>\n",
       "      <td> 539.8</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4  </th>\n",
       "      <td>   28</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 236</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    429</td>\n",
       "      <td> 12.8</td>\n",
       "      <td> 41.4</td>\n",
       "      <td> 193</td>\n",
       "      <td> 12%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>   U, R-7</td>\n",
       "      <td> 338.2</td>\n",
       "      <td> 394.6</td>\n",
       "      <td> 498.0</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5  </th>\n",
       "      <td>   32</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 328</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    626</td>\n",
       "      <td>  7.1</td>\n",
       "      <td> 34.8</td>\n",
       "      <td> 298</td>\n",
       "      <td>  1%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>      3-7</td>\n",
       "      <td> 394.2</td>\n",
       "      <td> 496.4</td>\n",
       "      <td> 563.4</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6  </th>\n",
       "      <td>   39</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 162</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    304</td>\n",
       "      <td>  9.3</td>\n",
       "      <td> 17.4</td>\n",
       "      <td> 142</td>\n",
       "      <td>  9%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>      R-7</td>\n",
       "      <td> 392.2</td>\n",
       "      <td> 488.8</td>\n",
       "      <td> 535.0</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7  </th>\n",
       "      <td>   46</td>\n",
       "      <td> 1000</td>\n",
       "      <td>  41</td>\n",
       "      <td> NaN</td>\n",
       "      <td>     71</td>\n",
       "      <td>  2.4</td>\n",
       "      <td>  5.4</td>\n",
       "      <td>  30</td>\n",
       "      <td>   -</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>   U, R-7</td>\n",
       "      <td> 413.6</td>\n",
       "      <td> 478.6</td>\n",
       "      <td> 552.8</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8  </th>\n",
       "      <td>   53</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 130</td>\n",
       "      <td>  20</td>\n",
       "      <td>  247.3</td>\n",
       "      <td>  9.2</td>\n",
       "      <td> 21.2</td>\n",
       "      <td> 121</td>\n",
       "      <td>  2%</td>\n",
       "      <td>       Remote</td>\n",
       "      <td>...</td>\n",
       "      <td> 587</td>\n",
       "      <td> 546</td>\n",
       "      <td> 545</td>\n",
       "      <td> 546</td>\n",
       "      <td>     R-12</td>\n",
       "      <td> 328.4</td>\n",
       "      <td> 449.8</td>\n",
       "      <td> 520.2</td>\n",
       "      <td> 553.0</td>\n",
       "      <td> 52.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9  </th>\n",
       "      <td>   60</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 196</td>\n",
       "      <td>  35</td>\n",
       "      <td>  364.2</td>\n",
       "      <td> 14.9</td>\n",
       "      <td> 26.9</td>\n",
       "      <td> 171</td>\n",
       "      <td>  2%</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>...</td>\n",
       "      <td> 550</td>\n",
       "      <td> 547</td>\n",
       "      <td> 538</td>\n",
       "      <td> 521</td>\n",
       "      <td>     R-12</td>\n",
       "      <td> 355.8</td>\n",
       "      <td> 419.8</td>\n",
       "      <td> 499.6</td>\n",
       "      <td> 538.0</td>\n",
       "      <td> 61.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10 </th>\n",
       "      <td>   67</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 175</td>\n",
       "      <td>  51</td>\n",
       "      <td>  328.6</td>\n",
       "      <td> 10.9</td>\n",
       "      <td> 25.4</td>\n",
       "      <td> 175</td>\n",
       "      <td>  3%</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>...</td>\n",
       "      <td> 556</td>\n",
       "      <td> 546</td>\n",
       "      <td> 538</td>\n",
       "      <td> 549</td>\n",
       "      <td>     8-12</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> 546.0</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11 </th>\n",
       "      <td>   74</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 656</td>\n",
       "      <td> 254</td>\n",
       "      <td>   1247</td>\n",
       "      <td> 23.3</td>\n",
       "      <td> 93.8</td>\n",
       "      <td> 595</td>\n",
       "      <td>  2%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> 613</td>\n",
       "      <td> 590</td>\n",
       "      <td> 596</td>\n",
       "      <td> 603</td>\n",
       "      <td>  U, 8-12</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> 600.4</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12 </th>\n",
       "      <td>   81</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 103</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    198</td>\n",
       "      <td>  5.2</td>\n",
       "      <td> 12.4</td>\n",
       "      <td>  95</td>\n",
       "      <td>  2%</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>      R-7</td>\n",
       "      <td> 406.8</td>\n",
       "      <td> 487.0</td>\n",
       "      <td> 535.4</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13 </th>\n",
       "      <td>   88</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 172</td>\n",
       "      <td>  39</td>\n",
       "      <td>  312.2</td>\n",
       "      <td> 16.5</td>\n",
       "      <td> 20.6</td>\n",
       "      <td> 142</td>\n",
       "      <td>  4%</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>...</td>\n",
       "      <td> 538</td>\n",
       "      <td> 549</td>\n",
       "      <td> 554</td>\n",
       "      <td> 513</td>\n",
       "      <td>     R-12</td>\n",
       "      <td> 367.2</td>\n",
       "      <td> 468.4</td>\n",
       "      <td> 549.0</td>\n",
       "      <td> 537.8</td>\n",
       "      <td>-12.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14 </th>\n",
       "      <td>   95</td>\n",
       "      <td> 1000</td>\n",
       "      <td>  79</td>\n",
       "      <td>   6</td>\n",
       "      <td>  184.8</td>\n",
       "      <td>  7.3</td>\n",
       "      <td> 17.6</td>\n",
       "      <td> 106</td>\n",
       "      <td>  6%</td>\n",
       "      <td>  Very Remote</td>\n",
       "      <td>...</td>\n",
       "      <td> 586</td>\n",
       "      <td> 566</td>\n",
       "      <td> 563</td>\n",
       "      <td> 565</td>\n",
       "      <td>     R-12</td>\n",
       "      <td> 441.2</td>\n",
       "      <td> 502.4</td>\n",
       "      <td> 540.4</td>\n",
       "      <td> 564.0</td>\n",
       "      <td> 28.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15 </th>\n",
       "      <td>  102</td>\n",
       "      <td> 1000</td>\n",
       "      <td>  34</td>\n",
       "      <td> NaN</td>\n",
       "      <td>     75</td>\n",
       "      <td>  3.1</td>\n",
       "      <td>  5.4</td>\n",
       "      <td>  41</td>\n",
       "      <td>  3%</td>\n",
       "      <td>       Remote</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>      R-7</td>\n",
       "      <td> 391.8</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16 </th>\n",
       "      <td>  109</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 106</td>\n",
       "      <td>  23</td>\n",
       "      <td>  230.2</td>\n",
       "      <td>  7.2</td>\n",
       "      <td> 18.2</td>\n",
       "      <td> 125</td>\n",
       "      <td>  1%</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>...</td>\n",
       "      <td> 578</td>\n",
       "      <td> 573</td>\n",
       "      <td> 572</td>\n",
       "      <td> 539</td>\n",
       "      <td>     R-12</td>\n",
       "      <td> 417.0</td>\n",
       "      <td> 518.0</td>\n",
       "      <td> 539.4</td>\n",
       "      <td> 568.0</td>\n",
       "      <td> 72.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17 </th>\n",
       "      <td>  116</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 277</td>\n",
       "      <td> 108</td>\n",
       "      <td>  534.7</td>\n",
       "      <td> 13.4</td>\n",
       "      <td> 36.8</td>\n",
       "      <td> 266</td>\n",
       "      <td>  2%</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>...</td>\n",
       "      <td> 558</td>\n",
       "      <td> 563</td>\n",
       "      <td> 551</td>\n",
       "      <td> 523</td>\n",
       "      <td>     8-12</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> 550.4</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18 </th>\n",
       "      <td>  123</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 240</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    485</td>\n",
       "      <td>  5.8</td>\n",
       "      <td> 23.7</td>\n",
       "      <td> 245</td>\n",
       "      <td>  0%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>      R-7</td>\n",
       "      <td> 414.8</td>\n",
       "      <td> 482.6</td>\n",
       "      <td> 548.8</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19 </th>\n",
       "      <td>  130</td>\n",
       "      <td> 1000</td>\n",
       "      <td>  46</td>\n",
       "      <td> NaN</td>\n",
       "      <td>     90</td>\n",
       "      <td>  3.9</td>\n",
       "      <td>    6</td>\n",
       "      <td>  44</td>\n",
       "      <td>  4%</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>      R-7</td>\n",
       "      <td> 415.0</td>\n",
       "      <td> 450.4</td>\n",
       "      <td> 554.6</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20 </th>\n",
       "      <td>  137</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 185</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    339</td>\n",
       "      <td>  8.4</td>\n",
       "      <td> 18.5</td>\n",
       "      <td> 154</td>\n",
       "      <td>  2%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>      R-7</td>\n",
       "      <td> 381.4</td>\n",
       "      <td> 460.6</td>\n",
       "      <td> 523.2</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21 </th>\n",
       "      <td>  144</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 212</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    378</td>\n",
       "      <td>    9</td>\n",
       "      <td> 20.4</td>\n",
       "      <td> 166</td>\n",
       "      <td>   -</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>   U, R-7</td>\n",
       "      <td> 421.0</td>\n",
       "      <td> 513.2</td>\n",
       "      <td> 530.8</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22 </th>\n",
       "      <td>  151</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 458</td>\n",
       "      <td> 137</td>\n",
       "      <td>  876.2</td>\n",
       "      <td> 32.9</td>\n",
       "      <td> 71.8</td>\n",
       "      <td> 420</td>\n",
       "      <td>  0%</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>...</td>\n",
       "      <td> 593</td>\n",
       "      <td> 609</td>\n",
       "      <td> 594</td>\n",
       "      <td> 577</td>\n",
       "      <td>  U, 8-12</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> 594.2</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23 </th>\n",
       "      <td>  158</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 721</td>\n",
       "      <td>  92</td>\n",
       "      <td>   1466</td>\n",
       "      <td> 62.1</td>\n",
       "      <td> 94.9</td>\n",
       "      <td> 745</td>\n",
       "      <td>  1%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> 579</td>\n",
       "      <td> 576</td>\n",
       "      <td> 576</td>\n",
       "      <td> 558</td>\n",
       "      <td>  U, R-12</td>\n",
       "      <td> 389.2</td>\n",
       "      <td> 476.0</td>\n",
       "      <td> 529.4</td>\n",
       "      <td> 572.4</td>\n",
       "      <td> 37.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24 </th>\n",
       "      <td>  165</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 192</td>\n",
       "      <td>  21</td>\n",
       "      <td>  402.7</td>\n",
       "      <td> 12.5</td>\n",
       "      <td> 31.6</td>\n",
       "      <td> 213</td>\n",
       "      <td>   -</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>...</td>\n",
       "      <td> 571</td>\n",
       "      <td> 574</td>\n",
       "      <td> 564</td>\n",
       "      <td> 561</td>\n",
       "      <td>  U, R-12</td>\n",
       "      <td> 405.2</td>\n",
       "      <td> 453.6</td>\n",
       "      <td> 498.4</td>\n",
       "      <td> 569.0</td>\n",
       "      <td> 48.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25 </th>\n",
       "      <td>  172</td>\n",
       "      <td> 1000</td>\n",
       "      <td>  22</td>\n",
       "      <td> NaN</td>\n",
       "      <td>     47</td>\n",
       "      <td>  2.9</td>\n",
       "      <td>    4</td>\n",
       "      <td>  25</td>\n",
       "      <td>  4%</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>   U, R-7</td>\n",
       "      <td> 398.2</td>\n",
       "      <td> 441.0</td>\n",
       "      <td> 489.0</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26 </th>\n",
       "      <td>  179</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 523</td>\n",
       "      <td>  94</td>\n",
       "      <td> 1109.8</td>\n",
       "      <td>   35</td>\n",
       "      <td> 76.3</td>\n",
       "      <td> 589</td>\n",
       "      <td>  1%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> 576</td>\n",
       "      <td> 575</td>\n",
       "      <td> 575</td>\n",
       "      <td> 562</td>\n",
       "      <td>  U, R-12</td>\n",
       "      <td> 390.6</td>\n",
       "      <td> 496.6</td>\n",
       "      <td> 530.6</td>\n",
       "      <td> 571.4</td>\n",
       "      <td> 46.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27 </th>\n",
       "      <td>  186</td>\n",
       "      <td> 1000</td>\n",
       "      <td>  59</td>\n",
       "      <td>  12</td>\n",
       "      <td>    126</td>\n",
       "      <td>  1.7</td>\n",
       "      <td> 14.2</td>\n",
       "      <td>  67</td>\n",
       "      <td>   -</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>  U, 3-12</td>\n",
       "      <td> 417.2</td>\n",
       "      <td> 534.8</td>\n",
       "      <td> 589.8</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> 44.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28 </th>\n",
       "      <td>  193</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 252</td>\n",
       "      <td>  74</td>\n",
       "      <td>  470.7</td>\n",
       "      <td>   15</td>\n",
       "      <td> 37.4</td>\n",
       "      <td> 219</td>\n",
       "      <td>  0%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> 607</td>\n",
       "      <td> 583</td>\n",
       "      <td> 596</td>\n",
       "      <td> 583</td>\n",
       "      <td>  U, 8-12</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> 591.6</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29 </th>\n",
       "      <td>  200</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 288</td>\n",
       "      <td>  32</td>\n",
       "      <td>    630</td>\n",
       "      <td> 14.8</td>\n",
       "      <td> 46.8</td>\n",
       "      <td> 342</td>\n",
       "      <td>   -</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> 579</td>\n",
       "      <td> 562</td>\n",
       "      <td> 570</td>\n",
       "      <td> 543</td>\n",
       "      <td>  U, R-12</td>\n",
       "      <td> 388.4</td>\n",
       "      <td> 488.6</td>\n",
       "      <td> 542.8</td>\n",
       "      <td> 565.8</td>\n",
       "      <td> 24.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>684</th>\n",
       "      <td> 4744</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 581</td>\n",
       "      <td> 334</td>\n",
       "      <td>   1048</td>\n",
       "      <td> 47.2</td>\n",
       "      <td> 74.4</td>\n",
       "      <td> 468</td>\n",
       "      <td>  1%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>  U, 8-12</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>685</th>\n",
       "      <td> 4751</td>\n",
       "      <td> 1000</td>\n",
       "      <td>  28</td>\n",
       "      <td>  36</td>\n",
       "      <td>  108.3</td>\n",
       "      <td>    1</td>\n",
       "      <td>  9.2</td>\n",
       "      <td>  81</td>\n",
       "      <td>  2%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> U, 11-12</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>686</th>\n",
       "      <td> 4758</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 187</td>\n",
       "      <td> 171</td>\n",
       "      <td>    216</td>\n",
       "      <td>  8.1</td>\n",
       "      <td> 17.5</td>\n",
       "      <td>  29</td>\n",
       "      <td>  1%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> U, 11-12</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>687</th>\n",
       "      <td> 4765</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 263</td>\n",
       "      <td>  66</td>\n",
       "      <td>  520.4</td>\n",
       "      <td> 12.2</td>\n",
       "      <td> 35.2</td>\n",
       "      <td> 258</td>\n",
       "      <td>  3%</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>...</td>\n",
       "      <td> 573</td>\n",
       "      <td> 568</td>\n",
       "      <td> 560</td>\n",
       "      <td> 561</td>\n",
       "      <td>     8-12</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> 565.2</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>688</th>\n",
       "      <td> 4772</td>\n",
       "      <td> 1000</td>\n",
       "      <td>  82</td>\n",
       "      <td>  27</td>\n",
       "      <td>  171.5</td>\n",
       "      <td>  9.2</td>\n",
       "      <td> 15.6</td>\n",
       "      <td>  90</td>\n",
       "      <td>  3%</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>...</td>\n",
       "      <td> 547</td>\n",
       "      <td> 562</td>\n",
       "      <td> 547</td>\n",
       "      <td> 522</td>\n",
       "      <td>     8-12</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> 547.4</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>689</th>\n",
       "      <td> 4779</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 672</td>\n",
       "      <td> 214</td>\n",
       "      <td> 1199.8</td>\n",
       "      <td>   25</td>\n",
       "      <td> 77.6</td>\n",
       "      <td> 542</td>\n",
       "      <td>  1%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> 592</td>\n",
       "      <td> 587</td>\n",
       "      <td> 592</td>\n",
       "      <td> 572</td>\n",
       "      <td>  U, 8-12</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> 587.4</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>690</th>\n",
       "      <td> 4786</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 460</td>\n",
       "      <td> 173</td>\n",
       "      <td>  981.5</td>\n",
       "      <td> 26.8</td>\n",
       "      <td> 71.1</td>\n",
       "      <td> 528</td>\n",
       "      <td>  2%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> 597</td>\n",
       "      <td> 595</td>\n",
       "      <td> 585</td>\n",
       "      <td> 568</td>\n",
       "      <td>     8-12</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> 585.8</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>691</th>\n",
       "      <td> 4793</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 348</td>\n",
       "      <td>  77</td>\n",
       "      <td>  739.9</td>\n",
       "      <td> 24.9</td>\n",
       "      <td> 51.6</td>\n",
       "      <td> 395</td>\n",
       "      <td>  7%</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>...</td>\n",
       "      <td> 548</td>\n",
       "      <td> 561</td>\n",
       "      <td> 545</td>\n",
       "      <td> 526</td>\n",
       "      <td>  U, 8-12</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> 546.2</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>692</th>\n",
       "      <td> 4800</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 186</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    365</td>\n",
       "      <td>  6.8</td>\n",
       "      <td> 19.2</td>\n",
       "      <td> 179</td>\n",
       "      <td>  6%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>      R-7</td>\n",
       "      <td> 406.4</td>\n",
       "      <td> 460.6</td>\n",
       "      <td> 519.0</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>693</th>\n",
       "      <td> 4804</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 542</td>\n",
       "      <td> 119</td>\n",
       "      <td>  984.4</td>\n",
       "      <td> 24.3</td>\n",
       "      <td> 81.2</td>\n",
       "      <td> 453</td>\n",
       "      <td> 15%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> 547</td>\n",
       "      <td> 537</td>\n",
       "      <td> 554</td>\n",
       "      <td> 518</td>\n",
       "      <td>  U, 8-12</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> 539.2</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>694</th>\n",
       "      <td> 4811</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 313</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    574</td>\n",
       "      <td>  8.5</td>\n",
       "      <td> 30.8</td>\n",
       "      <td> 261</td>\n",
       "      <td>   -</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>      R-7</td>\n",
       "      <td> 435.0</td>\n",
       "      <td> 509.8</td>\n",
       "      <td> 574.8</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>695</th>\n",
       "      <td> 4815</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 184</td>\n",
       "      <td>  42</td>\n",
       "      <td>  334.8</td>\n",
       "      <td> 16.5</td>\n",
       "      <td> 31.1</td>\n",
       "      <td> 153</td>\n",
       "      <td>  5%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> 551</td>\n",
       "      <td> 553</td>\n",
       "      <td> 552</td>\n",
       "      <td> 528</td>\n",
       "      <td>  U, 8-12</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td> 546.4</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>696</th>\n",
       "      <td> 4822</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 111</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    220</td>\n",
       "      <td>  5.5</td>\n",
       "      <td>   12</td>\n",
       "      <td> 109</td>\n",
       "      <td>  0%</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>      R-7</td>\n",
       "      <td> 402.2</td>\n",
       "      <td> 473.6</td>\n",
       "      <td> 544.8</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>697</th>\n",
       "      <td> 4829</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 283</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    525</td>\n",
       "      <td> 14.7</td>\n",
       "      <td> 35.4</td>\n",
       "      <td> 242</td>\n",
       "      <td> 10%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>   U, R-7</td>\n",
       "      <td> 373.4</td>\n",
       "      <td> 461.8</td>\n",
       "      <td> 480.0</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>698</th>\n",
       "      <td> 4833</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 122</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    161</td>\n",
       "      <td> 35.1</td>\n",
       "      <td> 28.8</td>\n",
       "      <td>  39</td>\n",
       "      <td>  5%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>        U</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699</th>\n",
       "      <td> 4840</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 210</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    434</td>\n",
       "      <td>  6.5</td>\n",
       "      <td> 23.8</td>\n",
       "      <td> 224</td>\n",
       "      <td>  0%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>      R-7</td>\n",
       "      <td> 418.2</td>\n",
       "      <td> 471.6</td>\n",
       "      <td> 540.2</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>700</th>\n",
       "      <td> 4847</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 184</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    394</td>\n",
       "      <td> 10.6</td>\n",
       "      <td> 21.9</td>\n",
       "      <td> 210</td>\n",
       "      <td>  8%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>      3-7</td>\n",
       "      <td> 383.6</td>\n",
       "      <td> 486.2</td>\n",
       "      <td> 503.2</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>701</th>\n",
       "      <td> 4854</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 111</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    256</td>\n",
       "      <td>  2.9</td>\n",
       "      <td> 14.3</td>\n",
       "      <td> 145</td>\n",
       "      <td>   -</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>   U, R-7</td>\n",
       "      <td> 443.0</td>\n",
       "      <td> 518.8</td>\n",
       "      <td> 576.8</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>702</th>\n",
       "      <td> 4861</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 144</td>\n",
       "      <td> NaN</td>\n",
       "      <td>  292.4</td>\n",
       "      <td>  5.6</td>\n",
       "      <td> 15.7</td>\n",
       "      <td> 149</td>\n",
       "      <td>   -</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>   U, R-7</td>\n",
       "      <td> 416.0</td>\n",
       "      <td> 465.4</td>\n",
       "      <td> 539.2</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>703</th>\n",
       "      <td> 4868</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 271</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    511</td>\n",
       "      <td>    7</td>\n",
       "      <td> 26.6</td>\n",
       "      <td> 240</td>\n",
       "      <td>  0%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>   U, R-7</td>\n",
       "      <td> 410.0</td>\n",
       "      <td> 486.4</td>\n",
       "      <td> 539.4</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>704</th>\n",
       "      <td> 4875</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 141</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    250</td>\n",
       "      <td>    5</td>\n",
       "      <td> 12.3</td>\n",
       "      <td> 109</td>\n",
       "      <td>   -</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>   U, R-7</td>\n",
       "      <td> 413.6</td>\n",
       "      <td> 483.8</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>705</th>\n",
       "      <td> 4882</td>\n",
       "      <td> 1000</td>\n",
       "      <td>  85</td>\n",
       "      <td> NaN</td>\n",
       "      <td>  165.5</td>\n",
       "      <td>    6</td>\n",
       "      <td> 10.6</td>\n",
       "      <td>  81</td>\n",
       "      <td>  3%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>   U, R-7</td>\n",
       "      <td> 406.6</td>\n",
       "      <td> 519.6</td>\n",
       "      <td> 529.6</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>706</th>\n",
       "      <td> 4889</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 106</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    177</td>\n",
       "      <td>  6.7</td>\n",
       "      <td> 12.8</td>\n",
       "      <td>  71</td>\n",
       "      <td>  9%</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>      R-7</td>\n",
       "      <td> 377.2</td>\n",
       "      <td> 430.0</td>\n",
       "      <td> 477.2</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>707</th>\n",
       "      <td> 4896</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 304</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    609</td>\n",
       "      <td>  6.8</td>\n",
       "      <td> 30.2</td>\n",
       "      <td> 305</td>\n",
       "      <td>  0%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>      R-7</td>\n",
       "      <td> 442.8</td>\n",
       "      <td> 506.2</td>\n",
       "      <td> 581.8</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>708</th>\n",
       "      <td> 4903</td>\n",
       "      <td> 1000</td>\n",
       "      <td>  52</td>\n",
       "      <td> NaN</td>\n",
       "      <td>     88</td>\n",
       "      <td>  2.5</td>\n",
       "      <td>  7.1</td>\n",
       "      <td>  36</td>\n",
       "      <td>  6%</td>\n",
       "      <td>       Remote</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>      R-7</td>\n",
       "      <td> 403.0</td>\n",
       "      <td> 481.8</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>709</th>\n",
       "      <td> 4910</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 227</td>\n",
       "      <td> NaN</td>\n",
       "      <td>    442</td>\n",
       "      <td>  7.2</td>\n",
       "      <td> 25.3</td>\n",
       "      <td> 215</td>\n",
       "      <td>  1%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>      R-7</td>\n",
       "      <td> 415.2</td>\n",
       "      <td> 471.0</td>\n",
       "      <td> 537.2</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>710</th>\n",
       "      <td> 4917</td>\n",
       "      <td> 1000</td>\n",
       "      <td>  32</td>\n",
       "      <td> NaN</td>\n",
       "      <td>     57</td>\n",
       "      <td>  1.9</td>\n",
       "      <td>  4.1</td>\n",
       "      <td>  25</td>\n",
       "      <td>  4%</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>      R-7</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>711</th>\n",
       "      <td> 4924</td>\n",
       "      <td> 1000</td>\n",
       "      <td>  18</td>\n",
       "      <td> NaN</td>\n",
       "      <td>     28</td>\n",
       "      <td>  1.4</td>\n",
       "      <td>    3</td>\n",
       "      <td>  10</td>\n",
       "      <td>  4%</td>\n",
       "      <td>   Provincial</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>      R-7</td>\n",
       "      <td> 370.4</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>712</th>\n",
       "      <td> 4931</td>\n",
       "      <td> 1000</td>\n",
       "      <td> 322</td>\n",
       "      <td> NaN</td>\n",
       "      <td>  658.8</td>\n",
       "      <td> 20.9</td>\n",
       "      <td>   38</td>\n",
       "      <td> 337</td>\n",
       "      <td>  1%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>   U, R-7</td>\n",
       "      <td> 423.2</td>\n",
       "      <td> 518.0</td>\n",
       "      <td> 551.0</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>713</th>\n",
       "      <td> 4938</td>\n",
       "      <td> 1000</td>\n",
       "      <td>  85</td>\n",
       "      <td> NaN</td>\n",
       "      <td>  154.9</td>\n",
       "      <td>  6.9</td>\n",
       "      <td>  9.7</td>\n",
       "      <td>  70</td>\n",
       "      <td>  3%</td>\n",
       "      <td> Metropolitan</td>\n",
       "      <td>...</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td> NaN</td>\n",
       "      <td>   U, R-7</td>\n",
       "      <td> 404.2</td>\n",
       "      <td> 513.4</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>   NaN</td>\n",
       "      <td>  NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>714 rows × 94 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0_x  Average ICSEA value_x Boys_x  \\\n",
       "0               0                   1000    349   \n",
       "1               7                   1000    382   \n",
       "2              14                   1000    202   \n",
       "3              21                   1000    191   \n",
       "4              28                   1000    236   \n",
       "5              32                   1000    328   \n",
       "6              39                   1000    162   \n",
       "7              46                   1000     41   \n",
       "8              53                   1000    130   \n",
       "9              60                   1000    196   \n",
       "10             67                   1000    175   \n",
       "11             74                   1000    656   \n",
       "12             81                   1000    103   \n",
       "13             88                   1000    172   \n",
       "14             95                   1000     79   \n",
       "15            102                   1000     34   \n",
       "16            109                   1000    106   \n",
       "17            116                   1000    277   \n",
       "18            123                   1000    240   \n",
       "19            130                   1000     46   \n",
       "20            137                   1000    185   \n",
       "21            144                   1000    212   \n",
       "22            151                   1000    458   \n",
       "23            158                   1000    721   \n",
       "24            165                   1000    192   \n",
       "25            172                   1000     22   \n",
       "26            179                   1000    523   \n",
       "27            186                   1000     59   \n",
       "28            193                   1000    252   \n",
       "29            200                   1000    288   \n",
       "..            ...                    ...    ...   \n",
       "684          4744                   1000    581   \n",
       "685          4751                   1000     28   \n",
       "686          4758                   1000    187   \n",
       "687          4765                   1000    263   \n",
       "688          4772                   1000     82   \n",
       "689          4779                   1000    672   \n",
       "690          4786                   1000    460   \n",
       "691          4793                   1000    348   \n",
       "692          4800                   1000    186   \n",
       "693          4804                   1000    542   \n",
       "694          4811                   1000    313   \n",
       "695          4815                   1000    184   \n",
       "696          4822                   1000    111   \n",
       "697          4829                   1000    283   \n",
       "698          4833                   1000    122   \n",
       "699          4840                   1000    210   \n",
       "700          4847                   1000    184   \n",
       "701          4854                   1000    111   \n",
       "702          4861                   1000    144   \n",
       "703          4868                   1000    271   \n",
       "704          4875                   1000    141   \n",
       "705          4882                   1000     85   \n",
       "706          4889                   1000    106   \n",
       "707          4896                   1000    304   \n",
       "708          4903                   1000     52   \n",
       "709          4910                   1000    227   \n",
       "710          4917                   1000     32   \n",
       "711          4924                   1000     18   \n",
       "712          4931                   1000    322   \n",
       "713          4938                   1000     85   \n",
       "\n",
       "    Completed senior secondary school_x Full-time equivalent enrolments_x  \\\n",
       "0                                    61                             704.3   \n",
       "1                                   NaN                               735   \n",
       "2                                   NaN                               388   \n",
       "3                                   NaN                             399.2   \n",
       "4                                   NaN                               429   \n",
       "5                                   NaN                               626   \n",
       "6                                   NaN                               304   \n",
       "7                                   NaN                                71   \n",
       "8                                    20                             247.3   \n",
       "9                                    35                             364.2   \n",
       "10                                   51                             328.6   \n",
       "11                                  254                              1247   \n",
       "12                                  NaN                               198   \n",
       "13                                   39                             312.2   \n",
       "14                                    6                             184.8   \n",
       "15                                  NaN                                75   \n",
       "16                                   23                             230.2   \n",
       "17                                  108                             534.7   \n",
       "18                                  NaN                               485   \n",
       "19                                  NaN                                90   \n",
       "20                                  NaN                               339   \n",
       "21                                  NaN                               378   \n",
       "22                                  137                             876.2   \n",
       "23                                   92                              1466   \n",
       "24                                   21                             402.7   \n",
       "25                                  NaN                                47   \n",
       "26                                   94                            1109.8   \n",
       "27                                   12                               126   \n",
       "28                                   74                             470.7   \n",
       "29                                   32                               630   \n",
       "..                                  ...                               ...   \n",
       "684                                 334                              1048   \n",
       "685                                  36                             108.3   \n",
       "686                                 171                               216   \n",
       "687                                  66                             520.4   \n",
       "688                                  27                             171.5   \n",
       "689                                 214                            1199.8   \n",
       "690                                 173                             981.5   \n",
       "691                                  77                             739.9   \n",
       "692                                 NaN                               365   \n",
       "693                                 119                             984.4   \n",
       "694                                 NaN                               574   \n",
       "695                                  42                             334.8   \n",
       "696                                 NaN                               220   \n",
       "697                                 NaN                               525   \n",
       "698                                 NaN                               161   \n",
       "699                                 NaN                               434   \n",
       "700                                 NaN                               394   \n",
       "701                                 NaN                               256   \n",
       "702                                 NaN                             292.4   \n",
       "703                                 NaN                               511   \n",
       "704                                 NaN                               250   \n",
       "705                                 NaN                             165.5   \n",
       "706                                 NaN                               177   \n",
       "707                                 NaN                               609   \n",
       "708                                 NaN                                88   \n",
       "709                                 NaN                               442   \n",
       "710                                 NaN                                57   \n",
       "711                                 NaN                                28   \n",
       "712                                 NaN                             658.8   \n",
       "713                                 NaN                             154.9   \n",
       "\n",
       "    Full-time equivalent non-teaching staff_x  \\\n",
       "0                                        22.3   \n",
       "1                                        12.4   \n",
       "2                                        13.7   \n",
       "3                                         3.9   \n",
       "4                                        12.8   \n",
       "5                                         7.1   \n",
       "6                                         9.3   \n",
       "7                                         2.4   \n",
       "8                                         9.2   \n",
       "9                                        14.9   \n",
       "10                                       10.9   \n",
       "11                                       23.3   \n",
       "12                                        5.2   \n",
       "13                                       16.5   \n",
       "14                                        7.3   \n",
       "15                                        3.1   \n",
       "16                                        7.2   \n",
       "17                                       13.4   \n",
       "18                                        5.8   \n",
       "19                                        3.9   \n",
       "20                                        8.4   \n",
       "21                                          9   \n",
       "22                                       32.9   \n",
       "23                                       62.1   \n",
       "24                                       12.5   \n",
       "25                                        2.9   \n",
       "26                                         35   \n",
       "27                                        1.7   \n",
       "28                                         15   \n",
       "29                                       14.8   \n",
       "..                                        ...   \n",
       "684                                      47.2   \n",
       "685                                         1   \n",
       "686                                       8.1   \n",
       "687                                      12.2   \n",
       "688                                       9.2   \n",
       "689                                        25   \n",
       "690                                      26.8   \n",
       "691                                      24.9   \n",
       "692                                       6.8   \n",
       "693                                      24.3   \n",
       "694                                       8.5   \n",
       "695                                      16.5   \n",
       "696                                       5.5   \n",
       "697                                      14.7   \n",
       "698                                      35.1   \n",
       "699                                       6.5   \n",
       "700                                      10.6   \n",
       "701                                       2.9   \n",
       "702                                       5.6   \n",
       "703                                         7   \n",
       "704                                         5   \n",
       "705                                         6   \n",
       "706                                       6.7   \n",
       "707                                       6.8   \n",
       "708                                       2.5   \n",
       "709                                       7.2   \n",
       "710                                       1.9   \n",
       "711                                       1.4   \n",
       "712                                      20.9   \n",
       "713                                       6.9   \n",
       "\n",
       "    Full-time equivalent teaching staff_x Girls_x Indigenous students_x  \\\n",
       "0                                    51.7     365                   14%   \n",
       "1                                    38.8     353                    0%   \n",
       "2                                    25.4     186                   13%   \n",
       "3                                    21.5     209                    3%   \n",
       "4                                    41.4     193                   12%   \n",
       "5                                    34.8     298                    1%   \n",
       "6                                    17.4     142                    9%   \n",
       "7                                     5.4      30                     -   \n",
       "8                                    21.2     121                    2%   \n",
       "9                                    26.9     171                    2%   \n",
       "10                                   25.4     175                    3%   \n",
       "11                                   93.8     595                    2%   \n",
       "12                                   12.4      95                    2%   \n",
       "13                                   20.6     142                    4%   \n",
       "14                                   17.6     106                    6%   \n",
       "15                                    5.4      41                    3%   \n",
       "16                                   18.2     125                    1%   \n",
       "17                                   36.8     266                    2%   \n",
       "18                                   23.7     245                    0%   \n",
       "19                                      6      44                    4%   \n",
       "20                                   18.5     154                    2%   \n",
       "21                                   20.4     166                     -   \n",
       "22                                   71.8     420                    0%   \n",
       "23                                   94.9     745                    1%   \n",
       "24                                   31.6     213                     -   \n",
       "25                                      4      25                    4%   \n",
       "26                                   76.3     589                    1%   \n",
       "27                                   14.2      67                     -   \n",
       "28                                   37.4     219                    0%   \n",
       "29                                   46.8     342                     -   \n",
       "..                                    ...     ...                   ...   \n",
       "684                                  74.4     468                    1%   \n",
       "685                                   9.2      81                    2%   \n",
       "686                                  17.5      29                    1%   \n",
       "687                                  35.2     258                    3%   \n",
       "688                                  15.6      90                    3%   \n",
       "689                                  77.6     542                    1%   \n",
       "690                                  71.1     528                    2%   \n",
       "691                                  51.6     395                    7%   \n",
       "692                                  19.2     179                    6%   \n",
       "693                                  81.2     453                   15%   \n",
       "694                                  30.8     261                     -   \n",
       "695                                  31.1     153                    5%   \n",
       "696                                    12     109                    0%   \n",
       "697                                  35.4     242                   10%   \n",
       "698                                  28.8      39                    5%   \n",
       "699                                  23.8     224                    0%   \n",
       "700                                  21.9     210                    8%   \n",
       "701                                  14.3     145                     -   \n",
       "702                                  15.7     149                     -   \n",
       "703                                  26.6     240                    0%   \n",
       "704                                  12.3     109                     -   \n",
       "705                                  10.6      81                    3%   \n",
       "706                                  12.8      71                    9%   \n",
       "707                                  30.2     305                    0%   \n",
       "708                                   7.1      36                    6%   \n",
       "709                                  25.3     215                    1%   \n",
       "710                                   4.1      25                    4%   \n",
       "711                                     3      10                    4%   \n",
       "712                                    38     337                    1%   \n",
       "713                                   9.7      70                    3%   \n",
       "\n",
       "       Location_x     ...      Year 9 | Numeracy_y Year 9 | Reading_y  \\\n",
       "0    Metropolitan     ...                      563                557   \n",
       "1    Metropolitan     ...                      NaN                NaN   \n",
       "2    Metropolitan     ...                      NaN                NaN   \n",
       "3    Metropolitan     ...                      NaN                NaN   \n",
       "4    Metropolitan     ...                      NaN                NaN   \n",
       "5    Metropolitan     ...                      NaN                NaN   \n",
       "6    Metropolitan     ...                      NaN                NaN   \n",
       "7      Provincial     ...                      NaN                NaN   \n",
       "8          Remote     ...                      587                546   \n",
       "9      Provincial     ...                      550                547   \n",
       "10     Provincial     ...                      556                546   \n",
       "11   Metropolitan     ...                      613                590   \n",
       "12     Provincial     ...                      NaN                NaN   \n",
       "13     Provincial     ...                      538                549   \n",
       "14    Very Remote     ...                      586                566   \n",
       "15         Remote     ...                      NaN                NaN   \n",
       "16     Provincial     ...                      578                573   \n",
       "17     Provincial     ...                      558                563   \n",
       "18   Metropolitan     ...                      NaN                NaN   \n",
       "19     Provincial     ...                      NaN                NaN   \n",
       "20   Metropolitan     ...                      NaN                NaN   \n",
       "21   Metropolitan     ...                      NaN                NaN   \n",
       "22     Provincial     ...                      593                609   \n",
       "23   Metropolitan     ...                      579                576   \n",
       "24     Provincial     ...                      571                574   \n",
       "25     Provincial     ...                      NaN                NaN   \n",
       "26   Metropolitan     ...                      576                575   \n",
       "27   Metropolitan     ...                      NaN                NaN   \n",
       "28   Metropolitan     ...                      607                583   \n",
       "29   Metropolitan     ...                      579                562   \n",
       "..            ...     ...                      ...                ...   \n",
       "684  Metropolitan     ...                      NaN                NaN   \n",
       "685  Metropolitan     ...                      NaN                NaN   \n",
       "686  Metropolitan     ...                      NaN                NaN   \n",
       "687    Provincial     ...                      573                568   \n",
       "688    Provincial     ...                      547                562   \n",
       "689  Metropolitan     ...                      592                587   \n",
       "690  Metropolitan     ...                      597                595   \n",
       "691    Provincial     ...                      548                561   \n",
       "692  Metropolitan     ...                      NaN                NaN   \n",
       "693  Metropolitan     ...                      547                537   \n",
       "694  Metropolitan     ...                      NaN                NaN   \n",
       "695  Metropolitan     ...                      551                553   \n",
       "696    Provincial     ...                      NaN                NaN   \n",
       "697  Metropolitan     ...                      NaN                NaN   \n",
       "698  Metropolitan     ...                      NaN                NaN   \n",
       "699  Metropolitan     ...                      NaN                NaN   \n",
       "700  Metropolitan     ...                      NaN                NaN   \n",
       "701    Provincial     ...                      NaN                NaN   \n",
       "702  Metropolitan     ...                      NaN                NaN   \n",
       "703  Metropolitan     ...                      NaN                NaN   \n",
       "704  Metropolitan     ...                      NaN                NaN   \n",
       "705  Metropolitan     ...                      NaN                NaN   \n",
       "706    Provincial     ...                      NaN                NaN   \n",
       "707  Metropolitan     ...                      NaN                NaN   \n",
       "708        Remote     ...                      NaN                NaN   \n",
       "709  Metropolitan     ...                      NaN                NaN   \n",
       "710    Provincial     ...                      NaN                NaN   \n",
       "711    Provincial     ...                      NaN                NaN   \n",
       "712  Metropolitan     ...                      NaN                NaN   \n",
       "713  Metropolitan     ...                      NaN                NaN   \n",
       "\n",
       "     Year 9 | Spelling_y Year 9 | Writing_y Year range_y Year 3 | Overall_y  \\\n",
       "0                    561                543      U, R-12              346.2   \n",
       "1                    NaN                NaN          3-7              416.4   \n",
       "2                    NaN                NaN       U, R-7              347.4   \n",
       "3                    NaN                NaN          R-7              409.0   \n",
       "4                    NaN                NaN       U, R-7              338.2   \n",
       "5                    NaN                NaN          3-7              394.2   \n",
       "6                    NaN                NaN          R-7              392.2   \n",
       "7                    NaN                NaN       U, R-7              413.6   \n",
       "8                    545                546         R-12              328.4   \n",
       "9                    538                521         R-12              355.8   \n",
       "10                   538                549         8-12                NaN   \n",
       "11                   596                603      U, 8-12                NaN   \n",
       "12                   NaN                NaN          R-7              406.8   \n",
       "13                   554                513         R-12              367.2   \n",
       "14                   563                565         R-12              441.2   \n",
       "15                   NaN                NaN          R-7              391.8   \n",
       "16                   572                539         R-12              417.0   \n",
       "17                   551                523         8-12                NaN   \n",
       "18                   NaN                NaN          R-7              414.8   \n",
       "19                   NaN                NaN          R-7              415.0   \n",
       "20                   NaN                NaN          R-7              381.4   \n",
       "21                   NaN                NaN       U, R-7              421.0   \n",
       "22                   594                577      U, 8-12                NaN   \n",
       "23                   576                558      U, R-12              389.2   \n",
       "24                   564                561      U, R-12              405.2   \n",
       "25                   NaN                NaN       U, R-7              398.2   \n",
       "26                   575                562      U, R-12              390.6   \n",
       "27                   NaN                NaN      U, 3-12              417.2   \n",
       "28                   596                583      U, 8-12                NaN   \n",
       "29                   570                543      U, R-12              388.4   \n",
       "..                   ...                ...          ...                ...   \n",
       "684                  NaN                NaN      U, 8-12                NaN   \n",
       "685                  NaN                NaN     U, 11-12                NaN   \n",
       "686                  NaN                NaN     U, 11-12                NaN   \n",
       "687                  560                561         8-12                NaN   \n",
       "688                  547                522         8-12                NaN   \n",
       "689                  592                572      U, 8-12                NaN   \n",
       "690                  585                568         8-12                NaN   \n",
       "691                  545                526      U, 8-12                NaN   \n",
       "692                  NaN                NaN          R-7              406.4   \n",
       "693                  554                518      U, 8-12                NaN   \n",
       "694                  NaN                NaN          R-7              435.0   \n",
       "695                  552                528      U, 8-12                NaN   \n",
       "696                  NaN                NaN          R-7              402.2   \n",
       "697                  NaN                NaN       U, R-7              373.4   \n",
       "698                  NaN                NaN            U                NaN   \n",
       "699                  NaN                NaN          R-7              418.2   \n",
       "700                  NaN                NaN          3-7              383.6   \n",
       "701                  NaN                NaN       U, R-7              443.0   \n",
       "702                  NaN                NaN       U, R-7              416.0   \n",
       "703                  NaN                NaN       U, R-7              410.0   \n",
       "704                  NaN                NaN       U, R-7              413.6   \n",
       "705                  NaN                NaN       U, R-7              406.6   \n",
       "706                  NaN                NaN          R-7              377.2   \n",
       "707                  NaN                NaN          R-7              442.8   \n",
       "708                  NaN                NaN          R-7              403.0   \n",
       "709                  NaN                NaN          R-7              415.2   \n",
       "710                  NaN                NaN          R-7                NaN   \n",
       "711                  NaN                NaN          R-7              370.4   \n",
       "712                  NaN                NaN       U, R-7              423.2   \n",
       "713                  NaN                NaN       U, R-7              404.2   \n",
       "\n",
       "     Year 5 | Overall_y Year 7 | Overall_y Year 9 | Overall_y Improv | 7-9  \n",
       "0                 454.8              514.6              555.8         22.4  \n",
       "1                 496.2              548.6                NaN          NaN  \n",
       "2                 441.4              509.4                NaN          NaN  \n",
       "3                 487.0              539.8                NaN          NaN  \n",
       "4                 394.6              498.0                NaN          NaN  \n",
       "5                 496.4              563.4                NaN          NaN  \n",
       "6                 488.8              535.0                NaN          NaN  \n",
       "7                 478.6              552.8                NaN          NaN  \n",
       "8                 449.8              520.2              553.0         52.0  \n",
       "9                 419.8              499.6              538.0         61.0  \n",
       "10                  NaN                NaN              546.0          NaN  \n",
       "11                  NaN                NaN              600.4          NaN  \n",
       "12                487.0              535.4                NaN          NaN  \n",
       "13                468.4              549.0              537.8        -12.8  \n",
       "14                502.4              540.4              564.0         28.6  \n",
       "15                  NaN                NaN                NaN          NaN  \n",
       "16                518.0              539.4              568.0         72.0  \n",
       "17                  NaN                NaN              550.4          NaN  \n",
       "18                482.6              548.8                NaN          NaN  \n",
       "19                450.4              554.6                NaN          NaN  \n",
       "20                460.6              523.2                NaN          NaN  \n",
       "21                513.2              530.8                NaN          NaN  \n",
       "22                  NaN                NaN              594.2          NaN  \n",
       "23                476.0              529.4              572.4         37.4  \n",
       "24                453.6              498.4              569.0         48.2  \n",
       "25                441.0              489.0                NaN          NaN  \n",
       "26                496.6              530.6              571.4         46.6  \n",
       "27                534.8              589.8                NaN         44.4  \n",
       "28                  NaN                NaN              591.6          NaN  \n",
       "29                488.6              542.8              565.8         24.4  \n",
       "..                  ...                ...                ...          ...  \n",
       "684                 NaN                NaN                NaN          NaN  \n",
       "685                 NaN                NaN                NaN          NaN  \n",
       "686                 NaN                NaN                NaN          NaN  \n",
       "687                 NaN                NaN              565.2          NaN  \n",
       "688                 NaN                NaN              547.4          NaN  \n",
       "689                 NaN                NaN              587.4          NaN  \n",
       "690                 NaN                NaN              585.8          NaN  \n",
       "691                 NaN                NaN              546.2          NaN  \n",
       "692               460.6              519.0                NaN          NaN  \n",
       "693                 NaN                NaN              539.2          NaN  \n",
       "694               509.8              574.8                NaN          NaN  \n",
       "695                 NaN                NaN              546.4          NaN  \n",
       "696               473.6              544.8                NaN          NaN  \n",
       "697               461.8              480.0                NaN          NaN  \n",
       "698                 NaN                NaN                NaN          NaN  \n",
       "699               471.6              540.2                NaN          NaN  \n",
       "700               486.2              503.2                NaN          NaN  \n",
       "701               518.8              576.8                NaN          NaN  \n",
       "702               465.4              539.2                NaN          NaN  \n",
       "703               486.4              539.4                NaN          NaN  \n",
       "704               483.8                NaN                NaN          NaN  \n",
       "705               519.6              529.6                NaN          NaN  \n",
       "706               430.0              477.2                NaN          NaN  \n",
       "707               506.2              581.8                NaN          NaN  \n",
       "708               481.8                NaN                NaN          NaN  \n",
       "709               471.0              537.2                NaN          NaN  \n",
       "710                 NaN                NaN                NaN          NaN  \n",
       "711                 NaN                NaN                NaN          NaN  \n",
       "712               518.0              551.0                NaN          NaN  \n",
       "713               513.4                NaN                NaN          NaN  \n",
       "\n",
       "[714 rows x 94 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newdf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index([u'Unnamed: 0', u'Average ICSEA value', u'Boys', u'Completed senior secondary school', u'Full-time equivalent enrolments', u'Full-time equivalent non-teaching staff', u'Full-time equivalent teaching staff', u'Girls', u'Indigenous students', u'Location', u'Name', u'Non-teaching staff', u'SMCLID', u'School ICSEA value', u'School sector', u'School type', u'School-based apprenticeships and traineeships', u'Senior secondary certificate awarded', u'Teaching staff', u'Total enrolments', u'VET enrolments', u'Year', u'Year 3 | Grammar', u'Year 3 | Numeracy', u'Year 3 | Reading', u'Year 3 | Spelling', u'Year 3 | Writing', u'Year 5 | Grammar', u'Year 5 | Numeracy', u'Year 5 | Reading', u'Year 5 | Spelling', u'Year 5 | Writing', u'Year 7 | Grammar', u'Year 7 | Numeracy', u'Year 7 | Reading', u'Year 7 | Spelling', u'Year 7 | Writing', u'Year 9 | Grammar', u'Year 9 | Numeracy', u'Year 9 | Reading', u'Year 9 | Spelling', u'Year 9 | Writing', u'Year range', u'Year 3 | Overall', u'Year 5 | Overall', u'Year 7 | Overall', u'Year 9 | Overall'], dtype='object')"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}