firstApiPy_testing.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['C:\\\\Users\\\\stacy\\\\OneDrive\\\\Projects\\\\scouting17\\\\irsScouting2017\\\\Server',\n",
       " 'C:\\\\Users\\\\stacy\\\\OneDrive\\\\Projects\\\\scouting17\\\\irsScouting2017\\\\Server',\n",
       " 'C:\\\\Users\\\\stacy\\\\OneDrive\\\\Projects\\\\scouting17\\\\irsScouting2017\\\\Server']"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import sys\n",
    "# This path will be different on your machine. Please change it accordingly.\n",
    "project_path = 'C:\\Users\\stacy\\OneDrive\\Projects\\scouting17\\irsScouting2017\\Server'\n",
    "sys.path.append(project_path)\n",
    "# Let's verify the path was added. The syntax below works because the data type of sys.path is Python List.\n",
    "sys.path[-3:]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Get a Database Connection\n",
    "We can get a database engine from the irsScouting system, or directly from the database server via the sqlalchemy package."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# From irsScouting\n",
    "import scouting.db as db\n",
    "engine = db.getdbengine()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Directly from Postgresql via sqlalchemy\n",
    "import sqlalchemy as sa\n",
    "connection_string = 'postgresql://irs1318:irs1318@localhost:5432/scouting'\n",
    "engine = sa.create_engine(connection_string)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Get a Rankings Table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "import scouting.output as out\n",
    "tasks = ['moveBaseline', 'placeGear','shootHighBoiler', 'shootLowBoiler']\n",
    "ranks = out.get_rankings(tasks = tasks, excel_file = None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th>task</th>\n",
       "      <th colspan=\"3\" halign=\"left\">moveBaseline</th>\n",
       "      <th colspan=\"3\" halign=\"left\">placeGear</th>\n",
       "      <th colspan=\"3\" halign=\"left\">shootHighBoiler</th>\n",
       "      <th colspan=\"3\" halign=\"left\">shootLowBoiler</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>sum_successes</th>\n",
       "      <th>sum_attempts</th>\n",
       "      <th>percent</th>\n",
       "      <th>sum_successes</th>\n",
       "      <th>sum_attempts</th>\n",
       "      <th>percent</th>\n",
       "      <th>sum_successes</th>\n",
       "      <th>sum_attempts</th>\n",
       "      <th>percent</th>\n",
       "      <th>sum_successes</th>\n",
       "      <th>sum_attempts</th>\n",
       "      <th>percent</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>team</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>1258</th>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.25</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1294</th>\n",
       "      <td>7.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1318</th>\n",
       "      <td>6.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.50</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1899</th>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1983</th>\n",
       "      <td>7.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "task  moveBaseline                          placeGear                         \\\n",
       "     sum_successes sum_attempts percent sum_successes sum_attempts   percent   \n",
       "team                                                                           \n",
       "1258           5.0          4.0    1.25           2.0          0.0       inf   \n",
       "1294           7.0          7.0    1.00           3.0          1.0  3.000000   \n",
       "1318           6.0          4.0    1.50           3.0          0.0       inf   \n",
       "1899           2.0          5.0    0.40           1.0          0.0       inf   \n",
       "1983           7.0          7.0    1.00           5.0          0.0       inf   \n",
       "\n",
       "task shootHighBoiler                      shootLowBoiler                       \n",
       "       sum_successes sum_attempts percent  sum_successes sum_attempts percent  \n",
       "team                                                                           \n",
       "1258             NaN          NaN     NaN            NaN          NaN     NaN  \n",
       "1294             NaN          NaN     NaN            0.0          0.0     NaN  \n",
       "1318             2.0          2.0     1.0            NaN          NaN     NaN  \n",
       "1899             NaN          NaN     NaN            NaN          NaN     NaN  \n",
       "1983             NaN          NaN     NaN            NaN          NaN     NaN  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ranks['auto'].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th>task</th>\n",
       "      <th colspan=\"3\" halign=\"left\">placeGear</th>\n",
       "      <th colspan=\"3\" halign=\"left\">shootHighBoiler</th>\n",
       "      <th colspan=\"3\" halign=\"left\">shootLowBoiler</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>sum_successes</th>\n",
       "      <th>sum_attempts</th>\n",
       "      <th>percent</th>\n",
       "      <th>sum_successes</th>\n",
       "      <th>sum_attempts</th>\n",
       "      <th>percent</th>\n",
       "      <th>sum_successes</th>\n",
       "      <th>sum_attempts</th>\n",
       "      <th>percent</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>team</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>4469</th>\n",
       "      <td>32.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>0.941176</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2930</th>\n",
       "      <td>30.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0.937500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5588</th>\n",
       "      <td>30.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5803</th>\n",
       "      <td>30.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2942</th>\n",
       "      <td>23.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>0.920000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2046</th>\n",
       "      <td>22.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>5.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.185185</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1294</th>\n",
       "      <td>21.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1983</th>\n",
       "      <td>19.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>0.863636</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2976</th>\n",
       "      <td>19.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>0.863636</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2907</th>\n",
       "      <td>17.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "task     placeGear                        shootHighBoiler               \\\n",
       "     sum_successes sum_attempts   percent   sum_successes sum_attempts   \n",
       "team                                                                     \n",
       "4469          32.0         34.0  0.941176             0.0          3.0   \n",
       "2930          30.0         32.0  0.937500             NaN          NaN   \n",
       "5588          30.0         30.0  1.000000             6.0          8.0   \n",
       "5803          30.0         30.0  1.000000             NaN          NaN   \n",
       "2942          23.0         25.0  0.920000             NaN          NaN   \n",
       "2046          22.0         22.0  1.000000             5.0         27.0   \n",
       "1294          21.0         21.0  1.000000             2.0          6.0   \n",
       "1983          19.0         22.0  0.863636             0.0          0.0   \n",
       "2976          19.0         22.0  0.863636             NaN          NaN   \n",
       "2907          17.0         17.0  1.000000             NaN          NaN   \n",
       "\n",
       "task           shootLowBoiler                       \n",
       "       percent  sum_successes sum_attempts percent  \n",
       "team                                                \n",
       "4469  0.000000            0.0         10.0     0.0  \n",
       "2930       NaN            NaN          NaN     NaN  \n",
       "5588  0.750000            NaN          NaN     NaN  \n",
       "5803       NaN            NaN          NaN     NaN  \n",
       "2942       NaN            NaN          NaN     NaN  \n",
       "2046  0.185185            NaN          NaN     NaN  \n",
       "1294  0.333333            NaN          NaN     NaN  \n",
       "1983       NaN            NaN          NaN     NaN  \n",
       "2976       NaN            0.0          0.0     NaN  \n",
       "2907       NaN            0.0          6.0     0.0  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ranks.sort_values(by=('teleop', 'placeGear', 'sum_successes'), ascending = False)[('teleop')].head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th>task</th>\n",
       "      <th colspan=\"3\" halign=\"left\">disabled</th>\n",
       "      <th colspan=\"3\" halign=\"left\">hasRobot</th>\n",
       "      <th colspan=\"3\" halign=\"left\">maintainContact</th>\n",
       "      <th colspan=\"3\" halign=\"left\">pushTouchPad</th>\n",
       "      <th colspan=\"3\" halign=\"left\">shotPercentHigh</th>\n",
       "      <th colspan=\"3\" halign=\"left\">shotPercentLow</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>sum_successes</th>\n",
       "      <th>sum_attempts</th>\n",
       "      <th>percent</th>\n",
       "      <th>sum_successes</th>\n",
       "      <th>sum_attempts</th>\n",
       "      <th>percent</th>\n",
       "      <th>sum_successes</th>\n",
       "      <th>sum_attempts</th>\n",
       "      <th>percent</th>\n",
       "      <th>sum_successes</th>\n",
       "      <th>sum_attempts</th>\n",
       "      <th>percent</th>\n",
       "      <th>sum_successes</th>\n",
       "      <th>sum_attempts</th>\n",
       "      <th>percent</th>\n",
       "      <th>sum_successes</th>\n",
       "      <th>sum_attempts</th>\n",
       "      <th>percent</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>team</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>4469</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1983</th>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5588</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2930</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1318</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2907</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3588</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4681</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4131</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2046</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "task      disabled                           hasRobot                       \\\n",
       "     sum_successes sum_attempts percent sum_successes sum_attempts percent   \n",
       "team                                                                         \n",
       "4469           NaN          NaN     NaN           NaN          NaN     NaN   \n",
       "1983           2.0          0.0     inf           NaN          NaN     NaN   \n",
       "5588           NaN          NaN     NaN           NaN          NaN     NaN   \n",
       "2930           NaN          NaN     NaN           NaN          NaN     NaN   \n",
       "1318           1.0          0.0     inf           NaN          NaN     NaN   \n",
       "2907           NaN          NaN     NaN           NaN          NaN     NaN   \n",
       "3588           NaN          NaN     NaN           NaN          NaN     NaN   \n",
       "4681           NaN          NaN     NaN           NaN          NaN     NaN   \n",
       "4131           1.0          0.0     inf           NaN          NaN     NaN   \n",
       "2046           NaN          NaN     NaN           NaN          NaN     NaN   \n",
       "\n",
       "task maintainContact                       pushTouchPad                       \\\n",
       "       sum_successes sum_attempts percent sum_successes sum_attempts percent   \n",
       "team                                                                           \n",
       "4469            10.0          0.0     inf          10.0          0.0     inf   \n",
       "1983             4.0          0.0     inf           9.0          0.0     inf   \n",
       "5588             8.0          0.0     inf           9.0          0.0     inf   \n",
       "2930             8.0          0.0     inf           8.0          0.0     inf   \n",
       "1318             7.0          0.0     inf           8.0          0.0     inf   \n",
       "2907             4.0          0.0     inf           8.0          0.0     inf   \n",
       "3588             5.0          0.0     inf           8.0          0.0     inf   \n",
       "4681             7.0          0.0     inf           8.0          0.0     inf   \n",
       "4131             1.0          0.0     inf           7.0          0.0     inf   \n",
       "2046             7.0          0.0     inf           7.0          0.0     inf   \n",
       "\n",
       "task shotPercentHigh                      shotPercentLow                       \n",
       "       sum_successes sum_attempts percent  sum_successes sum_attempts percent  \n",
       "team                                                                           \n",
       "4469             0.0          0.0     NaN            NaN          NaN     NaN  \n",
       "1983             0.0          0.0     NaN            0.0          0.0     NaN  \n",
       "5588             NaN          NaN     NaN            NaN          NaN     NaN  \n",
       "2930             0.0          0.0     NaN            0.0          0.0     NaN  \n",
       "1318             0.0          0.0     NaN            0.0          0.0     NaN  \n",
       "2907             NaN          NaN     NaN            NaN          NaN     NaN  \n",
       "3588             0.0          0.0     NaN            0.0          0.0     NaN  \n",
       "4681             0.0          0.0     NaN            0.0          0.0     NaN  \n",
       "4131             0.0          0.0     NaN            0.0          0.0     NaN  \n",
       "2046             0.0          0.0     NaN            0.0          0.0     NaN  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_ranks = out.get_rankings(excel_file = None)\n",
    "all_ranks.sort_values(by=('finish', 'pushTouchPad', 'sum_successes'), ascending = False)[('finish')].head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2017Mar18_105918'"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import datetime as dt\n",
    "dt.datetime.now().strftime(\"%Y%b%d_%H%M%S\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "u'waamv'"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import scouting.event as evt\n",
    "evt.EventDal.get_current_event()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "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.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}