Untitled-Copy1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sample</th>\n",
       "      <th>HBA_721_B_lymphoblasts</th>\n",
       "      <th>HBA_Adipocyte</th>\n",
       "      <th>HBA_AdrenalCortex</th>\n",
       "      <th>HBA_Adrenalgland</th>\n",
       "      <th>HBA_Amygdala</th>\n",
       "      <th>HBA_Appendix</th>\n",
       "      <th>HBA_AtrioventricularNode</th>\n",
       "      <th>HBA_BDCA4+_DentriticCells</th>\n",
       "      <th>HBA_Bonemarrow</th>\n",
       "      <th>...</th>\n",
       "      <th>WRS_Macrophage</th>\n",
       "      <th>WRS_Monocyte</th>\n",
       "      <th>WRS_Neutrophil</th>\n",
       "      <th>WRS_NK_cell</th>\n",
       "      <th>WRS_NK_T-cell</th>\n",
       "      <th>WRS_Platelet</th>\n",
       "      <th>WRS_Regulatory_T-cell</th>\n",
       "      <th>WRS_Reticulocyte</th>\n",
       "      <th>WRS_Subcutaneous_adipose</th>\n",
       "      <th>WRS_Vascular_endothelial_cell</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>GTEX.1117F.0426.SM.5EGHI</td>\n",
       "      <td>0.292699</td>\n",
       "      <td>0.743942</td>\n",
       "      <td>0.484423</td>\n",
       "      <td>0.455176</td>\n",
       "      <td>0.250221</td>\n",
       "      <td>1.042895</td>\n",
       "      <td>0.910704</td>\n",
       "      <td>0.244342</td>\n",
       "      <td>0.222023</td>\n",
       "      <td>...</td>\n",
       "      <td>0.251322</td>\n",
       "      <td>0.272035</td>\n",
       "      <td>0.140296</td>\n",
       "      <td>0.153715</td>\n",
       "      <td>0.073306</td>\n",
       "      <td>0.160703</td>\n",
       "      <td>0.312609</td>\n",
       "      <td>0.066788</td>\n",
       "      <td>0.564330</td>\n",
       "      <td>0.464354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>GTEX.1117F.0626.SM.5N9CS</td>\n",
       "      <td>0.550777</td>\n",
       "      <td>1.760130</td>\n",
       "      <td>0.858623</td>\n",
       "      <td>0.867942</td>\n",
       "      <td>0.549833</td>\n",
       "      <td>2.119385</td>\n",
       "      <td>1.682652</td>\n",
       "      <td>0.682672</td>\n",
       "      <td>0.447082</td>\n",
       "      <td>...</td>\n",
       "      <td>0.531806</td>\n",
       "      <td>0.620645</td>\n",
       "      <td>0.300208</td>\n",
       "      <td>0.188665</td>\n",
       "      <td>0.125979</td>\n",
       "      <td>0.175910</td>\n",
       "      <td>0.452133</td>\n",
       "      <td>0.108618</td>\n",
       "      <td>1.253605</td>\n",
       "      <td>0.927356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>GTEX.1117F.0726.SM.5GIEN</td>\n",
       "      <td>0.578434</td>\n",
       "      <td>1.458891</td>\n",
       "      <td>0.831372</td>\n",
       "      <td>0.840183</td>\n",
       "      <td>0.539575</td>\n",
       "      <td>1.885478</td>\n",
       "      <td>1.526229</td>\n",
       "      <td>0.775017</td>\n",
       "      <td>0.463803</td>\n",
       "      <td>...</td>\n",
       "      <td>0.469166</td>\n",
       "      <td>0.512638</td>\n",
       "      <td>0.230745</td>\n",
       "      <td>0.199397</td>\n",
       "      <td>0.123494</td>\n",
       "      <td>0.178303</td>\n",
       "      <td>0.427672</td>\n",
       "      <td>0.162718</td>\n",
       "      <td>0.904982</td>\n",
       "      <td>0.843205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>GTEX.1117F.1326.SM.5EGHH</td>\n",
       "      <td>0.775723</td>\n",
       "      <td>1.664025</td>\n",
       "      <td>0.945667</td>\n",
       "      <td>0.982146</td>\n",
       "      <td>0.372426</td>\n",
       "      <td>2.118096</td>\n",
       "      <td>1.418428</td>\n",
       "      <td>1.106873</td>\n",
       "      <td>0.672771</td>\n",
       "      <td>...</td>\n",
       "      <td>0.576916</td>\n",
       "      <td>0.587446</td>\n",
       "      <td>0.311065</td>\n",
       "      <td>0.313743</td>\n",
       "      <td>0.120433</td>\n",
       "      <td>0.155374</td>\n",
       "      <td>0.458597</td>\n",
       "      <td>0.073740</td>\n",
       "      <td>1.076636</td>\n",
       "      <td>0.959745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>GTEX.1117F.2426.SM.5EGGH</td>\n",
       "      <td>0.531634</td>\n",
       "      <td>1.227009</td>\n",
       "      <td>0.802531</td>\n",
       "      <td>0.838391</td>\n",
       "      <td>0.498293</td>\n",
       "      <td>1.969158</td>\n",
       "      <td>1.268496</td>\n",
       "      <td>0.582007</td>\n",
       "      <td>0.340974</td>\n",
       "      <td>...</td>\n",
       "      <td>0.511841</td>\n",
       "      <td>0.537911</td>\n",
       "      <td>0.279515</td>\n",
       "      <td>0.241279</td>\n",
       "      <td>0.177636</td>\n",
       "      <td>0.166834</td>\n",
       "      <td>0.411554</td>\n",
       "      <td>0.079151</td>\n",
       "      <td>0.733948</td>\n",
       "      <td>0.754756</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 137 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     sample  HBA_721_B_lymphoblasts  HBA_Adipocyte  \\\n",
       "0  GTEX.1117F.0426.SM.5EGHI                0.292699       0.743942   \n",
       "1  GTEX.1117F.0626.SM.5N9CS                0.550777       1.760130   \n",
       "2  GTEX.1117F.0726.SM.5GIEN                0.578434       1.458891   \n",
       "3  GTEX.1117F.1326.SM.5EGHH                0.775723       1.664025   \n",
       "4  GTEX.1117F.2426.SM.5EGGH                0.531634       1.227009   \n",
       "\n",
       "   HBA_AdrenalCortex  HBA_Adrenalgland  HBA_Amygdala  HBA_Appendix  \\\n",
       "0           0.484423          0.455176      0.250221      1.042895   \n",
       "1           0.858623          0.867942      0.549833      2.119385   \n",
       "2           0.831372          0.840183      0.539575      1.885478   \n",
       "3           0.945667          0.982146      0.372426      2.118096   \n",
       "4           0.802531          0.838391      0.498293      1.969158   \n",
       "\n",
       "   HBA_AtrioventricularNode  HBA_BDCA4+_DentriticCells  HBA_Bonemarrow  \\\n",
       "0                  0.910704                   0.244342        0.222023   \n",
       "1                  1.682652                   0.682672        0.447082   \n",
       "2                  1.526229                   0.775017        0.463803   \n",
       "3                  1.418428                   1.106873        0.672771   \n",
       "4                  1.268496                   0.582007        0.340974   \n",
       "\n",
       "               ...                WRS_Macrophage  WRS_Monocyte  \\\n",
       "0              ...                      0.251322      0.272035   \n",
       "1              ...                      0.531806      0.620645   \n",
       "2              ...                      0.469166      0.512638   \n",
       "3              ...                      0.576916      0.587446   \n",
       "4              ...                      0.511841      0.537911   \n",
       "\n",
       "   WRS_Neutrophil  WRS_NK_cell  WRS_NK_T-cell  WRS_Platelet  \\\n",
       "0        0.140296     0.153715       0.073306      0.160703   \n",
       "1        0.300208     0.188665       0.125979      0.175910   \n",
       "2        0.230745     0.199397       0.123494      0.178303   \n",
       "3        0.311065     0.313743       0.120433      0.155374   \n",
       "4        0.279515     0.241279       0.177636      0.166834   \n",
       "\n",
       "   WRS_Regulatory_T-cell  WRS_Reticulocyte  WRS_Subcutaneous_adipose  \\\n",
       "0               0.312609          0.066788                  0.564330   \n",
       "1               0.452133          0.108618                  1.253605   \n",
       "2               0.427672          0.162718                  0.904982   \n",
       "3               0.458597          0.073740                  1.076636   \n",
       "4               0.411554          0.079151                  0.733948   \n",
       "\n",
       "   WRS_Vascular_endothelial_cell  \n",
       "0                       0.464354  \n",
       "1                       0.927356  \n",
       "2                       0.843205  \n",
       "3                       0.959745  \n",
       "4                       0.754756  \n",
       "\n",
       "[5 rows x 137 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd \n",
    "data_savant = pd.read_csv(\"GTEX_SaVanT.txt\",sep='\\t') \n",
    "data_savant.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>fileName</th>\n",
       "      <th>sample</th>\n",
       "      <th>individual</th>\n",
       "      <th>tissue</th>\n",
       "      <th>raw.single.reads</th>\n",
       "      <th>nIGH</th>\n",
       "      <th>nIGK</th>\n",
       "      <th>nIGL</th>\n",
       "      <th>nTCRA</th>\n",
       "      <th>...</th>\n",
       "      <th>alphaTCRG</th>\n",
       "      <th>CPM.IGH</th>\n",
       "      <th>CPM.IGK</th>\n",
       "      <th>CPM.IGL</th>\n",
       "      <th>titration.IGH</th>\n",
       "      <th>titration.IGK</th>\n",
       "      <th>titration.IGL</th>\n",
       "      <th>immune.diverity.IGH</th>\n",
       "      <th>immune.diverity.IGK</th>\n",
       "      <th>immune.diverity.IGL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>G16788.GTEX-QDVJ-0426.3</td>\n",
       "      <td>GTEX-QDVJ-0426-SM-2I5FW</td>\n",
       "      <td>GTEX-QDVJ</td>\n",
       "      <td>Heart - Left Ventricle</td>\n",
       "      <td>135986666</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>382</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.005148</td>\n",
       "      <td>0.002206</td>\n",
       "      <td>0.002941</td>\n",
       "      <td>0.057359</td>\n",
       "      <td>0.015443</td>\n",
       "      <td>0.016913</td>\n",
       "      <td>1.383440</td>\n",
       "      <td>0.780131</td>\n",
       "      <td>0.860559</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>G16790.GTEX-QEG4-0006.3</td>\n",
       "      <td>GTEX-QEG4-0006-SM-2I5FY</td>\n",
       "      <td>GTEX-QEG4</td>\n",
       "      <td>Whole Blood</td>\n",
       "      <td>138173333</td>\n",
       "      <td>128</td>\n",
       "      <td>25</td>\n",
       "      <td>24</td>\n",
       "      <td>511</td>\n",
       "      <td>...</td>\n",
       "      <td>0.21677</td>\n",
       "      <td>0.092637</td>\n",
       "      <td>0.018093</td>\n",
       "      <td>0.017369</td>\n",
       "      <td>0.315546</td>\n",
       "      <td>0.730242</td>\n",
       "      <td>0.342324</td>\n",
       "      <td>4.665596</td>\n",
       "      <td>1.461433</td>\n",
       "      <td>2.363443</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>G16791.GTEX-QEG5-0006.3</td>\n",
       "      <td>GTEX-QEG5-0006-SM-2I5FZ</td>\n",
       "      <td>GTEX-QEG5</td>\n",
       "      <td>Whole Blood</td>\n",
       "      <td>135413333</td>\n",
       "      <td>194</td>\n",
       "      <td>20</td>\n",
       "      <td>25</td>\n",
       "      <td>415</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.143265</td>\n",
       "      <td>0.014770</td>\n",
       "      <td>0.018462</td>\n",
       "      <td>0.413549</td>\n",
       "      <td>0.850729</td>\n",
       "      <td>0.619584</td>\n",
       "      <td>5.104068</td>\n",
       "      <td>1.275978</td>\n",
       "      <td>2.251508</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>G16794.GTEX-QLQ7-0526.3</td>\n",
       "      <td>GTEX-QLQ7-0526-SM-2I5G3</td>\n",
       "      <td>GTEX-QLQ7</td>\n",
       "      <td>Heart - Left Ventricle</td>\n",
       "      <td>160000000</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>443</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.002500</td>\n",
       "      <td>0.001875</td>\n",
       "      <td>0.002500</td>\n",
       "      <td>0.035000</td>\n",
       "      <td>0.005000</td>\n",
       "      <td>0.008750</td>\n",
       "      <td>0.564716</td>\n",
       "      <td>1.039721</td>\n",
       "      <td>1.153742</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>G16802.GTEX-OXRN-0011-R10A.3</td>\n",
       "      <td>GTEX-OXRN-0011-R10A-SM-2I5GC</td>\n",
       "      <td>GTEX-OXRN</td>\n",
       "      <td>Brain - Frontal Cortex (BA9)</td>\n",
       "      <td>150093333</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>399</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.001333</td>\n",
       "      <td>0.001333</td>\n",
       "      <td>0.000666</td>\n",
       "      <td>0.011326</td>\n",
       "      <td>0.005996</td>\n",
       "      <td>0.001333</td>\n",
       "      <td>0.465999</td>\n",
       "      <td>0.529706</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 36 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0                      fileName                        sample  \\\n",
       "0           1       G16788.GTEX-QDVJ-0426.3       GTEX-QDVJ-0426-SM-2I5FW   \n",
       "1           2       G16790.GTEX-QEG4-0006.3       GTEX-QEG4-0006-SM-2I5FY   \n",
       "2           3       G16791.GTEX-QEG5-0006.3       GTEX-QEG5-0006-SM-2I5FZ   \n",
       "3           4       G16794.GTEX-QLQ7-0526.3       GTEX-QLQ7-0526-SM-2I5G3   \n",
       "4           5  G16802.GTEX-OXRN-0011-R10A.3  GTEX-OXRN-0011-R10A-SM-2I5GC   \n",
       "\n",
       "  individual                        tissue  raw.single.reads  nIGH  nIGK  \\\n",
       "0  GTEX-QDVJ        Heart - Left Ventricle         135986666     7     3   \n",
       "1  GTEX-QEG4                   Whole Blood         138173333   128    25   \n",
       "2  GTEX-QEG5                   Whole Blood         135413333   194    20   \n",
       "3  GTEX-QLQ7        Heart - Left Ventricle         160000000     4     3   \n",
       "4  GTEX-OXRN  Brain - Frontal Cortex (BA9)         150093333     2     2   \n",
       "\n",
       "   nIGL  nTCRA         ...           alphaTCRG   CPM.IGH   CPM.IGK   CPM.IGL  \\\n",
       "0     4    382         ...             0.00000  0.005148  0.002206  0.002941   \n",
       "1    24    511         ...             0.21677  0.092637  0.018093  0.017369   \n",
       "2    25    415         ...             0.00000  0.143265  0.014770  0.018462   \n",
       "3     4    443         ...             0.00000  0.002500  0.001875  0.002500   \n",
       "4     1    399         ...             0.00000  0.001333  0.001333  0.000666   \n",
       "\n",
       "   titration.IGH  titration.IGK  titration.IGL  immune.diverity.IGH  \\\n",
       "0       0.057359       0.015443       0.016913             1.383440   \n",
       "1       0.315546       0.730242       0.342324             4.665596   \n",
       "2       0.413549       0.850729       0.619584             5.104068   \n",
       "3       0.035000       0.005000       0.008750             0.564716   \n",
       "4       0.011326       0.005996       0.001333             0.465999   \n",
       "\n",
       "   immune.diverity.IGK  immune.diverity.IGL  \n",
       "0             0.780131             0.860559  \n",
       "1             1.461433             2.363443  \n",
       "2             1.275978             2.251508  \n",
       "3             1.039721             1.153742  \n",
       "4             0.529706             0.000000  \n",
       "\n",
       "[5 rows x 36 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "data_imrep=pd.read_csv(\"TheAIR.CDR3.csv\")\n",
    "data_imrep.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>fileName</th>\n",
       "      <th>sample</th>\n",
       "      <th>individual</th>\n",
       "      <th>tissue</th>\n",
       "      <th>raw.single.reads</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>G56254.GTEX-13112-0011-R5b.2</td>\n",
       "      <td>GTEX-13112-0011-R5b-SM-5DUV8</td>\n",
       "      <td>GTEX-13112</td>\n",
       "      <td>Brain - Caudate (basal ganglia)</td>\n",
       "      <td>70066666</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>G62434.GTEX-14E7W-0006.2</td>\n",
       "      <td>GTEX-14E7W-0006-SM-5N9GG</td>\n",
       "      <td>GTEX-14E7W</td>\n",
       "      <td>Whole Blood</td>\n",
       "      <td>94613333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>G25695.GTEX-NFK9-0326-SM-3MJGV.1</td>\n",
       "      <td>GTEX-NFK9-0326-SM-3MJGV</td>\n",
       "      <td>GTEX-NFK9</td>\n",
       "      <td>Adipose - Subcutaneous</td>\n",
       "      <td>114480000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>G65595.GTEX-13SLW-0011-R8b.3</td>\n",
       "      <td>GTEX-13SLW-0011-R8b-SM-5SI64</td>\n",
       "      <td>GTEX-13SLW</td>\n",
       "      <td>Brain - Hypothalamus</td>\n",
       "      <td>76933333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>G63111.GTEX-13X6J-0011-R6a.2</td>\n",
       "      <td>GTEX-13X6J-0011-R6a-SM-5PNUB</td>\n",
       "      <td>GTEX-13X6J</td>\n",
       "      <td>Brain - Nucleus accumbens (basal ganglia)</td>\n",
       "      <td>88933333</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           fileName                        sample  individual  \\\n",
       "0      G56254.GTEX-13112-0011-R5b.2  GTEX-13112-0011-R5b-SM-5DUV8  GTEX-13112   \n",
       "1          G62434.GTEX-14E7W-0006.2      GTEX-14E7W-0006-SM-5N9GG  GTEX-14E7W   \n",
       "2  G25695.GTEX-NFK9-0326-SM-3MJGV.1       GTEX-NFK9-0326-SM-3MJGV   GTEX-NFK9   \n",
       "3      G65595.GTEX-13SLW-0011-R8b.3  GTEX-13SLW-0011-R8b-SM-5SI64  GTEX-13SLW   \n",
       "4      G63111.GTEX-13X6J-0011-R6a.2  GTEX-13X6J-0011-R6a-SM-5PNUB  GTEX-13X6J   \n",
       "\n",
       "                                      tissue  raw.single.reads  \n",
       "0            Brain - Caudate (basal ganglia)          70066666  \n",
       "1                                Whole Blood          94613333  \n",
       "2                     Adipose - Subcutaneous         114480000  \n",
       "3                       Brain - Hypothalamus          76933333  \n",
       "4  Brain - Nucleus accumbens (basal ganglia)          88933333  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "metadata=pd.read_csv('./metadata/curated.metadata.RNASeq.samples.8555.csv')\n",
    "metadata.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sample</th>\n",
       "      <th>HBA_721_B_lymphoblasts</th>\n",
       "      <th>HBA_Adipocyte</th>\n",
       "      <th>HBA_AdrenalCortex</th>\n",
       "      <th>HBA_Adrenalgland</th>\n",
       "      <th>HBA_Amygdala</th>\n",
       "      <th>HBA_Appendix</th>\n",
       "      <th>HBA_AtrioventricularNode</th>\n",
       "      <th>HBA_BDCA4+_DentriticCells</th>\n",
       "      <th>HBA_Bonemarrow</th>\n",
       "      <th>...</th>\n",
       "      <th>WRS_NK_T-cell</th>\n",
       "      <th>WRS_Platelet</th>\n",
       "      <th>WRS_Regulatory_T-cell</th>\n",
       "      <th>WRS_Reticulocyte</th>\n",
       "      <th>WRS_Subcutaneous_adipose</th>\n",
       "      <th>WRS_Vascular_endothelial_cell</th>\n",
       "      <th>fileName</th>\n",
       "      <th>individual</th>\n",
       "      <th>tissue</th>\n",
       "      <th>raw.single.reads</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>0 rows × 141 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [sample, HBA_721_B_lymphoblasts, HBA_Adipocyte, HBA_AdrenalCortex, HBA_Adrenalgland, HBA_Amygdala, HBA_Appendix, HBA_AtrioventricularNode, HBA_BDCA4+_DentriticCells, HBA_Bonemarrow, HBA_BronchialEpithelialCells, HBA_CardiacMyocytes, HBA_Caudatenucleus, HBA_CD105+_Endothelial, HBA_CD14+_Monocytes, HBA_CD19+_BCells(neg, HBA_CD33+_Myeloid, HBA_CD34+, HBA_CD4+_Tcells, HBA_CD56+_NKCells, HBA_CD71+_EarlyErythroid, HBA_CD8+_Tcells, HBA_Cerebellum, HBA_CerebellumPeduncles, HBA_CiliaryGanglion, HBA_CingulateCortex, HBA_colon, HBA_Colorectaladenocarcinoma, HBA_DorsalRootGanglion, HBA_Fetalbrain, HBA_Fetalliver, HBA_Fetallung, HBA_FetalThyroid, HBA_GlobusPallidus, HBA_Heart, HBA_Hypothalamus, HBA_Kidney, HBA_Leukemia_chronicMyelogenousK-562, HBA_Leukemia_promyelocytic-HL-60, HBA_Leukemialymphoblastic(MOLT-4), HBA_Liver, HBA_Lung, HBA_Lymphnode, HBA_Lymphoma_burkitts(Daudi), HBA_Lymphoma_burkitts(Raji), HBA_MedullaOblongata, HBA_OccipitalLobe, HBA_OlfactoryBulb, HBA_Ovary, HBA_Pancreas, HBA_PancreaticIslet, HBA_ParietalLobe, HBA_pineal_day, HBA_pineal_night, HBA_Pituitary, HBA_Placenta, HBA_Pons, HBA_PrefrontalCortex, HBA_Prostate, HBA_retina, HBA_Salivarygland, HBA_SkeletalMuscle, HBA_Skin, HBA_small_intestine, HBA_SmoothMuscle, HBA_Spinalcord, HBA_SubthalamicNucleus, HBA_SuperiorCervicalGanglion, HBA_TemporalLobe, HBA_Testis, HBA_TestisGermCell, HBA_TestisIntersitial, HBA_TestisLeydigCell, HBA_TestisSeminiferousTubule, HBA_Thalamus, HBA_Thymus, HBA_Thyroid, HBA_Tongue, HBA_Tonsil, HBA_Trachea, HBA_TrigeminalGanglion, HBA_Uterus, HBA_UterusCorpus, HBA_WholeBlood, HBA_Wholebrain, HPCA_Adipocytes, HPCA_B_cells, HPCA_Bronchial_Epithelial_cells, HPCA_CD34+, HPCA_Dendritic_cells_BDCA1+, HPCA_Dendritic_cells_BDCA3+, HPCA_Dendritic_cells_plasmacytoid+, HPCA_Endothelial_cells, HPCA_Fibroblasts, HPCA_Keratinocytes, HPCA_M_IFNa, HPCA_M1_IFNg, HPCA_M2_IL-4, HPCA_Macrophage, HPCA_Monocytes_CD14plusCD16minus, ...]\n",
       "Index: []\n",
       "\n",
       "[0 rows x 141 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data=pd.merge( data_savant,metadata, on='sample')\n",
    "data.head()\n",
    "\n",
    "\n",
    "#select samples present in metdata nd filter Savant "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.15"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}