{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "6513c86d",
   "metadata": {},
   "source": [
    "# Ejemplos de Uso de la Librería `bcchapi`\n",
    "\n",
    "Este notebook muestra cómo usar los métodos `buscar` y `cuadro` de la librería `bcchapi` para interactuar con la API del Banco Central de Chile.\n",
    "\n",
    "## Instalación\n",
    "```bash\n",
    "pip install bcchapi\n",
    "```\n",
    "\n",
    "## Configuración inicial\n",
    "Necesitas un API Key Token válido para acceder a la API del Banco Central."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "66663389",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Librería bcchapi importada y configurada\n"
     ]
    }
   ],
   "source": [
    "# Importar la librería\n",
    "import bcchapi\n",
    "import pandas as pd\n",
    "\n",
    "# Crear una instancia con tu token\n",
    "siete = bcchapi.Siete(token=\"tu_token\")\n",
    "\n",
    "print(\"Librería bcchapi importada y configurada\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "dd55590b",
   "metadata": {},
   "source": [
    "---\n",
    "## Ejemplo 1: Buscar y Consultar el Dólar Observado\n",
    "\n",
    "En este ejemplo:\n",
    "1. Buscamos series relacionadas con \"dólar observado\"\n",
    "2. Consultamos los datos usando el código específico\n",
    "3. Calculamos estadísticas básicas con los datos extraidos\n",
    "4. Extra: Mostramos diferentes opciones del método `cuadro`"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ef4f8445",
   "metadata": {},
   "source": [
    "### Paso 1: Buscar la serie del Dólar Observado"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f51578ad",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Se encontraron 3 series relacionadas con 'dólar observado'\n",
      "\n",
      "Primeras 5 coincidencias:\n"
     ]
    },
    {
     "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>seriesId</th>\n",
       "      <th>frequencyCode</th>\n",
       "      <th>spanishTitle</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>F073.TCO.PRE.Z.A</td>\n",
       "      <td>ANNUAL</td>\n",
       "      <td>Tipo de cambio nominal (dólar observado $CLP/U...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>F073.TCO.PRE.HIST.M</td>\n",
       "      <td>MONTHLY</td>\n",
       "      <td>Tipo de cambio del dólar observado diario, ser...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>F073.TCO.PRE.Z.D</td>\n",
       "      <td>DAILY</td>\n",
       "      <td>Tipo de cambio nominal (dólar observado $CLP/U...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              seriesId frequencyCode  \\\n",
       "0     F073.TCO.PRE.Z.A        ANNUAL   \n",
       "1  F073.TCO.PRE.HIST.M       MONTHLY   \n",
       "2     F073.TCO.PRE.Z.D         DAILY   \n",
       "\n",
       "                                        spanishTitle  \n",
       "0  Tipo de cambio nominal (dólar observado $CLP/U...  \n",
       "1  Tipo de cambio del dólar observado diario, ser...  \n",
       "2  Tipo de cambio nominal (dólar observado $CLP/U...  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Buscar \"dólar observado\" en las series disponibles\n",
    "resultado_busqueda = siete.buscar(\"dólar observado\")\n",
    "print(f\"Se encontraron {len(resultado_busqueda)} series relacionadas con 'dólar observado'\")\n",
    "print(\"\\nPrimeras 5 coincidencias:\")\n",
    "resultado_busqueda[['seriesId', 'frequencyCode', 'spanishTitle']].head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "704f5132",
   "metadata": {},
   "source": [
    "### Paso 2: Consultar los datos de la serie específica\n",
    "\n",
    "Usaremos el código: `F073.TCO.PRE.Z.D` (Tipo de cambio nominal peso/dólar - diario)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2b8dc91e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Datos obtenidos: 394 observaciones\n",
      "Período: 2024-09-02 00:00:00 a 2025-09-30 00:00:00\n",
      "\n",
      "Últimas 10 observaciones:\n"
     ]
    },
    {
     "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>F073.TCO.PRE.Z.D</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2025-09-21</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-09-22</th>\n",
       "      <td>951.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-09-23</th>\n",
       "      <td>954.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-09-24</th>\n",
       "      <td>952.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-09-25</th>\n",
       "      <td>953.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-09-26</th>\n",
       "      <td>956.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-09-27</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-09-28</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-09-29</th>\n",
       "      <td>958.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-09-30</th>\n",
       "      <td>961.24</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            F073.TCO.PRE.Z.D\n",
       "2025-09-21               NaN\n",
       "2025-09-22            951.03\n",
       "2025-09-23            954.72\n",
       "2025-09-24            952.87\n",
       "2025-09-25            953.24\n",
       "2025-09-26            956.42\n",
       "2025-09-27               NaN\n",
       "2025-09-28               NaN\n",
       "2025-09-29            958.90\n",
       "2025-09-30            961.24"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Consultar datos del último año\n",
    "datos_dolar = siete.cuadro(\n",
    "    series=[\"F073.TCO.PRE.Z.D\"],\n",
    "    desde=\"2024-09-01\",\n",
    "    hasta=\"2025-09-30\"\n",
    ")\n",
    "\n",
    "print(f\"Datos obtenidos: {len(datos_dolar)} observaciones\")\n",
    "print(f\"Período: {datos_dolar.index.min()} a {datos_dolar.index.max()}\")\n",
    "print(\"\\nÚltimas 10 observaciones:\")\n",
    "datos_dolar.tail(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8d248275",
   "metadata": {},
   "source": [
    "### Paso 3: Obtener estadisticas básicas dela serie consultada"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b9ebac54",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Estadísticas del Dólar Observado:\n",
      "Valor mínimo: $896.25\n",
      "Valor máximo: $1012.76\n",
      "Valor promedio: $955.93\n",
      "Última observación: $961.24\n"
     ]
    }
   ],
   "source": [
    "# Estadísticas básicas\n",
    "print(\"Estadísticas del Dólar Observado:\")\n",
    "print(f\"Valor mínimo: ${datos_dolar.min().iloc[0]:.2f}\")\n",
    "print(f\"Valor máximo: ${datos_dolar.max().iloc[0]:.2f}\")\n",
    "print(f\"Valor promedio: ${datos_dolar.mean().iloc[0]:.2f}\")\n",
    "print(f\"Última observación: ${datos_dolar.iloc[-1, 0]:.2f}\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ea2e8b23",
   "metadata": {},
   "source": [
    "### Extra: Usando diferentes parámetros del método `cuadro`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "83088a82",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Dólar Observado - Promedio Mensual 2024-2025:\n"
     ]
    },
    {
     "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>Dólar Observado</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2024-09-30</th>\n",
       "      <td>926.214444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-10-31</th>\n",
       "      <td>933.812273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-11-30</th>\n",
       "      <td>971.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-12-31</th>\n",
       "      <td>982.296000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-01-31</th>\n",
       "      <td>1000.763636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-02-28</th>\n",
       "      <td>956.620000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-03-31</th>\n",
       "      <td>932.551905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-04-30</th>\n",
       "      <td>961.957143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-05-31</th>\n",
       "      <td>941.012500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-06-30</th>\n",
       "      <td>938.037000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-07-31</th>\n",
       "      <td>951.550000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-08-31</th>\n",
       "      <td>966.303500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-09-30</th>\n",
       "      <td>960.367500</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Dólar Observado\n",
       "2024-09-30       926.214444\n",
       "2024-10-31       933.812273\n",
       "2024-11-30       971.600000\n",
       "2024-12-31       982.296000\n",
       "2025-01-31      1000.763636\n",
       "2025-02-28       956.620000\n",
       "2025-03-31       932.551905\n",
       "2025-04-30       961.957143\n",
       "2025-05-31       941.012500\n",
       "2025-06-30       938.037000\n",
       "2025-07-31       951.550000\n",
       "2025-08-31       966.303500\n",
       "2025-09-30       960.367500"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Ejemplo con nombre personalizado y frecuencia mensual\n",
    "datos_dolar_mensual = siete.cuadro(\n",
    "    series=[\"F073.TCO.PRE.Z.D\"],\n",
    "    desde=\"2024-09-01\",\n",
    "    hasta=\"2025-09-30\",\n",
    "    nombres=[\"Dólar Observado\"],\n",
    "    frecuencia=\"M\",  # Mensual\n",
    "    observado=\"mean\"  # Promedio mensual\n",
    ")\n",
    "\n",
    "print(\"Dólar Observado - Promedio Mensual 2024-2025:\")\n",
    "datos_dolar_mensual"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "21f83055",
   "metadata": {},
   "source": [
    "---\n",
    "## Ejemplo 2: PIB e IMACEC con frecuencias distintas\n",
    "\n",
    "Este ejemplo muestra el manejo completo de series con diferentes frecuencias:\n",
    "- **IMACEC**: Mensual (`F032.IMC.IND.Z.Z.EP18.Z.Z.0.M`)\n",
    "- **PIB**: Trimestral (`F032.PIB.FLU.R.CLP.EP18.Z.Z.0.T`)\n",
    "\n",
    "Seguiremos estos pasos:\n",
    "1. Buscar las series\n",
    "2. Consultar cada serie por separado\n",
    "3. Calcular variaciones interanuales de cada serie\n",
    "4. Consultar ambas series"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "69d99dff",
   "metadata": {},
   "source": [
    "### Paso 1: Buscar las series"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f96e3111",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Series encontradas para IMACEC: 4\n",
      "\n",
      "Primeras coincidencias:\n"
     ]
    },
    {
     "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>seriesId</th>\n",
       "      <th>frequencyCode</th>\n",
       "      <th>spanishTitle</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>F032.IMC.IND.Z.Z.EP13.Z.Z.0.M</td>\n",
       "      <td>MONTHLY</td>\n",
       "      <td>Imacec empalmado, serie original (índice 2013=...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>F032.IMC.IND.Z.Z.EP13.Z.Z.1.M</td>\n",
       "      <td>MONTHLY</td>\n",
       "      <td>Imacec empalmado, desestacionalizado (índice 2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>F032.IMC.IND.Z.Z.EP18.Z.Z.0.M</td>\n",
       "      <td>MONTHLY</td>\n",
       "      <td>Imacec empalmado, serie original (índice 2018=...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>F032.IMC.IND.Z.Z.EP18.Z.Z.1.M</td>\n",
       "      <td>MONTHLY</td>\n",
       "      <td>Imacec empalmado, desestacionalizado (índice 2...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        seriesId frequencyCode  \\\n",
       "0  F032.IMC.IND.Z.Z.EP13.Z.Z.0.M       MONTHLY   \n",
       "1  F032.IMC.IND.Z.Z.EP13.Z.Z.1.M       MONTHLY   \n",
       "2  F032.IMC.IND.Z.Z.EP18.Z.Z.0.M       MONTHLY   \n",
       "3  F032.IMC.IND.Z.Z.EP18.Z.Z.1.M       MONTHLY   \n",
       "\n",
       "                                        spanishTitle  \n",
       "0  Imacec empalmado, serie original (índice 2013=...  \n",
       "1  Imacec empalmado, desestacionalizado (índice 2...  \n",
       "2  Imacec empalmado, serie original (índice 2018=...  \n",
       "3  Imacec empalmado, desestacionalizado (índice 2...  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Buscar IMACEC\n",
    "resultado_imacec = siete.buscar(\"Imacec empalmado\")\n",
    "print(f\"Series encontradas para IMACEC: {len(resultado_imacec)}\")\n",
    "print(\"\\nPrimeras coincidencias:\")\n",
    "resultado_imacec[['seriesId', 'frequencyCode', 'spanishTitle']].head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "aff91393",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Series encontradas para PIB: 68\n",
      "\n",
      "Últimas coincidencias:\n"
     ]
    },
    {
     "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>seriesId</th>\n",
       "      <th>frequencyCode</th>\n",
       "      <th>spanishTitle</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>F032.PIB.FLU.R.CLP.2018.Z.Z.2025MAR.T</td>\n",
       "      <td>QUARTERLY</td>\n",
       "      <td>PIB, volumen a precios del año anterior encade...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>F032.PIB.FLU.R.CLP.2018.Z.Z.2025MAY.T</td>\n",
       "      <td>QUARTERLY</td>\n",
       "      <td>PIB, volumen a precios del año anterior encade...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>F032.PIB.FLU.R.CLP.2018.Z.Z.2025NOV.T</td>\n",
       "      <td>QUARTERLY</td>\n",
       "      <td>PIB, volumen a precios del año anterior encade...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>F032.PIB.FLU.R.CLP.EP08.Z.Z.0.T</td>\n",
       "      <td>QUARTERLY</td>\n",
       "      <td>PIB, volumen a precios del año anterior encade...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>F032.PIB.FLU.R.CLP.EP13.Z.Z.0.T</td>\n",
       "      <td>QUARTERLY</td>\n",
       "      <td>PIB, volumen a precios del año anterior encade...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>F032.PIB.FLU.R.CLP.EP18.Z.Z.0.T</td>\n",
       "      <td>QUARTERLY</td>\n",
       "      <td>PIB, volumen a precios del año anterior encade...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>F032.PIB.FLU.R.CLP.HIST.Z.Z.0.T</td>\n",
       "      <td>QUARTERLY</td>\n",
       "      <td>PIB, volumen a precios del año anterior encade...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>F032.PIB.FLU.R.CLP.HIST.Z.Z.3.T</td>\n",
       "      <td>QUARTERLY</td>\n",
       "      <td>PIB, volumen a precios del año anterior encade...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>F032.PIB.FLU.R.CLP.HIST13.Z.Z.0.T</td>\n",
       "      <td>QUARTERLY</td>\n",
       "      <td>PIB, volumen a precios del año anterior encade...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>F032.PIB.FLU.R.CLP.HIST13.Z.Z.3.T</td>\n",
       "      <td>QUARTERLY</td>\n",
       "      <td>PIB, volumen a precios del año anterior encade...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 seriesId frequencyCode  \\\n",
       "58  F032.PIB.FLU.R.CLP.2018.Z.Z.2025MAR.T     QUARTERLY   \n",
       "59  F032.PIB.FLU.R.CLP.2018.Z.Z.2025MAY.T     QUARTERLY   \n",
       "60  F032.PIB.FLU.R.CLP.2018.Z.Z.2025NOV.T     QUARTERLY   \n",
       "61        F032.PIB.FLU.R.CLP.EP08.Z.Z.0.T     QUARTERLY   \n",
       "62        F032.PIB.FLU.R.CLP.EP13.Z.Z.0.T     QUARTERLY   \n",
       "63        F032.PIB.FLU.R.CLP.EP18.Z.Z.0.T     QUARTERLY   \n",
       "64        F032.PIB.FLU.R.CLP.HIST.Z.Z.0.T     QUARTERLY   \n",
       "65        F032.PIB.FLU.R.CLP.HIST.Z.Z.3.T     QUARTERLY   \n",
       "66      F032.PIB.FLU.R.CLP.HIST13.Z.Z.0.T     QUARTERLY   \n",
       "67      F032.PIB.FLU.R.CLP.HIST13.Z.Z.3.T     QUARTERLY   \n",
       "\n",
       "                                         spanishTitle  \n",
       "58  PIB, volumen a precios del año anterior encade...  \n",
       "59  PIB, volumen a precios del año anterior encade...  \n",
       "60  PIB, volumen a precios del año anterior encade...  \n",
       "61  PIB, volumen a precios del año anterior encade...  \n",
       "62  PIB, volumen a precios del año anterior encade...  \n",
       "63  PIB, volumen a precios del año anterior encade...  \n",
       "64  PIB, volumen a precios del año anterior encade...  \n",
       "65  PIB, volumen a precios del año anterior encade...  \n",
       "66  PIB, volumen a precios del año anterior encade...  \n",
       "67  PIB, volumen a precios del año anterior encade...  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Buscar PIB\n",
    "resultado_pib = siete.buscar(\"PIB, volumen a precios del año anterior encadenado\")\n",
    "print(f\"Series encontradas para PIB: {len(resultado_pib)}\")\n",
    "print(\"\\nÚltimas coincidencias:\")\n",
    "resultado_pib[['seriesId', 'frequencyCode', 'spanishTitle']].tail(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "36653300",
   "metadata": {},
   "source": [
    "### Paso 2: Consultar cada serie por separado"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3c0bfa31",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "IMACEC: 21 observaciones mensuales\n",
      "Período: 2024-01 a 2025-09\n"
     ]
    },
    {
     "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>IMACEC</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2025-05-01</th>\n",
       "      <td>112.950836</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-06-01</th>\n",
       "      <td>108.388247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-07-01</th>\n",
       "      <td>109.039654</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-08-01</th>\n",
       "      <td>110.446073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-09-01</th>\n",
       "      <td>109.152886</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                IMACEC\n",
       "2025-05-01  112.950836\n",
       "2025-06-01  108.388247\n",
       "2025-07-01  109.039654\n",
       "2025-08-01  110.446073\n",
       "2025-09-01  109.152886"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Consultar IMACEC (mensual)\n",
    "imacec = siete.cuadro(\n",
    "    series=[\"F032.IMC.IND.Z.Z.EP18.Z.Z.0.M\"],\n",
    "    desde=\"2024-01-01\",\n",
    "    hasta=\"2025-09-30\",\n",
    "    nombres=[\"IMACEC\"]\n",
    ")\n",
    "\n",
    "print(f\"IMACEC: {len(imacec)} observaciones mensuales\")\n",
    "print(f\"Período: {imacec.index.min().strftime('%Y-%m')} a {imacec.index.max().strftime('%Y-%m')}\")\n",
    "imacec.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3303f10b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "PIB: 7 observaciones trimestrales\n",
      "Período: 2024-01 a 2025-07\n"
     ]
    },
    {
     "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>PIB</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2024-01-01</th>\n",
       "      <td>51629.653131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-04-01</th>\n",
       "      <td>51347.892689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-07-01</th>\n",
       "      <td>51072.569785</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-10-01</th>\n",
       "      <td>55879.020025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-01-01</th>\n",
       "      <td>52974.863449</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-04-01</th>\n",
       "      <td>53039.105024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-07-01</th>\n",
       "      <td>51879.676786</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     PIB\n",
       "2024-01-01  51629.653131\n",
       "2024-04-01  51347.892689\n",
       "2024-07-01  51072.569785\n",
       "2024-10-01  55879.020025\n",
       "2025-01-01  52974.863449\n",
       "2025-04-01  53039.105024\n",
       "2025-07-01  51879.676786"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Consultar PIB (trimestral)\n",
    "pib = siete.cuadro(\n",
    "    series=[\"F032.PIB.FLU.R.CLP.EP18.Z.Z.0.T\"],\n",
    "    desde=\"2024-01-01\",\n",
    "    hasta=\"2025-09-30\",\n",
    "    nombres=[\"PIB\"]\n",
    ")\n",
    "\n",
    "print(f\"PIB: {len(pib)} observaciones trimestrales\")\n",
    "print(f\"Período: {pib.index.min().strftime('%Y-%m')} a {pib.index.max().strftime('%Y-%m')}\")\n",
    "pib"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9aaa34d9",
   "metadata": {},
   "source": [
    "### Paso 3: Calcular variaciones interanuales de cada serie"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "bb5f5a55",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "IMACEC - Variación interanual (%):\n"
     ]
    },
    {
     "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>IMACEC_var</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2025-05-01</th>\n",
       "      <td>3.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-06-01</th>\n",
       "      <td>3.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-07-01</th>\n",
       "      <td>1.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-08-01</th>\n",
       "      <td>0.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-09-01</th>\n",
       "      <td>2.70</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            IMACEC_var\n",
       "2025-05-01        3.45\n",
       "2025-06-01        3.30\n",
       "2025-07-01        1.84\n",
       "2025-08-01        0.26\n",
       "2025-09-01        2.70"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Variación interanual del IMACEC\n",
    "imacec_var = siete.cuadro(\n",
    "    series=[\"F032.IMC.IND.Z.Z.EP18.Z.Z.0.M\"],\n",
    "    desde=\"2024-01-01\",\n",
    "    hasta=\"2025-09-30\",\n",
    "    nombres=[\"IMACEC_var\"],\n",
    "    variacion=12  # 12 meses hacia atrás\n",
    ")\n",
    "\n",
    "print(\"IMACEC - Variación interanual (%):\")\n",
    "(imacec_var * 100).round(2).tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e8dae6ca",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "PIB - Variación interanual (%):\n"
     ]
    },
    {
     "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>PIB_var</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2024-07-01</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-10-01</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-01-01</th>\n",
       "      <td>2.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-04-01</th>\n",
       "      <td>3.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025-07-01</th>\n",
       "      <td>1.58</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            PIB_var\n",
       "2024-07-01      NaN\n",
       "2024-10-01      NaN\n",
       "2025-01-01     2.61\n",
       "2025-04-01     3.29\n",
       "2025-07-01     1.58"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Variación interanual del PIB\n",
    "pib_var = siete.cuadro(\n",
    "    series=[\"F032.PIB.FLU.R.CLP.EP18.Z.Z.0.T\"],\n",
    "    desde=\"2024-01-01\",\n",
    "    hasta=\"2025-09-30\",\n",
    "    nombres=[\"PIB_var\"],\n",
    "    variacion=12  # 12 meses hacia atrás\n",
    ")\n",
    "\n",
    "print(\"PIB - Variación interanual (%):\")\n",
    "(pib_var * 100).round(2).tail()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "11a02273",
   "metadata": {},
   "source": [
    "### Paso 4: Consultar ambas series con frecuencia original"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a8b5b18a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Datos combinados (frecuencia original):\n"
     ]
    },
    {
     "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>IMACEC</th>\n",
       "      <th>PIB</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2024-01-01</th>\n",
       "      <td>107.868108</td>\n",
       "      <td>51629.653131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-02-01</th>\n",
       "      <td>104.151200</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-03-01</th>\n",
       "      <td>115.035498</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-04-01</th>\n",
       "      <td>111.159047</td>\n",
       "      <td>51347.892689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-05-01</th>\n",
       "      <td>109.182567</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-06-01</th>\n",
       "      <td>104.928343</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-07-01</th>\n",
       "      <td>107.073852</td>\n",
       "      <td>51072.569785</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-08-01</th>\n",
       "      <td>110.163804</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                IMACEC           PIB\n",
       "2024-01-01  107.868108  51629.653131\n",
       "2024-02-01  104.151200           NaN\n",
       "2024-03-01  115.035498           NaN\n",
       "2024-04-01  111.159047  51347.892689\n",
       "2024-05-01  109.182567           NaN\n",
       "2024-06-01  104.928343           NaN\n",
       "2024-07-01  107.073852  51072.569785\n",
       "2024-08-01  110.163804           NaN"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Consultar ambas series con su frecuencia original\n",
    "datos_combinados = siete.cuadro(\n",
    "    series=[\n",
    "        \"F032.IMC.IND.Z.Z.EP18.Z.Z.0.M\",  # IMACEC (mensual)\n",
    "        \"F032.PIB.FLU.R.CLP.EP18.Z.Z.0.T\"   # PIB (trimestral)\n",
    "    ],\n",
    "    desde=\"2024-01-01\",\n",
    "    hasta=\"2025-09-30\",\n",
    "    nombres=[\"IMACEC\", \"PIB\"]\n",
    ")\n",
    "\n",
    "print(\"Datos combinados (frecuencia original):\")\n",
    "datos_combinados.head(8)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}