HW3.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 196,
   "id": "f874e317",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import scipy.cluster.hierarchy as hc\n",
    "import matplotlib.pyplot as plt\n",
    "import scipy.spatial.distance as ssd\n",
    "from sklearn.linear_model import LogisticRegression\n",
    "from sklearn.neighbors import KNeighborsClassifier\n",
    "from sklearn.model_selection import train_test_split\n",
    "from sklearn.metrics import accuracy_score\n",
    "from scipy.io import loadmat\n",
    "from sklearn.cluster import AgglomerativeClustering, DBSCAN\n",
    "from sklearn.preprocessing import LabelBinarizer\n",
    "from sklearn.svm import SVC\n",
    "from sklearn.metrics import confusion_matrix\n",
    "from sklearn.metrics import classification_report\n",
    "from sklearn.model_selection import cross_val_score\n",
    "from collections import Counter\n",
    "from collections import defaultdict"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "80d6f52f",
   "metadata": {},
   "source": [
    "# Question 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 198,
   "id": "ae11e681",
   "metadata": {},
   "outputs": [],
   "source": [
    "pine_corrected = loadmat('./data/Indian_pines_corrected.mat')['indian_pines_corrected']\n",
    "pine_gt = loadmat('./data/Indian_pines_gt.mat')['indian_pines_gt']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 197,
   "id": "e6b4ddb9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(145, 145, 200)"
      ]
     },
     "execution_count": 197,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pine_corrected.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 199,
   "id": "2715d993",
   "metadata": {},
   "outputs": [],
   "source": [
    "X = pine_corrected.reshape((145*145,200))\n",
    "y = pine_gt.reshape(145*145)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 200,
   "id": "aa42c1fb",
   "metadata": {},
   "outputs": [],
   "source": [
    "lbl = LabelBinarizer()\n",
    "y_bin = lbl.fit_transform(y)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 201,
   "id": "656417a6",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(21025, 200)\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "(21025, 17)"
      ]
     },
     "execution_count": 201,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(X.shape)\n",
    "y_bin.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "id": "fe37c63f",
   "metadata": {},
   "outputs": [],
   "source": [
    "def modelEvaluate(model_type, X, y_bin):\n",
    "    lr_acc = []\n",
    "    svc_acc =  []\n",
    "    knn_acc = []\n",
    "    for i in range(17):\n",
    "        X_train, X_test, y_train, y_test = train_test_split(X, y_bin[:,i], test_size=0.8)\n",
    "        \n",
    "        if model_type == 'LR':\n",
    "            model = LogisticRegression(max_iter=200,solver='liblinear')\n",
    "            model.fit(X_train, y_train)\n",
    "            crossval_lr = cross_val_score(model, X_test, y_test, cv=10)\n",
    "            lr_acc.append(crossval_lr)\n",
    "            \n",
    "        elif model_type == 'SVC':\n",
    "            model = SVC(kernel='rbf',C=1.0)\n",
    "            model.fit(X_train,y_train)\n",
    "            crossval_svc = cross_val_score(model, X_test, y_test, cv=10)\n",
    "            svc_acc.append(crossval_svc)\n",
    "            \n",
    "        elif model_type == 'KNN':\n",
    "            model = KNeighborsClassifier(n_neighbors=7)\n",
    "            model.fit(X_train, y_train)\n",
    "            crossval_knn = cross_val_score(model, X_test, y_test, cv=10)\n",
    "            knn_acc.append(crossval_knn)\n",
    "    df_lr = pd.DataFrame(lr_acc)\n",
    "    df_svc = pd.DataFrame(svc_acc)\n",
    "    df_knn = pd.DataFrame(knn_acc)\n",
    "    return df_lr, df_svc, df_knn"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0e81a5c8",
   "metadata": {},
   "source": [
    "# Accuracy score of Logistic Regression model for each of the 17 class"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "id": "91588b87",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_LogReg = modelEvaluate('LR', X, y_bin)[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 122,
   "id": "dc66c94a",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_LogReg = df_LogReg.T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "id": "8607d786",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.771106</td>\n",
       "      <td>0.764566</td>\n",
       "      <td>0.758026</td>\n",
       "      <td>0.772889</td>\n",
       "      <td>0.772889</td>\n",
       "      <td>0.763377</td>\n",
       "      <td>0.757432</td>\n",
       "      <td>0.777646</td>\n",
       "      <td>0.760999</td>\n",
       "      <td>0.778835</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.998216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.963734</td>\n",
       "      <td>0.961950</td>\n",
       "      <td>0.962545</td>\n",
       "      <td>0.956005</td>\n",
       "      <td>0.958383</td>\n",
       "      <td>0.959572</td>\n",
       "      <td>0.960166</td>\n",
       "      <td>0.961356</td>\n",
       "      <td>0.958383</td>\n",
       "      <td>0.962545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.970273</td>\n",
       "      <td>0.972652</td>\n",
       "      <td>0.967301</td>\n",
       "      <td>0.967895</td>\n",
       "      <td>0.972057</td>\n",
       "      <td>0.966706</td>\n",
       "      <td>0.976219</td>\n",
       "      <td>0.970868</td>\n",
       "      <td>0.970868</td>\n",
       "      <td>0.964923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.989893</td>\n",
       "      <td>0.990488</td>\n",
       "      <td>0.989298</td>\n",
       "      <td>0.989893</td>\n",
       "      <td>0.989893</td>\n",
       "      <td>0.986326</td>\n",
       "      <td>0.991677</td>\n",
       "      <td>0.988109</td>\n",
       "      <td>0.991677</td>\n",
       "      <td>0.987515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0.989298</td>\n",
       "      <td>0.988704</td>\n",
       "      <td>0.986920</td>\n",
       "      <td>0.988109</td>\n",
       "      <td>0.988109</td>\n",
       "      <td>0.991677</td>\n",
       "      <td>0.986326</td>\n",
       "      <td>0.988109</td>\n",
       "      <td>0.988704</td>\n",
       "      <td>0.988704</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0.986326</td>\n",
       "      <td>0.987515</td>\n",
       "      <td>0.986326</td>\n",
       "      <td>0.985731</td>\n",
       "      <td>0.987515</td>\n",
       "      <td>0.985731</td>\n",
       "      <td>0.985731</td>\n",
       "      <td>0.988109</td>\n",
       "      <td>0.992271</td>\n",
       "      <td>0.981570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.998216</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.997027</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.998216</td>\n",
       "      <td>0.998216</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.997622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.994055</td>\n",
       "      <td>0.996433</td>\n",
       "      <td>0.993460</td>\n",
       "      <td>0.991677</td>\n",
       "      <td>0.993460</td>\n",
       "      <td>0.994649</td>\n",
       "      <td>0.993460</td>\n",
       "      <td>0.996433</td>\n",
       "      <td>0.997027</td>\n",
       "      <td>0.996433</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.998216</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.999405</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.968490</td>\n",
       "      <td>0.967895</td>\n",
       "      <td>0.967301</td>\n",
       "      <td>0.965517</td>\n",
       "      <td>0.964328</td>\n",
       "      <td>0.962545</td>\n",
       "      <td>0.966112</td>\n",
       "      <td>0.968490</td>\n",
       "      <td>0.968490</td>\n",
       "      <td>0.968490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0.927467</td>\n",
       "      <td>0.936385</td>\n",
       "      <td>0.933413</td>\n",
       "      <td>0.917955</td>\n",
       "      <td>0.936980</td>\n",
       "      <td>0.928062</td>\n",
       "      <td>0.929251</td>\n",
       "      <td>0.938763</td>\n",
       "      <td>0.931629</td>\n",
       "      <td>0.935196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0.982164</td>\n",
       "      <td>0.978597</td>\n",
       "      <td>0.979786</td>\n",
       "      <td>0.983353</td>\n",
       "      <td>0.980380</td>\n",
       "      <td>0.979191</td>\n",
       "      <td>0.983948</td>\n",
       "      <td>0.983948</td>\n",
       "      <td>0.980975</td>\n",
       "      <td>0.979191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.995244</td>\n",
       "      <td>0.998216</td>\n",
       "      <td>0.998216</td>\n",
       "      <td>0.995244</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.997027</td>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.999405</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0.949465</td>\n",
       "      <td>0.956599</td>\n",
       "      <td>0.958977</td>\n",
       "      <td>0.951843</td>\n",
       "      <td>0.953032</td>\n",
       "      <td>0.957788</td>\n",
       "      <td>0.961950</td>\n",
       "      <td>0.954816</td>\n",
       "      <td>0.961950</td>\n",
       "      <td>0.957194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0.980975</td>\n",
       "      <td>0.986326</td>\n",
       "      <td>0.982164</td>\n",
       "      <td>0.982759</td>\n",
       "      <td>0.980380</td>\n",
       "      <td>0.979191</td>\n",
       "      <td>0.976813</td>\n",
       "      <td>0.981570</td>\n",
       "      <td>0.979786</td>\n",
       "      <td>0.978597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.998216</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.998216</td>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.998216</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           0         1         2         3         4         5         6  \\\n",
       "0   0.771106  0.764566  0.758026  0.772889  0.772889  0.763377  0.757432   \n",
       "1   1.000000  0.999405  1.000000  0.998811  0.999405  1.000000  0.999405   \n",
       "2   0.963734  0.961950  0.962545  0.956005  0.958383  0.959572  0.960166   \n",
       "3   0.970273  0.972652  0.967301  0.967895  0.972057  0.966706  0.976219   \n",
       "4   0.989893  0.990488  0.989298  0.989893  0.989893  0.986326  0.991677   \n",
       "5   0.989298  0.988704  0.986920  0.988109  0.988109  0.991677  0.986326   \n",
       "6   0.986326  0.987515  0.986326  0.985731  0.987515  0.985731  0.985731   \n",
       "7   0.998216  0.999405  0.997027  0.998811  0.999405  0.998216  0.998216   \n",
       "8   0.994055  0.996433  0.993460  0.991677  0.993460  0.994649  0.993460   \n",
       "9   1.000000  0.999405  0.998811  0.999405  0.998811  0.997622  0.999405   \n",
       "10  0.968490  0.967895  0.967301  0.965517  0.964328  0.962545  0.966112   \n",
       "11  0.927467  0.936385  0.933413  0.917955  0.936980  0.928062  0.929251   \n",
       "12  0.982164  0.978597  0.979786  0.983353  0.980380  0.979191  0.983948   \n",
       "13  0.998811  0.995244  0.998216  0.998216  0.995244  0.998811  0.997027   \n",
       "14  0.949465  0.956599  0.958977  0.951843  0.953032  0.957788  0.961950   \n",
       "15  0.980975  0.986326  0.982164  0.982759  0.980380  0.979191  0.976813   \n",
       "16  0.997622  0.998811  0.998811  0.997622  0.998216  0.998811  0.998216   \n",
       "\n",
       "           7         8         9  \n",
       "0   0.777646  0.760999  0.778835  \n",
       "1   0.999405  0.999405  0.998216  \n",
       "2   0.961356  0.958383  0.962545  \n",
       "3   0.970868  0.970868  0.964923  \n",
       "4   0.988109  0.991677  0.987515  \n",
       "5   0.988109  0.988704  0.988704  \n",
       "6   0.988109  0.992271  0.981570  \n",
       "7   0.999405  0.998811  0.997622  \n",
       "8   0.996433  0.997027  0.996433  \n",
       "9   0.998216  0.998811  0.999405  \n",
       "10  0.968490  0.968490  0.968490  \n",
       "11  0.938763  0.931629  0.935196  \n",
       "12  0.983948  0.980975  0.979191  \n",
       "13  0.997622  0.998811  0.999405  \n",
       "14  0.954816  0.961950  0.957194  \n",
       "15  0.981570  0.979786  0.978597  \n",
       "16  0.997622  0.997622  0.998216  "
      ]
     },
     "execution_count": 123,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_LogReg"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "27e04fd2",
   "metadata": {},
   "source": [
    "# Accuracy score of SVC model for each of the 17 class"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "id": "3fafa7f0",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_SVC = modelEvaluate('SVC', X, y_bin)[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 126,
   "id": "d6bae203",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_SVC = df_SVC.T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 127,
   "id": "d8aec6b3",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.753864</td>\n",
       "      <td>0.764566</td>\n",
       "      <td>0.771106</td>\n",
       "      <td>0.755054</td>\n",
       "      <td>0.766350</td>\n",
       "      <td>0.768728</td>\n",
       "      <td>0.739001</td>\n",
       "      <td>0.765161</td>\n",
       "      <td>0.753864</td>\n",
       "      <td>0.737218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.998216</td>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.997622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.931629</td>\n",
       "      <td>0.931629</td>\n",
       "      <td>0.931629</td>\n",
       "      <td>0.931629</td>\n",
       "      <td>0.931034</td>\n",
       "      <td>0.931034</td>\n",
       "      <td>0.931034</td>\n",
       "      <td>0.931034</td>\n",
       "      <td>0.931034</td>\n",
       "      <td>0.931034</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.960761</td>\n",
       "      <td>0.960761</td>\n",
       "      <td>0.960761</td>\n",
       "      <td>0.960761</td>\n",
       "      <td>0.960761</td>\n",
       "      <td>0.960761</td>\n",
       "      <td>0.960761</td>\n",
       "      <td>0.960761</td>\n",
       "      <td>0.960166</td>\n",
       "      <td>0.960166</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.989298</td>\n",
       "      <td>0.989298</td>\n",
       "      <td>0.989298</td>\n",
       "      <td>0.989298</td>\n",
       "      <td>0.989298</td>\n",
       "      <td>0.988704</td>\n",
       "      <td>0.988704</td>\n",
       "      <td>0.988704</td>\n",
       "      <td>0.988704</td>\n",
       "      <td>0.988704</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0.977408</td>\n",
       "      <td>0.977408</td>\n",
       "      <td>0.977408</td>\n",
       "      <td>0.977408</td>\n",
       "      <td>0.976813</td>\n",
       "      <td>0.976813</td>\n",
       "      <td>0.976813</td>\n",
       "      <td>0.976813</td>\n",
       "      <td>0.976813</td>\n",
       "      <td>0.976813</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0.964328</td>\n",
       "      <td>0.964328</td>\n",
       "      <td>0.964328</td>\n",
       "      <td>0.964328</td>\n",
       "      <td>0.964328</td>\n",
       "      <td>0.964328</td>\n",
       "      <td>0.963734</td>\n",
       "      <td>0.963734</td>\n",
       "      <td>0.963734</td>\n",
       "      <td>0.963734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.998811</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.979191</td>\n",
       "      <td>0.979191</td>\n",
       "      <td>0.978002</td>\n",
       "      <td>0.978597</td>\n",
       "      <td>0.978002</td>\n",
       "      <td>0.980380</td>\n",
       "      <td>0.978597</td>\n",
       "      <td>0.978597</td>\n",
       "      <td>0.978002</td>\n",
       "      <td>0.977408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.998811</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.953627</td>\n",
       "      <td>0.953627</td>\n",
       "      <td>0.953032</td>\n",
       "      <td>0.953032</td>\n",
       "      <td>0.953032</td>\n",
       "      <td>0.953032</td>\n",
       "      <td>0.953032</td>\n",
       "      <td>0.953032</td>\n",
       "      <td>0.953032</td>\n",
       "      <td>0.953032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0.882283</td>\n",
       "      <td>0.882283</td>\n",
       "      <td>0.882283</td>\n",
       "      <td>0.882283</td>\n",
       "      <td>0.882283</td>\n",
       "      <td>0.882283</td>\n",
       "      <td>0.882283</td>\n",
       "      <td>0.882283</td>\n",
       "      <td>0.881688</td>\n",
       "      <td>0.881688</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0.972057</td>\n",
       "      <td>0.972057</td>\n",
       "      <td>0.972057</td>\n",
       "      <td>0.972057</td>\n",
       "      <td>0.972057</td>\n",
       "      <td>0.971463</td>\n",
       "      <td>0.971463</td>\n",
       "      <td>0.971463</td>\n",
       "      <td>0.971463</td>\n",
       "      <td>0.971463</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0.989893</td>\n",
       "      <td>0.989893</td>\n",
       "      <td>0.989893</td>\n",
       "      <td>0.989893</td>\n",
       "      <td>0.989893</td>\n",
       "      <td>0.989298</td>\n",
       "      <td>0.989298</td>\n",
       "      <td>0.989298</td>\n",
       "      <td>0.989298</td>\n",
       "      <td>0.989298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0.942331</td>\n",
       "      <td>0.942331</td>\n",
       "      <td>0.941736</td>\n",
       "      <td>0.941736</td>\n",
       "      <td>0.941736</td>\n",
       "      <td>0.941736</td>\n",
       "      <td>0.941736</td>\n",
       "      <td>0.941736</td>\n",
       "      <td>0.941736</td>\n",
       "      <td>0.941736</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0.981570</td>\n",
       "      <td>0.981570</td>\n",
       "      <td>0.981570</td>\n",
       "      <td>0.981570</td>\n",
       "      <td>0.981570</td>\n",
       "      <td>0.981570</td>\n",
       "      <td>0.980975</td>\n",
       "      <td>0.980975</td>\n",
       "      <td>0.980975</td>\n",
       "      <td>0.980975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0.998216</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.997027</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.998216</td>\n",
       "      <td>0.995838</td>\n",
       "      <td>0.997027</td>\n",
       "      <td>0.995838</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           0         1         2         3         4         5         6  \\\n",
       "0   0.753864  0.764566  0.771106  0.755054  0.766350  0.768728  0.739001   \n",
       "1   0.998216  0.997622  0.997622  0.997622  0.997622  0.997622  0.997622   \n",
       "2   0.931629  0.931629  0.931629  0.931629  0.931034  0.931034  0.931034   \n",
       "3   0.960761  0.960761  0.960761  0.960761  0.960761  0.960761  0.960761   \n",
       "4   0.989298  0.989298  0.989298  0.989298  0.989298  0.988704  0.988704   \n",
       "5   0.977408  0.977408  0.977408  0.977408  0.976813  0.976813  0.976813   \n",
       "6   0.964328  0.964328  0.964328  0.964328  0.964328  0.964328  0.963734   \n",
       "7   0.999405  0.999405  0.998811  0.998811  0.998811  0.998811  0.998811   \n",
       "8   0.979191  0.979191  0.978002  0.978597  0.978002  0.980380  0.978597   \n",
       "9   0.999405  0.999405  0.999405  0.999405  0.998811  0.998811  0.998811   \n",
       "10  0.953627  0.953627  0.953032  0.953032  0.953032  0.953032  0.953032   \n",
       "11  0.882283  0.882283  0.882283  0.882283  0.882283  0.882283  0.882283   \n",
       "12  0.972057  0.972057  0.972057  0.972057  0.972057  0.971463  0.971463   \n",
       "13  0.989893  0.989893  0.989893  0.989893  0.989893  0.989298  0.989298   \n",
       "14  0.942331  0.942331  0.941736  0.941736  0.941736  0.941736  0.941736   \n",
       "15  0.981570  0.981570  0.981570  0.981570  0.981570  0.981570  0.980975   \n",
       "16  0.998216  0.998811  0.997622  0.997027  0.999405  0.997622  0.998216   \n",
       "\n",
       "           7         8         9  \n",
       "0   0.765161  0.753864  0.737218  \n",
       "1   0.997622  0.997622  0.997622  \n",
       "2   0.931034  0.931034  0.931034  \n",
       "3   0.960761  0.960166  0.960166  \n",
       "4   0.988704  0.988704  0.988704  \n",
       "5   0.976813  0.976813  0.976813  \n",
       "6   0.963734  0.963734  0.963734  \n",
       "7   0.998811  0.998811  0.998811  \n",
       "8   0.978597  0.978002  0.977408  \n",
       "9   0.998811  0.998811  0.998811  \n",
       "10  0.953032  0.953032  0.953032  \n",
       "11  0.882283  0.881688  0.881688  \n",
       "12  0.971463  0.971463  0.971463  \n",
       "13  0.989298  0.989298  0.989298  \n",
       "14  0.941736  0.941736  0.941736  \n",
       "15  0.980975  0.980975  0.980975  \n",
       "16  0.995838  0.997027  0.995838  "
      ]
     },
     "execution_count": 127,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_SVC"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0b44f87d",
   "metadata": {},
   "source": [
    "# Accuracy score of KNN model for each of the 17 class"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "id": "be4b40a6",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_KNN = modelEvaluate('KNN', X, y_bin)[2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "id": "38bedfed",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_KNN = df_KNN.T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 156,
   "id": "dd63caed",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.788347</td>\n",
       "      <td>0.797860</td>\n",
       "      <td>0.805589</td>\n",
       "      <td>0.816290</td>\n",
       "      <td>0.818074</td>\n",
       "      <td>0.802616</td>\n",
       "      <td>0.808561</td>\n",
       "      <td>0.806183</td>\n",
       "      <td>0.803210</td>\n",
       "      <td>0.817479</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.998216</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.998216</td>\n",
       "      <td>0.996433</td>\n",
       "      <td>0.998216</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.998216</td>\n",
       "      <td>0.998216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.951843</td>\n",
       "      <td>0.945303</td>\n",
       "      <td>0.950059</td>\n",
       "      <td>0.958977</td>\n",
       "      <td>0.953032</td>\n",
       "      <td>0.953627</td>\n",
       "      <td>0.945303</td>\n",
       "      <td>0.945303</td>\n",
       "      <td>0.951249</td>\n",
       "      <td>0.953032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.966706</td>\n",
       "      <td>0.969084</td>\n",
       "      <td>0.974435</td>\n",
       "      <td>0.969084</td>\n",
       "      <td>0.972652</td>\n",
       "      <td>0.972057</td>\n",
       "      <td>0.967895</td>\n",
       "      <td>0.971463</td>\n",
       "      <td>0.972652</td>\n",
       "      <td>0.969084</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.991677</td>\n",
       "      <td>0.990488</td>\n",
       "      <td>0.989298</td>\n",
       "      <td>0.989893</td>\n",
       "      <td>0.988704</td>\n",
       "      <td>0.989893</td>\n",
       "      <td>0.989298</td>\n",
       "      <td>0.989298</td>\n",
       "      <td>0.989298</td>\n",
       "      <td>0.986920</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0.987515</td>\n",
       "      <td>0.988109</td>\n",
       "      <td>0.985731</td>\n",
       "      <td>0.987515</td>\n",
       "      <td>0.990488</td>\n",
       "      <td>0.990488</td>\n",
       "      <td>0.983948</td>\n",
       "      <td>0.988704</td>\n",
       "      <td>0.988109</td>\n",
       "      <td>0.992866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0.980975</td>\n",
       "      <td>0.972652</td>\n",
       "      <td>0.979191</td>\n",
       "      <td>0.979191</td>\n",
       "      <td>0.982164</td>\n",
       "      <td>0.980975</td>\n",
       "      <td>0.983948</td>\n",
       "      <td>0.980975</td>\n",
       "      <td>0.975624</td>\n",
       "      <td>0.977408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.999405</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.998216</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.995244</td>\n",
       "      <td>0.997027</td>\n",
       "      <td>0.994649</td>\n",
       "      <td>0.992866</td>\n",
       "      <td>0.991677</td>\n",
       "      <td>0.991677</td>\n",
       "      <td>0.993460</td>\n",
       "      <td>0.993460</td>\n",
       "      <td>0.992271</td>\n",
       "      <td>0.992866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.998811</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.967301</td>\n",
       "      <td>0.972057</td>\n",
       "      <td>0.969084</td>\n",
       "      <td>0.973246</td>\n",
       "      <td>0.974435</td>\n",
       "      <td>0.964328</td>\n",
       "      <td>0.967895</td>\n",
       "      <td>0.967301</td>\n",
       "      <td>0.969679</td>\n",
       "      <td>0.963139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0.947087</td>\n",
       "      <td>0.928656</td>\n",
       "      <td>0.932818</td>\n",
       "      <td>0.932818</td>\n",
       "      <td>0.936980</td>\n",
       "      <td>0.947681</td>\n",
       "      <td>0.931629</td>\n",
       "      <td>0.936385</td>\n",
       "      <td>0.938169</td>\n",
       "      <td>0.935196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0.980975</td>\n",
       "      <td>0.976813</td>\n",
       "      <td>0.970273</td>\n",
       "      <td>0.972652</td>\n",
       "      <td>0.980380</td>\n",
       "      <td>0.975624</td>\n",
       "      <td>0.979191</td>\n",
       "      <td>0.977408</td>\n",
       "      <td>0.978002</td>\n",
       "      <td>0.978597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0.995244</td>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.996433</td>\n",
       "      <td>0.998811</td>\n",
       "      <td>0.995244</td>\n",
       "      <td>0.995244</td>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.998216</td>\n",
       "      <td>0.994055</td>\n",
       "      <td>0.995838</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0.946492</td>\n",
       "      <td>0.945898</td>\n",
       "      <td>0.946492</td>\n",
       "      <td>0.945303</td>\n",
       "      <td>0.942925</td>\n",
       "      <td>0.942331</td>\n",
       "      <td>0.954816</td>\n",
       "      <td>0.942331</td>\n",
       "      <td>0.937574</td>\n",
       "      <td>0.942331</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0.982164</td>\n",
       "      <td>0.980380</td>\n",
       "      <td>0.981570</td>\n",
       "      <td>0.982164</td>\n",
       "      <td>0.982164</td>\n",
       "      <td>0.980380</td>\n",
       "      <td>0.982759</td>\n",
       "      <td>0.980975</td>\n",
       "      <td>0.981570</td>\n",
       "      <td>0.980975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0.994055</td>\n",
       "      <td>0.998216</td>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.997027</td>\n",
       "      <td>0.999405</td>\n",
       "      <td>0.998216</td>\n",
       "      <td>0.998216</td>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.997622</td>\n",
       "      <td>0.995838</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           0         1         2         3         4         5         6  \\\n",
       "0   0.788347  0.797860  0.805589  0.816290  0.818074  0.802616  0.808561   \n",
       "1   0.997622  0.998811  0.998216  1.000000  0.998216  0.996433  0.998216   \n",
       "2   0.951843  0.945303  0.950059  0.958977  0.953032  0.953627  0.945303   \n",
       "3   0.966706  0.969084  0.974435  0.969084  0.972652  0.972057  0.967895   \n",
       "4   0.991677  0.990488  0.989298  0.989893  0.988704  0.989893  0.989298   \n",
       "5   0.987515  0.988109  0.985731  0.987515  0.990488  0.990488  0.983948   \n",
       "6   0.980975  0.972652  0.979191  0.979191  0.982164  0.980975  0.983948   \n",
       "7   0.999405  1.000000  1.000000  1.000000  0.998216  1.000000  0.998811   \n",
       "8   0.995244  0.997027  0.994649  0.992866  0.991677  0.991677  0.993460   \n",
       "9   0.999405  0.999405  0.999405  0.999405  0.998811  0.998811  0.998811   \n",
       "10  0.967301  0.972057  0.969084  0.973246  0.974435  0.964328  0.967895   \n",
       "11  0.947087  0.928656  0.932818  0.932818  0.936980  0.947681  0.931629   \n",
       "12  0.980975  0.976813  0.970273  0.972652  0.980380  0.975624  0.979191   \n",
       "13  0.995244  0.997622  0.996433  0.998811  0.995244  0.995244  0.997622   \n",
       "14  0.946492  0.945898  0.946492  0.945303  0.942925  0.942331  0.954816   \n",
       "15  0.982164  0.980380  0.981570  0.982164  0.982164  0.980380  0.982759   \n",
       "16  0.994055  0.998216  0.997622  0.997027  0.999405  0.998216  0.998216   \n",
       "\n",
       "           7         8         9  \n",
       "0   0.806183  0.803210  0.817479  \n",
       "1   0.999405  0.998216  0.998216  \n",
       "2   0.945303  0.951249  0.953032  \n",
       "3   0.971463  0.972652  0.969084  \n",
       "4   0.989298  0.989298  0.986920  \n",
       "5   0.988704  0.988109  0.992866  \n",
       "6   0.980975  0.975624  0.977408  \n",
       "7   0.999405  0.998811  1.000000  \n",
       "8   0.993460  0.992271  0.992866  \n",
       "9   0.998811  0.998811  0.998811  \n",
       "10  0.967301  0.969679  0.963139  \n",
       "11  0.936385  0.938169  0.935196  \n",
       "12  0.977408  0.978002  0.978597  \n",
       "13  0.998216  0.994055  0.995838  \n",
       "14  0.942331  0.937574  0.942331  \n",
       "15  0.980975  0.981570  0.980975  \n",
       "16  0.997622  0.997622  0.995838  "
      ]
     },
     "execution_count": 156,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_KNN"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 167,
   "id": "5a86839f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     0.767776\n",
       "1     0.999405\n",
       "2     0.960464\n",
       "3     0.969976\n",
       "4     0.989477\n",
       "5     0.988466\n",
       "6     0.986683\n",
       "7     0.998514\n",
       "8     0.994709\n",
       "9     0.998989\n",
       "10    0.966766\n",
       "11    0.931510\n",
       "12    0.981153\n",
       "13    0.997741\n",
       "14    0.956361\n",
       "15    0.980856\n",
       "16    0.998157\n",
       "dtype: float64"
      ]
     },
     "execution_count": 167,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_LogReg.T.mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 168,
   "id": "5d5ba752",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     0.757491\n",
       "1     0.997681\n",
       "2     0.931272\n",
       "3     0.960642\n",
       "4     0.989001\n",
       "5     0.977051\n",
       "6     0.964090\n",
       "7     0.998930\n",
       "8     0.978597\n",
       "9     0.999049\n",
       "10    0.953151\n",
       "11    0.882164\n",
       "12    0.971760\n",
       "13    0.989596\n",
       "14    0.941855\n",
       "15    0.981332\n",
       "16    0.997562\n",
       "dtype: float64"
      ]
     },
     "execution_count": 168,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_SVC.T.mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 169,
   "id": "34bb830d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     0.806421\n",
       "1     0.998335\n",
       "2     0.950773\n",
       "3     0.970511\n",
       "4     0.989477\n",
       "5     0.988347\n",
       "6     0.979310\n",
       "7     0.999465\n",
       "8     0.993520\n",
       "9     0.999049\n",
       "10    0.968847\n",
       "11    0.936742\n",
       "12    0.976992\n",
       "13    0.996433\n",
       "14    0.944649\n",
       "15    0.981510\n",
       "16    0.997384\n",
       "dtype: float64"
      ]
     },
     "execution_count": 169,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_KNN.T.mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "575f873c",
   "metadata": {},
   "source": [
    "### For class 0: KNN is the best model.\n",
    "### For class 1: Logistic Regression is the best model.\n",
    "### For class 2: Logistic Regression is the best model.\n",
    "### For class 3: KNN is the best model.\n",
    "### For class 4: KNN and Logistic Regression have the same score.\n",
    "### For class 5: Logistic Regression is the best model.\n",
    "### For class 6: Logistic Regression is the best model.\n",
    "### For class 7: KNN is the best model.\n",
    "### For class 8: Logistic Regression is the best model.\n",
    "### For class 9: KNN and SVC have the same.\n",
    "### For class 10: KNN is the best model.\n",
    "### For class 11: KNN is the best model.\n",
    "### For class 12: Logistic Regression is the best model.\n",
    "### For class 13: Logistic Regression is the best model.\n",
    "### For class 14: Logistic Regression is the best model.\n",
    "### For class 15: KNN is the best model.\n",
    "### For class 16: Logistic Regression is the best model.\n",
    "### According to scores Logistic Regression Model is the best model overall."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "dc767093",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "bbd76fe7",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "5c1fa486",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "a1e1f238",
   "metadata": {},
   "source": [
    "# Question 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 173,
   "id": "ed1535df",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Unnamed: 0', 'EVENTMSGACTIONTYPE', 'EVENTMSGTYPE', 'EVENTNUM',\n",
       "       'GAME_ID', 'HOMEDESCRIPTION', 'NEUTRALDESCRIPTION', 'PCTIMESTRING',\n",
       "       'PERIOD', 'PERSON1TYPE', 'PERSON2TYPE', 'PERSON3TYPE', 'PLAYER1_ID',\n",
       "       'PLAYER1_NAME', 'PLAYER1_TEAM_ABBREVIATION', 'PLAYER1_TEAM_CITY',\n",
       "       'PLAYER1_TEAM_ID', 'PLAYER1_TEAM_NICKNAME', 'PLAYER2_ID',\n",
       "       'PLAYER2_NAME', 'PLAYER2_TEAM_ABBREVIATION', 'PLAYER2_TEAM_CITY',\n",
       "       'PLAYER2_TEAM_ID', 'PLAYER2_TEAM_NICKNAME', 'PLAYER3_ID',\n",
       "       'PLAYER3_NAME', 'PLAYER3_TEAM_ABBREVIATION', 'PLAYER3_TEAM_CITY',\n",
       "       'PLAYER3_TEAM_ID', 'PLAYER3_TEAM_NICKNAME', 'SCORE', 'SCOREMARGIN',\n",
       "       'VISITORDESCRIPTION', 'WCTIMESTRING'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 173,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "NBA = pd.read_csv('https://sports-statistics.com/database/basketball-data/nba/2018-19_pbp.csv')\n",
    "NBA.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cde46e45",
   "metadata": {},
   "source": [
    "## Question 2.1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 253,
   "id": "4a0c0536",
   "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>PLAYER2_TEAM_ABBREVIATION</th>\n",
       "      <th>ATL</th>\n",
       "      <th>BKN</th>\n",
       "      <th>BOS</th>\n",
       "      <th>CHA</th>\n",
       "      <th>CHI</th>\n",
       "      <th>CLE</th>\n",
       "      <th>DAL</th>\n",
       "      <th>DEN</th>\n",
       "      <th>DET</th>\n",
       "      <th>GSW</th>\n",
       "      <th>...</th>\n",
       "      <th>OKC</th>\n",
       "      <th>ORL</th>\n",
       "      <th>PHI</th>\n",
       "      <th>PHX</th>\n",
       "      <th>POR</th>\n",
       "      <th>SAC</th>\n",
       "      <th>SAS</th>\n",
       "      <th>TOR</th>\n",
       "      <th>UTA</th>\n",
       "      <th>WAS</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PLAYER1_TEAM_ABBREVIATION</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",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ATL</th>\n",
       "      <td>4603</td>\n",
       "      <td>114</td>\n",
       "      <td>142</td>\n",
       "      <td>132</td>\n",
       "      <td>129</td>\n",
       "      <td>102</td>\n",
       "      <td>80</td>\n",
       "      <td>70</td>\n",
       "      <td>99</td>\n",
       "      <td>58</td>\n",
       "      <td>...</td>\n",
       "      <td>69</td>\n",
       "      <td>133</td>\n",
       "      <td>130</td>\n",
       "      <td>67</td>\n",
       "      <td>64</td>\n",
       "      <td>70</td>\n",
       "      <td>48</td>\n",
       "      <td>100</td>\n",
       "      <td>68</td>\n",
       "      <td>140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BKN</th>\n",
       "      <td>99</td>\n",
       "      <td>3955</td>\n",
       "      <td>118</td>\n",
       "      <td>119</td>\n",
       "      <td>100</td>\n",
       "      <td>108</td>\n",
       "      <td>69</td>\n",
       "      <td>59</td>\n",
       "      <td>97</td>\n",
       "      <td>63</td>\n",
       "      <td>...</td>\n",
       "      <td>60</td>\n",
       "      <td>76</td>\n",
       "      <td>137</td>\n",
       "      <td>52</td>\n",
       "      <td>67</td>\n",
       "      <td>57</td>\n",
       "      <td>52</td>\n",
       "      <td>130</td>\n",
       "      <td>58</td>\n",
       "      <td>113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BOS</th>\n",
       "      <td>132</td>\n",
       "      <td>112</td>\n",
       "      <td>4180</td>\n",
       "      <td>111</td>\n",
       "      <td>60</td>\n",
       "      <td>103</td>\n",
       "      <td>59</td>\n",
       "      <td>49</td>\n",
       "      <td>122</td>\n",
       "      <td>62</td>\n",
       "      <td>...</td>\n",
       "      <td>69</td>\n",
       "      <td>75</td>\n",
       "      <td>117</td>\n",
       "      <td>54</td>\n",
       "      <td>53</td>\n",
       "      <td>60</td>\n",
       "      <td>39</td>\n",
       "      <td>129</td>\n",
       "      <td>61</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHA</th>\n",
       "      <td>111</td>\n",
       "      <td>111</td>\n",
       "      <td>102</td>\n",
       "      <td>3903</td>\n",
       "      <td>76</td>\n",
       "      <td>84</td>\n",
       "      <td>55</td>\n",
       "      <td>57</td>\n",
       "      <td>104</td>\n",
       "      <td>39</td>\n",
       "      <td>...</td>\n",
       "      <td>66</td>\n",
       "      <td>93</td>\n",
       "      <td>133</td>\n",
       "      <td>63</td>\n",
       "      <td>51</td>\n",
       "      <td>48</td>\n",
       "      <td>42</td>\n",
       "      <td>67</td>\n",
       "      <td>50</td>\n",
       "      <td>117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHI</th>\n",
       "      <td>137</td>\n",
       "      <td>118</td>\n",
       "      <td>85</td>\n",
       "      <td>84</td>\n",
       "      <td>3526</td>\n",
       "      <td>107</td>\n",
       "      <td>75</td>\n",
       "      <td>59</td>\n",
       "      <td>97</td>\n",
       "      <td>57</td>\n",
       "      <td>...</td>\n",
       "      <td>85</td>\n",
       "      <td>106</td>\n",
       "      <td>107</td>\n",
       "      <td>56</td>\n",
       "      <td>48</td>\n",
       "      <td>63</td>\n",
       "      <td>43</td>\n",
       "      <td>110</td>\n",
       "      <td>49</td>\n",
       "      <td>106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CLE</th>\n",
       "      <td>94</td>\n",
       "      <td>124</td>\n",
       "      <td>114</td>\n",
       "      <td>106</td>\n",
       "      <td>97</td>\n",
       "      <td>3454</td>\n",
       "      <td>48</td>\n",
       "      <td>53</td>\n",
       "      <td>105</td>\n",
       "      <td>39</td>\n",
       "      <td>...</td>\n",
       "      <td>65</td>\n",
       "      <td>79</td>\n",
       "      <td>77</td>\n",
       "      <td>62</td>\n",
       "      <td>45</td>\n",
       "      <td>49</td>\n",
       "      <td>55</td>\n",
       "      <td>122</td>\n",
       "      <td>53</td>\n",
       "      <td>124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DAL</th>\n",
       "      <td>58</td>\n",
       "      <td>57</td>\n",
       "      <td>53</td>\n",
       "      <td>41</td>\n",
       "      <td>56</td>\n",
       "      <td>59</td>\n",
       "      <td>3880</td>\n",
       "      <td>82</td>\n",
       "      <td>58</td>\n",
       "      <td>100</td>\n",
       "      <td>...</td>\n",
       "      <td>137</td>\n",
       "      <td>45</td>\n",
       "      <td>55</td>\n",
       "      <td>122</td>\n",
       "      <td>114</td>\n",
       "      <td>85</td>\n",
       "      <td>116</td>\n",
       "      <td>64</td>\n",
       "      <td>129</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DEN</th>\n",
       "      <td>57</td>\n",
       "      <td>71</td>\n",
       "      <td>55</td>\n",
       "      <td>63</td>\n",
       "      <td>43</td>\n",
       "      <td>61</td>\n",
       "      <td>95</td>\n",
       "      <td>4122</td>\n",
       "      <td>52</td>\n",
       "      <td>106</td>\n",
       "      <td>...</td>\n",
       "      <td>132</td>\n",
       "      <td>51</td>\n",
       "      <td>56</td>\n",
       "      <td>128</td>\n",
       "      <td>111</td>\n",
       "      <td>88</td>\n",
       "      <td>115</td>\n",
       "      <td>46</td>\n",
       "      <td>136</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DET</th>\n",
       "      <td>100</td>\n",
       "      <td>96</td>\n",
       "      <td>125</td>\n",
       "      <td>111</td>\n",
       "      <td>108</td>\n",
       "      <td>129</td>\n",
       "      <td>62</td>\n",
       "      <td>56</td>\n",
       "      <td>3488</td>\n",
       "      <td>44</td>\n",
       "      <td>...</td>\n",
       "      <td>63</td>\n",
       "      <td>100</td>\n",
       "      <td>141</td>\n",
       "      <td>58</td>\n",
       "      <td>54</td>\n",
       "      <td>58</td>\n",
       "      <td>47</td>\n",
       "      <td>89</td>\n",
       "      <td>68</td>\n",
       "      <td>95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GSW</th>\n",
       "      <td>65</td>\n",
       "      <td>54</td>\n",
       "      <td>63</td>\n",
       "      <td>59</td>\n",
       "      <td>72</td>\n",
       "      <td>56</td>\n",
       "      <td>123</td>\n",
       "      <td>146</td>\n",
       "      <td>61</td>\n",
       "      <td>4247</td>\n",
       "      <td>...</td>\n",
       "      <td>100</td>\n",
       "      <td>47</td>\n",
       "      <td>61</td>\n",
       "      <td>135</td>\n",
       "      <td>114</td>\n",
       "      <td>128</td>\n",
       "      <td>74</td>\n",
       "      <td>58</td>\n",
       "      <td>87</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HOU</th>\n",
       "      <td>48</td>\n",
       "      <td>55</td>\n",
       "      <td>62</td>\n",
       "      <td>53</td>\n",
       "      <td>68</td>\n",
       "      <td>63</td>\n",
       "      <td>123</td>\n",
       "      <td>122</td>\n",
       "      <td>72</td>\n",
       "      <td>109</td>\n",
       "      <td>...</td>\n",
       "      <td>136</td>\n",
       "      <td>57</td>\n",
       "      <td>63</td>\n",
       "      <td>85</td>\n",
       "      <td>82</td>\n",
       "      <td>101</td>\n",
       "      <td>101</td>\n",
       "      <td>51</td>\n",
       "      <td>145</td>\n",
       "      <td>68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IND</th>\n",
       "      <td>130</td>\n",
       "      <td>83</td>\n",
       "      <td>96</td>\n",
       "      <td>81</td>\n",
       "      <td>97</td>\n",
       "      <td>83</td>\n",
       "      <td>63</td>\n",
       "      <td>49</td>\n",
       "      <td>110</td>\n",
       "      <td>52</td>\n",
       "      <td>...</td>\n",
       "      <td>53</td>\n",
       "      <td>96</td>\n",
       "      <td>117</td>\n",
       "      <td>47</td>\n",
       "      <td>53</td>\n",
       "      <td>64</td>\n",
       "      <td>52</td>\n",
       "      <td>90</td>\n",
       "      <td>52</td>\n",
       "      <td>139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LAC</th>\n",
       "      <td>62</td>\n",
       "      <td>63</td>\n",
       "      <td>75</td>\n",
       "      <td>63</td>\n",
       "      <td>59</td>\n",
       "      <td>62</td>\n",
       "      <td>121</td>\n",
       "      <td>134</td>\n",
       "      <td>62</td>\n",
       "      <td>148</td>\n",
       "      <td>...</td>\n",
       "      <td>140</td>\n",
       "      <td>58</td>\n",
       "      <td>72</td>\n",
       "      <td>142</td>\n",
       "      <td>101</td>\n",
       "      <td>125</td>\n",
       "      <td>121</td>\n",
       "      <td>59</td>\n",
       "      <td>106</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LAL</th>\n",
       "      <td>68</td>\n",
       "      <td>60</td>\n",
       "      <td>49</td>\n",
       "      <td>51</td>\n",
       "      <td>50</td>\n",
       "      <td>51</td>\n",
       "      <td>103</td>\n",
       "      <td>83</td>\n",
       "      <td>58</td>\n",
       "      <td>99</td>\n",
       "      <td>...</td>\n",
       "      <td>109</td>\n",
       "      <td>51</td>\n",
       "      <td>68</td>\n",
       "      <td>121</td>\n",
       "      <td>123</td>\n",
       "      <td>118</td>\n",
       "      <td>129</td>\n",
       "      <td>64</td>\n",
       "      <td>125</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MEM</th>\n",
       "      <td>66</td>\n",
       "      <td>62</td>\n",
       "      <td>59</td>\n",
       "      <td>63</td>\n",
       "      <td>52</td>\n",
       "      <td>54</td>\n",
       "      <td>120</td>\n",
       "      <td>98</td>\n",
       "      <td>68</td>\n",
       "      <td>105</td>\n",
       "      <td>...</td>\n",
       "      <td>101</td>\n",
       "      <td>60</td>\n",
       "      <td>59</td>\n",
       "      <td>81</td>\n",
       "      <td>118</td>\n",
       "      <td>137</td>\n",
       "      <td>126</td>\n",
       "      <td>62</td>\n",
       "      <td>123</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MIA</th>\n",
       "      <td>129</td>\n",
       "      <td>113</td>\n",
       "      <td>110</td>\n",
       "      <td>126</td>\n",
       "      <td>88</td>\n",
       "      <td>99</td>\n",
       "      <td>57</td>\n",
       "      <td>45</td>\n",
       "      <td>117</td>\n",
       "      <td>68</td>\n",
       "      <td>...</td>\n",
       "      <td>57</td>\n",
       "      <td>120</td>\n",
       "      <td>99</td>\n",
       "      <td>53</td>\n",
       "      <td>50</td>\n",
       "      <td>62</td>\n",
       "      <td>49</td>\n",
       "      <td>115</td>\n",
       "      <td>53</td>\n",
       "      <td>129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MIL</th>\n",
       "      <td>122</td>\n",
       "      <td>114</td>\n",
       "      <td>95</td>\n",
       "      <td>110</td>\n",
       "      <td>109</td>\n",
       "      <td>96</td>\n",
       "      <td>54</td>\n",
       "      <td>51</td>\n",
       "      <td>101</td>\n",
       "      <td>58</td>\n",
       "      <td>...</td>\n",
       "      <td>49</td>\n",
       "      <td>70</td>\n",
       "      <td>87</td>\n",
       "      <td>61</td>\n",
       "      <td>57</td>\n",
       "      <td>54</td>\n",
       "      <td>54</td>\n",
       "      <td>105</td>\n",
       "      <td>61</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MIN</th>\n",
       "      <td>64</td>\n",
       "      <td>50</td>\n",
       "      <td>56</td>\n",
       "      <td>51</td>\n",
       "      <td>52</td>\n",
       "      <td>50</td>\n",
       "      <td>93</td>\n",
       "      <td>102</td>\n",
       "      <td>59</td>\n",
       "      <td>103</td>\n",
       "      <td>...</td>\n",
       "      <td>117</td>\n",
       "      <td>52</td>\n",
       "      <td>47</td>\n",
       "      <td>86</td>\n",
       "      <td>111</td>\n",
       "      <td>131</td>\n",
       "      <td>109</td>\n",
       "      <td>54</td>\n",
       "      <td>131</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NOP</th>\n",
       "      <td>59</td>\n",
       "      <td>54</td>\n",
       "      <td>64</td>\n",
       "      <td>76</td>\n",
       "      <td>54</td>\n",
       "      <td>60</td>\n",
       "      <td>127</td>\n",
       "      <td>132</td>\n",
       "      <td>51</td>\n",
       "      <td>92</td>\n",
       "      <td>...</td>\n",
       "      <td>127</td>\n",
       "      <td>50</td>\n",
       "      <td>57</td>\n",
       "      <td>139</td>\n",
       "      <td>91</td>\n",
       "      <td>120</td>\n",
       "      <td>107</td>\n",
       "      <td>52</td>\n",
       "      <td>96</td>\n",
       "      <td>67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NYK</th>\n",
       "      <td>123</td>\n",
       "      <td>111</td>\n",
       "      <td>128</td>\n",
       "      <td>80</td>\n",
       "      <td>90</td>\n",
       "      <td>82</td>\n",
       "      <td>51</td>\n",
       "      <td>49</td>\n",
       "      <td>114</td>\n",
       "      <td>51</td>\n",
       "      <td>...</td>\n",
       "      <td>60</td>\n",
       "      <td>109</td>\n",
       "      <td>118</td>\n",
       "      <td>64</td>\n",
       "      <td>51</td>\n",
       "      <td>63</td>\n",
       "      <td>52</td>\n",
       "      <td>124</td>\n",
       "      <td>56</td>\n",
       "      <td>116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OKC</th>\n",
       "      <td>67</td>\n",
       "      <td>58</td>\n",
       "      <td>62</td>\n",
       "      <td>55</td>\n",
       "      <td>73</td>\n",
       "      <td>50</td>\n",
       "      <td>122</td>\n",
       "      <td>125</td>\n",
       "      <td>69</td>\n",
       "      <td>87</td>\n",
       "      <td>...</td>\n",
       "      <td>3671</td>\n",
       "      <td>60</td>\n",
       "      <td>59</td>\n",
       "      <td>116</td>\n",
       "      <td>133</td>\n",
       "      <td>135</td>\n",
       "      <td>81</td>\n",
       "      <td>65</td>\n",
       "      <td>145</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ORL</th>\n",
       "      <td>119</td>\n",
       "      <td>74</td>\n",
       "      <td>72</td>\n",
       "      <td>99</td>\n",
       "      <td>96</td>\n",
       "      <td>69</td>\n",
       "      <td>50</td>\n",
       "      <td>60</td>\n",
       "      <td>108</td>\n",
       "      <td>51</td>\n",
       "      <td>...</td>\n",
       "      <td>66</td>\n",
       "      <td>3951</td>\n",
       "      <td>97</td>\n",
       "      <td>50</td>\n",
       "      <td>56</td>\n",
       "      <td>59</td>\n",
       "      <td>49</td>\n",
       "      <td>96</td>\n",
       "      <td>68</td>\n",
       "      <td>104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PHI</th>\n",
       "      <td>121</td>\n",
       "      <td>126</td>\n",
       "      <td>106</td>\n",
       "      <td>137</td>\n",
       "      <td>85</td>\n",
       "      <td>81</td>\n",
       "      <td>52</td>\n",
       "      <td>46</td>\n",
       "      <td>132</td>\n",
       "      <td>73</td>\n",
       "      <td>...</td>\n",
       "      <td>62</td>\n",
       "      <td>105</td>\n",
       "      <td>4491</td>\n",
       "      <td>78</td>\n",
       "      <td>57</td>\n",
       "      <td>54</td>\n",
       "      <td>43</td>\n",
       "      <td>134</td>\n",
       "      <td>70</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PHX</th>\n",
       "      <td>67</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>67</td>\n",
       "      <td>60</td>\n",
       "      <td>57</td>\n",
       "      <td>134</td>\n",
       "      <td>134</td>\n",
       "      <td>70</td>\n",
       "      <td>133</td>\n",
       "      <td>...</td>\n",
       "      <td>155</td>\n",
       "      <td>54</td>\n",
       "      <td>87</td>\n",
       "      <td>3758</td>\n",
       "      <td>92</td>\n",
       "      <td>150</td>\n",
       "      <td>126</td>\n",
       "      <td>60</td>\n",
       "      <td>124</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>POR</th>\n",
       "      <td>49</td>\n",
       "      <td>61</td>\n",
       "      <td>46</td>\n",
       "      <td>54</td>\n",
       "      <td>47</td>\n",
       "      <td>46</td>\n",
       "      <td>127</td>\n",
       "      <td>121</td>\n",
       "      <td>51</td>\n",
       "      <td>104</td>\n",
       "      <td>...</td>\n",
       "      <td>132</td>\n",
       "      <td>49</td>\n",
       "      <td>67</td>\n",
       "      <td>101</td>\n",
       "      <td>3600</td>\n",
       "      <td>84</td>\n",
       "      <td>93</td>\n",
       "      <td>54</td>\n",
       "      <td>108</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAC</th>\n",
       "      <td>67</td>\n",
       "      <td>67</td>\n",
       "      <td>66</td>\n",
       "      <td>62</td>\n",
       "      <td>54</td>\n",
       "      <td>40</td>\n",
       "      <td>81</td>\n",
       "      <td>87</td>\n",
       "      <td>63</td>\n",
       "      <td>115</td>\n",
       "      <td>...</td>\n",
       "      <td>118</td>\n",
       "      <td>57</td>\n",
       "      <td>59</td>\n",
       "      <td>126</td>\n",
       "      <td>87</td>\n",
       "      <td>3804</td>\n",
       "      <td>74</td>\n",
       "      <td>72</td>\n",
       "      <td>145</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAS</th>\n",
       "      <td>62</td>\n",
       "      <td>46</td>\n",
       "      <td>46</td>\n",
       "      <td>53</td>\n",
       "      <td>53</td>\n",
       "      <td>53</td>\n",
       "      <td>103</td>\n",
       "      <td>91</td>\n",
       "      <td>38</td>\n",
       "      <td>78</td>\n",
       "      <td>...</td>\n",
       "      <td>91</td>\n",
       "      <td>50</td>\n",
       "      <td>42</td>\n",
       "      <td>93</td>\n",
       "      <td>91</td>\n",
       "      <td>82</td>\n",
       "      <td>4104</td>\n",
       "      <td>61</td>\n",
       "      <td>79</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TOR</th>\n",
       "      <td>93</td>\n",
       "      <td>97</td>\n",
       "      <td>109</td>\n",
       "      <td>82</td>\n",
       "      <td>112</td>\n",
       "      <td>120</td>\n",
       "      <td>61</td>\n",
       "      <td>55</td>\n",
       "      <td>97</td>\n",
       "      <td>53</td>\n",
       "      <td>...</td>\n",
       "      <td>67</td>\n",
       "      <td>104</td>\n",
       "      <td>126</td>\n",
       "      <td>63</td>\n",
       "      <td>59</td>\n",
       "      <td>60</td>\n",
       "      <td>58</td>\n",
       "      <td>3885</td>\n",
       "      <td>66</td>\n",
       "      <td>144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UTA</th>\n",
       "      <td>66</td>\n",
       "      <td>68</td>\n",
       "      <td>67</td>\n",
       "      <td>59</td>\n",
       "      <td>51</td>\n",
       "      <td>57</td>\n",
       "      <td>127</td>\n",
       "      <td>120</td>\n",
       "      <td>62</td>\n",
       "      <td>93</td>\n",
       "      <td>...</td>\n",
       "      <td>150</td>\n",
       "      <td>53</td>\n",
       "      <td>59</td>\n",
       "      <td>112</td>\n",
       "      <td>112</td>\n",
       "      <td>126</td>\n",
       "      <td>75</td>\n",
       "      <td>60</td>\n",
       "      <td>4476</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WAS</th>\n",
       "      <td>128</td>\n",
       "      <td>129</td>\n",
       "      <td>91</td>\n",
       "      <td>109</td>\n",
       "      <td>118</td>\n",
       "      <td>108</td>\n",
       "      <td>62</td>\n",
       "      <td>52</td>\n",
       "      <td>82</td>\n",
       "      <td>58</td>\n",
       "      <td>...</td>\n",
       "      <td>61</td>\n",
       "      <td>86</td>\n",
       "      <td>93</td>\n",
       "      <td>74</td>\n",
       "      <td>69</td>\n",
       "      <td>69</td>\n",
       "      <td>44</td>\n",
       "      <td>140</td>\n",
       "      <td>52</td>\n",
       "      <td>3571</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>30 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "PLAYER2_TEAM_ABBREVIATION   ATL   BKN   BOS   CHA   CHI   CLE   DAL   DEN  \\\n",
       "PLAYER1_TEAM_ABBREVIATION                                                   \n",
       "ATL                        4603   114   142   132   129   102    80    70   \n",
       "BKN                          99  3955   118   119   100   108    69    59   \n",
       "BOS                         132   112  4180   111    60   103    59    49   \n",
       "CHA                         111   111   102  3903    76    84    55    57   \n",
       "CHI                         137   118    85    84  3526   107    75    59   \n",
       "CLE                          94   124   114   106    97  3454    48    53   \n",
       "DAL                          58    57    53    41    56    59  3880    82   \n",
       "DEN                          57    71    55    63    43    61    95  4122   \n",
       "DET                         100    96   125   111   108   129    62    56   \n",
       "GSW                          65    54    63    59    72    56   123   146   \n",
       "HOU                          48    55    62    53    68    63   123   122   \n",
       "IND                         130    83    96    81    97    83    63    49   \n",
       "LAC                          62    63    75    63    59    62   121   134   \n",
       "LAL                          68    60    49    51    50    51   103    83   \n",
       "MEM                          66    62    59    63    52    54   120    98   \n",
       "MIA                         129   113   110   126    88    99    57    45   \n",
       "MIL                         122   114    95   110   109    96    54    51   \n",
       "MIN                          64    50    56    51    52    50    93   102   \n",
       "NOP                          59    54    64    76    54    60   127   132   \n",
       "NYK                         123   111   128    80    90    82    51    49   \n",
       "OKC                          67    58    62    55    73    50   122   125   \n",
       "ORL                         119    74    72    99    96    69    50    60   \n",
       "PHI                         121   126   106   137    85    81    52    46   \n",
       "PHX                          67    64    64    67    60    57   134   134   \n",
       "POR                          49    61    46    54    47    46   127   121   \n",
       "SAC                          67    67    66    62    54    40    81    87   \n",
       "SAS                          62    46    46    53    53    53   103    91   \n",
       "TOR                          93    97   109    82   112   120    61    55   \n",
       "UTA                          66    68    67    59    51    57   127   120   \n",
       "WAS                         128   129    91   109   118   108    62    52   \n",
       "\n",
       "PLAYER2_TEAM_ABBREVIATION   DET   GSW  ...   OKC   ORL   PHI   PHX   POR  \\\n",
       "PLAYER1_TEAM_ABBREVIATION              ...                                 \n",
       "ATL                          99    58  ...    69   133   130    67    64   \n",
       "BKN                          97    63  ...    60    76   137    52    67   \n",
       "BOS                         122    62  ...    69    75   117    54    53   \n",
       "CHA                         104    39  ...    66    93   133    63    51   \n",
       "CHI                          97    57  ...    85   106   107    56    48   \n",
       "CLE                         105    39  ...    65    79    77    62    45   \n",
       "DAL                          58   100  ...   137    45    55   122   114   \n",
       "DEN                          52   106  ...   132    51    56   128   111   \n",
       "DET                        3488    44  ...    63   100   141    58    54   \n",
       "GSW                          61  4247  ...   100    47    61   135   114   \n",
       "HOU                          72   109  ...   136    57    63    85    82   \n",
       "IND                         110    52  ...    53    96   117    47    53   \n",
       "LAC                          62   148  ...   140    58    72   142   101   \n",
       "LAL                          58    99  ...   109    51    68   121   123   \n",
       "MEM                          68   105  ...   101    60    59    81   118   \n",
       "MIA                         117    68  ...    57   120    99    53    50   \n",
       "MIL                         101    58  ...    49    70    87    61    57   \n",
       "MIN                          59   103  ...   117    52    47    86   111   \n",
       "NOP                          51    92  ...   127    50    57   139    91   \n",
       "NYK                         114    51  ...    60   109   118    64    51   \n",
       "OKC                          69    87  ...  3671    60    59   116   133   \n",
       "ORL                         108    51  ...    66  3951    97    50    56   \n",
       "PHI                         132    73  ...    62   105  4491    78    57   \n",
       "PHX                          70   133  ...   155    54    87  3758    92   \n",
       "POR                          51   104  ...   132    49    67   101  3600   \n",
       "SAC                          63   115  ...   118    57    59   126    87   \n",
       "SAS                          38    78  ...    91    50    42    93    91   \n",
       "TOR                          97    53  ...    67   104   126    63    59   \n",
       "UTA                          62    93  ...   150    53    59   112   112   \n",
       "WAS                          82    58  ...    61    86    93    74    69   \n",
       "\n",
       "PLAYER2_TEAM_ABBREVIATION   SAC   SAS   TOR   UTA   WAS  \n",
       "PLAYER1_TEAM_ABBREVIATION                                \n",
       "ATL                          70    48   100    68   140  \n",
       "BKN                          57    52   130    58   113  \n",
       "BOS                          60    39   129    61    72  \n",
       "CHA                          48    42    67    50   117  \n",
       "CHI                          63    43   110    49   106  \n",
       "CLE                          49    55   122    53   124  \n",
       "DAL                          85   116    64   129    53  \n",
       "DEN                          88   115    46   136    52  \n",
       "DET                          58    47    89    68    95  \n",
       "GSW                         128    74    58    87    59  \n",
       "HOU                         101   101    51   145    68  \n",
       "IND                          64    52    90    52   139  \n",
       "LAC                         125   121    59   106    73  \n",
       "LAL                         118   129    64   125    54  \n",
       "MEM                         137   126    62   123    64  \n",
       "MIA                          62    49   115    53   129  \n",
       "MIL                          54    54   105    61    80  \n",
       "MIN                         131   109    54   131    61  \n",
       "NOP                         120   107    52    96    67  \n",
       "NYK                          63    52   124    56   116  \n",
       "OKC                         135    81    65   145    54  \n",
       "ORL                          59    49    96    68   104  \n",
       "PHI                          54    43   134    70    99  \n",
       "PHX                         150   126    60   124    73  \n",
       "POR                          84    93    54   108    60  \n",
       "SAC                        3804    74    72   145    64  \n",
       "SAS                          82  4104    61    79    52  \n",
       "TOR                          60    58  3885    66   144  \n",
       "UTA                         126    75    60  4476    64  \n",
       "WAS                          69    44   140    52  3571  \n",
       "\n",
       "[30 rows x 30 columns]"
      ]
     },
     "execution_count": 253,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.crosstab(NBA['PLAYER1_TEAM_ABBREVIATION'], NBA['PLAYER2_TEAM_ABBREVIATION'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 254,
   "id": "b2cc9acb",
   "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>PLAYER3_TEAM_ABBREVIATION</th>\n",
       "      <th>ATL</th>\n",
       "      <th>BKN</th>\n",
       "      <th>BOS</th>\n",
       "      <th>CHA</th>\n",
       "      <th>CHI</th>\n",
       "      <th>CLE</th>\n",
       "      <th>DAL</th>\n",
       "      <th>DEN</th>\n",
       "      <th>DET</th>\n",
       "      <th>GSW</th>\n",
       "      <th>...</th>\n",
       "      <th>OKC</th>\n",
       "      <th>ORL</th>\n",
       "      <th>PHI</th>\n",
       "      <th>PHX</th>\n",
       "      <th>POR</th>\n",
       "      <th>SAC</th>\n",
       "      <th>SAS</th>\n",
       "      <th>TOR</th>\n",
       "      <th>UTA</th>\n",
       "      <th>WAS</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PLAYER1_TEAM_ABBREVIATION</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",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ATL</th>\n",
       "      <td>40</td>\n",
       "      <td>17</td>\n",
       "      <td>33</td>\n",
       "      <td>20</td>\n",
       "      <td>24</td>\n",
       "      <td>6</td>\n",
       "      <td>16</td>\n",
       "      <td>11</td>\n",
       "      <td>21</td>\n",
       "      <td>14</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>24</td>\n",
       "      <td>22</td>\n",
       "      <td>10</td>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>17</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BKN</th>\n",
       "      <td>14</td>\n",
       "      <td>39</td>\n",
       "      <td>34</td>\n",
       "      <td>21</td>\n",
       "      <td>25</td>\n",
       "      <td>13</td>\n",
       "      <td>6</td>\n",
       "      <td>14</td>\n",
       "      <td>15</td>\n",
       "      <td>14</td>\n",
       "      <td>...</td>\n",
       "      <td>13</td>\n",
       "      <td>25</td>\n",
       "      <td>16</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "      <td>5</td>\n",
       "      <td>9</td>\n",
       "      <td>15</td>\n",
       "      <td>14</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BOS</th>\n",
       "      <td>25</td>\n",
       "      <td>20</td>\n",
       "      <td>32</td>\n",
       "      <td>19</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>15</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>13</td>\n",
       "      <td>17</td>\n",
       "      <td>20</td>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>16</td>\n",
       "      <td>9</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHA</th>\n",
       "      <td>31</td>\n",
       "      <td>30</td>\n",
       "      <td>28</td>\n",
       "      <td>20</td>\n",
       "      <td>16</td>\n",
       "      <td>14</td>\n",
       "      <td>10</td>\n",
       "      <td>19</td>\n",
       "      <td>29</td>\n",
       "      <td>18</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>21</td>\n",
       "      <td>36</td>\n",
       "      <td>11</td>\n",
       "      <td>20</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>25</td>\n",
       "      <td>8</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHI</th>\n",
       "      <td>24</td>\n",
       "      <td>9</td>\n",
       "      <td>16</td>\n",
       "      <td>19</td>\n",
       "      <td>32</td>\n",
       "      <td>16</td>\n",
       "      <td>10</td>\n",
       "      <td>12</td>\n",
       "      <td>21</td>\n",
       "      <td>16</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>28</td>\n",
       "      <td>31</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>7</td>\n",
       "      <td>30</td>\n",
       "      <td>19</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CLE</th>\n",
       "      <td>20</td>\n",
       "      <td>26</td>\n",
       "      <td>24</td>\n",
       "      <td>25</td>\n",
       "      <td>19</td>\n",
       "      <td>27</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>23</td>\n",
       "      <td>14</td>\n",
       "      <td>...</td>\n",
       "      <td>21</td>\n",
       "      <td>13</td>\n",
       "      <td>19</td>\n",
       "      <td>18</td>\n",
       "      <td>13</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>22</td>\n",
       "      <td>15</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DAL</th>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>14</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>37</td>\n",
       "      <td>15</td>\n",
       "      <td>6</td>\n",
       "      <td>25</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "      <td>24</td>\n",
       "      <td>23</td>\n",
       "      <td>17</td>\n",
       "      <td>13</td>\n",
       "      <td>10</td>\n",
       "      <td>29</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DEN</th>\n",
       "      <td>17</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>13</td>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>27</td>\n",
       "      <td>11</td>\n",
       "      <td>33</td>\n",
       "      <td>...</td>\n",
       "      <td>22</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>26</td>\n",
       "      <td>15</td>\n",
       "      <td>12</td>\n",
       "      <td>22</td>\n",
       "      <td>9</td>\n",
       "      <td>27</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DET</th>\n",
       "      <td>15</td>\n",
       "      <td>12</td>\n",
       "      <td>18</td>\n",
       "      <td>21</td>\n",
       "      <td>19</td>\n",
       "      <td>9</td>\n",
       "      <td>12</td>\n",
       "      <td>6</td>\n",
       "      <td>51</td>\n",
       "      <td>10</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>19</td>\n",
       "      <td>30</td>\n",
       "      <td>10</td>\n",
       "      <td>9</td>\n",
       "      <td>14</td>\n",
       "      <td>12</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GSW</th>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>4</td>\n",
       "      <td>36</td>\n",
       "      <td>...</td>\n",
       "      <td>17</td>\n",
       "      <td>12</td>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>17</td>\n",
       "      <td>11</td>\n",
       "      <td>15</td>\n",
       "      <td>10</td>\n",
       "      <td>16</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HOU</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "      <td>21</td>\n",
       "      <td>13</td>\n",
       "      <td>7</td>\n",
       "      <td>26</td>\n",
       "      <td>...</td>\n",
       "      <td>24</td>\n",
       "      <td>7</td>\n",
       "      <td>18</td>\n",
       "      <td>5</td>\n",
       "      <td>11</td>\n",
       "      <td>18</td>\n",
       "      <td>26</td>\n",
       "      <td>8</td>\n",
       "      <td>23</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IND</th>\n",
       "      <td>27</td>\n",
       "      <td>15</td>\n",
       "      <td>28</td>\n",
       "      <td>11</td>\n",
       "      <td>21</td>\n",
       "      <td>12</td>\n",
       "      <td>6</td>\n",
       "      <td>13</td>\n",
       "      <td>22</td>\n",
       "      <td>15</td>\n",
       "      <td>...</td>\n",
       "      <td>13</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>8</td>\n",
       "      <td>18</td>\n",
       "      <td>16</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LAC</th>\n",
       "      <td>12</td>\n",
       "      <td>14</td>\n",
       "      <td>8</td>\n",
       "      <td>14</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>21</td>\n",
       "      <td>28</td>\n",
       "      <td>9</td>\n",
       "      <td>34</td>\n",
       "      <td>...</td>\n",
       "      <td>25</td>\n",
       "      <td>11</td>\n",
       "      <td>14</td>\n",
       "      <td>28</td>\n",
       "      <td>22</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>11</td>\n",
       "      <td>32</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LAL</th>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>17</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>24</td>\n",
       "      <td>...</td>\n",
       "      <td>17</td>\n",
       "      <td>13</td>\n",
       "      <td>9</td>\n",
       "      <td>30</td>\n",
       "      <td>36</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>10</td>\n",
       "      <td>22</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MEM</th>\n",
       "      <td>16</td>\n",
       "      <td>6</td>\n",
       "      <td>14</td>\n",
       "      <td>10</td>\n",
       "      <td>13</td>\n",
       "      <td>4</td>\n",
       "      <td>20</td>\n",
       "      <td>13</td>\n",
       "      <td>8</td>\n",
       "      <td>23</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>22</td>\n",
       "      <td>20</td>\n",
       "      <td>16</td>\n",
       "      <td>15</td>\n",
       "      <td>28</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MIA</th>\n",
       "      <td>18</td>\n",
       "      <td>15</td>\n",
       "      <td>25</td>\n",
       "      <td>27</td>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>20</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>23</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>14</td>\n",
       "      <td>9</td>\n",
       "      <td>25</td>\n",
       "      <td>10</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MIL</th>\n",
       "      <td>21</td>\n",
       "      <td>17</td>\n",
       "      <td>23</td>\n",
       "      <td>19</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>17</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>14</td>\n",
       "      <td>18</td>\n",
       "      <td>16</td>\n",
       "      <td>14</td>\n",
       "      <td>9</td>\n",
       "      <td>12</td>\n",
       "      <td>6</td>\n",
       "      <td>29</td>\n",
       "      <td>13</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MIN</th>\n",
       "      <td>13</td>\n",
       "      <td>6</td>\n",
       "      <td>13</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "      <td>20</td>\n",
       "      <td>21</td>\n",
       "      <td>6</td>\n",
       "      <td>25</td>\n",
       "      <td>...</td>\n",
       "      <td>27</td>\n",
       "      <td>14</td>\n",
       "      <td>15</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>19</td>\n",
       "      <td>20</td>\n",
       "      <td>14</td>\n",
       "      <td>28</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NOP</th>\n",
       "      <td>9</td>\n",
       "      <td>13</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "      <td>14</td>\n",
       "      <td>8</td>\n",
       "      <td>32</td>\n",
       "      <td>26</td>\n",
       "      <td>8</td>\n",
       "      <td>13</td>\n",
       "      <td>...</td>\n",
       "      <td>19</td>\n",
       "      <td>18</td>\n",
       "      <td>15</td>\n",
       "      <td>27</td>\n",
       "      <td>16</td>\n",
       "      <td>21</td>\n",
       "      <td>11</td>\n",
       "      <td>18</td>\n",
       "      <td>22</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NYK</th>\n",
       "      <td>18</td>\n",
       "      <td>22</td>\n",
       "      <td>27</td>\n",
       "      <td>20</td>\n",
       "      <td>18</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>12</td>\n",
       "      <td>24</td>\n",
       "      <td>16</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>31</td>\n",
       "      <td>29</td>\n",
       "      <td>15</td>\n",
       "      <td>11</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>22</td>\n",
       "      <td>10</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OKC</th>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>13</td>\n",
       "      <td>7</td>\n",
       "      <td>14</td>\n",
       "      <td>21</td>\n",
       "      <td>12</td>\n",
       "      <td>24</td>\n",
       "      <td>...</td>\n",
       "      <td>44</td>\n",
       "      <td>9</td>\n",
       "      <td>12</td>\n",
       "      <td>21</td>\n",
       "      <td>26</td>\n",
       "      <td>24</td>\n",
       "      <td>23</td>\n",
       "      <td>14</td>\n",
       "      <td>26</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ORL</th>\n",
       "      <td>17</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>14</td>\n",
       "      <td>16</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>18</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>31</td>\n",
       "      <td>14</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "      <td>27</td>\n",
       "      <td>8</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PHI</th>\n",
       "      <td>24</td>\n",
       "      <td>12</td>\n",
       "      <td>17</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>17</td>\n",
       "      <td>14</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>19</td>\n",
       "      <td>32</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "      <td>15</td>\n",
       "      <td>12</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PHX</th>\n",
       "      <td>15</td>\n",
       "      <td>9</td>\n",
       "      <td>23</td>\n",
       "      <td>11</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>22</td>\n",
       "      <td>17</td>\n",
       "      <td>7</td>\n",
       "      <td>29</td>\n",
       "      <td>...</td>\n",
       "      <td>25</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>26</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>17</td>\n",
       "      <td>19</td>\n",
       "      <td>25</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>POR</th>\n",
       "      <td>14</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>16</td>\n",
       "      <td>12</td>\n",
       "      <td>10</td>\n",
       "      <td>34</td>\n",
       "      <td>...</td>\n",
       "      <td>23</td>\n",
       "      <td>15</td>\n",
       "      <td>7</td>\n",
       "      <td>13</td>\n",
       "      <td>45</td>\n",
       "      <td>11</td>\n",
       "      <td>21</td>\n",
       "      <td>11</td>\n",
       "      <td>31</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAC</th>\n",
       "      <td>10</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "      <td>16</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>25</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>20</td>\n",
       "      <td>18</td>\n",
       "      <td>36</td>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "      <td>26</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAS</th>\n",
       "      <td>4</td>\n",
       "      <td>14</td>\n",
       "      <td>10</td>\n",
       "      <td>9</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "      <td>16</td>\n",
       "      <td>...</td>\n",
       "      <td>14</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>18</td>\n",
       "      <td>16</td>\n",
       "      <td>10</td>\n",
       "      <td>22</td>\n",
       "      <td>11</td>\n",
       "      <td>13</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TOR</th>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>24</td>\n",
       "      <td>12</td>\n",
       "      <td>15</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>13</td>\n",
       "      <td>16</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>29</td>\n",
       "      <td>21</td>\n",
       "      <td>13</td>\n",
       "      <td>9</td>\n",
       "      <td>13</td>\n",
       "      <td>6</td>\n",
       "      <td>26</td>\n",
       "      <td>8</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UTA</th>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>18</td>\n",
       "      <td>17</td>\n",
       "      <td>6</td>\n",
       "      <td>24</td>\n",
       "      <td>...</td>\n",
       "      <td>19</td>\n",
       "      <td>14</td>\n",
       "      <td>13</td>\n",
       "      <td>11</td>\n",
       "      <td>24</td>\n",
       "      <td>16</td>\n",
       "      <td>15</td>\n",
       "      <td>10</td>\n",
       "      <td>38</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WAS</th>\n",
       "      <td>17</td>\n",
       "      <td>13</td>\n",
       "      <td>9</td>\n",
       "      <td>27</td>\n",
       "      <td>20</td>\n",
       "      <td>16</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>20</td>\n",
       "      <td>13</td>\n",
       "      <td>16</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>32</td>\n",
       "      <td>16</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>30 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "PLAYER3_TEAM_ABBREVIATION  ATL  BKN  BOS  CHA  CHI  CLE  DAL  DEN  DET  GSW  \\\n",
       "PLAYER1_TEAM_ABBREVIATION                                                     \n",
       "ATL                         40   17   33   20   24    6   16   11   21   14   \n",
       "BKN                         14   39   34   21   25   13    6   14   15   14   \n",
       "BOS                         25   20   32   19    8    7    5   10   15   11   \n",
       "CHA                         31   30   28   20   16   14   10   19   29   18   \n",
       "CHI                         24    9   16   19   32   16   10   12   21   16   \n",
       "CLE                         20   26   24   25   19   27   10   10   23   14   \n",
       "DAL                          8    4    8   14    8    4   37   15    6   25   \n",
       "DEN                         17   15   15   13   10    6    5   27   11   33   \n",
       "DET                         15   12   18   21   19    9   12    6   51   10   \n",
       "GSW                          8    6   10   10    4    3   15   15    4   36   \n",
       "HOU                          8    8    4    9   10    6   21   13    7   26   \n",
       "IND                         27   15   28   11   21   12    6   13   22   15   \n",
       "LAC                         12   14    8   14   12    4   21   28    9   34   \n",
       "LAL                         11    9   10   10    7    4   17   14    7   24   \n",
       "MEM                         16    6   14   10   13    4   20   13    8   23   \n",
       "MIA                         18   15   25   27   11    9    2    8   20    9   \n",
       "MIL                         21   17   23   19   11   11   17    9    8   12   \n",
       "MIN                         13    6   13    8   10    6   20   21    6   25   \n",
       "NOP                          9   13   11   12   14    8   32   26    8   13   \n",
       "NYK                         18   22   27   20   18    9    3   12   24   16   \n",
       "OKC                          8   10    7    8   13    7   14   21   12   24   \n",
       "ORL                         17   11   11   14   16   10    7    8   18   12   \n",
       "PHI                         24   12   17   18   18    4    6    8   17   14   \n",
       "PHX                         15    9   23   11    7    8   22   17    7   29   \n",
       "POR                         14    9    9    7    3    6   16   12   10   34   \n",
       "SAC                         10    9    4   16   11    1   17    8    6   28   \n",
       "SAS                          4   14   10    9   14    2   14   14    6   16   \n",
       "TOR                         13   13   24   12   15    8    8    8   13   16   \n",
       "UTA                          9   11    7    5   10    4   18   17    6   24   \n",
       "WAS                         17   13    9   27   20   16    9    9    9   12   \n",
       "\n",
       "PLAYER3_TEAM_ABBREVIATION  ...  OKC  ORL  PHI  PHX  POR  SAC  SAS  TOR  UTA  \\\n",
       "PLAYER1_TEAM_ABBREVIATION  ...                                                \n",
       "ATL                        ...   11   24   22   10   12    5   17   11   10   \n",
       "BKN                        ...   13   25   16    8   15    5    9   15   14   \n",
       "BOS                        ...   13   17   20   12    5    7    9   16    9   \n",
       "CHA                        ...   12   21   36   11   20    8   12   25    8   \n",
       "CHI                        ...    9   28   31   10   10   11    7   30   19   \n",
       "CLE                        ...   21   13   19   18   13    9   11   22   15   \n",
       "DAL                        ...   16    8   15   24   23   17   13   10   29   \n",
       "DEN                        ...   22    7    8   26   15   12   22    9   27   \n",
       "DET                        ...   12   19   30   10    9   14   12    8    9   \n",
       "GSW                        ...   17   12    9   10   17   11   15   10   16   \n",
       "HOU                        ...   24    7   18    5   11   18   26    8   23   \n",
       "IND                        ...   13   23   23   12   13   13    8   18   16   \n",
       "LAC                        ...   25   11   14   28   22   26   26   11   32   \n",
       "LAL                        ...   17   13    9   30   36   19   19   10   22   \n",
       "MEM                        ...   12   10   10   11   22   20   16   15   28   \n",
       "MIA                        ...   15   23    4    5   10   14    9   25   10   \n",
       "MIL                        ...   14   18   16   14    9   12    6   29   13   \n",
       "MIN                        ...   27   14   15   21   21   19   20   14   28   \n",
       "NOP                        ...   19   18   15   27   16   21   11   18   22   \n",
       "NYK                        ...   10   31   29   15   11    6   10   22   10   \n",
       "OKC                        ...   44    9   12   21   26   24   23   14   26   \n",
       "ORL                        ...   10   31   14   10    8   11   10   27    8   \n",
       "PHI                        ...   11   19   32    9    9    4   15   12    6   \n",
       "PHX                        ...   25    7    5   26   23   23   17   19   25   \n",
       "POR                        ...   23   15    7   13   45   11   21   11   31   \n",
       "SAC                        ...   25    9   11   20   18   36   11    9   26   \n",
       "SAS                        ...   14    9   11   18   16   10   22   11   13   \n",
       "TOR                        ...    9   29   21   13    9   13    6   26    8   \n",
       "UTA                        ...   19   14   13   11   24   16   15   10   38   \n",
       "WAS                        ...   11   20   13   16    7    7    9   32   16   \n",
       "\n",
       "PLAYER3_TEAM_ABBREVIATION  WAS  \n",
       "PLAYER1_TEAM_ABBREVIATION       \n",
       "ATL                         16  \n",
       "BKN                         15  \n",
       "BOS                         13  \n",
       "CHA                         23  \n",
       "CHI                         30  \n",
       "CLE                         14  \n",
       "DAL                          8  \n",
       "DEN                          8  \n",
       "DET                         16  \n",
       "GSW                          3  \n",
       "HOU                         10  \n",
       "IND                         13  \n",
       "LAC                         12  \n",
       "LAL                          9  \n",
       "MEM                         14  \n",
       "MIA                         25  \n",
       "MIL                         15  \n",
       "MIN                         11  \n",
       "NOP                         11  \n",
       "NYK                         28  \n",
       "OKC                         13  \n",
       "ORL                         16  \n",
       "PHI                          9  \n",
       "PHX                          9  \n",
       "POR                         16  \n",
       "SAC                          8  \n",
       "SAS                          5  \n",
       "TOR                         26  \n",
       "UTA                          5  \n",
       "WAS                         40  \n",
       "\n",
       "[30 rows x 30 columns]"
      ]
     },
     "execution_count": 254,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.crosstab(NBA['PLAYER1_TEAM_ABBREVIATION'], NBA['PLAYER3_TEAM_ABBREVIATION'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 251,
   "id": "95d1550b",
   "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>PLAYER3_TEAM_ABBREVIATION</th>\n",
       "      <th>ATL</th>\n",
       "      <th>BKN</th>\n",
       "      <th>BOS</th>\n",
       "      <th>CHA</th>\n",
       "      <th>CHI</th>\n",
       "      <th>CLE</th>\n",
       "      <th>DAL</th>\n",
       "      <th>DEN</th>\n",
       "      <th>DET</th>\n",
       "      <th>GSW</th>\n",
       "      <th>...</th>\n",
       "      <th>OKC</th>\n",
       "      <th>ORL</th>\n",
       "      <th>PHI</th>\n",
       "      <th>PHX</th>\n",
       "      <th>POR</th>\n",
       "      <th>SAC</th>\n",
       "      <th>SAS</th>\n",
       "      <th>TOR</th>\n",
       "      <th>UTA</th>\n",
       "      <th>WAS</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PLAYER2_TEAM_ABBREVIATION</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",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ATL</th>\n",
       "      <td>27</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BKN</th>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BOS</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHA</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHI</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>36</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CLE</th>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DAL</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DEN</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DET</th>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GSW</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>36</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HOU</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IND</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LAC</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LAL</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MEM</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MIA</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MIL</th>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MIN</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NOP</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NYK</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OKC</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>44</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ORL</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PHI</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PHX</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>POR</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAC</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAS</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TOR</th>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UTA</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WAS</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>30 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "PLAYER3_TEAM_ABBREVIATION  ATL  BKN  BOS  CHA  CHI  CLE  DAL  DEN  DET  GSW  \\\n",
       "PLAYER2_TEAM_ABBREVIATION                                                     \n",
       "ATL                         27    2    2    0    3    3    2    0    2    0   \n",
       "BKN                          0   36    0    0    1    4    1    0    1    1   \n",
       "BOS                          3    2   35    0    2    1    2    0    3    0   \n",
       "CHA                          4    5    1   24    1    1    0    1    2    1   \n",
       "CHI                          4    1    0    2   36    1    0    0    3    1   \n",
       "CLE                          0    3    1    2    2   22    1    1    3    2   \n",
       "DAL                          0    1    1    0    0    0   28    1    1    1   \n",
       "DEN                          1    2    0    2    1    0    0   28    1    3   \n",
       "DET                          0    2    1    1    0    1    0    0   37    0   \n",
       "GSW                          1    1    1    1    0    0    2    1    1   36   \n",
       "HOU                          0    0    1    0    1    0    1    1    3    2   \n",
       "IND                          1    1    2    0    3    1    0    0    2    1   \n",
       "LAC                          0    1    1    2    1    0    2    1    0    0   \n",
       "LAL                          1    1    0    0    1    1    1    0    0    2   \n",
       "MEM                          1    2    1    1    1    0    2    1    1    1   \n",
       "MIA                          4    1    1    0    1    1    0    1    5    0   \n",
       "MIL                          1    3    1    1    1    1    2    1    2    0   \n",
       "MIN                          0    0    2    0    0    0    2    3    1    2   \n",
       "NOP                          1    0    0    0    1    0    1    1    1    2   \n",
       "NYK                          2    1    3    2    0    5    1    1    2    1   \n",
       "OKC                          0    0    1    0    1    1    1    2    2    4   \n",
       "ORL                          3    1    3    1    2    1    1    0    2    0   \n",
       "PHI                          1    0    2    0    0    0    0    1    1    2   \n",
       "PHX                          2    1    1    1    1    1    0    1    1    2   \n",
       "POR                          2    0    1    0    1    0    5    1    1    1   \n",
       "SAC                          2    2    0    1    1    0    2    1    1    4   \n",
       "SAS                          0    1    0    1    1    1    3    3    2    1   \n",
       "TOR                          1    4    2    0    1    1    2    2    3    0   \n",
       "UTA                          1    0    1    1    1    0    2    1    1    0   \n",
       "WAS                          4    1    2    1    3    2    1    1    3    2   \n",
       "\n",
       "PLAYER3_TEAM_ABBREVIATION  ...  OKC  ORL  PHI  PHX  POR  SAC  SAS  TOR  UTA  \\\n",
       "PLAYER2_TEAM_ABBREVIATION  ...                                                \n",
       "ATL                        ...    1    2    2    0    3    0    1    0    1   \n",
       "BKN                        ...    0    0    2    1    0    1    0    0    0   \n",
       "BOS                        ...    1    0    1    1    1    1    1    1    1   \n",
       "CHA                        ...    1    3    3    0    1    1    1    2    1   \n",
       "CHI                        ...    3    1    1    0    1    0    0    1    2   \n",
       "CLE                        ...    0    1    1    0    1    1    1    0    1   \n",
       "DAL                        ...    1    1    1    0    2    2    3    1    0   \n",
       "DEN                        ...    3    1    0    3    1    1    1    0    4   \n",
       "DET                        ...    0    1    1    0    0    1    0    0    1   \n",
       "GSW                        ...    0    1    1    1    1    0    1    2    2   \n",
       "HOU                        ...    4    0    3    2    3    1    1    1    2   \n",
       "IND                        ...    2    2    4    1    1    1    1    1    1   \n",
       "LAC                        ...    2    1    0    2    3    1    1    1    2   \n",
       "LAL                        ...    1    1    0    0    3    1    0    1    0   \n",
       "MEM                        ...    4    2    1    2    2    3    1    0    1   \n",
       "MIA                        ...    1    2    1    1    1    0    0    2    1   \n",
       "MIL                        ...    1    1    0    0    0    4    1    1    0   \n",
       "MIN                        ...    2    1    1    0    3    1    0    1    2   \n",
       "NOP                        ...    1    0    1    2    1    3    2    0    1   \n",
       "NYK                        ...    1    4    2    1    1    1    1    1    1   \n",
       "OKC                        ...   44    1    0    1    2    3    1    0    3   \n",
       "ORL                        ...    1   28    1    2    2    1    0    2    1   \n",
       "PHI                        ...    1    1   34    1    2    1    0    3    0   \n",
       "PHX                        ...    3    1    0   20    1    2    1    0    2   \n",
       "POR                        ...    1    0    0    1   37    0    1    1    2   \n",
       "SAC                        ...    1    2    1    1    1   23    1    0    3   \n",
       "SAS                        ...    1    0    1    2    4    2   19    1    2   \n",
       "TOR                        ...    2    0    1    1    0    1    1   34    0   \n",
       "UTA                        ...    3    1    0    0    2    1    0    1   36   \n",
       "WAS                        ...    2    0    2    0    2    1    0    2    1   \n",
       "\n",
       "PLAYER3_TEAM_ABBREVIATION  WAS  \n",
       "PLAYER2_TEAM_ABBREVIATION       \n",
       "ATL                          3  \n",
       "BKN                          1  \n",
       "BOS                          1  \n",
       "CHA                          2  \n",
       "CHI                          3  \n",
       "CLE                          4  \n",
       "DAL                          0  \n",
       "DEN                          1  \n",
       "DET                          3  \n",
       "GSW                          0  \n",
       "HOU                          2  \n",
       "IND                          1  \n",
       "LAC                          1  \n",
       "LAL                          0  \n",
       "MEM                          1  \n",
       "MIA                          1  \n",
       "MIL                          2  \n",
       "MIN                          1  \n",
       "NOP                          1  \n",
       "NYK                          1  \n",
       "OKC                          0  \n",
       "ORL                          3  \n",
       "PHI                          0  \n",
       "PHX                          3  \n",
       "POR                          2  \n",
       "SAC                          1  \n",
       "SAS                          0  \n",
       "TOR                          2  \n",
       "UTA                          0  \n",
       "WAS                         22  \n",
       "\n",
       "[30 rows x 30 columns]"
      ]
     },
     "execution_count": 251,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.crosstab(NBA['PLAYER2_TEAM_ABBREVIATION'], NBA['PLAYER3_TEAM_ABBREVIATION'])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "97965ac1",
   "metadata": {},
   "source": [
    "## Question 2.4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 264,
   "id": "da5f4018",
   "metadata": {},
   "outputs": [],
   "source": [
    "mat_1 = pd.crosstab(NBA['PLAYER1_NAME'], NBA['PLAYER2_NAME'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 265,
   "id": "d41ac12f",
   "metadata": {},
   "outputs": [],
   "source": [
    "mat_2 = pd.crosstab(NBA['PLAYER1_NAME'], NBA['PLAYER3_NAME'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 266,
   "id": "8223cde7",
   "metadata": {},
   "outputs": [],
   "source": [
    "mat_3 = pd.crosstab(NBA['PLAYER2_NAME'], NBA['PLAYER3_NAME'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0f14422e",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.10.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}