DBSCAN.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## DBSCAN (Density-Based Spatial Clustering of Applications with Noise)\n",
    "\n",
    "\n",
    "Find core samples of high density and expand clusters from them.\n",
    "\n",
    "The minimum number of samples in a neighborhood for a point to be considered as a core point was set at 10 and the maximum distance between two samples within the same neighborhood was set at 0.1.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Filename</th>\n",
       "      <th>EIN</th>\n",
       "      <th>Program_Exp</th>\n",
       "      <th>Liabilities_To_Asset</th>\n",
       "      <th>Working_Capital</th>\n",
       "      <th>Surplus_Margin</th>\n",
       "      <th>Total_Expenses</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>201523229349300327.xml</td>\n",
       "      <td>510311790.0</td>\n",
       "      <td>0.989619</td>\n",
       "      <td>0.091802</td>\n",
       "      <td>1.574677</td>\n",
       "      <td>-0.078663</td>\n",
       "      <td>4.643180e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>201543089349301829.xml</td>\n",
       "      <td>261460932.0</td>\n",
       "      <td>0.965378</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>3.910347</td>\n",
       "      <td>-0.042674</td>\n",
       "      <td>2.743900e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>201533179349306298.xml</td>\n",
       "      <td>270609504.0</td>\n",
       "      <td>0.942276</td>\n",
       "      <td>0.049206</td>\n",
       "      <td>0.655152</td>\n",
       "      <td>0.088597</td>\n",
       "      <td>3.848280e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>201533209349304768.xml</td>\n",
       "      <td>521548962.0</td>\n",
       "      <td>0.384526</td>\n",
       "      <td>0.000814</td>\n",
       "      <td>30.392756</td>\n",
       "      <td>0.633126</td>\n",
       "      <td>5.091200e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>201533179349307343.xml</td>\n",
       "      <td>731653383.0</td>\n",
       "      <td>0.620560</td>\n",
       "      <td>0.029487</td>\n",
       "      <td>1.083739</td>\n",
       "      <td>0.105901</td>\n",
       "      <td>2.812300e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>201533189349300608.xml</td>\n",
       "      <td>237324566.0</td>\n",
       "      <td>0.758902</td>\n",
       "      <td>0.736982</td>\n",
       "      <td>-0.176215</td>\n",
       "      <td>-0.003914</td>\n",
       "      <td>6.081260e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>201523069349301367.xml</td>\n",
       "      <td>43259150.0</td>\n",
       "      <td>0.736312</td>\n",
       "      <td>0.181998</td>\n",
       "      <td>0.378592</td>\n",
       "      <td>0.057534</td>\n",
       "      <td>2.129680e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>201533069349300963.xml</td>\n",
       "      <td>621273871.0</td>\n",
       "      <td>0.644822</td>\n",
       "      <td>0.234247</td>\n",
       "      <td>14.413163</td>\n",
       "      <td>0.496122</td>\n",
       "      <td>1.426413e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>201523099349300542.xml</td>\n",
       "      <td>541897455.0</td>\n",
       "      <td>0.845659</td>\n",
       "      <td>0.138531</td>\n",
       "      <td>0.414986</td>\n",
       "      <td>-0.016769</td>\n",
       "      <td>4.615120e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>201533099349301033.xml</td>\n",
       "      <td>251869168.0</td>\n",
       "      <td>0.762357</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>8.673984</td>\n",
       "      <td>0.122244</td>\n",
       "      <td>1.020440e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>201523169349304367.xml</td>\n",
       "      <td>376046335.0</td>\n",
       "      <td>0.745386</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>16.463976</td>\n",
       "      <td>0.252579</td>\n",
       "      <td>3.717000e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>201533099349301803.xml</td>\n",
       "      <td>50454409.0</td>\n",
       "      <td>0.915261</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.158768</td>\n",
       "      <td>0.062649</td>\n",
       "      <td>5.573470e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>201523069349300142.xml</td>\n",
       "      <td>272364809.0</td>\n",
       "      <td>0.920307</td>\n",
       "      <td>0.003606</td>\n",
       "      <td>0.240597</td>\n",
       "      <td>-0.029663</td>\n",
       "      <td>3.020610e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>201543039349301204.xml</td>\n",
       "      <td>463812139.0</td>\n",
       "      <td>0.664088</td>\n",
       "      <td>0.648413</td>\n",
       "      <td>0.045823</td>\n",
       "      <td>0.088812</td>\n",
       "      <td>1.399740e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>201523089349301462.xml</td>\n",
       "      <td>561797737.0</td>\n",
       "      <td>0.704623</td>\n",
       "      <td>0.432671</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.050384</td>\n",
       "      <td>2.147730e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>201533069349300788.xml</td>\n",
       "      <td>590638867.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.360157</td>\n",
       "      <td>-0.055883</td>\n",
       "      <td>7.625220e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>201533079349300238.xml</td>\n",
       "      <td>273314429.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.107584</td>\n",
       "      <td>2.617100e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>201523209349314257.xml</td>\n",
       "      <td>710801566.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-8.212337</td>\n",
       "      <td>1.145333e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>201523209349311332.xml</td>\n",
       "      <td>752204594.0</td>\n",
       "      <td>0.896895</td>\n",
       "      <td>0.069715</td>\n",
       "      <td>0.535678</td>\n",
       "      <td>-0.064100</td>\n",
       "      <td>3.889691e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>201533179349302173.xml</td>\n",
       "      <td>251374594.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.313630</td>\n",
       "      <td>0.337537</td>\n",
       "      <td>0.014809</td>\n",
       "      <td>4.235120e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>201533179349307048.xml</td>\n",
       "      <td>450448773.0</td>\n",
       "      <td>0.991205</td>\n",
       "      <td>0.051348</td>\n",
       "      <td>0.414930</td>\n",
       "      <td>0.161552</td>\n",
       "      <td>1.858940e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>201533209349302633.xml</td>\n",
       "      <td>363789851.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.232011</td>\n",
       "      <td>0.521133</td>\n",
       "      <td>-0.128997</td>\n",
       "      <td>7.329143e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>201533099349301113.xml</td>\n",
       "      <td>411712804.0</td>\n",
       "      <td>0.477697</td>\n",
       "      <td>0.009887</td>\n",
       "      <td>0.751388</td>\n",
       "      <td>-0.014507</td>\n",
       "      <td>8.147200e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>201523039349300127.xml</td>\n",
       "      <td>381557861.0</td>\n",
       "      <td>0.832159</td>\n",
       "      <td>0.063834</td>\n",
       "      <td>2.988120</td>\n",
       "      <td>0.170911</td>\n",
       "      <td>1.369609e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>201523079349301652.xml</td>\n",
       "      <td>273741627.0</td>\n",
       "      <td>0.945120</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.863663</td>\n",
       "      <td>0.094985</td>\n",
       "      <td>1.234798e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>201533039349300813.xml</td>\n",
       "      <td>411495321.0</td>\n",
       "      <td>0.668161</td>\n",
       "      <td>0.040796</td>\n",
       "      <td>144.508488</td>\n",
       "      <td>-0.139777</td>\n",
       "      <td>1.108143e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>201533139349300208.xml</td>\n",
       "      <td>60666277.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.644904</td>\n",
       "      <td>0.654848</td>\n",
       "      <td>-0.296143</td>\n",
       "      <td>1.964943e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>201533069349301413.xml</td>\n",
       "      <td>42616064.0</td>\n",
       "      <td>0.951218</td>\n",
       "      <td>0.338683</td>\n",
       "      <td>0.178517</td>\n",
       "      <td>0.041123</td>\n",
       "      <td>3.325420e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>201533079349300003.xml</td>\n",
       "      <td>581651220.0</td>\n",
       "      <td>0.910347</td>\n",
       "      <td>0.026832</td>\n",
       "      <td>0.945357</td>\n",
       "      <td>-0.020293</td>\n",
       "      <td>3.247970e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>201523069349300957.xml</td>\n",
       "      <td>341496171.0</td>\n",
       "      <td>0.850617</td>\n",
       "      <td>0.068838</td>\n",
       "      <td>1.125712</td>\n",
       "      <td>0.212899</td>\n",
       "      <td>6.727750e+05</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38884</th>\n",
       "      <td>201533099349301698.xml</td>\n",
       "      <td>912130056.0</td>\n",
       "      <td>0.760828</td>\n",
       "      <td>0.610684</td>\n",
       "      <td>0.104169</td>\n",
       "      <td>-2.163589</td>\n",
       "      <td>7.340370e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38885</th>\n",
       "      <td>201543119349300204.xml</td>\n",
       "      <td>237198698.0</td>\n",
       "      <td>0.819953</td>\n",
       "      <td>0.549109</td>\n",
       "      <td>0.248479</td>\n",
       "      <td>0.060347</td>\n",
       "      <td>3.518240e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38886</th>\n",
       "      <td>201543139349302814.xml</td>\n",
       "      <td>462250934.0</td>\n",
       "      <td>0.131636</td>\n",
       "      <td>0.960863</td>\n",
       "      <td>0.001425</td>\n",
       "      <td>0.005347</td>\n",
       "      <td>2.279017e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38887</th>\n",
       "      <td>201533219349301213.xml</td>\n",
       "      <td>231416559.0</td>\n",
       "      <td>0.598760</td>\n",
       "      <td>0.802416</td>\n",
       "      <td>0.248929</td>\n",
       "      <td>-0.207427</td>\n",
       "      <td>8.819110e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38888</th>\n",
       "      <td>201543179349306629.xml</td>\n",
       "      <td>223128187.0</td>\n",
       "      <td>0.621104</td>\n",
       "      <td>0.040543</td>\n",
       "      <td>1.574808</td>\n",
       "      <td>-0.133304</td>\n",
       "      <td>6.866690e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38889</th>\n",
       "      <td>201533209349316263.xml</td>\n",
       "      <td>731585237.0</td>\n",
       "      <td>0.849584</td>\n",
       "      <td>0.133037</td>\n",
       "      <td>0.508528</td>\n",
       "      <td>-0.054146</td>\n",
       "      <td>2.441360e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38890</th>\n",
       "      <td>201543079349301044.xml</td>\n",
       "      <td>581736427.0</td>\n",
       "      <td>0.887224</td>\n",
       "      <td>1.390273</td>\n",
       "      <td>-1.014415</td>\n",
       "      <td>0.052991</td>\n",
       "      <td>1.413780e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38891</th>\n",
       "      <td>201533139349300123.xml</td>\n",
       "      <td>470841633.0</td>\n",
       "      <td>0.730878</td>\n",
       "      <td>0.237917</td>\n",
       "      <td>6.796036</td>\n",
       "      <td>0.615454</td>\n",
       "      <td>8.076930e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38892</th>\n",
       "      <td>201543179349305429.xml</td>\n",
       "      <td>943345498.0</td>\n",
       "      <td>0.570344</td>\n",
       "      <td>0.031022</td>\n",
       "      <td>3.196737</td>\n",
       "      <td>0.146015</td>\n",
       "      <td>5.820010e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38893</th>\n",
       "      <td>201543179349308719.xml</td>\n",
       "      <td>264795329.0</td>\n",
       "      <td>0.984882</td>\n",
       "      <td>1.067790</td>\n",
       "      <td>-0.013730</td>\n",
       "      <td>-0.013601</td>\n",
       "      <td>6.089029e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38894</th>\n",
       "      <td>201533179349302373.xml</td>\n",
       "      <td>262709818.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>3.369300e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38895</th>\n",
       "      <td>201620149349300127.xml</td>\n",
       "      <td>431129770.0</td>\n",
       "      <td>0.868905</td>\n",
       "      <td>0.203344</td>\n",
       "      <td>0.818979</td>\n",
       "      <td>0.041341</td>\n",
       "      <td>1.113451e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38896</th>\n",
       "      <td>201630129349300803.xml</td>\n",
       "      <td>592240502.0</td>\n",
       "      <td>0.858238</td>\n",
       "      <td>0.090567</td>\n",
       "      <td>1.552281</td>\n",
       "      <td>0.165716</td>\n",
       "      <td>6.398019e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38897</th>\n",
       "      <td>201620119349300422.xml</td>\n",
       "      <td>61462359.0</td>\n",
       "      <td>0.843057</td>\n",
       "      <td>0.087344</td>\n",
       "      <td>0.250055</td>\n",
       "      <td>-0.086286</td>\n",
       "      <td>6.898120e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38898</th>\n",
       "      <td>201630129349300723.xml</td>\n",
       "      <td>630652760.0</td>\n",
       "      <td>0.992892</td>\n",
       "      <td>0.301988</td>\n",
       "      <td>0.133494</td>\n",
       "      <td>0.000101</td>\n",
       "      <td>3.599537e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38899</th>\n",
       "      <td>201610139349300811.xml</td>\n",
       "      <td>341472960.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.762930e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38900</th>\n",
       "      <td>201600199349300500.xml</td>\n",
       "      <td>800182020.0</td>\n",
       "      <td>0.594838</td>\n",
       "      <td>0.141928</td>\n",
       "      <td>0.037224</td>\n",
       "      <td>-0.104980</td>\n",
       "      <td>1.481881e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38901</th>\n",
       "      <td>201600399349300955.xml</td>\n",
       "      <td>462754433.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.235223</td>\n",
       "      <td>0.095712</td>\n",
       "      <td>4.060960e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38902</th>\n",
       "      <td>201600369349301750.xml</td>\n",
       "      <td>742744885.0</td>\n",
       "      <td>0.975219</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.452366</td>\n",
       "      <td>-0.045373</td>\n",
       "      <td>2.315450e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38903</th>\n",
       "      <td>201610399349300226.xml</td>\n",
       "      <td>471127421.0</td>\n",
       "      <td>0.138038</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.097551</td>\n",
       "      <td>2.163548</td>\n",
       "      <td>1.495530e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38904</th>\n",
       "      <td>201620359349300612.xml</td>\n",
       "      <td>742244155.0</td>\n",
       "      <td>0.901125</td>\n",
       "      <td>0.559978</td>\n",
       "      <td>0.068062</td>\n",
       "      <td>0.008963</td>\n",
       "      <td>2.399374e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38905</th>\n",
       "      <td>201610429349302361.xml</td>\n",
       "      <td>940764760.0</td>\n",
       "      <td>0.992275</td>\n",
       "      <td>0.788509</td>\n",
       "      <td>0.034823</td>\n",
       "      <td>0.014275</td>\n",
       "      <td>5.107870e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38906</th>\n",
       "      <td>201610369349301226.xml</td>\n",
       "      <td>840588263.0</td>\n",
       "      <td>0.988925</td>\n",
       "      <td>0.080860</td>\n",
       "      <td>0.313222</td>\n",
       "      <td>0.166371</td>\n",
       "      <td>2.257280e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38907</th>\n",
       "      <td>201640359349300129.xml</td>\n",
       "      <td>20650275.0</td>\n",
       "      <td>0.681210</td>\n",
       "      <td>0.498341</td>\n",
       "      <td>0.213852</td>\n",
       "      <td>0.038597</td>\n",
       "      <td>3.040090e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38908</th>\n",
       "      <td>201600429349301735.xml</td>\n",
       "      <td>942418861.0</td>\n",
       "      <td>0.987789</td>\n",
       "      <td>0.015595</td>\n",
       "      <td>3.429593</td>\n",
       "      <td>0.526883</td>\n",
       "      <td>2.165501e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38909</th>\n",
       "      <td>201600359349302005.xml</td>\n",
       "      <td>223201871.0</td>\n",
       "      <td>0.907986</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>3.052342</td>\n",
       "      <td>0.281392</td>\n",
       "      <td>2.319760e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38910</th>\n",
       "      <td>201600419349301130.xml</td>\n",
       "      <td>650599763.0</td>\n",
       "      <td>0.955581</td>\n",
       "      <td>4.173882</td>\n",
       "      <td>-0.414036</td>\n",
       "      <td>0.058141</td>\n",
       "      <td>1.489220e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38911</th>\n",
       "      <td>201640359349301614.xml</td>\n",
       "      <td>470461460.0</td>\n",
       "      <td>0.465235</td>\n",
       "      <td>0.014051</td>\n",
       "      <td>1.666884</td>\n",
       "      <td>0.182197</td>\n",
       "      <td>2.236610e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38912</th>\n",
       "      <td>201600429349302135.xml</td>\n",
       "      <td>990208381.0</td>\n",
       "      <td>0.852344</td>\n",
       "      <td>0.047928</td>\n",
       "      <td>0.815871</td>\n",
       "      <td>0.229352</td>\n",
       "      <td>1.879170e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38913</th>\n",
       "      <td>201610229349300741.xml</td>\n",
       "      <td>510216586.0</td>\n",
       "      <td>0.521938</td>\n",
       "      <td>0.746625</td>\n",
       "      <td>0.529489</td>\n",
       "      <td>0.026507</td>\n",
       "      <td>4.834544e+09</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>38657 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Filename          EIN  Program_Exp  Liabilities_To_Asset  \\\n",
       "0      201523229349300327.xml  510311790.0     0.989619              0.091802   \n",
       "1      201543089349301829.xml  261460932.0     0.965378              0.000000   \n",
       "2      201533179349306298.xml  270609504.0     0.942276              0.049206   \n",
       "3      201533209349304768.xml  521548962.0     0.384526              0.000814   \n",
       "4      201533179349307343.xml  731653383.0     0.620560              0.029487   \n",
       "5      201533189349300608.xml  237324566.0     0.758902              0.736982   \n",
       "6      201523069349301367.xml   43259150.0     0.736312              0.181998   \n",
       "7      201533069349300963.xml  621273871.0     0.644822              0.234247   \n",
       "8      201523099349300542.xml  541897455.0     0.845659              0.138531   \n",
       "9      201533099349301033.xml  251869168.0     0.762357              0.000000   \n",
       "10     201523169349304367.xml  376046335.0     0.745386              0.000000   \n",
       "11     201533099349301803.xml   50454409.0     0.915261              0.000000   \n",
       "12     201523069349300142.xml  272364809.0     0.920307              0.003606   \n",
       "13     201543039349301204.xml  463812139.0     0.664088              0.648413   \n",
       "14     201523089349301462.xml  561797737.0     0.704623              0.432671   \n",
       "15     201533069349300788.xml  590638867.0     0.000000              0.000000   \n",
       "16     201533079349300238.xml  273314429.0     1.000000              0.000000   \n",
       "17     201523209349314257.xml  710801566.0     1.000000              0.000000   \n",
       "18     201523209349311332.xml  752204594.0     0.896895              0.069715   \n",
       "19     201533179349302173.xml  251374594.0     0.000000              0.313630   \n",
       "20     201533179349307048.xml  450448773.0     0.991205              0.051348   \n",
       "21     201533209349302633.xml  363789851.0     0.000000              0.232011   \n",
       "22     201533099349301113.xml  411712804.0     0.477697              0.009887   \n",
       "23     201523039349300127.xml  381557861.0     0.832159              0.063834   \n",
       "24     201523079349301652.xml  273741627.0     0.945120              0.000000   \n",
       "25     201533039349300813.xml  411495321.0     0.668161              0.040796   \n",
       "26     201533139349300208.xml   60666277.0     0.000000              0.644904   \n",
       "27     201533069349301413.xml   42616064.0     0.951218              0.338683   \n",
       "28     201533079349300003.xml  581651220.0     0.910347              0.026832   \n",
       "29     201523069349300957.xml  341496171.0     0.850617              0.068838   \n",
       "...                       ...          ...          ...                   ...   \n",
       "38884  201533099349301698.xml  912130056.0     0.760828              0.610684   \n",
       "38885  201543119349300204.xml  237198698.0     0.819953              0.549109   \n",
       "38886  201543139349302814.xml  462250934.0     0.131636              0.960863   \n",
       "38887  201533219349301213.xml  231416559.0     0.598760              0.802416   \n",
       "38888  201543179349306629.xml  223128187.0     0.621104              0.040543   \n",
       "38889  201533209349316263.xml  731585237.0     0.849584              0.133037   \n",
       "38890  201543079349301044.xml  581736427.0     0.887224              1.390273   \n",
       "38891  201533139349300123.xml  470841633.0     0.730878              0.237917   \n",
       "38892  201543179349305429.xml  943345498.0     0.570344              0.031022   \n",
       "38893  201543179349308719.xml  264795329.0     0.984882              1.067790   \n",
       "38894  201533179349302373.xml  262709818.0     1.000000              1.000000   \n",
       "38895  201620149349300127.xml  431129770.0     0.868905              0.203344   \n",
       "38896  201630129349300803.xml  592240502.0     0.858238              0.090567   \n",
       "38897  201620119349300422.xml   61462359.0     0.843057              0.087344   \n",
       "38898  201630129349300723.xml  630652760.0     0.992892              0.301988   \n",
       "38899  201610139349300811.xml  341472960.0     1.000000              1.000000   \n",
       "38900  201600199349300500.xml  800182020.0     0.594838              0.141928   \n",
       "38901  201600399349300955.xml  462754433.0     0.000000              0.000000   \n",
       "38902  201600369349301750.xml  742744885.0     0.975219              0.000000   \n",
       "38903  201610399349300226.xml  471127421.0     0.138038              0.000000   \n",
       "38904  201620359349300612.xml  742244155.0     0.901125              0.559978   \n",
       "38905  201610429349302361.xml  940764760.0     0.992275              0.788509   \n",
       "38906  201610369349301226.xml  840588263.0     0.988925              0.080860   \n",
       "38907  201640359349300129.xml   20650275.0     0.681210              0.498341   \n",
       "38908  201600429349301735.xml  942418861.0     0.987789              0.015595   \n",
       "38909  201600359349302005.xml  223201871.0     0.907986              0.000000   \n",
       "38910  201600419349301130.xml  650599763.0     0.955581              4.173882   \n",
       "38911  201640359349301614.xml  470461460.0     0.465235              0.014051   \n",
       "38912  201600429349302135.xml  990208381.0     0.852344              0.047928   \n",
       "38913  201610229349300741.xml  510216586.0     0.521938              0.746625   \n",
       "\n",
       "       Working_Capital  Surplus_Margin  Total_Expenses  \n",
       "0             1.574677       -0.078663    4.643180e+05  \n",
       "1             3.910347       -0.042674    2.743900e+04  \n",
       "2             0.655152        0.088597    3.848280e+05  \n",
       "3            30.392756        0.633126    5.091200e+04  \n",
       "4             1.083739        0.105901    2.812300e+04  \n",
       "5            -0.176215       -0.003914    6.081260e+05  \n",
       "6             0.378592        0.057534    2.129680e+05  \n",
       "7            14.413163        0.496122    1.426413e+06  \n",
       "8             0.414986       -0.016769    4.615120e+05  \n",
       "9             8.673984        0.122244    1.020440e+05  \n",
       "10           16.463976        0.252579    3.717000e+04  \n",
       "11            1.158768        0.062649    5.573470e+05  \n",
       "12            0.240597       -0.029663    3.020610e+05  \n",
       "13            0.045823        0.088812    1.399740e+05  \n",
       "14            0.000000       -0.050384    2.147730e+05  \n",
       "15            0.360157       -0.055883    7.625220e+05  \n",
       "16            0.000000        0.107584    2.617100e+04  \n",
       "17            0.000000       -8.212337    1.145333e+06  \n",
       "18            0.535678       -0.064100    3.889691e+06  \n",
       "19            0.337537        0.014809    4.235120e+05  \n",
       "20            0.414930        0.161552    1.858940e+05  \n",
       "21            0.521133       -0.128997    7.329143e+06  \n",
       "22            0.751388       -0.014507    8.147200e+05  \n",
       "23            2.988120        0.170911    1.369609e+06  \n",
       "24            0.863663        0.094985    1.234798e+06  \n",
       "25          144.508488       -0.139777    1.108143e+06  \n",
       "26            0.654848       -0.296143    1.964943e+07  \n",
       "27            0.178517        0.041123    3.325420e+07  \n",
       "28            0.945357       -0.020293    3.247970e+05  \n",
       "29            1.125712        0.212899    6.727750e+05  \n",
       "...                ...             ...             ...  \n",
       "38884         0.104169       -2.163589    7.340370e+05  \n",
       "38885         0.248479        0.060347    3.518240e+05  \n",
       "38886         0.001425        0.005347    2.279017e+06  \n",
       "38887         0.248929       -0.207427    8.819110e+05  \n",
       "38888         1.574808       -0.133304    6.866690e+05  \n",
       "38889         0.508528       -0.054146    2.441360e+05  \n",
       "38890        -1.014415        0.052991    1.413780e+05  \n",
       "38891         6.796036        0.615454    8.076930e+05  \n",
       "38892         3.196737        0.146015    5.820010e+05  \n",
       "38893        -0.013730       -0.013601    6.089029e+06  \n",
       "38894         0.000000        0.000000    3.369300e+04  \n",
       "38895         0.818979        0.041341    1.113451e+07  \n",
       "38896         1.552281        0.165716    6.398019e+06  \n",
       "38897         0.250055       -0.086286    6.898120e+05  \n",
       "38898         0.133494        0.000101    3.599537e+06  \n",
       "38899         0.000000        0.000000    2.762930e+05  \n",
       "38900         0.037224       -0.104980    1.481881e+06  \n",
       "38901         0.235223        0.095712    4.060960e+05  \n",
       "38902         0.452366       -0.045373    2.315450e+05  \n",
       "38903         2.097551        2.163548    1.495530e+05  \n",
       "38904         0.068062        0.008963    2.399374e+07  \n",
       "38905         0.034823        0.014275    5.107870e+05  \n",
       "38906         0.313222        0.166371    2.257280e+05  \n",
       "38907         0.213852        0.038597    3.040090e+05  \n",
       "38908         3.429593        0.526883    2.165501e+06  \n",
       "38909         3.052342        0.281392    2.319760e+05  \n",
       "38910        -0.414036        0.058141    1.489220e+05  \n",
       "38911         1.666884        0.182197    2.236610e+05  \n",
       "38912         0.815871        0.229352    1.879170e+05  \n",
       "38913         0.529489        0.026507    4.834544e+09  \n",
       "\n",
       "[38657 rows x 7 columns]"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "\n",
    "df1=pd.read_csv('team_out_1.csv')\n",
    "df2=pd.read_csv('team_out_a2.csv')\n",
    "\n",
    "df=df1.append(df2)\n",
    "df.dropna(inplace=True)\n",
    "df.reset_index(inplace=True,drop=True)\n",
    "df=df[df.Total_Expenses>0]\n",
    "df=df[df.Program_Exp<=1]\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": false
   },
   "source": [
    "small_df=df[df.Total_Expenses<1000000]\n",
    "\n",
    "med_df=df[df.Total_Expenses>1000000]\n",
    "med_df=med_df[df.Total_Expenses<10000000]\n",
    "\n",
    "large_df=df[df.Total_Expenses<50000000]\n",
    "large_df=large_df[df.Total_Expenses>10000000]\n",
    "\n",
    "national_df=df[df.Total_Expenses>50000000]\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#Getting a list of positive businesses\n",
    "\n",
    "temp=df[df.Program_Exp>.9] \n",
    "temp=temp[temp.Liabilities_To_Asset<.2]\n",
    "lst_temp=list(temp['EIN'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Program_Exp</th>\n",
       "      <th>Liabilities_To_Asset</th>\n",
       "      <th>Working_Capital</th>\n",
       "      <th>Surplus_Margin</th>\n",
       "      <th>Total_Expenses</th>\n",
       "      <th>Filename</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EIN</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>510311790.0</th>\n",
       "      <td>0.989619</td>\n",
       "      <td>0.013484</td>\n",
       "      <td>0.463650</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000068</td>\n",
       "      <td>201523229349300327.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>261460932.0</th>\n",
       "      <td>0.965378</td>\n",
       "      <td>0.013479</td>\n",
       "      <td>0.463657</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000004</td>\n",
       "      <td>201543089349301829.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270609504.0</th>\n",
       "      <td>0.942276</td>\n",
       "      <td>0.013482</td>\n",
       "      <td>0.463647</td>\n",
       "      <td>0.957232</td>\n",
       "      <td>0.000056</td>\n",
       "      <td>201533179349306298.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>521548962.0</th>\n",
       "      <td>0.384526</td>\n",
       "      <td>0.013479</td>\n",
       "      <td>0.463740</td>\n",
       "      <td>0.957234</td>\n",
       "      <td>0.000007</td>\n",
       "      <td>201533209349304768.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>731653383.0</th>\n",
       "      <td>0.620560</td>\n",
       "      <td>0.013480</td>\n",
       "      <td>0.463649</td>\n",
       "      <td>0.957232</td>\n",
       "      <td>0.000004</td>\n",
       "      <td>201533179349307343.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237324566.0</th>\n",
       "      <td>0.758902</td>\n",
       "      <td>0.013522</td>\n",
       "      <td>0.463645</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000089</td>\n",
       "      <td>201533189349300608.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43259150.0</th>\n",
       "      <td>0.736312</td>\n",
       "      <td>0.013489</td>\n",
       "      <td>0.463646</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>201523069349301367.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>621273871.0</th>\n",
       "      <td>0.644822</td>\n",
       "      <td>0.013492</td>\n",
       "      <td>0.463690</td>\n",
       "      <td>0.957233</td>\n",
       "      <td>0.000209</td>\n",
       "      <td>201533069349300963.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541897455.0</th>\n",
       "      <td>0.845659</td>\n",
       "      <td>0.013487</td>\n",
       "      <td>0.463646</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000068</td>\n",
       "      <td>201523099349300542.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251869168.0</th>\n",
       "      <td>0.762357</td>\n",
       "      <td>0.013479</td>\n",
       "      <td>0.463672</td>\n",
       "      <td>0.957232</td>\n",
       "      <td>0.000015</td>\n",
       "      <td>201533099349301033.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>376046335.0</th>\n",
       "      <td>0.745386</td>\n",
       "      <td>0.013479</td>\n",
       "      <td>0.463696</td>\n",
       "      <td>0.957232</td>\n",
       "      <td>0.000005</td>\n",
       "      <td>201523169349304367.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50454409.0</th>\n",
       "      <td>0.915261</td>\n",
       "      <td>0.013479</td>\n",
       "      <td>0.463649</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000082</td>\n",
       "      <td>201533099349301803.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272364809.0</th>\n",
       "      <td>0.920307</td>\n",
       "      <td>0.013479</td>\n",
       "      <td>0.463646</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>201523069349300142.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>463812139.0</th>\n",
       "      <td>0.664088</td>\n",
       "      <td>0.013517</td>\n",
       "      <td>0.463645</td>\n",
       "      <td>0.957232</td>\n",
       "      <td>0.000020</td>\n",
       "      <td>201543039349301204.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>561797737.0</th>\n",
       "      <td>0.704623</td>\n",
       "      <td>0.013504</td>\n",
       "      <td>0.463645</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>201523089349301462.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>590638867.0</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.013479</td>\n",
       "      <td>0.463646</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000112</td>\n",
       "      <td>201533069349300788.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273314429.0</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.013479</td>\n",
       "      <td>0.463645</td>\n",
       "      <td>0.957232</td>\n",
       "      <td>0.000004</td>\n",
       "      <td>201533079349300238.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>710801566.0</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.013479</td>\n",
       "      <td>0.463645</td>\n",
       "      <td>0.957200</td>\n",
       "      <td>0.000168</td>\n",
       "      <td>201523209349314257.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>752204594.0</th>\n",
       "      <td>0.896895</td>\n",
       "      <td>0.013483</td>\n",
       "      <td>0.463647</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000569</td>\n",
       "      <td>201523209349311332.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251374594.0</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.013497</td>\n",
       "      <td>0.463646</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000062</td>\n",
       "      <td>201533179349302173.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450448773.0</th>\n",
       "      <td>0.991205</td>\n",
       "      <td>0.013482</td>\n",
       "      <td>0.463646</td>\n",
       "      <td>0.957232</td>\n",
       "      <td>0.000027</td>\n",
       "      <td>201533179349307048.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>363789851.0</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.013492</td>\n",
       "      <td>0.463647</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.001072</td>\n",
       "      <td>201533209349302633.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411712804.0</th>\n",
       "      <td>0.477697</td>\n",
       "      <td>0.013479</td>\n",
       "      <td>0.463648</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000119</td>\n",
       "      <td>201533099349301113.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>381557861.0</th>\n",
       "      <td>0.832159</td>\n",
       "      <td>0.013482</td>\n",
       "      <td>0.463654</td>\n",
       "      <td>0.957232</td>\n",
       "      <td>0.000200</td>\n",
       "      <td>201523039349300127.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273741627.0</th>\n",
       "      <td>0.945120</td>\n",
       "      <td>0.013479</td>\n",
       "      <td>0.463648</td>\n",
       "      <td>0.957232</td>\n",
       "      <td>0.000181</td>\n",
       "      <td>201523079349301652.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411495321.0</th>\n",
       "      <td>0.668161</td>\n",
       "      <td>0.013481</td>\n",
       "      <td>0.464095</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000162</td>\n",
       "      <td>201533039349300813.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60666277.0</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.013516</td>\n",
       "      <td>0.463647</td>\n",
       "      <td>0.957230</td>\n",
       "      <td>0.002874</td>\n",
       "      <td>201533139349300208.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42616064.0</th>\n",
       "      <td>0.951218</td>\n",
       "      <td>0.013499</td>\n",
       "      <td>0.463646</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.004864</td>\n",
       "      <td>201533069349301413.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>581651220.0</th>\n",
       "      <td>0.910347</td>\n",
       "      <td>0.013480</td>\n",
       "      <td>0.463648</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000048</td>\n",
       "      <td>201533079349300003.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341496171.0</th>\n",
       "      <td>0.850617</td>\n",
       "      <td>0.013483</td>\n",
       "      <td>0.463649</td>\n",
       "      <td>0.957232</td>\n",
       "      <td>0.000098</td>\n",
       "      <td>201523069349300957.xml</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>912130056.0</th>\n",
       "      <td>0.760828</td>\n",
       "      <td>0.013514</td>\n",
       "      <td>0.463645</td>\n",
       "      <td>0.957223</td>\n",
       "      <td>0.000107</td>\n",
       "      <td>201533099349301698.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237198698.0</th>\n",
       "      <td>0.819953</td>\n",
       "      <td>0.013511</td>\n",
       "      <td>0.463646</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000051</td>\n",
       "      <td>201543119349300204.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462250934.0</th>\n",
       "      <td>0.131636</td>\n",
       "      <td>0.013535</td>\n",
       "      <td>0.463645</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000333</td>\n",
       "      <td>201543139349302814.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231416559.0</th>\n",
       "      <td>0.598760</td>\n",
       "      <td>0.013526</td>\n",
       "      <td>0.463646</td>\n",
       "      <td>0.957230</td>\n",
       "      <td>0.000129</td>\n",
       "      <td>201533219349301213.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223128187.0</th>\n",
       "      <td>0.621104</td>\n",
       "      <td>0.013481</td>\n",
       "      <td>0.463650</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000100</td>\n",
       "      <td>201543179349306629.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>731585237.0</th>\n",
       "      <td>0.849584</td>\n",
       "      <td>0.013486</td>\n",
       "      <td>0.463647</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>201533209349316263.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>581736427.0</th>\n",
       "      <td>0.887224</td>\n",
       "      <td>0.013560</td>\n",
       "      <td>0.463642</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000021</td>\n",
       "      <td>201543079349301044.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>470841633.0</th>\n",
       "      <td>0.730878</td>\n",
       "      <td>0.013493</td>\n",
       "      <td>0.463666</td>\n",
       "      <td>0.957234</td>\n",
       "      <td>0.000118</td>\n",
       "      <td>201533139349300123.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>943345498.0</th>\n",
       "      <td>0.570344</td>\n",
       "      <td>0.013481</td>\n",
       "      <td>0.463655</td>\n",
       "      <td>0.957232</td>\n",
       "      <td>0.000085</td>\n",
       "      <td>201543179349305429.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>264795329.0</th>\n",
       "      <td>0.984882</td>\n",
       "      <td>0.013541</td>\n",
       "      <td>0.463645</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000891</td>\n",
       "      <td>201543179349308719.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262709818.0</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.013537</td>\n",
       "      <td>0.463645</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000005</td>\n",
       "      <td>201533179349302373.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>431129770.0</th>\n",
       "      <td>0.868905</td>\n",
       "      <td>0.013491</td>\n",
       "      <td>0.463648</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.001629</td>\n",
       "      <td>201620149349300127.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>592240502.0</th>\n",
       "      <td>0.858238</td>\n",
       "      <td>0.013484</td>\n",
       "      <td>0.463650</td>\n",
       "      <td>0.957232</td>\n",
       "      <td>0.000936</td>\n",
       "      <td>201630129349300803.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61462359.0</th>\n",
       "      <td>0.843057</td>\n",
       "      <td>0.013484</td>\n",
       "      <td>0.463646</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000101</td>\n",
       "      <td>201620119349300422.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>630652760.0</th>\n",
       "      <td>0.992892</td>\n",
       "      <td>0.013496</td>\n",
       "      <td>0.463646</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000526</td>\n",
       "      <td>201630129349300723.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341472960.0</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.013537</td>\n",
       "      <td>0.463645</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000040</td>\n",
       "      <td>201610139349300811.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>800182020.0</th>\n",
       "      <td>0.594838</td>\n",
       "      <td>0.013487</td>\n",
       "      <td>0.463645</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000217</td>\n",
       "      <td>201600199349300500.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462754433.0</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.013479</td>\n",
       "      <td>0.463646</td>\n",
       "      <td>0.957232</td>\n",
       "      <td>0.000059</td>\n",
       "      <td>201600399349300955.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>742744885.0</th>\n",
       "      <td>0.975219</td>\n",
       "      <td>0.013479</td>\n",
       "      <td>0.463647</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>201600369349301750.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>471127421.0</th>\n",
       "      <td>0.138038</td>\n",
       "      <td>0.013479</td>\n",
       "      <td>0.463652</td>\n",
       "      <td>0.957239</td>\n",
       "      <td>0.000022</td>\n",
       "      <td>201610399349300226.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>742244155.0</th>\n",
       "      <td>0.901125</td>\n",
       "      <td>0.013511</td>\n",
       "      <td>0.463645</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.003509</td>\n",
       "      <td>201620359349300612.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>940764760.0</th>\n",
       "      <td>0.992275</td>\n",
       "      <td>0.013525</td>\n",
       "      <td>0.463645</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000075</td>\n",
       "      <td>201610429349302361.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>840588263.0</th>\n",
       "      <td>0.988925</td>\n",
       "      <td>0.013483</td>\n",
       "      <td>0.463646</td>\n",
       "      <td>0.957232</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>201610369349301226.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20650275.0</th>\n",
       "      <td>0.681210</td>\n",
       "      <td>0.013508</td>\n",
       "      <td>0.463646</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>201640359349300129.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>942418861.0</th>\n",
       "      <td>0.987789</td>\n",
       "      <td>0.013480</td>\n",
       "      <td>0.463656</td>\n",
       "      <td>0.957233</td>\n",
       "      <td>0.000317</td>\n",
       "      <td>201600429349301735.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223201871.0</th>\n",
       "      <td>0.907986</td>\n",
       "      <td>0.013479</td>\n",
       "      <td>0.463655</td>\n",
       "      <td>0.957232</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>201600359349302005.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>650599763.0</th>\n",
       "      <td>0.955581</td>\n",
       "      <td>0.013723</td>\n",
       "      <td>0.463644</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.000022</td>\n",
       "      <td>201600419349301130.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>470461460.0</th>\n",
       "      <td>0.465235</td>\n",
       "      <td>0.013480</td>\n",
       "      <td>0.463650</td>\n",
       "      <td>0.957232</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>201640359349301614.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>990208381.0</th>\n",
       "      <td>0.852344</td>\n",
       "      <td>0.013482</td>\n",
       "      <td>0.463648</td>\n",
       "      <td>0.957232</td>\n",
       "      <td>0.000027</td>\n",
       "      <td>201600429349302135.xml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510216586.0</th>\n",
       "      <td>0.521938</td>\n",
       "      <td>0.013522</td>\n",
       "      <td>0.463647</td>\n",
       "      <td>0.957231</td>\n",
       "      <td>0.707131</td>\n",
       "      <td>201610229349300741.xml</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>38657 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Program_Exp  Liabilities_To_Asset  Working_Capital  \\\n",
       "EIN                                                               \n",
       "510311790.0     0.989619              0.013484         0.463650   \n",
       "261460932.0     0.965378              0.013479         0.463657   \n",
       "270609504.0     0.942276              0.013482         0.463647   \n",
       "521548962.0     0.384526              0.013479         0.463740   \n",
       "731653383.0     0.620560              0.013480         0.463649   \n",
       "237324566.0     0.758902              0.013522         0.463645   \n",
       "43259150.0      0.736312              0.013489         0.463646   \n",
       "621273871.0     0.644822              0.013492         0.463690   \n",
       "541897455.0     0.845659              0.013487         0.463646   \n",
       "251869168.0     0.762357              0.013479         0.463672   \n",
       "376046335.0     0.745386              0.013479         0.463696   \n",
       "50454409.0      0.915261              0.013479         0.463649   \n",
       "272364809.0     0.920307              0.013479         0.463646   \n",
       "463812139.0     0.664088              0.013517         0.463645   \n",
       "561797737.0     0.704623              0.013504         0.463645   \n",
       "590638867.0     0.000000              0.013479         0.463646   \n",
       "273314429.0     1.000000              0.013479         0.463645   \n",
       "710801566.0     1.000000              0.013479         0.463645   \n",
       "752204594.0     0.896895              0.013483         0.463647   \n",
       "251374594.0     0.000000              0.013497         0.463646   \n",
       "450448773.0     0.991205              0.013482         0.463646   \n",
       "363789851.0     0.000000              0.013492         0.463647   \n",
       "411712804.0     0.477697              0.013479         0.463648   \n",
       "381557861.0     0.832159              0.013482         0.463654   \n",
       "273741627.0     0.945120              0.013479         0.463648   \n",
       "411495321.0     0.668161              0.013481         0.464095   \n",
       "60666277.0      0.000000              0.013516         0.463647   \n",
       "42616064.0      0.951218              0.013499         0.463646   \n",
       "581651220.0     0.910347              0.013480         0.463648   \n",
       "341496171.0     0.850617              0.013483         0.463649   \n",
       "...                  ...                   ...              ...   \n",
       "912130056.0     0.760828              0.013514         0.463645   \n",
       "237198698.0     0.819953              0.013511         0.463646   \n",
       "462250934.0     0.131636              0.013535         0.463645   \n",
       "231416559.0     0.598760              0.013526         0.463646   \n",
       "223128187.0     0.621104              0.013481         0.463650   \n",
       "731585237.0     0.849584              0.013486         0.463647   \n",
       "581736427.0     0.887224              0.013560         0.463642   \n",
       "470841633.0     0.730878              0.013493         0.463666   \n",
       "943345498.0     0.570344              0.013481         0.463655   \n",
       "264795329.0     0.984882              0.013541         0.463645   \n",
       "262709818.0     1.000000              0.013537         0.463645   \n",
       "431129770.0     0.868905              0.013491         0.463648   \n",
       "592240502.0     0.858238              0.013484         0.463650   \n",
       "61462359.0      0.843057              0.013484         0.463646   \n",
       "630652760.0     0.992892              0.013496         0.463646   \n",
       "341472960.0     1.000000              0.013537         0.463645   \n",
       "800182020.0     0.594838              0.013487         0.463645   \n",
       "462754433.0     0.000000              0.013479         0.463646   \n",
       "742744885.0     0.975219              0.013479         0.463647   \n",
       "471127421.0     0.138038              0.013479         0.463652   \n",
       "742244155.0     0.901125              0.013511         0.463645   \n",
       "940764760.0     0.992275              0.013525         0.463645   \n",
       "840588263.0     0.988925              0.013483         0.463646   \n",
       "20650275.0      0.681210              0.013508         0.463646   \n",
       "942418861.0     0.987789              0.013480         0.463656   \n",
       "223201871.0     0.907986              0.013479         0.463655   \n",
       "650599763.0     0.955581              0.013723         0.463644   \n",
       "470461460.0     0.465235              0.013480         0.463650   \n",
       "990208381.0     0.852344              0.013482         0.463648   \n",
       "510216586.0     0.521938              0.013522         0.463647   \n",
       "\n",
       "             Surplus_Margin  Total_Expenses                Filename  \n",
       "EIN                                                                  \n",
       "510311790.0        0.957231        0.000068  201523229349300327.xml  \n",
       "261460932.0        0.957231        0.000004  201543089349301829.xml  \n",
       "270609504.0        0.957232        0.000056  201533179349306298.xml  \n",
       "521548962.0        0.957234        0.000007  201533209349304768.xml  \n",
       "731653383.0        0.957232        0.000004  201533179349307343.xml  \n",
       "237324566.0        0.957231        0.000089  201533189349300608.xml  \n",
       "43259150.0         0.957231        0.000031  201523069349301367.xml  \n",
       "621273871.0        0.957233        0.000209  201533069349300963.xml  \n",
       "541897455.0        0.957231        0.000068  201523099349300542.xml  \n",
       "251869168.0        0.957232        0.000015  201533099349301033.xml  \n",
       "376046335.0        0.957232        0.000005  201523169349304367.xml  \n",
       "50454409.0         0.957231        0.000082  201533099349301803.xml  \n",
       "272364809.0        0.957231        0.000044  201523069349300142.xml  \n",
       "463812139.0        0.957232        0.000020  201543039349301204.xml  \n",
       "561797737.0        0.957231        0.000031  201523089349301462.xml  \n",
       "590638867.0        0.957231        0.000112  201533069349300788.xml  \n",
       "273314429.0        0.957232        0.000004  201533079349300238.xml  \n",
       "710801566.0        0.957200        0.000168  201523209349314257.xml  \n",
       "752204594.0        0.957231        0.000569  201523209349311332.xml  \n",
       "251374594.0        0.957231        0.000062  201533179349302173.xml  \n",
       "450448773.0        0.957232        0.000027  201533179349307048.xml  \n",
       "363789851.0        0.957231        0.001072  201533209349302633.xml  \n",
       "411712804.0        0.957231        0.000119  201533099349301113.xml  \n",
       "381557861.0        0.957232        0.000200  201523039349300127.xml  \n",
       "273741627.0        0.957232        0.000181  201523079349301652.xml  \n",
       "411495321.0        0.957231        0.000162  201533039349300813.xml  \n",
       "60666277.0         0.957230        0.002874  201533139349300208.xml  \n",
       "42616064.0         0.957231        0.004864  201533069349301413.xml  \n",
       "581651220.0        0.957231        0.000048  201533079349300003.xml  \n",
       "341496171.0        0.957232        0.000098  201523069349300957.xml  \n",
       "...                     ...             ...                     ...  \n",
       "912130056.0        0.957223        0.000107  201533099349301698.xml  \n",
       "237198698.0        0.957231        0.000051  201543119349300204.xml  \n",
       "462250934.0        0.957231        0.000333  201543139349302814.xml  \n",
       "231416559.0        0.957230        0.000129  201533219349301213.xml  \n",
       "223128187.0        0.957231        0.000100  201543179349306629.xml  \n",
       "731585237.0        0.957231        0.000036  201533209349316263.xml  \n",
       "581736427.0        0.957231        0.000021  201543079349301044.xml  \n",
       "470841633.0        0.957234        0.000118  201533139349300123.xml  \n",
       "943345498.0        0.957232        0.000085  201543179349305429.xml  \n",
       "264795329.0        0.957231        0.000891  201543179349308719.xml  \n",
       "262709818.0        0.957231        0.000005  201533179349302373.xml  \n",
       "431129770.0        0.957231        0.001629  201620149349300127.xml  \n",
       "592240502.0        0.957232        0.000936  201630129349300803.xml  \n",
       "61462359.0         0.957231        0.000101  201620119349300422.xml  \n",
       "630652760.0        0.957231        0.000526  201630129349300723.xml  \n",
       "341472960.0        0.957231        0.000040  201610139349300811.xml  \n",
       "800182020.0        0.957231        0.000217  201600199349300500.xml  \n",
       "462754433.0        0.957232        0.000059  201600399349300955.xml  \n",
       "742744885.0        0.957231        0.000034  201600369349301750.xml  \n",
       "471127421.0        0.957239        0.000022  201610399349300226.xml  \n",
       "742244155.0        0.957231        0.003509  201620359349300612.xml  \n",
       "940764760.0        0.957231        0.000075  201610429349302361.xml  \n",
       "840588263.0        0.957232        0.000033  201610369349301226.xml  \n",
       "20650275.0         0.957231        0.000044  201640359349300129.xml  \n",
       "942418861.0        0.957233        0.000317  201600429349301735.xml  \n",
       "223201871.0        0.957232        0.000034  201600359349302005.xml  \n",
       "650599763.0        0.957231        0.000022  201600419349301130.xml  \n",
       "470461460.0        0.957232        0.000033  201640359349301614.xml  \n",
       "990208381.0        0.957232        0.000027  201600429349302135.xml  \n",
       "510216586.0        0.957231        0.707131  201610229349300741.xml  \n",
       "\n",
       "[38657 rows x 6 columns]"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.reset_index(drop=True,inplace=True)\n",
    "norm_df=df.copy()\n",
    "\n",
    "norm_df=norm_df[['Program_Exp','Liabilities_To_Asset','Working_Capital','Surplus_Margin','Total_Expenses']]\n",
    "\n",
    "from sklearn import preprocessing\n",
    "\n",
    "x = norm_df.values #returns a numpy array\n",
    "min_max_scaler = preprocessing.MinMaxScaler()\n",
    "x_scaled = min_max_scaler.fit_transform(x)\n",
    "norm_df = pd.DataFrame(x_scaled)\n",
    "norm_df[\"Filename\"]=df['Filename']\n",
    "\n",
    "norm_df[\"EIN\"]=df['EIN']\n",
    "norm_df.columns=['Program_Exp','Liabilities_To_Asset','Working_Capital','Surplus_Margin','Total_Expenses','Filename','EIN']\n",
    "norm_df.set_index('EIN',inplace=True)\n",
    "norm_df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "       Program_Exp  Liabilities_To_Asset  Working_Capital  Surplus_Margin  \\\n",
      "0         0.684058              0.013484         0.463650        0.957231   \n",
      "1         0.667302              0.013479         0.463657        0.957231   \n",
      "2         0.651333              0.013482         0.463647        0.957232   \n",
      "3         0.265798              0.013479         0.463740        0.957234   \n",
      "4         0.428952              0.013480         0.463649        0.957232   \n",
      "5         0.524579              0.013522         0.463645        0.957231   \n",
      "6         0.508964              0.013489         0.463646        0.957231   \n",
      "7         0.445723              0.013492         0.463690        0.957233   \n",
      "8         0.584548              0.013487         0.463646        0.957231   \n",
      "9         0.526967              0.013479         0.463672        0.957232   \n",
      "10        0.515236              0.013479         0.463696        0.957232   \n",
      "11        0.632659              0.013479         0.463649        0.957231   \n",
      "12        0.636148              0.013479         0.463646        0.957231   \n",
      "13        0.459040              0.013517         0.463645        0.957232   \n",
      "14        0.487059              0.013504         0.463645        0.957231   \n",
      "15        0.000000              0.013479         0.463646        0.957231   \n",
      "16        0.691234              0.013479         0.463645        0.957232   \n",
      "17        0.691234              0.013479         0.463645        0.957200   \n",
      "18        0.619964              0.013483         0.463647        0.957231   \n",
      "19        0.000000              0.013497         0.463646        0.957231   \n",
      "20        0.685154              0.013482         0.463646        0.957232   \n",
      "21        0.000000              0.013492         0.463647        0.957231   \n",
      "22        0.330200              0.013479         0.463648        0.957231   \n",
      "23        0.575217              0.013482         0.463654        0.957232   \n",
      "24        0.653299              0.013479         0.463648        0.957232   \n",
      "25        0.461856              0.013481         0.464095        0.957231   \n",
      "26        0.000000              0.013516         0.463647        0.957230   \n",
      "27        0.657514              0.013499         0.463646        0.957231   \n",
      "28        0.629263              0.013480         0.463648        0.957231   \n",
      "29        0.587975              0.013483         0.463649        0.957232   \n",
      "...            ...                   ...              ...             ...   \n",
      "38639     0.525910              0.013514         0.463645        0.957223   \n",
      "38640     0.566779              0.013511         0.463646        0.957231   \n",
      "38641     0.090991              0.013535         0.463645        0.957231   \n",
      "38642     0.413883              0.013526         0.463646        0.957230   \n",
      "38643     0.429328              0.013481         0.463650        0.957231   \n",
      "38644     0.587261              0.013486         0.463647        0.957231   \n",
      "38645     0.613279              0.013560         0.463642        0.957231   \n",
      "38646     0.505208              0.013493         0.463666        0.957234   \n",
      "38647     0.394241              0.013481         0.463655        0.957232   \n",
      "38648     0.680784              0.013541         0.463645        0.957231   \n",
      "38649     0.691234              0.013537         0.463645        0.957231   \n",
      "38650     0.600616              0.013491         0.463648        0.957231   \n",
      "38651     0.593243              0.013484         0.463650        0.957232   \n",
      "38652     0.582750              0.013484         0.463646        0.957231   \n",
      "38653     0.686320              0.013496         0.463646        0.957231   \n",
      "38654     0.691234              0.013537         0.463645        0.957231   \n",
      "38655     0.411172              0.013487         0.463645        0.957231   \n",
      "38656     0.000000              0.013479         0.463646        0.957232   \n",
      "38657     0.674104              0.013479         0.463647        0.957231   \n",
      "38658     0.095417              0.013479         0.463652        0.957239   \n",
      "38659     0.622888              0.013511         0.463645        0.957231   \n",
      "38660     0.685894              0.013525         0.463645        0.957231   \n",
      "38661     0.683578              0.013483         0.463646        0.957232   \n",
      "38662     0.470875              0.013508         0.463646        0.957231   \n",
      "38663     0.682793              0.013480         0.463656        0.957233   \n",
      "38664     0.627631              0.013479         0.463655        0.957232   \n",
      "38665     0.660530              0.013723         0.463644        0.957231   \n",
      "38666     0.321586              0.013480         0.463650        0.957232   \n",
      "38667     0.589169              0.013482         0.463648        0.957232   \n",
      "38668     0.360782              0.013522         0.463647        0.957231   \n",
      "\n",
      "       Total_Expenses                Filename  \n",
      "0            0.000068  201523229349300327.xml  \n",
      "1            0.000004  201543089349301829.xml  \n",
      "2            0.000056  201533179349306298.xml  \n",
      "3            0.000007  201533209349304768.xml  \n",
      "4            0.000004  201533179349307343.xml  \n",
      "5            0.000089  201533189349300608.xml  \n",
      "6            0.000031  201523069349301367.xml  \n",
      "7            0.000209  201533069349300963.xml  \n",
      "8            0.000068  201523099349300542.xml  \n",
      "9            0.000015  201533099349301033.xml  \n",
      "10           0.000005  201523169349304367.xml  \n",
      "11           0.000082  201533099349301803.xml  \n",
      "12           0.000044  201523069349300142.xml  \n",
      "13           0.000020  201543039349301204.xml  \n",
      "14           0.000031  201523089349301462.xml  \n",
      "15           0.000112  201533069349300788.xml  \n",
      "16           0.000004  201533079349300238.xml  \n",
      "17           0.000168  201523209349314257.xml  \n",
      "18           0.000569  201523209349311332.xml  \n",
      "19           0.000062  201533179349302173.xml  \n",
      "20           0.000027  201533179349307048.xml  \n",
      "21           0.001072  201533209349302633.xml  \n",
      "22           0.000119  201533099349301113.xml  \n",
      "23           0.000200  201523039349300127.xml  \n",
      "24           0.000181  201523079349301652.xml  \n",
      "25           0.000162  201533039349300813.xml  \n",
      "26           0.002874  201533139349300208.xml  \n",
      "27           0.004864  201533069349301413.xml  \n",
      "28           0.000048  201533079349300003.xml  \n",
      "29           0.000098  201523069349300957.xml  \n",
      "...               ...                     ...  \n",
      "38639        0.000107  201533099349301698.xml  \n",
      "38640        0.000051  201543119349300204.xml  \n",
      "38641        0.000333  201543139349302814.xml  \n",
      "38642        0.000129  201533219349301213.xml  \n",
      "38643        0.000100  201543179349306629.xml  \n",
      "38644        0.000036  201533209349316263.xml  \n",
      "38645        0.000021  201543079349301044.xml  \n",
      "38646        0.000118  201533139349300123.xml  \n",
      "38647        0.000085  201543179349305429.xml  \n",
      "38648        0.000891  201543179349308719.xml  \n",
      "38649        0.000005  201533179349302373.xml  \n",
      "38650        0.001629  201620149349300127.xml  \n",
      "38651        0.000936  201630129349300803.xml  \n",
      "38652        0.000101  201620119349300422.xml  \n",
      "38653        0.000526  201630129349300723.xml  \n",
      "38654        0.000040  201610139349300811.xml  \n",
      "38655        0.000217  201600199349300500.xml  \n",
      "38656        0.000059  201600399349300955.xml  \n",
      "38657        0.000034  201600369349301750.xml  \n",
      "38658        0.000022  201610399349300226.xml  \n",
      "38659        0.003509  201620359349300612.xml  \n",
      "38660        0.000075  201610429349302361.xml  \n",
      "38661        0.000033  201610369349301226.xml  \n",
      "38662        0.000044  201640359349300129.xml  \n",
      "38663        0.000317  201600429349301735.xml  \n",
      "38664        0.000034  201600359349302005.xml  \n",
      "38665        0.000022  201600419349301130.xml  \n",
      "38666        0.000033  201640359349301614.xml  \n",
      "38667        0.000027  201600429349302135.xml  \n",
      "38668        0.707131  201610229349300741.xml  \n",
      "\n",
      "[38669 rows x 6 columns]\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Anaconda3\\lib\\site-packages\\ipykernel\\__main__.py:6: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "C:\\Anaconda3\\lib\\site-packages\\ipykernel\\__main__.py:10: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n"
     ]
    }
   ],
   "source": [
    "df2 = df.copy()\n",
    "df2.reset_index(inplace=True, drop = True)\n",
    "print(norm_df2)\n",
    "Y_class_df = pd.DataFrame()\n",
    "X_class_df=norm_df.loc[lst_temp]\n",
    "X_class_df['Efficiency'] = 1\n",
    "\n",
    "\n",
    "Y_class_df['Efficiency'] = X_class_df['Efficiency'] \n",
    "X_class_df.drop('Efficiency', axis=1, inplace=True)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "new_df=norm_df[['Program_Exp','Liabilities_To_Asset','Working_Capital','Surplus_Margin']]\n",
    "new_df.reset_index(inplace=True,drop=True)\n",
    "X_class_df=X_class_df[['Program_Exp','Liabilities_To_Asset','Working_Capital','Surplus_Margin']]\n",
    "# X_class_df=X_class_df.drop(X_class_df.index[2])   #OUTLIER REMOVER\n",
    "X_class_df.reset_index(inplace=True,drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "\n",
    "from sklearn.cluster import DBSCAN\n",
    "from sklearn import metrics\n",
    "from sklearn.datasets.samples_generator import make_blobs\n",
    "from sklearn.preprocessing import StandardScaler\n",
    "from sklearn.decomposition import TruncatedSVD\n",
    "\n",
    "svd = TruncatedSVD(n_components=2, n_iter=7)\n",
    "X = svd.fit_transform(new_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "db = DBSCAN(eps=0.1, min_samples=10).fit(X)\n",
    "core_samples_mask = np.zeros_like(db.labels_, dtype=bool)\n",
    "core_samples_mask[db.core_sample_indices_] = True\n",
    "labels = db.labels_\n",
    "n_clusters_ = len(set(labels)) - (1 if -1 in labels else 0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAhcAAAFyCAYAAABGCPg8AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAAPYQAAD2EBqD+naQAAIABJREFUeJzs3Xl8lNX1+PHPIewYIOxbYrAiorUi+brLGpCvCggIsqjw\nU79VShWkpRVE61KsWhWEKoKCgloRoaKgtcgOWmUJixviBiRE9gxhgLAk3N8fZ4ZMhkkySWYIIef9\neuUV8szz3OfOJGRO7j33XHHOYYwxxhgTKRVKuwPGGGOMObtYcGGMMcaYiLLgwhhjjDERZcGFMcYY\nYyLKggtjjDHGRJQFF8YYY4yJKAsujDHGGBNRFlwYY4wxJqIsuDDGGGNMRFlwYcosEVkmIktLux+R\nJCLnisgJERlU2n0pqoC+/6G0+xIOEakhIlNFZIev3+NK2N4yEVkSqf4ZU5ZZcGEiTkQG+35Zh/rI\nEZEritBWKxF5VEQSQjzsgBOR63n4ROR3IjK4NO5tImYMMAh4CbgdeLOE7UV1LwURGS0iN0fzHpEi\nIo1E5GkRWSIiB3z/99uVdr/M6VOxtDtgzloOeATYGuKxH4vQzkXAo8BSIDXosS7F6llkDAX2ADNK\nsQ+mZDoCXzjnxpZ2R8L0EDAb+KC0OxKGlsCfgB+AL4GrS7c75nSz4MJE03+cc+tK2IaQz1+Ezrns\nErZtyiARqe6cOxyBphoA30SgnTJLRKoAx1zkd7BcC9R1zu0XkVuw4KLcsWkRU6pEpL+IrPUNnWaK\nyJcicr/vscHAu75TlwVMq7TzPZ5njltE2vvO6eubStnua3e2iMSKSGUReUFEdomIV0ReE5FKQf25\nU0QW+845IiLfiMiQoHO2ABcDHQKmewL7Uct3n1RfGz+IyJ9FRILaqSUi00Vkv4h4ROR1oHaYr5t/\n6ukaERknIrtF5KCIvCcidYPOPSEifwnRxlYReS1Em9eKyERfmx4RmSwiFX39fUNEMnwfzxTQvwd8\n7R/2fZ8uDnFOSxGZIyL7RCRLRNaISPd8nmc7EZkkIruAtEJem/oiMk1Edvra3SABOSz+nxMgEegW\n8HMVauotsN3bRWSViBzyPf/lItK5gPP/n6/thKDj/p/TdgHHzheRf4nmf2SJSJqIzBSRWN/jJ4Dq\ngL/NE0Hfuya+n+edvp+5r0Xkznzu209ExorIduAQEOv7/j4qIt/77r9XRFaKSHLA9RV937NGBb1O\nAM65Q865/YWdZ85eNnJhoqlW8Bsd4JxzGQAi0gV4G1gI/Nn3eCvgWuAfwApgInA/MBb4znfOJn9b\n+dx3NHAYeAo433f9cTQ/ozY6zXIVMBj42de23xDga3ToORvoDkwSEXHOvew7ZzjwIuD1XSvALt9z\nqubrd2NgMvpGeI2vL42AwGTHeb7HXvY9t17oNEtR/or8B5ABPIa+WY7w9W1AGNfmd59/ADuAv6Cv\n02+B/b6+bkNf3xuBkSLylXPuraDrBwPn+PpRFX29FovIJc65PQC+YONTYDv62hwCbgXeF5Hezrng\nof9JwG7gcaBGfk9IRKoCy4HzfM9jK9AXmC4itZxz/wC+RXMsXkC/P8/7Lt9TQLuPoj83n6HTfceA\nK4FOwKJ8LnPk/xqfPC4a4H4CVEJ/3ncCTYFu6M+r19ffacAq4BXfpT/5rm/gO57ju34vcAMwTURi\nnXMTg+79CHAUeBao7HsujwOjfG2vAWoC/wO0ARb7rmuK/t+bDtyVz/MyRjnn7MM+IvqBvrmcyOfj\ncMB54wFPIW3dgv7SbBfisaXAkoCv2/vusRGICTj+T18bHwZd/xnwc9CxKiHu8zHwQ9CxrwLvHXD8\nYeAAcF7Q8b+hv8Sb+r6+2dfXPwScI+gbYw4wKMzX+D9Bx5/33Sc24NgJ4C8h2tgCvBaizY9CvE45\nwIsBxyqgOTCBr/+5vusPAo0Cjl/uO/5cwLFFwHqgYtC9PgW+C9GnZYCE8bM33NfX/gHHYnzPIROo\nEfT854XR5q/QQHN2IecF/zwO9vUlIei89oE/08ClvufYq5D2vYHfr4DjU9EgrXbQ8bfRwLNK0P+P\nH4DKQeeuL+y18H1/c4Bphb1mQdfl+3/YPs7eD5sWMdHigN8BnYM+bgg4Zz9QQ0S6RvjeM5xzOQFf\nr/J9fi3ovFVAvIic/H/gnDvq/7eI1PSNvKwAzvMPUReiD7ASyBSRuv4P9K+/ioB/KPxGdDRlcsC9\nHfrXthAeR+5fsX4r0TfTc8NsI1SboV4nAo87506g8+rnhWhjrnNuZ8C5a3xt3AggInFoMuVsfKNb\nAa/TJ0ALEWkc1KdXfa9PYW4Adjrn3gm4v/8v+nPQN9ii6oV+T54oxrXhyPR9/l/fyFdR9QbmAzEh\nXsta6OhDoOnOuWNBx/YDF4vI+fndxDm3zTkX45y7uxh9NOWMTYuYaFrjCk7onIQOWf9bRH5Bfxm+\n65xbUML7Bs/JZxZwvAL6C9gDICLXokPEV6Fz3H7Od563kHu3AC4h9BC7Q5MIARKAHe7UxMTNhbQf\nLPg5eXyf44rYTqDgVTkFvX6h7hNqNdD36PcadKpKgL+Sd0rKz/867Qg4tjX/7uZxLvqXebBNvnsW\nJ+g6D/2Lf1NhJxaHc26riDyPTpndLiIr0Smzt5xzBwq6VkTqo1Mn9wD3hmqe3J85v60hzvsL8D7w\nvYh8DfwHeNM591VRnosxfhZcmFLjnNsjIq2BruhfnDcAd4rIDOfcnQVfXaCcIh4XABE5Dx2u34Tm\nLqShUww3AQ8QXgJ0BTSH5BlCj0B8H0YbRVHgcypETBHbDHU83FGWQP7X8Tkgv0AyOEDJKsZ9Slt+\nIy2nvO7OuT+JyHR0uux6dKRllIhc5Zz7pYB7+F/Lt8h/WfSXQV+f8lo651aKyK8C7n83MEJE7nXO\nBY9kGVMoCy5MqXK6nPQj3wci8jJwj4j81Tn3M1EuTBSkO5rg1t05l+4/GJgxHyC/fv0EnOOcK6xy\n6Dagk5y6rPLConQ4TB6CVqH4kggbhz69xFqEOHYBuX8x/+z7fNw5F+mKltvQkaNgrQIeL6qf0Dfx\nizj1jbog/lGk2uQdDUoMdbJz7ht0aezfROQq4L9ogrF/pU+on7k96GhaTElfS6erO2YAM0SkOjrF\n9hinTpMZUyjLuTClRkTqhDjsH4at4vt8CP3rOKwlmiXk/8v85P8LEakF/L8Q5x7Kp0/vAleLyPXB\nD4gu5fS3/W90dcDvAh6vgK5siXRA9RO5uR5+95L/yEVJ9RSRJv4vRCuyXok+Z5yuGFkG3BtqWaOI\n1CvBvf8NNBKRfgHtxaCvqxdNmC2q99HvyV9EpCgjNT+hP7uBS04roFMYBByL9fUx0DfoVEyVgGOn\n/Mz5cl/+BdwioZf7hvVaBv9f9AW8PwbevyhLUY2xkQsTLQLcKCKtQjz2mXNuKzDV90ttCZrtngjc\nB6x3zvnntzegb/oPikhtdAndYufc3mL0pzCfoEmWH4rIFCAW+D90mWnwL9QUYIiIjEF/Ce/2jVY8\nC/TwtTHdd14N4Ddo4l0imsE/H13B8LSINEeXR/b23bOkzyn4+FRgsojMQadsLkWHvkPlhRRnmiPY\nj8CnvlEo/1LUPehr4/d79C/jr0TkVXQ0oyFabKkpcFkx+/QKGjhNF5H/IXcp6tXAcOfcoaI+Gefc\nTyLyJLoSaKWIvIf+HF4OpDvnxuRz3bci8gX6Pa6Lft/7c+ofdZ2AF0VkNjptVhEtS56NBg5+KUBn\nERkB/AJscc6tRpeQdgBW+V7Lb4E6QJKv7XACjG9FZJnvHhm+59YHnZ7xK9JSVBF5GA3KLka/h4NE\npC2Ac+7JMPpkyrLSXq5iH2ffB7lL8PL7GOQ7rxe6zHMHOg+8Bd3noUFQe3ehSXrHyLuEbykaaPjP\n8y/x651Pf9oEHX/Ud7xOwLGb0GV5h9C/PP+IjlzkWVKIJsnNQ7Psc8i7BLE6mqi42fe8dqFvpA+Q\nd4lsbfQXtQf9hf46GoSEuxQ11HPKs8zRd0zQpbC70L/ePwKao2/o04rzOvmOvw5kBnztX6o4wvdc\nt6L1RpYCvw7xHBJ9baQDR9Cpgw8IWJKZX58KeW3qoQHVLt/rvwG4I8R5PwMfFPHneq3vOe1Fg+JO\nAY/n+XkMeI4LfNf8gq446UTen+NE4FU0sDiEBmKLgA5BbV3gu8dB3/WvBT3nib7X/IjvNf0EuKuw\n/x++x0YDnwP7fO1/AzwY9PNapKWo6MhLqP//2afz95F9lM6H+H4IjDHGGGMiIuo5FyLyexHZ4isp\n+4WIXF7I+beJlus9JCK/iJbxDTU3b4wxxpgzUFSDC19S1fPosOplaOXEBfklGflqDMxAhwgvQuf8\nruDUQkHGGGOMOUNFdVrEl8y0yjk33Pe1oLUDJjrn/h7i/D8CQ5xzLQKO3Qf82TlX4KZCxhhjjDkz\nRG3kwreOPoncTW9wGsksIv/tdz9HyzHf4GujIZrp/VG0+mmMMcaYyIrmUtR66Dr6XUHHdwEtQ13g\nnPuviNwOzPLtblgRzci/L7+b+JZ4dSU3S9oYY4wx4amKb1WTc25fpBo9o+pciMhFwAS0KtwnaAXB\n54ApaL2BULqiu14aY4wxpnhuQ3fSjYhoBhd70TXNDYOONwR2nno6oMVgPnPOjfN9/bWIDEUL14xx\nzgWPgoCvpPBbb71Fq1ah6jWdPUaMGMH48eNLuxunRXl5rqfreTrnKFpxyciy7+fZxZ7n2WPTpk3c\nfvvtEP7mgGGJWnDhnDsuIilAMjq14U/oTCZv1bdA1dFCSYFOoFXe8vvNeASgVatWtGkTvLPw2aVW\nrVpn/XP0Ky/PNZrP0+v1MmbMGObPn8/x48epVKkS3bt358knnyQ2tiiFQEvOvp9nF3ueZ6WIphVE\ne1pkHFqGNwVYjVbuq45WJUREngKaOOcG+86fD7wiIkPQqnZNgPHoipP8RjuMMUG8Xi9XX301mzZt\n4sSJEyePv/TSSyxZsoTPP//8tAcYxpjyI6p1Lpxz7wIj0ZK369HSxl2dblwEul9DfMD5M4A/oPsO\nfAXMQmvZ3xLNfhpzthkzZswpgQXAiRMn2LRpEw8//HAp9cwYUx5EvUKnc26Scy7ROVfNOXe1c25t\nwGN3Ouc6BZ3/knPuEufcOc65Zs65wc65HdHupzFlQbh1aebPn39KYOF34sQJ5s2bF8luGWNMHrbl\nehkyYMCA0u7CaVNenms4z9Pr9TJs2DCaN29OfHw8zZs3Z9iwYXi93pDnO+c4fvx4gW0eP3487EAl\nEuz7eXax52kKU+Y3LhORNkBKSkpKeUq8MeVEfrkTFSpUoFWrVvnmTjRv3pytW7fm225iYiJbtmyJ\nRpeNMWXIunXrSEpKAkhyzq2LVLs2cmHMGay4uRPdu3enQoXQ/70rVKhAjx49It5XY4zxs+DCmDNY\ncXMnnnzySVq1anVKgOEf8Rg7dmzE+2qMMX4WXBhzhipJ7kRsbCyff/459913H4mJiTRt2pTExETu\nu+8+W4ZqjIm6M6r8tzEml4hQqVKlAs+pVKlSvpU3Y2NjmTBhAhMmTCj1Cp3GmPLFRi6MOYNFKnfC\nAgtjzOlkwYUxZzDLnTDGlEUWXBhTiNJcrm25E8aYsshyLkyZ4PF4eHPWLL7buhWP10tcbCwXJiZy\nR79+xMXFRfx+Xq+XMU89xfzlyzlepQqVjh6le/v2PDl69Gl/Q7fcCWNMWWPBhTmjpaSk8OiECWxI\nT2dn27bk/OpXUL06HD5MTHo6f+/Th8uaNeOxYcP8hWBKzOv1cnW3bmy66SZOjB0LIuAcL61Zw5Ju\n3fj8ww9LbcTAAgtjTFlgwYU5I2VnZ9P/3ntZ5vWyr3t3iI8/5ZycFi1I79CB9LQ0Pn/mGTrExvLO\nlClUrFiyH+sxTz2lgcUVV+QeFOHEFVewCXj46aeZ8OSTJbqHMcaczSznwpxxsrOzSe7Th48SE9k3\ndGjIwCKP+Hj2DR3KR+eeS+e+fcnOzi7R/ecvX86Jyy8P+diJyy9n3vLlJWrfGGPOdjZyYU6bcPMm\n+t97L6uTkjjStm2R2j/Srh2rgAFDhjB76tRi9dE5x/EqVXQqJBQRjleubLkPxhhTAAsuTNT4g4mV\na9bw2fr1ZB45QlaLFriOHeGSS0LmTTjnWOb1Fjmw8DvSrh1LJ00iJSWlWDkYIkKlo0fBudABhnNU\nOnrUAgtjjCmABRcmIrZs2cKw0aNZu2kTmQcPcuzYMcjJIad3b7jqKujUCQ4fhu3bYc4cqF0buncn\np0OHPHkTlTZvZt/IkSXqy75u3Xh84kTmzZhRrOu7t2/PS2vW5M258KmwZg09OnQoUf+MMeZsZ8GF\nKbLA6Y01n3/O+p9+Iqd2bejdG5KTT67mIC0N5s6FxYuhVy+4/npo0QI6dsx97KOPYPhwzZu44w54\n4onCcywKk5DAurQ09u/fT+3atYt8+ZOjR7OkWzc2oTkW/tUiFdasodVHHzH2ww9L1j9jjDnLSWkW\nCIoEEWkDpKSkpNCmTZvS7s5Z6fLLL2ft2rVwzjn64Z8SOHgQvF547jkoaAoiLQ3efhu2bIGJE6Fy\n5dzHli2D5cvh4Yfh44+hRg0NPkooZulSxjVuzLAhQ4p1vdfr5eGnn2be8uUcr1yZSseO0aN9e8aO\nGmWFq4wxZ41169b5p5CTnHPrItWujVyYU3g8HqZMn87oUaPg2DFo1AguvlhHJuLj845MvPcePP88\n7NgBo0fr6ESw+Hh48EEdwbj3XpgyJTfA8E8xTJwItWpBMXMtguU0bcrmrVuLfX1sbCwTnnySCWDJ\nm8YYU0QWXJiTUlJSeODxx/nvTz9x4ttvoX59aNMGbrst9FRFixaaS5GWBv/8J0ydCk89BQsW5B2d\n8EtO1s/Dh8PLL+ce79ABvvwSdu3SwCUSqldn/4EDEWnKAgtjjCkaq3NRznk8Hsa/9BLnXXEFV4we\nzafduuUGFkOGwKhRYdWZYNQoHZVo0AC6doWvvgp9bnIyJCbCJ5/kPd6zp45+HD4ckefF4cPUrlkz\nMm0ZY4wpEhu5KKf8ZbXXp6Xxi8cDN9+suQ63354bWHTqVLRG/SMTU6bAM8/octORIyEmJu95AwbA\n3/6WdwolIUGnYLZv1xGREopJT6dlQkKJ2zHGGFN0NnJRzmRnZ9Pn7rvp+swzfNSlC7/ExupKjo4d\nYcYMSE/XqZCiBhZ+ycl6fXo6VKqkoxnffpv3nIQEfWznzrzHu3fX1SMR0GjlSgb17x+RtowxxhSN\nBRflyClltQ8fhooVoX17PWHRIk3evO22kt1o4EBtJyVF7zF2rB67+27Nt/jhB50GmT4973UtWujo\nRVpaye6fmkqb+PhiLUM1xhhTcjYtUo6cUlZ73jzw/3X/ww86JXHxxRGpM0GdOhooDBwIzZrlrjBJ\nTYUXXoADB+Do0bzXVa+uORtz58KwYcW+fd0PP+SxUaNK9hyMMcYUm41clBNr167NW1bb64XMzNxA\n4sUXITZWl5tGQu/ekJ2t0y0tWkDTpvo5ORleeklzLtq0gVtvzU3uPHxYz8vO1toXxVB1xQo61qxp\nNU+MMaYU2chFOfHYxIm6dbnf8uW5CZigb+znnFPyUQu/+HjIySn48VGjtPbFK69ocHPuuTpFM2iQ\nTqUcOwZduoR9y6orVnDl+vXMnD07Ak/AGGNMcdnIRTng8XjYkJ6eN3DYvVunK/xycrTyZgTrTBBO\n9dfkZLjnHj2/enXN+xg8GK64gsbz51N30qTCczBSU6k7aRLdUlNZNHs2FStazGyMMaUp6r+FReT3\nwEigEbARuN85t6aA8ysDjwK3+a75BXjCOTc92n09W705axY7gytfZmXlDSRiYjQYiGCdiXy3LQ+W\nnAxr1sChQ3pd7drwzjvsyMxk1E038c2iRaxLS2Nn27bkNG16Mn8jJj2dRitX0iYhgcdGjbKpEGOM\nOUNENbgQkX7A88A9wGpgBLBARC5wzu3N57LZQH3gTuAnoDE2wlIi323dSs6vfpX3YLVqeQOJ6tW1\nQmZaWkTqTJCWdmp9i4IMHKj7i/Tvr8tRzz8ftm3j6TfegEOH6NimDX9u3JjNW7ey/8ABatesScuE\nBO7417+Ii4sreX+NMcZETLRHLkYAU5xzbwCIyBDgJuAu4O/BJ4vI/wJtgfOcc/t9h1Oj3Meznsfr\nPXW6o0GDvAWr7rtPpyfee6/4NS4Cvfce/OEP4Z+fkKAJpYsWaTJoQkKeFSZL33uPpY89Ru0TJxhw\n110aWPTrZ4GFMcacgaI2IiAilYAkYLH/mNMtWBcBV+dzWXdgLfCgiGwXkc0i8qyIVI1WP8uDuNjY\nU6c72rfXZEq/Fi00B2PfvojUmcDj0QqdRdG7twY9ycmhV5g8+yz7L72Ul6dNY/i4cVzSpw/dBw8m\nJSWlZP01xhgTUdGcbqgHxAC7go7vQnMpQjkPHbm4GOgJDAf6AC9FqY/lwoWJicSkp+c9GBuru5AG\nBhKdO2vVzH/+s2Q3fPttuPzyol8XHw8ZGaEf83ph40Zo3BhatgSvl/SUFD5cv57rn36aPnffTXZ2\ndsn6bYwxJiLOtLT6CsAJYKBz7iCAiPwBmC0iQ51zR/O7cMSIEdSqVSvPsQEDBjBgwIBo9rdMuKNf\nP/7epw/p/u3N/Xr0yFuwavBgWLgQ1q2DJUuKNz2yeDFs2ADvvFP0a6tXP7Ww1ubNWuwrM1NHMNq2\n1Y3RDh+Gbdtg7lwyVq7kXxkZtExJYfPatbZaxBhjQpg5cyYzZ87McywzMzMq94rmb+G9QA7QMOh4\nQ2DnqacDsANI9wcWPpsAAZqhCZ4hjR8/3lYL5CMuLo7WTZuSnpaWdzlqy5aaPLl8eW4J8FdfhRtv\n1M3HnMtbC6Mw/poV06YVr6OHD0OVKvrvnByYMEHLk/fvn/+W75076+jLm2/y88aNVKpdm45XXMGS\nJUuK1wdjjDlLhfqDe926dSQlJUX8XlGbFnHOHQdSgJPvTiIivq//m89lnwFNRCQw+7AlOpqxPUpd\nLRceHz6cuvPnn/rA8OGwbJl+gK4i+fe/tQ7GlCnw9NNh1Zng6ac1MJk2TYtxFUdampYNz8mBv/4V\nkpJ0VCWcLd8fekh3cm3YkKWbNyMNGnDR5ZczcfJkPB5P8fpjjDGmWMSFU+iouI2L3ApMB4aQuxS1\nD3Chc26PiDwFNHHODfadXwP4FvgCeAxdkvoqsNQ5NySfe7QBUlJSUmzkohB97r6bjxITc0uA+wWO\nEvTqlftmPmOGbi7WqJG+6ffurY/5V3GkpemqEI9HcyxGjChZB++/H8aM0ZyNpKTc0ZSiWLYMPv5Y\nl8FWraorYoB2F13EuEceiUqEXhQej4c3Z83iu61b8Xi9xMXGcmFioq18McaUioCRiyTn3LpItRvV\nyWnn3LsiUg94Ap0O2QB0dc7t8Z3SCIgPOP+QiHQB/gGsAfYBs4BHotnP8uKdKVPo3Lcvq5zjSLt2\nuQ/ExOiy0c2bYdYsDRaSk+Hqq/XzkiXw+us6QlGjBlSooFMmhw7p3iHZ2dCnT8k6l5oKx49rbkXg\nTq1F1aEDfPkl1K2roy+33AKvv86KNWv4n27dOL9xYzatXn3a8zJSUlJ4dMIENqSnazGwX/0qTzGw\nv/fpw2XNmvHYsGGlHgAZY0xJRXXk4nSwkYuiyc7Opv+997LM69W9RkJNOXi9mofx889U+P578Hg4\nceCABhFVq+rUSZMmcNllWnjrpptgwYIS7WTKM8/oaMX69fnnWIQrNRXefVf/XaeOjrB8/70GLVlZ\ncPw4Dw0dypNPPln8e4QprNfbLy2NuvPn0yE2lnemTLHEVGNM1EVr5MIqX5YzFStWZM60aSx48EG6\nL1pE0yeeIGbpUn3z3b4dvv+emLVrabpuHd1r1mTNG2+Qk56O83pxWVn886WXYMcO2LIFvvgCfvxR\nryvBTqYsXgxbt8KVV+bdqbW4srJg0ybYs0c3Q7v5ZrjhBmjdWpNYa9fmb6++itSsSdeuXUt2rwJk\nZ2eT3KcPHyUmsm/o0LByR/YNHcpH555L5759bWmtMabMspGLcs6fA7A5NTVvWe1CcgA8Hg9NmjTh\nSGwsVK6sy1j/+1+dzghe8lqQxYvhrbc0efSTT3TapWPH4j2Z4NyRw4fzLmNt1iw3X2T7dnj/fZ06\nycqiFrBly5aI5j3km+MShqorVtAtNZXZU6dGrD/GGBOsTOZcmDNfXFwcw4aEzJUt9LqsrCwAbr75\nZuZNngyXXgqffqo5D4GJoaGkpsLMmTpiMWWKBii7d2sdi+LwrzDp2BGuuy68ZawdO+qUyYwZZH71\nFXWaN6eyc/zn/ffpWNwAx2ft2rUs83qLFVgAHGnXjqWTJpGSkmI5GMaYMseCC1NiH3zwAQC33nor\ns5cv19GB7dt1V9SuXfOOGKSm6gqTzEy480548MHchoJ3ai2KCRNyAwt/kBFOUmh8vG6YtnAhvPsu\nx+Li6PS738G+fSycOZPOnTsXqzuPTZyoORYlsK9bNx6fOJF5M2aUqB1jjDndLLgwEfOuL4ly8ODB\nvDF/vhbEmjw5tzBW5cpaA2PECJ2SaNkybwPBO7WGa/Pm3BUm48aFH1gE6tJFg6F33oEjR6BGDbrc\nfjtkZfHcX/7CH//4x7Cb8ng8bEhPL3nuSEIC69LS2L9/P7Vr1y5ZW8YYcxpZQqeJuBkzZuAyMhh7\n3326vFQEGjbUbdV//3sNIlq31mWvgfw7tRbVvHk6DRMYZBRH585w8cVajGvMGN0l9oILGDlxIlKv\nHp3CLIf+5qxZ7Czu9E6QnW3b8kZxSqkbY0wpsuDCRM2YMWNwHg8/L1/ORaA7mz7yCPzpT5r8uWtX\nbmVQOHWn1nB4vbkrTPxBRknccouugmnRQvdWefZZGDsWrr2Wpdu3I/Xrc3GbNgVW/fxu61ZymjYt\nWT98cpo2ZXNqakTaMsaY08WCCxN1zZs355u1a3EZGTwwcKBuTvbVV7oz6yef5AYYoXZqLczy5boS\nJDDIKImEBC0idjBge5v4eJ3KufVWqFGDb3fupM4ll1CjWbOQ2717vN7i544Eq16d/QcORKYtY4w5\nTSy4MKf8sqBjAAAgAElEQVTV+PHjcRkZ9GzbVkcIfvgBpk6F557ToMK/U2u4du/WhFF/kBEJycl5\nR1T8OneG22/XvJELLuBwpUr8T8+eSGwsa9euPXlaXGxs8XJHQjl8mNo1a0amLWOMOU0suDClYu7c\nubjDh/nj4MGwd6++mf/5z/DCC5CeDkuXhteQf4WJP8iIhGbNtABXKJ07Q6tWcM01MGiQntu4MZd3\n6YLUqMFDDz3EhYmJxKSnR6QrMenptExIiEhbxhhzulhwYUrVc889hztyhAd++1tdpZGeromZ/qJa\nhfGvMCnJMtZg/mWz+bnlFtiwQVelPPWU5pFcey3ExvLU1KkMHzGCWvPmRaQrjVauZFD//hFpyxhj\nThcLLswZYfz48TiPh/UrVlDh6FHNeZg6FZ58suAcDP8Kk+IuYw3l8OGCA5XgvIz4eBg5En77W50y\nufpqMrZv1z1XNm8ufj9SU2kTH2/LUI0xZY7VuTBnlNatW5Pjq/x50UUXsenTTzX5s0ED6Nnz1BLe\nK1fqiEeXLvp1ixYl78T27VC/fsHn+PMyunXLe+zECfjXv+CCC2DbNhg9WneQTU6G++4rUjfqfvgh\nj40aVfT+G2NMKbPgwpyxvv32WwBuuOEG/rNokU6ZxMbqSEGdOhoA9O+vha/OP1/3KClh2W5Al8OO\nHl3wOc2awWefnXq8SxdYu1bLmDdsqAHGe+/p0tsFC7T/bdvqc2jfXr8OoeqKFXSsWdP2yzHGlEkW\nXJgz3scffwzAihUraN+lC+zfrxucVaumu7PWqwf//nfuMtaSbtceF6fTGwUpKC/jttvg7bdh1Cgd\nSencWfs1a5bmaixZolMq//qXFu3q3j1PtdKqK1Zw5fr1zJw9u/jPwxhjSpHlXJgyo127drijR3H7\n99M9KUlXiGzcCF9/DatW6UhBUZaxhvL++7octjAF5WUkJOhqk+BaGSNHwv/9nwYc116rSajLl+ve\nJuPGwZYt1J00iW6pqSyaPZuKFS32N8aUTRZcmDJp3rx5uAMHuKVDB9i5U3dF/egjnTpZvrx4jS5b\npu1ccEHh5xaWl3HDDaFrZSQlQc2aGhA5p9MilSrptMnvf8+rAwYwe+pUCyyMMWWa/QYzZdqcOXMA\nWLJkCcmdO0N2NsyYoYmVRcm/WLYsdxQhHIXlZSQk5M3J2LwZ3nxTczAqVtSRjBtu0M/+KZZt2+j9\n0ENwzz2MfeABxowZE37/jTHmDGLBhTkrdOrUCXfiBCkpKSR37Urmyy/raMCgQQXnYKSm6lRITo4G\nFjExhd8snLwMf8CQkwPjx8OPP+oGbm3aQJ8+ofsUkJ/x8IwZPPz889zRrRtvvPFG4X0yxpgziAUX\n5qySlJTE/r172bNnDw0aN4Yvv9SEz169dDQhcBnr4sUaJPToEd5UiF84eRmHD2vC6RNP6J4n1arp\nUtpwdmyNj9dA55NPeHPaNN5s0IBrL7iATz/9NPw+GmNMKbLgwpyV6tevj8vOJiUlhauvu47jL7+c\nu4x13z5dujpqVL5LQfMVbl7G9u3wzTdQubIGFv/7v0XfCv766/Xza6/x2bZtSO3aNK5enV9++aVo\n7RhjzGlmCZ3mrJaUlMSxrCwyfvyRC2NjYd06XcmxerVOmxSFPy9j2LDCz12wQIOKqlWhceOiBxZ+\n118Pl18OgwfD/fezo3ZtpGFDYipWZMuWLcVr0xhjosyCC1MuxMXFsemrr3CHDnFXjx6QkQGvvAJj\nxxa+xXtqKkycCOvXh5eXkZqqUyGVK2ueRa9eJet8375aHyM5GSZNguee40SnTpx31VWICJe1a8fQ\nUaOYOHkyHo+nZPcyxpgIsGkRU+5MmzaNadOmMWTIEKbMmKG1MurVg9694dxzS56X8d57uiLk8OHc\nlSElkZCgwdDBg5pEGh8PDz2kG7u9/jobvvuODRs2QIsW/H32bC5r1ozHhg0jKSmpZPc1xphiEudc\nafehRESkDZCSkpJipZJNsbz99tvcdvfdOtJwzjm6jPWii+Cyywos0R3S0qVaLbRxY/36sssiU5J8\n0SLdQyVwLxP//Vau1C3g33tPt6/PyqLuDTfQITaWd6ZMsZoZxph8rVu3zv+HSJJzbl2k2rVpEVPu\nDRw4EJeVRcbWrTSrXFlrZXz9NVSpUvTAYsUKLeUtoh/NmkWmk/6qn8E6doTatXU0Y9IkeP55uPJK\n9i1cyL/mzKFz375kZ2dHpg/GGBMmCy6M8YmLiyNtyxbcnj20b9UKJk8uWk7Ghg2ak3H0qAYo2dkF\nb91eFAXtZdKzJ8yfr//2L2P93e+gShWWL1hA9cL2STHGmAiL+nipiPweGAk0AjYC9zvn1oRx3bXA\nMuAr55zNd5jTapmvdPd1113HZ3/8I9StG35ORrVqcOyY/ju/gKCoCtvLxOPJzcmAPMtYj1eogNSr\nR0xWFj98/TXNmzePTJ+MMSYfUQ0uRKQf8DxwD7AaGAEsEJELnHN7C7iuFjADWAQ0jGYfjSmIv3DV\n0KFDeXniRN2NtWpV3Q+kVavQtTIaNNCdW0EDkBYtSt6R1NSC9zJJTtalsoE5Gddfr0XErroKGjYk\nZ9s2zrvpJtizh6G33spLL71U8n4ZY0wI0Z4WGQFMcc694Zz7DhgCHAbuKuS6ycA/gS+i3D9jwjJp\n0iSc18vA5GTYtUtXb6xZA1+E+BFt3153bN29W0c2ImHJEujQIf/HmzULnZNx663aR39p8UmTYNw4\nJm3ejDRoQKtWrSLTP2OMCRC14EJEKgFJwMnfrk6XpiwCri7gujuB5sDj0eqbMcX1z3/+E5eVxfK5\nc3V0YsqUU/MyYmN1GqV6dV2BUljORmFSU6FOnfD2MgkWuIzVz5+XcffdfJeZidSuTcVq1awolzEm\nYqI5clEPiAF2BR3fheZfnEJEWgB/A25zzp2IYt+MKZF27drhsrJwe/fS7vhx+OMfNYly0SL4/nud\nisjO1m3V584t2c3mzAlvL5P8cjI6dcq7/bvXCx9+qNvTn3ceVKtGTtWqnPfrXyPnnMO4ceNK1l9j\nTLl3xqwWEZEK6FTIo865n/yHS7FLxoRl+fLluN27ubllS3jxRXj0UXjtNdixQ9/0d+zQsuHFsXCh\nLmkNZy+T/HIy/MtYN2+GZ5+FZ57R3JE2beDCC+GKK+DXv9brq1blj3/5C1KnDsOHDy9en40x5V7U\nimj5pkUOA7c45+YFHJ8O1HLO9Qo6vxbgAbLJDSoq+P6dDVzvnFsW4j5tgJR27dpRq1atPI8NGDCA\nAQMGROopGROWQYMG8eY77+j0SKVKmuAZEwM331xw3kSwhQvhs8/gkUcKLzk+ZgyMHh166mTbNvj7\n37X+Rq9eGvDMm6clypOTNV8jcAXM++9rvsjhw1ChAle2bMkXoXJLjDFlysyZM5k5c2aeY5mZmaxY\nsQIiXEQrqhU6ReQLYJVzbrjvawFSgYnOuWeDzhUgOLvs90BH4BZgq3MuK8Q9rEKnOSM9/vjjPDZ2\nLNSsqctVK1XSEYg+fQouCZ6aCm+/rec/8EB4e5m8+y6MHHnqYzk5Wir8+us1sJkwQUuS9+pVcB/S\n0mDGDPjqK71/Vha/qluXH3/8MaznbowpG6JVoTPawcWtwHR0lYh/KWof4ELn3B4ReQpo4pwbnM/1\njwI3F1TnwoILc6abN28evW69lRP+BM9q1TTh84Yb9A3eP2qQmqojCnXqwMCB4e9lMnGibuke6vxx\n46B1a13B8te/akXPouzQunChrnhJTtYRjYwMzjl4EK/XG34bxpgzVrSCi6jWuXDOvSsi9YAn0HoV\nG4Cuzjn/mrlGQAl3dTLmzNajRw9yjhzB4/GQmJjIgawsTaqcMkUDi5wcDSjatoUnnyxayfFly/T6\nUIHF5s06StGpkwYZRQ0sALp00ZGLjRvhpZcgLY2Db72FNGgA+/bx4bx53HTTTUVr0xhz1ot6Qqdz\nbpJzLtE5V805d7Vzbm3AY3c65zoVcO3jVp3TnC3i4uLIzMzEZWaSlJioVTyd071Bdu/W6ZOiBhbL\nl8OwYaEfnzdPpz/8QUZRAwu/Tp00wFi/XoOMhg01f6NBA7oNGoTUrMk111xTvLaNMWcl2y7RmFKw\ndq3G2G3btuXTH37QAOPtt7Uw16BBhedkvP++jlg8/HDonAyvVxM24+N1hUj//iXrcM+e8MQTcNtt\nOsLStatO5WzbBgsW8Pn27UhcHI2qVmXHjh0lu5cxpsyz4MKYUrRy5UoAXnjhBUaMGQP79umOrPXr\na22LhITC9zIJZflyHXEIDDJKIiFBRywuvzzvihR/5c+0NHjrLXZ+8w1SqxYVDh4kJycHAI/Hw5uz\nZvHd1q14vF7iYmO5MDGRO/r1Iy4urmT9MsackaKa0Hk6WEKnOZt4PB4SmzfnwMGDUKuWbvtetaoW\nu/InZoYzdfL445oUunmz1rTo2LHknVuyRIOcwP1Lgn3yCUybpjvDZmZSoW5dGl96KTvbtiWnadOT\ngVJMejqNVq7ksmbNeGzYMH9CmTHmNCuTCZ3GmKKJi4sj07fpWc2aNfEeOwbHj+v0Q40acOmlBQcX\n/mWse/boG/nu3TqNEQnNmmndjYJcf71O00yfDjVqcCIri/TNm+H//g8aNz55Wk6LFqR36EB6Whqf\nP/MMHWJjeWfKFCpWtF9JxpwN7H+yMWeoAwcOAHDllVeyetMm3VZ9wwadMilsGeunn+rxrKz8y4IX\nVX77lwRLToZ16+DAAQ2Kjh+HESM0R6R2bc3d8Aca8fHsGzqUj1asoHPfviyaPdsCDGPOAva/2Jgz\n3KpVqwC48MIL2bxtm+ZRTJ6stTKOHdM37YsvzruM9fvvNUejWrXwAoJwFLR/SbB+/eCxx+DOO/NW\nAN22TYOL/fs1yfTmmwE40q4dq4ABQ4Ywe+rUyPTXGFNqzpi9RYwxBfvuu+9wWVn0aNsWjhyBvXsh\nMRGaNNH9S1JSck9u316TPxs00CAjEgravyRYQoKOTlx+uSZ9Nm2am/z58stajvzrrzXA8G2qdqRd\nO5YeOEBK4PMwxpRJFlwYU8Z88MEHOK+X9YsWUeHzz+GnnzS3YuZMGD9eV27ExmpC6Pnna5ARCYsX\nF21vlOTkvLuxBoqP1/1Q7r0X3ngDeveGESPY17Ejj0+cGIneGmNKkU2LGFNGtW7dmpws3W7nuuuu\n47ONGyEjIzcvo3Vr+Pe/NchISyvZctTUVF0CG2pjtPyEkwDasaPu+vrxx3qPxx5jvtfL/+7axX/+\n85/i99cYU6ps5MKYs8Cnn36K83r58113wcGDcOgQ/Oc/sHq11qeYO7dkN3j/fa2tURThJoB26KDT\nJjfdpCti4uNZsGYN0rAhjQNWmBhjyg4LLow5izzzzDO4fft49u67daVIhQoaZKSna2Gt4iho/5KC\nFCUBtGdP2LlTR1tuuw2uvhoqVGDnhRci9eujmyYbY8oKCy6MOQuNHDkSt28fH0yeDLt2wc8/6xbq\nS5cWraHC9i8pSFETQD0e3Sht+XLIztZlq5s3a4BSqxZSvboFGcaUEZZzYcxZrEePHricHDweD3Xq\n1NGVGp9/DnfcUfL9SwqzeDGMHh3++Z06wSuvaF2M3r3hlltyp1bS0uC99yAjAznnHDh0iJ9//pnm\nzZsXvV/GmKiz4MKYciAuLg5/qf9atWpxYONGLbh1yy2n7l/y/vs64tCvX9GnQvyKkwAaH69lzu+/\nP+/xHTs0MfToUahcWdutXp3zLr0UjhzhD/ffz/PPP1+8fhpjosKCC2PKmczMTAASEhJIe+klrUfh\nnO5h0qYN/L//pxU+ixtYQPETQCsEzNR+8omWMndO63UMGJC3Kum2bfDee4x76y3GvfoqLRo14vvv\nvy9+n40xEWPBhTHlVGpqKgDt2rVj5Xff6Zv2V19pcSsRzc8ozoZnJU0APXYsd/Ti0kuhT5/QUziB\nO7LOmMEPGzeenDIp6xsyGlPWWXBhTDm3YsUKAF599VXueeABHcEA2LpV3+i7dg2/MX8C6MMPF70j\n27frlMc992gyZ69eWmm0MPHxer+FC+Gjj+DIEaRBA9izh4yMDNvW3ZhSYKtFjDEA/Pa3v8UdOkTG\njz9S4/hx3f9j6lQYO1ZHBwqSmgoTJ8L69SVLAP34Y2jUKPzAIlCXLloro2VLeP55SE6mTosWiAgv\nvPBC0ftjjCk2G7kwxuQRFxfHQd+OrAMGDOCdd9/V6ZL69fVNPzDvIZIJoEeO6GZsjRoVPbDw69IF\nvvxS8zWaNNE2f/yREY88woiHHqJW5crs921pb4yJHgsujDH5mjlzJjNnzuSqq65i1bff6kjGRRfp\nSpOjR3UlR6QSQDMzdeVKr14l63TfvjBpEtx9t07pBCR/Zno8SLVqcOSI5WUYE0U2LWKMKdQXX3yB\nO3CAu268ETZu1CmTvn11pYnXq0WvSlIB1OvVZabHjpVsDxTQAKVCBe1b4G6skybpbqzt2kHDhkhc\nnBXlMiZKLLgwxoRt2rRpuL17GVC/PjzwAHz/ve5b8pvfaJCQ3y6o+Vm6VIOSChV0B9fk5Mh0tFOn\n0H2Jj9fCXr/9LdSsCeefj9SujYjg8Xgic29jjAUXxpiie/vtt3H79rH8lVfg22+1smaFCjo9MnFi\neAmg48bpDq4PP6ylv0V0J9VISEiAPXtCP+b16r4rLVpAxYp6bp061ElMRKpU4b777otMH4wpxyzn\nwhhTbO3atcMdOwagUwwNG2qyZ3q6ntC1qwYM/gTQ1FRdMnriBFx2GQwcqOcdPapTK+FudFaYUDuy\nbt4M8+ZpbkdysiagBhXkYv9+Xpoxg5fefJN6lSuzJ78AxRhTIAsujDER4U+QbNCgAXv27YNKlXQv\nkypVtG5FQoKu4OjfH375RZed+oOLKlV0FCGcLdrDEbgja04OTJig7ffvX3hBrlmzYONG9mZnI9Wq\nUU2Ew5HqlzHlhE2LGGMiavfu3bjMTIb07aujBIcO6XbqR47o1xs2aEnvY8dyp0/q1NFj27dHphOp\nqbo8NicH/vpXSErSnV0LSxaNj4eRI3WlSfPmcO21ZNWocXJHVsvLMCY8FlwYY6Li5Zdfxh07xgcz\nZsC+fbrKxOPREYJu3bSs99tv68mDB8OPP2ohrUhYsgQ6dNARi44di143o0MHuP56qFFDK4bWrAl1\n61LnvPMQEV599dXI9NOYs5QFF8aYqOrRowfOOTL8wcMf/gBDhmgC5w8/aCDQuLHmYVSuXHgyaGFS\nU3UkJD1dp0KKW5CrQwetNJqQAPfeqyMhLVvChRdyz5gxiAhdi1Ia3ZhyJOrBhYj8XkS2iEiWiHwh\nIpcXcG4vEflERHaLSKaI/FdEro92H40x0eff9t3t2UNCVhb84x9aL2PKFA06evfWqZO5c0t2ozlz\ndEfWefNKXpCrZ0+YP19HP1q10uWyXq/mjiQm8smGDUiNGtSqVatk9zHmLBPV4EJE+gHPA48ClwEb\ngQUiUi+fS9oBnwA3AG2ApcB8Ebk0mv00xpxe27Ztwx04QOPKlSEjQwOMdet0+egvvxS/INfChToi\n0rix5ndEoiCXxwMHD2qg8cUXcNddWpU0ORmuugratOFA7dpInTpWlMsYn2ivFhkBTHHOvQEgIkOA\nm4C7gL8Hn+ycGxF0aIyI3Ax0RwMTY8xZ5JdffsHj8dC4TRuOLlsGtWrBgQM6euGcTk2Ea+FC+Owz\neOQRXYkSqYJcyclakKtbN83BWLVKk1STk+HKK/PuszJ3LtKoEezaZeXFTbkWteBCRCoBScDf/Mec\nc05EFgFXh9mGALFARlQ6aYwpdXFxcXRu25aPunTRHImhQ/WN+u23dZfVPn0KHoFITdVzK1XSwCIm\nBnbvhrZtI9PBZs20ONi4cdqPfv3yX87asaPmjMyYcXLb959//pnmzZtHpi/GlBHRHLmoB8QAu4KO\n7wJahtnGn4AawLsR7Jcx5gzz+PDhfPHMM+wbOjQ352LsWH1TX78eGjSAG27IuyNraip88IHupDpw\nYN6N07KyIluQa/VqGDAgvOTQ+HitOvrJJ/Daa5x36aVw5AhtLrmElJSUyPTJmDPcGVtES0QGAo8A\nPZxze0u7P8aY6ElKSqJDbCwfrVzJEf+Iw8MP6+cHH4TvvtPRjJgYXVHSsCGce65+jBx5aoPVqkW2\nIFezZkVbdeL1ah2Piy/WJbY5OaxLS0Nq1gSv16ZMzFkvmsHFXiAHaBh0vCGws6ALRaQ/8ArQxzm3\nNJybjRgx4pSM7QEDBjBgwICwO2yMKT3vTJlC5759WeUcR9q1y33gmWf08+jR+kZdqZIW5crO1mmU\npUt1OiJQgwYajLRoUfKOpaZC69bhnRtcYrx//7wlxt9/HzIykNhYOHjQggxzWs2cOZOZM2fmOZaZ\nmRmVe0k0f7hF5AtglXNuuO9rAVKBic65Z/O5ZgAwFejnnPswjHu0AVJSUlJo06ZN5DpvjDntsrOz\n6X/vvSzzetnXvXvo3IZ583T79HPOgUaNdITg1lu1OJef16tBydixJe/UqFE6inLOOfmfE1hivFev\ngnNE0tLgzTe1Uun+/XD8uAUZptSsW7eOpKQkgCTn3LpItRvtOhfjgN+KyCARuRCYDFQHpgOIyFMi\nMsN/sm8qZAbwR2CNiDT0fdSMcj+NMWeAihUrMmfaNBY8+CDdFy2i6RNPELN0qW7tvn07fP89MbGx\nNL3mGtpddx18840uZZ0+HZ57LrcAV2ysrjyJREGuevUKDyyKWmL8oYfgd7/T6ZZ69ZC6dRER/vzn\nP5esv8acIaI6cgEgIkOBP6PTIRuA+51za32PvQ6c65zr5Pt6KVrrItgM59xd+bRvIxfGnKU8Hg9v\nzprF5tRU9h84QO2aNWmZkMAd/foRFxd38jwR0emHWrX0o08frfj59dcwIniFexE895wW5ApMFg02\nbpwGFsWpBLp4McycmZsfcuSI1tSw0QxzmkRr5CLqCZ3OuUnApHweuzPo646hzjPGlE9xcXEMGzKk\n0PP8b8Qiom/UkybplEl2tr6BF6fmxaJF2lZBgcXmzSUrMZ6cDF9+CZdfrkmqaWlao2PXLsRX88OC\nDFMWnbGrRYwxpqjyBBler45ivPaaPliUAGPZMnj33dwVK/mZN0+TNkvillv0XiNHagJqp04aZMyZ\nA99+i8TFwf79FmSYMsU2LjPGnHWcc7hjx/hNkyZaTvzll+HJJwvPwUhNhYkTtbbGFVfA0aP5n+v1\nRr7EuF98vE7n3HabLretXx+Ji7Py4qbMsJELY8xZa+NG3TVgw4YNXHbZZToFUaeOjhYkJOQt3b14\nMcTF5eZYvPGGBhv5LWddvjw6JcYDdeigCaPvvKP9rFHj5HTJn/70J/7+91N2UTDmjGDBhTHmrNe6\ndeu8UybPPw+1a+teIeeeC02bwqBBuunZ9u3w4ov6+Lff5h9ARLrE+GefhX4sOC8jNRXmzOHZ6dN5\ndsIEOHbMpkzMGceCC2NMuZInyKhVC6pW1UBi0SIdyahfX3c9/fRTnRZJSws99RHpEuMFVRQNzstI\nTtZ+vfEGbNyI1KgBhw9bkGHOGJZzYYwpl5xzuP37qfrTT7BiBXz1lY4gXHCBVvj0eKBJk9y9ToJF\nusR4QYFKfnkZY8ZovYyGDTUv45xzLC/DnBFs5MIYU65lZWUBcOONN/Lx+PE6VVKpkgYZq1bpm/7y\n5acuN41kifHt23XEpCD55WV07KjTOR9/DOnpUKWKlRc3pc5GLowxBvj3v/+NO3yYn1evhh07NM+h\nXj0NLt56SxM+A7Vvf+qx4lq8WJM3C9KsGezZE/qxDh00b+T66zXYiY+HBg2QKlUQEc6/8EI8Hk9k\n+mpMGCy4MMaYAM2bN9cpk4wM3RTtm2/g+HHdDyRwOWskS4zHxRVcYhwKz8vo2VNHLo4fh/PP16qh\n558PcXH8tHUrderUQURs23dzWti0iDHG5CNP8mfNmrB6tZYUb9oUbrxRd0udM6dkJcbff1+Xvxam\noLwM/26sv/ySu3GaPxjxF+TyeODwYf7nmmvg2DGOHz9OxYr2FmCiw36yjDGmEHmCjAoVdMv3uXM1\nL+PHH4tfYnzZMq1jUVCJcb9QeRmBu7H27x96VUtg1c9//lMDkSpVqNS4Mezda3kZJipsWsQYY8Lk\nnMN5PFzZrBls3Qr//a++wc+fDwsXFq2xZcs0UXTYsPDOD87LKM5urKNGwcCBWl20TRu4+OKTO7Ja\nToaJJBu5MMaYIvriiy8A2LJlC+e1aKH5ElOn6uqSwYMLfqNPTdWpkJwc3bskJqbwG4bKy5gwQVeK\nFHXTtC5d9J5ffAHDh5+cNqlz4YWwezdJSUmsXbu2aG0aE8SCC2OMKabmzZvjsrMB35TJypWak9Gg\ngSZYNmtWcInxcAXnZZR0N9ZOnbSfJ07ov/3TJjNmkLJuHVKlilX+NCViwYUxxkRAnryM/ft1s7Qa\nNXQUY98+XbkxapSuMimKUHkZkdiNtWdPrfrZsqV+HR+vIymffALTpoHXi1SuDMePW5BhisxyLowx\nJoKcc7gjR2DvXsjI0P1JnNOVJp9/XrTGQuVlRHM3VoCrr9YdYePitM5HvXpI1apW+dMUiY1cGGNM\nFPj/2m/dujUbv/lGa2JMnQopKXD77cXPy4jWbqz+5ayZmXq8R4/cKZ1t2+C995D69WHvXtuR1RRK\nyvpwl4i0AVJSUlJo06ZNaXfHGGNC2rJlC+edd55Oi9Srp1MmN99c+NbvwV57TXdjjUTZ8e+/1w3a\n9u/XHA5/jYz8+PIy2LBBp3rApkzKuHXr1pGUlASQ5JxbF6l2beTCGGNOA3/lT/DlZdSpA6+/rvuC\nxMbqLquXXFJ4Xkakd2NdvRoGDAgvOdSfl7F4sfb92DFL/jQhWXBhjDGnWZ4go0YNOHYMfv1rHQ1I\nSSl4n5FI78barFnRV50kJ+tUzWefaT7Jpk1InTrg8ViQYQALLowxptTkCTJWrdJAIzUV1q6Ffv1C\nT4xxuRAAACAASURBVFFEcjfW1FQtYV4cHTro9EhsrOaGbN4MjRohNWuC12tBRjlnwYUxxpQy/xvx\nrbfeyuw5c+DAAVi3TnMvevXKm5chAu+9pwW0SmrRIp3mKK7evWHSJLj77rzJn//6F9KgAezZQ8eO\nHVmyZEnJ+2rKFAsujDHmDPHuu+8CAcmfhw7Bq6/q6EDjxpqnUb9+7m6sJVmOmpqqiaWF7cZakIQE\nnR5p3Di3nRYtoHPnk8mfS9evRypWhJwcG80oR6zOhTHGnGFObvuemQm7d+tW6ps2wZo1urrj8GF4\n552S3eTdd8PbjbUw/uWswfzJn0OGnAyKpHZtq5dRTlhwYYwxZzDnHC4rS5M99+7Vjzp14OhRrXlR\nHIsWaYBSlBLk+WnWDPbsyf/xLl3g3nt1N9m4OIiPR845x4KMs5xNixhjTBmQJ/lzyRKd0vjuO8jO\nLlpRrWXLdNSiJLkWgfy5FgVJTtbkz927dUrn66+hYkWkRg04fNimS85CNnJhjDFliHMOd+IEv+3Z\nU6dLJk+Gv/1NcxwKkpoKEyfC+vVa3vvo0ch06PDh8Opu9O2rpctvuQXuuktHX+rVg4YNkRo1EBHO\nP//8yPTJlDobuTDGmDLolVde4ZVXXgF8oxkbN+qbde/emu9QUNXPDz+M3HLW7ds1ybQwCQlQs6au\ndBk9WoObBQugeXPdgyU1lZ88npPTJTaaUbZFPbgQkd8DI4FGwEbgfufcmgLO7wA8D1wMpAJPOudm\nRLufxhhTVuWZMtm2TetlxMRogaukpFOrfrZvD888E5nlrIsXa7AQjuuvhzffhKee0pUwocqfz50L\nu3ZZkFHGRTW4EJF+aKBwD7AaGAEsEJELnHN7Q5yfCHwITAIGAp2BqSLyi3NuYTT7aowxZV2eIKN2\nbQ0wVq3SUYJBg3KXrsbGRm45a1xc+MtZmzXTe+e3cVujRhp0/Pyzro7JyECqV4esLAsyyphoj1yM\nAKY4594AEJEhwE3AXUCoLfV+B/zsnPuz7+vNInKdrx0LLowxJgyn7GGyZo2+WTdqBDfeqG/yV10F\ns2fDH/5Q/Bu9/37RlrNWrw4tW54aWATvyHrDDZqbEbgjq68olwUZZUPUggsRqQQkAX/zH3POORFZ\nBFydz2VXAYuCji0Axkelk8YYcxbzvxG3bduWTz//HI4c0WmHCy7QHVGPHNFpjeJs4b5smZb9Lspy\n1uDkz5wcmDBBd2Tt3z/0aEZgUa433kDq1YN9+4iLiyMjI6Po/TanRTRHLuoBMcCuoOO7gJb5XNMo\nn/NrikgV51yE0puNMab8WLly5cl/i4jWpahfX3MzPvwQTpzQehThWrZMa2wUdTlrYPJnTg789a+a\n9xHujqxjxsDChTB1Kp4TJ5CqVeHoURvNOAOdNatFRowYQa1atfIcGzBgAAMGDCilHhljzJknz5RJ\nXBxUrqx1L1avzpuXEUpqqk6F5ORoYBETU7SbByZ/TpgQfmDh5/Vq/shFF+lUSpMmcPCg7cgappkz\nZzJz5sw8xzIzM6Nyr2gGF3uBHKBh0PGGwM58rtmZz/kHChu1GD9+PG3atClOP40xptzJE2Ts368V\nQL/+WnM0gpezpqZqVc969XKXsxZVYPLn5s06FRJuYBGckzFwoK6E+ewznS75+WeoUgWJjYWDBy3I\nyEeoP7jXrVtHUlJSxO8VteDCOXdcRFKAZGAegOjaomRgYj6XfQ7cEHTset9xY4wxEZaRkcElffqQ\n3rEjPPKI5mG89ppOXzRtqgGFc/p55Mji3ygw+XPePM2xKEyonIzNm7Utf6Bx3XV5g6A5c5D69WHv\nXjIyMoiLiyt+n02xRXtaZBww3Rdk+JeiVgemA4jIU0AT59xg3/mTgd+LyDPAa2gg0ge4Mcr9NMaY\ncunNWbPY2batvkkvXapTDz166Jt1RgY0aKCrN9LS9PHi1MYITP70ejUwKGwJbHBORk4OjBtXePJn\ncvLJ5M86LVue3PfERjNOr6gGF865d0WkHvAEOr2xAejqnPPvctMIiA84f6uI3ISuDhkGbAfuds4F\nryAxxhgTAd9t3UrOr36VeyA2VoMI0Df2/fvhl1806dO/l0lRkj+XLoUVK3KTP5cvD291SmBORnGT\nP5cu1aJdBw4gMTFw4oQFGadJ1BM6nXOT0KJYoR67M8SxFegSVmOMMVHm8Xrz3xvEH2R07aorSypU\ngNdf11Lj/foVnvz5zjs6zRKY/Ll7N7RtW3CngnMyipP8CXqNCPznP7oPS3Y2UqsWHDhgQUaUnTWr\nRYwxxhRdXGxs4buaLlignzt31iDhs8+0TkadOlrSu1mz0HuZVKwI116bd1VJVlbhG50F5mQUNfkz\nWIcO8OWX8JvfwJYteuy775C4ONi/3/IyosR2RTXGmHLswsREYtLTwzt50SINNM47T1do/PADTJ8O\ns2bBW2/pY1u3wjXXgMejy0YXBhVXrlat4GAmOCdj3jzo1as4Ty1Xz546tRMbC336wB13QJUqUKsW\ndZo1Q0RISUkp2T1MHhZcGGNMOXZHv340CiiyFZbnn9dA48UXNXly3Tr9fOSITkM4p5uljR4Ndevm\n3Q6+QQMd3chPYE5GuMmfhUlI0GCnSxeYP19HW+65B1q10kCpSRP+p2NHJCYGEWHi5Ml4PJ6S3bOc\ns+DCGGPKsbi4OFo3bZo3AAhX48aalzF3Lnz7rRbiWr0aqlaFHTs0iGjdWkc2/Nq312mT/OzerdMs\nEH7yZziSk+GnnzTIOHgQOnXSwOeyy+DKK3XZbf36EBfH8D/9iTp16tB98GAb0SgmCy6MMaace3z4\ncOrOn1+iNur27UvKggW6ouTFF2HsWHj6aZgzR9/Uly3TEwN3ZA0lMCcjMNAoqf/f3p3HV1Wd+x//\nPBmEAmEsCgYQS1GxeisEq9SKxlS9VuFaCxdDpdZ5QhSvrbTYW1S4/rD+sHGqOOFQSRGpCOhPZKy0\nRq2JQ9VA7XVISEVRQoggNSTr98c6Bw4hwzkne+ck5Pt+vc4Lss/e+6yV6TxZ61nPGjDAL0vNy/PB\nzm9+4wuHHXIIjB7tc0OOOw6+9S1f06NvX5YtXszIkSMZd9FF7Nq1K5h2dBBK6BQR6eBycnI4OSuL\nZ9etY2dzKzka0PnFF8nt3p0RI0bsu+17167+pN//3k+X5Ob6OhpPPw1Tpux7s9icjHiSP+PVpYvf\nzn3dOv8a+fn+dWIrfx533N6JqYsXw5YtLFq0iMyHH6ampoaMDL1txkOfJRER4Q9z5/L98eN5xTl2\njh4d93WdX3yR415/ncKFC3cfe+211+gzfjyfX3mlDyYyMvxUyX33QVGRT6jctctPe9RfBRLNyRg6\ntPnkz0Ts2AHvvAP/+Z9+pCKe3Vhzc/0Iy+OPw1tvkXnggVBZSUFBAVMaCoxkN2vva33NbARQXFxc\nrL1FRERaYNeuXZx72WWsra7m8zFjmq1j0WfZMnK7d6fwvvv2+ov+rJ/8hGdPPXXv62fN8kmgPXr4\nR5cufsXG2LE+/yGquhpmz/bTKsuW+ZGPZKqC1rdypd875eqrEyvIFbVihS+LnpbmR0AiG35t2bKF\nxxcsYP2HH1JZXU2vrCyOGDyYSRMmtIslrjF7i+Q450qCuq9GLkREBICMjAyeeughiouLuenOOykp\nL2fTiSdSm529e7ogvaKCfuvWMWLQIGZMm7bPH3WVlZW8UVGxb2Ayfbp/1Nb6ehm9evn6F/Pm+STQ\nH//YXxObk3HSST7QCCK4WLrUBzjJFuSKViVds8a38c03oa6O3gce6Edh7r9/r8/RbePGMXzAAGZM\nmRLKxmBtnYILERHZS05ODksefZTKykoeX7CADR9+yNZt2+jZvTuHDxrEpEWLGv2rfPdeJY1JT/dv\n0Bs2wOWX+6mJ7dv9apPoPibHHOMTQadO3RNotGQ5almZT9KsqGhZQa5TT4XiYl9349hjfY2Pww/3\nNTQmT4avvoI1a6gdOpSKk0+morycotmzOTkriz/Mnduh8jU0LSIiIoG5cto0fjdkiM9ZiEd0ozSA\n7t39VElmph/huOgiX6Ni+fKGkz/jdeut8KMfwTPPNJ5jEa+yMpg/39fxWLECnn3WBywVFT64qK31\nUybR0unsyUtZuXBhmwswwpoW0VJUEREJTJN7lTQkulHamjWwbZt/Y66q8m/Sjz3m38yjyZ/JWLXK\n37d//+AKcm3e7GtlnHoq9OsHl1wCt90GI0b42hmDBvlgJjcXbruNnaNH88rw4eRffnnLXrsdaVsh\nlIiItGtx7VXSmOhf+zNm+GCiVy+fkzFsmB+9cM7vFRKvtWth4UK49tpgC3KdcYa/91lnwcSJfiTj\nqqvg29/2QVF5uf//Bx/AX/8Kp5/Ozq++Ys348RQXF6c0ByM61RVNQN21fXsor6PgQkREAhPdq6Q2\n3mmRhsyYAUD6mjXU3nyznzrp2hUeegheey2+HVkXL/Zv9N/6lh8diWc31ngNGuQ3bwNfi2PDBj/1\ncuqpvn5GtFZGWZlPJO3SBbZu5fMVKxi5cGGr7MjaUBDx7gcfUJmWxqcnnUTtkCG+XaWloby+ggsR\nEQnMpAkTuG3cOCoSGWFoRL9163i7spKePXv6olxf+xr8+c9+L5NevXxi5aBBDe/IOnasr61xxx3+\nuaALcn3xBcyZ4/Mtbr658VoZeXl7amW8+Sb06YP17g2VlaEEGcXFxfy6oIA3Kir8Sp/Bg2HRIt/m\niy/et50auRARkbYuuldJRQArPEYMHEjPnj0BuOKGG3yi6KWX+ue3b9+z/HPgQL/9e9++ftfTykp4\n9FEfZBx9tA86gizIVV3tC3Ll58e38mTgQPjlL/fUyti1CwYMwPr0gS1bkg4yYkcntlRV8errr/OJ\nc+y44AI44gg/cpNMTY8AKLgQEZFA3XTNNbw8e7av0JmkPsuWMWPatN0f704UjeZl5Ob6j7/80r/Z\n9+vn37RranyQMW2anw6JFuU6/vg9lT9b6tFHfaXPZGplpKfDCy/4HWQ7dYIDDtgdZBx00EFs2rSp\nyVtUVlbyP7ffzpMrVrC5upovs7P9pmsnnOATSjdu9KXWe/b0AVgKAgtQcCEiIgELcq+SqH0SRaNB\nxqpVPt9h+3a/iqNPHzjnHL8ra1WVv6amBr75Tf+m29KCXBs2+NobsVVFE3HKKfDWW742Rlqan1Yx\ng969+WTHDiwtDZxjy5YtzH34YRY//zz/W17Ol19+yVfArm7dcOec41eoxE4HPfaYDyjGjPHVTf/0\nJ3j55ZQEFqDgQkREQhDkXiXQRKJoXt6eVSC5uf7N9p57/DTIN78J3/gGHHYYPP98MAW5FiyACy5I\n/nrwwc+998LPfrYnQCgv95u5bdkC27fT++CD/ehGjx6+vYcdBuPHN78PytNP+9obNTV+JUuKqM6F\niIgELiMjg5ULF3LmRx/R5957G99iPaqsjD733stZZWUNFpuaNGEC/data/oea9b4/UiqqmDrVj/K\nsGkTnHYa1NX5bdeffjr5TlVX+zf/IGplpKf72hvZ2T44OOUUuOsuv0398cf7HJL+/X1S6ttvw3XX\nNf+6Awf6YmPDh/tVIAcf3LJ2toAqdIqISKji3qtkypQmf483uCFaU6JTIAce6JM7O3f2jzPOSG66\nYM4cX78iiHoZq1f7EYuzzmr4+VWrfHnx7GxfufSNN3yQdPHF8d1/1So//TJ1atPn/f3vcNlloI3L\nRESkPWnJXiWxEk4UjU3+/PRTP8XQrZvPT6irSyz/Ys0aeO89n9MQhAED9tTKaEg0gHniCTjoIB8A\n3H+/PxZPgJGX51e0bNjg9z9pZQouRESkVfTq1YspLSiBnXSiaCTI6LR6Nf+65RY/inH//VBUBJMm\nxV+Q68gjg62V0dzS2Lw8XzSsogJ+8AO/DHfu3PhHL84+G558UsGFiIhIU1qUKPq3v7GypoY333yT\nkSNH+kJYb73lg41zzoFDDmm8INdhh/kaFUHVytixI75AJT/f16pYuhSuv96XE8/N3WtjtEYNGuRr\nfnzxhR+xaUVK6BQRkXYjiETRnJwcnHOsXrIEPvnE7wHyu99BQQEUFvrpih07fK2M66/3gQX43I2N\nG4PpyMaNvh5HcwYN8nkiH3/sg4SJE31Nj3jl5fl9UFqZRi5ERKRdycjI4KmHHoo/UXTatAYTRXNz\nc/nRhRfy9MEHUzdzJvzrX75WRu/eflfT2FoZGzfCunV+eWhLa2WAHxX5xS/iO/fss+G55/Zslta7\nt58mee655q9tLrcjJAouRESkXQoiUfQPc+eSN24c66ZOxb36qk+AfP99uPNOP5UQrZXRty/ceCPc\nd1/La2WUlfnplninKgYO9Dkfmzf7j885x4+yxCOe3I4QKLgQEZF2rSWJohkZGax66ikmXHIJT2/e\njJszZ0/gkJvri1F16gTf/74vJz52rK+VMWVK8g1evNjfJ15duvjS5tEgYeBAv0tsPOLN7QhYaDkX\nZtbLzJ4wsyozqzSzB82s0c+GmWWY2Wwze8vMvjCzCjN71Mz6h9VGERGRjIwMFs2bx2O/+hUZTzyx\n54k1a+Cpp/wUxnXXwRVX+FGHysr4EiobsnatH4WI5nHEY8cOXyY8GiR06eJLh8ejvDy+3I6AhZnQ\nOR8YBuQBZwKjgblNnN8FOAa4CRgO/BA4HHgmxDaKiIgAcN555zG6SxcfTMRaswYWLoT16/10yZtv\n+umRF15I7AXWrvV7fiQ66lFe7it6RoOEHTt8nY54LF7sA5NWFsormtkRwOn4il+vR45dDTxrZtc7\n5/bZ9s05ty1yTex9JgOvmNkA51xAKboiIiIN6xQNLtLT4eST934ytigX+JoTr74K558ff62MG2/0\n907E4sVwwAF72lNe7jdqa05ZmW/Xu+/6gGjixJaXLo9TWOHMKKAyGlhErAQccBzxj0b0jFyzNdjm\niYiI7K2yspK3Pv7Y15UoKPA1MH74w33fkKNBxvTpPhB5+22/THXsWL90NJpE+dFH/vmvf31PrYxE\nlZX5FSqHHLInAfSPf/Q5GM1ZvNivNPnnP32bFyzwUzp5eX4VSZcu/v4hCCu46Ad8GnvAOVdrZlsi\nzzXLzDoB/weY75z7IvgmioiI7PH4ggVsOvFEP7Jw3XV+5UhDb8jRpang9yhJS/Nv3hs3+poUQ4b4\nFSaffeYTL6+/PvlGFRb6rdSjCaBlZX7ztOaWoUZzOzZuhJUrYdIk0jdt4sDVq+m9Zg1HHnEEmZ06\nUbNjBwubvlNSEgouzOxW4IYmTnH4PIsWMbMMYGHkfnEVkZ86dSo9evTY61h+fj75+fktbY6IiHQA\n6z/8kNohQ/YcOPxw/6iu9rkS0eJaXbr4/Idp0/wKkjlzYMYM+N73/KqSf/3LrzA5/3yYNctvUnbK\nKYk3aNUqH+AcffSeUY/58/1Or01ZuxaWL6dLnz70X76cY3Ny6F1ezheffMKn3bqRmZnJzk8+YSdQ\nVVWVeLvikOjIxe3AvGbOeR/YBBwYe9DM0oHekecaFRNYDAROiXfU4o477tCuqCIikrTK6uqGl21m\nZTW+eynANdfAzJngnB8lKCjw5bpLSvyUyLx5/rlEdlON7op66KF7EkBXrfL3bGylSlkZPPkknTds\nIG/UKG6+9tpm3xdLSkrIycmJv11xSii4cM59Dnze3HlmVgT0NLPhMXkXeYABrzRxXTSw+AaQ65yr\nTKR9IiIiyeqVlZVcwan0dJ+oGc3TGD8ezjwTfvtbv8IkI2NP8ud55zWf/Dl/vt/R9N/+zU/PpKf7\nwOL++30J8BUr9t4HpayMrz33HAdlZjIuL49fPv54XLvMhimUnAvn3HozWw48YGZXAAcAdwGFsStF\nzGw9cINz7plIYLEIvxz1LCDTzA6KnLrFOVcTRltFREQAjhg8mPSKCmqHDk384vp5Gps2+WTQ5csh\nO9uPOLzwgl+10aePr7I5cOCeAKG83Bfn2rrVT7n86ld+KiQabJSU+MTOrl2huBieeIK+WVmcfPzx\nfC8nh0mrVqU8oIgV5uLXicDd+FUidcBTwDX1zhkKRBMlsvFBBcAbkX8Nn3eRC7wYYltFRKSDmzRh\nAreNG0dF/SWoiYjmadxwg8/VOPJIHxgcfTT893/7x7vv+mCic+c9NSgyM2HECPj3fwcz/3xBgU/e\n3LTJb1a2axc9+/XjvKOO4ubCwjYVTNQXWnDhnNsKnNfMOekx//8ISHDxr4iISDB69erFMdnZVASx\nd0jfvn7zM4CLLvIjGkuW+OmMww+H117zq1A6d/Y1K7p1g5dfhlde8QWytm/3UyBduzJ81Ch++pOf\nMGnChDYdUMTSlusiIiIRN11zDX2WLm3ZTRraO+Tww+H66+l0yikM2b6dCy+9lKHDh/vnunXz0yNm\nPrDYuZPhRx3F+++/j/viC0peeokpl1/ebgIL0MZlIiIiu+Xk5HByVhbPrlvHzhNPTPwGje0dUlZG\nn2XLyO3encKXXyYjBSW5W9P+3TsREZEE/WHuXL4/fjyvOMfO0aPjv3DFCl/c6tJLffGqHTtIr6ig\n37p1jBg0iBnTpnWYkgkKLkRERGJkZGSwcuFCzr3sMtbeey+fjxnT7PLRPsuWcULnzpx88cX8o7yc\nrdu20bN7dw4fNIhJixa1qymNICi4EBGRBjnnMLNUNyMlMjIyeOqhhyguLuamO++kpLycTSeeSG12\n9u7lox11VCIeCi5ERGS36upqpk+fztKlS6mpqSEzM5MxY8Ywa9YssrKyUt28VpeTk8OSRx+lsrKS\nxxcsYMOHH3b4UYl4KLgQERHABxajRo2itLSUurq63cfvueceVq9eTVFRUYcMMMAvU51y+eWpbka7\noaWoIiICwPTp0/cJLADq6uooLS3lxhtvTFHLpL1RcCEiIgAsXbp0n8Aiqq6ujiVLlrRyi6S9UnAh\nIiJs27aNzZs3N3lOTU0NzrlWapG0ZwouREQ6uOrqar773e+yffv2Js/LzMzssKtHJDEKLkREOrho\nrkVT0tLSGFu/pLVIIxRciIh0cE3lWkQNGzaMmTNntlKLpL1TcCEi0oE556ipqWnynK5du/LSSy91\n2GWokjgFFyIiHZiZkZmZ2eQ5ffv2pXv37q3UItkfKLgQEengxowZQ1paw28HyrWQZCi4EBHp4GbN\nmsWwYcP2CTDS0tKUayFJUXAhItLBZWVlUVRUxOTJkxk8eDDZ2dkMHjyYyZMnd+iS35I87S0iIiJk\nZWVRUFBAQUFBh94NVYKhkQsREdmLAgtpKQUXIiIiEigFFyIiIhIoBRciIiISKAUXIiIiEigFFyIi\nIhIoBRciIiISKAUXIiIiEqjQggsz62VmT5hZlZlVmtmDZtY1gevvM7M6M5sSVhtFREQkeGGOXMwH\nhgF5wJnAaGBuPBea2Q+B44CK0FonIiIioQgluDCzI4DTgYucc685514CrgbONbN+zVybDRQAE4Fd\nYbRPREREwhPWyMUooNI593rMsZWAw49INMh8zdnHgNucc6UhtU1ERERCFFZw0Q/4NPaAc64W2BJ5\nrjHTgK+cc3eH1C4REREJWULBhZndGkmybOxRa2aHJdMQM8sBpgAXJHO9iIiItA2Jbrl+OzCvmXPe\nBzYBB8YeNLN0oHfkuYZ8D+gLlMfsyJcOzDGza51z32jqRadOnUqPHj32Opafn09+fn4zzRUREdn/\nFRYWUlhYuNexqqqqUF7LnHPB39QndL4DjIzmXZjZacBzwADn3D4Bhpn1AvrXO/wCPgdjnnPuvUZe\nawRQXFxczIgRIwLshYiIyP6tpKSEnJwcgBznXElQ90105CIuzrn1ZrYceMDMrgAOAO4CCmMDCzNb\nD9zgnHvGOVcJVMbex8xqgE2NBRYiIiLS9oRZ52IisB6/SmQZ8CJwWb1zhgI9aFzwwyoiIiISqlBG\nLgCcc1uB85o5J72Z55vMsxAREZG2R3uLiIiISKAUXIiIiEigFFyIiIhIoBRciIiISKAUXIiIiEig\nFFyIiIhIoBRciIiISKAUXIiIiEigFFyIiIhIoBRciIiISKAUXIiIiEigFFyIiIhIoBRciIiISKAU\nXIiIiEigFFyIiIhIoBRciIiISKAUXIiIiEigFFyIiIhIoBRciIiISKAUXIiIiEigFFyIiIhIoBRc\niIiISKAUXIiIiEigFFyIiIhIoBRciIiISKAUXIiIiEigFFyIiIhIoBRciIiISKBCCy7MrJeZPWFm\nVWZWaWYPmlnXOK4bZmbPmNlWM/vCzF4xswFhtVNERESCFebIxXxgGJAHnAmMBuY2dYGZDQHWAe9G\nzj8auAXYGWI7RUREJEAZYdzUzI4ATgdynHOvR45dDTxrZtc75zY1culM4Fnn3C9ijn0QRhtFREQk\nHGGNXIwCKqOBRcRKwAHHNXSBmRl+hOM9M3vezD4xs5fN7D9CaqOIiIiEIKzgoh/waewB51wtsCXy\nXEMOBLoBNwDPAacCTwN/NLMTQ2qniIiIBCyh4MLMbjWzuiYetWZ2WAvbstg5d6dz7i3n3GxgGXB5\nkvcUERGRVpZozsXtwLxmznkf2IQfidjNzNKB3pHnGvIZsAsorXe8FDihuYZNnTqVHj167HUsPz+f\n/Pz85i4VERHZ7xUWFlJYWLjXsaqqqlBey5xzwd/UJ3S+A4yMSeg8DT/dMaCxhE4z+wvwD+fc+THH\n/gjscM6d18g1I4Di4uJiRowYEXBPRERE9l8lJSXk5OSAX4BREtR9Q8m5cM6tB5YDD5jZsWZ2AnAX\nUBgbWJjZ+noJm78BJpjZxWY2xMwmA2cB94TRThEREQlemHUuJgLr8atElgEvApfVO2cosHsuwzm3\nGJ9f8XPgLeBC4BznXFGI7RQREZEAhVLnAsA5txVocCoj5pz0Bo49AjwSTqtEREQkbNpbRERERAKl\n4EJEREQCpeBCREREAqXgQkRERAKl4EJEREQCpeBCREREAqXgIiBhVDoVERFpjxRctEB1dTVTI2/S\n/AAACg1JREFUpkzh0EMPZeDAgRx66KFMmTKF6urqVDdNREQkZUIrorW/q66uZtSoUZSWllJXV7f7\n+D333MPq1aspKioiKysrhS0UERFJDY1cJGn69On7BBYAdXV1lJaWcuONN6aoZSIiIqml4CJJS5cu\n3SewiKqrq2PJkiWt3CIREZG2QcFFEpxz1NTUNHlOTU2NkjxFRKRDUnCRBDMjMzOzyXMyMzMxs1Zq\nkYiISNuh4CJJY8aMIS2t4U9fWloaY8eObeUWiYiItA0KLpI0a9Yshg0btk+AkZaWxrBhw5g5c2aK\nWiYiIpJaCi6SlJWVRVFREZMnT2bw4MFkZ2czePBgJk+erGWoIiLSoanORQtkZWVRUFBAQUEBzjnl\nWIiIiKCRi8AosBAREfEUXIiIiEigFFyIiIhIoBRciIiISKAUXIiIiEigFFyIiIhIoBRciIiISKAU\nXIiIiEigFFyIiIhIoBRciIiISKAUXLQjhYWFqW5Cq+kofVU/9y/q5/6lo/QzDKEFF2bWy8yeMLMq\nM6s0swfNrGsz13Q1s7vNrNzMdpjZO2Z2WVhtbG860jd6R+mr+rl/UT/3Lx2ln2EIc+RiPjAMyAPO\nBEYDc5u55g7gNGAicETk47vN7KwQ2ykiIiIBCiW4MLMjgNOBi5xzrznnXgKuBs41s35NXDoKeNQ5\nt845V+acexB4E/hOGO0UERGR4IU1cjEKqHTOvR5zbCXggOOauO4lYKyZHQxgZrnAUGB5SO0UERGR\ngGWEdN9+wKexB5xztWa2JfJcY64G7gc2mtkuoBa4xDn3lyau6QxQWlrasha3A1VVVZSUlKS6Ga2i\no/RV/dy/qJ/7l47Qz5j3zs6B3tg5F/cDuBWoa+JRCxwG/AIobeD6T4DLmrj/9UAp8APgKOBKYBtw\nShPXTMSPiOihhx566KGHHsk9JiYSDzT3sMgbdFzMrA/Qp5nT3gcmAbc753afa2bpwE5gnHPumQbu\n3RmoAs52zv2/mOMPANnOuR800abTgQ8j9xcREZH4dAYGA8udc58HddOEpkUiL9zsi5tZEdDTzIbH\n5F3kAQa80shlmZFHbb3jtTSRGxJp0/zm2iQiIiINeinoG4aS0OmcW49PwnzAzI41sxOAu4BC59ym\n6Hlmtt7M/iNyTTXwJ+B2MzvJzAab2U+BnwB/DKOdIiIiErywEjrB50LcjV8lUgc8BVxT75yhQI+Y\njyfg8zp+D/QGPgJ+4Zy7P8R2ioiISIASyrkQERERaY72FhEREZFAKbgQERGRQLWL4MLMrjKzD8zs\nSzN72cyObeLceWZWZ2a1kX+jj7+1ZpuTkUg/I+f/2MzeMLPtZvZPM3vIzHq3VnuTlUQ/rzKzdyOb\n2ZWa2aTWamuyzOxEM1tiZhWR77+xcVxzspkVm9lOM/u7mZ3fGm1tiUT7aWb9Ihsaboj8jM5prba2\nRBL9/KGZvWBmn0Y2b3zJzE5rrfa2RBJ9PcHM/mxmn8X8jF7bWu1NVjI/ozHXnmBmNWbW5itsJfH1\nPKnee2f0/fTARF63zQcXZjYB+L/Ar4Hh+L1GlpvZ1xu5ZAq+Cmj/yL8DgC3Ak+G3NnmJ9jOyAudR\n4AHgSGAcfg+WNp38mkQ/rwBmAf+N7+cM4B4zO7NVGpy8rsAb+EJwzSY2mdlgYBmwCvg2UAA8aGan\nhtfEQCTUT6ATvnrvLZHr2otE+zkaeAE4AxgBrAGWmtm3Q2thcBLt63b8asAT8RtO3gLMNLOLQ2th\nMBLtJwBm1gP/u3dlSO0KWjL9dPgFF/0ij/7OuU+bvqT+HQKsyBXGA3gZKIj52ICNwM/jvP5sYBcw\nMNV9CbKfwH8B79U7NhkoS3VfAu7nX4DZ9Y7dDryY6r4k0Oc6YGwz58wG3qp3rBB4LtXtD7Kf9c5f\nA8xJdbvD7mfMdW8DN6a6/a3U10X4TShT3oeg+xn5ubwJ/wdSSarbHnQ/gZPw9aW6t+S12vTIhZll\nAjn4v+YAcL73K/Gbo8XjQmClc648+BYGI8l+FgEDzeyMyD0OAsYDz4bb2uQl2c9O7Ft5dSfwnUjV\n1/3F8ez7l9By4v8+lzbMzAzIwo+i7tfMbDj++3ZtipsSODO7ADgUH1zszwx4IzLd/oKZfTfRG7Tp\n4AL4OpCO35Mk1ic0vQEaAGbWHz8s+UDwTQtUwv10fhv784AFZvYV8DFQiR+9aKuS+XouBy42sxEA\nZjYSuAhfzbWxqbH2qB8Nf166m1mnFLRHgvUz/PB0m56ebQkzKzezncCrwD3OuXmpblOQzGwo8D/A\nj51zdaluT4g+Bi4DfgScA5QDa83smERuEmYRrbbgp/g33H32MmnvzOxI/Lz8DPzcbn/8dMFcoK3P\ndSbiFuAgoMjM0oBNwCPAz/FDfCJtmplNBH6FH47+LNXtCdH3gG74UbjZZvYP59yCFLcpEJHfPU8A\nv3bO/W/0cAqbFBrn3N+Bv8ccetnMhgBTgbiTzNv6yMVn+Lmfg+odPwj/JtOcC4DHnHO7gm5YwJLp\n5zTgL865Oc65t51zK/AJOxdGpkjaooT76Zzb6Zy7GOgCHAIMwldurXbObQ6xra1tEw1/XrY55/6V\ngvZIAMzsXHyS9Xjn3JpUtydMzrmPnHPvOOceAu7A/+Gzv8gCRgJ3R1aJ1OADxmPM7CszOzmlrQvf\nq8A3E7mgTQcXzrkaoBi/6Rmwe+4yj2Y2Wol8sYcAD4XYxEAk2c8u+ETVWHX4LN82GVG35OvpnKt1\nzv0zkqNxLrA0zLamQBExn5eI0yLHpR0ys3z8759znXPPp7o9rSwdny+1v9gGHAUcg1/N9W3gPmB9\n5P+Nbci5vzgGP10St/YwLTIHeMTMivHR01T8G+sjAGZ2K3Cwc67+cM1FwCvOudJWbGtLJNrPpcD9\nZnY5Pi/hYPxfC6+4mM3h2qCE+hmZ5/wO/oe3N3Ad8C38hnZtlpl1xUf60UDvG5FliFucc+UNfD3v\nA64ys9nAw/hAYxzwg1ZuekKS6CeR5w0/hN438vFXbflnNdF+RqZCHsEvjf9rzGjil865ba3b+sQk\n0dcrgTL8Gy341Qb/Bfy2dVuemET6Gfmj5t16138K7GzL37eQ1NfzGuAD4B38duyXALlAYsviU700\nJs7lM1cCHwJf4v+SGxnz3Dxgdb3zuwNfABemuu0h9/Mq4G+Rvm7Er73un+p+BNlP/Lr5kkgfK/E7\n5A5NdR/i6ONJ+JGk2nqPh5v4eo7Gj+x8CbwHTEp1P0LqZ0Pnv5/qvgTZT/wy2/rn7j6/LT+S6Ovk\nyO+h6sjP6GvApanuR9D9bOD6drEUNYmv588iv3+2A5vxq/tGJ/q62rhMREREAtWmcy5ERESk/VFw\nISIiIoFScCEiIiKBUnAhIiIigVJwISIiIoFScCEiIiKBUnAhIiIigVJwISIiIoFScCEiIiKBUnAh\nIiIigVJwISIiIoH6//SEypfIyYt0AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x179e3f4d080>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Filename</th>\n",
       "      <th>EIN</th>\n",
       "      <th>Program_Exp</th>\n",
       "      <th>Liabilities_To_Asset</th>\n",
       "      <th>Working_Capital</th>\n",
       "      <th>Surplus_Margin</th>\n",
       "      <th>Total_Expenses</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2035</th>\n",
       "      <td>201502969349300235.xml</td>\n",
       "      <td>680383921.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>172324.300000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9921</th>\n",
       "      <td>201513179349308861.xml</td>\n",
       "      <td>311040228.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.540167</td>\n",
       "      <td>149559.470000</td>\n",
       "      <td>1.000333</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12048</th>\n",
       "      <td>201513179349305901.xml</td>\n",
       "      <td>166050703.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>33.472201</td>\n",
       "      <td>-148963.563600</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>220.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18753</th>\n",
       "      <td>201513139349303196.xml</td>\n",
       "      <td>943152652.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>254.451508</td>\n",
       "      <td>-7.144765</td>\n",
       "      <td>-250550.000000</td>\n",
       "      <td>250551.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30433</th>\n",
       "      <td>201512599349300126.xml</td>\n",
       "      <td>232799695.0</td>\n",
       "      <td>0.985825</td>\n",
       "      <td>0.426822</td>\n",
       "      <td>2.387819</td>\n",
       "      <td>-54849.571430</td>\n",
       "      <td>202757.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Filename          EIN  Program_Exp  Liabilities_To_Asset  \\\n",
       "2035   201502969349300235.xml  680383921.0     0.000000              0.000000   \n",
       "9921   201513179349308861.xml  311040228.0     0.000000              0.540167   \n",
       "12048  201513179349305901.xml  166050703.0     1.000000             33.472201   \n",
       "18753  201513139349303196.xml  943152652.0     1.000000            254.451508   \n",
       "30433  201512599349300126.xml  232799695.0     0.985825              0.426822   \n",
       "\n",
       "       Working_Capital  Surplus_Margin  Total_Expenses  \n",
       "2035     172324.300000        0.000000            10.0  \n",
       "9921     149559.470000        1.000333           100.0  \n",
       "12048   -148963.563600        0.000000           220.0  \n",
       "18753        -7.144765  -250550.000000        250551.0  \n",
       "30433         2.387819   -54849.571430        202757.0  "
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(n_clusters_)\n",
    "\n",
    "outliers_index = []\n",
    "for i in range(len(labels)):\n",
    "    if(labels[i]==-1):\n",
    "        outliers_index.append(i)\n",
    "        #print(df2.loc[i])\n",
    "outliers = df2.loc[outliers_index]\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "# Black removed and is used for noise instead.\n",
    "unique_labels = set(labels)\n",
    "colors = 'cyan'\n",
    "for k, col in zip(unique_labels, colors):\n",
    "    if k == -1:\n",
    "        # Black used for noise.\n",
    "        col = 'k'\n",
    "\n",
    "    class_member_mask = (labels == k)\n",
    "\n",
    "    xy = X[class_member_mask & core_samples_mask]\n",
    "    plt.plot(xy[:, 0], xy[:, 1], 'o', markerfacecolor=col,\n",
    "             markeredgecolor='k', markersize=14)\n",
    "\n",
    "    xy = X[class_member_mask & ~core_samples_mask]\n",
    "    plt.plot(xy[:, 0], xy[:, 1], 'o', markerfacecolor=col,\n",
    "             markeredgecolor='k', markersize=6)\n",
    "\n",
    "plt.title('Estimated number of clusters: %d' % n_clusters_)\n",
    "plt.show()\n",
    "\n",
    "outliers\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Results: \n",
    "\n",
    "Outliers appear to be failing in different metrics. The first 2 fail at Program Expenses and have extremeley inflated Working Capitals.\n",
    "The last two, despite having positive program expenses, have very high and negative surplus margins and are thus losing a lot of money."
   ]
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [conda root]",
   "language": "python",
   "name": "conda-root-py"
  },
  "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}