file_1_chembl_data_retrieval.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyN3Kvf8nzgch/UtSEUcktc3",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/shoaibimt/CancerAI/blob/main/file_1_chembl_data_retrieval.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "! pip install chembl_webresource_client"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "hX5Klrz_JV-o",
        "outputId": "de495c83-e478-4cb1-e146-85dd97efc4d5"
      },
      "execution_count": 1,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Collecting chembl_webresource_client\n",
            "  Downloading chembl_webresource_client-0.10.8-py3-none-any.whl (55 kB)\n",
            "\u001b[?25l     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m0.0/55.2 kB\u001b[0m \u001b[31m?\u001b[0m eta \u001b[36m-:--:--\u001b[0m\r\u001b[2K     \u001b[91m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m\u001b[91m╸\u001b[0m\u001b[90m━━━━━━━━━━\u001b[0m \u001b[32m41.0/55.2 kB\u001b[0m \u001b[31m981.3 kB/s\u001b[0m eta \u001b[36m0:00:01\u001b[0m\r\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m55.2/55.2 kB\u001b[0m \u001b[31m931.0 kB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[?25hRequirement already satisfied: urllib3 in /usr/local/lib/python3.10/dist-packages (from chembl_webresource_client) (2.0.7)\n",
            "Requirement already satisfied: requests>=2.18.4 in /usr/local/lib/python3.10/dist-packages (from chembl_webresource_client) (2.31.0)\n",
            "Collecting requests-cache~=0.7.0 (from chembl_webresource_client)\n",
            "  Downloading requests_cache-0.7.5-py3-none-any.whl (39 kB)\n",
            "Requirement already satisfied: easydict in /usr/local/lib/python3.10/dist-packages (from chembl_webresource_client) (1.11)\n",
            "Requirement already satisfied: charset-normalizer<4,>=2 in /usr/local/lib/python3.10/dist-packages (from requests>=2.18.4->chembl_webresource_client) (3.3.2)\n",
            "Requirement already satisfied: idna<4,>=2.5 in /usr/local/lib/python3.10/dist-packages (from requests>=2.18.4->chembl_webresource_client) (3.6)\n",
            "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.10/dist-packages (from requests>=2.18.4->chembl_webresource_client) (2023.11.17)\n",
            "Collecting attrs<22.0,>=21.2 (from requests-cache~=0.7.0->chembl_webresource_client)\n",
            "  Downloading attrs-21.4.0-py2.py3-none-any.whl (60 kB)\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m60.6/60.6 kB\u001b[0m \u001b[31m5.9 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[?25hRequirement already satisfied: itsdangerous>=2.0.1 in /usr/local/lib/python3.10/dist-packages (from requests-cache~=0.7.0->chembl_webresource_client) (2.1.2)\n",
            "Requirement already satisfied: pyyaml>=5.4 in /usr/local/lib/python3.10/dist-packages (from requests-cache~=0.7.0->chembl_webresource_client) (6.0.1)\n",
            "Collecting url-normalize<2.0,>=1.4 (from requests-cache~=0.7.0->chembl_webresource_client)\n",
            "  Downloading url_normalize-1.4.3-py2.py3-none-any.whl (6.8 kB)\n",
            "Requirement already satisfied: six in /usr/local/lib/python3.10/dist-packages (from url-normalize<2.0,>=1.4->requests-cache~=0.7.0->chembl_webresource_client) (1.16.0)\n",
            "Installing collected packages: url-normalize, attrs, requests-cache, chembl_webresource_client\n",
            "  Attempting uninstall: attrs\n",
            "    Found existing installation: attrs 23.1.0\n",
            "    Uninstalling attrs-23.1.0:\n",
            "      Successfully uninstalled attrs-23.1.0\n",
            "\u001b[31mERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts.\n",
            "lida 0.0.10 requires fastapi, which is not installed.\n",
            "lida 0.0.10 requires kaleido, which is not installed.\n",
            "lida 0.0.10 requires python-multipart, which is not installed.\n",
            "lida 0.0.10 requires uvicorn, which is not installed.\n",
            "jsonschema 4.19.2 requires attrs>=22.2.0, but you have attrs 21.4.0 which is incompatible.\n",
            "referencing 0.32.0 requires attrs>=22.2.0, but you have attrs 21.4.0 which is incompatible.\u001b[0m\u001b[31m\n",
            "\u001b[0mSuccessfully installed attrs-21.4.0 chembl_webresource_client-0.10.8 requests-cache-0.7.5 url-normalize-1.4.3\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n",
        "import math\n",
        "from pathlib import Path\n",
        "from zipfile import ZipFile\n",
        "from tempfile import TemporaryDirectory\n",
        "from chembl_webresource_client.new_client import new_client\n",
        "from tqdm.auto import tqdm"
      ],
      "metadata": {
        "id": "ixWJ5ZUiJaWX"
      },
      "execution_count": 2,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# run this code if you want to keep and then retrieve your files from Google drive\n",
        "from google.colab import drive\n",
        "drive.mount('/content/drive', force_remount=True)"
      ],
      "metadata": {
        "id": "7Vqg4q6AJek_",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "6f2ed40e-ce36-4cbb-c4fb-2e58d23453f2"
      },
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Mounted at /content/drive\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "target = new_client.target\n",
        "target_query_bcrabl = target.search('BCR-ABL')\n",
        "bcrabl_data = pd.DataFrame.from_dict(target_query_bcrabl)\n",
        "bcrabl_data"
      ],
      "metadata": {
        "id": "tk5KDl58Jhn2",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "9cbca184-5ebe-4123-fcf8-b8e2d9faa098"
      },
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                     cross_references  \\\n",
              "0   [{'xref_id': 'A1Z199', 'xref_name': None, 'xre...   \n",
              "1   [{'xref_id': 'P11274', 'xref_name': None, 'xre...   \n",
              "2                                                  []   \n",
              "3                                                  []   \n",
              "4                                                  []   \n",
              "5                                                  []   \n",
              "6                                                  []   \n",
              "7                                                  []   \n",
              "8   [{'xref_id': 'P00521', 'xref_name': None, 'xre...   \n",
              "9   [{'xref_id': 'P00519', 'xref_name': None, 'xre...   \n",
              "10  [{'xref_id': 'P00520', 'xref_name': None, 'xre...   \n",
              "11                                                 []   \n",
              "12                                                 []   \n",
              "13                                                 []   \n",
              "14                                                 []   \n",
              "15                                                 []   \n",
              "16                                                 []   \n",
              "17  [{'xref_id': 'P42684', 'xref_name': None, 'xre...   \n",
              "18  [{'xref_id': 'Q4JIM5', 'xref_name': None, 'xre...   \n",
              "19                                                 []   \n",
              "20  [{'xref_id': 'P06795', 'xref_name': None, 'xre...   \n",
              "21  [{'xref_id': 'P08183', 'xref_name': None, 'xre...   \n",
              "22  [{'xref_id': 'P21447', 'xref_name': None, 'xre...   \n",
              "23  [{'xref_id': 'Q5ABU7', 'xref_name': None, 'xre...   \n",
              "24  [{'xref_id': 'O95342', 'xref_name': None, 'xre...   \n",
              "25  [{'xref_id': 'P43245', 'xref_name': None, 'xre...   \n",
              "26                                                 []   \n",
              "27                                                 []   \n",
              "28  [{'xref_id': 'P43071', 'xref_name': None, 'xre...   \n",
              "29  [{'xref_id': 'ABCB9', 'xref_name': None, 'xref...   \n",
              "30                                                 []   \n",
              "31  [{'xref_id': 'ABCB4', 'xref_name': None, 'xref...   \n",
              "32  [{'xref_id': 'ABCB5', 'xref_name': None, 'xref...   \n",
              "33                                                 []   \n",
              "34                                                 []   \n",
              "35                                                 []   \n",
              "36                                                 []   \n",
              "37                                                 []   \n",
              "38                                                 []   \n",
              "\n",
              "                                             organism  \\\n",
              "0                                        Homo sapiens   \n",
              "1                                        Homo sapiens   \n",
              "2                                        Homo sapiens   \n",
              "3                                        Homo sapiens   \n",
              "4                                        Homo sapiens   \n",
              "5                                        Homo sapiens   \n",
              "6                                        Mus musculus   \n",
              "7                                        Homo sapiens   \n",
              "8                       Abelson murine leukemia virus   \n",
              "9                                        Homo sapiens   \n",
              "10                                       Mus musculus   \n",
              "11                                       Homo sapiens   \n",
              "12                                       Homo sapiens   \n",
              "13                                       Homo sapiens   \n",
              "14                                       Homo sapiens   \n",
              "15                                       Homo sapiens   \n",
              "16                                       Homo sapiens   \n",
              "17                                       Homo sapiens   \n",
              "18                                       Mus musculus   \n",
              "19                                       Homo sapiens   \n",
              "20                                       Mus musculus   \n",
              "21                                       Homo sapiens   \n",
              "22                                       Mus musculus   \n",
              "23  Candida albicans (strain SC5314 / ATCC MYA-287...   \n",
              "24                                       Homo sapiens   \n",
              "25                                  Rattus norvegicus   \n",
              "26                                  Rattus norvegicus   \n",
              "27  Candida albicans (strain SC5314 / ATCC MYA-287...   \n",
              "28                                   Candida albicans   \n",
              "29                                       Homo sapiens   \n",
              "30                      Escherichia coli (strain K12)   \n",
              "31                                       Homo sapiens   \n",
              "32                                       Homo sapiens   \n",
              "33                                       Homo sapiens   \n",
              "34                                  Rattus norvegicus   \n",
              "35                                       Mus musculus   \n",
              "36                                       Mus musculus   \n",
              "37                              Plasmodium falciparum   \n",
              "38                                       Homo sapiens   \n",
              "\n",
              "                                            pref_name  score  \\\n",
              "0                         BCR/ABL p210 fusion protein   37.0   \n",
              "1                   Breakpoint cluster region protein   26.0   \n",
              "2                              Bcr/Abl fusion protein   26.0   \n",
              "3   Baculoviral IAP repeat-containing protein 2/BC...   26.0   \n",
              "4            E3 ubiquitin-protein ligase XIAP/BCR/ABL   26.0   \n",
              "5                                    Cereblon/BCR/ABL   26.0   \n",
              "6                                            BCR/ABL1   26.0   \n",
              "7                                        VHL/BCR-ABL1   26.0   \n",
              "8                       Tyrosine-protein kinase V-ABL   19.0   \n",
              "9                         Tyrosine-protein kinase ABL   14.0   \n",
              "10                        Tyrosine-protein kinase ABL   14.0   \n",
              "11      Protein cereblon/Tyrosine-protein kinase ABL1   14.0   \n",
              "12                                           VHL/ABL1   13.0   \n",
              "13  Ras and Rab interactor 1/Tyrosine-protein kina...   12.0   \n",
              "14  Transcription factor ETV6/Tyrosine-protein kin...   12.0   \n",
              "15                        Tyrosine-protein kinase ABL   11.0   \n",
              "16              B-cell receptor-associated protein 31   11.0   \n",
              "17                       Tyrosine-protein kinase ABL2    9.0   \n",
              "18                       Tyrosine-protein kinase ABL2    9.0   \n",
              "19                   VHL/Tyrosine-protein kinase ABL2    9.0   \n",
              "20                                   P-glycoprotein 1    2.0   \n",
              "21                                   P-glycoprotein 1    2.0   \n",
              "22                                   P-glycoprotein 3    2.0   \n",
              "23                   Cycloheximide resistance protein    2.0   \n",
              "24                              Bile salt export pump    2.0   \n",
              "25                     Multidrug resistance protein 1    2.0   \n",
              "26                    Multidrug resistance protein 1a    2.0   \n",
              "27                  Multidrug resistance protein CDR2    2.0   \n",
              "28                  Multidrug resistance protein CDR1    2.0   \n",
              "29         ATP-binding cassette sub-family B member 9    2.0   \n",
              "30                  Multidrug resistance protein mdtK    2.0   \n",
              "31                     Multidrug resistance protein 3    2.0   \n",
              "32         ATP-binding cassette sub-family B member 5    2.0   \n",
              "33  ATP-binding cassette sub-family B member 6, mi...    2.0   \n",
              "34                              Bile salt export pump    2.0   \n",
              "35                              Bile salt export pump    2.0   \n",
              "36               P-glycoprotein 1 and 3 (MDR1a/MDR1b)    2.0   \n",
              "37                  Multidrug resistance protein Pgh1    2.0   \n",
              "38  Multidrug resistance protein 1/Multidrug resis...    1.0   \n",
              "\n",
              "    species_group_flag target_chembl_id  \\\n",
              "0                False       CHEMBL6105   \n",
              "1                False       CHEMBL5146   \n",
              "2                False    CHEMBL2096618   \n",
              "3                False    CHEMBL4296119   \n",
              "4                False    CHEMBL4296120   \n",
              "5                False    CHEMBL4296137   \n",
              "6                False    CHEMBL4523652   \n",
              "7                False    CHEMBL4523751   \n",
              "8                False       CHEMBL5166   \n",
              "9                False       CHEMBL1862   \n",
              "10               False       CHEMBL3099   \n",
              "11               False    CHEMBL4523750   \n",
              "12               False    CHEMBL4523725   \n",
              "13               False    CHEMBL3885630   \n",
              "14               False    CHEMBL3885645   \n",
              "15               False    CHEMBL2111414   \n",
              "16               False    CHEMBL4295778   \n",
              "17               False       CHEMBL4014   \n",
              "18               False       CHEMBL5222   \n",
              "19               False    CHEMBL4523736   \n",
              "20               False       CHEMBL3467   \n",
              "21               False       CHEMBL4302   \n",
              "22               False       CHEMBL2573   \n",
              "23               False       CHEMBL5336   \n",
              "24               False       CHEMBL6020   \n",
              "25               False    CHEMBL1075229   \n",
              "26               False    CHEMBL1075135   \n",
              "27               False    CHEMBL1163105   \n",
              "28               False    CHEMBL1163109   \n",
              "29               False    CHEMBL1293189   \n",
              "30               False    CHEMBL1681613   \n",
              "31               False    CHEMBL1743129   \n",
              "32               False    CHEMBL1772928   \n",
              "33               False    CHEMBL2007630   \n",
              "34               False    CHEMBL2073674   \n",
              "35               False    CHEMBL2073695   \n",
              "36               False    CHEMBL2111404   \n",
              "37               False    CHEMBL3308931   \n",
              "38               False    CHEMBL3430875   \n",
              "\n",
              "                                    target_components  \\\n",
              "0   [{'accession': 'A1Z199', 'component_descriptio...   \n",
              "1   [{'accession': 'P11274', 'component_descriptio...   \n",
              "2   [{'accession': 'P00519', 'component_descriptio...   \n",
              "3   [{'accession': 'P00519', 'component_descriptio...   \n",
              "4   [{'accession': 'P00519', 'component_descriptio...   \n",
              "5   [{'accession': 'P00519', 'component_descriptio...   \n",
              "6   [{'accession': 'P00520', 'component_descriptio...   \n",
              "7   [{'accession': 'P00519', 'component_descriptio...   \n",
              "8   [{'accession': 'P00521', 'component_descriptio...   \n",
              "9   [{'accession': 'P00519', 'component_descriptio...   \n",
              "10  [{'accession': 'P00520', 'component_descriptio...   \n",
              "11  [{'accession': 'P00519', 'component_descriptio...   \n",
              "12  [{'accession': 'P00519', 'component_descriptio...   \n",
              "13  [{'accession': 'P00519', 'component_descriptio...   \n",
              "14  [{'accession': 'P00519', 'component_descriptio...   \n",
              "15  [{'accession': 'P00519', 'component_descriptio...   \n",
              "16  [{'accession': 'P51572', 'component_descriptio...   \n",
              "17  [{'accession': 'P42684', 'component_descriptio...   \n",
              "18  [{'accession': 'Q4JIM5', 'component_descriptio...   \n",
              "19  [{'accession': 'P42684', 'component_descriptio...   \n",
              "20  [{'accession': 'P06795', 'component_descriptio...   \n",
              "21  [{'accession': 'P08183', 'component_descriptio...   \n",
              "22  [{'accession': 'P21447', 'component_descriptio...   \n",
              "23  [{'accession': 'Q5ABU7', 'component_descriptio...   \n",
              "24  [{'accession': 'O95342', 'component_descriptio...   \n",
              "25  [{'accession': 'P43245', 'component_descriptio...   \n",
              "26  [{'accession': 'Q6PSM0', 'component_descriptio...   \n",
              "27  [{'accession': 'P78595', 'component_descriptio...   \n",
              "28  [{'accession': 'P43071', 'component_descriptio...   \n",
              "29  [{'accession': 'Q9NP78', 'component_descriptio...   \n",
              "30  [{'accession': 'P37340', 'component_descriptio...   \n",
              "31  [{'accession': 'P21439', 'component_descriptio...   \n",
              "32  [{'accession': 'Q2M3G0', 'component_descriptio...   \n",
              "33  [{'accession': 'Q9NP58', 'component_descriptio...   \n",
              "34  [{'accession': 'O70127', 'component_descriptio...   \n",
              "35  [{'accession': 'Q9QY30', 'component_descriptio...   \n",
              "36  [{'accession': 'P21447', 'component_descriptio...   \n",
              "37  [{'accession': 'Q9NG76', 'component_descriptio...   \n",
              "38  [{'accession': 'P33527', 'component_descriptio...   \n",
              "\n",
              "                    target_type  tax_id  \n",
              "0                SINGLE PROTEIN    9606  \n",
              "1                SINGLE PROTEIN    9606  \n",
              "2              CHIMERIC PROTEIN    9606  \n",
              "3   PROTEIN-PROTEIN INTERACTION    9606  \n",
              "4   PROTEIN-PROTEIN INTERACTION    9606  \n",
              "5   PROTEIN-PROTEIN INTERACTION    9606  \n",
              "6              CHIMERIC PROTEIN   10090  \n",
              "7   PROTEIN-PROTEIN INTERACTION    9606  \n",
              "8                SINGLE PROTEIN   11788  \n",
              "9                SINGLE PROTEIN    9606  \n",
              "10               SINGLE PROTEIN   10090  \n",
              "11  PROTEIN-PROTEIN INTERACTION    9606  \n",
              "12  PROTEIN-PROTEIN INTERACTION    9606  \n",
              "13  PROTEIN-PROTEIN INTERACTION    9606  \n",
              "14             CHIMERIC PROTEIN    9606  \n",
              "15               PROTEIN FAMILY    9606  \n",
              "16               SINGLE PROTEIN    9606  \n",
              "17               SINGLE PROTEIN    9606  \n",
              "18               SINGLE PROTEIN   10090  \n",
              "19  PROTEIN-PROTEIN INTERACTION    9606  \n",
              "20               SINGLE PROTEIN   10090  \n",
              "21               SINGLE PROTEIN    9606  \n",
              "22               SINGLE PROTEIN   10090  \n",
              "23               SINGLE PROTEIN  237561  \n",
              "24               SINGLE PROTEIN    9606  \n",
              "25               SINGLE PROTEIN   10116  \n",
              "26               SINGLE PROTEIN   10116  \n",
              "27               SINGLE PROTEIN  237561  \n",
              "28               SINGLE PROTEIN    5476  \n",
              "29               SINGLE PROTEIN    9606  \n",
              "30               SINGLE PROTEIN   83333  \n",
              "31               SINGLE PROTEIN    9606  \n",
              "32               SINGLE PROTEIN    9606  \n",
              "33               SINGLE PROTEIN    9606  \n",
              "34               SINGLE PROTEIN   10116  \n",
              "35               SINGLE PROTEIN   10090  \n",
              "36               PROTEIN FAMILY   10090  \n",
              "37               SINGLE PROTEIN    5833  \n",
              "38            SELECTIVITY GROUP    9606  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-ccc9f7ee-38e9-45ef-9762-c40090dc712e\" class=\"colab-df-container\">\n",
              "    <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>cross_references</th>\n",
              "      <th>organism</th>\n",
              "      <th>pref_name</th>\n",
              "      <th>score</th>\n",
              "      <th>species_group_flag</th>\n",
              "      <th>target_chembl_id</th>\n",
              "      <th>target_components</th>\n",
              "      <th>target_type</th>\n",
              "      <th>tax_id</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>[{'xref_id': 'A1Z199', 'xref_name': None, 'xre...</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>BCR/ABL p210 fusion protein</td>\n",
              "      <td>37.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL6105</td>\n",
              "      <td>[{'accession': 'A1Z199', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>[{'xref_id': 'P11274', 'xref_name': None, 'xre...</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Breakpoint cluster region protein</td>\n",
              "      <td>26.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL5146</td>\n",
              "      <td>[{'accession': 'P11274', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>[]</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bcr/Abl fusion protein</td>\n",
              "      <td>26.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL2096618</td>\n",
              "      <td>[{'accession': 'P00519', 'component_descriptio...</td>\n",
              "      <td>CHIMERIC PROTEIN</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>[]</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Baculoviral IAP repeat-containing protein 2/BC...</td>\n",
              "      <td>26.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL4296119</td>\n",
              "      <td>[{'accession': 'P00519', 'component_descriptio...</td>\n",
              "      <td>PROTEIN-PROTEIN INTERACTION</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>[]</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>E3 ubiquitin-protein ligase XIAP/BCR/ABL</td>\n",
              "      <td>26.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL4296120</td>\n",
              "      <td>[{'accession': 'P00519', 'component_descriptio...</td>\n",
              "      <td>PROTEIN-PROTEIN INTERACTION</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>[]</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Cereblon/BCR/ABL</td>\n",
              "      <td>26.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL4296137</td>\n",
              "      <td>[{'accession': 'P00519', 'component_descriptio...</td>\n",
              "      <td>PROTEIN-PROTEIN INTERACTION</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>[]</td>\n",
              "      <td>Mus musculus</td>\n",
              "      <td>BCR/ABL1</td>\n",
              "      <td>26.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL4523652</td>\n",
              "      <td>[{'accession': 'P00520', 'component_descriptio...</td>\n",
              "      <td>CHIMERIC PROTEIN</td>\n",
              "      <td>10090</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>[]</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>VHL/BCR-ABL1</td>\n",
              "      <td>26.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL4523751</td>\n",
              "      <td>[{'accession': 'P00519', 'component_descriptio...</td>\n",
              "      <td>PROTEIN-PROTEIN INTERACTION</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>[{'xref_id': 'P00521', 'xref_name': None, 'xre...</td>\n",
              "      <td>Abelson murine leukemia virus</td>\n",
              "      <td>Tyrosine-protein kinase V-ABL</td>\n",
              "      <td>19.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL5166</td>\n",
              "      <td>[{'accession': 'P00521', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>11788</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>[{'xref_id': 'P00519', 'xref_name': None, 'xre...</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Tyrosine-protein kinase ABL</td>\n",
              "      <td>14.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL1862</td>\n",
              "      <td>[{'accession': 'P00519', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>[{'xref_id': 'P00520', 'xref_name': None, 'xre...</td>\n",
              "      <td>Mus musculus</td>\n",
              "      <td>Tyrosine-protein kinase ABL</td>\n",
              "      <td>14.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL3099</td>\n",
              "      <td>[{'accession': 'P00520', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>10090</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>[]</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Protein cereblon/Tyrosine-protein kinase ABL1</td>\n",
              "      <td>14.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL4523750</td>\n",
              "      <td>[{'accession': 'P00519', 'component_descriptio...</td>\n",
              "      <td>PROTEIN-PROTEIN INTERACTION</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>[]</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>VHL/ABL1</td>\n",
              "      <td>13.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL4523725</td>\n",
              "      <td>[{'accession': 'P00519', 'component_descriptio...</td>\n",
              "      <td>PROTEIN-PROTEIN INTERACTION</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>[]</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Ras and Rab interactor 1/Tyrosine-protein kina...</td>\n",
              "      <td>12.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL3885630</td>\n",
              "      <td>[{'accession': 'P00519', 'component_descriptio...</td>\n",
              "      <td>PROTEIN-PROTEIN INTERACTION</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>[]</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Transcription factor ETV6/Tyrosine-protein kin...</td>\n",
              "      <td>12.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL3885645</td>\n",
              "      <td>[{'accession': 'P00519', 'component_descriptio...</td>\n",
              "      <td>CHIMERIC PROTEIN</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>[]</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Tyrosine-protein kinase ABL</td>\n",
              "      <td>11.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL2111414</td>\n",
              "      <td>[{'accession': 'P00519', 'component_descriptio...</td>\n",
              "      <td>PROTEIN FAMILY</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>[]</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>B-cell receptor-associated protein 31</td>\n",
              "      <td>11.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL4295778</td>\n",
              "      <td>[{'accession': 'P51572', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>[{'xref_id': 'P42684', 'xref_name': None, 'xre...</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Tyrosine-protein kinase ABL2</td>\n",
              "      <td>9.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL4014</td>\n",
              "      <td>[{'accession': 'P42684', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>[{'xref_id': 'Q4JIM5', 'xref_name': None, 'xre...</td>\n",
              "      <td>Mus musculus</td>\n",
              "      <td>Tyrosine-protein kinase ABL2</td>\n",
              "      <td>9.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL5222</td>\n",
              "      <td>[{'accession': 'Q4JIM5', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>10090</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>[]</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>VHL/Tyrosine-protein kinase ABL2</td>\n",
              "      <td>9.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL4523736</td>\n",
              "      <td>[{'accession': 'P42684', 'component_descriptio...</td>\n",
              "      <td>PROTEIN-PROTEIN INTERACTION</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>[{'xref_id': 'P06795', 'xref_name': None, 'xre...</td>\n",
              "      <td>Mus musculus</td>\n",
              "      <td>P-glycoprotein 1</td>\n",
              "      <td>2.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL3467</td>\n",
              "      <td>[{'accession': 'P06795', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>10090</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>[{'xref_id': 'P08183', 'xref_name': None, 'xre...</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>P-glycoprotein 1</td>\n",
              "      <td>2.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL4302</td>\n",
              "      <td>[{'accession': 'P08183', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>[{'xref_id': 'P21447', 'xref_name': None, 'xre...</td>\n",
              "      <td>Mus musculus</td>\n",
              "      <td>P-glycoprotein 3</td>\n",
              "      <td>2.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL2573</td>\n",
              "      <td>[{'accession': 'P21447', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>10090</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>[{'xref_id': 'Q5ABU7', 'xref_name': None, 'xre...</td>\n",
              "      <td>Candida albicans (strain SC5314 / ATCC MYA-287...</td>\n",
              "      <td>Cycloheximide resistance protein</td>\n",
              "      <td>2.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL5336</td>\n",
              "      <td>[{'accession': 'Q5ABU7', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>237561</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>[{'xref_id': 'O95342', 'xref_name': None, 'xre...</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bile salt export pump</td>\n",
              "      <td>2.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL6020</td>\n",
              "      <td>[{'accession': 'O95342', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>[{'xref_id': 'P43245', 'xref_name': None, 'xre...</td>\n",
              "      <td>Rattus norvegicus</td>\n",
              "      <td>Multidrug resistance protein 1</td>\n",
              "      <td>2.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL1075229</td>\n",
              "      <td>[{'accession': 'P43245', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>10116</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>[]</td>\n",
              "      <td>Rattus norvegicus</td>\n",
              "      <td>Multidrug resistance protein 1a</td>\n",
              "      <td>2.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL1075135</td>\n",
              "      <td>[{'accession': 'Q6PSM0', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>10116</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>[]</td>\n",
              "      <td>Candida albicans (strain SC5314 / ATCC MYA-287...</td>\n",
              "      <td>Multidrug resistance protein CDR2</td>\n",
              "      <td>2.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL1163105</td>\n",
              "      <td>[{'accession': 'P78595', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>237561</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>[{'xref_id': 'P43071', 'xref_name': None, 'xre...</td>\n",
              "      <td>Candida albicans</td>\n",
              "      <td>Multidrug resistance protein CDR1</td>\n",
              "      <td>2.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL1163109</td>\n",
              "      <td>[{'accession': 'P43071', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>5476</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>[{'xref_id': 'ABCB9', 'xref_name': None, 'xref...</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>ATP-binding cassette sub-family B member 9</td>\n",
              "      <td>2.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL1293189</td>\n",
              "      <td>[{'accession': 'Q9NP78', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>[]</td>\n",
              "      <td>Escherichia coli (strain K12)</td>\n",
              "      <td>Multidrug resistance protein mdtK</td>\n",
              "      <td>2.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL1681613</td>\n",
              "      <td>[{'accession': 'P37340', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>83333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>[{'xref_id': 'ABCB4', 'xref_name': None, 'xref...</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Multidrug resistance protein 3</td>\n",
              "      <td>2.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL1743129</td>\n",
              "      <td>[{'accession': 'P21439', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>[{'xref_id': 'ABCB5', 'xref_name': None, 'xref...</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>ATP-binding cassette sub-family B member 5</td>\n",
              "      <td>2.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL1772928</td>\n",
              "      <td>[{'accession': 'Q2M3G0', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>[]</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>ATP-binding cassette sub-family B member 6, mi...</td>\n",
              "      <td>2.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL2007630</td>\n",
              "      <td>[{'accession': 'Q9NP58', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>[]</td>\n",
              "      <td>Rattus norvegicus</td>\n",
              "      <td>Bile salt export pump</td>\n",
              "      <td>2.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL2073674</td>\n",
              "      <td>[{'accession': 'O70127', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>10116</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>[]</td>\n",
              "      <td>Mus musculus</td>\n",
              "      <td>Bile salt export pump</td>\n",
              "      <td>2.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL2073695</td>\n",
              "      <td>[{'accession': 'Q9QY30', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>10090</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>[]</td>\n",
              "      <td>Mus musculus</td>\n",
              "      <td>P-glycoprotein 1 and 3 (MDR1a/MDR1b)</td>\n",
              "      <td>2.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL2111404</td>\n",
              "      <td>[{'accession': 'P21447', 'component_descriptio...</td>\n",
              "      <td>PROTEIN FAMILY</td>\n",
              "      <td>10090</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>[]</td>\n",
              "      <td>Plasmodium falciparum</td>\n",
              "      <td>Multidrug resistance protein Pgh1</td>\n",
              "      <td>2.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL3308931</td>\n",
              "      <td>[{'accession': 'Q9NG76', 'component_descriptio...</td>\n",
              "      <td>SINGLE PROTEIN</td>\n",
              "      <td>5833</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>[]</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Multidrug resistance protein 1/Multidrug resis...</td>\n",
              "      <td>1.0</td>\n",
              "      <td>False</td>\n",
              "      <td>CHEMBL3430875</td>\n",
              "      <td>[{'accession': 'P33527', 'component_descriptio...</td>\n",
              "      <td>SELECTIVITY GROUP</td>\n",
              "      <td>9606</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-ccc9f7ee-38e9-45ef-9762-c40090dc712e')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-ccc9f7ee-38e9-45ef-9762-c40090dc712e button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-ccc9f7ee-38e9-45ef-9762-c40090dc712e');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-32abaca2-6acf-473c-9ed3-426ff7774342\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-32abaca2-6acf-473c-9ed3-426ff7774342')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-32abaca2-6acf-473c-9ed3-426ff7774342 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "  <div id=\"id_8d9ddcc7-c690-4c15-84f9-43b70e195207\">\n",
              "    <style>\n",
              "      .colab-df-generate {\n",
              "        background-color: #E8F0FE;\n",
              "        border: none;\n",
              "        border-radius: 50%;\n",
              "        cursor: pointer;\n",
              "        display: none;\n",
              "        fill: #1967D2;\n",
              "        height: 32px;\n",
              "        padding: 0 0 0 0;\n",
              "        width: 32px;\n",
              "      }\n",
              "\n",
              "      .colab-df-generate:hover {\n",
              "        background-color: #E2EBFA;\n",
              "        box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "        fill: #174EA6;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate {\n",
              "        background-color: #3B4455;\n",
              "        fill: #D2E3FC;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate:hover {\n",
              "        background-color: #434B5C;\n",
              "        box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "        filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "        fill: #FFFFFF;\n",
              "      }\n",
              "    </style>\n",
              "    <button class=\"colab-df-generate\" onclick=\"generateWithVariable('bcrabl_data')\"\n",
              "            title=\"Generate code using this dataframe.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M7,19H8.4L18.45,9,17,7.55,7,17.6ZM5,21V16.75L18.45,3.32a2,2,0,0,1,2.83,0l1.4,1.43a1.91,1.91,0,0,1,.58,1.4,1.91,1.91,0,0,1-.58,1.4L9.25,21ZM18.45,9,17,7.55Zm-12,3A5.31,5.31,0,0,0,4.9,8.1,5.31,5.31,0,0,0,1,6.5,5.31,5.31,0,0,0,4.9,4.9,5.31,5.31,0,0,0,6.5,1,5.31,5.31,0,0,0,8.1,4.9,5.31,5.31,0,0,0,12,6.5,5.46,5.46,0,0,0,6.5,12Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "    <script>\n",
              "      (() => {\n",
              "      const buttonEl =\n",
              "        document.querySelector('#id_8d9ddcc7-c690-4c15-84f9-43b70e195207 button.colab-df-generate');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      buttonEl.onclick = () => {\n",
              "        google.colab.notebook.generateWithVariable('bcrabl_data');\n",
              "      }\n",
              "      })();\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#CHEMBL2096618\n",
        "selected_target = bcrabl_data.target_chembl_id[2]\n",
        "selected_target"
      ],
      "metadata": {
        "id": "GMrfhcymJkeg",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        },
        "outputId": "f11b0a1c-aa66-4ac0-e08b-7f663240aca1"
      },
      "execution_count": 12,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "'CHEMBL2096618'"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            }
          },
          "metadata": {},
          "execution_count": 12
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "activity = new_client.activity\n",
        "res = activity.filter(target_chembl_id=selected_target).filter(standard_type=\"IC50\")"
      ],
      "metadata": {
        "id": "pkTMY_r-JnbA"
      },
      "execution_count": 13,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df = pd.DataFrame.from_dict(res)"
      ],
      "metadata": {
        "id": "LSU-jSemJp_Y"
      },
      "execution_count": 14,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# 844 rows and 46 columns\n",
        "df.shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "fJ4dkGluhQs_",
        "outputId": "d43b484b-da8c-48a3-8934-bbf72d0ec3ff"
      },
      "execution_count": 15,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(844, 46)"
            ]
          },
          "metadata": {},
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "pd.set_option('display.max_columns', 46)"
      ],
      "metadata": {
        "id": "RMs25YgnKI3o"
      },
      "execution_count": 16,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df"
      ],
      "metadata": {
        "id": "ZF-1hVtwKMAH",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 877
        },
        "outputId": "bc0ea275-31f7-4ad9-cfe0-9937596304fa"
      },
      "execution_count": 17,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                           action_type activity_comment  \\\n",
              "0                                                 None             None   \n",
              "1                                                 None   Not Determined   \n",
              "2                                                 None             None   \n",
              "3                                                 None             None   \n",
              "4                                                 None             None   \n",
              "..                                                 ...              ...   \n",
              "839  {'action_type': 'INHIBITOR', 'description': 'N...             None   \n",
              "840  {'action_type': 'INHIBITOR', 'description': 'N...             None   \n",
              "841  {'action_type': 'INHIBITOR', 'description': 'N...             None   \n",
              "842  {'action_type': 'INHIBITOR', 'description': 'N...             None   \n",
              "843  {'action_type': 'INHIBITOR', 'description': 'N...             None   \n",
              "\n",
              "     activity_id activity_properties assay_chembl_id  \\\n",
              "0        1675266                  []    CHEMBL867071   \n",
              "1        1675350                  []    CHEMBL867071   \n",
              "2        1675351                  []    CHEMBL867071   \n",
              "3        1675352                  []    CHEMBL867071   \n",
              "4        1675353                  []    CHEMBL867071   \n",
              "..           ...                 ...             ...   \n",
              "839     24863069                  []   CHEMBL5150925   \n",
              "840     24867166                  []   CHEMBL5151951   \n",
              "841     24958852                  []   CHEMBL5215101   \n",
              "842     24958853                  []   CHEMBL5215101   \n",
              "843     24958854                  []   CHEMBL5215101   \n",
              "\n",
              "                                     assay_description assay_type  \\\n",
              "0    Antiproliferative activity against human BCR-A...          F   \n",
              "1    Antiproliferative activity against human BCR-A...          F   \n",
              "2    Antiproliferative activity against human BCR-A...          F   \n",
              "3    Antiproliferative activity against human BCR-A...          F   \n",
              "4    Antiproliferative activity against human BCR-A...          F   \n",
              "..                                                 ...        ...   \n",
              "839  Inhibition of BCR-ABL (unknown origin) using p...          B   \n",
              "840  Inhibition of BCR-ABL (unknown origin) by kina...          B   \n",
              "841             Inhibition of Bcr-Abl (unknown origin)          B   \n",
              "842             Inhibition of Bcr-Abl (unknown origin)          B   \n",
              "843             Inhibition of Bcr-Abl (unknown origin)          B   \n",
              "\n",
              "    assay_variant_accession assay_variant_mutation bao_endpoint   bao_format  \\\n",
              "0                      None                   None  BAO_0000190  BAO_0000219   \n",
              "1                      None                   None  BAO_0000190  BAO_0000219   \n",
              "2                      None                   None  BAO_0000190  BAO_0000219   \n",
              "3                      None                   None  BAO_0000190  BAO_0000219   \n",
              "4                      None                   None  BAO_0000190  BAO_0000219   \n",
              "..                      ...                    ...          ...          ...   \n",
              "839                    None                   None  BAO_0000190  BAO_0000224   \n",
              "840                    None                   None  BAO_0000190  BAO_0000224   \n",
              "841                    None                   None  BAO_0000190  BAO_0000224   \n",
              "842                    None                   None  BAO_0000190  BAO_0000224   \n",
              "843                    None                   None  BAO_0000190  BAO_0000224   \n",
              "\n",
              "             bao_label                                   canonical_smiles  \\\n",
              "0    cell-based format  CN1CCN(CCc2ccc(NC(=O)c3cc(-c4ccc5c(c4)OCO5)cnc...   \n",
              "1    cell-based format  COc1ccc(-c2cnc(O)c(C(=O)Nc3ccc(CN4CCN(C)CC4)cc...   \n",
              "2    cell-based format  CN1CCN(CCCc2ccc(NC(=O)c3cc(-c4ccc5c(c4)OCO5)cn...   \n",
              "3    cell-based format  CN1CCN(Cc2ccc(NC(=O)c3cc(-c4ccc5c(c4)OCO5)cnc3...   \n",
              "4    cell-based format  CN1CCN(c2ccc(NC(=O)c3cc(-c4ccc5c(c4)OCO5)cnc3O...   \n",
              "..                 ...                                                ...   \n",
              "839     protein format  CN1CCN(c2ccc(Nc3nc(Nc4ccc(F)c(F)c4)c4ncn(CC5CC...   \n",
              "840     protein format  Cc1ccc(C(=O)Nc2ccc(CN3CCN(C)CC3)c(C(F)(F)F)c2)...   \n",
              "841     protein format  CCN1CCN(c2cc(Nc3ncc(C(=O)Nc4ccccc4N)s3)nc(C)n2...   \n",
              "842     protein format  CCN1CCN(c2cc(Nc3ncc(C(=O)Nc4ccc(F)cc4N)s3)nc(C...   \n",
              "843     protein format  Cc1nc(Nc2ncc(C(=O)Nc3c(C)cccc3Cl)s2)cc(N2CCN(C...   \n",
              "\n",
              "    data_validity_comment data_validity_description document_chembl_id  \\\n",
              "0                    None                      None      CHEMBL1149386   \n",
              "1                    None                      None      CHEMBL1149386   \n",
              "2                    None                      None      CHEMBL1149386   \n",
              "3                    None                      None      CHEMBL1149386   \n",
              "4                    None                      None      CHEMBL1149386   \n",
              "..                    ...                       ...                ...   \n",
              "839                  None                      None      CHEMBL5149979   \n",
              "840                  None                      None      CHEMBL5150004   \n",
              "841                  None                      None      CHEMBL5214883   \n",
              "842                  None                      None      CHEMBL5214883   \n",
              "843                  None                      None      CHEMBL5214883   \n",
              "\n",
              "    document_journal  document_year  \\\n",
              "0         J Med Chem           2006   \n",
              "1         J Med Chem           2006   \n",
              "2         J Med Chem           2006   \n",
              "3         J Med Chem           2006   \n",
              "4         J Med Chem           2006   \n",
              "..               ...            ...   \n",
              "839   Eur J Med Chem           2021   \n",
              "840       J Med Chem           2021   \n",
              "841   Eur J Med Chem           2021   \n",
              "842   Eur J Med Chem           2021   \n",
              "843   Eur J Med Chem           2021   \n",
              "\n",
              "                                     ligand_efficiency molecule_chembl_id  \\\n",
              "0                                                 None       CHEMBL199723   \n",
              "1                                                 None       CHEMBL203354   \n",
              "2                                                 None       CHEMBL381738   \n",
              "3                                                 None       CHEMBL370800   \n",
              "4                                                 None       CHEMBL436509   \n",
              "..                                                 ...                ...   \n",
              "839  {'bei': '12.26', 'le': '0.23', 'lle': '1.35', ...      CHEMBL5174919   \n",
              "840  {'bei': '17.46', 'le': '0.33', 'lle': '4.84', ...      CHEMBL1171837   \n",
              "841  {'bei': '10.66', 'le': '0.21', 'lle': '1.71', ...      CHEMBL5219197   \n",
              "842  {'bei': '10.40', 'le': '0.20', 'lle': '1.65', ...      CHEMBL5218518   \n",
              "843  {'bei': '11.02', 'le': '0.22', 'lle': '2.07', ...         CHEMBL1421   \n",
              "\n",
              "    molecule_pref_name parent_molecule_chembl_id pchembl_value  \\\n",
              "0                 None              CHEMBL199723          5.02   \n",
              "1                 None              CHEMBL203354          None   \n",
              "2                 None              CHEMBL381738          4.84   \n",
              "3                 None              CHEMBL370800          4.89   \n",
              "4                 None              CHEMBL436509          5.42   \n",
              "..                 ...                       ...           ...   \n",
              "839               None             CHEMBL5174919          6.24   \n",
              "840          PONATINIB             CHEMBL1171837          9.30   \n",
              "841               None             CHEMBL5219197          4.67   \n",
              "842               None             CHEMBL5218518          4.75   \n",
              "843          DASATINIB                CHEMBL1421          5.38   \n",
              "\n",
              "     potential_duplicate                                 qudt_units  \\\n",
              "0                      0  http://www.openphacts.org/units/Nanomolar   \n",
              "1                      0                                       None   \n",
              "2                      0  http://www.openphacts.org/units/Nanomolar   \n",
              "3                      0  http://www.openphacts.org/units/Nanomolar   \n",
              "4                      0  http://www.openphacts.org/units/Nanomolar   \n",
              "..                   ...                                        ...   \n",
              "839                    0  http://www.openphacts.org/units/Nanomolar   \n",
              "840                    0  http://www.openphacts.org/units/Nanomolar   \n",
              "841                    0  http://www.openphacts.org/units/Nanomolar   \n",
              "842                    0  http://www.openphacts.org/units/Nanomolar   \n",
              "843                    0  http://www.openphacts.org/units/Nanomolar   \n",
              "\n",
              "     record_id relation  src_id  standard_flag standard_relation  \\\n",
              "0       422295        =       1              1                 =   \n",
              "1       422299     None       1              0              None   \n",
              "2       422298        =       1              1                 =   \n",
              "3       422297        =       1              1                 =   \n",
              "4       422296        =       1              1                 =   \n",
              "..         ...      ...     ...            ...               ...   \n",
              "839    3884778        =       1              1                 =   \n",
              "840    3885691        =       1              1                 =   \n",
              "841    3898645        =       1              1                 =   \n",
              "842    3898646        =       1              1                 =   \n",
              "843    3898647        =       1              1                 =   \n",
              "\n",
              "    standard_text_value standard_type standard_units standard_upper_value  \\\n",
              "0                  None          IC50             nM                 None   \n",
              "1                  None          IC50           None                 None   \n",
              "2                  None          IC50             nM                 None   \n",
              "3                  None          IC50             nM                 None   \n",
              "4                  None          IC50             nM                 None   \n",
              "..                  ...           ...            ...                  ...   \n",
              "839                None          IC50             nM                 None   \n",
              "840                None          IC50             nM                 None   \n",
              "841                None          IC50             nM                 None   \n",
              "842                None          IC50             nM                 None   \n",
              "843                None          IC50             nM                 None   \n",
              "\n",
              "    standard_value target_chembl_id target_organism        target_pref_name  \\\n",
              "0           9500.0    CHEMBL2096618    Homo sapiens  Bcr/Abl fusion protein   \n",
              "1             None    CHEMBL2096618    Homo sapiens  Bcr/Abl fusion protein   \n",
              "2          14600.0    CHEMBL2096618    Homo sapiens  Bcr/Abl fusion protein   \n",
              "3          12900.0    CHEMBL2096618    Homo sapiens  Bcr/Abl fusion protein   \n",
              "4           3800.0    CHEMBL2096618    Homo sapiens  Bcr/Abl fusion protein   \n",
              "..             ...              ...             ...                     ...   \n",
              "839          580.0    CHEMBL2096618    Homo sapiens  Bcr/Abl fusion protein   \n",
              "840            0.5    CHEMBL2096618    Homo sapiens  Bcr/Abl fusion protein   \n",
              "841        21200.0    CHEMBL2096618    Homo sapiens  Bcr/Abl fusion protein   \n",
              "842        17800.0    CHEMBL2096618    Homo sapiens  Bcr/Abl fusion protein   \n",
              "843         4200.0    CHEMBL2096618    Homo sapiens  Bcr/Abl fusion protein   \n",
              "\n",
              "    target_tax_id text_value  toid  type units    uo_units upper_value value  \n",
              "0            9606       None  None  IC50    uM  UO_0000065        None   9.5  \n",
              "1            9606       None  None  IC50  None        None        None  None  \n",
              "2            9606       None  None  IC50    uM  UO_0000065        None  14.6  \n",
              "3            9606       None  None  IC50    uM  UO_0000065        None  12.9  \n",
              "4            9606       None  None  IC50    uM  UO_0000065        None   3.8  \n",
              "..            ...        ...   ...   ...   ...         ...         ...   ...  \n",
              "839          9606       None  None  IC50    uM  UO_0000065        None  0.58  \n",
              "840          9606       None  None  IC50    nM  UO_0000065        None   0.5  \n",
              "841          9606       None  None  IC50    uM  UO_0000065        None  21.2  \n",
              "842          9606       None  None  IC50    uM  UO_0000065        None  17.8  \n",
              "843          9606       None  None  IC50    uM  UO_0000065        None   4.2  \n",
              "\n",
              "[844 rows x 46 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-7bb20f9c-8a12-4159-9e37-bf95ac215cf6\" class=\"colab-df-container\">\n",
              "    <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>action_type</th>\n",
              "      <th>activity_comment</th>\n",
              "      <th>activity_id</th>\n",
              "      <th>activity_properties</th>\n",
              "      <th>assay_chembl_id</th>\n",
              "      <th>assay_description</th>\n",
              "      <th>assay_type</th>\n",
              "      <th>assay_variant_accession</th>\n",
              "      <th>assay_variant_mutation</th>\n",
              "      <th>bao_endpoint</th>\n",
              "      <th>bao_format</th>\n",
              "      <th>bao_label</th>\n",
              "      <th>canonical_smiles</th>\n",
              "      <th>data_validity_comment</th>\n",
              "      <th>data_validity_description</th>\n",
              "      <th>document_chembl_id</th>\n",
              "      <th>document_journal</th>\n",
              "      <th>document_year</th>\n",
              "      <th>ligand_efficiency</th>\n",
              "      <th>molecule_chembl_id</th>\n",
              "      <th>molecule_pref_name</th>\n",
              "      <th>parent_molecule_chembl_id</th>\n",
              "      <th>pchembl_value</th>\n",
              "      <th>potential_duplicate</th>\n",
              "      <th>qudt_units</th>\n",
              "      <th>record_id</th>\n",
              "      <th>relation</th>\n",
              "      <th>src_id</th>\n",
              "      <th>standard_flag</th>\n",
              "      <th>standard_relation</th>\n",
              "      <th>standard_text_value</th>\n",
              "      <th>standard_type</th>\n",
              "      <th>standard_units</th>\n",
              "      <th>standard_upper_value</th>\n",
              "      <th>standard_value</th>\n",
              "      <th>target_chembl_id</th>\n",
              "      <th>target_organism</th>\n",
              "      <th>target_pref_name</th>\n",
              "      <th>target_tax_id</th>\n",
              "      <th>text_value</th>\n",
              "      <th>toid</th>\n",
              "      <th>type</th>\n",
              "      <th>units</th>\n",
              "      <th>uo_units</th>\n",
              "      <th>upper_value</th>\n",
              "      <th>value</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>1675266</td>\n",
              "      <td>[]</td>\n",
              "      <td>CHEMBL867071</td>\n",
              "      <td>Antiproliferative activity against human BCR-A...</td>\n",
              "      <td>F</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>BAO_0000190</td>\n",
              "      <td>BAO_0000219</td>\n",
              "      <td>cell-based format</td>\n",
              "      <td>CN1CCN(CCc2ccc(NC(=O)c3cc(-c4ccc5c(c4)OCO5)cnc...</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL1149386</td>\n",
              "      <td>J Med Chem</td>\n",
              "      <td>2006</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL199723</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL199723</td>\n",
              "      <td>5.02</td>\n",
              "      <td>0</td>\n",
              "      <td>http://www.openphacts.org/units/Nanomolar</td>\n",
              "      <td>422295</td>\n",
              "      <td>=</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>=</td>\n",
              "      <td>None</td>\n",
              "      <td>IC50</td>\n",
              "      <td>nM</td>\n",
              "      <td>None</td>\n",
              "      <td>9500.0</td>\n",
              "      <td>CHEMBL2096618</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bcr/Abl fusion protein</td>\n",
              "      <td>9606</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>IC50</td>\n",
              "      <td>uM</td>\n",
              "      <td>UO_0000065</td>\n",
              "      <td>None</td>\n",
              "      <td>9.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>None</td>\n",
              "      <td>Not Determined</td>\n",
              "      <td>1675350</td>\n",
              "      <td>[]</td>\n",
              "      <td>CHEMBL867071</td>\n",
              "      <td>Antiproliferative activity against human BCR-A...</td>\n",
              "      <td>F</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>BAO_0000190</td>\n",
              "      <td>BAO_0000219</td>\n",
              "      <td>cell-based format</td>\n",
              "      <td>COc1ccc(-c2cnc(O)c(C(=O)Nc3ccc(CN4CCN(C)CC4)cc...</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL1149386</td>\n",
              "      <td>J Med Chem</td>\n",
              "      <td>2006</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL203354</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL203354</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td>None</td>\n",
              "      <td>422299</td>\n",
              "      <td>None</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>IC50</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL2096618</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bcr/Abl fusion protein</td>\n",
              "      <td>9606</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>IC50</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>1675351</td>\n",
              "      <td>[]</td>\n",
              "      <td>CHEMBL867071</td>\n",
              "      <td>Antiproliferative activity against human BCR-A...</td>\n",
              "      <td>F</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>BAO_0000190</td>\n",
              "      <td>BAO_0000219</td>\n",
              "      <td>cell-based format</td>\n",
              "      <td>CN1CCN(CCCc2ccc(NC(=O)c3cc(-c4ccc5c(c4)OCO5)cn...</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL1149386</td>\n",
              "      <td>J Med Chem</td>\n",
              "      <td>2006</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL381738</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL381738</td>\n",
              "      <td>4.84</td>\n",
              "      <td>0</td>\n",
              "      <td>http://www.openphacts.org/units/Nanomolar</td>\n",
              "      <td>422298</td>\n",
              "      <td>=</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>=</td>\n",
              "      <td>None</td>\n",
              "      <td>IC50</td>\n",
              "      <td>nM</td>\n",
              "      <td>None</td>\n",
              "      <td>14600.0</td>\n",
              "      <td>CHEMBL2096618</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bcr/Abl fusion protein</td>\n",
              "      <td>9606</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>IC50</td>\n",
              "      <td>uM</td>\n",
              "      <td>UO_0000065</td>\n",
              "      <td>None</td>\n",
              "      <td>14.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>1675352</td>\n",
              "      <td>[]</td>\n",
              "      <td>CHEMBL867071</td>\n",
              "      <td>Antiproliferative activity against human BCR-A...</td>\n",
              "      <td>F</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>BAO_0000190</td>\n",
              "      <td>BAO_0000219</td>\n",
              "      <td>cell-based format</td>\n",
              "      <td>CN1CCN(Cc2ccc(NC(=O)c3cc(-c4ccc5c(c4)OCO5)cnc3...</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL1149386</td>\n",
              "      <td>J Med Chem</td>\n",
              "      <td>2006</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL370800</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL370800</td>\n",
              "      <td>4.89</td>\n",
              "      <td>0</td>\n",
              "      <td>http://www.openphacts.org/units/Nanomolar</td>\n",
              "      <td>422297</td>\n",
              "      <td>=</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>=</td>\n",
              "      <td>None</td>\n",
              "      <td>IC50</td>\n",
              "      <td>nM</td>\n",
              "      <td>None</td>\n",
              "      <td>12900.0</td>\n",
              "      <td>CHEMBL2096618</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bcr/Abl fusion protein</td>\n",
              "      <td>9606</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>IC50</td>\n",
              "      <td>uM</td>\n",
              "      <td>UO_0000065</td>\n",
              "      <td>None</td>\n",
              "      <td>12.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>1675353</td>\n",
              "      <td>[]</td>\n",
              "      <td>CHEMBL867071</td>\n",
              "      <td>Antiproliferative activity against human BCR-A...</td>\n",
              "      <td>F</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>BAO_0000190</td>\n",
              "      <td>BAO_0000219</td>\n",
              "      <td>cell-based format</td>\n",
              "      <td>CN1CCN(c2ccc(NC(=O)c3cc(-c4ccc5c(c4)OCO5)cnc3O...</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL1149386</td>\n",
              "      <td>J Med Chem</td>\n",
              "      <td>2006</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL436509</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL436509</td>\n",
              "      <td>5.42</td>\n",
              "      <td>0</td>\n",
              "      <td>http://www.openphacts.org/units/Nanomolar</td>\n",
              "      <td>422296</td>\n",
              "      <td>=</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>=</td>\n",
              "      <td>None</td>\n",
              "      <td>IC50</td>\n",
              "      <td>nM</td>\n",
              "      <td>None</td>\n",
              "      <td>3800.0</td>\n",
              "      <td>CHEMBL2096618</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bcr/Abl fusion protein</td>\n",
              "      <td>9606</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>IC50</td>\n",
              "      <td>uM</td>\n",
              "      <td>UO_0000065</td>\n",
              "      <td>None</td>\n",
              "      <td>3.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <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",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>839</th>\n",
              "      <td>{'action_type': 'INHIBITOR', 'description': 'N...</td>\n",
              "      <td>None</td>\n",
              "      <td>24863069</td>\n",
              "      <td>[]</td>\n",
              "      <td>CHEMBL5150925</td>\n",
              "      <td>Inhibition of BCR-ABL (unknown origin) using p...</td>\n",
              "      <td>B</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>BAO_0000190</td>\n",
              "      <td>BAO_0000224</td>\n",
              "      <td>protein format</td>\n",
              "      <td>CN1CCN(c2ccc(Nc3nc(Nc4ccc(F)c(F)c4)c4ncn(CC5CC...</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL5149979</td>\n",
              "      <td>Eur J Med Chem</td>\n",
              "      <td>2021</td>\n",
              "      <td>{'bei': '12.26', 'le': '0.23', 'lle': '1.35', ...</td>\n",
              "      <td>CHEMBL5174919</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL5174919</td>\n",
              "      <td>6.24</td>\n",
              "      <td>0</td>\n",
              "      <td>http://www.openphacts.org/units/Nanomolar</td>\n",
              "      <td>3884778</td>\n",
              "      <td>=</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>=</td>\n",
              "      <td>None</td>\n",
              "      <td>IC50</td>\n",
              "      <td>nM</td>\n",
              "      <td>None</td>\n",
              "      <td>580.0</td>\n",
              "      <td>CHEMBL2096618</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bcr/Abl fusion protein</td>\n",
              "      <td>9606</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>IC50</td>\n",
              "      <td>uM</td>\n",
              "      <td>UO_0000065</td>\n",
              "      <td>None</td>\n",
              "      <td>0.58</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>840</th>\n",
              "      <td>{'action_type': 'INHIBITOR', 'description': 'N...</td>\n",
              "      <td>None</td>\n",
              "      <td>24867166</td>\n",
              "      <td>[]</td>\n",
              "      <td>CHEMBL5151951</td>\n",
              "      <td>Inhibition of BCR-ABL (unknown origin) by kina...</td>\n",
              "      <td>B</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>BAO_0000190</td>\n",
              "      <td>BAO_0000224</td>\n",
              "      <td>protein format</td>\n",
              "      <td>Cc1ccc(C(=O)Nc2ccc(CN3CCN(C)CC3)c(C(F)(F)F)c2)...</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL5150004</td>\n",
              "      <td>J Med Chem</td>\n",
              "      <td>2021</td>\n",
              "      <td>{'bei': '17.46', 'le': '0.33', 'lle': '4.84', ...</td>\n",
              "      <td>CHEMBL1171837</td>\n",
              "      <td>PONATINIB</td>\n",
              "      <td>CHEMBL1171837</td>\n",
              "      <td>9.30</td>\n",
              "      <td>0</td>\n",
              "      <td>http://www.openphacts.org/units/Nanomolar</td>\n",
              "      <td>3885691</td>\n",
              "      <td>=</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>=</td>\n",
              "      <td>None</td>\n",
              "      <td>IC50</td>\n",
              "      <td>nM</td>\n",
              "      <td>None</td>\n",
              "      <td>0.5</td>\n",
              "      <td>CHEMBL2096618</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bcr/Abl fusion protein</td>\n",
              "      <td>9606</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>IC50</td>\n",
              "      <td>nM</td>\n",
              "      <td>UO_0000065</td>\n",
              "      <td>None</td>\n",
              "      <td>0.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>841</th>\n",
              "      <td>{'action_type': 'INHIBITOR', 'description': 'N...</td>\n",
              "      <td>None</td>\n",
              "      <td>24958852</td>\n",
              "      <td>[]</td>\n",
              "      <td>CHEMBL5215101</td>\n",
              "      <td>Inhibition of Bcr-Abl (unknown origin)</td>\n",
              "      <td>B</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>BAO_0000190</td>\n",
              "      <td>BAO_0000224</td>\n",
              "      <td>protein format</td>\n",
              "      <td>CCN1CCN(c2cc(Nc3ncc(C(=O)Nc4ccccc4N)s3)nc(C)n2...</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL5214883</td>\n",
              "      <td>Eur J Med Chem</td>\n",
              "      <td>2021</td>\n",
              "      <td>{'bei': '10.66', 'le': '0.21', 'lle': '1.71', ...</td>\n",
              "      <td>CHEMBL5219197</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL5219197</td>\n",
              "      <td>4.67</td>\n",
              "      <td>0</td>\n",
              "      <td>http://www.openphacts.org/units/Nanomolar</td>\n",
              "      <td>3898645</td>\n",
              "      <td>=</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>=</td>\n",
              "      <td>None</td>\n",
              "      <td>IC50</td>\n",
              "      <td>nM</td>\n",
              "      <td>None</td>\n",
              "      <td>21200.0</td>\n",
              "      <td>CHEMBL2096618</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bcr/Abl fusion protein</td>\n",
              "      <td>9606</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>IC50</td>\n",
              "      <td>uM</td>\n",
              "      <td>UO_0000065</td>\n",
              "      <td>None</td>\n",
              "      <td>21.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>842</th>\n",
              "      <td>{'action_type': 'INHIBITOR', 'description': 'N...</td>\n",
              "      <td>None</td>\n",
              "      <td>24958853</td>\n",
              "      <td>[]</td>\n",
              "      <td>CHEMBL5215101</td>\n",
              "      <td>Inhibition of Bcr-Abl (unknown origin)</td>\n",
              "      <td>B</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>BAO_0000190</td>\n",
              "      <td>BAO_0000224</td>\n",
              "      <td>protein format</td>\n",
              "      <td>CCN1CCN(c2cc(Nc3ncc(C(=O)Nc4ccc(F)cc4N)s3)nc(C...</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL5214883</td>\n",
              "      <td>Eur J Med Chem</td>\n",
              "      <td>2021</td>\n",
              "      <td>{'bei': '10.40', 'le': '0.20', 'lle': '1.65', ...</td>\n",
              "      <td>CHEMBL5218518</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL5218518</td>\n",
              "      <td>4.75</td>\n",
              "      <td>0</td>\n",
              "      <td>http://www.openphacts.org/units/Nanomolar</td>\n",
              "      <td>3898646</td>\n",
              "      <td>=</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>=</td>\n",
              "      <td>None</td>\n",
              "      <td>IC50</td>\n",
              "      <td>nM</td>\n",
              "      <td>None</td>\n",
              "      <td>17800.0</td>\n",
              "      <td>CHEMBL2096618</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bcr/Abl fusion protein</td>\n",
              "      <td>9606</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>IC50</td>\n",
              "      <td>uM</td>\n",
              "      <td>UO_0000065</td>\n",
              "      <td>None</td>\n",
              "      <td>17.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>843</th>\n",
              "      <td>{'action_type': 'INHIBITOR', 'description': 'N...</td>\n",
              "      <td>None</td>\n",
              "      <td>24958854</td>\n",
              "      <td>[]</td>\n",
              "      <td>CHEMBL5215101</td>\n",
              "      <td>Inhibition of Bcr-Abl (unknown origin)</td>\n",
              "      <td>B</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>BAO_0000190</td>\n",
              "      <td>BAO_0000224</td>\n",
              "      <td>protein format</td>\n",
              "      <td>Cc1nc(Nc2ncc(C(=O)Nc3c(C)cccc3Cl)s2)cc(N2CCN(C...</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>CHEMBL5214883</td>\n",
              "      <td>Eur J Med Chem</td>\n",
              "      <td>2021</td>\n",
              "      <td>{'bei': '11.02', 'le': '0.22', 'lle': '2.07', ...</td>\n",
              "      <td>CHEMBL1421</td>\n",
              "      <td>DASATINIB</td>\n",
              "      <td>CHEMBL1421</td>\n",
              "      <td>5.38</td>\n",
              "      <td>0</td>\n",
              "      <td>http://www.openphacts.org/units/Nanomolar</td>\n",
              "      <td>3898647</td>\n",
              "      <td>=</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>=</td>\n",
              "      <td>None</td>\n",
              "      <td>IC50</td>\n",
              "      <td>nM</td>\n",
              "      <td>None</td>\n",
              "      <td>4200.0</td>\n",
              "      <td>CHEMBL2096618</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bcr/Abl fusion protein</td>\n",
              "      <td>9606</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>IC50</td>\n",
              "      <td>uM</td>\n",
              "      <td>UO_0000065</td>\n",
              "      <td>None</td>\n",
              "      <td>4.2</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>844 rows × 46 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-7bb20f9c-8a12-4159-9e37-bf95ac215cf6')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-7bb20f9c-8a12-4159-9e37-bf95ac215cf6 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-7bb20f9c-8a12-4159-9e37-bf95ac215cf6');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-f376b241-c243-4241-bfcd-d0bf1248552f\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-f376b241-c243-4241-bfcd-d0bf1248552f')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-f376b241-c243-4241-bfcd-d0bf1248552f button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "  <div id=\"id_a073991f-628e-4625-a837-0b3cbb8bd6a6\">\n",
              "    <style>\n",
              "      .colab-df-generate {\n",
              "        background-color: #E8F0FE;\n",
              "        border: none;\n",
              "        border-radius: 50%;\n",
              "        cursor: pointer;\n",
              "        display: none;\n",
              "        fill: #1967D2;\n",
              "        height: 32px;\n",
              "        padding: 0 0 0 0;\n",
              "        width: 32px;\n",
              "      }\n",
              "\n",
              "      .colab-df-generate:hover {\n",
              "        background-color: #E2EBFA;\n",
              "        box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "        fill: #174EA6;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate {\n",
              "        background-color: #3B4455;\n",
              "        fill: #D2E3FC;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate:hover {\n",
              "        background-color: #434B5C;\n",
              "        box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "        filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "        fill: #FFFFFF;\n",
              "      }\n",
              "    </style>\n",
              "    <button class=\"colab-df-generate\" onclick=\"generateWithVariable('df')\"\n",
              "            title=\"Generate code using this dataframe.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M7,19H8.4L18.45,9,17,7.55,7,17.6ZM5,21V16.75L18.45,3.32a2,2,0,0,1,2.83,0l1.4,1.43a1.91,1.91,0,0,1,.58,1.4,1.91,1.91,0,0,1-.58,1.4L9.25,21ZM18.45,9,17,7.55Zm-12,3A5.31,5.31,0,0,0,4.9,8.1,5.31,5.31,0,0,0,1,6.5,5.31,5.31,0,0,0,4.9,4.9,5.31,5.31,0,0,0,6.5,1,5.31,5.31,0,0,0,8.1,4.9,5.31,5.31,0,0,0,12,6.5,5.46,5.46,0,0,0,6.5,12Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "    <script>\n",
              "      (() => {\n",
              "      const buttonEl =\n",
              "        document.querySelector('#id_a073991f-628e-4625-a837-0b3cbb8bd6a6 button.colab-df-generate');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      buttonEl.onclick = () => {\n",
              "        google.colab.notebook.generateWithVariable('df');\n",
              "      }\n",
              "      })();\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.to_csv('bcr_abl_bioactivity_data_raw.csv', index=False)"
      ],
      "metadata": {
        "id": "E-1e5jogKFOv"
      },
      "execution_count": 18,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "cp bcr_abl_bioactivity_data_raw.csv '/content/drive/MyDrive/inhibitor_prediction/bcr_abl/chembl_data_retrieve'"
      ],
      "metadata": {
        "id": "ZJDUc2PVUI1E"
      },
      "execution_count": 19,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "path = ('/content/drive/MyDrive/inhibitor_prediction/bcr_abl/chembl_data_retrieve/bcr_abl_bioactivity_data_raw.csv')"
      ],
      "metadata": {
        "id": "t0aGt-u6Whgl"
      },
      "execution_count": 20,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "pd.read_csv(path)"
      ],
      "metadata": {
        "id": "Q5-Lmi9ZWsGT",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 877
        },
        "outputId": "5110edf9-1c0d-4017-dddf-f8df168b521a"
      },
      "execution_count": 21,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                           action_type activity_comment  \\\n",
              "0                                                  NaN              NaN   \n",
              "1                                                  NaN   Not Determined   \n",
              "2                                                  NaN              NaN   \n",
              "3                                                  NaN              NaN   \n",
              "4                                                  NaN              NaN   \n",
              "..                                                 ...              ...   \n",
              "839  {'action_type': 'INHIBITOR', 'description': 'N...              NaN   \n",
              "840  {'action_type': 'INHIBITOR', 'description': 'N...              NaN   \n",
              "841  {'action_type': 'INHIBITOR', 'description': 'N...              NaN   \n",
              "842  {'action_type': 'INHIBITOR', 'description': 'N...              NaN   \n",
              "843  {'action_type': 'INHIBITOR', 'description': 'N...              NaN   \n",
              "\n",
              "     activity_id activity_properties assay_chembl_id  \\\n",
              "0        1675266                  []    CHEMBL867071   \n",
              "1        1675350                  []    CHEMBL867071   \n",
              "2        1675351                  []    CHEMBL867071   \n",
              "3        1675352                  []    CHEMBL867071   \n",
              "4        1675353                  []    CHEMBL867071   \n",
              "..           ...                 ...             ...   \n",
              "839     24863069                  []   CHEMBL5150925   \n",
              "840     24867166                  []   CHEMBL5151951   \n",
              "841     24958852                  []   CHEMBL5215101   \n",
              "842     24958853                  []   CHEMBL5215101   \n",
              "843     24958854                  []   CHEMBL5215101   \n",
              "\n",
              "                                     assay_description assay_type  \\\n",
              "0    Antiproliferative activity against human BCR-A...          F   \n",
              "1    Antiproliferative activity against human BCR-A...          F   \n",
              "2    Antiproliferative activity against human BCR-A...          F   \n",
              "3    Antiproliferative activity against human BCR-A...          F   \n",
              "4    Antiproliferative activity against human BCR-A...          F   \n",
              "..                                                 ...        ...   \n",
              "839  Inhibition of BCR-ABL (unknown origin) using p...          B   \n",
              "840  Inhibition of BCR-ABL (unknown origin) by kina...          B   \n",
              "841             Inhibition of Bcr-Abl (unknown origin)          B   \n",
              "842             Inhibition of Bcr-Abl (unknown origin)          B   \n",
              "843             Inhibition of Bcr-Abl (unknown origin)          B   \n",
              "\n",
              "    assay_variant_accession assay_variant_mutation bao_endpoint   bao_format  \\\n",
              "0                       NaN                    NaN  BAO_0000190  BAO_0000219   \n",
              "1                       NaN                    NaN  BAO_0000190  BAO_0000219   \n",
              "2                       NaN                    NaN  BAO_0000190  BAO_0000219   \n",
              "3                       NaN                    NaN  BAO_0000190  BAO_0000219   \n",
              "4                       NaN                    NaN  BAO_0000190  BAO_0000219   \n",
              "..                      ...                    ...          ...          ...   \n",
              "839                     NaN                    NaN  BAO_0000190  BAO_0000224   \n",
              "840                     NaN                    NaN  BAO_0000190  BAO_0000224   \n",
              "841                     NaN                    NaN  BAO_0000190  BAO_0000224   \n",
              "842                     NaN                    NaN  BAO_0000190  BAO_0000224   \n",
              "843                     NaN                    NaN  BAO_0000190  BAO_0000224   \n",
              "\n",
              "             bao_label                                   canonical_smiles  \\\n",
              "0    cell-based format  CN1CCN(CCc2ccc(NC(=O)c3cc(-c4ccc5c(c4)OCO5)cnc...   \n",
              "1    cell-based format  COc1ccc(-c2cnc(O)c(C(=O)Nc3ccc(CN4CCN(C)CC4)cc...   \n",
              "2    cell-based format  CN1CCN(CCCc2ccc(NC(=O)c3cc(-c4ccc5c(c4)OCO5)cn...   \n",
              "3    cell-based format  CN1CCN(Cc2ccc(NC(=O)c3cc(-c4ccc5c(c4)OCO5)cnc3...   \n",
              "4    cell-based format  CN1CCN(c2ccc(NC(=O)c3cc(-c4ccc5c(c4)OCO5)cnc3O...   \n",
              "..                 ...                                                ...   \n",
              "839     protein format  CN1CCN(c2ccc(Nc3nc(Nc4ccc(F)c(F)c4)c4ncn(CC5CC...   \n",
              "840     protein format  Cc1ccc(C(=O)Nc2ccc(CN3CCN(C)CC3)c(C(F)(F)F)c2)...   \n",
              "841     protein format  CCN1CCN(c2cc(Nc3ncc(C(=O)Nc4ccccc4N)s3)nc(C)n2...   \n",
              "842     protein format  CCN1CCN(c2cc(Nc3ncc(C(=O)Nc4ccc(F)cc4N)s3)nc(C...   \n",
              "843     protein format  Cc1nc(Nc2ncc(C(=O)Nc3c(C)cccc3Cl)s2)cc(N2CCN(C...   \n",
              "\n",
              "    data_validity_comment data_validity_description document_chembl_id  \\\n",
              "0                     NaN                       NaN      CHEMBL1149386   \n",
              "1                     NaN                       NaN      CHEMBL1149386   \n",
              "2                     NaN                       NaN      CHEMBL1149386   \n",
              "3                     NaN                       NaN      CHEMBL1149386   \n",
              "4                     NaN                       NaN      CHEMBL1149386   \n",
              "..                    ...                       ...                ...   \n",
              "839                   NaN                       NaN      CHEMBL5149979   \n",
              "840                   NaN                       NaN      CHEMBL5150004   \n",
              "841                   NaN                       NaN      CHEMBL5214883   \n",
              "842                   NaN                       NaN      CHEMBL5214883   \n",
              "843                   NaN                       NaN      CHEMBL5214883   \n",
              "\n",
              "    document_journal  document_year  \\\n",
              "0         J Med Chem           2006   \n",
              "1         J Med Chem           2006   \n",
              "2         J Med Chem           2006   \n",
              "3         J Med Chem           2006   \n",
              "4         J Med Chem           2006   \n",
              "..               ...            ...   \n",
              "839   Eur J Med Chem           2021   \n",
              "840       J Med Chem           2021   \n",
              "841   Eur J Med Chem           2021   \n",
              "842   Eur J Med Chem           2021   \n",
              "843   Eur J Med Chem           2021   \n",
              "\n",
              "                                     ligand_efficiency molecule_chembl_id  \\\n",
              "0                                                  NaN       CHEMBL199723   \n",
              "1                                                  NaN       CHEMBL203354   \n",
              "2                                                  NaN       CHEMBL381738   \n",
              "3                                                  NaN       CHEMBL370800   \n",
              "4                                                  NaN       CHEMBL436509   \n",
              "..                                                 ...                ...   \n",
              "839  {'bei': '12.26', 'le': '0.23', 'lle': '1.35', ...      CHEMBL5174919   \n",
              "840  {'bei': '17.46', 'le': '0.33', 'lle': '4.84', ...      CHEMBL1171837   \n",
              "841  {'bei': '10.66', 'le': '0.21', 'lle': '1.71', ...      CHEMBL5219197   \n",
              "842  {'bei': '10.40', 'le': '0.20', 'lle': '1.65', ...      CHEMBL5218518   \n",
              "843  {'bei': '11.02', 'le': '0.22', 'lle': '2.07', ...         CHEMBL1421   \n",
              "\n",
              "    molecule_pref_name parent_molecule_chembl_id  pchembl_value  \\\n",
              "0                  NaN              CHEMBL199723           5.02   \n",
              "1                  NaN              CHEMBL203354            NaN   \n",
              "2                  NaN              CHEMBL381738           4.84   \n",
              "3                  NaN              CHEMBL370800           4.89   \n",
              "4                  NaN              CHEMBL436509           5.42   \n",
              "..                 ...                       ...            ...   \n",
              "839                NaN             CHEMBL5174919           6.24   \n",
              "840          PONATINIB             CHEMBL1171837           9.30   \n",
              "841                NaN             CHEMBL5219197           4.67   \n",
              "842                NaN             CHEMBL5218518           4.75   \n",
              "843          DASATINIB                CHEMBL1421           5.38   \n",
              "\n",
              "     potential_duplicate                                 qudt_units  \\\n",
              "0                      0  http://www.openphacts.org/units/Nanomolar   \n",
              "1                      0                                        NaN   \n",
              "2                      0  http://www.openphacts.org/units/Nanomolar   \n",
              "3                      0  http://www.openphacts.org/units/Nanomolar   \n",
              "4                      0  http://www.openphacts.org/units/Nanomolar   \n",
              "..                   ...                                        ...   \n",
              "839                    0  http://www.openphacts.org/units/Nanomolar   \n",
              "840                    0  http://www.openphacts.org/units/Nanomolar   \n",
              "841                    0  http://www.openphacts.org/units/Nanomolar   \n",
              "842                    0  http://www.openphacts.org/units/Nanomolar   \n",
              "843                    0  http://www.openphacts.org/units/Nanomolar   \n",
              "\n",
              "     record_id relation  src_id  standard_flag standard_relation  \\\n",
              "0       422295        =       1              1                 =   \n",
              "1       422299      NaN       1              0               NaN   \n",
              "2       422298        =       1              1                 =   \n",
              "3       422297        =       1              1                 =   \n",
              "4       422296        =       1              1                 =   \n",
              "..         ...      ...     ...            ...               ...   \n",
              "839    3884778        =       1              1                 =   \n",
              "840    3885691        =       1              1                 =   \n",
              "841    3898645        =       1              1                 =   \n",
              "842    3898646        =       1              1                 =   \n",
              "843    3898647        =       1              1                 =   \n",
              "\n",
              "     standard_text_value standard_type standard_units  standard_upper_value  \\\n",
              "0                    NaN          IC50             nM                   NaN   \n",
              "1                    NaN          IC50            NaN                   NaN   \n",
              "2                    NaN          IC50             nM                   NaN   \n",
              "3                    NaN          IC50             nM                   NaN   \n",
              "4                    NaN          IC50             nM                   NaN   \n",
              "..                   ...           ...            ...                   ...   \n",
              "839                  NaN          IC50             nM                   NaN   \n",
              "840                  NaN          IC50             nM                   NaN   \n",
              "841                  NaN          IC50             nM                   NaN   \n",
              "842                  NaN          IC50             nM                   NaN   \n",
              "843                  NaN          IC50             nM                   NaN   \n",
              "\n",
              "     standard_value target_chembl_id target_organism        target_pref_name  \\\n",
              "0            9500.0    CHEMBL2096618    Homo sapiens  Bcr/Abl fusion protein   \n",
              "1               NaN    CHEMBL2096618    Homo sapiens  Bcr/Abl fusion protein   \n",
              "2           14600.0    CHEMBL2096618    Homo sapiens  Bcr/Abl fusion protein   \n",
              "3           12900.0    CHEMBL2096618    Homo sapiens  Bcr/Abl fusion protein   \n",
              "4            3800.0    CHEMBL2096618    Homo sapiens  Bcr/Abl fusion protein   \n",
              "..              ...              ...             ...                     ...   \n",
              "839           580.0    CHEMBL2096618    Homo sapiens  Bcr/Abl fusion protein   \n",
              "840             0.5    CHEMBL2096618    Homo sapiens  Bcr/Abl fusion protein   \n",
              "841         21200.0    CHEMBL2096618    Homo sapiens  Bcr/Abl fusion protein   \n",
              "842         17800.0    CHEMBL2096618    Homo sapiens  Bcr/Abl fusion protein   \n",
              "843          4200.0    CHEMBL2096618    Homo sapiens  Bcr/Abl fusion protein   \n",
              "\n",
              "     target_tax_id  text_value  toid  type units    uo_units  upper_value  \\\n",
              "0             9606         NaN   NaN  IC50    uM  UO_0000065          NaN   \n",
              "1             9606         NaN   NaN  IC50   NaN         NaN          NaN   \n",
              "2             9606         NaN   NaN  IC50    uM  UO_0000065          NaN   \n",
              "3             9606         NaN   NaN  IC50    uM  UO_0000065          NaN   \n",
              "4             9606         NaN   NaN  IC50    uM  UO_0000065          NaN   \n",
              "..             ...         ...   ...   ...   ...         ...          ...   \n",
              "839           9606         NaN   NaN  IC50    uM  UO_0000065          NaN   \n",
              "840           9606         NaN   NaN  IC50    nM  UO_0000065          NaN   \n",
              "841           9606         NaN   NaN  IC50    uM  UO_0000065          NaN   \n",
              "842           9606         NaN   NaN  IC50    uM  UO_0000065          NaN   \n",
              "843           9606         NaN   NaN  IC50    uM  UO_0000065          NaN   \n",
              "\n",
              "     value  \n",
              "0     9.50  \n",
              "1      NaN  \n",
              "2    14.60  \n",
              "3    12.90  \n",
              "4     3.80  \n",
              "..     ...  \n",
              "839   0.58  \n",
              "840   0.50  \n",
              "841  21.20  \n",
              "842  17.80  \n",
              "843   4.20  \n",
              "\n",
              "[844 rows x 46 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-18c31ecb-1466-4f6e-a88e-a1309d778571\" class=\"colab-df-container\">\n",
              "    <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>action_type</th>\n",
              "      <th>activity_comment</th>\n",
              "      <th>activity_id</th>\n",
              "      <th>activity_properties</th>\n",
              "      <th>assay_chembl_id</th>\n",
              "      <th>assay_description</th>\n",
              "      <th>assay_type</th>\n",
              "      <th>assay_variant_accession</th>\n",
              "      <th>assay_variant_mutation</th>\n",
              "      <th>bao_endpoint</th>\n",
              "      <th>bao_format</th>\n",
              "      <th>bao_label</th>\n",
              "      <th>canonical_smiles</th>\n",
              "      <th>data_validity_comment</th>\n",
              "      <th>data_validity_description</th>\n",
              "      <th>document_chembl_id</th>\n",
              "      <th>document_journal</th>\n",
              "      <th>document_year</th>\n",
              "      <th>ligand_efficiency</th>\n",
              "      <th>molecule_chembl_id</th>\n",
              "      <th>molecule_pref_name</th>\n",
              "      <th>parent_molecule_chembl_id</th>\n",
              "      <th>pchembl_value</th>\n",
              "      <th>potential_duplicate</th>\n",
              "      <th>qudt_units</th>\n",
              "      <th>record_id</th>\n",
              "      <th>relation</th>\n",
              "      <th>src_id</th>\n",
              "      <th>standard_flag</th>\n",
              "      <th>standard_relation</th>\n",
              "      <th>standard_text_value</th>\n",
              "      <th>standard_type</th>\n",
              "      <th>standard_units</th>\n",
              "      <th>standard_upper_value</th>\n",
              "      <th>standard_value</th>\n",
              "      <th>target_chembl_id</th>\n",
              "      <th>target_organism</th>\n",
              "      <th>target_pref_name</th>\n",
              "      <th>target_tax_id</th>\n",
              "      <th>text_value</th>\n",
              "      <th>toid</th>\n",
              "      <th>type</th>\n",
              "      <th>units</th>\n",
              "      <th>uo_units</th>\n",
              "      <th>upper_value</th>\n",
              "      <th>value</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1675266</td>\n",
              "      <td>[]</td>\n",
              "      <td>CHEMBL867071</td>\n",
              "      <td>Antiproliferative activity against human BCR-A...</td>\n",
              "      <td>F</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>BAO_0000190</td>\n",
              "      <td>BAO_0000219</td>\n",
              "      <td>cell-based format</td>\n",
              "      <td>CN1CCN(CCc2ccc(NC(=O)c3cc(-c4ccc5c(c4)OCO5)cnc...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL1149386</td>\n",
              "      <td>J Med Chem</td>\n",
              "      <td>2006</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL199723</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL199723</td>\n",
              "      <td>5.02</td>\n",
              "      <td>0</td>\n",
              "      <td>http://www.openphacts.org/units/Nanomolar</td>\n",
              "      <td>422295</td>\n",
              "      <td>=</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>=</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IC50</td>\n",
              "      <td>nM</td>\n",
              "      <td>NaN</td>\n",
              "      <td>9500.0</td>\n",
              "      <td>CHEMBL2096618</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bcr/Abl fusion protein</td>\n",
              "      <td>9606</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IC50</td>\n",
              "      <td>uM</td>\n",
              "      <td>UO_0000065</td>\n",
              "      <td>NaN</td>\n",
              "      <td>9.50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>NaN</td>\n",
              "      <td>Not Determined</td>\n",
              "      <td>1675350</td>\n",
              "      <td>[]</td>\n",
              "      <td>CHEMBL867071</td>\n",
              "      <td>Antiproliferative activity against human BCR-A...</td>\n",
              "      <td>F</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>BAO_0000190</td>\n",
              "      <td>BAO_0000219</td>\n",
              "      <td>cell-based format</td>\n",
              "      <td>COc1ccc(-c2cnc(O)c(C(=O)Nc3ccc(CN4CCN(C)CC4)cc...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL1149386</td>\n",
              "      <td>J Med Chem</td>\n",
              "      <td>2006</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL203354</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL203354</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>422299</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IC50</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL2096618</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bcr/Abl fusion protein</td>\n",
              "      <td>9606</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IC50</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1675351</td>\n",
              "      <td>[]</td>\n",
              "      <td>CHEMBL867071</td>\n",
              "      <td>Antiproliferative activity against human BCR-A...</td>\n",
              "      <td>F</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>BAO_0000190</td>\n",
              "      <td>BAO_0000219</td>\n",
              "      <td>cell-based format</td>\n",
              "      <td>CN1CCN(CCCc2ccc(NC(=O)c3cc(-c4ccc5c(c4)OCO5)cn...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL1149386</td>\n",
              "      <td>J Med Chem</td>\n",
              "      <td>2006</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL381738</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL381738</td>\n",
              "      <td>4.84</td>\n",
              "      <td>0</td>\n",
              "      <td>http://www.openphacts.org/units/Nanomolar</td>\n",
              "      <td>422298</td>\n",
              "      <td>=</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>=</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IC50</td>\n",
              "      <td>nM</td>\n",
              "      <td>NaN</td>\n",
              "      <td>14600.0</td>\n",
              "      <td>CHEMBL2096618</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bcr/Abl fusion protein</td>\n",
              "      <td>9606</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IC50</td>\n",
              "      <td>uM</td>\n",
              "      <td>UO_0000065</td>\n",
              "      <td>NaN</td>\n",
              "      <td>14.60</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1675352</td>\n",
              "      <td>[]</td>\n",
              "      <td>CHEMBL867071</td>\n",
              "      <td>Antiproliferative activity against human BCR-A...</td>\n",
              "      <td>F</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>BAO_0000190</td>\n",
              "      <td>BAO_0000219</td>\n",
              "      <td>cell-based format</td>\n",
              "      <td>CN1CCN(Cc2ccc(NC(=O)c3cc(-c4ccc5c(c4)OCO5)cnc3...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL1149386</td>\n",
              "      <td>J Med Chem</td>\n",
              "      <td>2006</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL370800</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL370800</td>\n",
              "      <td>4.89</td>\n",
              "      <td>0</td>\n",
              "      <td>http://www.openphacts.org/units/Nanomolar</td>\n",
              "      <td>422297</td>\n",
              "      <td>=</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>=</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IC50</td>\n",
              "      <td>nM</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12900.0</td>\n",
              "      <td>CHEMBL2096618</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bcr/Abl fusion protein</td>\n",
              "      <td>9606</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IC50</td>\n",
              "      <td>uM</td>\n",
              "      <td>UO_0000065</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12.90</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1675353</td>\n",
              "      <td>[]</td>\n",
              "      <td>CHEMBL867071</td>\n",
              "      <td>Antiproliferative activity against human BCR-A...</td>\n",
              "      <td>F</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>BAO_0000190</td>\n",
              "      <td>BAO_0000219</td>\n",
              "      <td>cell-based format</td>\n",
              "      <td>CN1CCN(c2ccc(NC(=O)c3cc(-c4ccc5c(c4)OCO5)cnc3O...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL1149386</td>\n",
              "      <td>J Med Chem</td>\n",
              "      <td>2006</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL436509</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL436509</td>\n",
              "      <td>5.42</td>\n",
              "      <td>0</td>\n",
              "      <td>http://www.openphacts.org/units/Nanomolar</td>\n",
              "      <td>422296</td>\n",
              "      <td>=</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>=</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IC50</td>\n",
              "      <td>nM</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3800.0</td>\n",
              "      <td>CHEMBL2096618</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bcr/Abl fusion protein</td>\n",
              "      <td>9606</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IC50</td>\n",
              "      <td>uM</td>\n",
              "      <td>UO_0000065</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.80</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <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",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>839</th>\n",
              "      <td>{'action_type': 'INHIBITOR', 'description': 'N...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>24863069</td>\n",
              "      <td>[]</td>\n",
              "      <td>CHEMBL5150925</td>\n",
              "      <td>Inhibition of BCR-ABL (unknown origin) using p...</td>\n",
              "      <td>B</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>BAO_0000190</td>\n",
              "      <td>BAO_0000224</td>\n",
              "      <td>protein format</td>\n",
              "      <td>CN1CCN(c2ccc(Nc3nc(Nc4ccc(F)c(F)c4)c4ncn(CC5CC...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL5149979</td>\n",
              "      <td>Eur J Med Chem</td>\n",
              "      <td>2021</td>\n",
              "      <td>{'bei': '12.26', 'le': '0.23', 'lle': '1.35', ...</td>\n",
              "      <td>CHEMBL5174919</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL5174919</td>\n",
              "      <td>6.24</td>\n",
              "      <td>0</td>\n",
              "      <td>http://www.openphacts.org/units/Nanomolar</td>\n",
              "      <td>3884778</td>\n",
              "      <td>=</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>=</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IC50</td>\n",
              "      <td>nM</td>\n",
              "      <td>NaN</td>\n",
              "      <td>580.0</td>\n",
              "      <td>CHEMBL2096618</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bcr/Abl fusion protein</td>\n",
              "      <td>9606</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IC50</td>\n",
              "      <td>uM</td>\n",
              "      <td>UO_0000065</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.58</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>840</th>\n",
              "      <td>{'action_type': 'INHIBITOR', 'description': 'N...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>24867166</td>\n",
              "      <td>[]</td>\n",
              "      <td>CHEMBL5151951</td>\n",
              "      <td>Inhibition of BCR-ABL (unknown origin) by kina...</td>\n",
              "      <td>B</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>BAO_0000190</td>\n",
              "      <td>BAO_0000224</td>\n",
              "      <td>protein format</td>\n",
              "      <td>Cc1ccc(C(=O)Nc2ccc(CN3CCN(C)CC3)c(C(F)(F)F)c2)...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL5150004</td>\n",
              "      <td>J Med Chem</td>\n",
              "      <td>2021</td>\n",
              "      <td>{'bei': '17.46', 'le': '0.33', 'lle': '4.84', ...</td>\n",
              "      <td>CHEMBL1171837</td>\n",
              "      <td>PONATINIB</td>\n",
              "      <td>CHEMBL1171837</td>\n",
              "      <td>9.30</td>\n",
              "      <td>0</td>\n",
              "      <td>http://www.openphacts.org/units/Nanomolar</td>\n",
              "      <td>3885691</td>\n",
              "      <td>=</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>=</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IC50</td>\n",
              "      <td>nM</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.5</td>\n",
              "      <td>CHEMBL2096618</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bcr/Abl fusion protein</td>\n",
              "      <td>9606</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IC50</td>\n",
              "      <td>nM</td>\n",
              "      <td>UO_0000065</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>841</th>\n",
              "      <td>{'action_type': 'INHIBITOR', 'description': 'N...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>24958852</td>\n",
              "      <td>[]</td>\n",
              "      <td>CHEMBL5215101</td>\n",
              "      <td>Inhibition of Bcr-Abl (unknown origin)</td>\n",
              "      <td>B</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>BAO_0000190</td>\n",
              "      <td>BAO_0000224</td>\n",
              "      <td>protein format</td>\n",
              "      <td>CCN1CCN(c2cc(Nc3ncc(C(=O)Nc4ccccc4N)s3)nc(C)n2...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL5214883</td>\n",
              "      <td>Eur J Med Chem</td>\n",
              "      <td>2021</td>\n",
              "      <td>{'bei': '10.66', 'le': '0.21', 'lle': '1.71', ...</td>\n",
              "      <td>CHEMBL5219197</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL5219197</td>\n",
              "      <td>4.67</td>\n",
              "      <td>0</td>\n",
              "      <td>http://www.openphacts.org/units/Nanomolar</td>\n",
              "      <td>3898645</td>\n",
              "      <td>=</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>=</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IC50</td>\n",
              "      <td>nM</td>\n",
              "      <td>NaN</td>\n",
              "      <td>21200.0</td>\n",
              "      <td>CHEMBL2096618</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bcr/Abl fusion protein</td>\n",
              "      <td>9606</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IC50</td>\n",
              "      <td>uM</td>\n",
              "      <td>UO_0000065</td>\n",
              "      <td>NaN</td>\n",
              "      <td>21.20</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>842</th>\n",
              "      <td>{'action_type': 'INHIBITOR', 'description': 'N...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>24958853</td>\n",
              "      <td>[]</td>\n",
              "      <td>CHEMBL5215101</td>\n",
              "      <td>Inhibition of Bcr-Abl (unknown origin)</td>\n",
              "      <td>B</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>BAO_0000190</td>\n",
              "      <td>BAO_0000224</td>\n",
              "      <td>protein format</td>\n",
              "      <td>CCN1CCN(c2cc(Nc3ncc(C(=O)Nc4ccc(F)cc4N)s3)nc(C...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL5214883</td>\n",
              "      <td>Eur J Med Chem</td>\n",
              "      <td>2021</td>\n",
              "      <td>{'bei': '10.40', 'le': '0.20', 'lle': '1.65', ...</td>\n",
              "      <td>CHEMBL5218518</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL5218518</td>\n",
              "      <td>4.75</td>\n",
              "      <td>0</td>\n",
              "      <td>http://www.openphacts.org/units/Nanomolar</td>\n",
              "      <td>3898646</td>\n",
              "      <td>=</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>=</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IC50</td>\n",
              "      <td>nM</td>\n",
              "      <td>NaN</td>\n",
              "      <td>17800.0</td>\n",
              "      <td>CHEMBL2096618</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bcr/Abl fusion protein</td>\n",
              "      <td>9606</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IC50</td>\n",
              "      <td>uM</td>\n",
              "      <td>UO_0000065</td>\n",
              "      <td>NaN</td>\n",
              "      <td>17.80</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>843</th>\n",
              "      <td>{'action_type': 'INHIBITOR', 'description': 'N...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>24958854</td>\n",
              "      <td>[]</td>\n",
              "      <td>CHEMBL5215101</td>\n",
              "      <td>Inhibition of Bcr-Abl (unknown origin)</td>\n",
              "      <td>B</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>BAO_0000190</td>\n",
              "      <td>BAO_0000224</td>\n",
              "      <td>protein format</td>\n",
              "      <td>Cc1nc(Nc2ncc(C(=O)Nc3c(C)cccc3Cl)s2)cc(N2CCN(C...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CHEMBL5214883</td>\n",
              "      <td>Eur J Med Chem</td>\n",
              "      <td>2021</td>\n",
              "      <td>{'bei': '11.02', 'le': '0.22', 'lle': '2.07', ...</td>\n",
              "      <td>CHEMBL1421</td>\n",
              "      <td>DASATINIB</td>\n",
              "      <td>CHEMBL1421</td>\n",
              "      <td>5.38</td>\n",
              "      <td>0</td>\n",
              "      <td>http://www.openphacts.org/units/Nanomolar</td>\n",
              "      <td>3898647</td>\n",
              "      <td>=</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>=</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IC50</td>\n",
              "      <td>nM</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4200.0</td>\n",
              "      <td>CHEMBL2096618</td>\n",
              "      <td>Homo sapiens</td>\n",
              "      <td>Bcr/Abl fusion protein</td>\n",
              "      <td>9606</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IC50</td>\n",
              "      <td>uM</td>\n",
              "      <td>UO_0000065</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4.20</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>844 rows × 46 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-18c31ecb-1466-4f6e-a88e-a1309d778571')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-18c31ecb-1466-4f6e-a88e-a1309d778571 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-18c31ecb-1466-4f6e-a88e-a1309d778571');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-ffd6d22c-f0fb-46cf-aa3f-405f3e688bbd\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-ffd6d22c-f0fb-46cf-aa3f-405f3e688bbd')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-ffd6d22c-f0fb-46cf-aa3f-405f3e688bbd button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 21
        }
      ]
    }
  ]
}