{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_temp = pd.DataFrame({\"Fecha\":[\"01/01/2021\",\"01/01/2021\",\"01/01/2021\",\"02/01/2021\",\"02/01/2021\",\"02/01/2021\"],\n",
    "                        \"Pais\":[\"España\",\"México\",\"Venezuela\",\"España\",\"México\",\"Venezuela\"],\n",
    "                        \"Temperatura\":[20,25,28,21,None,30]})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>Fecha</th>\n",
       "      <th>Pais</th>\n",
       "      <th>Temperatura</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>01/01/2021</td>\n",
       "      <td>España</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>01/01/2021</td>\n",
       "      <td>México</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>01/01/2021</td>\n",
       "      <td>Venezuela</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>02/01/2021</td>\n",
       "      <td>España</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>02/01/2021</td>\n",
       "      <td>México</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>02/01/2021</td>\n",
       "      <td>Venezuela</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Fecha       Pais  Temperatura\n",
       "0  01/01/2021     España         20.0\n",
       "1  01/01/2021     México         25.0\n",
       "2  01/01/2021  Venezuela         28.0\n",
       "3  02/01/2021     España         21.0\n",
       "4  02/01/2021     México          NaN\n",
       "5  02/01/2021  Venezuela         30.0"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_temp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Fecha</th>\n",
       "      <th>Pais</th>\n",
       "      <th>Temperatura</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>01/01/2021</td>\n",
       "      <td>México</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>01/01/2021</td>\n",
       "      <td>Venezuela</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>02/01/2021</td>\n",
       "      <td>Venezuela</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Fecha       Pais  Temperatura\n",
       "1  01/01/2021     México         25.0\n",
       "2  01/01/2021  Venezuela         28.0\n",
       "5  02/01/2021  Venezuela         30.0"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_temp[df_temp[\"Temperatura\"]>22]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>Fecha</th>\n",
       "      <th>Pais</th>\n",
       "      <th>Temperatura</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>01/01/2021</td>\n",
       "      <td>España</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>02/01/2021</td>\n",
       "      <td>España</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Fecha    Pais  Temperatura\n",
       "0  01/01/2021  España         20.0\n",
       "3  02/01/2021  España         21.0"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_temp[df_temp[\"Pais\"]==\"España\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Fecha</th>\n",
       "      <th>Pais</th>\n",
       "      <th>Temperatura</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>01/01/2021</td>\n",
       "      <td>España</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>02/01/2021</td>\n",
       "      <td>España</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Fecha    Pais  Temperatura\n",
       "0  01/01/2021  España         20.0\n",
       "3  02/01/2021  España         21.0"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_temp[df_temp[\"Pais\"].str.match(\"España\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Fecha</th>\n",
       "      <th>Pais</th>\n",
       "      <th>Temperatura</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>02/01/2021</td>\n",
       "      <td>España</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>02/01/2021</td>\n",
       "      <td>México</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>02/01/2021</td>\n",
       "      <td>Venezuela</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Fecha       Pais  Temperatura\n",
       "3  02/01/2021     España         21.0\n",
       "4  02/01/2021     México          NaN\n",
       "5  02/01/2021  Venezuela         30.0"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_temp[df_temp[\"Fecha\"]==\"02/01/2021\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Fecha</th>\n",
       "      <th>Pais</th>\n",
       "      <th>Temperatura</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>01/01/2021</td>\n",
       "      <td>México</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Fecha    Pais  Temperatura\n",
       "1  01/01/2021  México         25.0"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_temp[(df_temp[\"Pais\"]==\"México\") & (df_temp[\"Temperatura\"].notnull())]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 6 entries, 0 to 5\n",
      "Data columns (total 3 columns):\n",
      "Fecha          6 non-null object\n",
      "Pais           6 non-null object\n",
      "Temperatura    5 non-null float64\n",
      "dtypes: float64(1), object(2)\n",
      "memory usage: 272.0+ bytes\n"
     ]
    }
   ],
   "source": [
    "df_temp.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Ejercicio"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(r'C:\\Users\\ivan_pinar\\Dropbox\\Creación de MOCs\\MOC Master Python Análisis de Datos\\Datasets\\5.8\\PEATONES_2020_mod.csv', encoding = \"ISO-8859-1\",delimiter=\";\",index_col=2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "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>FECHA</th>\n",
       "      <th>HORA</th>\n",
       "      <th>PEATONES</th>\n",
       "      <th>NÚMERO_DISTRITO</th>\n",
       "      <th>DISTRITO</th>\n",
       "      <th>NOMBRE_VIAL</th>\n",
       "      <th>NÚMERO</th>\n",
       "      <th>CÓDIGO_POSTAL</th>\n",
       "      <th>OBSERVACIONES_DIRECCION</th>\n",
       "      <th>LATITUD</th>\n",
       "      <th>LONGITUD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IDENTIFICADOR</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:00:00</td>\n",
       "      <td>497.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:15:00</td>\n",
       "      <td>244.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:30:00</td>\n",
       "      <td>179.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:45:00</td>\n",
       "      <td>174.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>1:00:00</td>\n",
       "      <td>131.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>1:15:00</td>\n",
       "      <td>95.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>1:30:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>1:45:00</td>\n",
       "      <td>175.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>2:00:00</td>\n",
       "      <td>149.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>2:15:00</td>\n",
       "      <td>126.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      FECHA     HORA  PEATONES  NÚMERO_DISTRITO DISTRITO  \\\n",
       "IDENTIFICADOR                                                              \n",
       "PERM_PEA02_PM01  01/01/2020  0:00:00     497.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  0:15:00     244.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  0:30:00     179.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  0:45:00     174.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  1:00:00     131.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  1:15:00      95.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  1:30:00       NaN              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  1:45:00     175.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  2:00:00     149.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  2:15:00     126.0              1.0   Centro   \n",
       "\n",
       "                      NOMBRE_VIAL  NÚMERO  CÓDIGO_POSTAL  \\\n",
       "IDENTIFICADOR                                              \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "\n",
       "                        OBSERVACIONES_DIRECCION     LATITUD    LONGITUD  \n",
       "IDENTIFICADOR                                                            \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba        40,0           0  "
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(288755, 11)"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2 = df[(df[\"FECHA\"]>=\"01/01/2020\") & (df[\"FECHA\"]<=\"01/05/2020\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "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>FECHA</th>\n",
       "      <th>HORA</th>\n",
       "      <th>PEATONES</th>\n",
       "      <th>NÚMERO_DISTRITO</th>\n",
       "      <th>DISTRITO</th>\n",
       "      <th>NOMBRE_VIAL</th>\n",
       "      <th>NÚMERO</th>\n",
       "      <th>CÓDIGO_POSTAL</th>\n",
       "      <th>OBSERVACIONES_DIRECCION</th>\n",
       "      <th>LATITUD</th>\n",
       "      <th>LONGITUD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IDENTIFICADOR</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:00:00</td>\n",
       "      <td>497.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:15:00</td>\n",
       "      <td>244.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:30:00</td>\n",
       "      <td>179.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:45:00</td>\n",
       "      <td>174.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>1:00:00</td>\n",
       "      <td>131.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>PERM_PEA19_PM01</td>\n",
       "      <td>01/05/2020</td>\n",
       "      <td>22:45:00</td>\n",
       "      <td>568.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Bailén</td>\n",
       "      <td>6.0</td>\n",
       "      <td>28013.0</td>\n",
       "      <td>Acera Pares Datos en prueba</td>\n",
       "      <td>40,417278</td>\n",
       "      <td>-3,713371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA19_PM01</td>\n",
       "      <td>01/05/2020</td>\n",
       "      <td>23:00:00</td>\n",
       "      <td>588.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Bailén</td>\n",
       "      <td>6.0</td>\n",
       "      <td>28013.0</td>\n",
       "      <td>Acera Pares Datos en prueba</td>\n",
       "      <td>40,417278</td>\n",
       "      <td>-3,713371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA19_PM01</td>\n",
       "      <td>01/05/2020</td>\n",
       "      <td>23:15:00</td>\n",
       "      <td>504.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Bailén</td>\n",
       "      <td>6.0</td>\n",
       "      <td>28013.0</td>\n",
       "      <td>Acera Pares Datos en prueba</td>\n",
       "      <td>40,417278</td>\n",
       "      <td>-3,713371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA19_PM01</td>\n",
       "      <td>01/05/2020</td>\n",
       "      <td>23:30:00</td>\n",
       "      <td>554.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Bailén</td>\n",
       "      <td>6.0</td>\n",
       "      <td>28013.0</td>\n",
       "      <td>Acera Pares Datos en prueba</td>\n",
       "      <td>40,417278</td>\n",
       "      <td>-3,713371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA19_PM01</td>\n",
       "      <td>01/05/2020</td>\n",
       "      <td>23:45:00</td>\n",
       "      <td>492.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Bailén</td>\n",
       "      <td>6.0</td>\n",
       "      <td>28013.0</td>\n",
       "      <td>Acera Pares Datos en prueba</td>\n",
       "      <td>40,417278</td>\n",
       "      <td>-3,713371</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7481 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      FECHA      HORA  PEATONES  NÚMERO_DISTRITO DISTRITO  \\\n",
       "IDENTIFICADOR                                                               \n",
       "PERM_PEA02_PM01  01/01/2020   0:00:00     497.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020   0:15:00     244.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020   0:30:00     179.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020   0:45:00     174.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020   1:00:00     131.0              1.0   Centro   \n",
       "...                     ...       ...       ...              ...      ...   \n",
       "PERM_PEA19_PM01  01/05/2020  22:45:00     568.0              1.0   Centro   \n",
       "PERM_PEA19_PM01  01/05/2020  23:00:00     588.0              1.0   Centro   \n",
       "PERM_PEA19_PM01  01/05/2020  23:15:00     504.0              1.0   Centro   \n",
       "PERM_PEA19_PM01  01/05/2020  23:30:00     554.0              1.0   Centro   \n",
       "PERM_PEA19_PM01  01/05/2020  23:45:00     492.0              1.0   Centro   \n",
       "\n",
       "                      NOMBRE_VIAL  NÚMERO  CÓDIGO_POSTAL  \\\n",
       "IDENTIFICADOR                                              \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "...                           ...     ...            ...   \n",
       "PERM_PEA19_PM01      Calle Bailén     6.0        28013.0   \n",
       "PERM_PEA19_PM01      Calle Bailén     6.0        28013.0   \n",
       "PERM_PEA19_PM01      Calle Bailén     6.0        28013.0   \n",
       "PERM_PEA19_PM01      Calle Bailén     6.0        28013.0   \n",
       "PERM_PEA19_PM01      Calle Bailén     6.0        28013.0   \n",
       "\n",
       "                        OBSERVACIONES_DIRECCION     LATITUD    LONGITUD  \n",
       "IDENTIFICADOR                                                            \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "...                                         ...         ...         ...  \n",
       "PERM_PEA19_PM01     Acera Pares Datos en prueba   40,417278   -3,713371  \n",
       "PERM_PEA19_PM01     Acera Pares Datos en prueba   40,417278   -3,713371  \n",
       "PERM_PEA19_PM01     Acera Pares Datos en prueba   40,417278   -3,713371  \n",
       "PERM_PEA19_PM01     Acera Pares Datos en prueba   40,417278   -3,713371  \n",
       "PERM_PEA19_PM01     Acera Pares Datos en prueba   40,417278   -3,713371  \n",
       "\n",
       "[7481 rows x 11 columns]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2 = df2[df2[\"DISTRITO\"].str.contains(\"Centro\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "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>FECHA</th>\n",
       "      <th>HORA</th>\n",
       "      <th>PEATONES</th>\n",
       "      <th>NÚMERO_DISTRITO</th>\n",
       "      <th>DISTRITO</th>\n",
       "      <th>NOMBRE_VIAL</th>\n",
       "      <th>NÚMERO</th>\n",
       "      <th>CÓDIGO_POSTAL</th>\n",
       "      <th>OBSERVACIONES_DIRECCION</th>\n",
       "      <th>LATITUD</th>\n",
       "      <th>LONGITUD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IDENTIFICADOR</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:00:00</td>\n",
       "      <td>497.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:15:00</td>\n",
       "      <td>244.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:30:00</td>\n",
       "      <td>179.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:45:00</td>\n",
       "      <td>174.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>1:00:00</td>\n",
       "      <td>131.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>PERM_PEA19_PM01</td>\n",
       "      <td>01/05/2020</td>\n",
       "      <td>22:45:00</td>\n",
       "      <td>568.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Bailén</td>\n",
       "      <td>6.0</td>\n",
       "      <td>28013.0</td>\n",
       "      <td>Acera Pares Datos en prueba</td>\n",
       "      <td>40,417278</td>\n",
       "      <td>-3,713371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA19_PM01</td>\n",
       "      <td>01/05/2020</td>\n",
       "      <td>23:00:00</td>\n",
       "      <td>588.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Bailén</td>\n",
       "      <td>6.0</td>\n",
       "      <td>28013.0</td>\n",
       "      <td>Acera Pares Datos en prueba</td>\n",
       "      <td>40,417278</td>\n",
       "      <td>-3,713371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA19_PM01</td>\n",
       "      <td>01/05/2020</td>\n",
       "      <td>23:15:00</td>\n",
       "      <td>504.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Bailén</td>\n",
       "      <td>6.0</td>\n",
       "      <td>28013.0</td>\n",
       "      <td>Acera Pares Datos en prueba</td>\n",
       "      <td>40,417278</td>\n",
       "      <td>-3,713371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA19_PM01</td>\n",
       "      <td>01/05/2020</td>\n",
       "      <td>23:30:00</td>\n",
       "      <td>554.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Bailén</td>\n",
       "      <td>6.0</td>\n",
       "      <td>28013.0</td>\n",
       "      <td>Acera Pares Datos en prueba</td>\n",
       "      <td>40,417278</td>\n",
       "      <td>-3,713371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA19_PM01</td>\n",
       "      <td>01/05/2020</td>\n",
       "      <td>23:45:00</td>\n",
       "      <td>492.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Bailén</td>\n",
       "      <td>6.0</td>\n",
       "      <td>28013.0</td>\n",
       "      <td>Acera Pares Datos en prueba</td>\n",
       "      <td>40,417278</td>\n",
       "      <td>-3,713371</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5178 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      FECHA      HORA  PEATONES  NÚMERO_DISTRITO DISTRITO  \\\n",
       "IDENTIFICADOR                                                               \n",
       "PERM_PEA02_PM01  01/01/2020   0:00:00     497.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020   0:15:00     244.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020   0:30:00     179.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020   0:45:00     174.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020   1:00:00     131.0              1.0   Centro   \n",
       "...                     ...       ...       ...              ...      ...   \n",
       "PERM_PEA19_PM01  01/05/2020  22:45:00     568.0              1.0   Centro   \n",
       "PERM_PEA19_PM01  01/05/2020  23:00:00     588.0              1.0   Centro   \n",
       "PERM_PEA19_PM01  01/05/2020  23:15:00     504.0              1.0   Centro   \n",
       "PERM_PEA19_PM01  01/05/2020  23:30:00     554.0              1.0   Centro   \n",
       "PERM_PEA19_PM01  01/05/2020  23:45:00     492.0              1.0   Centro   \n",
       "\n",
       "                      NOMBRE_VIAL  NÚMERO  CÓDIGO_POSTAL  \\\n",
       "IDENTIFICADOR                                              \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "...                           ...     ...            ...   \n",
       "PERM_PEA19_PM01      Calle Bailén     6.0        28013.0   \n",
       "PERM_PEA19_PM01      Calle Bailén     6.0        28013.0   \n",
       "PERM_PEA19_PM01      Calle Bailén     6.0        28013.0   \n",
       "PERM_PEA19_PM01      Calle Bailén     6.0        28013.0   \n",
       "PERM_PEA19_PM01      Calle Bailén     6.0        28013.0   \n",
       "\n",
       "                        OBSERVACIONES_DIRECCION     LATITUD    LONGITUD  \n",
       "IDENTIFICADOR                                                            \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "...                                         ...         ...         ...  \n",
       "PERM_PEA19_PM01     Acera Pares Datos en prueba   40,417278   -3,713371  \n",
       "PERM_PEA19_PM01     Acera Pares Datos en prueba   40,417278   -3,713371  \n",
       "PERM_PEA19_PM01     Acera Pares Datos en prueba   40,417278   -3,713371  \n",
       "PERM_PEA19_PM01     Acera Pares Datos en prueba   40,417278   -3,713371  \n",
       "PERM_PEA19_PM01     Acera Pares Datos en prueba   40,417278   -3,713371  \n",
       "\n",
       "[5178 rows x 11 columns]"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2 = df[(df[\"FECHA\"]>=\"01/01/2020\") & (df[\"FECHA\"]<=\"01/05/2020\") & (df[\"DISTRITO\"].str.contains(\"Centro\"))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "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>FECHA</th>\n",
       "      <th>HORA</th>\n",
       "      <th>PEATONES</th>\n",
       "      <th>NÚMERO_DISTRITO</th>\n",
       "      <th>DISTRITO</th>\n",
       "      <th>NOMBRE_VIAL</th>\n",
       "      <th>NÚMERO</th>\n",
       "      <th>CÓDIGO_POSTAL</th>\n",
       "      <th>OBSERVACIONES_DIRECCION</th>\n",
       "      <th>LATITUD</th>\n",
       "      <th>LONGITUD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IDENTIFICADOR</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:00:00</td>\n",
       "      <td>497.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:15:00</td>\n",
       "      <td>244.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:30:00</td>\n",
       "      <td>179.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:45:00</td>\n",
       "      <td>174.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>1:00:00</td>\n",
       "      <td>131.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>PERM_PEA19_PM01</td>\n",
       "      <td>01/05/2020</td>\n",
       "      <td>22:45:00</td>\n",
       "      <td>568.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Bailén</td>\n",
       "      <td>6.0</td>\n",
       "      <td>28013.0</td>\n",
       "      <td>Acera Pares Datos en prueba</td>\n",
       "      <td>40,417278</td>\n",
       "      <td>-3,713371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA19_PM01</td>\n",
       "      <td>01/05/2020</td>\n",
       "      <td>23:00:00</td>\n",
       "      <td>588.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Bailén</td>\n",
       "      <td>6.0</td>\n",
       "      <td>28013.0</td>\n",
       "      <td>Acera Pares Datos en prueba</td>\n",
       "      <td>40,417278</td>\n",
       "      <td>-3,713371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA19_PM01</td>\n",
       "      <td>01/05/2020</td>\n",
       "      <td>23:15:00</td>\n",
       "      <td>504.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Bailén</td>\n",
       "      <td>6.0</td>\n",
       "      <td>28013.0</td>\n",
       "      <td>Acera Pares Datos en prueba</td>\n",
       "      <td>40,417278</td>\n",
       "      <td>-3,713371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA19_PM01</td>\n",
       "      <td>01/05/2020</td>\n",
       "      <td>23:30:00</td>\n",
       "      <td>554.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Bailén</td>\n",
       "      <td>6.0</td>\n",
       "      <td>28013.0</td>\n",
       "      <td>Acera Pares Datos en prueba</td>\n",
       "      <td>40,417278</td>\n",
       "      <td>-3,713371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA19_PM01</td>\n",
       "      <td>01/05/2020</td>\n",
       "      <td>23:45:00</td>\n",
       "      <td>492.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Bailén</td>\n",
       "      <td>6.0</td>\n",
       "      <td>28013.0</td>\n",
       "      <td>Acera Pares Datos en prueba</td>\n",
       "      <td>40,417278</td>\n",
       "      <td>-3,713371</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5178 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      FECHA      HORA  PEATONES  NÚMERO_DISTRITO DISTRITO  \\\n",
       "IDENTIFICADOR                                                               \n",
       "PERM_PEA02_PM01  01/01/2020   0:00:00     497.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020   0:15:00     244.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020   0:30:00     179.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020   0:45:00     174.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020   1:00:00     131.0              1.0   Centro   \n",
       "...                     ...       ...       ...              ...      ...   \n",
       "PERM_PEA19_PM01  01/05/2020  22:45:00     568.0              1.0   Centro   \n",
       "PERM_PEA19_PM01  01/05/2020  23:00:00     588.0              1.0   Centro   \n",
       "PERM_PEA19_PM01  01/05/2020  23:15:00     504.0              1.0   Centro   \n",
       "PERM_PEA19_PM01  01/05/2020  23:30:00     554.0              1.0   Centro   \n",
       "PERM_PEA19_PM01  01/05/2020  23:45:00     492.0              1.0   Centro   \n",
       "\n",
       "                      NOMBRE_VIAL  NÚMERO  CÓDIGO_POSTAL  \\\n",
       "IDENTIFICADOR                                              \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "...                           ...     ...            ...   \n",
       "PERM_PEA19_PM01      Calle Bailén     6.0        28013.0   \n",
       "PERM_PEA19_PM01      Calle Bailén     6.0        28013.0   \n",
       "PERM_PEA19_PM01      Calle Bailén     6.0        28013.0   \n",
       "PERM_PEA19_PM01      Calle Bailén     6.0        28013.0   \n",
       "PERM_PEA19_PM01      Calle Bailén     6.0        28013.0   \n",
       "\n",
       "                        OBSERVACIONES_DIRECCION     LATITUD    LONGITUD  \n",
       "IDENTIFICADOR                                                            \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "...                                         ...         ...         ...  \n",
       "PERM_PEA19_PM01     Acera Pares Datos en prueba   40,417278   -3,713371  \n",
       "PERM_PEA19_PM01     Acera Pares Datos en prueba   40,417278   -3,713371  \n",
       "PERM_PEA19_PM01     Acera Pares Datos en prueba   40,417278   -3,713371  \n",
       "PERM_PEA19_PM01     Acera Pares Datos en prueba   40,417278   -3,713371  \n",
       "PERM_PEA19_PM01     Acera Pares Datos en prueba   40,417278   -3,713371  \n",
       "\n",
       "[5178 rows x 11 columns]"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "FECHA                      5178\n",
       "HORA                       5178\n",
       "PEATONES                   5176\n",
       "NÚMERO_DISTRITO            5178\n",
       "DISTRITO                   5178\n",
       "NOMBRE_VIAL                5178\n",
       "NÚMERO                     5178\n",
       "CÓDIGO_POSTAL              5178\n",
       "OBSERVACIONES_DIRECCION    5178\n",
       "LATITUD                    5178\n",
       "LONGITUD                   5178\n",
       "dtype: int64"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "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>FECHA</th>\n",
       "      <th>HORA</th>\n",
       "      <th>PEATONES</th>\n",
       "      <th>NÚMERO_DISTRITO</th>\n",
       "      <th>DISTRITO</th>\n",
       "      <th>NOMBRE_VIAL</th>\n",
       "      <th>NÚMERO</th>\n",
       "      <th>CÓDIGO_POSTAL</th>\n",
       "      <th>OBSERVACIONES_DIRECCION</th>\n",
       "      <th>LATITUD</th>\n",
       "      <th>LONGITUD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IDENTIFICADOR</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:00:00</td>\n",
       "      <td>497.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:15:00</td>\n",
       "      <td>244.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:30:00</td>\n",
       "      <td>179.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:45:00</td>\n",
       "      <td>174.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>1:00:00</td>\n",
       "      <td>131.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>1:15:00</td>\n",
       "      <td>95.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>1:30:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>1:45:00</td>\n",
       "      <td>175.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>2:00:00</td>\n",
       "      <td>149.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>2:15:00</td>\n",
       "      <td>126.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      FECHA     HORA  PEATONES  NÚMERO_DISTRITO DISTRITO  \\\n",
       "IDENTIFICADOR                                                              \n",
       "PERM_PEA02_PM01  01/01/2020  0:00:00     497.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  0:15:00     244.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  0:30:00     179.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  0:45:00     174.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  1:00:00     131.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  1:15:00      95.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  1:30:00       NaN              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  1:45:00     175.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  2:00:00     149.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  2:15:00     126.0              1.0   Centro   \n",
       "\n",
       "                      NOMBRE_VIAL  NÚMERO  CÓDIGO_POSTAL  \\\n",
       "IDENTIFICADOR                                              \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "\n",
       "                        OBSERVACIONES_DIRECCION     LATITUD    LONGITUD  \n",
       "IDENTIFICADOR                                                            \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba        40,0           0  "
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_interp = df2.interpolate(method ='linear', limit_direction ='forward')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "FECHA                      5178\n",
       "HORA                       5178\n",
       "PEATONES                   5178\n",
       "NÚMERO_DISTRITO            5178\n",
       "DISTRITO                   5178\n",
       "NOMBRE_VIAL                5178\n",
       "NÚMERO                     5178\n",
       "CÓDIGO_POSTAL              5178\n",
       "OBSERVACIONES_DIRECCION    5178\n",
       "LATITUD                    5178\n",
       "LONGITUD                   5178\n",
       "dtype: int64"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_interp.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "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>FECHA</th>\n",
       "      <th>HORA</th>\n",
       "      <th>PEATONES</th>\n",
       "      <th>NÚMERO_DISTRITO</th>\n",
       "      <th>DISTRITO</th>\n",
       "      <th>NOMBRE_VIAL</th>\n",
       "      <th>NÚMERO</th>\n",
       "      <th>CÓDIGO_POSTAL</th>\n",
       "      <th>OBSERVACIONES_DIRECCION</th>\n",
       "      <th>LATITUD</th>\n",
       "      <th>LONGITUD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IDENTIFICADOR</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:00:00</td>\n",
       "      <td>497.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:15:00</td>\n",
       "      <td>244.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:30:00</td>\n",
       "      <td>179.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>0:45:00</td>\n",
       "      <td>174.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>1:00:00</td>\n",
       "      <td>131.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>1:15:00</td>\n",
       "      <td>95.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>1:30:00</td>\n",
       "      <td>135.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>1:45:00</td>\n",
       "      <td>175.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>2:00:00</td>\n",
       "      <td>149.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,4220090</td>\n",
       "      <td>-3,7008917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PERM_PEA02_PM01</td>\n",
       "      <td>01/01/2020</td>\n",
       "      <td>2:15:00</td>\n",
       "      <td>126.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Calle Fuencarral</td>\n",
       "      <td>22.0</td>\n",
       "      <td>28004.0</td>\n",
       "      <td>Calle peatonal Datos en prueba</td>\n",
       "      <td>40,0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      FECHA     HORA  PEATONES  NÚMERO_DISTRITO DISTRITO  \\\n",
       "IDENTIFICADOR                                                              \n",
       "PERM_PEA02_PM01  01/01/2020  0:00:00     497.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  0:15:00     244.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  0:30:00     179.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  0:45:00     174.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  1:00:00     131.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  1:15:00      95.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  1:30:00     135.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  1:45:00     175.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  2:00:00     149.0              1.0   Centro   \n",
       "PERM_PEA02_PM01  01/01/2020  2:15:00     126.0              1.0   Centro   \n",
       "\n",
       "                      NOMBRE_VIAL  NÚMERO  CÓDIGO_POSTAL  \\\n",
       "IDENTIFICADOR                                              \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "PERM_PEA02_PM01  Calle Fuencarral    22.0        28004.0   \n",
       "\n",
       "                        OBSERVACIONES_DIRECCION     LATITUD    LONGITUD  \n",
       "IDENTIFICADOR                                                            \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba  40,4220090  -3,7008917  \n",
       "PERM_PEA02_PM01  Calle peatonal Datos en prueba        40,0           0  "
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_interp.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}