storytelling_7_convert dates.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "942a7c94",
   "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>fiesta</th>\n",
       "      <th>date_start2023</th>\n",
       "      <th>date_fin2023</th>\n",
       "      <th>localidad</th>\n",
       "      <th>provincia</th>\n",
       "      <th>comunidad</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "      <th>visitors 2022</th>\n",
       "      <th>mlneuro_budget</th>\n",
       "      <th>mlneuro_revenue 2022</th>\n",
       "      <th>average ticket 2022</th>\n",
       "      <th>web</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Primavera sound Barcelona</td>\n",
       "      <td>01/06/2023</td>\n",
       "      <td>10/06/2023</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Catalonia</td>\n",
       "      <td>41.411459</td>\n",
       "      <td>2.224658</td>\n",
       "      <td>505700</td>\n",
       "      <td>50.00</td>\n",
       "      <td>349.0</td>\n",
       "      <td>325</td>\n",
       "      <td>https://www.primaverasound.com/en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Mad Cool Festival</td>\n",
       "      <td>06/07/2023</td>\n",
       "      <td>08/07/2023</td>\n",
       "      <td>Madrid</td>\n",
       "      <td>Madrid</td>\n",
       "      <td>Madrid</td>\n",
       "      <td>40.467830</td>\n",
       "      <td>-3.617307</td>\n",
       "      <td>310000</td>\n",
       "      <td>3.40</td>\n",
       "      <td>80.0</td>\n",
       "      <td>189</td>\n",
       "      <td>https://madcoolfestival.es</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Sonar</td>\n",
       "      <td>15/07/2023</td>\n",
       "      <td>17/07/2023</td>\n",
       "      <td>L'Hospitalet</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Catalonia</td>\n",
       "      <td>41.354694</td>\n",
       "      <td>2.127825</td>\n",
       "      <td>120000</td>\n",
       "      <td>9.45</td>\n",
       "      <td>43.0</td>\n",
       "      <td>180</td>\n",
       "      <td>https://sonar.es/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bilbao BBK Live</td>\n",
       "      <td>06/07/2023</td>\n",
       "      <td>08/07/2023</td>\n",
       "      <td>Bilbao</td>\n",
       "      <td>Bilbao</td>\n",
       "      <td>Basque Country</td>\n",
       "      <td>43.258076</td>\n",
       "      <td>-2.963625</td>\n",
       "      <td>115000</td>\n",
       "      <td>10.00</td>\n",
       "      <td>42.0</td>\n",
       "      <td>175</td>\n",
       "      <td>https://www.bilbaobbklive.com/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BIF: Festival International de Benicassim</td>\n",
       "      <td>13/07/2023</td>\n",
       "      <td>16/07/2023</td>\n",
       "      <td>Benicassim</td>\n",
       "      <td>Castellon de la Plana</td>\n",
       "      <td>Valenciana</td>\n",
       "      <td>40.056978</td>\n",
       "      <td>0.071053</td>\n",
       "      <td>180000</td>\n",
       "      <td>8.00</td>\n",
       "      <td>46.0</td>\n",
       "      <td>120</td>\n",
       "      <td>https://fiberfib.com/</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      fiesta date_start2023 date_fin2023  \\\n",
       "0                  Primavera sound Barcelona     01/06/2023   10/06/2023   \n",
       "1                          Mad Cool Festival     06/07/2023   08/07/2023   \n",
       "2                                      Sonar     15/07/2023   17/07/2023   \n",
       "3                            Bilbao BBK Live     06/07/2023   08/07/2023   \n",
       "4  BIF: Festival International de Benicassim     13/07/2023   16/07/2023   \n",
       "\n",
       "      localidad              provincia       comunidad        lat       lng  \\\n",
       "0     Barcelona              Barcelona       Catalonia  41.411459  2.224658   \n",
       "1        Madrid                 Madrid          Madrid  40.467830 -3.617307   \n",
       "2  L'Hospitalet              Barcelona       Catalonia  41.354694  2.127825   \n",
       "3        Bilbao                 Bilbao  Basque Country  43.258076 -2.963625   \n",
       "4    Benicassim  Castellon de la Plana      Valenciana  40.056978  0.071053   \n",
       "\n",
       "   visitors 2022  mlneuro_budget  mlneuro_revenue 2022  average ticket 2022  \\\n",
       "0         505700           50.00                 349.0                  325   \n",
       "1         310000            3.40                  80.0                  189   \n",
       "2         120000            9.45                  43.0                  180   \n",
       "3         115000           10.00                  42.0                  175   \n",
       "4         180000            8.00                  46.0                  120   \n",
       "\n",
       "                                 web  \n",
       "0  https://www.primaverasound.com/en  \n",
       "1         https://madcoolfestival.es  \n",
       "2                  https://sonar.es/  \n",
       "3     https://www.bilbaobbklive.com/  \n",
       "4              https://fiberfib.com/  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "data = pd.read_csv(r'C:\\WORK_IAAC\\submissions\\Storytelling\\fiesta_shapefiles\\top music festivals Spain.csv')\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "64dff871",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 26 entries, 0 to 25\n",
      "Data columns (total 13 columns):\n",
      " #   Column                Non-Null Count  Dtype  \n",
      "---  ------                --------------  -----  \n",
      " 0   fiesta                26 non-null     object \n",
      " 1   date_start2023        26 non-null     object \n",
      " 2   date_fin2023          26 non-null     object \n",
      " 3   localidad             26 non-null     object \n",
      " 4   provincia             26 non-null     object \n",
      " 5   comunidad             26 non-null     object \n",
      " 6   lat                   26 non-null     float64\n",
      " 7   lng                   26 non-null     float64\n",
      " 8   visitors 2022         26 non-null     int64  \n",
      " 9   mlneuro_budget        26 non-null     float64\n",
      " 10  mlneuro_revenue 2022  26 non-null     float64\n",
      " 11  average ticket 2022   26 non-null     int64  \n",
      " 12  web                   26 non-null     object \n",
      "dtypes: float64(4), int64(2), object(7)\n",
      "memory usage: 2.8+ KB\n"
     ]
    }
   ],
   "source": [
    "data.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "f27ae96f",
   "metadata": {},
   "outputs": [],
   "source": [
    "from datetime import datetime\n",
    "data['start'] = pd.to_datetime(data['date_start2023'], format='%d/%m/%Y')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "57231798",
   "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>fiesta</th>\n",
       "      <th>localidad</th>\n",
       "      <th>provincia</th>\n",
       "      <th>comunidad</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "      <th>visitors 2022</th>\n",
       "      <th>mlneuro_budget</th>\n",
       "      <th>mlneuro_revenue 2022</th>\n",
       "      <th>average ticket 2022</th>\n",
       "      <th>web</th>\n",
       "      <th>start</th>\n",
       "      <th>end</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Primavera sound Barcelona</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Catalonia</td>\n",
       "      <td>41.411459</td>\n",
       "      <td>2.224658</td>\n",
       "      <td>505700</td>\n",
       "      <td>50.00</td>\n",
       "      <td>349.0</td>\n",
       "      <td>325</td>\n",
       "      <td>https://www.primaverasound.com/en</td>\n",
       "      <td>2023-06-01</td>\n",
       "      <td>2023-06-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Mad Cool Festival</td>\n",
       "      <td>Madrid</td>\n",
       "      <td>Madrid</td>\n",
       "      <td>Madrid</td>\n",
       "      <td>40.467830</td>\n",
       "      <td>-3.617307</td>\n",
       "      <td>310000</td>\n",
       "      <td>3.40</td>\n",
       "      <td>80.0</td>\n",
       "      <td>189</td>\n",
       "      <td>https://madcoolfestival.es</td>\n",
       "      <td>2023-07-06</td>\n",
       "      <td>2023-07-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Sonar</td>\n",
       "      <td>L'Hospitalet</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Catalonia</td>\n",
       "      <td>41.354694</td>\n",
       "      <td>2.127825</td>\n",
       "      <td>120000</td>\n",
       "      <td>9.45</td>\n",
       "      <td>43.0</td>\n",
       "      <td>180</td>\n",
       "      <td>https://sonar.es/</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>2023-07-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bilbao BBK Live</td>\n",
       "      <td>Bilbao</td>\n",
       "      <td>Bilbao</td>\n",
       "      <td>Basque Country</td>\n",
       "      <td>43.258076</td>\n",
       "      <td>-2.963625</td>\n",
       "      <td>115000</td>\n",
       "      <td>10.00</td>\n",
       "      <td>42.0</td>\n",
       "      <td>175</td>\n",
       "      <td>https://www.bilbaobbklive.com/</td>\n",
       "      <td>2023-07-06</td>\n",
       "      <td>2023-07-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BIF: Festival International de Benicassim</td>\n",
       "      <td>Benicassim</td>\n",
       "      <td>Castellon de la Plana</td>\n",
       "      <td>Valenciana</td>\n",
       "      <td>40.056978</td>\n",
       "      <td>0.071053</td>\n",
       "      <td>180000</td>\n",
       "      <td>8.00</td>\n",
       "      <td>46.0</td>\n",
       "      <td>120</td>\n",
       "      <td>https://fiberfib.com/</td>\n",
       "      <td>2023-07-13</td>\n",
       "      <td>2023-07-16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      fiesta     localidad  \\\n",
       "0                  Primavera sound Barcelona     Barcelona   \n",
       "1                          Mad Cool Festival        Madrid   \n",
       "2                                      Sonar  L'Hospitalet   \n",
       "3                            Bilbao BBK Live        Bilbao   \n",
       "4  BIF: Festival International de Benicassim    Benicassim   \n",
       "\n",
       "               provincia       comunidad        lat       lng  visitors 2022  \\\n",
       "0              Barcelona       Catalonia  41.411459  2.224658         505700   \n",
       "1                 Madrid          Madrid  40.467830 -3.617307         310000   \n",
       "2              Barcelona       Catalonia  41.354694  2.127825         120000   \n",
       "3                 Bilbao  Basque Country  43.258076 -2.963625         115000   \n",
       "4  Castellon de la Plana      Valenciana  40.056978  0.071053         180000   \n",
       "\n",
       "   mlneuro_budget  mlneuro_revenue 2022  average ticket 2022  \\\n",
       "0           50.00                 349.0                  325   \n",
       "1            3.40                  80.0                  189   \n",
       "2            9.45                  43.0                  180   \n",
       "3           10.00                  42.0                  175   \n",
       "4            8.00                  46.0                  120   \n",
       "\n",
       "                                 web      start        end  \n",
       "0  https://www.primaverasound.com/en 2023-06-01 2023-06-10  \n",
       "1         https://madcoolfestival.es 2023-07-06 2023-07-08  \n",
       "2                  https://sonar.es/ 2023-07-15 2023-07-17  \n",
       "3     https://www.bilbaobbklive.com/ 2023-07-06 2023-07-08  \n",
       "4              https://fiberfib.com/ 2023-07-13 2023-07-16  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['end'] = pd.to_datetime(data['date_fin2023'], format='%d/%m/%Y')\n",
    "data = data.drop(columns=['date_start2023','date_fin2023'])\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "3542be99",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 26 entries, 0 to 25\n",
      "Data columns (total 13 columns):\n",
      " #   Column                Non-Null Count  Dtype         \n",
      "---  ------                --------------  -----         \n",
      " 0   fiesta                26 non-null     object        \n",
      " 1   localidad             26 non-null     object        \n",
      " 2   provincia             26 non-null     object        \n",
      " 3   comunidad             26 non-null     object        \n",
      " 4   lat                   26 non-null     float64       \n",
      " 5   lng                   26 non-null     float64       \n",
      " 6   visitors 2022         26 non-null     int64         \n",
      " 7   mlneuro_budget        26 non-null     float64       \n",
      " 8   mlneuro_revenue 2022  26 non-null     float64       \n",
      " 9   average ticket 2022   26 non-null     int64         \n",
      " 10  web                   26 non-null     object        \n",
      " 11  start                 26 non-null     datetime64[ns]\n",
      " 12  end                   26 non-null     datetime64[ns]\n",
      "dtypes: datetime64[ns](2), float64(4), int64(2), object(5)\n",
      "memory usage: 2.8+ KB\n"
     ]
    }
   ],
   "source": [
    "data.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "30d564e8",
   "metadata": {},
   "outputs": [],
   "source": [
    "data.to_csv(r'C:\\WORK_IAAC\\submissions\\Storytelling\\fiesta_shapefiles\\top music festivals Spain.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "fef373fb",
   "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
}