practica-3-1.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Creamos un mapa de la ciudad Zaragoza a partir de un archivo cvs\n",
    "\n",
    "## Configuración de pandas y creación de variables\n",
    "\n",
    "Crear diferentes varibles e importamos librerías para la creación del mapa\n",
    "\n",
    "Definimos las variables 'url_zrgz' y 'geo_zrgz'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "url_zrgz = 'http://www.zaragoza.es/sede/servicio/transporte/accidentalidad-trafico/accidente.csv'\n",
    "geo_zrgz = [41.649693,-0.887712]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Después instalamos la librería \"folium\" para poder crear mapas Leaflet."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Collecting folium\n",
      "  Downloading folium-0.12.1.post1-py2.py3-none-any.whl (95 kB)\n",
      "\u001b[K     |████████████████████████████████| 95 kB 1.5 MB/s eta 0:00:011\n",
      "\u001b[?25hRequirement already satisfied: jinja2>=2.9 in /usr/lib/python3/dist-packages (from folium) (2.10.1)\n",
      "Requirement already satisfied: numpy in /usr/local/lib/python3.8/dist-packages (from folium) (1.21.1)\n",
      "Collecting branca>=0.3.0\n",
      "  Downloading branca-0.5.0-py3-none-any.whl (24 kB)\n",
      "Requirement already satisfied: requests in /usr/local/lib/python3.8/dist-packages (from folium) (2.25.0)\n",
      "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.8/dist-packages (from requests->folium) (2020.6.20)\n",
      "Requirement already satisfied: idna<3,>=2.5 in /usr/lib/python3/dist-packages (from requests->folium) (2.8)\n",
      "Requirement already satisfied: chardet<4,>=3.0.2 in /usr/lib/python3/dist-packages (from requests->folium) (3.0.4)\n",
      "Requirement already satisfied: urllib3<1.27,>=1.21.1 in /usr/lib/python3/dist-packages (from requests->folium) (1.25.8)\n",
      "Installing collected packages: branca, folium\n",
      "Successfully installed branca-0.5.0 folium-0.12.1.post1\n"
     ]
    }
   ],
   "source": [
    "!pip install folium"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Importamos las librerías \"folim\" y \"panda\" y se cambia el nombre a \"panda\" como pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import folium"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Ahora creamos el mapa"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "mapa_zrgz = folium.Map(location=geo_zrgz)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Así se muestra el mapa que hemos creado"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"width:100%;\"><div style=\"position:relative;width:100%;height:0;padding-bottom:60%;\"><span style=\"color:#565656\">Make this Notebook Trusted to load map: File -> Trust Notebook</span><iframe srcdoc=\"&lt;!DOCTYPE html&gt;\n",
       "&lt;head&gt;    \n",
       "    &lt;meta http-equiv=&quot;content-type&quot; content=&quot;text/html; charset=UTF-8&quot; /&gt;\n",
       "    \n",
       "        &lt;script&gt;\n",
       "            L_NO_TOUCH = false;\n",
       "            L_DISABLE_3D = false;\n",
       "        &lt;/script&gt;\n",
       "    \n",
       "    &lt;style&gt;html, body {width: 100%;height: 100%;margin: 0;padding: 0;}&lt;/style&gt;\n",
       "    &lt;style&gt;#map {position:absolute;top:0;bottom:0;right:0;left:0;}&lt;/style&gt;\n",
       "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.6.0/dist/leaflet.js&quot;&gt;&lt;/script&gt;\n",
       "    &lt;script src=&quot;https://code.jquery.com/jquery-1.12.4.min.js&quot;&gt;&lt;/script&gt;\n",
       "    &lt;script src=&quot;https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js&quot;&gt;&lt;/script&gt;\n",
       "    &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.js&quot;&gt;&lt;/script&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.6.0/dist/leaflet.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap-theme.min.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://maxcdn.bootstrapcdn.com/font-awesome/4.6.3/css/font-awesome.min.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/gh/python-visualization/folium/folium/templates/leaflet.awesome.rotate.min.css&quot;/&gt;\n",
       "    \n",
       "            &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width,\n",
       "                initial-scale=1.0, maximum-scale=1.0, user-scalable=no&quot; /&gt;\n",
       "            &lt;style&gt;\n",
       "                #map_e9e0c6e7b964c596a45baed3dc6640e3 {\n",
       "                    position: relative;\n",
       "                    width: 100.0%;\n",
       "                    height: 100.0%;\n",
       "                    left: 0.0%;\n",
       "                    top: 0.0%;\n",
       "                }\n",
       "            &lt;/style&gt;\n",
       "        \n",
       "&lt;/head&gt;\n",
       "&lt;body&gt;    \n",
       "    \n",
       "            &lt;div class=&quot;folium-map&quot; id=&quot;map_e9e0c6e7b964c596a45baed3dc6640e3&quot; &gt;&lt;/div&gt;\n",
       "        \n",
       "&lt;/body&gt;\n",
       "&lt;script&gt;    \n",
       "    \n",
       "            var map_e9e0c6e7b964c596a45baed3dc6640e3 = L.map(\n",
       "                &quot;map_e9e0c6e7b964c596a45baed3dc6640e3&quot;,\n",
       "                {\n",
       "                    center: [41.649693, -0.887712],\n",
       "                    crs: L.CRS.EPSG3857,\n",
       "                    zoom: 10,\n",
       "                    zoomControl: true,\n",
       "                    preferCanvas: false,\n",
       "                }\n",
       "            );\n",
       "\n",
       "            \n",
       "\n",
       "        \n",
       "    \n",
       "            var tile_layer_3dc54bb90031da3c05e9b7e403959dd3 = L.tileLayer(\n",
       "                &quot;https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png&quot;,\n",
       "                {&quot;attribution&quot;: &quot;Data by \\u0026copy; \\u003ca href=\\&quot;http://openstreetmap.org\\&quot;\\u003eOpenStreetMap\\u003c/a\\u003e, under \\u003ca href=\\&quot;http://www.openstreetmap.org/copyright\\&quot;\\u003eODbL\\u003c/a\\u003e.&quot;, &quot;detectRetina&quot;: false, &quot;maxNativeZoom&quot;: 18, &quot;maxZoom&quot;: 18, &quot;minZoom&quot;: 0, &quot;noWrap&quot;: false, &quot;opacity&quot;: 1, &quot;subdomains&quot;: &quot;abc&quot;, &quot;tms&quot;: false}\n",
       "            ).addTo(map_e9e0c6e7b964c596a45baed3dc6640e3);\n",
       "        \n",
       "&lt;/script&gt;\" style=\"position:absolute;width:100%;height:100%;left:0;top:0;border:none !important;\" allowfullscreen webkitallowfullscreen mozallowfullscreen></iframe></div></div>"
      ],
      "text/plain": [
       "<folium.folium.Map at 0x7f91fc31c400>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mapa_zrgz"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Creamos un dataframe de \"pandas\" al que llamamos df_zrgz desde un archivo csv, y sus datos están marcados por un punto y coma (;)\n",
    "\n",
    "Ahora lo mostramos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>year</th>\n",
       "      <th>type</th>\n",
       "      <th>accidentType</th>\n",
       "      <th>firstAddress</th>\n",
       "      <th>secondAddress</th>\n",
       "      <th>geometry</th>\n",
       "      <th>reason</th>\n",
       "      <th>area</th>\n",
       "      <th>creationDate</th>\n",
       "      <th>daniosMateriales</th>\n",
       "      <th>falloMecanico</th>\n",
       "      <th>estadoPavimento</th>\n",
       "      <th>tipoEstadoPavimento</th>\n",
       "      <th>estadoAtmosfera</th>\n",
       "      <th>tipoEstadoAtmosfera</th>\n",
       "      <th>afectado</th>\n",
       "      <th>vehiculo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>SALIDA CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>COSTA, JOAQUIN</td>\n",
       "      <td>PERAL, ISAAC</td>\n",
       "      <td>-0.8818527060979306,41.649027473051156</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-10-09T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CADENA(MARQUES DE LA)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8645810716721081,41.661585829868585</td>\n",
       "      <td>DISTANCIA DE SEGURIDAD, no mantener</td>\n",
       "      <td>2560.0</td>\n",
       "      <td>2014-10-23T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GOMEZ AVELLANEDA, G.</td>\n",
       "      <td>CASTRO, R. (POETA)</td>\n",
       "      <td>-0.887776415002892,41.666992622958105</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>2598.0</td>\n",
       "      <td>2014-10-23T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLIS FRONTOLATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MONZON</td>\n",
       "      <td>GARCIA CONDOY, H.</td>\n",
       "      <td>-0.8825260453930127,41.62957498750602</td>\n",
       "      <td>CEDA EL PASO, no respetar prioridad de paso</td>\n",
       "      <td>2555.0</td>\n",
       "      <td>2014-10-23T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>SALIDA CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RIOJA</td>\n",
       "      <td>NAVARRA, AVENIDA DE</td>\n",
       "      <td>-0.908314757720389,41.6562121210704</td>\n",
       "      <td>PERDIDA del control por VELOCIDAD INADECUADA</td>\n",
       "      <td>2554.0</td>\n",
       "      <td>2014-10-24T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>OTRAS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MUEL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8691088511672924,41.65949772773082</td>\n",
       "      <td>Caída de ocupante en Transporte Público</td>\n",
       "      <td>2578.0</td>\n",
       "      <td>2014-10-24T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>ATROPELLO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PIGNATELLI, RAMON VIA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8880337913721866,41.633353667694024</td>\n",
       "      <td>PEATÓN cruza calz SIN PREFER. fuera de paso</td>\n",
       "      <td>2606.0</td>\n",
       "      <td>2014-10-24T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>CAIDA SOBRE CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALIERTA, AV. CESAREO</td>\n",
       "      <td>AULA, LUIS</td>\n",
       "      <td>-0.8708838775078237,41.6390382112928</td>\n",
       "      <td>INVADIR otro carril en el mismo sentido de cir...</td>\n",
       "      <td>2583.0</td>\n",
       "      <td>2014-10-24T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLIS. MARCHA ATRÁS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CERBUNA, PEDRO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8970649943808023,41.64083344974765</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>2556.0</td>\n",
       "      <td>2014-10-24T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN LATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ASALTO</td>\n",
       "      <td>COCCI, JORGE</td>\n",
       "      <td>-0.8718525605769747,41.64904657717317</td>\n",
       "      <td>INVADIR otro carril en el mismo sentido de cir...</td>\n",
       "      <td>4657.0</td>\n",
       "      <td>2013-12-20T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>OTRAS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ARAGON (CORONA DE)</td>\n",
       "      <td>SAN ANTONIO M CLARET</td>\n",
       "      <td>-0.8964627561577849,41.64322365075108</td>\n",
       "      <td>Caída de ocupante en Transporte Público</td>\n",
       "      <td>63.0</td>\n",
       "      <td>2013-12-21T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FRAGUA, LA</td>\n",
       "      <td>GASSIER, PIERRE</td>\n",
       "      <td>-0.8778095796207178,41.68753087470739</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>4780.0</td>\n",
       "      <td>2013-12-22T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>SALIDA CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PIRINEOS, AV. DE LOS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8812157329722801,41.661646612715046</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>4661.0</td>\n",
       "      <td>2013-12-22T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TORRES, CAMINO DE LAS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8762000299022707,41.6454384961757</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>4667.0</td>\n",
       "      <td>2013-12-22T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>ATROPELLO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RIOJA</td>\n",
       "      <td>NAVARRA, AVENIDA DE</td>\n",
       "      <td>-0.9089013552408617,41.65543768899759</td>\n",
       "      <td>PEATÓN cruza calz SIN PREFER. en PASO CON semá...</td>\n",
       "      <td>4664.0</td>\n",
       "      <td>2013-12-22T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ITALIA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.9004729973337304,41.65180346604993</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>4671.0</td>\n",
       "      <td>2013-12-22T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AGUSTIN, PASEO MARIA</td>\n",
       "      <td>MAYANDIA (GENERAL)</td>\n",
       "      <td>-0.8917562993466011,41.65233828238132</td>\n",
       "      <td>DISTANCIA DE SEGURIDAD, no mantener</td>\n",
       "      <td>18.0</td>\n",
       "      <td>2013-12-20T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AGUSTIN, PASEO MARIA</td>\n",
       "      <td>SANTA ANA</td>\n",
       "      <td>-0.888856043735591,41.65040494617356</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>4718.0</td>\n",
       "      <td>2013-12-23T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CASPE, AV.COMPROMISO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8629911318784169,41.645335650478316</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>4723.0</td>\n",
       "      <td>2013-12-23T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MURANO, ISLA DE AV.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8870207060655807,41.609992514227066</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-12-23T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN LATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HISPANIDAD, RONDA DE</td>\n",
       "      <td>ALIERTA, AV. CESAREO</td>\n",
       "      <td>-0.8636325074780108,41.63379905763323</td>\n",
       "      <td>PUERTA abierta incorrectamente</td>\n",
       "      <td>17.0</td>\n",
       "      <td>2013-12-23T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>CAIDA SOBRE CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ZARAGOZA LA VIEJA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8760724207544668,41.63275556609146</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>4677.0</td>\n",
       "      <td>2013-12-21T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ASIN Y PALACIOS, MIG.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.9036852209830768,41.63808926467497</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-12-17T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLIS. MARCHA ATRÁS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ZAMBRANO, M. (POETA)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8896980442453839,41.677487884305975</td>\n",
       "      <td>MARCHA ATRÁS</td>\n",
       "      <td>4783.0</td>\n",
       "      <td>2013-12-23T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>SALIDA CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALBA (DUQUE DE),PASEO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.9018264648858587,41.620591734015946</td>\n",
       "      <td>PERDIDA del control por VELOCIDAD INADECUADA</td>\n",
       "      <td>4679.0</td>\n",
       "      <td>2013-12-15T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLIS FRONTOLATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HISPANIDAD, VIA</td>\n",
       "      <td>MADRID, AVENIDA DE</td>\n",
       "      <td>-0.9187726932212442,41.64931371437485</td>\n",
       "      <td>SEMÁFORO, no respetar prioridad de paso</td>\n",
       "      <td>4773.0</td>\n",
       "      <td>2013-12-20T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN LATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PARAISO, PL.BASILIO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8855988456901538,41.646890443474554</td>\n",
       "      <td>INVADIR otro carril en el mismo sentido de cir...</td>\n",
       "      <td>4702.0</td>\n",
       "      <td>2013-12-17T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN LATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HISPANIDAD, RONDA DE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.887523212911549,41.62404668544956</td>\n",
       "      <td>PUERTA abierta incorrectamente</td>\n",
       "      <td>4701.0</td>\n",
       "      <td>2013-12-20T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN LATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SAGASTA, PASEO DE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8863120908790753,41.63964884250951</td>\n",
       "      <td>INVADIR otro carril en el mismo sentido de cir...</td>\n",
       "      <td>4700.0</td>\n",
       "      <td>2013-12-19T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN LATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CABALDOS, CAMINO DE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8689640327130923,41.638477534601776</td>\n",
       "      <td>INVADIR otro carril en el mismo sentido de cir...</td>\n",
       "      <td>4752.0</td>\n",
       "      <td>2013-12-24T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>CAIDA SOBRE CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GOYA,FCO.(PINTOR) AV.</td>\n",
       "      <td>TORRES MORALES, M.G.</td>\n",
       "      <td>-0.8900650666830714,41.64332496247496</td>\n",
       "      <td>DISTANCIA DE SEGURIDAD, no mantener</td>\n",
       "      <td>4751.0</td>\n",
       "      <td>2013-12-24T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN LATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AGUSTIN, PASEO MARIA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8918524618079099,41.65260977469196</td>\n",
       "      <td>INVADIR otro carril en el mismo sentido de cir...</td>\n",
       "      <td>4750.0</td>\n",
       "      <td>2013-12-25T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>OTRAS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RIOJA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.9104038365599549,41.65248328671194</td>\n",
       "      <td>OTRAS CAUSAS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-12-19T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLISIÓN LATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CONSTITUCION, PASEO</td>\n",
       "      <td>PARAISO, PL.BASILIO</td>\n",
       "      <td>-0.8850103896969528,41.6474034449745</td>\n",
       "      <td>INVADIR otro carril en el mismo sentido de cir...</td>\n",
       "      <td>2682.0</td>\n",
       "      <td>2014-10-24T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLIS. MARCHA ATRÁS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TORRE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8734135018983006,41.64926981833846</td>\n",
       "      <td>MARCHA ATRÁS</td>\n",
       "      <td>2626.0</td>\n",
       "      <td>2014-10-27T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ECHEGARAY Y CABALLERO</td>\n",
       "      <td>MATUTE HERVIAS,JULIAN</td>\n",
       "      <td>-0.8593239531218387,41.650740541708075</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>2605.0</td>\n",
       "      <td>2014-10-27T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLIS FRONTOLATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CABALDOS, CAMINO DE</td>\n",
       "      <td>CASTELAR, EMILIO</td>\n",
       "      <td>-0.868891092151338,41.638807389014836</td>\n",
       "      <td>INVADIR otro carril en el mismo sentido de cir...</td>\n",
       "      <td>2591.0</td>\n",
       "      <td>2014-10-25T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>ATROPELLO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALMOZARA, AV. DE LA</td>\n",
       "      <td>PUERTA DE SANCHO, AV.</td>\n",
       "      <td>-0.9008107424460443,41.66374540604866</td>\n",
       "      <td>PEATÓN cruza calz CON PREFER. en PASO  CON sem...</td>\n",
       "      <td>2610.0</td>\n",
       "      <td>2014-10-29T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLIS. MARCHA ATRÁS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OLIVAN, ALEJANDRO</td>\n",
       "      <td>BOSQUED, JOSE (MOSEN)</td>\n",
       "      <td>-0.9211220937948997,41.64886535549928</td>\n",
       "      <td>MARCHA ATRÁS</td>\n",
       "      <td>2594.0</td>\n",
       "      <td>2014-10-24T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLIS. MARCHA ATRÁS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ARRUPE, PADRE</td>\n",
       "      <td>VAZQUEZ DE MELLA</td>\n",
       "      <td>-0.9026681648170423,41.63265453864093</td>\n",
       "      <td>MARCHA ATRÁS</td>\n",
       "      <td>2596.0</td>\n",
       "      <td>2014-10-20T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLIS FRONTOLATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RUIZ PICASSO, PABLO</td>\n",
       "      <td>ZAMBRANO, M. (POETA)</td>\n",
       "      <td>-0.8893162332922886,41.67281318904247</td>\n",
       "      <td>OTRAS CAUSAS</td>\n",
       "      <td>2640.0</td>\n",
       "      <td>2014-10-29T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>ATROPELLO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CAMPOAMOR, CLARA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8890866503471749,41.66895757951277</td>\n",
       "      <td>PEATÓN cruza calz CON PREFER. en PASO  SIN sem...</td>\n",
       "      <td>2600.0</td>\n",
       "      <td>2014-10-29T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>SALIDA CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CASCAJO, CN. DEL  SJN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8439506345833918,41.71496486522088</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-10-29T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>SALIDA CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EDISON, TOMAS A</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8665477541801948,41.67007665525934</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-10-29T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CUELLAR, PASEO DE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8848493117953854,41.63484525009101</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>2604.0</td>\n",
       "      <td>2014-10-28T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLISIÓN LATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HISPANIDAD, VIA</td>\n",
       "      <td>GOMEZ LAGUNA(ALCALDE)</td>\n",
       "      <td>-0.9147014503640727,41.64060309287472</td>\n",
       "      <td>INVADIR otro carril en el mismo sentido de cir...</td>\n",
       "      <td>2624.0</td>\n",
       "      <td>2014-10-29T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PLAN, IBON DE</td>\n",
       "      <td>AEROPUERTO, CARRETERA</td>\n",
       "      <td>-0.9388159722509236,41.66210291413718</td>\n",
       "      <td>DISTANCIA DE SEGURIDAD, no mantener</td>\n",
       "      <td>2611.0</td>\n",
       "      <td>2014-10-27T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>SALIDA CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FANLO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.9157439755527074,41.63348367532985</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>2631.0</td>\n",
       "      <td>2014-10-27T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>SALIDA CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AZNAR,ADOLFO(CINEASTA</td>\n",
       "      <td>BELTRAN,J.M.(CINEASTA</td>\n",
       "      <td>-0.8869959298557372,41.67593597602368</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>4438.0</td>\n",
       "      <td>2013-12-02T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>SALIDA CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALLENDE, SALVADOR AV.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.876909940066992,41.672106692157605</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>4684.0</td>\n",
       "      <td>2013-12-05T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   id  year  \\\n",
       "0   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "1   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "2   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "3   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "4   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "5   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "6   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "7   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "8   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "9   https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "10  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "11  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "12  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "13  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "14  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "15  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "16  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "17  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "18  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "19  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "20  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "21  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "22  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "23  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "24  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "25  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "26  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "27  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "28  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "29  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "30  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "31  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "32  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "33  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "34  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "35  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "36  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "37  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "38  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "39  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "40  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "41  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "42  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "43  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "44  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "45  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "46  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "47  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "48  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "49  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "\n",
       "                   type  accidentType           firstAddress  \\\n",
       "0        SALIDA CALZADA           NaN         COSTA, JOAQUIN   \n",
       "1      COLISIÓN ALCANCE           NaN  CADENA(MARQUES DE LA)   \n",
       "2      COLISIÓN ALCANCE           NaN   GOMEZ AVELLANEDA, G.   \n",
       "3   COLIS FRONTOLATERAL           NaN                 MONZON   \n",
       "4        SALIDA CALZADA           NaN                  RIOJA   \n",
       "5                 OTRAS           NaN                   MUEL   \n",
       "6             ATROPELLO           NaN  PIGNATELLI, RAMON VIA   \n",
       "7   CAIDA SOBRE CALZADA           NaN   ALIERTA, AV. CESAREO   \n",
       "8   COLIS. MARCHA ATRÁS           NaN         CERBUNA, PEDRO   \n",
       "9      COLISIÓN LATERAL           NaN                 ASALTO   \n",
       "10                OTRAS           NaN     ARAGON (CORONA DE)   \n",
       "11     COLISIÓN ALCANCE           NaN             FRAGUA, LA   \n",
       "12       SALIDA CALZADA           NaN   PIRINEOS, AV. DE LOS   \n",
       "13     COLISIÓN ALCANCE           NaN  TORRES, CAMINO DE LAS   \n",
       "14            ATROPELLO           NaN                  RIOJA   \n",
       "15     COLISIÓN ALCANCE           NaN                 ITALIA   \n",
       "16     COLISIÓN ALCANCE           NaN   AGUSTIN, PASEO MARIA   \n",
       "17     COLISIÓN ALCANCE           NaN   AGUSTIN, PASEO MARIA   \n",
       "18     COLISIÓN ALCANCE           NaN   CASPE, AV.COMPROMISO   \n",
       "19     COLISIÓN ALCANCE           NaN    MURANO, ISLA DE AV.   \n",
       "20     COLISIÓN LATERAL           NaN   HISPANIDAD, RONDA DE   \n",
       "21  CAIDA SOBRE CALZADA           NaN      ZARAGOZA LA VIEJA   \n",
       "22     COLISIÓN ALCANCE           NaN  ASIN Y PALACIOS, MIG.   \n",
       "23  COLIS. MARCHA ATRÁS           NaN   ZAMBRANO, M. (POETA)   \n",
       "24       SALIDA CALZADA           NaN  ALBA (DUQUE DE),PASEO   \n",
       "25  COLIS FRONTOLATERAL           NaN        HISPANIDAD, VIA   \n",
       "26     COLISIÓN LATERAL           NaN    PARAISO, PL.BASILIO   \n",
       "27     COLISIÓN LATERAL           NaN   HISPANIDAD, RONDA DE   \n",
       "28     COLISIÓN LATERAL           NaN      SAGASTA, PASEO DE   \n",
       "29     COLISIÓN LATERAL           NaN    CABALDOS, CAMINO DE   \n",
       "30  CAIDA SOBRE CALZADA           NaN  GOYA,FCO.(PINTOR) AV.   \n",
       "31     COLISIÓN LATERAL           NaN   AGUSTIN, PASEO MARIA   \n",
       "32                OTRAS           NaN                  RIOJA   \n",
       "33     COLISIÓN LATERAL           NaN    CONSTITUCION, PASEO   \n",
       "34  COLIS. MARCHA ATRÁS           NaN                  TORRE   \n",
       "35     COLISIÓN ALCANCE           NaN  ECHEGARAY Y CABALLERO   \n",
       "36  COLIS FRONTOLATERAL           NaN    CABALDOS, CAMINO DE   \n",
       "37            ATROPELLO           NaN    ALMOZARA, AV. DE LA   \n",
       "38  COLIS. MARCHA ATRÁS           NaN      OLIVAN, ALEJANDRO   \n",
       "39  COLIS. MARCHA ATRÁS           NaN          ARRUPE, PADRE   \n",
       "40  COLIS FRONTOLATERAL           NaN    RUIZ PICASSO, PABLO   \n",
       "41            ATROPELLO           NaN       CAMPOAMOR, CLARA   \n",
       "42       SALIDA CALZADA           NaN  CASCAJO, CN. DEL  SJN   \n",
       "43       SALIDA CALZADA           NaN        EDISON, TOMAS A   \n",
       "44     COLISIÓN ALCANCE           NaN      CUELLAR, PASEO DE   \n",
       "45     COLISIÓN LATERAL           NaN        HISPANIDAD, VIA   \n",
       "46     COLISIÓN ALCANCE           NaN          PLAN, IBON DE   \n",
       "47       SALIDA CALZADA           NaN                  FANLO   \n",
       "48       SALIDA CALZADA           NaN  AZNAR,ADOLFO(CINEASTA   \n",
       "49       SALIDA CALZADA           NaN  ALLENDE, SALVADOR AV.   \n",
       "\n",
       "            secondAddress                                geometry  \\\n",
       "0            PERAL, ISAAC  -0.8818527060979306,41.649027473051156   \n",
       "1                     NaN  -0.8645810716721081,41.661585829868585   \n",
       "2      CASTRO, R. (POETA)   -0.887776415002892,41.666992622958105   \n",
       "3       GARCIA CONDOY, H.   -0.8825260453930127,41.62957498750602   \n",
       "4     NAVARRA, AVENIDA DE     -0.908314757720389,41.6562121210704   \n",
       "5                     NaN   -0.8691088511672924,41.65949772773082   \n",
       "6                     NaN  -0.8880337913721866,41.633353667694024   \n",
       "7              AULA, LUIS    -0.8708838775078237,41.6390382112928   \n",
       "8                     NaN   -0.8970649943808023,41.64083344974765   \n",
       "9            COCCI, JORGE   -0.8718525605769747,41.64904657717317   \n",
       "10   SAN ANTONIO M CLARET   -0.8964627561577849,41.64322365075108   \n",
       "11        GASSIER, PIERRE   -0.8778095796207178,41.68753087470739   \n",
       "12                    NaN  -0.8812157329722801,41.661646612715046   \n",
       "13                    NaN    -0.8762000299022707,41.6454384961757   \n",
       "14    NAVARRA, AVENIDA DE   -0.9089013552408617,41.65543768899759   \n",
       "15                    NaN   -0.9004729973337304,41.65180346604993   \n",
       "16     MAYANDIA (GENERAL)   -0.8917562993466011,41.65233828238132   \n",
       "17              SANTA ANA    -0.888856043735591,41.65040494617356   \n",
       "18                    NaN  -0.8629911318784169,41.645335650478316   \n",
       "19                    NaN  -0.8870207060655807,41.609992514227066   \n",
       "20   ALIERTA, AV. CESAREO   -0.8636325074780108,41.63379905763323   \n",
       "21                    NaN   -0.8760724207544668,41.63275556609146   \n",
       "22                    NaN   -0.9036852209830768,41.63808926467497   \n",
       "23                    NaN  -0.8896980442453839,41.677487884305975   \n",
       "24                    NaN  -0.9018264648858587,41.620591734015946   \n",
       "25     MADRID, AVENIDA DE   -0.9187726932212442,41.64931371437485   \n",
       "26                    NaN  -0.8855988456901538,41.646890443474554   \n",
       "27                    NaN    -0.887523212911549,41.62404668544956   \n",
       "28                    NaN   -0.8863120908790753,41.63964884250951   \n",
       "29                    NaN  -0.8689640327130923,41.638477534601776   \n",
       "30   TORRES MORALES, M.G.   -0.8900650666830714,41.64332496247496   \n",
       "31                    NaN   -0.8918524618079099,41.65260977469196   \n",
       "32                    NaN   -0.9104038365599549,41.65248328671194   \n",
       "33    PARAISO, PL.BASILIO    -0.8850103896969528,41.6474034449745   \n",
       "34                    NaN   -0.8734135018983006,41.64926981833846   \n",
       "35  MATUTE HERVIAS,JULIAN  -0.8593239531218387,41.650740541708075   \n",
       "36       CASTELAR, EMILIO   -0.868891092151338,41.638807389014836   \n",
       "37  PUERTA DE SANCHO, AV.   -0.9008107424460443,41.66374540604866   \n",
       "38  BOSQUED, JOSE (MOSEN)   -0.9211220937948997,41.64886535549928   \n",
       "39       VAZQUEZ DE MELLA   -0.9026681648170423,41.63265453864093   \n",
       "40   ZAMBRANO, M. (POETA)   -0.8893162332922886,41.67281318904247   \n",
       "41                    NaN   -0.8890866503471749,41.66895757951277   \n",
       "42                    NaN   -0.8439506345833918,41.71496486522088   \n",
       "43                    NaN   -0.8665477541801948,41.67007665525934   \n",
       "44                    NaN   -0.8848493117953854,41.63484525009101   \n",
       "45  GOMEZ LAGUNA(ALCALDE)   -0.9147014503640727,41.64060309287472   \n",
       "46  AEROPUERTO, CARRETERA   -0.9388159722509236,41.66210291413718   \n",
       "47                    NaN   -0.9157439755527074,41.63348367532985   \n",
       "48  BELTRAN,J.M.(CINEASTA   -0.8869959298557372,41.67593597602368   \n",
       "49                    NaN   -0.876909940066992,41.672106692157605   \n",
       "\n",
       "                                               reason    area  \\\n",
       "0           PERDIDA del control por FALTA de ATENCIÓN     NaN   \n",
       "1                 DISTANCIA DE SEGURIDAD, no mantener  2560.0   \n",
       "2           PERDIDA del control por FALTA de ATENCIÓN  2598.0   \n",
       "3         CEDA EL PASO, no respetar prioridad de paso  2555.0   \n",
       "4        PERDIDA del control por VELOCIDAD INADECUADA  2554.0   \n",
       "5             Caída de ocupante en Transporte Público  2578.0   \n",
       "6         PEATÓN cruza calz SIN PREFER. fuera de paso  2606.0   \n",
       "7   INVADIR otro carril en el mismo sentido de cir...  2583.0   \n",
       "8           PERDIDA del control por FALTA de ATENCIÓN  2556.0   \n",
       "9   INVADIR otro carril en el mismo sentido de cir...  4657.0   \n",
       "10            Caída de ocupante en Transporte Público    63.0   \n",
       "11          PERDIDA del control por FALTA de ATENCIÓN  4780.0   \n",
       "12          PERDIDA del control por FALTA de ATENCIÓN  4661.0   \n",
       "13          PERDIDA del control por FALTA de ATENCIÓN  4667.0   \n",
       "14  PEATÓN cruza calz SIN PREFER. en PASO CON semá...  4664.0   \n",
       "15          PERDIDA del control por FALTA de ATENCIÓN  4671.0   \n",
       "16                DISTANCIA DE SEGURIDAD, no mantener    18.0   \n",
       "17          PERDIDA del control por FALTA de ATENCIÓN  4718.0   \n",
       "18          PERDIDA del control por FALTA de ATENCIÓN  4723.0   \n",
       "19          PERDIDA del control por FALTA de ATENCIÓN     NaN   \n",
       "20                     PUERTA abierta incorrectamente    17.0   \n",
       "21          PERDIDA del control por FALTA de ATENCIÓN  4677.0   \n",
       "22          PERDIDA del control por FALTA de ATENCIÓN     NaN   \n",
       "23                                       MARCHA ATRÁS  4783.0   \n",
       "24       PERDIDA del control por VELOCIDAD INADECUADA  4679.0   \n",
       "25            SEMÁFORO, no respetar prioridad de paso  4773.0   \n",
       "26  INVADIR otro carril en el mismo sentido de cir...  4702.0   \n",
       "27                     PUERTA abierta incorrectamente  4701.0   \n",
       "28  INVADIR otro carril en el mismo sentido de cir...  4700.0   \n",
       "29  INVADIR otro carril en el mismo sentido de cir...  4752.0   \n",
       "30                DISTANCIA DE SEGURIDAD, no mantener  4751.0   \n",
       "31  INVADIR otro carril en el mismo sentido de cir...  4750.0   \n",
       "32                                       OTRAS CAUSAS     NaN   \n",
       "33  INVADIR otro carril en el mismo sentido de cir...  2682.0   \n",
       "34                                       MARCHA ATRÁS  2626.0   \n",
       "35          PERDIDA del control por FALTA de ATENCIÓN  2605.0   \n",
       "36  INVADIR otro carril en el mismo sentido de cir...  2591.0   \n",
       "37  PEATÓN cruza calz CON PREFER. en PASO  CON sem...  2610.0   \n",
       "38                                       MARCHA ATRÁS  2594.0   \n",
       "39                                       MARCHA ATRÁS  2596.0   \n",
       "40                                       OTRAS CAUSAS  2640.0   \n",
       "41  PEATÓN cruza calz CON PREFER. en PASO  SIN sem...  2600.0   \n",
       "42          PERDIDA del control por FALTA de ATENCIÓN     NaN   \n",
       "43          PERDIDA del control por FALTA de ATENCIÓN     NaN   \n",
       "44          PERDIDA del control por FALTA de ATENCIÓN  2604.0   \n",
       "45  INVADIR otro carril en el mismo sentido de cir...  2624.0   \n",
       "46                DISTANCIA DE SEGURIDAD, no mantener  2611.0   \n",
       "47          PERDIDA del control por FALTA de ATENCIÓN  2631.0   \n",
       "48          PERDIDA del control por FALTA de ATENCIÓN  4438.0   \n",
       "49          PERDIDA del control por FALTA de ATENCIÓN  4684.0   \n",
       "\n",
       "            creationDate  daniosMateriales  falloMecanico estadoPavimento  \\\n",
       "0   2014-10-09T00:00:00Z              True          False     BUEN ESTADO   \n",
       "1   2014-10-23T00:00:00Z             False          False     BUEN ESTADO   \n",
       "2   2014-10-23T00:00:00Z             False          False     BUEN ESTADO   \n",
       "3   2014-10-23T00:00:00Z             False          False     BUEN ESTADO   \n",
       "4   2014-10-24T00:00:00Z             False          False     BUEN ESTADO   \n",
       "5   2014-10-24T00:00:00Z             False          False     BUEN ESTADO   \n",
       "6   2014-10-24T00:00:00Z             False          False     BUEN ESTADO   \n",
       "7   2014-10-24T00:00:00Z             False          False     BUEN ESTADO   \n",
       "8   2014-10-24T00:00:00Z              True          False     BUEN ESTADO   \n",
       "9   2013-12-20T00:00:00Z             False          False     BUEN ESTADO   \n",
       "10  2013-12-21T00:00:00Z             False          False     BUEN ESTADO   \n",
       "11  2013-12-22T00:00:00Z              True          False     BUEN ESTADO   \n",
       "12  2013-12-22T00:00:00Z             False          False     BUEN ESTADO   \n",
       "13  2013-12-22T00:00:00Z             False          False     BUEN ESTADO   \n",
       "14  2013-12-22T00:00:00Z             False          False     BUEN ESTADO   \n",
       "15  2013-12-22T00:00:00Z              True          False     BUEN ESTADO   \n",
       "16  2013-12-20T00:00:00Z             False          False     BUEN ESTADO   \n",
       "17  2013-12-23T00:00:00Z             False          False     BUEN ESTADO   \n",
       "18  2013-12-23T00:00:00Z             False          False     BUEN ESTADO   \n",
       "19  2013-12-23T00:00:00Z              True          False     BUEN ESTADO   \n",
       "20  2013-12-23T00:00:00Z             False          False     BUEN ESTADO   \n",
       "21  2013-12-21T00:00:00Z             False          False     BUEN ESTADO   \n",
       "22  2013-12-17T00:00:00Z              True          False     BUEN ESTADO   \n",
       "23  2013-12-23T00:00:00Z              True          False     BUEN ESTADO   \n",
       "24  2013-12-15T00:00:00Z              True          False     BUEN ESTADO   \n",
       "25  2013-12-20T00:00:00Z              True          False     BUEN ESTADO   \n",
       "26  2013-12-17T00:00:00Z              True          False     BUEN ESTADO   \n",
       "27  2013-12-20T00:00:00Z              True          False     BUEN ESTADO   \n",
       "28  2013-12-19T00:00:00Z              True          False     BUEN ESTADO   \n",
       "29  2013-12-24T00:00:00Z             False          False     BUEN ESTADO   \n",
       "30  2013-12-24T00:00:00Z             False          False     BUEN ESTADO   \n",
       "31  2013-12-25T00:00:00Z             False          False     BUEN ESTADO   \n",
       "32  2013-12-19T00:00:00Z              True          False     BUEN ESTADO   \n",
       "33  2014-10-24T00:00:00Z              True          False     BUEN ESTADO   \n",
       "34  2014-10-27T00:00:00Z              True          False     BUEN ESTADO   \n",
       "35  2014-10-27T00:00:00Z              True          False     BUEN ESTADO   \n",
       "36  2014-10-25T00:00:00Z              True          False     BUEN ESTADO   \n",
       "37  2014-10-29T00:00:00Z             False          False     BUEN ESTADO   \n",
       "38  2014-10-24T00:00:00Z              True          False     BUEN ESTADO   \n",
       "39  2014-10-20T00:00:00Z              True          False     BUEN ESTADO   \n",
       "40  2014-10-29T00:00:00Z             False          False     BUEN ESTADO   \n",
       "41  2014-10-29T00:00:00Z             False          False     BUEN ESTADO   \n",
       "42  2014-10-29T00:00:00Z             False          False     BUEN ESTADO   \n",
       "43  2014-10-29T00:00:00Z              True          False     BUEN ESTADO   \n",
       "44  2014-10-28T00:00:00Z              True          False     BUEN ESTADO   \n",
       "45  2014-10-29T00:00:00Z              True          False     BUEN ESTADO   \n",
       "46  2014-10-27T00:00:00Z              True          False     BUEN ESTADO   \n",
       "47  2014-10-27T00:00:00Z              True          False     BUEN ESTADO   \n",
       "48  2013-12-02T00:00:00Z              True          False     BUEN ESTADO   \n",
       "49  2013-12-05T00:00:00Z              True          False     BUEN ESTADO   \n",
       "\n",
       "    tipoEstadoPavimento estadoAtmosfera  tipoEstadoAtmosfera  \\\n",
       "0                   NaN     BUEN ESTADO                  NaN   \n",
       "1                   NaN     BUEN ESTADO                  NaN   \n",
       "2                   NaN     BUEN ESTADO                  NaN   \n",
       "3                   NaN     BUEN ESTADO                  NaN   \n",
       "4                   NaN     BUEN ESTADO                  NaN   \n",
       "5                   NaN     BUEN ESTADO                  NaN   \n",
       "6                   NaN     BUEN ESTADO                  NaN   \n",
       "7                   NaN     BUEN ESTADO                  NaN   \n",
       "8                   NaN     BUEN ESTADO                  NaN   \n",
       "9                   NaN     BUEN ESTADO                  NaN   \n",
       "10                  NaN     BUEN ESTADO                  NaN   \n",
       "11                  NaN     BUEN ESTADO                  NaN   \n",
       "12                  NaN     BUEN ESTADO                  NaN   \n",
       "13                  NaN     BUEN ESTADO                  NaN   \n",
       "14                  NaN     BUEN ESTADO                  NaN   \n",
       "15                  NaN     BUEN ESTADO                  NaN   \n",
       "16                  NaN     BUEN ESTADO                  NaN   \n",
       "17                  NaN     BUEN ESTADO                  NaN   \n",
       "18                  NaN     BUEN ESTADO                  NaN   \n",
       "19                  NaN     BUEN ESTADO                  NaN   \n",
       "20                  NaN     BUEN ESTADO                  NaN   \n",
       "21                  NaN     BUEN ESTADO                  NaN   \n",
       "22                  NaN     BUEN ESTADO                  NaN   \n",
       "23                  NaN     BUEN ESTADO                  NaN   \n",
       "24                  NaN     BUEN ESTADO                  NaN   \n",
       "25                  NaN     BUEN ESTADO                  NaN   \n",
       "26                  NaN     BUEN ESTADO                  NaN   \n",
       "27                  NaN     BUEN ESTADO                  NaN   \n",
       "28                  NaN     BUEN ESTADO                  NaN   \n",
       "29                  NaN     BUEN ESTADO                  NaN   \n",
       "30                  NaN     BUEN ESTADO                  NaN   \n",
       "31                  NaN     BUEN ESTADO                  NaN   \n",
       "32                  NaN     BUEN ESTADO                  NaN   \n",
       "33                  NaN     BUEN ESTADO                  NaN   \n",
       "34                  NaN     BUEN ESTADO                  NaN   \n",
       "35                  NaN     BUEN ESTADO                  NaN   \n",
       "36                  NaN     BUEN ESTADO                  NaN   \n",
       "37                  NaN     BUEN ESTADO                  NaN   \n",
       "38                  NaN     BUEN ESTADO                  NaN   \n",
       "39                  NaN     BUEN ESTADO                  NaN   \n",
       "40                  NaN     BUEN ESTADO                  NaN   \n",
       "41                  NaN     BUEN ESTADO                  NaN   \n",
       "42                  NaN     BUEN ESTADO                  NaN   \n",
       "43                  NaN     BUEN ESTADO                  NaN   \n",
       "44                  NaN     BUEN ESTADO                  NaN   \n",
       "45                  NaN     BUEN ESTADO                  NaN   \n",
       "46                  NaN     BUEN ESTADO                  NaN   \n",
       "47                  NaN     BUEN ESTADO                  NaN   \n",
       "48                  NaN     BUEN ESTADO                  NaN   \n",
       "49                  NaN     BUEN ESTADO                  NaN   \n",
       "\n",
       "                                             afectado  \\\n",
       "0                                                 NaN   \n",
       "1   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "2   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "3   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "4   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "5   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "6   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "7   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "8                                                 NaN   \n",
       "9   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "10  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "11                                                NaN   \n",
       "12  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "13  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "14  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "15                                                NaN   \n",
       "16  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "17  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "18  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "19                                                NaN   \n",
       "20  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "21  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "22                                                NaN   \n",
       "23                                                NaN   \n",
       "24                                                NaN   \n",
       "25                                                NaN   \n",
       "26                                                NaN   \n",
       "27                                                NaN   \n",
       "28                                                NaN   \n",
       "29  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "30  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "31  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "32                                                NaN   \n",
       "33                                                NaN   \n",
       "34                                                NaN   \n",
       "35                                                NaN   \n",
       "36                                                NaN   \n",
       "37  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "38                                                NaN   \n",
       "39                                                NaN   \n",
       "40  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "41  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "42  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "43                                                NaN   \n",
       "44                                                NaN   \n",
       "45                                                NaN   \n",
       "46                                                NaN   \n",
       "47                                                NaN   \n",
       "48                                                NaN   \n",
       "49                                                NaN   \n",
       "\n",
       "                                             vehiculo  \n",
       "0   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "1   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "2   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "3   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "4   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "5   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "6   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "7   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "8   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "9   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "10  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "11  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "12  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "13  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "14  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "15  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "16  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "17  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "18  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "19  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "20  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "21  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "22  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "23  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "24  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "25  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "26  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "27  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "28  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "29  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "30  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "31  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "32  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "33  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "34  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "35  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "36  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "37  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "38  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "39  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "40  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "41  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "42  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "43  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "44  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "45  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "46  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "47  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "48  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "49  https://www.zaragoza.es/sede/servicio/transpor...  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz = pd.read_csv(url_zrgz,delimiter=';')\n",
    "df_zrgz"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Así se enseña el nombre de las columnas de la tabla:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['id', 'year', 'type', 'accidentType', 'firstAddress', 'secondAddress',\n",
       "       'geometry', 'reason', 'area', 'creationDate', 'daniosMateriales',\n",
       "       'falloMecanico', 'estadoPavimento', 'tipoEstadoPavimento',\n",
       "       'estadoAtmosfera', 'tipoEstadoAtmosfera', 'afectado', 'vehiculo'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Enseñamos la información proporcionada por la tabla como objeto de pandas\n",
    "\n",
    "Enseña la información acerca del dataframe en la que se incluye el índice (RangeIndex) con el número de entradas, el número de columnas que hay (Data Columns), el nombre de las columnas (Colum), la cantidad de datos nulos que tiene la tabla (Non-Null Count), el tipo de variable de las columnas (Dtype) y el tamaño de estas (memory usage)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 50 entries, 0 to 49\n",
      "Data columns (total 18 columns):\n",
      " #   Column               Non-Null Count  Dtype  \n",
      "---  ------               --------------  -----  \n",
      " 0   id                   50 non-null     object \n",
      " 1   year                 50 non-null     int64  \n",
      " 2   type                 50 non-null     object \n",
      " 3   accidentType         0 non-null      float64\n",
      " 4   firstAddress         50 non-null     object \n",
      " 5   secondAddress        24 non-null     object \n",
      " 6   geometry             50 non-null     object \n",
      " 7   reason               50 non-null     object \n",
      " 8   area                 44 non-null     float64\n",
      " 9   creationDate         50 non-null     object \n",
      " 10  daniosMateriales     50 non-null     bool   \n",
      " 11  falloMecanico        50 non-null     bool   \n",
      " 12  estadoPavimento      50 non-null     object \n",
      " 13  tipoEstadoPavimento  0 non-null      float64\n",
      " 14  estadoAtmosfera      50 non-null     object \n",
      " 15  tipoEstadoAtmosfera  0 non-null      float64\n",
      " 16  afectado             24 non-null     object \n",
      " 17  vehiculo             50 non-null     object \n",
      "dtypes: bool(2), float64(4), int64(1), object(11)\n",
      "memory usage: 6.5+ KB\n"
     ]
    }
   ],
   "source": [
    "df_zrgz.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Enseñamos la columna \"reason\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0             PERDIDA del control por FALTA de ATENCIÓN\n",
       "1                   DISTANCIA DE SEGURIDAD, no mantener\n",
       "2             PERDIDA del control por FALTA de ATENCIÓN\n",
       "3           CEDA EL PASO, no respetar prioridad de paso\n",
       "4          PERDIDA del control por VELOCIDAD INADECUADA\n",
       "5               Caída de ocupante en Transporte Público\n",
       "6           PEATÓN cruza calz SIN PREFER. fuera de paso\n",
       "7     INVADIR otro carril en el mismo sentido de cir...\n",
       "8             PERDIDA del control por FALTA de ATENCIÓN\n",
       "9     INVADIR otro carril en el mismo sentido de cir...\n",
       "10              Caída de ocupante en Transporte Público\n",
       "11            PERDIDA del control por FALTA de ATENCIÓN\n",
       "12            PERDIDA del control por FALTA de ATENCIÓN\n",
       "13            PERDIDA del control por FALTA de ATENCIÓN\n",
       "14    PEATÓN cruza calz SIN PREFER. en PASO CON semá...\n",
       "15            PERDIDA del control por FALTA de ATENCIÓN\n",
       "16                  DISTANCIA DE SEGURIDAD, no mantener\n",
       "17            PERDIDA del control por FALTA de ATENCIÓN\n",
       "18            PERDIDA del control por FALTA de ATENCIÓN\n",
       "19            PERDIDA del control por FALTA de ATENCIÓN\n",
       "20                       PUERTA abierta incorrectamente\n",
       "21            PERDIDA del control por FALTA de ATENCIÓN\n",
       "22            PERDIDA del control por FALTA de ATENCIÓN\n",
       "23                                         MARCHA ATRÁS\n",
       "24         PERDIDA del control por VELOCIDAD INADECUADA\n",
       "25              SEMÁFORO, no respetar prioridad de paso\n",
       "26    INVADIR otro carril en el mismo sentido de cir...\n",
       "27                       PUERTA abierta incorrectamente\n",
       "28    INVADIR otro carril en el mismo sentido de cir...\n",
       "29    INVADIR otro carril en el mismo sentido de cir...\n",
       "30                  DISTANCIA DE SEGURIDAD, no mantener\n",
       "31    INVADIR otro carril en el mismo sentido de cir...\n",
       "32                                         OTRAS CAUSAS\n",
       "33    INVADIR otro carril en el mismo sentido de cir...\n",
       "34                                         MARCHA ATRÁS\n",
       "35            PERDIDA del control por FALTA de ATENCIÓN\n",
       "36    INVADIR otro carril en el mismo sentido de cir...\n",
       "37    PEATÓN cruza calz CON PREFER. en PASO  CON sem...\n",
       "38                                         MARCHA ATRÁS\n",
       "39                                         MARCHA ATRÁS\n",
       "40                                         OTRAS CAUSAS\n",
       "41    PEATÓN cruza calz CON PREFER. en PASO  SIN sem...\n",
       "42            PERDIDA del control por FALTA de ATENCIÓN\n",
       "43            PERDIDA del control por FALTA de ATENCIÓN\n",
       "44            PERDIDA del control por FALTA de ATENCIÓN\n",
       "45    INVADIR otro carril en el mismo sentido de cir...\n",
       "46                  DISTANCIA DE SEGURIDAD, no mantener\n",
       "47            PERDIDA del control por FALTA de ATENCIÓN\n",
       "48            PERDIDA del control por FALTA de ATENCIÓN\n",
       "49            PERDIDA del control por FALTA de ATENCIÓN\n",
       "Name: reason, dtype: object"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz['reason']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Aquí se enseñan los datos que no están repetidos en la columna \"reason\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['PERDIDA del control por FALTA de ATENCIÓN',\n",
       "       'DISTANCIA DE SEGURIDAD, no mantener',\n",
       "       'CEDA EL PASO, no respetar prioridad de paso',\n",
       "       'PERDIDA del control por VELOCIDAD INADECUADA',\n",
       "       'Caída de ocupante en Transporte Público',\n",
       "       'PEATÓN cruza calz SIN PREFER. fuera de paso',\n",
       "       'INVADIR otro carril en el mismo sentido de circulación',\n",
       "       'PEATÓN cruza calz SIN PREFER. en PASO CON semáforo',\n",
       "       'PUERTA abierta incorrectamente', 'MARCHA ATRÁS',\n",
       "       'SEMÁFORO, no respetar prioridad de paso', 'OTRAS CAUSAS',\n",
       "       'PEATÓN cruza calz CON PREFER. en PASO  CON semáforo',\n",
       "       'PEATÓN cruza calz CON PREFER. en PASO  SIN semáforo'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz['reason'].unique()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Enseñamos los datos que no se repiten de la columna \"type\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['SALIDA CALZADA', 'COLISIÓN ALCANCE', 'COLIS FRONTOLATERAL',\n",
       "       'OTRAS', 'ATROPELLO', 'CAIDA SOBRE CALZADA', 'COLIS. MARCHA ATRÁS',\n",
       "       'COLISIÓN LATERAL'], dtype=object)"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz['type'].unique()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Enseñamos la columna que recibe el nombre de \"geometry\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     -0.8818527060979306,41.649027473051156\n",
       "1     -0.8645810716721081,41.661585829868585\n",
       "2      -0.887776415002892,41.666992622958105\n",
       "3      -0.8825260453930127,41.62957498750602\n",
       "4        -0.908314757720389,41.6562121210704\n",
       "5      -0.8691088511672924,41.65949772773082\n",
       "6     -0.8880337913721866,41.633353667694024\n",
       "7       -0.8708838775078237,41.6390382112928\n",
       "8      -0.8970649943808023,41.64083344974765\n",
       "9      -0.8718525605769747,41.64904657717317\n",
       "10     -0.8964627561577849,41.64322365075108\n",
       "11     -0.8778095796207178,41.68753087470739\n",
       "12    -0.8812157329722801,41.661646612715046\n",
       "13      -0.8762000299022707,41.6454384961757\n",
       "14     -0.9089013552408617,41.65543768899759\n",
       "15     -0.9004729973337304,41.65180346604993\n",
       "16     -0.8917562993466011,41.65233828238132\n",
       "17      -0.888856043735591,41.65040494617356\n",
       "18    -0.8629911318784169,41.645335650478316\n",
       "19    -0.8870207060655807,41.609992514227066\n",
       "20     -0.8636325074780108,41.63379905763323\n",
       "21     -0.8760724207544668,41.63275556609146\n",
       "22     -0.9036852209830768,41.63808926467497\n",
       "23    -0.8896980442453839,41.677487884305975\n",
       "24    -0.9018264648858587,41.620591734015946\n",
       "25     -0.9187726932212442,41.64931371437485\n",
       "26    -0.8855988456901538,41.646890443474554\n",
       "27      -0.887523212911549,41.62404668544956\n",
       "28     -0.8863120908790753,41.63964884250951\n",
       "29    -0.8689640327130923,41.638477534601776\n",
       "30     -0.8900650666830714,41.64332496247496\n",
       "31     -0.8918524618079099,41.65260977469196\n",
       "32     -0.9104038365599549,41.65248328671194\n",
       "33      -0.8850103896969528,41.6474034449745\n",
       "34     -0.8734135018983006,41.64926981833846\n",
       "35    -0.8593239531218387,41.650740541708075\n",
       "36     -0.868891092151338,41.638807389014836\n",
       "37     -0.9008107424460443,41.66374540604866\n",
       "38     -0.9211220937948997,41.64886535549928\n",
       "39     -0.9026681648170423,41.63265453864093\n",
       "40     -0.8893162332922886,41.67281318904247\n",
       "41     -0.8890866503471749,41.66895757951277\n",
       "42     -0.8439506345833918,41.71496486522088\n",
       "43     -0.8665477541801948,41.67007665525934\n",
       "44     -0.8848493117953854,41.63484525009101\n",
       "45     -0.9147014503640727,41.64060309287472\n",
       "46     -0.9388159722509236,41.66210291413718\n",
       "47     -0.9157439755527074,41.63348367532985\n",
       "48     -0.8869959298557372,41.67593597602368\n",
       "49     -0.876909940066992,41.672106692157605\n",
       "Name: geometry, dtype: object"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz['geometry']"
   ]
  }
 ],
 "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.8.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}