{ "metadata": { "name": "" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "code", "collapsed": false, "input": [ "%matplotlib inline\n", "# from pylab import *\n", "\n", "import matplotlib.pyplot as plt\n", "import pandas as pd\n", "import numpy as np\n", "\n", "from sklearn.naive_bayes import MultinomialNB" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 1 }, { "cell_type": "code", "collapsed": false, "input": [ "data = pd.read_csv('Chicago_Public_Schools_-_Elementary_School_Progress_Report__2013-2014_.csv',index_col='School ID')" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 23 }, { "cell_type": "code", "collapsed": false, "input": [ "# import progress report data, titles are included in the file\n", "#data = pd.read_csv('Chicago_Public_Schools_-_Elementary_School_Progress_Report__2013-2014_.csv').dropna()" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 5 }, { "cell_type": "code", "collapsed": false, "input": [ "data.head(5) # print the first 5 rows\n" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", " | Name of School | \n", "Street Address | \n", "City | \n", "State | \n", "ZIP Code | \n", "Phone Number | \n", "Website | \n", "Blue Ribbon Award | \n", "CPS Performance Policy Level | \n", "CPS Performance Policy Status | \n", "Probation Length | \n", "My Voice, My School Overall Rating | \n", "Student Response Rate | \n", "Teacher Response Rate | \n", "Involved Family | \n", "Supportive Environment | \n", "Ambitious Instruction | \n", "Effective Leaders | \n", "Collaborative Teachers | \n", "Safe | \n", "\n", " |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
School ID | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | |
400009 | \n", "Academy for Global Citizenship Elementary School | \n", "4647 W 47th St | \n", "Chicago | \n", "IL | \n", "60632 | \n", "(773) 582-1100 | \n", "http://www.agcchicago.org/ | \n", "NaN | \n", "LEVEL 1 | \n", "NOT APPLICABLE | \n", "NaN | \n", "NOT ENOUGH DATA | \n", "0% | \n", "47.6% | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "... | \n", "
400011 | \n", "Alain Locke Charter Elementary Academy | \n", "3141 W Jackson Blvd | \n", "Chicago | \n", "IL | \n", "60612 | \n", "(773) 265-7232 | \n", "http://www.alainlocke.org | \n", "NaN | \n", "LEVEL 1 | \n", "NOT APPLICABLE | \n", "NaN | \n", "NOT ENOUGH DATA | \n", "0.9% | \n", "0% | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "... | \n", "
400017 | \n", "ASPIRA Charter - Haugan Campus | \n", "3729 W Leland Ave | \n", "Chicago | \n", "IL | \n", "60625 | \n", "(773) 252-0970 | \n", "http://www.aspirail.org | \n", "NaN | \n", "LEVEL 2 | \n", "NOT APPLICABLE | \n", "NaN | \n", "ORGANIZED | \n", "93.2% | \n", "86.8% | \n", "NEUTRAL | \n", "STRONG | \n", "STRONG | \n", "NEUTRAL | \n", "NEUTRAL | \n", "NEUTRAL | \n", "... | \n", "
400019 | \n", "Bronzeville Lighthouse Charter Elementary School | \n", "8 W Root St | \n", "Chicago | \n", "IL | \n", "60609 | \n", "(773) 535-1460 | \n", "http://www.lighthouse-academies.org/BZLCS.htm | \n", "NaN | \n", "LEVEL 3 | \n", "NOT APPLICABLE | \n", "NaN | \n", "NOT ENOUGH DATA | \n", "2.4% | \n", "0% | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "... | \n", "
400020 | \n", "Catalyst Charter ES - Howland | \n", "1616 S Spaulding Ave | \n", "Chicago | \n", "IL | \n", "60623 | \n", "(773) 527-7330 | \n", "http://www.catalystschools.org | \n", "NaN | \n", "LEVEL 3 | \n", "NOT APPLICABLE | \n", "NaN | \n", "PARTIALLY ORGANIZED | \n", "65.2% | \n", "84% | \n", "VERY WEAK | \n", "STRONG | \n", "NEUTRAL | \n", "VERY WEAK | \n", "VERY WEAK | \n", "NEUTRAL | \n", "... | \n", "
5 rows \u00d7 73 columns
\n", "\n", " | school_name | \n", "school_add | \n", "school_city | \n", "school_state | \n", "school_zip | \n", "Phone Number | \n", "Website | \n", "Blue Ribbon Award | \n", "cps_perf | \n", "CPS Performance Policy Status | \n", "prob_length | \n", "My Voice, My School Overall Rating | \n", "student_resp_rate | \n", "teacher_resp_rate | \n", "inv_family | \n", "supp_env | \n", "amb_inst | \n", "eff_inst | \n", "coll_tea | \n", "Safe | \n", "\n", " |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
School ID | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | |
400009 | \n", "Academy for Global Citizenship Elementary School | \n", "4647 W 47th St | \n", "Chicago | \n", "IL | \n", "60632 | \n", "(773) 582-1100 | \n", "http://www.agcchicago.org/ | \n", "NaN | \n", "LEVEL 1 | \n", "NOT APPLICABLE | \n", "NaN | \n", "NOT ENOUGH DATA | \n", "0% | \n", "47.6% | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "... | \n", "
400011 | \n", "Alain Locke Charter Elementary Academy | \n", "3141 W Jackson Blvd | \n", "Chicago | \n", "IL | \n", "60612 | \n", "(773) 265-7232 | \n", "http://www.alainlocke.org | \n", "NaN | \n", "LEVEL 1 | \n", "NOT APPLICABLE | \n", "NaN | \n", "NOT ENOUGH DATA | \n", "0.9% | \n", "0% | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "... | \n", "
400017 | \n", "ASPIRA Charter - Haugan Campus | \n", "3729 W Leland Ave | \n", "Chicago | \n", "IL | \n", "60625 | \n", "(773) 252-0970 | \n", "http://www.aspirail.org | \n", "NaN | \n", "LEVEL 2 | \n", "NOT APPLICABLE | \n", "NaN | \n", "ORGANIZED | \n", "93.2% | \n", "86.8% | \n", "NEUTRAL | \n", "STRONG | \n", "STRONG | \n", "NEUTRAL | \n", "NEUTRAL | \n", "NEUTRAL | \n", "... | \n", "
400019 | \n", "Bronzeville Lighthouse Charter Elementary School | \n", "8 W Root St | \n", "Chicago | \n", "IL | \n", "60609 | \n", "(773) 535-1460 | \n", "http://www.lighthouse-academies.org/BZLCS.htm | \n", "NaN | \n", "LEVEL 3 | \n", "NOT APPLICABLE | \n", "NaN | \n", "NOT ENOUGH DATA | \n", "2.4% | \n", "0% | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "NOT ENOUGH DATA | \n", "... | \n", "
400020 | \n", "Catalyst Charter ES - Howland | \n", "1616 S Spaulding Ave | \n", "Chicago | \n", "IL | \n", "60623 | \n", "(773) 527-7330 | \n", "http://www.catalystschools.org | \n", "NaN | \n", "LEVEL 3 | \n", "NOT APPLICABLE | \n", "NaN | \n", "PARTIALLY ORGANIZED | \n", "65.2% | \n", "84% | \n", "VERY WEAK | \n", "STRONG | \n", "NEUTRAL | \n", "VERY WEAK | \n", "VERY WEAK | \n", "NEUTRAL | \n", "... | \n", "
5 rows \u00d7 73 columns
\n", "\n", " | teacher_resp_rate | \n", "
---|---|
count | \n", "478 | \n", "
unique | \n", "197 | \n", "
top | \n", "100% | \n", "
freq | \n", "58 | \n", "
4 rows \u00d7 1 columns
\n", "