LINCS_MOA_FullCurated_RandomForest_Gimm4_output.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## LINCS MOA prediction in LINCS Curated using Random Forest Classifier"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from sklearn.preprocessing  import StandardScaler\n",
    "from sklearn.model_selection import train_test_split\n",
    "from sklearn.ensemble import RandomForestClassifier\n",
    "from sklearn.metrics import confusion_matrix,classification_report,accuracy_score"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "file_prostate=pd.read_hdf(\"/opt/raid10/genomics/rashid/GCN/data/GSE92742_fully_restricted.hdf\")"
   ]
  },
  {
   "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></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>AARS</th>\n",
       "      <th>ABCB6</th>\n",
       "      <th>ABCC5</th>\n",
       "      <th>ABCF1</th>\n",
       "      <th>ABCF3</th>\n",
       "      <th>ABHD4</th>\n",
       "      <th>ABHD6</th>\n",
       "      <th>ABL1</th>\n",
       "      <th>ACAA1</th>\n",
       "      <th>ACAT2</th>\n",
       "      <th>...</th>\n",
       "      <th>ZMIZ1</th>\n",
       "      <th>ZMYM2</th>\n",
       "      <th>ZNF131</th>\n",
       "      <th>ZNF274</th>\n",
       "      <th>ZNF318</th>\n",
       "      <th>ZNF395</th>\n",
       "      <th>ZNF451</th>\n",
       "      <th>ZNF586</th>\n",
       "      <th>ZNF589</th>\n",
       "      <th>ZW10</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pert_id</th>\n",
       "      <th>pert_name</th>\n",
       "      <th>cell_id</th>\n",
       "      <th>primary_site</th>\n",
       "      <th>subtype</th>\n",
       "      <th>moa</th>\n",
       "      <th>Fold</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 rowspan=\"30\" valign=\"top\">BRD-A00520476</th>\n",
       "      <th rowspan=\"30\" valign=\"top\">AF-DX-116</th>\n",
       "      <th rowspan=\"3\" valign=\"top\">A375</th>\n",
       "      <th rowspan=\"3\" valign=\"top\">skin</th>\n",
       "      <th rowspan=\"3\" valign=\"top\">malignant melanoma</th>\n",
       "      <th rowspan=\"3\" valign=\"top\">Acetylcholine receptor antagonist</th>\n",
       "      <th>9</th>\n",
       "      <td>-1.5594</td>\n",
       "      <td>6.0608</td>\n",
       "      <td>-1.1950</td>\n",
       "      <td>-0.6894</td>\n",
       "      <td>0.0593</td>\n",
       "      <td>-0.7873</td>\n",
       "      <td>-0.0631</td>\n",
       "      <td>-1.1099</td>\n",
       "      <td>-0.6703</td>\n",
       "      <td>0.685800</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.334500</td>\n",
       "      <td>1.4356</td>\n",
       "      <td>-0.0628</td>\n",
       "      <td>-0.0721</td>\n",
       "      <td>-0.8695</td>\n",
       "      <td>-0.5413</td>\n",
       "      <td>-0.8752</td>\n",
       "      <td>0.2187</td>\n",
       "      <td>0.8570</td>\n",
       "      <td>0.5025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>-4.3904</td>\n",
       "      <td>0.7553</td>\n",
       "      <td>1.4643</td>\n",
       "      <td>0.8863</td>\n",
       "      <td>1.1585</td>\n",
       "      <td>3.5089</td>\n",
       "      <td>-0.5471</td>\n",
       "      <td>-0.8222</td>\n",
       "      <td>1.8885</td>\n",
       "      <td>-4.767100</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.447600</td>\n",
       "      <td>-0.5985</td>\n",
       "      <td>-0.8048</td>\n",
       "      <td>0.7390</td>\n",
       "      <td>1.2311</td>\n",
       "      <td>1.2392</td>\n",
       "      <td>1.4154</td>\n",
       "      <td>0.0942</td>\n",
       "      <td>0.6538</td>\n",
       "      <td>-0.9249</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1.0402</td>\n",
       "      <td>1.6024</td>\n",
       "      <td>6.8079</td>\n",
       "      <td>1.5701</td>\n",
       "      <td>1.0405</td>\n",
       "      <td>-1.6266</td>\n",
       "      <td>-2.7036</td>\n",
       "      <td>-1.3499</td>\n",
       "      <td>-0.3415</td>\n",
       "      <td>-2.686000</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.943700</td>\n",
       "      <td>-1.2552</td>\n",
       "      <td>-2.3513</td>\n",
       "      <td>2.2450</td>\n",
       "      <td>2.1778</td>\n",
       "      <td>0.6906</td>\n",
       "      <td>1.9346</td>\n",
       "      <td>1.8513</td>\n",
       "      <td>0.9545</td>\n",
       "      <td>-2.4527</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"6\" valign=\"top\">A549</th>\n",
       "      <th rowspan=\"6\" valign=\"top\">lung</th>\n",
       "      <th rowspan=\"6\" valign=\"top\">non small cell lung cancer| carcinoma</th>\n",
       "      <th rowspan=\"6\" valign=\"top\">Acetylcholine receptor antagonist</th>\n",
       "      <th>8</th>\n",
       "      <td>-0.2390</td>\n",
       "      <td>0.4851</td>\n",
       "      <td>0.2844</td>\n",
       "      <td>-1.0092</td>\n",
       "      <td>-0.9006</td>\n",
       "      <td>-0.2332</td>\n",
       "      <td>-0.4921</td>\n",
       "      <td>0.4718</td>\n",
       "      <td>0.8034</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.146000</td>\n",
       "      <td>-0.2967</td>\n",
       "      <td>0.8119</td>\n",
       "      <td>-0.6223</td>\n",
       "      <td>-0.9409</td>\n",
       "      <td>0.3434</td>\n",
       "      <td>-0.0792</td>\n",
       "      <td>0.3802</td>\n",
       "      <td>-0.5759</td>\n",
       "      <td>-0.2426</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.5787</td>\n",
       "      <td>1.2204</td>\n",
       "      <td>-0.5552</td>\n",
       "      <td>0.1837</td>\n",
       "      <td>-0.4781</td>\n",
       "      <td>0.5837</td>\n",
       "      <td>-0.3616</td>\n",
       "      <td>0.3630</td>\n",
       "      <td>-0.4275</td>\n",
       "      <td>0.231100</td>\n",
       "      <td>...</td>\n",
       "      <td>1.450900</td>\n",
       "      <td>0.8935</td>\n",
       "      <td>-0.2784</td>\n",
       "      <td>1.9705</td>\n",
       "      <td>-1.0668</td>\n",
       "      <td>-1.6562</td>\n",
       "      <td>-0.6090</td>\n",
       "      <td>-1.4161</td>\n",
       "      <td>0.8576</td>\n",
       "      <td>0.3100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-1.3419</td>\n",
       "      <td>1.1074</td>\n",
       "      <td>0.7377</td>\n",
       "      <td>0.5522</td>\n",
       "      <td>-1.2875</td>\n",
       "      <td>0.8788</td>\n",
       "      <td>-0.2627</td>\n",
       "      <td>0.1010</td>\n",
       "      <td>-0.4230</td>\n",
       "      <td>0.661300</td>\n",
       "      <td>...</td>\n",
       "      <td>1.034700</td>\n",
       "      <td>1.3311</td>\n",
       "      <td>1.9123</td>\n",
       "      <td>2.2413</td>\n",
       "      <td>-0.3120</td>\n",
       "      <td>0.8101</td>\n",
       "      <td>-1.9130</td>\n",
       "      <td>-0.5680</td>\n",
       "      <td>1.3092</td>\n",
       "      <td>-2.6481</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1.0551</td>\n",
       "      <td>1.2354</td>\n",
       "      <td>1.3601</td>\n",
       "      <td>-0.2162</td>\n",
       "      <td>0.4111</td>\n",
       "      <td>3.4653</td>\n",
       "      <td>-0.7132</td>\n",
       "      <td>-0.1750</td>\n",
       "      <td>2.2738</td>\n",
       "      <td>-1.986600</td>\n",
       "      <td>...</td>\n",
       "      <td>0.455600</td>\n",
       "      <td>-0.0390</td>\n",
       "      <td>0.2839</td>\n",
       "      <td>0.4539</td>\n",
       "      <td>0.6926</td>\n",
       "      <td>-0.7972</td>\n",
       "      <td>0.4520</td>\n",
       "      <td>-5.8484</td>\n",
       "      <td>-0.8234</td>\n",
       "      <td>-0.1456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.1489</td>\n",
       "      <td>-2.4495</td>\n",
       "      <td>-0.4539</td>\n",
       "      <td>1.1056</td>\n",
       "      <td>0.4953</td>\n",
       "      <td>-0.0215</td>\n",
       "      <td>0.2647</td>\n",
       "      <td>2.6636</td>\n",
       "      <td>-0.4983</td>\n",
       "      <td>-0.542800</td>\n",
       "      <td>...</td>\n",
       "      <td>0.649900</td>\n",
       "      <td>-1.1728</td>\n",
       "      <td>2.9031</td>\n",
       "      <td>1.1496</td>\n",
       "      <td>2.4240</td>\n",
       "      <td>-0.7917</td>\n",
       "      <td>0.3044</td>\n",
       "      <td>-1.7361</td>\n",
       "      <td>0.1871</td>\n",
       "      <td>0.2322</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-1.4213</td>\n",
       "      <td>0.3248</td>\n",
       "      <td>-0.6745</td>\n",
       "      <td>-0.2848</td>\n",
       "      <td>-0.3146</td>\n",
       "      <td>-0.4836</td>\n",
       "      <td>0.6913</td>\n",
       "      <td>-1.1582</td>\n",
       "      <td>4.1695</td>\n",
       "      <td>0.394600</td>\n",
       "      <td>...</td>\n",
       "      <td>3.214200</td>\n",
       "      <td>-0.7427</td>\n",
       "      <td>0.2303</td>\n",
       "      <td>-0.0963</td>\n",
       "      <td>1.0515</td>\n",
       "      <td>1.8027</td>\n",
       "      <td>-0.0683</td>\n",
       "      <td>1.2841</td>\n",
       "      <td>0.7798</td>\n",
       "      <td>-0.4633</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">HA1E</th>\n",
       "      <th rowspan=\"2\" valign=\"top\">kidney</th>\n",
       "      <th rowspan=\"2\" valign=\"top\">normal kidney</th>\n",
       "      <th rowspan=\"2\" valign=\"top\">Acetylcholine receptor antagonist</th>\n",
       "      <th>2</th>\n",
       "      <td>0.0560</td>\n",
       "      <td>-0.2165</td>\n",
       "      <td>0.4452</td>\n",
       "      <td>-1.3853</td>\n",
       "      <td>0.2647</td>\n",
       "      <td>-0.9348</td>\n",
       "      <td>-1.4993</td>\n",
       "      <td>-1.5589</td>\n",
       "      <td>1.1571</td>\n",
       "      <td>0.690900</td>\n",
       "      <td>...</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>2.8327</td>\n",
       "      <td>-0.3044</td>\n",
       "      <td>5.0788</td>\n",
       "      <td>-0.8970</td>\n",
       "      <td>-5.7992</td>\n",
       "      <td>0.5842</td>\n",
       "      <td>-1.1536</td>\n",
       "      <td>-1.3946</td>\n",
       "      <td>1.1338</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-0.0518</td>\n",
       "      <td>0.5813</td>\n",
       "      <td>-0.1840</td>\n",
       "      <td>-3.6283</td>\n",
       "      <td>0.7933</td>\n",
       "      <td>-0.5927</td>\n",
       "      <td>-0.1174</td>\n",
       "      <td>0.2393</td>\n",
       "      <td>-0.1036</td>\n",
       "      <td>-0.358100</td>\n",
       "      <td>...</td>\n",
       "      <td>0.589700</td>\n",
       "      <td>1.8987</td>\n",
       "      <td>-0.2837</td>\n",
       "      <td>0.4608</td>\n",
       "      <td>-0.8980</td>\n",
       "      <td>-0.5850</td>\n",
       "      <td>0.3259</td>\n",
       "      <td>0.8394</td>\n",
       "      <td>-0.5943</td>\n",
       "      <td>0.0777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">HT29</th>\n",
       "      <th rowspan=\"4\" valign=\"top\">large intestine</th>\n",
       "      <th rowspan=\"4\" valign=\"top\">colorectal adenocarcinoma</th>\n",
       "      <th rowspan=\"4\" valign=\"top\">Acetylcholine receptor antagonist</th>\n",
       "      <th>3</th>\n",
       "      <td>-6.4517</td>\n",
       "      <td>2.3952</td>\n",
       "      <td>3.9664</td>\n",
       "      <td>0.7901</td>\n",
       "      <td>1.1088</td>\n",
       "      <td>-2.4301</td>\n",
       "      <td>2.2921</td>\n",
       "      <td>-1.3441</td>\n",
       "      <td>-1.4215</td>\n",
       "      <td>-17.362499</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.681100</td>\n",
       "      <td>-2.0231</td>\n",
       "      <td>-1.7416</td>\n",
       "      <td>2.6361</td>\n",
       "      <td>2.8931</td>\n",
       "      <td>0.5410</td>\n",
       "      <td>2.2800</td>\n",
       "      <td>1.4823</td>\n",
       "      <td>-0.7641</td>\n",
       "      <td>-14.0374</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>-9.9143</td>\n",
       "      <td>1.6800</td>\n",
       "      <td>-0.5068</td>\n",
       "      <td>0.6087</td>\n",
       "      <td>1.0041</td>\n",
       "      <td>-2.5097</td>\n",
       "      <td>6.0199</td>\n",
       "      <td>-1.8816</td>\n",
       "      <td>-2.2613</td>\n",
       "      <td>1.055400</td>\n",
       "      <td>...</td>\n",
       "      <td>-4.203000</td>\n",
       "      <td>0.3622</td>\n",
       "      <td>-2.2260</td>\n",
       "      <td>1.7365</td>\n",
       "      <td>1.6679</td>\n",
       "      <td>1.0086</td>\n",
       "      <td>0.8317</td>\n",
       "      <td>0.9086</td>\n",
       "      <td>-5.6971</td>\n",
       "      <td>2.2892</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-0.8978</td>\n",
       "      <td>-1.3619</td>\n",
       "      <td>-0.1906</td>\n",
       "      <td>-0.5726</td>\n",
       "      <td>-1.5162</td>\n",
       "      <td>-0.4133</td>\n",
       "      <td>0.1475</td>\n",
       "      <td>1.1433</td>\n",
       "      <td>2.6946</td>\n",
       "      <td>1.307700</td>\n",
       "      <td>...</td>\n",
       "      <td>0.611000</td>\n",
       "      <td>-1.1018</td>\n",
       "      <td>-0.4752</td>\n",
       "      <td>-0.7527</td>\n",
       "      <td>-0.7139</td>\n",
       "      <td>0.6623</td>\n",
       "      <td>-0.8649</td>\n",
       "      <td>-0.5935</td>\n",
       "      <td>-0.1804</td>\n",
       "      <td>0.9388</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.6745</td>\n",
       "      <td>1.9114</td>\n",
       "      <td>1.1192</td>\n",
       "      <td>0.2433</td>\n",
       "      <td>0.7986</td>\n",
       "      <td>-0.4574</td>\n",
       "      <td>-0.7097</td>\n",
       "      <td>-0.5676</td>\n",
       "      <td>0.8551</td>\n",
       "      <td>-0.601600</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.295200</td>\n",
       "      <td>-0.4340</td>\n",
       "      <td>0.0893</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.5591</td>\n",
       "      <td>-0.9972</td>\n",
       "      <td>-0.3468</td>\n",
       "      <td>-1.1292</td>\n",
       "      <td>-0.9897</td>\n",
       "      <td>-0.1203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">MCF7</th>\n",
       "      <th rowspan=\"4\" valign=\"top\">breast</th>\n",
       "      <th rowspan=\"4\" valign=\"top\">adenocarcinoma</th>\n",
       "      <th rowspan=\"4\" valign=\"top\">Acetylcholine receptor antagonist</th>\n",
       "      <th>4</th>\n",
       "      <td>0.2640</td>\n",
       "      <td>-0.7579</td>\n",
       "      <td>-0.2044</td>\n",
       "      <td>0.0091</td>\n",
       "      <td>0.3972</td>\n",
       "      <td>0.3914</td>\n",
       "      <td>0.6085</td>\n",
       "      <td>0.2698</td>\n",
       "      <td>-0.3592</td>\n",
       "      <td>-0.247600</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.011300</td>\n",
       "      <td>-3.5442</td>\n",
       "      <td>-0.5320</td>\n",
       "      <td>-0.4506</td>\n",
       "      <td>-0.6127</td>\n",
       "      <td>-0.1957</td>\n",
       "      <td>-0.0418</td>\n",
       "      <td>-0.1375</td>\n",
       "      <td>0.4398</td>\n",
       "      <td>-0.5375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.3712</td>\n",
       "      <td>0.1030</td>\n",
       "      <td>-0.7772</td>\n",
       "      <td>0.4195</td>\n",
       "      <td>0.4700</td>\n",
       "      <td>-1.4550</td>\n",
       "      <td>2.0798</td>\n",
       "      <td>-4.7181</td>\n",
       "      <td>1.0709</td>\n",
       "      <td>-20.768000</td>\n",
       "      <td>...</td>\n",
       "      <td>-2.503800</td>\n",
       "      <td>-12.5829</td>\n",
       "      <td>-2.0656</td>\n",
       "      <td>1.2220</td>\n",
       "      <td>3.1535</td>\n",
       "      <td>1.2815</td>\n",
       "      <td>0.3204</td>\n",
       "      <td>2.3384</td>\n",
       "      <td>1.3244</td>\n",
       "      <td>-1.5311</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.1265</td>\n",
       "      <td>1.7918</td>\n",
       "      <td>0.2110</td>\n",
       "      <td>1.8861</td>\n",
       "      <td>-0.3015</td>\n",
       "      <td>-1.1905</td>\n",
       "      <td>0.4640</td>\n",
       "      <td>-0.0548</td>\n",
       "      <td>-1.7593</td>\n",
       "      <td>-1.188600</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.388300</td>\n",
       "      <td>-3.4791</td>\n",
       "      <td>2.2421</td>\n",
       "      <td>0.8726</td>\n",
       "      <td>1.1940</td>\n",
       "      <td>-0.7088</td>\n",
       "      <td>11.0312</td>\n",
       "      <td>3.2814</td>\n",
       "      <td>-0.3302</td>\n",
       "      <td>-0.9921</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-0.1869</td>\n",
       "      <td>-0.2091</td>\n",
       "      <td>-0.9615</td>\n",
       "      <td>0.2386</td>\n",
       "      <td>-0.4483</td>\n",
       "      <td>6.0688</td>\n",
       "      <td>2.3001</td>\n",
       "      <td>0.6608</td>\n",
       "      <td>-0.5725</td>\n",
       "      <td>1.293000</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.896300</td>\n",
       "      <td>-1.2209</td>\n",
       "      <td>1.1962</td>\n",
       "      <td>-0.4577</td>\n",
       "      <td>0.9054</td>\n",
       "      <td>-0.6353</td>\n",
       "      <td>-1.1797</td>\n",
       "      <td>0.9566</td>\n",
       "      <td>0.1962</td>\n",
       "      <td>2.2593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"8\" valign=\"top\">PC3</th>\n",
       "      <th rowspan=\"8\" valign=\"top\">prostate</th>\n",
       "      <th rowspan=\"8\" valign=\"top\">adenocarcinoma</th>\n",
       "      <th rowspan=\"8\" valign=\"top\">Acetylcholine receptor antagonist</th>\n",
       "      <th>9</th>\n",
       "      <td>1.0671</td>\n",
       "      <td>1.4505</td>\n",
       "      <td>0.8168</td>\n",
       "      <td>-1.9724</td>\n",
       "      <td>1.1069</td>\n",
       "      <td>1.2570</td>\n",
       "      <td>-0.7129</td>\n",
       "      <td>0.5326</td>\n",
       "      <td>0.6351</td>\n",
       "      <td>-15.293100</td>\n",
       "      <td>...</td>\n",
       "      <td>0.810200</td>\n",
       "      <td>-0.0500</td>\n",
       "      <td>0.2484</td>\n",
       "      <td>-0.1549</td>\n",
       "      <td>-2.4221</td>\n",
       "      <td>0.3301</td>\n",
       "      <td>1.8588</td>\n",
       "      <td>0.3574</td>\n",
       "      <td>-2.6171</td>\n",
       "      <td>1.8982</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0.4082</td>\n",
       "      <td>1.3545</td>\n",
       "      <td>0.1040</td>\n",
       "      <td>-0.9072</td>\n",
       "      <td>-1.5575</td>\n",
       "      <td>1.2204</td>\n",
       "      <td>0.0114</td>\n",
       "      <td>0.1642</td>\n",
       "      <td>0.1707</td>\n",
       "      <td>0.969200</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.007200</td>\n",
       "      <td>-0.2946</td>\n",
       "      <td>1.2560</td>\n",
       "      <td>-0.3101</td>\n",
       "      <td>-0.3246</td>\n",
       "      <td>1.6329</td>\n",
       "      <td>1.1772</td>\n",
       "      <td>-0.9050</td>\n",
       "      <td>-0.4823</td>\n",
       "      <td>0.2273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-2.5301</td>\n",
       "      <td>-2.5736</td>\n",
       "      <td>-0.1543</td>\n",
       "      <td>0.4802</td>\n",
       "      <td>-0.9612</td>\n",
       "      <td>-0.0687</td>\n",
       "      <td>1.2158</td>\n",
       "      <td>-1.2245</td>\n",
       "      <td>4.6211</td>\n",
       "      <td>-14.937500</td>\n",
       "      <td>...</td>\n",
       "      <td>2.081300</td>\n",
       "      <td>-0.9743</td>\n",
       "      <td>1.4296</td>\n",
       "      <td>-0.3264</td>\n",
       "      <td>0.3092</td>\n",
       "      <td>0.0527</td>\n",
       "      <td>0.0900</td>\n",
       "      <td>-0.2984</td>\n",
       "      <td>3.1302</td>\n",
       "      <td>0.2802</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-0.7174</td>\n",
       "      <td>-1.5135</td>\n",
       "      <td>0.7908</td>\n",
       "      <td>-0.2835</td>\n",
       "      <td>1.2939</td>\n",
       "      <td>1.4615</td>\n",
       "      <td>-1.9101</td>\n",
       "      <td>0.2277</td>\n",
       "      <td>0.1287</td>\n",
       "      <td>0.029400</td>\n",
       "      <td>...</td>\n",
       "      <td>0.880200</td>\n",
       "      <td>0.9504</td>\n",
       "      <td>-0.5792</td>\n",
       "      <td>-0.0106</td>\n",
       "      <td>-0.5566</td>\n",
       "      <td>-1.3707</td>\n",
       "      <td>0.0896</td>\n",
       "      <td>1.4262</td>\n",
       "      <td>-0.4790</td>\n",
       "      <td>1.3679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-0.5987</td>\n",
       "      <td>-0.6158</td>\n",
       "      <td>0.3769</td>\n",
       "      <td>-1.6787</td>\n",
       "      <td>-1.9208</td>\n",
       "      <td>-0.5257</td>\n",
       "      <td>0.7545</td>\n",
       "      <td>11.5631</td>\n",
       "      <td>0.4365</td>\n",
       "      <td>0.835500</td>\n",
       "      <td>...</td>\n",
       "      <td>0.264700</td>\n",
       "      <td>0.2985</td>\n",
       "      <td>0.7276</td>\n",
       "      <td>-0.7486</td>\n",
       "      <td>-0.1744</td>\n",
       "      <td>-0.9728</td>\n",
       "      <td>-1.4242</td>\n",
       "      <td>-1.4371</td>\n",
       "      <td>-0.8592</td>\n",
       "      <td>1.4526</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>-0.4265</td>\n",
       "      <td>-0.0221</td>\n",
       "      <td>0.1255</td>\n",
       "      <td>-0.4679</td>\n",
       "      <td>1.5453</td>\n",
       "      <td>0.6164</td>\n",
       "      <td>0.2204</td>\n",
       "      <td>-0.0394</td>\n",
       "      <td>0.2188</td>\n",
       "      <td>-0.013200</td>\n",
       "      <td>...</td>\n",
       "      <td>1.931300</td>\n",
       "      <td>1.3794</td>\n",
       "      <td>-0.6407</td>\n",
       "      <td>0.8322</td>\n",
       "      <td>-0.1456</td>\n",
       "      <td>-1.4119</td>\n",
       "      <td>-0.8553</td>\n",
       "      <td>0.9532</td>\n",
       "      <td>-0.1183</td>\n",
       "      <td>1.1055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-0.7781</td>\n",
       "      <td>0.6348</td>\n",
       "      <td>-1.2084</td>\n",
       "      <td>-1.6513</td>\n",
       "      <td>-0.7778</td>\n",
       "      <td>1.5135</td>\n",
       "      <td>-1.0978</td>\n",
       "      <td>-0.7554</td>\n",
       "      <td>0.0617</td>\n",
       "      <td>-0.584800</td>\n",
       "      <td>...</td>\n",
       "      <td>2.426700</td>\n",
       "      <td>0.3022</td>\n",
       "      <td>2.0434</td>\n",
       "      <td>0.3878</td>\n",
       "      <td>-0.2711</td>\n",
       "      <td>-0.8236</td>\n",
       "      <td>-1.1911</td>\n",
       "      <td>2.1305</td>\n",
       "      <td>1.8189</td>\n",
       "      <td>1.4120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.2818</td>\n",
       "      <td>-0.4199</td>\n",
       "      <td>0.6352</td>\n",
       "      <td>0.5172</td>\n",
       "      <td>0.5217</td>\n",
       "      <td>1.0383</td>\n",
       "      <td>-0.6706</td>\n",
       "      <td>-0.1195</td>\n",
       "      <td>-0.1375</td>\n",
       "      <td>-0.637700</td>\n",
       "      <td>...</td>\n",
       "      <td>1.863300</td>\n",
       "      <td>-0.6649</td>\n",
       "      <td>-0.4335</td>\n",
       "      <td>0.9029</td>\n",
       "      <td>5.6672</td>\n",
       "      <td>-1.5658</td>\n",
       "      <td>-0.4623</td>\n",
       "      <td>-0.7149</td>\n",
       "      <td>-0.6316</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">VCAP</th>\n",
       "      <th rowspan=\"3\" valign=\"top\">prostate</th>\n",
       "      <th rowspan=\"3\" valign=\"top\">carcinoma</th>\n",
       "      <th rowspan=\"3\" valign=\"top\">Acetylcholine receptor antagonist</th>\n",
       "      <th>1</th>\n",
       "      <td>0.1744</td>\n",
       "      <td>0.5378</td>\n",
       "      <td>-1.0857</td>\n",
       "      <td>-0.3073</td>\n",
       "      <td>-0.1163</td>\n",
       "      <td>-1.7152</td>\n",
       "      <td>-0.6287</td>\n",
       "      <td>-1.3200</td>\n",
       "      <td>-0.8119</td>\n",
       "      <td>0.657000</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.105900</td>\n",
       "      <td>0.9443</td>\n",
       "      <td>0.5768</td>\n",
       "      <td>-0.5061</td>\n",
       "      <td>-1.3563</td>\n",
       "      <td>-0.0020</td>\n",
       "      <td>-0.5914</td>\n",
       "      <td>-0.7954</td>\n",
       "      <td>-0.0704</td>\n",
       "      <td>-0.5691</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.2663</td>\n",
       "      <td>0.2292</td>\n",
       "      <td>-0.4814</td>\n",
       "      <td>0.0671</td>\n",
       "      <td>-0.5808</td>\n",
       "      <td>-0.3364</td>\n",
       "      <td>-0.0815</td>\n",
       "      <td>-2.8935</td>\n",
       "      <td>-0.0717</td>\n",
       "      <td>1.147800</td>\n",
       "      <td>...</td>\n",
       "      <td>0.211000</td>\n",
       "      <td>1.4788</td>\n",
       "      <td>0.5593</td>\n",
       "      <td>-0.2301</td>\n",
       "      <td>2.3426</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>-0.0081</td>\n",
       "      <td>-0.6377</td>\n",
       "      <td>-0.1764</td>\n",
       "      <td>-0.0616</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-1.5391</td>\n",
       "      <td>0.4758</td>\n",
       "      <td>-0.0811</td>\n",
       "      <td>-0.2588</td>\n",
       "      <td>-0.2115</td>\n",
       "      <td>-0.6171</td>\n",
       "      <td>-0.9760</td>\n",
       "      <td>-0.2049</td>\n",
       "      <td>-0.5870</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.472300</td>\n",
       "      <td>-0.0486</td>\n",
       "      <td>0.2198</td>\n",
       "      <td>-0.2311</td>\n",
       "      <td>-0.1250</td>\n",
       "      <td>0.1511</td>\n",
       "      <td>-0.3097</td>\n",
       "      <td>-0.7553</td>\n",
       "      <td>-0.8748</td>\n",
       "      <td>0.0474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\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 rowspan=\"30\" valign=\"top\">BRD-A00993607</th>\n",
       "      <th rowspan=\"30\" valign=\"top\">alprenolol</th>\n",
       "      <th rowspan=\"4\" valign=\"top\">PC3</th>\n",
       "      <th rowspan=\"4\" valign=\"top\">prostate</th>\n",
       "      <th rowspan=\"4\" valign=\"top\">adenocarcinoma</th>\n",
       "      <th rowspan=\"4\" valign=\"top\">Adrenergic receptor antagonist</th>\n",
       "      <th>1</th>\n",
       "      <td>-8.2223</td>\n",
       "      <td>0.2530</td>\n",
       "      <td>-0.3281</td>\n",
       "      <td>-0.6874</td>\n",
       "      <td>-0.1462</td>\n",
       "      <td>-0.2242</td>\n",
       "      <td>0.4557</td>\n",
       "      <td>10.7570</td>\n",
       "      <td>0.4209</td>\n",
       "      <td>-0.514000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.144400</td>\n",
       "      <td>0.5342</td>\n",
       "      <td>1.0130</td>\n",
       "      <td>-0.5083</td>\n",
       "      <td>0.6740</td>\n",
       "      <td>0.8399</td>\n",
       "      <td>0.3490</td>\n",
       "      <td>1.4029</td>\n",
       "      <td>-0.5145</td>\n",
       "      <td>0.7270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-4.2604</td>\n",
       "      <td>1.3838</td>\n",
       "      <td>14.5099</td>\n",
       "      <td>0.1174</td>\n",
       "      <td>1.8253</td>\n",
       "      <td>-2.4071</td>\n",
       "      <td>1.0525</td>\n",
       "      <td>4.1741</td>\n",
       "      <td>-0.6938</td>\n",
       "      <td>1.548600</td>\n",
       "      <td>...</td>\n",
       "      <td>-2.496900</td>\n",
       "      <td>-2.0900</td>\n",
       "      <td>-1.4377</td>\n",
       "      <td>1.0306</td>\n",
       "      <td>-1.1549</td>\n",
       "      <td>0.7113</td>\n",
       "      <td>2.7507</td>\n",
       "      <td>1.8690</td>\n",
       "      <td>-4.2575</td>\n",
       "      <td>-19.1175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>-1.5775</td>\n",
       "      <td>0.1779</td>\n",
       "      <td>1.8294</td>\n",
       "      <td>-0.3227</td>\n",
       "      <td>-0.9827</td>\n",
       "      <td>-0.4475</td>\n",
       "      <td>1.7893</td>\n",
       "      <td>-0.1612</td>\n",
       "      <td>1.9579</td>\n",
       "      <td>0.434300</td>\n",
       "      <td>...</td>\n",
       "      <td>1.842800</td>\n",
       "      <td>-0.2269</td>\n",
       "      <td>-0.6148</td>\n",
       "      <td>1.3191</td>\n",
       "      <td>1.6088</td>\n",
       "      <td>-0.2869</td>\n",
       "      <td>3.6665</td>\n",
       "      <td>0.2311</td>\n",
       "      <td>-1.7969</td>\n",
       "      <td>-1.1847</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.5139</td>\n",
       "      <td>-0.8046</td>\n",
       "      <td>0.9807</td>\n",
       "      <td>0.1361</td>\n",
       "      <td>1.1746</td>\n",
       "      <td>-0.1515</td>\n",
       "      <td>-0.3358</td>\n",
       "      <td>1.4335</td>\n",
       "      <td>1.0743</td>\n",
       "      <td>-0.696400</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.695900</td>\n",
       "      <td>3.0626</td>\n",
       "      <td>0.3000</td>\n",
       "      <td>-1.0580</td>\n",
       "      <td>0.2971</td>\n",
       "      <td>-1.9349</td>\n",
       "      <td>2.2641</td>\n",
       "      <td>-0.5155</td>\n",
       "      <td>-0.9639</td>\n",
       "      <td>0.3382</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"9\" valign=\"top\">VCAP</th>\n",
       "      <th rowspan=\"9\" valign=\"top\">prostate</th>\n",
       "      <th rowspan=\"9\" valign=\"top\">carcinoma</th>\n",
       "      <th rowspan=\"9\" valign=\"top\">Adrenergic receptor antagonist</th>\n",
       "      <th>4</th>\n",
       "      <td>-0.2028</td>\n",
       "      <td>0.3643</td>\n",
       "      <td>-0.1559</td>\n",
       "      <td>2.0305</td>\n",
       "      <td>0.3694</td>\n",
       "      <td>0.4915</td>\n",
       "      <td>0.9461</td>\n",
       "      <td>-9.5640</td>\n",
       "      <td>0.4583</td>\n",
       "      <td>-0.135400</td>\n",
       "      <td>...</td>\n",
       "      <td>0.703100</td>\n",
       "      <td>-5.5435</td>\n",
       "      <td>0.8042</td>\n",
       "      <td>-0.4486</td>\n",
       "      <td>1.3679</td>\n",
       "      <td>1.0890</td>\n",
       "      <td>0.4229</td>\n",
       "      <td>0.2373</td>\n",
       "      <td>0.0046</td>\n",
       "      <td>0.9947</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.7663</td>\n",
       "      <td>0.9173</td>\n",
       "      <td>0.2325</td>\n",
       "      <td>-0.3721</td>\n",
       "      <td>0.7184</td>\n",
       "      <td>0.4297</td>\n",
       "      <td>0.3558</td>\n",
       "      <td>0.7552</td>\n",
       "      <td>1.6967</td>\n",
       "      <td>-2.069100</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.463100</td>\n",
       "      <td>0.3797</td>\n",
       "      <td>-0.1767</td>\n",
       "      <td>0.1072</td>\n",
       "      <td>1.8550</td>\n",
       "      <td>-0.3225</td>\n",
       "      <td>1.2654</td>\n",
       "      <td>-0.2864</td>\n",
       "      <td>0.1969</td>\n",
       "      <td>-0.3626</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-0.1200</td>\n",
       "      <td>-0.4687</td>\n",
       "      <td>-0.8602</td>\n",
       "      <td>0.9564</td>\n",
       "      <td>-0.6093</td>\n",
       "      <td>-0.4215</td>\n",
       "      <td>-0.4564</td>\n",
       "      <td>0.6799</td>\n",
       "      <td>0.4419</td>\n",
       "      <td>-0.057900</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.696400</td>\n",
       "      <td>-0.6364</td>\n",
       "      <td>1.2809</td>\n",
       "      <td>-0.0880</td>\n",
       "      <td>0.7425</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.3104</td>\n",
       "      <td>0.5686</td>\n",
       "      <td>-0.1761</td>\n",
       "      <td>-0.2978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-1.0088</td>\n",
       "      <td>0.7589</td>\n",
       "      <td>-0.3797</td>\n",
       "      <td>0.2308</td>\n",
       "      <td>0.3848</td>\n",
       "      <td>-0.2513</td>\n",
       "      <td>-0.8002</td>\n",
       "      <td>-0.6510</td>\n",
       "      <td>0.6432</td>\n",
       "      <td>0.575400</td>\n",
       "      <td>...</td>\n",
       "      <td>0.592300</td>\n",
       "      <td>0.8293</td>\n",
       "      <td>-0.3070</td>\n",
       "      <td>1.0657</td>\n",
       "      <td>0.4135</td>\n",
       "      <td>0.0013</td>\n",
       "      <td>2.3551</td>\n",
       "      <td>-1.0883</td>\n",
       "      <td>0.6411</td>\n",
       "      <td>-2.3905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.4650</td>\n",
       "      <td>0.9251</td>\n",
       "      <td>0.1692</td>\n",
       "      <td>0.6428</td>\n",
       "      <td>0.2290</td>\n",
       "      <td>0.7292</td>\n",
       "      <td>-0.0074</td>\n",
       "      <td>0.3301</td>\n",
       "      <td>-0.5417</td>\n",
       "      <td>-0.108600</td>\n",
       "      <td>...</td>\n",
       "      <td>0.053100</td>\n",
       "      <td>-0.5715</td>\n",
       "      <td>0.1599</td>\n",
       "      <td>0.0583</td>\n",
       "      <td>1.1456</td>\n",
       "      <td>0.5254</td>\n",
       "      <td>1.4382</td>\n",
       "      <td>-1.0332</td>\n",
       "      <td>-0.2182</td>\n",
       "      <td>-2.9677</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-0.7724</td>\n",
       "      <td>-0.0781</td>\n",
       "      <td>1.0552</td>\n",
       "      <td>-1.7946</td>\n",
       "      <td>0.5707</td>\n",
       "      <td>1.2627</td>\n",
       "      <td>0.3431</td>\n",
       "      <td>0.0326</td>\n",
       "      <td>-1.4542</td>\n",
       "      <td>1.066100</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.381800</td>\n",
       "      <td>1.3170</td>\n",
       "      <td>0.2857</td>\n",
       "      <td>0.2721</td>\n",
       "      <td>1.4508</td>\n",
       "      <td>0.0558</td>\n",
       "      <td>0.4460</td>\n",
       "      <td>-0.4199</td>\n",
       "      <td>0.2244</td>\n",
       "      <td>-0.3989</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-0.8156</td>\n",
       "      <td>-0.6216</td>\n",
       "      <td>1.4811</td>\n",
       "      <td>0.7037</td>\n",
       "      <td>-0.0109</td>\n",
       "      <td>2.1580</td>\n",
       "      <td>-0.0837</td>\n",
       "      <td>2.4032</td>\n",
       "      <td>-0.0738</td>\n",
       "      <td>-1.161900</td>\n",
       "      <td>...</td>\n",
       "      <td>-22.067301</td>\n",
       "      <td>-1.1651</td>\n",
       "      <td>-0.2323</td>\n",
       "      <td>0.8083</td>\n",
       "      <td>0.0078</td>\n",
       "      <td>-0.0054</td>\n",
       "      <td>-0.7941</td>\n",
       "      <td>0.5867</td>\n",
       "      <td>-0.2662</td>\n",
       "      <td>1.0999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-0.7370</td>\n",
       "      <td>-0.3004</td>\n",
       "      <td>1.9659</td>\n",
       "      <td>-2.5489</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>9.5220</td>\n",
       "      <td>-1.1181</td>\n",
       "      <td>2.8928</td>\n",
       "      <td>2.7619</td>\n",
       "      <td>-1.907000</td>\n",
       "      <td>...</td>\n",
       "      <td>-10.699200</td>\n",
       "      <td>0.2358</td>\n",
       "      <td>-0.4416</td>\n",
       "      <td>-0.5581</td>\n",
       "      <td>-1.8312</td>\n",
       "      <td>-0.0040</td>\n",
       "      <td>-0.8493</td>\n",
       "      <td>0.5710</td>\n",
       "      <td>-0.7577</td>\n",
       "      <td>0.3681</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-0.3539</td>\n",
       "      <td>0.8609</td>\n",
       "      <td>1.1168</td>\n",
       "      <td>0.7730</td>\n",
       "      <td>0.5960</td>\n",
       "      <td>0.5256</td>\n",
       "      <td>-0.1483</td>\n",
       "      <td>-1.0793</td>\n",
       "      <td>-0.9175</td>\n",
       "      <td>1.068900</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.733800</td>\n",
       "      <td>-0.4095</td>\n",
       "      <td>1.8893</td>\n",
       "      <td>0.7970</td>\n",
       "      <td>-1.0820</td>\n",
       "      <td>-0.6745</td>\n",
       "      <td>0.3681</td>\n",
       "      <td>3.1484</td>\n",
       "      <td>0.1465</td>\n",
       "      <td>-4.3926</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">A375</th>\n",
       "      <th rowspan=\"5\" valign=\"top\">skin</th>\n",
       "      <th rowspan=\"5\" valign=\"top\">malignant melanoma</th>\n",
       "      <th rowspan=\"5\" valign=\"top\">Adrenergic receptor antagonist</th>\n",
       "      <th>5</th>\n",
       "      <td>-0.1695</td>\n",
       "      <td>-0.4278</td>\n",
       "      <td>-1.2191</td>\n",
       "      <td>-0.8066</td>\n",
       "      <td>0.4397</td>\n",
       "      <td>0.7218</td>\n",
       "      <td>12.1020</td>\n",
       "      <td>-0.1432</td>\n",
       "      <td>0.9388</td>\n",
       "      <td>-20.083500</td>\n",
       "      <td>...</td>\n",
       "      <td>0.355800</td>\n",
       "      <td>0.1693</td>\n",
       "      <td>0.8445</td>\n",
       "      <td>-0.9931</td>\n",
       "      <td>-0.9821</td>\n",
       "      <td>-1.2561</td>\n",
       "      <td>-0.1225</td>\n",
       "      <td>-0.8369</td>\n",
       "      <td>0.3596</td>\n",
       "      <td>-5.0803</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.5955</td>\n",
       "      <td>1.6904</td>\n",
       "      <td>0.2650</td>\n",
       "      <td>-0.7574</td>\n",
       "      <td>-0.1739</td>\n",
       "      <td>-0.2076</td>\n",
       "      <td>-0.7010</td>\n",
       "      <td>0.2545</td>\n",
       "      <td>-0.3540</td>\n",
       "      <td>0.508100</td>\n",
       "      <td>...</td>\n",
       "      <td>1.412300</td>\n",
       "      <td>0.8786</td>\n",
       "      <td>-1.0624</td>\n",
       "      <td>-0.6941</td>\n",
       "      <td>0.3435</td>\n",
       "      <td>-1.1195</td>\n",
       "      <td>-1.0363</td>\n",
       "      <td>1.1579</td>\n",
       "      <td>-0.3712</td>\n",
       "      <td>0.4687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-0.2913</td>\n",
       "      <td>0.2508</td>\n",
       "      <td>1.7071</td>\n",
       "      <td>-0.6005</td>\n",
       "      <td>-0.3775</td>\n",
       "      <td>-0.6150</td>\n",
       "      <td>0.7956</td>\n",
       "      <td>-0.5218</td>\n",
       "      <td>0.7210</td>\n",
       "      <td>0.489800</td>\n",
       "      <td>...</td>\n",
       "      <td>5.660400</td>\n",
       "      <td>0.1446</td>\n",
       "      <td>0.1103</td>\n",
       "      <td>-0.3754</td>\n",
       "      <td>-0.3831</td>\n",
       "      <td>0.6922</td>\n",
       "      <td>-1.0529</td>\n",
       "      <td>-0.2252</td>\n",
       "      <td>-0.2916</td>\n",
       "      <td>-3.9976</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-0.3826</td>\n",
       "      <td>0.3890</td>\n",
       "      <td>0.6478</td>\n",
       "      <td>-0.1487</td>\n",
       "      <td>0.7704</td>\n",
       "      <td>-0.8327</td>\n",
       "      <td>-0.4161</td>\n",
       "      <td>-0.5388</td>\n",
       "      <td>-1.9182</td>\n",
       "      <td>-0.063000</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.129100</td>\n",
       "      <td>0.5455</td>\n",
       "      <td>-0.5136</td>\n",
       "      <td>1.2984</td>\n",
       "      <td>-0.7030</td>\n",
       "      <td>-0.0007</td>\n",
       "      <td>0.4323</td>\n",
       "      <td>-0.6611</td>\n",
       "      <td>-1.0301</td>\n",
       "      <td>-0.7273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-0.1787</td>\n",
       "      <td>0.4775</td>\n",
       "      <td>0.3579</td>\n",
       "      <td>-0.4406</td>\n",
       "      <td>0.5631</td>\n",
       "      <td>0.6935</td>\n",
       "      <td>-0.5837</td>\n",
       "      <td>-0.9486</td>\n",
       "      <td>-0.9479</td>\n",
       "      <td>0.845700</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.710200</td>\n",
       "      <td>0.8907</td>\n",
       "      <td>-0.6713</td>\n",
       "      <td>0.0848</td>\n",
       "      <td>-0.8599</td>\n",
       "      <td>-4.4248</td>\n",
       "      <td>-0.1692</td>\n",
       "      <td>0.7509</td>\n",
       "      <td>1.1091</td>\n",
       "      <td>-0.5989</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">A549</th>\n",
       "      <th rowspan=\"5\" valign=\"top\">lung</th>\n",
       "      <th rowspan=\"5\" valign=\"top\">non small cell lung cancer| carcinoma</th>\n",
       "      <th rowspan=\"5\" valign=\"top\">Adrenergic receptor antagonist</th>\n",
       "      <th>6</th>\n",
       "      <td>-0.2798</td>\n",
       "      <td>0.6731</td>\n",
       "      <td>-0.3314</td>\n",
       "      <td>-1.0456</td>\n",
       "      <td>-0.2952</td>\n",
       "      <td>2.5748</td>\n",
       "      <td>0.0860</td>\n",
       "      <td>-0.0401</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>-0.072800</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.598100</td>\n",
       "      <td>-0.1227</td>\n",
       "      <td>1.4206</td>\n",
       "      <td>0.2277</td>\n",
       "      <td>0.7272</td>\n",
       "      <td>-0.2318</td>\n",
       "      <td>-0.0608</td>\n",
       "      <td>-8.6213</td>\n",
       "      <td>-0.5885</td>\n",
       "      <td>-0.1425</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-1.0433</td>\n",
       "      <td>-1.1752</td>\n",
       "      <td>31.2416</td>\n",
       "      <td>-0.3010</td>\n",
       "      <td>-0.8398</td>\n",
       "      <td>0.2160</td>\n",
       "      <td>0.8747</td>\n",
       "      <td>-0.3936</td>\n",
       "      <td>-0.4012</td>\n",
       "      <td>1.401300</td>\n",
       "      <td>...</td>\n",
       "      <td>0.759700</td>\n",
       "      <td>-0.3851</td>\n",
       "      <td>0.7589</td>\n",
       "      <td>-0.1359</td>\n",
       "      <td>-0.6745</td>\n",
       "      <td>0.4529</td>\n",
       "      <td>1.0002</td>\n",
       "      <td>0.6915</td>\n",
       "      <td>0.7044</td>\n",
       "      <td>-0.6654</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-0.6519</td>\n",
       "      <td>0.1909</td>\n",
       "      <td>0.1726</td>\n",
       "      <td>-0.2505</td>\n",
       "      <td>-0.4306</td>\n",
       "      <td>-0.2382</td>\n",
       "      <td>-0.7403</td>\n",
       "      <td>-0.9947</td>\n",
       "      <td>1.7889</td>\n",
       "      <td>0.294400</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.306600</td>\n",
       "      <td>0.7709</td>\n",
       "      <td>3.0445</td>\n",
       "      <td>-0.6898</td>\n",
       "      <td>-2.1351</td>\n",
       "      <td>0.3805</td>\n",
       "      <td>-0.1169</td>\n",
       "      <td>0.3210</td>\n",
       "      <td>-0.6571</td>\n",
       "      <td>-0.3595</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.2362</td>\n",
       "      <td>-0.8170</td>\n",
       "      <td>0.5587</td>\n",
       "      <td>1.7030</td>\n",
       "      <td>-0.6148</td>\n",
       "      <td>-0.3435</td>\n",
       "      <td>4.3609</td>\n",
       "      <td>-1.2221</td>\n",
       "      <td>-0.0340</td>\n",
       "      <td>0.789000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.478200</td>\n",
       "      <td>-0.0333</td>\n",
       "      <td>-0.4742</td>\n",
       "      <td>-0.1401</td>\n",
       "      <td>-0.4967</td>\n",
       "      <td>0.4020</td>\n",
       "      <td>-0.7995</td>\n",
       "      <td>1.1747</td>\n",
       "      <td>1.2867</td>\n",
       "      <td>0.7235</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.6872</td>\n",
       "      <td>-2.5525</td>\n",
       "      <td>-0.1987</td>\n",
       "      <td>-0.4164</td>\n",
       "      <td>1.0955</td>\n",
       "      <td>0.0733</td>\n",
       "      <td>-0.7394</td>\n",
       "      <td>2.5675</td>\n",
       "      <td>0.0291</td>\n",
       "      <td>-0.822000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.608800</td>\n",
       "      <td>1.2993</td>\n",
       "      <td>-0.1356</td>\n",
       "      <td>-0.4026</td>\n",
       "      <td>-0.1958</td>\n",
       "      <td>-1.0477</td>\n",
       "      <td>-0.4164</td>\n",
       "      <td>0.7161</td>\n",
       "      <td>1.1639</td>\n",
       "      <td>-0.7995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">ASC</th>\n",
       "      <th rowspan=\"3\" valign=\"top\">adipose</th>\n",
       "      <th rowspan=\"3\" valign=\"top\">normal primary adipocyte stem cells</th>\n",
       "      <th rowspan=\"3\" valign=\"top\">Adrenergic receptor antagonist</th>\n",
       "      <th>2</th>\n",
       "      <td>0.1039</td>\n",
       "      <td>-0.4812</td>\n",
       "      <td>0.9269</td>\n",
       "      <td>0.3516</td>\n",
       "      <td>-0.0999</td>\n",
       "      <td>0.0536</td>\n",
       "      <td>0.1106</td>\n",
       "      <td>0.6273</td>\n",
       "      <td>-0.4695</td>\n",
       "      <td>-0.286200</td>\n",
       "      <td>...</td>\n",
       "      <td>0.999300</td>\n",
       "      <td>-0.3543</td>\n",
       "      <td>3.2522</td>\n",
       "      <td>0.7498</td>\n",
       "      <td>-1.5449</td>\n",
       "      <td>0.3624</td>\n",
       "      <td>-0.1791</td>\n",
       "      <td>-0.2471</td>\n",
       "      <td>0.4251</td>\n",
       "      <td>-0.4371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>-1.4398</td>\n",
       "      <td>0.4268</td>\n",
       "      <td>-0.6745</td>\n",
       "      <td>1.1397</td>\n",
       "      <td>-0.1147</td>\n",
       "      <td>0.8131</td>\n",
       "      <td>3.8109</td>\n",
       "      <td>0.3421</td>\n",
       "      <td>-0.7671</td>\n",
       "      <td>0.087000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.651400</td>\n",
       "      <td>0.5903</td>\n",
       "      <td>-0.9020</td>\n",
       "      <td>0.1564</td>\n",
       "      <td>-0.0965</td>\n",
       "      <td>-0.2086</td>\n",
       "      <td>-0.1711</td>\n",
       "      <td>-0.6160</td>\n",
       "      <td>1.0688</td>\n",
       "      <td>3.9686</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>-1.5059</td>\n",
       "      <td>0.5205</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.4994</td>\n",
       "      <td>0.5916</td>\n",
       "      <td>-0.7880</td>\n",
       "      <td>1.1448</td>\n",
       "      <td>1.3136</td>\n",
       "      <td>0.7389</td>\n",
       "      <td>-0.380500</td>\n",
       "      <td>...</td>\n",
       "      <td>1.849200</td>\n",
       "      <td>1.2213</td>\n",
       "      <td>-0.5936</td>\n",
       "      <td>-0.6745</td>\n",
       "      <td>0.1694</td>\n",
       "      <td>-0.2984</td>\n",
       "      <td>-0.0941</td>\n",
       "      <td>0.4937</td>\n",
       "      <td>0.7115</td>\n",
       "      <td>-0.7486</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">HEPG2</th>\n",
       "      <th rowspan=\"3\" valign=\"top\">liver</th>\n",
       "      <th rowspan=\"3\" valign=\"top\">hepatocellular carcinoma</th>\n",
       "      <th rowspan=\"3\" valign=\"top\">Adrenergic receptor antagonist</th>\n",
       "      <th>6</th>\n",
       "      <td>-0.7185</td>\n",
       "      <td>-1.2094</td>\n",
       "      <td>-0.4121</td>\n",
       "      <td>-0.2741</td>\n",
       "      <td>0.4949</td>\n",
       "      <td>-0.5806</td>\n",
       "      <td>1.2480</td>\n",
       "      <td>-0.4416</td>\n",
       "      <td>0.1321</td>\n",
       "      <td>-0.845400</td>\n",
       "      <td>...</td>\n",
       "      <td>0.333400</td>\n",
       "      <td>-1.1118</td>\n",
       "      <td>10.9816</td>\n",
       "      <td>0.2364</td>\n",
       "      <td>-0.4323</td>\n",
       "      <td>0.5240</td>\n",
       "      <td>-0.4328</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>-0.5680</td>\n",
       "      <td>0.4966</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-0.1369</td>\n",
       "      <td>-0.3580</td>\n",
       "      <td>-0.1192</td>\n",
       "      <td>0.1153</td>\n",
       "      <td>0.1716</td>\n",
       "      <td>-1.0899</td>\n",
       "      <td>1.3000</td>\n",
       "      <td>-0.2734</td>\n",
       "      <td>-4.0040</td>\n",
       "      <td>-0.485000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.873500</td>\n",
       "      <td>-0.9966</td>\n",
       "      <td>-2.5157</td>\n",
       "      <td>0.0609</td>\n",
       "      <td>-1.3817</td>\n",
       "      <td>0.5588</td>\n",
       "      <td>-0.4205</td>\n",
       "      <td>-2.5153</td>\n",
       "      <td>0.2059</td>\n",
       "      <td>-1.2207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1.5603</td>\n",
       "      <td>0.2260</td>\n",
       "      <td>11.4132</td>\n",
       "      <td>-0.0020</td>\n",
       "      <td>-0.0558</td>\n",
       "      <td>-0.8810</td>\n",
       "      <td>2.2724</td>\n",
       "      <td>0.4416</td>\n",
       "      <td>-0.1477</td>\n",
       "      <td>-0.106800</td>\n",
       "      <td>...</td>\n",
       "      <td>1.227300</td>\n",
       "      <td>-0.5943</td>\n",
       "      <td>-0.6427</td>\n",
       "      <td>-1.3820</td>\n",
       "      <td>-0.1640</td>\n",
       "      <td>0.6747</td>\n",
       "      <td>-1.1245</td>\n",
       "      <td>-2.0479</td>\n",
       "      <td>0.9938</td>\n",
       "      <td>1.5999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HT29</th>\n",
       "      <th>large intestine</th>\n",
       "      <th>colorectal adenocarcinoma</th>\n",
       "      <th>Adrenergic receptor antagonist</th>\n",
       "      <th>9</th>\n",
       "      <td>-0.6579</td>\n",
       "      <td>1.1905</td>\n",
       "      <td>15.2378</td>\n",
       "      <td>0.0553</td>\n",
       "      <td>-0.3262</td>\n",
       "      <td>-0.2788</td>\n",
       "      <td>-0.5475</td>\n",
       "      <td>-0.2736</td>\n",
       "      <td>0.7715</td>\n",
       "      <td>0.417600</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.088900</td>\n",
       "      <td>1.0036</td>\n",
       "      <td>0.5346</td>\n",
       "      <td>-0.1436</td>\n",
       "      <td>-0.7990</td>\n",
       "      <td>-0.7629</td>\n",
       "      <td>-0.4904</td>\n",
       "      <td>2.7061</td>\n",
       "      <td>0.3499</td>\n",
       "      <td>0.7003</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 978 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                                                                 AARS  \\\n",
       "pert_id       pert_name  cell_id primary_site    subtype                               moa                               Fold           \n",
       "BRD-A00520476 AF-DX-116  A375    skin            malignant melanoma                    Acetylcholine receptor antagonist 9    -1.5594   \n",
       "                                                                                                                         7    -4.3904   \n",
       "                                                                                                                         5     1.0402   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Acetylcholine receptor antagonist 8    -0.2390   \n",
       "                                                                                                                         7     0.5787   \n",
       "                                                                                                                         4    -1.3419   \n",
       "                                                                                                                         7     1.0551   \n",
       "                                                                                                                         1     0.1489   \n",
       "                                                                                                                         2    -1.4213   \n",
       "                         HA1E    kidney          normal kidney                         Acetylcholine receptor antagonist 2     0.0560   \n",
       "                                                                                                                         3    -0.0518   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Acetylcholine receptor antagonist 3    -6.4517   \n",
       "                                                                                                                         7    -9.9143   \n",
       "                                                                                                                         3    -0.8978   \n",
       "                                                                                                                         8     0.6745   \n",
       "                         MCF7    breast          adenocarcinoma                        Acetylcholine receptor antagonist 4     0.2640   \n",
       "                                                                                                                         4     1.3712   \n",
       "                                                                                                                         2     1.1265   \n",
       "                                                                                                                         6    -0.1869   \n",
       "                         PC3     prostate        adenocarcinoma                        Acetylcholine receptor antagonist 9     1.0671   \n",
       "                                                                                                                         5     0.4082   \n",
       "                                                                                                                         3    -2.5301   \n",
       "                                                                                                                         6    -0.7174   \n",
       "                                                                                                                         1    -0.5987   \n",
       "                                                                                                                         7    -0.4265   \n",
       "                                                                                                                         0    -0.7781   \n",
       "                                                                                                                         1     0.2818   \n",
       "                         VCAP    prostate        carcinoma                             Acetylcholine receptor antagonist 1     0.1744   \n",
       "                                                                                                                         1     0.2663   \n",
       "                                                                                                                         0    -1.5391   \n",
       "...                                                                                                                               ...   \n",
       "BRD-A00993607 alprenolol PC3     prostate        adenocarcinoma                        Adrenergic receptor antagonist    1    -8.2223   \n",
       "                                                                                                                         3    -4.2604   \n",
       "                                                                                                                         8    -1.5775   \n",
       "                                                                                                                         8     0.5139   \n",
       "                         VCAP    prostate        carcinoma                             Adrenergic receptor antagonist    4    -0.2028   \n",
       "                                                                                                                         3     1.7663   \n",
       "                                                                                                                         2    -0.1200   \n",
       "                                                                                                                         0    -1.0088   \n",
       "                                                                                                                         2     1.4650   \n",
       "                                                                                                                         4    -0.7724   \n",
       "                                                                                                                         1    -0.8156   \n",
       "                                                                                                                         0    -0.7370   \n",
       "                                                                                                                         2    -0.3539   \n",
       "                         A375    skin            malignant melanoma                    Adrenergic receptor antagonist    5    -0.1695   \n",
       "                                                                                                                         3     0.5955   \n",
       "                                                                                                                         3    -0.2913   \n",
       "                                                                                                                         6    -0.3826   \n",
       "                                                                                                                         1    -0.1787   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Adrenergic receptor antagonist    6    -0.2798   \n",
       "                                                                                                                         0    -1.0433   \n",
       "                                                                                                                         6    -0.6519   \n",
       "                                                                                                                         0     0.2362   \n",
       "                                                                                                                         0     0.6872   \n",
       "                         ASC     adipose         normal primary adipocyte stem cells   Adrenergic receptor antagonist    2     0.1039   \n",
       "                                                                                                                         9    -1.4398   \n",
       "                                                                                                                         7    -1.5059   \n",
       "                         HEPG2   liver           hepatocellular carcinoma              Adrenergic receptor antagonist    6    -0.7185   \n",
       "                                                                                                                         6    -0.1369   \n",
       "                                                                                                                         6     1.5603   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Adrenergic receptor antagonist    9    -0.6579   \n",
       "\n",
       "                                                                                                                                ABCB6  \\\n",
       "pert_id       pert_name  cell_id primary_site    subtype                               moa                               Fold           \n",
       "BRD-A00520476 AF-DX-116  A375    skin            malignant melanoma                    Acetylcholine receptor antagonist 9     6.0608   \n",
       "                                                                                                                         7     0.7553   \n",
       "                                                                                                                         5     1.6024   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Acetylcholine receptor antagonist 8     0.4851   \n",
       "                                                                                                                         7     1.2204   \n",
       "                                                                                                                         4     1.1074   \n",
       "                                                                                                                         7     1.2354   \n",
       "                                                                                                                         1    -2.4495   \n",
       "                                                                                                                         2     0.3248   \n",
       "                         HA1E    kidney          normal kidney                         Acetylcholine receptor antagonist 2    -0.2165   \n",
       "                                                                                                                         3     0.5813   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Acetylcholine receptor antagonist 3     2.3952   \n",
       "                                                                                                                         7     1.6800   \n",
       "                                                                                                                         3    -1.3619   \n",
       "                                                                                                                         8     1.9114   \n",
       "                         MCF7    breast          adenocarcinoma                        Acetylcholine receptor antagonist 4    -0.7579   \n",
       "                                                                                                                         4     0.1030   \n",
       "                                                                                                                         2     1.7918   \n",
       "                                                                                                                         6    -0.2091   \n",
       "                         PC3     prostate        adenocarcinoma                        Acetylcholine receptor antagonist 9     1.4505   \n",
       "                                                                                                                         5     1.3545   \n",
       "                                                                                                                         3    -2.5736   \n",
       "                                                                                                                         6    -1.5135   \n",
       "                                                                                                                         1    -0.6158   \n",
       "                                                                                                                         7    -0.0221   \n",
       "                                                                                                                         0     0.6348   \n",
       "                                                                                                                         1    -0.4199   \n",
       "                         VCAP    prostate        carcinoma                             Acetylcholine receptor antagonist 1     0.5378   \n",
       "                                                                                                                         1     0.2292   \n",
       "                                                                                                                         0     0.4758   \n",
       "...                                                                                                                               ...   \n",
       "BRD-A00993607 alprenolol PC3     prostate        adenocarcinoma                        Adrenergic receptor antagonist    1     0.2530   \n",
       "                                                                                                                         3     1.3838   \n",
       "                                                                                                                         8     0.1779   \n",
       "                                                                                                                         8    -0.8046   \n",
       "                         VCAP    prostate        carcinoma                             Adrenergic receptor antagonist    4     0.3643   \n",
       "                                                                                                                         3     0.9173   \n",
       "                                                                                                                         2    -0.4687   \n",
       "                                                                                                                         0     0.7589   \n",
       "                                                                                                                         2     0.9251   \n",
       "                                                                                                                         4    -0.0781   \n",
       "                                                                                                                         1    -0.6216   \n",
       "                                                                                                                         0    -0.3004   \n",
       "                                                                                                                         2     0.8609   \n",
       "                         A375    skin            malignant melanoma                    Adrenergic receptor antagonist    5    -0.4278   \n",
       "                                                                                                                         3     1.6904   \n",
       "                                                                                                                         3     0.2508   \n",
       "                                                                                                                         6     0.3890   \n",
       "                                                                                                                         1     0.4775   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Adrenergic receptor antagonist    6     0.6731   \n",
       "                                                                                                                         0    -1.1752   \n",
       "                                                                                                                         6     0.1909   \n",
       "                                                                                                                         0    -0.8170   \n",
       "                                                                                                                         0    -2.5525   \n",
       "                         ASC     adipose         normal primary adipocyte stem cells   Adrenergic receptor antagonist    2    -0.4812   \n",
       "                                                                                                                         9     0.4268   \n",
       "                                                                                                                         7     0.5205   \n",
       "                         HEPG2   liver           hepatocellular carcinoma              Adrenergic receptor antagonist    6    -1.2094   \n",
       "                                                                                                                         6    -0.3580   \n",
       "                                                                                                                         6     0.2260   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Adrenergic receptor antagonist    9     1.1905   \n",
       "\n",
       "                                                                                                                                 ABCC5  \\\n",
       "pert_id       pert_name  cell_id primary_site    subtype                               moa                               Fold            \n",
       "BRD-A00520476 AF-DX-116  A375    skin            malignant melanoma                    Acetylcholine receptor antagonist 9     -1.1950   \n",
       "                                                                                                                         7      1.4643   \n",
       "                                                                                                                         5      6.8079   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Acetylcholine receptor antagonist 8      0.2844   \n",
       "                                                                                                                         7     -0.5552   \n",
       "                                                                                                                         4      0.7377   \n",
       "                                                                                                                         7      1.3601   \n",
       "                                                                                                                         1     -0.4539   \n",
       "                                                                                                                         2     -0.6745   \n",
       "                         HA1E    kidney          normal kidney                         Acetylcholine receptor antagonist 2      0.4452   \n",
       "                                                                                                                         3     -0.1840   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Acetylcholine receptor antagonist 3      3.9664   \n",
       "                                                                                                                         7     -0.5068   \n",
       "                                                                                                                         3     -0.1906   \n",
       "                                                                                                                         8      1.1192   \n",
       "                         MCF7    breast          adenocarcinoma                        Acetylcholine receptor antagonist 4     -0.2044   \n",
       "                                                                                                                         4     -0.7772   \n",
       "                                                                                                                         2      0.2110   \n",
       "                                                                                                                         6     -0.9615   \n",
       "                         PC3     prostate        adenocarcinoma                        Acetylcholine receptor antagonist 9      0.8168   \n",
       "                                                                                                                         5      0.1040   \n",
       "                                                                                                                         3     -0.1543   \n",
       "                                                                                                                         6      0.7908   \n",
       "                                                                                                                         1      0.3769   \n",
       "                                                                                                                         7      0.1255   \n",
       "                                                                                                                         0     -1.2084   \n",
       "                                                                                                                         1      0.6352   \n",
       "                         VCAP    prostate        carcinoma                             Acetylcholine receptor antagonist 1     -1.0857   \n",
       "                                                                                                                         1     -0.4814   \n",
       "                                                                                                                         0     -0.0811   \n",
       "...                                                                                                                                ...   \n",
       "BRD-A00993607 alprenolol PC3     prostate        adenocarcinoma                        Adrenergic receptor antagonist    1     -0.3281   \n",
       "                                                                                                                         3     14.5099   \n",
       "                                                                                                                         8      1.8294   \n",
       "                                                                                                                         8      0.9807   \n",
       "                         VCAP    prostate        carcinoma                             Adrenergic receptor antagonist    4     -0.1559   \n",
       "                                                                                                                         3      0.2325   \n",
       "                                                                                                                         2     -0.8602   \n",
       "                                                                                                                         0     -0.3797   \n",
       "                                                                                                                         2      0.1692   \n",
       "                                                                                                                         4      1.0552   \n",
       "                                                                                                                         1      1.4811   \n",
       "                                                                                                                         0      1.9659   \n",
       "                                                                                                                         2      1.1168   \n",
       "                         A375    skin            malignant melanoma                    Adrenergic receptor antagonist    5     -1.2191   \n",
       "                                                                                                                         3      0.2650   \n",
       "                                                                                                                         3      1.7071   \n",
       "                                                                                                                         6      0.6478   \n",
       "                                                                                                                         1      0.3579   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Adrenergic receptor antagonist    6     -0.3314   \n",
       "                                                                                                                         0     31.2416   \n",
       "                                                                                                                         6      0.1726   \n",
       "                                                                                                                         0      0.5587   \n",
       "                                                                                                                         0     -0.1987   \n",
       "                         ASC     adipose         normal primary adipocyte stem cells   Adrenergic receptor antagonist    2      0.9269   \n",
       "                                                                                                                         9     -0.6745   \n",
       "                                                                                                                         7      0.0000   \n",
       "                         HEPG2   liver           hepatocellular carcinoma              Adrenergic receptor antagonist    6     -0.4121   \n",
       "                                                                                                                         6     -0.1192   \n",
       "                                                                                                                         6     11.4132   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Adrenergic receptor antagonist    9     15.2378   \n",
       "\n",
       "                                                                                                                                ABCF1  \\\n",
       "pert_id       pert_name  cell_id primary_site    subtype                               moa                               Fold           \n",
       "BRD-A00520476 AF-DX-116  A375    skin            malignant melanoma                    Acetylcholine receptor antagonist 9    -0.6894   \n",
       "                                                                                                                         7     0.8863   \n",
       "                                                                                                                         5     1.5701   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Acetylcholine receptor antagonist 8    -1.0092   \n",
       "                                                                                                                         7     0.1837   \n",
       "                                                                                                                         4     0.5522   \n",
       "                                                                                                                         7    -0.2162   \n",
       "                                                                                                                         1     1.1056   \n",
       "                                                                                                                         2    -0.2848   \n",
       "                         HA1E    kidney          normal kidney                         Acetylcholine receptor antagonist 2    -1.3853   \n",
       "                                                                                                                         3    -3.6283   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Acetylcholine receptor antagonist 3     0.7901   \n",
       "                                                                                                                         7     0.6087   \n",
       "                                                                                                                         3    -0.5726   \n",
       "                                                                                                                         8     0.2433   \n",
       "                         MCF7    breast          adenocarcinoma                        Acetylcholine receptor antagonist 4     0.0091   \n",
       "                                                                                                                         4     0.4195   \n",
       "                                                                                                                         2     1.8861   \n",
       "                                                                                                                         6     0.2386   \n",
       "                         PC3     prostate        adenocarcinoma                        Acetylcholine receptor antagonist 9    -1.9724   \n",
       "                                                                                                                         5    -0.9072   \n",
       "                                                                                                                         3     0.4802   \n",
       "                                                                                                                         6    -0.2835   \n",
       "                                                                                                                         1    -1.6787   \n",
       "                                                                                                                         7    -0.4679   \n",
       "                                                                                                                         0    -1.6513   \n",
       "                                                                                                                         1     0.5172   \n",
       "                         VCAP    prostate        carcinoma                             Acetylcholine receptor antagonist 1    -0.3073   \n",
       "                                                                                                                         1     0.0671   \n",
       "                                                                                                                         0    -0.2588   \n",
       "...                                                                                                                               ...   \n",
       "BRD-A00993607 alprenolol PC3     prostate        adenocarcinoma                        Adrenergic receptor antagonist    1    -0.6874   \n",
       "                                                                                                                         3     0.1174   \n",
       "                                                                                                                         8    -0.3227   \n",
       "                                                                                                                         8     0.1361   \n",
       "                         VCAP    prostate        carcinoma                             Adrenergic receptor antagonist    4     2.0305   \n",
       "                                                                                                                         3    -0.3721   \n",
       "                                                                                                                         2     0.9564   \n",
       "                                                                                                                         0     0.2308   \n",
       "                                                                                                                         2     0.6428   \n",
       "                                                                                                                         4    -1.7946   \n",
       "                                                                                                                         1     0.7037   \n",
       "                                                                                                                         0    -2.5489   \n",
       "                                                                                                                         2     0.7730   \n",
       "                         A375    skin            malignant melanoma                    Adrenergic receptor antagonist    5    -0.8066   \n",
       "                                                                                                                         3    -0.7574   \n",
       "                                                                                                                         3    -0.6005   \n",
       "                                                                                                                         6    -0.1487   \n",
       "                                                                                                                         1    -0.4406   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Adrenergic receptor antagonist    6    -1.0456   \n",
       "                                                                                                                         0    -0.3010   \n",
       "                                                                                                                         6    -0.2505   \n",
       "                                                                                                                         0     1.7030   \n",
       "                                                                                                                         0    -0.4164   \n",
       "                         ASC     adipose         normal primary adipocyte stem cells   Adrenergic receptor antagonist    2     0.3516   \n",
       "                                                                                                                         9     1.1397   \n",
       "                                                                                                                         7     0.4994   \n",
       "                         HEPG2   liver           hepatocellular carcinoma              Adrenergic receptor antagonist    6    -0.2741   \n",
       "                                                                                                                         6     0.1153   \n",
       "                                                                                                                         6    -0.0020   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Adrenergic receptor antagonist    9     0.0553   \n",
       "\n",
       "                                                                                                                                ABCF3  \\\n",
       "pert_id       pert_name  cell_id primary_site    subtype                               moa                               Fold           \n",
       "BRD-A00520476 AF-DX-116  A375    skin            malignant melanoma                    Acetylcholine receptor antagonist 9     0.0593   \n",
       "                                                                                                                         7     1.1585   \n",
       "                                                                                                                         5     1.0405   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Acetylcholine receptor antagonist 8    -0.9006   \n",
       "                                                                                                                         7    -0.4781   \n",
       "                                                                                                                         4    -1.2875   \n",
       "                                                                                                                         7     0.4111   \n",
       "                                                                                                                         1     0.4953   \n",
       "                                                                                                                         2    -0.3146   \n",
       "                         HA1E    kidney          normal kidney                         Acetylcholine receptor antagonist 2     0.2647   \n",
       "                                                                                                                         3     0.7933   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Acetylcholine receptor antagonist 3     1.1088   \n",
       "                                                                                                                         7     1.0041   \n",
       "                                                                                                                         3    -1.5162   \n",
       "                                                                                                                         8     0.7986   \n",
       "                         MCF7    breast          adenocarcinoma                        Acetylcholine receptor antagonist 4     0.3972   \n",
       "                                                                                                                         4     0.4700   \n",
       "                                                                                                                         2    -0.3015   \n",
       "                                                                                                                         6    -0.4483   \n",
       "                         PC3     prostate        adenocarcinoma                        Acetylcholine receptor antagonist 9     1.1069   \n",
       "                                                                                                                         5    -1.5575   \n",
       "                                                                                                                         3    -0.9612   \n",
       "                                                                                                                         6     1.2939   \n",
       "                                                                                                                         1    -1.9208   \n",
       "                                                                                                                         7     1.5453   \n",
       "                                                                                                                         0    -0.7778   \n",
       "                                                                                                                         1     0.5217   \n",
       "                         VCAP    prostate        carcinoma                             Acetylcholine receptor antagonist 1    -0.1163   \n",
       "                                                                                                                         1    -0.5808   \n",
       "                                                                                                                         0    -0.2115   \n",
       "...                                                                                                                               ...   \n",
       "BRD-A00993607 alprenolol PC3     prostate        adenocarcinoma                        Adrenergic receptor antagonist    1    -0.1462   \n",
       "                                                                                                                         3     1.8253   \n",
       "                                                                                                                         8    -0.9827   \n",
       "                                                                                                                         8     1.1746   \n",
       "                         VCAP    prostate        carcinoma                             Adrenergic receptor antagonist    4     0.3694   \n",
       "                                                                                                                         3     0.7184   \n",
       "                                                                                                                         2    -0.6093   \n",
       "                                                                                                                         0     0.3848   \n",
       "                                                                                                                         2     0.2290   \n",
       "                                                                                                                         4     0.5707   \n",
       "                                                                                                                         1    -0.0109   \n",
       "                                                                                                                         0     0.0000   \n",
       "                                                                                                                         2     0.5960   \n",
       "                         A375    skin            malignant melanoma                    Adrenergic receptor antagonist    5     0.4397   \n",
       "                                                                                                                         3    -0.1739   \n",
       "                                                                                                                         3    -0.3775   \n",
       "                                                                                                                         6     0.7704   \n",
       "                                                                                                                         1     0.5631   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Adrenergic receptor antagonist    6    -0.2952   \n",
       "                                                                                                                         0    -0.8398   \n",
       "                                                                                                                         6    -0.4306   \n",
       "                                                                                                                         0    -0.6148   \n",
       "                                                                                                                         0     1.0955   \n",
       "                         ASC     adipose         normal primary adipocyte stem cells   Adrenergic receptor antagonist    2    -0.0999   \n",
       "                                                                                                                         9    -0.1147   \n",
       "                                                                                                                         7     0.5916   \n",
       "                         HEPG2   liver           hepatocellular carcinoma              Adrenergic receptor antagonist    6     0.4949   \n",
       "                                                                                                                         6     0.1716   \n",
       "                                                                                                                         6    -0.0558   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Adrenergic receptor antagonist    9    -0.3262   \n",
       "\n",
       "                                                                                                                                ABHD4  \\\n",
       "pert_id       pert_name  cell_id primary_site    subtype                               moa                               Fold           \n",
       "BRD-A00520476 AF-DX-116  A375    skin            malignant melanoma                    Acetylcholine receptor antagonist 9    -0.7873   \n",
       "                                                                                                                         7     3.5089   \n",
       "                                                                                                                         5    -1.6266   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Acetylcholine receptor antagonist 8    -0.2332   \n",
       "                                                                                                                         7     0.5837   \n",
       "                                                                                                                         4     0.8788   \n",
       "                                                                                                                         7     3.4653   \n",
       "                                                                                                                         1    -0.0215   \n",
       "                                                                                                                         2    -0.4836   \n",
       "                         HA1E    kidney          normal kidney                         Acetylcholine receptor antagonist 2    -0.9348   \n",
       "                                                                                                                         3    -0.5927   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Acetylcholine receptor antagonist 3    -2.4301   \n",
       "                                                                                                                         7    -2.5097   \n",
       "                                                                                                                         3    -0.4133   \n",
       "                                                                                                                         8    -0.4574   \n",
       "                         MCF7    breast          adenocarcinoma                        Acetylcholine receptor antagonist 4     0.3914   \n",
       "                                                                                                                         4    -1.4550   \n",
       "                                                                                                                         2    -1.1905   \n",
       "                                                                                                                         6     6.0688   \n",
       "                         PC3     prostate        adenocarcinoma                        Acetylcholine receptor antagonist 9     1.2570   \n",
       "                                                                                                                         5     1.2204   \n",
       "                                                                                                                         3    -0.0687   \n",
       "                                                                                                                         6     1.4615   \n",
       "                                                                                                                         1    -0.5257   \n",
       "                                                                                                                         7     0.6164   \n",
       "                                                                                                                         0     1.5135   \n",
       "                                                                                                                         1     1.0383   \n",
       "                         VCAP    prostate        carcinoma                             Acetylcholine receptor antagonist 1    -1.7152   \n",
       "                                                                                                                         1    -0.3364   \n",
       "                                                                                                                         0    -0.6171   \n",
       "...                                                                                                                               ...   \n",
       "BRD-A00993607 alprenolol PC3     prostate        adenocarcinoma                        Adrenergic receptor antagonist    1    -0.2242   \n",
       "                                                                                                                         3    -2.4071   \n",
       "                                                                                                                         8    -0.4475   \n",
       "                                                                                                                         8    -0.1515   \n",
       "                         VCAP    prostate        carcinoma                             Adrenergic receptor antagonist    4     0.4915   \n",
       "                                                                                                                         3     0.4297   \n",
       "                                                                                                                         2    -0.4215   \n",
       "                                                                                                                         0    -0.2513   \n",
       "                                                                                                                         2     0.7292   \n",
       "                                                                                                                         4     1.2627   \n",
       "                                                                                                                         1     2.1580   \n",
       "                                                                                                                         0     9.5220   \n",
       "                                                                                                                         2     0.5256   \n",
       "                         A375    skin            malignant melanoma                    Adrenergic receptor antagonist    5     0.7218   \n",
       "                                                                                                                         3    -0.2076   \n",
       "                                                                                                                         3    -0.6150   \n",
       "                                                                                                                         6    -0.8327   \n",
       "                                                                                                                         1     0.6935   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Adrenergic receptor antagonist    6     2.5748   \n",
       "                                                                                                                         0     0.2160   \n",
       "                                                                                                                         6    -0.2382   \n",
       "                                                                                                                         0    -0.3435   \n",
       "                                                                                                                         0     0.0733   \n",
       "                         ASC     adipose         normal primary adipocyte stem cells   Adrenergic receptor antagonist    2     0.0536   \n",
       "                                                                                                                         9     0.8131   \n",
       "                                                                                                                         7    -0.7880   \n",
       "                         HEPG2   liver           hepatocellular carcinoma              Adrenergic receptor antagonist    6    -0.5806   \n",
       "                                                                                                                         6    -1.0899   \n",
       "                                                                                                                         6    -0.8810   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Adrenergic receptor antagonist    9    -0.2788   \n",
       "\n",
       "                                                                                                                                 ABHD6  \\\n",
       "pert_id       pert_name  cell_id primary_site    subtype                               moa                               Fold            \n",
       "BRD-A00520476 AF-DX-116  A375    skin            malignant melanoma                    Acetylcholine receptor antagonist 9     -0.0631   \n",
       "                                                                                                                         7     -0.5471   \n",
       "                                                                                                                         5     -2.7036   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Acetylcholine receptor antagonist 8     -0.4921   \n",
       "                                                                                                                         7     -0.3616   \n",
       "                                                                                                                         4     -0.2627   \n",
       "                                                                                                                         7     -0.7132   \n",
       "                                                                                                                         1      0.2647   \n",
       "                                                                                                                         2      0.6913   \n",
       "                         HA1E    kidney          normal kidney                         Acetylcholine receptor antagonist 2     -1.4993   \n",
       "                                                                                                                         3     -0.1174   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Acetylcholine receptor antagonist 3      2.2921   \n",
       "                                                                                                                         7      6.0199   \n",
       "                                                                                                                         3      0.1475   \n",
       "                                                                                                                         8     -0.7097   \n",
       "                         MCF7    breast          adenocarcinoma                        Acetylcholine receptor antagonist 4      0.6085   \n",
       "                                                                                                                         4      2.0798   \n",
       "                                                                                                                         2      0.4640   \n",
       "                                                                                                                         6      2.3001   \n",
       "                         PC3     prostate        adenocarcinoma                        Acetylcholine receptor antagonist 9     -0.7129   \n",
       "                                                                                                                         5      0.0114   \n",
       "                                                                                                                         3      1.2158   \n",
       "                                                                                                                         6     -1.9101   \n",
       "                                                                                                                         1      0.7545   \n",
       "                                                                                                                         7      0.2204   \n",
       "                                                                                                                         0     -1.0978   \n",
       "                                                                                                                         1     -0.6706   \n",
       "                         VCAP    prostate        carcinoma                             Acetylcholine receptor antagonist 1     -0.6287   \n",
       "                                                                                                                         1     -0.0815   \n",
       "                                                                                                                         0     -0.9760   \n",
       "...                                                                                                                                ...   \n",
       "BRD-A00993607 alprenolol PC3     prostate        adenocarcinoma                        Adrenergic receptor antagonist    1      0.4557   \n",
       "                                                                                                                         3      1.0525   \n",
       "                                                                                                                         8      1.7893   \n",
       "                                                                                                                         8     -0.3358   \n",
       "                         VCAP    prostate        carcinoma                             Adrenergic receptor antagonist    4      0.9461   \n",
       "                                                                                                                         3      0.3558   \n",
       "                                                                                                                         2     -0.4564   \n",
       "                                                                                                                         0     -0.8002   \n",
       "                                                                                                                         2     -0.0074   \n",
       "                                                                                                                         4      0.3431   \n",
       "                                                                                                                         1     -0.0837   \n",
       "                                                                                                                         0     -1.1181   \n",
       "                                                                                                                         2     -0.1483   \n",
       "                         A375    skin            malignant melanoma                    Adrenergic receptor antagonist    5     12.1020   \n",
       "                                                                                                                         3     -0.7010   \n",
       "                                                                                                                         3      0.7956   \n",
       "                                                                                                                         6     -0.4161   \n",
       "                                                                                                                         1     -0.5837   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Adrenergic receptor antagonist    6      0.0860   \n",
       "                                                                                                                         0      0.8747   \n",
       "                                                                                                                         6     -0.7403   \n",
       "                                                                                                                         0      4.3609   \n",
       "                                                                                                                         0     -0.7394   \n",
       "                         ASC     adipose         normal primary adipocyte stem cells   Adrenergic receptor antagonist    2      0.1106   \n",
       "                                                                                                                         9      3.8109   \n",
       "                                                                                                                         7      1.1448   \n",
       "                         HEPG2   liver           hepatocellular carcinoma              Adrenergic receptor antagonist    6      1.2480   \n",
       "                                                                                                                         6      1.3000   \n",
       "                                                                                                                         6      2.2724   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Adrenergic receptor antagonist    9     -0.5475   \n",
       "\n",
       "                                                                                                                                  ABL1  \\\n",
       "pert_id       pert_name  cell_id primary_site    subtype                               moa                               Fold            \n",
       "BRD-A00520476 AF-DX-116  A375    skin            malignant melanoma                    Acetylcholine receptor antagonist 9     -1.1099   \n",
       "                                                                                                                         7     -0.8222   \n",
       "                                                                                                                         5     -1.3499   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Acetylcholine receptor antagonist 8      0.4718   \n",
       "                                                                                                                         7      0.3630   \n",
       "                                                                                                                         4      0.1010   \n",
       "                                                                                                                         7     -0.1750   \n",
       "                                                                                                                         1      2.6636   \n",
       "                                                                                                                         2     -1.1582   \n",
       "                         HA1E    kidney          normal kidney                         Acetylcholine receptor antagonist 2     -1.5589   \n",
       "                                                                                                                         3      0.2393   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Acetylcholine receptor antagonist 3     -1.3441   \n",
       "                                                                                                                         7     -1.8816   \n",
       "                                                                                                                         3      1.1433   \n",
       "                                                                                                                         8     -0.5676   \n",
       "                         MCF7    breast          adenocarcinoma                        Acetylcholine receptor antagonist 4      0.2698   \n",
       "                                                                                                                         4     -4.7181   \n",
       "                                                                                                                         2     -0.0548   \n",
       "                                                                                                                         6      0.6608   \n",
       "                         PC3     prostate        adenocarcinoma                        Acetylcholine receptor antagonist 9      0.5326   \n",
       "                                                                                                                         5      0.1642   \n",
       "                                                                                                                         3     -1.2245   \n",
       "                                                                                                                         6      0.2277   \n",
       "                                                                                                                         1     11.5631   \n",
       "                                                                                                                         7     -0.0394   \n",
       "                                                                                                                         0     -0.7554   \n",
       "                                                                                                                         1     -0.1195   \n",
       "                         VCAP    prostate        carcinoma                             Acetylcholine receptor antagonist 1     -1.3200   \n",
       "                                                                                                                         1     -2.8935   \n",
       "                                                                                                                         0     -0.2049   \n",
       "...                                                                                                                                ...   \n",
       "BRD-A00993607 alprenolol PC3     prostate        adenocarcinoma                        Adrenergic receptor antagonist    1     10.7570   \n",
       "                                                                                                                         3      4.1741   \n",
       "                                                                                                                         8     -0.1612   \n",
       "                                                                                                                         8      1.4335   \n",
       "                         VCAP    prostate        carcinoma                             Adrenergic receptor antagonist    4     -9.5640   \n",
       "                                                                                                                         3      0.7552   \n",
       "                                                                                                                         2      0.6799   \n",
       "                                                                                                                         0     -0.6510   \n",
       "                                                                                                                         2      0.3301   \n",
       "                                                                                                                         4      0.0326   \n",
       "                                                                                                                         1      2.4032   \n",
       "                                                                                                                         0      2.8928   \n",
       "                                                                                                                         2     -1.0793   \n",
       "                         A375    skin            malignant melanoma                    Adrenergic receptor antagonist    5     -0.1432   \n",
       "                                                                                                                         3      0.2545   \n",
       "                                                                                                                         3     -0.5218   \n",
       "                                                                                                                         6     -0.5388   \n",
       "                                                                                                                         1     -0.9486   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Adrenergic receptor antagonist    6     -0.0401   \n",
       "                                                                                                                         0     -0.3936   \n",
       "                                                                                                                         6     -0.9947   \n",
       "                                                                                                                         0     -1.2221   \n",
       "                                                                                                                         0      2.5675   \n",
       "                         ASC     adipose         normal primary adipocyte stem cells   Adrenergic receptor antagonist    2      0.6273   \n",
       "                                                                                                                         9      0.3421   \n",
       "                                                                                                                         7      1.3136   \n",
       "                         HEPG2   liver           hepatocellular carcinoma              Adrenergic receptor antagonist    6     -0.4416   \n",
       "                                                                                                                         6     -0.2734   \n",
       "                                                                                                                         6      0.4416   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Adrenergic receptor antagonist    9     -0.2736   \n",
       "\n",
       "                                                                                                                                ACAA1  \\\n",
       "pert_id       pert_name  cell_id primary_site    subtype                               moa                               Fold           \n",
       "BRD-A00520476 AF-DX-116  A375    skin            malignant melanoma                    Acetylcholine receptor antagonist 9    -0.6703   \n",
       "                                                                                                                         7     1.8885   \n",
       "                                                                                                                         5    -0.3415   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Acetylcholine receptor antagonist 8     0.8034   \n",
       "                                                                                                                         7    -0.4275   \n",
       "                                                                                                                         4    -0.4230   \n",
       "                                                                                                                         7     2.2738   \n",
       "                                                                                                                         1    -0.4983   \n",
       "                                                                                                                         2     4.1695   \n",
       "                         HA1E    kidney          normal kidney                         Acetylcholine receptor antagonist 2     1.1571   \n",
       "                                                                                                                         3    -0.1036   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Acetylcholine receptor antagonist 3    -1.4215   \n",
       "                                                                                                                         7    -2.2613   \n",
       "                                                                                                                         3     2.6946   \n",
       "                                                                                                                         8     0.8551   \n",
       "                         MCF7    breast          adenocarcinoma                        Acetylcholine receptor antagonist 4    -0.3592   \n",
       "                                                                                                                         4     1.0709   \n",
       "                                                                                                                         2    -1.7593   \n",
       "                                                                                                                         6    -0.5725   \n",
       "                         PC3     prostate        adenocarcinoma                        Acetylcholine receptor antagonist 9     0.6351   \n",
       "                                                                                                                         5     0.1707   \n",
       "                                                                                                                         3     4.6211   \n",
       "                                                                                                                         6     0.1287   \n",
       "                                                                                                                         1     0.4365   \n",
       "                                                                                                                         7     0.2188   \n",
       "                                                                                                                         0     0.0617   \n",
       "                                                                                                                         1    -0.1375   \n",
       "                         VCAP    prostate        carcinoma                             Acetylcholine receptor antagonist 1    -0.8119   \n",
       "                                                                                                                         1    -0.0717   \n",
       "                                                                                                                         0    -0.5870   \n",
       "...                                                                                                                               ...   \n",
       "BRD-A00993607 alprenolol PC3     prostate        adenocarcinoma                        Adrenergic receptor antagonist    1     0.4209   \n",
       "                                                                                                                         3    -0.6938   \n",
       "                                                                                                                         8     1.9579   \n",
       "                                                                                                                         8     1.0743   \n",
       "                         VCAP    prostate        carcinoma                             Adrenergic receptor antagonist    4     0.4583   \n",
       "                                                                                                                         3     1.6967   \n",
       "                                                                                                                         2     0.4419   \n",
       "                                                                                                                         0     0.6432   \n",
       "                                                                                                                         2    -0.5417   \n",
       "                                                                                                                         4    -1.4542   \n",
       "                                                                                                                         1    -0.0738   \n",
       "                                                                                                                         0     2.7619   \n",
       "                                                                                                                         2    -0.9175   \n",
       "                         A375    skin            malignant melanoma                    Adrenergic receptor antagonist    5     0.9388   \n",
       "                                                                                                                         3    -0.3540   \n",
       "                                                                                                                         3     0.7210   \n",
       "                                                                                                                         6    -1.9182   \n",
       "                                                                                                                         1    -0.9479   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Adrenergic receptor antagonist    6     0.0000   \n",
       "                                                                                                                         0    -0.4012   \n",
       "                                                                                                                         6     1.7889   \n",
       "                                                                                                                         0    -0.0340   \n",
       "                                                                                                                         0     0.0291   \n",
       "                         ASC     adipose         normal primary adipocyte stem cells   Adrenergic receptor antagonist    2    -0.4695   \n",
       "                                                                                                                         9    -0.7671   \n",
       "                                                                                                                         7     0.7389   \n",
       "                         HEPG2   liver           hepatocellular carcinoma              Adrenergic receptor antagonist    6     0.1321   \n",
       "                                                                                                                         6    -4.0040   \n",
       "                                                                                                                         6    -0.1477   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Adrenergic receptor antagonist    9     0.7715   \n",
       "\n",
       "                                                                                                                                   ACAT2  \\\n",
       "pert_id       pert_name  cell_id primary_site    subtype                               moa                               Fold              \n",
       "BRD-A00520476 AF-DX-116  A375    skin            malignant melanoma                    Acetylcholine receptor antagonist 9      0.685800   \n",
       "                                                                                                                         7     -4.767100   \n",
       "                                                                                                                         5     -2.686000   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Acetylcholine receptor antagonist 8      0.000000   \n",
       "                                                                                                                         7      0.231100   \n",
       "                                                                                                                         4      0.661300   \n",
       "                                                                                                                         7     -1.986600   \n",
       "                                                                                                                         1     -0.542800   \n",
       "                                                                                                                         2      0.394600   \n",
       "                         HA1E    kidney          normal kidney                         Acetylcholine receptor antagonist 2      0.690900   \n",
       "                                                                                                                         3     -0.358100   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Acetylcholine receptor antagonist 3    -17.362499   \n",
       "                                                                                                                         7      1.055400   \n",
       "                                                                                                                         3      1.307700   \n",
       "                                                                                                                         8     -0.601600   \n",
       "                         MCF7    breast          adenocarcinoma                        Acetylcholine receptor antagonist 4     -0.247600   \n",
       "                                                                                                                         4    -20.768000   \n",
       "                                                                                                                         2     -1.188600   \n",
       "                                                                                                                         6      1.293000   \n",
       "                         PC3     prostate        adenocarcinoma                        Acetylcholine receptor antagonist 9    -15.293100   \n",
       "                                                                                                                         5      0.969200   \n",
       "                                                                                                                         3    -14.937500   \n",
       "                                                                                                                         6      0.029400   \n",
       "                                                                                                                         1      0.835500   \n",
       "                                                                                                                         7     -0.013200   \n",
       "                                                                                                                         0     -0.584800   \n",
       "                                                                                                                         1     -0.637700   \n",
       "                         VCAP    prostate        carcinoma                             Acetylcholine receptor antagonist 1      0.657000   \n",
       "                                                                                                                         1      1.147800   \n",
       "                                                                                                                         0      0.000000   \n",
       "...                                                                                                                                  ...   \n",
       "BRD-A00993607 alprenolol PC3     prostate        adenocarcinoma                        Adrenergic receptor antagonist    1     -0.514000   \n",
       "                                                                                                                         3      1.548600   \n",
       "                                                                                                                         8      0.434300   \n",
       "                                                                                                                         8     -0.696400   \n",
       "                         VCAP    prostate        carcinoma                             Adrenergic receptor antagonist    4     -0.135400   \n",
       "                                                                                                                         3     -2.069100   \n",
       "                                                                                                                         2     -0.057900   \n",
       "                                                                                                                         0      0.575400   \n",
       "                                                                                                                         2     -0.108600   \n",
       "                                                                                                                         4      1.066100   \n",
       "                                                                                                                         1     -1.161900   \n",
       "                                                                                                                         0     -1.907000   \n",
       "                                                                                                                         2      1.068900   \n",
       "                         A375    skin            malignant melanoma                    Adrenergic receptor antagonist    5    -20.083500   \n",
       "                                                                                                                         3      0.508100   \n",
       "                                                                                                                         3      0.489800   \n",
       "                                                                                                                         6     -0.063000   \n",
       "                                                                                                                         1      0.845700   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Adrenergic receptor antagonist    6     -0.072800   \n",
       "                                                                                                                         0      1.401300   \n",
       "                                                                                                                         6      0.294400   \n",
       "                                                                                                                         0      0.789000   \n",
       "                                                                                                                         0     -0.822000   \n",
       "                         ASC     adipose         normal primary adipocyte stem cells   Adrenergic receptor antagonist    2     -0.286200   \n",
       "                                                                                                                         9      0.087000   \n",
       "                                                                                                                         7     -0.380500   \n",
       "                         HEPG2   liver           hepatocellular carcinoma              Adrenergic receptor antagonist    6     -0.845400   \n",
       "                                                                                                                         6     -0.485000   \n",
       "                                                                                                                         6     -0.106800   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Adrenergic receptor antagonist    9      0.417600   \n",
       "\n",
       "                                                                                                                               ...  \\\n",
       "pert_id       pert_name  cell_id primary_site    subtype                               moa                               Fold  ...   \n",
       "BRD-A00520476 AF-DX-116  A375    skin            malignant melanoma                    Acetylcholine receptor antagonist 9     ...   \n",
       "                                                                                                                         7     ...   \n",
       "                                                                                                                         5     ...   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Acetylcholine receptor antagonist 8     ...   \n",
       "                                                                                                                         7     ...   \n",
       "                                                                                                                         4     ...   \n",
       "                                                                                                                         7     ...   \n",
       "                                                                                                                         1     ...   \n",
       "                                                                                                                         2     ...   \n",
       "                         HA1E    kidney          normal kidney                         Acetylcholine receptor antagonist 2     ...   \n",
       "                                                                                                                         3     ...   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Acetylcholine receptor antagonist 3     ...   \n",
       "                                                                                                                         7     ...   \n",
       "                                                                                                                         3     ...   \n",
       "                                                                                                                         8     ...   \n",
       "                         MCF7    breast          adenocarcinoma                        Acetylcholine receptor antagonist 4     ...   \n",
       "                                                                                                                         4     ...   \n",
       "                                                                                                                         2     ...   \n",
       "                                                                                                                         6     ...   \n",
       "                         PC3     prostate        adenocarcinoma                        Acetylcholine receptor antagonist 9     ...   \n",
       "                                                                                                                         5     ...   \n",
       "                                                                                                                         3     ...   \n",
       "                                                                                                                         6     ...   \n",
       "                                                                                                                         1     ...   \n",
       "                                                                                                                         7     ...   \n",
       "                                                                                                                         0     ...   \n",
       "                                                                                                                         1     ...   \n",
       "                         VCAP    prostate        carcinoma                             Acetylcholine receptor antagonist 1     ...   \n",
       "                                                                                                                         1     ...   \n",
       "                                                                                                                         0     ...   \n",
       "...                                                                                                                            ...   \n",
       "BRD-A00993607 alprenolol PC3     prostate        adenocarcinoma                        Adrenergic receptor antagonist    1     ...   \n",
       "                                                                                                                         3     ...   \n",
       "                                                                                                                         8     ...   \n",
       "                                                                                                                         8     ...   \n",
       "                         VCAP    prostate        carcinoma                             Adrenergic receptor antagonist    4     ...   \n",
       "                                                                                                                         3     ...   \n",
       "                                                                                                                         2     ...   \n",
       "                                                                                                                         0     ...   \n",
       "                                                                                                                         2     ...   \n",
       "                                                                                                                         4     ...   \n",
       "                                                                                                                         1     ...   \n",
       "                                                                                                                         0     ...   \n",
       "                                                                                                                         2     ...   \n",
       "                         A375    skin            malignant melanoma                    Adrenergic receptor antagonist    5     ...   \n",
       "                                                                                                                         3     ...   \n",
       "                                                                                                                         3     ...   \n",
       "                                                                                                                         6     ...   \n",
       "                                                                                                                         1     ...   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Adrenergic receptor antagonist    6     ...   \n",
       "                                                                                                                         0     ...   \n",
       "                                                                                                                         6     ...   \n",
       "                                                                                                                         0     ...   \n",
       "                                                                                                                         0     ...   \n",
       "                         ASC     adipose         normal primary adipocyte stem cells   Adrenergic receptor antagonist    2     ...   \n",
       "                                                                                                                         9     ...   \n",
       "                                                                                                                         7     ...   \n",
       "                         HEPG2   liver           hepatocellular carcinoma              Adrenergic receptor antagonist    6     ...   \n",
       "                                                                                                                         6     ...   \n",
       "                                                                                                                         6     ...   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Adrenergic receptor antagonist    9     ...   \n",
       "\n",
       "                                                                                                                                   ZMIZ1  \\\n",
       "pert_id       pert_name  cell_id primary_site    subtype                               moa                               Fold              \n",
       "BRD-A00520476 AF-DX-116  A375    skin            malignant melanoma                    Acetylcholine receptor antagonist 9     -0.334500   \n",
       "                                                                                                                         7     -1.447600   \n",
       "                                                                                                                         5     -1.943700   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Acetylcholine receptor antagonist 8      0.146000   \n",
       "                                                                                                                         7      1.450900   \n",
       "                                                                                                                         4      1.034700   \n",
       "                                                                                                                         7      0.455600   \n",
       "                                                                                                                         1      0.649900   \n",
       "                                                                                                                         2      3.214200   \n",
       "                         HA1E    kidney          normal kidney                         Acetylcholine receptor antagonist 2      0.050000   \n",
       "                                                                                                                         3      0.589700   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Acetylcholine receptor antagonist 3     -1.681100   \n",
       "                                                                                                                         7     -4.203000   \n",
       "                                                                                                                         3      0.611000   \n",
       "                                                                                                                         8     -0.295200   \n",
       "                         MCF7    breast          adenocarcinoma                        Acetylcholine receptor antagonist 4     -0.011300   \n",
       "                                                                                                                         4     -2.503800   \n",
       "                                                                                                                         2     -0.388300   \n",
       "                                                                                                                         6     -0.896300   \n",
       "                         PC3     prostate        adenocarcinoma                        Acetylcholine receptor antagonist 9      0.810200   \n",
       "                                                                                                                         5     -0.007200   \n",
       "                                                                                                                         3      2.081300   \n",
       "                                                                                                                         6      0.880200   \n",
       "                                                                                                                         1      0.264700   \n",
       "                                                                                                                         7      1.931300   \n",
       "                                                                                                                         0      2.426700   \n",
       "                                                                                                                         1      1.863300   \n",
       "                         VCAP    prostate        carcinoma                             Acetylcholine receptor antagonist 1     -0.105900   \n",
       "                                                                                                                         1      0.211000   \n",
       "                                                                                                                         0     -0.472300   \n",
       "...                                                                                                                                  ...   \n",
       "BRD-A00993607 alprenolol PC3     prostate        adenocarcinoma                        Adrenergic receptor antagonist    1      0.144400   \n",
       "                                                                                                                         3     -2.496900   \n",
       "                                                                                                                         8      1.842800   \n",
       "                                                                                                                         8     -0.695900   \n",
       "                         VCAP    prostate        carcinoma                             Adrenergic receptor antagonist    4      0.703100   \n",
       "                                                                                                                         3     -0.463100   \n",
       "                                                                                                                         2     -0.696400   \n",
       "                                                                                                                         0      0.592300   \n",
       "                                                                                                                         2      0.053100   \n",
       "                                                                                                                         4     -0.381800   \n",
       "                                                                                                                         1    -22.067301   \n",
       "                                                                                                                         0    -10.699200   \n",
       "                                                                                                                         2     -0.733800   \n",
       "                         A375    skin            malignant melanoma                    Adrenergic receptor antagonist    5      0.355800   \n",
       "                                                                                                                         3      1.412300   \n",
       "                                                                                                                         3      5.660400   \n",
       "                                                                                                                         6     -0.129100   \n",
       "                                                                                                                         1     -0.710200   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Adrenergic receptor antagonist    6     -0.598100   \n",
       "                                                                                                                         0      0.759700   \n",
       "                                                                                                                         6     -0.306600   \n",
       "                                                                                                                         0      1.478200   \n",
       "                                                                                                                         0      1.608800   \n",
       "                         ASC     adipose         normal primary adipocyte stem cells   Adrenergic receptor antagonist    2      0.999300   \n",
       "                                                                                                                         9      0.651400   \n",
       "                                                                                                                         7      1.849200   \n",
       "                         HEPG2   liver           hepatocellular carcinoma              Adrenergic receptor antagonist    6      0.333400   \n",
       "                                                                                                                         6      1.873500   \n",
       "                                                                                                                         6      1.227300   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Adrenergic receptor antagonist    9     -1.088900   \n",
       "\n",
       "                                                                                                                                 ZMYM2  \\\n",
       "pert_id       pert_name  cell_id primary_site    subtype                               moa                               Fold            \n",
       "BRD-A00520476 AF-DX-116  A375    skin            malignant melanoma                    Acetylcholine receptor antagonist 9      1.4356   \n",
       "                                                                                                                         7     -0.5985   \n",
       "                                                                                                                         5     -1.2552   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Acetylcholine receptor antagonist 8     -0.2967   \n",
       "                                                                                                                         7      0.8935   \n",
       "                                                                                                                         4      1.3311   \n",
       "                                                                                                                         7     -0.0390   \n",
       "                                                                                                                         1     -1.1728   \n",
       "                                                                                                                         2     -0.7427   \n",
       "                         HA1E    kidney          normal kidney                         Acetylcholine receptor antagonist 2      2.8327   \n",
       "                                                                                                                         3      1.8987   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Acetylcholine receptor antagonist 3     -2.0231   \n",
       "                                                                                                                         7      0.3622   \n",
       "                                                                                                                         3     -1.1018   \n",
       "                                                                                                                         8     -0.4340   \n",
       "                         MCF7    breast          adenocarcinoma                        Acetylcholine receptor antagonist 4     -3.5442   \n",
       "                                                                                                                         4    -12.5829   \n",
       "                                                                                                                         2     -3.4791   \n",
       "                                                                                                                         6     -1.2209   \n",
       "                         PC3     prostate        adenocarcinoma                        Acetylcholine receptor antagonist 9     -0.0500   \n",
       "                                                                                                                         5     -0.2946   \n",
       "                                                                                                                         3     -0.9743   \n",
       "                                                                                                                         6      0.9504   \n",
       "                                                                                                                         1      0.2985   \n",
       "                                                                                                                         7      1.3794   \n",
       "                                                                                                                         0      0.3022   \n",
       "                                                                                                                         1     -0.6649   \n",
       "                         VCAP    prostate        carcinoma                             Acetylcholine receptor antagonist 1      0.9443   \n",
       "                                                                                                                         1      1.4788   \n",
       "                                                                                                                         0     -0.0486   \n",
       "...                                                                                                                                ...   \n",
       "BRD-A00993607 alprenolol PC3     prostate        adenocarcinoma                        Adrenergic receptor antagonist    1      0.5342   \n",
       "                                                                                                                         3     -2.0900   \n",
       "                                                                                                                         8     -0.2269   \n",
       "                                                                                                                         8      3.0626   \n",
       "                         VCAP    prostate        carcinoma                             Adrenergic receptor antagonist    4     -5.5435   \n",
       "                                                                                                                         3      0.3797   \n",
       "                                                                                                                         2     -0.6364   \n",
       "                                                                                                                         0      0.8293   \n",
       "                                                                                                                         2     -0.5715   \n",
       "                                                                                                                         4      1.3170   \n",
       "                                                                                                                         1     -1.1651   \n",
       "                                                                                                                         0      0.2358   \n",
       "                                                                                                                         2     -0.4095   \n",
       "                         A375    skin            malignant melanoma                    Adrenergic receptor antagonist    5      0.1693   \n",
       "                                                                                                                         3      0.8786   \n",
       "                                                                                                                         3      0.1446   \n",
       "                                                                                                                         6      0.5455   \n",
       "                                                                                                                         1      0.8907   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Adrenergic receptor antagonist    6     -0.1227   \n",
       "                                                                                                                         0     -0.3851   \n",
       "                                                                                                                         6      0.7709   \n",
       "                                                                                                                         0     -0.0333   \n",
       "                                                                                                                         0      1.2993   \n",
       "                         ASC     adipose         normal primary adipocyte stem cells   Adrenergic receptor antagonist    2     -0.3543   \n",
       "                                                                                                                         9      0.5903   \n",
       "                                                                                                                         7      1.2213   \n",
       "                         HEPG2   liver           hepatocellular carcinoma              Adrenergic receptor antagonist    6     -1.1118   \n",
       "                                                                                                                         6     -0.9966   \n",
       "                                                                                                                         6     -0.5943   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Adrenergic receptor antagonist    9      1.0036   \n",
       "\n",
       "                                                                                                                                ZNF131  \\\n",
       "pert_id       pert_name  cell_id primary_site    subtype                               moa                               Fold            \n",
       "BRD-A00520476 AF-DX-116  A375    skin            malignant melanoma                    Acetylcholine receptor antagonist 9     -0.0628   \n",
       "                                                                                                                         7     -0.8048   \n",
       "                                                                                                                         5     -2.3513   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Acetylcholine receptor antagonist 8      0.8119   \n",
       "                                                                                                                         7     -0.2784   \n",
       "                                                                                                                         4      1.9123   \n",
       "                                                                                                                         7      0.2839   \n",
       "                                                                                                                         1      2.9031   \n",
       "                                                                                                                         2      0.2303   \n",
       "                         HA1E    kidney          normal kidney                         Acetylcholine receptor antagonist 2     -0.3044   \n",
       "                                                                                                                         3     -0.2837   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Acetylcholine receptor antagonist 3     -1.7416   \n",
       "                                                                                                                         7     -2.2260   \n",
       "                                                                                                                         3     -0.4752   \n",
       "                                                                                                                         8      0.0893   \n",
       "                         MCF7    breast          adenocarcinoma                        Acetylcholine receptor antagonist 4     -0.5320   \n",
       "                                                                                                                         4     -2.0656   \n",
       "                                                                                                                         2      2.2421   \n",
       "                                                                                                                         6      1.1962   \n",
       "                         PC3     prostate        adenocarcinoma                        Acetylcholine receptor antagonist 9      0.2484   \n",
       "                                                                                                                         5      1.2560   \n",
       "                                                                                                                         3      1.4296   \n",
       "                                                                                                                         6     -0.5792   \n",
       "                                                                                                                         1      0.7276   \n",
       "                                                                                                                         7     -0.6407   \n",
       "                                                                                                                         0      2.0434   \n",
       "                                                                                                                         1     -0.4335   \n",
       "                         VCAP    prostate        carcinoma                             Acetylcholine receptor antagonist 1      0.5768   \n",
       "                                                                                                                         1      0.5593   \n",
       "                                                                                                                         0      0.2198   \n",
       "...                                                                                                                                ...   \n",
       "BRD-A00993607 alprenolol PC3     prostate        adenocarcinoma                        Adrenergic receptor antagonist    1      1.0130   \n",
       "                                                                                                                         3     -1.4377   \n",
       "                                                                                                                         8     -0.6148   \n",
       "                                                                                                                         8      0.3000   \n",
       "                         VCAP    prostate        carcinoma                             Adrenergic receptor antagonist    4      0.8042   \n",
       "                                                                                                                         3     -0.1767   \n",
       "                                                                                                                         2      1.2809   \n",
       "                                                                                                                         0     -0.3070   \n",
       "                                                                                                                         2      0.1599   \n",
       "                                                                                                                         4      0.2857   \n",
       "                                                                                                                         1     -0.2323   \n",
       "                                                                                                                         0     -0.4416   \n",
       "                                                                                                                         2      1.8893   \n",
       "                         A375    skin            malignant melanoma                    Adrenergic receptor antagonist    5      0.8445   \n",
       "                                                                                                                         3     -1.0624   \n",
       "                                                                                                                         3      0.1103   \n",
       "                                                                                                                         6     -0.5136   \n",
       "                                                                                                                         1     -0.6713   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Adrenergic receptor antagonist    6      1.4206   \n",
       "                                                                                                                         0      0.7589   \n",
       "                                                                                                                         6      3.0445   \n",
       "                                                                                                                         0     -0.4742   \n",
       "                                                                                                                         0     -0.1356   \n",
       "                         ASC     adipose         normal primary adipocyte stem cells   Adrenergic receptor antagonist    2      3.2522   \n",
       "                                                                                                                         9     -0.9020   \n",
       "                                                                                                                         7     -0.5936   \n",
       "                         HEPG2   liver           hepatocellular carcinoma              Adrenergic receptor antagonist    6     10.9816   \n",
       "                                                                                                                         6     -2.5157   \n",
       "                                                                                                                         6     -0.6427   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Adrenergic receptor antagonist    9      0.5346   \n",
       "\n",
       "                                                                                                                               ZNF274  \\\n",
       "pert_id       pert_name  cell_id primary_site    subtype                               moa                               Fold           \n",
       "BRD-A00520476 AF-DX-116  A375    skin            malignant melanoma                    Acetylcholine receptor antagonist 9    -0.0721   \n",
       "                                                                                                                         7     0.7390   \n",
       "                                                                                                                         5     2.2450   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Acetylcholine receptor antagonist 8    -0.6223   \n",
       "                                                                                                                         7     1.9705   \n",
       "                                                                                                                         4     2.2413   \n",
       "                                                                                                                         7     0.4539   \n",
       "                                                                                                                         1     1.1496   \n",
       "                                                                                                                         2    -0.0963   \n",
       "                         HA1E    kidney          normal kidney                         Acetylcholine receptor antagonist 2     5.0788   \n",
       "                                                                                                                         3     0.4608   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Acetylcholine receptor antagonist 3     2.6361   \n",
       "                                                                                                                         7     1.7365   \n",
       "                                                                                                                         3    -0.7527   \n",
       "                                                                                                                         8     0.0000   \n",
       "                         MCF7    breast          adenocarcinoma                        Acetylcholine receptor antagonist 4    -0.4506   \n",
       "                                                                                                                         4     1.2220   \n",
       "                                                                                                                         2     0.8726   \n",
       "                                                                                                                         6    -0.4577   \n",
       "                         PC3     prostate        adenocarcinoma                        Acetylcholine receptor antagonist 9    -0.1549   \n",
       "                                                                                                                         5    -0.3101   \n",
       "                                                                                                                         3    -0.3264   \n",
       "                                                                                                                         6    -0.0106   \n",
       "                                                                                                                         1    -0.7486   \n",
       "                                                                                                                         7     0.8322   \n",
       "                                                                                                                         0     0.3878   \n",
       "                                                                                                                         1     0.9029   \n",
       "                         VCAP    prostate        carcinoma                             Acetylcholine receptor antagonist 1    -0.5061   \n",
       "                                                                                                                         1    -0.2301   \n",
       "                                                                                                                         0    -0.2311   \n",
       "...                                                                                                                               ...   \n",
       "BRD-A00993607 alprenolol PC3     prostate        adenocarcinoma                        Adrenergic receptor antagonist    1    -0.5083   \n",
       "                                                                                                                         3     1.0306   \n",
       "                                                                                                                         8     1.3191   \n",
       "                                                                                                                         8    -1.0580   \n",
       "                         VCAP    prostate        carcinoma                             Adrenergic receptor antagonist    4    -0.4486   \n",
       "                                                                                                                         3     0.1072   \n",
       "                                                                                                                         2    -0.0880   \n",
       "                                                                                                                         0     1.0657   \n",
       "                                                                                                                         2     0.0583   \n",
       "                                                                                                                         4     0.2721   \n",
       "                                                                                                                         1     0.8083   \n",
       "                                                                                                                         0    -0.5581   \n",
       "                                                                                                                         2     0.7970   \n",
       "                         A375    skin            malignant melanoma                    Adrenergic receptor antagonist    5    -0.9931   \n",
       "                                                                                                                         3    -0.6941   \n",
       "                                                                                                                         3    -0.3754   \n",
       "                                                                                                                         6     1.2984   \n",
       "                                                                                                                         1     0.0848   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Adrenergic receptor antagonist    6     0.2277   \n",
       "                                                                                                                         0    -0.1359   \n",
       "                                                                                                                         6    -0.6898   \n",
       "                                                                                                                         0    -0.1401   \n",
       "                                                                                                                         0    -0.4026   \n",
       "                         ASC     adipose         normal primary adipocyte stem cells   Adrenergic receptor antagonist    2     0.7498   \n",
       "                                                                                                                         9     0.1564   \n",
       "                                                                                                                         7    -0.6745   \n",
       "                         HEPG2   liver           hepatocellular carcinoma              Adrenergic receptor antagonist    6     0.2364   \n",
       "                                                                                                                         6     0.0609   \n",
       "                                                                                                                         6    -1.3820   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Adrenergic receptor antagonist    9    -0.1436   \n",
       "\n",
       "                                                                                                                               ZNF318  \\\n",
       "pert_id       pert_name  cell_id primary_site    subtype                               moa                               Fold           \n",
       "BRD-A00520476 AF-DX-116  A375    skin            malignant melanoma                    Acetylcholine receptor antagonist 9    -0.8695   \n",
       "                                                                                                                         7     1.2311   \n",
       "                                                                                                                         5     2.1778   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Acetylcholine receptor antagonist 8    -0.9409   \n",
       "                                                                                                                         7    -1.0668   \n",
       "                                                                                                                         4    -0.3120   \n",
       "                                                                                                                         7     0.6926   \n",
       "                                                                                                                         1     2.4240   \n",
       "                                                                                                                         2     1.0515   \n",
       "                         HA1E    kidney          normal kidney                         Acetylcholine receptor antagonist 2    -0.8970   \n",
       "                                                                                                                         3    -0.8980   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Acetylcholine receptor antagonist 3     2.8931   \n",
       "                                                                                                                         7     1.6679   \n",
       "                                                                                                                         3    -0.7139   \n",
       "                                                                                                                         8     1.5591   \n",
       "                         MCF7    breast          adenocarcinoma                        Acetylcholine receptor antagonist 4    -0.6127   \n",
       "                                                                                                                         4     3.1535   \n",
       "                                                                                                                         2     1.1940   \n",
       "                                                                                                                         6     0.9054   \n",
       "                         PC3     prostate        adenocarcinoma                        Acetylcholine receptor antagonist 9    -2.4221   \n",
       "                                                                                                                         5    -0.3246   \n",
       "                                                                                                                         3     0.3092   \n",
       "                                                                                                                         6    -0.5566   \n",
       "                                                                                                                         1    -0.1744   \n",
       "                                                                                                                         7    -0.1456   \n",
       "                                                                                                                         0    -0.2711   \n",
       "                                                                                                                         1     5.6672   \n",
       "                         VCAP    prostate        carcinoma                             Acetylcholine receptor antagonist 1    -1.3563   \n",
       "                                                                                                                         1     2.3426   \n",
       "                                                                                                                         0    -0.1250   \n",
       "...                                                                                                                               ...   \n",
       "BRD-A00993607 alprenolol PC3     prostate        adenocarcinoma                        Adrenergic receptor antagonist    1     0.6740   \n",
       "                                                                                                                         3    -1.1549   \n",
       "                                                                                                                         8     1.6088   \n",
       "                                                                                                                         8     0.2971   \n",
       "                         VCAP    prostate        carcinoma                             Adrenergic receptor antagonist    4     1.3679   \n",
       "                                                                                                                         3     1.8550   \n",
       "                                                                                                                         2     0.7425   \n",
       "                                                                                                                         0     0.4135   \n",
       "                                                                                                                         2     1.1456   \n",
       "                                                                                                                         4     1.4508   \n",
       "                                                                                                                         1     0.0078   \n",
       "                                                                                                                         0    -1.8312   \n",
       "                                                                                                                         2    -1.0820   \n",
       "                         A375    skin            malignant melanoma                    Adrenergic receptor antagonist    5    -0.9821   \n",
       "                                                                                                                         3     0.3435   \n",
       "                                                                                                                         3    -0.3831   \n",
       "                                                                                                                         6    -0.7030   \n",
       "                                                                                                                         1    -0.8599   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Adrenergic receptor antagonist    6     0.7272   \n",
       "                                                                                                                         0    -0.6745   \n",
       "                                                                                                                         6    -2.1351   \n",
       "                                                                                                                         0    -0.4967   \n",
       "                                                                                                                         0    -0.1958   \n",
       "                         ASC     adipose         normal primary adipocyte stem cells   Adrenergic receptor antagonist    2    -1.5449   \n",
       "                                                                                                                         9    -0.0965   \n",
       "                                                                                                                         7     0.1694   \n",
       "                         HEPG2   liver           hepatocellular carcinoma              Adrenergic receptor antagonist    6    -0.4323   \n",
       "                                                                                                                         6    -1.3817   \n",
       "                                                                                                                         6    -0.1640   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Adrenergic receptor antagonist    9    -0.7990   \n",
       "\n",
       "                                                                                                                               ZNF395  \\\n",
       "pert_id       pert_name  cell_id primary_site    subtype                               moa                               Fold           \n",
       "BRD-A00520476 AF-DX-116  A375    skin            malignant melanoma                    Acetylcholine receptor antagonist 9    -0.5413   \n",
       "                                                                                                                         7     1.2392   \n",
       "                                                                                                                         5     0.6906   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Acetylcholine receptor antagonist 8     0.3434   \n",
       "                                                                                                                         7    -1.6562   \n",
       "                                                                                                                         4     0.8101   \n",
       "                                                                                                                         7    -0.7972   \n",
       "                                                                                                                         1    -0.7917   \n",
       "                                                                                                                         2     1.8027   \n",
       "                         HA1E    kidney          normal kidney                         Acetylcholine receptor antagonist 2    -5.7992   \n",
       "                                                                                                                         3    -0.5850   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Acetylcholine receptor antagonist 3     0.5410   \n",
       "                                                                                                                         7     1.0086   \n",
       "                                                                                                                         3     0.6623   \n",
       "                                                                                                                         8    -0.9972   \n",
       "                         MCF7    breast          adenocarcinoma                        Acetylcholine receptor antagonist 4    -0.1957   \n",
       "                                                                                                                         4     1.2815   \n",
       "                                                                                                                         2    -0.7088   \n",
       "                                                                                                                         6    -0.6353   \n",
       "                         PC3     prostate        adenocarcinoma                        Acetylcholine receptor antagonist 9     0.3301   \n",
       "                                                                                                                         5     1.6329   \n",
       "                                                                                                                         3     0.0527   \n",
       "                                                                                                                         6    -1.3707   \n",
       "                                                                                                                         1    -0.9728   \n",
       "                                                                                                                         7    -1.4119   \n",
       "                                                                                                                         0    -0.8236   \n",
       "                                                                                                                         1    -1.5658   \n",
       "                         VCAP    prostate        carcinoma                             Acetylcholine receptor antagonist 1    -0.0020   \n",
       "                                                                                                                         1     0.0000   \n",
       "                                                                                                                         0     0.1511   \n",
       "...                                                                                                                               ...   \n",
       "BRD-A00993607 alprenolol PC3     prostate        adenocarcinoma                        Adrenergic receptor antagonist    1     0.8399   \n",
       "                                                                                                                         3     0.7113   \n",
       "                                                                                                                         8    -0.2869   \n",
       "                                                                                                                         8    -1.9349   \n",
       "                         VCAP    prostate        carcinoma                             Adrenergic receptor antagonist    4     1.0890   \n",
       "                                                                                                                         3    -0.3225   \n",
       "                                                                                                                         2     0.0000   \n",
       "                                                                                                                         0     0.0013   \n",
       "                                                                                                                         2     0.5254   \n",
       "                                                                                                                         4     0.0558   \n",
       "                                                                                                                         1    -0.0054   \n",
       "                                                                                                                         0    -0.0040   \n",
       "                                                                                                                         2    -0.6745   \n",
       "                         A375    skin            malignant melanoma                    Adrenergic receptor antagonist    5    -1.2561   \n",
       "                                                                                                                         3    -1.1195   \n",
       "                                                                                                                         3     0.6922   \n",
       "                                                                                                                         6    -0.0007   \n",
       "                                                                                                                         1    -4.4248   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Adrenergic receptor antagonist    6    -0.2318   \n",
       "                                                                                                                         0     0.4529   \n",
       "                                                                                                                         6     0.3805   \n",
       "                                                                                                                         0     0.4020   \n",
       "                                                                                                                         0    -1.0477   \n",
       "                         ASC     adipose         normal primary adipocyte stem cells   Adrenergic receptor antagonist    2     0.3624   \n",
       "                                                                                                                         9    -0.2086   \n",
       "                                                                                                                         7    -0.2984   \n",
       "                         HEPG2   liver           hepatocellular carcinoma              Adrenergic receptor antagonist    6     0.5240   \n",
       "                                                                                                                         6     0.5588   \n",
       "                                                                                                                         6     0.6747   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Adrenergic receptor antagonist    9    -0.7629   \n",
       "\n",
       "                                                                                                                                ZNF451  \\\n",
       "pert_id       pert_name  cell_id primary_site    subtype                               moa                               Fold            \n",
       "BRD-A00520476 AF-DX-116  A375    skin            malignant melanoma                    Acetylcholine receptor antagonist 9     -0.8752   \n",
       "                                                                                                                         7      1.4154   \n",
       "                                                                                                                         5      1.9346   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Acetylcholine receptor antagonist 8     -0.0792   \n",
       "                                                                                                                         7     -0.6090   \n",
       "                                                                                                                         4     -1.9130   \n",
       "                                                                                                                         7      0.4520   \n",
       "                                                                                                                         1      0.3044   \n",
       "                                                                                                                         2     -0.0683   \n",
       "                         HA1E    kidney          normal kidney                         Acetylcholine receptor antagonist 2      0.5842   \n",
       "                                                                                                                         3      0.3259   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Acetylcholine receptor antagonist 3      2.2800   \n",
       "                                                                                                                         7      0.8317   \n",
       "                                                                                                                         3     -0.8649   \n",
       "                                                                                                                         8     -0.3468   \n",
       "                         MCF7    breast          adenocarcinoma                        Acetylcholine receptor antagonist 4     -0.0418   \n",
       "                                                                                                                         4      0.3204   \n",
       "                                                                                                                         2     11.0312   \n",
       "                                                                                                                         6     -1.1797   \n",
       "                         PC3     prostate        adenocarcinoma                        Acetylcholine receptor antagonist 9      1.8588   \n",
       "                                                                                                                         5      1.1772   \n",
       "                                                                                                                         3      0.0900   \n",
       "                                                                                                                         6      0.0896   \n",
       "                                                                                                                         1     -1.4242   \n",
       "                                                                                                                         7     -0.8553   \n",
       "                                                                                                                         0     -1.1911   \n",
       "                                                                                                                         1     -0.4623   \n",
       "                         VCAP    prostate        carcinoma                             Acetylcholine receptor antagonist 1     -0.5914   \n",
       "                                                                                                                         1     -0.0081   \n",
       "                                                                                                                         0     -0.3097   \n",
       "...                                                                                                                                ...   \n",
       "BRD-A00993607 alprenolol PC3     prostate        adenocarcinoma                        Adrenergic receptor antagonist    1      0.3490   \n",
       "                                                                                                                         3      2.7507   \n",
       "                                                                                                                         8      3.6665   \n",
       "                                                                                                                         8      2.2641   \n",
       "                         VCAP    prostate        carcinoma                             Adrenergic receptor antagonist    4      0.4229   \n",
       "                                                                                                                         3      1.2654   \n",
       "                                                                                                                         2      1.3104   \n",
       "                                                                                                                         0      2.3551   \n",
       "                                                                                                                         2      1.4382   \n",
       "                                                                                                                         4      0.4460   \n",
       "                                                                                                                         1     -0.7941   \n",
       "                                                                                                                         0     -0.8493   \n",
       "                                                                                                                         2      0.3681   \n",
       "                         A375    skin            malignant melanoma                    Adrenergic receptor antagonist    5     -0.1225   \n",
       "                                                                                                                         3     -1.0363   \n",
       "                                                                                                                         3     -1.0529   \n",
       "                                                                                                                         6      0.4323   \n",
       "                                                                                                                         1     -0.1692   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Adrenergic receptor antagonist    6     -0.0608   \n",
       "                                                                                                                         0      1.0002   \n",
       "                                                                                                                         6     -0.1169   \n",
       "                                                                                                                         0     -0.7995   \n",
       "                                                                                                                         0     -0.4164   \n",
       "                         ASC     adipose         normal primary adipocyte stem cells   Adrenergic receptor antagonist    2     -0.1791   \n",
       "                                                                                                                         9     -0.1711   \n",
       "                                                                                                                         7     -0.0941   \n",
       "                         HEPG2   liver           hepatocellular carcinoma              Adrenergic receptor antagonist    6     -0.4328   \n",
       "                                                                                                                         6     -0.4205   \n",
       "                                                                                                                         6     -1.1245   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Adrenergic receptor antagonist    9     -0.4904   \n",
       "\n",
       "                                                                                                                               ZNF586  \\\n",
       "pert_id       pert_name  cell_id primary_site    subtype                               moa                               Fold           \n",
       "BRD-A00520476 AF-DX-116  A375    skin            malignant melanoma                    Acetylcholine receptor antagonist 9     0.2187   \n",
       "                                                                                                                         7     0.0942   \n",
       "                                                                                                                         5     1.8513   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Acetylcholine receptor antagonist 8     0.3802   \n",
       "                                                                                                                         7    -1.4161   \n",
       "                                                                                                                         4    -0.5680   \n",
       "                                                                                                                         7    -5.8484   \n",
       "                                                                                                                         1    -1.7361   \n",
       "                                                                                                                         2     1.2841   \n",
       "                         HA1E    kidney          normal kidney                         Acetylcholine receptor antagonist 2    -1.1536   \n",
       "                                                                                                                         3     0.8394   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Acetylcholine receptor antagonist 3     1.4823   \n",
       "                                                                                                                         7     0.9086   \n",
       "                                                                                                                         3    -0.5935   \n",
       "                                                                                                                         8    -1.1292   \n",
       "                         MCF7    breast          adenocarcinoma                        Acetylcholine receptor antagonist 4    -0.1375   \n",
       "                                                                                                                         4     2.3384   \n",
       "                                                                                                                         2     3.2814   \n",
       "                                                                                                                         6     0.9566   \n",
       "                         PC3     prostate        adenocarcinoma                        Acetylcholine receptor antagonist 9     0.3574   \n",
       "                                                                                                                         5    -0.9050   \n",
       "                                                                                                                         3    -0.2984   \n",
       "                                                                                                                         6     1.4262   \n",
       "                                                                                                                         1    -1.4371   \n",
       "                                                                                                                         7     0.9532   \n",
       "                                                                                                                         0     2.1305   \n",
       "                                                                                                                         1    -0.7149   \n",
       "                         VCAP    prostate        carcinoma                             Acetylcholine receptor antagonist 1    -0.7954   \n",
       "                                                                                                                         1    -0.6377   \n",
       "                                                                                                                         0    -0.7553   \n",
       "...                                                                                                                               ...   \n",
       "BRD-A00993607 alprenolol PC3     prostate        adenocarcinoma                        Adrenergic receptor antagonist    1     1.4029   \n",
       "                                                                                                                         3     1.8690   \n",
       "                                                                                                                         8     0.2311   \n",
       "                                                                                                                         8    -0.5155   \n",
       "                         VCAP    prostate        carcinoma                             Adrenergic receptor antagonist    4     0.2373   \n",
       "                                                                                                                         3    -0.2864   \n",
       "                                                                                                                         2     0.5686   \n",
       "                                                                                                                         0    -1.0883   \n",
       "                                                                                                                         2    -1.0332   \n",
       "                                                                                                                         4    -0.4199   \n",
       "                                                                                                                         1     0.5867   \n",
       "                                                                                                                         0     0.5710   \n",
       "                                                                                                                         2     3.1484   \n",
       "                         A375    skin            malignant melanoma                    Adrenergic receptor antagonist    5    -0.8369   \n",
       "                                                                                                                         3     1.1579   \n",
       "                                                                                                                         3    -0.2252   \n",
       "                                                                                                                         6    -0.6611   \n",
       "                                                                                                                         1     0.7509   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Adrenergic receptor antagonist    6    -8.6213   \n",
       "                                                                                                                         0     0.6915   \n",
       "                                                                                                                         6     0.3210   \n",
       "                                                                                                                         0     1.1747   \n",
       "                                                                                                                         0     0.7161   \n",
       "                         ASC     adipose         normal primary adipocyte stem cells   Adrenergic receptor antagonist    2    -0.2471   \n",
       "                                                                                                                         9    -0.6160   \n",
       "                                                                                                                         7     0.4937   \n",
       "                         HEPG2   liver           hepatocellular carcinoma              Adrenergic receptor antagonist    6     0.0000   \n",
       "                                                                                                                         6    -2.5153   \n",
       "                                                                                                                         6    -2.0479   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Adrenergic receptor antagonist    9     2.7061   \n",
       "\n",
       "                                                                                                                               ZNF589  \\\n",
       "pert_id       pert_name  cell_id primary_site    subtype                               moa                               Fold           \n",
       "BRD-A00520476 AF-DX-116  A375    skin            malignant melanoma                    Acetylcholine receptor antagonist 9     0.8570   \n",
       "                                                                                                                         7     0.6538   \n",
       "                                                                                                                         5     0.9545   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Acetylcholine receptor antagonist 8    -0.5759   \n",
       "                                                                                                                         7     0.8576   \n",
       "                                                                                                                         4     1.3092   \n",
       "                                                                                                                         7    -0.8234   \n",
       "                                                                                                                         1     0.1871   \n",
       "                                                                                                                         2     0.7798   \n",
       "                         HA1E    kidney          normal kidney                         Acetylcholine receptor antagonist 2    -1.3946   \n",
       "                                                                                                                         3    -0.5943   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Acetylcholine receptor antagonist 3    -0.7641   \n",
       "                                                                                                                         7    -5.6971   \n",
       "                                                                                                                         3    -0.1804   \n",
       "                                                                                                                         8    -0.9897   \n",
       "                         MCF7    breast          adenocarcinoma                        Acetylcholine receptor antagonist 4     0.4398   \n",
       "                                                                                                                         4     1.3244   \n",
       "                                                                                                                         2    -0.3302   \n",
       "                                                                                                                         6     0.1962   \n",
       "                         PC3     prostate        adenocarcinoma                        Acetylcholine receptor antagonist 9    -2.6171   \n",
       "                                                                                                                         5    -0.4823   \n",
       "                                                                                                                         3     3.1302   \n",
       "                                                                                                                         6    -0.4790   \n",
       "                                                                                                                         1    -0.8592   \n",
       "                                                                                                                         7    -0.1183   \n",
       "                                                                                                                         0     1.8189   \n",
       "                                                                                                                         1    -0.6316   \n",
       "                         VCAP    prostate        carcinoma                             Acetylcholine receptor antagonist 1    -0.0704   \n",
       "                                                                                                                         1    -0.1764   \n",
       "                                                                                                                         0    -0.8748   \n",
       "...                                                                                                                               ...   \n",
       "BRD-A00993607 alprenolol PC3     prostate        adenocarcinoma                        Adrenergic receptor antagonist    1    -0.5145   \n",
       "                                                                                                                         3    -4.2575   \n",
       "                                                                                                                         8    -1.7969   \n",
       "                                                                                                                         8    -0.9639   \n",
       "                         VCAP    prostate        carcinoma                             Adrenergic receptor antagonist    4     0.0046   \n",
       "                                                                                                                         3     0.1969   \n",
       "                                                                                                                         2    -0.1761   \n",
       "                                                                                                                         0     0.6411   \n",
       "                                                                                                                         2    -0.2182   \n",
       "                                                                                                                         4     0.2244   \n",
       "                                                                                                                         1    -0.2662   \n",
       "                                                                                                                         0    -0.7577   \n",
       "                                                                                                                         2     0.1465   \n",
       "                         A375    skin            malignant melanoma                    Adrenergic receptor antagonist    5     0.3596   \n",
       "                                                                                                                         3    -0.3712   \n",
       "                                                                                                                         3    -0.2916   \n",
       "                                                                                                                         6    -1.0301   \n",
       "                                                                                                                         1     1.1091   \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Adrenergic receptor antagonist    6    -0.5885   \n",
       "                                                                                                                         0     0.7044   \n",
       "                                                                                                                         6    -0.6571   \n",
       "                                                                                                                         0     1.2867   \n",
       "                                                                                                                         0     1.1639   \n",
       "                         ASC     adipose         normal primary adipocyte stem cells   Adrenergic receptor antagonist    2     0.4251   \n",
       "                                                                                                                         9     1.0688   \n",
       "                                                                                                                         7     0.7115   \n",
       "                         HEPG2   liver           hepatocellular carcinoma              Adrenergic receptor antagonist    6    -0.5680   \n",
       "                                                                                                                         6     0.2059   \n",
       "                                                                                                                         6     0.9938   \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Adrenergic receptor antagonist    9     0.3499   \n",
       "\n",
       "                                                                                                                                  ZW10  \n",
       "pert_id       pert_name  cell_id primary_site    subtype                               moa                               Fold           \n",
       "BRD-A00520476 AF-DX-116  A375    skin            malignant melanoma                    Acetylcholine receptor antagonist 9      0.5025  \n",
       "                                                                                                                         7     -0.9249  \n",
       "                                                                                                                         5     -2.4527  \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Acetylcholine receptor antagonist 8     -0.2426  \n",
       "                                                                                                                         7      0.3100  \n",
       "                                                                                                                         4     -2.6481  \n",
       "                                                                                                                         7     -0.1456  \n",
       "                                                                                                                         1      0.2322  \n",
       "                                                                                                                         2     -0.4633  \n",
       "                         HA1E    kidney          normal kidney                         Acetylcholine receptor antagonist 2      1.1338  \n",
       "                                                                                                                         3      0.0777  \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Acetylcholine receptor antagonist 3    -14.0374  \n",
       "                                                                                                                         7      2.2892  \n",
       "                                                                                                                         3      0.9388  \n",
       "                                                                                                                         8     -0.1203  \n",
       "                         MCF7    breast          adenocarcinoma                        Acetylcholine receptor antagonist 4     -0.5375  \n",
       "                                                                                                                         4     -1.5311  \n",
       "                                                                                                                         2     -0.9921  \n",
       "                                                                                                                         6      2.2593  \n",
       "                         PC3     prostate        adenocarcinoma                        Acetylcholine receptor antagonist 9      1.8982  \n",
       "                                                                                                                         5      0.2273  \n",
       "                                                                                                                         3      0.2802  \n",
       "                                                                                                                         6      1.3679  \n",
       "                                                                                                                         1      1.4526  \n",
       "                                                                                                                         7      1.1055  \n",
       "                                                                                                                         0      1.4120  \n",
       "                                                                                                                         1      0.0000  \n",
       "                         VCAP    prostate        carcinoma                             Acetylcholine receptor antagonist 1     -0.5691  \n",
       "                                                                                                                         1     -0.0616  \n",
       "                                                                                                                         0      0.0474  \n",
       "...                                                                                                                                ...  \n",
       "BRD-A00993607 alprenolol PC3     prostate        adenocarcinoma                        Adrenergic receptor antagonist    1      0.7270  \n",
       "                                                                                                                         3    -19.1175  \n",
       "                                                                                                                         8     -1.1847  \n",
       "                                                                                                                         8      0.3382  \n",
       "                         VCAP    prostate        carcinoma                             Adrenergic receptor antagonist    4      0.9947  \n",
       "                                                                                                                         3     -0.3626  \n",
       "                                                                                                                         2     -0.2978  \n",
       "                                                                                                                         0     -2.3905  \n",
       "                                                                                                                         2     -2.9677  \n",
       "                                                                                                                         4     -0.3989  \n",
       "                                                                                                                         1      1.0999  \n",
       "                                                                                                                         0      0.3681  \n",
       "                                                                                                                         2     -4.3926  \n",
       "                         A375    skin            malignant melanoma                    Adrenergic receptor antagonist    5     -5.0803  \n",
       "                                                                                                                         3      0.4687  \n",
       "                                                                                                                         3     -3.9976  \n",
       "                                                                                                                         6     -0.7273  \n",
       "                                                                                                                         1     -0.5989  \n",
       "                         A549    lung            non small cell lung cancer| carcinoma Adrenergic receptor antagonist    6     -0.1425  \n",
       "                                                                                                                         0     -0.6654  \n",
       "                                                                                                                         6     -0.3595  \n",
       "                                                                                                                         0      0.7235  \n",
       "                                                                                                                         0     -0.7995  \n",
       "                         ASC     adipose         normal primary adipocyte stem cells   Adrenergic receptor antagonist    2     -0.4371  \n",
       "                                                                                                                         9      3.9686  \n",
       "                                                                                                                         7     -0.7486  \n",
       "                         HEPG2   liver           hepatocellular carcinoma              Adrenergic receptor antagonist    6      0.4966  \n",
       "                                                                                                                         6     -1.2207  \n",
       "                                                                                                                         6      1.5999  \n",
       "                         HT29    large intestine colorectal adenocarcinoma             Adrenergic receptor antagonist    9      0.7003  \n",
       "\n",
       "[100 rows x 978 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "file_prostate.head(100) #show top 100 samples"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>pert_id</th>\n",
       "      <th>pert_name</th>\n",
       "      <th>cell_id</th>\n",
       "      <th>primary_site</th>\n",
       "      <th>subtype</th>\n",
       "      <th>moa</th>\n",
       "      <th>Fold</th>\n",
       "      <th>AARS</th>\n",
       "      <th>ABCB6</th>\n",
       "      <th>ABCC5</th>\n",
       "      <th>...</th>\n",
       "      <th>ZMIZ1</th>\n",
       "      <th>ZMYM2</th>\n",
       "      <th>ZNF131</th>\n",
       "      <th>ZNF274</th>\n",
       "      <th>ZNF318</th>\n",
       "      <th>ZNF395</th>\n",
       "      <th>ZNF451</th>\n",
       "      <th>ZNF586</th>\n",
       "      <th>ZNF589</th>\n",
       "      <th>ZW10</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BRD-A00520476</td>\n",
       "      <td>AF-DX-116</td>\n",
       "      <td>A375</td>\n",
       "      <td>skin</td>\n",
       "      <td>malignant melanoma</td>\n",
       "      <td>Acetylcholine receptor antagonist</td>\n",
       "      <td>9</td>\n",
       "      <td>-1.5594</td>\n",
       "      <td>6.0608</td>\n",
       "      <td>-1.1950</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.3345</td>\n",
       "      <td>1.4356</td>\n",
       "      <td>-0.0628</td>\n",
       "      <td>-0.0721</td>\n",
       "      <td>-0.8695</td>\n",
       "      <td>-0.5413</td>\n",
       "      <td>-0.8752</td>\n",
       "      <td>0.2187</td>\n",
       "      <td>0.8570</td>\n",
       "      <td>0.5025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BRD-A00520476</td>\n",
       "      <td>AF-DX-116</td>\n",
       "      <td>A375</td>\n",
       "      <td>skin</td>\n",
       "      <td>malignant melanoma</td>\n",
       "      <td>Acetylcholine receptor antagonist</td>\n",
       "      <td>7</td>\n",
       "      <td>-4.3904</td>\n",
       "      <td>0.7553</td>\n",
       "      <td>1.4643</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.4476</td>\n",
       "      <td>-0.5985</td>\n",
       "      <td>-0.8048</td>\n",
       "      <td>0.7390</td>\n",
       "      <td>1.2311</td>\n",
       "      <td>1.2392</td>\n",
       "      <td>1.4154</td>\n",
       "      <td>0.0942</td>\n",
       "      <td>0.6538</td>\n",
       "      <td>-0.9249</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BRD-A00520476</td>\n",
       "      <td>AF-DX-116</td>\n",
       "      <td>A375</td>\n",
       "      <td>skin</td>\n",
       "      <td>malignant melanoma</td>\n",
       "      <td>Acetylcholine receptor antagonist</td>\n",
       "      <td>5</td>\n",
       "      <td>1.0402</td>\n",
       "      <td>1.6024</td>\n",
       "      <td>6.8079</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.9437</td>\n",
       "      <td>-1.2552</td>\n",
       "      <td>-2.3513</td>\n",
       "      <td>2.2450</td>\n",
       "      <td>2.1778</td>\n",
       "      <td>0.6906</td>\n",
       "      <td>1.9346</td>\n",
       "      <td>1.8513</td>\n",
       "      <td>0.9545</td>\n",
       "      <td>-2.4527</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BRD-A00520476</td>\n",
       "      <td>AF-DX-116</td>\n",
       "      <td>A549</td>\n",
       "      <td>lung</td>\n",
       "      <td>non small cell lung cancer| carcinoma</td>\n",
       "      <td>Acetylcholine receptor antagonist</td>\n",
       "      <td>8</td>\n",
       "      <td>-0.2390</td>\n",
       "      <td>0.4851</td>\n",
       "      <td>0.2844</td>\n",
       "      <td>...</td>\n",
       "      <td>0.1460</td>\n",
       "      <td>-0.2967</td>\n",
       "      <td>0.8119</td>\n",
       "      <td>-0.6223</td>\n",
       "      <td>-0.9409</td>\n",
       "      <td>0.3434</td>\n",
       "      <td>-0.0792</td>\n",
       "      <td>0.3802</td>\n",
       "      <td>-0.5759</td>\n",
       "      <td>-0.2426</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BRD-A00520476</td>\n",
       "      <td>AF-DX-116</td>\n",
       "      <td>A549</td>\n",
       "      <td>lung</td>\n",
       "      <td>non small cell lung cancer| carcinoma</td>\n",
       "      <td>Acetylcholine receptor antagonist</td>\n",
       "      <td>7</td>\n",
       "      <td>0.5787</td>\n",
       "      <td>1.2204</td>\n",
       "      <td>-0.5552</td>\n",
       "      <td>...</td>\n",
       "      <td>1.4509</td>\n",
       "      <td>0.8935</td>\n",
       "      <td>-0.2784</td>\n",
       "      <td>1.9705</td>\n",
       "      <td>-1.0668</td>\n",
       "      <td>-1.6562</td>\n",
       "      <td>-0.6090</td>\n",
       "      <td>-1.4161</td>\n",
       "      <td>0.8576</td>\n",
       "      <td>0.3100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>BRD-A00520476</td>\n",
       "      <td>AF-DX-116</td>\n",
       "      <td>A549</td>\n",
       "      <td>lung</td>\n",
       "      <td>non small cell lung cancer| carcinoma</td>\n",
       "      <td>Acetylcholine receptor antagonist</td>\n",
       "      <td>4</td>\n",
       "      <td>-1.3419</td>\n",
       "      <td>1.1074</td>\n",
       "      <td>0.7377</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0347</td>\n",
       "      <td>1.3311</td>\n",
       "      <td>1.9123</td>\n",
       "      <td>2.2413</td>\n",
       "      <td>-0.3120</td>\n",
       "      <td>0.8101</td>\n",
       "      <td>-1.9130</td>\n",
       "      <td>-0.5680</td>\n",
       "      <td>1.3092</td>\n",
       "      <td>-2.6481</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>BRD-A00520476</td>\n",
       "      <td>AF-DX-116</td>\n",
       "      <td>A549</td>\n",
       "      <td>lung</td>\n",
       "      <td>non small cell lung cancer| carcinoma</td>\n",
       "      <td>Acetylcholine receptor antagonist</td>\n",
       "      <td>7</td>\n",
       "      <td>1.0551</td>\n",
       "      <td>1.2354</td>\n",
       "      <td>1.3601</td>\n",
       "      <td>...</td>\n",
       "      <td>0.4556</td>\n",
       "      <td>-0.0390</td>\n",
       "      <td>0.2839</td>\n",
       "      <td>0.4539</td>\n",
       "      <td>0.6926</td>\n",
       "      <td>-0.7972</td>\n",
       "      <td>0.4520</td>\n",
       "      <td>-5.8484</td>\n",
       "      <td>-0.8234</td>\n",
       "      <td>-0.1456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>BRD-A00520476</td>\n",
       "      <td>AF-DX-116</td>\n",
       "      <td>A549</td>\n",
       "      <td>lung</td>\n",
       "      <td>non small cell lung cancer| carcinoma</td>\n",
       "      <td>Acetylcholine receptor antagonist</td>\n",
       "      <td>1</td>\n",
       "      <td>0.1489</td>\n",
       "      <td>-2.4495</td>\n",
       "      <td>-0.4539</td>\n",
       "      <td>...</td>\n",
       "      <td>0.6499</td>\n",
       "      <td>-1.1728</td>\n",
       "      <td>2.9031</td>\n",
       "      <td>1.1496</td>\n",
       "      <td>2.4240</td>\n",
       "      <td>-0.7917</td>\n",
       "      <td>0.3044</td>\n",
       "      <td>-1.7361</td>\n",
       "      <td>0.1871</td>\n",
       "      <td>0.2322</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>BRD-A00520476</td>\n",
       "      <td>AF-DX-116</td>\n",
       "      <td>A549</td>\n",
       "      <td>lung</td>\n",
       "      <td>non small cell lung cancer| carcinoma</td>\n",
       "      <td>Acetylcholine receptor antagonist</td>\n",
       "      <td>2</td>\n",
       "      <td>-1.4213</td>\n",
       "      <td>0.3248</td>\n",
       "      <td>-0.6745</td>\n",
       "      <td>...</td>\n",
       "      <td>3.2142</td>\n",
       "      <td>-0.7427</td>\n",
       "      <td>0.2303</td>\n",
       "      <td>-0.0963</td>\n",
       "      <td>1.0515</td>\n",
       "      <td>1.8027</td>\n",
       "      <td>-0.0683</td>\n",
       "      <td>1.2841</td>\n",
       "      <td>0.7798</td>\n",
       "      <td>-0.4633</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>BRD-A00520476</td>\n",
       "      <td>AF-DX-116</td>\n",
       "      <td>HA1E</td>\n",
       "      <td>kidney</td>\n",
       "      <td>normal kidney</td>\n",
       "      <td>Acetylcholine receptor antagonist</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0560</td>\n",
       "      <td>-0.2165</td>\n",
       "      <td>0.4452</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0500</td>\n",
       "      <td>2.8327</td>\n",
       "      <td>-0.3044</td>\n",
       "      <td>5.0788</td>\n",
       "      <td>-0.8970</td>\n",
       "      <td>-5.7992</td>\n",
       "      <td>0.5842</td>\n",
       "      <td>-1.1536</td>\n",
       "      <td>-1.3946</td>\n",
       "      <td>1.1338</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>BRD-A00520476</td>\n",
       "      <td>AF-DX-116</td>\n",
       "      <td>HA1E</td>\n",
       "      <td>kidney</td>\n",
       "      <td>normal kidney</td>\n",
       "      <td>Acetylcholine receptor antagonist</td>\n",
       "      <td>3</td>\n",
       "      <td>-0.0518</td>\n",
       "      <td>0.5813</td>\n",
       "      <td>-0.1840</td>\n",
       "      <td>...</td>\n",
       "      <td>0.5897</td>\n",
       "      <td>1.8987</td>\n",
       "      <td>-0.2837</td>\n",
       "      <td>0.4608</td>\n",
       "      <td>-0.8980</td>\n",
       "      <td>-0.5850</td>\n",
       "      <td>0.3259</td>\n",
       "      <td>0.8394</td>\n",
       "      <td>-0.5943</td>\n",
       "      <td>0.0777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>BRD-A00520476</td>\n",
       "      <td>AF-DX-116</td>\n",
       "      <td>HT29</td>\n",
       "      <td>large intestine</td>\n",
       "      <td>colorectal adenocarcinoma</td>\n",
       "      <td>Acetylcholine receptor antagonist</td>\n",
       "      <td>3</td>\n",
       "      <td>-6.4517</td>\n",
       "      <td>2.3952</td>\n",
       "      <td>3.9664</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.6811</td>\n",
       "      <td>-2.0231</td>\n",
       "      <td>-1.7416</td>\n",
       "      <td>2.6361</td>\n",
       "      <td>2.8931</td>\n",
       "      <td>0.5410</td>\n",
       "      <td>2.2800</td>\n",
       "      <td>1.4823</td>\n",
       "      <td>-0.7641</td>\n",
       "      <td>-14.0374</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>BRD-A00520476</td>\n",
       "      <td>AF-DX-116</td>\n",
       "      <td>HT29</td>\n",
       "      <td>large intestine</td>\n",
       "      <td>colorectal adenocarcinoma</td>\n",
       "      <td>Acetylcholine receptor antagonist</td>\n",
       "      <td>7</td>\n",
       "      <td>-9.9143</td>\n",
       "      <td>1.6800</td>\n",
       "      <td>-0.5068</td>\n",
       "      <td>...</td>\n",
       "      <td>-4.2030</td>\n",
       "      <td>0.3622</td>\n",
       "      <td>-2.2260</td>\n",
       "      <td>1.7365</td>\n",
       "      <td>1.6679</td>\n",
       "      <td>1.0086</td>\n",
       "      <td>0.8317</td>\n",
       "      <td>0.9086</td>\n",
       "      <td>-5.6971</td>\n",
       "      <td>2.2892</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>BRD-A00520476</td>\n",
       "      <td>AF-DX-116</td>\n",
       "      <td>HT29</td>\n",
       "      <td>large intestine</td>\n",
       "      <td>colorectal adenocarcinoma</td>\n",
       "      <td>Acetylcholine receptor antagonist</td>\n",
       "      <td>3</td>\n",
       "      <td>-0.8978</td>\n",
       "      <td>-1.3619</td>\n",
       "      <td>-0.1906</td>\n",
       "      <td>...</td>\n",
       "      <td>0.6110</td>\n",
       "      <td>-1.1018</td>\n",
       "      <td>-0.4752</td>\n",
       "      <td>-0.7527</td>\n",
       "      <td>-0.7139</td>\n",
       "      <td>0.6623</td>\n",
       "      <td>-0.8649</td>\n",
       "      <td>-0.5935</td>\n",
       "      <td>-0.1804</td>\n",
       "      <td>0.9388</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>BRD-A00520476</td>\n",
       "      <td>AF-DX-116</td>\n",
       "      <td>HT29</td>\n",
       "      <td>large intestine</td>\n",
       "      <td>colorectal adenocarcinoma</td>\n",
       "      <td>Acetylcholine receptor antagonist</td>\n",
       "      <td>8</td>\n",
       "      <td>0.6745</td>\n",
       "      <td>1.9114</td>\n",
       "      <td>1.1192</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.2952</td>\n",
       "      <td>-0.4340</td>\n",
       "      <td>0.0893</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.5591</td>\n",
       "      <td>-0.9972</td>\n",
       "      <td>-0.3468</td>\n",
       "      <td>-1.1292</td>\n",
       "      <td>-0.9897</td>\n",
       "      <td>-0.1203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>BRD-A00520476</td>\n",
       "      <td>AF-DX-116</td>\n",
       "      <td>MCF7</td>\n",
       "      <td>breast</td>\n",
       "      <td>adenocarcinoma</td>\n",
       "      <td>Acetylcholine receptor antagonist</td>\n",
       "      <td>4</td>\n",
       "      <td>0.2640</td>\n",
       "      <td>-0.7579</td>\n",
       "      <td>-0.2044</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.0113</td>\n",
       "      <td>-3.5442</td>\n",
       "      <td>-0.5320</td>\n",
       "      <td>-0.4506</td>\n",
       "      <td>-0.6127</td>\n",
       "      <td>-0.1957</td>\n",
       "      <td>-0.0418</td>\n",
       "      <td>-0.1375</td>\n",
       "      <td>0.4398</td>\n",
       "      <td>-0.5375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>BRD-A00520476</td>\n",
       "      <td>AF-DX-116</td>\n",
       "      <td>MCF7</td>\n",
       "      <td>breast</td>\n",
       "      <td>adenocarcinoma</td>\n",
       "      <td>Acetylcholine receptor antagonist</td>\n",
       "      <td>4</td>\n",
       "      <td>1.3712</td>\n",
       "      <td>0.1030</td>\n",
       "      <td>-0.7772</td>\n",
       "      <td>...</td>\n",
       "      <td>-2.5038</td>\n",
       "      <td>-12.5829</td>\n",
       "      <td>-2.0656</td>\n",
       "      <td>1.2220</td>\n",
       "      <td>3.1535</td>\n",
       "      <td>1.2815</td>\n",
       "      <td>0.3204</td>\n",
       "      <td>2.3384</td>\n",
       "      <td>1.3244</td>\n",
       "      <td>-1.5311</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>BRD-A00520476</td>\n",
       "      <td>AF-DX-116</td>\n",
       "      <td>MCF7</td>\n",
       "      <td>breast</td>\n",
       "      <td>adenocarcinoma</td>\n",
       "      <td>Acetylcholine receptor antagonist</td>\n",
       "      <td>2</td>\n",
       "      <td>1.1265</td>\n",
       "      <td>1.7918</td>\n",
       "      <td>0.2110</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.3883</td>\n",
       "      <td>-3.4791</td>\n",
       "      <td>2.2421</td>\n",
       "      <td>0.8726</td>\n",
       "      <td>1.1940</td>\n",
       "      <td>-0.7088</td>\n",
       "      <td>11.0312</td>\n",
       "      <td>3.2814</td>\n",
       "      <td>-0.3302</td>\n",
       "      <td>-0.9921</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>BRD-A00520476</td>\n",
       "      <td>AF-DX-116</td>\n",
       "      <td>MCF7</td>\n",
       "      <td>breast</td>\n",
       "      <td>adenocarcinoma</td>\n",
       "      <td>Acetylcholine receptor antagonist</td>\n",
       "      <td>6</td>\n",
       "      <td>-0.1869</td>\n",
       "      <td>-0.2091</td>\n",
       "      <td>-0.9615</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.8963</td>\n",
       "      <td>-1.2209</td>\n",
       "      <td>1.1962</td>\n",
       "      <td>-0.4577</td>\n",
       "      <td>0.9054</td>\n",
       "      <td>-0.6353</td>\n",
       "      <td>-1.1797</td>\n",
       "      <td>0.9566</td>\n",
       "      <td>0.1962</td>\n",
       "      <td>2.2593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>BRD-A00520476</td>\n",
       "      <td>AF-DX-116</td>\n",
       "      <td>PC3</td>\n",
       "      <td>prostate</td>\n",
       "      <td>adenocarcinoma</td>\n",
       "      <td>Acetylcholine receptor antagonist</td>\n",
       "      <td>9</td>\n",
       "      <td>1.0671</td>\n",
       "      <td>1.4505</td>\n",
       "      <td>0.8168</td>\n",
       "      <td>...</td>\n",
       "      <td>0.8102</td>\n",
       "      <td>-0.0500</td>\n",
       "      <td>0.2484</td>\n",
       "      <td>-0.1549</td>\n",
       "      <td>-2.4221</td>\n",
       "      <td>0.3301</td>\n",
       "      <td>1.8588</td>\n",
       "      <td>0.3574</td>\n",
       "      <td>-2.6171</td>\n",
       "      <td>1.8982</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 985 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          pert_id  pert_name cell_id     primary_site  \\\n",
       "0   BRD-A00520476  AF-DX-116    A375             skin   \n",
       "1   BRD-A00520476  AF-DX-116    A375             skin   \n",
       "2   BRD-A00520476  AF-DX-116    A375             skin   \n",
       "3   BRD-A00520476  AF-DX-116    A549             lung   \n",
       "4   BRD-A00520476  AF-DX-116    A549             lung   \n",
       "5   BRD-A00520476  AF-DX-116    A549             lung   \n",
       "6   BRD-A00520476  AF-DX-116    A549             lung   \n",
       "7   BRD-A00520476  AF-DX-116    A549             lung   \n",
       "8   BRD-A00520476  AF-DX-116    A549             lung   \n",
       "9   BRD-A00520476  AF-DX-116    HA1E           kidney   \n",
       "10  BRD-A00520476  AF-DX-116    HA1E           kidney   \n",
       "11  BRD-A00520476  AF-DX-116    HT29  large intestine   \n",
       "12  BRD-A00520476  AF-DX-116    HT29  large intestine   \n",
       "13  BRD-A00520476  AF-DX-116    HT29  large intestine   \n",
       "14  BRD-A00520476  AF-DX-116    HT29  large intestine   \n",
       "15  BRD-A00520476  AF-DX-116    MCF7           breast   \n",
       "16  BRD-A00520476  AF-DX-116    MCF7           breast   \n",
       "17  BRD-A00520476  AF-DX-116    MCF7           breast   \n",
       "18  BRD-A00520476  AF-DX-116    MCF7           breast   \n",
       "19  BRD-A00520476  AF-DX-116     PC3         prostate   \n",
       "\n",
       "                                  subtype                                moa  \\\n",
       "0                      malignant melanoma  Acetylcholine receptor antagonist   \n",
       "1                      malignant melanoma  Acetylcholine receptor antagonist   \n",
       "2                      malignant melanoma  Acetylcholine receptor antagonist   \n",
       "3   non small cell lung cancer| carcinoma  Acetylcholine receptor antagonist   \n",
       "4   non small cell lung cancer| carcinoma  Acetylcholine receptor antagonist   \n",
       "5   non small cell lung cancer| carcinoma  Acetylcholine receptor antagonist   \n",
       "6   non small cell lung cancer| carcinoma  Acetylcholine receptor antagonist   \n",
       "7   non small cell lung cancer| carcinoma  Acetylcholine receptor antagonist   \n",
       "8   non small cell lung cancer| carcinoma  Acetylcholine receptor antagonist   \n",
       "9                           normal kidney  Acetylcholine receptor antagonist   \n",
       "10                          normal kidney  Acetylcholine receptor antagonist   \n",
       "11              colorectal adenocarcinoma  Acetylcholine receptor antagonist   \n",
       "12              colorectal adenocarcinoma  Acetylcholine receptor antagonist   \n",
       "13              colorectal adenocarcinoma  Acetylcholine receptor antagonist   \n",
       "14              colorectal adenocarcinoma  Acetylcholine receptor antagonist   \n",
       "15                         adenocarcinoma  Acetylcholine receptor antagonist   \n",
       "16                         adenocarcinoma  Acetylcholine receptor antagonist   \n",
       "17                         adenocarcinoma  Acetylcholine receptor antagonist   \n",
       "18                         adenocarcinoma  Acetylcholine receptor antagonist   \n",
       "19                         adenocarcinoma  Acetylcholine receptor antagonist   \n",
       "\n",
       "    Fold    AARS   ABCB6   ABCC5  ...   ZMIZ1    ZMYM2  ZNF131  ZNF274  \\\n",
       "0      9 -1.5594  6.0608 -1.1950  ... -0.3345   1.4356 -0.0628 -0.0721   \n",
       "1      7 -4.3904  0.7553  1.4643  ... -1.4476  -0.5985 -0.8048  0.7390   \n",
       "2      5  1.0402  1.6024  6.8079  ... -1.9437  -1.2552 -2.3513  2.2450   \n",
       "3      8 -0.2390  0.4851  0.2844  ...  0.1460  -0.2967  0.8119 -0.6223   \n",
       "4      7  0.5787  1.2204 -0.5552  ...  1.4509   0.8935 -0.2784  1.9705   \n",
       "5      4 -1.3419  1.1074  0.7377  ...  1.0347   1.3311  1.9123  2.2413   \n",
       "6      7  1.0551  1.2354  1.3601  ...  0.4556  -0.0390  0.2839  0.4539   \n",
       "7      1  0.1489 -2.4495 -0.4539  ...  0.6499  -1.1728  2.9031  1.1496   \n",
       "8      2 -1.4213  0.3248 -0.6745  ...  3.2142  -0.7427  0.2303 -0.0963   \n",
       "9      2  0.0560 -0.2165  0.4452  ...  0.0500   2.8327 -0.3044  5.0788   \n",
       "10     3 -0.0518  0.5813 -0.1840  ...  0.5897   1.8987 -0.2837  0.4608   \n",
       "11     3 -6.4517  2.3952  3.9664  ... -1.6811  -2.0231 -1.7416  2.6361   \n",
       "12     7 -9.9143  1.6800 -0.5068  ... -4.2030   0.3622 -2.2260  1.7365   \n",
       "13     3 -0.8978 -1.3619 -0.1906  ...  0.6110  -1.1018 -0.4752 -0.7527   \n",
       "14     8  0.6745  1.9114  1.1192  ... -0.2952  -0.4340  0.0893  0.0000   \n",
       "15     4  0.2640 -0.7579 -0.2044  ... -0.0113  -3.5442 -0.5320 -0.4506   \n",
       "16     4  1.3712  0.1030 -0.7772  ... -2.5038 -12.5829 -2.0656  1.2220   \n",
       "17     2  1.1265  1.7918  0.2110  ... -0.3883  -3.4791  2.2421  0.8726   \n",
       "18     6 -0.1869 -0.2091 -0.9615  ... -0.8963  -1.2209  1.1962 -0.4577   \n",
       "19     9  1.0671  1.4505  0.8168  ...  0.8102  -0.0500  0.2484 -0.1549   \n",
       "\n",
       "    ZNF318  ZNF395   ZNF451  ZNF586  ZNF589     ZW10  \n",
       "0  -0.8695 -0.5413  -0.8752  0.2187  0.8570   0.5025  \n",
       "1   1.2311  1.2392   1.4154  0.0942  0.6538  -0.9249  \n",
       "2   2.1778  0.6906   1.9346  1.8513  0.9545  -2.4527  \n",
       "3  -0.9409  0.3434  -0.0792  0.3802 -0.5759  -0.2426  \n",
       "4  -1.0668 -1.6562  -0.6090 -1.4161  0.8576   0.3100  \n",
       "5  -0.3120  0.8101  -1.9130 -0.5680  1.3092  -2.6481  \n",
       "6   0.6926 -0.7972   0.4520 -5.8484 -0.8234  -0.1456  \n",
       "7   2.4240 -0.7917   0.3044 -1.7361  0.1871   0.2322  \n",
       "8   1.0515  1.8027  -0.0683  1.2841  0.7798  -0.4633  \n",
       "9  -0.8970 -5.7992   0.5842 -1.1536 -1.3946   1.1338  \n",
       "10 -0.8980 -0.5850   0.3259  0.8394 -0.5943   0.0777  \n",
       "11  2.8931  0.5410   2.2800  1.4823 -0.7641 -14.0374  \n",
       "12  1.6679  1.0086   0.8317  0.9086 -5.6971   2.2892  \n",
       "13 -0.7139  0.6623  -0.8649 -0.5935 -0.1804   0.9388  \n",
       "14  1.5591 -0.9972  -0.3468 -1.1292 -0.9897  -0.1203  \n",
       "15 -0.6127 -0.1957  -0.0418 -0.1375  0.4398  -0.5375  \n",
       "16  3.1535  1.2815   0.3204  2.3384  1.3244  -1.5311  \n",
       "17  1.1940 -0.7088  11.0312  3.2814 -0.3302  -0.9921  \n",
       "18  0.9054 -0.6353  -1.1797  0.9566  0.1962   2.2593  \n",
       "19 -2.4221  0.3301   1.8588  0.3574 -2.6171   1.8982  \n",
       "\n",
       "[20 rows x 985 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_prostate=file_prostate.reset_index(level=[0,1,2,3,4,5,6]) #change from multi index to single index\n",
    "df_prostate.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DMSO                                       25638\n",
       "UnTrt                                      17397\n",
       "HDAC inhibitor                             14506\n",
       "Dopamine receptor antagonist                6218\n",
       "HSP inhibitor                               4341\n",
       "Cyclooxygenase inhibitor                    4325\n",
       "EMPTY_VECTOR                                4069\n",
       "Adrenergic receptor antagonist              3877\n",
       "Serotonin receptor antagonist               3359\n",
       "EGFR inhibitor                              3252\n",
       "Adrenergic receptor agonist                 3196\n",
       "Histamine receptor antagonist               2943\n",
       "CDK activator                               2893\n",
       "Acetylcholine receptor antagonist           2887\n",
       "Phosphodiesterase inhibitor                 2852\n",
       "Serotonin receptor agonist                  2815\n",
       "Estrogen receptor agonist                   2752\n",
       "Glutamate receptor antagonist               2469\n",
       "MTOR inhibitor                              2311\n",
       "Aurora kinase inhibitor                     2283\n",
       "Glucocorticoid receptor agonist             2278\n",
       "Calcium channel blocker                     2213\n",
       "PARP inhibitor                              2145\n",
       "Sodium channel blocker                      2097\n",
       "CDK inhibitor                               1863\n",
       "PI3K inhibitor                              1837\n",
       "RAF inhibitor                               1829\n",
       "Dopamine receptor agonist                   1759\n",
       "Topoisomerase inhibitor                     1758\n",
       "Tyrosine kinase inhibitor                   1758\n",
       "Retinoid receptor agonist                   1657\n",
       "Bacterial cell wall synthesis inhibitor     1653\n",
       "p38 MAPK inhibitor                          1368\n",
       "Tubulin inhibitor                           1353\n",
       "MEK inhibitor                               1298\n",
       "AKT inhibitor                               1248\n",
       "ATPase inhibitor                            1248\n",
       "PLK inhibitor                               1183\n",
       "PPAR receptor agonist                       1178\n",
       "Acetylcholine receptor agonist              1163\n",
       "NFkB pathway inhibitor                      1153\n",
       "Cytochrome P450 inhibitor                   1130\n",
       "Potassium channel blocker                   1075\n",
       "PKC inhibitor                               1050\n",
       "Adenosine receptor antagonist               1032\n",
       "Monoamine oxidase inhibitor                 1018\n",
       "Opioid receptor agonist                      964\n",
       "Angiotensin receptor antagonist              942\n",
       "IKK inhibitor                                828\n",
       "Name: moa, dtype: int64"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_prostate.moa.value_counts() # 9 classes of MOA. What is Fold  here in dataframe?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DMSO                    25638\n",
       "UnTrt                   17397\n",
       "vorinostat               7834\n",
       "EMPTY_VECTOR             4069\n",
       "geldanamycin             2991\n",
       "trichostatin-a           2893\n",
       "genistein                1130\n",
       "sirolimus                 848\n",
       "panobinostat              668\n",
       "thioridazine              621\n",
       "PCI-34051                 595\n",
       "tubastatin-a              577\n",
       "tacedinaline              575\n",
       "barasertib-HQPA           549\n",
       "diethylstilbestrol        542\n",
       "HDAC3-selective           534\n",
       "HDAC1-selective           531\n",
       "entinostat                461\n",
       "PLX-4720                  448\n",
       "olaparib                  436\n",
       "trifluoperazine           419\n",
       "apicidin                  414\n",
       "GSK-1070916               411\n",
       "ZM-447439                 410\n",
       "selumetinib               407\n",
       "vemurafenib               389\n",
       "gefitinib                 387\n",
       "alvocidib                 387\n",
       "GW-843682X                379\n",
       "pifithrin-mu              375\n",
       "                        ...  \n",
       "diphenoxylate              37\n",
       "zeranol                    37\n",
       "AF-DX-116                  37\n",
       "3-matida                   37\n",
       "lacidipine                 36\n",
       "levosulpiride              36\n",
       "pazufloxacin               36\n",
       "alosetron                  36\n",
       "halometasone               36\n",
       "cephalosporanic-acid       36\n",
       "cefpodoxime                36\n",
       "lobeline                   36\n",
       "oxiconazole                36\n",
       "benidipine                 36\n",
       "vincristine                36\n",
       "esomeprazole               36\n",
       "benactyzine                36\n",
       "nitrendipine               35\n",
       "nisoldipine                35\n",
       "tolterodine                35\n",
       "etoposide                  35\n",
       "amlodipine                 34\n",
       "vindesine                  34\n",
       "nomilin                    33\n",
       "PD-169316                  33\n",
       "cosmosiin                  33\n",
       "sarmentogenin              30\n",
       "LFM-A12                    30\n",
       "idarubicin                 29\n",
       "1-phenylbiguanide          28\n",
       "Name: pert_name, Length: 947, dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_prostate.pert_name.value_counts() #239 perturbagens"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "MCF7        26546\n",
       "PC3         23350\n",
       "VCAP        20336\n",
       "A549        13504\n",
       "A375        11909\n",
       "HT29        11588\n",
       "HA1E        10663\n",
       "HCC515       7941\n",
       "HEPG2        5641\n",
       "NPC          3968\n",
       "ASC          3033\n",
       "SKB          1986\n",
       "PHH          1816\n",
       "SKBR3        1747\n",
       "BT20         1603\n",
       "MDAMB231     1602\n",
       "NEU          1569\n",
       "MCF10A       1506\n",
       "HEK293T      1384\n",
       "HS578T       1297\n",
       "FIBRNPC       613\n",
       "SW620         330\n",
       "HUH7          324\n",
       "SW948         322\n",
       "RMUGS         247\n",
       "SW480         228\n",
       "SKMEL1        176\n",
       "LOVO          176\n",
       "OV7           168\n",
       "SKMEL28       166\n",
       "H1299         166\n",
       "CL34          163\n",
       "NCIH508       159\n",
       "SNUC5         147\n",
       "HEKTE          79\n",
       "NCIH716         8\n",
       "Name: cell_id, dtype: int64"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_prostate.cell_id.value_counts() #2 cell lines"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "prostate                  43686\n",
       "breast                    34301\n",
       "lung                      21611\n",
       "large intestine           13121\n",
       "skin                      12864\n",
       "kidney                    12126\n",
       "liver                      7781\n",
       "central nervous system     3968\n",
       "adipose                    3033\n",
       "muscle                     1986\n",
       "-666                       1569\n",
       "ovary                       415\n",
       "Name: primary_site, dtype: int64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_prostate.primary_site.value_counts() # 1 primary-site:prostate with 25565 samples"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "adenocarcinoma                           53245\n",
       "carcinoma                                31758\n",
       "non small cell lung cancer| carcinoma    13504\n",
       "colorectal adenocarcinoma                13121\n",
       "malignant melanoma                       12251\n",
       "normal kidney                            10663\n",
       "hepatocellular carcinoma                  5965\n",
       "normal stem fibroblast-derived iPScs      3968\n",
       "normal primary adipocyte stem cells       3033\n",
       "-666                                      2182\n",
       "myoblast                                  1986\n",
       "normal primary liver                      1816\n",
       "epithelial                                1585\n",
       "embryonal kidney                          1384\n",
       "Name: subtype, dtype: int64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_prostate.subtype.value_counts() #2 subtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Acetylcholine receptor antagonist',\n",
       "       'Acetylcholine receptor antagonist',\n",
       "       'Acetylcholine receptor antagonist', ..., 'EMPTY_VECTOR',\n",
       "       'EMPTY_VECTOR', 'EMPTY_VECTOR'], dtype=object)"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "prostate_y=df_prostate[\"moa\"].values #change moa column to numpy array\n",
    "prostate_y #predictor values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[-1.55939996,  6.06080008, -1.19500005, ...,  0.21870001,\n",
       "         0.85699999,  0.5025    ],\n",
       "       [-4.39039993,  0.75529999,  1.46430004, ...,  0.0942    ,\n",
       "         0.65380001, -0.9249    ],\n",
       "       [ 1.0402    ,  1.60239995,  6.80789995, ...,  1.8513    ,\n",
       "         0.95450002, -2.4526999 ],\n",
       "       ...,\n",
       "       [ 0.84429997, -1.21940005,  0.1869    , ...,  0.2313    ,\n",
       "        -0.0402    ,  0.95569998],\n",
       "       [-1.29639995, -0.34630001, -1.51810002, ..., -0.25659999,\n",
       "        -0.23379999, -0.58200002],\n",
       "       [-0.35589999,  0.70179999, -0.34310001, ..., -0.70649999,\n",
       "         0.84460002,  0.54409999]])"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_prostate= df_prostate.drop(columns=[\"pert_id\",\"pert_name\",\"cell_id\",\"primary_site\",\"subtype\",\"moa\",\"Fold\"])\n",
    "prostate_X=df_prostate.values #get the matrix\n",
    "prostate_X # feature values from 978 genes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Acetylcholine receptor antagonist' 'Adrenergic receptor antagonist'\n",
      " 'Adrenergic receptor agonist' 'Glucocorticoid receptor agonist'\n",
      " 'Opioid receptor agonist' 'Histamine receptor antagonist'\n",
      " 'Adenosine receptor antagonist' 'Calcium channel blocker' 'HSP inhibitor'\n",
      " 'Sodium channel blocker' 'Dopamine receptor agonist'\n",
      " 'Bacterial cell wall synthesis inhibitor' 'Glutamate receptor antagonist'\n",
      " 'ATPase inhibitor' 'Dopamine receptor antagonist' 'PI3K inhibitor'\n",
      " 'Potassium channel blocker' 'Serotonin receptor antagonist'\n",
      " 'Cyclooxygenase inhibitor' 'Acetylcholine receptor agonist'\n",
      " 'Estrogen receptor agonist' 'Serotonin receptor agonist' 'CDK activator'\n",
      " 'Tubulin inhibitor' 'Topoisomerase inhibitor' 'Cytochrome P450 inhibitor'\n",
      " 'HDAC inhibitor' 'Retinoid receptor agonist'\n",
      " 'Monoamine oxidase inhibitor' 'EGFR inhibitor' 'MTOR inhibitor'\n",
      " 'PPAR receptor agonist' 'IKK inhibitor' 'Phosphodiesterase inhibitor'\n",
      " 'Angiotensin receptor antagonist' 'NFkB pathway inhibitor'\n",
      " 'PARP inhibitor' 'RAF inhibitor' 'Tyrosine kinase inhibitor'\n",
      " 'AKT inhibitor' 'MEK inhibitor' 'p38 MAPK inhibitor' 'CDK inhibitor'\n",
      " 'PKC inhibitor' 'Aurora kinase inhibitor' 'PLK inhibitor' 'UnTrt' 'DMSO'\n",
      " 'EMPTY_VECTOR']\n",
      "[ 0  0  0 ... 48 48 48]\n"
     ]
    }
   ],
   "source": [
    "labels,uniques=pd.factorize(prostate_y) #labels are the encodings\n",
    "print(uniques)\n",
    "print(labels)\n",
    "prostate_y=labels"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[-0.8907516 ,  3.86091414, -0.57863416, ...,  0.0165087 ,\n",
       "         0.41149757,  0.2811565 ],\n",
       "       [-2.57906201,  0.50621107,  0.36108279, ..., -0.02512503,\n",
       "         0.28886065, -0.35779095],\n",
       "       [ 0.65955985,  1.04183802,  2.24935085, ...,  0.56246243,\n",
       "         0.47034158, -1.04168043],\n",
       "       ...,\n",
       "       [ 0.54273186, -0.74240492, -0.09031209, ...,  0.02072224,\n",
       "        -0.12998793,  0.48402253],\n",
       "       [-0.7339075 , -0.19033795, -0.692808  , ..., -0.14243519,\n",
       "        -0.24683099, -0.20429854],\n",
       "       [-0.17302587,  0.47238267, -0.27759821, ..., -0.29288514,\n",
       "         0.40401384,  0.29977791]])"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sc=StandardScaler()\n",
    "prostate_X=sc.fit_transform(prostate_X) #normalize feature data\n",
    "prostate_X"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "#SPLIT DATA\n",
    "X_train,X_test,y_train,y_test=train_test_split(prostate_X,prostate_y,test_size=0.2,random_state=42)#split into train and test"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Random Forest Classifier"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "rfc=RandomForestClassifier(n_estimators=200)\n",
    "rfc.fit(X_train,y_train) #fit random forest with training data \n",
    "pred_rfc=rfc.predict(X_test) #see how the test data is predicted"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([26, 47, 29, 47, 47, 47, 47,  8, 47, 47, 47,  8, 47, 47, 47, 47, 47,\n",
       "       47, 46, 26])"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pred_rfc[:20]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[[   3    0    0 ...   18  539    0]\n",
      " [   0    6    0 ...   24  632    0]\n",
      " [   0    0    4 ...   29  573    0]\n",
      " ...\n",
      " [   0    0    0 ... 2195 1264    0]\n",
      " [   0    0    0 ...  102 5088    0]\n",
      " [   0    0    0 ...  561  270    4]]\n",
      "              precision    recall  f1-score   support\n",
      "\n",
      "           0       0.60      0.01      0.01       583\n",
      "           1       0.38      0.01      0.02       710\n",
      "           2       0.50      0.01      0.01       634\n",
      "           3       0.71      0.14      0.24       453\n",
      "           4       1.00      0.00      0.01       205\n",
      "           5       0.71      0.01      0.02       588\n",
      "           6       1.00      0.07      0.12       212\n",
      "           7       0.50      0.00      0.00       441\n",
      "           8       0.84      0.72      0.78       859\n",
      "           9       1.00      0.01      0.01       433\n",
      "          10       0.00      0.00      0.00       337\n",
      "          11       0.00      0.00      0.00       290\n",
      "          12       0.50      0.00      0.00       487\n",
      "          13       0.99      0.48      0.65       253\n",
      "          14       0.37      0.28      0.31      1222\n",
      "          15       0.76      0.09      0.16       380\n",
      "          16       1.00      0.00      0.01       220\n",
      "          17       0.83      0.01      0.01       693\n",
      "          18       0.68      0.02      0.03       825\n",
      "          19       0.00      0.00      0.00       238\n",
      "          20       1.00      0.00      0.00       547\n",
      "          21       0.50      0.00      0.00       566\n",
      "          22       0.92      0.41      0.56       544\n",
      "          23       0.70      0.31      0.43       262\n",
      "          24       0.82      0.63      0.72       364\n",
      "          25       1.00      0.00      0.01       227\n",
      "          26       0.74      0.73      0.73      2909\n",
      "          27       0.96      0.14      0.24       321\n",
      "          28       1.00      0.00      0.01       210\n",
      "          29       0.56      0.14      0.22       673\n",
      "          30       0.71      0.68      0.69       456\n",
      "          31       0.00      0.00      0.00       232\n",
      "          32       1.00      0.06      0.12       170\n",
      "          33       1.00      0.00      0.00       575\n",
      "          34       0.00      0.00      0.00       187\n",
      "          35       1.00      0.03      0.06       246\n",
      "          36       1.00      0.01      0.01       458\n",
      "          37       0.78      0.12      0.21       378\n",
      "          38       0.86      0.02      0.03       342\n",
      "          39       0.73      0.14      0.24       212\n",
      "          40       0.65      0.16      0.26       255\n",
      "          41       0.00      0.00      0.00       256\n",
      "          42       0.78      0.34      0.47       364\n",
      "          43       1.00      0.12      0.22       203\n",
      "          44       0.95      0.09      0.16       478\n",
      "          45       0.94      0.11      0.20       267\n",
      "          46       0.62      0.63      0.63      3479\n",
      "          47       0.24      0.98      0.39      5212\n",
      "          48       1.00      0.00      0.01       837\n",
      "\n",
      "   micro avg       0.38      0.38      0.38     31293\n",
      "   macro avg       0.69      0.16      0.18     31293\n",
      "weighted avg       0.62      0.38      0.31     31293\n",
      "\n",
      "0.38369603425686255\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/rashid/.local/lib/python3.5/site-packages/sklearn/metrics/classification.py:1143: UndefinedMetricWarning: Precision and F-score are ill-defined and being set to 0.0 in labels with no predicted samples.\n",
      "  'precision', 'predicted', average, warn_for)\n"
     ]
    }
   ],
   "source": [
    "#METRICS\n",
    "print(confusion_matrix(y_test,pred_rfc))\n",
    "print(classification_report(y_test,pred_rfc))\n",
    "cm=accuracy_score(y_test,pred_rfc) #result for randomforest\n",
    "print(cm) #print precision score \n",
    "#results matches in the paper where accuracy is 60.4+/-0.48, macro F1 is 37.4 +/- 0.41. Took 4-5 minutes on macbook pro 2.7 GHz inter core i5 processor, 16 GB 1867 MHz DDR3 Memomry, Intel Iris Graphics 6100 1536 MB Graphics"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['randomForest_MOA_FullCurated']"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn.externals import joblib\n",
    "joblib.dump(rfc,'randomForest_MOA_FullCurated')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "rfc_benchmark=RandomForestClassifier(max_depth= 100, max_leaf_nodes= None, criterion= 'gini', n_estimators= 211, min_samples_split= 2, min_weight_fraction_leaf= 1.2722643563513202e-06, min_impurity_decrease= 1.6979071770883573e-05, min_samples_leaf= 1)\n",
    "rfc_benchmark.fit(X_train,y_train) #fit random forest with training data \n",
    "pred_rfc_benchmark=rfc_benchmark.predict(X_test) #see how the test data is predicted"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[[   3    0    0 ...   16  534    0]\n",
      " [   0    5    0 ...   15  635    0]\n",
      " [   0    0    4 ...   21  580    0]\n",
      " ...\n",
      " [   0    0    0 ... 2154 1307    0]\n",
      " [   0    0    0 ...   76 5112    0]\n",
      " [   0    0    0 ...  564  268    3]]\n",
      "              precision    recall  f1-score   support\n",
      "\n",
      "           0       1.00      0.01      0.01       583\n",
      "           1       0.56      0.01      0.01       710\n",
      "           2       0.80      0.01      0.01       634\n",
      "           3       0.71      0.15      0.24       453\n",
      "           4       1.00      0.00      0.01       205\n",
      "           5       1.00      0.01      0.02       588\n",
      "           6       1.00      0.05      0.10       212\n",
      "           7       1.00      0.00      0.00       441\n",
      "           8       0.84      0.71      0.77       859\n",
      "           9       1.00      0.01      0.01       433\n",
      "          10       0.00      0.00      0.00       337\n",
      "          11       0.00      0.00      0.00       290\n",
      "          12       0.50      0.00      0.00       487\n",
      "          13       0.98      0.49      0.66       253\n",
      "          14       0.38      0.28      0.33      1222\n",
      "          15       0.70      0.07      0.13       380\n",
      "          16       1.00      0.00      0.01       220\n",
      "          17       0.80      0.01      0.01       693\n",
      "          18       0.67      0.01      0.02       825\n",
      "          19       0.00      0.00      0.00       238\n",
      "          20       0.00      0.00      0.00       547\n",
      "          21       1.00      0.00      0.01       566\n",
      "          22       0.94      0.34      0.50       544\n",
      "          23       0.72      0.30      0.43       262\n",
      "          24       0.82      0.63      0.72       364\n",
      "          25       1.00      0.00      0.01       227\n",
      "          26       0.72      0.73      0.73      2909\n",
      "          27       1.00      0.15      0.26       321\n",
      "          28       1.00      0.00      0.01       210\n",
      "          29       0.59      0.12      0.20       673\n",
      "          30       0.70      0.66      0.68       456\n",
      "          31       0.00      0.00      0.00       232\n",
      "          32       1.00      0.03      0.06       170\n",
      "          33       1.00      0.00      0.00       575\n",
      "          34       0.00      0.00      0.00       187\n",
      "          35       1.00      0.03      0.06       246\n",
      "          36       1.00      0.00      0.00       458\n",
      "          37       0.75      0.12      0.21       378\n",
      "          38       0.80      0.01      0.02       342\n",
      "          39       0.77      0.13      0.22       212\n",
      "          40       0.62      0.17      0.27       255\n",
      "          41       0.00      0.00      0.00       256\n",
      "          42       0.74      0.32      0.45       364\n",
      "          43       1.00      0.11      0.20       203\n",
      "          44       0.94      0.09      0.17       478\n",
      "          45       0.92      0.09      0.16       267\n",
      "          46       0.64      0.62      0.63      3479\n",
      "          47       0.24      0.98      0.38      5212\n",
      "          48       1.00      0.00      0.01       837\n",
      "\n",
      "   micro avg       0.38      0.38      0.38     31293\n",
      "   macro avg       0.71      0.15      0.18     31293\n",
      "weighted avg       0.64      0.38      0.30     31293\n",
      "\n",
      "0.3800850030358227\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/rashid/.local/lib/python3.5/site-packages/sklearn/metrics/classification.py:1143: UndefinedMetricWarning: Precision and F-score are ill-defined and being set to 0.0 in labels with no predicted samples.\n",
      "  'precision', 'predicted', average, warn_for)\n"
     ]
    }
   ],
   "source": [
    "#METRICS\n",
    "print(confusion_matrix(y_test,pred_rfc_benchmark))\n",
    "print(classification_report(y_test,pred_rfc_benchmark))\n",
    "cm_benchmark=accuracy_score(y_test,pred_rfc_benchmark) #result for randomforest\n",
    "print(cm_benchmark) #print precision score \n",
    "#results matches in the paper where accuracy is 60.4+/-0.48, macro F1 is 37.4 +/- 0.41. Took 4-5 minutes on macbook pro 2.7 GHz inter core i5 processor, 16 GB 1867 MHz DDR3 Memomry, Intel Iris Graphics 6100 1536 MB Graphics"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['randomForest_MOA_FullCurated_Tuned']"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "joblib.dump(rfc_benchmark,'randomForest_MOA_FullCurated_Tuned')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}