Combine Events.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('data/lynx_ppl.csv', header=None)\n",
    "df.drop(columns=4, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.columns = ['athleteNumber', 'lastName', 'firstName', 'team', 'sex', 'eventNumber']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_all_events(group):\n",
    "    eventNumbers = group.eventNumber.tolist()\n",
    "    strEventNumbers = [str(num) for num in eventNumbers]\n",
    "    group['eventNumbers'] = ','.join(strEventNumbers)\n",
    "    return group"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.groupby(by='athleteNumber').apply(get_all_events)\n",
    "df.drop(columns='eventNumber', inplace=True)\n",
    "df.drop_duplicates(subset='athleteNumber', inplace=True)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>athleteNumber</th>\n",
       "      <th>lastName</th>\n",
       "      <th>firstName</th>\n",
       "      <th>team</th>\n",
       "      <th>sex</th>\n",
       "      <th>eventNumber</th>\n",
       "      <th>eventNumbers</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10</td>\n",
       "      <td>Spires</td>\n",
       "      <td>Shelley</td>\n",
       "      <td>AFA</td>\n",
       "      <td>F</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>11</td>\n",
       "      <td>Rhoads</td>\n",
       "      <td>Michael</td>\n",
       "      <td>AFA</td>\n",
       "      <td>M</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>12</td>\n",
       "      <td>Bryan</td>\n",
       "      <td>Lucy</td>\n",
       "      <td>AKR</td>\n",
       "      <td>F</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>13</td>\n",
       "      <td>Siefring</td>\n",
       "      <td>Jaclyn</td>\n",
       "      <td>AKR</td>\n",
       "      <td>F</td>\n",
       "      <td>34</td>\n",
       "      <td>34,29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>14</td>\n",
       "      <td>Latimer</td>\n",
       "      <td>Jordan</td>\n",
       "      <td>AKR</td>\n",
       "      <td>M</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>15</td>\n",
       "      <td>Ludwig</td>\n",
       "      <td>Matthew</td>\n",
       "      <td>AKR</td>\n",
       "      <td>M</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>16</td>\n",
       "      <td>Clark</td>\n",
       "      <td>Tamara</td>\n",
       "      <td>BAMA</td>\n",
       "      <td>F</td>\n",
       "      <td>18</td>\n",
       "      <td>18,17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>17</td>\n",
       "      <td>Darius</td>\n",
       "      <td>Symone</td>\n",
       "      <td>BAMA</td>\n",
       "      <td>F</td>\n",
       "      <td>18</td>\n",
       "      <td>18,17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>18</td>\n",
       "      <td>Destin</td>\n",
       "      <td>Stacey</td>\n",
       "      <td>BAMA</td>\n",
       "      <td>F</td>\n",
       "      <td>34</td>\n",
       "      <td>34,27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>19</td>\n",
       "      <td>Lampkin</td>\n",
       "      <td>Daija</td>\n",
       "      <td>BAMA</td>\n",
       "      <td>F</td>\n",
       "      <td>17</td>\n",
       "      <td>17,18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>20</td>\n",
       "      <td>Prieto</td>\n",
       "      <td>Mauricia</td>\n",
       "      <td>BAMA</td>\n",
       "      <td>F</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>21</td>\n",
       "      <td>Roberson</td>\n",
       "      <td>Takyera</td>\n",
       "      <td>BAMA</td>\n",
       "      <td>F</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>22</td>\n",
       "      <td>Warren</td>\n",
       "      <td>Portious</td>\n",
       "      <td>BAMA</td>\n",
       "      <td>F</td>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>24</td>\n",
       "      <td>Ferguson</td>\n",
       "      <td>Kord</td>\n",
       "      <td>BAMA</td>\n",
       "      <td>M</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>25</td>\n",
       "      <td>Haugh</td>\n",
       "      <td>Daniel</td>\n",
       "      <td>BAMA</td>\n",
       "      <td>M</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>26</td>\n",
       "      <td>Kigen</td>\n",
       "      <td>Gilbert</td>\n",
       "      <td>BAMA</td>\n",
       "      <td>M</td>\n",
       "      <td>6</td>\n",
       "      <td>6,7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>27</td>\n",
       "      <td>Kiprop</td>\n",
       "      <td>Vincent</td>\n",
       "      <td>BAMA</td>\n",
       "      <td>M</td>\n",
       "      <td>7</td>\n",
       "      <td>7,6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>28</td>\n",
       "      <td>McEwen</td>\n",
       "      <td>Shelby</td>\n",
       "      <td>BAMA</td>\n",
       "      <td>M</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>29</td>\n",
       "      <td>Walters</td>\n",
       "      <td>Ruebin</td>\n",
       "      <td>BAMA</td>\n",
       "      <td>M</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>30</td>\n",
       "      <td>Green</td>\n",
       "      <td>Claire</td>\n",
       "      <td>ARIZ</td>\n",
       "      <td>F</td>\n",
       "      <td>22</td>\n",
       "      <td>22,21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>31</td>\n",
       "      <td>Geist</td>\n",
       "      <td>Jordan</td>\n",
       "      <td>ARIZ</td>\n",
       "      <td>M</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>32</td>\n",
       "      <td>Villarreal</td>\n",
       "      <td>Carlos</td>\n",
       "      <td>ARIZ</td>\n",
       "      <td>M</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>33</td>\n",
       "      <td>Ewen</td>\n",
       "      <td>Maggie</td>\n",
       "      <td>AZST</td>\n",
       "      <td>F</td>\n",
       "      <td>32</td>\n",
       "      <td>32,31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>34</td>\n",
       "      <td>Baylark</td>\n",
       "      <td>Jada</td>\n",
       "      <td>ARK</td>\n",
       "      <td>F</td>\n",
       "      <td>18</td>\n",
       "      <td>18,17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>35</td>\n",
       "      <td>Brooks</td>\n",
       "      <td>Taliyah</td>\n",
       "      <td>ARK</td>\n",
       "      <td>F</td>\n",
       "      <td>27</td>\n",
       "      <td>27,24,17,29,34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>36</td>\n",
       "      <td>Brown</td>\n",
       "      <td>Janeek</td>\n",
       "      <td>ARK</td>\n",
       "      <td>F</td>\n",
       "      <td>24</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>37</td>\n",
       "      <td>Burks Magee</td>\n",
       "      <td>Morgan</td>\n",
       "      <td>ARK</td>\n",
       "      <td>F</td>\n",
       "      <td>19</td>\n",
       "      <td>19,26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>38</td>\n",
       "      <td>Chadwick</td>\n",
       "      <td>Payton</td>\n",
       "      <td>ARK</td>\n",
       "      <td>F</td>\n",
       "      <td>19</td>\n",
       "      <td>19,17,24,29,18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>39</td>\n",
       "      <td>Freier</td>\n",
       "      <td>Desiree</td>\n",
       "      <td>ARK</td>\n",
       "      <td>F</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>40</td>\n",
       "      <td>Hiltz</td>\n",
       "      <td>Nikki</td>\n",
       "      <td>ARK</td>\n",
       "      <td>F</td>\n",
       "      <td>21</td>\n",
       "      <td>21,22,20,26</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>879</th>\n",
       "      <td>214</td>\n",
       "      <td>Browning</td>\n",
       "      <td>Teddy</td>\n",
       "      <td>IU</td>\n",
       "      <td>M</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>883</th>\n",
       "      <td>220</td>\n",
       "      <td>Muncherji</td>\n",
       "      <td>Zubin</td>\n",
       "      <td>IU</td>\n",
       "      <td>M</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>885</th>\n",
       "      <td>233</td>\n",
       "      <td>Hofacker</td>\n",
       "      <td>Collin</td>\n",
       "      <td>IOWA</td>\n",
       "      <td>M</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>886</th>\n",
       "      <td>234</td>\n",
       "      <td>Thompson</td>\n",
       "      <td>Chris</td>\n",
       "      <td>IOWA</td>\n",
       "      <td>M</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>888</th>\n",
       "      <td>238</td>\n",
       "      <td>Cooney</td>\n",
       "      <td>Riley</td>\n",
       "      <td>KU</td>\n",
       "      <td>F</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>889</th>\n",
       "      <td>239</td>\n",
       "      <td>Coppinger</td>\n",
       "      <td>Courtney</td>\n",
       "      <td>KU</td>\n",
       "      <td>F</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>890</th>\n",
       "      <td>240</td>\n",
       "      <td>Dimmick</td>\n",
       "      <td>Hannah</td>\n",
       "      <td>KU</td>\n",
       "      <td>F</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>903</th>\n",
       "      <td>343</td>\n",
       "      <td>Jones</td>\n",
       "      <td>Steffi</td>\n",
       "      <td>UNM</td>\n",
       "      <td>F</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>904</th>\n",
       "      <td>345</td>\n",
       "      <td>Keller</td>\n",
       "      <td>Shalom</td>\n",
       "      <td>UNM</td>\n",
       "      <td>F</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>910</th>\n",
       "      <td>352</td>\n",
       "      <td>Haywood</td>\n",
       "      <td>Mark</td>\n",
       "      <td>UNM</td>\n",
       "      <td>M</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>920</th>\n",
       "      <td>369</td>\n",
       "      <td>Keller</td>\n",
       "      <td>Annasophia</td>\n",
       "      <td>ND</td>\n",
       "      <td>F</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>921</th>\n",
       "      <td>370</td>\n",
       "      <td>Miller</td>\n",
       "      <td>Payton</td>\n",
       "      <td>ND</td>\n",
       "      <td>F</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>922</th>\n",
       "      <td>371</td>\n",
       "      <td>Murray</td>\n",
       "      <td>Samantha</td>\n",
       "      <td>ND</td>\n",
       "      <td>F</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>924</th>\n",
       "      <td>373</td>\n",
       "      <td>Cheatham</td>\n",
       "      <td>Edward</td>\n",
       "      <td>ND</td>\n",
       "      <td>M</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>926</th>\n",
       "      <td>375</td>\n",
       "      <td>Goldman</td>\n",
       "      <td>Clayton</td>\n",
       "      <td>ND</td>\n",
       "      <td>M</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>927</th>\n",
       "      <td>376</td>\n",
       "      <td>Hansen</td>\n",
       "      <td>Kirk</td>\n",
       "      <td>ND</td>\n",
       "      <td>M</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>929</th>\n",
       "      <td>378</td>\n",
       "      <td>Silva</td>\n",
       "      <td>Elijah</td>\n",
       "      <td>ND</td>\n",
       "      <td>M</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>931</th>\n",
       "      <td>389</td>\n",
       "      <td>Cooper</td>\n",
       "      <td>Joseph</td>\n",
       "      <td>OHST</td>\n",
       "      <td>M</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>933</th>\n",
       "      <td>401</td>\n",
       "      <td>Coleman</td>\n",
       "      <td>Amira</td>\n",
       "      <td>OKST</td>\n",
       "      <td>F</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>935</th>\n",
       "      <td>403</td>\n",
       "      <td>Hetherington</td>\n",
       "      <td>Abbie</td>\n",
       "      <td>OKST</td>\n",
       "      <td>F</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>937</th>\n",
       "      <td>405</td>\n",
       "      <td>Wesley</td>\n",
       "      <td>Ambra</td>\n",
       "      <td>OKST</td>\n",
       "      <td>F</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>939</th>\n",
       "      <td>409</td>\n",
       "      <td>Bethmann</td>\n",
       "      <td>Cade</td>\n",
       "      <td>MISS</td>\n",
       "      <td>M</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>940</th>\n",
       "      <td>410</td>\n",
       "      <td>Domanic</td>\n",
       "      <td>Robert</td>\n",
       "      <td>MISS</td>\n",
       "      <td>M</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>944</th>\n",
       "      <td>414</td>\n",
       "      <td>Westbrook</td>\n",
       "      <td>Alvin</td>\n",
       "      <td>MISS</td>\n",
       "      <td>M</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>965</th>\n",
       "      <td>484</td>\n",
       "      <td>Mongiovi</td>\n",
       "      <td>Missy</td>\n",
       "      <td>STAN</td>\n",
       "      <td>F</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>966</th>\n",
       "      <td>486</td>\n",
       "      <td>Wilson</td>\n",
       "      <td>Carolyn</td>\n",
       "      <td>STAN</td>\n",
       "      <td>F</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>968</th>\n",
       "      <td>491</td>\n",
       "      <td>McGorty</td>\n",
       "      <td>Brandon</td>\n",
       "      <td>STAN</td>\n",
       "      <td>M</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>969</th>\n",
       "      <td>492</td>\n",
       "      <td>McGorty</td>\n",
       "      <td>Sean</td>\n",
       "      <td>STAN</td>\n",
       "      <td>M</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>970</th>\n",
       "      <td>493</td>\n",
       "      <td>Sathyamurthy</td>\n",
       "      <td>Hari</td>\n",
       "      <td>STAN</td>\n",
       "      <td>M</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>975</th>\n",
       "      <td>531</td>\n",
       "      <td>Owens</td>\n",
       "      <td>Jarra</td>\n",
       "      <td>TAMU</td>\n",
       "      <td>F</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>604 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     athleteNumber      lastName   firstName  team sex  eventNumber  \\\n",
       "0               10        Spires     Shelley   AFA   F           27   \n",
       "1               11        Rhoads     Michael   AFA   M            4   \n",
       "2               12         Bryan        Lucy   AKR   F           28   \n",
       "3               13      Siefring      Jaclyn   AKR   F           34   \n",
       "5               14       Latimer      Jordan   AKR   M           13   \n",
       "6               15        Ludwig     Matthew   AKR   M           12   \n",
       "7               16         Clark      Tamara  BAMA   F           18   \n",
       "9               17        Darius      Symone  BAMA   F           18   \n",
       "11              18        Destin      Stacey  BAMA   F           34   \n",
       "13              19       Lampkin       Daija  BAMA   F           17   \n",
       "15              20        Prieto    Mauricia  BAMA   F           19   \n",
       "16              21      Roberson     Takyera  BAMA   F           19   \n",
       "17              22        Warren    Portious  BAMA   F           31   \n",
       "18              24      Ferguson        Kord  BAMA   M           15   \n",
       "19              25         Haugh      Daniel  BAMA   M           16   \n",
       "20              26         Kigen     Gilbert  BAMA   M            6   \n",
       "22              27        Kiprop     Vincent  BAMA   M            7   \n",
       "24              28        McEwen      Shelby  BAMA   M           11   \n",
       "25              29       Walters      Ruebin  BAMA   M            8   \n",
       "26              30         Green      Claire  ARIZ   F           22   \n",
       "28              31         Geist      Jordan  ARIZ   M           15   \n",
       "29              32    Villarreal      Carlos  ARIZ   M            5   \n",
       "30              33          Ewen      Maggie  AZST   F           32   \n",
       "32              34       Baylark        Jada   ARK   F           18   \n",
       "34              35        Brooks     Taliyah   ARK   F           27   \n",
       "39              36         Brown      Janeek   ARK   F           24   \n",
       "40              37   Burks Magee      Morgan   ARK   F           19   \n",
       "41              38      Chadwick      Payton   ARK   F           19   \n",
       "46              39        Freier     Desiree   ARK   F           28   \n",
       "47              40         Hiltz       Nikki   ARK   F           21   \n",
       "..             ...           ...         ...   ...  ..          ...   \n",
       "879            214      Browning       Teddy    IU   M           10   \n",
       "883            220     Muncherji       Zubin    IU   M           10   \n",
       "885            233      Hofacker      Collin  IOWA   M           10   \n",
       "886            234      Thompson       Chris  IOWA   M           10   \n",
       "888            238        Cooney       Riley    KU   F           26   \n",
       "889            239     Coppinger    Courtney    KU   F           26   \n",
       "890            240       Dimmick      Hannah    KU   F           26   \n",
       "903            343         Jones      Steffi   UNM   F           26   \n",
       "904            345        Keller      Shalom   UNM   F           26   \n",
       "910            352       Haywood        Mark   UNM   M           10   \n",
       "920            369        Keller  Annasophia    ND   F           26   \n",
       "921            370        Miller      Payton    ND   F           26   \n",
       "922            371        Murray    Samantha    ND   F           26   \n",
       "924            373      Cheatham      Edward    ND   M           10   \n",
       "926            375       Goldman     Clayton    ND   M           10   \n",
       "927            376        Hansen        Kirk    ND   M           10   \n",
       "929            378         Silva      Elijah    ND   M           10   \n",
       "931            389        Cooper      Joseph  OHST   M           10   \n",
       "933            401       Coleman       Amira  OKST   F           26   \n",
       "935            403  Hetherington       Abbie  OKST   F           26   \n",
       "937            405        Wesley       Ambra  OKST   F           26   \n",
       "939            409      Bethmann        Cade  MISS   M           10   \n",
       "940            410       Domanic      Robert  MISS   M           10   \n",
       "944            414     Westbrook       Alvin  MISS   M           10   \n",
       "965            484      Mongiovi       Missy  STAN   F           26   \n",
       "966            486        Wilson     Carolyn  STAN   F           26   \n",
       "968            491       McGorty     Brandon  STAN   M           10   \n",
       "969            492       McGorty        Sean  STAN   M           10   \n",
       "970            493  Sathyamurthy        Hari  STAN   M           10   \n",
       "975            531         Owens       Jarra  TAMU   F           26   \n",
       "\n",
       "       eventNumbers  \n",
       "0                27  \n",
       "1                 4  \n",
       "2                28  \n",
       "3             34,29  \n",
       "5                13  \n",
       "6                12  \n",
       "7             18,17  \n",
       "9             18,17  \n",
       "11            34,27  \n",
       "13            17,18  \n",
       "15               19  \n",
       "16               19  \n",
       "17               31  \n",
       "18               15  \n",
       "19               16  \n",
       "20              6,7  \n",
       "22              7,6  \n",
       "24               11  \n",
       "25                8  \n",
       "26            22,21  \n",
       "28               15  \n",
       "29                5  \n",
       "30            32,31  \n",
       "32            18,17  \n",
       "34   27,24,17,29,34  \n",
       "39               24  \n",
       "40            19,26  \n",
       "41   19,17,24,29,18  \n",
       "46               28  \n",
       "47      21,22,20,26  \n",
       "..              ...  \n",
       "879              10  \n",
       "883              10  \n",
       "885              10  \n",
       "886              10  \n",
       "888              26  \n",
       "889              26  \n",
       "890              26  \n",
       "903              26  \n",
       "904              26  \n",
       "910              10  \n",
       "920              26  \n",
       "921              26  \n",
       "922              26  \n",
       "924              10  \n",
       "926              10  \n",
       "927              10  \n",
       "929              10  \n",
       "931              10  \n",
       "933              26  \n",
       "935              26  \n",
       "937              26  \n",
       "939              10  \n",
       "940              10  \n",
       "944              10  \n",
       "965              26  \n",
       "966              26  \n",
       "968              10  \n",
       "969              10  \n",
       "970              10  \n",
       "975              26  \n",
       "\n",
       "[604 rows x 7 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# df.to_csv('bleh.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}