create_enrollment_el_dataset.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>#</th>\n",
       "      <th>School Name</th>\n",
       "      <th>Auth (14)</th>\n",
       "      <th>Program (16)</th>\n",
       "      <th>Charter (14)</th>\n",
       "      <th>Facility (4)</th>\n",
       "      <th>School Code</th>\n",
       "      <th>School Type</th>\n",
       "      <th>Note</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>18</td>\n",
       "      <td>Greenwood Academy</td>\n",
       "      <td>WCCUSD</td>\n",
       "      <td>Non-ILCoP</td>\n",
       "      <td>WCCUSD School</td>\n",
       "      <td>No</td>\n",
       "      <td>0733253</td>\n",
       "      <td>Alternative</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>63</td>\n",
       "      <td>Vista Independent Study/Virtual Academy</td>\n",
       "      <td>WCCUSD</td>\n",
       "      <td>Non-ILCoP</td>\n",
       "      <td>WCCUSD School</td>\n",
       "      <td>No</td>\n",
       "      <td>0730325</td>\n",
       "      <td>Alternative</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Aspire Richmond Technology Academy</td>\n",
       "      <td>WCCUSD</td>\n",
       "      <td>Non-ILCoP</td>\n",
       "      <td>WCC Charter</td>\n",
       "      <td>Yes</td>\n",
       "      <td>0132118</td>\n",
       "      <td>Elementary</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Bayview Elementary</td>\n",
       "      <td>WCCUSD</td>\n",
       "      <td>ILCoP</td>\n",
       "      <td>WCCUSD School</td>\n",
       "      <td>No</td>\n",
       "      <td>6004600</td>\n",
       "      <td>Elementary</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6</td>\n",
       "      <td>Cesar E. Chavez Elementary</td>\n",
       "      <td>WCCUSD</td>\n",
       "      <td>ILCoP</td>\n",
       "      <td>WCCUSD School</td>\n",
       "      <td>No</td>\n",
       "      <td>6114094</td>\n",
       "      <td>Elementary</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>1</td>\n",
       "      <td>Aspire Ca College Preparatory Academy</td>\n",
       "      <td>WCCUSD</td>\n",
       "      <td>Non-ILCoP</td>\n",
       "      <td>WCC Charter</td>\n",
       "      <td>Yes</td>\n",
       "      <td>0132100</td>\n",
       "      <td>Middle-High</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>25</td>\n",
       "      <td>Invictus Academy of Richmond</td>\n",
       "      <td>CCCOE</td>\n",
       "      <td>Non-ILCoP</td>\n",
       "      <td>WCC Charter</td>\n",
       "      <td>No</td>\n",
       "      <td>0137026</td>\n",
       "      <td>Middle-High</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>35</td>\n",
       "      <td>Making Waves Academy</td>\n",
       "      <td>CCCOE</td>\n",
       "      <td>Non-ILCoP</td>\n",
       "      <td>WCC Charter</td>\n",
       "      <td>No</td>\n",
       "      <td>0114470</td>\n",
       "      <td>Middle-High</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>58</td>\n",
       "      <td>Summit: K2</td>\n",
       "      <td>CCCOE</td>\n",
       "      <td>Non-ILCoP</td>\n",
       "      <td>WCC Charter</td>\n",
       "      <td>Yes</td>\n",
       "      <td>0129684</td>\n",
       "      <td>Middle-High</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>59</td>\n",
       "      <td>Summit: Tamalpais</td>\n",
       "      <td>WCCUSD</td>\n",
       "      <td>Non-ILCoP</td>\n",
       "      <td>WCC Charter</td>\n",
       "      <td>No</td>\n",
       "      <td>0133637</td>\n",
       "      <td>Middle-High</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>66 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     #                              School Name Auth (14) Program (16)  \\\n",
       "0   18                        Greenwood Academy    WCCUSD    Non-ILCoP   \n",
       "1   63  Vista Independent Study/Virtual Academy    WCCUSD    Non-ILCoP   \n",
       "2    2       Aspire Richmond Technology Academy    WCCUSD    Non-ILCoP   \n",
       "3    3                       Bayview Elementary    WCCUSD        ILCoP   \n",
       "4    6               Cesar E. Chavez Elementary    WCCUSD        ILCoP   \n",
       "..  ..                                      ...       ...          ...   \n",
       "61   1    Aspire Ca College Preparatory Academy    WCCUSD    Non-ILCoP   \n",
       "62  25             Invictus Academy of Richmond     CCCOE    Non-ILCoP   \n",
       "63  35                     Making Waves Academy     CCCOE    Non-ILCoP   \n",
       "64  58                               Summit: K2     CCCOE    Non-ILCoP   \n",
       "65  59                        Summit: Tamalpais    WCCUSD    Non-ILCoP   \n",
       "\n",
       "    Charter (14)  Facility (4) School Code  School Type Note  \n",
       "0   WCCUSD School           No     0733253  Alternative  NaN  \n",
       "1   WCCUSD School           No     0730325  Alternative  NaN  \n",
       "2     WCC Charter          Yes     0132118   Elementary  NaN  \n",
       "3   WCCUSD School           No     6004600   Elementary  NaN  \n",
       "4   WCCUSD School           No     6114094   Elementary  NaN  \n",
       "..            ...          ...         ...          ...  ...  \n",
       "61    WCC Charter          Yes     0132100  Middle-High  NaN  \n",
       "62    WCC Charter           No     0137026  Middle-High  NaN  \n",
       "63    WCC Charter           No     0114470  Middle-High  NaN  \n",
       "64    WCC Charter          Yes     0129684  Middle-High  NaN  \n",
       "65    WCC Charter           No     0133637  Middle-High  NaN  \n",
       "\n",
       "[66 rows x 9 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "wcc_schools_df = pd.read_csv('cef_provided_files/cef_school_list.csv', encoding='ISO-8859-1',dtype=str)\n",
    "wcc_schools_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 2023"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>AcademicYear</th>\n",
       "      <th>CountyCode</th>\n",
       "      <th>DistrictCode</th>\n",
       "      <th>SchoolCode</th>\n",
       "      <th>CountyName</th>\n",
       "      <th>DistrictName</th>\n",
       "      <th>SchoolName</th>\n",
       "      <th>Charter</th>\n",
       "      <th>AggLevel</th>\n",
       "      <th>Grade</th>\n",
       "      <th>Gender</th>\n",
       "      <th>EO</th>\n",
       "      <th>IFEP</th>\n",
       "      <th>EL</th>\n",
       "      <th>RFEP</th>\n",
       "      <th>TBD</th>\n",
       "      <th>TotalEnrollment</th>\n",
       "      <th>AR</th>\n",
       "      <th>LTEL</th>\n",
       "      <th>EL4+</th>\n",
       "      <th>EL03Y</th>\n",
       "      <th>EL45Y</th>\n",
       "      <th>EL6+Y</th>\n",
       "      <th>Total-EE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>01</td>\n",
       "      <td>F</td>\n",
       "      <td>133992</td>\n",
       "      <td>11609</td>\n",
       "      <td>50556</td>\n",
       "      <td>2560</td>\n",
       "      <td>460</td>\n",
       "      <td>199177</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>50553</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>53116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>02</td>\n",
       "      <td>F</td>\n",
       "      <td>132237</td>\n",
       "      <td>14066</td>\n",
       "      <td>47940</td>\n",
       "      <td>5890</td>\n",
       "      <td>302</td>\n",
       "      <td>200435</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>212</td>\n",
       "      <td>47728</td>\n",
       "      <td>212</td>\n",
       "      <td>0</td>\n",
       "      <td>53830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>03</td>\n",
       "      <td>F</td>\n",
       "      <td>132417</td>\n",
       "      <td>15930</td>\n",
       "      <td>49164</td>\n",
       "      <td>7971</td>\n",
       "      <td>268</td>\n",
       "      <td>205750</td>\n",
       "      <td>11151</td>\n",
       "      <td>0</td>\n",
       "      <td>1332</td>\n",
       "      <td>36681</td>\n",
       "      <td>12480</td>\n",
       "      <td>3</td>\n",
       "      <td>57135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>04</td>\n",
       "      <td>F</td>\n",
       "      <td>130842</td>\n",
       "      <td>14813</td>\n",
       "      <td>46817</td>\n",
       "      <td>15486</td>\n",
       "      <td>254</td>\n",
       "      <td>208212</td>\n",
       "      <td>24242</td>\n",
       "      <td>0</td>\n",
       "      <td>17321</td>\n",
       "      <td>5254</td>\n",
       "      <td>41262</td>\n",
       "      <td>301</td>\n",
       "      <td>62303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>05</td>\n",
       "      <td>F</td>\n",
       "      <td>128623</td>\n",
       "      <td>8807</td>\n",
       "      <td>46665</td>\n",
       "      <td>26829</td>\n",
       "      <td>211</td>\n",
       "      <td>211135</td>\n",
       "      <td>19569</td>\n",
       "      <td>0</td>\n",
       "      <td>22613</td>\n",
       "      <td>4483</td>\n",
       "      <td>31850</td>\n",
       "      <td>10332</td>\n",
       "      <td>73494</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218995</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72736</td>\n",
       "      <td>6056782</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Marysville Joint Unified</td>\n",
       "      <td>Yuba Feather Elementary</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>06</td>\n",
       "      <td>ALL</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218996</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72751</td>\n",
       "      <td>6056816</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland</td>\n",
       "      <td>Bear River</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>07</td>\n",
       "      <td>ALL</td>\n",
       "      <td>95</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>118</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218997</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72751</td>\n",
       "      <td>6118806</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland</td>\n",
       "      <td>Wheatland Charter Academy</td>\n",
       "      <td>Y</td>\n",
       "      <td>S</td>\n",
       "      <td>01</td>\n",
       "      <td>ALL</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218998</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>0123570</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland Union High</td>\n",
       "      <td>Wheatland Community Day High</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>11</td>\n",
       "      <td>ALL</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218999</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>5838305</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland Union High</td>\n",
       "      <td>Wheatland Union High</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>12</td>\n",
       "      <td>ALL</td>\n",
       "      <td>204</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>244</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>219000 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       AcademicYear CountyCode DistrictCode SchoolCode CountyName  \\\n",
       "0           2022-23        NaN          NaN        NaN        NaN   \n",
       "1           2022-23        NaN          NaN        NaN        NaN   \n",
       "2           2022-23        NaN          NaN        NaN        NaN   \n",
       "3           2022-23        NaN          NaN        NaN        NaN   \n",
       "4           2022-23        NaN          NaN        NaN        NaN   \n",
       "...             ...        ...          ...        ...        ...   \n",
       "218995      2022-23         58        72736    6056782       Yuba   \n",
       "218996      2022-23         58        72751    6056816       Yuba   \n",
       "218997      2022-23         58        72751    6118806       Yuba   \n",
       "218998      2022-23         58        72769    0123570       Yuba   \n",
       "218999      2022-23         58        72769    5838305       Yuba   \n",
       "\n",
       "                    DistrictName                    SchoolName Charter  \\\n",
       "0                            NaN                           NaN     NaN   \n",
       "1                            NaN                           NaN     NaN   \n",
       "2                            NaN                           NaN     NaN   \n",
       "3                            NaN                           NaN     NaN   \n",
       "4                            NaN                           NaN     NaN   \n",
       "...                          ...                           ...     ...   \n",
       "218995  Marysville Joint Unified       Yuba Feather Elementary       N   \n",
       "218996                 Wheatland                    Bear River       N   \n",
       "218997                 Wheatland     Wheatland Charter Academy       Y   \n",
       "218998      Wheatland Union High  Wheatland Community Day High       N   \n",
       "218999      Wheatland Union High          Wheatland Union High       N   \n",
       "\n",
       "       AggLevel Grade Gender      EO   IFEP     EL   RFEP  TBD  \\\n",
       "0             T    01      F  133992  11609  50556   2560  460   \n",
       "1             T    02      F  132237  14066  47940   5890  302   \n",
       "2             T    03      F  132417  15930  49164   7971  268   \n",
       "3             T    04      F  130842  14813  46817  15486  254   \n",
       "4             T    05      F  128623   8807  46665  26829  211   \n",
       "...         ...   ...    ...     ...    ...    ...    ...  ...   \n",
       "218995        S    06    ALL      13      0      0      0    0   \n",
       "218996        S    07    ALL      95      2     12      9    0   \n",
       "218997        S    01    ALL      12      0      0      0    0   \n",
       "218998        S    11    ALL       2      0      0      0    0   \n",
       "218999        S    12    ALL     204      9      5     26    0   \n",
       "\n",
       "       TotalEnrollment     AR LTEL   EL4+  EL03Y  EL45Y  EL6+Y Total-EE  \n",
       "0               199177      0    0      3  50553      1      2    53116  \n",
       "1               200435      0    0    212  47728    212      0    53830  \n",
       "2               205750  11151    0   1332  36681  12480      3    57135  \n",
       "3               208212  24242    0  17321   5254  41262    301    62303  \n",
       "4               211135  19569    0  22613   4483  31850  10332    73494  \n",
       "...                ...    ...  ...    ...    ...    ...    ...      ...  \n",
       "218995              13      0    0      0      0      0      0        0  \n",
       "218996             118      1    4      5      2      1      9       21  \n",
       "218997              12      0    0      0      0      0      0        0  \n",
       "218998               2      0    0      0      0      0      0        0  \n",
       "218999             244      0    4      0      1      0      4       31  \n",
       "\n",
       "[219000 rows x 24 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "enrollment_el_2023_df = pd.read_csv('enrollment_el_csv_files_exported/LtelDownload2223.csv', encoding='ISO-8859-1',dtype=str)\n",
    "pd.set_option('display.max_columns', None)\n",
    "enrollment_el_2023_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 2022"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>AcademicYear</th>\n",
       "      <th>CountyCode</th>\n",
       "      <th>DistrictCode</th>\n",
       "      <th>SchoolCode</th>\n",
       "      <th>CountyName</th>\n",
       "      <th>DistrictName</th>\n",
       "      <th>SchoolName</th>\n",
       "      <th>Charter</th>\n",
       "      <th>AggLevel</th>\n",
       "      <th>Grade</th>\n",
       "      <th>Gender</th>\n",
       "      <th>EO</th>\n",
       "      <th>IFEP</th>\n",
       "      <th>EL</th>\n",
       "      <th>RFEP</th>\n",
       "      <th>TBD</th>\n",
       "      <th>TotalEnrollment</th>\n",
       "      <th>AR</th>\n",
       "      <th>LTEL</th>\n",
       "      <th>EL4+</th>\n",
       "      <th>EL03Y</th>\n",
       "      <th>EL45Y</th>\n",
       "      <th>EL6+Y</th>\n",
       "      <th>Total-EE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>01</td>\n",
       "      <td>F</td>\n",
       "      <td>132811</td>\n",
       "      <td>13761</td>\n",
       "      <td>50396</td>\n",
       "      <td>1171</td>\n",
       "      <td>639</td>\n",
       "      <td>198778</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>50396</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>51567</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>02</td>\n",
       "      <td>F</td>\n",
       "      <td>133678</td>\n",
       "      <td>15914</td>\n",
       "      <td>52434</td>\n",
       "      <td>3214</td>\n",
       "      <td>281</td>\n",
       "      <td>205521</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>307</td>\n",
       "      <td>52127</td>\n",
       "      <td>307</td>\n",
       "      <td>0</td>\n",
       "      <td>55648</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>03</td>\n",
       "      <td>F</td>\n",
       "      <td>132092</td>\n",
       "      <td>14713</td>\n",
       "      <td>50788</td>\n",
       "      <td>10019</td>\n",
       "      <td>234</td>\n",
       "      <td>207846</td>\n",
       "      <td>12449</td>\n",
       "      <td>0</td>\n",
       "      <td>1537</td>\n",
       "      <td>36802</td>\n",
       "      <td>13985</td>\n",
       "      <td>1</td>\n",
       "      <td>60807</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>04</td>\n",
       "      <td>F</td>\n",
       "      <td>130154</td>\n",
       "      <td>8568</td>\n",
       "      <td>52307</td>\n",
       "      <td>20003</td>\n",
       "      <td>199</td>\n",
       "      <td>211231</td>\n",
       "      <td>43798</td>\n",
       "      <td>0</td>\n",
       "      <td>3752</td>\n",
       "      <td>4757</td>\n",
       "      <td>47157</td>\n",
       "      <td>393</td>\n",
       "      <td>72310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>05</td>\n",
       "      <td>F</td>\n",
       "      <td>129625</td>\n",
       "      <td>8956</td>\n",
       "      <td>45488</td>\n",
       "      <td>30483</td>\n",
       "      <td>207</td>\n",
       "      <td>214759</td>\n",
       "      <td>29334</td>\n",
       "      <td>0</td>\n",
       "      <td>12174</td>\n",
       "      <td>3980</td>\n",
       "      <td>31272</td>\n",
       "      <td>10236</td>\n",
       "      <td>75971</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216996</th>\n",
       "      <td>2021-22</td>\n",
       "      <td>58</td>\n",
       "      <td>72751</td>\n",
       "      <td>6056816</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland</td>\n",
       "      <td>Bear River</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>07</td>\n",
       "      <td>ALL</td>\n",
       "      <td>111</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>128</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216997</th>\n",
       "      <td>2021-22</td>\n",
       "      <td>58</td>\n",
       "      <td>72751</td>\n",
       "      <td>6118806</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland</td>\n",
       "      <td>Wheatland Charter Academy</td>\n",
       "      <td>Y</td>\n",
       "      <td>S</td>\n",
       "      <td>01</td>\n",
       "      <td>ALL</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216998</th>\n",
       "      <td>2021-22</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>0000001</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland Union High</td>\n",
       "      <td>Nonpublic, Nonsectarian Schools</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>12</td>\n",
       "      <td>ALL</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216999</th>\n",
       "      <td>2021-22</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>0123570</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland Union High</td>\n",
       "      <td>Wheatland Community Day High</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>11</td>\n",
       "      <td>ALL</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217000</th>\n",
       "      <td>2021-22</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>5838305</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland Union High</td>\n",
       "      <td>Wheatland Union High</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>12</td>\n",
       "      <td>ALL</td>\n",
       "      <td>152</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>193</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>217001 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       AcademicYear CountyCode DistrictCode SchoolCode CountyName  \\\n",
       "0           2021-22        NaN          NaN        NaN        NaN   \n",
       "1           2021-22        NaN          NaN        NaN        NaN   \n",
       "2           2021-22        NaN          NaN        NaN        NaN   \n",
       "3           2021-22        NaN          NaN        NaN        NaN   \n",
       "4           2021-22        NaN          NaN        NaN        NaN   \n",
       "...             ...        ...          ...        ...        ...   \n",
       "216996      2021-22         58        72751    6056816       Yuba   \n",
       "216997      2021-22         58        72751    6118806       Yuba   \n",
       "216998      2021-22         58        72769    0000001       Yuba   \n",
       "216999      2021-22         58        72769    0123570       Yuba   \n",
       "217000      2021-22         58        72769    5838305       Yuba   \n",
       "\n",
       "                DistrictName                       SchoolName Charter  \\\n",
       "0                        NaN                              NaN     NaN   \n",
       "1                        NaN                              NaN     NaN   \n",
       "2                        NaN                              NaN     NaN   \n",
       "3                        NaN                              NaN     NaN   \n",
       "4                        NaN                              NaN     NaN   \n",
       "...                      ...                              ...     ...   \n",
       "216996             Wheatland                       Bear River       N   \n",
       "216997             Wheatland        Wheatland Charter Academy       Y   \n",
       "216998  Wheatland Union High  Nonpublic, Nonsectarian Schools       N   \n",
       "216999  Wheatland Union High     Wheatland Community Day High       N   \n",
       "217000  Wheatland Union High             Wheatland Union High       N   \n",
       "\n",
       "       AggLevel Grade Gender      EO   IFEP     EL   RFEP  TBD  \\\n",
       "0             T    01      F  132811  13761  50396   1171  639   \n",
       "1             T    02      F  133678  15914  52434   3214  281   \n",
       "2             T    03      F  132092  14713  50788  10019  234   \n",
       "3             T    04      F  130154   8568  52307  20003  199   \n",
       "4             T    05      F  129625   8956  45488  30483  207   \n",
       "...         ...   ...    ...     ...    ...    ...    ...  ...   \n",
       "216996        S    07    ALL     111      1      5     11    0   \n",
       "216997        S    01    ALL      19      0      0      0    0   \n",
       "216998        S    12    ALL       1      0      0      0    0   \n",
       "216999        S    11    ALL       0      0      1      0    0   \n",
       "217000        S    12    ALL     152      5      6     30    0   \n",
       "\n",
       "       TotalEnrollment     AR LTEL   EL4+  EL03Y  EL45Y  EL6+Y Total-EE  \n",
       "0               198778      0    0      0  50396      0      0    51567  \n",
       "1               205521      0    0    307  52127    307      0    55648  \n",
       "2               207846  12449    0   1537  36802  13985      1    60807  \n",
       "3               211231  43798    0   3752   4757  47157    393    72310  \n",
       "4               214759  29334    0  12174   3980  31272  10236    75971  \n",
       "...                ...    ...  ...    ...    ...    ...    ...      ...  \n",
       "216996             128      0    5      0      0      0      5       16  \n",
       "216997              19      0    0      0      0      0      0        0  \n",
       "216998               1      0    0      0      0      0      0        0  \n",
       "216999               1      0    1      0      0      0      1        1  \n",
       "217000             193      0    5      0      1      0      5       36  \n",
       "\n",
       "[217001 rows x 24 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "enrollment_el_2022_df = pd.read_csv('enrollment_el_csv_files_exported/LtelDownload2122.csv', encoding='ISO-8859-1',dtype=str)\n",
    "pd.set_option('display.max_columns', None)\n",
    "enrollment_el_2022_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 2021"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>AcademicYear</th>\n",
       "      <th>CountyCode</th>\n",
       "      <th>DistrictCode</th>\n",
       "      <th>SchoolCode</th>\n",
       "      <th>CountyName</th>\n",
       "      <th>DistrictName</th>\n",
       "      <th>SchoolName</th>\n",
       "      <th>Charter</th>\n",
       "      <th>AggLevel</th>\n",
       "      <th>Grade</th>\n",
       "      <th>Gender</th>\n",
       "      <th>EO</th>\n",
       "      <th>IFEP</th>\n",
       "      <th>EL</th>\n",
       "      <th>RFEP</th>\n",
       "      <th>TBD</th>\n",
       "      <th>TotalEnrollment</th>\n",
       "      <th>AR</th>\n",
       "      <th>LTEL</th>\n",
       "      <th>EL4+</th>\n",
       "      <th>EL03Y</th>\n",
       "      <th>EL45Y</th>\n",
       "      <th>EL6+Y</th>\n",
       "      <th>Total-EE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>01</td>\n",
       "      <td>F</td>\n",
       "      <td>136189</td>\n",
       "      <td>15550</td>\n",
       "      <td>54235</td>\n",
       "      <td>568</td>\n",
       "      <td>1310</td>\n",
       "      <td>207852</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>54232</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>54803</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>02</td>\n",
       "      <td>F</td>\n",
       "      <td>135167</td>\n",
       "      <td>14682</td>\n",
       "      <td>53472</td>\n",
       "      <td>6986</td>\n",
       "      <td>713</td>\n",
       "      <td>211020</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>415</td>\n",
       "      <td>53057</td>\n",
       "      <td>415</td>\n",
       "      <td>0</td>\n",
       "      <td>60458</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>03</td>\n",
       "      <td>F</td>\n",
       "      <td>133421</td>\n",
       "      <td>8438</td>\n",
       "      <td>55356</td>\n",
       "      <td>16804</td>\n",
       "      <td>620</td>\n",
       "      <td>214639</td>\n",
       "      <td>14020</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>41333</td>\n",
       "      <td>14020</td>\n",
       "      <td>3</td>\n",
       "      <td>72160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>04</td>\n",
       "      <td>F</td>\n",
       "      <td>132819</td>\n",
       "      <td>8784</td>\n",
       "      <td>48319</td>\n",
       "      <td>27656</td>\n",
       "      <td>525</td>\n",
       "      <td>218103</td>\n",
       "      <td>43322</td>\n",
       "      <td>0</td>\n",
       "      <td>399</td>\n",
       "      <td>4598</td>\n",
       "      <td>43322</td>\n",
       "      <td>399</td>\n",
       "      <td>75975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>05</td>\n",
       "      <td>F</td>\n",
       "      <td>130307</td>\n",
       "      <td>9279</td>\n",
       "      <td>41111</td>\n",
       "      <td>38463</td>\n",
       "      <td>509</td>\n",
       "      <td>219669</td>\n",
       "      <td>28073</td>\n",
       "      <td>0</td>\n",
       "      <td>8873</td>\n",
       "      <td>4165</td>\n",
       "      <td>28073</td>\n",
       "      <td>8873</td>\n",
       "      <td>79574</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213413</th>\n",
       "      <td>2020-21</td>\n",
       "      <td>58</td>\n",
       "      <td>72744</td>\n",
       "      <td>0107375</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Plumas Lake Elementary</td>\n",
       "      <td>Rio Del Oro Elementary</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>02</td>\n",
       "      <td>ALL</td>\n",
       "      <td>72</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>79</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213414</th>\n",
       "      <td>2020-21</td>\n",
       "      <td>58</td>\n",
       "      <td>72751</td>\n",
       "      <td>6056832</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland</td>\n",
       "      <td>Lone Tree Elementary</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>02</td>\n",
       "      <td>ALL</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213415</th>\n",
       "      <td>2020-21</td>\n",
       "      <td>58</td>\n",
       "      <td>72751</td>\n",
       "      <td>6056832</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland</td>\n",
       "      <td>Lone Tree Elementary</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>04</td>\n",
       "      <td>ALL</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>43</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213416</th>\n",
       "      <td>2020-21</td>\n",
       "      <td>58</td>\n",
       "      <td>72751</td>\n",
       "      <td>6056840</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland</td>\n",
       "      <td>Wheatland Elementary</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>01</td>\n",
       "      <td>ALL</td>\n",
       "      <td>69</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>77</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213417</th>\n",
       "      <td>2020-21</td>\n",
       "      <td>58</td>\n",
       "      <td>72751</td>\n",
       "      <td>6056840</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland</td>\n",
       "      <td>Wheatland Elementary</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>02</td>\n",
       "      <td>ALL</td>\n",
       "      <td>62</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>71</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>213418 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       AcademicYear CountyCode DistrictCode SchoolCode CountyName  \\\n",
       "0           2020-21        NaN          NaN        NaN        NaN   \n",
       "1           2020-21        NaN          NaN        NaN        NaN   \n",
       "2           2020-21        NaN          NaN        NaN        NaN   \n",
       "3           2020-21        NaN          NaN        NaN        NaN   \n",
       "4           2020-21        NaN          NaN        NaN        NaN   \n",
       "...             ...        ...          ...        ...        ...   \n",
       "213413      2020-21         58        72744    0107375       Yuba   \n",
       "213414      2020-21         58        72751    6056832       Yuba   \n",
       "213415      2020-21         58        72751    6056832       Yuba   \n",
       "213416      2020-21         58        72751    6056840       Yuba   \n",
       "213417      2020-21         58        72751    6056840       Yuba   \n",
       "\n",
       "                  DistrictName              SchoolName Charter AggLevel Grade  \\\n",
       "0                          NaN                     NaN     NaN        T    01   \n",
       "1                          NaN                     NaN     NaN        T    02   \n",
       "2                          NaN                     NaN     NaN        T    03   \n",
       "3                          NaN                     NaN     NaN        T    04   \n",
       "4                          NaN                     NaN     NaN        T    05   \n",
       "...                        ...                     ...     ...      ...   ...   \n",
       "213413  Plumas Lake Elementary  Rio Del Oro Elementary       N        S    02   \n",
       "213414               Wheatland    Lone Tree Elementary       N        S    02   \n",
       "213415               Wheatland    Lone Tree Elementary       N        S    04   \n",
       "213416               Wheatland    Wheatland Elementary       N        S    01   \n",
       "213417               Wheatland    Wheatland Elementary       N        S    02   \n",
       "\n",
       "       Gender      EO   IFEP     EL   RFEP   TBD TotalEnrollment     AR LTEL  \\\n",
       "0           F  136189  15550  54235    568  1310          207852      0    0   \n",
       "1           F  135167  14682  53472   6986   713          211020      0    0   \n",
       "2           F  133421   8438  55356  16804   620          214639  14020    0   \n",
       "3           F  132819   8784  48319  27656   525          218103  43322    0   \n",
       "4           F  130307   9279  41111  38463   509          219669  28073    0   \n",
       "...       ...     ...    ...    ...    ...   ...             ...    ...  ...   \n",
       "213413    ALL      72      2      5      0     0              79      0    0   \n",
       "213414    ALL      42      0      0      0     0              42      0    0   \n",
       "213415    ALL      40      1      2      0     0              43      2    0   \n",
       "213416    ALL      69      1      7      0     0              77      0    0   \n",
       "213417    ALL      62      2      7      0     0              71      0    0   \n",
       "\n",
       "        EL4+  EL03Y  EL45Y EL6+Y Total-EE  \n",
       "0          3  54232      3     0    54803  \n",
       "1        415  53057    415     0    60458  \n",
       "2          3  41333  14020     3    72160  \n",
       "3        399   4598  43322   399    75975  \n",
       "4       8873   4165  28073  8873    79574  \n",
       "...      ...    ...    ...   ...      ...  \n",
       "213413     0      5      0     0        5  \n",
       "213414     0      0      0     0        0  \n",
       "213415     0      0      2     0        2  \n",
       "213416     0      7      0     0        7  \n",
       "213417     0      7      0     0        7  \n",
       "\n",
       "[213418 rows x 24 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "enrollment_el_2021_df = pd.read_csv('enrollment_el_csv_files_exported/LtelDownload2021.csv', encoding='ISO-8859-1',dtype=str)\n",
    "pd.set_option('display.max_columns', None)\n",
    "enrollment_el_2021_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 2020"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>AcademicYear</th>\n",
       "      <th>CountyCode</th>\n",
       "      <th>DistrictCode</th>\n",
       "      <th>SchoolCode</th>\n",
       "      <th>CountyName</th>\n",
       "      <th>DistrictName</th>\n",
       "      <th>SchoolName</th>\n",
       "      <th>Charter</th>\n",
       "      <th>AggLevel</th>\n",
       "      <th>Grade</th>\n",
       "      <th>Gender</th>\n",
       "      <th>EO</th>\n",
       "      <th>IFEP</th>\n",
       "      <th>EL</th>\n",
       "      <th>RFEP</th>\n",
       "      <th>TBD</th>\n",
       "      <th>TotalEnrollment</th>\n",
       "      <th>AR</th>\n",
       "      <th>LTEL</th>\n",
       "      <th>EL4+</th>\n",
       "      <th>EL03Y</th>\n",
       "      <th>EL45Y</th>\n",
       "      <th>EL6+Y</th>\n",
       "      <th>Total-EE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2019-20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>01</td>\n",
       "      <td>F</td>\n",
       "      <td>138716</td>\n",
       "      <td>14737</td>\n",
       "      <td>59837</td>\n",
       "      <td>2993</td>\n",
       "      <td>209</td>\n",
       "      <td>216492</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>102</td>\n",
       "      <td>59735</td>\n",
       "      <td>42</td>\n",
       "      <td>60</td>\n",
       "      <td>62830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2019-20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>02</td>\n",
       "      <td>F</td>\n",
       "      <td>136760</td>\n",
       "      <td>8425</td>\n",
       "      <td>59066</td>\n",
       "      <td>13672</td>\n",
       "      <td>134</td>\n",
       "      <td>218057</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>691</td>\n",
       "      <td>58375</td>\n",
       "      <td>682</td>\n",
       "      <td>9</td>\n",
       "      <td>72738</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2019-20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>03</td>\n",
       "      <td>F</td>\n",
       "      <td>136062</td>\n",
       "      <td>8817</td>\n",
       "      <td>52726</td>\n",
       "      <td>23654</td>\n",
       "      <td>121</td>\n",
       "      <td>221380</td>\n",
       "      <td>11157</td>\n",
       "      <td>0</td>\n",
       "      <td>1925</td>\n",
       "      <td>39644</td>\n",
       "      <td>13079</td>\n",
       "      <td>3</td>\n",
       "      <td>76380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2019-20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>04</td>\n",
       "      <td>F</td>\n",
       "      <td>133210</td>\n",
       "      <td>9251</td>\n",
       "      <td>44953</td>\n",
       "      <td>34984</td>\n",
       "      <td>117</td>\n",
       "      <td>222515</td>\n",
       "      <td>20901</td>\n",
       "      <td>0</td>\n",
       "      <td>18303</td>\n",
       "      <td>5749</td>\n",
       "      <td>38674</td>\n",
       "      <td>530</td>\n",
       "      <td>79937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2019-20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>05</td>\n",
       "      <td>F</td>\n",
       "      <td>127340</td>\n",
       "      <td>9439</td>\n",
       "      <td>44778</td>\n",
       "      <td>35786</td>\n",
       "      <td>103</td>\n",
       "      <td>217446</td>\n",
       "      <td>17116</td>\n",
       "      <td>0</td>\n",
       "      <td>22409</td>\n",
       "      <td>5253</td>\n",
       "      <td>30292</td>\n",
       "      <td>9233</td>\n",
       "      <td>80564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212091</th>\n",
       "      <td>2019-20</td>\n",
       "      <td>58</td>\n",
       "      <td>72744</td>\n",
       "      <td>0107375</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Plumas Lake Elementary</td>\n",
       "      <td>Rio Del Oro Elementary</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>02</td>\n",
       "      <td>ALL</td>\n",
       "      <td>86</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>94</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212092</th>\n",
       "      <td>2019-20</td>\n",
       "      <td>58</td>\n",
       "      <td>72751</td>\n",
       "      <td>6056832</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland</td>\n",
       "      <td>Lone Tree Elementary</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>02</td>\n",
       "      <td>ALL</td>\n",
       "      <td>71</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>74</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212093</th>\n",
       "      <td>2019-20</td>\n",
       "      <td>58</td>\n",
       "      <td>72751</td>\n",
       "      <td>6056832</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland</td>\n",
       "      <td>Lone Tree Elementary</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>04</td>\n",
       "      <td>ALL</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>44</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212094</th>\n",
       "      <td>2019-20</td>\n",
       "      <td>58</td>\n",
       "      <td>72751</td>\n",
       "      <td>6056840</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland</td>\n",
       "      <td>Wheatland Elementary</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>01</td>\n",
       "      <td>ALL</td>\n",
       "      <td>56</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>66</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212095</th>\n",
       "      <td>2019-20</td>\n",
       "      <td>58</td>\n",
       "      <td>72751</td>\n",
       "      <td>6056840</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland</td>\n",
       "      <td>Wheatland Elementary</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>02</td>\n",
       "      <td>ALL</td>\n",
       "      <td>67</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>73</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>212096 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       AcademicYear CountyCode DistrictCode SchoolCode CountyName  \\\n",
       "0           2019-20        NaN          NaN        NaN        NaN   \n",
       "1           2019-20        NaN          NaN        NaN        NaN   \n",
       "2           2019-20        NaN          NaN        NaN        NaN   \n",
       "3           2019-20        NaN          NaN        NaN        NaN   \n",
       "4           2019-20        NaN          NaN        NaN        NaN   \n",
       "...             ...        ...          ...        ...        ...   \n",
       "212091      2019-20         58        72744    0107375       Yuba   \n",
       "212092      2019-20         58        72751    6056832       Yuba   \n",
       "212093      2019-20         58        72751    6056832       Yuba   \n",
       "212094      2019-20         58        72751    6056840       Yuba   \n",
       "212095      2019-20         58        72751    6056840       Yuba   \n",
       "\n",
       "                  DistrictName              SchoolName Charter AggLevel Grade  \\\n",
       "0                          NaN                     NaN     NaN        T    01   \n",
       "1                          NaN                     NaN     NaN        T    02   \n",
       "2                          NaN                     NaN     NaN        T    03   \n",
       "3                          NaN                     NaN     NaN        T    04   \n",
       "4                          NaN                     NaN     NaN        T    05   \n",
       "...                        ...                     ...     ...      ...   ...   \n",
       "212091  Plumas Lake Elementary  Rio Del Oro Elementary       N        S    02   \n",
       "212092               Wheatland    Lone Tree Elementary       N        S    02   \n",
       "212093               Wheatland    Lone Tree Elementary       N        S    04   \n",
       "212094               Wheatland    Wheatland Elementary       N        S    01   \n",
       "212095               Wheatland    Wheatland Elementary       N        S    02   \n",
       "\n",
       "       Gender      EO   IFEP     EL   RFEP  TBD TotalEnrollment     AR LTEL  \\\n",
       "0           F  138716  14737  59837   2993  209          216492      0    0   \n",
       "1           F  136760   8425  59066  13672  134          218057      0    0   \n",
       "2           F  136062   8817  52726  23654  121          221380  11157    0   \n",
       "3           F  133210   9251  44953  34984  117          222515  20901    0   \n",
       "4           F  127340   9439  44778  35786  103          217446  17116    0   \n",
       "...       ...     ...    ...    ...    ...  ...             ...    ...  ...   \n",
       "212091    ALL      86      0      6      2    0              94      0    0   \n",
       "212092    ALL      71      0      3      0    0              74      0    0   \n",
       "212093    ALL      42      0      1      1    0              44      0    0   \n",
       "212094    ALL      56      2      8      0    0              66      0    0   \n",
       "212095    ALL      67      0      5      1    0              73      0    0   \n",
       "\n",
       "         EL4+  EL03Y  EL45Y EL6+Y Total-EE  \n",
       "0         102  59735     42    60    62830  \n",
       "1         691  58375    682     9    72738  \n",
       "2        1925  39644  13079     3    76380  \n",
       "3       18303   5749  38674   530    79937  \n",
       "4       22409   5253  30292  9233    80564  \n",
       "...       ...    ...    ...   ...      ...  \n",
       "212091      0      6      0     0        8  \n",
       "212092      0      3      0     0        3  \n",
       "212093      1      0      1     0        2  \n",
       "212094      0      8      0     0        8  \n",
       "212095      0      5      0     0        6  \n",
       "\n",
       "[212096 rows x 24 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "enrollment_el_2020_df = pd.read_csv('enrollment_el_csv_files_exported/LtelDownload1920.csv', encoding='ISO-8859-1',dtype=str)\n",
    "pd.set_option('display.max_columns', None)\n",
    "enrollment_el_2020_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 2019"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>AcademicYear</th>\n",
       "      <th>CountyCode</th>\n",
       "      <th>DistrictCode</th>\n",
       "      <th>SchoolCode</th>\n",
       "      <th>CountyName</th>\n",
       "      <th>DistrictName</th>\n",
       "      <th>SchoolName</th>\n",
       "      <th>Charter</th>\n",
       "      <th>AggLevel</th>\n",
       "      <th>Grade</th>\n",
       "      <th>Gender</th>\n",
       "      <th>EO</th>\n",
       "      <th>IFEP</th>\n",
       "      <th>EL</th>\n",
       "      <th>RFEP</th>\n",
       "      <th>TBD</th>\n",
       "      <th>TotalEnrollment</th>\n",
       "      <th>AR</th>\n",
       "      <th>LTEL</th>\n",
       "      <th>EL4+</th>\n",
       "      <th>EL03Y</th>\n",
       "      <th>EL45Y</th>\n",
       "      <th>EL6+Y</th>\n",
       "      <th>Total-EE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>01</td>\n",
       "      <td>F</td>\n",
       "      <td>137324</td>\n",
       "      <td>7913</td>\n",
       "      <td>69183</td>\n",
       "      <td>3606</td>\n",
       "      <td>323</td>\n",
       "      <td>218349</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>74</td>\n",
       "      <td>69109</td>\n",
       "      <td>20</td>\n",
       "      <td>54</td>\n",
       "      <td>72789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018-19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>02</td>\n",
       "      <td>F</td>\n",
       "      <td>136936</td>\n",
       "      <td>8529</td>\n",
       "      <td>64252</td>\n",
       "      <td>11144</td>\n",
       "      <td>242</td>\n",
       "      <td>221103</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>913</td>\n",
       "      <td>63339</td>\n",
       "      <td>907</td>\n",
       "      <td>6</td>\n",
       "      <td>75396</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018-19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>03</td>\n",
       "      <td>F</td>\n",
       "      <td>134232</td>\n",
       "      <td>8939</td>\n",
       "      <td>56292</td>\n",
       "      <td>22551</td>\n",
       "      <td>214</td>\n",
       "      <td>222228</td>\n",
       "      <td>14122</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>42161</td>\n",
       "      <td>14122</td>\n",
       "      <td>9</td>\n",
       "      <td>78843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2018-19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>04</td>\n",
       "      <td>F</td>\n",
       "      <td>128240</td>\n",
       "      <td>9109</td>\n",
       "      <td>51238</td>\n",
       "      <td>28414</td>\n",
       "      <td>163</td>\n",
       "      <td>217164</td>\n",
       "      <td>44863</td>\n",
       "      <td>0</td>\n",
       "      <td>757</td>\n",
       "      <td>5618</td>\n",
       "      <td>44863</td>\n",
       "      <td>757</td>\n",
       "      <td>79652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2018-19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>05</td>\n",
       "      <td>F</td>\n",
       "      <td>130730</td>\n",
       "      <td>9650</td>\n",
       "      <td>45577</td>\n",
       "      <td>39987</td>\n",
       "      <td>165</td>\n",
       "      <td>226109</td>\n",
       "      <td>31939</td>\n",
       "      <td>0</td>\n",
       "      <td>8559</td>\n",
       "      <td>5079</td>\n",
       "      <td>31939</td>\n",
       "      <td>8559</td>\n",
       "      <td>85564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210811</th>\n",
       "      <td>2018-19</td>\n",
       "      <td>58</td>\n",
       "      <td>72736</td>\n",
       "      <td>6099014</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Marysville Joint Unified</td>\n",
       "      <td>Browns Valley Elementary</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>03</td>\n",
       "      <td>ALL</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210812</th>\n",
       "      <td>2018-19</td>\n",
       "      <td>58</td>\n",
       "      <td>72736</td>\n",
       "      <td>6099014</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Marysville Joint Unified</td>\n",
       "      <td>Browns Valley Elementary</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>05</td>\n",
       "      <td>ALL</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210813</th>\n",
       "      <td>2018-19</td>\n",
       "      <td>58</td>\n",
       "      <td>72744</td>\n",
       "      <td>0107375</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Plumas Lake Elementary</td>\n",
       "      <td>Rio Del Oro Elementary</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>04</td>\n",
       "      <td>ALL</td>\n",
       "      <td>57</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>67</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210814</th>\n",
       "      <td>2018-19</td>\n",
       "      <td>58</td>\n",
       "      <td>72744</td>\n",
       "      <td>0114652</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Plumas Lake Elementary</td>\n",
       "      <td>Cobblestone Elementary</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>03</td>\n",
       "      <td>ALL</td>\n",
       "      <td>57</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>63</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210815</th>\n",
       "      <td>2018-19</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>0000001</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland Union High</td>\n",
       "      <td>Nonpublic, Nonsectarian Schools</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>10</td>\n",
       "      <td>ALL</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>210816 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       AcademicYear CountyCode DistrictCode SchoolCode CountyName  \\\n",
       "0           2018-19        NaN          NaN        NaN        NaN   \n",
       "1           2018-19        NaN          NaN        NaN        NaN   \n",
       "2           2018-19        NaN          NaN        NaN        NaN   \n",
       "3           2018-19        NaN          NaN        NaN        NaN   \n",
       "4           2018-19        NaN          NaN        NaN        NaN   \n",
       "...             ...        ...          ...        ...        ...   \n",
       "210811      2018-19         58        72736    6099014       Yuba   \n",
       "210812      2018-19         58        72736    6099014       Yuba   \n",
       "210813      2018-19         58        72744    0107375       Yuba   \n",
       "210814      2018-19         58        72744    0114652       Yuba   \n",
       "210815      2018-19         58        72769    0000001       Yuba   \n",
       "\n",
       "                    DistrictName                       SchoolName Charter  \\\n",
       "0                            NaN                              NaN     NaN   \n",
       "1                            NaN                              NaN     NaN   \n",
       "2                            NaN                              NaN     NaN   \n",
       "3                            NaN                              NaN     NaN   \n",
       "4                            NaN                              NaN     NaN   \n",
       "...                          ...                              ...     ...   \n",
       "210811  Marysville Joint Unified         Browns Valley Elementary       N   \n",
       "210812  Marysville Joint Unified         Browns Valley Elementary       N   \n",
       "210813    Plumas Lake Elementary           Rio Del Oro Elementary       N   \n",
       "210814    Plumas Lake Elementary           Cobblestone Elementary       N   \n",
       "210815      Wheatland Union High  Nonpublic, Nonsectarian Schools       N   \n",
       "\n",
       "       AggLevel Grade Gender      EO  IFEP     EL   RFEP  TBD TotalEnrollment  \\\n",
       "0             T    01      F  137324  7913  69183   3606  323          218349   \n",
       "1             T    02      F  136936  8529  64252  11144  242          221103   \n",
       "2             T    03      F  134232  8939  56292  22551  214          222228   \n",
       "3             T    04      F  128240  9109  51238  28414  163          217164   \n",
       "4             T    05      F  130730  9650  45577  39987  165          226109   \n",
       "...         ...   ...    ...     ...   ...    ...    ...  ...             ...   \n",
       "210811        S    03    ALL      30     0      1      0    0              31   \n",
       "210812        S    05    ALL      24     1      0      0    0              25   \n",
       "210813        S    04    ALL      57     0      6      4    0              67   \n",
       "210814        S    03    ALL      57     0      5      1    0              63   \n",
       "210815        S    10    ALL       1     0      0      0    0               1   \n",
       "\n",
       "           AR LTEL  EL4+  EL03Y  EL45Y EL6+Y Total-EE  \n",
       "0           0    0    74  69109     20    54    72789  \n",
       "1           0    0   913  63339    907     6    75396  \n",
       "2       14122    0     9  42161  14122     9    78843  \n",
       "3       44863    0   757   5618  44863   757    79652  \n",
       "4       31939    0  8559   5079  31939  8559    85564  \n",
       "...       ...  ...   ...    ...    ...   ...      ...  \n",
       "210811      1    0     0      0      1     0        1  \n",
       "210812      0    0     0      0      0     0        0  \n",
       "210813      5    0     0      1      5     0       10  \n",
       "210814      0    0     0      5      0     0        6  \n",
       "210815      0    0     0      0      0     0        0  \n",
       "\n",
       "[210816 rows x 24 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "enrollment_el_2019_df = pd.read_csv('enrollment_el_csv_files_exported/LtelDownload1819.csv', encoding='ISO-8859-1',dtype=str)\n",
    "pd.set_option('display.max_columns', None)\n",
    "enrollment_el_2019_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 2018"
   ]
  },
  {
   "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>AcademicYear</th>\n",
       "      <th>CountyCode</th>\n",
       "      <th>DistrictCode</th>\n",
       "      <th>SchoolCode</th>\n",
       "      <th>CountyName</th>\n",
       "      <th>DistrictName</th>\n",
       "      <th>SchoolName</th>\n",
       "      <th>Charter</th>\n",
       "      <th>AggLevel</th>\n",
       "      <th>Grade</th>\n",
       "      <th>Gender</th>\n",
       "      <th>EO</th>\n",
       "      <th>IFEP</th>\n",
       "      <th>EL</th>\n",
       "      <th>RFEP</th>\n",
       "      <th>TBD</th>\n",
       "      <th>TotalEnrollment</th>\n",
       "      <th>AR</th>\n",
       "      <th>LTEL</th>\n",
       "      <th>EL4+</th>\n",
       "      <th>EL03Y</th>\n",
       "      <th>EL45Y</th>\n",
       "      <th>EL6+Y</th>\n",
       "      <th>Total-EE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>01</td>\n",
       "      <td>F</td>\n",
       "      <td>137765</td>\n",
       "      <td>7955</td>\n",
       "      <td>74303</td>\n",
       "      <td>1391</td>\n",
       "      <td>233</td>\n",
       "      <td>221647</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>86</td>\n",
       "      <td>74217</td>\n",
       "      <td>3</td>\n",
       "      <td>83</td>\n",
       "      <td>75694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>02</td>\n",
       "      <td>F</td>\n",
       "      <td>134727</td>\n",
       "      <td>8702</td>\n",
       "      <td>68053</td>\n",
       "      <td>10366</td>\n",
       "      <td>141</td>\n",
       "      <td>221989</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1272</td>\n",
       "      <td>66781</td>\n",
       "      <td>1269</td>\n",
       "      <td>3</td>\n",
       "      <td>78419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>03</td>\n",
       "      <td>F</td>\n",
       "      <td>128616</td>\n",
       "      <td>8812</td>\n",
       "      <td>60090</td>\n",
       "      <td>18970</td>\n",
       "      <td>127</td>\n",
       "      <td>216615</td>\n",
       "      <td>10099</td>\n",
       "      <td>0</td>\n",
       "      <td>4173</td>\n",
       "      <td>45818</td>\n",
       "      <td>14255</td>\n",
       "      <td>17</td>\n",
       "      <td>79060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>04</td>\n",
       "      <td>F</td>\n",
       "      <td>131383</td>\n",
       "      <td>9365</td>\n",
       "      <td>55478</td>\n",
       "      <td>29443</td>\n",
       "      <td>92</td>\n",
       "      <td>225761</td>\n",
       "      <td>26786</td>\n",
       "      <td>0</td>\n",
       "      <td>23097</td>\n",
       "      <td>5595</td>\n",
       "      <td>49135</td>\n",
       "      <td>748</td>\n",
       "      <td>84921</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>05</td>\n",
       "      <td>F</td>\n",
       "      <td>131962</td>\n",
       "      <td>9584</td>\n",
       "      <td>47428</td>\n",
       "      <td>40262</td>\n",
       "      <td>101</td>\n",
       "      <td>229337</td>\n",
       "      <td>19798</td>\n",
       "      <td>0</td>\n",
       "      <td>22641</td>\n",
       "      <td>4989</td>\n",
       "      <td>34508</td>\n",
       "      <td>7931</td>\n",
       "      <td>87690</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210716</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>58</td>\n",
       "      <td>72736</td>\n",
       "      <td>6056725</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Marysville Joint Unified</td>\n",
       "      <td>Loma Rica Elementary</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>KN</td>\n",
       "      <td>ALL</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210717</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>58</td>\n",
       "      <td>72736</td>\n",
       "      <td>6056741</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Marysville Joint Unified</td>\n",
       "      <td>Olivehurst Elementary</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>04</td>\n",
       "      <td>ALL</td>\n",
       "      <td>46</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>66</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>2</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210718</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>58</td>\n",
       "      <td>72736</td>\n",
       "      <td>6056782</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Marysville Joint Unified</td>\n",
       "      <td>Yuba Feather Elementary</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>03</td>\n",
       "      <td>ALL</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210719</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>58</td>\n",
       "      <td>72751</td>\n",
       "      <td>6118806</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland</td>\n",
       "      <td>Wheatland Charter Academy</td>\n",
       "      <td>Y</td>\n",
       "      <td>S</td>\n",
       "      <td>02</td>\n",
       "      <td>ALL</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210720</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>58</td>\n",
       "      <td>72751</td>\n",
       "      <td>6118806</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland</td>\n",
       "      <td>Wheatland Charter Academy</td>\n",
       "      <td>Y</td>\n",
       "      <td>S</td>\n",
       "      <td>KN</td>\n",
       "      <td>ALL</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>210721 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       AcademicYear CountyCode DistrictCode SchoolCode CountyName  \\\n",
       "0           2017-18        NaN          NaN        NaN        NaN   \n",
       "1           2017-18        NaN          NaN        NaN        NaN   \n",
       "2           2017-18        NaN          NaN        NaN        NaN   \n",
       "3           2017-18        NaN          NaN        NaN        NaN   \n",
       "4           2017-18        NaN          NaN        NaN        NaN   \n",
       "...             ...        ...          ...        ...        ...   \n",
       "210716      2017-18         58        72736    6056725       Yuba   \n",
       "210717      2017-18         58        72736    6056741       Yuba   \n",
       "210718      2017-18         58        72736    6056782       Yuba   \n",
       "210719      2017-18         58        72751    6118806       Yuba   \n",
       "210720      2017-18         58        72751    6118806       Yuba   \n",
       "\n",
       "                    DistrictName                 SchoolName Charter AggLevel  \\\n",
       "0                            NaN                        NaN     NaN        T   \n",
       "1                            NaN                        NaN     NaN        T   \n",
       "2                            NaN                        NaN     NaN        T   \n",
       "3                            NaN                        NaN     NaN        T   \n",
       "4                            NaN                        NaN     NaN        T   \n",
       "...                          ...                        ...     ...      ...   \n",
       "210716  Marysville Joint Unified       Loma Rica Elementary       N        S   \n",
       "210717  Marysville Joint Unified      Olivehurst Elementary       N        S   \n",
       "210718  Marysville Joint Unified    Yuba Feather Elementary       N        S   \n",
       "210719                 Wheatland  Wheatland Charter Academy       Y        S   \n",
       "210720                 Wheatland  Wheatland Charter Academy       Y        S   \n",
       "\n",
       "       Grade Gender      EO  IFEP     EL   RFEP  TBD TotalEnrollment     AR  \\\n",
       "0         01      F  137765  7955  74303   1391  233          221647      0   \n",
       "1         02      F  134727  8702  68053  10366  141          221989      0   \n",
       "2         03      F  128616  8812  60090  18970  127          216615  10099   \n",
       "3         04      F  131383  9365  55478  29443   92          225761  26786   \n",
       "4         05      F  131962  9584  47428  40262  101          229337  19798   \n",
       "...      ...    ...     ...   ...    ...    ...  ...             ...    ...   \n",
       "210716    KN    ALL      12     0      1      0    0              13      0   \n",
       "210717    04    ALL      46     0     18      2    0              66     11   \n",
       "210718    03    ALL      19     0      1      0    0              20      0   \n",
       "210719    02    ALL      22     0      2      1    0              25      0   \n",
       "210720    KN    ALL      24     0      1      0    0              25      0   \n",
       "\n",
       "       LTEL   EL4+  EL03Y  EL45Y EL6+Y Total-EE  \n",
       "0         0     86  74217      3    83    75694  \n",
       "1         0   1272  66781   1269     3    78419  \n",
       "2         0   4173  45818  14255    17    79060  \n",
       "3         0  23097   5595  49135   748    84921  \n",
       "4         0  22641   4989  34508  7931    87690  \n",
       "...     ...    ...    ...    ...   ...      ...  \n",
       "210716    0      0      1      0     0        1  \n",
       "210717    0      7      0     16     2       20  \n",
       "210718    0      0      1      0     0        1  \n",
       "210719    0      0      2      0     0        3  \n",
       "210720    0      0      1      0     0        1  \n",
       "\n",
       "[210721 rows x 24 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "enrollment_el_2018_df = pd.read_csv('enrollment_el_csv_files_exported/LtelDownload1718.csv', encoding='ISO-8859-1',dtype=str)\n",
    "pd.set_option('display.max_columns', None)\n",
    "enrollment_el_2018_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>AcademicYear</th>\n",
       "      <th>CountyCode</th>\n",
       "      <th>DistrictCode</th>\n",
       "      <th>SchoolCode</th>\n",
       "      <th>CountyName</th>\n",
       "      <th>DistrictName</th>\n",
       "      <th>SchoolName</th>\n",
       "      <th>Charter</th>\n",
       "      <th>AggLevel</th>\n",
       "      <th>Grade</th>\n",
       "      <th>Gender</th>\n",
       "      <th>EO</th>\n",
       "      <th>IFEP</th>\n",
       "      <th>EL</th>\n",
       "      <th>RFEP</th>\n",
       "      <th>TBD</th>\n",
       "      <th>TotalEnrollment</th>\n",
       "      <th>AR</th>\n",
       "      <th>LTEL</th>\n",
       "      <th>EL4+</th>\n",
       "      <th>EL03Y</th>\n",
       "      <th>EL45Y</th>\n",
       "      <th>EL6+Y</th>\n",
       "      <th>Total-EE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>01</td>\n",
       "      <td>F</td>\n",
       "      <td>133992</td>\n",
       "      <td>11609</td>\n",
       "      <td>50556</td>\n",
       "      <td>2560</td>\n",
       "      <td>460</td>\n",
       "      <td>199177</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>50553</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>53116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>02</td>\n",
       "      <td>F</td>\n",
       "      <td>132237</td>\n",
       "      <td>14066</td>\n",
       "      <td>47940</td>\n",
       "      <td>5890</td>\n",
       "      <td>302</td>\n",
       "      <td>200435</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>212</td>\n",
       "      <td>47728</td>\n",
       "      <td>212</td>\n",
       "      <td>0</td>\n",
       "      <td>53830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>03</td>\n",
       "      <td>F</td>\n",
       "      <td>132417</td>\n",
       "      <td>15930</td>\n",
       "      <td>49164</td>\n",
       "      <td>7971</td>\n",
       "      <td>268</td>\n",
       "      <td>205750</td>\n",
       "      <td>11151</td>\n",
       "      <td>0</td>\n",
       "      <td>1332</td>\n",
       "      <td>36681</td>\n",
       "      <td>12480</td>\n",
       "      <td>3</td>\n",
       "      <td>57135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>04</td>\n",
       "      <td>F</td>\n",
       "      <td>130842</td>\n",
       "      <td>14813</td>\n",
       "      <td>46817</td>\n",
       "      <td>15486</td>\n",
       "      <td>254</td>\n",
       "      <td>208212</td>\n",
       "      <td>24242</td>\n",
       "      <td>0</td>\n",
       "      <td>17321</td>\n",
       "      <td>5254</td>\n",
       "      <td>41262</td>\n",
       "      <td>301</td>\n",
       "      <td>62303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>05</td>\n",
       "      <td>F</td>\n",
       "      <td>128623</td>\n",
       "      <td>8807</td>\n",
       "      <td>46665</td>\n",
       "      <td>26829</td>\n",
       "      <td>211</td>\n",
       "      <td>211135</td>\n",
       "      <td>19569</td>\n",
       "      <td>0</td>\n",
       "      <td>22613</td>\n",
       "      <td>4483</td>\n",
       "      <td>31850</td>\n",
       "      <td>10332</td>\n",
       "      <td>73494</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210716</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>58</td>\n",
       "      <td>72736</td>\n",
       "      <td>6056725</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Marysville Joint Unified</td>\n",
       "      <td>Loma Rica Elementary</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>KN</td>\n",
       "      <td>ALL</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210717</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>58</td>\n",
       "      <td>72736</td>\n",
       "      <td>6056741</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Marysville Joint Unified</td>\n",
       "      <td>Olivehurst Elementary</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>04</td>\n",
       "      <td>ALL</td>\n",
       "      <td>46</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>66</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>2</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210718</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>58</td>\n",
       "      <td>72736</td>\n",
       "      <td>6056782</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Marysville Joint Unified</td>\n",
       "      <td>Yuba Feather Elementary</td>\n",
       "      <td>N</td>\n",
       "      <td>S</td>\n",
       "      <td>03</td>\n",
       "      <td>ALL</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210719</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>58</td>\n",
       "      <td>72751</td>\n",
       "      <td>6118806</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland</td>\n",
       "      <td>Wheatland Charter Academy</td>\n",
       "      <td>Y</td>\n",
       "      <td>S</td>\n",
       "      <td>02</td>\n",
       "      <td>ALL</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210720</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>58</td>\n",
       "      <td>72751</td>\n",
       "      <td>6118806</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland</td>\n",
       "      <td>Wheatland Charter Academy</td>\n",
       "      <td>Y</td>\n",
       "      <td>S</td>\n",
       "      <td>KN</td>\n",
       "      <td>ALL</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1283052 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       AcademicYear CountyCode DistrictCode SchoolCode CountyName  \\\n",
       "0           2022-23        NaN          NaN        NaN        NaN   \n",
       "1           2022-23        NaN          NaN        NaN        NaN   \n",
       "2           2022-23        NaN          NaN        NaN        NaN   \n",
       "3           2022-23        NaN          NaN        NaN        NaN   \n",
       "4           2022-23        NaN          NaN        NaN        NaN   \n",
       "...             ...        ...          ...        ...        ...   \n",
       "210716      2017-18         58        72736    6056725       Yuba   \n",
       "210717      2017-18         58        72736    6056741       Yuba   \n",
       "210718      2017-18         58        72736    6056782       Yuba   \n",
       "210719      2017-18         58        72751    6118806       Yuba   \n",
       "210720      2017-18         58        72751    6118806       Yuba   \n",
       "\n",
       "                    DistrictName                 SchoolName Charter AggLevel  \\\n",
       "0                            NaN                        NaN     NaN        T   \n",
       "1                            NaN                        NaN     NaN        T   \n",
       "2                            NaN                        NaN     NaN        T   \n",
       "3                            NaN                        NaN     NaN        T   \n",
       "4                            NaN                        NaN     NaN        T   \n",
       "...                          ...                        ...     ...      ...   \n",
       "210716  Marysville Joint Unified       Loma Rica Elementary       N        S   \n",
       "210717  Marysville Joint Unified      Olivehurst Elementary       N        S   \n",
       "210718  Marysville Joint Unified    Yuba Feather Elementary       N        S   \n",
       "210719                 Wheatland  Wheatland Charter Academy       Y        S   \n",
       "210720                 Wheatland  Wheatland Charter Academy       Y        S   \n",
       "\n",
       "       Grade Gender      EO   IFEP     EL   RFEP  TBD TotalEnrollment     AR  \\\n",
       "0         01      F  133992  11609  50556   2560  460          199177      0   \n",
       "1         02      F  132237  14066  47940   5890  302          200435      0   \n",
       "2         03      F  132417  15930  49164   7971  268          205750  11151   \n",
       "3         04      F  130842  14813  46817  15486  254          208212  24242   \n",
       "4         05      F  128623   8807  46665  26829  211          211135  19569   \n",
       "...      ...    ...     ...    ...    ...    ...  ...             ...    ...   \n",
       "210716    KN    ALL      12      0      1      0    0              13      0   \n",
       "210717    04    ALL      46      0     18      2    0              66     11   \n",
       "210718    03    ALL      19      0      1      0    0              20      0   \n",
       "210719    02    ALL      22      0      2      1    0              25      0   \n",
       "210720    KN    ALL      24      0      1      0    0              25      0   \n",
       "\n",
       "       LTEL   EL4+  EL03Y  EL45Y  EL6+Y Total-EE  \n",
       "0         0      3  50553      1      2    53116  \n",
       "1         0    212  47728    212      0    53830  \n",
       "2         0   1332  36681  12480      3    57135  \n",
       "3         0  17321   5254  41262    301    62303  \n",
       "4         0  22613   4483  31850  10332    73494  \n",
       "...     ...    ...    ...    ...    ...      ...  \n",
       "210716    0      0      1      0      0        1  \n",
       "210717    0      7      0     16      2       20  \n",
       "210718    0      0      1      0      0        1  \n",
       "210719    0      0      2      0      0        3  \n",
       "210720    0      0      1      0      0        1  \n",
       "\n",
       "[1283052 rows x 24 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_enrollment_el_df = pd.concat([enrollment_el_2023_df, enrollment_el_2022_df, enrollment_el_2021_df, enrollment_el_2020_df, enrollment_el_2019_df, enrollment_el_2018_df])\n",
    "final_enrollment_el_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_enrollment_el_df.loc[final_enrollment_el_df['AggLevel'] == 'T', 'CountyCode'] = '00'\n",
    "final_enrollment_el_df.loc[final_enrollment_el_df['AggLevel'] == 'T', 'DistrictCode'] = '00000'\n",
    "final_enrollment_el_df.loc[final_enrollment_el_df['AggLevel'] == 'T', 'SchoolCode'] = '0000000'\n",
    "\n",
    "final_enrollment_el_df['Charter'] = final_enrollment_el_df['Charter'].fillna('NV').replace('', 'NV')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_enrollment_el_df.loc[final_enrollment_el_df['AggLevel'] == 'D', 'SchoolCode'] = '0000000'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>AcademicYear</th>\n",
       "      <th>CountyCode</th>\n",
       "      <th>DistrictCode</th>\n",
       "      <th>SchoolCode</th>\n",
       "      <th>CountyName</th>\n",
       "      <th>DistrictName</th>\n",
       "      <th>SchoolName</th>\n",
       "      <th>Charter</th>\n",
       "      <th>AggLevel</th>\n",
       "      <th>Grade</th>\n",
       "      <th>Gender</th>\n",
       "      <th>EO</th>\n",
       "      <th>IFEP</th>\n",
       "      <th>EL</th>\n",
       "      <th>RFEP</th>\n",
       "      <th>TBD</th>\n",
       "      <th>TotalEnrollment</th>\n",
       "      <th>AR</th>\n",
       "      <th>LTEL</th>\n",
       "      <th>EL4+</th>\n",
       "      <th>EL03Y</th>\n",
       "      <th>EL45Y</th>\n",
       "      <th>EL6+Y</th>\n",
       "      <th>Total-EE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2786</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>01</td>\n",
       "      <td>10017</td>\n",
       "      <td>0000000</td>\n",
       "      <td>Alameda</td>\n",
       "      <td>Alameda County Office of Education</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NV</td>\n",
       "      <td>D</td>\n",
       "      <td>01</td>\n",
       "      <td>F</td>\n",
       "      <td>106</td>\n",
       "      <td>28</td>\n",
       "      <td>65</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>206</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>65</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2787</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>01</td>\n",
       "      <td>10017</td>\n",
       "      <td>0000000</td>\n",
       "      <td>Alameda</td>\n",
       "      <td>Alameda County Office of Education</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NV</td>\n",
       "      <td>D</td>\n",
       "      <td>04</td>\n",
       "      <td>F</td>\n",
       "      <td>90</td>\n",
       "      <td>23</td>\n",
       "      <td>49</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>183</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>7</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2788</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>01</td>\n",
       "      <td>10017</td>\n",
       "      <td>0000000</td>\n",
       "      <td>Alameda</td>\n",
       "      <td>Alameda County Office of Education</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NV</td>\n",
       "      <td>D</td>\n",
       "      <td>07</td>\n",
       "      <td>F</td>\n",
       "      <td>63</td>\n",
       "      <td>7</td>\n",
       "      <td>28</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>122</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>24</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2789</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>01</td>\n",
       "      <td>10017</td>\n",
       "      <td>0000000</td>\n",
       "      <td>Alameda</td>\n",
       "      <td>Alameda County Office of Education</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NV</td>\n",
       "      <td>D</td>\n",
       "      <td>11</td>\n",
       "      <td>M</td>\n",
       "      <td>37</td>\n",
       "      <td>6</td>\n",
       "      <td>25</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>84</td>\n",
       "      <td>2</td>\n",
       "      <td>17</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>20</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2790</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>01</td>\n",
       "      <td>31609</td>\n",
       "      <td>0000000</td>\n",
       "      <td>Alameda</td>\n",
       "      <td>California School for the Blind (State Special...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NV</td>\n",
       "      <td>D</td>\n",
       "      <td>08</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34407</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>58</td>\n",
       "      <td>10587</td>\n",
       "      <td>0000000</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Yuba County Office of Education</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NV</td>\n",
       "      <td>D</td>\n",
       "      <td>11</td>\n",
       "      <td>ALL</td>\n",
       "      <td>76</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>92</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34408</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>58</td>\n",
       "      <td>72728</td>\n",
       "      <td>0000000</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Camptonville Elementary</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NV</td>\n",
       "      <td>D</td>\n",
       "      <td>10</td>\n",
       "      <td>ALL</td>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>41</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34409</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>58</td>\n",
       "      <td>72736</td>\n",
       "      <td>0000000</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Marysville Joint Unified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NV</td>\n",
       "      <td>D</td>\n",
       "      <td>05</td>\n",
       "      <td>ALL</td>\n",
       "      <td>602</td>\n",
       "      <td>3</td>\n",
       "      <td>186</td>\n",
       "      <td>62</td>\n",
       "      <td>2</td>\n",
       "      <td>855</td>\n",
       "      <td>66</td>\n",
       "      <td>0</td>\n",
       "      <td>111</td>\n",
       "      <td>9</td>\n",
       "      <td>135</td>\n",
       "      <td>42</td>\n",
       "      <td>248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34410</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>58</td>\n",
       "      <td>72744</td>\n",
       "      <td>0000000</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Plumas Lake Elementary</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NV</td>\n",
       "      <td>D</td>\n",
       "      <td>KN</td>\n",
       "      <td>ALL</td>\n",
       "      <td>165</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>180</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34411</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>58</td>\n",
       "      <td>72751</td>\n",
       "      <td>0000000</td>\n",
       "      <td>Yuba</td>\n",
       "      <td>Wheatland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NV</td>\n",
       "      <td>D</td>\n",
       "      <td>01</td>\n",
       "      <td>ALL</td>\n",
       "      <td>164</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>175</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>193353 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      AcademicYear CountyCode DistrictCode SchoolCode CountyName  \\\n",
       "2786       2022-23         01        10017    0000000    Alameda   \n",
       "2787       2022-23         01        10017    0000000    Alameda   \n",
       "2788       2022-23         01        10017    0000000    Alameda   \n",
       "2789       2022-23         01        10017    0000000    Alameda   \n",
       "2790       2022-23         01        31609    0000000    Alameda   \n",
       "...            ...        ...          ...        ...        ...   \n",
       "34407      2017-18         58        10587    0000000       Yuba   \n",
       "34408      2017-18         58        72728    0000000       Yuba   \n",
       "34409      2017-18         58        72736    0000000       Yuba   \n",
       "34410      2017-18         58        72744    0000000       Yuba   \n",
       "34411      2017-18         58        72751    0000000       Yuba   \n",
       "\n",
       "                                            DistrictName SchoolName Charter  \\\n",
       "2786                  Alameda County Office of Education        NaN      NV   \n",
       "2787                  Alameda County Office of Education        NaN      NV   \n",
       "2788                  Alameda County Office of Education        NaN      NV   \n",
       "2789                  Alameda County Office of Education        NaN      NV   \n",
       "2790   California School for the Blind (State Special...        NaN      NV   \n",
       "...                                                  ...        ...     ...   \n",
       "34407                    Yuba County Office of Education        NaN      NV   \n",
       "34408                            Camptonville Elementary        NaN      NV   \n",
       "34409                           Marysville Joint Unified        NaN      NV   \n",
       "34410                             Plumas Lake Elementary        NaN      NV   \n",
       "34411                                          Wheatland        NaN      NV   \n",
       "\n",
       "      AggLevel Grade Gender   EO IFEP   EL RFEP TBD TotalEnrollment  AR LTEL  \\\n",
       "2786         D    01      F  106   28   65    7   0             206   0    0   \n",
       "2787         D    04      F   90   23   49   21   0             183  27    0   \n",
       "2788         D    07      F   63    7   28   24   0             122   3   15   \n",
       "2789         D    11      M   37    6   25   15   0              84   2   17   \n",
       "2790         D    08      M    1    0    0    0   0               1   0    0   \n",
       "...        ...   ...    ...  ...  ...  ...  ...  ..             ...  ..  ...   \n",
       "34407        D    11    ALL   76    0    9    7   0              92   0    9   \n",
       "34408        D    10    ALL   36    0    0    5   0              41   0    0   \n",
       "34409        D    05    ALL  602    3  186   62   2             855  66    0   \n",
       "34410        D    KN    ALL  165    0   15    0   0             180   0    0   \n",
       "34411        D    01    ALL  164    0   11    0   0             175   0    0   \n",
       "\n",
       "      EL4+ EL03Y EL45Y EL6+Y Total-EE  \n",
       "2786     0    65     0     0       72  \n",
       "2787    15     7    42     0       70  \n",
       "2788     9     1     3    24       52  \n",
       "2789     3     3     2    20       40  \n",
       "2790     0     0     0     0        0  \n",
       "...    ...   ...   ...   ...      ...  \n",
       "34407    0     0     0     9       16  \n",
       "34408    0     0     0     0        5  \n",
       "34409  111     9   135    42      248  \n",
       "34410    0    15     0     0       15  \n",
       "34411    0    11     0     0       11  \n",
       "\n",
       "[193353 rows x 24 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_enrollment_el_df[final_enrollment_el_df['AggLevel'] == 'D']\n",
    "\n",
    "# D = Local educational agency totals (includes districts and direct funded charter schools)\n",
    "# O = County totals\n",
    "# S = School totals\n",
    "# T = State totals"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['NV', 'Y', 'N'], dtype=object)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_enrollment_el_df.Charter.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>AcademicYear</th>\n",
       "      <th>CountyCode</th>\n",
       "      <th>DistrictCode</th>\n",
       "      <th>SchoolCode</th>\n",
       "      <th>AggLevel</th>\n",
       "      <th>Gender</th>\n",
       "      <th>EO</th>\n",
       "      <th>IFEP</th>\n",
       "      <th>EL</th>\n",
       "      <th>RFEP</th>\n",
       "      <th>TBD</th>\n",
       "      <th>TotalEnrollment</th>\n",
       "      <th>AR</th>\n",
       "      <th>LTEL</th>\n",
       "      <th>EL4+</th>\n",
       "      <th>EL03Y</th>\n",
       "      <th>EL45Y</th>\n",
       "      <th>EL6+Y</th>\n",
       "      <th>Total-EE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>00</td>\n",
       "      <td>00000</td>\n",
       "      <td>0000000</td>\n",
       "      <td>T</td>\n",
       "      <td>ALL</td>\n",
       "      <td>3569666</td>\n",
       "      <td>261767</td>\n",
       "      <td>1271150</td>\n",
       "      <td>1104495</td>\n",
       "      <td>13335</td>\n",
       "      <td>6220413</td>\n",
       "      <td>144146</td>\n",
       "      <td>218135</td>\n",
       "      <td>250479</td>\n",
       "      <td>658390</td>\n",
       "      <td>234842</td>\n",
       "      <td>377918</td>\n",
       "      <td>2375645</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>00</td>\n",
       "      <td>00000</td>\n",
       "      <td>0000000</td>\n",
       "      <td>T</td>\n",
       "      <td>F</td>\n",
       "      <td>1728140</td>\n",
       "      <td>140174</td>\n",
       "      <td>580771</td>\n",
       "      <td>568942</td>\n",
       "      <td>6414</td>\n",
       "      <td>3024441</td>\n",
       "      <td>62609</td>\n",
       "      <td>87882</td>\n",
       "      <td>114543</td>\n",
       "      <td>315737</td>\n",
       "      <td>107805</td>\n",
       "      <td>157229</td>\n",
       "      <td>1149713</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>00</td>\n",
       "      <td>00000</td>\n",
       "      <td>0000000</td>\n",
       "      <td>T</td>\n",
       "      <td>M</td>\n",
       "      <td>1841526</td>\n",
       "      <td>121593</td>\n",
       "      <td>690379</td>\n",
       "      <td>535553</td>\n",
       "      <td>6921</td>\n",
       "      <td>3195972</td>\n",
       "      <td>81537</td>\n",
       "      <td>130253</td>\n",
       "      <td>135936</td>\n",
       "      <td>342653</td>\n",
       "      <td>127037</td>\n",
       "      <td>220689</td>\n",
       "      <td>1225932</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>01</td>\n",
       "      <td>10017</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>ALL</td>\n",
       "      <td>1506</td>\n",
       "      <td>121</td>\n",
       "      <td>870</td>\n",
       "      <td>489</td>\n",
       "      <td>119</td>\n",
       "      <td>3105</td>\n",
       "      <td>136</td>\n",
       "      <td>159</td>\n",
       "      <td>143</td>\n",
       "      <td>432</td>\n",
       "      <td>188</td>\n",
       "      <td>250</td>\n",
       "      <td>1359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>01</td>\n",
       "      <td>10017</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>F</td>\n",
       "      <td>718</td>\n",
       "      <td>69</td>\n",
       "      <td>431</td>\n",
       "      <td>283</td>\n",
       "      <td>61</td>\n",
       "      <td>1562</td>\n",
       "      <td>64</td>\n",
       "      <td>77</td>\n",
       "      <td>75</td>\n",
       "      <td>215</td>\n",
       "      <td>98</td>\n",
       "      <td>118</td>\n",
       "      <td>714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212565</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>0133751</td>\n",
       "      <td>S</td>\n",
       "      <td>M</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212566</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>5838305</td>\n",
       "      <td>S</td>\n",
       "      <td>ALL</td>\n",
       "      <td>850</td>\n",
       "      <td>28</td>\n",
       "      <td>33</td>\n",
       "      <td>136</td>\n",
       "      <td>1</td>\n",
       "      <td>1048</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>29</td>\n",
       "      <td>169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212567</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>5838305</td>\n",
       "      <td>S</td>\n",
       "      <td>F</td>\n",
       "      <td>379</td>\n",
       "      <td>18</td>\n",
       "      <td>14</td>\n",
       "      <td>66</td>\n",
       "      <td>0</td>\n",
       "      <td>477</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212568</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>5838305</td>\n",
       "      <td>S</td>\n",
       "      <td>M</td>\n",
       "      <td>470</td>\n",
       "      <td>10</td>\n",
       "      <td>19</td>\n",
       "      <td>70</td>\n",
       "      <td>1</td>\n",
       "      <td>570</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212569</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>5838305</td>\n",
       "      <td>S</td>\n",
       "      <td>X</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>212570 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       AcademicYear CountyCode DistrictCode SchoolCode AggLevel Gender  \\\n",
       "0           2017-18         00        00000    0000000        T    ALL   \n",
       "1           2017-18         00        00000    0000000        T      F   \n",
       "2           2017-18         00        00000    0000000        T      M   \n",
       "3           2017-18         01        10017    0000000        D    ALL   \n",
       "4           2017-18         01        10017    0000000        D      F   \n",
       "...             ...        ...          ...        ...      ...    ...   \n",
       "212565      2022-23         58        72769    0133751        S      M   \n",
       "212566      2022-23         58        72769    5838305        S    ALL   \n",
       "212567      2022-23         58        72769    5838305        S      F   \n",
       "212568      2022-23         58        72769    5838305        S      M   \n",
       "212569      2022-23         58        72769    5838305        S      X   \n",
       "\n",
       "             EO    IFEP       EL     RFEP    TBD  TotalEnrollment      AR  \\\n",
       "0       3569666  261767  1271150  1104495  13335          6220413  144146   \n",
       "1       1728140  140174   580771   568942   6414          3024441   62609   \n",
       "2       1841526  121593   690379   535553   6921          3195972   81537   \n",
       "3          1506     121      870      489    119             3105     136   \n",
       "4           718      69      431      283     61             1562      64   \n",
       "...         ...     ...      ...      ...    ...              ...     ...   \n",
       "212565       17       0        0        5      0               22       0   \n",
       "212566      850      28       33      136      1             1048       0   \n",
       "212567      379      18       14       66      0              477       0   \n",
       "212568      470      10       19       70      1              570       0   \n",
       "212569        1       0        0        0      0                1       0   \n",
       "\n",
       "          LTEL    EL4+   EL03Y   EL45Y   EL6+Y  Total-EE  \n",
       "0       218135  250479  658390  234842  377918   2375645  \n",
       "1        87882  114543  315737  107805  157229   1149713  \n",
       "2       130253  135936  342653  127037  220689   1225932  \n",
       "3          159     143     432     188     250      1359  \n",
       "4           77      75     215      98     118       714  \n",
       "...        ...     ...     ...     ...     ...       ...  \n",
       "212565       0       0       0       0       0         5  \n",
       "212566      22       7       4       0      29       169  \n",
       "212567       8       4       2       0      12        80  \n",
       "212568      14       3       2       0      17        89  \n",
       "212569       0       0       0       0       0         0  \n",
       "\n",
       "[212570 rows x 19 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Columns to convert to integer\n",
    "convert_columns = [\n",
    "    'EO', 'IFEP', 'EL', 'RFEP', 'TBD', 'TotalEnrollment', 'AR', 'LTEL',\n",
    "    'EL4+', 'EL03Y', 'EL45Y', 'EL6+Y', 'Total-EE'\n",
    "]\n",
    "\n",
    "# Convert specified columns from strings to integers (handling missing or malformed data)\n",
    "for column in convert_columns:\n",
    "    final_enrollment_el_df[column] = pd.to_numeric(final_enrollment_el_df[column], errors='coerce').fillna(0).astype(int)\n",
    "\n",
    "# Group by columns\n",
    "group_columns = [\n",
    "    'AcademicYear', 'CountyCode', 'DistrictCode', 'SchoolCode',  'AggLevel', 'Gender'\n",
    "]\n",
    "\n",
    "# Group the data and sum the specified columns\n",
    "final_enrollment_el_df = final_enrollment_el_df.groupby(group_columns)[convert_columns].sum().reset_index()\n",
    "final_enrollment_el_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Step 1: Create a set of unique school codes from dataframe2 for efficient lookup\n",
    "wcc_schools_list = set(wcc_schools_df['School Code'])\n",
    "\n",
    "# Step 2: Use the .isin() method to check if each school code in dataframe1 is in the set of schools from dataframe2\n",
    "final_enrollment_el_df['is_wcc_entity'] = final_enrollment_el_df['SchoolCode'].isin(wcc_schools_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Existing conditions for \"Aggregate Level\" and \"is_wcc_entity\"\n",
    "condition1 = final_enrollment_el_df['AggLevel'].isin(['T', 'D'])\n",
    "condition2 = final_enrollment_el_df['is_wcc_entity']\n",
    "\n",
    "# Combine all conditions using \"OR\" (|) for the initial conditions\n",
    "combined_condition = (condition1 | condition2) \n",
    "\n",
    "# Filter dataframe1 using the combined condition\n",
    "final_filtered_enrollment_el_df = final_enrollment_el_df[combined_condition]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>AcademicYear</th>\n",
       "      <th>CountyCode</th>\n",
       "      <th>DistrictCode</th>\n",
       "      <th>SchoolCode</th>\n",
       "      <th>AggLevel</th>\n",
       "      <th>Gender</th>\n",
       "      <th>EO</th>\n",
       "      <th>IFEP</th>\n",
       "      <th>EL</th>\n",
       "      <th>RFEP</th>\n",
       "      <th>TBD</th>\n",
       "      <th>TotalEnrollment</th>\n",
       "      <th>AR</th>\n",
       "      <th>LTEL</th>\n",
       "      <th>EL4+</th>\n",
       "      <th>EL03Y</th>\n",
       "      <th>EL45Y</th>\n",
       "      <th>EL6+Y</th>\n",
       "      <th>Total-EE</th>\n",
       "      <th>is_wcc_entity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>00</td>\n",
       "      <td>00000</td>\n",
       "      <td>0000000</td>\n",
       "      <td>T</td>\n",
       "      <td>ALL</td>\n",
       "      <td>3569666</td>\n",
       "      <td>261767</td>\n",
       "      <td>1271150</td>\n",
       "      <td>1104495</td>\n",
       "      <td>13335</td>\n",
       "      <td>6220413</td>\n",
       "      <td>144146</td>\n",
       "      <td>218135</td>\n",
       "      <td>250479</td>\n",
       "      <td>658390</td>\n",
       "      <td>234842</td>\n",
       "      <td>377918</td>\n",
       "      <td>2375645</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>00</td>\n",
       "      <td>00000</td>\n",
       "      <td>0000000</td>\n",
       "      <td>T</td>\n",
       "      <td>F</td>\n",
       "      <td>1728140</td>\n",
       "      <td>140174</td>\n",
       "      <td>580771</td>\n",
       "      <td>568942</td>\n",
       "      <td>6414</td>\n",
       "      <td>3024441</td>\n",
       "      <td>62609</td>\n",
       "      <td>87882</td>\n",
       "      <td>114543</td>\n",
       "      <td>315737</td>\n",
       "      <td>107805</td>\n",
       "      <td>157229</td>\n",
       "      <td>1149713</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>00</td>\n",
       "      <td>00000</td>\n",
       "      <td>0000000</td>\n",
       "      <td>T</td>\n",
       "      <td>M</td>\n",
       "      <td>1841526</td>\n",
       "      <td>121593</td>\n",
       "      <td>690379</td>\n",
       "      <td>535553</td>\n",
       "      <td>6921</td>\n",
       "      <td>3195972</td>\n",
       "      <td>81537</td>\n",
       "      <td>130253</td>\n",
       "      <td>135936</td>\n",
       "      <td>342653</td>\n",
       "      <td>127037</td>\n",
       "      <td>220689</td>\n",
       "      <td>1225932</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>01</td>\n",
       "      <td>10017</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>ALL</td>\n",
       "      <td>1506</td>\n",
       "      <td>121</td>\n",
       "      <td>870</td>\n",
       "      <td>489</td>\n",
       "      <td>119</td>\n",
       "      <td>3105</td>\n",
       "      <td>136</td>\n",
       "      <td>159</td>\n",
       "      <td>143</td>\n",
       "      <td>432</td>\n",
       "      <td>188</td>\n",
       "      <td>250</td>\n",
       "      <td>1359</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>01</td>\n",
       "      <td>10017</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>F</td>\n",
       "      <td>718</td>\n",
       "      <td>69</td>\n",
       "      <td>431</td>\n",
       "      <td>283</td>\n",
       "      <td>61</td>\n",
       "      <td>1562</td>\n",
       "      <td>64</td>\n",
       "      <td>77</td>\n",
       "      <td>75</td>\n",
       "      <td>215</td>\n",
       "      <td>98</td>\n",
       "      <td>118</td>\n",
       "      <td>714</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212543</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72751</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>M</td>\n",
       "      <td>647</td>\n",
       "      <td>4</td>\n",
       "      <td>44</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>715</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>12</td>\n",
       "      <td>23</td>\n",
       "      <td>8</td>\n",
       "      <td>13</td>\n",
       "      <td>64</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212556</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>ALL</td>\n",
       "      <td>885</td>\n",
       "      <td>28</td>\n",
       "      <td>36</td>\n",
       "      <td>146</td>\n",
       "      <td>1</td>\n",
       "      <td>1096</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>182</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212557</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>F</td>\n",
       "      <td>395</td>\n",
       "      <td>18</td>\n",
       "      <td>15</td>\n",
       "      <td>71</td>\n",
       "      <td>0</td>\n",
       "      <td>499</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>86</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212558</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>M</td>\n",
       "      <td>489</td>\n",
       "      <td>10</td>\n",
       "      <td>21</td>\n",
       "      <td>75</td>\n",
       "      <td>1</td>\n",
       "      <td>596</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>96</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212559</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>X</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21102 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       AcademicYear CountyCode DistrictCode SchoolCode AggLevel Gender  \\\n",
       "0           2017-18         00        00000    0000000        T    ALL   \n",
       "1           2017-18         00        00000    0000000        T      F   \n",
       "2           2017-18         00        00000    0000000        T      M   \n",
       "3           2017-18         01        10017    0000000        D    ALL   \n",
       "4           2017-18         01        10017    0000000        D      F   \n",
       "...             ...        ...          ...        ...      ...    ...   \n",
       "212543      2022-23         58        72751    0000000        D      M   \n",
       "212556      2022-23         58        72769    0000000        D    ALL   \n",
       "212557      2022-23         58        72769    0000000        D      F   \n",
       "212558      2022-23         58        72769    0000000        D      M   \n",
       "212559      2022-23         58        72769    0000000        D      X   \n",
       "\n",
       "             EO    IFEP       EL     RFEP    TBD  TotalEnrollment      AR  \\\n",
       "0       3569666  261767  1271150  1104495  13335          6220413  144146   \n",
       "1       1728140  140174   580771   568942   6414          3024441   62609   \n",
       "2       1841526  121593   690379   535553   6921          3195972   81537   \n",
       "3          1506     121      870      489    119             3105     136   \n",
       "4           718      69      431      283     61             1562      64   \n",
       "...         ...     ...      ...      ...    ...              ...     ...   \n",
       "212543      647       4       44       20      0              715       3   \n",
       "212556      885      28       36      146      1             1096       0   \n",
       "212557      395      18       15       71      0              499       0   \n",
       "212558      489      10       21       75      1              596       0   \n",
       "212559        1       0        0        0      0                1       0   \n",
       "\n",
       "          LTEL    EL4+   EL03Y   EL45Y   EL6+Y  Total-EE  is_wcc_entity  \n",
       "0       218135  250479  658390  234842  377918   2375645          False  \n",
       "1        87882  114543  315737  107805  157229   1149713          False  \n",
       "2       130253  135936  342653  127037  220689   1225932          False  \n",
       "3          159     143     432     188     250      1359          False  \n",
       "4           77      75     215      98     118       714          False  \n",
       "...        ...     ...     ...     ...     ...       ...            ...  \n",
       "212543       6      12      23       8      13        64          False  \n",
       "212556      24       8       4       0      32       182          False  \n",
       "212557       9       4       2       0      13        86          False  \n",
       "212558      15       4       2       0      19        96          False  \n",
       "212559       0       0       0       0       0         0          False  \n",
       "\n",
       "[21102 rows x 20 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_filtered_enrollment_el_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/6t/n3rqwc2x06ngf2r8521g1nmc0000gn/T/ipykernel_20635/1372549556.py:10: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  final_filtered_enrollment_el_df['Gender'] = final_filtered_enrollment_el_df['Gender'].replace(replacement_dict)\n"
     ]
    },
    {
     "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>AcademicYear</th>\n",
       "      <th>CountyCode</th>\n",
       "      <th>DistrictCode</th>\n",
       "      <th>SchoolCode</th>\n",
       "      <th>AggLevel</th>\n",
       "      <th>Gender</th>\n",
       "      <th>EO</th>\n",
       "      <th>IFEP</th>\n",
       "      <th>EL</th>\n",
       "      <th>RFEP</th>\n",
       "      <th>TBD</th>\n",
       "      <th>TotalEnrollment</th>\n",
       "      <th>AR</th>\n",
       "      <th>LTEL</th>\n",
       "      <th>EL4+</th>\n",
       "      <th>EL03Y</th>\n",
       "      <th>EL45Y</th>\n",
       "      <th>EL6+Y</th>\n",
       "      <th>Total-EE</th>\n",
       "      <th>is_wcc_entity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>00</td>\n",
       "      <td>00000</td>\n",
       "      <td>0000000</td>\n",
       "      <td>T</td>\n",
       "      <td>TA</td>\n",
       "      <td>3569666</td>\n",
       "      <td>261767</td>\n",
       "      <td>1271150</td>\n",
       "      <td>1104495</td>\n",
       "      <td>13335</td>\n",
       "      <td>6220413</td>\n",
       "      <td>144146</td>\n",
       "      <td>218135</td>\n",
       "      <td>250479</td>\n",
       "      <td>658390</td>\n",
       "      <td>234842</td>\n",
       "      <td>377918</td>\n",
       "      <td>2375645</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>00</td>\n",
       "      <td>00000</td>\n",
       "      <td>0000000</td>\n",
       "      <td>T</td>\n",
       "      <td>GF</td>\n",
       "      <td>1728140</td>\n",
       "      <td>140174</td>\n",
       "      <td>580771</td>\n",
       "      <td>568942</td>\n",
       "      <td>6414</td>\n",
       "      <td>3024441</td>\n",
       "      <td>62609</td>\n",
       "      <td>87882</td>\n",
       "      <td>114543</td>\n",
       "      <td>315737</td>\n",
       "      <td>107805</td>\n",
       "      <td>157229</td>\n",
       "      <td>1149713</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>00</td>\n",
       "      <td>00000</td>\n",
       "      <td>0000000</td>\n",
       "      <td>T</td>\n",
       "      <td>GM</td>\n",
       "      <td>1841526</td>\n",
       "      <td>121593</td>\n",
       "      <td>690379</td>\n",
       "      <td>535553</td>\n",
       "      <td>6921</td>\n",
       "      <td>3195972</td>\n",
       "      <td>81537</td>\n",
       "      <td>130253</td>\n",
       "      <td>135936</td>\n",
       "      <td>342653</td>\n",
       "      <td>127037</td>\n",
       "      <td>220689</td>\n",
       "      <td>1225932</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>01</td>\n",
       "      <td>10017</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>TA</td>\n",
       "      <td>1506</td>\n",
       "      <td>121</td>\n",
       "      <td>870</td>\n",
       "      <td>489</td>\n",
       "      <td>119</td>\n",
       "      <td>3105</td>\n",
       "      <td>136</td>\n",
       "      <td>159</td>\n",
       "      <td>143</td>\n",
       "      <td>432</td>\n",
       "      <td>188</td>\n",
       "      <td>250</td>\n",
       "      <td>1359</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>01</td>\n",
       "      <td>10017</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>GF</td>\n",
       "      <td>718</td>\n",
       "      <td>69</td>\n",
       "      <td>431</td>\n",
       "      <td>283</td>\n",
       "      <td>61</td>\n",
       "      <td>1562</td>\n",
       "      <td>64</td>\n",
       "      <td>77</td>\n",
       "      <td>75</td>\n",
       "      <td>215</td>\n",
       "      <td>98</td>\n",
       "      <td>118</td>\n",
       "      <td>714</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212543</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72751</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>GM</td>\n",
       "      <td>647</td>\n",
       "      <td>4</td>\n",
       "      <td>44</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>715</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>12</td>\n",
       "      <td>23</td>\n",
       "      <td>8</td>\n",
       "      <td>13</td>\n",
       "      <td>64</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212556</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>TA</td>\n",
       "      <td>885</td>\n",
       "      <td>28</td>\n",
       "      <td>36</td>\n",
       "      <td>146</td>\n",
       "      <td>1</td>\n",
       "      <td>1096</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>182</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212557</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>GF</td>\n",
       "      <td>395</td>\n",
       "      <td>18</td>\n",
       "      <td>15</td>\n",
       "      <td>71</td>\n",
       "      <td>0</td>\n",
       "      <td>499</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>86</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212558</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>GM</td>\n",
       "      <td>489</td>\n",
       "      <td>10</td>\n",
       "      <td>21</td>\n",
       "      <td>75</td>\n",
       "      <td>1</td>\n",
       "      <td>596</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>96</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212559</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>GX</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21102 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       AcademicYear CountyCode DistrictCode SchoolCode AggLevel Gender  \\\n",
       "0           2017-18         00        00000    0000000        T     TA   \n",
       "1           2017-18         00        00000    0000000        T     GF   \n",
       "2           2017-18         00        00000    0000000        T     GM   \n",
       "3           2017-18         01        10017    0000000        D     TA   \n",
       "4           2017-18         01        10017    0000000        D     GF   \n",
       "...             ...        ...          ...        ...      ...    ...   \n",
       "212543      2022-23         58        72751    0000000        D     GM   \n",
       "212556      2022-23         58        72769    0000000        D     TA   \n",
       "212557      2022-23         58        72769    0000000        D     GF   \n",
       "212558      2022-23         58        72769    0000000        D     GM   \n",
       "212559      2022-23         58        72769    0000000        D     GX   \n",
       "\n",
       "             EO    IFEP       EL     RFEP    TBD  TotalEnrollment      AR  \\\n",
       "0       3569666  261767  1271150  1104495  13335          6220413  144146   \n",
       "1       1728140  140174   580771   568942   6414          3024441   62609   \n",
       "2       1841526  121593   690379   535553   6921          3195972   81537   \n",
       "3          1506     121      870      489    119             3105     136   \n",
       "4           718      69      431      283     61             1562      64   \n",
       "...         ...     ...      ...      ...    ...              ...     ...   \n",
       "212543      647       4       44       20      0              715       3   \n",
       "212556      885      28       36      146      1             1096       0   \n",
       "212557      395      18       15       71      0              499       0   \n",
       "212558      489      10       21       75      1              596       0   \n",
       "212559        1       0        0        0      0                1       0   \n",
       "\n",
       "          LTEL    EL4+   EL03Y   EL45Y   EL6+Y  Total-EE  is_wcc_entity  \n",
       "0       218135  250479  658390  234842  377918   2375645          False  \n",
       "1        87882  114543  315737  107805  157229   1149713          False  \n",
       "2       130253  135936  342653  127037  220689   1225932          False  \n",
       "3          159     143     432     188     250      1359          False  \n",
       "4           77      75     215      98     118       714          False  \n",
       "...        ...     ...     ...     ...     ...       ...            ...  \n",
       "212543       6      12      23       8      13        64          False  \n",
       "212556      24       8       4       0      32       182          False  \n",
       "212557       9       4       2       0      13        86          False  \n",
       "212558      15       4       2       0      19        96          False  \n",
       "212559       0       0       0       0       0         0          False  \n",
       "\n",
       "[21102 rows x 20 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Define a dictionary with the mappings from old values to new values\n",
    "replacement_dict = {\n",
    "    'ALL': 'TA',\n",
    "    'F': 'GF',\n",
    "    'M': 'GM',\n",
    "    'X': 'GX'\n",
    "}\n",
    "\n",
    "# Replace the values in the 'Gender' column\n",
    "final_filtered_enrollment_el_df['Gender'] = final_filtered_enrollment_el_df['Gender'].replace(replacement_dict)\n",
    "final_filtered_enrollment_el_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>academic_year</th>\n",
       "      <th>county_code</th>\n",
       "      <th>district_code</th>\n",
       "      <th>school_code</th>\n",
       "      <th>aggregate_level</th>\n",
       "      <th>reporting_category</th>\n",
       "      <th>EO</th>\n",
       "      <th>IFEP</th>\n",
       "      <th>EL</th>\n",
       "      <th>RFEP</th>\n",
       "      <th>TBD</th>\n",
       "      <th>TotalEnrollment</th>\n",
       "      <th>AR</th>\n",
       "      <th>LTEL</th>\n",
       "      <th>EL4+</th>\n",
       "      <th>EL03Y</th>\n",
       "      <th>EL45Y</th>\n",
       "      <th>EL6+Y</th>\n",
       "      <th>Total-EE</th>\n",
       "      <th>is_wcc_entity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>00</td>\n",
       "      <td>00000</td>\n",
       "      <td>0000000</td>\n",
       "      <td>T</td>\n",
       "      <td>TA</td>\n",
       "      <td>3569666</td>\n",
       "      <td>261767</td>\n",
       "      <td>1271150</td>\n",
       "      <td>1104495</td>\n",
       "      <td>13335</td>\n",
       "      <td>6220413</td>\n",
       "      <td>144146</td>\n",
       "      <td>218135</td>\n",
       "      <td>250479</td>\n",
       "      <td>658390</td>\n",
       "      <td>234842</td>\n",
       "      <td>377918</td>\n",
       "      <td>2375645</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>00</td>\n",
       "      <td>00000</td>\n",
       "      <td>0000000</td>\n",
       "      <td>T</td>\n",
       "      <td>GF</td>\n",
       "      <td>1728140</td>\n",
       "      <td>140174</td>\n",
       "      <td>580771</td>\n",
       "      <td>568942</td>\n",
       "      <td>6414</td>\n",
       "      <td>3024441</td>\n",
       "      <td>62609</td>\n",
       "      <td>87882</td>\n",
       "      <td>114543</td>\n",
       "      <td>315737</td>\n",
       "      <td>107805</td>\n",
       "      <td>157229</td>\n",
       "      <td>1149713</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>00</td>\n",
       "      <td>00000</td>\n",
       "      <td>0000000</td>\n",
       "      <td>T</td>\n",
       "      <td>GM</td>\n",
       "      <td>1841526</td>\n",
       "      <td>121593</td>\n",
       "      <td>690379</td>\n",
       "      <td>535553</td>\n",
       "      <td>6921</td>\n",
       "      <td>3195972</td>\n",
       "      <td>81537</td>\n",
       "      <td>130253</td>\n",
       "      <td>135936</td>\n",
       "      <td>342653</td>\n",
       "      <td>127037</td>\n",
       "      <td>220689</td>\n",
       "      <td>1225932</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>01</td>\n",
       "      <td>10017</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>TA</td>\n",
       "      <td>1506</td>\n",
       "      <td>121</td>\n",
       "      <td>870</td>\n",
       "      <td>489</td>\n",
       "      <td>119</td>\n",
       "      <td>3105</td>\n",
       "      <td>136</td>\n",
       "      <td>159</td>\n",
       "      <td>143</td>\n",
       "      <td>432</td>\n",
       "      <td>188</td>\n",
       "      <td>250</td>\n",
       "      <td>1359</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>01</td>\n",
       "      <td>10017</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>GF</td>\n",
       "      <td>718</td>\n",
       "      <td>69</td>\n",
       "      <td>431</td>\n",
       "      <td>283</td>\n",
       "      <td>61</td>\n",
       "      <td>1562</td>\n",
       "      <td>64</td>\n",
       "      <td>77</td>\n",
       "      <td>75</td>\n",
       "      <td>215</td>\n",
       "      <td>98</td>\n",
       "      <td>118</td>\n",
       "      <td>714</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212543</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72751</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>GM</td>\n",
       "      <td>647</td>\n",
       "      <td>4</td>\n",
       "      <td>44</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>715</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>12</td>\n",
       "      <td>23</td>\n",
       "      <td>8</td>\n",
       "      <td>13</td>\n",
       "      <td>64</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212556</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>TA</td>\n",
       "      <td>885</td>\n",
       "      <td>28</td>\n",
       "      <td>36</td>\n",
       "      <td>146</td>\n",
       "      <td>1</td>\n",
       "      <td>1096</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>182</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212557</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>GF</td>\n",
       "      <td>395</td>\n",
       "      <td>18</td>\n",
       "      <td>15</td>\n",
       "      <td>71</td>\n",
       "      <td>0</td>\n",
       "      <td>499</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>86</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212558</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>GM</td>\n",
       "      <td>489</td>\n",
       "      <td>10</td>\n",
       "      <td>21</td>\n",
       "      <td>75</td>\n",
       "      <td>1</td>\n",
       "      <td>596</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>96</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212559</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>GX</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21102 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       academic_year county_code district_code school_code aggregate_level  \\\n",
       "0            2017-18          00         00000     0000000               T   \n",
       "1            2017-18          00         00000     0000000               T   \n",
       "2            2017-18          00         00000     0000000               T   \n",
       "3            2017-18          01         10017     0000000               D   \n",
       "4            2017-18          01         10017     0000000               D   \n",
       "...              ...         ...           ...         ...             ...   \n",
       "212543       2022-23          58         72751     0000000               D   \n",
       "212556       2022-23          58         72769     0000000               D   \n",
       "212557       2022-23          58         72769     0000000               D   \n",
       "212558       2022-23          58         72769     0000000               D   \n",
       "212559       2022-23          58         72769     0000000               D   \n",
       "\n",
       "       reporting_category       EO    IFEP       EL     RFEP    TBD  \\\n",
       "0                      TA  3569666  261767  1271150  1104495  13335   \n",
       "1                      GF  1728140  140174   580771   568942   6414   \n",
       "2                      GM  1841526  121593   690379   535553   6921   \n",
       "3                      TA     1506     121      870      489    119   \n",
       "4                      GF      718      69      431      283     61   \n",
       "...                   ...      ...     ...      ...      ...    ...   \n",
       "212543                 GM      647       4       44       20      0   \n",
       "212556                 TA      885      28       36      146      1   \n",
       "212557                 GF      395      18       15       71      0   \n",
       "212558                 GM      489      10       21       75      1   \n",
       "212559                 GX        1       0        0        0      0   \n",
       "\n",
       "        TotalEnrollment      AR    LTEL    EL4+   EL03Y   EL45Y   EL6+Y  \\\n",
       "0               6220413  144146  218135  250479  658390  234842  377918   \n",
       "1               3024441   62609   87882  114543  315737  107805  157229   \n",
       "2               3195972   81537  130253  135936  342653  127037  220689   \n",
       "3                  3105     136     159     143     432     188     250   \n",
       "4                  1562      64      77      75     215      98     118   \n",
       "...                 ...     ...     ...     ...     ...     ...     ...   \n",
       "212543              715       3       6      12      23       8      13   \n",
       "212556             1096       0      24       8       4       0      32   \n",
       "212557              499       0       9       4       2       0      13   \n",
       "212558              596       0      15       4       2       0      19   \n",
       "212559                1       0       0       0       0       0       0   \n",
       "\n",
       "        Total-EE  is_wcc_entity  \n",
       "0        2375645          False  \n",
       "1        1149713          False  \n",
       "2        1225932          False  \n",
       "3           1359          False  \n",
       "4            714          False  \n",
       "...          ...            ...  \n",
       "212543        64          False  \n",
       "212556       182          False  \n",
       "212557        86          False  \n",
       "212558        96          False  \n",
       "212559         0          False  \n",
       "\n",
       "[21102 rows x 20 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Dictionary mapping old column names to new ones\n",
    "rename_dict = {\n",
    "    'AcademicYear': 'academic_year',\n",
    "    'CountyCode': 'county_code',\n",
    "    'DistrictCode': 'district_code',\n",
    "    'SchoolCode': 'school_code',\n",
    "    'AggLevel': 'aggregate_level',\n",
    "    'Gender': 'reporting_category' \n",
    "}\n",
    "\n",
    "# Rename the columns using the dictionary\n",
    "final_filtered_enrollment_el_df = final_filtered_enrollment_el_df.rename(columns=rename_dict)\n",
    "final_filtered_enrollment_el_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>academic_year</th>\n",
       "      <th>county_code</th>\n",
       "      <th>district_code</th>\n",
       "      <th>school_code</th>\n",
       "      <th>aggregate_level</th>\n",
       "      <th>reporting_category</th>\n",
       "      <th>EO</th>\n",
       "      <th>IFEP</th>\n",
       "      <th>EL</th>\n",
       "      <th>RFEP</th>\n",
       "      <th>TBD</th>\n",
       "      <th>TotalEnrollment</th>\n",
       "      <th>AR</th>\n",
       "      <th>LTEL</th>\n",
       "      <th>EL4+</th>\n",
       "      <th>EL03Y</th>\n",
       "      <th>EL45Y</th>\n",
       "      <th>EL6+Y</th>\n",
       "      <th>Total-EE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>00</td>\n",
       "      <td>00000</td>\n",
       "      <td>0000000</td>\n",
       "      <td>T</td>\n",
       "      <td>TA</td>\n",
       "      <td>3569666</td>\n",
       "      <td>261767</td>\n",
       "      <td>1271150</td>\n",
       "      <td>1104495</td>\n",
       "      <td>13335</td>\n",
       "      <td>6220413</td>\n",
       "      <td>144146</td>\n",
       "      <td>218135</td>\n",
       "      <td>250479</td>\n",
       "      <td>658390</td>\n",
       "      <td>234842</td>\n",
       "      <td>377918</td>\n",
       "      <td>2375645</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>00</td>\n",
       "      <td>00000</td>\n",
       "      <td>0000000</td>\n",
       "      <td>T</td>\n",
       "      <td>GF</td>\n",
       "      <td>1728140</td>\n",
       "      <td>140174</td>\n",
       "      <td>580771</td>\n",
       "      <td>568942</td>\n",
       "      <td>6414</td>\n",
       "      <td>3024441</td>\n",
       "      <td>62609</td>\n",
       "      <td>87882</td>\n",
       "      <td>114543</td>\n",
       "      <td>315737</td>\n",
       "      <td>107805</td>\n",
       "      <td>157229</td>\n",
       "      <td>1149713</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>00</td>\n",
       "      <td>00000</td>\n",
       "      <td>0000000</td>\n",
       "      <td>T</td>\n",
       "      <td>GM</td>\n",
       "      <td>1841526</td>\n",
       "      <td>121593</td>\n",
       "      <td>690379</td>\n",
       "      <td>535553</td>\n",
       "      <td>6921</td>\n",
       "      <td>3195972</td>\n",
       "      <td>81537</td>\n",
       "      <td>130253</td>\n",
       "      <td>135936</td>\n",
       "      <td>342653</td>\n",
       "      <td>127037</td>\n",
       "      <td>220689</td>\n",
       "      <td>1225932</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>01</td>\n",
       "      <td>10017</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>TA</td>\n",
       "      <td>1506</td>\n",
       "      <td>121</td>\n",
       "      <td>870</td>\n",
       "      <td>489</td>\n",
       "      <td>119</td>\n",
       "      <td>3105</td>\n",
       "      <td>136</td>\n",
       "      <td>159</td>\n",
       "      <td>143</td>\n",
       "      <td>432</td>\n",
       "      <td>188</td>\n",
       "      <td>250</td>\n",
       "      <td>1359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017-18</td>\n",
       "      <td>01</td>\n",
       "      <td>10017</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>GF</td>\n",
       "      <td>718</td>\n",
       "      <td>69</td>\n",
       "      <td>431</td>\n",
       "      <td>283</td>\n",
       "      <td>61</td>\n",
       "      <td>1562</td>\n",
       "      <td>64</td>\n",
       "      <td>77</td>\n",
       "      <td>75</td>\n",
       "      <td>215</td>\n",
       "      <td>98</td>\n",
       "      <td>118</td>\n",
       "      <td>714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212543</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72751</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>GM</td>\n",
       "      <td>647</td>\n",
       "      <td>4</td>\n",
       "      <td>44</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>715</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>12</td>\n",
       "      <td>23</td>\n",
       "      <td>8</td>\n",
       "      <td>13</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212556</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>TA</td>\n",
       "      <td>885</td>\n",
       "      <td>28</td>\n",
       "      <td>36</td>\n",
       "      <td>146</td>\n",
       "      <td>1</td>\n",
       "      <td>1096</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212557</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>GF</td>\n",
       "      <td>395</td>\n",
       "      <td>18</td>\n",
       "      <td>15</td>\n",
       "      <td>71</td>\n",
       "      <td>0</td>\n",
       "      <td>499</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212558</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>GM</td>\n",
       "      <td>489</td>\n",
       "      <td>10</td>\n",
       "      <td>21</td>\n",
       "      <td>75</td>\n",
       "      <td>1</td>\n",
       "      <td>596</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212559</th>\n",
       "      <td>2022-23</td>\n",
       "      <td>58</td>\n",
       "      <td>72769</td>\n",
       "      <td>0000000</td>\n",
       "      <td>D</td>\n",
       "      <td>GX</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21102 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       academic_year county_code district_code school_code aggregate_level  \\\n",
       "0            2017-18          00         00000     0000000               T   \n",
       "1            2017-18          00         00000     0000000               T   \n",
       "2            2017-18          00         00000     0000000               T   \n",
       "3            2017-18          01         10017     0000000               D   \n",
       "4            2017-18          01         10017     0000000               D   \n",
       "...              ...         ...           ...         ...             ...   \n",
       "212543       2022-23          58         72751     0000000               D   \n",
       "212556       2022-23          58         72769     0000000               D   \n",
       "212557       2022-23          58         72769     0000000               D   \n",
       "212558       2022-23          58         72769     0000000               D   \n",
       "212559       2022-23          58         72769     0000000               D   \n",
       "\n",
       "       reporting_category       EO    IFEP       EL     RFEP    TBD  \\\n",
       "0                      TA  3569666  261767  1271150  1104495  13335   \n",
       "1                      GF  1728140  140174   580771   568942   6414   \n",
       "2                      GM  1841526  121593   690379   535553   6921   \n",
       "3                      TA     1506     121      870      489    119   \n",
       "4                      GF      718      69      431      283     61   \n",
       "...                   ...      ...     ...      ...      ...    ...   \n",
       "212543                 GM      647       4       44       20      0   \n",
       "212556                 TA      885      28       36      146      1   \n",
       "212557                 GF      395      18       15       71      0   \n",
       "212558                 GM      489      10       21       75      1   \n",
       "212559                 GX        1       0        0        0      0   \n",
       "\n",
       "        TotalEnrollment      AR    LTEL    EL4+   EL03Y   EL45Y   EL6+Y  \\\n",
       "0               6220413  144146  218135  250479  658390  234842  377918   \n",
       "1               3024441   62609   87882  114543  315737  107805  157229   \n",
       "2               3195972   81537  130253  135936  342653  127037  220689   \n",
       "3                  3105     136     159     143     432     188     250   \n",
       "4                  1562      64      77      75     215      98     118   \n",
       "...                 ...     ...     ...     ...     ...     ...     ...   \n",
       "212543              715       3       6      12      23       8      13   \n",
       "212556             1096       0      24       8       4       0      32   \n",
       "212557              499       0       9       4       2       0      13   \n",
       "212558              596       0      15       4       2       0      19   \n",
       "212559                1       0       0       0       0       0       0   \n",
       "\n",
       "        Total-EE  \n",
       "0        2375645  \n",
       "1        1149713  \n",
       "2        1225932  \n",
       "3           1359  \n",
       "4            714  \n",
       "...          ...  \n",
       "212543        64  \n",
       "212556       182  \n",
       "212557        86  \n",
       "212558        96  \n",
       "212559         0  \n",
       "\n",
       "[21102 rows x 19 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Columns you want to remove\n",
    "columns_to_drop = ['is_wcc_entity' ]\n",
    "\n",
    "# Drop the specified columns\n",
    "final_filtered_enrollment_el_df = final_filtered_enrollment_el_df.drop(columns=columns_to_drop)\n",
    "final_filtered_enrollment_el_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_filtered_enrollment_el_df.to_csv('final_long_datasets_domain/final_enrollment_el_df.csv', index=False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "venv",
   "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.9.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}