stroytelling_06_interes_national.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "c4436bda",
   "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>festival</th>\n",
       "      <th>localidad</th>\n",
       "      <th>lat</th>\n",
       "      <th>date_start</th>\n",
       "      <th>est</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>El Bautizo del Niño</td>\n",
       "      <td>Palencia</td>\n",
       "      <td>42°01′00″N 4°32′00″O﻿ / ﻿42.01667, -4.53333﻿</td>\n",
       "      <td>1 de enero</td>\n",
       "      <td>5 de marzo de 2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>La Vijanera</td>\n",
       "      <td>Silió(Cantabria)</td>\n",
       "      <td>43°08′53″N 4°01′17″O﻿ / ﻿43.14806, -4.02139﻿</td>\n",
       "      <td>2-8 de enero (primer domingo de enero después ...</td>\n",
       "      <td>28 de mayo de 2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Cabalgata de Reyes Magos de Alcoy</td>\n",
       "      <td>Alcoy(Alicante)</td>\n",
       "      <td>38°41′54″N 0°28′25″O﻿ / ﻿38.69833, -0.47361﻿</td>\n",
       "      <td>5 de enero</td>\n",
       "      <td>28 de noviembre de 2001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Auto Sacramental y Cabalgata de Reyes</td>\n",
       "      <td>Santillana del Mar(Cantabria)</td>\n",
       "      <td>43°23′36″N 4°06′17″O﻿ / ﻿43.39333, -4.10472﻿</td>\n",
       "      <td>5 de enero</td>\n",
       "      <td>23 de noviembre de 2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Fiestas de San Antón y Carrera Urbana Internac...</td>\n",
       "      <td>Jaén</td>\n",
       "      <td>37°46′11″N 3°47′20″O﻿ / ﻿37.76972, -3.78889﻿</td>\n",
       "      <td>Noche del 16 de enero</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            festival  \\\n",
       "0                                El Bautizo del Niño   \n",
       "1                                        La Vijanera   \n",
       "2                  Cabalgata de Reyes Magos de Alcoy   \n",
       "3              Auto Sacramental y Cabalgata de Reyes   \n",
       "4  Fiestas de San Antón y Carrera Urbana Internac...   \n",
       "\n",
       "                       localidad  \\\n",
       "0                       Palencia   \n",
       "1               Silió(Cantabria)   \n",
       "2                Alcoy(Alicante)   \n",
       "3  Santillana del Mar(Cantabria)   \n",
       "4                           Jaén   \n",
       "\n",
       "                                            lat  \\\n",
       "0  42°01′00″N 4°32′00″O﻿ / ﻿42.01667, -4.53333﻿   \n",
       "1  43°08′53″N 4°01′17″O﻿ / ﻿43.14806, -4.02139﻿   \n",
       "2  38°41′54″N 0°28′25″O﻿ / ﻿38.69833, -0.47361﻿   \n",
       "3  43°23′36″N 4°06′17″O﻿ / ﻿43.39333, -4.10472﻿   \n",
       "4  37°46′11″N 3°47′20″O﻿ / ﻿37.76972, -3.78889﻿   \n",
       "\n",
       "                                          date_start                      est  \n",
       "0                                         1 de enero       5 de marzo de 2015  \n",
       "1  2-8 de enero (primer domingo de enero después ...       28 de mayo de 2009  \n",
       "2                                         5 de enero  28 de noviembre de 2001  \n",
       "3                                         5 de enero  23 de noviembre de 2009  \n",
       "4                              Noche del 16 de enero                     2019  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "data = pd.read_csv(r'C:\\WORK_IAAC\\submissions\\Storytelling\\fiesta_shapefiles\\fiestasWiki_national.csv')\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "28654f3a",
   "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>festival</th>\n",
       "      <th>localidad</th>\n",
       "      <th>lat</th>\n",
       "      <th>date_start</th>\n",
       "      <th>est</th>\n",
       "      <th>prov</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>El Bautizo del Niño</td>\n",
       "      <td>Palencia</td>\n",
       "      <td>42°01′00″N 4°32′00″O﻿ / ﻿42.01667, -4.53333﻿</td>\n",
       "      <td>1 de enero</td>\n",
       "      <td>5 de marzo de 2015</td>\n",
       "      <td>Palencia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>La Vijanera</td>\n",
       "      <td>Silió</td>\n",
       "      <td>43°08′53″N 4°01′17″O﻿ / ﻿43.14806, -4.02139﻿</td>\n",
       "      <td>2-8 de enero (primer domingo de enero después ...</td>\n",
       "      <td>28 de mayo de 2009</td>\n",
       "      <td>Cantabria</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Cabalgata de Reyes Magos de Alcoy</td>\n",
       "      <td>Alcoy</td>\n",
       "      <td>38°41′54″N 0°28′25″O﻿ / ﻿38.69833, -0.47361﻿</td>\n",
       "      <td>5 de enero</td>\n",
       "      <td>28 de noviembre de 2001</td>\n",
       "      <td>Alicante</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Auto Sacramental y Cabalgata de Reyes</td>\n",
       "      <td>Santillana del Mar</td>\n",
       "      <td>43°23′36″N 4°06′17″O﻿ / ﻿43.39333, -4.10472﻿</td>\n",
       "      <td>5 de enero</td>\n",
       "      <td>23 de noviembre de 2009</td>\n",
       "      <td>Cantabria</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Fiestas de San Antón y Carrera Urbana Internac...</td>\n",
       "      <td>Jaén</td>\n",
       "      <td>37°46′11″N 3°47′20″O﻿ / ﻿37.76972, -3.78889﻿</td>\n",
       "      <td>Noche del 16 de enero</td>\n",
       "      <td>2019</td>\n",
       "      <td>Jaén</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            festival           localidad  \\\n",
       "0                                El Bautizo del Niño            Palencia   \n",
       "1                                        La Vijanera               Silió   \n",
       "2                  Cabalgata de Reyes Magos de Alcoy               Alcoy   \n",
       "3              Auto Sacramental y Cabalgata de Reyes  Santillana del Mar   \n",
       "4  Fiestas de San Antón y Carrera Urbana Internac...                Jaén   \n",
       "\n",
       "                                            lat  \\\n",
       "0  42°01′00″N 4°32′00″O﻿ / ﻿42.01667, -4.53333﻿   \n",
       "1  43°08′53″N 4°01′17″O﻿ / ﻿43.14806, -4.02139﻿   \n",
       "2  38°41′54″N 0°28′25″O﻿ / ﻿38.69833, -0.47361﻿   \n",
       "3  43°23′36″N 4°06′17″O﻿ / ﻿43.39333, -4.10472﻿   \n",
       "4  37°46′11″N 3°47′20″O﻿ / ﻿37.76972, -3.78889﻿   \n",
       "\n",
       "                                          date_start                      est  \\\n",
       "0                                         1 de enero       5 de marzo de 2015   \n",
       "1  2-8 de enero (primer domingo de enero después ...       28 de mayo de 2009   \n",
       "2                                         5 de enero  28 de noviembre de 2001   \n",
       "3                                         5 de enero  23 de noviembre de 2009   \n",
       "4                              Noche del 16 de enero                     2019   \n",
       "\n",
       "        prov  \n",
       "0   Palencia  \n",
       "1  Cantabria  \n",
       "2   Alicante  \n",
       "3  Cantabria  \n",
       "4       Jaén  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "prov_list = []\n",
    "for index, row in data.iterrows():\n",
    "    if '(' in row['localidad']:\n",
    "        prov = row['localidad'].split('(')[1].replace(')', '').strip()\n",
    "    else:\n",
    "        prov = row['localidad']\n",
    "    prov_list.append(prov)\n",
    "    row['localidad'] = row['localidad'].split('(')[0].strip()\n",
    "data['prov'] = prov_list\n",
    "\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "261a283c",
   "metadata": {
    "scrolled": true
   },
   "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>festival</th>\n",
       "      <th>localidad</th>\n",
       "      <th>date_start</th>\n",
       "      <th>est</th>\n",
       "      <th>prov</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>El Bautizo del Niño</td>\n",
       "      <td>Palencia</td>\n",
       "      <td>1 de enero</td>\n",
       "      <td>5 de marzo de 2015</td>\n",
       "      <td>Palencia</td>\n",
       "      <td>42°01′00″N 4°32′00″O﻿</td>\n",
       "      <td>﻿42.01667, -4.53333﻿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>La Vijanera</td>\n",
       "      <td>Silió</td>\n",
       "      <td>2-8 de enero (primer domingo de enero después ...</td>\n",
       "      <td>28 de mayo de 2009</td>\n",
       "      <td>Cantabria</td>\n",
       "      <td>43°08′53″N 4°01′17″O﻿</td>\n",
       "      <td>﻿43.14806, -4.02139﻿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Cabalgata de Reyes Magos de Alcoy</td>\n",
       "      <td>Alcoy</td>\n",
       "      <td>5 de enero</td>\n",
       "      <td>28 de noviembre de 2001</td>\n",
       "      <td>Alicante</td>\n",
       "      <td>38°41′54″N 0°28′25″O﻿</td>\n",
       "      <td>﻿38.69833, -0.47361﻿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Auto Sacramental y Cabalgata de Reyes</td>\n",
       "      <td>Santillana del Mar</td>\n",
       "      <td>5 de enero</td>\n",
       "      <td>23 de noviembre de 2009</td>\n",
       "      <td>Cantabria</td>\n",
       "      <td>43°23′36″N 4°06′17″O﻿</td>\n",
       "      <td>﻿43.39333, -4.10472﻿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Fiestas de San Antón y Carrera Urbana Internac...</td>\n",
       "      <td>Jaén</td>\n",
       "      <td>Noche del 16 de enero</td>\n",
       "      <td>2019</td>\n",
       "      <td>Jaén</td>\n",
       "      <td>37°46′11″N 3°47′20″O﻿</td>\n",
       "      <td>﻿37.76972, -3.78889﻿</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            festival           localidad  \\\n",
       "0                                El Bautizo del Niño            Palencia   \n",
       "1                                        La Vijanera               Silió   \n",
       "2                  Cabalgata de Reyes Magos de Alcoy               Alcoy   \n",
       "3              Auto Sacramental y Cabalgata de Reyes  Santillana del Mar   \n",
       "4  Fiestas de San Antón y Carrera Urbana Internac...                Jaén   \n",
       "\n",
       "                                          date_start                      est  \\\n",
       "0                                         1 de enero       5 de marzo de 2015   \n",
       "1  2-8 de enero (primer domingo de enero después ...       28 de mayo de 2009   \n",
       "2                                         5 de enero  28 de noviembre de 2001   \n",
       "3                                         5 de enero  23 de noviembre de 2009   \n",
       "4                              Noche del 16 de enero                     2019   \n",
       "\n",
       "        prov                Latitude              Longitude  \n",
       "0   Palencia  42°01′00″N 4°32′00″O﻿    ﻿42.01667, -4.53333﻿  \n",
       "1  Cantabria  43°08′53″N 4°01′17″O﻿    ﻿43.14806, -4.02139﻿  \n",
       "2   Alicante  38°41′54″N 0°28′25″O﻿    ﻿38.69833, -0.47361﻿  \n",
       "3  Cantabria  43°23′36″N 4°06′17″O﻿    ﻿43.39333, -4.10472﻿  \n",
       "4       Jaén  37°46′11″N 3°47′20″O﻿    ﻿37.76972, -3.78889﻿  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['lat'] = data['lat'].astype(str)\n",
    "\n",
    "data[['Latitude', 'Longitude']] = data['lat'].dropna().apply(lambda x: pd.Series(x.split('/')[0:2]) if '/' in x else pd.Series([None, None]))\n",
    "\n",
    "data = data.drop(columns=['lat'])\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "5a5aa818",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['festival', 'localidad', 'date_start', 'est', 'prov', 'Latitude',\n",
       "       'Longitude'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "b19cd75a",
   "metadata": {},
   "outputs": [],
   "source": [
    "import re"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "e66478f4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0         ﻿42.01667, -4.53333﻿\n",
       "1         ﻿43.14806, -4.02139﻿\n",
       "2         ﻿38.69833, -0.47361﻿\n",
       "3         ﻿43.39333, -4.10472﻿\n",
       "4         ﻿37.76972, -3.78889﻿\n",
       "                ...           \n",
       "157       ﻿43.15361, -4.62333﻿\n",
       "158       ﻿38.74500, -0.44056﻿\n",
       "159     ﻿40.482194, -3.371861﻿\n",
       "160       ﻿41.33056, -5.08139﻿\n",
       "161       ﻿38.61667, -1.11667﻿\n",
       "Name: Longitude, Length: 162, dtype: object"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Longitude']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "802a5a26",
   "metadata": {
    "scrolled": true
   },
   "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>festival</th>\n",
       "      <th>localidad</th>\n",
       "      <th>date_start</th>\n",
       "      <th>est</th>\n",
       "      <th>prov</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>El Bautizo del Niño</td>\n",
       "      <td>Palencia</td>\n",
       "      <td>1 de enero</td>\n",
       "      <td>5 de marzo de 2015</td>\n",
       "      <td>Palencia</td>\n",
       "      <td>﻿42.01667</td>\n",
       "      <td>-4.53333﻿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>La Vijanera</td>\n",
       "      <td>Silió</td>\n",
       "      <td>2-8 de enero (primer domingo de enero después ...</td>\n",
       "      <td>28 de mayo de 2009</td>\n",
       "      <td>Cantabria</td>\n",
       "      <td>﻿43.14806</td>\n",
       "      <td>-4.02139﻿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Cabalgata de Reyes Magos de Alcoy</td>\n",
       "      <td>Alcoy</td>\n",
       "      <td>5 de enero</td>\n",
       "      <td>28 de noviembre de 2001</td>\n",
       "      <td>Alicante</td>\n",
       "      <td>﻿38.69833</td>\n",
       "      <td>-0.47361﻿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Auto Sacramental y Cabalgata de Reyes</td>\n",
       "      <td>Santillana del Mar</td>\n",
       "      <td>5 de enero</td>\n",
       "      <td>23 de noviembre de 2009</td>\n",
       "      <td>Cantabria</td>\n",
       "      <td>﻿43.39333</td>\n",
       "      <td>-4.10472﻿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Fiestas de San Antón y Carrera Urbana Internac...</td>\n",
       "      <td>Jaén</td>\n",
       "      <td>Noche del 16 de enero</td>\n",
       "      <td>2019</td>\n",
       "      <td>Jaén</td>\n",
       "      <td>﻿37.76972</td>\n",
       "      <td>-3.78889﻿</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            festival           localidad  \\\n",
       "0                                El Bautizo del Niño            Palencia   \n",
       "1                                        La Vijanera               Silió   \n",
       "2                  Cabalgata de Reyes Magos de Alcoy               Alcoy   \n",
       "3              Auto Sacramental y Cabalgata de Reyes  Santillana del Mar   \n",
       "4  Fiestas de San Antón y Carrera Urbana Internac...                Jaén   \n",
       "\n",
       "                                          date_start                      est  \\\n",
       "0                                         1 de enero       5 de marzo de 2015   \n",
       "1  2-8 de enero (primer domingo de enero después ...       28 de mayo de 2009   \n",
       "2                                         5 de enero  28 de noviembre de 2001   \n",
       "3                                         5 de enero  23 de noviembre de 2009   \n",
       "4                              Noche del 16 de enero                     2019   \n",
       "\n",
       "        prov         lat         lng  \n",
       "0   Palencia   ﻿42.01667   -4.53333﻿  \n",
       "1  Cantabria   ﻿43.14806   -4.02139﻿  \n",
       "2   Alicante   ﻿38.69833   -0.47361﻿  \n",
       "3  Cantabria   ﻿43.39333   -4.10472﻿  \n",
       "4       Jaén   ﻿37.76972   -3.78889﻿  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = data.drop(columns=['Latitude'])\n",
    "data[['lat', 'lng']] = data['Longitude'].dropna().apply(lambda x: pd.Series(x.split(',')) if ',' in x else pd.Series([None, None]))\n",
    "data = data.drop(columns=['Longitude'])\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "90fc2112",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The 'lng' column contains the \\ufeff character\n",
      "161 161\n"
     ]
    }
   ],
   "source": [
    "if data['lng'].str.contains('\\ufeff').any():\n",
    "    print(\"The 'lng' column contains the \\\\ufeff character\")\n",
    "else:\n",
    "    print(\"The 'lng' column does not contain the \\\\ufeff character\")\n",
    "count = sum(data['lat'].astype(str).str.contains('\\ufeff'))\n",
    "count2 = sum(data['lng'].astype(str).str.contains('\\ufeff'))\n",
    "# print the count\n",
    "print(count, count2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "b714e72c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['festival', 'localidad', 'date_start', 'est', 'prov', 'lat', 'lng'], dtype='object')"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "39333ff8",
   "metadata": {},
   "outputs": [],
   "source": [
    "data['est'] = data['est'].str.rsplit(' ', 2).str[-1].fillna('1980')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "71f96e72",
   "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>festival</th>\n",
       "      <th>localidad</th>\n",
       "      <th>date_start</th>\n",
       "      <th>est</th>\n",
       "      <th>prov</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>El Bautizo del Niño</td>\n",
       "      <td>Palencia</td>\n",
       "      <td>1 de enero</td>\n",
       "      <td>2015</td>\n",
       "      <td>Palencia</td>\n",
       "      <td>﻿42.01667</td>\n",
       "      <td>-4.53333﻿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>La Vijanera</td>\n",
       "      <td>Silió</td>\n",
       "      <td>2-8 de enero (primer domingo de enero después ...</td>\n",
       "      <td>2009</td>\n",
       "      <td>Cantabria</td>\n",
       "      <td>﻿43.14806</td>\n",
       "      <td>-4.02139﻿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Cabalgata de Reyes Magos de Alcoy</td>\n",
       "      <td>Alcoy</td>\n",
       "      <td>5 de enero</td>\n",
       "      <td>2001</td>\n",
       "      <td>Alicante</td>\n",
       "      <td>﻿38.69833</td>\n",
       "      <td>-0.47361﻿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Auto Sacramental y Cabalgata de Reyes</td>\n",
       "      <td>Santillana del Mar</td>\n",
       "      <td>5 de enero</td>\n",
       "      <td>2009</td>\n",
       "      <td>Cantabria</td>\n",
       "      <td>﻿43.39333</td>\n",
       "      <td>-4.10472﻿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Fiestas de San Antón y Carrera Urbana Internac...</td>\n",
       "      <td>Jaén</td>\n",
       "      <td>Noche del 16 de enero</td>\n",
       "      <td>2019</td>\n",
       "      <td>Jaén</td>\n",
       "      <td>﻿37.76972</td>\n",
       "      <td>-3.78889﻿</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            festival           localidad  \\\n",
       "0                                El Bautizo del Niño            Palencia   \n",
       "1                                        La Vijanera               Silió   \n",
       "2                  Cabalgata de Reyes Magos de Alcoy               Alcoy   \n",
       "3              Auto Sacramental y Cabalgata de Reyes  Santillana del Mar   \n",
       "4  Fiestas de San Antón y Carrera Urbana Internac...                Jaén   \n",
       "\n",
       "                                          date_start   est       prov  \\\n",
       "0                                         1 de enero  2015   Palencia   \n",
       "1  2-8 de enero (primer domingo de enero después ...  2009  Cantabria   \n",
       "2                                         5 de enero  2001   Alicante   \n",
       "3                                         5 de enero  2009  Cantabria   \n",
       "4                              Noche del 16 de enero  2019       Jaén   \n",
       "\n",
       "          lat         lng  \n",
       "0   ﻿42.01667   -4.53333﻿  \n",
       "1   ﻿43.14806   -4.02139﻿  \n",
       "2   ﻿38.69833   -0.47361﻿  \n",
       "3   ﻿43.39333   -4.10472﻿  \n",
       "4   ﻿37.76972   -3.78889﻿  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "7b21ac8f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    42.01667\n",
       "1    43.14806\n",
       "2    38.69833\n",
       "3    43.39333\n",
       "4    37.76972\n",
       "Name: latitude, dtype: object"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import re\n",
    "data['latitude'] = data['lat'].apply(lambda x:re.findall(r'[0-9]+\\.[0-9]+', str(x)))\n",
    "data['latitude'] = data['latitude'].apply(lambda x:x[0] if len(x)>0 else None)\n",
    "\n",
    "data['latitude'].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "7a2aeb4c",
   "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>festival</th>\n",
       "      <th>localidad</th>\n",
       "      <th>date_start</th>\n",
       "      <th>est</th>\n",
       "      <th>prov</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>El Bautizo del Niño</td>\n",
       "      <td>Palencia</td>\n",
       "      <td>1 de enero</td>\n",
       "      <td>2015</td>\n",
       "      <td>Palencia</td>\n",
       "      <td>42.01667</td>\n",
       "      <td>-4.53333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>La Vijanera</td>\n",
       "      <td>Silió</td>\n",
       "      <td>2-8 de enero (primer domingo de enero después ...</td>\n",
       "      <td>2009</td>\n",
       "      <td>Cantabria</td>\n",
       "      <td>43.14806</td>\n",
       "      <td>-4.02139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Cabalgata de Reyes Magos de Alcoy</td>\n",
       "      <td>Alcoy</td>\n",
       "      <td>5 de enero</td>\n",
       "      <td>2001</td>\n",
       "      <td>Alicante</td>\n",
       "      <td>38.69833</td>\n",
       "      <td>-0.47361</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Auto Sacramental y Cabalgata de Reyes</td>\n",
       "      <td>Santillana del Mar</td>\n",
       "      <td>5 de enero</td>\n",
       "      <td>2009</td>\n",
       "      <td>Cantabria</td>\n",
       "      <td>43.39333</td>\n",
       "      <td>-4.10472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Fiestas de San Antón y Carrera Urbana Internac...</td>\n",
       "      <td>Jaén</td>\n",
       "      <td>Noche del 16 de enero</td>\n",
       "      <td>2019</td>\n",
       "      <td>Jaén</td>\n",
       "      <td>37.76972</td>\n",
       "      <td>-3.78889</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            festival           localidad  \\\n",
       "0                                El Bautizo del Niño            Palencia   \n",
       "1                                        La Vijanera               Silió   \n",
       "2                  Cabalgata de Reyes Magos de Alcoy               Alcoy   \n",
       "3              Auto Sacramental y Cabalgata de Reyes  Santillana del Mar   \n",
       "4  Fiestas de San Antón y Carrera Urbana Internac...                Jaén   \n",
       "\n",
       "                                          date_start   est       prov  \\\n",
       "0                                         1 de enero  2015   Palencia   \n",
       "1  2-8 de enero (primer domingo de enero después ...  2009  Cantabria   \n",
       "2                                         5 de enero  2001   Alicante   \n",
       "3                                         5 de enero  2009  Cantabria   \n",
       "4                              Noche del 16 de enero  2019       Jaén   \n",
       "\n",
       "   latitude longitude  \n",
       "0  42.01667  -4.53333  \n",
       "1  43.14806  -4.02139  \n",
       "2  38.69833  -0.47361  \n",
       "3  43.39333  -4.10472  \n",
       "4  37.76972  -3.78889  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['longitude'] = data['lng'].apply(lambda x:re.findall(r'\\-[0-9]+\\.[0-9]+', str(x)))\n",
    "data['longitude'] = data['longitude'].apply(lambda x:x[0] if len(x)>0 else None)\n",
    "data = data.drop(columns=['lat','lng'])\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "ba20b45f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['1 de enero',\n",
       "       '2-8 de enero (primer domingo de enero después de Año Nuevo)',\n",
       "       '5 de enero', 'Noche del 16 de enero', '16, 17 y 18 de enero',\n",
       "       '19 y 20 de enero', '20 y 21 de enero',\n",
       "       '25-31 de enero (último domingo de enero)',\n",
       "       '11 de enero-15 de febrero al 8 de febrero-14 de marzo (Carnaval)',\n",
       "       '18 de enero-1 de marzo al 9 de febrero-12 de marzo (Carnaval)',\n",
       "       '21 de enero-25 de febrero al 8 de febrero-14 de marzo (Carnaval)',\n",
       "       '24 de enero-28 de febrero al 4 de febrero-10 de marzo (Carnaval)',\n",
       "       '24 de enero-28 de febrero (sábado anterior a Carnaval)',\n",
       "       '25 de enero-29 de febrero (domingo anterior a Carnaval)',\n",
       "       '29 de enero-4 de marzo al 5 de febrero-11 de marzo (Carnaval)',\n",
       "       '30 de enero-5 de marzo al 3 de febrero-9 de marzo (Carnaval)',\n",
       "       '30 de enero-5 de marzo al 7 de febrero-13 de marzo (Carnaval)',\n",
       "       '1-7 al 4-10 de febrero', 'Fin de semana próximo al 14 de febrero',\n",
       "       'Febrero', 'Primer domingo de marzo',\n",
       "       'Algunos sábados y todos los domingos y festivos desde el inicio de la Cuaresma hasta la primera semana de mayo (excepto Domingo de Ramos, Viernes Santo y Lunes de Pascua)',\n",
       "       'Del 15 al 19 de marzo', 'Del 14 al 19 de marzo',\n",
       "       'Del 15 al 31 de marzo', 'Fin de semana cercano al 28 de marzo',\n",
       "       'Abril', 'Del segundo lunes al tercer domingo de abril',\n",
       "       'Domingo de Ramos', 'Jueves y Viernes Santo',\n",
       "       'Domingo de Ramos, Jueves y Viernes Santo', 'Viernes Santo',\n",
       "       'Sábado Santo', 'Domingo de Resurrección', 'Semana Santa',\n",
       "       'Miércoles Santo', 'Sábado posterior a Semana Santa',\n",
       "       'Del 22 al 25 de abril', '27 de abril',\n",
       "       'Último fin de semana de abril', 'Último domingo de abril',\n",
       "       'Primera quincena de mayo', 'Del 30 de abril al 1 de mayo',\n",
       "       'Del 30 de abril al 6 de mayo', '2 de mayo',\n",
       "       'Primer viernes de mayo', 'Primer fin de semana de mayo',\n",
       "       'Del 2 al 3 de mayo', 'Primer domingo de mayo',\n",
       "       'Segunda o tercera semana de mayo', 'Domingo de Pentecostés',\n",
       "       'Lunes de Pentecostés', '26 de mayo', 'Última semana de mayo',\n",
       "       'Última semana de mayo-primera semana de junio',\n",
       "       'Del 9 al 11 de junio', 'Corpus Christi',\n",
       "       'Ocho días después de Corpus Christi', 'Mediados de junio',\n",
       "       'Tercer fin de semana de junio', 'Del 24 al 29 de junio',\n",
       "       '24 de junio', 'julio-agosto', 'Primer sábado de julio',\n",
       "       'Del 4 al 12 de julio', 'Segundo fin de semana de julio',\n",
       "       'Semana en torno al 17 de julio', 'Segunda quincena de julio',\n",
       "       'Último sábado de julio', 'Semana entorno al 25 de julio',\n",
       "       'En julio, cada cinco años', 'Agosto', 'Primer sábado de agosto',\n",
       "       'Primer domingo de agosto', 'Primera semana de agosto',\n",
       "       'Primera semana de agosto en los años impares, en los años pares se celebra en Oloron-Sainte-Marie',\n",
       "       'Principios de agosto', '6 de agosto', 'Del 9 al 15 de agosto',\n",
       "       'Del 14 al 17 de agosto', 'Del 14 al 21 de agosto',\n",
       "       'Segundo domingo de agosto', '15 de agosto', '16 de agosto',\n",
       "       'Segunda quincena de agosto', 'Del 20 al 23 de agosto',\n",
       "       'Tercer sábado de agosto', 'Tercer domingo de agosto, cada 6 años',\n",
       "       '27 de agosto', 'Último viernes de agosto',\n",
       "       'Último viernes y sábado de agosto', 'Última semana de agosto',\n",
       "       'Último domingo de agosto',\n",
       "       'Madrugada siguiente al último domingo de agosto',\n",
       "       'Último fin de semana deagosto y primer fin de semana de septiembre',\n",
       "       '5-8 de septiembre', '8 de septiembre', 'Del 4 al 9 de septiembre',\n",
       "       'Primera quincena de septiembre', '8 y 9 de septiembre',\n",
       "       'Segundo domingo de septiembre', 'Del 12 al 15 de septiembre',\n",
       "       'Del 15 al 24 de septiembre', '19 de septiembre',\n",
       "       'Del 20 al 26 de septiembre', '24 de septiembre',\n",
       "       '27 de septiembre', 'En torno al 27 de septiembre',\n",
       "       'Último sábado de septiembre', 'Otoño', 'Octubre',\n",
       "       'Principios de octubre', 'Del 4 al 12 de octubre',\n",
       "       'Semana en torno al 9 de octubre', '12 de octubre',\n",
       "       'Segunda quincena de octubre', 'Noviembre', '1 de noviembre',\n",
       "       'Fin de semana más cercano al 1 de noviembre',\n",
       "       '30 de noviembre-8 de diciembre', 'Del 5 al 8 de diciembre'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['date_start'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "8900c5cd",
   "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>festival</th>\n",
       "      <th>localidad</th>\n",
       "      <th>date_start</th>\n",
       "      <th>est</th>\n",
       "      <th>prov</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>start</th>\n",
       "      <th>fin</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>El Bautizo del Niño</td>\n",
       "      <td>Palencia</td>\n",
       "      <td>1 de enero</td>\n",
       "      <td>2015</td>\n",
       "      <td>Palencia</td>\n",
       "      <td>42.01667</td>\n",
       "      <td>-4.53333</td>\n",
       "      <td>2023-01-01</td>\n",
       "      <td>2023-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>La Vijanera</td>\n",
       "      <td>Silió</td>\n",
       "      <td>2-8 de enero (primer domingo de enero después ...</td>\n",
       "      <td>2009</td>\n",
       "      <td>Cantabria</td>\n",
       "      <td>43.14806</td>\n",
       "      <td>-4.02139</td>\n",
       "      <td>2023-01-02</td>\n",
       "      <td>2023-01-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Cabalgata de Reyes Magos de Alcoy</td>\n",
       "      <td>Alcoy</td>\n",
       "      <td>5 de enero</td>\n",
       "      <td>2001</td>\n",
       "      <td>Alicante</td>\n",
       "      <td>38.69833</td>\n",
       "      <td>-0.47361</td>\n",
       "      <td>2023-01-05</td>\n",
       "      <td>2023-01-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Auto Sacramental y Cabalgata de Reyes</td>\n",
       "      <td>Santillana del Mar</td>\n",
       "      <td>5 de enero</td>\n",
       "      <td>2009</td>\n",
       "      <td>Cantabria</td>\n",
       "      <td>43.39333</td>\n",
       "      <td>-4.10472</td>\n",
       "      <td>2023-01-05</td>\n",
       "      <td>2023-01-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Fiestas de San Antón y Carrera Urbana Internac...</td>\n",
       "      <td>Jaén</td>\n",
       "      <td>Noche del 16 de enero</td>\n",
       "      <td>2019</td>\n",
       "      <td>Jaén</td>\n",
       "      <td>37.76972</td>\n",
       "      <td>-3.78889</td>\n",
       "      <td>2023-01-15</td>\n",
       "      <td>2023-01-16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            festival           localidad  \\\n",
       "0                                El Bautizo del Niño            Palencia   \n",
       "1                                        La Vijanera               Silió   \n",
       "2                  Cabalgata de Reyes Magos de Alcoy               Alcoy   \n",
       "3              Auto Sacramental y Cabalgata de Reyes  Santillana del Mar   \n",
       "4  Fiestas de San Antón y Carrera Urbana Internac...                Jaén   \n",
       "\n",
       "                                          date_start   est       prov  \\\n",
       "0                                         1 de enero  2015   Palencia   \n",
       "1  2-8 de enero (primer domingo de enero después ...  2009  Cantabria   \n",
       "2                                         5 de enero  2001   Alicante   \n",
       "3                                         5 de enero  2009  Cantabria   \n",
       "4                              Noche del 16 de enero  2019       Jaén   \n",
       "\n",
       "   latitude longitude      start        fin  \n",
       "0  42.01667  -4.53333 2023-01-01 2023-01-01  \n",
       "1  43.14806  -4.02139 2023-01-02 2023-01-08  \n",
       "2  38.69833  -0.47361 2023-01-05 2023-01-05  \n",
       "3  43.39333  -4.10472 2023-01-05 2023-01-05  \n",
       "4  37.76972  -3.78889 2023-01-15 2023-01-16  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from datetime import datetime\n",
    "\n",
    "def add_carnival_dates(date):\n",
    "    if date == '2-8 de enero (primer domingo de enero después de Año Nuevo)':\n",
    "        start = datetime(2023, 1, 2)\n",
    "        fin = datetime(2023, 1, 8)\n",
    "        return pd.Series({'start': start, 'fin': fin})\n",
    "    if date == '5 de enero':\n",
    "        start = datetime(2023, 1, 5)\n",
    "        fin = datetime(2023, 1, 5)  \n",
    "        return pd.Series({'start': start, 'fin': fin})\n",
    "    if date == 'Noche del 16 de enero':\n",
    "        start = datetime(2023, 1, 15)\n",
    "        fin = datetime(2023, 1, 16)    \n",
    "        return pd.Series({'start': start, 'fin': fin})\n",
    "    if date == '16, 17 y 18 de enero':\n",
    "        start = datetime(2023, 1, 16)\n",
    "        fin = datetime(2023, 1, 18)\n",
    "        return pd.Series({'start': start, 'fin': fin})\n",
    "    if date == '1 de enero':\n",
    "        start = datetime(2023, 1, 1)\n",
    "        fin = datetime(2023, 1, 1)\n",
    "        return pd.Series({'start': start, 'fin': fin})   \n",
    "    if date == '19 y 20 de enero':\n",
    "        start = datetime(2023, 1, 19)\n",
    "        fin = datetime(2023, 1, 20)\n",
    "        return pd.Series({'start': start, 'fin': fin})\n",
    "    if date == '20 y 21 de enero':\n",
    "        start = datetime(2023, 1, 20)\n",
    "        fin = datetime(2023, 1, 21)\n",
    "        return pd.Series({'start': start, 'fin': fin})\n",
    "    if date == '25-31 de enero (último domingo de enero)':\n",
    "        start = datetime(2023, 1, 25)\n",
    "        fin = datetime(2023, 1, 30)\n",
    "        return pd.Series({'start': start, 'fin': fin})\n",
    "    if date == '11 de enero-15 de febrero al 8 de febrero-14 de marzo (Carnaval)':\n",
    "        start = datetime(2023, 2, 8)\n",
    "        fin = datetime(2023, 3, 14)\n",
    "        return pd.Series({'start': start, 'fin': fin})\n",
    "    if date == '18 de enero-1 de marzo al 9 de febrero-12 de marzo (Carnaval)':\n",
    "        start = datetime(2023, 1, 18)\n",
    "        fin = datetime(2023, 3, 1)\n",
    "        return pd.Series({'start': start, 'fin': fin})\n",
    "    if date == '21 de enero-25 de febrero al 8 de febrero-14 de marzo (Carnaval)':\n",
    "        start = datetime(2023, 1, 21)\n",
    "        fin = datetime(2023, 2, 25)\n",
    "        return pd.Series({'start': start, 'fin': fin})\n",
    "    if date == '24 de enero-28 de febrero al 4 de febrero-10 de marzo (Carnaval)':\n",
    "        start = datetime(2023, 1, 24)\n",
    "        fin = datetime(2023, 2, 28)\n",
    "        return pd.Series({'start': start, 'fin': fin})   \n",
    "    if date == '24 de enero-28 de febrero (sábado anterior a Carnaval)':\n",
    "        start = datetime(2023, 1, 24)\n",
    "        fin = datetime(2023, 2, 28)\n",
    "        return pd.Series({'start': start, 'fin': fin})\n",
    "    if date == '25 de enero-29 de febrero (domingo anterior a Carnaval)':\n",
    "        start = datetime(2023, 1, 25)\n",
    "        fin = datetime(2023, 2, 28)\n",
    "        return pd.Series({'start': start, 'fin': fin})\n",
    "    if date == '29 de enero-4 de marzo al 5 de febrero-11 de marzo (Carnaval)':\n",
    "        start = datetime(2023, 1, 29)\n",
    "        fin = datetime(2023, 3, 11)\n",
    "        return pd.Series({'start': start, 'fin': fin})       \n",
    "    if date == '30 de enero-5 de marzo al 3 de febrero-9 de marzo (Carnaval)':\n",
    "        start = datetime(2023, 1, 30)\n",
    "        fin = datetime(2023, 3, 9)\n",
    "        return pd.Series({'start': start, 'fin': fin})\n",
    "    if date == '30 de enero-5 de marzo al 7 de febrero-13 de marzo (Carnaval)':\n",
    "        start = datetime(2023, 1, 30)\n",
    "        fin = datetime(2023, 3, 13)\n",
    "        return pd.Series({'start': start, 'fin': fin})\n",
    "    if date == '1-7 al 4-10 de febrero':\n",
    "        start = datetime(2023, 2, 7)\n",
    "        fin = datetime(2023, 2, 10)\n",
    "        return pd.Series({'start': start, 'fin': fin})\n",
    "    if date == 'Fin de semana próximo al 14 de febrero':\n",
    "        start = datetime(2023, 2, 17)\n",
    "        fin = datetime(2023, 2, 18)\n",
    "        return pd.Series({'start': start, 'fin': fin})\n",
    "    if date == 'Febrero':\n",
    "        start = datetime(2023, 2, 1)\n",
    "        fin = datetime(2023, 2, 28)\n",
    "        return pd.Series({'start': start, 'fin': fin})  \n",
    "    if date == 'Primer domingo de marzo':\n",
    "        start = datetime(2023, 3, 4)\n",
    "        fin = datetime(2023, 3, 5)\n",
    "        return pd.Series({'start': start, 'fin': fin})    \n",
    "    if date == 'Algunos sábados y todos los domingos y festivos desde el inicio de la Cuaresma hasta la primera semana de mayo (excepto Domingo de Ramos, Viernes Santo y Lunes de Pascua)':\n",
    "        start = datetime(2023, 4, 2)\n",
    "        fin = datetime(2023, 4, 14)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Del 15 al 19 de marzo':\n",
    "        start = datetime(2023, 3, 15)\n",
    "        fin = datetime(2023, 3, 19)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Del 14 al 19 de marzo':\n",
    "        start = datetime(2023, 3, 14)\n",
    "        fin = datetime(2023, 3, 19)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Del 15 al 31 de marzo':\n",
    "        start = datetime(2023, 4, 15)\n",
    "        fin = datetime(2023, 4, 30)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Fin de semana cercano al 28 de marzo':\n",
    "        start = datetime(2023, 3, 24)\n",
    "        fin = datetime(2023, 3, 25)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Abril':\n",
    "        start = datetime(2023, 4, 1)\n",
    "        fin = datetime(2023, 4, 30)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == 'Del segundo lunes al tercer domingo de abril':\n",
    "        start = datetime(2023, 4, 17)\n",
    "        fin = datetime(2023, 4, 17)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Domingo de Ramos':\n",
    "        start = datetime(2023, 4, 2)\n",
    "        fin = datetime(2023, 4, 2)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Jueves y Viernes Santo':\n",
    "        start = datetime(2023, 4, 7)\n",
    "        fin = datetime(2023, 4, 10)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == 'Domingo de Ramos, Jueves y Viernes Santo':\n",
    "        start = datetime(2023, 4, 2)\n",
    "        fin = datetime(2023, 4, 10)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Viernes Santo':\n",
    "        start = datetime(2023, 4, 7)\n",
    "        fin = datetime(2023, 4, 7)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Sábado Santo':\n",
    "        start = datetime(2023, 4, 8)\n",
    "        fin = datetime(2023, 4, 8)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == 'Domingo de Resurrección':\n",
    "        start = datetime(2023, 4, 9)\n",
    "        fin = datetime(2023, 4, 9)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Semana Santa':\n",
    "        start = datetime(2023, 4, 2)\n",
    "        fin = datetime(2023, 4, 9)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Miércoles Santo':\n",
    "        start = datetime(2023, 4, 5)\n",
    "        fin = datetime(2023, 4, 5)\n",
    "        return pd.Series({'start': start, 'fin': fin})    \n",
    "    if date == 'Sábado posterior a Semana Santa':\n",
    "        start = datetime(2023, 4, 1)\n",
    "        fin = datetime(2023, 4, 1)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Del 22 al 25 de abril':\n",
    "        start = datetime(2023, 4, 22)\n",
    "        fin = datetime(2023, 4, 25)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == '27 de abril':\n",
    "        start = datetime(2023, 4, 27)\n",
    "        fin = datetime(2023, 4, 27)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Último fin de semana de abril':\n",
    "        start = datetime(2023, 4, 28)\n",
    "        fin = datetime(2023, 4, 29)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Último domingo de abril':\n",
    "        start = datetime(2023, 4, 29)\n",
    "        fin = datetime(2023, 4, 29)\n",
    "        return pd.Series({'start': start, 'fin': fin})         \n",
    "    if date == 'Primera quincena de mayo':\n",
    "        start = datetime(2023, 5, 1)\n",
    "        fin = datetime(2023, 5, 15)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Del 30 de abril al 1 de mayo':\n",
    "        start = datetime(2023, 4, 30)\n",
    "        fin = datetime(2023, 5, 1)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == 'Del 30 de abril al 6 de mayo':\n",
    "        start = datetime(2023, 4, 30)\n",
    "        fin = datetime(2023, 5, 6)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == '2 de mayo':\n",
    "        start = datetime(2023, 5, 2)\n",
    "        fin = datetime(2023, 5, 2)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Primer viernes de mayo':\n",
    "        start = datetime(2023, 5, 4)\n",
    "        fin = datetime(2023, 5, 4)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Primer fin de semana de mayo':\n",
    "        start = datetime(2023, 5, 6)\n",
    "        fin = datetime(2023, 5, 7)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Del 2 al 3 de mayo':\n",
    "        start = datetime(2023, 5, 2)\n",
    "        fin = datetime(2023, 5, 3)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == 'Primer domingo de mayo':\n",
    "        start = datetime(2023, 4, 30)\n",
    "        fin = datetime(2023, 5, 6)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == '2 de mayo':\n",
    "        start = datetime(2023, 5, 2)\n",
    "        fin = datetime(2023, 5, 2)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Primer viernes de mayo':\n",
    "        start = datetime(2023, 5, 1)\n",
    "        fin = datetime(2023, 5, 1)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Segunda o tercera semana de mayo':\n",
    "        start = datetime(2023, 5, 8)\n",
    "        fin = datetime(2023, 5, 14)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Domingo de Pentecostés':\n",
    "        start = datetime(2023, 5, 28)\n",
    "        fin = datetime(2023, 5, 28)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == 'Lunes de Pentecostés':\n",
    "        start = datetime(2023, 5, 29)\n",
    "        fin = datetime(2023, 5, 29)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == '26 de mayo':\n",
    "        start = datetime(2023, 5, 26)\n",
    "        fin = datetime(2023, 5, 26)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Última semana de mayo':\n",
    "        start = datetime(2023, 5, 22)\n",
    "        fin = datetime(2023, 5, 28)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Última semana de mayo-primera semana de junio':\n",
    "        start = datetime(2023, 5, 29)\n",
    "        fin = datetime(2023, 6, 4)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Del 9 al 11 de junio':\n",
    "        start = datetime(2023, 6, 9)\n",
    "        fin = datetime(2023, 6, 11)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == 'Ocho días después de Corpus Christi':\n",
    "        start = datetime(2023, 6, 9)\n",
    "        fin = datetime(2023, 6, 17)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Mediados de junio':\n",
    "        start = datetime(2023, 6, 15)\n",
    "        fin = datetime(2023, 6, 17)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Tercer fin de semana de junio':\n",
    "        start = datetime(2023, 6, 19)\n",
    "        fin = datetime(2023, 6, 25)\n",
    "        return pd.Series({'start': start, 'fin': fin})      \n",
    "    if date == 'Del 24 al 29 de junio':\n",
    "        start = datetime(2023,6, 24)\n",
    "        fin = datetime(2023, 6, 29)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Corpus Christi':\n",
    "        start = datetime(2023, 6, 8)\n",
    "        fin = datetime(2023, 6, 8)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == '24 de junio':\n",
    "        start = datetime(2023, 6, 24)\n",
    "        fin = datetime(2023, 6, 24)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'julio-agosto':\n",
    "        start = datetime(2023, 7, 25)\n",
    "        fin = datetime(2023, 8, 5)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Primer sábado de julio':\n",
    "        start = datetime(2023, 7, 1)\n",
    "        fin = datetime(2023, 7, 1)\n",
    "        return pd.Series({'start': start, 'fin': fin})        \n",
    "    if date == 'Del 4 al 12 de julio':\n",
    "        start = datetime(2023, 7, 4)\n",
    "        fin = datetime(2023, 7, 12)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Segundo fin de semana de julio':\n",
    "        start = datetime(2023, 7, 7)\n",
    "        fin = datetime(2023, 7, 8)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == 'Semana en torno al 17 de julio':\n",
    "        start = datetime(2023, 7, 15)\n",
    "        fin = datetime(2023, 7, 17)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Segunda quincena de julio':\n",
    "        start = datetime(2023, 7, 15)\n",
    "        fin = datetime(2023, 7, 30)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Último sábado de julio':\n",
    "        start = datetime(2023, 7, 29)\n",
    "        fin = datetime(2023, 7, 29)\n",
    "        return pd.Series({'start': start, 'fin': fin})        \n",
    "    if date == 'Semana entorno al 25 de julio':\n",
    "        start = datetime(2023, 7, 22)\n",
    "        fin = datetime(2023, 7, 25)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'En julio, cada cinco años':\n",
    "        start = datetime(2023, 7, 22)\n",
    "        fin = datetime(2023, 7, 27)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == 'Agosto':\n",
    "        start = datetime(2023, 8, 1)\n",
    "        fin = datetime(2023, 8, 15)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Primer sábado de agosto':\n",
    "        start = datetime(2023, 8, 5)\n",
    "        fin = datetime(2023, 8, 5)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Primer domingo de agosto':\n",
    "        start = datetime(2023, 8, 6)\n",
    "        fin = datetime(2023, 8, 6)\n",
    "        return pd.Series({'start': start, 'fin': fin})        \n",
    "    if date == 'Primera semana de agosto':\n",
    "        start = datetime(2023, 8, 7)\n",
    "        fin = datetime(2023, 8, 13)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Primera semana de agosto en los años impares, en los años pares se celebra en Oloron-Sainte-Marie':\n",
    "        start = datetime(2023, 8, 7)\n",
    "        fin = datetime(2023, 8, 14)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == 'Principios de agosto':\n",
    "        start = datetime(2023, 8, 1)\n",
    "        fin = datetime(2023, 8, 10)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == '6 de agosto':\n",
    "        start = datetime(2023, 8, 6)\n",
    "        fin = datetime(2023, 8, 6)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Del 9 al 15 de agosto':\n",
    "        start = datetime(2023, 8, 9)\n",
    "        fin = datetime(2023, 8, 15)\n",
    "        return pd.Series({'start': start, 'fin': fin})\n",
    "    if date == 'Del 14 al 17 de agosto':\n",
    "        start = datetime(2023, 8, 14)\n",
    "        fin = datetime(2023, 8, 17)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Del 14 al 21 de agosto':\n",
    "        start = datetime(2023, 8, 14)\n",
    "        fin = datetime(2023, 8, 21)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == 'Segundo domingo de agosto':\n",
    "        start = datetime(2023, 8, 15)\n",
    "        fin = datetime(2023, 8, 15)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == '15 de agosto':\n",
    "        start = datetime(2023, 8, 15)\n",
    "        fin = datetime(2023, 8, 15)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == '16 de agosto':\n",
    "        start = datetime(2023, 8, 16)\n",
    "        fin = datetime(2023, 8, 16)\n",
    "        return pd.Series({'start': start, 'fin': fin})    \n",
    "    if date == 'Segunda quincena de agosto':\n",
    "        start = datetime(2023, 8, 15)\n",
    "        fin = datetime(2023, 8, 30)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Del 20 al 23 de agosto':\n",
    "        start = datetime(2023, 8, 20)\n",
    "        fin = datetime(2023, 8, 23)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == 'Tercer sábado de agosto':\n",
    "        start = datetime(2023, 8, 19)\n",
    "        fin = datetime(2023, 8, 19)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Tercer domingo de agosto, cada 6 años':\n",
    "        start = datetime(2023, 8, 22)\n",
    "        fin = datetime(2023, 8, 22)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == '27 de agosto':\n",
    "        start = datetime(2023, 8, 27)\n",
    "        fin = datetime(2023, 8, 27)\n",
    "        return pd.Series({'start': start, 'fin': fin})    \n",
    "    if date == 'Último viernes de agosto':\n",
    "        start = datetime(2023, 8, 25)\n",
    "        fin = datetime(2023, 8, 25)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Último viernes y sábado de agosto':\n",
    "        start = datetime(2023, 8, 25)\n",
    "        fin = datetime(2023, 8, 26)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == 'Última semana de agosto':\n",
    "        start = datetime(2023, 8, 23)\n",
    "        fin = datetime(2023, 8, 29)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Último domingo de agosto':\n",
    "        start = datetime(2023, 8, 29)\n",
    "        fin = datetime(2023, 8, 29)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Madrugada siguiente al último domingo de agosto':\n",
    "        start = datetime(2023, 8, 30)\n",
    "        fin = datetime(2023, 8, 30)\n",
    "        return pd.Series({'start': start, 'fin': fin})    \n",
    "    if date == 'Último fin de semana deagosto y primer fin de semana de septiembre':\n",
    "        start = datetime(2023, 8, 30)\n",
    "        fin = datetime(2023, 9, 3)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == '5-8 de septiembre':\n",
    "        start = datetime(2023, 9, 5)\n",
    "        fin = datetime(2023, 9, 8)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == '8 de septiembre':\n",
    "        start = datetime(2023, 9, 8)\n",
    "        fin = datetime(2023, 9, 8)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Del 4 al 9 de septiembre':\n",
    "        start = datetime(2023, 9, 4)\n",
    "        fin = datetime(2023, 9, 9)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Primera quincena de septiembre':\n",
    "        start = datetime(2023, 9, 1)\n",
    "        fin = datetime(2023, 9, 15)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == '8 y 9 de septiembre':\n",
    "        start = datetime(2023, 9, 8)\n",
    "        fin = datetime(2023, 9, 9)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Segundo domingo de septiembre':\n",
    "        start = datetime(2023, 9, 10)\n",
    "        fin = datetime(2023, 9, 10)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == 'Del 12 al 15 de septiembre':\n",
    "        start = datetime(2023, 9, 12)\n",
    "        fin = datetime(2023, 9, 15)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Del 15 al 24 de septiembre':\n",
    "        start = datetime(2023, 9, 15)\n",
    "        fin = datetime(2023, 9, 24)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == '19 de septiembre':\n",
    "        start = datetime(2023, 9, 19)\n",
    "        fin = datetime(2023, 9, 19)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == 'Del 20 al 26 de septiembre':\n",
    "        start = datetime(2023, 9, 20)\n",
    "        fin = datetime(2023, 9, 26)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == '24 de septiembre':\n",
    "        start = datetime(2023, 9, 24)\n",
    "        fin = datetime(2023, 9, 24)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == '27 de septiembre':\n",
    "        start = datetime(2023, 9, 27)\n",
    "        fin = datetime(2023, 9, 27)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'En torno al 27 de septiembre':\n",
    "        start = datetime(2023, 9, 25)\n",
    "        fin = datetime(2023, 9, 27)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Último sábado de septiembre':\n",
    "        start = datetime(2023, 9, 30)\n",
    "        fin = datetime(2023, 9, 30)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == 'Otoño':\n",
    "        start = datetime(2023, 9, 15)\n",
    "        fin = datetime(2023, 10, 15)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Octubre':\n",
    "        start = datetime(2023, 10, 1)\n",
    "        fin = datetime(2023, 10, 15)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == 'Principios de octubre':\n",
    "        start = datetime(2023, 10, 1)\n",
    "        fin = datetime(2023, 10, 10)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Del 4 al 12 de octubre':\n",
    "        start = datetime(2023, 10, 4)\n",
    "        fin = datetime(2023, 10, 12)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Semana en torno al 9 de octubre':\n",
    "        start = datetime(2023, 10, 6)\n",
    "        fin = datetime(2023, 10, 9)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == '12 de octubre':\n",
    "        start = datetime(2023, 9, 12)\n",
    "        fin = datetime(2023, 10, 12)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Segunda quincena de octubre':\n",
    "        start = datetime(2023, 10, 16)\n",
    "        fin = datetime(2023, 10, 30)\n",
    "        return pd.Series({'start': start, 'fin': fin}) \n",
    "    if date == 'Noviembre':\n",
    "        start = datetime(2023, 11, 1)\n",
    "        fin = datetime(2023, 11, 10)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == '1 de noviembre':\n",
    "        start = datetime(2023, 11, 1)\n",
    "        fin = datetime(2023, 11, 1)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Fin de semana más cercano al 1 de noviembre':\n",
    "        start = datetime(2023, 11, 3)\n",
    "        fin = datetime(2023, 11, 5)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == '30 de noviembre-8 de diciembre':\n",
    "        start = datetime(2023, 11, 30)\n",
    "        fin = datetime(2023, 12, 8)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    if date == 'Del 5 al 8 de diciembre':\n",
    "        start = datetime(2023, 12, 5)\n",
    "        fin = datetime(2023, 12, 8)\n",
    "        return pd.Series({'start': start, 'fin': fin})     \n",
    "    \n",
    "    else:\n",
    "        return pd.Series({'start': None, 'fin': None})\n",
    "\n",
    "data = pd.concat([data, data['date_start'].apply(add_carnival_dates)], axis=1)\n",
    "data['start'] = pd.to_datetime(data['start'])\n",
    "data['fin'] = pd.to_datetime(data['fin'])\n",
    "\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "19b3c683",
   "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>festival</th>\n",
       "      <th>localidad</th>\n",
       "      <th>est</th>\n",
       "      <th>prov</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>start</th>\n",
       "      <th>fin</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>El Bautizo del Niño</td>\n",
       "      <td>Palencia</td>\n",
       "      <td>2015</td>\n",
       "      <td>Palencia</td>\n",
       "      <td>42.01667</td>\n",
       "      <td>-4.53333</td>\n",
       "      <td>2023-01-01</td>\n",
       "      <td>2023-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>La Vijanera</td>\n",
       "      <td>Silió</td>\n",
       "      <td>2009</td>\n",
       "      <td>Cantabria</td>\n",
       "      <td>43.14806</td>\n",
       "      <td>-4.02139</td>\n",
       "      <td>2023-01-02</td>\n",
       "      <td>2023-01-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Cabalgata de Reyes Magos de Alcoy</td>\n",
       "      <td>Alcoy</td>\n",
       "      <td>2001</td>\n",
       "      <td>Alicante</td>\n",
       "      <td>38.69833</td>\n",
       "      <td>-0.47361</td>\n",
       "      <td>2023-01-05</td>\n",
       "      <td>2023-01-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Auto Sacramental y Cabalgata de Reyes</td>\n",
       "      <td>Santillana del Mar</td>\n",
       "      <td>2009</td>\n",
       "      <td>Cantabria</td>\n",
       "      <td>43.39333</td>\n",
       "      <td>-4.10472</td>\n",
       "      <td>2023-01-05</td>\n",
       "      <td>2023-01-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Fiestas de San Antón y Carrera Urbana Internac...</td>\n",
       "      <td>Jaén</td>\n",
       "      <td>2019</td>\n",
       "      <td>Jaén</td>\n",
       "      <td>37.76972</td>\n",
       "      <td>-3.78889</td>\n",
       "      <td>2023-01-15</td>\n",
       "      <td>2023-01-16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            festival           localidad  \\\n",
       "0                                El Bautizo del Niño            Palencia   \n",
       "1                                        La Vijanera               Silió   \n",
       "2                  Cabalgata de Reyes Magos de Alcoy               Alcoy   \n",
       "3              Auto Sacramental y Cabalgata de Reyes  Santillana del Mar   \n",
       "4  Fiestas de San Antón y Carrera Urbana Internac...                Jaén   \n",
       "\n",
       "    est       prov  latitude longitude      start        fin  \n",
       "0  2015   Palencia  42.01667  -4.53333 2023-01-01 2023-01-01  \n",
       "1  2009  Cantabria  43.14806  -4.02139 2023-01-02 2023-01-08  \n",
       "2  2001   Alicante  38.69833  -0.47361 2023-01-05 2023-01-05  \n",
       "3  2009  Cantabria  43.39333  -4.10472 2023-01-05 2023-01-05  \n",
       "4  2019       Jaén  37.76972  -3.78889 2023-01-15 2023-01-16  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = data.drop(columns=['date_start'])\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "b6270c9c",
   "metadata": {},
   "outputs": [],
   "source": [
    "data.to_csv(r'C:\\WORK_IAAC\\submissions\\Storytelling\\fiesta_shapefiles\\fiestas_national_fin.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c210f0a6",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}