Datathon_Main_Train.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Meta Data :\n",
    "1. ID: Unique identifier for each entry. --> ID is Important \n",
    "2. TargetID: Identifier for the target.\n",
    "3. DRUGID: Unique identifier for the drug.\n",
    "4. DRUGTYPE: Type of drug (e.g., small molecular drug).\n",
    "5. Drug_high_status: Approval status of the drug (e.g., Approved).\n",
    "6. DRUGNAME: Name of the drug.\n",
    "7. PUBCHCID: PubChem compound ID.\n",
    "8. Disease_of_highest_status: Disease associated with the highest status.\n",
    "9. Drug_Status: Status of the drug in the dataset.\n",
    "10. UNIPROID: UniProt identifier for the target protein.\n",
    "11. TARGNAME: Name of the target.\n",
    "12. GENENAME: Gene name associated with the target.\n",
    "13. SYNONYMS: Alternate names for the target.\n",
    "14. FUNCTION: Biological function of the target.\n",
    "15. BIOCLASS: Biological classification of the target.\n",
    "16. SEQUENCE: Amino acid sequence of the target protein.\n",
    "17. Disease: Disease associated with the drug.  --> Important\n",
    "18. Accession Number: Accession number in relevant databases.\n",
    "19. Target_Status: Current status of the target (e.g., Approved)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd \n",
    "import numpy as nd \n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import sklearn\n",
    "from sklearn.preprocessing import LabelEncoder, StandardScaler\n",
    "%matplotlib inline\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "drug_df = pd.read_csv(\"train.csv\")"
   ]
  },
  {
   "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>ID</th>\n",
       "      <th>TargetID</th>\n",
       "      <th>DRUGID</th>\n",
       "      <th>DRUGTYPE</th>\n",
       "      <th>Drug_high_status</th>\n",
       "      <th>DRUGNAME</th>\n",
       "      <th>PUBCHCID</th>\n",
       "      <th>Disease_of_highest_status</th>\n",
       "      <th>Drug_Status</th>\n",
       "      <th>UNIPROID</th>\n",
       "      <th>TARGNAME</th>\n",
       "      <th>GENENAME</th>\n",
       "      <th>SYNONYMS</th>\n",
       "      <th>FUNCTION</th>\n",
       "      <th>BIOCLASS</th>\n",
       "      <th>SEQUENCE</th>\n",
       "      <th>Disease</th>\n",
       "      <th>Accession Number</th>\n",
       "      <th>Target_Status</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>140736</td>\n",
       "      <td>T51115</td>\n",
       "      <td>D0L4YD</td>\n",
       "      <td>Small molecular drug</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Solifenacin</td>\n",
       "      <td>154059</td>\n",
       "      <td>Overactive bladder</td>\n",
       "      <td>Approved</td>\n",
       "      <td>CAC1C_HUMAN</td>\n",
       "      <td>Voltage-gated calcium channel alpha Cav1.2 (CA...</td>\n",
       "      <td>CACNA1C</td>\n",
       "      <td>Voltage-gated calcium channel subunit alpha Ca...</td>\n",
       "      <td>Mediates influx of calcium ions into the cytop...</td>\n",
       "      <td>Voltage-gated ion channel</td>\n",
       "      <td>MVNENTRMYIPEENHQGSNYGSPRPAHANMNANAAAGLAPEHIPTP...</td>\n",
       "      <td>Genetic cardiac arrhythmia</td>\n",
       "      <td>Q13936</td>\n",
       "      <td>Terminated</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>133048</td>\n",
       "      <td>T60529</td>\n",
       "      <td>D03NMM</td>\n",
       "      <td>Small molecular drug</td>\n",
       "      <td>Investigative</td>\n",
       "      <td>AM-643</td>\n",
       "      <td>46843035</td>\n",
       "      <td>Dermatological disease</td>\n",
       "      <td>Investigative</td>\n",
       "      <td>PGH1_HUMAN</td>\n",
       "      <td>Prostaglandin G/H synthase 1 (COX-1)</td>\n",
       "      <td>PTGS1</td>\n",
       "      <td>Prostaglandin-endoperoxide synthase 1; Prostag...</td>\n",
       "      <td>Converts arachidonate to prostaglandin H2 (PGH...</td>\n",
       "      <td>Paired donor oxygen oxidoreductase</td>\n",
       "      <td>MSRSLLLWFLLFLLLLPPLPVLLADPGAPTPVNPCCYYPCQHQGIC...</td>\n",
       "      <td>Rheumatoid arthritis</td>\n",
       "      <td>P23219</td>\n",
       "      <td>Approved</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>60493</td>\n",
       "      <td>T80975</td>\n",
       "      <td>D0T2ER</td>\n",
       "      <td>Small molecular drug</td>\n",
       "      <td>Phase 1</td>\n",
       "      <td>TAK-593</td>\n",
       "      <td>24767976</td>\n",
       "      <td>Solid tumour/cancer</td>\n",
       "      <td>Phase 1</td>\n",
       "      <td>VGFR2_HUMAN</td>\n",
       "      <td>Vascular endothelial growth factor receptor 2 ...</td>\n",
       "      <td>KDR</td>\n",
       "      <td>VEGFR2; VEGFR-2; VEGF-2 receptor; Protein-tyro...</td>\n",
       "      <td>Plays an essential role in the regulation of a...</td>\n",
       "      <td>Kinase</td>\n",
       "      <td>MQSKVLLAVALWLCVETRAASVGLPSVSLDLPRLSIQKDILTIKAN...</td>\n",
       "      <td>Renal cell carcinoma</td>\n",
       "      <td>P35968</td>\n",
       "      <td>Approved</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>169176</td>\n",
       "      <td>T92072</td>\n",
       "      <td>D07ESH</td>\n",
       "      <td>Small molecular drug</td>\n",
       "      <td>Discontinued in Phase 3</td>\n",
       "      <td>PF-1913539</td>\n",
       "      <td>176408</td>\n",
       "      <td>Alzheimer disease</td>\n",
       "      <td>Discontinued in Phase 3</td>\n",
       "      <td>AA1R_HUMAN</td>\n",
       "      <td>Adenosine A1 receptor (ADORA1)</td>\n",
       "      <td>ADORA1</td>\n",
       "      <td>Adenosine receptor A1; A(1) adenosine receptor</td>\n",
       "      <td>The activity of this receptor is mediated by G...</td>\n",
       "      <td>GPCR rhodopsin</td>\n",
       "      <td>MPPSISAFQAAYIGIEVLIALVSVPGNVLVIWAVKVNQALRDATFC...</td>\n",
       "      <td>Hyper-lipoproteinaemia</td>\n",
       "      <td>P30542</td>\n",
       "      <td>Phase 2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>120183</td>\n",
       "      <td>T30082</td>\n",
       "      <td>D0Q0RC</td>\n",
       "      <td>Small molecular drug</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Ethopropazine</td>\n",
       "      <td>3290</td>\n",
       "      <td>Parkinson disease</td>\n",
       "      <td>Approved</td>\n",
       "      <td>ACES_HUMAN</td>\n",
       "      <td>Acetylcholinesterase (AChE)</td>\n",
       "      <td>ACHE</td>\n",
       "      <td>YT; N-ACHE; ARACHE</td>\n",
       "      <td>Role in neuronal apoptosis. Terminates signal ...</td>\n",
       "      <td>Carboxylic ester hydrolase</td>\n",
       "      <td>MRPPQCLLHTPSLASPLLLLLLWLLGGGVGAEGREDAELLVTVRGG...</td>\n",
       "      <td>Oesophageal/gastroduodenal disorder</td>\n",
       "      <td>P22303</td>\n",
       "      <td>Approved</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>137655</td>\n",
       "      <td>T75243</td>\n",
       "      <td>D0W7HE</td>\n",
       "      <td>Small molecular drug</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Alpelisib</td>\n",
       "      <td>56649450</td>\n",
       "      <td>Solid tumour/cancer</td>\n",
       "      <td>Phase 2</td>\n",
       "      <td>MTOR_HUMAN</td>\n",
       "      <td>Serine/threonine-protein kinase mTOR (mTOR)</td>\n",
       "      <td>MTOR</td>\n",
       "      <td>Target of rapamycin; TOR kinase; Rapamycin tar...</td>\n",
       "      <td>MTOR directly or indirectly regulates the phos...</td>\n",
       "      <td>Kinase</td>\n",
       "      <td>MLGTGPAAATTAATTSSNVSVLQQFASGLKSRNEETRAKAAKELQH...</td>\n",
       "      <td>Bladder cancer</td>\n",
       "      <td>P42345</td>\n",
       "      <td>Phase 1/2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>86935</td>\n",
       "      <td>T85435</td>\n",
       "      <td>D0O0LS</td>\n",
       "      <td>Small molecular drug</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Entrectinib</td>\n",
       "      <td>25141092</td>\n",
       "      <td>Solid tumour/cancer</td>\n",
       "      <td>Phase 2</td>\n",
       "      <td>INSR_HUMAN</td>\n",
       "      <td>Insulin receptor (INSR)</td>\n",
       "      <td>INSR</td>\n",
       "      <td>IR; CD220 antigen; CD220</td>\n",
       "      <td>Binding of insulin leads to phosphorylation of...</td>\n",
       "      <td>Kinase</td>\n",
       "      <td>MATGGRRGAAAAPLLVAVAALLLGAAGHLYPGEVCPGMDIRNNLTR...</td>\n",
       "      <td>Acute diabete complication</td>\n",
       "      <td>P06213</td>\n",
       "      <td>Approved</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>96089</td>\n",
       "      <td>T40954</td>\n",
       "      <td>D0N0ES</td>\n",
       "      <td>Small molecular drug</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Vitamin B3</td>\n",
       "      <td>938</td>\n",
       "      <td>Lipid metabolism disorder</td>\n",
       "      <td>Approved</td>\n",
       "      <td>XDH_HUMAN</td>\n",
       "      <td>Xanthine dehydrogenase/oxidase (XDH)</td>\n",
       "      <td>XDH</td>\n",
       "      <td>Xanthine oxidase; Xanthine dehydrogenase; XDHA</td>\n",
       "      <td>Catalyzes the oxidation of hypoxanthine to xan...</td>\n",
       "      <td>CH/CH(2) oxidoreductase</td>\n",
       "      <td>MTADKLVFFVNGRKVVEKNADPETTLLAYLRRKLGLSGTKLGCGEG...</td>\n",
       "      <td>Encephalopathy</td>\n",
       "      <td>P47989</td>\n",
       "      <td>Phase 2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>142033</td>\n",
       "      <td>T21945</td>\n",
       "      <td>D04PXS</td>\n",
       "      <td>Small molecular drug</td>\n",
       "      <td>Phase 3</td>\n",
       "      <td>Amitifadine</td>\n",
       "      <td>11658655</td>\n",
       "      <td>Mood disorder</td>\n",
       "      <td>Phase 2</td>\n",
       "      <td>SC6A2_HUMAN</td>\n",
       "      <td>Norepinephrine transporter (NET)</td>\n",
       "      <td>SLC6A2</td>\n",
       "      <td>Solute carrier family 6 member 2; Sodium-depen...</td>\n",
       "      <td>Amine transporter. Terminates the action of no...</td>\n",
       "      <td>Neurotransmitter:sodium symporter</td>\n",
       "      <td>MLLARMNPQVQPENNGADTGPEQPLRARKTAELLVVKERNGVQCLL...</td>\n",
       "      <td>Pain</td>\n",
       "      <td>P23975</td>\n",
       "      <td>Approved</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>25065</td>\n",
       "      <td>T78709</td>\n",
       "      <td>D0P2QO</td>\n",
       "      <td>Small molecular drug</td>\n",
       "      <td>Phase 2</td>\n",
       "      <td>S-15535</td>\n",
       "      <td>132787</td>\n",
       "      <td>Anxiety disorder</td>\n",
       "      <td>Phase 2</td>\n",
       "      <td>5HT1A_HUMAN</td>\n",
       "      <td>5-HT 1A receptor (HTR1A)</td>\n",
       "      <td>HTR1A</td>\n",
       "      <td>Serotonin receptor 1A; G-21; ADRBRL1; ADRB2RL1...</td>\n",
       "      <td>Functions as a receptor for various drugs and ...</td>\n",
       "      <td>GPCR rhodopsin</td>\n",
       "      <td>MDVLSPGQGNNTTSPPAPFETGGNTTGISDVTVSYQVITSLLLGTL...</td>\n",
       "      <td>Attention deficit hyperactivity disorder</td>\n",
       "      <td>P08908</td>\n",
       "      <td>Phase 3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>178844</td>\n",
       "      <td>T70977</td>\n",
       "      <td>D08DHN</td>\n",
       "      <td>Small molecular drug</td>\n",
       "      <td>Phase 3</td>\n",
       "      <td>VX-787</td>\n",
       "      <td>67286591</td>\n",
       "      <td>Influenza A virus infection</td>\n",
       "      <td>Phase 3</td>\n",
       "      <td>GSK3B_HUMAN</td>\n",
       "      <td>Glycogen synthase kinase-3 beta (GSK-3B)</td>\n",
       "      <td>GSK3B</td>\n",
       "      <td>Serine/threonine-protein kinase GSK3B; GSK-3 beta</td>\n",
       "      <td>Requires primed phosphorylation of the majorit...</td>\n",
       "      <td>Kinase</td>\n",
       "      <td>MSGRPRTTSFAESCKPVQQPSAFGSMKVSRDKDGSKVTTVVATPGQ...</td>\n",
       "      <td>Allergic/hypersensitivity disorder</td>\n",
       "      <td>P49841</td>\n",
       "      <td>Patented</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>104739</td>\n",
       "      <td>T49507</td>\n",
       "      <td>D0W5HK</td>\n",
       "      <td>Small molecular drug</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Sorafenib</td>\n",
       "      <td>216239</td>\n",
       "      <td>Renal cell carcinoma</td>\n",
       "      <td>Approved</td>\n",
       "      <td>EPHB4_HUMAN</td>\n",
       "      <td>Ephrin type-B receptor 4 (EPHB4)</td>\n",
       "      <td>EPHB4</td>\n",
       "      <td>Tyrosine-protein kinase TYRO11; TYRO11; MYK1; ...</td>\n",
       "      <td>Receptor tyrosine kinase which binds promiscuo...</td>\n",
       "      <td>Kinase</td>\n",
       "      <td>MELRVLLCWASLAAALEETLLNTKLETADLKWVTFPQVDGQWEELS...</td>\n",
       "      <td>Lung cancer</td>\n",
       "      <td>P54760</td>\n",
       "      <td>Phase 2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>139458</td>\n",
       "      <td>T20401</td>\n",
       "      <td>D0R0FO</td>\n",
       "      <td>Small molecular drug</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Lenvatinib</td>\n",
       "      <td>9823820</td>\n",
       "      <td>Ovarian cancer</td>\n",
       "      <td>Phase 1</td>\n",
       "      <td>CAH2_HUMAN</td>\n",
       "      <td>Carbonic anhydrase II (CA-II)</td>\n",
       "      <td>CA2</td>\n",
       "      <td>Carbonic anhydrase C; Carbonic anhydrase 2; Ca...</td>\n",
       "      <td>Reversible hydration of carbon dioxide. Can hy...</td>\n",
       "      <td>Alpha-carbonic anhydrase</td>\n",
       "      <td>MSHHWGYGKHNGPEHWHKDFPIAKGERQSPVDIDTHTAKYDPSLKP...</td>\n",
       "      <td>Essential hypertension</td>\n",
       "      <td>P00918</td>\n",
       "      <td>Approved</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>104249</td>\n",
       "      <td>T62460</td>\n",
       "      <td>D0O0LS</td>\n",
       "      <td>Small molecular drug</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Entrectinib</td>\n",
       "      <td>25141092</td>\n",
       "      <td>Solid tumour/cancer</td>\n",
       "      <td>Phase 2</td>\n",
       "      <td>JAK1_HUMAN</td>\n",
       "      <td>Janus kinase 1 (JAK-1)</td>\n",
       "      <td>JAK1</td>\n",
       "      <td>Tyrosine-protein kinase JAK1; JAK1B; JAK1A</td>\n",
       "      <td>Kinase partner for the interleukin (IL)-2 rece...</td>\n",
       "      <td>Kinase</td>\n",
       "      <td>MQYLNIKEDCNAMAFCAKMRSSKKTEVNLEAPEPGVEVIFYLSDRE...</td>\n",
       "      <td>Cutaneous lupus erythematosus</td>\n",
       "      <td>P23458</td>\n",
       "      <td>Phase 2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>167605</td>\n",
       "      <td>T92609</td>\n",
       "      <td>D0Z3UP</td>\n",
       "      <td>Small molecular drug</td>\n",
       "      <td>Discontinued in Phase 2</td>\n",
       "      <td>Dabuzalgron</td>\n",
       "      <td>216249</td>\n",
       "      <td>Urinary incontinence</td>\n",
       "      <td>Discontinued in Phase 2</td>\n",
       "      <td>ADA1A_HUMAN</td>\n",
       "      <td>Adrenergic receptor alpha-1A (ADRA1A)</td>\n",
       "      <td>ADRA1A</td>\n",
       "      <td>Alpha-adrenergic receptor 1c; Alpha-1C adrener...</td>\n",
       "      <td>Its effect is mediated by G(q) and G(11) prote...</td>\n",
       "      <td>GPCR rhodopsin</td>\n",
       "      <td>MVFLSGNASDSSNCTQPPAPVNISKAILLGVILGGLILFGVLGNIL...</td>\n",
       "      <td>Abnormal micturition</td>\n",
       "      <td>P35348</td>\n",
       "      <td>Discontinued in Phase 2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>188631</td>\n",
       "      <td>T74312</td>\n",
       "      <td>D09KTS</td>\n",
       "      <td>Small molecular drug</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Ibrutinib</td>\n",
       "      <td>24821094</td>\n",
       "      <td>Solid tumour/cancer</td>\n",
       "      <td>Phase 2</td>\n",
       "      <td>FLT3_HUMAN</td>\n",
       "      <td>Fms-like tyrosine kinase 3 (FLT-3)</td>\n",
       "      <td>FLT3</td>\n",
       "      <td>Stem cell tyrosine kinase 1; STK1; STK-1; Rece...</td>\n",
       "      <td>Tyrosine-protein kinase that acts as cell-surf...</td>\n",
       "      <td>Kinase</td>\n",
       "      <td>MPALARDGGQLPLLVVFSAMIFGTITNQDLPVIKCVLINHKNNDSS...</td>\n",
       "      <td>Lung cancer</td>\n",
       "      <td>P36888</td>\n",
       "      <td>Phase 3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>37083</td>\n",
       "      <td>T63505</td>\n",
       "      <td>D00DRL</td>\n",
       "      <td>Small molecular drug</td>\n",
       "      <td>Phase 1/2</td>\n",
       "      <td>MK-2461</td>\n",
       "      <td>44137946</td>\n",
       "      <td>Alzheimer disease</td>\n",
       "      <td>Phase 1/2</td>\n",
       "      <td>ABL1_HUMAN</td>\n",
       "      <td>Tyrosine-protein kinase ABL1 (ABL)</td>\n",
       "      <td>ABL1</td>\n",
       "      <td>p150; Proto-oncogene tyrosine-protein kinase A...</td>\n",
       "      <td>Coordinates actin remodeling through tyrosine ...</td>\n",
       "      <td>Kinase</td>\n",
       "      <td>MLEICLKLVGCKSKKGLSSSSSCYLEEALQRPVASDFEPQGLSEAA...</td>\n",
       "      <td>Cardiovascular disease</td>\n",
       "      <td>P00519</td>\n",
       "      <td>Phase 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>62037</td>\n",
       "      <td>T31204</td>\n",
       "      <td>D0B7SP</td>\n",
       "      <td>Small molecular drug</td>\n",
       "      <td>Discontinued in Phase 2</td>\n",
       "      <td>GSK163090</td>\n",
       "      <td>11292933</td>\n",
       "      <td>Major depressive disorder</td>\n",
       "      <td>Discontinued in Phase 2</td>\n",
       "      <td>5HT2B_HUMAN</td>\n",
       "      <td>5-HT 2B receptor (HTR2B)</td>\n",
       "      <td>HTR2B</td>\n",
       "      <td>Serotonin receptor 2B; 5-hydroxytryptamine rec...</td>\n",
       "      <td>Functions as a receptor for various ergot alka...</td>\n",
       "      <td>GPCR rhodopsin</td>\n",
       "      <td>MALSYRVSELQSTIPEHILQSTFVHVISSNWSGLQTESIPEEMKQI...</td>\n",
       "      <td>Irritable bowel syndrome</td>\n",
       "      <td>P41595</td>\n",
       "      <td>Investigative</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>12571</td>\n",
       "      <td>T95913</td>\n",
       "      <td>D0B3HD</td>\n",
       "      <td>Small molecular drug</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Caffeine</td>\n",
       "      <td>2519</td>\n",
       "      <td>Orthostatic hypotension</td>\n",
       "      <td>Approved</td>\n",
       "      <td>PK3CG_HUMAN</td>\n",
       "      <td>PI3-kinase gamma (PIK3CG)</td>\n",
       "      <td>PIK3CG</td>\n",
       "      <td>p120-PI3K; p110gamma; Serine/threonine protein...</td>\n",
       "      <td>Phosphoinositide-3-kinase (PI3K) that phosphor...</td>\n",
       "      <td>Kinase</td>\n",
       "      <td>MELENYKQPVVLREDNCRRRRRMKPRSAAASLSSMELIPIEFVLPT...</td>\n",
       "      <td>Prostate cancer</td>\n",
       "      <td>P48736</td>\n",
       "      <td>Investigative</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>105753</td>\n",
       "      <td>T10265</td>\n",
       "      <td>D0R4UW</td>\n",
       "      <td>Small molecular drug</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Roflumilast</td>\n",
       "      <td>449193</td>\n",
       "      <td>Asthma</td>\n",
       "      <td>Approved</td>\n",
       "      <td>PDE4B_HUMAN</td>\n",
       "      <td>Phosphodiesterase 4B (PDE4B)</td>\n",
       "      <td>PDE4B</td>\n",
       "      <td>cAMP-specific 3',5'-cyclic phosphodiesterase 4...</td>\n",
       "      <td>May be involved in mediating central nervous s...</td>\n",
       "      <td>Phosphoric diester hydrolase</td>\n",
       "      <td>MKKSRSVMTVMADDNVKDYFECSLSKSYSSSSNTLGIDLWRGRRCC...</td>\n",
       "      <td>Postoperative inflammation</td>\n",
       "      <td>Q07343</td>\n",
       "      <td>Investigative</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        ID TargetID  DRUGID              DRUGTYPE         Drug_high_status  \\\n",
       "0   140736   T51115  D0L4YD  Small molecular drug                 Approved   \n",
       "1   133048   T60529  D03NMM  Small molecular drug            Investigative   \n",
       "2    60493   T80975  D0T2ER  Small molecular drug                  Phase 1   \n",
       "3   169176   T92072  D07ESH  Small molecular drug  Discontinued in Phase 3   \n",
       "4   120183   T30082  D0Q0RC  Small molecular drug                 Approved   \n",
       "5   137655   T75243  D0W7HE  Small molecular drug                 Approved   \n",
       "6    86935   T85435  D0O0LS  Small molecular drug                 Approved   \n",
       "7    96089   T40954  D0N0ES  Small molecular drug                 Approved   \n",
       "8   142033   T21945  D04PXS  Small molecular drug                  Phase 3   \n",
       "9    25065   T78709  D0P2QO  Small molecular drug                  Phase 2   \n",
       "10  178844   T70977  D08DHN  Small molecular drug                  Phase 3   \n",
       "11  104739   T49507  D0W5HK  Small molecular drug                 Approved   \n",
       "12  139458   T20401  D0R0FO  Small molecular drug                 Approved   \n",
       "13  104249   T62460  D0O0LS  Small molecular drug                 Approved   \n",
       "14  167605   T92609  D0Z3UP  Small molecular drug  Discontinued in Phase 2   \n",
       "15  188631   T74312  D09KTS  Small molecular drug                 Approved   \n",
       "16   37083   T63505  D00DRL  Small molecular drug                Phase 1/2   \n",
       "17   62037   T31204  D0B7SP  Small molecular drug  Discontinued in Phase 2   \n",
       "18   12571   T95913  D0B3HD  Small molecular drug                 Approved   \n",
       "19  105753   T10265  D0R4UW  Small molecular drug                 Approved   \n",
       "\n",
       "         DRUGNAME  PUBCHCID    Disease_of_highest_status  \\\n",
       "0     Solifenacin    154059           Overactive bladder   \n",
       "1          AM-643  46843035       Dermatological disease   \n",
       "2         TAK-593  24767976          Solid tumour/cancer   \n",
       "3      PF-1913539    176408            Alzheimer disease   \n",
       "4   Ethopropazine      3290            Parkinson disease   \n",
       "5       Alpelisib  56649450          Solid tumour/cancer   \n",
       "6     Entrectinib  25141092          Solid tumour/cancer   \n",
       "7      Vitamin B3       938    Lipid metabolism disorder   \n",
       "8     Amitifadine  11658655                Mood disorder   \n",
       "9         S-15535    132787             Anxiety disorder   \n",
       "10         VX-787  67286591  Influenza A virus infection   \n",
       "11      Sorafenib    216239         Renal cell carcinoma   \n",
       "12     Lenvatinib   9823820               Ovarian cancer   \n",
       "13    Entrectinib  25141092          Solid tumour/cancer   \n",
       "14    Dabuzalgron    216249         Urinary incontinence   \n",
       "15      Ibrutinib  24821094          Solid tumour/cancer   \n",
       "16        MK-2461  44137946            Alzheimer disease   \n",
       "17      GSK163090  11292933    Major depressive disorder   \n",
       "18       Caffeine      2519      Orthostatic hypotension   \n",
       "19    Roflumilast    449193                       Asthma   \n",
       "\n",
       "                Drug_Status     UNIPROID  \\\n",
       "0                  Approved  CAC1C_HUMAN   \n",
       "1             Investigative   PGH1_HUMAN   \n",
       "2                   Phase 1  VGFR2_HUMAN   \n",
       "3   Discontinued in Phase 3   AA1R_HUMAN   \n",
       "4                  Approved   ACES_HUMAN   \n",
       "5                   Phase 2   MTOR_HUMAN   \n",
       "6                   Phase 2   INSR_HUMAN   \n",
       "7                  Approved    XDH_HUMAN   \n",
       "8                   Phase 2  SC6A2_HUMAN   \n",
       "9                   Phase 2  5HT1A_HUMAN   \n",
       "10                  Phase 3  GSK3B_HUMAN   \n",
       "11                 Approved  EPHB4_HUMAN   \n",
       "12                  Phase 1   CAH2_HUMAN   \n",
       "13                  Phase 2   JAK1_HUMAN   \n",
       "14  Discontinued in Phase 2  ADA1A_HUMAN   \n",
       "15                  Phase 2   FLT3_HUMAN   \n",
       "16                Phase 1/2   ABL1_HUMAN   \n",
       "17  Discontinued in Phase 2  5HT2B_HUMAN   \n",
       "18                 Approved  PK3CG_HUMAN   \n",
       "19                 Approved  PDE4B_HUMAN   \n",
       "\n",
       "                                             TARGNAME GENENAME  \\\n",
       "0   Voltage-gated calcium channel alpha Cav1.2 (CA...  CACNA1C   \n",
       "1                Prostaglandin G/H synthase 1 (COX-1)    PTGS1   \n",
       "2   Vascular endothelial growth factor receptor 2 ...      KDR   \n",
       "3                      Adenosine A1 receptor (ADORA1)   ADORA1   \n",
       "4                         Acetylcholinesterase (AChE)     ACHE   \n",
       "5         Serine/threonine-protein kinase mTOR (mTOR)     MTOR   \n",
       "6                             Insulin receptor (INSR)     INSR   \n",
       "7                Xanthine dehydrogenase/oxidase (XDH)      XDH   \n",
       "8                    Norepinephrine transporter (NET)   SLC6A2   \n",
       "9                            5-HT 1A receptor (HTR1A)    HTR1A   \n",
       "10           Glycogen synthase kinase-3 beta (GSK-3B)    GSK3B   \n",
       "11                   Ephrin type-B receptor 4 (EPHB4)    EPHB4   \n",
       "12                      Carbonic anhydrase II (CA-II)      CA2   \n",
       "13                             Janus kinase 1 (JAK-1)     JAK1   \n",
       "14              Adrenergic receptor alpha-1A (ADRA1A)   ADRA1A   \n",
       "15                 Fms-like tyrosine kinase 3 (FLT-3)     FLT3   \n",
       "16                 Tyrosine-protein kinase ABL1 (ABL)     ABL1   \n",
       "17                           5-HT 2B receptor (HTR2B)    HTR2B   \n",
       "18                          PI3-kinase gamma (PIK3CG)   PIK3CG   \n",
       "19                       Phosphodiesterase 4B (PDE4B)    PDE4B   \n",
       "\n",
       "                                             SYNONYMS  \\\n",
       "0   Voltage-gated calcium channel subunit alpha Ca...   \n",
       "1   Prostaglandin-endoperoxide synthase 1; Prostag...   \n",
       "2   VEGFR2; VEGFR-2; VEGF-2 receptor; Protein-tyro...   \n",
       "3      Adenosine receptor A1; A(1) adenosine receptor   \n",
       "4                                  YT; N-ACHE; ARACHE   \n",
       "5   Target of rapamycin; TOR kinase; Rapamycin tar...   \n",
       "6                            IR; CD220 antigen; CD220   \n",
       "7      Xanthine oxidase; Xanthine dehydrogenase; XDHA   \n",
       "8   Solute carrier family 6 member 2; Sodium-depen...   \n",
       "9   Serotonin receptor 1A; G-21; ADRBRL1; ADRB2RL1...   \n",
       "10  Serine/threonine-protein kinase GSK3B; GSK-3 beta   \n",
       "11  Tyrosine-protein kinase TYRO11; TYRO11; MYK1; ...   \n",
       "12  Carbonic anhydrase C; Carbonic anhydrase 2; Ca...   \n",
       "13         Tyrosine-protein kinase JAK1; JAK1B; JAK1A   \n",
       "14  Alpha-adrenergic receptor 1c; Alpha-1C adrener...   \n",
       "15  Stem cell tyrosine kinase 1; STK1; STK-1; Rece...   \n",
       "16  p150; Proto-oncogene tyrosine-protein kinase A...   \n",
       "17  Serotonin receptor 2B; 5-hydroxytryptamine rec...   \n",
       "18  p120-PI3K; p110gamma; Serine/threonine protein...   \n",
       "19  cAMP-specific 3',5'-cyclic phosphodiesterase 4...   \n",
       "\n",
       "                                             FUNCTION  \\\n",
       "0   Mediates influx of calcium ions into the cytop...   \n",
       "1   Converts arachidonate to prostaglandin H2 (PGH...   \n",
       "2   Plays an essential role in the regulation of a...   \n",
       "3   The activity of this receptor is mediated by G...   \n",
       "4   Role in neuronal apoptosis. Terminates signal ...   \n",
       "5   MTOR directly or indirectly regulates the phos...   \n",
       "6   Binding of insulin leads to phosphorylation of...   \n",
       "7   Catalyzes the oxidation of hypoxanthine to xan...   \n",
       "8   Amine transporter. Terminates the action of no...   \n",
       "9   Functions as a receptor for various drugs and ...   \n",
       "10  Requires primed phosphorylation of the majorit...   \n",
       "11  Receptor tyrosine kinase which binds promiscuo...   \n",
       "12  Reversible hydration of carbon dioxide. Can hy...   \n",
       "13  Kinase partner for the interleukin (IL)-2 rece...   \n",
       "14  Its effect is mediated by G(q) and G(11) prote...   \n",
       "15  Tyrosine-protein kinase that acts as cell-surf...   \n",
       "16  Coordinates actin remodeling through tyrosine ...   \n",
       "17  Functions as a receptor for various ergot alka...   \n",
       "18  Phosphoinositide-3-kinase (PI3K) that phosphor...   \n",
       "19  May be involved in mediating central nervous s...   \n",
       "\n",
       "                              BIOCLASS  \\\n",
       "0            Voltage-gated ion channel   \n",
       "1   Paired donor oxygen oxidoreductase   \n",
       "2                               Kinase   \n",
       "3                       GPCR rhodopsin   \n",
       "4           Carboxylic ester hydrolase   \n",
       "5                               Kinase   \n",
       "6                               Kinase   \n",
       "7              CH/CH(2) oxidoreductase   \n",
       "8    Neurotransmitter:sodium symporter   \n",
       "9                       GPCR rhodopsin   \n",
       "10                              Kinase   \n",
       "11                              Kinase   \n",
       "12            Alpha-carbonic anhydrase   \n",
       "13                              Kinase   \n",
       "14                      GPCR rhodopsin   \n",
       "15                              Kinase   \n",
       "16                              Kinase   \n",
       "17                      GPCR rhodopsin   \n",
       "18                              Kinase   \n",
       "19        Phosphoric diester hydrolase   \n",
       "\n",
       "                                             SEQUENCE  \\\n",
       "0   MVNENTRMYIPEENHQGSNYGSPRPAHANMNANAAAGLAPEHIPTP...   \n",
       "1   MSRSLLLWFLLFLLLLPPLPVLLADPGAPTPVNPCCYYPCQHQGIC...   \n",
       "2   MQSKVLLAVALWLCVETRAASVGLPSVSLDLPRLSIQKDILTIKAN...   \n",
       "3   MPPSISAFQAAYIGIEVLIALVSVPGNVLVIWAVKVNQALRDATFC...   \n",
       "4   MRPPQCLLHTPSLASPLLLLLLWLLGGGVGAEGREDAELLVTVRGG...   \n",
       "5   MLGTGPAAATTAATTSSNVSVLQQFASGLKSRNEETRAKAAKELQH...   \n",
       "6   MATGGRRGAAAAPLLVAVAALLLGAAGHLYPGEVCPGMDIRNNLTR...   \n",
       "7   MTADKLVFFVNGRKVVEKNADPETTLLAYLRRKLGLSGTKLGCGEG...   \n",
       "8   MLLARMNPQVQPENNGADTGPEQPLRARKTAELLVVKERNGVQCLL...   \n",
       "9   MDVLSPGQGNNTTSPPAPFETGGNTTGISDVTVSYQVITSLLLGTL...   \n",
       "10  MSGRPRTTSFAESCKPVQQPSAFGSMKVSRDKDGSKVTTVVATPGQ...   \n",
       "11  MELRVLLCWASLAAALEETLLNTKLETADLKWVTFPQVDGQWEELS...   \n",
       "12  MSHHWGYGKHNGPEHWHKDFPIAKGERQSPVDIDTHTAKYDPSLKP...   \n",
       "13  MQYLNIKEDCNAMAFCAKMRSSKKTEVNLEAPEPGVEVIFYLSDRE...   \n",
       "14  MVFLSGNASDSSNCTQPPAPVNISKAILLGVILGGLILFGVLGNIL...   \n",
       "15  MPALARDGGQLPLLVVFSAMIFGTITNQDLPVIKCVLINHKNNDSS...   \n",
       "16  MLEICLKLVGCKSKKGLSSSSSCYLEEALQRPVASDFEPQGLSEAA...   \n",
       "17  MALSYRVSELQSTIPEHILQSTFVHVISSNWSGLQTESIPEEMKQI...   \n",
       "18  MELENYKQPVVLREDNCRRRRRMKPRSAAASLSSMELIPIEFVLPT...   \n",
       "19  MKKSRSVMTVMADDNVKDYFECSLSKSYSSSSNTLGIDLWRGRRCC...   \n",
       "\n",
       "                                     Disease Accession Number  \\\n",
       "0                 Genetic cardiac arrhythmia           Q13936   \n",
       "1                       Rheumatoid arthritis           P23219   \n",
       "2                       Renal cell carcinoma           P35968   \n",
       "3                     Hyper-lipoproteinaemia           P30542   \n",
       "4        Oesophageal/gastroduodenal disorder           P22303   \n",
       "5                             Bladder cancer           P42345   \n",
       "6                 Acute diabete complication           P06213   \n",
       "7                             Encephalopathy           P47989   \n",
       "8                                       Pain           P23975   \n",
       "9   Attention deficit hyperactivity disorder           P08908   \n",
       "10        Allergic/hypersensitivity disorder           P49841   \n",
       "11                               Lung cancer           P54760   \n",
       "12                    Essential hypertension           P00918   \n",
       "13             Cutaneous lupus erythematosus           P23458   \n",
       "14                      Abnormal micturition           P35348   \n",
       "15                               Lung cancer           P36888   \n",
       "16                    Cardiovascular disease           P00519   \n",
       "17                  Irritable bowel syndrome           P41595   \n",
       "18                           Prostate cancer           P48736   \n",
       "19                Postoperative inflammation           Q07343   \n",
       "\n",
       "              Target_Status  \n",
       "0                Terminated  \n",
       "1                  Approved  \n",
       "2                  Approved  \n",
       "3                   Phase 2  \n",
       "4                  Approved  \n",
       "5                 Phase 1/2  \n",
       "6                  Approved  \n",
       "7                   Phase 2  \n",
       "8                  Approved  \n",
       "9                   Phase 3  \n",
       "10                 Patented  \n",
       "11                  Phase 2  \n",
       "12                 Approved  \n",
       "13                  Phase 2  \n",
       "14  Discontinued in Phase 2  \n",
       "15                  Phase 3  \n",
       "16                  Phase 1  \n",
       "17            Investigative  \n",
       "18            Investigative  \n",
       "19            Investigative  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "drug_df.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(134486, 19)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "drug_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>ID</th>\n",
       "      <th>PUBCHCID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>134486.000000</td>\n",
       "      <td>1.344860e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>95958.384107</td>\n",
       "      <td>1.397308e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>55524.645340</td>\n",
       "      <td>2.561885e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>1.190000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>47764.250000</td>\n",
       "      <td>5.484100e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>96015.500000</td>\n",
       "      <td>5.280980e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>144131.750000</td>\n",
       "      <td>1.165886e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>192122.000000</td>\n",
       "      <td>1.357437e+08</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  ID      PUBCHCID\n",
       "count  134486.000000  1.344860e+05\n",
       "mean    95958.384107  1.397308e+07\n",
       "std     55524.645340  2.561885e+07\n",
       "min         2.000000  1.190000e+02\n",
       "25%     47764.250000  5.484100e+04\n",
       "50%     96015.500000  5.280980e+06\n",
       "75%    144131.750000  1.165886e+07\n",
       "max    192122.000000  1.357437e+08"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "drug_df.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "No Null Values are present "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 134486 entries, 0 to 134485\n",
      "Data columns (total 19 columns):\n",
      " #   Column                     Non-Null Count   Dtype \n",
      "---  ------                     --------------   ----- \n",
      " 0   ID                         134486 non-null  int64 \n",
      " 1   TargetID                   134486 non-null  object\n",
      " 2   DRUGID                     134486 non-null  object\n",
      " 3   DRUGTYPE                   134486 non-null  object\n",
      " 4   Drug_high_status           134486 non-null  object\n",
      " 5   DRUGNAME                   134486 non-null  object\n",
      " 6   PUBCHCID                   134486 non-null  int64 \n",
      " 7   Disease_of_highest_status  134486 non-null  object\n",
      " 8   Drug_Status                134486 non-null  object\n",
      " 9   UNIPROID                   134486 non-null  object\n",
      " 10  TARGNAME                   134486 non-null  object\n",
      " 11  GENENAME                   134486 non-null  object\n",
      " 12  SYNONYMS                   134486 non-null  object\n",
      " 13  FUNCTION                   134486 non-null  object\n",
      " 14  BIOCLASS                   134486 non-null  object\n",
      " 15  SEQUENCE                   134486 non-null  object\n",
      " 16  Disease                    134486 non-null  object\n",
      " 17  Accession Number           134486 non-null  object\n",
      " 18  Target_Status              134486 non-null  object\n",
      "dtypes: int64(2), object(17)\n",
      "memory usage: 19.5+ MB\n"
     ]
    }
   ],
   "source": [
    "drug_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['ID', 'TargetID', 'DRUGID', 'DRUGTYPE', 'Drug_high_status', 'DRUGNAME',\n",
       "       'PUBCHCID', 'Disease_of_highest_status', 'Drug_Status', 'UNIPROID',\n",
       "       'TARGNAME', 'GENENAME', 'SYNONYMS', 'FUNCTION', 'BIOCLASS', 'SEQUENCE',\n",
       "       'Disease', 'Accession Number', 'Target_Status'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "drug_df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DRUGTYPE\n",
       "Small molecular drug                       134082\n",
       "Small molecule immunotherapy                  192\n",
       "Combination drug (small molecular drug)       174\n",
       "Combination drug (Antibody)                    24\n",
       "Protein/peptide drug                           12\n",
       "Recombinant protein                             2\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "drug_df['DRUGTYPE'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "unique drug id's are 2443"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DRUGID\n",
       "D0O0LS    1997\n",
       "D0W5HK    1601\n",
       "D0H3HM    1439\n",
       "D0AZ3C    1368\n",
       "D0U3EP    1290\n",
       "          ... \n",
       "D0Z2FD       1\n",
       "D0B2OT       1\n",
       "D09VBE       1\n",
       "D03XYW       1\n",
       "D01AQT       1\n",
       "Name: count, Length: 2443, dtype: int64"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "drug_df['DRUGID'].value_counts()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "TargetID\n",
       "T67162    6538\n",
       "T59328    4037\n",
       "T95913    4007\n",
       "T78709    2853\n",
       "T80975    2842\n",
       "          ... \n",
       "T21678       1\n",
       "T24634       1\n",
       "T43206       1\n",
       "T69506       1\n",
       "T96685       1\n",
       "Name: count, Length: 701, dtype: int64"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "drug_df['TargetID'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}