5_3_report_all.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'\\n\\njupyter nbconvert 5_association.ipynb --to script\\npython 5_association.py albumin 2 0\\n\\nfor i in {00..101};do python 5_association.py $i 2 1;done\\n\\n\\nfor i in {00..10};do python 5_association.py $i 2 0;done\\nfor i in {11..20};do python 5_association.py $i 2 0;done\\nfor i in {21..30};do python 5_association.py $i 2 0;done\\nfor i in {31..40};do python 5_association.py $i 2 0;done\\nfor i in {41..50};do python 5_association.py $i 2 0;done\\nfor i in {51..60};do python 5_association.py $i 2 0;done\\nfor i in {61..70};do python 5_association.py $i 2 0;done\\nfor i in {71..80};do python 5_association.py $i 2 0;done\\nfor i in {91..90};do python 5_association.py $i 2 0;done\\nfor i in {91..101};do python 5_association.py $i 2 0;done\\nfor i in {51..60};do python 5_association.py $i 2 0;done\\nfor i in {51..60};do python 5_association.py $i 2 0;done\\nfor i in {51..60};do python 5_association.py $i 2 0;done\\n\\nfor i in {00..101};do python 5_association.py $i 1 0,2;done\\nfor i in {00..101};do python 5_association.py $i 1 1;done\\n\\nfor i in {00..20};do python 5_association.py $i 1 1;done\\nfor i in {21..40};do python 5_association.py $i 1 1;done\\nfor i in {41..60};do python 5_association.py $i 1 1;done\\nfor i in {61..80};do python 5_association.py $i 1 1;done\\nfor i in {81..101};do python 5_association.py $i 1 1;done\\n\\n'"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import os\n",
    "import sys\n",
    "\n",
    "import logging\n",
    "import re\n",
    "import pathlib\n",
    "\n",
    "import datetime\n",
    "\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "from scipy.stats import pearsonr\n",
    "\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "from pyplink import PyPlink\n",
    "import seaborn as sns\n",
    "\n",
    "import statsmodels.api as sm\n",
    "\n",
    "from basic_tools import *\n",
    "\n",
    "\"\"\"\n",
    "\n",
    "jupyter nbconvert 5_association.ipynb --to script\n",
    "python 5_association.py albumin 2 0\n",
    "\n",
    "for i in {00..101};do python 5_association.py $i 2 1;done\n",
    "\n",
    "\n",
    "for i in {00..10};do python 5_association.py $i 2 0;done\n",
    "for i in {11..20};do python 5_association.py $i 2 0;done\n",
    "for i in {21..30};do python 5_association.py $i 2 0;done\n",
    "for i in {31..40};do python 5_association.py $i 2 0;done\n",
    "for i in {41..50};do python 5_association.py $i 2 0;done\n",
    "for i in {51..60};do python 5_association.py $i 2 0;done\n",
    "for i in {61..70};do python 5_association.py $i 2 0;done\n",
    "for i in {71..80};do python 5_association.py $i 2 0;done\n",
    "for i in {91..90};do python 5_association.py $i 2 0;done\n",
    "for i in {91..101};do python 5_association.py $i 2 0;done\n",
    "for i in {51..60};do python 5_association.py $i 2 0;done\n",
    "for i in {51..60};do python 5_association.py $i 2 0;done\n",
    "for i in {51..60};do python 5_association.py $i 2 0;done\n",
    "\n",
    "for i in {00..101};do python 5_association.py $i 1 0,2;done\n",
    "for i in {00..101};do python 5_association.py $i 1 1;done\n",
    "\n",
    "for i in {00..20};do python 5_association.py $i 1 1;done\n",
    "for i in {21..40};do python 5_association.py $i 1 1;done\n",
    "for i in {41..60};do python 5_association.py $i 1 1;done\n",
    "for i in {61..80};do python 5_association.py $i 1 1;done\n",
    "for i in {81..101};do python 5_association.py $i 1 1;done\n",
    "\n",
    "\"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "plink_KCHIP_HLA_AA_SNP_1000G=PyPlink(plink_KCHIP_HLA_AA_SNP_1000G_path)\n",
    "plink_KCHIP_HLA_AA_SNP_1000G_fam=plink_KCHIP_HLA_AA_SNP_1000G.get_fam().astype({'fid':str,'iid':str}).rename(columns={'fid':'FID','iid':'IID'})\n",
    "plink_KCHIP_HLA_AA_SNP_1000G_bim=plink_KCHIP_HLA_AA_SNP_1000G.get_bim()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "phenotypes=pd.read_csv(pheno_all_file_path,sep='\\t')\n",
    "phenotypes=phenotypes.set_index('ID').loc[plink_KCHIP_HLA_AA_SNP_1000G_fam['IID']]\n",
    "\n",
    "binary_continuous_traits=phenotypes.columns.difference(['age','sex','cohort','diabetes'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "97"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(binary_continuous_traits)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "phenotype_name='platelet'\n",
    "data_out_assoc_phenotype_path=data_out_assoc_path+phenotype_name+'/'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "step_idx_sub=2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    }
   ],
   "source": [
    "result_merge=pd.read_csv(data_out_assoc_phenotype_path+'step_{:02d}.merge.result.tsv'.format(step_idx_sub),sep='\\t')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>phenotype_type</th>\n",
       "      <th>phenotype_name</th>\n",
       "      <th>samples(case/control)</th>\n",
       "      <th>step</th>\n",
       "      <th>condition</th>\n",
       "      <th>marker_name</th>\n",
       "      <th>marker_name_pub</th>\n",
       "      <th>note</th>\n",
       "      <th>term</th>\n",
       "      <th>...</th>\n",
       "      <th>A1_freq_case</th>\n",
       "      <th>A1_freq_control</th>\n",
       "      <th>multi_allele</th>\n",
       "      <th>nobs</th>\n",
       "      <th>Z</th>\n",
       "      <th>coef</th>\n",
       "      <th>std</th>\n",
       "      <th>chisq</th>\n",
       "      <th>df</th>\n",
       "      <th>P</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>12142</th>\n",
       "      <td>700</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>HLA_B</td>\n",
       "      <td>HLA-B</td>\n",
       "      <td>phased multiallelic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HLA_B*07:02,HLA_B*13:01,HLA_B*13:02,HLA_B*14:0...</td>\n",
       "      <td>172174</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>290.513761</td>\n",
       "      <td>26.0</td>\n",
       "      <td>1.652724e-46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65635</th>\n",
       "      <td>648220</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:33541507_A/G</td>\n",
       "      <td>rs511515</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.252756</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>-12.411800</td>\n",
       "      <td>-3.938910</td>\n",
       "      <td>0.317352</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.417650e-35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65653</th>\n",
       "      <td>648400</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:33546930_T/C</td>\n",
       "      <td>rs210143</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.251426</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>-12.345000</td>\n",
       "      <td>-3.922350</td>\n",
       "      <td>0.317729</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.552350e-35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65652</th>\n",
       "      <td>648390</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:33546837_T/C</td>\n",
       "      <td>rs210142</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.251426</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>-12.345000</td>\n",
       "      <td>-3.922350</td>\n",
       "      <td>0.317729</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.552350e-35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65658</th>\n",
       "      <td>648450</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:33548090_A/AG</td>\n",
       "      <td>6:33548090_A/AG</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.251339</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>-12.333400</td>\n",
       "      <td>-3.918650</td>\n",
       "      <td>0.317727</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.408650e-35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65633</th>\n",
       "      <td>648200</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:33540692_T/A</td>\n",
       "      <td>rs210135</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.248539</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>-12.083000</td>\n",
       "      <td>-3.848380</td>\n",
       "      <td>0.318494</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.382300e-33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12173</th>\n",
       "      <td>728</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>HLA_C</td>\n",
       "      <td>HLA-C</td>\n",
       "      <td>phased multiallelic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HLA_C*01:02,HLA_C*03:02,HLA_C*03:03,HLA_C*03:0...</td>\n",
       "      <td>172174</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>192.304779</td>\n",
       "      <td>15.0</td>\n",
       "      <td>7.739463e-33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52491</th>\n",
       "      <td>775</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>HLA_DQB1</td>\n",
       "      <td>HLA-DQB1</td>\n",
       "      <td>phased multiallelic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HLA_DQB1*02:01,HLA_DQB1*02:02,HLA_DQB1*03:01,H...</td>\n",
       "      <td>172174</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>183.011788</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1.584756e-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24322</th>\n",
       "      <td>241650</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31217815_A/C</td>\n",
       "      <td>rs2894189</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.485108</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>11.487100</td>\n",
       "      <td>3.013700</td>\n",
       "      <td>0.262356</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.612700e-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24282</th>\n",
       "      <td>241250</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31216262_G/A</td>\n",
       "      <td>rs3130412</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.484115</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>11.455800</td>\n",
       "      <td>3.005720</td>\n",
       "      <td>0.262377</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.314650e-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24332</th>\n",
       "      <td>241750</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31218208_A/G</td>\n",
       "      <td>rs3130423</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.484109</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>11.446800</td>\n",
       "      <td>3.003360</td>\n",
       "      <td>0.262374</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.565100e-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24321</th>\n",
       "      <td>241640</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31217741_T/C</td>\n",
       "      <td>rs3130419</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.484109</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>11.446800</td>\n",
       "      <td>3.003360</td>\n",
       "      <td>0.262374</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.565100e-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24324</th>\n",
       "      <td>241670</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31217973_C/T</td>\n",
       "      <td>rs2394908</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.484109</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>11.446800</td>\n",
       "      <td>3.003360</td>\n",
       "      <td>0.262374</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.565100e-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24290</th>\n",
       "      <td>241330</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31216507_A/C</td>\n",
       "      <td>rs2394905</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.484109</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>11.446800</td>\n",
       "      <td>3.003360</td>\n",
       "      <td>0.262374</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.565100e-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24245</th>\n",
       "      <td>240880</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31214652_A/G</td>\n",
       "      <td>rs3130538</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.484103</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>11.446000</td>\n",
       "      <td>3.003090</td>\n",
       "      <td>0.262371</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.591580e-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24256</th>\n",
       "      <td>240990</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31215005_T/C</td>\n",
       "      <td>rs2394903</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.484103</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>11.446000</td>\n",
       "      <td>3.003090</td>\n",
       "      <td>0.262371</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.591580e-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24192</th>\n",
       "      <td>240350</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31210796_A/G</td>\n",
       "      <td>rs3130537</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.484103</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>11.446000</td>\n",
       "      <td>3.003090</td>\n",
       "      <td>0.262371</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.591580e-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24208</th>\n",
       "      <td>240510</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31211436_T/C</td>\n",
       "      <td>rs3130697</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.484103</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>11.446000</td>\n",
       "      <td>3.003090</td>\n",
       "      <td>0.262371</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.591580e-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24183</th>\n",
       "      <td>240260</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31210577_T/C</td>\n",
       "      <td>rs3134765</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.484103</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>11.446000</td>\n",
       "      <td>3.003090</td>\n",
       "      <td>0.262371</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.591580e-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24188</th>\n",
       "      <td>240310</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31210691_A/G</td>\n",
       "      <td>rs3132494</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.484103</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>11.446000</td>\n",
       "      <td>3.003090</td>\n",
       "      <td>0.262371</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.591580e-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24257</th>\n",
       "      <td>241000</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31215006_G/A</td>\n",
       "      <td>rs3130410</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.484103</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>11.446000</td>\n",
       "      <td>3.003090</td>\n",
       "      <td>0.262371</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.591580e-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24203</th>\n",
       "      <td>240460</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31211093_AT/A</td>\n",
       "      <td>6:31211093_AT/A</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.483999</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>11.424200</td>\n",
       "      <td>2.997500</td>\n",
       "      <td>0.262382</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.329450e-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24353</th>\n",
       "      <td>241960</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>AX-15354677</td>\n",
       "      <td>rs3130427</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.482014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85650</td>\n",
       "      <td>11.412900</td>\n",
       "      <td>3.009120</td>\n",
       "      <td>0.263659</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.789700e-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24296</th>\n",
       "      <td>241390</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31216730_CA/C</td>\n",
       "      <td>6:31216730_CA/C</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.484051</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>11.402800</td>\n",
       "      <td>2.991840</td>\n",
       "      <td>0.262378</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.257260e-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24335</th>\n",
       "      <td>241780</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>AX-15354672</td>\n",
       "      <td>rs3130425</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.483820</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85877</td>\n",
       "      <td>11.327400</td>\n",
       "      <td>2.977840</td>\n",
       "      <td>0.262888</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.007570e-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22276</th>\n",
       "      <td>221190</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>AX-35729741</td>\n",
       "      <td>rs3132542</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.458010</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85938</td>\n",
       "      <td>11.166100</td>\n",
       "      <td>2.949520</td>\n",
       "      <td>0.264149</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.253790e-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22272</th>\n",
       "      <td>221150</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31090945_C/T</td>\n",
       "      <td>rs3130998</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.458315</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>11.164600</td>\n",
       "      <td>2.944910</td>\n",
       "      <td>0.263771</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.357960e-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22282</th>\n",
       "      <td>221250</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31091447_C/T</td>\n",
       "      <td>rs3095310</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.458310</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>11.160700</td>\n",
       "      <td>2.943830</td>\n",
       "      <td>0.263769</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.649540e-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24323</th>\n",
       "      <td>241660</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31217943_C/T</td>\n",
       "      <td>rs2394907</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.429298</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>-11.142200</td>\n",
       "      <td>-2.956680</td>\n",
       "      <td>0.265358</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.175820e-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22275</th>\n",
       "      <td>221180</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31091074_G/A</td>\n",
       "      <td>rs3132543</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.458426</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>11.136500</td>\n",
       "      <td>2.937300</td>\n",
       "      <td>0.263755</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.724000e-29</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14757</th>\n",
       "      <td>146000</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:30052006_A/G</td>\n",
       "      <td>rs188821094</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.234832</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>-0.001850</td>\n",
       "      <td>-0.000576</td>\n",
       "      <td>0.311231</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.985240e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37093</th>\n",
       "      <td>367300</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:32343715_G/A</td>\n",
       "      <td>rs114445199</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.174701</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>-0.001668</td>\n",
       "      <td>-0.000583</td>\n",
       "      <td>0.349434</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.986690e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10905</th>\n",
       "      <td>109050</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:29874490_C/T</td>\n",
       "      <td>rs2734932</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.496265</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>-0.001632</td>\n",
       "      <td>-0.000428</td>\n",
       "      <td>0.261974</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.986980e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20620</th>\n",
       "      <td>204630</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:30970134_ATC/A</td>\n",
       "      <td>6:30970134_ATC/A</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.012830</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>-0.001622</td>\n",
       "      <td>-0.001897</td>\n",
       "      <td>1.169390</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.987060e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20685</th>\n",
       "      <td>205280</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:30976772_A/C</td>\n",
       "      <td>rs143001137</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.012830</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>-0.001622</td>\n",
       "      <td>-0.001897</td>\n",
       "      <td>1.169390</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.987060e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40965</th>\n",
       "      <td>406020</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:32517761_G/A</td>\n",
       "      <td>rs67778241</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.075546</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>0.001567</td>\n",
       "      <td>0.000782</td>\n",
       "      <td>0.499207</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.987490e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32724</th>\n",
       "      <td>323610</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31462898_C/A</td>\n",
       "      <td>rs151327873</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.011477</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>0.001509</td>\n",
       "      <td>0.001860</td>\n",
       "      <td>1.233140</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.987960e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18672</th>\n",
       "      <td>185150</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>AX-35727335</td>\n",
       "      <td>rs73727463</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.151435</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85875</td>\n",
       "      <td>-0.001499</td>\n",
       "      <td>-0.000551</td>\n",
       "      <td>0.367642</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.988040e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18088</th>\n",
       "      <td>179310</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:30537339_G/A</td>\n",
       "      <td>rs3130242</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.286815</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>0.001358</td>\n",
       "      <td>0.000394</td>\n",
       "      <td>0.290127</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.989170e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>647</th>\n",
       "      <td>6470</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:28168965_CATAG/C</td>\n",
       "      <td>6:28168965_CATAG/C</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.123021</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>0.001125</td>\n",
       "      <td>0.000449</td>\n",
       "      <td>0.399518</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.991020e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>639</th>\n",
       "      <td>6390</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:28168103_T/G</td>\n",
       "      <td>rs9393905</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.123021</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>0.001125</td>\n",
       "      <td>0.000449</td>\n",
       "      <td>0.399518</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.991020e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33263</th>\n",
       "      <td>329000</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31519509_T/C</td>\n",
       "      <td>rs112868039</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.024156</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>-0.000934</td>\n",
       "      <td>-0.000798</td>\n",
       "      <td>0.854903</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.992550e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3219</th>\n",
       "      <td>32190</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:28860078_A/AAAGGAAGG</td>\n",
       "      <td>6:28860078_A/AAAGGAAGG</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.363051</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>-0.000531</td>\n",
       "      <td>-0.000145</td>\n",
       "      <td>0.272357</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.995760e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32792</th>\n",
       "      <td>324290</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>AX-11483893</td>\n",
       "      <td>rs3828917</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.049572</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85855</td>\n",
       "      <td>0.000410</td>\n",
       "      <td>0.000247</td>\n",
       "      <td>0.602893</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.996730e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33237</th>\n",
       "      <td>328740</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31514153_GCTGT/G</td>\n",
       "      <td>6:31514153_GCTGT/G</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.078903</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>-0.000234</td>\n",
       "      <td>-0.000114</td>\n",
       "      <td>0.487413</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.998130e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33236</th>\n",
       "      <td>328730</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:31513864_A/T</td>\n",
       "      <td>rs2523502</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.078903</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>-0.000234</td>\n",
       "      <td>-0.000114</td>\n",
       "      <td>0.487413</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.998130e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64957</th>\n",
       "      <td>641440</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:33421833_G/A</td>\n",
       "      <td>rs41271245</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.029615</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>0.000025</td>\n",
       "      <td>0.000019</td>\n",
       "      <td>0.777385</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.999800e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33072</th>\n",
       "      <td>327090</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>AX-11433202</td>\n",
       "      <td>rs3095227</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.121124</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86073</td>\n",
       "      <td>0.000015</td>\n",
       "      <td>0.000006</td>\n",
       "      <td>0.402733</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.999880e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7056</th>\n",
       "      <td>70560</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>AX-11675566</td>\n",
       "      <td>rs9258102</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.068396</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>74983</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30079</th>\n",
       "      <td>297160</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>AX-11396682</td>\n",
       "      <td>rs2523534</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.465428</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78475</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33023</th>\n",
       "      <td>326600</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>AX-15355403</td>\n",
       "      <td>rs3093999</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.143128</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>76655</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33597</th>\n",
       "      <td>332340</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>AX-11381232</td>\n",
       "      <td>rs2280801</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.098229</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78597</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65639</th>\n",
       "      <td>648260</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>rs9296095</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.223034</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85942</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65642</th>\n",
       "      <td>648290</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:33543374_CAGG/C</td>\n",
       "      <td>6:33543374_CAGG/C</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.222809</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65646</th>\n",
       "      <td>648330</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>AX-113131953</td>\n",
       "      <td>rs5745587</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.222181</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85894</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65649</th>\n",
       "      <td>648360</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>AX-96085836</td>\n",
       "      <td>rs5745582</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.224667</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85776</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65661</th>\n",
       "      <td>648480</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:33548394_G/T</td>\n",
       "      <td>rs5745568</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.223692</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65664</th>\n",
       "      <td>648510</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:33548696_C/CA</td>\n",
       "      <td>6:33548696_C/CA</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.223553</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65667</th>\n",
       "      <td>648540</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>6:33549403_C/T</td>\n",
       "      <td>rs9357161</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.223716</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86087</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65677</th>\n",
       "      <td>648640</td>\n",
       "      <td>continuous</td>\n",
       "      <td>platelet</td>\n",
       "      <td>86087</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41961031</td>\n",
       "      <td>AX-35756363</td>\n",
       "      <td>rs75080135</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.224806</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85189</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>71107 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0 phenotype_type phenotype_name  samples(case/control)  step  \\\n",
       "12142         700     continuous       platelet                  86087     2   \n",
       "65635      648220     continuous       platelet                  86087     2   \n",
       "65653      648400     continuous       platelet                  86087     2   \n",
       "65652      648390     continuous       platelet                  86087     2   \n",
       "65658      648450     continuous       platelet                  86087     2   \n",
       "65633      648200     continuous       platelet                  86087     2   \n",
       "12173         728     continuous       platelet                  86087     2   \n",
       "52491         775     continuous       platelet                  86087     2   \n",
       "24322      241650     continuous       platelet                  86087     2   \n",
       "24282      241250     continuous       platelet                  86087     2   \n",
       "24332      241750     continuous       platelet                  86087     2   \n",
       "24321      241640     continuous       platelet                  86087     2   \n",
       "24324      241670     continuous       platelet                  86087     2   \n",
       "24290      241330     continuous       platelet                  86087     2   \n",
       "24245      240880     continuous       platelet                  86087     2   \n",
       "24256      240990     continuous       platelet                  86087     2   \n",
       "24192      240350     continuous       platelet                  86087     2   \n",
       "24208      240510     continuous       platelet                  86087     2   \n",
       "24183      240260     continuous       platelet                  86087     2   \n",
       "24188      240310     continuous       platelet                  86087     2   \n",
       "24257      241000     continuous       platelet                  86087     2   \n",
       "24203      240460     continuous       platelet                  86087     2   \n",
       "24353      241960     continuous       platelet                  86087     2   \n",
       "24296      241390     continuous       platelet                  86087     2   \n",
       "24335      241780     continuous       platelet                  86087     2   \n",
       "22276      221190     continuous       platelet                  86087     2   \n",
       "22272      221150     continuous       platelet                  86087     2   \n",
       "22282      221250     continuous       platelet                  86087     2   \n",
       "24323      241660     continuous       platelet                  86087     2   \n",
       "22275      221180     continuous       platelet                  86087     2   \n",
       "...           ...            ...            ...                    ...   ...   \n",
       "14757      146000     continuous       platelet                  86087     2   \n",
       "37093      367300     continuous       platelet                  86087     2   \n",
       "10905      109050     continuous       platelet                  86087     2   \n",
       "20620      204630     continuous       platelet                  86087     2   \n",
       "20685      205280     continuous       platelet                  86087     2   \n",
       "40965      406020     continuous       platelet                  86087     2   \n",
       "32724      323610     continuous       platelet                  86087     2   \n",
       "18672      185150     continuous       platelet                  86087     2   \n",
       "18088      179310     continuous       platelet                  86087     2   \n",
       "647          6470     continuous       platelet                  86087     2   \n",
       "639          6390     continuous       platelet                  86087     2   \n",
       "33263      329000     continuous       platelet                  86087     2   \n",
       "3219        32190     continuous       platelet                  86087     2   \n",
       "32792      324290     continuous       platelet                  86087     2   \n",
       "33237      328740     continuous       platelet                  86087     2   \n",
       "33236      328730     continuous       platelet                  86087     2   \n",
       "64957      641440     continuous       platelet                  86087     2   \n",
       "33072      327090     continuous       platelet                  86087     2   \n",
       "7056        70560     continuous       platelet                  86087     2   \n",
       "30079      297160     continuous       platelet                  86087     2   \n",
       "33023      326600     continuous       platelet                  86087     2   \n",
       "33597      332340     continuous       platelet                  86087     2   \n",
       "65639      648260     continuous       platelet                  86087     2   \n",
       "65642      648290     continuous       platelet                  86087     2   \n",
       "65646      648330     continuous       platelet                  86087     2   \n",
       "65649      648360     continuous       platelet                  86087     2   \n",
       "65661      648480     continuous       platelet                  86087     2   \n",
       "65664      648510     continuous       platelet                  86087     2   \n",
       "65667      648540     continuous       platelet                  86087     2   \n",
       "65677      648640     continuous       platelet                  86087     2   \n",
       "\n",
       "         condition             marker_name         marker_name_pub  \\\n",
       "12142  AX-41961031                   HLA_B                   HLA-B   \n",
       "65635  AX-41961031          6:33541507_A/G                rs511515   \n",
       "65653  AX-41961031          6:33546930_T/C                rs210143   \n",
       "65652  AX-41961031          6:33546837_T/C                rs210142   \n",
       "65658  AX-41961031         6:33548090_A/AG         6:33548090_A/AG   \n",
       "65633  AX-41961031          6:33540692_T/A                rs210135   \n",
       "12173  AX-41961031                   HLA_C                   HLA-C   \n",
       "52491  AX-41961031                HLA_DQB1                HLA-DQB1   \n",
       "24322  AX-41961031          6:31217815_A/C               rs2894189   \n",
       "24282  AX-41961031          6:31216262_G/A               rs3130412   \n",
       "24332  AX-41961031          6:31218208_A/G               rs3130423   \n",
       "24321  AX-41961031          6:31217741_T/C               rs3130419   \n",
       "24324  AX-41961031          6:31217973_C/T               rs2394908   \n",
       "24290  AX-41961031          6:31216507_A/C               rs2394905   \n",
       "24245  AX-41961031          6:31214652_A/G               rs3130538   \n",
       "24256  AX-41961031          6:31215005_T/C               rs2394903   \n",
       "24192  AX-41961031          6:31210796_A/G               rs3130537   \n",
       "24208  AX-41961031          6:31211436_T/C               rs3130697   \n",
       "24183  AX-41961031          6:31210577_T/C               rs3134765   \n",
       "24188  AX-41961031          6:31210691_A/G               rs3132494   \n",
       "24257  AX-41961031          6:31215006_G/A               rs3130410   \n",
       "24203  AX-41961031         6:31211093_AT/A         6:31211093_AT/A   \n",
       "24353  AX-41961031             AX-15354677               rs3130427   \n",
       "24296  AX-41961031         6:31216730_CA/C         6:31216730_CA/C   \n",
       "24335  AX-41961031             AX-15354672               rs3130425   \n",
       "22276  AX-41961031             AX-35729741               rs3132542   \n",
       "22272  AX-41961031          6:31090945_C/T               rs3130998   \n",
       "22282  AX-41961031          6:31091447_C/T               rs3095310   \n",
       "24323  AX-41961031          6:31217943_C/T               rs2394907   \n",
       "22275  AX-41961031          6:31091074_G/A               rs3132543   \n",
       "...            ...                     ...                     ...   \n",
       "14757  AX-41961031          6:30052006_A/G             rs188821094   \n",
       "37093  AX-41961031          6:32343715_G/A             rs114445199   \n",
       "10905  AX-41961031          6:29874490_C/T               rs2734932   \n",
       "20620  AX-41961031        6:30970134_ATC/A        6:30970134_ATC/A   \n",
       "20685  AX-41961031          6:30976772_A/C             rs143001137   \n",
       "40965  AX-41961031          6:32517761_G/A              rs67778241   \n",
       "32724  AX-41961031          6:31462898_C/A             rs151327873   \n",
       "18672  AX-41961031             AX-35727335              rs73727463   \n",
       "18088  AX-41961031          6:30537339_G/A               rs3130242   \n",
       "647    AX-41961031      6:28168965_CATAG/C      6:28168965_CATAG/C   \n",
       "639    AX-41961031          6:28168103_T/G               rs9393905   \n",
       "33263  AX-41961031          6:31519509_T/C             rs112868039   \n",
       "3219   AX-41961031  6:28860078_A/AAAGGAAGG  6:28860078_A/AAAGGAAGG   \n",
       "32792  AX-41961031             AX-11483893               rs3828917   \n",
       "33237  AX-41961031      6:31514153_GCTGT/G      6:31514153_GCTGT/G   \n",
       "33236  AX-41961031          6:31513864_A/T               rs2523502   \n",
       "64957  AX-41961031          6:33421833_G/A              rs41271245   \n",
       "33072  AX-41961031             AX-11433202               rs3095227   \n",
       "7056   AX-41961031             AX-11675566               rs9258102   \n",
       "30079  AX-41961031             AX-11396682               rs2523534   \n",
       "33023  AX-41961031             AX-15355403               rs3093999   \n",
       "33597  AX-41961031             AX-11381232               rs2280801   \n",
       "65639  AX-41961031             AX-41961031               rs9296095   \n",
       "65642  AX-41961031       6:33543374_CAGG/C       6:33543374_CAGG/C   \n",
       "65646  AX-41961031            AX-113131953               rs5745587   \n",
       "65649  AX-41961031             AX-96085836               rs5745582   \n",
       "65661  AX-41961031          6:33548394_G/T               rs5745568   \n",
       "65664  AX-41961031         6:33548696_C/CA         6:33548696_C/CA   \n",
       "65667  AX-41961031          6:33549403_C/T               rs9357161   \n",
       "65677  AX-41961031             AX-35756363              rs75080135   \n",
       "\n",
       "                      note term  ...  A1_freq_case A1_freq_control  \\\n",
       "12142  phased multiallelic  NaN  ...           NaN             NaN   \n",
       "65635    unphased bialleic  ADD  ...      0.252756             NaN   \n",
       "65653    unphased bialleic  ADD  ...      0.251426             NaN   \n",
       "65652    unphased bialleic  ADD  ...      0.251426             NaN   \n",
       "65658    unphased bialleic  ADD  ...      0.251339             NaN   \n",
       "65633    unphased bialleic  ADD  ...      0.248539             NaN   \n",
       "12173  phased multiallelic  NaN  ...           NaN             NaN   \n",
       "52491  phased multiallelic  NaN  ...           NaN             NaN   \n",
       "24322    unphased bialleic  ADD  ...      0.485108             NaN   \n",
       "24282    unphased bialleic  ADD  ...      0.484115             NaN   \n",
       "24332    unphased bialleic  ADD  ...      0.484109             NaN   \n",
       "24321    unphased bialleic  ADD  ...      0.484109             NaN   \n",
       "24324    unphased bialleic  ADD  ...      0.484109             NaN   \n",
       "24290    unphased bialleic  ADD  ...      0.484109             NaN   \n",
       "24245    unphased bialleic  ADD  ...      0.484103             NaN   \n",
       "24256    unphased bialleic  ADD  ...      0.484103             NaN   \n",
       "24192    unphased bialleic  ADD  ...      0.484103             NaN   \n",
       "24208    unphased bialleic  ADD  ...      0.484103             NaN   \n",
       "24183    unphased bialleic  ADD  ...      0.484103             NaN   \n",
       "24188    unphased bialleic  ADD  ...      0.484103             NaN   \n",
       "24257    unphased bialleic  ADD  ...      0.484103             NaN   \n",
       "24203    unphased bialleic  ADD  ...      0.483999             NaN   \n",
       "24353    unphased bialleic  ADD  ...      0.482014             NaN   \n",
       "24296    unphased bialleic  ADD  ...      0.484051             NaN   \n",
       "24335    unphased bialleic  ADD  ...      0.483820             NaN   \n",
       "22276    unphased bialleic  ADD  ...      0.458010             NaN   \n",
       "22272    unphased bialleic  ADD  ...      0.458315             NaN   \n",
       "22282    unphased bialleic  ADD  ...      0.458310             NaN   \n",
       "24323    unphased bialleic  ADD  ...      0.429298             NaN   \n",
       "22275    unphased bialleic  ADD  ...      0.458426             NaN   \n",
       "...                    ...  ...  ...           ...             ...   \n",
       "14757    unphased bialleic  ADD  ...      0.234832             NaN   \n",
       "37093    unphased bialleic  ADD  ...      0.174701             NaN   \n",
       "10905    unphased bialleic  ADD  ...      0.496265             NaN   \n",
       "20620    unphased bialleic  ADD  ...      0.012830             NaN   \n",
       "20685    unphased bialleic  ADD  ...      0.012830             NaN   \n",
       "40965    unphased bialleic  ADD  ...      0.075546             NaN   \n",
       "32724    unphased bialleic  ADD  ...      0.011477             NaN   \n",
       "18672    unphased bialleic  ADD  ...      0.151435             NaN   \n",
       "18088    unphased bialleic  ADD  ...      0.286815             NaN   \n",
       "647      unphased bialleic  ADD  ...      0.123021             NaN   \n",
       "639      unphased bialleic  ADD  ...      0.123021             NaN   \n",
       "33263    unphased bialleic  ADD  ...      0.024156             NaN   \n",
       "3219     unphased bialleic  ADD  ...      0.363051             NaN   \n",
       "32792    unphased bialleic  ADD  ...      0.049572             NaN   \n",
       "33237    unphased bialleic  ADD  ...      0.078903             NaN   \n",
       "33236    unphased bialleic  ADD  ...      0.078903             NaN   \n",
       "64957    unphased bialleic  ADD  ...      0.029615             NaN   \n",
       "33072    unphased bialleic  ADD  ...      0.121124             NaN   \n",
       "7056     unphased bialleic  ADD  ...      0.068396             NaN   \n",
       "30079    unphased bialleic  ADD  ...      0.465428             NaN   \n",
       "33023    unphased bialleic  ADD  ...      0.143128             NaN   \n",
       "33597    unphased bialleic  ADD  ...      0.098229             NaN   \n",
       "65639    unphased bialleic  ADD  ...      0.223034             NaN   \n",
       "65642    unphased bialleic  ADD  ...      0.222809             NaN   \n",
       "65646    unphased bialleic  ADD  ...      0.222181             NaN   \n",
       "65649    unphased bialleic  ADD  ...      0.224667             NaN   \n",
       "65661    unphased bialleic  ADD  ...      0.223692             NaN   \n",
       "65664    unphased bialleic  ADD  ...      0.223553             NaN   \n",
       "65667    unphased bialleic  ADD  ...      0.223716             NaN   \n",
       "65677    unphased bialleic  ADD  ...      0.224806             NaN   \n",
       "\n",
       "                                            multi_allele    nobs          Z  \\\n",
       "12142  HLA_B*07:02,HLA_B*13:01,HLA_B*13:02,HLA_B*14:0...  172174        NaN   \n",
       "65635                                                NaN   86087 -12.411800   \n",
       "65653                                                NaN   86087 -12.345000   \n",
       "65652                                                NaN   86087 -12.345000   \n",
       "65658                                                NaN   86087 -12.333400   \n",
       "65633                                                NaN   86087 -12.083000   \n",
       "12173  HLA_C*01:02,HLA_C*03:02,HLA_C*03:03,HLA_C*03:0...  172174        NaN   \n",
       "52491  HLA_DQB1*02:01,HLA_DQB1*02:02,HLA_DQB1*03:01,H...  172174        NaN   \n",
       "24322                                                NaN   86087  11.487100   \n",
       "24282                                                NaN   86087  11.455800   \n",
       "24332                                                NaN   86087  11.446800   \n",
       "24321                                                NaN   86087  11.446800   \n",
       "24324                                                NaN   86087  11.446800   \n",
       "24290                                                NaN   86087  11.446800   \n",
       "24245                                                NaN   86087  11.446000   \n",
       "24256                                                NaN   86087  11.446000   \n",
       "24192                                                NaN   86087  11.446000   \n",
       "24208                                                NaN   86087  11.446000   \n",
       "24183                                                NaN   86087  11.446000   \n",
       "24188                                                NaN   86087  11.446000   \n",
       "24257                                                NaN   86087  11.446000   \n",
       "24203                                                NaN   86087  11.424200   \n",
       "24353                                                NaN   85650  11.412900   \n",
       "24296                                                NaN   86087  11.402800   \n",
       "24335                                                NaN   85877  11.327400   \n",
       "22276                                                NaN   85938  11.166100   \n",
       "22272                                                NaN   86087  11.164600   \n",
       "22282                                                NaN   86087  11.160700   \n",
       "24323                                                NaN   86087 -11.142200   \n",
       "22275                                                NaN   86087  11.136500   \n",
       "...                                                  ...     ...        ...   \n",
       "14757                                                NaN   86087  -0.001850   \n",
       "37093                                                NaN   86087  -0.001668   \n",
       "10905                                                NaN   86087  -0.001632   \n",
       "20620                                                NaN   86087  -0.001622   \n",
       "20685                                                NaN   86087  -0.001622   \n",
       "40965                                                NaN   86087   0.001567   \n",
       "32724                                                NaN   86087   0.001509   \n",
       "18672                                                NaN   85875  -0.001499   \n",
       "18088                                                NaN   86087   0.001358   \n",
       "647                                                  NaN   86087   0.001125   \n",
       "639                                                  NaN   86087   0.001125   \n",
       "33263                                                NaN   86087  -0.000934   \n",
       "3219                                                 NaN   86087  -0.000531   \n",
       "32792                                                NaN   85855   0.000410   \n",
       "33237                                                NaN   86087  -0.000234   \n",
       "33236                                                NaN   86087  -0.000234   \n",
       "64957                                                NaN   86087   0.000025   \n",
       "33072                                                NaN   86073   0.000015   \n",
       "7056                                                 NaN   74983        NaN   \n",
       "30079                                                NaN   78475        NaN   \n",
       "33023                                                NaN   76655        NaN   \n",
       "33597                                                NaN   78597        NaN   \n",
       "65639                                                NaN   85942        NaN   \n",
       "65642                                                NaN   86087        NaN   \n",
       "65646                                                NaN   85894        NaN   \n",
       "65649                                                NaN   85776        NaN   \n",
       "65661                                                NaN   86087        NaN   \n",
       "65664                                                NaN   86087        NaN   \n",
       "65667                                                NaN   86087        NaN   \n",
       "65677                                                NaN   85189        NaN   \n",
       "\n",
       "           coef       std       chisq    df             P  \n",
       "12142       NaN       NaN  290.513761  26.0  1.652724e-46  \n",
       "65635 -3.938910  0.317352         NaN   NaN  2.417650e-35  \n",
       "65653 -3.922350  0.317729         NaN   NaN  5.552350e-35  \n",
       "65652 -3.922350  0.317729         NaN   NaN  5.552350e-35  \n",
       "65658 -3.918650  0.317727         NaN   NaN  6.408650e-35  \n",
       "65633 -3.848380  0.318494         NaN   NaN  1.382300e-33  \n",
       "12173       NaN       NaN  192.304779  15.0  7.739463e-33  \n",
       "52491       NaN       NaN  183.011788  14.0  1.584756e-31  \n",
       "24322  3.013700  0.262356         NaN   NaN  1.612700e-30  \n",
       "24282  3.005720  0.262377         NaN   NaN  2.314650e-30  \n",
       "24332  3.003360  0.262374         NaN   NaN  2.565100e-30  \n",
       "24321  3.003360  0.262374         NaN   NaN  2.565100e-30  \n",
       "24324  3.003360  0.262374         NaN   NaN  2.565100e-30  \n",
       "24290  3.003360  0.262374         NaN   NaN  2.565100e-30  \n",
       "24245  3.003090  0.262371         NaN   NaN  2.591580e-30  \n",
       "24256  3.003090  0.262371         NaN   NaN  2.591580e-30  \n",
       "24192  3.003090  0.262371         NaN   NaN  2.591580e-30  \n",
       "24208  3.003090  0.262371         NaN   NaN  2.591580e-30  \n",
       "24183  3.003090  0.262371         NaN   NaN  2.591580e-30  \n",
       "24188  3.003090  0.262371         NaN   NaN  2.591580e-30  \n",
       "24257  3.003090  0.262371         NaN   NaN  2.591580e-30  \n",
       "24203  2.997500  0.262382         NaN   NaN  3.329450e-30  \n",
       "24353  3.009120  0.263659         NaN   NaN  3.789700e-30  \n",
       "24296  2.991840  0.262378         NaN   NaN  4.257260e-30  \n",
       "24335  2.977840  0.262888         NaN   NaN  1.007570e-29  \n",
       "22276  2.949520  0.264149         NaN   NaN  6.253790e-29  \n",
       "22272  2.944910  0.263771         NaN   NaN  6.357960e-29  \n",
       "22282  2.943830  0.263769         NaN   NaN  6.649540e-29  \n",
       "24323 -2.956680  0.265358         NaN   NaN  8.175820e-29  \n",
       "22275  2.937300  0.263755         NaN   NaN  8.724000e-29  \n",
       "...         ...       ...         ...   ...           ...  \n",
       "14757 -0.000576  0.311231         NaN   NaN  9.985240e-01  \n",
       "37093 -0.000583  0.349434         NaN   NaN  9.986690e-01  \n",
       "10905 -0.000428  0.261974         NaN   NaN  9.986980e-01  \n",
       "20620 -0.001897  1.169390         NaN   NaN  9.987060e-01  \n",
       "20685 -0.001897  1.169390         NaN   NaN  9.987060e-01  \n",
       "40965  0.000782  0.499207         NaN   NaN  9.987490e-01  \n",
       "32724  0.001860  1.233140         NaN   NaN  9.987960e-01  \n",
       "18672 -0.000551  0.367642         NaN   NaN  9.988040e-01  \n",
       "18088  0.000394  0.290127         NaN   NaN  9.989170e-01  \n",
       "647    0.000449  0.399518         NaN   NaN  9.991020e-01  \n",
       "639    0.000449  0.399518         NaN   NaN  9.991020e-01  \n",
       "33263 -0.000798  0.854903         NaN   NaN  9.992550e-01  \n",
       "3219  -0.000145  0.272357         NaN   NaN  9.995760e-01  \n",
       "32792  0.000247  0.602893         NaN   NaN  9.996730e-01  \n",
       "33237 -0.000114  0.487413         NaN   NaN  9.998130e-01  \n",
       "33236 -0.000114  0.487413         NaN   NaN  9.998130e-01  \n",
       "64957  0.000019  0.777385         NaN   NaN  9.999800e-01  \n",
       "33072  0.000006  0.402733         NaN   NaN  9.999880e-01  \n",
       "7056        NaN       NaN         NaN   NaN           NaN  \n",
       "30079       NaN       NaN         NaN   NaN           NaN  \n",
       "33023       NaN       NaN         NaN   NaN           NaN  \n",
       "33597       NaN       NaN         NaN   NaN           NaN  \n",
       "65639       NaN       NaN         NaN   NaN           NaN  \n",
       "65642       NaN       NaN         NaN   NaN           NaN  \n",
       "65646       NaN       NaN         NaN   NaN           NaN  \n",
       "65649       NaN       NaN         NaN   NaN           NaN  \n",
       "65661       NaN       NaN         NaN   NaN           NaN  \n",
       "65664       NaN       NaN         NaN   NaN           NaN  \n",
       "65667       NaN       NaN         NaN   NaN           NaN  \n",
       "65677       NaN       NaN         NaN   NaN           NaN  \n",
       "\n",
       "[71107 rows x 23 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result_merge.sort_values(\"P\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "GAT_result[((~GAT_result['marker_name'].str.contains('HLA',regex=False))|(GAT_result['marker_name'].str.contains('*',regex=False)))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "#result_merge[((~result_merge['marker_name'].str.contains('HLA',regex=False))|(result_merge['marker_name'].str.contains('*',regex=False)))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 3\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 3\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 5\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 3\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 4\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 4\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 3\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 4\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 3\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 4\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 3\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 3\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 3\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 5\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 7\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 5\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 3\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 5\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 3\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 3\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 3\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 3\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 4\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 3\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 9\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 3\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 3\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 6\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 3\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 3\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 6\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 3\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 4\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 6\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "meets end 6\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ch6845/tools/miniconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (15) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    }
   ],
   "source": [
    "assoc_result_list=[]\n",
    "for phenotype_name in binary_continuous_traits:\n",
    "    data_out_assoc_phenotype_path=data_out_assoc_path+phenotype_name+'/'\n",
    "\n",
    "    for step_idx_sub in range(1,100):\n",
    "        #print(step_idx_sub)\n",
    "        if os.path.exists(data_out_assoc_phenotype_path+'step_{:02d}.cond.stop'.format(step_idx_sub)):\n",
    "            print('meets end',step_idx_sub)\n",
    "            break\n",
    "        result_merge=pd.read_csv(data_out_assoc_phenotype_path+'step_{:02d}.merge.result.tsv'.format(step_idx_sub),sep='\\t')\n",
    "        result_merge=result_merge[((~result_merge['marker_name'].str.contains('HLA',regex=False))|(result_merge['marker_name'].str.contains('*',regex=False)))]\n",
    "        assoc_result_list.append(result_merge.sort_values('P').iloc[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "#assoc_result_concat"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "assoc_result_concat=pd.concat(assoc_result_list,axis=1).transpose()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "assoc_result_concat.to_csv('data/result_concat_1_top_all.tsv',sep='\\t')#,index=None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>phenotype_type</th>\n",
       "      <th>phenotype_name</th>\n",
       "      <th>samples(case/control)</th>\n",
       "      <th>step</th>\n",
       "      <th>condition</th>\n",
       "      <th>marker_name</th>\n",
       "      <th>marker_name_pub</th>\n",
       "      <th>note</th>\n",
       "      <th>term</th>\n",
       "      <th>...</th>\n",
       "      <th>A1_freq_case</th>\n",
       "      <th>A1_freq_control</th>\n",
       "      <th>multi_allele</th>\n",
       "      <th>nobs</th>\n",
       "      <th>Z</th>\n",
       "      <th>coef</th>\n",
       "      <th>std</th>\n",
       "      <th>chisq</th>\n",
       "      <th>df</th>\n",
       "      <th>P</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>20816</th>\n",
       "      <td>144613</td>\n",
       "      <td>continuous</td>\n",
       "      <td>FEV_over_FVC_predicted</td>\n",
       "      <td>7440</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6:30985177_G/A</td>\n",
       "      <td>rs12204947</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.265927</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7440</td>\n",
       "      <td>-5.18377</td>\n",
       "      <td>-0.060131</td>\n",
       "      <td>0.0115999</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.23172e-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68685</th>\n",
       "      <td>475104</td>\n",
       "      <td>continuous</td>\n",
       "      <td>FEV_predicted</td>\n",
       "      <td>7440</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6:34172055_C/A</td>\n",
       "      <td>rs1187115</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.16586</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7440</td>\n",
       "      <td>5.83644</td>\n",
       "      <td>0.0269541</td>\n",
       "      <td>0.00461824</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.55679e-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21318</th>\n",
       "      <td>169288</td>\n",
       "      <td>continuous</td>\n",
       "      <td>FEV_predicted</td>\n",
       "      <td>7440</td>\n",
       "      <td>2</td>\n",
       "      <td>6:34172055_C/A</td>\n",
       "      <td>6:31018788_T/G</td>\n",
       "      <td>rs2517531</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.475067</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7440</td>\n",
       "      <td>-4.35216</td>\n",
       "      <td>-0.0151004</td>\n",
       "      <td>0.00346964</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.36607e-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68741</th>\n",
       "      <td>475496</td>\n",
       "      <td>continuous</td>\n",
       "      <td>FVC_predicted</td>\n",
       "      <td>7441</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6:34205465_G/GGAGCCC</td>\n",
       "      <td>6:34205465_G/GGAGCCC</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.16698</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7441</td>\n",
       "      <td>5.57356</td>\n",
       "      <td>0.0368127</td>\n",
       "      <td>0.00660489</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.58334e-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21307</th>\n",
       "      <td>169200</td>\n",
       "      <td>continuous</td>\n",
       "      <td>FVC_predicted</td>\n",
       "      <td>7441</td>\n",
       "      <td>2</td>\n",
       "      <td>6:34205465_G/GGAGCCC</td>\n",
       "      <td>AX-11396301</td>\n",
       "      <td>rs2517534</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.494955</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7433</td>\n",
       "      <td>4.6301</td>\n",
       "      <td>0.0229209</td>\n",
       "      <td>0.00495041</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.71707e-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29549</th>\n",
       "      <td>204407</td>\n",
       "      <td>continuous</td>\n",
       "      <td>MVV_predicted</td>\n",
       "      <td>7441</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SNPS_B_293_31324643_exon2</td>\n",
       "      <td>rs1050517</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.413073</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7374</td>\n",
       "      <td>-3.29054</td>\n",
       "      <td>-0.415866</td>\n",
       "      <td>0.126382</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00100464</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56431</th>\n",
       "      <td>445472</td>\n",
       "      <td>binary</td>\n",
       "      <td>acute_liver_disease</td>\n",
       "      <td>669/74104</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6:32658375_T/G</td>\n",
       "      <td>rs28371257</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.230942</td>\n",
       "      <td>0.188195</td>\n",
       "      <td>NaN</td>\n",
       "      <td>74773</td>\n",
       "      <td>4.0016</td>\n",
       "      <td>0.261618</td>\n",
       "      <td>0.0653785</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.29163e-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12173</th>\n",
       "      <td>728</td>\n",
       "      <td>continuous</td>\n",
       "      <td>albumin</td>\n",
       "      <td>125069</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HLA_C</td>\n",
       "      <td>HLA-C</td>\n",
       "      <td>phased multiallelic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HLA_C*01:02,HLA_C*03:02,HLA_C*03:03,HLA_C*03:0...</td>\n",
       "      <td>250138</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>132.95</td>\n",
       "      <td>15</td>\n",
       "      <td>5.61403e-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68761</th>\n",
       "      <td>679480</td>\n",
       "      <td>continuous</td>\n",
       "      <td>albumin</td>\n",
       "      <td>125069</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-41950637</td>\n",
       "      <td>6:34215221_G/A</td>\n",
       "      <td>rs928482</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.169802</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>125069</td>\n",
       "      <td>-8.16313</td>\n",
       "      <td>-0.0109551</td>\n",
       "      <td>0.00134202</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.29462e-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22997</th>\n",
       "      <td>251240</td>\n",
       "      <td>continuous</td>\n",
       "      <td>albumin</td>\n",
       "      <td>125069</td>\n",
       "      <td>3</td>\n",
       "      <td>6:34215221_G/A,AX-41950637</td>\n",
       "      <td>AX-15354567</td>\n",
       "      <td>rs4713438</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.156157</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>124849</td>\n",
       "      <td>-5.83045</td>\n",
       "      <td>-0.00817142</td>\n",
       "      <td>0.00140151</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.54147e-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17705</th>\n",
       "      <td>210576</td>\n",
       "      <td>continuous</td>\n",
       "      <td>albumin</td>\n",
       "      <td>125069</td>\n",
       "      <td>4</td>\n",
       "      <td>6:34215221_G/A,AX-15354567,AX-41950637</td>\n",
       "      <td>6:30436315_C/CAT</td>\n",
       "      <td>6:30436315_C/CAT</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.399507</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>125069</td>\n",
       "      <td>5.28305</td>\n",
       "      <td>0.00553228</td>\n",
       "      <td>0.00104718</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.27262e-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54209</th>\n",
       "      <td>481860</td>\n",
       "      <td>binary</td>\n",
       "      <td>allergic_disease</td>\n",
       "      <td>9273/78950</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6:32632237_C/T</td>\n",
       "      <td>rs9274326</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.450448</td>\n",
       "      <td>0.428258</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88223</td>\n",
       "      <td>5.60328</td>\n",
       "      <td>0.0886151</td>\n",
       "      <td>0.0158144</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.10329e-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12809</th>\n",
       "      <td>290996</td>\n",
       "      <td>binary</td>\n",
       "      <td>allergic_disease</td>\n",
       "      <td>9273/78950</td>\n",
       "      <td>2</td>\n",
       "      <td>HLA_DQB1</td>\n",
       "      <td>6:29916650_G/A</td>\n",
       "      <td>rs13215305</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.278011</td>\n",
       "      <td>0.296225</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88223</td>\n",
       "      <td>-5.19572</td>\n",
       "      <td>-0.0932442</td>\n",
       "      <td>0.0179464</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.03927e-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30669</th>\n",
       "      <td>272754</td>\n",
       "      <td>continuous</td>\n",
       "      <td>alt</td>\n",
       "      <td>120788</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6:31351530_T/C</td>\n",
       "      <td>rs2905715</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.272005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>120788</td>\n",
       "      <td>6.52296</td>\n",
       "      <td>0.326987</td>\n",
       "      <td>0.0501286</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.92049e-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68693</th>\n",
       "      <td>678800</td>\n",
       "      <td>continuous</td>\n",
       "      <td>alt</td>\n",
       "      <td>120788</td>\n",
       "      <td>2</td>\n",
       "      <td>6:31351530_T/C</td>\n",
       "      <td>6:34178764_A/C</td>\n",
       "      <td>rs28673163</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.158608</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>120788</td>\n",
       "      <td>-5.47584</td>\n",
       "      <td>-0.334937</td>\n",
       "      <td>0.0611663</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.36296e-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51373</th>\n",
       "      <td>419</td>\n",
       "      <td>continuous</td>\n",
       "      <td>alt</td>\n",
       "      <td>120788</td>\n",
       "      <td>3</td>\n",
       "      <td>6:31351530_T/C,6:34178764_A/C</td>\n",
       "      <td>AA_DQA1_75_32609303_exon2</td>\n",
       "      <td>HLA-DQA1 pos.75</td>\n",
       "      <td>phased biallelic</td>\n",
       "      <td>THIS</td>\n",
       "      <td>...</td>\n",
       "      <td>0.091822</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>241576</td>\n",
       "      <td>-4.61386</td>\n",
       "      <td>-0.356955</td>\n",
       "      <td>0.0773657</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.95259e-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29461</th>\n",
       "      <td>198</td>\n",
       "      <td>binary</td>\n",
       "      <td>angina_pectoris_myocardial_infarction</td>\n",
       "      <td>3077/77843</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AA_B_80_31324497_exon2_T</td>\n",
       "      <td>HLA-B pos.80(T)</td>\n",
       "      <td>phased biallelic</td>\n",
       "      <td>THIS</td>\n",
       "      <td>...</td>\n",
       "      <td>0.233182</td>\n",
       "      <td>0.210616</td>\n",
       "      <td>NaN</td>\n",
       "      <td>161840</td>\n",
       "      <td>4.73328</td>\n",
       "      <td>0.149197</td>\n",
       "      <td>0.0315209</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.20919e-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36489</th>\n",
       "      <td>325134</td>\n",
       "      <td>binary</td>\n",
       "      <td>arthritis</td>\n",
       "      <td>11348/73684</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6:32288790_A/G</td>\n",
       "      <td>rs117475045</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0416814</td>\n",
       "      <td>0.0364801</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85032</td>\n",
       "      <td>4.75784</td>\n",
       "      <td>0.18263</td>\n",
       "      <td>0.0383844</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.95673e-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41723</th>\n",
       "      <td>791</td>\n",
       "      <td>continuous</td>\n",
       "      <td>ast</td>\n",
       "      <td>121162</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HLA_DRB1</td>\n",
       "      <td>HLA-DRB1</td>\n",
       "      <td>phased multiallelic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HLA_DRB1*01:01,HLA_DRB1*03:01,HLA_DRB1*04:03,H...</td>\n",
       "      <td>242324</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>142.453</td>\n",
       "      <td>20</td>\n",
       "      <td>1.73152e-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63263</th>\n",
       "      <td>1498800</td>\n",
       "      <td>continuous</td>\n",
       "      <td>ast</td>\n",
       "      <td>121162</td>\n",
       "      <td>2</td>\n",
       "      <td>6:32202630_G/T,HLA_DQB1</td>\n",
       "      <td>6:33076268_T/C</td>\n",
       "      <td>rs742870</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.385055</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>121162</td>\n",
       "      <td>-5.81671</td>\n",
       "      <td>-0.191552</td>\n",
       "      <td>0.0329314</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.01661e-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68693</th>\n",
       "      <td>2307920</td>\n",
       "      <td>continuous</td>\n",
       "      <td>ast</td>\n",
       "      <td>121162</td>\n",
       "      <td>3</td>\n",
       "      <td>6:32202630_G/T,6:33076268_T/C,HLA_DPB1,HLA_DQB1</td>\n",
       "      <td>6:34178764_A/C</td>\n",
       "      <td>rs28673163</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.158536</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>121162</td>\n",
       "      <td>-4.90892</td>\n",
       "      <td>-0.205566</td>\n",
       "      <td>0.041876</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.16974e-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38500</th>\n",
       "      <td>343233</td>\n",
       "      <td>binary</td>\n",
       "      <td>asthma</td>\n",
       "      <td>2115/78066</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6:32408907_G/A</td>\n",
       "      <td>rs3129879</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.307565</td>\n",
       "      <td>0.340731</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80181</td>\n",
       "      <td>-4.64556</td>\n",
       "      <td>-0.157035</td>\n",
       "      <td>0.0338034</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.39163e-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>671</th>\n",
       "      <td>4697</td>\n",
       "      <td>binary</td>\n",
       "      <td>benign_prostatic_hyperplasia</td>\n",
       "      <td>168/11518</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6:28177492_C/T</td>\n",
       "      <td>rs988084</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.264881</td>\n",
       "      <td>0.190658</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11686</td>\n",
       "      <td>3.75809</td>\n",
       "      <td>0.477103</td>\n",
       "      <td>0.126954</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000171212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37231</th>\n",
       "      <td>258076</td>\n",
       "      <td>binary</td>\n",
       "      <td>big_baby</td>\n",
       "      <td>5057/71304</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6:32354723_CT/C</td>\n",
       "      <td>6:32354723_CT/C</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.312636</td>\n",
       "      <td>0.295516</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51279</td>\n",
       "      <td>3.60374</td>\n",
       "      <td>0.0820407</td>\n",
       "      <td>0.022765</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000313667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64351</th>\n",
       "      <td>508304</td>\n",
       "      <td>binary</td>\n",
       "      <td>bladder_cancer</td>\n",
       "      <td>47/74436</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6:33200591_T/C</td>\n",
       "      <td>rs111327924</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0638298</td>\n",
       "      <td>0.0133202</td>\n",
       "      <td>NaN</td>\n",
       "      <td>74483</td>\n",
       "      <td>3.90304</td>\n",
       "      <td>1.65333</td>\n",
       "      <td>0.423601</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.49928e-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11573</th>\n",
       "      <td>92584</td>\n",
       "      <td>binary</td>\n",
       "      <td>blood_in_urine</td>\n",
       "      <td>1817/14938</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6:29896680_A/G</td>\n",
       "      <td>rs2517754</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.383599</td>\n",
       "      <td>0.432789</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16755</td>\n",
       "      <td>-5.53651</td>\n",
       "      <td>-0.201425</td>\n",
       "      <td>0.0363813</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.08565e-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38146</th>\n",
       "      <td>340047</td>\n",
       "      <td>binary</td>\n",
       "      <td>blood_in_urine</td>\n",
       "      <td>1817/14938</td>\n",
       "      <td>2</td>\n",
       "      <td>6:29896680_A/G</td>\n",
       "      <td>6:32386619_T/C</td>\n",
       "      <td>rs4335021</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.163456</td>\n",
       "      <td>0.196947</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16755</td>\n",
       "      <td>-4.22991</td>\n",
       "      <td>-0.20258</td>\n",
       "      <td>0.0478924</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.33784e-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51369</th>\n",
       "      <td>417</td>\n",
       "      <td>continuous</td>\n",
       "      <td>bmi</td>\n",
       "      <td>124539</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AA_DQA1_69_32609285_exon2_L</td>\n",
       "      <td>HLA-DQA1 pos.69(L)</td>\n",
       "      <td>phased biallelic</td>\n",
       "      <td>THIS</td>\n",
       "      <td>...</td>\n",
       "      <td>0.369836</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>249078</td>\n",
       "      <td>-6.08288</td>\n",
       "      <td>-0.0706937</td>\n",
       "      <td>0.0116218</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.18043e-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4332</th>\n",
       "      <td>95304</td>\n",
       "      <td>continuous</td>\n",
       "      <td>bmi</td>\n",
       "      <td>124539</td>\n",
       "      <td>2</td>\n",
       "      <td>HLA_DQA1</td>\n",
       "      <td>6:29190624_G/A</td>\n",
       "      <td>rs59230085</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.347</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>124539</td>\n",
       "      <td>-6.11132</td>\n",
       "      <td>-0.0745605</td>\n",
       "      <td>0.0122004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.91021e-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68875</th>\n",
       "      <td>1565426</td>\n",
       "      <td>continuous</td>\n",
       "      <td>bmi</td>\n",
       "      <td>124539</td>\n",
       "      <td>3</td>\n",
       "      <td>6:29190624_G/A,HLA_DQA1</td>\n",
       "      <td>6:34244245_C/A</td>\n",
       "      <td>rs4713766</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.123628</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>124539</td>\n",
       "      <td>5.06854</td>\n",
       "      <td>0.0867968</td>\n",
       "      <td>0.0171246</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.01448e-07</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41739</th>\n",
       "      <td>794</td>\n",
       "      <td>continuous</td>\n",
       "      <td>systolic_blood_pressure</td>\n",
       "      <td>124467</td>\n",
       "      <td>2</td>\n",
       "      <td>AX-11365330</td>\n",
       "      <td>HLA_DRB1*04:03</td>\n",
       "      <td>HLA-DRB1*04:03</td>\n",
       "      <td>phased biallelic</td>\n",
       "      <td>THIS</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0260752</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>248934</td>\n",
       "      <td>-4.58033</td>\n",
       "      <td>-0.835254</td>\n",
       "      <td>0.182357</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.64235e-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68714</th>\n",
       "      <td>611109</td>\n",
       "      <td>binary</td>\n",
       "      <td>t2_diabetes</td>\n",
       "      <td>8662/78950</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6:34185749_C/T</td>\n",
       "      <td>rs2797963</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.136169</td>\n",
       "      <td>0.155636</td>\n",
       "      <td>NaN</td>\n",
       "      <td>87612</td>\n",
       "      <td>-6.84964</td>\n",
       "      <td>-0.164752</td>\n",
       "      <td>0.0240526</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.40382e-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35422</th>\n",
       "      <td>350590</td>\n",
       "      <td>binary</td>\n",
       "      <td>t2_diabetes</td>\n",
       "      <td>8662/78950</td>\n",
       "      <td>2</td>\n",
       "      <td>6:34185749_C/T</td>\n",
       "      <td>6:32181182_G/A</td>\n",
       "      <td>rs206016</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.266393</td>\n",
       "      <td>0.282723</td>\n",
       "      <td>NaN</td>\n",
       "      <td>87612</td>\n",
       "      <td>-4.92004</td>\n",
       "      <td>-0.0920078</td>\n",
       "      <td>0.0187005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.65272e-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34182</th>\n",
       "      <td>304371</td>\n",
       "      <td>binary</td>\n",
       "      <td>thyroid_cancer</td>\n",
       "      <td>681/78535</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6:31797422_G/C</td>\n",
       "      <td>rs56280220</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0535977</td>\n",
       "      <td>0.0358821</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79216</td>\n",
       "      <td>3.56435</td>\n",
       "      <td>0.433865</td>\n",
       "      <td>0.121723</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000364753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41723</th>\n",
       "      <td>791</td>\n",
       "      <td>binary</td>\n",
       "      <td>thyroid_disease</td>\n",
       "      <td>5139/75944</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HLA_DRB1</td>\n",
       "      <td>HLA-DRB1</td>\n",
       "      <td>phased multiallelic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HLA_DRB1*01:01,HLA_DRB1*03:01,HLA_DRB1*04:03,H...</td>\n",
       "      <td>162166</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>205.759</td>\n",
       "      <td>20</td>\n",
       "      <td>8.13882e-33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12142</th>\n",
       "      <td>700</td>\n",
       "      <td>binary</td>\n",
       "      <td>thyroid_disease</td>\n",
       "      <td>5139/75944</td>\n",
       "      <td>2</td>\n",
       "      <td>HLA_DQA1</td>\n",
       "      <td>HLA_B</td>\n",
       "      <td>HLA-B</td>\n",
       "      <td>phased multiallelic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HLA_B*07:02,HLA_B*13:01,HLA_B*13:02,HLA_B*14:0...</td>\n",
       "      <td>162166</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>178.414</td>\n",
       "      <td>26</td>\n",
       "      <td>1.10715e-24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41723</th>\n",
       "      <td>791</td>\n",
       "      <td>binary</td>\n",
       "      <td>thyroid_disease</td>\n",
       "      <td>5139/75944</td>\n",
       "      <td>3</td>\n",
       "      <td>6:31430143_G/C,HLA_DQA1</td>\n",
       "      <td>HLA_DRB1</td>\n",
       "      <td>HLA-DRB1</td>\n",
       "      <td>phased multiallelic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HLA_DRB1*01:01,HLA_DRB1*03:01,HLA_DRB1*04:03,H...</td>\n",
       "      <td>162166</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>122.189</td>\n",
       "      <td>20</td>\n",
       "      <td>1.11964e-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41723</th>\n",
       "      <td>791</td>\n",
       "      <td>binary</td>\n",
       "      <td>thyroid_disease</td>\n",
       "      <td>5139/75944</td>\n",
       "      <td>4</td>\n",
       "      <td>6:31430143_G/C,6:31612576_A/T,HLA_DQA1</td>\n",
       "      <td>HLA_DRB1</td>\n",
       "      <td>HLA-DRB1</td>\n",
       "      <td>phased multiallelic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HLA_DRB1*01:01,HLA_DRB1*03:01,HLA_DRB1*04:03,H...</td>\n",
       "      <td>162166</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>102.922</td>\n",
       "      <td>20</td>\n",
       "      <td>3.76534e-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41723</th>\n",
       "      <td>791</td>\n",
       "      <td>binary</td>\n",
       "      <td>thyroid_disease</td>\n",
       "      <td>5139/75944</td>\n",
       "      <td>5</td>\n",
       "      <td>6:31430143_G/C,6:31612576_A/T,6:32641938_G/T,H...</td>\n",
       "      <td>HLA_DRB1</td>\n",
       "      <td>HLA-DRB1</td>\n",
       "      <td>phased multiallelic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HLA_DRB1*01:01,HLA_DRB1*03:01,HLA_DRB1*04:03,H...</td>\n",
       "      <td>162166</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>72.1554</td>\n",
       "      <td>20</td>\n",
       "      <td>8.0688e-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39995</th>\n",
       "      <td>356688</td>\n",
       "      <td>continuous</td>\n",
       "      <td>total_bilirubin</td>\n",
       "      <td>77789</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6:32460867_T/C</td>\n",
       "      <td>rs78325334</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.161739</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>77789</td>\n",
       "      <td>5.4448</td>\n",
       "      <td>0.0092894</td>\n",
       "      <td>0.00170611</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.20203e-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52491</th>\n",
       "      <td>775</td>\n",
       "      <td>continuous</td>\n",
       "      <td>total_cholesterol</td>\n",
       "      <td>125007</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HLA_DQB1</td>\n",
       "      <td>HLA-DQB1</td>\n",
       "      <td>phased multiallelic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HLA_DQB1*02:01,HLA_DQB1*02:02,HLA_DQB1*03:01,H...</td>\n",
       "      <td>250014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>218.204</td>\n",
       "      <td>14</td>\n",
       "      <td>1.02716e-38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61399</th>\n",
       "      <td>1394996</td>\n",
       "      <td>continuous</td>\n",
       "      <td>total_cholesterol</td>\n",
       "      <td>125007</td>\n",
       "      <td>2</td>\n",
       "      <td>HLA_DQB1</td>\n",
       "      <td>AX-11505577</td>\n",
       "      <td>rs443623</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.304134</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>124830</td>\n",
       "      <td>-4.79175</td>\n",
       "      <td>-0.736927</td>\n",
       "      <td>0.153791</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.65519e-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29520</th>\n",
       "      <td>167</td>\n",
       "      <td>binary</td>\n",
       "      <td>transient_ischemic_attacks</td>\n",
       "      <td>59/74437</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AA_B_63_31324548_exon2</td>\n",
       "      <td>HLA-B pos.63</td>\n",
       "      <td>phased biallelic</td>\n",
       "      <td>THIS</td>\n",
       "      <td>...</td>\n",
       "      <td>0.220339</td>\n",
       "      <td>0.3917</td>\n",
       "      <td>NaN</td>\n",
       "      <td>148992</td>\n",
       "      <td>-3.761</td>\n",
       "      <td>-0.835879</td>\n",
       "      <td>0.222249</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000169237</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52491</th>\n",
       "      <td>775</td>\n",
       "      <td>continuous</td>\n",
       "      <td>triglyceride</td>\n",
       "      <td>123426</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HLA_DQB1</td>\n",
       "      <td>HLA-DQB1</td>\n",
       "      <td>phased multiallelic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HLA_DQB1*02:01,HLA_DQB1*02:02,HLA_DQB1*03:01,H...</td>\n",
       "      <td>246852</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>279.431</td>\n",
       "      <td>14</td>\n",
       "      <td>2.26632e-51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68714</th>\n",
       "      <td>1561723</td>\n",
       "      <td>continuous</td>\n",
       "      <td>triglyceride</td>\n",
       "      <td>123426</td>\n",
       "      <td>2</td>\n",
       "      <td>HLA_DQB1</td>\n",
       "      <td>6:34185749_C/T</td>\n",
       "      <td>rs2797963</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.153315</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>123426</td>\n",
       "      <td>-7.42078</td>\n",
       "      <td>-2.76013</td>\n",
       "      <td>0.371946</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.17177e-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34658</th>\n",
       "      <td>823080</td>\n",
       "      <td>continuous</td>\n",
       "      <td>triglyceride</td>\n",
       "      <td>123426</td>\n",
       "      <td>3</td>\n",
       "      <td>6:34185749_C/T,HLA_DQB1</td>\n",
       "      <td>AX-83121875</td>\n",
       "      <td>rs440454</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.294158</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>118241</td>\n",
       "      <td>-5.38871</td>\n",
       "      <td>-1.8815</td>\n",
       "      <td>0.349157</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.11018e-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69788</th>\n",
       "      <td>482825</td>\n",
       "      <td>continuous</td>\n",
       "      <td>tsh</td>\n",
       "      <td>286</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6:34539305_T/C</td>\n",
       "      <td>rs117748192</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0699301</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>286</td>\n",
       "      <td>3.95375</td>\n",
       "      <td>0.618714</td>\n",
       "      <td>0.156488</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.76699e-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3634</th>\n",
       "      <td>25438</td>\n",
       "      <td>binary</td>\n",
       "      <td>tuberculosis</td>\n",
       "      <td>403/11344</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6:28984512_T/C</td>\n",
       "      <td>rs9468464</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0657568</td>\n",
       "      <td>0.0363628</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11747</td>\n",
       "      <td>4.3669</td>\n",
       "      <td>0.645987</td>\n",
       "      <td>0.147929</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.26024e-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11836</th>\n",
       "      <td>106524</td>\n",
       "      <td>binary</td>\n",
       "      <td>urinary_tract_infection</td>\n",
       "      <td>2368/77648</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6:29904453_A/G</td>\n",
       "      <td>rs429762</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0173142</td>\n",
       "      <td>0.0268713</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80016</td>\n",
       "      <td>-3.97955</td>\n",
       "      <td>-0.449889</td>\n",
       "      <td>0.11305</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.90471e-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68715</th>\n",
       "      <td>611118</td>\n",
       "      <td>continuous</td>\n",
       "      <td>waist_circumference</td>\n",
       "      <td>124772</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6:34185755_C/T</td>\n",
       "      <td>rs2797964</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.163578</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>124772</td>\n",
       "      <td>5.2863</td>\n",
       "      <td>0.225496</td>\n",
       "      <td>0.0426566</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.25026e-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12173</th>\n",
       "      <td>728</td>\n",
       "      <td>continuous</td>\n",
       "      <td>wbc</td>\n",
       "      <td>86639</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HLA_C</td>\n",
       "      <td>HLA-C</td>\n",
       "      <td>phased multiallelic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HLA_C*01:02,HLA_C*03:02,HLA_C*03:03,HLA_C*03:0...</td>\n",
       "      <td>173278</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>330.251</td>\n",
       "      <td>15</td>\n",
       "      <td>2.80495e-61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42882</th>\n",
       "      <td>1019904</td>\n",
       "      <td>continuous</td>\n",
       "      <td>wbc</td>\n",
       "      <td>86639</td>\n",
       "      <td>2</td>\n",
       "      <td>HLA_C</td>\n",
       "      <td>SNPS_DRB1_9801_32547719_intron5_A</td>\n",
       "      <td>SNPS_DRB1_9801_32547719_intron5_A</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.464806</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85057</td>\n",
       "      <td>8.8875</td>\n",
       "      <td>0.0702154</td>\n",
       "      <td>0.00790047</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.36847e-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32222</th>\n",
       "      <td>1401796</td>\n",
       "      <td>continuous</td>\n",
       "      <td>wbc</td>\n",
       "      <td>86639</td>\n",
       "      <td>3</td>\n",
       "      <td>HLA_C,HLA_DRB1</td>\n",
       "      <td>6:31428911_A/G</td>\n",
       "      <td>rs2596471</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.239425</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86639</td>\n",
       "      <td>-6.37498</td>\n",
       "      <td>-0.0668564</td>\n",
       "      <td>0.0104873</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.8391e-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68824</th>\n",
       "      <td>3060495</td>\n",
       "      <td>continuous</td>\n",
       "      <td>wbc</td>\n",
       "      <td>86639</td>\n",
       "      <td>4</td>\n",
       "      <td>6:31428911_A/G,HLA_C,HLA_DRB1</td>\n",
       "      <td>6:34234974_A/G</td>\n",
       "      <td>rs117324087</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.124395</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86639</td>\n",
       "      <td>-5.65081</td>\n",
       "      <td>-0.0621543</td>\n",
       "      <td>0.0109992</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.60191e-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11583</th>\n",
       "      <td>532818</td>\n",
       "      <td>continuous</td>\n",
       "      <td>wbc</td>\n",
       "      <td>86639</td>\n",
       "      <td>5</td>\n",
       "      <td>6:31428911_A/G,6:34234974_A/G,HLA_C,HLA_DRB1</td>\n",
       "      <td>6:29897017_C/A</td>\n",
       "      <td>rs434577</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.21937</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86639</td>\n",
       "      <td>-5.14009</td>\n",
       "      <td>-0.0477037</td>\n",
       "      <td>0.00928072</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.75209e-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68741</th>\n",
       "      <td>611352</td>\n",
       "      <td>continuous</td>\n",
       "      <td>weight</td>\n",
       "      <td>124693</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6:34205465_G/GGAGCCC</td>\n",
       "      <td>6:34205465_G/GGAGCCC</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.163153</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>124693</td>\n",
       "      <td>12.5338</td>\n",
       "      <td>0.553022</td>\n",
       "      <td>0.0441226</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.12976e-36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47363</th>\n",
       "      <td>468200</td>\n",
       "      <td>continuous</td>\n",
       "      <td>weight</td>\n",
       "      <td>124693</td>\n",
       "      <td>2</td>\n",
       "      <td>6:34205465_G/GGAGCCC</td>\n",
       "      <td>6:32569297_A/G</td>\n",
       "      <td>rs9270797</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.485777</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>124693</td>\n",
       "      <td>8.08385</td>\n",
       "      <td>0.263069</td>\n",
       "      <td>0.0325425</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.33094e-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3225</th>\n",
       "      <td>77400</td>\n",
       "      <td>continuous</td>\n",
       "      <td>weight</td>\n",
       "      <td>124693</td>\n",
       "      <td>3</td>\n",
       "      <td>6:32569297_A/G,6:34205465_G/GGAGCCC,HLA_DQA1</td>\n",
       "      <td>6:28861320_A/G</td>\n",
       "      <td>rs3135314</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.485897</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>124693</td>\n",
       "      <td>6.86023</td>\n",
       "      <td>0.228396</td>\n",
       "      <td>0.0332928</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.90666e-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20964</th>\n",
       "      <td>520175</td>\n",
       "      <td>continuous</td>\n",
       "      <td>weight</td>\n",
       "      <td>124693</td>\n",
       "      <td>4</td>\n",
       "      <td>6:28861320_A/G,6:32569297_A/G,6:34205465_G/GGA...</td>\n",
       "      <td>6:30990019_A/G</td>\n",
       "      <td>rs9380210</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.435858</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>124693</td>\n",
       "      <td>5.49536</td>\n",
       "      <td>0.189633</td>\n",
       "      <td>0.0345078</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.90667e-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11868</th>\n",
       "      <td>308568</td>\n",
       "      <td>continuous</td>\n",
       "      <td>weight</td>\n",
       "      <td>124693</td>\n",
       "      <td>5</td>\n",
       "      <td>6:28861320_A/G,6:30990019_A/G,6:32569297_A/G,6...</td>\n",
       "      <td>6:29905224_A/T</td>\n",
       "      <td>rs28482016</td>\n",
       "      <td>unphased bialleic</td>\n",
       "      <td>ADD</td>\n",
       "      <td>...</td>\n",
       "      <td>0.472785</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>124693</td>\n",
       "      <td>4.79048</td>\n",
       "      <td>0.166417</td>\n",
       "      <td>0.0347391</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.66576e-06</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>168 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0 phenotype_type                         phenotype_name  \\\n",
       "20816     144613     continuous                 FEV_over_FVC_predicted   \n",
       "68685     475104     continuous                          FEV_predicted   \n",
       "21318     169288     continuous                          FEV_predicted   \n",
       "68741     475496     continuous                          FVC_predicted   \n",
       "21307     169200     continuous                          FVC_predicted   \n",
       "29549     204407     continuous                          MVV_predicted   \n",
       "56431     445472         binary                    acute_liver_disease   \n",
       "12173        728     continuous                                albumin   \n",
       "68761     679480     continuous                                albumin   \n",
       "22997     251240     continuous                                albumin   \n",
       "17705     210576     continuous                                albumin   \n",
       "54209     481860         binary                       allergic_disease   \n",
       "12809     290996         binary                       allergic_disease   \n",
       "30669     272754     continuous                                    alt   \n",
       "68693     678800     continuous                                    alt   \n",
       "51373        419     continuous                                    alt   \n",
       "29461        198         binary  angina_pectoris_myocardial_infarction   \n",
       "36489     325134         binary                              arthritis   \n",
       "41723        791     continuous                                    ast   \n",
       "63263    1498800     continuous                                    ast   \n",
       "68693    2307920     continuous                                    ast   \n",
       "38500     343233         binary                                 asthma   \n",
       "671         4697         binary           benign_prostatic_hyperplasia   \n",
       "37231     258076         binary                               big_baby   \n",
       "64351     508304         binary                         bladder_cancer   \n",
       "11573      92584         binary                         blood_in_urine   \n",
       "38146     340047         binary                         blood_in_urine   \n",
       "51369        417     continuous                                    bmi   \n",
       "4332       95304     continuous                                    bmi   \n",
       "68875    1565426     continuous                                    bmi   \n",
       "...          ...            ...                                    ...   \n",
       "41739        794     continuous                systolic_blood_pressure   \n",
       "68714     611109         binary                            t2_diabetes   \n",
       "35422     350590         binary                            t2_diabetes   \n",
       "34182     304371         binary                         thyroid_cancer   \n",
       "41723        791         binary                        thyroid_disease   \n",
       "12142        700         binary                        thyroid_disease   \n",
       "41723        791         binary                        thyroid_disease   \n",
       "41723        791         binary                        thyroid_disease   \n",
       "41723        791         binary                        thyroid_disease   \n",
       "39995     356688     continuous                        total_bilirubin   \n",
       "52491        775     continuous                      total_cholesterol   \n",
       "61399    1394996     continuous                      total_cholesterol   \n",
       "29520        167         binary             transient_ischemic_attacks   \n",
       "52491        775     continuous                           triglyceride   \n",
       "68714    1561723     continuous                           triglyceride   \n",
       "34658     823080     continuous                           triglyceride   \n",
       "69788     482825     continuous                                    tsh   \n",
       "3634       25438         binary                           tuberculosis   \n",
       "11836     106524         binary                urinary_tract_infection   \n",
       "68715     611118     continuous                    waist_circumference   \n",
       "12173        728     continuous                                    wbc   \n",
       "42882    1019904     continuous                                    wbc   \n",
       "32222    1401796     continuous                                    wbc   \n",
       "68824    3060495     continuous                                    wbc   \n",
       "11583     532818     continuous                                    wbc   \n",
       "68741     611352     continuous                                 weight   \n",
       "47363     468200     continuous                                 weight   \n",
       "3225       77400     continuous                                 weight   \n",
       "20964     520175     continuous                                 weight   \n",
       "11868     308568     continuous                                 weight   \n",
       "\n",
       "      samples(case/control) step  \\\n",
       "20816                  7440    1   \n",
       "68685                  7440    1   \n",
       "21318                  7440    2   \n",
       "68741                  7441    1   \n",
       "21307                  7441    2   \n",
       "29549                  7441    1   \n",
       "56431             669/74104    1   \n",
       "12173                125069    1   \n",
       "68761                125069    2   \n",
       "22997                125069    3   \n",
       "17705                125069    4   \n",
       "54209            9273/78950    1   \n",
       "12809            9273/78950    2   \n",
       "30669                120788    1   \n",
       "68693                120788    2   \n",
       "51373                120788    3   \n",
       "29461            3077/77843    1   \n",
       "36489           11348/73684    1   \n",
       "41723                121162    1   \n",
       "63263                121162    2   \n",
       "68693                121162    3   \n",
       "38500            2115/78066    1   \n",
       "671               168/11518    1   \n",
       "37231            5057/71304    1   \n",
       "64351              47/74436    1   \n",
       "11573            1817/14938    1   \n",
       "38146            1817/14938    2   \n",
       "51369                124539    1   \n",
       "4332                 124539    2   \n",
       "68875                124539    3   \n",
       "...                     ...  ...   \n",
       "41739                124467    2   \n",
       "68714            8662/78950    1   \n",
       "35422            8662/78950    2   \n",
       "34182             681/78535    1   \n",
       "41723            5139/75944    1   \n",
       "12142            5139/75944    2   \n",
       "41723            5139/75944    3   \n",
       "41723            5139/75944    4   \n",
       "41723            5139/75944    5   \n",
       "39995                 77789    1   \n",
       "52491                125007    1   \n",
       "61399                125007    2   \n",
       "29520              59/74437    1   \n",
       "52491                123426    1   \n",
       "68714                123426    2   \n",
       "34658                123426    3   \n",
       "69788                   286    1   \n",
       "3634              403/11344    1   \n",
       "11836            2368/77648    1   \n",
       "68715                124772    1   \n",
       "12173                 86639    1   \n",
       "42882                 86639    2   \n",
       "32222                 86639    3   \n",
       "68824                 86639    4   \n",
       "11583                 86639    5   \n",
       "68741                124693    1   \n",
       "47363                124693    2   \n",
       "3225                 124693    3   \n",
       "20964                124693    4   \n",
       "11868                124693    5   \n",
       "\n",
       "                                               condition  \\\n",
       "20816                                                NaN   \n",
       "68685                                                NaN   \n",
       "21318                                     6:34172055_C/A   \n",
       "68741                                                NaN   \n",
       "21307                               6:34205465_G/GGAGCCC   \n",
       "29549                                                NaN   \n",
       "56431                                                NaN   \n",
       "12173                                                NaN   \n",
       "68761                                        AX-41950637   \n",
       "22997                         6:34215221_G/A,AX-41950637   \n",
       "17705             6:34215221_G/A,AX-15354567,AX-41950637   \n",
       "54209                                                NaN   \n",
       "12809                                           HLA_DQB1   \n",
       "30669                                                NaN   \n",
       "68693                                     6:31351530_T/C   \n",
       "51373                      6:31351530_T/C,6:34178764_A/C   \n",
       "29461                                                NaN   \n",
       "36489                                                NaN   \n",
       "41723                                                NaN   \n",
       "63263                            6:32202630_G/T,HLA_DQB1   \n",
       "68693    6:32202630_G/T,6:33076268_T/C,HLA_DPB1,HLA_DQB1   \n",
       "38500                                                NaN   \n",
       "671                                                  NaN   \n",
       "37231                                                NaN   \n",
       "64351                                                NaN   \n",
       "11573                                                NaN   \n",
       "38146                                     6:29896680_A/G   \n",
       "51369                                                NaN   \n",
       "4332                                            HLA_DQA1   \n",
       "68875                            6:29190624_G/A,HLA_DQA1   \n",
       "...                                                  ...   \n",
       "41739                                        AX-11365330   \n",
       "68714                                                NaN   \n",
       "35422                                     6:34185749_C/T   \n",
       "34182                                                NaN   \n",
       "41723                                                NaN   \n",
       "12142                                           HLA_DQA1   \n",
       "41723                            6:31430143_G/C,HLA_DQA1   \n",
       "41723             6:31430143_G/C,6:31612576_A/T,HLA_DQA1   \n",
       "41723  6:31430143_G/C,6:31612576_A/T,6:32641938_G/T,H...   \n",
       "39995                                                NaN   \n",
       "52491                                                NaN   \n",
       "61399                                           HLA_DQB1   \n",
       "29520                                                NaN   \n",
       "52491                                                NaN   \n",
       "68714                                           HLA_DQB1   \n",
       "34658                            6:34185749_C/T,HLA_DQB1   \n",
       "69788                                                NaN   \n",
       "3634                                                 NaN   \n",
       "11836                                                NaN   \n",
       "68715                                                NaN   \n",
       "12173                                                NaN   \n",
       "42882                                              HLA_C   \n",
       "32222                                     HLA_C,HLA_DRB1   \n",
       "68824                      6:31428911_A/G,HLA_C,HLA_DRB1   \n",
       "11583       6:31428911_A/G,6:34234974_A/G,HLA_C,HLA_DRB1   \n",
       "68741                                                NaN   \n",
       "47363                               6:34205465_G/GGAGCCC   \n",
       "3225        6:32569297_A/G,6:34205465_G/GGAGCCC,HLA_DQA1   \n",
       "20964  6:28861320_A/G,6:32569297_A/G,6:34205465_G/GGA...   \n",
       "11868  6:28861320_A/G,6:30990019_A/G,6:32569297_A/G,6...   \n",
       "\n",
       "                             marker_name                    marker_name_pub  \\\n",
       "20816                     6:30985177_G/A                         rs12204947   \n",
       "68685                     6:34172055_C/A                          rs1187115   \n",
       "21318                     6:31018788_T/G                          rs2517531   \n",
       "68741               6:34205465_G/GGAGCCC               6:34205465_G/GGAGCCC   \n",
       "21307                        AX-11396301                          rs2517534   \n",
       "29549          SNPS_B_293_31324643_exon2                          rs1050517   \n",
       "56431                     6:32658375_T/G                         rs28371257   \n",
       "12173                              HLA_C                              HLA-C   \n",
       "68761                     6:34215221_G/A                           rs928482   \n",
       "22997                        AX-15354567                          rs4713438   \n",
       "17705                   6:30436315_C/CAT                   6:30436315_C/CAT   \n",
       "54209                     6:32632237_C/T                          rs9274326   \n",
       "12809                     6:29916650_G/A                         rs13215305   \n",
       "30669                     6:31351530_T/C                          rs2905715   \n",
       "68693                     6:34178764_A/C                         rs28673163   \n",
       "51373          AA_DQA1_75_32609303_exon2                    HLA-DQA1 pos.75   \n",
       "29461           AA_B_80_31324497_exon2_T                    HLA-B pos.80(T)   \n",
       "36489                     6:32288790_A/G                        rs117475045   \n",
       "41723                           HLA_DRB1                           HLA-DRB1   \n",
       "63263                     6:33076268_T/C                           rs742870   \n",
       "68693                     6:34178764_A/C                         rs28673163   \n",
       "38500                     6:32408907_G/A                          rs3129879   \n",
       "671                       6:28177492_C/T                           rs988084   \n",
       "37231                    6:32354723_CT/C                    6:32354723_CT/C   \n",
       "64351                     6:33200591_T/C                        rs111327924   \n",
       "11573                     6:29896680_A/G                          rs2517754   \n",
       "38146                     6:32386619_T/C                          rs4335021   \n",
       "51369        AA_DQA1_69_32609285_exon2_L                 HLA-DQA1 pos.69(L)   \n",
       "4332                      6:29190624_G/A                         rs59230085   \n",
       "68875                     6:34244245_C/A                          rs4713766   \n",
       "...                                  ...                                ...   \n",
       "41739                     HLA_DRB1*04:03                     HLA-DRB1*04:03   \n",
       "68714                     6:34185749_C/T                          rs2797963   \n",
       "35422                     6:32181182_G/A                           rs206016   \n",
       "34182                     6:31797422_G/C                         rs56280220   \n",
       "41723                           HLA_DRB1                           HLA-DRB1   \n",
       "12142                              HLA_B                              HLA-B   \n",
       "41723                           HLA_DRB1                           HLA-DRB1   \n",
       "41723                           HLA_DRB1                           HLA-DRB1   \n",
       "41723                           HLA_DRB1                           HLA-DRB1   \n",
       "39995                     6:32460867_T/C                         rs78325334   \n",
       "52491                           HLA_DQB1                           HLA-DQB1   \n",
       "61399                        AX-11505577                           rs443623   \n",
       "29520             AA_B_63_31324548_exon2                       HLA-B pos.63   \n",
       "52491                           HLA_DQB1                           HLA-DQB1   \n",
       "68714                     6:34185749_C/T                          rs2797963   \n",
       "34658                        AX-83121875                           rs440454   \n",
       "69788                     6:34539305_T/C                        rs117748192   \n",
       "3634                      6:28984512_T/C                          rs9468464   \n",
       "11836                     6:29904453_A/G                           rs429762   \n",
       "68715                     6:34185755_C/T                          rs2797964   \n",
       "12173                              HLA_C                              HLA-C   \n",
       "42882  SNPS_DRB1_9801_32547719_intron5_A  SNPS_DRB1_9801_32547719_intron5_A   \n",
       "32222                     6:31428911_A/G                          rs2596471   \n",
       "68824                     6:34234974_A/G                        rs117324087   \n",
       "11583                     6:29897017_C/A                           rs434577   \n",
       "68741               6:34205465_G/GGAGCCC               6:34205465_G/GGAGCCC   \n",
       "47363                     6:32569297_A/G                          rs9270797   \n",
       "3225                      6:28861320_A/G                          rs3135314   \n",
       "20964                     6:30990019_A/G                          rs9380210   \n",
       "11868                     6:29905224_A/T                         rs28482016   \n",
       "\n",
       "                      note  term  ... A1_freq_case A1_freq_control  \\\n",
       "20816    unphased bialleic   ADD  ...     0.265927             NaN   \n",
       "68685    unphased bialleic   ADD  ...      0.16586             NaN   \n",
       "21318    unphased bialleic   ADD  ...     0.475067             NaN   \n",
       "68741    unphased bialleic   ADD  ...      0.16698             NaN   \n",
       "21307    unphased bialleic   ADD  ...     0.494955             NaN   \n",
       "29549    unphased bialleic   ADD  ...     0.413073             NaN   \n",
       "56431    unphased bialleic   ADD  ...     0.230942        0.188195   \n",
       "12173  phased multiallelic   NaN  ...          NaN             NaN   \n",
       "68761    unphased bialleic   ADD  ...     0.169802             NaN   \n",
       "22997    unphased bialleic   ADD  ...     0.156157             NaN   \n",
       "17705    unphased bialleic   ADD  ...     0.399507             NaN   \n",
       "54209    unphased bialleic   ADD  ...     0.450448        0.428258   \n",
       "12809    unphased bialleic   ADD  ...     0.278011        0.296225   \n",
       "30669    unphased bialleic   ADD  ...     0.272005             NaN   \n",
       "68693    unphased bialleic   ADD  ...     0.158608             NaN   \n",
       "51373     phased biallelic  THIS  ...     0.091822             NaN   \n",
       "29461     phased biallelic  THIS  ...     0.233182        0.210616   \n",
       "36489    unphased bialleic   ADD  ...    0.0416814       0.0364801   \n",
       "41723  phased multiallelic   NaN  ...          NaN             NaN   \n",
       "63263    unphased bialleic   ADD  ...     0.385055             NaN   \n",
       "68693    unphased bialleic   ADD  ...     0.158536             NaN   \n",
       "38500    unphased bialleic   ADD  ...     0.307565        0.340731   \n",
       "671      unphased bialleic   ADD  ...     0.264881        0.190658   \n",
       "37231    unphased bialleic   ADD  ...     0.312636        0.295516   \n",
       "64351    unphased bialleic   ADD  ...    0.0638298       0.0133202   \n",
       "11573    unphased bialleic   ADD  ...     0.383599        0.432789   \n",
       "38146    unphased bialleic   ADD  ...     0.163456        0.196947   \n",
       "51369     phased biallelic  THIS  ...     0.369836             NaN   \n",
       "4332     unphased bialleic   ADD  ...        0.347             NaN   \n",
       "68875    unphased bialleic   ADD  ...     0.123628             NaN   \n",
       "...                    ...   ...  ...          ...             ...   \n",
       "41739     phased biallelic  THIS  ...    0.0260752             NaN   \n",
       "68714    unphased bialleic   ADD  ...     0.136169        0.155636   \n",
       "35422    unphased bialleic   ADD  ...     0.266393        0.282723   \n",
       "34182    unphased bialleic   ADD  ...    0.0535977       0.0358821   \n",
       "41723  phased multiallelic   NaN  ...          NaN             NaN   \n",
       "12142  phased multiallelic   NaN  ...          NaN             NaN   \n",
       "41723  phased multiallelic   NaN  ...          NaN             NaN   \n",
       "41723  phased multiallelic   NaN  ...          NaN             NaN   \n",
       "41723  phased multiallelic   NaN  ...          NaN             NaN   \n",
       "39995    unphased bialleic   ADD  ...     0.161739             NaN   \n",
       "52491  phased multiallelic   NaN  ...          NaN             NaN   \n",
       "61399    unphased bialleic   ADD  ...     0.304134             NaN   \n",
       "29520     phased biallelic  THIS  ...     0.220339          0.3917   \n",
       "52491  phased multiallelic   NaN  ...          NaN             NaN   \n",
       "68714    unphased bialleic   ADD  ...     0.153315             NaN   \n",
       "34658    unphased bialleic   ADD  ...     0.294158             NaN   \n",
       "69788    unphased bialleic   ADD  ...    0.0699301             NaN   \n",
       "3634     unphased bialleic   ADD  ...    0.0657568       0.0363628   \n",
       "11836    unphased bialleic   ADD  ...    0.0173142       0.0268713   \n",
       "68715    unphased bialleic   ADD  ...     0.163578             NaN   \n",
       "12173  phased multiallelic   NaN  ...          NaN             NaN   \n",
       "42882    unphased bialleic   ADD  ...     0.464806             NaN   \n",
       "32222    unphased bialleic   ADD  ...     0.239425             NaN   \n",
       "68824    unphased bialleic   ADD  ...     0.124395             NaN   \n",
       "11583    unphased bialleic   ADD  ...      0.21937             NaN   \n",
       "68741    unphased bialleic   ADD  ...     0.163153             NaN   \n",
       "47363    unphased bialleic   ADD  ...     0.485777             NaN   \n",
       "3225     unphased bialleic   ADD  ...     0.485897             NaN   \n",
       "20964    unphased bialleic   ADD  ...     0.435858             NaN   \n",
       "11868    unphased bialleic   ADD  ...     0.472785             NaN   \n",
       "\n",
       "                                            multi_allele    nobs        Z  \\\n",
       "20816                                                NaN    7440 -5.18377   \n",
       "68685                                                NaN    7440  5.83644   \n",
       "21318                                                NaN    7440 -4.35216   \n",
       "68741                                                NaN    7441  5.57356   \n",
       "21307                                                NaN    7433   4.6301   \n",
       "29549                                                NaN    7374 -3.29054   \n",
       "56431                                                NaN   74773   4.0016   \n",
       "12173  HLA_C*01:02,HLA_C*03:02,HLA_C*03:03,HLA_C*03:0...  250138      NaN   \n",
       "68761                                                NaN  125069 -8.16313   \n",
       "22997                                                NaN  124849 -5.83045   \n",
       "17705                                                NaN  125069  5.28305   \n",
       "54209                                                NaN   88223  5.60328   \n",
       "12809                                                NaN   88223 -5.19572   \n",
       "30669                                                NaN  120788  6.52296   \n",
       "68693                                                NaN  120788 -5.47584   \n",
       "51373                                                NaN  241576 -4.61386   \n",
       "29461                                                NaN  161840  4.73328   \n",
       "36489                                                NaN   85032  4.75784   \n",
       "41723  HLA_DRB1*01:01,HLA_DRB1*03:01,HLA_DRB1*04:03,H...  242324      NaN   \n",
       "63263                                                NaN  121162 -5.81671   \n",
       "68693                                                NaN  121162 -4.90892   \n",
       "38500                                                NaN   80181 -4.64556   \n",
       "671                                                  NaN   11686  3.75809   \n",
       "37231                                                NaN   51279  3.60374   \n",
       "64351                                                NaN   74483  3.90304   \n",
       "11573                                                NaN   16755 -5.53651   \n",
       "38146                                                NaN   16755 -4.22991   \n",
       "51369                                                NaN  249078 -6.08288   \n",
       "4332                                                 NaN  124539 -6.11132   \n",
       "68875                                                NaN  124539  5.06854   \n",
       "...                                                  ...     ...      ...   \n",
       "41739                                                NaN  248934 -4.58033   \n",
       "68714                                                NaN   87612 -6.84964   \n",
       "35422                                                NaN   87612 -4.92004   \n",
       "34182                                                NaN   79216  3.56435   \n",
       "41723  HLA_DRB1*01:01,HLA_DRB1*03:01,HLA_DRB1*04:03,H...  162166      NaN   \n",
       "12142  HLA_B*07:02,HLA_B*13:01,HLA_B*13:02,HLA_B*14:0...  162166      NaN   \n",
       "41723  HLA_DRB1*01:01,HLA_DRB1*03:01,HLA_DRB1*04:03,H...  162166      NaN   \n",
       "41723  HLA_DRB1*01:01,HLA_DRB1*03:01,HLA_DRB1*04:03,H...  162166      NaN   \n",
       "41723  HLA_DRB1*01:01,HLA_DRB1*03:01,HLA_DRB1*04:03,H...  162166      NaN   \n",
       "39995                                                NaN   77789   5.4448   \n",
       "52491  HLA_DQB1*02:01,HLA_DQB1*02:02,HLA_DQB1*03:01,H...  250014      NaN   \n",
       "61399                                                NaN  124830 -4.79175   \n",
       "29520                                                NaN  148992   -3.761   \n",
       "52491  HLA_DQB1*02:01,HLA_DQB1*02:02,HLA_DQB1*03:01,H...  246852      NaN   \n",
       "68714                                                NaN  123426 -7.42078   \n",
       "34658                                                NaN  118241 -5.38871   \n",
       "69788                                                NaN     286  3.95375   \n",
       "3634                                                 NaN   11747   4.3669   \n",
       "11836                                                NaN   80016 -3.97955   \n",
       "68715                                                NaN  124772   5.2863   \n",
       "12173  HLA_C*01:02,HLA_C*03:02,HLA_C*03:03,HLA_C*03:0...  173278      NaN   \n",
       "42882                                                NaN   85057   8.8875   \n",
       "32222                                                NaN   86639 -6.37498   \n",
       "68824                                                NaN   86639 -5.65081   \n",
       "11583                                                NaN   86639 -5.14009   \n",
       "68741                                                NaN  124693  12.5338   \n",
       "47363                                                NaN  124693  8.08385   \n",
       "3225                                                 NaN  124693  6.86023   \n",
       "20964                                                NaN  124693  5.49536   \n",
       "11868                                                NaN  124693  4.79048   \n",
       "\n",
       "             coef         std    chisq   df            P  \n",
       "20816   -0.060131   0.0115999      NaN  NaN  2.23172e-07  \n",
       "68685   0.0269541  0.00461824      NaN  NaN  5.55679e-09  \n",
       "21318  -0.0151004  0.00346964      NaN  NaN  1.36607e-05  \n",
       "68741   0.0368127  0.00660489      NaN  NaN  2.58334e-08  \n",
       "21307   0.0229209  0.00495041      NaN  NaN  3.71707e-06  \n",
       "29549   -0.415866    0.126382      NaN  NaN   0.00100464  \n",
       "56431    0.261618   0.0653785      NaN  NaN  6.29163e-05  \n",
       "12173         NaN         NaN   132.95   15  5.61403e-21  \n",
       "68761  -0.0109551  0.00134202      NaN  NaN  3.29462e-16  \n",
       "22997 -0.00817142  0.00140151      NaN  NaN  5.54147e-09  \n",
       "17705  0.00553228  0.00104718      NaN  NaN  1.27262e-07  \n",
       "54209   0.0886151   0.0158144      NaN  NaN  2.10329e-08  \n",
       "12809  -0.0932442   0.0179464      NaN  NaN  2.03927e-07  \n",
       "30669    0.326987   0.0501286      NaN  NaN  6.92049e-11  \n",
       "68693   -0.334937   0.0611663      NaN  NaN  4.36296e-08  \n",
       "51373   -0.356955   0.0773657      NaN  NaN  3.95259e-06  \n",
       "29461    0.149197   0.0315209      NaN  NaN  2.20919e-06  \n",
       "36489     0.18263   0.0383844      NaN  NaN  1.95673e-06  \n",
       "41723         NaN         NaN  142.453   20  1.73152e-20  \n",
       "63263   -0.191552   0.0329314      NaN  NaN  6.01661e-09  \n",
       "68693   -0.205566    0.041876      NaN  NaN  9.16974e-07  \n",
       "38500   -0.157035   0.0338034      NaN  NaN  3.39163e-06  \n",
       "671      0.477103    0.126954      NaN  NaN  0.000171212  \n",
       "37231   0.0820407    0.022765      NaN  NaN  0.000313667  \n",
       "64351     1.65333    0.423601      NaN  NaN  9.49928e-05  \n",
       "11573   -0.201425   0.0363813      NaN  NaN  3.08565e-08  \n",
       "38146    -0.20258   0.0478924      NaN  NaN  2.33784e-05  \n",
       "51369  -0.0706937   0.0116218      NaN  NaN  1.18043e-09  \n",
       "4332   -0.0745605   0.0122004      NaN  NaN  9.91021e-10  \n",
       "68875   0.0867968   0.0171246      NaN  NaN  4.01448e-07  \n",
       "...           ...         ...      ...  ...          ...  \n",
       "41739   -0.835254    0.182357      NaN  NaN  4.64235e-06  \n",
       "68714   -0.164752   0.0240526      NaN  NaN  7.40382e-12  \n",
       "35422  -0.0920078   0.0187005      NaN  NaN  8.65272e-07  \n",
       "34182    0.433865    0.121723      NaN  NaN  0.000364753  \n",
       "41723         NaN         NaN  205.759   20  8.13882e-33  \n",
       "12142         NaN         NaN  178.414   26  1.10715e-24  \n",
       "41723         NaN         NaN  122.189   20  1.11964e-16  \n",
       "41723         NaN         NaN  102.922   20  3.76534e-13  \n",
       "41723         NaN         NaN  72.1554   20   8.0688e-08  \n",
       "39995   0.0092894  0.00170611      NaN  NaN  5.20203e-08  \n",
       "52491         NaN         NaN  218.204   14  1.02716e-38  \n",
       "61399   -0.736927    0.153791      NaN  NaN  1.65519e-06  \n",
       "29520   -0.835879    0.222249      NaN  NaN  0.000169237  \n",
       "52491         NaN         NaN  279.431   14  2.26632e-51  \n",
       "68714    -2.76013    0.371946      NaN  NaN  1.17177e-13  \n",
       "34658     -1.8815    0.349157      NaN  NaN  7.11018e-08  \n",
       "69788    0.618714    0.156488      NaN  NaN  9.76699e-05  \n",
       "3634     0.645987    0.147929      NaN  NaN  1.26024e-05  \n",
       "11836   -0.449889     0.11305      NaN  NaN  6.90471e-05  \n",
       "68715    0.225496   0.0426566      NaN  NaN  1.25026e-07  \n",
       "12173         NaN         NaN  330.251   15  2.80495e-61  \n",
       "42882   0.0702154  0.00790047      NaN  NaN  6.36847e-19  \n",
       "32222  -0.0668564   0.0104873      NaN  NaN   1.8391e-10  \n",
       "68824  -0.0621543   0.0109992      NaN  NaN  1.60191e-08  \n",
       "11583  -0.0477037  0.00928072      NaN  NaN  2.75209e-07  \n",
       "68741    0.553022   0.0441226      NaN  NaN  5.12976e-36  \n",
       "47363    0.263069   0.0325425      NaN  NaN  6.33094e-16  \n",
       "3225     0.228396   0.0332928      NaN  NaN  6.90666e-12  \n",
       "20964    0.189633   0.0345078      NaN  NaN  3.90667e-08  \n",
       "11868    0.166417   0.0347391      NaN  NaN  1.66576e-06  \n",
       "\n",
       "[168 rows x 23 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "assoc_result_concat#.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Unnamed: 0                                                          308568\n",
       "phenotype_type                                                  continuous\n",
       "phenotype_name                                                      weight\n",
       "samples(case/control)                                               124693\n",
       "step                                                                     5\n",
       "condition                6:28861320_A/G,6:30990019_A/G,6:32569297_A/G,6...\n",
       "marker_name                                                 6:29905224_A/T\n",
       "marker_name_pub                                                 rs28482016\n",
       "note                                                     unphased bialleic\n",
       "term                                                                   ADD\n",
       "POS                                                               29905224\n",
       "A1                                                                       T\n",
       "A2                                                                       A\n",
       "A1_freq_case                                                      0.472785\n",
       "A1_freq_control                                                        NaN\n",
       "multi_allele                                                           NaN\n",
       "nobs                                                                124693\n",
       "Z                                                                  4.79048\n",
       "coef                                                              0.166417\n",
       "std                                                              0.0347391\n",
       "chisq                                                                  NaN\n",
       "df                                                                     NaN\n",
       "P                                                              1.66576e-06\n",
       "Name: 11868, dtype: object"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result_merge.sort_values('P').iloc[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}