Untitled2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "pd.set_option('display.max_columns', 500)\n",
    "pd.set_option('display.max_rows', 1000)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\5029874\\AppData\\Local\\Continuum\\anaconda3\\envs\\trainingenv\\lib\\site-packages\\IPython\\core\\interactiveshell.py:3020: DtypeWarning: Columns (16,38,69) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    }
   ],
   "source": [
    "final_new = pd.read_csv(\"D:\\CD\\CD_VARIABLES_Stage3_V7_v1.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "676010"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_new.PROPNO.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "exitcust = pd.read_csv(\"D:\\CD\\EXisting_Cust.csv\", usecols=['AGREEMENTNUMBER','DATEOFENQUIRY','ENQUIRINGMEMBERSHORTNAME','ENQUIRYPURPOSE'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_new_v = final_new.loc[~final_new['loanDisbDate'].isnull()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "637940"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_new_v.PROPNO.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_new_vnu = final_new.loc[final_new['loanDisbDate'].isnull()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "from datetime import datetime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_new_v['loanDisbDate'].isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'24/04/2018'"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_new_v['loanDisbDate'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timestamp('2019-03-15 00:00:00')"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "max(final_df['loanDisbDate'])"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "final_new_v['loanDisbDate'] = final_new['loanDisbDate'].astype('datetime64[ns]')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\5029874\\AppData\\Local\\Continuum\\anaconda3\\envs\\trainingenv\\lib\\site-packages\\ipykernel_launcher.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "final_new_v['loanDisbDate'] =  pd.to_datetime(final_new_v['loanDisbDate'], format='%d/%m/%Y')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_df = final_new_v.loc[final_new_v['loanDisbDate'] <= datetime(2019,3,15)] "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_df_v2 = pd.concat([final_df, final_new_vnu])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_df_v2.to_csv(\"D:\\CD\\CD_Variables_21_v1.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "logindisp = pd.read_csv(\"D:\\CD\\login_disp.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "logindisp =logindisp.iloc[:,1:] "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\5029874\\AppData\\Local\\Continuum\\anaconda3\\envs\\trainingenv\\lib\\site-packages\\ipykernel_launcher.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "logindisp['logdisp'] = 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "logindisp['loanDisbDate'] = pd.to_datetime(logindisp['loanDisbDate'], format='%Y-%m-%d')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "logindisp = logindisp.loc[logindisp['loanDisbDate'] <= datetime(2019,3,15)] "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "491616"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "logindisp.PROPNO.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "logindisp_prop = logindisp[['PROPNO']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\5029874\\AppData\\Local\\Continuum\\anaconda3\\envs\\trainingenv\\lib\\site-packages\\ipykernel_launcher.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "logindisp_prop['logdisp'] = 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "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>PROPNO</th>\n",
       "      <th>logdisp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3006CD0000026</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3003CD0000034</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3006CD0000027</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3054CD0000068</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3054CD0000063</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>3003CD0000040</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3000CD0000059</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3000CD0000060</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3006CD0000030</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>3006CD0000031</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>3078CD0000010</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>3054CD0000075</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>3078CD0000012</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>3054CD0000074</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>3054CD0000077</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>3006CD0000033</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>3003CD0000041</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>3078CD0000013</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>3000CD0000063</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>3000CD0000065</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>3000CD0000067</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>3003CD0000044</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>3003CD0000048</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>3003CD0000051</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>3006CD0000035</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>3006CD0000036</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>3054CD0000081</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>3054CD0000083</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>3078CD0000015</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>3078CD0000018</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>3078CD0000023</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>3000CD0000069</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>3000CD0000070</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>3006CD0000037</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>3000CD0000072</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>3003CD0000053</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>3003CD0000055</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>3078CD0000024</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>3000CD0000075</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>3003CD0000061</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>3000CD0000077</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>3000CD0000078</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>3000CD0000080</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>3078CD0000029</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>3005CD0000012</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>3006CD0000043</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>3000CD0000082</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>3054CD0000095</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>3078CD0000034</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>3000CD0000084</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>3078CD0000036</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>3078CD0000038</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>3054CD0000099</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>3054CD0000101</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>3078CD0000039</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>3078CD0000048</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>3078CD0000046</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>3006CD0000051</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>3000CD0000090</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>3054CD0000110</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>3003CD0000072</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>3006CD0000052</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>3000CD0000092</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>3054CD0000112</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>3054CD0000114</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>3054CD0000103</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>3078CD0000053</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>3003CD0000074</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>3054CD0000115</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>3006CD0000056</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>3006CD0000058</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>3054CD0000116</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>3054CD0000107</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>3078CD0000055</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>3000CD0000097</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>3054CD0000117</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>3078CD0000056</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>3078CD0000061</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>3078CD0000060</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>3054CD0000122</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>3006CD0000061</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>3054CD0000124</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>3078CD0000064</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>3000CD0000110</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>3000CD0000113</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>3000CD0000114</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>3000CD0000116</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>3003CD0000078</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>3006CD0000062</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>3006CD0000063</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>3006CD0000067</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>3006CD0000068</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>3006CD0000071</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>3006CD0000073</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>3006CD0000074</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>3054CD0000127</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>3054CD0000129</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>3054CD0000130</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>3054CD0000134</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>3054CD0000135</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>3054CD0000139</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>3078CD0000068</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>3078CD0000072</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>3078CD0000073</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>3078CD0000076</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>3078CD0000078</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>3078CD0000079</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>3078CD0000080</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>3003CD0000091</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>3006CD0000079</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>3006CD0000080</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>3078CD0000081</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>3005CD0000018</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>3006CD0000084</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>3000CD0000133</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>3006CD0000087</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>3000CD0000118</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>3000CD0000134</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>3003CD0000093</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>3000CD0000136</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>3006CD0000085</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>3000CD0000137</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>3000CD0000138</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>3078CD0000082</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>3003CD0000096</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>3054CD0000143</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>3054CD0000144</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>3000CD0000141</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>3006CD0000091</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>3054CD0000145</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>3078CD0000085</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>3054CD0000148</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>3078CD0000086</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>3006CD0000096</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>3054CD0000149</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>3006CD0000098</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>3006CD0000097</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>3078CD0000093</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>3006CD0000100</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>3000CD0000147</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>3078CD0000094</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>3054CD0000151</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>3000CD0000149</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>3000CD0000151</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>3003CD0000104</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>3078CD0000098</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>3006CD0000088</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>3078CD0000100</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>3078CD0000102</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>3003CD0000106</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>3000CD0000159</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>3078CD0000103</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>3006CD0000104</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>3078CD0000104</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>3078CD0000105</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>3078CD0000107</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>3078CD0000109</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>3078CD0000112</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>3054CD0000157</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>3078CD0000114</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>3000CD0000164</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>3000CD0000169</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>3000CD0000170</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>3003CD0000107</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>3054CD0000159</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>3078CD0000118</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>3003CD0000108</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>3054CD0000160</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>3078CD0000123</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>3078CD0000121</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>3054CD0000161</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>3003CD0000112</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>3078CD0000125</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>3078CD0000126</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>3078CD0000128</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>3054CD0000162</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>3006CD0000109</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>3000CD0000182</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>3054CD0000163</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>3054CD0000164</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>3054CD0000166</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>3054CD0000165</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>3003CD0000116</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>3078CD0000130</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>3078CD0000131</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>3000CD0000184</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>3000CD0000186</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>3000CD0000189</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>3003CD0000118</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>3006CD0000110</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>3006CD0000111</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>3054CD0000168</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>3000CD0000190</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>3054CD0000170</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>3078CD0000140</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>3054CD0000173</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>3000CD0000196</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>3003CD0000125</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>3054CD0000174</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>3078CD0000141</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>3078CD0000143</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>3000CD0000202</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>3000CD0000204</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>3003CD0000124</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204</th>\n",
       "      <td>3078CD0000144</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>205</th>\n",
       "      <td>3000CD0000199</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>3003CD0000128</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>3078CD0000148</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>3054CD0000176</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>3078CD0000149</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>3000CD0000210</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>3003CD0000129</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>3006CD0000114</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>3003CD0000130</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>3006CD0000116</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>3003CD0000132</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>3006CD0000118</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>3003CD0000133</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>3000CD0000224</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>3000CD0000228</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>3000CD0000229</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>3003CD0000136</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>3003CD0000142</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>3003CD0000144</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>3003CD0000145</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>3003CD0000146</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>3003CD0000147</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>3003CD0000151</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>3006CD0000127</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>3006CD0000129</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>3006CD0000132</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>3006CD0000134</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>3006CD0000135</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>3006CD0000136</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>3006CD0000139</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>3054CD0000184</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>3054CD0000185</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>3054CD0000186</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>3054CD0000194</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>3054CD0000195</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>3078CD0000154</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>3078CD0000156</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>3078CD0000160</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>3078CD0000161</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>3078CD0000162</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>3078CD0000163</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>3078CD0000164</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>3078CD0000166</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>3078CD0000168</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>3078CD0000170</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>3078CD0000172</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>3078CD0000175</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>3006CD0000140</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>3054CD0000202</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>3078CD0000178</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>3000CD0000234</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>3006CD0000141</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>3006CD0000144</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>3078CD0000180</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>3003CD0000154</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>3000CD0000235</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>261</th>\n",
       "      <td>3000CD0000236</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262</th>\n",
       "      <td>3000CD0000237</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263</th>\n",
       "      <td>3000CD0000239</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>264</th>\n",
       "      <td>3000CD0000240</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>265</th>\n",
       "      <td>3000CD0000243</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>266</th>\n",
       "      <td>3000CD0000252</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>267</th>\n",
       "      <td>3000CD0000257</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>268</th>\n",
       "      <td>3000CD0000259</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269</th>\n",
       "      <td>3000CD0000261</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270</th>\n",
       "      <td>3003CD0000159</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271</th>\n",
       "      <td>3003CD0000163</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272</th>\n",
       "      <td>3006CD0000151</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273</th>\n",
       "      <td>3054CD0000205</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274</th>\n",
       "      <td>3054CD0000211</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>275</th>\n",
       "      <td>3054CD0000214</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276</th>\n",
       "      <td>3054CD0000215</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277</th>\n",
       "      <td>3054CD0000217</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>3054CD0000218</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>3078CD0000184</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>280</th>\n",
       "      <td>3078CD0000185</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281</th>\n",
       "      <td>3078CD0000186</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282</th>\n",
       "      <td>3078CD0000187</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>283</th>\n",
       "      <td>3078CD0000193</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284</th>\n",
       "      <td>3078CD0000196</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285</th>\n",
       "      <td>3078CD0000197</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286</th>\n",
       "      <td>3078CD0000198</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287</th>\n",
       "      <td>3078CD0000199</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>288</th>\n",
       "      <td>3078CD0000202</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289</th>\n",
       "      <td>3078CD0000203</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>290</th>\n",
       "      <td>3078CD0000206</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291</th>\n",
       "      <td>3078CD0000209</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>292</th>\n",
       "      <td>3000CD0000265</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293</th>\n",
       "      <td>3000CD0000266</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>3000CD0000267</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>295</th>\n",
       "      <td>3000CD0000272</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296</th>\n",
       "      <td>3000CD0000274</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297</th>\n",
       "      <td>3003CD0000168</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>3006CD0000152</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>3006CD0000154</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300</th>\n",
       "      <td>3006CD0000155</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>3006CD0000157</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>302</th>\n",
       "      <td>3006CD0000158</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>303</th>\n",
       "      <td>3054CD0000222</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>304</th>\n",
       "      <td>3054CD0000223</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>305</th>\n",
       "      <td>3054CD0000224</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306</th>\n",
       "      <td>3054CD0000226</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>307</th>\n",
       "      <td>3054CD0000231</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>308</th>\n",
       "      <td>3078CD0000210</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>309</th>\n",
       "      <td>3078CD0000211</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310</th>\n",
       "      <td>3078CD0000213</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>311</th>\n",
       "      <td>3078CD0000214</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>312</th>\n",
       "      <td>3078CD0000215</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313</th>\n",
       "      <td>3078CD0000217</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>3000CD0000269</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>315</th>\n",
       "      <td>3000CD0000270</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>316</th>\n",
       "      <td>3000CD0000277</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>317</th>\n",
       "      <td>3000CD0000283</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>318</th>\n",
       "      <td>3000CD0000286</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>3000CD0000287</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320</th>\n",
       "      <td>3000CD0000290</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321</th>\n",
       "      <td>3000CD0000291</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>322</th>\n",
       "      <td>3000CD0000292</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323</th>\n",
       "      <td>3000CD0000293</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324</th>\n",
       "      <td>3000CD0000295</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>325</th>\n",
       "      <td>3000CD0000296</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>326</th>\n",
       "      <td>3000CD0000303</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>327</th>\n",
       "      <td>3000CD0000304</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>328</th>\n",
       "      <td>3000CD0000311</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>329</th>\n",
       "      <td>3003CD0000173</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>330</th>\n",
       "      <td>3003CD0000175</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>331</th>\n",
       "      <td>3003CD0000176</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>332</th>\n",
       "      <td>3003CD0000181</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>333</th>\n",
       "      <td>3003CD0000182</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>334</th>\n",
       "      <td>3003CD0000184</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>335</th>\n",
       "      <td>3003CD0000186</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>336</th>\n",
       "      <td>3005CD0000037</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>337</th>\n",
       "      <td>3006CD0000163</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>338</th>\n",
       "      <td>3006CD0000167</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>339</th>\n",
       "      <td>3006CD0000168</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>340</th>\n",
       "      <td>3054CD0000232</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341</th>\n",
       "      <td>3054CD0000233</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>342</th>\n",
       "      <td>3054CD0000235</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>343</th>\n",
       "      <td>3054CD0000238</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>3054CD0000239</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>345</th>\n",
       "      <td>3054CD0000242</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>346</th>\n",
       "      <td>3078CD0000224</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>347</th>\n",
       "      <td>3078CD0000226</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>348</th>\n",
       "      <td>3078CD0000230</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>349</th>\n",
       "      <td>3078CD0000233</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>350</th>\n",
       "      <td>3078CD0000234</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>351</th>\n",
       "      <td>3078CD0000235</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>352</th>\n",
       "      <td>3078CD0000236</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>353</th>\n",
       "      <td>3078CD0000237</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>354</th>\n",
       "      <td>3078CD0000238</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <td>3078CD0000240</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>356</th>\n",
       "      <td>3078CD0000242</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357</th>\n",
       "      <td>3078CD0000244</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <td>3078CD0000246</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>359</th>\n",
       "      <td>3078CD0000247</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>360</th>\n",
       "      <td>3078CD0000248</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>361</th>\n",
       "      <td>3000CD0000313</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <td>3000CD0000317</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>363</th>\n",
       "      <td>3000CD0000326</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364</th>\n",
       "      <td>3000CD0000327</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>365</th>\n",
       "      <td>3000CD0000330</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>366</th>\n",
       "      <td>3000CD0000331</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>367</th>\n",
       "      <td>3000CD0000332</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>3003CD0000191</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>369</th>\n",
       "      <td>3003CD0000196</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>370</th>\n",
       "      <td>3003CD0000197</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371</th>\n",
       "      <td>3003CD0000199</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>372</th>\n",
       "      <td>3006CD0000169</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>373</th>\n",
       "      <td>3006CD0000170</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>374</th>\n",
       "      <td>3006CD0000174</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>375</th>\n",
       "      <td>3006CD0000175</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>376</th>\n",
       "      <td>3054CD0000245</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>377</th>\n",
       "      <td>3054CD0000247</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>3054CD0000248</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>379</th>\n",
       "      <td>3054CD0000251</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>380</th>\n",
       "      <td>3054CD0000252</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>381</th>\n",
       "      <td>3054CD0000256</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>382</th>\n",
       "      <td>3054CD0000258</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>383</th>\n",
       "      <td>3054CD0000260</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>384</th>\n",
       "      <td>3054CD0000261</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>385</th>\n",
       "      <td>3054CD0000262</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>386</th>\n",
       "      <td>3054CD0000264</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>387</th>\n",
       "      <td>3054CD0000265</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>388</th>\n",
       "      <td>3054CD0000266</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>389</th>\n",
       "      <td>3054CD0000267</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>390</th>\n",
       "      <td>3078CD0000250</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>3078CD0000251</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>392</th>\n",
       "      <td>3078CD0000253</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393</th>\n",
       "      <td>3078CD0000255</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>394</th>\n",
       "      <td>3078CD0000256</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>395</th>\n",
       "      <td>3078CD0000257</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>396</th>\n",
       "      <td>3078CD0000258</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>397</th>\n",
       "      <td>3078CD0000260</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>398</th>\n",
       "      <td>3078CD0000261</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>399</th>\n",
       "      <td>3078CD0000262</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>400</th>\n",
       "      <td>3078CD0000265</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>401</th>\n",
       "      <td>3078CD0000267</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>402</th>\n",
       "      <td>3078CD0000269</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>403</th>\n",
       "      <td>3078CD0000270</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>404</th>\n",
       "      <td>3078CD0000271</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>405</th>\n",
       "      <td>3078CD0000273</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>406</th>\n",
       "      <td>3078CD0000274</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>407</th>\n",
       "      <td>3078CD0000276</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>408</th>\n",
       "      <td>3078CD0000277</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>409</th>\n",
       "      <td>3078CD0000278</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>410</th>\n",
       "      <td>3078CD0000279</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>3003CD0000188</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>412</th>\n",
       "      <td>3000CD0000335</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>3000CD0000337</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>3000CD0000339</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>3000CD0000342</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>416</th>\n",
       "      <td>3000CD0000343</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>417</th>\n",
       "      <td>3000CD0000349</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>418</th>\n",
       "      <td>3000CD0000355</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419</th>\n",
       "      <td>3000CD0000359</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>420</th>\n",
       "      <td>3000CD0000360</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>3000CD0000365</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422</th>\n",
       "      <td>3000CD0000372</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>423</th>\n",
       "      <td>3003CD0000205</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>424</th>\n",
       "      <td>3006CD0000180</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>3006CD0000181</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426</th>\n",
       "      <td>3006CD0000182</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>427</th>\n",
       "      <td>3006CD0000185</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>428</th>\n",
       "      <td>3006CD0000188</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429</th>\n",
       "      <td>3006CD0000190</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>430</th>\n",
       "      <td>3054CD0000270</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>431</th>\n",
       "      <td>3054CD0000271</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>432</th>\n",
       "      <td>3054CD0000276</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>433</th>\n",
       "      <td>3054CD0000281</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>434</th>\n",
       "      <td>3054CD0000285</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>435</th>\n",
       "      <td>3054CD0000286</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>436</th>\n",
       "      <td>3054CD0000288</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>437</th>\n",
       "      <td>3054CD0000289</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>438</th>\n",
       "      <td>3054CD0000291</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>439</th>\n",
       "      <td>3054CD0000294</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>440</th>\n",
       "      <td>3054CD0000295</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>441</th>\n",
       "      <td>3078CD0000280</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>442</th>\n",
       "      <td>3078CD0000281</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>443</th>\n",
       "      <td>3078CD0000283</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>444</th>\n",
       "      <td>3078CD0000288</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445</th>\n",
       "      <td>3078CD0000291</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>446</th>\n",
       "      <td>3078CD0000293</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>447</th>\n",
       "      <td>3078CD0000294</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>448</th>\n",
       "      <td>3078CD0000297</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>449</th>\n",
       "      <td>3078CD0000299</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>3078CD0000304</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>451</th>\n",
       "      <td>3078CD0000305</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>452</th>\n",
       "      <td>3078CD0000306</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>453</th>\n",
       "      <td>3078CD0000308</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>454</th>\n",
       "      <td>3078CD0000302</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>455</th>\n",
       "      <td>3000CD0000371</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>456</th>\n",
       "      <td>3000CD0000254</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>457</th>\n",
       "      <td>3000CD0000376</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>458</th>\n",
       "      <td>3000CD0000382</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>459</th>\n",
       "      <td>3000CD0000383</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>460</th>\n",
       "      <td>3000CD0000384</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>461</th>\n",
       "      <td>3000CD0000388</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462</th>\n",
       "      <td>3000CD0000389</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>463</th>\n",
       "      <td>3000CD0000390</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>464</th>\n",
       "      <td>3000CD0000397</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>465</th>\n",
       "      <td>3000CD0000399</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>466</th>\n",
       "      <td>3003CD0000222</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>467</th>\n",
       "      <td>3003CD0000225</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>3003CD0000226</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>469</th>\n",
       "      <td>3003CD0000229</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>470</th>\n",
       "      <td>3003CD0000233</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>471</th>\n",
       "      <td>3005CD0000043</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>472</th>\n",
       "      <td>3005CD0000044</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>3005CD0000046</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>474</th>\n",
       "      <td>3054CD0000306</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475</th>\n",
       "      <td>3054CD0000309</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476</th>\n",
       "      <td>3054CD0000311</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>477</th>\n",
       "      <td>3078CD0000310</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478</th>\n",
       "      <td>3078CD0000311</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>479</th>\n",
       "      <td>3078CD0000315</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>480</th>\n",
       "      <td>3078CD0000316</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>481</th>\n",
       "      <td>3078CD0000317</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>482</th>\n",
       "      <td>3078CD0000319</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>483</th>\n",
       "      <td>3078CD0000320</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>484</th>\n",
       "      <td>3078CD0000323</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>485</th>\n",
       "      <td>3078CD0000324</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>486</th>\n",
       "      <td>3078CD0000329</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>487</th>\n",
       "      <td>3078CD0000331</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>488</th>\n",
       "      <td>3078CD0000333</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>489</th>\n",
       "      <td>3078CD0000334</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490</th>\n",
       "      <td>3078CD0000336</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>491</th>\n",
       "      <td>3003CD0000234</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>492</th>\n",
       "      <td>3000CD0000400</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>493</th>\n",
       "      <td>3000CD0000402</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>494</th>\n",
       "      <td>3000CD0000404</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>495</th>\n",
       "      <td>3000CD0000405</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>496</th>\n",
       "      <td>3000CD0000411</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>497</th>\n",
       "      <td>3000CD0000413</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498</th>\n",
       "      <td>3000CD0000419</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499</th>\n",
       "      <td>3000CD0000423</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498550</th>\n",
       "      <td>3054CD0128869</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498553</th>\n",
       "      <td>3028CD0028084</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498559</th>\n",
       "      <td>3007CD0058548</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498561</th>\n",
       "      <td>3018CD0076721</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498563</th>\n",
       "      <td>3000CD0102615</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498570</th>\n",
       "      <td>3110CD0014187</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498571</th>\n",
       "      <td>3021CD0041187</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498575</th>\n",
       "      <td>3078CD0137199</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498576</th>\n",
       "      <td>3020CD0044585</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498582</th>\n",
       "      <td>3028CD0028089</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498591</th>\n",
       "      <td>3021CD0041186</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498605</th>\n",
       "      <td>3054CD0128876</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498606</th>\n",
       "      <td>3027CD0066720</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498608</th>\n",
       "      <td>3006CD0036204</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498616</th>\n",
       "      <td>3007CD0058556</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498617</th>\n",
       "      <td>3029CD0110625</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498618</th>\n",
       "      <td>3078CD0137222</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498623</th>\n",
       "      <td>3042CD0030728</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498638</th>\n",
       "      <td>3019CD0033621</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498646</th>\n",
       "      <td>3007CD0058558</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498648</th>\n",
       "      <td>3019CD0033767</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498649</th>\n",
       "      <td>3110CD0014198</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498657</th>\n",
       "      <td>3042CD0030729</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498659</th>\n",
       "      <td>3054CD0128864</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498661</th>\n",
       "      <td>3078CD0137227</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498663</th>\n",
       "      <td>3075CD0036194</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498666</th>\n",
       "      <td>3000CD0102628</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498668</th>\n",
       "      <td>3009CD0092196</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498677</th>\n",
       "      <td>3000CD0102623</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498679</th>\n",
       "      <td>3003CD0054546</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498680</th>\n",
       "      <td>3078CD0137235</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498685</th>\n",
       "      <td>3024CD0043501</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498688</th>\n",
       "      <td>3009CD0092618</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498691</th>\n",
       "      <td>3020CD0044596</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498692</th>\n",
       "      <td>3020CD0044598</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498694</th>\n",
       "      <td>3009CD0092628</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498695</th>\n",
       "      <td>3027CD0066731</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498697</th>\n",
       "      <td>3029CD0110389</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498699</th>\n",
       "      <td>3029CD0110644</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498702</th>\n",
       "      <td>3027CD0066733</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498703</th>\n",
       "      <td>3008CD0014547</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498704</th>\n",
       "      <td>3042CD0030739</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498713</th>\n",
       "      <td>3110CD0014208</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498715</th>\n",
       "      <td>3029CD0110642</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498716</th>\n",
       "      <td>3003CD0054549</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498720</th>\n",
       "      <td>3007CD0058562</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498726</th>\n",
       "      <td>3004CD0058301</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498732</th>\n",
       "      <td>3020CD0044583</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498737</th>\n",
       "      <td>3029CD0110663</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498739</th>\n",
       "      <td>3009CD0092631</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498741</th>\n",
       "      <td>3078CD0137234</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498747</th>\n",
       "      <td>3004CD0058295</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498750</th>\n",
       "      <td>3028CD0028098</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498755</th>\n",
       "      <td>3020CD0044607</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498758</th>\n",
       "      <td>3028CD0028097</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498759</th>\n",
       "      <td>3027CD0066737</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498761</th>\n",
       "      <td>3000CD0102637</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498765</th>\n",
       "      <td>3110CD0014210</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498767</th>\n",
       "      <td>3007CD0058571</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498768</th>\n",
       "      <td>3001CD0032215</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498777</th>\n",
       "      <td>3061CD0037197</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498781</th>\n",
       "      <td>3054CD0128894</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498791</th>\n",
       "      <td>3009CD0092637</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498808</th>\n",
       "      <td>3110CD0014214</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498810</th>\n",
       "      <td>3004CD0058309</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498816</th>\n",
       "      <td>3078CD0137275</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498820</th>\n",
       "      <td>3029CD0110673</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498825</th>\n",
       "      <td>3054CD0128900</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498828</th>\n",
       "      <td>3019CD0033832</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498830</th>\n",
       "      <td>3019CD0033837</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498831</th>\n",
       "      <td>3078CD0137262</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498833</th>\n",
       "      <td>3027CD0066752</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498834</th>\n",
       "      <td>3029CD0110681</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498845</th>\n",
       "      <td>3007CD0058579</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498849</th>\n",
       "      <td>3000CD0102654</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498850</th>\n",
       "      <td>3000CD0102655</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498851</th>\n",
       "      <td>3007CD0058582</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498852</th>\n",
       "      <td>3025CD0079165</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498854</th>\n",
       "      <td>3029CD0110699</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498855</th>\n",
       "      <td>3078CD0137268</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498858</th>\n",
       "      <td>3029CD0110703</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498862</th>\n",
       "      <td>3000CD0102658</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498865</th>\n",
       "      <td>3004CD0058298</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498866</th>\n",
       "      <td>3028CD0028102</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498867</th>\n",
       "      <td>3061CD0037209</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498871</th>\n",
       "      <td>3025CD0079166</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498873</th>\n",
       "      <td>3000CD0102661</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498881</th>\n",
       "      <td>3029CD0110713</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498886</th>\n",
       "      <td>3020CD0044622</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498887</th>\n",
       "      <td>3029CD0110709</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498890</th>\n",
       "      <td>3061CD0037206</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498895</th>\n",
       "      <td>3027CD0066763</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498900</th>\n",
       "      <td>3024CD0043530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498910</th>\n",
       "      <td>3000CD0102665</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498911</th>\n",
       "      <td>3009CD0092664</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498915</th>\n",
       "      <td>3061CD0037208</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498916</th>\n",
       "      <td>3000CD0102663</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498921</th>\n",
       "      <td>3054CD0128909</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498923</th>\n",
       "      <td>3029CD0110719</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498924</th>\n",
       "      <td>3061CD0037192</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498928</th>\n",
       "      <td>3075CD0036222</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498930</th>\n",
       "      <td>3024CD0043531</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498931</th>\n",
       "      <td>3019CD0033845</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498937</th>\n",
       "      <td>3004CD0058324</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498939</th>\n",
       "      <td>3019CD0033846</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498942</th>\n",
       "      <td>3027CD0066775</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498944</th>\n",
       "      <td>3029CD0110698</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498948</th>\n",
       "      <td>3009CD0092670</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498953</th>\n",
       "      <td>3006CD0036230</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498959</th>\n",
       "      <td>3020CD0044634</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498963</th>\n",
       "      <td>3027CD0066774</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498967</th>\n",
       "      <td>3110CD0014228</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498971</th>\n",
       "      <td>3024CD0043541</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498977</th>\n",
       "      <td>3061CD0037220</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498979</th>\n",
       "      <td>3009CD0092682</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498980</th>\n",
       "      <td>3009CD0092683</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498983</th>\n",
       "      <td>3004CD0058326</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498984</th>\n",
       "      <td>3027CD0066780</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498985</th>\n",
       "      <td>3007CD0058591</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498988</th>\n",
       "      <td>3075CD0036233</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498991</th>\n",
       "      <td>3028CD0028109</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498994</th>\n",
       "      <td>3003CD0054565</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499003</th>\n",
       "      <td>3027CD0066781</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499004</th>\n",
       "      <td>3029CD0110751</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499005</th>\n",
       "      <td>3054CD0128916</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499006</th>\n",
       "      <td>3019CD0033854</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499010</th>\n",
       "      <td>3021CD0041248</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499011</th>\n",
       "      <td>3000CD0102682</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499016</th>\n",
       "      <td>3054CD0128928</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499017</th>\n",
       "      <td>3078CD0137315</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499019</th>\n",
       "      <td>3054CD0128927</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499026</th>\n",
       "      <td>3027CD0066783</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499028</th>\n",
       "      <td>3009CD0092692</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499029</th>\n",
       "      <td>3078CD0137319</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499033</th>\n",
       "      <td>3054CD0128926</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499037</th>\n",
       "      <td>3054CD0128915</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499040</th>\n",
       "      <td>3000CD0102679</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499044</th>\n",
       "      <td>3007CD0058593</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499045</th>\n",
       "      <td>3003CD0054568</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499054</th>\n",
       "      <td>3024CD0043548</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499065</th>\n",
       "      <td>3000CD0102678</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499068</th>\n",
       "      <td>3019CD0033863</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499079</th>\n",
       "      <td>3078CD0137050</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499080</th>\n",
       "      <td>3029CD0110768</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499082</th>\n",
       "      <td>3003CD0054570</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499093</th>\n",
       "      <td>3042CD0030762</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499101</th>\n",
       "      <td>3061CD0037231</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499103</th>\n",
       "      <td>3078CD0137313</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499105</th>\n",
       "      <td>3000CD0102697</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499116</th>\n",
       "      <td>3054CD0128949</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499123</th>\n",
       "      <td>3006CD0036238</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499125</th>\n",
       "      <td>3078CD0137349</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499126</th>\n",
       "      <td>3000CD0102700</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499129</th>\n",
       "      <td>3025CD0079208</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499133</th>\n",
       "      <td>3061CD0037235</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499137</th>\n",
       "      <td>3042CD0030763</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499140</th>\n",
       "      <td>3078CD0137336</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499141</th>\n",
       "      <td>3075CD0036255</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499142</th>\n",
       "      <td>3018CD0076769</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499143</th>\n",
       "      <td>3009CD0092712</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499145</th>\n",
       "      <td>3075CD0036248</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499151</th>\n",
       "      <td>3078CD0137348</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499153</th>\n",
       "      <td>3021CD0041258</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499154</th>\n",
       "      <td>3078CD0137337</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499159</th>\n",
       "      <td>3075CD0036250</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499163</th>\n",
       "      <td>3075CD0036240</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499168</th>\n",
       "      <td>3021CD0041269</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499169</th>\n",
       "      <td>3009CD0092701</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499172</th>\n",
       "      <td>3029CD0110784</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499180</th>\n",
       "      <td>3020CD0044654</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499191</th>\n",
       "      <td>3021CD0041270</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499195</th>\n",
       "      <td>3001CD0032239</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499198</th>\n",
       "      <td>3042CD0030767</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499204</th>\n",
       "      <td>3006CD0036245</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499209</th>\n",
       "      <td>3027CD0066802</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499210</th>\n",
       "      <td>3075CD0036259</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499214</th>\n",
       "      <td>3009CD0092714</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499219</th>\n",
       "      <td>3029CD0110794</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499234</th>\n",
       "      <td>3003CD0054577</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499235</th>\n",
       "      <td>3020CD0044671</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499238</th>\n",
       "      <td>3054CD0128956</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499240</th>\n",
       "      <td>3020CD0044669</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499245</th>\n",
       "      <td>3078CD0137363</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499247</th>\n",
       "      <td>3029CD0110808</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499248</th>\n",
       "      <td>3000CD0102722</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499249</th>\n",
       "      <td>3002CD0004724</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499257</th>\n",
       "      <td>3110CD0014252</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499261</th>\n",
       "      <td>3078CD0137358</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499264</th>\n",
       "      <td>3009CD0092725</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499266</th>\n",
       "      <td>3042CD0030781</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499271</th>\n",
       "      <td>3006CD0036247</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499273</th>\n",
       "      <td>3078CD0137381</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499277</th>\n",
       "      <td>3003CD0054584</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499278</th>\n",
       "      <td>3110CD0014260</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499296</th>\n",
       "      <td>3054CD0128993</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499301</th>\n",
       "      <td>3042CD0030786</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499303</th>\n",
       "      <td>3018CD0076791</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499310</th>\n",
       "      <td>3021CD0041281</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499312</th>\n",
       "      <td>3078CD0137379</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499315</th>\n",
       "      <td>3078CD0137374</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499323</th>\n",
       "      <td>3061CD0037251</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499324</th>\n",
       "      <td>3029CD0110825</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499326</th>\n",
       "      <td>3054CD0128971</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499332</th>\n",
       "      <td>3025CD0079240</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499334</th>\n",
       "      <td>3054CD0128994</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499335</th>\n",
       "      <td>3000CD0102728</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499337</th>\n",
       "      <td>3019CD0033875</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499339</th>\n",
       "      <td>3029CD0110811</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499351</th>\n",
       "      <td>3007CD0058612</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499353</th>\n",
       "      <td>3029CD0110830</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499354</th>\n",
       "      <td>3009CD0092717</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499372</th>\n",
       "      <td>3018CD0076796</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499377</th>\n",
       "      <td>3006CD0036256</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499379</th>\n",
       "      <td>3003CD0054583</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499382</th>\n",
       "      <td>3078CD0137409</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499383</th>\n",
       "      <td>3054CD0128966</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499384</th>\n",
       "      <td>3078CD0137404</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499386</th>\n",
       "      <td>3061CD0037259</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499387</th>\n",
       "      <td>3061CD0037261</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499390</th>\n",
       "      <td>3009CD0092745</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499392</th>\n",
       "      <td>3054CD0128967</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499403</th>\n",
       "      <td>3018CD0076803</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499408</th>\n",
       "      <td>3021CD0041299</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499413</th>\n",
       "      <td>3020CD0044685</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499417</th>\n",
       "      <td>3020CD0044686</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499421</th>\n",
       "      <td>3025CD0079248</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499423</th>\n",
       "      <td>3028CD0028124</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499424</th>\n",
       "      <td>3078CD0137413</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499427</th>\n",
       "      <td>3020CD0044689</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499429</th>\n",
       "      <td>3021CD0041292</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499440</th>\n",
       "      <td>3006CD0036261</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499443</th>\n",
       "      <td>3020CD0044691</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499447</th>\n",
       "      <td>3004CD0058370</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499460</th>\n",
       "      <td>3009CD0092761</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499461</th>\n",
       "      <td>3054CD0129022</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499469</th>\n",
       "      <td>3000CD0102753</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499474</th>\n",
       "      <td>3004CD0058375</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499476</th>\n",
       "      <td>3024CD0043582</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499479</th>\n",
       "      <td>3018CD0076807</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499481</th>\n",
       "      <td>3027CD0066830</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499482</th>\n",
       "      <td>3075CD0036286</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499493</th>\n",
       "      <td>3078CD0137443</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499494</th>\n",
       "      <td>3000CD0102769</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499495</th>\n",
       "      <td>3042CD0030803</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499499</th>\n",
       "      <td>3078CD0137439</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499502</th>\n",
       "      <td>3008CD0014565</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499503</th>\n",
       "      <td>3078CD0137380</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499507</th>\n",
       "      <td>3078CD0137438</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499512</th>\n",
       "      <td>3009CD0092768</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499516</th>\n",
       "      <td>3021CD0041308</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499517</th>\n",
       "      <td>3028CD0028129</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499523</th>\n",
       "      <td>3000CD0102779</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499527</th>\n",
       "      <td>3054CD0129044</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499539</th>\n",
       "      <td>3029CD0110876</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499545</th>\n",
       "      <td>3025CD0079257</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499546</th>\n",
       "      <td>3003CD0054610</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499549</th>\n",
       "      <td>3110CD0014279</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499551</th>\n",
       "      <td>3024CD0043592</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499554</th>\n",
       "      <td>3075CD0036294</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499556</th>\n",
       "      <td>3018CD0076821</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499563</th>\n",
       "      <td>3054CD0129039</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499568</th>\n",
       "      <td>3075CD0036298</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499571</th>\n",
       "      <td>3018CD0076815</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499572</th>\n",
       "      <td>3003CD0054615</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499576</th>\n",
       "      <td>3061CD0037289</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499585</th>\n",
       "      <td>3025CD0079280</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499589</th>\n",
       "      <td>3054CD0129043</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499591</th>\n",
       "      <td>3061CD0037285</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499593</th>\n",
       "      <td>3029CD0110891</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499595</th>\n",
       "      <td>3003CD0054616</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499596</th>\n",
       "      <td>3110CD0014285</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499601</th>\n",
       "      <td>3019CD0033901</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499604</th>\n",
       "      <td>3078CD0137447</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499607</th>\n",
       "      <td>3061CD0037291</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499609</th>\n",
       "      <td>3009CD0092784</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499616</th>\n",
       "      <td>3054CD0129019</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499630</th>\n",
       "      <td>3078CD0137464</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499632</th>\n",
       "      <td>3025CD0079283</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499638</th>\n",
       "      <td>3020CD0044707</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499639</th>\n",
       "      <td>3028CD0028134</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499641</th>\n",
       "      <td>3054CD0129051</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499644</th>\n",
       "      <td>3021CD0041318</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499645</th>\n",
       "      <td>3078CD0137477</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499654</th>\n",
       "      <td>3004CD0058388</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499655</th>\n",
       "      <td>3029CD0110902</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499659</th>\n",
       "      <td>3018CD0076831</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499664</th>\n",
       "      <td>3061CD0037295</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499677</th>\n",
       "      <td>3018CD0076714</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499683</th>\n",
       "      <td>3009CD0092794</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499689</th>\n",
       "      <td>3061CD0037301</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499696</th>\n",
       "      <td>3024CD0043608</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499702</th>\n",
       "      <td>3024CD0043607</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499707</th>\n",
       "      <td>3025CD0079296</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499709</th>\n",
       "      <td>3061CD0037303</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499722</th>\n",
       "      <td>3006CD0036275</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499730</th>\n",
       "      <td>3000CD0102791</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499732</th>\n",
       "      <td>3024CD0043610</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499736</th>\n",
       "      <td>3018CD0076837</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499748</th>\n",
       "      <td>3006CD0036276</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499751</th>\n",
       "      <td>3004CD0058402</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499759</th>\n",
       "      <td>3020CD0044728</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499763</th>\n",
       "      <td>3075CD0036307</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499765</th>\n",
       "      <td>3018CD0076839</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499775</th>\n",
       "      <td>3078CD0137492</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499782</th>\n",
       "      <td>3054CD0129069</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499786</th>\n",
       "      <td>3009CD0092811</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499796</th>\n",
       "      <td>3075CD0036301</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499798</th>\n",
       "      <td>3054CD0129085</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499800</th>\n",
       "      <td>3029CD0110898</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499808</th>\n",
       "      <td>3018CD0076845</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499814</th>\n",
       "      <td>3000CD0102823</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499815</th>\n",
       "      <td>3000CD0102785</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499820</th>\n",
       "      <td>3009CD0092808</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499821</th>\n",
       "      <td>3007CD0058672</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499822</th>\n",
       "      <td>3029CD0110930</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499840</th>\n",
       "      <td>3028CD0028142</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499842</th>\n",
       "      <td>3110CD0014308</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499844</th>\n",
       "      <td>3054CD0129095</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499847</th>\n",
       "      <td>3061CD0037324</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499853</th>\n",
       "      <td>3054CD0129098</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499854</th>\n",
       "      <td>3020CD0044739</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499856</th>\n",
       "      <td>3020CD0044738</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499864</th>\n",
       "      <td>3000CD0102835</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499874</th>\n",
       "      <td>3027CD0066871</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499876</th>\n",
       "      <td>3054CD0129096</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499883</th>\n",
       "      <td>3029CD0110939</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499889</th>\n",
       "      <td>3009CD0092825</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499894</th>\n",
       "      <td>3027CD0066872</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499902</th>\n",
       "      <td>3078CD0137504</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499909</th>\n",
       "      <td>3021CD0041342</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499913</th>\n",
       "      <td>3021CD0041343</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499937</th>\n",
       "      <td>3009CD0092835</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499943</th>\n",
       "      <td>3000CD0102859</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499944</th>\n",
       "      <td>3007CD0058689</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499945</th>\n",
       "      <td>3078CD0137515</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499946</th>\n",
       "      <td>3054CD0129118</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499949</th>\n",
       "      <td>3018CD0076864</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499952</th>\n",
       "      <td>3009CD0092833</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499957</th>\n",
       "      <td>3001CD0032269</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499958</th>\n",
       "      <td>3075CD0036320</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499964</th>\n",
       "      <td>3018CD0076867</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499970</th>\n",
       "      <td>3054CD0129126</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499971</th>\n",
       "      <td>3042CD0030806</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499978</th>\n",
       "      <td>3042CD0030828</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499982</th>\n",
       "      <td>3009CD0092841</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499987</th>\n",
       "      <td>3009CD0092842</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499993</th>\n",
       "      <td>3008CD0014584</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499994</th>\n",
       "      <td>3027CD0066886</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499995</th>\n",
       "      <td>3054CD0129136</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500008</th>\n",
       "      <td>3054CD0129139</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500012</th>\n",
       "      <td>3054CD0129140</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500014</th>\n",
       "      <td>3061CD0037339</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500017</th>\n",
       "      <td>3054CD0129142</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500021</th>\n",
       "      <td>3078CD0137529</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500030</th>\n",
       "      <td>3061CD0037341</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500035</th>\n",
       "      <td>3009CD0092845</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500042</th>\n",
       "      <td>3025CD0079332</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500049</th>\n",
       "      <td>3054CD0129157</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500052</th>\n",
       "      <td>3054CD0129143</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500059</th>\n",
       "      <td>3078CD0137543</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500062</th>\n",
       "      <td>3029CD0110966</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500083</th>\n",
       "      <td>3009CD0092850</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500084</th>\n",
       "      <td>3005CD0022469</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500089</th>\n",
       "      <td>3000CD0102875</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500103</th>\n",
       "      <td>3000CD0102876</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500105</th>\n",
       "      <td>3003CD0054651</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500120</th>\n",
       "      <td>3078CD0137568</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500127</th>\n",
       "      <td>3061CD0037353</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500134</th>\n",
       "      <td>3078CD0137576</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500139</th>\n",
       "      <td>3078CD0137572</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500160</th>\n",
       "      <td>3042CD0030832</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500163</th>\n",
       "      <td>3024CD0043636</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500171</th>\n",
       "      <td>3018CD0076895</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500172</th>\n",
       "      <td>3009CD0092862</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500181</th>\n",
       "      <td>3024CD0043669</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500182</th>\n",
       "      <td>3078CD0137610</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500183</th>\n",
       "      <td>3000CD0102896</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500188</th>\n",
       "      <td>3009CD0092871</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500189</th>\n",
       "      <td>3018CD0076896</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500197</th>\n",
       "      <td>3009CD0092867</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500203</th>\n",
       "      <td>3029CD0110998</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500210</th>\n",
       "      <td>3078CD0137598</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500216</th>\n",
       "      <td>3078CD0137609</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500231</th>\n",
       "      <td>3019CD0033949</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500233</th>\n",
       "      <td>3078CD0137617</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500234</th>\n",
       "      <td>3027CD0066921</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500241</th>\n",
       "      <td>3020CD0044795</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500244</th>\n",
       "      <td>3075CD0036349</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500249</th>\n",
       "      <td>3061CD0037377</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500254</th>\n",
       "      <td>3021CD0041363</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500256</th>\n",
       "      <td>3025CD0079354</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500267</th>\n",
       "      <td>3027CD0066935</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500269</th>\n",
       "      <td>3078CD0137627</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500281</th>\n",
       "      <td>3078CD0137611</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500287</th>\n",
       "      <td>3018CD0076904</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500293</th>\n",
       "      <td>3019CD0033958</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500306</th>\n",
       "      <td>3061CD0037376</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500309</th>\n",
       "      <td>3020CD0044814</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500316</th>\n",
       "      <td>3054CD0129214</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500319</th>\n",
       "      <td>3042CD0030855</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500322</th>\n",
       "      <td>3029CD0111014</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500327</th>\n",
       "      <td>3009CD0092888</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500336</th>\n",
       "      <td>3007CD0058730</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500337</th>\n",
       "      <td>3029CD0111022</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500341</th>\n",
       "      <td>3029CD0111016</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500342</th>\n",
       "      <td>3078CD0137631</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500347</th>\n",
       "      <td>3000CD0102776</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500362</th>\n",
       "      <td>3061CD0037390</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500377</th>\n",
       "      <td>3024CD0043683</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500399</th>\n",
       "      <td>3078CD0137654</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500406</th>\n",
       "      <td>3018CD0076919</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500408</th>\n",
       "      <td>3018CD0076918</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500409</th>\n",
       "      <td>3024CD0043693</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500413</th>\n",
       "      <td>3028CD0028174</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500417</th>\n",
       "      <td>3061CD0037396</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500419</th>\n",
       "      <td>3020CD0044830</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500423</th>\n",
       "      <td>3061CD0037393</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500438</th>\n",
       "      <td>3061CD0037399</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500445</th>\n",
       "      <td>3000CD0102927</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500456</th>\n",
       "      <td>3061CD0037392</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500459</th>\n",
       "      <td>3029CD0111050</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500478</th>\n",
       "      <td>3028CD0028172</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500501</th>\n",
       "      <td>3078CD0137662</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500502</th>\n",
       "      <td>3007CD0058755</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500508</th>\n",
       "      <td>3078CD0137676</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500524</th>\n",
       "      <td>3078CD0137620</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500538</th>\n",
       "      <td>3000CD0102949</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500539</th>\n",
       "      <td>3020CD0044852</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500574</th>\n",
       "      <td>3054CD0129265</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500578</th>\n",
       "      <td>3061CD0037420</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500580</th>\n",
       "      <td>3061CD0037416</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500593</th>\n",
       "      <td>3000CD0102957</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500609</th>\n",
       "      <td>3004CD0058489</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500613</th>\n",
       "      <td>3027CD0066991</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500614</th>\n",
       "      <td>3029CD0111088</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500615</th>\n",
       "      <td>3029CD0111089</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500616</th>\n",
       "      <td>3006CD0036328</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500642</th>\n",
       "      <td>3024CD0043671</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500645</th>\n",
       "      <td>3024CD0043716</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500652</th>\n",
       "      <td>3078CD0137712</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500667</th>\n",
       "      <td>3019CD0033997</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500672</th>\n",
       "      <td>3007CD0058770</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500683</th>\n",
       "      <td>3018CD0076957</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500692</th>\n",
       "      <td>3075CD0036409</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500698</th>\n",
       "      <td>3029CD0111111</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500699</th>\n",
       "      <td>3028CD0028189</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500702</th>\n",
       "      <td>3054CD0129284</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500704</th>\n",
       "      <td>3021CD0041406</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500705</th>\n",
       "      <td>3025CD0079422</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500706</th>\n",
       "      <td>3007CD0058777</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500729</th>\n",
       "      <td>3042CD0030903</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500735</th>\n",
       "      <td>3028CD0028193</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500753</th>\n",
       "      <td>3009CD0092955</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500754</th>\n",
       "      <td>3021CD0041416</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500771</th>\n",
       "      <td>3009CD0092957</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500782</th>\n",
       "      <td>3054CD0129293</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500787</th>\n",
       "      <td>3009CD0092961</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500788</th>\n",
       "      <td>3028CD0028196</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500805</th>\n",
       "      <td>3024CD0043732</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500814</th>\n",
       "      <td>3029CD0111152</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500830</th>\n",
       "      <td>3061CD0037471</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500842</th>\n",
       "      <td>3020CD0044884</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500858</th>\n",
       "      <td>3009CD0092970</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500867</th>\n",
       "      <td>3029CD0111160</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500870</th>\n",
       "      <td>3075CD0036419</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500889</th>\n",
       "      <td>3006CD0036346</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500892</th>\n",
       "      <td>3027CD0067008</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500949</th>\n",
       "      <td>3042CD0030927</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500956</th>\n",
       "      <td>3029CD0111174</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500971</th>\n",
       "      <td>3025CD0079464</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500987</th>\n",
       "      <td>3028CD0028206</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500988</th>\n",
       "      <td>3009CD0092986</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500999</th>\n",
       "      <td>3025CD0079469</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501022</th>\n",
       "      <td>3008CD0014626</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501025</th>\n",
       "      <td>3018CD0077002</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501030</th>\n",
       "      <td>3025CD0079476</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501051</th>\n",
       "      <td>3054CD0129327</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501054</th>\n",
       "      <td>3042CD0030933</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501056</th>\n",
       "      <td>3009CD0093010</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501078</th>\n",
       "      <td>3021CD0041448</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501087</th>\n",
       "      <td>3078CD0137795</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501092</th>\n",
       "      <td>3019CD0034042</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501108</th>\n",
       "      <td>3025CD0079468</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501132</th>\n",
       "      <td>3000CD0103034</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501183</th>\n",
       "      <td>3000CD0103035</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501217</th>\n",
       "      <td>3029CD0111244</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501245</th>\n",
       "      <td>3025CD0079505</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501314</th>\n",
       "      <td>3078CD0137840</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501324</th>\n",
       "      <td>3027CD0067076</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501334</th>\n",
       "      <td>3000CD0103038</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501430</th>\n",
       "      <td>3027CD0067107</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501439</th>\n",
       "      <td>3007CD0058852</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501469</th>\n",
       "      <td>3025CD0079551</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501598</th>\n",
       "      <td>3054CD0129407</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501638</th>\n",
       "      <td>3061CD0037574</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501659</th>\n",
       "      <td>3027CD0067141</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501660</th>\n",
       "      <td>3021CD0041520</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501747</th>\n",
       "      <td>3075CD0036518</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501830</th>\n",
       "      <td>3027CD0067160</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501837</th>\n",
       "      <td>3021CD0041534</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>491616 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               PROPNO  logdisp\n",
       "0       3006CD0000026        1\n",
       "1       3003CD0000034        1\n",
       "2       3006CD0000027        1\n",
       "3       3054CD0000068        1\n",
       "4       3054CD0000063        1\n",
       "5       3003CD0000040        1\n",
       "6       3000CD0000059        1\n",
       "7       3000CD0000060        1\n",
       "8       3006CD0000030        1\n",
       "9       3006CD0000031        1\n",
       "10      3078CD0000010        1\n",
       "11      3054CD0000075        1\n",
       "12      3078CD0000012        1\n",
       "13      3054CD0000074        1\n",
       "14      3054CD0000077        1\n",
       "15      3006CD0000033        1\n",
       "16      3003CD0000041        1\n",
       "17      3078CD0000013        1\n",
       "18      3000CD0000063        1\n",
       "19      3000CD0000065        1\n",
       "20      3000CD0000067        1\n",
       "21      3003CD0000044        1\n",
       "22      3003CD0000048        1\n",
       "23      3003CD0000051        1\n",
       "24      3006CD0000035        1\n",
       "25      3006CD0000036        1\n",
       "26      3054CD0000081        1\n",
       "27      3054CD0000083        1\n",
       "28      3078CD0000015        1\n",
       "29      3078CD0000018        1\n",
       "30      3078CD0000023        1\n",
       "31      3000CD0000069        1\n",
       "32      3000CD0000070        1\n",
       "33      3006CD0000037        1\n",
       "34      3000CD0000072        1\n",
       "35      3003CD0000053        1\n",
       "36      3003CD0000055        1\n",
       "37      3078CD0000024        1\n",
       "38      3000CD0000075        1\n",
       "39      3003CD0000061        1\n",
       "40      3000CD0000077        1\n",
       "41      3000CD0000078        1\n",
       "42      3000CD0000080        1\n",
       "43      3078CD0000029        1\n",
       "44      3005CD0000012        1\n",
       "45      3006CD0000043        1\n",
       "46      3000CD0000082        1\n",
       "47      3054CD0000095        1\n",
       "48      3078CD0000034        1\n",
       "49      3000CD0000084        1\n",
       "50      3078CD0000036        1\n",
       "51      3078CD0000038        1\n",
       "52      3054CD0000099        1\n",
       "53      3054CD0000101        1\n",
       "54      3078CD0000039        1\n",
       "55      3078CD0000048        1\n",
       "56      3078CD0000046        1\n",
       "57      3006CD0000051        1\n",
       "58      3000CD0000090        1\n",
       "59      3054CD0000110        1\n",
       "60      3003CD0000072        1\n",
       "61      3006CD0000052        1\n",
       "62      3000CD0000092        1\n",
       "63      3054CD0000112        1\n",
       "64      3054CD0000114        1\n",
       "65      3054CD0000103        1\n",
       "66      3078CD0000053        1\n",
       "67      3003CD0000074        1\n",
       "68      3054CD0000115        1\n",
       "69      3006CD0000056        1\n",
       "70      3006CD0000058        1\n",
       "71      3054CD0000116        1\n",
       "72      3054CD0000107        1\n",
       "73      3078CD0000055        1\n",
       "74      3000CD0000097        1\n",
       "75      3054CD0000117        1\n",
       "76      3078CD0000056        1\n",
       "77      3078CD0000061        1\n",
       "78      3078CD0000060        1\n",
       "79      3054CD0000122        1\n",
       "80      3006CD0000061        1\n",
       "81      3054CD0000124        1\n",
       "82      3078CD0000064        1\n",
       "83      3000CD0000110        1\n",
       "84      3000CD0000113        1\n",
       "85      3000CD0000114        1\n",
       "86      3000CD0000116        1\n",
       "87      3003CD0000078        1\n",
       "88      3006CD0000062        1\n",
       "89      3006CD0000063        1\n",
       "90      3006CD0000067        1\n",
       "91      3006CD0000068        1\n",
       "92      3006CD0000071        1\n",
       "93      3006CD0000073        1\n",
       "94      3006CD0000074        1\n",
       "95      3054CD0000127        1\n",
       "96      3054CD0000129        1\n",
       "97      3054CD0000130        1\n",
       "98      3054CD0000134        1\n",
       "99      3054CD0000135        1\n",
       "100     3054CD0000139        1\n",
       "101     3078CD0000068        1\n",
       "102     3078CD0000072        1\n",
       "103     3078CD0000073        1\n",
       "104     3078CD0000076        1\n",
       "105     3078CD0000078        1\n",
       "106     3078CD0000079        1\n",
       "107     3078CD0000080        1\n",
       "108     3003CD0000091        1\n",
       "109     3006CD0000079        1\n",
       "110     3006CD0000080        1\n",
       "111     3078CD0000081        1\n",
       "112     3005CD0000018        1\n",
       "113     3006CD0000084        1\n",
       "114     3000CD0000133        1\n",
       "115     3006CD0000087        1\n",
       "116     3000CD0000118        1\n",
       "117     3000CD0000134        1\n",
       "118     3003CD0000093        1\n",
       "119     3000CD0000136        1\n",
       "120     3006CD0000085        1\n",
       "121     3000CD0000137        1\n",
       "122     3000CD0000138        1\n",
       "123     3078CD0000082        1\n",
       "124     3003CD0000096        1\n",
       "125     3054CD0000143        1\n",
       "126     3054CD0000144        1\n",
       "127     3000CD0000141        1\n",
       "128     3006CD0000091        1\n",
       "129     3054CD0000145        1\n",
       "130     3078CD0000085        1\n",
       "131     3054CD0000148        1\n",
       "132     3078CD0000086        1\n",
       "133     3006CD0000096        1\n",
       "134     3054CD0000149        1\n",
       "135     3006CD0000098        1\n",
       "136     3006CD0000097        1\n",
       "137     3078CD0000093        1\n",
       "138     3006CD0000100        1\n",
       "139     3000CD0000147        1\n",
       "140     3078CD0000094        1\n",
       "141     3054CD0000151        1\n",
       "142     3000CD0000149        1\n",
       "143     3000CD0000151        1\n",
       "144     3003CD0000104        1\n",
       "145     3078CD0000098        1\n",
       "146     3006CD0000088        1\n",
       "147     3078CD0000100        1\n",
       "148     3078CD0000102        1\n",
       "149     3003CD0000106        1\n",
       "150     3000CD0000159        1\n",
       "151     3078CD0000103        1\n",
       "152     3006CD0000104        1\n",
       "153     3078CD0000104        1\n",
       "154     3078CD0000105        1\n",
       "155     3078CD0000107        1\n",
       "156     3078CD0000109        1\n",
       "157     3078CD0000112        1\n",
       "158     3054CD0000157        1\n",
       "159     3078CD0000114        1\n",
       "160     3000CD0000164        1\n",
       "161     3000CD0000169        1\n",
       "162     3000CD0000170        1\n",
       "163     3003CD0000107        1\n",
       "164     3054CD0000159        1\n",
       "165     3078CD0000118        1\n",
       "166     3003CD0000108        1\n",
       "167     3054CD0000160        1\n",
       "168     3078CD0000123        1\n",
       "169     3078CD0000121        1\n",
       "170     3054CD0000161        1\n",
       "171     3003CD0000112        1\n",
       "172     3078CD0000125        1\n",
       "173     3078CD0000126        1\n",
       "174     3078CD0000128        1\n",
       "175     3054CD0000162        1\n",
       "176     3006CD0000109        1\n",
       "177     3000CD0000182        1\n",
       "178     3054CD0000163        1\n",
       "179     3054CD0000164        1\n",
       "180     3054CD0000166        1\n",
       "181     3054CD0000165        1\n",
       "182     3003CD0000116        1\n",
       "183     3078CD0000130        1\n",
       "184     3078CD0000131        1\n",
       "185     3000CD0000184        1\n",
       "186     3000CD0000186        1\n",
       "187     3000CD0000189        1\n",
       "188     3003CD0000118        1\n",
       "189     3006CD0000110        1\n",
       "190     3006CD0000111        1\n",
       "191     3054CD0000168        1\n",
       "192     3000CD0000190        1\n",
       "193     3054CD0000170        1\n",
       "194     3078CD0000140        1\n",
       "195     3054CD0000173        1\n",
       "196     3000CD0000196        1\n",
       "197     3003CD0000125        1\n",
       "198     3054CD0000174        1\n",
       "199     3078CD0000141        1\n",
       "200     3078CD0000143        1\n",
       "201     3000CD0000202        1\n",
       "202     3000CD0000204        1\n",
       "203     3003CD0000124        1\n",
       "204     3078CD0000144        1\n",
       "205     3000CD0000199        1\n",
       "206     3003CD0000128        1\n",
       "207     3078CD0000148        1\n",
       "208     3054CD0000176        1\n",
       "209     3078CD0000149        1\n",
       "210     3000CD0000210        1\n",
       "211     3003CD0000129        1\n",
       "212     3006CD0000114        1\n",
       "213     3003CD0000130        1\n",
       "214     3006CD0000116        1\n",
       "215     3003CD0000132        1\n",
       "216     3006CD0000118        1\n",
       "217     3003CD0000133        1\n",
       "218     3000CD0000224        1\n",
       "219     3000CD0000228        1\n",
       "220     3000CD0000229        1\n",
       "221     3003CD0000136        1\n",
       "222     3003CD0000142        1\n",
       "223     3003CD0000144        1\n",
       "224     3003CD0000145        1\n",
       "225     3003CD0000146        1\n",
       "226     3003CD0000147        1\n",
       "227     3003CD0000151        1\n",
       "228     3006CD0000127        1\n",
       "229     3006CD0000129        1\n",
       "230     3006CD0000132        1\n",
       "231     3006CD0000134        1\n",
       "232     3006CD0000135        1\n",
       "233     3006CD0000136        1\n",
       "234     3006CD0000139        1\n",
       "235     3054CD0000184        1\n",
       "236     3054CD0000185        1\n",
       "237     3054CD0000186        1\n",
       "238     3054CD0000194        1\n",
       "239     3054CD0000195        1\n",
       "240     3078CD0000154        1\n",
       "241     3078CD0000156        1\n",
       "242     3078CD0000160        1\n",
       "243     3078CD0000161        1\n",
       "244     3078CD0000162        1\n",
       "245     3078CD0000163        1\n",
       "246     3078CD0000164        1\n",
       "247     3078CD0000166        1\n",
       "248     3078CD0000168        1\n",
       "249     3078CD0000170        1\n",
       "250     3078CD0000172        1\n",
       "251     3078CD0000175        1\n",
       "252     3006CD0000140        1\n",
       "253     3054CD0000202        1\n",
       "254     3078CD0000178        1\n",
       "255     3000CD0000234        1\n",
       "256     3006CD0000141        1\n",
       "257     3006CD0000144        1\n",
       "258     3078CD0000180        1\n",
       "259     3003CD0000154        1\n",
       "260     3000CD0000235        1\n",
       "261     3000CD0000236        1\n",
       "262     3000CD0000237        1\n",
       "263     3000CD0000239        1\n",
       "264     3000CD0000240        1\n",
       "265     3000CD0000243        1\n",
       "266     3000CD0000252        1\n",
       "267     3000CD0000257        1\n",
       "268     3000CD0000259        1\n",
       "269     3000CD0000261        1\n",
       "270     3003CD0000159        1\n",
       "271     3003CD0000163        1\n",
       "272     3006CD0000151        1\n",
       "273     3054CD0000205        1\n",
       "274     3054CD0000211        1\n",
       "275     3054CD0000214        1\n",
       "276     3054CD0000215        1\n",
       "277     3054CD0000217        1\n",
       "278     3054CD0000218        1\n",
       "279     3078CD0000184        1\n",
       "280     3078CD0000185        1\n",
       "281     3078CD0000186        1\n",
       "282     3078CD0000187        1\n",
       "283     3078CD0000193        1\n",
       "284     3078CD0000196        1\n",
       "285     3078CD0000197        1\n",
       "286     3078CD0000198        1\n",
       "287     3078CD0000199        1\n",
       "288     3078CD0000202        1\n",
       "289     3078CD0000203        1\n",
       "290     3078CD0000206        1\n",
       "291     3078CD0000209        1\n",
       "292     3000CD0000265        1\n",
       "293     3000CD0000266        1\n",
       "294     3000CD0000267        1\n",
       "295     3000CD0000272        1\n",
       "296     3000CD0000274        1\n",
       "297     3003CD0000168        1\n",
       "298     3006CD0000152        1\n",
       "299     3006CD0000154        1\n",
       "300     3006CD0000155        1\n",
       "301     3006CD0000157        1\n",
       "302     3006CD0000158        1\n",
       "303     3054CD0000222        1\n",
       "304     3054CD0000223        1\n",
       "305     3054CD0000224        1\n",
       "306     3054CD0000226        1\n",
       "307     3054CD0000231        1\n",
       "308     3078CD0000210        1\n",
       "309     3078CD0000211        1\n",
       "310     3078CD0000213        1\n",
       "311     3078CD0000214        1\n",
       "312     3078CD0000215        1\n",
       "313     3078CD0000217        1\n",
       "314     3000CD0000269        1\n",
       "315     3000CD0000270        1\n",
       "316     3000CD0000277        1\n",
       "317     3000CD0000283        1\n",
       "318     3000CD0000286        1\n",
       "319     3000CD0000287        1\n",
       "320     3000CD0000290        1\n",
       "321     3000CD0000291        1\n",
       "322     3000CD0000292        1\n",
       "323     3000CD0000293        1\n",
       "324     3000CD0000295        1\n",
       "325     3000CD0000296        1\n",
       "326     3000CD0000303        1\n",
       "327     3000CD0000304        1\n",
       "328     3000CD0000311        1\n",
       "329     3003CD0000173        1\n",
       "330     3003CD0000175        1\n",
       "331     3003CD0000176        1\n",
       "332     3003CD0000181        1\n",
       "333     3003CD0000182        1\n",
       "334     3003CD0000184        1\n",
       "335     3003CD0000186        1\n",
       "336     3005CD0000037        1\n",
       "337     3006CD0000163        1\n",
       "338     3006CD0000167        1\n",
       "339     3006CD0000168        1\n",
       "340     3054CD0000232        1\n",
       "341     3054CD0000233        1\n",
       "342     3054CD0000235        1\n",
       "343     3054CD0000238        1\n",
       "344     3054CD0000239        1\n",
       "345     3054CD0000242        1\n",
       "346     3078CD0000224        1\n",
       "347     3078CD0000226        1\n",
       "348     3078CD0000230        1\n",
       "349     3078CD0000233        1\n",
       "350     3078CD0000234        1\n",
       "351     3078CD0000235        1\n",
       "352     3078CD0000236        1\n",
       "353     3078CD0000237        1\n",
       "354     3078CD0000238        1\n",
       "355     3078CD0000240        1\n",
       "356     3078CD0000242        1\n",
       "357     3078CD0000244        1\n",
       "358     3078CD0000246        1\n",
       "359     3078CD0000247        1\n",
       "360     3078CD0000248        1\n",
       "361     3000CD0000313        1\n",
       "362     3000CD0000317        1\n",
       "363     3000CD0000326        1\n",
       "364     3000CD0000327        1\n",
       "365     3000CD0000330        1\n",
       "366     3000CD0000331        1\n",
       "367     3000CD0000332        1\n",
       "368     3003CD0000191        1\n",
       "369     3003CD0000196        1\n",
       "370     3003CD0000197        1\n",
       "371     3003CD0000199        1\n",
       "372     3006CD0000169        1\n",
       "373     3006CD0000170        1\n",
       "374     3006CD0000174        1\n",
       "375     3006CD0000175        1\n",
       "376     3054CD0000245        1\n",
       "377     3054CD0000247        1\n",
       "378     3054CD0000248        1\n",
       "379     3054CD0000251        1\n",
       "380     3054CD0000252        1\n",
       "381     3054CD0000256        1\n",
       "382     3054CD0000258        1\n",
       "383     3054CD0000260        1\n",
       "384     3054CD0000261        1\n",
       "385     3054CD0000262        1\n",
       "386     3054CD0000264        1\n",
       "387     3054CD0000265        1\n",
       "388     3054CD0000266        1\n",
       "389     3054CD0000267        1\n",
       "390     3078CD0000250        1\n",
       "391     3078CD0000251        1\n",
       "392     3078CD0000253        1\n",
       "393     3078CD0000255        1\n",
       "394     3078CD0000256        1\n",
       "395     3078CD0000257        1\n",
       "396     3078CD0000258        1\n",
       "397     3078CD0000260        1\n",
       "398     3078CD0000261        1\n",
       "399     3078CD0000262        1\n",
       "400     3078CD0000265        1\n",
       "401     3078CD0000267        1\n",
       "402     3078CD0000269        1\n",
       "403     3078CD0000270        1\n",
       "404     3078CD0000271        1\n",
       "405     3078CD0000273        1\n",
       "406     3078CD0000274        1\n",
       "407     3078CD0000276        1\n",
       "408     3078CD0000277        1\n",
       "409     3078CD0000278        1\n",
       "410     3078CD0000279        1\n",
       "411     3003CD0000188        1\n",
       "412     3000CD0000335        1\n",
       "413     3000CD0000337        1\n",
       "414     3000CD0000339        1\n",
       "415     3000CD0000342        1\n",
       "416     3000CD0000343        1\n",
       "417     3000CD0000349        1\n",
       "418     3000CD0000355        1\n",
       "419     3000CD0000359        1\n",
       "420     3000CD0000360        1\n",
       "421     3000CD0000365        1\n",
       "422     3000CD0000372        1\n",
       "423     3003CD0000205        1\n",
       "424     3006CD0000180        1\n",
       "425     3006CD0000181        1\n",
       "426     3006CD0000182        1\n",
       "427     3006CD0000185        1\n",
       "428     3006CD0000188        1\n",
       "429     3006CD0000190        1\n",
       "430     3054CD0000270        1\n",
       "431     3054CD0000271        1\n",
       "432     3054CD0000276        1\n",
       "433     3054CD0000281        1\n",
       "434     3054CD0000285        1\n",
       "435     3054CD0000286        1\n",
       "436     3054CD0000288        1\n",
       "437     3054CD0000289        1\n",
       "438     3054CD0000291        1\n",
       "439     3054CD0000294        1\n",
       "440     3054CD0000295        1\n",
       "441     3078CD0000280        1\n",
       "442     3078CD0000281        1\n",
       "443     3078CD0000283        1\n",
       "444     3078CD0000288        1\n",
       "445     3078CD0000291        1\n",
       "446     3078CD0000293        1\n",
       "447     3078CD0000294        1\n",
       "448     3078CD0000297        1\n",
       "449     3078CD0000299        1\n",
       "450     3078CD0000304        1\n",
       "451     3078CD0000305        1\n",
       "452     3078CD0000306        1\n",
       "453     3078CD0000308        1\n",
       "454     3078CD0000302        1\n",
       "455     3000CD0000371        1\n",
       "456     3000CD0000254        1\n",
       "457     3000CD0000376        1\n",
       "458     3000CD0000382        1\n",
       "459     3000CD0000383        1\n",
       "460     3000CD0000384        1\n",
       "461     3000CD0000388        1\n",
       "462     3000CD0000389        1\n",
       "463     3000CD0000390        1\n",
       "464     3000CD0000397        1\n",
       "465     3000CD0000399        1\n",
       "466     3003CD0000222        1\n",
       "467     3003CD0000225        1\n",
       "468     3003CD0000226        1\n",
       "469     3003CD0000229        1\n",
       "470     3003CD0000233        1\n",
       "471     3005CD0000043        1\n",
       "472     3005CD0000044        1\n",
       "473     3005CD0000046        1\n",
       "474     3054CD0000306        1\n",
       "475     3054CD0000309        1\n",
       "476     3054CD0000311        1\n",
       "477     3078CD0000310        1\n",
       "478     3078CD0000311        1\n",
       "479     3078CD0000315        1\n",
       "480     3078CD0000316        1\n",
       "481     3078CD0000317        1\n",
       "482     3078CD0000319        1\n",
       "483     3078CD0000320        1\n",
       "484     3078CD0000323        1\n",
       "485     3078CD0000324        1\n",
       "486     3078CD0000329        1\n",
       "487     3078CD0000331        1\n",
       "488     3078CD0000333        1\n",
       "489     3078CD0000334        1\n",
       "490     3078CD0000336        1\n",
       "491     3003CD0000234        1\n",
       "492     3000CD0000400        1\n",
       "493     3000CD0000402        1\n",
       "494     3000CD0000404        1\n",
       "495     3000CD0000405        1\n",
       "496     3000CD0000411        1\n",
       "497     3000CD0000413        1\n",
       "498     3000CD0000419        1\n",
       "499     3000CD0000423        1\n",
       "...               ...      ...\n",
       "498550  3054CD0128869        1\n",
       "498553  3028CD0028084        1\n",
       "498559  3007CD0058548        1\n",
       "498561  3018CD0076721        1\n",
       "498563  3000CD0102615        1\n",
       "498570  3110CD0014187        1\n",
       "498571  3021CD0041187        1\n",
       "498575  3078CD0137199        1\n",
       "498576  3020CD0044585        1\n",
       "498582  3028CD0028089        1\n",
       "498591  3021CD0041186        1\n",
       "498605  3054CD0128876        1\n",
       "498606  3027CD0066720        1\n",
       "498608  3006CD0036204        1\n",
       "498616  3007CD0058556        1\n",
       "498617  3029CD0110625        1\n",
       "498618  3078CD0137222        1\n",
       "498623  3042CD0030728        1\n",
       "498638  3019CD0033621        1\n",
       "498646  3007CD0058558        1\n",
       "498648  3019CD0033767        1\n",
       "498649  3110CD0014198        1\n",
       "498657  3042CD0030729        1\n",
       "498659  3054CD0128864        1\n",
       "498661  3078CD0137227        1\n",
       "498663  3075CD0036194        1\n",
       "498666  3000CD0102628        1\n",
       "498668  3009CD0092196        1\n",
       "498677  3000CD0102623        1\n",
       "498679  3003CD0054546        1\n",
       "498680  3078CD0137235        1\n",
       "498685  3024CD0043501        1\n",
       "498688  3009CD0092618        1\n",
       "498691  3020CD0044596        1\n",
       "498692  3020CD0044598        1\n",
       "498694  3009CD0092628        1\n",
       "498695  3027CD0066731        1\n",
       "498697  3029CD0110389        1\n",
       "498699  3029CD0110644        1\n",
       "498702  3027CD0066733        1\n",
       "498703  3008CD0014547        1\n",
       "498704  3042CD0030739        1\n",
       "498713  3110CD0014208        1\n",
       "498715  3029CD0110642        1\n",
       "498716  3003CD0054549        1\n",
       "498720  3007CD0058562        1\n",
       "498726  3004CD0058301        1\n",
       "498732  3020CD0044583        1\n",
       "498737  3029CD0110663        1\n",
       "498739  3009CD0092631        1\n",
       "498741  3078CD0137234        1\n",
       "498747  3004CD0058295        1\n",
       "498750  3028CD0028098        1\n",
       "498755  3020CD0044607        1\n",
       "498758  3028CD0028097        1\n",
       "498759  3027CD0066737        1\n",
       "498761  3000CD0102637        1\n",
       "498765  3110CD0014210        1\n",
       "498767  3007CD0058571        1\n",
       "498768  3001CD0032215        1\n",
       "498777  3061CD0037197        1\n",
       "498781  3054CD0128894        1\n",
       "498791  3009CD0092637        1\n",
       "498808  3110CD0014214        1\n",
       "498810  3004CD0058309        1\n",
       "498816  3078CD0137275        1\n",
       "498820  3029CD0110673        1\n",
       "498825  3054CD0128900        1\n",
       "498828  3019CD0033832        1\n",
       "498830  3019CD0033837        1\n",
       "498831  3078CD0137262        1\n",
       "498833  3027CD0066752        1\n",
       "498834  3029CD0110681        1\n",
       "498845  3007CD0058579        1\n",
       "498849  3000CD0102654        1\n",
       "498850  3000CD0102655        1\n",
       "498851  3007CD0058582        1\n",
       "498852  3025CD0079165        1\n",
       "498854  3029CD0110699        1\n",
       "498855  3078CD0137268        1\n",
       "498858  3029CD0110703        1\n",
       "498862  3000CD0102658        1\n",
       "498865  3004CD0058298        1\n",
       "498866  3028CD0028102        1\n",
       "498867  3061CD0037209        1\n",
       "498871  3025CD0079166        1\n",
       "498873  3000CD0102661        1\n",
       "498881  3029CD0110713        1\n",
       "498886  3020CD0044622        1\n",
       "498887  3029CD0110709        1\n",
       "498890  3061CD0037206        1\n",
       "498895  3027CD0066763        1\n",
       "498900  3024CD0043530        1\n",
       "498910  3000CD0102665        1\n",
       "498911  3009CD0092664        1\n",
       "498915  3061CD0037208        1\n",
       "498916  3000CD0102663        1\n",
       "498921  3054CD0128909        1\n",
       "498923  3029CD0110719        1\n",
       "498924  3061CD0037192        1\n",
       "498928  3075CD0036222        1\n",
       "498930  3024CD0043531        1\n",
       "498931  3019CD0033845        1\n",
       "498937  3004CD0058324        1\n",
       "498939  3019CD0033846        1\n",
       "498942  3027CD0066775        1\n",
       "498944  3029CD0110698        1\n",
       "498948  3009CD0092670        1\n",
       "498953  3006CD0036230        1\n",
       "498959  3020CD0044634        1\n",
       "498963  3027CD0066774        1\n",
       "498967  3110CD0014228        1\n",
       "498971  3024CD0043541        1\n",
       "498977  3061CD0037220        1\n",
       "498979  3009CD0092682        1\n",
       "498980  3009CD0092683        1\n",
       "498983  3004CD0058326        1\n",
       "498984  3027CD0066780        1\n",
       "498985  3007CD0058591        1\n",
       "498988  3075CD0036233        1\n",
       "498991  3028CD0028109        1\n",
       "498994  3003CD0054565        1\n",
       "499003  3027CD0066781        1\n",
       "499004  3029CD0110751        1\n",
       "499005  3054CD0128916        1\n",
       "499006  3019CD0033854        1\n",
       "499010  3021CD0041248        1\n",
       "499011  3000CD0102682        1\n",
       "499016  3054CD0128928        1\n",
       "499017  3078CD0137315        1\n",
       "499019  3054CD0128927        1\n",
       "499026  3027CD0066783        1\n",
       "499028  3009CD0092692        1\n",
       "499029  3078CD0137319        1\n",
       "499033  3054CD0128926        1\n",
       "499037  3054CD0128915        1\n",
       "499040  3000CD0102679        1\n",
       "499044  3007CD0058593        1\n",
       "499045  3003CD0054568        1\n",
       "499054  3024CD0043548        1\n",
       "499065  3000CD0102678        1\n",
       "499068  3019CD0033863        1\n",
       "499079  3078CD0137050        1\n",
       "499080  3029CD0110768        1\n",
       "499082  3003CD0054570        1\n",
       "499093  3042CD0030762        1\n",
       "499101  3061CD0037231        1\n",
       "499103  3078CD0137313        1\n",
       "499105  3000CD0102697        1\n",
       "499116  3054CD0128949        1\n",
       "499123  3006CD0036238        1\n",
       "499125  3078CD0137349        1\n",
       "499126  3000CD0102700        1\n",
       "499129  3025CD0079208        1\n",
       "499133  3061CD0037235        1\n",
       "499137  3042CD0030763        1\n",
       "499140  3078CD0137336        1\n",
       "499141  3075CD0036255        1\n",
       "499142  3018CD0076769        1\n",
       "499143  3009CD0092712        1\n",
       "499145  3075CD0036248        1\n",
       "499151  3078CD0137348        1\n",
       "499153  3021CD0041258        1\n",
       "499154  3078CD0137337        1\n",
       "499159  3075CD0036250        1\n",
       "499163  3075CD0036240        1\n",
       "499168  3021CD0041269        1\n",
       "499169  3009CD0092701        1\n",
       "499172  3029CD0110784        1\n",
       "499180  3020CD0044654        1\n",
       "499191  3021CD0041270        1\n",
       "499195  3001CD0032239        1\n",
       "499198  3042CD0030767        1\n",
       "499204  3006CD0036245        1\n",
       "499209  3027CD0066802        1\n",
       "499210  3075CD0036259        1\n",
       "499214  3009CD0092714        1\n",
       "499219  3029CD0110794        1\n",
       "499234  3003CD0054577        1\n",
       "499235  3020CD0044671        1\n",
       "499238  3054CD0128956        1\n",
       "499240  3020CD0044669        1\n",
       "499245  3078CD0137363        1\n",
       "499247  3029CD0110808        1\n",
       "499248  3000CD0102722        1\n",
       "499249  3002CD0004724        1\n",
       "499257  3110CD0014252        1\n",
       "499261  3078CD0137358        1\n",
       "499264  3009CD0092725        1\n",
       "499266  3042CD0030781        1\n",
       "499271  3006CD0036247        1\n",
       "499273  3078CD0137381        1\n",
       "499277  3003CD0054584        1\n",
       "499278  3110CD0014260        1\n",
       "499296  3054CD0128993        1\n",
       "499301  3042CD0030786        1\n",
       "499303  3018CD0076791        1\n",
       "499310  3021CD0041281        1\n",
       "499312  3078CD0137379        1\n",
       "499315  3078CD0137374        1\n",
       "499323  3061CD0037251        1\n",
       "499324  3029CD0110825        1\n",
       "499326  3054CD0128971        1\n",
       "499332  3025CD0079240        1\n",
       "499334  3054CD0128994        1\n",
       "499335  3000CD0102728        1\n",
       "499337  3019CD0033875        1\n",
       "499339  3029CD0110811        1\n",
       "499351  3007CD0058612        1\n",
       "499353  3029CD0110830        1\n",
       "499354  3009CD0092717        1\n",
       "499372  3018CD0076796        1\n",
       "499377  3006CD0036256        1\n",
       "499379  3003CD0054583        1\n",
       "499382  3078CD0137409        1\n",
       "499383  3054CD0128966        1\n",
       "499384  3078CD0137404        1\n",
       "499386  3061CD0037259        1\n",
       "499387  3061CD0037261        1\n",
       "499390  3009CD0092745        1\n",
       "499392  3054CD0128967        1\n",
       "499403  3018CD0076803        1\n",
       "499408  3021CD0041299        1\n",
       "499413  3020CD0044685        1\n",
       "499417  3020CD0044686        1\n",
       "499421  3025CD0079248        1\n",
       "499423  3028CD0028124        1\n",
       "499424  3078CD0137413        1\n",
       "499427  3020CD0044689        1\n",
       "499429  3021CD0041292        1\n",
       "499440  3006CD0036261        1\n",
       "499443  3020CD0044691        1\n",
       "499447  3004CD0058370        1\n",
       "499460  3009CD0092761        1\n",
       "499461  3054CD0129022        1\n",
       "499469  3000CD0102753        1\n",
       "499474  3004CD0058375        1\n",
       "499476  3024CD0043582        1\n",
       "499479  3018CD0076807        1\n",
       "499481  3027CD0066830        1\n",
       "499482  3075CD0036286        1\n",
       "499493  3078CD0137443        1\n",
       "499494  3000CD0102769        1\n",
       "499495  3042CD0030803        1\n",
       "499499  3078CD0137439        1\n",
       "499502  3008CD0014565        1\n",
       "499503  3078CD0137380        1\n",
       "499507  3078CD0137438        1\n",
       "499512  3009CD0092768        1\n",
       "499516  3021CD0041308        1\n",
       "499517  3028CD0028129        1\n",
       "499523  3000CD0102779        1\n",
       "499527  3054CD0129044        1\n",
       "499539  3029CD0110876        1\n",
       "499545  3025CD0079257        1\n",
       "499546  3003CD0054610        1\n",
       "499549  3110CD0014279        1\n",
       "499551  3024CD0043592        1\n",
       "499554  3075CD0036294        1\n",
       "499556  3018CD0076821        1\n",
       "499563  3054CD0129039        1\n",
       "499568  3075CD0036298        1\n",
       "499571  3018CD0076815        1\n",
       "499572  3003CD0054615        1\n",
       "499576  3061CD0037289        1\n",
       "499585  3025CD0079280        1\n",
       "499589  3054CD0129043        1\n",
       "499591  3061CD0037285        1\n",
       "499593  3029CD0110891        1\n",
       "499595  3003CD0054616        1\n",
       "499596  3110CD0014285        1\n",
       "499601  3019CD0033901        1\n",
       "499604  3078CD0137447        1\n",
       "499607  3061CD0037291        1\n",
       "499609  3009CD0092784        1\n",
       "499616  3054CD0129019        1\n",
       "499630  3078CD0137464        1\n",
       "499632  3025CD0079283        1\n",
       "499638  3020CD0044707        1\n",
       "499639  3028CD0028134        1\n",
       "499641  3054CD0129051        1\n",
       "499644  3021CD0041318        1\n",
       "499645  3078CD0137477        1\n",
       "499654  3004CD0058388        1\n",
       "499655  3029CD0110902        1\n",
       "499659  3018CD0076831        1\n",
       "499664  3061CD0037295        1\n",
       "499677  3018CD0076714        1\n",
       "499683  3009CD0092794        1\n",
       "499689  3061CD0037301        1\n",
       "499696  3024CD0043608        1\n",
       "499702  3024CD0043607        1\n",
       "499707  3025CD0079296        1\n",
       "499709  3061CD0037303        1\n",
       "499722  3006CD0036275        1\n",
       "499730  3000CD0102791        1\n",
       "499732  3024CD0043610        1\n",
       "499736  3018CD0076837        1\n",
       "499748  3006CD0036276        1\n",
       "499751  3004CD0058402        1\n",
       "499759  3020CD0044728        1\n",
       "499763  3075CD0036307        1\n",
       "499765  3018CD0076839        1\n",
       "499775  3078CD0137492        1\n",
       "499782  3054CD0129069        1\n",
       "499786  3009CD0092811        1\n",
       "499796  3075CD0036301        1\n",
       "499798  3054CD0129085        1\n",
       "499800  3029CD0110898        1\n",
       "499808  3018CD0076845        1\n",
       "499814  3000CD0102823        1\n",
       "499815  3000CD0102785        1\n",
       "499820  3009CD0092808        1\n",
       "499821  3007CD0058672        1\n",
       "499822  3029CD0110930        1\n",
       "499840  3028CD0028142        1\n",
       "499842  3110CD0014308        1\n",
       "499844  3054CD0129095        1\n",
       "499847  3061CD0037324        1\n",
       "499853  3054CD0129098        1\n",
       "499854  3020CD0044739        1\n",
       "499856  3020CD0044738        1\n",
       "499864  3000CD0102835        1\n",
       "499874  3027CD0066871        1\n",
       "499876  3054CD0129096        1\n",
       "499883  3029CD0110939        1\n",
       "499889  3009CD0092825        1\n",
       "499894  3027CD0066872        1\n",
       "499902  3078CD0137504        1\n",
       "499909  3021CD0041342        1\n",
       "499913  3021CD0041343        1\n",
       "499937  3009CD0092835        1\n",
       "499943  3000CD0102859        1\n",
       "499944  3007CD0058689        1\n",
       "499945  3078CD0137515        1\n",
       "499946  3054CD0129118        1\n",
       "499949  3018CD0076864        1\n",
       "499952  3009CD0092833        1\n",
       "499957  3001CD0032269        1\n",
       "499958  3075CD0036320        1\n",
       "499964  3018CD0076867        1\n",
       "499970  3054CD0129126        1\n",
       "499971  3042CD0030806        1\n",
       "499978  3042CD0030828        1\n",
       "499982  3009CD0092841        1\n",
       "499987  3009CD0092842        1\n",
       "499993  3008CD0014584        1\n",
       "499994  3027CD0066886        1\n",
       "499995  3054CD0129136        1\n",
       "500008  3054CD0129139        1\n",
       "500012  3054CD0129140        1\n",
       "500014  3061CD0037339        1\n",
       "500017  3054CD0129142        1\n",
       "500021  3078CD0137529        1\n",
       "500030  3061CD0037341        1\n",
       "500035  3009CD0092845        1\n",
       "500042  3025CD0079332        1\n",
       "500049  3054CD0129157        1\n",
       "500052  3054CD0129143        1\n",
       "500059  3078CD0137543        1\n",
       "500062  3029CD0110966        1\n",
       "500083  3009CD0092850        1\n",
       "500084  3005CD0022469        1\n",
       "500089  3000CD0102875        1\n",
       "500103  3000CD0102876        1\n",
       "500105  3003CD0054651        1\n",
       "500120  3078CD0137568        1\n",
       "500127  3061CD0037353        1\n",
       "500134  3078CD0137576        1\n",
       "500139  3078CD0137572        1\n",
       "500160  3042CD0030832        1\n",
       "500163  3024CD0043636        1\n",
       "500171  3018CD0076895        1\n",
       "500172  3009CD0092862        1\n",
       "500181  3024CD0043669        1\n",
       "500182  3078CD0137610        1\n",
       "500183  3000CD0102896        1\n",
       "500188  3009CD0092871        1\n",
       "500189  3018CD0076896        1\n",
       "500197  3009CD0092867        1\n",
       "500203  3029CD0110998        1\n",
       "500210  3078CD0137598        1\n",
       "500216  3078CD0137609        1\n",
       "500231  3019CD0033949        1\n",
       "500233  3078CD0137617        1\n",
       "500234  3027CD0066921        1\n",
       "500241  3020CD0044795        1\n",
       "500244  3075CD0036349        1\n",
       "500249  3061CD0037377        1\n",
       "500254  3021CD0041363        1\n",
       "500256  3025CD0079354        1\n",
       "500267  3027CD0066935        1\n",
       "500269  3078CD0137627        1\n",
       "500281  3078CD0137611        1\n",
       "500287  3018CD0076904        1\n",
       "500293  3019CD0033958        1\n",
       "500306  3061CD0037376        1\n",
       "500309  3020CD0044814        1\n",
       "500316  3054CD0129214        1\n",
       "500319  3042CD0030855        1\n",
       "500322  3029CD0111014        1\n",
       "500327  3009CD0092888        1\n",
       "500336  3007CD0058730        1\n",
       "500337  3029CD0111022        1\n",
       "500341  3029CD0111016        1\n",
       "500342  3078CD0137631        1\n",
       "500347  3000CD0102776        1\n",
       "500362  3061CD0037390        1\n",
       "500377  3024CD0043683        1\n",
       "500399  3078CD0137654        1\n",
       "500406  3018CD0076919        1\n",
       "500408  3018CD0076918        1\n",
       "500409  3024CD0043693        1\n",
       "500413  3028CD0028174        1\n",
       "500417  3061CD0037396        1\n",
       "500419  3020CD0044830        1\n",
       "500423  3061CD0037393        1\n",
       "500438  3061CD0037399        1\n",
       "500445  3000CD0102927        1\n",
       "500456  3061CD0037392        1\n",
       "500459  3029CD0111050        1\n",
       "500478  3028CD0028172        1\n",
       "500501  3078CD0137662        1\n",
       "500502  3007CD0058755        1\n",
       "500508  3078CD0137676        1\n",
       "500524  3078CD0137620        1\n",
       "500538  3000CD0102949        1\n",
       "500539  3020CD0044852        1\n",
       "500574  3054CD0129265        1\n",
       "500578  3061CD0037420        1\n",
       "500580  3061CD0037416        1\n",
       "500593  3000CD0102957        1\n",
       "500609  3004CD0058489        1\n",
       "500613  3027CD0066991        1\n",
       "500614  3029CD0111088        1\n",
       "500615  3029CD0111089        1\n",
       "500616  3006CD0036328        1\n",
       "500642  3024CD0043671        1\n",
       "500645  3024CD0043716        1\n",
       "500652  3078CD0137712        1\n",
       "500667  3019CD0033997        1\n",
       "500672  3007CD0058770        1\n",
       "500683  3018CD0076957        1\n",
       "500692  3075CD0036409        1\n",
       "500698  3029CD0111111        1\n",
       "500699  3028CD0028189        1\n",
       "500702  3054CD0129284        1\n",
       "500704  3021CD0041406        1\n",
       "500705  3025CD0079422        1\n",
       "500706  3007CD0058777        1\n",
       "500729  3042CD0030903        1\n",
       "500735  3028CD0028193        1\n",
       "500753  3009CD0092955        1\n",
       "500754  3021CD0041416        1\n",
       "500771  3009CD0092957        1\n",
       "500782  3054CD0129293        1\n",
       "500787  3009CD0092961        1\n",
       "500788  3028CD0028196        1\n",
       "500805  3024CD0043732        1\n",
       "500814  3029CD0111152        1\n",
       "500830  3061CD0037471        1\n",
       "500842  3020CD0044884        1\n",
       "500858  3009CD0092970        1\n",
       "500867  3029CD0111160        1\n",
       "500870  3075CD0036419        1\n",
       "500889  3006CD0036346        1\n",
       "500892  3027CD0067008        1\n",
       "500949  3042CD0030927        1\n",
       "500956  3029CD0111174        1\n",
       "500971  3025CD0079464        1\n",
       "500987  3028CD0028206        1\n",
       "500988  3009CD0092986        1\n",
       "500999  3025CD0079469        1\n",
       "501022  3008CD0014626        1\n",
       "501025  3018CD0077002        1\n",
       "501030  3025CD0079476        1\n",
       "501051  3054CD0129327        1\n",
       "501054  3042CD0030933        1\n",
       "501056  3009CD0093010        1\n",
       "501078  3021CD0041448        1\n",
       "501087  3078CD0137795        1\n",
       "501092  3019CD0034042        1\n",
       "501108  3025CD0079468        1\n",
       "501132  3000CD0103034        1\n",
       "501183  3000CD0103035        1\n",
       "501217  3029CD0111244        1\n",
       "501245  3025CD0079505        1\n",
       "501314  3078CD0137840        1\n",
       "501324  3027CD0067076        1\n",
       "501334  3000CD0103038        1\n",
       "501430  3027CD0067107        1\n",
       "501439  3007CD0058852        1\n",
       "501469  3025CD0079551        1\n",
       "501598  3054CD0129407        1\n",
       "501638  3061CD0037574        1\n",
       "501659  3027CD0067141        1\n",
       "501660  3021CD0041520        1\n",
       "501747  3075CD0036518        1\n",
       "501830  3027CD0067160        1\n",
       "501837  3021CD0041534        1\n",
       "\n",
       "[491616 rows x 2 columns]"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "logindisp_prop"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [],
   "source": [
    "newdata = pd.merge(final_df_v2, logindisp_prop, on=['PROPNO'], how='left')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "a = set(final_df_v2['PROPNO'])\n",
    "b = set(logindisp['PROPNO'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "res = b.difference(a)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "res2 = a.difference(b)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "22"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(res) #142734 #37895"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'3000CD0089019',\n",
       " '3000CD0089905',\n",
       " '3001CD0013681',\n",
       " '3003CD0031645',\n",
       " '3003CD0038163',\n",
       " '3005CD0020116',\n",
       " '3006CD0031342',\n",
       " '3009CD0067245',\n",
       " '3019CD0019559',\n",
       " '3020CD0028482',\n",
       " '3020CD0036045',\n",
       " '3021CD0032877',\n",
       " '3025CD0044694',\n",
       " '3027CD0043195',\n",
       " '3029CD0089576',\n",
       " '3029CD0090164',\n",
       " '3042CD0011430',\n",
       " '3054CD0009553',\n",
       " '3061CD0019297',\n",
       " '3075CD0022480',\n",
       " '3075CD0029046',\n",
       " '3085CD0007316'}"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "res"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "pd.DataFrame(list(res2)).to_csv(\"D:\\CD\\Missing_Login_disp.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "PROPNO                          532671\n",
       "AGMTNO                          532671\n",
       "DEALER_CODE                     532671\n",
       "PORTFOLIO                       532671\n",
       "PREPAIDPOSTPAIDFLAG             532671\n",
       "AVGMOBILEBILLAMOUNTLAST3MON     532671\n",
       "AVGMOBRECHARGEAMOUNTLAST3MON    532671\n",
       "INSTALLTIME                     268424\n",
       "LASTPINGTIME                    268424\n",
       "REQUESTTIME                     268424\n",
       "DEALER_TYPE                     532671\n",
       "PRODUCT_CODE                    532671\n",
       "MODEL_CODE                      532671\n",
       "SCHEME_TYPE                     532671\n",
       "LTV                             532671\n",
       "STATE                           532671\n",
       "IMEI_NUMBER                     262409\n",
       "MAKE_CODE                       532671\n",
       "MODEL_DESC                      532671\n",
       "MODEL_DESC_V2_MAKE              532671\n",
       "DEALER_CITY                     532671\n",
       "REGISTRATION_TYPE                    0\n",
       "SCHEME_CODE                     532671\n",
       "CIBIL_HIT                       532671\n",
       "SURROGATE                       235635\n",
       "ACTUAL_LOAN_AMOUNT              532671\n",
       "CITY                            532671\n",
       "LATESTBALANCE                    91020\n",
       "GENDER                          532635\n",
       "QUALIFICATION                   532671\n",
       "AGE                             532671\n",
       "CIBIL_SCORE                     529751\n",
       "EXISTING_CUSTOMER                    0\n",
       "SPL_INSURANCE_TYPE              282989\n",
       "ADDRESS_TYPE                    532671\n",
       "RESIDENT_TYPE                   528390\n",
       "ADDRESS1                        532671\n",
       "ADDRESS2                        469548\n",
       "ADDRESS3                            17\n",
       "VOTERID                         532671\n",
       "PANNO                           532671\n",
       "DRIVING_LICENSE                 532671\n",
       "PASSPORT                        532671\n",
       "AADHAR                          532671\n",
       "RATION                          532671\n",
       "ACTIVITY_CODE                   532671\n",
       "TAT_HOUR                        532671\n",
       "TAT_DAYS                        532671\n",
       "TAT_DAYS_EXCLUDE_SUNDAY         532671\n",
       "PAYMENT_TYPE                    532671\n",
       "IFSC_CODE                       532641\n",
       "ELIGIBILITYGRID                 286605\n",
       "ELIGIBILITYGRID_REMARK          531864\n",
       "IS_MANDATE_REGISTERED           532671\n",
       "DELAER_NAME                     527937\n",
       "DELAER_CATEGORY                 527937\n",
       "IS_MOBILE                       532671\n",
       "Mobile_active_hours             268424\n",
       "Mobile_Bill                     532671\n",
       "Mobile_Bill_bin                 532671\n",
       "IS_CIBIL_HIT                    532671\n",
       "SURROGATE_CAT                   532671\n",
       "TICKET_SIZE                     532671\n",
       "CROSS_SELL_INSURANCE            532671\n",
       "DEALER_CITY_V2                  532671\n",
       "BANK_NAME                       531619\n",
       "MICR_CODE                       438687\n",
       "BANK_BRANCH                     531577\n",
       "BANK_ADDRESS                    531600\n",
       "BANK_CONTACT                    526459\n",
       "BANK_CITY                       532671\n",
       "BANK_DISTRICT                   531619\n",
       "BANK_STATE                      531619\n",
       "DEALER_CUST_CITY                532671\n",
       "CUST_BANK_CITY_DIFF             532671\n",
       "AGE_BIN                         492539\n",
       "CIBIL_SCORE_NEW                 529751\n",
       "CIBIL_SCORE_NEW_BIN             526598\n",
       "ADDRESS1_LEN                    532671\n",
       "ADDRESS2_LEN                    532671\n",
       "ADDRESS3_LEN                    532671\n",
       "AGMTNO_v1                       494601\n",
       "applAssetCtg                    494551\n",
       "applAssetMake                   494551\n",
       "D_LOGIN_TIME                    494601\n",
       "LOGIN_dateTime                  494601\n",
       "croApprovedDate                 281535\n",
       "loanDisbDate                    494601\n",
       "residenceCity                   494601\n",
       "Cust_bankName                   477809\n",
       "bankIFSCCode                    477781\n",
       "Bank_Name                       462001\n",
       "Bank_Type                       462001\n",
       "Actual_TAT_Days                 494601\n",
       "Disp_Month_bin                  532671\n",
       "IS_WEEKEND                      532671\n",
       "Processing Unit                 532671\n",
       "dtype: int64"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_df_v2.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "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>AGREEMENTNUMBER</th>\n",
       "      <th>DATEOFENQUIRY</th>\n",
       "      <th>ENQUIRINGMEMBERSHORTNAME</th>\n",
       "      <th>ENQUIRYPURPOSE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AP3042TW0053194</td>\n",
       "      <td>2017-03-28</td>\n",
       "      <td>TVS CREDIT</td>\n",
       "      <td>Used Car Loan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>PY3001TW52716</td>\n",
       "      <td>2014-12-16</td>\n",
       "      <td>TVS CREDIT</td>\n",
       "      <td>Two-Wheeler Loan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>MP3012TW0049727</td>\n",
       "      <td>2019-03-14</td>\n",
       "      <td>TVS CREDIT</td>\n",
       "      <td>Two-Wheeler Loan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>GJ3031TW10926</td>\n",
       "      <td>2015-07-24</td>\n",
       "      <td>TVS CREDIT</td>\n",
       "      <td>Two-Wheeler Loan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>KA3025TW01124</td>\n",
       "      <td>2011-01-11</td>\n",
       "      <td>TVS CREDIT</td>\n",
       "      <td>Two-Wheeler Loan</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   AGREEMENTNUMBER DATEOFENQUIRY ENQUIRINGMEMBERSHORTNAME    ENQUIRYPURPOSE\n",
       "0  AP3042TW0053194    2017-03-28               TVS CREDIT     Used Car Loan\n",
       "1    PY3001TW52716    2014-12-16               TVS CREDIT  Two-Wheeler Loan\n",
       "2  MP3012TW0049727    2019-03-14               TVS CREDIT  Two-Wheeler Loan\n",
       "3    GJ3031TW10926    2015-07-24               TVS CREDIT  Two-Wheeler Loan\n",
       "4    KA3025TW01124    2011-01-11               TVS CREDIT  Two-Wheeler Loan"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "exitcust.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Used Car Loan', 'Two-Wheeler Loan', 'Tractor Loan',\n",
       "       'Personal Loan', 'Auto Loan (Personal)', 'Consumer Loan', 'Other',\n",
       "       'Commercial Vehicle Loan', 'Property Loan', 'Overdraft',\n",
       "       'Business Loan - General', 'Education Loan',\n",
       "       'Loan Against Shares / Securities', 'Business Loan - Unsecured',\n",
       "       'Business Non-Funded Credit Facility-Priority Sector-Others',\n",
       "       'Business Loan - Priority Sector - Agriculture', 'Gold Loan',\n",
       "       'Loan Against Bank Deposits', 'Construction Equipment Loan'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "exitcust['ENQUIRYPURPOSE'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import cx_Oracle\n",
    "pd.set_option('display.max_columns', None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "ip = '172.16.80.74'\n",
    "port = '1521'\n",
    "SID = 'RPTDB'\n",
    "\n",
    "dsn_tns = cx_Oracle.makedsn(ip, port, SID)\n",
    "connection = cx_Oracle.connect('ANLYUSR', 'ANLYUSR$', dsn_tns, encoding='iso-8859-1')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "query =\"SELECT tb1.AGREEMENTNUMBER, \\\n",
    "tb1.TELEPHONE, \\\n",
    "tb2.ENQUIRINGMEMBERSHORTNAME, \\\n",
    "tb2.ENQUIRYPURPOSE, \\\n",
    "tb2.DATEOFENQUIRY \\\n",
    "FROM \\\n",
    "(SELECT * FROM BIUSR.TBL_TRN_CIBIL_ID_DETAILS) tb1 join \\\n",
    "(SELECT * FROM BIUSR.TBL_TRN_CIBIL_IQ_DETAILS \\\n",
    "WHERE ENQUIRINGMEMBERSHORTNAME = 'TVS CREDIT') tb2 \\\n",
    "ON tb1.AGREEMENTNUMBER = tb2.AGREEMENTNUMBER\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "Data = pd.read_sql(query, con=connection, chunksize=40000)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.concat([chunk for chunk in Data])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>AGREEMENTNUMBER</th>\n",
       "      <th>TELEPHONE</th>\n",
       "      <th>ENQUIRINGMEMBERSHORTNAME</th>\n",
       "      <th>ENQUIRYPURPOSE</th>\n",
       "      <th>DATEOFENQUIRY</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AP3042TW0053194</td>\n",
       "      <td>9704120959</td>\n",
       "      <td>TVS CREDIT</td>\n",
       "      <td>Used Car Loan</td>\n",
       "      <td>2019-03-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AP3042TW0053194</td>\n",
       "      <td>9704120959</td>\n",
       "      <td>TVS CREDIT</td>\n",
       "      <td>Used Car Loan</td>\n",
       "      <td>2019-03-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AP3042TW0053194</td>\n",
       "      <td>9553929283</td>\n",
       "      <td>TVS CREDIT</td>\n",
       "      <td>Used Car Loan</td>\n",
       "      <td>2019-03-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AP3042TW0053194</td>\n",
       "      <td>9059349782</td>\n",
       "      <td>TVS CREDIT</td>\n",
       "      <td>Used Car Loan</td>\n",
       "      <td>2019-03-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AP3042TW0053194</td>\n",
       "      <td>9704120959</td>\n",
       "      <td>TVS CREDIT</td>\n",
       "      <td>Used Car Loan</td>\n",
       "      <td>2019-03-08</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   AGREEMENTNUMBER   TELEPHONE ENQUIRINGMEMBERSHORTNAME ENQUIRYPURPOSE  \\\n",
       "0  AP3042TW0053194  9704120959               TVS CREDIT  Used Car Loan   \n",
       "1  AP3042TW0053194  9704120959               TVS CREDIT  Used Car Loan   \n",
       "2  AP3042TW0053194  9553929283               TVS CREDIT  Used Car Loan   \n",
       "3  AP3042TW0053194  9059349782               TVS CREDIT  Used Car Loan   \n",
       "4  AP3042TW0053194  9704120959               TVS CREDIT  Used Car Loan   \n",
       "\n",
       "  DATEOFENQUIRY  \n",
       "0    2019-03-14  \n",
       "1    2019-03-14  \n",
       "2    2019-03-14  \n",
       "3    2019-03-14  \n",
       "4    2019-03-08  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "data.to_csv(\"D:\\CD\\existing_customer_v2.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "query2=\"SELECT PROPNO, MAx(CONTACT1), max(CONTACT2), max(MOBILE1), max(MOBILE2) FROM BIUSR.TBL_TRN_CUSTOMER_ADDRESS \\\n",
    "WHERE SUBSTR(PROPNO,5,2) = 'CD' \\\n",
    "GROUP BY PROPNO\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "Data2 = pd.read_sql(query2, con=connection, chunksize=40000)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "data2 = pd.concat([chunk for chunk in Data2])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "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>PROPNO</th>\n",
       "      <th>CONTACT1</th>\n",
       "      <th>CONTACT2</th>\n",
       "      <th>MOBILE1</th>\n",
       "      <th>MOBILE2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3009CD0000008</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>9945247395</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3054CD0007166</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>9564149304</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3008CD0004077</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>9791606283</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3003CD0000499</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>9626080836</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3078CD0040165</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>8759476665</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          PROPNO CONTACT1 CONTACT2     MOBILE1 MOBILE2\n",
       "0  3009CD0000008     None     None  9945247395    None\n",
       "1  3054CD0007166     None     None  9564149304    None\n",
       "2  3008CD0004077     None     None  9791606283    None\n",
       "3  3003CD0000499     None     None  9626080836    None\n",
       "4  3078CD0040165     None     None  8759476665    None"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "data2.columns = ['PROPNO','CONTACT1','CONTACT2','MOBILE1','MOBILE2']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "data2.to_csv(\"D:\\CD\\customer_mobile_v.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "data2.fillna(value=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "def merg_mobile(row):\n",
    "    c1,c2,m1,m2 = int(row['CONTACT1'][:-10]),int(row['CONTACT2'][:-10]),int(row['MOBILE1'][:-10]),int(row['MOBILE2'][:-10])\n",
    "    return max(c1,c2,m1,m2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "(\"'NoneType' object is not subscriptable\", 'occurred at index 0')",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mTypeError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-53-89846a6a96fd>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mdata2\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'MOBILE'\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mdata2\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mapply\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmerg_mobile\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;36m1\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;32m~\\AppData\\Local\\Continuum\\anaconda3\\envs\\trainingenv\\lib\\site-packages\\pandas\\core\\frame.py\u001b[0m in \u001b[0;36mapply\u001b[1;34m(self, func, axis, broadcast, raw, reduce, result_type, args, **kwds)\u001b[0m\n\u001b[0;32m   6012\u001b[0m                          \u001b[0margs\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0margs\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   6013\u001b[0m                          kwds=kwds)\n\u001b[1;32m-> 6014\u001b[1;33m         \u001b[1;32mreturn\u001b[0m \u001b[0mop\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget_result\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   6015\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   6016\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mapplymap\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mfunc\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\AppData\\Local\\Continuum\\anaconda3\\envs\\trainingenv\\lib\\site-packages\\pandas\\core\\apply.py\u001b[0m in \u001b[0;36mget_result\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m    140\u001b[0m             \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mapply_raw\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    141\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 142\u001b[1;33m         \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mapply_standard\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    143\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    144\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mapply_empty_result\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\AppData\\Local\\Continuum\\anaconda3\\envs\\trainingenv\\lib\\site-packages\\pandas\\core\\apply.py\u001b[0m in \u001b[0;36mapply_standard\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m    246\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    247\u001b[0m         \u001b[1;31m# compute the result using the series generator\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 248\u001b[1;33m         \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mapply_series_generator\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    249\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    250\u001b[0m         \u001b[1;31m# wrap results\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\AppData\\Local\\Continuum\\anaconda3\\envs\\trainingenv\\lib\\site-packages\\pandas\\core\\apply.py\u001b[0m in \u001b[0;36mapply_series_generator\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m    275\u001b[0m             \u001b[1;32mtry\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    276\u001b[0m                 \u001b[1;32mfor\u001b[0m \u001b[0mi\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mv\u001b[0m \u001b[1;32min\u001b[0m \u001b[0menumerate\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mseries_gen\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 277\u001b[1;33m                     \u001b[0mresults\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mi\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mf\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mv\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    278\u001b[0m                     \u001b[0mkeys\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mv\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mname\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    279\u001b[0m             \u001b[1;32mexcept\u001b[0m \u001b[0mException\u001b[0m \u001b[1;32mas\u001b[0m \u001b[0me\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m<ipython-input-52-49a9497c9923>\u001b[0m in \u001b[0;36mmerg_mobile\u001b[1;34m(row)\u001b[0m\n\u001b[0;32m      1\u001b[0m \u001b[1;32mdef\u001b[0m \u001b[0mmerg_mobile\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mrow\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 2\u001b[1;33m     \u001b[0mc1\u001b[0m\u001b[1;33m,\u001b[0m\u001b[0mc2\u001b[0m\u001b[1;33m,\u001b[0m\u001b[0mm1\u001b[0m\u001b[1;33m,\u001b[0m\u001b[0mm2\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mrow\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'CONTACT1'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m-\u001b[0m\u001b[1;36m10\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m,\u001b[0m\u001b[0mrow\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'CONTACT2'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m-\u001b[0m\u001b[1;36m10\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m,\u001b[0m\u001b[0mrow\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'MOBILE1'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m-\u001b[0m\u001b[1;36m10\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m,\u001b[0m\u001b[0mrow\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'MOBILE2'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m-\u001b[0m\u001b[1;36m10\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m      3\u001b[0m     \u001b[1;32mif\u001b[0m \u001b[0mc1\u001b[0m \u001b[1;33m==\u001b[0m \u001b[1;32mNone\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      4\u001b[0m         \u001b[0mc1\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;36m0\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      5\u001b[0m     \u001b[1;32mif\u001b[0m \u001b[0mc2\u001b[0m \u001b[1;33m==\u001b[0m \u001b[1;32mNone\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mTypeError\u001b[0m: (\"'NoneType' object is not subscriptable\", 'occurred at index 0')"
     ]
    }
   ],
   "source": [
    "data2['MOBILE'] = data2.apply(merg_mobile, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "PROPNO                          494601\n",
       "AGMTNO                          494601\n",
       "DEALER_CODE                     494601\n",
       "PORTFOLIO                       494601\n",
       "PREPAIDPOSTPAIDFLAG             494601\n",
       "AVGMOBILEBILLAMOUNTLAST3MON     494601\n",
       "AVGMOBRECHARGEAMOUNTLAST3MON    494601\n",
       "INSTALLTIME                     256234\n",
       "LASTPINGTIME                    256234\n",
       "REQUESTTIME                     256234\n",
       "DEALER_TYPE                     494601\n",
       "PRODUCT_CODE                    494601\n",
       "MODEL_CODE                      494601\n",
       "SCHEME_TYPE                     494601\n",
       "LTV                             494601\n",
       "STATE                           494601\n",
       "IMEI_NUMBER                     242723\n",
       "MAKE_CODE                       494601\n",
       "MODEL_DESC                      494601\n",
       "MODEL_DESC_V2_MAKE              494601\n",
       "DEALER_CITY                     494601\n",
       "REGISTRATION_TYPE                    0\n",
       "SCHEME_CODE                     494601\n",
       "CIBIL_HIT                       494601\n",
       "SURROGATE                       214686\n",
       "ACTUAL_LOAN_AMOUNT              494601\n",
       "CITY                            494601\n",
       "LATESTBALANCE                    87636\n",
       "GENDER                          494565\n",
       "QUALIFICATION                   494601\n",
       "AGE                             494601\n",
       "CIBIL_SCORE                     491744\n",
       "EXISTING_CUSTOMER                    0\n",
       "SPL_INSURANCE_TYPE              257500\n",
       "ADDRESS_TYPE                    494601\n",
       "RESIDENT_TYPE                   490549\n",
       "ADDRESS1                        494601\n",
       "ADDRESS2                        436151\n",
       "ADDRESS3                            17\n",
       "VOTERID                         494601\n",
       "PANNO                           494601\n",
       "DRIVING_LICENSE                 494601\n",
       "PASSPORT                        494601\n",
       "AADHAR                          494601\n",
       "RATION                          494601\n",
       "ACTIVITY_CODE                   494601\n",
       "TAT_HOUR                        494601\n",
       "TAT_DAYS                        494601\n",
       "TAT_DAYS_EXCLUDE_SUNDAY         494601\n",
       "PAYMENT_TYPE                    494601\n",
       "IFSC_CODE                       494571\n",
       "ELIGIBILITYGRID                 266897\n",
       "ELIGIBILITYGRID_REMARK          493837\n",
       "IS_MANDATE_REGISTERED           494601\n",
       "DELAER_NAME                     490551\n",
       "DELAER_CATEGORY                 490551\n",
       "IS_MOBILE                       494601\n",
       "Mobile_active_hours             256234\n",
       "Mobile_Bill                     494601\n",
       "Mobile_Bill_bin                 494601\n",
       "IS_CIBIL_HIT                    494601\n",
       "SURROGATE_CAT                   494601\n",
       "TICKET_SIZE                     494601\n",
       "CROSS_SELL_INSURANCE            494601\n",
       "DEALER_CITY_V2                  494601\n",
       "BANK_NAME                       493593\n",
       "MICR_CODE                       407301\n",
       "BANK_BRANCH                     493554\n",
       "BANK_ADDRESS                    493576\n",
       "BANK_CONTACT                    488839\n",
       "BANK_CITY                       494601\n",
       "BANK_DISTRICT                   493593\n",
       "BANK_STATE                      493593\n",
       "DEALER_CUST_CITY                494601\n",
       "CUST_BANK_CITY_DIFF             494601\n",
       "AGE_BIN                         457420\n",
       "CIBIL_SCORE_NEW                 491744\n",
       "CIBIL_SCORE_NEW_BIN             488793\n",
       "ADDRESS1_LEN                    494601\n",
       "ADDRESS2_LEN                    494601\n",
       "ADDRESS3_LEN                    494601\n",
       "AGMTNO_v1                       494601\n",
       "applAssetCtg                    494551\n",
       "applAssetMake                   494551\n",
       "D_LOGIN_TIME                    494601\n",
       "LOGIN_dateTime                  494601\n",
       "croApprovedDate                 281535\n",
       "loanDisbDate                    494601\n",
       "residenceCity                   494601\n",
       "Cust_bankName                   477809\n",
       "bankIFSCCode                    477781\n",
       "Bank_Name                       428694\n",
       "Bank_Type                       428694\n",
       "Actual_TAT_Days                 494601\n",
       "Disp_Month_bin                  494601\n",
       "IS_WEEKEND                      494601\n",
       "Processing Unit                 494601\n",
       "dtype: int64"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_df.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_df.to_csv(\"D:\\CD\\CD_VARIABLES_final_v1.csv\")"
   ]
  }
 ],
 "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.6.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}