CreacionCSV.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Importacion de librerias\n",
    "import cv2                                                \n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "from matplotlib import pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "sanas    = [50]\n",
    "enfermas = [50]\n",
    "insectos = [50]\n",
    "\n",
    "for x in range (0 , 50):\n",
    "    sanas.append(cv2.imread('Imagenes/Sanas/S'+str(x)+'.jpg',1))\n",
    "    enfermas.append(cv2.imread('Imagenes/Insectos/I'+str(x)+'.jpg',1))\n",
    "    insectos.append(cv2.imread('Imagenes/Manchas/E'+str(x)+'.jpg',1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "agua  = [20]\n",
    "for x in range (0,20):\n",
    "    agua.append(cv2.imread('Imagenes/Agua/A'+str(x)+'.jpeg',1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(49,)"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## Vector de caracteristica \n",
    "features = []\n",
    "for n in range (1,50):\n",
    "    features.append(ExtracionDeCarateristicas(sanas[n],1))\n",
    "np.shape(features)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(98,)"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for n in range (1,50):\n",
    "    features.append(ExtracionDeCarateristicas(enfermas[n],2))\n",
    "np.shape(features)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(147,)"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for n in range (1,50):\n",
    "    features.append(ExtracionDeCarateristicas(insectos[n],3))\n",
    "np.shape(features)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(166,)"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for n in range (1,20):\n",
    "    features.append(ExtracionDeCarateristicas(agua[n],4))\n",
    "np.shape(features)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>MoB</th>\n",
       "      <th>MoG</th>\n",
       "      <th>MoR</th>\n",
       "      <th>MeB</th>\n",
       "      <th>MeG</th>\n",
       "      <th>MeR</th>\n",
       "      <th>sdtB</th>\n",
       "      <th>stdG</th>\n",
       "      <th>stdR</th>\n",
       "      <th>MoB2</th>\n",
       "      <th>...</th>\n",
       "      <th>Ncont</th>\n",
       "      <th>MinArea</th>\n",
       "      <th>MaxArea</th>\n",
       "      <th>ContConv</th>\n",
       "      <th>MinPer</th>\n",
       "      <th>MaxPeri</th>\n",
       "      <th>type</th>\n",
       "      <th>var2</th>\n",
       "      <th>var3</th>\n",
       "      <th>var</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>11</td>\n",
       "      <td>43</td>\n",
       "      <td>20</td>\n",
       "      <td>15.609935</td>\n",
       "      <td>52.551740</td>\n",
       "      <td>28.917639</td>\n",
       "      <td>10.831466</td>\n",
       "      <td>14.156018</td>\n",
       "      <td>14.660467</td>\n",
       "      <td>33</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>1680.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3</td>\n",
       "      <td>5.656854</td>\n",
       "      <td>25850.065742</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>15</td>\n",
       "      <td>71</td>\n",
       "      <td>34</td>\n",
       "      <td>20.313145</td>\n",
       "      <td>78.438995</td>\n",
       "      <td>42.608000</td>\n",
       "      <td>12.577629</td>\n",
       "      <td>15.735803</td>\n",
       "      <td>15.631453</td>\n",
       "      <td>53</td>\n",
       "      <td>...</td>\n",
       "      <td>20</td>\n",
       "      <td>2416.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>4</td>\n",
       "      <td>5.656854</td>\n",
       "      <td>34499.553223</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>11</td>\n",
       "      <td>57</td>\n",
       "      <td>30</td>\n",
       "      <td>16.117764</td>\n",
       "      <td>64.699430</td>\n",
       "      <td>36.972668</td>\n",
       "      <td>11.728563</td>\n",
       "      <td>15.078706</td>\n",
       "      <td>14.882422</td>\n",
       "      <td>45</td>\n",
       "      <td>...</td>\n",
       "      <td>23</td>\n",
       "      <td>274292.5</td>\n",
       "      <td>12.0</td>\n",
       "      <td>4</td>\n",
       "      <td>39.071068</td>\n",
       "      <td>10050.748945</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>10</td>\n",
       "      <td>63</td>\n",
       "      <td>28</td>\n",
       "      <td>14.750944</td>\n",
       "      <td>70.362788</td>\n",
       "      <td>36.795557</td>\n",
       "      <td>11.723098</td>\n",
       "      <td>14.500892</td>\n",
       "      <td>14.698378</td>\n",
       "      <td>46</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>1632.5</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>232.769552</td>\n",
       "      <td>22558.653270</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>7</td>\n",
       "      <td>48</td>\n",
       "      <td>22</td>\n",
       "      <td>12.920143</td>\n",
       "      <td>52.927004</td>\n",
       "      <td>28.622405</td>\n",
       "      <td>10.598902</td>\n",
       "      <td>13.783048</td>\n",
       "      <td>13.041982</td>\n",
       "      <td>36</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>1564.5</td>\n",
       "      <td>1141.0</td>\n",
       "      <td>0</td>\n",
       "      <td>21270.147797</td>\n",
       "      <td>24815.062434</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>15</td>\n",
       "      <td>71</td>\n",
       "      <td>34</td>\n",
       "      <td>20.239477</td>\n",
       "      <td>74.927431</td>\n",
       "      <td>39.920032</td>\n",
       "      <td>11.651256</td>\n",
       "      <td>11.220574</td>\n",
       "      <td>12.454426</td>\n",
       "      <td>54</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>533.5</td>\n",
       "      <td>17.0</td>\n",
       "      <td>0</td>\n",
       "      <td>737.587874</td>\n",
       "      <td>14307.055159</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>17</td>\n",
       "      <td>58</td>\n",
       "      <td>31</td>\n",
       "      <td>21.052108</td>\n",
       "      <td>66.894639</td>\n",
       "      <td>38.989015</td>\n",
       "      <td>11.879448</td>\n",
       "      <td>16.181154</td>\n",
       "      <td>14.090948</td>\n",
       "      <td>46</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>4951.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>1</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>23527.950395</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>11</td>\n",
       "      <td>59</td>\n",
       "      <td>29</td>\n",
       "      <td>15.903081</td>\n",
       "      <td>65.381808</td>\n",
       "      <td>37.305137</td>\n",
       "      <td>11.803764</td>\n",
       "      <td>15.740255</td>\n",
       "      <td>15.248684</td>\n",
       "      <td>45</td>\n",
       "      <td>...</td>\n",
       "      <td>18</td>\n",
       "      <td>213695.0</td>\n",
       "      <td>14.5</td>\n",
       "      <td>1</td>\n",
       "      <td>43.455843</td>\n",
       "      <td>10838.032356</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>19</td>\n",
       "      <td>73</td>\n",
       "      <td>40</td>\n",
       "      <td>23.619594</td>\n",
       "      <td>77.611333</td>\n",
       "      <td>47.306885</td>\n",
       "      <td>13.463645</td>\n",
       "      <td>13.230484</td>\n",
       "      <td>14.640946</td>\n",
       "      <td>56</td>\n",
       "      <td>...</td>\n",
       "      <td>22</td>\n",
       "      <td>147412.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "      <td>7.656854</td>\n",
       "      <td>11659.604029</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>8</td>\n",
       "      <td>49</td>\n",
       "      <td>23</td>\n",
       "      <td>13.937870</td>\n",
       "      <td>53.368118</td>\n",
       "      <td>29.094605</td>\n",
       "      <td>10.594458</td>\n",
       "      <td>13.795643</td>\n",
       "      <td>13.000197</td>\n",
       "      <td>37</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1227.5</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0</td>\n",
       "      <td>122.183765</td>\n",
       "      <td>25605.912291</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>19</td>\n",
       "      <td>50</td>\n",
       "      <td>27</td>\n",
       "      <td>21.909877</td>\n",
       "      <td>60.136429</td>\n",
       "      <td>36.214606</td>\n",
       "      <td>12.782327</td>\n",
       "      <td>15.570396</td>\n",
       "      <td>15.077189</td>\n",
       "      <td>39</td>\n",
       "      <td>...</td>\n",
       "      <td>89</td>\n",
       "      <td>271608.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>14</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>9959.456511</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>9</td>\n",
       "      <td>48</td>\n",
       "      <td>22</td>\n",
       "      <td>13.532693</td>\n",
       "      <td>53.455673</td>\n",
       "      <td>29.662157</td>\n",
       "      <td>10.723968</td>\n",
       "      <td>13.621627</td>\n",
       "      <td>14.150773</td>\n",
       "      <td>36</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>13817.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>9.071068</td>\n",
       "      <td>35544.759283</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>8</td>\n",
       "      <td>54</td>\n",
       "      <td>27</td>\n",
       "      <td>13.367006</td>\n",
       "      <td>64.521991</td>\n",
       "      <td>34.782700</td>\n",
       "      <td>12.091301</td>\n",
       "      <td>14.239936</td>\n",
       "      <td>14.423229</td>\n",
       "      <td>41</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>1496.0</td>\n",
       "      <td>1085.5</td>\n",
       "      <td>0</td>\n",
       "      <td>10506.189271</td>\n",
       "      <td>21957.870645</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>13</td>\n",
       "      <td>51</td>\n",
       "      <td>27</td>\n",
       "      <td>16.266433</td>\n",
       "      <td>56.759589</td>\n",
       "      <td>31.621765</td>\n",
       "      <td>9.602699</td>\n",
       "      <td>11.290344</td>\n",
       "      <td>10.948105</td>\n",
       "      <td>39</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1284.5</td>\n",
       "      <td>3.5</td>\n",
       "      <td>0</td>\n",
       "      <td>114.284271</td>\n",
       "      <td>19514.851858</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>72</td>\n",
       "      <td>36</td>\n",
       "      <td>19.799738</td>\n",
       "      <td>75.510673</td>\n",
       "      <td>40.976217</td>\n",
       "      <td>11.676377</td>\n",
       "      <td>11.571080</td>\n",
       "      <td>12.768883</td>\n",
       "      <td>54</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>569.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>5.656854</td>\n",
       "      <td>9541.994734</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>19</td>\n",
       "      <td>84</td>\n",
       "      <td>45</td>\n",
       "      <td>21.139945</td>\n",
       "      <td>86.582210</td>\n",
       "      <td>49.333084</td>\n",
       "      <td>10.036396</td>\n",
       "      <td>11.217750</td>\n",
       "      <td>12.684399</td>\n",
       "      <td>65</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>2203.5</td>\n",
       "      <td>22.5</td>\n",
       "      <td>3</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>24406.536218</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>15</td>\n",
       "      <td>68</td>\n",
       "      <td>35</td>\n",
       "      <td>21.899001</td>\n",
       "      <td>75.996048</td>\n",
       "      <td>43.051953</td>\n",
       "      <td>12.708869</td>\n",
       "      <td>13.802437</td>\n",
       "      <td>14.164429</td>\n",
       "      <td>51</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>2250.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0</td>\n",
       "      <td>38.242641</td>\n",
       "      <td>16257.869974</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>7</td>\n",
       "      <td>57</td>\n",
       "      <td>28</td>\n",
       "      <td>11.812600</td>\n",
       "      <td>64.086911</td>\n",
       "      <td>34.700778</td>\n",
       "      <td>12.509669</td>\n",
       "      <td>13.112325</td>\n",
       "      <td>13.673442</td>\n",
       "      <td>43</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1270875.5</td>\n",
       "      <td>50.0</td>\n",
       "      <td>2</td>\n",
       "      <td>9.656854</td>\n",
       "      <td>19132.747168</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>9</td>\n",
       "      <td>65</td>\n",
       "      <td>30</td>\n",
       "      <td>13.798849</td>\n",
       "      <td>73.899700</td>\n",
       "      <td>38.720376</td>\n",
       "      <td>12.174805</td>\n",
       "      <td>15.141706</td>\n",
       "      <td>15.390712</td>\n",
       "      <td>48</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>2303.0</td>\n",
       "      <td>3.5</td>\n",
       "      <td>2</td>\n",
       "      <td>37.071068</td>\n",
       "      <td>42288.477422</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>11</td>\n",
       "      <td>68</td>\n",
       "      <td>35</td>\n",
       "      <td>15.316011</td>\n",
       "      <td>77.796726</td>\n",
       "      <td>44.715678</td>\n",
       "      <td>10.343214</td>\n",
       "      <td>17.514815</td>\n",
       "      <td>16.995987</td>\n",
       "      <td>51</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2099.5</td>\n",
       "      <td>2099.5</td>\n",
       "      <td>0</td>\n",
       "      <td>9.656854</td>\n",
       "      <td>30156.926358</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>11</td>\n",
       "      <td>49</td>\n",
       "      <td>25</td>\n",
       "      <td>21.864516</td>\n",
       "      <td>66.212056</td>\n",
       "      <td>37.166040</td>\n",
       "      <td>14.718186</td>\n",
       "      <td>19.897828</td>\n",
       "      <td>16.979182</td>\n",
       "      <td>37</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>1792.5</td>\n",
       "      <td>177.5</td>\n",
       "      <td>0</td>\n",
       "      <td>2325.578980</td>\n",
       "      <td>21068.928519</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>18</td>\n",
       "      <td>51</td>\n",
       "      <td>28</td>\n",
       "      <td>18.729973</td>\n",
       "      <td>54.776234</td>\n",
       "      <td>31.256431</td>\n",
       "      <td>9.140481</td>\n",
       "      <td>11.440157</td>\n",
       "      <td>11.069914</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>1179.0</td>\n",
       "      <td>9.5</td>\n",
       "      <td>0</td>\n",
       "      <td>372.350286</td>\n",
       "      <td>19026.909534</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>3</td>\n",
       "      <td>59</td>\n",
       "      <td>29</td>\n",
       "      <td>8.712216</td>\n",
       "      <td>65.825288</td>\n",
       "      <td>35.347144</td>\n",
       "      <td>11.882464</td>\n",
       "      <td>13.176397</td>\n",
       "      <td>12.889688</td>\n",
       "      <td>44</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>1577.5</td>\n",
       "      <td>19.0</td>\n",
       "      <td>0</td>\n",
       "      <td>505.646748</td>\n",
       "      <td>22001.176010</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>12</td>\n",
       "      <td>51</td>\n",
       "      <td>28</td>\n",
       "      <td>15.558474</td>\n",
       "      <td>55.578111</td>\n",
       "      <td>32.173991</td>\n",
       "      <td>10.345837</td>\n",
       "      <td>12.128272</td>\n",
       "      <td>11.700731</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>19</td>\n",
       "      <td>1588.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>14431.583286</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>9</td>\n",
       "      <td>47</td>\n",
       "      <td>23</td>\n",
       "      <td>14.488711</td>\n",
       "      <td>51.754638</td>\n",
       "      <td>30.005806</td>\n",
       "      <td>10.823763</td>\n",
       "      <td>15.370268</td>\n",
       "      <td>13.536215</td>\n",
       "      <td>35</td>\n",
       "      <td>...</td>\n",
       "      <td>26</td>\n",
       "      <td>1171.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>37.071068</td>\n",
       "      <td>14830.572310</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>10</td>\n",
       "      <td>48</td>\n",
       "      <td>26</td>\n",
       "      <td>16.511603</td>\n",
       "      <td>56.119641</td>\n",
       "      <td>33.034363</td>\n",
       "      <td>10.994781</td>\n",
       "      <td>13.379101</td>\n",
       "      <td>13.679444</td>\n",
       "      <td>37</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>1474.5</td>\n",
       "      <td>5.5</td>\n",
       "      <td>0</td>\n",
       "      <td>344.551296</td>\n",
       "      <td>16960.105470</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>14</td>\n",
       "      <td>58</td>\n",
       "      <td>24</td>\n",
       "      <td>15.163184</td>\n",
       "      <td>57.719520</td>\n",
       "      <td>32.122941</td>\n",
       "      <td>9.924523</td>\n",
       "      <td>15.118745</td>\n",
       "      <td>13.065646</td>\n",
       "      <td>35</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>1967.0</td>\n",
       "      <td>16.5</td>\n",
       "      <td>0</td>\n",
       "      <td>59.313708</td>\n",
       "      <td>18657.624386</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>13</td>\n",
       "      <td>57</td>\n",
       "      <td>31</td>\n",
       "      <td>15.185238</td>\n",
       "      <td>61.875456</td>\n",
       "      <td>36.495673</td>\n",
       "      <td>9.686309</td>\n",
       "      <td>14.058090</td>\n",
       "      <td>12.904499</td>\n",
       "      <td>44</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>1714.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>41.071068</td>\n",
       "      <td>16442.166776</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>19</td>\n",
       "      <td>78</td>\n",
       "      <td>44</td>\n",
       "      <td>21.972798</td>\n",
       "      <td>79.692994</td>\n",
       "      <td>46.973777</td>\n",
       "      <td>10.671621</td>\n",
       "      <td>11.537404</td>\n",
       "      <td>12.633068</td>\n",
       "      <td>61</td>\n",
       "      <td>...</td>\n",
       "      <td>13</td>\n",
       "      <td>2186.0</td>\n",
       "      <td>5.5</td>\n",
       "      <td>3</td>\n",
       "      <td>9.071068</td>\n",
       "      <td>20249.291999</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>5</td>\n",
       "      <td>56</td>\n",
       "      <td>26</td>\n",
       "      <td>12.188511</td>\n",
       "      <td>65.832670</td>\n",
       "      <td>34.783700</td>\n",
       "      <td>13.409715</td>\n",
       "      <td>14.161095</td>\n",
       "      <td>14.141881</td>\n",
       "      <td>41</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>18010.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2747.000000</td>\n",
       "      <td>2747.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>46134.581617</td>\n",
       "      <td>46134.581617</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>4</td>\n",
       "      <td>113</td>\n",
       "      <td>96</td>\n",
       "      <td>7.753188</td>\n",
       "      <td>122.342417</td>\n",
       "      <td>108.699259</td>\n",
       "      <td>8.143712</td>\n",
       "      <td>17.568897</td>\n",
       "      <td>22.227150</td>\n",
       "      <td>96</td>\n",
       "      <td>...</td>\n",
       "      <td>64</td>\n",
       "      <td>474711.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>11</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>14004.767923</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>9</td>\n",
       "      <td>111</td>\n",
       "      <td>93</td>\n",
       "      <td>12.721571</td>\n",
       "      <td>113.394949</td>\n",
       "      <td>97.631534</td>\n",
       "      <td>9.637975</td>\n",
       "      <td>16.938355</td>\n",
       "      <td>24.951241</td>\n",
       "      <td>95</td>\n",
       "      <td>...</td>\n",
       "      <td>68</td>\n",
       "      <td>161699.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>11</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>12780.363477</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>11</td>\n",
       "      <td>117</td>\n",
       "      <td>134</td>\n",
       "      <td>17.163144</td>\n",
       "      <td>115.879494</td>\n",
       "      <td>131.732919</td>\n",
       "      <td>8.037334</td>\n",
       "      <td>20.148884</td>\n",
       "      <td>21.774423</td>\n",
       "      <td>111</td>\n",
       "      <td>...</td>\n",
       "      <td>73</td>\n",
       "      <td>4026.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>17</td>\n",
       "      <td>37.071068</td>\n",
       "      <td>760.457931</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>16</td>\n",
       "      <td>132</td>\n",
       "      <td>129</td>\n",
       "      <td>24.851586</td>\n",
       "      <td>137.817150</td>\n",
       "      <td>135.237912</td>\n",
       "      <td>12.865571</td>\n",
       "      <td>14.277372</td>\n",
       "      <td>17.004569</td>\n",
       "      <td>119</td>\n",
       "      <td>...</td>\n",
       "      <td>129</td>\n",
       "      <td>262660.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>18</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>9417.126434</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>6</td>\n",
       "      <td>113</td>\n",
       "      <td>93</td>\n",
       "      <td>11.278847</td>\n",
       "      <td>119.832161</td>\n",
       "      <td>100.737946</td>\n",
       "      <td>10.751032</td>\n",
       "      <td>13.391018</td>\n",
       "      <td>16.799384</td>\n",
       "      <td>95</td>\n",
       "      <td>...</td>\n",
       "      <td>42</td>\n",
       "      <td>406796.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>4831.287038</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>14</td>\n",
       "      <td>126</td>\n",
       "      <td>138</td>\n",
       "      <td>18.546387</td>\n",
       "      <td>119.330776</td>\n",
       "      <td>122.810086</td>\n",
       "      <td>9.564072</td>\n",
       "      <td>16.070645</td>\n",
       "      <td>21.062420</td>\n",
       "      <td>118</td>\n",
       "      <td>...</td>\n",
       "      <td>115</td>\n",
       "      <td>26664.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>12</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>6399.715182</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>8</td>\n",
       "      <td>114</td>\n",
       "      <td>93</td>\n",
       "      <td>12.393474</td>\n",
       "      <td>109.568298</td>\n",
       "      <td>91.361018</td>\n",
       "      <td>9.426325</td>\n",
       "      <td>19.418019</td>\n",
       "      <td>25.613779</td>\n",
       "      <td>96</td>\n",
       "      <td>...</td>\n",
       "      <td>65</td>\n",
       "      <td>589182.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>8</td>\n",
       "      <td>2.828427</td>\n",
       "      <td>11526.693561</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>16</td>\n",
       "      <td>115</td>\n",
       "      <td>137</td>\n",
       "      <td>17.015942</td>\n",
       "      <td>103.009977</td>\n",
       "      <td>119.737928</td>\n",
       "      <td>7.152383</td>\n",
       "      <td>28.460999</td>\n",
       "      <td>27.097623</td>\n",
       "      <td>115</td>\n",
       "      <td>...</td>\n",
       "      <td>48</td>\n",
       "      <td>2164.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8</td>\n",
       "      <td>4.828427</td>\n",
       "      <td>448.208150</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>36</td>\n",
       "      <td>150</td>\n",
       "      <td>143</td>\n",
       "      <td>36.800002</td>\n",
       "      <td>149.885652</td>\n",
       "      <td>144.892741</td>\n",
       "      <td>13.799424</td>\n",
       "      <td>13.010173</td>\n",
       "      <td>12.108080</td>\n",
       "      <td>135</td>\n",
       "      <td>...</td>\n",
       "      <td>257</td>\n",
       "      <td>3143.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>35</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>8386.146975</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>8</td>\n",
       "      <td>95</td>\n",
       "      <td>60</td>\n",
       "      <td>12.335219</td>\n",
       "      <td>90.774065</td>\n",
       "      <td>57.975201</td>\n",
       "      <td>9.981602</td>\n",
       "      <td>16.001477</td>\n",
       "      <td>17.493420</td>\n",
       "      <td>75</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>1255.0</td>\n",
       "      <td>77.5</td>\n",
       "      <td>0</td>\n",
       "      <td>26.142135</td>\n",
       "      <td>25037.537604</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>11</td>\n",
       "      <td>67</td>\n",
       "      <td>39</td>\n",
       "      <td>15.356538</td>\n",
       "      <td>76.465913</td>\n",
       "      <td>54.503527</td>\n",
       "      <td>10.326691</td>\n",
       "      <td>17.369161</td>\n",
       "      <td>22.102412</td>\n",
       "      <td>52</td>\n",
       "      <td>...</td>\n",
       "      <td>120</td>\n",
       "      <td>8780.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>17</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>11464.259494</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>11</td>\n",
       "      <td>126</td>\n",
       "      <td>110</td>\n",
       "      <td>17.960080</td>\n",
       "      <td>124.186672</td>\n",
       "      <td>109.148286</td>\n",
       "      <td>11.595740</td>\n",
       "      <td>18.228039</td>\n",
       "      <td>17.636433</td>\n",
       "      <td>106</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>31616.5</td>\n",
       "      <td>4767.0</td>\n",
       "      <td>0</td>\n",
       "      <td>402.014280</td>\n",
       "      <td>1384.531086</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>33</td>\n",
       "      <td>144</td>\n",
       "      <td>139</td>\n",
       "      <td>39.944007</td>\n",
       "      <td>141.424515</td>\n",
       "      <td>141.025377</td>\n",
       "      <td>10.676215</td>\n",
       "      <td>14.167174</td>\n",
       "      <td>13.439349</td>\n",
       "      <td>128</td>\n",
       "      <td>...</td>\n",
       "      <td>44</td>\n",
       "      <td>23162.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>12</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2256.052945</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>9</td>\n",
       "      <td>119</td>\n",
       "      <td>100</td>\n",
       "      <td>15.996715</td>\n",
       "      <td>112.994878</td>\n",
       "      <td>96.157592</td>\n",
       "      <td>11.706584</td>\n",
       "      <td>18.298873</td>\n",
       "      <td>18.648601</td>\n",
       "      <td>102</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>16911.5</td>\n",
       "      <td>121.5</td>\n",
       "      <td>0</td>\n",
       "      <td>321.338094</td>\n",
       "      <td>1795.055031</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>24</td>\n",
       "      <td>174</td>\n",
       "      <td>141</td>\n",
       "      <td>36.582607</td>\n",
       "      <td>150.103326</td>\n",
       "      <td>142.714043</td>\n",
       "      <td>16.989564</td>\n",
       "      <td>22.062279</td>\n",
       "      <td>22.059466</td>\n",
       "      <td>136</td>\n",
       "      <td>...</td>\n",
       "      <td>18</td>\n",
       "      <td>16379.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>2</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1035.928059</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>16</td>\n",
       "      <td>131</td>\n",
       "      <td>124</td>\n",
       "      <td>22.819736</td>\n",
       "      <td>130.117106</td>\n",
       "      <td>129.003982</td>\n",
       "      <td>10.490318</td>\n",
       "      <td>17.332336</td>\n",
       "      <td>18.095845</td>\n",
       "      <td>116</td>\n",
       "      <td>...</td>\n",
       "      <td>40</td>\n",
       "      <td>38740.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>8</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>3018.584032</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>31</td>\n",
       "      <td>117</td>\n",
       "      <td>119</td>\n",
       "      <td>29.416169</td>\n",
       "      <td>119.110956</td>\n",
       "      <td>122.199360</td>\n",
       "      <td>9.421677</td>\n",
       "      <td>14.197605</td>\n",
       "      <td>15.798534</td>\n",
       "      <td>107</td>\n",
       "      <td>...</td>\n",
       "      <td>25</td>\n",
       "      <td>20975.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1180.315796</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>11</td>\n",
       "      <td>136</td>\n",
       "      <td>127</td>\n",
       "      <td>18.751632</td>\n",
       "      <td>134.775424</td>\n",
       "      <td>129.795312</td>\n",
       "      <td>11.227805</td>\n",
       "      <td>15.337223</td>\n",
       "      <td>15.568320</td>\n",
       "      <td>119</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>29793.0</td>\n",
       "      <td>287.0</td>\n",
       "      <td>0</td>\n",
       "      <td>67.941126</td>\n",
       "      <td>1152.974738</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>23</td>\n",
       "      <td>146</td>\n",
       "      <td>143</td>\n",
       "      <td>31.265635</td>\n",
       "      <td>141.690884</td>\n",
       "      <td>141.782986</td>\n",
       "      <td>11.320696</td>\n",
       "      <td>16.322770</td>\n",
       "      <td>17.433085</td>\n",
       "      <td>130</td>\n",
       "      <td>...</td>\n",
       "      <td>47</td>\n",
       "      <td>24640.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>2</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2287.065137</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>22</td>\n",
       "      <td>121</td>\n",
       "      <td>134</td>\n",
       "      <td>23.573089</td>\n",
       "      <td>116.998954</td>\n",
       "      <td>126.090933</td>\n",
       "      <td>7.870220</td>\n",
       "      <td>18.825269</td>\n",
       "      <td>17.676764</td>\n",
       "      <td>113</td>\n",
       "      <td>...</td>\n",
       "      <td>70</td>\n",
       "      <td>7890.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>13</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2506.525155</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>23</td>\n",
       "      <td>147</td>\n",
       "      <td>153</td>\n",
       "      <td>27.268471</td>\n",
       "      <td>138.136770</td>\n",
       "      <td>140.073028</td>\n",
       "      <td>13.145419</td>\n",
       "      <td>21.959314</td>\n",
       "      <td>24.177682</td>\n",
       "      <td>137</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>4744.5</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>5.656854</td>\n",
       "      <td>952.631593</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>9</td>\n",
       "      <td>136</td>\n",
       "      <td>117</td>\n",
       "      <td>15.653391</td>\n",
       "      <td>137.607414</td>\n",
       "      <td>131.098607</td>\n",
       "      <td>9.693635</td>\n",
       "      <td>21.195449</td>\n",
       "      <td>24.615177</td>\n",
       "      <td>117</td>\n",
       "      <td>...</td>\n",
       "      <td>17</td>\n",
       "      <td>19043.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1</td>\n",
       "      <td>11.071068</td>\n",
       "      <td>882.274166</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>16</td>\n",
       "      <td>149</td>\n",
       "      <td>152</td>\n",
       "      <td>27.596619</td>\n",
       "      <td>151.423060</td>\n",
       "      <td>154.927335</td>\n",
       "      <td>11.084358</td>\n",
       "      <td>14.893223</td>\n",
       "      <td>15.256196</td>\n",
       "      <td>136</td>\n",
       "      <td>...</td>\n",
       "      <td>17</td>\n",
       "      <td>1020.5</td>\n",
       "      <td>37.5</td>\n",
       "      <td>4</td>\n",
       "      <td>41.071068</td>\n",
       "      <td>2113.986929</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>13</td>\n",
       "      <td>23</td>\n",
       "      <td>107</td>\n",
       "      <td>24.811111</td>\n",
       "      <td>55.866667</td>\n",
       "      <td>65.822222</td>\n",
       "      <td>14.007851</td>\n",
       "      <td>37.168744</td>\n",
       "      <td>33.137618</td>\n",
       "      <td>24</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>12</td>\n",
       "      <td>134</td>\n",
       "      <td>117</td>\n",
       "      <td>23.470856</td>\n",
       "      <td>135.304891</td>\n",
       "      <td>129.731314</td>\n",
       "      <td>12.672782</td>\n",
       "      <td>21.675059</td>\n",
       "      <td>21.862498</td>\n",
       "      <td>118</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>20525.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>0</td>\n",
       "      <td>123.112698</td>\n",
       "      <td>1276.548333</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>14</td>\n",
       "      <td>109</td>\n",
       "      <td>125</td>\n",
       "      <td>15.484116</td>\n",
       "      <td>99.272116</td>\n",
       "      <td>114.378888</td>\n",
       "      <td>3.861035</td>\n",
       "      <td>29.722315</td>\n",
       "      <td>31.539818</td>\n",
       "      <td>103</td>\n",
       "      <td>...</td>\n",
       "      <td>14</td>\n",
       "      <td>1747.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "      <td>7.656854</td>\n",
       "      <td>491.279218</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>22</td>\n",
       "      <td>135</td>\n",
       "      <td>137</td>\n",
       "      <td>26.805131</td>\n",
       "      <td>117.235343</td>\n",
       "      <td>121.602702</td>\n",
       "      <td>11.153041</td>\n",
       "      <td>20.361037</td>\n",
       "      <td>21.658117</td>\n",
       "      <td>115</td>\n",
       "      <td>...</td>\n",
       "      <td>21</td>\n",
       "      <td>2232.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>943.685411</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>26</td>\n",
       "      <td>143</td>\n",
       "      <td>128</td>\n",
       "      <td>32.021844</td>\n",
       "      <td>137.463988</td>\n",
       "      <td>125.939292</td>\n",
       "      <td>12.209761</td>\n",
       "      <td>15.358791</td>\n",
       "      <td>16.271666</td>\n",
       "      <td>128</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>19387.0</td>\n",
       "      <td>4896.0</td>\n",
       "      <td>0</td>\n",
       "      <td>467.955405</td>\n",
       "      <td>1092.655975</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>33</td>\n",
       "      <td>144</td>\n",
       "      <td>139</td>\n",
       "      <td>39.944007</td>\n",
       "      <td>141.424515</td>\n",
       "      <td>141.025377</td>\n",
       "      <td>10.676215</td>\n",
       "      <td>14.167174</td>\n",
       "      <td>13.439349</td>\n",
       "      <td>128</td>\n",
       "      <td>...</td>\n",
       "      <td>44</td>\n",
       "      <td>23162.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>12</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2256.052945</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>165 rows × 35 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     MoB  MoG  MoR        MeB         MeG         MeR       sdtB       stdG  \\\n",
       "1     11   43   20  15.609935   52.551740   28.917639  10.831466  14.156018   \n",
       "2     15   71   34  20.313145   78.438995   42.608000  12.577629  15.735803   \n",
       "3     11   57   30  16.117764   64.699430   36.972668  11.728563  15.078706   \n",
       "4     10   63   28  14.750944   70.362788   36.795557  11.723098  14.500892   \n",
       "5      7   48   22  12.920143   52.927004   28.622405  10.598902  13.783048   \n",
       "6     15   71   34  20.239477   74.927431   39.920032  11.651256  11.220574   \n",
       "7     17   58   31  21.052108   66.894639   38.989015  11.879448  16.181154   \n",
       "8     11   59   29  15.903081   65.381808   37.305137  11.803764  15.740255   \n",
       "9     19   73   40  23.619594   77.611333   47.306885  13.463645  13.230484   \n",
       "10     8   49   23  13.937870   53.368118   29.094605  10.594458  13.795643   \n",
       "11    19   50   27  21.909877   60.136429   36.214606  12.782327  15.570396   \n",
       "12     9   48   22  13.532693   53.455673   29.662157  10.723968  13.621627   \n",
       "13     8   54   27  13.367006   64.521991   34.782700  12.091301  14.239936   \n",
       "14    13   51   27  16.266433   56.759589   31.621765   9.602699  11.290344   \n",
       "15    15   72   36  19.799738   75.510673   40.976217  11.676377  11.571080   \n",
       "16    19   84   45  21.139945   86.582210   49.333084  10.036396  11.217750   \n",
       "17    15   68   35  21.899001   75.996048   43.051953  12.708869  13.802437   \n",
       "18     7   57   28  11.812600   64.086911   34.700778  12.509669  13.112325   \n",
       "19     9   65   30  13.798849   73.899700   38.720376  12.174805  15.141706   \n",
       "20    11   68   35  15.316011   77.796726   44.715678  10.343214  17.514815   \n",
       "21    11   49   25  21.864516   66.212056   37.166040  14.718186  19.897828   \n",
       "22    18   51   28  18.729973   54.776234   31.256431   9.140481  11.440157   \n",
       "23     3   59   29   8.712216   65.825288   35.347144  11.882464  13.176397   \n",
       "24    12   51   28  15.558474   55.578111   32.173991  10.345837  12.128272   \n",
       "25     9   47   23  14.488711   51.754638   30.005806  10.823763  15.370268   \n",
       "26    10   48   26  16.511603   56.119641   33.034363  10.994781  13.379101   \n",
       "27    14   58   24  15.163184   57.719520   32.122941   9.924523  15.118745   \n",
       "28    13   57   31  15.185238   61.875456   36.495673   9.686309  14.058090   \n",
       "29    19   78   44  21.972798   79.692994   46.973777  10.671621  11.537404   \n",
       "30     5   56   26  12.188511   65.832670   34.783700  13.409715  14.161095   \n",
       "..   ...  ...  ...        ...         ...         ...        ...        ...   \n",
       "136    4  113   96   7.753188  122.342417  108.699259   8.143712  17.568897   \n",
       "137    9  111   93  12.721571  113.394949   97.631534   9.637975  16.938355   \n",
       "138   11  117  134  17.163144  115.879494  131.732919   8.037334  20.148884   \n",
       "139   16  132  129  24.851586  137.817150  135.237912  12.865571  14.277372   \n",
       "140    6  113   93  11.278847  119.832161  100.737946  10.751032  13.391018   \n",
       "141   14  126  138  18.546387  119.330776  122.810086   9.564072  16.070645   \n",
       "142    8  114   93  12.393474  109.568298   91.361018   9.426325  19.418019   \n",
       "143   16  115  137  17.015942  103.009977  119.737928   7.152383  28.460999   \n",
       "144   36  150  143  36.800002  149.885652  144.892741  13.799424  13.010173   \n",
       "145    8   95   60  12.335219   90.774065   57.975201   9.981602  16.001477   \n",
       "146   11   67   39  15.356538   76.465913   54.503527  10.326691  17.369161   \n",
       "147   11  126  110  17.960080  124.186672  109.148286  11.595740  18.228039   \n",
       "148   33  144  139  39.944007  141.424515  141.025377  10.676215  14.167174   \n",
       "149    9  119  100  15.996715  112.994878   96.157592  11.706584  18.298873   \n",
       "150   24  174  141  36.582607  150.103326  142.714043  16.989564  22.062279   \n",
       "151   16  131  124  22.819736  130.117106  129.003982  10.490318  17.332336   \n",
       "152   31  117  119  29.416169  119.110956  122.199360   9.421677  14.197605   \n",
       "153   11  136  127  18.751632  134.775424  129.795312  11.227805  15.337223   \n",
       "154   23  146  143  31.265635  141.690884  141.782986  11.320696  16.322770   \n",
       "155   22  121  134  23.573089  116.998954  126.090933   7.870220  18.825269   \n",
       "156   23  147  153  27.268471  138.136770  140.073028  13.145419  21.959314   \n",
       "157    9  136  117  15.653391  137.607414  131.098607   9.693635  21.195449   \n",
       "158   16  149  152  27.596619  151.423060  154.927335  11.084358  14.893223   \n",
       "159   13   23  107  24.811111   55.866667   65.822222  14.007851  37.168744   \n",
       "160   12  134  117  23.470856  135.304891  129.731314  12.672782  21.675059   \n",
       "161   14  109  125  15.484116   99.272116  114.378888   3.861035  29.722315   \n",
       "162    0    0    0   0.000000    0.000000    0.000000   0.000000   0.000000   \n",
       "163   22  135  137  26.805131  117.235343  121.602702  11.153041  20.361037   \n",
       "164   26  143  128  32.021844  137.463988  125.939292  12.209761  15.358791   \n",
       "165   33  144  139  39.944007  141.424515  141.025377  10.676215  14.167174   \n",
       "\n",
       "          stdR  MoB2 ...   Ncont    MinArea  MaxArea  ContConv        MinPer  \\\n",
       "1    14.660467    33 ...      10     1680.0      2.0         3      5.656854   \n",
       "2    15.631453    53 ...      20     2416.0      0.5         4      5.656854   \n",
       "3    14.882422    45 ...      23   274292.5     12.0         4     39.071068   \n",
       "4    14.698378    46 ...       6     1632.5      2.0         0    232.769552   \n",
       "5    13.041982    36 ...       2     1564.5   1141.0         0  21270.147797   \n",
       "6    12.454426    54 ...       5      533.5     17.0         0    737.587874   \n",
       "7    14.090948    46 ...      12     4951.0      4.5         1      2.000000   \n",
       "8    15.248684    45 ...      18   213695.0     14.5         1     43.455843   \n",
       "9    14.640946    56 ...      22   147412.5      1.0         5      7.656854   \n",
       "10   13.000197    37 ...       7     1227.5     11.0         0    122.183765   \n",
       "11   15.077189    39 ...      89   271608.5      0.5        14      2.000000   \n",
       "12   14.150773    36 ...      10    13817.0      1.0         2      9.071068   \n",
       "13   14.423229    41 ...       2     1496.0   1085.5         0  10506.189271   \n",
       "14   10.948105    39 ...       7     1284.5      3.5         0    114.284271   \n",
       "15   12.768883    54 ...      11      569.0      2.0         2      5.656854   \n",
       "16   12.684399    65 ...      15     2203.5     22.5         3      2.000000   \n",
       "17   14.164429    51 ...      12     2250.0      0.5         0     38.242641   \n",
       "18   13.673442    43 ...       7  1270875.5     50.0         2      9.656854   \n",
       "19   15.390712    48 ...       6     2303.0      3.5         2     37.071068   \n",
       "20   16.995987    51 ...       2     2099.5   2099.5         0      9.656854   \n",
       "21   16.979182    37 ...       3     1792.5    177.5         0   2325.578980   \n",
       "22   11.069914    40 ...       4     1179.0      9.5         0    372.350286   \n",
       "23   12.889688    44 ...       4     1577.5     19.0         0    505.646748   \n",
       "24   11.700731    40 ...      19     1588.0      2.0         2      2.000000   \n",
       "25   13.536215    35 ...      26     1171.0      1.0         2     37.071068   \n",
       "26   13.679444    37 ...       9     1474.5      5.5         0    344.551296   \n",
       "27   13.065646    35 ...      10     1967.0     16.5         0     59.313708   \n",
       "28   12.904499    44 ...      11     1714.0      2.0         2     41.071068   \n",
       "29   12.633068    61 ...      13     2186.0      5.5         3      9.071068   \n",
       "30   14.141881    41 ...       1    18010.0      1.0         2   2747.000000   \n",
       "..         ...   ... ...     ...        ...      ...       ...           ...   \n",
       "136  22.227150    96 ...      64   474711.0      0.5        11      2.000000   \n",
       "137  24.951241    95 ...      68   161699.0      0.5        11      2.000000   \n",
       "138  21.774423   111 ...      73     4026.0      1.0        17     37.071068   \n",
       "139  17.004569   119 ...     129   262660.0      1.0        18      2.000000   \n",
       "140  16.799384    95 ...      42   406796.0      1.0         1      4.000000   \n",
       "141  21.062420   118 ...     115    26664.0      0.5        12      2.000000   \n",
       "142  25.613779    96 ...      65   589182.5      0.5         8      2.828427   \n",
       "143  27.097623   115 ...      48     2164.0      1.0         8      4.828427   \n",
       "144  12.108080   135 ...     257     3143.0      0.5        35      2.000000   \n",
       "145  17.493420    75 ...       6     1255.0     77.5         0     26.142135   \n",
       "146  22.102412    52 ...     120     8780.5      0.5        17      2.000000   \n",
       "147  17.636433   106 ...       8    31616.5   4767.0         0    402.014280   \n",
       "148  13.439349   128 ...      44    23162.5      0.5        12      2.000000   \n",
       "149  18.648601   102 ...       9    16911.5    121.5         0    321.338094   \n",
       "150  22.059466   136 ...      18    16379.5      0.5         2      2.000000   \n",
       "151  18.095845   116 ...      40    38740.5      0.5         8      2.000000   \n",
       "152  15.798534   107 ...      25    20975.5      1.0         3      2.000000   \n",
       "153  15.568320   119 ...      12    29793.0    287.0         0     67.941126   \n",
       "154  17.433085   130 ...      47    24640.0      0.5         2      2.000000   \n",
       "155  17.676764   113 ...      70     7890.0      0.5        13      2.000000   \n",
       "156  24.177682   137 ...       9     4744.5      2.0         2      5.656854   \n",
       "157  24.615177   117 ...      17    19043.0      0.5         1     11.071068   \n",
       "158  15.256196   136 ...      17     1020.5     37.5         4     41.071068   \n",
       "159  33.137618    24 ...       0        0.0      0.0         0      0.000000   \n",
       "160  21.862498   118 ...       6    20525.0     47.0         0    123.112698   \n",
       "161  31.539818   103 ...      14     1747.0      1.0         4      7.656854   \n",
       "162   0.000000     0 ...       0        0.0      0.0         0      0.000000   \n",
       "163  21.658117   115 ...      21     2232.0      0.5         1      2.000000   \n",
       "164  16.271666   128 ...      10    19387.0   4896.0         0    467.955405   \n",
       "165  13.439349   128 ...      44    23162.5      0.5        12      2.000000   \n",
       "\n",
       "          MaxPeri  type          var2          var3  var  \n",
       "1    25850.065742     1           NaN           NaN  NaN  \n",
       "2    34499.553223     1           NaN           NaN  NaN  \n",
       "3    10050.748945     1           NaN           NaN  NaN  \n",
       "4    22558.653270     1           NaN           NaN  NaN  \n",
       "5    24815.062434     1           NaN           NaN  NaN  \n",
       "6    14307.055159     1           NaN           NaN  NaN  \n",
       "7    23527.950395     1           NaN           NaN  NaN  \n",
       "8    10838.032356     1           NaN           NaN  NaN  \n",
       "9    11659.604029     1           NaN           NaN  NaN  \n",
       "10   25605.912291     1           NaN           NaN  NaN  \n",
       "11    9959.456511     1           NaN           NaN  NaN  \n",
       "12   35544.759283     1           NaN           NaN  NaN  \n",
       "13   21957.870645     1           NaN           NaN  NaN  \n",
       "14   19514.851858     1           NaN           NaN  NaN  \n",
       "15    9541.994734     1           NaN           NaN  NaN  \n",
       "16   24406.536218     1           NaN           NaN  NaN  \n",
       "17   16257.869974     1           NaN           NaN  NaN  \n",
       "18   19132.747168     1           NaN           NaN  NaN  \n",
       "19   42288.477422     1           NaN           NaN  NaN  \n",
       "20   30156.926358     1           NaN           NaN  NaN  \n",
       "21   21068.928519     1           NaN           NaN  NaN  \n",
       "22   19026.909534     1           NaN           NaN  NaN  \n",
       "23   22001.176010     1           NaN           NaN  NaN  \n",
       "24   14431.583286     1           NaN           NaN  NaN  \n",
       "25   14830.572310     1           NaN           NaN  NaN  \n",
       "26   16960.105470     1           NaN           NaN  NaN  \n",
       "27   18657.624386     1           NaN           NaN  NaN  \n",
       "28   16442.166776     1           NaN           NaN  NaN  \n",
       "29   20249.291999     1           NaN           NaN  NaN  \n",
       "30    2747.000000     0  46134.581617  46134.581617    1  \n",
       "..            ...   ...           ...           ...  ...  \n",
       "136  14004.767923     3           NaN           NaN  NaN  \n",
       "137  12780.363477     3           NaN           NaN  NaN  \n",
       "138    760.457931     3           NaN           NaN  NaN  \n",
       "139   9417.126434     3           NaN           NaN  NaN  \n",
       "140   4831.287038     3           NaN           NaN  NaN  \n",
       "141   6399.715182     3           NaN           NaN  NaN  \n",
       "142  11526.693561     3           NaN           NaN  NaN  \n",
       "143    448.208150     3           NaN           NaN  NaN  \n",
       "144   8386.146975     3           NaN           NaN  NaN  \n",
       "145  25037.537604     3           NaN           NaN  NaN  \n",
       "146  11464.259494     3           NaN           NaN  NaN  \n",
       "147   1384.531086     4           NaN           NaN  NaN  \n",
       "148   2256.052945     4           NaN           NaN  NaN  \n",
       "149   1795.055031     4           NaN           NaN  NaN  \n",
       "150   1035.928059     4           NaN           NaN  NaN  \n",
       "151   3018.584032     4           NaN           NaN  NaN  \n",
       "152   1180.315796     4           NaN           NaN  NaN  \n",
       "153   1152.974738     4           NaN           NaN  NaN  \n",
       "154   2287.065137     4           NaN           NaN  NaN  \n",
       "155   2506.525155     4           NaN           NaN  NaN  \n",
       "156    952.631593     4           NaN           NaN  NaN  \n",
       "157    882.274166     4           NaN           NaN  NaN  \n",
       "158   2113.986929     4           NaN           NaN  NaN  \n",
       "159      0.000000     4           NaN           NaN  NaN  \n",
       "160   1276.548333     4           NaN           NaN  NaN  \n",
       "161    491.279218     4           NaN           NaN  NaN  \n",
       "162      0.000000     4           NaN           NaN  NaN  \n",
       "163    943.685411     4           NaN           NaN  NaN  \n",
       "164   1092.655975     4           NaN           NaN  NaN  \n",
       "165   2256.052945     4           NaN           NaN  NaN  \n",
       "\n",
       "[165 rows x 35 columns]"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "columns = ['MoB', 'MoG','MoR', 'MeB','MeG', 'MeR','sdtB',\n",
    "           'stdG','stdR','MoB2', 'MoG2','MoR2', 'MeB2','MeG2',\n",
    "           'MeR2','sdtB2', 'stdG2','stdR2','hu1','hu2','hu3',\n",
    "           'hu4','hu5','hu6','hu7','Ncont','MinArea','MaxArea',\n",
    "           'ContConv','MinPer','MaxPeri','type','var2','var3','var']\n",
    "\n",
    "df = pd.DataFrame(data=features, columns=columns)\n",
    "df.drop(df.index[[0]], inplace=True)\n",
    "df.to_csv('dataFrame.csv',index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "def ExtracionDeCarateristicas(img,target):\n",
    "    imgYCC = cv2.cvtColor(img, cv2.COLOR_BGR2YCR_CB)\n",
    "    Gausianas = cv2.GaussianBlur(cv2.cvtColor(imgYCC, cv2.COLOR_BGR2GRAY),(5,5),0)\n",
    "    ret,umbralizada = cv2.threshold(Gausianas,120,255,cv2.THRESH_BINARY_INV)\n",
    "    Enmascarada = cv2.bitwise_and(img,img, mask = umbralizada)\n",
    "    # Se comienza sacar carateristicas \n",
    "\n",
    "    caracteristicas = np.array([])\n",
    "    # ----------------------------------- Canal RGB -------------------------------------------------\n",
    "    for i, col in enumerate(['B', 'G', 'R']):\n",
    "        hist = cv2.calcHist([img], [i], umbralizada, [255], [1, 255])\n",
    "        caracteristicas = np.append(caracteristicas, np.argmax(hist))\n",
    "    # Ademas del calculo del histograma se optiene la media y desviacion estandar del canal     \n",
    "    mean, sdk = cv2.meanStdDev(img,mask = umbralizada)\n",
    "    caracteristicas = np.append(caracteristicas,mean)\n",
    "    caracteristicas = np.append(caracteristicas,sdk)\n",
    "\n",
    "    # ----------------------------------- Canal YCBYR -----------------------------------------------\n",
    "    # Extraccion canal YCBYR moda media y desviacion estandar\n",
    "    for i, col in enumerate(['Y', 'B', 'R']):\n",
    "        hist = cv2.calcHist([imgYCC], [i], umbralizada, [256], [1, 255])\n",
    "        caracteristicas = np.append(caracteristicas, np.argmax(hist))   \n",
    "\n",
    "    # Ademas del calculo del histograma se optiene la media y desviacion estandar del canal     \n",
    "    mean, sdk = cv2.meanStdDev(imgYCC,mask = umbralizada)\n",
    "    caracteristicas = np.append(caracteristicas,mean)\n",
    "    caracteristicas = np.append(caracteristicas,sdk)\n",
    "\n",
    "    # ---------------------------------- Momentos de  HU-------------------------------------------    \n",
    "    # se calculan los momentos de Hu \n",
    "    moments = cv2.moments(umbralizada)\n",
    "    huMoments = cv2.HuMoments(moments)\n",
    "    caracteristicas = np.append(caracteristicas,huMoments)\n",
    "\n",
    "    image = img\n",
    "    bordes = [40]\n",
    "    contornos = [40]\n",
    "    kernel = np.ones((10,10),np.uint8)\n",
    "\n",
    "    erosion = cv2.erode(umbralizada,kernel,iterations = 1)\n",
    "    dilation = cv2.dilate(erosion,kernel,iterations = 1)\n",
    "    canny = cv2.Canny(dilation,0,300)\n",
    "    countorns,hierarchy = cv2.findContours(canny, cv2.RETR_TREE, cv2.CHAIN_APPROX_SIMPLE)\n",
    "    caracteristicas = np.append(caracteristicas,np.shape(countorns)) # 26 numero de contornos\n",
    "   \n",
    "    maxArea =0\n",
    "    cont = 0\n",
    "    maxArc = 0\n",
    "    for i in range (0, len(countorns)):\n",
    "        if (cv2.contourArea(countorns[i]) > maxArea ):\n",
    "            maxArea = cv2.contourArea(countorns[i])\n",
    "        if (cv2.arcLength(countorns[i],True)>maxArc):\n",
    "            maxArc=cv2.arcLength(countorns[i],True)\n",
    "\n",
    "    minArea = maxArea\n",
    "    minArc = maxArc\n",
    "    for i in range (0, len(countorns)):\n",
    "        if (cv2.contourArea(countorns[i]) < minArea  and cv2.contourArea(countorns[i]) != 0):\n",
    "            minArea = cv2.contourArea(countorns[i])\n",
    "        if (cv2.arcLength(countorns[i],True) < minArc  and cv2.arcLength(countorns[i],True) != 0):\n",
    "            minArc = cv2.arcLength(countorns[i],True);\n",
    "        if (cv2.isContourConvex(countorns[i]) ):\n",
    "            cont = cont + 1 \n",
    "\n",
    "    caracteristicas = np.append(caracteristicas,maxArea)\n",
    "    caracteristicas = np.append(caracteristicas,minArea)\n",
    "    caracteristicas = np.append(caracteristicas,cont)\n",
    "    caracteristicas = np.append(caracteristicas,minArc)\n",
    "    caracteristicas = np.append(caracteristicas,maxArc)\n",
    "    caracteristicas = np.append(caracteristicas,target)\n",
    "    return caracteristicas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "def imprimirImagen(img1):\n",
    "    plt.imshow(img1,cmap=plt.cm.gray)\n",
    "    plt.subplots_adjust(top=1.00, bottom=0.05, left=0.30, right=1.2 )\n",
    "    plt.show()\n",
    "    \n",
    "def imprimirDosImagenes(img1,img2):\n",
    "    plt.subplot(1,2,1), plt.imshow(img1,cmap=plt.cm.gray)\n",
    "    plt.subplot(1,2,2), plt.imshow(img2,cmap=plt.cm.gray)\n",
    "    plt.subplots_adjust(top=1.00, bottom=0.05, left=0.30, right=1.2 )\n",
    "    plt.show()\n",
    "    \n",
    "def imprimirTresImagenes(img1,img2,img3):\n",
    "    plt.subplot(1,3,1), plt.imshow(img1,cmap=plt.cm.gray)\n",
    "    plt.subplot(1,3,2), plt.imshow(img2,cmap=plt.cm.gray)\n",
    "    plt.subplot(1,3,3), plt.imshow(img3,cmap=plt.cm.gray)\n",
    "    plt.subplots_adjust(top=1.00, bottom=0.05, left=0.1, right=1.2 )\n",
    "    plt.show()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}