{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": true }, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "collapsed": false }, "outputs": [], "source": [ "df = pd.read_excel('/Users/hunterowens/Downloads/EPASreportSchoolLevel_20151105.xls', sheetname='Attainment')" ] }, { "cell_type": "code", "execution_count": 9, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", " | School ID | \n", "School Name | \n", "Network | \n", "Test | \n", "Subject | \n", "Grade | \n", "2013 | \n", "Unnamed: 7 | \n", "Unnamed: 8 | \n", "Unnamed: 9 | \n", "2014 | \n", "Unnamed: 11 | \n", "Unnamed: 12 | \n", "Unnamed: 13 | \n", "2015 | \n", "Unnamed: 15 | \n", "Unnamed: 16 | \n", "Unnamed: 17 | \n", "
---|