Untitled1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from pyspark.sql import SparkSession"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sparkSession = SparkSession.builder.appName(\"example-pyspark-read-and-write\").getOrCreate()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df=pd.read_csv('ukbb_asthma_cohorts_gwas_annotation.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df=df.fillna('NA')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df.to_csv('ukbb_asthma_cohorts_gwas_annotation_new.csv',index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import time"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1543333306.224215"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "time.time()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df=pd.read_csv('ukbb_asthma_cohorts_gwas_annotation_new.csv').fillna('NA')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df.head()\n",
    "conditions = [\n",
    "    (df['Asthma_CohortA'] == 1) & (df['Asthma_CohortB']==0),\n",
    "    (df['Asthma_CohortA'] == 0) & (df['Asthma_CohortB']==1)]\n",
    "\n",
    "choices = ['NA','1']\n",
    "np.select(conditions, choices)\n",
    "df['Asthma_CohortB']=np.select(conditions, choices)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df.head()\n",
    "conditions = [\n",
    "    (df['Asthma_CohortA'] == 0) & (df['Asthma_CohortB'].str.contains('1')),\n",
    "    (df['Asthma_CohortA'] == 1) & (df['Asthma_CohortB'].str.contains('NA'))\n",
    "    ]\n",
    "    \n",
    "choices = ['NA','1']\n",
    "np.select(conditions, choices)\n",
    "df['Asthma_CohortA']=np.select(conditions, choices)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {
    "collapsed": false
   },
   "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>IID</th>\n",
       "      <th>PC1</th>\n",
       "      <th>PC2</th>\n",
       "      <th>PC3</th>\n",
       "      <th>PC4</th>\n",
       "      <th>PC5</th>\n",
       "      <th>PC6</th>\n",
       "      <th>PC7</th>\n",
       "      <th>PC8</th>\n",
       "      <th>PC9</th>\n",
       "      <th>PC10</th>\n",
       "      <th>sex</th>\n",
       "      <th>age</th>\n",
       "      <th>Asthma_CohortA</th>\n",
       "      <th>Asthma_CohortB</th>\n",
       "      <th>Asthma_CohortAnotB</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>1009140</td>\n",
       "      <td>0.0012</td>\n",
       "      <td>0.0009</td>\n",
       "      <td>0.0005</td>\n",
       "      <td>-0.0005</td>\n",
       "      <td>0.0010</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>-0.0017</td>\n",
       "      <td>0.0032</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>0.0011</td>\n",
       "      <td>1</td>\n",
       "      <td>48</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>1011170</td>\n",
       "      <td>-0.0021</td>\n",
       "      <td>0.0005</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>0.0017</td>\n",
       "      <td>-0.0010</td>\n",
       "      <td>-0.0025</td>\n",
       "      <td>-0.0017</td>\n",
       "      <td>0.0022</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>-0.0019</td>\n",
       "      <td>2</td>\n",
       "      <td>60</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324</th>\n",
       "      <td>1026140</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>-0.0012</td>\n",
       "      <td>0.0010</td>\n",
       "      <td>-0.0012</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>0.0015</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>-0.0016</td>\n",
       "      <td>-0.0020</td>\n",
       "      <td>0.0007</td>\n",
       "      <td>2</td>\n",
       "      <td>57</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>337</th>\n",
       "      <td>1026953</td>\n",
       "      <td>-0.0006</td>\n",
       "      <td>-0.0005</td>\n",
       "      <td>-0.0012</td>\n",
       "      <td>-0.0020</td>\n",
       "      <td>0.0021</td>\n",
       "      <td>0.0020</td>\n",
       "      <td>-0.0022</td>\n",
       "      <td>-0.0024</td>\n",
       "      <td>-0.0005</td>\n",
       "      <td>-0.0007</td>\n",
       "      <td>1</td>\n",
       "      <td>56</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>493</th>\n",
       "      <td>1038133</td>\n",
       "      <td>-0.0013</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>0.0022</td>\n",
       "      <td>-0.0021</td>\n",
       "      <td>0.0017</td>\n",
       "      <td>0.0005</td>\n",
       "      <td>0.0040</td>\n",
       "      <td>-0.0011</td>\n",
       "      <td>0.0011</td>\n",
       "      <td>0.0036</td>\n",
       "      <td>1</td>\n",
       "      <td>63</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>504</th>\n",
       "      <td>1039015</td>\n",
       "      <td>0.0027</td>\n",
       "      <td>0.0003</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>-0.0010</td>\n",
       "      <td>-0.0008</td>\n",
       "      <td>-0.0003</td>\n",
       "      <td>0.0002</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0016</td>\n",
       "      <td>-0.0018</td>\n",
       "      <td>1</td>\n",
       "      <td>69</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>555</th>\n",
       "      <td>1041793</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>-0.0017</td>\n",
       "      <td>0.0002</td>\n",
       "      <td>-0.0014</td>\n",
       "      <td>0.0015</td>\n",
       "      <td>0.0003</td>\n",
       "      <td>-0.0016</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>0.0019</td>\n",
       "      <td>0.0026</td>\n",
       "      <td>2</td>\n",
       "      <td>48</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>619</th>\n",
       "      <td>1046476</td>\n",
       "      <td>0.0019</td>\n",
       "      <td>-0.0007</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>-0.0018</td>\n",
       "      <td>0.0021</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>-0.0008</td>\n",
       "      <td>-0.0032</td>\n",
       "      <td>-0.0034</td>\n",
       "      <td>0.0002</td>\n",
       "      <td>1</td>\n",
       "      <td>54</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>864</th>\n",
       "      <td>1066792</td>\n",
       "      <td>-0.0010</td>\n",
       "      <td>-0.0013</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>0.0002</td>\n",
       "      <td>-0.0020</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>2</td>\n",
       "      <td>42</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>904</th>\n",
       "      <td>1069660</td>\n",
       "      <td>-0.0008</td>\n",
       "      <td>-0.0007</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>0.0015</td>\n",
       "      <td>-0.0023</td>\n",
       "      <td>0.0003</td>\n",
       "      <td>-0.0018</td>\n",
       "      <td>0.0030</td>\n",
       "      <td>-0.0020</td>\n",
       "      <td>2</td>\n",
       "      <td>67</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>926</th>\n",
       "      <td>1071491</td>\n",
       "      <td>-0.0008</td>\n",
       "      <td>-0.0013</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>-0.0011</td>\n",
       "      <td>-0.0006</td>\n",
       "      <td>0.0021</td>\n",
       "      <td>-0.0021</td>\n",
       "      <td>0.0008</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>2</td>\n",
       "      <td>48</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1019</th>\n",
       "      <td>1079020</td>\n",
       "      <td>-0.0007</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>-0.0013</td>\n",
       "      <td>-0.0019</td>\n",
       "      <td>0.0011</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>-0.0034</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>-0.0017</td>\n",
       "      <td>-0.0023</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1033</th>\n",
       "      <td>1080145</td>\n",
       "      <td>0.0018</td>\n",
       "      <td>-0.0002</td>\n",
       "      <td>0.0010</td>\n",
       "      <td>-0.0005</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0027</td>\n",
       "      <td>-0.0011</td>\n",
       "      <td>-0.0005</td>\n",
       "      <td>0.0034</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>1</td>\n",
       "      <td>57</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1037</th>\n",
       "      <td>1080310</td>\n",
       "      <td>-0.0016</td>\n",
       "      <td>-0.0014</td>\n",
       "      <td>0.0005</td>\n",
       "      <td>-0.0040</td>\n",
       "      <td>0.0009</td>\n",
       "      <td>-0.0002</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>0.0014</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>0.0008</td>\n",
       "      <td>2</td>\n",
       "      <td>61</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1047</th>\n",
       "      <td>1081098</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>-0.0030</td>\n",
       "      <td>0.0013</td>\n",
       "      <td>-0.0033</td>\n",
       "      <td>0.0028</td>\n",
       "      <td>-0.0002</td>\n",
       "      <td>0.0031</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0007</td>\n",
       "      <td>0.0009</td>\n",
       "      <td>1</td>\n",
       "      <td>56</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1403</th>\n",
       "      <td>1110751</td>\n",
       "      <td>-0.0005</td>\n",
       "      <td>0.0014</td>\n",
       "      <td>0.0005</td>\n",
       "      <td>-0.0021</td>\n",
       "      <td>0.0016</td>\n",
       "      <td>-0.0005</td>\n",
       "      <td>0.0013</td>\n",
       "      <td>0.0011</td>\n",
       "      <td>-0.0010</td>\n",
       "      <td>0.0003</td>\n",
       "      <td>1</td>\n",
       "      <td>50</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1437</th>\n",
       "      <td>1113524</td>\n",
       "      <td>0.0011</td>\n",
       "      <td>-0.0013</td>\n",
       "      <td>-0.0003</td>\n",
       "      <td>-0.0012</td>\n",
       "      <td>0.0026</td>\n",
       "      <td>-0.0012</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>-0.0002</td>\n",
       "      <td>-0.0020</td>\n",
       "      <td>-0.0035</td>\n",
       "      <td>2</td>\n",
       "      <td>50</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1444</th>\n",
       "      <td>1114261</td>\n",
       "      <td>-0.0010</td>\n",
       "      <td>-0.0026</td>\n",
       "      <td>0.0012</td>\n",
       "      <td>-0.0042</td>\n",
       "      <td>0.0021</td>\n",
       "      <td>0.0003</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>0.0034</td>\n",
       "      <td>0.0018</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>1</td>\n",
       "      <td>65</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1833</th>\n",
       "      <td>1147145</td>\n",
       "      <td>0.0015</td>\n",
       "      <td>-0.0021</td>\n",
       "      <td>-0.0007</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0016</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>-0.0006</td>\n",
       "      <td>0.0020</td>\n",
       "      <td>0.0018</td>\n",
       "      <td>-0.0012</td>\n",
       "      <td>2</td>\n",
       "      <td>54</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1900</th>\n",
       "      <td>1153249</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>-0.0005</td>\n",
       "      <td>-0.0019</td>\n",
       "      <td>0.0002</td>\n",
       "      <td>0.0013</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>-0.0014</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>-0.0030</td>\n",
       "      <td>2</td>\n",
       "      <td>65</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978</th>\n",
       "      <td>1160643</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>-0.0005</td>\n",
       "      <td>0.0008</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>-0.0003</td>\n",
       "      <td>0.0005</td>\n",
       "      <td>0.0009</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>2</td>\n",
       "      <td>59</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2061</th>\n",
       "      <td>1167792</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>-0.0011</td>\n",
       "      <td>-0.0022</td>\n",
       "      <td>-0.0002</td>\n",
       "      <td>-0.0002</td>\n",
       "      <td>-0.0016</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>-0.0014</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>2</td>\n",
       "      <td>58</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2155</th>\n",
       "      <td>1176073</td>\n",
       "      <td>0.0020</td>\n",
       "      <td>-0.0007</td>\n",
       "      <td>-0.0003</td>\n",
       "      <td>-0.0012</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>0.0009</td>\n",
       "      <td>0.0020</td>\n",
       "      <td>-0.0008</td>\n",
       "      <td>-0.0006</td>\n",
       "      <td>0.0005</td>\n",
       "      <td>1</td>\n",
       "      <td>42</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2711</th>\n",
       "      <td>1222955</td>\n",
       "      <td>-0.0016</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>-0.0007</td>\n",
       "      <td>-0.0007</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>-0.0017</td>\n",
       "      <td>-0.0012</td>\n",
       "      <td>-0.0010</td>\n",
       "      <td>1</td>\n",
       "      <td>45</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2763</th>\n",
       "      <td>1226849</td>\n",
       "      <td>-0.0003</td>\n",
       "      <td>-0.0007</td>\n",
       "      <td>0.0013</td>\n",
       "      <td>0.0018</td>\n",
       "      <td>-0.0023</td>\n",
       "      <td>0.0020</td>\n",
       "      <td>-0.0014</td>\n",
       "      <td>0.0014</td>\n",
       "      <td>-0.0034</td>\n",
       "      <td>0.0032</td>\n",
       "      <td>1</td>\n",
       "      <td>66</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2825</th>\n",
       "      <td>1231414</td>\n",
       "      <td>-0.0013</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>-0.0003</td>\n",
       "      <td>0.0014</td>\n",
       "      <td>-0.0007</td>\n",
       "      <td>-0.0022</td>\n",
       "      <td>-0.0012</td>\n",
       "      <td>0.0013</td>\n",
       "      <td>-0.0023</td>\n",
       "      <td>-0.0008</td>\n",
       "      <td>1</td>\n",
       "      <td>44</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2972</th>\n",
       "      <td>1243344</td>\n",
       "      <td>-0.0010</td>\n",
       "      <td>-0.0024</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>0.0015</td>\n",
       "      <td>0.0007</td>\n",
       "      <td>0.0014</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>-0.0008</td>\n",
       "      <td>0.0026</td>\n",
       "      <td>2</td>\n",
       "      <td>61</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2988</th>\n",
       "      <td>1244530</td>\n",
       "      <td>0.0043</td>\n",
       "      <td>-0.0002</td>\n",
       "      <td>0.0011</td>\n",
       "      <td>-0.0010</td>\n",
       "      <td>0.0009</td>\n",
       "      <td>-0.0023</td>\n",
       "      <td>-0.0008</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>-0.0003</td>\n",
       "      <td>-0.0011</td>\n",
       "      <td>2</td>\n",
       "      <td>50</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3029</th>\n",
       "      <td>1247823</td>\n",
       "      <td>0.0002</td>\n",
       "      <td>0.0008</td>\n",
       "      <td>0.0007</td>\n",
       "      <td>-0.0006</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>-0.0017</td>\n",
       "      <td>-0.0008</td>\n",
       "      <td>0.0009</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>0.0003</td>\n",
       "      <td>1</td>\n",
       "      <td>50</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3063</th>\n",
       "      <td>1250829</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>-0.0006</td>\n",
       "      <td>-0.0005</td>\n",
       "      <td>0.0010</td>\n",
       "      <td>-0.0020</td>\n",
       "      <td>-0.0005</td>\n",
       "      <td>0.0014</td>\n",
       "      <td>-0.0020</td>\n",
       "      <td>-0.0011</td>\n",
       "      <td>2</td>\n",
       "      <td>57</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59026</th>\n",
       "      <td>5852096</td>\n",
       "      <td>-0.0010</td>\n",
       "      <td>-0.0006</td>\n",
       "      <td>-0.0007</td>\n",
       "      <td>0.0012</td>\n",
       "      <td>-0.0011</td>\n",
       "      <td>0.0003</td>\n",
       "      <td>-0.0010</td>\n",
       "      <td>0.0005</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>-0.0003</td>\n",
       "      <td>1</td>\n",
       "      <td>49</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59064</th>\n",
       "      <td>5855259</td>\n",
       "      <td>-0.0007</td>\n",
       "      <td>-0.0007</td>\n",
       "      <td>-0.0003</td>\n",
       "      <td>0.0011</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>-0.0023</td>\n",
       "      <td>-0.0005</td>\n",
       "      <td>0.0008</td>\n",
       "      <td>0.0022</td>\n",
       "      <td>-0.0003</td>\n",
       "      <td>1</td>\n",
       "      <td>68</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59178</th>\n",
       "      <td>5863549</td>\n",
       "      <td>0.0014</td>\n",
       "      <td>-0.0003</td>\n",
       "      <td>-0.0058</td>\n",
       "      <td>-0.0018</td>\n",
       "      <td>0.0020</td>\n",
       "      <td>0.0059</td>\n",
       "      <td>-0.0082</td>\n",
       "      <td>-0.0025</td>\n",
       "      <td>-0.0008</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>2</td>\n",
       "      <td>64</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59230</th>\n",
       "      <td>5866798</td>\n",
       "      <td>0.0030</td>\n",
       "      <td>0.0012</td>\n",
       "      <td>0.0002</td>\n",
       "      <td>-0.0016</td>\n",
       "      <td>0.0013</td>\n",
       "      <td>0.0003</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>-0.0008</td>\n",
       "      <td>-0.0028</td>\n",
       "      <td>2</td>\n",
       "      <td>47</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59313</th>\n",
       "      <td>5874022</td>\n",
       "      <td>-0.0002</td>\n",
       "      <td>-0.0013</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>-0.0041</td>\n",
       "      <td>0.0016</td>\n",
       "      <td>0.0026</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>-0.0034</td>\n",
       "      <td>-0.0012</td>\n",
       "      <td>0.0012</td>\n",
       "      <td>1</td>\n",
       "      <td>58</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59350</th>\n",
       "      <td>5876308</td>\n",
       "      <td>-0.0014</td>\n",
       "      <td>-0.0022</td>\n",
       "      <td>0.0014</td>\n",
       "      <td>-0.0016</td>\n",
       "      <td>0.0021</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>0.0003</td>\n",
       "      <td>0.0007</td>\n",
       "      <td>-0.0016</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>2</td>\n",
       "      <td>60</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59389</th>\n",
       "      <td>5878891</td>\n",
       "      <td>0.0047</td>\n",
       "      <td>0.0007</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>-0.0017</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>-0.0024</td>\n",
       "      <td>0.0008</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>0.0005</td>\n",
       "      <td>0.0011</td>\n",
       "      <td>2</td>\n",
       "      <td>66</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59684</th>\n",
       "      <td>5902112</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>-0.0010</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>-0.0023</td>\n",
       "      <td>0.0010</td>\n",
       "      <td>-0.0005</td>\n",
       "      <td>-0.0011</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>2</td>\n",
       "      <td>48</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59806</th>\n",
       "      <td>5913128</td>\n",
       "      <td>0.0019</td>\n",
       "      <td>-0.0003</td>\n",
       "      <td>-0.0007</td>\n",
       "      <td>0.0013</td>\n",
       "      <td>-0.0002</td>\n",
       "      <td>0.0013</td>\n",
       "      <td>0.0008</td>\n",
       "      <td>0.0018</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>-0.0005</td>\n",
       "      <td>1</td>\n",
       "      <td>55</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59808</th>\n",
       "      <td>5913176</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>0.0007</td>\n",
       "      <td>0.0005</td>\n",
       "      <td>0.0011</td>\n",
       "      <td>-0.0007</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>0.0005</td>\n",
       "      <td>0.0005</td>\n",
       "      <td>0.0013</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>2</td>\n",
       "      <td>58</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59842</th>\n",
       "      <td>5915992</td>\n",
       "      <td>-0.0008</td>\n",
       "      <td>-0.0014</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>-0.0031</td>\n",
       "      <td>-0.0011</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>-0.0002</td>\n",
       "      <td>-0.0014</td>\n",
       "      <td>-0.0005</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>2</td>\n",
       "      <td>55</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59923</th>\n",
       "      <td>5921844</td>\n",
       "      <td>0.0022</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>-0.0010</td>\n",
       "      <td>-0.0013</td>\n",
       "      <td>0.0011</td>\n",
       "      <td>-0.0032</td>\n",
       "      <td>-0.0002</td>\n",
       "      <td>-0.0011</td>\n",
       "      <td>0.0039</td>\n",
       "      <td>0.0007</td>\n",
       "      <td>2</td>\n",
       "      <td>61</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60060</th>\n",
       "      <td>5933010</td>\n",
       "      <td>0.0038</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>0.0019</td>\n",
       "      <td>0.0013</td>\n",
       "      <td>-0.0007</td>\n",
       "      <td>0.0010</td>\n",
       "      <td>-0.0018</td>\n",
       "      <td>0.0018</td>\n",
       "      <td>-0.0010</td>\n",
       "      <td>0.0018</td>\n",
       "      <td>2</td>\n",
       "      <td>55</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60163</th>\n",
       "      <td>5942761</td>\n",
       "      <td>-0.0022</td>\n",
       "      <td>0.0089</td>\n",
       "      <td>0.0005</td>\n",
       "      <td>-0.0041</td>\n",
       "      <td>0.0021</td>\n",
       "      <td>0.0016</td>\n",
       "      <td>0.0023</td>\n",
       "      <td>0.0019</td>\n",
       "      <td>-0.0002</td>\n",
       "      <td>-0.0021</td>\n",
       "      <td>1</td>\n",
       "      <td>48</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60217</th>\n",
       "      <td>5948549</td>\n",
       "      <td>-0.0014</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>-0.0017</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>-0.0012</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>0.0018</td>\n",
       "      <td>-0.0014</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>2</td>\n",
       "      <td>54</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60413</th>\n",
       "      <td>5964883</td>\n",
       "      <td>-0.0002</td>\n",
       "      <td>-0.0006</td>\n",
       "      <td>0.0009</td>\n",
       "      <td>-0.0025</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0003</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>-0.0008</td>\n",
       "      <td>-0.0023</td>\n",
       "      <td>-0.0013</td>\n",
       "      <td>2</td>\n",
       "      <td>43</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60463</th>\n",
       "      <td>5969909</td>\n",
       "      <td>-0.0015</td>\n",
       "      <td>-0.0014</td>\n",
       "      <td>-0.0003</td>\n",
       "      <td>-0.0020</td>\n",
       "      <td>0.0009</td>\n",
       "      <td>0.0003</td>\n",
       "      <td>0.0019</td>\n",
       "      <td>-0.0005</td>\n",
       "      <td>0.0038</td>\n",
       "      <td>-0.0002</td>\n",
       "      <td>2</td>\n",
       "      <td>43</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60557</th>\n",
       "      <td>5978554</td>\n",
       "      <td>0.0039</td>\n",
       "      <td>0.0017</td>\n",
       "      <td>-0.0003</td>\n",
       "      <td>0.0008</td>\n",
       "      <td>0.0002</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>-0.0023</td>\n",
       "      <td>-0.0030</td>\n",
       "      <td>0.0003</td>\n",
       "      <td>0.0011</td>\n",
       "      <td>2</td>\n",
       "      <td>57</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60559</th>\n",
       "      <td>5978665</td>\n",
       "      <td>0.0008</td>\n",
       "      <td>-0.0013</td>\n",
       "      <td>0.0008</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>-0.0007</td>\n",
       "      <td>0.0021</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>-0.0011</td>\n",
       "      <td>-0.0008</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>2</td>\n",
       "      <td>42</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60563</th>\n",
       "      <td>5979011</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>0.0003</td>\n",
       "      <td>0.0008</td>\n",
       "      <td>-0.0008</td>\n",
       "      <td>-0.0010</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>0.0021</td>\n",
       "      <td>0.0008</td>\n",
       "      <td>-0.0027</td>\n",
       "      <td>-0.0012</td>\n",
       "      <td>2</td>\n",
       "      <td>59</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60579</th>\n",
       "      <td>5979819</td>\n",
       "      <td>-0.0018</td>\n",
       "      <td>-0.0006</td>\n",
       "      <td>0.0020</td>\n",
       "      <td>-0.0010</td>\n",
       "      <td>-0.0007</td>\n",
       "      <td>-0.0006</td>\n",
       "      <td>0.0010</td>\n",
       "      <td>-0.0011</td>\n",
       "      <td>0.0028</td>\n",
       "      <td>-0.0002</td>\n",
       "      <td>2</td>\n",
       "      <td>51</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60603</th>\n",
       "      <td>5981699</td>\n",
       "      <td>-0.0008</td>\n",
       "      <td>-0.0003</td>\n",
       "      <td>-0.0022</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>-0.0011</td>\n",
       "      <td>-0.0002</td>\n",
       "      <td>0.0005</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>2</td>\n",
       "      <td>54</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60634</th>\n",
       "      <td>5983379</td>\n",
       "      <td>0.0014</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>0.0014</td>\n",
       "      <td>-0.0027</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>0.0011</td>\n",
       "      <td>-0.0020</td>\n",
       "      <td>-0.0006</td>\n",
       "      <td>2</td>\n",
       "      <td>59</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60649</th>\n",
       "      <td>5984332</td>\n",
       "      <td>-0.0011</td>\n",
       "      <td>-0.0010</td>\n",
       "      <td>-0.0012</td>\n",
       "      <td>-0.0011</td>\n",
       "      <td>0.0005</td>\n",
       "      <td>-0.0006</td>\n",
       "      <td>-0.0018</td>\n",
       "      <td>-0.0008</td>\n",
       "      <td>-0.0002</td>\n",
       "      <td>0.0003</td>\n",
       "      <td>1</td>\n",
       "      <td>46</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60771</th>\n",
       "      <td>5993495</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>-0.0015</td>\n",
       "      <td>0.0012</td>\n",
       "      <td>-0.0025</td>\n",
       "      <td>0.0002</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>0.0011</td>\n",
       "      <td>-0.0024</td>\n",
       "      <td>-0.0046</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>1</td>\n",
       "      <td>59</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60808</th>\n",
       "      <td>5997017</td>\n",
       "      <td>-0.0012</td>\n",
       "      <td>-0.0019</td>\n",
       "      <td>0.0021</td>\n",
       "      <td>-0.0027</td>\n",
       "      <td>0.0016</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>0.0012</td>\n",
       "      <td>0.0032</td>\n",
       "      <td>0.0010</td>\n",
       "      <td>-0.0014</td>\n",
       "      <td>1</td>\n",
       "      <td>47</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60855</th>\n",
       "      <td>6000718</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>-0.0005</td>\n",
       "      <td>0.0007</td>\n",
       "      <td>-0.0005</td>\n",
       "      <td>0.0003</td>\n",
       "      <td>-0.0015</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>0.0003</td>\n",
       "      <td>-0.0008</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>2</td>\n",
       "      <td>64</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60889</th>\n",
       "      <td>6003445</td>\n",
       "      <td>0.0013</td>\n",
       "      <td>-0.0002</td>\n",
       "      <td>0.0005</td>\n",
       "      <td>-0.0005</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>0.0018</td>\n",
       "      <td>0.0018</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>0.0003</td>\n",
       "      <td>2</td>\n",
       "      <td>63</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60908</th>\n",
       "      <td>6005280</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>-0.0006</td>\n",
       "      <td>0.0013</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0019</td>\n",
       "      <td>-0.0006</td>\n",
       "      <td>-0.0011</td>\n",
       "      <td>0.0019</td>\n",
       "      <td>-0.0013</td>\n",
       "      <td>1</td>\n",
       "      <td>43</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61050</th>\n",
       "      <td>6016140</td>\n",
       "      <td>-0.0008</td>\n",
       "      <td>-0.0026</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>0.0019</td>\n",
       "      <td>0.0014</td>\n",
       "      <td>-0.0010</td>\n",
       "      <td>-0.0007</td>\n",
       "      <td>-0.0016</td>\n",
       "      <td>-0.0057</td>\n",
       "      <td>1</td>\n",
       "      <td>51</td>\n",
       "      <td>NA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>645 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           IID     PC1     PC2     PC3     PC4     PC5     PC6     PC7  \\\n",
       "103    1009140  0.0012  0.0009  0.0005 -0.0005  0.0010 -0.0004 -0.0017   \n",
       "130    1011170 -0.0021  0.0005  0.0001  0.0017 -0.0010 -0.0025 -0.0017   \n",
       "324    1026140  0.0001 -0.0012  0.0010 -0.0012  0.0004  0.0015  0.0006   \n",
       "337    1026953 -0.0006 -0.0005 -0.0012 -0.0020  0.0021  0.0020 -0.0022   \n",
       "493    1038133 -0.0013 -0.0009  0.0022 -0.0021  0.0017  0.0005  0.0040   \n",
       "504    1039015  0.0027  0.0003  0.0004 -0.0010 -0.0008 -0.0003  0.0002   \n",
       "555    1041793 -0.0004 -0.0017  0.0002 -0.0014  0.0015  0.0003 -0.0016   \n",
       "619    1046476  0.0019 -0.0007  0.0006 -0.0018  0.0021 -0.0009 -0.0008   \n",
       "864    1066792 -0.0010 -0.0013  0.0001 -0.0009 -0.0009  0.0004  0.0002   \n",
       "904    1069660 -0.0008 -0.0007  0.0000 -0.0001  0.0015 -0.0023  0.0003   \n",
       "926    1071491 -0.0008 -0.0013 -0.0004 -0.0009 -0.0011 -0.0006  0.0021   \n",
       "1019   1079020 -0.0007 -0.0004 -0.0013 -0.0019  0.0011  0.0001 -0.0034   \n",
       "1033   1080145  0.0018 -0.0002  0.0010 -0.0005  0.0000  0.0027 -0.0011   \n",
       "1037   1080310 -0.0016 -0.0014  0.0005 -0.0040  0.0009 -0.0002 -0.0001   \n",
       "1047   1081098 -0.0009 -0.0030  0.0013 -0.0033  0.0028 -0.0002  0.0031   \n",
       "1403   1110751 -0.0005  0.0014  0.0005 -0.0021  0.0016 -0.0005  0.0013   \n",
       "1437   1113524  0.0011 -0.0013 -0.0003 -0.0012  0.0026 -0.0012 -0.0001   \n",
       "1444   1114261 -0.0010 -0.0026  0.0012 -0.0042  0.0021  0.0003  0.0001   \n",
       "1833   1147145  0.0015 -0.0021 -0.0007  0.0000  0.0016 -0.0004 -0.0006   \n",
       "1900   1153249 -0.0009 -0.0005 -0.0019  0.0002  0.0013  0.0004 -0.0001   \n",
       "1978   1160643 -0.0004 -0.0005  0.0008 -0.0004 -0.0004 -0.0003  0.0005   \n",
       "2061   1167792 -0.0009 -0.0011 -0.0022 -0.0002 -0.0002 -0.0016  0.0006   \n",
       "2155   1176073  0.0020 -0.0007 -0.0003 -0.0012 -0.0001  0.0009  0.0020   \n",
       "2711   1222955 -0.0016  0.0004 -0.0009 -0.0007 -0.0007 -0.0004  0.0004   \n",
       "2763   1226849 -0.0003 -0.0007  0.0013  0.0018 -0.0023  0.0020 -0.0014   \n",
       "2825   1231414 -0.0013 -0.0004 -0.0003  0.0014 -0.0007 -0.0022 -0.0012   \n",
       "2972   1243344 -0.0010 -0.0024  0.0006 -0.0004  0.0015  0.0007  0.0014   \n",
       "2988   1244530  0.0043 -0.0002  0.0011 -0.0010  0.0009 -0.0023 -0.0008   \n",
       "3029   1247823  0.0002  0.0008  0.0007 -0.0006 -0.0001 -0.0017 -0.0008   \n",
       "3063   1250829 -0.0004 -0.0004 -0.0006 -0.0005  0.0010 -0.0020 -0.0005   \n",
       "...        ...     ...     ...     ...     ...     ...     ...     ...   \n",
       "59026  5852096 -0.0010 -0.0006 -0.0007  0.0012 -0.0011  0.0003 -0.0010   \n",
       "59064  5855259 -0.0007 -0.0007 -0.0003  0.0011  0.0004 -0.0023 -0.0005   \n",
       "59178  5863549  0.0014 -0.0003 -0.0058 -0.0018  0.0020  0.0059 -0.0082   \n",
       "59230  5866798  0.0030  0.0012  0.0002 -0.0016  0.0013  0.0003  0.0000   \n",
       "59313  5874022 -0.0002 -0.0013  0.0006 -0.0041  0.0016  0.0026  0.0000   \n",
       "59350  5876308 -0.0014 -0.0022  0.0014 -0.0016  0.0021  0.0006  0.0003   \n",
       "59389  5878891  0.0047  0.0007  0.0004 -0.0017  0.0006 -0.0024  0.0008   \n",
       "59684  5902112 -0.0001 -0.0004 -0.0010 -0.0004 -0.0004 -0.0023  0.0010   \n",
       "59806  5913128  0.0019 -0.0003 -0.0007  0.0013 -0.0002  0.0013  0.0008   \n",
       "59808  5913176  0.0001  0.0007  0.0005  0.0011 -0.0007  0.0001  0.0005   \n",
       "59842  5915992 -0.0008 -0.0014  0.0006 -0.0031 -0.0011 -0.0001 -0.0002   \n",
       "59923  5921844  0.0022 -0.0004 -0.0010 -0.0013  0.0011 -0.0032 -0.0002   \n",
       "60060  5933010  0.0038  0.0004  0.0019  0.0013 -0.0007  0.0010 -0.0018   \n",
       "60163  5942761 -0.0022  0.0089  0.0005 -0.0041  0.0021  0.0016  0.0023   \n",
       "60217  5948549 -0.0014 -0.0001  0.0006 -0.0017 -0.0001 -0.0012 -0.0001   \n",
       "60413  5964883 -0.0002 -0.0006  0.0009 -0.0025  0.0000  0.0003  0.0006   \n",
       "60463  5969909 -0.0015 -0.0014 -0.0003 -0.0020  0.0009  0.0003  0.0019   \n",
       "60557  5978554  0.0039  0.0017 -0.0003  0.0008  0.0002 -0.0009 -0.0023   \n",
       "60559  5978665  0.0008 -0.0013  0.0008  0.0004 -0.0007  0.0021  0.0004   \n",
       "60563  5979011  0.0001  0.0003  0.0008 -0.0008 -0.0010  0.0004  0.0021   \n",
       "60579  5979819 -0.0018 -0.0006  0.0020 -0.0010 -0.0007 -0.0006  0.0010   \n",
       "60603  5981699 -0.0008 -0.0003 -0.0022  0.0000  0.0006  0.0006 -0.0011   \n",
       "60634  5983379  0.0014  0.0006  0.0006 -0.0009  0.0014 -0.0027  0.0004   \n",
       "60649  5984332 -0.0011 -0.0010 -0.0012 -0.0011  0.0005 -0.0006 -0.0018   \n",
       "60771  5993495  0.0001 -0.0015  0.0012 -0.0025  0.0002  0.0004  0.0011   \n",
       "60808  5997017 -0.0012 -0.0019  0.0021 -0.0027  0.0016  0.0004  0.0012   \n",
       "60855  6000718 -0.0009 -0.0005  0.0007 -0.0005  0.0003 -0.0015  0.0004   \n",
       "60889  6003445  0.0013 -0.0002  0.0005 -0.0005 -0.0001  0.0018  0.0018   \n",
       "60908  6005280  0.0001 -0.0006  0.0013 -0.0004  0.0000  0.0019 -0.0006   \n",
       "61050  6016140 -0.0008 -0.0026 -0.0009 -0.0004  0.0019  0.0014 -0.0010   \n",
       "\n",
       "          PC8     PC9    PC10  sex  age Asthma_CohortA Asthma_CohortB  \\\n",
       "103    0.0032  0.0001  0.0011    1   48             NA              1   \n",
       "130    0.0022 -0.0001 -0.0019    2   60             NA              1   \n",
       "324   -0.0016 -0.0020  0.0007    2   57             NA              1   \n",
       "337   -0.0024 -0.0005 -0.0007    1   56             NA              1   \n",
       "493   -0.0011  0.0011  0.0036    1   63             NA              1   \n",
       "504    0.0000  0.0016 -0.0018    1   69             NA              1   \n",
       "555   -0.0001  0.0019  0.0026    2   48             NA              1   \n",
       "619   -0.0032 -0.0034  0.0002    1   54             NA              1   \n",
       "864   -0.0020  0.0000  0.0000    2   42             NA              1   \n",
       "904   -0.0018  0.0030 -0.0020    2   67             NA              1   \n",
       "926   -0.0021  0.0008  0.0004    2   48             NA              1   \n",
       "1019   0.0006 -0.0017 -0.0023    1   52             NA              1   \n",
       "1033  -0.0005  0.0034 -0.0004    1   57             NA              1   \n",
       "1037   0.0014  0.0004  0.0008    2   61             NA              1   \n",
       "1047   0.0000  0.0007  0.0009    1   56             NA              1   \n",
       "1403   0.0011 -0.0010  0.0003    1   50             NA              1   \n",
       "1437  -0.0002 -0.0020 -0.0035    2   50             NA              1   \n",
       "1444   0.0034  0.0018  0.0004    1   65             NA              1   \n",
       "1833   0.0020  0.0018 -0.0012    2   54             NA              1   \n",
       "1900  -0.0014  0.0006 -0.0030    2   65             NA              1   \n",
       "1978   0.0009  0.0001 -0.0009    2   59             NA              1   \n",
       "2061  -0.0014  0.0001 -0.0009    2   58             NA              1   \n",
       "2155  -0.0008 -0.0006  0.0005    1   42             NA              1   \n",
       "2711  -0.0017 -0.0012 -0.0010    1   45             NA              1   \n",
       "2763   0.0014 -0.0034  0.0032    1   66             NA              1   \n",
       "2825   0.0013 -0.0023 -0.0008    1   44             NA              1   \n",
       "2972  -0.0009 -0.0008  0.0026    2   61             NA              1   \n",
       "2988  -0.0009 -0.0003 -0.0011    2   50             NA              1   \n",
       "3029   0.0009 -0.0001  0.0003    1   50             NA              1   \n",
       "3063   0.0014 -0.0020 -0.0011    2   57             NA              1   \n",
       "...       ...     ...     ...  ...  ...            ...            ...   \n",
       "59026  0.0005  0.0000 -0.0003    1   49             NA              1   \n",
       "59064  0.0008  0.0022 -0.0003    1   68             NA              1   \n",
       "59178 -0.0025 -0.0008 -0.0009    2   64             NA              1   \n",
       "59230  0.0000 -0.0008 -0.0028    2   47             NA              1   \n",
       "59313 -0.0034 -0.0012  0.0012    1   58             NA              1   \n",
       "59350  0.0007 -0.0016  0.0006    2   60             NA              1   \n",
       "59389  0.0006  0.0005  0.0011    2   66             NA              1   \n",
       "59684 -0.0005 -0.0011  0.0000    2   48             NA              1   \n",
       "59806  0.0018  0.0006 -0.0005    1   55             NA              1   \n",
       "59808  0.0005  0.0013 -0.0004    2   58             NA              1   \n",
       "59842 -0.0014 -0.0005 -0.0009    2   55             NA              1   \n",
       "59923 -0.0011  0.0039  0.0007    2   61             NA              1   \n",
       "60060  0.0018 -0.0010  0.0018    2   55             NA              1   \n",
       "60163  0.0019 -0.0002 -0.0021    1   48             NA              1   \n",
       "60217  0.0018 -0.0014 -0.0004    2   54             NA              1   \n",
       "60413 -0.0008 -0.0023 -0.0013    2   43             NA              1   \n",
       "60463 -0.0005  0.0038 -0.0002    2   43             NA              1   \n",
       "60557 -0.0030  0.0003  0.0011    2   57             NA              1   \n",
       "60559 -0.0011 -0.0008 -0.0009    2   42             NA              1   \n",
       "60563  0.0008 -0.0027 -0.0012    2   59             NA              1   \n",
       "60579 -0.0011  0.0028 -0.0002    2   51             NA              1   \n",
       "60603 -0.0002  0.0005  0.0001    2   54             NA              1   \n",
       "60634  0.0011 -0.0020 -0.0006    2   59             NA              1   \n",
       "60649 -0.0008 -0.0002  0.0003    1   46             NA              1   \n",
       "60771 -0.0024 -0.0046 -0.0004    1   59             NA              1   \n",
       "60808  0.0032  0.0010 -0.0014    1   47             NA              1   \n",
       "60855  0.0003 -0.0008  0.0004    2   64             NA              1   \n",
       "60889 -0.0004 -0.0004  0.0003    2   63             NA              1   \n",
       "60908 -0.0011  0.0019 -0.0013    1   43             NA              1   \n",
       "61050 -0.0007 -0.0016 -0.0057    1   51             NA              1   \n",
       "\n",
       "      Asthma_CohortAnotB  \n",
       "103                    0  \n",
       "130                    0  \n",
       "324                    0  \n",
       "337                    0  \n",
       "493                    0  \n",
       "504                    0  \n",
       "555                    0  \n",
       "619                    0  \n",
       "864                    0  \n",
       "904                    0  \n",
       "926                    0  \n",
       "1019                   0  \n",
       "1033                   0  \n",
       "1037                   0  \n",
       "1047                   0  \n",
       "1403                   0  \n",
       "1437                   0  \n",
       "1444                   0  \n",
       "1833                   0  \n",
       "1900                   0  \n",
       "1978                   0  \n",
       "2061                   0  \n",
       "2155                   0  \n",
       "2711                   0  \n",
       "2763                   0  \n",
       "2825                   0  \n",
       "2972                   0  \n",
       "2988                   0  \n",
       "3029                   0  \n",
       "3063                   0  \n",
       "...                  ...  \n",
       "59026                  0  \n",
       "59064                  0  \n",
       "59178                  0  \n",
       "59230                  0  \n",
       "59313                  0  \n",
       "59350                  0  \n",
       "59389                  0  \n",
       "59684                  0  \n",
       "59806                  0  \n",
       "59808                  0  \n",
       "59842                  0  \n",
       "59923                  0  \n",
       "60060                  0  \n",
       "60163                  0  \n",
       "60217                  0  \n",
       "60413                  0  \n",
       "60463                  0  \n",
       "60557                  0  \n",
       "60559                  0  \n",
       "60563                  0  \n",
       "60579                  0  \n",
       "60603                  0  \n",
       "60634                  0  \n",
       "60649                  0  \n",
       "60771                  0  \n",
       "60808                  0  \n",
       "60855                  0  \n",
       "60889                  0  \n",
       "60908                  0  \n",
       "61050                  0  \n",
       "\n",
       "[645 rows x 16 columns]"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df.to_csv('ukbb_asthma_cohorts_gwas_annotation_new_fixed.csv',index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [conda env:anaconda-default]",
   "language": "python",
   "name": "conda-env-anaconda-default-py"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.14"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}