Panda challenge 2
annahiraeta
PyCitySchools_starter.ipynb{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "### Note\n", "* Instructions have been included for each segment. You do not have to follow them exactly, but they are included to help you think through the steps." ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "# Dependencies and Setup\n", "import pandas as pd\n", "\n", "# File to Load (Remember to Change These)\n", "school_data_to_load = \"Resources/schools_complete.csv\"\n", "student_data_to_load = \"Resources/students_complete.csv\"\n", "\n", "# Read School and Student Data File and store into Pandas DataFrames\n", "school_data = pd.read_csv(school_data_to_load)\n", "student_data = pd.read_csv(student_data_to_load)\n", "\n", "# Combine the data into a single dataset. \n", "school_data_complete = pd.merge(student_data, school_data, how=\"left\", on=[\"school_name\", \"school_name\"])" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## District Summary\n", "\n", "* Calculate the total number of schools\n", "\n", "* Calculate the total number of students\n", "\n", "* Calculate the total budget\n", "\n", "* Calculate the average math score \n", "\n", "* Calculate the average reading score\n", "\n", "* Calculate the percentage of students with a passing math score (70 or greater)\n", "\n", "* Calculate the percentage of students with a passing reading score (70 or greater)\n", "\n", "* Calculate the percentage of students who passed math **and** reading (% Overall Passing)\n", "\n", "* Create a dataframe to hold the above results\n", "\n", "* Optional: give the displayed data cleaner formatting" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "data": { "text/html": [ "<div>\n", "<style scoped>\n", " .dataframe tbody tr th:only-of-type {\n", " vertical-align: middle;\n", " }\n", "\n", " .dataframe tbody tr th {\n", " vertical-align: top;\n", " }\n", "\n", " .dataframe thead th {\n", " text-align: right;\n", " }\n", "</style>\n", "<table border=\"1\" class=\"dataframe\">\n", " <thead>\n", " <tr style=\"text-align: right;\">\n", " <th></th>\n", " <th>Total Schools</th>\n", " <th>Total Students</th>\n", " <th>Total Budget</th>\n", " <th>Average Math Score</th>\n", " <th>Average Reading Score</th>\n", " <th>% Passing Math</th>\n", " <th>% Passing Reading</th>\n", " <th>% Overall Passing</th>\n", " </tr>\n", " </thead>\n", " <tbody>\n", " <tr>\n", " <th>0</th>\n", " <td>15</td>\n", " <td>39,170</td>\n", " <td>$24,649,428.00</td>\n", " <td>78.985371</td>\n", " <td>81.87784</td>\n", " <td>74.980853</td>\n", " <td>85.805463</td>\n", " <td>65.172326</td>\n", " </tr>\n", " </tbody>\n", "</table>\n", "</div>" ], "text/plain": [ " Total Schools Total Students Total Budget Average Math Score \\\n", "0 15 39,170 $24,649,428.00 78.985371 \n", "\n", " Average Reading Score % Passing Math % Passing Reading % Overall Passing \n", "0 81.87784 74.980853 85.805463 65.172326 " ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## School Summary" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "* Create an overview table that summarizes key metrics about each school, including:\n", " * School Name\n", " * School Type\n", " * Total Students\n", " * Total School Budget\n", " * Per Student Budget\n", " * Average Math Score\n", " * Average Reading Score\n", " * % Passing Math\n", " * % Passing Reading\n", " * % Overall Passing (The percentage of students that passed math **and** reading.)\n", " \n", "* Create a dataframe to hold the above results" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [ { "data": { "text/html": [ "<div>\n", "<style scoped>\n", " .dataframe tbody tr th:only-of-type {\n", " vertical-align: middle;\n", " }\n", "\n", " .dataframe tbody tr th {\n", " vertical-align: top;\n", " }\n", "\n", " .dataframe thead th {\n", " text-align: right;\n", " }\n", "</style>\n", "<table border=\"1\" class=\"dataframe\">\n", " <thead>\n", " <tr style=\"text-align: right;\">\n", " <th></th>\n", " <th>School Type</th>\n", " <th>Total Students</th>\n", " <th>Total School Budget</th>\n", " <th>Per Student Budget</th>\n", " <th>Average Math Score</th>\n", " <th>Average Reading Score</th>\n", " <th>% Passing Math</th>\n", " <th>% Passing Reading</th>\n", " <th>% Overall Passing</th>\n", " </tr>\n", " </thead>\n", " <tbody>\n", " <tr>\n", " <th>Bailey High School</th>\n", " <td>District</td>\n", " <td>4976</td>\n", " <td>$3,124,928.00</td>\n", " <td>$628.00</td>\n", " <td>77.048432</td>\n", " <td>81.033963</td>\n", " <td>66.680064</td>\n", " <td>81.933280</td>\n", " <td>54.642283</td>\n", " </tr>\n", " <tr>\n", " <th>Cabrera High School</th>\n", " <td>Charter</td>\n", " <td>1858</td>\n", " <td>$1,081,356.00</td>\n", " <td>$582.00</td>\n", " <td>83.061895</td>\n", " <td>83.975780</td>\n", " <td>94.133477</td>\n", " <td>97.039828</td>\n", " <td>91.334769</td>\n", " </tr>\n", " <tr>\n", " <th>Figueroa High School</th>\n", " <td>District</td>\n", " <td>2949</td>\n", " <td>$1,884,411.00</td>\n", " <td>$639.00</td>\n", " <td>76.711767</td>\n", " <td>81.158020</td>\n", " <td>65.988471</td>\n", " <td>80.739234</td>\n", " <td>53.204476</td>\n", " </tr>\n", " <tr>\n", " <th>Ford High School</th>\n", " <td>District</td>\n", " <td>2739</td>\n", " <td>$1,763,916.00</td>\n", " <td>$644.00</td>\n", " <td>77.102592</td>\n", " <td>80.746258</td>\n", " <td>68.309602</td>\n", " <td>79.299014</td>\n", " <td>54.289887</td>\n", " </tr>\n", " <tr>\n", " <th>Griffin High School</th>\n", " <td>Charter</td>\n", " <td>1468</td>\n", " <td>$917,500.00</td>\n", " <td>$625.00</td>\n", " <td>83.351499</td>\n", " <td>83.816757</td>\n", " <td>93.392371</td>\n", " <td>97.138965</td>\n", " <td>90.599455</td>\n", " </tr>\n", " <tr>\n", " <th>Hernandez High School</th>\n", " <td>District</td>\n", " <td>4635</td>\n", " <td>$3,022,020.00</td>\n", " <td>$652.00</td>\n", " <td>77.289752</td>\n", " <td>80.934412</td>\n", " <td>66.752967</td>\n", " <td>80.862999</td>\n", " <td>53.527508</td>\n", " </tr>\n", " <tr>\n", " <th>Holden High School</th>\n", " <td>Charter</td>\n", " <td>427</td>\n", " <td>$248,087.00</td>\n", " <td>$581.00</td>\n", " <td>83.803279</td>\n", " <td>83.814988</td>\n", " <td>92.505855</td>\n", " <td>96.252927</td>\n", " <td>89.227166</td>\n", " </tr>\n", " <tr>\n", " <th>Huang High School</th>\n", " <td>District</td>\n", " <td>2917</td>\n", " <td>$1,910,635.00</td>\n", " <td>$655.00</td>\n", " <td>76.629414</td>\n", " <td>81.182722</td>\n", " <td>65.683922</td>\n", " <td>81.316421</td>\n", " <td>53.513884</td>\n", " </tr>\n", " <tr>\n", " <th>Johnson High School</th>\n", " <td>District</td>\n", " <td>4761</td>\n", " <td>$3,094,650.00</td>\n", " <td>$650.00</td>\n", " <td>77.072464</td>\n", " <td>80.966394</td>\n", " <td>66.057551</td>\n", " <td>81.222432</td>\n", " <td>53.539172</td>\n", " </tr>\n", " <tr>\n", " <th>Pena High School</th>\n", " <td>Charter</td>\n", " <td>962</td>\n", " <td>$585,858.00</td>\n", " <td>$609.00</td>\n", " <td>83.839917</td>\n", " <td>84.044699</td>\n", " <td>94.594595</td>\n", " <td>95.945946</td>\n", " <td>90.540541</td>\n", " </tr>\n", " <tr>\n", " <th>Rodriguez High School</th>\n", " <td>District</td>\n", " <td>3999</td>\n", " <td>$2,547,363.00</td>\n", " <td>$637.00</td>\n", " <td>76.842711</td>\n", " <td>80.744686</td>\n", " <td>66.366592</td>\n", " <td>80.220055</td>\n", " <td>52.988247</td>\n", " </tr>\n", " <tr>\n", " <th>Shelton High School</th>\n", " <td>Charter</td>\n", " <td>1761</td>\n", " <td>$1,056,600.00</td>\n", " <td>$600.00</td>\n", " <td>83.359455</td>\n", " <td>83.725724</td>\n", " <td>93.867121</td>\n", " <td>95.854628</td>\n", " <td>89.892107</td>\n", " </tr>\n", " <tr>\n", " <th>Thomas High School</th>\n", " <td>Charter</td>\n", " <td>1635</td>\n", " <td>$1,043,130.00</td>\n", " <td>$638.00</td>\n", " <td>83.418349</td>\n", " <td>83.848930</td>\n", " <td>93.272171</td>\n", " <td>97.308869</td>\n", " <td>90.948012</td>\n", " </tr>\n", " <tr>\n", " <th>Wilson High School</th>\n", " <td>Charter</td>\n", " <td>2283</td>\n", " <td>$1,319,574.00</td>\n", " <td>$578.00</td>\n", " <td>83.274201</td>\n", " <td>83.989488</td>\n", " <td>93.867718</td>\n", " <td>96.539641</td>\n", " <td>90.582567</td>\n", " </tr>\n", " <tr>\n", " <th>Wright High School</th>\n", " <td>Charter</td>\n", " <td>1800</td>\n", " <td>$1,049,400.00</td>\n", " <td>$583.00</td>\n", " <td>83.682222</td>\n", " <td>83.955000</td>\n", " <td>93.333333</td>\n", " <td>96.611111</td>\n", " <td>90.333333</td>\n", " </tr>\n", " </tbody>\n", "</table>\n", "</div>" ], "text/plain": [ " School Type Total Students Total School Budget \\\n", "Bailey High School District 4976 $3,124,928.00 \n", "Cabrera High School Charter 1858 $1,081,356.00 \n", "Figueroa High School District 2949 $1,884,411.00 \n", "Ford High School District 2739 $1,763,916.00 \n", "Griffin High School Charter 1468 $917,500.00 \n", "Hernandez High School District 4635 $3,022,020.00 \n", "Holden High School Charter 427 $248,087.00 \n", "Huang High School District 2917 $1,910,635.00 \n", "Johnson High School District 4761 $3,094,650.00 \n", "Pena High School Charter 962 $585,858.00 \n", "Rodriguez High School District 3999 $2,547,363.00 \n", "Shelton High School Charter 1761 $1,056,600.00 \n", "Thomas High School Charter 1635 $1,043,130.00 \n", "Wilson High School Charter 2283 $1,319,574.00 \n", "Wright High School Charter 1800 $1,049,400.00 \n", "\n", " Per Student Budget Average Math Score \\\n", "Bailey High School $628.00 77.048432 \n", "Cabrera High School $582.00 83.061895 \n", "Figueroa High School $639.00 76.711767 \n", "Ford High School $644.00 77.102592 \n", "Griffin High School $625.00 83.351499 \n", "Hernandez High School $652.00 77.289752 \n", "Holden High School $581.00 83.803279 \n", "Huang High School $655.00 76.629414 \n", "Johnson High School $650.00 77.072464 \n", "Pena High School $609.00 83.839917 \n", "Rodriguez High School $637.00 76.842711 \n", "Shelton High School $600.00 83.359455 \n", "Thomas High School $638.00 83.418349 \n", "Wilson High School $578.00 83.274201 \n", "Wright High School $583.00 83.682222 \n", "\n", " Average Reading Score % Passing Math \\\n", "Bailey High School 81.033963 66.680064 \n", "Cabrera High School 83.975780 94.133477 \n", "Figueroa High School 81.158020 65.988471 \n", "Ford High School 80.746258 68.309602 \n", "Griffin High School 83.816757 93.392371 \n", "Hernandez High School 80.934412 66.752967 \n", "Holden High School 83.814988 92.505855 \n", "Huang High School 81.182722 65.683922 \n", "Johnson High School 80.966394 66.057551 \n", "Pena High School 84.044699 94.594595 \n", "Rodriguez High School 80.744686 66.366592 \n", "Shelton High School 83.725724 93.867121 \n", "Thomas High School 83.848930 93.272171 \n", "Wilson High School 83.989488 93.867718 \n", "Wright High School 83.955000 93.333333 \n", "\n", " % Passing Reading % Overall Passing \n", "Bailey High School 81.933280 54.642283 \n", "Cabrera High School 97.039828 91.334769 \n", "Figueroa High School 80.739234 53.204476 \n", "Ford High School 79.299014 54.289887 \n", "Griffin High School 97.138965 90.599455 \n", "Hernandez High School 80.862999 53.527508 \n", "Holden High School 96.252927 89.227166 \n", "Huang High School 81.316421 53.513884 \n", "Johnson High School 81.222432 53.539172 \n", "Pena High School 95.945946 90.540541 \n", "Rodriguez High School 80.220055 52.988247 \n", "Shelton High School 95.854628 89.892107 \n", "Thomas High School 97.308869 90.948012 \n", "Wilson High School 96.539641 90.582567 \n", "Wright High School 96.611111 90.333333 " ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Top Performing Schools (By % Overall Passing)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "* Sort and display the top five performing schools by % overall passing." ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "scrolled": true }, "outputs": [ { "data": { "text/html": [ "<div>\n", "<style scoped>\n", " .dataframe tbody tr th:only-of-type {\n", " vertical-align: middle;\n", " }\n", "\n", " .dataframe tbody tr th {\n", " vertical-align: top;\n", " }\n", "\n", " .dataframe thead th {\n", " text-align: right;\n", " }\n", "</style>\n", "<table border=\"1\" class=\"dataframe\">\n", " <thead>\n", " <tr style=\"text-align: right;\">\n", " <th></th>\n", " <th>School Type</th>\n", " <th>Total Students</th>\n", " <th>Total School Budget</th>\n", " <th>Per Student Budget</th>\n", " <th>Average Math Score</th>\n", " <th>Average Reading Score</th>\n", " <th>% Passing Math</th>\n", " <th>% Passing Reading</th>\n", " <th>% Overall Passing</th>\n", " </tr>\n", " </thead>\n", " <tbody>\n", " <tr>\n", " <th>Cabrera High School</th>\n", " <td>Charter</td>\n", " <td>1858</td>\n", " <td>$1,081,356.00</td>\n", " <td>$582.00</td>\n", " <td>83.061895</td>\n", " <td>83.975780</td>\n", " <td>94.133477</td>\n", " <td>97.039828</td>\n", " <td>91.334769</td>\n", " </tr>\n", " <tr>\n", " <th>Thomas High School</th>\n", " <td>Charter</td>\n", " <td>1635</td>\n", " <td>$1,043,130.00</td>\n", " <td>$638.00</td>\n", " <td>83.418349</td>\n", " <td>83.848930</td>\n", " <td>93.272171</td>\n", " <td>97.308869</td>\n", " <td>90.948012</td>\n", " </tr>\n", " <tr>\n", " <th>Griffin High School</th>\n", " <td>Charter</td>\n", " <td>1468</td>\n", " <td>$917,500.00</td>\n", " <td>$625.00</td>\n", " <td>83.351499</td>\n", " <td>83.816757</td>\n", " <td>93.392371</td>\n", " <td>97.138965</td>\n", " <td>90.599455</td>\n", " </tr>\n", " <tr>\n", " <th>Wilson High School</th>\n", " <td>Charter</td>\n", " <td>2283</td>\n", " <td>$1,319,574.00</td>\n", " <td>$578.00</td>\n", " <td>83.274201</td>\n", " <td>83.989488</td>\n", " <td>93.867718</td>\n", " <td>96.539641</td>\n", " <td>90.582567</td>\n", " </tr>\n", " <tr>\n", " <th>Pena High School</th>\n", " <td>Charter</td>\n", " <td>962</td>\n", " <td>$585,858.00</td>\n", " <td>$609.00</td>\n", " <td>83.839917</td>\n", " <td>84.044699</td>\n", " <td>94.594595</td>\n", " <td>95.945946</td>\n", " <td>90.540541</td>\n", " </tr>\n", " </tbody>\n", "</table>\n", "</div>" ], "text/plain": [ " School Type Total Students Total School Budget \\\n", "Cabrera High School Charter 1858 $1,081,356.00 \n", "Thomas High School Charter 1635 $1,043,130.00 \n", "Griffin High School Charter 1468 $917,500.00 \n", "Wilson High School Charter 2283 $1,319,574.00 \n", "Pena High School Charter 962 $585,858.00 \n", "\n", " Per Student Budget Average Math Score \\\n", "Cabrera High School $582.00 83.061895 \n", "Thomas High School $638.00 83.418349 \n", "Griffin High School $625.00 83.351499 \n", "Wilson High School $578.00 83.274201 \n", "Pena High School $609.00 83.839917 \n", "\n", " Average Reading Score % Passing Math % Passing Reading \\\n", "Cabrera High School 83.975780 94.133477 97.039828 \n", "Thomas High School 83.848930 93.272171 97.308869 \n", "Griffin High School 83.816757 93.392371 97.138965 \n", "Wilson High School 83.989488 93.867718 96.539641 \n", "Pena High School 84.044699 94.594595 95.945946 \n", "\n", " % Overall Passing \n", "Cabrera High School 91.334769 \n", "Thomas High School 90.948012 \n", "Griffin High School 90.599455 \n", "Wilson High School 90.582567 \n", "Pena High School 90.540541 " ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" } ], "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Bottom Performing Schools (By % Overall Passing)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "* Sort and display the five worst-performing schools by % overall passing." ] }, { "cell_type": "code", "execution_count": 11, "metadata": {}, "outputs": [ { "data": { "text/html": [ "<div>\n", "<style scoped>\n", " .dataframe tbody tr th:only-of-type {\n", " vertical-align: middle;\n", " }\n", "\n", " .dataframe tbody tr th {\n", " vertical-align: top;\n", " }\n", "\n", " .dataframe thead th {\n", " text-align: right;\n", " }\n", "</style>\n", "<table border=\"1\" class=\"dataframe\">\n", " <thead>\n", " <tr style=\"text-align: right;\">\n", " <th></th>\n", " <th>School Type</th>\n", " <th>Total Students</th>\n", " <th>Total School Budget</th>\n", " <th>Per Student Budget</th>\n", " <th>Average Math Score</th>\n", " <th>Average Reading Score</th>\n", " <th>% Passing Math</th>\n", " <th>% Passing Reading</th>\n", " <th>% Overall Passing</th>\n", " </tr>\n", " </thead>\n", " <tbody>\n", " <tr>\n", " <th>Rodriguez High School</th>\n", " <td>District</td>\n", " <td>3999</td>\n", " <td>$2,547,363.00</td>\n", " <td>$637.00</td>\n", " <td>76.842711</td>\n", " <td>80.744686</td>\n", " <td>66.366592</td>\n", " <td>80.220055</td>\n", " <td>52.988247</td>\n", " </tr>\n", " <tr>\n", " <th>Figueroa High School</th>\n", " <td>District</td>\n", " <td>2949</td>\n", " <td>$1,884,411.00</td>\n", " <td>$639.00</td>\n", " <td>76.711767</td>\n", " <td>81.158020</td>\n", " <td>65.988471</td>\n", " <td>80.739234</td>\n", " <td>53.204476</td>\n", " </tr>\n", " <tr>\n", " <th>Huang High School</th>\n", " <td>District</td>\n", " <td>2917</td>\n", " <td>$1,910,635.00</td>\n", " <td>$655.00</td>\n", " <td>76.629414</td>\n", " <td>81.182722</td>\n", " <td>65.683922</td>\n", " <td>81.316421</td>\n", " <td>53.513884</td>\n", " </tr>\n", " <tr>\n", " <th>Hernandez High School</th>\n", " <td>District</td>\n", " <td>4635</td>\n", " <td>$3,022,020.00</td>\n", " <td>$652.00</td>\n", " <td>77.289752</td>\n", " <td>80.934412</td>\n", " <td>66.752967</td>\n", " <td>80.862999</td>\n", " <td>53.527508</td>\n", " </tr>\n", " <tr>\n", " <th>Johnson High School</th>\n", " <td>District</td>\n", " <td>4761</td>\n", " <td>$3,094,650.00</td>\n", " <td>$650.00</td>\n", " <td>77.072464</td>\n", " <td>80.966394</td>\n", " <td>66.057551</td>\n", " <td>81.222432</td>\n", " <td>53.539172</td>\n", " </tr>\n", " </tbody>\n", "</table>\n", "</div>" ], "text/plain": [ " School Type Total Students Total School Budget \\\n", "Rodriguez High School District 3999 $2,547,363.00 \n", "Figueroa High School District 2949 $1,884,411.00 \n", "Huang High School District 2917 $1,910,635.00 \n", "Hernandez High School District 4635 $3,022,020.00 \n", "Johnson High School District 4761 $3,094,650.00 \n", "\n", " Per Student Budget Average Math Score \\\n", "Rodriguez High School $637.00 76.842711 \n", "Figueroa High School $639.00 76.711767 \n", "Huang High School $655.00 76.629414 \n", "Hernandez High School $652.00 77.289752 \n", "Johnson High School $650.00 77.072464 \n", "\n", " Average Reading Score % Passing Math \\\n", "Rodriguez High School 80.744686 66.366592 \n", "Figueroa High School 81.158020 65.988471 \n", "Huang High School 81.182722 65.683922 \n", "Hernandez High School 80.934412 66.752967 \n", "Johnson High School 80.966394 66.057551 \n", "\n", " % Passing Reading % Overall Passing \n", "Rodriguez High School 80.220055 52.988247 \n", "Figueroa High School 80.739234 53.204476 \n", "Huang High School 81.316421 53.513884 \n", "Hernandez High School 80.862999 53.527508 \n", "Johnson High School 81.222432 53.539172 " ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [] }, { "cell_type": "markdown", "metadata": { "collapsed": true }, "source": [ "## Math Scores by Grade" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "* Create a table that lists the average Reading Score for students of each grade level (9th, 10th, 11th, 12th) at each school.\n", "\n", " * Create a pandas series for each grade. Hint: use a conditional statement.\n", " \n", " * Group each series by school\n", " \n", " * Combine the series into a dataframe\n", " \n", " * Optional: give the displayed data cleaner formatting" ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [ { "data": { "text/html": [ "<div>\n", "<style scoped>\n", " .dataframe tbody tr th:only-of-type {\n", " vertical-align: middle;\n", " }\n", "\n", " .dataframe tbody tr th {\n", " vertical-align: top;\n", " }\n", "\n", " .dataframe thead th {\n", " text-align: right;\n", " }\n", "</style>\n", "<table border=\"1\" class=\"dataframe\">\n", " <thead>\n", " <tr style=\"text-align: right;\">\n", " <th></th>\n", " <th>9th</th>\n", " <th>10th</th>\n", " <th>11th</th>\n", " <th>12th</th>\n", " </tr>\n", " </thead>\n", " <tbody>\n", " <tr>\n", " <th>Bailey High School</th>\n", " <td>77.083676</td>\n", " <td>76.996772</td>\n", " <td>77.515588</td>\n", " <td>76.492218</td>\n", " </tr>\n", " <tr>\n", " <th>Cabrera High School</th>\n", " <td>83.094697</td>\n", " <td>83.154506</td>\n", " <td>82.765560</td>\n", " <td>83.277487</td>\n", " </tr>\n", " <tr>\n", " <th>Figueroa High School</th>\n", " <td>76.403037</td>\n", " <td>76.539974</td>\n", " <td>76.884344</td>\n", " <td>77.151369</td>\n", " </tr>\n", " <tr>\n", " <th>Ford High School</th>\n", " <td>77.361345</td>\n", " <td>77.672316</td>\n", " <td>76.918058</td>\n", " <td>76.179963</td>\n", " </tr>\n", " <tr>\n", " <th>Griffin High School</th>\n", " <td>82.044010</td>\n", " <td>84.229064</td>\n", " <td>83.842105</td>\n", " <td>83.356164</td>\n", " </tr>\n", " <tr>\n", " <th>Hernandez High School</th>\n", " <td>77.438495</td>\n", " <td>77.337408</td>\n", " <td>77.136029</td>\n", " <td>77.186567</td>\n", " </tr>\n", " <tr>\n", " <th>Holden High School</th>\n", " <td>83.787402</td>\n", " <td>83.429825</td>\n", " <td>85.000000</td>\n", " <td>82.855422</td>\n", " </tr>\n", " <tr>\n", " <th>Huang High School</th>\n", " <td>77.027251</td>\n", " <td>75.908735</td>\n", " <td>76.446602</td>\n", " <td>77.225641</td>\n", " </tr>\n", " <tr>\n", " <th>Johnson High School</th>\n", " <td>77.187857</td>\n", " <td>76.691117</td>\n", " <td>77.491653</td>\n", " <td>76.863248</td>\n", " </tr>\n", " <tr>\n", " <th>Pena High School</th>\n", " <td>83.625455</td>\n", " <td>83.372000</td>\n", " <td>84.328125</td>\n", " <td>84.121547</td>\n", " </tr>\n", " <tr>\n", " <th>Rodriguez High School</th>\n", " <td>76.859966</td>\n", " <td>76.612500</td>\n", " <td>76.395626</td>\n", " <td>77.690748</td>\n", " </tr>\n", " <tr>\n", " <th>Shelton High School</th>\n", " <td>83.420755</td>\n", " <td>82.917411</td>\n", " <td>83.383495</td>\n", " <td>83.778976</td>\n", " </tr>\n", " <tr>\n", " <th>Thomas High School</th>\n", " <td>83.590022</td>\n", " <td>83.087886</td>\n", " <td>83.498795</td>\n", " <td>83.497041</td>\n", " </tr>\n", " <tr>\n", " <th>Wilson High School</th>\n", " <td>83.085578</td>\n", " <td>83.724422</td>\n", " <td>83.195326</td>\n", " <td>83.035794</td>\n", " </tr>\n", " <tr>\n", " <th>Wright High School</th>\n", " <td>83.264706</td>\n", " <td>84.010288</td>\n", " <td>83.836782</td>\n", " <td>83.644986</td>\n", " </tr>\n", " </tbody>\n", "</table>\n", "</div>" ], "text/plain": [ " 9th 10th 11th 12th\n", "Bailey High School 77.083676 76.996772 77.515588 76.492218\n", "Cabrera High School 83.094697 83.154506 82.765560 83.277487\n", "Figueroa High School 76.403037 76.539974 76.884344 77.151369\n", "Ford High School 77.361345 77.672316 76.918058 76.179963\n", "Griffin High School 82.044010 84.229064 83.842105 83.356164\n", "Hernandez High School 77.438495 77.337408 77.136029 77.186567\n", "Holden High School 83.787402 83.429825 85.000000 82.855422\n", "Huang High School 77.027251 75.908735 76.446602 77.225641\n", "Johnson High School 77.187857 76.691117 77.491653 76.863248\n", "Pena High School 83.625455 83.372000 84.328125 84.121547\n", "Rodriguez High School 76.859966 76.612500 76.395626 77.690748\n", "Shelton High School 83.420755 82.917411 83.383495 83.778976\n", "Thomas High School 83.590022 83.087886 83.498795 83.497041\n", "Wilson High School 83.085578 83.724422 83.195326 83.035794\n", "Wright High School 83.264706 84.010288 83.836782 83.644986" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Reading Score by Grade " ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "* Perform the same operations as above for reading scores" ] }, { "cell_type": "code", "execution_count": 13, "metadata": {}, "outputs": [ { "data": { "text/html": [ "<div>\n", "<style scoped>\n", " .dataframe tbody tr th:only-of-type {\n", " vertical-align: middle;\n", " }\n", "\n", " .dataframe tbody tr th {\n", " vertical-align: top;\n", " }\n", "\n", " .dataframe thead th {\n", " text-align: right;\n", " }\n", "</style>\n", "<table border=\"1\" class=\"dataframe\">\n", " <thead>\n", " <tr style=\"text-align: right;\">\n", " <th></th>\n", " <th>9th</th>\n", " <th>10th</th>\n", " <th>11th</th>\n", " <th>12th</th>\n", " </tr>\n", " </thead>\n", " <tbody>\n", " <tr>\n", " <th>Bailey High School</th>\n", " <td>81.303155</td>\n", " <td>80.907183</td>\n", " <td>80.945643</td>\n", " <td>80.912451</td>\n", " </tr>\n", " <tr>\n", " <th>Cabrera High School</th>\n", " <td>83.676136</td>\n", " <td>84.253219</td>\n", " <td>83.788382</td>\n", " <td>84.287958</td>\n", " </tr>\n", " <tr>\n", " <th>Figueroa High School</th>\n", " <td>81.198598</td>\n", " <td>81.408912</td>\n", " <td>80.640339</td>\n", " <td>81.384863</td>\n", " </tr>\n", " <tr>\n", " <th>Ford High School</th>\n", " <td>80.632653</td>\n", " <td>81.262712</td>\n", " <td>80.403642</td>\n", " <td>80.662338</td>\n", " </tr>\n", " <tr>\n", " <th>Griffin High School</th>\n", " <td>83.369193</td>\n", " <td>83.706897</td>\n", " <td>84.288089</td>\n", " <td>84.013699</td>\n", " </tr>\n", " <tr>\n", " <th>Hernandez High School</th>\n", " <td>80.866860</td>\n", " <td>80.660147</td>\n", " <td>81.396140</td>\n", " <td>80.857143</td>\n", " </tr>\n", " <tr>\n", " <th>Holden High School</th>\n", " <td>83.677165</td>\n", " <td>83.324561</td>\n", " <td>83.815534</td>\n", " <td>84.698795</td>\n", " </tr>\n", " <tr>\n", " <th>Huang High School</th>\n", " <td>81.290284</td>\n", " <td>81.512386</td>\n", " <td>81.417476</td>\n", " <td>80.305983</td>\n", " </tr>\n", " <tr>\n", " <th>Johnson High School</th>\n", " <td>81.260714</td>\n", " <td>80.773431</td>\n", " <td>80.616027</td>\n", " <td>81.227564</td>\n", " </tr>\n", " <tr>\n", " <th>Pena High School</th>\n", " <td>83.807273</td>\n", " <td>83.612000</td>\n", " <td>84.335938</td>\n", " <td>84.591160</td>\n", " </tr>\n", " <tr>\n", " <th>Rodriguez High School</th>\n", " <td>80.993127</td>\n", " <td>80.629808</td>\n", " <td>80.864811</td>\n", " <td>80.376426</td>\n", " </tr>\n", " <tr>\n", " <th>Shelton High School</th>\n", " <td>84.122642</td>\n", " <td>83.441964</td>\n", " <td>84.373786</td>\n", " <td>82.781671</td>\n", " </tr>\n", " <tr>\n", " <th>Thomas High School</th>\n", " <td>83.728850</td>\n", " <td>84.254157</td>\n", " <td>83.585542</td>\n", " <td>83.831361</td>\n", " </tr>\n", " <tr>\n", " <th>Wilson High School</th>\n", " <td>83.939778</td>\n", " <td>84.021452</td>\n", " <td>83.764608</td>\n", " <td>84.317673</td>\n", " </tr>\n", " <tr>\n", " <th>Wright High School</th>\n", " <td>83.833333</td>\n", " <td>83.812757</td>\n", " <td>84.156322</td>\n", " <td>84.073171</td>\n", " </tr>\n", " </tbody>\n", "</table>\n", "</div>" ], "text/plain": [ " 9th 10th 11th 12th\n", "Bailey High School 81.303155 80.907183 80.945643 80.912451\n", "Cabrera High School 83.676136 84.253219 83.788382 84.287958\n", "Figueroa High School 81.198598 81.408912 80.640339 81.384863\n", "Ford High School 80.632653 81.262712 80.403642 80.662338\n", "Griffin High School 83.369193 83.706897 84.288089 84.013699\n", "Hernandez High School 80.866860 80.660147 81.396140 80.857143\n", "Holden High School 83.677165 83.324561 83.815534 84.698795\n", "Huang High School 81.290284 81.512386 81.417476 80.305983\n", "Johnson High School 81.260714 80.773431 80.616027 81.227564\n", "Pena High School 83.807273 83.612000 84.335938 84.591160\n", "Rodriguez High School 80.993127 80.629808 80.864811 80.376426\n", "Shelton High School 84.122642 83.441964 84.373786 82.781671\n", "Thomas High School 83.728850 84.254157 83.585542 83.831361\n", "Wilson High School 83.939778 84.021452 83.764608 84.317673\n", "Wright High School 83.833333 83.812757 84.156322 84.073171" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Scores by School Spending" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "* Create a table that breaks down school performances based on average Spending Ranges (Per Student). Use 4 reasonable bins to group school spending. Include in the table each of the following:\n", " * Average Math Score\n", " * Average Reading Score\n", " * % Passing Math\n", " * % Passing Reading\n", " * Overall Passing Rate (Average of the above two)" ] }, { "cell_type": "code", "execution_count": 18, "metadata": {}, "outputs": [ { "data": { "text/html": [ "<div>\n", "<style scoped>\n", " .dataframe tbody tr th:only-of-type {\n", " vertical-align: middle;\n", " }\n", "\n", " .dataframe tbody tr th {\n", " vertical-align: top;\n", " }\n", "\n", " .dataframe thead th {\n", " text-align: right;\n", " }\n", "</style>\n", "<table border=\"1\" class=\"dataframe\">\n", " <thead>\n", " <tr style=\"text-align: right;\">\n", " <th></th>\n", " <th>Average Math Score</th>\n", " <th>Average Reading Score</th>\n", " <th>% Passing Math</th>\n", " <th>% Passing Reading</th>\n", " <th>% Overall Passing</th>\n", " </tr>\n", " <tr>\n", " <th>Spending Ranges (Per Student)</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><$584</th>\n", " <td>83.46</td>\n", " <td>83.93</td>\n", " <td>93.46</td>\n", " <td>96.61</td>\n", " <td>90.37</td>\n", " </tr>\n", " <tr>\n", " <th>$585-629</th>\n", " <td>81.90</td>\n", " <td>83.16</td>\n", " <td>87.13</td>\n", " <td>92.72</td>\n", " <td>81.42</td>\n", " </tr>\n", " <tr>\n", " <th>$630-644</th>\n", " <td>78.52</td>\n", " <td>81.62</td>\n", " <td>73.48</td>\n", " <td>84.39</td>\n", " <td>62.86</td>\n", " </tr>\n", " <tr>\n", " <th>$645-675</th>\n", " <td>77.00</td>\n", " <td>81.03</td>\n", " <td>66.16</td>\n", " <td>81.13</td>\n", " <td>53.53</td>\n", " </tr>\n", " </tbody>\n", "</table>\n", "</div>" ], "text/plain": [ " Average Math Score Average Reading Score \\\n", "Spending Ranges (Per Student) \n", "<$584 83.46 83.93 \n", "$585-629 81.90 83.16 \n", "$630-644 78.52 81.62 \n", "$645-675 77.00 81.03 \n", "\n", " % Passing Math % Passing Reading \\\n", "Spending Ranges (Per Student) \n", "<$584 93.46 96.61 \n", "$585-629 87.13 92.72 \n", "$630-644 73.48 84.39 \n", "$645-675 66.16 81.13 \n", "\n", " % Overall Passing \n", "Spending Ranges (Per Student) \n", "<$584 90.37 \n", "$585-629 81.42 \n", "$630-644 62.86 \n", "$645-675 53.53 " ] }, "execution_count": 18, "metadata": {}, "output_type": "execute_result" } ], "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Scores by School Size" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "* Perform the same operations as above, based on school size." ] }, { "cell_type": "code", "execution_count": 22, "metadata": { "scrolled": true }, "outputs": [ { "data": { "text/html": [ "<div>\n", "<style scoped>\n", " .dataframe tbody tr th:only-of-type {\n", " vertical-align: middle;\n", " }\n", "\n", " .dataframe tbody tr th {\n", " vertical-align: top;\n", " }\n", "\n", " .dataframe thead th {\n", " text-align: right;\n", " }\n", "</style>\n", "<table border=\"1\" class=\"dataframe\">\n", " <thead>\n", " <tr style=\"text-align: right;\">\n", " <th></th>\n", " <th>Average Math Score</th>\n", " <th>Average Reading Score</th>\n", " <th>% Passing Math</th>\n", " <th>% Passing Reading</th>\n", " <th>% Overall Passing</th>\n", " </tr>\n", " <tr>\n", " <th>School Size</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>Small (<1000)</th>\n", " <td>83.821598</td>\n", " <td>83.929843</td>\n", " <td>93.550225</td>\n", " <td>96.099437</td>\n", " <td>89.883853</td>\n", " </tr>\n", " <tr>\n", " <th>Medium (1000-2000)</th>\n", " <td>83.374684</td>\n", " <td>83.864438</td>\n", " <td>93.599695</td>\n", " <td>96.790680</td>\n", " <td>90.621535</td>\n", " </tr>\n", " <tr>\n", " <th>Large (2000-5000)</th>\n", " <td>77.746417</td>\n", " <td>81.344493</td>\n", " <td>69.963361</td>\n", " <td>82.766634</td>\n", " <td>58.286003</td>\n", " </tr>\n", " </tbody>\n", "</table>\n", "</div>" ], "text/plain": [ " Average Math Score Average Reading Score % Passing Math \\\n", "School Size \n", "Small (<1000) 83.821598 83.929843 93.550225 \n", "Medium (1000-2000) 83.374684 83.864438 93.599695 \n", "Large (2000-5000) 77.746417 81.344493 69.963361 \n", "\n", " % Passing Reading % Overall Passing \n", "School Size \n", "Small (<1000) 96.099437 89.883853 \n", "Medium (1000-2000) 96.790680 90.621535 \n", "Large (2000-5000) 82.766634 58.286003 " ] }, "execution_count": 22, "metadata": {}, "output_type": "execute_result" } ], "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Scores by School Type" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "* Perform the same operations as above, based on school type" ] }, { "cell_type": "code", "execution_count": 24, "metadata": {}, "outputs": [ { "data": { "text/html": [ "<div>\n", "<style scoped>\n", " .dataframe tbody tr th:only-of-type {\n", " vertical-align: middle;\n", " }\n", "\n", " .dataframe tbody tr th {\n", " vertical-align: top;\n", " }\n", "\n", " .dataframe thead th {\n", " text-align: right;\n", " }\n", "</style>\n", "<table border=\"1\" class=\"dataframe\">\n", " <thead>\n", " <tr style=\"text-align: right;\">\n", " <th></th>\n", " <th>Average Math Score</th>\n", " <th>Average Reading Score</th>\n", " <th>% Passing Math</th>\n", " <th>% Passing Reading</th>\n", " <th>% Overall Passing</th>\n", " </tr>\n", " <tr>\n", " <th>School Type</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>Charter</th>\n", " <td>83.473852</td>\n", " <td>83.896421</td>\n", " <td>93.620830</td>\n", " <td>96.586489</td>\n", " <td>90.432244</td>\n", " </tr>\n", " <tr>\n", " <th>District</th>\n", " <td>76.956733</td>\n", " <td>80.966636</td>\n", " <td>66.548453</td>\n", " <td>80.799062</td>\n", " <td>53.672208</td>\n", " </tr>\n", " </tbody>\n", "</table>\n", "</div>" ], "text/plain": [ " Average Math Score Average Reading Score % Passing Math \\\n", "School Type \n", "Charter 83.473852 83.896421 93.620830 \n", "District 76.956733 80.966636 66.548453 \n", "\n", " % Passing Reading % Overall Passing \n", "School Type \n", "Charter 96.586489 90.432244 \n", "District 80.799062 53.672208 " ] }, "execution_count": 24, "metadata": {}, "output_type": "execute_result" } ], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "anaconda-cloud": {}, "kernel_info": { "name": "python3" }, "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.6.9" }, "latex_envs": { "LaTeX_envs_menu_present": true, "autoclose": false, "autocomplete": true, "bibliofile": "biblio.bib", "cite_by": "apalike", "current_citInitial": 1, "eqLabelWithNumbers": true, "eqNumInitial": 1, "hotkeys": { "equation": "Ctrl-E", "itemize": "Ctrl-I" }, "labels_anchors": false, "latex_user_defs": false, "report_style_numbering": false, "user_envs_cfg": false }, "nteract": { "version": "0.8.4" } }, "nbformat": 4, "nbformat_minor": 1 }
