Cuadernos/Intro_Pandas.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "2--PW8ExNrgi"
   },
   "source": [
    "# Introducción a funciones en Python y al paquete Pandas\n",
    "\n",
    "**Universidad Central**\n",
    "\n",
    "*Carlos Zainea, Daniel Montenegro y Luis Campos*"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "VuSLMMBsNrgt"
   },
   "source": [
    "Uno de los paquetes fundamentales y más usados para el análisis de datos es [pandas](https://pandas.pydata.org/pandas-docs/stable/getting_started/index.html), una biblioteca de software que ofrece la posibilidad de estructurar y explorar colecciones de datos de forma rapida y sencilla caracterizado por la fluidez en diversas funciones.\n",
    "\n",
    "Usaremos este paquete para extraer información importante de la base [Predios2018](https://www.datos.gov.co/Ordenamiento-Territorial/Predios-de-Bogot-/twbp-6xh5) que contiene alrededor de 5.5 millones de registros con 22 características.\n",
    "\n",
    "\n",
    "Iniciamos importando los paquetes:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-27T23:28:35.955336Z",
     "start_time": "2020-01-27T23:28:35.728400Z"
    },
    "colab": {},
    "colab_type": "code",
    "id": "9hh0EiEFNrg0"
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "K-lGPOfrNrhI"
   },
   "source": [
    "## Funciones básicas de pandas\n",
    "\n",
    "Lo primero que debemos tener en cuenta es que la libreria pandas admite dos tipos de arreglos de datos, las series que expresan un arreglo lineal de información y los marcos de datos (DataFrames), que  corresponden a colecciones de series. Veamos a continuación algunos ejemplos:"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "GwSkNjoZNrhN"
   },
   "source": [
    "## Series\n",
    "\n",
    "A continuación listamos los valores [1, 3, 5, nan, 6, 8] y lo asignamos a la variable s usando pandas:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-27T23:29:43.997943Z",
     "start_time": "2020-01-27T23:29:43.986914Z"
    },
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 173
    },
    "colab_type": "code",
    "executionInfo": {
     "elapsed": 2874,
     "status": "ok",
     "timestamp": 1580333630749,
     "user": {
      "displayName": "daniel mauricio montenegro reyes",
      "photoUrl": "",
      "userId": "12701434767844263388"
     },
     "user_tz": 300
    },
    "id": "X0qxbRd1NrhT",
    "outputId": "c74ed349-28dc-4526-c7a4-ae0f5e62b058"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Mi serie es:\n",
      "\n",
      "0    1.0\n",
      "1    3.0\n",
      "2    5.0\n",
      "3    NaN\n",
      "4    6.0\n",
      "5    8.0\n",
      "dtype: float64\n"
     ]
    }
   ],
   "source": [
    "s = pd.Series([1, 3, 5, np.nan, 6, 8])\n",
    "print(\"Mi serie es:\\n\")\n",
    "print(s)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "zoVsAN-ANrhh"
   },
   "source": [
    "## Dataframe\n",
    "\n",
    " Podemos crear un DataFrame a partir de diferentes tipos de datos. Para esto., debemos nombrar las variables y los individuos para representarlo más informativamente.\n",
    " \n",
    " **Ejemplo:**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-27T23:37:49.618659Z",
     "start_time": "2020-01-27T23:37:49.613642Z"
    },
    "colab": {},
    "colab_type": "code",
    "id": "tiG3tukhNrhk"
   },
   "outputs": [],
   "source": [
    "# Individuos (Fechas)\n",
    "# M = Month end Frequency \n",
    "dates = pd.date_range('20130101', periods=6,freq='M')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-27T23:37:50.608325Z",
     "start_time": "2020-01-27T23:37:50.604533Z"
    },
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 225
    },
    "colab_type": "code",
    "executionInfo": {
     "elapsed": 2850,
     "status": "ok",
     "timestamp": 1580333630752,
     "user": {
      "displayName": "daniel mauricio montenegro reyes",
      "photoUrl": "",
      "userId": "12701434767844263388"
     },
     "user_tz": 300
    },
    "id": "DenucaoKNrhy",
    "outputId": "04fa1da1-16f5-4b93-f7d3-284c416fb522"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "DatetimeIndex(['2013-01-31', '2013-02-28', '2013-03-31', '2013-04-30',\n",
      "               '2013-05-31', '2013-06-30'],\n",
      "              dtype='datetime64[ns]', freq='M')\n",
      "\n",
      " Showing Vertically:\n",
      "\n",
      "2013-01-31 00:00:00\n",
      "2013-02-28 00:00:00\n",
      "2013-03-31 00:00:00\n",
      "2013-04-30 00:00:00\n",
      "2013-05-31 00:00:00\n",
      "2013-06-30 00:00:00\n"
     ]
    }
   ],
   "source": [
    "# Showing horizontally\n",
    "print(dates)\n",
    "print(\"\\n Showing Vertically:\\n\")\n",
    "\n",
    "# Showing Vertically\n",
    "for date in dates:\n",
    "    print(date)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "-Md9NDzmNriA"
   },
   "source": [
    "Hagamos un proceso de **simulación**. \n",
    "\n",
    "Para esto, inventamos algunos datos al azar..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-27T23:42:22.530002Z",
     "start_time": "2020-01-27T23:42:22.525731Z"
    },
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 121
    },
    "colab_type": "code",
    "executionInfo": {
     "elapsed": 2832,
     "status": "ok",
     "timestamp": 1580333630753,
     "user": {
      "displayName": "daniel mauricio montenegro reyes",
      "photoUrl": "",
      "userId": "12701434767844263388"
     },
     "user_tz": 300
    },
    "id": "ci7KPrF5NriF",
    "outputId": "96eae235-d620-4847-9f15-1007399c00bf"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[[-1.77537614 -0.63218881  0.1085777  -0.30463557]\n",
      " [ 1.70283615 -0.84213153  0.07512821  2.05455142]\n",
      " [ 0.5770894   1.26373082  1.28895269 -0.41708178]\n",
      " [-1.24620525 -1.54527793 -1.0794236   0.06459746]\n",
      " [-0.82980599  0.50295498 -0.95816548  0.83612532]\n",
      " [-0.10631549  0.13938595  0.83325148 -0.02155537]]\n"
     ]
    }
   ],
   "source": [
    "A=np.random.randn(6,4)\n",
    "print(A)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "4ZRapPEuNriO"
   },
   "source": [
    "Ahora, nos inventamos los **nombres de las variables**..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-27T23:44:06.610046Z",
     "start_time": "2020-01-27T23:44:06.605989Z"
    },
    "colab": {},
    "colab_type": "code",
    "id": "gWVpNsBhNriT"
   },
   "outputs": [],
   "source": [
    "variables=list(\"ABCD\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "k6YjhMOwNrif"
   },
   "source": [
    "Finalmente, podemos concatenar toda esta **información** en un DataFrame:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-27T23:44:44.979872Z",
     "start_time": "2020-01-27T23:44:44.975506Z"
    },
    "colab": {},
    "colab_type": "code",
    "id": "0AIuteVfNrij"
   },
   "outputs": [],
   "source": [
    "df = pd.DataFrame(A, index=dates, columns=variables)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-27T23:44:59.208000Z",
     "start_time": "2020-01-27T23:44:59.193192Z"
    },
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 238
    },
    "colab_type": "code",
    "executionInfo": {
     "elapsed": 2799,
     "status": "ok",
     "timestamp": 1580333630758,
     "user": {
      "displayName": "daniel mauricio montenegro reyes",
      "photoUrl": "",
      "userId": "12701434767844263388"
     },
     "user_tz": 300
    },
    "id": "T53B_SSRNrit",
    "outputId": "06192b2e-43bf-4f56-efd2-5ac2f84fc963"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>A</th>\n",
       "      <th>B</th>\n",
       "      <th>C</th>\n",
       "      <th>D</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2013-01-31</th>\n",
       "      <td>-1.775376</td>\n",
       "      <td>-0.632189</td>\n",
       "      <td>0.108578</td>\n",
       "      <td>-0.304636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-02-28</th>\n",
       "      <td>1.702836</td>\n",
       "      <td>-0.842132</td>\n",
       "      <td>0.075128</td>\n",
       "      <td>2.054551</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-03-31</th>\n",
       "      <td>0.577089</td>\n",
       "      <td>1.263731</td>\n",
       "      <td>1.288953</td>\n",
       "      <td>-0.417082</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-04-30</th>\n",
       "      <td>-1.246205</td>\n",
       "      <td>-1.545278</td>\n",
       "      <td>-1.079424</td>\n",
       "      <td>0.064597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-05-31</th>\n",
       "      <td>-0.829806</td>\n",
       "      <td>0.502955</td>\n",
       "      <td>-0.958165</td>\n",
       "      <td>0.836125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-06-30</th>\n",
       "      <td>-0.106315</td>\n",
       "      <td>0.139386</td>\n",
       "      <td>0.833251</td>\n",
       "      <td>-0.021555</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   A         B         C         D\n",
       "2013-01-31 -1.775376 -0.632189  0.108578 -0.304636\n",
       "2013-02-28  1.702836 -0.842132  0.075128  2.054551\n",
       "2013-03-31  0.577089  1.263731  1.288953 -0.417082\n",
       "2013-04-30 -1.246205 -1.545278 -1.079424  0.064597\n",
       "2013-05-31 -0.829806  0.502955 -0.958165  0.836125\n",
       "2013-06-30 -0.106315  0.139386  0.833251 -0.021555"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "X_6fEAYENrkB"
   },
   "source": [
    "## Pandas y la carga de datos\n",
    "Después de cargar pandas configuramos la opción que nos permita ver todas las columnas de nuestra base de datos:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-27T19:32:24.786051Z",
     "start_time": "2020-01-27T19:32:24.783402Z"
    },
    "colab": {},
    "colab_type": "code",
    "id": "zqqQm2tZNrkD"
   },
   "outputs": [],
   "source": [
    "pd.set_option('display.max_columns', None)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "FLVJA0RyNrkL"
   },
   "source": [
    "La función [set_option de pandas](https://pandas.pydata.org/pandas-docs/stable/user_guide/options.html) nos permite personalizar la vista de los datos en la consola de salida. Podemos establecer a cantidad de columnas o filas que apareceran en el output de la celda que presente el DataFrame que guardamos. "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "n3n7nAWrNrkP"
   },
   "source": [
    "# Ejemplo Juguete\n",
    "\n",
    "hagamos una primera base de datos usando pandas. Supongamos que podemos medir la velocidad de ciertos animales que vemos pasar en el aire. vemos dos águilas y dos loros a diferentes velocidad que registramos en un papel.\n",
    "\n",
    "| Animal | Max Speed |\n",
    "| -------| --------- |\n",
    "| Falcon |   380     |\n",
    "| Parrot | 24        |\n",
    "| Falcon |   370     |\n",
    "| Parrot | 26        |\n",
    "\n",
    "Si queremos colocar dichos datos en un **DataFrame** de pandas, el procedimiento es el siguiente:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 175
    },
    "colab_type": "code",
    "executionInfo": {
     "elapsed": 2702,
     "status": "ok",
     "timestamp": 1580333630770,
     "user": {
      "displayName": "daniel mauricio montenegro reyes",
      "photoUrl": "",
      "userId": "12701434767844263388"
     },
     "user_tz": 300
    },
    "id": "w1ZQLHFUNrkS",
    "outputId": "b0b49b8f-8dbd-4794-aabf-4f27d46ef68c"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Animal</th>\n",
       "      <th>Max Speed</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Falcon</td>\n",
       "      <td>380.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Parrot</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Falcon</td>\n",
       "      <td>370.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Parrot</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Animal  Max Speed\n",
       "0  Falcon      380.0\n",
       "1  Parrot       24.0\n",
       "2  Falcon      370.0\n",
       "3  Parrot       26.0"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame({'Animal': ['Falcon', 'Parrot','Falcon', 'Parrot'],\n",
    "                'Max Speed': [380., 24., 370., 26.]})\n",
    "\n",
    "df\n",
    "#print(df) # Look for the differences in the outputs"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Eliminar Registros "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Animal</th>\n",
       "      <th>Max Speed</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Parrot</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Falcon</td>\n",
       "      <td>370.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Parrot</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Animal  Max Speed\n",
       "1  Parrot       24.0\n",
       "2  Falcon      370.0\n",
       "3  Parrot       26.0"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_mod=df.drop([0])\n",
    "df_mod"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "OYHNHh1UNrka"
   },
   "source": [
    "Ahora podemos **jugar con los datos**, es decir, podemos organizarlos y hacer cálculos con ellos que sean de nuestro interes:\n",
    "\n",
    "**Ejemplo:**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 34
    },
    "colab_type": "code",
    "executionInfo": {
     "elapsed": 2692,
     "status": "ok",
     "timestamp": 1580333630772,
     "user": {
      "displayName": "daniel mauricio montenegro reyes",
      "photoUrl": "",
      "userId": "12701434767844263388"
     },
     "user_tz": 300
    },
    "id": "XIdVfnGUNrkf",
    "outputId": "e42fcabc-eff0-4cf8-f75c-807c285b1fe6"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pandas.core.groupby.generic.DataFrameGroupBy object at 0x7f52bb6a2ad0>"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby(['Animal'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "-rZH4HvyNrkm"
   },
   "source": [
    "Como podemos ver (o más bien, no podemos), **groupby** no genera un DataFame como tal, sino un objeto **DataFrameGroupBy**, que contiene información sobre los grupos, pero nada más.\n",
    "\n",
    "Esto quiere decir, que si queremos información detallada, debemos aplicar alguna operación a dicha agrupación:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 143
    },
    "colab_type": "code",
    "executionInfo": {
     "elapsed": 2681,
     "status": "ok",
     "timestamp": 1580333630773,
     "user": {
      "displayName": "daniel mauricio montenegro reyes",
      "photoUrl": "",
      "userId": "12701434767844263388"
     },
     "user_tz": 300
    },
    "id": "r3X5V4GQNrko",
    "outputId": "fe770646-2ac4-4005-b849-630698a3afb0"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Max Speed</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Animal</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Falcon</th>\n",
       "      <td>375.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Parrot</th>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Max Speed\n",
       "Animal           \n",
       "Falcon      375.0\n",
       "Parrot       25.0"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_proc=df.groupby(['Animal']).mean()\n",
    "df_proc"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "FemxKwkqNrky"
   },
   "source": [
    "# Bases de Datos Serias:\n",
    "\n",
    "La siguiente celda de código carga los datos del archivo `Predios2016.csv` usando la función [`pd.read_csv`]() observe que en la declaración de carga de datos indico la separación en csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv('~/Data/Predios_2018.csv',delimiter=',',low_memory=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "mAp2gnwcNrk7"
   },
   "source": [
    "Antes de cualquier cosa, verifiquemos el **tamaño de los datos**:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "YhynDVRTNrk-"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "En total, hay 5,513,625 registros\n",
      "La dimensión de la base de datos es:  (5513625, 22)\n"
     ]
    }
   ],
   "source": [
    "print(\"En total, hay \"+\"{:,}\".format(len(df))+\" registros\")\n",
    "print(\"La dimensión de la base de datos es: \", df.shape)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "ZUSpvpTeNrlF"
   },
   "source": [
    "¿Cómo se hace esto? [Mira aquí](https://mkaz.blog/code/python-string-format-cookbook/).\n",
    "\n",
    "Vaya que es **\"grande\"** ésta base.\n",
    "\n",
    "Analicemos algunas propiedades básicas:"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "BB2fcwkNNrlH"
   },
   "source": [
    "## Propiedades principales de la BSD:\n",
    "\n",
    "### Cabezales"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "_7sDDH9iNrlK"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CODIGO_BARRIO</th>\n",
       "      <th>NOMBRE_BARRIO</th>\n",
       "      <th>CODIGO_MANZANA</th>\n",
       "      <th>CODIGO_PREDIO</th>\n",
       "      <th>CODIGO_CONSTRUCCION</th>\n",
       "      <th>CODIGO_RESTO</th>\n",
       "      <th>TIPO_PROPIEDAD</th>\n",
       "      <th>CODIGO_DESTINO</th>\n",
       "      <th>FECHA_INCORPORACION</th>\n",
       "      <th>AVALUO_ANO</th>\n",
       "      <th>CLASE_PREDIO</th>\n",
       "      <th>DIRECCION_REAL</th>\n",
       "      <th>MARCA_DIRECCION</th>\n",
       "      <th>VIGENCIA_FORMACION</th>\n",
       "      <th>AREA_CONSTRUIDA</th>\n",
       "      <th>CEDULA_CATASTRAL</th>\n",
       "      <th>CHIP</th>\n",
       "      <th>DESCRIPCION_DESTINO</th>\n",
       "      <th>VIGENCIA_ACTUALIZACION</th>\n",
       "      <th>TIPO_DIRECCION(S/I)</th>\n",
       "      <th>DIRECCION(S/I)</th>\n",
       "      <th>ZONA_HOMOGENEA_FISICA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1101.0</td>\n",
       "      <td>LAS BRISAS</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 7 1 92 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>42.03</td>\n",
       "      <td>25 6 18</td>\n",
       "      <td>AAA0000AOSK</td>\n",
       "      <td>COMERCIO PUNTUAL</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.712215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1101.0</td>\n",
       "      <td>LAS BRISAS</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 7 1 90 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>52.45</td>\n",
       "      <td>25 6 19</td>\n",
       "      <td>AAA0000AOTO</td>\n",
       "      <td>COMERCIO PUNTUAL</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.712215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1101.0</td>\n",
       "      <td>LAS BRISAS</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 7 1 86 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>10.02</td>\n",
       "      <td>2S 6 20</td>\n",
       "      <td>AAA0000AOUZ</td>\n",
       "      <td>COMERCIO PUNTUAL</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.712215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1101.0</td>\n",
       "      <td>LAS BRISAS</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 7 1 82 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>106.4</td>\n",
       "      <td>2S 6 22</td>\n",
       "      <td>AAA0000AOWF</td>\n",
       "      <td>COMERCIO PUNTUAL</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.712215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1101.0</td>\n",
       "      <td>LAS BRISAS</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 7 1 70 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>57.78</td>\n",
       "      <td>2S 6 23</td>\n",
       "      <td>AAA0000AOXR</td>\n",
       "      <td>COMERCIO PUNTUAL</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.712215e+12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   CODIGO_BARRIO NOMBRE_BARRIO  CODIGO_MANZANA  CODIGO_PREDIO  \\\n",
       "0         1101.0    LAS BRISAS             1.0            1.0   \n",
       "1         1101.0    LAS BRISAS             1.0            2.0   \n",
       "2         1101.0    LAS BRISAS             1.0            3.0   \n",
       "3         1101.0    LAS BRISAS             1.0            4.0   \n",
       "4         1101.0    LAS BRISAS             1.0            5.0   \n",
       "\n",
       "   CODIGO_CONSTRUCCION  CODIGO_RESTO  TIPO_PROPIEDAD  CODIGO_DESTINO  \\\n",
       "0                  0.0           0.0             6.0            23.0   \n",
       "1                  0.0           0.0             6.0            23.0   \n",
       "2                  0.0           0.0             6.0            23.0   \n",
       "3                  0.0           0.0             6.0            23.0   \n",
       "4                  0.0           0.0             6.0            23.0   \n",
       "\n",
       "      FECHA_INCORPORACION  AVALUO_ANO CLASE_PREDIO DIRECCION_REAL  \\\n",
       "0  12/31/1997 12:00:00 AM      2017.0            N  KR 7 1 92 SUR   \n",
       "1  12/31/1997 12:00:00 AM      2017.0            N  KR 7 1 90 SUR   \n",
       "2  12/31/1997 12:00:00 AM      2017.0            N  KR 7 1 86 SUR   \n",
       "3  12/31/1997 12:00:00 AM      2017.0            N  KR 7 1 82 SUR   \n",
       "4  12/31/1997 12:00:00 AM      2017.0            N  KR 7 1 70 SUR   \n",
       "\n",
       "  MARCA_DIRECCION  VIGENCIA_FORMACION AREA_CONSTRUIDA CEDULA_CATASTRAL  \\\n",
       "0               D              1998.0           42.03          25 6 18   \n",
       "1               D              1998.0           52.45          25 6 19   \n",
       "2               D              1998.0           10.02          2S 6 20   \n",
       "3               D              1998.0           106.4          2S 6 22   \n",
       "4               D              1998.0           57.78          2S 6 23   \n",
       "\n",
       "          CHIP DESCRIPCION_DESTINO  VIGENCIA_ACTUALIZACION  \\\n",
       "0  AAA0000AOSK    COMERCIO PUNTUAL                  2017.0   \n",
       "1  AAA0000AOTO    COMERCIO PUNTUAL                  2017.0   \n",
       "2  AAA0000AOUZ    COMERCIO PUNTUAL                  2017.0   \n",
       "3  AAA0000AOWF    COMERCIO PUNTUAL                  2017.0   \n",
       "4  AAA0000AOXR    COMERCIO PUNTUAL                  2017.0   \n",
       "\n",
       "  TIPO_DIRECCION(S/I) DIRECCION(S/I)  ZONA_HOMOGENEA_FISICA  \n",
       "0                 NaN            NaN           6.712215e+12  \n",
       "1                 NaN            NaN           6.712215e+12  \n",
       "2                 NaN            NaN           6.712215e+12  \n",
       "3                 NaN            NaN           6.712215e+12  \n",
       "4                 NaN            NaN           6.712215e+12  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Cabezal de la base de datos... No aporta mucha información\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "IrahXTzQNrlQ"
   },
   "source": [
    "### Colas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-28T00:57:37.729618Z",
     "start_time": "2020-01-28T00:57:37.702444Z"
    },
    "colab": {},
    "colab_type": "code",
    "id": "jqS4wE-UNrlU"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CODIGO_BARRIO</th>\n",
       "      <th>NOMBRE_BARRIO</th>\n",
       "      <th>CODIGO_MANZANA</th>\n",
       "      <th>CODIGO_PREDIO</th>\n",
       "      <th>CODIGO_CONSTRUCCION</th>\n",
       "      <th>CODIGO_RESTO</th>\n",
       "      <th>TIPO_PROPIEDAD</th>\n",
       "      <th>CODIGO_DESTINO</th>\n",
       "      <th>FECHA_INCORPORACION</th>\n",
       "      <th>AVALUO_ANO</th>\n",
       "      <th>CLASE_PREDIO</th>\n",
       "      <th>DIRECCION_REAL</th>\n",
       "      <th>MARCA_DIRECCION</th>\n",
       "      <th>VIGENCIA_FORMACION</th>\n",
       "      <th>AREA_CONSTRUIDA</th>\n",
       "      <th>CEDULA_CATASTRAL</th>\n",
       "      <th>CHIP</th>\n",
       "      <th>DESCRIPCION_DESTINO</th>\n",
       "      <th>VIGENCIA_ACTUALIZACION</th>\n",
       "      <th>TIPO_DIRECCION(S/I)</th>\n",
       "      <th>DIRECCION(S/I)</th>\n",
       "      <th>ZONA_HOMOGENEA_FISICA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5513620</th>\n",
       "      <td>209106.0</td>\n",
       "      <td>LA UNION URBANO</td>\n",
       "      <td>5.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>02/10/2016 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 4 3 06 LAUNION</td>\n",
       "      <td>D</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>55.1</td>\n",
       "      <td>209106052400000000</td>\n",
       "      <td>AAA0251CPHK</td>\n",
       "      <td>RESIDENCIAL</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.901142e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5513621</th>\n",
       "      <td>209106.0</td>\n",
       "      <td>LA UNION URBANO</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12/31/2000 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>N</td>\n",
       "      <td>CL 4 2 06 LAUNION</td>\n",
       "      <td>D</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>70</td>\n",
       "      <td>209106060100000000</td>\n",
       "      <td>AAA0157PTCN</td>\n",
       "      <td>RESIDENCIAL</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.901142e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5513622</th>\n",
       "      <td>209106.0</td>\n",
       "      <td>LA UNION URBANO</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>05/24/2012 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 3 3 82 LAUNION</td>\n",
       "      <td>D</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>175.25</td>\n",
       "      <td>209106060200000000</td>\n",
       "      <td>AAA0229CJLW</td>\n",
       "      <td>RESIDENCIAL</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>S</td>\n",
       "      <td>KR 3 3 86 LAUNION</td>\n",
       "      <td>2.901142e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5513623</th>\n",
       "      <td>209106.0</td>\n",
       "      <td>LA UNION URBANO</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>12/31/2000 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>N</td>\n",
       "      <td>CL 4 3 06 LAUNION</td>\n",
       "      <td>D</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>0</td>\n",
       "      <td>209106060300000000</td>\n",
       "      <td>AAA0157PTEP</td>\n",
       "      <td>PREDIO RURAL PARCEL. NO EDIFI.</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.901142e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5513624</th>\n",
       "      <td>209106.0</td>\n",
       "      <td>LA UNION URBANO</td>\n",
       "      <td>99.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>12/18/2015 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 3 2 01 LAUNION</td>\n",
       "      <td>D</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>0</td>\n",
       "      <td>209106990100000000</td>\n",
       "      <td>AAA0250LPFZ</td>\n",
       "      <td>VIAS</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.901142e+12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         CODIGO_BARRIO    NOMBRE_BARRIO  CODIGO_MANZANA  CODIGO_PREDIO  \\\n",
       "5513620       209106.0  LA UNION URBANO             5.0           24.0   \n",
       "5513621       209106.0  LA UNION URBANO             6.0            1.0   \n",
       "5513622       209106.0  LA UNION URBANO             6.0            2.0   \n",
       "5513623       209106.0  LA UNION URBANO             6.0            3.0   \n",
       "5513624       209106.0  LA UNION URBANO            99.0            1.0   \n",
       "\n",
       "         CODIGO_CONSTRUCCION  CODIGO_RESTO  TIPO_PROPIEDAD  CODIGO_DESTINO  \\\n",
       "5513620                  0.0           0.0             6.0             1.0   \n",
       "5513621                  0.0           0.0             6.0             1.0   \n",
       "5513622                  0.0           0.0             6.0             1.0   \n",
       "5513623                  0.0           0.0             6.0            89.0   \n",
       "5513624                  0.0           0.0             2.0            65.0   \n",
       "\n",
       "            FECHA_INCORPORACION  AVALUO_ANO CLASE_PREDIO     DIRECCION_REAL  \\\n",
       "5513620  02/10/2016 12:00:00 AM      2018.0            N  KR 4 3 06 LAUNION   \n",
       "5513621  12/31/2000 12:00:00 AM      2018.0            N  CL 4 2 06 LAUNION   \n",
       "5513622  05/24/2012 12:00:00 AM      2018.0            N  KR 3 3 82 LAUNION   \n",
       "5513623  12/31/2000 12:00:00 AM      2018.0            N  CL 4 3 06 LAUNION   \n",
       "5513624  12/18/2015 12:00:00 AM      2018.0            N  KR 3 2 01 LAUNION   \n",
       "\n",
       "        MARCA_DIRECCION  VIGENCIA_FORMACION AREA_CONSTRUIDA  \\\n",
       "5513620               D              2001.0            55.1   \n",
       "5513621               D              2001.0              70   \n",
       "5513622               D              2001.0          175.25   \n",
       "5513623               D              2001.0               0   \n",
       "5513624               D              2001.0               0   \n",
       "\n",
       "           CEDULA_CATASTRAL         CHIP             DESCRIPCION_DESTINO  \\\n",
       "5513620  209106052400000000  AAA0251CPHK                     RESIDENCIAL   \n",
       "5513621  209106060100000000  AAA0157PTCN                     RESIDENCIAL   \n",
       "5513622  209106060200000000  AAA0229CJLW                     RESIDENCIAL   \n",
       "5513623  209106060300000000  AAA0157PTEP  PREDIO RURAL PARCEL. NO EDIFI.   \n",
       "5513624  209106990100000000  AAA0250LPFZ                            VIAS   \n",
       "\n",
       "         VIGENCIA_ACTUALIZACION TIPO_DIRECCION(S/I)     DIRECCION(S/I)  \\\n",
       "5513620                  2017.0                 NaN                NaN   \n",
       "5513621                  2017.0                 NaN                NaN   \n",
       "5513622                  2017.0                   S  KR 3 3 86 LAUNION   \n",
       "5513623                  2017.0                 NaN                NaN   \n",
       "5513624                  2017.0                 NaN                NaN   \n",
       "\n",
       "         ZONA_HOMOGENEA_FISICA  \n",
       "5513620           2.901142e+12  \n",
       "5513621           2.901142e+12  \n",
       "5513622           2.901142e+12  \n",
       "5513623           2.901142e+12  \n",
       "5513624           2.901142e+12  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "D0cti2wvNrld"
   },
   "source": [
    "Podemos por ejemplo, sacar una **muestra aleatoria** de dicha base para darnos una idea de lo que contiene:"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "xn9XAl6QNrlf"
   },
   "source": [
    "### Muestreo"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "62ForM_mNrli"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CODIGO_BARRIO</th>\n",
       "      <th>NOMBRE_BARRIO</th>\n",
       "      <th>CODIGO_MANZANA</th>\n",
       "      <th>CODIGO_PREDIO</th>\n",
       "      <th>CODIGO_CONSTRUCCION</th>\n",
       "      <th>CODIGO_RESTO</th>\n",
       "      <th>TIPO_PROPIEDAD</th>\n",
       "      <th>CODIGO_DESTINO</th>\n",
       "      <th>FECHA_INCORPORACION</th>\n",
       "      <th>AVALUO_ANO</th>\n",
       "      <th>CLASE_PREDIO</th>\n",
       "      <th>DIRECCION_REAL</th>\n",
       "      <th>MARCA_DIRECCION</th>\n",
       "      <th>VIGENCIA_FORMACION</th>\n",
       "      <th>AREA_CONSTRUIDA</th>\n",
       "      <th>CEDULA_CATASTRAL</th>\n",
       "      <th>CHIP</th>\n",
       "      <th>DESCRIPCION_DESTINO</th>\n",
       "      <th>VIGENCIA_ACTUALIZACION</th>\n",
       "      <th>TIPO_DIRECCION(S/I)</th>\n",
       "      <th>DIRECCION(S/I)</th>\n",
       "      <th>ZONA_HOMOGENEA_FISICA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1048175</th>\n",
       "      <td>5304.0</td>\n",
       "      <td>LA CASTELLANA</td>\n",
       "      <td>44.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>91020.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10/05/1994 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>P</td>\n",
       "      <td>CL 96 45A 40 ET 2 AG 2 GJ 11</td>\n",
       "      <td>D</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>10.4</td>\n",
       "      <td>96 A13 1 640</td>\n",
       "      <td>AAA0057MFXS</td>\n",
       "      <td>RESIDENCIAL</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.222115e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5228607</th>\n",
       "      <td>9128.0</td>\n",
       "      <td>EL PLAN</td>\n",
       "      <td>14.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>91021.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>08/08/2013 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>P</td>\n",
       "      <td>KR 73B 147 95 ET 2 GJ 381</td>\n",
       "      <td>D</td>\n",
       "      <td>1992.0</td>\n",
       "      <td>23.01</td>\n",
       "      <td>009128140300291021</td>\n",
       "      <td>AAA0236MWFZ</td>\n",
       "      <td>RESIDENCIAL</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.611125e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2091084</th>\n",
       "      <td>8510.0</td>\n",
       "      <td>ACACIAS USAQUEN</td>\n",
       "      <td>20.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1027.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>05/31/1991 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>P</td>\n",
       "      <td>CL 146 11 41 IN 3</td>\n",
       "      <td>D</td>\n",
       "      <td>1992.0</td>\n",
       "      <td>141.1</td>\n",
       "      <td>UQ 145 19 6</td>\n",
       "      <td>AAA0110SHZE</td>\n",
       "      <td>RESIDENCIAL</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.212315e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4102397</th>\n",
       "      <td>6212.0</td>\n",
       "      <td>SALAZAR GOMEZ</td>\n",
       "      <td>16.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3001.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>05/04/1995 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>P</td>\n",
       "      <td>KR 65B 10A 69 AP 301</td>\n",
       "      <td>D</td>\n",
       "      <td>1995.0</td>\n",
       "      <td>77</td>\n",
       "      <td>10 65B 20 3</td>\n",
       "      <td>AAA0074KOUH</td>\n",
       "      <td>RESIDENCIAL</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.232315e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2086641</th>\n",
       "      <td>8510.0</td>\n",
       "      <td>ACACIAS USAQUEN</td>\n",
       "      <td>14.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>07/11/2013 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>P</td>\n",
       "      <td>CL 146 12A 53 AP 205</td>\n",
       "      <td>D</td>\n",
       "      <td>1992.0</td>\n",
       "      <td>47.07</td>\n",
       "      <td>008510143000102005</td>\n",
       "      <td>AAA0235WNEP</td>\n",
       "      <td>RESIDENCIAL</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.212315e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2959221</th>\n",
       "      <td>2401.0</td>\n",
       "      <td>TUNAL ORIENTAL</td>\n",
       "      <td>27.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5003.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>P</td>\n",
       "      <td>KR 24C 54 40 SUR IN 2 AP 503</td>\n",
       "      <td>D</td>\n",
       "      <td>1992.0</td>\n",
       "      <td>59.4</td>\n",
       "      <td>002401270400205003</td>\n",
       "      <td>AAA0015EKUZ</td>\n",
       "      <td>RESIDENCIAL</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.212115e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1269822</th>\n",
       "      <td>5657.0</td>\n",
       "      <td>SABANA DEL DORADO</td>\n",
       "      <td>34.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 120B 63A 92</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>210.7</td>\n",
       "      <td>57 120A 7</td>\n",
       "      <td>AAA0072BDHK</td>\n",
       "      <td>RESIDENCIAL</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>S</td>\n",
       "      <td>KR 120B 63A 90</td>\n",
       "      <td>6.040215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>903383</th>\n",
       "      <td>4601.0</td>\n",
       "      <td>CALANDAIMA</td>\n",
       "      <td>44.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12/31/2002 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>N</td>\n",
       "      <td>CL 34B SUR 90A 22</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>76.8</td>\n",
       "      <td>105218441000000000</td>\n",
       "      <td>AAA0165CJKC</td>\n",
       "      <td>RESIDENCIAL</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.032115e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4848799</th>\n",
       "      <td>8510.0</td>\n",
       "      <td>ACACIAS USAQUEN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1004.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>02/21/1989 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>P</td>\n",
       "      <td>CL 144 13 58 IN 4</td>\n",
       "      <td>D</td>\n",
       "      <td>1992.0</td>\n",
       "      <td>79.1</td>\n",
       "      <td>144 25 6 4</td>\n",
       "      <td>AAA0110KKNN</td>\n",
       "      <td>RESIDENCIAL</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.212315e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4685918</th>\n",
       "      <td>8405.0</td>\n",
       "      <td>GINEBRA</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>91023.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12/01/2011 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>P</td>\n",
       "      <td>AK 7 130 50 TO 4 GS16 D</td>\n",
       "      <td>D</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>25</td>\n",
       "      <td>008405020200491023</td>\n",
       "      <td>AAA0225DHBS</td>\n",
       "      <td>RESIDENCIAL</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.612415e+12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         CODIGO_BARRIO      NOMBRE_BARRIO  CODIGO_MANZANA  CODIGO_PREDIO  \\\n",
       "1048175         5304.0      LA CASTELLANA            44.0            4.0   \n",
       "5228607         9128.0            EL PLAN            14.0            3.0   \n",
       "2091084         8510.0    ACACIAS USAQUEN            20.0            2.0   \n",
       "4102397         6212.0      SALAZAR GOMEZ            16.0           35.0   \n",
       "2086641         8510.0    ACACIAS USAQUEN            14.0           30.0   \n",
       "2959221         2401.0     TUNAL ORIENTAL            27.0            4.0   \n",
       "1269822         5657.0  SABANA DEL DORADO            34.0           25.0   \n",
       "903383          4601.0         CALANDAIMA            44.0           10.0   \n",
       "4848799         8510.0    ACACIAS USAQUEN            12.0            8.0   \n",
       "4685918         8405.0            GINEBRA             2.0            2.0   \n",
       "\n",
       "         CODIGO_CONSTRUCCION  CODIGO_RESTO  TIPO_PROPIEDAD  CODIGO_DESTINO  \\\n",
       "1048175                  2.0       91020.0             6.0             1.0   \n",
       "5228607                  2.0       91021.0             6.0             1.0   \n",
       "2091084                  1.0        1027.0             6.0             1.0   \n",
       "4102397                  1.0        3001.0             6.0             1.0   \n",
       "2086641                  1.0        2005.0             6.0             1.0   \n",
       "2959221                  2.0        5003.0             6.0             1.0   \n",
       "1269822                  0.0           0.0             6.0             1.0   \n",
       "903383                   0.0           0.0             6.0             1.0   \n",
       "4848799                  1.0        1004.0             6.0             1.0   \n",
       "4685918                  4.0       91023.0             6.0             1.0   \n",
       "\n",
       "            FECHA_INCORPORACION  AVALUO_ANO CLASE_PREDIO  \\\n",
       "1048175  10/05/1994 12:00:00 AM      2017.0            P   \n",
       "5228607  08/08/2013 12:00:00 AM      2018.0            P   \n",
       "2091084  05/31/1991 12:00:00 AM      2017.0            P   \n",
       "4102397  05/04/1995 12:00:00 AM      2018.0            P   \n",
       "2086641  07/11/2013 12:00:00 AM      2017.0            P   \n",
       "2959221  12/31/1997 12:00:00 AM      2018.0            P   \n",
       "1269822  12/31/1997 12:00:00 AM      2017.0            N   \n",
       "903383   12/31/2002 12:00:00 AM      2017.0            N   \n",
       "4848799  02/21/1989 12:00:00 AM      2018.0            P   \n",
       "4685918  12/01/2011 12:00:00 AM      2018.0            P   \n",
       "\n",
       "                       DIRECCION_REAL MARCA_DIRECCION  VIGENCIA_FORMACION  \\\n",
       "1048175  CL 96 45A 40 ET 2 AG 2 GJ 11               D              1994.0   \n",
       "5228607     KR 73B 147 95 ET 2 GJ 381               D              1992.0   \n",
       "2091084             CL 146 11 41 IN 3               D              1992.0   \n",
       "4102397          KR 65B 10A 69 AP 301               D              1995.0   \n",
       "2086641          CL 146 12A 53 AP 205               D              1992.0   \n",
       "2959221  KR 24C 54 40 SUR IN 2 AP 503               D              1992.0   \n",
       "1269822                KR 120B 63A 92               D              1998.0   \n",
       "903383              CL 34B SUR 90A 22               D              1998.0   \n",
       "4848799             CL 144 13 58 IN 4               D              1992.0   \n",
       "4685918       AK 7 130 50 TO 4 GS16 D               D              1993.0   \n",
       "\n",
       "        AREA_CONSTRUIDA    CEDULA_CATASTRAL         CHIP DESCRIPCION_DESTINO  \\\n",
       "1048175            10.4        96 A13 1 640  AAA0057MFXS         RESIDENCIAL   \n",
       "5228607           23.01  009128140300291021  AAA0236MWFZ         RESIDENCIAL   \n",
       "2091084           141.1         UQ 145 19 6  AAA0110SHZE         RESIDENCIAL   \n",
       "4102397              77         10 65B 20 3  AAA0074KOUH         RESIDENCIAL   \n",
       "2086641           47.07  008510143000102005  AAA0235WNEP         RESIDENCIAL   \n",
       "2959221            59.4  002401270400205003  AAA0015EKUZ         RESIDENCIAL   \n",
       "1269822           210.7           57 120A 7  AAA0072BDHK         RESIDENCIAL   \n",
       "903383             76.8  105218441000000000  AAA0165CJKC         RESIDENCIAL   \n",
       "4848799            79.1          144 25 6 4  AAA0110KKNN         RESIDENCIAL   \n",
       "4685918              25  008405020200491023  AAA0225DHBS         RESIDENCIAL   \n",
       "\n",
       "         VIGENCIA_ACTUALIZACION TIPO_DIRECCION(S/I)  DIRECCION(S/I)  \\\n",
       "1048175                  2017.0                 NaN             NaN   \n",
       "5228607                  2018.0                 NaN             NaN   \n",
       "2091084                  2017.0                 NaN             NaN   \n",
       "4102397                  2018.0                 NaN             NaN   \n",
       "2086641                  2017.0                 NaN             NaN   \n",
       "2959221                  2018.0                 NaN             NaN   \n",
       "1269822                  2017.0                   S  KR 120B 63A 90   \n",
       "903383                   2017.0                 NaN             NaN   \n",
       "4848799                  2018.0                 NaN             NaN   \n",
       "4685918                  2018.0                 NaN             NaN   \n",
       "\n",
       "         ZONA_HOMOGENEA_FISICA  \n",
       "1048175           6.222115e+12  \n",
       "5228607           6.611125e+12  \n",
       "2091084           6.212315e+12  \n",
       "4102397           6.232315e+12  \n",
       "2086641           6.212315e+12  \n",
       "2959221           6.212115e+12  \n",
       "1269822           6.040215e+12  \n",
       "903383            6.032115e+12  \n",
       "4848799           6.212315e+12  \n",
       "4685918           6.612415e+12  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sample(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "gu-AvHRoNrlp"
   },
   "source": [
    "### Nombres de las variables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-28T00:54:49.871293Z",
     "start_time": "2020-01-28T00:54:49.866812Z"
    },
    "colab": {},
    "colab_type": "code",
    "id": "nQVxwggxNrlr"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['CODIGO_BARRIO', 'NOMBRE_BARRIO', 'CODIGO_MANZANA', 'CODIGO_PREDIO',\n",
       "       'CODIGO_CONSTRUCCION', 'CODIGO_RESTO', 'TIPO_PROPIEDAD',\n",
       "       'CODIGO_DESTINO', 'FECHA_INCORPORACION', 'AVALUO_ANO', 'CLASE_PREDIO',\n",
       "       'DIRECCION_REAL', 'MARCA_DIRECCION', 'VIGENCIA_FORMACION',\n",
       "       'AREA_CONSTRUIDA', 'CEDULA_CATASTRAL', 'CHIP', 'DESCRIPCION_DESTINO',\n",
       "       'VIGENCIA_ACTUALIZACION', 'TIPO_DIRECCION(S/I)', 'DIRECCION(S/I)',\n",
       "       'ZONA_HOMOGENEA_FISICA'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "unnlYKKiNrlw"
   },
   "source": [
    "### Tipos de Datos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-28T00:56:13.449749Z",
     "start_time": "2020-01-28T00:56:13.437454Z"
    },
    "colab": {},
    "colab_type": "code",
    "id": "zBwm4TJdNrly"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "CODIGO_BARRIO             float64\n",
       "NOMBRE_BARRIO              object\n",
       "CODIGO_MANZANA            float64\n",
       "CODIGO_PREDIO             float64\n",
       "CODIGO_CONSTRUCCION       float64\n",
       "CODIGO_RESTO              float64\n",
       "TIPO_PROPIEDAD            float64\n",
       "CODIGO_DESTINO            float64\n",
       "FECHA_INCORPORACION        object\n",
       "AVALUO_ANO                float64\n",
       "CLASE_PREDIO               object\n",
       "DIRECCION_REAL             object\n",
       "MARCA_DIRECCION            object\n",
       "VIGENCIA_FORMACION        float64\n",
       "AREA_CONSTRUIDA            object\n",
       "CEDULA_CATASTRAL           object\n",
       "CHIP                       object\n",
       "DESCRIPCION_DESTINO        object\n",
       "VIGENCIA_ACTUALIZACION    float64\n",
       "TIPO_DIRECCION(S/I)        object\n",
       "DIRECCION(S/I)             object\n",
       "ZONA_HOMOGENEA_FISICA     float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "xi_Abid0Nrl6"
   },
   "source": [
    "### Información General"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-28T00:58:28.917945Z",
     "start_time": "2020-01-28T00:58:27.990932Z"
    },
    "colab": {},
    "colab_type": "code",
    "id": "2_KsvUT-Nrl8"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CODIGO_BARRIO</th>\n",
       "      <th>CODIGO_MANZANA</th>\n",
       "      <th>CODIGO_PREDIO</th>\n",
       "      <th>CODIGO_CONSTRUCCION</th>\n",
       "      <th>CODIGO_RESTO</th>\n",
       "      <th>TIPO_PROPIEDAD</th>\n",
       "      <th>CODIGO_DESTINO</th>\n",
       "      <th>AVALUO_ANO</th>\n",
       "      <th>VIGENCIA_FORMACION</th>\n",
       "      <th>VIGENCIA_ACTUALIZACION</th>\n",
       "      <th>ZONA_HOMOGENEA_FISICA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>5.513624e+06</td>\n",
       "      <td>5.513624e+06</td>\n",
       "      <td>5.513624e+06</td>\n",
       "      <td>5.513624e+06</td>\n",
       "      <td>5.513624e+06</td>\n",
       "      <td>5.513624e+06</td>\n",
       "      <td>5.513624e+06</td>\n",
       "      <td>5.513624e+06</td>\n",
       "      <td>5.363810e+06</td>\n",
       "      <td>5.513434e+06</td>\n",
       "      <td>5.491772e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>8.080937e+03</td>\n",
       "      <td>3.155936e+01</td>\n",
       "      <td>1.521210e+01</td>\n",
       "      <td>3.703899e+00</td>\n",
       "      <td>1.422149e+04</td>\n",
       "      <td>5.915451e+00</td>\n",
       "      <td>6.405872e+00</td>\n",
       "      <td>2.017504e+03</td>\n",
       "      <td>1.995649e+03</td>\n",
       "      <td>2.017495e+03</td>\n",
       "      <td>6.237121e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>1.909106e+04</td>\n",
       "      <td>2.552161e+01</td>\n",
       "      <td>1.659554e+01</td>\n",
       "      <td>1.711890e+01</td>\n",
       "      <td>3.100198e+04</td>\n",
       "      <td>5.806246e-01</td>\n",
       "      <td>1.371721e+01</td>\n",
       "      <td>4.999845e-01</td>\n",
       "      <td>5.917214e+00</td>\n",
       "      <td>5.236379e-01</td>\n",
       "      <td>3.955659e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.101000e+03</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.017000e+03</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.001000e+03</td>\n",
       "      <td>1.030231e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>4.503000e+03</td>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.017000e+03</td>\n",
       "      <td>1.993000e+03</td>\n",
       "      <td>2.017000e+03</td>\n",
       "      <td>6.222115e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>6.217000e+03</td>\n",
       "      <td>2.500000e+01</td>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.015000e+03</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.018000e+03</td>\n",
       "      <td>1.995000e+03</td>\n",
       "      <td>2.018000e+03</td>\n",
       "      <td>6.222215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>8.504000e+03</td>\n",
       "      <td>4.700000e+01</td>\n",
       "      <td>2.100000e+01</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>5.001000e+03</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.018000e+03</td>\n",
       "      <td>1.998000e+03</td>\n",
       "      <td>2.018000e+03</td>\n",
       "      <td>6.235225e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2.091060e+05</td>\n",
       "      <td>9.900000e+01</td>\n",
       "      <td>9.900000e+01</td>\n",
       "      <td>9.990000e+02</td>\n",
       "      <td>9.917700e+04</td>\n",
       "      <td>8.000000e+00</td>\n",
       "      <td>8.900000e+01</td>\n",
       "      <td>2.018000e+03</td>\n",
       "      <td>2.015000e+03</td>\n",
       "      <td>2.018000e+03</td>\n",
       "      <td>6.825235e+12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       CODIGO_BARRIO  CODIGO_MANZANA  CODIGO_PREDIO  CODIGO_CONSTRUCCION  \\\n",
       "count   5.513624e+06    5.513624e+06   5.513624e+06         5.513624e+06   \n",
       "mean    8.080937e+03    3.155936e+01   1.521210e+01         3.703899e+00   \n",
       "std     1.909106e+04    2.552161e+01   1.659554e+01         1.711890e+01   \n",
       "min     1.101000e+03    0.000000e+00   0.000000e+00         0.000000e+00   \n",
       "25%     4.503000e+03    1.000000e+01   3.000000e+00         0.000000e+00   \n",
       "50%     6.217000e+03    2.500000e+01   1.000000e+01         1.000000e+00   \n",
       "75%     8.504000e+03    4.700000e+01   2.100000e+01         1.000000e+00   \n",
       "max     2.091060e+05    9.900000e+01   9.900000e+01         9.990000e+02   \n",
       "\n",
       "       CODIGO_RESTO  TIPO_PROPIEDAD  CODIGO_DESTINO    AVALUO_ANO  \\\n",
       "count  5.513624e+06    5.513624e+06    5.513624e+06  5.513624e+06   \n",
       "mean   1.422149e+04    5.915451e+00    6.405872e+00  2.017504e+03   \n",
       "std    3.100198e+04    5.806246e-01    1.371721e+01  4.999845e-01   \n",
       "min    0.000000e+00    1.000000e+00    1.000000e+00  2.017000e+03   \n",
       "25%    0.000000e+00    6.000000e+00    1.000000e+00  2.017000e+03   \n",
       "50%    1.015000e+03    6.000000e+00    1.000000e+00  2.018000e+03   \n",
       "75%    5.001000e+03    6.000000e+00    1.000000e+00  2.018000e+03   \n",
       "max    9.917700e+04    8.000000e+00    8.900000e+01  2.018000e+03   \n",
       "\n",
       "       VIGENCIA_FORMACION  VIGENCIA_ACTUALIZACION  ZONA_HOMOGENEA_FISICA  \n",
       "count        5.363810e+06            5.513434e+06           5.491772e+06  \n",
       "mean         1.995649e+03            2.017495e+03           6.237121e+12  \n",
       "std          5.917214e+00            5.236379e-01           3.955659e+11  \n",
       "min          0.000000e+00            2.001000e+03           1.030231e+11  \n",
       "25%          1.993000e+03            2.017000e+03           6.222115e+12  \n",
       "50%          1.995000e+03            2.018000e+03           6.222215e+12  \n",
       "75%          1.998000e+03            2.018000e+03           6.235225e+12  \n",
       "max          2.015000e+03            2.018000e+03           6.825235e+12  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Basic Statistics\n",
    "df.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "gQ5l7W22NrmC"
   },
   "source": [
    "### Filtros por Variables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-28T01:03:55.121751Z",
     "start_time": "2020-01-28T01:03:55.069280Z"
    },
    "colab": {},
    "colab_type": "code",
    "id": "9d0gtl7TNrmD"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CHIP</th>\n",
       "      <th>NOMBRE_BARRIO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AAA0000AOSK</td>\n",
       "      <td>LAS BRISAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AAA0000AOTO</td>\n",
       "      <td>LAS BRISAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AAA0000AOUZ</td>\n",
       "      <td>LAS BRISAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AAA0000AOWF</td>\n",
       "      <td>LAS BRISAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AAA0000AOXR</td>\n",
       "      <td>LAS BRISAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5513620</th>\n",
       "      <td>AAA0251CPHK</td>\n",
       "      <td>LA UNION URBANO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5513621</th>\n",
       "      <td>AAA0157PTCN</td>\n",
       "      <td>LA UNION URBANO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5513622</th>\n",
       "      <td>AAA0229CJLW</td>\n",
       "      <td>LA UNION URBANO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5513623</th>\n",
       "      <td>AAA0157PTEP</td>\n",
       "      <td>LA UNION URBANO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5513624</th>\n",
       "      <td>AAA0250LPFZ</td>\n",
       "      <td>LA UNION URBANO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5513625 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                CHIP    NOMBRE_BARRIO\n",
       "0        AAA0000AOSK       LAS BRISAS\n",
       "1        AAA0000AOTO       LAS BRISAS\n",
       "2        AAA0000AOUZ       LAS BRISAS\n",
       "3        AAA0000AOWF       LAS BRISAS\n",
       "4        AAA0000AOXR       LAS BRISAS\n",
       "...              ...              ...\n",
       "5513620  AAA0251CPHK  LA UNION URBANO\n",
       "5513621  AAA0157PTCN  LA UNION URBANO\n",
       "5513622  AAA0229CJLW  LA UNION URBANO\n",
       "5513623  AAA0157PTEP  LA UNION URBANO\n",
       "5513624  AAA0250LPFZ  LA UNION URBANO\n",
       "\n",
       "[5513625 rows x 2 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[[\"CHIP\",\"NOMBRE_BARRIO\"]]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "c7UB4fx9NrmJ"
   },
   "source": [
    "## Conteo de barrios"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-28T01:07:29.998085Z",
     "start_time": "2020-01-28T01:07:29.783091Z"
    },
    "colab": {},
    "colab_type": "code",
    "id": "FTYjDvTyNrmM"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CODIGO_BARRIO</th>\n",
       "      <th>NOMBRE_BARRIO</th>\n",
       "      <th>CODIGO_MANZANA</th>\n",
       "      <th>CODIGO_PREDIO</th>\n",
       "      <th>CODIGO_CONSTRUCCION</th>\n",
       "      <th>CODIGO_RESTO</th>\n",
       "      <th>TIPO_PROPIEDAD</th>\n",
       "      <th>CODIGO_DESTINO</th>\n",
       "      <th>FECHA_INCORPORACION</th>\n",
       "      <th>AVALUO_ANO</th>\n",
       "      <th>CLASE_PREDIO</th>\n",
       "      <th>DIRECCION_REAL</th>\n",
       "      <th>MARCA_DIRECCION</th>\n",
       "      <th>VIGENCIA_FORMACION</th>\n",
       "      <th>AREA_CONSTRUIDA</th>\n",
       "      <th>CEDULA_CATASTRAL</th>\n",
       "      <th>CHIP</th>\n",
       "      <th>DESCRIPCION_DESTINO</th>\n",
       "      <th>VIGENCIA_ACTUALIZACION</th>\n",
       "      <th>TIPO_DIRECCION(S/I)</th>\n",
       "      <th>DIRECCION(S/I)</th>\n",
       "      <th>ZONA_HOMOGENEA_FISICA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1101.0</td>\n",
       "      <td>LAS BRISAS</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 7 1 92 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>42.03</td>\n",
       "      <td>25 6 18</td>\n",
       "      <td>AAA0000AOSK</td>\n",
       "      <td>COMERCIO PUNTUAL</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.712215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1101.0</td>\n",
       "      <td>LAS BRISAS</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 7 1 90 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>52.45</td>\n",
       "      <td>25 6 19</td>\n",
       "      <td>AAA0000AOTO</td>\n",
       "      <td>COMERCIO PUNTUAL</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.712215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1101.0</td>\n",
       "      <td>LAS BRISAS</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 7 1 86 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>10.02</td>\n",
       "      <td>2S 6 20</td>\n",
       "      <td>AAA0000AOUZ</td>\n",
       "      <td>COMERCIO PUNTUAL</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.712215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1101.0</td>\n",
       "      <td>LAS BRISAS</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 7 1 82 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>106.4</td>\n",
       "      <td>2S 6 22</td>\n",
       "      <td>AAA0000AOWF</td>\n",
       "      <td>COMERCIO PUNTUAL</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.712215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1101.0</td>\n",
       "      <td>LAS BRISAS</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 7 1 70 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>57.78</td>\n",
       "      <td>2S 6 23</td>\n",
       "      <td>AAA0000AOXR</td>\n",
       "      <td>COMERCIO PUNTUAL</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.712215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5512824</th>\n",
       "      <td>208127.0</td>\n",
       "      <td>PARAMO RURAL V</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>06/07/1995 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 16 ESTE 102B 05</td>\n",
       "      <td>D</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>81.2</td>\n",
       "      <td>108004006300000000</td>\n",
       "      <td>AAA0142LHDE</td>\n",
       "      <td>RESIDENCIAL</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.800636e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5512825</th>\n",
       "      <td>208127.0</td>\n",
       "      <td>PARAMO RURAL V</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12/31/2000 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 16 ESTE 102B 05 MJ 1</td>\n",
       "      <td>D</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>70</td>\n",
       "      <td>108104006300100000</td>\n",
       "      <td>AAA0156SPYN</td>\n",
       "      <td>RESIDENCIAL</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.800636e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5512826</th>\n",
       "      <td>208127.0</td>\n",
       "      <td>PARAMO RURAL V</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12/01/2004 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 16 ESTE 102B 05 MJ 2</td>\n",
       "      <td>D</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>146.7</td>\n",
       "      <td>008422010100200000</td>\n",
       "      <td>AAA0180TPRJ</td>\n",
       "      <td>RESIDENCIAL</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.800636e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5512827</th>\n",
       "      <td>208127.0</td>\n",
       "      <td>PARAMO RURAL V</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12/01/2004 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 16 ESTE 102B 05 MJ 3</td>\n",
       "      <td>D</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>120.1</td>\n",
       "      <td>008422010100300000</td>\n",
       "      <td>AAA0180TPSY</td>\n",
       "      <td>RESIDENCIAL</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.800636e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5512828</th>\n",
       "      <td>208127.0</td>\n",
       "      <td>PARAMO RURAL V</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>08/15/1991 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 16 ESTE 102B 05 IN 1</td>\n",
       "      <td>D</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>243.6</td>\n",
       "      <td>UQ 11238</td>\n",
       "      <td>AAA0142LFLF</td>\n",
       "      <td>RESIDENCIAL</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.800636e+12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5479 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         CODIGO_BARRIO   NOMBRE_BARRIO  CODIGO_MANZANA  CODIGO_PREDIO  \\\n",
       "0               1101.0      LAS BRISAS             1.0            1.0   \n",
       "1               1101.0      LAS BRISAS             1.0            2.0   \n",
       "2               1101.0      LAS BRISAS             1.0            3.0   \n",
       "3               1101.0      LAS BRISAS             1.0            4.0   \n",
       "4               1101.0      LAS BRISAS             1.0            5.0   \n",
       "...                ...             ...             ...            ...   \n",
       "5512824       208127.0  PARAMO RURAL V             1.0            1.0   \n",
       "5512825       208127.0  PARAMO RURAL V             1.0            1.0   \n",
       "5512826       208127.0  PARAMO RURAL V             1.0            1.0   \n",
       "5512827       208127.0  PARAMO RURAL V             1.0            1.0   \n",
       "5512828       208127.0  PARAMO RURAL V             1.0            2.0   \n",
       "\n",
       "         CODIGO_CONSTRUCCION  CODIGO_RESTO  TIPO_PROPIEDAD  CODIGO_DESTINO  \\\n",
       "0                        0.0           0.0             6.0            23.0   \n",
       "1                        0.0           0.0             6.0            23.0   \n",
       "2                        0.0           0.0             6.0            23.0   \n",
       "3                        0.0           0.0             6.0            23.0   \n",
       "4                        0.0           0.0             6.0            23.0   \n",
       "...                      ...           ...             ...             ...   \n",
       "5512824                  0.0           9.0             6.0             1.0   \n",
       "5512825                  1.0           0.0             6.0             1.0   \n",
       "5512826                  2.0           0.0             6.0             1.0   \n",
       "5512827                  3.0           0.0             6.0             1.0   \n",
       "5512828                  0.0           0.0             6.0             1.0   \n",
       "\n",
       "            FECHA_INCORPORACION  AVALUO_ANO CLASE_PREDIO  \\\n",
       "0        12/31/1997 12:00:00 AM      2017.0            N   \n",
       "1        12/31/1997 12:00:00 AM      2017.0            N   \n",
       "2        12/31/1997 12:00:00 AM      2017.0            N   \n",
       "3        12/31/1997 12:00:00 AM      2017.0            N   \n",
       "4        12/31/1997 12:00:00 AM      2017.0            N   \n",
       "...                         ...         ...          ...   \n",
       "5512824  06/07/1995 12:00:00 AM      2018.0            N   \n",
       "5512825  12/31/2000 12:00:00 AM      2018.0            N   \n",
       "5512826  12/01/2004 12:00:00 AM      2018.0            N   \n",
       "5512827  12/01/2004 12:00:00 AM      2018.0            N   \n",
       "5512828  08/15/1991 12:00:00 AM      2018.0            N   \n",
       "\n",
       "                  DIRECCION_REAL MARCA_DIRECCION  VIGENCIA_FORMACION  \\\n",
       "0                  KR 7 1 92 SUR               D              1998.0   \n",
       "1                  KR 7 1 90 SUR               D              1998.0   \n",
       "2                  KR 7 1 86 SUR               D              1998.0   \n",
       "3                  KR 7 1 82 SUR               D              1998.0   \n",
       "4                  KR 7 1 70 SUR               D              1998.0   \n",
       "...                          ...             ...                 ...   \n",
       "5512824       KR 16 ESTE 102B 05               D              1993.0   \n",
       "5512825  KR 16 ESTE 102B 05 MJ 1               D              1993.0   \n",
       "5512826  KR 16 ESTE 102B 05 MJ 2               D              1993.0   \n",
       "5512827  KR 16 ESTE 102B 05 MJ 3               D              1993.0   \n",
       "5512828  KR 16 ESTE 102B 05 IN 1               D              1993.0   \n",
       "\n",
       "        AREA_CONSTRUIDA    CEDULA_CATASTRAL         CHIP DESCRIPCION_DESTINO  \\\n",
       "0                 42.03             25 6 18  AAA0000AOSK    COMERCIO PUNTUAL   \n",
       "1                 52.45             25 6 19  AAA0000AOTO    COMERCIO PUNTUAL   \n",
       "2                 10.02             2S 6 20  AAA0000AOUZ    COMERCIO PUNTUAL   \n",
       "3                 106.4             2S 6 22  AAA0000AOWF    COMERCIO PUNTUAL   \n",
       "4                 57.78             2S 6 23  AAA0000AOXR    COMERCIO PUNTUAL   \n",
       "...                 ...                 ...          ...                 ...   \n",
       "5512824            81.2  108004006300000000  AAA0142LHDE         RESIDENCIAL   \n",
       "5512825              70  108104006300100000  AAA0156SPYN         RESIDENCIAL   \n",
       "5512826           146.7  008422010100200000  AAA0180TPRJ         RESIDENCIAL   \n",
       "5512827           120.1  008422010100300000  AAA0180TPSY         RESIDENCIAL   \n",
       "5512828           243.6            UQ 11238  AAA0142LFLF         RESIDENCIAL   \n",
       "\n",
       "         VIGENCIA_ACTUALIZACION TIPO_DIRECCION(S/I) DIRECCION(S/I)  \\\n",
       "0                        2017.0                 NaN            NaN   \n",
       "1                        2017.0                 NaN            NaN   \n",
       "2                        2017.0                 NaN            NaN   \n",
       "3                        2017.0                 NaN            NaN   \n",
       "4                        2017.0                 NaN            NaN   \n",
       "...                         ...                 ...            ...   \n",
       "5512824                  2018.0                 NaN            NaN   \n",
       "5512825                  2018.0                 NaN            NaN   \n",
       "5512826                  2018.0                 NaN            NaN   \n",
       "5512827                  2018.0                 NaN            NaN   \n",
       "5512828                  2018.0                 NaN            NaN   \n",
       "\n",
       "         ZONA_HOMOGENEA_FISICA  \n",
       "0                 6.712215e+12  \n",
       "1                 6.712215e+12  \n",
       "2                 6.712215e+12  \n",
       "3                 6.712215e+12  \n",
       "4                 6.712215e+12  \n",
       "...                        ...  \n",
       "5512824           2.800636e+12  \n",
       "5512825           2.800636e+12  \n",
       "5512826           2.800636e+12  \n",
       "5512827           2.800636e+12  \n",
       "5512828           2.800636e+12  \n",
       "\n",
       "[5479 rows x 22 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby('NOMBRE_BARRIO').head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-28T01:08:57.191094Z",
     "start_time": "2020-01-28T01:08:57.020791Z"
    },
    "colab": {},
    "colab_type": "code",
    "id": "q77FFuPgNrmS"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0          AAA0000AOSK\n",
       "1          AAA0000AOTO\n",
       "2          AAA0000AOUZ\n",
       "3          AAA0000AOWF\n",
       "4          AAA0000AOXR\n",
       "              ...     \n",
       "5512824    AAA0142LHDE\n",
       "5512825    AAA0156SPYN\n",
       "5512826    AAA0180TPRJ\n",
       "5512827    AAA0180TPSY\n",
       "5512828    AAA0142LFLF\n",
       "Name: CHIP, Length: 5479, dtype: object"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby('NOMBRE_BARRIO')[\"CHIP\"].head()\n",
    "#df[df[\"NOMBRE_BARRIO\"].str.contains('MONTES')]\n",
    "#df.loc[df['NOMBRE_BARRIO']=='NOMBRE_BARRIO']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-28T01:09:24.334075Z",
     "start_time": "2020-01-28T01:09:24.141035Z"
    },
    "colab": {},
    "colab_type": "code",
    "id": "Rxlc4SG9NrmW"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "NOMBRE_BARRIO\n",
       "ABRAHAM LINCOLN          2385\n",
       "ACACIAS USAQUEN         27720\n",
       "ACEVEDO TEJADA           2532\n",
       "AEROPUERTO EL DORADO      594\n",
       "AGUAS CLARAS             1473\n",
       "                        ...  \n",
       "VITELMA                  3947\n",
       "VOTO NACIONAL            6299\n",
       "YOMASA                   2363\n",
       "YOMASA NORTE               16\n",
       "ZONA FRANCA              4525\n",
       "Name: CHIP, Length: 1120, dtype: int64"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bar=df.groupby('NOMBRE_BARRIO')[\"CHIP\"].count()\n",
    "bar"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-28T01:09:24.334075Z",
     "start_time": "2020-01-28T01:09:24.141035Z"
    },
    "colab": {},
    "colab_type": "code",
    "id": "Rxlc4SG9NrmW"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CANTIDAD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NOMBRE_BARRIO</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ABRAHAM LINCOLN</th>\n",
       "      <td>2385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ACACIAS USAQUEN</th>\n",
       "      <td>27720</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ACEVEDO TEJADA</th>\n",
       "      <td>2532</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEROPUERTO EL DORADO</th>\n",
       "      <td>594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AGUAS CLARAS</th>\n",
       "      <td>1473</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VITELMA</th>\n",
       "      <td>3947</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VOTO NACIONAL</th>\n",
       "      <td>6299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>YOMASA</th>\n",
       "      <td>2363</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>YOMASA NORTE</th>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZONA FRANCA</th>\n",
       "      <td>4525</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1120 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      CANTIDAD\n",
       "NOMBRE_BARRIO                 \n",
       "ABRAHAM LINCOLN           2385\n",
       "ACACIAS USAQUEN          27720\n",
       "ACEVEDO TEJADA            2532\n",
       "AEROPUERTO EL DORADO       594\n",
       "AGUAS CLARAS              1473\n",
       "...                        ...\n",
       "VITELMA                   3947\n",
       "VOTO NACIONAL             6299\n",
       "YOMASA                    2363\n",
       "YOMASA NORTE                16\n",
       "ZONA FRANCA               4525\n",
       "\n",
       "[1120 rows x 1 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Extract Info to DataFrames\n",
    "bar=pd.DataFrame(bar)\n",
    "bar.columns=['CANTIDAD']\n",
    "\n",
    "#Reset index if necesary\n",
    "#bar.reset_index(level=0, inplace=True)\n",
    "#Delete Trashy Values\n",
    "#bar=bar.drop(['NOMBRE_BARRIO'])\n",
    "\n",
    "bar.to_csv('prediosporbarrio.csv')\n",
    "bar"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "V7mjrvcJNrnY"
   },
   "source": [
    "## Barrios Grandes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-28T01:18:11.385302Z",
     "start_time": "2020-01-28T01:18:11.381582Z"
    },
    "colab": {},
    "colab_type": "code",
    "id": "CiBcI7zCNrnd"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CANTIDAD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NOMBRE_BARRIO</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ACACIAS USAQUEN</th>\n",
       "      <td>27720</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ALTOS DE CHOZICA</th>\n",
       "      <td>10270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ANTIGUO COUNTRY</th>\n",
       "      <td>13263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ATENAS</th>\n",
       "      <td>11020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BATAN</th>\n",
       "      <td>24764</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VERACRUZ</th>\n",
       "      <td>18842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VICTORIA NORTE</th>\n",
       "      <td>17952</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VILLA ALSACIA</th>\n",
       "      <td>18470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VILLA ELISA</th>\n",
       "      <td>13544</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VILLAS DE ALCALA</th>\n",
       "      <td>13280</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>148 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  CANTIDAD\n",
       "NOMBRE_BARRIO             \n",
       "ACACIAS USAQUEN      27720\n",
       "ALTOS DE CHOZICA     10270\n",
       "ANTIGUO COUNTRY      13263\n",
       "ATENAS               11020\n",
       "BATAN                24764\n",
       "...                    ...\n",
       "VERACRUZ             18842\n",
       "VICTORIA NORTE       17952\n",
       "VILLA ALSACIA        18470\n",
       "VILLA ELISA          13544\n",
       "VILLAS DE ALCALA     13280\n",
       "\n",
       "[148 rows x 1 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "BarriosGrandes = bar[bar['CANTIDAD']>10000]\n",
    "BarriosGrandes"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "Gz1xPLdRNrnk"
   },
   "source": [
    "De esto, podemos obtener los 10 muy grandes en tamaño:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-28T01:18:14.185677Z",
     "start_time": "2020-01-28T01:18:14.176831Z"
    },
    "colab": {},
    "colab_type": "code",
    "id": "g8xjx6EeNrnl"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CANTIDAD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NOMBRE_BARRIO</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>TINTALA</th>\n",
       "      <td>54563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SANTA BARBARA CENTRAL</th>\n",
       "      <td>40902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LOS CEDROS</th>\n",
       "      <td>38764</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SANTA BARBARA OCCIDENTAL</th>\n",
       "      <td>38561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CAOBOS SALAZAR</th>\n",
       "      <td>38540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ALTOS DE CHOZICA</th>\n",
       "      <td>10270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EL CARMEN FONTIBON</th>\n",
       "      <td>10207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LA PEPITA</th>\n",
       "      <td>10202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ESTRELLA DEL NORTE</th>\n",
       "      <td>10066</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LOS LAURELES</th>\n",
       "      <td>10017</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>148 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                          CANTIDAD\n",
       "NOMBRE_BARRIO                     \n",
       "TINTALA                      54563\n",
       "SANTA BARBARA CENTRAL        40902\n",
       "LOS CEDROS                   38764\n",
       "SANTA BARBARA OCCIDENTAL     38561\n",
       "CAOBOS SALAZAR               38540\n",
       "...                            ...\n",
       "ALTOS DE CHOZICA             10270\n",
       "EL CARMEN FONTIBON           10207\n",
       "LA PEPITA                    10202\n",
       "ESTRELLA DEL NORTE           10066\n",
       "LOS LAURELES                 10017\n",
       "\n",
       "[148 rows x 1 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "BarriosGrandes.sort_values(by=['CANTIDAD'],ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-28T01:20:57.477084Z",
     "start_time": "2020-01-28T01:20:57.471257Z"
    },
    "colab": {},
    "colab_type": "code",
    "id": "kqPjETibNrnp"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Barrios Grandes:  148\n"
     ]
    }
   ],
   "source": [
    "print(\"Barrios Grandes: \", len(BarriosGrandes))\n",
    "BarriosGrandes.to_csv('barrios_grandes.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Gané...¿No?** \n",
    "\n",
    "¡Claro... QUE NO!"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Errores Típicos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>count</th>\n",
       "      <th>unique</th>\n",
       "      <th>top</th>\n",
       "      <th>freq</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NOMBRE_BARRIO</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ABRAHAM LINCOLN</th>\n",
       "      <td>2385</td>\n",
       "      <td>885</td>\n",
       "      <td>AAA0021TTOM</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ACACIAS USAQUEN</th>\n",
       "      <td>27720</td>\n",
       "      <td>14038</td>\n",
       "      <td>AAA0110RKOM</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ACEVEDO TEJADA</th>\n",
       "      <td>2532</td>\n",
       "      <td>1150</td>\n",
       "      <td>AAA0055DORJ</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEROPUERTO EL DORADO</th>\n",
       "      <td>594</td>\n",
       "      <td>222</td>\n",
       "      <td>AAA0065UHEA</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AGUAS CLARAS</th>\n",
       "      <td>1473</td>\n",
       "      <td>1180</td>\n",
       "      <td>AAA0142UFUZ</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VITELMA</th>\n",
       "      <td>3947</td>\n",
       "      <td>1839</td>\n",
       "      <td>AAA0000HTPP</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VOTO NACIONAL</th>\n",
       "      <td>6299</td>\n",
       "      <td>2486</td>\n",
       "      <td>AAA0160CFRU</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>YOMASA</th>\n",
       "      <td>2363</td>\n",
       "      <td>1070</td>\n",
       "      <td>AAA0145AEWF</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>YOMASA NORTE</th>\n",
       "      <td>16</td>\n",
       "      <td>8</td>\n",
       "      <td>AAA0180MYJZ</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZONA FRANCA</th>\n",
       "      <td>4525</td>\n",
       "      <td>2266</td>\n",
       "      <td>AAA0164YYRJ</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1120 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      count unique          top freq\n",
       "NOMBRE_BARRIO                                       \n",
       "ABRAHAM LINCOLN        2385    885  AAA0021TTOM   14\n",
       "ACACIAS USAQUEN       27720  14038  AAA0110RKOM   16\n",
       "ACEVEDO TEJADA         2532   1150  AAA0055DORJ   20\n",
       "AEROPUERTO EL DORADO    594    222  AAA0065UHEA  100\n",
       "AGUAS CLARAS           1473   1180  AAA0142UFUZ    3\n",
       "...                     ...    ...          ...  ...\n",
       "VITELMA                3947   1839  AAA0000HTPP   10\n",
       "VOTO NACIONAL          6299   2486  AAA0160CFRU   36\n",
       "YOMASA                 2363   1070  AAA0145AEWF    8\n",
       "YOMASA NORTE             16      8  AAA0180MYJZ    2\n",
       "ZONA FRANCA            4525   2266  AAA0164YYRJ    2\n",
       "\n",
       "[1120 rows x 4 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby('NOMBRE_BARRIO')[\"CHIP\"].describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Mal conteo de barrios...Sorry Bro!**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CANTIDAD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NOMBRE_BARRIO</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ABRAHAM LINCOLN</th>\n",
       "      <td>885</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ACACIAS USAQUEN</th>\n",
       "      <td>14038</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ACEVEDO TEJADA</th>\n",
       "      <td>1150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEROPUERTO EL DORADO</th>\n",
       "      <td>222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AGUAS CLARAS</th>\n",
       "      <td>1180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VITELMA</th>\n",
       "      <td>1839</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VOTO NACIONAL</th>\n",
       "      <td>2486</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>YOMASA</th>\n",
       "      <td>1070</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>YOMASA NORTE</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZONA FRANCA</th>\n",
       "      <td>2266</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1120 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      CANTIDAD\n",
       "NOMBRE_BARRIO                 \n",
       "ABRAHAM LINCOLN            885\n",
       "ACACIAS USAQUEN          14038\n",
       "ACEVEDO TEJADA            1150\n",
       "AEROPUERTO EL DORADO       222\n",
       "AGUAS CLARAS              1180\n",
       "...                        ...\n",
       "VITELMA                   1839\n",
       "VOTO NACIONAL             2486\n",
       "YOMASA                    1070\n",
       "YOMASA NORTE                 8\n",
       "ZONA FRANCA               2266\n",
       "\n",
       "[1120 rows x 1 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bar=df.groupby('NOMBRE_BARRIO')[\"CHIP\"].nunique()\n",
    "\n",
    "# Extract Info to DataFrames\n",
    "bar=pd.DataFrame(bar)\n",
    "bar.columns=['CANTIDAD']\n",
    "\n",
    "#Delete Trashy Values\n",
    "#bar=bar.drop(['NOMBRE_BARRIO'])\n",
    "\n",
    "bar.to_csv('prediosporbarrio.csv')\n",
    "bar"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CANTIDAD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NOMBRE_BARRIO</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>TINTALA</th>\n",
       "      <td>27462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SANTA BARBARA CENTRAL</th>\n",
       "      <td>20466</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LOS CEDROS</th>\n",
       "      <td>19930</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SANTA BARBARA OCCIDENTAL</th>\n",
       "      <td>19277</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CAOBOS SALAZAR</th>\n",
       "      <td>19258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LAS MARGARITAS</th>\n",
       "      <td>18275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MAZUREN</th>\n",
       "      <td>18058</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EL PLAN</th>\n",
       "      <td>17472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHICO NORTE</th>\n",
       "      <td>16922</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BRITALIA</th>\n",
       "      <td>16535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EL TINTAL CENTRAL</th>\n",
       "      <td>16095</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CIUDAD TECHO II</th>\n",
       "      <td>15858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CEDRITOS</th>\n",
       "      <td>15696</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CIUDAD HAYUELOS</th>\n",
       "      <td>15505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CANTAGALLO</th>\n",
       "      <td>14519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CIUDAD SALITRE SUR-ORIENTAL</th>\n",
       "      <td>14457</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TIBABUYES</th>\n",
       "      <td>14426</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LA CALLEJA</th>\n",
       "      <td>14180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ACACIAS USAQUEN</th>\n",
       "      <td>14038</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MIRANDELA</th>\n",
       "      <td>13747</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SANTA ROSA</th>\n",
       "      <td>13437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAN PATRICIO</th>\n",
       "      <td>13112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GALAN</th>\n",
       "      <td>12886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MONACO</th>\n",
       "      <td>12881</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PORTALES DEL NORTE</th>\n",
       "      <td>12705</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EL CHICO</th>\n",
       "      <td>12600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SANTA BIBIANA</th>\n",
       "      <td>12563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BATAN</th>\n",
       "      <td>12301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FERROCAJA FONTIBON</th>\n",
       "      <td>12256</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LA ESPERANZA NORTE</th>\n",
       "      <td>12070</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EL CORTIJO</th>\n",
       "      <td>12032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHICO NORTE II SECTOR</th>\n",
       "      <td>11704</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAN JOSE DEL PRADO</th>\n",
       "      <td>11334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HIPOTECHO OCCIDENTAL</th>\n",
       "      <td>11119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHICO NORTE III SECTOR</th>\n",
       "      <td>10988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SALITRE OCCIDENTAL</th>\n",
       "      <td>10919</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NUEVO TECHO</th>\n",
       "      <td>10885</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EL ENSUENO</th>\n",
       "      <td>10803</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MOLINOS NORTE</th>\n",
       "      <td>10697</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAN ANTONIO NOROCCIDENTAL</th>\n",
       "      <td>10597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GILMAR</th>\n",
       "      <td>10568</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LISBOA</th>\n",
       "      <td>10500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OSORIO III</th>\n",
       "      <td>10404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IBERIA</th>\n",
       "      <td>10267</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                             CANTIDAD\n",
       "NOMBRE_BARRIO                        \n",
       "TINTALA                         27462\n",
       "SANTA BARBARA CENTRAL           20466\n",
       "LOS CEDROS                      19930\n",
       "SANTA BARBARA OCCIDENTAL        19277\n",
       "CAOBOS SALAZAR                  19258\n",
       "LAS MARGARITAS                  18275\n",
       "MAZUREN                         18058\n",
       "EL PLAN                         17472\n",
       "CHICO NORTE                     16922\n",
       "BRITALIA                        16535\n",
       "EL TINTAL CENTRAL               16095\n",
       "CIUDAD TECHO II                 15858\n",
       "CEDRITOS                        15696\n",
       "CIUDAD HAYUELOS                 15505\n",
       "CANTAGALLO                      14519\n",
       "CIUDAD SALITRE SUR-ORIENTAL     14457\n",
       "TIBABUYES                       14426\n",
       "LA CALLEJA                      14180\n",
       "ACACIAS USAQUEN                 14038\n",
       "MIRANDELA                       13747\n",
       "SANTA ROSA                      13437\n",
       "SAN PATRICIO                    13112\n",
       "GALAN                           12886\n",
       "MONACO                          12881\n",
       "PORTALES DEL NORTE              12705\n",
       "EL CHICO                        12600\n",
       "SANTA BIBIANA                   12563\n",
       "BATAN                           12301\n",
       "FERROCAJA FONTIBON              12256\n",
       "LA ESPERANZA NORTE              12070\n",
       "EL CORTIJO                      12032\n",
       "CHICO NORTE II SECTOR           11704\n",
       "SAN JOSE DEL PRADO              11334\n",
       "HIPOTECHO OCCIDENTAL            11119\n",
       "CHICO NORTE III SECTOR          10988\n",
       "SALITRE OCCIDENTAL              10919\n",
       "NUEVO TECHO                     10885\n",
       "EL ENSUENO                      10803\n",
       "MOLINOS NORTE                   10697\n",
       "SAN ANTONIO NOROCCIDENTAL       10597\n",
       "GILMAR                          10568\n",
       "LISBOA                          10500\n",
       "OSORIO III                      10404\n",
       "IBERIA                          10267"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "BarriosGrandes = bar[bar['CANTIDAD']>10000]\n",
    "BarriosGrandes = BarriosGrandes.sort_values(by=['CANTIDAD'],ascending=False)\n",
    "BarriosGrandes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Barrios Grandes:  44\n"
     ]
    }
   ],
   "source": [
    "print(\"Barrios Grandes: \", len(BarriosGrandes))\n",
    "BarriosGrandes.to_csv('barrios_grandes.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Analizando Duplicados "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CODIGO_BARRIO</th>\n",
       "      <th>NOMBRE_BARRIO</th>\n",
       "      <th>CODIGO_MANZANA</th>\n",
       "      <th>CODIGO_PREDIO</th>\n",
       "      <th>CODIGO_CONSTRUCCION</th>\n",
       "      <th>CODIGO_RESTO</th>\n",
       "      <th>TIPO_PROPIEDAD</th>\n",
       "      <th>CODIGO_DESTINO</th>\n",
       "      <th>FECHA_INCORPORACION</th>\n",
       "      <th>AVALUO_ANO</th>\n",
       "      <th>CLASE_PREDIO</th>\n",
       "      <th>DIRECCION_REAL</th>\n",
       "      <th>MARCA_DIRECCION</th>\n",
       "      <th>VIGENCIA_FORMACION</th>\n",
       "      <th>AREA_CONSTRUIDA</th>\n",
       "      <th>CEDULA_CATASTRAL</th>\n",
       "      <th>CHIP</th>\n",
       "      <th>DESCRIPCION_DESTINO</th>\n",
       "      <th>VIGENCIA_ACTUALIZACION</th>\n",
       "      <th>TIPO_DIRECCION(S/I)</th>\n",
       "      <th>DIRECCION(S/I)</th>\n",
       "      <th>ZONA_HOMOGENEA_FISICA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>341445</th>\n",
       "      <td>2507.0</td>\n",
       "      <td>ABRAHAM LINCOLN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 9A 51 10 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>150.6</td>\n",
       "      <td>US 52S 9 14</td>\n",
       "      <td>AAA0021TTOM</td>\n",
       "      <td>COMERCIO EN CORREDOR COM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>S</td>\n",
       "      <td>KR 9A 51 04 SUR</td>\n",
       "      <td>6.232215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341446</th>\n",
       "      <td>2507.0</td>\n",
       "      <td>ABRAHAM LINCOLN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 9A 51 10 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>150.6</td>\n",
       "      <td>US 52S 9 14</td>\n",
       "      <td>AAA0021TTOM</td>\n",
       "      <td>COMERCIO EN CORREDOR COM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>I</td>\n",
       "      <td>CL 51 SUR 9 15</td>\n",
       "      <td>6.232215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341447</th>\n",
       "      <td>2507.0</td>\n",
       "      <td>ABRAHAM LINCOLN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 9A 51 10 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>150.6</td>\n",
       "      <td>US 52S 9 14</td>\n",
       "      <td>AAA0021TTOM</td>\n",
       "      <td>COMERCIO EN CORREDOR COM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>I</td>\n",
       "      <td>CL 51 SUR 9 27</td>\n",
       "      <td>6.232215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341448</th>\n",
       "      <td>2507.0</td>\n",
       "      <td>ABRAHAM LINCOLN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 9A 51 10 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>150.6</td>\n",
       "      <td>US 52S 9 14</td>\n",
       "      <td>AAA0021TTOM</td>\n",
       "      <td>COMERCIO EN CORREDOR COM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>I</td>\n",
       "      <td>CL 51 SUR 9 25</td>\n",
       "      <td>6.232215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341449</th>\n",
       "      <td>2507.0</td>\n",
       "      <td>ABRAHAM LINCOLN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 9A 51 10 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>150.6</td>\n",
       "      <td>US 52S 9 14</td>\n",
       "      <td>AAA0021TTOM</td>\n",
       "      <td>COMERCIO EN CORREDOR COM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>I</td>\n",
       "      <td>CL 51 SUR 9 23</td>\n",
       "      <td>6.232215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341450</th>\n",
       "      <td>2507.0</td>\n",
       "      <td>ABRAHAM LINCOLN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 9A 51 10 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>150.6</td>\n",
       "      <td>US 52S 9 14</td>\n",
       "      <td>AAA0021TTOM</td>\n",
       "      <td>COMERCIO EN CORREDOR COM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>I</td>\n",
       "      <td>CL 51 SUR 9 21</td>\n",
       "      <td>6.232215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341451</th>\n",
       "      <td>2507.0</td>\n",
       "      <td>ABRAHAM LINCOLN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 9A 51 10 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>150.6</td>\n",
       "      <td>US 52S 9 14</td>\n",
       "      <td>AAA0021TTOM</td>\n",
       "      <td>COMERCIO EN CORREDOR COM</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>I</td>\n",
       "      <td>CL 51 SUR 9 19</td>\n",
       "      <td>6.232215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3082292</th>\n",
       "      <td>2507.0</td>\n",
       "      <td>ABRAHAM LINCOLN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 9A 51 10 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>151.1</td>\n",
       "      <td>US 52S 9 14</td>\n",
       "      <td>AAA0021TTOM</td>\n",
       "      <td>COMERCIO EN CORREDOR COM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>I</td>\n",
       "      <td>CL 51 SUR 9 15</td>\n",
       "      <td>6.232215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3082293</th>\n",
       "      <td>2507.0</td>\n",
       "      <td>ABRAHAM LINCOLN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 9A 51 10 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>151.1</td>\n",
       "      <td>US 52S 9 14</td>\n",
       "      <td>AAA0021TTOM</td>\n",
       "      <td>COMERCIO EN CORREDOR COM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>I</td>\n",
       "      <td>CL 51 SUR 9 19</td>\n",
       "      <td>6.232215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3082294</th>\n",
       "      <td>2507.0</td>\n",
       "      <td>ABRAHAM LINCOLN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 9A 51 10 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>151.1</td>\n",
       "      <td>US 52S 9 14</td>\n",
       "      <td>AAA0021TTOM</td>\n",
       "      <td>COMERCIO EN CORREDOR COM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>I</td>\n",
       "      <td>CL 51 SUR 9 21</td>\n",
       "      <td>6.232215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3082295</th>\n",
       "      <td>2507.0</td>\n",
       "      <td>ABRAHAM LINCOLN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 9A 51 10 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>151.1</td>\n",
       "      <td>US 52S 9 14</td>\n",
       "      <td>AAA0021TTOM</td>\n",
       "      <td>COMERCIO EN CORREDOR COM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>I</td>\n",
       "      <td>CL 51 SUR 9 27</td>\n",
       "      <td>6.232215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3082296</th>\n",
       "      <td>2507.0</td>\n",
       "      <td>ABRAHAM LINCOLN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 9A 51 10 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>151.1</td>\n",
       "      <td>US 52S 9 14</td>\n",
       "      <td>AAA0021TTOM</td>\n",
       "      <td>COMERCIO EN CORREDOR COM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>I</td>\n",
       "      <td>CL 51 SUR 9 25</td>\n",
       "      <td>6.232215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3082297</th>\n",
       "      <td>2507.0</td>\n",
       "      <td>ABRAHAM LINCOLN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 9A 51 10 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>151.1</td>\n",
       "      <td>US 52S 9 14</td>\n",
       "      <td>AAA0021TTOM</td>\n",
       "      <td>COMERCIO EN CORREDOR COM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>I</td>\n",
       "      <td>CL 51 SUR 9 23</td>\n",
       "      <td>6.232215e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3082298</th>\n",
       "      <td>2507.0</td>\n",
       "      <td>ABRAHAM LINCOLN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>12/31/1997 12:00:00 AM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>N</td>\n",
       "      <td>KR 9A 51 10 SUR</td>\n",
       "      <td>D</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>151.1</td>\n",
       "      <td>US 52S 9 14</td>\n",
       "      <td>AAA0021TTOM</td>\n",
       "      <td>COMERCIO EN CORREDOR COM</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>S</td>\n",
       "      <td>KR 9A 51 04 SUR</td>\n",
       "      <td>6.232215e+12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         CODIGO_BARRIO    NOMBRE_BARRIO  CODIGO_MANZANA  CODIGO_PREDIO  \\\n",
       "341445          2507.0  ABRAHAM LINCOLN            43.0           10.0   \n",
       "341446          2507.0  ABRAHAM LINCOLN            43.0           10.0   \n",
       "341447          2507.0  ABRAHAM LINCOLN            43.0           10.0   \n",
       "341448          2507.0  ABRAHAM LINCOLN            43.0           10.0   \n",
       "341449          2507.0  ABRAHAM LINCOLN            43.0           10.0   \n",
       "341450          2507.0  ABRAHAM LINCOLN            43.0           10.0   \n",
       "341451          2507.0  ABRAHAM LINCOLN            43.0           10.0   \n",
       "3082292         2507.0  ABRAHAM LINCOLN            43.0           10.0   \n",
       "3082293         2507.0  ABRAHAM LINCOLN            43.0           10.0   \n",
       "3082294         2507.0  ABRAHAM LINCOLN            43.0           10.0   \n",
       "3082295         2507.0  ABRAHAM LINCOLN            43.0           10.0   \n",
       "3082296         2507.0  ABRAHAM LINCOLN            43.0           10.0   \n",
       "3082297         2507.0  ABRAHAM LINCOLN            43.0           10.0   \n",
       "3082298         2507.0  ABRAHAM LINCOLN            43.0           10.0   \n",
       "\n",
       "         CODIGO_CONSTRUCCION  CODIGO_RESTO  TIPO_PROPIEDAD  CODIGO_DESTINO  \\\n",
       "341445                   0.0           0.0             6.0            21.0   \n",
       "341446                   0.0           0.0             6.0            21.0   \n",
       "341447                   0.0           0.0             6.0            21.0   \n",
       "341448                   0.0           0.0             6.0            21.0   \n",
       "341449                   0.0           0.0             6.0            21.0   \n",
       "341450                   0.0           0.0             6.0            21.0   \n",
       "341451                   0.0           0.0             6.0            21.0   \n",
       "3082292                  0.0           0.0             6.0            21.0   \n",
       "3082293                  0.0           0.0             6.0            21.0   \n",
       "3082294                  0.0           0.0             6.0            21.0   \n",
       "3082295                  0.0           0.0             6.0            21.0   \n",
       "3082296                  0.0           0.0             6.0            21.0   \n",
       "3082297                  0.0           0.0             6.0            21.0   \n",
       "3082298                  0.0           0.0             6.0            21.0   \n",
       "\n",
       "            FECHA_INCORPORACION  AVALUO_ANO CLASE_PREDIO   DIRECCION_REAL  \\\n",
       "341445   12/31/1997 12:00:00 AM      2017.0            N  KR 9A 51 10 SUR   \n",
       "341446   12/31/1997 12:00:00 AM      2017.0            N  KR 9A 51 10 SUR   \n",
       "341447   12/31/1997 12:00:00 AM      2017.0            N  KR 9A 51 10 SUR   \n",
       "341448   12/31/1997 12:00:00 AM      2017.0            N  KR 9A 51 10 SUR   \n",
       "341449   12/31/1997 12:00:00 AM      2017.0            N  KR 9A 51 10 SUR   \n",
       "341450   12/31/1997 12:00:00 AM      2017.0            N  KR 9A 51 10 SUR   \n",
       "341451   12/31/1997 12:00:00 AM      2017.0            N  KR 9A 51 10 SUR   \n",
       "3082292  12/31/1997 12:00:00 AM      2018.0            N  KR 9A 51 10 SUR   \n",
       "3082293  12/31/1997 12:00:00 AM      2018.0            N  KR 9A 51 10 SUR   \n",
       "3082294  12/31/1997 12:00:00 AM      2018.0            N  KR 9A 51 10 SUR   \n",
       "3082295  12/31/1997 12:00:00 AM      2018.0            N  KR 9A 51 10 SUR   \n",
       "3082296  12/31/1997 12:00:00 AM      2018.0            N  KR 9A 51 10 SUR   \n",
       "3082297  12/31/1997 12:00:00 AM      2018.0            N  KR 9A 51 10 SUR   \n",
       "3082298  12/31/1997 12:00:00 AM      2018.0            N  KR 9A 51 10 SUR   \n",
       "\n",
       "        MARCA_DIRECCION  VIGENCIA_FORMACION AREA_CONSTRUIDA CEDULA_CATASTRAL  \\\n",
       "341445                D              1998.0           150.6      US 52S 9 14   \n",
       "341446                D              1998.0           150.6      US 52S 9 14   \n",
       "341447                D              1998.0           150.6      US 52S 9 14   \n",
       "341448                D              1998.0           150.6      US 52S 9 14   \n",
       "341449                D              1998.0           150.6      US 52S 9 14   \n",
       "341450                D              1998.0           150.6      US 52S 9 14   \n",
       "341451                D              1998.0           150.6      US 52S 9 14   \n",
       "3082292               D              1998.0           151.1      US 52S 9 14   \n",
       "3082293               D              1998.0           151.1      US 52S 9 14   \n",
       "3082294               D              1998.0           151.1      US 52S 9 14   \n",
       "3082295               D              1998.0           151.1      US 52S 9 14   \n",
       "3082296               D              1998.0           151.1      US 52S 9 14   \n",
       "3082297               D              1998.0           151.1      US 52S 9 14   \n",
       "3082298               D              1998.0           151.1      US 52S 9 14   \n",
       "\n",
       "                CHIP       DESCRIPCION_DESTINO  VIGENCIA_ACTUALIZACION  \\\n",
       "341445   AAA0021TTOM  COMERCIO EN CORREDOR COM                  2017.0   \n",
       "341446   AAA0021TTOM  COMERCIO EN CORREDOR COM                  2017.0   \n",
       "341447   AAA0021TTOM  COMERCIO EN CORREDOR COM                  2017.0   \n",
       "341448   AAA0021TTOM  COMERCIO EN CORREDOR COM                  2017.0   \n",
       "341449   AAA0021TTOM  COMERCIO EN CORREDOR COM                  2017.0   \n",
       "341450   AAA0021TTOM  COMERCIO EN CORREDOR COM                  2017.0   \n",
       "341451   AAA0021TTOM  COMERCIO EN CORREDOR COM                  2017.0   \n",
       "3082292  AAA0021TTOM  COMERCIO EN CORREDOR COM                  2018.0   \n",
       "3082293  AAA0021TTOM  COMERCIO EN CORREDOR COM                  2018.0   \n",
       "3082294  AAA0021TTOM  COMERCIO EN CORREDOR COM                  2018.0   \n",
       "3082295  AAA0021TTOM  COMERCIO EN CORREDOR COM                  2018.0   \n",
       "3082296  AAA0021TTOM  COMERCIO EN CORREDOR COM                  2018.0   \n",
       "3082297  AAA0021TTOM  COMERCIO EN CORREDOR COM                  2018.0   \n",
       "3082298  AAA0021TTOM  COMERCIO EN CORREDOR COM                  2018.0   \n",
       "\n",
       "        TIPO_DIRECCION(S/I)   DIRECCION(S/I)  ZONA_HOMOGENEA_FISICA  \n",
       "341445                    S  KR 9A 51 04 SUR           6.232215e+12  \n",
       "341446                    I   CL 51 SUR 9 15           6.232215e+12  \n",
       "341447                    I   CL 51 SUR 9 27           6.232215e+12  \n",
       "341448                    I   CL 51 SUR 9 25           6.232215e+12  \n",
       "341449                    I   CL 51 SUR 9 23           6.232215e+12  \n",
       "341450                    I   CL 51 SUR 9 21           6.232215e+12  \n",
       "341451                    I   CL 51 SUR 9 19           6.232215e+12  \n",
       "3082292                   I   CL 51 SUR 9 15           6.232215e+12  \n",
       "3082293                   I   CL 51 SUR 9 19           6.232215e+12  \n",
       "3082294                   I   CL 51 SUR 9 21           6.232215e+12  \n",
       "3082295                   I   CL 51 SUR 9 27           6.232215e+12  \n",
       "3082296                   I   CL 51 SUR 9 25           6.232215e+12  \n",
       "3082297                   I   CL 51 SUR 9 23           6.232215e+12  \n",
       "3082298                   S  KR 9A 51 04 SUR           6.232215e+12  "
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[df['CHIP']=='AAA0021TTOM']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#  Generador de Reportes"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Para Resumir... Se hizo lo siguiente:"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "1. **Leer Base de Datos**\n",
    "\n",
    "```df = pd.read_csv('Predios_2018.csv',sep=',',low_memory=False)```\n",
    "\n",
    "2. **Agrupar, Filtrar y contar INTELIGENTEMENTE**\n",
    "\n",
    "```bar=df.groupby('NOMBRE_BARRIO')[\"CHIP\"].nunique()```\n",
    "\n",
    "3. **Crear DataFrame con Resultados**\n",
    "\n",
    "```bar=pd.DataFrame(bar)```\n",
    "\n",
    "4. **Cambie Nombre si es Necesario**\n",
    "\n",
    "```bar.columns=['CANTIDAD']```\n",
    "\n",
    "5. **Filtro Final de lo pedido por su jefecito**\n",
    "\n",
    "```BarriosGrandes = bar[bar['CANTIDAD']>10000]```\n",
    "\n",
    "6. **Guarde Resultado Final**\n",
    "\n",
    "```BarriosGrandes.to_csv(\"barrios_grandes.csv\")```\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Módulo Reporte "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-01-28T00:53:45.353658Z",
     "start_time": "2020-01-28T00:53:35.080284Z"
    },
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 382
    },
    "colab_type": "code",
    "executionInfo": {
     "elapsed": 2697,
     "status": "error",
     "timestamp": 1580333630804,
     "user": {
      "displayName": "daniel mauricio montenegro reyes",
      "photoUrl": "",
      "userId": "12701434767844263388"
     },
     "user_tz": 300
    },
    "id": "gfHit0mLNrk0",
    "outputId": "e03065ea-c02d-468d-9fe8-7b13643c8921"
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "def Machaquebase(df,nombre_guardo,agrupa,filtra,grandeza):\n",
    "    \n",
    "    bar=df.groupby(agrupa)[filtra].nunique()\n",
    "    bar=pd.DataFrame(bar)\n",
    "    bar.columns=['CANTIDAD']\n",
    "    BarriosGrandes = bar[bar['CANTIDAD']>grandeza]\n",
    "    BarriosGrandes.to_csv(nombre_guardo)\n",
    "    return BarriosGrandes"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Ejemplo de Aplicación "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "#ruta_base='Predios_2018.csv'\n",
    "#df = pd.read_csv(ruta_base,sep=',',low_memory=False)\n",
    "grandeza=[100,1000,5000,10000]\n",
    "agrupa='NOMBRE_BARRIO'\n",
    "filtra=\"CHIP\"\n",
    "\n",
    "for reporte in grandeza:\n",
    "    Felicidad= Machaquebase(df,'Mi_reporte_Barrios_'+str(reporte)+'.csv',agrupa,filtra,reporte)"
   ]
  }
 ],
 "metadata": {
  "colab": {
   "name": "Intro_Pandas.ipynb",
   "provenance": []
  },
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.7"
  },
  "latex_envs": {
   "LaTeX_envs_menu_present": true,
   "autoclose": true,
   "autocomplete": true,
   "bibliofile": "biblio.bib",
   "cite_by": "apalike",
   "current_citInitial": 1,
   "eqLabelWithNumbers": true,
   "eqNumInitial": 1,
   "hotkeys": {
    "equation": "Ctrl-E",
    "itemize": "Ctrl-I"
   },
   "labels_anchors": false,
   "latex_user_defs": false,
   "report_style_numbering": false,
   "user_envs_cfg": true
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": false,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}