20180607_DNNRegressor_v1.2.1.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 更新版本v1.1到v1.2\n",
    "\n",
    "1. 特征标准化\n",
    "2. 尝试其他优化器"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "\n",
    "os.chdir(r'G:\\pycharm-workspace\\2018ATEC\\data')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "D:\\Install\\Anaconda3\\lib\\site-packages\\h5py\\__init__.py:36: FutureWarning: Conversion of the second argument of issubdtype from `float` to `np.floating` is deprecated. In future, it will be treated as `np.float64 == np.dtype(float).type`.\n",
      "  from ._conv import register_converters as _register_converters\n"
     ]
    },
    {
     "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>id</th>\n",
       "      <th>label</th>\n",
       "      <th>date</th>\n",
       "      <th>f1</th>\n",
       "      <th>f2</th>\n",
       "      <th>f3</th>\n",
       "      <th>f4</th>\n",
       "      <th>f5</th>\n",
       "      <th>f6</th>\n",
       "      <th>f7</th>\n",
       "      <th>f8</th>\n",
       "      <th>f9</th>\n",
       "      <th>f10</th>\n",
       "      <th>f11</th>\n",
       "      <th>f12</th>\n",
       "      <th>f13</th>\n",
       "      <th>f14</th>\n",
       "      <th>f15</th>\n",
       "      <th>f16</th>\n",
       "      <th>f17</th>\n",
       "      <th>f18</th>\n",
       "      <th>f19</th>\n",
       "      <th>f20</th>\n",
       "      <th>f21</th>\n",
       "      <th>f22</th>\n",
       "      <th>f23</th>\n",
       "      <th>f24</th>\n",
       "      <th>f25</th>\n",
       "      <th>f26</th>\n",
       "      <th>f27</th>\n",
       "      <th>f28</th>\n",
       "      <th>f29</th>\n",
       "      <th>f30</th>\n",
       "      <th>f31</th>\n",
       "      <th>f32</th>\n",
       "      <th>f33</th>\n",
       "      <th>f34</th>\n",
       "      <th>f35</th>\n",
       "      <th>f36</th>\n",
       "      <th>f37</th>\n",
       "      <th>f38</th>\n",
       "      <th>f39</th>\n",
       "      <th>f40</th>\n",
       "      <th>f41</th>\n",
       "      <th>f42</th>\n",
       "      <th>f43</th>\n",
       "      <th>f44</th>\n",
       "      <th>f45</th>\n",
       "      <th>f46</th>\n",
       "      <th>f47</th>\n",
       "      <th>f48</th>\n",
       "      <th>f49</th>\n",
       "      <th>f50</th>\n",
       "      <th>f51</th>\n",
       "      <th>f52</th>\n",
       "      <th>f53</th>\n",
       "      <th>f54</th>\n",
       "      <th>f55</th>\n",
       "      <th>f56</th>\n",
       "      <th>f57</th>\n",
       "      <th>f58</th>\n",
       "      <th>f59</th>\n",
       "      <th>f60</th>\n",
       "      <th>f61</th>\n",
       "      <th>f62</th>\n",
       "      <th>f63</th>\n",
       "      <th>f64</th>\n",
       "      <th>f65</th>\n",
       "      <th>f66</th>\n",
       "      <th>f67</th>\n",
       "      <th>f68</th>\n",
       "      <th>f69</th>\n",
       "      <th>f70</th>\n",
       "      <th>f71</th>\n",
       "      <th>f72</th>\n",
       "      <th>f73</th>\n",
       "      <th>f74</th>\n",
       "      <th>f75</th>\n",
       "      <th>f76</th>\n",
       "      <th>f77</th>\n",
       "      <th>f78</th>\n",
       "      <th>f79</th>\n",
       "      <th>f80</th>\n",
       "      <th>f81</th>\n",
       "      <th>f82</th>\n",
       "      <th>f83</th>\n",
       "      <th>f84</th>\n",
       "      <th>f85</th>\n",
       "      <th>f86</th>\n",
       "      <th>f87</th>\n",
       "      <th>f88</th>\n",
       "      <th>f89</th>\n",
       "      <th>f90</th>\n",
       "      <th>f91</th>\n",
       "      <th>f92</th>\n",
       "      <th>f93</th>\n",
       "      <th>f94</th>\n",
       "      <th>f95</th>\n",
       "      <th>f96</th>\n",
       "      <th>f97</th>\n",
       "      <th>f98</th>\n",
       "      <th>f99</th>\n",
       "      <th>f100</th>\n",
       "      <th>f101</th>\n",
       "      <th>f102</th>\n",
       "      <th>f103</th>\n",
       "      <th>f104</th>\n",
       "      <th>f105</th>\n",
       "      <th>f106</th>\n",
       "      <th>f107</th>\n",
       "      <th>f108</th>\n",
       "      <th>f109</th>\n",
       "      <th>f110</th>\n",
       "      <th>f111</th>\n",
       "      <th>f112</th>\n",
       "      <th>f113</th>\n",
       "      <th>f114</th>\n",
       "      <th>f115</th>\n",
       "      <th>f116</th>\n",
       "      <th>f117</th>\n",
       "      <th>f118</th>\n",
       "      <th>f119</th>\n",
       "      <th>f120</th>\n",
       "      <th>f121</th>\n",
       "      <th>f122</th>\n",
       "      <th>f123</th>\n",
       "      <th>f124</th>\n",
       "      <th>f125</th>\n",
       "      <th>f126</th>\n",
       "      <th>f127</th>\n",
       "      <th>f128</th>\n",
       "      <th>f129</th>\n",
       "      <th>f130</th>\n",
       "      <th>f131</th>\n",
       "      <th>f132</th>\n",
       "      <th>f133</th>\n",
       "      <th>f134</th>\n",
       "      <th>f135</th>\n",
       "      <th>f136</th>\n",
       "      <th>f137</th>\n",
       "      <th>f138</th>\n",
       "      <th>f139</th>\n",
       "      <th>f140</th>\n",
       "      <th>f141</th>\n",
       "      <th>f142</th>\n",
       "      <th>f143</th>\n",
       "      <th>f144</th>\n",
       "      <th>f145</th>\n",
       "      <th>f146</th>\n",
       "      <th>f147</th>\n",
       "      <th>f148</th>\n",
       "      <th>f149</th>\n",
       "      <th>f150</th>\n",
       "      <th>f151</th>\n",
       "      <th>f152</th>\n",
       "      <th>f153</th>\n",
       "      <th>f154</th>\n",
       "      <th>f155</th>\n",
       "      <th>f156</th>\n",
       "      <th>f157</th>\n",
       "      <th>f158</th>\n",
       "      <th>f159</th>\n",
       "      <th>f160</th>\n",
       "      <th>f161</th>\n",
       "      <th>f162</th>\n",
       "      <th>f163</th>\n",
       "      <th>f164</th>\n",
       "      <th>f165</th>\n",
       "      <th>f166</th>\n",
       "      <th>f167</th>\n",
       "      <th>f168</th>\n",
       "      <th>f169</th>\n",
       "      <th>f170</th>\n",
       "      <th>f171</th>\n",
       "      <th>f172</th>\n",
       "      <th>f173</th>\n",
       "      <th>f174</th>\n",
       "      <th>f175</th>\n",
       "      <th>f176</th>\n",
       "      <th>f177</th>\n",
       "      <th>f178</th>\n",
       "      <th>f179</th>\n",
       "      <th>f180</th>\n",
       "      <th>f181</th>\n",
       "      <th>f182</th>\n",
       "      <th>f183</th>\n",
       "      <th>f184</th>\n",
       "      <th>f185</th>\n",
       "      <th>f186</th>\n",
       "      <th>f187</th>\n",
       "      <th>f188</th>\n",
       "      <th>f189</th>\n",
       "      <th>f190</th>\n",
       "      <th>f191</th>\n",
       "      <th>f192</th>\n",
       "      <th>f193</th>\n",
       "      <th>f194</th>\n",
       "      <th>f195</th>\n",
       "      <th>f196</th>\n",
       "      <th>f197</th>\n",
       "      <th>f198</th>\n",
       "      <th>f199</th>\n",
       "      <th>f200</th>\n",
       "      <th>f201</th>\n",
       "      <th>f202</th>\n",
       "      <th>f203</th>\n",
       "      <th>f204</th>\n",
       "      <th>f205</th>\n",
       "      <th>f206</th>\n",
       "      <th>f207</th>\n",
       "      <th>f208</th>\n",
       "      <th>f209</th>\n",
       "      <th>f210</th>\n",
       "      <th>f211</th>\n",
       "      <th>f212</th>\n",
       "      <th>f213</th>\n",
       "      <th>f214</th>\n",
       "      <th>f215</th>\n",
       "      <th>f216</th>\n",
       "      <th>f217</th>\n",
       "      <th>f218</th>\n",
       "      <th>f219</th>\n",
       "      <th>f220</th>\n",
       "      <th>f221</th>\n",
       "      <th>f222</th>\n",
       "      <th>f223</th>\n",
       "      <th>f224</th>\n",
       "      <th>f225</th>\n",
       "      <th>f226</th>\n",
       "      <th>f227</th>\n",
       "      <th>f228</th>\n",
       "      <th>f229</th>\n",
       "      <th>f230</th>\n",
       "      <th>f231</th>\n",
       "      <th>f232</th>\n",
       "      <th>f233</th>\n",
       "      <th>f234</th>\n",
       "      <th>f235</th>\n",
       "      <th>f236</th>\n",
       "      <th>f237</th>\n",
       "      <th>f238</th>\n",
       "      <th>f239</th>\n",
       "      <th>f240</th>\n",
       "      <th>f241</th>\n",
       "      <th>f242</th>\n",
       "      <th>f243</th>\n",
       "      <th>f244</th>\n",
       "      <th>f245</th>\n",
       "      <th>f246</th>\n",
       "      <th>f247</th>\n",
       "      <th>f248</th>\n",
       "      <th>f249</th>\n",
       "      <th>f250</th>\n",
       "      <th>f251</th>\n",
       "      <th>f252</th>\n",
       "      <th>f253</th>\n",
       "      <th>f254</th>\n",
       "      <th>f255</th>\n",
       "      <th>f256</th>\n",
       "      <th>f257</th>\n",
       "      <th>f258</th>\n",
       "      <th>f259</th>\n",
       "      <th>f260</th>\n",
       "      <th>f261</th>\n",
       "      <th>f262</th>\n",
       "      <th>f263</th>\n",
       "      <th>f264</th>\n",
       "      <th>f265</th>\n",
       "      <th>f266</th>\n",
       "      <th>f267</th>\n",
       "      <th>f268</th>\n",
       "      <th>f269</th>\n",
       "      <th>f270</th>\n",
       "      <th>f271</th>\n",
       "      <th>f272</th>\n",
       "      <th>f273</th>\n",
       "      <th>f274</th>\n",
       "      <th>f275</th>\n",
       "      <th>f276</th>\n",
       "      <th>f277</th>\n",
       "      <th>f278</th>\n",
       "      <th>f279</th>\n",
       "      <th>f280</th>\n",
       "      <th>f281</th>\n",
       "      <th>f282</th>\n",
       "      <th>f283</th>\n",
       "      <th>f284</th>\n",
       "      <th>f285</th>\n",
       "      <th>f286</th>\n",
       "      <th>f287</th>\n",
       "      <th>f288</th>\n",
       "      <th>f289</th>\n",
       "      <th>f290</th>\n",
       "      <th>f291</th>\n",
       "      <th>f292</th>\n",
       "      <th>f293</th>\n",
       "      <th>f294</th>\n",
       "      <th>f295</th>\n",
       "      <th>f296</th>\n",
       "      <th>f297</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>18024</th>\n",
       "      <td>aeb05b67ddb1c53d149a15ebbd4b8a34b58589afd1a8fa...</td>\n",
       "      <td>0</td>\n",
       "      <td>20171029</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>100802.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>10.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>11.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>6.0000</td>\n",
       "      <td>11.0000</td>\n",
       "      <td>70.0000</td>\n",
       "      <td>1667.0000</td>\n",
       "      <td>3665.7000</td>\n",
       "      <td>69.0000</td>\n",
       "      <td>1364.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>8.0000</td>\n",
       "      <td>15.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>11.0000</td>\n",
       "      <td>25.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>6.0000</td>\n",
       "      <td>11.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>6.0000</td>\n",
       "      <td>11.0000</td>\n",
       "      <td>24.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>925633</th>\n",
       "      <td>a03c77d8fae2995939149204172231e75073cd33917b7a...</td>\n",
       "      <td>0</td>\n",
       "      <td>20170914</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>100805.0000</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>11.0000</td>\n",
       "      <td>10.0000</td>\n",
       "      <td>36.0000</td>\n",
       "      <td>36.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>78.0000</td>\n",
       "      <td>36.0000</td>\n",
       "      <td>302.0000</td>\n",
       "      <td>301.0000</td>\n",
       "      <td>301.0000</td>\n",
       "      <td>301.0000</td>\n",
       "      <td>301.0000</td>\n",
       "      <td>301.0000</td>\n",
       "      <td>40.0000</td>\n",
       "      <td>58.0000</td>\n",
       "      <td>40.0000</td>\n",
       "      <td>58.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>10.0000</td>\n",
       "      <td>41.0000</td>\n",
       "      <td>60.0000</td>\n",
       "      <td>612.0000</td>\n",
       "      <td>3147.7000</td>\n",
       "      <td>5311.3000</td>\n",
       "      <td>984.7000</td>\n",
       "      <td>2862.2000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>9.0000</td>\n",
       "      <td>11.0000</td>\n",
       "      <td>10.0000</td>\n",
       "      <td>10.0000</td>\n",
       "      <td>24.0000</td>\n",
       "      <td>40.0000</td>\n",
       "      <td>57.0000</td>\n",
       "      <td>57.0000</td>\n",
       "      <td>10.0000</td>\n",
       "      <td>24.0000</td>\n",
       "      <td>40.0000</td>\n",
       "      <td>59.0000</td>\n",
       "      <td>230.0000</td>\n",
       "      <td>231.0000</td>\n",
       "      <td>226.0000</td>\n",
       "      <td>227.0000</td>\n",
       "      <td>227.0000</td>\n",
       "      <td>227.0000</td>\n",
       "      <td>230.0000</td>\n",
       "      <td>230.0000</td>\n",
       "      <td>230.0000</td>\n",
       "      <td>227.0000</td>\n",
       "      <td>227.0000</td>\n",
       "      <td>227.0000</td>\n",
       "      <td>32.0000</td>\n",
       "      <td>32.0000</td>\n",
       "      <td>29.0000</td>\n",
       "      <td>29.0000</td>\n",
       "      <td>29.0000</td>\n",
       "      <td>30.0000</td>\n",
       "      <td>32.0000</td>\n",
       "      <td>78.0000</td>\n",
       "      <td>44.0000</td>\n",
       "      <td>44.0000</td>\n",
       "      <td>44.0000</td>\n",
       "      <td>67.0000</td>\n",
       "      <td>32.0000</td>\n",
       "      <td>32.0000</td>\n",
       "      <td>29.0000</td>\n",
       "      <td>28.0000</td>\n",
       "      <td>29.0000</td>\n",
       "      <td>29.0000</td>\n",
       "      <td>31.0000</td>\n",
       "      <td>233.0000</td>\n",
       "      <td>233.0000</td>\n",
       "      <td>159.0000</td>\n",
       "      <td>160.0000</td>\n",
       "      <td>160.0000</td>\n",
       "      <td>160.0000</td>\n",
       "      <td>233.0000</td>\n",
       "      <td>230.0000</td>\n",
       "      <td>231.0000</td>\n",
       "      <td>226.0000</td>\n",
       "      <td>227.0000</td>\n",
       "      <td>226.0000</td>\n",
       "      <td>302.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>9.0000</td>\n",
       "      <td>25.0000</td>\n",
       "      <td>40.0000</td>\n",
       "      <td>59.0000</td>\n",
       "      <td>59.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>32.0000</td>\n",
       "      <td>182.0000</td>\n",
       "      <td>301.0000</td>\n",
       "      <td>311.0000</td>\n",
       "      <td>312.0000</td>\n",
       "      <td>26.0000</td>\n",
       "      <td>94.0000</td>\n",
       "      <td>134.0000</td>\n",
       "      <td>135.0000</td>\n",
       "      <td>134.0000</td>\n",
       "      <td>301.0000</td>\n",
       "      <td>314.0000</td>\n",
       "      <td>332.0000</td>\n",
       "      <td>87.0000</td>\n",
       "      <td>302.0000</td>\n",
       "      <td>185.0000</td>\n",
       "      <td>186.0000</td>\n",
       "      <td>187.0000</td>\n",
       "      <td>69.0000</td>\n",
       "      <td>186.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145076</th>\n",
       "      <td>671be36a1b9829a30ddbf831574280b936dc050e011ae0...</td>\n",
       "      <td>0</td>\n",
       "      <td>20171006</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100805.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>31.0000</td>\n",
       "      <td>32.0000</td>\n",
       "      <td>106.0000</td>\n",
       "      <td>108.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>91.0000</td>\n",
       "      <td>26.0000</td>\n",
       "      <td>301.0000</td>\n",
       "      <td>252.0000</td>\n",
       "      <td>301.0000</td>\n",
       "      <td>302.0000</td>\n",
       "      <td>301.0000</td>\n",
       "      <td>302.0000</td>\n",
       "      <td>22.0000</td>\n",
       "      <td>48.0000</td>\n",
       "      <td>23.0000</td>\n",
       "      <td>49.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>23.0000</td>\n",
       "      <td>51.0000</td>\n",
       "      <td>2053.9000</td>\n",
       "      <td>21354.9000</td>\n",
       "      <td>45776.1000</td>\n",
       "      <td>2054.9000</td>\n",
       "      <td>2054.9000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>10.0000</td>\n",
       "      <td>18.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>24.0000</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>96.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>24.0000</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>190.0000</td>\n",
       "      <td>190.0000</td>\n",
       "      <td>162.0000</td>\n",
       "      <td>188.0000</td>\n",
       "      <td>188.0000</td>\n",
       "      <td>189.0000</td>\n",
       "      <td>190.0000</td>\n",
       "      <td>190.0000</td>\n",
       "      <td>189.0000</td>\n",
       "      <td>163.0000</td>\n",
       "      <td>188.0000</td>\n",
       "      <td>189.0000</td>\n",
       "      <td>33.0000</td>\n",
       "      <td>35.0000</td>\n",
       "      <td>27.0000</td>\n",
       "      <td>26.0000</td>\n",
       "      <td>27.0000</td>\n",
       "      <td>26.0000</td>\n",
       "      <td>31.0000</td>\n",
       "      <td>80.0000</td>\n",
       "      <td>42.0000</td>\n",
       "      <td>43.0000</td>\n",
       "      <td>42.0000</td>\n",
       "      <td>61.0000</td>\n",
       "      <td>31.0000</td>\n",
       "      <td>31.0000</td>\n",
       "      <td>24.0000</td>\n",
       "      <td>25.0000</td>\n",
       "      <td>25.0000</td>\n",
       "      <td>24.0000</td>\n",
       "      <td>29.0000</td>\n",
       "      <td>233.0000</td>\n",
       "      <td>233.0000</td>\n",
       "      <td>114.0000</td>\n",
       "      <td>129.0000</td>\n",
       "      <td>130.0000</td>\n",
       "      <td>129.0000</td>\n",
       "      <td>233.0000</td>\n",
       "      <td>190.0000</td>\n",
       "      <td>190.0000</td>\n",
       "      <td>163.0000</td>\n",
       "      <td>189.0000</td>\n",
       "      <td>188.0000</td>\n",
       "      <td>301.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>24.0000</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>97.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>24.0000</td>\n",
       "      <td>24.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>22.0000</td>\n",
       "      <td>122.0000</td>\n",
       "      <td>302.0000</td>\n",
       "      <td>415.0000</td>\n",
       "      <td>650.0000</td>\n",
       "      <td>10.0000</td>\n",
       "      <td>26.0000</td>\n",
       "      <td>85.0000</td>\n",
       "      <td>105.0000</td>\n",
       "      <td>119.0000</td>\n",
       "      <td>301.0000</td>\n",
       "      <td>305.0000</td>\n",
       "      <td>308.0000</td>\n",
       "      <td>84.0000</td>\n",
       "      <td>277.0000</td>\n",
       "      <td>137.0000</td>\n",
       "      <td>137.0000</td>\n",
       "      <td>138.0000</td>\n",
       "      <td>51.0000</td>\n",
       "      <td>126.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200921</th>\n",
       "      <td>57877d3a9134f5bf9567b2386e3e2da41ea707ab306013...</td>\n",
       "      <td>0</td>\n",
       "      <td>20170923</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100802.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>198.9000</td>\n",
       "      <td>245.9000</td>\n",
       "      <td>301.8000</td>\n",
       "      <td>197.9000</td>\n",
       "      <td>246.9000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>409334</th>\n",
       "      <td>5914181c46badfcaf71e099a72342e0587dbb03723fc1c...</td>\n",
       "      <td>0</td>\n",
       "      <td>20170916</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100805.0000</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>32.0000</td>\n",
       "      <td>43.0000</td>\n",
       "      <td>33.0000</td>\n",
       "      <td>44.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>41.0000</td>\n",
       "      <td>56.0000</td>\n",
       "      <td>421.0000</td>\n",
       "      <td>9063.6000</td>\n",
       "      <td>9351.0000</td>\n",
       "      <td>1735.8000</td>\n",
       "      <td>8590.9000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>9.0000</td>\n",
       "      <td>13.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>21.0000</td>\n",
       "      <td>27.0000</td>\n",
       "      <td>26.0000</td>\n",
       "      <td>6.0000</td>\n",
       "      <td>18.0000</td>\n",
       "      <td>33.0000</td>\n",
       "      <td>45.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>6.0000</td>\n",
       "      <td>18.0000</td>\n",
       "      <td>33.0000</td>\n",
       "      <td>44.0000</td>\n",
       "      <td>44.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>903324</th>\n",
       "      <td>7201de3ebbeee31e83e400adca5fd87e9603885d53bcfd...</td>\n",
       "      <td>0</td>\n",
       "      <td>20170907</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>100803.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>6.0000</td>\n",
       "      <td>6.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>9.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>7.0000</td>\n",
       "      <td>8.0000</td>\n",
       "      <td>9.0000</td>\n",
       "      <td>10.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>11.0000</td>\n",
       "      <td>11.0000</td>\n",
       "      <td>11.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>8.0000</td>\n",
       "      <td>8.0000</td>\n",
       "      <td>13.0000</td>\n",
       "      <td>14.0000</td>\n",
       "      <td>500.0000</td>\n",
       "      <td>5190.7000</td>\n",
       "      <td>5191.7000</td>\n",
       "      <td>4413.0000</td>\n",
       "      <td>5190.7000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>8.0000</td>\n",
       "      <td>13.0000</td>\n",
       "      <td>14.0000</td>\n",
       "      <td>13.0000</td>\n",
       "      <td>14.0000</td>\n",
       "      <td>7.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>13.0000</td>\n",
       "      <td>13.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>10.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>7.0000</td>\n",
       "      <td>6.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>13.0000</td>\n",
       "      <td>13.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>8.0000</td>\n",
       "      <td>8.0000</td>\n",
       "      <td>7.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>6.0000</td>\n",
       "      <td>6.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>6.0000</td>\n",
       "      <td>7.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>535022</th>\n",
       "      <td>efee32d9e35cdd31855ef239caae554507d450d9f64ecd...</td>\n",
       "      <td>0</td>\n",
       "      <td>20170914</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>nan</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>793080</th>\n",
       "      <td>76746f56a24a9150de7caa8651f209f2348744b480775e...</td>\n",
       "      <td>0</td>\n",
       "      <td>20171023</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>100806.0000</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>6.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>6.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>6.0000</td>\n",
       "      <td>11.0000</td>\n",
       "      <td>6.0000</td>\n",
       "      <td>13.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>22.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>7.0000</td>\n",
       "      <td>7.0000</td>\n",
       "      <td>18.0000</td>\n",
       "      <td>34.0000</td>\n",
       "      <td>18.0000</td>\n",
       "      <td>34.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>11.0000</td>\n",
       "      <td>11.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>22.0000</td>\n",
       "      <td>62.0000</td>\n",
       "      <td>996.2000</td>\n",
       "      <td>22718.8000</td>\n",
       "      <td>40335.6000</td>\n",
       "      <td>995.2000</td>\n",
       "      <td>3901.5000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>6.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>25.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>17.0000</td>\n",
       "      <td>20.0000</td>\n",
       "      <td>35.0000</td>\n",
       "      <td>49.0000</td>\n",
       "      <td>11.0000</td>\n",
       "      <td>18.0000</td>\n",
       "      <td>20.0000</td>\n",
       "      <td>35.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>11.0000</td>\n",
       "      <td>18.0000</td>\n",
       "      <td>19.0000</td>\n",
       "      <td>34.0000</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>640315</th>\n",
       "      <td>ba7ef2aaabe9dbd85625fa6322f19b0e1e67810217ed6b...</td>\n",
       "      <td>0</td>\n",
       "      <td>20171005</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100806.0000</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>13.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>6.0000</td>\n",
       "      <td>10.0000</td>\n",
       "      <td>6.0000</td>\n",
       "      <td>10.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>7.0000</td>\n",
       "      <td>11.0000</td>\n",
       "      <td>39.9000</td>\n",
       "      <td>268.0000</td>\n",
       "      <td>1768.0000</td>\n",
       "      <td>119.5000</td>\n",
       "      <td>120.5000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>8.0000</td>\n",
       "      <td>9.0000</td>\n",
       "      <td>21.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>8.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>8.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>24.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993469</th>\n",
       "      <td>7527f0653a4efa081c2b63b4229545a7c08f502a64b8dd...</td>\n",
       "      <td>0</td>\n",
       "      <td>20171015</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>nan</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>104.0000</td>\n",
       "      <td>201.0000</td>\n",
       "      <td>240.0000</td>\n",
       "      <td>240.0000</td>\n",
       "      <td>105.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>9.0000</td>\n",
       "      <td>20.0000</td>\n",
       "      <td>105.0000</td>\n",
       "      <td>202.0000</td>\n",
       "      <td>239.0000</td>\n",
       "      <td>239.0000</td>\n",
       "      <td>128.0000</td>\n",
       "      <td>254.0000</td>\n",
       "      <td>301.0000</td>\n",
       "      <td>301.0000</td>\n",
       "      <td>21.0000</td>\n",
       "      <td>25.0000</td>\n",
       "      <td>27.0000</td>\n",
       "      <td>27.0000</td>\n",
       "      <td>76.0000</td>\n",
       "      <td>121.0000</td>\n",
       "      <td>139.0000</td>\n",
       "      <td>138.0000</td>\n",
       "      <td>202.0000</td>\n",
       "      <td>240.0000</td>\n",
       "      <td>239.0000</td>\n",
       "      <td>93.0000</td>\n",
       "      <td>171.0000</td>\n",
       "      <td>249.0000</td>\n",
       "      <td>248.0000</td>\n",
       "      <td>21.0000</td>\n",
       "      <td>58.0000</td>\n",
       "      <td>173.0000</td>\n",
       "      <td>322.0000</td>\n",
       "      <td>418.0000</td>\n",
       "      <td>16.0000</td>\n",
       "      <td>41.0000</td>\n",
       "      <td>121.0000</td>\n",
       "      <td>198.0000</td>\n",
       "      <td>202.0000</td>\n",
       "      <td>69.0000</td>\n",
       "      <td>127.0000</td>\n",
       "      <td>302.0000</td>\n",
       "      <td>303.0000</td>\n",
       "      <td>303.0000</td>\n",
       "      <td>60.0000</td>\n",
       "      <td>106.0000</td>\n",
       "      <td>248.0000</td>\n",
       "      <td>248.0000</td>\n",
       "      <td>248.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>990006 rows × 300 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                       id  label      date  \\\n",
       "18024   aeb05b67ddb1c53d149a15ebbd4b8a34b58589afd1a8fa...      0  20171029   \n",
       "925633  a03c77d8fae2995939149204172231e75073cd33917b7a...      0  20170914   \n",
       "145076  671be36a1b9829a30ddbf831574280b936dc050e011ae0...      0  20171006   \n",
       "200921  57877d3a9134f5bf9567b2386e3e2da41ea707ab306013...      0  20170923   \n",
       "409334  5914181c46badfcaf71e099a72342e0587dbb03723fc1c...      0  20170916   \n",
       "...                                                   ...    ...       ...   \n",
       "903324  7201de3ebbeee31e83e400adca5fd87e9603885d53bcfd...      0  20170907   \n",
       "535022  efee32d9e35cdd31855ef239caae554507d450d9f64ecd...      0  20170914   \n",
       "793080  76746f56a24a9150de7caa8651f209f2348744b480775e...      0  20171023   \n",
       "640315  ba7ef2aaabe9dbd85625fa6322f19b0e1e67810217ed6b...      0  20171005   \n",
       "993469  7527f0653a4efa081c2b63b4229545a7c08f502a64b8dd...      0  20171015   \n",
       "\n",
       "        f1  f2  f3  f4          f5  f6  f7  f8  f9  f10  f11  f12  f13  f14  \\\n",
       "18024    2   1   1   0 100802.0000   0   6   2   0    1    1    1    0    1   \n",
       "925633   1   1   1   0 100805.0000   1   2   1   1    1    0    1    1    2   \n",
       "145076   1   0   0   0 100805.0000   0   5   1   1    1    0    1    2    2   \n",
       "200921   1   1   0   0 100802.0000   0   6   2   0    1    0    2    2    1   \n",
       "409334   0   0   1   1 100805.0000   1   5   1   1    1    0    2    0    1   \n",
       "...     ..  ..  ..  ..         ...  ..  ..  ..  ..  ...  ...  ...  ...  ...   \n",
       "903324   0   0   1   0 100803.0000   0   4   1   0    2    1    1    1    1   \n",
       "535022   1   0   1   1         nan   2   7   1   0    0    1    1    1    2   \n",
       "793080   1   1   1   0 100806.0000   1   3   1   1    0    1    2    2    2   \n",
       "640315   1   0   1   1 100806.0000   1   1   2   0    1    0    2    1    1   \n",
       "993469   1   1   1   1         nan   0   3   1   1    1    0    1    0    1   \n",
       "\n",
       "        f15  f16  f17  f18  f19     f20     f21      f22      f23    f24  \\\n",
       "18024     1    1    1    2    2  0.0000  1.0000   1.0000   1.0000 1.0000   \n",
       "925633    2    1    2    1    1 11.0000 10.0000  36.0000  36.0000 0.0000   \n",
       "145076    2    1    2    2    0 31.0000 32.0000 106.0000 108.0000 1.0000   \n",
       "200921    2    0    2    2    2  0.0000  0.0000   0.0000   0.0000 1.0000   \n",
       "409334    0    1    1    2    1  0.0000  1.0000   1.0000   0.0000 1.0000   \n",
       "...     ...  ...  ...  ...  ...     ...     ...      ...      ...    ...   \n",
       "903324    1    1    1    2    1  1.0000  1.0000   0.0000   0.0000 1.0000   \n",
       "535022    1    0    1    2    1     nan     nan      nan      nan    nan   \n",
       "793080    2    2    1    1    0  1.0000  1.0000   0.0000   0.0000 1.0000   \n",
       "640315    0    1    1    1    0  0.0000  0.0000   1.0000   0.0000 0.0000   \n",
       "993469    1    0    1    2    0     nan     nan      nan      nan    nan   \n",
       "\n",
       "          f25    f26    f27    f28    f29    f30    f31    f32     f33    f34  \\\n",
       "18024  0.0000 1.0000 0.0000 0.0000 0.0000 1.0000 0.0000 0.0000  0.0000 1.0000   \n",
       "925633 1.0000 0.0000 0.0000 0.0000 0.0000 1.0000 1.0000 0.0000  0.0000 0.0000   \n",
       "145076 0.0000 0.0000 1.0000 0.0000 1.0000 0.0000 0.0000    nan     nan    nan   \n",
       "200921 1.0000 1.0000 0.0000 1.0000 1.0000 0.0000 1.0000 1.0000  1.0000 1.0000   \n",
       "409334 1.0000 1.0000 1.0000 1.0000 0.0000 0.0000 1.0000 1.0000  1.0000 1.0000   \n",
       "...       ...    ...    ...    ...    ...    ...    ...    ...     ...    ...   \n",
       "903324 1.0000 1.0000 0.0000 0.0000 0.0000 1.0000 0.0000 1.0000  2.0000 3.0000   \n",
       "535022    nan    nan    nan    nan    nan    nan    nan    nan     nan    nan   \n",
       "793080 1.0000 0.0000 0.0000 1.0000 0.0000 0.0000 0.0000 6.0000 12.0000 6.0000   \n",
       "640315 0.0000 1.0000 0.0000 0.0000 0.0000 1.0000 1.0000 0.0000  0.0000 0.0000   \n",
       "993469    nan    nan    nan    nan    nan    nan    nan    nan     nan    nan   \n",
       "\n",
       "           f35  f36  f37  f38  f39  f40  f41  f42  f43  f44  f45  f46  f47  \\\n",
       "18024   0.0000  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan   \n",
       "925633  0.0000  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan   \n",
       "145076     nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan   \n",
       "200921  0.0000  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan   \n",
       "409334  0.0000  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan   \n",
       "...        ...  ...  ...  ...  ...  ...  ...  ...  ...  ...  ...  ...  ...   \n",
       "903324  2.0000  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan   \n",
       "535022     nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan   \n",
       "793080 12.0000  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan   \n",
       "640315  1.0000  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan   \n",
       "993469     nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan  nan   \n",
       "\n",
       "          f48     f49    f50     f51    f52    f53    f54    f55    f56  \\\n",
       "18024  1.0000  0.0000 1.0000  1.0000 1.0000 1.0000 1.0000 1.0000 1.0000   \n",
       "925633 1.0000  1.0000 0.0000  1.0000 0.0000 1.0000 1.0000 1.0000 1.0000   \n",
       "145076    nan     nan    nan     nan 1.0000 1.0000    nan    nan    nan   \n",
       "200921 1.0000  1.0000 1.0000  0.0000 1.0000 1.0000 2.0000 2.0000 2.0000   \n",
       "409334 1.0000  0.0000 0.0000  0.0000 0.0000 0.0000 1.0000 1.0000 2.0000   \n",
       "...       ...     ...    ...     ...    ...    ...    ...    ...    ...   \n",
       "903324 1.0000  1.0000 3.0000  2.0000 0.0000 1.0000 1.0000 4.0000 6.0000   \n",
       "535022    nan     nan    nan     nan    nan    nan    nan    nan    nan   \n",
       "793080 6.0000 11.0000 6.0000 13.0000 1.0000 0.0000 1.0000 1.0000 1.0000   \n",
       "640315 1.0000  1.0000 0.0000  0.0000 1.0000 1.0000 3.0000 2.0000 3.0000   \n",
       "993469    nan     nan    nan     nan    nan    nan    nan    nan    nan   \n",
       "\n",
       "          f57    f58    f59    f60    f61    f62    f63     f64     f65  \\\n",
       "18024  1.0000 2.0000 2.0000 2.0000 1.0000 1.0000 1.0000  2.0000  1.0000   \n",
       "925633 1.0000 1.0000 1.0000 1.0000 2.0000 2.0000 1.0000 78.0000 36.0000   \n",
       "145076    nan    nan    nan    nan    nan    nan    nan 91.0000 26.0000   \n",
       "200921 1.0000 2.0000 2.0000 2.0000 1.0000 2.0000 2.0000  2.0000  1.0000   \n",
       "409334 1.0000 2.0000 1.0000 2.0000 1.0000 2.0000 1.0000  1.0000  1.0000   \n",
       "...       ...    ...    ...    ...    ...    ...    ...     ...     ...   \n",
       "903324 6.0000 5.0000 2.0000 3.0000 3.0000 4.0000 4.0000  2.0000  1.0000   \n",
       "535022    nan    nan    nan    nan    nan    nan    nan     nan     nan   \n",
       "793080 1.0000 2.0000 2.0000 1.0000 2.0000 2.0000 2.0000  2.0000  2.0000   \n",
       "640315 2.0000 3.0000 2.0000 2.0000 2.0000 1.0000 3.0000  3.0000  1.0000   \n",
       "993469    nan    nan    nan    nan    nan    nan    nan     nan     nan   \n",
       "\n",
       "            f66      f67      f68      f69      f70      f71     f72     f73  \\\n",
       "18024    5.0000   2.0000   2.0000   2.0000   1.0000   1.0000  5.0000 10.0000   \n",
       "925633 302.0000 301.0000 301.0000 301.0000 301.0000 301.0000 40.0000 58.0000   \n",
       "145076 301.0000 252.0000 301.0000 302.0000 301.0000 302.0000 22.0000 48.0000   \n",
       "200921   4.0000   1.0000   1.0000   1.0000   2.0000   1.0000  1.0000  3.0000   \n",
       "409334   2.0000   2.0000   1.0000   2.0000   2.0000   2.0000 32.0000 43.0000   \n",
       "...         ...      ...      ...      ...      ...      ...     ...     ...   \n",
       "903324   9.0000   1.0000   7.0000   8.0000   9.0000  10.0000 12.0000 11.0000   \n",
       "535022      nan      nan      nan      nan      nan      nan     nan     nan   \n",
       "793080  22.0000   3.0000   4.0000   3.0000   7.0000   7.0000 18.0000 34.0000   \n",
       "640315  13.0000   3.0000   2.0000   2.0000   2.0000   5.0000  6.0000 10.0000   \n",
       "993469      nan      nan      nan      nan      nan      nan     nan     nan   \n",
       "\n",
       "           f74     f75     f76     f77     f78     f79     f80     f81  \\\n",
       "18024   4.0000 11.0000  2.0000  1.0000  1.0000  1.0000  6.0000 11.0000   \n",
       "925633 40.0000 58.0000  2.0000  4.0000  4.0000 10.0000 41.0000 60.0000   \n",
       "145076 23.0000 49.0000  3.0000  2.0000  3.0000  3.0000 23.0000 51.0000   \n",
       "200921  1.0000  4.0000  1.0000  1.0000  1.0000  1.0000  2.0000  5.0000   \n",
       "409334 33.0000 44.0000  2.0000  3.0000  5.0000  5.0000 41.0000 56.0000   \n",
       "...        ...     ...     ...     ...     ...     ...     ...     ...   \n",
       "903324 11.0000 11.0000  2.0000  5.0000  8.0000  8.0000 13.0000 14.0000   \n",
       "535022     nan     nan     nan     nan     nan     nan     nan     nan   \n",
       "793080 18.0000 34.0000 12.0000 11.0000 11.0000 12.0000 22.0000 62.0000   \n",
       "640315  6.0000 10.0000  2.0000  3.0000  2.0000  4.0000  7.0000 11.0000   \n",
       "993469     nan     nan     nan     nan     nan     nan     nan     nan   \n",
       "\n",
       "             f82        f83        f84       f85       f86    f87    f88  \\\n",
       "18024    70.0000  1667.0000  3665.7000   69.0000 1364.0000 2.0000 2.0000   \n",
       "925633  612.0000  3147.7000  5311.3000  984.7000 2862.2000 1.0000 2.0000   \n",
       "145076 2053.9000 21354.9000 45776.1000 2054.9000 2054.9000 2.0000 2.0000   \n",
       "200921  198.9000   245.9000   301.8000  197.9000  246.9000 2.0000 2.0000   \n",
       "409334  421.0000  9063.6000  9351.0000 1735.8000 8590.9000 1.0000 3.0000   \n",
       "...          ...        ...        ...       ...       ...    ...    ...   \n",
       "903324  500.0000  5190.7000  5191.7000 4413.0000 5190.7000 2.0000 2.0000   \n",
       "535022       nan        nan        nan       nan       nan    nan    nan   \n",
       "793080  996.2000 22718.8000 40335.6000  995.2000 3901.5000 2.0000 1.0000   \n",
       "640315   39.9000   268.0000  1768.0000  119.5000  120.5000 1.0000 2.0000   \n",
       "993469       nan        nan        nan       nan       nan    nan    nan   \n",
       "\n",
       "          f89    f90    f91    f92    f93    f94    f95    f96    f97    f98  \\\n",
       "18024  1.0000 1.0000 1.0000 1.0000 2.0000 1.0000 1.0000 2.0000 1.0000 3.0000   \n",
       "925633 1.0000 2.0000 2.0000 2.0000 1.0000 1.0000 2.0000 1.0000 2.0000 4.0000   \n",
       "145076 2.0000 2.0000 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000 2.0000 2.0000   \n",
       "200921 1.0000 2.0000 2.0000 2.0000 2.0000 2.0000 2.0000 1.0000 2.0000 3.0000   \n",
       "409334 4.0000 4.0000 4.0000 2.0000 1.0000 2.0000 2.0000 2.0000 1.0000 4.0000   \n",
       "...       ...    ...    ...    ...    ...    ...    ...    ...    ...    ...   \n",
       "903324 2.0000 2.0000 1.0000 1.0000 2.0000 2.0000 3.0000 2.0000 3.0000 3.0000   \n",
       "535022    nan    nan    nan    nan    nan    nan    nan    nan    nan    nan   \n",
       "793080 1.0000 2.0000 2.0000 1.0000 2.0000 2.0000 1.0000 1.0000 1.0000 3.0000   \n",
       "640315 2.0000 1.0000 3.0000 2.0000 1.0000 2.0000 2.0000 1.0000 2.0000 2.0000   \n",
       "993469    nan    nan    nan    nan    nan    nan    nan    nan    nan    nan   \n",
       "\n",
       "          f99    f100    f101    f102    f103    f104    f105    f106    f107  \\\n",
       "18024  5.0000  8.0000 15.0000  1.0000  3.0000  5.0000 11.0000 25.0000  2.0000   \n",
       "925633 9.0000 11.0000 10.0000 10.0000 24.0000 40.0000 57.0000 57.0000 10.0000   \n",
       "145076 4.0000 10.0000 18.0000  2.0000  3.0000 24.0000 50.0000 96.0000  3.0000   \n",
       "200921 3.0000  4.0000  4.0000  1.0000  3.0000  3.0000  5.0000  4.0000  2.0000   \n",
       "409334 9.0000 13.0000 12.0000  3.0000 12.0000 21.0000 27.0000 26.0000  6.0000   \n",
       "...       ...     ...     ...     ...     ...     ...     ...     ...     ...   \n",
       "903324 3.0000  4.0000  3.0000  8.0000 13.0000 14.0000 13.0000 14.0000  7.0000   \n",
       "535022    nan     nan     nan     nan     nan     nan     nan     nan     nan   \n",
       "793080 6.0000 12.0000 25.0000 12.0000 17.0000 20.0000 35.0000 49.0000 11.0000   \n",
       "640315 3.0000  5.0000 12.0000  3.0000  3.0000  8.0000  9.0000 21.0000  4.0000   \n",
       "993469    nan     nan     nan     nan     nan     nan     nan     nan     nan   \n",
       "\n",
       "          f108    f109    f110     f111     f112     f113     f114     f115  \\\n",
       "18024   2.0000  6.0000 11.0000   1.0000   2.0000   1.0000   2.0000   2.0000   \n",
       "925633 24.0000 40.0000 59.0000 230.0000 231.0000 226.0000 227.0000 227.0000   \n",
       "145076  3.0000 24.0000 50.0000 190.0000 190.0000 162.0000 188.0000 188.0000   \n",
       "200921  2.0000  3.0000  5.0000   2.0000   2.0000   1.0000   2.0000   2.0000   \n",
       "409334 18.0000 33.0000 45.0000   2.0000   2.0000   2.0000   1.0000   1.0000   \n",
       "...        ...     ...     ...      ...      ...      ...      ...      ...   \n",
       "903324 12.0000 13.0000 13.0000   2.0000   1.0000   1.0000   1.0000   1.0000   \n",
       "535022     nan     nan     nan      nan      nan      nan      nan      nan   \n",
       "793080 18.0000 20.0000 35.0000   1.0000   1.0000   1.0000   1.0000   2.0000   \n",
       "640315  4.0000  8.0000 12.0000   2.0000   1.0000   1.0000   2.0000   2.0000   \n",
       "993469     nan     nan     nan      nan      nan      nan      nan      nan   \n",
       "\n",
       "           f116     f117     f118     f119     f120     f121     f122    f123  \\\n",
       "18024    2.0000   2.0000   1.0000   1.0000   2.0000   1.0000   1.0000  1.0000   \n",
       "925633 227.0000 230.0000 230.0000 230.0000 227.0000 227.0000 227.0000 32.0000   \n",
       "145076 189.0000 190.0000 190.0000 189.0000 163.0000 188.0000 189.0000 33.0000   \n",
       "200921   1.0000   1.0000   2.0000   1.0000   2.0000   1.0000   1.0000  2.0000   \n",
       "409334   1.0000   2.0000   1.0000   1.0000   1.0000   1.0000   2.0000  1.0000   \n",
       "...         ...      ...      ...      ...      ...      ...      ...     ...   \n",
       "903324   2.0000   2.0000   2.0000   2.0000   2.0000   2.0000   1.0000  1.0000   \n",
       "535022      nan      nan      nan      nan      nan      nan      nan     nan   \n",
       "793080   1.0000   1.0000   2.0000   1.0000   1.0000   1.0000   2.0000  2.0000   \n",
       "640315   1.0000   2.0000   2.0000   2.0000   1.0000   1.0000   2.0000  2.0000   \n",
       "993469      nan      nan      nan      nan      nan      nan      nan     nan   \n",
       "\n",
       "          f124    f125    f126    f127    f128    f129    f130    f131  \\\n",
       "18024   1.0000  2.0000  1.0000  2.0000  2.0000  1.0000  2.0000  2.0000   \n",
       "925633 32.0000 29.0000 29.0000 29.0000 30.0000 32.0000 78.0000 44.0000   \n",
       "145076 35.0000 27.0000 26.0000 27.0000 26.0000 31.0000 80.0000 42.0000   \n",
       "200921  2.0000  1.0000  1.0000  2.0000  1.0000  2.0000  2.0000  1.0000   \n",
       "409334  2.0000  1.0000  2.0000  1.0000  2.0000  2.0000  2.0000  1.0000   \n",
       "...        ...     ...     ...     ...     ...     ...     ...     ...   \n",
       "903324  1.0000  2.0000  1.0000  1.0000  1.0000  1.0000  1.0000  1.0000   \n",
       "535022     nan     nan     nan     nan     nan     nan     nan     nan   \n",
       "793080  2.0000  2.0000  1.0000  1.0000  1.0000  1.0000  1.0000  1.0000   \n",
       "640315  1.0000  2.0000  2.0000  1.0000  1.0000  2.0000  2.0000  2.0000   \n",
       "993469     nan     nan     nan     nan     nan     nan     nan     nan   \n",
       "\n",
       "          f132    f133    f134    f135    f136    f137    f138    f139  \\\n",
       "18024   1.0000  1.0000  1.0000  1.0000  2.0000  2.0000  2.0000  1.0000   \n",
       "925633 44.0000 44.0000 67.0000 32.0000 32.0000 29.0000 28.0000 29.0000   \n",
       "145076 43.0000 42.0000 61.0000 31.0000 31.0000 24.0000 25.0000 25.0000   \n",
       "200921  2.0000  1.0000  1.0000  2.0000  1.0000  1.0000  1.0000  1.0000   \n",
       "409334  1.0000  2.0000  1.0000  2.0000  1.0000  1.0000  1.0000  2.0000   \n",
       "...        ...     ...     ...     ...     ...     ...     ...     ...   \n",
       "903324  1.0000  1.0000  1.0000  2.0000  1.0000  2.0000  2.0000  1.0000   \n",
       "535022     nan     nan     nan     nan     nan     nan     nan     nan   \n",
       "793080  1.0000  1.0000  1.0000  1.0000  2.0000  1.0000  1.0000  2.0000   \n",
       "640315  1.0000  1.0000  3.0000  1.0000  2.0000  1.0000  2.0000  1.0000   \n",
       "993469     nan     nan     nan     nan     nan     nan     nan     nan   \n",
       "\n",
       "          f140    f141     f142     f143     f144     f145     f146     f147  \\\n",
       "18024   2.0000  2.0000   2.0000   2.0000   1.0000   1.0000   2.0000   2.0000   \n",
       "925633 29.0000 31.0000 233.0000 233.0000 159.0000 160.0000 160.0000 160.0000   \n",
       "145076 24.0000 29.0000 233.0000 233.0000 114.0000 129.0000 130.0000 129.0000   \n",
       "200921  2.0000  2.0000   2.0000   1.0000   2.0000   1.0000   1.0000   2.0000   \n",
       "409334  2.0000  1.0000   1.0000   2.0000   1.0000   1.0000   2.0000   1.0000   \n",
       "...        ...     ...      ...      ...      ...      ...      ...      ...   \n",
       "903324  2.0000  2.0000   1.0000   1.0000   2.0000   1.0000   1.0000   1.0000   \n",
       "535022     nan     nan      nan      nan      nan      nan      nan      nan   \n",
       "793080  2.0000  2.0000   1.0000   1.0000   2.0000   2.0000   2.0000   2.0000   \n",
       "640315  1.0000  2.0000   2.0000   2.0000   2.0000   1.0000   1.0000   2.0000   \n",
       "993469     nan     nan      nan      nan      nan      nan      nan      nan   \n",
       "\n",
       "           f148     f149     f150     f151     f152     f153     f154   f155  \\\n",
       "18024    1.0000   1.0000   1.0000   1.0000   2.0000   2.0000   2.0000 1.0000   \n",
       "925633 233.0000 230.0000 231.0000 226.0000 227.0000 226.0000 302.0000 1.0000   \n",
       "145076 233.0000 190.0000 190.0000 163.0000 189.0000 188.0000 301.0000 1.0000   \n",
       "200921   1.0000   1.0000   2.0000   1.0000   1.0000   1.0000   3.0000 2.0000   \n",
       "409334   1.0000   1.0000   2.0000   1.0000   1.0000   1.0000   2.0000 1.0000   \n",
       "...         ...      ...      ...      ...      ...      ...      ...    ...   \n",
       "903324   2.0000   2.0000   2.0000   1.0000   1.0000   2.0000  10.0000 2.0000   \n",
       "535022      nan      nan      nan      nan      nan      nan      nan    nan   \n",
       "793080   2.0000   1.0000   1.0000   2.0000   2.0000   2.0000  12.0000 2.0000   \n",
       "640315   1.0000   2.0000   1.0000   1.0000   2.0000   1.0000   5.0000 2.0000   \n",
       "993469      nan      nan      nan      nan      nan      nan      nan    nan   \n",
       "\n",
       "         f156   f157   f158   f159   f160     f161     f162     f163     f164  \\\n",
       "18024  2.0000 2.0000 2.0000 1.0000 1.0000   1.0000   2.0000   2.0000   2.0000   \n",
       "925633 2.0000 1.0000 2.0000 2.0000 1.0000   2.0000   2.0000   3.0000   2.0000   \n",
       "145076 1.0000 2.0000 1.0000 2.0000 1.0000   2.0000   1.0000   1.0000   1.0000   \n",
       "200921 1.0000 1.0000 2.0000 1.0000 1.0000   1.0000   2.0000   1.0000   2.0000   \n",
       "409334 1.0000 1.0000 1.0000 1.0000 2.0000   2.0000   2.0000   2.0000   2.0000   \n",
       "...       ...    ...    ...    ...    ...      ...      ...      ...      ...   \n",
       "903324 2.0000 1.0000 1.0000 1.0000 1.0000   2.0000   2.0000   2.0000   1.0000   \n",
       "535022    nan    nan    nan    nan    nan   1.0000   2.0000   2.0000   2.0000   \n",
       "793080 2.0000 2.0000 1.0000 1.0000 1.0000   1.0000   2.0000   2.0000   1.0000   \n",
       "640315 1.0000 2.0000 1.0000 1.0000 1.0000   2.0000   2.0000   1.0000   1.0000   \n",
       "993469    nan    nan    nan    nan    nan 104.0000 201.0000 240.0000 240.0000   \n",
       "\n",
       "           f165   f166   f167   f168   f169   f170   f171   f172   f173  \\\n",
       "18024    2.0000 1.0000 2.0000 2.0000 2.0000 2.0000 2.0000 2.0000 1.0000   \n",
       "925633   2.0000 2.0000 1.0000 2.0000 1.0000 1.0000 1.0000 2.0000 2.0000   \n",
       "145076   1.0000 1.0000 1.0000 2.0000 2.0000 1.0000 1.0000 2.0000 1.0000   \n",
       "200921   2.0000 1.0000 1.0000 1.0000 1.0000 2.0000 2.0000 1.0000 2.0000   \n",
       "409334   2.0000 1.0000 2.0000 1.0000 1.0000 2.0000 1.0000 1.0000 2.0000   \n",
       "...         ...    ...    ...    ...    ...    ...    ...    ...    ...   \n",
       "903324   1.0000 2.0000 1.0000 2.0000 1.0000 1.0000 2.0000 1.0000 1.0000   \n",
       "535022   1.0000    nan    nan    nan    nan    nan    nan    nan    nan   \n",
       "793080   1.0000 1.0000 1.0000 1.0000 1.0000 2.0000 2.0000 1.0000 2.0000   \n",
       "640315   1.0000 2.0000 1.0000 2.0000 1.0000 2.0000 1.0000 2.0000 1.0000   \n",
       "993469 105.0000 1.0000 1.0000 1.0000 1.0000 2.0000 1.0000 2.0000 1.0000   \n",
       "\n",
       "         f174   f175   f176   f177   f178   f179   f180   f181   f182   f183  \\\n",
       "18024  1.0000 1.0000 1.0000 1.0000 1.0000 2.0000 2.0000 2.0000 1.0000 3.0000   \n",
       "925633 2.0000 2.0000 2.0000 2.0000 1.0000 1.0000 1.0000 2.0000 2.0000 1.0000   \n",
       "145076 2.0000 1.0000 1.0000 1.0000 2.0000 1.0000 2.0000 2.0000 2.0000 2.0000   \n",
       "200921 1.0000 1.0000 1.0000 1.0000 2.0000 1.0000 2.0000 2.0000 1.0000 1.0000   \n",
       "409334 2.0000 2.0000 3.0000 3.0000 2.0000 2.0000 3.0000 2.0000 3.0000 4.0000   \n",
       "...       ...    ...    ...    ...    ...    ...    ...    ...    ...    ...   \n",
       "903324 1.0000 1.0000 1.0000 2.0000 1.0000 2.0000 2.0000 1.0000 1.0000 1.0000   \n",
       "535022    nan    nan    nan    nan    nan    nan    nan    nan    nan    nan   \n",
       "793080 2.0000 2.0000 2.0000 1.0000 1.0000 3.0000 3.0000 3.0000 3.0000 4.0000   \n",
       "640315 1.0000 2.0000 2.0000 3.0000 3.0000 2.0000 2.0000 2.0000 2.0000 2.0000   \n",
       "993469 2.0000 2.0000 2.0000 3.0000 3.0000 1.0000 1.0000 1.0000 3.0000 3.0000   \n",
       "\n",
       "         f184   f185   f186   f187   f188   f189   f190   f191   f192   f193  \\\n",
       "18024  3.0000 4.0000 1.0000 2.0000 2.0000 1.0000 2.0000 1.0000 1.0000 2.0000   \n",
       "925633 3.0000 2.0000 2.0000 2.0000 2.0000 2.0000 1.0000 1.0000 1.0000 1.0000   \n",
       "145076 2.0000 1.0000 2.0000 1.0000 2.0000 2.0000 2.0000 2.0000 1.0000 2.0000   \n",
       "200921 2.0000 2.0000 2.0000 2.0000 2.0000 2.0000 2.0000 2.0000 1.0000 1.0000   \n",
       "409334 4.0000 4.0000 1.0000 1.0000 2.0000 1.0000 1.0000 2.0000 2.0000 1.0000   \n",
       "...       ...    ...    ...    ...    ...    ...    ...    ...    ...    ...   \n",
       "903324 1.0000 1.0000 1.0000 2.0000 1.0000 1.0000 2.0000 1.0000 1.0000 1.0000   \n",
       "535022    nan    nan    nan    nan    nan    nan    nan    nan    nan    nan   \n",
       "793080 4.0000 4.0000 1.0000 1.0000 1.0000 2.0000 1.0000 2.0000 1.0000 1.0000   \n",
       "640315 3.0000 3.0000 2.0000 1.0000 1.0000 2.0000 1.0000 2.0000 1.0000 2.0000   \n",
       "993469 3.0000 3.0000 1.0000 2.0000 2.0000 1.0000 2.0000 1.0000 1.0000 1.0000   \n",
       "\n",
       "         f194   f195   f196   f197   f198   f199   f200   f201   f202   f203  \\\n",
       "18024  1.0000 1.0000 2.0000 1.0000 2.0000 1.0000 2.0000 2.0000 1.0000 2.0000   \n",
       "925633 1.0000 1.0000 2.0000 2.0000 1.0000 2.0000 1.0000 1.0000 1.0000 2.0000   \n",
       "145076 2.0000 2.0000 2.0000 1.0000 2.0000 2.0000 2.0000 1.0000 2.0000 2.0000   \n",
       "200921 2.0000 2.0000 2.0000 2.0000 1.0000 1.0000 1.0000 1.0000 2.0000 1.0000   \n",
       "409334 2.0000 1.0000 2.0000 1.0000 1.0000 1.0000 2.0000 2.0000 2.0000 2.0000   \n",
       "...       ...    ...    ...    ...    ...    ...    ...    ...    ...    ...   \n",
       "903324 2.0000 2.0000 2.0000 1.0000 1.0000 2.0000 1.0000 1.0000 2.0000 1.0000   \n",
       "535022    nan    nan    nan    nan    nan    nan    nan    nan    nan    nan   \n",
       "793080 1.0000 1.0000 1.0000 1.0000 2.0000 1.0000 1.0000 1.0000 1.0000 2.0000   \n",
       "640315 2.0000 2.0000 1.0000 2.0000 1.0000 2.0000 2.0000 1.0000 1.0000 2.0000   \n",
       "993469 2.0000 1.0000 2.0000 2.0000 1.0000 2.0000 2.0000 2.0000 1.0000 2.0000   \n",
       "\n",
       "          f204    f205    f206    f207    f208    f209    f210     f211  \\\n",
       "18024   2.0000  1.0000  2.0000  2.0000  6.0000 11.0000 24.0000   2.0000   \n",
       "925633  2.0000  5.0000  9.0000 25.0000 40.0000 59.0000 59.0000   2.0000   \n",
       "145076  2.0000  2.0000  3.0000  3.0000 24.0000 50.0000 97.0000   2.0000   \n",
       "200921  2.0000  1.0000  1.0000  3.0000  2.0000  5.0000  5.0000   1.0000   \n",
       "409334  1.0000  5.0000  6.0000 18.0000 33.0000 44.0000 44.0000   1.0000   \n",
       "...        ...     ...     ...     ...     ...     ...     ...      ...   \n",
       "903324  1.0000  7.0000  6.0000 12.0000 13.0000 13.0000 12.0000   1.0000   \n",
       "535022     nan     nan     nan     nan     nan     nan     nan   2.0000   \n",
       "793080 12.0000 12.0000 11.0000 18.0000 19.0000 34.0000 50.0000   2.0000   \n",
       "640315  3.0000  2.0000  4.0000  4.0000  8.0000 12.0000 24.0000   2.0000   \n",
       "993469  2.0000  2.0000  2.0000  4.0000  5.0000  9.0000 20.0000 105.0000   \n",
       "\n",
       "           f212     f213     f214     f215     f216     f217     f218    f219  \\\n",
       "18024    2.0000   1.0000   1.0000   1.0000   1.0000   2.0000   2.0000  2.0000   \n",
       "925633   2.0000   2.0000   3.0000   2.0000   3.0000   2.0000   2.0000  1.0000   \n",
       "145076   2.0000   2.0000   2.0000   3.0000   3.0000   2.0000   2.0000  2.0000   \n",
       "200921   1.0000   1.0000   2.0000   2.0000   2.0000   1.0000   1.0000  1.0000   \n",
       "409334   1.0000   2.0000   1.0000   1.0000   1.0000   2.0000   1.0000  2.0000   \n",
       "...         ...      ...      ...      ...      ...      ...      ...     ...   \n",
       "903324   1.0000   2.0000   2.0000   2.0000   8.0000   8.0000   7.0000  1.0000   \n",
       "535022   1.0000   2.0000   1.0000   1.0000   3.0000   3.0000   3.0000  2.0000   \n",
       "793080   1.0000   1.0000   2.0000   4.0000   4.0000   4.0000   3.0000  2.0000   \n",
       "640315   1.0000   1.0000   1.0000   2.0000   3.0000   2.0000   3.0000  1.0000   \n",
       "993469 202.0000 239.0000 239.0000 128.0000 254.0000 301.0000 301.0000 21.0000   \n",
       "\n",
       "          f220    f221    f222    f223     f224     f225     f226     f227  \\\n",
       "18024   2.0000  2.0000  1.0000  2.0000   2.0000   1.0000   1.0000   1.0000   \n",
       "925633  1.0000  1.0000  1.0000  1.0000   3.0000   3.0000   3.0000   3.0000   \n",
       "145076  2.0000  1.0000  1.0000  2.0000   2.0000   1.0000   1.0000   1.0000   \n",
       "200921  2.0000  2.0000  2.0000  1.0000   1.0000   2.0000   2.0000   1.0000   \n",
       "409334  1.0000  1.0000  2.0000  2.0000   2.0000   2.0000   1.0000   1.0000   \n",
       "...        ...     ...     ...     ...      ...      ...      ...      ...   \n",
       "903324  1.0000  1.0000  1.0000  2.0000   2.0000   1.0000   1.0000   2.0000   \n",
       "535022  2.0000  1.0000  1.0000  1.0000   1.0000   2.0000   2.0000   1.0000   \n",
       "793080  1.0000  2.0000  1.0000  1.0000   1.0000   1.0000   1.0000   1.0000   \n",
       "640315  1.0000  1.0000  1.0000  1.0000   1.0000   2.0000   2.0000   1.0000   \n",
       "993469 25.0000 27.0000 27.0000 76.0000 121.0000 139.0000 138.0000 202.0000   \n",
       "\n",
       "           f228     f229    f230     f231     f232     f233    f234    f235  \\\n",
       "18024    1.0000   2.0000  1.0000   2.0000   2.0000   1.0000  1.0000  1.0000   \n",
       "925633   2.0000   2.0000  2.0000   3.0000   2.0000   3.0000  2.0000  1.0000   \n",
       "145076   2.0000   1.0000  1.0000   1.0000   2.0000   2.0000  2.0000  1.0000   \n",
       "200921   1.0000   1.0000  2.0000   1.0000   2.0000   1.0000  2.0000  2.0000   \n",
       "409334   2.0000   2.0000  1.0000   2.0000   1.0000   2.0000  1.0000  2.0000   \n",
       "...         ...      ...     ...      ...      ...      ...     ...     ...   \n",
       "903324   2.0000   2.0000  2.0000   2.0000   3.0000   3.0000  2.0000  3.0000   \n",
       "535022   2.0000   1.0000  2.0000   2.0000   1.0000   2.0000  2.0000  2.0000   \n",
       "793080   2.0000   2.0000  1.0000   2.0000   2.0000   1.0000  2.0000  1.0000   \n",
       "640315   2.0000   2.0000  2.0000   1.0000   1.0000   1.0000  2.0000  1.0000   \n",
       "993469 240.0000 239.0000 93.0000 171.0000 249.0000 248.0000 21.0000 58.0000   \n",
       "\n",
       "           f236     f237     f238    f239    f240     f241     f242     f243  \\\n",
       "18024    1.0000   2.0000   1.0000  2.0000  2.0000   1.0000   2.0000   2.0000   \n",
       "925633   2.0000   2.0000   3.0000  2.0000  2.0000   2.0000   1.0000   3.0000   \n",
       "145076   2.0000   1.0000   2.0000  2.0000  2.0000   2.0000   2.0000   1.0000   \n",
       "200921   2.0000   2.0000   1.0000  1.0000  1.0000   2.0000   2.0000   2.0000   \n",
       "409334   2.0000   1.0000   1.0000  2.0000  2.0000   1.0000   1.0000   2.0000   \n",
       "...         ...      ...      ...     ...     ...      ...      ...      ...   \n",
       "903324   2.0000   2.0000   3.0000  2.0000  1.0000   1.0000   2.0000   2.0000   \n",
       "535022   2.0000   2.0000   2.0000  1.0000  2.0000   1.0000   2.0000   2.0000   \n",
       "793080   2.0000   1.0000   2.0000  1.0000  1.0000   2.0000   1.0000   1.0000   \n",
       "640315   2.0000   2.0000   2.0000  1.0000  2.0000   2.0000   2.0000   2.0000   \n",
       "993469 173.0000 322.0000 418.0000 16.0000 41.0000 121.0000 198.0000 202.0000   \n",
       "\n",
       "          f244     f245     f246     f247     f248    f249     f250     f251  \\\n",
       "18024   2.0000   2.0000   1.0000   2.0000   2.0000  2.0000   2.0000   1.0000   \n",
       "925633  2.0000   2.0000   2.0000   2.0000   3.0000  1.0000   2.0000   2.0000   \n",
       "145076  2.0000   3.0000   3.0000  24.0000  24.0000  1.0000   2.0000   1.0000   \n",
       "200921  1.0000   2.0000   2.0000   1.0000   1.0000  2.0000   1.0000   1.0000   \n",
       "409334  2.0000   2.0000   1.0000   1.0000   2.0000  2.0000   1.0000   1.0000   \n",
       "...        ...      ...      ...      ...      ...     ...      ...      ...   \n",
       "903324  1.0000   6.0000   6.0000   5.0000   5.0000  2.0000   2.0000   1.0000   \n",
       "535022  2.0000   3.0000   3.0000   3.0000   3.0000  2.0000   2.0000   1.0000   \n",
       "793080  3.0000   4.0000   3.0000   4.0000   4.0000  1.0000   2.0000   2.0000   \n",
       "640315  3.0000   2.0000   3.0000   3.0000   3.0000  2.0000   1.0000   1.0000   \n",
       "993469 69.0000 127.0000 302.0000 303.0000 303.0000 60.0000 106.0000 248.0000   \n",
       "\n",
       "           f252     f253   f254   f255   f256   f257   f258   f259   f260  \\\n",
       "18024    1.0000   2.0000 2.0000 1.0000 2.0000 1.0000 1.0000 1.0000 1.0000   \n",
       "925633   3.0000   4.0000 1.0000 1.0000 2.0000 1.0000 2.0000 2.0000 1.0000   \n",
       "145076   2.0000   1.0000 2.0000 1.0000 1.0000 1.0000 2.0000 1.0000 1.0000   \n",
       "200921   1.0000   2.0000 2.0000 2.0000 2.0000 2.0000 1.0000 2.0000 1.0000   \n",
       "409334   2.0000   1.0000 1.0000 1.0000 2.0000 1.0000 2.0000 1.0000 1.0000   \n",
       "...         ...      ...    ...    ...    ...    ...    ...    ...    ...   \n",
       "903324   1.0000   2.0000 2.0000 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000   \n",
       "535022   1.0000   1.0000    nan    nan    nan    nan    nan    nan    nan   \n",
       "793080   1.0000   2.0000 1.0000 2.0000 1.0000 1.0000 2.0000 2.0000 2.0000   \n",
       "640315   1.0000   2.0000 1.0000 2.0000 2.0000 2.0000 2.0000 2.0000 1.0000   \n",
       "993469 248.0000 248.0000 2.0000 2.0000 2.0000 2.0000 1.0000 1.0000 1.0000   \n",
       "\n",
       "         f261   f262   f263   f264   f265   f266   f267   f268   f269   f270  \\\n",
       "18024  1.0000 1.0000 2.0000 1.0000 1.0000 2.0000 1.0000 1.0000 1.0000 2.0000   \n",
       "925633 2.0000 1.0000 3.0000 2.0000 2.0000 2.0000 2.0000 2.0000 1.0000 2.0000   \n",
       "145076 2.0000 1.0000 2.0000 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000   \n",
       "200921 1.0000 2.0000 2.0000 2.0000 2.0000 3.0000 2.0000 1.0000 2.0000 2.0000   \n",
       "409334 1.0000 2.0000 3.0000 1.0000 2.0000 3.0000 2.0000 1.0000 1.0000 1.0000   \n",
       "...       ...    ...    ...    ...    ...    ...    ...    ...    ...    ...   \n",
       "903324 2.0000 3.0000 2.0000 1.0000 3.0000 2.0000 2.0000 2.0000 2.0000 1.0000   \n",
       "535022    nan    nan    nan    nan    nan    nan    nan    nan    nan    nan   \n",
       "793080 1.0000 1.0000 1.0000 2.0000 1.0000 2.0000 2.0000 2.0000 2.0000 2.0000   \n",
       "640315 2.0000 1.0000 1.0000 1.0000 2.0000 2.0000 2.0000 1.0000 2.0000 1.0000   \n",
       "993469 2.0000 1.0000 2.0000 1.0000 2.0000 2.0000 1.0000 2.0000 2.0000 1.0000   \n",
       "\n",
       "         f271   f272   f273   f274   f275   f276   f277    f278     f279  \\\n",
       "18024  2.0000 2.0000 1.0000 1.0000 1.0000 0.0000 1.0000  2.0000   2.0000   \n",
       "925633 1.0000 2.0000 2.0000 1.0000 2.0000 0.0000 2.0000 32.0000 182.0000   \n",
       "145076 1.0000 1.0000 2.0000 1.0000 1.0000 0.0000 0.0000 22.0000 122.0000   \n",
       "200921 2.0000 1.0000 2.0000 1.0000 1.0000 0.0000 1.0000  1.0000   2.0000   \n",
       "409334 1.0000 1.0000 1.0000 1.0000 1.0000 0.0000 2.0000  2.0000   2.0000   \n",
       "...       ...    ...    ...    ...    ...    ...    ...     ...      ...   \n",
       "903324 1.0000 1.0000 1.0000 2.0000 2.0000 2.0000 2.0000  2.0000   2.0000   \n",
       "535022    nan    nan    nan    nan    nan    nan    nan     nan      nan   \n",
       "793080 2.0000 2.0000 2.0000 0.0000 0.0000 1.0000 0.0000  2.0000   1.0000   \n",
       "640315 1.0000 1.0000 2.0000 0.0000 1.0000 0.0000 1.0000  2.0000   1.0000   \n",
       "993469 1.0000 2.0000 2.0000 1.0000 0.0000 0.0000 2.0000     nan      nan   \n",
       "\n",
       "           f280     f281     f282    f283    f284     f285     f286     f287  \\\n",
       "18024    2.0000   1.0000   1.0000  2.0000  2.0000   2.0000   2.0000   1.0000   \n",
       "925633 301.0000 311.0000 312.0000 26.0000 94.0000 134.0000 135.0000 134.0000   \n",
       "145076 302.0000 415.0000 650.0000 10.0000 26.0000  85.0000 105.0000 119.0000   \n",
       "200921   1.0000   1.0000   3.0000  2.0000  2.0000   2.0000   2.0000   2.0000   \n",
       "409334   1.0000   2.0000   1.0000  2.0000  1.0000   2.0000   1.0000   2.0000   \n",
       "...         ...      ...      ...     ...     ...      ...      ...      ...   \n",
       "903324   3.0000   3.0000   3.0000  2.0000  2.0000   2.0000   1.0000   2.0000   \n",
       "535022      nan      nan      nan     nan     nan      nan      nan      nan   \n",
       "793080   2.0000   2.0000   2.0000  2.0000  1.0000   1.0000   1.0000   1.0000   \n",
       "640315   2.0000   1.0000   2.0000  2.0000  1.0000   1.0000   2.0000   1.0000   \n",
       "993469      nan      nan      nan     nan     nan      nan      nan      nan   \n",
       "\n",
       "           f288     f289     f290    f291     f292     f293     f294     f295  \\\n",
       "18024    1.0000   1.0000   2.0000  1.0000   2.0000   2.0000   2.0000   1.0000   \n",
       "925633 301.0000 314.0000 332.0000 87.0000 302.0000 185.0000 186.0000 187.0000   \n",
       "145076 301.0000 305.0000 308.0000 84.0000 277.0000 137.0000 137.0000 138.0000   \n",
       "200921   2.0000   2.0000   3.0000  2.0000   2.0000   1.0000   2.0000   1.0000   \n",
       "409334   1.0000   2.0000   2.0000  2.0000   2.0000   1.0000   1.0000   2.0000   \n",
       "...         ...      ...      ...     ...      ...      ...      ...      ...   \n",
       "903324   5.0000   6.0000   7.0000  2.0000   4.0000   2.0000   2.0000   1.0000   \n",
       "535022      nan      nan      nan     nan      nan      nan      nan      nan   \n",
       "793080   1.0000   2.0000   2.0000  1.0000   1.0000   2.0000   2.0000   2.0000   \n",
       "640315   1.0000   2.0000   2.0000  2.0000   2.0000   2.0000   1.0000   2.0000   \n",
       "993469      nan      nan      nan     nan      nan      nan      nan      nan   \n",
       "\n",
       "          f296     f297  \n",
       "18024   2.0000   1.0000  \n",
       "925633 69.0000 186.0000  \n",
       "145076 51.0000 126.0000  \n",
       "200921  2.0000   1.0000  \n",
       "409334  2.0000   1.0000  \n",
       "...        ...      ...  \n",
       "903324  1.0000   1.0000  \n",
       "535022     nan      nan  \n",
       "793080  1.0000   1.0000  \n",
       "640315  1.0000   2.0000  \n",
       "993469     nan      nan  \n",
       "\n",
       "[990006 rows x 300 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import math\n",
    "\n",
    "from IPython import display\n",
    "from matplotlib import cm\n",
    "from matplotlib import gridspec\n",
    "from matplotlib import pyplot as plt\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "from sklearn import metrics\n",
    "import tensorflow as tf\n",
    "from tensorflow.python.data import Dataset\n",
    "\n",
    "tf.logging.set_verbosity(tf.logging.ERROR)\n",
    "pd.options.display.max_rows = 10\n",
    "pd.set_option('display.max_columns', 350)\n",
    "pd.options.display.float_format = '{:.4f}'.format\n",
    "\n",
    "anti_fraud_dataframe = pd.read_csv(\"atec_anti_fraud_train.csv\")\n",
    "anti_fraud_dataframe = anti_fraud_dataframe[anti_fraud_dataframe.label != -1]\n",
    "anti_fraud_dataframe = anti_fraud_dataframe.reindex(\n",
    "    np.random.permutation(anti_fraud_dataframe.index))\n",
    "anti_fraud_dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>f28</th>\n",
       "      <th>f29</th>\n",
       "      <th>f30</th>\n",
       "      <th>f31</th>\n",
       "      <th>f52</th>\n",
       "      <th>f53</th>\n",
       "      <th>f111</th>\n",
       "      <th>f112</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>18024</th>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>925633</th>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>230.0000</td>\n",
       "      <td>231.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145076</th>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>190.0000</td>\n",
       "      <td>190.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200921</th>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>409334</th>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>2.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>903324</th>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>535022</th>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>793080</th>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>640315</th>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993469</th>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>990006 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           f28     f29     f30     f31     f52     f53     f111     f112\n",
       "18024   0.0000  0.0000  1.0000  0.0000  1.0000  1.0000   1.0000   2.0000\n",
       "925633  0.0000  0.0000  1.0000  1.0000  0.0000  1.0000 230.0000 231.0000\n",
       "145076  0.0000  1.0000  0.0000  0.0000  1.0000  1.0000 190.0000 190.0000\n",
       "200921  1.0000  1.0000  0.0000  1.0000  1.0000  1.0000   2.0000   2.0000\n",
       "409334  1.0000  0.0000  0.0000  1.0000  0.0000  0.0000   2.0000   2.0000\n",
       "...        ...     ...     ...     ...     ...     ...      ...      ...\n",
       "903324  0.0000  0.0000  1.0000  0.0000  0.0000  1.0000   2.0000   1.0000\n",
       "535022 -1.0000 -1.0000 -1.0000 -1.0000 -1.0000 -1.0000  -1.0000  -1.0000\n",
       "793080  1.0000  0.0000  0.0000  0.0000  1.0000  0.0000   1.0000   1.0000\n",
       "640315  0.0000  0.0000  1.0000  1.0000  1.0000  1.0000   2.0000   1.0000\n",
       "993469 -1.0000 -1.0000 -1.0000 -1.0000 -1.0000 -1.0000  -1.0000  -1.0000\n",
       "\n",
       "[990006 rows x 8 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>label</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>18024</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>925633</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145076</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200921</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>409334</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>903324</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>535022</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>793080</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>640315</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993469</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>990006 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        label\n",
       "18024       0\n",
       "925633      0\n",
       "145076      0\n",
       "200921      0\n",
       "409334      0\n",
       "...       ...\n",
       "903324      0\n",
       "535022      0\n",
       "793080      0\n",
       "640315      0\n",
       "993469      0\n",
       "\n",
       "[990006 rows x 1 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "def preprocess_features(anti_fraud_dataframe):\n",
    "    selected_feature = anti_fraud_dataframe[\n",
    "        [\"f28\", \n",
    "         \"f29\", \n",
    "         \"f30\", \n",
    "         \"f31\", \n",
    "         \"f52\", \n",
    "         \"f53\", \n",
    "         \"f111\", \n",
    "         \"f112\"\n",
    "#          \"f113\", \n",
    "#          \"f114\", \n",
    "#          \"f115\", \n",
    "#          \"f116\", \n",
    "#          \"f185\", \n",
    "#          \"f259\", \n",
    "#          \"f260\", \n",
    "#          \"f261\", \n",
    "#          \"f270\", \n",
    "#          \"f271\"\n",
    "        ]]\n",
    "    processed_features = selected_feature.copy()\n",
    "    processed_features = processed_features.fillna(-1)\n",
    "    return processed_features\n",
    "\n",
    "def preprocess_targets(anti_fraud_dataframe):\n",
    "    output_targets = pd.DataFrame()\n",
    "    output_targets[\"label\"] = anti_fraud_dataframe[\"label\"]\n",
    "    return output_targets\n",
    "\n",
    "display.display(preprocess_features(anti_fraud_dataframe))\n",
    "display.display(preprocess_targets(anti_fraud_dataframe))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "def construct_feature_columns(input_features):\n",
    "    return set([tf.feature_column.numeric_column(my_feature)\n",
    "               for my_feature in input_features])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "def my_input_fn(features, targets, batch_size=1, shuffle=True, num_epochs=None):\n",
    "    features = {key:np.array(value) for key,value in dict(features).items()}\n",
    "    \n",
    "    ds = Dataset.from_tensor_slices((features,targets))\n",
    "    ds = ds.batch(batch_size).repeat(num_epochs)\n",
    "    \n",
    "    if shuffle:\n",
    "        ds = ds.shuffle(10000)\n",
    "    \n",
    "    features, labels = ds.make_one_shot_iterator().get_next()\n",
    "    return features, labels"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "def train_nn_regression_model(\n",
    "    my_optimizer,\n",
    "    steps,\n",
    "    batch_size,\n",
    "    hidden_units,\n",
    "    training_examples,\n",
    "    training_targets,\n",
    "    validation_examples,\n",
    "    validation_targets):\n",
    "    \n",
    "    periods = 10\n",
    "    steps_per_period = steps / periods\n",
    "    \n",
    "    my_optimizer = tf.contrib.estimator.clip_gradients_by_norm(my_optimizer, 5.0)\n",
    "    dnn_regressor = tf.estimator.DNNRegressor(\n",
    "        feature_columns=construct_feature_columns(training_examples),\n",
    "        hidden_units=hidden_units,\n",
    "        optimizer=my_optimizer\n",
    "    )\n",
    "    \n",
    "    training_input_fn = lambda: my_input_fn(training_examples, \n",
    "                                            training_targets[\"label\"], \n",
    "                                            batch_size=batch_size)\n",
    "    predict_training_input_fn = lambda: my_input_fn(training_examples, \n",
    "                                                    training_targets[\"label\"], \n",
    "                                                    num_epochs=1, \n",
    "                                                    shuffle=False)\n",
    "    predict_validation_input_fn = lambda: my_input_fn(validation_examples, \n",
    "                                                      validation_targets[\"label\"], \n",
    "                                                      num_epochs=1, \n",
    "                                                      shuffle=False)\n",
    "    \n",
    "    print(\"Training model...\")\n",
    "    print(\"RMSE (on training data):\")\n",
    "    training_rmse = []\n",
    "    validation_rmse = []\n",
    "    for period in range (0, periods):\n",
    "        dnn_regressor.train(\n",
    "            input_fn=training_input_fn,\n",
    "            steps=steps_per_period\n",
    "        )\n",
    "        training_predictions = dnn_regressor.predict(input_fn=predict_training_input_fn)\n",
    "        training_predictions = np.array([item['predictions'][0] for item in training_predictions])\n",
    "\n",
    "        validation_predictions = dnn_regressor.predict(input_fn=predict_validation_input_fn)\n",
    "        validation_predictions = np.array([item['predictions'][0] for item in validation_predictions])\n",
    "\n",
    "        training_root_mean_squared_error = math.sqrt(\n",
    "            metrics.mean_squared_error(training_predictions, training_targets))\n",
    "        validation_root_mean_squared_error = math.sqrt(\n",
    "            metrics.mean_squared_error(validation_predictions, validation_targets))\n",
    "        print(\"  period %02d : %0.2f\" % (period, training_root_mean_squared_error))\n",
    "        training_rmse.append(training_root_mean_squared_error)\n",
    "        validation_rmse.append(validation_root_mean_squared_error)\n",
    "    print(\"Model training finished.\")\n",
    "    \n",
    "    plt.ylabel(\"RMSE\")\n",
    "    plt.xlabel(\"Periods\")\n",
    "    plt.title(\"Root Mean Squared Error vs. Periods\")\n",
    "    plt.tight_layout()\n",
    "    plt.plot(training_rmse, label=\"training\")\n",
    "    plt.plot(validation_rmse, label=\"validation\")\n",
    "    plt.legend()\n",
    "\n",
    "    print(\"Final RMSE (on training data):   %0.2f\" % training_root_mean_squared_error)\n",
    "    print(\"Final RMSE (on validation data): %0.2f\" % validation_root_mean_squared_error)\n",
    "\n",
    "    return dnn_regressor, training_rmse, validation_rmse"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "def linear_scale(series):\n",
    "    min_val = series.min()\n",
    "    max_val = series.max()\n",
    "    scale = (max_val - min_val) / 2.0\n",
    "    return series.apply(lambda x:((x - min_val) / scale) - 1.0)\n",
    "\n",
    "def log_normalize(series):\n",
    "    return series.apply(lambda x:math.log(x+1.0))\n",
    "\n",
    "def clip(series, clip_to_min, clip_to_max):\n",
    "    return series.apply(lambda x:(\n",
    "        min(max(x, clip_to_min), clip_to_max)))\n",
    "\n",
    "def z_score_normalize(series):\n",
    "    mean = series.mean()\n",
    "    std_dv = series.std()\n",
    "    return series.apply(lambda x:(x - mean) / std_dv)\n",
    "\n",
    "def binary_threshold(series, threshold):\n",
    "    return series.apply(lambda x:(1 if x > threshold else 0))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Training examples summary:\n"
     ]
    },
    {
     "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>f28</th>\n",
       "      <th>f29</th>\n",
       "      <th>f30</th>\n",
       "      <th>f31</th>\n",
       "      <th>f52</th>\n",
       "      <th>f53</th>\n",
       "      <th>f111</th>\n",
       "      <th>f112</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>696312.0000</td>\n",
       "      <td>696312.0000</td>\n",
       "      <td>696312.0000</td>\n",
       "      <td>696312.0000</td>\n",
       "      <td>696312.0000</td>\n",
       "      <td>696312.0000</td>\n",
       "      <td>696312.0000</td>\n",
       "      <td>696312.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>0.1962</td>\n",
       "      <td>0.1976</td>\n",
       "      <td>0.2057</td>\n",
       "      <td>0.2067</td>\n",
       "      <td>0.2593</td>\n",
       "      <td>0.2741</td>\n",
       "      <td>-0.4325</td>\n",
       "      <td>-0.4325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.7723</td>\n",
       "      <td>0.7737</td>\n",
       "      <td>0.8470</td>\n",
       "      <td>0.8541</td>\n",
       "      <td>0.9385</td>\n",
       "      <td>0.9813</td>\n",
       "      <td>0.7594</td>\n",
       "      <td>0.7594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>-0.9763</td>\n",
       "      <td>-0.9763</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.5257</td>\n",
       "      <td>0.5257</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>13.0000</td>\n",
       "      <td>13.0000</td>\n",
       "      <td>25.0000</td>\n",
       "      <td>29.0000</td>\n",
       "      <td>31.0000</td>\n",
       "      <td>56.0000</td>\n",
       "      <td>0.9921</td>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              f28         f29         f30         f31         f52         f53  \\\n",
       "count 696312.0000 696312.0000 696312.0000 696312.0000 696312.0000 696312.0000   \n",
       "mean       0.1962      0.1976      0.2057      0.2067      0.2593      0.2741   \n",
       "std        0.7723      0.7737      0.8470      0.8541      0.9385      0.9813   \n",
       "min       -1.0000     -1.0000     -1.0000     -1.0000     -1.0000     -1.0000   \n",
       "25%        0.0000      0.0000      0.0000      0.0000      0.0000      0.0000   \n",
       "50%        0.0000      0.0000      0.0000      0.0000      0.0000      0.0000   \n",
       "75%        1.0000      1.0000      1.0000      1.0000      1.0000      1.0000   \n",
       "max       13.0000     13.0000     25.0000     29.0000     31.0000     56.0000   \n",
       "\n",
       "             f111        f112  \n",
       "count 696312.0000 696312.0000  \n",
       "mean      -0.4325     -0.4325  \n",
       "std        0.7594      0.7594  \n",
       "min       -1.0000     -1.0000  \n",
       "25%       -1.0000     -1.0000  \n",
       "50%       -0.9763     -0.9763  \n",
       "75%        0.5257      0.5257  \n",
       "max        0.9921      1.0000  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Validation examples summary:\n"
     ]
    },
    {
     "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>f28</th>\n",
       "      <th>f29</th>\n",
       "      <th>f30</th>\n",
       "      <th>f31</th>\n",
       "      <th>f52</th>\n",
       "      <th>f53</th>\n",
       "      <th>f111</th>\n",
       "      <th>f112</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>298419.0000</td>\n",
       "      <td>298419.0000</td>\n",
       "      <td>298419.0000</td>\n",
       "      <td>298419.0000</td>\n",
       "      <td>298419.0000</td>\n",
       "      <td>298419.0000</td>\n",
       "      <td>298419.0000</td>\n",
       "      <td>298419.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>0.1940</td>\n",
       "      <td>0.1963</td>\n",
       "      <td>0.2043</td>\n",
       "      <td>0.2040</td>\n",
       "      <td>0.2559</td>\n",
       "      <td>0.2684</td>\n",
       "      <td>-0.4345</td>\n",
       "      <td>-0.4345</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.7737</td>\n",
       "      <td>0.7752</td>\n",
       "      <td>0.8408</td>\n",
       "      <td>0.8460</td>\n",
       "      <td>0.9259</td>\n",
       "      <td>0.9550</td>\n",
       "      <td>0.7583</td>\n",
       "      <td>0.7583</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "      <td>-1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>-0.9763</td>\n",
       "      <td>-0.9763</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.5257</td>\n",
       "      <td>0.5257</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>12.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>25.0000</td>\n",
       "      <td>28.0000</td>\n",
       "      <td>31.0000</td>\n",
       "      <td>56.0000</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>0.9921</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              f28         f29         f30         f31         f52         f53  \\\n",
       "count 298419.0000 298419.0000 298419.0000 298419.0000 298419.0000 298419.0000   \n",
       "mean       0.1940      0.1963      0.2043      0.2040      0.2559      0.2684   \n",
       "std        0.7737      0.7752      0.8408      0.8460      0.9259      0.9550   \n",
       "min       -1.0000     -1.0000     -1.0000     -1.0000     -1.0000     -1.0000   \n",
       "25%        0.0000      0.0000      0.0000      0.0000      0.0000      0.0000   \n",
       "50%        0.0000      0.0000      0.0000      0.0000      0.0000      0.0000   \n",
       "75%        1.0000      1.0000      1.0000      1.0000      1.0000      1.0000   \n",
       "max       12.0000     12.0000     25.0000     28.0000     31.0000     56.0000   \n",
       "\n",
       "             f111        f112  \n",
       "count 298419.0000 298419.0000  \n",
       "mean      -0.4345     -0.4345  \n",
       "std        0.7583      0.7583  \n",
       "min       -1.0000     -1.0000  \n",
       "25%       -1.0000     -1.0000  \n",
       "50%       -0.9763     -0.9763  \n",
       "75%        0.5257      0.5257  \n",
       "max        1.0000      0.9921  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Training targets summary:\n"
     ]
    },
    {
     "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>label</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>696312.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>0.0122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.1097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            label\n",
       "count 696312.0000\n",
       "mean       0.0122\n",
       "std        0.1097\n",
       "min        0.0000\n",
       "25%        0.0000\n",
       "50%        0.0000\n",
       "75%        0.0000\n",
       "max        1.0000"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Validation targets summary:\n"
     ]
    },
    {
     "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>label</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>298419.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>0.0124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.1106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            label\n",
       "count 298419.0000\n",
       "mean       0.0124\n",
       "std        0.1106\n",
       "min        0.0000\n",
       "25%        0.0000\n",
       "50%        0.0000\n",
       "75%        0.0000\n",
       "max        1.0000"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "def normalize(examples_dataframe):\n",
    "    processed_features = examples_dataframe.copy()\n",
    "    \n",
    "    processed_features[\"f111\"] = linear_scale(examples_dataframe[\"f111\"])\n",
    "    processed_features[\"f112\"] = linear_scale(examples_dataframe[\"f112\"])\n",
    "    \n",
    "    return processed_features\n",
    "\n",
    "normalized_dataframe = normalize(preprocess_features(anti_fraud_dataframe))\n",
    "normalized_training_examples = normalized_dataframe.head(696312)\n",
    "normalized_validation_examples = normalized_dataframe.tail(298419)\n",
    "\n",
    "training_targets = preprocess_targets(anti_fraud_dataframe.head(696312))\n",
    "validation_targets = preprocess_targets(anti_fraud_dataframe.tail(298419))\n",
    "\n",
    "print(\"Training examples summary:\")\n",
    "display.display(normalized_training_examples.describe())\n",
    "print(\"Validation examples summary:\")\n",
    "display.display(normalized_validation_examples.describe())\n",
    "\n",
    "print(\"Training targets summary:\")\n",
    "display.display(training_targets.describe())\n",
    "print(\"Validation targets summary:\")\n",
    "display.display(validation_targets.describe())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Training model...\n",
      "RMSE (on training data):\n",
      "  period 00 : 0.12\n",
      "  period 01 : 0.11\n",
      "  period 02 : 0.11\n",
      "  period 03 : 0.11\n"
     ]
    }
   ],
   "source": [
    "dnn_regressor, adagrad_training_losses, adagrad_validation_losses = train_nn_regression_model(\n",
    "    my_optimizer=tf.train.AdagradOptimizer(learning_rate=0.5),\n",
    "    steps=500,\n",
    "    batch_size=100,\n",
    "    hidden_units=[10, 10],\n",
    "    training_examples=normalized_training_examples,\n",
    "    training_targets=training_targets,\n",
    "    validation_examples=normalized_validation_examples,\n",
    "    validation_targets=validation_targets)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "dnn_regressor1, adam_training_losses, adam_validation_losses = train_nn_regression_model(\n",
    "    my_optimizer=tf.train.AdamOptimizer(learning_rate=0.009),\n",
    "    steps=500,\n",
    "    batch_size=100,\n",
    "    hidden_units=[10, 10],\n",
    "    training_examples=normalized_training_examples,\n",
    "    training_targets=training_targets,\n",
    "    validation_examples=normalized_validation_examples,\n",
    "    validation_targets=validation_targets)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "dnn_regressor2, gradientdescent_training_losses, gradientdescent_validation_losses = train_nn_regression_model(\n",
    "    my_optimizer=tf.train.GradientDescentOptimizer(learning_rate=0.005),\n",
    "    steps=5000,\n",
    "    batch_size=50,\n",
    "    hidden_units=[10, 10],\n",
    "    training_examples=normalized_training_examples,\n",
    "    training_targets=training_targets,\n",
    "    validation_examples=normalized_validation_examples,\n",
    "    validation_targets=validation_targets)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "plt.ylabel(\"RMSE\")\n",
    "plt.xlabel(\"Periods\")\n",
    "plt.title(\"Root Mean Squared Error vs. Periods\")\n",
    "plt.plot(adagrad_validation_losses, label='Adagrad validation')\n",
    "plt.plot(adam_validation_losses, label='Adam validation')\n",
    "plt.plot(gradientdescent_validation_losses, label='GradientDescent validation')\n",
    "_ = plt.legend()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "anti_fraud_dataframe_test_data = pd.read_csv(\"atec_anti_fraud_test_a.csv\")\n",
    "display.display(anti_fraud_dataframe_test_data.describe())\n",
    "\n",
    "anti_fraud_dataframe_test_data['label'] = 0.0\n",
    "test_examples = normalize(preprocess_features(anti_fraud_dataframe_test_data))\n",
    "print(\"Test examples summary:\")\n",
    "display.display(test_examples.describe())\n",
    "\n",
    "test_targets = pd.DataFrame()\n",
    "test_targets[\"label\"] = (anti_fraud_dataframe_test_data[\"label\"])\n",
    "display.display(test_targets.describe())\n",
    "\n",
    "predict_testing_input_fn = lambda: my_input_fn(test_examples, \n",
    "                                               test_targets[\"label\"], \n",
    "                                               num_epochs=1, \n",
    "                                               shuffle=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "test_predictions = dnn_regressor.predict(input_fn=predict_testing_input_fn)\n",
    "test_predictions = np.array([item['predictions'][0] for item in test_predictions])\n",
    "display.display(test_predictions, len(test_predictions))\n",
    "\n",
    "predictions = pd.DataFrame()\n",
    "predictions['score'] = pd.Series(test_predictions)\n",
    "predictions['score']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = pd.concat([anti_fraud_dataframe_test_data[\"id\"], predictions['score']], axis=1)\n",
    "result.describe()\n",
    "\n",
    "result.loc[result[\"score\"]<0, \"score\"] = 0\n",
    "result.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "result[[\"id\", \"score\"]].to_csv('submission.csv', index=False)"
   ]
  }
 ],
 "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.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}