{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "c59f55d8-e623-4f92-af20-ad2666e990c4", "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/home/ubuntu/.local/lib/python3.10/site-packages/matplotlib/projections/__init__.py:63: UserWarning: Unable to import Axes3D. This may be due to multiple versions of Matplotlib being installed (e.g. as a system package and as a pip package). As a result, the 3D projection is not available.\n", " warnings.warn(\"Unable to import Axes3D. This may be due to multiple versions of \"\n" ] } ], "source": [ "import scanpy as sc\n", "import pandas as pd \n", "import anndata as ad\n", "from tqdm import tqdm" ] }, { "cell_type": "markdown", "id": "8fee8391-6ed8-4038-a307-f2a86513f903", "metadata": {}, "source": [ "## Building a combined anndata with embeddings from PCA, scVI, CVI, TF" ] }, { "cell_type": "code", "execution_count": 25, "id": "46d9e62e-660f-46a8-bfc8-dcc809c21d86", "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/home/ubuntu/.local/lib/python3.10/site-packages/anndata/_core/anndata.py:1756: UserWarning: Observation names are not unique. To make them unique, call `.obs_names_make_unique`.\n", " utils.warn_names_duplicates(\"obs\")\n" ] } ], "source": [ "scvi_edata = sc.read_h5ad('./embeddings/inference_100x_scVI.h5ad')" ] }, { "cell_type": "code", "execution_count": 24, "id": "e2156803-4ee6-4839-bc7a-dd40e170a000", "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/home/ubuntu/.local/lib/python3.10/site-packages/anndata/_core/anndata.py:1756: UserWarning: Observation names are not unique. To make them unique, call `.obs_names_make_unique`.\n", " utils.warn_names_duplicates(\"obs\")\n" ] } ], "source": [ "cvi_edata = sc.read_h5ad('./embeddings/test_100x_contrastiveVI.h5ad')" ] }, { "cell_type": "code", "execution_count": null, "id": "747d7b36-d294-4658-9d6e-50dac3f21555", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": 28, "id": "1b06309a-5121-41e6-89a4-e3384572b894", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "AnnData object with n_obs × n_vars = 482620 × 10000\n", " obs: 'sample', 'gene_count', 'tscp_count', 'mread_count', 'drugname_drugconc', 'drug', 'cell_line', 'sublibrary', 'BARCODE', 'pcnt_mito', 'S_score', 'G2M_score', 'phase', 'pass_filter', 'cell_name', 'plate', 'train_val_test_split', '_scvi_batch', '_scvi_labels'\n", " uns: '_scvi_manager_uuid', '_scvi_uuid'\n", " obsm: 'background_rep_contrastiveVI', 'salient_rep_contrastiveVI'\n", " layers: 'raw'" ] }, "execution_count": 28, "metadata": {}, "output_type": "execute_result" } ], "source": [ "cvi_edata" ] }, { "cell_type": "code", "execution_count": 29, "id": "fd6b8d89-830e-46ff-9d6a-36b72179d4a6", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "AnnData object with n_obs × n_vars = 482620 × 10000\n", " obs: 'sample', 'gene_count', 'tscp_count', 'mread_count', 'drugname_drugconc', 'drug', 'cell_line', 'sublibrary', 'BARCODE', 'pcnt_mito', 'S_score', 'G2M_score', 'phase', 'pass_filter', 'cell_name', 'plate', 'train_val_test_split', '_scvi_batch', '_scvi_labels'\n", " uns: '_scvi_manager_uuid', '_scvi_uuid', 'neighbors', 'umap'\n", " obsm: 'X_scVI'\n", " layers: 'raw'\n", " obsp: 'connectivities', 'distances'" ] }, "execution_count": 29, "metadata": {}, "output_type": "execute_result" } ], "source": [ "scvi_edata" ] }, { "cell_type": "code", "execution_count": null, "id": "a3b5e8a7-d69c-4b32-b636-08b68babf4f4", "metadata": {}, "outputs": [], "source": [ "adata.obsm['salient_rep_contrastiveVI'] " ] }, { "cell_type": "code", "execution_count": null, "id": "33051582-031c-4ee8-9afb-9e97905d518f", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "markdown", "id": "d0fe68d5-b75b-4171-96de-62cf17d9f133", "metadata": {}, "source": [ "## Collapse cVI" ] }, { "cell_type": "code", "execution_count": 33, "id": "49b4a3c0-9dff-4df2-bd6e-1b96054518a3", "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/tmp/ipykernel_51540/1378527330.py:21: FutureWarning: The default of observed=False is deprecated and will be changed to True in a future version of pandas. Pass observed=False to retain current behavior or observed=True to adopt the future default and silence this warning.\n", " .groupby([\"drug\", \"cell_line\"])[feat_cols]\n" ] } ], "source": [ "import numpy as np\n", "import pandas as pd\n", "import scanpy as sc\n", "from anndata import AnnData\n", "\n", "\n", "feat_cols = [f\"drug_emb_{i}\" for i in range(cvi_edata.obsm['salient_rep_contrastiveVI'].shape[1])]\n", "df_embed = pd.DataFrame(\n", " cvi_edata.obsm['salient_rep_contrastiveVI'],\n", " index=cvi_edata.obs_names,\n", " columns=feat_cols\n", ")\n", "\n", "df_embed = df_embed.join(\n", " cvi_edata.obs[[\"drug\", \"cell_line\"]]\n", ")\n", "\n", "#Aggregate (mean) per (drug, cell_line)\n", "grp = (\n", " df_embed\n", " .groupby([\"drug\", \"cell_line\"])[feat_cols]\n", " .mean()\n", " .reset_index()\n", ")\n", "\n", "# Extract DMSO_TF (control) per cell_line\n", "ctrl = (\n", " grp[grp[\"drug\"] == \"DMSO_TF\"]\n", " .set_index(\"cell_line\")[feat_cols]\n", " .rename(lambda c: f\"ctrl_{c}\", axis=1)\n", ")\n", "\n", "# Prepare the “drug vs. DMSO” concatenated DataFram# - drop the DMSO rows\n", "df_pairs = grp[grp[\"drug\"] != \"DMSO_TF\"].copy()\n", "\n", "# merge in the control embeddings\n", "df_pairs = df_pairs.merge(\n", " ctrl,\n", " left_on=\"cell_line\",\n", " right_index=True,\n", " how=\"left\"\n", ")\n" ] }, { "cell_type": "code", "execution_count": 34, "id": "fb2ec2d1-b222-4f63-bc18-27180a7af67b", "metadata": {}, "outputs": [], "source": [ "## Build the new AnnData\n", "# - X is the concatenated vector of [drug_avg, ctrl_avg]\n", "feature_cols = feat_cols + list(ctrl.columns)\n", "X_concat = df_pairs[feature_cols].values\n", "\n", "# - obs is the metadata of each drug-cell pair\n", "obs_meta = df_pairs[[\"drug\", \"cell_line\"]].copy()\n", "obs_meta.index = pd.Index(\n", " [f\"{d}__{cl}\" for d, cl in zip(obs_meta[\"drug\"], obs_meta[\"cell_line\"])],\n", " name=\"drug|cell_line\"\n", ")\n", "# Create var DataFrame with feature names\n", "var = pd.DataFrame(index=pd.Index(feature_cols, name=\"features\"))\n", "cVI_collapsed_adata = AnnData(\n", " X=X_concat,\n", " obs=obs_meta,\n", " var=var\n", ")\n" ] }, { "cell_type": "code", "execution_count": 35, "id": "38cdaa61-ae14-4ed0-9ac3-d018626ec1b9", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "AnnData object with n_obs × n_vars = 18950 × 20\n", " obs: 'drug', 'cell_line'" ] }, "execution_count": 35, "metadata": {}, "output_type": "execute_result" } ], "source": [ "cVI_collapsed_adata" ] }, { "cell_type": "markdown", "id": "7c004cad-06a4-4506-bd4b-f175b0822958", "metadata": {}, "source": [ "## Collapse scVI" ] }, { "cell_type": "code", "execution_count": 30, "id": "3768b9a0-a5c5-407f-928d-8bcbec8985af", "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/tmp/ipykernel_51540/1170690059.py:21: FutureWarning: The default of observed=False is deprecated and will be changed to True in a future version of pandas. Pass observed=False to retain current behavior or observed=True to adopt the future default and silence this warning.\n", " .groupby([\"drug\", \"cell_line\"])[feat_cols]\n" ] } ], "source": [ "import numpy as np\n", "import pandas as pd\n", "import scanpy as sc\n", "from anndata import AnnData\n", "\n", "\n", "feat_cols = [f\"drug_emb_{i}\" for i in range(scvi_edata.obsm['X_scVI'].shape[1])]\n", "df_embed = pd.DataFrame(\n", " scvi_edata.obsm['X_scVI'],\n", " index=scvi_edata.obs_names,\n", " columns=feat_cols\n", ")\n", "\n", "df_embed = df_embed.join(\n", " scvi_edata.obs[[\"drug\", \"cell_line\"]]\n", ")\n", "\n", "#Aggregate (mean) per (drug, cell_line)\n", "grp = (\n", " df_embed\n", " .groupby([\"drug\", \"cell_line\"])[feat_cols]\n", " .mean()\n", " .reset_index()\n", ")\n", "\n", "# Extract DMSO_TF (control) per cell_line\n", "ctrl = (\n", " grp[grp[\"drug\"] == \"DMSO_TF\"]\n", " .set_index(\"cell_line\")[feat_cols]\n", " .rename(lambda c: f\"ctrl_{c}\", axis=1)\n", ")\n", "\n", "# Prepare the “drug vs. DMSO” concatenated DataFram# - drop the DMSO rows\n", "df_pairs = grp[grp[\"drug\"] != \"DMSO_TF\"].copy()\n", "\n", "# merge in the control embeddings\n", "df_pairs = df_pairs.merge(\n", " ctrl,\n", " left_on=\"cell_line\",\n", " right_index=True,\n", " how=\"left\"\n", ")\n" ] }, { "cell_type": "code", "execution_count": 31, "id": "3bc8fb79-c00d-47e5-9a71-7600b49cb82a", "metadata": {}, "outputs": [], "source": [ "## Build the new AnnData\n", "# - X is the concatenated vector of [drug_avg, ctrl_avg]\n", "feature_cols = feat_cols + list(ctrl.columns)\n", "X_concat = df_pairs[feature_cols].values\n", "\n", "# - obs is the metadata of each drug-cell pair\n", "obs_meta = df_pairs[[\"drug\", \"cell_line\"]].copy()\n", "obs_meta.index = pd.Index(\n", " [f\"{d}__{cl}\" for d, cl in zip(obs_meta[\"drug\"], obs_meta[\"cell_line\"])],\n", " name=\"drug|cell_line\"\n", ")\n", "# Create var DataFrame with feature names\n", "var = pd.DataFrame(index=pd.Index(feature_cols, name=\"features\"))\n", "scVI_collapsed_adata = AnnData(\n", " X=X_concat,\n", " obs=obs_meta,\n", " var=var\n", ")\n" ] }, { "cell_type": "code", "execution_count": null, "id": "788844e3-fc8c-4552-bbe6-4b76101b393a", "metadata": {}, "outputs": [], "source": [ "scVI_collapsed_adata" ] }, { "cell_type": "code", "execution_count": 32, "id": "ad83ffbc-9528-4d0a-a26b-b2dd7309bd3c", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "AnnData object with n_obs × n_vars = 18950 × 20\n", " obs: 'drug', 'cell_line'" ] }, "execution_count": 32, "metadata": {}, "output_type": "execute_result" } ], "source": [ "scVI_collapsed_adata" ] }, { "cell_type": "code", "execution_count": 39, "id": "bdfabdf8-8d9f-4635-9a72-8866e85765da", "metadata": {}, "outputs": [], "source": [ "scVI_collapsed_adata.obsm = {\n", " 'scVI': scVI_collapsed_adata.X.copy(),\n", " 'cVI': cVI_collapsed_adata.X.copy()\n", "}" ] }, { "cell_type": "code", "execution_count": 40, "id": "bba5a69b-30e0-4733-abd9-ed2b83cfd69e", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "AnnData object with n_obs × n_vars = 18950 × 20\n", " obs: 'drug', 'cell_line'\n", " obsm: 'scVI', 'cVI'" ] }, "execution_count": 40, "metadata": {}, "output_type": "execute_result" } ], "source": [ "scVI_collapsed_adata" ] }, { "cell_type": "code", "execution_count": 42, "id": "df29123a-6b8e-4248-b6a4-1acdfd0715b4", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
| \n", " |
|---|
| features | \n", "
| drug_emb_0 | \n", "
| drug_emb_1 | \n", "
| drug_emb_2 | \n", "
| drug_emb_3 | \n", "
| drug_emb_4 | \n", "
| drug_emb_5 | \n", "
| drug_emb_6 | \n", "
| drug_emb_7 | \n", "
| drug_emb_8 | \n", "
| drug_emb_9 | \n", "
| ctrl_drug_emb_0 | \n", "
| ctrl_drug_emb_1 | \n", "
| ctrl_drug_emb_2 | \n", "
| ctrl_drug_emb_3 | \n", "
| ctrl_drug_emb_4 | \n", "
| ctrl_drug_emb_5 | \n", "
| ctrl_drug_emb_6 | \n", "
| ctrl_drug_emb_7 | \n", "
| ctrl_drug_emb_8 | \n", "
| ctrl_drug_emb_9 | \n", "
| \n", " | sample | \n", "gene_count | \n", "tscp_count | \n", "mread_count | \n", "drugname_drugconc | \n", "drug | \n", "cell_line | \n", "sublibrary | \n", "BARCODE | \n", "pcnt_mito | \n", "S_score | \n", "G2M_score | \n", "phase | \n", "pass_filter | \n", "cell_name | \n", "plate | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BARCODE_SUB_LIB_ID | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
| 95_127_189-lib_877 | \n", "smp_1589 | \n", "608 | \n", "747 | \n", "889 | \n", "[('DMSO_TF', 0.0, 'uM')] | \n", "DMSO_TF | \n", "CVCL_0504 | \n", "lib_877 | \n", "95_127_189 | \n", "0.078983 | \n", "0.009228 | \n", "-0.061905 | \n", "S | \n", "full | \n", "RKO | \n", "plate1 | \n", "
| 95_165_114-lib_850 | \n", "smp_1589 | \n", "1969 | \n", "3486 | \n", "4262 | \n", "[('DMSO_TF', 0.0, 'uM')] | \n", "DMSO_TF | \n", "CVCL_1097 | \n", "lib_850 | \n", "95_165_114 | \n", "0.042742 | \n", "-0.242857 | \n", "-0.258097 | \n", "G1 | \n", "full | \n", "C32 | \n", "plate1 | \n", "
| 96_094_163-lib_898 | \n", "smp_1590 | \n", "703 | \n", "965 | \n", "1186 | \n", "[('DMSO_TF', 0.0, 'uM')] | \n", "DMSO_TF | \n", "CVCL_1717 | \n", "lib_898 | \n", "96_094_163 | \n", "0.078756 | \n", "-0.033607 | \n", "0.000000 | \n", "G2M | \n", "full | \n", "SW1417 | \n", "plate1 | \n", "
| 96_146_131-lib_889 | \n", "smp_1590 | \n", "1511 | \n", "2214 | \n", "2749 | \n", "[('DMSO_TF', 0.0, 'uM')] | \n", "DMSO_TF | \n", "CVCL_0428 | \n", "lib_889 | \n", "96_146_131 | \n", "0.050587 | \n", "-0.091137 | \n", "-0.100962 | \n", "G1 | \n", "full | \n", "MIA PaCa-2 | \n", "plate1 | \n", "
| 96_107_116-lib_898 | \n", "smp_1590 | \n", "581 | \n", "825 | \n", "1002 | \n", "[('DMSO_TF', 0.0, 'uM')] | \n", "DMSO_TF | \n", "CVCL_0334 | \n", "lib_898 | \n", "96_107_116 | \n", "0.080000 | \n", "-0.023923 | \n", "0.033654 | \n", "G2M | \n", "full | \n", "Hs 766T | \n", "plate1 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 48_059_091-lib_2083 | \n", "smp_2790 | \n", "1182 | \n", "1732 | \n", "2060 | \n", "[('Ritonavir', 5.0, 'uM')] | \n", "Ritonavir | \n", "CVCL_0218 | \n", "lib_2083 | \n", "48_059_091 | \n", "0.061201 | \n", "0.531746 | \n", "-0.034631 | \n", "S | \n", "full | \n", "COLO 205 | \n", "plate14 | \n", "
| 54_034_175-lib_2112 | \n", "smp_2796 | \n", "926 | \n", "1213 | \n", "1425 | \n", "[('Lidocaine (hydrochloride)', 5.0, 'uM')] | \n", "Lidocaine (hydrochloride) | \n", "CVCL_1635 | \n", "lib_2112 | \n", "54_034_175 | \n", "0.046167 | \n", "-0.085714 | \n", "-0.066484 | \n", "G1 | \n", "full | \n", "Panc 03.27 | \n", "plate14 | \n", "
| 45_045_054-lib_2080 | \n", "smp_2787 | \n", "727 | \n", "1037 | \n", "1247 | \n", "[('Vilanterol', 5.0, 'uM')] | \n", "Vilanterol | \n", "CVCL_0320 | \n", "lib_2080 | \n", "45_045_054 | \n", "0.101254 | \n", "-0.087649 | \n", "-0.066986 | \n", "G1 | \n", "full | \n", "HT-29 | \n", "plate14 | \n", "
| 01_064_159-lib_2069 | \n", "smp_2743 | \n", "1668 | \n", "2501 | \n", "2966 | \n", "[('8-Hydroxyquinoline', 5.0, 'uM')] | \n", "8-Hydroxyquinoline | \n", "CVCL_1547 | \n", "lib_2069 | \n", "01_064_159 | \n", "0.036385 | \n", "0.409524 | \n", "0.149267 | \n", "S | \n", "full | \n", "NCI-H23 | \n", "plate14 | \n", "
| 21_190_144-lib_2098 | \n", "smp_2763 | \n", "1982 | \n", "3346 | \n", "3881 | \n", "[('Megestrol', 5.0, 'uM')] | \n", "Megestrol | \n", "CVCL_1495 | \n", "lib_2098 | \n", "21_190_144 | \n", "0.045129 | \n", "-0.181932 | \n", "-0.127839 | \n", "G1 | \n", "full | \n", "NCI-H1792 | \n", "plate14 | \n", "
4780 rows × 16 columns
\n", "| \n", " | drug | \n", "cell_line | \n", "train_val_test_split | \n", "
|---|---|---|---|
| BARCODE_SUB_LIB_ID | \n", "\n", " | \n", " | \n", " |
| 38_132_056-lib_2077 | \n", "Resveratrol | \n", "CVCL_1693 | \n", "test | \n", "
| 56_171_034-lib_2099 | \n", "Mitoxantrone (dihydrochloride) | \n", "CVCL_1055 | \n", "test | \n", "
| 10_086_185-lib_2089 | \n", "Palmatine (chloride) | \n", "CVCL_1381 | \n", "test | \n", "
| 41_020_157-lib_2143 | \n", "Tofacitinib (citrate) | \n", "CVCL_0359 | \n", "test | \n", "
| 18_057_171-lib_2076 | \n", "Pyridoxine | \n", "CVCL_1097 | \n", "test | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "
| 49_098_178-lib_2158 | \n", "Pentamidine (isethionate) | \n", "CVCL_0359 | \n", "val | \n", "
| 58_111_017-lib_2064 | \n", "Busulfan | \n", "CVCL_0359 | \n", "val | \n", "
| 03_046_142-lib_2091 | \n", "Trifluridine | \n", "CVCL_0359 | \n", "val | \n", "
| 55_191_132-lib_2102 | \n", "Demeclocycline | \n", "CVCL_0359 | \n", "val | \n", "
| 34_186_018-lib_2073 | \n", "Fluvoxamine (maleate) | \n", "CVCL_0359 | \n", "val | \n", "
482620 rows × 3 columns
\n", "| \n", " | sample | \n", "species | \n", "gene_count | \n", "tscp_count | \n", "mread_count | \n", "bc1_wind | \n", "bc2_wind | \n", "bc3_wind | \n", "bc1_well | \n", "bc2_well | \n", "... | \n", "DIFF.LLK.SNG.DBL | \n", "sublibrary | \n", "BARCODE | \n", "pcnt_mito | \n", "S_score | \n", "G2M_score | \n", "phase | \n", "cell_line_orig | \n", "pass_filter | \n", "cell_name | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BARCODE_SUB_LIB_ID | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
| 75_040_049-lib_2604 | \n", "smp_1761 | \n", "hg38 | \n", "1099 | \n", "1530 | \n", "1791 | \n", "75 | \n", "40 | \n", "49 | \n", "G3 | \n", "D4 | \n", "... | \n", "-1.70 | \n", "lib_2604 | \n", "75_040_049 | \n", "0.054902 | \n", "0.305255 | \n", "0.048399 | \n", "S | \n", "CVCL_0359 | \n", "full | \n", "J82 | \n", "
| 75_108_162-lib_1051 | \n", "smp_1761 | \n", "hg38 | \n", "1016 | \n", "1302 | \n", "1565 | \n", "75 | \n", "108 | \n", "162 | \n", "G3 | \n", "p2.A12 | \n", "... | \n", "1.83 | \n", "lib_1051 | \n", "75_108_162 | \n", "0.033026 | \n", "-0.047998 | \n", "0.404762 | \n", "G2M | \n", "CVCL_0023 | \n", "full | \n", "A549 | \n", "
| 32_130_058-lib_1047 | \n", "smp_1718 | \n", "hg38 | \n", "1677 | \n", "2511 | \n", "2954 | \n", "32 | \n", "130 | \n", "58 | \n", "C8 | \n", "p2.C10 | \n", "... | \n", "10.49 | \n", "lib_1047 | \n", "32_130_058 | \n", "0.092792 | \n", "0.150794 | \n", "0.391392 | \n", "G2M | \n", "CVCL_0480 | \n", "full | \n", "PANC-1 | \n", "
| 88_105_132-lib_1033 | \n", "smp_1774 | \n", "hg38 | \n", "616 | \n", "788 | \n", "927 | \n", "88 | \n", "105 | \n", "132 | \n", "H4 | \n", "p2.A9 | \n", "... | \n", "0.85 | \n", "lib_1033 | \n", "88_105_132 | \n", "0.022843 | \n", "-0.056000 | \n", "-0.033150 | \n", "G1 | \n", "CVCL_1285 | \n", "full | \n", "HOP62 | \n", "
| 45_003_187-lib_1099 | \n", "smp_1731 | \n", "hg38 | \n", "1022 | \n", "1397 | \n", "1679 | \n", "45 | \n", "3 | \n", "187 | \n", "D9 | \n", "A3 | \n", "... | \n", "1.95 | \n", "lib_1099 | \n", "45_003_187 | \n", "0.078740 | \n", "0.059524 | \n", "-0.008974 | \n", "S | \n", "CVCL_0131 | \n", "full | \n", "A-172 | \n", "
5 rows × 42 columns
\n", "| \n", " | sample | \n", "drugname_drugconc | \n", "drug | \n", "n_cells | \n", "tscp_count | \n", "plate | \n", "Cell_Name_Vevo | \n", "Cell_ID_Cellosaur | \n", "
|---|---|---|---|---|---|---|---|---|
| 0 | \n", "smp_1975 | \n", "[('8-Hydroxyquinoline', 5.0, 'uM')] | \n", "8-Hydroxyquinoline | \n", "3076 | \n", "6686156.0 | \n", "6 | \n", "A549 | \n", "CVCL_0023 | \n", "
| 1 | \n", "smp_1975 | \n", "[('8-Hydroxyquinoline', 5.0, 'uM')] | \n", "8-Hydroxyquinoline | \n", "1505 | \n", "4744833.0 | \n", "6 | \n", "HS-578T | \n", "CVCL_0332 | \n", "
| 2 | \n", "smp_1975 | \n", "[('8-Hydroxyquinoline', 5.0, 'uM')] | \n", "8-Hydroxyquinoline | \n", "1700 | \n", "2494504.0 | \n", "6 | \n", "HCT15 | \n", "CVCL_0292 | \n", "
| 3 | \n", "smp_1975 | \n", "[('8-Hydroxyquinoline', 5.0, 'uM')] | \n", "8-Hydroxyquinoline | \n", "3560 | \n", "8923357.0 | \n", "6 | \n", "HOP62 | \n", "CVCL_1285 | \n", "
| 4 | \n", "smp_1975 | \n", "[('8-Hydroxyquinoline', 5.0, 'uM')] | \n", "8-Hydroxyquinoline | \n", "1876 | \n", "4676765.0 | \n", "6 | \n", "SK-MEL-2 | \n", "CVCL_0069 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 4795-11 | \n", "smp_2742 | \n", "[('Ribociclib', 0.05, 'uM')] | \n", "Ribociclib | \n", "1412 | \n", "2102723.0 | \n", "13 | \n", "hTERT-HPNE | \n", "CVCL_C466 | \n", "
| 4796-10 | \n", "smp_2742 | \n", "[('Ribociclib', 0.05, 'uM')] | \n", "Ribociclib | \n", "1632 | \n", "3507957.0 | \n", "13 | \n", "NCI-H23 | \n", "CVCL_1547 | \n", "
| 4797-10 | \n", "smp_2742 | \n", "[('Ribociclib', 0.05, 'uM')] | \n", "Ribociclib | \n", "2225 | \n", "5246475.0 | \n", "13 | \n", "NCI-H1792 | \n", "CVCL_1495 | \n", "
| 4798-10 | \n", "smp_2742 | \n", "[('Ribociclib', 0.05, 'uM')] | \n", "Ribociclib | \n", "31 | \n", "31648.0 | \n", "13 | \n", "NCI-H2122 | \n", "CVCL_1531 | \n", "
| 4799-10 | \n", "smp_2742 | \n", "[('Ribociclib', 0.05, 'uM')] | \n", "Ribociclib | \n", "1319 | \n", "3911514.0 | \n", "13 | \n", "NCI-H2030 | \n", "CVCL_1517 | \n", "
67018 rows × 8 columns
\n", "| \n", " | sample | \n", "drugname_drugconc | \n", "drug | \n", "n_cells | \n", "tscp_count | \n", "plate | \n", "Cell_Name_Vevo | \n", "Cell_ID_Cellosaur | \n", "
|---|---|---|---|---|---|---|---|---|
| 0 | \n", "smp_1975 | \n", "[('8-Hydroxyquinoline', 5.0, 'uM')] | \n", "8-Hydroxyquinoline | \n", "3076 | \n", "6686156.0 | \n", "6 | \n", "A549 | \n", "CVCL_0023 | \n", "
| 1 | \n", "smp_1975 | \n", "[('8-Hydroxyquinoline', 5.0, 'uM')] | \n", "8-Hydroxyquinoline | \n", "1505 | \n", "4744833.0 | \n", "6 | \n", "HS-578T | \n", "CVCL_0332 | \n", "
| 2 | \n", "smp_1975 | \n", "[('8-Hydroxyquinoline', 5.0, 'uM')] | \n", "8-Hydroxyquinoline | \n", "1700 | \n", "2494504.0 | \n", "6 | \n", "HCT15 | \n", "CVCL_0292 | \n", "
| 3 | \n", "smp_1975 | \n", "[('8-Hydroxyquinoline', 5.0, 'uM')] | \n", "8-Hydroxyquinoline | \n", "3560 | \n", "8923357.0 | \n", "6 | \n", "HOP62 | \n", "CVCL_1285 | \n", "
| 4 | \n", "smp_1975 | \n", "[('8-Hydroxyquinoline', 5.0, 'uM')] | \n", "8-Hydroxyquinoline | \n", "1876 | \n", "4676765.0 | \n", "6 | \n", "SK-MEL-2 | \n", "CVCL_0069 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 3895-13 | \n", "smp_2724 | \n", "[('Plicamycin', 0.5, 'uM')] | \n", "Plicamycin | \n", "1188 | \n", "1869984.0 | \n", "13 | \n", "hTERT-HPNE | \n", "CVCL_C466 | \n", "
| 3896-13 | \n", "smp_2724 | \n", "[('Plicamycin', 0.5, 'uM')] | \n", "Plicamycin | \n", "1507 | \n", "3413185.0 | \n", "13 | \n", "NCI-H23 | \n", "CVCL_1547 | \n", "
| 3897-13 | \n", "smp_2724 | \n", "[('Plicamycin', 0.5, 'uM')] | \n", "Plicamycin | \n", "1877 | \n", "4635019.0 | \n", "13 | \n", "NCI-H1792 | \n", "CVCL_1495 | \n", "
| 3898-13 | \n", "smp_2724 | \n", "[('Plicamycin', 0.5, 'uM')] | \n", "Plicamycin | \n", "28 | \n", "31629.0 | \n", "13 | \n", "NCI-H2122 | \n", "CVCL_1531 | \n", "
| 3899-13 | \n", "smp_2724 | \n", "[('Plicamycin', 0.5, 'uM')] | \n", "Plicamycin | \n", "1207 | \n", "3569081.0 | \n", "13 | \n", "NCI-H2030 | \n", "CVCL_1517 | \n", "
25895 rows × 8 columns
\n", "| \n", " | sample | \n", "drugname_drugconc | \n", "drug | \n", "n_cells | \n", "tscp_count | \n", "plate | \n", "Cell_Name_Vevo | \n", "Cell_ID_Cellosaur | \n", "
|---|---|---|---|---|---|---|---|---|
| 0-1 | \n", "smp_2743 | \n", "[('8-Hydroxyquinoline', 5.0, 'uM')] | \n", "8-Hydroxyquinoline | \n", "1549 | \n", "2972368.0 | \n", "14 | \n", "A549 | \n", "CVCL_0023 | \n", "
| 1-1 | \n", "smp_2743 | \n", "[('8-Hydroxyquinoline', 5.0, 'uM')] | \n", "8-Hydroxyquinoline | \n", "895 | \n", "2426161.0 | \n", "14 | \n", "HS-578T | \n", "CVCL_0332 | \n", "
| 2-1 | \n", "smp_2743 | \n", "[('8-Hydroxyquinoline', 5.0, 'uM')] | \n", "8-Hydroxyquinoline | \n", "716 | \n", "1007837.0 | \n", "14 | \n", "HCT15 | \n", "CVCL_0292 | \n", "
| 3-1 | \n", "smp_2743 | \n", "[('8-Hydroxyquinoline', 5.0, 'uM')] | \n", "8-Hydroxyquinoline | \n", "1886 | \n", "4019130.0 | \n", "14 | \n", "HOP62 | \n", "CVCL_1285 | \n", "
| 4-1 | \n", "smp_2743 | \n", "[('8-Hydroxyquinoline', 5.0, 'uM')] | \n", "8-Hydroxyquinoline | \n", "845 | \n", "1851405.0 | \n", "14 | \n", "SK-MEL-2 | \n", "CVCL_0069 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 4791-1 | \n", "smp_2838 | \n", "[('DMSO_TF', 0.0, 'uM')] | \n", "DMSO_TF | \n", "1268 | \n", "2070209.0 | \n", "14 | \n", "hTERT-HPNE | \n", "CVCL_C466 | \n", "
| 4792-1 | \n", "smp_2838 | \n", "[('DMSO_TF', 0.0, 'uM')] | \n", "DMSO_TF | \n", "1274 | \n", "2984503.0 | \n", "14 | \n", "NCI-H23 | \n", "CVCL_1547 | \n", "
| 4793-1 | \n", "smp_2838 | \n", "[('DMSO_TF', 0.0, 'uM')] | \n", "DMSO_TF | \n", "938 | \n", "2223218.0 | \n", "14 | \n", "NCI-H1792 | \n", "CVCL_1495 | \n", "
| 4794-1 | \n", "smp_2838 | \n", "[('DMSO_TF', 0.0, 'uM')] | \n", "DMSO_TF | \n", "17 | \n", "22536.0 | \n", "14 | \n", "NCI-H2122 | \n", "CVCL_1531 | \n", "
| 4795-1 | \n", "smp_2838 | \n", "[('DMSO_TF', 0.0, 'uM')] | \n", "DMSO_TF | \n", "1661 | \n", "6106461.0 | \n", "14 | \n", "NCI-H2030 | \n", "CVCL_1517 | \n", "
4696 rows × 8 columns
\n", "