Anwendung.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import xgboost as xgb\n",
    "from sklearn.preprocessing import StandardScaler\n",
    "from sklearn.datasets import make_classification\n",
    "from sklearn.model_selection import train_test_split\n",
    "from matplotlib import pyplot as plt\n",
    "from sklearn.preprocessing import OneHotEncoder\n",
    "from sklearn.compose import ColumnTransformer\n",
    "from sklearn.pipeline import Pipeline\n",
    "from datetime import datetime, timedelta\n",
    "from sklearn.metrics import accuracy_score\n",
    "from sklearn.metrics import confusion_matrix, classification_report\n",
    "import numpy as np\n",
    "from sklearn.metrics import mean_absolute_error\n",
    "from sklearn.metrics import accuracy_score, precision_score, recall_score, f1_score, roc_auc_score, confusion_matrix\n",
    "import pickle"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Datensatz laden"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "play_data = pd.read_csv(\n",
    "    'data_final.1.csv'\n",
    ")"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Aufteilung in Trainings-, Validierungs- und Testdatensatz"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "unique_game_ids = play_data['GameID'].unique()\n",
    "\n",
    "train_game_ids, remaining_game_ids = train_test_split(unique_game_ids, test_size=0.2, random_state=42)\n",
    "train_game_ids, valid_game_ids = train_test_split(train_game_ids, test_size=0.2, random_state=42)\n",
    "test_game_ids =remaining_game_ids\n",
    "\n",
    "\n",
    "train_df = play_data[play_data['GameID'].isin(train_game_ids)]\n",
    "valid_df = play_data[play_data['GameID'].isin(valid_game_ids)]\n",
    "test_df = play_data[play_data['GameID'].isin(test_game_ids)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Keine gemeinsamen GameIDs zwischen train_df, valid_df und test_df.\n"
     ]
    }
   ],
   "source": [
    "train_game_ids = set(train_df['GameID'])\n",
    "valid_game_ids = set(valid_df['GameID'])\n",
    "test_game_ids = set(test_df['GameID'])\n",
    "\n",
    "intersection_train_valid = train_game_ids.intersection(valid_game_ids)\n",
    "intersection_train_test = train_game_ids.intersection(test_game_ids)\n",
    "intersection_valid_test = valid_game_ids.intersection(test_game_ids)\n",
    "\n",
    "if len(intersection_train_valid) == 0 and len(intersection_train_test) == 0 and len(intersection_valid_test) == 0:\n",
    "    print(\"Keine gemeinsamen GameIDs zwischen train_df, valid_df und test_df.\")\n",
    "else:\n",
    "    print(\"Es gibt gemeinsame GameIDs zwischen train_df, valid_df und test_df.\")"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Laden des XGBoost-Modells"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Es kann auch der Random Forest zur Anwendung angwendet werden, hierzu muss der Code unten angepasst werden\n",
    "#rf_filename = \"RandomForest_final.pkl\"\n",
    "#with open(rf_filename, 'rb') as file:\n",
    "    #rf_model = pickle.load(file)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "xgb_filename = \"/Users/michelbauer/Downloads/xgbAll_final.pkl\"\n",
    "with open(xgb_filename, 'rb') as file:\n",
    "    xgb_model = pickle.load(file)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "y_train_xgb = train_df['Winner']\n",
    "y_valid_xgb = valid_df['Winner']\n",
    "y_test_xgb = test_df['Winner']\n",
    "X_train_xgb = train_df.drop('Winner', axis=1)\n",
    "X_valid_xgb = valid_df.drop('Winner', axis=1)\n",
    "X_test_xgb = test_df.drop('Winner', axis=1)\n",
    "\n",
    "\n",
    "y_valid_xgb = y_valid_xgb.astype(int)\n",
    "y_train_xgb = y_train_xgb.astype(int)\n",
    "y_test_xgb = y_test_xgb.astype(int)\n",
    "cardinality_cols = ['GameID','type_text', 'team_play', 'start_down', 'end_down', 'season', 'week', 'Home_teamname', 'Away_teamname', 'leading_Team']\n",
    "numerical_cols = ['scoring_game','point_difference','awayScore', 'homeScore', 'scoreValue', 'statYardage', 'quarter', 'clock', 'start_distance', 'start_yardlinie', 'start_yardsToEndzone', 'end_distance', 'end_yardlinie', 'end_yardsToEndzone', 'elo_score_away', 'elo_score_home', 'attendence', 'time_remaining']\n",
    "\n",
    "\n",
    "scaler = StandardScaler()\n",
    "X_train_numerical_xgb = scaler.fit_transform(X_train_xgb[numerical_cols])\n",
    "X_valid_numerical_xgb = scaler.transform(X_valid_xgb[numerical_cols])\n",
    "X_test_numerical_xgb = scaler.transform(X_test_xgb[numerical_cols])\n",
    "\n",
    "encoder = OneHotEncoder(handle_unknown='ignore')\n",
    "X_train_categorical_xgb = encoder.fit_transform(X_train_xgb[cardinality_cols]).toarray()\n",
    "X_valid_categorical_xgb = encoder.transform(X_valid_xgb[cardinality_cols]).toarray()\n",
    "X_test_categorical_xgb = encoder.transform(X_test_xgb[cardinality_cols]).toarray()\n",
    "\n",
    "\n",
    "X_train_processed_xgb = np.concatenate([X_train_numerical_xgb, X_train_categorical_xgb], axis=1)\n",
    "X_valid_processed_xgb = np.concatenate([X_valid_numerical_xgb, X_valid_categorical_xgb], axis=1)\n",
    "X_test_processed_xgb = np.concatenate([X_test_numerical_xgb, X_test_categorical_xgb], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "Test Set Metrics:\n",
      "Accuracy: 0.7438023533400195\n",
      "Precision: 0.7373444651440926\n",
      "Recall: 0.8267742933773468\n",
      "F1 Score: 0.7795027657893138\n",
      "AUC: 0.7350443912774856\n",
      "Confusion Matrix:\n",
      " [[20597, 11420],\n",
      " [ 6717, 32059]]\n"
     ]
    }
   ],
   "source": [
    "preds_test_xgb = xgb_model.predict(X_test_processed_xgb)\n",
    "\n",
    "\n",
    "accuracy_test_xgb = accuracy_score(y_test_xgb, preds_test_xgb)\n",
    "precision_test_xgb = precision_score(y_test_xgb, preds_test_xgb)\n",
    "recall_test_xgb = recall_score(y_test_xgb, preds_test_xgb)\n",
    "f1_test_xgb = f1_score(y_test_xgb, preds_test_xgb)\n",
    "auc_test_xgb = roc_auc_score(y_test_xgb, preds_test_xgb)\n",
    "cm_test_xgb = confusion_matrix(y_test_xgb, preds_test_xgb)\n",
    "cm_str_test_xgb = np.array2string(cm_test_xgb, separator=', ')\n",
    "\n",
    "\n",
    "print(\"\\nTest Set Metrics:\")\n",
    "print(\"Accuracy:\", accuracy_test_xgb)\n",
    "print(\"Precision:\", precision_test_xgb)\n",
    "print(\"Recall:\", recall_test_xgb)\n",
    "print(\"F1 Score:\", f1_test_xgb)\n",
    "print(\"AUC:\", auc_test_xgb)\n",
    "print(\"Confusion Matrix:\\n\", cm_str_test_xgb)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Das XGBoost Modell anwenden"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.concat([X_train_xgb, X_valid_xgb,X_test_xgb], ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "data=data.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_processed=np.concatenate((X_train_processed_xgb, X_valid_processed_xgb, X_test_processed_xgb), axis=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "preds_wshl_xgb= xgb_model.predict_proba(data_processed)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "preds_game=preds_wshl_xgb[(data['GameID']==\t401437834)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>GameID</th>\n",
       "      <th>playID</th>\n",
       "      <th>awayScore</th>\n",
       "      <th>homeScore</th>\n",
       "      <th>scoreValue</th>\n",
       "      <th>statYardage</th>\n",
       "      <th>quarter</th>\n",
       "      <th>clock</th>\n",
       "      <th>type_text</th>\n",
       "      <th>team_play</th>\n",
       "      <th>...</th>\n",
       "      <th>week</th>\n",
       "      <th>Home_teamname</th>\n",
       "      <th>Away_teamname</th>\n",
       "      <th>elo_score_away</th>\n",
       "      <th>elo_score_home</th>\n",
       "      <th>attendence</th>\n",
       "      <th>time_remaining</th>\n",
       "      <th>leading_Team</th>\n",
       "      <th>point_difference</th>\n",
       "      <th>scoring_game</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>216225</th>\n",
       "      <td>401437834</td>\n",
       "      <td>40143783441</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>Kickoff</td>\n",
       "      <td>det</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>chi</td>\n",
       "      <td>det</td>\n",
       "      <td>1404.406</td>\n",
       "      <td>1431.96</td>\n",
       "      <td>1.005154</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>tie</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216226</th>\n",
       "      <td>401437834</td>\n",
       "      <td>40143783456</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>Rush</td>\n",
       "      <td>chi</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>chi</td>\n",
       "      <td>det</td>\n",
       "      <td>1404.406</td>\n",
       "      <td>1431.96</td>\n",
       "      <td>1.005154</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>tie</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216227</th>\n",
       "      <td>401437834</td>\n",
       "      <td>40143783482</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>14.450000</td>\n",
       "      <td>Rush</td>\n",
       "      <td>chi</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>chi</td>\n",
       "      <td>det</td>\n",
       "      <td>1404.406</td>\n",
       "      <td>1431.96</td>\n",
       "      <td>1.005154</td>\n",
       "      <td>59.450000</td>\n",
       "      <td>tie</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216228</th>\n",
       "      <td>401437834</td>\n",
       "      <td>401437834103</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>13.766667</td>\n",
       "      <td>Rush</td>\n",
       "      <td>chi</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>chi</td>\n",
       "      <td>det</td>\n",
       "      <td>1404.406</td>\n",
       "      <td>1431.96</td>\n",
       "      <td>1.005154</td>\n",
       "      <td>58.766667</td>\n",
       "      <td>tie</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216229</th>\n",
       "      <td>401437834</td>\n",
       "      <td>401437834129</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>13.133333</td>\n",
       "      <td>Rush</td>\n",
       "      <td>chi</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>chi</td>\n",
       "      <td>det</td>\n",
       "      <td>1404.406</td>\n",
       "      <td>1431.96</td>\n",
       "      <td>1.005154</td>\n",
       "      <td>58.133333</td>\n",
       "      <td>tie</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216390</th>\n",
       "      <td>401437834</td>\n",
       "      <td>4014378343793</td>\n",
       "      <td>31</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>-3</td>\n",
       "      <td>4</td>\n",
       "      <td>0.983333</td>\n",
       "      <td>Rush</td>\n",
       "      <td>det</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>chi</td>\n",
       "      <td>det</td>\n",
       "      <td>1404.406</td>\n",
       "      <td>1431.96</td>\n",
       "      <td>1.005154</td>\n",
       "      <td>0.983333</td>\n",
       "      <td>det</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216391</th>\n",
       "      <td>401437834</td>\n",
       "      <td>4014378343816</td>\n",
       "      <td>31</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0.933333</td>\n",
       "      <td>Timeout</td>\n",
       "      <td>det</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>chi</td>\n",
       "      <td>det</td>\n",
       "      <td>1404.406</td>\n",
       "      <td>1431.96</td>\n",
       "      <td>1.005154</td>\n",
       "      <td>0.933333</td>\n",
       "      <td>det</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216392</th>\n",
       "      <td>401437834</td>\n",
       "      <td>4014378343823</td>\n",
       "      <td>31</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>0.933333</td>\n",
       "      <td>Rush</td>\n",
       "      <td>det</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>chi</td>\n",
       "      <td>det</td>\n",
       "      <td>1404.406</td>\n",
       "      <td>1431.96</td>\n",
       "      <td>1.005154</td>\n",
       "      <td>0.933333</td>\n",
       "      <td>det</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216393</th>\n",
       "      <td>401437834</td>\n",
       "      <td>4014378343846</td>\n",
       "      <td>31</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>-1</td>\n",
       "      <td>4</td>\n",
       "      <td>0.266667</td>\n",
       "      <td>Rush</td>\n",
       "      <td>det</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>chi</td>\n",
       "      <td>det</td>\n",
       "      <td>1404.406</td>\n",
       "      <td>1431.96</td>\n",
       "      <td>1.005154</td>\n",
       "      <td>0.266667</td>\n",
       "      <td>det</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216394</th>\n",
       "      <td>401437834</td>\n",
       "      <td>4014378343867</td>\n",
       "      <td>31</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>End of Game</td>\n",
       "      <td>NoTeam</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>chi</td>\n",
       "      <td>det</td>\n",
       "      <td>1404.406</td>\n",
       "      <td>1431.96</td>\n",
       "      <td>1.005154</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>det</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>170 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           GameID         playID  awayScore  homeScore  scoreValue  \\\n",
       "216225  401437834    40143783441          0          0           0   \n",
       "216226  401437834    40143783456          0          0           0   \n",
       "216227  401437834    40143783482          0          0           0   \n",
       "216228  401437834   401437834103          0          0           0   \n",
       "216229  401437834   401437834129          0          0           0   \n",
       "...           ...            ...        ...        ...         ...   \n",
       "216390  401437834  4014378343793         31         30           0   \n",
       "216391  401437834  4014378343816         31         30           0   \n",
       "216392  401437834  4014378343823         31         30           0   \n",
       "216393  401437834  4014378343846         31         30           0   \n",
       "216394  401437834  4014378343867         31         30           0   \n",
       "\n",
       "        statYardage  quarter      clock    type_text team_play  ...  week  \\\n",
       "216225            0        1  15.000000      Kickoff       det  ...    10   \n",
       "216226           28        1  15.000000         Rush       chi  ...    10   \n",
       "216227            9        1  14.450000         Rush       chi  ...    10   \n",
       "216228           13        1  13.766667         Rush       chi  ...    10   \n",
       "216229           10        1  13.133333         Rush       chi  ...    10   \n",
       "...             ...      ...        ...          ...       ...  ...   ...   \n",
       "216390           -3        4   0.983333         Rush       det  ...    10   \n",
       "216391            0        4   0.933333      Timeout       det  ...    10   \n",
       "216392            7        4   0.933333         Rush       det  ...    10   \n",
       "216393           -1        4   0.266667         Rush       det  ...    10   \n",
       "216394            0        4   0.000000  End of Game    NoTeam  ...    10   \n",
       "\n",
       "        Home_teamname  Away_teamname  elo_score_away  elo_score_home  \\\n",
       "216225            chi            det        1404.406         1431.96   \n",
       "216226            chi            det        1404.406         1431.96   \n",
       "216227            chi            det        1404.406         1431.96   \n",
       "216228            chi            det        1404.406         1431.96   \n",
       "216229            chi            det        1404.406         1431.96   \n",
       "...               ...            ...             ...             ...   \n",
       "216390            chi            det        1404.406         1431.96   \n",
       "216391            chi            det        1404.406         1431.96   \n",
       "216392            chi            det        1404.406         1431.96   \n",
       "216393            chi            det        1404.406         1431.96   \n",
       "216394            chi            det        1404.406         1431.96   \n",
       "\n",
       "        attendence  time_remaining  leading_Team  point_difference  \\\n",
       "216225    1.005154       60.000000           tie               0.0   \n",
       "216226    1.005154       60.000000           tie               0.0   \n",
       "216227    1.005154       59.450000           tie               0.0   \n",
       "216228    1.005154       58.766667           tie               0.0   \n",
       "216229    1.005154       58.133333           tie               0.0   \n",
       "...            ...             ...           ...               ...   \n",
       "216390    1.005154        0.983333           det               1.0   \n",
       "216391    1.005154        0.933333           det               1.0   \n",
       "216392    1.005154        0.933333           det               1.0   \n",
       "216393    1.005154        0.266667           det               1.0   \n",
       "216394    1.005154        0.000000           det               1.0   \n",
       "\n",
       "        scoring_game  \n",
       "216225             1  \n",
       "216226             1  \n",
       "216227             1  \n",
       "216228             1  \n",
       "216229             1  \n",
       "...              ...  \n",
       "216390             1  \n",
       "216391             1  \n",
       "216392             1  \n",
       "216393             1  \n",
       "216394             1  \n",
       "\n",
       "[170 rows x 29 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[(data['GameID']==401437834)]"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Die Gewinnwahrscheinlichkeiten während des Spiles plotten"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAj0AAAGwCAYAAABCV9SaAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjYuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/P9b71AAAACXBIWXMAAA9hAAAPYQGoP6dpAABkl0lEQVR4nO3deVhUZfsH8O/MsO8gyqIorrkEaPhKVJYLhdbrklZm/lIptVSyIsvMkrQ3Kc2len01zaU9W8wWCy0US0UtFZc0XFIxZVNkl23m/P4YZmBkcQbP4ZyZ+X6uay7hzDMz94zDcHPfz/MclSAIAoiIiIhsnFruAIiIiIhaApMeIiIisgtMeoiIiMguMOkhIiIiu8Ckh4iIiOwCkx4iIiKyC0x6iIiIyC44yB1AS9PpdLh48SI8PT2hUqnkDoeIiIjMIAgCiouLERwcDLW6eTUbu0t6Ll68iJCQELnDICIiomY4f/482rVr16zb2l3S4+npCUD/onl5eckcDREREZmjqKgIISEhxt/jzWF3SY+hpeXl5cWkh4iIyMrcyNQUTmQmIiIiu8Ckh4iIiOwCkx4iIiKyC3Y3p8dcWq0WVVVVcodB1CxOTk7NXtJJRGSrmPRcQxAEZGdno6CgQO5QiJpNrVajY8eOcHJykjsUIiLFYNJzDUPC06ZNG7i5uXEDQ7I6hg04s7Ky0L59e76HiYhqMOmpQ6vVGhOeVq1ayR0OUbO1bt0aFy9eRHV1NRwdHeUOh4hIEdj0r8Mwh8fNzU3mSIhujKGtpdVqZY6EiEg5mPQ0gO0AsnZ8DxMR1cekh4iIiOwCkx4iIiKyC0x6SHIqlQqbNm0S9T5fffVV9O7dW9T7JCIi28bVWzZi4sSJ+OCDDwAADg4O8PPzQ3h4OMaOHYuJEydatFHdq6++ik2bNiE9PV2U2LKysuDr6wsAOHv2LDp27IiDBw82mbRcb9zMmTPx1FNPiRIfkdIUlBegsLxQ7jBEF+wZDEcNVxOSfJj02JAhQ4Zg3bp10Gq1yMnJQXJyMp5++ml89dVX+O677+DgIO5/d1VVlVnLoQMDA0V9XADw8PCAh4eH6PdLJLe082m4c/2dqNZVyx2K6Hr498CRqUegUWvkDoXsFNtb1yEIQGmpPBdBsCxWZ2dnBAYGom3btrjlllvw0ksv4dtvv8VPP/2E9evXG8cVFBRg0qRJaN26Nby8vDBo0CAcOnQIALB+/XrMmzcPhw4dgkqlgkqlMt5WpVJhxYoVGD58ONzd3fH6668DAFasWIHOnTvDyckJN910Ez766COTuOq2tzp27AgA6NOnD1QqFQYMGGDx/wlQv72l0+kwf/58tGvXDs7OzujduzeSk5ON1589exYqlQobN27EwIED4ebmhoiICKSlpRnHnDt3DsOGDYOvry/c3d3Rq1cv/Pjjj82Kj6i59l3Yh2pdNdQqNVwcXGzmAgDHLx3HpbJLMr/CZM9Y6bmOsjJAroJCSQng7n5j9zFo0CBERERg48aNmDRpEgDgwQcfhKurK3766Sd4e3vjvffew+DBg3HixAmMGTMGR48eRXJyMn755RcAgLe3t/H+Xn31VbzxxhtYtmwZHBwc8M033+Dpp5/GsmXLEBMTgx9++AFxcXFo164dBg4cWC+effv2oV+/fvjll1/Qq1cv0U6T8Pbbb2Px4sV477330KdPH6xduxbDhw/Hn3/+ia5duxrHzZkzB2+99Ra6du2KOXPmYOzYsTh16hQcHBwwffp0VFZW4tdff4W7uzuOHTvGahK1uLKqMgDAxIiJWDNijczRiKfVwlbIv5qPy1cvI8AjQO5wyE4x6bED3bt3x+HDhwEAO3fuxL59+5CbmwtnZ2cAwFtvvYVNmzbhq6++wpQpU+Dh4QEHB4cG21KPPPII4uLijN8b5gxNmzYNAJCQkIA9e/bgrbfeajDpad26NQCgVatWora93nrrLcyaNQsPP/wwAODNN9/E9u3bsWzZMixfvtw4bubMmbjvvvsAAPPmzUOvXr1w6tQpdO/eHZmZmRg9ejTCwsIAAJ06dRItPiJzlVaVAgDcnW7wLx6FaeVak/SUXZY7FLJjTHquw81NX3GR67HFIAiCcbO6Q4cOoaSkpN5pNq5evYrTp09f97769u1r8v3x48cxZcoUk2O333473n777RuM2nxFRUW4ePEibr/99npxGNp2BuHh4cavg4KCAAC5ubno3r07ZsyYgalTp2Lr1q2IiYnB6NGjTcYTtYTSSn3S4+ZoWzvD+7v542T+Sba3SFZMeq5DpbrxFpPcjh8/bpxLU1JSgqCgIKSmptYb5+Pjc937crfyF6PuxGtDIqjT6QAAkyZNQmxsLDZv3oytW7ciKSkJixcv5ioxalGG9pa7o3X/rF2rlZv+D63LV1npIflwIrON27ZtG44cOYLRo0cDAG655RZkZ2fDwcEBXbp0Mbn4+/sD0J+3ydxzNvXo0QO7du0yObZr1y707NmzwfFSnBPKy8sLwcHBFsXRmJCQEDz55JPYuHEjnnvuOaxevVq0OInMYavtLX83/ecLKz0kJ1Z6bEhFRQWys7NNlqwnJSXh3//+N8aPHw8AiImJQXR0NEaOHImFCxeiW7duuHjxIjZv3oz7778fffv2RWhoKM6cOYP09HS0a9cOnp6exvk/13r++efx0EMPoU+fPoiJicH333+PjRs3GidBX6tNmzZwdXVFcnIy2rVrBxcXF5OJ0tfKyMiod6xXr14NxpGYmIjOnTujd+/eWLduHdLT0/HJJ5+Y89IBAJ555hkMHToU3bp1w5UrV7B9+3b06NHD7NsTicGQ9Nhae6uVa02lh3N6SEZMemxIcnIygoKC4ODgAF9fX0REROCdd97BhAkTjJsTqlQq/Pjjj5gzZw7i4uKQl5eHwMBA3HnnnQgI0K+oGD16tHFpd0FBAdatW4eJEyc2+JgjR47E22+/jbfeegtPP/00OnbsiHXr1jW6FN3BwQHvvPMO5s+fj7lz56J///4NttoMDBOT6zp//ny9YzNmzEBhYSGee+455ObmomfPnvjuu+9MVm5dj1arxfTp0/HPP//Ay8sLQ4YMwdKlS82+PZEYDHN6bK69VZP0XLrKSg/JRyUIlu4GY92Kiorg7e2NwsJCeHl5mVxXXl6OM2fOoGPHjnBxcZEpQqIbx/ey9bpj7R3YdX4Xvn7oa4zqMUrucESzev9qTPlhCoZ1G4bvxn4ndzhkhZr6/W0uzukhIlIQ45weW6v01Exk5pwekhOTHiIiBbHlJesAV2+RvJj0EBEpiK2u3jLO6WGlh2TEpIeISEFsdZ8eQ6XnytUr0OrE27KCyBJMeoiIFMS4esvGKj1+rn4AAAECrpRfkTkasldMeoiIFKJKW4UqXRUA25vT46hxhLezfk8u7tVDcmHSQ0SkEIb5PIDttbcAruAi+THpISJSCMN8Ho1KAyeNk8zRiI8ruEhuTHrsjEqlwqZNm0S7vwEDBuCZZ54R7f5uRGpqKlQqFQoKCuQORTQTJ07EyJEj5Q6DWkjd5eqGE+LaEq7gIrkx6bEh2dnZeOqpp9CpUyc4OzsjJCQEw4YNQ0pKinFMVlYWhg4dKtpjbty4Ea+99ppo92euhpKt2267DVlZWU2eyys0NBQqlQoqlQoajQbBwcF4/PHHceUKJ1aS/Gx1ubqBsdLDOT0kEyY9NuLs2bOIjIzEtm3bsGjRIhw5cgTJyckYOHAgpk+fbhwXGBjY6MlDm8PPzw+enp6i3d+NcHJyQmBg4HX/Qp4/fz6ysrKQmZmJTz75BL/++itmzJjRQlESNc5Wz7tlwEoPyU32pGf58uUIDQ2Fi4sLoqKisG/fvibHL1u2DDfddBNcXV0REhKCZ599FuXl5S0UrXJNmzYNKpUK+/btw+jRo9GtWzf06tULCQkJ2LNnj3Fc3fbW2bNnoVKpjCcXdXNzQ0REBNLS0kzue9euXRgwYADc3Nzg6+uL2NhYY2Xk2opLaGgoFixYgMceewyenp5o3749Vq1aZbzenMe8fPkyxo4di7Zt28LNzQ1hYWH47LPPjNdPnDgRO3bswNtvv22s2pw9e9bs9panpycCAwPRtm1bDBw4EBMmTMCBAwdMxuzcuRP9+/c3vs9mzJiB0tLaSabXe54AsHv3bvTu3RsuLi7o27cvNm3aBJVKhfT0dAD6E5w+/vjj6NixI1xdXXHTTTfh7bffbjL2r776CmFhYXB1dUWrVq0QExNjEhdZN+MePbZe6eGcHpKJrEnPhg0bkJCQgMTERBw4cAARERGIjY1Fbm5ug+M//fRTvPjii0hMTMTx48exZs0abNiwAS+99JJkMQqCgNLKUlku5p4LNj8/H8nJyZg+fTrc3et/WPr4+DR5+zlz5mDmzJlIT09Ht27dMHbsWFRXVwMA0tPTMXjwYPTs2RNpaWnYuXMnhg0bBq228c3FFi9ejL59++LgwYOYNm0apk6dioyMDLMfs7y8HJGRkdi8eTOOHj2KKVOm4NFHHzUmxG+//Taio6MxefJkZGVlISsrCyEhIWa9Vte6cOECvv/+e0RFRRmPnT59GkOGDMHo0aNx+PBhbNiwATt37kR8fLzZz7OoqAjDhg1DWFgYDhw4gNdeew2zZs0yub1Op0O7du3w5Zdf4tixY5g7dy5eeuklfPHFFw3GmpWVhbFjx+Kxxx7D8ePHkZqailGjRpn9PiHlM7S3bG25uoFh9RaTHpKLg5wPvmTJEkyePBlxcXEAgJUrV2Lz5s1Yu3YtXnzxxXrjd+/ejdtvvx2PPPIIAP1f22PHjsXevXsli7GsqgweSR6S3X9TSmaXmPUX36lTpyAIArp3796sx5k5cybuu+8+AMC8efPQq1cvnDp1Ct27d8fChQvRt29f/O9//zOO79WrV5P3d++992LatGkAgFmzZmHp0qXYvn07brrpJrMes23btpg5c6Zx7FNPPYUtW7bgiy++QL9+/eDt7Q0nJye4ubkhMDDQ4uc7a9YsvPzyy9BqtSgvL0dUVBSWLFlivD4pKQnjxo0zVrC6du2Kd955B3fddRdWrFhhPGt5U8/z008/hUqlwurVq+Hi4oKePXviwoULmDx5svFxHB0dMW/ePOP3HTt2RFpaGr744gs89NBD9eLOyspCdXU1Ro0ahQ4dOgAAwsLCLH7+pFy23t4yVHrY3iK5yFbpqaysxP79+xETE1MbjFqNmJiYeu0Vg9tuuw379+83/sX/999/48cff8S9997b6ONUVFSgqKjI5GJrbvQv/fDwcOPXQUFBAGCsthkqPc29P5VKhcDAwHrVu6YeU6vV4rXXXkNYWBj8/Pzg4eGBLVu2IDMz06I4GvP8888jPT0dhw8fNk7yvu+++4zVq0OHDmH9+vXw8PAwXmJjY6HT6XDmzBmznmdGRgbCw8ONCRIA9OvXr14sy5cvR2RkJFq3bg0PDw+sWrWq0ecZERGBwYMHIywsDA8++CBWr17NCdg2xtbbW4Y5PZzITHKRrdJz6dIlaLVaBAQEmBwPCAjAX3/91eBtHnnkEVy6dAl33HEHBEFAdXU1nnzyySbbW0lJSSZ/TVvKzdENJbNLmn37G2Fuibtr165QqVSNvm7X4+joaPzaMAlYp9MBAFxdXW/o/gz3abg/cx5z0aJFePvtt7Fs2TKEhYXB3d0dzzzzDCorKy2OpSH+/v7o0qULAP1rt2zZMkRHR2P79u2IiYlBSUkJnnjiiQYnN7dv396i59mUzz//HDNnzsTixYsRHR0NT09PLFq0qNHKpUajwc8//4zdu3dj69atePfddzFnzhzs3bsXHTt2NPtxSblsvb3FSg/JTfaJzJZITU3FggUL8L///Q8HDhzAxo0bsXnz5iaXTM+ePRuFhYXGy/nz5y16TJVKBXcnd1ku5u7T4efnh9jYWCxfvrzBSa03sm9NeHi4yZL3lrBr1y6MGDEC//d//4eIiAh06tQJJ06cMBnj5OTU5LwiS2g0GgDA1atXAQC33HILjh07hi5dutS7ODmZt2HcTTfdhCNHjqCiosJ47PfffzcZs2vXLtx2222YNm0a+vTpgy5duuD06dNN3q9KpcLtt9+OefPm4eDBg3BycsI333xjydMlBbP19pZhTk/+1XzoBPP/QCASi2xJj7+/PzQaDXJyckyO5+TkNDpP45VXXsGjjz6KSZMmISwsDPfffz8WLFiApKSkRv/CdnZ2hpeXl8nFFi1fvhxarRb9+vXD119/jZMnT+L48eN45513EB0d3ez7nT17Nn7//XdMmzYNhw8fxl9//YUVK1bg0iXp/lLr2rWrsaJx/PhxPPHEE/XeJ6Ghodi7dy/Onj2LS5cuWVRhKS4uRnZ2NrKysrBv3z48//zzaN26NW677TYA+vk5u3fvRnx8PNLT03Hy5El8++239SYyN+WRRx6BTqfDlClTcPz4cWzZsgVvvfUWgNrKVteuXfHHH39gy5YtOHHiBF555ZV6iVFde/fuxYIFC/DHH38gMzMTGzduRF5eHnr06GF2XKRsxn16bDXpqWlvaQUtCssLZY6G7JFsSY+TkxMiIyNNqgg6nQ4pKSmN/pIuKyuDWm0asuGvdHtfwdKpUyccOHAAAwcOxHPPPYebb74Zd999N1JSUrBixYpm32+3bt2wdetWHDp0CP369UN0dDS+/fZbODhI1xl9+eWXccsttyA2NhYDBgxAYGBgvV2JZ86cCY1Gg549e6J169YWzfeZO3cugoKCEBwcjH//+99wd3fH1q1b0aqV/gM5PDwcO3bswIkTJ9C/f3/06dMHc+fORXBwsNmP4eXlhe+//x7p6eno3bs35syZg7lz5wKAcZ7PE088gVGjRmHMmDGIiorC5cuXjROjG7vPX3/9Fffeey+6deuGl19+GYsXLxZ1s0mSl63P6XF2cIaHk35hCFdwkSwEGX3++eeCs7OzsH79euHYsWPClClTBB8fHyE7O1sQBEF49NFHhRdffNE4PjExUfD09BQ+++wz4e+//xa2bt0qdO7cWXjooYfMfszCwkIBgFBYWFjvuqtXrwrHjh0Trl69euNPjugaH3/8seDo6CiUlZVJ/lh8L1unSd9OEvAqhNd2vCZ3KJLpsLSDgFchpJ1PkzsUsjJN/f42l6xL1seMGYO8vDzMnTsX2dnZ6N27N5KTk42TmzMzM00qOy+//DJUKhVefvllXLhwAa1bt8awYcPw+uuvy/UUiBr14YcfolOnTmjbti0OHTqEWbNm4aGHHmrW5HCyD7be3gL0k5nPFZ7jCi6ShaxJDwDEx8c3OlciNTXV5HsHBwckJiYiMTGxBSIjujHZ2dnGhD4oKAgPPvggE3Rqkq2fewuonczMFVwkB9mTHiJb9cILL+CFF16QOwyyIoY5Pba6ZB3gqShIXla1ZJ2IyJbZ+pJ1gCcdJXmx0kNEpBD20N4yVHqySrIaXbauUWuMq7yIxMSkh4hIIeyp0rM+fT3Wp69vdNwbg9/ArDtmNXo9UXOwvUVEpBD2MKdnYMeB8HXxve64bWe3tUA0ZG9Y6SEiUgh7aG/1bN0Tec/nQSs0fBqZz49+jgmbJkCrE+c0M0R1MekhIlIAQRDsor0F6OfsaKBp8DpnjTMANJoUEd0ItreIiBSgUltp/EVvy5We63FQ6/8Wr9ZVyxwJ2SImPTbi1VdfhUqlMrl0797deH15eTmmT5+OVq1awcPDA6NHjzY5iWd+fj6GDRsGDw8P9OnTBwcPHjS5/+nTp2Px4sUt9nyI7I1hPg9g23N6rkej1leA2N4iKTDpsSG9evVCVlaW8bJz507jdc8++yy+//57fPnll9ixYwcuXryIUaNGGa9//fXXUVxcjAMHDmDAgAGYPHmy8bo9e/Zg7969eOaZZ1ry6RDZFcN8Hge1A5w0TjJHIx+NqibpYXuLJMA5PTbEwcEBgYGB9Y4XFhZizZo1+PTTTzFo0CAAwLp169CjRw/s2bMHt956K44fP46HH34Y3bp1w5QpU7Bq1SoAQFVVFZ588km8//77xjPaE5H47GU+z/WwvUVSYqXHXKWljV/Ky80fe/WqeWOb4eTJkwgODkanTp0wbtw4ZGZmAgD279+PqqoqxMTEGMd2794d7du3R1paGgAgIiIC27ZtQ3V1NbZs2YLw8HAAwMKFCzFgwAD07du3WTERkXnsYbm6OdjeIikx6TGXh0fjl9GjTce2adP42KFDTceGhjY8zkJRUVFYv349kpOTsWLFCpw5cwb9+/dHcXExsrOz4eTkBB8fH5PbBAQEIDs7GwDw4osvwsHBAZ07d8Y333yDNWvW4OTJk/jggw/wyiuv4Mknn0SnTp3w0EMPobCw4V1Uiaj57GG5ujkM7S1WekgKbG/ZiKF1kqnw8HBERUWhQ4cO+OKLL+Dq6nrd23t7e+PTTz81OTZo0CAsWrQIn3zyCf7++29kZGRg8uTJmD9/Pic1E4mM7S09Q3uLc3pICkx6zFVS0vh11851yc1tfKz6muLa2bPNDqkpPj4+6NatG06dOoW7774blZWVKCgoMKn25OTkNDgHCNDP+fHx8cGIESMwatQojBw5Eo6OjnjwwQcxd+5cSWImsmes9OixvUVSYtJjLncLPoikGmuBkpISnD59Go8++igiIyPh6OiIlJQUjK5pxWVkZCAzMxPR0dH1bpuXl4f58+cbV39ptVpUVVUB0E9s1mr5YUQkNs7p0eNEZpISkx4bMXPmTAwbNgwdOnTAxYsXkZiYCI1Gg7Fjx8Lb2xuPP/44EhIS4OfnBy8vLzz11FOIjo7GrbfeWu++nnnmGTz33HNo27YtAOD222/HRx99hHvuuQerVq3C7bff3tJPj8jmsb2lxyXrJCUmPTbin3/+wdixY3H58mW0bt0ad9xxB/bs2YPWrVsDAJYuXQq1Wo3Ro0ejoqICsbGx+N///lfvfrZs2YJTp07ho48+Mh6Lj4/HH3/8gaioKPTr1w+JiYkt9ryI7AXbW3psb5GUmPTYiM8//7zJ611cXLB8+XIsX768yXGxsbGIjY01Oebm5oYvvvjihmMkosYZKj1uDmxvAWxvkTS4ZJ2ISAEMc3rsvtLD9hZJiEkPEZECGNtb9j6nR819ekg6THqIiBTAOJHZzis9xn16OKeHJMCkh4hIAQyVHntfss72FkmJSU8DBEGQOwSiG8L3sPUxzulhewsA21skDSY9dTg6OgIAysrKZI6E6MZUVlYCADTX7hZOisUl63psb5GUuGS9Do1GAx8fH+TWnEbCzc0NKpVK5qiILKPT6ZCXlwc3Nzc4OPBH3Fpwc0K9uu0tQRD4GUyi4ifiNQznospt6vxZRAqnVqvRvn17/sKwIpzTo2eo9ACATtAZkyAiMTDpuYZKpUJQUBDatGljPN8UkbVxcnKC+tqT25KicZ8ePcOcHkBf7dGASQ+Jh0lPIzQaDedDEFGLYXtLr25lp1pXDSeNk4zRkK3hn4JERArA9pZe3fYWJzOT2Jj0EBHJTBAEtrdqXNveIhIT21tERHVUaiux4egGXL56ucUeU6vTQifoALC9dW17i0hMTHqIiOr48s8vMX7TeFke21HtaPeVHrWqtgHB9haJjUkPEVEdWSVZAIBQn1BEt4tu0ce+p/M9JnNa7JFKpYJGpYFW0LK9RaKz758uIqJrXK26CgC4u9PdWDVslczR2CcHtQO0Wi3bWyQ6TmQmIqqjvLocAODq4CpzJPbLMJmZ7S0SG5MeIqI6DEmPi4OLzJHYL55pnaSiiKRn+fLlCA0NhYuLC6KiorBv375Gxw4YMAAqlare5b777mvBiInIVjHpkZ9hXhPbWyQ22ZOeDRs2ICEhAYmJiThw4AAiIiIQGxvb6LmvNm7ciKysLOPl6NGj0Gg0ePDBB1s4ciKyRVer9XN6XB3Z3pIL21skFdmTniVLlmDy5MmIi4tDz549sXLlSri5uWHt2rUNjvfz80NgYKDx8vPPP8PNzY1JDxGJgpUe+RnaW6z0kNhkTXoqKyuxf/9+xMTEGI+p1WrExMQgLS3NrPtYs2YNHn74Ybi7N7y3RUVFBYqKikwuRESNYdIjP0N7i3N6SGyyJj2XLl2CVqtFQECAyfGAgABkZ2df9/b79u3D0aNHMWnSpEbHJCUlwdvb23gJCQm54biJyHYx6ZEf21skFdnbWzdizZo1CAsLQ79+/RodM3v2bBQWFhov58+fb8EIicjaGOf0cMm6bDiRmaQi6+aE/v7+0Gg0yMnJMTmek5ODwMDAJm9bWlqKzz//HPPnz29ynLOzM5ydnW84ViKyD6z0yI9L1kkqslZ6nJycEBkZiZSUFOMxnU6HlJQUREc3vf37l19+iYqKCvzf//2f1GESkR1h0iM/trdIKrKfhiIhIQETJkxA37590a9fPyxbtgylpaWIi4sDAIwfPx5t27ZFUlKSye3WrFmDkSNHolWrVnKETUQ2ikmP/NjeIqnInvSMGTMGeXl5mDt3LrKzs9G7d28kJycbJzdnZmZCrTYtSGVkZGDnzp3YunWrHCETkQ0znHuL+/TIh+0tkorsSQ8AxMfHIz4+vsHrUlNT6x276aabIAiCxFERkT1ipUd+hvYWKz0kNqtevUVEJDYmPfIz7tPDOT0kMiY9RER1cMm6/NjeIqkw6SEiqqETdKjUVgJgpUdObG+RVJj0EBHVqKiuMH7NpEc+bG+RVJj0EBHVMMznAZj0yIntLZIKkx4iohqG+TwalQaOGkeZo7Ff3KeHpMKkh4ioBlduKQN3ZCapMOkhIqrBpEcZDO0tVnpIbEx6iIhqGJIe7sYsL+NEZs7pIZEx6SEiqmE4BQUrPfJie4ukwqSHiKgG21vKwPYWSYVJDxFRDSY9ysD2FkmFSQ8RUQ3jnB6egkJWbG+RVJj0EBHVMOzTw0qPvBxU3KeHpMGkh4ioBttbymCs9LC9RSJj0kNEVINJjzJwIjNJhUkPEVENw5J17tMjL55wlKTCpIeIqIax0qNhpUdObG+RVBzkDoCISCnY3lIGQ3srK6caTzwBVFWZd7s77wQmTpQuLrJ+THqIiGrwNBTKYGhv7dqtxclV5t/ugw+A0aMBT0+JAiOrx6SHiKgGl6wrg6G9VVGtb289+CBwyy1N3yYxEaisBC5fZtJDjWPSQ0RUg+0tZTBUenSCfvXWyJHAI480fZt33wUuXgTy84HQUGnjI+vFicxERDWY9CiDYU6PrmYis0Zz/dv4+ur/vXJFqqjIFjDpISKqwdNQKMO1q7eY9JBYmPQQEdXgnB5lMLa3oG9vOZgxEYNJD5mDSQ8RUQ22t5TB2N4CKz0kLiY9REQ1uGRdGQztLVZ6SGwWJz2dOnXC5cuX6x0vKChAp06dRAmKiEgOrPQog6G9JbDSQyKzOOk5e/YstNr6W4NXVFTgwoULogRFRCQHw7m3mPTIi+0tkorZ+/R89913xq+3bNkCb29v4/darRYpKSkI5eYIRGTFWOlRBk5kJqmYnfSMHDkSAKBSqTBhwgST6xwdHREaGorFixeLGhwRUUviknVlMMzpYXsLKCw0/9xjSuLgAPj4yB1FfWYnPTqdDgDQsWNH/P777/D395csKCIiOXDJujKwvaW3ZAnw3HNyR9E80dHA7t1yR1GfxaehOHPmjBRxEBHJju0tZaidyGzf7a2ffpI7AttjVtLzzjvvYMqUKXBxccE777zT5NgZM2aIEhgRUUvSCTpUaisBMOmRm7G9pbK80lNQAOh0gNoGNmTJztb/m5wM3HOPvLHYCrOSnqVLl2LcuHFwcXHB0qVLGx2nUqmY9BCRVaqorjB+zX165FXb3tJXeixJenQ6oLgYqLPWxmplZen/DQ4GVCp5Y7EVZiU9dVtabG8RkS0yzOcBWOmRm7G9VVPpMae95eKiv5SX61tc1p70VFYChi3xgoLkjcWWWDynx6CyshJnzpxB586d4WDOO5JuWHZJNv4p+kfuMJoU1iYMzg7OcodBZDHDfB6NSmP8pUvyaM7qLUBf7cnK0ic91r6DiqG15egItGolbyy2xOKf7LKyMjz11FP44IMPAAAnTpxAp06d8NRTT6Ft27Z48cUXLbq/5cuXY9GiRcjOzkZERATeffdd9OvXr9HxBQUFmDNnDjZu3Ij8/Hx06NABy5Ytw7333mvpU7Eq/xT9gy7vdEGFtuL6g2V0Z4c7sWPiDrnDILIYT0GhHIb2lqAyfyIzYJr0WDtDayswkK0tMVmc9MyePRuHDh1CamoqhgwZYjweExODV1991aKkZ8OGDUhISMDKlSsRFRWFZcuWITY2FhkZGWjTpk298ZWVlbj77rvRpk0bfPXVV2jbti3OnTsHHyVuBiCynZk7UaGtgIuDC9q4139t5Fatq8bF4os4kHVA7lCImoUrt5Tj2vaWJZUewDaSHkOlJzBQ3jhsjcVJz6ZNm7BhwwbceuutUNVJP3v16oXTp09bdF9LlizB5MmTERcXBwBYuXIlNm/ejLVr1zaYPK1duxb5+fnYvXs3HB0dAcBudoE+nHMYAPBo+KNYNWyVzNHUd7nsMvwX+aOksgRV2io4ahzlDonIIjwFhXIY2ltoZtKTny9BUC3MUOnhfB5xWbyoLy8vr8EqTGlpqUkSdD2VlZXYv38/YmJiaoNRqxETE4O0tLQGb/Pdd98hOjoa06dPR0BAAG6++WYsWLCgwXOBGVRUVKCoqMjkYo2O5B4BAIQHhMscScN8XHyMX18pt4E/s8jusNKjHLWVHsvbW4BtVHqY9EjD4qSnb9++2Lx5s/F7Q6Lz/vvvIzo62uz7uXTpErRaLQICAkyOBwQEINtQ17vG33//ja+++gparRY//vgjXnnlFSxevBj/+c9/Gn2cpKQkeHt7Gy8hISFmx6gkR3L0SU9YmzCZI2mYRq0xJj75V23gzyyyOzwFhXIY5vQ0t9LDpIcaY3F7a8GCBRg6dCiOHTuG6upqvP322zh27Bh2796NHTukncCq0+nQpk0brFq1ChqNBpGRkbhw4QIWLVqExMTEBm8ze/ZsJCQkGL8vKiqyusSnsLwQ5wrPAQDCApSZ9ACAn6sfCsoLcOWqDXzikN1hpUc5jO0ttfn79AC2lfQY/vZn0iMuiys9d9xxB9LT01FdXY2wsDBs3boVbdq0QVpaGiIjI82+H39/f2g0GuTk5Jgcz8nJQWAjM7eCgoLQrVs3aOr8BPTo0QPZ2dmorKxs8DbOzs7w8vIyuVibo7lHAQBtPdvCz9VP5mga5+ui/8RhpYesEc+7pRzGLQPU5u/TA9hW0sNKjzQsTnqOHj2Kzp07Y/Xq1di3bx+OHTuGjz/+GGFhYdi0aZPZ9+Pk5ITIyEikpKQYj+l0OqSkpDTaJrv99ttx6tQp48lPAf2S+aCgIDg5OVn6VKyGYRKzUufzGBgSMiY9ZI24ZF052N4yXbJO4rE46YmNjW1wV+avv/4a48aNs+i+EhISsHr1anzwwQc4fvw4pk6ditLSUuNqrvHjx2P27NnG8VOnTkV+fj6efvppnDhxAps3b8aCBQswffp0S5+GVTFMYlbqfB4DJj1kzdjeUo5r21v2VunR6QBDE4SVHnFZPKdn0qRJiImJwa5du4xtqA0bNuCxxx7D+vXrLbqvMWPGIC8vD3PnzkV2djZ69+6N5ORk4+TmzMxMqOucNS4kJARbtmzBs88+i/DwcLRt2xZPP/00Zs2aZenTsCpKX7llYGhvcfUWWSMmPcpxbXvL3io9ly8D1dX6TQmvWetDN8jipGfevHnIz89HTEwMfv31VyQnJ2PSpEn46KOPMHr0aIsDiI+PR3x8fIPXpaam1jsWHR2NPXv2WPw41koQhNqVWwqexAyw0kPWjfv0KIe9t7cMrS1/f/1pKEg8zTrBzLvvvotx48bh1ltvxYULF/DZZ59hxIgRYsdGAM4XnUdhRSEc1A7o7t9d7nCaxKSHrBmXrCtHbaVH395SmzkRw5D0FBToW0Tm3k5pOIlZOmYlPd999129Y6NGjcJvv/2GsWPHQqVSGccMHz5c3AjtnGESc3f/7nDSKHuytiHpYXuLrBHbW8pRO6dHC43G/HNPGZIenQ4oLrbeM61zErN0zEp6Ro4c2eh1a9euxdq1awHoNypsandkspyhtaX0+TwA4OvKJetkvbhkXTmM7S11tdmtLQBwdQWcnYGKCn2Ly9qTHlZ6xGdW0lN3iTg1rLSyFKfyT4l+v7v/2Q1A+Su3ALa3yLqx0qMcxvaWSmv2yi0DP7/aM61b66kZuTGhdJo1p4fqO5J7BNFrzD8Nh6WsodJjbG9xR2ayQpzToxzXtrcs4etbm/RYK1Z6pNOspCclJQUpKSnIzc2tVwUytLrsjaPaEUEe0rxDu/h1wV0d7pLkvsVUd0dmQRAsOgEtkdxY6VGO2vaWFhoHAYD5nyW2sIKLSY90mrVkff78+ejbty+CgoL4i61GZHAkLj53Ue4wZGWo9GgFLYori+HlbH2n/CD7xTk9ymFsbwHQOOgAmF/usaWkhxOZxWdx0rNy5UqsX78ejz76qBTxkBVzdXSFi4MLyqvLceXqFSY9ZFV4GgrlMLa3AGgctLC3pIdzeqRj8S4GlZWVuO2226SIhWwAJzOTtWJ7SzlMKj2O1Rbd1tqTnuJioLRU/zWTHvE16zQUn376KV555RUp4iEr5+vii4vFF5n0NGD1auDQIbmjEIeLCzBtGtCpk9yRiIdJj3IY5/TAUOkxnyHpybfSjyBDa8vTE3B3lzcWW2RW0pOQkGD8WqfTYdWqVfjll18QHh4Ox2v2yF6yZIm4EZJVYaWnYefOAVOmyB2FuIqKgFWr5I5CPDwNhXLUbW+pm5n0/PorYI2nZbxYMzWUVR5pmJX0HDx40OT73r17AwCOHj1qcpyTmom7MjfM0KP38QFmzJA1lBt24ADwww9AXp7ckYiLS9aVo257y8HJsvZWcLD+3+PH9RdrZa17DCmdWUnP9u3bpY6DbAQrPQ0rKND/26EDMG+erKHcsE8/1Sc9xcVyRyIutreUQ62qnW6q1lhW6Rk+HFi4EMjJETuqluPgAIwfL3cUtsniOT2FhYXQarXw8/MzOZ6fnw8HBwd4eXHFjj2ru1cP1TIkPT4+ckYhDk9P/b9MekhKamigg9biiczOzsDzz0sUFFk9i1dvPfzww/j888/rHf/iiy/w8MMPixIUWS/uytwwW0x6iorkjUNshn16uGRdGTQq/d/kls7pIWqKxUnP3r17MXDgwHrHBwwYgL1794oSFFkvY3urnJWeumwx6WGlh6SkrlnBxaSHxGRx0lNRUYHq6vrlxqqqKly9elWUoMh68UzrDSss1P/LpEeZdIIOldpKAEx6lEJTM/tC42BZe4uoKRYnPf369cOqBtaprly5EpGRkaIERdaL7a2G2WKlp6QEEAR5YxGLocoDMOlRClZ6SAoWT2T+z3/+g5iYGBw6dAiDBw8GoD8B6e+//46tW7eKHiBZF67eapgtJT2GtQo6HfBu2ntY+vsb0Oqs+xeTTqg9cTKTHmVQ1Zx6QmXh6i2iplic9Nx+++1IS0vDokWL8MUXX8DV1RXh4eFYs2YNunbtKkWMZEWY9DTMkPR4e8sahijc3AC1Wp/0vH9wFc4WnJU7JNF09+9uskcMyYftLZJCs366e/fujU8++UTsWMgGGJasl1aVolJbCSeNk8wRKYMtVXpUKsDDQ796q6hcv4RrzfA1iAiIkDmyG9fdv7vcIVANlYqVHhKfWUlPUVGRcf+douusU+U+PfbN28UbKqggQMCVq1cQ4BEgd0iKYEtJD6Cf11NUBJRU6WczRwZFIiLQ+pMeUg61YJjTw0oPicespMfX1xdZWVlo06YNfHx8GjzdhCAIUKlU0GqZldsztUoNX1df5F/NR/7VfCY9NWwx6QGA0pqkx9PZU8ZoyBapuU8PScCspGfbtm3GHZh5Sgq6Hl+X2qSH9Gwy6VFpUa4r03/vxKSHxKWqqfSo1Ex6SDxmJT133XVXg18TNcTP1Q+nr5zmSUdrVFYChi2sbCrpca7dqIeVHhKbGmxvkfjMSnoOHz5s9h2Gh4c3OxiyDVzBZcqwMSFQu9zb2nl6AnDSJz0Oagc4a5zlDYhsjqrm1xMnMpOYzEp6evfuDZVKBeE6O5FxTg8BTHquZWhteXkBGo2soYimbqXHy9mrwXl+RDfC0N6y9CzrRE0xK+k5c+aM1HGQDTEsW197cC32XuD52BzL2gPq1+HtbTv7v9St9HA+D0lBbaz0sL1F4jHrU7hDhw5Sx0E2pKNvRwDAkdwjOJJ7ROZoFKJDLHw8BskdhWjqVno4n4ekwB2ZSQrN+tPz5MmT2L59O3Jzc6HT6Uyumzt3riiBkfWa2ncqWrm2QnGlDZ2RspmW/74cJy6fANzybGYSM8BKD0mvdvUWKz0kHouTntWrV2Pq1Knw9/dHYGCgSS9fpVIx6SG4O7kjrk+c3GEowrYz2/RJj0uB7SU9rPSQhFQCJzKT+Jp1wtHXX38ds2bNkiIeIpvi4+Kj/8LGkh4vL7DSQ5Jie4ukoLb0BleuXMGDDz4oRSxENsdWkx5WekhyOkPSw/YWicfipOfBBx/E1q1bpYiFyObYdNLDSg9JyLhPD3dkJhFZ3N7q0qULXnnlFezZswdhYWFwdHQ0uX7GjBmiBUdk7Ww66XFm0kPSUek0+j/LmfSQiCxOelatWgUPDw/s2LEDO3bsMLlOpVIx6SGqozbpKYS3t6yhiMqk0sP2FknAOJGZq7dIRBYnPdyokMh89lDp8XK2kXNrkLLULFlnpYfEZPGcHiksX74coaGhcHFxQVRUFPbt29fo2PXr10OlUplcXFxcWjBaIvPZdtJTBABwc2ClhyTAs6yTBMyq9CQkJOC1116Du7s7EhISmhy7ZMkSiwLYsGEDEhISsHLlSkRFRWHZsmWIjY1FRkYG2rRp0+BtvLy8kJGRYfye5/0hpfJ2rulp2WLSYzjhqJZJD4lPpav59cTVWyQis5KegwcPoqqqyvh1Y5qTfCxZsgSTJ09GXJx+M7uVK1di8+bNWLt2LV588cVGHycwMNDixzJRWtrw2R81GqBu5ai0tPH7UKsBV9fmjS0rAxo7gatKBbi5NW/s1avANbtkm3B3b97Y8nKgqZPJWjLWzU0fNwBUVADVTXyoWTLW1VX/OgNAZSVQ85694bEuLrXvFUvGVlXBV+sEt0oA6ivwdSoF6r5FnJ0BBwfjWFRWNn6/dcdWV+tfi8Y4OQGGBQaWjNVq9f93jXF01I8H4KTRwl1TCKEScCx2qP/erzMWOp3+vWbG/V53rIOD/rUA9D8TZWXijLXk556fEQ2PFfszoqbS46itaPp1s/LPCLN/7q3sM8KisZZ8RtwoQUYVFRWCRqMRvvnmG5Pj48ePF4YPH97gbdatWydoNBqhffv2Qrt27YThw4cLR48ebfQxysvLhcLCQuPl/PnzAgChUP8RUf9y772md+Dm1vA4QBDuust0rL9/42P79jUd26FD42N79jQd27Nn42M7dDAd27dv42P9/U3H3nVX42Pd3EzH3ntv42OvfRs98EDTY0tKasdOmND02Nzc2rHTpjU99syZ2rEzZzY9tu57JjGx6bH79tWOXbiw6bHbt9eO/e9/mx77ww+1Y9eta3rsF1/Ujv3ii6bHrltXO/aHH5oe+9//1o7dvr3psQsX1o7dt6/psYmJtWOPHm167MyZtWPPnGl67LRptWNzc5seO2FC7diSkqbHPvCAYKKpsfyM0F8k/ozoPHO8gFchbO0T2fRYfkboL3bwGVFYWCgAEAoLC4XmavacnlOnTmHLli24WpOdCYJg8X1cunQJWq0WAQEBJscDAgKQnZ3d4G1uuukmrF27Ft9++y0+/vhj6HQ63Hbbbfjnn38aHJ+UlARvb2/jJSQkxOI4iYioZRnbW7D8dwtRY1SChdnK5cuX8dBDD2H79u1QqVQ4efIkOnXqhMceewy+vr5YvHix2fd18eJFtG3bFrt370Z0dLTx+AsvvIAdO3Zg7969172Pqqoq9OjRA2PHjsVrr71W7/qKigpU1CndFRUVISQkBIUXL8LLq4FVJyxdNzyW7S3Lx1ZV4e+/KhG2PghwKUb6EwfRtVXX2rFWXLoWqqvh8YoLoNZibZ8MjBnattGxbG/xM8LisW5u6PrcEzjlvRrD1In4LuH5Jsda82cE21sw+zOiqKgI3t7eKCwsbPj3txksXrL+7LPPwtHREZmZmejRo4fx+JgxY5CQkGBR0uPv7w+NRoOcnByT4zk5OWbP2XF0dESfPn1w6tSpBq93dnaGs+GDry53d9MfwsaYM6Y5Y+t+CIk5tu6HpphjLVkhZ8lYZ+faX0xijnVyMr8HLNVYR0dcqXREmc4XcCpGgaaq8feIo2PtB8v1ODjUfriJOVajMfs9XIFqlLnof2lVCgFN306tNv9nw5KxKpU0YwFljLXzzwihptJT5QTzXzcr/Iww++feyj4jLBpryc/9DbK4vbV161a8+eabaNeuncnxrl274ty5cxbdl5OTEyIjI5GSkmI8ptPpkJKSYlL5aYpWq8WRI0cQFBRk0WMTtYSCAgDlPvqvywtkjERcxRXFxq+rSz1kjIRsVs25t6DiknUSj8WVntLSUrg18FdFfn5+wxWV60hISMCECRPQt29f9OvXD8uWLUNpaalxNdf48ePRtm1bJCUlAQDmz5+PW2+9FV26dEFBQQEWLVqEc+fOYdKkSRY/NpHUbDbpqaxJeirdUFLcwCpIohsk1CQ9ApMeEpHFSU///v3x4YcfGufPqFQq6HQ6LFy4EAMHDrQ4gDFjxiAvLw9z585FdnY2evfujeTkZOPk5szMTKjVtQWpK1euYPLkycjOzoavry8iIyOxe/du9OzZ0+LHJpJaQQGACm/917aU9BgqPRVeKC5ueixRs2hrfj3xNBQkIouTnoULF2Lw4MH4448/UFlZiRdeeAF//vkn8vPzsWvXrmYFER8fj/j4+AavS01NNfl+6dKlWLp0abMeh6il2X6lx5NJD0mDlR6SgMVzem6++WacOHECd9xxB0aMGIHS0lKMGjUKBw8eROfOnaWIkchqFRbCNpMeY6WHSQ9JQzDO6WGlh8RjcaUHALy9vTFnzhyxYyGyOXZR6WliVSpRcxlWb7HSQ2JqVtJTUFCAffv2ITc3F7pr9nAYP368KIER2QKTpKeiQMZIxFVUoT/ZKCqY9JBEtGxvkfgsTnq+//57jBs3DiUlJfDy8jI535ZKpWLSQ1RH3aSnsLxQzlBEZWxvcU4PSUTQGio9bG+ReCxOep577jk89thjWLBgQYNL14lycoAlS8BfhgD27wfg7QPARttbnNNDEjEuWQcrPSQei5OeCxcuYMaMGUx4qFHvvQcsXCh3FAri7APAxpIeVnpIYjq2t0gCFic9sbGx+OOPP9CpUycp4iEbkJWl/3fQIODOO+WNRQl0gd6Yn21jSQ8rPSQxtrdICmYlPd99953x6/vuuw/PP/88jh07hrCwMDhecy6Q4cOHixshWZ38fP2/I0cCTz0layiKcDrfB/PftdGkh5UekoigZXuLxGdW0jNy5Mh6x+bPn1/vmEqlgrapM+eSXTAkPX5+8sahFD4uPgCA0qpSVGmr4Kgx86SBClZ3n56iIv0JvuusaSC6YYb2lg6s9JB4zNqcUKfTmXVhwkMAk55rebt4G78urLCNFVy17S0v6HTA1avyxkO2p7a9xd8rJB6Ld2Qmup4rV/T/+vrKG4dSOKgd4OGkPxO5rbS46k5kBrhSj8TH9hZJweKkZ8aMGXjnnXfqHf/vf/+LZ555RoyYyMqx0lOfocVlK3v1GCo9rmomPSQNtrdIChYnPV9//TVuv/32esdvu+02fPXVV6IERdZLq6053xSY9NRlSHpsrdLj7sikh6QhVOvbWzpWekhEFi9Zv3z5Mry9vesd9/LywqVLl0QJiqxXQUHt1z4+ckWhPDaX9NRUejycPHEJwDffAMeOyRuTGKKigC5d5I6CAEBbzfYWic/ipKdLly5ITk5GfHy8yfGffvqJe/eQsbXl5QU4NOvMbrbJ21n/h4ItJD06QYeSyhIAgJ+7J84CeO01WUMSTWBg7T5TJC/DRGa2t0hMFv9aSkhIQHx8PPLy8jBo0CAAQEpKChYvXoxly5aJHR9ZGc7naZgtVXoMCQ8AzHneE6vd9W1Na1ZdDWzfDmRnA1VVgKP17ypg9YxzegQrf3ORolic9Dz22GOoqKjA66+/jtdq/rwLDQ3FihUreLJRMiY9XLllypaSHsN8Ho1Kg/v/7YJRw2QOSATl5YCra+3XTHrkZ2hvaVnpIRE1qwExdepUTJ06FXl5eXB1dYWHh4fYcZGVMixXZ6XHlE0lPTXzeTydPaGykR0JnZ1rvy4vBzw95YuF9AwTmTmnh8Rk8eqtq1evoqysDADQunVrXL58GcuWLcPWrVtFD46sD9tbDTMmPRUFssYhBkOlx9PJdjIDlao28SkvlzcW0tNVs71F4rM46RkxYgQ+/PBDAEBBQQH69euHxYsXY8SIEVixYoXoAZJ1YXurYba0T4+h0uPl7CVzJOIytLe4u7QyGNtbAttbJB6Lk54DBw6gf//+AICvvvoKgYGBOHfuHD788MMGNy0k+8JKT8Nsqr1VUdvesiUuLvp/WelRBh336SEJWDynp6ysDJ41De+tW7di1KhRUKvVuPXWW3Hu3DnRAyTrwjk9DbOppKfS9tpbAJMeJRGE5re3CssLkbAlATmlOVKE1iIc1A6YETUDgzoOkjsUm9OsfXo2bdqE+++/H1u2bMGzzz4LAMjNzYWXl22Vu8lyrPQ0zLBPz+krpzHmqzEyR3Nj/r7yNwDbrfSwvSU/nQ6ATv/rqdrC9tZ3Gd9hbfpaCaJqWflX85n0SMDipGfu3Ll45JFH8Oyzz2Lw4MGIjo4GoK/69OnTR/QAybpwTk/DQrxDoFapUVZVhi/+/ELucEQR4hUidwiiqrtkneSl1QIQmlfpySvLAwBEt4vG5Fsmix2a5P6+8jf+89t/cKH4gtyh2CSLk54HHngAd9xxB7KyshAREWE8PnjwYNx///2iBkfWh+2thgV6BOKXR3/B0dyjcociChcHFzzQ8wG5wxAV21vKUV0NQNe8pOfKVf2HUJ/APojrEyd2aJIzJD1ZxVkQBMFmtoVQCouSnqqqKri6uiI9Pb1eVadfv36iBkbWie2txg3sOBADOw6UOwxqBJMe5dBq0ez21pVyfdLj62qd5eZAj0AAwNXqqyiqKIK3S/1zXVLzWbR6y9HREe3bt4fW2vecJ0kIAttbZL04p0c5bqS9ZUx6XKzzQ8jN0c24HURWCU8EJzaL21tz5szBSy+9hI8++gh+/HPeqLoaqNmzUXRubtZx8s7SUv15iwBWesj6cE6PctRtb1XrLKz0XLXuSg8ABHkEoaiiCNkl2eju313ucGyKxb9K//vf/+LUqVMIDg5Ghw4d4O7ubnL9gQMHRAvOmvzxB1Azp1t0QUHAkSNAq1bS3L9YDPN5nJz0iRqRNWF7Sznqtre0dlbpAYAgzyBkXM5AVjErPWKzOOkZOXKkBGFQU7KygF9/BZQ+T7xua4tz78jasL2lHHXbW1pd8yYyW3ulB2B7SwoWJz2JiYlSxGH1+vWT5i/EKVOADz8EDh+2nqSHrS2yRqz0KIe+vVUzkdnS9pYtVHoMSQ8rPaJr9kyRyspK5ObmQqfTmRxv3779DQdljdRq0zM1i8WwK8CRI+Lft9i4XJ2sGef0KIe+vWU495b5lR5BEIyVHj9X6/0gMqzgYqVHfBYnPSdOnMDjjz+O3bt3mxw37CfAlV3iCgvT/3v4sLxxmIMrt8iasdKjHNXVaFZ7q6yqDFU6/WoKq25vebK9JRWLk564uDg4ODjghx9+QFBQEDdOklh4uP7fU6f0q8OUPEGY7S2yZpzToxzXTmQ2d5M+Q2vLQe0Ad0f364xWLkN7K7skW+ZIbI/FSU96ejr279+P7t25jK4lBAQArVsDeXnAn38C//qX3BE1jkkPWTO2t5SjbnsLAHSCDhqVpvEb1DBOYnbxteo/yI2VHs7pEZ1FmxMCQM+ePXHp0iUpYqFGGKo9Sp/Xwzk9ZM3Y3lKOuu0twPzJzNa+G7OBYU7PlfIrKK/mG1JMZiU9RUVFxsubb76JF154Aampqbh8+bLJdUVFRVLHa5esZV4P5/SQNWPSoxx121uA+ZOZ61Z6rJmviy+cNfqVMWxxicuspMfHxwe+vr7w9fXF3XffjT179mDw4MFo06aN8bhhTHMsX74coaGhcHFxQVRUFPbt22fW7T7//HOoVCqb3zvIWio9bG+RNeOcHuW4tr1l7mRmW6n0qFSq2hVcbHGJyqw5Pdu3b5csgA0bNiAhIQErV65EVFQUli1bhtjYWGRkZKBNmzaN3u7s2bOYOXMm+vfvL1lsSlG30iMIyt34j0kPWTPO6VGOZre3bKTSA+jn9ZwrPMdKj8jMSnruuusuyQJYsmQJJk+ejLi4OADAypUrsXnzZqxduxYvvvhig7fRarUYN24c5s2bh99++w0FBQWSxacEPXvqE51Ll4CcHCAwUO6IGmaY08P2FlkjtreUo9ntLRvYmNCAe/VIo9mbE5aVlSEzMxOVlZUmx8MNvRgzVFZWYv/+/Zg9e7bxmFqtRkxMDNLS0hq93fz589GmTRs8/vjj+O2335p8jIqKClRUVBi/t8Z5R25uQNeuwIkT+mqPUpMeVnrImrG9pRz6Sk/t7Auz21s2cAoKA+7KLA2Lk568vDzExcXhp59+avB6SzYnvHTpErRaLQICAkyOBwQE4K+//mrwNjt37sSaNWuQnp5u1mMkJSVh3rx5ZsekVGFh+qTnyBHgnnvkjqa+qiqguFj/NZMeskas9CiH8deIzgFQV1u+essGKj08/5Y0LF6y/swzz6CgoAB79+6Fq6srkpOT8cEHH6Br16747rvvpIjRqLi4GI8++ihWr14Nf39/s24ze/ZsFBYWGi/nz5+XNEapGApoBw/q/xJV2iW7TtvZx0eWl4johnBOj3IYkh6VYNmpKGxlIjPAXZmlYnGlZ9u2bfj222/Rt29fqNVqdOjQAXfffTe8vLyQlJSE++67z+z78vf3h0ajQU5OjsnxnJwcBDbQwzl9+jTOnj2LYcOGGY8Zzv3l4OCAjIwMdO7c2eQ2zs7OcJbipFgtzDCZ+ZNP9Bel8vYGNNffQ4xIcVjpUY7qmsKOStBAgPkTmfOv6nvstlTp4URmcVlc6SktLTWuqvL19UVeXh4AICwsDAcOHLDovpycnBAZGYmUlBTjMZ1Oh5SUFERHR9cb3717dxw5cgTp6enGy/DhwzFw4ECkp6cjJCTE0qdjNe68EwgOljuK6/v3v+WOgKh5OKdHOWorPTWnorDDOT1csi4Niys9N910EzIyMhAaGoqIiAi89957CA0NxcqVKxEUFGRxAAkJCZgwYQL69u2Lfv36YdmyZSgtLTWu5ho/fjzatm2LpKQkuLi44Oabbza5vU9NL+Xa47amVSsgM1P5H8geHnJHQNQ8dSs9St4awh7UTg1tZnvLFio9Ne2tnNIcaHVaaNQsoYvB7KTnzJkz6NixI55++mlkZekzz8TERAwZMgSffPIJnJycsH79eosDGDNmDPLy8jB37lxkZ2ejd+/eSE5ONk5uzszMhFptcUHKJmk0TCqIpGKY06PT6dsrjo7yxmPP6ra3APPaW4Ig2FSlp417G6iggk7QIa8sz1j5oRtjdtLTuXNndOjQAQMHDsTAgQPxzz//IDIyEufOncNff/2F9u3bmz25+Frx8fGIj49v8LrU1NQmb9ucRIuI6FqGSg+gr6gy6ZGPodKjtqC9VVZVhipdFQDbqPQ4qB3Qxr0NckpzkFWcxaRHJGYnPdu2bUNqaipSU1Px2WefobKyEp06dcKgQYMwcOBAtG3bVso4iYgkVXe9Q3k54OUlXyz2zljpsaC9ZWhtaVQaeDjZRkk80CMQOaU5+P3i73BxcLn+DRTE1dEVoT6hcodRj9lJz4ABAzBgwAAAQHl5OXbv3m1Mgj744ANUVVWhe/fu+PPPP6WKlYhIMiqVvtpTXs4VXHK7diKzOe0tQ2vLz9UPKhuZkBXkGYRDOYfwxA9PyB2KxaLbRWP347vlDqOeZu3I7OLigkGDBuGOO+7AwIED8dNPP+G9995rdENBIiJrwKRHGYztLUOlx4z2li3t0WMwMWIiDuccRkV1xfUHK4y3i7fcITTIoqSnsrISe/bswfbt25Gamoq9e/ciJCQEd955J/773/9Keo4uIiKpcdm6Mlzb3rKk0mML83kMxtw8BmNuHiN3GDbF7KRn0KBB2Lt3Lzp27Ii77roLTzzxBD799NNmLVMnIlIiblCoDLWVnpqJzBbM6bGlSg+Jz+yk57fffkNQUBAGDRqEAQMG4K677kKrVq2kjI2IqEXxVBTKYJzTY0l7ywYrPSQ+szfAKSgowKpVq+Dm5oY333wTwcHBCAsLQ3x8PL766ivjzsxERNaKlR5lMLS31Ja0t2xoY0KSjtmVHnd3dwwZMgRDhgwBoD/5586dO7F9+3YsXLgQ48aNQ9euXXH06FHJgiUikhLn9ChDs9pbNrQxIUmn2Vsdu7u7w8/PD35+fvD19YWDgwOOHz8uZmxERC2KlR5luKHVW6z0UBPMrvTodDr88ccfSE1Nxfbt27Fr1y6Ulpaibdu2GDhwIJYvX46BAwdKGSsRkaQ4p0cZjO0tlQX79HAiM5nB7KTHx8cHpaWlCAwMxMCBA7F06VIMGDAAnTt3ljI+IqIWw/aWMtSr9FjS3mKlh5pgdtKzaNEiDBw4EN26dZMyHiIi2bC9pQzXTmS2180JSXxmJz1PPGF922ATEVmCSY8yGCo9GkvaW6z0kBmadRoKIiJbxDk9ymBsb6n0lZ6V+1filzO/NHmbS2WXALDSQ01j0kNEVINzepTB0N5yQ2sAwM7MndiZufO6t3N1cEVrt9ZShkZWjkkPEVENtreUwVDpGVD9Jqb8OxKV2kqzbndru1vh6ugqYWRk7Zj0EBHVYNKjDIakx0cdjGdufUbWWMi2NHtzQiIiW2OY08P2lrwM7S0H/llOImPSQ0RUg5UeZTCu3tLIGwfZHiY9REQ1mPQog6HSw6SHxMakh4ioBpesK4Oh0sP2FomNSQ8RUQ0uWVcGtrdIKkx6iIhqsL2lDJzITFJh0kNEVINJjzKw0kNSYdJDRFSDc3qUgUkPSYVJDxFRDc7pUQa2t0gqTHqIiGqwvaUMrPSQVJj0EBHVYNKjDNynh6TCpIeIqEbd01AIgryx2DPu00NSYdJDRFTDUOkRBKCqSt5Y7BnbWyQVJj1ERDUMSQ/AFpec2N4iqTDpISKq4exc+zWTHvmwvUVSYdJDRFRDpeKydSVge4ukwqSHiKgOruCSH/fpIakw6SEiqoNJj/xY6SGpMOkhIqqj7rJ1kgcnMpNUmPQQEdXBSo/8OJGZpKKIpGf58uUIDQ2Fi4sLoqKisG/fvkbHbty4EX379oWPjw/c3d3Ru3dvfPTRRy0YLRHZMiY98mN7i6Qie9KzYcMGJCQkIDExEQcOHEBERARiY2ORm5vb4Hg/Pz/MmTMHaWlpOHz4MOLi4hAXF4ctW7a0cOREZIuY9MiP7S2SiuxJz5IlSzB58mTExcWhZ8+eWLlyJdzc3LB27doGxw8YMAD3338/evTogc6dO+Ppp59GeHg4du7c2cKRE5Et4pwe+bG9RVKRNemprKzE/v37ERMTYzymVqsRExODtLS0695eEASkpKQgIyMDd955Z4NjKioqUFRUZHIhImoMKz3yY3uLpCJr0nPp0iVotVoEBASYHA8ICEB2dnajtyssLISHhwecnJxw33334d1338Xdd9/d4NikpCR4e3sbLyEhIaI+ByKyLUx65Md9ekgqsre3msPT0xPp6en4/fff8frrryMhIQGpqakNjp09ezYKCwuNl/Pnz7dssERkVZj0yI+VHpKKrHm0v78/NBoNcnJyTI7n5OQgMDCw0dup1Wp06dIFANC7d28cP34cSUlJGDBgQL2xzs7OcK57Qh0ioiZwTo/8mPSQVGSt9Dg5OSEyMhIpKSnGYzqdDikpKYiOjjb7fnQ6HSoqKqQIkYjsDCs98mN7i6Qi+1sqISEBEyZMQN++fdGvXz8sW7YMpaWliIuLAwCMHz8ebdu2RVJSEgD9HJ2+ffuic+fOqKiowI8//oiPPvoIK1askPNpEJGNYNIjP1Z6SCqyJz1jxoxBXl4e5s6di+zsbPTu3RvJycnGyc2ZmZlQq2sLUqWlpZg2bRr++ecfuLq6onv37vj4448xZswYuZ4CEdkQnmVdftynh6SiEgRBkDuIllRUVARvb28UFhbCy8tL7nCISGFefx14+WVg0iRg9Wq5o7FPzs5AZSWQmQlwwS0ZiPH7W/ZKDxGRkhgqPV9/Dezf37KPfd99wGuvtexjKhHbWyQVJj1ERHXULAzFlSv6S0s6eBB45RXAyallH1dJBIE7MpN0+JYiIqpj+HBg3z7g8uWWe8zqamDYMP3XpaX2nfTodLVfs9JDYmPSQ0RUh0oF/OtfLfuYgqD/Ba/V6pMeX9+WfXwlMVR5ACY9JD6r3JGZiMiWqFSAu7v+67IyeWORm2HlFsD2FomPSQ8RkQIYkp7SUnnjkBsrPSQlJj1ERArg5qb/196TnrqVHiY9JDYmPURECsD2ll7dSg/bWyQ2Jj1ERArA9pZe3aRHzd9QJDK+pYiIFIBJjx5PQUFSYtJDRKQAnNOjx40JSUpMeoiIFIBzevR4CgqSEpMeIiIFYHtLz9DeYqWHpMCkh4hIAZj06LHSQ1Ji0kNEpACGOT323t7iRGaSEpMeIiIFYKVHjxOZSUpMeoiIFIBJjx7bWyQlJj1ERArApEeP7S2SEpMeIiIF4JwePba3SEpMeoiIFICVHj22t0hKTHqIiBSASY8e9+khKTHpISJSAJ6GQo+VHpISkx4iIgXgaSj0OJGZpMSkh4hIAdje0uNEZpISkx4iIgWom/QIgryxyIntLZISkx4iIgUwzOnR6YDKSnljkRPbWyQlJj1ERApgqPQA9t3iYnuLpMSkh4hIARwd9ReASQ/ASg9Jg7k0EZFCuLsDBQW2n/RcvAhcutTwdWfO6P9lpYekwLcVEZFCuLnpkx5bXra+ezdwxx3Xn6zNpIekwLcVEZFC2MOy9T/+0Cc8Li6Aj0/DYxwdgf/7vxYNi+wEkx4iIoWwh6Tn8mX9v3FxwP/+J28sZH84kZmISCHsYVdmw1yeVq3kjYPsE5MeIiKFsIfzbxkqPf7+8sZB9olJDxGRQthDe4uVHpITkx4iIoWwh6SHlR6SE5MeIiKF4JweImkpIulZvnw5QkND4eLigqioKOzbt6/RsatXr0b//v3h6+sLX19fxMTENDmeiMhacE4PkbRkT3o2bNiAhIQEJCYm4sCBA4iIiEBsbCxyc3MbHJ+amoqxY8di+/btSEtLQ0hICO655x5cuHChhSMnIhKXrbe3ysqAq1f1X7PSQ3KQPelZsmQJJk+ejLi4OPTs2RMrV66Em5sb1q5d2+D4Tz75BNOmTUPv3r3RvXt3vP/++9DpdEhJSWnhyImIxGXrSY+hyuPoCHh6yhsL2SdZk57Kykrs378fMTExxmNqtRoxMTFIS0sz6z7KyspQVVUFPz+/Bq+vqKhAUVGRyYWISIkM7S1bndNjSHpatQJUKnljIfska9Jz6dIlaLVaBAQEmBwPCAhAdna2Wfcxa9YsBAcHmyROdSUlJcHb29t4CQkJueG4iYikYOuVHsMkZs7nIbnI3t66EW+88QY+//xzfPPNN3BxcWlwzOzZs1FYWGi8nD9/voWjJCIyj60nPXUrPURykPXcW/7+/tBoNMjJyTE5npOTg8DAwCZv+9Zbb+GNN97AL7/8gvDw8EbHOTs7w9nZWZR4iYikZOtL1lnpIbnJWulxcnJCZGSkySRkw6Tk6OjoRm+3cOFCvPbaa0hOTkbfvn1bIlQiIsnZ+pJ1VnpIbrKfZT0hIQETJkxA37590a9fPyxbtgylpaWIi4sDAIwfPx5t27ZFUlISAODNN9/E3Llz8emnnyI0NNQ498fDwwMeHh6yPQ8iohtl6+0tVnpIbrInPWPGjEFeXh7mzp2L7Oxs9O7dG8nJycbJzZmZmVCrawtSK1asQGVlJR544AGT+0lMTMSrr77akqETEYnK1pMeVnpIbrInPQAQHx+P+Pj4Bq9LTU01+f7s2bPSB0REJAN7mdPDpIfkYtWrt4iIbEndOT2CIG8sUuApKEhuTHqIiBTCUOkRBKC8XN5YpMBKD8mNSQ8RkUIYkh7ANltcrPSQ3Jj0EBEphEYDGLYVs7XJzBUVQEmJ/mtWekguTHqIiBTEVvfqMVR5NBrA21veWMh+MekhIlIQW122bpjP4+cHqPmbh2TCtx4RkYLY6rJ1zuchJWDSQ0SkILZe6eF8HpITkx4iIgWx9Tk9rPSQnJj0EBEpiK22t1jpISVg0kNEpCC22t5ipYeUgEkPEZGC2Hp7i5UekhOTHiIiBbHVSo+hvcVKD8mJSQ8RkYLY6pweVnpICZj0EBEpCCs9RNJxkDsAIiKqZZjTk5sLnDsnbyxi4uotUgImPURECmKo9Hz5pf5ia5j0kJyY9BARKUhMDBASAuTlyR2J+GJimPSQvJj0EBEpSI8eQGam3FEQ2SZOZCYiIiK7wKSHiIiI7AKTHiIiIrILTHqIiIjILjDpISIiIrvApIeIiIjsApMeIiIisgtMeoiIiMguMOkhIiIiu8Ckh4iIiOwCkx4iIiKyC0x6iIiIyC4w6SEiIiK7wKSHiIiI7IKD3AG0NEEQAABFRUUyR0JERETmMvzeNvwebw67S3qKi4sBACEhITJHQkRERJYqLi6Gt7d3s26rEm4kZbJCOp0OFy9ehKenJ1Qqlaj3XVRUhJCQEJw/fx5eXl6i3re14Wuhx9ehFl+LWnwt9Pg61OJrUaux10IQBBQXFyM4OBhqdfNm59hdpUetVqNdu3aSPoaXl5fdv2kN+Fro8XWoxdeiFl8LPb4Otfha1GrotWhuhceAE5mJiIjILjDpISIiIrvApEdEzs7OSExMhLOzs9yhyI6vhR5fh1p8LWrxtdDj61CLr0UtKV8Lu5vITERERPaJlR4iIiKyC0x6iIiIyC4w6SEiIiK7wKSHiIiI7AKTHpEsX74coaGhcHFxQVRUFPbt2yd3SJJLSkrCv/71L3h6eqJNmzYYOXIkMjIyTMYMGDAAKpXK5PLkk0/KFLF0Xn311XrPs3v37sbry8vLMX36dLRq1QoeHh4YPXo0cnJyZIxYGqGhofVeB5VKhenTpwOw7ffDr7/+imHDhiE4OBgqlQqbNm0yuV4QBMydOxdBQUFwdXVFTEwMTp48aTImPz8f48aNg5eXF3x8fPD444+jpKSkBZ+FOJp6LaqqqjBr1iyEhYXB3d0dwcHBGD9+PC5evGhyHw29l954440WfiY35nrviYkTJ9Z7jkOGDDEZYw/vCQANfm6oVCosWrTIOEaM9wSTHhFs2LABCQkJSExMxIEDBxAREYHY2Fjk5ubKHZqkduzYgenTp2PPnj34+eefUVVVhXvuuQelpaUm4yZPnoysrCzjZeHChTJFLK1evXqZPM+dO3car3v22Wfx/fff48svv8SOHTtw8eJFjBo1SsZopfH777+bvAY///wzAODBBx80jrHV90NpaSkiIiKwfPnyBq9fuHAh3nnnHaxcuRJ79+6Fu7s7YmNjUV5ebhwzbtw4/Pnnn/j555/xww8/4Ndff8WUKVNa6imIpqnXoqysDAcOHMArr7yCAwcOYOPGjcjIyMDw4cPrjZ0/f77Je+Wpp55qifBFc733BAAMGTLE5Dl+9tlnJtfbw3sCgMlrkJWVhbVr10KlUmH06NEm4274PSHQDevXr58wffp04/darVYIDg4WkpKSZIyq5eXm5goAhB07dhiP3XXXXcLTTz8tX1AtJDExUYiIiGjwuoKCAsHR0VH48ssvjceOHz8uABDS0tJaKEJ5PP3000Lnzp0FnU4nCIL9vB8ACN98843xe51OJwQGBgqLFi0yHisoKBCcnZ2Fzz77TBAEQTh27JgAQPj999+NY3766SdBpVIJFy5caLHYxXbta9GQffv2CQCEc+fOGY916NBBWLp0qbTBtaCGXocJEyYII0aMaPQ29vyeGDFihDBo0CCTY2K8J1jpuUGVlZXYv38/YmJijMfUajViYmKQlpYmY2Qtr7CwEADg5+dncvyTTz6Bv78/br75ZsyePRtlZWVyhCe5kydPIjg4GJ06dcK4ceOQmZkJANi/fz+qqqpM3iPdu3dH+/btbfo9UllZiY8//hiPPfaYycl97eX9UNeZM2eQnZ1t8h7w9vZGVFSU8T2QlpYGHx8f9O3b1zgmJiYGarUae/fubfGYW1JhYSFUKhV8fHxMjr/xxhto1aoV+vTpg0WLFqG6ulqeACWUmpqKNm3a4KabbsLUqVNx+fJl43X2+p7IycnB5s2b8fjjj9e77kbfE3Z3wlGxXbp0CVqtFgEBASbHAwIC8Ndff8kUVcvT6XR45plncPvtt+Pmm282Hn/kkUfQoUMHBAcH4/Dhw5g1axYyMjKwceNGGaMVX1RUFNavX4+bbroJWVlZmDdvHvr374+jR48iOzsbTk5O9T7QAwICkJ2dLU/ALWDTpk0oKCjAxIkTjcfs5f1wLcP/c0OfE4brsrOz0aZNG5PrHRwc4OfnZ9Pvk/LycsyaNQtjx441ObnkjBkzcMstt8DPzw+7d+/G7NmzkZWVhSVLlsgYrbiGDBmCUaNGoWPHjjh9+jReeuklDB06FGlpadBoNHb7nvjggw/g6elZbwqAGO8JJj0kiunTp+Po0aMm81gAmPSew8LCEBQUhMGDB+P06dPo3LlzS4cpmaFDhxq/Dg8PR1RUFDp06IAvvvgCrq6uMkYmnzVr1mDo0KEIDg42HrOX9wOZp6qqCg899BAEQcCKFStMrktISDB+HR4eDicnJzzxxBNISkqymVM1PPzww8avw8LCEB4ejs6dOyM1NRWDBw+WMTJ5rV27FuPGjYOLi4vJcTHeE2xv3SB/f39oNJp6K3FycnIQGBgoU1QtKz4+Hj/88AO2b9+Odu3aNTk2KioKAHDq1KmWCE02Pj4+6NatG06dOoXAwEBUVlaioKDAZIwtv0fOnTuHX375BZMmTWpynL28Hwz/z019TgQGBtZb/FBdXY38/HybfJ8YEp5z587h559/NqnyNCQqKgrV1dU4e/ZsywQog06dOsHf39/482Bv7wkA+O2335CRkXHdzw6gee8JJj03yMnJCZGRkUhJSTEe0+l0SElJQXR0tIyRSU8QBMTHx+Obb77Btm3b0LFjx+veJj09HQAQFBQkcXTyKikpwenTpxEUFITIyEg4OjqavEcyMjKQmZlps++RdevWoU2bNrjvvvuaHGcv74eOHTsiMDDQ5D1QVFSEvXv3Gt8D0dHRKCgowP79+41jtm3bBp1OZ0wObYUh4Tl58iR++eUXtGrV6rq3SU9Ph1qtrtfusSX//PMPLl++bPx5sKf3hMGaNWsQGRmJiIiI645t1nvihqZBkyAIgvD5558Lzs7Owvr164Vjx44JU6ZMEXx8fITs7Gy5Q5PU1KlTBW9vbyE1NVXIysoyXsrKygRBEIRTp04J8+fPF/744w/hzJkzwrfffit06tRJuPPOO2WOXHzPPfeckJqaKpw5c0bYtWuXEBMTI/j7+wu5ubmCIAjCk08+KbRv317Ytm2b8McffwjR0dFCdHS0zFFLQ6vVCu3btxdmzZplctzW3w/FxcXCwYMHhYMHDwoAhCVLlggHDx40rkh64403BB8fH+Hbb78VDh8+LIwYMULo2LGjcPXqVeN9DBkyROjTp4+wd+9eYefOnULXrl2FsWPHyvWUmq2p16KyslIYPny40K5dOyE9Pd3ks6OiokIQBEHYvXu3sHTpUiE9PV04ffq08PHHHwutW7cWxo8fL/Mzs0xTr0NxcbEwc+ZMIS0tTThz5ozwyy+/CLfccovQtWtXoby83Hgf9vCeMCgsLBTc3NyEFStW1Lu9WO8JJj0ieffdd4X27dsLTk5OQr9+/YQ9e/bIHZLkADR4WbdunSAIgpCZmSnceeedgp+fn+Ds7Cx06dJFeP7554XCwkJ5A5fAmDFjhKCgIMHJyUlo27atMGbMGOHUqVPG669evSpMmzZN8PX1Fdzc3IT7779fyMrKkjFi6WzZskUAIGRkZJgct/X3w/bt2xv8eZgwYYIgCPpl66+88ooQEBAgODs7C4MHD673Gl2+fFkYO3as4OHhIXh5eQlxcXFCcXGxDM/mxjT1Wpw5c6bRz47t27cLgiAI+/fvF6KiogRvb2/BxcVF6NGjh7BgwQKTZMAaNPU6lJWVCffcc4/QunVrwdHRUejQoYMwefLken8s28N7wuC9994TXF1dhYKCgnq3F+s9oRIEQTC/LkRERERknTinh4iIiOwCkx4iIiKyC0x6iIiIyC4w6SEiIiK7wKSHiIiI7AKTHiIiIrILTHqIiIjILjDpISIiIrvApIeIJLd+/Xr4+PjIHYZZUlNToVKp6p0gloisH5MeIhLFxIkToVKpoFKp4OTkhC5dumD+/Pmorq5usRhCQ0OxbNmyFns8IrIuDnIHQES2Y8iQIVi3bh0qKirw448/Yvr06XB0dLT5s6gTkXVgpYeIROPs7IzAwEB06NABU6dORUxMDL777rt6406fPo0RI0YgICAAHh4e+Ne//oVffvnFeP38+fNx880317td79698corr5gdj0qlwvvvv4/7778fbm5u6Nq1a714fvzxR3Tr1g2urq4YOHAgzp49W+9+du7cif79+8PV1RUhISGYMWMGSktLAQAffvghPDw8cPLkSeP4adOmoXv37igrKzM7ViKSHpMeIpKMq6srKisr6x0vKSnBvffei5SUFBw8eBBDhgzBsGHDkJmZCQB47LHHcPz4cfz+++/G2xw8eBCHDx9GXFycRTHMmzcPDz30EA4fPox7770X48aNQ35+PgDg/PnzGDVqFIYNG4b09HRMmjQJL774osntT58+jSFDhmD06NE4fPgwNmzYgJ07dyI+Ph4AMH78eOP9VldXY/PmzXj//ffxySefwM3NzaJYiUhiN3ayeCIivQkTJggjRowQBEEQdDqd8PPPPwvOzs7CzJkzhXXr1gne3t5N3r5Xr17Cu+++a/x+6NChwtSpU43fP/XUU8KAAQOavI8OHToIS5cuNX4PQHj55ZeN35eUlAgAhJ9++kkQBEGYPXu20LNnT5P7mDVrlgBAuHLliiAIgvD4448LU6ZMMRnz22+/CWq1Wrh69aogCIKQn58vtGvXTpg6daoQEBAgvP76603GSUTyYKWHiETzww8/wMPDAy4uLhg6dCjGjBmDV199td64kpISzJw5Ez169ICPjw88PDxw/PhxY6UHACZPnozPPvsM5eXlqKysxKefforHHnsMALBgwQJ4eHgYL3Vvd63w8HDj1+7u7vDy8kJubi4A4Pjx44iKijIZHx0dbfL9oUOHsH79epPHi42NhU6nw5kzZwAAvr6+WLNmDVasWIHOnTvXqxYRkTJwIjMRiWbgwIFYsWIFnJycEBwcDAeHhj9iZs6ciZ9//hlvvfUWunTpAldXVzzwwAMmrbBhw4bB2dkZ33zzDZycnFBVVYUHHngAAPDkk0/ioYceMo4NDg5uNCZHR0eT71UqFXQ6ndnPqaSkBE888QRmzJhR77r27dsbv/7111+h0WiQlZWF0tJSeHp6mv0YRNQymPQQkWjc3d3RpUuX647btWsXJk6ciPvvvx+APrG4dgKxg4MDJkyYgHXr1sHJyQkPP/wwXF1dAQB+fn7w8/O74Xh79OhRb2Lznj17TL6/5ZZbcOzYsSaf1+7du/Hmm2/i+++/x6xZsxAfH48PPvjghuMjInGxvUVELa5r167YuHEj0tPTcejQITzyyCMNVl8mTZqEbdu2ITk52djaEtOTTz6JkydP4vnnn0dGRgY+/fRTrF+/3mTMrFmzsHv3bsTHxyM9PR0nT57Et99+a5zIXFxcjEcffRQzZszA0KFD8cknn2DDhg346quvRI+XiG4Mkx4ianFLliyBr68vbrvtNgwbNgyxsbG45ZZb6o3r2rUrbrvtNnTv3r3e3BsxtG/fHl9//TU2bdqEiIgIrFy5EgsWLDAZEx4ejh07duDEiRPo378/+vTpg7lz5xpbak8//TTc3d2NtwsLC8OCBQvwxBNP4MKFC6LHTETNpxIEQZA7CCKihgiCgK5du2LatGlISEiQOxwisnKc00NEipSXl4fPP/8c2dnZFu/NQ0TUECY9RKRIbdq0gb+/P1atWgVfX1+5wyEiG8Ckh4gUiZ13IhIbJzITERGRXWDSQ0RERHaBSQ8RERHZBSY9REREZBeY9BAREZFdYNJDREREdoFJDxEREdkFJj1ERERkF/4ffLLkkg/3cqgAAAAASUVORK5CYII=",
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "AwayTeam = preds_game[:,0]  \n",
    "HomeTeam= preds_game[:,1]  \n",
    "\n",
    "\n",
    "plt.plot(AwayTeam, color='blue', label='Detroit Lions')\n",
    "plt.plot(HomeTeam, color='green', label='Cincinnati Bengals')\n",
    "plt.axhline(y=0.5, color='red', linestyle='--', label='50%')\n",
    "\n",
    "\n",
    "plt.xlabel('Play-Index')\n",
    "plt.ylabel('Wahrscheinlichkeit')\n",
    "\n",
    "\n",
    "plt.legend()\n",
    "\n",
    "\n",
    "plt.show()"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Hier werden die wichtigesten Plays des Spiels Cincinnati Bengals vs. Detroit Lions herausgefilter"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0.03125918\n",
      "9\n",
      "0.39367878\n",
      "0.6063212\n",
      "GameID                        401437834\n",
      "playID                     401437834251\n",
      "awayScore                             0\n",
      "homeScore                             3\n",
      "scoreValue                            3\n",
      "statYardage                          33\n",
      "quarter                               1\n",
      "clock                             10.65\n",
      "type_text               Field Goal Good\n",
      "team_play                           chi\n",
      "start_down                            4\n",
      "start_distance                       10\n",
      "start_yardlinie                      85\n",
      "start_yardsToEndzone                 15\n",
      "end_down                             -1\n",
      "end_distance                         10\n",
      "end_yardlinie                       100\n",
      "end_yardsToEndzone                   65\n",
      "season                             2022\n",
      "week                                 10\n",
      "Home_teamname                       chi\n",
      "Away_teamname                       det\n",
      "elo_score_away                 1404.406\n",
      "elo_score_home                  1431.96\n",
      "attendence                     1.005154\n",
      "time_remaining                    55.65\n",
      "leading_Team                        chi\n",
      "point_difference                    3.0\n",
      "scoring_game                          1\n",
      "Name: 9, dtype: object\n",
      "0.08023715\n",
      "25\n",
      "0.47391593\n",
      "0.52608407\n",
      "GameID                        401437834\n",
      "playID                     401437834624\n",
      "awayScore                             3\n",
      "homeScore                             3\n",
      "scoreValue                            3\n",
      "statYardage                          25\n",
      "quarter                               1\n",
      "clock                              3.35\n",
      "type_text               Field Goal Good\n",
      "team_play                           det\n",
      "start_down                            4\n",
      "start_distance                        4\n",
      "start_yardlinie                       7\n",
      "start_yardsToEndzone                  7\n",
      "end_down                             -1\n",
      "end_distance                         10\n",
      "end_yardlinie                         0\n",
      "end_yardsToEndzone                   65\n",
      "season                             2022\n",
      "week                                 10\n",
      "Home_teamname                       chi\n",
      "Away_teamname                       det\n",
      "elo_score_away                 1404.406\n",
      "elo_score_home                  1431.96\n",
      "attendence                     1.005154\n",
      "time_remaining                    48.35\n",
      "leading_Team                        tie\n",
      "point_difference                    0.0\n",
      "scoring_game                          1\n",
      "Name: 25, dtype: object\n",
      "0.08948201\n",
      "51\n",
      "0.56339794\n",
      "0.43660206\n",
      "GameID                          401437834\n",
      "playID                      4014378341231\n",
      "awayScore                              10\n",
      "homeScore                               3\n",
      "scoreValue                              6\n",
      "statYardage                             2\n",
      "quarter                                 2\n",
      "clock                                 7.3\n",
      "type_text               Passing Touchdown\n",
      "team_play                             det\n",
      "start_down                              4\n",
      "start_distance                          2\n",
      "start_yardlinie                         2\n",
      "start_yardsToEndzone                    2\n",
      "end_down                               -1\n",
      "end_distance                           10\n",
      "end_yardlinie                           0\n",
      "end_yardsToEndzone                     15\n",
      "season                               2022\n",
      "week                                   10\n",
      "Home_teamname                         chi\n",
      "Away_teamname                         det\n",
      "elo_score_away                   1404.406\n",
      "elo_score_home                    1431.96\n",
      "attendence                       1.005154\n",
      "time_remaining                       37.3\n",
      "leading_Team                          det\n",
      "point_difference                      7.0\n",
      "scoring_game                            1\n",
      "Name: 51, dtype: object\n",
      "0.108695745\n",
      "71\n",
      "0.4547022\n",
      "0.5452978\n",
      "GameID                          401437834\n",
      "playID                      4014378341663\n",
      "awayScore                              10\n",
      "homeScore                              10\n",
      "scoreValue                              6\n",
      "statYardage                             1\n",
      "quarter                                 2\n",
      "clock                                 0.2\n",
      "type_text               Rushing Touchdown\n",
      "team_play                             chi\n",
      "start_down                              3\n",
      "start_distance                          1\n",
      "start_yardlinie                        99\n",
      "start_yardsToEndzone                    1\n",
      "end_down                               -1\n",
      "end_distance                           10\n",
      "end_yardlinie                         100\n",
      "end_yardsToEndzone                     15\n",
      "season                               2022\n",
      "week                                   10\n",
      "Home_teamname                         chi\n",
      "Away_teamname                         det\n",
      "elo_score_away                   1404.406\n",
      "elo_score_home                    1431.96\n",
      "attendence                       1.005154\n",
      "time_remaining                       30.2\n",
      "leading_Team                          tie\n",
      "point_difference                      0.0\n",
      "scoring_game                            1\n",
      "Name: 71, dtype: object\n",
      "0.1718198\n",
      "91\n",
      "0.2828824\n",
      "0.7171176\n",
      "GameID                          401437834\n",
      "playID                      4014378342097\n",
      "awayScore                              10\n",
      "homeScore                              17\n",
      "scoreValue                              6\n",
      "statYardage                             6\n",
      "quarter                                 3\n",
      "clock                                 7.6\n",
      "type_text               Passing Touchdown\n",
      "team_play                             chi\n",
      "start_down                              1\n",
      "start_distance                          6\n",
      "start_yardlinie                        94\n",
      "start_yardsToEndzone                    6\n",
      "end_down                               -1\n",
      "end_distance                           10\n",
      "end_yardlinie                         100\n",
      "end_yardsToEndzone                     15\n",
      "season                               2022\n",
      "week                                   10\n",
      "Home_teamname                         chi\n",
      "Away_teamname                         det\n",
      "elo_score_away                   1404.406\n",
      "elo_score_home                    1431.96\n",
      "attendence                       1.005154\n",
      "time_remaining                       22.6\n",
      "leading_Team                          chi\n",
      "point_difference                      7.0\n",
      "scoring_game                            1\n",
      "Name: 91, dtype: object\n",
      "0.13254762\n",
      "103\n",
      "0.15033478\n",
      "0.8496652\n",
      "GameID                          401437834\n",
      "playID                      4014378342387\n",
      "awayScore                              10\n",
      "homeScore                              24\n",
      "scoreValue                              6\n",
      "statYardage                            50\n",
      "quarter                                 3\n",
      "clock                            2.716667\n",
      "type_text               Passing Touchdown\n",
      "team_play                             chi\n",
      "start_down                              2\n",
      "start_distance                          1\n",
      "start_yardlinie                        50\n",
      "start_yardsToEndzone                   50\n",
      "end_down                               -1\n",
      "end_distance                           10\n",
      "end_yardlinie                         100\n",
      "end_yardsToEndzone                     15\n",
      "season                               2022\n",
      "week                                   10\n",
      "Home_teamname                         chi\n",
      "Away_teamname                         det\n",
      "elo_score_away                   1404.406\n",
      "elo_score_home                    1431.96\n",
      "attendence                       1.005154\n",
      "time_remaining                  17.716667\n",
      "leading_Team                          chi\n",
      "point_difference                     14.0\n",
      "scoring_game                            2\n",
      "Name: 103, dtype: object\n",
      "0.07297486\n",
      "124\n",
      "0.22330964\n",
      "0.77669036\n",
      "GameID                          401437834\n",
      "playID                      4014378342858\n",
      "awayScore                              17\n",
      "homeScore                              24\n",
      "scoreValue                              6\n",
      "statYardage                             9\n",
      "quarter                                 4\n",
      "clock                           11.616667\n",
      "type_text               Rushing Touchdown\n",
      "team_play                             det\n",
      "start_down                              1\n",
      "start_distance                          9\n",
      "start_yardlinie                         9\n",
      "start_yardsToEndzone                    9\n",
      "end_down                               -1\n",
      "end_distance                           10\n",
      "end_yardlinie                           0\n",
      "end_yardsToEndzone                     15\n",
      "season                               2022\n",
      "week                                   10\n",
      "Home_teamname                         chi\n",
      "Away_teamname                         det\n",
      "elo_score_away                   1404.406\n",
      "elo_score_home                    1431.96\n",
      "attendence                       1.005154\n",
      "time_remaining                  11.616667\n",
      "leading_Team                          chi\n",
      "point_difference                      7.0\n",
      "scoring_game                            1\n",
      "Name: 124, dtype: object\n",
      "0.42133665\n",
      "128\n",
      "0.6446463\n",
      "0.3553537\n",
      "GameID                                      401437834\n",
      "playID                                  4014378342974\n",
      "awayScore                                          24\n",
      "homeScore                                          24\n",
      "scoreValue                                          6\n",
      "statYardage                                        20\n",
      "quarter                                             4\n",
      "clock                                       10.483333\n",
      "type_text               Interception Return Touchdown\n",
      "team_play                                         chi\n",
      "start_down                                          2\n",
      "start_distance                                     18\n",
      "start_yardlinie                                    17\n",
      "start_yardsToEndzone                               83\n",
      "end_down                                           -1\n",
      "end_distance                                       10\n",
      "end_yardlinie                                       0\n",
      "end_yardsToEndzone                                 15\n",
      "season                                           2022\n",
      "week                                               10\n",
      "Home_teamname                                     chi\n",
      "Away_teamname                                     det\n",
      "elo_score_away                               1404.406\n",
      "elo_score_home                                1431.96\n",
      "attendence                                   1.005154\n",
      "time_remaining                              10.483333\n",
      "leading_Team                                      tie\n",
      "point_difference                                  0.0\n",
      "scoring_game                                        1\n",
      "Name: 128, dtype: object\n",
      "0.08342254\n",
      "133\n",
      "0.56122375\n",
      "0.43877622\n",
      "GameID                          401437834\n",
      "playID                      4014378343092\n",
      "awayScore                              24\n",
      "homeScore                              30\n",
      "scoreValue                              6\n",
      "statYardage                            67\n",
      "quarter                                 4\n",
      "clock                            9.183333\n",
      "type_text               Rushing Touchdown\n",
      "team_play                             chi\n",
      "start_down                              3\n",
      "start_distance                          2\n",
      "start_yardlinie                        33\n",
      "start_yardsToEndzone                   67\n",
      "end_down                               -1\n",
      "end_distance                           10\n",
      "end_yardlinie                         100\n",
      "end_yardsToEndzone                     15\n",
      "season                               2022\n",
      "week                                   10\n",
      "Home_teamname                         chi\n",
      "Away_teamname                         det\n",
      "elo_score_away                   1404.406\n",
      "elo_score_home                    1431.96\n",
      "attendence                       1.005154\n",
      "time_remaining                   9.183333\n",
      "leading_Team                          chi\n",
      "point_difference                      6.0\n",
      "scoring_game                            1\n",
      "Name: 133, dtype: object\n",
      "0.05732894\n",
      "152\n",
      "0.6185527\n",
      "0.38144732\n",
      "GameID                          401437834\n",
      "playID                      4014378343523\n",
      "awayScore                              31\n",
      "homeScore                              30\n",
      "scoreValue                              6\n",
      "statYardage                             1\n",
      "quarter                                 4\n",
      "clock                                2.35\n",
      "type_text               Rushing Touchdown\n",
      "team_play                             det\n",
      "start_down                              1\n",
      "start_distance                          1\n",
      "start_yardlinie                         1\n",
      "start_yardsToEndzone                    1\n",
      "end_down                               -1\n",
      "end_distance                           10\n",
      "end_yardlinie                           0\n",
      "end_yardsToEndzone                     15\n",
      "season                               2022\n",
      "week                                   10\n",
      "Home_teamname                         chi\n",
      "Away_teamname                         det\n",
      "elo_score_away                   1404.406\n",
      "elo_score_home                    1431.96\n",
      "attendence                       1.005154\n",
      "time_remaining                       2.35\n",
      "leading_Team                          det\n",
      "point_difference                      1.0\n",
      "scoring_game                            1\n",
      "Name: 152, dtype: object\n"
     ]
    }
   ],
   "source": [
    "\n",
    "preds_game=preds_wshl_xgb[(data['GameID']==\t401437834)]\n",
    "game= data[data['GameID']==401437834].reset_index(drop=True)\n",
    "\n",
    "for proba in range(len(preds_game)-1):\n",
    "        wshl = abs(preds_game[:,0][proba+1]-preds_game[:,0][proba])\n",
    "        if wshl>0 :\n",
    "            print(wshl)\n",
    "            print(proba+1)\n",
    "            print(preds_game[:,0][proba+1])\n",
    "            print(preds_game[:,1][proba+1])\n",
    "            print(game.iloc[proba+1])\n",
    "            \n",
    "        "
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Hier wird der beste 'Pass Reception' Spielzug der Saison 2022 gesucht"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "season_2022 = data[(data['season']==2022)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0.07297486\n",
      "GameID                       401437735\n",
      "playID                   4014377354183\n",
      "awayScore                           17\n",
      "homeScore                           29\n",
      "scoreValue                           6\n",
      "statYardage                          0\n",
      "quarter                              4\n",
      "clock                              0.0\n",
      "type_text               Pass Reception\n",
      "team_play                          pit\n",
      "start_down                           1\n",
      "start_distance                      10\n",
      "start_yardlinie                     96\n",
      "start_yardsToEndzone                96\n",
      "end_down                            -1\n",
      "end_distance                        10\n",
      "end_yardlinie                      100\n",
      "end_yardsToEndzone                  15\n",
      "season                            2022\n",
      "week                                 3\n",
      "Home_teamname                      cle\n",
      "Away_teamname                      pit\n",
      "elo_score_away                 1511.81\n",
      "elo_score_home                 1504.49\n",
      "attendence                         1.0\n",
      "time_remaining                     0.0\n",
      "leading_Team                       cle\n",
      "point_difference                  12.0\n",
      "scoring_game                         2\n",
      "Name: 171, dtype: object\n",
      "0.05778265\n",
      "GameID                       401437738\n",
      "playID                   4014377384086\n",
      "awayScore                           17\n",
      "homeScore                           21\n",
      "scoreValue                           0\n",
      "statYardage                         12\n",
      "quarter                              4\n",
      "clock                              0.3\n",
      "type_text               Pass Reception\n",
      "team_play                          buf\n",
      "start_down                           2\n",
      "start_distance                      20\n",
      "start_yardlinie                     53\n",
      "start_yardsToEndzone                53\n",
      "end_down                             3\n",
      "end_distance                         8\n",
      "end_yardlinie                       41\n",
      "end_yardsToEndzone                  40\n",
      "season                            2022\n",
      "week                                 3\n",
      "Home_teamname                      mia\n",
      "Away_teamname                      buf\n",
      "elo_score_away                  1669.8\n",
      "elo_score_home                 1578.58\n",
      "attendence                    1.022218\n",
      "time_remaining                     0.3\n",
      "leading_Team                       mia\n",
      "point_difference                   4.0\n",
      "scoring_game                         1\n",
      "Name: 169, dtype: object\n",
      "0.068615794\n",
      "GameID                       401437782\n",
      "playID                   4014377821177\n",
      "awayScore                            0\n",
      "homeScore                            0\n",
      "scoreValue                           0\n",
      "statYardage                         17\n",
      "quarter                              2\n",
      "clock                        10.866667\n",
      "type_text               Pass Reception\n",
      "team_play                          mia\n",
      "start_down                           2\n",
      "start_distance                      11\n",
      "start_yardlinie                     37\n",
      "start_yardsToEndzone                63\n",
      "end_down                             1\n",
      "end_distance                        10\n",
      "end_yardlinie                       54\n",
      "end_yardsToEndzone                  46\n",
      "season                            2022\n",
      "week                                 6\n",
      "Home_teamname                      mia\n",
      "Away_teamname                      min\n",
      "elo_score_away                 1549.62\n",
      "elo_score_home                 1520.15\n",
      "attendence                    1.020581\n",
      "time_remaining               40.866667\n",
      "leading_Team                       tie\n",
      "point_difference                   0.0\n",
      "scoring_game                         1\n",
      "Name: 47, dtype: object\n",
      "0.07781702\n",
      "GameID                       401437790\n",
      "playID                    401437790455\n",
      "awayScore                            3\n",
      "homeScore                            0\n",
      "scoreValue                           0\n",
      "statYardage                          7\n",
      "quarter                              1\n",
      "clock                         7.333333\n",
      "type_text               Pass Reception\n",
      "team_play                          den\n",
      "start_down                           1\n",
      "start_distance                      10\n",
      "start_yardlinie                     38\n",
      "start_yardsToEndzone                38\n",
      "end_down                             1\n",
      "end_distance                        12\n",
      "end_yardlinie                       31\n",
      "end_yardsToEndzone                  65\n",
      "season                            2022\n",
      "week                                 6\n",
      "Home_teamname                       sd\n",
      "Away_teamname                      den\n",
      "elo_score_away                 1431.44\n",
      "elo_score_home                 1495.69\n",
      "attendence                    0.982378\n",
      "time_remaining               52.333333\n",
      "leading_Team                       den\n",
      "point_difference                   3.0\n",
      "scoring_game                         1\n",
      "Name: 18, dtype: object\n",
      "0.06609213\n",
      "GameID                       401437131\n",
      "playID                   4014371311102\n",
      "awayScore                            0\n",
      "homeScore                            0\n",
      "scoreValue                           0\n",
      "statYardage                          5\n",
      "quarter                              2\n",
      "clock                        10.883333\n",
      "type_text               Pass Reception\n",
      "team_play                          dal\n",
      "start_down                           2\n",
      "start_distance                       4\n",
      "start_yardlinie                     13\n",
      "start_yardsToEndzone                13\n",
      "end_down                             1\n",
      "end_distance                        10\n",
      "end_yardlinie                        8\n",
      "end_yardsToEndzone                   8\n",
      "season                            2022\n",
      "week                                10\n",
      "Home_teamname                       gb\n",
      "Away_teamname                      dal\n",
      "elo_score_away                 1606.85\n",
      "elo_score_home                 1475.74\n",
      "attendence                    0.967819\n",
      "time_remaining               40.883333\n",
      "leading_Team                       tie\n",
      "point_difference                   0.0\n",
      "scoring_game                         1\n",
      "Name: 45, dtype: object\n",
      "0.07977778\n",
      "GameID                       401437843\n",
      "playID                   4014378434016\n",
      "awayScore                           32\n",
      "homeScore                           21\n",
      "scoreValue                           6\n",
      "statYardage                          1\n",
      "quarter                              4\n",
      "clock                              0.0\n",
      "type_text               Pass Reception\n",
      "team_play                          phi\n",
      "start_down                           1\n",
      "start_distance                      10\n",
      "start_yardlinie                     10\n",
      "start_yardsToEndzone                90\n",
      "end_down                            -1\n",
      "end_distance                        10\n",
      "end_yardlinie                        0\n",
      "end_yardsToEndzone                  15\n",
      "season                            2022\n",
      "week                                10\n",
      "Home_teamname                      phi\n",
      "Away_teamname                      wsh\n",
      "elo_score_away                 1435.58\n",
      "elo_score_home                 1633.43\n",
      "attendence                         1.0\n",
      "time_remaining                     0.0\n",
      "leading_Team                       wsh\n",
      "point_difference                  11.0\n",
      "scoring_game                         2\n",
      "Name: 169, dtype: object\n",
      "0.065957904\n",
      "GameID                       401437890\n",
      "playID                   4014378901327\n",
      "awayScore                            0\n",
      "homeScore                            0\n",
      "scoreValue                           0\n",
      "statYardage                          4\n",
      "quarter                              2\n",
      "clock                        11.083333\n",
      "type_text               Pass Reception\n",
      "team_play                          cin\n",
      "start_down                           2\n",
      "start_distance                       7\n",
      "start_yardlinie                     73\n",
      "start_yardsToEndzone                27\n",
      "end_down                             3\n",
      "end_distance                        10\n",
      "end_yardlinie                       77\n",
      "end_yardsToEndzone                  23\n",
      "season                            2022\n",
      "week                                14\n",
      "Home_teamname                      cin\n",
      "Away_teamname                      cle\n",
      "elo_score_away                 1466.93\n",
      "elo_score_home                 1622.42\n",
      "attendence                    1.010791\n",
      "time_remaining               41.083333\n",
      "leading_Team                       tie\n",
      "point_difference                   0.0\n",
      "scoring_game                         1\n",
      "Name: 52, dtype: object\n",
      "0.069273114\n",
      "GameID                       401437954\n",
      "playID                    401437954994\n",
      "awayScore                            3\n",
      "homeScore                            0\n",
      "scoreValue                           0\n",
      "statYardage                          5\n",
      "quarter                              2\n",
      "clock                             10.9\n",
      "type_text               Pass Reception\n",
      "team_play                          jax\n",
      "start_down                           1\n",
      "start_distance                      10\n",
      "start_yardlinie                     65\n",
      "start_yardsToEndzone                35\n",
      "end_down                             2\n",
      "end_distance                        10\n",
      "end_yardlinie                       70\n",
      "end_yardsToEndzone                  30\n",
      "season                            2022\n",
      "week                                18\n",
      "Home_teamname                      jax\n",
      "Away_teamname                      ten\n",
      "elo_score_away                 1454.07\n",
      "elo_score_home                 1507.16\n",
      "attendence                    1.032303\n",
      "time_remaining                    40.9\n",
      "leading_Team                       ten\n",
      "point_difference                   3.0\n",
      "scoring_game                         1\n",
      "Name: 40, dtype: object\n",
      "0.069015205\n",
      "GameID                       401437958\n",
      "playID                   4014379581211\n",
      "awayScore                            0\n",
      "homeScore                            0\n",
      "scoreValue                           0\n",
      "statYardage                         14\n",
      "quarter                              2\n",
      "clock                        10.616667\n",
      "type_text               Pass Reception\n",
      "team_play                          cle\n",
      "start_down                           3\n",
      "start_distance                       3\n",
      "start_yardlinie                     64\n",
      "start_yardsToEndzone                64\n",
      "end_down                             1\n",
      "end_distance                        10\n",
      "end_yardlinie                       50\n",
      "end_yardsToEndzone                  50\n",
      "season                            2022\n",
      "week                                18\n",
      "Home_teamname                      pit\n",
      "Away_teamname                      cle\n",
      "elo_score_away                 1516.53\n",
      "elo_score_home                 1533.11\n",
      "attendence                     0.95057\n",
      "time_remaining               40.616667\n",
      "leading_Team                       tie\n",
      "point_difference                   0.0\n",
      "scoring_game                         1\n",
      "Name: 46, dtype: object\n",
      "0.13790798\n",
      "GameID                       401437857\n",
      "playID                   4014378571439\n",
      "awayScore                            8\n",
      "homeScore                            7\n",
      "scoreValue                           0\n",
      "statYardage                          7\n",
      "quarter                              2\n",
      "clock                         6.666667\n",
      "type_text               Pass Reception\n",
      "team_play                          det\n",
      "start_down                           3\n",
      "start_distance                       8\n",
      "start_yardlinie                     26\n",
      "start_yardsToEndzone                74\n",
      "end_down                             4\n",
      "end_distance                         3\n",
      "end_yardlinie                       33\n",
      "end_yardsToEndzone                  67\n",
      "season                            2022\n",
      "week                                12\n",
      "Home_teamname                      det\n",
      "Away_teamname                      buf\n",
      "elo_score_away                  1671.5\n",
      "elo_score_home                 1431.05\n",
      "attendence                    1.031829\n",
      "time_remaining               36.666667\n",
      "leading_Team                       buf\n",
      "point_difference                   1.0\n",
      "scoring_game                         1\n",
      "Name: 56, dtype: object\n",
      "0.06609213\n",
      "GameID                       401437793\n",
      "playID                   4014377931037\n",
      "awayScore                            0\n",
      "homeScore                            0\n",
      "scoreValue                           0\n",
      "statYardage                          6\n",
      "quarter                              2\n",
      "clock                            10.85\n",
      "type_text               Pass Reception\n",
      "team_play                          car\n",
      "start_down                           2\n",
      "start_distance                       1\n",
      "start_yardlinie                     59\n",
      "start_yardsToEndzone                41\n",
      "end_down                             1\n",
      "end_distance                        10\n",
      "end_yardlinie                       65\n",
      "end_yardsToEndzone                  35\n",
      "season                            2022\n",
      "week                                 7\n",
      "Home_teamname                      car\n",
      "Away_teamname                       tb\n",
      "elo_score_away                 1608.57\n",
      "elo_score_home                 1364.42\n",
      "attendence                    0.975101\n",
      "time_remaining                   40.85\n",
      "leading_Team                       tie\n",
      "point_difference                   0.0\n",
      "scoring_game                         1\n",
      "Name: 40, dtype: object\n",
      "0.065957904\n",
      "GameID                       401437846\n",
      "playID                   4014378461001\n",
      "awayScore                            0\n",
      "homeScore                            0\n",
      "scoreValue                           0\n",
      "statYardage                         13\n",
      "quarter                              2\n",
      "clock                        11.083333\n",
      "type_text               Pass Reception\n",
      "team_play                          bal\n",
      "start_down                           3\n",
      "start_distance                      13\n",
      "start_yardlinie                     46\n",
      "start_yardsToEndzone                54\n",
      "end_down                             1\n",
      "end_distance                        10\n",
      "end_yardlinie                       59\n",
      "end_yardsToEndzone                  41\n",
      "season                            2022\n",
      "week                                11\n",
      "Home_teamname                      bal\n",
      "Away_teamname                      car\n",
      "elo_score_away                 1415.31\n",
      "elo_score_home                 1583.95\n",
      "attendence                    0.999039\n",
      "time_remaining               41.083333\n",
      "leading_Team                       tie\n",
      "point_difference                   0.0\n",
      "scoring_game                         1\n",
      "Name: 41, dtype: object\n",
      "0.06883848\n",
      "GameID                       401437931\n",
      "playID                   4014379311094\n",
      "awayScore                            0\n",
      "homeScore                            0\n",
      "scoreValue                           0\n",
      "statYardage                         18\n",
      "quarter                              2\n",
      "clock                        11.183333\n",
      "type_text               Pass Reception\n",
      "team_play                           sd\n",
      "start_down                           2\n",
      "start_distance                       9\n",
      "start_yardlinie                     30\n",
      "start_yardsToEndzone                30\n",
      "end_down                             1\n",
      "end_distance                         3\n",
      "end_yardlinie                       12\n",
      "end_yardsToEndzone                  12\n",
      "season                            2022\n",
      "week                                16\n",
      "Home_teamname                      ind\n",
      "Away_teamname                       sd\n",
      "elo_score_away                 1494.57\n",
      "elo_score_home                 1434.15\n",
      "attendence                    1.040889\n",
      "time_remaining               41.183333\n",
      "leading_Team                       tie\n",
      "point_difference                   0.0\n",
      "scoring_game                         1\n",
      "Name: 42, dtype: object\n"
     ]
    }
   ],
   "source": [
    "\n",
    "for Game in season_2022['GameID'].unique():\n",
    "    preds_game = preds_wshl_xgb[(data['GameID']==Game)]\n",
    "    season_2022_reindex_game = season_2022[season_2022['GameID']==Game].reset_index(drop=True)\n",
    "    for proba in range(len(preds_game)-1):\n",
    "        wshl1 = abs(preds_game[:,0][proba+1]-preds_game[:,0][proba])\n",
    "        if season_2022_reindex_game.iloc[proba+1]['type_text']=='Pass Reception' and wshl1>0:\n",
    "            print(wshl1)\n",
    "            print(season_2022_reindex_game.iloc[proba+1])\n",
    "            \n",
    "       \n",
    "    "
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.8"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}