notebooks/places.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from datetime import datetime, timezone, timedelta\n"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Lugares"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "areaexp = pd.read_csv('../db/csv/areaexp.csv')\n",
    "areapro = pd.read_csv('../db/csv/areapro.csv')\n",
    "barrio = pd.read_csv('../db/csv/barrio.csv')\n",
    "comuna = pd.read_csv('../db/csv/comuna.csv')\n",
    "sector = pd.read_csv('../db/csv/sector.csv')\n",
    "vereda = pd.read_csv('../db/csv/vereda.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "created = datetime.now(tz=timezone(offset=-timedelta(hours=5), name='America/Bogota')).isoformat()\n",
    "updated = datetime.now(tz=timezone(offset=-timedelta(hours=5), name='America/Bogota')).isoformat()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>nombre</th>\n",
       "      <th>codigo</th>\n",
       "      <th>created</th>\n",
       "      <th>updated</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Las Vegas</td>\n",
       "      <td>8101</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Las Vegas del Lili</td>\n",
       "      <td>8102</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Ciudad Melendez</td>\n",
       "      <td>8103</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Ciudad Melendez 2</td>\n",
       "      <td>8104</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>El Guayabal</td>\n",
       "      <td>8105</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id              nombre  codigo                    created   \n",
       "0   1           Las Vegas    8101  2023-04-27T20:02:34-07:00  \\\n",
       "1   2  Las Vegas del Lili    8102  2023-04-27T20:02:34-07:00   \n",
       "2   3     Ciudad Melendez    8103  2023-04-27T20:02:34-07:00   \n",
       "3   4   Ciudad Melendez 2    8104  2023-04-27T20:02:34-07:00   \n",
       "4   5         El Guayabal    8105  2023-04-27T20:02:34-07:00   \n",
       "\n",
       "                     updated  \n",
       "0  2023-04-27T20:02:34-07:00  \n",
       "1  2023-04-27T20:02:34-07:00  \n",
       "2  2023-04-27T20:02:34-07:00  \n",
       "3  2023-04-27T20:02:34-07:00  \n",
       "4  2023-04-27T20:02:34-07:00  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "areaexp.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>id</th>\n",
       "      <th>nombre</th>\n",
       "      <th>codigo</th>\n",
       "      <th>created</th>\n",
       "      <th>updated</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Jarillon Río Cauca I</td>\n",
       "      <td>9197</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Jarillon Río Cauca II</td>\n",
       "      <td>9198</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Jarillon Río Cauca III</td>\n",
       "      <td>9199</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id                  nombre  codigo                    created   \n",
       "0   1    Jarillon Río Cauca I    9197  2023-04-27T20:02:34-07:00  \\\n",
       "1   2   Jarillon Río Cauca II    9198  2023-04-27T20:02:34-07:00   \n",
       "2   3  Jarillon Río Cauca III    9199  2023-04-27T20:02:34-07:00   \n",
       "\n",
       "                     updated  \n",
       "0  2023-04-27T20:02:34-07:00  \n",
       "1  2023-04-27T20:02:34-07:00  \n",
       "2  2023-04-27T20:02:34-07:00  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "areapro.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>id</th>\n",
       "      <th>nombre</th>\n",
       "      <th>codigo</th>\n",
       "      <th>estrato</th>\n",
       "      <th>id_comuna</th>\n",
       "      <th>created</th>\n",
       "      <th>updated</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Terrón Colorado</td>\n",
       "      <td>101</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Vista Hermosa</td>\n",
       "      <td>102</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Sector Patio Bonito</td>\n",
       "      <td>196</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Aguacatal</td>\n",
       "      <td>199</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Santa Rita</td>\n",
       "      <td>201</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id               nombre  codigo estrato  id_comuna   \n",
       "0   1      Terrón Colorado     101       2          1  \\\n",
       "1   2        Vista Hermosa     102       1          1   \n",
       "2   3  Sector Patio Bonito     196       1          1   \n",
       "3   4            Aguacatal     199       1          1   \n",
       "4   5           Santa Rita     201       6          2   \n",
       "\n",
       "                     created                    updated  \n",
       "0  2023-04-27T20:02:34-07:00  2023-04-27T20:02:34-07:00  \n",
       "1  2023-04-27T20:02:34-07:00  2023-04-27T20:02:34-07:00  \n",
       "2  2023-04-27T20:02:34-07:00  2023-04-27T20:02:34-07:00  \n",
       "3  2023-04-27T20:02:34-07:00  2023-04-27T20:02:34-07:00  \n",
       "4  2023-04-27T20:02:34-07:00  2023-04-27T20:02:34-07:00  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "barrio.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>id</th>\n",
       "      <th>nombre</th>\n",
       "      <th>codigo</th>\n",
       "      <th>created</th>\n",
       "      <th>updated</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Comuna 1</td>\n",
       "      <td>C1</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Comuna 2</td>\n",
       "      <td>C2</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Comuna 3</td>\n",
       "      <td>C3</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Comuna 4</td>\n",
       "      <td>C4</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Comuna 5</td>\n",
       "      <td>C5</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id    nombre codigo                    created                    updated\n",
       "0   1  Comuna 1     C1  2023-04-27T20:02:34-07:00  2023-04-27T20:02:34-07:00\n",
       "1   2  Comuna 2     C2  2023-04-27T20:02:34-07:00  2023-04-27T20:02:34-07:00\n",
       "2   3  Comuna 3     C3  2023-04-27T20:02:34-07:00  2023-04-27T20:02:34-07:00\n",
       "3   4  Comuna 4     C4  2023-04-27T20:02:34-07:00  2023-04-27T20:02:34-07:00\n",
       "4   5  Comuna 5     C5  2023-04-27T20:02:34-07:00  2023-04-27T20:02:34-07:00"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "comuna.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>id</th>\n",
       "      <th>nombre</th>\n",
       "      <th>codigo</th>\n",
       "      <th>id_vereda</th>\n",
       "      <th>created</th>\n",
       "      <th>updated</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Navarro (Cabecera)</td>\n",
       "      <td>5101</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>El Estero</td>\n",
       "      <td>5102</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Zona de reserva agrícola</td>\n",
       "      <td>5198</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Jarillón Navarro</td>\n",
       "      <td>5199</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>El Hormiguero (Cabecera)</td>\n",
       "      <td>5201</td>\n",
       "      <td>2</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id                    nombre  codigo  id_vereda                    created   \n",
       "0   1        Navarro (Cabecera)    5101          1  2023-04-27T20:02:34-07:00  \\\n",
       "1   2                 El Estero    5102          1  2023-04-27T20:02:34-07:00   \n",
       "2   3  Zona de reserva agrícola    5198          1  2023-04-27T20:02:34-07:00   \n",
       "3   4          Jarillón Navarro    5199          1  2023-04-27T20:02:34-07:00   \n",
       "4   5  El Hormiguero (Cabecera)    5201          2  2023-04-27T20:02:34-07:00   \n",
       "\n",
       "                     updated  \n",
       "0  2023-04-27T20:02:34-07:00  \n",
       "1  2023-04-27T20:02:34-07:00  \n",
       "2  2023-04-27T20:02:34-07:00  \n",
       "3  2023-04-27T20:02:34-07:00  \n",
       "4  2023-04-27T20:02:34-07:00  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sector.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>id</th>\n",
       "      <th>nombre</th>\n",
       "      <th>codigo</th>\n",
       "      <th>created</th>\n",
       "      <th>updated</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>NAVARRO</td>\n",
       "      <td>5100</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>EL HORMIGUERO</td>\n",
       "      <td>5200</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>PANCE</td>\n",
       "      <td>5300</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>LA BUITRERA</td>\n",
       "      <td>5400</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>VILLACARMELO</td>\n",
       "      <td>5500</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id         nombre  codigo                    created   \n",
       "0   1        NAVARRO    5100  2023-04-27T20:02:34-07:00  \\\n",
       "1   2  EL HORMIGUERO    5200  2023-04-27T20:02:34-07:00   \n",
       "2   3          PANCE    5300  2023-04-27T20:02:34-07:00   \n",
       "3   4    LA BUITRERA    5400  2023-04-27T20:02:34-07:00   \n",
       "4   5   VILLACARMELO    5500  2023-04-27T20:02:34-07:00   \n",
       "\n",
       "                     updated  \n",
       "0  2023-04-27T20:02:34-07:00  \n",
       "1  2023-04-27T20:02:34-07:00  \n",
       "2  2023-04-27T20:02:34-07:00  \n",
       "3  2023-04-27T20:02:34-07:00  \n",
       "4  2023-04-27T20:02:34-07:00  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vereda.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>id</th>\n",
       "      <th>nombre</th>\n",
       "      <th>codigo</th>\n",
       "      <th>created</th>\n",
       "      <th>updated</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Navarro</td>\n",
       "      <td>5100</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>El Hormiguero</td>\n",
       "      <td>5200</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Pance</td>\n",
       "      <td>5300</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>La Buitrera</td>\n",
       "      <td>5400</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Villacarmelo</td>\n",
       "      <td>5500</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id         nombre  codigo                    created   \n",
       "0   1        Navarro    5100  2023-04-27T20:02:34-07:00  \\\n",
       "1   2  El Hormiguero    5200  2023-04-27T20:02:34-07:00   \n",
       "2   3          Pance    5300  2023-04-27T20:02:34-07:00   \n",
       "3   4    La Buitrera    5400  2023-04-27T20:02:34-07:00   \n",
       "4   5   Villacarmelo    5500  2023-04-27T20:02:34-07:00   \n",
       "\n",
       "                     updated  \n",
       "0  2023-04-27T20:02:34-07:00  \n",
       "1  2023-04-27T20:02:34-07:00  \n",
       "2  2023-04-27T20:02:34-07:00  \n",
       "3  2023-04-27T20:02:34-07:00  \n",
       "4  2023-04-27T20:02:34-07:00  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vereda['nombre'] = vereda['nombre'].str.title()\n",
    "vereda.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Lugares Codes\n",
    "COMUNACODES = 1000\n",
    "BARRIOCODES = 2000\n",
    "VEREDACODES = 3000\n",
    "SECTORCODES = 4000\n",
    "AREAEXPCODES = 5000\n",
    "AREAPROCODES = 6000\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "areaexp['id'] = range(AREAEXPCODES, AREAEXPCODES + len(areaexp['id']))\n",
    "areapro['id'] = range(AREAPROCODES, AREAPROCODES + len(areapro['id']))\n",
    "barrio['id'] = range(BARRIOCODES, BARRIOCODES + len(barrio['id']))\n",
    "comuna['id'] = range(COMUNACODES, COMUNACODES + len(comuna['id']))\n",
    "sector['id'] = range(SECTORCODES, SECTORCODES + len(sector['id']))\n",
    "vereda['id'] = range(VEREDACODES, VEREDACODES + len(vereda['id']))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "barrio['id_comuna'] = barrio['id_comuna'].apply(lambda id: (id - 1) + COMUNACODES if id < COMUNACODES else id)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "sector['id_vereda'] = sector['id_vereda'].apply(lambda id: (id - 1) + VEREDACODES if id < COMUNACODES else id)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>id</th>\n",
       "      <th>nombre</th>\n",
       "      <th>codigo</th>\n",
       "      <th>estrato</th>\n",
       "      <th>id_comuna</th>\n",
       "      <th>created</th>\n",
       "      <th>updated</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2000</td>\n",
       "      <td>Terrón Colorado</td>\n",
       "      <td>101</td>\n",
       "      <td>2</td>\n",
       "      <td>1000</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2001</td>\n",
       "      <td>Vista Hermosa</td>\n",
       "      <td>102</td>\n",
       "      <td>1</td>\n",
       "      <td>1000</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2002</td>\n",
       "      <td>Sector Patio Bonito</td>\n",
       "      <td>196</td>\n",
       "      <td>1</td>\n",
       "      <td>1000</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2003</td>\n",
       "      <td>Aguacatal</td>\n",
       "      <td>199</td>\n",
       "      <td>1</td>\n",
       "      <td>1000</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2004</td>\n",
       "      <td>Santa Rita</td>\n",
       "      <td>201</td>\n",
       "      <td>6</td>\n",
       "      <td>1001</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     id               nombre  codigo estrato  id_comuna   \n",
       "0  2000      Terrón Colorado     101       2       1000  \\\n",
       "1  2001        Vista Hermosa     102       1       1000   \n",
       "2  2002  Sector Patio Bonito     196       1       1000   \n",
       "3  2003            Aguacatal     199       1       1000   \n",
       "4  2004           Santa Rita     201       6       1001   \n",
       "\n",
       "                     created                    updated  \n",
       "0  2023-04-27T20:02:34-07:00  2023-04-27T20:02:34-07:00  \n",
       "1  2023-04-27T20:02:34-07:00  2023-04-27T20:02:34-07:00  \n",
       "2  2023-04-27T20:02:34-07:00  2023-04-27T20:02:34-07:00  \n",
       "3  2023-04-27T20:02:34-07:00  2023-04-27T20:02:34-07:00  \n",
       "4  2023-04-27T20:02:34-07:00  2023-04-27T20:02:34-07:00  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "barrio.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>id</th>\n",
       "      <th>nombre</th>\n",
       "      <th>codigo</th>\n",
       "      <th>id_vereda</th>\n",
       "      <th>created</th>\n",
       "      <th>updated</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4000</td>\n",
       "      <td>Navarro (Cabecera)</td>\n",
       "      <td>5101</td>\n",
       "      <td>3000</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4001</td>\n",
       "      <td>El Estero</td>\n",
       "      <td>5102</td>\n",
       "      <td>3000</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4002</td>\n",
       "      <td>Zona de reserva agrícola</td>\n",
       "      <td>5198</td>\n",
       "      <td>3000</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4003</td>\n",
       "      <td>Jarillón Navarro</td>\n",
       "      <td>5199</td>\n",
       "      <td>3000</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4004</td>\n",
       "      <td>El Hormiguero (Cabecera)</td>\n",
       "      <td>5201</td>\n",
       "      <td>3001</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "      <td>2023-04-27T20:02:34-07:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     id                    nombre  codigo  id_vereda   \n",
       "0  4000        Navarro (Cabecera)    5101       3000  \\\n",
       "1  4001                 El Estero    5102       3000   \n",
       "2  4002  Zona de reserva agrícola    5198       3000   \n",
       "3  4003          Jarillón Navarro    5199       3000   \n",
       "4  4004  El Hormiguero (Cabecera)    5201       3001   \n",
       "\n",
       "                     created                    updated  \n",
       "0  2023-04-27T20:02:34-07:00  2023-04-27T20:02:34-07:00  \n",
       "1  2023-04-27T20:02:34-07:00  2023-04-27T20:02:34-07:00  \n",
       "2  2023-04-27T20:02:34-07:00  2023-04-27T20:02:34-07:00  \n",
       "3  2023-04-27T20:02:34-07:00  2023-04-27T20:02:34-07:00  \n",
       "4  2023-04-27T20:02:34-07:00  2023-04-27T20:02:34-07:00  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sector.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>id</th>\n",
       "      <th>nombre</th>\n",
       "      <th>created</th>\n",
       "      <th>updated</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1000</td>\n",
       "      <td>Comuna 1</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1001</td>\n",
       "      <td>Comuna 2</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1002</td>\n",
       "      <td>Comuna 3</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1003</td>\n",
       "      <td>Comuna 4</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1004</td>\n",
       "      <td>Comuna 5</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</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>22</th>\n",
       "      <td>5022</td>\n",
       "      <td>PP8</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>5023</td>\n",
       "      <td>PP6</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6000</td>\n",
       "      <td>Jarillon Río Cauca I</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>6001</td>\n",
       "      <td>Jarillon Río Cauca II</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>6002</td>\n",
       "      <td>Jarillon Río Cauca III</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>485 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      id                  nombre                           created   \n",
       "0   1000                Comuna 1  2023-05-21T13:03:04.887992-05:00  \\\n",
       "1   1001                Comuna 2  2023-05-21T13:03:04.887992-05:00   \n",
       "2   1002                Comuna 3  2023-05-21T13:03:04.887992-05:00   \n",
       "3   1003                Comuna 4  2023-05-21T13:03:04.887992-05:00   \n",
       "4   1004                Comuna 5  2023-05-21T13:03:04.887992-05:00   \n",
       "..   ...                     ...                               ...   \n",
       "22  5022                     PP8  2023-05-21T13:03:04.887992-05:00   \n",
       "23  5023                     PP6  2023-05-21T13:03:04.887992-05:00   \n",
       "0   6000    Jarillon Río Cauca I  2023-05-21T13:03:04.887992-05:00   \n",
       "1   6001   Jarillon Río Cauca II  2023-05-21T13:03:04.887992-05:00   \n",
       "2   6002  Jarillon Río Cauca III  2023-05-21T13:03:04.887992-05:00   \n",
       "\n",
       "                             updated  \n",
       "0   2023-05-21T13:03:04.888298-05:00  \n",
       "1   2023-05-21T13:03:04.888298-05:00  \n",
       "2   2023-05-21T13:03:04.888298-05:00  \n",
       "3   2023-05-21T13:03:04.888298-05:00  \n",
       "4   2023-05-21T13:03:04.888298-05:00  \n",
       "..                               ...  \n",
       "22  2023-05-21T13:03:04.888298-05:00  \n",
       "23  2023-05-21T13:03:04.888298-05:00  \n",
       "0   2023-05-21T13:03:04.888298-05:00  \n",
       "1   2023-05-21T13:03:04.888298-05:00  \n",
       "2   2023-05-21T13:03:04.888298-05:00  \n",
       "\n",
       "[485 rows x 4 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lugares = [lugar[['id', 'nombre']] for lugar in [comuna, barrio, vereda, sector, areaexp, areapro]]\n",
    "lugares = pd.concat(lugares)\n",
    "lugares['created'] = created\n",
    "lugares['updated'] = updated\n",
    "lugares"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "lugares.to_csv('../db/csv/lugares.csv', index_label='id', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>id</th>\n",
       "      <th>nombre</th>\n",
       "      <th>codigo</th>\n",
       "      <th>created</th>\n",
       "      <th>updated</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1000</td>\n",
       "      <td>Comuna 1</td>\n",
       "      <td>C1</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1001</td>\n",
       "      <td>Comuna 2</td>\n",
       "      <td>C2</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1002</td>\n",
       "      <td>Comuna 3</td>\n",
       "      <td>C3</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1003</td>\n",
       "      <td>Comuna 4</td>\n",
       "      <td>C4</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1004</td>\n",
       "      <td>Comuna 5</td>\n",
       "      <td>C5</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     id    nombre codigo                           created   \n",
       "0  1000  Comuna 1     C1  2023-05-21T13:03:04.887992-05:00  \\\n",
       "1  1001  Comuna 2     C2  2023-05-21T13:03:04.887992-05:00   \n",
       "2  1002  Comuna 3     C3  2023-05-21T13:03:04.887992-05:00   \n",
       "3  1003  Comuna 4     C4  2023-05-21T13:03:04.887992-05:00   \n",
       "4  1004  Comuna 5     C5  2023-05-21T13:03:04.887992-05:00   \n",
       "\n",
       "                            updated  \n",
       "0  2023-05-21T13:03:04.888298-05:00  \n",
       "1  2023-05-21T13:03:04.888298-05:00  \n",
       "2  2023-05-21T13:03:04.888298-05:00  \n",
       "3  2023-05-21T13:03:04.888298-05:00  \n",
       "4  2023-05-21T13:03:04.888298-05:00  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "comuna['created'] = created\n",
    "comuna['updated'] = updated\n",
    "comuna.to_csv('../db/csv/comuna.csv', index_label='id', index=False)\n",
    "comuna.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>id</th>\n",
       "      <th>nombre</th>\n",
       "      <th>codigo</th>\n",
       "      <th>estrato</th>\n",
       "      <th>id_comuna</th>\n",
       "      <th>created</th>\n",
       "      <th>updated</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2000</td>\n",
       "      <td>Terrón Colorado</td>\n",
       "      <td>101</td>\n",
       "      <td>2</td>\n",
       "      <td>1000</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2001</td>\n",
       "      <td>Vista Hermosa</td>\n",
       "      <td>102</td>\n",
       "      <td>1</td>\n",
       "      <td>1000</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2002</td>\n",
       "      <td>Sector Patio Bonito</td>\n",
       "      <td>196</td>\n",
       "      <td>1</td>\n",
       "      <td>1000</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2003</td>\n",
       "      <td>Aguacatal</td>\n",
       "      <td>199</td>\n",
       "      <td>1</td>\n",
       "      <td>1000</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2004</td>\n",
       "      <td>Santa Rita</td>\n",
       "      <td>201</td>\n",
       "      <td>6</td>\n",
       "      <td>1001</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     id               nombre  codigo estrato  id_comuna   \n",
       "0  2000      Terrón Colorado     101       2       1000  \\\n",
       "1  2001        Vista Hermosa     102       1       1000   \n",
       "2  2002  Sector Patio Bonito     196       1       1000   \n",
       "3  2003            Aguacatal     199       1       1000   \n",
       "4  2004           Santa Rita     201       6       1001   \n",
       "\n",
       "                            created                           updated  \n",
       "0  2023-05-21T13:03:04.887992-05:00  2023-05-21T13:03:04.888298-05:00  \n",
       "1  2023-05-21T13:03:04.887992-05:00  2023-05-21T13:03:04.888298-05:00  \n",
       "2  2023-05-21T13:03:04.887992-05:00  2023-05-21T13:03:04.888298-05:00  \n",
       "3  2023-05-21T13:03:04.887992-05:00  2023-05-21T13:03:04.888298-05:00  \n",
       "4  2023-05-21T13:03:04.887992-05:00  2023-05-21T13:03:04.888298-05:00  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "barrio['created'] = created\n",
    "barrio['updated'] = updated\n",
    "barrio.to_csv('../db/csv/barrio.csv', index_label='id', index=False)\n",
    "barrio.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>id</th>\n",
       "      <th>nombre</th>\n",
       "      <th>codigo</th>\n",
       "      <th>created</th>\n",
       "      <th>updated</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3000</td>\n",
       "      <td>Navarro</td>\n",
       "      <td>5100</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3001</td>\n",
       "      <td>El Hormiguero</td>\n",
       "      <td>5200</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3002</td>\n",
       "      <td>Pance</td>\n",
       "      <td>5300</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3003</td>\n",
       "      <td>La Buitrera</td>\n",
       "      <td>5400</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3004</td>\n",
       "      <td>Villacarmelo</td>\n",
       "      <td>5500</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     id         nombre  codigo                           created   \n",
       "0  3000        Navarro    5100  2023-05-21T13:03:04.887992-05:00  \\\n",
       "1  3001  El Hormiguero    5200  2023-05-21T13:03:04.887992-05:00   \n",
       "2  3002          Pance    5300  2023-05-21T13:03:04.887992-05:00   \n",
       "3  3003    La Buitrera    5400  2023-05-21T13:03:04.887992-05:00   \n",
       "4  3004   Villacarmelo    5500  2023-05-21T13:03:04.887992-05:00   \n",
       "\n",
       "                            updated  \n",
       "0  2023-05-21T13:03:04.888298-05:00  \n",
       "1  2023-05-21T13:03:04.888298-05:00  \n",
       "2  2023-05-21T13:03:04.888298-05:00  \n",
       "3  2023-05-21T13:03:04.888298-05:00  \n",
       "4  2023-05-21T13:03:04.888298-05:00  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vereda['created'] = created\n",
    "vereda['updated'] = updated\n",
    "vereda.to_csv('../db/csv/vereda.csv', index_label='id', index=False)\n",
    "vereda.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>id</th>\n",
       "      <th>nombre</th>\n",
       "      <th>codigo</th>\n",
       "      <th>id_vereda</th>\n",
       "      <th>created</th>\n",
       "      <th>updated</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4000</td>\n",
       "      <td>Navarro (Cabecera)</td>\n",
       "      <td>5101</td>\n",
       "      <td>3000</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4001</td>\n",
       "      <td>El Estero</td>\n",
       "      <td>5102</td>\n",
       "      <td>3000</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4002</td>\n",
       "      <td>Zona de reserva agrícola</td>\n",
       "      <td>5198</td>\n",
       "      <td>3000</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4003</td>\n",
       "      <td>Jarillón Navarro</td>\n",
       "      <td>5199</td>\n",
       "      <td>3000</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4004</td>\n",
       "      <td>El Hormiguero (Cabecera)</td>\n",
       "      <td>5201</td>\n",
       "      <td>3001</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     id                    nombre  codigo  id_vereda   \n",
       "0  4000        Navarro (Cabecera)    5101       3000  \\\n",
       "1  4001                 El Estero    5102       3000   \n",
       "2  4002  Zona de reserva agrícola    5198       3000   \n",
       "3  4003          Jarillón Navarro    5199       3000   \n",
       "4  4004  El Hormiguero (Cabecera)    5201       3001   \n",
       "\n",
       "                            created                           updated  \n",
       "0  2023-05-21T13:03:04.887992-05:00  2023-05-21T13:03:04.888298-05:00  \n",
       "1  2023-05-21T13:03:04.887992-05:00  2023-05-21T13:03:04.888298-05:00  \n",
       "2  2023-05-21T13:03:04.887992-05:00  2023-05-21T13:03:04.888298-05:00  \n",
       "3  2023-05-21T13:03:04.887992-05:00  2023-05-21T13:03:04.888298-05:00  \n",
       "4  2023-05-21T13:03:04.887992-05:00  2023-05-21T13:03:04.888298-05:00  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sector['created'] = created\n",
    "sector['updated'] = updated\n",
    "sector.to_csv('../db/csv/sector.csv', index_label='id', index=False)\n",
    "sector.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>id</th>\n",
       "      <th>nombre</th>\n",
       "      <th>codigo</th>\n",
       "      <th>created</th>\n",
       "      <th>updated</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5000</td>\n",
       "      <td>Las Vegas</td>\n",
       "      <td>8101</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5001</td>\n",
       "      <td>Las Vegas del Lili</td>\n",
       "      <td>8102</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5002</td>\n",
       "      <td>Ciudad Melendez</td>\n",
       "      <td>8103</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5003</td>\n",
       "      <td>Ciudad Melendez 2</td>\n",
       "      <td>8104</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5004</td>\n",
       "      <td>El Guayabal</td>\n",
       "      <td>8105</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     id              nombre  codigo                           created   \n",
       "0  5000           Las Vegas    8101  2023-05-21T13:03:04.887992-05:00  \\\n",
       "1  5001  Las Vegas del Lili    8102  2023-05-21T13:03:04.887992-05:00   \n",
       "2  5002     Ciudad Melendez    8103  2023-05-21T13:03:04.887992-05:00   \n",
       "3  5003   Ciudad Melendez 2    8104  2023-05-21T13:03:04.887992-05:00   \n",
       "4  5004         El Guayabal    8105  2023-05-21T13:03:04.887992-05:00   \n",
       "\n",
       "                            updated  \n",
       "0  2023-05-21T13:03:04.888298-05:00  \n",
       "1  2023-05-21T13:03:04.888298-05:00  \n",
       "2  2023-05-21T13:03:04.888298-05:00  \n",
       "3  2023-05-21T13:03:04.888298-05:00  \n",
       "4  2023-05-21T13:03:04.888298-05:00  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "areaexp['created'] = created\n",
    "areaexp['updated'] = updated\n",
    "areaexp.to_csv('../db/csv/areaexp.csv', index_label='id', index=False)\n",
    "areaexp.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>id</th>\n",
       "      <th>nombre</th>\n",
       "      <th>codigo</th>\n",
       "      <th>created</th>\n",
       "      <th>updated</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6000</td>\n",
       "      <td>Jarillon Río Cauca I</td>\n",
       "      <td>9197</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>6001</td>\n",
       "      <td>Jarillon Río Cauca II</td>\n",
       "      <td>9198</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>6002</td>\n",
       "      <td>Jarillon Río Cauca III</td>\n",
       "      <td>9199</td>\n",
       "      <td>2023-05-21T13:03:04.887992-05:00</td>\n",
       "      <td>2023-05-21T13:03:04.888298-05:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     id                  nombre  codigo                           created   \n",
       "0  6000    Jarillon Río Cauca I    9197  2023-05-21T13:03:04.887992-05:00  \\\n",
       "1  6001   Jarillon Río Cauca II    9198  2023-05-21T13:03:04.887992-05:00   \n",
       "2  6002  Jarillon Río Cauca III    9199  2023-05-21T13:03:04.887992-05:00   \n",
       "\n",
       "                            updated  \n",
       "0  2023-05-21T13:03:04.888298-05:00  \n",
       "1  2023-05-21T13:03:04.888298-05:00  \n",
       "2  2023-05-21T13:03:04.888298-05:00  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "areapro['created'] = created\n",
    "areapro['updated'] = updated\n",
    "areapro.to_csv('../db/csv/areapro.csv', index_label='id', index=False)\n",
    "areapro.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": ".venv",
   "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.10.6"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}