notebook/2 - Dados de bens.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "pd.set_option('display.max_colwidth', 500)\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df = pd.read_csv('../dados/bem_candidato_2016_CE.txt', \n",
    "                 encoding='ISO-8859-1', \n",
    "                 sep=';', \n",
    "                 names=[\"DATA_GERACAO\", \"HORA_GERACAO\", \"ANO_ELEICAO\", \"DESCRICAO_ELEICAO\", \n",
    "                         \"SIGLA_UF\", \"SQ_CANDIDATO\", \"CD_TIPO_BEM_CANDIDATO\", \"TIPO_BEM_CANDIDATO\", \n",
    "                         \"DS_TIPO_BEM_CANDIDATO\", \"VALOR_BEM\", \"DATA_ULTIMA_ATUALIZACAO\", \n",
    "                         \"HORA_ULTIMA_ATUALIZACAO\"],\n",
    "                 usecols=[\"SQ_CANDIDATO\", \"TIPO_BEM_CANDIDATO\", \"DS_TIPO_BEM_CANDIDATO\", \"VALOR_BEM\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "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>SQ_CANDIDATO</th>\n",
       "      <th>TIPO_BEM_CANDIDATO</th>\n",
       "      <th>DS_TIPO_BEM_CANDIDATO</th>\n",
       "      <th>VALOR_BEM</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>60000001105</td>\n",
       "      <td>Veículo automotor terrestre: caminhão, automóvel, moto, etc.</td>\n",
       "      <td>UMA MOTO HONDA BIZ 2005</td>\n",
       "      <td>2000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   SQ_CANDIDATO                                            TIPO_BEM_CANDIDATO  \\\n",
       "0   60000001105  Veículo automotor terrestre: caminhão, automóvel, moto, etc.   \n",
       "\n",
       "     DS_TIPO_BEM_CANDIDATO  VALOR_BEM  \n",
       "0  UMA MOTO HONDA BIZ 2005     2000.0  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>224</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>SQ_CANDIDATO</th>\n",
       "      <td>60000001239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TIPO_BEM_CANDIDATO</th>\n",
       "      <td>Aplicação de renda fixa (CDB, RDB e outros)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DS_TIPO_BEM_CANDIDATO</th>\n",
       "      <td>EMPRESTIMO AO MEU FILHO YURI DIAS PORTO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VALOR_BEM</th>\n",
       "      <td>50000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                               224\n",
       "SQ_CANDIDATO                                           60000001239\n",
       "TIPO_BEM_CANDIDATO     Aplicação de renda fixa (CDB, RDB e outros)\n",
       "DS_TIPO_BEM_CANDIDATO      EMPRESTIMO AO MEU FILHO YURI DIAS PORTO\n",
       "VALOR_BEM                                                    50000"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sample(1).T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count               26,155.0\n",
       "mean     64,866.171179889076\n",
       "std      267,550.16069688706\n",
       "min                     0.01\n",
       "25%                  6,000.0\n",
       "50%                 20,000.0\n",
       "75%                57,044.44\n",
       "max             20,000,000.0\n",
       "Name: VALOR_BEM, dtype: object"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.VALOR_BEM.describe().apply(lambda x: \"{:,}\".format(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.text.Text at 0x7f418483d400>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAA7oAAAHvCAYAAAB62KMAAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3X+0ZWdZJ/jvAxGCNlBot7nLRHMRiAYaKGMbsNHmtkj4\n0WNgqYPRnoFCWnsJCmgvhwRXN6yePzQ4jqI9OO0SEVxgROwRbGP4MXDsZpQfDRSJJEAUKyRx5Tr+\nKLptuzOEvPPHOUWdVOree27dc8/eZ+/PZ62zct+999nvcypvvbWfu99nn2qtBQAAAIbiAV0HAAAA\nAMsk0QUAAGBQJLoAAAAMikQXAACAQZHoAgAAMCgSXQAAAAblUBPdqnp9VW1X1Y1z255YVX9YVR+r\nqg9V1T+Y23dNVd1aVbdU1RVz2y+rqhur6tNV9XOHGTMAAADr7bDv6L4hyTPO2PaaJK9qrX1Dklcl\n+ekkqarHJnlekkuTPCvJ66qqZu/5xSQvaq1dkuSSqjrznAAAAJDkkBPd1tr7k/z1GZvvTfLw2c9H\nktw5+/nKJNe11u5prZ1IcmuSy6tqI8lDW2sfnh33piTPPcy4AQAAWF/nddDnjyZ5Z1X9TJJK8g9n\n2y9M8odzx90523ZPkjvmtt8x2w4AAAD300Wi+0NJXtZa++2q+u4kv5Lk6cs6eVW1ZZ0LAACA/mmt\n1W77u0h0X9Bae1mStNbeVlW/PNt+Z5Kvnjvuotm2nbbvqDW5Luvt1a9+dV796ld3HQYcmLHMEBjH\nDIWxzFCcfpTTzlbx9UI1e51yZ1U9NUmq6mmZ1uImyTuSXFVVD6qqRyZ5dJIPtdbuSvK5qrp89nCq\n5yd5+wrihs6cOHGi6xBgKYxlhsA4ZiiMZcbkUO/oVtVbkmwl+Yqq+mymT1n+gSQ/X1UPTPLfk/xg\nkrTWbq6qtya5Ocnnk7y4nb41+5Ikv5rk/CTXt9ZuOMy4AQBINjY2s7192477L7jg4tx114nVBQSw\noBraMt+qakP7TIzPZDLJ1tZW12HAgRnLDMGYx/F0Md1u11WlZGyNjHksMyxVtWeNrkQXAICzkugC\nfbRIoruKGl1gnyaTSdchwFIYywyBccxQGMuMiUQXAACAQbF0GQCAs7J0GegjS5cBAAAYHYku9JAa\nGobCWGYIjGOGwlhmTCS6AAAADIoaXQAAzkqNLtBHanQBAAAYHYku9JAaGobCWGYIjGOGwlhmTCS6\nAAAADIoaXQAAzkqNLtBHanQBAAAYHYku9JAaGobCWGYIjGOGwlhmTCS6AAAADIoaXQAAzkqNLtBH\nanQBAHpoY2MzVbXja2Njs+sQAdaaRBd6SA0NQ2EsMwSHMY63t2/L9E7p2V/T/bBc5mTGRKILAADA\noKjRBQBYsXWpfV2XOIFxUaMLAADA6Eh0oYfU0DAUxjJDYBwzFMYyYyLRBQAAYFDU6AIArNi61L6u\nS5zAuKjRBQAAYHQkutBDamgYCmOZITCOGQpjmTGR6AIAADAoanQBAFZsXWpf1yVOYFzU6AIAADA6\nEl3oITU0DIWxzBAYxwyFscyYSHQBAAAYFDW6AAArti61r+sSJzAuanQBAAAYHYku9JAaGobCWGYI\njGOGwlhmTCS6AAAADIoaXQCAFVuX2td1iRMYFzW6AAAAjI5EF3pIDQ1DYSwzBMYxQ2EsMyYSXQAA\nAAZFjS4AwIqtS+3rusQJjIsaXQAAAEbnUBPdqnp9VW1X1Y1nbP+Rqrqlqm6qqp+a235NVd0623fF\n3PbLqurGqvp0Vf3cYcYMfaCGhqEwlhkC45ihMJYZk8O+o/uGJM+Y31BVW0m+I8njW2uPT/K/zbZf\nmuR5SS5N8qwkr6vpepkk+cUkL2qtXZLkkqq6zzkBAADglEOv0a2qi5P8TmvtCbP2byT5t621955x\n3NVJWmvt2ln795K8OsltSd7bWnvsbPtVSZ7aWvuhHfpTowsA9Nq61L6uS5zAuPS1RveSJP+oqj5Q\nVe+rqm+cbb8wye1zx90523Zhkjvmtt8x2wYAAAD3c15HfT6itfbkqvqmJL+Z5GuX2cGxY8eyubmZ\nJDly5EiOHj2ara2tJKdrE7S1+9w+ta0v8Whrn2v7+PHjefnLX96beLS1z6V96udlnn9qkmRr7ufM\ntafv6frz3zfW+fjuu79P/7+0d///OT+mu45HW3vR9vHjx3Py5MkkyYkTJ7KILpYuX5/k2tba78/a\ntyZ5cpIfSJLW2k/Ntt+Q5FWZLl1+X2vt0tl2S5cZvMncxQ2sM2OZITiMcbwuS4LXJU4WY05mKBZZ\nuryKRHcz00T38bP2Dya5sLX2qqq6JMm7W2sXV9Vjk7w5yZMyXZr87iSPaa21qvpAkpcm+XCS303y\n8621G3boT6ILAPTauiSQ6xInMC6LJLqHunS5qt6S6RqXr6iqz2Z6h/ZXkryhqm5KcneS5ydJa+3m\nqnprkpuTfD7Ji+cy1pck+dUk5ye5fqckFwAAAA79ju6quaPLEFhaxFAYywyBpcv9j5PFmJMZir4+\ndRkAAAAOjTu6AAArti53StclTmBc3NEFAABgdCS60EPz33cH68xYZgj6Oo43NjZTVTu+NjY2uw6R\nnunrWIbDcKhPXQYA4HBsb9+W3ZYVb2/vuqoPYNDU6AIArNgyal9XUT+rRhfoIzW6AAAAjI5EF3pI\nDQ1DYSwzBMYxQ2EsMyYSXQAAAAZFjS4AwIqp0QU4d2p0AQAAGB2JLvSQGhqGwlhmCIxjhsJYZkwk\nugAAAAyKGl0AgBVTowtw7tToAgAAMDoSXeghNTQMhbHMEBjHDIWxzJhIdAEAABgUNboAACumRhfg\n3KnRBQAAYHQkutBDamgYCmOZITCOGQpjmTGR6AIADNKDU1U7vjY2NrsOEODQqNEFAFixVdXorkMd\nMMB+qdEFAABgdCS60ENqaBgKY5khMI4ZCmOZMZHoAgAAMChqdAEAVkyNLsC5U6MLAADA6Eh0oYfU\n0DAUxjJDYBwzFMYyYyLRBQAAYFDU6AIArJgaXYBzp0YXAACA0ZHoQg+poWEojGWGwDhmKIxlxuS8\nrgMAAOiTjY3NbG/ftuP+Cy64OHfddWJ1AQGwb2p0AQDmLKMuda9keUqNLsC5WKRGV6ILADBnSA+K\nkugCQ+RhVLCm1NAwFMYywzDpOgBYCnMyYyLRBQAAYFAsXQYAmGPp8v76cN0FrJqlywAAAIyORBd6\nSA0NQ2EsMwyTrgOApTAnMyaHmuhW1euraruqbjzLvn9RVfdW1ZfPbbumqm6tqluq6oq57ZdV1Y1V\n9emq+rnDjBkAAID1dqg1ulX1LUn+JsmbWmtPmNt+UZJfTvJ1Sb6xtfZXVXVpkrck+aYkFyV5T5LH\ntNZaVX0wyQ+31j5cVdcneW1r7Z079KlGFwA4Z2p099eH6y5g1Tqv0W2tvT/JX59l188m+fEztj0n\nyXWttXtaayeS3Jrk8qraSPLQ1tqHZ8e9KclzDylkAAAA1tzKa3Sr6sokt7fWbjpj14VJbp9r3znb\ndmGSO+a23zHbBoOlhoahMJYZhknXAcBSmJMZk/NW2VlVPSTJK5M8fZX9AgAAMB4rTXSTPCrJZpKP\n17To46IkH62qyzO9g/s1c8deNNt2Z5KvPsv2HR07diybm5tJkiNHjuTo0aPZ2tpKcvo3Wdra2tra\nq2mf0pd4tLUXaSeT2X+3Zq/59iLvP3WOs51vsf2TyWThv1/3f//+9h/0/F3//9LW1h52+/jx4zl5\n8mSS5MSJE1nEoT6MKkmqajPJ77TWHn+WfX+a5LLW2l9X1WOTvDnJkzJdmvzunH4Y1QeSvDTJh5P8\nbpKfb63dsEN/HkYFAJwzD6PaXx+uu4BV6/xhVFX1liR/kOSSqvpsVb3wjENaprNwWms3J3lrkpuT\nXJ/kxXMZ60uSvD7Jp5PculOSC0Nx6jdZsO6MZZZtY2MzVbXra2Njc8m9TpZ8PuiGOZkxOdSly621\n79tj/9ee0f7JJD95luM+kuR+d4QBgHHZ3r4tu99hTLa3d/0lPwAjcOhLl1fN0mUAGK69l9ImB11O\na+ny/vpw3QWsWudLlwEAAGDVJLrQQ2poGApjmWGYdB0ALIU5mTGR6AIAADAoanQBgLWhRrd/fbju\nAlZNjS4AAACjI9GFHlJDw1AYywzDpOsAYCnMyYyJRBcAAIBBUaMLAKwNNbr968N1F7BqanQBAAAY\nHYku9JAaGobCWGYYJl0HAEthTmZMJLoAAAAMihpdAGBtqNHtXx+uu4BVU6MLAADA6Eh0oYfU0DAU\nxjLDMOk6AFgKczJjItEFAABgUNToAgBrQ41u//pw3QWsmhpdAAAARkeiCz2khoahMJYZhknXAcBS\nmJMZE4kuAAAAg6JGFwBYG2p0+9eH6y5g1dToAgAAMDoSXeghNTQMhbHMMEy6DgCWwpzMmEh0AQAA\nGBQ1ugDA2lCj278+XHcBq6ZGFwAAgNGR6EIPqaFhKIxlhmHSdQCwFOZkxkSiCwAAwKCo0QUA1oYa\n3f714boLWDU1ugAAAIyORBd6SA0NQ2EsMwyTrgOApTAnMyYSXQAAAAZFjS4AsDbU6PavD9ddwKqp\n0QUAAGB0JLrQQ2poGApjmWGYdB0ALIU5mTGR6AIAADAoanQBgLWhRrd/fbjuAlZtkRrd81YVDAAA\ni3rwLMkE4FxYugw9pIaGoTCWGYZJB33enemd1N1esD/mZMZEogsAAMCgqNEFANbGmGp0F/mcanSB\nMer8e3Sr6vVVtV1VN85te01V3VJVx6vqt6rqYXP7rqmqW2f7r5jbfllV3VhVn66qnzvMmAEAAFhv\nh710+Q1JnnHGtncleVxr7WiSW5NckyRV9dgkz0tyaZJnJXldnX4Kwy8meVFr7ZIkl1TVmeeEQVFD\nw1AYywzDpOsAYCnMyYzJoSa6rbX3J/nrM7a9p7V276z5gSQXzX6+Msl1rbV7WmsnMk2CL6+qjSQP\nba19eHbcm5I89zDjBgAAYH11/TCq709y/eznC5PcPrfvztm2C5PcMbf9jtk2GKytra2uQ4ClMJbH\nZWNjM1W162tjY7PrMM/BVtcBwFKYkxmTzr5Ht6p+IsnnW2u/vuxzHzt2LJubm0mSI0eO5OjRo1/8\ni31qyYa2tra2trb2ctvb27fl9IOLJrP/bt2nvb39jw/U32lnP/+p9kE/z0HPf/o9O53voPsnua+D\n7T/3P+/d36+tra29jPbx48dz8uTJJMmJEyeyiEN/6nJVXZzkd1prT5jbdizJDyT5ttba3bNtVydp\nrbVrZ+0bkrwqyW1J3tdau3S2/aokT22t/dAO/XnqMmtvMpl88S83rDNjeVz68UTkw+hjkvsmoJ66\nvJ9z0B/mZIai86cun4pj9po2qp6Z5MeTXHkqyZ15R5KrqupBVfXIJI9O8qHW2l1JPldVl88eTvX8\nJG9fQdwAAACsoUO9o1tVb8n0V6BfkWQ70zu0r0zyoCR/OTvsA621F8+OvybJi5J8PsnLWmvvmm3/\nxiS/muT8JNe31l62S5/u6AJAB4Z7R3f/53dHF+DwLHJH99CXLq+aRBcAutGPJHQVfUh093MOgGXr\ny9JlYJ9OFeHDujOWGYZJ1wHAUpiTGROJLgAAAINi6TIAsBT9WFa8ij4sXd7POQCWzdJlAAAARkei\nCz2khoahMJYZhknXAcBSmJMZE4kuAAAAg6JGFwBYin7Uz66iDzW6+zkHwLKp0QUAAGB0JLrQQ2po\nGApjmWGYdB0ALIU5mTGR6AIAADAoanQBgKXoR/3sKvpQo7ufcwAsmxpdAAAARkeiCz2khoahMJYZ\nhknXAcBSmJMZE4kuAAAAg6JGFwBYin7Uz66iDzW6+zkHwLKp0QUAAGB0JLrQQ2poGApjmWGYdB0A\nLIU5mTGR6AIAADAoanQBgKXoR/3sKvpQo7ufcwAsmxpdAAAARkeiCz2khoahMJYZhknXAcBSmJMZ\nE4kuAAAAg6JGFwBYin7Uz66iDzW6+zkHwLKp0QUAAGB0JLrQQ2poGApjmWGYdB0ALIU5mTGR6AIA\nADAoanQBgKXoR/3sKvpQo7ufcwAsmxpdAAAARkeiCz2khoahMJYZhknXAcBSmJMZE4kuAAAAg6JG\nFwBYin7Uz66iDzW6+zkHwLKp0QUAAGB0JLrQQ2poGApjmWGYdB0ALIU5mTGR6AIAADAoanQBgKXo\nR/3sKvpQo7ufc+xmY2Mz29u37XrMBRdcnLvuOnHOfQDDs0iNrkQXAFiKfiShSXJ+krt33LtX4iTR\nnTvikBPdVYwZYHg8jArWlBoahsJYpht3Z5o8nf211x3E+5ssNTroijmZMZHoAgAAMCiWLgMAS9Gf\npcsHW25r6fLcEZYuAz1k6TIAAACjI9GFHlJDw1AYywzDpOsAYCnMyYzJoSa6VfX6qtquqhvntj2i\nqt5VVZ+qqndW1cPn9l1TVbdW1S1VdcXc9suq6saq+nRV/dxhxgwAAMB6O9Qa3ar6liR/k+RNrbUn\nzLZdm+QvW2uvqapXJHlEa+3qqnpskjcn+aYkFyV5T5LHtNZaVX0wyQ+31j5cVdcneW1r7Z079KlG\nFwA6oEZ3f+cYQ43uIt+Tq0YX2K/Oa3Rba+9P8tdnbH5OkjfOfn5jkufOfr4yyXWttXtaayeS3Jrk\n8qraSPLQ1tqHZ8e9ae49AAD01DTJ3fmrngAOSxc1ul/ZWttOktbaXUm+crb9wiS3zx1352zbhUnu\nmNt+x2wbDJYaGobCWGYYJl0HAEthTmZMzus6gBzCr/OOHTuWzc3NJMmRI0dy9OjRbG1tJTn9F1xb\nu8/tU/oSj7b2ubaPHz/eq3i0Vzd/nU4Ot85o55DPv1h7r/4O/v5T79npfAfdP8l9HWz/Yf3/PHh8\n9z1f1+N73dun9CUebe1F28ePH8/JkyeTJCdOnMgiDv17dKvq4iS/M1eje0uSrdba9mxZ8vtaa5dW\n1dVJWmvt2tlxNyR5VZLbTh0z235Vkqe21n5oh/7U6AJAB9To7u8cY6jRPfifw959AOPTeY3uqThm\nr1PekeTY7OcXJHn73ParqupBVfXIJI9O8qHZ8ubPVdXlNZ0tnz/3HgAAALiPQ010q+otSf4gySVV\n9dmqemGSn0ry9Kr6VJKnzdpprd2c5K1Jbk5yfZIXz92afUmS1yf5dJJbW2s3HGbc0LUzlxjBujKW\nGYZJ1wHAUpiTGZNDrdFtrX3fDru+fYfjfzLJT55l+0eSPH6JoQEAADBQh16ju2pqdAGgG2p093cO\nNbqLxLh3H8D49KVGFwAAAFZGogs9pIaGoTCWGYZJ1wHAUpiTGROJLgAAAIOiRhcAWAo1uvs7hxrd\nRWLcuw9gfNToAgAAMDoSXeghNTQMhbHMMEy6DgCWwpzMmCyU6FbVy6rqYTX1+qr6aFVdcdjBAQAA\nwH4tVKNbVR9vrT2xqp6R5J8n+ZdJfq21dtlhB7hfanQBoBtqdPd3DjW6i8S4dx/A+CyzRvfUSZ6d\naYL7ibltAAAA0BuLJrofqap3ZZrovrOqHprk3sMLC8ZNDQ1DYSwzDJOuA4ClMCczJucteNyLkhxN\n8pnW2t9W1VckeeHhhQUAAADnZuHv0a2qC5NcnLnkuLX2Hw4prnOmRhcAuqFGd3/nUKO7SIx79wGM\nzyI1ugvd0a2qa5N8T5Kbk3xhtrkl6V2iCwAAwLgtWqP73CRf11p7dmvtO2avKw8zMBgzNTQMhbHM\nMEy6DgCWwpzMmCya6H4myZccZiAAAACwDIt+j+5vJXlikv87yd2ntrfWXnp4oZ0bNboA0A01uvs7\nhxrdRWLcuw9gfJZWo5vkHbMXAAAA9NpCS5dba29M8tYkH2itvfHU63BDg/FSQ8NQGMsMw6TrAGAp\nzMmMyUKJblV9R5LjSW6YtY9WlTu8AAAA9M6iNbofSfJtSSattW+Ybfuj1trfP+T49k2NLgB0Q43u\n/s6hRneRGPfuAxifRWp0F33q8udba587Y9u95xYWAAAAHJ5FE91PVNX3JXlgVT2mqn4hyR8cYlww\nampoGApjmWGYdB0ALIU5mTFZNNH9kSSPy/SrhX49yX9O8vLDCgoAAADO1UI1ul88uOphSVpr7b8c\nXkgHo0YXALqxjBrdjY3NbG/ftsc51Ogu5xxqdIH1tLQa3ar6pqq6KcmNSW6qqo9X1TcuI0gAgFOm\nSW7b5QUAe1t06fLrk7y4tbbZWttM8pIkbzi0qGDk1NAwFMYywzDpOgBYCnMyY7JoovuF1tp/PNVo\nrb0/yT2HExIAAACcu11rdKvqstmPz0/ykEwfRNWSfE+S/95a+7FDj3Cf1OgCQDeWUaO7rJpONbqL\n7VejC6yjRWp090p037fLe1tr7dvONbjDItEFgG5IdPd3DonuIjHu3QcwPgd+GFVr7R+31v5xkvfO\n/fys2c+9S3JhKNTQMBTGMsMw6ToAWApzMmOya6JbVa+oqm9O8l1zm//gcEMCAACAc7fX0uXnJHlq\nkn+W5ONJPpnkiiRXtNY+tZII98nSZQDohqXL+zuHpcuLxLh3H8D4LON7dE8meWWSP06yleS1s+1X\nV5U7uwAAAPTOXonuM5L8bpJHJfnfkzwpyX9trb2wtfYPDzs4GCs1NAyFscwwTLoOAJbCnMyY7PUw\nqle21p6W5ESSX0vywCR/r6reX1W/s4L4AAAAYF92rdH94kFVr2mt/S+znz/WWvuGqvq7rbW/OPQI\n90mNLgB0Q43u/s6hRneRGPfuAxifA3+P7g4nfWJr7eMHiuwQSXQBoBsS3f2dQ6K7SIx79wGMzzIe\nRnU/fU5yYSjU0DAUxjLDMOk6AFgKczJjsu9EFwAAAPps30uXl9Zx1Y8meVGSe5PclOSFSb4syW8k\nuTjTB2A9r7X2udnx1yT5/iT3JHlZa+1dO5zX0mUA6ICly/s7h6XLi8S4dx/A+BzK0uVlqKqvSvIj\nSS5rrT0hyXlJvjfJ1Une01r7uiTvTXLN7PjHJnlekkuTPCvJ62o6cwIAAMB9dLl0+YFJvqyqzkvy\nkCR3JnlOkjfO9r8xyXNnP1+Z5LrW2j2ttRNJbk1y+WrDhdVRQ8NQGMsMw6TrAGApzMmMSSeJbmvt\nz5L8TJLPZprgfq619p4kF7TWtmfH3JXkK2dvuTDJ7XOnuHO2DQAAAO7jvC46raojmd69vTjJ55L8\nZlX909y/SOOcCjKOHTuWzc3NJMmRI0dy9OjRbG1tJTn9myxtbW1t7dW0T+lLPNqH2z7tVHvrjHaW\n8v6d9y/SfnD2roCaP37rfufb68/j9Dl2iueg+ye5r4Pt7/v/z76Mb21t7W7ax48fz8mTJ5MkJ06c\nyCI6eRhVVX13kme01n5g1v6fkzw5ybcl2WqtbVfVRpL3tdYuraqrk7TW2rWz429I8qrW2gfPcm4P\nowKADqzTw6j68BCnPnzOg3+O85Pcves5PIwKWLbePowq0yXLT66q82cPlXpakpuTvCPJsdkxL0jy\n9tnP70hyVVU9qKoemeTRST602pBhdU79JgvWnbHMMEy6DqDH7s40Ud3pRZ+YkxmTTpYut9Y+VFVv\nS/KxJJ+f/feXkjw0yVur6vuT3Jbpk5bTWru5qt6aaTL8+SQvdtsWAACAs+nse3QPi6XLANANS5fn\njhjN0uXVfE7XdsC8Pi9dBgAAgEMh0YUeUkPDUBjLDMOk6wBgKczJjIlEFwAAgEFRowsALIUa3bkj\n1Oguaf/0GNd2wDw1ugAAAIyORBd6SA0NQ2EsMwyTrgOApTAnMyYSXQAAAAZFjS4AsBRqdOeOUKO7\npP3TY1zbAfPU6AIAADA6El3oITU0DIWxzDBMug4AlsKczJhIdAEAABgUNboAwFKo0Z07Qo3ukvZP\nj3FtB8xTowsAAMDoSHShh9TQMBTGMsMw6ToAWApzMmMi0QUAAGBQ1OgCAEuhRnfuCDW6S9o/Pca1\nHTBPjS4AAACjI9GFHlJDw1AYywzDpOsAYCnMyYzJeV0HAACwXh48W9ILQF+p0QUAlmJMNbrdx7Cc\nPtToAutIjS4AAACjI9GFHlJDw1AYywzDpOsAYCnMyYyJRBcAAIBBUaMLACyFGt3160ONLrCO1OgC\nAAAwOhJd6CE1NAyFscwwTLoOAJbCnMyYSHQBAAAYFDW6AMBSqNFdvz7U6ALrSI0uAAAAoyPRhR5S\nQ8NQGMsMw6TrAGApzMmMiUQXAACAQVGjCwAshRrd9etDjS6wjtToAgAAMDoSXeghNTQMhbHMMEy6\nDgCWwpzMmEh0AQBYWxsbm6mqHV8bG5tdhwh0QI0uALAUanTXr48h1OguEqNrQxgWNboAAACMjkQX\nekgNDUNhLDMMk64DgKUwJzMmEl0AAAAGRY0uALAUanTXrw81usA6UqMLAADA6HSW6FbVw6vqN6vq\nlqr6RFU9qaoeUVXvqqpPVdU7q+rhc8dfU1W3zo6/oqu4YRXU0DAUxjLDMOk6AFgKczJj0uUd3dcm\nub61dmmSJyb5ZJKrk7yntfZ1Sd6b5JokqarHJnlekkuTPCvJ62q6TgUAAADuo5Ma3ap6WJKPtdYe\ndcb2TyZ5amttu6o2kkxaa19fVVcnaa21a2fH/V6SV7fWPniWc6vRBYAOqNFdvz7U6ALrqM81uo9M\n8hdV9Yaq+mhV/VJVfWmSC1pr20nSWrsryVfOjr8wye1z779ztg0AAHbx4FTVrq+Njc2ugwSW7LwO\n+70syUtaa/+pqn4202XLZ/667Zx+/Xbs2LFsbm4mSY4cOZKjR49ma2sryenaBG3tPrdPbetLPNra\n59o+fvx4Xv7yl/cmHu3VzF9Tp9pbZ7SzlPfvvP8w2vN9L/r+U9sOa/98TOe6/0uyeCXYYfS/yP5p\ne6/xt/v7707yvl3Pv71dmUwmnf/9WcXfzy3XF9pr2D5+/HhOnjyZJDlx4kQW0dXS5QuS/GFr7Wtn\n7W/JNNF9VJKtuaXL72utXXqWpcs3JHmVpcsM1fw/trDOjOVxGe7S5Unum4AOZ+ly9330Z8yM4frR\nnMxQLLJ0ubPv0a2q30/yA621T1fVq5J86WzXX7XWrq2qVyR5RGvt6tnDqN6c5EmZLll+d5LHnC2j\nlegCQDcO4RFoAAAYIUlEQVSGm+j2MYah9NGfMeP6EdbHIoluV0uXk+SlSd5cVV+S5DNJXpjkgUne\nWlXfn+S2TJ+0nNbazVX11iQ3J/l8khfLZgEAADibzu7oHhZ3dBkCS4sYCmN5XIZ7R3cSS5e7jcEd\n3eUwJzMUfX7qMgAAABwKd3QBgCTJxsZmtrdv23H/BRdcnLvuOrHj/uHe0e1jDEPpoz9jxvUjrI9e\nP4zqsEh0AeDcLJIwHCzhWMY51ic508fyYpDoAvMsXYY1Nf99d7DOjGWGYdJ1ALAU5mTGRKILAADA\noFi6DAAksXR5efv1sdwYzk9y9x7HWLoMY9L379EFAIA93J29E1mA+7J0GXpIDQ1DYSwzDJOuA4Cl\nMCczJhJdAAAABkWNLgCQRI3u8vbrY71imB7j+hHWh68XAgAAYHQkutBDamgYCmOZYZh0HQAshTmZ\nMZHoAgAAMChqdAGAJGp0l7dfH+sVw/QY14+wPtToAgAAMDoSXeghNTQMhbHMMEy6DgCWwpzMmEh0\nAQAAGBQ1ugBAEjW6y9uvj/WKYXqM60dYH2p0AQAAGB2JLvSQGhqGwlhmGCZdBwBLYU5mTCS6AAAA\nDIoaXQAgiRrd5e3Xx3rFMD3G9SOsDzW6AAAAjI5EF3pIDQ1DYSwzDJOuA4ClMCczJhJdAAAABkWN\nLgCQRI3u8vbrY71imB7j+hHWxyI1uuetKhgAgOTBs2QWAA6PpcvQQ2poGApjmfu7O9O7azu9+mjS\ndQCwFOZkxkSiCwAAwKCo0QUAkqyuRnf9azr7EMNQ+uhDDNNjXD/C+vA9ugAAAIyORBd6SA0NQ2Es\nMwyTrgOApTAnMyYSXQAAAAZFjS4AkESN7nrFMJQ++hDD9BjXj7A+1OgCAAAwOhJd6CE1NAyFscww\nTLoOAJbCnMyYSHQBAAAYFDW6AEASNbrrFcNQ+uhDDNNjXD/C+lCjCwAAwOhIdKGH1NAwFMYywzDp\nOgBYCnMyY9JpoltVD6iqj1bVO2btR1TVu6rqU1X1zqp6+Nyx11TVrVV1S1Vd0V3UAAAA9FmnNbpV\n9aNJvjHJw1prV1bVtUn+srX2mqp6RZJHtNaurqrHJnlzkm9KclGS9yR5zNmKcdXoAsC5UaO7TjEM\npY8+xDA9xvUjrI9e1+hW1UVJnp3kl+c2PyfJG2c/vzHJc2c/X5nkutbaPa21E0luTXL5ikIFAABg\njXS5dPlnk/x47vsrtgtaa9tJ0lq7K8lXzrZfmOT2uePunG2DQVJDw1AYywzDpOsAYCnMyYxJJ4lu\nVf2TJNutteOZrifZiTUkAAAA7Mt5HfX7lCRXVtWzkzwkyUOr6teS3FVVF7TWtqtqI8mfz46/M8lX\nz73/otm2szp27Fg2NzeTJEeOHMnRo0eztbWV5PRvsrS1tbW1V9M+pS/xaO/ePu1Ue+uMdpby/sPb\nfxjtrXN4/6lth7V/kvsa6v5VtadjuOu/f9ra2mdvHz9+PCdPnkySnDhxIovo9GFUSVJVT03yL2YP\no3pNpg+junaHh1E9KdMly++Oh1EBwFJ5GNU6xTCUPvoQw/QY14+wPnr9MKod/FSSp1fVp5I8bdZO\na+3mJG9NcnOS65O8WDbLkN3/zgisJ2OZYZh0HQAshTmZMelq6fIXtdZ+P8nvz37+qyTfvsNxP5nk\nJ1cYGgAAAGuo86XLy2bpMgCcG0uX1ymGofTRhximx7h+hPWxjkuXAQAA4EAkutBDamgYCmOZYZh0\nHQAshTmZMZHoAgAAMChqdAGAJGp01yuGofTRhximx7h+hPWhRhcAAIDRkehCD6mhYSiMZYZh0nUA\nsBTmZMZEogsAAMCgqNEFAJKo0V2vGIbSRx9imB7j+hHWhxpdAAAARkeiCz2khoahMJYZhknXAcBS\nmJMZE4kuAAAAg6JGFwBIokZ3vWIYSh99iGF6jOtHWB9qdAEAABgdiS70kBoahsJYZhgmXQcAS2FO\nZkwkugAAAAyKGl0AIIka3fWKYSh99CGG6TGuH2F9qNEFAABgdCS60ENqaBgKY5lhmHQdACyFOZkx\nkegCAAAwKGp0AYAkanTXK4ah9NGHGKbHuH6E9aFGFwAAgNGR6EIPqaFhKIzl5dnY2ExV7fja2Njs\nOsQBm3QdACyFOZkxkegCwBrY3r4t0+WXZ39N9wPn5sF+kQQDo0YXANbAQetnV9GHGl19rGcMi53D\n9SX0hxpdAAA4MHd8Yd1IdKGH1NAwFMYywzDpOgA6d3eGUDpgTmZMJLoAAAAMihpdAFgDanQX3b+K\nPvoQw1D66EMMy+nD9SesjhpdAAAARkeiCz2khoahMJYZhknXAcBSmJMZE4kuAAAAg6JGFwDWgBrd\nRfevoo8+xDCUPvoQw3L6cP0Jq6NGFwAAgNGR6EIPqaFhKIxlhmHSdQCwFOZkxkSiCwAAwKCo0QWA\nNaBGd9H9q+ijDzEMpY8+xLCcPlx/wuqo0QUAAGB0JLrQQ2poGApjuT82NjZTVbu+2Mmk6wBgKczJ\njMl5XQcAABy+7e3bstjyTQBYf2p0AWAN9KV+Vo1uX2IYSh99iGEZ5zg/yd279nDBBRfnrrtO7BEH\nsIje1uhW1UVV9d6q+kRV3VRVL51tf0RVvauqPlVV76yqh8+955qqurWqbqmqK7qIGwAA7u/uTBPh\nnV/TVRXAqnRVo3tPkh9rrT0uyTcneUlVfX2Sq5O8p7X2dUnem+SaJKmqxyZ5XpJLkzwryetKMRED\npoaGoTCWGYZJ1wHAUpiTGZNOEt3W2l2tteOzn/8myS1JLkrynCRvnB32xiTPnf18ZZLrWmv3tNZO\nJLk1yeUrDRoAAIC10HmNblVtZvqr0r+f5PbW2iPm9v1Va+3Lq+oXkvxha+0ts+2/nOT61tq/O8v5\n1OgCMDhqdBfdv4o++hDDUProQwyr68M1KizHIjW6nT51uar+TpK3JXlZa+1vqurMv/3nNBscO3Ys\nm5ubSZIjR47k6NGj2draSnJ6yYa2tra2tvY6tacmSbbmfs5ce/qec3//JPe1+/6d4l30/Ye3vy/t\nU9sOa/8k9zXU/atqn9p2WPsnmdf1fKKtvW7t48eP5+TJk0mSEydOZBGd3dGtqvOS/Pskv9dae+1s\n2y1Jtlpr21W1keR9rbVLq+rqJK21du3suBuSvKq19sGznNcdXdbe/MUqrDNjeXnc0V10/2H0Mcl9\nE5qhfs4u+uhDDKvro+trVHMyQ9Hbpy7P/EqSm08luTPvSHJs9vMLkrx9bvtVVfWgqnpkkkcn+dCq\nAgUAAGB9dHJHt6qekuQ/JLkpp5+7/spMk9e3JvnqJLcleV5r7eTsPdckeVGSz2e61PldO5zbHV0A\nBscd3UX3r6KPPsQwlD76EMPq+nCNCsuxyB3dzh9GtWwSXQCGSKK76P5V9NGHGIbSRx9iWF0frlFh\nOfq+dBnYwf0f6gLryVhmGCZdBwBLYU5mTCS6AMCCHpyq2vEF7Gb3vz8bG5tdBwiDYukyAKyBvixd\nXpclopbbrksffYihP324hoXFWLoMAADA6Eh0oYfU0DAUxjLDMOk6AFgKczJjItEFAABgUNToAsAa\nUKPbpz76EMNQ+uhDDP3pwzUsLEaNLgAAAKMj0YUeUkPDUBjLDMOk6wBgKczJjIlEFwAAgEFRowsA\na0CNbp/66EMMQ+mjDzH0pw/XsLAYNboAAACMjkQXekgNDUNhLDMMk64DgKUwJzMm53UdAACwDA+e\nLU8GANToAsAaWKRGdyh1iv3vow8xDKWPPsTQnz5cw8Ji1OgCAAAwOhJd6CE1NAyFscwwTLoOAJbC\nnMyYSHQBAAAYFDW6ALAG1Oj2qY8+xDCUPvoQQ3/6cA0Li1GjCwAAwOhIdKGH1NAwFGMZyxsbm6mq\nHV8bG5tdh8iBTLoOAJZiLHMyJL5HFwAObHv7tuy2JHF72/fbAsAqqdEFgANapH72oP82qdHtUx99\niGEoffQhhr70cX6Su3fce8EFF+euu07s0QeMwyI1uu7oAgBA5+6OlSGwPGp0oYfU0DAUxvLi9qrz\npUuTrgOAJA/edY5Y5HkA5mTGxB1dAOiBvep8p8segfHa/Y5v4q4vzFOjCwAHtIwa3cOvwV2XOsV1\n6KMPMQyljz7EMKw+XAczBr5HFwAAgNGR6EIPqaFhKIzlU/auraPPJl0HAEthTmZMJLoAcOhO1dbt\n9gI4XN/5nVcd6GFWsE7U6EIPbGxszh5Ec3a+O491NZaxffD62kWOGU4N4fr30YcYhtJHH2IYVh+7\nXQev4ju/YRUWqdGV6EIP+IeHoRrL2Jbojq2PPsQwlD76EMOw+pDoMgYeRgVra9J1AAB80aTrAADY\nJ4kuAAAAgyLRhV7a6joAWBsbG5uH/nCVvfpg6La6DgCAfVKjCz2gZoahWsXYPmgfez0w67R1r9/r\nQwxD6aMPMQyljz7EMKw+1OgyBmp0YW1Nug4AVmT375ddxVddTJPctseLcZt0HQAA+3Re1wEAMGan\nvl/27La3z1/C0uAHW14MACPjji700lbXAQzWXrWWq7qLuAqrqF09fKcS4YPcbd3rHLCXra4DgAXt\nvkoGxkSNLvSAmpnV2fvPOlmHP+9l1ZUe5HOOp7Z1KH30IYah9NGHGIbSRx9i0Mf8/r7/+weJGl1Y\nY5OuA+jMEO5CruKu8XLqSnf/zf8DH/hlu+5X28p4TLoOAFak++cmwLKsVaJbVc+sqk9W1aer6hVd\nxwOH53jXAZyTZSSpeyVP29t3HSg5W8XnXCQB7MPn2GtJ7733/u0enwPGYj3nZNi/3f9d2OvfLskw\nfbI2D6Oqqgck+TdJnpbkz5J8uKre3lr75JnHXnfddTue55nPfGaOHDlyaHHCcpzc9zv2Wkb6gAd8\n6SxxObsLLrg4d911Yt/9zjud4O20fxkJ2u4PL7r33kWWbe1lkYcXHbSPVXwOYDn2PyfDMO3+b1ey\n90MEl3G9AYtYm0Q3yeVJbm2t3ZYkVXVdkuckuV+i+4M/+NtnPcHdd/9RfuInPp1/9a/+1WHGyZrZ\nK0Fclwl5ryRzr8RpkafbHvzPYl2efrvXP+Tr8BkAoAsHe5r+Xr+YT9bn2oxurdPS5QuT3D7XvmO2\n7X6+8IWHnvXV2oNy7733HjiQIdQQLmIon/Ogy0wPusT03JahnjijvXvNzHKSx72fbrvXn8Uy+gDo\nnxNdBwADctCymYNfmy3j2m2v/etynTxka/PU5ar6riTPaK394Kz9PyW5vLX20jOOW48PBAAAwDnZ\n66nL67R0+c4kXzPXvmi27T72+sAAAAAM2zotXf5wkkdX1cVV9aAkVyV5R8cxAQAA0DNrc0e3tfaF\nqvrhJO/KNEF/fWvtlo7DAgAAoGfWpkYXAAAAFrFOS5cXUlWvqapbqup4Vf1WVT2s65hgP6rqmVX1\nyar6dFW9out4YL+q6qKqem9VfaKqbqqql+79LuivqnpAVX20qpRMsbaq6uFV9Zuz6+RPVNWTuo4J\n9quqfrSq/qiqbqyqN89KWs9qcIlupkubH9daO5rk1iTXdBwPLKyqHpDk3yR5RpLHJfneqvr6bqOC\nfbsnyY+11h6X5JuTvMQ4Zs29LMnNXQcBB/TaJNe31i5N8sQkSgBZK1X1VUl+JMllrbUnZFqGe9VO\nxw8u0W2tvae1durLcj+Q6dOZYV1cnuTW1tptrbXPJ7kuyXM6jgn2pbV2V2vt+Oznv8n0Yuqs33sO\nfVdVFyV5dpJf7joWOFezFY7f2lp7Q5K01u5prf3njsOCc/HAJF9WVecl+dIkf7bTgYNLdM/w/Ul+\nr+sgYB8uTHL7XPuOSBBYY1W1meRokg92Gwmcs59N8uNJPNSEdfbIJH9RVW+YLcP/pap6SNdBwX60\n1v4syc8k+WymXzN7srX2np2OX8tEt6rePVuXfep10+y/3zF3zE8k+Xxr7S0dhgowWlX1d5K8LcnL\nZnd2Ya1U1T9Jsj1boVCzF6yj85JcluT/aK1dluRvk1zdbUiwP1V1JNOVjhcn+aokf6eqvm+n49fm\n64Xmtdaevtv+qjqW6TKjb1tJQLA8dyb5mrn2RbNtsFZmS4reluTXWmtv7zoeOEdPSXJlVT07yUOS\nPLSq3tRae37HccF+3ZHk9tbaf5q135bEAy9ZN9+e5DOttb9Kkqr6d0n+YZKz3thcyzu6u6mqZ2a6\nxOjK1trdXccD+/ThJI+uqotnT5G7KomnfLKOfiXJza2113YdCJyr1torW2tf01r72kzn4/dKcllH\nrbXtJLdX1SWzTU+LB6yxfj6b5MlVdX5VVabjeMeHqq3lHd09/EKSByV59/Tz5wOttRd3GxIsprX2\nhar64UyfHv6AJK9vrXkqImulqp6S5J8muamqPpZpbeMrW2s3dBsZwKi9NMmbq+pLknwmyQs7jgf2\npbX2oap6W5KPJfn87L+/tNPx1ZpnKwAAADAcg1u6DAAAwLhJdAEAABgUiS4AAACDItEFAABgUCS6\nAAAADIpEFwAAgEGR6AIAADAoEl0ARq+q/ssB3vuSqrq1qr5QVV9+xr6fn+07XlVH57afX1WTqnpA\nVf1JVT3mjPf9bFX9+Fz756rqjjOOeUFV/cJZ4nlYVb1x1u+tVfWrVfWw2b6Lq+pvq+qjVfVHs30P\n3OWzPbWqTs6O/3hVvauq/u5c/38+2/ex2X+/ftbHvVX1r+fO8xVV9f9V1c/P/Zm9cNE/YwDYL4ku\nACTtAO99f5KnJbltfmNVPSvJo1prj0nyz5P8n3O7vz/Jb7XW7k3y60mumntfJfnuJNfNtZ+b5LNV\n9dQF4n59kj9prT1m1veJJL88t/+PW2uXJXlCkq9O8rw9Pt9/aK1d1lp7YpL/lOQlc/uum+37htl/\nPznb/qdJ/snccf9jkj+aa/9Kkh/Zo18AOGcSXQCYU1U/XVU3ze5gPm+2rarqdVV1c1W9s6p+t6q+\nM0laax9vrX02SZ1xquckedPsmA8meXhVXTDb90+TvH3283WZS3ST/KMkJ1prt8/aW5kmib+Y5Pv2\niP1RSS5L8r/Obf7XSf5BVT1y/thZkv2hJBfuds5Tn2uWcD80yV+fue8s/jbJLVV12az9PUneOtf3\nf0vyp1X1D/boGwDOiUQXAGaq6ruSPKG19vgkT0/y07Pk9DuTfE1r7bFJnp/kmxc43YVJbp9r35nk\nwqr6kiSPnCXHaa39UZIvVNXjZ8ddleld3lO+N8lbkvx2kmfvttQ4yWOTHG+tffFO7yyhPZ7kcac+\n5uyznp/kSUlu2ONzfGtVfTTTO9ZPy/Ru7Cnfc8bS5QfP7bsuyfdW1UVJ7knyZ2ec9yNJvnWPvgHg\nnEh0AeC0p2SWZLbW/jzJJMnlSb4lyW/Otm8ned8B+vi7SU6ese26JFfNktjnnuprlhQ/O8nbW2v/\nJdM7sM84QN9J8qhZ4npXkj+bJdq7ObV0+WuSvCHJT8/HfcbS5btn21umCfTTM03cfyP3v/v750m+\n6oCfBQDOSqILADurLF6/e+Zxd2ZaA3vKRbNt/y3JQ8449rpMl/d+e5KPt9b+39n2ZyR5eJKbqupP\nM03Ev3eXGG5OcnR+w2zJ8dHZvuR0je6jMl3S/D/s/dG+6Hey4F3Y1to9md61/bEkbzvLIedn+mcB\nAEsn0QWA03cb/2Omy3EfUFV/L9Ok7kNJ/p8k3z2r1b0g07rZs51j/q7lOzJd5pyqenKSk6217dba\nySQPqKoHnTqwtfaZJH+R5Kdy/2XLL2qtfW1r7ZFJvjbJFbNlx/NxnzrPnyT5WFX9y7nN/zLJR2Z9\nfPE9rbW/THJ1klfu/kdznz6+Ncmf7LDvbO/5mSSvmH3mM12S+z6gCgCWRqILALO7sa21/yvJjUk+\nnuQ9SX58toT5tzKtt/1Epg+Y+kiSzyVJVf1IVd2eaU3ux6vql2bnuj7TBy79cZJ/m+TFc/29K9Pl\n0PN+PcnXJfl3s/M+JNM7utd/McjW/jbTZPw7ZpteUFWfrarbZ//9qiT/LMklVfXHVXVrkkcnedGZ\nn3V2vt9O8pCqesoufzbfMqu/PZ7pQ7T+xdy+551Ro/vkM/48b26t/doO531Kknfv0i8AnLOae14F\nALCDqvqy1tp/nX1X7geTPGWWBJ/Lub4hyctbay9YapBrYvadwj861s8PwOE7r+sAAGBN/PuqOpLk\nS5L863NNcpOktfaxqnpfVVUb52+cvyLTJdUAcCjc0QWAkauqK5Jcm9PLmivJZ1pr39VdVABw7iS6\nAAAADIqHUQEAADAoEl0AAAAGRaILAADAoEh0AQAAGJT/H8A1NZZkonCbAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7f41843b7c50>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "ax = df.VALOR_BEM.apply(np.log10).hist(bins=100, figsize=(16, 8))\n",
    "ax.set_xlabel('log10(VALOR_BEM)')\n",
    "ax.set_ylabel('#bens')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "vbg = df.groupby('TIPO_BEM_CANDIDATO').VALOR_BEM\\\n",
    ".apply(lambda x: pd.Series({'qtd':x.count(), 'min':x.min(), 'max':x.max(), 'mean':x.mean(), 'std':x.std()}))\\\n",
    ".unstack()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "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>max</th>\n",
       "      <th>mean</th>\n",
       "      <th>min</th>\n",
       "      <th>qtd</th>\n",
       "      <th>std</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TIPO_BEM_CANDIDATO</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>Aeronave</th>\n",
       "      <td>28,000.00</td>\n",
       "      <td>28,000.00</td>\n",
       "      <td>28,000.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Apartamento</th>\n",
       "      <td>3,620,501.57</td>\n",
       "      <td>246,284.52</td>\n",
       "      <td>600.00</td>\n",
       "      <td>715.00</td>\n",
       "      <td>331,685.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aplicação de renda fixa (CDB, RDB e outros)</th>\n",
       "      <td>2,182,486.00</td>\n",
       "      <td>63,722.33</td>\n",
       "      <td>1.14</td>\n",
       "      <td>262.00</td>\n",
       "      <td>175,456.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ações (inclusive as provenientes de linha telefônica)</th>\n",
       "      <td>10,092,334.84</td>\n",
       "      <td>491,430.79</td>\n",
       "      <td>2.00</td>\n",
       "      <td>59.00</td>\n",
       "      <td>1,702,877.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bem relacionado com o exercício da atividade autônoma</th>\n",
       "      <td>600,000.00</td>\n",
       "      <td>49,496.09</td>\n",
       "      <td>1,000.00</td>\n",
       "      <td>87.00</td>\n",
       "      <td>87,563.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Benfeitorias</th>\n",
       "      <td>643,508.75</td>\n",
       "      <td>87,994.65</td>\n",
       "      <td>700.00</td>\n",
       "      <td>25.00</td>\n",
       "      <td>141,231.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Caderneta de poupança</th>\n",
       "      <td>860,000.00</td>\n",
       "      <td>18,050.22</td>\n",
       "      <td>0.01</td>\n",
       "      <td>753.00</td>\n",
       "      <td>52,936.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Casa</th>\n",
       "      <td>6,000,000.00</td>\n",
       "      <td>112,810.24</td>\n",
       "      <td>0.01</td>\n",
       "      <td>3,831.00</td>\n",
       "      <td>169,863.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Construção</th>\n",
       "      <td>888,260.00</td>\n",
       "      <td>144,024.18</td>\n",
       "      <td>15,000.00</td>\n",
       "      <td>37.00</td>\n",
       "      <td>191,210.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Consórcio não contemplado</th>\n",
       "      <td>690,217.85</td>\n",
       "      <td>43,331.20</td>\n",
       "      <td>1.00</td>\n",
       "      <td>113.00</td>\n",
       "      <td>80,860.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Crédito decorrente de alienação</th>\n",
       "      <td>519,814.50</td>\n",
       "      <td>102,885.09</td>\n",
       "      <td>12,000.00</td>\n",
       "      <td>8.00</td>\n",
       "      <td>169,948.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Crédito decorrente de empréstimo</th>\n",
       "      <td>1,200,000.00</td>\n",
       "      <td>164,181.49</td>\n",
       "      <td>281.00</td>\n",
       "      <td>38.00</td>\n",
       "      <td>262,354.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Depósito bancário em conta corrente no País</th>\n",
       "      <td>1,702,859.73</td>\n",
       "      <td>12,291.84</td>\n",
       "      <td>0.01</td>\n",
       "      <td>946.00</td>\n",
       "      <td>61,699.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Depósito bancário em conta corrente no exterior</th>\n",
       "      <td>770.00</td>\n",
       "      <td>635.00</td>\n",
       "      <td>500.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>190.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dinheiro em espécie - moeda estrangeira</th>\n",
       "      <td>125,000.00</td>\n",
       "      <td>21,027.78</td>\n",
       "      <td>500.00</td>\n",
       "      <td>45.00</td>\n",
       "      <td>29,514.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dinheiro em espécie - moeda nacional</th>\n",
       "      <td>4,800,000.00</td>\n",
       "      <td>26,258.67</td>\n",
       "      <td>0.01</td>\n",
       "      <td>2,233.00</td>\n",
       "      <td>139,101.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Direito de autor, de inventor e patente</th>\n",
       "      <td>50,000.00</td>\n",
       "      <td>28,750.00</td>\n",
       "      <td>5,000.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>20,155.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Direito de lavra e assemelhado</th>\n",
       "      <td>1,000,000.00</td>\n",
       "      <td>1,000,000.00</td>\n",
       "      <td>1,000,000.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Embarcação</th>\n",
       "      <td>200,000.00</td>\n",
       "      <td>27,024.39</td>\n",
       "      <td>500.00</td>\n",
       "      <td>41.00</td>\n",
       "      <td>32,529.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fundo de ações, inclusive Carteira Livre e Fundo de Investimento no exterior</th>\n",
       "      <td>2,194,022.00</td>\n",
       "      <td>268,842.52</td>\n",
       "      <td>291.70</td>\n",
       "      <td>11.00</td>\n",
       "      <td>648,195.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fundo de capitalização</th>\n",
       "      <td>155,000.00</td>\n",
       "      <td>13,075.90</td>\n",
       "      <td>50.00</td>\n",
       "      <td>96.00</td>\n",
       "      <td>25,681.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fundo de investimento financeiro - FIF</th>\n",
       "      <td>1,093,397.31</td>\n",
       "      <td>52,149.04</td>\n",
       "      <td>0.01</td>\n",
       "      <td>68.00</td>\n",
       "      <td>146,695.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Galpão</th>\n",
       "      <td>3,000,000.00</td>\n",
       "      <td>327,706.44</td>\n",
       "      <td>4,300.00</td>\n",
       "      <td>30.00</td>\n",
       "      <td>744,987.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jóia, quadro, objeto de arte, de coleção, antiguidade, etc.</th>\n",
       "      <td>130,000.00</td>\n",
       "      <td>21,854.71</td>\n",
       "      <td>500.00</td>\n",
       "      <td>17.00</td>\n",
       "      <td>32,804.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Leasing</th>\n",
       "      <td>224,900.00</td>\n",
       "      <td>76,086.90</td>\n",
       "      <td>16,263.61</td>\n",
       "      <td>4.00</td>\n",
       "      <td>99,480.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Linha telefônica</th>\n",
       "      <td>9,021.64</td>\n",
       "      <td>1,202.32</td>\n",
       "      <td>10.00</td>\n",
       "      <td>26.00</td>\n",
       "      <td>1,916.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Loja</th>\n",
       "      <td>500,000.00</td>\n",
       "      <td>42,431.44</td>\n",
       "      <td>1.00</td>\n",
       "      <td>85.00</td>\n",
       "      <td>73,695.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mercado futuros, de opções e a termo</th>\n",
       "      <td>7,000.00</td>\n",
       "      <td>5,666.67</td>\n",
       "      <td>4,000.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>1,527.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ouro, ativo financeiro</th>\n",
       "      <td>15,000.00</td>\n",
       "      <td>7,000.32</td>\n",
       "      <td>8.14</td>\n",
       "      <td>9.00</td>\n",
       "      <td>5,174.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Outras aplicações e Investimentos</th>\n",
       "      <td>2,834,282.50</td>\n",
       "      <td>68,754.67</td>\n",
       "      <td>1.00</td>\n",
       "      <td>195.00</td>\n",
       "      <td>264,612.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Outras participações societárias</th>\n",
       "      <td>10,424,473.00</td>\n",
       "      <td>117,359.62</td>\n",
       "      <td>0.01</td>\n",
       "      <td>227.00</td>\n",
       "      <td>713,135.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Outros bens e direitos</th>\n",
       "      <td>50,000.00</td>\n",
       "      <td>33,500.00</td>\n",
       "      <td>500.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>28,578.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Outros bens imóveis</th>\n",
       "      <td>3,000,000.00</td>\n",
       "      <td>126,227.60</td>\n",
       "      <td>69.39</td>\n",
       "      <td>600.00</td>\n",
       "      <td>231,558.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Outros bens móveis</th>\n",
       "      <td>1,952,800.00</td>\n",
       "      <td>45,645.72</td>\n",
       "      <td>100.00</td>\n",
       "      <td>516.00</td>\n",
       "      <td>118,177.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Outros créditos e poupança vinculados</th>\n",
       "      <td>1,153,043.06</td>\n",
       "      <td>41,513.13</td>\n",
       "      <td>0.51</td>\n",
       "      <td>76.00</td>\n",
       "      <td>138,861.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Outros depósitos à vista e numerário</th>\n",
       "      <td>100,000.00</td>\n",
       "      <td>13,476.68</td>\n",
       "      <td>81.66</td>\n",
       "      <td>15.00</td>\n",
       "      <td>27,836.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Outros fundos</th>\n",
       "      <td>7,269,532.60</td>\n",
       "      <td>61,646.84</td>\n",
       "      <td>0.79</td>\n",
       "      <td>291.00</td>\n",
       "      <td>442,428.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Poupança para construção ou aquisição de bem imóvel</th>\n",
       "      <td>1,171,447.20</td>\n",
       "      <td>202,120.33</td>\n",
       "      <td>430.40</td>\n",
       "      <td>20.00</td>\n",
       "      <td>350,312.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Prédio comercial</th>\n",
       "      <td>2,000,000.00</td>\n",
       "      <td>125,282.58</td>\n",
       "      <td>30.00</td>\n",
       "      <td>456.00</td>\n",
       "      <td>210,914.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Prédio residencial</th>\n",
       "      <td>1,000,000.00</td>\n",
       "      <td>132,648.71</td>\n",
       "      <td>1,110.36</td>\n",
       "      <td>223.00</td>\n",
       "      <td>156,716.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Quotas ou quinhões de capital</th>\n",
       "      <td>20,000,000.00</td>\n",
       "      <td>144,000.27</td>\n",
       "      <td>1.00</td>\n",
       "      <td>742.00</td>\n",
       "      <td>989,498.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sala ou conjunto</th>\n",
       "      <td>302,505.62</td>\n",
       "      <td>72,809.72</td>\n",
       "      <td>832.75</td>\n",
       "      <td>49.00</td>\n",
       "      <td>73,188.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Terra nua</th>\n",
       "      <td>8,000,000.00</td>\n",
       "      <td>183,530.16</td>\n",
       "      <td>1.00</td>\n",
       "      <td>281.00</td>\n",
       "      <td>825,487.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Terreno</th>\n",
       "      <td>6,000,000.00</td>\n",
       "      <td>72,294.84</td>\n",
       "      <td>1.00</td>\n",
       "      <td>3,416.00</td>\n",
       "      <td>208,177.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Título de clube e assemelhado</th>\n",
       "      <td>50,000.00</td>\n",
       "      <td>4,735.91</td>\n",
       "      <td>400.00</td>\n",
       "      <td>17.00</td>\n",
       "      <td>11,771.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VGBL - Vida Gerador de Benefício Livre</th>\n",
       "      <td>383,487.84</td>\n",
       "      <td>44,196.58</td>\n",
       "      <td>632.77</td>\n",
       "      <td>60.00</td>\n",
       "      <td>73,133.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Veículo automotor terrestre: caminhão, automóvel, moto, etc.</th>\n",
       "      <td>3,982,820.00</td>\n",
       "      <td>26,185.91</td>\n",
       "      <td>1.00</td>\n",
       "      <td>9,418.00</td>\n",
       "      <td>52,632.09</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                        max  \\\n",
       "TIPO_BEM_CANDIDATO                                                                            \n",
       "Aeronave                                                                          28,000.00   \n",
       "Apartamento                                                                    3,620,501.57   \n",
       "Aplicação de renda fixa (CDB, RDB e outros)                                    2,182,486.00   \n",
       "Ações (inclusive as provenientes de linha telefônica)                         10,092,334.84   \n",
       "Bem relacionado com o exercício da atividade autônoma                            600,000.00   \n",
       "Benfeitorias                                                                     643,508.75   \n",
       "Caderneta de poupança                                                            860,000.00   \n",
       "Casa                                                                           6,000,000.00   \n",
       "Construção                                                                       888,260.00   \n",
       "Consórcio não contemplado                                                        690,217.85   \n",
       "Crédito decorrente de alienação                                                  519,814.50   \n",
       "Crédito decorrente de empréstimo                                               1,200,000.00   \n",
       "Depósito bancário em conta corrente no País                                    1,702,859.73   \n",
       "Depósito bancário em conta corrente no exterior                                      770.00   \n",
       "Dinheiro em espécie - moeda estrangeira                                          125,000.00   \n",
       "Dinheiro em espécie - moeda nacional                                           4,800,000.00   \n",
       "Direito de autor, de inventor e patente                                           50,000.00   \n",
       "Direito de lavra e assemelhado                                                 1,000,000.00   \n",
       "Embarcação                                                                       200,000.00   \n",
       "Fundo de ações, inclusive Carteira Livre e Fundo de Investimento no exterior   2,194,022.00   \n",
       "Fundo de capitalização                                                           155,000.00   \n",
       "Fundo de investimento financeiro - FIF                                         1,093,397.31   \n",
       "Galpão                                                                         3,000,000.00   \n",
       "Jóia, quadro, objeto de arte, de coleção, antiguidade, etc.                      130,000.00   \n",
       "Leasing                                                                          224,900.00   \n",
       "Linha telefônica                                                                   9,021.64   \n",
       "Loja                                                                             500,000.00   \n",
       "Mercado futuros, de opções e a termo                                               7,000.00   \n",
       "Ouro, ativo financeiro                                                            15,000.00   \n",
       "Outras aplicações e Investimentos                                              2,834,282.50   \n",
       "Outras participações societárias                                              10,424,473.00   \n",
       "Outros bens e direitos                                                            50,000.00   \n",
       "Outros bens imóveis                                                            3,000,000.00   \n",
       "Outros bens móveis                                                             1,952,800.00   \n",
       "Outros créditos e poupança vinculados                                          1,153,043.06   \n",
       "Outros depósitos à vista e numerário                                             100,000.00   \n",
       "Outros fundos                                                                  7,269,532.60   \n",
       "Poupança para construção ou aquisição de bem imóvel                            1,171,447.20   \n",
       "Prédio comercial                                                               2,000,000.00   \n",
       "Prédio residencial                                                             1,000,000.00   \n",
       "Quotas ou quinhões de capital                                                 20,000,000.00   \n",
       "Sala ou conjunto                                                                 302,505.62   \n",
       "Terra nua                                                                      8,000,000.00   \n",
       "Terreno                                                                        6,000,000.00   \n",
       "Título de clube e assemelhado                                                     50,000.00   \n",
       "VGBL - Vida Gerador de Benefício Livre                                           383,487.84   \n",
       "Veículo automotor terrestre: caminhão, automóvel, moto, etc.                   3,982,820.00   \n",
       "\n",
       "                                                                                      mean  \\\n",
       "TIPO_BEM_CANDIDATO                                                                           \n",
       "Aeronave                                                                         28,000.00   \n",
       "Apartamento                                                                     246,284.52   \n",
       "Aplicação de renda fixa (CDB, RDB e outros)                                      63,722.33   \n",
       "Ações (inclusive as provenientes de linha telefônica)                           491,430.79   \n",
       "Bem relacionado com o exercício da atividade autônoma                            49,496.09   \n",
       "Benfeitorias                                                                     87,994.65   \n",
       "Caderneta de poupança                                                            18,050.22   \n",
       "Casa                                                                            112,810.24   \n",
       "Construção                                                                      144,024.18   \n",
       "Consórcio não contemplado                                                        43,331.20   \n",
       "Crédito decorrente de alienação                                                 102,885.09   \n",
       "Crédito decorrente de empréstimo                                                164,181.49   \n",
       "Depósito bancário em conta corrente no País                                      12,291.84   \n",
       "Depósito bancário em conta corrente no exterior                                     635.00   \n",
       "Dinheiro em espécie - moeda estrangeira                                          21,027.78   \n",
       "Dinheiro em espécie - moeda nacional                                             26,258.67   \n",
       "Direito de autor, de inventor e patente                                          28,750.00   \n",
       "Direito de lavra e assemelhado                                                1,000,000.00   \n",
       "Embarcação                                                                       27,024.39   \n",
       "Fundo de ações, inclusive Carteira Livre e Fundo de Investimento no exterior    268,842.52   \n",
       "Fundo de capitalização                                                           13,075.90   \n",
       "Fundo de investimento financeiro - FIF                                           52,149.04   \n",
       "Galpão                                                                          327,706.44   \n",
       "Jóia, quadro, objeto de arte, de coleção, antiguidade, etc.                      21,854.71   \n",
       "Leasing                                                                          76,086.90   \n",
       "Linha telefônica                                                                  1,202.32   \n",
       "Loja                                                                             42,431.44   \n",
       "Mercado futuros, de opções e a termo                                              5,666.67   \n",
       "Ouro, ativo financeiro                                                            7,000.32   \n",
       "Outras aplicações e Investimentos                                                68,754.67   \n",
       "Outras participações societárias                                                117,359.62   \n",
       "Outros bens e direitos                                                           33,500.00   \n",
       "Outros bens imóveis                                                             126,227.60   \n",
       "Outros bens móveis                                                               45,645.72   \n",
       "Outros créditos e poupança vinculados                                            41,513.13   \n",
       "Outros depósitos à vista e numerário                                             13,476.68   \n",
       "Outros fundos                                                                    61,646.84   \n",
       "Poupança para construção ou aquisição de bem imóvel                             202,120.33   \n",
       "Prédio comercial                                                                125,282.58   \n",
       "Prédio residencial                                                              132,648.71   \n",
       "Quotas ou quinhões de capital                                                   144,000.27   \n",
       "Sala ou conjunto                                                                 72,809.72   \n",
       "Terra nua                                                                       183,530.16   \n",
       "Terreno                                                                          72,294.84   \n",
       "Título de clube e assemelhado                                                     4,735.91   \n",
       "VGBL - Vida Gerador de Benefício Livre                                           44,196.58   \n",
       "Veículo automotor terrestre: caminhão, automóvel, moto, etc.                     26,185.91   \n",
       "\n",
       "                                                                                       min  \\\n",
       "TIPO_BEM_CANDIDATO                                                                           \n",
       "Aeronave                                                                         28,000.00   \n",
       "Apartamento                                                                         600.00   \n",
       "Aplicação de renda fixa (CDB, RDB e outros)                                           1.14   \n",
       "Ações (inclusive as provenientes de linha telefônica)                                 2.00   \n",
       "Bem relacionado com o exercício da atividade autônoma                             1,000.00   \n",
       "Benfeitorias                                                                        700.00   \n",
       "Caderneta de poupança                                                                 0.01   \n",
       "Casa                                                                                  0.01   \n",
       "Construção                                                                       15,000.00   \n",
       "Consórcio não contemplado                                                             1.00   \n",
       "Crédito decorrente de alienação                                                  12,000.00   \n",
       "Crédito decorrente de empréstimo                                                    281.00   \n",
       "Depósito bancário em conta corrente no País                                           0.01   \n",
       "Depósito bancário em conta corrente no exterior                                     500.00   \n",
       "Dinheiro em espécie - moeda estrangeira                                             500.00   \n",
       "Dinheiro em espécie - moeda nacional                                                  0.01   \n",
       "Direito de autor, de inventor e patente                                           5,000.00   \n",
       "Direito de lavra e assemelhado                                                1,000,000.00   \n",
       "Embarcação                                                                          500.00   \n",
       "Fundo de ações, inclusive Carteira Livre e Fundo de Investimento no exterior        291.70   \n",
       "Fundo de capitalização                                                               50.00   \n",
       "Fundo de investimento financeiro - FIF                                                0.01   \n",
       "Galpão                                                                            4,300.00   \n",
       "Jóia, quadro, objeto de arte, de coleção, antiguidade, etc.                         500.00   \n",
       "Leasing                                                                          16,263.61   \n",
       "Linha telefônica                                                                     10.00   \n",
       "Loja                                                                                  1.00   \n",
       "Mercado futuros, de opções e a termo                                              4,000.00   \n",
       "Ouro, ativo financeiro                                                                8.14   \n",
       "Outras aplicações e Investimentos                                                     1.00   \n",
       "Outras participações societárias                                                      0.01   \n",
       "Outros bens e direitos                                                              500.00   \n",
       "Outros bens imóveis                                                                  69.39   \n",
       "Outros bens móveis                                                                  100.00   \n",
       "Outros créditos e poupança vinculados                                                 0.51   \n",
       "Outros depósitos à vista e numerário                                                 81.66   \n",
       "Outros fundos                                                                         0.79   \n",
       "Poupança para construção ou aquisição de bem imóvel                                 430.40   \n",
       "Prédio comercial                                                                     30.00   \n",
       "Prédio residencial                                                                1,110.36   \n",
       "Quotas ou quinhões de capital                                                         1.00   \n",
       "Sala ou conjunto                                                                    832.75   \n",
       "Terra nua                                                                             1.00   \n",
       "Terreno                                                                               1.00   \n",
       "Título de clube e assemelhado                                                       400.00   \n",
       "VGBL - Vida Gerador de Benefício Livre                                              632.77   \n",
       "Veículo automotor terrestre: caminhão, automóvel, moto, etc.                          1.00   \n",
       "\n",
       "                                                                                   qtd  \\\n",
       "TIPO_BEM_CANDIDATO                                                                       \n",
       "Aeronave                                                                          1.00   \n",
       "Apartamento                                                                     715.00   \n",
       "Aplicação de renda fixa (CDB, RDB e outros)                                     262.00   \n",
       "Ações (inclusive as provenientes de linha telefônica)                            59.00   \n",
       "Bem relacionado com o exercício da atividade autônoma                            87.00   \n",
       "Benfeitorias                                                                     25.00   \n",
       "Caderneta de poupança                                                           753.00   \n",
       "Casa                                                                          3,831.00   \n",
       "Construção                                                                       37.00   \n",
       "Consórcio não contemplado                                                       113.00   \n",
       "Crédito decorrente de alienação                                                   8.00   \n",
       "Crédito decorrente de empréstimo                                                 38.00   \n",
       "Depósito bancário em conta corrente no País                                     946.00   \n",
       "Depósito bancário em conta corrente no exterior                                   2.00   \n",
       "Dinheiro em espécie - moeda estrangeira                                          45.00   \n",
       "Dinheiro em espécie - moeda nacional                                          2,233.00   \n",
       "Direito de autor, de inventor e patente                                           4.00   \n",
       "Direito de lavra e assemelhado                                                    1.00   \n",
       "Embarcação                                                                       41.00   \n",
       "Fundo de ações, inclusive Carteira Livre e Fundo de Investimento no exterior     11.00   \n",
       "Fundo de capitalização                                                           96.00   \n",
       "Fundo de investimento financeiro - FIF                                           68.00   \n",
       "Galpão                                                                           30.00   \n",
       "Jóia, quadro, objeto de arte, de coleção, antiguidade, etc.                      17.00   \n",
       "Leasing                                                                           4.00   \n",
       "Linha telefônica                                                                 26.00   \n",
       "Loja                                                                             85.00   \n",
       "Mercado futuros, de opções e a termo                                              3.00   \n",
       "Ouro, ativo financeiro                                                            9.00   \n",
       "Outras aplicações e Investimentos                                               195.00   \n",
       "Outras participações societárias                                                227.00   \n",
       "Outros bens e direitos                                                            3.00   \n",
       "Outros bens imóveis                                                             600.00   \n",
       "Outros bens móveis                                                              516.00   \n",
       "Outros créditos e poupança vinculados                                            76.00   \n",
       "Outros depósitos à vista e numerário                                             15.00   \n",
       "Outros fundos                                                                   291.00   \n",
       "Poupança para construção ou aquisição de bem imóvel                              20.00   \n",
       "Prédio comercial                                                                456.00   \n",
       "Prédio residencial                                                              223.00   \n",
       "Quotas ou quinhões de capital                                                   742.00   \n",
       "Sala ou conjunto                                                                 49.00   \n",
       "Terra nua                                                                       281.00   \n",
       "Terreno                                                                       3,416.00   \n",
       "Título de clube e assemelhado                                                    17.00   \n",
       "VGBL - Vida Gerador de Benefício Livre                                           60.00   \n",
       "Veículo automotor terrestre: caminhão, automóvel, moto, etc.                  9,418.00   \n",
       "\n",
       "                                                                                       std  \n",
       "TIPO_BEM_CANDIDATO                                                                          \n",
       "Aeronave                                                                               nan  \n",
       "Apartamento                                                                     331,685.73  \n",
       "Aplicação de renda fixa (CDB, RDB e outros)                                     175,456.56  \n",
       "Ações (inclusive as provenientes de linha telefônica)                         1,702,877.98  \n",
       "Bem relacionado com o exercício da atividade autônoma                            87,563.80  \n",
       "Benfeitorias                                                                    141,231.64  \n",
       "Caderneta de poupança                                                            52,936.58  \n",
       "Casa                                                                            169,863.10  \n",
       "Construção                                                                      191,210.93  \n",
       "Consórcio não contemplado                                                        80,860.67  \n",
       "Crédito decorrente de alienação                                                 169,948.33  \n",
       "Crédito decorrente de empréstimo                                                262,354.52  \n",
       "Depósito bancário em conta corrente no País                                      61,699.82  \n",
       "Depósito bancário em conta corrente no exterior                                     190.92  \n",
       "Dinheiro em espécie - moeda estrangeira                                          29,514.84  \n",
       "Dinheiro em espécie - moeda nacional                                            139,101.47  \n",
       "Direito de autor, de inventor e patente                                          20,155.64  \n",
       "Direito de lavra e assemelhado                                                         nan  \n",
       "Embarcação                                                                       32,529.98  \n",
       "Fundo de ações, inclusive Carteira Livre e Fundo de Investimento no exterior    648,195.35  \n",
       "Fundo de capitalização                                                           25,681.95  \n",
       "Fundo de investimento financeiro - FIF                                          146,695.35  \n",
       "Galpão                                                                          744,987.27  \n",
       "Jóia, quadro, objeto de arte, de coleção, antiguidade, etc.                      32,804.93  \n",
       "Leasing                                                                          99,480.02  \n",
       "Linha telefônica                                                                  1,916.92  \n",
       "Loja                                                                             73,695.45  \n",
       "Mercado futuros, de opções e a termo                                              1,527.53  \n",
       "Ouro, ativo financeiro                                                            5,174.29  \n",
       "Outras aplicações e Investimentos                                               264,612.31  \n",
       "Outras participações societárias                                                713,135.15  \n",
       "Outros bens e direitos                                                           28,578.84  \n",
       "Outros bens imóveis                                                             231,558.16  \n",
       "Outros bens móveis                                                              118,177.66  \n",
       "Outros créditos e poupança vinculados                                           138,861.77  \n",
       "Outros depósitos à vista e numerário                                             27,836.61  \n",
       "Outros fundos                                                                   442,428.91  \n",
       "Poupança para construção ou aquisição de bem imóvel                             350,312.87  \n",
       "Prédio comercial                                                                210,914.74  \n",
       "Prédio residencial                                                              156,716.53  \n",
       "Quotas ou quinhões de capital                                                   989,498.27  \n",
       "Sala ou conjunto                                                                 73,188.25  \n",
       "Terra nua                                                                       825,487.87  \n",
       "Terreno                                                                         208,177.38  \n",
       "Título de clube e assemelhado                                                    11,771.66  \n",
       "VGBL - Vida Gerador de Benefício Livre                                           73,133.41  \n",
       "Veículo automotor terrestre: caminhão, automóvel, moto, etc.                     52,632.09  "
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vbg.applymap(lambda x: \"{:,.2f}\".format(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7f4181f42208>"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAoAAAAF4CAYAAADE5EjKAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3XmcJVV9///XewAZFlEhiqg4il9xR5ZIXGGQJMbEoBJx\nN8SQb/xJ4pqfxrgNJP5cotG4J6hBMC64gAJuKDIquMEwMIAEJQLGBY1bQIKg8Pn9UafhTnO7b9+e\nvt09U6/n43EfU/fUqTqfqnun+9PnnKpKVSFJkqT+WLHUAUiSJGlxmQBKkiT1jAmgJElSz5gASpIk\n9YwJoCRJUs+YAEqSJPXM1ksdgCQBJPGeVJI0D1WVcbexB1DSslFVvhbgtWbNmiWPYUt6eT49n8v5\nNV8mgJIkST1jAihJktQzJoCStIVZvXr1UoewRfF8LizP5/KQTRk/lqSFkqT8eSRJ40lCeRGIJEmS\nRjEBlCRJ6hkTQEmSpJ4xAZQkSeoZE0BJkqSeMQGUJEnqGRNASZKknjEBlCRJ6hkTQEmSpJ4xAZQk\nSeoZE0BJkqSe2XqpA5CkKcnYj7PUZmTXXVdx5ZWXL3UYkoD48HVJy0GSAn8ebdmCv3OkhZWEqhr7\nr2eHgCVJknrGBFCSJKlnTAAlSZJ6xgRQkiSpZ0wAJUmSesYEUJIkqWdMACVJknrGBFCSJKlnTAAl\nSZJ6xgRQkiSpZ0wApQlLcuckH0/yrSTfTvKmJCOfw53k7yYUz28l+VqSdUketgD7OzbJoQsRmyRp\ncZgASpN3InBiVe0J7AncGnj1HLZ76Uwrkoz93McBvwtsqKr9quqsTdiPJGkzZQIoTVCSRwLXVtXx\nAFVVwAuAP0+yMsnhSd46UP+UJAckeQ2wXZJzk7wvyaok/5HkuCQXAHdJ8pQkG9rrtW37Fa1HbkOS\n85M8b1o8DwReBzyu7XtlkqsH1v9JkmPb8rFJ3pzkrCSXDvbyJXlbkouTnAbcYaD84Lbf85O8O8k2\nrfy1SS5Mcl6Sf1zo8yxJGs/IYShJm+R+wLrBgqq6OskVwP+ZKpq+UVX9XZK/qqp9AZKsavWfUVVn\nJ9kNeC2wD/AL4HNJDgG+B9y5qvZq2+00bb/nJ3klsF9VPbfVmd7+4Ps7VtXDktwHOBk4sSWC96yq\n+7Q4vgm8J8m2wLHAQVX1n0mOA56d5N+Bx1XVvYfFJElafCaA0tKYyxDu9DpXVNXZbflBwBlV9TOA\nJO8HDgBeBdw9yZuBTwGnbWKcHweoqouTTPX0PQL4YCv/YZLTW/m9gO9U1X+298cBRwJvB65N8m7g\nk8CpMzd31MDy6vaSJE1Zu3Yta9eu3eT9mABKk/VN4AmDBa0HbHfgUuCBbDwVY+Us+7pm2vtbJJFV\n9Ys2zPso4FnAE4Ejxoh3evvXzdbekPJhMd2QZH/gYOAw4K/b8hBHzTFMSeqn1atXs3r16pveH330\n0fPaj3MApQmqqtPp5vI9HSDJVsAbgGOr6lfA5cDe6ewO7D+w+fWt/pTB5OobwAFJdm51ngJ8Mcku\nwFZVdRLwCroh4lGuTHKvJCuAx89Sb6r9LwFPavMNdwMOauWXAKuS7NHeP6PFtD1w26r6DPBCYK85\nxCRJmiB7AKXJezzwzjb3LnRDsy8DqKqzklwOXARczMbzBY8BLkiyDng5A3PzqurKJC8B1raiU6vq\nlCR7Ace2ZK6Al8whvr+jG5r9MXAOsONUM9PqVWv7pHZxy0XAd4GvtPLrkjwT+GhLSs8G/gXYBfhE\nkqnexRfMISZJ0gSluyhRkpZWdzGKP4+2bMHfOdLCSkJVjX1rMIeAJUmSesYEUJIkqWdMACVJknrG\nBFCSJKlnTAAlSZJ6xgRQkiSpZ0wAJUmSesYEUJIkqWdMACVJknrGBFCSJKlnTAAlSZJ6xgRQkiSp\nZ7Ze6gAk6WZjP89cm5Fdd1211CFIakwAJS0bVbXUIUhSLzgELEmS1DMmgJIkST1jAihJktQzJoCS\nJEk9YwIoSZLUMyaAkiRJPWMCKEmS1DMmgJIkST1jAihJktQzJoCSJEk9YwIoSZLUMyaAkiRJPWMC\nKEmS1DMmgJIkST1jAihJktQzJoCSJEk9YwIoSZLUMyaAkiRJPWMCKEmS1DMmgJIkST1jAihJktQz\nJoCSJEk9YwIoSZLUMyaAkiRJPWMCKEmS1DMmgJIkST1jAihJktQzJoCSJEk9YwIoSZLUMyaAkiRJ\nPWMCKEmS1DMmgJIkST2z9VIHIElTkix1CFpmdt11FVdeeflShyFtcVJVSx2DJJGkwJ9Hmi74e0qa\nWRKqauy/nh0CliRJ6hkTQEmSpJ4xAZQkSeoZE0BJkqSeMQGUJEnqGRNASZKknjEBlCRJ6hkTQEmS\npJ4xAZQkSeoZE0BJkqSe8VnA0mYoyc7A6XTPTtsNuAH47/Z+/6r6zRKGJ0la5nwWsLSZS/JK4JdV\n9cYxtllRVTcOvN+qqm6YSIBzj8lnAWsInwUszcZnAUv9tdF//CR/muTrSc5N8rZWtlWSnyd5U5Lz\ngP2T/FeS1yRZBzwuybOSfCPJ+iQnJNn2Fg0l/5Dk3UnWJrk0yZGt/B5J1g/U+9skL23LI/crSVpc\nJoDSFiTJ/YDHAw+pqn2BbZI8ua2+DbC2qvauqq+1sh9V1X5V9THgw1W1f1XtA3wH+LMZmrkncDDw\nEODvk0wloDN108x1v5KkReIcQGnL8rvAbwPntMRsJXBFW3ddVX1iWv0TBpb3TnI0cFtgR+DUGdo4\ntQ0X/3eSnwK3HxHTXPcLHDWwvLq9JElT1q5dy9q1azd5PyaA0pYlwL9V1ZqNCpOtgGun1S3gmoH3\nxwGPqqqLkxwB/M4MbVw3sHwj3c+R3wBbDZSvBH495n7ZOAGUJE23evVqVq9efdP7o48+el77cQhY\n2rJ8Hnhikl2gu1o4yV3auumThKe/3x74UZJtgKeO2e6VwG5JbpNkJfBHC7RfSdIE2AMobUGq6sI2\n3Pr5JCuA64H/B/ght5yjN/39K4FzgB8D36DrxRvZZGv3uiSvBtYB3wMuGqizZh77lSRNkLeBkbQs\neBsYDedtYKTZeBsYSZIkzYkJoCRJUs+YAEqSJPWMCaAkSVLPmABKkiT1jAmgJElSz8w5AUyyY5Id\nJxmMJEmSJm9kApjkyCTfpXue6HeTXJHkyMmHJkmSpEmYNQFM8nLgMcDqqtqlqnYGDgIe3dZJkiRp\nMzPrk0CSXAI8sKp+Na18O+D8qtpzwvFJ6gmfBKLhfBKINJtJPQmkpid/rfBa4MZxG5MkSdLSG5UA\nfj/JwdMLkzyS7uHykiRJ2sxsPWL9c4FPJDkTWNfKfht4GPDYSQYmqY/GHsXQFm7XXVctdQjSFmnW\nOYAASVYCTwXu14q+Cbx/2NCwJM1XknKulySNZ75zAEddBHJaVf3+JkUmSXNgAihJ45vURSC3n2c8\nkiRJWqZGzQG8TZJDZ1pZVScucDySJEmasJEJIN2NoId1LRZgAihJkrSZGTUH8Nyq2ncR45HUU84B\nlKTxTWoOoPdkkCRJ2sKMSgCfMawwycOTvH0C8UiSJGnCZp0DWFUXTi0n2YfufoCHAZfh/D9JkqTN\n0qwJYJI9gae010+AE+jmDR60CLFJkiRpAkZdBHIj8GXgiKq6tJV9p6r2WKT4JPWEF4FI0vgmdRHI\nocAPgTOSvCvJwXhhiCRJ0mZt5LOAAZLsADyWbij4kcDxwElVddpkw5PUF/YAStL4JvIs4Bkauh3d\nhSBPqqqDx21QkoYxAZSk8U00AUzyAODe7e3Fg1cHS9JCMAGUpPHNNwEcdRXwbYBPALsDG+jm/z0g\nyRXA46rqqvkEK0mSpKUz6irgtwDXAy+uqhtb2QrgtcB2VfWcRYlS0hbPHkBJGt9EhoCTfBPYq6p+\nM618a+CCqrrP2JFK0hAmgJI0vkndBub66ckfQCu7btzGJEmStPRmnQMIrGyPgJueWQbYdjIhSZIk\naZJGDQGvBWas4CPhJC0Uh4AlaXyLdh9ASZoEE0BJGt+kbgNz6Gzrq+rEcRuUJEnS0ho1B/CPZ1lX\ngAmgJEnSZsYhYEnLgkPAkjS+iQwBtx3fC/hLBh4FBxxTVd8atzFJkiQtvVnvA5jkIcBa4JfAMcC7\ngGuAtUkePPHoJEmStOBG3Qbm08DrqmrttPIDgZdU1aMnG56kvnAIWJLGN6lHwX2rqvacYd0lVXWv\ncRuUpGFMACVpfJN6FNzVs6y7ZtzGJEmStPRGXQSye5K3DCkPcOcJxCNJkqQJG5UAvmiWdecsZCCS\nJElaHN4HUNKy4BxASRrfpB4FdyzdEz+Gqao6YtwGJWkmydg/w6RFs+uuq7jyysuXOgxpQYwaAj51\nSNnuwAuArRY+HEn9Zg+glq8f/cg/ULTlmPMQcJI9gJcCBwBvAt5TVddPMDZJPZKkTAC1vAWnKWi5\nmdRtYEhy7yT/DpwCnAnct6reafInSZK0eRp1I+iPAPsB/wR8GLhhcH1V/Wyi0UnqDXsAtfzZA6jl\nZ1JPArmcm38iT/071UhV1R7jNihJw5gAavkzAdTyM5EEUJIWiwmglj8TQC0/E5sDOKSheyR5RZKL\nxt1WkiRJS29OCWCSOyV5QZKzgYvadk+eaGSSJEmaiFFzAP8SeArdc38/3F6fqKq7L054kvrCIWAt\nfw4Ba/mZyJNAgLcBXwWeWlXntIb89kuSJG3GRiWAuwGHAf+U5I50PYDbTDwqSYsqyROBy6vqG0sd\niyRp8madA1hVP62qf6mqA4GDgV8AP0pycZJXz7WRJI9LcmOSPedQ915J1ib5ZJJXzrWNEfvcO8m7\n2vIfJ3nxPPdzbJJD57Hdbkk+PJ82t0RJTk2y0zy3fWySe08gprE+2yRrkrywLR+d5JFzrT/P+J6X\nZOUc6p2RZN8RdR6e5MIk5ybZNsmjgDsBf5bkTnNo45j5fAZJ7t+eLy5JWmKjegBvUlXfo7sh9D8l\nuSfd3MC5ejLw5bbN0SPauQRYPca+5+KlwD+0/Z9C91STRVNVPwSeuJhtzkeSrarqhtE1N01VPWYT\nNn8c3TOq/2OBwtlkVbVmEZp5PvA+4FcLsK+nAa+uqg+0959trzmpqr+cT6NVdWGSOye5S/t5Ikla\nIrP2ACZ5epJnDFn1YODSuTSQZAfgYcARTEsak/xtkguSrE+yppUd3Homzk/yniTbtPJ9W8/g2Uk+\nnWTXVv7cJBclOS/JB6Y1T5IdgQdU1QXt/eFJ3tqWj03y5iRnJbl0sAeoxbahxXaL3s4klyXZuS3v\nl+SMtnxg2+bcJOuS7JBkVZKp9r+a5D4D+zmjHdv27Xi/1rb742HnMsnnk5zTzs8hrXz71qu2vsV8\n2JBtz0jyzwN1fruVr0lyfJIzgeNbj9C/tTrrkhw4n7jbef5Y+6wuSfK6Gc7d05J8vZ2vdyZJK786\nyava5/qVJLdP8hDgEOAfW/27J9mjtXF2ki+m9TInOWzgu7V2+vlodd6Wrjf7NOAOA+VDv2szyUDv\nYTu2o9q5OD8b93rfr523S5M8Z2D7k1pbFyT5iyH7fw5dD90ZSU5vZb/fzss5SU5Isv2Q7X5vWp0d\nkhxB98fIPyR5X6v3+tb2+emGgqe+x2ck+Ug7R+8b2O9NvYxJ/qAd6/okn2tlD2rtrktyZro/GKec\nincQkKSlV1UzvoCvAzsOKd8BWDfbtgN1nwq8qy2fCezTlv8A+BJwq/b+tsC2wH8B92xlxwHPpeup\nPAvYpZU/EXhPW/4+sE1b3mlI+6uBjwy8Pxx4S1s+FjihLd8H+HZbfnSLddup2AbqH9qWvwPs3Jb3\nA77Qlk8GHtKWt6dLslcBG1rZ84Gj2vIdgYvb8v9Hd7ENwG2AS4Dtph3LiqnPA9hlIN5DgX8dqHfr\nIefhjKk6wCOAC9ryGuDsgc/hhcC72/K9gCuAWwHPGyfudp4vBXZsn+vlwJ0Hzx1w73a+tmrlbwee\n3pZvBP6wLb8OeOn0z6C9/zxwj7a8P3B6W94A7DbL9+LxwGfb8m7Az9t5nPG7Nm37NcALh3wvLgOO\nbMvPBo4ZqH9m2/8uwE8Gjnvq+7USuAC43ZD2vjNV3rb/4tT3A3gx8PKBz3nfEXUG4z104DzcoX3e\nuwIHtnOyG93Tf74CPHRaG78FfBe467Tj2BFY0ZYPBj46cBwPpbuTwLCfFQXly9cyflHSctO+l4z7\nGjUEvE1V/XJ6YVVdk9YzNwdPAf65LZ/Q3q8Hfhd4b1Vd3/b5iyR7Ad+pqm+3+scBRwKnA/cHPtd6\niFYAP2h1zgc+kOTjwMeHtL8b8N+zxPfx1v7FSaZ6gQ4Gjq2q66ZiG7LdTJdcnwW8Kcn7gROr6vut\nU2vKh+mG246iSy4+2sp/H/jjJC9q728F3JUuoZqyAnhNkgPoEqQ7tZgvAN6Q5DXAJ6vqzBli+2A7\nni8nuXVunod38tTnADwceEurd0m6xwHuCXwEOG2MuKFLxn4JkOSbdInw97n53B1Ml0ic3T7XlcCV\nbd31VfWptryO7vuykXS9yw8FPpKbT/LU9/Is4Lh0cy9PHHIuDhg4Hz9M8oVWfi9m/q7N1UkDcT9+\noPyTVfUb4KdJfkSXaP0AeH6Sx7U6dwHuCUy/GCPcfN4eDNwXOKvFuA1dgjZoLnWg+7ynzsOPW2/p\ng4CrgW9UN32BJOcBd5u2jwcDX6yq77btp/6f3JauN/meQLHxVJMf0/VmzuCogeXVLPxsEEnavK1d\nu5a1a9du8n5GJYDbJdmhqq4ZLExya7pf9LNKcjvgkcD9090+Ziu6XwjjXoQR4MKqetiQdX9E98v8\nEOBlSe5fVTcOrL+WLrGYyXXT2pmr33DzEPpN+6+q1yU5tcV1VpLfH2yjqn6Q5KdJHgA8CXjWwD7/\nZCD5HeZpdL0u+1TVjUkuA1ZW1bfbkNwfAq9K8vmqetWQ7WuG99dMrzggA3H/ZK5xJ3kwG5/bG7j5\n+zbVboDjquplQ9q9fmB5cNtBK4CfV9UtLnqoqmcneRDwGGBdkn2r6uczHeRg6Mz8XZurqeOeHvfg\n+bgR2DrdEPsjgd+pquvSTSUYdbFHgNOq6mmbWGem7YbFO9NnMOz/zD/Q9YgfmmQVXY/hlJV0/ydn\ncNRc45SkXlq9ejWrV6++6f3RR896acWMRj0J5D3AR9sPcQCS3A34UFs3ymHA8VV196rao6pWAZcl\neTjwOeDwtCsbW7J4CbAqyR5t+2cAa1v57VtSQZKtk9y31blrVX0ReAmwE93w06CL6XpU5mLql9nn\ngGcm2W4gtukuoxv6BfiTm3aQ7FFVF1XVP9INrU5dLTn4i/IEuiR4p6q6sJV9lm64e2o/ew9p8zbA\nj1vydxCtpy3JbsC11U3qfz1dr9owT2r1Hw78T1VdPaTOl+kSTdr8td25uRdyvnFPN3UuTgeekOT2\nbdvbJdl9Wp3prqb7nGnxX5bkCQPt79X+3aOqzq7uAo0ft+MY9CXgSUlWtPN3UCuf7bs2CbehS2Kv\nS3dl7YNnqHcV7biBrwEPS3KPFuP20+bZzbUOdJ/31Hm4Pd30gLneCuZrwCOmfj4M/D/Zia6nF+CZ\n07bZE7gQSdKSGnUbmDcAnwC+1Hqtfko3r+jUqnr9HPb/JG4eDptyIvCUqvos8Cng/NaT9ddtyPXP\n6ZLO8+l6Hf61qn4NPAF4XRuKWg88JMnWwL+3uuuAN1fVVdOO4RJgpzZceItDHPa+xXYycE6Sc4G/\nGVL/74G3JPkGXW/glOe3CfXn0fVifXrIth9r5+aEgbJXAduku/jigrb/6d4PPKgd79O5+UrYBwDf\nSLIeeGXb1zC/asfzDrrzPMw7gK2SbKAbGjy8nf+5xH3hDHHDxsc/dZ4vBl4OnNaO6TS6Ifvp9Qd9\nCHhRu8Dg7nTJ6hHpLha5kK4nGOD1LaYNwFlVtWGjYKpOopujeBHwXtrQ5kzftRlimfHY5mCq3mfo\nzt9FwKvpbrw+zLuAzyQ5vap+QpdYfbCdt6/QDV3ftN9W589mq9PqnUQ3X/J8uvmUL6qqH8/lGFsb\nfwmc1L57H2rrXw+8Nsk6bvkz5iDgkzMcoyRpkcz6KLiNKnbDvgzrNUpyeFUdN+8gkn+tqmeNrjnv\n/T8PuLqq/m1SbSx3bWjxb6rq3KWORf2U5FZ0PfoPnzZNY2p9zT1/lpaCj4LT8pN5Pgpu1BDwTarq\n6hmGDKG7QnRs6W5LsZ5bDs8ttH9h4/lMfeRPLS21uwIvGZb8SZIW15x7AGfdSbK+qvZZgHgk9ZQ9\ngFr+7AHU8jPxHsAR/B8hSZK0mVioBHDszFOSJElLY6ESwLMWaD+SJEmasFnnACZ54WwbV9UbFzwi\nSb3kHEAtf84B1PIz3zmAo54E8gbgPLp72V2HQ72SJEmbvVEJ4D50z+79I7obLX+Q7vmu/gkkSZK0\nmRrnRtAPpUsGfxf426o6eZKBSeoXh4C1/DkErOVnoreBac8I3YfukWPfo3u2qiRJkjZDsw4BJ/lz\n4InASuCjwBNneE6oJEmSNhOjrgK+EbgQuKIVbVS5qg6ZXGiS+sQhYC1/DgFr+ZnUVcAHzTMeSZoH\nbzSg5WvXXVctdQjSghmVAK6vqquGrUhy1wnEI6nH7F2RpMUx6iKQtVMLSU6ftu7jCx6NJEmSJm5U\nAjg4HrPzLOskSZK0mRiVANYMy8PeS5IkaTMwag7gHdrzgDOwTHt/+4lGJkmSpIkYdRuYNbNtXFVH\nL3hEknopiU+ZlKQxzfc2MHN+FJwkTZIJoCSNbyKPgkuyMsnhSQ5J58VJTk3y5iS/Nf9wJUmStFRG\nDQF/GPg1sANwO7qngpwCPBzYu6oesxhBStry2QMoSeObyBBwkgur6v5Jtga+V1V3HFh3flU9cH7h\nStLGTAAlaXwTGQIGrgeoqt8AP5i27oZxG5MkSdLSG3UbmLskeQvdbV+mlmnv7zzRyCRJkjQRo4aA\nD59t46o6bsEjktRLDgFL0viW9DYwSd5aVc/Z5B1J6i0TQEka36TmAM7VwxZoP5IkSZqwhUoAJUmS\ntJkwAZQkSeqZhUoAxx57liRJ0tKYcwKYZMckO86w+s0LFI8kSZImbGQCmOTIJN8FrgC+m+SKJEcO\n1qmq904oPkmSJC2wWRPAJC8HHgOsrqpdqmpn4CDg0W2dJEmSNjOjbgR9CfDAqvrVtPLtgPOras8J\nxyepJ7wPoCSNb1L3AazpyV8rvBa4cdzGJEmStPRGJYDfT3Lw9MIkjwR+OJmQJEmSNEmjhoDvB3wC\nOBNY14p/m+7JH4+tqosmHqGkXnAIWJLGN7FnASdZCTwVuF8r+ibw/mFDw5I0XyaAkjS++SaAW8+h\nzh8AOwOnVdVnx45MkiRJy8qo28C8A3gBsAvwD0lesShRSZIkaWJGzQG8kO42MDck2R74clXtt2jR\nSeoNh4AlaXyTug3M9VV1A0BV/S8+81eSJGmzN6oH8H+BS6feAvdo70N3j8C9Jh6hpF6wB1CSxjep\ni0DuM894JEmStEyNvA2MJC0GewAlaXwT6QFMcg1ww7BVdEPAO43boCTNJHGasTYvu+66iiuvvHyp\nw5DGNmoO4Pqq2mcR45HUU0kK7AHU5ibYc62lNKmrgP1WS5IkbWFGXQRyhyQvnGllVb1xgeORJEnS\nhI1KALcCdsT7/0mSJG0xRs0BPLeq9l3EeCT1lHMAtXlyDqCW1qTmANrzJ0mStIUZ1QO4c1X9bBHj\nkdRT9gBq82QPoJbWfHsAvRG0pGXBBFCbJxNALa1JDQFLkiRpC2MCKEmS1DMmgJJmleShSR621HFI\nkhaOCWCPJblzko8n+VaSbyd5U5JR94Ykyd8tRnzzMT22JGeOqH90kkcucAx/kuSrST6a5LCF3Pd8\nJTkmyb1H1HlekpXTynYC1gDnzbLdgp9DSdJkeRFIjyX5OvD2qjo+SYB3AT+rqheP2O7qqrr1DOtS\nS/SlSrIC+J+ZYtPsklwG7Dd45X+SB9N9J741wzYrqurGBWrfi0C0GfIiEC0tLwLRWFqPzbVVdTxA\nS9peAPx5kpVJDk/y1oH6pyQ5IMlrgO2SnJvkfUlWJfmPJMcluQC4S5J3JPlGkguSrBnYx2uTXJjk\nvCT/OCSmNUmOT/KVJJck+YtWvkOSzyc5J8n5SQ5p5dPbfvdgbK3O1QP7/9skG5KsT/LqVnZskkPb\n8mVJXtfqfC3JHq38Me39uiSnJbn9QFz/1uqfl+QPW/kL27FvSPK8gfafluTrLb53prOixbChHdtN\n9Qe2O6ztb32Sta1s24G21yVZ3cpXJHl9q39ekr9q5Wck2bct/147x+ckOaEdx3OAOwFnJDm91XsH\n8BbgxGmf42XtszwHeMK0c/iKdowbkvzLwDbPTXJRi+kDw7+VkqRFU1W+evgCngP805DydcD9gcOB\ntwyUnwIc0JavGihfBfwGeNBA2W3bvyuAM9r+dgb+Y6DOTkPaXgOsB24F7AJ8F7gj7ZGErc4uwLdn\nafuqafu8qv37aOBMYNtpMR4LHNqWLwNe0pafAZzSlm8zsL8jgNe35ddOLU/VA/YFLgC2A3YALgQe\nCNwbOBnYqtV9O/D0Vv+0EedlA7Db4HrghcC72/K9gCvaeXs28GFu7t2fOs4zWlu7AF8EtmvlLwZe\nPnD8txvyOW7Vtrn/QL3/d6De4Dm87UD58cAfteXvA9vMdIytvKB8+drMXpS0lNp3kHFfI+d7qXfm\n0o08vc4VVXX2wPsnJ/m/dM+aviNwX+Bi4Nok7wY+CZw6w74/UVXXAz9N8gVgf+BTwGuTPAK4EbhT\nkjvM0PZMDgaOrarrAKrqFzPU+1D794PAm9ry7kk+DOwGbEOXAAH8LvDEqQ2r6n+SPBw4saquBUjy\nMeARQAH7AWcnCbAS+FE7D3dP8uZ2nKcNielM4LgWw4mt7OF0vXNU1SVJLqdLBA8G3tl+KAw7zgfT\nfR5ntTi2Ab4ysH7ws31Ckj9tse/RtruwrTthSJwAByd5EbA9cLtW/5PA+cAHknwc+PgM2wJHDSyv\nbi9J0pS1a9eydu3aTd6PCWB/fRN4wmBBugn/uwOX0vVaDU4R2OjigGmuGdjH3YC/oZtLdlWSY4GV\nVXVDkv3XX2fwAAAPOElEQVTpEpTDgL9uy9PVYEjt/dPoeq72qaob081Vm4rnmmnbb+rjCwfbn5rb\n9lbgDVX1ySQH0vVUznUfg/G8t6peNr1ykgcCjwKeRZdQHrHRzqqOTPIg4DHAuiT7DWlz6lyNEroe\nx6fNWilZBbwI2Luqrk3yXjb+Dkw/7yTZlq5nc9+q+kEbNp7a5o+AA4BDgJcluX8NnTt41BwOQZL6\na/Xq1axevfqm90cfffS89uMcwJ6qqtPp5ss9HSDJVsAb6HrJfgVcDuzd5qntTtcTN+X6Vn/KYJKz\nE/BL4Ooku9INvZJke7rhwc/QDV/uNUNoj01yqyS7AAcCZ9MNrf64JX8H0Q39Dmt7Krath6z/HPDM\nJNu1eG43Q/tPav8+GfjqwDH9oC0fPlD3c8CRNzWU3Bb4MvC4dPModwAe38q+QNejNjV/8HZJ7tqO\nc6uqOgl4BbDP9ICS7FFVZ1fVGuDHwF3aPqc+uz3pEvdLWkzPmvp8hhzn14CHJblHW799knu2dVe1\nYwW4LfC/wK/a5/gHM5yvQSvpktCfJtmRjf/AuGtVfRF4SWtjxznsT5I0IfYA9tvjgXcmeSVdovQp\n4GUAVXVWG1a8iG74dt3AdscAFyRZB7ycgZ6nqtqQ5Ly2zX/RDV9C90v/E7n5NiMvmCGmDcBauh6/\nv6+qK5O8HzglyfnAOW3fNzU5bftjgA1J1lXVM6bWV9VnW0/bOUmua8f68iHb36618yvgKa3saOCj\nSX5Gl8jdrZW/Cnh7kivoesT+pqo+3XrLzm77PqaqzgdI8nLgtHRXK18P/FVr59hWVnQJ0nSvH0jS\nTm/n+BK6z24D8Gvg8Kr6dRti37Odg+vprux+x8B5+EmSPwM+2Hrsqp2Hb7e6n0ny/ao6uO17+uc4\n7JxP7ft/WvsXAT8EvtGOe2vg31sPc4A3V9VVQ45TkrRIvA2Mlo02ZHh1Vb1xidq/jGm3QZnjdrsB\nf1lV8+uHF+BtYLS58jYwWlrxNjDSJhv7p3ibE/gFuquRJUnaLNgDKGlZsAdQmyd7ALW07AGUJEnS\nnJgASpIk9YwJoCRJUs+YAEqSJPWMCaAkSVLPmABKkiT1jAmgJElSz5gASpIk9YwJoCRJUs+YAEqS\nJPXM1ksdgCTdbOynGUlLatddVy11CNK8mABKWjZ8pqokLQ6HgCVJknrGBFCSJKlnTAAlSZJ6xgRQ\nkiSpZ0wAJUmSesYEUJIkqWdMACVJknrGBFCSJKlnTAAlSZJ6xgRQkiSpZ0wAJUmSesYEUJIkqWdM\nACVJknrGBFCSJKlnTAAlSZJ6xgRQkiSpZ0wAJUmSesYEUJIkqWdMACVJknrGBFCSJKlnTAAlSZJ6\nxgRQkiSpZ0wAJUmSesYEUJIkqWdMACVJknrGBFCSJKlnTAAlSZJ6xgRQkiSpZ0wAJUmSesYEUJIk\nqWdMACVJknrGBFCSJKlntl7qACRpSpKlDkGSesEEUNIyUksdgCRtZub3h7NDwJIkST1jAihJktQz\nJoCSJEk9YwIoSZLUMyaAkiRJPWMCKEmS1DMmgJIkST1jAihJktQzJoCSJEk9YwIoSZLUMyaAmlWS\nOyf5eJJvJbk0yVuSbLMJ+/u7hYxvsSTZL8k/j6izKskFM6zbJcnnknw2yVsnEN+xSQ5d6P3Ood2j\nkzyyLT8vyco5bHNGkn0nH50kaSYmgBrlRODEqtoTuCewPfD6TdjfSxckqkVWVeuq6vlzqTrD9j+t\nqt+rqkdV1XMWOLwlU1VrquoL7e3z6b4fkqRlzgRQM2o9O9dW1fEAVVXAC4BnJNk+yeGDvVlJTkly\nQFt+SpIN7fWaVvYaYLsk5yZ5Xys7KcnZSS5I8hetbEXr0dqQ5PwkzxsS26okpyc5r/Ws3aWVb9QT\nluTqGY7tZUkuSfKlJB9I8sJWflPvVOu1u6wtH5jklLa8Jsl7Wt1LkwwmdFsnOSbJhUk+k2Tbts3e\nSb7ajudjSW7TyvdI8ul2Dr6YZM9Wflg7J+uTrJ3hGN6W5OIkpwF3GCjfN8nats9PJ9l1yLZ3SHJi\nO3/rkzx4ps9j6jwmeWM7rs8l2WXwfLdzcCfgjCSnt3XvSPKNtq81w45BkrREqsqXr6Ev4DnAPw0p\nXwfsBRwOvGWg/BTgAGA34ApgZ7o/Mk4HDml1rpq2r9u2f1cCFwC3A/YFThuos9OQGE4Gnt6Wnwmc\n1JaPBQ4dqHfVkG33Bc4HtgVuDXwbeGFbdwawb1veBfhOWz4QOLktrwHOBLZudX4CbAWsAn4NPKDV\nOwF4als+HziwLR8NvLEtfx64R1veHzi9LW8Adpvl+B8PfLYt7wb8HDi0xXQWsEtb90TgPUO2/xDw\n3LYc4NYzfR7t/Y3Ak9vyK6Y+98HzDVw2VX/avla083r/6ed4WkwF5cuXL1++xnpR8/kdvzXS+DJi\n/YOAM6rqZwBJ3k+XGJ48ZNvnJ3lcW74L3TDzt4C7J3kz8CngtCFtPIQuCQJ4H/C6MeJ/BF3CeB1w\nXZKTx9h2yier6jfAT5P8CJjqZftOVU3NA1wH3C3JTnTJ0Bdb+XHAh5PsADwU+EiSqfMyNb/yLOC4\nJB+mG4af7gDggwBV9cMkU8Ow9wLuD3yu7XMF8IMh2z8SeEbbvoCpntJhn8c36BLAD7fyfwc+NsN5\nGfx8n5zk/9IlpXcE7gtcOMN2zVEDy6vbS5J0s7XttWlMADWbbwJPGCxoycyuwCXAA9h4GsHgBQCj\nkkSSHEiXiPxOVV2X5AxgZVX9IskDgUcBz6LrxTpi2uY1w25/MxVTS4BuNSqOmbZn4+OZ7rqB5Ru5\n+f/SYPkNI/axAvh5Vd3igoiqenaSBwGPAdYl2beqfj4qeLrzfmFVPWxEvVucv5k+j7luP21fdwP+\nBtivqq5Kcuws+xpw1OgqktRrq9n4j+Oj57UX5wBqRlV1Ot2cvacDJNkKeAPw1tZ7djmwdzq70w1h\nQtdjdECSnds2T+HmP1eub2UAt6FLgK5Lcm9gah7aLsBWVXUS3XDjPkPC+0rbL8DTgS+35cuB327L\nj+XmHrVBXwIel2TbJLcG/nhg3eD2h81wamZzi8S3qq4CfpZkKil7BvDFqroauCzJTUl2kr3av3tU\n1dlVtQb4MbD7kGN4UpsvuRtwUCu/BLj9wJy+rZPcd0icpwNHtjorWmI/9PNoVnDzHwNPoxsCn+4q\nYKe2vBPwS+DqNgfx0UPqS5KWiAmgRnk8cFiSb9HNdbuhql4LUFVn0SVMFwH/TDfkSVVdCbyELulb\nD5xdVae2/R0DXJDuIpBPA9skuQh4NfDVVufOwNok6+mGd18yJK7nAs9Mch5dQjJ1oci7gAPbtg8G\nrpm+YVWtp5uftwH4JF3COuUNwLOTrKObwzgXNcPyoD8D3tDifSDw9638acAR7WKMC4FDWvnr0y6i\nAc6qqg3TjuEk4FK6c/9euoSYqvo1XaL2utbWerrh8umeDxzU9n8OcB/gMwz/PKA7j/unu83N6oH4\nB4/3XcBnkpze4j0PuJhuyHgwYZy191CSNHlpk6+lkVqv0geBx1fVeUsdz0JpV6heXVVvXOpYlqsk\nV1fVrSfcRpkbStK4QlWNnHY1nXMANWdV9TXg7ksdh5aEmZkkbUHsAZS0LNgDKEnzMb8eQOcASpIk\n9YwJoCRJUs+YAEqSJPWMCaAkSVLPmABKkiT1jAmgJElSz5gASpIk9YwJoCRJUs+YAEqSJPWMCaAk\nSVLP+CxgScvI2E8zkiTNgwmgpGXDZ5NL0niS+f3h7BCwJElSz5gASpIk9YwJoCRJUs+YAEqSJPWM\nCaAkSVLPmABKkiT1jAmgJElSz5gASpIk9YwJoCRJUs+YAEqSJPWMCaAkSVLPmABK0hZm7dq1Sx3C\nFsXzubA8n8uDCaAkbWH8BbuwPJ8Ly/O5PJgASpIk9YwJoCRJUs+kqpY6BkkiiT+MJGkeqirjbmMC\nKEmS1DMOAUuSJPWMCaAkSVLPmABKWjRJ/iDJfyT5VpK/naHOW5J8O8l5SfZe7Bg3J6POZ5IDk/wi\nybnt9fKliHNzkOQ9SX6UZMMsdfxuztGo8+l3c+6S3CXJF5JclOSCJM+dod5Y308TQEmLIskK4G3A\no4D7AU9Jcu9pdR4N3KOq7gk8C/iXRQ90MzGX89l8qar2ba9XLWqQm5dj6c7lUH43xzbr+Wz8bs7N\nb4AXVtX9gIcAf7UQPztNACUtlv2Bb1fVFVX1a+BDwGOn1XkscDxAVX0duE2SXRc3zM3GXM4nwNhX\nB/ZRVZ0J/HyWKn43xzCH8wl+N+ekqq6sqvPa8i+Bi4E7T6s29vfTBFDSYrkz8F8D77/HLX+ITa/z\n/SF11JnL+QR4SBsS+mSS+y5OaFskv5sLz+/mmJLcDdgb+Pq0VWN/P7deyMAkScvKOuCuVfW/bYjo\n48CeSxyTBH43x5ZkR+CjwPNaT+AmsQdQ0mL5PnDXgfd3aWXT6+w+oo46I89nVf2yqv63LX8a2CbJ\nzosX4hbF7+YC8rs5niRb0yV/76uqTwypMvb30wRQ0mI5G/g/SVYluRXwZODkaXVOBv4UIMmDgV9U\n1Y8WN8zNxsjzOTgHKMn+dDf//9nihrlZCTPPS/O7Ob4Zz6ffzbH9G/DNqnrzDOvH/n46BCxpUVTV\nDUn+GjiN7o/P91TVxUme1a2uY6rqU0n+MMmlwDXAM5cy5uVsLucTeEKSZwO/Bq4FnrR0ES9vST4A\nrAZ2SfJdYA1wK/xuzsuo84nfzTlL8jDgacAFSdYDBbwUWMUmfD99FJwkSVLPOAQsSZLUMyaAkiRJ\nPWMCKEmS1DMmgJIkST1jAihJkrTIkrwnyY+SbJhD3TcmWZ/k3CSXJNnkW+Z4FbAkSdIiS/Jw4JfA\n8VW11xjb/TWwd1X9xaa0bw+gJEnSIquqM4GfD5Yl2SPJp5OcneSLSYY9Hu8pwAc3tX1vBC1JkrQ8\nHAM8q6r+sz0h5Z3AwVMrk9wVuBvwhU1tyARQkiRpiSXZAXgo8JEkU4/Q22ZatScDH60FmL9nAihJ\nkrT0VgA/r6p9Z6nzZODIhWpMkiRJiy/tRVVdDVyW5Ak3rUz2Gli+N3DbqvraQjRsAihJkrTIknwA\n+AqwZ5LvJnkm8DTgiCTnJbkQOGRgkycBH1qw9r0NjCRJUr/YAyhJktQzJoCSJEk9YwIoSZLUMyaA\nkiRJPWMCKEmS1DMmgJIkST1jAihJktQzJoCSJEk98/8D55q3Ds2FLigAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7f4184b010b8>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "vbg['max'].nlargest(5).plot(kind='barh', figsize=(6, 6))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def only_outliers(row):\n",
    "    \n",
    "    vbg_row = vbg.loc[row['TIPO_BEM_CANDIDATO']]\n",
    "    \n",
    "    mean_tipo_bem = vbg_row['mean']\n",
    "    std_tipo_bem = vbg_row['std']\n",
    "    \n",
    "    return np.abs((row['VALOR_BEM'] - std_tipo_bem)) > 2*std_tipo_bem"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df_out = df[df.apply(only_outliers, axis=1)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(373, 4)"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_out.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "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>SQ_CANDIDATO</th>\n",
       "      <th>TIPO_BEM_CANDIDATO</th>\n",
       "      <th>DS_TIPO_BEM_CANDIDATO</th>\n",
       "      <th>VALOR_BEM</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>907</th>\n",
       "      <td>60000001634</td>\n",
       "      <td>Quotas ou quinhões de capital</td>\n",
       "      <td>QUOTAS DE CAPITAL NA EMPRESA CONSTRUTORA S &amp; V LTDA CNPJ 07.419.365/0001-02</td>\n",
       "      <td>2976000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17791</th>\n",
       "      <td>60000011302</td>\n",
       "      <td>Quotas ou quinhões de capital</td>\n",
       "      <td>EMPRESA JJ EMPREENDIMENTOS LTDA - PERCENTUAL DE 90% DAS QUOTAS</td>\n",
       "      <td>3204000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7011</th>\n",
       "      <td>60000004669</td>\n",
       "      <td>Quotas ou quinhões de capital</td>\n",
       "      <td>50% DAS QUOTAS DO CAPITAL DA EMPRESA ENGEXATA ENGENHARIA LTDA</td>\n",
       "      <td>3250000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4239</th>\n",
       "      <td>60000003287</td>\n",
       "      <td>Quotas ou quinhões de capital</td>\n",
       "      <td>COTAS DE CAPITAL DA FIRMA ICEVA CERAMICA VALE DO ACARAÚ LTDA EM NOME DA CONJUGE</td>\n",
       "      <td>4000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18419</th>\n",
       "      <td>60000011679</td>\n",
       "      <td>Quotas ou quinhões de capital</td>\n",
       "      <td>QUOTAS DE CAPITAL (JUNTO C/ CONJUGUE) COMPESCAL COM. DE PESC. ARAC. LTDA -  CGC 07.108.145/0001-50 CAPITAL SOCIAL AUMENTADO COM LUCROS ACUMULADOS</td>\n",
       "      <td>15993630.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11584</th>\n",
       "      <td>60000007189</td>\n",
       "      <td>Quotas ou quinhões de capital</td>\n",
       "      <td>QUOTAS NA EMPRESA CMACK</td>\n",
       "      <td>20000000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       SQ_CANDIDATO             TIPO_BEM_CANDIDATO  \\\n",
       "907     60000001634  Quotas ou quinhões de capital   \n",
       "17791   60000011302  Quotas ou quinhões de capital   \n",
       "7011    60000004669  Quotas ou quinhões de capital   \n",
       "4239    60000003287  Quotas ou quinhões de capital   \n",
       "18419   60000011679  Quotas ou quinhões de capital   \n",
       "11584   60000007189  Quotas ou quinhões de capital   \n",
       "\n",
       "                                                                                                                                   DS_TIPO_BEM_CANDIDATO  \\\n",
       "907                                                                          QUOTAS DE CAPITAL NA EMPRESA CONSTRUTORA S & V LTDA CNPJ 07.419.365/0001-02   \n",
       "17791                                                                                     EMPRESA JJ EMPREENDIMENTOS LTDA - PERCENTUAL DE 90% DAS QUOTAS   \n",
       "7011                                                                                       50% DAS QUOTAS DO CAPITAL DA EMPRESA ENGEXATA ENGENHARIA LTDA   \n",
       "4239                                                                     COTAS DE CAPITAL DA FIRMA ICEVA CERAMICA VALE DO ACARAÚ LTDA EM NOME DA CONJUGE   \n",
       "18419  QUOTAS DE CAPITAL (JUNTO C/ CONJUGUE) COMPESCAL COM. DE PESC. ARAC. LTDA -  CGC 07.108.145/0001-50 CAPITAL SOCIAL AUMENTADO COM LUCROS ACUMULADOS   \n",
       "11584                                                                                                                            QUOTAS NA EMPRESA CMACK   \n",
       "\n",
       "        VALOR_BEM  \n",
       "907     2976000.0  \n",
       "17791   3204000.0  \n",
       "7011    3250000.0  \n",
       "4239    4000000.0  \n",
       "18419  15993630.0  \n",
       "11584  20000000.0  "
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_out[df_out.TIPO_BEM_CANDIDATO == 'Quotas ou quinhões de capital']\\\n",
    ".sort_values('VALOR_BEM')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "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>SQ_CANDIDATO</th>\n",
       "      <th>TIPO_BEM_CANDIDATO</th>\n",
       "      <th>DS_TIPO_BEM_CANDIDATO</th>\n",
       "      <th>VALOR_BEM</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>23598</th>\n",
       "      <td>60000015032</td>\n",
       "      <td>Veículo automotor terrestre: caminhão, automóvel, moto, etc.</td>\n",
       "      <td>UM CARRO ESCORT XR3 VENDIDO PARA SUCATA A VARIOS ANOS</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25737</th>\n",
       "      <td>60000016480</td>\n",
       "      <td>Veículo automotor terrestre: caminhão, automóvel, moto, etc.</td>\n",
       "      <td>UM CARRO MODELO VOYAGE ANO 2013 PLACA DRV5694</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14629</th>\n",
       "      <td>60000009015</td>\n",
       "      <td>Veículo automotor terrestre: caminhão, automóvel, moto, etc.</td>\n",
       "      <td>MOTO HONDA/NXR150 BROS ES ANO 2009 COR PRETA</td>\n",
       "      <td>4.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11608</th>\n",
       "      <td>60000007198</td>\n",
       "      <td>Veículo automotor terrestre: caminhão, automóvel, moto, etc.</td>\n",
       "      <td>MOTO SHINERAY 49 CC, JET</td>\n",
       "      <td>4.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19719</th>\n",
       "      <td>60000012478</td>\n",
       "      <td>Veículo automotor terrestre: caminhão, automóvel, moto, etc.</td>\n",
       "      <td>TENHO UM VEICULO DE MARCA BELINA DEL REY ANO 91 DE PLACA - HUI 2823</td>\n",
       "      <td>5.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19715</th>\n",
       "      <td>60000012476</td>\n",
       "      <td>Veículo automotor terrestre: caminhão, automóvel, moto, etc.</td>\n",
       "      <td>CARRO MARCA MERCERDES BENZ CLASSE A 160, ANO 2000 PLACA HWE 0803</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25063</th>\n",
       "      <td>60000016042</td>\n",
       "      <td>Veículo automotor terrestre: caminhão, automóvel, moto, etc.</td>\n",
       "      <td>AUTOMOVEL FIAT PALIO ANO 2004 NO VALOR DE R$ 15.000,00</td>\n",
       "      <td>15.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14573</th>\n",
       "      <td>60000008978</td>\n",
       "      <td>Veículo automotor terrestre: caminhão, automóvel, moto, etc.</td>\n",
       "      <td>POSSUO UM CARRO VOYAGE DE COR CINZA, ANO 2009 MODELO 2010 COM A OLACA HMJ 4447</td>\n",
       "      <td>20.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15161</th>\n",
       "      <td>60000009436</td>\n",
       "      <td>Veículo automotor terrestre: caminhão, automóvel, moto, etc.</td>\n",
       "      <td>01 CARRO FIAT/PALIO FIRE ANO 2011/2012, PLACA: OCJ 7192</td>\n",
       "      <td>20.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25876</th>\n",
       "      <td>60000016565</td>\n",
       "      <td>Veículo automotor terrestre: caminhão, automóvel, moto, etc.</td>\n",
       "      <td>1 VEICULO PRISMA 1.0 ANO 2013 COR PRATA</td>\n",
       "      <td>35.94</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       SQ_CANDIDATO  \\\n",
       "23598   60000015032   \n",
       "25737   60000016480   \n",
       "14629   60000009015   \n",
       "11608   60000007198   \n",
       "19719   60000012478   \n",
       "19715   60000012476   \n",
       "25063   60000016042   \n",
       "14573   60000008978   \n",
       "15161   60000009436   \n",
       "25876   60000016565   \n",
       "\n",
       "                                                 TIPO_BEM_CANDIDATO  \\\n",
       "23598  Veículo automotor terrestre: caminhão, automóvel, moto, etc.   \n",
       "25737  Veículo automotor terrestre: caminhão, automóvel, moto, etc.   \n",
       "14629  Veículo automotor terrestre: caminhão, automóvel, moto, etc.   \n",
       "11608  Veículo automotor terrestre: caminhão, automóvel, moto, etc.   \n",
       "19719  Veículo automotor terrestre: caminhão, automóvel, moto, etc.   \n",
       "19715  Veículo automotor terrestre: caminhão, automóvel, moto, etc.   \n",
       "25063  Veículo automotor terrestre: caminhão, automóvel, moto, etc.   \n",
       "14573  Veículo automotor terrestre: caminhão, automóvel, moto, etc.   \n",
       "15161  Veículo automotor terrestre: caminhão, automóvel, moto, etc.   \n",
       "25876  Veículo automotor terrestre: caminhão, automóvel, moto, etc.   \n",
       "\n",
       "                                                                DS_TIPO_BEM_CANDIDATO  \\\n",
       "23598                           UM CARRO ESCORT XR3 VENDIDO PARA SUCATA A VARIOS ANOS   \n",
       "25737                                   UM CARRO MODELO VOYAGE ANO 2013 PLACA DRV5694   \n",
       "14629                                    MOTO HONDA/NXR150 BROS ES ANO 2009 COR PRETA   \n",
       "11608                                                        MOTO SHINERAY 49 CC, JET   \n",
       "19719             TENHO UM VEICULO DE MARCA BELINA DEL REY ANO 91 DE PLACA - HUI 2823   \n",
       "19715                CARRO MARCA MERCERDES BENZ CLASSE A 160, ANO 2000 PLACA HWE 0803   \n",
       "25063                          AUTOMOVEL FIAT PALIO ANO 2004 NO VALOR DE R$ 15.000,00   \n",
       "14573  POSSUO UM CARRO VOYAGE DE COR CINZA, ANO 2009 MODELO 2010 COM A OLACA HMJ 4447   \n",
       "15161                         01 CARRO FIAT/PALIO FIRE ANO 2011/2012, PLACA: OCJ 7192   \n",
       "25876                                         1 VEICULO PRISMA 1.0 ANO 2013 COR PRATA   \n",
       "\n",
       "       VALOR_BEM  \n",
       "23598       1.00  \n",
       "25737       1.00  \n",
       "14629       4.00  \n",
       "11608       4.00  \n",
       "19719       5.00  \n",
       "19715      10.00  \n",
       "25063      15.00  \n",
       "14573      20.00  \n",
       "15161      20.00  \n",
       "25876      35.94  "
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "is_veiculo = df.TIPO_BEM_CANDIDATO == 'Veículo automotor terrestre: caminhão, automóvel, moto, etc.'\n",
    "is_lt_5k = df.VALOR_BEM < 5000\n",
    "df[is_veiculo & is_lt_5k].sort_values('VALOR_BEM').head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# RS, que dados ruins..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [Root]",
   "language": "python",
   "name": "Python [Root]"
  },
  "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": 0
}