{ "cells": [ { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "import numpy as np\n", "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "%matplotlib inline" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Describe your dataset. \n", "Describe and explore your dataset in the initial section of your Report. What does your data contain and what is its background? Where does it come from? Why is it interesting or significant? Conduct summary statistics and produce visualizations for the particular variables from the dataset that you will use." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Dataset: The Civil Rights Data Collection, school-level data for 2015-2016\n", "\n", "The Civil Rights Data Collection (CRDC) is a biennial survey required by the U.S. Department of Education’s (Department) Office for Civil Rights (OCR) since 1968. (Note, howerever, that survey content changes over time.)\n", "\n", "The 2015–16 CRDC collects data from all public local educational agencies (LEAs, ie *School Districts*) and schools, including \n", "- long-term secure juvenile justice facilities\n", "- charter schools\n", "- alternative schools\n", "- and schools serving students with disabilities\n", "\n", "with a responce rate of 99.8% from __17,337 LEAs and 96,360 schools__. Speicifically, I will be looking at the finer-grained *data disagregated by school*.\n", "\n", "### Data content and format\n", "Each school (row) in the dataset includes 1,800 columns (typically a student count disagregated by race and gender) regarding 32 general topics, (__the topics I will investigate are in bold__):\n", "\n", "__'Identification', 'School Characteristics', 'Enrollment','Suspensions', 'Expulsions', 'Transfers', 'Referrals and Arrests', 'Offenses', 'Restraint and Seclusion', 'Chronic Absenteeism', 'Retention', 'Justice Facility',__ \n", " 'Gifted and Talented', 'Dual Enrollment', 'Credit Recovery',\n", " 'Algebra I', 'Geometry', 'Algebra II', 'Calculus',\n", " 'Advanced Mathematics', 'Biology', 'Chemistry', 'Physics',\n", " 'Single-sex Classes', 'Advanced Placement',\n", " 'International Baccalaureate', 'SAT and ACT Exams',\n", " 'Corporal Punishment',\n", " 'Harassment and Bullying',\n", " 'Single-Sex Athletics', 'School Expenditures', 'School Support',\n", " \n", "\n", "\n", "### Known issues with dataset\n", "From the CRDC report: \"An important consideration for response rates is that the reporting process requires all schools and LEAs to respond to each survey item on the CRDC. Some LEAs, that did not have complete data, __reported a zero value__. It is not possible to determine all possible situations where this may have occurred. As such, it may be the case that the item response rates may be positively biased. For the large majority of CRDC survey items, __the rate of missing data ranged from 0-5% of reported values__.\"" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "array(['Identification', 'School Characteristics', 'Enrollment',\n", " 'Gifted and Talented', 'Dual Enrollment', 'Credit Recovery',\n", " 'Algebra I', 'Geometry', 'Algebra II', 'Calculus',\n", " 'Advanced Mathematics', 'Biology', 'Chemistry', 'Physics',\n", " 'Single-sex Classes', 'Advanced Placement',\n", " 'International Baccalaureate', 'SAT and ACT Exams',\n", " 'Corporal Punishment', 'Suspensions', 'Expulsions', 'Transfers',\n", " 'Referrals and Arrests', 'Offenses', 'Restraint and Seclusion',\n", " 'Harassment and Bullying', 'Chronic Absenteeism', 'Retention',\n", " 'Single-Sex Athletics', 'School Expenditures', 'School Support',\n", " 'Justice Facility'], dtype=object)" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "cols_description = pd.read_csv('data (download CSVs here)/CRDC 2015-16 School Data Record Layout.csv', encoding=\"ISO-8859-1\")\n", "cols_description['Module'].unique()" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "0 LEA_STATE\n", "1 LEA_STATE_NAME\n", "2 LEAID\n", "3 LEA_NAME\n", "4 SCHID\n", "5 SCH_NAME\n", "6 COMBOKEY\n", "7 JJ\n", "8 SCH_GRADE_PS\n", "9 SCH_GRADE_KG\n", "10 SCH_GRADE_G01\n", "11 SCH_GRADE_G02\n", "12 SCH_GRADE_G03\n", "13 SCH_GRADE_G04\n", "14 SCH_GRADE_G05\n", "15 SCH_GRADE_G06\n", "16 SCH_GRADE_G07\n", "17 SCH_GRADE_G08\n", "18 SCH_GRADE_G09\n", "19 SCH_GRADE_G10\n", "20 SCH_GRADE_G11\n", "21 SCH_GRADE_G12\n", "22 SCH_GRADE_UG\n", "23 SCH_UGDETAIL_ES\n", "24 SCH_UGDETAIL_MS\n", "25 SCH_UGDETAIL_HS\n", "26 SCH_STATUS_SPED\n", "27 SCH_STATUS_MAGNET\n", "28 SCH_STATUS_CHARTER\n", "29 SCH_STATUS_ALT\n", " ... \n", "1777 TOT_RET_G12_M\n", "1778 TOT_RET_G12_F\n", "1779 SCH_RET_G12_LEP_M\n", "1780 SCH_RET_G12_LEP_F\n", "1781 SCH_RET_G12_IDEA_M\n", "1782 SCH_RET_G12_IDEA_F\n", "1783 SCH_RET_G12_504_M\n", "1784 SCH_RET_G12_504_F\n", "1814 SCH_FTETEACH_TOT\n", "1815 SCH_FTETEACH_CERT\n", "1816 SCH_FTETEACH_NOTCERT\n", "1817 SCH_FTETEACH_FY\n", "1818 SCH_FTETEACH_SY\n", "1819 SCH_TEACHERS_CURR_TOT\n", "1820 SCH_TEACHERS_PREV_TOT\n", "1821 SCH_FTECOUNSELORS\n", "1822 SCH_FTETEACH_ABSENT\n", "1823 SCH_FTESECURITY_LEO\n", "1824 SCH_FTESECURITY_GUA\n", "1825 SCH_FTESERVICES_NUR\n", "1826 SCH_FTESERVICES_PSY\n", "1827 SCH_FTESERVICES_SOC\n", "1828 SCH_JJTYPE\n", "1829 SCH_JJSYDAYS\n", "1830 SCH_JJHOURS\n", "1831 SCH_JJPART_LT15\n", "1832 SCH_JJPART_15T30\n", "1833 SCH_JJPART_31T90\n", "1834 SCH_JJPART_91T180\n", "1835 SCH_JJPART_OV180\n", "Name: Field_Name, Length: 1056, dtype: object" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "modules_of_interest = ['Identification', 'School Characteristics', 'Enrollment','Suspensions', 'Expulsions', 'Transfers', 'Referrals and Arrests', 'Offenses', 'Restraint and Seclusion', 'Chronic Absenteeism', 'Retention', 'School Support', 'Justice Facility']\n", "# Get all cols within our modules of interest\n", "cols_of_interest = cols_description[cols_description['Module'].isin(modules_of_interest)]\n", "cols_of_interest['Field_Name']" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Load and Format the data (after downloading)\n", "[Download the 400MB file here.](https://drive.google.com/file/d/1yOqzjwinFp4THrDX0s543LtIEXO9B-Ap/view?usp=sharing)\n", "\n", "Note that this file is *identical* to the one that can be downloaded [on the CRDC website](https://www2.ed.gov/about/offices/list/ocr/data.html)" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "ename": "NameError", "evalue": "name 'cols_of_interest' is not defined", "output_type": "error", "traceback": [ "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m", "\u001b[0;31mNameError\u001b[0m Traceback (most recent call last)", "\u001b[0;32m\u001b[0m in \u001b[0;36m\u001b[0;34m()\u001b[0m\n\u001b[1;32m 3\u001b[0m crdc_data = pd.read_csv(\n\u001b[1;32m 4\u001b[0m \u001b[0mDATA_FILE\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 5\u001b[0;31m \u001b[0musecols\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mcols_of_interest\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'Field_Name'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m 6\u001b[0m \u001b[0mlow_memory\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mFalse\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 7\u001b[0m \u001b[0mencoding\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m\"ISO-8859-1\"\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n", "\u001b[0;31mNameError\u001b[0m: name 'cols_of_interest' is not defined" ] } ], "source": [ "# In take data\n", "DATA_FILE = 'data (download CSVs here)/CRDC 2015-16 School Data.csv'\n", "crdc_data = pd.read_csv(\n", " DATA_FILE,\n", " usecols=cols_of_interest['Field_Name'],\n", " low_memory=False,\n", " encoding=\"ISO-8859-1\"\n", ")\n", "crdc_data" ] }, { "cell_type": "code", "execution_count": 48, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "LEA_STATE object\n", "LEA_STATE_NAME object\n", "LEAID object\n", "LEA_NAME object\n", "SCHID object\n", "SCH_NAME object\n", "COMBOKEY object\n", "JJ object\n", "SCH_GRADE_PS object\n", "SCH_GRADE_KG object\n", "SCH_GRADE_G01 object\n", "SCH_GRADE_G02 object\n", "SCH_GRADE_G03 object\n", "SCH_GRADE_G04 object\n", "SCH_GRADE_G05 object\n", "SCH_GRADE_G06 object\n", "SCH_GRADE_G07 object\n", "SCH_GRADE_G08 object\n", "SCH_GRADE_G09 object\n", "SCH_GRADE_G10 object\n", "SCH_GRADE_G11 object\n", "SCH_GRADE_G12 object\n", "SCH_GRADE_UG object\n", "SCH_UGDETAIL_ES object\n", "SCH_UGDETAIL_MS object\n", "SCH_UGDETAIL_HS object\n", "SCH_STATUS_SPED object\n", "SCH_STATUS_MAGNET object\n", "SCH_STATUS_CHARTER object\n", "SCH_STATUS_ALT object\n", " ... \n", "TOT_RET_G12_M int64\n", "TOT_RET_G12_F int64\n", "SCH_RET_G12_LEP_M int64\n", "SCH_RET_G12_LEP_F int64\n", "SCH_RET_G12_IDEA_M int64\n", "SCH_RET_G12_IDEA_F int64\n", "SCH_RET_G12_504_M int64\n", "SCH_RET_G12_504_F int64\n", "SCH_FTETEACH_TOT float64\n", "SCH_FTETEACH_CERT float64\n", "SCH_FTETEACH_NOTCERT float64\n", "SCH_FTETEACH_FY float64\n", "SCH_FTETEACH_SY float64\n", "SCH_TEACHERS_CURR_TOT int64\n", "SCH_TEACHERS_PREV_TOT int64\n", "SCH_FTECOUNSELORS float64\n", "SCH_FTETEACH_ABSENT float64\n", "SCH_FTESECURITY_LEO float64\n", "SCH_FTESECURITY_GUA float64\n", "SCH_FTESERVICES_NUR float64\n", "SCH_FTESERVICES_PSY float64\n", "SCH_FTESERVICES_SOC float64\n", "SCH_JJTYPE object\n", "SCH_JJSYDAYS int64\n", "SCH_JJHOURS int64\n", "SCH_JJPART_LT15 int64\n", "SCH_JJPART_15T30 int64\n", "SCH_JJPART_31T90 int64\n", "SCH_JJPART_91T180 int64\n", "SCH_JJPART_OV180 int64\n", "Length: 1056, dtype: object" ] }, "execution_count": 48, "metadata": {}, "output_type": "execute_result" } ], "source": [ "crdc_data.dtypes" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### The raw CRDC unhelpfully converted large ID values to scientific notation, so we'll reconstruct the IDs, which are a combination of district, school, and state IDs" ] }, { "cell_type": "code", "execution_count": 49, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "'5.68025E+11'" ] }, "execution_count": 49, "metadata": {}, "output_type": "execute_result" } ], "source": [ "crdc_data[-1:]['COMBOKEY'].values[0]#get('COMBOKEY')\n", "# LIMIT TO JUST NORTH CAROLINA (FOR DEVELOPMENT SPEED)\n", "# data = crdc_data[crdc_data['LEA_STATE'] == 'NC'] " ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Create the NCESSCH field on the CRDC Data" ] }, { "cell_type": "code", "execution_count": 50, "metadata": {}, "outputs": [], "source": [ "def f(row):\n", " return str(row['LEAID']) + str(row['SCHID']).zfill(5)\n", "\n", "crdc_data['NCESSCH'] = crdc_data.apply(f, axis='columns')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Merge with Lat/Long coordinate data" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### A. Merge with Public School Data" ] }, { "cell_type": "code", "execution_count": 51, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "NCESSCH object\n", "NAME object\n", "LAT1516 float64\n", "LON1516 float64\n", "dtype: object" ] }, "execution_count": 51, "metadata": {}, "output_type": "execute_result" } ], "source": [ "LAT_LONG_FILE = 'EDGE_GEOCODE_PUBLICSCH_1516/EDGE_GEOCODE_PUBLICSCH_1516.csv'\n", "lat_long_cols_of_interest = ['NCESSCH', 'LAT1516', 'LON1516', 'NAME']\n", "school_lat_longs = pd.read_csv(\n", " LAT_LONG_FILE,\n", " usecols=lat_long_cols_of_interest,\n", " dtype={'NCESSCH': int},\n", " low_memory=False,\n", " encoding = \"ISO-8859-1\"\n", ")\n", "school_lat_longs['NCESSCH'] = school_lat_longs['NCESSCH'].apply(str)\n", "school_lat_longs.dtypes" ] }, { "cell_type": "code", "execution_count": 52, "metadata": { "scrolled": true }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
LEA_STATELEA_STATE_NAMELEAIDLEA_NAMESCHIDSCH_NAMECOMBOKEYJJSCH_GRADE_PSSCH_GRADE_KG...SCH_JJHOURSSCH_JJPART_LT15SCH_JJPART_15T30SCH_JJPART_31T90SCH_JJPART_91T180SCH_JJPART_OV180NCESSCHNAMELAT1516LON1516
0ALALABAMA100002Alabama Youth Services1705Wallace Sch - Mt Meigs Campus10000201705YesNoNo...-7-7-7-7-7-710000201705Wallace Sch - Mt Meigs Campus32.374812-86.082360
1ALALABAMA100002Alabama Youth Services1706McNeel Sch - Vacca Campus10000201706YesNoNo...-7-7-7-7-7-710000201706McNeel Sch - Vacca Campus33.583385-86.710058
2ALALABAMA100002Alabama Youth Services1876Alabama Youth Services10000201876NoNoNo...-9-9-9-9-9-910000201876Alabama Youth Services32.374847-86.082332
3ALALABAMA100002Alabama Youth Services99995AUTAUGA CAMPUS10000299995YesNoNo...-7-7-7-7-7-710000299995NaNNaNNaN
4ALALABAMA100005Albertville City870Albertville Middle School10000500870NoNoNo...-9-9-9-9-9-910000500870Ala Avenue Middle Sch34.260194-86.206174
5ALALABAMA100005Albertville City871Albertville High Sch10000500871NoNoNo...-9-9-9-9-9-910000500871Albertville High Sch34.262154-86.204863
6ALALABAMA100005Albertville City879Evans Elem Sch10000500879NoNoNo...-9-9-9-9-9-910000500879Evans Elem Sch34.273161-86.220086
7ALALABAMA100005Albertville City889Albertville Elem Sch10000500889NoNoNo...-9-9-9-9-9-910000500889Albertville Elem Sch34.253251-86.221834
8ALALABAMA100005Albertville City1616Big Spring Lake Kinderg Sch10000501616NoYesYes...-9-9-9-9-9-910000501616Big Spring Lake Kinderg Sch34.290220-86.192490
9ALALABAMA100005Albertville City2150Albertville Primary Sch10000502150NoYesNo...-9-9-9-9-9-910000502150Albertville Primary Sch34.253251-86.221834
10ALALABAMA100006Marshall County193Kate Duncan Smith DAR Middle10000600193NoNoNo...-9-9-9-9-9-910000600193Kate Duncan Smith DAR Middle34.533721-86.253681
11ALALABAMA100006Marshall County872Asbury Sch10000600872NoNoNo...-9-9-9-9-9-910000600872Asbury Sch34.362770-86.142240
12ALALABAMA100006Marshall County876Claysville Jr High Sch10000600876NoYesYes...-9-9-9-9-9-910000600876Claysville Jr High Sch34.406429-86.270689
13ALALABAMA100006Marshall County877Douglas Elem Sch10000600877NoYesNo...-9-9-9-9-9-910000600877Douglas Elem Sch34.176234-86.321259
14ALALABAMA100006Marshall County878Douglas High Sch10000600878NoNoNo...-9-9-9-9-9-910000600878Douglas High Sch34.178157-86.319947
15ALALABAMA100006Marshall County880Brindlee Mountain Elementary School10000600880NoYesNo...-9-9-9-9-9-910000600880Grassy Elem Sch34.344388-86.442199
16ALALABAMA100006Marshall County883Kate D Smith DAR High Sch10000600883NoNoNo...-9-9-9-9-9-910000600883Kate D Smith DAR High Sch34.533721-86.253681
17ALALABAMA100006Marshall County887Brindlee Mountain Primary School10000600887NoYesYes...-9-9-9-9-9-910000600887Union Grove Elem Sch34.399966-86.446812
18ALALABAMA100006Marshall County1413Robert D Sloman Primary10000601413NoYesYes...-9-9-9-9-9-910000601413Robert D Sloman Primary34.176713-86.323279
19ALALABAMA100006Marshall County1434Brindlee Mt Middle Sch10000601434NoNoNo...-9-9-9-9-9-910000601434Brindlee Mt Middle Sch34.377158-86.422337
20ALALABAMA100006Marshall County1585Brindlee Mt High Sch10000601585NoNoNo...-9-9-9-9-9-910000601585Brindlee Mt High Sch34.376400-86.421876
21ALALABAMA100006Marshall County1685Kate D Smith DAR Elem Sch10000601685NoYesYes...-9-9-9-9-9-910000601685Kate D Smith DAR Elem Sch34.533721-86.253681
22ALALABAMA100006Marshall County1812Douglas Middle Sch10000601812NoNoNo...-9-9-9-9-9-910000601812Douglas Middle Sch34.176234-86.321259
23ALALABAMA100006Marshall County2209Asbury Elem Sch10000602209NoYesYes...-9-9-9-9-9-910000602209Asbury Elem Sch34.362794-86.142507
24ALALABAMA100007Hoover City91Trace Crossings Elem Sch10000700091NoYesYes...-9-9-9-9-9-910000700091Trace Crossings Elem Sch33.340886-86.844733
25ALALABAMA100007Hoover City248Greystone Elem Sch10000700248NoNoYes...-9-9-9-9-9-910000700248Greystone Elem Sch33.413047-86.658547
26ALALABAMA100007Hoover City251Hoover High Sch10000700251NoNoNo...-9-9-9-9-9-910000700251Hoover High Sch33.344370-86.837683
27ALALABAMA100007Hoover City337Berry Middle Sch10000700337NoNoNo...-9-9-9-9-9-910000700337Berry Middle Sch33.395648-86.732180
28ALALABAMA100007Hoover City342South Shades Crest Elem Sch10000700342NoNoYes...-9-9-9-9-9-910000700342South Shades Crest Elem Sch33.337527-86.878390
29ALALABAMA100007Hoover City1422Robert F Bumpus Middle Sch10000701422NoNoNo...-9-9-9-9-9-910000701422Robert F Bumpus Middle Sch33.330911-86.852477
..................................................................
96330WYWYOMING5605762Sweetwater County School District #2332Washington Elementary5.60576E+11NoNoYes...-9-9-9-9-9-9560576200332NaNNaNNaN
96331WYWYOMING5605762Sweetwater County School District #2399Lincoln Middle School5.60576E+11NoNoNo...-9-9-9-9-9-9560576200399NaNNaNNaN
96332WYWYOMING5605762Sweetwater County School District #2424Jackson Elementary5.60576E+11NoNoYes...-9-9-9-9-9-9560576200424NaNNaNNaN
96333WYWYOMING5605762Sweetwater County School District #2425Truman Elementary5.60576E+11NoNoYes...-9-9-9-9-9-9560576200425NaNNaNNaN
96334WYWYOMING5605762Sweetwater County School District #2439Harrison Elementary5.60576E+11NoNoYes...-9-9-9-9-9-9560576200439NaNNaNNaN
96335WYWYOMING5605762Sweetwater County School District #2528Thoman Ranch Elementary5.60576E+11NoNoNo...-9-9-9-9-9-9560576200528NaNNaNNaN
96336WYWYOMING5605820Washakie County School District #2393Ten Sleep K-125.60582E+11NoNoYes...-9-9-9-9-9-9560582000393NaNNaNNaN
96337WYWYOMING5605830Teton County School District #1289Colter Elementary5.60583E+11NoNoNo...-9-9-9-9-9-9560583000289NaNNaNNaN
96338WYWYOMING5605830Teton County School District #1313Jackson Elementary5.60583E+11NoNoYes...-9-9-9-9-9-9560583000313NaNNaNNaN
96339WYWYOMING5605830Teton County School District #1335Jackson Hole High School5.60583E+11NoNoNo...-9-9-9-9-9-9560583000335NaNNaNNaN
96340WYWYOMING5605830Teton County School District #1336Jackson Hole Middle School5.60583E+11NoNoNo...-9-9-9-9-9-9560583000336NaNNaNNaN
96341WYWYOMING5605830Teton County School District #1337Alta Elementary5.60583E+11NoNoYes...-9-9-9-9-9-9560583000337NaNNaNNaN
96342WYWYOMING5605830Teton County School District #1339Kelly Elementary5.60583E+11NoNoYes...-9-9-9-9-9-9560583000339NaNNaNNaN
96343WYWYOMING5605830Teton County School District #1340Moran Elementary5.60583E+11NoNoYes...-9-9-9-9-9-9560583000340NaNNaNNaN
96344WYWYOMING5605830Teton County School District #1341Wilson Elementary5.60583E+11NoNoYes...-9-9-9-9-9-9560583000341NaNNaNNaN
96345WYWYOMING5605830Teton County School District #1512Summit High School5.60583E+11NoNoNo...-9-9-9-9-9-9560583000512NaNNaNNaN
96346WYWYOMING5606090Weston County School District #7342Upton Middle School5.60609E+11NoNoNo...-9-9-9-9-9-9560609000342NaNNaNNaN
96347WYWYOMING5606090Weston County School District #7363Upton Elementary5.60609E+11NoNoYes...-9-9-9-9-9-9560609000363NaNNaNNaN
96348WYWYOMING5606090Weston County School District #7401Upton High School5.60609E+11NoNoNo...-9-9-9-9-9-9560609000401NaNNaNNaN
96349WYWYOMING5606240Washakie County School District #1343Worland High School5.60624E+11NoNoNo...-9-9-9-9-9-9560624000343NaNNaNNaN
96350WYWYOMING5606240Washakie County School District #1344Worland Middle School5.60624E+11NoNoNo...-9-9-9-9-9-9560624000344NaNNaNNaN
96351WYWYOMING5606240Washakie County School District #1345East Side Elementary5.60624E+11NoNoYes...-9-9-9-9-9-9560624000345NaNNaNNaN
96352WYWYOMING5606240Washakie County School District #1346South Side Elementary5.60624E+11NoNoYes...-9-9-9-9-9-9560624000346NaNNaNNaN
96353WYWYOMING5606240Washakie County School District #1347West Side Elementary5.60624E+11NoNoYes...-9-9-9-9-9-9560624000347NaNNaNNaN
96354WYWYOMING5680180Northeast Wyoming BOCES31Powder River Basin Children's Center5.68018E+11NoNoNo...-9-9-9-9-9-9568018000031NaNNaNNaN
96355WYWYOMING5680250Region V BOCES48C-Bar-V Ranch5.68025E+11NoNoNo...-9-9-9-9-9-9568025000048NaNNaNNaN
96356WYWYOMING5680251Wyoming Department of Family Services534Wyoming Girls School5.68025E+11YesNoNo...272581750568025100534NaNNaNNaN
96357WYWYOMING5680251Wyoming Department of Family Services538Wyoming Boys School5.68025E+11YesNoNo...30171168868568025100538NaNNaNNaN
96358WYWYOMING5680252Youth Emergency Services Inc. - Administration...350Youth Emergency Services Inc.5.68025E+11NoNoNo...-9-9-9-9-9-9568025200350NaNNaNNaN
96359WYWYOMING5680254Saint Stephen's Indian School Admin Office\\tSaint Stephen's Indian School5.68025E+11NoNoYes...-9-9-9-9-9-956802540000\\tNaNNaNNaN
\n", "

96360 rows × 1060 columns

\n", "
" ], "text/plain": [ " LEA_STATE LEA_STATE_NAME LEAID \\\n", "0 AL ALABAMA 100002 \n", "1 AL ALABAMA 100002 \n", "2 AL ALABAMA 100002 \n", "3 AL ALABAMA 100002 \n", "4 AL ALABAMA 100005 \n", "5 AL ALABAMA 100005 \n", "6 AL ALABAMA 100005 \n", "7 AL ALABAMA 100005 \n", "8 AL ALABAMA 100005 \n", "9 AL ALABAMA 100005 \n", "10 AL ALABAMA 100006 \n", "11 AL ALABAMA 100006 \n", "12 AL ALABAMA 100006 \n", "13 AL ALABAMA 100006 \n", "14 AL ALABAMA 100006 \n", "15 AL ALABAMA 100006 \n", "16 AL ALABAMA 100006 \n", "17 AL ALABAMA 100006 \n", "18 AL ALABAMA 100006 \n", "19 AL ALABAMA 100006 \n", "20 AL ALABAMA 100006 \n", "21 AL ALABAMA 100006 \n", "22 AL ALABAMA 100006 \n", "23 AL ALABAMA 100006 \n", "24 AL ALABAMA 100007 \n", "25 AL ALABAMA 100007 \n", "26 AL ALABAMA 100007 \n", "27 AL ALABAMA 100007 \n", "28 AL ALABAMA 100007 \n", "29 AL ALABAMA 100007 \n", "... ... ... ... \n", "96330 WY WYOMING 5605762 \n", "96331 WY WYOMING 5605762 \n", "96332 WY WYOMING 5605762 \n", "96333 WY WYOMING 5605762 \n", "96334 WY WYOMING 5605762 \n", "96335 WY WYOMING 5605762 \n", "96336 WY WYOMING 5605820 \n", "96337 WY WYOMING 5605830 \n", "96338 WY WYOMING 5605830 \n", "96339 WY WYOMING 5605830 \n", "96340 WY WYOMING 5605830 \n", "96341 WY WYOMING 5605830 \n", "96342 WY WYOMING 5605830 \n", "96343 WY WYOMING 5605830 \n", "96344 WY WYOMING 5605830 \n", "96345 WY WYOMING 5605830 \n", "96346 WY WYOMING 5606090 \n", "96347 WY WYOMING 5606090 \n", "96348 WY WYOMING 5606090 \n", "96349 WY WYOMING 5606240 \n", "96350 WY WYOMING 5606240 \n", "96351 WY WYOMING 5606240 \n", "96352 WY WYOMING 5606240 \n", "96353 WY WYOMING 5606240 \n", "96354 WY WYOMING 5680180 \n", "96355 WY WYOMING 5680250 \n", "96356 WY WYOMING 5680251 \n", "96357 WY WYOMING 5680251 \n", "96358 WY WYOMING 5680252 \n", "96359 WY WYOMING 5680254 \n", "\n", " LEA_NAME SCHID \\\n", "0 Alabama Youth Services 1705 \n", "1 Alabama Youth Services 1706 \n", "2 Alabama Youth Services 1876 \n", "3 Alabama Youth Services 99995 \n", "4 Albertville City 870 \n", "5 Albertville City 871 \n", "6 Albertville City 879 \n", "7 Albertville City 889 \n", "8 Albertville City 1616 \n", "9 Albertville City 2150 \n", "10 Marshall County 193 \n", "11 Marshall County 872 \n", "12 Marshall County 876 \n", "13 Marshall County 877 \n", "14 Marshall County 878 \n", "15 Marshall County 880 \n", "16 Marshall County 883 \n", "17 Marshall County 887 \n", "18 Marshall County 1413 \n", "19 Marshall County 1434 \n", "20 Marshall County 1585 \n", "21 Marshall County 1685 \n", "22 Marshall County 1812 \n", "23 Marshall County 2209 \n", "24 Hoover City 91 \n", "25 Hoover City 248 \n", "26 Hoover City 251 \n", "27 Hoover City 337 \n", "28 Hoover City 342 \n", "29 Hoover City 1422 \n", "... ... ... \n", "96330 Sweetwater County School District #2 332 \n", "96331 Sweetwater County School District #2 399 \n", "96332 Sweetwater County School District #2 424 \n", "96333 Sweetwater County School District #2 425 \n", "96334 Sweetwater County School District #2 439 \n", "96335 Sweetwater County School District #2 528 \n", "96336 Washakie County School District #2 393 \n", "96337 Teton County School District #1 289 \n", "96338 Teton County School District #1 313 \n", "96339 Teton County School District #1 335 \n", "96340 Teton County School District #1 336 \n", "96341 Teton County School District #1 337 \n", "96342 Teton County School District #1 339 \n", "96343 Teton County School District #1 340 \n", "96344 Teton County School District #1 341 \n", "96345 Teton County School District #1 512 \n", "96346 Weston County School District #7 342 \n", "96347 Weston County School District #7 363 \n", "96348 Weston County School District #7 401 \n", "96349 Washakie County School District #1 343 \n", "96350 Washakie County School District #1 344 \n", "96351 Washakie County School District #1 345 \n", "96352 Washakie County School District #1 346 \n", "96353 Washakie County School District #1 347 \n", "96354 Northeast Wyoming BOCES 31 \n", "96355 Region V BOCES 48 \n", "96356 Wyoming Department of Family Services 534 \n", "96357 Wyoming Department of Family Services 538 \n", "96358 Youth Emergency Services Inc. - Administration... 350 \n", "96359 Saint Stephen's Indian School Admin Office \\t \n", "\n", " SCH_NAME COMBOKEY JJ SCH_GRADE_PS \\\n", "0 Wallace Sch - Mt Meigs Campus 10000201705 Yes No \n", "1 McNeel Sch - Vacca Campus 10000201706 Yes No \n", "2 Alabama Youth Services 10000201876 No No \n", "3 AUTAUGA CAMPUS 10000299995 Yes No \n", "4 Albertville Middle School 10000500870 No No \n", "5 Albertville High Sch 10000500871 No No \n", "6 Evans Elem Sch 10000500879 No No \n", "7 Albertville Elem Sch 10000500889 No No \n", "8 Big Spring Lake Kinderg Sch 10000501616 No Yes \n", "9 Albertville Primary Sch 10000502150 No Yes \n", "10 Kate Duncan Smith DAR Middle 10000600193 No No \n", "11 Asbury Sch 10000600872 No No \n", "12 Claysville Jr High Sch 10000600876 No Yes \n", "13 Douglas Elem Sch 10000600877 No Yes \n", "14 Douglas High Sch 10000600878 No No \n", "15 Brindlee Mountain Elementary School 10000600880 No Yes \n", "16 Kate D Smith DAR High Sch 10000600883 No No \n", "17 Brindlee Mountain Primary School 10000600887 No Yes \n", "18 Robert D Sloman Primary 10000601413 No Yes \n", "19 Brindlee Mt Middle Sch 10000601434 No No \n", "20 Brindlee Mt High Sch 10000601585 No No \n", "21 Kate D Smith DAR Elem Sch 10000601685 No Yes \n", "22 Douglas Middle Sch 10000601812 No No \n", "23 Asbury Elem Sch 10000602209 No Yes \n", "24 Trace Crossings Elem Sch 10000700091 No Yes \n", "25 Greystone Elem Sch 10000700248 No No \n", "26 Hoover High Sch 10000700251 No No \n", "27 Berry Middle Sch 10000700337 No No \n", "28 South Shades Crest Elem Sch 10000700342 No No \n", "29 Robert F Bumpus Middle Sch 10000701422 No No \n", "... ... ... ... ... \n", "96330 Washington Elementary 5.60576E+11 No No \n", "96331 Lincoln Middle School 5.60576E+11 No No \n", "96332 Jackson Elementary 5.60576E+11 No No \n", "96333 Truman Elementary 5.60576E+11 No No \n", "96334 Harrison Elementary 5.60576E+11 No No \n", "96335 Thoman Ranch Elementary 5.60576E+11 No No \n", "96336 Ten Sleep K-12 5.60582E+11 No No \n", "96337 Colter Elementary 5.60583E+11 No No \n", "96338 Jackson Elementary 5.60583E+11 No No \n", "96339 Jackson Hole High School 5.60583E+11 No No \n", "96340 Jackson Hole Middle School 5.60583E+11 No No \n", "96341 Alta Elementary 5.60583E+11 No No \n", "96342 Kelly Elementary 5.60583E+11 No No \n", "96343 Moran Elementary 5.60583E+11 No No \n", "96344 Wilson Elementary 5.60583E+11 No No \n", "96345 Summit High School 5.60583E+11 No No \n", "96346 Upton Middle School 5.60609E+11 No No \n", "96347 Upton Elementary 5.60609E+11 No No \n", "96348 Upton High School 5.60609E+11 No No \n", "96349 Worland High School 5.60624E+11 No No \n", "96350 Worland Middle School 5.60624E+11 No No \n", "96351 East Side Elementary 5.60624E+11 No No \n", "96352 South Side Elementary 5.60624E+11 No No \n", "96353 West Side Elementary 5.60624E+11 No No \n", "96354 Powder River Basin Children's Center 5.68018E+11 No No \n", "96355 C-Bar-V Ranch 5.68025E+11 No No \n", "96356 Wyoming Girls School 5.68025E+11 Yes No \n", "96357 Wyoming Boys School 5.68025E+11 Yes No \n", "96358 Youth Emergency Services Inc. 5.68025E+11 No No \n", "96359 Saint Stephen's Indian School 5.68025E+11 No No \n", "\n", " SCH_GRADE_KG ... SCH_JJHOURS SCH_JJPART_LT15 SCH_JJPART_15T30 \\\n", "0 No ... -7 -7 -7 \n", "1 No ... -7 -7 -7 \n", "2 No ... -9 -9 -9 \n", "3 No ... -7 -7 -7 \n", "4 No ... -9 -9 -9 \n", "5 No ... -9 -9 -9 \n", "6 No ... -9 -9 -9 \n", "7 No ... -9 -9 -9 \n", "8 Yes ... -9 -9 -9 \n", "9 No ... -9 -9 -9 \n", "10 No ... -9 -9 -9 \n", "11 No ... -9 -9 -9 \n", "12 Yes ... -9 -9 -9 \n", "13 No ... -9 -9 -9 \n", "14 No ... -9 -9 -9 \n", "15 No ... -9 -9 -9 \n", "16 No ... -9 -9 -9 \n", "17 Yes ... -9 -9 -9 \n", "18 Yes ... -9 -9 -9 \n", "19 No ... -9 -9 -9 \n", "20 No ... -9 -9 -9 \n", "21 Yes ... -9 -9 -9 \n", "22 No ... -9 -9 -9 \n", "23 Yes ... -9 -9 -9 \n", "24 Yes ... -9 -9 -9 \n", "25 Yes ... -9 -9 -9 \n", "26 No ... -9 -9 -9 \n", "27 No ... -9 -9 -9 \n", "28 Yes ... -9 -9 -9 \n", "29 No ... -9 -9 -9 \n", "... ... ... ... ... ... \n", "96330 Yes ... -9 -9 -9 \n", "96331 No ... -9 -9 -9 \n", "96332 Yes ... -9 -9 -9 \n", "96333 Yes ... -9 -9 -9 \n", "96334 Yes ... -9 -9 -9 \n", "96335 No ... -9 -9 -9 \n", "96336 Yes ... -9 -9 -9 \n", "96337 No ... -9 -9 -9 \n", "96338 Yes ... -9 -9 -9 \n", "96339 No ... -9 -9 -9 \n", "96340 No ... -9 -9 -9 \n", "96341 Yes ... -9 -9 -9 \n", "96342 Yes ... -9 -9 -9 \n", "96343 Yes ... -9 -9 -9 \n", "96344 Yes ... -9 -9 -9 \n", "96345 No ... -9 -9 -9 \n", "96346 No ... -9 -9 -9 \n", "96347 Yes ... -9 -9 -9 \n", "96348 No ... -9 -9 -9 \n", "96349 No ... -9 -9 -9 \n", "96350 No ... -9 -9 -9 \n", "96351 Yes ... -9 -9 -9 \n", "96352 Yes ... -9 -9 -9 \n", "96353 Yes ... -9 -9 -9 \n", "96354 No ... -9 -9 -9 \n", "96355 No ... -9 -9 -9 \n", "96356 No ... 27 2 5 \n", "96357 No ... 30 17 11 \n", "96358 No ... -9 -9 -9 \n", "96359 Yes ... -9 -9 -9 \n", "\n", " SCH_JJPART_31T90 SCH_JJPART_91T180 SCH_JJPART_OV180 NCESSCH \\\n", "0 -7 -7 -7 10000201705 \n", "1 -7 -7 -7 10000201706 \n", "2 -9 -9 -9 10000201876 \n", "3 -7 -7 -7 10000299995 \n", "4 -9 -9 -9 10000500870 \n", "5 -9 -9 -9 10000500871 \n", "6 -9 -9 -9 10000500879 \n", "7 -9 -9 -9 10000500889 \n", "8 -9 -9 -9 10000501616 \n", "9 -9 -9 -9 10000502150 \n", "10 -9 -9 -9 10000600193 \n", "11 -9 -9 -9 10000600872 \n", "12 -9 -9 -9 10000600876 \n", "13 -9 -9 -9 10000600877 \n", "14 -9 -9 -9 10000600878 \n", "15 -9 -9 -9 10000600880 \n", "16 -9 -9 -9 10000600883 \n", "17 -9 -9 -9 10000600887 \n", "18 -9 -9 -9 10000601413 \n", "19 -9 -9 -9 10000601434 \n", "20 -9 -9 -9 10000601585 \n", "21 -9 -9 -9 10000601685 \n", "22 -9 -9 -9 10000601812 \n", "23 -9 -9 -9 10000602209 \n", "24 -9 -9 -9 10000700091 \n", "25 -9 -9 -9 10000700248 \n", "26 -9 -9 -9 10000700251 \n", "27 -9 -9 -9 10000700337 \n", "28 -9 -9 -9 10000700342 \n", "29 -9 -9 -9 10000701422 \n", "... ... ... ... ... \n", "96330 -9 -9 -9 560576200332 \n", "96331 -9 -9 -9 560576200399 \n", "96332 -9 -9 -9 560576200424 \n", "96333 -9 -9 -9 560576200425 \n", "96334 -9 -9 -9 560576200439 \n", "96335 -9 -9 -9 560576200528 \n", "96336 -9 -9 -9 560582000393 \n", "96337 -9 -9 -9 560583000289 \n", "96338 -9 -9 -9 560583000313 \n", "96339 -9 -9 -9 560583000335 \n", "96340 -9 -9 -9 560583000336 \n", "96341 -9 -9 -9 560583000337 \n", "96342 -9 -9 -9 560583000339 \n", "96343 -9 -9 -9 560583000340 \n", "96344 -9 -9 -9 560583000341 \n", "96345 -9 -9 -9 560583000512 \n", "96346 -9 -9 -9 560609000342 \n", "96347 -9 -9 -9 560609000363 \n", "96348 -9 -9 -9 560609000401 \n", "96349 -9 -9 -9 560624000343 \n", "96350 -9 -9 -9 560624000344 \n", "96351 -9 -9 -9 560624000345 \n", "96352 -9 -9 -9 560624000346 \n", "96353 -9 -9 -9 560624000347 \n", "96354 -9 -9 -9 568018000031 \n", "96355 -9 -9 -9 568025000048 \n", "96356 8 17 50 568025100534 \n", "96357 68 86 8 568025100538 \n", "96358 -9 -9 -9 568025200350 \n", "96359 -9 -9 -9 56802540000\\t \n", "\n", " NAME LAT1516 LON1516 \n", "0 Wallace Sch - Mt Meigs Campus 32.374812 -86.082360 \n", "1 McNeel Sch - Vacca Campus 33.583385 -86.710058 \n", "2 Alabama Youth Services 32.374847 -86.082332 \n", "3 NaN NaN NaN \n", "4 Ala Avenue Middle Sch 34.260194 -86.206174 \n", "5 Albertville High Sch 34.262154 -86.204863 \n", "6 Evans Elem Sch 34.273161 -86.220086 \n", "7 Albertville Elem Sch 34.253251 -86.221834 \n", "8 Big Spring Lake Kinderg Sch 34.290220 -86.192490 \n", "9 Albertville Primary Sch 34.253251 -86.221834 \n", "10 Kate Duncan Smith DAR Middle 34.533721 -86.253681 \n", "11 Asbury Sch 34.362770 -86.142240 \n", "12 Claysville Jr High Sch 34.406429 -86.270689 \n", "13 Douglas Elem Sch 34.176234 -86.321259 \n", "14 Douglas High Sch 34.178157 -86.319947 \n", "15 Grassy Elem Sch 34.344388 -86.442199 \n", "16 Kate D Smith DAR High Sch 34.533721 -86.253681 \n", "17 Union Grove Elem Sch 34.399966 -86.446812 \n", "18 Robert D Sloman Primary 34.176713 -86.323279 \n", "19 Brindlee Mt Middle Sch 34.377158 -86.422337 \n", "20 Brindlee Mt High Sch 34.376400 -86.421876 \n", "21 Kate D Smith DAR Elem Sch 34.533721 -86.253681 \n", "22 Douglas Middle Sch 34.176234 -86.321259 \n", "23 Asbury Elem Sch 34.362794 -86.142507 \n", "24 Trace Crossings Elem Sch 33.340886 -86.844733 \n", "25 Greystone Elem Sch 33.413047 -86.658547 \n", "26 Hoover High Sch 33.344370 -86.837683 \n", "27 Berry Middle Sch 33.395648 -86.732180 \n", "28 South Shades Crest Elem Sch 33.337527 -86.878390 \n", "29 Robert F Bumpus Middle Sch 33.330911 -86.852477 \n", "... ... ... ... \n", "96330 NaN NaN NaN \n", "96331 NaN NaN NaN \n", "96332 NaN NaN NaN \n", "96333 NaN NaN NaN \n", "96334 NaN NaN NaN \n", "96335 NaN NaN NaN \n", "96336 NaN NaN NaN \n", "96337 NaN NaN NaN \n", "96338 NaN NaN NaN \n", "96339 NaN NaN NaN \n", "96340 NaN NaN NaN \n", "96341 NaN NaN NaN \n", "96342 NaN NaN NaN \n", "96343 NaN NaN NaN \n", "96344 NaN NaN NaN \n", "96345 NaN NaN NaN \n", "96346 NaN NaN NaN \n", "96347 NaN NaN NaN \n", "96348 NaN NaN NaN \n", "96349 NaN NaN NaN \n", "96350 NaN NaN NaN \n", "96351 NaN NaN NaN \n", "96352 NaN NaN NaN \n", "96353 NaN NaN NaN \n", "96354 NaN NaN NaN \n", "96355 NaN NaN NaN \n", "96356 NaN NaN NaN \n", "96357 NaN NaN NaN \n", "96358 NaN NaN NaN \n", "96359 NaN NaN NaN \n", "\n", "[96360 rows x 1060 columns]" ] }, "execution_count": 52, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Join on SCHOOL CODE. \n", "final = crdc_data.merge(\n", " school_lat_longs,\n", " how='left',\n", " left_on='NCESSCH',\n", " right_on='NCESSCH',\n", ")\n", "final" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### We're still missing lat/long for a substantial # of schools" ] }, { "cell_type": "code", "execution_count": 53, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 53, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXQAAAD8CAYAAABn919SAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvIxREBQAAIABJREFUeJzt3X+QVWed5/H3t5sGGgQbFNikEwZkWKIuSbf2JGR7djeJIhFmTa9jxJiM2a2p5B9rShIHJQtlwlYyacVJmC2nZiqutRUrjEE0duKSCbJJ2FopQRubH4uBJSghubCAYhskLTTdz/5xz21uX+6Pc+49995zzv28qrq67+/n9IHvefr7fJ/nMeccIiISf031boCIiIRDAV1EJCEU0EVEEkIBXUQkIRTQRUQSQgFdRCQhFNBFRBJCAV1EJCEU0EVEEmJCLT/sve99r5s3b14tP1JEJPb27Nnza+fcrFLPq2lAnzdvHv39/bX8SBGR2DOzN/w8TykXEZGEUEAXEUkIBXQRkYRQQBcRSQgFdBGRhKhplYuMt/SJHRw5fX7s9sLZU9n+4C31a5CIxJp66HWSG8wBjpw+z9IndtSnQSISewrodZIbzEvdLyJSilIuVdI3kGLDtsOcGBzi6rZWVi9bRE9n+9hjIiJhU0Cvgr6BFA89d4Ch4REAUoNDPPTcgbHHs3+u9HMKXTREpPGUDOhmtgjYnHXX+4CvAN/27p8HHAM+7Zz7bfhNjJ8N2w6PBfOMoeERNmw7PPZzIQtnT/X1GcUuGpUEdV0kROKrZA7dOXfYOdfhnOsAPgy8A/wAWAO87JxbCLzs3W4YfQMpuntfYf6arXT3vjIujXJicCjva04MDhV8DIJVuZS6aJQjc5FIDQ7huHyRUIpIJB6CDop+BDjqnHsDuAN42rv/aaAnzIZFWanAd3Vba97XXd3WWvCx9rbWQCWLxS4a5arGRUJEaidoQP8M8B3v5znOuZMA3vfZ+V5gZvebWb+Z9Z85c6b8lkZIqcC3etkiWluaxz3e2tLM6mWLij4WRLGLRrmqcZEQkdrxHdDNbCLwCWBLkA9wzj3lnOtyznXNmlVyOd9YKBX4ejrbefyTi2lva8VI974f/+Riejrbiz4WRFgXhmzVuEiISO0EqXL5OPBz59wp7/YpM7vKOXfSzK4CToffvGi6uq2VVJ6gnh34MsE7n2KP+ZV5fZgDmKuXLRo30AqVXyREpHaCBPS7uJxuAXgBuBfo9b4/H2K76sJvhUdUAl8YF4bc94NwLxIiUjvmnCv9JLMpwJvA+5xzv/Puew/wXWAucBy40zl3ttj7dHV1uajuWJRbBgjpIF0oHVLP8r4wPlvliSLxYWZ7nHNdJZ/nJ6CHJcoBvbv3lbxplPa2Vnauua0OLcov6IWnWu8hIrXjN6Brpqin1EBnbo/21utm8eqhMzXv4RarsPH7+WG8h4hEjwK6p9hAZ75Zmc/sOj72nLBmafoRRmmhyhNFkkmrLXqKlQHm69Hm8jsBp9gMUz8qLS3sG0jRZFbRe4hINCmHnqXQQOH8NVvx+1tq93r6zWaMOEd71vvky11ntLW28MgnPliyh19J/rvY5yuHLhJdyqGXoVAZYKF0TD6Z5414F8rU4BAPbN5L/xtnefXQmYI9/cGhYVZv2TfWjnwyF5yh4ZG8F4xSiv2lMbmlif43zqryRSTGlHLxIV86JggHbNp1vORFYXjUFUzbZK8fA+kLRiYl5KdnXqiKJ+O37wzzjNdGLcwlEk/qoReRnYJ5d2sLk1uaGHxnOFCPPcPBWK+6mEJVNecvXCqrMqVYmqUUVb6IxEtDBnQ/k2pyA+Hg0DCtLc08ubKDns525q3ZGvhzM73qYsH13a0teatqCilVmeJnQLcYVb6IxEfDpVzyLX37wOa9zMupOim1omJLGb+5zEJcba0tBZ9z/uIlHnnhoO8gXKoypdKArMoXkfhouICeL1BnkiCpwSFWb9nHB7/yUsFecSZAXhoN9rnZ+e69D3+MjSs7aMpTPTg84hgcGvb1ngbcel3xFSwLBeQZU1pKjgsYaGEukRhpuJRLqR7r8Khj+GLh3nEmQAbJo+erROnpbOeBzXt9vT5j6sRm3rk4MnYBcsDmn77J1v0nx3L7uTNYb71uFt/fk7qizPHhf/9BIH2BK3QcjupPlBKR8DRcQC9nQDMj08vuG0hx/sIlX6+5Z8lcHu1ZDFzO3Wfq1IsNjxqMe7y1pZmW5iYc4y82w6OO376T7tHnm8GafTtjaHiEv3/1CNsfvIWezvai69hkaDEvkehruJRLJSWI0yenX/fQcwd8p0VePZTepSlf2WExjnRQh8u599/5/Ew/jpw+z9IndgClN8vQXqMi8dBwAT17xyC4HDT9OHXuIg9u3huoaiST4ln/Q/8DnRmOy6s99nS2hz5AeeT0eaD4DkugvUZF4qLhUi4wfkZobq35uQuXGBkt3HsOOBbK5JYm+gZSY2mRoLJz/vk21qhUpvxyzrSJ7F67tGQb/NwvIvWR2ICeG6jNGBs4zM7/5k737xtIsf6HB8sOwLmGhkdZ/8ODZb8+d1s7YNxxnb94ieGRytfjOXXuIvPWbMW8z8z+HfnZck9E6i+Ri3OVmh3pZyGqYhOHcgcsq8VPO7MvXNVokwH/esFMfn78d9oQQ6RO/C7OlcgceqnZkX7yvwtnTy14/91L5gbKvfu1cPbUgnnsQno629m55jZ+1btiXFVKWByw8+hZRp2jrbUlUNtEpLYSGdD95HZLPWf7g7dcEdQXzp7K529dyKuHzgTqDRvQ0jz+EtDa0szGlR0c613BxpUdzJjSwpHT50l5qZRbr5vFhm2HA62bXmoSUOZiUY4Ll0b53dAwdy+ZOzZIKyLRksiA7ie36+c52x+8hWO9K7hnyVzM0lUhqzbvLWthruERNzYzNLuH2zeQYvX39o3L2Q8OlbfyYakgm+nJz5k2MVD7s49j067jKlcUiahEBvRStebZNdalrOs7wDO7jhPGUMOoS/fUz1+4xAOb99Ld+wrrf3jQ16BmsTRR30CKjvU/Kpr3z07H7F67tKKgrnJFkWhKZJVLvmqQQlUupXxn95uhti17rZagPf18aaK+gRSrt+xjuEipZb4L2B/Pfhenzp0N9PnF2iEi9ZfIgA6Fdx8Kom8gVXJGZy3lSxNt2Ha4aDCfMaUF5+CBzXvZsO0wq5ctYkv/cXYeLS+YF2qHiNRfYgN6JfoGUjzywkHf0/troVCaqFRvOTs3n8nFVzIxKUi6SkRqK5E59EpkatjrGczN0ot6+SlhDNpbDhLMW5rNdztEpP7UQ89R6Q4/oXCMrdBYTJBVH4MKsvm0iESDAnqOKAz4+el1r+s7wKZdx6syOzSzIJiIxItSLjnqPeDnJ0fdN5BKl1LW6fNFJJp8BXQzazOz75nZITN7zcxuNrOZZrbdzI5432dUu7G1sHrZoitmdVZDvk+YMaVl3ISj7t5X8s4UXfuDA1Vp06QJTcqRi8SY3x763wEvOeeuA24AXgPWAC875xYCL3u3k6FKlYpGerDzWO8KnlzZMW6wcePKDga+8jF6OttZ13eAB7wZqflmip4vskVeJS5cGlUwF4mxkjl0M5sO/FvgPwI45y4CF83sDuAW72lPAzuAL1ejkbVUqq47KAOeXNnhO1BmZqbm0oYSIlKKn0HR9wFngP9uZjcAe4AvAHOccycBnHMnzWx29ZpZO2EPit69ZO4VwTw3aKcGh1i9ZR/9b5xlU55gnt22StZWD5vffUZz91IdcU5VNCJV4CegTwA+BPyVc263mf0dAdIrZnY/cD/A3Llzy2pkLVWyiXSujVk98+ygls/wqMvbMw+7bZmAmk/3gpm+3yd3zflMWgi4YsOQ7OdlPrvQ80WkfH5y6G8Bbznndnu3v0c6wJ8ys6sAvO+n873YOfeUc67LOdc1a9asMNpcVZVsIp1r1ea9LHjoRZY+saOsVRrzta0SrS3N/O2nb+BY74orgnf3gplsuu9m3+/ld5/RYnX9SiOJhKtkD9059//M7E0zW+ScOwx8BPiF93Uv0Ot9f76qLa2R3IW9MqmETDokaHZ9xLmxzZjDaNuqzXvLem1uiiNI8M7H7z6jpVJYUaj7F0kKvxOL/grYZGYTgV8C/4l07/67ZvaXwHHgzuo0sfbyLezV09lO1x/NHEubmBHKkrp++d2NaPqkZt6+cLlHHLTn7ZfffUZLpYkc6e3+jvWuCLuJIg3HV0B3zu0F8u1n95FwmxNt+QL9/DVbq76/aPZkn+4FMwuulFit4J3P6mWLrljoK9+kpNXLFvn6q0JBXaRymvpfoTAHUbNlNqLOpEqg8MbVtQzkGYVSUxrgFKkfczXMG3R1dbn+/v6afV4t5FZxhKHZjLtuupat+0+OW/62kKj2bIP+bqJ6HCL1ZmZ7nHP5siTjaC2XCvV0tvP4JxePm/XZvWAmzZae3N9sRveCmcyY0uLr/ZoM7rrpWjb/7E1fwRyI7B6fkVi5UqSBNEzKxe8kmHIE2R2pu/eVgimaSROa+OqfX5+erepjn9GMDdsORzLVEbSCpW8gFcnjEImLhuihZ/70L7Q2Sq3aUCyYG3D40Y/T09keyl6jURB05cpVm/cyb81W7v7mT6rUIpFka4iAXmgSzBe/u68mQT37glJIdvDLpGv8qveSv4WUO0lr59GzCuwiZWiIgF6oBzviXE166qVyybnlfkE2po7y+uXZ4wvl2Hn0rIK6SAANEdCL9WBrMf28WM88ew30DL8BMA57fPZ0tle0+9HOo2eLrg0vIpc1REAv9ad/NXPQpYLPlIkTrgjIpdrb2tLMxpUd7FxzW6SDebbJFWwaUu/xD5G4aIiAnvnTv1Buupo56FK9/3wXk9xSyLbWFmZMaRkri4x6rzyfQ48tLzuo+1kETEQaqGwxEwD9TFevVHaJZKlseKGLSZBSyLg49NjyopU+QUS1skeknhomoEN409WzA/a7W1swg8F3hrm6rZVbr5vF9/ekfE2oaaLyJXHjJt8aMOWIamWPSD01VECHynu+udPZB4cuz+ZMDQ75XmK3pQk23Ol/a7qkyL6olttTj3Jlj0g9NVxAr1SpEsRiwdxAi1gx/qJaaMGxfPT7EylOAb2AQksFlJu7bW9rrah8L6nmTJvIqXMXfT33V1q8S6QoBfQc6/oO8E+7jzOa1dXO3v/Sz3K5maVvM5QiKGz32qVc//BL4zblEJHyNETZol/r+g7wzK7xwTwjUyrnp0b87iVzx62+GMcyw1rav/52Nq7sGPud5aOldUVKUw89y3d2v1n08RODQ1dUyuRWuSi/W54klmmK1JoCepZSa6hkSuUUfEQkipRyyVJslUPlwUUk6hTQs9x107V5729taVIeXEQiTymXLI/2LAbSufQR58b29szcLyISZbHeJLqa28qJiESF302iI99DLxS0c6fgZ9eKK6iLSCOKdEAvFrQLbSsX1Q2TRUSqLdKDosWCdqEp+FpWVUQaVaQDerGgXWj5VC2rKiKNKtIBvVjQzjcFX7XiItLIIh3QiwXt3G3atGaKiDQ6X4OiZnYMOAeMAJecc11mNhPYDMwDjgGfds79NszGldphSFPwRUQu81WH7gX0Lufcr7Pu+xpw1jnXa2ZrgBnOuS8Xe5+w69BFRBqB3zr0SlIudwBPez8/DfRU8F4iIlIhvwHdAT8ysz1mdr933xzn3EkA7/vsajRQRET88TuxqNs5d8LMZgPbzeyQ3w/wLgD3A8ydO7eMJoqIiB++Arpz7oT3/bSZ/QC4EThlZlc5506a2VXA6QKvfQp4CtI59HCaLVJ/mWUpUoNDNJtdsZ7+9EnNTGudSGpw6IptCTOagNGs22aQb1irva2VKRObOHL6vK+2dS+Yyab7bvZ7KGP6BlKs/cEBzl8sviVgue8v1VVyUNTMpgJNzrlz3s/bgf8CfAT4Tdag6Ezn3JeKvZcGRSUpMtsVRlnQoNs3kOKLW/Yxkm8Pxip8nvgX5qDoHODHZrYP+Cmw1Tn3EtALLDWzI8BS77ZI4vUNpCIfzAF2Hj0b6Pkbth0uO5hnPu/ub/6k7NdL5UqmXJxzvwRuyHP/b0j30kUayvofHqx3E6oijHWQgl5EJFyRXm1RJGr6BlL89p3hejejKq5uayUVQlCft2YrAHOmTWR6a8u4vH8T8MTKDk0IrBIFdJEANmw7XO8m+DZ9UnPpJ2VZvWwRqzbvDe3zT527yKlzF8fdNwqs2ryX/jfO8uqhM9qcJmQK6CIBxGl55rcvFK9UydXT2R5qQC8mewwiSZvT3PTY9isuYrUcLI704lwiUaPlmasjs89BnOUL5pAeV7hu7Ys1aYMCukgAWp65elKDQ/QNpOjufYX5a7bS3fsKfQOpejfLt3zBPOMPI46lT+yoehuUchEJoJZpiUp1L5gZ+DULZ0/1PXmpGrJ/t6nBIVZt3nvF7/tY74paNysUtfi9qocuklDl5G23P3hL+A0JWaaKRq6kgC4SQJxSAEmm85CfUi4iAcR94C4pvrhlH1DfqpjMWj7F9jiuNfXQRQKIU9liko2MurpeXPsGUjz03AFSg0M4CGVCVhgU0EUCiEpPTOobRDdsO8zQcLA6f6Dqa90o5SISQNizKatl4eyp9W4Cx3pXFKzNDstNj21n99qlFb/P0id2lKxC6V4wk9dP/76i48ksYFatiUYK6CIBZHK2UQ/qn791Yb2bADAu2PoJmkFVerHoG0j5PpdhLTxWzQXMlHIRCaj/jeivKFhJfrklpKgwP6e8cPuDt5RVG18tQYJ5XCigiwQUh7XQKxm83XBnRyhtcFxZM77pvpsjMTEoicEcFNBFEqmSwduwSwHzTQQKuhJkMUGn1Cc1mIMCukgsTZ3YXDA10trSHLk1Z65/+KVxt/evvz20oH7k9PlAQT3Jcwk0KCoSIe1lrA2eO8ElimuL51vKd//624FwpvLnG2ytxiBsGO5ZMrdq762ALhIhO9fcFvg1PZ3tkQvg9RbVYN69YCaP9iyu2vsroIskwLq+A2zadZzyt3iOv+z67igG84012HpPAV0kgCguCrWu70AsKm+qvUpiVDeoruWORQroIgFUc0Ct3EHC7+x+M+SWxFsUlted2Gx87VM31DwVpoAuDaFvIMUjLxxkcGgYSFeJOOd4Z3j0iue2NMGlUcYGGIGxQcdqpjQyg4RBjbhGTrSMl1tNUw/1rLNXQJfEy1d3fP5i4YWVMjE+NTjE6i37wGB4REEz6roXzIxE2mVd34GqDnwWozp0SbxKJpEMjzoF85ioVZ66lHqOZyigi0jsTW62ejchEhTQRSJgzrSJ9W5CrB16bHm9mxAJyqGLRECpNb1zB3XlsuyZlxtXdiR2nRY/FNAl0db1Hah3E4qaM21i3mCemc4fla3Nomr6pOZxA5BxWa++WnwHdDNrBvqBlHPuz8xsPvAsMBP4OfAXzrnqbU0iUoaoTbgpVdK2ru8A/7T7OKMahy1p4eypbH/wlivuD7oUQhTq1sMSpIf+BeA1YLp3+6vAk865Z83sH4G/BP4h5PaJNIy4zPistzDrvKvxF1w9N/HwFdDN7BpgBfAY8KCZGXAb8FnvKU8Dj6CALlI2zfgMT70W56rlNP98/PbQNwJfAqZ5t98DDDrnLnm33wK03JtEjkFkFqwq1XPTjM9w1CqY12KxraBKli2a2Z8Bp51ze7LvzvPUvP8azex+M+s3s/4zZ86U2UyR8txdxbWng/DTc2s21VKHodrBfM60iRzrXRG5YA7+eujdwCfMbDkwmXQOfSPQZmYTvF76NcCJfC92zj0FPAXQ1dWlLojU1KM9iyORl76zq/SFZcn7ZkRi6nrUZQYxm82466ZrazbNPgp7oZZSsofunHvIOXeNc24e8BngFefc3cCrwKe8p90LPF+1VopUIAo7zftZpfHYb1SiGMSIczyz63hNqlQmxOSPp0pmin6Z9ADp66Rz6t8Kp0ki4YrCGh8nfNSTq+a8fNUO6q8/Hv3eOQScWOSc2wHs8H7+JXBj+E0SSZ6r21pLPidKA7hxNn1Sc949TBuB1nIRqYFbr5tV8jkK5uHYv/72sjcLyScOufMMTf2XhjBn2kROnavfRObv/uzNuq2R3Siy9xTNt1lIOWmZjSs7Km5XLamHLg1h99qldV1i9aLWVK+6UhVC5Zz/KJYmFqMeujSMQ48tr+u6HYU+e/qk5rK3nxP/gp7/MNM2taIeujSUeyIy0Sjb2xdGErVAVJQd613huwQxjhdZczWcbtzV1eX6+/tr9nki+Sh4SjGTmy1yG2aY2R7nXFep56mHLiKS5VN/cm29m1A2BXRpOHEqQ5Pai8JSEeVSQJeGFJep3CJBKKBLQ4rLVO5qOta7gmO9K7hnyVyt9JgQKlsUSbhCW7VlPNqz2NekJw0mR5966NKw4jYLsFyzp02qdxNiJ+qbixeigC4Nq6ezPZJ16WHTGuvBxXU7QAV0aWiP9ixmzrSJ9W6GRExctwNUQJeGt3vt0no3QSImroPECugiqIxRxrvrpnhOLlJAF0FljJLWbMY9S+bGdqljlS2KiFC6vDMO1EMX8WhJgGQo5zwmIZiDeugi42SCgSbRxNs9S+aWXJPFgF8l7CKuHrpIHsd6V8Ryg4NqWjh7ar2b4MvSJ3bwaM9iuhfMLPq8JxM4sUwBXaSA/etv51jvCtrbWuvdlEiIS0riyOnz9A2k2HTfzWxc2TF2/jKliO1trWxc2RG77eX8UMpFpITVyxbx0HMHGBoeqXdTxKdVm/fS09k+9tUo1EMXKaGns53HP7lYPfWYiet6LJVQQBfxoaeznZ1rbqt3MySAuK7HUgkFdBFJpLiux1IJBXSRAIrVOE+akP+/U703kChV7RFEnNJOcV2PpRIaFBUJqJyJK4/2LK5abXv3gpkFl8jtXjCTTffdHNpnrV62iFWb94b2ftUU1/VYKqGALlIjG1d2BA6GE5qMS6OFUwe1Lr/r6Wzn8Rd/walzF2v2meWI83oslSiZcjGzyWb2UzPbZ2YHzWy9d/98M9ttZkfMbLOZaVFpkSLK2VDj9b9ZPrbvZ1NWBqG1palutdQPLf9AzT8zqEYM5gDmSgwcmJkBU51zvzezFuDHwBeAB4HnnHPPmtk/Avucc/9Q7L26urpcf39/SE0Xiae+gZSvnnpU15bp7n2F1OBQvZtRVFR/d+Uysz3Oua5SzyuZcnHpiP9772aL9+WA24DPevc/DTwCFA3oIkLsJ7tEPZhDei2epAV1P3xVuZhZs5ntBU4D24GjwKBz7pL3lLeAvP9Czex+M+s3s/4zZ86E0WYRqaNGrB6JC18B3Tk34pzrAK4BbgTen+9pBV77lHOuyznXNWvWrPJbKiKR0Ij13XERqA7dOTcI7ACWAG1mlknZXAOcCLdpIhJFcalFn9+ASyCXzKGb2Sxg2Dk3aGatwEeBrwKvAp8CngXuBZ6vZkNFJBrCXKwsN88dZq1+I/4d4acO/SrgaTNrJt2j/65z7n+Y2S+AZ83sUWAA+FYV2ykiEZEZ0N2w7TCpwSGazcpKw+TLxWcC/N3f/Mm4yVJNwGh5zW0oJcsWw6SyRZHk89vLDjr5p2P9jxgcGg7cniRUu4RWtigiEkR2AF36xA6OnD4/7vEmg8/eFHwm56xpE8sK6I1EAV1EqibMXY5yLwxyJa22KCKSEAroIpJo1VrlMooU0EVEEkIBXURiIcyNOpJKAV1EYiHMjTqSSgFdRCQhFNBFJDaSMEmomhTQRSRWprQobBWi34yIxMrffPL6ejchshTQRSRW4rzbU7UpoItI7CiXnp8CuojETiPN/gxCAV1EEq2RevMK6CKSWNMnNde7CTWlgC4iiTR9UjP7199e72bUlNZDF5FEWTh7aqjrsMeJeugiEjuF8uL3LJnbsMEc1EMXkZhqpMFOv9RDFxFJCPXQq+z6h1/i7QsjY7cbcaBGRGpDPfQqmrdm67hgDvD2hRGuf/ilOrVIRJJMPfQquW7tiwUfe/vCyNhMN/XYRSQs6qFXyR9GnK/nZQd3EZFKKKBHxLw1W1nXd6DezRCRGFNAj5Bndh1n3pqt9A2k6t0UEYkhBfQqmdxsZb921ea9CuoiEpgCepUcemx5RUF99Za9IbZGRBpByYBuZtea2atm9pqZHTSzL3j3zzSz7WZ2xPs+o/rNjZdDjy3nWO+Ksma0DY8Wr5QREcnlp4d+Cfiic+79wBLg82b2AWAN8LJzbiHwsndbCignqP9hxKkCRkR8M+f8ldeNvcDseeAb3tctzrmTZnYVsMM5t6jYa7u6ulx/f3/ZjU2S3BmkpWjdCpHGZWZ7nHNdpZ4XKIduZvOATmA3MMc5dxLA+z67wGvuN7N+M+s/c+ZMkI9LtP3rb6d7wUzfz9cgqYiU4jugm9m7gO8Dq5xzb/t9nXPuKedcl3Oua9asWeW0MbE23Xez7+du2Ha4ii0RkSTwFdDNrIV0MN/knHvOu/uUl2rB+366Ok0UgBODQ/VugohEnJ8qFwO+BbzmnHsi66EXgHu9n+8Fng+/eZJxdVtrvZsgIhHnp4feDfwFcJuZ7fW+lgO9wFIzOwIs9W5LQH7z6KuXFR1vFhEpvdqic+7HQKEZMh8JtzmNZ9N9N/PH//lFLo0WrjbauLKDns72GrZKROJIM0Uj4Ot33kBz05XXzCZTMBcR/xTQI6Cns52/vfMGZkxpGbuvrbWFJz6tYC4i/mmDi4jo6WxX8BaRiqiHLiKSEAroIiIJoYAuIpIQCugiIgmhgC4ikhCBl8+t6MPMzgBv5HnovcCva9aQ2krysUGyjy/JxwbJPr6kHdsfOedKrm5Y04BesBFm/X7W+o2jJB8bJPv4knxskOzjS/KxFaOUi4hIQiigi4gkRFQC+lP1bkAVJfnYINnHl+Rjg2QfX5KPraBI5NBFRKRyUemhi4hIhWoa0M3sTjM7aGajZtaVdX+LmT1tZgfM7DUzeyjrsdvN7LCZvW5ma2rZ3qAKHZ/32PVm9hPv8QNmNtm7/8Pe7dfN7L96O0RFTrFj8x6fa2a/N7O/zrov9ufOzJaa2R7vHO0xs9uyHov9uTOzh7z2HzazZVn3x+bcZTOzDjPb5W2UuvThAAADvElEQVTE029mN3r3m3eOXjez/Wb2oXq3tSqcczX7At4PLAJ2AF1Z938WeNb7eQpwDJgHNANHgfcBE4F9wAdq2eaQjm8CsB+4wbv9HqDZ+/mnwM2kNxH5Z+Dj9T6OIMeW9fj3gS3AX3u3k3LuOoGrvZ//FZDKeizW5w74gHdeJgHzvfPVHLdzl3OsP8qcB2A5sCPr53/2ztUSYHe921qNr5oun+ucew0gT0fGAVPNbALQClwE3gZuBF53zv3Se92zwB3AL2rV5iCKHN/HgP3OuX3e837jPe8qYLpz7ife7W8DPaT/4UVKkWPDzHqAXwLns+5OxLlzzg1k3TwITDazScBM4n/u7iDdkboA/MrMXid93iBG5y6HA6Z7P78bOOH9fAfwbZeO7rvMrM3MrnLOnaxHI6slKjn075EOBieB48DXnXNngXbgzaznveXdFzf/EnBmts3Mfm5mX/Lubyd9TBmxOz4zmwp8GVif81BSzl22PwcGvAAY+3NH4XMU53O3CthgZm8CXwcy6ds4H5NvoffQzex/Av8iz0NrnXPPF3jZjcAIcDUwA/jf3vvky0nWtSynzOObAPwp8CfAO8DLZraH9F8huep2fGUe23rgSefc73N6gEk5d5nXfhD4Kum/tiBix1fmsRU6hnwdvciUwxU7VtL7HD/gnPu+mX0a+BbwUSJ2vqol9IDunPtoGS/7LPCSc24YOG1mO4Eu0lfUa7Oedw2X/4SqizKP7y3gfznnfg1gZi8CHwKeIX1MGXU9vjKP7SbgU2b2NaANGDWzPwB7SMa5w8yuAX4AfM45d9S7+y3if+7eovA5itS5y1bsWL3U1xe8m1uA/+b9XOxYEyMqKZfjwG3eSPRU0oMWh4CfAQvNbL6ZTQQ+A7xQx3aWaxtwvZlN8cYJ/h3wCy9/d87MlngVEp8DivYUo8Y592+cc/Occ/OAjcDfOOe+QULOnZm1AVuBh5xzOzP3J+HckT4fnzGzSWY2H1hIeqA3zufuBOn/XwC3AUe8n18APufFmCXA75KWPwdqXuXyH0hfKS8Ap4Bt3v3vIn01PUh64GV11muWA/+X9Kj72nqPIpdzfN5j93jH93+Ar2Xd3+XddxT4Bt5kr6h9FTu2rOc8glflkpRzB6wjPb6zN+trdlLOHek0xVHgMFlVOnE6dznH+qek/zrcB+wGPuzdb8Dfe8dzgDyVWkn40kxREZGEiErKRUREKqSALiKSEAroIiIJoYAuIpIQCugiIgmhgC4ikhAK6CIiCaGALiKSEP8fZJkRxOWXy3gAAAAASUVORK5CYII=\n", "text/plain": [ "
" ] }, "metadata": { "needs_background": "light" }, "output_type": "display_data" } ], "source": [ "plt.scatter(x=final['LON1516'], y=final['LAT1516'])" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### B. Merge with LEA (District) Data" ] }, { "cell_type": "code", "execution_count": 57, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
LEAIDLEA_LAT1516LEA_LON1516
0010024032.462750-86.474211
1010027030.911431-87.787485
2010030031.878283-85.453785
3010141031.868304-85.151290
4010002833.167521-87.191200
5010036032.945405-87.143254
6010042033.945640-86.476448
7010255033.933262-86.495930
8010048032.144541-85.716350
9010051031.815298-86.628715
10010009033.707086-85.821631
11010054033.697530-85.824331
12010186033.815375-85.761522
13010263533.615880-85.835271
14010276033.926817-85.615822
15010060032.890345-85.382695
16010198032.868360-85.191461
17010063034.151788-85.678430
18010066032.868550-86.621991
19010069032.079440-88.233236
20010072031.709818-87.780277
21010330031.887730-87.735221
22010075033.274462-85.835284
23010078033.677803-85.552196
24010003831.418700-85.894400
25010081031.410900-86.056300
26010126031.428518-86.101554
27010132031.323218-85.851124
28010084034.714834-87.702449
29010252034.733552-87.635204
............
18832560001444.775594-107.016285
18833560568044.637273-106.381798
18834560569044.906370-107.173864
18835560569544.799510-106.951301
18836560126042.538186-110.114744
18837560486042.872895-109.861242
18838560530241.587910-109.252991
18839560576241.510680-109.465821
18840560001543.434100-110.860500
18841560583043.462312-110.797767
18842568025043.535575-110.830607
18843560276041.265200-110.968900
18844560426041.327948-110.290546
18845560450041.270593-110.340170
18846560582044.036012-107.447922
18847560624044.011520-107.943721
18848560483043.851100-104.208200
18849560609044.101000-104.623594
18850630001913.475196144.736443
18851660000213.476911144.800161
18852720003018.155370-65.987770
18853780000217.702500-64.866900
18854780003018.336545-64.889056
18855630000749.30534610.635923
18856630001037.527461126.980962
18857630001126.346153127.784655
18858630002352.3943010.536978
18859630002449.4288407.697105
18860630002545.54883511.578043
18861630002635.729377139.345405
\n", "

18862 rows × 3 columns

\n", "
" ], "text/plain": [ " LEAID LEA_LAT1516 LEA_LON1516\n", "0 0100240 32.462750 -86.474211\n", "1 0100270 30.911431 -87.787485\n", "2 0100300 31.878283 -85.453785\n", "3 0101410 31.868304 -85.151290\n", "4 0100028 33.167521 -87.191200\n", "5 0100360 32.945405 -87.143254\n", "6 0100420 33.945640 -86.476448\n", "7 0102550 33.933262 -86.495930\n", "8 0100480 32.144541 -85.716350\n", "9 0100510 31.815298 -86.628715\n", "10 0100090 33.707086 -85.821631\n", "11 0100540 33.697530 -85.824331\n", "12 0101860 33.815375 -85.761522\n", "13 0102635 33.615880 -85.835271\n", "14 0102760 33.926817 -85.615822\n", "15 0100600 32.890345 -85.382695\n", "16 0101980 32.868360 -85.191461\n", "17 0100630 34.151788 -85.678430\n", "18 0100660 32.868550 -86.621991\n", "19 0100690 32.079440 -88.233236\n", "20 0100720 31.709818 -87.780277\n", "21 0103300 31.887730 -87.735221\n", "22 0100750 33.274462 -85.835284\n", "23 0100780 33.677803 -85.552196\n", "24 0100038 31.418700 -85.894400\n", "25 0100810 31.410900 -86.056300\n", "26 0101260 31.428518 -86.101554\n", "27 0101320 31.323218 -85.851124\n", "28 0100840 34.714834 -87.702449\n", "29 0102520 34.733552 -87.635204\n", "... ... ... ...\n", "18832 5600014 44.775594 -107.016285\n", "18833 5605680 44.637273 -106.381798\n", "18834 5605690 44.906370 -107.173864\n", "18835 5605695 44.799510 -106.951301\n", "18836 5601260 42.538186 -110.114744\n", "18837 5604860 42.872895 -109.861242\n", "18838 5605302 41.587910 -109.252991\n", "18839 5605762 41.510680 -109.465821\n", "18840 5600015 43.434100 -110.860500\n", "18841 5605830 43.462312 -110.797767\n", "18842 5680250 43.535575 -110.830607\n", "18843 5602760 41.265200 -110.968900\n", "18844 5604260 41.327948 -110.290546\n", "18845 5604500 41.270593 -110.340170\n", "18846 5605820 44.036012 -107.447922\n", "18847 5606240 44.011520 -107.943721\n", "18848 5604830 43.851100 -104.208200\n", "18849 5606090 44.101000 -104.623594\n", "18850 6300019 13.475196 144.736443\n", "18851 6600002 13.476911 144.800161\n", "18852 7200030 18.155370 -65.987770\n", "18853 7800002 17.702500 -64.866900\n", "18854 7800030 18.336545 -64.889056\n", "18855 6300007 49.305346 10.635923\n", "18856 6300010 37.527461 126.980962\n", "18857 6300011 26.346153 127.784655\n", "18858 6300023 52.394301 0.536978\n", "18859 6300024 49.428840 7.697105\n", "18860 6300025 45.548835 11.578043\n", "18861 6300026 35.729377 139.345405\n", "\n", "[18862 rows x 3 columns]" ] }, "execution_count": 57, "metadata": {}, "output_type": "execute_result" } ], "source": [ "LEA_LAT_LONG_FILE = 'EDGE_GEOCODE_PUBLICLEA_1516/EDGE_GEOCODE_PUBLICLEA_1516.csv'\n", "lea_lat_long_cols_of_interest = ['LEAID', 'LAT1516', 'LON1516']\n", "lea_lat_longs = pd.read_csv(\n", " LEA_LAT_LONG_FILE,\n", " usecols=lea_lat_long_cols_of_interest,\n", " dtype={'LEAID': str},\n", " low_memory=False,\n", " encoding = \"ISO-8859-1\"\n", ")\n", "lea_lat_longs = lea_lat_longs.rename(index=str, columns={\"LAT1516\": \"LEA_LAT1516\", \"LON1516\": \"LEA_LON1516\"})\n", "lea_lat_longs" ] }, { "cell_type": "code", "execution_count": 58, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "LEAID object\n", "LEA_LAT1516 float64\n", "LEA_LON1516 float64\n", "dtype: object" ] }, "execution_count": 58, "metadata": {}, "output_type": "execute_result" } ], "source": [ "lea_lat_longs.dtypes" ] }, { "cell_type": "code", "execution_count": 59, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
LEA_STATELEA_STATE_NAMELEAIDLEA_NAMESCHIDSCH_NAMECOMBOKEYJJSCH_GRADE_PSSCH_GRADE_KG...SCH_JJPART_15T30SCH_JJPART_31T90SCH_JJPART_91T180SCH_JJPART_OV180NCESSCHNAMELAT1516LON1516LEA_LAT1516LEA_LON1516
0ALALABAMA100002Alabama Youth Services1705Wallace Sch - Mt Meigs Campus10000201705YesNoNo...-7-7-7-710000201705Wallace Sch - Mt Meigs Campus32.374812-86.082360NaNNaN
1ALALABAMA100002Alabama Youth Services1706McNeel Sch - Vacca Campus10000201706YesNoNo...-7-7-7-710000201706McNeel Sch - Vacca Campus33.583385-86.710058NaNNaN
2ALALABAMA100002Alabama Youth Services1876Alabama Youth Services10000201876NoNoNo...-9-9-9-910000201876Alabama Youth Services32.374847-86.082332NaNNaN
3ALALABAMA100002Alabama Youth Services99995AUTAUGA CAMPUS10000299995YesNoNo...-7-7-7-710000299995NaNNaNNaNNaNNaN
4ALALABAMA100005Albertville City870Albertville Middle School10000500870NoNoNo...-9-9-9-910000500870Ala Avenue Middle Sch34.260194-86.206174NaNNaN
5ALALABAMA100005Albertville City871Albertville High Sch10000500871NoNoNo...-9-9-9-910000500871Albertville High Sch34.262154-86.204863NaNNaN
6ALALABAMA100005Albertville City879Evans Elem Sch10000500879NoNoNo...-9-9-9-910000500879Evans Elem Sch34.273161-86.220086NaNNaN
7ALALABAMA100005Albertville City889Albertville Elem Sch10000500889NoNoNo...-9-9-9-910000500889Albertville Elem Sch34.253251-86.221834NaNNaN
8ALALABAMA100005Albertville City1616Big Spring Lake Kinderg Sch10000501616NoYesYes...-9-9-9-910000501616Big Spring Lake Kinderg Sch34.290220-86.192490NaNNaN
9ALALABAMA100005Albertville City2150Albertville Primary Sch10000502150NoYesNo...-9-9-9-910000502150Albertville Primary Sch34.253251-86.221834NaNNaN
10ALALABAMA100006Marshall County193Kate Duncan Smith DAR Middle10000600193NoNoNo...-9-9-9-910000600193Kate Duncan Smith DAR Middle34.533721-86.253681NaNNaN
11ALALABAMA100006Marshall County872Asbury Sch10000600872NoNoNo...-9-9-9-910000600872Asbury Sch34.362770-86.142240NaNNaN
12ALALABAMA100006Marshall County876Claysville Jr High Sch10000600876NoYesYes...-9-9-9-910000600876Claysville Jr High Sch34.406429-86.270689NaNNaN
13ALALABAMA100006Marshall County877Douglas Elem Sch10000600877NoYesNo...-9-9-9-910000600877Douglas Elem Sch34.176234-86.321259NaNNaN
14ALALABAMA100006Marshall County878Douglas High Sch10000600878NoNoNo...-9-9-9-910000600878Douglas High Sch34.178157-86.319947NaNNaN
15ALALABAMA100006Marshall County880Brindlee Mountain Elementary School10000600880NoYesNo...-9-9-9-910000600880Grassy Elem Sch34.344388-86.442199NaNNaN
16ALALABAMA100006Marshall County883Kate D Smith DAR High Sch10000600883NoNoNo...-9-9-9-910000600883Kate D Smith DAR High Sch34.533721-86.253681NaNNaN
17ALALABAMA100006Marshall County887Brindlee Mountain Primary School10000600887NoYesYes...-9-9-9-910000600887Union Grove Elem Sch34.399966-86.446812NaNNaN
18ALALABAMA100006Marshall County1413Robert D Sloman Primary10000601413NoYesYes...-9-9-9-910000601413Robert D Sloman Primary34.176713-86.323279NaNNaN
19ALALABAMA100006Marshall County1434Brindlee Mt Middle Sch10000601434NoNoNo...-9-9-9-910000601434Brindlee Mt Middle Sch34.377158-86.422337NaNNaN
20ALALABAMA100006Marshall County1585Brindlee Mt High Sch10000601585NoNoNo...-9-9-9-910000601585Brindlee Mt High Sch34.376400-86.421876NaNNaN
21ALALABAMA100006Marshall County1685Kate D Smith DAR Elem Sch10000601685NoYesYes...-9-9-9-910000601685Kate D Smith DAR Elem Sch34.533721-86.253681NaNNaN
22ALALABAMA100006Marshall County1812Douglas Middle Sch10000601812NoNoNo...-9-9-9-910000601812Douglas Middle Sch34.176234-86.321259NaNNaN
23ALALABAMA100006Marshall County2209Asbury Elem Sch10000602209NoYesYes...-9-9-9-910000602209Asbury Elem Sch34.362794-86.142507NaNNaN
24ALALABAMA100007Hoover City91Trace Crossings Elem Sch10000700091NoYesYes...-9-9-9-910000700091Trace Crossings Elem Sch33.340886-86.844733NaNNaN
25ALALABAMA100007Hoover City248Greystone Elem Sch10000700248NoNoYes...-9-9-9-910000700248Greystone Elem Sch33.413047-86.658547NaNNaN
26ALALABAMA100007Hoover City251Hoover High Sch10000700251NoNoNo...-9-9-9-910000700251Hoover High Sch33.344370-86.837683NaNNaN
27ALALABAMA100007Hoover City337Berry Middle Sch10000700337NoNoNo...-9-9-9-910000700337Berry Middle Sch33.395648-86.732180NaNNaN
28ALALABAMA100007Hoover City342South Shades Crest Elem Sch10000700342NoNoYes...-9-9-9-910000700342South Shades Crest Elem Sch33.337527-86.878390NaNNaN
29ALALABAMA100007Hoover City1422Robert F Bumpus Middle Sch10000701422NoNoNo...-9-9-9-910000701422Robert F Bumpus Middle Sch33.330911-86.852477NaNNaN
..................................................................
96330WYWYOMING5605762Sweetwater County School District #2332Washington Elementary5.60576E+11NoNoYes...-9-9-9-9560576200332NaNNaNNaN41.510680-109.465821
96331WYWYOMING5605762Sweetwater County School District #2399Lincoln Middle School5.60576E+11NoNoNo...-9-9-9-9560576200399NaNNaNNaN41.510680-109.465821
96332WYWYOMING5605762Sweetwater County School District #2424Jackson Elementary5.60576E+11NoNoYes...-9-9-9-9560576200424NaNNaNNaN41.510680-109.465821
96333WYWYOMING5605762Sweetwater County School District #2425Truman Elementary5.60576E+11NoNoYes...-9-9-9-9560576200425NaNNaNNaN41.510680-109.465821
96334WYWYOMING5605762Sweetwater County School District #2439Harrison Elementary5.60576E+11NoNoYes...-9-9-9-9560576200439NaNNaNNaN41.510680-109.465821
96335WYWYOMING5605762Sweetwater County School District #2528Thoman Ranch Elementary5.60576E+11NoNoNo...-9-9-9-9560576200528NaNNaNNaN41.510680-109.465821
96336WYWYOMING5605820Washakie County School District #2393Ten Sleep K-125.60582E+11NoNoYes...-9-9-9-9560582000393NaNNaNNaN44.036012-107.447922
96337WYWYOMING5605830Teton County School District #1289Colter Elementary5.60583E+11NoNoNo...-9-9-9-9560583000289NaNNaNNaN43.462312-110.797767
96338WYWYOMING5605830Teton County School District #1313Jackson Elementary5.60583E+11NoNoYes...-9-9-9-9560583000313NaNNaNNaN43.462312-110.797767
96339WYWYOMING5605830Teton County School District #1335Jackson Hole High School5.60583E+11NoNoNo...-9-9-9-9560583000335NaNNaNNaN43.462312-110.797767
96340WYWYOMING5605830Teton County School District #1336Jackson Hole Middle School5.60583E+11NoNoNo...-9-9-9-9560583000336NaNNaNNaN43.462312-110.797767
96341WYWYOMING5605830Teton County School District #1337Alta Elementary5.60583E+11NoNoYes...-9-9-9-9560583000337NaNNaNNaN43.462312-110.797767
96342WYWYOMING5605830Teton County School District #1339Kelly Elementary5.60583E+11NoNoYes...-9-9-9-9560583000339NaNNaNNaN43.462312-110.797767
96343WYWYOMING5605830Teton County School District #1340Moran Elementary5.60583E+11NoNoYes...-9-9-9-9560583000340NaNNaNNaN43.462312-110.797767
96344WYWYOMING5605830Teton County School District #1341Wilson Elementary5.60583E+11NoNoYes...-9-9-9-9560583000341NaNNaNNaN43.462312-110.797767
96345WYWYOMING5605830Teton County School District #1512Summit High School5.60583E+11NoNoNo...-9-9-9-9560583000512NaNNaNNaN43.462312-110.797767
96346WYWYOMING5606090Weston County School District #7342Upton Middle School5.60609E+11NoNoNo...-9-9-9-9560609000342NaNNaNNaN44.101000-104.623594
96347WYWYOMING5606090Weston County School District #7363Upton Elementary5.60609E+11NoNoYes...-9-9-9-9560609000363NaNNaNNaN44.101000-104.623594
96348WYWYOMING5606090Weston County School District #7401Upton High School5.60609E+11NoNoNo...-9-9-9-9560609000401NaNNaNNaN44.101000-104.623594
96349WYWYOMING5606240Washakie County School District #1343Worland High School5.60624E+11NoNoNo...-9-9-9-9560624000343NaNNaNNaN44.011520-107.943721
96350WYWYOMING5606240Washakie County School District #1344Worland Middle School5.60624E+11NoNoNo...-9-9-9-9560624000344NaNNaNNaN44.011520-107.943721
96351WYWYOMING5606240Washakie County School District #1345East Side Elementary5.60624E+11NoNoYes...-9-9-9-9560624000345NaNNaNNaN44.011520-107.943721
96352WYWYOMING5606240Washakie County School District #1346South Side Elementary5.60624E+11NoNoYes...-9-9-9-9560624000346NaNNaNNaN44.011520-107.943721
96353WYWYOMING5606240Washakie County School District #1347West Side Elementary5.60624E+11NoNoYes...-9-9-9-9560624000347NaNNaNNaN44.011520-107.943721
96354WYWYOMING5680180Northeast Wyoming BOCES31Powder River Basin Children's Center5.68018E+11NoNoNo...-9-9-9-9568018000031NaNNaNNaN44.297605-105.494905
96355WYWYOMING5680250Region V BOCES48C-Bar-V Ranch5.68025E+11NoNoNo...-9-9-9-9568025000048NaNNaNNaN43.535575-110.830607
96356WYWYOMING5680251Wyoming Department of Family Services534Wyoming Girls School5.68025E+11YesNoNo...581750568025100534NaNNaNNaN41.138600-104.819200
96357WYWYOMING5680251Wyoming Department of Family Services538Wyoming Boys School5.68025E+11YesNoNo...1168868568025100538NaNNaNNaN41.138600-104.819200
96358WYWYOMING5680252Youth Emergency Services Inc. - Administration...350Youth Emergency Services Inc.5.68025E+11NoNoNo...-9-9-9-9568025200350NaNNaNNaN44.296500-105.494900
96359WYWYOMING5680254Saint Stephen's Indian School Admin Office\\tSaint Stephen's Indian School5.68025E+11NoNoYes...-9-9-9-956802540000\\tNaNNaNNaN42.985268-108.420787
\n", "

96360 rows × 1062 columns

\n", "
" ], "text/plain": [ " LEA_STATE LEA_STATE_NAME LEAID \\\n", "0 AL ALABAMA 100002 \n", "1 AL ALABAMA 100002 \n", "2 AL ALABAMA 100002 \n", "3 AL ALABAMA 100002 \n", "4 AL ALABAMA 100005 \n", "5 AL ALABAMA 100005 \n", "6 AL ALABAMA 100005 \n", "7 AL ALABAMA 100005 \n", "8 AL ALABAMA 100005 \n", "9 AL ALABAMA 100005 \n", "10 AL ALABAMA 100006 \n", "11 AL ALABAMA 100006 \n", "12 AL ALABAMA 100006 \n", "13 AL ALABAMA 100006 \n", "14 AL ALABAMA 100006 \n", "15 AL ALABAMA 100006 \n", "16 AL ALABAMA 100006 \n", "17 AL ALABAMA 100006 \n", "18 AL ALABAMA 100006 \n", "19 AL ALABAMA 100006 \n", "20 AL ALABAMA 100006 \n", "21 AL ALABAMA 100006 \n", "22 AL ALABAMA 100006 \n", "23 AL ALABAMA 100006 \n", "24 AL ALABAMA 100007 \n", "25 AL ALABAMA 100007 \n", "26 AL ALABAMA 100007 \n", "27 AL ALABAMA 100007 \n", "28 AL ALABAMA 100007 \n", "29 AL ALABAMA 100007 \n", "... ... ... ... \n", "96330 WY WYOMING 5605762 \n", "96331 WY WYOMING 5605762 \n", "96332 WY WYOMING 5605762 \n", "96333 WY WYOMING 5605762 \n", "96334 WY WYOMING 5605762 \n", "96335 WY WYOMING 5605762 \n", "96336 WY WYOMING 5605820 \n", "96337 WY WYOMING 5605830 \n", "96338 WY WYOMING 5605830 \n", "96339 WY WYOMING 5605830 \n", "96340 WY WYOMING 5605830 \n", "96341 WY WYOMING 5605830 \n", "96342 WY WYOMING 5605830 \n", "96343 WY WYOMING 5605830 \n", "96344 WY WYOMING 5605830 \n", "96345 WY WYOMING 5605830 \n", "96346 WY WYOMING 5606090 \n", "96347 WY WYOMING 5606090 \n", "96348 WY WYOMING 5606090 \n", "96349 WY WYOMING 5606240 \n", "96350 WY WYOMING 5606240 \n", "96351 WY WYOMING 5606240 \n", "96352 WY WYOMING 5606240 \n", "96353 WY WYOMING 5606240 \n", "96354 WY WYOMING 5680180 \n", "96355 WY WYOMING 5680250 \n", "96356 WY WYOMING 5680251 \n", "96357 WY WYOMING 5680251 \n", "96358 WY WYOMING 5680252 \n", "96359 WY WYOMING 5680254 \n", "\n", " LEA_NAME SCHID \\\n", "0 Alabama Youth Services 1705 \n", "1 Alabama Youth Services 1706 \n", "2 Alabama Youth Services 1876 \n", "3 Alabama Youth Services 99995 \n", "4 Albertville City 870 \n", "5 Albertville City 871 \n", "6 Albertville City 879 \n", "7 Albertville City 889 \n", "8 Albertville City 1616 \n", "9 Albertville City 2150 \n", "10 Marshall County 193 \n", "11 Marshall County 872 \n", "12 Marshall County 876 \n", "13 Marshall County 877 \n", "14 Marshall County 878 \n", "15 Marshall County 880 \n", "16 Marshall County 883 \n", "17 Marshall County 887 \n", "18 Marshall County 1413 \n", "19 Marshall County 1434 \n", "20 Marshall County 1585 \n", "21 Marshall County 1685 \n", "22 Marshall County 1812 \n", "23 Marshall County 2209 \n", "24 Hoover City 91 \n", "25 Hoover City 248 \n", "26 Hoover City 251 \n", "27 Hoover City 337 \n", "28 Hoover City 342 \n", "29 Hoover City 1422 \n", "... ... ... \n", "96330 Sweetwater County School District #2 332 \n", "96331 Sweetwater County School District #2 399 \n", "96332 Sweetwater County School District #2 424 \n", "96333 Sweetwater County School District #2 425 \n", "96334 Sweetwater County School District #2 439 \n", "96335 Sweetwater County School District #2 528 \n", "96336 Washakie County School District #2 393 \n", "96337 Teton County School District #1 289 \n", "96338 Teton County School District #1 313 \n", "96339 Teton County School District #1 335 \n", "96340 Teton County School District #1 336 \n", "96341 Teton County School District #1 337 \n", "96342 Teton County School District #1 339 \n", "96343 Teton County School District #1 340 \n", "96344 Teton County School District #1 341 \n", "96345 Teton County School District #1 512 \n", "96346 Weston County School District #7 342 \n", "96347 Weston County School District #7 363 \n", "96348 Weston County School District #7 401 \n", "96349 Washakie County School District #1 343 \n", "96350 Washakie County School District #1 344 \n", "96351 Washakie County School District #1 345 \n", "96352 Washakie County School District #1 346 \n", "96353 Washakie County School District #1 347 \n", "96354 Northeast Wyoming BOCES 31 \n", "96355 Region V BOCES 48 \n", "96356 Wyoming Department of Family Services 534 \n", "96357 Wyoming Department of Family Services 538 \n", "96358 Youth Emergency Services Inc. - Administration... 350 \n", "96359 Saint Stephen's Indian School Admin Office \\t \n", "\n", " SCH_NAME COMBOKEY JJ SCH_GRADE_PS \\\n", "0 Wallace Sch - Mt Meigs Campus 10000201705 Yes No \n", "1 McNeel Sch - Vacca Campus 10000201706 Yes No \n", "2 Alabama Youth Services 10000201876 No No \n", "3 AUTAUGA CAMPUS 10000299995 Yes No \n", "4 Albertville Middle School 10000500870 No No \n", "5 Albertville High Sch 10000500871 No No \n", "6 Evans Elem Sch 10000500879 No No \n", "7 Albertville Elem Sch 10000500889 No No \n", "8 Big Spring Lake Kinderg Sch 10000501616 No Yes \n", "9 Albertville Primary Sch 10000502150 No Yes \n", "10 Kate Duncan Smith DAR Middle 10000600193 No No \n", "11 Asbury Sch 10000600872 No No \n", "12 Claysville Jr High Sch 10000600876 No Yes \n", "13 Douglas Elem Sch 10000600877 No Yes \n", "14 Douglas High Sch 10000600878 No No \n", "15 Brindlee Mountain Elementary School 10000600880 No Yes \n", "16 Kate D Smith DAR High Sch 10000600883 No No \n", "17 Brindlee Mountain Primary School 10000600887 No Yes \n", "18 Robert D Sloman Primary 10000601413 No Yes \n", "19 Brindlee Mt Middle Sch 10000601434 No No \n", "20 Brindlee Mt High Sch 10000601585 No No \n", "21 Kate D Smith DAR Elem Sch 10000601685 No Yes \n", "22 Douglas Middle Sch 10000601812 No No \n", "23 Asbury Elem Sch 10000602209 No Yes \n", "24 Trace Crossings Elem Sch 10000700091 No Yes \n", "25 Greystone Elem Sch 10000700248 No No \n", "26 Hoover High Sch 10000700251 No No \n", "27 Berry Middle Sch 10000700337 No No \n", "28 South Shades Crest Elem Sch 10000700342 No No \n", "29 Robert F Bumpus Middle Sch 10000701422 No No \n", "... ... ... ... ... \n", "96330 Washington Elementary 5.60576E+11 No No \n", "96331 Lincoln Middle School 5.60576E+11 No No \n", "96332 Jackson Elementary 5.60576E+11 No No \n", "96333 Truman Elementary 5.60576E+11 No No \n", "96334 Harrison Elementary 5.60576E+11 No No \n", "96335 Thoman Ranch Elementary 5.60576E+11 No No \n", "96336 Ten Sleep K-12 5.60582E+11 No No \n", "96337 Colter Elementary 5.60583E+11 No No \n", "96338 Jackson Elementary 5.60583E+11 No No \n", "96339 Jackson Hole High School 5.60583E+11 No No \n", "96340 Jackson Hole Middle School 5.60583E+11 No No \n", "96341 Alta Elementary 5.60583E+11 No No \n", "96342 Kelly Elementary 5.60583E+11 No No \n", "96343 Moran Elementary 5.60583E+11 No No \n", "96344 Wilson Elementary 5.60583E+11 No No \n", "96345 Summit High School 5.60583E+11 No No \n", "96346 Upton Middle School 5.60609E+11 No No \n", "96347 Upton Elementary 5.60609E+11 No No \n", "96348 Upton High School 5.60609E+11 No No \n", "96349 Worland High School 5.60624E+11 No No \n", "96350 Worland Middle School 5.60624E+11 No No \n", "96351 East Side Elementary 5.60624E+11 No No \n", "96352 South Side Elementary 5.60624E+11 No No \n", "96353 West Side Elementary 5.60624E+11 No No \n", "96354 Powder River Basin Children's Center 5.68018E+11 No No \n", "96355 C-Bar-V Ranch 5.68025E+11 No No \n", "96356 Wyoming Girls School 5.68025E+11 Yes No \n", "96357 Wyoming Boys School 5.68025E+11 Yes No \n", "96358 Youth Emergency Services Inc. 5.68025E+11 No No \n", "96359 Saint Stephen's Indian School 5.68025E+11 No No \n", "\n", " SCH_GRADE_KG ... SCH_JJPART_15T30 SCH_JJPART_31T90 \\\n", "0 No ... -7 -7 \n", "1 No ... -7 -7 \n", "2 No ... -9 -9 \n", "3 No ... -7 -7 \n", "4 No ... -9 -9 \n", "5 No ... -9 -9 \n", "6 No ... -9 -9 \n", "7 No ... -9 -9 \n", "8 Yes ... -9 -9 \n", "9 No ... -9 -9 \n", "10 No ... -9 -9 \n", "11 No ... -9 -9 \n", "12 Yes ... -9 -9 \n", "13 No ... -9 -9 \n", "14 No ... -9 -9 \n", "15 No ... -9 -9 \n", "16 No ... -9 -9 \n", "17 Yes ... -9 -9 \n", "18 Yes ... -9 -9 \n", "19 No ... -9 -9 \n", "20 No ... -9 -9 \n", "21 Yes ... -9 -9 \n", "22 No ... -9 -9 \n", "23 Yes ... -9 -9 \n", "24 Yes ... -9 -9 \n", "25 Yes ... -9 -9 \n", "26 No ... -9 -9 \n", "27 No ... -9 -9 \n", "28 Yes ... -9 -9 \n", "29 No ... -9 -9 \n", "... ... ... ... ... \n", "96330 Yes ... -9 -9 \n", "96331 No ... -9 -9 \n", "96332 Yes ... -9 -9 \n", "96333 Yes ... -9 -9 \n", "96334 Yes ... -9 -9 \n", "96335 No ... -9 -9 \n", "96336 Yes ... -9 -9 \n", "96337 No ... -9 -9 \n", "96338 Yes ... -9 -9 \n", "96339 No ... -9 -9 \n", "96340 No ... -9 -9 \n", "96341 Yes ... -9 -9 \n", "96342 Yes ... -9 -9 \n", "96343 Yes ... -9 -9 \n", "96344 Yes ... -9 -9 \n", "96345 No ... -9 -9 \n", "96346 No ... -9 -9 \n", "96347 Yes ... -9 -9 \n", "96348 No ... -9 -9 \n", "96349 No ... -9 -9 \n", "96350 No ... -9 -9 \n", "96351 Yes ... -9 -9 \n", "96352 Yes ... -9 -9 \n", "96353 Yes ... -9 -9 \n", "96354 No ... -9 -9 \n", "96355 No ... -9 -9 \n", "96356 No ... 5 8 \n", "96357 No ... 11 68 \n", "96358 No ... -9 -9 \n", "96359 Yes ... -9 -9 \n", "\n", " SCH_JJPART_91T180 SCH_JJPART_OV180 NCESSCH \\\n", "0 -7 -7 10000201705 \n", "1 -7 -7 10000201706 \n", "2 -9 -9 10000201876 \n", "3 -7 -7 10000299995 \n", "4 -9 -9 10000500870 \n", "5 -9 -9 10000500871 \n", "6 -9 -9 10000500879 \n", "7 -9 -9 10000500889 \n", "8 -9 -9 10000501616 \n", "9 -9 -9 10000502150 \n", "10 -9 -9 10000600193 \n", "11 -9 -9 10000600872 \n", "12 -9 -9 10000600876 \n", "13 -9 -9 10000600877 \n", "14 -9 -9 10000600878 \n", "15 -9 -9 10000600880 \n", "16 -9 -9 10000600883 \n", "17 -9 -9 10000600887 \n", "18 -9 -9 10000601413 \n", "19 -9 -9 10000601434 \n", "20 -9 -9 10000601585 \n", "21 -9 -9 10000601685 \n", "22 -9 -9 10000601812 \n", "23 -9 -9 10000602209 \n", "24 -9 -9 10000700091 \n", "25 -9 -9 10000700248 \n", "26 -9 -9 10000700251 \n", "27 -9 -9 10000700337 \n", "28 -9 -9 10000700342 \n", "29 -9 -9 10000701422 \n", "... ... ... ... \n", "96330 -9 -9 560576200332 \n", "96331 -9 -9 560576200399 \n", "96332 -9 -9 560576200424 \n", "96333 -9 -9 560576200425 \n", "96334 -9 -9 560576200439 \n", "96335 -9 -9 560576200528 \n", "96336 -9 -9 560582000393 \n", "96337 -9 -9 560583000289 \n", "96338 -9 -9 560583000313 \n", "96339 -9 -9 560583000335 \n", "96340 -9 -9 560583000336 \n", "96341 -9 -9 560583000337 \n", "96342 -9 -9 560583000339 \n", "96343 -9 -9 560583000340 \n", "96344 -9 -9 560583000341 \n", "96345 -9 -9 560583000512 \n", "96346 -9 -9 560609000342 \n", "96347 -9 -9 560609000363 \n", "96348 -9 -9 560609000401 \n", "96349 -9 -9 560624000343 \n", "96350 -9 -9 560624000344 \n", "96351 -9 -9 560624000345 \n", "96352 -9 -9 560624000346 \n", "96353 -9 -9 560624000347 \n", "96354 -9 -9 568018000031 \n", "96355 -9 -9 568025000048 \n", "96356 17 50 568025100534 \n", "96357 86 8 568025100538 \n", "96358 -9 -9 568025200350 \n", "96359 -9 -9 56802540000\\t \n", "\n", " NAME LAT1516 LON1516 LEA_LAT1516 \\\n", "0 Wallace Sch - Mt Meigs Campus 32.374812 -86.082360 NaN \n", "1 McNeel Sch - Vacca Campus 33.583385 -86.710058 NaN \n", "2 Alabama Youth Services 32.374847 -86.082332 NaN \n", "3 NaN NaN NaN NaN \n", "4 Ala Avenue Middle Sch 34.260194 -86.206174 NaN \n", "5 Albertville High Sch 34.262154 -86.204863 NaN \n", "6 Evans Elem Sch 34.273161 -86.220086 NaN \n", "7 Albertville Elem Sch 34.253251 -86.221834 NaN \n", "8 Big Spring Lake Kinderg Sch 34.290220 -86.192490 NaN \n", "9 Albertville Primary Sch 34.253251 -86.221834 NaN \n", "10 Kate Duncan Smith DAR Middle 34.533721 -86.253681 NaN \n", "11 Asbury Sch 34.362770 -86.142240 NaN \n", "12 Claysville Jr High Sch 34.406429 -86.270689 NaN \n", "13 Douglas Elem Sch 34.176234 -86.321259 NaN \n", "14 Douglas High Sch 34.178157 -86.319947 NaN \n", "15 Grassy Elem Sch 34.344388 -86.442199 NaN \n", "16 Kate D Smith DAR High Sch 34.533721 -86.253681 NaN \n", "17 Union Grove Elem Sch 34.399966 -86.446812 NaN \n", "18 Robert D Sloman Primary 34.176713 -86.323279 NaN \n", "19 Brindlee Mt Middle Sch 34.377158 -86.422337 NaN \n", "20 Brindlee Mt High Sch 34.376400 -86.421876 NaN \n", "21 Kate D Smith DAR Elem Sch 34.533721 -86.253681 NaN \n", "22 Douglas Middle Sch 34.176234 -86.321259 NaN \n", "23 Asbury Elem Sch 34.362794 -86.142507 NaN \n", "24 Trace Crossings Elem Sch 33.340886 -86.844733 NaN \n", "25 Greystone Elem Sch 33.413047 -86.658547 NaN \n", "26 Hoover High Sch 33.344370 -86.837683 NaN \n", "27 Berry Middle Sch 33.395648 -86.732180 NaN \n", "28 South Shades Crest Elem Sch 33.337527 -86.878390 NaN \n", "29 Robert F Bumpus Middle Sch 33.330911 -86.852477 NaN \n", "... ... ... ... ... \n", "96330 NaN NaN NaN 41.510680 \n", "96331 NaN NaN NaN 41.510680 \n", "96332 NaN NaN NaN 41.510680 \n", "96333 NaN NaN NaN 41.510680 \n", "96334 NaN NaN NaN 41.510680 \n", "96335 NaN NaN NaN 41.510680 \n", "96336 NaN NaN NaN 44.036012 \n", "96337 NaN NaN NaN 43.462312 \n", "96338 NaN NaN NaN 43.462312 \n", "96339 NaN NaN NaN 43.462312 \n", "96340 NaN NaN NaN 43.462312 \n", "96341 NaN NaN NaN 43.462312 \n", "96342 NaN NaN NaN 43.462312 \n", "96343 NaN NaN NaN 43.462312 \n", "96344 NaN NaN NaN 43.462312 \n", "96345 NaN NaN NaN 43.462312 \n", "96346 NaN NaN NaN 44.101000 \n", "96347 NaN NaN NaN 44.101000 \n", "96348 NaN NaN NaN 44.101000 \n", "96349 NaN NaN NaN 44.011520 \n", "96350 NaN NaN NaN 44.011520 \n", "96351 NaN NaN NaN 44.011520 \n", "96352 NaN NaN NaN 44.011520 \n", "96353 NaN NaN NaN 44.011520 \n", "96354 NaN NaN NaN 44.297605 \n", "96355 NaN NaN NaN 43.535575 \n", "96356 NaN NaN NaN 41.138600 \n", "96357 NaN NaN NaN 41.138600 \n", "96358 NaN NaN NaN 44.296500 \n", "96359 NaN NaN NaN 42.985268 \n", "\n", " LEA_LON1516 \n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "5 NaN \n", "6 NaN \n", "7 NaN \n", "8 NaN \n", "9 NaN \n", "10 NaN \n", "11 NaN \n", "12 NaN \n", "13 NaN \n", "14 NaN \n", "15 NaN \n", "16 NaN \n", "17 NaN \n", "18 NaN \n", "19 NaN \n", "20 NaN \n", "21 NaN \n", "22 NaN \n", "23 NaN \n", "24 NaN \n", "25 NaN \n", "26 NaN \n", "27 NaN \n", "28 NaN \n", "29 NaN \n", "... ... \n", "96330 -109.465821 \n", "96331 -109.465821 \n", "96332 -109.465821 \n", "96333 -109.465821 \n", "96334 -109.465821 \n", "96335 -109.465821 \n", "96336 -107.447922 \n", "96337 -110.797767 \n", "96338 -110.797767 \n", "96339 -110.797767 \n", "96340 -110.797767 \n", "96341 -110.797767 \n", "96342 -110.797767 \n", "96343 -110.797767 \n", "96344 -110.797767 \n", "96345 -110.797767 \n", "96346 -104.623594 \n", "96347 -104.623594 \n", "96348 -104.623594 \n", "96349 -107.943721 \n", "96350 -107.943721 \n", "96351 -107.943721 \n", "96352 -107.943721 \n", "96353 -107.943721 \n", "96354 -105.494905 \n", "96355 -110.830607 \n", "96356 -104.819200 \n", "96357 -104.819200 \n", "96358 -105.494900 \n", "96359 -108.420787 \n", "\n", "[96360 rows x 1062 columns]" ] }, "execution_count": 59, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Join on LEA CODE. \n", "final_2 = final.merge(\n", " lea_lat_longs,\n", " how='left',\n", " left_on='LEAID',\n", " right_on='LEAID',\n", ")\n", "final_2" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### (942 Schools have *no* lat/long data available, not even for LEA)" ] }, { "cell_type": "code", "execution_count": 60, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
LEA_STATELEA_STATE_NAMELEAIDLEA_NAMESCHIDSCH_NAMECOMBOKEYJJSCH_GRADE_PSSCH_GRADE_KG...SCH_JJPART_15T30SCH_JJPART_31T90SCH_JJPART_91T180SCH_JJPART_OV180NCESSCHNAMELAT1516LON1516LEA_LAT1516LEA_LON1516
3ALALABAMA100002Alabama Youth Services99995AUTAUGA CAMPUS10000299995YesNoNo...-7-7-7-710000299995NaNNaNNaNNaNNaN
69ALALABAMA100021Brewer-Porch Childrens Center1832Brewer Porch Children's Ctr10002101832NoYesYes...-9-9-9-910002101832NaNNaNNaNNaNNaN
70ALALABAMA100022Sequel TSI Courtland1833Three Springs Courtland Sch10002201833NoNoNo...-9-9-9-910002201833NaNNaNNaNNaNNaN
71ALALABAMA100023Sequel Madison TSI1834Sequel Madison TSI10002301834NoNoNo...-9-9-9-910002301834NaNNaNNaNNaNNaN
72ALALABAMA100024Sequel TSI- New Beginnings School/ Owens Cross...1835Three Springs New Beginnings10002401835NoNoNo...-9-9-9-910002401835NaNNaNNaNNaNNaN
73ALALABAMA100026Sequel TSI Tuskegee2352Sequel TSI Tuskegee LLC10002602352NoNoNo...-9-9-9-910002602352NaNNaNNaNNaNNaN
79ALALABAMA100033Glenwood Mental Health Services99998Allan Cott10003399998NoNoNo...-9-9-9-910003399998NaNNaNNaNNaNNaN
80ALALABAMA100033Glenwood Mental Health Services99999Lakeview10003399999NoNoYes...-9-9-9-910003399999NaNNaNNaNNaNNaN
81ALALABAMA100035Learning Tree Inc1845Learning Tree Inc Semmes10003501845NoYesNo...-9-9-9-910003501845NaNNaNNaNNaNNaN
82ALALABAMA100035Learning Tree Inc1846Learning Tree Inc Webb10003501846NoYesNo...-9-9-9-910003501846NaNNaNNaNNaNNaN
83ALALABAMA100035Learning Tree Inc2105The Learning Tree-Tallassee10003502105NoNoNo...-9-9-9-910003502105NaNNaNNaNNaNNaN
84ALALABAMA100036Lee Co Youth Development Ctr99999CHANTICLEER LEARNING CENTER10003699999NoNoNo...-9-9-9-910003699999NaNNaNNaNNaNNaN
86ALALABAMA100039Presbyterian Home For Children1850Hope Academy10003901850NoNoNo...-9-9-9-910003901850NaNNaNNaNNaNNaN
88ALALABAMA100042Laurel Oaks Behavioral Health1853Laurel Oaks Behavioral Health Ctr10004201853NoNoNo...-9-9-9-910004201853NaNNaNNaNNaNNaN
89ALALABAMA100043Mountainview Hospital1854Mountainview Hospital10004301854NoNoNo...-9-9-9-910004301854NaNNaNNaNNaNNaN
114ALALABAMA100178Higdon Hill School2374Higdon Hill10017802374NoNoNo...-9-9-9-910017802374NaNNaNNaNNaNNaN
115ALALABAMA100180Attalla City32ATTALLA ELEMENTARY10018000032NoYesYes...-9-9-9-910018000032NaNNaNNaNNaNNaN
125ALALABAMA100188Chickasaw City99999Chickasaw Early Learning Center10018899999NoYesNo...-9-9-9-910018899999NaNNaNNaNNaNNaN
214ALALABAMA100330Bessemer City99999BESSEMER PRESCHOOL10033099999NoYesNo...-9-9-9-910033099999NaNNaNNaNNaNNaN
222ALALABAMA100360Bibb County99998BIBB CO PRESCHOOL10036099998NoYesNo...-9-9-9-910036099998NaNNaNNaNNaNNaN
223ALALABAMA100360Bibb County99999CENTREVILLE MIDDLE SCHOOL10036099999NoNoNo...-9-9-9-910036099999NaNNaNNaNNaNNaN
266ALALABAMA100390Birmingham City99996Jones Valley Middle School10039099996NoNoNo...-9-9-9-910039099996NaNNaNNaNNaNNaN
267ALALABAMA100390Birmingham City99999Oliver Elementary10039099999NoYesYes...-9-9-9-910039099999NaNNaNNaNNaNNaN
375ALALABAMA100840Colbert County99999Tennessee Valley Juvenile Detention Center10084099999NoNoNo...-9-9-9-910084099999NaNNaNNaNNaNNaN
435ALALABAMA101050Dale County2373Unique Situations10105002373NoNoNo...-9-9-9-910105002373NaNNaNNaNNaNNaN
461ALALABAMA101140Dekalb County99999Crossville MIddle School10114099999NoYesNo...-9-9-9-910114099999NaNNaNNaNNaNNaN
500ALALABAMA101230Dothan City1634DCS Head Start Preschool Center10123001634NoYesNo...-9-9-9-910123001634NaNNaNNaNNaNNaN
519ALALABAMA101290Elmore County99998ELMORE COUNTY ALTERNATIVE PROGRAMs10129099998NoNoNo...-9-9-9-910129099998NaNNaNNaNNaNNaN
652ALALABAMA101740Henry County99999Camp Sayla10174099999NoNoNo...-9-9-9-910174099999NaNNaNNaNNaNNaN
834ALALABAMA102070Lee County99999Lee County Learning Center10207099999NoNoNo...-9-9-9-910207099999NaNNaNNaNNaNNaN
..................................................................
71749OROREGON4199999ODE Juvenile Detention Education Program (JDEP)99989NORCOR4.2E+11YesNoNo...412980419999999989NaNNaNNaNNaNNaN
71750OROREGON4199999ODE Juvenile Detention Education Program (JDEP)99990YAMHILL COUNTY JUVENILE4.2E+11YesNoNo...381700419999999990NaNNaNNaNNaNNaN
71751OROREGON4199999ODE Juvenile Detention Education Program (JDEP)99992DONALD E LONG SCHOOL4.2E+11YesNoNo...164122112419999999992NaNNaNNaNNaNNaN
71752OROREGON4199999ODE Juvenile Detention Education Program (JDEP)99993MARION COUNTY JUV DET4.2E+11YesNoNo...684450419999999993NaNNaNNaNNaNNaN
71753OROREGON4199999ODE Juvenile Detention Education Program (JDEP)99994LINN COUNTY JUV DET4.2E+11YesNoNo...292000419999999994NaNNaNNaNNaNNaN
71754OROREGON4199999ODE Juvenile Detention Education Program (JDEP)99995LINCOLN COUNTY JUVENILE4.2E+11YesNoNo...2800419999999995NaNNaNNaNNaNNaN
71755OROREGON4199999ODE Juvenile Detention Education Program (JDEP)99996LANE COUNTY DEPT OF YOUTH4.2E+11YesNoNo...441400419999999996NaNNaNNaNNaNNaN
71756OROREGON4199999ODE Juvenile Detention Education Program (JDEP)99997JACKSON COUNTY JUVENILE4.2E+11YesNoNo...533220419999999997NaNNaNNaNNaNNaN
71757OROREGON4199999ODE Juvenile Detention Education Program (JDEP)99998KLAMATH COUNTY JUVENILE4.2E+11YesNoNo...292600419999999998NaNNaNNaNNaNNaN
71758OROREGON4199999ODE Juvenile Detention Education Program (JDEP)99999COIC SKILL LAB4.2E+11YesNoNo...351700419999999999NaNNaNNaNNaNNaN
71871PAPENNSYLVANIA4200779ACLD TILLOTSON SCHOOL99999ACLD TILLOTSON SCHOOL4.20078E+11NoNoNo...-9-9-9-9420077999999NaNNaNNaNNaNNaN
71872PAPENNSYLVANIA4200782ROYER-GREAVES SCHOOL FOR BLIND99999ROYER-GREAVES SCHOOL FOR BLIND4.20078E+11NoNoNo...-9-9-9-9420078299999NaNNaNNaNNaNNaN
71873PAPENNSYLVANIA4200784WESTERN PA SCHOOL FOR BLIND CHILDREN99999WESTERN PA SCHOOL FOR BLIND CHILDREN4.20078E+11NoYesYes...-9-9-9-9420078499999NaNNaNNaNNaNNaN
71874PAPENNSYLVANIA4200796CENTENNIAL SCHOOL LEHIGH UNIV99999CENTENNIAL SCHOOL OF LEHIGH UNIVERSITY4.2008E+11NoNoNo...-9-9-9-9420079699999NaNNaNNaNNaNNaN
71875PAPENNSYLVANIA4200801SCI-FOREST99999SCI-FOREST4.2008E+11NoNoNo...-9-9-9-9420080199999NaNNaNNaNNaNNaN
71876PAPENNSYLVANIA4200802SCI-MUNCY99999SCI-Muncy4.2008E+11NoNoNo...-9-9-9-9420080299999NaNNaNNaNNaNNaN
71877PAPENNSYLVANIA4200803SCI-SOMERSET99999SCI Somerset4.2008E+11YesNoNo...-7-7-7-7420080399999NaNNaNNaNNaNNaN
71878PAPENNSYLVANIA4200805SCI-HOUTZDALE99999SCI-HOUTZDALE4.20081E+11NoNoNo...-9-9-9-9420080599999NaNNaNNaNNaNNaN
71879PAPENNSYLVANIA4200806SCI- Camp Hill99999SCI- Camp Hill4.20081E+11NoNoNo...-9-9-9-9420080699999NaNNaNNaNNaNNaN
71880PAPENNSYLVANIA4200807SCI-COAL TOWNSHIP99999SCI-Coal Township4.20081E+11NoNoNo...-9-9-9-9420080799999NaNNaNNaNNaNNaN
71881PAPENNSYLVANIA4200808Sci-Retreat99999SCI Retreat4.20081E+11NoNoNo...-9-9-9-9420080899999NaNNaNNaNNaNNaN
71882PAPENNSYLVANIA4200809SCI-PINE GROVE99999SCI PINE GROVE4.20081E+11NoNoNo...-9-9-9-9420080999999NaNNaNNaNNaNNaN
71884PAPENNSYLVANIA4200811FRANKLIN LEARNING CENTER99999FRANKLIN LEARNING CENTER4.20081E+11NoYesYes...-9-9-9-9420081199999NaNNaNNaNNaNNaN
71939PAPENNSYLVANIA4200871Sci-Dallas99999SCI-Dallas4.20087E+11NoNoNo...-9-9-9-9420087199999NaNNaNNaNNaNNaN
74735PAPENNSYLVANIA4226830YORK ADAMS ACADEMY99999York Adams Academy4.22683E+11NoNoNo...-9-9-9-9422683099999NaNNaNNaNNaNNaN
74784PAPENNSYLVANIA4299091Western Pennsylvania School for the Deaf99998Scranton School for Deaf and Hard of Hearing C...4.29909E+11NoYesYes...-9-9-9-9429909199998NaNNaNNaNNaNNaN
74785PAPENNSYLVANIA4299091Western Pennsylvania School for the Deaf99999Western Pennsylvania School for the Deaf4.29909E+11NoYesYes...-9-9-9-9429909199999NaNNaNNaNNaNNaN
78833TNTENNESSEE47SOP04TENNESSEE DEPARTMENT OF CHILDREN'S SERVICES99991WOODLAND HILLS YOUTH DEVELOPMENT CENTER47SOP0499991YesNoNo...020412047SOP0499991NaNNaNNaNNaNNaN
78834TNTENNESSEE47SOP04TENNESSEE DEPARTMENT OF CHILDREN'S SERVICES99994JOHN S. WILDER YOUTH DEVELOPMENT CENTER47SOP0499994YesNoNo...1141808347SOP0499994NaNNaNNaNNaNNaN
78835TNTENNESSEE47SOP04TENNESSEE DEPARTMENT OF CHILDREN'S SERVICES99999MOUNTAIN VIEW YOUTH DEVELOPMENT CENTER47SOP0499999YesNoNo...829474447SOP0499999NaNNaNNaNNaNNaN
\n", "

942 rows × 1062 columns

\n", "
" ], "text/plain": [ " LEA_STATE LEA_STATE_NAME LEAID \\\n", "3 AL ALABAMA 100002 \n", "69 AL ALABAMA 100021 \n", "70 AL ALABAMA 100022 \n", "71 AL ALABAMA 100023 \n", "72 AL ALABAMA 100024 \n", "73 AL ALABAMA 100026 \n", "79 AL ALABAMA 100033 \n", "80 AL ALABAMA 100033 \n", "81 AL ALABAMA 100035 \n", "82 AL ALABAMA 100035 \n", "83 AL ALABAMA 100035 \n", "84 AL ALABAMA 100036 \n", "86 AL ALABAMA 100039 \n", "88 AL ALABAMA 100042 \n", "89 AL ALABAMA 100043 \n", "114 AL ALABAMA 100178 \n", "115 AL ALABAMA 100180 \n", "125 AL ALABAMA 100188 \n", "214 AL ALABAMA 100330 \n", "222 AL ALABAMA 100360 \n", "223 AL ALABAMA 100360 \n", "266 AL ALABAMA 100390 \n", "267 AL ALABAMA 100390 \n", "375 AL ALABAMA 100840 \n", "435 AL ALABAMA 101050 \n", "461 AL ALABAMA 101140 \n", "500 AL ALABAMA 101230 \n", "519 AL ALABAMA 101290 \n", "652 AL ALABAMA 101740 \n", "834 AL ALABAMA 102070 \n", "... ... ... ... \n", "71749 OR OREGON 4199999 \n", "71750 OR OREGON 4199999 \n", "71751 OR OREGON 4199999 \n", "71752 OR OREGON 4199999 \n", "71753 OR OREGON 4199999 \n", "71754 OR OREGON 4199999 \n", "71755 OR OREGON 4199999 \n", "71756 OR OREGON 4199999 \n", "71757 OR OREGON 4199999 \n", "71758 OR OREGON 4199999 \n", "71871 PA PENNSYLVANIA 4200779 \n", "71872 PA PENNSYLVANIA 4200782 \n", "71873 PA PENNSYLVANIA 4200784 \n", "71874 PA PENNSYLVANIA 4200796 \n", "71875 PA PENNSYLVANIA 4200801 \n", "71876 PA PENNSYLVANIA 4200802 \n", "71877 PA PENNSYLVANIA 4200803 \n", "71878 PA PENNSYLVANIA 4200805 \n", "71879 PA PENNSYLVANIA 4200806 \n", "71880 PA PENNSYLVANIA 4200807 \n", "71881 PA PENNSYLVANIA 4200808 \n", "71882 PA PENNSYLVANIA 4200809 \n", "71884 PA PENNSYLVANIA 4200811 \n", "71939 PA PENNSYLVANIA 4200871 \n", "74735 PA PENNSYLVANIA 4226830 \n", "74784 PA PENNSYLVANIA 4299091 \n", "74785 PA PENNSYLVANIA 4299091 \n", "78833 TN TENNESSEE 47SOP04 \n", "78834 TN TENNESSEE 47SOP04 \n", "78835 TN TENNESSEE 47SOP04 \n", "\n", " LEA_NAME SCHID \\\n", "3 Alabama Youth Services 99995 \n", "69 Brewer-Porch Childrens Center 1832 \n", "70 Sequel TSI Courtland 1833 \n", "71 Sequel Madison TSI 1834 \n", "72 Sequel TSI- New Beginnings School/ Owens Cross... 1835 \n", "73 Sequel TSI Tuskegee 2352 \n", "79 Glenwood Mental Health Services 99998 \n", "80 Glenwood Mental Health Services 99999 \n", "81 Learning Tree Inc 1845 \n", "82 Learning Tree Inc 1846 \n", "83 Learning Tree Inc 2105 \n", "84 Lee Co Youth Development Ctr 99999 \n", "86 Presbyterian Home For Children 1850 \n", "88 Laurel Oaks Behavioral Health 1853 \n", "89 Mountainview Hospital 1854 \n", "114 Higdon Hill School 2374 \n", "115 Attalla City 32 \n", "125 Chickasaw City 99999 \n", "214 Bessemer City 99999 \n", "222 Bibb County 99998 \n", "223 Bibb County 99999 \n", "266 Birmingham City 99996 \n", "267 Birmingham City 99999 \n", "375 Colbert County 99999 \n", "435 Dale County 2373 \n", "461 Dekalb County 99999 \n", "500 Dothan City 1634 \n", "519 Elmore County 99998 \n", "652 Henry County 99999 \n", "834 Lee County 99999 \n", "... ... ... \n", "71749 ODE Juvenile Detention Education Program (JDEP) 99989 \n", "71750 ODE Juvenile Detention Education Program (JDEP) 99990 \n", "71751 ODE Juvenile Detention Education Program (JDEP) 99992 \n", "71752 ODE Juvenile Detention Education Program (JDEP) 99993 \n", "71753 ODE Juvenile Detention Education Program (JDEP) 99994 \n", "71754 ODE Juvenile Detention Education Program (JDEP) 99995 \n", "71755 ODE Juvenile Detention Education Program (JDEP) 99996 \n", "71756 ODE Juvenile Detention Education Program (JDEP) 99997 \n", "71757 ODE Juvenile Detention Education Program (JDEP) 99998 \n", "71758 ODE Juvenile Detention Education Program (JDEP) 99999 \n", "71871 ACLD TILLOTSON SCHOOL 99999 \n", "71872 ROYER-GREAVES SCHOOL FOR BLIND 99999 \n", "71873 WESTERN PA SCHOOL FOR BLIND CHILDREN 99999 \n", "71874 CENTENNIAL SCHOOL LEHIGH UNIV 99999 \n", "71875 SCI-FOREST 99999 \n", "71876 SCI-MUNCY 99999 \n", "71877 SCI-SOMERSET 99999 \n", "71878 SCI-HOUTZDALE 99999 \n", "71879 SCI- Camp Hill 99999 \n", "71880 SCI-COAL TOWNSHIP 99999 \n", "71881 Sci-Retreat 99999 \n", "71882 SCI-PINE GROVE 99999 \n", "71884 FRANKLIN LEARNING CENTER 99999 \n", "71939 Sci-Dallas 99999 \n", "74735 YORK ADAMS ACADEMY 99999 \n", "74784 Western Pennsylvania School for the Deaf 99998 \n", "74785 Western Pennsylvania School for the Deaf 99999 \n", "78833 TENNESSEE DEPARTMENT OF CHILDREN'S SERVICES 99991 \n", "78834 TENNESSEE DEPARTMENT OF CHILDREN'S SERVICES 99994 \n", "78835 TENNESSEE DEPARTMENT OF CHILDREN'S SERVICES 99999 \n", "\n", " SCH_NAME COMBOKEY JJ \\\n", "3 AUTAUGA CAMPUS 10000299995 Yes \n", "69 Brewer Porch Children's Ctr 10002101832 No \n", "70 Three Springs Courtland Sch 10002201833 No \n", "71 Sequel Madison TSI 10002301834 No \n", "72 Three Springs New Beginnings 10002401835 No \n", "73 Sequel TSI Tuskegee LLC 10002602352 No \n", "79 Allan Cott 10003399998 No \n", "80 Lakeview 10003399999 No \n", "81 Learning Tree Inc Semmes 10003501845 No \n", "82 Learning Tree Inc Webb 10003501846 No \n", "83 The Learning Tree-Tallassee 10003502105 No \n", "84 CHANTICLEER LEARNING CENTER 10003699999 No \n", "86 Hope Academy 10003901850 No \n", "88 Laurel Oaks Behavioral Health Ctr 10004201853 No \n", "89 Mountainview Hospital 10004301854 No \n", "114 Higdon Hill 10017802374 No \n", "115 ATTALLA ELEMENTARY 10018000032 No \n", "125 Chickasaw Early Learning Center 10018899999 No \n", "214 BESSEMER PRESCHOOL 10033099999 No \n", "222 BIBB CO PRESCHOOL 10036099998 No \n", "223 CENTREVILLE MIDDLE SCHOOL 10036099999 No \n", "266 Jones Valley Middle School 10039099996 No \n", "267 Oliver Elementary 10039099999 No \n", "375 Tennessee Valley Juvenile Detention Center 10084099999 No \n", "435 Unique Situations 10105002373 No \n", "461 Crossville MIddle School 10114099999 No \n", "500 DCS Head Start Preschool Center 10123001634 No \n", "519 ELMORE COUNTY ALTERNATIVE PROGRAMs 10129099998 No \n", "652 Camp Sayla 10174099999 No \n", "834 Lee County Learning Center 10207099999 No \n", "... ... ... ... \n", "71749 NORCOR 4.2E+11 Yes \n", "71750 YAMHILL COUNTY JUVENILE 4.2E+11 Yes \n", "71751 DONALD E LONG SCHOOL 4.2E+11 Yes \n", "71752 MARION COUNTY JUV DET 4.2E+11 Yes \n", "71753 LINN COUNTY JUV DET 4.2E+11 Yes \n", "71754 LINCOLN COUNTY JUVENILE 4.2E+11 Yes \n", "71755 LANE COUNTY DEPT OF YOUTH 4.2E+11 Yes \n", "71756 JACKSON COUNTY JUVENILE 4.2E+11 Yes \n", "71757 KLAMATH COUNTY JUVENILE 4.2E+11 Yes \n", "71758 COIC SKILL LAB 4.2E+11 Yes \n", "71871 ACLD TILLOTSON SCHOOL 4.20078E+11 No \n", "71872 ROYER-GREAVES SCHOOL FOR BLIND 4.20078E+11 No \n", "71873 WESTERN PA SCHOOL FOR BLIND CHILDREN 4.20078E+11 No \n", "71874 CENTENNIAL SCHOOL OF LEHIGH UNIVERSITY 4.2008E+11 No \n", "71875 SCI-FOREST 4.2008E+11 No \n", "71876 SCI-Muncy 4.2008E+11 No \n", "71877 SCI Somerset 4.2008E+11 Yes \n", "71878 SCI-HOUTZDALE 4.20081E+11 No \n", "71879 SCI- Camp Hill 4.20081E+11 No \n", "71880 SCI-Coal Township 4.20081E+11 No \n", "71881 SCI Retreat 4.20081E+11 No \n", "71882 SCI PINE GROVE 4.20081E+11 No \n", "71884 FRANKLIN LEARNING CENTER 4.20081E+11 No \n", "71939 SCI-Dallas 4.20087E+11 No \n", "74735 York Adams Academy 4.22683E+11 No \n", "74784 Scranton School for Deaf and Hard of Hearing C... 4.29909E+11 No \n", "74785 Western Pennsylvania School for the Deaf 4.29909E+11 No \n", "78833 WOODLAND HILLS YOUTH DEVELOPMENT CENTER 47SOP0499991 Yes \n", "78834 JOHN S. WILDER YOUTH DEVELOPMENT CENTER 47SOP0499994 Yes \n", "78835 MOUNTAIN VIEW YOUTH DEVELOPMENT CENTER 47SOP0499999 Yes \n", "\n", " SCH_GRADE_PS SCH_GRADE_KG ... SCH_JJPART_15T30 SCH_JJPART_31T90 \\\n", "3 No No ... -7 -7 \n", "69 Yes Yes ... -9 -9 \n", "70 No No ... -9 -9 \n", "71 No No ... -9 -9 \n", "72 No No ... -9 -9 \n", "73 No No ... -9 -9 \n", "79 No No ... -9 -9 \n", "80 No Yes ... -9 -9 \n", "81 Yes No ... -9 -9 \n", "82 Yes No ... -9 -9 \n", "83 No No ... -9 -9 \n", "84 No No ... -9 -9 \n", "86 No No ... -9 -9 \n", "88 No No ... -9 -9 \n", "89 No No ... -9 -9 \n", "114 No No ... -9 -9 \n", "115 Yes Yes ... -9 -9 \n", "125 Yes No ... -9 -9 \n", "214 Yes No ... -9 -9 \n", "222 Yes No ... -9 -9 \n", "223 No No ... -9 -9 \n", "266 No No ... -9 -9 \n", "267 Yes Yes ... -9 -9 \n", "375 No No ... -9 -9 \n", "435 No No ... -9 -9 \n", "461 Yes No ... -9 -9 \n", "500 Yes No ... -9 -9 \n", "519 No No ... -9 -9 \n", "652 No No ... -9 -9 \n", "834 No No ... -9 -9 \n", "... ... ... ... ... ... \n", "71749 No No ... 41 29 \n", "71750 No No ... 38 17 \n", "71751 No No ... 164 122 \n", "71752 No No ... 68 44 \n", "71753 No No ... 29 20 \n", "71754 No No ... 2 8 \n", "71755 No No ... 44 14 \n", "71756 No No ... 53 32 \n", "71757 No No ... 29 26 \n", "71758 No No ... 35 17 \n", "71871 No No ... -9 -9 \n", "71872 No No ... -9 -9 \n", "71873 Yes Yes ... -9 -9 \n", "71874 No No ... -9 -9 \n", "71875 No No ... -9 -9 \n", "71876 No No ... -9 -9 \n", "71877 No No ... -7 -7 \n", "71878 No No ... -9 -9 \n", "71879 No No ... -9 -9 \n", "71880 No No ... -9 -9 \n", "71881 No No ... -9 -9 \n", "71882 No No ... -9 -9 \n", "71884 Yes Yes ... -9 -9 \n", "71939 No No ... -9 -9 \n", "74735 No No ... -9 -9 \n", "74784 Yes Yes ... -9 -9 \n", "74785 Yes Yes ... -9 -9 \n", "78833 No No ... 0 20 \n", "78834 No No ... 11 41 \n", "78835 No No ... 8 29 \n", "\n", " SCH_JJPART_91T180 SCH_JJPART_OV180 NCESSCH NAME LAT1516 LON1516 \\\n", "3 -7 -7 10000299995 NaN NaN NaN \n", "69 -9 -9 10002101832 NaN NaN NaN \n", "70 -9 -9 10002201833 NaN NaN NaN \n", "71 -9 -9 10002301834 NaN NaN NaN \n", "72 -9 -9 10002401835 NaN NaN NaN \n", "73 -9 -9 10002602352 NaN NaN NaN \n", "79 -9 -9 10003399998 NaN NaN NaN \n", "80 -9 -9 10003399999 NaN NaN NaN \n", "81 -9 -9 10003501845 NaN NaN NaN \n", "82 -9 -9 10003501846 NaN NaN NaN \n", "83 -9 -9 10003502105 NaN NaN NaN \n", "84 -9 -9 10003699999 NaN NaN NaN \n", "86 -9 -9 10003901850 NaN NaN NaN \n", "88 -9 -9 10004201853 NaN NaN NaN \n", "89 -9 -9 10004301854 NaN NaN NaN \n", "114 -9 -9 10017802374 NaN NaN NaN \n", "115 -9 -9 10018000032 NaN NaN NaN \n", "125 -9 -9 10018899999 NaN NaN NaN \n", "214 -9 -9 10033099999 NaN NaN NaN \n", "222 -9 -9 10036099998 NaN NaN NaN \n", "223 -9 -9 10036099999 NaN NaN NaN \n", "266 -9 -9 10039099996 NaN NaN NaN \n", "267 -9 -9 10039099999 NaN NaN NaN \n", "375 -9 -9 10084099999 NaN NaN NaN \n", "435 -9 -9 10105002373 NaN NaN NaN \n", "461 -9 -9 10114099999 NaN NaN NaN \n", "500 -9 -9 10123001634 NaN NaN NaN \n", "519 -9 -9 10129099998 NaN NaN NaN \n", "652 -9 -9 10174099999 NaN NaN NaN \n", "834 -9 -9 10207099999 NaN NaN NaN \n", "... ... ... ... ... ... ... \n", "71749 8 0 419999999989 NaN NaN NaN \n", "71750 0 0 419999999990 NaN NaN NaN \n", "71751 11 2 419999999992 NaN NaN NaN \n", "71752 5 0 419999999993 NaN NaN NaN \n", "71753 0 0 419999999994 NaN NaN NaN \n", "71754 0 0 419999999995 NaN NaN NaN \n", "71755 0 0 419999999996 NaN NaN NaN \n", "71756 2 0 419999999997 NaN NaN NaN \n", "71757 0 0 419999999998 NaN NaN NaN \n", "71758 0 0 419999999999 NaN NaN NaN \n", "71871 -9 -9 420077999999 NaN NaN NaN \n", "71872 -9 -9 420078299999 NaN NaN NaN \n", "71873 -9 -9 420078499999 NaN NaN NaN \n", "71874 -9 -9 420079699999 NaN NaN NaN \n", "71875 -9 -9 420080199999 NaN NaN NaN \n", "71876 -9 -9 420080299999 NaN NaN NaN \n", "71877 -7 -7 420080399999 NaN NaN NaN \n", "71878 -9 -9 420080599999 NaN NaN NaN \n", "71879 -9 -9 420080699999 NaN NaN NaN \n", "71880 -9 -9 420080799999 NaN NaN NaN \n", "71881 -9 -9 420080899999 NaN NaN NaN \n", "71882 -9 -9 420080999999 NaN NaN NaN \n", "71884 -9 -9 420081199999 NaN NaN NaN \n", "71939 -9 -9 420087199999 NaN NaN NaN \n", "74735 -9 -9 422683099999 NaN NaN NaN \n", "74784 -9 -9 429909199998 NaN NaN NaN \n", "74785 -9 -9 429909199999 NaN NaN NaN \n", "78833 41 20 47SOP0499991 NaN NaN NaN \n", "78834 80 83 47SOP0499994 NaN NaN NaN \n", "78835 47 44 47SOP0499999 NaN NaN NaN \n", "\n", " LEA_LAT1516 LEA_LON1516 \n", "3 NaN NaN \n", "69 NaN NaN \n", "70 NaN NaN \n", "71 NaN NaN \n", "72 NaN NaN \n", "73 NaN NaN \n", "79 NaN NaN \n", "80 NaN NaN \n", "81 NaN NaN \n", "82 NaN NaN \n", "83 NaN NaN \n", "84 NaN NaN \n", "86 NaN NaN \n", "88 NaN NaN \n", "89 NaN NaN \n", "114 NaN NaN \n", "115 NaN NaN \n", "125 NaN NaN \n", "214 NaN NaN \n", "222 NaN NaN \n", "223 NaN NaN \n", "266 NaN NaN \n", "267 NaN NaN \n", "375 NaN NaN \n", "435 NaN NaN \n", "461 NaN NaN \n", "500 NaN NaN \n", "519 NaN NaN \n", "652 NaN NaN \n", "834 NaN NaN \n", "... ... ... \n", "71749 NaN NaN \n", "71750 NaN NaN \n", "71751 NaN NaN \n", "71752 NaN NaN \n", "71753 NaN NaN \n", "71754 NaN NaN \n", "71755 NaN NaN \n", "71756 NaN NaN \n", "71757 NaN NaN \n", "71758 NaN NaN \n", "71871 NaN NaN \n", "71872 NaN NaN \n", "71873 NaN NaN \n", "71874 NaN NaN \n", "71875 NaN NaN \n", "71876 NaN NaN \n", "71877 NaN NaN \n", "71878 NaN NaN \n", "71879 NaN NaN \n", "71880 NaN NaN \n", "71881 NaN NaN \n", "71882 NaN NaN \n", "71884 NaN NaN \n", "71939 NaN NaN \n", "74735 NaN NaN \n", "74784 NaN NaN \n", "74785 NaN NaN \n", "78833 NaN NaN \n", "78834 NaN NaN \n", "78835 NaN NaN \n", "\n", "[942 rows x 1062 columns]" ] }, "execution_count": 60, "metadata": {}, "output_type": "execute_result" } ], "source": [ "final_2[pd.isnull(final_2['LEA_LAT1516']) & pd.isnull(final_2['LAT1516'])]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### LEA lat/longs fill in the remaining schools locations (minus 942 schools)" ] }, { "cell_type": "code", "execution_count": 64, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 64, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXQAAAD8CAYAAABn919SAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvIxREBQAAHChJREFUeJzt3X+QVeWd5/H3l7YbWgJpicAiyLbLsppMVJjpABazNQ6THh2ZSnpmY4wFE6cmpbtVu1W6bowwbZUxKxsyTCG1NVs7BcnMOCWrTtSQrBBJT0ZmaizsSRMQNMgq2lHBgna0R1RAaL77xz3dXLrvj3N/nHt+3M+rqot7zz339rdPXz793Oc8z3PM3RERkfSbFHcBIiJSHwp0EZGMUKCLiGSEAl1EJCMU6CIiGaFAFxHJCAW6iEhGKNBFRDJCgS4ikhEXhdnJzAaBE8AIcNbdu8xsBvA40AkMAl929/dKvc6ll17qnZ2dNZQrItJ89uzZ8467zyy3X6hAD/ymu7+Td38N8FN3X29ma4L795Z6gc7OTgYGBir4liIiYma/DLNfLV0uXwQeDm4/DPTU8FoiIlKjsIHuwE/MbI+Z3RFsm+3ubwME/84q9EQzu8PMBsxsYGhoqPaKRUSkoLBdLsvd/aiZzQL6zOzlsN/A3TcDmwG6urq0tKOISERCtdDd/Wjw73HgB8AS4JiZzQEI/j0eVZEiIlJe2UA3s6lmNm30NvDbwIvAj4Dbgt1uA34YVZEiIlJemC6X2cAPzGx0///j7s+Y2c+AvzGzrwFvADdHV6ZkzTX3P8P7p0fG7k+f3ML+B26MsSKR9Csb6O7+GnBtge3/DPxWFEVJto0Pc4D3T4/QuWY7g+tXTtj/vm0HeLT/TUbcmWSAw7lx+yxfMIOtt18HwLa9R9iw8xBHh0/SdtEkTp89V3C/fEvX9XHsxMdj92dPa6O/t7voz7Bqy26eO/zuhNcttr3Y88ZrMePWpZfzYM/VF/zcLWaMjLu6mAGvr185ofYpLcaZc4ztHxyyCxQ7DpJu1shL0HV1dbnGoUvnmu0lH88P9fu2HeCR59+o6/cfH2bjAzHf7GltnD7rDJ88A8AlF7dy6SfaeOX4h3WtKS6rl83nwZ6r4y5DyjCzPe7eVXY/Bbo0UqnwHDWlxXh53U1A+fCvVqFWa7PL/3QgyRI20CuZKSpSs3JhDnBqxOneuCvSVrDCfKIR97FPQwr1dNLiXJJIWenSSKNH+9+MuwSpklroEqmoW9pSf+NPvkp6qIUukVGYizSWWugSGYV5euWfjB4/Kih/WOhlHe3cc8OV9CyeG0eZMo4CXURKeu7wu1zVu4NTIxO7Yo4Mn2TtUwcAFOoJoC4XESmrUJiPOnlmhA07DzWwGilGLXQRqdnR4ZPqikkABbpIHSxfMIOBXw5fsMxAM+m4uJW1Tx3g5Jnckg7N2hUzfrmGRk/UUpeLRGb65Ja4S2iY5w6/27RhDvDeR2fGwnxUs3XFXNW7g0eef2Ns2OfoRK2l6/oaVoMCXSKj1RPl6PDJuEtoiKXr+oqeZzh24mNWbdndkDoU6CISmcs62uMuoSHKLWlRaoXNelKgi0jFJln5fVonGffccGX0xaTEfdsORP49dFJURCp2LsTqAKNnFPJHv3yyvRUzGP7oTNONhHnk+TciP0GqQBeRSIycc+56fB+tLcaZoH95dF15yI2Euevxfdz1+D6Aghc3SYvZ09pCrSQaNXW5iEikzpSYlJQvqrXvG6G/tztUN1TUFOgiInWQhEUqFegiInWQhBE9CnQRSYxGjdeOwsVt8cdp/BWIiASeO/xuakM9CctFa5SLRCopZ/8lPRo1CacWhRYiSwK10CVS/b3dcZcgUlfb9h5h7VMHODJ8Euf88MskUKCLiFRgw85DExYiSwoFumTe7GltLF8wI+4yJKQpLQkY0F1CkhccCx3oZtZiZnvN7Ong/l+Z2etmti/4WhRdmSLV6+/tZuvt1zXVcr5pdmrEG7LuSbU+2d5a9XO7N+6qXyEFVHJS9E7gIDA9b9s97v5EfUsSqb/ujbt4/3QyPybLRI/2vxnpuidL1/VVdbK+rcX4OOTM10JeOf4hS9f1RXZuKVQL3czmASuB70ZShUiElq7rS8SQMglvJMJpl1f17qh65FUtYT7q2ImPI/sEErbLZRPwDc4voDZqnZntN7OHzGxyfUsTqQ8Nm5RRpS5E0UiP9r8ZyeuWDXQz+13guLvvGffQWuAq4HPADODeIs+/w8wGzGxgaGio1nolZdK84JLEq96t2FVbdifmj3tUn0DCtNCXA18ws0HgMWCFmT3i7m97zmngL4ElhZ7s7pvdvcvdu2bOnFm3wkUk2+rdik3ShKUWi2YkT9lAd/e17j7P3TuBrwB/5+6rzWwOgJkZ0AO8GEmFItKU6tmK3bb3SN1eqx5uXXp5JK9by9T/rWY2EzBgH/Cf6lOSiEh9JWUmJ8DqZfMjG8FTUaC7+y5gV3B7RQT1iCTS8gUzEvWRXcK75v5n4i5hjEGkwzE1U1QilYUZmssXzGDr7dfFXUZTWrqur+bXSNL8g9cjvsyeAl0ilYVW7Z7B94Bc60oa69iJjyOfXdkIU1qsIddM1fK5ImWcGnENv4xR2ieFNfLi12qhi0RgbgIuRybxa2SYg1roInXX3trCPTdcSc/iuWPbVm3ZnYnupyS65v5nEtVPDjDJYOOXG79eoVroInU0+aJJfPv3r74gzAG23n4dC2dNjamq7Opcsz1xYQ65MB//HmgEBbpEJq3XhqzF6bPniv5H7rv7+sYWk3FJPK8xe1obg+tXxhLmoC4XiVCzdjEUCprZ09p0Ob4adK7Z3vD+6EolYXirWuiSGJdcXP2FA5Lu2ImPE9milPqJO8xBgS4J8sGps7RM0mhvSZ+kfHpQl4skxplzrsk7IjVQC10SJf5LD0gaqPuqMAW6SJ0k5WN31inMi1OgS6oV6nJvdDf89MktY2GuUI9WUsM8qmuEVkp96BKZFrNIL/YL4A6bblnEhp2HODp8kss62sdmaS5f/3ccGT5Z9++5cNbUkmPK80M9qQGURkk+lo88/wYQ7dK4YSjQJTK3Lr187I0elcs62ulZPLfgRI57briStU8d4OSZ+s0kLBbmS9f1XXC9So07bz6PPP9G7IGuLheJTNRv7tE1U4rpWTyXb//+1cztaMeAjvZWLrm4FSO3eNamWypfa+OV4x/SuWb72BdMDHPIjTuvx1reki5xL/WrFrqkxvTJLUxrb5vQtVJKsdb7qG/v+EVNV4Iv1Q2QlCvMS+PEvdSvAl0iVezSbUbpIYqzp7U1pAujv7c70X2zIpVQoEuktt5+3YSlY5Ow5oVIFinQJXJJDu9te4/U/BrjP01I84p7iWQFuqRWoa6SwfUri24vpPcHtY8fVreNjIp7iWSNcpFUKhaglW7/8OPahjSO/qGY0qJVaCR+CnSRKuW3+l9ed5NCvcktXzAj7hLU5SJSLy+vu+mC++qGya6Fs6ZeMEQxKSf6FegiVSp3FR0tAZBNq5fNj31GaDEKdEmVJF7hPYxyi3aNH9opyWTEv15LKaH70M2sxcz2mtnTwf0rzKzfzF4xs8fNrC26MkVqC/Okr4KYhI/rUt7rCX8fVdJCvxM4CEwP7n8HeMjdHzOzPwe+BvzvOtcnMqaSME/j4liNWJ1SqlNuhc2kCNVCN7N5wErgu8F9A1YATwS7PAz0RFGgSKXSGOaQW51SkmXTLYsYXL8yFWEO4Vvom4BvANOC+58Cht39bHD/LaDgCkhmdgdwB8D8+fOrr1SkhDi6VJLejSO1SePvt2ygm9nvAsfdfY+ZXT+6ucCuBT8ruvtmYDNAV1eXPk9KRcKMDpk+uWXsdiPWjdl0y6KyqzxW49H+N+v+mtJcwnS5LAe+YGaDwGPkulo2AR1mNvoHYR5wNJIKpWmFHeq3/4EbgcIjRZ47/C6rtuyuW02D61dGEuaA+s+lZmVb6O6+FlgLELTQv+7uq8zs+8CXyIX8bcAPI6xTpKxiw/6eO/zu2B8H4/xIBY0Nl2LiXmSrWrVM/b8XuNvMXiXXp/69+pQkEh0HrlCQSxlpOQk6XkUTi9x9F7AruP0asKT+JYlESx0bklVanEtSLf+EaNSLI6Vx1IM0FwW6pNroCVHIzbZMwop31bhvW+3rsotoLRdJtaXr+i6YRJQ/RPGKNdsLdq+MjrktdjGMQmZPa7tg33pPXtKQxeRI8ycxtdAl1Y6d+Jil6/oKPvb6+pUTJkzkj3IJY3D9yoKXmCv1fauhIYvJsOmWRXGXUBO10CX1Sl3Ps9bFlLo37ir6+vW8jqjWcUmGqOYYNIpa6JJYlXz07VyzfewrrKt6d5TdJ/8iBlHSOi7xS3NXyygFuiTa4PqVY19hhQ31UyPJaREneY1tSQ91uUhqFOrLDquWWaHFvu/safW9BMD4y5qJVEotdEmN/t7uqkK0ljBfOGtq0dEs9V6i97Whj+r6etJ8FOiSKv293RV3wVRr9KIGxf4g1HstGJ0UlVqpy0WkgDhOkBlaliAuWTghCmqhiySGwjweWQlzUKCLTFDo6i0iaaBAl9Qqtm7L+O2VtsCqnYx037YDLFi7g84121mwdofWZ5GGM2/giZiuri4fGBho2PeT7KvkknOVnMQc/0eg2hOgq5fNHxtjXqrW+7Yd4JHn36jqe0ht0tDlYmZ73L2r7H4KdGkWtQR6Na8Rlsafx6fei6xFJWygq8tFJGYK8/ikIcwroUAXEckIBbo0jTT0lUpjbdt7JO4S6koTiySzCvV3hznZqeBvHht2Hkr9krn5FOiSSaWm6+cHdqXhPbejnSPDJ2uqTZIja79LdbmIVOA3r5qpiUcZE8XIpbgo0EVC2rb3CE/uOXLBFH2FuySJulxEQtqw8xAnz4xcsC0r66+U6nrKUgs269RCFwnpaMb6W8NqMX0OSQsFumRSsRZnLSNYLutor/q5SVdq+J6ud5oeZaf+m9kU4B+AyeS6aJ5w9/vN7K+A3wD+Jdj1D919X6nX0tR/SbNte49w1+Ml3+KpNfmiSRx68HeKPp7ltWbSMEy1nlP/TwMr3P1aYBFwo5ktCx67x90XBV/ZfKeLBLI0Xnm802fPlXw8ixexbtSVrxqp7ElRzzXhPwjutgZfWTkXJBLa0nV9cZcgUlKoPnQzazGzfcBxoM/d+4OH1pnZfjN7yMwmR1alSAIcO/Fx3CXEJmsjXYqtpZ92oQLd3UfcfREwD1hiZp8F1gJXAZ8DZgD3Fnqumd1hZgNmNjA0NFSnskWknkoF3FW9OxpYSWMUWzM/7Soa5eLuw8Au4EZ3f9tzTgN/CSwp8pzN7t7l7l0zZ86suWARqb9SAXdqRD2saVE20M1sppl1BLfbgc8DL5vZnGCbAT3Ai1EWKhK32dPa4i5BpKQwLfQ5wLNmth/4Gbk+9KeBrWZ2ADgAXAo8GF2ZIvHr7+1WqFdgdBTJwllT4y6laZQNdHff7+6L3f0ad/+su38r2L7C3a8Otq129w/KvZZI2mXtCjfl1GNkT9/d19deiISimaIiUlQWR/Zkbex5Pi3OJSIFXXP/M3GXUDdZDvF8aqGLVGDVlt1xl9Aw758eKb+TJIoCXaQCzx1+t6bnr142v06V1FfWJg41KwW6SAMleYErhXr6KdBFJHJx9mE3S/856KSoSEWWL5hRc7dLkl2xZjuXdbRzzw1Xxl1K1QzGfoYsr5BZiAJdpAJbb7+OVVt2ZzbUHTgyfJK1Tx2Iu5Sqvd5ELfLx1OUiUqGsLuyUb/y1Uyt1ka5aFwsFukiFdPKwvFe/3byt5Dgp0EUkM5rpBGghCnQRyYRmD3NQoItUpHvjrrhLEClKgS5SgVeOfxh3CSJFKdBFIrbplkXM7WiPu4xMU3dLjsahi4RU7cJcdz2+r86VSD6F+XlqoYuElNXJRI3SYhqcHjUFuog0xIjX/2LTap1fSIEuIqmkMJ9IgS4S0vIFM4puV7g0lo53YQp0kZC23n7dhFBfvmBGU6ztIumgUS4iFSgV3oPrV2qdF4mVWugiEjn9oWsMtdBF6kit9Bwdg3iohS5SZ8VOnopETYEuUmeFTp6KNIK6XEQiMP7k6eJv/YT3PjoTUzXSLMq20M1sipn9k5m9YGYvmdkDwfYrzKzfzF4xs8fNrC36ckXSaVhhLg0QpsvlNLDC3a8FFgE3mtky4DvAQ+6+EHgP+Fp0ZYqk22VabVEaoGyge84Hwd3W4MuBFcATwfaHgZ5IKhTJgHtuuDLuEjLlqt4dcZeQSKFOippZi5ntA44DfcBhYNjdzwa7vAXMjaZEkfTrWTyXjvbWuMvIjFMj9V/oKwtCBbq7j7j7ImAesAT4dKHdCj3XzO4wswEzGxgaGqq+UpGUmzlNp5kkWhWNcnH3YTPbBSwDOszsoqCVPg84WuQ5m4HNAF1dXfqzKk1p1ZbdBS9fNwk4BxhFWkQpsXDWVPruvr7gY5pk1DhhRrnMNLOO4HY78HngIPAs8KVgt9uAH0ZVpEjaFbs4xrng3ymtk7jk4lbSegmIYmEOWhmxkcJ0ucwBnjWz/cDPgD53fxq4F7jbzF4FPgV8L7oyRbLt5JlzfHDqLA+l8PqjYQJ7trqbGiLMKJf97r7Y3a9x98+6+7eC7a+5+xJ3/7fufrO7n46+XJHsOnPO2bDzUKwjYhbOmlpRizrsvv293Qr1BtDUf5EGCLsUwNHhk/QsbuyAMQNWL5vP4PqVY10nYYK60q6U/t5uBtevZPWy+WPXF20xY/Wy+ZWWLEWYR3Cdv2K6urp8YGCgYd9PJElWbdld9kLTczvaeW7NioaeSNx0y6KSf0QK1RJFv3ilP3Mz9c2b2R537yq7nwJdpLG27T3CPU+8wJlxY6lbJxkbbr52LFwbFepJCsZKfuYk1R21sIGuxblEGmw0sB/4vy+NLdjV0d7KN7/wKw3vbmmmUGwGCnSRGPQsntvw8B5PYZ49Oikq0oSyEOaasDSRAl2kicye1paJMJfCFOgiCVXv4J09rY3+3u66vqYki/rQRRJsNNS7N+4quBZMpa+TZOpCqZ1a6CIp0Hf39akI5UbTH4ELKdBFUkLhVZiOy3kKdBGRjFCgi2Rc2HVkJP0U6CIZt/X26+IuQRpEgS6SYWm9YIZUR4EuklEGvK6RMU1FgS6SQe2tkxTmTUiBLpJB8y5J12XsoLbJTxq6mKNAF8mgV45/yKotu+Muo2KaPFUbBbpISkyf3FLR/uWujpRUCvXqKdBFUmL/AzfGXYIknAJdJMO6N+6KuwRpIAW6SIbVskJjmrSYRtyDAl0kVdS/XNitSy+Pu4REUKCLpIxCfaIHe66Ou4REUKCLpFDYUF84a2rElURDf7SqoysWiaTU4PqVZSfU9N19fWOKicD4UNfkofLKttDN7HIze9bMDprZS2Z2Z7D9m2Z2xMz2BV83RV+uiOQbXL+yaGtWrdzmY+5eegezOcAcd/+5mU0D9gA9wJeBD9z9T8N+s66uLh8YGKilXhFpYoVa6c3wh8vM9rh7V7n9yna5uPvbwNvB7RNmdhCYW3uJIiKVaYbwrkVFJ0XNrBNYDPQHm/6Lme03s78ws0uKPOcOMxsws4GhoaGaihURkeLKdrmM7Wj2CeDvgXXu/pSZzQbeARz47+S6Zf6o1Guoy0VEwmrW7pVCwna5hGqhm1kr8CSw1d2fAnD3Y+4+4u7ngC3AkloKFhEZVWxEi0a6lBZmlIsB3wMOuvvGvO1z8nb7PeDF+pcnIiJhhRmHvhz4A+CAme0Ltv0xcKuZLSLX5TII/MdIKhQRkVDCjHL5Rwpfa3ZH/csREZFqaeq/iEhGKNBFJHE0+7U6WstFRBJJ4V05tdBFRDJCgS4ikhEKdBGRjFCgi4hkhAJdRCQjFOgiIhmhQBcRyQgFuohIRijQRUQyQoEuIpIRCnQRkYxQoIuIZIQCXUQkIxToIiIZoUAXEcmIxK+HXugq31onWURkokS30AuFeantIiLNLNGBLiIi4SnQRUQyQoEuIpIRCnQRkYxIdKAXG82iUS4iIhMlftiiwltEJJyyLXQzu9zMnjWzg2b2kpndGWyfYWZ9ZvZK8O8l0ZcrIiLFhOlyOQv8N3f/NLAM+M9m9hlgDfBTd18I/DS4LyIiMSkb6O7+trv/PLh9AjgIzAW+CDwc7PYw0BNVkSIiUl5FJ0XNrBNYDPQDs939bciFPjCr3sWJiEh4oQPdzD4BPAnc5e7vV/C8O8xswMwGhoaGqqlRRERCMHcvv5NZK/A0sNPdNwbbDgHXu/vbZjYH2OXuV5Z5nSHglyV2uRR4J2zxGadjcZ6OxXk6Fuc107H41+4+s9xOZYctmpkB3wMOjoZ54EfAbcD64N8flnutcgWZ2YC7d5V7nWagY3GejsV5Ohbn6VhMFGYc+nLgD4ADZrYv2PbH5IL8b8zsa8AbwM3RlCgiImGUDXR3/0fAijz8W/UtR0REqpW0qf+b4y4gQXQsztOxOE/H4jwdi3FCnRQVEZHkS1oLXUREqhRLoJvZzcG6MOfMrGvcY9eY2e7g8QNmNiXY/mvB/VfN7H8Go29Sr9SxCB6fb2YfmNnX87bdaGaHgmORmSUXih0LM+s2sz3B73+Pma3Ie6zp3hdmtjb4eQ+Z2Q152zP5vhjPzBaZ2fNmti+Y47Ik2G7Be+BVM9tvZr8ad60N5+4N/wI+DVwJ7AK68rZfBOwHrg3ufwpoCW7/E3AduRO0PwZ+J47aG3Us8h5/Evg+8PXgfgtwGPg3QBvwAvCZuH+OiN8Xi4HLgtufBY7kPdZU7wvgM8HvfDJwRfBeaMny+6LAsfnJ6O8ZuIncHJjR2z8O3gvLgP64a230VyzL57r7QYACjanfBva7+wvBfv8c7DcHmO7uu4P7f01u7ZgfN6rmqJQ4FphZD/Aa8GHe5iXAq+7+WrDPY+TW1flF5MVGrNixcPe9eXdfAqaY2WRgBs33vvgi8Ji7nwZeN7NXyb0nIKPviwIcmB7c/iRwNLj9ReCvPZfuz5tZh5nN8WCJkmaQtD70fwe4me00s5+b2TeC7XOBt/L2eyvYlllmNhW4F3hg3ENzgTfz7mf+WIzzH4C9QaA13fuC4r//Znpf3AVsMLM3gT8F1gbbm+kYFBRZC93M/hb4VwUe6nX3YrNKLwJ+Hfgc8BHwUzPbAxRaOyY1w3OqPBYPAA+5+wfjWmmF+oizfixGn/srwHfIfZKD5jwWxX7mQo2z1ByL8UodG3LzX/6ruz9pZl8mN5P986T8/VAPkQW6u3++iqe9Bfy9u78DYGY7gF8FHgHm5e03j/MfsxKvymOxFPiSmf0J0AGcM7NTwB7g8rz9muFYYGbzgB8AX3X3w8Hmt2i+98VbFP/9p/Z9MV6pYxN0rd0Z3P0+8N3gdqlj0xSS1uWyE7jGzC42s4uA3wB+EfSBnTCzZcEohq8SYu2YNHP3f+/une7eCWwC/oe7/xnwM2ChmV1hZm3AV8itq5NZZtYBbAfWuvtzo9ub8X1B7nf9FTObbGZXAAvJnRhupvfFUXLZALACeCW4/SPgq8Fol2XAvzRT/zkQ2yiX3yP31/Q0cIzcKo6jj60md+LrReBP8rZ3BdsOA39GMCkq7V+ljkXePt8kGOUS3L8J+H/BseiN+2eI+lgA95E7Mbwv72tWs74vyHU7HAYOkTeqJ6vviwLH5tfJfVJ9gdy1GX4t2G7A/wp+/gMUGDWW9S/NFBURyYikdbmIiEiVFOgiIhmhQBcRyQgFuohIRijQRUQyQoEuIpIRCnQRkYxQoIuIZMT/B0e83S9M9BjxAAAAAElFTkSuQmCC\n", "text/plain": [ "
" ] }, "metadata": { "needs_background": "light" }, "output_type": "display_data" } ], "source": [ "plt.scatter(x=final_2['LEA_LON1516'], y=final_2['LEA_LAT1516'])" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Where there were no school-level Lat/Long, use LEA (district) Lat/Longs.\n", "Note that there are 942 schools with neither school-level or LEA-level coordinates." ] }, { "cell_type": "code", "execution_count": 66, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
SCH_PSENR_HI_MSCH_PSENR_HI_FSCH_PSENR_AM_MSCH_PSENR_AM_FSCH_PSENR_AS_MSCH_PSENR_AS_FSCH_PSENR_HP_MSCH_PSENR_HP_FSCH_PSENR_BL_MSCH_PSENR_BL_F...SCH_JJHOURSSCH_JJPART_LT15SCH_JJPART_15T30SCH_JJPART_31T90SCH_JJPART_91T180SCH_JJPART_OV180LAT1516LON1516LEA_LAT1516LEA_LON1516
count96360.00000096360.00000096360.00000096360.00000096360.00000096360.00000096360.00000096360.00000096360.00000096360.000000...96360.00000096360.00000096360.00000096360.00000096360.00000096360.00000095418.00000095418.00000078056.00000078056.000000
mean-3.683562-3.949336-6.089705-6.102491-5.846876-5.909423-6.175467-6.182015-4.579763-4.733105...-8.912557-8.821254-8.911914-8.896658-8.927615-8.94739538.134749-92.90742038.431997-88.955788
std12.32209011.5456214.4827614.4329865.1132814.9027214.2218144.2103439.5951409.148189...1.8379699.0531193.1678783.4355282.1779941.5514255.31622516.0243195.31962313.063124
min-9.000000-9.000000-9.000000-9.000000-9.000000-9.000000-9.000000-9.000000-9.000000-9.000000...-9.000000-9.000000-9.000000-9.000000-9.000000-9.00000019.039730-176.63985321.308737-157.854998
25%-9.000000-9.000000-9.000000-9.000000-9.000000-9.000000-9.000000-9.000000-9.000000-9.000000...-9.000000-9.000000-9.000000-9.000000-9.000000-9.00000034.092015-100.01638334.935200-95.789531
50%-9.000000-9.000000-9.000000-9.000000-9.000000-9.000000-9.000000-9.000000-9.000000-9.000000...-9.000000-9.000000-9.000000-9.000000-9.000000-9.00000038.949950-89.01860139.804010-86.431091
75%0.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.000000...-9.000000-9.000000-9.000000-9.000000-9.000000-9.00000041.715340-81.10350042.161800-80.093271
max392.000000365.00000068.00000065.000000131.000000104.00000023.00000026.000000335.000000326.000000...180.0000002150.000000611.000000515.000000320.000000152.00000071.300337-66.98938748.993407-66.989387
\n", "

8 rows × 1009 columns

\n", "
" ], "text/plain": [ " SCH_PSENR_HI_M SCH_PSENR_HI_F SCH_PSENR_AM_M SCH_PSENR_AM_F \\\n", "count 96360.000000 96360.000000 96360.000000 96360.000000 \n", "mean -3.683562 -3.949336 -6.089705 -6.102491 \n", "std 12.322090 11.545621 4.482761 4.432986 \n", "min -9.000000 -9.000000 -9.000000 -9.000000 \n", "25% -9.000000 -9.000000 -9.000000 -9.000000 \n", "50% -9.000000 -9.000000 -9.000000 -9.000000 \n", "75% 0.000000 0.000000 0.000000 0.000000 \n", "max 392.000000 365.000000 68.000000 65.000000 \n", "\n", " SCH_PSENR_AS_M SCH_PSENR_AS_F SCH_PSENR_HP_M SCH_PSENR_HP_F \\\n", "count 96360.000000 96360.000000 96360.000000 96360.000000 \n", "mean -5.846876 -5.909423 -6.175467 -6.182015 \n", "std 5.113281 4.902721 4.221814 4.210343 \n", "min -9.000000 -9.000000 -9.000000 -9.000000 \n", "25% -9.000000 -9.000000 -9.000000 -9.000000 \n", "50% -9.000000 -9.000000 -9.000000 -9.000000 \n", "75% 0.000000 0.000000 0.000000 0.000000 \n", "max 131.000000 104.000000 23.000000 26.000000 \n", "\n", " SCH_PSENR_BL_M SCH_PSENR_BL_F ... SCH_JJHOURS \\\n", "count 96360.000000 96360.000000 ... 96360.000000 \n", "mean -4.579763 -4.733105 ... -8.912557 \n", "std 9.595140 9.148189 ... 1.837969 \n", "min -9.000000 -9.000000 ... -9.000000 \n", "25% -9.000000 -9.000000 ... -9.000000 \n", "50% -9.000000 -9.000000 ... -9.000000 \n", "75% 0.000000 0.000000 ... -9.000000 \n", "max 335.000000 326.000000 ... 180.000000 \n", "\n", " SCH_JJPART_LT15 SCH_JJPART_15T30 SCH_JJPART_31T90 SCH_JJPART_91T180 \\\n", "count 96360.000000 96360.000000 96360.000000 96360.000000 \n", "mean -8.821254 -8.911914 -8.896658 -8.927615 \n", "std 9.053119 3.167878 3.435528 2.177994 \n", "min -9.000000 -9.000000 -9.000000 -9.000000 \n", "25% -9.000000 -9.000000 -9.000000 -9.000000 \n", "50% -9.000000 -9.000000 -9.000000 -9.000000 \n", "75% -9.000000 -9.000000 -9.000000 -9.000000 \n", "max 2150.000000 611.000000 515.000000 320.000000 \n", "\n", " SCH_JJPART_OV180 LAT1516 LON1516 LEA_LAT1516 \\\n", "count 96360.000000 95418.000000 95418.000000 78056.000000 \n", "mean -8.947395 38.134749 -92.907420 38.431997 \n", "std 1.551425 5.316225 16.024319 5.319623 \n", "min -9.000000 19.039730 -176.639853 21.308737 \n", "25% -9.000000 34.092015 -100.016383 34.935200 \n", "50% -9.000000 38.949950 -89.018601 39.804010 \n", "75% -9.000000 41.715340 -81.103500 42.161800 \n", "max 152.000000 71.300337 -66.989387 48.993407 \n", "\n", " LEA_LON1516 \n", "count 78056.000000 \n", "mean -88.955788 \n", "std 13.063124 \n", "min -157.854998 \n", "25% -95.789531 \n", "50% -86.431091 \n", "75% -80.093271 \n", "max -66.989387 \n", "\n", "[8 rows x 1009 columns]" ] }, "execution_count": 66, "metadata": {}, "output_type": "execute_result" } ], "source": [ "final_2.loc[pd.isnull(final_2['LAT1516']), 'LAT1516'] = final_2['LEA_LAT1516']\n", "final_2.loc[pd.isnull(final_2['LON1516']), 'LON1516'] = final_2['LEA_LON1516']\n", "\n", "# final_2[pd.isnull(final_2['LON1516'])]\n", "final_2.describe()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Save CRDC data with Lat/Longs to CSV" ] }, { "cell_type": "code", "execution_count": 68, "metadata": {}, "outputs": [], "source": [ "final_2.to_csv('crdc-data-with-lat-long.csv')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Ask and answer analytic questions. \n", "Ask three analytic questions and answer each one with a combination of statistics and visualizations. These analytic questions can focus on individuals behaviors or comparisons of the population." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Propose further research.\n", "Lastly, make a proposal for a realistic future research project on this dataset that would use some data science techniques you'd like to learn in the bootcamp. Just like your earlier questions, your research proposal should present one or more clear questions. Then you should describe the techniques you would apply in order to arrive at an answer." ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.7.0" } }, "nbformat": 4, "nbformat_minor": 2 }