Skip to content

Instantly share code, notes, and snippets.

@elbertwang3

elbertwang3/2016EXTRATIME.ipynb

Created April 22, 2019 20:59
Show Gist options
  • Save elbertwang3/693cc8c185c84b41c87beb3c086a872f to your computer and use it in GitHub Desktop.
Save elbertwang3/693cc8c185c84b41c87beb3c086a872f to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
2016EXTRATIME.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd\n",
"pd.set_option('display.max_columns', 500)"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/Users/wangelbert/.local/share/virtualenvs/disability-ITEgXPnM/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (2,6,23,24,25,30,31,1828) have mixed types. Specify dtype option on import or set low_memory=False.\n",
" interactivity=interactivity, compiler=compiler, result=result)\n"
]
},
{
"data": {
"text/plain": [
"(96360, 1836)"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"schools = pd.read_csv('2015-16-crdc-data/Data Files and Layouts/CRDC 2015-16 School Data.csv', encoding = \"utf-8\")\n",
"schools.shape"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [],
"source": [
"disability = schools[['LEA_STATE', 'LEA_STATE_NAME', \"LEAID\", \"LEA_NAME\", \"SCH_NAME\", \"TOT_ENR_M\", \"TOT_ENR_F\", \"SCH_ENR_504_M\", \"SCH_ENR_504_F\", \"SCH_ENR_IDEA_M\", \"SCH_ENR_IDEA_F\"]]"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [],
"source": [
"disability = disability.rename(columns = {\"TOT_ENR_M\": \"male enrollment\", \"TOT_ENR_F\": \"female enrollment\",'SCH_ENR_504_M': \"male 504\", 'SCH_ENR_504_F': \"female 504\", \"SCH_ENR_IDEA_M\":\"male idea\", \"SCH_ENR_IDEA_F\": \"female idea\"})"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [],
"source": [
"disability = disability.loc[~disability['male 504'].isin([-2,-5,-6,-7,-8,-9])]\n",
"disability = disability.loc[~disability['female 504'].isin([-2,-5,-6,-7,-8,-9])]\n",
"disability = disability.loc[~disability['male enrollment'].isin([-2,-5,-6,-7,-8,-9])]\n",
"disability = disability.loc[~disability['female enrollment'].isin([-2,-5,-6,-7,-8,-9])]\n",
"disability = disability.loc[~disability['male idea'].isin([-2,-5,-6,-7,-8,-9])]\n",
"disability = disability.loc[~disability['female idea'].isin([-2,-5,-6,-7,-8,-9])]"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [],
"source": [
"disability['total idea'] = disability['male idea'] + disability['female idea']\n",
"disability['total 504'] = disability['male 504'] + disability['female 504']\n",
"disability['total enrollment'] = disability['male enrollment'] + disability['female enrollment']\n",
"disability['male 504 rate'] = disability['male 504']/disability['male enrollment']\n",
"disability['female 504 rate'] = disability['female 504']/disability['female enrollment']\n",
"disability['504 rate'] = disability['total 504']/disability['total enrollment']\n",
"disability['idea rate'] = disability['total idea']/disability['total enrollment']"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>LEA_STATE</th>\n",
" <th>LEA_STATE_NAME</th>\n",
" <th>LEAID</th>\n",
" <th>LEA_NAME</th>\n",
" <th>SCH_NAME</th>\n",
" <th>male enrollment</th>\n",
" <th>female enrollment</th>\n",
" <th>male 504</th>\n",
" <th>female 504</th>\n",
" <th>male idea</th>\n",
" <th>female idea</th>\n",
" <th>total idea</th>\n",
" <th>total 504</th>\n",
" <th>total enrollment</th>\n",
" <th>male 504 rate</th>\n",
" <th>female 504 rate</th>\n",
" <th>504 rate</th>\n",
" <th>idea rate</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100005</td>\n",
" <td>Albertville City</td>\n",
" <td>Albertville Middle School</td>\n",
" <td>358</td>\n",
" <td>346</td>\n",
" <td>2</td>\n",
" <td>5</td>\n",
" <td>28</td>\n",
" <td>16</td>\n",
" <td>44</td>\n",
" <td>7</td>\n",
" <td>704</td>\n",
" <td>0.005587</td>\n",
" <td>0.014451</td>\n",
" <td>0.009943</td>\n",
" <td>0.062500</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100005</td>\n",
" <td>Albertville City</td>\n",
" <td>Albertville High Sch</td>\n",
" <td>645</td>\n",
" <td>650</td>\n",
" <td>5</td>\n",
" <td>8</td>\n",
" <td>43</td>\n",
" <td>28</td>\n",
" <td>71</td>\n",
" <td>13</td>\n",
" <td>1295</td>\n",
" <td>0.007752</td>\n",
" <td>0.012308</td>\n",
" <td>0.010039</td>\n",
" <td>0.054826</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100005</td>\n",
" <td>Albertville City</td>\n",
" <td>Evans Elem Sch</td>\n",
" <td>381</td>\n",
" <td>389</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>31</td>\n",
" <td>25</td>\n",
" <td>56</td>\n",
" <td>4</td>\n",
" <td>770</td>\n",
" <td>0.005249</td>\n",
" <td>0.005141</td>\n",
" <td>0.005195</td>\n",
" <td>0.072727</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100005</td>\n",
" <td>Albertville City</td>\n",
" <td>Albertville Elem Sch</td>\n",
" <td>430</td>\n",
" <td>417</td>\n",
" <td>5</td>\n",
" <td>0</td>\n",
" <td>31</td>\n",
" <td>13</td>\n",
" <td>44</td>\n",
" <td>5</td>\n",
" <td>847</td>\n",
" <td>0.011628</td>\n",
" <td>0.000000</td>\n",
" <td>0.005903</td>\n",
" <td>0.051948</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100005</td>\n",
" <td>Albertville City</td>\n",
" <td>Big Spring Lake Kinderg Sch</td>\n",
" <td>264</td>\n",
" <td>234</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>52</td>\n",
" <td>13</td>\n",
" <td>65</td>\n",
" <td>0</td>\n",
" <td>498</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.130522</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100005</td>\n",
" <td>Albertville City</td>\n",
" <td>Albertville Primary Sch</td>\n",
" <td>555</td>\n",
" <td>534</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>70</td>\n",
" <td>34</td>\n",
" <td>104</td>\n",
" <td>4</td>\n",
" <td>1089</td>\n",
" <td>0.003604</td>\n",
" <td>0.003745</td>\n",
" <td>0.003673</td>\n",
" <td>0.095500</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100006</td>\n",
" <td>Marshall County</td>\n",
" <td>Kate Duncan Smith DAR Middle</td>\n",
" <td>235</td>\n",
" <td>210</td>\n",
" <td>5</td>\n",
" <td>5</td>\n",
" <td>43</td>\n",
" <td>16</td>\n",
" <td>59</td>\n",
" <td>10</td>\n",
" <td>445</td>\n",
" <td>0.021277</td>\n",
" <td>0.023810</td>\n",
" <td>0.022472</td>\n",
" <td>0.132584</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100006</td>\n",
" <td>Marshall County</td>\n",
" <td>Asbury Sch</td>\n",
" <td>289</td>\n",
" <td>250</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>49</td>\n",
" <td>13</td>\n",
" <td>62</td>\n",
" <td>4</td>\n",
" <td>539</td>\n",
" <td>0.006920</td>\n",
" <td>0.008000</td>\n",
" <td>0.007421</td>\n",
" <td>0.115028</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100006</td>\n",
" <td>Marshall County</td>\n",
" <td>Claysville Jr High Sch</td>\n",
" <td>64</td>\n",
" <td>65</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>25</td>\n",
" <td>13</td>\n",
" <td>38</td>\n",
" <td>4</td>\n",
" <td>129</td>\n",
" <td>0.031250</td>\n",
" <td>0.030769</td>\n",
" <td>0.031008</td>\n",
" <td>0.294574</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100006</td>\n",
" <td>Marshall County</td>\n",
" <td>Douglas Elem Sch</td>\n",
" <td>261</td>\n",
" <td>240</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>34</td>\n",
" <td>22</td>\n",
" <td>56</td>\n",
" <td>2</td>\n",
" <td>501</td>\n",
" <td>0.007663</td>\n",
" <td>0.000000</td>\n",
" <td>0.003992</td>\n",
" <td>0.111776</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100006</td>\n",
" <td>Marshall County</td>\n",
" <td>Douglas High Sch</td>\n",
" <td>310</td>\n",
" <td>284</td>\n",
" <td>8</td>\n",
" <td>2</td>\n",
" <td>28</td>\n",
" <td>16</td>\n",
" <td>44</td>\n",
" <td>10</td>\n",
" <td>594</td>\n",
" <td>0.025806</td>\n",
" <td>0.007042</td>\n",
" <td>0.016835</td>\n",
" <td>0.074074</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100006</td>\n",
" <td>Marshall County</td>\n",
" <td>Brindlee Mountain Elementary School</td>\n",
" <td>131</td>\n",
" <td>123</td>\n",
" <td>5</td>\n",
" <td>2</td>\n",
" <td>34</td>\n",
" <td>19</td>\n",
" <td>53</td>\n",
" <td>7</td>\n",
" <td>254</td>\n",
" <td>0.038168</td>\n",
" <td>0.016260</td>\n",
" <td>0.027559</td>\n",
" <td>0.208661</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100006</td>\n",
" <td>Marshall County</td>\n",
" <td>Kate D Smith DAR High Sch</td>\n",
" <td>236</td>\n",
" <td>223</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>16</td>\n",
" <td>10</td>\n",
" <td>26</td>\n",
" <td>4</td>\n",
" <td>459</td>\n",
" <td>0.008475</td>\n",
" <td>0.008969</td>\n",
" <td>0.008715</td>\n",
" <td>0.056645</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100006</td>\n",
" <td>Marshall County</td>\n",
" <td>Brindlee Mountain Primary School</td>\n",
" <td>128</td>\n",
" <td>102</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>19</td>\n",
" <td>16</td>\n",
" <td>35</td>\n",
" <td>4</td>\n",
" <td>230</td>\n",
" <td>0.015625</td>\n",
" <td>0.019608</td>\n",
" <td>0.017391</td>\n",
" <td>0.152174</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100006</td>\n",
" <td>Marshall County</td>\n",
" <td>Robert D Sloman Primary</td>\n",
" <td>258</td>\n",
" <td>238</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>37</td>\n",
" <td>25</td>\n",
" <td>62</td>\n",
" <td>0</td>\n",
" <td>496</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.125000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100006</td>\n",
" <td>Marshall County</td>\n",
" <td>Brindlee Mt Middle Sch</td>\n",
" <td>130</td>\n",
" <td>129</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>19</td>\n",
" <td>19</td>\n",
" <td>38</td>\n",
" <td>2</td>\n",
" <td>259</td>\n",
" <td>0.015385</td>\n",
" <td>0.000000</td>\n",
" <td>0.007722</td>\n",
" <td>0.146718</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100006</td>\n",
" <td>Marshall County</td>\n",
" <td>Brindlee Mt High Sch</td>\n",
" <td>187</td>\n",
" <td>176</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>28</td>\n",
" <td>13</td>\n",
" <td>41</td>\n",
" <td>4</td>\n",
" <td>363</td>\n",
" <td>0.010695</td>\n",
" <td>0.011364</td>\n",
" <td>0.011019</td>\n",
" <td>0.112948</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100006</td>\n",
" <td>Marshall County</td>\n",
" <td>Kate D Smith DAR Elem Sch</td>\n",
" <td>215</td>\n",
" <td>223</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>37</td>\n",
" <td>19</td>\n",
" <td>56</td>\n",
" <td>4</td>\n",
" <td>438</td>\n",
" <td>0.009302</td>\n",
" <td>0.008969</td>\n",
" <td>0.009132</td>\n",
" <td>0.127854</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100006</td>\n",
" <td>Marshall County</td>\n",
" <td>Douglas Middle Sch</td>\n",
" <td>250</td>\n",
" <td>218</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>37</td>\n",
" <td>22</td>\n",
" <td>59</td>\n",
" <td>0</td>\n",
" <td>468</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.126068</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100006</td>\n",
" <td>Marshall County</td>\n",
" <td>Asbury Elem Sch</td>\n",
" <td>237</td>\n",
" <td>259</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>40</td>\n",
" <td>22</td>\n",
" <td>62</td>\n",
" <td>2</td>\n",
" <td>496</td>\n",
" <td>0.000000</td>\n",
" <td>0.007722</td>\n",
" <td>0.004032</td>\n",
" <td>0.125000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100007</td>\n",
" <td>Hoover City</td>\n",
" <td>Trace Crossings Elem Sch</td>\n",
" <td>334</td>\n",
" <td>238</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>70</td>\n",
" <td>28</td>\n",
" <td>98</td>\n",
" <td>4</td>\n",
" <td>572</td>\n",
" <td>0.005988</td>\n",
" <td>0.008403</td>\n",
" <td>0.006993</td>\n",
" <td>0.171329</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100007</td>\n",
" <td>Hoover City</td>\n",
" <td>Greystone Elem Sch</td>\n",
" <td>307</td>\n",
" <td>256</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>22</td>\n",
" <td>16</td>\n",
" <td>38</td>\n",
" <td>2</td>\n",
" <td>563</td>\n",
" <td>0.006515</td>\n",
" <td>0.000000</td>\n",
" <td>0.003552</td>\n",
" <td>0.067496</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100007</td>\n",
" <td>Hoover City</td>\n",
" <td>Hoover High Sch</td>\n",
" <td>1518</td>\n",
" <td>1449</td>\n",
" <td>44</td>\n",
" <td>26</td>\n",
" <td>214</td>\n",
" <td>91</td>\n",
" <td>305</td>\n",
" <td>70</td>\n",
" <td>2967</td>\n",
" <td>0.028986</td>\n",
" <td>0.017943</td>\n",
" <td>0.023593</td>\n",
" <td>0.102797</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100007</td>\n",
" <td>Hoover City</td>\n",
" <td>Berry Middle Sch</td>\n",
" <td>586</td>\n",
" <td>582</td>\n",
" <td>8</td>\n",
" <td>11</td>\n",
" <td>82</td>\n",
" <td>61</td>\n",
" <td>143</td>\n",
" <td>19</td>\n",
" <td>1168</td>\n",
" <td>0.013652</td>\n",
" <td>0.018900</td>\n",
" <td>0.016267</td>\n",
" <td>0.122432</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100007</td>\n",
" <td>Hoover City</td>\n",
" <td>South Shades Crest Elem Sch</td>\n",
" <td>318</td>\n",
" <td>295</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>43</td>\n",
" <td>22</td>\n",
" <td>65</td>\n",
" <td>4</td>\n",
" <td>613</td>\n",
" <td>0.006289</td>\n",
" <td>0.006780</td>\n",
" <td>0.006525</td>\n",
" <td>0.106036</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100007</td>\n",
" <td>Hoover City</td>\n",
" <td>Robert F Bumpus Middle Sch</td>\n",
" <td>414</td>\n",
" <td>414</td>\n",
" <td>14</td>\n",
" <td>8</td>\n",
" <td>43</td>\n",
" <td>31</td>\n",
" <td>74</td>\n",
" <td>22</td>\n",
" <td>828</td>\n",
" <td>0.033816</td>\n",
" <td>0.019324</td>\n",
" <td>0.026570</td>\n",
" <td>0.089372</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100007</td>\n",
" <td>Hoover City</td>\n",
" <td>Spain Park High Sch</td>\n",
" <td>873</td>\n",
" <td>804</td>\n",
" <td>26</td>\n",
" <td>17</td>\n",
" <td>97</td>\n",
" <td>61</td>\n",
" <td>158</td>\n",
" <td>43</td>\n",
" <td>1677</td>\n",
" <td>0.029782</td>\n",
" <td>0.021144</td>\n",
" <td>0.025641</td>\n",
" <td>0.094216</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100007</td>\n",
" <td>Hoover City</td>\n",
" <td>Deer Valley Elem Sch</td>\n",
" <td>448</td>\n",
" <td>444</td>\n",
" <td>8</td>\n",
" <td>8</td>\n",
" <td>28</td>\n",
" <td>10</td>\n",
" <td>38</td>\n",
" <td>16</td>\n",
" <td>892</td>\n",
" <td>0.017857</td>\n",
" <td>0.018018</td>\n",
" <td>0.017937</td>\n",
" <td>0.042601</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100007</td>\n",
" <td>Hoover City</td>\n",
" <td>Bluff Pk Elem Sch</td>\n",
" <td>336</td>\n",
" <td>319</td>\n",
" <td>5</td>\n",
" <td>5</td>\n",
" <td>43</td>\n",
" <td>25</td>\n",
" <td>68</td>\n",
" <td>10</td>\n",
" <td>655</td>\n",
" <td>0.014881</td>\n",
" <td>0.015674</td>\n",
" <td>0.015267</td>\n",
" <td>0.103817</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>100007</td>\n",
" <td>Hoover City</td>\n",
" <td>Green Valley Elem Sch</td>\n",
" <td>273</td>\n",
" <td>237</td>\n",
" <td>5</td>\n",
" <td>0</td>\n",
" <td>40</td>\n",
" <td>16</td>\n",
" <td>56</td>\n",
" <td>5</td>\n",
" <td>510</td>\n",
" <td>0.018315</td>\n",
" <td>0.000000</td>\n",
" <td>0.009804</td>\n",
" <td>0.109804</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96315</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605695</td>\n",
" <td>Sheridan County School District #2</td>\n",
" <td>Highland Park Elementary</td>\n",
" <td>184</td>\n",
" <td>203</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>25</td>\n",
" <td>13</td>\n",
" <td>38</td>\n",
" <td>2</td>\n",
" <td>387</td>\n",
" <td>0.000000</td>\n",
" <td>0.009852</td>\n",
" <td>0.005168</td>\n",
" <td>0.098191</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96317</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605695</td>\n",
" <td>Sheridan County School District #2</td>\n",
" <td>Woodland Park Elementary</td>\n",
" <td>146</td>\n",
" <td>172</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>28</td>\n",
" <td>10</td>\n",
" <td>38</td>\n",
" <td>2</td>\n",
" <td>318</td>\n",
" <td>0.013699</td>\n",
" <td>0.000000</td>\n",
" <td>0.006289</td>\n",
" <td>0.119497</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96318</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605695</td>\n",
" <td>Sheridan County School District #2</td>\n",
" <td>Sheridan High School</td>\n",
" <td>504</td>\n",
" <td>479</td>\n",
" <td>2</td>\n",
" <td>8</td>\n",
" <td>52</td>\n",
" <td>19</td>\n",
" <td>71</td>\n",
" <td>10</td>\n",
" <td>983</td>\n",
" <td>0.003968</td>\n",
" <td>0.016701</td>\n",
" <td>0.010173</td>\n",
" <td>0.072228</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96319</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605695</td>\n",
" <td>Sheridan County School District #2</td>\n",
" <td>Sheridan Junior High School</td>\n",
" <td>384</td>\n",
" <td>317</td>\n",
" <td>5</td>\n",
" <td>2</td>\n",
" <td>58</td>\n",
" <td>34</td>\n",
" <td>92</td>\n",
" <td>7</td>\n",
" <td>701</td>\n",
" <td>0.013021</td>\n",
" <td>0.006309</td>\n",
" <td>0.009986</td>\n",
" <td>0.131241</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96320</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605695</td>\n",
" <td>Sheridan County School District #2</td>\n",
" <td>Meadowlark Elementary</td>\n",
" <td>165</td>\n",
" <td>180</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>28</td>\n",
" <td>13</td>\n",
" <td>41</td>\n",
" <td>2</td>\n",
" <td>345</td>\n",
" <td>0.000000</td>\n",
" <td>0.011111</td>\n",
" <td>0.005797</td>\n",
" <td>0.118841</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96321</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605695</td>\n",
" <td>Sheridan County School District #2</td>\n",
" <td>Sagebrush Elementary</td>\n",
" <td>179</td>\n",
" <td>165</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>34</td>\n",
" <td>25</td>\n",
" <td>59</td>\n",
" <td>4</td>\n",
" <td>344</td>\n",
" <td>0.011173</td>\n",
" <td>0.012121</td>\n",
" <td>0.011628</td>\n",
" <td>0.171512</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96323</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605700</td>\n",
" <td>Fremont County School District #24</td>\n",
" <td>Shoshoni Elementary</td>\n",
" <td>145</td>\n",
" <td>102</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>25</td>\n",
" <td>7</td>\n",
" <td>32</td>\n",
" <td>0</td>\n",
" <td>247</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.129555</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96324</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605700</td>\n",
" <td>Fremont County School District #24</td>\n",
" <td>Shoshoni Junior High School</td>\n",
" <td>24</td>\n",
" <td>26</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>4</td>\n",
" <td>8</td>\n",
" <td>2</td>\n",
" <td>50</td>\n",
" <td>0.000000</td>\n",
" <td>0.076923</td>\n",
" <td>0.040000</td>\n",
" <td>0.160000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96325</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605762</td>\n",
" <td>Sweetwater County School District #2</td>\n",
" <td>Expedition Academy</td>\n",
" <td>27</td>\n",
" <td>19</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>7</td>\n",
" <td>4</td>\n",
" <td>11</td>\n",
" <td>4</td>\n",
" <td>46</td>\n",
" <td>0.074074</td>\n",
" <td>0.105263</td>\n",
" <td>0.086957</td>\n",
" <td>0.239130</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96326</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605762</td>\n",
" <td>Sweetwater County School District #2</td>\n",
" <td>Monroe Intermediate School</td>\n",
" <td>214</td>\n",
" <td>181</td>\n",
" <td>8</td>\n",
" <td>5</td>\n",
" <td>46</td>\n",
" <td>22</td>\n",
" <td>68</td>\n",
" <td>13</td>\n",
" <td>395</td>\n",
" <td>0.037383</td>\n",
" <td>0.027624</td>\n",
" <td>0.032911</td>\n",
" <td>0.172152</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96327</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605762</td>\n",
" <td>Sweetwater County School District #2</td>\n",
" <td>Green River High School</td>\n",
" <td>411</td>\n",
" <td>366</td>\n",
" <td>14</td>\n",
" <td>11</td>\n",
" <td>70</td>\n",
" <td>37</td>\n",
" <td>107</td>\n",
" <td>25</td>\n",
" <td>777</td>\n",
" <td>0.034063</td>\n",
" <td>0.030055</td>\n",
" <td>0.032175</td>\n",
" <td>0.137709</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96330</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605762</td>\n",
" <td>Sweetwater County School District #2</td>\n",
" <td>Washington Elementary</td>\n",
" <td>120</td>\n",
" <td>102</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>34</td>\n",
" <td>13</td>\n",
" <td>47</td>\n",
" <td>2</td>\n",
" <td>222</td>\n",
" <td>0.016667</td>\n",
" <td>0.000000</td>\n",
" <td>0.009009</td>\n",
" <td>0.211712</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96331</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605762</td>\n",
" <td>Sweetwater County School District #2</td>\n",
" <td>Lincoln Middle School</td>\n",
" <td>203</td>\n",
" <td>230</td>\n",
" <td>8</td>\n",
" <td>5</td>\n",
" <td>46</td>\n",
" <td>28</td>\n",
" <td>74</td>\n",
" <td>13</td>\n",
" <td>433</td>\n",
" <td>0.039409</td>\n",
" <td>0.021739</td>\n",
" <td>0.030023</td>\n",
" <td>0.170901</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96332</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605762</td>\n",
" <td>Sweetwater County School District #2</td>\n",
" <td>Jackson Elementary</td>\n",
" <td>116</td>\n",
" <td>141</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>19</td>\n",
" <td>16</td>\n",
" <td>35</td>\n",
" <td>0</td>\n",
" <td>257</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.136187</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96333</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605762</td>\n",
" <td>Sweetwater County School District #2</td>\n",
" <td>Truman Elementary</td>\n",
" <td>155</td>\n",
" <td>142</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>46</td>\n",
" <td>22</td>\n",
" <td>68</td>\n",
" <td>0</td>\n",
" <td>297</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.228956</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96334</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605762</td>\n",
" <td>Sweetwater County School District #2</td>\n",
" <td>Harrison Elementary</td>\n",
" <td>137</td>\n",
" <td>143</td>\n",
" <td>5</td>\n",
" <td>2</td>\n",
" <td>28</td>\n",
" <td>16</td>\n",
" <td>44</td>\n",
" <td>7</td>\n",
" <td>280</td>\n",
" <td>0.036496</td>\n",
" <td>0.013986</td>\n",
" <td>0.025000</td>\n",
" <td>0.157143</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96336</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605820</td>\n",
" <td>Washakie County School District #2</td>\n",
" <td>Ten Sleep K-12</td>\n",
" <td>60</td>\n",
" <td>50</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>7</td>\n",
" <td>7</td>\n",
" <td>14</td>\n",
" <td>4</td>\n",
" <td>110</td>\n",
" <td>0.033333</td>\n",
" <td>0.040000</td>\n",
" <td>0.036364</td>\n",
" <td>0.127273</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96337</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605830</td>\n",
" <td>Teton County School District #1</td>\n",
" <td>Colter Elementary</td>\n",
" <td>290</td>\n",
" <td>270</td>\n",
" <td>5</td>\n",
" <td>5</td>\n",
" <td>46</td>\n",
" <td>22</td>\n",
" <td>68</td>\n",
" <td>10</td>\n",
" <td>560</td>\n",
" <td>0.017241</td>\n",
" <td>0.018519</td>\n",
" <td>0.017857</td>\n",
" <td>0.121429</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96338</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605830</td>\n",
" <td>Teton County School District #1</td>\n",
" <td>Jackson Elementary</td>\n",
" <td>301</td>\n",
" <td>290</td>\n",
" <td>5</td>\n",
" <td>2</td>\n",
" <td>37</td>\n",
" <td>22</td>\n",
" <td>59</td>\n",
" <td>7</td>\n",
" <td>591</td>\n",
" <td>0.016611</td>\n",
" <td>0.006897</td>\n",
" <td>0.011844</td>\n",
" <td>0.099831</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96339</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605830</td>\n",
" <td>Teton County School District #1</td>\n",
" <td>Jackson Hole High School</td>\n",
" <td>324</td>\n",
" <td>316</td>\n",
" <td>11</td>\n",
" <td>8</td>\n",
" <td>40</td>\n",
" <td>25</td>\n",
" <td>65</td>\n",
" <td>19</td>\n",
" <td>640</td>\n",
" <td>0.033951</td>\n",
" <td>0.025316</td>\n",
" <td>0.029687</td>\n",
" <td>0.101562</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96340</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605830</td>\n",
" <td>Teton County School District #1</td>\n",
" <td>Jackson Hole Middle School</td>\n",
" <td>298</td>\n",
" <td>288</td>\n",
" <td>8</td>\n",
" <td>5</td>\n",
" <td>34</td>\n",
" <td>22</td>\n",
" <td>56</td>\n",
" <td>13</td>\n",
" <td>586</td>\n",
" <td>0.026846</td>\n",
" <td>0.017361</td>\n",
" <td>0.022184</td>\n",
" <td>0.095563</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96344</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605830</td>\n",
" <td>Teton County School District #1</td>\n",
" <td>Wilson Elementary</td>\n",
" <td>110</td>\n",
" <td>125</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>16</td>\n",
" <td>4</td>\n",
" <td>20</td>\n",
" <td>4</td>\n",
" <td>235</td>\n",
" <td>0.018182</td>\n",
" <td>0.016000</td>\n",
" <td>0.017021</td>\n",
" <td>0.085106</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96345</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5605830</td>\n",
" <td>Teton County School District #1</td>\n",
" <td>Summit High School</td>\n",
" <td>36</td>\n",
" <td>18</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>16</td>\n",
" <td>7</td>\n",
" <td>23</td>\n",
" <td>0</td>\n",
" <td>54</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.425926</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96347</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5606090</td>\n",
" <td>Weston County School District #7</td>\n",
" <td>Upton Elementary</td>\n",
" <td>63</td>\n",
" <td>66</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>13</td>\n",
" <td>10</td>\n",
" <td>23</td>\n",
" <td>0</td>\n",
" <td>129</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.178295</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96348</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5606090</td>\n",
" <td>Weston County School District #7</td>\n",
" <td>Upton High School</td>\n",
" <td>49</td>\n",
" <td>51</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>7</td>\n",
" <td>14</td>\n",
" <td>0</td>\n",
" <td>100</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.140000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96349</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5606240</td>\n",
" <td>Washakie County School District #1</td>\n",
" <td>Worland High School</td>\n",
" <td>203</td>\n",
" <td>197</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>37</td>\n",
" <td>16</td>\n",
" <td>53</td>\n",
" <td>4</td>\n",
" <td>400</td>\n",
" <td>0.009852</td>\n",
" <td>0.010152</td>\n",
" <td>0.010000</td>\n",
" <td>0.132500</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96350</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5606240</td>\n",
" <td>Washakie County School District #1</td>\n",
" <td>Worland Middle School</td>\n",
" <td>171</td>\n",
" <td>159</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>10</td>\n",
" <td>4</td>\n",
" <td>14</td>\n",
" <td>2</td>\n",
" <td>330</td>\n",
" <td>0.011696</td>\n",
" <td>0.000000</td>\n",
" <td>0.006061</td>\n",
" <td>0.042424</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96354</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5680180</td>\n",
" <td>Northeast Wyoming BOCES</td>\n",
" <td>Powder River Basin Children's Center</td>\n",
" <td>28</td>\n",
" <td>13</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>25</td>\n",
" <td>13</td>\n",
" <td>38</td>\n",
" <td>0</td>\n",
" <td>41</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.926829</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96355</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5680250</td>\n",
" <td>Region V BOCES</td>\n",
" <td>C-Bar-V Ranch</td>\n",
" <td>41</td>\n",
" <td>9</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>40</td>\n",
" <td>7</td>\n",
" <td>47</td>\n",
" <td>0</td>\n",
" <td>50</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.940000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96359</th>\n",
" <td>WY</td>\n",
" <td>WYOMING</td>\n",
" <td>5680254</td>\n",
" <td>Saint Stephen's Indian School Admin Office</td>\n",
" <td>Saint Stephen's Indian School</td>\n",
" <td>110</td>\n",
" <td>107</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>16</td>\n",
" <td>16</td>\n",
" <td>32</td>\n",
" <td>0</td>\n",
" <td>217</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.147465</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>86163 rows × 18 columns</p>\n",
"</div>"
],
"text/plain": [
" LEA_STATE LEA_STATE_NAME LEAID \\\n",
"4 AL ALABAMA 100005 \n",
"5 AL ALABAMA 100005 \n",
"6 AL ALABAMA 100005 \n",
"7 AL ALABAMA 100005 \n",
"8 AL ALABAMA 100005 \n",
"9 AL ALABAMA 100005 \n",
"10 AL ALABAMA 100006 \n",
"11 AL ALABAMA 100006 \n",
"12 AL ALABAMA 100006 \n",
"13 AL ALABAMA 100006 \n",
"14 AL ALABAMA 100006 \n",
"15 AL ALABAMA 100006 \n",
"16 AL ALABAMA 100006 \n",
"17 AL ALABAMA 100006 \n",
"18 AL ALABAMA 100006 \n",
"19 AL ALABAMA 100006 \n",
"20 AL ALABAMA 100006 \n",
"21 AL ALABAMA 100006 \n",
"22 AL ALABAMA 100006 \n",
"23 AL ALABAMA 100006 \n",
"24 AL ALABAMA 100007 \n",
"25 AL ALABAMA 100007 \n",
"26 AL ALABAMA 100007 \n",
"27 AL ALABAMA 100007 \n",
"28 AL ALABAMA 100007 \n",
"29 AL ALABAMA 100007 \n",
"30 AL ALABAMA 100007 \n",
"31 AL ALABAMA 100007 \n",
"32 AL ALABAMA 100007 \n",
"33 AL ALABAMA 100007 \n",
"... ... ... ... \n",
"96315 WY WYOMING 5605695 \n",
"96317 WY WYOMING 5605695 \n",
"96318 WY WYOMING 5605695 \n",
"96319 WY WYOMING 5605695 \n",
"96320 WY WYOMING 5605695 \n",
"96321 WY WYOMING 5605695 \n",
"96323 WY WYOMING 5605700 \n",
"96324 WY WYOMING 5605700 \n",
"96325 WY WYOMING 5605762 \n",
"96326 WY WYOMING 5605762 \n",
"96327 WY WYOMING 5605762 \n",
"96330 WY WYOMING 5605762 \n",
"96331 WY WYOMING 5605762 \n",
"96332 WY WYOMING 5605762 \n",
"96333 WY WYOMING 5605762 \n",
"96334 WY WYOMING 5605762 \n",
"96336 WY WYOMING 5605820 \n",
"96337 WY WYOMING 5605830 \n",
"96338 WY WYOMING 5605830 \n",
"96339 WY WYOMING 5605830 \n",
"96340 WY WYOMING 5605830 \n",
"96344 WY WYOMING 5605830 \n",
"96345 WY WYOMING 5605830 \n",
"96347 WY WYOMING 5606090 \n",
"96348 WY WYOMING 5606090 \n",
"96349 WY WYOMING 5606240 \n",
"96350 WY WYOMING 5606240 \n",
"96354 WY WYOMING 5680180 \n",
"96355 WY WYOMING 5680250 \n",
"96359 WY WYOMING 5680254 \n",
"\n",
" LEA_NAME \\\n",
"4 Albertville City \n",
"5 Albertville City \n",
"6 Albertville City \n",
"7 Albertville City \n",
"8 Albertville City \n",
"9 Albertville City \n",
"10 Marshall County \n",
"11 Marshall County \n",
"12 Marshall County \n",
"13 Marshall County \n",
"14 Marshall County \n",
"15 Marshall County \n",
"16 Marshall County \n",
"17 Marshall County \n",
"18 Marshall County \n",
"19 Marshall County \n",
"20 Marshall County \n",
"21 Marshall County \n",
"22 Marshall County \n",
"23 Marshall County \n",
"24 Hoover City \n",
"25 Hoover City \n",
"26 Hoover City \n",
"27 Hoover City \n",
"28 Hoover City \n",
"29 Hoover City \n",
"30 Hoover City \n",
"31 Hoover City \n",
"32 Hoover City \n",
"33 Hoover City \n",
"... ... \n",
"96315 Sheridan County School District #2 \n",
"96317 Sheridan County School District #2 \n",
"96318 Sheridan County School District #2 \n",
"96319 Sheridan County School District #2 \n",
"96320 Sheridan County School District #2 \n",
"96321 Sheridan County School District #2 \n",
"96323 Fremont County School District #24 \n",
"96324 Fremont County School District #24 \n",
"96325 Sweetwater County School District #2 \n",
"96326 Sweetwater County School District #2 \n",
"96327 Sweetwater County School District #2 \n",
"96330 Sweetwater County School District #2 \n",
"96331 Sweetwater County School District #2 \n",
"96332 Sweetwater County School District #2 \n",
"96333 Sweetwater County School District #2 \n",
"96334 Sweetwater County School District #2 \n",
"96336 Washakie County School District #2 \n",
"96337 Teton County School District #1 \n",
"96338 Teton County School District #1 \n",
"96339 Teton County School District #1 \n",
"96340 Teton County School District #1 \n",
"96344 Teton County School District #1 \n",
"96345 Teton County School District #1 \n",
"96347 Weston County School District #7 \n",
"96348 Weston County School District #7 \n",
"96349 Washakie County School District #1 \n",
"96350 Washakie County School District #1 \n",
"96354 Northeast Wyoming BOCES \n",
"96355 Region V BOCES \n",
"96359 Saint Stephen's Indian School Admin Office \n",
"\n",
" SCH_NAME male enrollment \\\n",
"4 Albertville Middle School 358 \n",
"5 Albertville High Sch 645 \n",
"6 Evans Elem Sch 381 \n",
"7 Albertville Elem Sch 430 \n",
"8 Big Spring Lake Kinderg Sch 264 \n",
"9 Albertville Primary Sch 555 \n",
"10 Kate Duncan Smith DAR Middle 235 \n",
"11 Asbury Sch 289 \n",
"12 Claysville Jr High Sch 64 \n",
"13 Douglas Elem Sch 261 \n",
"14 Douglas High Sch 310 \n",
"15 Brindlee Mountain Elementary School 131 \n",
"16 Kate D Smith DAR High Sch 236 \n",
"17 Brindlee Mountain Primary School 128 \n",
"18 Robert D Sloman Primary 258 \n",
"19 Brindlee Mt Middle Sch 130 \n",
"20 Brindlee Mt High Sch 187 \n",
"21 Kate D Smith DAR Elem Sch 215 \n",
"22 Douglas Middle Sch 250 \n",
"23 Asbury Elem Sch 237 \n",
"24 Trace Crossings Elem Sch 334 \n",
"25 Greystone Elem Sch 307 \n",
"26 Hoover High Sch 1518 \n",
"27 Berry Middle Sch 586 \n",
"28 South Shades Crest Elem Sch 318 \n",
"29 Robert F Bumpus Middle Sch 414 \n",
"30 Spain Park High Sch 873 \n",
"31 Deer Valley Elem Sch 448 \n",
"32 Bluff Pk Elem Sch 336 \n",
"33 Green Valley Elem Sch 273 \n",
"... ... ... \n",
"96315 Highland Park Elementary 184 \n",
"96317 Woodland Park Elementary 146 \n",
"96318 Sheridan High School 504 \n",
"96319 Sheridan Junior High School 384 \n",
"96320 Meadowlark Elementary 165 \n",
"96321 Sagebrush Elementary 179 \n",
"96323 Shoshoni Elementary 145 \n",
"96324 Shoshoni Junior High School 24 \n",
"96325 Expedition Academy 27 \n",
"96326 Monroe Intermediate School 214 \n",
"96327 Green River High School 411 \n",
"96330 Washington Elementary 120 \n",
"96331 Lincoln Middle School 203 \n",
"96332 Jackson Elementary 116 \n",
"96333 Truman Elementary 155 \n",
"96334 Harrison Elementary 137 \n",
"96336 Ten Sleep K-12 60 \n",
"96337 Colter Elementary 290 \n",
"96338 Jackson Elementary 301 \n",
"96339 Jackson Hole High School 324 \n",
"96340 Jackson Hole Middle School 298 \n",
"96344 Wilson Elementary 110 \n",
"96345 Summit High School 36 \n",
"96347 Upton Elementary 63 \n",
"96348 Upton High School 49 \n",
"96349 Worland High School 203 \n",
"96350 Worland Middle School 171 \n",
"96354 Powder River Basin Children's Center 28 \n",
"96355 C-Bar-V Ranch 41 \n",
"96359 Saint Stephen's Indian School 110 \n",
"\n",
" female enrollment male 504 female 504 male idea female idea \\\n",
"4 346 2 5 28 16 \n",
"5 650 5 8 43 28 \n",
"6 389 2 2 31 25 \n",
"7 417 5 0 31 13 \n",
"8 234 0 0 52 13 \n",
"9 534 2 2 70 34 \n",
"10 210 5 5 43 16 \n",
"11 250 2 2 49 13 \n",
"12 65 2 2 25 13 \n",
"13 240 2 0 34 22 \n",
"14 284 8 2 28 16 \n",
"15 123 5 2 34 19 \n",
"16 223 2 2 16 10 \n",
"17 102 2 2 19 16 \n",
"18 238 0 0 37 25 \n",
"19 129 2 0 19 19 \n",
"20 176 2 2 28 13 \n",
"21 223 2 2 37 19 \n",
"22 218 0 0 37 22 \n",
"23 259 0 2 40 22 \n",
"24 238 2 2 70 28 \n",
"25 256 2 0 22 16 \n",
"26 1449 44 26 214 91 \n",
"27 582 8 11 82 61 \n",
"28 295 2 2 43 22 \n",
"29 414 14 8 43 31 \n",
"30 804 26 17 97 61 \n",
"31 444 8 8 28 10 \n",
"32 319 5 5 43 25 \n",
"33 237 5 0 40 16 \n",
"... ... ... ... ... ... \n",
"96315 203 0 2 25 13 \n",
"96317 172 2 0 28 10 \n",
"96318 479 2 8 52 19 \n",
"96319 317 5 2 58 34 \n",
"96320 180 0 2 28 13 \n",
"96321 165 2 2 34 25 \n",
"96323 102 0 0 25 7 \n",
"96324 26 0 2 4 4 \n",
"96325 19 2 2 7 4 \n",
"96326 181 8 5 46 22 \n",
"96327 366 14 11 70 37 \n",
"96330 102 2 0 34 13 \n",
"96331 230 8 5 46 28 \n",
"96332 141 0 0 19 16 \n",
"96333 142 0 0 46 22 \n",
"96334 143 5 2 28 16 \n",
"96336 50 2 2 7 7 \n",
"96337 270 5 5 46 22 \n",
"96338 290 5 2 37 22 \n",
"96339 316 11 8 40 25 \n",
"96340 288 8 5 34 22 \n",
"96344 125 2 2 16 4 \n",
"96345 18 0 0 16 7 \n",
"96347 66 0 0 13 10 \n",
"96348 51 0 0 7 7 \n",
"96349 197 2 2 37 16 \n",
"96350 159 2 0 10 4 \n",
"96354 13 0 0 25 13 \n",
"96355 9 0 0 40 7 \n",
"96359 107 0 0 16 16 \n",
"\n",
" total idea total 504 total enrollment male 504 rate \\\n",
"4 44 7 704 0.005587 \n",
"5 71 13 1295 0.007752 \n",
"6 56 4 770 0.005249 \n",
"7 44 5 847 0.011628 \n",
"8 65 0 498 0.000000 \n",
"9 104 4 1089 0.003604 \n",
"10 59 10 445 0.021277 \n",
"11 62 4 539 0.006920 \n",
"12 38 4 129 0.031250 \n",
"13 56 2 501 0.007663 \n",
"14 44 10 594 0.025806 \n",
"15 53 7 254 0.038168 \n",
"16 26 4 459 0.008475 \n",
"17 35 4 230 0.015625 \n",
"18 62 0 496 0.000000 \n",
"19 38 2 259 0.015385 \n",
"20 41 4 363 0.010695 \n",
"21 56 4 438 0.009302 \n",
"22 59 0 468 0.000000 \n",
"23 62 2 496 0.000000 \n",
"24 98 4 572 0.005988 \n",
"25 38 2 563 0.006515 \n",
"26 305 70 2967 0.028986 \n",
"27 143 19 1168 0.013652 \n",
"28 65 4 613 0.006289 \n",
"29 74 22 828 0.033816 \n",
"30 158 43 1677 0.029782 \n",
"31 38 16 892 0.017857 \n",
"32 68 10 655 0.014881 \n",
"33 56 5 510 0.018315 \n",
"... ... ... ... ... \n",
"96315 38 2 387 0.000000 \n",
"96317 38 2 318 0.013699 \n",
"96318 71 10 983 0.003968 \n",
"96319 92 7 701 0.013021 \n",
"96320 41 2 345 0.000000 \n",
"96321 59 4 344 0.011173 \n",
"96323 32 0 247 0.000000 \n",
"96324 8 2 50 0.000000 \n",
"96325 11 4 46 0.074074 \n",
"96326 68 13 395 0.037383 \n",
"96327 107 25 777 0.034063 \n",
"96330 47 2 222 0.016667 \n",
"96331 74 13 433 0.039409 \n",
"96332 35 0 257 0.000000 \n",
"96333 68 0 297 0.000000 \n",
"96334 44 7 280 0.036496 \n",
"96336 14 4 110 0.033333 \n",
"96337 68 10 560 0.017241 \n",
"96338 59 7 591 0.016611 \n",
"96339 65 19 640 0.033951 \n",
"96340 56 13 586 0.026846 \n",
"96344 20 4 235 0.018182 \n",
"96345 23 0 54 0.000000 \n",
"96347 23 0 129 0.000000 \n",
"96348 14 0 100 0.000000 \n",
"96349 53 4 400 0.009852 \n",
"96350 14 2 330 0.011696 \n",
"96354 38 0 41 0.000000 \n",
"96355 47 0 50 0.000000 \n",
"96359 32 0 217 0.000000 \n",
"\n",
" female 504 rate 504 rate idea rate \n",
"4 0.014451 0.009943 0.062500 \n",
"5 0.012308 0.010039 0.054826 \n",
"6 0.005141 0.005195 0.072727 \n",
"7 0.000000 0.005903 0.051948 \n",
"8 0.000000 0.000000 0.130522 \n",
"9 0.003745 0.003673 0.095500 \n",
"10 0.023810 0.022472 0.132584 \n",
"11 0.008000 0.007421 0.115028 \n",
"12 0.030769 0.031008 0.294574 \n",
"13 0.000000 0.003992 0.111776 \n",
"14 0.007042 0.016835 0.074074 \n",
"15 0.016260 0.027559 0.208661 \n",
"16 0.008969 0.008715 0.056645 \n",
"17 0.019608 0.017391 0.152174 \n",
"18 0.000000 0.000000 0.125000 \n",
"19 0.000000 0.007722 0.146718 \n",
"20 0.011364 0.011019 0.112948 \n",
"21 0.008969 0.009132 0.127854 \n",
"22 0.000000 0.000000 0.126068 \n",
"23 0.007722 0.004032 0.125000 \n",
"24 0.008403 0.006993 0.171329 \n",
"25 0.000000 0.003552 0.067496 \n",
"26 0.017943 0.023593 0.102797 \n",
"27 0.018900 0.016267 0.122432 \n",
"28 0.006780 0.006525 0.106036 \n",
"29 0.019324 0.026570 0.089372 \n",
"30 0.021144 0.025641 0.094216 \n",
"31 0.018018 0.017937 0.042601 \n",
"32 0.015674 0.015267 0.103817 \n",
"33 0.000000 0.009804 0.109804 \n",
"... ... ... ... \n",
"96315 0.009852 0.005168 0.098191 \n",
"96317 0.000000 0.006289 0.119497 \n",
"96318 0.016701 0.010173 0.072228 \n",
"96319 0.006309 0.009986 0.131241 \n",
"96320 0.011111 0.005797 0.118841 \n",
"96321 0.012121 0.011628 0.171512 \n",
"96323 0.000000 0.000000 0.129555 \n",
"96324 0.076923 0.040000 0.160000 \n",
"96325 0.105263 0.086957 0.239130 \n",
"96326 0.027624 0.032911 0.172152 \n",
"96327 0.030055 0.032175 0.137709 \n",
"96330 0.000000 0.009009 0.211712 \n",
"96331 0.021739 0.030023 0.170901 \n",
"96332 0.000000 0.000000 0.136187 \n",
"96333 0.000000 0.000000 0.228956 \n",
"96334 0.013986 0.025000 0.157143 \n",
"96336 0.040000 0.036364 0.127273 \n",
"96337 0.018519 0.017857 0.121429 \n",
"96338 0.006897 0.011844 0.099831 \n",
"96339 0.025316 0.029687 0.101562 \n",
"96340 0.017361 0.022184 0.095563 \n",
"96344 0.016000 0.017021 0.085106 \n",
"96345 0.000000 0.000000 0.425926 \n",
"96347 0.000000 0.000000 0.178295 \n",
"96348 0.000000 0.000000 0.140000 \n",
"96349 0.010152 0.010000 0.132500 \n",
"96350 0.000000 0.006061 0.042424 \n",
"96354 0.000000 0.000000 0.926829 \n",
"96355 0.000000 0.000000 0.940000 \n",
"96359 0.000000 0.000000 0.147465 \n",
"\n",
"[86163 rows x 18 columns]"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"disability"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [],
"source": [
"disability.to_csv('2016extratime.csv', index=False)"
]
},
{
"cell_type": "code",
"execution_count": 56,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>LEA_STATE</th>\n",
" <th>LEA_STATE_NAME</th>\n",
" <th>LEA_NAME</th>\n",
" <th>SCH_NAME</th>\n",
" <th>male enrollment</th>\n",
" <th>female enrollment</th>\n",
" <th>male 504</th>\n",
" <th>female 504</th>\n",
" <th>male idea</th>\n",
" <th>female idea</th>\n",
" <th>total idea</th>\n",
" <th>total 504</th>\n",
" <th>total enrollment</th>\n",
" <th>male 504 rate</th>\n",
" <th>female 504 rate</th>\n",
" <th>504 rate</th>\n",
" <th>idea rate</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>1291</th>\n",
" <td>AL</td>\n",
" <td>ALABAMA</td>\n",
" <td>Tuscaloosa City</td>\n",
" <td>Arcadia Elem Sch</td>\n",
" <td>169</td>\n",
" <td>161</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>28</td>\n",
" <td>13</td>\n",
" <td>41</td>\n",
" <td>2</td>\n",
" <td>330</td>\n",
" <td>0.000000</td>\n",
" <td>0.012422</td>\n",
" <td>0.006061</td>\n",
" <td>0.124242</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3491</th>\n",
" <td>AZ</td>\n",
" <td>ARIZONA</td>\n",
" <td>Scottsdale Unified District</td>\n",
" <td>Arcadia High School</td>\n",
" <td>878</td>\n",
" <td>875</td>\n",
" <td>59</td>\n",
" <td>38</td>\n",
" <td>73</td>\n",
" <td>43</td>\n",
" <td>116</td>\n",
" <td>97</td>\n",
" <td>1753</td>\n",
" <td>0.067198</td>\n",
" <td>0.043429</td>\n",
" <td>0.055334</td>\n",
" <td>0.066172</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3515</th>\n",
" <td>AZ</td>\n",
" <td>ARIZONA</td>\n",
" <td>Scottsdale Unified District</td>\n",
" <td>Arcadia Learning Center (ANLC)</td>\n",
" <td>257</td>\n",
" <td>236</td>\n",
" <td>17</td>\n",
" <td>8</td>\n",
" <td>31</td>\n",
" <td>25</td>\n",
" <td>56</td>\n",
" <td>25</td>\n",
" <td>493</td>\n",
" <td>0.066148</td>\n",
" <td>0.033898</td>\n",
" <td>0.050710</td>\n",
" <td>0.113590</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5928</th>\n",
" <td>CA</td>\n",
" <td>CALIFORNIA</td>\n",
" <td>Arcadia Unified</td>\n",
" <td>Arcadia High</td>\n",
" <td>1724</td>\n",
" <td>1700</td>\n",
" <td>53</td>\n",
" <td>41</td>\n",
" <td>118</td>\n",
" <td>73</td>\n",
" <td>191</td>\n",
" <td>94</td>\n",
" <td>3424</td>\n",
" <td>0.030742</td>\n",
" <td>0.024118</td>\n",
" <td>0.027453</td>\n",
" <td>0.055783</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28703</th>\n",
" <td>IL</td>\n",
" <td>ILLINOIS</td>\n",
" <td>Matteson ESD 162</td>\n",
" <td>Arcadia Elem School</td>\n",
" <td>230</td>\n",
" <td>224</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>40</td>\n",
" <td>10</td>\n",
" <td>50</td>\n",
" <td>4</td>\n",
" <td>454</td>\n",
" <td>0.008696</td>\n",
" <td>0.008929</td>\n",
" <td>0.008811</td>\n",
" <td>0.110132</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36299</th>\n",
" <td>LA</td>\n",
" <td>LOUISIANA</td>\n",
" <td>Bienville Parish</td>\n",
" <td>Arcadia High School</td>\n",
" <td>156</td>\n",
" <td>138</td>\n",
" <td>11</td>\n",
" <td>5</td>\n",
" <td>19</td>\n",
" <td>4</td>\n",
" <td>23</td>\n",
" <td>16</td>\n",
" <td>294</td>\n",
" <td>0.070513</td>\n",
" <td>0.036232</td>\n",
" <td>0.054422</td>\n",
" <td>0.078231</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43338</th>\n",
" <td>MI</td>\n",
" <td>MICHIGAN</td>\n",
" <td>Kalamazoo Public Schools</td>\n",
" <td>Arcadia Elementary School</td>\n",
" <td>208</td>\n",
" <td>199</td>\n",
" <td>8</td>\n",
" <td>5</td>\n",
" <td>28</td>\n",
" <td>16</td>\n",
" <td>44</td>\n",
" <td>13</td>\n",
" <td>407</td>\n",
" <td>0.038462</td>\n",
" <td>0.025126</td>\n",
" <td>0.031941</td>\n",
" <td>0.108108</td>\n",
" </tr>\n",
" <tr>\n",
" <th>62351</th>\n",
" <td>NC</td>\n",
" <td>NORTH CAROLINA</td>\n",
" <td>Bladen County Schools</td>\n",
" <td>East Arcadia Elementary</td>\n",
" <td>58</td>\n",
" <td>70</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>13</td>\n",
" <td>7</td>\n",
" <td>20</td>\n",
" <td>2</td>\n",
" <td>128</td>\n",
" <td>0.000000</td>\n",
" <td>0.028571</td>\n",
" <td>0.015625</td>\n",
" <td>0.156250</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68525</th>\n",
" <td>OH</td>\n",
" <td>OHIO</td>\n",
" <td>Arcadia Local</td>\n",
" <td>Arcadia Elementary School</td>\n",
" <td>155</td>\n",
" <td>153</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>22</td>\n",
" <td>10</td>\n",
" <td>32</td>\n",
" <td>4</td>\n",
" <td>308</td>\n",
" <td>0.012903</td>\n",
" <td>0.013072</td>\n",
" <td>0.012987</td>\n",
" <td>0.103896</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68526</th>\n",
" <td>OH</td>\n",
" <td>OHIO</td>\n",
" <td>Arcadia Local</td>\n",
" <td>Arcadia High School</td>\n",
" <td>90</td>\n",
" <td>110</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>10</td>\n",
" <td>4</td>\n",
" <td>14</td>\n",
" <td>4</td>\n",
" <td>200</td>\n",
" <td>0.022222</td>\n",
" <td>0.018182</td>\n",
" <td>0.020000</td>\n",
" <td>0.070000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>76153</th>\n",
" <td>SC</td>\n",
" <td>SOUTH CAROLINA</td>\n",
" <td>Spartanburg 06</td>\n",
" <td>Arcadia Elementary</td>\n",
" <td>204</td>\n",
" <td>237</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>25</td>\n",
" <td>28</td>\n",
" <td>53</td>\n",
" <td>4</td>\n",
" <td>441</td>\n",
" <td>0.009804</td>\n",
" <td>0.008439</td>\n",
" <td>0.009070</td>\n",
" <td>0.120181</td>\n",
" </tr>\n",
" <tr>\n",
" <th>91218</th>\n",
" <td>WA</td>\n",
" <td>WASHINGTON</td>\n",
" <td>Deer Park School District</td>\n",
" <td>Arcadia Elementary</td>\n",
" <td>242</td>\n",
" <td>212</td>\n",
" <td>14</td>\n",
" <td>5</td>\n",
" <td>31</td>\n",
" <td>22</td>\n",
" <td>53</td>\n",
" <td>19</td>\n",
" <td>454</td>\n",
" <td>0.057851</td>\n",
" <td>0.023585</td>\n",
" <td>0.041850</td>\n",
" <td>0.116740</td>\n",
" </tr>\n",
" <tr>\n",
" <th>93903</th>\n",
" <td>WI</td>\n",
" <td>WISCONSIN</td>\n",
" <td>Arcadia School District</td>\n",
" <td>Arcadia El</td>\n",
" <td>469</td>\n",
" <td>415</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>52</td>\n",
" <td>40</td>\n",
" <td>92</td>\n",
" <td>0</td>\n",
" <td>884</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.104072</td>\n",
" </tr>\n",
" <tr>\n",
" <th>93904</th>\n",
" <td>WI</td>\n",
" <td>WISCONSIN</td>\n",
" <td>Arcadia School District</td>\n",
" <td>Arcadia High</td>\n",
" <td>195</td>\n",
" <td>155</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>22</td>\n",
" <td>13</td>\n",
" <td>35</td>\n",
" <td>4</td>\n",
" <td>350</td>\n",
" <td>0.010256</td>\n",
" <td>0.012903</td>\n",
" <td>0.011429</td>\n",
" <td>0.100000</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" LEA_STATE LEA_STATE_NAME LEA_NAME \\\n",
"1291 AL ALABAMA Tuscaloosa City \n",
"3491 AZ ARIZONA Scottsdale Unified District \n",
"3515 AZ ARIZONA Scottsdale Unified District \n",
"5928 CA CALIFORNIA Arcadia Unified \n",
"28703 IL ILLINOIS Matteson ESD 162 \n",
"36299 LA LOUISIANA Bienville Parish \n",
"43338 MI MICHIGAN Kalamazoo Public Schools \n",
"62351 NC NORTH CAROLINA Bladen County Schools \n",
"68525 OH OHIO Arcadia Local \n",
"68526 OH OHIO Arcadia Local \n",
"76153 SC SOUTH CAROLINA Spartanburg 06 \n",
"91218 WA WASHINGTON Deer Park School District \n",
"93903 WI WISCONSIN Arcadia School District \n",
"93904 WI WISCONSIN Arcadia School District \n",
"\n",
" SCH_NAME male enrollment female enrollment \\\n",
"1291 Arcadia Elem Sch 169 161 \n",
"3491 Arcadia High School 878 875 \n",
"3515 Arcadia Learning Center (ANLC) 257 236 \n",
"5928 Arcadia High 1724 1700 \n",
"28703 Arcadia Elem School 230 224 \n",
"36299 Arcadia High School 156 138 \n",
"43338 Arcadia Elementary School 208 199 \n",
"62351 East Arcadia Elementary 58 70 \n",
"68525 Arcadia Elementary School 155 153 \n",
"68526 Arcadia High School 90 110 \n",
"76153 Arcadia Elementary 204 237 \n",
"91218 Arcadia Elementary 242 212 \n",
"93903 Arcadia El 469 415 \n",
"93904 Arcadia High 195 155 \n",
"\n",
" male 504 female 504 male idea female idea total idea total 504 \\\n",
"1291 0 2 28 13 41 2 \n",
"3491 59 38 73 43 116 97 \n",
"3515 17 8 31 25 56 25 \n",
"5928 53 41 118 73 191 94 \n",
"28703 2 2 40 10 50 4 \n",
"36299 11 5 19 4 23 16 \n",
"43338 8 5 28 16 44 13 \n",
"62351 0 2 13 7 20 2 \n",
"68525 2 2 22 10 32 4 \n",
"68526 2 2 10 4 14 4 \n",
"76153 2 2 25 28 53 4 \n",
"91218 14 5 31 22 53 19 \n",
"93903 0 0 52 40 92 0 \n",
"93904 2 2 22 13 35 4 \n",
"\n",
" total enrollment male 504 rate female 504 rate 504 rate idea rate \n",
"1291 330 0.000000 0.012422 0.006061 0.124242 \n",
"3491 1753 0.067198 0.043429 0.055334 0.066172 \n",
"3515 493 0.066148 0.033898 0.050710 0.113590 \n",
"5928 3424 0.030742 0.024118 0.027453 0.055783 \n",
"28703 454 0.008696 0.008929 0.008811 0.110132 \n",
"36299 294 0.070513 0.036232 0.054422 0.078231 \n",
"43338 407 0.038462 0.025126 0.031941 0.108108 \n",
"62351 128 0.000000 0.028571 0.015625 0.156250 \n",
"68525 308 0.012903 0.013072 0.012987 0.103896 \n",
"68526 200 0.022222 0.018182 0.020000 0.070000 \n",
"76153 441 0.009804 0.008439 0.009070 0.120181 \n",
"91218 454 0.057851 0.023585 0.041850 0.116740 \n",
"93903 884 0.000000 0.000000 0.000000 0.104072 \n",
"93904 350 0.010256 0.012903 0.011429 0.100000 "
]
},
"execution_count": 56,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"disability.loc[disability['SCH_NAME'].str.contains(\"Arcadia\")]"
]
},
{
"cell_type": "code",
"execution_count": 40,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>male 504</th>\n",
" <th>female 504</th>\n",
" <th>male enrollment</th>\n",
" <th>female enrollment</th>\n",
" <th>total 504</th>\n",
" <th>total enrollment</th>\n",
" <th>male 504 rate</th>\n",
" <th>female 504 rate</th>\n",
" <th>504 rate</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>count</th>\n",
" <td>86163.000000</td>\n",
" <td>86163.000000</td>\n",
" <td>86163.000000</td>\n",
" <td>86163.000000</td>\n",
" <td>86163.000000</td>\n",
" <td>86163.000000</td>\n",
" <td>86163.000000</td>\n",
" <td>86163.000000</td>\n",
" <td>86163.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>mean</th>\n",
" <td>7.985818</td>\n",
" <td>5.173926</td>\n",
" <td>48.588350</td>\n",
" <td>24.634797</td>\n",
" <td>13.159744</td>\n",
" <td>73.223147</td>\n",
" <td>0.186633</td>\n",
" <td>0.237364</td>\n",
" <td>0.197416</td>\n",
" </tr>\n",
" <tr>\n",
" <th>std</th>\n",
" <td>13.028095</td>\n",
" <td>9.347158</td>\n",
" <td>40.567538</td>\n",
" <td>22.147586</td>\n",
" <td>21.932711</td>\n",
" <td>61.566930</td>\n",
" <td>0.305729</td>\n",
" <td>0.398213</td>\n",
" <td>0.300214</td>\n",
" </tr>\n",
" <tr>\n",
" <th>min</th>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>4.000000</td>\n",
" <td>4.000000</td>\n",
" <td>0.000000</td>\n",
" <td>8.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25%</th>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>25.000000</td>\n",
" <td>13.000000</td>\n",
" <td>2.000000</td>\n",
" <td>38.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.024096</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50%</th>\n",
" <td>2.000000</td>\n",
" <td>2.000000</td>\n",
" <td>40.000000</td>\n",
" <td>19.000000</td>\n",
" <td>5.000000</td>\n",
" <td>59.000000</td>\n",
" <td>0.090909</td>\n",
" <td>0.105263</td>\n",
" <td>0.100000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>75%</th>\n",
" <td>11.000000</td>\n",
" <td>5.000000</td>\n",
" <td>61.000000</td>\n",
" <td>31.000000</td>\n",
" <td>16.000000</td>\n",
" <td>92.000000</td>\n",
" <td>0.238532</td>\n",
" <td>0.285714</td>\n",
" <td>0.250000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>max</th>\n",
" <td>245.000000</td>\n",
" <td>203.000000</td>\n",
" <td>2125.000000</td>\n",
" <td>1183.000000</td>\n",
" <td>424.000000</td>\n",
" <td>3227.000000</td>\n",
" <td>22.250000</td>\n",
" <td>13.250000</td>\n",
" <td>14.750000</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" male 504 female 504 male enrollment female enrollment \\\n",
"count 86163.000000 86163.000000 86163.000000 86163.000000 \n",
"mean 7.985818 5.173926 48.588350 24.634797 \n",
"std 13.028095 9.347158 40.567538 22.147586 \n",
"min 0.000000 0.000000 4.000000 4.000000 \n",
"25% 0.000000 0.000000 25.000000 13.000000 \n",
"50% 2.000000 2.000000 40.000000 19.000000 \n",
"75% 11.000000 5.000000 61.000000 31.000000 \n",
"max 245.000000 203.000000 2125.000000 1183.000000 \n",
"\n",
" total 504 total enrollment male 504 rate female 504 rate \\\n",
"count 86163.000000 86163.000000 86163.000000 86163.000000 \n",
"mean 13.159744 73.223147 0.186633 0.237364 \n",
"std 21.932711 61.566930 0.305729 0.398213 \n",
"min 0.000000 8.000000 0.000000 0.000000 \n",
"25% 2.000000 38.000000 0.000000 0.000000 \n",
"50% 5.000000 59.000000 0.090909 0.105263 \n",
"75% 16.000000 92.000000 0.238532 0.285714 \n",
"max 424.000000 3227.000000 22.250000 13.250000 \n",
"\n",
" 504 rate \n",
"count 86163.000000 \n",
"mean 0.197416 \n",
"std 0.300214 \n",
"min 0.000000 \n",
"25% 0.024096 \n",
"50% 0.100000 \n",
"75% 0.250000 \n",
"max 14.750000 "
]
},
"execution_count": 40,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"disability.describe()"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.7.2"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment