SAT scores.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0_level_0</th>\n",
       "      <th>Unnamed: 1_level_0</th>\n",
       "      <th>Unnamed: 2_level_0</th>\n",
       "      <th>Unnamed: 3_level_0</th>\n",
       "      <th>Unnamed: 4_level_0</th>\n",
       "      <th>Unnamed: 5_level_0</th>\n",
       "      <th>Unnamed: 6_level_0</th>\n",
       "      <th>Level 1Not Met</th>\n",
       "      <th>Unnamed: 8_level_0</th>\n",
       "      <th>Level 2Approaching</th>\n",
       "      <th>Unnamed: 10_level_0</th>\n",
       "      <th>Level 3Met</th>\n",
       "      <th>Unnamed: 12_level_0</th>\n",
       "      <th>Level 4Exceeded</th>\n",
       "      <th>Unnamed: 14_level_0</th>\n",
       "      <th>Level 3&amp;4Met or Exceeded</th>\n",
       "      <th>Unnamed: 16_level_0</th>\n",
       "      <th>Unnamed: 17_level_0</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>District</th>\n",
       "      <th>District Code</th>\n",
       "      <th>Subject</th>\n",
       "      <th>Total Numberof Students</th>\n",
       "      <th>Total NumberTested</th>\n",
       "      <th>Connecticut School Day SATParticipationRate</th>\n",
       "      <th>Total Numberwith Scored Tests</th>\n",
       "      <th>Count</th>\n",
       "      <th>%</th>\n",
       "      <th>Count</th>\n",
       "      <th>%</th>\n",
       "      <th>Count</th>\n",
       "      <th>%</th>\n",
       "      <th>Count</th>\n",
       "      <th>%</th>\n",
       "      <th>Count</th>\n",
       "      <th>%</th>\n",
       "      <th>AverageScore</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Achievement First Hartford Academy Inc. District</td>\n",
       "      <td>=\"2880013\"</td>\n",
       "      <td>ELA</td>\n",
       "      <td>32</td>\n",
       "      <td>30</td>\n",
       "      <td>93.8</td>\n",
       "      <td>30</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>7</td>\n",
       "      <td>23.3</td>\n",
       "      <td>17</td>\n",
       "      <td>56.7</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Achievement First Hartford Academy Inc. District</td>\n",
       "      <td>=\"2880013\"</td>\n",
       "      <td>Math</td>\n",
       "      <td>32</td>\n",
       "      <td>30</td>\n",
       "      <td>93.8</td>\n",
       "      <td>30</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>13</td>\n",
       "      <td>43.3</td>\n",
       "      <td>14</td>\n",
       "      <td>46.7</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Amistad Academy District</td>\n",
       "      <td>=\"2790013\"</td>\n",
       "      <td>ELA</td>\n",
       "      <td>45</td>\n",
       "      <td>44</td>\n",
       "      <td>97.8</td>\n",
       "      <td>44</td>\n",
       "      <td>6</td>\n",
       "      <td>13.6</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>28</td>\n",
       "      <td>63.6</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Amistad Academy District</td>\n",
       "      <td>=\"2790013\"</td>\n",
       "      <td>Math</td>\n",
       "      <td>45</td>\n",
       "      <td>44</td>\n",
       "      <td>97.8</td>\n",
       "      <td>44</td>\n",
       "      <td>11</td>\n",
       "      <td>25.0</td>\n",
       "      <td>23</td>\n",
       "      <td>52.3</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>10</td>\n",
       "      <td>22.7</td>\n",
       "      <td>470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ansonia School District</td>\n",
       "      <td>=\"0020011\"</td>\n",
       "      <td>ELA</td>\n",
       "      <td>151</td>\n",
       "      <td>138</td>\n",
       "      <td>91.4</td>\n",
       "      <td>138</td>\n",
       "      <td>37</td>\n",
       "      <td>26.8</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>62</td>\n",
       "      <td>44.9</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>476</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 Unnamed: 0_level_0 Unnamed: 1_level_0  \\\n",
       "                                           District      District Code   \n",
       "0  Achievement First Hartford Academy Inc. District         =\"2880013\"   \n",
       "1  Achievement First Hartford Academy Inc. District         =\"2880013\"   \n",
       "2                          Amistad Academy District         =\"2790013\"   \n",
       "3                          Amistad Academy District         =\"2790013\"   \n",
       "4                           Ansonia School District         =\"0020011\"   \n",
       "\n",
       "  Unnamed: 2_level_0      Unnamed: 3_level_0 Unnamed: 4_level_0  \\\n",
       "             Subject Total Numberof Students Total NumberTested   \n",
       "0                ELA                      32                 30   \n",
       "1               Math                      32                 30   \n",
       "2                ELA                      45                 44   \n",
       "3               Math                      45                 44   \n",
       "4                ELA                     151                138   \n",
       "\n",
       "                           Unnamed: 5_level_0            Unnamed: 6_level_0  \\\n",
       "  Connecticut School Day SATParticipationRate Total Numberwith Scored Tests   \n",
       "0                                        93.8                            30   \n",
       "1                                        93.8                            30   \n",
       "2                                        97.8                            44   \n",
       "3                                        97.8                            44   \n",
       "4                                        91.4                           138   \n",
       "\n",
       "  Level 1Not Met Unnamed: 8_level_0 Level 2Approaching Unnamed: 10_level_0  \\\n",
       "           Count                  %              Count                   %   \n",
       "0              *                  *                  7                23.3   \n",
       "1              *                  *                 13                43.3   \n",
       "2              6               13.6                  *                   *   \n",
       "3             11               25.0                 23                52.3   \n",
       "4             37               26.8                  *                   *   \n",
       "\n",
       "  Level 3Met Unnamed: 12_level_0 Level 4Exceeded Unnamed: 14_level_0  \\\n",
       "       Count                   %           Count                   %   \n",
       "0         17                56.7               *                   *   \n",
       "1         14                46.7               *                   *   \n",
       "2         28                63.6               *                   *   \n",
       "3          *                   *               *                   *   \n",
       "4         62                44.9               *                   *   \n",
       "\n",
       "  Level 3&4Met or Exceeded Unnamed: 16_level_0 Unnamed: 17_level_0  \n",
       "                     Count                   %        AverageScore  \n",
       "0                        *                   *                 529  \n",
       "1                        *                   *                 537  \n",
       "2                        *                   *                 515  \n",
       "3                       10                22.7                 470  \n",
       "4                        *                   *                 476  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def get_data(year=\"2015-16\"):\n",
    "    \n",
    "    ret = pd.read_csv(\"data/CTSchoolDaySAT\" + year + \".csv\",skiprows=3,header=[0,1])\n",
    "    \n",
    "    return ret\n",
    "\n",
    "get_data().head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0_level_0</th>\n",
       "      <th>Unnamed: 1_level_0</th>\n",
       "      <th>Unnamed: 2_level_0</th>\n",
       "      <th>Unnamed: 3_level_0</th>\n",
       "      <th>Unnamed: 4_level_0</th>\n",
       "      <th>Unnamed: 5_level_0</th>\n",
       "      <th>Unnamed: 6_level_0</th>\n",
       "      <th>Level 1Not Met</th>\n",
       "      <th>Unnamed: 8_level_0</th>\n",
       "      <th>Level 2Approaching</th>\n",
       "      <th>Unnamed: 10_level_0</th>\n",
       "      <th>Level 3Met</th>\n",
       "      <th>Unnamed: 12_level_0</th>\n",
       "      <th>Level 4Exceeded</th>\n",
       "      <th>Unnamed: 14_level_0</th>\n",
       "      <th>Level 3&amp;4Met or Exceeded</th>\n",
       "      <th>Unnamed: 16_level_0</th>\n",
       "      <th>Unnamed: 17_level_0</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>District</th>\n",
       "      <th>District Code</th>\n",
       "      <th>Subject</th>\n",
       "      <th>Total Numberof Students</th>\n",
       "      <th>Total NumberTested</th>\n",
       "      <th>Connecticut School Day SATParticipationRate</th>\n",
       "      <th>Total Numberwith Scored Tests</th>\n",
       "      <th>Count</th>\n",
       "      <th>%</th>\n",
       "      <th>Count</th>\n",
       "      <th>%</th>\n",
       "      <th>Count</th>\n",
       "      <th>%</th>\n",
       "      <th>Count</th>\n",
       "      <th>%</th>\n",
       "      <th>Count</th>\n",
       "      <th>%</th>\n",
       "      <th>AverageScore</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Achievement First Hartford Academy Inc. District</td>\n",
       "      <td>=\"2880013\"</td>\n",
       "      <td>ELA</td>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "      <td>100.0</td>\n",
       "      <td>39</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>10</td>\n",
       "      <td>25.6</td>\n",
       "      <td>22</td>\n",
       "      <td>56.4</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Achievement First Hartford Academy Inc. District</td>\n",
       "      <td>=\"2880013\"</td>\n",
       "      <td>Math</td>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "      <td>100.0</td>\n",
       "      <td>38</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>20</td>\n",
       "      <td>52.6</td>\n",
       "      <td>13</td>\n",
       "      <td>34.2</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>494</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Amistad Academy District</td>\n",
       "      <td>=\"2790013\"</td>\n",
       "      <td>ELA</td>\n",
       "      <td>50</td>\n",
       "      <td>48</td>\n",
       "      <td>96.0</td>\n",
       "      <td>47</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>9</td>\n",
       "      <td>19.1</td>\n",
       "      <td>33</td>\n",
       "      <td>70.2</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>*</td>\n",
       "      <td>511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Amistad Academy District</td>\n",
       "      <td>=\"2790013\"</td>\n",
       "      <td>Math</td>\n",
       "      <td>50</td>\n",
       "      <td>48</td>\n",
       "      <td>96.0</td>\n",
       "      <td>47</td>\n",
       "      <td>10</td>\n",
       "      <td>21.3</td>\n",
       "      <td>28</td>\n",
       "      <td>59.6</td>\n",
       "      <td>9</td>\n",
       "      <td>19.1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9</td>\n",
       "      <td>19.1</td>\n",
       "      <td>467</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ansonia School District</td>\n",
       "      <td>=\"0020011\"</td>\n",
       "      <td>ELA</td>\n",
       "      <td>134</td>\n",
       "      <td>127</td>\n",
       "      <td>94.8</td>\n",
       "      <td>127</td>\n",
       "      <td>38</td>\n",
       "      <td>29.9</td>\n",
       "      <td>26</td>\n",
       "      <td>20.5</td>\n",
       "      <td>52</td>\n",
       "      <td>40.9</td>\n",
       "      <td>11</td>\n",
       "      <td>8.7</td>\n",
       "      <td>63</td>\n",
       "      <td>49.6</td>\n",
       "      <td>478</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 Unnamed: 0_level_0 Unnamed: 1_level_0  \\\n",
       "                                           District      District Code   \n",
       "0  Achievement First Hartford Academy Inc. District         =\"2880013\"   \n",
       "1  Achievement First Hartford Academy Inc. District         =\"2880013\"   \n",
       "2                          Amistad Academy District         =\"2790013\"   \n",
       "3                          Amistad Academy District         =\"2790013\"   \n",
       "4                           Ansonia School District         =\"0020011\"   \n",
       "\n",
       "  Unnamed: 2_level_0      Unnamed: 3_level_0 Unnamed: 4_level_0  \\\n",
       "             Subject Total Numberof Students Total NumberTested   \n",
       "0                ELA                      39                 39   \n",
       "1               Math                      39                 39   \n",
       "2                ELA                      50                 48   \n",
       "3               Math                      50                 48   \n",
       "4                ELA                     134                127   \n",
       "\n",
       "                           Unnamed: 5_level_0            Unnamed: 6_level_0  \\\n",
       "  Connecticut School Day SATParticipationRate Total Numberwith Scored Tests   \n",
       "0                                       100.0                            39   \n",
       "1                                       100.0                            38   \n",
       "2                                        96.0                            47   \n",
       "3                                        96.0                            47   \n",
       "4                                        94.8                           127   \n",
       "\n",
       "  Level 1Not Met Unnamed: 8_level_0 Level 2Approaching Unnamed: 10_level_0  \\\n",
       "           Count                  %              Count                   %   \n",
       "0              *                  *                 10                25.6   \n",
       "1              *                  *                 20                52.6   \n",
       "2              *                  *                  9                19.1   \n",
       "3             10               21.3                 28                59.6   \n",
       "4             38               29.9                 26                20.5   \n",
       "\n",
       "  Level 3Met Unnamed: 12_level_0 Level 4Exceeded Unnamed: 14_level_0  \\\n",
       "       Count                   %           Count                   %   \n",
       "0         22                56.4               *                   *   \n",
       "1         13                34.2               *                   *   \n",
       "2         33                70.2               *                   *   \n",
       "3          9                19.1               0                 0.0   \n",
       "4         52                40.9              11                 8.7   \n",
       "\n",
       "  Level 3&4Met or Exceeded Unnamed: 16_level_0 Unnamed: 17_level_0  \n",
       "                     Count                   %        AverageScore  \n",
       "0                        *                   *                 488  \n",
       "1                        *                   *                 494  \n",
       "2                        *                   *                 511  \n",
       "3                        9                19.1                 467  \n",
       "4                       63                49.6                 478  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "scores_17 = get_data(year=\"2016-17\")\n",
    "scores_17.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Achievement First Hartford Academy Inc. District (39)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [52.600000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [34.200000000000003], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Amistad Academy District (48)': ({'data': [21.300000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [59.600000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [19.100000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [0.0], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [19.100000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Ansonia School District (127)': ({'data': [45.200000000000003],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [38.100000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [16.699999999999999], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Area Cooperative Educational Services (15)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [None], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Avon School District (282)': ({'data': [4.5999999999999996],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [16.300000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [36.899999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [42.200000000000003], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [79.099999999999994], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Berlin School District (216)': ({'data': [12.5],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [42.100000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [33.299999999999997], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [12.0], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [45.399999999999999], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Bethel School District (194)': ({'data': [9.3000000000000007],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [42.799999999999997], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [36.100000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [11.9], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [47.899999999999999], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Bloomfield School District (154)': ({'data': [29.899999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [55.200000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [14.9], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Bolton School District (79)': ({'data': [17.699999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [32.899999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [38.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [11.4], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [49.399999999999999], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Branford School District (215)': ({'data': [18.600000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [38.600000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [33.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [9.8000000000000007], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [42.799999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Bridgeport Achievement First District (34)': ({'data': [23.5],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [52.899999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [23.5], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [0.0], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [23.5], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Bridgeport School District (1143)': ({'data': [47.299999999999997],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [36.799999999999997], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [12.699999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [3.2999999999999998], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [15.9], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Bristol School District (552)': ({'data': [21.800000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [47.200000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [26.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [5.0999999999999996], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [31.0], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Brookfield School District (207)': ({'data': [5.2999999999999998],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [34.799999999999997], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [44.399999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [15.5], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [59.899999999999999], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Brooklyn School District (*)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [None], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Canton School District (115)': ({'data': [5.2000000000000002],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [27.0], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [42.600000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [25.199999999999999], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [67.799999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Capital Preparatory Harbor School Inc. District (33)': ({'data': [51.5],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [None], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [0.0], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Capitol Region Education Council (550)': ({'data': [33.899999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [43.399999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [16.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [6.7000000000000002], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [22.800000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Cheshire School District (326)': ({'data': [7.7000000000000002],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [27.5], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [43.799999999999997], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [21.0], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [64.799999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Clinton School District (124)': ({'data': [18.699999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [39.0], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [35.799999999999997], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [6.5], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [42.299999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Colchester School District (218)': ({'data': [11.9],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [33.0], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [42.700000000000003], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [12.4], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [55.0], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Common Ground High School District (43)': ({'data': [39.5],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [37.200000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [23.300000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Connecticut Technical High School System (2481)': ({'data': [28.600000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [57.100000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [13.199999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [1.1000000000000001], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [14.300000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Cooperative Educational Services (15)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [None], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Coventry School District (115)': ({'data': [11.300000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [33.0], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [43.5], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [12.199999999999999], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [55.700000000000003], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Cromwell School District (149)': ({'data': [12.800000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [34.899999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [40.299999999999997], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [12.1], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [52.299999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Danbury School District (674)': ({'data': [29.699999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [45.200000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [21.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [4.0], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [25.100000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Darien School District (325)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [None], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [36.700000000000003], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [49.100000000000001], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [85.799999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Derby School District (82)': ({'data': [34.600000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [38.299999999999997], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [27.199999999999999], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'East Granby School District (56)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [30.399999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [53.600000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'East Haddam School District (80)': ({'data': [27.5],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [45.0], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [27.5], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'East Hampton School District (106)': ({'data': [13.199999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [43.399999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [31.100000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [12.300000000000001], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [43.399999999999999], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'East Hartford School District (442)': ({'data': [36.700000000000003],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [38.299999999999997], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [19.899999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [5.0999999999999996], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [24.899999999999999], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'East Haven School District (217)': ({'data': [24.0],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [57.600000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [18.399999999999999], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'East Lyme School District (274)': ({'data': [8.8000000000000007],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [34.299999999999997], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [33.200000000000003], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [23.699999999999999], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [56.899999999999999], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'East Windsor School District (87)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [39.100000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [34.5], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Eastern Connecticut Regional Educational Service Center (EASTCONN) (75)': ({'data': [42.700000000000003],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [49.299999999999997], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [8.0], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'EdAdvance (*)': ({'data': [None], 'index': 0, 'name': 'Level 1 - Not met'},\n",
       "  {'data': [None], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Ellington School District (174)': ({'data': [6.9000000000000004],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [42.200000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [41.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [9.8000000000000007], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [50.899999999999999], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Elm City College Preparatory School District (29)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [41.399999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [31.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Enfield School District (342)': ({'data': [13.199999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [49.700000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [31.300000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [5.7999999999999998], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [37.100000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Explorations District (21)': ({'data': [42.899999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [42.899999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Fairfield School District (759)': ({'data': [6.5],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [31.100000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [43.299999999999997], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [19.100000000000001], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [62.5], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Farmington School District (287)': ({'data': [6.2999999999999998],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [26.899999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [39.200000000000003], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [27.600000000000001], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [66.799999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Glastonbury School District (480)': ({'data': [5.4000000000000004],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [19.899999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [41.200000000000003], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [33.5], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [74.700000000000003], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Granby School District (152)': ({'data': [8.5999999999999996],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [22.399999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [44.700000000000003], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [24.300000000000001], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [69.099999999999994], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Greenwich School District (598)': ({'data': [9.1999999999999993],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [28.600000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [33.700000000000003], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [28.5], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [62.100000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Griswold School District (139)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [47.5], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [35.299999999999997], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Groton School District (228)': ({'data': [20.399999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [41.200000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [27.899999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [10.6], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [38.5], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Guilford School District (286)': ({'data': [10.199999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [26.699999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [40.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [23.199999999999999], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [63.200000000000003], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Hamden School District (389)': ({'data': [25.600000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [46.0], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [25.100000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [3.3999999999999999], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [28.399999999999999], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Hartford School District (1114)': ({'data': [48.299999999999997],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [36.299999999999997], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [12.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [3.3999999999999999], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [15.300000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Highville Charter School District (22)': ({'data': [50.0],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [50.0], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [0.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [0.0], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [0.0], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Jumoke Academy District (11)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [None], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Killingly School District (178)': ({'data': [28.699999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [48.899999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [22.5], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Learn (191)': ({'data': [31.100000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [41.100000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [22.100000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [5.7999999999999998], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [27.899999999999999], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Lebanon School District (88)': ({'data': [17.0],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [35.200000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [39.799999999999997], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [8.0], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [47.700000000000003], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Ledyard School District (194)': ({'data': [18.0],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [39.700000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [30.399999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [11.9], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [42.299999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Litchfield School District (65)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [36.899999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [41.5], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Madison School District (290)': ({'data': [2.3999999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [24.899999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [48.799999999999997], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [23.899999999999999], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [72.700000000000003], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Manchester School District (338)': ({'data': [28.0],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [50.0], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [19.600000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [2.3999999999999999], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [22.0], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Meriden School District (506)': ({'data': [44.0],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [40.399999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [13.800000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [1.8], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [15.6], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Middletown School District (315)': ({'data': [28.899999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [38.399999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [25.699999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [7.0], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [32.700000000000003], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Milford School District (409)': ({'data': [13.800000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [37.799999999999997], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [37.600000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [10.800000000000001], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [48.399999999999999], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Monroe School District (292)': ({'data': [6.2000000000000002],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [32.200000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [37.299999999999997], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [24.300000000000001], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [61.600000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Montville School District (179)': ({'data': [14.5],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [41.299999999999997], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [36.299999999999997], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [7.7999999999999998], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [44.100000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Naugatuck School District (276)': ({'data': [32.399999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [45.5], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [22.199999999999999], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'New Britain School District (473)': ({'data': [50.399999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [40.299999999999997], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [9.3000000000000007], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'New Canaan School District (301)': ({'data': [3.7000000000000002],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [14.699999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [42.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [39.700000000000003], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [81.700000000000003], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'New Fairfield School District (203)': ({'data': [15.300000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [41.899999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [34.5], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [8.4000000000000004], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [42.899999999999999], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'New Haven School District (1178)': ({'data': [45.200000000000003],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [40.200000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [11.9], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [2.7000000000000002], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [14.6], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'New London School District (216)': ({'data': [40.899999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [38.100000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [17.199999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [3.7000000000000002], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [20.899999999999999], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'New Milford School District (321)': ({'data': [11.5],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [36.799999999999997], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [38.899999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [12.800000000000001], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [51.700000000000003], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Newington School District (287)': ({'data': [15.699999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [43.200000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [31.399999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [9.8000000000000007], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [41.100000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Newtown School District (410)': ({'data': [5.0999999999999996],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [21.699999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [48.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [25.100000000000001], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [73.200000000000003], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'North Branford School District (145)': ({'data': [11.699999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [49.0], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [30.300000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [9.0], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [39.299999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'North Haven School District (240)': ({'data': [10.800000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [41.700000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [37.5], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [10.0], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [47.5], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'North Stonington School District (43)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [41.899999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [30.199999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Norwalk School District (818)': ({'data': [24.0],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [44.299999999999997], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [23.300000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [8.4000000000000004], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [31.800000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Norwich Free Academy District (534)': ({'data': [25.899999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [38.600000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [25.699999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [9.8000000000000007], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [35.5], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Norwich School District (*)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [None], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Old Saybrook School District (109)': ({'data': [12.800000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [30.300000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [40.399999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [16.5], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [56.899999999999999], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Oxford School District (135)': ({'data': [8.0999999999999996],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [33.299999999999997], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [46.700000000000003], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [11.9], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [58.5], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Path Academy District (20)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [None], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Plainfield School District (151)': ({'data': [27.5],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [45.0], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [27.5], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Plainville School District (155)': ({'data': [18.199999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [40.299999999999997], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [37.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [4.5], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [41.600000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Plymouth School District (121)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [39.200000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [37.5], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Portland School District (86)': ({'data': [14.1],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [34.100000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [32.899999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [18.800000000000001], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [51.799999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Putnam School District (64)': ({'data': [28.100000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [53.100000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [18.800000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Regional School District 01 (85)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [46.399999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [28.600000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Regional School District 04 (154)': ({'data': [9.6999999999999993],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [39.600000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [39.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [11.699999999999999], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [50.600000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Regional School District 05 (355)': ({'data': [4.5],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [28.199999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [40.299999999999997], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [27.0], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [67.299999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Regional School District 06 (104)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [49.0], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [30.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Regional School District 07 (173)': ({'data': [9.8000000000000007],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [26.600000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [45.700000000000003], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [17.899999999999999], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [63.600000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Regional School District 08 (268)': ({'data': [3.7000000000000002],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [22.0], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [45.899999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [28.399999999999999], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [74.299999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Regional School District 09 (224)': ({'data': [4.0],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [26.300000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [44.600000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [25.0], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [69.599999999999994], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Regional School District 10 (196)': ({'data': [8.1999999999999993],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [29.100000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [42.299999999999997], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [20.399999999999999], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [62.799999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Regional School District 11 (30)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [33.299999999999997], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [40.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Regional School District 12 (58)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [37.899999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [44.799999999999997], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Regional School District 13 (126)': ({'data': [7.9000000000000004],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [31.0], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [44.399999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [16.699999999999999], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [61.100000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Regional School District 14 (192)': ({'data': [13.0],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [35.899999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [37.5], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [13.5], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [51.0], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Regional School District 15 (285)': ({'data': [7.0],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [25.399999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [46.799999999999997], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [20.800000000000001], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [67.599999999999994], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Regional School District 16 (168)': ({'data': [16.699999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [41.700000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [34.5], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [7.0999999999999996], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [41.700000000000003], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Regional School District 17 (164)': ({'data': [7.2999999999999998],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [38.399999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [38.399999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [15.9], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [54.299999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Regional School District 18 (113)': ({'data': [5.2999999999999998],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [24.800000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [49.600000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [20.399999999999999], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [69.900000000000006], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Regional School District 19 (298)': ({'data': [8.4000000000000004],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [29.899999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [37.200000000000003], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [24.5], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [61.700000000000003], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Ridgefield School District (400)': ({'data': [3.2999999999999998],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [18.800000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [43.399999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [34.600000000000001], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [77.900000000000006], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Rocky Hill School District (177)': ({'data': [13.0],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [28.199999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [42.899999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [15.800000000000001], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [58.799999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Seymour School District (149)': ({'data': [10.699999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [36.200000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [45.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [8.0999999999999996], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [53.0], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Shelton School District (322)': ({'data': [10.300000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [37.700000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [37.399999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [14.6], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [52.0], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Simsbury School District (329)': ({'data': [3.2999999999999998],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [19.5], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [42.899999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [34.299999999999997], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [77.200000000000003], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Somers School District (117)': ({'data': [13.800000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [37.100000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [25.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [24.100000000000001], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [49.100000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'South Windsor School District (328)': ({'data': [7.2999999999999998],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [33.799999999999997], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [36.600000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [22.300000000000001], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [58.799999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Southington School District (527)': ({'data': [9.6999999999999993],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [30.199999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [44.5], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [15.6], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [60.100000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Stafford School District (84)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [31.300000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [50.600000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Stamford Academy District (25)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [None], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [0.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [0.0], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [0.0], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Stamford School District (1032)': ({'data': [27.300000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [39.600000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [21.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [12.1], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [33.100000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Stonington School District (172)': ({'data': [10.5],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [33.100000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [39.5], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [16.899999999999999], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [56.399999999999999], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Stratford School District (516)': ({'data': [26.100000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [45.100000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [23.300000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [5.4000000000000004], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [28.800000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Suffield School District (194)': ({'data': [7.2000000000000002],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [36.600000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [35.600000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [20.600000000000001], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [56.200000000000003], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'The Bridge Academy District (38)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [57.899999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [0.0], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'The Gilbert School District (83)': ({'data': [19.300000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [37.299999999999997], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [30.100000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [13.300000000000001], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [43.399999999999999], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Thomaston School District (59)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [44.100000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [40.700000000000003], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Thompson School District (63)': ({'data': [33.299999999999997],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [39.700000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [27.0], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Tolland School District (207)': ({'data': [8.6999999999999993],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [24.199999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [45.399999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [21.699999999999999], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [67.099999999999994], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Torrington School District (224)': ({'data': [28.300000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [48.0], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [20.199999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [3.6000000000000001], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [23.800000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Trumbull School District (557)': ({'data': [6.7999999999999998],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [28.899999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [38.600000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [25.699999999999999], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [64.299999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Unified School District #1 (0)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [None], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Unified School District #2 (23)': ({'data': [68.200000000000003],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [None], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [0.0], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Vernon School District (196)': ({'data': [27.199999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [40.0], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [28.699999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [4.0999999999999996], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [32.799999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Voluntown School District (*)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [None], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Wallingford School District (447)': ({'data': [15.0],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [44.700000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [34.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [6.2999999999999998], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [40.299999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Waterbury School District (1126)': ({'data': [50.299999999999997],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [39.200000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [9.5], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [1.0], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [10.5], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Waterford School District (200)': ({'data': [14.0],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [43.5], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [34.0], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [8.5], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [42.5], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Watertown School District (199)': ({'data': [14.6],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [50.0], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [30.800000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [4.5], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [35.399999999999999], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'West Hartford School District (723)': ({'data': [11.4],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [27.800000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [37.399999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [23.399999999999999], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [60.799999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'West Haven School District (325)': ({'data': [34.799999999999997],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [49.399999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [15.800000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Westbrook School District (88)': ({'data': [10.199999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [44.299999999999997], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [38.600000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [6.7999999999999998], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [45.5], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Weston School District (200)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [None], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [42.5], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [39.5], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [82.0], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Westport School District (459)': ({'data': [3.8999999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [17.699999999999999], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [36.299999999999997], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [42.0], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [78.299999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Wethersfield School District (304)': ({'data': [16.100000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [40.100000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [31.300000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [12.5], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [43.799999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Wilton School District (323)': ({'data': [3.1000000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [19.600000000000001], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [39.399999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [37.899999999999999], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [77.299999999999997], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Winchester School District (*)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [None], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Windham School District (123)': ({'data': [39.799999999999997],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [48.799999999999997], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [None], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [11.4], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Windsor Locks School District (106)': ({'data': [None],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [50.5], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [25.699999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [None], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [None], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Windsor School District (288)': ({'data': [18.100000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [46.700000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [29.300000000000001], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [5.9000000000000004], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [35.200000000000003], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Wolcott School District (179)': ({'data': [11.199999999999999],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [40.200000000000003], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [40.799999999999997], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [7.7999999999999998], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [48.600000000000001], 'index': 4, 'name': 'Met or Exceeded'}),\n",
       " 'Woodstock Academy District (243)': ({'data': [12.300000000000001],\n",
       "   'index': 0,\n",
       "   'name': 'Level 1 - Not met'},\n",
       "  {'data': [33.299999999999997], 'index': 1, 'name': 'Level 2 - Approaching'},\n",
       "  {'data': [37.899999999999999], 'index': 2, 'name': 'Level 3 - Met'},\n",
       "  {'data': [16.5], 'index': 3, 'name': 'Level 4 - Exceeded'},\n",
       "  {'data': [54.299999999999997], 'index': 4, 'name': 'Met or Exceeded'})}"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def make_json(data,subject=\"ELA\",base_data={}):\n",
    "\n",
    "    ret = data[data[\"Unnamed: 2_level_0\",\"Subject\"] == subject]\n",
    "    \n",
    "    json_ret = base_data\n",
    "    \n",
    "    \n",
    "    def num_null(n):\n",
    "        \n",
    "        ret = pd.to_numeric(n, errors=\"coerce\")\n",
    "                \n",
    "        #print ret, np.isnan(np.array([ret], dtype=np.float64))[0]\n",
    "        \n",
    "        \n",
    "        #print ret, pd.isnull(n), np.isnan(n)\n",
    "        \n",
    "        \n",
    "        if np.isnan(np.array([ret], dtype=np.float64))[0]:\n",
    "            return None\n",
    "        \n",
    "        return ret\n",
    "    \n",
    "    def convert_row (row):\n",
    "                \n",
    "        school_name = row[\"Unnamed: 0_level_0\",\"District\"]\n",
    "        \n",
    "        test_count = row[\"Unnamed: 4_level_0\",\"Total NumberTested\"]\n",
    "            \n",
    "        json_ret[school_name + \" (\" + str(test_count) + \")\"] = {\n",
    "            \"name\": \"Level 1 - Not met\",\n",
    "            \"index\": 0,\n",
    "            \"data\": [num_null(row[\"Unnamed: 8_level_0\",\"%\"])]\n",
    "           },{\n",
    "            \"name\": \"Level 2 - Approaching\",\n",
    "            \"index\": 1,\n",
    "            \"data\": [num_null(row[\"Unnamed: 10_level_0\",\"%\"])]\n",
    "           },{\n",
    "            \"name\": \"Level 3 - Met\",\n",
    "            \"index\": 2,\n",
    "            \"data\": [num_null(row[\"Unnamed: 12_level_0\",\"%\"])]\n",
    "           },{\n",
    "            \"name\": \"Level 4 - Exceeded\",\n",
    "            \"index\": 3,\n",
    "            \"data\": [num_null(row[\"Unnamed: 14_level_0\",\"%\"])]\n",
    "           },{\n",
    "            \"name\": \"Met or Exceeded\" ,\n",
    "            \"index\": 4,\n",
    "            \"data\": [num_null(row[\"Unnamed: 16_level_0\",\"%\"])]\n",
    "        }\n",
    "                \n",
    "    for index, row in ret.iterrows():\n",
    "        convert_row(row)\n",
    "        \n",
    "    return json_ret\n",
    "    \n",
    "make_json(get_data(year=\"2016-17\"),subject=\"Math\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import json\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#\n",
    "# export the data to json, but with hard-coded state-wide results.\n",
    "# gross, but had to add fast, and they're not included in the district-level\n",
    "# spreadsheet. arg.\n",
    "#\n",
    "open(\"data.js\",\"w\").write(\"var data = \" +\\\n",
    "                          json.dumps(make_json(get_data(year=\"2016-17\"),\n",
    "                                               base_data={\n",
    "                \"State results\":[{\n",
    "                    \"name\": \"Level 1 - Not met\",\n",
    "                    \"index\": 0,\n",
    "                    \"data\": [17.6]\n",
    "                },{\n",
    "                    \"name\": \"Level 2 - Approaching\",\n",
    "                    \"index\": 1,\n",
    "                    \"data\": [17]\n",
    "                },{\n",
    "                    \"name\": \"Level 3 - Met\",\n",
    "                    \"index\": 2,\n",
    "                    \"data\": [46.3]\n",
    "                },{\n",
    "                    \"name\": \"Level 4 - Exceeded\",\n",
    "                    \"index\": 3,\n",
    "                    \"data\":[19.1]\n",
    "                },{\n",
    "                    \"name\": \"Met or Exceeded\" ,\n",
    "                    \"index\": 4,\n",
    "                    \"data\": [65.4]\n",
    "                }]},subject=\"ELA\"))\\\n",
    "                          + \";\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "open(\"data2.js\",\"w\").write(\"var data = \" +\\\n",
    "                           json.dumps(make_json(get_data(year=\"2016-17\"),\n",
    "                                                base_data={\n",
    "                \"State results\":[{\n",
    "                    \"name\": \"Level 1 - Not met\",\n",
    "                    \"index\": 0,\n",
    "                    \"data\": [21.2]\n",
    "                },{\n",
    "                    \"name\": \"Level 2 - Approaching\",\n",
    "                    \"index\": 1,\n",
    "                    \"data\": [37.5]\n",
    "                },{\n",
    "                    \"name\": \"Level 3 - Met\",\n",
    "                    \"index\": 2,\n",
    "                    \"data\": [28.8]\n",
    "                },{\n",
    "                    \"name\": \"Level 4 - Exceeded\",\n",
    "                    \"index\": 3,\n",
    "                    \"data\":[12.5]\n",
    "                },{\n",
    "                    \"name\": \"Met or Exceeded\" ,\n",
    "                    \"index\": 4,\n",
    "                    \"data\": [41.3]\n",
    "                }]},subject=\"Math\"))\\\n",
    "                           + \";\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "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.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}