{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import os\n", "import glob\n", "from collections import defaultdict\n", "\n", "import numpy as np\n", "import pandas as pd\n", "\n", "import matplotlib.pyplot as plt\n", "\n", "import watchcbb.utils as utils" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Shape: (54760, 37)\n" ] }, { "data": { "text/html": [ "
| \n", " | index | \n", "Season | \n", "Date | \n", "Type | \n", "WTeamID | \n", "WScore | \n", "LTeamID | \n", "LScore | \n", "WLoc | \n", "NumOT | \n", "... | \n", "LFTM | \n", "LFTA | \n", "LOR | \n", "LDR | \n", "LAst | \n", "LTO | \n", "LStl | \n", "LBlk | \n", "LPF | \n", "poss | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "0 | \n", "2011 | \n", "2010-11-08 | \n", "RG | \n", "illinois | \n", "79 | \n", "california-irvine | \n", "65 | \n", "H | \n", "0 | \n", "... | \n", "14 | \n", "22 | \n", "11 | \n", "26 | \n", "12 | \n", "14 | \n", "7 | \n", "1 | \n", "21 | \n", "74.90 | \n", "
| 1 | \n", "3 | \n", "2011 | \n", "2010-11-08 | \n", "RG | \n", "pittsburgh | \n", "83 | \n", "rhode-island | \n", "75 | \n", "H | \n", "0 | \n", "... | \n", "13 | \n", "16 | \n", "9 | \n", "20 | \n", "16 | \n", "16 | \n", "7 | \n", "6 | \n", "25 | \n", "75.62 | \n", "
| 2 | \n", "1 | \n", "2011 | \n", "2010-11-08 | \n", "RG | \n", "maryland | \n", "105 | \n", "seattle | \n", "76 | \n", "H | \n", "0 | \n", "... | \n", "17 | \n", "22 | \n", "13 | \n", "16 | \n", "11 | \n", "27 | \n", "18 | \n", "1 | \n", "31 | \n", "98.36 | \n", "
| 3 | \n", "2 | \n", "2011 | \n", "2010-11-08 | \n", "RG | \n", "texas | \n", "83 | \n", "navy | \n", "52 | \n", "H | \n", "0 | \n", "... | \n", "10 | \n", "18 | \n", "5 | \n", "21 | \n", "8 | \n", "16 | \n", "5 | \n", "5 | \n", "24 | \n", "80.44 | \n", "
| 4 | \n", "4 | \n", "2011 | \n", "2010-11-10 | \n", "RG | \n", "maryland | \n", "75 | \n", "college-of-charleston | \n", "74 | \n", "H | \n", "0 | \n", "... | \n", "16 | \n", "19 | \n", "10 | \n", "25 | \n", "12 | \n", "22 | \n", "8 | \n", "8 | \n", "19 | \n", "77.64 | \n", "
| 5 | \n", "5 | \n", "2011 | \n", "2010-11-10 | \n", "RG | \n", "pittsburgh | \n", "97 | \n", "illinois-chicago | \n", "54 | \n", "H | \n", "0 | \n", "... | \n", "7 | \n", "9 | \n", "5 | \n", "15 | \n", "9 | \n", "11 | \n", "0 | \n", "3 | \n", "18 | \n", "67.88 | \n", "
| 6 | \n", "6 | \n", "2011 | \n", "2010-11-10 | \n", "RG | \n", "illinois | \n", "84 | \n", "toledo | \n", "45 | \n", "H | \n", "0 | \n", "... | \n", "10 | \n", "19 | \n", "3 | \n", "16 | \n", "9 | \n", "23 | \n", "6 | \n", "0 | \n", "14 | \n", "72.00 | \n", "
| 7 | \n", "7 | \n", "2011 | \n", "2010-11-10 | \n", "RG | \n", "texas | \n", "89 | \n", "louisiana-tech | \n", "58 | \n", "H | \n", "0 | \n", "... | \n", "13 | \n", "20 | \n", "13 | \n", "25 | \n", "4 | \n", "22 | \n", "6 | \n", "5 | \n", "21 | \n", "83.74 | \n", "
| 8 | \n", "78 | \n", "2011 | \n", "2010-11-12 | \n", "RG | \n", "tulane | \n", "91 | \n", "maryland-eastern-shore | \n", "62 | \n", "A | \n", "0 | \n", "... | \n", "19 | \n", "26 | \n", "9 | \n", "16 | \n", "11 | \n", "21 | \n", "4 | \n", "2 | \n", "28 | \n", "78.04 | \n", "
| 9 | \n", "77 | \n", "2011 | \n", "2010-11-12 | \n", "RG | \n", "marquette | \n", "97 | \n", "prairie-view | \n", "58 | \n", "H | \n", "0 | \n", "... | \n", "7 | \n", "11 | \n", "3 | \n", "13 | \n", "12 | \n", "20 | \n", "11 | \n", "3 | \n", "27 | \n", "79.12 | \n", "
10 rows × 37 columns
\n", "| \n", " | year | \n", "team_id | \n", "wins | \n", "losses | \n", "totOT | \n", "TScore | \n", "TFGM | \n", "TFGA | \n", "TFGM3 | \n", "TFGA3 | \n", "... | \n", "Torbp | \n", "Tftr | \n", "Oposs | \n", "Oeff | \n", "Oastr | \n", "Otovr | \n", "Oefgp | \n", "Oorbp | \n", "Oftr | \n", "rawpace | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "2011 | \n", "air-force | \n", "12 | \n", "8 | \n", "2 | \n", "1328 | \n", "463 | \n", "941 | \n", "133 | \n", "333 | \n", "... | \n", "0.192678 | \n", "0.414453 | \n", "1261.96 | \n", "101.825731 | \n", "0.157057 | \n", "0.169381 | \n", "0.485780 | \n", "0.342949 | \n", "0.283486 | \n", "61.890370 | \n", "
| 1 | \n", "2011 | \n", "akron | \n", "12 | \n", "10 | \n", "2 | \n", "1498 | \n", "527 | \n", "1263 | \n", "175 | \n", "508 | \n", "... | \n", "0.289833 | \n", "0.306413 | \n", "1522.28 | \n", "96.434296 | \n", "0.137450 | \n", "0.190418 | \n", "0.480897 | \n", "0.286472 | \n", "0.383721 | \n", "68.349663 | \n", "
| 2 | \n", "2011 | \n", "alabama | \n", "15 | \n", "7 | \n", "1 | \n", "1493 | \n", "566 | \n", "1249 | \n", "96 | \n", "311 | \n", "... | \n", "0.305990 | \n", "0.293034 | \n", "1502.48 | \n", "83.595123 | \n", "0.110456 | \n", "0.199252 | \n", "0.409393 | \n", "0.350689 | \n", "0.346633 | \n", "67.763164 | \n", "
| 3 | \n", "2011 | \n", "alabama-am | \n", "6 | \n", "10 | \n", "0 | \n", "959 | \n", "348 | \n", "896 | \n", "62 | \n", "237 | \n", "... | \n", "0.299213 | \n", "0.377232 | \n", "1143.32 | \n", "90.875695 | \n", "0.136156 | \n", "0.209393 | \n", "0.472254 | \n", "0.305206 | \n", "0.399773 | \n", "71.501250 | \n", "
| 4 | \n", "2011 | \n", "alabama-birmingham | \n", "16 | \n", "6 | \n", "5 | \n", "1537 | \n", "547 | \n", "1224 | \n", "166 | \n", "480 | \n", "... | \n", "0.291248 | \n", "0.307190 | \n", "1472.84 | \n", "94.375492 | \n", "0.130914 | \n", "0.164221 | \n", "0.457404 | \n", "0.330330 | \n", "0.287420 | \n", "64.801768 | \n", "
5 rows × 48 columns
\n", "| \n", " | year | \n", "team_id | \n", "wins | \n", "losses | \n", "totOT | \n", "TScore | \n", "TFGM | \n", "TFGA | \n", "TFGM3 | \n", "TFGA3 | \n", "... | \n", "Torbp | \n", "Tftr | \n", "Oposs | \n", "Oeff | \n", "Oastr | \n", "Otovr | \n", "Oefgp | \n", "Oorbp | \n", "Oftr | \n", "rawpace | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2903 | \n", "2019 | \n", "green-bay | \n", "10 | \n", "12 | \n", "2 | \n", "1787 | \n", "632 | \n", "1412 | \n", "184 | \n", "533 | \n", "... | \n", "0.257468 | \n", "0.345609 | \n", "1720.64 | \n", "108.854845 | \n", "0.144713 | \n", "0.158850 | \n", "0.539202 | \n", "0.255114 | \n", "0.360656 | \n", "77.333933 | \n", "
| 3000 | \n", "2019 | \n", "north-carolina | \n", "19 | \n", "4 | \n", "1 | \n", "2031 | \n", "726 | \n", "1532 | \n", "203 | \n", "535 | \n", "... | \n", "0.276273 | \n", "0.327023 | \n", "1776.72 | \n", "96.019632 | \n", "0.144185 | \n", "0.170009 | \n", "0.489184 | \n", "0.261494 | \n", "0.305652 | \n", "77.711568 | \n", "
| 3063 | \n", "2019 | \n", "savannah-state | \n", "7 | \n", "15 | \n", "1 | \n", "1654 | \n", "581 | \n", "1508 | \n", "253 | \n", "884 | \n", "... | \n", "0.300539 | \n", "0.241379 | \n", "1759.56 | \n", "112.869126 | \n", "0.183773 | \n", "0.164379 | \n", "0.560926 | \n", "0.273128 | \n", "0.322668 | \n", "80.038870 | \n", "
| 2876 | \n", "2019 | \n", "eastern-kentucky | \n", "8 | \n", "14 | \n", "3 | \n", "1766 | \n", "622 | \n", "1486 | \n", "189 | \n", "592 | \n", "... | \n", "0.296044 | \n", "0.327052 | \n", "1788.84 | \n", "105.096040 | \n", "0.145986 | \n", "0.188988 | \n", "0.538293 | \n", "0.240936 | \n", "0.409190 | \n", "80.484469 | \n", "
| 2887 | \n", "2019 | \n", "florida-international | \n", "10 | \n", "10 | \n", "0 | \n", "1604 | \n", "563 | \n", "1313 | \n", "169 | \n", "568 | \n", "... | \n", "0.282468 | \n", "0.369383 | \n", "1592.84 | \n", "106.037016 | \n", "0.144561 | \n", "0.192815 | \n", "0.547049 | \n", "0.264339 | \n", "0.367624 | \n", "80.731000 | \n", "
5 rows × 48 columns
\n", "