Busiest_Roads_2011_2012.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Importing Packages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "%matplotlib inline\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import pandas as pd\n",
    "import math"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "sns.set(style=\"whitegrid\", color_codes=True)\n",
    "plt.style.use('ggplot')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1 = pd.read_csv(\"Data_cleaned_2011.csv\")\n",
    "df2 = pd.read_csv(\"Data_cleaned_2012.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1 = df1.dropna()\n",
    "df1['GIS ID'] = df1['GIS ID'].astype(int)\n",
    "df1[li] = df1[li].astype(int)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### WORKING PART"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [],
   "source": [
    "li = ['12:00-1:00 AM','1:00-2:00AM', '2:00-3:00AM','3:00-4:00AM', '4:00-5:00AM','5:00-6:00AM', '6:00-7:00AM','7:00-8:00AM',\n",
    "      '8:00-9:00AM','9:00-10:00AM','10:00-11:00AM','11:00-12:00PM','12:00-1:00PM', '1:00-2:00PM', '2:00-3:00PM', '3:00-4:00PM',\n",
    "      '4:00-5:00PM', '5:00-6:00PM','6:00-7:00PM','7:00-8:00PM','8:00-9:00PM', '9:00-10:00PM', '10:00-11:00PM', '11:00-12:00AM']\n",
    "y1 = {}\n",
    "y2 = {}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "def street_average(st_id, col, y, df):\n",
    "    m = []\n",
    "    x = df.loc[df[col] == st_id]\n",
    "    x = pd.DataFrame(x)\n",
    "    #print(x['Segment ID'])\n",
    "    for i in li:\n",
    "        sum = 0\n",
    "        ctr = 0\n",
    "        avg = 0\n",
    "        for index, rows in x[i].iteritems():\n",
    "            sum = sum + x[i].loc[index]\n",
    "            ctr = ctr+1;\n",
    "        avg = math.ceil(sum/ctr)    \n",
    "        m.append(avg)\n",
    "    y[st_id] = m"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "streets1 = list(set(df1['GIS ID']))\n",
    "streets2 = list(set(df2['Segment ID']))\n",
    "for i in streets1:\n",
    "    street_average(i, 'GIS ID', y1, df1)\n",
    "for i in streets2:\n",
    "    street_average(i,  'Segment ID', y2, df2)    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "378\n",
      "376\n"
     ]
    }
   ],
   "source": [
    "print(len(y1))\n",
    "print(len(y2))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "max1 = {}\n",
    "max2 = {}\n",
    "for i in y1.keys():\n",
    "    max1[i] = np.mean(y1[i])\n",
    "for i in y2.keys():\n",
    "    max2[i] = np.mean(y2[i])    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "max1 = sorted(y1.items(), key=lambda x: x[1])[-1: -6:-1]\n",
    "max2 = sorted(y2.items(), key=lambda x: x[1])[-1: -6:-1]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### CHECKING FOR COMMON BUSY ROADS:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in max1:\n",
    "    if(i[0] in [x[0] for x in max2]):\n",
    "        print(i[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [],
   "source": [
    "## No common busy roads between 2011, 2012"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "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>Unnamed: 0</th>\n",
       "      <th>ID</th>\n",
       "      <th>GIS ID</th>\n",
       "      <th>Roadway Name</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>Direction</th>\n",
       "      <th>Date</th>\n",
       "      <th>12:00-1:00 AM</th>\n",
       "      <th>1:00-2:00AM</th>\n",
       "      <th>...</th>\n",
       "      <th>2:00-3:00PM</th>\n",
       "      <th>3:00-4:00PM</th>\n",
       "      <th>4:00-5:00PM</th>\n",
       "      <th>5:00-6:00PM</th>\n",
       "      <th>6:00-7:00PM</th>\n",
       "      <th>7:00-8:00PM</th>\n",
       "      <th>8:00-9:00PM</th>\n",
       "      <th>9:00-10:00PM</th>\n",
       "      <th>10:00-11:00PM</th>\n",
       "      <th>11:00-12:00AM</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1169</th>\n",
       "      <td>1169.0</td>\n",
       "      <td>1170.0</td>\n",
       "      <td>62767</td>\n",
       "      <td>SO CONDUIT AVE</td>\n",
       "      <td>182ND ST</td>\n",
       "      <td>181ST ST</td>\n",
       "      <td>EB</td>\n",
       "      <td>02-07-2012</td>\n",
       "      <td>651</td>\n",
       "      <td>365</td>\n",
       "      <td>...</td>\n",
       "      <td>2107</td>\n",
       "      <td>3155</td>\n",
       "      <td>3701</td>\n",
       "      <td>3751</td>\n",
       "      <td>3457</td>\n",
       "      <td>2171</td>\n",
       "      <td>1567</td>\n",
       "      <td>1278</td>\n",
       "      <td>1191</td>\n",
       "      <td>937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1170</th>\n",
       "      <td>1170.0</td>\n",
       "      <td>1171.0</td>\n",
       "      <td>62767</td>\n",
       "      <td>SO CONDUIT AVE</td>\n",
       "      <td>182ND ST</td>\n",
       "      <td>181ST ST</td>\n",
       "      <td>EB</td>\n",
       "      <td>02-08-2012</td>\n",
       "      <td>717</td>\n",
       "      <td>419</td>\n",
       "      <td>...</td>\n",
       "      <td>2137</td>\n",
       "      <td>3307</td>\n",
       "      <td>3621</td>\n",
       "      <td>3391</td>\n",
       "      <td>3021</td>\n",
       "      <td>2131</td>\n",
       "      <td>1589</td>\n",
       "      <td>1301</td>\n",
       "      <td>1214</td>\n",
       "      <td>949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1171</th>\n",
       "      <td>1171.0</td>\n",
       "      <td>1172.0</td>\n",
       "      <td>62767</td>\n",
       "      <td>SO CONDUIT AVE</td>\n",
       "      <td>182ND ST</td>\n",
       "      <td>181ST ST</td>\n",
       "      <td>EB</td>\n",
       "      <td>02-09-2012</td>\n",
       "      <td>770</td>\n",
       "      <td>384</td>\n",
       "      <td>...</td>\n",
       "      <td>2238</td>\n",
       "      <td>3308</td>\n",
       "      <td>3503</td>\n",
       "      <td>3503</td>\n",
       "      <td>3267</td>\n",
       "      <td>3010</td>\n",
       "      <td>1768</td>\n",
       "      <td>1410</td>\n",
       "      <td>1261</td>\n",
       "      <td>973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1172</th>\n",
       "      <td>1172.0</td>\n",
       "      <td>1173.0</td>\n",
       "      <td>62767</td>\n",
       "      <td>SO CONDUIT AVE</td>\n",
       "      <td>182ND ST</td>\n",
       "      <td>181ST ST</td>\n",
       "      <td>EB</td>\n",
       "      <td>02-10-2012</td>\n",
       "      <td>692</td>\n",
       "      <td>402</td>\n",
       "      <td>...</td>\n",
       "      <td>2377</td>\n",
       "      <td>3345</td>\n",
       "      <td>3645</td>\n",
       "      <td>3690</td>\n",
       "      <td>3489</td>\n",
       "      <td>3012</td>\n",
       "      <td>1944</td>\n",
       "      <td>1475</td>\n",
       "      <td>1342</td>\n",
       "      <td>1220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1173</th>\n",
       "      <td>1173.0</td>\n",
       "      <td>1174.0</td>\n",
       "      <td>62767</td>\n",
       "      <td>SO CONDUIT AVE</td>\n",
       "      <td>182ND ST</td>\n",
       "      <td>181ST ST</td>\n",
       "      <td>EB</td>\n",
       "      <td>02-11-2012</td>\n",
       "      <td>989</td>\n",
       "      <td>643</td>\n",
       "      <td>...</td>\n",
       "      <td>1973</td>\n",
       "      <td>2155</td>\n",
       "      <td>2410</td>\n",
       "      <td>2347</td>\n",
       "      <td>2120</td>\n",
       "      <td>1736</td>\n",
       "      <td>1504</td>\n",
       "      <td>1363</td>\n",
       "      <td>1254</td>\n",
       "      <td>1086</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1174</th>\n",
       "      <td>1174.0</td>\n",
       "      <td>1175.0</td>\n",
       "      <td>62767</td>\n",
       "      <td>SO CONDUIT AVE</td>\n",
       "      <td>182ND ST</td>\n",
       "      <td>181ST ST</td>\n",
       "      <td>EB</td>\n",
       "      <td>02-12-2012</td>\n",
       "      <td>928</td>\n",
       "      <td>600</td>\n",
       "      <td>...</td>\n",
       "      <td>2167</td>\n",
       "      <td>3054</td>\n",
       "      <td>3376</td>\n",
       "      <td>3337</td>\n",
       "      <td>3071</td>\n",
       "      <td>2412</td>\n",
       "      <td>1675</td>\n",
       "      <td>1366</td>\n",
       "      <td>1253</td>\n",
       "      <td>1033</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0      ID  GIS ID    Roadway Name      From        To  \\\n",
       "1169      1169.0  1170.0   62767  SO CONDUIT AVE  182ND ST  181ST ST   \n",
       "1170      1170.0  1171.0   62767  SO CONDUIT AVE  182ND ST  181ST ST   \n",
       "1171      1171.0  1172.0   62767  SO CONDUIT AVE  182ND ST  181ST ST   \n",
       "1172      1172.0  1173.0   62767  SO CONDUIT AVE  182ND ST  181ST ST   \n",
       "1173      1173.0  1174.0   62767  SO CONDUIT AVE  182ND ST  181ST ST   \n",
       "1174      1174.0  1175.0   62767  SO CONDUIT AVE  182ND ST  181ST ST   \n",
       "\n",
       "     Direction        Date  12:00-1:00 AM  1:00-2:00AM      ...        \\\n",
       "1169        EB  02-07-2012            651          365      ...         \n",
       "1170        EB  02-08-2012            717          419      ...         \n",
       "1171        EB  02-09-2012            770          384      ...         \n",
       "1172        EB  02-10-2012            692          402      ...         \n",
       "1173        EB  02-11-2012            989          643      ...         \n",
       "1174        EB  02-12-2012            928          600      ...         \n",
       "\n",
       "      2:00-3:00PM  3:00-4:00PM  4:00-5:00PM  5:00-6:00PM  6:00-7:00PM  \\\n",
       "1169         2107         3155         3701         3751         3457   \n",
       "1170         2137         3307         3621         3391         3021   \n",
       "1171         2238         3308         3503         3503         3267   \n",
       "1172         2377         3345         3645         3690         3489   \n",
       "1173         1973         2155         2410         2347         2120   \n",
       "1174         2167         3054         3376         3337         3071   \n",
       "\n",
       "      7:00-8:00PM  8:00-9:00PM  9:00-10:00PM  10:00-11:00PM  11:00-12:00AM  \n",
       "1169         2171         1567          1278           1191            937  \n",
       "1170         2131         1589          1301           1214            949  \n",
       "1171         3010         1768          1410           1261            973  \n",
       "1172         3012         1944          1475           1342           1220  \n",
       "1173         1736         1504          1363           1254           1086  \n",
       "1174         2412         1675          1366           1253           1033  \n",
       "\n",
       "[6 rows x 32 columns]"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.loc[df1[\"GIS ID\"]==62767] ### Airport Road"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "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>Unnamed: 0</th>\n",
       "      <th>ID</th>\n",
       "      <th>GIS ID</th>\n",
       "      <th>Roadway Name</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>Direction</th>\n",
       "      <th>Date</th>\n",
       "      <th>12:00-1:00 AM</th>\n",
       "      <th>1:00-2:00AM</th>\n",
       "      <th>...</th>\n",
       "      <th>2:00-3:00PM</th>\n",
       "      <th>3:00-4:00PM</th>\n",
       "      <th>4:00-5:00PM</th>\n",
       "      <th>5:00-6:00PM</th>\n",
       "      <th>6:00-7:00PM</th>\n",
       "      <th>7:00-8:00PM</th>\n",
       "      <th>8:00-9:00PM</th>\n",
       "      <th>9:00-10:00PM</th>\n",
       "      <th>10:00-11:00PM</th>\n",
       "      <th>11:00-12:00AM</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2581</th>\n",
       "      <td>2581.0</td>\n",
       "      <td>2582.0</td>\n",
       "      <td>52592</td>\n",
       "      <td>WOODHAVEN BOULEVARD</td>\n",
       "      <td>75 AVENUE</td>\n",
       "      <td>76 AVENUE</td>\n",
       "      <td>NB</td>\n",
       "      <td>02-09-2012</td>\n",
       "      <td>218</td>\n",
       "      <td>157</td>\n",
       "      <td>...</td>\n",
       "      <td>1604</td>\n",
       "      <td>1622</td>\n",
       "      <td>1585</td>\n",
       "      <td>1583</td>\n",
       "      <td>1454</td>\n",
       "      <td>1176</td>\n",
       "      <td>934</td>\n",
       "      <td>770</td>\n",
       "      <td>645</td>\n",
       "      <td>473</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2582</th>\n",
       "      <td>2582.0</td>\n",
       "      <td>2583.0</td>\n",
       "      <td>52592</td>\n",
       "      <td>WOODHAVEN BOULEVARD</td>\n",
       "      <td>75 AVENUE</td>\n",
       "      <td>76 AVENUE</td>\n",
       "      <td>NB</td>\n",
       "      <td>02-10-2012</td>\n",
       "      <td>309</td>\n",
       "      <td>186</td>\n",
       "      <td>...</td>\n",
       "      <td>1526</td>\n",
       "      <td>1638</td>\n",
       "      <td>1654</td>\n",
       "      <td>1647</td>\n",
       "      <td>1539</td>\n",
       "      <td>1525</td>\n",
       "      <td>1217</td>\n",
       "      <td>969</td>\n",
       "      <td>834</td>\n",
       "      <td>688</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2583</th>\n",
       "      <td>2583.0</td>\n",
       "      <td>2584.0</td>\n",
       "      <td>52592</td>\n",
       "      <td>WOODHAVEN BOULEVARD</td>\n",
       "      <td>75 AVENUE</td>\n",
       "      <td>76 AVENUE</td>\n",
       "      <td>NB</td>\n",
       "      <td>02-11-2012</td>\n",
       "      <td>536</td>\n",
       "      <td>316</td>\n",
       "      <td>...</td>\n",
       "      <td>1654</td>\n",
       "      <td>1674</td>\n",
       "      <td>1652</td>\n",
       "      <td>1578</td>\n",
       "      <td>1485</td>\n",
       "      <td>1431</td>\n",
       "      <td>1122</td>\n",
       "      <td>923</td>\n",
       "      <td>885</td>\n",
       "      <td>688</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2584</th>\n",
       "      <td>2584.0</td>\n",
       "      <td>2585.0</td>\n",
       "      <td>52592</td>\n",
       "      <td>WOODHAVEN BOULEVARD</td>\n",
       "      <td>75 AVENUE</td>\n",
       "      <td>76 AVENUE</td>\n",
       "      <td>NB</td>\n",
       "      <td>02-12-2012</td>\n",
       "      <td>572</td>\n",
       "      <td>375</td>\n",
       "      <td>...</td>\n",
       "      <td>1611</td>\n",
       "      <td>1597</td>\n",
       "      <td>1547</td>\n",
       "      <td>1457</td>\n",
       "      <td>1391</td>\n",
       "      <td>1002</td>\n",
       "      <td>745</td>\n",
       "      <td>622</td>\n",
       "      <td>581</td>\n",
       "      <td>374</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2585</th>\n",
       "      <td>2585.0</td>\n",
       "      <td>2586.0</td>\n",
       "      <td>52592</td>\n",
       "      <td>WOODHAVEN BOULEVARD</td>\n",
       "      <td>75 AVENUE</td>\n",
       "      <td>76 AVENUE</td>\n",
       "      <td>NB</td>\n",
       "      <td>02-13-2012</td>\n",
       "      <td>269</td>\n",
       "      <td>152</td>\n",
       "      <td>...</td>\n",
       "      <td>1496</td>\n",
       "      <td>1531</td>\n",
       "      <td>1531</td>\n",
       "      <td>1587</td>\n",
       "      <td>1393</td>\n",
       "      <td>1197</td>\n",
       "      <td>862</td>\n",
       "      <td>712</td>\n",
       "      <td>553</td>\n",
       "      <td>418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2586</th>\n",
       "      <td>2586.0</td>\n",
       "      <td>2587.0</td>\n",
       "      <td>52592</td>\n",
       "      <td>WOODHAVEN BOULEVARD</td>\n",
       "      <td>75 AVENUE</td>\n",
       "      <td>76 AVENUE</td>\n",
       "      <td>NB</td>\n",
       "      <td>02-14-2012</td>\n",
       "      <td>217</td>\n",
       "      <td>153</td>\n",
       "      <td>...</td>\n",
       "      <td>1632</td>\n",
       "      <td>1780</td>\n",
       "      <td>1791</td>\n",
       "      <td>1754</td>\n",
       "      <td>1662</td>\n",
       "      <td>1406</td>\n",
       "      <td>1169</td>\n",
       "      <td>954</td>\n",
       "      <td>798</td>\n",
       "      <td>640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2587</th>\n",
       "      <td>2587.0</td>\n",
       "      <td>2588.0</td>\n",
       "      <td>52592</td>\n",
       "      <td>WOODHAVEN BOULEVARD</td>\n",
       "      <td>75 AVENUE</td>\n",
       "      <td>76 AVENUE</td>\n",
       "      <td>SB</td>\n",
       "      <td>02-09-2012</td>\n",
       "      <td>461</td>\n",
       "      <td>271</td>\n",
       "      <td>...</td>\n",
       "      <td>1767</td>\n",
       "      <td>2094</td>\n",
       "      <td>2165</td>\n",
       "      <td>2124</td>\n",
       "      <td>2123</td>\n",
       "      <td>1487</td>\n",
       "      <td>1507</td>\n",
       "      <td>1237</td>\n",
       "      <td>920</td>\n",
       "      <td>677</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2588</th>\n",
       "      <td>2588.0</td>\n",
       "      <td>2589.0</td>\n",
       "      <td>52592</td>\n",
       "      <td>WOODHAVEN BOULEVARD</td>\n",
       "      <td>75 AVENUE</td>\n",
       "      <td>76 AVENUE</td>\n",
       "      <td>SB</td>\n",
       "      <td>02-10-2012</td>\n",
       "      <td>544</td>\n",
       "      <td>281</td>\n",
       "      <td>...</td>\n",
       "      <td>1919</td>\n",
       "      <td>2170</td>\n",
       "      <td>2196</td>\n",
       "      <td>2181</td>\n",
       "      <td>2066</td>\n",
       "      <td>1845</td>\n",
       "      <td>1531</td>\n",
       "      <td>1265</td>\n",
       "      <td>1140</td>\n",
       "      <td>981</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2589</th>\n",
       "      <td>2589.0</td>\n",
       "      <td>2590.0</td>\n",
       "      <td>52592</td>\n",
       "      <td>WOODHAVEN BOULEVARD</td>\n",
       "      <td>75 AVENUE</td>\n",
       "      <td>76 AVENUE</td>\n",
       "      <td>SB</td>\n",
       "      <td>02-11-2012</td>\n",
       "      <td>778</td>\n",
       "      <td>519</td>\n",
       "      <td>...</td>\n",
       "      <td>1584</td>\n",
       "      <td>1739</td>\n",
       "      <td>1718</td>\n",
       "      <td>1644</td>\n",
       "      <td>1553</td>\n",
       "      <td>1457</td>\n",
       "      <td>1286</td>\n",
       "      <td>1134</td>\n",
       "      <td>1053</td>\n",
       "      <td>908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2590</th>\n",
       "      <td>2590.0</td>\n",
       "      <td>2591.0</td>\n",
       "      <td>52592</td>\n",
       "      <td>WOODHAVEN BOULEVARD</td>\n",
       "      <td>75 AVENUE</td>\n",
       "      <td>76 AVENUE</td>\n",
       "      <td>SB</td>\n",
       "      <td>02-12-2012</td>\n",
       "      <td>722</td>\n",
       "      <td>491</td>\n",
       "      <td>...</td>\n",
       "      <td>1465</td>\n",
       "      <td>1649</td>\n",
       "      <td>1652</td>\n",
       "      <td>1518</td>\n",
       "      <td>1538</td>\n",
       "      <td>1293</td>\n",
       "      <td>1148</td>\n",
       "      <td>801</td>\n",
       "      <td>599</td>\n",
       "      <td>564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2591</th>\n",
       "      <td>2591.0</td>\n",
       "      <td>2592.0</td>\n",
       "      <td>52592</td>\n",
       "      <td>WOODHAVEN BOULEVARD</td>\n",
       "      <td>75 AVENUE</td>\n",
       "      <td>76 AVENUE</td>\n",
       "      <td>SB</td>\n",
       "      <td>02-13-2012</td>\n",
       "      <td>391</td>\n",
       "      <td>183</td>\n",
       "      <td>...</td>\n",
       "      <td>1689</td>\n",
       "      <td>2078</td>\n",
       "      <td>2203</td>\n",
       "      <td>2213</td>\n",
       "      <td>2077</td>\n",
       "      <td>1645</td>\n",
       "      <td>1335</td>\n",
       "      <td>1098</td>\n",
       "      <td>770</td>\n",
       "      <td>626</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2592</th>\n",
       "      <td>2592.0</td>\n",
       "      <td>2593.0</td>\n",
       "      <td>52592</td>\n",
       "      <td>WOODHAVEN BOULEVARD</td>\n",
       "      <td>75 AVENUE</td>\n",
       "      <td>76 AVENUE</td>\n",
       "      <td>SB</td>\n",
       "      <td>02-14-2012</td>\n",
       "      <td>451</td>\n",
       "      <td>246</td>\n",
       "      <td>...</td>\n",
       "      <td>1632</td>\n",
       "      <td>1780</td>\n",
       "      <td>1791</td>\n",
       "      <td>1754</td>\n",
       "      <td>1662</td>\n",
       "      <td>1406</td>\n",
       "      <td>1169</td>\n",
       "      <td>954</td>\n",
       "      <td>798</td>\n",
       "      <td>640</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0      ID  GIS ID         Roadway Name       From         To  \\\n",
       "2581      2581.0  2582.0   52592  WOODHAVEN BOULEVARD  75 AVENUE  76 AVENUE   \n",
       "2582      2582.0  2583.0   52592  WOODHAVEN BOULEVARD  75 AVENUE  76 AVENUE   \n",
       "2583      2583.0  2584.0   52592  WOODHAVEN BOULEVARD  75 AVENUE  76 AVENUE   \n",
       "2584      2584.0  2585.0   52592  WOODHAVEN BOULEVARD  75 AVENUE  76 AVENUE   \n",
       "2585      2585.0  2586.0   52592  WOODHAVEN BOULEVARD  75 AVENUE  76 AVENUE   \n",
       "2586      2586.0  2587.0   52592  WOODHAVEN BOULEVARD  75 AVENUE  76 AVENUE   \n",
       "2587      2587.0  2588.0   52592  WOODHAVEN BOULEVARD  75 AVENUE  76 AVENUE   \n",
       "2588      2588.0  2589.0   52592  WOODHAVEN BOULEVARD  75 AVENUE  76 AVENUE   \n",
       "2589      2589.0  2590.0   52592  WOODHAVEN BOULEVARD  75 AVENUE  76 AVENUE   \n",
       "2590      2590.0  2591.0   52592  WOODHAVEN BOULEVARD  75 AVENUE  76 AVENUE   \n",
       "2591      2591.0  2592.0   52592  WOODHAVEN BOULEVARD  75 AVENUE  76 AVENUE   \n",
       "2592      2592.0  2593.0   52592  WOODHAVEN BOULEVARD  75 AVENUE  76 AVENUE   \n",
       "\n",
       "     Direction        Date  12:00-1:00 AM  1:00-2:00AM      ...        \\\n",
       "2581        NB  02-09-2012            218          157      ...         \n",
       "2582        NB  02-10-2012            309          186      ...         \n",
       "2583        NB  02-11-2012            536          316      ...         \n",
       "2584        NB  02-12-2012            572          375      ...         \n",
       "2585        NB  02-13-2012            269          152      ...         \n",
       "2586        NB  02-14-2012            217          153      ...         \n",
       "2587        SB  02-09-2012            461          271      ...         \n",
       "2588        SB  02-10-2012            544          281      ...         \n",
       "2589        SB  02-11-2012            778          519      ...         \n",
       "2590        SB  02-12-2012            722          491      ...         \n",
       "2591        SB  02-13-2012            391          183      ...         \n",
       "2592        SB  02-14-2012            451          246      ...         \n",
       "\n",
       "      2:00-3:00PM  3:00-4:00PM  4:00-5:00PM  5:00-6:00PM  6:00-7:00PM  \\\n",
       "2581         1604         1622         1585         1583         1454   \n",
       "2582         1526         1638         1654         1647         1539   \n",
       "2583         1654         1674         1652         1578         1485   \n",
       "2584         1611         1597         1547         1457         1391   \n",
       "2585         1496         1531         1531         1587         1393   \n",
       "2586         1632         1780         1791         1754         1662   \n",
       "2587         1767         2094         2165         2124         2123   \n",
       "2588         1919         2170         2196         2181         2066   \n",
       "2589         1584         1739         1718         1644         1553   \n",
       "2590         1465         1649         1652         1518         1538   \n",
       "2591         1689         2078         2203         2213         2077   \n",
       "2592         1632         1780         1791         1754         1662   \n",
       "\n",
       "      7:00-8:00PM  8:00-9:00PM  9:00-10:00PM  10:00-11:00PM  11:00-12:00AM  \n",
       "2581         1176          934           770            645            473  \n",
       "2582         1525         1217           969            834            688  \n",
       "2583         1431         1122           923            885            688  \n",
       "2584         1002          745           622            581            374  \n",
       "2585         1197          862           712            553            418  \n",
       "2586         1406         1169           954            798            640  \n",
       "2587         1487         1507          1237            920            677  \n",
       "2588         1845         1531          1265           1140            981  \n",
       "2589         1457         1286          1134           1053            908  \n",
       "2590         1293         1148           801            599            564  \n",
       "2591         1645         1335          1098            770            626  \n",
       "2592         1406         1169           954            798            640  \n",
       "\n",
       "[12 rows x 32 columns]"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.loc[df1[\"GIS ID\"]==52592]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "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>Unnamed: 0</th>\n",
       "      <th>ID</th>\n",
       "      <th>GIS ID</th>\n",
       "      <th>Roadway Name</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>Direction</th>\n",
       "      <th>Date</th>\n",
       "      <th>12:00-1:00 AM</th>\n",
       "      <th>1:00-2:00AM</th>\n",
       "      <th>...</th>\n",
       "      <th>2:00-3:00PM</th>\n",
       "      <th>3:00-4:00PM</th>\n",
       "      <th>4:00-5:00PM</th>\n",
       "      <th>5:00-6:00PM</th>\n",
       "      <th>6:00-7:00PM</th>\n",
       "      <th>7:00-8:00PM</th>\n",
       "      <th>8:00-9:00PM</th>\n",
       "      <th>9:00-10:00PM</th>\n",
       "      <th>10:00-11:00PM</th>\n",
       "      <th>11:00-12:00AM</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3260</th>\n",
       "      <td>3260.0</td>\n",
       "      <td>3261.0</td>\n",
       "      <td>178394</td>\n",
       "      <td>EAST GUN HILL ROAD</td>\n",
       "      <td>BRONX RIVER PARKWAY SB EXIT 9</td>\n",
       "      <td>BRONX RIVER PARKWAY</td>\n",
       "      <td>EB</td>\n",
       "      <td>02-07-2012</td>\n",
       "      <td>168</td>\n",
       "      <td>155</td>\n",
       "      <td>...</td>\n",
       "      <td>820</td>\n",
       "      <td>1109</td>\n",
       "      <td>1173</td>\n",
       "      <td>1127</td>\n",
       "      <td>1078</td>\n",
       "      <td>1000</td>\n",
       "      <td>759</td>\n",
       "      <td>643</td>\n",
       "      <td>502</td>\n",
       "      <td>442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3261</th>\n",
       "      <td>3261.0</td>\n",
       "      <td>3262.0</td>\n",
       "      <td>178394</td>\n",
       "      <td>EAST GUN HILL ROAD</td>\n",
       "      <td>BRONX RIVER PARKWAY SB EXIT 9</td>\n",
       "      <td>BRONX RIVER PARKWAY</td>\n",
       "      <td>EB</td>\n",
       "      <td>02-08-2012</td>\n",
       "      <td>321</td>\n",
       "      <td>190</td>\n",
       "      <td>...</td>\n",
       "      <td>839</td>\n",
       "      <td>1001</td>\n",
       "      <td>1115</td>\n",
       "      <td>1191</td>\n",
       "      <td>1119</td>\n",
       "      <td>911</td>\n",
       "      <td>807</td>\n",
       "      <td>675</td>\n",
       "      <td>495</td>\n",
       "      <td>465</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3262</th>\n",
       "      <td>3262.0</td>\n",
       "      <td>3263.0</td>\n",
       "      <td>178394</td>\n",
       "      <td>EAST GUN HILL ROAD</td>\n",
       "      <td>BRONX RIVER PARKWAY SB EXIT 9</td>\n",
       "      <td>BRONX RIVER PARKWAY</td>\n",
       "      <td>EB</td>\n",
       "      <td>02-09-2012</td>\n",
       "      <td>306</td>\n",
       "      <td>180</td>\n",
       "      <td>...</td>\n",
       "      <td>883</td>\n",
       "      <td>1081</td>\n",
       "      <td>1148</td>\n",
       "      <td>1198</td>\n",
       "      <td>1151</td>\n",
       "      <td>951</td>\n",
       "      <td>780</td>\n",
       "      <td>669</td>\n",
       "      <td>530</td>\n",
       "      <td>502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3263</th>\n",
       "      <td>3263.0</td>\n",
       "      <td>3264.0</td>\n",
       "      <td>178394</td>\n",
       "      <td>EAST GUN HILL ROAD</td>\n",
       "      <td>BRONX RIVER PARKWAY SB EXIT 9</td>\n",
       "      <td>BRONX RIVER PARKWAY</td>\n",
       "      <td>EB</td>\n",
       "      <td>02-10-2012</td>\n",
       "      <td>356</td>\n",
       "      <td>217</td>\n",
       "      <td>...</td>\n",
       "      <td>884</td>\n",
       "      <td>1070</td>\n",
       "      <td>1170</td>\n",
       "      <td>1218</td>\n",
       "      <td>1136</td>\n",
       "      <td>1062</td>\n",
       "      <td>892</td>\n",
       "      <td>755</td>\n",
       "      <td>645</td>\n",
       "      <td>638</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3264</th>\n",
       "      <td>3264.0</td>\n",
       "      <td>3265.0</td>\n",
       "      <td>178394</td>\n",
       "      <td>EAST GUN HILL ROAD</td>\n",
       "      <td>BRONX RIVER PARKWAY SB EXIT 9</td>\n",
       "      <td>BRONX RIVER PARKWAY</td>\n",
       "      <td>EB</td>\n",
       "      <td>02-11-2012</td>\n",
       "      <td>494</td>\n",
       "      <td>322</td>\n",
       "      <td>...</td>\n",
       "      <td>853</td>\n",
       "      <td>988</td>\n",
       "      <td>991</td>\n",
       "      <td>897</td>\n",
       "      <td>886</td>\n",
       "      <td>897</td>\n",
       "      <td>788</td>\n",
       "      <td>664</td>\n",
       "      <td>578</td>\n",
       "      <td>622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3265</th>\n",
       "      <td>3265.0</td>\n",
       "      <td>3266.0</td>\n",
       "      <td>178394</td>\n",
       "      <td>EAST GUN HILL ROAD</td>\n",
       "      <td>BRONX RIVER PARKWAY SB EXIT 9</td>\n",
       "      <td>BRONX RIVER PARKWAY</td>\n",
       "      <td>EB</td>\n",
       "      <td>02-12-2012</td>\n",
       "      <td>397</td>\n",
       "      <td>305</td>\n",
       "      <td>...</td>\n",
       "      <td>1211</td>\n",
       "      <td>1355</td>\n",
       "      <td>1338</td>\n",
       "      <td>1322</td>\n",
       "      <td>1281</td>\n",
       "      <td>1191</td>\n",
       "      <td>1047</td>\n",
       "      <td>919</td>\n",
       "      <td>820</td>\n",
       "      <td>769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3266</th>\n",
       "      <td>3266.0</td>\n",
       "      <td>3267.0</td>\n",
       "      <td>178394</td>\n",
       "      <td>EAST GUN HILL ROAD</td>\n",
       "      <td>BRONX RIVER PARKWAY SB EXIT 9</td>\n",
       "      <td>BRONX RIVER PARKWAY</td>\n",
       "      <td>WB</td>\n",
       "      <td>02-07-2012</td>\n",
       "      <td>366</td>\n",
       "      <td>280</td>\n",
       "      <td>...</td>\n",
       "      <td>1602</td>\n",
       "      <td>1687</td>\n",
       "      <td>1498</td>\n",
       "      <td>1673</td>\n",
       "      <td>1295</td>\n",
       "      <td>1271</td>\n",
       "      <td>1250</td>\n",
       "      <td>1046</td>\n",
       "      <td>970</td>\n",
       "      <td>806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3267</th>\n",
       "      <td>3267.0</td>\n",
       "      <td>3268.0</td>\n",
       "      <td>178394</td>\n",
       "      <td>EAST GUN HILL ROAD</td>\n",
       "      <td>BRONX RIVER PARKWAY SB EXIT 9</td>\n",
       "      <td>BRONX RIVER PARKWAY</td>\n",
       "      <td>WB</td>\n",
       "      <td>02-08-2012</td>\n",
       "      <td>562</td>\n",
       "      <td>323</td>\n",
       "      <td>...</td>\n",
       "      <td>1556</td>\n",
       "      <td>1688</td>\n",
       "      <td>1565</td>\n",
       "      <td>1527</td>\n",
       "      <td>1553</td>\n",
       "      <td>1288</td>\n",
       "      <td>1175</td>\n",
       "      <td>1082</td>\n",
       "      <td>919</td>\n",
       "      <td>831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3268</th>\n",
       "      <td>3268.0</td>\n",
       "      <td>3269.0</td>\n",
       "      <td>178394</td>\n",
       "      <td>EAST GUN HILL ROAD</td>\n",
       "      <td>BRONX RIVER PARKWAY SB EXIT 9</td>\n",
       "      <td>BRONX RIVER PARKWAY</td>\n",
       "      <td>WB</td>\n",
       "      <td>02-09-2012</td>\n",
       "      <td>554</td>\n",
       "      <td>288</td>\n",
       "      <td>...</td>\n",
       "      <td>1619</td>\n",
       "      <td>1722</td>\n",
       "      <td>1526</td>\n",
       "      <td>1523</td>\n",
       "      <td>1567</td>\n",
       "      <td>1496</td>\n",
       "      <td>1214</td>\n",
       "      <td>1154</td>\n",
       "      <td>1030</td>\n",
       "      <td>840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3269</th>\n",
       "      <td>3269.0</td>\n",
       "      <td>3270.0</td>\n",
       "      <td>178394</td>\n",
       "      <td>EAST GUN HILL ROAD</td>\n",
       "      <td>BRONX RIVER PARKWAY SB EXIT 9</td>\n",
       "      <td>BRONX RIVER PARKWAY</td>\n",
       "      <td>WB</td>\n",
       "      <td>02-10-2012</td>\n",
       "      <td>647</td>\n",
       "      <td>378</td>\n",
       "      <td>...</td>\n",
       "      <td>1639</td>\n",
       "      <td>1695</td>\n",
       "      <td>1734</td>\n",
       "      <td>1626</td>\n",
       "      <td>1509</td>\n",
       "      <td>1615</td>\n",
       "      <td>1506</td>\n",
       "      <td>1293</td>\n",
       "      <td>1299</td>\n",
       "      <td>1217</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3270</th>\n",
       "      <td>3270.0</td>\n",
       "      <td>3271.0</td>\n",
       "      <td>178394</td>\n",
       "      <td>EAST GUN HILL ROAD</td>\n",
       "      <td>BRONX RIVER PARKWAY SB EXIT 9</td>\n",
       "      <td>BRONX RIVER PARKWAY</td>\n",
       "      <td>WB</td>\n",
       "      <td>02-11-2012</td>\n",
       "      <td>935</td>\n",
       "      <td>717</td>\n",
       "      <td>...</td>\n",
       "      <td>1415</td>\n",
       "      <td>1502</td>\n",
       "      <td>1452</td>\n",
       "      <td>1240</td>\n",
       "      <td>1512</td>\n",
       "      <td>1417</td>\n",
       "      <td>1292</td>\n",
       "      <td>1209</td>\n",
       "      <td>1226</td>\n",
       "      <td>1327</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3271</th>\n",
       "      <td>3271.0</td>\n",
       "      <td>3272.0</td>\n",
       "      <td>178394</td>\n",
       "      <td>EAST GUN HILL ROAD</td>\n",
       "      <td>BRONX RIVER PARKWAY SB EXIT 9</td>\n",
       "      <td>BRONX RIVER PARKWAY</td>\n",
       "      <td>WB</td>\n",
       "      <td>02-12-2012</td>\n",
       "      <td>813</td>\n",
       "      <td>305</td>\n",
       "      <td>...</td>\n",
       "      <td>1211</td>\n",
       "      <td>1355</td>\n",
       "      <td>1338</td>\n",
       "      <td>1322</td>\n",
       "      <td>1281</td>\n",
       "      <td>1191</td>\n",
       "      <td>1047</td>\n",
       "      <td>919</td>\n",
       "      <td>820</td>\n",
       "      <td>769</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0      ID  GIS ID        Roadway Name  \\\n",
       "3260      3260.0  3261.0  178394  EAST GUN HILL ROAD   \n",
       "3261      3261.0  3262.0  178394  EAST GUN HILL ROAD   \n",
       "3262      3262.0  3263.0  178394  EAST GUN HILL ROAD   \n",
       "3263      3263.0  3264.0  178394  EAST GUN HILL ROAD   \n",
       "3264      3264.0  3265.0  178394  EAST GUN HILL ROAD   \n",
       "3265      3265.0  3266.0  178394  EAST GUN HILL ROAD   \n",
       "3266      3266.0  3267.0  178394  EAST GUN HILL ROAD   \n",
       "3267      3267.0  3268.0  178394  EAST GUN HILL ROAD   \n",
       "3268      3268.0  3269.0  178394  EAST GUN HILL ROAD   \n",
       "3269      3269.0  3270.0  178394  EAST GUN HILL ROAD   \n",
       "3270      3270.0  3271.0  178394  EAST GUN HILL ROAD   \n",
       "3271      3271.0  3272.0  178394  EAST GUN HILL ROAD   \n",
       "\n",
       "                               From                   To Direction  \\\n",
       "3260  BRONX RIVER PARKWAY SB EXIT 9  BRONX RIVER PARKWAY        EB   \n",
       "3261  BRONX RIVER PARKWAY SB EXIT 9  BRONX RIVER PARKWAY        EB   \n",
       "3262  BRONX RIVER PARKWAY SB EXIT 9  BRONX RIVER PARKWAY        EB   \n",
       "3263  BRONX RIVER PARKWAY SB EXIT 9  BRONX RIVER PARKWAY        EB   \n",
       "3264  BRONX RIVER PARKWAY SB EXIT 9  BRONX RIVER PARKWAY        EB   \n",
       "3265  BRONX RIVER PARKWAY SB EXIT 9  BRONX RIVER PARKWAY        EB   \n",
       "3266  BRONX RIVER PARKWAY SB EXIT 9  BRONX RIVER PARKWAY        WB   \n",
       "3267  BRONX RIVER PARKWAY SB EXIT 9  BRONX RIVER PARKWAY        WB   \n",
       "3268  BRONX RIVER PARKWAY SB EXIT 9  BRONX RIVER PARKWAY        WB   \n",
       "3269  BRONX RIVER PARKWAY SB EXIT 9  BRONX RIVER PARKWAY        WB   \n",
       "3270  BRONX RIVER PARKWAY SB EXIT 9  BRONX RIVER PARKWAY        WB   \n",
       "3271  BRONX RIVER PARKWAY SB EXIT 9  BRONX RIVER PARKWAY        WB   \n",
       "\n",
       "            Date  12:00-1:00 AM  1:00-2:00AM      ...        2:00-3:00PM  \\\n",
       "3260  02-07-2012            168          155      ...                820   \n",
       "3261  02-08-2012            321          190      ...                839   \n",
       "3262  02-09-2012            306          180      ...                883   \n",
       "3263  02-10-2012            356          217      ...                884   \n",
       "3264  02-11-2012            494          322      ...                853   \n",
       "3265  02-12-2012            397          305      ...               1211   \n",
       "3266  02-07-2012            366          280      ...               1602   \n",
       "3267  02-08-2012            562          323      ...               1556   \n",
       "3268  02-09-2012            554          288      ...               1619   \n",
       "3269  02-10-2012            647          378      ...               1639   \n",
       "3270  02-11-2012            935          717      ...               1415   \n",
       "3271  02-12-2012            813          305      ...               1211   \n",
       "\n",
       "      3:00-4:00PM  4:00-5:00PM  5:00-6:00PM  6:00-7:00PM  7:00-8:00PM  \\\n",
       "3260         1109         1173         1127         1078         1000   \n",
       "3261         1001         1115         1191         1119          911   \n",
       "3262         1081         1148         1198         1151          951   \n",
       "3263         1070         1170         1218         1136         1062   \n",
       "3264          988          991          897          886          897   \n",
       "3265         1355         1338         1322         1281         1191   \n",
       "3266         1687         1498         1673         1295         1271   \n",
       "3267         1688         1565         1527         1553         1288   \n",
       "3268         1722         1526         1523         1567         1496   \n",
       "3269         1695         1734         1626         1509         1615   \n",
       "3270         1502         1452         1240         1512         1417   \n",
       "3271         1355         1338         1322         1281         1191   \n",
       "\n",
       "      8:00-9:00PM  9:00-10:00PM  10:00-11:00PM  11:00-12:00AM  \n",
       "3260          759           643            502            442  \n",
       "3261          807           675            495            465  \n",
       "3262          780           669            530            502  \n",
       "3263          892           755            645            638  \n",
       "3264          788           664            578            622  \n",
       "3265         1047           919            820            769  \n",
       "3266         1250          1046            970            806  \n",
       "3267         1175          1082            919            831  \n",
       "3268         1214          1154           1030            840  \n",
       "3269         1506          1293           1299           1217  \n",
       "3270         1292          1209           1226           1327  \n",
       "3271         1047           919            820            769  \n",
       "\n",
       "[12 rows x 32 columns]"
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.loc[df1[\"GIS ID\"]==178394]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "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>Unnamed: 0</th>\n",
       "      <th>ID</th>\n",
       "      <th>GIS ID</th>\n",
       "      <th>Roadway Name</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>Direction</th>\n",
       "      <th>Date</th>\n",
       "      <th>12:00-1:00 AM</th>\n",
       "      <th>1:00-2:00AM</th>\n",
       "      <th>...</th>\n",
       "      <th>2:00-3:00PM</th>\n",
       "      <th>3:00-4:00PM</th>\n",
       "      <th>4:00-5:00PM</th>\n",
       "      <th>5:00-6:00PM</th>\n",
       "      <th>6:00-7:00PM</th>\n",
       "      <th>7:00-8:00PM</th>\n",
       "      <th>8:00-9:00PM</th>\n",
       "      <th>9:00-10:00PM</th>\n",
       "      <th>10:00-11:00PM</th>\n",
       "      <th>11:00-12:00AM</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1058</th>\n",
       "      <td>1058.0</td>\n",
       "      <td>1058.0</td>\n",
       "      <td>67437</td>\n",
       "      <td>21 STREET</td>\n",
       "      <td>34 AVENUE</td>\n",
       "      <td>35 AVENUE</td>\n",
       "      <td>NB</td>\n",
       "      <td>01-23-2012</td>\n",
       "      <td>532</td>\n",
       "      <td>328</td>\n",
       "      <td>...</td>\n",
       "      <td>906</td>\n",
       "      <td>1154</td>\n",
       "      <td>1216</td>\n",
       "      <td>1252</td>\n",
       "      <td>1098</td>\n",
       "      <td>863</td>\n",
       "      <td>730</td>\n",
       "      <td>659</td>\n",
       "      <td>611</td>\n",
       "      <td>573</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1059</th>\n",
       "      <td>1059.0</td>\n",
       "      <td>1059.0</td>\n",
       "      <td>67437</td>\n",
       "      <td>21 STREET</td>\n",
       "      <td>34 AVENUE</td>\n",
       "      <td>35 AVENUE</td>\n",
       "      <td>NB</td>\n",
       "      <td>01-24-2012</td>\n",
       "      <td>547</td>\n",
       "      <td>328</td>\n",
       "      <td>...</td>\n",
       "      <td>965</td>\n",
       "      <td>1208</td>\n",
       "      <td>1176</td>\n",
       "      <td>1249</td>\n",
       "      <td>1018</td>\n",
       "      <td>871</td>\n",
       "      <td>671</td>\n",
       "      <td>712</td>\n",
       "      <td>600</td>\n",
       "      <td>582</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1060</th>\n",
       "      <td>1060.0</td>\n",
       "      <td>1060.0</td>\n",
       "      <td>67437</td>\n",
       "      <td>21 STREET</td>\n",
       "      <td>34 AVENUE</td>\n",
       "      <td>35 AVENUE</td>\n",
       "      <td>NB</td>\n",
       "      <td>01-25-2012</td>\n",
       "      <td>542</td>\n",
       "      <td>306</td>\n",
       "      <td>...</td>\n",
       "      <td>927</td>\n",
       "      <td>1178</td>\n",
       "      <td>1288</td>\n",
       "      <td>1320</td>\n",
       "      <td>1084</td>\n",
       "      <td>869</td>\n",
       "      <td>786</td>\n",
       "      <td>768</td>\n",
       "      <td>668</td>\n",
       "      <td>622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1061</th>\n",
       "      <td>1061.0</td>\n",
       "      <td>1061.0</td>\n",
       "      <td>67437</td>\n",
       "      <td>21 STREET</td>\n",
       "      <td>34 AVENUE</td>\n",
       "      <td>35 AVENUE</td>\n",
       "      <td>NB</td>\n",
       "      <td>01-26-2012</td>\n",
       "      <td>604</td>\n",
       "      <td>446</td>\n",
       "      <td>...</td>\n",
       "      <td>887</td>\n",
       "      <td>1157</td>\n",
       "      <td>1282</td>\n",
       "      <td>1358</td>\n",
       "      <td>1102</td>\n",
       "      <td>856</td>\n",
       "      <td>774</td>\n",
       "      <td>727</td>\n",
       "      <td>694</td>\n",
       "      <td>594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1062</th>\n",
       "      <td>1062.0</td>\n",
       "      <td>1062.0</td>\n",
       "      <td>67437</td>\n",
       "      <td>21 STREET</td>\n",
       "      <td>34 AVENUE</td>\n",
       "      <td>35 AVENUE</td>\n",
       "      <td>NB</td>\n",
       "      <td>01-27-2012</td>\n",
       "      <td>612</td>\n",
       "      <td>448</td>\n",
       "      <td>...</td>\n",
       "      <td>838</td>\n",
       "      <td>988</td>\n",
       "      <td>1052</td>\n",
       "      <td>1030</td>\n",
       "      <td>830</td>\n",
       "      <td>678</td>\n",
       "      <td>570</td>\n",
       "      <td>540</td>\n",
       "      <td>532</td>\n",
       "      <td>469</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1063</th>\n",
       "      <td>1063.0</td>\n",
       "      <td>1063.0</td>\n",
       "      <td>67437</td>\n",
       "      <td>21 STREET</td>\n",
       "      <td>34 AVENUE</td>\n",
       "      <td>35 AVENUE</td>\n",
       "      <td>SB</td>\n",
       "      <td>01-23-2012</td>\n",
       "      <td>286</td>\n",
       "      <td>179</td>\n",
       "      <td>...</td>\n",
       "      <td>702</td>\n",
       "      <td>760</td>\n",
       "      <td>794</td>\n",
       "      <td>761</td>\n",
       "      <td>637</td>\n",
       "      <td>473</td>\n",
       "      <td>446</td>\n",
       "      <td>352</td>\n",
       "      <td>399</td>\n",
       "      <td>340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1064</th>\n",
       "      <td>1064.0</td>\n",
       "      <td>1064.0</td>\n",
       "      <td>67437</td>\n",
       "      <td>21 STREET</td>\n",
       "      <td>34 AVENUE</td>\n",
       "      <td>35 AVENUE</td>\n",
       "      <td>SB</td>\n",
       "      <td>01-24-2012</td>\n",
       "      <td>243</td>\n",
       "      <td>192</td>\n",
       "      <td>...</td>\n",
       "      <td>754</td>\n",
       "      <td>827</td>\n",
       "      <td>896</td>\n",
       "      <td>750</td>\n",
       "      <td>526</td>\n",
       "      <td>498</td>\n",
       "      <td>362</td>\n",
       "      <td>366</td>\n",
       "      <td>442</td>\n",
       "      <td>354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1065</th>\n",
       "      <td>1065.0</td>\n",
       "      <td>1065.0</td>\n",
       "      <td>67437</td>\n",
       "      <td>21 STREET</td>\n",
       "      <td>34 AVENUE</td>\n",
       "      <td>35 AVENUE</td>\n",
       "      <td>SB</td>\n",
       "      <td>01-25-2012</td>\n",
       "      <td>303</td>\n",
       "      <td>175</td>\n",
       "      <td>...</td>\n",
       "      <td>762</td>\n",
       "      <td>816</td>\n",
       "      <td>851</td>\n",
       "      <td>759</td>\n",
       "      <td>614</td>\n",
       "      <td>485</td>\n",
       "      <td>402</td>\n",
       "      <td>353</td>\n",
       "      <td>402</td>\n",
       "      <td>336</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1066</th>\n",
       "      <td>1066.0</td>\n",
       "      <td>1066.0</td>\n",
       "      <td>67437</td>\n",
       "      <td>21 STREET</td>\n",
       "      <td>34 AVENUE</td>\n",
       "      <td>35 AVENUE</td>\n",
       "      <td>SB</td>\n",
       "      <td>01-26-2012</td>\n",
       "      <td>265</td>\n",
       "      <td>189</td>\n",
       "      <td>...</td>\n",
       "      <td>796</td>\n",
       "      <td>799</td>\n",
       "      <td>913</td>\n",
       "      <td>790</td>\n",
       "      <td>560</td>\n",
       "      <td>503</td>\n",
       "      <td>383</td>\n",
       "      <td>382</td>\n",
       "      <td>436</td>\n",
       "      <td>346</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1067</th>\n",
       "      <td>1067.0</td>\n",
       "      <td>1067.0</td>\n",
       "      <td>67437</td>\n",
       "      <td>21 STREET</td>\n",
       "      <td>34 AVENUE</td>\n",
       "      <td>35 AVENUE</td>\n",
       "      <td>SB</td>\n",
       "      <td>01-27-2012</td>\n",
       "      <td>284</td>\n",
       "      <td>168</td>\n",
       "      <td>...</td>\n",
       "      <td>838</td>\n",
       "      <td>988</td>\n",
       "      <td>1052</td>\n",
       "      <td>1030</td>\n",
       "      <td>830</td>\n",
       "      <td>678</td>\n",
       "      <td>570</td>\n",
       "      <td>540</td>\n",
       "      <td>532</td>\n",
       "      <td>469</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0      ID  GIS ID Roadway Name       From         To Direction  \\\n",
       "1058      1058.0  1058.0   67437    21 STREET  34 AVENUE  35 AVENUE        NB   \n",
       "1059      1059.0  1059.0   67437    21 STREET  34 AVENUE  35 AVENUE        NB   \n",
       "1060      1060.0  1060.0   67437    21 STREET  34 AVENUE  35 AVENUE        NB   \n",
       "1061      1061.0  1061.0   67437    21 STREET  34 AVENUE  35 AVENUE        NB   \n",
       "1062      1062.0  1062.0   67437    21 STREET  34 AVENUE  35 AVENUE        NB   \n",
       "1063      1063.0  1063.0   67437    21 STREET  34 AVENUE  35 AVENUE        SB   \n",
       "1064      1064.0  1064.0   67437    21 STREET  34 AVENUE  35 AVENUE        SB   \n",
       "1065      1065.0  1065.0   67437    21 STREET  34 AVENUE  35 AVENUE        SB   \n",
       "1066      1066.0  1066.0   67437    21 STREET  34 AVENUE  35 AVENUE        SB   \n",
       "1067      1067.0  1067.0   67437    21 STREET  34 AVENUE  35 AVENUE        SB   \n",
       "\n",
       "            Date  12:00-1:00 AM  1:00-2:00AM      ...        2:00-3:00PM  \\\n",
       "1058  01-23-2012            532          328      ...                906   \n",
       "1059  01-24-2012            547          328      ...                965   \n",
       "1060  01-25-2012            542          306      ...                927   \n",
       "1061  01-26-2012            604          446      ...                887   \n",
       "1062  01-27-2012            612          448      ...                838   \n",
       "1063  01-23-2012            286          179      ...                702   \n",
       "1064  01-24-2012            243          192      ...                754   \n",
       "1065  01-25-2012            303          175      ...                762   \n",
       "1066  01-26-2012            265          189      ...                796   \n",
       "1067  01-27-2012            284          168      ...                838   \n",
       "\n",
       "      3:00-4:00PM  4:00-5:00PM  5:00-6:00PM  6:00-7:00PM  7:00-8:00PM  \\\n",
       "1058         1154         1216         1252         1098          863   \n",
       "1059         1208         1176         1249         1018          871   \n",
       "1060         1178         1288         1320         1084          869   \n",
       "1061         1157         1282         1358         1102          856   \n",
       "1062          988         1052         1030          830          678   \n",
       "1063          760          794          761          637          473   \n",
       "1064          827          896          750          526          498   \n",
       "1065          816          851          759          614          485   \n",
       "1066          799          913          790          560          503   \n",
       "1067          988         1052         1030          830          678   \n",
       "\n",
       "      8:00-9:00PM  9:00-10:00PM  10:00-11:00PM  11:00-12:00AM  \n",
       "1058          730           659            611            573  \n",
       "1059          671           712            600            582  \n",
       "1060          786           768            668            622  \n",
       "1061          774           727            694            594  \n",
       "1062          570           540            532            469  \n",
       "1063          446           352            399            340  \n",
       "1064          362           366            442            354  \n",
       "1065          402           353            402            336  \n",
       "1066          383           382            436            346  \n",
       "1067          570           540            532            469  \n",
       "\n",
       "[10 rows x 32 columns]"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.loc[df1[\"GIS ID\"]==67437] ###"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "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>Unnamed: 0</th>\n",
       "      <th>ID</th>\n",
       "      <th>Segment ID</th>\n",
       "      <th>Roadway Name</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>Direction</th>\n",
       "      <th>Date</th>\n",
       "      <th>12:00-1:00 AM</th>\n",
       "      <th>1:00-2:00AM</th>\n",
       "      <th>...</th>\n",
       "      <th>2:00-3:00PM</th>\n",
       "      <th>3:00-4:00PM</th>\n",
       "      <th>4:00-5:00PM</th>\n",
       "      <th>5:00-6:00PM</th>\n",
       "      <th>6:00-7:00PM</th>\n",
       "      <th>7:00-8:00PM</th>\n",
       "      <th>8:00-9:00PM</th>\n",
       "      <th>9:00-10:00PM</th>\n",
       "      <th>10:00-11:00PM</th>\n",
       "      <th>11:00-12:00AM</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2402</th>\n",
       "      <td>2402</td>\n",
       "      <td>169</td>\n",
       "      <td>36112</td>\n",
       "      <td>2 AVENUE</td>\n",
       "      <td>EAST 46 STREET</td>\n",
       "      <td>EAST 47 STREET</td>\n",
       "      <td>SB</td>\n",
       "      <td>10-12-2012</td>\n",
       "      <td>1877</td>\n",
       "      <td>1282</td>\n",
       "      <td>...</td>\n",
       "      <td>2596</td>\n",
       "      <td>2382</td>\n",
       "      <td>2192</td>\n",
       "      <td>2453</td>\n",
       "      <td>2569</td>\n",
       "      <td>2423</td>\n",
       "      <td>2449</td>\n",
       "      <td>2434</td>\n",
       "      <td>2564</td>\n",
       "      <td>2460</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2403</th>\n",
       "      <td>2403</td>\n",
       "      <td>169</td>\n",
       "      <td>36112</td>\n",
       "      <td>2 AVENUE</td>\n",
       "      <td>EAST 46 STREET</td>\n",
       "      <td>EAST 47 STREET</td>\n",
       "      <td>SB</td>\n",
       "      <td>10-13-2012</td>\n",
       "      <td>2113</td>\n",
       "      <td>2184</td>\n",
       "      <td>...</td>\n",
       "      <td>2399</td>\n",
       "      <td>2343</td>\n",
       "      <td>2049</td>\n",
       "      <td>2225</td>\n",
       "      <td>2324</td>\n",
       "      <td>2266</td>\n",
       "      <td>2282</td>\n",
       "      <td>2311</td>\n",
       "      <td>2458</td>\n",
       "      <td>2466</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2404</th>\n",
       "      <td>2404</td>\n",
       "      <td>169</td>\n",
       "      <td>36112</td>\n",
       "      <td>2 AVENUE</td>\n",
       "      <td>EAST 46 STREET</td>\n",
       "      <td>EAST 47 STREET</td>\n",
       "      <td>SB</td>\n",
       "      <td>10-14-2012</td>\n",
       "      <td>2371</td>\n",
       "      <td>2202</td>\n",
       "      <td>...</td>\n",
       "      <td>2386</td>\n",
       "      <td>2450</td>\n",
       "      <td>2311</td>\n",
       "      <td>2365</td>\n",
       "      <td>2253</td>\n",
       "      <td>2274</td>\n",
       "      <td>2145</td>\n",
       "      <td>2009</td>\n",
       "      <td>1857</td>\n",
       "      <td>1535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2405</th>\n",
       "      <td>2405</td>\n",
       "      <td>169</td>\n",
       "      <td>36112</td>\n",
       "      <td>2 AVENUE</td>\n",
       "      <td>EAST 46 STREET</td>\n",
       "      <td>EAST 47 STREET</td>\n",
       "      <td>SB</td>\n",
       "      <td>10-15-2012</td>\n",
       "      <td>1124</td>\n",
       "      <td>773</td>\n",
       "      <td>...</td>\n",
       "      <td>2699</td>\n",
       "      <td>2587</td>\n",
       "      <td>2410</td>\n",
       "      <td>2757</td>\n",
       "      <td>2694</td>\n",
       "      <td>2717</td>\n",
       "      <td>2528</td>\n",
       "      <td>2205</td>\n",
       "      <td>2178</td>\n",
       "      <td>1778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2406</th>\n",
       "      <td>2406</td>\n",
       "      <td>169</td>\n",
       "      <td>36112</td>\n",
       "      <td>2 AVENUE</td>\n",
       "      <td>EAST 46 STREET</td>\n",
       "      <td>EAST 47 STREET</td>\n",
       "      <td>SB</td>\n",
       "      <td>10-16-2012</td>\n",
       "      <td>1329</td>\n",
       "      <td>870</td>\n",
       "      <td>...</td>\n",
       "      <td>2512</td>\n",
       "      <td>2438</td>\n",
       "      <td>2344</td>\n",
       "      <td>2690</td>\n",
       "      <td>2794</td>\n",
       "      <td>2830</td>\n",
       "      <td>2624</td>\n",
       "      <td>2401</td>\n",
       "      <td>2291</td>\n",
       "      <td>1933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2407</th>\n",
       "      <td>2407</td>\n",
       "      <td>169</td>\n",
       "      <td>36112</td>\n",
       "      <td>2 AVENUE</td>\n",
       "      <td>EAST 46 STREET</td>\n",
       "      <td>EAST 47 STREET</td>\n",
       "      <td>SB</td>\n",
       "      <td>10-17-2012</td>\n",
       "      <td>1481</td>\n",
       "      <td>959</td>\n",
       "      <td>...</td>\n",
       "      <td>2643</td>\n",
       "      <td>2451</td>\n",
       "      <td>2358</td>\n",
       "      <td>2730</td>\n",
       "      <td>2823</td>\n",
       "      <td>2868</td>\n",
       "      <td>2685</td>\n",
       "      <td>2457</td>\n",
       "      <td>2487</td>\n",
       "      <td>2175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2408</th>\n",
       "      <td>2408</td>\n",
       "      <td>169</td>\n",
       "      <td>36112</td>\n",
       "      <td>2 AVENUE</td>\n",
       "      <td>EAST 46 STREET</td>\n",
       "      <td>EAST 47 STREET</td>\n",
       "      <td>SB</td>\n",
       "      <td>10-18-2012</td>\n",
       "      <td>1593</td>\n",
       "      <td>1014</td>\n",
       "      <td>...</td>\n",
       "      <td>2024</td>\n",
       "      <td>2391</td>\n",
       "      <td>2361</td>\n",
       "      <td>2704</td>\n",
       "      <td>2741</td>\n",
       "      <td>2840</td>\n",
       "      <td>2644</td>\n",
       "      <td>2317</td>\n",
       "      <td>2082</td>\n",
       "      <td>2095</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2409</th>\n",
       "      <td>2409</td>\n",
       "      <td>169</td>\n",
       "      <td>36112</td>\n",
       "      <td>2 AVENUE</td>\n",
       "      <td>EAST 46 STREET</td>\n",
       "      <td>EAST 47 STREET</td>\n",
       "      <td>SB</td>\n",
       "      <td>10-19-2012</td>\n",
       "      <td>1761</td>\n",
       "      <td>1305</td>\n",
       "      <td>...</td>\n",
       "      <td>2508</td>\n",
       "      <td>2080</td>\n",
       "      <td>2155</td>\n",
       "      <td>2491</td>\n",
       "      <td>2342</td>\n",
       "      <td>2519</td>\n",
       "      <td>2391</td>\n",
       "      <td>2316</td>\n",
       "      <td>2432</td>\n",
       "      <td>2553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2410</th>\n",
       "      <td>2410</td>\n",
       "      <td>169</td>\n",
       "      <td>36112</td>\n",
       "      <td>2 AVENUE</td>\n",
       "      <td>EAST 46 STREET</td>\n",
       "      <td>EAST 47 STREET</td>\n",
       "      <td>SB</td>\n",
       "      <td>10-20-2012</td>\n",
       "      <td>2312</td>\n",
       "      <td>2202</td>\n",
       "      <td>...</td>\n",
       "      <td>2504</td>\n",
       "      <td>2419</td>\n",
       "      <td>2098</td>\n",
       "      <td>1875</td>\n",
       "      <td>1796</td>\n",
       "      <td>1732</td>\n",
       "      <td>1755</td>\n",
       "      <td>1943</td>\n",
       "      <td>2420</td>\n",
       "      <td>2600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2411</th>\n",
       "      <td>2411</td>\n",
       "      <td>169</td>\n",
       "      <td>36112</td>\n",
       "      <td>2 AVENUE</td>\n",
       "      <td>EAST 46 STREET</td>\n",
       "      <td>EAST 47 STREET</td>\n",
       "      <td>SB</td>\n",
       "      <td>10-21-2012</td>\n",
       "      <td>2296</td>\n",
       "      <td>2215</td>\n",
       "      <td>...</td>\n",
       "      <td>2522</td>\n",
       "      <td>2563</td>\n",
       "      <td>2493</td>\n",
       "      <td>2319</td>\n",
       "      <td>2281</td>\n",
       "      <td>2207</td>\n",
       "      <td>2074</td>\n",
       "      <td>1930</td>\n",
       "      <td>1765</td>\n",
       "      <td>1441</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2412</th>\n",
       "      <td>2412</td>\n",
       "      <td>169</td>\n",
       "      <td>36112</td>\n",
       "      <td>2 AVENUE</td>\n",
       "      <td>EAST 46 STREET</td>\n",
       "      <td>EAST 47 STREET</td>\n",
       "      <td>SB</td>\n",
       "      <td>10-22-2012</td>\n",
       "      <td>1073</td>\n",
       "      <td>711</td>\n",
       "      <td>...</td>\n",
       "      <td>2605</td>\n",
       "      <td>2350</td>\n",
       "      <td>2280</td>\n",
       "      <td>2554</td>\n",
       "      <td>2838</td>\n",
       "      <td>2526</td>\n",
       "      <td>2390</td>\n",
       "      <td>2255</td>\n",
       "      <td>2166</td>\n",
       "      <td>1815</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0   ID  Segment ID Roadway Name               From  \\\n",
       "2402        2402  169       36112   2 AVENUE     EAST 46 STREET     \n",
       "2403        2403  169       36112   2 AVENUE     EAST 46 STREET     \n",
       "2404        2404  169       36112   2 AVENUE     EAST 46 STREET     \n",
       "2405        2405  169       36112   2 AVENUE     EAST 46 STREET     \n",
       "2406        2406  169       36112   2 AVENUE     EAST 46 STREET     \n",
       "2407        2407  169       36112   2 AVENUE     EAST 46 STREET     \n",
       "2408        2408  169       36112   2 AVENUE     EAST 46 STREET     \n",
       "2409        2409  169       36112   2 AVENUE     EAST 46 STREET     \n",
       "2410        2410  169       36112   2 AVENUE     EAST 46 STREET     \n",
       "2411        2411  169       36112   2 AVENUE     EAST 46 STREET     \n",
       "2412        2412  169       36112   2 AVENUE     EAST 46 STREET     \n",
       "\n",
       "                     To Direction        Date  12:00-1:00 AM  1:00-2:00AM  \\\n",
       "2402   EAST 47 STREET          SB  10-12-2012           1877         1282   \n",
       "2403   EAST 47 STREET          SB  10-13-2012           2113         2184   \n",
       "2404   EAST 47 STREET          SB  10-14-2012           2371         2202   \n",
       "2405   EAST 47 STREET          SB  10-15-2012           1124          773   \n",
       "2406   EAST 47 STREET          SB  10-16-2012           1329          870   \n",
       "2407   EAST 47 STREET          SB  10-17-2012           1481          959   \n",
       "2408   EAST 47 STREET          SB  10-18-2012           1593         1014   \n",
       "2409   EAST 47 STREET          SB  10-19-2012           1761         1305   \n",
       "2410   EAST 47 STREET          SB  10-20-2012           2312         2202   \n",
       "2411   EAST 47 STREET          SB  10-21-2012           2296         2215   \n",
       "2412   EAST 47 STREET          SB  10-22-2012           1073          711   \n",
       "\n",
       "          ...        2:00-3:00PM  3:00-4:00PM  4:00-5:00PM  5:00-6:00PM  \\\n",
       "2402      ...               2596         2382         2192         2453   \n",
       "2403      ...               2399         2343         2049         2225   \n",
       "2404      ...               2386         2450         2311         2365   \n",
       "2405      ...               2699         2587         2410         2757   \n",
       "2406      ...               2512         2438         2344         2690   \n",
       "2407      ...               2643         2451         2358         2730   \n",
       "2408      ...               2024         2391         2361         2704   \n",
       "2409      ...               2508         2080         2155         2491   \n",
       "2410      ...               2504         2419         2098         1875   \n",
       "2411      ...               2522         2563         2493         2319   \n",
       "2412      ...               2605         2350         2280         2554   \n",
       "\n",
       "      6:00-7:00PM  7:00-8:00PM  8:00-9:00PM  9:00-10:00PM  10:00-11:00PM  \\\n",
       "2402         2569         2423         2449          2434           2564   \n",
       "2403         2324         2266         2282          2311           2458   \n",
       "2404         2253         2274         2145          2009           1857   \n",
       "2405         2694         2717         2528          2205           2178   \n",
       "2406         2794         2830         2624          2401           2291   \n",
       "2407         2823         2868         2685          2457           2487   \n",
       "2408         2741         2840         2644          2317           2082   \n",
       "2409         2342         2519         2391          2316           2432   \n",
       "2410         1796         1732         1755          1943           2420   \n",
       "2411         2281         2207         2074          1930           1765   \n",
       "2412         2838         2526         2390          2255           2166   \n",
       "\n",
       "      11:00-12:00AM  \n",
       "2402           2460  \n",
       "2403           2466  \n",
       "2404           1535  \n",
       "2405           1778  \n",
       "2406           1933  \n",
       "2407           2175  \n",
       "2408           2095  \n",
       "2409           2553  \n",
       "2410           2600  \n",
       "2411           1441  \n",
       "2412           1815  \n",
       "\n",
       "[11 rows x 32 columns]"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.loc[df2[\"Segment ID\"]==36112]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [],
   "source": [
    "y1 = pd.DataFrame(y1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {},
   "outputs": [],
   "source": [
    "y2 = pd.DataFrame(y2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "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>646</th>\n",
       "      <th>1421</th>\n",
       "      <th>1883</th>\n",
       "      <th>1884</th>\n",
       "      <th>1885</th>\n",
       "      <th>1886</th>\n",
       "      <th>2147</th>\n",
       "      <th>2369</th>\n",
       "      <th>2870</th>\n",
       "      <th>2930</th>\n",
       "      <th>...</th>\n",
       "      <th>176975</th>\n",
       "      <th>178394</th>\n",
       "      <th>179509</th>\n",
       "      <th>180547</th>\n",
       "      <th>183880</th>\n",
       "      <th>184214</th>\n",
       "      <th>188247</th>\n",
       "      <th>194331</th>\n",
       "      <th>194358</th>\n",
       "      <th>194613</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>29</td>\n",
       "      <td>54</td>\n",
       "      <td>57</td>\n",
       "      <td>53</td>\n",
       "      <td>58</td>\n",
       "      <td>67</td>\n",
       "      <td>69</td>\n",
       "      <td>57</td>\n",
       "      <td>36</td>\n",
       "      <td>56</td>\n",
       "      <td>...</td>\n",
       "      <td>57</td>\n",
       "      <td>494</td>\n",
       "      <td>71</td>\n",
       "      <td>163</td>\n",
       "      <td>24</td>\n",
       "      <td>81</td>\n",
       "      <td>98</td>\n",
       "      <td>52</td>\n",
       "      <td>44</td>\n",
       "      <td>225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>26</td>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "      <td>29</td>\n",
       "      <td>31</td>\n",
       "      <td>36</td>\n",
       "      <td>40</td>\n",
       "      <td>44</td>\n",
       "      <td>26</td>\n",
       "      <td>35</td>\n",
       "      <td>...</td>\n",
       "      <td>36</td>\n",
       "      <td>305</td>\n",
       "      <td>48</td>\n",
       "      <td>99</td>\n",
       "      <td>14</td>\n",
       "      <td>55</td>\n",
       "      <td>59</td>\n",
       "      <td>32</td>\n",
       "      <td>30</td>\n",
       "      <td>134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>19</td>\n",
       "      <td>22</td>\n",
       "      <td>19</td>\n",
       "      <td>24</td>\n",
       "      <td>23</td>\n",
       "      <td>29</td>\n",
       "      <td>29</td>\n",
       "      <td>35</td>\n",
       "      <td>18</td>\n",
       "      <td>26</td>\n",
       "      <td>...</td>\n",
       "      <td>25</td>\n",
       "      <td>196</td>\n",
       "      <td>34</td>\n",
       "      <td>59</td>\n",
       "      <td>8</td>\n",
       "      <td>44</td>\n",
       "      <td>42</td>\n",
       "      <td>23</td>\n",
       "      <td>18</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>17</td>\n",
       "      <td>19</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>17</td>\n",
       "      <td>24</td>\n",
       "      <td>22</td>\n",
       "      <td>33</td>\n",
       "      <td>12</td>\n",
       "      <td>18</td>\n",
       "      <td>...</td>\n",
       "      <td>23</td>\n",
       "      <td>162</td>\n",
       "      <td>28</td>\n",
       "      <td>46</td>\n",
       "      <td>7</td>\n",
       "      <td>39</td>\n",
       "      <td>27</td>\n",
       "      <td>20</td>\n",
       "      <td>13</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>27</td>\n",
       "      <td>26</td>\n",
       "      <td>20</td>\n",
       "      <td>18</td>\n",
       "      <td>17</td>\n",
       "      <td>21</td>\n",
       "      <td>34</td>\n",
       "      <td>67</td>\n",
       "      <td>17</td>\n",
       "      <td>13</td>\n",
       "      <td>...</td>\n",
       "      <td>20</td>\n",
       "      <td>180</td>\n",
       "      <td>29</td>\n",
       "      <td>67</td>\n",
       "      <td>7</td>\n",
       "      <td>59</td>\n",
       "      <td>35</td>\n",
       "      <td>26</td>\n",
       "      <td>17</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>52</td>\n",
       "      <td>55</td>\n",
       "      <td>53</td>\n",
       "      <td>54</td>\n",
       "      <td>45</td>\n",
       "      <td>42</td>\n",
       "      <td>76</td>\n",
       "      <td>204</td>\n",
       "      <td>49</td>\n",
       "      <td>25</td>\n",
       "      <td>...</td>\n",
       "      <td>50</td>\n",
       "      <td>291</td>\n",
       "      <td>47</td>\n",
       "      <td>155</td>\n",
       "      <td>15</td>\n",
       "      <td>122</td>\n",
       "      <td>66</td>\n",
       "      <td>57</td>\n",
       "      <td>25</td>\n",
       "      <td>218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>98</td>\n",
       "      <td>152</td>\n",
       "      <td>135</td>\n",
       "      <td>145</td>\n",
       "      <td>156</td>\n",
       "      <td>107</td>\n",
       "      <td>183</td>\n",
       "      <td>290</td>\n",
       "      <td>106</td>\n",
       "      <td>74</td>\n",
       "      <td>...</td>\n",
       "      <td>105</td>\n",
       "      <td>670</td>\n",
       "      <td>115</td>\n",
       "      <td>432</td>\n",
       "      <td>32</td>\n",
       "      <td>264</td>\n",
       "      <td>136</td>\n",
       "      <td>93</td>\n",
       "      <td>61</td>\n",
       "      <td>728</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>135</td>\n",
       "      <td>316</td>\n",
       "      <td>423</td>\n",
       "      <td>395</td>\n",
       "      <td>379</td>\n",
       "      <td>383</td>\n",
       "      <td>457</td>\n",
       "      <td>389</td>\n",
       "      <td>326</td>\n",
       "      <td>346</td>\n",
       "      <td>...</td>\n",
       "      <td>177</td>\n",
       "      <td>1169</td>\n",
       "      <td>230</td>\n",
       "      <td>1069</td>\n",
       "      <td>82</td>\n",
       "      <td>301</td>\n",
       "      <td>272</td>\n",
       "      <td>153</td>\n",
       "      <td>150</td>\n",
       "      <td>1265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>183</td>\n",
       "      <td>354</td>\n",
       "      <td>352</td>\n",
       "      <td>332</td>\n",
       "      <td>352</td>\n",
       "      <td>356</td>\n",
       "      <td>421</td>\n",
       "      <td>467</td>\n",
       "      <td>296</td>\n",
       "      <td>404</td>\n",
       "      <td>...</td>\n",
       "      <td>219</td>\n",
       "      <td>1257</td>\n",
       "      <td>285</td>\n",
       "      <td>1154</td>\n",
       "      <td>88</td>\n",
       "      <td>339</td>\n",
       "      <td>362</td>\n",
       "      <td>177</td>\n",
       "      <td>250</td>\n",
       "      <td>1039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>212</td>\n",
       "      <td>213</td>\n",
       "      <td>206</td>\n",
       "      <td>206</td>\n",
       "      <td>198</td>\n",
       "      <td>205</td>\n",
       "      <td>263</td>\n",
       "      <td>359</td>\n",
       "      <td>156</td>\n",
       "      <td>225</td>\n",
       "      <td>...</td>\n",
       "      <td>210</td>\n",
       "      <td>1135</td>\n",
       "      <td>200</td>\n",
       "      <td>752</td>\n",
       "      <td>56</td>\n",
       "      <td>283</td>\n",
       "      <td>347</td>\n",
       "      <td>174</td>\n",
       "      <td>242</td>\n",
       "      <td>965</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>201</td>\n",
       "      <td>220</td>\n",
       "      <td>207</td>\n",
       "      <td>223</td>\n",
       "      <td>180</td>\n",
       "      <td>208</td>\n",
       "      <td>242</td>\n",
       "      <td>324</td>\n",
       "      <td>148</td>\n",
       "      <td>227</td>\n",
       "      <td>...</td>\n",
       "      <td>227</td>\n",
       "      <td>1046</td>\n",
       "      <td>180</td>\n",
       "      <td>597</td>\n",
       "      <td>54</td>\n",
       "      <td>249</td>\n",
       "      <td>352</td>\n",
       "      <td>192</td>\n",
       "      <td>242</td>\n",
       "      <td>768</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>237</td>\n",
       "      <td>260</td>\n",
       "      <td>253</td>\n",
       "      <td>243</td>\n",
       "      <td>228</td>\n",
       "      <td>241</td>\n",
       "      <td>281</td>\n",
       "      <td>317</td>\n",
       "      <td>177</td>\n",
       "      <td>237</td>\n",
       "      <td>...</td>\n",
       "      <td>241</td>\n",
       "      <td>1024</td>\n",
       "      <td>185</td>\n",
       "      <td>487</td>\n",
       "      <td>64</td>\n",
       "      <td>238</td>\n",
       "      <td>348</td>\n",
       "      <td>221</td>\n",
       "      <td>260</td>\n",
       "      <td>893</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>251</td>\n",
       "      <td>288</td>\n",
       "      <td>289</td>\n",
       "      <td>291</td>\n",
       "      <td>255</td>\n",
       "      <td>291</td>\n",
       "      <td>303</td>\n",
       "      <td>343</td>\n",
       "      <td>186</td>\n",
       "      <td>287</td>\n",
       "      <td>...</td>\n",
       "      <td>268</td>\n",
       "      <td>1121</td>\n",
       "      <td>207</td>\n",
       "      <td>625</td>\n",
       "      <td>66</td>\n",
       "      <td>242</td>\n",
       "      <td>360</td>\n",
       "      <td>257</td>\n",
       "      <td>269</td>\n",
       "      <td>905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>272</td>\n",
       "      <td>295</td>\n",
       "      <td>311</td>\n",
       "      <td>314</td>\n",
       "      <td>268</td>\n",
       "      <td>315</td>\n",
       "      <td>312</td>\n",
       "      <td>351</td>\n",
       "      <td>208</td>\n",
       "      <td>290</td>\n",
       "      <td>...</td>\n",
       "      <td>257</td>\n",
       "      <td>1165</td>\n",
       "      <td>217</td>\n",
       "      <td>643</td>\n",
       "      <td>68</td>\n",
       "      <td>245</td>\n",
       "      <td>368</td>\n",
       "      <td>271</td>\n",
       "      <td>296</td>\n",
       "      <td>935</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>264</td>\n",
       "      <td>353</td>\n",
       "      <td>367</td>\n",
       "      <td>368</td>\n",
       "      <td>357</td>\n",
       "      <td>415</td>\n",
       "      <td>417</td>\n",
       "      <td>382</td>\n",
       "      <td>288</td>\n",
       "      <td>385</td>\n",
       "      <td>...</td>\n",
       "      <td>261</td>\n",
       "      <td>1211</td>\n",
       "      <td>228</td>\n",
       "      <td>721</td>\n",
       "      <td>76</td>\n",
       "      <td>283</td>\n",
       "      <td>368</td>\n",
       "      <td>276</td>\n",
       "      <td>323</td>\n",
       "      <td>1081</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>294</td>\n",
       "      <td>401</td>\n",
       "      <td>429</td>\n",
       "      <td>442</td>\n",
       "      <td>387</td>\n",
       "      <td>430</td>\n",
       "      <td>465</td>\n",
       "      <td>432</td>\n",
       "      <td>315</td>\n",
       "      <td>369</td>\n",
       "      <td>...</td>\n",
       "      <td>277</td>\n",
       "      <td>1355</td>\n",
       "      <td>270</td>\n",
       "      <td>823</td>\n",
       "      <td>81</td>\n",
       "      <td>285</td>\n",
       "      <td>394</td>\n",
       "      <td>301</td>\n",
       "      <td>331</td>\n",
       "      <td>1298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>291</td>\n",
       "      <td>396</td>\n",
       "      <td>380</td>\n",
       "      <td>380</td>\n",
       "      <td>364</td>\n",
       "      <td>374</td>\n",
       "      <td>440</td>\n",
       "      <td>416</td>\n",
       "      <td>267</td>\n",
       "      <td>362</td>\n",
       "      <td>...</td>\n",
       "      <td>264</td>\n",
       "      <td>1338</td>\n",
       "      <td>257</td>\n",
       "      <td>928</td>\n",
       "      <td>75</td>\n",
       "      <td>308</td>\n",
       "      <td>402</td>\n",
       "      <td>307</td>\n",
       "      <td>420</td>\n",
       "      <td>1336</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>226</td>\n",
       "      <td>411</td>\n",
       "      <td>371</td>\n",
       "      <td>406</td>\n",
       "      <td>328</td>\n",
       "      <td>378</td>\n",
       "      <td>420</td>\n",
       "      <td>426</td>\n",
       "      <td>272</td>\n",
       "      <td>357</td>\n",
       "      <td>...</td>\n",
       "      <td>268</td>\n",
       "      <td>1322</td>\n",
       "      <td>257</td>\n",
       "      <td>992</td>\n",
       "      <td>93</td>\n",
       "      <td>342</td>\n",
       "      <td>374</td>\n",
       "      <td>318</td>\n",
       "      <td>416</td>\n",
       "      <td>1370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>183</td>\n",
       "      <td>367</td>\n",
       "      <td>325</td>\n",
       "      <td>372</td>\n",
       "      <td>339</td>\n",
       "      <td>364</td>\n",
       "      <td>404</td>\n",
       "      <td>380</td>\n",
       "      <td>267</td>\n",
       "      <td>313</td>\n",
       "      <td>...</td>\n",
       "      <td>244</td>\n",
       "      <td>1281</td>\n",
       "      <td>250</td>\n",
       "      <td>933</td>\n",
       "      <td>75</td>\n",
       "      <td>305</td>\n",
       "      <td>354</td>\n",
       "      <td>278</td>\n",
       "      <td>377</td>\n",
       "      <td>1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>153</td>\n",
       "      <td>316</td>\n",
       "      <td>277</td>\n",
       "      <td>312</td>\n",
       "      <td>286</td>\n",
       "      <td>333</td>\n",
       "      <td>366</td>\n",
       "      <td>357</td>\n",
       "      <td>227</td>\n",
       "      <td>276</td>\n",
       "      <td>...</td>\n",
       "      <td>233</td>\n",
       "      <td>1191</td>\n",
       "      <td>222</td>\n",
       "      <td>756</td>\n",
       "      <td>57</td>\n",
       "      <td>231</td>\n",
       "      <td>341</td>\n",
       "      <td>250</td>\n",
       "      <td>325</td>\n",
       "      <td>924</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>95</td>\n",
       "      <td>184</td>\n",
       "      <td>223</td>\n",
       "      <td>239</td>\n",
       "      <td>227</td>\n",
       "      <td>130</td>\n",
       "      <td>244</td>\n",
       "      <td>240</td>\n",
       "      <td>167</td>\n",
       "      <td>228</td>\n",
       "      <td>...</td>\n",
       "      <td>199</td>\n",
       "      <td>1047</td>\n",
       "      <td>187</td>\n",
       "      <td>519</td>\n",
       "      <td>56</td>\n",
       "      <td>170</td>\n",
       "      <td>288</td>\n",
       "      <td>211</td>\n",
       "      <td>265</td>\n",
       "      <td>691</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>96</td>\n",
       "      <td>187</td>\n",
       "      <td>186</td>\n",
       "      <td>171</td>\n",
       "      <td>172</td>\n",
       "      <td>0</td>\n",
       "      <td>199</td>\n",
       "      <td>186</td>\n",
       "      <td>132</td>\n",
       "      <td>181</td>\n",
       "      <td>...</td>\n",
       "      <td>161</td>\n",
       "      <td>919</td>\n",
       "      <td>168</td>\n",
       "      <td>436</td>\n",
       "      <td>47</td>\n",
       "      <td>141</td>\n",
       "      <td>203</td>\n",
       "      <td>160</td>\n",
       "      <td>177</td>\n",
       "      <td>550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>58</td>\n",
       "      <td>118</td>\n",
       "      <td>120</td>\n",
       "      <td>136</td>\n",
       "      <td>142</td>\n",
       "      <td>0</td>\n",
       "      <td>141</td>\n",
       "      <td>143</td>\n",
       "      <td>91</td>\n",
       "      <td>133</td>\n",
       "      <td>...</td>\n",
       "      <td>118</td>\n",
       "      <td>820</td>\n",
       "      <td>134</td>\n",
       "      <td>334</td>\n",
       "      <td>39</td>\n",
       "      <td>125</td>\n",
       "      <td>167</td>\n",
       "      <td>122</td>\n",
       "      <td>127</td>\n",
       "      <td>441</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>47</td>\n",
       "      <td>83</td>\n",
       "      <td>89</td>\n",
       "      <td>88</td>\n",
       "      <td>105</td>\n",
       "      <td>0</td>\n",
       "      <td>93</td>\n",
       "      <td>100</td>\n",
       "      <td>67</td>\n",
       "      <td>93</td>\n",
       "      <td>...</td>\n",
       "      <td>96</td>\n",
       "      <td>769</td>\n",
       "      <td>105</td>\n",
       "      <td>250</td>\n",
       "      <td>37</td>\n",
       "      <td>107</td>\n",
       "      <td>127</td>\n",
       "      <td>83</td>\n",
       "      <td>78</td>\n",
       "      <td>397</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>24 rows × 378 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    646     1421    1883    1884    1885    1886    2147    2369    2870    \\\n",
       "0       29      54      57      53      58      67      69      57      36   \n",
       "1       26      31      31      29      31      36      40      44      26   \n",
       "2       19      22      19      24      23      29      29      35      18   \n",
       "3       17      19       7       9      17      24      22      33      12   \n",
       "4       27      26      20      18      17      21      34      67      17   \n",
       "5       52      55      53      54      45      42      76     204      49   \n",
       "6       98     152     135     145     156     107     183     290     106   \n",
       "7      135     316     423     395     379     383     457     389     326   \n",
       "8      183     354     352     332     352     356     421     467     296   \n",
       "9      212     213     206     206     198     205     263     359     156   \n",
       "10     201     220     207     223     180     208     242     324     148   \n",
       "11     237     260     253     243     228     241     281     317     177   \n",
       "12     251     288     289     291     255     291     303     343     186   \n",
       "13     272     295     311     314     268     315     312     351     208   \n",
       "14     264     353     367     368     357     415     417     382     288   \n",
       "15     294     401     429     442     387     430     465     432     315   \n",
       "16     291     396     380     380     364     374     440     416     267   \n",
       "17     226     411     371     406     328     378     420     426     272   \n",
       "18     183     367     325     372     339     364     404     380     267   \n",
       "19     153     316     277     312     286     333     366     357     227   \n",
       "20      95     184     223     239     227     130     244     240     167   \n",
       "21      96     187     186     171     172       0     199     186     132   \n",
       "22      58     118     120     136     142       0     141     143      91   \n",
       "23      47      83      89      88     105       0      93     100      67   \n",
       "\n",
       "    2930     ...    176975  178394  179509  180547  183880  184214  188247  \\\n",
       "0       56   ...        57     494      71     163      24      81      98   \n",
       "1       35   ...        36     305      48      99      14      55      59   \n",
       "2       26   ...        25     196      34      59       8      44      42   \n",
       "3       18   ...        23     162      28      46       7      39      27   \n",
       "4       13   ...        20     180      29      67       7      59      35   \n",
       "5       25   ...        50     291      47     155      15     122      66   \n",
       "6       74   ...       105     670     115     432      32     264     136   \n",
       "7      346   ...       177    1169     230    1069      82     301     272   \n",
       "8      404   ...       219    1257     285    1154      88     339     362   \n",
       "9      225   ...       210    1135     200     752      56     283     347   \n",
       "10     227   ...       227    1046     180     597      54     249     352   \n",
       "11     237   ...       241    1024     185     487      64     238     348   \n",
       "12     287   ...       268    1121     207     625      66     242     360   \n",
       "13     290   ...       257    1165     217     643      68     245     368   \n",
       "14     385   ...       261    1211     228     721      76     283     368   \n",
       "15     369   ...       277    1355     270     823      81     285     394   \n",
       "16     362   ...       264    1338     257     928      75     308     402   \n",
       "17     357   ...       268    1322     257     992      93     342     374   \n",
       "18     313   ...       244    1281     250     933      75     305     354   \n",
       "19     276   ...       233    1191     222     756      57     231     341   \n",
       "20     228   ...       199    1047     187     519      56     170     288   \n",
       "21     181   ...       161     919     168     436      47     141     203   \n",
       "22     133   ...       118     820     134     334      39     125     167   \n",
       "23      93   ...        96     769     105     250      37     107     127   \n",
       "\n",
       "    194331  194358  194613  \n",
       "0       52      44     225  \n",
       "1       32      30     134  \n",
       "2       23      18      75  \n",
       "3       20      13      63  \n",
       "4       26      17      81  \n",
       "5       57      25     218  \n",
       "6       93      61     728  \n",
       "7      153     150    1265  \n",
       "8      177     250    1039  \n",
       "9      174     242     965  \n",
       "10     192     242     768  \n",
       "11     221     260     893  \n",
       "12     257     269     905  \n",
       "13     271     296     935  \n",
       "14     276     323    1081  \n",
       "15     301     331    1298  \n",
       "16     307     420    1336  \n",
       "17     318     416    1370  \n",
       "18     278     377    1100  \n",
       "19     250     325     924  \n",
       "20     211     265     691  \n",
       "21     160     177     550  \n",
       "22     122     127     441  \n",
       "23      83      78     397  \n",
       "\n",
       "[24 rows x 378 columns]"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "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>2153</th>\n",
       "      <th>6644</th>\n",
       "      <th>7564</th>\n",
       "      <th>11599</th>\n",
       "      <th>12945</th>\n",
       "      <th>13133</th>\n",
       "      <th>14602</th>\n",
       "      <th>17319</th>\n",
       "      <th>17652</th>\n",
       "      <th>18635</th>\n",
       "      <th>...</th>\n",
       "      <th>174566</th>\n",
       "      <th>175696</th>\n",
       "      <th>176380</th>\n",
       "      <th>176399</th>\n",
       "      <th>176426</th>\n",
       "      <th>178157</th>\n",
       "      <th>179545</th>\n",
       "      <th>179547</th>\n",
       "      <th>184562</th>\n",
       "      <th>192292</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>65</td>\n",
       "      <td>102</td>\n",
       "      <td>133</td>\n",
       "      <td>27</td>\n",
       "      <td>63</td>\n",
       "      <td>286</td>\n",
       "      <td>22</td>\n",
       "      <td>218</td>\n",
       "      <td>147</td>\n",
       "      <td>84</td>\n",
       "      <td>...</td>\n",
       "      <td>205</td>\n",
       "      <td>1179</td>\n",
       "      <td>24</td>\n",
       "      <td>119</td>\n",
       "      <td>40</td>\n",
       "      <td>107</td>\n",
       "      <td>359</td>\n",
       "      <td>43</td>\n",
       "      <td>216</td>\n",
       "      <td>3452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>43</td>\n",
       "      <td>63</td>\n",
       "      <td>79</td>\n",
       "      <td>15</td>\n",
       "      <td>36</td>\n",
       "      <td>168</td>\n",
       "      <td>15</td>\n",
       "      <td>146</td>\n",
       "      <td>102</td>\n",
       "      <td>59</td>\n",
       "      <td>...</td>\n",
       "      <td>103</td>\n",
       "      <td>822</td>\n",
       "      <td>20</td>\n",
       "      <td>74</td>\n",
       "      <td>25</td>\n",
       "      <td>70</td>\n",
       "      <td>203</td>\n",
       "      <td>19</td>\n",
       "      <td>159</td>\n",
       "      <td>2814</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>28</td>\n",
       "      <td>44</td>\n",
       "      <td>49</td>\n",
       "      <td>9</td>\n",
       "      <td>20</td>\n",
       "      <td>111</td>\n",
       "      <td>7</td>\n",
       "      <td>106</td>\n",
       "      <td>76</td>\n",
       "      <td>38</td>\n",
       "      <td>...</td>\n",
       "      <td>65</td>\n",
       "      <td>645</td>\n",
       "      <td>15</td>\n",
       "      <td>50</td>\n",
       "      <td>24</td>\n",
       "      <td>53</td>\n",
       "      <td>140</td>\n",
       "      <td>13</td>\n",
       "      <td>124</td>\n",
       "      <td>2294</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>22</td>\n",
       "      <td>35</td>\n",
       "      <td>30</td>\n",
       "      <td>7</td>\n",
       "      <td>15</td>\n",
       "      <td>86</td>\n",
       "      <td>5</td>\n",
       "      <td>97</td>\n",
       "      <td>77</td>\n",
       "      <td>34</td>\n",
       "      <td>...</td>\n",
       "      <td>49</td>\n",
       "      <td>618</td>\n",
       "      <td>13</td>\n",
       "      <td>41</td>\n",
       "      <td>21</td>\n",
       "      <td>47</td>\n",
       "      <td>132</td>\n",
       "      <td>10</td>\n",
       "      <td>107</td>\n",
       "      <td>2229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>33</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>6</td>\n",
       "      <td>12</td>\n",
       "      <td>113</td>\n",
       "      <td>7</td>\n",
       "      <td>108</td>\n",
       "      <td>100</td>\n",
       "      <td>39</td>\n",
       "      <td>...</td>\n",
       "      <td>51</td>\n",
       "      <td>892</td>\n",
       "      <td>12</td>\n",
       "      <td>58</td>\n",
       "      <td>28</td>\n",
       "      <td>73</td>\n",
       "      <td>189</td>\n",
       "      <td>14</td>\n",
       "      <td>110</td>\n",
       "      <td>2618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>78</td>\n",
       "      <td>112</td>\n",
       "      <td>145</td>\n",
       "      <td>19</td>\n",
       "      <td>22</td>\n",
       "      <td>224</td>\n",
       "      <td>12</td>\n",
       "      <td>164</td>\n",
       "      <td>193</td>\n",
       "      <td>53</td>\n",
       "      <td>...</td>\n",
       "      <td>90</td>\n",
       "      <td>1220</td>\n",
       "      <td>15</td>\n",
       "      <td>85</td>\n",
       "      <td>38</td>\n",
       "      <td>216</td>\n",
       "      <td>432</td>\n",
       "      <td>25</td>\n",
       "      <td>120</td>\n",
       "      <td>3182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>166</td>\n",
       "      <td>203</td>\n",
       "      <td>412</td>\n",
       "      <td>92</td>\n",
       "      <td>68</td>\n",
       "      <td>495</td>\n",
       "      <td>39</td>\n",
       "      <td>323</td>\n",
       "      <td>428</td>\n",
       "      <td>107</td>\n",
       "      <td>...</td>\n",
       "      <td>311</td>\n",
       "      <td>1783</td>\n",
       "      <td>23</td>\n",
       "      <td>187</td>\n",
       "      <td>96</td>\n",
       "      <td>307</td>\n",
       "      <td>1004</td>\n",
       "      <td>81</td>\n",
       "      <td>209</td>\n",
       "      <td>4035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>298</td>\n",
       "      <td>386</td>\n",
       "      <td>669</td>\n",
       "      <td>276</td>\n",
       "      <td>229</td>\n",
       "      <td>799</td>\n",
       "      <td>148</td>\n",
       "      <td>606</td>\n",
       "      <td>560</td>\n",
       "      <td>218</td>\n",
       "      <td>...</td>\n",
       "      <td>705</td>\n",
       "      <td>2374</td>\n",
       "      <td>46</td>\n",
       "      <td>465</td>\n",
       "      <td>226</td>\n",
       "      <td>404</td>\n",
       "      <td>1353</td>\n",
       "      <td>82</td>\n",
       "      <td>416</td>\n",
       "      <td>4605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>321</td>\n",
       "      <td>451</td>\n",
       "      <td>722</td>\n",
       "      <td>240</td>\n",
       "      <td>297</td>\n",
       "      <td>884</td>\n",
       "      <td>110</td>\n",
       "      <td>644</td>\n",
       "      <td>502</td>\n",
       "      <td>315</td>\n",
       "      <td>...</td>\n",
       "      <td>901</td>\n",
       "      <td>2316</td>\n",
       "      <td>60</td>\n",
       "      <td>536</td>\n",
       "      <td>181</td>\n",
       "      <td>481</td>\n",
       "      <td>1349</td>\n",
       "      <td>77</td>\n",
       "      <td>500</td>\n",
       "      <td>4474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>236</td>\n",
       "      <td>500</td>\n",
       "      <td>697</td>\n",
       "      <td>153</td>\n",
       "      <td>231</td>\n",
       "      <td>831</td>\n",
       "      <td>90</td>\n",
       "      <td>578</td>\n",
       "      <td>443</td>\n",
       "      <td>297</td>\n",
       "      <td>...</td>\n",
       "      <td>803</td>\n",
       "      <td>1978</td>\n",
       "      <td>59</td>\n",
       "      <td>414</td>\n",
       "      <td>166</td>\n",
       "      <td>412</td>\n",
       "      <td>1237</td>\n",
       "      <td>68</td>\n",
       "      <td>452</td>\n",
       "      <td>4371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>240</td>\n",
       "      <td>590</td>\n",
       "      <td>723</td>\n",
       "      <td>161</td>\n",
       "      <td>263</td>\n",
       "      <td>823</td>\n",
       "      <td>89</td>\n",
       "      <td>601</td>\n",
       "      <td>431</td>\n",
       "      <td>298</td>\n",
       "      <td>...</td>\n",
       "      <td>757</td>\n",
       "      <td>1876</td>\n",
       "      <td>58</td>\n",
       "      <td>407</td>\n",
       "      <td>182</td>\n",
       "      <td>395</td>\n",
       "      <td>1108</td>\n",
       "      <td>67</td>\n",
       "      <td>415</td>\n",
       "      <td>4436</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>276</td>\n",
       "      <td>710</td>\n",
       "      <td>849</td>\n",
       "      <td>180</td>\n",
       "      <td>354</td>\n",
       "      <td>875</td>\n",
       "      <td>102</td>\n",
       "      <td>639</td>\n",
       "      <td>492</td>\n",
       "      <td>326</td>\n",
       "      <td>...</td>\n",
       "      <td>737</td>\n",
       "      <td>1938</td>\n",
       "      <td>69</td>\n",
       "      <td>456</td>\n",
       "      <td>214</td>\n",
       "      <td>426</td>\n",
       "      <td>1056</td>\n",
       "      <td>85</td>\n",
       "      <td>427</td>\n",
       "      <td>4590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>300</td>\n",
       "      <td>765</td>\n",
       "      <td>964</td>\n",
       "      <td>204</td>\n",
       "      <td>409</td>\n",
       "      <td>922</td>\n",
       "      <td>77</td>\n",
       "      <td>678</td>\n",
       "      <td>515</td>\n",
       "      <td>349</td>\n",
       "      <td>...</td>\n",
       "      <td>766</td>\n",
       "      <td>1993</td>\n",
       "      <td>65</td>\n",
       "      <td>476</td>\n",
       "      <td>222</td>\n",
       "      <td>473</td>\n",
       "      <td>1100</td>\n",
       "      <td>79</td>\n",
       "      <td>448</td>\n",
       "      <td>4812</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>315</td>\n",
       "      <td>686</td>\n",
       "      <td>803</td>\n",
       "      <td>216</td>\n",
       "      <td>467</td>\n",
       "      <td>955</td>\n",
       "      <td>81</td>\n",
       "      <td>720</td>\n",
       "      <td>554</td>\n",
       "      <td>357</td>\n",
       "      <td>...</td>\n",
       "      <td>777</td>\n",
       "      <td>2051</td>\n",
       "      <td>61</td>\n",
       "      <td>517</td>\n",
       "      <td>232</td>\n",
       "      <td>537</td>\n",
       "      <td>1148</td>\n",
       "      <td>79</td>\n",
       "      <td>471</td>\n",
       "      <td>4691</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>343</td>\n",
       "      <td>750</td>\n",
       "      <td>941</td>\n",
       "      <td>293</td>\n",
       "      <td>551</td>\n",
       "      <td>1027</td>\n",
       "      <td>110</td>\n",
       "      <td>751</td>\n",
       "      <td>585</td>\n",
       "      <td>378</td>\n",
       "      <td>...</td>\n",
       "      <td>829</td>\n",
       "      <td>2234</td>\n",
       "      <td>70</td>\n",
       "      <td>587</td>\n",
       "      <td>282</td>\n",
       "      <td>530</td>\n",
       "      <td>1290</td>\n",
       "      <td>110</td>\n",
       "      <td>523</td>\n",
       "      <td>4865</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>389</td>\n",
       "      <td>776</td>\n",
       "      <td>928</td>\n",
       "      <td>295</td>\n",
       "      <td>551</td>\n",
       "      <td>969</td>\n",
       "      <td>106</td>\n",
       "      <td>777</td>\n",
       "      <td>619</td>\n",
       "      <td>383</td>\n",
       "      <td>...</td>\n",
       "      <td>975</td>\n",
       "      <td>2228</td>\n",
       "      <td>71</td>\n",
       "      <td>642</td>\n",
       "      <td>294</td>\n",
       "      <td>568</td>\n",
       "      <td>1449</td>\n",
       "      <td>114</td>\n",
       "      <td>586</td>\n",
       "      <td>5096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>371</td>\n",
       "      <td>735</td>\n",
       "      <td>891</td>\n",
       "      <td>274</td>\n",
       "      <td>599</td>\n",
       "      <td>1019</td>\n",
       "      <td>84</td>\n",
       "      <td>773</td>\n",
       "      <td>629</td>\n",
       "      <td>381</td>\n",
       "      <td>...</td>\n",
       "      <td>1064</td>\n",
       "      <td>2118</td>\n",
       "      <td>64</td>\n",
       "      <td>604</td>\n",
       "      <td>308</td>\n",
       "      <td>565</td>\n",
       "      <td>1558</td>\n",
       "      <td>142</td>\n",
       "      <td>629</td>\n",
       "      <td>4960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>366</td>\n",
       "      <td>710</td>\n",
       "      <td>969</td>\n",
       "      <td>262</td>\n",
       "      <td>633</td>\n",
       "      <td>992</td>\n",
       "      <td>90</td>\n",
       "      <td>816</td>\n",
       "      <td>586</td>\n",
       "      <td>399</td>\n",
       "      <td>...</td>\n",
       "      <td>1147</td>\n",
       "      <td>1963</td>\n",
       "      <td>68</td>\n",
       "      <td>608</td>\n",
       "      <td>279</td>\n",
       "      <td>560</td>\n",
       "      <td>1530</td>\n",
       "      <td>140</td>\n",
       "      <td>626</td>\n",
       "      <td>4678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>361</td>\n",
       "      <td>668</td>\n",
       "      <td>884</td>\n",
       "      <td>228</td>\n",
       "      <td>561</td>\n",
       "      <td>956</td>\n",
       "      <td>85</td>\n",
       "      <td>751</td>\n",
       "      <td>528</td>\n",
       "      <td>373</td>\n",
       "      <td>...</td>\n",
       "      <td>1065</td>\n",
       "      <td>1844</td>\n",
       "      <td>65</td>\n",
       "      <td>524</td>\n",
       "      <td>202</td>\n",
       "      <td>482</td>\n",
       "      <td>1444</td>\n",
       "      <td>113</td>\n",
       "      <td>559</td>\n",
       "      <td>4322</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>309</td>\n",
       "      <td>541</td>\n",
       "      <td>704</td>\n",
       "      <td>159</td>\n",
       "      <td>366</td>\n",
       "      <td>894</td>\n",
       "      <td>72</td>\n",
       "      <td>669</td>\n",
       "      <td>421</td>\n",
       "      <td>323</td>\n",
       "      <td>...</td>\n",
       "      <td>831</td>\n",
       "      <td>1683</td>\n",
       "      <td>63</td>\n",
       "      <td>389</td>\n",
       "      <td>162</td>\n",
       "      <td>393</td>\n",
       "      <td>1134</td>\n",
       "      <td>97</td>\n",
       "      <td>476</td>\n",
       "      <td>4350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>235</td>\n",
       "      <td>361</td>\n",
       "      <td>574</td>\n",
       "      <td>110</td>\n",
       "      <td>233</td>\n",
       "      <td>745</td>\n",
       "      <td>56</td>\n",
       "      <td>526</td>\n",
       "      <td>322</td>\n",
       "      <td>265</td>\n",
       "      <td>...</td>\n",
       "      <td>585</td>\n",
       "      <td>1453</td>\n",
       "      <td>56</td>\n",
       "      <td>322</td>\n",
       "      <td>129</td>\n",
       "      <td>308</td>\n",
       "      <td>884</td>\n",
       "      <td>73</td>\n",
       "      <td>412</td>\n",
       "      <td>4262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>177</td>\n",
       "      <td>262</td>\n",
       "      <td>404</td>\n",
       "      <td>79</td>\n",
       "      <td>147</td>\n",
       "      <td>611</td>\n",
       "      <td>42</td>\n",
       "      <td>430</td>\n",
       "      <td>256</td>\n",
       "      <td>209</td>\n",
       "      <td>...</td>\n",
       "      <td>475</td>\n",
       "      <td>1192</td>\n",
       "      <td>51</td>\n",
       "      <td>281</td>\n",
       "      <td>109</td>\n",
       "      <td>236</td>\n",
       "      <td>749</td>\n",
       "      <td>81</td>\n",
       "      <td>355</td>\n",
       "      <td>4141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>136</td>\n",
       "      <td>195</td>\n",
       "      <td>298</td>\n",
       "      <td>63</td>\n",
       "      <td>111</td>\n",
       "      <td>509</td>\n",
       "      <td>36</td>\n",
       "      <td>338</td>\n",
       "      <td>206</td>\n",
       "      <td>160</td>\n",
       "      <td>...</td>\n",
       "      <td>442</td>\n",
       "      <td>1540</td>\n",
       "      <td>48</td>\n",
       "      <td>209</td>\n",
       "      <td>88</td>\n",
       "      <td>179</td>\n",
       "      <td>615</td>\n",
       "      <td>56</td>\n",
       "      <td>310</td>\n",
       "      <td>4119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>98</td>\n",
       "      <td>136</td>\n",
       "      <td>241</td>\n",
       "      <td>45</td>\n",
       "      <td>85</td>\n",
       "      <td>387</td>\n",
       "      <td>28</td>\n",
       "      <td>257</td>\n",
       "      <td>171</td>\n",
       "      <td>121</td>\n",
       "      <td>...</td>\n",
       "      <td>370</td>\n",
       "      <td>1413</td>\n",
       "      <td>33</td>\n",
       "      <td>167</td>\n",
       "      <td>72</td>\n",
       "      <td>149</td>\n",
       "      <td>513</td>\n",
       "      <td>47</td>\n",
       "      <td>260</td>\n",
       "      <td>4034</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>24 rows × 376 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    2153    6644    7564    11599   12945   13133   14602   17319   17652   \\\n",
       "0       65     102     133      27      63     286      22     218     147   \n",
       "1       43      63      79      15      36     168      15     146     102   \n",
       "2       28      44      49       9      20     111       7     106      76   \n",
       "3       22      35      30       7      15      86       5      97      77   \n",
       "4       33      50      50       6      12     113       7     108     100   \n",
       "5       78     112     145      19      22     224      12     164     193   \n",
       "6      166     203     412      92      68     495      39     323     428   \n",
       "7      298     386     669     276     229     799     148     606     560   \n",
       "8      321     451     722     240     297     884     110     644     502   \n",
       "9      236     500     697     153     231     831      90     578     443   \n",
       "10     240     590     723     161     263     823      89     601     431   \n",
       "11     276     710     849     180     354     875     102     639     492   \n",
       "12     300     765     964     204     409     922      77     678     515   \n",
       "13     315     686     803     216     467     955      81     720     554   \n",
       "14     343     750     941     293     551    1027     110     751     585   \n",
       "15     389     776     928     295     551     969     106     777     619   \n",
       "16     371     735     891     274     599    1019      84     773     629   \n",
       "17     366     710     969     262     633     992      90     816     586   \n",
       "18     361     668     884     228     561     956      85     751     528   \n",
       "19     309     541     704     159     366     894      72     669     421   \n",
       "20     235     361     574     110     233     745      56     526     322   \n",
       "21     177     262     404      79     147     611      42     430     256   \n",
       "22     136     195     298      63     111     509      36     338     206   \n",
       "23      98     136     241      45      85     387      28     257     171   \n",
       "\n",
       "    18635    ...    174566  175696  176380  176399  176426  178157  179545  \\\n",
       "0       84   ...       205    1179      24     119      40     107     359   \n",
       "1       59   ...       103     822      20      74      25      70     203   \n",
       "2       38   ...        65     645      15      50      24      53     140   \n",
       "3       34   ...        49     618      13      41      21      47     132   \n",
       "4       39   ...        51     892      12      58      28      73     189   \n",
       "5       53   ...        90    1220      15      85      38     216     432   \n",
       "6      107   ...       311    1783      23     187      96     307    1004   \n",
       "7      218   ...       705    2374      46     465     226     404    1353   \n",
       "8      315   ...       901    2316      60     536     181     481    1349   \n",
       "9      297   ...       803    1978      59     414     166     412    1237   \n",
       "10     298   ...       757    1876      58     407     182     395    1108   \n",
       "11     326   ...       737    1938      69     456     214     426    1056   \n",
       "12     349   ...       766    1993      65     476     222     473    1100   \n",
       "13     357   ...       777    2051      61     517     232     537    1148   \n",
       "14     378   ...       829    2234      70     587     282     530    1290   \n",
       "15     383   ...       975    2228      71     642     294     568    1449   \n",
       "16     381   ...      1064    2118      64     604     308     565    1558   \n",
       "17     399   ...      1147    1963      68     608     279     560    1530   \n",
       "18     373   ...      1065    1844      65     524     202     482    1444   \n",
       "19     323   ...       831    1683      63     389     162     393    1134   \n",
       "20     265   ...       585    1453      56     322     129     308     884   \n",
       "21     209   ...       475    1192      51     281     109     236     749   \n",
       "22     160   ...       442    1540      48     209      88     179     615   \n",
       "23     121   ...       370    1413      33     167      72     149     513   \n",
       "\n",
       "    179547  184562  192292  \n",
       "0       43     216    3452  \n",
       "1       19     159    2814  \n",
       "2       13     124    2294  \n",
       "3       10     107    2229  \n",
       "4       14     110    2618  \n",
       "5       25     120    3182  \n",
       "6       81     209    4035  \n",
       "7       82     416    4605  \n",
       "8       77     500    4474  \n",
       "9       68     452    4371  \n",
       "10      67     415    4436  \n",
       "11      85     427    4590  \n",
       "12      79     448    4812  \n",
       "13      79     471    4691  \n",
       "14     110     523    4865  \n",
       "15     114     586    5096  \n",
       "16     142     629    4960  \n",
       "17     140     626    4678  \n",
       "18     113     559    4322  \n",
       "19      97     476    4350  \n",
       "20      73     412    4262  \n",
       "21      81     355    4141  \n",
       "22      56     310    4119  \n",
       "23      47     260    4034  \n",
       "\n",
       "[24 rows x 376 columns]"
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "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>18562</th>\n",
       "      <th>41788</th>\n",
       "      <th>81409</th>\n",
       "      <th>74299</th>\n",
       "      <th>1885</th>\n",
       "      <th>89603</th>\n",
       "      <th>45497</th>\n",
       "      <th>175828</th>\n",
       "      <th>83650</th>\n",
       "      <th>52914</th>\n",
       "      <th>...</th>\n",
       "      <th>77301</th>\n",
       "      <th>13277</th>\n",
       "      <th>41761</th>\n",
       "      <th>65642</th>\n",
       "      <th>183880</th>\n",
       "      <th>19174</th>\n",
       "      <th>86910</th>\n",
       "      <th>188247</th>\n",
       "      <th>98540</th>\n",
       "      <th>4853</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>22</td>\n",
       "      <td>101</td>\n",
       "      <td>44</td>\n",
       "      <td>147</td>\n",
       "      <td>58</td>\n",
       "      <td>59</td>\n",
       "      <td>137</td>\n",
       "      <td>122</td>\n",
       "      <td>18</td>\n",
       "      <td>225</td>\n",
       "      <td>...</td>\n",
       "      <td>155</td>\n",
       "      <td>193</td>\n",
       "      <td>114</td>\n",
       "      <td>38</td>\n",
       "      <td>24</td>\n",
       "      <td>40</td>\n",
       "      <td>89</td>\n",
       "      <td>98</td>\n",
       "      <td>20</td>\n",
       "      <td>68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>25</td>\n",
       "      <td>44</td>\n",
       "      <td>30</td>\n",
       "      <td>87</td>\n",
       "      <td>31</td>\n",
       "      <td>34</td>\n",
       "      <td>86</td>\n",
       "      <td>85</td>\n",
       "      <td>10</td>\n",
       "      <td>142</td>\n",
       "      <td>...</td>\n",
       "      <td>117</td>\n",
       "      <td>104</td>\n",
       "      <td>62</td>\n",
       "      <td>19</td>\n",
       "      <td>14</td>\n",
       "      <td>24</td>\n",
       "      <td>57</td>\n",
       "      <td>59</td>\n",
       "      <td>12</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>15</td>\n",
       "      <td>30</td>\n",
       "      <td>25</td>\n",
       "      <td>63</td>\n",
       "      <td>23</td>\n",
       "      <td>25</td>\n",
       "      <td>77</td>\n",
       "      <td>67</td>\n",
       "      <td>10</td>\n",
       "      <td>105</td>\n",
       "      <td>...</td>\n",
       "      <td>101</td>\n",
       "      <td>74</td>\n",
       "      <td>34</td>\n",
       "      <td>11</td>\n",
       "      <td>8</td>\n",
       "      <td>18</td>\n",
       "      <td>42</td>\n",
       "      <td>42</td>\n",
       "      <td>8</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>10</td>\n",
       "      <td>23</td>\n",
       "      <td>21</td>\n",
       "      <td>67</td>\n",
       "      <td>17</td>\n",
       "      <td>19</td>\n",
       "      <td>72</td>\n",
       "      <td>51</td>\n",
       "      <td>9</td>\n",
       "      <td>93</td>\n",
       "      <td>...</td>\n",
       "      <td>100</td>\n",
       "      <td>52</td>\n",
       "      <td>29</td>\n",
       "      <td>11</td>\n",
       "      <td>7</td>\n",
       "      <td>14</td>\n",
       "      <td>35</td>\n",
       "      <td>27</td>\n",
       "      <td>6</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>23</td>\n",
       "      <td>91</td>\n",
       "      <td>17</td>\n",
       "      <td>25</td>\n",
       "      <td>113</td>\n",
       "      <td>62</td>\n",
       "      <td>11</td>\n",
       "      <td>122</td>\n",
       "      <td>...</td>\n",
       "      <td>156</td>\n",
       "      <td>56</td>\n",
       "      <td>45</td>\n",
       "      <td>15</td>\n",
       "      <td>7</td>\n",
       "      <td>18</td>\n",
       "      <td>43</td>\n",
       "      <td>35</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>12</td>\n",
       "      <td>60</td>\n",
       "      <td>50</td>\n",
       "      <td>179</td>\n",
       "      <td>45</td>\n",
       "      <td>47</td>\n",
       "      <td>221</td>\n",
       "      <td>65</td>\n",
       "      <td>17</td>\n",
       "      <td>205</td>\n",
       "      <td>...</td>\n",
       "      <td>232</td>\n",
       "      <td>117</td>\n",
       "      <td>79</td>\n",
       "      <td>39</td>\n",
       "      <td>15</td>\n",
       "      <td>32</td>\n",
       "      <td>83</td>\n",
       "      <td>66</td>\n",
       "      <td>11</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>28</td>\n",
       "      <td>128</td>\n",
       "      <td>115</td>\n",
       "      <td>341</td>\n",
       "      <td>156</td>\n",
       "      <td>100</td>\n",
       "      <td>476</td>\n",
       "      <td>92</td>\n",
       "      <td>32</td>\n",
       "      <td>410</td>\n",
       "      <td>...</td>\n",
       "      <td>361</td>\n",
       "      <td>273</td>\n",
       "      <td>171</td>\n",
       "      <td>105</td>\n",
       "      <td>32</td>\n",
       "      <td>94</td>\n",
       "      <td>209</td>\n",
       "      <td>136</td>\n",
       "      <td>39</td>\n",
       "      <td>171</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>65</td>\n",
       "      <td>332</td>\n",
       "      <td>189</td>\n",
       "      <td>529</td>\n",
       "      <td>379</td>\n",
       "      <td>218</td>\n",
       "      <td>643</td>\n",
       "      <td>177</td>\n",
       "      <td>65</td>\n",
       "      <td>633</td>\n",
       "      <td>...</td>\n",
       "      <td>511</td>\n",
       "      <td>634</td>\n",
       "      <td>380</td>\n",
       "      <td>312</td>\n",
       "      <td>82</td>\n",
       "      <td>170</td>\n",
       "      <td>227</td>\n",
       "      <td>272</td>\n",
       "      <td>137</td>\n",
       "      <td>310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>96</td>\n",
       "      <td>387</td>\n",
       "      <td>195</td>\n",
       "      <td>510</td>\n",
       "      <td>352</td>\n",
       "      <td>231</td>\n",
       "      <td>618</td>\n",
       "      <td>299</td>\n",
       "      <td>77</td>\n",
       "      <td>694</td>\n",
       "      <td>...</td>\n",
       "      <td>534</td>\n",
       "      <td>796</td>\n",
       "      <td>529</td>\n",
       "      <td>303</td>\n",
       "      <td>88</td>\n",
       "      <td>208</td>\n",
       "      <td>329</td>\n",
       "      <td>362</td>\n",
       "      <td>200</td>\n",
       "      <td>447</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>79</td>\n",
       "      <td>274</td>\n",
       "      <td>132</td>\n",
       "      <td>423</td>\n",
       "      <td>198</td>\n",
       "      <td>171</td>\n",
       "      <td>485</td>\n",
       "      <td>249</td>\n",
       "      <td>71</td>\n",
       "      <td>555</td>\n",
       "      <td>...</td>\n",
       "      <td>486</td>\n",
       "      <td>708</td>\n",
       "      <td>358</td>\n",
       "      <td>122</td>\n",
       "      <td>56</td>\n",
       "      <td>167</td>\n",
       "      <td>294</td>\n",
       "      <td>347</td>\n",
       "      <td>142</td>\n",
       "      <td>377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>66</td>\n",
       "      <td>213</td>\n",
       "      <td>135</td>\n",
       "      <td>434</td>\n",
       "      <td>180</td>\n",
       "      <td>149</td>\n",
       "      <td>439</td>\n",
       "      <td>247</td>\n",
       "      <td>87</td>\n",
       "      <td>693</td>\n",
       "      <td>...</td>\n",
       "      <td>457</td>\n",
       "      <td>729</td>\n",
       "      <td>95</td>\n",
       "      <td>99</td>\n",
       "      <td>54</td>\n",
       "      <td>165</td>\n",
       "      <td>282</td>\n",
       "      <td>352</td>\n",
       "      <td>118</td>\n",
       "      <td>357</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>68</td>\n",
       "      <td>233</td>\n",
       "      <td>156</td>\n",
       "      <td>489</td>\n",
       "      <td>228</td>\n",
       "      <td>186</td>\n",
       "      <td>494</td>\n",
       "      <td>259</td>\n",
       "      <td>92</td>\n",
       "      <td>745</td>\n",
       "      <td>...</td>\n",
       "      <td>481</td>\n",
       "      <td>769</td>\n",
       "      <td>0</td>\n",
       "      <td>110</td>\n",
       "      <td>64</td>\n",
       "      <td>177</td>\n",
       "      <td>279</td>\n",
       "      <td>348</td>\n",
       "      <td>135</td>\n",
       "      <td>408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>90</td>\n",
       "      <td>241</td>\n",
       "      <td>156</td>\n",
       "      <td>506</td>\n",
       "      <td>255</td>\n",
       "      <td>191</td>\n",
       "      <td>548</td>\n",
       "      <td>288</td>\n",
       "      <td>81</td>\n",
       "      <td>810</td>\n",
       "      <td>...</td>\n",
       "      <td>539</td>\n",
       "      <td>791</td>\n",
       "      <td>0</td>\n",
       "      <td>113</td>\n",
       "      <td>66</td>\n",
       "      <td>200</td>\n",
       "      <td>297</td>\n",
       "      <td>360</td>\n",
       "      <td>143</td>\n",
       "      <td>442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>83</td>\n",
       "      <td>240</td>\n",
       "      <td>166</td>\n",
       "      <td>530</td>\n",
       "      <td>268</td>\n",
       "      <td>207</td>\n",
       "      <td>554</td>\n",
       "      <td>300</td>\n",
       "      <td>95</td>\n",
       "      <td>829</td>\n",
       "      <td>...</td>\n",
       "      <td>568</td>\n",
       "      <td>810</td>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "      <td>68</td>\n",
       "      <td>199</td>\n",
       "      <td>328</td>\n",
       "      <td>368</td>\n",
       "      <td>145</td>\n",
       "      <td>496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>97</td>\n",
       "      <td>289</td>\n",
       "      <td>199</td>\n",
       "      <td>611</td>\n",
       "      <td>357</td>\n",
       "      <td>256</td>\n",
       "      <td>573</td>\n",
       "      <td>326</td>\n",
       "      <td>101</td>\n",
       "      <td>861</td>\n",
       "      <td>...</td>\n",
       "      <td>622</td>\n",
       "      <td>989</td>\n",
       "      <td>0</td>\n",
       "      <td>152</td>\n",
       "      <td>76</td>\n",
       "      <td>244</td>\n",
       "      <td>399</td>\n",
       "      <td>368</td>\n",
       "      <td>187</td>\n",
       "      <td>508</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>104</td>\n",
       "      <td>362</td>\n",
       "      <td>217</td>\n",
       "      <td>669</td>\n",
       "      <td>387</td>\n",
       "      <td>258</td>\n",
       "      <td>653</td>\n",
       "      <td>393</td>\n",
       "      <td>114</td>\n",
       "      <td>916</td>\n",
       "      <td>...</td>\n",
       "      <td>667</td>\n",
       "      <td>1184</td>\n",
       "      <td>0</td>\n",
       "      <td>177</td>\n",
       "      <td>81</td>\n",
       "      <td>248</td>\n",
       "      <td>387</td>\n",
       "      <td>394</td>\n",
       "      <td>202</td>\n",
       "      <td>529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>111</td>\n",
       "      <td>380</td>\n",
       "      <td>227</td>\n",
       "      <td>637</td>\n",
       "      <td>364</td>\n",
       "      <td>277</td>\n",
       "      <td>674</td>\n",
       "      <td>416</td>\n",
       "      <td>121</td>\n",
       "      <td>1036</td>\n",
       "      <td>...</td>\n",
       "      <td>697</td>\n",
       "      <td>1205</td>\n",
       "      <td>0</td>\n",
       "      <td>187</td>\n",
       "      <td>75</td>\n",
       "      <td>202</td>\n",
       "      <td>382</td>\n",
       "      <td>402</td>\n",
       "      <td>178</td>\n",
       "      <td>581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>120</td>\n",
       "      <td>375</td>\n",
       "      <td>231</td>\n",
       "      <td>658</td>\n",
       "      <td>328</td>\n",
       "      <td>298</td>\n",
       "      <td>705</td>\n",
       "      <td>403</td>\n",
       "      <td>96</td>\n",
       "      <td>1063</td>\n",
       "      <td>...</td>\n",
       "      <td>684</td>\n",
       "      <td>1208</td>\n",
       "      <td>0</td>\n",
       "      <td>214</td>\n",
       "      <td>93</td>\n",
       "      <td>218</td>\n",
       "      <td>373</td>\n",
       "      <td>374</td>\n",
       "      <td>205</td>\n",
       "      <td>544</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>112</td>\n",
       "      <td>329</td>\n",
       "      <td>193</td>\n",
       "      <td>618</td>\n",
       "      <td>339</td>\n",
       "      <td>265</td>\n",
       "      <td>609</td>\n",
       "      <td>384</td>\n",
       "      <td>66</td>\n",
       "      <td>1003</td>\n",
       "      <td>...</td>\n",
       "      <td>560</td>\n",
       "      <td>981</td>\n",
       "      <td>0</td>\n",
       "      <td>189</td>\n",
       "      <td>75</td>\n",
       "      <td>182</td>\n",
       "      <td>325</td>\n",
       "      <td>354</td>\n",
       "      <td>178</td>\n",
       "      <td>470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>113</td>\n",
       "      <td>257</td>\n",
       "      <td>149</td>\n",
       "      <td>505</td>\n",
       "      <td>286</td>\n",
       "      <td>213</td>\n",
       "      <td>487</td>\n",
       "      <td>322</td>\n",
       "      <td>48</td>\n",
       "      <td>842</td>\n",
       "      <td>...</td>\n",
       "      <td>372</td>\n",
       "      <td>813</td>\n",
       "      <td>0</td>\n",
       "      <td>148</td>\n",
       "      <td>57</td>\n",
       "      <td>142</td>\n",
       "      <td>268</td>\n",
       "      <td>341</td>\n",
       "      <td>142</td>\n",
       "      <td>368</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>88</td>\n",
       "      <td>225</td>\n",
       "      <td>117</td>\n",
       "      <td>401</td>\n",
       "      <td>227</td>\n",
       "      <td>174</td>\n",
       "      <td>392</td>\n",
       "      <td>276</td>\n",
       "      <td>54</td>\n",
       "      <td>659</td>\n",
       "      <td>...</td>\n",
       "      <td>303</td>\n",
       "      <td>604</td>\n",
       "      <td>0</td>\n",
       "      <td>116</td>\n",
       "      <td>56</td>\n",
       "      <td>109</td>\n",
       "      <td>221</td>\n",
       "      <td>288</td>\n",
       "      <td>106</td>\n",
       "      <td>291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>82</td>\n",
       "      <td>185</td>\n",
       "      <td>88</td>\n",
       "      <td>328</td>\n",
       "      <td>172</td>\n",
       "      <td>136</td>\n",
       "      <td>299</td>\n",
       "      <td>219</td>\n",
       "      <td>37</td>\n",
       "      <td>553</td>\n",
       "      <td>...</td>\n",
       "      <td>241</td>\n",
       "      <td>508</td>\n",
       "      <td>0</td>\n",
       "      <td>104</td>\n",
       "      <td>47</td>\n",
       "      <td>88</td>\n",
       "      <td>196</td>\n",
       "      <td>203</td>\n",
       "      <td>85</td>\n",
       "      <td>219</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>52</td>\n",
       "      <td>142</td>\n",
       "      <td>88</td>\n",
       "      <td>249</td>\n",
       "      <td>142</td>\n",
       "      <td>117</td>\n",
       "      <td>227</td>\n",
       "      <td>192</td>\n",
       "      <td>37</td>\n",
       "      <td>434</td>\n",
       "      <td>...</td>\n",
       "      <td>208</td>\n",
       "      <td>416</td>\n",
       "      <td>0</td>\n",
       "      <td>76</td>\n",
       "      <td>39</td>\n",
       "      <td>74</td>\n",
       "      <td>180</td>\n",
       "      <td>167</td>\n",
       "      <td>58</td>\n",
       "      <td>142</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>33</td>\n",
       "      <td>134</td>\n",
       "      <td>67</td>\n",
       "      <td>178</td>\n",
       "      <td>105</td>\n",
       "      <td>94</td>\n",
       "      <td>171</td>\n",
       "      <td>166</td>\n",
       "      <td>29</td>\n",
       "      <td>337</td>\n",
       "      <td>...</td>\n",
       "      <td>203</td>\n",
       "      <td>286</td>\n",
       "      <td>0</td>\n",
       "      <td>59</td>\n",
       "      <td>37</td>\n",
       "      <td>54</td>\n",
       "      <td>129</td>\n",
       "      <td>127</td>\n",
       "      <td>31</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>24 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    18562   41788   81409   74299   1885    89603   45497   175828  83650   \\\n",
       "0       22     101      44     147      58      59     137     122      18   \n",
       "1       25      44      30      87      31      34      86      85      10   \n",
       "2       15      30      25      63      23      25      77      67      10   \n",
       "3       10      23      21      67      17      19      72      51       9   \n",
       "4       12      31      23      91      17      25     113      62      11   \n",
       "5       12      60      50     179      45      47     221      65      17   \n",
       "6       28     128     115     341     156     100     476      92      32   \n",
       "7       65     332     189     529     379     218     643     177      65   \n",
       "8       96     387     195     510     352     231     618     299      77   \n",
       "9       79     274     132     423     198     171     485     249      71   \n",
       "10      66     213     135     434     180     149     439     247      87   \n",
       "11      68     233     156     489     228     186     494     259      92   \n",
       "12      90     241     156     506     255     191     548     288      81   \n",
       "13      83     240     166     530     268     207     554     300      95   \n",
       "14      97     289     199     611     357     256     573     326     101   \n",
       "15     104     362     217     669     387     258     653     393     114   \n",
       "16     111     380     227     637     364     277     674     416     121   \n",
       "17     120     375     231     658     328     298     705     403      96   \n",
       "18     112     329     193     618     339     265     609     384      66   \n",
       "19     113     257     149     505     286     213     487     322      48   \n",
       "20      88     225     117     401     227     174     392     276      54   \n",
       "21      82     185      88     328     172     136     299     219      37   \n",
       "22      52     142      88     249     142     117     227     192      37   \n",
       "23      33     134      67     178     105      94     171     166      29   \n",
       "\n",
       "    52914    ...    77301   13277   41761   65642   183880  19174   86910   \\\n",
       "0      225   ...       155     193     114      38      24      40      89   \n",
       "1      142   ...       117     104      62      19      14      24      57   \n",
       "2      105   ...       101      74      34      11       8      18      42   \n",
       "3       93   ...       100      52      29      11       7      14      35   \n",
       "4      122   ...       156      56      45      15       7      18      43   \n",
       "5      205   ...       232     117      79      39      15      32      83   \n",
       "6      410   ...       361     273     171     105      32      94     209   \n",
       "7      633   ...       511     634     380     312      82     170     227   \n",
       "8      694   ...       534     796     529     303      88     208     329   \n",
       "9      555   ...       486     708     358     122      56     167     294   \n",
       "10     693   ...       457     729      95      99      54     165     282   \n",
       "11     745   ...       481     769       0     110      64     177     279   \n",
       "12     810   ...       539     791       0     113      66     200     297   \n",
       "13     829   ...       568     810       0     119      68     199     328   \n",
       "14     861   ...       622     989       0     152      76     244     399   \n",
       "15     916   ...       667    1184       0     177      81     248     387   \n",
       "16    1036   ...       697    1205       0     187      75     202     382   \n",
       "17    1063   ...       684    1208       0     214      93     218     373   \n",
       "18    1003   ...       560     981       0     189      75     182     325   \n",
       "19     842   ...       372     813       0     148      57     142     268   \n",
       "20     659   ...       303     604       0     116      56     109     221   \n",
       "21     553   ...       241     508       0     104      47      88     196   \n",
       "22     434   ...       208     416       0      76      39      74     180   \n",
       "23     337   ...       203     286       0      59      37      54     129   \n",
       "\n",
       "    188247  98540   4853    \n",
       "0       98      20      68  \n",
       "1       59      12      33  \n",
       "2       42       8      22  \n",
       "3       27       6      18  \n",
       "4       35       6      30  \n",
       "5       66      11      87  \n",
       "6      136      39     171  \n",
       "7      272     137     310  \n",
       "8      362     200     447  \n",
       "9      347     142     377  \n",
       "10     352     118     357  \n",
       "11     348     135     408  \n",
       "12     360     143     442  \n",
       "13     368     145     496  \n",
       "14     368     187     508  \n",
       "15     394     202     529  \n",
       "16     402     178     581  \n",
       "17     374     205     544  \n",
       "18     354     178     470  \n",
       "19     341     142     368  \n",
       "20     288     106     291  \n",
       "21     203      85     219  \n",
       "22     167      58     142  \n",
       "23     127      31      78  \n",
       "\n",
       "[24 rows x 30 columns]"
      ]
     },
     "execution_count": 89,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s1 = y1.sample(30, axis=1)\n",
    "s1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "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>18641</th>\n",
       "      <th>62171</th>\n",
       "      <th>150677</th>\n",
       "      <th>108716</th>\n",
       "      <th>39011</th>\n",
       "      <th>18846</th>\n",
       "      <th>81165</th>\n",
       "      <th>155609</th>\n",
       "      <th>38055</th>\n",
       "      <th>78800</th>\n",
       "      <th>...</th>\n",
       "      <th>91529</th>\n",
       "      <th>70873</th>\n",
       "      <th>56994</th>\n",
       "      <th>34124</th>\n",
       "      <th>22219</th>\n",
       "      <th>17319</th>\n",
       "      <th>72335</th>\n",
       "      <th>41034</th>\n",
       "      <th>76391</th>\n",
       "      <th>158203</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>74</td>\n",
       "      <td>98</td>\n",
       "      <td>260</td>\n",
       "      <td>601</td>\n",
       "      <td>251</td>\n",
       "      <td>7</td>\n",
       "      <td>198</td>\n",
       "      <td>64</td>\n",
       "      <td>489</td>\n",
       "      <td>26</td>\n",
       "      <td>...</td>\n",
       "      <td>70</td>\n",
       "      <td>195</td>\n",
       "      <td>216</td>\n",
       "      <td>962</td>\n",
       "      <td>74</td>\n",
       "      <td>218</td>\n",
       "      <td>100</td>\n",
       "      <td>55</td>\n",
       "      <td>73</td>\n",
       "      <td>397</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>44</td>\n",
       "      <td>52</td>\n",
       "      <td>203</td>\n",
       "      <td>449</td>\n",
       "      <td>196</td>\n",
       "      <td>7</td>\n",
       "      <td>145</td>\n",
       "      <td>39</td>\n",
       "      <td>386</td>\n",
       "      <td>14</td>\n",
       "      <td>...</td>\n",
       "      <td>44</td>\n",
       "      <td>153</td>\n",
       "      <td>161</td>\n",
       "      <td>757</td>\n",
       "      <td>50</td>\n",
       "      <td>146</td>\n",
       "      <td>100</td>\n",
       "      <td>37</td>\n",
       "      <td>53</td>\n",
       "      <td>269</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>33</td>\n",
       "      <td>40</td>\n",
       "      <td>153</td>\n",
       "      <td>330</td>\n",
       "      <td>158</td>\n",
       "      <td>5</td>\n",
       "      <td>102</td>\n",
       "      <td>30</td>\n",
       "      <td>343</td>\n",
       "      <td>17</td>\n",
       "      <td>...</td>\n",
       "      <td>32</td>\n",
       "      <td>387</td>\n",
       "      <td>133</td>\n",
       "      <td>620</td>\n",
       "      <td>35</td>\n",
       "      <td>106</td>\n",
       "      <td>121</td>\n",
       "      <td>25</td>\n",
       "      <td>38</td>\n",
       "      <td>193</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>28</td>\n",
       "      <td>31</td>\n",
       "      <td>139</td>\n",
       "      <td>304</td>\n",
       "      <td>132</td>\n",
       "      <td>4</td>\n",
       "      <td>97</td>\n",
       "      <td>28</td>\n",
       "      <td>345</td>\n",
       "      <td>13</td>\n",
       "      <td>...</td>\n",
       "      <td>24</td>\n",
       "      <td>258</td>\n",
       "      <td>129</td>\n",
       "      <td>507</td>\n",
       "      <td>32</td>\n",
       "      <td>97</td>\n",
       "      <td>127</td>\n",
       "      <td>18</td>\n",
       "      <td>32</td>\n",
       "      <td>176</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>31</td>\n",
       "      <td>35</td>\n",
       "      <td>148</td>\n",
       "      <td>375</td>\n",
       "      <td>143</td>\n",
       "      <td>3</td>\n",
       "      <td>113</td>\n",
       "      <td>40</td>\n",
       "      <td>405</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>28</td>\n",
       "      <td>424</td>\n",
       "      <td>169</td>\n",
       "      <td>400</td>\n",
       "      <td>44</td>\n",
       "      <td>108</td>\n",
       "      <td>127</td>\n",
       "      <td>24</td>\n",
       "      <td>38</td>\n",
       "      <td>223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>33</td>\n",
       "      <td>55</td>\n",
       "      <td>138</td>\n",
       "      <td>435</td>\n",
       "      <td>163</td>\n",
       "      <td>4</td>\n",
       "      <td>157</td>\n",
       "      <td>67</td>\n",
       "      <td>572</td>\n",
       "      <td>25</td>\n",
       "      <td>...</td>\n",
       "      <td>43</td>\n",
       "      <td>164</td>\n",
       "      <td>239</td>\n",
       "      <td>396</td>\n",
       "      <td>82</td>\n",
       "      <td>164</td>\n",
       "      <td>123</td>\n",
       "      <td>34</td>\n",
       "      <td>32</td>\n",
       "      <td>291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>75</td>\n",
       "      <td>126</td>\n",
       "      <td>163</td>\n",
       "      <td>662</td>\n",
       "      <td>223</td>\n",
       "      <td>7</td>\n",
       "      <td>304</td>\n",
       "      <td>171</td>\n",
       "      <td>863</td>\n",
       "      <td>34</td>\n",
       "      <td>...</td>\n",
       "      <td>92</td>\n",
       "      <td>693</td>\n",
       "      <td>364</td>\n",
       "      <td>627</td>\n",
       "      <td>159</td>\n",
       "      <td>323</td>\n",
       "      <td>120</td>\n",
       "      <td>56</td>\n",
       "      <td>50</td>\n",
       "      <td>471</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>160</td>\n",
       "      <td>264</td>\n",
       "      <td>234</td>\n",
       "      <td>1175</td>\n",
       "      <td>359</td>\n",
       "      <td>15</td>\n",
       "      <td>476</td>\n",
       "      <td>305</td>\n",
       "      <td>1004</td>\n",
       "      <td>50</td>\n",
       "      <td>...</td>\n",
       "      <td>190</td>\n",
       "      <td>1408</td>\n",
       "      <td>598</td>\n",
       "      <td>911</td>\n",
       "      <td>239</td>\n",
       "      <td>606</td>\n",
       "      <td>118</td>\n",
       "      <td>119</td>\n",
       "      <td>114</td>\n",
       "      <td>679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>244</td>\n",
       "      <td>341</td>\n",
       "      <td>286</td>\n",
       "      <td>1246</td>\n",
       "      <td>427</td>\n",
       "      <td>25</td>\n",
       "      <td>506</td>\n",
       "      <td>306</td>\n",
       "      <td>1096</td>\n",
       "      <td>105</td>\n",
       "      <td>...</td>\n",
       "      <td>293</td>\n",
       "      <td>1196</td>\n",
       "      <td>656</td>\n",
       "      <td>1077</td>\n",
       "      <td>291</td>\n",
       "      <td>644</td>\n",
       "      <td>122</td>\n",
       "      <td>143</td>\n",
       "      <td>157</td>\n",
       "      <td>773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>222</td>\n",
       "      <td>354</td>\n",
       "      <td>286</td>\n",
       "      <td>1032</td>\n",
       "      <td>402</td>\n",
       "      <td>24</td>\n",
       "      <td>423</td>\n",
       "      <td>213</td>\n",
       "      <td>1056</td>\n",
       "      <td>63</td>\n",
       "      <td>...</td>\n",
       "      <td>290</td>\n",
       "      <td>296</td>\n",
       "      <td>619</td>\n",
       "      <td>1166</td>\n",
       "      <td>302</td>\n",
       "      <td>578</td>\n",
       "      <td>106</td>\n",
       "      <td>130</td>\n",
       "      <td>118</td>\n",
       "      <td>724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>233</td>\n",
       "      <td>317</td>\n",
       "      <td>330</td>\n",
       "      <td>1075</td>\n",
       "      <td>394</td>\n",
       "      <td>20</td>\n",
       "      <td>403</td>\n",
       "      <td>209</td>\n",
       "      <td>964</td>\n",
       "      <td>65</td>\n",
       "      <td>...</td>\n",
       "      <td>273</td>\n",
       "      <td>283</td>\n",
       "      <td>595</td>\n",
       "      <td>1185</td>\n",
       "      <td>263</td>\n",
       "      <td>601</td>\n",
       "      <td>104</td>\n",
       "      <td>133</td>\n",
       "      <td>126</td>\n",
       "      <td>719</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>252</td>\n",
       "      <td>322</td>\n",
       "      <td>358</td>\n",
       "      <td>1201</td>\n",
       "      <td>401</td>\n",
       "      <td>26</td>\n",
       "      <td>414</td>\n",
       "      <td>216</td>\n",
       "      <td>924</td>\n",
       "      <td>72</td>\n",
       "      <td>...</td>\n",
       "      <td>258</td>\n",
       "      <td>303</td>\n",
       "      <td>595</td>\n",
       "      <td>1214</td>\n",
       "      <td>293</td>\n",
       "      <td>639</td>\n",
       "      <td>93</td>\n",
       "      <td>152</td>\n",
       "      <td>141</td>\n",
       "      <td>787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>291</td>\n",
       "      <td>347</td>\n",
       "      <td>392</td>\n",
       "      <td>1245</td>\n",
       "      <td>404</td>\n",
       "      <td>21</td>\n",
       "      <td>430</td>\n",
       "      <td>245</td>\n",
       "      <td>944</td>\n",
       "      <td>80</td>\n",
       "      <td>...</td>\n",
       "      <td>270</td>\n",
       "      <td>318</td>\n",
       "      <td>632</td>\n",
       "      <td>1196</td>\n",
       "      <td>268</td>\n",
       "      <td>678</td>\n",
       "      <td>88</td>\n",
       "      <td>163</td>\n",
       "      <td>155</td>\n",
       "      <td>770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>301</td>\n",
       "      <td>356</td>\n",
       "      <td>407</td>\n",
       "      <td>1259</td>\n",
       "      <td>414</td>\n",
       "      <td>27</td>\n",
       "      <td>474</td>\n",
       "      <td>272</td>\n",
       "      <td>1018</td>\n",
       "      <td>76</td>\n",
       "      <td>...</td>\n",
       "      <td>279</td>\n",
       "      <td>333</td>\n",
       "      <td>674</td>\n",
       "      <td>1190</td>\n",
       "      <td>260</td>\n",
       "      <td>720</td>\n",
       "      <td>81</td>\n",
       "      <td>153</td>\n",
       "      <td>166</td>\n",
       "      <td>818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>319</td>\n",
       "      <td>370</td>\n",
       "      <td>501</td>\n",
       "      <td>1317</td>\n",
       "      <td>429</td>\n",
       "      <td>33</td>\n",
       "      <td>526</td>\n",
       "      <td>325</td>\n",
       "      <td>1044</td>\n",
       "      <td>87</td>\n",
       "      <td>...</td>\n",
       "      <td>291</td>\n",
       "      <td>355</td>\n",
       "      <td>703</td>\n",
       "      <td>1202</td>\n",
       "      <td>258</td>\n",
       "      <td>751</td>\n",
       "      <td>68</td>\n",
       "      <td>190</td>\n",
       "      <td>190</td>\n",
       "      <td>885</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>318</td>\n",
       "      <td>400</td>\n",
       "      <td>622</td>\n",
       "      <td>1574</td>\n",
       "      <td>472</td>\n",
       "      <td>27</td>\n",
       "      <td>594</td>\n",
       "      <td>365</td>\n",
       "      <td>1115</td>\n",
       "      <td>103</td>\n",
       "      <td>...</td>\n",
       "      <td>291</td>\n",
       "      <td>400</td>\n",
       "      <td>714</td>\n",
       "      <td>1186</td>\n",
       "      <td>262</td>\n",
       "      <td>777</td>\n",
       "      <td>62</td>\n",
       "      <td>191</td>\n",
       "      <td>217</td>\n",
       "      <td>974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>309</td>\n",
       "      <td>380</td>\n",
       "      <td>753</td>\n",
       "      <td>1718</td>\n",
       "      <td>479</td>\n",
       "      <td>34</td>\n",
       "      <td>577</td>\n",
       "      <td>388</td>\n",
       "      <td>1192</td>\n",
       "      <td>97</td>\n",
       "      <td>...</td>\n",
       "      <td>283</td>\n",
       "      <td>393</td>\n",
       "      <td>709</td>\n",
       "      <td>1172</td>\n",
       "      <td>250</td>\n",
       "      <td>773</td>\n",
       "      <td>68</td>\n",
       "      <td>185</td>\n",
       "      <td>215</td>\n",
       "      <td>982</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>324</td>\n",
       "      <td>374</td>\n",
       "      <td>750</td>\n",
       "      <td>1566</td>\n",
       "      <td>489</td>\n",
       "      <td>29</td>\n",
       "      <td>577</td>\n",
       "      <td>387</td>\n",
       "      <td>1227</td>\n",
       "      <td>87</td>\n",
       "      <td>...</td>\n",
       "      <td>303</td>\n",
       "      <td>400</td>\n",
       "      <td>706</td>\n",
       "      <td>1208</td>\n",
       "      <td>260</td>\n",
       "      <td>816</td>\n",
       "      <td>74</td>\n",
       "      <td>192</td>\n",
       "      <td>217</td>\n",
       "      <td>955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>314</td>\n",
       "      <td>341</td>\n",
       "      <td>690</td>\n",
       "      <td>1416</td>\n",
       "      <td>474</td>\n",
       "      <td>27</td>\n",
       "      <td>567</td>\n",
       "      <td>333</td>\n",
       "      <td>1188</td>\n",
       "      <td>72</td>\n",
       "      <td>...</td>\n",
       "      <td>297</td>\n",
       "      <td>375</td>\n",
       "      <td>670</td>\n",
       "      <td>1318</td>\n",
       "      <td>214</td>\n",
       "      <td>751</td>\n",
       "      <td>85</td>\n",
       "      <td>173</td>\n",
       "      <td>213</td>\n",
       "      <td>894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>265</td>\n",
       "      <td>298</td>\n",
       "      <td>543</td>\n",
       "      <td>1221</td>\n",
       "      <td>421</td>\n",
       "      <td>25</td>\n",
       "      <td>514</td>\n",
       "      <td>253</td>\n",
       "      <td>953</td>\n",
       "      <td>60</td>\n",
       "      <td>...</td>\n",
       "      <td>284</td>\n",
       "      <td>333</td>\n",
       "      <td>554</td>\n",
       "      <td>1369</td>\n",
       "      <td>193</td>\n",
       "      <td>669</td>\n",
       "      <td>121</td>\n",
       "      <td>141</td>\n",
       "      <td>175</td>\n",
       "      <td>786</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>219</td>\n",
       "      <td>245</td>\n",
       "      <td>416</td>\n",
       "      <td>1055</td>\n",
       "      <td>376</td>\n",
       "      <td>20</td>\n",
       "      <td>426</td>\n",
       "      <td>184</td>\n",
       "      <td>747</td>\n",
       "      <td>51</td>\n",
       "      <td>...</td>\n",
       "      <td>238</td>\n",
       "      <td>299</td>\n",
       "      <td>496</td>\n",
       "      <td>1266</td>\n",
       "      <td>152</td>\n",
       "      <td>526</td>\n",
       "      <td>139</td>\n",
       "      <td>118</td>\n",
       "      <td>157</td>\n",
       "      <td>674</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>170</td>\n",
       "      <td>197</td>\n",
       "      <td>333</td>\n",
       "      <td>897</td>\n",
       "      <td>326</td>\n",
       "      <td>16</td>\n",
       "      <td>367</td>\n",
       "      <td>148</td>\n",
       "      <td>667</td>\n",
       "      <td>42</td>\n",
       "      <td>...</td>\n",
       "      <td>184</td>\n",
       "      <td>253</td>\n",
       "      <td>382</td>\n",
       "      <td>1154</td>\n",
       "      <td>143</td>\n",
       "      <td>430</td>\n",
       "      <td>133</td>\n",
       "      <td>97</td>\n",
       "      <td>131</td>\n",
       "      <td>573</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>130</td>\n",
       "      <td>175</td>\n",
       "      <td>261</td>\n",
       "      <td>768</td>\n",
       "      <td>291</td>\n",
       "      <td>17</td>\n",
       "      <td>330</td>\n",
       "      <td>110</td>\n",
       "      <td>600</td>\n",
       "      <td>30</td>\n",
       "      <td>...</td>\n",
       "      <td>158</td>\n",
       "      <td>229</td>\n",
       "      <td>331</td>\n",
       "      <td>1166</td>\n",
       "      <td>112</td>\n",
       "      <td>338</td>\n",
       "      <td>120</td>\n",
       "      <td>73</td>\n",
       "      <td>103</td>\n",
       "      <td>494</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>103</td>\n",
       "      <td>148</td>\n",
       "      <td>226</td>\n",
       "      <td>699</td>\n",
       "      <td>266</td>\n",
       "      <td>15</td>\n",
       "      <td>293</td>\n",
       "      <td>92</td>\n",
       "      <td>563</td>\n",
       "      <td>34</td>\n",
       "      <td>...</td>\n",
       "      <td>110</td>\n",
       "      <td>200</td>\n",
       "      <td>269</td>\n",
       "      <td>1101</td>\n",
       "      <td>86</td>\n",
       "      <td>257</td>\n",
       "      <td>105</td>\n",
       "      <td>63</td>\n",
       "      <td>83</td>\n",
       "      <td>435</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>24 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    18641   62171   150677  108716  39011   18846   81165   155609  38055   \\\n",
       "0       74      98     260     601     251       7     198      64     489   \n",
       "1       44      52     203     449     196       7     145      39     386   \n",
       "2       33      40     153     330     158       5     102      30     343   \n",
       "3       28      31     139     304     132       4      97      28     345   \n",
       "4       31      35     148     375     143       3     113      40     405   \n",
       "5       33      55     138     435     163       4     157      67     572   \n",
       "6       75     126     163     662     223       7     304     171     863   \n",
       "7      160     264     234    1175     359      15     476     305    1004   \n",
       "8      244     341     286    1246     427      25     506     306    1096   \n",
       "9      222     354     286    1032     402      24     423     213    1056   \n",
       "10     233     317     330    1075     394      20     403     209     964   \n",
       "11     252     322     358    1201     401      26     414     216     924   \n",
       "12     291     347     392    1245     404      21     430     245     944   \n",
       "13     301     356     407    1259     414      27     474     272    1018   \n",
       "14     319     370     501    1317     429      33     526     325    1044   \n",
       "15     318     400     622    1574     472      27     594     365    1115   \n",
       "16     309     380     753    1718     479      34     577     388    1192   \n",
       "17     324     374     750    1566     489      29     577     387    1227   \n",
       "18     314     341     690    1416     474      27     567     333    1188   \n",
       "19     265     298     543    1221     421      25     514     253     953   \n",
       "20     219     245     416    1055     376      20     426     184     747   \n",
       "21     170     197     333     897     326      16     367     148     667   \n",
       "22     130     175     261     768     291      17     330     110     600   \n",
       "23     103     148     226     699     266      15     293      92     563   \n",
       "\n",
       "    78800    ...    91529   70873   56994   34124   22219   17319   72335   \\\n",
       "0       26   ...        70     195     216     962      74     218     100   \n",
       "1       14   ...        44     153     161     757      50     146     100   \n",
       "2       17   ...        32     387     133     620      35     106     121   \n",
       "3       13   ...        24     258     129     507      32      97     127   \n",
       "4       11   ...        28     424     169     400      44     108     127   \n",
       "5       25   ...        43     164     239     396      82     164     123   \n",
       "6       34   ...        92     693     364     627     159     323     120   \n",
       "7       50   ...       190    1408     598     911     239     606     118   \n",
       "8      105   ...       293    1196     656    1077     291     644     122   \n",
       "9       63   ...       290     296     619    1166     302     578     106   \n",
       "10      65   ...       273     283     595    1185     263     601     104   \n",
       "11      72   ...       258     303     595    1214     293     639      93   \n",
       "12      80   ...       270     318     632    1196     268     678      88   \n",
       "13      76   ...       279     333     674    1190     260     720      81   \n",
       "14      87   ...       291     355     703    1202     258     751      68   \n",
       "15     103   ...       291     400     714    1186     262     777      62   \n",
       "16      97   ...       283     393     709    1172     250     773      68   \n",
       "17      87   ...       303     400     706    1208     260     816      74   \n",
       "18      72   ...       297     375     670    1318     214     751      85   \n",
       "19      60   ...       284     333     554    1369     193     669     121   \n",
       "20      51   ...       238     299     496    1266     152     526     139   \n",
       "21      42   ...       184     253     382    1154     143     430     133   \n",
       "22      30   ...       158     229     331    1166     112     338     120   \n",
       "23      34   ...       110     200     269    1101      86     257     105   \n",
       "\n",
       "    41034   76391   158203  \n",
       "0       55      73     397  \n",
       "1       37      53     269  \n",
       "2       25      38     193  \n",
       "3       18      32     176  \n",
       "4       24      38     223  \n",
       "5       34      32     291  \n",
       "6       56      50     471  \n",
       "7      119     114     679  \n",
       "8      143     157     773  \n",
       "9      130     118     724  \n",
       "10     133     126     719  \n",
       "11     152     141     787  \n",
       "12     163     155     770  \n",
       "13     153     166     818  \n",
       "14     190     190     885  \n",
       "15     191     217     974  \n",
       "16     185     215     982  \n",
       "17     192     217     955  \n",
       "18     173     213     894  \n",
       "19     141     175     786  \n",
       "20     118     157     674  \n",
       "21      97     131     573  \n",
       "22      73     103     494  \n",
       "23      63      83     435  \n",
       "\n",
       "[24 rows x 30 columns]"
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s2 = y2.sample(30, axis=1)\n",
    "s2"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}