update_df.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "c54fe9c2-13eb-47ee-a7e4-9a78ce09735a",
   "metadata": {},
   "source": [
    "# El siguiente script tiene por finalidad actualizar un dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "3902f67b-5a53-4b85-8a6a-758ab50c7bfb",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "15529b0d-219d-4527-a447-a97c96a5d6f1",
   "metadata": {},
   "source": [
    "## Crear una nueva fila de datos\n",
    "\n",
    "Como se podra notar, se trata de un diccionario compuesto por llave y valor"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "7bb5d105-900e-4d2c-a558-bd71e3145837",
   "metadata": {},
   "outputs": [],
   "source": [
    "new_row = {'Fecha': '2023-02-01',\n",
    "           'Hora_inicio': '09:00:00',\n",
    "           'Hora_de_finalización': '10:15:50',\n",
    "           'Duración_sesion': '01:15:50',\n",
    "           'Tipo_entrenamiento': 'Estilos',\n",
    "           'Objetivos': 'Mejorar Tecnica',\n",
    "           'Metas': 'Mejorar rendimiento',\n",
    "           'Metros_piscina': 20,\n",
    "           'Metros_totales': 1920,\n",
    "           'Cantidad_de_brazadas': 1382,\n",
    "           'Frecuencia_cardíaca': 124,\n",
    "           'Calorías_quemadas': 625,\n",
    "           'Tiempo_estilo_espalda': '00:20:00',\n",
    "           'Metros_estilo_espalda': 600,\n",
    "           'Repeticiones_estilo_espalda': 5,\n",
    "           'Tiempo_estilo_pecho': '00:21:00',\n",
    "           'Metros_estilo_pecho': 600,\n",
    "           'Repeticiones_estilo_pecho': 5,\n",
    "           'Tiempo_estilo_crawl': '00:36:50',\n",
    "           'Metros_estilo_crawl': 720,\n",
    "           'Repeticiones_estilo_crawl': 5,\n",
    "           'Descanso_entre_series': '00:00:00',\n",
    "           'Ritmo_promedio': 3.6,\n",
    "           'Vueltas': 96,\n",
    "           'Tiempo_ingesta_previa': '00:40:00',\n",
    "           'Ingesta_descripcion': 'Cafe, pan, clara huevo',\n",
    "           'Suplemento_dietario': 'Creatina',\n",
    "           'Ejercicios_previos': 'Caminata',\n",
    "           'Tiempo_ejercicios_previos': '00:00:10',\n",
    "           'Sensaciones_entrenamiento': 'Muy buenas'}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "745c21f7-123d-4dfd-8682-dfc3fdcbedb5",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Crear un dataframe temporal a partir de los datos existentes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "11fac068-4c57-48fb-88a4-a6e53bd7509d",
   "metadata": {},
   "outputs": [],
   "source": [
    "temp = pd.DataFrame([new_row])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f13b36e5-a12a-48ba-8ba0-f51fb14bb1ce",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Convertir datos a formato compatible con el dataframe original"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "10d867e2-31fc-4302-8bc0-49927afcf045",
   "metadata": {},
   "outputs": [],
   "source": [
    "temp[['Hora_inicio', 'Hora_de_finalización', 'Duración_sesion', 'Tiempo_estilo_espalda', 'Tiempo_estilo_pecho', 'Tiempo_estilo_crawl', 'Descanso_entre_series', 'Tiempo_ingesta_previa', 'Tiempo_ejercicios_previos']] = temp[['Hora_inicio', 'Hora_de_finalización', 'Duración_sesion', 'Tiempo_estilo_espalda', 'Tiempo_estilo_pecho', 'Tiempo_estilo_crawl', 'Descanso_entre_series', 'Tiempo_ingesta_previa', 'Tiempo_ejercicios_previos']].apply(pd.to_datetime, format='%H:%M:%S', errors='coerce')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "cd2791fe-b5de-43cb-a58d-d6c71803bb6e",
   "metadata": {},
   "outputs": [],
   "source": [
    "temp['Hora_inicio'] = temp['Hora_inicio'].dt.time\n",
    "temp['Hora_de_finalización'] = temp['Hora_de_finalización'].dt.time\n",
    "temp['Duración_sesion'] = temp['Duración_sesion'].dt.time\n",
    "temp['Tiempo_estilo_espalda'] = temp['Tiempo_estilo_espalda'].dt.time\n",
    "temp['Tiempo_estilo_pecho'] = temp['Tiempo_estilo_pecho'].dt.time\n",
    "temp['Tiempo_estilo_crawl'] = temp['Tiempo_estilo_crawl'].dt.time\n",
    "temp['Descanso_entre_series'] = temp['Descanso_entre_series'].dt.time\n",
    "temp['Tiempo_ingesta_previa'] = temp['Tiempo_ingesta_previa'].dt.time\n",
    "temp['Tiempo_ejercicios_previos'] = temp['Tiempo_ejercicios_previos'].dt.time"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d03b4e17-8326-4348-a420-24f8cac90b32",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Cargar dataframe de origen de datos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "4bc25fd0-b789-427d-8b14-f933d92af211",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_excel(\"/home/studio-lab-user/Swimming Data Analysis/Data/natacion_20230131.xlsx\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "231235df-3314-485a-abc1-38fe96d4fef8",
   "metadata": {},
   "outputs": [],
   "source": [
    "df[['Hora_inicio', 'Hora_de_finalización', 'Duración_sesion', 'Tiempo_estilo_espalda', 'Tiempo_estilo_pecho', 'Tiempo_estilo_crawl', 'Descanso_entre_series', 'Tiempo_ingesta_previa', 'Tiempo_ejercicios_previos']] = df[['Hora_inicio', 'Hora_de_finalización', 'Duración_sesion', 'Tiempo_estilo_espalda', 'Tiempo_estilo_pecho', 'Tiempo_estilo_crawl', 'Descanso_entre_series', 'Tiempo_ingesta_previa', 'Tiempo_ejercicios_previos']].apply(pd.to_datetime, format='%H:%M:%S', errors='coerce')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "daf9b3d3-c2e8-44b6-acb1-97528b37a78d",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Hora_inicio'] = df['Hora_inicio'].dt.time\n",
    "df['Hora_de_finalización'] = df['Hora_de_finalización'].dt.time\n",
    "df['Duración_sesion'] = df['Duración_sesion'].dt.time\n",
    "df['Tiempo_estilo_espalda'] = df['Tiempo_estilo_espalda'].dt.time\n",
    "df['Tiempo_estilo_pecho'] = df['Tiempo_estilo_pecho'].dt.time\n",
    "df['Tiempo_estilo_crawl'] = df['Tiempo_estilo_crawl'].dt.time\n",
    "df['Descanso_entre_series'] = df['Descanso_entre_series'].dt.time\n",
    "df['Tiempo_ingesta_previa'] = df['Tiempo_ingesta_previa'].dt.time\n",
    "df['Tiempo_ejercicios_previos'] = df['Tiempo_ejercicios_previos'].dt.time"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0cfc1a74-904a-4123-a985-74c8c38f546d",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Verificar que los formatos de los datos en ambos DataFrames son compatibles"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "d67ef953-e127-4666-8c2b-114fd2598f5d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1 entries, 0 to 0\n",
      "Data columns (total 30 columns):\n",
      " #   Column                       Non-Null Count  Dtype  \n",
      "---  ------                       --------------  -----  \n",
      " 0   Fecha                        1 non-null      object \n",
      " 1   Hora_inicio                  1 non-null      object \n",
      " 2   Hora_de_finalización         1 non-null      object \n",
      " 3   Duración_sesion              1 non-null      object \n",
      " 4   Tipo_entrenamiento           1 non-null      object \n",
      " 5   Objetivos                    1 non-null      object \n",
      " 6   Metas                        1 non-null      object \n",
      " 7   Metros_piscina               1 non-null      int64  \n",
      " 8   Metros_totales               1 non-null      int64  \n",
      " 9   Cantidad_de_brazadas         1 non-null      int64  \n",
      " 10  Frecuencia_cardíaca          1 non-null      int64  \n",
      " 11  Calorías_quemadas            1 non-null      int64  \n",
      " 12  Tiempo_estilo_espalda        1 non-null      object \n",
      " 13  Metros_estilo_espalda        1 non-null      int64  \n",
      " 14  Repeticiones_estilo_espalda  1 non-null      int64  \n",
      " 15  Tiempo_estilo_pecho          1 non-null      object \n",
      " 16  Metros_estilo_pecho          1 non-null      int64  \n",
      " 17  Repeticiones_estilo_pecho    1 non-null      int64  \n",
      " 18  Tiempo_estilo_crawl          1 non-null      object \n",
      " 19  Metros_estilo_crawl          1 non-null      int64  \n",
      " 20  Repeticiones_estilo_crawl    1 non-null      int64  \n",
      " 21  Descanso_entre_series        1 non-null      object \n",
      " 22  Ritmo_promedio               1 non-null      float64\n",
      " 23  Vueltas                      1 non-null      int64  \n",
      " 24  Tiempo_ingesta_previa        1 non-null      object \n",
      " 25  Ingesta_descripcion          1 non-null      object \n",
      " 26  Suplemento_dietario          1 non-null      object \n",
      " 27  Ejercicios_previos           1 non-null      object \n",
      " 28  Tiempo_ejercicios_previos    1 non-null      object \n",
      " 29  Sensaciones_entrenamiento    1 non-null      object \n",
      "dtypes: float64(1), int64(12), object(17)\n",
      "memory usage: 368.0+ bytes\n",
      "None\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 8 entries, 0 to 7\n",
      "Data columns (total 30 columns):\n",
      " #   Column                       Non-Null Count  Dtype  \n",
      "---  ------                       --------------  -----  \n",
      " 0   Fecha                        8 non-null      object \n",
      " 1   Hora_inicio                  8 non-null      object \n",
      " 2   Hora_de_finalización         2 non-null      object \n",
      " 3   Duración_sesion              8 non-null      object \n",
      " 4   Tipo_entrenamiento           8 non-null      object \n",
      " 5   Objetivos                    8 non-null      object \n",
      " 6   Metas                        6 non-null      object \n",
      " 7   Metros_piscina               8 non-null      int64  \n",
      " 8   Metros_totales               8 non-null      int64  \n",
      " 9   Cantidad_de_brazadas         8 non-null      int64  \n",
      " 10  Frecuencia_cardíaca          8 non-null      int64  \n",
      " 11  Calorías_quemadas            8 non-null      int64  \n",
      " 12  Tiempo_estilo_espalda        7 non-null      object \n",
      " 13  Metros_estilo_espalda        7 non-null      float64\n",
      " 14  Repeticiones_estilo_espalda  7 non-null      float64\n",
      " 15  Tiempo_estilo_pecho          7 non-null      object \n",
      " 16  Metros_estilo_pecho          7 non-null      float64\n",
      " 17  Repeticiones_estilo_pecho    7 non-null      float64\n",
      " 18  Tiempo_estilo_crawl          7 non-null      object \n",
      " 19  Metros_estilo_crawl          6 non-null      float64\n",
      " 20  Repeticiones_estilo_crawl    7 non-null      float64\n",
      " 21  Descanso_entre_series        8 non-null      object \n",
      " 22  Ritmo_promedio               8 non-null      float64\n",
      " 23  Vueltas                      8 non-null      int64  \n",
      " 24  Tiempo_ingesta_previa        8 non-null      object \n",
      " 25  Ingesta_descripcion          8 non-null      object \n",
      " 26  Suplemento_dietario          8 non-null      object \n",
      " 27  Ejercicios_previos           8 non-null      object \n",
      " 28  Tiempo_ejercicios_previos    8 non-null      object \n",
      " 29  Sensaciones_entrenamiento    8 non-null      object \n",
      "dtypes: float64(7), int64(6), object(17)\n",
      "memory usage: 2.0+ KB\n",
      "None\n"
     ]
    }
   ],
   "source": [
    "print(temp.info())\n",
    "print(df.info())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "6f2a03f2-1884-49b9-9425-063e6ca3d038",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.drop(\"Unnamed: 0\", axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8341e05a-988a-42a5-9f41-a5488e1fceec",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Correccion tipo de datos\n",
    "# temp[''] = temp[''].astype()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "cd8a3c10-f64a-4dff-9f0e-d80e3e6ab32b",
   "metadata": {},
   "outputs": [],
   "source": [
    "temp['Metros_estilo_espalda'] = temp['Metros_estilo_espalda'].astype(np.float64)\n",
    "temp['Repeticiones_estilo_espalda'] = temp['Repeticiones_estilo_espalda'].astype(np.float64)\n",
    "temp['Metros_estilo_pecho'] = temp['Metros_estilo_pecho'].astype(np.float64)\n",
    "temp['Repeticiones_estilo_pecho'] = temp['Repeticiones_estilo_pecho'].astype(np.float64)\n",
    "temp['Metros_estilo_crawl'] = temp['Metros_estilo_crawl'].astype(np.float64)\n",
    "temp['Repeticiones_estilo_crawl'] = temp['Repeticiones_estilo_crawl'].astype(np.float64)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "d642a9e9-191f-4ef7-ba9d-9a6f24005925",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1 entries, 0 to 0\n",
      "Data columns (total 30 columns):\n",
      " #   Column                       Non-Null Count  Dtype  \n",
      "---  ------                       --------------  -----  \n",
      " 0   Fecha                        1 non-null      object \n",
      " 1   Hora_inicio                  1 non-null      object \n",
      " 2   Hora_de_finalización         1 non-null      object \n",
      " 3   Duración_sesion              1 non-null      object \n",
      " 4   Tipo_entrenamiento           1 non-null      object \n",
      " 5   Objetivos                    1 non-null      object \n",
      " 6   Metas                        1 non-null      object \n",
      " 7   Metros_piscina               1 non-null      int64  \n",
      " 8   Metros_totales               1 non-null      int64  \n",
      " 9   Cantidad_de_brazadas         1 non-null      int64  \n",
      " 10  Frecuencia_cardíaca          1 non-null      int64  \n",
      " 11  Calorías_quemadas            1 non-null      int64  \n",
      " 12  Tiempo_estilo_espalda        1 non-null      object \n",
      " 13  Metros_estilo_espalda        1 non-null      float64\n",
      " 14  Repeticiones_estilo_espalda  1 non-null      float64\n",
      " 15  Tiempo_estilo_pecho          1 non-null      object \n",
      " 16  Metros_estilo_pecho          1 non-null      float64\n",
      " 17  Repeticiones_estilo_pecho    1 non-null      float64\n",
      " 18  Tiempo_estilo_crawl          1 non-null      object \n",
      " 19  Metros_estilo_crawl          1 non-null      float64\n",
      " 20  Repeticiones_estilo_crawl    1 non-null      float64\n",
      " 21  Descanso_entre_series        1 non-null      object \n",
      " 22  Ritmo_promedio               1 non-null      float64\n",
      " 23  Vueltas                      1 non-null      int64  \n",
      " 24  Tiempo_ingesta_previa        1 non-null      object \n",
      " 25  Ingesta_descripcion          1 non-null      object \n",
      " 26  Suplemento_dietario          1 non-null      object \n",
      " 27  Ejercicios_previos           1 non-null      object \n",
      " 28  Tiempo_ejercicios_previos    1 non-null      object \n",
      " 29  Sensaciones_entrenamiento    1 non-null      object \n",
      "dtypes: float64(7), int64(6), object(17)\n",
      "memory usage: 368.0+ bytes\n",
      "None\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 8 entries, 0 to 7\n",
      "Data columns (total 30 columns):\n",
      " #   Column                       Non-Null Count  Dtype  \n",
      "---  ------                       --------------  -----  \n",
      " 0   Fecha                        8 non-null      object \n",
      " 1   Hora_inicio                  8 non-null      object \n",
      " 2   Hora_de_finalización         2 non-null      object \n",
      " 3   Duración_sesion              8 non-null      object \n",
      " 4   Tipo_entrenamiento           8 non-null      object \n",
      " 5   Objetivos                    8 non-null      object \n",
      " 6   Metas                        6 non-null      object \n",
      " 7   Metros_piscina               8 non-null      int64  \n",
      " 8   Metros_totales               8 non-null      int64  \n",
      " 9   Cantidad_de_brazadas         8 non-null      int64  \n",
      " 10  Frecuencia_cardíaca          8 non-null      int64  \n",
      " 11  Calorías_quemadas            8 non-null      int64  \n",
      " 12  Tiempo_estilo_espalda        7 non-null      object \n",
      " 13  Metros_estilo_espalda        7 non-null      float64\n",
      " 14  Repeticiones_estilo_espalda  7 non-null      float64\n",
      " 15  Tiempo_estilo_pecho          7 non-null      object \n",
      " 16  Metros_estilo_pecho          7 non-null      float64\n",
      " 17  Repeticiones_estilo_pecho    7 non-null      float64\n",
      " 18  Tiempo_estilo_crawl          7 non-null      object \n",
      " 19  Metros_estilo_crawl          6 non-null      float64\n",
      " 20  Repeticiones_estilo_crawl    7 non-null      float64\n",
      " 21  Descanso_entre_series        8 non-null      object \n",
      " 22  Ritmo_promedio               8 non-null      float64\n",
      " 23  Vueltas                      8 non-null      int64  \n",
      " 24  Tiempo_ingesta_previa        8 non-null      object \n",
      " 25  Ingesta_descripcion          8 non-null      object \n",
      " 26  Suplemento_dietario          8 non-null      object \n",
      " 27  Ejercicios_previos           8 non-null      object \n",
      " 28  Tiempo_ejercicios_previos    8 non-null      object \n",
      " 29  Sensaciones_entrenamiento    8 non-null      object \n",
      "dtypes: float64(7), int64(6), object(17)\n",
      "memory usage: 2.0+ KB\n",
      "None\n"
     ]
    }
   ],
   "source": [
    "print(temp.info())\n",
    "print(df.info())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "00bd2f3f-5064-4f54-88f4-3c8fc274ea33",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Agregar la nueva fila al dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "e91d6b26-5528-483c-96e5-debd2feea11e",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.concat([temp, df], ignore_index=True, sort=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "9cccc811-3d5e-49e3-8496-3f27ef1c3c8a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Fecha</th>\n",
       "      <th>Hora_inicio</th>\n",
       "      <th>Hora_de_finalización</th>\n",
       "      <th>Duración_sesion</th>\n",
       "      <th>Tipo_entrenamiento</th>\n",
       "      <th>Objetivos</th>\n",
       "      <th>Metas</th>\n",
       "      <th>Metros_piscina</th>\n",
       "      <th>Metros_totales</th>\n",
       "      <th>Cantidad_de_brazadas</th>\n",
       "      <th>...</th>\n",
       "      <th>Repeticiones_estilo_crawl</th>\n",
       "      <th>Descanso_entre_series</th>\n",
       "      <th>Ritmo_promedio</th>\n",
       "      <th>Vueltas</th>\n",
       "      <th>Tiempo_ingesta_previa</th>\n",
       "      <th>Ingesta_descripcion</th>\n",
       "      <th>Suplemento_dietario</th>\n",
       "      <th>Ejercicios_previos</th>\n",
       "      <th>Tiempo_ejercicios_previos</th>\n",
       "      <th>Sensaciones_entrenamiento</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2023-02-01</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>10:15:50</td>\n",
       "      <td>01:15:50</td>\n",
       "      <td>Estilos</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Mejorar rendimiento</td>\n",
       "      <td>20</td>\n",
       "      <td>1920</td>\n",
       "      <td>1382</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>3.60</td>\n",
       "      <td>96</td>\n",
       "      <td>00:40:00</td>\n",
       "      <td>Cafe, pan, clara huevo</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Muy buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2023-01-30</td>\n",
       "      <td>09:05:00</td>\n",
       "      <td>10:05:00</td>\n",
       "      <td>01:01:11</td>\n",
       "      <td>Series</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Mejorar rendimiento</td>\n",
       "      <td>20</td>\n",
       "      <td>1420</td>\n",
       "      <td>980</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>00:00:30</td>\n",
       "      <td>4.20</td>\n",
       "      <td>71</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Leche con coco, pan</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:15</td>\n",
       "      <td>Muy buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2023-01-27</td>\n",
       "      <td>11:04:00</td>\n",
       "      <td>NaT</td>\n",
       "      <td>00:55:18</td>\n",
       "      <td>Estilos</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Mejorar crawl</td>\n",
       "      <td>20</td>\n",
       "      <td>1420</td>\n",
       "      <td>890</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>00:00:45</td>\n",
       "      <td>3.54</td>\n",
       "      <td>71</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, cereales, banana</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Muy buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2023-01-25</td>\n",
       "      <td>08:50:00</td>\n",
       "      <td>09:50:00</td>\n",
       "      <td>01:01:11</td>\n",
       "      <td>Estilos</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Mejorar crawl</td>\n",
       "      <td>20</td>\n",
       "      <td>1340</td>\n",
       "      <td>818</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>00:01:00</td>\n",
       "      <td>4.34</td>\n",
       "      <td>67</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, cereales, banana</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2023-01-23</td>\n",
       "      <td>21:06:00</td>\n",
       "      <td>NaT</td>\n",
       "      <td>00:37:45</td>\n",
       "      <td>Series</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Aumentar distancia</td>\n",
       "      <td>20</td>\n",
       "      <td>780</td>\n",
       "      <td>506</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>00:01:30</td>\n",
       "      <td>4.50</td>\n",
       "      <td>39</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, banana</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2023-01-20</td>\n",
       "      <td>09:33:00</td>\n",
       "      <td>NaT</td>\n",
       "      <td>00:53:54</td>\n",
       "      <td>Series</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Incrementar velocidad</td>\n",
       "      <td>20</td>\n",
       "      <td>1100</td>\n",
       "      <td>663</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>00:01:30</td>\n",
       "      <td>4.54</td>\n",
       "      <td>55</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, cereales, banana</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2023-01-18</td>\n",
       "      <td>09:50:00</td>\n",
       "      <td>NaT</td>\n",
       "      <td>00:54:21</td>\n",
       "      <td>Estilos</td>\n",
       "      <td>Resistencia</td>\n",
       "      <td>Incrementar velocidad</td>\n",
       "      <td>20</td>\n",
       "      <td>1220</td>\n",
       "      <td>832</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>00:01:30</td>\n",
       "      <td>4.27</td>\n",
       "      <td>61</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, panes</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2023-01-16</td>\n",
       "      <td>21:04:00</td>\n",
       "      <td>NaT</td>\n",
       "      <td>00:33:56</td>\n",
       "      <td>Series</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20</td>\n",
       "      <td>820</td>\n",
       "      <td>455</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>00:01:30</td>\n",
       "      <td>4.08</td>\n",
       "      <td>41</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, cereales, banana</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Buenas</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Fecha Hora_inicio Hora_de_finalización Duración_sesion  \\\n",
       "0  2023-02-01    09:00:00             10:15:50        01:15:50   \n",
       "1  2023-01-30    09:05:00             10:05:00        01:01:11   \n",
       "2  2023-01-27    11:04:00                  NaT        00:55:18   \n",
       "3  2023-01-25    08:50:00             09:50:00        01:01:11   \n",
       "4  2023-01-23    21:06:00                  NaT        00:37:45   \n",
       "5  2023-01-20    09:33:00                  NaT        00:53:54   \n",
       "6  2023-01-18    09:50:00                  NaT        00:54:21   \n",
       "7  2023-01-16    21:04:00                  NaT        00:33:56   \n",
       "\n",
       "  Tipo_entrenamiento        Objetivos                  Metas  Metros_piscina  \\\n",
       "0            Estilos  Mejorar Tecnica    Mejorar rendimiento              20   \n",
       "1             Series  Mejorar Tecnica    Mejorar rendimiento              20   \n",
       "2            Estilos  Mejorar Tecnica          Mejorar crawl              20   \n",
       "3            Estilos  Mejorar Tecnica          Mejorar crawl              20   \n",
       "4             Series  Mejorar Tecnica     Aumentar distancia              20   \n",
       "5             Series  Mejorar Tecnica  Incrementar velocidad              20   \n",
       "6            Estilos      Resistencia  Incrementar velocidad              20   \n",
       "7             Series  Mejorar Tecnica                    NaN              20   \n",
       "\n",
       "   Metros_totales  Cantidad_de_brazadas  ...  Repeticiones_estilo_crawl  \\\n",
       "0            1920                  1382  ...                        5.0   \n",
       "1            1420                   980  ...                        4.0   \n",
       "2            1420                   890  ...                        4.0   \n",
       "3            1340                   818  ...                        3.0   \n",
       "4             780                   506  ...                        2.0   \n",
       "5            1100                   663  ...                        2.0   \n",
       "6            1220                   832  ...                        2.0   \n",
       "7             820                   455  ...                        2.0   \n",
       "\n",
       "   Descanso_entre_series Ritmo_promedio  Vueltas  Tiempo_ingesta_previa  \\\n",
       "0               00:00:00           3.60       96               00:40:00   \n",
       "1               00:00:30           4.20       71               01:00:00   \n",
       "2               00:00:45           3.54       71               01:00:00   \n",
       "3               00:01:00           4.34       67               01:00:00   \n",
       "4               00:01:30           4.50       39               01:00:00   \n",
       "5               00:01:30           4.54       55               01:00:00   \n",
       "6               00:01:30           4.27       61               01:00:00   \n",
       "7               00:01:30           4.08       41               01:00:00   \n",
       "\n",
       "      Ingesta_descripcion  Suplemento_dietario  Ejercicios_previos  \\\n",
       "0  Cafe, pan, clara huevo             Creatina            Caminata   \n",
       "1     Leche con coco, pan             Creatina            Caminata   \n",
       "2  Cafe, cereales, banana             Creatina            Caminata   \n",
       "3  Cafe, cereales, banana             Creatina            Caminata   \n",
       "4            Cafe, banana             Creatina            Caminata   \n",
       "5  Cafe, cereales, banana             Creatina            Caminata   \n",
       "6             Cafe, panes             Creatina            Caminata   \n",
       "7  Cafe, cereales, banana             Creatina            Caminata   \n",
       "\n",
       "  Tiempo_ejercicios_previos  Sensaciones_entrenamiento  \n",
       "0                  00:00:10                 Muy buenas  \n",
       "1                  00:00:15                 Muy buenas  \n",
       "2                  00:00:10                 Muy buenas  \n",
       "3                  00:00:10                     Buenas  \n",
       "4                  00:00:10                     Buenas  \n",
       "5                  00:00:10                     Buenas  \n",
       "6                  00:00:10                     Buenas  \n",
       "7                  00:00:10                     Buenas  \n",
       "\n",
       "[8 rows x 30 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(8)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "eabc4071-4e0d-479d-9acd-d3163b10a96f",
   "metadata": {},
   "outputs": [],
   "source": [
    "import datetime\n",
    "\n",
    "now = datetime.datetime.now() # Obtener fecha y hora actual\n",
    "file_name = f\"natacion_{now.strftime('%Y%m%d')}.xlsx\" # Formatear fecha para usar en el nombre del archivo\n",
    "file_path = \"/home/studio-lab-user/Swimming Data Analysis/Data/\" + file_name # Especificar la ruta donde se guardará el nuevo DataFrame\n",
    "\n",
    "df.to_excel(file_path) # Guardar el archivo"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "2aee116f-4377-4e5c-858b-2b747b54e2db",
   "metadata": {},
   "outputs": [],
   "source": [
    "new_df = pd.read_excel(\"/home/studio-lab-user/Swimming Data Analysis/Data/natacion_20230201.xlsx\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "e3d2284c-c30a-4dd3-b729-85624febe027",
   "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>Unnamed: 0</th>\n",
       "      <th>Fecha</th>\n",
       "      <th>Hora_inicio</th>\n",
       "      <th>Hora_de_finalización</th>\n",
       "      <th>Duración_sesion</th>\n",
       "      <th>Tipo_entrenamiento</th>\n",
       "      <th>Objetivos</th>\n",
       "      <th>Metas</th>\n",
       "      <th>Metros_piscina</th>\n",
       "      <th>Metros_totales</th>\n",
       "      <th>...</th>\n",
       "      <th>Repeticiones_estilo_crawl</th>\n",
       "      <th>Descanso_entre_series</th>\n",
       "      <th>Ritmo_promedio</th>\n",
       "      <th>Vueltas</th>\n",
       "      <th>Tiempo_ingesta_previa</th>\n",
       "      <th>Ingesta_descripcion</th>\n",
       "      <th>Suplemento_dietario</th>\n",
       "      <th>Ejercicios_previos</th>\n",
       "      <th>Tiempo_ejercicios_previos</th>\n",
       "      <th>Sensaciones_entrenamiento</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>2023-02-01</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>10:15:50</td>\n",
       "      <td>01:15:50</td>\n",
       "      <td>Estilos</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Mejorar rendimiento</td>\n",
       "      <td>20</td>\n",
       "      <td>1920</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>3.60</td>\n",
       "      <td>96</td>\n",
       "      <td>00:40:00</td>\n",
       "      <td>Cafe, pan, clara huevo</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Muy buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2023-01-30</td>\n",
       "      <td>09:05:00</td>\n",
       "      <td>10:05:00</td>\n",
       "      <td>01:01:11</td>\n",
       "      <td>Series</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Mejorar rendimiento</td>\n",
       "      <td>20</td>\n",
       "      <td>1420</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>00:00:30</td>\n",
       "      <td>4.20</td>\n",
       "      <td>71</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Leche con coco, pan</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:15</td>\n",
       "      <td>Muy buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2023-01-27</td>\n",
       "      <td>11:04:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00:55:18</td>\n",
       "      <td>Estilos</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Mejorar crawl</td>\n",
       "      <td>20</td>\n",
       "      <td>1420</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>00:00:45</td>\n",
       "      <td>3.54</td>\n",
       "      <td>71</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, cereales, banana</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Muy buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>2023-01-25</td>\n",
       "      <td>08:50:00</td>\n",
       "      <td>09:50:00</td>\n",
       "      <td>01:01:11</td>\n",
       "      <td>Estilos</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Mejorar crawl</td>\n",
       "      <td>20</td>\n",
       "      <td>1340</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>00:01:00</td>\n",
       "      <td>4.34</td>\n",
       "      <td>67</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, cereales, banana</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>2023-01-23</td>\n",
       "      <td>21:06:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00:37:45</td>\n",
       "      <td>Series</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Aumentar distancia</td>\n",
       "      <td>20</td>\n",
       "      <td>780</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>00:01:30</td>\n",
       "      <td>4.50</td>\n",
       "      <td>39</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, banana</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>2023-01-20</td>\n",
       "      <td>09:33:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00:53:54</td>\n",
       "      <td>Series</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Incrementar velocidad</td>\n",
       "      <td>20</td>\n",
       "      <td>1100</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>00:01:30</td>\n",
       "      <td>4.54</td>\n",
       "      <td>55</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, cereales, banana</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>2023-01-18</td>\n",
       "      <td>09:50:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00:54:21</td>\n",
       "      <td>Estilos</td>\n",
       "      <td>Resistencia</td>\n",
       "      <td>Incrementar velocidad</td>\n",
       "      <td>20</td>\n",
       "      <td>1220</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>00:01:30</td>\n",
       "      <td>4.27</td>\n",
       "      <td>61</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, panes</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Buenas</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0       Fecha Hora_inicio Hora_de_finalización Duración_sesion  \\\n",
       "0           0  2023-02-01    09:00:00             10:15:50        01:15:50   \n",
       "1           1  2023-01-30    09:05:00             10:05:00        01:01:11   \n",
       "2           2  2023-01-27    11:04:00                  NaN        00:55:18   \n",
       "3           3  2023-01-25    08:50:00             09:50:00        01:01:11   \n",
       "4           4  2023-01-23    21:06:00                  NaN        00:37:45   \n",
       "5           5  2023-01-20    09:33:00                  NaN        00:53:54   \n",
       "6           6  2023-01-18    09:50:00                  NaN        00:54:21   \n",
       "\n",
       "  Tipo_entrenamiento        Objetivos                  Metas  Metros_piscina  \\\n",
       "0            Estilos  Mejorar Tecnica    Mejorar rendimiento              20   \n",
       "1             Series  Mejorar Tecnica    Mejorar rendimiento              20   \n",
       "2            Estilos  Mejorar Tecnica          Mejorar crawl              20   \n",
       "3            Estilos  Mejorar Tecnica          Mejorar crawl              20   \n",
       "4             Series  Mejorar Tecnica     Aumentar distancia              20   \n",
       "5             Series  Mejorar Tecnica  Incrementar velocidad              20   \n",
       "6            Estilos      Resistencia  Incrementar velocidad              20   \n",
       "\n",
       "   Metros_totales  ...  Repeticiones_estilo_crawl  Descanso_entre_series  \\\n",
       "0            1920  ...                        5.0               00:00:00   \n",
       "1            1420  ...                        4.0               00:00:30   \n",
       "2            1420  ...                        4.0               00:00:45   \n",
       "3            1340  ...                        3.0               00:01:00   \n",
       "4             780  ...                        2.0               00:01:30   \n",
       "5            1100  ...                        2.0               00:01:30   \n",
       "6            1220  ...                        2.0               00:01:30   \n",
       "\n",
       "   Ritmo_promedio Vueltas  Tiempo_ingesta_previa     Ingesta_descripcion  \\\n",
       "0            3.60      96               00:40:00  Cafe, pan, clara huevo   \n",
       "1            4.20      71               01:00:00     Leche con coco, pan   \n",
       "2            3.54      71               01:00:00  Cafe, cereales, banana   \n",
       "3            4.34      67               01:00:00  Cafe, cereales, banana   \n",
       "4            4.50      39               01:00:00            Cafe, banana   \n",
       "5            4.54      55               01:00:00  Cafe, cereales, banana   \n",
       "6            4.27      61               01:00:00             Cafe, panes   \n",
       "\n",
       "  Suplemento_dietario  Ejercicios_previos  Tiempo_ejercicios_previos  \\\n",
       "0            Creatina            Caminata                   00:00:10   \n",
       "1            Creatina            Caminata                   00:00:15   \n",
       "2            Creatina            Caminata                   00:00:10   \n",
       "3            Creatina            Caminata                   00:00:10   \n",
       "4            Creatina            Caminata                   00:00:10   \n",
       "5            Creatina            Caminata                   00:00:10   \n",
       "6            Creatina            Caminata                   00:00:10   \n",
       "\n",
       "  Sensaciones_entrenamiento  \n",
       "0                Muy buenas  \n",
       "1                Muy buenas  \n",
       "2                Muy buenas  \n",
       "3                    Buenas  \n",
       "4                    Buenas  \n",
       "5                    Buenas  \n",
       "6                    Buenas  \n",
       "\n",
       "[7 rows x 31 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df.head(7)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "e95bfd6f-dbb2-4577-8a3f-95cfb728fd4c",
   "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>Unnamed: 0</th>\n",
       "      <th>Hora_inicio</th>\n",
       "      <th>Hora_de_finalización</th>\n",
       "      <th>Duración_sesion</th>\n",
       "      <th>Tipo_entrenamiento</th>\n",
       "      <th>Objetivos</th>\n",
       "      <th>Metas</th>\n",
       "      <th>Metros_piscina</th>\n",
       "      <th>Metros_totales</th>\n",
       "      <th>Cantidad_de_brazadas</th>\n",
       "      <th>...</th>\n",
       "      <th>Repeticiones_estilo_crawl</th>\n",
       "      <th>Descanso_entre_series</th>\n",
       "      <th>Ritmo_promedio</th>\n",
       "      <th>Vueltas</th>\n",
       "      <th>Tiempo_ingesta_previa</th>\n",
       "      <th>Ingesta_descripcion</th>\n",
       "      <th>Suplemento_dietario</th>\n",
       "      <th>Ejercicios_previos</th>\n",
       "      <th>Tiempo_ejercicios_previos</th>\n",
       "      <th>Sensaciones_entrenamiento</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fecha</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2023-02-01</th>\n",
       "      <td>0</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>10:15:50</td>\n",
       "      <td>01:15:50</td>\n",
       "      <td>Estilos</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Mejorar rendimiento</td>\n",
       "      <td>20</td>\n",
       "      <td>1920</td>\n",
       "      <td>1382</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>3.60</td>\n",
       "      <td>96</td>\n",
       "      <td>00:40:00</td>\n",
       "      <td>Cafe, pan, clara huevo</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Muy buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-30</th>\n",
       "      <td>1</td>\n",
       "      <td>09:05:00</td>\n",
       "      <td>10:05:00</td>\n",
       "      <td>01:01:11</td>\n",
       "      <td>Series</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Mejorar rendimiento</td>\n",
       "      <td>20</td>\n",
       "      <td>1420</td>\n",
       "      <td>980</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>00:00:30</td>\n",
       "      <td>4.20</td>\n",
       "      <td>71</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Leche con coco, pan</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:15</td>\n",
       "      <td>Muy buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-27</th>\n",
       "      <td>2</td>\n",
       "      <td>11:04:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00:55:18</td>\n",
       "      <td>Estilos</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Mejorar crawl</td>\n",
       "      <td>20</td>\n",
       "      <td>1420</td>\n",
       "      <td>890</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>00:00:45</td>\n",
       "      <td>3.54</td>\n",
       "      <td>71</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, cereales, banana</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Muy buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-25</th>\n",
       "      <td>3</td>\n",
       "      <td>08:50:00</td>\n",
       "      <td>09:50:00</td>\n",
       "      <td>01:01:11</td>\n",
       "      <td>Estilos</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Mejorar crawl</td>\n",
       "      <td>20</td>\n",
       "      <td>1340</td>\n",
       "      <td>818</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>00:01:00</td>\n",
       "      <td>4.34</td>\n",
       "      <td>67</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, cereales, banana</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-23</th>\n",
       "      <td>4</td>\n",
       "      <td>21:06:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00:37:45</td>\n",
       "      <td>Series</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Aumentar distancia</td>\n",
       "      <td>20</td>\n",
       "      <td>780</td>\n",
       "      <td>506</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>00:01:30</td>\n",
       "      <td>4.50</td>\n",
       "      <td>39</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, banana</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-20</th>\n",
       "      <td>5</td>\n",
       "      <td>09:33:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00:53:54</td>\n",
       "      <td>Series</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Incrementar velocidad</td>\n",
       "      <td>20</td>\n",
       "      <td>1100</td>\n",
       "      <td>663</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>00:01:30</td>\n",
       "      <td>4.54</td>\n",
       "      <td>55</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, cereales, banana</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-18</th>\n",
       "      <td>6</td>\n",
       "      <td>09:50:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00:54:21</td>\n",
       "      <td>Estilos</td>\n",
       "      <td>Resistencia</td>\n",
       "      <td>Incrementar velocidad</td>\n",
       "      <td>20</td>\n",
       "      <td>1220</td>\n",
       "      <td>832</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>00:01:30</td>\n",
       "      <td>4.27</td>\n",
       "      <td>61</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, panes</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-16</th>\n",
       "      <td>7</td>\n",
       "      <td>21:04:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00:33:56</td>\n",
       "      <td>Series</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20</td>\n",
       "      <td>820</td>\n",
       "      <td>455</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>00:01:30</td>\n",
       "      <td>4.08</td>\n",
       "      <td>41</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, cereales, banana</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-14</th>\n",
       "      <td>8</td>\n",
       "      <td>17:13:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00:43:00</td>\n",
       "      <td>Series</td>\n",
       "      <td>Prueba</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>240</td>\n",
       "      <td>73</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00:01:30</td>\n",
       "      <td>17.55</td>\n",
       "      <td>12</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Banana</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Piscina Pequeña</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Unnamed: 0 Hora_inicio Hora_de_finalización Duración_sesion  \\\n",
       "Fecha                                                                     \n",
       "2023-02-01           0    09:00:00             10:15:50        01:15:50   \n",
       "2023-01-30           1    09:05:00             10:05:00        01:01:11   \n",
       "2023-01-27           2    11:04:00                  NaN        00:55:18   \n",
       "2023-01-25           3    08:50:00             09:50:00        01:01:11   \n",
       "2023-01-23           4    21:06:00                  NaN        00:37:45   \n",
       "2023-01-20           5    09:33:00                  NaN        00:53:54   \n",
       "2023-01-18           6    09:50:00                  NaN        00:54:21   \n",
       "2023-01-16           7    21:04:00                  NaN        00:33:56   \n",
       "2023-01-14           8    17:13:00                  NaN        00:43:00   \n",
       "\n",
       "           Tipo_entrenamiento        Objetivos                  Metas  \\\n",
       "Fecha                                                                   \n",
       "2023-02-01            Estilos  Mejorar Tecnica    Mejorar rendimiento   \n",
       "2023-01-30             Series  Mejorar Tecnica    Mejorar rendimiento   \n",
       "2023-01-27            Estilos  Mejorar Tecnica          Mejorar crawl   \n",
       "2023-01-25            Estilos  Mejorar Tecnica          Mejorar crawl   \n",
       "2023-01-23             Series  Mejorar Tecnica     Aumentar distancia   \n",
       "2023-01-20             Series  Mejorar Tecnica  Incrementar velocidad   \n",
       "2023-01-18            Estilos      Resistencia  Incrementar velocidad   \n",
       "2023-01-16             Series  Mejorar Tecnica                    NaN   \n",
       "2023-01-14             Series           Prueba                    NaN   \n",
       "\n",
       "            Metros_piscina  Metros_totales  Cantidad_de_brazadas  ...  \\\n",
       "Fecha                                                             ...   \n",
       "2023-02-01              20            1920                  1382  ...   \n",
       "2023-01-30              20            1420                   980  ...   \n",
       "2023-01-27              20            1420                   890  ...   \n",
       "2023-01-25              20            1340                   818  ...   \n",
       "2023-01-23              20             780                   506  ...   \n",
       "2023-01-20              20            1100                   663  ...   \n",
       "2023-01-18              20            1220                   832  ...   \n",
       "2023-01-16              20             820                   455  ...   \n",
       "2023-01-14               5             240                    73  ...   \n",
       "\n",
       "            Repeticiones_estilo_crawl  Descanso_entre_series Ritmo_promedio  \\\n",
       "Fecha                                                                         \n",
       "2023-02-01                        5.0               00:00:00           3.60   \n",
       "2023-01-30                        4.0               00:00:30           4.20   \n",
       "2023-01-27                        4.0               00:00:45           3.54   \n",
       "2023-01-25                        3.0               00:01:00           4.34   \n",
       "2023-01-23                        2.0               00:01:30           4.50   \n",
       "2023-01-20                        2.0               00:01:30           4.54   \n",
       "2023-01-18                        2.0               00:01:30           4.27   \n",
       "2023-01-16                        2.0               00:01:30           4.08   \n",
       "2023-01-14                        NaN               00:01:30          17.55   \n",
       "\n",
       "            Vueltas  Tiempo_ingesta_previa     Ingesta_descripcion  \\\n",
       "Fecha                                                                \n",
       "2023-02-01       96               00:40:00  Cafe, pan, clara huevo   \n",
       "2023-01-30       71               01:00:00     Leche con coco, pan   \n",
       "2023-01-27       71               01:00:00  Cafe, cereales, banana   \n",
       "2023-01-25       67               01:00:00  Cafe, cereales, banana   \n",
       "2023-01-23       39               01:00:00            Cafe, banana   \n",
       "2023-01-20       55               01:00:00  Cafe, cereales, banana   \n",
       "2023-01-18       61               01:00:00             Cafe, panes   \n",
       "2023-01-16       41               01:00:00  Cafe, cereales, banana   \n",
       "2023-01-14       12               01:00:00                  Banana   \n",
       "\n",
       "            Suplemento_dietario  Ejercicios_previos Tiempo_ejercicios_previos  \\\n",
       "Fecha                                                                           \n",
       "2023-02-01             Creatina            Caminata                  00:00:10   \n",
       "2023-01-30             Creatina            Caminata                  00:00:15   \n",
       "2023-01-27             Creatina            Caminata                  00:00:10   \n",
       "2023-01-25             Creatina            Caminata                  00:00:10   \n",
       "2023-01-23             Creatina            Caminata                  00:00:10   \n",
       "2023-01-20             Creatina            Caminata                  00:00:10   \n",
       "2023-01-18             Creatina            Caminata                  00:00:10   \n",
       "2023-01-16             Creatina            Caminata                  00:00:10   \n",
       "2023-01-14             Creatina            Caminata                  00:00:10   \n",
       "\n",
       "            Sensaciones_entrenamiento  \n",
       "Fecha                                  \n",
       "2023-02-01                 Muy buenas  \n",
       "2023-01-30                 Muy buenas  \n",
       "2023-01-27                 Muy buenas  \n",
       "2023-01-25                     Buenas  \n",
       "2023-01-23                     Buenas  \n",
       "2023-01-20                     Buenas  \n",
       "2023-01-18                     Buenas  \n",
       "2023-01-16                     Buenas  \n",
       "2023-01-14            Piscina Pequeña  \n",
       "\n",
       "[9 rows x 30 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df.set_index('Fecha')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "8b2015b2-8c33-479a-8927-508b09076cbd",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 9 entries, 0 to 8\n",
      "Data columns (total 31 columns):\n",
      " #   Column                       Non-Null Count  Dtype  \n",
      "---  ------                       --------------  -----  \n",
      " 0   Unnamed: 0                   9 non-null      int64  \n",
      " 1   Fecha                        9 non-null      object \n",
      " 2   Hora_inicio                  9 non-null      object \n",
      " 3   Hora_de_finalización         3 non-null      object \n",
      " 4   Duración_sesion              9 non-null      object \n",
      " 5   Tipo_entrenamiento           9 non-null      object \n",
      " 6   Objetivos                    9 non-null      object \n",
      " 7   Metas                        7 non-null      object \n",
      " 8   Metros_piscina               9 non-null      int64  \n",
      " 9   Metros_totales               9 non-null      int64  \n",
      " 10  Cantidad_de_brazadas         9 non-null      int64  \n",
      " 11  Frecuencia_cardíaca          9 non-null      int64  \n",
      " 12  Calorías_quemadas            9 non-null      int64  \n",
      " 13  Tiempo_estilo_espalda        8 non-null      object \n",
      " 14  Metros_estilo_espalda        8 non-null      float64\n",
      " 15  Repeticiones_estilo_espalda  8 non-null      float64\n",
      " 16  Tiempo_estilo_pecho          8 non-null      object \n",
      " 17  Metros_estilo_pecho          8 non-null      float64\n",
      " 18  Repeticiones_estilo_pecho    8 non-null      float64\n",
      " 19  Tiempo_estilo_crawl          8 non-null      object \n",
      " 20  Metros_estilo_crawl          7 non-null      float64\n",
      " 21  Repeticiones_estilo_crawl    8 non-null      float64\n",
      " 22  Descanso_entre_series        9 non-null      object \n",
      " 23  Ritmo_promedio               9 non-null      float64\n",
      " 24  Vueltas                      9 non-null      int64  \n",
      " 25  Tiempo_ingesta_previa        9 non-null      object \n",
      " 26  Ingesta_descripcion          9 non-null      object \n",
      " 27  Suplemento_dietario          9 non-null      object \n",
      " 28  Ejercicios_previos           9 non-null      object \n",
      " 29  Tiempo_ejercicios_previos    9 non-null      object \n",
      " 30  Sensaciones_entrenamiento    9 non-null      object \n",
      "dtypes: float64(7), int64(7), object(17)\n",
      "memory usage: 2.3+ KB\n"
     ]
    }
   ],
   "source": [
    "new_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "477bedcd-c546-43c2-b84c-096f8f1ddaf5",
   "metadata": {},
   "outputs": [],
   "source": [
    "new_df = new_df.drop(\"Unnamed: 0\", axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "91700a1e-7ae3-4e84-9ab5-1e64ebbe9205",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 9 entries, 0 to 8\n",
      "Data columns (total 30 columns):\n",
      " #   Column                       Non-Null Count  Dtype  \n",
      "---  ------                       --------------  -----  \n",
      " 0   Fecha                        9 non-null      object \n",
      " 1   Hora_inicio                  9 non-null      object \n",
      " 2   Hora_de_finalización         3 non-null      object \n",
      " 3   Duración_sesion              9 non-null      object \n",
      " 4   Tipo_entrenamiento           9 non-null      object \n",
      " 5   Objetivos                    9 non-null      object \n",
      " 6   Metas                        7 non-null      object \n",
      " 7   Metros_piscina               9 non-null      int64  \n",
      " 8   Metros_totales               9 non-null      int64  \n",
      " 9   Cantidad_de_brazadas         9 non-null      int64  \n",
      " 10  Frecuencia_cardíaca          9 non-null      int64  \n",
      " 11  Calorías_quemadas            9 non-null      int64  \n",
      " 12  Tiempo_estilo_espalda        8 non-null      object \n",
      " 13  Metros_estilo_espalda        8 non-null      float64\n",
      " 14  Repeticiones_estilo_espalda  8 non-null      float64\n",
      " 15  Tiempo_estilo_pecho          8 non-null      object \n",
      " 16  Metros_estilo_pecho          8 non-null      float64\n",
      " 17  Repeticiones_estilo_pecho    8 non-null      float64\n",
      " 18  Tiempo_estilo_crawl          8 non-null      object \n",
      " 19  Metros_estilo_crawl          7 non-null      float64\n",
      " 20  Repeticiones_estilo_crawl    8 non-null      float64\n",
      " 21  Descanso_entre_series        9 non-null      object \n",
      " 22  Ritmo_promedio               9 non-null      float64\n",
      " 23  Vueltas                      9 non-null      int64  \n",
      " 24  Tiempo_ingesta_previa        9 non-null      object \n",
      " 25  Ingesta_descripcion          9 non-null      object \n",
      " 26  Suplemento_dietario          9 non-null      object \n",
      " 27  Ejercicios_previos           9 non-null      object \n",
      " 28  Tiempo_ejercicios_previos    9 non-null      object \n",
      " 29  Sensaciones_entrenamiento    9 non-null      object \n",
      "dtypes: float64(7), int64(6), object(17)\n",
      "memory usage: 2.2+ KB\n"
     ]
    }
   ],
   "source": [
    "new_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "d3c23551-bed3-475f-a449-ff7d74f7ed78",
   "metadata": {},
   "outputs": [],
   "source": [
    "now = datetime.datetime.now() # Obtener fecha y hora actual\n",
    "file_name = f\"natacion_{now.strftime('%Y%m%d')}.xlsx\" # Formatear fecha para usar en el nombre del archivo\n",
    "file_path = \"/home/studio-lab-user/Swimming Data Analysis/Data/\" + file_name # Especificar la ruta donde se guardará el nuevo DataFrame\n",
    "\n",
    "df.to_excel(file_path) # Guardar el archivo"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "5b323e47-42d9-46de-9a44-5bddf66d4ab5",
   "metadata": {},
   "outputs": [],
   "source": [
    "new_df = pd.read_excel(\"/home/studio-lab-user/Swimming Data Analysis/Data/natacion_20230201.xlsx\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "a1c8f83a-4b6d-4031-a2c5-4a9395028b05",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 9 entries, 0 to 8\n",
      "Data columns (total 30 columns):\n",
      " #   Column                       Non-Null Count  Dtype  \n",
      "---  ------                       --------------  -----  \n",
      " 0   Fecha                        9 non-null      object \n",
      " 1   Hora_inicio                  9 non-null      object \n",
      " 2   Hora_de_finalización         3 non-null      object \n",
      " 3   Duración_sesion              9 non-null      object \n",
      " 4   Tipo_entrenamiento           9 non-null      object \n",
      " 5   Objetivos                    9 non-null      object \n",
      " 6   Metas                        7 non-null      object \n",
      " 7   Metros_piscina               9 non-null      int64  \n",
      " 8   Metros_totales               9 non-null      int64  \n",
      " 9   Cantidad_de_brazadas         9 non-null      int64  \n",
      " 10  Frecuencia_cardíaca          9 non-null      int64  \n",
      " 11  Calorías_quemadas            9 non-null      int64  \n",
      " 12  Tiempo_estilo_espalda        8 non-null      object \n",
      " 13  Metros_estilo_espalda        8 non-null      float64\n",
      " 14  Repeticiones_estilo_espalda  8 non-null      float64\n",
      " 15  Tiempo_estilo_pecho          8 non-null      object \n",
      " 16  Metros_estilo_pecho          8 non-null      float64\n",
      " 17  Repeticiones_estilo_pecho    8 non-null      float64\n",
      " 18  Tiempo_estilo_crawl          8 non-null      object \n",
      " 19  Metros_estilo_crawl          7 non-null      float64\n",
      " 20  Repeticiones_estilo_crawl    8 non-null      float64\n",
      " 21  Descanso_entre_series        9 non-null      object \n",
      " 22  Ritmo_promedio               9 non-null      float64\n",
      " 23  Vueltas                      9 non-null      int64  \n",
      " 24  Tiempo_ingesta_previa        9 non-null      object \n",
      " 25  Ingesta_descripcion          9 non-null      object \n",
      " 26  Suplemento_dietario          9 non-null      object \n",
      " 27  Ejercicios_previos           9 non-null      object \n",
      " 28  Tiempo_ejercicios_previos    9 non-null      object \n",
      " 29  Sensaciones_entrenamiento    9 non-null      object \n",
      "dtypes: float64(7), int64(6), object(17)\n",
      "memory usage: 2.2+ KB\n"
     ]
    }
   ],
   "source": [
    "new_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "13719988-a56e-4cc1-93d5-828588e6c145",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Fecha</th>\n",
       "      <th>Hora_inicio</th>\n",
       "      <th>Hora_de_finalización</th>\n",
       "      <th>Duración_sesion</th>\n",
       "      <th>Tipo_entrenamiento</th>\n",
       "      <th>Objetivos</th>\n",
       "      <th>Metas</th>\n",
       "      <th>Metros_piscina</th>\n",
       "      <th>Metros_totales</th>\n",
       "      <th>Cantidad_de_brazadas</th>\n",
       "      <th>...</th>\n",
       "      <th>Repeticiones_estilo_crawl</th>\n",
       "      <th>Descanso_entre_series</th>\n",
       "      <th>Ritmo_promedio</th>\n",
       "      <th>Vueltas</th>\n",
       "      <th>Tiempo_ingesta_previa</th>\n",
       "      <th>Ingesta_descripcion</th>\n",
       "      <th>Suplemento_dietario</th>\n",
       "      <th>Ejercicios_previos</th>\n",
       "      <th>Tiempo_ejercicios_previos</th>\n",
       "      <th>Sensaciones_entrenamiento</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2023-02-01</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>10:15:50</td>\n",
       "      <td>01:15:50</td>\n",
       "      <td>Estilos</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Mejorar rendimiento</td>\n",
       "      <td>20</td>\n",
       "      <td>1920</td>\n",
       "      <td>1382</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>00:00:00</td>\n",
       "      <td>3.60</td>\n",
       "      <td>96</td>\n",
       "      <td>00:40:00</td>\n",
       "      <td>Cafe, pan, clara huevo</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Muy buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2023-01-30</td>\n",
       "      <td>09:05:00</td>\n",
       "      <td>10:05:00</td>\n",
       "      <td>01:01:11</td>\n",
       "      <td>Series</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Mejorar rendimiento</td>\n",
       "      <td>20</td>\n",
       "      <td>1420</td>\n",
       "      <td>980</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>00:00:30</td>\n",
       "      <td>4.20</td>\n",
       "      <td>71</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Leche con coco, pan</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:15</td>\n",
       "      <td>Muy buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2023-01-27</td>\n",
       "      <td>11:04:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00:55:18</td>\n",
       "      <td>Estilos</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Mejorar crawl</td>\n",
       "      <td>20</td>\n",
       "      <td>1420</td>\n",
       "      <td>890</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>00:00:45</td>\n",
       "      <td>3.54</td>\n",
       "      <td>71</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, cereales, banana</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Muy buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2023-01-25</td>\n",
       "      <td>08:50:00</td>\n",
       "      <td>09:50:00</td>\n",
       "      <td>01:01:11</td>\n",
       "      <td>Estilos</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Mejorar crawl</td>\n",
       "      <td>20</td>\n",
       "      <td>1340</td>\n",
       "      <td>818</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>00:01:00</td>\n",
       "      <td>4.34</td>\n",
       "      <td>67</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, cereales, banana</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2023-01-23</td>\n",
       "      <td>21:06:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00:37:45</td>\n",
       "      <td>Series</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Aumentar distancia</td>\n",
       "      <td>20</td>\n",
       "      <td>780</td>\n",
       "      <td>506</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>00:01:30</td>\n",
       "      <td>4.50</td>\n",
       "      <td>39</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, banana</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2023-01-20</td>\n",
       "      <td>09:33:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00:53:54</td>\n",
       "      <td>Series</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Incrementar velocidad</td>\n",
       "      <td>20</td>\n",
       "      <td>1100</td>\n",
       "      <td>663</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>00:01:30</td>\n",
       "      <td>4.54</td>\n",
       "      <td>55</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, cereales, banana</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2023-01-18</td>\n",
       "      <td>09:50:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00:54:21</td>\n",
       "      <td>Estilos</td>\n",
       "      <td>Resistencia</td>\n",
       "      <td>Incrementar velocidad</td>\n",
       "      <td>20</td>\n",
       "      <td>1220</td>\n",
       "      <td>832</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>00:01:30</td>\n",
       "      <td>4.27</td>\n",
       "      <td>61</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, panes</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2023-01-16</td>\n",
       "      <td>21:04:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00:33:56</td>\n",
       "      <td>Series</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20</td>\n",
       "      <td>820</td>\n",
       "      <td>455</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>00:01:30</td>\n",
       "      <td>4.08</td>\n",
       "      <td>41</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Cafe, cereales, banana</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Buenas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2023-01-14</td>\n",
       "      <td>17:13:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00:43:00</td>\n",
       "      <td>Series</td>\n",
       "      <td>Prueba</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>240</td>\n",
       "      <td>73</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00:01:30</td>\n",
       "      <td>17.55</td>\n",
       "      <td>12</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Banana</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:10</td>\n",
       "      <td>Piscina Pequeña</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Fecha Hora_inicio Hora_de_finalización Duración_sesion  \\\n",
       "0  2023-02-01    09:00:00             10:15:50        01:15:50   \n",
       "1  2023-01-30    09:05:00             10:05:00        01:01:11   \n",
       "2  2023-01-27    11:04:00                  NaN        00:55:18   \n",
       "3  2023-01-25    08:50:00             09:50:00        01:01:11   \n",
       "4  2023-01-23    21:06:00                  NaN        00:37:45   \n",
       "5  2023-01-20    09:33:00                  NaN        00:53:54   \n",
       "6  2023-01-18    09:50:00                  NaN        00:54:21   \n",
       "7  2023-01-16    21:04:00                  NaN        00:33:56   \n",
       "8  2023-01-14    17:13:00                  NaN        00:43:00   \n",
       "\n",
       "  Tipo_entrenamiento        Objetivos                  Metas  Metros_piscina  \\\n",
       "0            Estilos  Mejorar Tecnica    Mejorar rendimiento              20   \n",
       "1             Series  Mejorar Tecnica    Mejorar rendimiento              20   \n",
       "2            Estilos  Mejorar Tecnica          Mejorar crawl              20   \n",
       "3            Estilos  Mejorar Tecnica          Mejorar crawl              20   \n",
       "4             Series  Mejorar Tecnica     Aumentar distancia              20   \n",
       "5             Series  Mejorar Tecnica  Incrementar velocidad              20   \n",
       "6            Estilos      Resistencia  Incrementar velocidad              20   \n",
       "7             Series  Mejorar Tecnica                    NaN              20   \n",
       "8             Series           Prueba                    NaN               5   \n",
       "\n",
       "   Metros_totales  Cantidad_de_brazadas  ...  Repeticiones_estilo_crawl  \\\n",
       "0            1920                  1382  ...                        5.0   \n",
       "1            1420                   980  ...                        4.0   \n",
       "2            1420                   890  ...                        4.0   \n",
       "3            1340                   818  ...                        3.0   \n",
       "4             780                   506  ...                        2.0   \n",
       "5            1100                   663  ...                        2.0   \n",
       "6            1220                   832  ...                        2.0   \n",
       "7             820                   455  ...                        2.0   \n",
       "8             240                    73  ...                        NaN   \n",
       "\n",
       "   Descanso_entre_series Ritmo_promedio  Vueltas  Tiempo_ingesta_previa  \\\n",
       "0               00:00:00           3.60       96               00:40:00   \n",
       "1               00:00:30           4.20       71               01:00:00   \n",
       "2               00:00:45           3.54       71               01:00:00   \n",
       "3               00:01:00           4.34       67               01:00:00   \n",
       "4               00:01:30           4.50       39               01:00:00   \n",
       "5               00:01:30           4.54       55               01:00:00   \n",
       "6               00:01:30           4.27       61               01:00:00   \n",
       "7               00:01:30           4.08       41               01:00:00   \n",
       "8               00:01:30          17.55       12               01:00:00   \n",
       "\n",
       "      Ingesta_descripcion  Suplemento_dietario  Ejercicios_previos  \\\n",
       "0  Cafe, pan, clara huevo             Creatina            Caminata   \n",
       "1     Leche con coco, pan             Creatina            Caminata   \n",
       "2  Cafe, cereales, banana             Creatina            Caminata   \n",
       "3  Cafe, cereales, banana             Creatina            Caminata   \n",
       "4            Cafe, banana             Creatina            Caminata   \n",
       "5  Cafe, cereales, banana             Creatina            Caminata   \n",
       "6             Cafe, panes             Creatina            Caminata   \n",
       "7  Cafe, cereales, banana             Creatina            Caminata   \n",
       "8                  Banana             Creatina            Caminata   \n",
       "\n",
       "  Tiempo_ejercicios_previos  Sensaciones_entrenamiento  \n",
       "0                  00:00:10                 Muy buenas  \n",
       "1                  00:00:15                 Muy buenas  \n",
       "2                  00:00:10                 Muy buenas  \n",
       "3                  00:00:10                     Buenas  \n",
       "4                  00:00:10                     Buenas  \n",
       "5                  00:00:10                     Buenas  \n",
       "6                  00:00:10                     Buenas  \n",
       "7                  00:00:10                     Buenas  \n",
       "8                  00:00:10            Piscina Pequeña  \n",
       "\n",
       "[9 rows x 30 columns]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df.head(9)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "3dde5982-82ff-4d2d-be45-a969208682e4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(9, 30)"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3b57ea8e-cdba-4243-9f40-653275aef8d8",
   "metadata": {},
   "source": [
    "### Algunas ooperaciones sobre el dataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "5e846e7d-0060-4f48-a39a-2e624aa6365e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0         Muy buenas\n",
       "1         Muy buenas\n",
       "2             Buenas\n",
       "3             Buenas\n",
       "4             Buenas\n",
       "5             Buenas\n",
       "6             Buenas\n",
       "7    Piscina Pequeña\n",
       "Name: Sensaciones_entrenamiento, dtype: object"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df.Sensaciones_entrenamiento"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "aa1d1e19-87d0-4512-9569-0d6465fb05c0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Fecha</th>\n",
       "      <th>Hora_inicio</th>\n",
       "      <th>Hora_de_finalización</th>\n",
       "      <th>Duración_sesion</th>\n",
       "      <th>Tipo_entrenamiento</th>\n",
       "      <th>Objetivos</th>\n",
       "      <th>Metas</th>\n",
       "      <th>Metros_piscina</th>\n",
       "      <th>Metros_totales</th>\n",
       "      <th>Cantidad_de_brazadas</th>\n",
       "      <th>...</th>\n",
       "      <th>Repeticiones_estilo_crawl</th>\n",
       "      <th>Descanso_entre_series</th>\n",
       "      <th>Ritmo_promedio</th>\n",
       "      <th>Vueltas</th>\n",
       "      <th>Tiempo_ingesta_previa</th>\n",
       "      <th>Ingesta_descripcion</th>\n",
       "      <th>Suplemento_dietario</th>\n",
       "      <th>Ejercicios_previos</th>\n",
       "      <th>Tiempo_ejercicios_previos</th>\n",
       "      <th>Sensaciones_entrenamiento</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2023-01-30</td>\n",
       "      <td>09:05:00</td>\n",
       "      <td>10:05:00</td>\n",
       "      <td>01:01:11</td>\n",
       "      <td>Series</td>\n",
       "      <td>Mejorar Tecnica</td>\n",
       "      <td>Mejorar rendimiento</td>\n",
       "      <td>20</td>\n",
       "      <td>1420</td>\n",
       "      <td>980</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>00:00:30</td>\n",
       "      <td>4.2</td>\n",
       "      <td>71</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>Leche con coco, pan</td>\n",
       "      <td>Creatina</td>\n",
       "      <td>Caminata</td>\n",
       "      <td>00:00:15</td>\n",
       "      <td>Muy buenas</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Fecha Hora_inicio Hora_de_finalización Duración_sesion  \\\n",
       "0  2023-01-30    09:05:00             10:05:00        01:01:11   \n",
       "\n",
       "  Tipo_entrenamiento        Objetivos                Metas  Metros_piscina  \\\n",
       "0             Series  Mejorar Tecnica  Mejorar rendimiento              20   \n",
       "\n",
       "   Metros_totales  Cantidad_de_brazadas  ...  Repeticiones_estilo_crawl  \\\n",
       "0            1420                   980  ...                        4.0   \n",
       "\n",
       "   Descanso_entre_series Ritmo_promedio  Vueltas  Tiempo_ingesta_previa  \\\n",
       "0               00:00:30            4.2       71               01:00:00   \n",
       "\n",
       "   Ingesta_descripcion  Suplemento_dietario  Ejercicios_previos  \\\n",
       "0  Leche con coco, pan             Creatina            Caminata   \n",
       "\n",
       "  Tiempo_ejercicios_previos  Sensaciones_entrenamiento  \n",
       "0                  00:00:15                 Muy buenas  \n",
       "\n",
       "[1 rows x 30 columns]"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df.loc[(new_df.Sensaciones_entrenamiento == 'Muy buenas') & (new_df.Ingesta_descripcion == 'Leche con coco, pan')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "39690185-b708-4523-892c-323180623153",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       Leche con coco, pan\n",
       "1    Cafe, cereales, banana\n",
       "2    Cafe, cereales, banana\n",
       "3              Cafe, banana\n",
       "4    Cafe, cereales, banana\n",
       "5               Cafe, panes\n",
       "6    Cafe, cereales, banana\n",
       "7                    Banana\n",
       "Name: Ingesta_descripcion, dtype: object"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df.Ingesta_descripcion"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "default:Python",
   "language": "python",
   "name": "conda-env-default-py"
  },
  "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
}