Project 2 - code.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "bb398390",
   "metadata": {},
   "source": [
    "# Project 2: A look into solar farms across the island"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ac0a8ddd",
   "metadata": {},
   "source": [
    "This code is the data analysis conducted as part of Project 2 for Lede Program, and it's a look into construction permits given to establish solar farms across the archipélago."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "73f7b0d5",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "45c824d9",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_main = pd.read_excel(\"Main_Permisos Aprobados OGPE_2012_2021.xlsm\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "250dc2d7",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_update = pd.read_excel(\"Update_Permisos Aprobados OGPE_2012_2021.xlsx\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "0f79379f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(371852, 12)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_main.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "64d3d891",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1365, 12)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_update.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "86121b82",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "373217\n"
     ]
    }
   ],
   "source": [
    "print(371852 + 1365)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ac00c52c",
   "metadata": {},
   "source": [
    "The merge was sucessful since the sum of rows from both dataframes is equal to the merged df:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "6e01e6e6",
   "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>CPT_ID</th>\n",
       "      <th>TRÁMITE</th>\n",
       "      <th>ESTADO_TRÁMITE</th>\n",
       "      <th>TIPO_TRÁMITE</th>\n",
       "      <th>FECHA_SOMETIDO</th>\n",
       "      <th>FECHA_EXPEDIDO</th>\n",
       "      <th>NOMBRE_PROYECTO</th>\n",
       "      <th>DESCRIPCIÓN_PROYECTO</th>\n",
       "      <th>SOLICITANTE</th>\n",
       "      <th>MUNICIPIO</th>\n",
       "      <th>CDBG_DR</th>\n",
       "      <th>COORDENADAS_X_Y</th>\n",
       "      <th>COORDENADAS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>848363</td>\n",
       "      <td>2021-415824-PCOC-021390</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>2021-12-23</td>\n",
       "      <td>2022-01-11</td>\n",
       "      <td>REMODELACION INTERIOR PARA CUATRO (4) APARTAME...</td>\n",
       "      <td>REMODELACION INTERIOR PARA CUATRO (4) APARTAME...</td>\n",
       "      <td>ing.arodzpa@yahoo.com</td>\n",
       "      <td>Guayama</td>\n",
       "      <td>0</td>\n",
       "      <td>18.00129992026974,-66.11360639333725</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>848485</td>\n",
       "      <td>2021-416058-PCOC-021395</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>2021-12-23</td>\n",
       "      <td>2022-01-11</td>\n",
       "      <td>CAMPO MOFONGO RESTAURANT - CANTINA</td>\n",
       "      <td>RESTAURANTE</td>\n",
       "      <td>ing.arodzpa@yahoo.com</td>\n",
       "      <td>Canóvanas</td>\n",
       "      <td>0</td>\n",
       "      <td>18.35172045,-65.89898544</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>848527</td>\n",
       "      <td>2021-416081-PCOC-021396</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>2021-12-23</td>\n",
       "      <td>2022-01-10</td>\n",
       "      <td>Parque del Retiro II</td>\n",
       "      <td>Permiso de Construcción, Privada - Remodelació...</td>\n",
       "      <td>julio@enginerix.com</td>\n",
       "      <td>Morovis</td>\n",
       "      <td>0</td>\n",
       "      <td>18.33050467,-66.39994426</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>848739</td>\n",
       "      <td>2021-415871-PCOC-021403</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>2021-12-23</td>\n",
       "      <td>2022-01-04</td>\n",
       "      <td>Estructura Comercial - Angel L. López Ramos</td>\n",
       "      <td>Estructura Comercial - Angel L. López Ramos</td>\n",
       "      <td>juan.m.curbelo@gmail.com</td>\n",
       "      <td>Lares</td>\n",
       "      <td>0</td>\n",
       "      <td>18.27705317,-66.89399285</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>849426</td>\n",
       "      <td>2021-415882-PCOC-021431</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>2021-12-27</td>\n",
       "      <td>2022-01-11</td>\n",
       "      <td>Emmanuel Serrano Vázquez Permiso de Construcci...</td>\n",
       "      <td>Se solicita Permiso de construcción certificad...</td>\n",
       "      <td>ricardordj@yahoo.com</td>\n",
       "      <td>Vega Alta</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47536117,-66.33075159</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371847</th>\n",
       "      <td>20251</td>\n",
       "      <td>2014-016540-PUS-020251</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PUS</td>\n",
       "      <td>2014-10-28</td>\n",
       "      <td>2015-02-27</td>\n",
       "      <td>Hermandad de Iglesias y Comunidades Cristianas...</td>\n",
       "      <td>IGLESIA</td>\n",
       "      <td>robertovegasantiago07@gmail.com</td>\n",
       "      <td>Adjuntas</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.google.com/maps/@18.1711522429912,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371848</th>\n",
       "      <td>20252</td>\n",
       "      <td>2014-016542-CPI-020252</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>CPI</td>\n",
       "      <td>2014-10-28</td>\n",
       "      <td>2014-11-03</td>\n",
       "      <td>Essence By Glory</td>\n",
       "      <td>Jabones, cremas y Spa</td>\n",
       "      <td>essencebyglory@hotmail.com</td>\n",
       "      <td>San Juan</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.google.com/maps/@18.345174279544,-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371849</th>\n",
       "      <td>20253</td>\n",
       "      <td>2014-016541-CSA-020253</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>CSA</td>\n",
       "      <td>2014-10-28</td>\n",
       "      <td>2014-12-08</td>\n",
       "      <td>Essence By Glory</td>\n",
       "      <td>Jabones, cremas y Spa</td>\n",
       "      <td>essencebyglory@hotmail.com</td>\n",
       "      <td>San Juan</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.google.com/maps/@18.345174279544,-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371850</th>\n",
       "      <td>20254</td>\n",
       "      <td>2014-016543-PUS-020254</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PUS</td>\n",
       "      <td>2014-10-28</td>\n",
       "      <td>2014-10-30</td>\n",
       "      <td>fiesta patronales de peÒuelas</td>\n",
       "      <td>kiosko conventas al letal con bebidas alcoholica</td>\n",
       "      <td>karina_cc14@hotmail.com</td>\n",
       "      <td>PeÒuelas</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.google.com/maps/@18.04579243746337...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371851</th>\n",
       "      <td>20255</td>\n",
       "      <td>2014-016545-CPI-020255</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>CPI</td>\n",
       "      <td>2014-10-28</td>\n",
       "      <td>2015-10-08</td>\n",
       "      <td>VENTA DE BEBIDAS ALCOHOLICAS AL DETAL</td>\n",
       "      <td>VENTA DE BEBIDAS ALCOHOLICAS AL DETAL</td>\n",
       "      <td>bebomed@hotmail.com</td>\n",
       "      <td>Aguadilla</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.google.com/maps/@18.4220672828423,...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>373217 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        CPT_ID                  TRÁMITE   ESTADO_TRÁMITE TIPO_TRÁMITE  \\\n",
       "0       848363  2021-415824-PCOC-021390  PERMIT_APPROVED         PCOC   \n",
       "1       848485  2021-416058-PCOC-021395  PERMIT_APPROVED         PCOC   \n",
       "2       848527  2021-416081-PCOC-021396  PERMIT_APPROVED         PCOC   \n",
       "3       848739  2021-415871-PCOC-021403  PERMIT_APPROVED         PCOC   \n",
       "4       849426  2021-415882-PCOC-021431  PERMIT_APPROVED         PCOC   \n",
       "...        ...                      ...              ...          ...   \n",
       "371847   20251   2014-016540-PUS-020251  PERMIT_APPROVED          PUS   \n",
       "371848   20252   2014-016542-CPI-020252  PERMIT_APPROVED          CPI   \n",
       "371849   20253   2014-016541-CSA-020253  PERMIT_APPROVED          CSA   \n",
       "371850   20254   2014-016543-PUS-020254  PERMIT_APPROVED          PUS   \n",
       "371851   20255   2014-016545-CPI-020255  PERMIT_APPROVED          CPI   \n",
       "\n",
       "       FECHA_SOMETIDO FECHA_EXPEDIDO  \\\n",
       "0          2021-12-23     2022-01-11   \n",
       "1          2021-12-23     2022-01-11   \n",
       "2          2021-12-23     2022-01-10   \n",
       "3          2021-12-23     2022-01-04   \n",
       "4          2021-12-27     2022-01-11   \n",
       "...               ...            ...   \n",
       "371847     2014-10-28     2015-02-27   \n",
       "371848     2014-10-28     2014-11-03   \n",
       "371849     2014-10-28     2014-12-08   \n",
       "371850     2014-10-28     2014-10-30   \n",
       "371851     2014-10-28     2015-10-08   \n",
       "\n",
       "                                          NOMBRE_PROYECTO  \\\n",
       "0       REMODELACION INTERIOR PARA CUATRO (4) APARTAME...   \n",
       "1                      CAMPO MOFONGO RESTAURANT - CANTINA   \n",
       "2                                    Parque del Retiro II   \n",
       "3             Estructura Comercial - Angel L. López Ramos   \n",
       "4       Emmanuel Serrano Vázquez Permiso de Construcci...   \n",
       "...                                                   ...   \n",
       "371847  Hermandad de Iglesias y Comunidades Cristianas...   \n",
       "371848                                   Essence By Glory   \n",
       "371849                                   Essence By Glory   \n",
       "371850                      fiesta patronales de peÒuelas   \n",
       "371851             VENTA DE BEBIDAS ALCOHOLICAS AL DETAL    \n",
       "\n",
       "                                     DESCRIPCIÓN_PROYECTO  \\\n",
       "0       REMODELACION INTERIOR PARA CUATRO (4) APARTAME...   \n",
       "1                                             RESTAURANTE   \n",
       "2       Permiso de Construcción, Privada - Remodelació...   \n",
       "3             Estructura Comercial - Angel L. López Ramos   \n",
       "4       Se solicita Permiso de construcción certificad...   \n",
       "...                                                   ...   \n",
       "371847                                            IGLESIA   \n",
       "371848                              Jabones, cremas y Spa   \n",
       "371849                              Jabones, cremas y Spa   \n",
       "371850   kiosko conventas al letal con bebidas alcoholica   \n",
       "371851             VENTA DE BEBIDAS ALCOHOLICAS AL DETAL    \n",
       "\n",
       "                            SOLICITANTE  MUNICIPIO  CDBG_DR  \\\n",
       "0                 ing.arodzpa@yahoo.com    Guayama        0   \n",
       "1                 ing.arodzpa@yahoo.com  Canóvanas        0   \n",
       "2                   julio@enginerix.com    Morovis        0   \n",
       "3              juan.m.curbelo@gmail.com      Lares        0   \n",
       "4                  ricardordj@yahoo.com  Vega Alta        0   \n",
       "...                                 ...        ...      ...   \n",
       "371847  robertovegasantiago07@gmail.com   Adjuntas        0   \n",
       "371848       essencebyglory@hotmail.com   San Juan        0   \n",
       "371849       essencebyglory@hotmail.com   San Juan        0   \n",
       "371850          karina_cc14@hotmail.com   PeÒuelas        0   \n",
       "371851              bebomed@hotmail.com  Aguadilla        0   \n",
       "\n",
       "                             COORDENADAS_X_Y  \\\n",
       "0       18.00129992026974,-66.11360639333725   \n",
       "1                   18.35172045,-65.89898544   \n",
       "2                   18.33050467,-66.39994426   \n",
       "3                   18.27705317,-66.89399285   \n",
       "4                   18.47536117,-66.33075159   \n",
       "...                                      ...   \n",
       "371847                                   NaN   \n",
       "371848                                   NaN   \n",
       "371849                                   NaN   \n",
       "371850                                   NaN   \n",
       "371851                                   NaN   \n",
       "\n",
       "                                              COORDENADAS  \n",
       "0                                                     NaN  \n",
       "1                                                     NaN  \n",
       "2                                                     NaN  \n",
       "3                                                     NaN  \n",
       "4                                                     NaN  \n",
       "...                                                   ...  \n",
       "371847  https://www.google.com/maps/@18.1711522429912,...  \n",
       "371848  https://www.google.com/maps/@18.345174279544,-...  \n",
       "371849  https://www.google.com/maps/@18.345174279544,-...  \n",
       "371850  https://www.google.com/maps/@18.04579243746337...  \n",
       "371851  https://www.google.com/maps/@18.4220672828423,...  \n",
       "\n",
       "[373217 rows x 13 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.concat([df_update, df_main])\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "9907190f",
   "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>TIPO_TRÁMITE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>DEC</th>\n",
       "      <td>84601</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PUS</th>\n",
       "      <td>47439</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CSA</th>\n",
       "      <td>42532</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CPI</th>\n",
       "      <td>39092</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PU</th>\n",
       "      <td>28694</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     TIPO_TRÁMITE\n",
       "DEC         84601\n",
       "PUS         47439\n",
       "CSA         42532\n",
       "CPI         39092\n",
       "PU          28694"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.TIPO_TRÁMITE.value_counts().to_frame().head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "1fd772d2",
   "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>CPT_ID</th>\n",
       "      <th>TRÁMITE</th>\n",
       "      <th>ESTADO_TRÁMITE</th>\n",
       "      <th>TIPO_TRÁMITE</th>\n",
       "      <th>FECHA_SOMETIDO</th>\n",
       "      <th>FECHA_EXPEDIDO</th>\n",
       "      <th>NOMBRE_PROYECTO</th>\n",
       "      <th>DESCRIPCIÓN_PROYECTO</th>\n",
       "      <th>SOLICITANTE</th>\n",
       "      <th>MUNICIPIO</th>\n",
       "      <th>CDBG_DR</th>\n",
       "      <th>COORDENADAS_X_Y</th>\n",
       "      <th>COORDENADAS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>848363</td>\n",
       "      <td>2021-415824-PCOC-021390</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>2021-12-23</td>\n",
       "      <td>2022-01-11</td>\n",
       "      <td>REMODELACION INTERIOR PARA CUATRO (4) APARTAME...</td>\n",
       "      <td>REMODELACION INTERIOR PARA CUATRO (4) APARTAME...</td>\n",
       "      <td>ing.arodzpa@yahoo.com</td>\n",
       "      <td>Guayama</td>\n",
       "      <td>0</td>\n",
       "      <td>18.00129992026974,-66.11360639333725</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>848485</td>\n",
       "      <td>2021-416058-PCOC-021395</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>2021-12-23</td>\n",
       "      <td>2022-01-11</td>\n",
       "      <td>CAMPO MOFONGO RESTAURANT - CANTINA</td>\n",
       "      <td>RESTAURANTE</td>\n",
       "      <td>ing.arodzpa@yahoo.com</td>\n",
       "      <td>Canóvanas</td>\n",
       "      <td>0</td>\n",
       "      <td>18.35172045,-65.89898544</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>848527</td>\n",
       "      <td>2021-416081-PCOC-021396</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>2021-12-23</td>\n",
       "      <td>2022-01-10</td>\n",
       "      <td>Parque del Retiro II</td>\n",
       "      <td>Permiso de Construcción, Privada - Remodelació...</td>\n",
       "      <td>julio@enginerix.com</td>\n",
       "      <td>Morovis</td>\n",
       "      <td>0</td>\n",
       "      <td>18.33050467,-66.39994426</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>848739</td>\n",
       "      <td>2021-415871-PCOC-021403</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>2021-12-23</td>\n",
       "      <td>2022-01-04</td>\n",
       "      <td>Estructura Comercial - Angel L. López Ramos</td>\n",
       "      <td>Estructura Comercial - Angel L. López Ramos</td>\n",
       "      <td>juan.m.curbelo@gmail.com</td>\n",
       "      <td>Lares</td>\n",
       "      <td>0</td>\n",
       "      <td>18.27705317,-66.89399285</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>849426</td>\n",
       "      <td>2021-415882-PCOC-021431</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>2021-12-27</td>\n",
       "      <td>2022-01-11</td>\n",
       "      <td>Emmanuel Serrano Vázquez Permiso de Construcci...</td>\n",
       "      <td>Se solicita Permiso de construcción certificad...</td>\n",
       "      <td>ricardordj@yahoo.com</td>\n",
       "      <td>Vega Alta</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47536117,-66.33075159</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362580</th>\n",
       "      <td>50359</td>\n",
       "      <td>2015-039340-PCO-050359</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>2015-03-04</td>\n",
       "      <td>2015-03-10</td>\n",
       "      <td>Permiso de Gean C. Torres Rivera</td>\n",
       "      <td>Permiso para una residencia Plano Modelo Ferrm...</td>\n",
       "      <td>matgferrmax2@gmail.com</td>\n",
       "      <td>Moca</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.google.com/maps/@18.3386718144967,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362597</th>\n",
       "      <td>49277</td>\n",
       "      <td>2015-038699-PCO-049277</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>2015-03-03</td>\n",
       "      <td>2015-05-11</td>\n",
       "      <td>Residencia del Sr. Carlos Manuel Gonzalez Andujar</td>\n",
       "      <td>Residencia en hormigon y bloques unifamiliar d...</td>\n",
       "      <td>alfredorodriguez84@yahoo.com</td>\n",
       "      <td>ManatÌ</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.google.com/maps/@18.4496147814754,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362600</th>\n",
       "      <td>49474</td>\n",
       "      <td>2015-038862-PCO-049474</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>2015-03-03</td>\n",
       "      <td>2015-04-06</td>\n",
       "      <td>Residencia Joel ValentÌn ColÛn</td>\n",
       "      <td>Residencia unifamiliar, dos plantas, en hormig...</td>\n",
       "      <td>ingenierojnvelez@gmail.com</td>\n",
       "      <td>AÒasco</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.google.com/maps/@18.3050356915723,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>369666</th>\n",
       "      <td>24696</td>\n",
       "      <td>2014-019562-PCO-024696</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>2014-12-02</td>\n",
       "      <td>2015-03-03</td>\n",
       "      <td>Kiosko y terraza abierta</td>\n",
       "      <td>Kiosko y terraza abierta</td>\n",
       "      <td>tutocajigas@yahoo.com</td>\n",
       "      <td>Aguada</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.google.com/maps/@18.38971445772890...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>370516</th>\n",
       "      <td>24813</td>\n",
       "      <td>2014-019609-PCO-024813</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>2014-12-03</td>\n",
       "      <td>2015-09-03</td>\n",
       "      <td>VIVIENDA (TRAILER) LUIS JAIME MEAUX</td>\n",
       "      <td>CONSTRUCCION DE VIVIENDA (TRAILER)</td>\n",
       "      <td>benjaminvsandoval@hotmail.com</td>\n",
       "      <td>Aguas Buenas</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.google.com/maps/@18.2188261177835,...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20117 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        CPT_ID                  TRÁMITE   ESTADO_TRÁMITE TIPO_TRÁMITE  \\\n",
       "0       848363  2021-415824-PCOC-021390  PERMIT_APPROVED         PCOC   \n",
       "1       848485  2021-416058-PCOC-021395  PERMIT_APPROVED         PCOC   \n",
       "2       848527  2021-416081-PCOC-021396  PERMIT_APPROVED         PCOC   \n",
       "3       848739  2021-415871-PCOC-021403  PERMIT_APPROVED         PCOC   \n",
       "4       849426  2021-415882-PCOC-021431  PERMIT_APPROVED         PCOC   \n",
       "...        ...                      ...              ...          ...   \n",
       "362580   50359   2015-039340-PCO-050359  PERMIT_APPROVED          PCO   \n",
       "362597   49277   2015-038699-PCO-049277  PERMIT_APPROVED          PCO   \n",
       "362600   49474   2015-038862-PCO-049474  PERMIT_APPROVED          PCO   \n",
       "369666   24696   2014-019562-PCO-024696  PERMIT_APPROVED          PCO   \n",
       "370516   24813   2014-019609-PCO-024813  PERMIT_APPROVED          PCO   \n",
       "\n",
       "       FECHA_SOMETIDO FECHA_EXPEDIDO  \\\n",
       "0          2021-12-23     2022-01-11   \n",
       "1          2021-12-23     2022-01-11   \n",
       "2          2021-12-23     2022-01-10   \n",
       "3          2021-12-23     2022-01-04   \n",
       "4          2021-12-27     2022-01-11   \n",
       "...               ...            ...   \n",
       "362580     2015-03-04     2015-03-10   \n",
       "362597     2015-03-03     2015-05-11   \n",
       "362600     2015-03-03     2015-04-06   \n",
       "369666     2014-12-02     2015-03-03   \n",
       "370516     2014-12-03     2015-09-03   \n",
       "\n",
       "                                          NOMBRE_PROYECTO  \\\n",
       "0       REMODELACION INTERIOR PARA CUATRO (4) APARTAME...   \n",
       "1                      CAMPO MOFONGO RESTAURANT - CANTINA   \n",
       "2                                    Parque del Retiro II   \n",
       "3             Estructura Comercial - Angel L. López Ramos   \n",
       "4       Emmanuel Serrano Vázquez Permiso de Construcci...   \n",
       "...                                                   ...   \n",
       "362580                   Permiso de Gean C. Torres Rivera   \n",
       "362597  Residencia del Sr. Carlos Manuel Gonzalez Andujar   \n",
       "362600                     Residencia Joel ValentÌn ColÛn   \n",
       "369666                           Kiosko y terraza abierta   \n",
       "370516                VIVIENDA (TRAILER) LUIS JAIME MEAUX   \n",
       "\n",
       "                                     DESCRIPCIÓN_PROYECTO  \\\n",
       "0       REMODELACION INTERIOR PARA CUATRO (4) APARTAME...   \n",
       "1                                             RESTAURANTE   \n",
       "2       Permiso de Construcción, Privada - Remodelació...   \n",
       "3             Estructura Comercial - Angel L. López Ramos   \n",
       "4       Se solicita Permiso de construcción certificad...   \n",
       "...                                                   ...   \n",
       "362580  Permiso para una residencia Plano Modelo Ferrm...   \n",
       "362597  Residencia en hormigon y bloques unifamiliar d...   \n",
       "362600  Residencia unifamiliar, dos plantas, en hormig...   \n",
       "369666                           Kiosko y terraza abierta   \n",
       "370516                 CONSTRUCCION DE VIVIENDA (TRAILER)   \n",
       "\n",
       "                          SOLICITANTE     MUNICIPIO  CDBG_DR  \\\n",
       "0               ing.arodzpa@yahoo.com       Guayama        0   \n",
       "1               ing.arodzpa@yahoo.com     Canóvanas        0   \n",
       "2                 julio@enginerix.com       Morovis        0   \n",
       "3            juan.m.curbelo@gmail.com         Lares        0   \n",
       "4                ricardordj@yahoo.com     Vega Alta        0   \n",
       "...                               ...           ...      ...   \n",
       "362580         matgferrmax2@gmail.com          Moca        0   \n",
       "362597   alfredorodriguez84@yahoo.com        ManatÌ        0   \n",
       "362600     ingenierojnvelez@gmail.com        AÒasco        0   \n",
       "369666          tutocajigas@yahoo.com        Aguada        0   \n",
       "370516  benjaminvsandoval@hotmail.com  Aguas Buenas        0   \n",
       "\n",
       "                             COORDENADAS_X_Y  \\\n",
       "0       18.00129992026974,-66.11360639333725   \n",
       "1                   18.35172045,-65.89898544   \n",
       "2                   18.33050467,-66.39994426   \n",
       "3                   18.27705317,-66.89399285   \n",
       "4                   18.47536117,-66.33075159   \n",
       "...                                      ...   \n",
       "362580                                   NaN   \n",
       "362597                                   NaN   \n",
       "362600                                   NaN   \n",
       "369666                                   NaN   \n",
       "370516                                   NaN   \n",
       "\n",
       "                                              COORDENADAS  \n",
       "0                                                     NaN  \n",
       "1                                                     NaN  \n",
       "2                                                     NaN  \n",
       "3                                                     NaN  \n",
       "4                                                     NaN  \n",
       "...                                                   ...  \n",
       "362580  https://www.google.com/maps/@18.3386718144967,...  \n",
       "362597  https://www.google.com/maps/@18.4496147814754,...  \n",
       "362600  https://www.google.com/maps/@18.3050356915723,...  \n",
       "369666  https://www.google.com/maps/@18.38971445772890...  \n",
       "370516  https://www.google.com/maps/@18.2188261177835,...  \n",
       "\n",
       "[20117 rows x 13 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df[df[\"TIPO_TRÁMITE\"].isin([\"PCOC\",\"PCO\"])]\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "24e02218",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"permisos de construcción 2012-2021.csv\",index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fa9205ef",
   "metadata": {},
   "source": [
    "# Part 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "75ffef25",
   "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>CPT_ID</th>\n",
       "      <th>TRÁMITE</th>\n",
       "      <th>ESTADO_TRÁMITE</th>\n",
       "      <th>TIPO_TRÁMITE</th>\n",
       "      <th>FECHA_SOMETIDO</th>\n",
       "      <th>FECHA_EXPEDIDO</th>\n",
       "      <th>NOMBRE_PROYECTO</th>\n",
       "      <th>DESCRIPCIÓN_PROYECTO</th>\n",
       "      <th>SOLICITANTE</th>\n",
       "      <th>MUNICIPIO</th>\n",
       "      <th>CDBG_DR</th>\n",
       "      <th>COORDENADAS_LAT</th>\n",
       "      <th>COORDENADAS_LON</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>848363</td>\n",
       "      <td>2021-415824-PCOC-021390</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>12/23/2021</td>\n",
       "      <td>1/11/2022</td>\n",
       "      <td>REMODELACION INTERIOR PARA CUATRO (4) APARTAME...</td>\n",
       "      <td>REMODELACION INTERIOR PARA CUATRO (4) APARTAME...</td>\n",
       "      <td>ing.arodzpa@yahoo.com</td>\n",
       "      <td>Guayama</td>\n",
       "      <td>0</td>\n",
       "      <td>18.00129992</td>\n",
       "      <td>-66.11360639</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>848485</td>\n",
       "      <td>2021-416058-PCOC-021395</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>12/23/2021</td>\n",
       "      <td>1/11/2022</td>\n",
       "      <td>CAMPO MOFONGO RESTAURANT - CANTINA</td>\n",
       "      <td>RESTAURANTE</td>\n",
       "      <td>ing.arodzpa@yahoo.com</td>\n",
       "      <td>Canóvanas</td>\n",
       "      <td>0</td>\n",
       "      <td>18.35172045</td>\n",
       "      <td>-65.89898544</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>848527</td>\n",
       "      <td>2021-416081-PCOC-021396</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>12/23/2021</td>\n",
       "      <td>1/10/2022</td>\n",
       "      <td>Parque del Retiro II</td>\n",
       "      <td>Permiso de Construcción, Privada - Remodelació...</td>\n",
       "      <td>julio@enginerix.com</td>\n",
       "      <td>Morovis</td>\n",
       "      <td>0</td>\n",
       "      <td>18.33050467</td>\n",
       "      <td>-66.39994426</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>848739</td>\n",
       "      <td>2021-415871-PCOC-021403</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>12/23/2021</td>\n",
       "      <td>1/4/2022</td>\n",
       "      <td>Estructura Comercial - Angel L. López Ramos</td>\n",
       "      <td>Estructura Comercial - Angel L. López Ramos</td>\n",
       "      <td>juan.m.curbelo@gmail.com</td>\n",
       "      <td>Lares</td>\n",
       "      <td>0</td>\n",
       "      <td>18.27705317</td>\n",
       "      <td>-66.89399285</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>849426</td>\n",
       "      <td>2021-415882-PCOC-021431</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>12/27/2021</td>\n",
       "      <td>1/11/2022</td>\n",
       "      <td>Emmanuel Serrano Vázquez Permiso de Construcci...</td>\n",
       "      <td>Se solicita Permiso de construcción certificad...</td>\n",
       "      <td>ricardordj@yahoo.com</td>\n",
       "      <td>Vega Alta</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47536117</td>\n",
       "      <td>-66.33075159</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20112</th>\n",
       "      <td>50359</td>\n",
       "      <td>2015-039340-PCO-050359</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>3/4/2015</td>\n",
       "      <td>3/10/2015</td>\n",
       "      <td>Permiso de Gean C. Torres Rivera</td>\n",
       "      <td>Permiso para una residencia Plano Modelo Ferrm...</td>\n",
       "      <td>matgferrmax2@gmail.com</td>\n",
       "      <td>Moca</td>\n",
       "      <td>0</td>\n",
       "      <td>18.33867181</td>\n",
       "      <td>-67.07116502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20113</th>\n",
       "      <td>49277</td>\n",
       "      <td>2015-038699-PCO-049277</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>3/3/2015</td>\n",
       "      <td>5/11/2015</td>\n",
       "      <td>Residencia del Sr. Carlos Manuel Gonzalez Andujar</td>\n",
       "      <td>Residencia en hormigon y bloques unifamiliar d...</td>\n",
       "      <td>alfredorodriguez84@yahoo.com</td>\n",
       "      <td>ManatÌ</td>\n",
       "      <td>0</td>\n",
       "      <td>18.44961478</td>\n",
       "      <td>-66.4834879</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20114</th>\n",
       "      <td>49474</td>\n",
       "      <td>2015-038862-PCO-049474</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>3/3/2015</td>\n",
       "      <td>4/6/2015</td>\n",
       "      <td>Residencia Joel ValentÌn ColÛn</td>\n",
       "      <td>Residencia unifamiliar, dos plantas, en hormig...</td>\n",
       "      <td>ingenierojnvelez@gmail.com</td>\n",
       "      <td>AÒasco</td>\n",
       "      <td>0</td>\n",
       "      <td>18.30503569</td>\n",
       "      <td>-67.16463856</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20115</th>\n",
       "      <td>24696</td>\n",
       "      <td>2014-019562-PCO-024696</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>12/2/2014</td>\n",
       "      <td>3/3/2015</td>\n",
       "      <td>Kiosko y terraza abierta</td>\n",
       "      <td>Kiosko y terraza abierta</td>\n",
       "      <td>tutocajigas@yahoo.com</td>\n",
       "      <td>Aguada</td>\n",
       "      <td>0</td>\n",
       "      <td>18.38971446</td>\n",
       "      <td>-67.20180273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20116</th>\n",
       "      <td>24813</td>\n",
       "      <td>2014-019609-PCO-024813</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>12/3/2014</td>\n",
       "      <td>9/3/2015</td>\n",
       "      <td>VIVIENDA (TRAILER) LUIS JAIME MEAUX</td>\n",
       "      <td>CONSTRUCCION DE VIVIENDA (TRAILER)</td>\n",
       "      <td>benjaminvsandoval@hotmail.com</td>\n",
       "      <td>Aguas Buenas</td>\n",
       "      <td>0</td>\n",
       "      <td>18.21882612</td>\n",
       "      <td>-66.13160199</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20117 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       CPT_ID                  TRÁMITE   ESTADO_TRÁMITE TIPO_TRÁMITE  \\\n",
       "0      848363  2021-415824-PCOC-021390  PERMIT_APPROVED         PCOC   \n",
       "1      848485  2021-416058-PCOC-021395  PERMIT_APPROVED         PCOC   \n",
       "2      848527  2021-416081-PCOC-021396  PERMIT_APPROVED         PCOC   \n",
       "3      848739  2021-415871-PCOC-021403  PERMIT_APPROVED         PCOC   \n",
       "4      849426  2021-415882-PCOC-021431  PERMIT_APPROVED         PCOC   \n",
       "...       ...                      ...              ...          ...   \n",
       "20112   50359   2015-039340-PCO-050359  PERMIT_APPROVED          PCO   \n",
       "20113   49277   2015-038699-PCO-049277  PERMIT_APPROVED          PCO   \n",
       "20114   49474   2015-038862-PCO-049474  PERMIT_APPROVED          PCO   \n",
       "20115   24696   2014-019562-PCO-024696  PERMIT_APPROVED          PCO   \n",
       "20116   24813   2014-019609-PCO-024813  PERMIT_APPROVED          PCO   \n",
       "\n",
       "      FECHA_SOMETIDO FECHA_EXPEDIDO  \\\n",
       "0         12/23/2021      1/11/2022   \n",
       "1         12/23/2021      1/11/2022   \n",
       "2         12/23/2021      1/10/2022   \n",
       "3         12/23/2021       1/4/2022   \n",
       "4         12/27/2021      1/11/2022   \n",
       "...              ...            ...   \n",
       "20112       3/4/2015      3/10/2015   \n",
       "20113       3/3/2015      5/11/2015   \n",
       "20114       3/3/2015       4/6/2015   \n",
       "20115      12/2/2014       3/3/2015   \n",
       "20116      12/3/2014       9/3/2015   \n",
       "\n",
       "                                         NOMBRE_PROYECTO  \\\n",
       "0      REMODELACION INTERIOR PARA CUATRO (4) APARTAME...   \n",
       "1                     CAMPO MOFONGO RESTAURANT - CANTINA   \n",
       "2                                   Parque del Retiro II   \n",
       "3            Estructura Comercial - Angel L. López Ramos   \n",
       "4      Emmanuel Serrano Vázquez Permiso de Construcci...   \n",
       "...                                                  ...   \n",
       "20112                   Permiso de Gean C. Torres Rivera   \n",
       "20113  Residencia del Sr. Carlos Manuel Gonzalez Andujar   \n",
       "20114                     Residencia Joel ValentÌn ColÛn   \n",
       "20115                           Kiosko y terraza abierta   \n",
       "20116                VIVIENDA (TRAILER) LUIS JAIME MEAUX   \n",
       "\n",
       "                                    DESCRIPCIÓN_PROYECTO  \\\n",
       "0      REMODELACION INTERIOR PARA CUATRO (4) APARTAME...   \n",
       "1                                            RESTAURANTE   \n",
       "2      Permiso de Construcción, Privada - Remodelació...   \n",
       "3            Estructura Comercial - Angel L. López Ramos   \n",
       "4      Se solicita Permiso de construcción certificad...   \n",
       "...                                                  ...   \n",
       "20112  Permiso para una residencia Plano Modelo Ferrm...   \n",
       "20113  Residencia en hormigon y bloques unifamiliar d...   \n",
       "20114  Residencia unifamiliar, dos plantas, en hormig...   \n",
       "20115                           Kiosko y terraza abierta   \n",
       "20116                 CONSTRUCCION DE VIVIENDA (TRAILER)   \n",
       "\n",
       "                         SOLICITANTE     MUNICIPIO  CDBG_DR COORDENADAS_LAT  \\\n",
       "0              ing.arodzpa@yahoo.com       Guayama        0     18.00129992   \n",
       "1              ing.arodzpa@yahoo.com     Canóvanas        0     18.35172045   \n",
       "2                julio@enginerix.com       Morovis        0     18.33050467   \n",
       "3           juan.m.curbelo@gmail.com         Lares        0     18.27705317   \n",
       "4               ricardordj@yahoo.com     Vega Alta        0     18.47536117   \n",
       "...                              ...           ...      ...             ...   \n",
       "20112         matgferrmax2@gmail.com          Moca        0     18.33867181   \n",
       "20113   alfredorodriguez84@yahoo.com        ManatÌ        0     18.44961478   \n",
       "20114     ingenierojnvelez@gmail.com        AÒasco        0     18.30503569   \n",
       "20115          tutocajigas@yahoo.com        Aguada        0     18.38971446   \n",
       "20116  benjaminvsandoval@hotmail.com  Aguas Buenas        0     18.21882612   \n",
       "\n",
       "      COORDENADAS_LON  \n",
       "0        -66.11360639  \n",
       "1        -65.89898544  \n",
       "2        -66.39994426  \n",
       "3        -66.89399285  \n",
       "4        -66.33075159  \n",
       "...               ...  \n",
       "20112    -67.07116502  \n",
       "20113     -66.4834879  \n",
       "20114    -67.16463856  \n",
       "20115    -67.20180273  \n",
       "20116    -66.13160199  \n",
       "\n",
       "[20117 rows x 13 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"permisos de construcción 2012-2021.csv\")\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "7903f6d8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        remodelacion interior para cuatro (4) apartame...\n",
       "1                                              restaurante\n",
       "2        permiso de construcción, privada - remodelació...\n",
       "3              estructura comercial - angel l. lópez ramos\n",
       "4        se solicita permiso de construcción certificad...\n",
       "                               ...                        \n",
       "20112    permiso para una residencia plano modelo ferrm...\n",
       "20113    residencia en hormigon y bloques unifamiliar d...\n",
       "20114    residencia unifamiliar, dos plantas, en hormig...\n",
       "20115                             kiosko y terraza abierta\n",
       "20116                   construccion de vivienda (trailer)\n",
       "Name: DESCRIPCIÓN_PROYECTO, Length: 20117, dtype: object"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.DESCRIPCIÓN_PROYECTO = df.DESCRIPCIÓN_PROYECTO.str.lower()\n",
    "df.DESCRIPCIÓN_PROYECTO"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "264b2ac1",
   "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>CPT_ID</th>\n",
       "      <th>TRÁMITE</th>\n",
       "      <th>ESTADO_TRÁMITE</th>\n",
       "      <th>TIPO_TRÁMITE</th>\n",
       "      <th>FECHA_SOMETIDO</th>\n",
       "      <th>FECHA_EXPEDIDO</th>\n",
       "      <th>NOMBRE_PROYECTO</th>\n",
       "      <th>DESCRIPCIÓN_PROYECTO</th>\n",
       "      <th>SOLICITANTE</th>\n",
       "      <th>MUNICIPIO</th>\n",
       "      <th>CDBG_DR</th>\n",
       "      <th>COORDENADAS_LAT</th>\n",
       "      <th>COORDENADAS_LON</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>838010</td>\n",
       "      <td>2020-298040-PCOC-020820</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>12/1/2021</td>\n",
       "      <td>12/6/2021</td>\n",
       "      <td>JW Marriott Hotel &amp; Marriott Vacation Club Int...</td>\n",
       "      <td>proyecto turístico de hotel y club vacacional ...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Vega Alta</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47407343</td>\n",
       "      <td>-66.31800413</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284</th>\n",
       "      <td>822963</td>\n",
       "      <td>2021-387502-PCOC-019943</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>10/27/2021</td>\n",
       "      <td>11/17/2021</td>\n",
       "      <td>HOTEL DON RAFA</td>\n",
       "      <td>hotel turístico con recepción en el 1er nivel,...</td>\n",
       "      <td>proactiveconstruction@gmail.com</td>\n",
       "      <td>San Juan</td>\n",
       "      <td>0</td>\n",
       "      <td>18.45629497</td>\n",
       "      <td>-66.08483253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>408</th>\n",
       "      <td>820083</td>\n",
       "      <td>2018-248043-PCOC-019759</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>10/21/2021</td>\n",
       "      <td>12/6/2021</td>\n",
       "      <td>Atlantic Estates at Bahia Beach Resort</td>\n",
       "      <td>desarrollo de 32 lotes unifamiliares y un lote...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Río Grande</td>\n",
       "      <td>0</td>\n",
       "      <td>18.41608108</td>\n",
       "      <td>-65.82121611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>495</th>\n",
       "      <td>805077</td>\n",
       "      <td>2021-400214-PCOC-018803</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>10/7/2021</td>\n",
       "      <td>11/23/2021</td>\n",
       "      <td>PARGUERA PLAZA HOTEL</td>\n",
       "      <td>remodelacion y ampliacion de parguera plaza hotel</td>\n",
       "      <td>ing.arodzpa@yahoo.com</td>\n",
       "      <td>Lajas</td>\n",
       "      <td>0</td>\n",
       "      <td>17.97410386</td>\n",
       "      <td>-67.04964086</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1447</th>\n",
       "      <td>774278</td>\n",
       "      <td>2020-298040-PCOC-016789</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>7/8/2021</td>\n",
       "      <td>7/14/2021</td>\n",
       "      <td>JW Marriott Hotel &amp; Marriott Vacation Club Int...</td>\n",
       "      <td>proyecto turìstico de hotel y club vacacional ...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Vega Alta</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47407343</td>\n",
       "      <td>-66.31800413</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19206</th>\n",
       "      <td>91719</td>\n",
       "      <td>2015-050945-PCO-091719</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>7/22/2015</td>\n",
       "      <td>4/8/2016</td>\n",
       "      <td>Hotel Municipal Dorado</td>\n",
       "      <td>hotel que constar· de tres (3) pisos con 53 h...</td>\n",
       "      <td>permisos@dg3a.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47480101</td>\n",
       "      <td>-66.27844691</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19266</th>\n",
       "      <td>90644</td>\n",
       "      <td>2015-063621-PCO-090644</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>7/20/2015</td>\n",
       "      <td>7/24/2015</td>\n",
       "      <td>Beachfront Residences at Dorado Beach Resort III</td>\n",
       "      <td>construcciûn de condohotel de 14 unidades mult...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47522117</td>\n",
       "      <td>-66.30899843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19621</th>\n",
       "      <td>54797</td>\n",
       "      <td>2015-041888-PCO-054797</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>3/20/2015</td>\n",
       "      <td>4/1/2015</td>\n",
       "      <td>West Beach Residences IV</td>\n",
       "      <td>edificio iv de condohotel dentro de dorado bea...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47478574</td>\n",
       "      <td>-66.30676031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19780</th>\n",
       "      <td>41504</td>\n",
       "      <td>2014-005393-PCO-041504</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>2/10/2015</td>\n",
       "      <td>8/19/2015</td>\n",
       "      <td>Wyndham Rio Mar Hotel Renovation</td>\n",
       "      <td>wyndham rio mar hotel renovation</td>\n",
       "      <td>csapermitspr@csagroup.com</td>\n",
       "      <td>RÌo Grande</td>\n",
       "      <td>0</td>\n",
       "      <td>18.38452536</td>\n",
       "      <td>-65.75912802</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19862</th>\n",
       "      <td>41826</td>\n",
       "      <td>2014-005393-PCO-041826</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>2/13/2015</td>\n",
       "      <td>5/20/2015</td>\n",
       "      <td>Wyndham Rio Mar Hotel Renovation</td>\n",
       "      <td>wyndham rio mar hotel renovation</td>\n",
       "      <td>csapermitspr@csagroup.com</td>\n",
       "      <td>RÌo Grande</td>\n",
       "      <td>0</td>\n",
       "      <td>18.38452536</td>\n",
       "      <td>-65.75912802</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>75 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       CPT_ID                  TRÁMITE   ESTADO_TRÁMITE TIPO_TRÁMITE  \\\n",
       "62     838010  2020-298040-PCOC-020820  PERMIT_APPROVED         PCOC   \n",
       "284    822963  2021-387502-PCOC-019943  PERMIT_APPROVED         PCOC   \n",
       "408    820083  2018-248043-PCOC-019759  PERMIT_APPROVED         PCOC   \n",
       "495    805077  2021-400214-PCOC-018803  PERMIT_APPROVED         PCOC   \n",
       "1447   774278  2020-298040-PCOC-016789  PERMIT_APPROVED         PCOC   \n",
       "...       ...                      ...              ...          ...   \n",
       "19206   91719   2015-050945-PCO-091719  PERMIT_APPROVED          PCO   \n",
       "19266   90644   2015-063621-PCO-090644  PERMIT_APPROVED          PCO   \n",
       "19621   54797   2015-041888-PCO-054797  PERMIT_APPROVED          PCO   \n",
       "19780   41504   2014-005393-PCO-041504  PERMIT_APPROVED          PCO   \n",
       "19862   41826   2014-005393-PCO-041826  PERMIT_APPROVED          PCO   \n",
       "\n",
       "      FECHA_SOMETIDO FECHA_EXPEDIDO  \\\n",
       "62         12/1/2021      12/6/2021   \n",
       "284       10/27/2021     11/17/2021   \n",
       "408       10/21/2021      12/6/2021   \n",
       "495        10/7/2021     11/23/2021   \n",
       "1447        7/8/2021      7/14/2021   \n",
       "...              ...            ...   \n",
       "19206      7/22/2015       4/8/2016   \n",
       "19266      7/20/2015      7/24/2015   \n",
       "19621      3/20/2015       4/1/2015   \n",
       "19780      2/10/2015      8/19/2015   \n",
       "19862      2/13/2015      5/20/2015   \n",
       "\n",
       "                                         NOMBRE_PROYECTO  \\\n",
       "62     JW Marriott Hotel & Marriott Vacation Club Int...   \n",
       "284                                       HOTEL DON RAFA   \n",
       "408               Atlantic Estates at Bahia Beach Resort   \n",
       "495                                 PARGUERA PLAZA HOTEL   \n",
       "1447   JW Marriott Hotel & Marriott Vacation Club Int...   \n",
       "...                                                  ...   \n",
       "19206                             Hotel Municipal Dorado   \n",
       "19266   Beachfront Residences at Dorado Beach Resort III   \n",
       "19621                           West Beach Residences IV   \n",
       "19780                   Wyndham Rio Mar Hotel Renovation   \n",
       "19862                   Wyndham Rio Mar Hotel Renovation   \n",
       "\n",
       "                                    DESCRIPCIÓN_PROYECTO  \\\n",
       "62     proyecto turístico de hotel y club vacacional ...   \n",
       "284    hotel turístico con recepción en el 1er nivel,...   \n",
       "408    desarrollo de 32 lotes unifamiliares y un lote...   \n",
       "495    remodelacion y ampliacion de parguera plaza hotel   \n",
       "1447   proyecto turìstico de hotel y club vacacional ...   \n",
       "...                                                  ...   \n",
       "19206   hotel que constar· de tres (3) pisos con 53 h...   \n",
       "19266  construcciûn de condohotel de 14 unidades mult...   \n",
       "19621  edificio iv de condohotel dentro de dorado bea...   \n",
       "19780                   wyndham rio mar hotel renovation   \n",
       "19862                   wyndham rio mar hotel renovation   \n",
       "\n",
       "                           SOLICITANTE   MUNICIPIO  CDBG_DR COORDENADAS_LAT  \\\n",
       "62                    pjaner@cmapr.com   Vega Alta        0     18.47407343   \n",
       "284    proactiveconstruction@gmail.com    San Juan        0     18.45629497   \n",
       "408                   pjaner@cmapr.com  Río Grande        0     18.41608108   \n",
       "495              ing.arodzpa@yahoo.com       Lajas        0     17.97410386   \n",
       "1447                  pjaner@cmapr.com   Vega Alta        0     18.47407343   \n",
       "...                                ...         ...      ...             ...   \n",
       "19206                permisos@dg3a.com      Dorado        0     18.47480101   \n",
       "19266                 pjaner@cmapr.com      Dorado        0     18.47522117   \n",
       "19621                 pjaner@cmapr.com      Dorado        0     18.47478574   \n",
       "19780        csapermitspr@csagroup.com  RÌo Grande        0     18.38452536   \n",
       "19862        csapermitspr@csagroup.com  RÌo Grande        0     18.38452536   \n",
       "\n",
       "      COORDENADAS_LON  \n",
       "62       -66.31800413  \n",
       "284      -66.08483253  \n",
       "408      -65.82121611  \n",
       "495      -67.04964086  \n",
       "1447     -66.31800413  \n",
       "...               ...  \n",
       "19206    -66.27844691  \n",
       "19266    -66.30899843  \n",
       "19621    -66.30676031  \n",
       "19780    -65.75912802  \n",
       "19862    -65.75912802  \n",
       "\n",
       "[75 rows x 13 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_hotel = df[df['DESCRIPCIÓN_PROYECTO'].str.contains('hotel')]\n",
    "df_hotel"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "de2bc998",
   "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>CPT_ID</th>\n",
       "      <th>TRÁMITE</th>\n",
       "      <th>ESTADO_TRÁMITE</th>\n",
       "      <th>TIPO_TRÁMITE</th>\n",
       "      <th>FECHA_SOMETIDO</th>\n",
       "      <th>FECHA_EXPEDIDO</th>\n",
       "      <th>NOMBRE_PROYECTO</th>\n",
       "      <th>DESCRIPCIÓN_PROYECTO</th>\n",
       "      <th>SOLICITANTE</th>\n",
       "      <th>MUNICIPIO</th>\n",
       "      <th>CDBG_DR</th>\n",
       "      <th>COORDENADAS_LAT</th>\n",
       "      <th>COORDENADAS_LON</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>408</th>\n",
       "      <td>820083</td>\n",
       "      <td>2018-248043-PCOC-019759</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>10/21/2021</td>\n",
       "      <td>12/6/2021</td>\n",
       "      <td>Atlantic Estates at Bahia Beach Resort</td>\n",
       "      <td>desarrollo de 32 lotes unifamiliares y un lote...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Río Grande</td>\n",
       "      <td>0</td>\n",
       "      <td>18.41608108</td>\n",
       "      <td>-65.82121611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3382</th>\n",
       "      <td>707843</td>\n",
       "      <td>2019-289961-PCOC-012341</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>2/9/2021</td>\n",
       "      <td>4/19/2021</td>\n",
       "      <td>West Point Residences &amp; Residents' Beach Club</td>\n",
       "      <td>8 edificios de condohotel con 36 unidades y ed...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47568122</td>\n",
       "      <td>-66.30985022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3645</th>\n",
       "      <td>698885</td>\n",
       "      <td>2021-351364-PCOC-011815</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>1/18/2021</td>\n",
       "      <td>3/24/2021</td>\n",
       "      <td>DBR West Point Residences I</td>\n",
       "      <td>condohotel de ocho (8) unidades multifamiliares</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47588474</td>\n",
       "      <td>-66.30959272</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6512</th>\n",
       "      <td>622355</td>\n",
       "      <td>2019-252750-PCOC-007373</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>7/8/2020</td>\n",
       "      <td>7/13/2020</td>\n",
       "      <td>Beachfront Residences at Dorado Beach Resort V</td>\n",
       "      <td>edificio de condohotel de ocho (8) unidades re...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47541156</td>\n",
       "      <td>-66.30841255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6902</th>\n",
       "      <td>598516</td>\n",
       "      <td>2018-248043-PCOC-005641</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>3/2/2020</td>\n",
       "      <td>9/16/2020</td>\n",
       "      <td>Atlantic Estates at Bahia Beach Resort</td>\n",
       "      <td>desarrollo de 32 lotes unifamiliares y un lote...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>RÌo Grande</td>\n",
       "      <td>0</td>\n",
       "      <td>18.41608108</td>\n",
       "      <td>-65.82121611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10996</th>\n",
       "      <td>470036</td>\n",
       "      <td>2019-252750-PCO-017841</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>1/28/2019</td>\n",
       "      <td>4/4/2019</td>\n",
       "      <td>Beachfront Residences at Dorado Beach Resort V</td>\n",
       "      <td>edificio de condohotel de ocho (8) unidades re...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47541156</td>\n",
       "      <td>-66.30841255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16176</th>\n",
       "      <td>248337</td>\n",
       "      <td>2016-135169-PCO-008633</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>11/1/2016</td>\n",
       "      <td>11/4/2016</td>\n",
       "      <td>Beachfront Residences at Dorado Beach Resort IV</td>\n",
       "      <td>16 unidades multifamiliares de condohotel</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47505032</td>\n",
       "      <td>-66.30775809</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16981</th>\n",
       "      <td>191656</td>\n",
       "      <td>2015-041888-PCO-191656</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>5/4/2016</td>\n",
       "      <td>5/23/2016</td>\n",
       "      <td>West Beach Residences IV</td>\n",
       "      <td>edificio iv de condohotel dentro de dorado bea...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47478574</td>\n",
       "      <td>-66.30676031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19266</th>\n",
       "      <td>90644</td>\n",
       "      <td>2015-063621-PCO-090644</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>7/20/2015</td>\n",
       "      <td>7/24/2015</td>\n",
       "      <td>Beachfront Residences at Dorado Beach Resort III</td>\n",
       "      <td>construcciûn de condohotel de 14 unidades mult...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47522117</td>\n",
       "      <td>-66.30899843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19621</th>\n",
       "      <td>54797</td>\n",
       "      <td>2015-041888-PCO-054797</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>3/20/2015</td>\n",
       "      <td>4/1/2015</td>\n",
       "      <td>West Beach Residences IV</td>\n",
       "      <td>edificio iv de condohotel dentro de dorado bea...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47478574</td>\n",
       "      <td>-66.30676031</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       CPT_ID                  TRÁMITE   ESTADO_TRÁMITE TIPO_TRÁMITE  \\\n",
       "408    820083  2018-248043-PCOC-019759  PERMIT_APPROVED         PCOC   \n",
       "3382   707843  2019-289961-PCOC-012341  PERMIT_APPROVED         PCOC   \n",
       "3645   698885  2021-351364-PCOC-011815  PERMIT_APPROVED         PCOC   \n",
       "6512   622355  2019-252750-PCOC-007373  PERMIT_APPROVED         PCOC   \n",
       "6902   598516  2018-248043-PCOC-005641  PERMIT_APPROVED         PCOC   \n",
       "10996  470036   2019-252750-PCO-017841  PERMIT_APPROVED          PCO   \n",
       "16176  248337   2016-135169-PCO-008633  PERMIT_APPROVED          PCO   \n",
       "16981  191656   2015-041888-PCO-191656  PERMIT_APPROVED          PCO   \n",
       "19266   90644   2015-063621-PCO-090644  PERMIT_APPROVED          PCO   \n",
       "19621   54797   2015-041888-PCO-054797  PERMIT_APPROVED          PCO   \n",
       "\n",
       "      FECHA_SOMETIDO FECHA_EXPEDIDO  \\\n",
       "408       10/21/2021      12/6/2021   \n",
       "3382        2/9/2021      4/19/2021   \n",
       "3645       1/18/2021      3/24/2021   \n",
       "6512        7/8/2020      7/13/2020   \n",
       "6902        3/2/2020      9/16/2020   \n",
       "10996      1/28/2019       4/4/2019   \n",
       "16176      11/1/2016      11/4/2016   \n",
       "16981       5/4/2016      5/23/2016   \n",
       "19266      7/20/2015      7/24/2015   \n",
       "19621      3/20/2015       4/1/2015   \n",
       "\n",
       "                                        NOMBRE_PROYECTO  \\\n",
       "408              Atlantic Estates at Bahia Beach Resort   \n",
       "3382      West Point Residences & Residents' Beach Club   \n",
       "3645                        DBR West Point Residences I   \n",
       "6512     Beachfront Residences at Dorado Beach Resort V   \n",
       "6902             Atlantic Estates at Bahia Beach Resort   \n",
       "10996    Beachfront Residences at Dorado Beach Resort V   \n",
       "16176   Beachfront Residences at Dorado Beach Resort IV   \n",
       "16981                          West Beach Residences IV   \n",
       "19266  Beachfront Residences at Dorado Beach Resort III   \n",
       "19621                          West Beach Residences IV   \n",
       "\n",
       "                                    DESCRIPCIÓN_PROYECTO       SOLICITANTE  \\\n",
       "408    desarrollo de 32 lotes unifamiliares y un lote...  pjaner@cmapr.com   \n",
       "3382   8 edificios de condohotel con 36 unidades y ed...  pjaner@cmapr.com   \n",
       "3645     condohotel de ocho (8) unidades multifamiliares  pjaner@cmapr.com   \n",
       "6512   edificio de condohotel de ocho (8) unidades re...  pjaner@cmapr.com   \n",
       "6902   desarrollo de 32 lotes unifamiliares y un lote...  pjaner@cmapr.com   \n",
       "10996  edificio de condohotel de ocho (8) unidades re...  pjaner@cmapr.com   \n",
       "16176          16 unidades multifamiliares de condohotel  pjaner@cmapr.com   \n",
       "16981  edificio iv de condohotel dentro de dorado bea...  pjaner@cmapr.com   \n",
       "19266  construcciûn de condohotel de 14 unidades mult...  pjaner@cmapr.com   \n",
       "19621  edificio iv de condohotel dentro de dorado bea...  pjaner@cmapr.com   \n",
       "\n",
       "        MUNICIPIO  CDBG_DR COORDENADAS_LAT COORDENADAS_LON  \n",
       "408    Río Grande        0     18.41608108    -65.82121611  \n",
       "3382       Dorado        0     18.47568122    -66.30985022  \n",
       "3645       Dorado        0     18.47588474    -66.30959272  \n",
       "6512       Dorado        0     18.47541156    -66.30841255  \n",
       "6902   RÌo Grande        0     18.41608108    -65.82121611  \n",
       "10996      Dorado        0     18.47541156    -66.30841255  \n",
       "16176      Dorado        0     18.47505032    -66.30775809  \n",
       "16981      Dorado        0     18.47478574    -66.30676031  \n",
       "19266      Dorado        0     18.47522117    -66.30899843  \n",
       "19621      Dorado        0     18.47478574    -66.30676031  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_condohotel = df[df['DESCRIPCIÓN_PROYECTO'].str.contains('condohotel')]\n",
    "df_condohotel"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "8ef105e3",
   "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>CPT_ID</th>\n",
       "      <th>TRÁMITE</th>\n",
       "      <th>ESTADO_TRÁMITE</th>\n",
       "      <th>TIPO_TRÁMITE</th>\n",
       "      <th>FECHA_SOMETIDO</th>\n",
       "      <th>FECHA_EXPEDIDO</th>\n",
       "      <th>NOMBRE_PROYECTO</th>\n",
       "      <th>DESCRIPCIÓN_PROYECTO</th>\n",
       "      <th>SOLICITANTE</th>\n",
       "      <th>MUNICIPIO</th>\n",
       "      <th>CDBG_DR</th>\n",
       "      <th>COORDENADAS_LAT</th>\n",
       "      <th>COORDENADAS_LON</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [CPT_ID, TRÁMITE, ESTADO_TRÁMITE, TIPO_TRÁMITE, FECHA_SOMETIDO, FECHA_EXPEDIDO, NOMBRE_PROYECTO, DESCRIPCIÓN_PROYECTO, SOLICITANTE, MUNICIPIO, CDBG_DR, COORDENADAS_LAT, COORDENADAS_LON]\n",
       "Index: []"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_turÌstico = df[df['DESCRIPCIÓN_PROYECTO'].str.contains('turÌstico')]\n",
    "df_turÌstico"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "ef837d8c",
   "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>CPT_ID</th>\n",
       "      <th>TRÁMITE</th>\n",
       "      <th>ESTADO_TRÁMITE</th>\n",
       "      <th>TIPO_TRÁMITE</th>\n",
       "      <th>FECHA_SOMETIDO</th>\n",
       "      <th>FECHA_EXPEDIDO</th>\n",
       "      <th>NOMBRE_PROYECTO</th>\n",
       "      <th>DESCRIPCIÓN_PROYECTO</th>\n",
       "      <th>SOLICITANTE</th>\n",
       "      <th>MUNICIPIO</th>\n",
       "      <th>CDBG_DR</th>\n",
       "      <th>COORDENADAS_LAT</th>\n",
       "      <th>COORDENADAS_LON</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>838010</td>\n",
       "      <td>2020-298040-PCOC-020820</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>12/1/2021</td>\n",
       "      <td>12/6/2021</td>\n",
       "      <td>JW Marriott Hotel &amp; Marriott Vacation Club Int...</td>\n",
       "      <td>proyecto turístico de hotel y club vacacional ...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Vega Alta</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47407343</td>\n",
       "      <td>-66.31800413</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>822963</td>\n",
       "      <td>2021-387502-PCOC-019943</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>10/27/2021</td>\n",
       "      <td>11/17/2021</td>\n",
       "      <td>HOTEL DON RAFA</td>\n",
       "      <td>hotel turístico con recepción en el 1er nivel,...</td>\n",
       "      <td>proactiveconstruction@gmail.com</td>\n",
       "      <td>San Juan</td>\n",
       "      <td>0</td>\n",
       "      <td>18.45629497</td>\n",
       "      <td>-66.08483253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>820083</td>\n",
       "      <td>2018-248043-PCOC-019759</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>10/21/2021</td>\n",
       "      <td>12/6/2021</td>\n",
       "      <td>Atlantic Estates at Bahia Beach Resort</td>\n",
       "      <td>desarrollo de 32 lotes unifamiliares y un lote...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Río Grande</td>\n",
       "      <td>0</td>\n",
       "      <td>18.41608108</td>\n",
       "      <td>-65.82121611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>805077</td>\n",
       "      <td>2021-400214-PCOC-018803</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>10/7/2021</td>\n",
       "      <td>11/23/2021</td>\n",
       "      <td>PARGUERA PLAZA HOTEL</td>\n",
       "      <td>remodelacion y ampliacion de parguera plaza hotel</td>\n",
       "      <td>ing.arodzpa@yahoo.com</td>\n",
       "      <td>Lajas</td>\n",
       "      <td>0</td>\n",
       "      <td>17.97410386</td>\n",
       "      <td>-67.04964086</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>774278</td>\n",
       "      <td>2020-298040-PCOC-016789</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>7/8/2021</td>\n",
       "      <td>7/14/2021</td>\n",
       "      <td>JW Marriott Hotel &amp; Marriott Vacation Club Int...</td>\n",
       "      <td>proyecto turìstico de hotel y club vacacional ...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Vega Alta</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47407343</td>\n",
       "      <td>-66.31800413</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>91719</td>\n",
       "      <td>2015-050945-PCO-091719</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>7/22/2015</td>\n",
       "      <td>4/8/2016</td>\n",
       "      <td>Hotel Municipal Dorado</td>\n",
       "      <td>hotel que constar· de tres (3) pisos con 53 h...</td>\n",
       "      <td>permisos@dg3a.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47480101</td>\n",
       "      <td>-66.27844691</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>90644</td>\n",
       "      <td>2015-063621-PCO-090644</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>7/20/2015</td>\n",
       "      <td>7/24/2015</td>\n",
       "      <td>Beachfront Residences at Dorado Beach Resort III</td>\n",
       "      <td>construcciûn de condohotel de 14 unidades mult...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47522117</td>\n",
       "      <td>-66.30899843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>54797</td>\n",
       "      <td>2015-041888-PCO-054797</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>3/20/2015</td>\n",
       "      <td>4/1/2015</td>\n",
       "      <td>West Beach Residences IV</td>\n",
       "      <td>edificio iv de condohotel dentro de dorado bea...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47478574</td>\n",
       "      <td>-66.30676031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>41504</td>\n",
       "      <td>2014-005393-PCO-041504</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>2/10/2015</td>\n",
       "      <td>8/19/2015</td>\n",
       "      <td>Wyndham Rio Mar Hotel Renovation</td>\n",
       "      <td>wyndham rio mar hotel renovation</td>\n",
       "      <td>csapermitspr@csagroup.com</td>\n",
       "      <td>RÌo Grande</td>\n",
       "      <td>0</td>\n",
       "      <td>18.38452536</td>\n",
       "      <td>-65.75912802</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>41826</td>\n",
       "      <td>2014-005393-PCO-041826</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>2/13/2015</td>\n",
       "      <td>5/20/2015</td>\n",
       "      <td>Wyndham Rio Mar Hotel Renovation</td>\n",
       "      <td>wyndham rio mar hotel renovation</td>\n",
       "      <td>csapermitspr@csagroup.com</td>\n",
       "      <td>RÌo Grande</td>\n",
       "      <td>0</td>\n",
       "      <td>18.38452536</td>\n",
       "      <td>-65.75912802</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>75 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    CPT_ID                  TRÁMITE   ESTADO_TRÁMITE TIPO_TRÁMITE  \\\n",
       "0   838010  2020-298040-PCOC-020820  PERMIT_APPROVED         PCOC   \n",
       "1   822963  2021-387502-PCOC-019943  PERMIT_APPROVED         PCOC   \n",
       "2   820083  2018-248043-PCOC-019759  PERMIT_APPROVED         PCOC   \n",
       "3   805077  2021-400214-PCOC-018803  PERMIT_APPROVED         PCOC   \n",
       "4   774278  2020-298040-PCOC-016789  PERMIT_APPROVED         PCOC   \n",
       "..     ...                      ...              ...          ...   \n",
       "70   91719   2015-050945-PCO-091719  PERMIT_APPROVED          PCO   \n",
       "71   90644   2015-063621-PCO-090644  PERMIT_APPROVED          PCO   \n",
       "72   54797   2015-041888-PCO-054797  PERMIT_APPROVED          PCO   \n",
       "73   41504   2014-005393-PCO-041504  PERMIT_APPROVED          PCO   \n",
       "74   41826   2014-005393-PCO-041826  PERMIT_APPROVED          PCO   \n",
       "\n",
       "   FECHA_SOMETIDO FECHA_EXPEDIDO  \\\n",
       "0       12/1/2021      12/6/2021   \n",
       "1      10/27/2021     11/17/2021   \n",
       "2      10/21/2021      12/6/2021   \n",
       "3       10/7/2021     11/23/2021   \n",
       "4        7/8/2021      7/14/2021   \n",
       "..            ...            ...   \n",
       "70      7/22/2015       4/8/2016   \n",
       "71      7/20/2015      7/24/2015   \n",
       "72      3/20/2015       4/1/2015   \n",
       "73      2/10/2015      8/19/2015   \n",
       "74      2/13/2015      5/20/2015   \n",
       "\n",
       "                                      NOMBRE_PROYECTO  \\\n",
       "0   JW Marriott Hotel & Marriott Vacation Club Int...   \n",
       "1                                      HOTEL DON RAFA   \n",
       "2              Atlantic Estates at Bahia Beach Resort   \n",
       "3                                PARGUERA PLAZA HOTEL   \n",
       "4   JW Marriott Hotel & Marriott Vacation Club Int...   \n",
       "..                                                ...   \n",
       "70                             Hotel Municipal Dorado   \n",
       "71   Beachfront Residences at Dorado Beach Resort III   \n",
       "72                           West Beach Residences IV   \n",
       "73                   Wyndham Rio Mar Hotel Renovation   \n",
       "74                   Wyndham Rio Mar Hotel Renovation   \n",
       "\n",
       "                                 DESCRIPCIÓN_PROYECTO  \\\n",
       "0   proyecto turístico de hotel y club vacacional ...   \n",
       "1   hotel turístico con recepción en el 1er nivel,...   \n",
       "2   desarrollo de 32 lotes unifamiliares y un lote...   \n",
       "3   remodelacion y ampliacion de parguera plaza hotel   \n",
       "4   proyecto turìstico de hotel y club vacacional ...   \n",
       "..                                                ...   \n",
       "70   hotel que constar· de tres (3) pisos con 53 h...   \n",
       "71  construcciûn de condohotel de 14 unidades mult...   \n",
       "72  edificio iv de condohotel dentro de dorado bea...   \n",
       "73                   wyndham rio mar hotel renovation   \n",
       "74                   wyndham rio mar hotel renovation   \n",
       "\n",
       "                        SOLICITANTE   MUNICIPIO  CDBG_DR COORDENADAS_LAT  \\\n",
       "0                  pjaner@cmapr.com   Vega Alta        0     18.47407343   \n",
       "1   proactiveconstruction@gmail.com    San Juan        0     18.45629497   \n",
       "2                  pjaner@cmapr.com  Río Grande        0     18.41608108   \n",
       "3             ing.arodzpa@yahoo.com       Lajas        0     17.97410386   \n",
       "4                  pjaner@cmapr.com   Vega Alta        0     18.47407343   \n",
       "..                              ...         ...      ...             ...   \n",
       "70                permisos@dg3a.com      Dorado        0     18.47480101   \n",
       "71                 pjaner@cmapr.com      Dorado        0     18.47522117   \n",
       "72                 pjaner@cmapr.com      Dorado        0     18.47478574   \n",
       "73        csapermitspr@csagroup.com  RÌo Grande        0     18.38452536   \n",
       "74        csapermitspr@csagroup.com  RÌo Grande        0     18.38452536   \n",
       "\n",
       "   COORDENADAS_LON  \n",
       "0     -66.31800413  \n",
       "1     -66.08483253  \n",
       "2     -65.82121611  \n",
       "3     -67.04964086  \n",
       "4     -66.31800413  \n",
       "..             ...  \n",
       "70    -66.27844691  \n",
       "71    -66.30899843  \n",
       "72    -66.30676031  \n",
       "73    -65.75912802  \n",
       "74    -65.75912802  \n",
       "\n",
       "[75 rows x 13 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_merge1 = df_hotel.merge(df_condohotel, how='outer')\n",
    "df_merge1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "2a8c586e",
   "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>CPT_ID</th>\n",
       "      <th>TRÁMITE</th>\n",
       "      <th>ESTADO_TRÁMITE</th>\n",
       "      <th>TIPO_TRÁMITE</th>\n",
       "      <th>FECHA_SOMETIDO</th>\n",
       "      <th>FECHA_EXPEDIDO</th>\n",
       "      <th>NOMBRE_PROYECTO</th>\n",
       "      <th>DESCRIPCIÓN_PROYECTO</th>\n",
       "      <th>SOLICITANTE</th>\n",
       "      <th>MUNICIPIO</th>\n",
       "      <th>CDBG_DR</th>\n",
       "      <th>COORDENADAS_LAT</th>\n",
       "      <th>COORDENADAS_LON</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>838010</td>\n",
       "      <td>2020-298040-PCOC-020820</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>12/1/2021</td>\n",
       "      <td>12/6/2021</td>\n",
       "      <td>JW Marriott Hotel &amp; Marriott Vacation Club Int...</td>\n",
       "      <td>proyecto turístico de hotel y club vacacional ...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Vega Alta</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47407343</td>\n",
       "      <td>-66.31800413</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>822963</td>\n",
       "      <td>2021-387502-PCOC-019943</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>10/27/2021</td>\n",
       "      <td>11/17/2021</td>\n",
       "      <td>HOTEL DON RAFA</td>\n",
       "      <td>hotel turístico con recepción en el 1er nivel,...</td>\n",
       "      <td>proactiveconstruction@gmail.com</td>\n",
       "      <td>San Juan</td>\n",
       "      <td>0</td>\n",
       "      <td>18.45629497</td>\n",
       "      <td>-66.08483253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>820083</td>\n",
       "      <td>2018-248043-PCOC-019759</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>10/21/2021</td>\n",
       "      <td>12/6/2021</td>\n",
       "      <td>Atlantic Estates at Bahia Beach Resort</td>\n",
       "      <td>desarrollo de 32 lotes unifamiliares y un lote...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Río Grande</td>\n",
       "      <td>0</td>\n",
       "      <td>18.41608108</td>\n",
       "      <td>-65.82121611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>805077</td>\n",
       "      <td>2021-400214-PCOC-018803</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>10/7/2021</td>\n",
       "      <td>11/23/2021</td>\n",
       "      <td>PARGUERA PLAZA HOTEL</td>\n",
       "      <td>remodelacion y ampliacion de parguera plaza hotel</td>\n",
       "      <td>ing.arodzpa@yahoo.com</td>\n",
       "      <td>Lajas</td>\n",
       "      <td>0</td>\n",
       "      <td>17.97410386</td>\n",
       "      <td>-67.04964086</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>774278</td>\n",
       "      <td>2020-298040-PCOC-016789</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>7/8/2021</td>\n",
       "      <td>7/14/2021</td>\n",
       "      <td>JW Marriott Hotel &amp; Marriott Vacation Club Int...</td>\n",
       "      <td>proyecto turìstico de hotel y club vacacional ...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Vega Alta</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47407343</td>\n",
       "      <td>-66.31800413</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>91719</td>\n",
       "      <td>2015-050945-PCO-091719</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>7/22/2015</td>\n",
       "      <td>4/8/2016</td>\n",
       "      <td>Hotel Municipal Dorado</td>\n",
       "      <td>hotel que constar· de tres (3) pisos con 53 h...</td>\n",
       "      <td>permisos@dg3a.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47480101</td>\n",
       "      <td>-66.27844691</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>90644</td>\n",
       "      <td>2015-063621-PCO-090644</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>7/20/2015</td>\n",
       "      <td>7/24/2015</td>\n",
       "      <td>Beachfront Residences at Dorado Beach Resort III</td>\n",
       "      <td>construcciûn de condohotel de 14 unidades mult...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47522117</td>\n",
       "      <td>-66.30899843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>54797</td>\n",
       "      <td>2015-041888-PCO-054797</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>3/20/2015</td>\n",
       "      <td>4/1/2015</td>\n",
       "      <td>West Beach Residences IV</td>\n",
       "      <td>edificio iv de condohotel dentro de dorado bea...</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.47478574</td>\n",
       "      <td>-66.30676031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>41504</td>\n",
       "      <td>2014-005393-PCO-041504</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>2/10/2015</td>\n",
       "      <td>8/19/2015</td>\n",
       "      <td>Wyndham Rio Mar Hotel Renovation</td>\n",
       "      <td>wyndham rio mar hotel renovation</td>\n",
       "      <td>csapermitspr@csagroup.com</td>\n",
       "      <td>RÌo Grande</td>\n",
       "      <td>0</td>\n",
       "      <td>18.38452536</td>\n",
       "      <td>-65.75912802</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>41826</td>\n",
       "      <td>2014-005393-PCO-041826</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>2/13/2015</td>\n",
       "      <td>5/20/2015</td>\n",
       "      <td>Wyndham Rio Mar Hotel Renovation</td>\n",
       "      <td>wyndham rio mar hotel renovation</td>\n",
       "      <td>csapermitspr@csagroup.com</td>\n",
       "      <td>RÌo Grande</td>\n",
       "      <td>0</td>\n",
       "      <td>18.38452536</td>\n",
       "      <td>-65.75912802</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>75 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    CPT_ID                  TRÁMITE   ESTADO_TRÁMITE TIPO_TRÁMITE  \\\n",
       "0   838010  2020-298040-PCOC-020820  PERMIT_APPROVED         PCOC   \n",
       "1   822963  2021-387502-PCOC-019943  PERMIT_APPROVED         PCOC   \n",
       "2   820083  2018-248043-PCOC-019759  PERMIT_APPROVED         PCOC   \n",
       "3   805077  2021-400214-PCOC-018803  PERMIT_APPROVED         PCOC   \n",
       "4   774278  2020-298040-PCOC-016789  PERMIT_APPROVED         PCOC   \n",
       "..     ...                      ...              ...          ...   \n",
       "70   91719   2015-050945-PCO-091719  PERMIT_APPROVED          PCO   \n",
       "71   90644   2015-063621-PCO-090644  PERMIT_APPROVED          PCO   \n",
       "72   54797   2015-041888-PCO-054797  PERMIT_APPROVED          PCO   \n",
       "73   41504   2014-005393-PCO-041504  PERMIT_APPROVED          PCO   \n",
       "74   41826   2014-005393-PCO-041826  PERMIT_APPROVED          PCO   \n",
       "\n",
       "   FECHA_SOMETIDO FECHA_EXPEDIDO  \\\n",
       "0       12/1/2021      12/6/2021   \n",
       "1      10/27/2021     11/17/2021   \n",
       "2      10/21/2021      12/6/2021   \n",
       "3       10/7/2021     11/23/2021   \n",
       "4        7/8/2021      7/14/2021   \n",
       "..            ...            ...   \n",
       "70      7/22/2015       4/8/2016   \n",
       "71      7/20/2015      7/24/2015   \n",
       "72      3/20/2015       4/1/2015   \n",
       "73      2/10/2015      8/19/2015   \n",
       "74      2/13/2015      5/20/2015   \n",
       "\n",
       "                                      NOMBRE_PROYECTO  \\\n",
       "0   JW Marriott Hotel & Marriott Vacation Club Int...   \n",
       "1                                      HOTEL DON RAFA   \n",
       "2              Atlantic Estates at Bahia Beach Resort   \n",
       "3                                PARGUERA PLAZA HOTEL   \n",
       "4   JW Marriott Hotel & Marriott Vacation Club Int...   \n",
       "..                                                ...   \n",
       "70                             Hotel Municipal Dorado   \n",
       "71   Beachfront Residences at Dorado Beach Resort III   \n",
       "72                           West Beach Residences IV   \n",
       "73                   Wyndham Rio Mar Hotel Renovation   \n",
       "74                   Wyndham Rio Mar Hotel Renovation   \n",
       "\n",
       "                                 DESCRIPCIÓN_PROYECTO  \\\n",
       "0   proyecto turístico de hotel y club vacacional ...   \n",
       "1   hotel turístico con recepción en el 1er nivel,...   \n",
       "2   desarrollo de 32 lotes unifamiliares y un lote...   \n",
       "3   remodelacion y ampliacion de parguera plaza hotel   \n",
       "4   proyecto turìstico de hotel y club vacacional ...   \n",
       "..                                                ...   \n",
       "70   hotel que constar· de tres (3) pisos con 53 h...   \n",
       "71  construcciûn de condohotel de 14 unidades mult...   \n",
       "72  edificio iv de condohotel dentro de dorado bea...   \n",
       "73                   wyndham rio mar hotel renovation   \n",
       "74                   wyndham rio mar hotel renovation   \n",
       "\n",
       "                        SOLICITANTE   MUNICIPIO  CDBG_DR COORDENADAS_LAT  \\\n",
       "0                  pjaner@cmapr.com   Vega Alta        0     18.47407343   \n",
       "1   proactiveconstruction@gmail.com    San Juan        0     18.45629497   \n",
       "2                  pjaner@cmapr.com  Río Grande        0     18.41608108   \n",
       "3             ing.arodzpa@yahoo.com       Lajas        0     17.97410386   \n",
       "4                  pjaner@cmapr.com   Vega Alta        0     18.47407343   \n",
       "..                              ...         ...      ...             ...   \n",
       "70                permisos@dg3a.com      Dorado        0     18.47480101   \n",
       "71                 pjaner@cmapr.com      Dorado        0     18.47522117   \n",
       "72                 pjaner@cmapr.com      Dorado        0     18.47478574   \n",
       "73        csapermitspr@csagroup.com  RÌo Grande        0     18.38452536   \n",
       "74        csapermitspr@csagroup.com  RÌo Grande        0     18.38452536   \n",
       "\n",
       "   COORDENADAS_LON  \n",
       "0     -66.31800413  \n",
       "1     -66.08483253  \n",
       "2     -65.82121611  \n",
       "3     -67.04964086  \n",
       "4     -66.31800413  \n",
       "..             ...  \n",
       "70    -66.27844691  \n",
       "71    -66.30899843  \n",
       "72    -66.30676031  \n",
       "73    -65.75912802  \n",
       "74    -65.75912802  \n",
       "\n",
       "[75 rows x 13 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.merge.html\n",
    "\n",
    "df_merge2 = df_merge1.merge(df_turÌstico, how='outer')\n",
    "df_merge2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "84923f75",
   "metadata": {},
   "outputs": [],
   "source": [
    "# crear variables de cada palabra\n",
    "# usar merge para juntarlas todas\n",
    "# then reset index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "f6f22981",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "PERMIT_APPROVED    20117\n",
       "Name: ESTADO_TRÁMITE, dtype: int64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# All construction permits between 2012 and 2021 have been aproved.\n",
    "\n",
    "df.ESTADO_TRÁMITE.value_counts() "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3a58b294",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_merge2.to_csv(\"permisos proyecto 2 - 2012-2021.csv\",index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "37007a1d",
   "metadata": {},
   "source": [
    "# Part 3"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6db864ad",
   "metadata": {},
   "source": [
    "Categories were assigned manually to every entry from 2018 to 2021 (years after huracain María) according to the description included in the column \"DESCRIPCIÓN_PROYECTO\". In between, some entries where not considered since they are not actually developments nor renovations of importance. The year was also assigned date (FECHA) and year (AÑO). "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "2a67064a",
   "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>CPT_ID</th>\n",
       "      <th>TRAMITE</th>\n",
       "      <th>ESTADO_TRAMITE</th>\n",
       "      <th>TIPO_TRAMITE</th>\n",
       "      <th>FECHA_SOMETIDO</th>\n",
       "      <th>FECHA_EXPEDIDO</th>\n",
       "      <th>FECHA</th>\n",
       "      <th>AÑO</th>\n",
       "      <th>NOMBRE_PROYECTO</th>\n",
       "      <th>DESCRIPCION_PROYECTO</th>\n",
       "      <th>CATEGORIA</th>\n",
       "      <th>CODE_CATEGORIA</th>\n",
       "      <th>SOLICITANTE</th>\n",
       "      <th>MUNICIPIO</th>\n",
       "      <th>CDBG_DR</th>\n",
       "      <th>COORDENADAS_LAT</th>\n",
       "      <th>COORDENADAS_LON</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>838010</td>\n",
       "      <td>2020-298040-PCOC-020820</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>12/1/2021</td>\n",
       "      <td>12/6/2021</td>\n",
       "      <td>21-Dec</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>JW Marriott Hotel &amp; Marriott Vacation Club Int...</td>\n",
       "      <td>proyecto turÃ­stico de hotel y club vacacional...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Vega Alta</td>\n",
       "      <td>0</td>\n",
       "      <td>18.474073</td>\n",
       "      <td>-66.318004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>820083</td>\n",
       "      <td>2018-248043-PCOC-019759</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>10/21/2021</td>\n",
       "      <td>12/6/2021</td>\n",
       "      <td>21-Dec</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>Atlantic Estates at Bahia Beach Resort</td>\n",
       "      <td>desarrollo de 32 lotes unifamiliares y un lote...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>RÃ­o Grande</td>\n",
       "      <td>0</td>\n",
       "      <td>18.416081</td>\n",
       "      <td>-65.821216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>805077</td>\n",
       "      <td>2021-400214-PCOC-018803</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>10/7/2021</td>\n",
       "      <td>11/23/2021</td>\n",
       "      <td>21-Nov</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>PARGUERA PLAZA HOTEL</td>\n",
       "      <td>remodelacion y ampliacion de parguera plaza hotel</td>\n",
       "      <td>Expansion/ Renovating</td>\n",
       "      <td>B</td>\n",
       "      <td>ing.arodzpa@yahoo.com</td>\n",
       "      <td>Lajas</td>\n",
       "      <td>0</td>\n",
       "      <td>17.974104</td>\n",
       "      <td>-67.049641</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>822963</td>\n",
       "      <td>2021-387502-PCOC-019943</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>10/27/2021</td>\n",
       "      <td>11/17/2021</td>\n",
       "      <td>21-Nov</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>HOTEL DON RAFA</td>\n",
       "      <td>hotel turÃ­stico con recepciÃ³n en el 1er nive...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>proactiveconstruction@gmail.com</td>\n",
       "      <td>San Juan</td>\n",
       "      <td>0</td>\n",
       "      <td>18.456295</td>\n",
       "      <td>-66.084833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>754935</td>\n",
       "      <td>2018-248619-PCOC-015505</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>5/26/2021</td>\n",
       "      <td>7/16/2021</td>\n",
       "      <td>21-Jul</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>HOTEL COCO'S</td>\n",
       "      <td>hotel</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>p.robles76@yahoo.com</td>\n",
       "      <td>Fajardo</td>\n",
       "      <td>0</td>\n",
       "      <td>18.364695</td>\n",
       "      <td>-65.631988</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>41504</td>\n",
       "      <td>2014-005393-PCO-041504</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>2/10/2015</td>\n",
       "      <td>8/19/2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wyndham Rio Mar Hotel Renovation</td>\n",
       "      <td>wyndham rio mar hotel renovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>csapermitspr@csagroup.com</td>\n",
       "      <td>RÃo Grande</td>\n",
       "      <td>0</td>\n",
       "      <td>18.384525</td>\n",
       "      <td>-65.759128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>90644</td>\n",
       "      <td>2015-063621-PCO-090644</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>7/20/2015</td>\n",
       "      <td>7/24/2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Beachfront Residences at Dorado Beach Resort III</td>\n",
       "      <td>construcciÃ»n de condohotel de 14 unidades mul...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.475221</td>\n",
       "      <td>-66.308998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>80967</td>\n",
       "      <td>2014-005393-PCO-080967</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>6/17/2015</td>\n",
       "      <td>6/17/2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wyndham Rio Mar Hotel Renovation</td>\n",
       "      <td>wyndham rio mar hotel renovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>csapermitspr@csagroup.com</td>\n",
       "      <td>RÃo Grande</td>\n",
       "      <td>0</td>\n",
       "      <td>18.384525</td>\n",
       "      <td>-65.759128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>41826</td>\n",
       "      <td>2014-005393-PCO-041826</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>2/13/2015</td>\n",
       "      <td>5/20/2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wyndham Rio Mar Hotel Renovation</td>\n",
       "      <td>wyndham rio mar hotel renovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>csapermitspr@csagroup.com</td>\n",
       "      <td>RÃo Grande</td>\n",
       "      <td>0</td>\n",
       "      <td>18.384525</td>\n",
       "      <td>-65.759128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>54797</td>\n",
       "      <td>2015-041888-PCO-054797</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>3/20/2015</td>\n",
       "      <td>4/1/2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>West Beach Residences IV</td>\n",
       "      <td>edificio iv de condohotel dentro de dorado bea...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.474786</td>\n",
       "      <td>-66.306760</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>75 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    CPT_ID                  TRAMITE   ESTADO_TRAMITE TIPO_TRAMITE  \\\n",
       "0   838010  2020-298040-PCOC-020820  PERMIT_APPROVED         PCOC   \n",
       "1   820083  2018-248043-PCOC-019759  PERMIT_APPROVED         PCOC   \n",
       "2   805077  2021-400214-PCOC-018803  PERMIT_APPROVED         PCOC   \n",
       "3   822963  2021-387502-PCOC-019943  PERMIT_APPROVED         PCOC   \n",
       "4   754935  2018-248619-PCOC-015505  PERMIT_APPROVED         PCOC   \n",
       "..     ...                      ...              ...          ...   \n",
       "70   41504   2014-005393-PCO-041504  PERMIT_APPROVED          PCO   \n",
       "71   90644   2015-063621-PCO-090644  PERMIT_APPROVED          PCO   \n",
       "72   80967   2014-005393-PCO-080967  PERMIT_APPROVED          PCO   \n",
       "73   41826   2014-005393-PCO-041826  PERMIT_APPROVED          PCO   \n",
       "74   54797   2015-041888-PCO-054797  PERMIT_APPROVED          PCO   \n",
       "\n",
       "   FECHA_SOMETIDO FECHA_EXPEDIDO   FECHA     AÑO  \\\n",
       "0       12/1/2021      12/6/2021  21-Dec  2021.0   \n",
       "1      10/21/2021      12/6/2021  21-Dec  2021.0   \n",
       "2       10/7/2021     11/23/2021  21-Nov  2021.0   \n",
       "3      10/27/2021     11/17/2021  21-Nov  2021.0   \n",
       "4       5/26/2021      7/16/2021  21-Jul  2021.0   \n",
       "..            ...            ...     ...     ...   \n",
       "70      2/10/2015      8/19/2015     NaN     NaN   \n",
       "71      7/20/2015      7/24/2015     NaN     NaN   \n",
       "72      6/17/2015      6/17/2015     NaN     NaN   \n",
       "73      2/13/2015      5/20/2015     NaN     NaN   \n",
       "74      3/20/2015       4/1/2015     NaN     NaN   \n",
       "\n",
       "                                      NOMBRE_PROYECTO  \\\n",
       "0   JW Marriott Hotel & Marriott Vacation Club Int...   \n",
       "1              Atlantic Estates at Bahia Beach Resort   \n",
       "2                                PARGUERA PLAZA HOTEL   \n",
       "3                                      HOTEL DON RAFA   \n",
       "4                                        HOTEL COCO'S   \n",
       "..                                                ...   \n",
       "70                   Wyndham Rio Mar Hotel Renovation   \n",
       "71   Beachfront Residences at Dorado Beach Resort III   \n",
       "72                   Wyndham Rio Mar Hotel Renovation   \n",
       "73                   Wyndham Rio Mar Hotel Renovation   \n",
       "74                           West Beach Residences IV   \n",
       "\n",
       "                                 DESCRIPCION_PROYECTO              CATEGORIA  \\\n",
       "0   proyecto turÃ­stico de hotel y club vacacional...            Development   \n",
       "1   desarrollo de 32 lotes unifamiliares y un lote...            Development   \n",
       "2   remodelacion y ampliacion de parguera plaza hotel  Expansion/ Renovating   \n",
       "3   hotel turÃ­stico con recepciÃ³n en el 1er nive...            Development   \n",
       "4                                               hotel            Development   \n",
       "..                                                ...                    ...   \n",
       "70                   wyndham rio mar hotel renovation                    NaN   \n",
       "71  construcciÃ»n de condohotel de 14 unidades mul...                    NaN   \n",
       "72                   wyndham rio mar hotel renovation                    NaN   \n",
       "73                   wyndham rio mar hotel renovation                    NaN   \n",
       "74  edificio iv de condohotel dentro de dorado bea...                    NaN   \n",
       "\n",
       "   CODE_CATEGORIA                      SOLICITANTE    MUNICIPIO  CDBG_DR  \\\n",
       "0               A                 pjaner@cmapr.com    Vega Alta        0   \n",
       "1               A                 pjaner@cmapr.com  RÃ­o Grande        0   \n",
       "2               B            ing.arodzpa@yahoo.com        Lajas        0   \n",
       "3               A  proactiveconstruction@gmail.com     San Juan        0   \n",
       "4               A             p.robles76@yahoo.com      Fajardo        0   \n",
       "..            ...                              ...          ...      ...   \n",
       "70            NaN        csapermitspr@csagroup.com  RÃo Grande        0   \n",
       "71            NaN                 pjaner@cmapr.com       Dorado        0   \n",
       "72            NaN        csapermitspr@csagroup.com  RÃo Grande        0   \n",
       "73            NaN        csapermitspr@csagroup.com  RÃo Grande        0   \n",
       "74            NaN                 pjaner@cmapr.com       Dorado        0   \n",
       "\n",
       "    COORDENADAS_LAT  COORDENADAS_LON  \n",
       "0         18.474073       -66.318004  \n",
       "1         18.416081       -65.821216  \n",
       "2         17.974104       -67.049641  \n",
       "3         18.456295       -66.084833  \n",
       "4         18.364695       -65.631988  \n",
       "..              ...              ...  \n",
       "70        18.384525       -65.759128  \n",
       "71        18.475221       -66.308998  \n",
       "72        18.384525       -65.759128  \n",
       "73        18.384525       -65.759128  \n",
       "74        18.474786       -66.306760  \n",
       "\n",
       "[75 rows x 17 columns]"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_part3 = pd.read_csv(\"permisos proyecto 2 - 2012-2021.csv\", encoding = 'latin1')\n",
    "df_part3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "e487fdbb",
   "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>CPT_ID</th>\n",
       "      <th>TRAMITE</th>\n",
       "      <th>ESTADO_TRAMITE</th>\n",
       "      <th>TIPO_TRAMITE</th>\n",
       "      <th>FECHA_SOMETIDO</th>\n",
       "      <th>FECHA_EXPEDIDO</th>\n",
       "      <th>FECHA</th>\n",
       "      <th>AÑO</th>\n",
       "      <th>NOMBRE_PROYECTO</th>\n",
       "      <th>DESCRIPCION_PROYECTO</th>\n",
       "      <th>CATEGORIA</th>\n",
       "      <th>CODE_CATEGORIA</th>\n",
       "      <th>SOLICITANTE</th>\n",
       "      <th>MUNICIPIO</th>\n",
       "      <th>CDBG_DR</th>\n",
       "      <th>COORDENADAS_LAT</th>\n",
       "      <th>COORDENADAS_LON</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>838010</td>\n",
       "      <td>2020-298040-PCOC-020820</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>12/1/2021</td>\n",
       "      <td>12/6/2021</td>\n",
       "      <td>21-Dec</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>JW Marriott Hotel &amp; Marriott Vacation Club Int...</td>\n",
       "      <td>proyecto turÃ­stico de hotel y club vacacional...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Vega Alta</td>\n",
       "      <td>0</td>\n",
       "      <td>18.474073</td>\n",
       "      <td>-66.318004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>820083</td>\n",
       "      <td>2018-248043-PCOC-019759</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>10/21/2021</td>\n",
       "      <td>12/6/2021</td>\n",
       "      <td>21-Dec</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>Atlantic Estates at Bahia Beach Resort</td>\n",
       "      <td>desarrollo de 32 lotes unifamiliares y un lote...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>RÃ­o Grande</td>\n",
       "      <td>0</td>\n",
       "      <td>18.416081</td>\n",
       "      <td>-65.821216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>805077</td>\n",
       "      <td>2021-400214-PCOC-018803</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>10/7/2021</td>\n",
       "      <td>11/23/2021</td>\n",
       "      <td>21-Nov</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>PARGUERA PLAZA HOTEL</td>\n",
       "      <td>remodelacion y ampliacion de parguera plaza hotel</td>\n",
       "      <td>Expansion/ Renovating</td>\n",
       "      <td>B</td>\n",
       "      <td>ing.arodzpa@yahoo.com</td>\n",
       "      <td>Lajas</td>\n",
       "      <td>0</td>\n",
       "      <td>17.974104</td>\n",
       "      <td>-67.049641</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>822963</td>\n",
       "      <td>2021-387502-PCOC-019943</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>10/27/2021</td>\n",
       "      <td>11/17/2021</td>\n",
       "      <td>21-Nov</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>HOTEL DON RAFA</td>\n",
       "      <td>hotel turÃ­stico con recepciÃ³n en el 1er nive...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>proactiveconstruction@gmail.com</td>\n",
       "      <td>San Juan</td>\n",
       "      <td>0</td>\n",
       "      <td>18.456295</td>\n",
       "      <td>-66.084833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>754935</td>\n",
       "      <td>2018-248619-PCOC-015505</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>5/26/2021</td>\n",
       "      <td>7/16/2021</td>\n",
       "      <td>21-Jul</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>HOTEL COCO'S</td>\n",
       "      <td>hotel</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>p.robles76@yahoo.com</td>\n",
       "      <td>Fajardo</td>\n",
       "      <td>0</td>\n",
       "      <td>18.364695</td>\n",
       "      <td>-65.631988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>774278</td>\n",
       "      <td>2020-298040-PCOC-016789</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>7/8/2021</td>\n",
       "      <td>7/14/2021</td>\n",
       "      <td>21-Jul</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>JW Marriott Hotel &amp; Marriott Vacation Club Int...</td>\n",
       "      <td>proyecto turÃ¬stico de hotel y club vacacional...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Vega Alta</td>\n",
       "      <td>0</td>\n",
       "      <td>18.474073</td>\n",
       "      <td>-66.318004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>739894</td>\n",
       "      <td>2021-364489-PCOC-014377</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>4/27/2021</td>\n",
       "      <td>7/7/2021</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Four Points by Sheraton Caguas Real Hotel &amp; Ca...</td>\n",
       "      <td>se solicita un permiso de rotulo tipo poste qu...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>mvega1234@gmail.com</td>\n",
       "      <td>Caguas</td>\n",
       "      <td>0</td>\n",
       "      <td>18.193808</td>\n",
       "      <td>-66.052648</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>701715</td>\n",
       "      <td>2021-352689-PCOC-011978</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>2/11/2021</td>\n",
       "      <td>6/28/2021</td>\n",
       "      <td>21-Jun</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>Hampton Inn Hotel- Tower A Suites Remodeling</td>\n",
       "      <td>el hotel hampton inn estÂ· localizado en la av...</td>\n",
       "      <td>Expansion/ Renovating</td>\n",
       "      <td>B</td>\n",
       "      <td>arquitecto@vissepo.com</td>\n",
       "      <td>Carolina</td>\n",
       "      <td>0</td>\n",
       "      <td>18.441579</td>\n",
       "      <td>-66.016095</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>752237</td>\n",
       "      <td>2021-364378-PCOC-015301</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>5/20/2021</td>\n",
       "      <td>6/1/2021</td>\n",
       "      <td>21-Jun</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>TaquerÃa Orale - Terraza Hotel Aloft</td>\n",
       "      <td>mejoras a la barra/cocina existente, para crea...</td>\n",
       "      <td>Expansion/ Renovating</td>\n",
       "      <td>B</td>\n",
       "      <td>jerrymisla@hotmail.com</td>\n",
       "      <td>Ponce</td>\n",
       "      <td>0</td>\n",
       "      <td>17.997168</td>\n",
       "      <td>-66.603988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>741719</td>\n",
       "      <td>2020-298040-PCOC-014502</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>4/26/2021</td>\n",
       "      <td>5/25/2021</td>\n",
       "      <td>21-May</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>JW Marriott Hotel &amp; Marriott Vacation Club Int...</td>\n",
       "      <td>proyecto turÃ¬stico de hotel y club vacacional...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Vega Alta</td>\n",
       "      <td>0</td>\n",
       "      <td>18.474073</td>\n",
       "      <td>-66.318004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>725670</td>\n",
       "      <td>2021-364378-PCOC-013407</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>3/17/2021</td>\n",
       "      <td>4/21/2021</td>\n",
       "      <td>21-Apr</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>TaquerÃa Orale - Terraza Hotel Aloft</td>\n",
       "      <td>mejoras a la barra/cocina existente, para crea...</td>\n",
       "      <td>Expansion/ Renovating</td>\n",
       "      <td>B</td>\n",
       "      <td>jerrymisla@hotmail.com</td>\n",
       "      <td>Ponce</td>\n",
       "      <td>0</td>\n",
       "      <td>17.997168</td>\n",
       "      <td>-66.603988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>707843</td>\n",
       "      <td>2019-289961-PCOC-012341</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>2/9/2021</td>\n",
       "      <td>4/19/2021</td>\n",
       "      <td>21-Apr</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>West Point Residences &amp; Residents' Beach Club</td>\n",
       "      <td>8 edificios de condohotel con 36 unidades y ed...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.475681</td>\n",
       "      <td>-66.309850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>698885</td>\n",
       "      <td>2021-351364-PCOC-011815</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>1/18/2021</td>\n",
       "      <td>3/24/2021</td>\n",
       "      <td>21-Mar</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>DBR West Point Residences I</td>\n",
       "      <td>condohotel de ocho (8) unidades multifamiliares</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.475885</td>\n",
       "      <td>-66.309593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>576906</td>\n",
       "      <td>2019-292767-PCOC-004290</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>12/18/2019</td>\n",
       "      <td>3/18/2021</td>\n",
       "      <td>21-Mar</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>TrÃpica Beach Hotel Annex</td>\n",
       "      <td>anexo de 8 habitaciones y oficina para el trÃ»...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>jfv@hacedormaker.com</td>\n",
       "      <td>San Juan</td>\n",
       "      <td>0</td>\n",
       "      <td>18.453003</td>\n",
       "      <td>-66.057849</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>689843</td>\n",
       "      <td>2020-347274-PCOC-011292</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>12/16/2020</td>\n",
       "      <td>3/17/2021</td>\n",
       "      <td>21-Mar</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>ESJ MARE HOTEL</td>\n",
       "      <td>remodelaciÃ»n de baÃ²os, cocinas y pisos para ...</td>\n",
       "      <td>Expansion/ Renovating</td>\n",
       "      <td>B</td>\n",
       "      <td>torrealmenada@yahoo.com</td>\n",
       "      <td>Carolina</td>\n",
       "      <td>0</td>\n",
       "      <td>18.444489</td>\n",
       "      <td>-66.017334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>649968</td>\n",
       "      <td>2020-328607-PCOC-008935</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>9/16/2020</td>\n",
       "      <td>3/12/2021</td>\n",
       "      <td>21-Mar</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>Resort at Cayo Largo CHP Plant &amp; Parking Lot</td>\n",
       "      <td>construcciÃ»n de un nuevo sistema de cogenerac...</td>\n",
       "      <td>Utilities</td>\n",
       "      <td>B</td>\n",
       "      <td>permisos@uniproaep.net</td>\n",
       "      <td>Fajardo</td>\n",
       "      <td>0</td>\n",
       "      <td>18.301309</td>\n",
       "      <td>-65.635047</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>604969</td>\n",
       "      <td>2020-302739-PCOC-006129</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>4/1/2020</td>\n",
       "      <td>1/21/2021</td>\n",
       "      <td>21-Jan</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>Hotel Milano Remodeling</td>\n",
       "      <td>el proyecto consiste permiso de construccion p...</td>\n",
       "      <td>Expansion/ Renovating</td>\n",
       "      <td>B</td>\n",
       "      <td>jguillermodeya@gmail.com</td>\n",
       "      <td>San Juan</td>\n",
       "      <td>0</td>\n",
       "      <td>18.465591</td>\n",
       "      <td>-66.113830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>681747</td>\n",
       "      <td>2020-343634-PCOC-010776</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>11/26/2020</td>\n",
       "      <td>1/13/2021</td>\n",
       "      <td>21-Jan</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>Hotel Palacio Provincial</td>\n",
       "      <td>remodelaciÃ»n de edificio de tres (3) niveles ...</td>\n",
       "      <td>Expansion/ Renovating</td>\n",
       "      <td>B</td>\n",
       "      <td>eha@ehaeng.com</td>\n",
       "      <td>San Juan</td>\n",
       "      <td>0</td>\n",
       "      <td>18.465319</td>\n",
       "      <td>-66.117619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>684471</td>\n",
       "      <td>2020-298040-PCOC-010970</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>12/4/2020</td>\n",
       "      <td>12/10/2020</td>\n",
       "      <td>20-Oct</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>JW Marriott Hotel &amp; Marriott Vacation Club Int...</td>\n",
       "      <td>proyecto turÃ¬stico de hotel y club vacacional...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Vega Alta</td>\n",
       "      <td>0</td>\n",
       "      <td>18.474073</td>\n",
       "      <td>-66.318004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>649298</td>\n",
       "      <td>2020-328556-PCOC-008897</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>11/2/2020</td>\n",
       "      <td>11/20/2020</td>\n",
       "      <td>20-Nov</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>JRC International Boutique Hotel &amp; Business Ce...</td>\n",
       "      <td>hotel de 150 habitaciones, con piscina, restau...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>jerrymisla@hotmail.com</td>\n",
       "      <td>Ponce</td>\n",
       "      <td>0</td>\n",
       "      <td>17.997168</td>\n",
       "      <td>-66.603988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>677911</td>\n",
       "      <td>2019-264617-PCOC-010551</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>11/17/2020</td>\n",
       "      <td>11/17/2020</td>\n",
       "      <td>20-Nov</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>San Francisco # 405 Building Remodeling</td>\n",
       "      <td>el permiso de construcciÃ»n consiste en la rem...</td>\n",
       "      <td>Expansion/ Renovating</td>\n",
       "      <td>B</td>\n",
       "      <td>bonnin.permisos041@gmail.com</td>\n",
       "      <td>San Juan</td>\n",
       "      <td>0</td>\n",
       "      <td>18.466707</td>\n",
       "      <td>-66.112202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>668579</td>\n",
       "      <td>2020-298040-PCOC-010040</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>10/27/2020</td>\n",
       "      <td>11/13/2020</td>\n",
       "      <td>20-Nov</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>JW Marriott Hotel &amp; Marriott Vacation Club Int...</td>\n",
       "      <td>proyecto turÃ¬stico de hotel y club vacacional...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Vega Alta</td>\n",
       "      <td>0</td>\n",
       "      <td>18.474073</td>\n",
       "      <td>-66.318004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>598516</td>\n",
       "      <td>2018-248043-PCOC-005641</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>3/2/2020</td>\n",
       "      <td>9/16/2020</td>\n",
       "      <td>20-Sep</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>Atlantic Estates at Bahia Beach Resort</td>\n",
       "      <td>desarrollo de 32 lotes unifamiliares y un lote...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>RÃo Grande</td>\n",
       "      <td>0</td>\n",
       "      <td>18.416081</td>\n",
       "      <td>-65.821216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>637494</td>\n",
       "      <td>2020-313518-PCOC-008270</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>8/17/2020</td>\n",
       "      <td>9/15/2020</td>\n",
       "      <td>20-Sep</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>Remodelacion en San Francisco 312</td>\n",
       "      <td>remodelaciÃ»n del vestÃ¬bulo del hotel en la c...</td>\n",
       "      <td>Expansion/ Renovating</td>\n",
       "      <td>B</td>\n",
       "      <td>billirami@yahoo.com</td>\n",
       "      <td>San Juan</td>\n",
       "      <td>0</td>\n",
       "      <td>18.466085</td>\n",
       "      <td>-66.113413</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>607864</td>\n",
       "      <td>2019-265384-PCOC-006325</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>4/29/2020</td>\n",
       "      <td>9/11/2020</td>\n",
       "      <td>20-Sep</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>Residence Inn by Marriott</td>\n",
       "      <td>iv hospitality, llc propone la construcciÃ»n d...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>rmateo@brapr.com</td>\n",
       "      <td>Carolina</td>\n",
       "      <td>0</td>\n",
       "      <td>18.441420</td>\n",
       "      <td>-66.016358</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>587196</td>\n",
       "      <td>2020-298040-PCOC-004872</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>6/17/2020</td>\n",
       "      <td>8/5/2020</td>\n",
       "      <td>20-Aug</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>JW Marriott Hotel &amp; Marriott Vacation Club Int...</td>\n",
       "      <td>proyecto turÃ¬stico de hotel y club vacacional...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Vega Alta</td>\n",
       "      <td>0</td>\n",
       "      <td>18.474073</td>\n",
       "      <td>-66.318004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>569771</td>\n",
       "      <td>2019-277705-PCOC-003787</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>12/17/2019</td>\n",
       "      <td>8/5/2020</td>\n",
       "      <td>20-Aug</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>ConstrucciÃn de Planta de Utilidades</td>\n",
       "      <td>se propone la construcciÃ»n de una planta de u...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Vega Alta</td>\n",
       "      <td>0</td>\n",
       "      <td>18.474332</td>\n",
       "      <td>-66.320239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>622355</td>\n",
       "      <td>2019-252750-PCOC-007373</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>7/8/2020</td>\n",
       "      <td>7/13/2020</td>\n",
       "      <td>20-Jul</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>Beachfront Residences at Dorado Beach Resort V</td>\n",
       "      <td>edificio de condohotel de ocho (8) unidades re...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.475412</td>\n",
       "      <td>-66.308413</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>611039</td>\n",
       "      <td>2019-293357-PCOC-006625</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>5/26/2020</td>\n",
       "      <td>5/27/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hotel Villa CofresÃ</td>\n",
       "      <td>permiso de uso para 7 habitaciones del hotel</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>lmengineeringpr@gmail.com</td>\n",
       "      <td>RincÃn</td>\n",
       "      <td>0</td>\n",
       "      <td>18.328504</td>\n",
       "      <td>-67.250379</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>579305</td>\n",
       "      <td>2015-049937-PCOC-004435</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>2/20/2020</td>\n",
       "      <td>5/22/2020</td>\n",
       "      <td>20-May</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>Posada PeÃuelas</td>\n",
       "      <td>construcciÃ»n hotel</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>ayalarubio@mac.com</td>\n",
       "      <td>PeÃuelas</td>\n",
       "      <td>0</td>\n",
       "      <td>18.057748</td>\n",
       "      <td>-66.722283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>604691</td>\n",
       "      <td>2020-307005-PCOC-006115</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>4/23/2020</td>\n",
       "      <td>4/23/2020</td>\n",
       "      <td>20-Apr</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>Allmost Home Hotel- Bailey LLC</td>\n",
       "      <td>remodelaciÃ»n y ampliaciÃ»n de edificio existe...</td>\n",
       "      <td>Expansion/ Renovating</td>\n",
       "      <td>B</td>\n",
       "      <td>profesionalauto@aol.com</td>\n",
       "      <td>San Juan</td>\n",
       "      <td>0</td>\n",
       "      <td>18.456314</td>\n",
       "      <td>-66.073316</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>604202</td>\n",
       "      <td>2020-306782-PCOC-006067</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>3/23/2020</td>\n",
       "      <td>3/23/2020</td>\n",
       "      <td>20-Mar</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>Punta Borinquen Resort Aguadilla</td>\n",
       "      <td>hotel 92 habitaciones, salones de actividades,...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>mgyasociados@yahoo.com</td>\n",
       "      <td>Aguadilla</td>\n",
       "      <td>0</td>\n",
       "      <td>18.502391</td>\n",
       "      <td>-67.140941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>531495</td>\n",
       "      <td>2019-265384-PCOC-000861</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>8/5/2019</td>\n",
       "      <td>12/6/2019</td>\n",
       "      <td>19-Dec</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>Residence Inn by Marriott</td>\n",
       "      <td>iv hospitality, llc propone la construcciÃ»n d...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>rmateo@brapr.com</td>\n",
       "      <td>Carolina</td>\n",
       "      <td>0</td>\n",
       "      <td>18.441420</td>\n",
       "      <td>-66.016358</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>462534</td>\n",
       "      <td>2018-250373-PCO-017475</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>2/5/2019</td>\n",
       "      <td>10/18/2019</td>\n",
       "      <td>19-Oct</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>RemodelaciÃn Costa BahÃa Hotel and Conventio...</td>\n",
       "      <td>remodelaciÃ»n interior costa bahÃ¬a hotel and ...</td>\n",
       "      <td>Expansion/ Renovating</td>\n",
       "      <td>B</td>\n",
       "      <td>magnapsc@gmail.com</td>\n",
       "      <td>Guayanilla</td>\n",
       "      <td>0</td>\n",
       "      <td>18.031821</td>\n",
       "      <td>-66.797367</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>544224</td>\n",
       "      <td>2019-278811-PCOC-001855</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>8/30/2019</td>\n",
       "      <td>10/5/2019</td>\n",
       "      <td>19-Oct</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>Sheraton Puerto Rico Hotel &amp; Casino</td>\n",
       "      <td>trabajos de mejoras en el hotel existente \"she...</td>\n",
       "      <td>Expansion/ Renovating</td>\n",
       "      <td>B</td>\n",
       "      <td>permits@advfirm.com</td>\n",
       "      <td>San Juan</td>\n",
       "      <td>0</td>\n",
       "      <td>18.451457</td>\n",
       "      <td>-66.092172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>554782</td>\n",
       "      <td>2019-283119-PCOC-002705</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>10/3/2019</td>\n",
       "      <td>10/3/2019</td>\n",
       "      <td>19-Oct</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>Joe &amp; Vic Hotel &amp; Restaurant Supply</td>\n",
       "      <td>joe &amp; vic hotel &amp; restaurant supply</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>p.robles76@yahoo.com</td>\n",
       "      <td>San Juan</td>\n",
       "      <td>0</td>\n",
       "      <td>18.449018</td>\n",
       "      <td>-66.076549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>545559</td>\n",
       "      <td>2019-270406-PCOC-001981</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>9/4/2019</td>\n",
       "      <td>9/20/2019</td>\n",
       "      <td>19-Sep</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>Nuevo Generador de Electricidad de Emergencia ...</td>\n",
       "      <td>se propone la instalaciÃ»n de un generador de ...</td>\n",
       "      <td>Utilities</td>\n",
       "      <td>B</td>\n",
       "      <td>profesionalauto@aol.com</td>\n",
       "      <td>San Juan</td>\n",
       "      <td>0</td>\n",
       "      <td>18.463989</td>\n",
       "      <td>-66.112590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>522225</td>\n",
       "      <td>2019-264617-PCOC-000179</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>6/26/2019</td>\n",
       "      <td>9/20/2019</td>\n",
       "      <td>19-Sep</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>San Francisco # 405 Building Remodeling</td>\n",
       "      <td>el permiso de construcciÃ»n consiste en la rem...</td>\n",
       "      <td>Expansion/ Renovating</td>\n",
       "      <td>B</td>\n",
       "      <td>meca@miguelcalzadaarq.com</td>\n",
       "      <td>San Juan</td>\n",
       "      <td>0</td>\n",
       "      <td>18.466707</td>\n",
       "      <td>-66.112202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>522908</td>\n",
       "      <td>2019-266759-PCOC-000228</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>6/17/2019</td>\n",
       "      <td>9/13/2019</td>\n",
       "      <td>19-Sep</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>Posada del Mar La Parguera</td>\n",
       "      <td>hotel &amp; restaurante posada del mar</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>camiloalmeyda@yahoo.com</td>\n",
       "      <td>Lajas</td>\n",
       "      <td>0</td>\n",
       "      <td>17.973886</td>\n",
       "      <td>-67.051004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>530309</td>\n",
       "      <td>2019-272176-PCOC-000765</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>7/15/2019</td>\n",
       "      <td>9/6/2019</td>\n",
       "      <td>19-Sep</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>: August Sage Suites Hotel Corp.</td>\n",
       "      <td>remodelacion de hotel que fue afectado por los...</td>\n",
       "      <td>Expansion/ Renovating</td>\n",
       "      <td>B</td>\n",
       "      <td>ramon.amaury@hotmail.com</td>\n",
       "      <td>Vieques</td>\n",
       "      <td>0</td>\n",
       "      <td>18.131256</td>\n",
       "      <td>-65.462817</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    CPT_ID                  TRAMITE   ESTADO_TRAMITE TIPO_TRAMITE  \\\n",
       "0   838010  2020-298040-PCOC-020820  PERMIT_APPROVED         PCOC   \n",
       "1   820083  2018-248043-PCOC-019759  PERMIT_APPROVED         PCOC   \n",
       "2   805077  2021-400214-PCOC-018803  PERMIT_APPROVED         PCOC   \n",
       "3   822963  2021-387502-PCOC-019943  PERMIT_APPROVED         PCOC   \n",
       "4   754935  2018-248619-PCOC-015505  PERMIT_APPROVED         PCOC   \n",
       "5   774278  2020-298040-PCOC-016789  PERMIT_APPROVED         PCOC   \n",
       "6   739894  2021-364489-PCOC-014377  PERMIT_APPROVED         PCOC   \n",
       "7   701715  2021-352689-PCOC-011978  PERMIT_APPROVED         PCOC   \n",
       "8   752237  2021-364378-PCOC-015301  PERMIT_APPROVED         PCOC   \n",
       "9   741719  2020-298040-PCOC-014502  PERMIT_APPROVED         PCOC   \n",
       "10  725670  2021-364378-PCOC-013407  PERMIT_APPROVED         PCOC   \n",
       "11  707843  2019-289961-PCOC-012341  PERMIT_APPROVED         PCOC   \n",
       "12  698885  2021-351364-PCOC-011815  PERMIT_APPROVED         PCOC   \n",
       "13  576906  2019-292767-PCOC-004290  PERMIT_APPROVED         PCOC   \n",
       "14  689843  2020-347274-PCOC-011292  PERMIT_APPROVED         PCOC   \n",
       "15  649968  2020-328607-PCOC-008935  PERMIT_APPROVED         PCOC   \n",
       "16  604969  2020-302739-PCOC-006129  PERMIT_APPROVED         PCOC   \n",
       "17  681747  2020-343634-PCOC-010776  PERMIT_APPROVED         PCOC   \n",
       "18  684471  2020-298040-PCOC-010970  PERMIT_APPROVED         PCOC   \n",
       "19  649298  2020-328556-PCOC-008897  PERMIT_APPROVED         PCOC   \n",
       "20  677911  2019-264617-PCOC-010551  PERMIT_APPROVED         PCOC   \n",
       "21  668579  2020-298040-PCOC-010040  PERMIT_APPROVED         PCOC   \n",
       "22  598516  2018-248043-PCOC-005641  PERMIT_APPROVED         PCOC   \n",
       "23  637494  2020-313518-PCOC-008270  PERMIT_APPROVED         PCOC   \n",
       "24  607864  2019-265384-PCOC-006325  PERMIT_APPROVED         PCOC   \n",
       "25  587196  2020-298040-PCOC-004872  PERMIT_APPROVED         PCOC   \n",
       "26  569771  2019-277705-PCOC-003787  PERMIT_APPROVED         PCOC   \n",
       "27  622355  2019-252750-PCOC-007373  PERMIT_APPROVED         PCOC   \n",
       "28  611039  2019-293357-PCOC-006625  PERMIT_APPROVED         PCOC   \n",
       "29  579305  2015-049937-PCOC-004435  PERMIT_APPROVED         PCOC   \n",
       "30  604691  2020-307005-PCOC-006115  PERMIT_APPROVED         PCOC   \n",
       "31  604202  2020-306782-PCOC-006067  PERMIT_APPROVED         PCOC   \n",
       "32  531495  2019-265384-PCOC-000861  PERMIT_APPROVED         PCOC   \n",
       "33  462534   2018-250373-PCO-017475  PERMIT_APPROVED          PCO   \n",
       "34  544224  2019-278811-PCOC-001855  PERMIT_APPROVED         PCOC   \n",
       "35  554782  2019-283119-PCOC-002705  PERMIT_APPROVED         PCOC   \n",
       "36  545559  2019-270406-PCOC-001981  PERMIT_APPROVED         PCOC   \n",
       "37  522225  2019-264617-PCOC-000179  PERMIT_APPROVED         PCOC   \n",
       "38  522908  2019-266759-PCOC-000228  PERMIT_APPROVED         PCOC   \n",
       "39  530309  2019-272176-PCOC-000765  PERMIT_APPROVED         PCOC   \n",
       "\n",
       "   FECHA_SOMETIDO FECHA_EXPEDIDO   FECHA     AÑO  \\\n",
       "0       12/1/2021      12/6/2021  21-Dec  2021.0   \n",
       "1      10/21/2021      12/6/2021  21-Dec  2021.0   \n",
       "2       10/7/2021     11/23/2021  21-Nov  2021.0   \n",
       "3      10/27/2021     11/17/2021  21-Nov  2021.0   \n",
       "4       5/26/2021      7/16/2021  21-Jul  2021.0   \n",
       "5        7/8/2021      7/14/2021  21-Jul  2021.0   \n",
       "6       4/27/2021       7/7/2021     NaN     NaN   \n",
       "7       2/11/2021      6/28/2021  21-Jun  2021.0   \n",
       "8       5/20/2021       6/1/2021  21-Jun  2021.0   \n",
       "9       4/26/2021      5/25/2021  21-May  2021.0   \n",
       "10      3/17/2021      4/21/2021  21-Apr  2021.0   \n",
       "11       2/9/2021      4/19/2021  21-Apr  2021.0   \n",
       "12      1/18/2021      3/24/2021  21-Mar  2021.0   \n",
       "13     12/18/2019      3/18/2021  21-Mar  2021.0   \n",
       "14     12/16/2020      3/17/2021  21-Mar  2021.0   \n",
       "15      9/16/2020      3/12/2021  21-Mar  2021.0   \n",
       "16       4/1/2020      1/21/2021  21-Jan  2021.0   \n",
       "17     11/26/2020      1/13/2021  21-Jan  2021.0   \n",
       "18      12/4/2020     12/10/2020  20-Oct  2020.0   \n",
       "19      11/2/2020     11/20/2020  20-Nov  2020.0   \n",
       "20     11/17/2020     11/17/2020  20-Nov  2020.0   \n",
       "21     10/27/2020     11/13/2020  20-Nov  2020.0   \n",
       "22       3/2/2020      9/16/2020  20-Sep  2020.0   \n",
       "23      8/17/2020      9/15/2020  20-Sep  2020.0   \n",
       "24      4/29/2020      9/11/2020  20-Sep  2020.0   \n",
       "25      6/17/2020       8/5/2020  20-Aug  2020.0   \n",
       "26     12/17/2019       8/5/2020  20-Aug  2020.0   \n",
       "27       7/8/2020      7/13/2020  20-Jul  2020.0   \n",
       "28      5/26/2020      5/27/2020     NaN     NaN   \n",
       "29      2/20/2020      5/22/2020  20-May  2020.0   \n",
       "30      4/23/2020      4/23/2020  20-Apr  2020.0   \n",
       "31      3/23/2020      3/23/2020  20-Mar  2020.0   \n",
       "32       8/5/2019      12/6/2019  19-Dec  2019.0   \n",
       "33       2/5/2019     10/18/2019  19-Oct  2019.0   \n",
       "34      8/30/2019      10/5/2019  19-Oct  2019.0   \n",
       "35      10/3/2019      10/3/2019  19-Oct  2019.0   \n",
       "36       9/4/2019      9/20/2019  19-Sep  2019.0   \n",
       "37      6/26/2019      9/20/2019  19-Sep  2019.0   \n",
       "38      6/17/2019      9/13/2019  19-Sep  2019.0   \n",
       "39      7/15/2019       9/6/2019  19-Sep  2019.0   \n",
       "\n",
       "                                      NOMBRE_PROYECTO  \\\n",
       "0   JW Marriott Hotel & Marriott Vacation Club Int...   \n",
       "1              Atlantic Estates at Bahia Beach Resort   \n",
       "2                                PARGUERA PLAZA HOTEL   \n",
       "3                                      HOTEL DON RAFA   \n",
       "4                                        HOTEL COCO'S   \n",
       "5   JW Marriott Hotel & Marriott Vacation Club Int...   \n",
       "6   Four Points by Sheraton Caguas Real Hotel & Ca...   \n",
       "7        Hampton Inn Hotel- Tower A Suites Remodeling   \n",
       "8               TaquerÃa Orale - Terraza Hotel Aloft   \n",
       "9   JW Marriott Hotel & Marriott Vacation Club Int...   \n",
       "10              TaquerÃa Orale - Terraza Hotel Aloft   \n",
       "11      West Point Residences & Residents' Beach Club   \n",
       "12                        DBR West Point Residences I   \n",
       "13                         TrÃpica Beach Hotel Annex   \n",
       "14                                     ESJ MARE HOTEL   \n",
       "15       Resort at Cayo Largo CHP Plant & Parking Lot   \n",
       "16                            Hotel Milano Remodeling   \n",
       "17                           Hotel Palacio Provincial   \n",
       "18  JW Marriott Hotel & Marriott Vacation Club Int...   \n",
       "19  JRC International Boutique Hotel & Business Ce...   \n",
       "20            San Francisco # 405 Building Remodeling   \n",
       "21  JW Marriott Hotel & Marriott Vacation Club Int...   \n",
       "22             Atlantic Estates at Bahia Beach Resort   \n",
       "23                  Remodelacion en San Francisco 312   \n",
       "24                          Residence Inn by Marriott   \n",
       "25  JW Marriott Hotel & Marriott Vacation Club Int...   \n",
       "26             ConstrucciÃn de Planta de Utilidades    \n",
       "27     Beachfront Residences at Dorado Beach Resort V   \n",
       "28                               Hotel Villa CofresÃ   \n",
       "29                                   Posada PeÃuelas   \n",
       "30                  Allmost Home Hotel- Bailey LLC      \n",
       "31                   Punta Borinquen Resort Aguadilla   \n",
       "32                          Residence Inn by Marriott   \n",
       "33  RemodelaciÃn Costa BahÃa Hotel and Conventio...   \n",
       "34                Sheraton Puerto Rico Hotel & Casino   \n",
       "35                Joe & Vic Hotel & Restaurant Supply   \n",
       "36  Nuevo Generador de Electricidad de Emergencia ...   \n",
       "37            San Francisco # 405 Building Remodeling   \n",
       "38                         Posada del Mar La Parguera   \n",
       "39                   : August Sage Suites Hotel Corp.   \n",
       "\n",
       "                                 DESCRIPCION_PROYECTO              CATEGORIA  \\\n",
       "0   proyecto turÃ­stico de hotel y club vacacional...            Development   \n",
       "1   desarrollo de 32 lotes unifamiliares y un lote...            Development   \n",
       "2   remodelacion y ampliacion de parguera plaza hotel  Expansion/ Renovating   \n",
       "3   hotel turÃ­stico con recepciÃ³n en el 1er nive...            Development   \n",
       "4                                               hotel            Development   \n",
       "5   proyecto turÃ¬stico de hotel y club vacacional...            Development   \n",
       "6   se solicita un permiso de rotulo tipo poste qu...                    NaN   \n",
       "7   el hotel hampton inn estÂ· localizado en la av...  Expansion/ Renovating   \n",
       "8   mejoras a la barra/cocina existente, para crea...  Expansion/ Renovating   \n",
       "9   proyecto turÃ¬stico de hotel y club vacacional...            Development   \n",
       "10  mejoras a la barra/cocina existente, para crea...  Expansion/ Renovating   \n",
       "11  8 edificios de condohotel con 36 unidades y ed...            Development   \n",
       "12    condohotel de ocho (8) unidades multifamiliares            Development   \n",
       "13  anexo de 8 habitaciones y oficina para el trÃ»...            Development   \n",
       "14  remodelaciÃ»n de baÃ²os, cocinas y pisos para ...  Expansion/ Renovating   \n",
       "15  construcciÃ»n de un nuevo sistema de cogenerac...              Utilities   \n",
       "16  el proyecto consiste permiso de construccion p...  Expansion/ Renovating   \n",
       "17  remodelaciÃ»n de edificio de tres (3) niveles ...  Expansion/ Renovating   \n",
       "18  proyecto turÃ¬stico de hotel y club vacacional...            Development   \n",
       "19  hotel de 150 habitaciones, con piscina, restau...            Development   \n",
       "20  el permiso de construcciÃ»n consiste en la rem...  Expansion/ Renovating   \n",
       "21  proyecto turÃ¬stico de hotel y club vacacional...            Development   \n",
       "22  desarrollo de 32 lotes unifamiliares y un lote...            Development   \n",
       "23  remodelaciÃ»n del vestÃ¬bulo del hotel en la c...  Expansion/ Renovating   \n",
       "24  iv hospitality, llc propone la construcciÃ»n d...            Development   \n",
       "25  proyecto turÃ¬stico de hotel y club vacacional...            Development   \n",
       "26  se propone la construcciÃ»n de una planta de u...            Development   \n",
       "27  edificio de condohotel de ocho (8) unidades re...            Development   \n",
       "28       permiso de uso para 7 habitaciones del hotel                    NaN   \n",
       "29                                construcciÃ»n hotel            Development   \n",
       "30  remodelaciÃ»n y ampliaciÃ»n de edificio existe...  Expansion/ Renovating   \n",
       "31  hotel 92 habitaciones, salones de actividades,...            Development   \n",
       "32  iv hospitality, llc propone la construcciÃ»n d...            Development   \n",
       "33  remodelaciÃ»n interior costa bahÃ¬a hotel and ...  Expansion/ Renovating   \n",
       "34  trabajos de mejoras en el hotel existente \"she...  Expansion/ Renovating   \n",
       "35                joe & vic hotel & restaurant supply            Development   \n",
       "36  se propone la instalaciÃ»n de un generador de ...              Utilities   \n",
       "37  el permiso de construcciÃ»n consiste en la rem...  Expansion/ Renovating   \n",
       "38                 hotel & restaurante posada del mar            Development   \n",
       "39  remodelacion de hotel que fue afectado por los...  Expansion/ Renovating   \n",
       "\n",
       "   CODE_CATEGORIA                      SOLICITANTE    MUNICIPIO  CDBG_DR  \\\n",
       "0               A                 pjaner@cmapr.com    Vega Alta        0   \n",
       "1               A                 pjaner@cmapr.com  RÃ­o Grande        0   \n",
       "2               B            ing.arodzpa@yahoo.com        Lajas        0   \n",
       "3               A  proactiveconstruction@gmail.com     San Juan        0   \n",
       "4               A             p.robles76@yahoo.com      Fajardo        0   \n",
       "5               A                 pjaner@cmapr.com    Vega Alta        0   \n",
       "6             NaN              mvega1234@gmail.com       Caguas        0   \n",
       "7               B           arquitecto@vissepo.com     Carolina        0   \n",
       "8               B           jerrymisla@hotmail.com        Ponce        0   \n",
       "9               A                 pjaner@cmapr.com    Vega Alta        0   \n",
       "10              B           jerrymisla@hotmail.com        Ponce        0   \n",
       "11              A                 pjaner@cmapr.com       Dorado        0   \n",
       "12              A                 pjaner@cmapr.com       Dorado        0   \n",
       "13              A             jfv@hacedormaker.com     San Juan        0   \n",
       "14              B          torrealmenada@yahoo.com     Carolina        0   \n",
       "15              B           permisos@uniproaep.net      Fajardo        0   \n",
       "16              B         jguillermodeya@gmail.com     San Juan        0   \n",
       "17              B                   eha@ehaeng.com     San Juan        0   \n",
       "18              A                 pjaner@cmapr.com    Vega Alta        0   \n",
       "19              A           jerrymisla@hotmail.com        Ponce        0   \n",
       "20              B     bonnin.permisos041@gmail.com     San Juan        0   \n",
       "21              A                 pjaner@cmapr.com    Vega Alta        0   \n",
       "22              A                 pjaner@cmapr.com  RÃo Grande        0   \n",
       "23              B              billirami@yahoo.com     San Juan        0   \n",
       "24              A                 rmateo@brapr.com     Carolina        0   \n",
       "25              A                 pjaner@cmapr.com    Vega Alta        0   \n",
       "26              A                 pjaner@cmapr.com    Vega Alta        0   \n",
       "27              A                 pjaner@cmapr.com       Dorado        0   \n",
       "28            NaN        lmengineeringpr@gmail.com      RincÃn        0   \n",
       "29              A               ayalarubio@mac.com    PeÃuelas        0   \n",
       "30              B          profesionalauto@aol.com     San Juan        0   \n",
       "31              A           mgyasociados@yahoo.com    Aguadilla        0   \n",
       "32              A                 rmateo@brapr.com     Carolina        0   \n",
       "33              B               magnapsc@gmail.com   Guayanilla        0   \n",
       "34              B              permits@advfirm.com     San Juan        0   \n",
       "35              A             p.robles76@yahoo.com     San Juan        0   \n",
       "36              B          profesionalauto@aol.com     San Juan        0   \n",
       "37              B        meca@miguelcalzadaarq.com     San Juan        0   \n",
       "38              A          camiloalmeyda@yahoo.com        Lajas        0   \n",
       "39              B         ramon.amaury@hotmail.com      Vieques        0   \n",
       "\n",
       "    COORDENADAS_LAT  COORDENADAS_LON  \n",
       "0         18.474073       -66.318004  \n",
       "1         18.416081       -65.821216  \n",
       "2         17.974104       -67.049641  \n",
       "3         18.456295       -66.084833  \n",
       "4         18.364695       -65.631988  \n",
       "5         18.474073       -66.318004  \n",
       "6         18.193808       -66.052648  \n",
       "7         18.441579       -66.016095  \n",
       "8         17.997168       -66.603988  \n",
       "9         18.474073       -66.318004  \n",
       "10        17.997168       -66.603988  \n",
       "11        18.475681       -66.309850  \n",
       "12        18.475885       -66.309593  \n",
       "13        18.453003       -66.057849  \n",
       "14        18.444489       -66.017334  \n",
       "15        18.301309       -65.635047  \n",
       "16        18.465591       -66.113830  \n",
       "17        18.465319       -66.117619  \n",
       "18        18.474073       -66.318004  \n",
       "19        17.997168       -66.603988  \n",
       "20        18.466707       -66.112202  \n",
       "21        18.474073       -66.318004  \n",
       "22        18.416081       -65.821216  \n",
       "23        18.466085       -66.113413  \n",
       "24        18.441420       -66.016358  \n",
       "25        18.474073       -66.318004  \n",
       "26        18.474332       -66.320239  \n",
       "27        18.475412       -66.308413  \n",
       "28        18.328504       -67.250379  \n",
       "29        18.057748       -66.722283  \n",
       "30        18.456314       -66.073316  \n",
       "31        18.502391       -67.140941  \n",
       "32        18.441420       -66.016358  \n",
       "33        18.031821       -66.797367  \n",
       "34        18.451457       -66.092172  \n",
       "35        18.449018       -66.076549  \n",
       "36        18.463989       -66.112590  \n",
       "37        18.466707       -66.112202  \n",
       "38        17.973886       -67.051004  \n",
       "39        18.131256       -65.462817  "
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_part3.head(40)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "3855e927",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "CPT_ID                    int64\n",
       "TRAMITE                  object\n",
       "ESTADO_TRAMITE           object\n",
       "TIPO_TRAMITE             object\n",
       "FECHA_SOMETIDO           object\n",
       "FECHA_EXPEDIDO           object\n",
       "FECHA                    object\n",
       "AÑO                     float64\n",
       "NOMBRE_PROYECTO          object\n",
       "DESCRIPCION_PROYECTO     object\n",
       "CATEGORIA                object\n",
       "CODE_CATEGORIA           object\n",
       "SOLICITANTE              object\n",
       "MUNICIPIO                object\n",
       "CDBG_DR                   int64\n",
       "COORDENADAS_LAT         float64\n",
       "COORDENADAS_LON         float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_part3.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "a5c0bc90",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     2021.0\n",
       "1     2021.0\n",
       "2     2021.0\n",
       "3     2021.0\n",
       "4     2021.0\n",
       "       ...  \n",
       "70      <NA>\n",
       "71      <NA>\n",
       "72      <NA>\n",
       "73      <NA>\n",
       "74      <NA>\n",
       "Name: AÑO, Length: 75, dtype: string"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_part3.AÑO = df_part3.AÑO.astype('string')\n",
    "df_part3.AÑO"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "d2c6ef54",
   "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>CPT_ID</th>\n",
       "      <th>TRAMITE</th>\n",
       "      <th>ESTADO_TRAMITE</th>\n",
       "      <th>TIPO_TRAMITE</th>\n",
       "      <th>FECHA_SOMETIDO</th>\n",
       "      <th>FECHA_EXPEDIDO</th>\n",
       "      <th>FECHA</th>\n",
       "      <th>AÑO</th>\n",
       "      <th>NOMBRE_PROYECTO</th>\n",
       "      <th>DESCRIPCION_PROYECTO</th>\n",
       "      <th>CATEGORIA</th>\n",
       "      <th>CODE_CATEGORIA</th>\n",
       "      <th>SOLICITANTE</th>\n",
       "      <th>MUNICIPIO</th>\n",
       "      <th>CDBG_DR</th>\n",
       "      <th>COORDENADAS_LAT</th>\n",
       "      <th>COORDENADAS_LON</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>838010</td>\n",
       "      <td>2020-298040-PCOC-020820</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>12/1/2021</td>\n",
       "      <td>12/6/2021</td>\n",
       "      <td>21-Dec</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>JW Marriott Hotel &amp; Marriott Vacation Club Int...</td>\n",
       "      <td>proyecto turÃ­stico de hotel y club vacacional...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Vega Alta</td>\n",
       "      <td>0</td>\n",
       "      <td>18.474073</td>\n",
       "      <td>-66.318004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>820083</td>\n",
       "      <td>2018-248043-PCOC-019759</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>10/21/2021</td>\n",
       "      <td>12/6/2021</td>\n",
       "      <td>21-Dec</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>Atlantic Estates at Bahia Beach Resort</td>\n",
       "      <td>desarrollo de 32 lotes unifamiliares y un lote...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>RÃ­o Grande</td>\n",
       "      <td>0</td>\n",
       "      <td>18.416081</td>\n",
       "      <td>-65.821216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>805077</td>\n",
       "      <td>2021-400214-PCOC-018803</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>10/7/2021</td>\n",
       "      <td>11/23/2021</td>\n",
       "      <td>21-Nov</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>PARGUERA PLAZA HOTEL</td>\n",
       "      <td>remodelacion y ampliacion de parguera plaza hotel</td>\n",
       "      <td>Expansion/ Renovating</td>\n",
       "      <td>B</td>\n",
       "      <td>ing.arodzpa@yahoo.com</td>\n",
       "      <td>Lajas</td>\n",
       "      <td>0</td>\n",
       "      <td>17.974104</td>\n",
       "      <td>-67.049641</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>822963</td>\n",
       "      <td>2021-387502-PCOC-019943</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>10/27/2021</td>\n",
       "      <td>11/17/2021</td>\n",
       "      <td>21-Nov</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>HOTEL DON RAFA</td>\n",
       "      <td>hotel turÃ­stico con recepciÃ³n en el 1er nive...</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>proactiveconstruction@gmail.com</td>\n",
       "      <td>San Juan</td>\n",
       "      <td>0</td>\n",
       "      <td>18.456295</td>\n",
       "      <td>-66.084833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>754935</td>\n",
       "      <td>2018-248619-PCOC-015505</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCOC</td>\n",
       "      <td>5/26/2021</td>\n",
       "      <td>7/16/2021</td>\n",
       "      <td>21-Jul</td>\n",
       "      <td>2021.0</td>\n",
       "      <td>HOTEL COCO'S</td>\n",
       "      <td>hotel</td>\n",
       "      <td>Development</td>\n",
       "      <td>A</td>\n",
       "      <td>p.robles76@yahoo.com</td>\n",
       "      <td>Fajardo</td>\n",
       "      <td>0</td>\n",
       "      <td>18.364695</td>\n",
       "      <td>-65.631988</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>41504</td>\n",
       "      <td>2014-005393-PCO-041504</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>2/10/2015</td>\n",
       "      <td>8/19/2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>Wyndham Rio Mar Hotel Renovation</td>\n",
       "      <td>wyndham rio mar hotel renovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>csapermitspr@csagroup.com</td>\n",
       "      <td>RÃo Grande</td>\n",
       "      <td>0</td>\n",
       "      <td>18.384525</td>\n",
       "      <td>-65.759128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>90644</td>\n",
       "      <td>2015-063621-PCO-090644</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>7/20/2015</td>\n",
       "      <td>7/24/2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>Beachfront Residences at Dorado Beach Resort III</td>\n",
       "      <td>construcciÃ»n de condohotel de 14 unidades mul...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.475221</td>\n",
       "      <td>-66.308998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>80967</td>\n",
       "      <td>2014-005393-PCO-080967</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>6/17/2015</td>\n",
       "      <td>6/17/2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>Wyndham Rio Mar Hotel Renovation</td>\n",
       "      <td>wyndham rio mar hotel renovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>csapermitspr@csagroup.com</td>\n",
       "      <td>RÃo Grande</td>\n",
       "      <td>0</td>\n",
       "      <td>18.384525</td>\n",
       "      <td>-65.759128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>41826</td>\n",
       "      <td>2014-005393-PCO-041826</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>2/13/2015</td>\n",
       "      <td>5/20/2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>Wyndham Rio Mar Hotel Renovation</td>\n",
       "      <td>wyndham rio mar hotel renovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>csapermitspr@csagroup.com</td>\n",
       "      <td>RÃo Grande</td>\n",
       "      <td>0</td>\n",
       "      <td>18.384525</td>\n",
       "      <td>-65.759128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>54797</td>\n",
       "      <td>2015-041888-PCO-054797</td>\n",
       "      <td>PERMIT_APPROVED</td>\n",
       "      <td>PCO</td>\n",
       "      <td>3/20/2015</td>\n",
       "      <td>4/1/2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>West Beach Residences IV</td>\n",
       "      <td>edificio iv de condohotel dentro de dorado bea...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>pjaner@cmapr.com</td>\n",
       "      <td>Dorado</td>\n",
       "      <td>0</td>\n",
       "      <td>18.474786</td>\n",
       "      <td>-66.306760</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>75 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    CPT_ID                  TRAMITE   ESTADO_TRAMITE TIPO_TRAMITE  \\\n",
       "0   838010  2020-298040-PCOC-020820  PERMIT_APPROVED         PCOC   \n",
       "1   820083  2018-248043-PCOC-019759  PERMIT_APPROVED         PCOC   \n",
       "2   805077  2021-400214-PCOC-018803  PERMIT_APPROVED         PCOC   \n",
       "3   822963  2021-387502-PCOC-019943  PERMIT_APPROVED         PCOC   \n",
       "4   754935  2018-248619-PCOC-015505  PERMIT_APPROVED         PCOC   \n",
       "..     ...                      ...              ...          ...   \n",
       "70   41504   2014-005393-PCO-041504  PERMIT_APPROVED          PCO   \n",
       "71   90644   2015-063621-PCO-090644  PERMIT_APPROVED          PCO   \n",
       "72   80967   2014-005393-PCO-080967  PERMIT_APPROVED          PCO   \n",
       "73   41826   2014-005393-PCO-041826  PERMIT_APPROVED          PCO   \n",
       "74   54797   2015-041888-PCO-054797  PERMIT_APPROVED          PCO   \n",
       "\n",
       "   FECHA_SOMETIDO FECHA_EXPEDIDO   FECHA     AÑO  \\\n",
       "0       12/1/2021      12/6/2021  21-Dec  2021.0   \n",
       "1      10/21/2021      12/6/2021  21-Dec  2021.0   \n",
       "2       10/7/2021     11/23/2021  21-Nov  2021.0   \n",
       "3      10/27/2021     11/17/2021  21-Nov  2021.0   \n",
       "4       5/26/2021      7/16/2021  21-Jul  2021.0   \n",
       "..            ...            ...     ...     ...   \n",
       "70      2/10/2015      8/19/2015     NaN    <NA>   \n",
       "71      7/20/2015      7/24/2015     NaN    <NA>   \n",
       "72      6/17/2015      6/17/2015     NaN    <NA>   \n",
       "73      2/13/2015      5/20/2015     NaN    <NA>   \n",
       "74      3/20/2015       4/1/2015     NaN    <NA>   \n",
       "\n",
       "                                      NOMBRE_PROYECTO  \\\n",
       "0   JW Marriott Hotel & Marriott Vacation Club Int...   \n",
       "1              Atlantic Estates at Bahia Beach Resort   \n",
       "2                                PARGUERA PLAZA HOTEL   \n",
       "3                                      HOTEL DON RAFA   \n",
       "4                                        HOTEL COCO'S   \n",
       "..                                                ...   \n",
       "70                   Wyndham Rio Mar Hotel Renovation   \n",
       "71   Beachfront Residences at Dorado Beach Resort III   \n",
       "72                   Wyndham Rio Mar Hotel Renovation   \n",
       "73                   Wyndham Rio Mar Hotel Renovation   \n",
       "74                           West Beach Residences IV   \n",
       "\n",
       "                                 DESCRIPCION_PROYECTO              CATEGORIA  \\\n",
       "0   proyecto turÃ­stico de hotel y club vacacional...            Development   \n",
       "1   desarrollo de 32 lotes unifamiliares y un lote...            Development   \n",
       "2   remodelacion y ampliacion de parguera plaza hotel  Expansion/ Renovating   \n",
       "3   hotel turÃ­stico con recepciÃ³n en el 1er nive...            Development   \n",
       "4                                               hotel            Development   \n",
       "..                                                ...                    ...   \n",
       "70                   wyndham rio mar hotel renovation                    NaN   \n",
       "71  construcciÃ»n de condohotel de 14 unidades mul...                    NaN   \n",
       "72                   wyndham rio mar hotel renovation                    NaN   \n",
       "73                   wyndham rio mar hotel renovation                    NaN   \n",
       "74  edificio iv de condohotel dentro de dorado bea...                    NaN   \n",
       "\n",
       "   CODE_CATEGORIA                      SOLICITANTE    MUNICIPIO  CDBG_DR  \\\n",
       "0               A                 pjaner@cmapr.com    Vega Alta        0   \n",
       "1               A                 pjaner@cmapr.com  RÃ­o Grande        0   \n",
       "2               B            ing.arodzpa@yahoo.com        Lajas        0   \n",
       "3               A  proactiveconstruction@gmail.com     San Juan        0   \n",
       "4               A             p.robles76@yahoo.com      Fajardo        0   \n",
       "..            ...                              ...          ...      ...   \n",
       "70            NaN        csapermitspr@csagroup.com  RÃo Grande        0   \n",
       "71            NaN                 pjaner@cmapr.com       Dorado        0   \n",
       "72            NaN        csapermitspr@csagroup.com  RÃo Grande        0   \n",
       "73            NaN        csapermitspr@csagroup.com  RÃo Grande        0   \n",
       "74            NaN                 pjaner@cmapr.com       Dorado        0   \n",
       "\n",
       "    COORDENADAS_LAT  COORDENADAS_LON  \n",
       "0         18.474073       -66.318004  \n",
       "1         18.416081       -65.821216  \n",
       "2         17.974104       -67.049641  \n",
       "3         18.456295       -66.084833  \n",
       "4         18.364695       -65.631988  \n",
       "..              ...              ...  \n",
       "70        18.384525       -65.759128  \n",
       "71        18.475221       -66.308998  \n",
       "72        18.384525       -65.759128  \n",
       "73        18.384525       -65.759128  \n",
       "74        18.474786       -66.306760  \n",
       "\n",
       "[75 rows x 17 columns]"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_part3 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "8ed8995c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Development              25\n",
       "Expansion/ Renovating    25\n",
       "Utilities                 2\n",
       "Name: CATEGORIA, dtype: int64"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_part3.CATEGORIA.value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e8be5ef1",
   "metadata": {},
   "source": [
    "A code letter was assigned to map the sites on a map based on the impact to show points with different sizes:\n",
    "\n",
    "    A = Development\n",
    "    B = Expansion/ Renovating + Utilities"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "928d07a7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "B    27\n",
       "A    25\n",
       "Name: CODE_CATEGORIA, dtype: int64"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_part3[\"CODE_CATEGORIA\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "5c943c4e",
   "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></th>\n",
       "      <th>CODE_CATEGORIA</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AÑO</th>\n",
       "      <th>CODE_CATEGORIA</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2018.0</th>\n",
       "      <th>B</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2019.0</th>\n",
       "      <th>B</th>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2020.0</th>\n",
       "      <th>A</th>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2021.0</th>\n",
       "      <th>A</th>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                       CODE_CATEGORIA\n",
       "AÑO    CODE_CATEGORIA                \n",
       "2018.0 B                            5\n",
       "       A                            1\n",
       "2019.0 B                           11\n",
       "       A                            5\n",
       "2020.0 A                           10\n",
       "       B                            3\n",
       "2021.0 A                            9\n",
       "       B                            8"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_part3.groupby(\"AÑO\").CODE_CATEGORIA.value_counts().to_frame()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5312bd3c",
   "metadata": {},
   "source": [
    "filtrar para solo ver CODE_CATEGORIA == A y quienes son los desarrolladores usando SOLICITANTE y NOMBRE_PROYECTO"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "id": "8583f252",
   "metadata": {},
   "outputs": [],
   "source": [
    "CODE_A = df_part3[df_part3.CODE_CATEGORIA == 'A']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "855876a9",
   "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>NOMBRE_PROYECTO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>JW Marriott Hotel &amp; Marriott Vacation Club International Tower</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Atlantic Estates at Bahia Beach Resort</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Beachfront Residences at Dorado Beach Resort V</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Residence Inn by Marriott</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>West Point Residences &amp; Residents' Beach Club</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DBR West Point Residences I</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TrÃpica Beach Hotel Annex</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JRC International Boutique Hotel &amp; Business Center Aloft</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HOTEL COCO'S</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ConstrucciÃn de Planta de Utilidades</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HOTEL DON RAFA</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Posada PeÃuelas</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Punta Borinquen Resort Aguadilla</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Joe &amp; Vic Hotel &amp; Restaurant Supply</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Posada del Mar La Parguera</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HACIENDA BUENOS AIRES RANCH RESORT</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Puerto Del Rey (Condo-Hotel Remodeling &amp; Boat Dealership Relocation)</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    NOMBRE_PROYECTO\n",
       "JW Marriott Hotel & Marriott Vacation Club Inte...                6\n",
       "Atlantic Estates at Bahia Beach Resort                            2\n",
       "Beachfront Residences at Dorado Beach Resort V                    2\n",
       "Residence Inn by Marriott                                         2\n",
       "West Point Residences & Residents' Beach Club                     1\n",
       "DBR West Point Residences I                                       1\n",
       "TrÃpica Beach Hotel Annex                                        1\n",
       "JRC International Boutique Hotel & Business Cen...                1\n",
       "HOTEL COCO'S                                                      1\n",
       "ConstrucciÃn de Planta de Utilidades                             1\n",
       "HOTEL DON RAFA                                                    1\n",
       "Posada PeÃuelas                                                  1\n",
       "Punta Borinquen Resort Aguadilla                                  1\n",
       "Joe & Vic Hotel & Restaurant Supply                               1\n",
       "Posada del Mar La Parguera                                        1\n",
       "HACIENDA BUENOS AIRES RANCH RESORT                                1\n",
       "Puerto Del Rey (Condo-Hotel Remodeling & Boat D...                1"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "CODE_A.NOMBRE_PROYECTO.value_counts().to_frame()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}