Main Recommendation Program.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Import the data and build the training Data set\n",
    "Some of the training tracks have lot of missing Data, so we choose to delete the trackes with the  whole line which have the 'None' or 'NaN' item. This step narrows the size of data and make the data matrix full filled."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/WeiChenhao/targetDirectory/lib/python3.6/site-packages/ipykernel_launcher.py:18: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "/Users/WeiChenhao/targetDirectory/lib/python3.6/site-packages/ipykernel_launcher.py:20: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "/Users/WeiChenhao/targetDirectory/lib/python3.6/site-packages/ipykernel_launcher.py:21: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "/Users/WeiChenhao/targetDirectory/lib/python3.6/site-packages/ipykernel_launcher.py:22: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "# import the data\n",
    "with open (\"./data_in_matrixForm/trainIdx2_matrix.txt\",'rt') as scoreFile:\n",
    "    ScoreList = pd.read_csv(scoreFile,sep='|') # Every item(track album genre) with score\n",
    "\n",
    "with open (\"./YahooMusic/trackData2.txt\",'rt') as trackFile:\n",
    "    TrackList = pd.read_csv(trackFile,sep='|') # map to show every track belong which album and Genre.\n",
    "    ### Delete the lines which have None ###\n",
    "    album_noNone = TrackList['albumID'] != \"None\"\n",
    "    artist_noNone = TrackList['artistID'] != \"None\" \n",
    "    album_noNaN = TrackList['albumID'] != np.NaN\n",
    "    artist_noNaN = TrackList['artistID'] != np.NaN \n",
    "    genre_noNaN = TrackList['genreID'] != np.NaN\n",
    "    TrackList = TrackList[album_noNone]\n",
    "    TrackList = TrackList[artist_noNone]\n",
    "    TrackList = TrackList[album_noNaN]\n",
    "    TrackList = TrackList[artist_noNaN]\n",
    "    TrackList = TrackList[genre_noNaN]\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "# slice of the scorelist to find every user's track score.\n",
    "trainingSet = ScoreList.loc[ScoreList['item'].isin(TrackList['trackID'])]\n",
    "SortedList = trainingSet.sort_values(by=['user','score']) # sort the slice"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {
    "scrolled": true
   },
   "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>trackID</th>\n",
       "      <th>albumID</th>\n",
       "      <th>artistID</th>\n",
       "      <th>genreID</th>\n",
       "      <th>genreID.1</th>\n",
       "      <th>genreID.2</th>\n",
       "      <th>genreID.3</th>\n",
       "      <th>genreID.4</th>\n",
       "      <th>genreID.5</th>\n",
       "      <th>genreID.6</th>\n",
       "      <th>...</th>\n",
       "      <th>genreID.13</th>\n",
       "      <th>genreID.14</th>\n",
       "      <th>genreID.15</th>\n",
       "      <th>genreID.16</th>\n",
       "      <th>genreID.17</th>\n",
       "      <th>genreID.18</th>\n",
       "      <th>genreID.19</th>\n",
       "      <th>genreID.20</th>\n",
       "      <th>genreID.21</th>\n",
       "      <th>genreID.22</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>106710</td>\n",
       "      <td>281667</td>\n",
       "      <td>214765.0</td>\n",
       "      <td>162234.0</td>\n",
       "      <td>155788.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>280977</td>\n",
       "      <td>233685</td>\n",
       "      <td>131552.0</td>\n",
       "      <td>173467.0</td>\n",
       "      <td>48505.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>38422</td>\n",
       "      <td>219136</td>\n",
       "      <td>61215.0</td>\n",
       "      <td>201738.0</td>\n",
       "      <td>88853.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>119529</td>\n",
       "      <td>166863</td>\n",
       "      <td>17453.0</td>\n",
       "      <td>35389.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>16742</td>\n",
       "      <td>294690</td>\n",
       "      <td>61215.0</td>\n",
       "      <td>34486.0</td>\n",
       "      <td>274088.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>7</td>\n",
       "      <td>101746</td>\n",
       "      <td>44649</td>\n",
       "      <td>198263.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>8</td>\n",
       "      <td>58498</td>\n",
       "      <td>142773</td>\n",
       "      <td>274161.0</td>\n",
       "      <td>61215.0</td>\n",
       "      <td>274088.0</td>\n",
       "      <td>163949.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>10</td>\n",
       "      <td>88722</td>\n",
       "      <td>179846</td>\n",
       "      <td>186413.0</td>\n",
       "      <td>77904.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>11</td>\n",
       "      <td>54548</td>\n",
       "      <td>206862</td>\n",
       "      <td>98154.0</td>\n",
       "      <td>48505.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>12</td>\n",
       "      <td>6346</td>\n",
       "      <td>93804</td>\n",
       "      <td>33722.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>13</td>\n",
       "      <td>197080</td>\n",
       "      <td>76279</td>\n",
       "      <td>33204.0</td>\n",
       "      <td>162673.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>14</td>\n",
       "      <td>221884</td>\n",
       "      <td>48800</td>\n",
       "      <td>214765.0</td>\n",
       "      <td>131552.0</td>\n",
       "      <td>176858.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>15</td>\n",
       "      <td>31978</td>\n",
       "      <td>91719</td>\n",
       "      <td>173467.0</td>\n",
       "      <td>48505.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>17</td>\n",
       "      <td>249405</td>\n",
       "      <td>276080</td>\n",
       "      <td>17453.0</td>\n",
       "      <td>35389.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>18</td>\n",
       "      <td>123126</td>\n",
       "      <td>169463</td>\n",
       "      <td>172023.0</td>\n",
       "      <td>88853.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>20</td>\n",
       "      <td>208724</td>\n",
       "      <td>96989</td>\n",
       "      <td>33204.0</td>\n",
       "      <td>162673.0</td>\n",
       "      <td>101667.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>21</td>\n",
       "      <td>236848</td>\n",
       "      <td>232639</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>22</td>\n",
       "      <td>22876</td>\n",
       "      <td>272726</td>\n",
       "      <td>126500.0</td>\n",
       "      <td>181653.0</td>\n",
       "      <td>142021.0</td>\n",
       "      <td>206269.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>24</td>\n",
       "      <td>223622</td>\n",
       "      <td>1238</td>\n",
       "      <td>131552.0</td>\n",
       "      <td>61215.0</td>\n",
       "      <td>88853.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>25</td>\n",
       "      <td>77518</td>\n",
       "      <td>292178</td>\n",
       "      <td>61215.0</td>\n",
       "      <td>172023.0</td>\n",
       "      <td>201738.0</td>\n",
       "      <td>88853.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>26</td>\n",
       "      <td>197169</td>\n",
       "      <td>47482</td>\n",
       "      <td>61215.0</td>\n",
       "      <td>199606.0</td>\n",
       "      <td>212410.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>27</td>\n",
       "      <td>159984</td>\n",
       "      <td>164412</td>\n",
       "      <td>173467.0</td>\n",
       "      <td>48505.0</td>\n",
       "      <td>133159.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>28</td>\n",
       "      <td>289988</td>\n",
       "      <td>133835</td>\n",
       "      <td>131552.0</td>\n",
       "      <td>176858.0</td>\n",
       "      <td>19913.0</td>\n",
       "      <td>84705.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>29</td>\n",
       "      <td>161792</td>\n",
       "      <td>49714</td>\n",
       "      <td>176858.0</td>\n",
       "      <td>34486.0</td>\n",
       "      <td>274088.0</td>\n",
       "      <td>48717.0</td>\n",
       "      <td>266781.0</td>\n",
       "      <td>82378.0</td>\n",
       "      <td>99463.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>31</td>\n",
       "      <td>173702</td>\n",
       "      <td>269166</td>\n",
       "      <td>274161.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>32</td>\n",
       "      <td>128448</td>\n",
       "      <td>78745</td>\n",
       "      <td>287681.0</td>\n",
       "      <td>259669.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>34</td>\n",
       "      <td>164570</td>\n",
       "      <td>282789</td>\n",
       "      <td>77904.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>36</td>\n",
       "      <td>204393</td>\n",
       "      <td>134993</td>\n",
       "      <td>214765.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>39</td>\n",
       "      <td>81868</td>\n",
       "      <td>54788</td>\n",
       "      <td>173467.0</td>\n",
       "      <td>219193.0</td>\n",
       "      <td>82064.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>41</td>\n",
       "      <td>250955</td>\n",
       "      <td>90859</td>\n",
       "      <td>33722.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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>224008</th>\n",
       "      <td>296066</td>\n",
       "      <td>35701</td>\n",
       "      <td>89704</td>\n",
       "      <td>173467.0</td>\n",
       "      <td>242383.0</td>\n",
       "      <td>207648.0</td>\n",
       "      <td>279143.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224009</th>\n",
       "      <td>296067</td>\n",
       "      <td>1247</td>\n",
       "      <td>236546</td>\n",
       "      <td>131552.0</td>\n",
       "      <td>173467.0</td>\n",
       "      <td>19913.0</td>\n",
       "      <td>218185.0</td>\n",
       "      <td>146792.0</td>\n",
       "      <td>48505.0</td>\n",
       "      <td>133159.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224010</th>\n",
       "      <td>296068</td>\n",
       "      <td>41178</td>\n",
       "      <td>189708</td>\n",
       "      <td>61215.0</td>\n",
       "      <td>274088.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224011</th>\n",
       "      <td>296069</td>\n",
       "      <td>278667</td>\n",
       "      <td>15279</td>\n",
       "      <td>131552.0</td>\n",
       "      <td>199606.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224012</th>\n",
       "      <td>296070</td>\n",
       "      <td>93833</td>\n",
       "      <td>107674</td>\n",
       "      <td>61215.0</td>\n",
       "      <td>17453.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224013</th>\n",
       "      <td>296071</td>\n",
       "      <td>105236</td>\n",
       "      <td>85921</td>\n",
       "      <td>61215.0</td>\n",
       "      <td>34486.0</td>\n",
       "      <td>37405.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224014</th>\n",
       "      <td>296072</td>\n",
       "      <td>30652</td>\n",
       "      <td>78959</td>\n",
       "      <td>211809.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224015</th>\n",
       "      <td>296073</td>\n",
       "      <td>126149</td>\n",
       "      <td>176213</td>\n",
       "      <td>33722.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224016</th>\n",
       "      <td>296075</td>\n",
       "      <td>162744</td>\n",
       "      <td>185014</td>\n",
       "      <td>162234.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224018</th>\n",
       "      <td>296077</td>\n",
       "      <td>235857</td>\n",
       "      <td>133614</td>\n",
       "      <td>34486.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224019</th>\n",
       "      <td>296078</td>\n",
       "      <td>271115</td>\n",
       "      <td>197404</td>\n",
       "      <td>173467.0</td>\n",
       "      <td>206627.0</td>\n",
       "      <td>82064.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224020</th>\n",
       "      <td>296079</td>\n",
       "      <td>252834</td>\n",
       "      <td>254977</td>\n",
       "      <td>230141.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224021</th>\n",
       "      <td>296080</td>\n",
       "      <td>287832</td>\n",
       "      <td>258464</td>\n",
       "      <td>209270.0</td>\n",
       "      <td>8400.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224022</th>\n",
       "      <td>296081</td>\n",
       "      <td>5961</td>\n",
       "      <td>190518</td>\n",
       "      <td>61215.0</td>\n",
       "      <td>35389.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224023</th>\n",
       "      <td>296084</td>\n",
       "      <td>2865</td>\n",
       "      <td>235140</td>\n",
       "      <td>274161.0</td>\n",
       "      <td>82064.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224024</th>\n",
       "      <td>296086</td>\n",
       "      <td>255052</td>\n",
       "      <td>176963</td>\n",
       "      <td>198263.0</td>\n",
       "      <td>61215.0</td>\n",
       "      <td>278302.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224025</th>\n",
       "      <td>296087</td>\n",
       "      <td>40500</td>\n",
       "      <td>7285</td>\n",
       "      <td>158282.0</td>\n",
       "      <td>279143.0</td>\n",
       "      <td>3969.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224027</th>\n",
       "      <td>296089</td>\n",
       "      <td>282943</td>\n",
       "      <td>69022</td>\n",
       "      <td>158282.0</td>\n",
       "      <td>139095.0</td>\n",
       "      <td>242383.0</td>\n",
       "      <td>279143.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224028</th>\n",
       "      <td>296090</td>\n",
       "      <td>94450</td>\n",
       "      <td>224968</td>\n",
       "      <td>35389.0</td>\n",
       "      <td>31104.0</td>\n",
       "      <td>294310.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224029</th>\n",
       "      <td>296092</td>\n",
       "      <td>199148</td>\n",
       "      <td>246889</td>\n",
       "      <td>61215.0</td>\n",
       "      <td>17453.0</td>\n",
       "      <td>35389.0</td>\n",
       "      <td>253120.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224030</th>\n",
       "      <td>296094</td>\n",
       "      <td>161449</td>\n",
       "      <td>57037</td>\n",
       "      <td>61215.0</td>\n",
       "      <td>34486.0</td>\n",
       "      <td>274088.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224031</th>\n",
       "      <td>296095</td>\n",
       "      <td>74770</td>\n",
       "      <td>64744</td>\n",
       "      <td>256783.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224032</th>\n",
       "      <td>296096</td>\n",
       "      <td>32102</td>\n",
       "      <td>22935</td>\n",
       "      <td>33722.0</td>\n",
       "      <td>224280.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224033</th>\n",
       "      <td>296097</td>\n",
       "      <td>81448</td>\n",
       "      <td>159197</td>\n",
       "      <td>35389.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224034</th>\n",
       "      <td>296098</td>\n",
       "      <td>268097</td>\n",
       "      <td>122298</td>\n",
       "      <td>33722.0</td>\n",
       "      <td>235074.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224035</th>\n",
       "      <td>296099</td>\n",
       "      <td>206461</td>\n",
       "      <td>91679</td>\n",
       "      <td>61215.0</td>\n",
       "      <td>17453.0</td>\n",
       "      <td>88853.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224036</th>\n",
       "      <td>296100</td>\n",
       "      <td>166516</td>\n",
       "      <td>33011</td>\n",
       "      <td>274088.0</td>\n",
       "      <td>199606.0</td>\n",
       "      <td>88853.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224038</th>\n",
       "      <td>296102</td>\n",
       "      <td>153644</td>\n",
       "      <td>289056</td>\n",
       "      <td>158282.0</td>\n",
       "      <td>139095.0</td>\n",
       "      <td>242383.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224039</th>\n",
       "      <td>296105</td>\n",
       "      <td>68336</td>\n",
       "      <td>6613</td>\n",
       "      <td>82064.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224040</th>\n",
       "      <td>296110</td>\n",
       "      <td>281202</td>\n",
       "      <td>140302</td>\n",
       "      <td>61215.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>196463 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        trackID albumID artistID   genreID  genreID.1  genreID.2  genreID.3  \\\n",
       "0             1  106710   281667  214765.0   162234.0   155788.0        NaN   \n",
       "1             2  280977   233685  131552.0   173467.0    48505.0        NaN   \n",
       "2             3   38422   219136   61215.0   201738.0    88853.0        NaN   \n",
       "3             4  119529   166863   17453.0    35389.0        NaN        NaN   \n",
       "4             5   16742   294690   61215.0    34486.0   274088.0        NaN   \n",
       "5             7  101746    44649  198263.0        NaN        NaN        NaN   \n",
       "6             8   58498   142773  274161.0    61215.0   274088.0   163949.0   \n",
       "8            10   88722   179846  186413.0    77904.0        NaN        NaN   \n",
       "9            11   54548   206862   98154.0    48505.0        NaN        NaN   \n",
       "10           12    6346    93804   33722.0        NaN        NaN        NaN   \n",
       "11           13  197080    76279   33204.0   162673.0        NaN        NaN   \n",
       "12           14  221884    48800  214765.0   131552.0   176858.0        NaN   \n",
       "13           15   31978    91719  173467.0    48505.0        NaN        NaN   \n",
       "14           17  249405   276080   17453.0    35389.0        NaN        NaN   \n",
       "15           18  123126   169463  172023.0    88853.0        NaN        NaN   \n",
       "16           20  208724    96989   33204.0   162673.0   101667.0        NaN   \n",
       "17           21  236848   232639       NaN        NaN        NaN        NaN   \n",
       "18           22   22876   272726  126500.0   181653.0   142021.0   206269.0   \n",
       "19           24  223622     1238  131552.0    61215.0    88853.0        NaN   \n",
       "20           25   77518   292178   61215.0   172023.0   201738.0    88853.0   \n",
       "21           26  197169    47482   61215.0   199606.0   212410.0        NaN   \n",
       "22           27  159984   164412  173467.0    48505.0   133159.0        NaN   \n",
       "23           28  289988   133835  131552.0   176858.0    19913.0    84705.0   \n",
       "24           29  161792    49714  176858.0    34486.0   274088.0    48717.0   \n",
       "25           31  173702   269166  274161.0        NaN        NaN        NaN   \n",
       "26           32  128448    78745  287681.0   259669.0        NaN        NaN   \n",
       "27           34  164570   282789   77904.0        NaN        NaN        NaN   \n",
       "28           36  204393   134993  214765.0        NaN        NaN        NaN   \n",
       "30           39   81868    54788  173467.0   219193.0    82064.0        NaN   \n",
       "31           41  250955    90859   33722.0        NaN        NaN        NaN   \n",
       "...         ...     ...      ...       ...        ...        ...        ...   \n",
       "224008   296066   35701    89704  173467.0   242383.0   207648.0   279143.0   \n",
       "224009   296067    1247   236546  131552.0   173467.0    19913.0   218185.0   \n",
       "224010   296068   41178   189708   61215.0   274088.0        NaN        NaN   \n",
       "224011   296069  278667    15279  131552.0   199606.0        NaN        NaN   \n",
       "224012   296070   93833   107674   61215.0    17453.0        NaN        NaN   \n",
       "224013   296071  105236    85921   61215.0    34486.0    37405.0        NaN   \n",
       "224014   296072   30652    78959  211809.0        NaN        NaN        NaN   \n",
       "224015   296073  126149   176213   33722.0        NaN        NaN        NaN   \n",
       "224016   296075  162744   185014  162234.0        NaN        NaN        NaN   \n",
       "224018   296077  235857   133614   34486.0        NaN        NaN        NaN   \n",
       "224019   296078  271115   197404  173467.0   206627.0    82064.0        NaN   \n",
       "224020   296079  252834   254977  230141.0        NaN        NaN        NaN   \n",
       "224021   296080  287832   258464  209270.0     8400.0        NaN        NaN   \n",
       "224022   296081    5961   190518   61215.0    35389.0        NaN        NaN   \n",
       "224023   296084    2865   235140  274161.0    82064.0        NaN        NaN   \n",
       "224024   296086  255052   176963  198263.0    61215.0   278302.0        NaN   \n",
       "224025   296087   40500     7285  158282.0   279143.0     3969.0        NaN   \n",
       "224027   296089  282943    69022  158282.0   139095.0   242383.0   279143.0   \n",
       "224028   296090   94450   224968   35389.0    31104.0   294310.0        NaN   \n",
       "224029   296092  199148   246889   61215.0    17453.0    35389.0   253120.0   \n",
       "224030   296094  161449    57037   61215.0    34486.0   274088.0        NaN   \n",
       "224031   296095   74770    64744  256783.0        NaN        NaN        NaN   \n",
       "224032   296096   32102    22935   33722.0   224280.0        NaN        NaN   \n",
       "224033   296097   81448   159197   35389.0        NaN        NaN        NaN   \n",
       "224034   296098  268097   122298   33722.0   235074.0        NaN        NaN   \n",
       "224035   296099  206461    91679   61215.0    17453.0    88853.0        NaN   \n",
       "224036   296100  166516    33011  274088.0   199606.0    88853.0        NaN   \n",
       "224038   296102  153644   289056  158282.0   139095.0   242383.0        NaN   \n",
       "224039   296105   68336     6613   82064.0        NaN        NaN        NaN   \n",
       "224040   296110  281202   140302   61215.0        NaN        NaN        NaN   \n",
       "\n",
       "        genreID.4  genreID.5  genreID.6     ...      genreID.13  genreID.14  \\\n",
       "0             NaN        NaN        NaN     ...             NaN         NaN   \n",
       "1             NaN        NaN        NaN     ...             NaN         NaN   \n",
       "2             NaN        NaN        NaN     ...             NaN         NaN   \n",
       "3             NaN        NaN        NaN     ...             NaN         NaN   \n",
       "4             NaN        NaN        NaN     ...             NaN         NaN   \n",
       "5             NaN        NaN        NaN     ...             NaN         NaN   \n",
       "6             NaN        NaN        NaN     ...             NaN         NaN   \n",
       "8             NaN        NaN        NaN     ...             NaN         NaN   \n",
       "9             NaN        NaN        NaN     ...             NaN         NaN   \n",
       "10            NaN        NaN        NaN     ...             NaN         NaN   \n",
       "11            NaN        NaN        NaN     ...             NaN         NaN   \n",
       "12            NaN        NaN        NaN     ...             NaN         NaN   \n",
       "13            NaN        NaN        NaN     ...             NaN         NaN   \n",
       "14            NaN        NaN        NaN     ...             NaN         NaN   \n",
       "15            NaN        NaN        NaN     ...             NaN         NaN   \n",
       "16            NaN        NaN        NaN     ...             NaN         NaN   \n",
       "17            NaN        NaN        NaN     ...             NaN         NaN   \n",
       "18            NaN        NaN        NaN     ...             NaN         NaN   \n",
       "19            NaN        NaN        NaN     ...             NaN         NaN   \n",
       "20            NaN        NaN        NaN     ...             NaN         NaN   \n",
       "21            NaN        NaN        NaN     ...             NaN         NaN   \n",
       "22            NaN        NaN        NaN     ...             NaN         NaN   \n",
       "23            NaN        NaN        NaN     ...             NaN         NaN   \n",
       "24       266781.0    82378.0    99463.0     ...             NaN         NaN   \n",
       "25            NaN        NaN        NaN     ...             NaN         NaN   \n",
       "26            NaN        NaN        NaN     ...             NaN         NaN   \n",
       "27            NaN        NaN        NaN     ...             NaN         NaN   \n",
       "28            NaN        NaN        NaN     ...             NaN         NaN   \n",
       "30            NaN        NaN        NaN     ...             NaN         NaN   \n",
       "31            NaN        NaN        NaN     ...             NaN         NaN   \n",
       "...           ...        ...        ...     ...             ...         ...   \n",
       "224008        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224009   146792.0    48505.0   133159.0     ...             NaN         NaN   \n",
       "224010        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224011        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224012        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224013        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224014        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224015        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224016        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224018        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224019        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224020        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224021        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224022        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224023        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224024        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224025        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224027        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224028        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224029        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224030        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224031        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224032        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224033        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224034        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224035        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224036        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224038        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224039        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "224040        NaN        NaN        NaN     ...             NaN         NaN   \n",
       "\n",
       "        genreID.15  genreID.16  genreID.17  genreID.18  genreID.19  \\\n",
       "0              NaN         NaN         NaN         NaN         NaN   \n",
       "1              NaN         NaN         NaN         NaN         NaN   \n",
       "2              NaN         NaN         NaN         NaN         NaN   \n",
       "3              NaN         NaN         NaN         NaN         NaN   \n",
       "4              NaN         NaN         NaN         NaN         NaN   \n",
       "5              NaN         NaN         NaN         NaN         NaN   \n",
       "6              NaN         NaN         NaN         NaN         NaN   \n",
       "8              NaN         NaN         NaN         NaN         NaN   \n",
       "9              NaN         NaN         NaN         NaN         NaN   \n",
       "10             NaN         NaN         NaN         NaN         NaN   \n",
       "11             NaN         NaN         NaN         NaN         NaN   \n",
       "12             NaN         NaN         NaN         NaN         NaN   \n",
       "13             NaN         NaN         NaN         NaN         NaN   \n",
       "14             NaN         NaN         NaN         NaN         NaN   \n",
       "15             NaN         NaN         NaN         NaN         NaN   \n",
       "16             NaN         NaN         NaN         NaN         NaN   \n",
       "17             NaN         NaN         NaN         NaN         NaN   \n",
       "18             NaN         NaN         NaN         NaN         NaN   \n",
       "19             NaN         NaN         NaN         NaN         NaN   \n",
       "20             NaN         NaN         NaN         NaN         NaN   \n",
       "21             NaN         NaN         NaN         NaN         NaN   \n",
       "22             NaN         NaN         NaN         NaN         NaN   \n",
       "23             NaN         NaN         NaN         NaN         NaN   \n",
       "24             NaN         NaN         NaN         NaN         NaN   \n",
       "25             NaN         NaN         NaN         NaN         NaN   \n",
       "26             NaN         NaN         NaN         NaN         NaN   \n",
       "27             NaN         NaN         NaN         NaN         NaN   \n",
       "28             NaN         NaN         NaN         NaN         NaN   \n",
       "30             NaN         NaN         NaN         NaN         NaN   \n",
       "31             NaN         NaN         NaN         NaN         NaN   \n",
       "...            ...         ...         ...         ...         ...   \n",
       "224008         NaN         NaN         NaN         NaN         NaN   \n",
       "224009         NaN         NaN         NaN         NaN         NaN   \n",
       "224010         NaN         NaN         NaN         NaN         NaN   \n",
       "224011         NaN         NaN         NaN         NaN         NaN   \n",
       "224012         NaN         NaN         NaN         NaN         NaN   \n",
       "224013         NaN         NaN         NaN         NaN         NaN   \n",
       "224014         NaN         NaN         NaN         NaN         NaN   \n",
       "224015         NaN         NaN         NaN         NaN         NaN   \n",
       "224016         NaN         NaN         NaN         NaN         NaN   \n",
       "224018         NaN         NaN         NaN         NaN         NaN   \n",
       "224019         NaN         NaN         NaN         NaN         NaN   \n",
       "224020         NaN         NaN         NaN         NaN         NaN   \n",
       "224021         NaN         NaN         NaN         NaN         NaN   \n",
       "224022         NaN         NaN         NaN         NaN         NaN   \n",
       "224023         NaN         NaN         NaN         NaN         NaN   \n",
       "224024         NaN         NaN         NaN         NaN         NaN   \n",
       "224025         NaN         NaN         NaN         NaN         NaN   \n",
       "224027         NaN         NaN         NaN         NaN         NaN   \n",
       "224028         NaN         NaN         NaN         NaN         NaN   \n",
       "224029         NaN         NaN         NaN         NaN         NaN   \n",
       "224030         NaN         NaN         NaN         NaN         NaN   \n",
       "224031         NaN         NaN         NaN         NaN         NaN   \n",
       "224032         NaN         NaN         NaN         NaN         NaN   \n",
       "224033         NaN         NaN         NaN         NaN         NaN   \n",
       "224034         NaN         NaN         NaN         NaN         NaN   \n",
       "224035         NaN         NaN         NaN         NaN         NaN   \n",
       "224036         NaN         NaN         NaN         NaN         NaN   \n",
       "224038         NaN         NaN         NaN         NaN         NaN   \n",
       "224039         NaN         NaN         NaN         NaN         NaN   \n",
       "224040         NaN         NaN         NaN         NaN         NaN   \n",
       "\n",
       "        genreID.20  genreID.21  genreID.22  \n",
       "0              NaN         NaN         NaN  \n",
       "1              NaN         NaN         NaN  \n",
       "2              NaN         NaN         NaN  \n",
       "3              NaN         NaN         NaN  \n",
       "4              NaN         NaN         NaN  \n",
       "5              NaN         NaN         NaN  \n",
       "6              NaN         NaN         NaN  \n",
       "8              NaN         NaN         NaN  \n",
       "9              NaN         NaN         NaN  \n",
       "10             NaN         NaN         NaN  \n",
       "11             NaN         NaN         NaN  \n",
       "12             NaN         NaN         NaN  \n",
       "13             NaN         NaN         NaN  \n",
       "14             NaN         NaN         NaN  \n",
       "15             NaN         NaN         NaN  \n",
       "16             NaN         NaN         NaN  \n",
       "17             NaN         NaN         NaN  \n",
       "18             NaN         NaN         NaN  \n",
       "19             NaN         NaN         NaN  \n",
       "20             NaN         NaN         NaN  \n",
       "21             NaN         NaN         NaN  \n",
       "22             NaN         NaN         NaN  \n",
       "23             NaN         NaN         NaN  \n",
       "24             NaN         NaN         NaN  \n",
       "25             NaN         NaN         NaN  \n",
       "26             NaN         NaN         NaN  \n",
       "27             NaN         NaN         NaN  \n",
       "28             NaN         NaN         NaN  \n",
       "30             NaN         NaN         NaN  \n",
       "31             NaN         NaN         NaN  \n",
       "...            ...         ...         ...  \n",
       "224008         NaN         NaN         NaN  \n",
       "224009         NaN         NaN         NaN  \n",
       "224010         NaN         NaN         NaN  \n",
       "224011         NaN         NaN         NaN  \n",
       "224012         NaN         NaN         NaN  \n",
       "224013         NaN         NaN         NaN  \n",
       "224014         NaN         NaN         NaN  \n",
       "224015         NaN         NaN         NaN  \n",
       "224016         NaN         NaN         NaN  \n",
       "224018         NaN         NaN         NaN  \n",
       "224019         NaN         NaN         NaN  \n",
       "224020         NaN         NaN         NaN  \n",
       "224021         NaN         NaN         NaN  \n",
       "224022         NaN         NaN         NaN  \n",
       "224023         NaN         NaN         NaN  \n",
       "224024         NaN         NaN         NaN  \n",
       "224025         NaN         NaN         NaN  \n",
       "224027         NaN         NaN         NaN  \n",
       "224028         NaN         NaN         NaN  \n",
       "224029         NaN         NaN         NaN  \n",
       "224030         NaN         NaN         NaN  \n",
       "224031         NaN         NaN         NaN  \n",
       "224032         NaN         NaN         NaN  \n",
       "224033         NaN         NaN         NaN  \n",
       "224034         NaN         NaN         NaN  \n",
       "224035         NaN         NaN         NaN  \n",
       "224036         NaN         NaN         NaN  \n",
       "224038         NaN         NaN         NaN  \n",
       "224039         NaN         NaN         NaN  \n",
       "224040         NaN         NaN         NaN  \n",
       "\n",
       "[196463 rows x 26 columns]"
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "TrackList"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 234,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "ename": "KeyboardInterrupt",
     "evalue": "",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mKeyboardInterrupt\u001b[0m                         Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-234-a64915d3a009>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m     58\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0martist\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     59\u001b[0m             \u001b[0;32mcontinue\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 60\u001b[0;31m         \u001b[0mgenre\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mscoreFind\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mi\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mgenreNumber\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     61\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0mgenre\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     62\u001b[0m             \u001b[0;32mcontinue\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m<ipython-input-234-a64915d3a009>\u001b[0m in \u001b[0;36mscoreFind\u001b[0;34m(user, item)\u001b[0m\n\u001b[1;32m      2\u001b[0m \u001b[0;32mdef\u001b[0m \u001b[0mscoreFind\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0muser\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      3\u001b[0m     \u001b[0;34m'''输入用户id，以及想要找的item名，在ScoreList里寻找对应的分数'''\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 4\u001b[0;31m     \u001b[0mn\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mScoreList\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mScoreList\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'user'\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m==\u001b[0m \u001b[0muser\u001b[0m \u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      5\u001b[0m     \u001b[0;31m# 如果没有这个item（Album，ect），那么就返回-1\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      6\u001b[0m     \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/targetDirectory/lib/python3.6/site-packages/pandas/core/ops.py\u001b[0m in \u001b[0;36mwrapper\u001b[0;34m(self, other, axis)\u001b[0m\n\u001b[1;32m    877\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    878\u001b[0m             \u001b[0;32mwith\u001b[0m \u001b[0mnp\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0merrstate\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mall\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'ignore'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 879\u001b[0;31m                 \u001b[0mres\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mna_op\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mvalues\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mother\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    880\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mis_scalar\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mres\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    881\u001b[0m                 raise TypeError('Could not compare {typ} type with Series'\n",
      "\u001b[0;32m~/targetDirectory/lib/python3.6/site-packages/pandas/core/ops.py\u001b[0m in \u001b[0;36mna_op\u001b[0;34m(x, y)\u001b[0m\n\u001b[1;32m    814\u001b[0m             \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    815\u001b[0m                 \u001b[0;32mwith\u001b[0m \u001b[0mnp\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0merrstate\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mall\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'ignore'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 816\u001b[0;31m                     \u001b[0mresult\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mgetattr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mx\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mname\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0my\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    817\u001b[0m                 \u001b[0;32mif\u001b[0m \u001b[0mresult\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0mNotImplemented\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    818\u001b[0m                     \u001b[0;32mraise\u001b[0m \u001b[0mTypeError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"invalid type comparison\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mKeyboardInterrupt\u001b[0m: "
     ]
    }
   ],
   "source": [
    "### Build the training data Set\n",
    "def scoreFind(user,item):\n",
    "    '''输入用户id，以及想要找的item名，在ScoreList里寻找对应的分数/ input user ID and item ID, return the item's score '''\n",
    "    n = ScoreList[ScoreList['user'] == user ]\n",
    "    # if cannot find this item（Album，ect），return -1.\n",
    "    try:\n",
    "        w = n[n['item'] == item]\n",
    "        w['user'].iloc[0]\n",
    "    except IndexError:\n",
    "        return False\n",
    "    else:\n",
    "        score = w.iloc[:,2].iloc[0]\n",
    "        return score\n",
    "\n",
    "# Build a pandas dataframe\n",
    "trainingScoreData = pd.DataFrame(columns=['user', 'track', 'album', 'artist', 'genre'])\n",
    "# we only catch one genre for each track\n",
    "k = 0\n",
    "### The data we catch need have scores for all these items -- user，track，album，artist，genre ###\n",
    "### If any is None then we drop it ###\n",
    "# Here we only choose 1000 user to make the training data set\n",
    "for i in range(1,1000):\n",
    "#     print(i)\n",
    "    try:\n",
    "        singleUser = SortedList[SortedList['user']==i] # single user's track score slice.\n",
    "        singleUser['user'].iloc[0] # test if this user's list is empty raise IndexError.\n",
    "    except IndexError:\n",
    "        #print(\"user %d is not in this track based list\" % i) # User is not in the Track only ScoreList\n",
    "        continue\n",
    "    for trackNumber in singleUser['item']:# track number\n",
    "#         print(trackNumber)\n",
    "        try:\n",
    "            albumNumber=int(TrackList[TrackList['trackID']==trackNumber].iloc[:,1].iloc[0])\n",
    "        except (IndexError, ValueError):\n",
    "            #print(\"the album %d is not in the TrackList\" % trackNumber)\n",
    "            continue\n",
    "            \n",
    "        try:\n",
    "            artistNumber=int(TrackList[TrackList['trackID']==trackNumber].iloc[:,2].iloc[0])\n",
    "        except (IndexError, ValueError):\n",
    "            #print(\"the artist %d is not in the TrackList\" % trackNumber)\n",
    "            continue\n",
    "        \n",
    "        try:\n",
    "            genreNumber=int(TrackList[TrackList['trackID']==trackNumber].iloc[:,3].iloc[0])\n",
    "        except (IndexError,ValueError):\n",
    "            #print(\"the genre %d is not in the TrackList\" % trackNumber)\n",
    "            continue\n",
    "        \n",
    "        album = scoreFind(i,albumNumber)\n",
    "        if album == False:\n",
    "            continue\n",
    "        artist = scoreFind(i,artistNumber)\n",
    "        if not artist:\n",
    "            continue\n",
    "        genre = scoreFind(i,genreNumber)\n",
    "        if not genre:\n",
    "            continue\n",
    "        trackScore = singleUser[singleUser['item']==trackNumber].iloc[:,2].iloc[0]\n",
    "        trainingScoreData.loc[k]=[i,trackScore,album,artist,genre]\n",
    "        #print(k)\n",
    "        k += 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'trainingScoreData' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-76-c5e0ec6129ab>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mtrainingScoreData\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mto_csv\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'./trainingData.csv'\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0msep\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m','\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;31mNameError\u001b[0m: name 'trainingScoreData' is not defined"
     ]
    }
   ],
   "source": [
    "# Output Training Data\n",
    "trainingScoreData.to_csv('./trainingData.csv',sep='|')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "### build the test data file with score ###\n",
    "### this cell get all the scores for every track, artist, album ,genre. ###\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "\n",
    "dataDir='./YahooMusic/'\n",
    "file_name_test = dataDir + 'testTrack_hierarchy.txt'\n",
    "file_name_train = dataDir + 'trainIdx2_matrix.txt'\n",
    "output_file = dataDir + 'scores.txt'\n",
    "\n",
    "fTest = open(file_name_test, 'r')\n",
    "fTrain = open(file_name_train, 'r')\n",
    "Trainline = fTrain.readline()\n",
    "fOut = open(output_file, 'w')\n",
    "titles ='userID'+ '|' + 'trackID'+ '|' + 'albumID'+ '|' + 'artistID'+ '|' + 'genre1ID' + '|' + 'genre2ID' + '|' + 'genre3ID' + '|' + 'genre4ID' + '|' + 'genre5ID' + '|' + 'genre6ID' + '|' + 'genre7ID' + '|' + 'genre8ID' + '|' + 'genre9ID' + '|' + 'genre10ID' + '|' + 'genre11ID' + '|' + 'genre12ID' + '|' + 'genre13ID' + '|' + 'genre14ID' + '|' + 'genre15ID' + '|' + 'genre16ID' + '|' + 'genre17ID' + '|' + 'genre18ID' + '|' + 'genre19ID' + '|' + 'genre20ID' + '|' + 'genre21ID'\n",
    "fOut.write(titles + '\\n')\n",
    "\n",
    "trackID_vec = [0] * 6\n",
    "albumID_vec = [0] * 6\n",
    "artistID_vec = [0] * 6\n",
    "genre1ID_vec = [0] * 6\n",
    "genre2ID_vec = [0] * 6\n",
    "genre3ID_vec = [0] * 6\n",
    "genre4ID_vec = [0] * 6\n",
    "genre5ID_vec = [0] * 6\n",
    "genre6ID_vec = [0] * 6\n",
    "genre7ID_vec = [0] * 6\n",
    "genre8ID_vec = [0] * 6\n",
    "genre9ID_vec = [0] * 6\n",
    "genre10ID_vec = [0] * 6\n",
    "genre11ID_vec = [0] * 6\n",
    "genre12ID_vec = [0] * 6\n",
    "genre13ID_vec = [0] * 6\n",
    "genre14ID_vec = [0] * 6\n",
    "genre15ID_vec = [0] * 6\n",
    "genre16ID_vec = [0] * 6\n",
    "genre17ID_vec = [0] * 6\n",
    "genre18ID_vec = [0] * 6\n",
    "genre19ID_vec = [0] * 6\n",
    "genre20ID_vec = [0] * 6\n",
    "genre21ID_vec = [0] * 6\n",
    "\n",
    "lastUserID = -1\n",
    "\n",
    "user_rating_inTrain = np.zeros(shape=(6,25))-1\n",
    "arr_len = []\n",
    "\n",
    "for line in fTest:\n",
    "    arr_test = line.strip().split('|')\n",
    "    #arr_len.append(len(arr_test))\n",
    "    \n",
    "    # make a matrix with equal column numbers\n",
    "    b = [-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1]\n",
    "    arr_test.extend(b[:25-len(arr_test)])\n",
    "    userID = arr_test[0]\n",
    "    trackID = arr_test[1]\n",
    "    albumID = arr_test[2]\n",
    "    artistID = arr_test[3]\n",
    "    genre1ID = arr_test[4]\n",
    "    genre2ID = arr_test[5]\n",
    "    genre3ID = arr_test[6]\n",
    "    genre4ID = arr_test[7]\n",
    "    genre5ID = arr_test[8]\n",
    "    genre6ID = arr_test[9]\n",
    "    genre7ID = arr_test[10]\n",
    "    genre8ID = arr_test[11]\n",
    "    genre9ID = arr_test[12]\n",
    "    genre10ID = arr_test[13]\n",
    "    genre11ID = arr_test[14]\n",
    "    genre12ID = arr_test[15]\n",
    "    genre13ID = arr_test[16]\n",
    "    genre14ID = arr_test[17]\n",
    "    genre15ID = arr_test[18]\n",
    "    genre16ID = arr_test[19]\n",
    "    genre17ID = arr_test[20]\n",
    "    genre18ID = arr_test[21]\n",
    "    genre19ID = arr_test[22]\n",
    "    genre20ID = arr_test[23]\n",
    "    genre21ID = arr_test[24]\n",
    "    \n",
    "    if userID != lastUserID:\n",
    "        ii = 0\n",
    "        user_rating_inTrain = np.zeros(shape=(6,25))-1\n",
    "\n",
    "    trackID_vec[ii] = trackID\n",
    "    albumID_vec[ii] = albumID\n",
    "    artistID_vec[ii] = artistID\n",
    "    genre1ID_vec[ii] = genre1ID\n",
    "    genre2ID_vec[ii] = genre2ID\n",
    "    genre3ID_vec[ii] = genre3ID\n",
    "    genre4ID_vec[ii] = genre4ID\n",
    "    genre5ID_vec[ii] = genre5ID\n",
    "    genre6ID_vec[ii] = genre6ID\n",
    "    genre7ID_vec[ii] = genre7ID\n",
    "    genre8ID_vec[ii] = genre8ID\n",
    "    genre9ID_vec[ii] = genre9ID\n",
    "    genre10ID_vec[ii] = genre10ID\n",
    "    genre11ID_vec[ii] = genre11ID\n",
    "    genre12ID_vec[ii] = genre12ID\n",
    "    genre13ID_vec[ii] = genre13ID\n",
    "    genre14ID_vec[ii] = genre14ID\n",
    "    genre15ID_vec[ii] = genre15ID\n",
    "    genre16ID_vec[ii] = genre16ID\n",
    "    genre17ID_vec[ii] = genre17ID\n",
    "    genre18ID_vec[ii] = genre18ID\n",
    "    genre19ID_vec[ii] = genre19ID\n",
    "    genre20ID_vec[ii] = genre20ID\n",
    "    genre21ID_vec[ii] = genre21ID\n",
    "\n",
    "    ii = ii + 1\n",
    "    lastUserID = userID\n",
    "\n",
    "    if ii == 6:\n",
    "        while (Trainline):\n",
    "            # for Trainline in fTrain:\n",
    "            arr_train = Trainline.strip().split('|')\n",
    "            trainUserID = arr_train[0]\n",
    "            trainItemID = arr_train[1]\n",
    "            trainRating = arr_train[2]\n",
    "            \n",
    "            Trainline = fTrain.readline()\n",
    "               \n",
    "            if int(trainUserID) < int(userID):\n",
    "#                 print('dao zhe le <')\n",
    "#                 print()\n",
    "                continue\n",
    "                # test user 627\n",
    "             \n",
    "            if int(trainUserID) == int(userID):\n",
    "#                 print('dao zhe le =')\n",
    "                # test user 627#\n",
    "#                 print(arr_train[0],', ',trainItemID,', ',trainRating)\n",
    "#                 print()\n",
    "                \n",
    "                for nn in range(0, 6):\n",
    "                    if trainItemID == albumID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 0] = trainRating\n",
    "#                         print('one abl',', ',user_rating_inTrain[nn, 0])\n",
    "            \n",
    "                    if trainItemID == artistID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 1] = trainRating\n",
    "#                         print('one art',', ',user_rating_inTrain[nn, 1])\n",
    "#                     elif artistID_vec[nn] == 999 :\n",
    "#                         user_rating_inTrain[nn, 1] = 999\n",
    "                        \n",
    "                    if trainItemID == genre1ID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 2] = trainRating\n",
    "#                         print('one genre1ID_vec',', ',user_rating_inTrain[nn, 2])\n",
    "\n",
    "                    if trainItemID == genre2ID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 3] = trainRating\n",
    "#                         print('one genrel 2',', ',user_rating_inTrain[nn, 3])\n",
    "\n",
    "                    if trainItemID == genre3ID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 4] = trainRating\n",
    "#                         print('one genrel 3',', ',user_rating_inTrain[nn, 4])\n",
    "                    \n",
    "                    if trainItemID == genre4ID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 5] = trainRating \n",
    "                    \n",
    "                    if trainItemID == genre5ID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 6] = trainRating\n",
    "                    \n",
    "                    if trainItemID == genre6ID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 7] = trainRating\n",
    "\n",
    "                    if trainItemID == genre7ID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 8] = trainRating\n",
    "\n",
    "                    if trainItemID == genre8ID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 9] = trainRating\n",
    "\n",
    "                    if trainItemID == genre9ID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 10] = trainRating\n",
    "\n",
    "                    if trainItemID == genre10ID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 11] = trainRating\n",
    "\n",
    "                    if trainItemID == genre11ID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 12] = trainRating\n",
    "                        \n",
    "                    if trainItemID == genre12ID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 13] = trainRating\n",
    "                    \n",
    "                    if trainItemID == genre13ID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 14] = trainRating\n",
    "                        \n",
    "                    if trainItemID == genre14ID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 15] = trainRating\n",
    "                        \n",
    "                    if trainItemID == genre15ID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 16] = trainRating\n",
    "                        \n",
    "                    if trainItemID == genre16ID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 17] = trainRating\n",
    "                        \n",
    "                    if trainItemID == genre17ID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 18] = trainRating\n",
    "                        \n",
    "                    if trainItemID == genre18ID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 19] = trainRating\n",
    "                        \n",
    "                    if trainItemID == genre19ID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 20] = trainRating\n",
    "                        \n",
    "                    if trainItemID == genre20ID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 21] = trainRating\n",
    "                        \n",
    "                    if trainItemID == genre21ID_vec[nn]:\n",
    "                        user_rating_inTrain[nn, 22] = trainRating\n",
    "                        \n",
    "            if int(trainUserID) > int(userID):\n",
    "#                 print('dao zhe le >')\n",
    "#                 print(trainUserID,', ',userID)\n",
    "                for nn in range(0, 6):\n",
    "                    outStr = str(userID) + '|' + str(trackID_vec[nn]) + '|' + str(\n",
    "                        user_rating_inTrain[nn, 0]) + '|' + str(user_rating_inTrain[nn, 1]) + '|' + str(\n",
    "                        user_rating_inTrain[nn, 2]) + '|' + str(user_rating_inTrain[nn, 3]) + '|' + str(user_rating_inTrain[nn, 4]) + '|' + str(\n",
    "                        user_rating_inTrain[nn, 5]) + '|' + str(user_rating_inTrain[nn, 6]) + '|' + str(user_rating_inTrain[nn, 7]) + '|' + str(\n",
    "                        user_rating_inTrain[nn, 8]) + '|' + str(user_rating_inTrain[nn, 9]) + '|' + str(user_rating_inTrain[nn, 10]) + '|' + str(\n",
    "                        user_rating_inTrain[nn, 11]) + '|' + str(user_rating_inTrain[nn, 12]) + '|' + str(user_rating_inTrain[nn, 13]) + '|' + str(\n",
    "                        user_rating_inTrain[nn, 14]) + '|' + str(user_rating_inTrain[nn, 15]) + '|' + str(user_rating_inTrain[nn, 16]) + '|' + str(\n",
    "                        user_rating_inTrain[nn, 17]) + '|' + str(user_rating_inTrain[nn, 18]) + '|' + str(user_rating_inTrain[nn, 19]) + '|' + str(\n",
    "                        user_rating_inTrain[nn, 20]) + '|' + str(user_rating_inTrain[nn, 21]) + '|' + str(user_rating_inTrain[nn, 22])\n",
    "                    fOut.write(outStr + '\\n')\n",
    "                break\n",
    "\n",
    "fTest.close()\n",
    "fTrain.close()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 256,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "5000\n",
      "10000\n",
      "15000\n",
      "20000\n",
      "25000\n",
      "30000\n",
      "35000\n",
      "40000\n",
      "45000\n",
      "50000\n",
      "55000\n",
      "60000\n",
      "65000\n",
      "70000\n",
      "75000\n",
      "80000\n",
      "85000\n",
      "90000\n"
     ]
    }
   ],
   "source": [
    "# matrix_factorization\n",
    "import numpy as np\n",
    "\n",
    "def matrixFactorization(R,K,steps,alpha,beta):\n",
    "    (row,col) = R.shape\n",
    "    e = np.zeros((row,col))\n",
    "    R_near = np.zeros((row,col))\n",
    "    nP = P = np.random.random((row,K))\n",
    "    nQ = Q = np.random.random((K,col))\n",
    "    for n in range(1,steps+1):\n",
    "        for i in range(row):\n",
    "            for j in range(col):\n",
    "                if R[i][j] != -1.0:\n",
    "                    R_near = P.dot(Q)\n",
    "                    e[i][j]=R[i][j]-R_near[i][j]\n",
    "                    for m in range(K):\n",
    "                        nP[i][m]=P[i][m]+alpha*(2*e[i][j]*Q[m][j]-beta*P[i][m])\n",
    "                        nQ[m][j]=Q[m][j]+alpha*(2*e[i][j]*P[i][m]-beta*Q[m][j])\n",
    "                        P[i][m] = nP[i][m]\n",
    "                        Q[m][j] = nQ[m][j]\n",
    "    return nP.dot(nQ)\n",
    "\n",
    "\n",
    "with open('./YahooMusic/scores.txt','rt') as scorefile:\n",
    "    scoreMatrix = np.loadtxt(scorefile,dtype=np.float128,delimiter=\"|\")\n",
    "    \n",
    "filledMatrix=np.ones(shape=(94290,4))\n",
    "i = 0\n",
    "while i <90000 :\n",
    "    R = scoreMatrix[i:i+5000,2:6]\n",
    "    K = 2\n",
    "    steps = 5\n",
    "    alpha = 0.000001\n",
    "    beta = 0.000002\n",
    "    filledMatrix[i:i+5000,0:4]=matrixFactorization(R, K, steps, alpha, beta)\n",
    "    i += 5000\n",
    "    print (i)\n",
    "    \n",
    "R = scoreMatrix[90000:94290,2:6]\n",
    "filledMatrix[90000:94290,0:4]= matrixFactorization(R, K, steps, alpha, beta)\n",
    "\n",
    "# only repalce the '-1' item, keep the original items which have scores.\n",
    "for i in range(0,94290):\n",
    "    for j in range(0,4):\n",
    "        if scoreMatrix[i][j+2] != -1.0:\n",
    "            filledMatrix[i][j] = scoreMatrix[i][j+2]\n",
    "            \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 193,
   "metadata": {},
   "outputs": [],
   "source": [
    "### !!!!! Bad way !!!!!###\n",
    "### failed !!!!! Only 0.70 ac ###\n",
    "\n",
    "\n",
    "### avarage fill method ###\n",
    "\n",
    "# sc_album = list()\n",
    "# sc_artist = list()\n",
    "# sc_genre = list()\n",
    "# for kk in range(0,94290):\n",
    "#     if scoreMatrix[kk][2] != -1:\n",
    "#         sc_album.append(scoreMatrix[kk][2])\n",
    "\n",
    "# for kk in range(0,94290):\n",
    "#     if scoreMatrix[kk][3] != -1:\n",
    "#         sc_artist.append(scoreMatrix[kk][3])\n",
    "\n",
    "# for kk in range(0,94290):\n",
    "#     if scoreMatrix[kk][4] != -1:\n",
    "#         sc_genre.append(scoreMatrix[kk][4])\n",
    "\n",
    "# sc_album_mean = np.mean(sc_album)\n",
    "# sc_artist_mean = np.mean(sc_artist)\n",
    "# sc_genre_mean = np.mean(sc_genre)\n",
    "\n",
    "# with open('./YahooMusic/scores.txt','rt') as scorefile:\n",
    "#     meansolvedScore = np.loadtxt(scorefile,dtype=np.float128,delimiter=\"|\")\n",
    "    \n",
    "# for kk in range(0,94290):\n",
    "#     if scoreMatrix[kk][2] == -1:\n",
    "#         meansolvedScore[kk][2]=sc_album_mean\n",
    "        \n",
    "# for kk in range(0,94290):\n",
    "#     if scoreMatrix[kk][3] == -1:\n",
    "#         meansolvedScore[kk][3]=sc_artist_mean\n",
    "        \n",
    "# for kk in range(0,94290):\n",
    "#     if scoreMatrix[kk][4] == -1:\n",
    "#         meansolvedScore[kk][4]=sc_genre_mean\n",
    "        \n",
    "# filledMatrix_slice = meansolvedScore[:,2:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 227,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "matrix([[0.67094047],\n",
       "        [0.15304484],\n",
       "        [0.08841344]])"
      ]
     },
     "execution_count": 227,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# linear regression\n",
    "with open('./trainingData.csv','rt') as file2:\n",
    "    finTrainingData = pd.read_csv(file2,sep='|')\n",
    "    \n",
    "train = finTrainingData.iloc[:,2:6]\n",
    "\n",
    "theta = np.ones((3,1))\n",
    "training = np.mat(finTrainingData.iloc[:,3:6])\n",
    "track = np.mat(finTrainingData.iloc[:,2])\n",
    "X_I= (training.T*training).I\n",
    "X_t_Y = training.T * track.T\n",
    "theta = X_I * X_t_Y\n",
    "\n",
    "theta"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 257,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "finish\n"
     ]
    }
   ],
   "source": [
    "filledMatrix_slice = filledMatrix[:,0:3]\n",
    "# test data filledMatrix，weight theta\n",
    "import csv\n",
    "# resultMatrix = pd.DataFrame(filledMatrix.dot(theta))\n",
    "resultMatrix = pd.DataFrame(filledMatrix_slice.dot(theta))\n",
    "\n",
    "with open('./YahooMusic/scores.txt','rt') as filer:\n",
    "    tracktrack= pd.read_csv(filer,sep='|',header = None)\n",
    "    tracktrack['1/0'] = 1\n",
    "\n",
    "useri = 0\n",
    "while useri < 94290:\n",
    "    finalscore = resultMatrix.iloc[useri:useri+6,0].sort_values()\n",
    "    for iii in range(0,3):\n",
    "        tracktrack.iloc[finalscore.index[iii],25] = 0\n",
    "    useri += 6\n",
    "    \n",
    "r = tracktrack['1/0']\n",
    "r.to_csv('./result//result2.txt', header=False, index=False, sep='\\t', mode='a') # output the result \n",
    "print('finish')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 258,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>16</th>\n",
       "      <th>17</th>\n",
       "      <th>18</th>\n",
       "      <th>19</th>\n",
       "      <th>20</th>\n",
       "      <th>21</th>\n",
       "      <th>22</th>\n",
       "      <th>23</th>\n",
       "      <th>24</th>\n",
       "      <th>1/0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>188135</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>250273</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>60428</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>187953</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>108088</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>52615</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3</td>\n",
       "      <td>170331</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3</td>\n",
       "      <td>53881</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3</td>\n",
       "      <td>92079</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>3</td>\n",
       "      <td>1199</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>3</td>\n",
       "      <td>72035</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>3</td>\n",
       "      <td>164737</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>5</td>\n",
       "      <td>230811</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>5</td>\n",
       "      <td>223222</td>\n",
       "      <td>70.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>5</td>\n",
       "      <td>11786</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>5</td>\n",
       "      <td>16367</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>5</td>\n",
       "      <td>76149</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>5</td>\n",
       "      <td>234512</td>\n",
       "      <td>70.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>9</td>\n",
       "      <td>213659</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>9</td>\n",
       "      <td>195174</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>9</td>\n",
       "      <td>119128</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>9</td>\n",
       "      <td>177509</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>9</td>\n",
       "      <td>150618</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>9</td>\n",
       "      <td>267024</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>10</td>\n",
       "      <td>136562</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>10</td>\n",
       "      <td>101910</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>10</td>\n",
       "      <td>283051</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>10</td>\n",
       "      <td>187560</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>10</td>\n",
       "      <td>47528</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>10</td>\n",
       "      <td>120383</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.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>94260</th>\n",
       "      <td>38450</td>\n",
       "      <td>29228</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94261</th>\n",
       "      <td>38450</td>\n",
       "      <td>185436</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94262</th>\n",
       "      <td>38450</td>\n",
       "      <td>105431</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94263</th>\n",
       "      <td>38450</td>\n",
       "      <td>135186</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94264</th>\n",
       "      <td>38450</td>\n",
       "      <td>32606</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94265</th>\n",
       "      <td>38450</td>\n",
       "      <td>248452</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94266</th>\n",
       "      <td>38452</td>\n",
       "      <td>225319</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94267</th>\n",
       "      <td>38452</td>\n",
       "      <td>229447</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94268</th>\n",
       "      <td>38452</td>\n",
       "      <td>164660</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94269</th>\n",
       "      <td>38452</td>\n",
       "      <td>61686</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94270</th>\n",
       "      <td>38452</td>\n",
       "      <td>147741</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94271</th>\n",
       "      <td>38452</td>\n",
       "      <td>217200</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94272</th>\n",
       "      <td>38453</td>\n",
       "      <td>210682</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94273</th>\n",
       "      <td>38453</td>\n",
       "      <td>175349</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94274</th>\n",
       "      <td>38453</td>\n",
       "      <td>183431</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94275</th>\n",
       "      <td>38453</td>\n",
       "      <td>277735</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94276</th>\n",
       "      <td>38453</td>\n",
       "      <td>23164</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94277</th>\n",
       "      <td>38453</td>\n",
       "      <td>272763</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94278</th>\n",
       "      <td>38459</td>\n",
       "      <td>247218</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94279</th>\n",
       "      <td>38459</td>\n",
       "      <td>106291</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94280</th>\n",
       "      <td>38459</td>\n",
       "      <td>121620</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94281</th>\n",
       "      <td>38459</td>\n",
       "      <td>290018</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94282</th>\n",
       "      <td>38459</td>\n",
       "      <td>26094</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94283</th>\n",
       "      <td>38459</td>\n",
       "      <td>120121</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94284</th>\n",
       "      <td>38465</td>\n",
       "      <td>245719</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94285</th>\n",
       "      <td>38465</td>\n",
       "      <td>54238</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94286</th>\n",
       "      <td>38465</td>\n",
       "      <td>228598</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94287</th>\n",
       "      <td>38465</td>\n",
       "      <td>217068</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94288</th>\n",
       "      <td>38465</td>\n",
       "      <td>257173</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94289</th>\n",
       "      <td>38465</td>\n",
       "      <td>31358</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>94290 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           0       1     2     3     4     5    6    7    8    9 ...    16  \\\n",
       "0          1  188135  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "1          1  250273  90.0  90.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "2          1   60428  -1.0  90.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "3          1  187953  90.0  90.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "4          1  108088  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "5          1   52615  90.0  90.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "6          3  170331  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "7          3   53881   0.0   0.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "8          3   92079  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "9          3    1199  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "10         3   72035  30.0   0.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "11         3  164737   0.0   0.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "12         5  230811  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "13         5  223222  70.0  70.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "14         5   11786  -1.0  90.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "15         5   16367  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "16         5   76149  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "17         5  234512  70.0  70.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "18         9  213659  90.0  90.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "19         9  195174  -1.0  90.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "20         9  119128  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "21         9  177509  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "22         9  150618  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "23         9  267024  90.0  90.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "24        10  136562  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "25        10  101910  90.0  90.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "26        10  283051  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "27        10  187560  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "28        10   47528  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "29        10  120383  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "...      ...     ...   ...   ...   ...   ...  ...  ...  ...  ... ...   ...   \n",
       "94260  38450   29228  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94261  38450  185436  -1.0  -1.0  50.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94262  38450  105431  90.0  90.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94263  38450  135186  90.0  90.0  80.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94264  38450   32606  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94265  38450  248452  -1.0  -1.0  70.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94266  38452  225319  90.0  90.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94267  38452  229447  90.0  90.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94268  38452  164660  90.0  90.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94269  38452   61686  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94270  38452  147741  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94271  38452  217200  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94272  38453  210682  90.0  90.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94273  38453  175349  90.0  90.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94274  38453  183431  -1.0  90.0   0.0   0.0  0.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94275  38453  277735  -1.0  -1.0   0.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94276  38453   23164  -1.0  -1.0   0.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94277  38453  272763  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94278  38459  247218  90.0  90.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94279  38459  106291  90.0  90.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94280  38459  121620  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94281  38459  290018  90.0  90.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94282  38459   26094  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94283  38459  120121  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94284  38465  245719  90.0  90.0  80.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94285  38465   54238  90.0  90.0  80.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94286  38465  228598  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94287  38465  217068  90.0  90.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94288  38465  257173  -1.0  -1.0  -1.0  -1.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "94289  38465   31358  -1.0  -1.0  80.0  80.0 -1.0 -1.0 -1.0 -1.0 ...  -1.0   \n",
       "\n",
       "        17   18   19   20   21   22   23   24  1/0  \n",
       "0     -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "1     -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "2     -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "3     -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "4     -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "5     -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "6     -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "7     -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "8     -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "9     -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "10    -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "11    -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "12    -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "13    -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "14    -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "15    -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "16    -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "17    -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "18    -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "19    -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "20    -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "21    -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "22    -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "23    -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "24    -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "25    -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "26    -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "27    -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "28    -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "29    -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "...    ...  ...  ...  ...  ...  ...  ...  ...  ...  \n",
       "94260 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "94261 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "94262 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "94263 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "94264 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "94265 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "94266 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "94267 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "94268 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "94269 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "94270 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "94271 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "94272 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "94273 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "94274 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "94275 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "94276 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "94277 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "94278 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "94279 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "94280 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "94281 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "94282 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "94283 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "94284 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "94285 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "94286 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "94287 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "94288 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    0  \n",
       "94289 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0    1  \n",
       "\n",
       "[94290 rows x 26 columns]"
      ]
     },
     "execution_count": 258,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tracktrack"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}