get_data_opendata.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "import feedparser\n",
    "import pprint\n",
    "import requests \n",
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Listado de data sets disponible en opendata   \n",
    "parameters = {'rows': '1000'}\n",
    "\n",
    "url = 'http://opendata-ajuntament.barcelona.cat/data/api/3/action/package_search'\n",
    "response = requests.get(url,params=parameters)\n",
    "# Incluimos a tabla pandas Data sets contienen diferentes fuentes de datos columna resources\n",
    "catalogo = pd.DataFrame(response.json()['result']['results']) \n",
    "\n",
    "# Creamos tabla con las fuentes de datos del catalogo\n",
    "\n",
    "i = 0\n",
    "for index, row in catalogo.iterrows():\n",
    "    if i== 0:\n",
    "        fuente_datos = pd.DataFrame(row['resources']) \n",
    "        fuente_datos['code'] = row['code']   \n",
    "    i = 1\n",
    "    aux =  pd.DataFrame(row['resources'])\n",
    "    aux['code'] = row['code']\n",
    "    fuente_datos = fuente_datos.append(aux)\n",
    "fuente_datos = fuente_datos[['code','size', 'description', 'format' , 'downloads_absolute', 'token_required', 'url',  'name']]    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "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>code</th>\n",
       "      <th>title</th>\n",
       "      <th>frequency</th>\n",
       "      <th>fuente</th>\n",
       "      <th>relationships_as_object</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>np-piscines</td>\n",
       "      <td>Outdoor and covered swimming pools in the city...</td>\n",
       "      <td>SETMANAL</td>\n",
       "      <td>Ajuntament de Barcelona</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>np-molls</td>\n",
       "      <td>Docks in the city of Barcelona</td>\n",
       "      <td>SETMANAL</td>\n",
       "      <td>Ajuntament de Barcelona</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>np-platges</td>\n",
       "      <td>Beaches in the city of Barcelona</td>\n",
       "      <td>SETMANAL</td>\n",
       "      <td>Ajuntament de Barcelona</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>np-quioscs-tramits</td>\n",
       "      <td>Punt BCN. Procedures' kiosks in the city of Ba...</td>\n",
       "      <td>SETMANAL</td>\n",
       "      <td>Ajuntament de Barcelona</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>np umbracles</td>\n",
       "      <td>Umbracles in the city of Barcelona</td>\n",
       "      <td>SETMANAL</td>\n",
       "      <td>Ajuntament de Barcelona</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>518</th>\n",
       "      <td>MAPA_URBANISTIC</td>\n",
       "      <td>Urban map of the city of Barcelona</td>\n",
       "      <td>IMMEDIATA</td>\n",
       "      <td>Ajuntament de Barcelona - Geoportal</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519</th>\n",
       "      <td>MAPA_BASE_DE_VIALITAT</td>\n",
       "      <td>Base map of viability of the city of Barcelona</td>\n",
       "      <td>PETICIO_NEGOCI</td>\n",
       "      <td>Ajuntament de Barcelona - Geoportal</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>520</th>\n",
       "      <td>MAPA_PARCELARI</td>\n",
       "      <td>Land plots in the city of Barcelona</td>\n",
       "      <td>PETICIO_NEGOCI</td>\n",
       "      <td>Ajuntament de Barcelona</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>521</th>\n",
       "      <td>FRASE</td>\n",
       "      <td>Traffic incidence notices of the city of Barce...</td>\n",
       "      <td>CINC_MINUTS</td>\n",
       "      <td>Web del trànsit de l'Ajuntament de Barcelona</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>522</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>Traffic state information in the city of Barce...</td>\n",
       "      <td>CINC_MINUTS</td>\n",
       "      <td>Web del trànsit de l'Ajuntament de Barcelona</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>523 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      code                                              title  \\\n",
       "0              np-piscines  Outdoor and covered swimming pools in the city...   \n",
       "1                 np-molls                     Docks in the city of Barcelona   \n",
       "2               np-platges                   Beaches in the city of Barcelona   \n",
       "3       np-quioscs-tramits  Punt BCN. Procedures' kiosks in the city of Ba...   \n",
       "4             np umbracles                 Umbracles in the city of Barcelona   \n",
       "..                     ...                                                ...   \n",
       "518        MAPA_URBANISTIC                 Urban map of the city of Barcelona   \n",
       "519  MAPA_BASE_DE_VIALITAT     Base map of viability of the city of Barcelona   \n",
       "520         MAPA_PARCELARI                Land plots in the city of Barcelona   \n",
       "521                  FRASE  Traffic incidence notices of the city of Barce...   \n",
       "522             ITINERARIS  Traffic state information in the city of Barce...   \n",
       "\n",
       "          frequency                                        fuente  \\\n",
       "0          SETMANAL                       Ajuntament de Barcelona   \n",
       "1          SETMANAL                       Ajuntament de Barcelona   \n",
       "2          SETMANAL                       Ajuntament de Barcelona   \n",
       "3          SETMANAL                       Ajuntament de Barcelona   \n",
       "4          SETMANAL                       Ajuntament de Barcelona   \n",
       "..              ...                                           ...   \n",
       "518       IMMEDIATA           Ajuntament de Barcelona - Geoportal   \n",
       "519  PETICIO_NEGOCI           Ajuntament de Barcelona - Geoportal   \n",
       "520  PETICIO_NEGOCI                     Ajuntament de Barcelona     \n",
       "521     CINC_MINUTS  Web del trànsit de l'Ajuntament de Barcelona   \n",
       "522     CINC_MINUTS  Web del trànsit de l'Ajuntament de Barcelona   \n",
       "\n",
       "    relationships_as_object  \n",
       "0                        []  \n",
       "1                        []  \n",
       "2                        []  \n",
       "3                        []  \n",
       "4                        []  \n",
       "..                      ...  \n",
       "518                      []  \n",
       "519                      []  \n",
       "520                      []  \n",
       "521                      []  \n",
       "522                      []  \n",
       "\n",
       "[523 rows x 5 columns]"
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "catalogo[['code', 'title', 'frequency', 'fuente', 'relationships_as_object']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "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>code</th>\n",
       "      <th>size</th>\n",
       "      <th>description</th>\n",
       "      <th>format</th>\n",
       "      <th>downloads_absolute</th>\n",
       "      <th>token_required</th>\n",
       "      <th>url</th>\n",
       "      <th>name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>DAT</td>\n",
       "      <td>395893</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>225</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2021_01_Gener_ITINERARIS_ITINERARIS.csv</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>160</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2021_02_Febrer_ITINERARIS_ITINERARIS.csv</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>132</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2021_03_Marc_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>111</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2021_04_Abril_ITINERARIS_ITINERARIS.csv</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>114</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2021_05_Maig_ITINERARIS_ITINERARIS.csv</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>73</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2021_06_Juny_ITINERARIS_ITINERARIS.csv</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>55</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2021_07_Juliol_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>40</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2021_08_Agost_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>28</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2021_09_Setembre_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2021_10_Octubre_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2021_11_Novembre_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>515</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2020_01_Gener_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>446</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2020_02_Febrer_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>910</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2020_03_Marc_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>228</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2020_04_Abril_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>191</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2020_05_Maig_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>178</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2020_06_Juny_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>196</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2020_07_Juliol_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>181</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2020_08_Agost_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>195</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2020_09_Setembre_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>203</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2020_10_Octubre_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>166</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2020_11_Novembre_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>199</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2020_12_Desembre_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>589</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2019_01_Gener_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>519</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2019_02_Febrer_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>507</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2019_03_Marc_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>511</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2019_04_Abril_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>486</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2019_05_Maig_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>458</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2019_06_Juny_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>423</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2019_07_Juliol_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>435</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2019_08_Agost_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>450</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2019_09_Setembre_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>423</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2019_10_Octubre_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>435</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2019_11_Novembre_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>421</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2019_12_Desembre_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>571</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2018_01_Gener_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>504</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2018_02_Febrer_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>507</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2018_03_Marc_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>499</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2018_04_Abril_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>491</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2018_05_Maig_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>477</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2018_06_Juny_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>459</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2018_07_Juliol_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>465</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2018_08_Agost_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>473</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2018_09_Setembre_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>489</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2018_10_Octubre_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>473</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2018_11_Novembre_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>438</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2018_12_Desembre_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>544</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2017_11_Novembre_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>ITINERARIS</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>CSV</td>\n",
       "      <td>492</td>\n",
       "      <td>No</td>\n",
       "      <td>https://opendata-ajuntament.barcelona.cat/data...</td>\n",
       "      <td>2017_12_Desembre_ITINERARIS_ITINERARIS</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          code  size description format downloads_absolute token_required  \\\n",
       "0   ITINERARIS  None                DAT             395893            NaN   \n",
       "1   ITINERARIS  None                CSV                225             No   \n",
       "2   ITINERARIS  None                CSV                160             No   \n",
       "3   ITINERARIS  None                CSV                132             No   \n",
       "4   ITINERARIS  None                CSV                111             No   \n",
       "5   ITINERARIS  None                CSV                114             No   \n",
       "6   ITINERARIS  None                CSV                 73             No   \n",
       "7   ITINERARIS  None                CSV                 55             No   \n",
       "8   ITINERARIS  None                CSV                 40             No   \n",
       "9   ITINERARIS  None                CSV                 28             No   \n",
       "10  ITINERARIS  None                CSV                 23            NaN   \n",
       "11  ITINERARIS  None                CSV                  1            NaN   \n",
       "12  ITINERARIS  None                CSV                515             No   \n",
       "13  ITINERARIS  None                CSV                446             No   \n",
       "14  ITINERARIS  None                CSV                910             No   \n",
       "15  ITINERARIS  None                CSV                228             No   \n",
       "16  ITINERARIS  None                CSV                191             No   \n",
       "17  ITINERARIS  None                CSV                178             No   \n",
       "18  ITINERARIS  None                CSV                196             No   \n",
       "19  ITINERARIS  None                CSV                181             No   \n",
       "20  ITINERARIS  None                CSV                195             No   \n",
       "21  ITINERARIS  None                CSV                203             No   \n",
       "22  ITINERARIS  None                CSV                166             No   \n",
       "23  ITINERARIS  None                CSV                199             No   \n",
       "24  ITINERARIS  None                CSV                589             No   \n",
       "25  ITINERARIS  None                CSV                519             No   \n",
       "26  ITINERARIS  None                CSV                507             No   \n",
       "27  ITINERARIS  None                CSV                511             No   \n",
       "28  ITINERARIS  None                CSV                486             No   \n",
       "29  ITINERARIS  None                CSV                458             No   \n",
       "30  ITINERARIS  None                CSV                423             No   \n",
       "31  ITINERARIS  None                CSV                435             No   \n",
       "32  ITINERARIS  None                CSV                450             No   \n",
       "33  ITINERARIS  None                CSV                423             No   \n",
       "34  ITINERARIS  None                CSV                435             No   \n",
       "35  ITINERARIS  None                CSV                421             No   \n",
       "36  ITINERARIS  None                CSV                571             No   \n",
       "37  ITINERARIS  None                CSV                504             No   \n",
       "38  ITINERARIS  None                CSV                507             No   \n",
       "39  ITINERARIS  None                CSV                499             No   \n",
       "40  ITINERARIS  None                CSV                491             No   \n",
       "41  ITINERARIS  None                CSV                477             No   \n",
       "42  ITINERARIS  None                CSV                459             No   \n",
       "43  ITINERARIS  None                CSV                465             No   \n",
       "44  ITINERARIS  None                CSV                473             No   \n",
       "45  ITINERARIS  None                CSV                489             No   \n",
       "46  ITINERARIS  None                CSV                473             No   \n",
       "47  ITINERARIS  None                CSV                438             No   \n",
       "48  ITINERARIS  None                CSV                544             No   \n",
       "49  ITINERARIS  None                CSV                492             No   \n",
       "\n",
       "                                                  url  \\\n",
       "0   https://opendata-ajuntament.barcelona.cat/data...   \n",
       "1   https://opendata-ajuntament.barcelona.cat/data...   \n",
       "2   https://opendata-ajuntament.barcelona.cat/data...   \n",
       "3   https://opendata-ajuntament.barcelona.cat/data...   \n",
       "4   https://opendata-ajuntament.barcelona.cat/data...   \n",
       "5   https://opendata-ajuntament.barcelona.cat/data...   \n",
       "6   https://opendata-ajuntament.barcelona.cat/data...   \n",
       "7   https://opendata-ajuntament.barcelona.cat/data...   \n",
       "8   https://opendata-ajuntament.barcelona.cat/data...   \n",
       "9   https://opendata-ajuntament.barcelona.cat/data...   \n",
       "10  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "11  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "12  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "13  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "14  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "15  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "16  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "17  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "18  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "19  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "20  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "21  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "22  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "23  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "24  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "25  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "26  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "27  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "28  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "29  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "30  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "31  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "32  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "33  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "34  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "35  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "36  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "37  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "38  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "39  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "40  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "41  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "42  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "43  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "44  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "45  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "46  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "47  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "48  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "49  https://opendata-ajuntament.barcelona.cat/data...   \n",
       "\n",
       "                                        name  \n",
       "0                      ITINERARIS_ITINERARIS  \n",
       "1    2021_01_Gener_ITINERARIS_ITINERARIS.csv  \n",
       "2   2021_02_Febrer_ITINERARIS_ITINERARIS.csv  \n",
       "3         2021_03_Marc_ITINERARIS_ITINERARIS  \n",
       "4    2021_04_Abril_ITINERARIS_ITINERARIS.csv  \n",
       "5     2021_05_Maig_ITINERARIS_ITINERARIS.csv  \n",
       "6     2021_06_Juny_ITINERARIS_ITINERARIS.csv  \n",
       "7       2021_07_Juliol_ITINERARIS_ITINERARIS  \n",
       "8        2021_08_Agost_ITINERARIS_ITINERARIS  \n",
       "9     2021_09_Setembre_ITINERARIS_ITINERARIS  \n",
       "10     2021_10_Octubre_ITINERARIS_ITINERARIS  \n",
       "11    2021_11_Novembre_ITINERARIS_ITINERARIS  \n",
       "12       2020_01_Gener_ITINERARIS_ITINERARIS  \n",
       "13      2020_02_Febrer_ITINERARIS_ITINERARIS  \n",
       "14        2020_03_Marc_ITINERARIS_ITINERARIS  \n",
       "15       2020_04_Abril_ITINERARIS_ITINERARIS  \n",
       "16        2020_05_Maig_ITINERARIS_ITINERARIS  \n",
       "17        2020_06_Juny_ITINERARIS_ITINERARIS  \n",
       "18      2020_07_Juliol_ITINERARIS_ITINERARIS  \n",
       "19       2020_08_Agost_ITINERARIS_ITINERARIS  \n",
       "20    2020_09_Setembre_ITINERARIS_ITINERARIS  \n",
       "21     2020_10_Octubre_ITINERARIS_ITINERARIS  \n",
       "22    2020_11_Novembre_ITINERARIS_ITINERARIS  \n",
       "23    2020_12_Desembre_ITINERARIS_ITINERARIS  \n",
       "24       2019_01_Gener_ITINERARIS_ITINERARIS  \n",
       "25      2019_02_Febrer_ITINERARIS_ITINERARIS  \n",
       "26        2019_03_Marc_ITINERARIS_ITINERARIS  \n",
       "27       2019_04_Abril_ITINERARIS_ITINERARIS  \n",
       "28        2019_05_Maig_ITINERARIS_ITINERARIS  \n",
       "29        2019_06_Juny_ITINERARIS_ITINERARIS  \n",
       "30      2019_07_Juliol_ITINERARIS_ITINERARIS  \n",
       "31       2019_08_Agost_ITINERARIS_ITINERARIS  \n",
       "32    2019_09_Setembre_ITINERARIS_ITINERARIS  \n",
       "33     2019_10_Octubre_ITINERARIS_ITINERARIS  \n",
       "34    2019_11_Novembre_ITINERARIS_ITINERARIS  \n",
       "35    2019_12_Desembre_ITINERARIS_ITINERARIS  \n",
       "36       2018_01_Gener_ITINERARIS_ITINERARIS  \n",
       "37      2018_02_Febrer_ITINERARIS_ITINERARIS  \n",
       "38        2018_03_Marc_ITINERARIS_ITINERARIS  \n",
       "39       2018_04_Abril_ITINERARIS_ITINERARIS  \n",
       "40        2018_05_Maig_ITINERARIS_ITINERARIS  \n",
       "41        2018_06_Juny_ITINERARIS_ITINERARIS  \n",
       "42      2018_07_Juliol_ITINERARIS_ITINERARIS  \n",
       "43       2018_08_Agost_ITINERARIS_ITINERARIS  \n",
       "44    2018_09_Setembre_ITINERARIS_ITINERARIS  \n",
       "45     2018_10_Octubre_ITINERARIS_ITINERARIS  \n",
       "46    2018_11_Novembre_ITINERARIS_ITINERARIS  \n",
       "47    2018_12_Desembre_ITINERARIS_ITINERARIS  \n",
       "48    2017_11_Novembre_ITINERARIS_ITINERARIS  \n",
       "49    2017_12_Desembre_ITINERARIS_ITINERARIS  "
      ]
     },
     "execution_count": 108,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fuente_datos[fuente_datos.code == 'ITINERARIS' ]\n",
    "    "
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "language": "python",
   "name": "base"
  },
  "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}