511_ProjectStep2.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyMfGhm1gzgd2DzQ02dWOcik",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/pooja-thalur/511_SimilarityMatching/blob/main/511_ProjectStep2.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "PIEsit6P1Sx4"
      },
      "outputs": [],
      "source": [
        "import pandas as pd"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df = pd.read_csv('/content/sample_data/ProjectStep2.csv')\n",
        "df.head()\n",
        "\n",
        "#drop unnecessary columns\n",
        "cols = ['State Name [District] 2022-23', 'Web Site URL [District] 2022-23','Phone Number [District] 2022-23','Location Address 1 [District] 2022-23']\n",
        "df = df.drop(cols,axis=1)\n",
        "\n",
        "#checking for values with na in both rows and columns\n",
        "df.isna().any(axis=0)\n",
        "df.isna().any(axis=1)\n",
        "df.dropna()\n",
        "\n",
        "#removing unwanted string in the headers\n",
        "df.columns=df.columns.str.replace('\\[District\\] 2022-23','')\n",
        "\n",
        "\n",
        "county_names= df['County Name '].value_counts().index.tolist()\n",
        "\n",
        "maricopa=[0]* len(df)\n",
        "pinal=[0]* len(df)\n",
        "#Transform Country name column by converting it to binary\n",
        "for i in range (0,len(df)):\n",
        "  if df.iloc[i]['County Name ']=='Maricopa County':\n",
        "    maricopa[i]=1\n",
        "  else:\n",
        "    pinal[i]=1\n",
        "#add county names into df\n",
        "df[county_names[0]] = maricopa\n",
        "df[county_names[1]] = pinal\n",
        "\n",
        "# #since County Name is redundant and not necessary drop the column\n",
        "df.drop('County Name ', axis=1, inplace=True)\n",
        "df.head()\n",
        "\n",
        "# #convert the value of Ap Program offered column from Yes and NO to 0,1s\n",
        "df['AP Program Offered'].value_counts()\n",
        "# # NO     321\n",
        "# # YES     33\n",
        "df['AP Program Offered'].replace('YES', 1, inplace=True)\n",
        "df['AP Program Offered'].replace('NO', 0, inplace=True)\n",
        "\n",
        "df['Locale '].value_counts()\n",
        "\n",
        "# https://nces.ed.gov/programs/edge/docs/locale_classifications.pdf\n",
        "# 11-City: Large         189\n",
        "# 21-Suburb: Large        65\n",
        "# 41-Rural: Fringe        25\n",
        "# 12-City: Mid-size       20\n",
        "# 22-Suburb: Mid-size     17\n",
        "# 42-Rural: Distant       14\n",
        "# 13-City: Small           8\n",
        "# 32-Town: Distant         6\n",
        "# 31-Town: Fringe          5\n",
        "# 43-Rural: Remote         4\n",
        "# 33-Town: Remote          1\n",
        "\n",
        "#converting to nces locale classification code\n",
        "df['Locale '] = df['Locale '].str[:2]\n",
        "df['Locale '].value_counts()\n",
        "\n",
        "for i in df['Locale '].value_counts().index.tolist():\n",
        "  df['Locale '].replace(i, 'Locale_'+i, inplace=True)\n",
        "  df['Locale_'+i] = [0]*len(df)\n",
        "\n",
        "#Since it is Nominal,\n",
        "#Now convert them into different columns\n",
        "#iterate over each row and assign their corresponding locale\n",
        "for i in range(0,len(df['Locale '])):\n",
        "  df[df['Locale '].iloc[i]].iloc[i]=1\n",
        "\n",
        "#since locale is not necessary drop the locale column\n",
        "df.drop('Locale ', axis=1, inplace=True)\n",
        "\n",
        "#now convert the charter status from string to binary attribute\n",
        "df['LEA Charter Status '].value_counts()\n",
        "df['LEA Charter Status '] = df['LEA Charter Status '].apply(lambda x: 0 if 'not' in x else 1)\n",
        "\n",
        "#now convert the numeric columns to int or float as required\n",
        "c = {'Male Students ': int,'Female Students ': int,'Total Students, All Grades (Excludes AE) ': int,\n",
        "     'Total Students, All Grades (Includes AE) ': int,'American Indian/Alaska Native Students ': int,\n",
        "     'Asian or Asian/Pacific Islander Students ': int,'Hispanic Students ': int,\n",
        "                'Black or African American Students ':int,'White Students ':int,\n",
        "     'Nat. Hawaiian or Other Pacific Isl. Students ':int\n",
        "                }\n",
        "df = df.astype(c)\n",
        "\n",
        "#remove duplicates\n",
        "df.duplicated().sum()\n",
        "df=df.drop_duplicates()\n",
        "# df.columns\n",
        "df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "Xt3j_G4S1XLa",
        "outputId": "b9866757-c1b0-4bf6-ff63-f229cd31672f"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "<ipython-input-20-4acec4ae2390>:14: FutureWarning: The default value of regex will change from True to False in a future version.\n",
            "  df.columns=df.columns.str.replace('\\[District\\] 2022-23','')\n",
            "<ipython-input-20-4acec4ae2390>:69: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "  df[df['Locale '].iloc[i]].iloc[i]=1\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                           School Name Location City   \\\n",
              "0                         A+ CHARTER SCHOOLS (1000166)       MARICOPA   \n",
              "1          ACADEMY WITH COMMUNITY PARTNERS INC (79213)           MESA   \n",
              "2              ACCELERATED LEARNING CENTER INC. (4297)        PHOENIX   \n",
              "3                        ACCLAIM CHARTER SCHOOL (4325)        PHOENIX   \n",
              "4          AGUA FRIA UNION HIGH SCHOOL DISTRICT (4289)       AVONDALE   \n",
              "..                                                 ...            ...   \n",
              "349  WEST VALLEY ARTS AND TECHNOLOGY ACADEMY INC. (...         LAVEEN   \n",
              "350  WEST-MEC - WESTERN MARICOPA EDUCATION CENTER (...       GLENDALE   \n",
              "351  WESTERN SCHOOL OF SCIENCE AND TECHNOLOGY INC. ...        PHOENIX   \n",
              "352                 WICKENBURG UNIFIED DISTRICT (4236)     WICKENBURG   \n",
              "353                  WILSON ELEMENTARY DISTRICT (4261)        PHOENIX   \n",
              "\n",
              "     Location ZIP   Latitude   Longitude   LEA Charter Status   \\\n",
              "0            85138  33.042533 -112.015895                    1   \n",
              "1            85203  33.423526 -111.793077                    1   \n",
              "2            85028  33.582212 -111.992879                    0   \n",
              "3            85033  33.495776 -112.224385                    1   \n",
              "4            85323  33.450600 -112.336700                    0   \n",
              "..             ...        ...         ...                  ...   \n",
              "349          85339  33.394980 -112.167071                    1   \n",
              "350          85305  33.515170 -112.271701                    0   \n",
              "351          85033  33.493699 -112.200226                    1   \n",
              "352          85390  33.968197 -112.728728                    0   \n",
              "353          85008  33.454591 -112.016200                    0   \n",
              "\n",
              "     Total Students, All Grades (Excludes AE)   \\\n",
              "0                                          268   \n",
              "1                                          171   \n",
              "2                                          153   \n",
              "3                                          268   \n",
              "4                                         9632   \n",
              "..                                         ...   \n",
              "349                                        247   \n",
              "350                                        292   \n",
              "351                                        522   \n",
              "352                                       1298   \n",
              "353                                       1077   \n",
              "\n",
              "     Total Students, All Grades (Includes AE)   Male Students   \\\n",
              "0                                          268             155   \n",
              "1                                          171              89   \n",
              "2                                          153              72   \n",
              "3                                          268             151   \n",
              "4                                         9632            4899   \n",
              "..                                         ...             ...   \n",
              "349                                        247             130   \n",
              "350                                        292             164   \n",
              "351                                        522             245   \n",
              "352                                       1298             651   \n",
              "353                                       1077             532   \n",
              "\n",
              "     Female Students   ...  Locale_21  Locale_41  Locale_12  Locale_22  \\\n",
              "0                 113  ...          0          0          0          0   \n",
              "1                  82  ...          0          0          0          0   \n",
              "2                  81  ...          0          0          0          0   \n",
              "3                 117  ...          0          0          0          0   \n",
              "4                4733  ...          0          0          0          1   \n",
              "..                ...  ...        ...        ...        ...        ...   \n",
              "349               117  ...          0          0          0          0   \n",
              "350               128  ...          0          0          0          0   \n",
              "351               277  ...          0          0          0          0   \n",
              "352               647  ...          0          1          0          0   \n",
              "353               545  ...          0          0          0          0   \n",
              "\n",
              "     Locale_42  Locale_13  Locale_32  Locale_31  Locale_43  Locale_33  \n",
              "0            0          0          1          0          0          0  \n",
              "1            0          0          0          0          0          0  \n",
              "2            0          0          0          0          0          0  \n",
              "3            0          0          0          0          0          0  \n",
              "4            0          0          0          0          0          0  \n",
              "..         ...        ...        ...        ...        ...        ...  \n",
              "349          0          0          0          0          0          0  \n",
              "350          0          0          0          0          0          0  \n",
              "351          0          0          0          0          0          0  \n",
              "352          0          0          0          0          0          0  \n",
              "353          0          0          0          0          0          0  \n",
              "\n",
              "[354 rows x 31 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-e12fda78-ccf2-41fc-97e4-5dbbb4c98951\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>School Name</th>\n",
              "      <th>Location City</th>\n",
              "      <th>Location ZIP</th>\n",
              "      <th>Latitude</th>\n",
              "      <th>Longitude</th>\n",
              "      <th>LEA Charter Status</th>\n",
              "      <th>Total Students, All Grades (Excludes AE)</th>\n",
              "      <th>Total Students, All Grades (Includes AE)</th>\n",
              "      <th>Male Students</th>\n",
              "      <th>Female Students</th>\n",
              "      <th>...</th>\n",
              "      <th>Locale_21</th>\n",
              "      <th>Locale_41</th>\n",
              "      <th>Locale_12</th>\n",
              "      <th>Locale_22</th>\n",
              "      <th>Locale_42</th>\n",
              "      <th>Locale_13</th>\n",
              "      <th>Locale_32</th>\n",
              "      <th>Locale_31</th>\n",
              "      <th>Locale_43</th>\n",
              "      <th>Locale_33</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>A+ CHARTER SCHOOLS (1000166)</td>\n",
              "      <td>MARICOPA</td>\n",
              "      <td>85138</td>\n",
              "      <td>33.042533</td>\n",
              "      <td>-112.015895</td>\n",
              "      <td>1</td>\n",
              "      <td>268</td>\n",
              "      <td>268</td>\n",
              "      <td>155</td>\n",
              "      <td>113</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>ACADEMY WITH COMMUNITY PARTNERS INC (79213)</td>\n",
              "      <td>MESA</td>\n",
              "      <td>85203</td>\n",
              "      <td>33.423526</td>\n",
              "      <td>-111.793077</td>\n",
              "      <td>1</td>\n",
              "      <td>171</td>\n",
              "      <td>171</td>\n",
              "      <td>89</td>\n",
              "      <td>82</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>ACCELERATED LEARNING CENTER INC. (4297)</td>\n",
              "      <td>PHOENIX</td>\n",
              "      <td>85028</td>\n",
              "      <td>33.582212</td>\n",
              "      <td>-111.992879</td>\n",
              "      <td>0</td>\n",
              "      <td>153</td>\n",
              "      <td>153</td>\n",
              "      <td>72</td>\n",
              "      <td>81</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>ACCLAIM CHARTER SCHOOL (4325)</td>\n",
              "      <td>PHOENIX</td>\n",
              "      <td>85033</td>\n",
              "      <td>33.495776</td>\n",
              "      <td>-112.224385</td>\n",
              "      <td>1</td>\n",
              "      <td>268</td>\n",
              "      <td>268</td>\n",
              "      <td>151</td>\n",
              "      <td>117</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>AGUA FRIA UNION HIGH SCHOOL DISTRICT (4289)</td>\n",
              "      <td>AVONDALE</td>\n",
              "      <td>85323</td>\n",
              "      <td>33.450600</td>\n",
              "      <td>-112.336700</td>\n",
              "      <td>0</td>\n",
              "      <td>9632</td>\n",
              "      <td>9632</td>\n",
              "      <td>4899</td>\n",
              "      <td>4733</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>349</th>\n",
              "      <td>WEST VALLEY ARTS AND TECHNOLOGY ACADEMY INC. (...</td>\n",
              "      <td>LAVEEN</td>\n",
              "      <td>85339</td>\n",
              "      <td>33.394980</td>\n",
              "      <td>-112.167071</td>\n",
              "      <td>1</td>\n",
              "      <td>247</td>\n",
              "      <td>247</td>\n",
              "      <td>130</td>\n",
              "      <td>117</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>350</th>\n",
              "      <td>WEST-MEC - WESTERN MARICOPA EDUCATION CENTER (...</td>\n",
              "      <td>GLENDALE</td>\n",
              "      <td>85305</td>\n",
              "      <td>33.515170</td>\n",
              "      <td>-112.271701</td>\n",
              "      <td>0</td>\n",
              "      <td>292</td>\n",
              "      <td>292</td>\n",
              "      <td>164</td>\n",
              "      <td>128</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>351</th>\n",
              "      <td>WESTERN SCHOOL OF SCIENCE AND TECHNOLOGY INC. ...</td>\n",
              "      <td>PHOENIX</td>\n",
              "      <td>85033</td>\n",
              "      <td>33.493699</td>\n",
              "      <td>-112.200226</td>\n",
              "      <td>1</td>\n",
              "      <td>522</td>\n",
              "      <td>522</td>\n",
              "      <td>245</td>\n",
              "      <td>277</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>352</th>\n",
              "      <td>WICKENBURG UNIFIED DISTRICT (4236)</td>\n",
              "      <td>WICKENBURG</td>\n",
              "      <td>85390</td>\n",
              "      <td>33.968197</td>\n",
              "      <td>-112.728728</td>\n",
              "      <td>0</td>\n",
              "      <td>1298</td>\n",
              "      <td>1298</td>\n",
              "      <td>651</td>\n",
              "      <td>647</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>353</th>\n",
              "      <td>WILSON ELEMENTARY DISTRICT (4261)</td>\n",
              "      <td>PHOENIX</td>\n",
              "      <td>85008</td>\n",
              "      <td>33.454591</td>\n",
              "      <td>-112.016200</td>\n",
              "      <td>0</td>\n",
              "      <td>1077</td>\n",
              "      <td>1077</td>\n",
              "      <td>532</td>\n",
              "      <td>545</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>354 rows × 31 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-e12fda78-ccf2-41fc-97e4-5dbbb4c98951')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-e12fda78-ccf2-41fc-97e4-5dbbb4c98951 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-e12fda78-ccf2-41fc-97e4-5dbbb4c98951');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-c0b1a226-caaf-4e48-954e-c395eda9f2d4\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-c0b1a226-caaf-4e48-954e-c395eda9f2d4')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-c0b1a226-caaf-4e48-954e-c395eda9f2d4 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "df"
            }
          },
          "metadata": {},
          "execution_count": 20
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "mTxZQgP0PY2B",
        "outputId": "86f95a1d-de34-41eb-d53a-5f251f2337ff"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "School Name\n",
            "Location City \n",
            "Location ZIP \n",
            "Latitude \n",
            "Longitude \n",
            "LEA Charter Status \n",
            "Total Students, All Grades (Excludes AE) \n",
            "Total Students, All Grades (Includes AE) \n",
            "Male Students \n",
            "Female Students \n",
            "American Indian/Alaska Native Students \n",
            "Asian or Asian/Pacific Islander Students \n",
            "Hispanic Students \n",
            "Black or African American Students \n",
            "White Students \n",
            "Nat. Hawaiian or Other Pacific Isl. Students \n",
            "Two or More Races Students \n",
            "AP Program Offered\n",
            "Maricopa County\n",
            "Pinal County\n",
            "Locale_11\n",
            "Locale_21\n",
            "Locale_41\n",
            "Locale_12\n",
            "Locale_22\n",
            "Locale_42\n",
            "Locale_13\n",
            "Locale_32\n",
            "Locale_31\n",
            "Locale_43\n",
            "Locale_33\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "YVp80wn9THof"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}