Code #4 - CreateEDADataset.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"Code #4 - CreateEDADataset.ipynb","provenance":[],"collapsed_sections":[],"mount_file_id":"1dXGO5tIDmXyx3Tt-y8vxO5U1INQ45n0T","authorship_tag":"ABX9TyPgYanfbxkdKfeZGaQBZKWF"},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"}},"cells":[{"cell_type":"markdown","source":["# <font color=deeppink>**Create a Dataset to Use for EDA**</font>"],"metadata":{"id":"LF6b00EkNsnc"}},{"cell_type":"markdown","source":["## <font color=royalblue>Load Necessary Libraries</font>"],"metadata":{"id":"RVr-0lMqRMhc"}},{"cell_type":"code","execution_count":null,"metadata":{"id":"-TBhtRLoNitL"},"outputs":[],"source":["import pandas as pd\n","import numpy as np\n","import datetime\n","import csv"]},{"cell_type":"markdown","source":["## <font color=royalblue>Pertinent Functions</font>"],"metadata":{"id":"jPajvmkxRPlA"}},{"cell_type":"code","source":["# The Data Was Formatted So That 0 Indicates \"Male\", 1 Indicates \"Female\", and -1 Indicates \"Unknown\"\n","def gender_labels(numericalValue):\n","    if numericalValue == 0:\n","        text = \"Male\"\n","    elif numericalValue == 1:\n","        text = \"Female\"\n","    elif numericalValue == -1:\n","        text = \"Unknown\"\n","    else:\n","        text = \"Error\"\n","    \n","    return text\n","\n","# The Data Was Formatted So That 0 Indicates \"No\" and 1 Indicates \"Yes\"\n","def yes_no_labels(numericalValue):\n","    if numericalValue == 0:\n","        text = \"No\"\n","    elif numericalValue == 1:\n","        text = \"Yes\"\n","    else:\n","        text = \"Error\"\n","        \n","    return text\n","\n","def eligibility_labels(numericalValue):\n","    # 1: Low Income and First Generation\n","    if numericalValue == 1:\n","        text = \"Low Income & First Generation\"\n","    # 2: Low Income Only\n","    elif numericalValue == 2:\n","        text = \"Low Income\"\n","    # 3: First Generation Only\n","    elif numericalValue == 3:\n","        text = \"First Generation\"\n","    # 4: At Risk for Academic Failure Only\n","    elif numericalValue == 4:\n","        text = \"At Risk for Academic Failure\"\n","    # 5: Low Income and At High Risk for Academic Failure\n","    elif numericalValue == 5:\n","        text = \"Low Income & At Risk for Academic Failure\"\n","    # 6: First Generation and At High Risk for Academic Failure\n","    elif numericalValue == 6:\n","        text = \"First Generation & At Risk for Academic Failure\"\n","    # 7: Low Income, First Generation, and At High Risk for Academic Failure\n","    elif numericalValue == 7:\n","        text = \"Low Income, First Generation, & At Risk for Academic Failure\"\n","    # -1: Unknown\n","    elif numericalValue == -1:\n","        text = \"Unknown\"\n","    else:\n","        text = \"Error\"\n","    \n","    return text\n","\n","def academic_need_labels(numericalValue):\n","    # 1: Low GPA\n","    if numericalValue == 1:\n","        text = \"Low GPA\"\n","    # 2: Low Achievement Test Scores\n","    elif numericalValue == 2:\n","        text = \"Low Test Scores\"\n","    # 3: Low Educational Aspirations\n","    elif numericalValue == 3:\n","        text = \"Low Educational Aspirations\"\n","    # 4: Low GPA and Low Educational Aspirations\n","    elif numericalValue == 4:\n","        text = \"Low GPA & Low Educational Aspirations\"\n","    # 5: Low GPA and Low Achievement Test Scores\n","    elif numericalValue == 5:\n","        text = \"Low GPA & Low Test Scores\"\n","    # 6: Low Achievement Test Scores and Low Educational Aspirations\n","    elif numericalValue == 6:\n","        text = \"Low Test Scores & Low Educational Aspirations\"\n","    # 7: Lack of Opportunity/Support\n","    elif numericalValue == 7:\n","        text = \"Lack of Opportunity/Support\"\n","    # 8: Lack of Career Goals\n","    elif numericalValue == 8:\n","        text = \"Lack of Career Goals\"\n","    #  9: Limited English Proficiency\n","    elif numericalValue == 9:\n","        text = \"Limited English Proficiency\"\n","    # 10: Lack of Confidence/Self Esteem/Social Skills\n","    elif numericalValue == 10:\n","        text = \"Lack of Confidence/Self Esteem/Social Skills\"\n","    # 11: Predominately Low Income Community\n","    elif numericalValue == 11:\n","        text = \"Predominately Low Income Community\"\n","    # 12: Rural Isolation\n","    elif numericalValue == 12:\n","        text = \"Rural Isolation\"\n","    # 13: Interest in Careers in Math and Science\n","    elif numericalValue == 13:\n","        text = \"Interested in Math/Science\"\n","    # 14: Other\n","    elif numericalValue == 14:\n","        text = \"Other\"\n","    # 15: Diagnosed Learning Disability\n","    elif numericalValue == 15:\n","        text = \"Diagnosed Learning Disability\"\n","    # 16: Pre-Algebra or Algebra Course Not Successfully Completed by 10th Grade\n","    elif numericalValue == 16:\n","        text = \"Pre-Algebra or Algebra Not Completed\"\n","    # -1: Unkown\n","    elif numericalValue == -1:\n","        text = \"Unknown\"\n","    else:\n","        text = \"Error\"\n","    \n","    return text\n","\n","# The Data Was Formatted So That 0 Indicates \"No\", 1 Indicates \"Yes\", 9 Indicates \"Not Applicable\", and -1 Indicates \"Unknown\"\n","def categorical_labels(numericalValue):\n","    if (numericalValue == 0) | (numericalValue == 2):\n","        text = \"No\"\n","    elif numericalValue == 1:\n","        text = \"Yes\"\n","    elif numericalValue == 9:\n","        text = \"Not Applicable\"\n","    elif numericalValue == -1:\n","        text = \"Unkown\"\n","    else:\n","        text = \"Error\"\n","        \n","    return text\n","\n","def grade_entered_labels(numericalValue):\n","    if numericalValue == 9:\n","        text = \"Freshman\"\n","    elif numericalValue == 10:\n","        text = \"Sophomore\"\n","    elif numericalValue == 11:\n","        text = \"Junior\"\n","    elif numericalValue == 12:\n","        text = \"Senior\"\n","    else:\n","        text = \"Error\"\n","        \n","    return text\n","\n","def participation_labels(numericalValue):\n","    # 1: Academic Year And Summer Components\n","    if numericalValue == 1:\n","        text = \"Full Year\"\n","    # 2: Academic Year And Summer Bridge\n","    elif numericalValue == 2:\n","        text = \"Academic Year And Summer Bridge\"\n","    # 3: Academic Year Only\n","    elif numericalValue == 3:\n","        text = \"Academic Year Only\"\n","    # 4: Summer Component Only\n","    elif numericalValue == 4:\n","        text = \"Summer Component Only\"\n","    # 5: Summer Bridge Only\n","    elif numericalValue == 5:\n","        text = \"Summer Bridge Only\"\n","    # 6: Prior-Year Participant\n","    elif numericalValue == 6:\n","        text = \"Not Active This Year\"\n","    # -1: Unknown\n","    elif numericalValue == -1:\n","        text = \"Unknown\"\n","    else:\n","        text = \"Error\"\n","    \n","    return text\n","\n","def course_labels(numericalValue):\n","    # 1: Student Took at Least One Course of This Level\n","    if numericalValue == 1:\n","        text = \"Took At Least One\"\n","    # 0: Student Did Not Take Any Courses of This Level\n","    elif numericalValue == 0:\n","        text = \"Took No Such Courses\"\n","    elif numericalValue == -1:\n","        text = \"Unknown\"\n","    else:\n","        text = \"Error\"\n","        \n","    return text\n","\n","\n","def degree_labels(numericalValue):\n","    # 1: Yes\n","    if numericalValue == 1:\n","        text = \"Yes\"\n","    # 2: No; Pursued Another Kind of Postsecondary Credential\n","    elif numericalValue == 2:\n","        text = \"Pursued Another Kind of Postsecondary Credential\"\n","    # 3: Deferred Enrollment\n","    elif numericalValue == 3:\n","        text = \"Deferred Enrollment\"\n","    # 5: Transferred to Four-Year Without Completing Associate\n","    elif numericalValue == 5:\n","        text = \"Transferred to Four-Year\"\n","    # 6: Currently Enrolled\n","    elif numericalValue == 6:\n","        text = \"Currently Enrolled\"\n","    # 7: Left Postsecondary Program without Completing It\n","    elif numericalValue == 7:\n","        text = \"Dropped Out\"\n","    # 9: Not Applicable\n","    elif numericalValue == 9:\n","        text = \"Not Applicable\"\n","    # -1: Unknown\n","    elif numericalValue == -1:\n","        text = \"Unknown\"\n","    else:\n","        text = \"Error\"\n","        \n","    return text\n","\n","def stem_degree_labels(numericalValue):\n","    # 1: Yes; \"Hard\" Science\n","    if numericalValue == 1:\n","        text = \"Yes; 'Hard' Science\"\n","    # 2: Yes; Psychology or Social Science\n","    elif numericalValue == 2:\n","        text = \"Yes; Psychology or Social Science\"\n","    else:\n","        text = categorical_labels(numericalValue)\n","        \n","    return text"],"metadata":{"id":"vNfJ_0W4RP50"},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":["## <font color=royalblue>Read In Data</font>"],"metadata":{"id":"ZRazpMEKR1ai"}},{"cell_type":"code","source":["eda_df = pd.read_csv(\"/content/drive/MyDrive/Thesis/Codes/Final Datasets/cjb_final_dataset.csv\", index_col=\"ID\")\n","eda_df"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":519},"id":"Nt918nu1R14p","executionInfo":{"status":"ok","timestamp":1648421542016,"user_tz":240,"elapsed":758,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"8e6da70a-e363-4b5d-bcb7-5ee58976f1a7"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["     Gender  Hispanic  AmerInd  Asian  Black  White  Hawaiian  Multinational  \\\n","ID                                                                             \n","0         0         0        0      0      1      0         0              0   \n","1         1         1        0      0      0      0         0              0   \n","2         0         1        0      0      0      0         0              0   \n","3         0         0        0      0      1      0         0              0   \n","4         1         1        0      0      0      0         0              0   \n","..      ...       ...      ...    ...    ...    ...       ...            ...   \n","119       0         1        0      0      0      0         0              0   \n","120       1         0        0      0      0      1         0              0   \n","121       0         1        0      0      0      0         0              0   \n","122       1         1        0      0      0      0         0              0   \n","123       0         0        0      0      1      0         0              0   \n","\n","     LimitedEnglish  Eligibility  ...  Student_RapesCateg  \\\n","ID                                ...                       \n","0                 0            1  ...                 Low   \n","1                 0            2  ...                 Low   \n","2                 0            3  ...                 Low   \n","3                 0            1  ...                 Low   \n","4                 0            3  ...                 Low   \n","..              ...          ...  ...                 ...   \n","119               0            1  ...                 Low   \n","120               0            1  ...                 Low   \n","121               0            1  ...                 Low   \n","122               1            1  ...                 Low   \n","123               0            1  ...                High   \n","\n","     Student_RobberiesCateg  Student_AssaultsCateg  \\\n","ID                                                   \n","0                      High                   High   \n","1                      High                   High   \n","2                      High                   High   \n","3                      High                   High   \n","4                      High                    Low   \n","..                      ...                    ...   \n","119                    High                    Low   \n","120                    High                    Low   \n","121                    High                    Low   \n","122                    High                   High   \n","123                    High                   High   \n","\n","     Student_PropertyCrimesCateg  Student_BurglariesCateg  \\\n","ID                                                          \n","0                            Low                     High   \n","1                           High                     High   \n","2                           High                     High   \n","3                            Low                     High   \n","4                            Low                     High   \n","..                           ...                      ...   \n","119                          Low                      Low   \n","120                          Low                     High   \n","121                          Low                      Low   \n","122                         High                     High   \n","123                          Low                     High   \n","\n","     Student_LarceniesCateg  Student_VehicleTheftsCateg  Distance_to_HS  \\\n","ID                                                                        \n","0                       Low                        High        1.527317   \n","1                       Low                        High        3.227670   \n","2                       Low                        High        1.803466   \n","3                       Low                        High        1.287508   \n","4                       Low                        High        4.410934   \n","..                      ...                         ...             ...   \n","119                     Low                        High       19.355286   \n","120                     Low                        High       22.010710   \n","121                     Low                        High        2.954628   \n","122                     Low                        High       21.245041   \n","123                     Low                        High        1.239157   \n","\n","     Distance_to_PS  PS_Graduated  \n","ID                                 \n","0          2.651641             0  \n","1         27.026511             1  \n","2          5.922479             0  \n","3         20.718053             0  \n","4          2.378576             1  \n","..              ...           ...  \n","119       20.589324             0  \n","120      161.404493             0  \n","121       18.060702             1  \n","122       88.935781             1  \n","123        9.510761             1  \n","\n","[124 rows x 106 columns]"],"text/html":["\n","  <div id=\"df-3cdeb7e4-aa0c-46db-b9bb-b6b6b84c7b10\">\n","    <div 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>Gender</th>\n","      <th>Hispanic</th>\n","      <th>AmerInd</th>\n","      <th>Asian</th>\n","      <th>Black</th>\n","      <th>White</th>\n","      <th>Hawaiian</th>\n","      <th>Multinational</th>\n","      <th>LimitedEnglish</th>\n","      <th>Eligibility</th>\n","      <th>...</th>\n","      <th>Student_RapesCateg</th>\n","      <th>Student_RobberiesCateg</th>\n","      <th>Student_AssaultsCateg</th>\n","      <th>Student_PropertyCrimesCateg</th>\n","      <th>Student_BurglariesCateg</th>\n","      <th>Student_LarceniesCateg</th>\n","      <th>Student_VehicleTheftsCateg</th>\n","      <th>Distance_to_HS</th>\n","      <th>Distance_to_PS</th>\n","      <th>PS_Graduated</th>\n","    </tr>\n","    <tr>\n","      <th>ID</th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>...</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>1.527317</td>\n","      <td>2.651641</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1</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>2</td>\n","      <td>...</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>High</td>\n","      <td>High</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>3.227670</td>\n","      <td>27.026511</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\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>3</td>\n","      <td>...</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>High</td>\n","      <td>High</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>1.803466</td>\n","      <td>5.922479</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>...</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>1.287508</td>\n","      <td>20.718053</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>1</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>3</td>\n","      <td>...</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>4.410934</td>\n","      <td>2.378576</td>\n","      <td>1</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>119</th>\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>1</td>\n","      <td>...</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>Low</td>\n","      <td>Low</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>19.355286</td>\n","      <td>20.589324</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>120</th>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>...</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>22.010710</td>\n","      <td>161.404493</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>121</th>\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>1</td>\n","      <td>...</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>Low</td>\n","      <td>Low</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>2.954628</td>\n","      <td>18.060702</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>122</th>\n","      <td>1</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>1</td>\n","      <td>1</td>\n","      <td>...</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>High</td>\n","      <td>High</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>21.245041</td>\n","      <td>88.935781</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>123</th>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>...</td>\n","      <td>High</td>\n","      <td>High</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>1.239157</td>\n","      <td>9.510761</td>\n","      <td>1</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>124 rows × 106 columns</p>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-3cdeb7e4-aa0c-46db-b9bb-b6b6b84c7b10')\"\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 0 24 24\"\n","       width=\"24px\">\n","    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n","    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n","  </svg>\n","      </button>\n","      \n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      flex-wrap:wrap;\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","    [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-3cdeb7e4-aa0c-46db-b9bb-b6b6b84c7b10 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-3cdeb7e4-aa0c-46db-b9bb-b6b6b84c7b10');\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","  </div>\n","  "]},"metadata":{},"execution_count":3}]},{"cell_type":"markdown","source":["## <font color=royalblue>Replace the Numerical Values with Clear Labels</font>"],"metadata":{"id":"5N6i716nSd_P"}},{"cell_type":"markdown","source":["#### <font color=darkviolet>Gender</font>"],"metadata":{"id":"1xDcKdWiR3Ik"}},{"cell_type":"code","source":["eda_df[\"Gender\"] = eda_df.Gender.transform(lambda x: gender_labels(x))\n","\n","print(eda_df[\"Gender\"].value_counts())"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"iLmwcQ_6SlUF","executionInfo":{"status":"ok","timestamp":1648421542017,"user_tz":240,"elapsed":22,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"5debb963-f455-4c20-c2b1-83f2546e8b4b"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Female    69\n","Male      55\n","Name: Gender, dtype: int64\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Ethnicity and Race</font>"],"metadata":{"id":"1LJmJOfHSoj_"}},{"cell_type":"code","source":["races = [\"Hispanic\", \"AmerInd\", \"Asian\", \"Black\", \"White\", \"Hawaiian\", \"Multinational\"]\n","\n","for race in races:\n","    eda_df[race] = eda_df[race].transform(lambda x: yes_no_labels(x))\n","    \n","    print(race)\n","    print(eda_df[race].value_counts(), \"\\n\")"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"Fsh5JpNhSoKk","executionInfo":{"status":"ok","timestamp":1648421542019,"user_tz":240,"elapsed":19,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"c2f90d07-5364-4353-8a2b-2a32b401ad54"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Hispanic\n","No     71\n","Yes    53\n","Name: Hispanic, dtype: int64 \n","\n","AmerInd\n","No    124\n","Name: AmerInd, dtype: int64 \n","\n","Asian\n","No     102\n","Yes     22\n","Name: Asian, dtype: int64 \n","\n","Black\n","No     78\n","Yes    46\n","Name: Black, dtype: int64 \n","\n","White\n","No     105\n","Yes     19\n","Name: White, dtype: int64 \n","\n","Hawaiian\n","No     123\n","Yes      1\n","Name: Hawaiian, dtype: int64 \n","\n","Multinational\n","No     106\n","Yes     18\n","Name: Multinational, dtype: int64 \n","\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Limited English Proficiency</font>"],"metadata":{"id":"JbpZ8C8jSn66"}},{"cell_type":"code","source":["eda_df[\"LimitedEnglish\"] = eda_df.LimitedEnglish.transform(lambda x: yes_no_labels(x))\n","\n","print(eda_df[\"LimitedEnglish\"].value_counts(), \"\\n\")"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"PRr5NvXFTCT_","executionInfo":{"status":"ok","timestamp":1648421542020,"user_tz":240,"elapsed":16,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"91df58ab-291d-4483-cfb1-05e004318339"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["No     117\n","Yes      7\n","Name: LimitedEnglish, dtype: int64 \n","\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Eligibility</font>"],"metadata":{"id":"bXTnkYgZTBwc"}},{"cell_type":"code","source":["eda_df[\"Eligibility\"] = eda_df.Eligibility.transform(lambda x: eligibility_labels(x))\n","\n","print(eda_df[\"Eligibility\"].value_counts(), \"\\n\")"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"5qOkeKqfTNrP","executionInfo":{"status":"ok","timestamp":1648421542180,"user_tz":240,"elapsed":172,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"c5d99e55-9dd7-4f4e-dec9-f3729b190230"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Low Income & First Generation    96\n","Low Income                       15\n","First Generation                 13\n","Name: Eligibility, dtype: int64 \n","\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Academic Need</font>"],"metadata":{"id":"qW3tsyfuTLKo"}},{"cell_type":"code","source":["eda_df[\"AcademNeed\"] = eda_df.AcademNeed.transform(lambda x: academic_need_labels(x))\n","\n","print(eda_df[\"AcademNeed\"].value_counts())"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"FhgH8w3XTRDv","executionInfo":{"status":"ok","timestamp":1648421542181,"user_tz":240,"elapsed":25,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"1019bf57-1316-4024-a776-3ee21b9fcce2"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Predominately Low Income Community               50\n","Interested in Math/Science                       34\n","Lack of Career Goals                             17\n","Lack of Opportunity/Support                      10\n","Low GPA                                           5\n","Lack of Confidence/Self Esteem/Social Skills      4\n","Low Test Scores                                   2\n","Low GPA & Low Test Scores                         1\n","Low Test Scores & Low Educational Aspirations     1\n","Name: AcademNeed, dtype: int64\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Upward Bound Entry Grade Level</font>"],"metadata":{"id":"m9ZBsiKYe9Ru"}},{"cell_type":"code","source":["eda_df[\"Grade_EnteredUB\"] = eda_df.Grade_EnteredUB.transform(lambda x: grade_entered_labels(x))\n","\n","print(eda_df[\"Grade_EnteredUB\"].value_counts())"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"skGr6F04fAoY","executionInfo":{"status":"ok","timestamp":1648421542182,"user_tz":240,"elapsed":20,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"fe4c338c-386a-4612-b2e2-9ae98c7f6983"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Sophomore    67\n","Freshman     51\n","Senior        3\n","Junior        3\n","Name: Grade_EnteredUB, dtype: int64\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Participation</font>"],"metadata":{"id":"xePgW03HTZu9"}},{"cell_type":"code","source":["eda_df[\"Participation\"] = eda_df.Participation.transform(lambda x: participation_labels(x))\n","\n","print(eda_df[\"Participation\"].value_counts())"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"etIh7JopTjMT","executionInfo":{"status":"ok","timestamp":1648421542182,"user_tz":240,"elapsed":14,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"b8f58eca-a053-4cc2-ed08-c783c06c8897"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Academic Year Only      60\n","Not Active This Year    51\n","Full Year               13\n","Name: Participation, dtype: int64\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>ELA Academic Achievement/Proficiency</font>"],"metadata":{"id":"CQkSYmYdTj--"}},{"cell_type":"code","source":["eda_df[\"AcademAch_ELA\"] = eda_df.AcademAch_ELA.transform(lambda x: categorical_labels(x))\n","\n","print(eda_df[\"AcademAch_ELA\"].value_counts())"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"yFaqdCNhTsdw","executionInfo":{"status":"ok","timestamp":1648421542317,"user_tz":240,"elapsed":143,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"fafeb570-ab59-429f-9316-2baf268d0c29"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Yes               121\n","No                  2\n","Not Applicable      1\n","Name: AcademAch_ELA, dtype: int64\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Math Academic Achievement/Proficiency</font>"],"metadata":{"id":"C7JrUPNATvW0"}},{"cell_type":"code","source":["eda_df[\"AcademAch_Math\"] = eda_df.AcademAch_Math.transform(lambda x: categorical_labels(x))\n","\n","print(eda_df[\"AcademAch_Math\"].value_counts())"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"QCZ7qwQTTzZk","executionInfo":{"status":"ok","timestamp":1648421542317,"user_tz":240,"elapsed":21,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"93be5ad9-76ea-4c30-c6d6-bceabd3b481d"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Yes               118\n","No                  5\n","Not Applicable      1\n","Name: AcademAch_Math, dtype: int64\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Employed</font>"],"metadata":{"id":"CHO0NeX7T18Y"}},{"cell_type":"code","source":["eda_df[\"Employed\"] = eda_df.Employed.transform(lambda x: categorical_labels(x))\n","\n","print(eda_df[\"Employed\"].value_counts())"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"5ZgRPuQoT7kg","executionInfo":{"status":"ok","timestamp":1648421542318,"user_tz":240,"elapsed":16,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"b1cfc0c9-aa6b-4b09-a510-5f3f305fed70"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["No                69\n","Not Applicable    43\n","Yes               12\n","Name: Employed, dtype: int64\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Participated in Cultural Activities</font>\n","\n"],"metadata":{"id":"dKBtszWvT-0I"}},{"cell_type":"code","source":["eda_df[\"CulturalAct\"] = eda_df.CulturalAct.transform(lambda x: categorical_labels(x))\n","\n","print(eda_df[\"CulturalAct\"].value_counts())"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"FfDkwuo1T9y-","executionInfo":{"status":"ok","timestamp":1648421542318,"user_tz":240,"elapsed":12,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"552bdfcc-4c02-4c69-fcc9-bad2ec0e4892"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Yes               90\n","Not Applicable    32\n","No                 2\n","Name: CulturalAct, dtype: int64\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Community Service</font>"],"metadata":{"id":"3O-24NuuT9j1"}},{"cell_type":"code","source":["eda_df[\"CommServ\"] = eda_df.CommServ.transform(lambda x: categorical_labels(x))\n","\n","print(eda_df[\"CommServ\"].value_counts())"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"EBQBRDD7UNRX","executionInfo":{"status":"ok","timestamp":1648421542319,"user_tz":240,"elapsed":9,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"d97e85a8-afe2-4514-8eaa-5b5dc8c8d946"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Yes               47\n","Not Applicable    46\n","No                31\n","Name: CommServ, dtype: int64\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Received Limited English Proficiency Instruction</font>"],"metadata":{"id":"apREtEimUPIa"}},{"cell_type":"code","source":["eda_df[\"LEPServs\"] = eda_df.LEPServs.transform(lambda x: categorical_labels(x))\n","\n","print(eda_df[\"LEPServs\"].value_counts())"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"LWyKqjbVUVb7","executionInfo":{"status":"ok","timestamp":1648421542452,"user_tz":240,"elapsed":140,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"1d39ffef-e3c8-4049-fe47-72ae4f9b0723"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Not Applicable    124\n","Name: LEPServs, dtype: int64\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Took AP Courses</font>"],"metadata":{"id":"Cy5ax-OtUXTB"}},{"cell_type":"code","source":["eda_df[\"AP\"] = eda_df.AP.transform(lambda x: course_labels(x))\n","\n","print(eda_df[\"AP\"].value_counts())"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"KjrcOZ-wUfEJ","executionInfo":{"status":"ok","timestamp":1648421542453,"user_tz":240,"elapsed":15,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"75b5a947-c232-4f79-8d81-f643ae82df91"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Took At Least One       82\n","Took No Such Courses    42\n","Name: AP, dtype: int64\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Took Honors Courses</font>"],"metadata":{"id":"eWdP2l-BUjh5"}},{"cell_type":"code","source":["eda_df[\"Honors\"] = eda_df.Honors.transform(lambda x: course_labels(x))\n","\n","print(eda_df[\"Honors\"].value_counts())"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"g08H-OrkUpTl","executionInfo":{"status":"ok","timestamp":1648421542455,"user_tz":240,"elapsed":14,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"81c71007-85f6-457e-c682-f7fa97269c1b"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Took At Least One       111\n","Took No Such Courses     13\n","Name: Honors, dtype: int64\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Received Certificate or Diploma</font>"],"metadata":{"id":"ujNsr1b8UlRB"}},{"cell_type":"code","source":["eda_df[\"Cert_or_Diploma\"] = eda_df.Cert_or_Diploma.transform(lambda x: degree_labels(x))\n","\n","print(eda_df[\"Cert_or_Diploma\"].value_counts())"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"dDFRDnZLUsRX","executionInfo":{"status":"ok","timestamp":1648421542455,"user_tz":240,"elapsed":10,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"bf9a698d-f3c1-4fe2-8152-b2bf362a4ae8"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Pursued Another Kind of Postsecondary Credential    119\n","Yes                                                   5\n","Name: Cert_or_Diploma, dtype: int64\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Associate Degree</font>"],"metadata":{"id":"MoD-X-62UtFj"}},{"cell_type":"code","source":["eda_df[\"AssocDeg\"] = eda_df.AssocDeg.transform(lambda x: degree_labels(x))\n","\n","print(eda_df[\"AssocDeg\"].value_counts())"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"UnPCbI3ZUy_Q","executionInfo":{"status":"ok","timestamp":1648421542618,"user_tz":240,"elapsed":170,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"1f3ea5d5-54ec-413f-b0dc-8c58b355def4"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Pursued Another Kind of Postsecondary Credential    87\n","Dropped Out                                         18\n","Currently Enrolled                                   8\n","Yes                                                  6\n","Transferred to Four-Year                             5\n","Name: AssocDeg, dtype: int64\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Bachelor's Degree</font>"],"metadata":{"id":"3giRL0aOV934"}},{"cell_type":"code","source":["eda_df[\"BachDeg\"] = eda_df.BachDeg.transform(lambda x: degree_labels(x))\n","\n","print(eda_df[\"BachDeg\"].value_counts())"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"nwBsz1bJWAXF","executionInfo":{"status":"ok","timestamp":1648421542619,"user_tz":240,"elapsed":22,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"276e974a-5da1-4e63-c197-78d8f1fae26a"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Yes                                                 67\n","Dropped Out                                         34\n","Pursued Another Kind of Postsecondary Credential    12\n","Currently Enrolled                                  11\n","Name: BachDeg, dtype: int64\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Graduated College</font>"],"metadata":{"id":"WCo6fvWAWDZQ"}},{"cell_type":"code","source":["eda_df[\"PS_Graduated\"] = eda_df.PS_Graduated.transform(lambda x: categorical_labels(x))\n","\n","print(eda_df[\"PS_Graduated\"].value_counts())"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"hDgeTrWNWKbL","executionInfo":{"status":"ok","timestamp":1648421542620,"user_tz":240,"elapsed":17,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"b68e678e-9296-4865-e9eb-f8ed8c0cdbc2"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Yes    69\n","No     55\n","Name: PS_Graduated, dtype: int64\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Pursued a STEM Degree</font>"],"metadata":{"id":"gEswEBKUWL4L"}},{"cell_type":"code","source":["eda_df[\"STEMDeg\"] = eda_df.STEMDeg.transform(lambda x: stem_degree_labels(x))\n","\n","print(eda_df[\"STEMDeg\"].value_counts())"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"FJOrEOc8WXBF","executionInfo":{"status":"ok","timestamp":1648421542620,"user_tz":240,"elapsed":14,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"619de29d-fc72-4e86-bd4e-dbf2e870a07a"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["No                                   73\n","Yes; 'Hard' Science                  32\n","Yes; Psychology or Social Science    11\n","Not Applicable                        8\n","Name: STEMDeg, dtype: int64\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Attended a Charter High School</font>"],"metadata":{"id":"QiYt7b_kWZHp"}},{"cell_type":"code","source":["eda_df[\"Charter\"] = eda_df.Charter.transform(lambda x: categorical_labels(x))\n","\n","print(eda_df[\"Charter\"].value_counts())"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"eAkB856zWezT","executionInfo":{"status":"ok","timestamp":1648421542946,"user_tz":240,"elapsed":337,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"8b82a2aa-59c8-47e8-98e1-8c3fd3329942"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["No    124\n","Name: Charter, dtype: int64\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Attended a Magnet High School</font>"],"metadata":{"id":"nydK5cNBWgrT"}},{"cell_type":"code","source":["eda_df[\"Magnet\"] = eda_df.Magnet.transform(lambda x: categorical_labels(x))\n","\n","print(eda_df[\"Magnet\"].value_counts())"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"_0kTqolVWoIj","executionInfo":{"status":"ok","timestamp":1648421542947,"user_tz":240,"elapsed":19,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"1631a4bd-b47c-4fed-9a05-f3e1dfe88215"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Not Applicable    124\n","Name: Magnet, dtype: int64\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Attended a Title I High School</font>"],"metadata":{"id":"pPEzuNDYWmMM"}},{"cell_type":"code","source":["eda_df[\"Title1_School\"] = eda_df.Title1_School.transform(lambda x: categorical_labels(x))\n","\n","print(eda_df[\"Title1_School\"].value_counts())"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"1MJW2JTYWocQ","executionInfo":{"status":"ok","timestamp":1648421542948,"user_tz":240,"elapsed":19,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"ab7ec684-a47d-4ee0-9dde-e81e1209b46e"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Yes    123\n","No       1\n","Name: Title1_School, dtype: int64\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>High School Had a Title I School-Wide Program</font>"],"metadata":{"id":"s-E_GAjpW2Z_"}},{"cell_type":"code","source":["eda_df[\"Title1_SchoolWide\"] = eda_df.Title1_SchoolWide.transform(lambda x: categorical_labels(x))\n","\n","print(eda_df[\"Title1_SchoolWide\"].value_counts())"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"PuKKRgALW7uT","executionInfo":{"status":"ok","timestamp":1648421542950,"user_tz":240,"elapsed":15,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"23739f6d-ea02-4b2f-a5c8-a02d0ebfd745"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Yes               72\n","No                51\n","Not Applicable     1\n","Name: Title1_SchoolWide, dtype: int64\n"]}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>Student's City</font>"],"metadata":{"id":"JS5pyf4Of7I6"}},{"cell_type":"code","source":["# Extract the City's Name From the Full Address\n","eda_df[\"Student_City\"] = eda_df[\"Student_FullAddress\"].transform(lambda x: x.split(\" \")[-2])\n","\n","# Remove the Comma\n","eda_df[\"Student_City\"] = eda_df[\"Student_City\"].transform(lambda x: x[:-1])\n","\n","eda_df[\"Student_City\"]"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"LUHw7Cr2f7dN","executionInfo":{"status":"ok","timestamp":1648421543090,"user_tz":240,"elapsed":149,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"5f4099fd-8be0-4024-b715-3cd05b213f31"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["ID\n","0      Paterson\n","1      Paterson\n","2      Paterson\n","3      Paterson\n","4      Paterson\n","         ...   \n","119    Paterson\n","120    Paterson\n","121    Paterson\n","122    Paterson\n","123      Newark\n","Name: Student_City, Length: 124, dtype: object"]},"metadata":{},"execution_count":28}]},{"cell_type":"markdown","source":["#### <font color=darkviolet>High School's City</font>"],"metadata":{"id":"vqBjKR_ThTbz"}},{"cell_type":"code","source":["# Extract the City's Name From the Full Address\n","eda_df[\"HS_City\"] = eda_df[\"HS_FullAddress\"].transform(lambda x: x.split(\" \")[-2])\n","\n","# Remove the Comma and Make the Entire String Lowercase\n","eda_df[\"HS_City\"] = eda_df[\"HS_City\"].transform(lambda x: x[:-1].lower())\n","\n","# Capitalize Only the First Letter \n","eda_df[\"HS_City\"] = eda_df[\"HS_City\"].transform(lambda x: str(x[0]).upper() + str(x[1:]))\n","\n","eda_df[\"HS_City\"]"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"o0F7bd3jhTxo","executionInfo":{"status":"ok","timestamp":1648421543092,"user_tz":240,"elapsed":19,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"a2b168f4-0f8a-469c-cf86-8e5348e6bfa2"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["ID\n","0      Paterson\n","1      Paterson\n","2      Paterson\n","3      Paterson\n","4      Paterson\n","         ...   \n","119      Newark\n","120      Newark\n","121    Paterson\n","122      Newark\n","123      Newark\n","Name: HS_City, Length: 124, dtype: object"]},"metadata":{},"execution_count":29}]},{"cell_type":"markdown","source":["## <font color=royalblue>Write the Final Dataset to a .csv File</font>\n","\n"],"metadata":{"id":"NWG6msbaR6Cx"}},{"cell_type":"code","source":["eda_df"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":797},"id":"uEA6O55qu7uo","executionInfo":{"status":"ok","timestamp":1648421543094,"user_tz":240,"elapsed":18,"user":{"displayName":"Colette Barca","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gi19Z2cpiZ6ouuHGjJ2spfEPwZ4GfacMwSgydGc=s64","userId":"07002218744542087387"}},"outputId":"ec77c345-b771-4c3f-aa9b-cd5174d82fcf"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["     Gender Hispanic AmerInd Asian Black White Hawaiian Multinational  \\\n","ID                                                                      \n","0      Male       No      No    No   Yes    No       No            No   \n","1    Female      Yes      No    No    No    No       No            No   \n","2      Male      Yes      No    No    No    No       No            No   \n","3      Male       No      No    No   Yes    No       No            No   \n","4    Female      Yes      No    No    No    No       No            No   \n","..      ...      ...     ...   ...   ...   ...      ...           ...   \n","119    Male      Yes      No    No    No    No       No            No   \n","120  Female       No      No    No    No   Yes       No            No   \n","121    Male      Yes      No    No    No    No       No            No   \n","122  Female      Yes      No    No    No    No       No            No   \n","123    Male       No      No    No   Yes    No       No            No   \n","\n","    LimitedEnglish                    Eligibility  ... Student_AssaultsCateg  \\\n","ID                                                 ...                         \n","0               No  Low Income & First Generation  ...                  High   \n","1               No                     Low Income  ...                  High   \n","2               No               First Generation  ...                  High   \n","3               No  Low Income & First Generation  ...                  High   \n","4               No               First Generation  ...                   Low   \n","..             ...                            ...  ...                   ...   \n","119             No  Low Income & First Generation  ...                   Low   \n","120             No  Low Income & First Generation  ...                   Low   \n","121             No  Low Income & First Generation  ...                   Low   \n","122            Yes  Low Income & First Generation  ...                  High   \n","123             No  Low Income & First Generation  ...                  High   \n","\n","    Student_PropertyCrimesCateg Student_BurglariesCateg  \\\n","ID                                                        \n","0                           Low                    High   \n","1                          High                    High   \n","2                          High                    High   \n","3                           Low                    High   \n","4                           Low                    High   \n","..                          ...                     ...   \n","119                         Low                     Low   \n","120                         Low                    High   \n","121                         Low                     Low   \n","122                        High                    High   \n","123                         Low                    High   \n","\n","     Student_LarceniesCateg  Student_VehicleTheftsCateg Distance_to_HS  \\\n","ID                                                                       \n","0                       Low                        High       1.527317   \n","1                       Low                        High       3.227670   \n","2                       Low                        High       1.803466   \n","3                       Low                        High       1.287508   \n","4                       Low                        High       4.410934   \n","..                      ...                         ...            ...   \n","119                     Low                        High      19.355286   \n","120                     Low                        High      22.010710   \n","121                     Low                        High       2.954628   \n","122                     Low                        High      21.245041   \n","123                     Low                        High       1.239157   \n","\n","    Distance_to_PS PS_Graduated Student_City   HS_City  \n","ID                                                      \n","0         2.651641           No     Paterson  Paterson  \n","1        27.026511          Yes     Paterson  Paterson  \n","2         5.922479           No     Paterson  Paterson  \n","3        20.718053           No     Paterson  Paterson  \n","4         2.378576          Yes     Paterson  Paterson  \n","..             ...          ...          ...       ...  \n","119      20.589324           No     Paterson    Newark  \n","120     161.404493           No     Paterson    Newark  \n","121      18.060702          Yes     Paterson  Paterson  \n","122      88.935781          Yes     Paterson    Newark  \n","123       9.510761          Yes       Newark    Newark  \n","\n","[124 rows x 108 columns]"],"text/html":["\n","  <div id=\"df-76eef57a-ff85-4607-8410-69884c864be6\">\n","    <div 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>Gender</th>\n","      <th>Hispanic</th>\n","      <th>AmerInd</th>\n","      <th>Asian</th>\n","      <th>Black</th>\n","      <th>White</th>\n","      <th>Hawaiian</th>\n","      <th>Multinational</th>\n","      <th>LimitedEnglish</th>\n","      <th>Eligibility</th>\n","      <th>...</th>\n","      <th>Student_AssaultsCateg</th>\n","      <th>Student_PropertyCrimesCateg</th>\n","      <th>Student_BurglariesCateg</th>\n","      <th>Student_LarceniesCateg</th>\n","      <th>Student_VehicleTheftsCateg</th>\n","      <th>Distance_to_HS</th>\n","      <th>Distance_to_PS</th>\n","      <th>PS_Graduated</th>\n","      <th>Student_City</th>\n","      <th>HS_City</th>\n","    </tr>\n","    <tr>\n","      <th>ID</th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>Male</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>Yes</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>Low Income &amp; First Generation</td>\n","      <td>...</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>1.527317</td>\n","      <td>2.651641</td>\n","      <td>No</td>\n","      <td>Paterson</td>\n","      <td>Paterson</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Female</td>\n","      <td>Yes</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>Low Income</td>\n","      <td>...</td>\n","      <td>High</td>\n","      <td>High</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>3.227670</td>\n","      <td>27.026511</td>\n","      <td>Yes</td>\n","      <td>Paterson</td>\n","      <td>Paterson</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>Male</td>\n","      <td>Yes</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>First Generation</td>\n","      <td>...</td>\n","      <td>High</td>\n","      <td>High</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>1.803466</td>\n","      <td>5.922479</td>\n","      <td>No</td>\n","      <td>Paterson</td>\n","      <td>Paterson</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Male</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>Yes</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>Low Income &amp; First Generation</td>\n","      <td>...</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>1.287508</td>\n","      <td>20.718053</td>\n","      <td>No</td>\n","      <td>Paterson</td>\n","      <td>Paterson</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>Female</td>\n","      <td>Yes</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>First Generation</td>\n","      <td>...</td>\n","      <td>Low</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>4.410934</td>\n","      <td>2.378576</td>\n","      <td>Yes</td>\n","      <td>Paterson</td>\n","      <td>Paterson</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>119</th>\n","      <td>Male</td>\n","      <td>Yes</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>Low Income &amp; First Generation</td>\n","      <td>...</td>\n","      <td>Low</td>\n","      <td>Low</td>\n","      <td>Low</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>19.355286</td>\n","      <td>20.589324</td>\n","      <td>No</td>\n","      <td>Paterson</td>\n","      <td>Newark</td>\n","    </tr>\n","    <tr>\n","      <th>120</th>\n","      <td>Female</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>Yes</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>Low Income &amp; First Generation</td>\n","      <td>...</td>\n","      <td>Low</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>22.010710</td>\n","      <td>161.404493</td>\n","      <td>No</td>\n","      <td>Paterson</td>\n","      <td>Newark</td>\n","    </tr>\n","    <tr>\n","      <th>121</th>\n","      <td>Male</td>\n","      <td>Yes</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>Low Income &amp; First Generation</td>\n","      <td>...</td>\n","      <td>Low</td>\n","      <td>Low</td>\n","      <td>Low</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>2.954628</td>\n","      <td>18.060702</td>\n","      <td>Yes</td>\n","      <td>Paterson</td>\n","      <td>Paterson</td>\n","    </tr>\n","    <tr>\n","      <th>122</th>\n","      <td>Female</td>\n","      <td>Yes</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>Yes</td>\n","      <td>Low Income &amp; First Generation</td>\n","      <td>...</td>\n","      <td>High</td>\n","      <td>High</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>21.245041</td>\n","      <td>88.935781</td>\n","      <td>Yes</td>\n","      <td>Paterson</td>\n","      <td>Newark</td>\n","    </tr>\n","    <tr>\n","      <th>123</th>\n","      <td>Male</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>Yes</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>No</td>\n","      <td>Low Income &amp; First Generation</td>\n","      <td>...</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>Low</td>\n","      <td>High</td>\n","      <td>1.239157</td>\n","      <td>9.510761</td>\n","      <td>Yes</td>\n","      <td>Newark</td>\n","      <td>Newark</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>124 rows × 108 columns</p>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-76eef57a-ff85-4607-8410-69884c864be6')\"\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 0 24 24\"\n","       width=\"24px\">\n","    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n","    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n","  </svg>\n","      </button>\n","      \n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      flex-wrap:wrap;\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","    [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-76eef57a-ff85-4607-8410-69884c864be6 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-76eef57a-ff85-4607-8410-69884c864be6');\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","  </div>\n","  "]},"metadata":{},"execution_count":30}]},{"cell_type":"code","source":["# Write the DataFrame to a .csv File\n","eda_df.to_csv(\"/content/drive/MyDrive/Thesis/Codes/Final Datasets/cjb_final_dataset_eda.csv\", index_label=\"ID\")"],"metadata":{"id":"hR6Codj2SB0M"},"execution_count":null,"outputs":[]}]}