Example_Read_Data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import ImportData"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>ES3</th>\n",
       "      <th>ES5</th>\n",
       "      <th>EW-11</th>\n",
       "      <th>NCI-H1395</th>\n",
       "      <th>NCI-H1770</th>\n",
       "      <th>DMS-114</th>\n",
       "      <th>NCI-H1092</th>\n",
       "      <th>NCI-H2141</th>\n",
       "      <th>NCI-H345</th>\n",
       "      <th>NCI-H446</th>\n",
       "      <th>...</th>\n",
       "      <th>D-502MG</th>\n",
       "      <th>EW-3</th>\n",
       "      <th>EW-1</th>\n",
       "      <th>EW-18</th>\n",
       "      <th>EW-24</th>\n",
       "      <th>LAN-6</th>\n",
       "      <th>NB10</th>\n",
       "      <th>NB6</th>\n",
       "      <th>NB5</th>\n",
       "      <th>NB14</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>drug_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>176870</th>\n",
       "      <td>5.457453</td>\n",
       "      <td>6.177945</td>\n",
       "      <td>3.954488</td>\n",
       "      <td>5.429563</td>\n",
       "      <td>6.239001</td>\n",
       "      <td>6.439408</td>\n",
       "      <td>5.322913</td>\n",
       "      <td>5.481543</td>\n",
       "      <td>5.701747</td>\n",
       "      <td>5.829406</td>\n",
       "      <td>...</td>\n",
       "      <td>2.853407</td>\n",
       "      <td>4.907507</td>\n",
       "      <td>3.862042</td>\n",
       "      <td>6.281844</td>\n",
       "      <td>-0.520144</td>\n",
       "      <td>5.284207</td>\n",
       "      <td>2.464594</td>\n",
       "      <td>3.128087</td>\n",
       "      <td>2.331174</td>\n",
       "      <td>5.788405</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5284616</th>\n",
       "      <td>2.712723</td>\n",
       "      <td>2.713280</td>\n",
       "      <td>0.083814</td>\n",
       "      <td>0.926814</td>\n",
       "      <td>2.125850</td>\n",
       "      <td>-1.892659</td>\n",
       "      <td>1.661186</td>\n",
       "      <td>1.155157</td>\n",
       "      <td>-0.058457</td>\n",
       "      <td>0.278546</td>\n",
       "      <td>...</td>\n",
       "      <td>1.145465</td>\n",
       "      <td>2.363574</td>\n",
       "      <td>-6.132267</td>\n",
       "      <td>1.956273</td>\n",
       "      <td>2.170812</td>\n",
       "      <td>2.116257</td>\n",
       "      <td>0.382757</td>\n",
       "      <td>1.157696</td>\n",
       "      <td>5.900698</td>\n",
       "      <td>1.412155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5329102</th>\n",
       "      <td>3.624351</td>\n",
       "      <td>3.208216</td>\n",
       "      <td>3.540163</td>\n",
       "      <td>6.187608</td>\n",
       "      <td>2.676693</td>\n",
       "      <td>4.345598</td>\n",
       "      <td>5.835351</td>\n",
       "      <td>3.639802</td>\n",
       "      <td>5.687395</td>\n",
       "      <td>3.313991</td>\n",
       "      <td>...</td>\n",
       "      <td>6.892013</td>\n",
       "      <td>1.861296</td>\n",
       "      <td>1.543108</td>\n",
       "      <td>7.450205</td>\n",
       "      <td>6.305561</td>\n",
       "      <td>2.656457</td>\n",
       "      <td>7.379108</td>\n",
       "      <td>4.617955</td>\n",
       "      <td>4.390978</td>\n",
       "      <td>2.391296</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10461815</th>\n",
       "      <td>5.741999</td>\n",
       "      <td>2.671871</td>\n",
       "      <td>5.191223</td>\n",
       "      <td>2.379769</td>\n",
       "      <td>4.042987</td>\n",
       "      <td>5.904581</td>\n",
       "      <td>5.305583</td>\n",
       "      <td>4.700236</td>\n",
       "      <td>6.133696</td>\n",
       "      <td>6.221338</td>\n",
       "      <td>...</td>\n",
       "      <td>4.200647</td>\n",
       "      <td>4.961017</td>\n",
       "      <td>6.038975</td>\n",
       "      <td>3.709424</td>\n",
       "      <td>5.878941</td>\n",
       "      <td>5.791552</td>\n",
       "      <td>6.379263</td>\n",
       "      <td>5.592871</td>\n",
       "      <td>6.070821</td>\n",
       "      <td>2.972592</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462382</th>\n",
       "      <td>1.465161</td>\n",
       "      <td>1.482183</td>\n",
       "      <td>2.443964</td>\n",
       "      <td>4.074435</td>\n",
       "      <td>5.051646</td>\n",
       "      <td>0.368378</td>\n",
       "      <td>-0.945622</td>\n",
       "      <td>0.514722</td>\n",
       "      <td>3.047581</td>\n",
       "      <td>4.602755</td>\n",
       "      <td>...</td>\n",
       "      <td>0.514084</td>\n",
       "      <td>4.552909</td>\n",
       "      <td>-1.558431</td>\n",
       "      <td>0.704762</td>\n",
       "      <td>3.476532</td>\n",
       "      <td>-1.161549</td>\n",
       "      <td>2.078887</td>\n",
       "      <td>3.432384</td>\n",
       "      <td>4.253437</td>\n",
       "      <td>4.990988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36314</th>\n",
       "      <td>2.230729</td>\n",
       "      <td>2.062629</td>\n",
       "      <td>2.456970</td>\n",
       "      <td>1.610128</td>\n",
       "      <td>2.911541</td>\n",
       "      <td>-3.688091</td>\n",
       "      <td>0.267879</td>\n",
       "      <td>-2.513281</td>\n",
       "      <td>-1.776183</td>\n",
       "      <td>-3.857458</td>\n",
       "      <td>...</td>\n",
       "      <td>1.053631</td>\n",
       "      <td>-2.209074</td>\n",
       "      <td>-5.595654</td>\n",
       "      <td>1.951147</td>\n",
       "      <td>-2.735986</td>\n",
       "      <td>1.266350</td>\n",
       "      <td>3.450273</td>\n",
       "      <td>-1.856457</td>\n",
       "      <td>-1.795945</td>\n",
       "      <td>2.055904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>442972</th>\n",
       "      <td>6.262880</td>\n",
       "      <td>7.901639</td>\n",
       "      <td>6.841940</td>\n",
       "      <td>5.192934</td>\n",
       "      <td>4.689366</td>\n",
       "      <td>6.962380</td>\n",
       "      <td>8.059654</td>\n",
       "      <td>7.905122</td>\n",
       "      <td>7.664581</td>\n",
       "      <td>6.864623</td>\n",
       "      <td>...</td>\n",
       "      <td>3.944047</td>\n",
       "      <td>6.229268</td>\n",
       "      <td>6.147171</td>\n",
       "      <td>6.323129</td>\n",
       "      <td>7.327341</td>\n",
       "      <td>7.927056</td>\n",
       "      <td>6.089575</td>\n",
       "      <td>7.302904</td>\n",
       "      <td>8.251158</td>\n",
       "      <td>7.289493</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11676786</th>\n",
       "      <td>3.840777</td>\n",
       "      <td>2.634967</td>\n",
       "      <td>1.836697</td>\n",
       "      <td>4.547153</td>\n",
       "      <td>5.440164</td>\n",
       "      <td>3.831238</td>\n",
       "      <td>3.769191</td>\n",
       "      <td>5.354976</td>\n",
       "      <td>7.074614</td>\n",
       "      <td>6.781506</td>\n",
       "      <td>...</td>\n",
       "      <td>0.815994</td>\n",
       "      <td>1.769899</td>\n",
       "      <td>4.954149</td>\n",
       "      <td>2.502414</td>\n",
       "      <td>0.997667</td>\n",
       "      <td>-0.382198</td>\n",
       "      <td>3.782938</td>\n",
       "      <td>4.817854</td>\n",
       "      <td>0.669910</td>\n",
       "      <td>-0.706610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216239</th>\n",
       "      <td>2.934077</td>\n",
       "      <td>4.127530</td>\n",
       "      <td>6.831892</td>\n",
       "      <td>3.838928</td>\n",
       "      <td>5.437241</td>\n",
       "      <td>2.355562</td>\n",
       "      <td>5.406161</td>\n",
       "      <td>2.784330</td>\n",
       "      <td>5.354602</td>\n",
       "      <td>6.159637</td>\n",
       "      <td>...</td>\n",
       "      <td>4.545320</td>\n",
       "      <td>3.053480</td>\n",
       "      <td>5.073228</td>\n",
       "      <td>2.476909</td>\n",
       "      <td>2.782917</td>\n",
       "      <td>4.221937</td>\n",
       "      <td>3.926651</td>\n",
       "      <td>2.278322</td>\n",
       "      <td>5.885494</td>\n",
       "      <td>2.155399</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5494449</th>\n",
       "      <td>3.602096</td>\n",
       "      <td>5.346999</td>\n",
       "      <td>5.729100</td>\n",
       "      <td>5.477718</td>\n",
       "      <td>2.186349</td>\n",
       "      <td>4.868544</td>\n",
       "      <td>4.197522</td>\n",
       "      <td>4.017509</td>\n",
       "      <td>3.880903</td>\n",
       "      <td>3.942056</td>\n",
       "      <td>...</td>\n",
       "      <td>5.228564</td>\n",
       "      <td>2.620323</td>\n",
       "      <td>0.170270</td>\n",
       "      <td>6.462531</td>\n",
       "      <td>5.003229</td>\n",
       "      <td>4.840668</td>\n",
       "      <td>5.500566</td>\n",
       "      <td>-0.258076</td>\n",
       "      <td>0.496093</td>\n",
       "      <td>5.372444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5291</th>\n",
       "      <td>5.337817</td>\n",
       "      <td>4.215039</td>\n",
       "      <td>5.822416</td>\n",
       "      <td>3.947071</td>\n",
       "      <td>1.717865</td>\n",
       "      <td>6.237985</td>\n",
       "      <td>4.431051</td>\n",
       "      <td>5.288382</td>\n",
       "      <td>6.018588</td>\n",
       "      <td>5.891683</td>\n",
       "      <td>...</td>\n",
       "      <td>4.912112</td>\n",
       "      <td>5.310111</td>\n",
       "      <td>3.494853</td>\n",
       "      <td>3.880315</td>\n",
       "      <td>5.955108</td>\n",
       "      <td>6.285480</td>\n",
       "      <td>3.276010</td>\n",
       "      <td>4.900965</td>\n",
       "      <td>5.767412</td>\n",
       "      <td>4.594319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16038120</th>\n",
       "      <td>4.674520</td>\n",
       "      <td>3.405319</td>\n",
       "      <td>2.267368</td>\n",
       "      <td>1.036778</td>\n",
       "      <td>3.346738</td>\n",
       "      <td>0.961355</td>\n",
       "      <td>2.081607</td>\n",
       "      <td>1.637575</td>\n",
       "      <td>2.443206</td>\n",
       "      <td>4.727257</td>\n",
       "      <td>...</td>\n",
       "      <td>4.092738</td>\n",
       "      <td>1.560768</td>\n",
       "      <td>-2.277299</td>\n",
       "      <td>3.252065</td>\n",
       "      <td>1.298649</td>\n",
       "      <td>-1.746236</td>\n",
       "      <td>0.453570</td>\n",
       "      <td>2.021414</td>\n",
       "      <td>0.460432</td>\n",
       "      <td>-0.824944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11496366</th>\n",
       "      <td>5.924602</td>\n",
       "      <td>6.253164</td>\n",
       "      <td>4.698552</td>\n",
       "      <td>4.675106</td>\n",
       "      <td>5.708927</td>\n",
       "      <td>5.353218</td>\n",
       "      <td>5.444895</td>\n",
       "      <td>4.611212</td>\n",
       "      <td>4.717657</td>\n",
       "      <td>5.920815</td>\n",
       "      <td>...</td>\n",
       "      <td>4.708966</td>\n",
       "      <td>5.497982</td>\n",
       "      <td>2.345889</td>\n",
       "      <td>5.388803</td>\n",
       "      <td>5.383014</td>\n",
       "      <td>2.931500</td>\n",
       "      <td>5.909705</td>\n",
       "      <td>5.368972</td>\n",
       "      <td>3.551155</td>\n",
       "      <td>1.575931</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10302451</th>\n",
       "      <td>2.860227</td>\n",
       "      <td>6.389974</td>\n",
       "      <td>5.413987</td>\n",
       "      <td>4.641152</td>\n",
       "      <td>5.920998</td>\n",
       "      <td>5.477196</td>\n",
       "      <td>4.712901</td>\n",
       "      <td>4.015363</td>\n",
       "      <td>6.042795</td>\n",
       "      <td>5.152341</td>\n",
       "      <td>...</td>\n",
       "      <td>4.641850</td>\n",
       "      <td>5.207449</td>\n",
       "      <td>5.159156</td>\n",
       "      <td>5.447730</td>\n",
       "      <td>-0.466917</td>\n",
       "      <td>4.973744</td>\n",
       "      <td>2.919153</td>\n",
       "      <td>3.313749</td>\n",
       "      <td>1.485833</td>\n",
       "      <td>4.082745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76044</th>\n",
       "      <td>5.345504</td>\n",
       "      <td>6.007588</td>\n",
       "      <td>6.035437</td>\n",
       "      <td>2.306003</td>\n",
       "      <td>2.754991</td>\n",
       "      <td>1.181406</td>\n",
       "      <td>3.022778</td>\n",
       "      <td>1.471682</td>\n",
       "      <td>2.071927</td>\n",
       "      <td>0.951191</td>\n",
       "      <td>...</td>\n",
       "      <td>5.589781</td>\n",
       "      <td>1.592400</td>\n",
       "      <td>0.413721</td>\n",
       "      <td>7.218919</td>\n",
       "      <td>3.154823</td>\n",
       "      <td>1.305098</td>\n",
       "      <td>3.870451</td>\n",
       "      <td>1.364751</td>\n",
       "      <td>2.859267</td>\n",
       "      <td>4.064081</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16760646</th>\n",
       "      <td>2.750826</td>\n",
       "      <td>2.494072</td>\n",
       "      <td>5.852555</td>\n",
       "      <td>3.579228</td>\n",
       "      <td>3.399192</td>\n",
       "      <td>5.536588</td>\n",
       "      <td>0.459749</td>\n",
       "      <td>2.973586</td>\n",
       "      <td>5.507376</td>\n",
       "      <td>3.994693</td>\n",
       "      <td>...</td>\n",
       "      <td>5.002047</td>\n",
       "      <td>2.626498</td>\n",
       "      <td>1.433309</td>\n",
       "      <td>6.511248</td>\n",
       "      <td>3.723822</td>\n",
       "      <td>1.350476</td>\n",
       "      <td>4.939727</td>\n",
       "      <td>4.905872</td>\n",
       "      <td>2.108060</td>\n",
       "      <td>2.467049</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3062316</th>\n",
       "      <td>4.078735</td>\n",
       "      <td>5.701991</td>\n",
       "      <td>4.777730</td>\n",
       "      <td>3.738057</td>\n",
       "      <td>4.339664</td>\n",
       "      <td>4.295439</td>\n",
       "      <td>4.898917</td>\n",
       "      <td>3.209851</td>\n",
       "      <td>4.816569</td>\n",
       "      <td>-0.465847</td>\n",
       "      <td>...</td>\n",
       "      <td>0.210066</td>\n",
       "      <td>4.517188</td>\n",
       "      <td>4.995126</td>\n",
       "      <td>5.801361</td>\n",
       "      <td>-0.246343</td>\n",
       "      <td>5.184950</td>\n",
       "      <td>5.352914</td>\n",
       "      <td>2.294814</td>\n",
       "      <td>0.335239</td>\n",
       "      <td>5.983951</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5311510</th>\n",
       "      <td>2.858726</td>\n",
       "      <td>5.833998</td>\n",
       "      <td>4.818600</td>\n",
       "      <td>5.292979</td>\n",
       "      <td>5.736564</td>\n",
       "      <td>5.548083</td>\n",
       "      <td>3.929057</td>\n",
       "      <td>5.120549</td>\n",
       "      <td>4.691522</td>\n",
       "      <td>5.217490</td>\n",
       "      <td>...</td>\n",
       "      <td>4.873181</td>\n",
       "      <td>5.192398</td>\n",
       "      <td>4.871301</td>\n",
       "      <td>5.939899</td>\n",
       "      <td>5.321265</td>\n",
       "      <td>5.466854</td>\n",
       "      <td>5.145785</td>\n",
       "      <td>4.016846</td>\n",
       "      <td>5.854458</td>\n",
       "      <td>5.980599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>644215</th>\n",
       "      <td>-0.045722</td>\n",
       "      <td>0.628669</td>\n",
       "      <td>1.791496</td>\n",
       "      <td>-1.290847</td>\n",
       "      <td>-1.187067</td>\n",
       "      <td>-0.666328</td>\n",
       "      <td>-2.222384</td>\n",
       "      <td>-2.283975</td>\n",
       "      <td>0.772660</td>\n",
       "      <td>0.789477</td>\n",
       "      <td>...</td>\n",
       "      <td>0.618983</td>\n",
       "      <td>-1.343815</td>\n",
       "      <td>-3.083062</td>\n",
       "      <td>2.704978</td>\n",
       "      <td>1.027847</td>\n",
       "      <td>-1.907018</td>\n",
       "      <td>0.111594</td>\n",
       "      <td>0.843692</td>\n",
       "      <td>2.203509</td>\n",
       "      <td>-0.413826</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24825971</th>\n",
       "      <td>2.556418</td>\n",
       "      <td>6.422752</td>\n",
       "      <td>5.224450</td>\n",
       "      <td>5.089995</td>\n",
       "      <td>1.626116</td>\n",
       "      <td>4.932276</td>\n",
       "      <td>6.232089</td>\n",
       "      <td>3.888698</td>\n",
       "      <td>6.589912</td>\n",
       "      <td>6.437845</td>\n",
       "      <td>...</td>\n",
       "      <td>5.126632</td>\n",
       "      <td>6.324584</td>\n",
       "      <td>2.740650</td>\n",
       "      <td>6.568490</td>\n",
       "      <td>4.277519</td>\n",
       "      <td>5.704759</td>\n",
       "      <td>6.924701</td>\n",
       "      <td>6.351617</td>\n",
       "      <td>6.933278</td>\n",
       "      <td>5.716638</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9549184</th>\n",
       "      <td>6.102112</td>\n",
       "      <td>6.967883</td>\n",
       "      <td>5.068808</td>\n",
       "      <td>2.590619</td>\n",
       "      <td>5.335362</td>\n",
       "      <td>6.140627</td>\n",
       "      <td>6.029098</td>\n",
       "      <td>3.488897</td>\n",
       "      <td>6.214220</td>\n",
       "      <td>6.786771</td>\n",
       "      <td>...</td>\n",
       "      <td>5.259058</td>\n",
       "      <td>6.803529</td>\n",
       "      <td>5.981820</td>\n",
       "      <td>5.690450</td>\n",
       "      <td>3.270553</td>\n",
       "      <td>7.831552</td>\n",
       "      <td>7.337717</td>\n",
       "      <td>5.340784</td>\n",
       "      <td>2.486816</td>\n",
       "      <td>6.786110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11844351</th>\n",
       "      <td>5.143049</td>\n",
       "      <td>6.383421</td>\n",
       "      <td>6.516894</td>\n",
       "      <td>4.836352</td>\n",
       "      <td>6.582229</td>\n",
       "      <td>1.026119</td>\n",
       "      <td>5.315626</td>\n",
       "      <td>5.783885</td>\n",
       "      <td>4.942131</td>\n",
       "      <td>2.649070</td>\n",
       "      <td>...</td>\n",
       "      <td>4.799909</td>\n",
       "      <td>4.231410</td>\n",
       "      <td>5.220739</td>\n",
       "      <td>7.307820</td>\n",
       "      <td>5.812862</td>\n",
       "      <td>5.057459</td>\n",
       "      <td>6.880506</td>\n",
       "      <td>0.528852</td>\n",
       "      <td>5.646194</td>\n",
       "      <td>6.188467</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49821040</th>\n",
       "      <td>6.076867</td>\n",
       "      <td>7.726779</td>\n",
       "      <td>7.382650</td>\n",
       "      <td>6.755815</td>\n",
       "      <td>7.805116</td>\n",
       "      <td>6.024787</td>\n",
       "      <td>6.352278</td>\n",
       "      <td>5.542833</td>\n",
       "      <td>7.400490</td>\n",
       "      <td>6.656297</td>\n",
       "      <td>...</td>\n",
       "      <td>6.148649</td>\n",
       "      <td>4.956919</td>\n",
       "      <td>5.881320</td>\n",
       "      <td>7.383467</td>\n",
       "      <td>1.523695</td>\n",
       "      <td>6.700624</td>\n",
       "      <td>7.745282</td>\n",
       "      <td>4.380176</td>\n",
       "      <td>5.176501</td>\n",
       "      <td>7.633546</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11364421</th>\n",
       "      <td>2.638894</td>\n",
       "      <td>3.080401</td>\n",
       "      <td>4.019169</td>\n",
       "      <td>0.101385</td>\n",
       "      <td>1.897476</td>\n",
       "      <td>-2.586503</td>\n",
       "      <td>0.566345</td>\n",
       "      <td>-1.660166</td>\n",
       "      <td>-1.435280</td>\n",
       "      <td>-2.357924</td>\n",
       "      <td>...</td>\n",
       "      <td>2.077390</td>\n",
       "      <td>-2.048497</td>\n",
       "      <td>-2.840946</td>\n",
       "      <td>4.247597</td>\n",
       "      <td>-0.083365</td>\n",
       "      <td>-1.152885</td>\n",
       "      <td>3.410138</td>\n",
       "      <td>-1.683838</td>\n",
       "      <td>-1.866773</td>\n",
       "      <td>1.786973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10390396</th>\n",
       "      <td>4.348722</td>\n",
       "      <td>6.146188</td>\n",
       "      <td>6.313170</td>\n",
       "      <td>6.747982</td>\n",
       "      <td>2.453080</td>\n",
       "      <td>1.719837</td>\n",
       "      <td>4.113632</td>\n",
       "      <td>3.300396</td>\n",
       "      <td>3.763715</td>\n",
       "      <td>7.265668</td>\n",
       "      <td>...</td>\n",
       "      <td>4.321355</td>\n",
       "      <td>1.560359</td>\n",
       "      <td>-1.751832</td>\n",
       "      <td>4.536535</td>\n",
       "      <td>2.342079</td>\n",
       "      <td>-1.761946</td>\n",
       "      <td>3.282415</td>\n",
       "      <td>6.291796</td>\n",
       "      <td>0.104780</td>\n",
       "      <td>6.847403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20635522</th>\n",
       "      <td>2.186483</td>\n",
       "      <td>3.882340</td>\n",
       "      <td>2.389910</td>\n",
       "      <td>5.855510</td>\n",
       "      <td>4.267952</td>\n",
       "      <td>3.480206</td>\n",
       "      <td>3.247356</td>\n",
       "      <td>3.806186</td>\n",
       "      <td>7.862416</td>\n",
       "      <td>8.026635</td>\n",
       "      <td>...</td>\n",
       "      <td>6.646773</td>\n",
       "      <td>2.148520</td>\n",
       "      <td>1.135812</td>\n",
       "      <td>6.607817</td>\n",
       "      <td>6.846458</td>\n",
       "      <td>1.986520</td>\n",
       "      <td>7.319852</td>\n",
       "      <td>4.871396</td>\n",
       "      <td>2.807171</td>\n",
       "      <td>4.142461</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4993</th>\n",
       "      <td>5.166096</td>\n",
       "      <td>7.883980</td>\n",
       "      <td>7.859141</td>\n",
       "      <td>5.475670</td>\n",
       "      <td>7.447522</td>\n",
       "      <td>4.070601</td>\n",
       "      <td>6.550599</td>\n",
       "      <td>7.367777</td>\n",
       "      <td>6.987707</td>\n",
       "      <td>9.440488</td>\n",
       "      <td>...</td>\n",
       "      <td>6.174442</td>\n",
       "      <td>5.502698</td>\n",
       "      <td>0.317060</td>\n",
       "      <td>5.806752</td>\n",
       "      <td>3.993994</td>\n",
       "      <td>5.857310</td>\n",
       "      <td>7.470861</td>\n",
       "      <td>7.233896</td>\n",
       "      <td>7.139622</td>\n",
       "      <td>3.052458</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49836027</th>\n",
       "      <td>3.899734</td>\n",
       "      <td>2.253695</td>\n",
       "      <td>3.189317</td>\n",
       "      <td>2.507146</td>\n",
       "      <td>0.284641</td>\n",
       "      <td>-1.427422</td>\n",
       "      <td>1.083139</td>\n",
       "      <td>0.176466</td>\n",
       "      <td>0.962813</td>\n",
       "      <td>-1.778365</td>\n",
       "      <td>...</td>\n",
       "      <td>3.782435</td>\n",
       "      <td>-1.527016</td>\n",
       "      <td>-4.894122</td>\n",
       "      <td>5.249339</td>\n",
       "      <td>0.435797</td>\n",
       "      <td>1.707899</td>\n",
       "      <td>0.792442</td>\n",
       "      <td>-2.942993</td>\n",
       "      <td>-2.340776</td>\n",
       "      <td>5.157241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10172943</th>\n",
       "      <td>1.244741</td>\n",
       "      <td>2.081055</td>\n",
       "      <td>5.327523</td>\n",
       "      <td>4.329033</td>\n",
       "      <td>5.358756</td>\n",
       "      <td>-0.016805</td>\n",
       "      <td>-0.063587</td>\n",
       "      <td>-0.616792</td>\n",
       "      <td>-0.287250</td>\n",
       "      <td>-0.929038</td>\n",
       "      <td>...</td>\n",
       "      <td>1.187738</td>\n",
       "      <td>0.107468</td>\n",
       "      <td>-1.507889</td>\n",
       "      <td>5.326627</td>\n",
       "      <td>-0.177820</td>\n",
       "      <td>-0.121295</td>\n",
       "      <td>1.853053</td>\n",
       "      <td>-0.734500</td>\n",
       "      <td>-0.407789</td>\n",
       "      <td>0.677418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15983966</th>\n",
       "      <td>3.021673</td>\n",
       "      <td>4.944419</td>\n",
       "      <td>4.129560</td>\n",
       "      <td>0.053222</td>\n",
       "      <td>-0.816280</td>\n",
       "      <td>-2.106796</td>\n",
       "      <td>0.615709</td>\n",
       "      <td>-1.841517</td>\n",
       "      <td>-1.097197</td>\n",
       "      <td>-4.426513</td>\n",
       "      <td>...</td>\n",
       "      <td>2.326680</td>\n",
       "      <td>-2.713409</td>\n",
       "      <td>-4.087139</td>\n",
       "      <td>4.172566</td>\n",
       "      <td>0.177178</td>\n",
       "      <td>-1.975958</td>\n",
       "      <td>1.391426</td>\n",
       "      <td>-1.953810</td>\n",
       "      <td>-2.450524</td>\n",
       "      <td>2.538847</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11960529</th>\n",
       "      <td>5.683549</td>\n",
       "      <td>4.305218</td>\n",
       "      <td>5.348367</td>\n",
       "      <td>5.416088</td>\n",
       "      <td>6.224812</td>\n",
       "      <td>6.010940</td>\n",
       "      <td>6.168458</td>\n",
       "      <td>6.606545</td>\n",
       "      <td>6.439538</td>\n",
       "      <td>6.490016</td>\n",
       "      <td>...</td>\n",
       "      <td>5.901723</td>\n",
       "      <td>3.692212</td>\n",
       "      <td>5.304538</td>\n",
       "      <td>4.981526</td>\n",
       "      <td>5.266191</td>\n",
       "      <td>5.801910</td>\n",
       "      <td>5.357161</td>\n",
       "      <td>6.292128</td>\n",
       "      <td>5.622409</td>\n",
       "      <td>6.196443</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5328940</th>\n",
       "      <td>3.878526</td>\n",
       "      <td>0.624584</td>\n",
       "      <td>1.145104</td>\n",
       "      <td>3.104169</td>\n",
       "      <td>5.495732</td>\n",
       "      <td>5.574144</td>\n",
       "      <td>5.787172</td>\n",
       "      <td>5.007210</td>\n",
       "      <td>5.576062</td>\n",
       "      <td>5.554359</td>\n",
       "      <td>...</td>\n",
       "      <td>1.999414</td>\n",
       "      <td>1.961255</td>\n",
       "      <td>3.910189</td>\n",
       "      <td>2.255547</td>\n",
       "      <td>2.426689</td>\n",
       "      <td>5.609573</td>\n",
       "      <td>5.279878</td>\n",
       "      <td>3.445624</td>\n",
       "      <td>4.663958</td>\n",
       "      <td>2.859645</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216326</th>\n",
       "      <td>3.122202</td>\n",
       "      <td>5.673848</td>\n",
       "      <td>4.459377</td>\n",
       "      <td>5.795685</td>\n",
       "      <td>5.982549</td>\n",
       "      <td>6.006429</td>\n",
       "      <td>6.433115</td>\n",
       "      <td>6.541348</td>\n",
       "      <td>6.155639</td>\n",
       "      <td>6.360811</td>\n",
       "      <td>...</td>\n",
       "      <td>4.963808</td>\n",
       "      <td>5.927353</td>\n",
       "      <td>5.997094</td>\n",
       "      <td>3.869471</td>\n",
       "      <td>5.216401</td>\n",
       "      <td>6.135829</td>\n",
       "      <td>5.621627</td>\n",
       "      <td>4.189473</td>\n",
       "      <td>6.441622</td>\n",
       "      <td>6.250331</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6450551</th>\n",
       "      <td>2.922531</td>\n",
       "      <td>0.159125</td>\n",
       "      <td>1.289293</td>\n",
       "      <td>4.282659</td>\n",
       "      <td>4.280930</td>\n",
       "      <td>0.979621</td>\n",
       "      <td>5.584058</td>\n",
       "      <td>4.985454</td>\n",
       "      <td>5.250250</td>\n",
       "      <td>1.351358</td>\n",
       "      <td>...</td>\n",
       "      <td>1.838733</td>\n",
       "      <td>3.715895</td>\n",
       "      <td>1.510753</td>\n",
       "      <td>1.641951</td>\n",
       "      <td>3.578717</td>\n",
       "      <td>3.636486</td>\n",
       "      <td>0.281839</td>\n",
       "      <td>3.831052</td>\n",
       "      <td>4.943348</td>\n",
       "      <td>-0.302999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126565</th>\n",
       "      <td>-2.082146</td>\n",
       "      <td>-4.105555</td>\n",
       "      <td>-2.022476</td>\n",
       "      <td>-1.268014</td>\n",
       "      <td>0.423532</td>\n",
       "      <td>0.417860</td>\n",
       "      <td>1.776061</td>\n",
       "      <td>1.426202</td>\n",
       "      <td>2.369733</td>\n",
       "      <td>-0.328386</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.888498</td>\n",
       "      <td>-0.084830</td>\n",
       "      <td>0.075484</td>\n",
       "      <td>-0.820722</td>\n",
       "      <td>1.563616</td>\n",
       "      <td>0.896512</td>\n",
       "      <td>-1.084717</td>\n",
       "      <td>-0.066319</td>\n",
       "      <td>-0.753346</td>\n",
       "      <td>-4.939001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6505803</th>\n",
       "      <td>-0.525536</td>\n",
       "      <td>1.633988</td>\n",
       "      <td>3.968306</td>\n",
       "      <td>-1.677600</td>\n",
       "      <td>-0.639987</td>\n",
       "      <td>1.514447</td>\n",
       "      <td>4.039580</td>\n",
       "      <td>3.368856</td>\n",
       "      <td>3.636540</td>\n",
       "      <td>4.463196</td>\n",
       "      <td>...</td>\n",
       "      <td>3.127904</td>\n",
       "      <td>2.107907</td>\n",
       "      <td>3.772227</td>\n",
       "      <td>3.146968</td>\n",
       "      <td>3.852400</td>\n",
       "      <td>2.737052</td>\n",
       "      <td>0.125259</td>\n",
       "      <td>3.474684</td>\n",
       "      <td>1.254731</td>\n",
       "      <td>2.780563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10341154</th>\n",
       "      <td>4.839934</td>\n",
       "      <td>3.589065</td>\n",
       "      <td>3.007883</td>\n",
       "      <td>4.406614</td>\n",
       "      <td>4.642372</td>\n",
       "      <td>5.482972</td>\n",
       "      <td>3.875990</td>\n",
       "      <td>5.629601</td>\n",
       "      <td>5.489417</td>\n",
       "      <td>4.740784</td>\n",
       "      <td>...</td>\n",
       "      <td>4.677631</td>\n",
       "      <td>4.316078</td>\n",
       "      <td>5.436961</td>\n",
       "      <td>2.602177</td>\n",
       "      <td>4.873713</td>\n",
       "      <td>5.470376</td>\n",
       "      <td>4.943404</td>\n",
       "      <td>4.329608</td>\n",
       "      <td>4.022665</td>\n",
       "      <td>5.355499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11667893</th>\n",
       "      <td>3.225935</td>\n",
       "      <td>3.423937</td>\n",
       "      <td>4.540733</td>\n",
       "      <td>5.699898</td>\n",
       "      <td>5.241725</td>\n",
       "      <td>3.983784</td>\n",
       "      <td>5.498988</td>\n",
       "      <td>5.052387</td>\n",
       "      <td>4.845417</td>\n",
       "      <td>4.755961</td>\n",
       "      <td>...</td>\n",
       "      <td>3.819904</td>\n",
       "      <td>3.943630</td>\n",
       "      <td>2.859866</td>\n",
       "      <td>4.904784</td>\n",
       "      <td>4.387342</td>\n",
       "      <td>4.973785</td>\n",
       "      <td>0.854624</td>\n",
       "      <td>5.300406</td>\n",
       "      <td>4.734032</td>\n",
       "      <td>2.638917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5278396</th>\n",
       "      <td>4.047392</td>\n",
       "      <td>4.495346</td>\n",
       "      <td>6.917073</td>\n",
       "      <td>4.010761</td>\n",
       "      <td>6.930248</td>\n",
       "      <td>6.022198</td>\n",
       "      <td>7.141449</td>\n",
       "      <td>6.677504</td>\n",
       "      <td>7.266747</td>\n",
       "      <td>6.602751</td>\n",
       "      <td>...</td>\n",
       "      <td>5.558615</td>\n",
       "      <td>7.169269</td>\n",
       "      <td>5.499052</td>\n",
       "      <td>3.815202</td>\n",
       "      <td>5.406605</td>\n",
       "      <td>7.036660</td>\n",
       "      <td>6.843498</td>\n",
       "      <td>6.558648</td>\n",
       "      <td>5.010736</td>\n",
       "      <td>3.490883</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10184653</th>\n",
       "      <td>2.828106</td>\n",
       "      <td>1.576343</td>\n",
       "      <td>2.216649</td>\n",
       "      <td>3.028667</td>\n",
       "      <td>3.896277</td>\n",
       "      <td>3.709598</td>\n",
       "      <td>3.725827</td>\n",
       "      <td>3.992132</td>\n",
       "      <td>3.918417</td>\n",
       "      <td>4.285926</td>\n",
       "      <td>...</td>\n",
       "      <td>2.115390</td>\n",
       "      <td>3.394566</td>\n",
       "      <td>3.827965</td>\n",
       "      <td>2.806362</td>\n",
       "      <td>3.164771</td>\n",
       "      <td>3.689160</td>\n",
       "      <td>3.101761</td>\n",
       "      <td>4.263802</td>\n",
       "      <td>0.345838</td>\n",
       "      <td>4.158341</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24776445</th>\n",
       "      <td>6.176463</td>\n",
       "      <td>4.529101</td>\n",
       "      <td>3.126855</td>\n",
       "      <td>6.820092</td>\n",
       "      <td>6.926870</td>\n",
       "      <td>6.738021</td>\n",
       "      <td>6.567106</td>\n",
       "      <td>7.151018</td>\n",
       "      <td>7.227604</td>\n",
       "      <td>5.036699</td>\n",
       "      <td>...</td>\n",
       "      <td>6.821872</td>\n",
       "      <td>5.235327</td>\n",
       "      <td>6.181789</td>\n",
       "      <td>3.310252</td>\n",
       "      <td>5.452315</td>\n",
       "      <td>7.098196</td>\n",
       "      <td>7.073850</td>\n",
       "      <td>7.196784</td>\n",
       "      <td>6.032335</td>\n",
       "      <td>7.045438</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24180719</th>\n",
       "      <td>4.863117</td>\n",
       "      <td>1.816328</td>\n",
       "      <td>5.764284</td>\n",
       "      <td>5.982259</td>\n",
       "      <td>6.411098</td>\n",
       "      <td>6.380521</td>\n",
       "      <td>6.625925</td>\n",
       "      <td>6.062776</td>\n",
       "      <td>6.109542</td>\n",
       "      <td>5.885714</td>\n",
       "      <td>...</td>\n",
       "      <td>3.891159</td>\n",
       "      <td>6.500161</td>\n",
       "      <td>5.506808</td>\n",
       "      <td>4.121076</td>\n",
       "      <td>5.807522</td>\n",
       "      <td>7.152838</td>\n",
       "      <td>6.922368</td>\n",
       "      <td>5.263797</td>\n",
       "      <td>6.429824</td>\n",
       "      <td>6.391518</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10077147</th>\n",
       "      <td>0.964262</td>\n",
       "      <td>0.176920</td>\n",
       "      <td>2.347783</td>\n",
       "      <td>2.297945</td>\n",
       "      <td>2.159361</td>\n",
       "      <td>2.521826</td>\n",
       "      <td>3.285498</td>\n",
       "      <td>2.920491</td>\n",
       "      <td>6.175110</td>\n",
       "      <td>2.256334</td>\n",
       "      <td>...</td>\n",
       "      <td>1.835894</td>\n",
       "      <td>2.817968</td>\n",
       "      <td>3.082500</td>\n",
       "      <td>1.201367</td>\n",
       "      <td>4.632461</td>\n",
       "      <td>6.288675</td>\n",
       "      <td>1.441665</td>\n",
       "      <td>1.006598</td>\n",
       "      <td>1.077441</td>\n",
       "      <td>0.250380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11327430</th>\n",
       "      <td>4.075888</td>\n",
       "      <td>2.575329</td>\n",
       "      <td>4.122000</td>\n",
       "      <td>3.528709</td>\n",
       "      <td>5.440606</td>\n",
       "      <td>2.729755</td>\n",
       "      <td>5.514731</td>\n",
       "      <td>4.961287</td>\n",
       "      <td>5.544484</td>\n",
       "      <td>2.608854</td>\n",
       "      <td>...</td>\n",
       "      <td>4.126876</td>\n",
       "      <td>5.382167</td>\n",
       "      <td>3.524364</td>\n",
       "      <td>3.232616</td>\n",
       "      <td>4.577973</td>\n",
       "      <td>3.046405</td>\n",
       "      <td>3.267055</td>\n",
       "      <td>5.406361</td>\n",
       "      <td>2.375453</td>\n",
       "      <td>1.695502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156422</th>\n",
       "      <td>6.270331</td>\n",
       "      <td>5.064372</td>\n",
       "      <td>5.914983</td>\n",
       "      <td>4.696624</td>\n",
       "      <td>6.741191</td>\n",
       "      <td>5.388570</td>\n",
       "      <td>6.435830</td>\n",
       "      <td>5.645205</td>\n",
       "      <td>6.748418</td>\n",
       "      <td>6.087085</td>\n",
       "      <td>...</td>\n",
       "      <td>4.792388</td>\n",
       "      <td>6.227857</td>\n",
       "      <td>6.291758</td>\n",
       "      <td>7.050382</td>\n",
       "      <td>6.554919</td>\n",
       "      <td>6.123599</td>\n",
       "      <td>6.691200</td>\n",
       "      <td>6.579294</td>\n",
       "      <td>7.277708</td>\n",
       "      <td>4.077675</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11624601</th>\n",
       "      <td>3.642703</td>\n",
       "      <td>6.392269</td>\n",
       "      <td>6.234337</td>\n",
       "      <td>7.029000</td>\n",
       "      <td>6.744473</td>\n",
       "      <td>6.245762</td>\n",
       "      <td>7.267811</td>\n",
       "      <td>6.900567</td>\n",
       "      <td>6.832558</td>\n",
       "      <td>7.188936</td>\n",
       "      <td>...</td>\n",
       "      <td>5.849862</td>\n",
       "      <td>6.914144</td>\n",
       "      <td>2.844231</td>\n",
       "      <td>7.055812</td>\n",
       "      <td>5.613861</td>\n",
       "      <td>6.708045</td>\n",
       "      <td>3.693197</td>\n",
       "      <td>6.980673</td>\n",
       "      <td>5.827317</td>\n",
       "      <td>4.374883</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10384072</th>\n",
       "      <td>3.156625</td>\n",
       "      <td>1.256022</td>\n",
       "      <td>2.453857</td>\n",
       "      <td>4.540692</td>\n",
       "      <td>5.053123</td>\n",
       "      <td>4.994856</td>\n",
       "      <td>5.317543</td>\n",
       "      <td>4.096865</td>\n",
       "      <td>4.774967</td>\n",
       "      <td>5.591334</td>\n",
       "      <td>...</td>\n",
       "      <td>2.354314</td>\n",
       "      <td>2.619950</td>\n",
       "      <td>2.211061</td>\n",
       "      <td>2.735793</td>\n",
       "      <td>4.562602</td>\n",
       "      <td>4.217780</td>\n",
       "      <td>3.651335</td>\n",
       "      <td>1.359812</td>\n",
       "      <td>3.494506</td>\n",
       "      <td>2.686497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11433190</th>\n",
       "      <td>2.684867</td>\n",
       "      <td>4.223113</td>\n",
       "      <td>6.556386</td>\n",
       "      <td>6.619402</td>\n",
       "      <td>6.283072</td>\n",
       "      <td>7.162875</td>\n",
       "      <td>6.858920</td>\n",
       "      <td>4.873260</td>\n",
       "      <td>6.995324</td>\n",
       "      <td>6.821069</td>\n",
       "      <td>...</td>\n",
       "      <td>1.089081</td>\n",
       "      <td>4.720908</td>\n",
       "      <td>6.391790</td>\n",
       "      <td>4.717355</td>\n",
       "      <td>6.400036</td>\n",
       "      <td>2.484305</td>\n",
       "      <td>1.166164</td>\n",
       "      <td>5.290392</td>\n",
       "      <td>1.881270</td>\n",
       "      <td>6.489096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1401</th>\n",
       "      <td>4.610518</td>\n",
       "      <td>1.344527</td>\n",
       "      <td>4.840732</td>\n",
       "      <td>4.403492</td>\n",
       "      <td>5.083817</td>\n",
       "      <td>0.312886</td>\n",
       "      <td>4.936584</td>\n",
       "      <td>5.411739</td>\n",
       "      <td>5.410276</td>\n",
       "      <td>3.194603</td>\n",
       "      <td>...</td>\n",
       "      <td>3.346391</td>\n",
       "      <td>5.106754</td>\n",
       "      <td>4.137981</td>\n",
       "      <td>3.976215</td>\n",
       "      <td>4.946276</td>\n",
       "      <td>5.275817</td>\n",
       "      <td>3.340374</td>\n",
       "      <td>4.928141</td>\n",
       "      <td>5.256207</td>\n",
       "      <td>5.292950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9914412</th>\n",
       "      <td>-0.748240</td>\n",
       "      <td>0.002473</td>\n",
       "      <td>4.977950</td>\n",
       "      <td>3.857583</td>\n",
       "      <td>2.005240</td>\n",
       "      <td>5.843849</td>\n",
       "      <td>6.057763</td>\n",
       "      <td>5.113857</td>\n",
       "      <td>5.643313</td>\n",
       "      <td>1.351146</td>\n",
       "      <td>...</td>\n",
       "      <td>1.378712</td>\n",
       "      <td>4.398155</td>\n",
       "      <td>3.587298</td>\n",
       "      <td>1.507198</td>\n",
       "      <td>5.779916</td>\n",
       "      <td>2.944887</td>\n",
       "      <td>1.970921</td>\n",
       "      <td>2.138586</td>\n",
       "      <td>0.609055</td>\n",
       "      <td>-0.295429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44450571</th>\n",
       "      <td>2.211340</td>\n",
       "      <td>4.880847</td>\n",
       "      <td>6.279265</td>\n",
       "      <td>4.248338</td>\n",
       "      <td>6.359012</td>\n",
       "      <td>3.310418</td>\n",
       "      <td>6.640961</td>\n",
       "      <td>6.350226</td>\n",
       "      <td>6.002792</td>\n",
       "      <td>6.040172</td>\n",
       "      <td>...</td>\n",
       "      <td>3.900294</td>\n",
       "      <td>4.887105</td>\n",
       "      <td>4.851317</td>\n",
       "      <td>5.201899</td>\n",
       "      <td>5.758217</td>\n",
       "      <td>5.679550</td>\n",
       "      <td>2.077888</td>\n",
       "      <td>3.396646</td>\n",
       "      <td>5.987578</td>\n",
       "      <td>0.787787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5330286</th>\n",
       "      <td>-0.316171</td>\n",
       "      <td>-0.283954</td>\n",
       "      <td>1.509023</td>\n",
       "      <td>5.053014</td>\n",
       "      <td>6.310274</td>\n",
       "      <td>4.406203</td>\n",
       "      <td>6.323589</td>\n",
       "      <td>6.366640</td>\n",
       "      <td>6.398217</td>\n",
       "      <td>6.042497</td>\n",
       "      <td>...</td>\n",
       "      <td>1.860004</td>\n",
       "      <td>2.734451</td>\n",
       "      <td>2.281738</td>\n",
       "      <td>3.820208</td>\n",
       "      <td>6.240592</td>\n",
       "      <td>1.873375</td>\n",
       "      <td>-0.512192</td>\n",
       "      <td>0.877027</td>\n",
       "      <td>2.595755</td>\n",
       "      <td>-1.186377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17755052</th>\n",
       "      <td>3.413564</td>\n",
       "      <td>-2.991458</td>\n",
       "      <td>2.480513</td>\n",
       "      <td>3.324435</td>\n",
       "      <td>2.292877</td>\n",
       "      <td>1.444307</td>\n",
       "      <td>3.275176</td>\n",
       "      <td>3.026796</td>\n",
       "      <td>2.278926</td>\n",
       "      <td>-0.085905</td>\n",
       "      <td>...</td>\n",
       "      <td>0.843554</td>\n",
       "      <td>-0.174095</td>\n",
       "      <td>1.997412</td>\n",
       "      <td>-1.980787</td>\n",
       "      <td>2.821422</td>\n",
       "      <td>3.965373</td>\n",
       "      <td>1.653922</td>\n",
       "      <td>4.143178</td>\n",
       "      <td>-0.044370</td>\n",
       "      <td>0.205165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9826528</th>\n",
       "      <td>2.875741</td>\n",
       "      <td>2.342638</td>\n",
       "      <td>2.534454</td>\n",
       "      <td>0.045125</td>\n",
       "      <td>3.161442</td>\n",
       "      <td>0.828878</td>\n",
       "      <td>3.583805</td>\n",
       "      <td>3.404238</td>\n",
       "      <td>3.272355</td>\n",
       "      <td>3.346019</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.419873</td>\n",
       "      <td>2.687343</td>\n",
       "      <td>1.301819</td>\n",
       "      <td>2.884144</td>\n",
       "      <td>2.918667</td>\n",
       "      <td>-2.093607</td>\n",
       "      <td>-2.298407</td>\n",
       "      <td>0.165697</td>\n",
       "      <td>-1.688156</td>\n",
       "      <td>-0.996696</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11316960</th>\n",
       "      <td>6.179703</td>\n",
       "      <td>4.311074</td>\n",
       "      <td>5.878736</td>\n",
       "      <td>5.984420</td>\n",
       "      <td>6.388039</td>\n",
       "      <td>5.864240</td>\n",
       "      <td>6.603216</td>\n",
       "      <td>6.478583</td>\n",
       "      <td>6.509114</td>\n",
       "      <td>6.313255</td>\n",
       "      <td>...</td>\n",
       "      <td>2.957277</td>\n",
       "      <td>5.395433</td>\n",
       "      <td>5.948279</td>\n",
       "      <td>5.268499</td>\n",
       "      <td>6.017040</td>\n",
       "      <td>6.099297</td>\n",
       "      <td>5.950036</td>\n",
       "      <td>6.432919</td>\n",
       "      <td>5.086676</td>\n",
       "      <td>6.542188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10127622</th>\n",
       "      <td>1.545801</td>\n",
       "      <td>3.314183</td>\n",
       "      <td>6.201988</td>\n",
       "      <td>4.933526</td>\n",
       "      <td>5.791245</td>\n",
       "      <td>6.302363</td>\n",
       "      <td>5.924107</td>\n",
       "      <td>6.237617</td>\n",
       "      <td>5.708350</td>\n",
       "      <td>6.034364</td>\n",
       "      <td>...</td>\n",
       "      <td>1.820766</td>\n",
       "      <td>4.678979</td>\n",
       "      <td>5.408225</td>\n",
       "      <td>3.819427</td>\n",
       "      <td>5.515387</td>\n",
       "      <td>1.039808</td>\n",
       "      <td>1.844562</td>\n",
       "      <td>6.126838</td>\n",
       "      <td>0.942509</td>\n",
       "      <td>5.585778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46883536</th>\n",
       "      <td>3.487370</td>\n",
       "      <td>4.679426</td>\n",
       "      <td>2.700231</td>\n",
       "      <td>4.447440</td>\n",
       "      <td>5.940386</td>\n",
       "      <td>5.732116</td>\n",
       "      <td>5.946962</td>\n",
       "      <td>5.832011</td>\n",
       "      <td>6.132978</td>\n",
       "      <td>4.883195</td>\n",
       "      <td>...</td>\n",
       "      <td>2.701591</td>\n",
       "      <td>6.359273</td>\n",
       "      <td>5.424043</td>\n",
       "      <td>6.436164</td>\n",
       "      <td>5.381509</td>\n",
       "      <td>6.286841</td>\n",
       "      <td>5.228552</td>\n",
       "      <td>5.420118</td>\n",
       "      <td>3.197688</td>\n",
       "      <td>6.396768</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11609586</th>\n",
       "      <td>2.468481</td>\n",
       "      <td>2.981479</td>\n",
       "      <td>3.097402</td>\n",
       "      <td>3.322574</td>\n",
       "      <td>6.868157</td>\n",
       "      <td>4.042837</td>\n",
       "      <td>3.915386</td>\n",
       "      <td>6.376999</td>\n",
       "      <td>6.009027</td>\n",
       "      <td>6.619592</td>\n",
       "      <td>...</td>\n",
       "      <td>3.635295</td>\n",
       "      <td>3.382523</td>\n",
       "      <td>2.917035</td>\n",
       "      <td>4.425206</td>\n",
       "      <td>5.407765</td>\n",
       "      <td>2.655755</td>\n",
       "      <td>2.973188</td>\n",
       "      <td>5.648437</td>\n",
       "      <td>4.662707</td>\n",
       "      <td>3.024360</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11455910</th>\n",
       "      <td>-1.025733</td>\n",
       "      <td>-0.122957</td>\n",
       "      <td>-0.834322</td>\n",
       "      <td>-0.491186</td>\n",
       "      <td>-1.309782</td>\n",
       "      <td>-2.400113</td>\n",
       "      <td>-0.099120</td>\n",
       "      <td>-0.679022</td>\n",
       "      <td>0.746377</td>\n",
       "      <td>0.742430</td>\n",
       "      <td>...</td>\n",
       "      <td>1.593719</td>\n",
       "      <td>0.122178</td>\n",
       "      <td>-1.483677</td>\n",
       "      <td>-0.427251</td>\n",
       "      <td>1.821120</td>\n",
       "      <td>-1.833078</td>\n",
       "      <td>-1.538582</td>\n",
       "      <td>0.910633</td>\n",
       "      <td>-0.859536</td>\n",
       "      <td>-2.571121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9931953</th>\n",
       "      <td>1.246618</td>\n",
       "      <td>1.780458</td>\n",
       "      <td>0.812216</td>\n",
       "      <td>2.443202</td>\n",
       "      <td>6.295548</td>\n",
       "      <td>5.771774</td>\n",
       "      <td>6.036853</td>\n",
       "      <td>6.379037</td>\n",
       "      <td>6.375098</td>\n",
       "      <td>6.244091</td>\n",
       "      <td>...</td>\n",
       "      <td>4.138311</td>\n",
       "      <td>3.409801</td>\n",
       "      <td>4.045058</td>\n",
       "      <td>3.775550</td>\n",
       "      <td>6.038505</td>\n",
       "      <td>3.864015</td>\n",
       "      <td>2.576201</td>\n",
       "      <td>5.989073</td>\n",
       "      <td>2.151274</td>\n",
       "      <td>2.973298</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>124 rows × 124 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               ES3       ES5     EW-11  NCI-H1395  NCI-H1770   DMS-114  \\\n",
       "drug_id                                                                  \n",
       "176870    5.457453  6.177945  3.954488   5.429563   6.239001  6.439408   \n",
       "5284616   2.712723  2.713280  0.083814   0.926814   2.125850 -1.892659   \n",
       "5329102   3.624351  3.208216  3.540163   6.187608   2.676693  4.345598   \n",
       "10461815  5.741999  2.671871  5.191223   2.379769   4.042987  5.904581   \n",
       "462382    1.465161  1.482183  2.443964   4.074435   5.051646  0.368378   \n",
       "36314     2.230729  2.062629  2.456970   1.610128   2.911541 -3.688091   \n",
       "442972    6.262880  7.901639  6.841940   5.192934   4.689366  6.962380   \n",
       "11676786  3.840777  2.634967  1.836697   4.547153   5.440164  3.831238   \n",
       "216239    2.934077  4.127530  6.831892   3.838928   5.437241  2.355562   \n",
       "5494449   3.602096  5.346999  5.729100   5.477718   2.186349  4.868544   \n",
       "5291      5.337817  4.215039  5.822416   3.947071   1.717865  6.237985   \n",
       "16038120  4.674520  3.405319  2.267368   1.036778   3.346738  0.961355   \n",
       "11496366  5.924602  6.253164  4.698552   4.675106   5.708927  5.353218   \n",
       "10302451  2.860227  6.389974  5.413987   4.641152   5.920998  5.477196   \n",
       "76044     5.345504  6.007588  6.035437   2.306003   2.754991  1.181406   \n",
       "16760646  2.750826  2.494072  5.852555   3.579228   3.399192  5.536588   \n",
       "3062316   4.078735  5.701991  4.777730   3.738057   4.339664  4.295439   \n",
       "5311510   2.858726  5.833998  4.818600   5.292979   5.736564  5.548083   \n",
       "644215   -0.045722  0.628669  1.791496  -1.290847  -1.187067 -0.666328   \n",
       "24825971  2.556418  6.422752  5.224450   5.089995   1.626116  4.932276   \n",
       "9549184   6.102112  6.967883  5.068808   2.590619   5.335362  6.140627   \n",
       "11844351  5.143049  6.383421  6.516894   4.836352   6.582229  1.026119   \n",
       "49821040  6.076867  7.726779  7.382650   6.755815   7.805116  6.024787   \n",
       "11364421  2.638894  3.080401  4.019169   0.101385   1.897476 -2.586503   \n",
       "10390396  4.348722  6.146188  6.313170   6.747982   2.453080  1.719837   \n",
       "20635522  2.186483  3.882340  2.389910   5.855510   4.267952  3.480206   \n",
       "4993      5.166096  7.883980  7.859141   5.475670   7.447522  4.070601   \n",
       "49836027  3.899734  2.253695  3.189317   2.507146   0.284641 -1.427422   \n",
       "10172943  1.244741  2.081055  5.327523   4.329033   5.358756 -0.016805   \n",
       "15983966  3.021673  4.944419  4.129560   0.053222  -0.816280 -2.106796   \n",
       "...            ...       ...       ...        ...        ...       ...   \n",
       "11960529  5.683549  4.305218  5.348367   5.416088   6.224812  6.010940   \n",
       "5328940   3.878526  0.624584  1.145104   3.104169   5.495732  5.574144   \n",
       "216326    3.122202  5.673848  4.459377   5.795685   5.982549  6.006429   \n",
       "6450551   2.922531  0.159125  1.289293   4.282659   4.280930  0.979621   \n",
       "126565   -2.082146 -4.105555 -2.022476  -1.268014   0.423532  0.417860   \n",
       "6505803  -0.525536  1.633988  3.968306  -1.677600  -0.639987  1.514447   \n",
       "10341154  4.839934  3.589065  3.007883   4.406614   4.642372  5.482972   \n",
       "11667893  3.225935  3.423937  4.540733   5.699898   5.241725  3.983784   \n",
       "5278396   4.047392  4.495346  6.917073   4.010761   6.930248  6.022198   \n",
       "10184653  2.828106  1.576343  2.216649   3.028667   3.896277  3.709598   \n",
       "24776445  6.176463  4.529101  3.126855   6.820092   6.926870  6.738021   \n",
       "24180719  4.863117  1.816328  5.764284   5.982259   6.411098  6.380521   \n",
       "10077147  0.964262  0.176920  2.347783   2.297945   2.159361  2.521826   \n",
       "11327430  4.075888  2.575329  4.122000   3.528709   5.440606  2.729755   \n",
       "156422    6.270331  5.064372  5.914983   4.696624   6.741191  5.388570   \n",
       "11624601  3.642703  6.392269  6.234337   7.029000   6.744473  6.245762   \n",
       "10384072  3.156625  1.256022  2.453857   4.540692   5.053123  4.994856   \n",
       "11433190  2.684867  4.223113  6.556386   6.619402   6.283072  7.162875   \n",
       "1401      4.610518  1.344527  4.840732   4.403492   5.083817  0.312886   \n",
       "9914412  -0.748240  0.002473  4.977950   3.857583   2.005240  5.843849   \n",
       "44450571  2.211340  4.880847  6.279265   4.248338   6.359012  3.310418   \n",
       "5330286  -0.316171 -0.283954  1.509023   5.053014   6.310274  4.406203   \n",
       "17755052  3.413564 -2.991458  2.480513   3.324435   2.292877  1.444307   \n",
       "9826528   2.875741  2.342638  2.534454   0.045125   3.161442  0.828878   \n",
       "11316960  6.179703  4.311074  5.878736   5.984420   6.388039  5.864240   \n",
       "10127622  1.545801  3.314183  6.201988   4.933526   5.791245  6.302363   \n",
       "46883536  3.487370  4.679426  2.700231   4.447440   5.940386  5.732116   \n",
       "11609586  2.468481  2.981479  3.097402   3.322574   6.868157  4.042837   \n",
       "11455910 -1.025733 -0.122957 -0.834322  -0.491186  -1.309782 -2.400113   \n",
       "9931953   1.246618  1.780458  0.812216   2.443202   6.295548  5.771774   \n",
       "\n",
       "          NCI-H1092  NCI-H2141  NCI-H345  NCI-H446    ...      D-502MG  \\\n",
       "drug_id                                               ...                \n",
       "176870     5.322913   5.481543  5.701747  5.829406    ...     2.853407   \n",
       "5284616    1.661186   1.155157 -0.058457  0.278546    ...     1.145465   \n",
       "5329102    5.835351   3.639802  5.687395  3.313991    ...     6.892013   \n",
       "10461815   5.305583   4.700236  6.133696  6.221338    ...     4.200647   \n",
       "462382    -0.945622   0.514722  3.047581  4.602755    ...     0.514084   \n",
       "36314      0.267879  -2.513281 -1.776183 -3.857458    ...     1.053631   \n",
       "442972     8.059654   7.905122  7.664581  6.864623    ...     3.944047   \n",
       "11676786   3.769191   5.354976  7.074614  6.781506    ...     0.815994   \n",
       "216239     5.406161   2.784330  5.354602  6.159637    ...     4.545320   \n",
       "5494449    4.197522   4.017509  3.880903  3.942056    ...     5.228564   \n",
       "5291       4.431051   5.288382  6.018588  5.891683    ...     4.912112   \n",
       "16038120   2.081607   1.637575  2.443206  4.727257    ...     4.092738   \n",
       "11496366   5.444895   4.611212  4.717657  5.920815    ...     4.708966   \n",
       "10302451   4.712901   4.015363  6.042795  5.152341    ...     4.641850   \n",
       "76044      3.022778   1.471682  2.071927  0.951191    ...     5.589781   \n",
       "16760646   0.459749   2.973586  5.507376  3.994693    ...     5.002047   \n",
       "3062316    4.898917   3.209851  4.816569 -0.465847    ...     0.210066   \n",
       "5311510    3.929057   5.120549  4.691522  5.217490    ...     4.873181   \n",
       "644215    -2.222384  -2.283975  0.772660  0.789477    ...     0.618983   \n",
       "24825971   6.232089   3.888698  6.589912  6.437845    ...     5.126632   \n",
       "9549184    6.029098   3.488897  6.214220  6.786771    ...     5.259058   \n",
       "11844351   5.315626   5.783885  4.942131  2.649070    ...     4.799909   \n",
       "49821040   6.352278   5.542833  7.400490  6.656297    ...     6.148649   \n",
       "11364421   0.566345  -1.660166 -1.435280 -2.357924    ...     2.077390   \n",
       "10390396   4.113632   3.300396  3.763715  7.265668    ...     4.321355   \n",
       "20635522   3.247356   3.806186  7.862416  8.026635    ...     6.646773   \n",
       "4993       6.550599   7.367777  6.987707  9.440488    ...     6.174442   \n",
       "49836027   1.083139   0.176466  0.962813 -1.778365    ...     3.782435   \n",
       "10172943  -0.063587  -0.616792 -0.287250 -0.929038    ...     1.187738   \n",
       "15983966   0.615709  -1.841517 -1.097197 -4.426513    ...     2.326680   \n",
       "...             ...        ...       ...       ...    ...          ...   \n",
       "11960529   6.168458   6.606545  6.439538  6.490016    ...     5.901723   \n",
       "5328940    5.787172   5.007210  5.576062  5.554359    ...     1.999414   \n",
       "216326     6.433115   6.541348  6.155639  6.360811    ...     4.963808   \n",
       "6450551    5.584058   4.985454  5.250250  1.351358    ...     1.838733   \n",
       "126565     1.776061   1.426202  2.369733 -0.328386    ...    -0.888498   \n",
       "6505803    4.039580   3.368856  3.636540  4.463196    ...     3.127904   \n",
       "10341154   3.875990   5.629601  5.489417  4.740784    ...     4.677631   \n",
       "11667893   5.498988   5.052387  4.845417  4.755961    ...     3.819904   \n",
       "5278396    7.141449   6.677504  7.266747  6.602751    ...     5.558615   \n",
       "10184653   3.725827   3.992132  3.918417  4.285926    ...     2.115390   \n",
       "24776445   6.567106   7.151018  7.227604  5.036699    ...     6.821872   \n",
       "24180719   6.625925   6.062776  6.109542  5.885714    ...     3.891159   \n",
       "10077147   3.285498   2.920491  6.175110  2.256334    ...     1.835894   \n",
       "11327430   5.514731   4.961287  5.544484  2.608854    ...     4.126876   \n",
       "156422     6.435830   5.645205  6.748418  6.087085    ...     4.792388   \n",
       "11624601   7.267811   6.900567  6.832558  7.188936    ...     5.849862   \n",
       "10384072   5.317543   4.096865  4.774967  5.591334    ...     2.354314   \n",
       "11433190   6.858920   4.873260  6.995324  6.821069    ...     1.089081   \n",
       "1401       4.936584   5.411739  5.410276  3.194603    ...     3.346391   \n",
       "9914412    6.057763   5.113857  5.643313  1.351146    ...     1.378712   \n",
       "44450571   6.640961   6.350226  6.002792  6.040172    ...     3.900294   \n",
       "5330286    6.323589   6.366640  6.398217  6.042497    ...     1.860004   \n",
       "17755052   3.275176   3.026796  2.278926 -0.085905    ...     0.843554   \n",
       "9826528    3.583805   3.404238  3.272355  3.346019    ...    -1.419873   \n",
       "11316960   6.603216   6.478583  6.509114  6.313255    ...     2.957277   \n",
       "10127622   5.924107   6.237617  5.708350  6.034364    ...     1.820766   \n",
       "46883536   5.946962   5.832011  6.132978  4.883195    ...     2.701591   \n",
       "11609586   3.915386   6.376999  6.009027  6.619592    ...     3.635295   \n",
       "11455910  -0.099120  -0.679022  0.746377  0.742430    ...     1.593719   \n",
       "9931953    6.036853   6.379037  6.375098  6.244091    ...     4.138311   \n",
       "\n",
       "              EW-3      EW-1     EW-18     EW-24     LAN-6      NB10  \\\n",
       "drug_id                                                                \n",
       "176870    4.907507  3.862042  6.281844 -0.520144  5.284207  2.464594   \n",
       "5284616   2.363574 -6.132267  1.956273  2.170812  2.116257  0.382757   \n",
       "5329102   1.861296  1.543108  7.450205  6.305561  2.656457  7.379108   \n",
       "10461815  4.961017  6.038975  3.709424  5.878941  5.791552  6.379263   \n",
       "462382    4.552909 -1.558431  0.704762  3.476532 -1.161549  2.078887   \n",
       "36314    -2.209074 -5.595654  1.951147 -2.735986  1.266350  3.450273   \n",
       "442972    6.229268  6.147171  6.323129  7.327341  7.927056  6.089575   \n",
       "11676786  1.769899  4.954149  2.502414  0.997667 -0.382198  3.782938   \n",
       "216239    3.053480  5.073228  2.476909  2.782917  4.221937  3.926651   \n",
       "5494449   2.620323  0.170270  6.462531  5.003229  4.840668  5.500566   \n",
       "5291      5.310111  3.494853  3.880315  5.955108  6.285480  3.276010   \n",
       "16038120  1.560768 -2.277299  3.252065  1.298649 -1.746236  0.453570   \n",
       "11496366  5.497982  2.345889  5.388803  5.383014  2.931500  5.909705   \n",
       "10302451  5.207449  5.159156  5.447730 -0.466917  4.973744  2.919153   \n",
       "76044     1.592400  0.413721  7.218919  3.154823  1.305098  3.870451   \n",
       "16760646  2.626498  1.433309  6.511248  3.723822  1.350476  4.939727   \n",
       "3062316   4.517188  4.995126  5.801361 -0.246343  5.184950  5.352914   \n",
       "5311510   5.192398  4.871301  5.939899  5.321265  5.466854  5.145785   \n",
       "644215   -1.343815 -3.083062  2.704978  1.027847 -1.907018  0.111594   \n",
       "24825971  6.324584  2.740650  6.568490  4.277519  5.704759  6.924701   \n",
       "9549184   6.803529  5.981820  5.690450  3.270553  7.831552  7.337717   \n",
       "11844351  4.231410  5.220739  7.307820  5.812862  5.057459  6.880506   \n",
       "49821040  4.956919  5.881320  7.383467  1.523695  6.700624  7.745282   \n",
       "11364421 -2.048497 -2.840946  4.247597 -0.083365 -1.152885  3.410138   \n",
       "10390396  1.560359 -1.751832  4.536535  2.342079 -1.761946  3.282415   \n",
       "20635522  2.148520  1.135812  6.607817  6.846458  1.986520  7.319852   \n",
       "4993      5.502698  0.317060  5.806752  3.993994  5.857310  7.470861   \n",
       "49836027 -1.527016 -4.894122  5.249339  0.435797  1.707899  0.792442   \n",
       "10172943  0.107468 -1.507889  5.326627 -0.177820 -0.121295  1.853053   \n",
       "15983966 -2.713409 -4.087139  4.172566  0.177178 -1.975958  1.391426   \n",
       "...            ...       ...       ...       ...       ...       ...   \n",
       "11960529  3.692212  5.304538  4.981526  5.266191  5.801910  5.357161   \n",
       "5328940   1.961255  3.910189  2.255547  2.426689  5.609573  5.279878   \n",
       "216326    5.927353  5.997094  3.869471  5.216401  6.135829  5.621627   \n",
       "6450551   3.715895  1.510753  1.641951  3.578717  3.636486  0.281839   \n",
       "126565   -0.084830  0.075484 -0.820722  1.563616  0.896512 -1.084717   \n",
       "6505803   2.107907  3.772227  3.146968  3.852400  2.737052  0.125259   \n",
       "10341154  4.316078  5.436961  2.602177  4.873713  5.470376  4.943404   \n",
       "11667893  3.943630  2.859866  4.904784  4.387342  4.973785  0.854624   \n",
       "5278396   7.169269  5.499052  3.815202  5.406605  7.036660  6.843498   \n",
       "10184653  3.394566  3.827965  2.806362  3.164771  3.689160  3.101761   \n",
       "24776445  5.235327  6.181789  3.310252  5.452315  7.098196  7.073850   \n",
       "24180719  6.500161  5.506808  4.121076  5.807522  7.152838  6.922368   \n",
       "10077147  2.817968  3.082500  1.201367  4.632461  6.288675  1.441665   \n",
       "11327430  5.382167  3.524364  3.232616  4.577973  3.046405  3.267055   \n",
       "156422    6.227857  6.291758  7.050382  6.554919  6.123599  6.691200   \n",
       "11624601  6.914144  2.844231  7.055812  5.613861  6.708045  3.693197   \n",
       "10384072  2.619950  2.211061  2.735793  4.562602  4.217780  3.651335   \n",
       "11433190  4.720908  6.391790  4.717355  6.400036  2.484305  1.166164   \n",
       "1401      5.106754  4.137981  3.976215  4.946276  5.275817  3.340374   \n",
       "9914412   4.398155  3.587298  1.507198  5.779916  2.944887  1.970921   \n",
       "44450571  4.887105  4.851317  5.201899  5.758217  5.679550  2.077888   \n",
       "5330286   2.734451  2.281738  3.820208  6.240592  1.873375 -0.512192   \n",
       "17755052 -0.174095  1.997412 -1.980787  2.821422  3.965373  1.653922   \n",
       "9826528   2.687343  1.301819  2.884144  2.918667 -2.093607 -2.298407   \n",
       "11316960  5.395433  5.948279  5.268499  6.017040  6.099297  5.950036   \n",
       "10127622  4.678979  5.408225  3.819427  5.515387  1.039808  1.844562   \n",
       "46883536  6.359273  5.424043  6.436164  5.381509  6.286841  5.228552   \n",
       "11609586  3.382523  2.917035  4.425206  5.407765  2.655755  2.973188   \n",
       "11455910  0.122178 -1.483677 -0.427251  1.821120 -1.833078 -1.538582   \n",
       "9931953   3.409801  4.045058  3.775550  6.038505  3.864015  2.576201   \n",
       "\n",
       "               NB6       NB5      NB14  \n",
       "drug_id                                 \n",
       "176870    3.128087  2.331174  5.788405  \n",
       "5284616   1.157696  5.900698  1.412155  \n",
       "5329102   4.617955  4.390978  2.391296  \n",
       "10461815  5.592871  6.070821  2.972592  \n",
       "462382    3.432384  4.253437  4.990988  \n",
       "36314    -1.856457 -1.795945  2.055904  \n",
       "442972    7.302904  8.251158  7.289493  \n",
       "11676786  4.817854  0.669910 -0.706610  \n",
       "216239    2.278322  5.885494  2.155399  \n",
       "5494449  -0.258076  0.496093  5.372444  \n",
       "5291      4.900965  5.767412  4.594319  \n",
       "16038120  2.021414  0.460432 -0.824944  \n",
       "11496366  5.368972  3.551155  1.575931  \n",
       "10302451  3.313749  1.485833  4.082745  \n",
       "76044     1.364751  2.859267  4.064081  \n",
       "16760646  4.905872  2.108060  2.467049  \n",
       "3062316   2.294814  0.335239  5.983951  \n",
       "5311510   4.016846  5.854458  5.980599  \n",
       "644215    0.843692  2.203509 -0.413826  \n",
       "24825971  6.351617  6.933278  5.716638  \n",
       "9549184   5.340784  2.486816  6.786110  \n",
       "11844351  0.528852  5.646194  6.188467  \n",
       "49821040  4.380176  5.176501  7.633546  \n",
       "11364421 -1.683838 -1.866773  1.786973  \n",
       "10390396  6.291796  0.104780  6.847403  \n",
       "20635522  4.871396  2.807171  4.142461  \n",
       "4993      7.233896  7.139622  3.052458  \n",
       "49836027 -2.942993 -2.340776  5.157241  \n",
       "10172943 -0.734500 -0.407789  0.677418  \n",
       "15983966 -1.953810 -2.450524  2.538847  \n",
       "...            ...       ...       ...  \n",
       "11960529  6.292128  5.622409  6.196443  \n",
       "5328940   3.445624  4.663958  2.859645  \n",
       "216326    4.189473  6.441622  6.250331  \n",
       "6450551   3.831052  4.943348 -0.302999  \n",
       "126565   -0.066319 -0.753346 -4.939001  \n",
       "6505803   3.474684  1.254731  2.780563  \n",
       "10341154  4.329608  4.022665  5.355499  \n",
       "11667893  5.300406  4.734032  2.638917  \n",
       "5278396   6.558648  5.010736  3.490883  \n",
       "10184653  4.263802  0.345838  4.158341  \n",
       "24776445  7.196784  6.032335  7.045438  \n",
       "24180719  5.263797  6.429824  6.391518  \n",
       "10077147  1.006598  1.077441  0.250380  \n",
       "11327430  5.406361  2.375453  1.695502  \n",
       "156422    6.579294  7.277708  4.077675  \n",
       "11624601  6.980673  5.827317  4.374883  \n",
       "10384072  1.359812  3.494506  2.686497  \n",
       "11433190  5.290392  1.881270  6.489096  \n",
       "1401      4.928141  5.256207  5.292950  \n",
       "9914412   2.138586  0.609055 -0.295429  \n",
       "44450571  3.396646  5.987578  0.787787  \n",
       "5330286   0.877027  2.595755 -1.186377  \n",
       "17755052  4.143178 -0.044370  0.205165  \n",
       "9826528   0.165697 -1.688156 -0.996696  \n",
       "11316960  6.432919  5.086676  6.542188  \n",
       "10127622  6.126838  0.942509  5.585778  \n",
       "46883536  5.420118  3.197688  6.396768  \n",
       "11609586  5.648437  4.662707  3.024360  \n",
       "11455910  0.910633 -0.859536 -2.571121  \n",
       "9931953   5.989073  2.151274  2.973298  \n",
       "\n",
       "[124 rows x 124 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ImportData.importDataAsMatrix()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>IC50</th>\n",
       "      <th>cell_line</th>\n",
       "      <th>drug_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5.457453</td>\n",
       "      <td>ES3</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>6.177945</td>\n",
       "      <td>ES5</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3.954488</td>\n",
       "      <td>EW-11</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5.429563</td>\n",
       "      <td>NCI-H1395</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6.239001</td>\n",
       "      <td>NCI-H1770</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6.439408</td>\n",
       "      <td>DMS-114</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>5.322913</td>\n",
       "      <td>NCI-H1092</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>5.481543</td>\n",
       "      <td>NCI-H2141</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5.701747</td>\n",
       "      <td>NCI-H345</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5.829406</td>\n",
       "      <td>NCI-H446</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>5.880866</td>\n",
       "      <td>NCI-H82</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>4.641043</td>\n",
       "      <td>SK-N-DZ</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>4.946024</td>\n",
       "      <td>Calu-6</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>5.758914</td>\n",
       "      <td>LU-65</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>5.341703</td>\n",
       "      <td>SHP-77</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>5.841532</td>\n",
       "      <td>HCC1187</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>3.012397</td>\n",
       "      <td>HCC2157</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>5.332874</td>\n",
       "      <td>HCC2218</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>4.835373</td>\n",
       "      <td>BB49-HNC</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>4.694712</td>\n",
       "      <td>CPC-N</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>3.941827</td>\n",
       "      <td>EC-GI-10</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>5.978332</td>\n",
       "      <td>IM-9</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>5.410115</td>\n",
       "      <td>IST-SL1</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>3.414455</td>\n",
       "      <td>LB831-BLC</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>6.180606</td>\n",
       "      <td>LU-134-A</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2.439368</td>\n",
       "      <td>MS-1</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>5.456650</td>\n",
       "      <td>MZ7-mel</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>4.749837</td>\n",
       "      <td>NCI-H510A</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>5.723651</td>\n",
       "      <td>SK-MM-2</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>0.339898</td>\n",
       "      <td>TE-1</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15346</th>\n",
       "      <td>4.591031</td>\n",
       "      <td>WSU-NHL</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15347</th>\n",
       "      <td>4.343680</td>\n",
       "      <td>RCC10RGB</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15348</th>\n",
       "      <td>3.835645</td>\n",
       "      <td>KURAMOCHI</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15349</th>\n",
       "      <td>5.564257</td>\n",
       "      <td>Ramos-2G6-4C10</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15350</th>\n",
       "      <td>5.169653</td>\n",
       "      <td>CW-2</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15351</th>\n",
       "      <td>6.460933</td>\n",
       "      <td>COLO-320-HSR</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15352</th>\n",
       "      <td>4.072314</td>\n",
       "      <td>COLO-684</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15353</th>\n",
       "      <td>5.795011</td>\n",
       "      <td>CA46</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15354</th>\n",
       "      <td>5.644396</td>\n",
       "      <td>RL</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15355</th>\n",
       "      <td>5.926194</td>\n",
       "      <td>SNU-C1</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15356</th>\n",
       "      <td>5.134174</td>\n",
       "      <td>ST486</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15357</th>\n",
       "      <td>5.301860</td>\n",
       "      <td>BC-1</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15358</th>\n",
       "      <td>2.961610</td>\n",
       "      <td>CAS-1</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15359</th>\n",
       "      <td>6.051435</td>\n",
       "      <td>MFM-223</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15360</th>\n",
       "      <td>5.270021</td>\n",
       "      <td>LS-1034</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15361</th>\n",
       "      <td>6.315813</td>\n",
       "      <td>HDLM-2</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15362</th>\n",
       "      <td>2.480321</td>\n",
       "      <td>KNS-81-FD</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15363</th>\n",
       "      <td>5.127429</td>\n",
       "      <td>TE-6</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15364</th>\n",
       "      <td>5.362633</td>\n",
       "      <td>TE-12</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15365</th>\n",
       "      <td>3.340448</td>\n",
       "      <td>D-263MG</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15366</th>\n",
       "      <td>4.138311</td>\n",
       "      <td>D-502MG</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15367</th>\n",
       "      <td>3.409801</td>\n",
       "      <td>EW-3</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15368</th>\n",
       "      <td>4.045058</td>\n",
       "      <td>EW-1</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15369</th>\n",
       "      <td>3.775550</td>\n",
       "      <td>EW-18</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15370</th>\n",
       "      <td>6.038505</td>\n",
       "      <td>EW-24</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15371</th>\n",
       "      <td>3.864015</td>\n",
       "      <td>LAN-6</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15372</th>\n",
       "      <td>2.576201</td>\n",
       "      <td>NB10</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15373</th>\n",
       "      <td>5.989073</td>\n",
       "      <td>NB6</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15374</th>\n",
       "      <td>2.151274</td>\n",
       "      <td>NB5</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15375</th>\n",
       "      <td>2.973298</td>\n",
       "      <td>NB14</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>15376 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           IC50       cell_line  drug_id\n",
       "0      5.457453             ES3   176870\n",
       "1      6.177945             ES5   176870\n",
       "2      3.954488           EW-11   176870\n",
       "3      5.429563       NCI-H1395   176870\n",
       "4      6.239001       NCI-H1770   176870\n",
       "5      6.439408         DMS-114   176870\n",
       "6      5.322913       NCI-H1092   176870\n",
       "7      5.481543       NCI-H2141   176870\n",
       "8      5.701747        NCI-H345   176870\n",
       "9      5.829406        NCI-H446   176870\n",
       "10     5.880866         NCI-H82   176870\n",
       "11     4.641043         SK-N-DZ   176870\n",
       "12     4.946024          Calu-6   176870\n",
       "13     5.758914           LU-65   176870\n",
       "14     5.341703          SHP-77   176870\n",
       "15     5.841532         HCC1187   176870\n",
       "16     3.012397         HCC2157   176870\n",
       "17     5.332874         HCC2218   176870\n",
       "18     4.835373        BB49-HNC   176870\n",
       "19     4.694712           CPC-N   176870\n",
       "20     3.941827        EC-GI-10   176870\n",
       "21     5.978332            IM-9   176870\n",
       "22     5.410115         IST-SL1   176870\n",
       "23     3.414455       LB831-BLC   176870\n",
       "24     6.180606        LU-134-A   176870\n",
       "25     2.439368            MS-1   176870\n",
       "26     5.456650         MZ7-mel   176870\n",
       "27     4.749837       NCI-H510A   176870\n",
       "28     5.723651         SK-MM-2   176870\n",
       "29     0.339898            TE-1   176870\n",
       "...         ...             ...      ...\n",
       "15346  4.591031         WSU-NHL  9931953\n",
       "15347  4.343680        RCC10RGB  9931953\n",
       "15348  3.835645       KURAMOCHI  9931953\n",
       "15349  5.564257  Ramos-2G6-4C10  9931953\n",
       "15350  5.169653            CW-2  9931953\n",
       "15351  6.460933    COLO-320-HSR  9931953\n",
       "15352  4.072314        COLO-684  9931953\n",
       "15353  5.795011            CA46  9931953\n",
       "15354  5.644396              RL  9931953\n",
       "15355  5.926194          SNU-C1  9931953\n",
       "15356  5.134174           ST486  9931953\n",
       "15357  5.301860            BC-1  9931953\n",
       "15358  2.961610           CAS-1  9931953\n",
       "15359  6.051435         MFM-223  9931953\n",
       "15360  5.270021         LS-1034  9931953\n",
       "15361  6.315813          HDLM-2  9931953\n",
       "15362  2.480321       KNS-81-FD  9931953\n",
       "15363  5.127429            TE-6  9931953\n",
       "15364  5.362633           TE-12  9931953\n",
       "15365  3.340448         D-263MG  9931953\n",
       "15366  4.138311         D-502MG  9931953\n",
       "15367  3.409801            EW-3  9931953\n",
       "15368  4.045058            EW-1  9931953\n",
       "15369  3.775550           EW-18  9931953\n",
       "15370  6.038505           EW-24  9931953\n",
       "15371  3.864015           LAN-6  9931953\n",
       "15372  2.576201            NB10  9931953\n",
       "15373  5.989073             NB6  9931953\n",
       "15374  2.151274             NB5  9931953\n",
       "15375  2.973298            NB14  9931953\n",
       "\n",
       "[15376 rows x 3 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ImportData.importDataAsTable(False, False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|##########| 12134/12134 [00:34<00:00, 346.73it/s]\n"
     ]
    },
    {
     "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>IC50</th>\n",
       "      <th>cell_line</th>\n",
       "      <th>drug_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5.457453</td>\n",
       "      <td>ES3</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>6.177945</td>\n",
       "      <td>ES5</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3.954488</td>\n",
       "      <td>EW-11</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5.429563</td>\n",
       "      <td>NCI-H1395</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6.239001</td>\n",
       "      <td>NCI-H1770</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6.439408</td>\n",
       "      <td>DMS-114</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>5.322913</td>\n",
       "      <td>NCI-H1092</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>5.481543</td>\n",
       "      <td>NCI-H2141</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5.701747</td>\n",
       "      <td>NCI-H345</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5.829406</td>\n",
       "      <td>NCI-H446</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>5.880866</td>\n",
       "      <td>NCI-H82</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>4.641043</td>\n",
       "      <td>SK-N-DZ</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>4.946024</td>\n",
       "      <td>Calu-6</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>5.758914</td>\n",
       "      <td>LU-65</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>5.341703</td>\n",
       "      <td>SHP-77</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>5.841532</td>\n",
       "      <td>HCC1187</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>3.012397</td>\n",
       "      <td>HCC2157</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>5.332874</td>\n",
       "      <td>HCC2218</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>4.835373</td>\n",
       "      <td>BB49-HNC</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>4.694712</td>\n",
       "      <td>CPC-N</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>3.941827</td>\n",
       "      <td>EC-GI-10</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>5.978332</td>\n",
       "      <td>IM-9</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>5.410115</td>\n",
       "      <td>IST-SL1</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>3.414455</td>\n",
       "      <td>LB831-BLC</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>6.180606</td>\n",
       "      <td>LU-134-A</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2.439368</td>\n",
       "      <td>MS-1</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>5.456650</td>\n",
       "      <td>MZ7-mel</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>4.749837</td>\n",
       "      <td>NCI-H510A</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>5.723651</td>\n",
       "      <td>SK-MM-2</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>0.339898</td>\n",
       "      <td>TE-1</td>\n",
       "      <td>176870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15346</th>\n",
       "      <td>4.591031</td>\n",
       "      <td>WSU-NHL</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15347</th>\n",
       "      <td>4.343680</td>\n",
       "      <td>RCC10RGB</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15348</th>\n",
       "      <td>3.835645</td>\n",
       "      <td>KURAMOCHI</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15349</th>\n",
       "      <td>5.564257</td>\n",
       "      <td>Ramos-2G6-4C10</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15350</th>\n",
       "      <td>5.169653</td>\n",
       "      <td>CW-2</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15351</th>\n",
       "      <td>6.460933</td>\n",
       "      <td>COLO-320-HSR</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15352</th>\n",
       "      <td>4.072314</td>\n",
       "      <td>COLO-684</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15353</th>\n",
       "      <td>5.795011</td>\n",
       "      <td>CA46</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15354</th>\n",
       "      <td>5.644396</td>\n",
       "      <td>RL</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15355</th>\n",
       "      <td>5.926194</td>\n",
       "      <td>SNU-C1</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15356</th>\n",
       "      <td>5.134174</td>\n",
       "      <td>ST486</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15357</th>\n",
       "      <td>5.301860</td>\n",
       "      <td>BC-1</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15358</th>\n",
       "      <td>2.961610</td>\n",
       "      <td>CAS-1</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15359</th>\n",
       "      <td>6.051435</td>\n",
       "      <td>MFM-223</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15360</th>\n",
       "      <td>5.270021</td>\n",
       "      <td>LS-1034</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15361</th>\n",
       "      <td>6.315813</td>\n",
       "      <td>HDLM-2</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15362</th>\n",
       "      <td>2.480321</td>\n",
       "      <td>KNS-81-FD</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15363</th>\n",
       "      <td>5.127429</td>\n",
       "      <td>TE-6</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15364</th>\n",
       "      <td>5.362633</td>\n",
       "      <td>TE-12</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15365</th>\n",
       "      <td>3.340448</td>\n",
       "      <td>D-263MG</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15366</th>\n",
       "      <td>4.138311</td>\n",
       "      <td>D-502MG</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15367</th>\n",
       "      <td>3.409801</td>\n",
       "      <td>EW-3</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15368</th>\n",
       "      <td>4.045058</td>\n",
       "      <td>EW-1</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15369</th>\n",
       "      <td>3.775550</td>\n",
       "      <td>EW-18</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15370</th>\n",
       "      <td>6.038505</td>\n",
       "      <td>EW-24</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15371</th>\n",
       "      <td>3.864015</td>\n",
       "      <td>LAN-6</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15372</th>\n",
       "      <td>2.576201</td>\n",
       "      <td>NB10</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15373</th>\n",
       "      <td>5.989073</td>\n",
       "      <td>NB6</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15374</th>\n",
       "      <td>2.151274</td>\n",
       "      <td>NB5</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15375</th>\n",
       "      <td>2.973298</td>\n",
       "      <td>NB14</td>\n",
       "      <td>9931953</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>15376 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           IC50       cell_line  drug_id\n",
       "0      5.457453             ES3   176870\n",
       "1      6.177945             ES5   176870\n",
       "2      3.954488           EW-11   176870\n",
       "3      5.429563       NCI-H1395   176870\n",
       "4      6.239001       NCI-H1770   176870\n",
       "5      6.439408         DMS-114   176870\n",
       "6      5.322913       NCI-H1092   176870\n",
       "7      5.481543       NCI-H2141   176870\n",
       "8      5.701747        NCI-H345   176870\n",
       "9      5.829406        NCI-H446   176870\n",
       "10     5.880866         NCI-H82   176870\n",
       "11     4.641043         SK-N-DZ   176870\n",
       "12     4.946024          Calu-6   176870\n",
       "13     5.758914           LU-65   176870\n",
       "14     5.341703          SHP-77   176870\n",
       "15     5.841532         HCC1187   176870\n",
       "16     3.012397         HCC2157   176870\n",
       "17     5.332874         HCC2218   176870\n",
       "18     4.835373        BB49-HNC   176870\n",
       "19     4.694712           CPC-N   176870\n",
       "20     3.941827        EC-GI-10   176870\n",
       "21     5.978332            IM-9   176870\n",
       "22     5.410115         IST-SL1   176870\n",
       "23     3.414455       LB831-BLC   176870\n",
       "24     6.180606        LU-134-A   176870\n",
       "25     2.439368            MS-1   176870\n",
       "26     5.456650         MZ7-mel   176870\n",
       "27     4.749837       NCI-H510A   176870\n",
       "28     5.723651         SK-MM-2   176870\n",
       "29     0.339898            TE-1   176870\n",
       "...         ...             ...      ...\n",
       "15346  4.591031         WSU-NHL  9931953\n",
       "15347  4.343680        RCC10RGB  9931953\n",
       "15348  3.835645       KURAMOCHI  9931953\n",
       "15349  5.564257  Ramos-2G6-4C10  9931953\n",
       "15350  5.169653            CW-2  9931953\n",
       "15351  6.460933    COLO-320-HSR  9931953\n",
       "15352  4.072314        COLO-684  9931953\n",
       "15353  5.795011            CA46  9931953\n",
       "15354  5.644396              RL  9931953\n",
       "15355  5.926194          SNU-C1  9931953\n",
       "15356  5.134174           ST486  9931953\n",
       "15357  5.301860            BC-1  9931953\n",
       "15358  2.961610           CAS-1  9931953\n",
       "15359  6.051435         MFM-223  9931953\n",
       "15360  5.270021         LS-1034  9931953\n",
       "15361  6.315813          HDLM-2  9931953\n",
       "15362  2.480321       KNS-81-FD  9931953\n",
       "15363  5.127429            TE-6  9931953\n",
       "15364  5.362633           TE-12  9931953\n",
       "15365  3.340448         D-263MG  9931953\n",
       "15366  4.138311         D-502MG  9931953\n",
       "15367  3.409801            EW-3  9931953\n",
       "15368  4.045058            EW-1  9931953\n",
       "15369  3.775550           EW-18  9931953\n",
       "15370  6.038505           EW-24  9931953\n",
       "15371  3.864015           LAN-6  9931953\n",
       "15372  2.576201            NB10  9931953\n",
       "15373  5.989073             NB6  9931953\n",
       "15374  2.151274             NB5  9931953\n",
       "15375  2.973298            NB14  9931953\n",
       "\n",
       "[15376 rows x 3 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ImportData.importDataAsTable(True, False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|##########| 36994/36994 [04:23<00:00, 140.45it/s]\n"
     ]
    },
    {
     "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>IC50</th>\n",
       "      <th>cell_line</th>\n",
       "      <th>drug_id</th>\n",
       "      <th>cell-line-info_GDSC_Tissue_descriptor_1_aero_dig_tract</th>\n",
       "      <th>cell-line-info_GDSC_Tissue_descriptor_1_bone</th>\n",
       "      <th>cell-line-info_GDSC_Tissue_descriptor_1_breast</th>\n",
       "      <th>cell-line-info_GDSC_Tissue_descriptor_1_digestive_system</th>\n",
       "      <th>cell-line-info_GDSC_Tissue_descriptor_1_kidney</th>\n",
       "      <th>cell-line-info_GDSC_Tissue_descriptor_1_large_intestine</th>\n",
       "      <th>cell-line-info_GDSC_Tissue_descriptor_1_leukemia</th>\n",
       "      <th>...</th>\n",
       "      <th>cell-line_sangerENSG00000264575</th>\n",
       "      <th>cell-line_sangerENSG00000265060</th>\n",
       "      <th>cell-line_sangerENSG00000265246</th>\n",
       "      <th>cell-line_sangerENSG00000265298</th>\n",
       "      <th>cell-line_sangerENSG00000265480</th>\n",
       "      <th>cell-line_sangerENSG00000265929</th>\n",
       "      <th>cell-line_sangerENSG00000266066</th>\n",
       "      <th>cell-line_sangerENSG00000266282</th>\n",
       "      <th>cell-line_sangerENSG00000266433</th>\n",
       "      <th>cell-line_sangerENSG00000266753</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>0 rows × 36997 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty SparseDataFrame\n",
       "Columns: [IC50, cell_line, drug_id, cell-line-info_GDSC_Tissue_descriptor_1_aero_dig_tract, cell-line-info_GDSC_Tissue_descriptor_1_bone, cell-line-info_GDSC_Tissue_descriptor_1_breast, cell-line-info_GDSC_Tissue_descriptor_1_digestive_system, cell-line-info_GDSC_Tissue_descriptor_1_kidney, cell-line-info_GDSC_Tissue_descriptor_1_large_intestine, cell-line-info_GDSC_Tissue_descriptor_1_leukemia, cell-line-info_GDSC_Tissue_descriptor_1_lung, cell-line-info_GDSC_Tissue_descriptor_1_lung_NSCLC, cell-line-info_GDSC_Tissue_descriptor_1_lung_SCLC, cell-line-info_GDSC_Tissue_descriptor_1_lymphoma, cell-line-info_GDSC_Tissue_descriptor_1_myeloma, cell-line-info_GDSC_Tissue_descriptor_1_nervous_system, cell-line-info_GDSC_Tissue_descriptor_1_neuroblastoma, cell-line-info_GDSC_Tissue_descriptor_1_pancreas, cell-line-info_GDSC_Tissue_descriptor_1_skin, cell-line-info_GDSC_Tissue_descriptor_1_soft_tissue, cell-line-info_GDSC_Tissue_descriptor_1_thyroid, cell-line-info_GDSC_Tissue_descriptor_1_urogenital_system, cell-line-info_GDSC_Tissue_descriptor_1_nan, cell-line-info_GDSC_Tissue_descriptor_2_B_cell_leukemia, cell-line-info_GDSC_Tissue_descriptor_2_B_cell_lymphoma, cell-line-info_GDSC_Tissue_descriptor_2_Bladder, cell-line-info_GDSC_Tissue_descriptor_2_Burkitt_lymphoma, cell-line-info_GDSC_Tissue_descriptor_2_Hodgkin_lymphoma, cell-line-info_GDSC_Tissue_descriptor_2_Lung_other, cell-line-info_GDSC_Tissue_descriptor_2_T_cell_leukemia, cell-line-info_GDSC_Tissue_descriptor_2_acute_myeloid_leukaemia, cell-line-info_GDSC_Tissue_descriptor_2_adrenal_gland, cell-line-info_GDSC_Tissue_descriptor_2_anaplastic_large_cell_lymphoma, cell-line-info_GDSC_Tissue_descriptor_2_biliary_tract, cell-line-info_GDSC_Tissue_descriptor_2_bone_other, cell-line-info_GDSC_Tissue_descriptor_2_breast, cell-line-info_GDSC_Tissue_descriptor_2_cervix, cell-line-info_GDSC_Tissue_descriptor_2_chondrosarcoma, cell-line-info_GDSC_Tissue_descriptor_2_chronic_myeloid_leukaemia, cell-line-info_GDSC_Tissue_descriptor_2_digestive_system_other, cell-line-info_GDSC_Tissue_descriptor_2_endometrium, cell-line-info_GDSC_Tissue_descriptor_2_ewings_sarcoma, cell-line-info_GDSC_Tissue_descriptor_2_fibrosarcoma, cell-line-info_GDSC_Tissue_descriptor_2_glioma, cell-line-info_GDSC_Tissue_descriptor_2_haematopoietic_neoplasm_other, cell-line-info_GDSC_Tissue_descriptor_2_hairy_cell_leukaemia, cell-line-info_GDSC_Tissue_descriptor_2_head_and_neck, cell-line-info_GDSC_Tissue_descriptor_2_kidney, cell-line-info_GDSC_Tissue_descriptor_2_large_intestine, cell-line-info_GDSC_Tissue_descriptor_2_leukemia, cell-line-info_GDSC_Tissue_descriptor_2_liver, cell-line-info_GDSC_Tissue_descriptor_2_lung_NSCLC_adenocarcinoma, cell-line-info_GDSC_Tissue_descriptor_2_lung_NSCLC_carcinoid, cell-line-info_GDSC_Tissue_descriptor_2_lung_NSCLC_large_cell, cell-line-info_GDSC_Tissue_descriptor_2_lung_NSCLC_not_specified, cell-line-info_GDSC_Tissue_descriptor_2_lung_NSCLC_squamous_cell_carcinoma, cell-line-info_GDSC_Tissue_descriptor_2_lung_small_cell_carcinoma, cell-line-info_GDSC_Tissue_descriptor_2_lymphoblastic_T_cell_leukaemia, cell-line-info_GDSC_Tissue_descriptor_2_lymphoblastic_leukemia, cell-line-info_GDSC_Tissue_descriptor_2_lymphoid_neoplasm_other, cell-line-info_GDSC_Tissue_descriptor_2_medulloblastoma, cell-line-info_GDSC_Tissue_descriptor_2_melanoma, cell-line-info_GDSC_Tissue_descriptor_2_mesothelioma, cell-line-info_GDSC_Tissue_descriptor_2_myeloma, cell-line-info_GDSC_Tissue_descriptor_2_neuroblastoma, cell-line-info_GDSC_Tissue_descriptor_2_oesophagus, cell-line-info_GDSC_Tissue_descriptor_2_osteosarcoma, cell-line-info_GDSC_Tissue_descriptor_2_ovary, cell-line-info_GDSC_Tissue_descriptor_2_pancreas, cell-line-info_GDSC_Tissue_descriptor_2_prostate, cell-line-info_GDSC_Tissue_descriptor_2_rhabdomyosarcoma, cell-line-info_GDSC_Tissue_descriptor_2_skin_other, cell-line-info_GDSC_Tissue_descriptor_2_soft_tissue_other, cell-line-info_GDSC_Tissue_descriptor_2_stomach, cell-line-info_GDSC_Tissue_descriptor_2_testis, cell-line-info_GDSC_Tissue_descriptor_2_thyroid, cell-line-info_GDSC_Tissue_descriptor_2_urogenital_system_other, cell-line-info_GDSC_Tissue_descriptor_2_uterus, cell-line-info_GDSC_Tissue_descriptor_2_nan, cell-line-info_Cancer_Type_(matching_TCGA_label)_ACC, cell-line-info_Cancer_Type_(matching_TCGA_label)_ALL, cell-line-info_Cancer_Type_(matching_TCGA_label)_BLCA, cell-line-info_Cancer_Type_(matching_TCGA_label)_BRCA, cell-line-info_Cancer_Type_(matching_TCGA_label)_CESC, cell-line-info_Cancer_Type_(matching_TCGA_label)_CLL, cell-line-info_Cancer_Type_(matching_TCGA_label)_COAD/READ, cell-line-info_Cancer_Type_(matching_TCGA_label)_DLBC, cell-line-info_Cancer_Type_(matching_TCGA_label)_ESCA, cell-line-info_Cancer_Type_(matching_TCGA_label)_GBM, cell-line-info_Cancer_Type_(matching_TCGA_label)_HNSC, cell-line-info_Cancer_Type_(matching_TCGA_label)_KIRC, cell-line-info_Cancer_Type_(matching_TCGA_label)_LAML, cell-line-info_Cancer_Type_(matching_TCGA_label)_LCML, cell-line-info_Cancer_Type_(matching_TCGA_label)_LGG, cell-line-info_Cancer_Type_(matching_TCGA_label)_LIHC, cell-line-info_Cancer_Type_(matching_TCGA_label)_LUAD, cell-line-info_Cancer_Type_(matching_TCGA_label)_LUSC, cell-line-info_Cancer_Type_(matching_TCGA_label)_MB, cell-line-info_Cancer_Type_(matching_TCGA_label)_MESO, cell-line-info_Cancer_Type_(matching_TCGA_label)_MM, ...]\n",
       "Index: []\n",
       "\n",
       "[0 rows x 36997 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ImportData.importDataAsTable(False, True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|##########| 12134/12134 [00:29<00:00, 405.41it/s]\n",
      "100%|##########| 36994/36994 [04:27<00:00, 138.29it/s]\n"
     ]
    },
    {
     "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>IC50</th>\n",
       "      <th>cell_line</th>\n",
       "      <th>drug_id</th>\n",
       "      <th>binary_is_connected</th>\n",
       "      <th>finger_standard_1</th>\n",
       "      <th>finger_standard_2</th>\n",
       "      <th>finger_standard_3</th>\n",
       "      <th>finger_standard_4</th>\n",
       "      <th>finger_standard_5</th>\n",
       "      <th>finger_standard_6</th>\n",
       "      <th>...</th>\n",
       "      <th>cell-line_sangerENSG00000264575</th>\n",
       "      <th>cell-line_sangerENSG00000265060</th>\n",
       "      <th>cell-line_sangerENSG00000265246</th>\n",
       "      <th>cell-line_sangerENSG00000265298</th>\n",
       "      <th>cell-line_sangerENSG00000265480</th>\n",
       "      <th>cell-line_sangerENSG00000265929</th>\n",
       "      <th>cell-line_sangerENSG00000266066</th>\n",
       "      <th>cell-line_sangerENSG00000266282</th>\n",
       "      <th>cell-line_sangerENSG00000266433</th>\n",
       "      <th>cell-line_sangerENSG00000266753</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5.457453</td>\n",
       "      <td>ES3</td>\n",
       "      <td>176870</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>2.712723</td>\n",
       "      <td>ES3</td>\n",
       "      <td>5284616</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>3.624351</td>\n",
       "      <td>ES3</td>\n",
       "      <td>5329102</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>372</th>\n",
       "      <td>5.741999</td>\n",
       "      <td>ES3</td>\n",
       "      <td>10461815</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>496</th>\n",
       "      <td>1.465161</td>\n",
       "      <td>ES3</td>\n",
       "      <td>462382</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>620</th>\n",
       "      <td>2.230729</td>\n",
       "      <td>ES3</td>\n",
       "      <td>36314</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>744</th>\n",
       "      <td>6.262880</td>\n",
       "      <td>ES3</td>\n",
       "      <td>442972</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>868</th>\n",
       "      <td>3.840777</td>\n",
       "      <td>ES3</td>\n",
       "      <td>11676786</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>992</th>\n",
       "      <td>2.934077</td>\n",
       "      <td>ES3</td>\n",
       "      <td>216239</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1116</th>\n",
       "      <td>3.602096</td>\n",
       "      <td>ES3</td>\n",
       "      <td>5494449</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1240</th>\n",
       "      <td>5.337817</td>\n",
       "      <td>ES3</td>\n",
       "      <td>5291</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1364</th>\n",
       "      <td>4.674520</td>\n",
       "      <td>ES3</td>\n",
       "      <td>16038120</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1488</th>\n",
       "      <td>5.924602</td>\n",
       "      <td>ES3</td>\n",
       "      <td>11496366</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1612</th>\n",
       "      <td>2.860227</td>\n",
       "      <td>ES3</td>\n",
       "      <td>10302451</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1736</th>\n",
       "      <td>5.345504</td>\n",
       "      <td>ES3</td>\n",
       "      <td>76044</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1860</th>\n",
       "      <td>2.750826</td>\n",
       "      <td>ES3</td>\n",
       "      <td>16760646</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1984</th>\n",
       "      <td>4.078735</td>\n",
       "      <td>ES3</td>\n",
       "      <td>3062316</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2108</th>\n",
       "      <td>2.858726</td>\n",
       "      <td>ES3</td>\n",
       "      <td>5311510</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2232</th>\n",
       "      <td>-0.045722</td>\n",
       "      <td>ES3</td>\n",
       "      <td>644215</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2356</th>\n",
       "      <td>2.556418</td>\n",
       "      <td>ES3</td>\n",
       "      <td>24825971</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2480</th>\n",
       "      <td>6.102112</td>\n",
       "      <td>ES3</td>\n",
       "      <td>9549184</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2604</th>\n",
       "      <td>5.143049</td>\n",
       "      <td>ES3</td>\n",
       "      <td>11844351</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2728</th>\n",
       "      <td>6.076867</td>\n",
       "      <td>ES3</td>\n",
       "      <td>49821040</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2852</th>\n",
       "      <td>2.638894</td>\n",
       "      <td>ES3</td>\n",
       "      <td>11364421</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2976</th>\n",
       "      <td>4.348722</td>\n",
       "      <td>ES3</td>\n",
       "      <td>10390396</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3100</th>\n",
       "      <td>2.186483</td>\n",
       "      <td>ES3</td>\n",
       "      <td>20635522</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3224</th>\n",
       "      <td>5.166096</td>\n",
       "      <td>ES3</td>\n",
       "      <td>4993</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3348</th>\n",
       "      <td>3.899734</td>\n",
       "      <td>ES3</td>\n",
       "      <td>49836027</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3472</th>\n",
       "      <td>1.244741</td>\n",
       "      <td>ES3</td>\n",
       "      <td>10172943</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3596</th>\n",
       "      <td>3.021673</td>\n",
       "      <td>ES3</td>\n",
       "      <td>15983966</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11779</th>\n",
       "      <td>6.196443</td>\n",
       "      <td>NB14</td>\n",
       "      <td>11960529</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11903</th>\n",
       "      <td>2.859645</td>\n",
       "      <td>NB14</td>\n",
       "      <td>5328940</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12027</th>\n",
       "      <td>6.250331</td>\n",
       "      <td>NB14</td>\n",
       "      <td>216326</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12151</th>\n",
       "      <td>-0.302999</td>\n",
       "      <td>NB14</td>\n",
       "      <td>6450551</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12275</th>\n",
       "      <td>-4.939001</td>\n",
       "      <td>NB14</td>\n",
       "      <td>126565</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12399</th>\n",
       "      <td>2.780563</td>\n",
       "      <td>NB14</td>\n",
       "      <td>6505803</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12523</th>\n",
       "      <td>5.355499</td>\n",
       "      <td>NB14</td>\n",
       "      <td>10341154</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12647</th>\n",
       "      <td>2.638917</td>\n",
       "      <td>NB14</td>\n",
       "      <td>11667893</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12771</th>\n",
       "      <td>3.490883</td>\n",
       "      <td>NB14</td>\n",
       "      <td>5278396</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12895</th>\n",
       "      <td>4.158341</td>\n",
       "      <td>NB14</td>\n",
       "      <td>10184653</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13019</th>\n",
       "      <td>7.045438</td>\n",
       "      <td>NB14</td>\n",
       "      <td>24776445</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13143</th>\n",
       "      <td>6.391518</td>\n",
       "      <td>NB14</td>\n",
       "      <td>24180719</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13267</th>\n",
       "      <td>0.250380</td>\n",
       "      <td>NB14</td>\n",
       "      <td>10077147</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13391</th>\n",
       "      <td>1.695502</td>\n",
       "      <td>NB14</td>\n",
       "      <td>11327430</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13515</th>\n",
       "      <td>4.077675</td>\n",
       "      <td>NB14</td>\n",
       "      <td>156422</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13639</th>\n",
       "      <td>4.374883</td>\n",
       "      <td>NB14</td>\n",
       "      <td>11624601</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13763</th>\n",
       "      <td>2.686497</td>\n",
       "      <td>NB14</td>\n",
       "      <td>10384072</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13887</th>\n",
       "      <td>6.489096</td>\n",
       "      <td>NB14</td>\n",
       "      <td>11433190</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14011</th>\n",
       "      <td>5.292950</td>\n",
       "      <td>NB14</td>\n",
       "      <td>1401</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14135</th>\n",
       "      <td>-0.295429</td>\n",
       "      <td>NB14</td>\n",
       "      <td>9914412</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14259</th>\n",
       "      <td>0.787787</td>\n",
       "      <td>NB14</td>\n",
       "      <td>44450571</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14383</th>\n",
       "      <td>-1.186377</td>\n",
       "      <td>NB14</td>\n",
       "      <td>5330286</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14507</th>\n",
       "      <td>0.205165</td>\n",
       "      <td>NB14</td>\n",
       "      <td>17755052</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14631</th>\n",
       "      <td>-0.996696</td>\n",
       "      <td>NB14</td>\n",
       "      <td>9826528</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14755</th>\n",
       "      <td>6.542188</td>\n",
       "      <td>NB14</td>\n",
       "      <td>11316960</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14879</th>\n",
       "      <td>5.585778</td>\n",
       "      <td>NB14</td>\n",
       "      <td>10127622</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15003</th>\n",
       "      <td>6.396768</td>\n",
       "      <td>NB14</td>\n",
       "      <td>46883536</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15127</th>\n",
       "      <td>3.024360</td>\n",
       "      <td>NB14</td>\n",
       "      <td>11609586</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15251</th>\n",
       "      <td>-2.571121</td>\n",
       "      <td>NB14</td>\n",
       "      <td>11455910</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15375</th>\n",
       "      <td>2.973298</td>\n",
       "      <td>NB14</td>\n",
       "      <td>9931953</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>15376 rows × 49131 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           IC50 cell_line   drug_id  binary_is_connected  finger_standard_1  \\\n",
       "0      5.457453       ES3    176870                 True              False   \n",
       "124    2.712723       ES3   5284616                 True              False   \n",
       "248    3.624351       ES3   5329102                 True              False   \n",
       "372    5.741999       ES3  10461815                 True              False   \n",
       "496    1.465161       ES3    462382                 True              False   \n",
       "620    2.230729       ES3     36314                 True              False   \n",
       "744    6.262880       ES3    442972                 True              False   \n",
       "868    3.840777       ES3  11676786                 True              False   \n",
       "992    2.934077       ES3    216239                 True              False   \n",
       "1116   3.602096       ES3   5494449                 True              False   \n",
       "1240   5.337817       ES3      5291                 True              False   \n",
       "1364   4.674520       ES3  16038120                 True              False   \n",
       "1488   5.924602       ES3  11496366                 True              False   \n",
       "1612   2.860227       ES3  10302451                 True              False   \n",
       "1736   5.345504       ES3     76044                 True               True   \n",
       "1860   2.750826       ES3  16760646                 True              False   \n",
       "1984   4.078735       ES3   3062316                 True              False   \n",
       "2108   2.858726       ES3   5311510                 True              False   \n",
       "2232  -0.045722       ES3    644215                 True              False   \n",
       "2356   2.556418       ES3  24825971                 True              False   \n",
       "2480   6.102112       ES3   9549184                 True              False   \n",
       "2604   5.143049       ES3  11844351                 True              False   \n",
       "2728   6.076867       ES3  49821040                 True              False   \n",
       "2852   2.638894       ES3  11364421                 True              False   \n",
       "2976   4.348722       ES3  10390396                 True              False   \n",
       "3100   2.186483       ES3  20635522                 True              False   \n",
       "3224   5.166096       ES3      4993                 True              False   \n",
       "3348   3.899734       ES3  49836027                 True              False   \n",
       "3472   1.244741       ES3  10172943                 True              False   \n",
       "3596   3.021673       ES3  15983966                 True              False   \n",
       "...         ...       ...       ...                  ...                ...   \n",
       "11779  6.196443      NB14  11960529                 True              False   \n",
       "11903  2.859645      NB14   5328940                 True              False   \n",
       "12027  6.250331      NB14    216326                 True              False   \n",
       "12151 -0.302999      NB14   6450551                 True              False   \n",
       "12275 -4.939001      NB14    126565                 True              False   \n",
       "12399  2.780563      NB14   6505803                 True              False   \n",
       "12523  5.355499      NB14  10341154                 True              False   \n",
       "12647  2.638917      NB14  11667893                 True              False   \n",
       "12771  3.490883      NB14   5278396                 True              False   \n",
       "12895  4.158341      NB14  10184653                 True              False   \n",
       "13019  7.045438      NB14  24776445                 True              False   \n",
       "13143  6.391518      NB14  24180719                 True              False   \n",
       "13267  0.250380      NB14  10077147                 True              False   \n",
       "13391  1.695502      NB14  11327430                 True              False   \n",
       "13515  4.077675      NB14    156422                 True              False   \n",
       "13639  4.374883      NB14  11624601                 True              False   \n",
       "13763  2.686497      NB14  10384072                 True              False   \n",
       "13887  6.489096      NB14  11433190                 True              False   \n",
       "14011  5.292950      NB14      1401                 True              False   \n",
       "14135 -0.295429      NB14   9914412                 True              False   \n",
       "14259  0.787787      NB14  44450571                 True               True   \n",
       "14383 -1.186377      NB14   5330286                 True              False   \n",
       "14507  0.205165      NB14  17755052                 True              False   \n",
       "14631 -0.996696      NB14   9826528                 True              False   \n",
       "14755  6.542188      NB14  11316960                 True              False   \n",
       "14879  5.585778      NB14  10127622                 True              False   \n",
       "15003  6.396768      NB14  46883536                 True              False   \n",
       "15127  3.024360      NB14  11609586                 True              False   \n",
       "15251 -2.571121      NB14  11455910                 True              False   \n",
       "15375  2.973298      NB14   9931953                False              False   \n",
       "\n",
       "       finger_standard_2  finger_standard_3  finger_standard_4  \\\n",
       "0                   True              False              False   \n",
       "124                False              False               True   \n",
       "248                False              False              False   \n",
       "372                False              False              False   \n",
       "496                False              False              False   \n",
       "620                False              False               True   \n",
       "744                False              False               True   \n",
       "868                False              False              False   \n",
       "992                False              False              False   \n",
       "1116                True              False              False   \n",
       "1240                True              False              False   \n",
       "1364                True              False              False   \n",
       "1488               False              False              False   \n",
       "1612                True              False              False   \n",
       "1736               False              False              False   \n",
       "1860               False              False              False   \n",
       "1984                True              False              False   \n",
       "2108                True              False              False   \n",
       "2232                True              False              False   \n",
       "2356                True              False              False   \n",
       "2480                True              False              False   \n",
       "2604                True              False              False   \n",
       "2728                True              False              False   \n",
       "2852                True              False               True   \n",
       "2976               False              False               True   \n",
       "3100               False              False              False   \n",
       "3224                True              False              False   \n",
       "3348               False              False              False   \n",
       "3472               False              False              False   \n",
       "3596                True              False              False   \n",
       "...                  ...                ...                ...   \n",
       "11779               True              False              False   \n",
       "11903              False              False              False   \n",
       "12027              False              False              False   \n",
       "12151              False              False              False   \n",
       "12275              False              False              False   \n",
       "12399              False              False               True   \n",
       "12523               True              False              False   \n",
       "12647              False              False              False   \n",
       "12771              False              False              False   \n",
       "12895               True              False              False   \n",
       "13019              False              False              False   \n",
       "13143               True              False              False   \n",
       "13267               True              False              False   \n",
       "13391              False               True              False   \n",
       "13515              False              False              False   \n",
       "13639              False              False              False   \n",
       "13763              False              False              False   \n",
       "13887              False              False              False   \n",
       "14011               True              False              False   \n",
       "14135               True              False              False   \n",
       "14259              False              False              False   \n",
       "14383               True              False              False   \n",
       "14507               True               True              False   \n",
       "14631              False              False              False   \n",
       "14755              False              False              False   \n",
       "14879               True              False              False   \n",
       "15003              False              False              False   \n",
       "15127              False              False              False   \n",
       "15251              False              False              False   \n",
       "15375              False              False              False   \n",
       "\n",
       "       finger_standard_5  finger_standard_6               ...                 \\\n",
       "0                  False              False               ...                  \n",
       "124                False               True               ...                  \n",
       "248                False              False               ...                  \n",
       "372                False               True               ...                  \n",
       "496                False              False               ...                  \n",
       "620                False               True               ...                  \n",
       "744                False               True               ...                  \n",
       "868                False              False               ...                  \n",
       "992                False              False               ...                  \n",
       "1116               False              False               ...                  \n",
       "1240               False              False               ...                  \n",
       "1364               False              False               ...                  \n",
       "1488               False              False               ...                  \n",
       "1612               False              False               ...                  \n",
       "1736                True              False               ...                  \n",
       "1860               False              False               ...                  \n",
       "1984               False              False               ...                  \n",
       "2108               False              False               ...                  \n",
       "2232               False              False               ...                  \n",
       "2356               False              False               ...                  \n",
       "2480               False              False               ...                  \n",
       "2604               False              False               ...                  \n",
       "2728               False              False               ...                  \n",
       "2852               False              False               ...                  \n",
       "2976               False              False               ...                  \n",
       "3100               False              False               ...                  \n",
       "3224               False              False               ...                  \n",
       "3348               False              False               ...                  \n",
       "3472               False              False               ...                  \n",
       "3596               False              False               ...                  \n",
       "...                  ...                ...               ...                  \n",
       "11779              False              False               ...                  \n",
       "11903              False              False               ...                  \n",
       "12027              False              False               ...                  \n",
       "12151              False              False               ...                  \n",
       "12275              False              False               ...                  \n",
       "12399              False               True               ...                  \n",
       "12523              False              False               ...                  \n",
       "12647              False              False               ...                  \n",
       "12771              False              False               ...                  \n",
       "12895              False              False               ...                  \n",
       "13019              False              False               ...                  \n",
       "13143               True              False               ...                  \n",
       "13267              False              False               ...                  \n",
       "13391              False              False               ...                  \n",
       "13515              False              False               ...                  \n",
       "13639              False              False               ...                  \n",
       "13763              False              False               ...                  \n",
       "13887              False              False               ...                  \n",
       "14011              False              False               ...                  \n",
       "14135              False              False               ...                  \n",
       "14259              False              False               ...                  \n",
       "14383              False              False               ...                  \n",
       "14507              False              False               ...                  \n",
       "14631              False              False               ...                  \n",
       "14755              False               True               ...                  \n",
       "14879              False              False               ...                  \n",
       "15003              False              False               ...                  \n",
       "15127              False              False               ...                  \n",
       "15251              False              False               ...                  \n",
       "15375              False              False               ...                  \n",
       "\n",
       "       cell-line_sangerENSG00000264575  cell-line_sangerENSG00000265060  \\\n",
       "0                                    5                                3   \n",
       "124                                  5                                3   \n",
       "248                                  5                                3   \n",
       "372                                  5                                3   \n",
       "496                                  5                                3   \n",
       "620                                  5                                3   \n",
       "744                                  5                                3   \n",
       "868                                  5                                3   \n",
       "992                                  5                                3   \n",
       "1116                                 5                                3   \n",
       "1240                                 5                                3   \n",
       "1364                                 5                                3   \n",
       "1488                                 5                                3   \n",
       "1612                                 5                                3   \n",
       "1736                                 5                                3   \n",
       "1860                                 5                                3   \n",
       "1984                                 5                                3   \n",
       "2108                                 5                                3   \n",
       "2232                                 5                                3   \n",
       "2356                                 5                                3   \n",
       "2480                                 5                                3   \n",
       "2604                                 5                                3   \n",
       "2728                                 5                                3   \n",
       "2852                                 5                                3   \n",
       "2976                                 5                                3   \n",
       "3100                                 5                                3   \n",
       "3224                                 5                                3   \n",
       "3348                                 5                                3   \n",
       "3472                                 5                                3   \n",
       "3596                                 5                                3   \n",
       "...                                ...                              ...   \n",
       "11779                                7                                3   \n",
       "11903                                7                                3   \n",
       "12027                                7                                3   \n",
       "12151                                7                                3   \n",
       "12275                                7                                3   \n",
       "12399                                7                                3   \n",
       "12523                                7                                3   \n",
       "12647                                7                                3   \n",
       "12771                                7                                3   \n",
       "12895                                7                                3   \n",
       "13019                                7                                3   \n",
       "13143                                7                                3   \n",
       "13267                                7                                3   \n",
       "13391                                7                                3   \n",
       "13515                                7                                3   \n",
       "13639                                7                                3   \n",
       "13763                                7                                3   \n",
       "13887                                7                                3   \n",
       "14011                                7                                3   \n",
       "14135                                7                                3   \n",
       "14259                                7                                3   \n",
       "14383                                7                                3   \n",
       "14507                                7                                3   \n",
       "14631                                7                                3   \n",
       "14755                                7                                3   \n",
       "14879                                7                                3   \n",
       "15003                                7                                3   \n",
       "15127                                7                                3   \n",
       "15251                                7                                3   \n",
       "15375                                7                                3   \n",
       "\n",
       "       cell-line_sangerENSG00000265246  cell-line_sangerENSG00000265298  \\\n",
       "0                                    3                                8   \n",
       "124                                  3                                8   \n",
       "248                                  3                                8   \n",
       "372                                  3                                8   \n",
       "496                                  3                                8   \n",
       "620                                  3                                8   \n",
       "744                                  3                                8   \n",
       "868                                  3                                8   \n",
       "992                                  3                                8   \n",
       "1116                                 3                                8   \n",
       "1240                                 3                                8   \n",
       "1364                                 3                                8   \n",
       "1488                                 3                                8   \n",
       "1612                                 3                                8   \n",
       "1736                                 3                                8   \n",
       "1860                                 3                                8   \n",
       "1984                                 3                                8   \n",
       "2108                                 3                                8   \n",
       "2232                                 3                                8   \n",
       "2356                                 3                                8   \n",
       "2480                                 3                                8   \n",
       "2604                                 3                                8   \n",
       "2728                                 3                                8   \n",
       "2852                                 3                                8   \n",
       "2976                                 3                                8   \n",
       "3100                                 3                                8   \n",
       "3224                                 3                                8   \n",
       "3348                                 3                                8   \n",
       "3472                                 3                                8   \n",
       "3596                                 3                                8   \n",
       "...                                ...                              ...   \n",
       "11779                                3                                8   \n",
       "11903                                3                                8   \n",
       "12027                                3                                8   \n",
       "12151                                3                                8   \n",
       "12275                                3                                8   \n",
       "12399                                3                                8   \n",
       "12523                                3                                8   \n",
       "12647                                3                                8   \n",
       "12771                                3                                8   \n",
       "12895                                3                                8   \n",
       "13019                                3                                8   \n",
       "13143                                3                                8   \n",
       "13267                                3                                8   \n",
       "13391                                3                                8   \n",
       "13515                                3                                8   \n",
       "13639                                3                                8   \n",
       "13763                                3                                8   \n",
       "13887                                3                                8   \n",
       "14011                                3                                8   \n",
       "14135                                3                                8   \n",
       "14259                                3                                8   \n",
       "14383                                3                                8   \n",
       "14507                                3                                8   \n",
       "14631                                3                                8   \n",
       "14755                                3                                8   \n",
       "14879                                3                                8   \n",
       "15003                                3                                8   \n",
       "15127                                3                                8   \n",
       "15251                                3                                8   \n",
       "15375                                3                                8   \n",
       "\n",
       "       cell-line_sangerENSG00000265480  cell-line_sangerENSG00000265929  \\\n",
       "0                                    3                                2   \n",
       "124                                  3                                2   \n",
       "248                                  3                                2   \n",
       "372                                  3                                2   \n",
       "496                                  3                                2   \n",
       "620                                  3                                2   \n",
       "744                                  3                                2   \n",
       "868                                  3                                2   \n",
       "992                                  3                                2   \n",
       "1116                                 3                                2   \n",
       "1240                                 3                                2   \n",
       "1364                                 3                                2   \n",
       "1488                                 3                                2   \n",
       "1612                                 3                                2   \n",
       "1736                                 3                                2   \n",
       "1860                                 3                                2   \n",
       "1984                                 3                                2   \n",
       "2108                                 3                                2   \n",
       "2232                                 3                                2   \n",
       "2356                                 3                                2   \n",
       "2480                                 3                                2   \n",
       "2604                                 3                                2   \n",
       "2728                                 3                                2   \n",
       "2852                                 3                                2   \n",
       "2976                                 3                                2   \n",
       "3100                                 3                                2   \n",
       "3224                                 3                                2   \n",
       "3348                                 3                                2   \n",
       "3472                                 3                                2   \n",
       "3596                                 3                                2   \n",
       "...                                ...                              ...   \n",
       "11779                                3                                3   \n",
       "11903                                3                                3   \n",
       "12027                                3                                3   \n",
       "12151                                3                                3   \n",
       "12275                                3                                3   \n",
       "12399                                3                                3   \n",
       "12523                                3                                3   \n",
       "12647                                3                                3   \n",
       "12771                                3                                3   \n",
       "12895                                3                                3   \n",
       "13019                                3                                3   \n",
       "13143                                3                                3   \n",
       "13267                                3                                3   \n",
       "13391                                3                                3   \n",
       "13515                                3                                3   \n",
       "13639                                3                                3   \n",
       "13763                                3                                3   \n",
       "13887                                3                                3   \n",
       "14011                                3                                3   \n",
       "14135                                3                                3   \n",
       "14259                                3                                3   \n",
       "14383                                3                                3   \n",
       "14507                                3                                3   \n",
       "14631                                3                                3   \n",
       "14755                                3                                3   \n",
       "14879                                3                                3   \n",
       "15003                                3                                3   \n",
       "15127                                3                                3   \n",
       "15251                                3                                3   \n",
       "15375                                3                                3   \n",
       "\n",
       "       cell-line_sangerENSG00000266066  cell-line_sangerENSG00000266282  \\\n",
       "0                                    3                                9   \n",
       "124                                  3                                9   \n",
       "248                                  3                                9   \n",
       "372                                  3                                9   \n",
       "496                                  3                                9   \n",
       "620                                  3                                9   \n",
       "744                                  3                                9   \n",
       "868                                  3                                9   \n",
       "992                                  3                                9   \n",
       "1116                                 3                                9   \n",
       "1240                                 3                                9   \n",
       "1364                                 3                                9   \n",
       "1488                                 3                                9   \n",
       "1612                                 3                                9   \n",
       "1736                                 3                                9   \n",
       "1860                                 3                                9   \n",
       "1984                                 3                                9   \n",
       "2108                                 3                                9   \n",
       "2232                                 3                                9   \n",
       "2356                                 3                                9   \n",
       "2480                                 3                                9   \n",
       "2604                                 3                                9   \n",
       "2728                                 3                                9   \n",
       "2852                                 3                                9   \n",
       "2976                                 3                                9   \n",
       "3100                                 3                                9   \n",
       "3224                                 3                                9   \n",
       "3348                                 3                                9   \n",
       "3472                                 3                                9   \n",
       "3596                                 3                                9   \n",
       "...                                ...                              ...   \n",
       "11779                                3                                9   \n",
       "11903                                3                                9   \n",
       "12027                                3                                9   \n",
       "12151                                3                                9   \n",
       "12275                                3                                9   \n",
       "12399                                3                                9   \n",
       "12523                                3                                9   \n",
       "12647                                3                                9   \n",
       "12771                                3                                9   \n",
       "12895                                3                                9   \n",
       "13019                                3                                9   \n",
       "13143                                3                                9   \n",
       "13267                                3                                9   \n",
       "13391                                3                                9   \n",
       "13515                                3                                9   \n",
       "13639                                3                                9   \n",
       "13763                                3                                9   \n",
       "13887                                3                                9   \n",
       "14011                                3                                9   \n",
       "14135                                3                                9   \n",
       "14259                                3                                9   \n",
       "14383                                3                                9   \n",
       "14507                                3                                9   \n",
       "14631                                3                                9   \n",
       "14755                                3                                9   \n",
       "14879                                3                                9   \n",
       "15003                                3                                9   \n",
       "15127                                3                                9   \n",
       "15251                                3                                9   \n",
       "15375                                3                                9   \n",
       "\n",
       "       cell-line_sangerENSG00000266433  cell-line_sangerENSG00000266753  \n",
       "0                                    3                                8  \n",
       "124                                  3                                8  \n",
       "248                                  3                                8  \n",
       "372                                  3                                8  \n",
       "496                                  3                                8  \n",
       "620                                  3                                8  \n",
       "744                                  3                                8  \n",
       "868                                  3                                8  \n",
       "992                                  3                                8  \n",
       "1116                                 3                                8  \n",
       "1240                                 3                                8  \n",
       "1364                                 3                                8  \n",
       "1488                                 3                                8  \n",
       "1612                                 3                                8  \n",
       "1736                                 3                                8  \n",
       "1860                                 3                                8  \n",
       "1984                                 3                                8  \n",
       "2108                                 3                                8  \n",
       "2232                                 3                                8  \n",
       "2356                                 3                                8  \n",
       "2480                                 3                                8  \n",
       "2604                                 3                                8  \n",
       "2728                                 3                                8  \n",
       "2852                                 3                                8  \n",
       "2976                                 3                                8  \n",
       "3100                                 3                                8  \n",
       "3224                                 3                                8  \n",
       "3348                                 3                                8  \n",
       "3472                                 3                                8  \n",
       "3596                                 3                                8  \n",
       "...                                ...                              ...  \n",
       "11779                                3                                7  \n",
       "11903                                3                                7  \n",
       "12027                                3                                7  \n",
       "12151                                3                                7  \n",
       "12275                                3                                7  \n",
       "12399                                3                                7  \n",
       "12523                                3                                7  \n",
       "12647                                3                                7  \n",
       "12771                                3                                7  \n",
       "12895                                3                                7  \n",
       "13019                                3                                7  \n",
       "13143                                3                                7  \n",
       "13267                                3                                7  \n",
       "13391                                3                                7  \n",
       "13515                                3                                7  \n",
       "13639                                3                                7  \n",
       "13763                                3                                7  \n",
       "13887                                3                                7  \n",
       "14011                                3                                7  \n",
       "14135                                3                                7  \n",
       "14259                                3                                7  \n",
       "14383                                3                                7  \n",
       "14507                                3                                7  \n",
       "14631                                3                                7  \n",
       "14755                                3                                7  \n",
       "14879                                3                                7  \n",
       "15003                                3                                7  \n",
       "15127                                3                                7  \n",
       "15251                                3                                7  \n",
       "15375                                3                                7  \n",
       "\n",
       "[15376 rows x 49131 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ImportData.importDataAsTable(True, True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "#from sklearn.ensemble import RandomForestRegressor\n",
    "#regr = RandomForestRegressor(max_depth=2, random_state=0, n_estimators=1)\n",
    "#regr.fit(df.select_dtypes(exclude=['object']).loc[:, df.select_dtypes(exclude=['object']).columns != 'IC50'], df[\"IC50\"])"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}