01-tabla.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "711d1328",
   "metadata": {},
   "source": [
    "Genera una tabla cargando del excel los datos iniciales de las imágenes, y añadiendo las medidas realizadas por nosotros"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "id": "0b0384cf",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import glob\n",
    "import re\n",
    "import re\n",
    "import os\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "id": "86a732d7",
   "metadata": {},
   "outputs": [],
   "source": [
    "tablepath='datos/medidas.xlsx'\n",
    "# Echar vistazo a esto https://en.wikipedia.org/wiki/Student%27s_t-distribution#Table_of_selected_values\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "id": "303f3be2",
   "metadata": {},
   "outputs": [],
   "source": [
    "lambdadisco= {'Halfa-7 nm':656.281,\n",
    "              'Halfa-35 nm':656.281,\n",
    "              'Hbeta-8.5nm':486.135}\n",
    "dlambdadisco={'Halfa-7 nm':7,\n",
    "              'Halfa-35 nm':35,\n",
    "              'Hbeta-8.5nm':8.5}\n",
    "alphap_mas  ={'Sirio':6.04,\n",
    "              'Rigel':2.77,\n",
    "              'Betelgeuse':54.04,\n",
    "              'GammaLeo':7.70}\n",
    "filtername= {'Halfa-7 nm':'H-alpha (7 nm)',\n",
    "              'Halfa-35 nm':'H-alpha (35 nm)',\n",
    "              'Hbeta-8.5nm':'H-beta (8.5 nm)'}\n",
    "starname={'Sirio':'Sirius',\n",
    "          'Rigel':'Rigel',\n",
    "          'Betelgeuse':'Betelgeuse',\n",
    "          'GammaLeo':'GammaLeo'}\n",
    "\n",
    "alphap={k:ap*(np.pi/180/1000/3600) for k, ap in alphap_mas.items()} #rad"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "id": "8f956585",
   "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>Objeto</th>\n",
       "      <th>Filtro</th>\n",
       "      <th>Disco</th>\n",
       "      <th>D (mm)</th>\n",
       "      <th>L (mm)</th>\n",
       "      <th>L1 (mm)</th>\n",
       "      <th>L2 (mm)</th>\n",
       "      <th>Notas</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Imagen</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>1</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>I</td>\n",
       "      <td>22</td>\n",
       "      <td>220</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>H</td>\n",
       "      <td>22</td>\n",
       "      <td>158</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>G</td>\n",
       "      <td>61</td>\n",
       "      <td>178</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>E</td>\n",
       "      <td>51</td>\n",
       "      <td>222</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Doble</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>F</td>\n",
       "      <td>51</td>\n",
       "      <td>147</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>E</td>\n",
       "      <td>51</td>\n",
       "      <td>222</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Betelgeuse</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>F</td>\n",
       "      <td>51</td>\n",
       "      <td>147</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Betelgeuse</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B/L+C</td>\n",
       "      <td>30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>133.0</td>\n",
       "      <td>238.0</td>\n",
       "      <td>4X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Betelgeuse</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30</td>\n",
       "      <td>238</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Betelgeuse</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30</td>\n",
       "      <td>133</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30</td>\n",
       "      <td>133</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>F</td>\n",
       "      <td>51</td>\n",
       "      <td>147</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30</td>\n",
       "      <td>238</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30</td>\n",
       "      <td>133</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>E</td>\n",
       "      <td>50</td>\n",
       "      <td>222</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>C</td>\n",
       "      <td>65</td>\n",
       "      <td>162</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Hbeta-8.5nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30</td>\n",
       "      <td>133</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>C</td>\n",
       "      <td>66</td>\n",
       "      <td>162</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Hbeta-8.5nm</td>\n",
       "      <td>B</td>\n",
       "      <td>66</td>\n",
       "      <td>162</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>D</td>\n",
       "      <td>66</td>\n",
       "      <td>205</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>A</td>\n",
       "      <td>90</td>\n",
       "      <td>187</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Hbeta-8.5nm</td>\n",
       "      <td>A</td>\n",
       "      <td>90</td>\n",
       "      <td>187</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>GammaLeo</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>F</td>\n",
       "      <td>51</td>\n",
       "      <td>147</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>GammaLeo</td>\n",
       "      <td>sF</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Estrella</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Objeto        Filtro   Disco D (mm) L (mm)  L1 (mm)  L2 (mm)  \\\n",
       "Imagen                                                                      \n",
       "1            Sirio    Halfa-7 nm       I      22    220      NaN      NaN   \n",
       "2            Sirio    Halfa-7 nm       H      22    158      NaN      NaN   \n",
       "3            Sirio    Halfa-7 nm       G      61    178      NaN      NaN   \n",
       "4            Rigel    Halfa-7 nm       E      51    222      NaN      NaN   \n",
       "5            Rigel    Halfa-7 nm      NaN    NaN    NaN      NaN      NaN   \n",
       "6            Rigel   Halfa-35 nm       F      51    147      NaN      NaN   \n",
       "7            Rigel   Halfa-35 nm       E      51    222      NaN      NaN   \n",
       "8       Betelgeuse   Halfa-35 nm       F      51    147      NaN      NaN   \n",
       "9       Betelgeuse   Halfa-35 nm   B/L+C      30    NaN    133.0    238.0   \n",
       "10      Betelgeuse   Halfa-35 nm       B      30    238      NaN      NaN   \n",
       "11      Betelgeuse   Halfa-35 nm       B      30    133      NaN      NaN   \n",
       "12           Sirio   Halfa-35 nm       B      30    133      NaN      NaN   \n",
       "13           Rigel    Halfa-7 nm       F      51    147      NaN      NaN   \n",
       "14           Sirio   Halfa-35 nm       B      30    238      NaN      NaN   \n",
       "15           Sirio   Halfa-35 nm       B      30    133      NaN      NaN   \n",
       "16           Sirio   Halfa-35 nm       E      50    222      NaN      NaN   \n",
       "17           Sirio   Halfa-35 nm       C      65    162      NaN      NaN   \n",
       "18           Sirio   Hbeta-8.5nm       B      30    133      NaN      NaN   \n",
       "19           Sirio   Halfa-35 nm       C      66    162      NaN      NaN   \n",
       "20           Sirio   Hbeta-8.5nm       B      66    162      NaN      NaN   \n",
       "21           Sirio   Halfa-35 nm       D      66    205      NaN      NaN   \n",
       "22           Sirio   Halfa-35 nm       A      90    187      NaN      NaN   \n",
       "23           Sirio   Hbeta-8.5nm       A      90    187      NaN      NaN   \n",
       "24        GammaLeo   Halfa-35 nm       F      51    147      NaN      NaN   \n",
       "25        GammaLeo            sF       -      -      -       NaN      NaN   \n",
       "\n",
       "           Notas  \n",
       "Imagen            \n",
       "1            NaN  \n",
       "2            NaN  \n",
       "3            NaN  \n",
       "4            NaN  \n",
       "5          Doble  \n",
       "6            NaN  \n",
       "7            NaN  \n",
       "8            NaN  \n",
       "9             4X  \n",
       "10           NaN  \n",
       "11           NaN  \n",
       "12           NaN  \n",
       "13           NaN  \n",
       "14           NaN  \n",
       "15           NaN  \n",
       "16           NaN  \n",
       "17           NaN  \n",
       "18           NaN  \n",
       "19           NaN  \n",
       "20           NaN  \n",
       "21           NaN  \n",
       "22           NaN  \n",
       "23           NaN  \n",
       "24           NaN  \n",
       "25      Estrella  "
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dts={}#{'D (mm)':np.int16,'L (mm)':np.int16,'L1 (mm)':np.int16,'L2 (mm)':np.int16}\n",
    "cols=['D (mm)','L (mm)','L1 (mm)','L2 (mm)']\n",
    "df=pd.read_excel(tablepath,engine=\"openpyxl\",index_col=0,converters=dts                 \n",
    "                )\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "id": "2a439311",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Objeto      object\n",
       "Filtro      object\n",
       "Disco       object\n",
       "D (mm)      object\n",
       "L (mm)      object\n",
       "L1 (mm)    float64\n",
       "L2 (mm)    float64\n",
       "Notas       object\n",
       "dtype: object"
      ]
     },
     "execution_count": 93,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "id": "20d01b07",
   "metadata": {},
   "outputs": [],
   "source": [
    "for c in cols:\n",
    "    df[c]=pd.to_numeric(df[c],errors='coerce')\n",
    "df['Filtro']=df['Filtro'].str.strip()\n",
    "df['Objeto']=df['Objeto'].str.strip()\n",
    "df['Disco']=df['Disco'].str.strip()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "id": "3476af7a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Objeto      object\n",
       "Filtro      object\n",
       "Disco       object\n",
       "D (mm)     float64\n",
       "L (mm)     float64\n",
       "L1 (mm)    float64\n",
       "L2 (mm)    float64\n",
       "Notas       object\n",
       "dtype: object"
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "id": "a25675d7",
   "metadata": {
    "scrolled": true,
    "tags": []
   },
   "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>PATH</th>\n",
       "      <th>Imagen</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>datos/imagenes\\Beltegeuse\\10Betelgeuse0016 Bx3...</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>datos/imagenes\\Beltegeuse\\11Betelgeuse0017 Bx3...</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>datos/imagenes\\Beltegeuse\\8Betelgeuse0012 Bx3 ...</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>datos/imagenes\\Beltegeuse\\9Betelgeuse0014 Bx3 ...</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>datos/imagenes\\Gamma Leo\\24Gamma Leo0003 Bx3 H...</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>datos/imagenes\\Gamma Leo\\25Gamma Leo0001 Bx3 s...</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>datos/imagenes\\Rigel\\13Rigel0004 Bx3 Halfa35nm...</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>datos/imagenes\\Rigel\\4Rigel0002 Bx3 Halfa7nm I...</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>datos/imagenes\\Rigel\\5Rigel0003 sB Halfa7nm Im...</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>datos/imagenes\\Rigel\\6Rigel0008 Bx3 Halfa35nm ...</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>datos/imagenes\\Rigel\\7Rigel0009 Bx3 Halfa35nm ...</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>datos/imagenes\\Sirio\\12Sirio0006 Bx3 Halfa35nm...</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>datos/imagenes\\Sirio\\14Sirio0009 Bx3 Halfa35nm...</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>datos/imagenes\\Sirio\\15Sirio0010 Bx3 Halfa35nm...</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>datos/imagenes\\Sirio\\16Sirio0012 Bx3 Halfa35nm...</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>datos/imagenes\\Sirio\\17Sirio0014 Bx3 Halfa35nm...</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>datos/imagenes\\Sirio\\18Sirio0016 Bx3 Hbeta 8.5...</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>datos/imagenes\\Sirio\\19Sirio0001 Bx3 Halfa35nm...</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>datos/imagenes\\Sirio\\1Sirio0005 Bx3 Halfa 7 nm...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>datos/imagenes\\Sirio\\20Sirio0002 Bx3 Hbeta8.5n...</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>datos/imagenes\\Sirio\\21Sirio0004  Bx3 Halfa35n...</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>datos/imagenes\\Sirio\\22Sirio0006  Bx3 Halfa35n...</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>datos/imagenes\\Sirio\\23Sirio0007 Bx3 Hbeta8.5n...</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>datos/imagenes\\Sirio\\2Sirio0007 Bx3 Halfa 7 nm...</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>datos/imagenes\\Sirio\\3Sirio0011 Bx3 Halfa 7 nm...</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 PATH  Imagen\n",
       "10  datos/imagenes\\Beltegeuse\\10Betelgeuse0016 Bx3...      10\n",
       "11  datos/imagenes\\Beltegeuse\\11Betelgeuse0017 Bx3...      11\n",
       "8   datos/imagenes\\Beltegeuse\\8Betelgeuse0012 Bx3 ...       8\n",
       "9   datos/imagenes\\Beltegeuse\\9Betelgeuse0014 Bx3 ...       9\n",
       "24  datos/imagenes\\Gamma Leo\\24Gamma Leo0003 Bx3 H...      24\n",
       "25  datos/imagenes\\Gamma Leo\\25Gamma Leo0001 Bx3 s...      25\n",
       "13  datos/imagenes\\Rigel\\13Rigel0004 Bx3 Halfa35nm...      13\n",
       "4   datos/imagenes\\Rigel\\4Rigel0002 Bx3 Halfa7nm I...       4\n",
       "5   datos/imagenes\\Rigel\\5Rigel0003 sB Halfa7nm Im...       5\n",
       "6   datos/imagenes\\Rigel\\6Rigel0008 Bx3 Halfa35nm ...       6\n",
       "7   datos/imagenes\\Rigel\\7Rigel0009 Bx3 Halfa35nm ...       7\n",
       "12  datos/imagenes\\Sirio\\12Sirio0006 Bx3 Halfa35nm...      12\n",
       "14  datos/imagenes\\Sirio\\14Sirio0009 Bx3 Halfa35nm...      14\n",
       "15  datos/imagenes\\Sirio\\15Sirio0010 Bx3 Halfa35nm...      15\n",
       "16  datos/imagenes\\Sirio\\16Sirio0012 Bx3 Halfa35nm...      16\n",
       "17  datos/imagenes\\Sirio\\17Sirio0014 Bx3 Halfa35nm...      17\n",
       "18  datos/imagenes\\Sirio\\18Sirio0016 Bx3 Hbeta 8.5...      18\n",
       "19  datos/imagenes\\Sirio\\19Sirio0001 Bx3 Halfa35nm...      19\n",
       "1   datos/imagenes\\Sirio\\1Sirio0005 Bx3 Halfa 7 nm...       1\n",
       "20  datos/imagenes\\Sirio\\20Sirio0002 Bx3 Hbeta8.5n...      20\n",
       "21  datos/imagenes\\Sirio\\21Sirio0004  Bx3 Halfa35n...      21\n",
       "22  datos/imagenes\\Sirio\\22Sirio0006  Bx3 Halfa35n...      22\n",
       "23  datos/imagenes\\Sirio\\23Sirio0007 Bx3 Hbeta8.5n...      23\n",
       "2   datos/imagenes\\Sirio\\2Sirio0007 Bx3 Halfa 7 nm...       2\n",
       "3   datos/imagenes\\Sirio\\3Sirio0011 Bx3 Halfa 7 nm...       3"
      ]
     },
     "execution_count": 96,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "names=[]\n",
    "ims=[]\n",
    "for name in glob.glob('datos/imagenes/*/*.tif'):\n",
    "    names.append(name)\n",
    "    ims.append(int(re.search('\\d+', name.split('\\\\')[-1])[0]))\n",
    "\n",
    "paths=pd.DataFrame({'PATH':names,'Imagen':ims},index=ims)\n",
    "paths"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "id": "43eea84b",
   "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>Objeto</th>\n",
       "      <th>Filtro</th>\n",
       "      <th>Disco</th>\n",
       "      <th>D (mm)</th>\n",
       "      <th>L (mm)</th>\n",
       "      <th>L1 (mm)</th>\n",
       "      <th>L2 (mm)</th>\n",
       "      <th>Notas</th>\n",
       "      <th>PATH</th>\n",
       "      <th>Imagen</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Imagen</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>1</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>I</td>\n",
       "      <td>22.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\1Sirio0005 Bx3 Halfa 7 nm...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>H</td>\n",
       "      <td>22.0</td>\n",
       "      <td>158.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\2Sirio0007 Bx3 Halfa 7 nm...</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>G</td>\n",
       "      <td>61.0</td>\n",
       "      <td>178.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\3Sirio0011 Bx3 Halfa 7 nm...</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>E</td>\n",
       "      <td>51.0</td>\n",
       "      <td>222.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Rigel\\4Rigel0002 Bx3 Halfa7nm I...</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Doble</td>\n",
       "      <td>datos/imagenes\\Rigel\\5Rigel0003 sB Halfa7nm Im...</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>F</td>\n",
       "      <td>51.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Rigel\\6Rigel0008 Bx3 Halfa35nm ...</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>E</td>\n",
       "      <td>51.0</td>\n",
       "      <td>222.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Rigel\\7Rigel0009 Bx3 Halfa35nm ...</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Betelgeuse</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>F</td>\n",
       "      <td>51.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Beltegeuse\\8Betelgeuse0012 Bx3 ...</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Betelgeuse</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B/L+C</td>\n",
       "      <td>30.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>133.0</td>\n",
       "      <td>238.0</td>\n",
       "      <td>4X</td>\n",
       "      <td>datos/imagenes\\Beltegeuse\\9Betelgeuse0014 Bx3 ...</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Betelgeuse</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30.0</td>\n",
       "      <td>238.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Beltegeuse\\10Betelgeuse0016 Bx3...</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Betelgeuse</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Beltegeuse\\11Betelgeuse0017 Bx3...</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\12Sirio0006 Bx3 Halfa35nm...</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>F</td>\n",
       "      <td>51.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Rigel\\13Rigel0004 Bx3 Halfa35nm...</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30.0</td>\n",
       "      <td>238.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\14Sirio0009 Bx3 Halfa35nm...</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\15Sirio0010 Bx3 Halfa35nm...</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>E</td>\n",
       "      <td>50.0</td>\n",
       "      <td>222.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\16Sirio0012 Bx3 Halfa35nm...</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>C</td>\n",
       "      <td>65.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\17Sirio0014 Bx3 Halfa35nm...</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Hbeta-8.5nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\18Sirio0016 Bx3 Hbeta 8.5...</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>C</td>\n",
       "      <td>66.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\19Sirio0001 Bx3 Halfa35nm...</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Hbeta-8.5nm</td>\n",
       "      <td>B</td>\n",
       "      <td>66.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\20Sirio0002 Bx3 Hbeta8.5n...</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>D</td>\n",
       "      <td>66.0</td>\n",
       "      <td>205.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\21Sirio0004  Bx3 Halfa35n...</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>A</td>\n",
       "      <td>90.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\22Sirio0006  Bx3 Halfa35n...</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Hbeta-8.5nm</td>\n",
       "      <td>A</td>\n",
       "      <td>90.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\23Sirio0007 Bx3 Hbeta8.5n...</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>GammaLeo</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>F</td>\n",
       "      <td>51.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Gamma Leo\\24Gamma Leo0003 Bx3 H...</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>GammaLeo</td>\n",
       "      <td>sF</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Estrella</td>\n",
       "      <td>datos/imagenes\\Gamma Leo\\25Gamma Leo0001 Bx3 s...</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Objeto       Filtro  Disco  D (mm)  L (mm)  L1 (mm)  L2 (mm)  \\\n",
       "Imagen                                                                     \n",
       "1            Sirio   Halfa-7 nm      I    22.0   220.0      NaN      NaN   \n",
       "2            Sirio   Halfa-7 nm      H    22.0   158.0      NaN      NaN   \n",
       "3            Sirio   Halfa-7 nm      G    61.0   178.0      NaN      NaN   \n",
       "4            Rigel   Halfa-7 nm      E    51.0   222.0      NaN      NaN   \n",
       "5            Rigel   Halfa-7 nm    NaN     NaN     NaN      NaN      NaN   \n",
       "6            Rigel  Halfa-35 nm      F    51.0   147.0      NaN      NaN   \n",
       "7            Rigel  Halfa-35 nm      E    51.0   222.0      NaN      NaN   \n",
       "8       Betelgeuse  Halfa-35 nm      F    51.0   147.0      NaN      NaN   \n",
       "9       Betelgeuse  Halfa-35 nm  B/L+C    30.0     NaN    133.0    238.0   \n",
       "10      Betelgeuse  Halfa-35 nm      B    30.0   238.0      NaN      NaN   \n",
       "11      Betelgeuse  Halfa-35 nm      B    30.0   133.0      NaN      NaN   \n",
       "12           Sirio  Halfa-35 nm      B    30.0   133.0      NaN      NaN   \n",
       "13           Rigel   Halfa-7 nm      F    51.0   147.0      NaN      NaN   \n",
       "14           Sirio  Halfa-35 nm      B    30.0   238.0      NaN      NaN   \n",
       "15           Sirio  Halfa-35 nm      B    30.0   133.0      NaN      NaN   \n",
       "16           Sirio  Halfa-35 nm      E    50.0   222.0      NaN      NaN   \n",
       "17           Sirio  Halfa-35 nm      C    65.0   162.0      NaN      NaN   \n",
       "18           Sirio  Hbeta-8.5nm      B    30.0   133.0      NaN      NaN   \n",
       "19           Sirio  Halfa-35 nm      C    66.0   162.0      NaN      NaN   \n",
       "20           Sirio  Hbeta-8.5nm      B    66.0   162.0      NaN      NaN   \n",
       "21           Sirio  Halfa-35 nm      D    66.0   205.0      NaN      NaN   \n",
       "22           Sirio  Halfa-35 nm      A    90.0   187.0      NaN      NaN   \n",
       "23           Sirio  Hbeta-8.5nm      A    90.0   187.0      NaN      NaN   \n",
       "24        GammaLeo  Halfa-35 nm      F    51.0   147.0      NaN      NaN   \n",
       "25        GammaLeo           sF      -     NaN     NaN      NaN      NaN   \n",
       "\n",
       "           Notas                                               PATH  Imagen  \n",
       "Imagen                                                                       \n",
       "1            NaN  datos/imagenes\\Sirio\\1Sirio0005 Bx3 Halfa 7 nm...       1  \n",
       "2            NaN  datos/imagenes\\Sirio\\2Sirio0007 Bx3 Halfa 7 nm...       2  \n",
       "3            NaN  datos/imagenes\\Sirio\\3Sirio0011 Bx3 Halfa 7 nm...       3  \n",
       "4            NaN  datos/imagenes\\Rigel\\4Rigel0002 Bx3 Halfa7nm I...       4  \n",
       "5          Doble  datos/imagenes\\Rigel\\5Rigel0003 sB Halfa7nm Im...       5  \n",
       "6            NaN  datos/imagenes\\Rigel\\6Rigel0008 Bx3 Halfa35nm ...       6  \n",
       "7            NaN  datos/imagenes\\Rigel\\7Rigel0009 Bx3 Halfa35nm ...       7  \n",
       "8            NaN  datos/imagenes\\Beltegeuse\\8Betelgeuse0012 Bx3 ...       8  \n",
       "9             4X  datos/imagenes\\Beltegeuse\\9Betelgeuse0014 Bx3 ...       9  \n",
       "10           NaN  datos/imagenes\\Beltegeuse\\10Betelgeuse0016 Bx3...      10  \n",
       "11           NaN  datos/imagenes\\Beltegeuse\\11Betelgeuse0017 Bx3...      11  \n",
       "12           NaN  datos/imagenes\\Sirio\\12Sirio0006 Bx3 Halfa35nm...      12  \n",
       "13           NaN  datos/imagenes\\Rigel\\13Rigel0004 Bx3 Halfa35nm...      13  \n",
       "14           NaN  datos/imagenes\\Sirio\\14Sirio0009 Bx3 Halfa35nm...      14  \n",
       "15           NaN  datos/imagenes\\Sirio\\15Sirio0010 Bx3 Halfa35nm...      15  \n",
       "16           NaN  datos/imagenes\\Sirio\\16Sirio0012 Bx3 Halfa35nm...      16  \n",
       "17           NaN  datos/imagenes\\Sirio\\17Sirio0014 Bx3 Halfa35nm...      17  \n",
       "18           NaN  datos/imagenes\\Sirio\\18Sirio0016 Bx3 Hbeta 8.5...      18  \n",
       "19           NaN  datos/imagenes\\Sirio\\19Sirio0001 Bx3 Halfa35nm...      19  \n",
       "20           NaN  datos/imagenes\\Sirio\\20Sirio0002 Bx3 Hbeta8.5n...      20  \n",
       "21           NaN  datos/imagenes\\Sirio\\21Sirio0004  Bx3 Halfa35n...      21  \n",
       "22           NaN  datos/imagenes\\Sirio\\22Sirio0006  Bx3 Halfa35n...      22  \n",
       "23           NaN  datos/imagenes\\Sirio\\23Sirio0007 Bx3 Hbeta8.5n...      23  \n",
       "24           NaN  datos/imagenes\\Gamma Leo\\24Gamma Leo0003 Bx3 H...      24  \n",
       "25      Estrella  datos/imagenes\\Gamma Leo\\25Gamma Leo0001 Bx3 s...      25  "
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2=df.join(paths)\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "id": "158ee604",
   "metadata": {},
   "outputs": [],
   "source": [
    "df2['$\\lambda$']=df2['Filtro'].map(lambdadisco)\n",
    "df2['$d\\lambda$']=df2['Filtro'].map(dlambdadisco)\n",
    "df2['alphap']=df2['Objeto'].map(alphap)\n",
    "df2['alphap_mas']=df2['alphap'].apply(lambda x: x/ (np.pi/180/1000/3600))\n",
    "df2['filtername']=df2['Filtro'].map(filtername)\n",
    "df2['starname']=df2['Objeto'].map(starname)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "id": "53ec3894",
   "metadata": {},
   "outputs": [],
   "source": [
    "# df2['V_exp']=df2['Objeto'].map(starname)\n",
    "\n",
    "# s='1Sirio0005 Bx3 Halfa 7 nm Inter1_I_D22mm-L220mm_2.4s Gmax 17-03-10 20-48-51.tif'\n",
    "# re.findall(\"\\d{2}-\\d{2}-\\d{2}\", s.split('\\\\')[-1])[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "id": "915c8b14",
   "metadata": {},
   "outputs": [],
   "source": [
    "df2['DATE']=df2['PATH'].apply(lambda x: re.findall(\"\\d{2}-\\d{2}-\\d{2}\", x.split('\\\\')[-1])[0])\n",
    "df2['DAY']=df2['DATE'].apply(lambda x:int(x.split('-')[-1]))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "id": "915c8b14",
   "metadata": {},
   "outputs": [],
   "source": [
    "df2['HOUR']=df2['PATH'].apply(lambda x: re.findall(\"\\d{2}-\\d{2}-\\d{2}\", x.split('\\\\')[-1])[1].replace('-',':'))\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cc6c5160",
   "metadata": {},
   "source": [
    "Cargamos la tabla con las medidas originales que realizamos en el aula con imagej"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "id": "9e3696ed",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfV=pd.read_csv(\"datos/v_individualesyajuster0inicial.csv\",sep=';',index_col='indice')[['V_media','S']].rename(columns={'V_media':\"V_media_antigua\",'S':\"S_antigua\"})\n",
    "#dfV=pd.read_csv(\"datos/medidas_iniciales.csv\",sep=';',index_col=1).rename(columns={'MEDIA V':\"V_promedio_antigua\"})\n",
    "\n",
    "#tenemos que añadir esto para que funcione el script hasta que metamos los datos nuevos\n",
    "# dfV['V_media']=dfV['V_media_antigua']\n",
    "# dfV['S']=dfV['S_antigua']\n",
    "\n",
    "#Calculamos desviacion tipica\n",
    "dfV['S_tip_antigua']=dfV['S_antigua']*1/(3**0.5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "id": "b26166ac",
   "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>V_media_antigua</th>\n",
       "      <th>S_antigua</th>\n",
       "      <th>S_tip_antigua</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>indice</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.641222</td>\n",
       "      <td>0.008581</td>\n",
       "      <td>0.004954</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0.483885</td>\n",
       "      <td>0.015082</td>\n",
       "      <td>0.008708</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.322587</td>\n",
       "      <td>0.003800</td>\n",
       "      <td>0.002194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0.211979</td>\n",
       "      <td>0.018689</td>\n",
       "      <td>0.010790</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.096563</td>\n",
       "      <td>0.003182</td>\n",
       "      <td>0.001837</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0.439454</td>\n",
       "      <td>0.007861</td>\n",
       "      <td>0.004539</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.144100</td>\n",
       "      <td>0.008017</td>\n",
       "      <td>0.004628</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0.308249</td>\n",
       "      <td>0.003382</td>\n",
       "      <td>0.001953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.094463</td>\n",
       "      <td>0.017632</td>\n",
       "      <td>0.010180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.033639</td>\n",
       "      <td>0.014732</td>\n",
       "      <td>0.008506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.277885</td>\n",
       "      <td>0.002123</td>\n",
       "      <td>0.001226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0.342583</td>\n",
       "      <td>0.000277</td>\n",
       "      <td>0.000160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0.015108</td>\n",
       "      <td>0.001886</td>\n",
       "      <td>0.001089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0.268869</td>\n",
       "      <td>0.013899</td>\n",
       "      <td>0.008025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0.139991</td>\n",
       "      <td>0.021037</td>\n",
       "      <td>0.012146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0.205609</td>\n",
       "      <td>0.051177</td>\n",
       "      <td>0.029547</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0.060419</td>\n",
       "      <td>0.002892</td>\n",
       "      <td>0.001669</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0.372131</td>\n",
       "      <td>0.017874</td>\n",
       "      <td>0.010320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0.072809</td>\n",
       "      <td>0.004383</td>\n",
       "      <td>0.002530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0.138379</td>\n",
       "      <td>0.003587</td>\n",
       "      <td>0.002071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0.226591</td>\n",
       "      <td>0.002237</td>\n",
       "      <td>0.001291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0.139635</td>\n",
       "      <td>0.002157</td>\n",
       "      <td>0.001246</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        V_media_antigua  S_antigua  S_tip_antigua\n",
       "indice                                           \n",
       "8              0.641222   0.008581       0.004954\n",
       "9              0.483885   0.015082       0.008708\n",
       "10             0.322587   0.003800       0.002194\n",
       "11             0.211979   0.018689       0.010790\n",
       "4              0.096563   0.003182       0.001837\n",
       "6              0.439454   0.007861       0.004539\n",
       "7              0.144100   0.008017       0.004628\n",
       "13             0.308249   0.003382       0.001953\n",
       "1              0.094463   0.017632       0.010180\n",
       "2              0.033639   0.014732       0.008506\n",
       "3              0.277885   0.002123       0.001226\n",
       "12             0.342583   0.000277       0.000160\n",
       "14             0.015108   0.001886       0.001089\n",
       "15             0.268869   0.013899       0.008025\n",
       "16             0.139991   0.021037       0.012146\n",
       "17             0.205609   0.051177       0.029547\n",
       "18             0.060419   0.002892       0.001669\n",
       "19             0.372131   0.017874       0.010320\n",
       "20             0.072809   0.004383       0.002530\n",
       "21             0.138379   0.003587       0.002071\n",
       "22             0.226591   0.002237       0.001291\n",
       "23             0.139635   0.002157       0.001246"
      ]
     },
     "execution_count": 103,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfV"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "id": "3a5689b9",
   "metadata": {},
   "outputs": [],
   "source": [
    "df3=df2.join(dfV)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "69816d81",
   "metadata": {},
   "source": [
    "Añadimos los nuevos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "id": "b6dc99b8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 3 entries, 8 to 11\n",
      "Data columns (total 2 columns):\n",
      " #   Column   Non-Null Count  Dtype  \n",
      "---  ------   --------------  -----  \n",
      " 0   V_media  3 non-null      float64\n",
      " 1   S        3 non-null      float64\n",
      "dtypes: float64(2)\n",
      "memory usage: 72.0 bytes\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "c:\\Users\\ivian\\.conda\\envs\\jupy\\lib\\site-packages\\pandas\\util\\_decorators.py:311: ParserWarning: Both a converter and dtype were specified for column Index - only the converter will be used.\n",
      "  return func(*args, **kwargs)\n"
     ]
    }
   ],
   "source": [
    "numerar=lambda x: int(x) if x!='' else None\n",
    "dfV=pd.read_csv(\"datos/repetimos_medidas.csv\",sep=';',index_col='Index',converters={\"Index\":numerar},dtype={\"Index\":int,\"V_media\":float,'S':float},na_values=['',\"#¡DIV/0!\"])[['V_media','S']]\n",
    "dfV.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "id": "fac64c04",
   "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>V_media</th>\n",
       "      <th>S</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.632407</td>\n",
       "      <td>0.014108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.294962</td>\n",
       "      <td>0.025108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0.219090</td>\n",
       "      <td>0.008554</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        V_media         S\n",
       "Index                    \n",
       "8      0.632407  0.014108\n",
       "10     0.294962  0.025108\n",
       "11     0.219090  0.008554"
      ]
     },
     "execution_count": 106,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfV.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "id": "fc208e0f",
   "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>V_media</th>\n",
       "      <th>S</th>\n",
       "      <th>S_tip</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       V_media   S  S_tip\n",
       "Index                    \n",
       "8          NaN NaN    NaN\n",
       "10         NaN NaN    NaN\n",
       "11         NaN NaN    NaN"
      ]
     },
     "execution_count": 107,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Si volvemos a usar esas medidas hay que calcular la desviación tipica aqui tambien\n",
    "#(de momento para no utilizar los valores repetidos la borramos, habria que comentar)\n",
    "\n",
    "dfV['V_media']=np.nan\n",
    "dfV['S']=np.nan\n",
    "dfV['S_tip']=np.nan\n",
    "\n",
    "dfV.head(4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "id": "561da2c7",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "\n",
    "df3=df3.join(dfV)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2a866d54",
   "metadata": {},
   "source": [
    "Copiamos los valores antiguos si no se repitio la medida"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "id": "0f611d79",
   "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>Objeto</th>\n",
       "      <th>Filtro</th>\n",
       "      <th>Disco</th>\n",
       "      <th>D (mm)</th>\n",
       "      <th>L (mm)</th>\n",
       "      <th>L1 (mm)</th>\n",
       "      <th>L2 (mm)</th>\n",
       "      <th>Notas</th>\n",
       "      <th>PATH</th>\n",
       "      <th>Imagen</th>\n",
       "      <th>...</th>\n",
       "      <th>starname</th>\n",
       "      <th>DATE</th>\n",
       "      <th>DAY</th>\n",
       "      <th>HOUR</th>\n",
       "      <th>V_media_antigua</th>\n",
       "      <th>S_antigua</th>\n",
       "      <th>S_tip_antigua</th>\n",
       "      <th>V_media</th>\n",
       "      <th>S</th>\n",
       "      <th>S_tip</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Imagen</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>1</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>I</td>\n",
       "      <td>22.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\1Sirio0005 Bx3 Halfa 7 nm...</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>Sirius</td>\n",
       "      <td>17-03-10</td>\n",
       "      <td>10</td>\n",
       "      <td>20:48:51</td>\n",
       "      <td>0.094463</td>\n",
       "      <td>0.017632</td>\n",
       "      <td>0.010180</td>\n",
       "      <td>0.094463</td>\n",
       "      <td>0.017632</td>\n",
       "      <td>0.010180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>H</td>\n",
       "      <td>22.0</td>\n",
       "      <td>158.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\2Sirio0007 Bx3 Halfa 7 nm...</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>Sirius</td>\n",
       "      <td>17-03-10</td>\n",
       "      <td>10</td>\n",
       "      <td>20:54:18</td>\n",
       "      <td>0.033639</td>\n",
       "      <td>0.014732</td>\n",
       "      <td>0.008506</td>\n",
       "      <td>0.033639</td>\n",
       "      <td>0.014732</td>\n",
       "      <td>0.008506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>G</td>\n",
       "      <td>61.0</td>\n",
       "      <td>178.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\3Sirio0011 Bx3 Halfa 7 nm...</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>Sirius</td>\n",
       "      <td>17-03-10</td>\n",
       "      <td>10</td>\n",
       "      <td>21:05:53</td>\n",
       "      <td>0.277885</td>\n",
       "      <td>0.002123</td>\n",
       "      <td>0.001226</td>\n",
       "      <td>0.277885</td>\n",
       "      <td>0.002123</td>\n",
       "      <td>0.001226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>E</td>\n",
       "      <td>51.0</td>\n",
       "      <td>222.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Rigel\\4Rigel0002 Bx3 Halfa7nm I...</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>Rigel</td>\n",
       "      <td>17-03-15</td>\n",
       "      <td>15</td>\n",
       "      <td>20:38:22</td>\n",
       "      <td>0.096563</td>\n",
       "      <td>0.003182</td>\n",
       "      <td>0.001837</td>\n",
       "      <td>0.096563</td>\n",
       "      <td>0.003182</td>\n",
       "      <td>0.001837</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Doble</td>\n",
       "      <td>datos/imagenes\\Rigel\\5Rigel0003 sB Halfa7nm Im...</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>Rigel</td>\n",
       "      <td>17-03-15</td>\n",
       "      <td>15</td>\n",
       "      <td>20:43:57</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>F</td>\n",
       "      <td>51.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Rigel\\6Rigel0008 Bx3 Halfa35nm ...</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>Rigel</td>\n",
       "      <td>17-03-15</td>\n",
       "      <td>15</td>\n",
       "      <td>21:14:55</td>\n",
       "      <td>0.439454</td>\n",
       "      <td>0.007861</td>\n",
       "      <td>0.004539</td>\n",
       "      <td>0.439454</td>\n",
       "      <td>0.007861</td>\n",
       "      <td>0.004539</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>E</td>\n",
       "      <td>51.0</td>\n",
       "      <td>222.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Rigel\\7Rigel0009 Bx3 Halfa35nm ...</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>Rigel</td>\n",
       "      <td>17-03-15</td>\n",
       "      <td>15</td>\n",
       "      <td>21:19:47</td>\n",
       "      <td>0.144100</td>\n",
       "      <td>0.008017</td>\n",
       "      <td>0.004628</td>\n",
       "      <td>0.144100</td>\n",
       "      <td>0.008017</td>\n",
       "      <td>0.004628</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Betelgeuse</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>F</td>\n",
       "      <td>51.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Beltegeuse\\8Betelgeuse0012 Bx3 ...</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>Betelgeuse</td>\n",
       "      <td>17-03-15</td>\n",
       "      <td>15</td>\n",
       "      <td>21:41:53</td>\n",
       "      <td>0.641222</td>\n",
       "      <td>0.008581</td>\n",
       "      <td>0.004954</td>\n",
       "      <td>0.641222</td>\n",
       "      <td>0.008581</td>\n",
       "      <td>0.004954</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Betelgeuse</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B/L+C</td>\n",
       "      <td>30.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>133.0</td>\n",
       "      <td>238.0</td>\n",
       "      <td>4X</td>\n",
       "      <td>datos/imagenes\\Beltegeuse\\9Betelgeuse0014 Bx3 ...</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Betelgeuse</td>\n",
       "      <td>17-03-15</td>\n",
       "      <td>15</td>\n",
       "      <td>21:51:31</td>\n",
       "      <td>0.483885</td>\n",
       "      <td>0.015082</td>\n",
       "      <td>0.008708</td>\n",
       "      <td>0.483885</td>\n",
       "      <td>0.015082</td>\n",
       "      <td>0.008708</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Betelgeuse</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30.0</td>\n",
       "      <td>238.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Beltegeuse\\10Betelgeuse0016 Bx3...</td>\n",
       "      <td>10</td>\n",
       "      <td>...</td>\n",
       "      <td>Betelgeuse</td>\n",
       "      <td>17-03-15</td>\n",
       "      <td>15</td>\n",
       "      <td>22:01:11</td>\n",
       "      <td>0.322587</td>\n",
       "      <td>0.003800</td>\n",
       "      <td>0.002194</td>\n",
       "      <td>0.322587</td>\n",
       "      <td>0.003800</td>\n",
       "      <td>0.002194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Betelgeuse</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Beltegeuse\\11Betelgeuse0017 Bx3...</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>Betelgeuse</td>\n",
       "      <td>17-03-15</td>\n",
       "      <td>15</td>\n",
       "      <td>22:05:53</td>\n",
       "      <td>0.211979</td>\n",
       "      <td>0.018689</td>\n",
       "      <td>0.010790</td>\n",
       "      <td>0.211979</td>\n",
       "      <td>0.018689</td>\n",
       "      <td>0.010790</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\12Sirio0006 Bx3 Halfa35nm...</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>Sirius</td>\n",
       "      <td>17-03-16</td>\n",
       "      <td>16</td>\n",
       "      <td>21:47:29</td>\n",
       "      <td>0.342583</td>\n",
       "      <td>0.000277</td>\n",
       "      <td>0.000160</td>\n",
       "      <td>0.342583</td>\n",
       "      <td>0.000277</td>\n",
       "      <td>0.000160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>F</td>\n",
       "      <td>51.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Rigel\\13Rigel0004 Bx3 Halfa35nm...</td>\n",
       "      <td>13</td>\n",
       "      <td>...</td>\n",
       "      <td>Rigel</td>\n",
       "      <td>17-03-23</td>\n",
       "      <td>23</td>\n",
       "      <td>20:46:30</td>\n",
       "      <td>0.308249</td>\n",
       "      <td>0.003382</td>\n",
       "      <td>0.001953</td>\n",
       "      <td>0.308249</td>\n",
       "      <td>0.003382</td>\n",
       "      <td>0.001953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30.0</td>\n",
       "      <td>238.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\14Sirio0009 Bx3 Halfa35nm...</td>\n",
       "      <td>14</td>\n",
       "      <td>...</td>\n",
       "      <td>Sirius</td>\n",
       "      <td>17-03-23</td>\n",
       "      <td>23</td>\n",
       "      <td>21:15:50</td>\n",
       "      <td>0.015108</td>\n",
       "      <td>0.001886</td>\n",
       "      <td>0.001089</td>\n",
       "      <td>0.015108</td>\n",
       "      <td>0.001886</td>\n",
       "      <td>0.001089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\15Sirio0010 Bx3 Halfa35nm...</td>\n",
       "      <td>15</td>\n",
       "      <td>...</td>\n",
       "      <td>Sirius</td>\n",
       "      <td>17-03-23</td>\n",
       "      <td>23</td>\n",
       "      <td>21:20:55</td>\n",
       "      <td>0.268869</td>\n",
       "      <td>0.013899</td>\n",
       "      <td>0.008025</td>\n",
       "      <td>0.268869</td>\n",
       "      <td>0.013899</td>\n",
       "      <td>0.008025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>E</td>\n",
       "      <td>50.0</td>\n",
       "      <td>222.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\16Sirio0012 Bx3 Halfa35nm...</td>\n",
       "      <td>16</td>\n",
       "      <td>...</td>\n",
       "      <td>Sirius</td>\n",
       "      <td>17-03-23</td>\n",
       "      <td>23</td>\n",
       "      <td>21:29:27</td>\n",
       "      <td>0.139991</td>\n",
       "      <td>0.021037</td>\n",
       "      <td>0.012146</td>\n",
       "      <td>0.139991</td>\n",
       "      <td>0.021037</td>\n",
       "      <td>0.012146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>C</td>\n",
       "      <td>65.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\17Sirio0014 Bx3 Halfa35nm...</td>\n",
       "      <td>17</td>\n",
       "      <td>...</td>\n",
       "      <td>Sirius</td>\n",
       "      <td>17-03-23</td>\n",
       "      <td>23</td>\n",
       "      <td>21:35:19</td>\n",
       "      <td>0.205609</td>\n",
       "      <td>0.051177</td>\n",
       "      <td>0.029547</td>\n",
       "      <td>0.205609</td>\n",
       "      <td>0.051177</td>\n",
       "      <td>0.029547</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Hbeta-8.5nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\18Sirio0016 Bx3 Hbeta 8.5...</td>\n",
       "      <td>18</td>\n",
       "      <td>...</td>\n",
       "      <td>Sirius</td>\n",
       "      <td>17-03-23</td>\n",
       "      <td>23</td>\n",
       "      <td>21:44:25</td>\n",
       "      <td>0.060419</td>\n",
       "      <td>0.002892</td>\n",
       "      <td>0.001669</td>\n",
       "      <td>0.060419</td>\n",
       "      <td>0.002892</td>\n",
       "      <td>0.001669</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>C</td>\n",
       "      <td>66.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\19Sirio0001 Bx3 Halfa35nm...</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>Sirius</td>\n",
       "      <td>17-03-29</td>\n",
       "      <td>29</td>\n",
       "      <td>21:32:34</td>\n",
       "      <td>0.372131</td>\n",
       "      <td>0.017874</td>\n",
       "      <td>0.010320</td>\n",
       "      <td>0.372131</td>\n",
       "      <td>0.017874</td>\n",
       "      <td>0.010320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Hbeta-8.5nm</td>\n",
       "      <td>B</td>\n",
       "      <td>66.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\20Sirio0002 Bx3 Hbeta8.5n...</td>\n",
       "      <td>20</td>\n",
       "      <td>...</td>\n",
       "      <td>Sirius</td>\n",
       "      <td>17-03-29</td>\n",
       "      <td>29</td>\n",
       "      <td>21:36:56</td>\n",
       "      <td>0.072809</td>\n",
       "      <td>0.004383</td>\n",
       "      <td>0.002530</td>\n",
       "      <td>0.072809</td>\n",
       "      <td>0.004383</td>\n",
       "      <td>0.002530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>D</td>\n",
       "      <td>66.0</td>\n",
       "      <td>205.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\21Sirio0004  Bx3 Halfa35n...</td>\n",
       "      <td>21</td>\n",
       "      <td>...</td>\n",
       "      <td>Sirius</td>\n",
       "      <td>17-03-29</td>\n",
       "      <td>29</td>\n",
       "      <td>21:45:14</td>\n",
       "      <td>0.138379</td>\n",
       "      <td>0.003587</td>\n",
       "      <td>0.002071</td>\n",
       "      <td>0.138379</td>\n",
       "      <td>0.003587</td>\n",
       "      <td>0.002071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>A</td>\n",
       "      <td>90.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\22Sirio0006  Bx3 Halfa35n...</td>\n",
       "      <td>22</td>\n",
       "      <td>...</td>\n",
       "      <td>Sirius</td>\n",
       "      <td>17-03-29</td>\n",
       "      <td>29</td>\n",
       "      <td>21:48:54</td>\n",
       "      <td>0.226591</td>\n",
       "      <td>0.002237</td>\n",
       "      <td>0.001291</td>\n",
       "      <td>0.226591</td>\n",
       "      <td>0.002237</td>\n",
       "      <td>0.001291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Hbeta-8.5nm</td>\n",
       "      <td>A</td>\n",
       "      <td>90.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\23Sirio0007 Bx3 Hbeta8.5n...</td>\n",
       "      <td>23</td>\n",
       "      <td>...</td>\n",
       "      <td>Sirius</td>\n",
       "      <td>17-03-29</td>\n",
       "      <td>29</td>\n",
       "      <td>21:51:23</td>\n",
       "      <td>0.139635</td>\n",
       "      <td>0.002157</td>\n",
       "      <td>0.001246</td>\n",
       "      <td>0.139635</td>\n",
       "      <td>0.002157</td>\n",
       "      <td>0.001246</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>GammaLeo</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>F</td>\n",
       "      <td>51.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Gamma Leo\\24Gamma Leo0003 Bx3 H...</td>\n",
       "      <td>24</td>\n",
       "      <td>...</td>\n",
       "      <td>GammaLeo</td>\n",
       "      <td>17-04-07</td>\n",
       "      <td>7</td>\n",
       "      <td>23:00:37</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>GammaLeo</td>\n",
       "      <td>sF</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Estrella</td>\n",
       "      <td>datos/imagenes\\Gamma Leo\\25Gamma Leo0001 Bx3 s...</td>\n",
       "      <td>25</td>\n",
       "      <td>...</td>\n",
       "      <td>GammaLeo</td>\n",
       "      <td>17-04-07</td>\n",
       "      <td>7</td>\n",
       "      <td>22:45:11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Objeto       Filtro  Disco  D (mm)  L (mm)  L1 (mm)  L2 (mm)  \\\n",
       "Imagen                                                                     \n",
       "1            Sirio   Halfa-7 nm      I    22.0   220.0      NaN      NaN   \n",
       "2            Sirio   Halfa-7 nm      H    22.0   158.0      NaN      NaN   \n",
       "3            Sirio   Halfa-7 nm      G    61.0   178.0      NaN      NaN   \n",
       "4            Rigel   Halfa-7 nm      E    51.0   222.0      NaN      NaN   \n",
       "5            Rigel   Halfa-7 nm    NaN     NaN     NaN      NaN      NaN   \n",
       "6            Rigel  Halfa-35 nm      F    51.0   147.0      NaN      NaN   \n",
       "7            Rigel  Halfa-35 nm      E    51.0   222.0      NaN      NaN   \n",
       "8       Betelgeuse  Halfa-35 nm      F    51.0   147.0      NaN      NaN   \n",
       "9       Betelgeuse  Halfa-35 nm  B/L+C    30.0     NaN    133.0    238.0   \n",
       "10      Betelgeuse  Halfa-35 nm      B    30.0   238.0      NaN      NaN   \n",
       "11      Betelgeuse  Halfa-35 nm      B    30.0   133.0      NaN      NaN   \n",
       "12           Sirio  Halfa-35 nm      B    30.0   133.0      NaN      NaN   \n",
       "13           Rigel   Halfa-7 nm      F    51.0   147.0      NaN      NaN   \n",
       "14           Sirio  Halfa-35 nm      B    30.0   238.0      NaN      NaN   \n",
       "15           Sirio  Halfa-35 nm      B    30.0   133.0      NaN      NaN   \n",
       "16           Sirio  Halfa-35 nm      E    50.0   222.0      NaN      NaN   \n",
       "17           Sirio  Halfa-35 nm      C    65.0   162.0      NaN      NaN   \n",
       "18           Sirio  Hbeta-8.5nm      B    30.0   133.0      NaN      NaN   \n",
       "19           Sirio  Halfa-35 nm      C    66.0   162.0      NaN      NaN   \n",
       "20           Sirio  Hbeta-8.5nm      B    66.0   162.0      NaN      NaN   \n",
       "21           Sirio  Halfa-35 nm      D    66.0   205.0      NaN      NaN   \n",
       "22           Sirio  Halfa-35 nm      A    90.0   187.0      NaN      NaN   \n",
       "23           Sirio  Hbeta-8.5nm      A    90.0   187.0      NaN      NaN   \n",
       "24        GammaLeo  Halfa-35 nm      F    51.0   147.0      NaN      NaN   \n",
       "25        GammaLeo           sF      -     NaN     NaN      NaN      NaN   \n",
       "\n",
       "           Notas                                               PATH  Imagen  \\\n",
       "Imagen                                                                        \n",
       "1            NaN  datos/imagenes\\Sirio\\1Sirio0005 Bx3 Halfa 7 nm...       1   \n",
       "2            NaN  datos/imagenes\\Sirio\\2Sirio0007 Bx3 Halfa 7 nm...       2   \n",
       "3            NaN  datos/imagenes\\Sirio\\3Sirio0011 Bx3 Halfa 7 nm...       3   \n",
       "4            NaN  datos/imagenes\\Rigel\\4Rigel0002 Bx3 Halfa7nm I...       4   \n",
       "5          Doble  datos/imagenes\\Rigel\\5Rigel0003 sB Halfa7nm Im...       5   \n",
       "6            NaN  datos/imagenes\\Rigel\\6Rigel0008 Bx3 Halfa35nm ...       6   \n",
       "7            NaN  datos/imagenes\\Rigel\\7Rigel0009 Bx3 Halfa35nm ...       7   \n",
       "8            NaN  datos/imagenes\\Beltegeuse\\8Betelgeuse0012 Bx3 ...       8   \n",
       "9             4X  datos/imagenes\\Beltegeuse\\9Betelgeuse0014 Bx3 ...       9   \n",
       "10           NaN  datos/imagenes\\Beltegeuse\\10Betelgeuse0016 Bx3...      10   \n",
       "11           NaN  datos/imagenes\\Beltegeuse\\11Betelgeuse0017 Bx3...      11   \n",
       "12           NaN  datos/imagenes\\Sirio\\12Sirio0006 Bx3 Halfa35nm...      12   \n",
       "13           NaN  datos/imagenes\\Rigel\\13Rigel0004 Bx3 Halfa35nm...      13   \n",
       "14           NaN  datos/imagenes\\Sirio\\14Sirio0009 Bx3 Halfa35nm...      14   \n",
       "15           NaN  datos/imagenes\\Sirio\\15Sirio0010 Bx3 Halfa35nm...      15   \n",
       "16           NaN  datos/imagenes\\Sirio\\16Sirio0012 Bx3 Halfa35nm...      16   \n",
       "17           NaN  datos/imagenes\\Sirio\\17Sirio0014 Bx3 Halfa35nm...      17   \n",
       "18           NaN  datos/imagenes\\Sirio\\18Sirio0016 Bx3 Hbeta 8.5...      18   \n",
       "19           NaN  datos/imagenes\\Sirio\\19Sirio0001 Bx3 Halfa35nm...      19   \n",
       "20           NaN  datos/imagenes\\Sirio\\20Sirio0002 Bx3 Hbeta8.5n...      20   \n",
       "21           NaN  datos/imagenes\\Sirio\\21Sirio0004  Bx3 Halfa35n...      21   \n",
       "22           NaN  datos/imagenes\\Sirio\\22Sirio0006  Bx3 Halfa35n...      22   \n",
       "23           NaN  datos/imagenes\\Sirio\\23Sirio0007 Bx3 Hbeta8.5n...      23   \n",
       "24           NaN  datos/imagenes\\Gamma Leo\\24Gamma Leo0003 Bx3 H...      24   \n",
       "25      Estrella  datos/imagenes\\Gamma Leo\\25Gamma Leo0001 Bx3 s...      25   \n",
       "\n",
       "        ...    starname      DATE  DAY      HOUR V_media_antigua S_antigua  \\\n",
       "Imagen  ...                                                                  \n",
       "1       ...      Sirius  17-03-10   10  20:48:51        0.094463  0.017632   \n",
       "2       ...      Sirius  17-03-10   10  20:54:18        0.033639  0.014732   \n",
       "3       ...      Sirius  17-03-10   10  21:05:53        0.277885  0.002123   \n",
       "4       ...       Rigel  17-03-15   15  20:38:22        0.096563  0.003182   \n",
       "5       ...       Rigel  17-03-15   15  20:43:57             NaN       NaN   \n",
       "6       ...       Rigel  17-03-15   15  21:14:55        0.439454  0.007861   \n",
       "7       ...       Rigel  17-03-15   15  21:19:47        0.144100  0.008017   \n",
       "8       ...  Betelgeuse  17-03-15   15  21:41:53        0.641222  0.008581   \n",
       "9       ...  Betelgeuse  17-03-15   15  21:51:31        0.483885  0.015082   \n",
       "10      ...  Betelgeuse  17-03-15   15  22:01:11        0.322587  0.003800   \n",
       "11      ...  Betelgeuse  17-03-15   15  22:05:53        0.211979  0.018689   \n",
       "12      ...      Sirius  17-03-16   16  21:47:29        0.342583  0.000277   \n",
       "13      ...       Rigel  17-03-23   23  20:46:30        0.308249  0.003382   \n",
       "14      ...      Sirius  17-03-23   23  21:15:50        0.015108  0.001886   \n",
       "15      ...      Sirius  17-03-23   23  21:20:55        0.268869  0.013899   \n",
       "16      ...      Sirius  17-03-23   23  21:29:27        0.139991  0.021037   \n",
       "17      ...      Sirius  17-03-23   23  21:35:19        0.205609  0.051177   \n",
       "18      ...      Sirius  17-03-23   23  21:44:25        0.060419  0.002892   \n",
       "19      ...      Sirius  17-03-29   29  21:32:34        0.372131  0.017874   \n",
       "20      ...      Sirius  17-03-29   29  21:36:56        0.072809  0.004383   \n",
       "21      ...      Sirius  17-03-29   29  21:45:14        0.138379  0.003587   \n",
       "22      ...      Sirius  17-03-29   29  21:48:54        0.226591  0.002237   \n",
       "23      ...      Sirius  17-03-29   29  21:51:23        0.139635  0.002157   \n",
       "24      ...    GammaLeo  17-04-07    7  23:00:37             NaN       NaN   \n",
       "25      ...    GammaLeo  17-04-07    7  22:45:11             NaN       NaN   \n",
       "\n",
       "       S_tip_antigua   V_media         S     S_tip  \n",
       "Imagen                                              \n",
       "1           0.010180  0.094463  0.017632  0.010180  \n",
       "2           0.008506  0.033639  0.014732  0.008506  \n",
       "3           0.001226  0.277885  0.002123  0.001226  \n",
       "4           0.001837  0.096563  0.003182  0.001837  \n",
       "5                NaN       NaN       NaN       NaN  \n",
       "6           0.004539  0.439454  0.007861  0.004539  \n",
       "7           0.004628  0.144100  0.008017  0.004628  \n",
       "8           0.004954  0.641222  0.008581  0.004954  \n",
       "9           0.008708  0.483885  0.015082  0.008708  \n",
       "10          0.002194  0.322587  0.003800  0.002194  \n",
       "11          0.010790  0.211979  0.018689  0.010790  \n",
       "12          0.000160  0.342583  0.000277  0.000160  \n",
       "13          0.001953  0.308249  0.003382  0.001953  \n",
       "14          0.001089  0.015108  0.001886  0.001089  \n",
       "15          0.008025  0.268869  0.013899  0.008025  \n",
       "16          0.012146  0.139991  0.021037  0.012146  \n",
       "17          0.029547  0.205609  0.051177  0.029547  \n",
       "18          0.001669  0.060419  0.002892  0.001669  \n",
       "19          0.010320  0.372131  0.017874  0.010320  \n",
       "20          0.002530  0.072809  0.004383  0.002530  \n",
       "21          0.002071  0.138379  0.003587  0.002071  \n",
       "22          0.001291  0.226591  0.002237  0.001291  \n",
       "23          0.001246  0.139635  0.002157  0.001246  \n",
       "24               NaN       NaN       NaN       NaN  \n",
       "25               NaN       NaN       NaN       NaN  \n",
       "\n",
       "[25 rows x 25 columns]"
      ]
     },
     "execution_count": 109,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3[\"V_media\"]=df3.apply(lambda row:row[\"V_media_antigua\"] if pd.isna(row[\"V_media\"]) else row[\"V_media\"],axis=1)\n",
    "df3[\"S\"]=df3.apply(lambda row:row[\"S_antigua\"] if pd.isna(row[\"S\"]) else row[\"S\"],axis=1)\n",
    "df3[\"S_tip\"]=df3.apply(lambda row:row[\"S_tip_antigua\"] if pd.isna(row[\"S_tip\"]) else row[\"S_tip\"],axis=1)\n",
    "\n",
    "df3"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f52fc447",
   "metadata": {},
   "source": [
    "Por último calculamos el error (ojo si cambiamos las medidas habria que modificar esto, la t_student esta harcoded)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3f562596",
   "metadata": {},
   "source": [
    "![table](datos/t_student.jpeg)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "id": "a97851b0",
   "metadata": {},
   "outputs": [],
   "source": [
    "df3['E_acc']=df3[\"S_tip\"]*9.925 #* 4.3027 # "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "dac75827",
   "metadata": {},
   "source": [
    "Vemos lo que hay"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "id": "64085c8f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Objeto', 'Filtro', 'Disco', 'D (mm)', 'L (mm)', 'L1 (mm)', 'L2 (mm)',\n",
       "       'Notas', 'PATH', 'Imagen', '$\\lambda$', '$d\\lambda$', 'alphap',\n",
       "       'alphap_mas', 'filtername', 'starname', 'DATE', 'DAY', 'HOUR',\n",
       "       'V_media_antigua', 'S_antigua', 'S_tip_antigua', 'V_media', 'S',\n",
       "       'S_tip', 'E_acc'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 111,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "id": "8afb8047",
   "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>Objeto</th>\n",
       "      <th>Filtro</th>\n",
       "      <th>Disco</th>\n",
       "      <th>D (mm)</th>\n",
       "      <th>L (mm)</th>\n",
       "      <th>L1 (mm)</th>\n",
       "      <th>L2 (mm)</th>\n",
       "      <th>Notas</th>\n",
       "      <th>PATH</th>\n",
       "      <th>Imagen</th>\n",
       "      <th>...</th>\n",
       "      <th>DATE</th>\n",
       "      <th>DAY</th>\n",
       "      <th>HOUR</th>\n",
       "      <th>V_media_antigua</th>\n",
       "      <th>S_antigua</th>\n",
       "      <th>S_tip_antigua</th>\n",
       "      <th>V_media</th>\n",
       "      <th>S</th>\n",
       "      <th>S_tip</th>\n",
       "      <th>E_acc</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Imagen</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>1</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>I</td>\n",
       "      <td>22.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\1Sirio0005 Bx3 Halfa 7 nm...</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-10</td>\n",
       "      <td>10</td>\n",
       "      <td>20:48:51</td>\n",
       "      <td>0.094463</td>\n",
       "      <td>0.017632</td>\n",
       "      <td>0.010180</td>\n",
       "      <td>0.094463</td>\n",
       "      <td>0.017632</td>\n",
       "      <td>0.010180</td>\n",
       "      <td>0.101035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>H</td>\n",
       "      <td>22.0</td>\n",
       "      <td>158.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\2Sirio0007 Bx3 Halfa 7 nm...</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-10</td>\n",
       "      <td>10</td>\n",
       "      <td>20:54:18</td>\n",
       "      <td>0.033639</td>\n",
       "      <td>0.014732</td>\n",
       "      <td>0.008506</td>\n",
       "      <td>0.033639</td>\n",
       "      <td>0.014732</td>\n",
       "      <td>0.008506</td>\n",
       "      <td>0.084420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>G</td>\n",
       "      <td>61.0</td>\n",
       "      <td>178.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\3Sirio0011 Bx3 Halfa 7 nm...</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-10</td>\n",
       "      <td>10</td>\n",
       "      <td>21:05:53</td>\n",
       "      <td>0.277885</td>\n",
       "      <td>0.002123</td>\n",
       "      <td>0.001226</td>\n",
       "      <td>0.277885</td>\n",
       "      <td>0.002123</td>\n",
       "      <td>0.001226</td>\n",
       "      <td>0.012167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>E</td>\n",
       "      <td>51.0</td>\n",
       "      <td>222.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Rigel\\4Rigel0002 Bx3 Halfa7nm I...</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-15</td>\n",
       "      <td>15</td>\n",
       "      <td>20:38:22</td>\n",
       "      <td>0.096563</td>\n",
       "      <td>0.003182</td>\n",
       "      <td>0.001837</td>\n",
       "      <td>0.096563</td>\n",
       "      <td>0.003182</td>\n",
       "      <td>0.001837</td>\n",
       "      <td>0.018232</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Doble</td>\n",
       "      <td>datos/imagenes\\Rigel\\5Rigel0003 sB Halfa7nm Im...</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-15</td>\n",
       "      <td>15</td>\n",
       "      <td>20:43:57</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Objeto      Filtro Disco  D (mm)  L (mm)  L1 (mm)  L2 (mm)  Notas  \\\n",
       "Imagen                                                                     \n",
       "1       Sirio  Halfa-7 nm     I    22.0   220.0      NaN      NaN    NaN   \n",
       "2       Sirio  Halfa-7 nm     H    22.0   158.0      NaN      NaN    NaN   \n",
       "3       Sirio  Halfa-7 nm     G    61.0   178.0      NaN      NaN    NaN   \n",
       "4       Rigel  Halfa-7 nm     E    51.0   222.0      NaN      NaN    NaN   \n",
       "5       Rigel  Halfa-7 nm   NaN     NaN     NaN      NaN      NaN  Doble   \n",
       "\n",
       "                                                     PATH  Imagen  ...  \\\n",
       "Imagen                                                             ...   \n",
       "1       datos/imagenes\\Sirio\\1Sirio0005 Bx3 Halfa 7 nm...       1  ...   \n",
       "2       datos/imagenes\\Sirio\\2Sirio0007 Bx3 Halfa 7 nm...       2  ...   \n",
       "3       datos/imagenes\\Sirio\\3Sirio0011 Bx3 Halfa 7 nm...       3  ...   \n",
       "4       datos/imagenes\\Rigel\\4Rigel0002 Bx3 Halfa7nm I...       4  ...   \n",
       "5       datos/imagenes\\Rigel\\5Rigel0003 sB Halfa7nm Im...       5  ...   \n",
       "\n",
       "            DATE  DAY      HOUR  V_media_antigua S_antigua S_tip_antigua  \\\n",
       "Imagen                                                                     \n",
       "1       17-03-10   10  20:48:51         0.094463  0.017632      0.010180   \n",
       "2       17-03-10   10  20:54:18         0.033639  0.014732      0.008506   \n",
       "3       17-03-10   10  21:05:53         0.277885  0.002123      0.001226   \n",
       "4       17-03-15   15  20:38:22         0.096563  0.003182      0.001837   \n",
       "5       17-03-15   15  20:43:57              NaN       NaN           NaN   \n",
       "\n",
       "         V_media         S     S_tip     E_acc  \n",
       "Imagen                                          \n",
       "1       0.094463  0.017632  0.010180  0.101035  \n",
       "2       0.033639  0.014732  0.008506  0.084420  \n",
       "3       0.277885  0.002123  0.001226  0.012167  \n",
       "4       0.096563  0.003182  0.001837  0.018232  \n",
       "5            NaN       NaN       NaN       NaN  \n",
       "\n",
       "[5 rows x 26 columns]"
      ]
     },
     "execution_count": 112,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "id": "c44add2a",
   "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>Imagen</th>\n",
       "      <th>Objeto</th>\n",
       "      <th>DATE</th>\n",
       "      <th>DAY</th>\n",
       "      <th>HOUR</th>\n",
       "      <th>V_media</th>\n",
       "      <th>E_acc</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Imagen</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>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Sirio</td>\n",
       "      <td>17-03-10</td>\n",
       "      <td>10</td>\n",
       "      <td>20:48:51</td>\n",
       "      <td>0.094463</td>\n",
       "      <td>0.101035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Sirio</td>\n",
       "      <td>17-03-10</td>\n",
       "      <td>10</td>\n",
       "      <td>20:54:18</td>\n",
       "      <td>0.033639</td>\n",
       "      <td>0.084420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Sirio</td>\n",
       "      <td>17-03-10</td>\n",
       "      <td>10</td>\n",
       "      <td>21:05:53</td>\n",
       "      <td>0.277885</td>\n",
       "      <td>0.012167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Rigel</td>\n",
       "      <td>17-03-15</td>\n",
       "      <td>15</td>\n",
       "      <td>20:38:22</td>\n",
       "      <td>0.096563</td>\n",
       "      <td>0.018232</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>Rigel</td>\n",
       "      <td>17-03-15</td>\n",
       "      <td>15</td>\n",
       "      <td>20:43:57</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>Rigel</td>\n",
       "      <td>17-03-15</td>\n",
       "      <td>15</td>\n",
       "      <td>21:14:55</td>\n",
       "      <td>0.439454</td>\n",
       "      <td>0.045045</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Imagen Objeto      DATE  DAY      HOUR   V_media     E_acc\n",
       "Imagen                                                            \n",
       "1            1  Sirio  17-03-10   10  20:48:51  0.094463  0.101035\n",
       "2            2  Sirio  17-03-10   10  20:54:18  0.033639  0.084420\n",
       "3            3  Sirio  17-03-10   10  21:05:53  0.277885  0.012167\n",
       "4            4  Rigel  17-03-15   15  20:38:22  0.096563  0.018232\n",
       "5            5  Rigel  17-03-15   15  20:43:57       NaN       NaN\n",
       "6            6  Rigel  17-03-15   15  21:14:55  0.439454  0.045045"
      ]
     },
     "execution_count": 113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3[['Imagen','Objeto','DATE','DAY','HOUR','V_media','E_acc']].head(6)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "id": "0bd52ae5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Objeto              object\n",
       "Filtro              object\n",
       "Disco               object\n",
       "D (mm)             float64\n",
       "L (mm)             float64\n",
       "L1 (mm)            float64\n",
       "L2 (mm)            float64\n",
       "Notas               object\n",
       "PATH                object\n",
       "Imagen               int64\n",
       "$\\lambda$          float64\n",
       "$d\\lambda$         float64\n",
       "alphap             float64\n",
       "alphap_mas         float64\n",
       "filtername          object\n",
       "starname            object\n",
       "DATE                object\n",
       "DAY                  int64\n",
       "HOUR                object\n",
       "V_media_antigua    float64\n",
       "S_antigua          float64\n",
       "S_tip_antigua      float64\n",
       "V_media            float64\n",
       "S                  float64\n",
       "S_tip              float64\n",
       "E_acc              float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 114,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "id": "23ec91f6",
   "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>Objeto</th>\n",
       "      <th>Filtro</th>\n",
       "      <th>Disco</th>\n",
       "      <th>D (mm)</th>\n",
       "      <th>L (mm)</th>\n",
       "      <th>L1 (mm)</th>\n",
       "      <th>L2 (mm)</th>\n",
       "      <th>Notas</th>\n",
       "      <th>PATH</th>\n",
       "      <th>Imagen</th>\n",
       "      <th>...</th>\n",
       "      <th>DATE</th>\n",
       "      <th>DAY</th>\n",
       "      <th>HOUR</th>\n",
       "      <th>V_media_antigua</th>\n",
       "      <th>S_antigua</th>\n",
       "      <th>S_tip_antigua</th>\n",
       "      <th>V_media</th>\n",
       "      <th>S</th>\n",
       "      <th>S_tip</th>\n",
       "      <th>E_acc</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Imagen</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>1</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>I</td>\n",
       "      <td>22.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\1Sirio0005 Bx3 Halfa 7 nm...</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-10</td>\n",
       "      <td>10</td>\n",
       "      <td>20:48:51</td>\n",
       "      <td>0.094463</td>\n",
       "      <td>0.017632</td>\n",
       "      <td>0.010180</td>\n",
       "      <td>0.094463</td>\n",
       "      <td>0.017632</td>\n",
       "      <td>0.010180</td>\n",
       "      <td>0.101035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>H</td>\n",
       "      <td>22.0</td>\n",
       "      <td>158.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\2Sirio0007 Bx3 Halfa 7 nm...</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-10</td>\n",
       "      <td>10</td>\n",
       "      <td>20:54:18</td>\n",
       "      <td>0.033639</td>\n",
       "      <td>0.014732</td>\n",
       "      <td>0.008506</td>\n",
       "      <td>0.033639</td>\n",
       "      <td>0.014732</td>\n",
       "      <td>0.008506</td>\n",
       "      <td>0.084420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>G</td>\n",
       "      <td>61.0</td>\n",
       "      <td>178.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\3Sirio0011 Bx3 Halfa 7 nm...</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-10</td>\n",
       "      <td>10</td>\n",
       "      <td>21:05:53</td>\n",
       "      <td>0.277885</td>\n",
       "      <td>0.002123</td>\n",
       "      <td>0.001226</td>\n",
       "      <td>0.277885</td>\n",
       "      <td>0.002123</td>\n",
       "      <td>0.001226</td>\n",
       "      <td>0.012167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>E</td>\n",
       "      <td>51.0</td>\n",
       "      <td>222.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Rigel\\4Rigel0002 Bx3 Halfa7nm I...</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-15</td>\n",
       "      <td>15</td>\n",
       "      <td>20:38:22</td>\n",
       "      <td>0.096563</td>\n",
       "      <td>0.003182</td>\n",
       "      <td>0.001837</td>\n",
       "      <td>0.096563</td>\n",
       "      <td>0.003182</td>\n",
       "      <td>0.001837</td>\n",
       "      <td>0.018232</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Doble</td>\n",
       "      <td>datos/imagenes\\Rigel\\5Rigel0003 sB Halfa7nm Im...</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-15</td>\n",
       "      <td>15</td>\n",
       "      <td>20:43:57</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>F</td>\n",
       "      <td>51.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Rigel\\6Rigel0008 Bx3 Halfa35nm ...</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-15</td>\n",
       "      <td>15</td>\n",
       "      <td>21:14:55</td>\n",
       "      <td>0.439454</td>\n",
       "      <td>0.007861</td>\n",
       "      <td>0.004539</td>\n",
       "      <td>0.439454</td>\n",
       "      <td>0.007861</td>\n",
       "      <td>0.004539</td>\n",
       "      <td>0.045045</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>E</td>\n",
       "      <td>51.0</td>\n",
       "      <td>222.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Rigel\\7Rigel0009 Bx3 Halfa35nm ...</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-15</td>\n",
       "      <td>15</td>\n",
       "      <td>21:19:47</td>\n",
       "      <td>0.144100</td>\n",
       "      <td>0.008017</td>\n",
       "      <td>0.004628</td>\n",
       "      <td>0.144100</td>\n",
       "      <td>0.008017</td>\n",
       "      <td>0.004628</td>\n",
       "      <td>0.045938</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Betelgeuse</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>F</td>\n",
       "      <td>51.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Beltegeuse\\8Betelgeuse0012 Bx3 ...</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-15</td>\n",
       "      <td>15</td>\n",
       "      <td>21:41:53</td>\n",
       "      <td>0.641222</td>\n",
       "      <td>0.008581</td>\n",
       "      <td>0.004954</td>\n",
       "      <td>0.641222</td>\n",
       "      <td>0.008581</td>\n",
       "      <td>0.004954</td>\n",
       "      <td>0.049168</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Betelgeuse</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B/L+C</td>\n",
       "      <td>30.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>133.0</td>\n",
       "      <td>238.0</td>\n",
       "      <td>4X</td>\n",
       "      <td>datos/imagenes\\Beltegeuse\\9Betelgeuse0014 Bx3 ...</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-15</td>\n",
       "      <td>15</td>\n",
       "      <td>21:51:31</td>\n",
       "      <td>0.483885</td>\n",
       "      <td>0.015082</td>\n",
       "      <td>0.008708</td>\n",
       "      <td>0.483885</td>\n",
       "      <td>0.015082</td>\n",
       "      <td>0.008708</td>\n",
       "      <td>0.086422</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Betelgeuse</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30.0</td>\n",
       "      <td>238.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Beltegeuse\\10Betelgeuse0016 Bx3...</td>\n",
       "      <td>10</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-15</td>\n",
       "      <td>15</td>\n",
       "      <td>22:01:11</td>\n",
       "      <td>0.322587</td>\n",
       "      <td>0.003800</td>\n",
       "      <td>0.002194</td>\n",
       "      <td>0.322587</td>\n",
       "      <td>0.003800</td>\n",
       "      <td>0.002194</td>\n",
       "      <td>0.021777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Betelgeuse</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Beltegeuse\\11Betelgeuse0017 Bx3...</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-15</td>\n",
       "      <td>15</td>\n",
       "      <td>22:05:53</td>\n",
       "      <td>0.211979</td>\n",
       "      <td>0.018689</td>\n",
       "      <td>0.010790</td>\n",
       "      <td>0.211979</td>\n",
       "      <td>0.018689</td>\n",
       "      <td>0.010790</td>\n",
       "      <td>0.107091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\12Sirio0006 Bx3 Halfa35nm...</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-16</td>\n",
       "      <td>16</td>\n",
       "      <td>21:47:29</td>\n",
       "      <td>0.342583</td>\n",
       "      <td>0.000277</td>\n",
       "      <td>0.000160</td>\n",
       "      <td>0.342583</td>\n",
       "      <td>0.000277</td>\n",
       "      <td>0.000160</td>\n",
       "      <td>0.001589</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Rigel</td>\n",
       "      <td>Halfa-7 nm</td>\n",
       "      <td>F</td>\n",
       "      <td>51.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Rigel\\13Rigel0004 Bx3 Halfa35nm...</td>\n",
       "      <td>13</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-23</td>\n",
       "      <td>23</td>\n",
       "      <td>20:46:30</td>\n",
       "      <td>0.308249</td>\n",
       "      <td>0.003382</td>\n",
       "      <td>0.001953</td>\n",
       "      <td>0.308249</td>\n",
       "      <td>0.003382</td>\n",
       "      <td>0.001953</td>\n",
       "      <td>0.019379</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30.0</td>\n",
       "      <td>238.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\14Sirio0009 Bx3 Halfa35nm...</td>\n",
       "      <td>14</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-23</td>\n",
       "      <td>23</td>\n",
       "      <td>21:15:50</td>\n",
       "      <td>0.015108</td>\n",
       "      <td>0.001886</td>\n",
       "      <td>0.001089</td>\n",
       "      <td>0.015108</td>\n",
       "      <td>0.001886</td>\n",
       "      <td>0.001089</td>\n",
       "      <td>0.010804</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\15Sirio0010 Bx3 Halfa35nm...</td>\n",
       "      <td>15</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-23</td>\n",
       "      <td>23</td>\n",
       "      <td>21:20:55</td>\n",
       "      <td>0.268869</td>\n",
       "      <td>0.013899</td>\n",
       "      <td>0.008025</td>\n",
       "      <td>0.268869</td>\n",
       "      <td>0.013899</td>\n",
       "      <td>0.008025</td>\n",
       "      <td>0.079645</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>E</td>\n",
       "      <td>50.0</td>\n",
       "      <td>222.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\16Sirio0012 Bx3 Halfa35nm...</td>\n",
       "      <td>16</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-23</td>\n",
       "      <td>23</td>\n",
       "      <td>21:29:27</td>\n",
       "      <td>0.139991</td>\n",
       "      <td>0.021037</td>\n",
       "      <td>0.012146</td>\n",
       "      <td>0.139991</td>\n",
       "      <td>0.021037</td>\n",
       "      <td>0.012146</td>\n",
       "      <td>0.120546</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>C</td>\n",
       "      <td>65.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\17Sirio0014 Bx3 Halfa35nm...</td>\n",
       "      <td>17</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-23</td>\n",
       "      <td>23</td>\n",
       "      <td>21:35:19</td>\n",
       "      <td>0.205609</td>\n",
       "      <td>0.051177</td>\n",
       "      <td>0.029547</td>\n",
       "      <td>0.205609</td>\n",
       "      <td>0.051177</td>\n",
       "      <td>0.029547</td>\n",
       "      <td>0.293257</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Hbeta-8.5nm</td>\n",
       "      <td>B</td>\n",
       "      <td>30.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\18Sirio0016 Bx3 Hbeta 8.5...</td>\n",
       "      <td>18</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-23</td>\n",
       "      <td>23</td>\n",
       "      <td>21:44:25</td>\n",
       "      <td>0.060419</td>\n",
       "      <td>0.002892</td>\n",
       "      <td>0.001669</td>\n",
       "      <td>0.060419</td>\n",
       "      <td>0.002892</td>\n",
       "      <td>0.001669</td>\n",
       "      <td>0.016569</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>C</td>\n",
       "      <td>66.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\19Sirio0001 Bx3 Halfa35nm...</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-29</td>\n",
       "      <td>29</td>\n",
       "      <td>21:32:34</td>\n",
       "      <td>0.372131</td>\n",
       "      <td>0.017874</td>\n",
       "      <td>0.010320</td>\n",
       "      <td>0.372131</td>\n",
       "      <td>0.017874</td>\n",
       "      <td>0.010320</td>\n",
       "      <td>0.102422</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Hbeta-8.5nm</td>\n",
       "      <td>B</td>\n",
       "      <td>66.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\20Sirio0002 Bx3 Hbeta8.5n...</td>\n",
       "      <td>20</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-29</td>\n",
       "      <td>29</td>\n",
       "      <td>21:36:56</td>\n",
       "      <td>0.072809</td>\n",
       "      <td>0.004383</td>\n",
       "      <td>0.002530</td>\n",
       "      <td>0.072809</td>\n",
       "      <td>0.004383</td>\n",
       "      <td>0.002530</td>\n",
       "      <td>0.025113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>D</td>\n",
       "      <td>66.0</td>\n",
       "      <td>205.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\21Sirio0004  Bx3 Halfa35n...</td>\n",
       "      <td>21</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-29</td>\n",
       "      <td>29</td>\n",
       "      <td>21:45:14</td>\n",
       "      <td>0.138379</td>\n",
       "      <td>0.003587</td>\n",
       "      <td>0.002071</td>\n",
       "      <td>0.138379</td>\n",
       "      <td>0.003587</td>\n",
       "      <td>0.002071</td>\n",
       "      <td>0.020552</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>A</td>\n",
       "      <td>90.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\22Sirio0006  Bx3 Halfa35n...</td>\n",
       "      <td>22</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-29</td>\n",
       "      <td>29</td>\n",
       "      <td>21:48:54</td>\n",
       "      <td>0.226591</td>\n",
       "      <td>0.002237</td>\n",
       "      <td>0.001291</td>\n",
       "      <td>0.226591</td>\n",
       "      <td>0.002237</td>\n",
       "      <td>0.001291</td>\n",
       "      <td>0.012818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Sirio</td>\n",
       "      <td>Hbeta-8.5nm</td>\n",
       "      <td>A</td>\n",
       "      <td>90.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Sirio\\23Sirio0007 Bx3 Hbeta8.5n...</td>\n",
       "      <td>23</td>\n",
       "      <td>...</td>\n",
       "      <td>17-03-29</td>\n",
       "      <td>29</td>\n",
       "      <td>21:51:23</td>\n",
       "      <td>0.139635</td>\n",
       "      <td>0.002157</td>\n",
       "      <td>0.001246</td>\n",
       "      <td>0.139635</td>\n",
       "      <td>0.002157</td>\n",
       "      <td>0.001246</td>\n",
       "      <td>0.012362</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>GammaLeo</td>\n",
       "      <td>Halfa-35 nm</td>\n",
       "      <td>F</td>\n",
       "      <td>51.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>datos/imagenes\\Gamma Leo\\24Gamma Leo0003 Bx3 H...</td>\n",
       "      <td>24</td>\n",
       "      <td>...</td>\n",
       "      <td>17-04-07</td>\n",
       "      <td>7</td>\n",
       "      <td>23:00:37</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>GammaLeo</td>\n",
       "      <td>sF</td>\n",
       "      <td>-</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Estrella</td>\n",
       "      <td>datos/imagenes\\Gamma Leo\\25Gamma Leo0001 Bx3 s...</td>\n",
       "      <td>25</td>\n",
       "      <td>...</td>\n",
       "      <td>17-04-07</td>\n",
       "      <td>7</td>\n",
       "      <td>22:45:11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Objeto       Filtro  Disco  D (mm)  L (mm)  L1 (mm)  L2 (mm)  \\\n",
       "Imagen                                                                     \n",
       "1            Sirio   Halfa-7 nm      I    22.0   220.0      NaN      NaN   \n",
       "2            Sirio   Halfa-7 nm      H    22.0   158.0      NaN      NaN   \n",
       "3            Sirio   Halfa-7 nm      G    61.0   178.0      NaN      NaN   \n",
       "4            Rigel   Halfa-7 nm      E    51.0   222.0      NaN      NaN   \n",
       "5            Rigel   Halfa-7 nm    NaN     NaN     NaN      NaN      NaN   \n",
       "6            Rigel  Halfa-35 nm      F    51.0   147.0      NaN      NaN   \n",
       "7            Rigel  Halfa-35 nm      E    51.0   222.0      NaN      NaN   \n",
       "8       Betelgeuse  Halfa-35 nm      F    51.0   147.0      NaN      NaN   \n",
       "9       Betelgeuse  Halfa-35 nm  B/L+C    30.0     NaN    133.0    238.0   \n",
       "10      Betelgeuse  Halfa-35 nm      B    30.0   238.0      NaN      NaN   \n",
       "11      Betelgeuse  Halfa-35 nm      B    30.0   133.0      NaN      NaN   \n",
       "12           Sirio  Halfa-35 nm      B    30.0   133.0      NaN      NaN   \n",
       "13           Rigel   Halfa-7 nm      F    51.0   147.0      NaN      NaN   \n",
       "14           Sirio  Halfa-35 nm      B    30.0   238.0      NaN      NaN   \n",
       "15           Sirio  Halfa-35 nm      B    30.0   133.0      NaN      NaN   \n",
       "16           Sirio  Halfa-35 nm      E    50.0   222.0      NaN      NaN   \n",
       "17           Sirio  Halfa-35 nm      C    65.0   162.0      NaN      NaN   \n",
       "18           Sirio  Hbeta-8.5nm      B    30.0   133.0      NaN      NaN   \n",
       "19           Sirio  Halfa-35 nm      C    66.0   162.0      NaN      NaN   \n",
       "20           Sirio  Hbeta-8.5nm      B    66.0   162.0      NaN      NaN   \n",
       "21           Sirio  Halfa-35 nm      D    66.0   205.0      NaN      NaN   \n",
       "22           Sirio  Halfa-35 nm      A    90.0   187.0      NaN      NaN   \n",
       "23           Sirio  Hbeta-8.5nm      A    90.0   187.0      NaN      NaN   \n",
       "24        GammaLeo  Halfa-35 nm      F    51.0   147.0      NaN      NaN   \n",
       "25        GammaLeo           sF      -     NaN     NaN      NaN      NaN   \n",
       "\n",
       "           Notas                                               PATH  Imagen  \\\n",
       "Imagen                                                                        \n",
       "1            NaN  datos/imagenes\\Sirio\\1Sirio0005 Bx3 Halfa 7 nm...       1   \n",
       "2            NaN  datos/imagenes\\Sirio\\2Sirio0007 Bx3 Halfa 7 nm...       2   \n",
       "3            NaN  datos/imagenes\\Sirio\\3Sirio0011 Bx3 Halfa 7 nm...       3   \n",
       "4            NaN  datos/imagenes\\Rigel\\4Rigel0002 Bx3 Halfa7nm I...       4   \n",
       "5          Doble  datos/imagenes\\Rigel\\5Rigel0003 sB Halfa7nm Im...       5   \n",
       "6            NaN  datos/imagenes\\Rigel\\6Rigel0008 Bx3 Halfa35nm ...       6   \n",
       "7            NaN  datos/imagenes\\Rigel\\7Rigel0009 Bx3 Halfa35nm ...       7   \n",
       "8            NaN  datos/imagenes\\Beltegeuse\\8Betelgeuse0012 Bx3 ...       8   \n",
       "9             4X  datos/imagenes\\Beltegeuse\\9Betelgeuse0014 Bx3 ...       9   \n",
       "10           NaN  datos/imagenes\\Beltegeuse\\10Betelgeuse0016 Bx3...      10   \n",
       "11           NaN  datos/imagenes\\Beltegeuse\\11Betelgeuse0017 Bx3...      11   \n",
       "12           NaN  datos/imagenes\\Sirio\\12Sirio0006 Bx3 Halfa35nm...      12   \n",
       "13           NaN  datos/imagenes\\Rigel\\13Rigel0004 Bx3 Halfa35nm...      13   \n",
       "14           NaN  datos/imagenes\\Sirio\\14Sirio0009 Bx3 Halfa35nm...      14   \n",
       "15           NaN  datos/imagenes\\Sirio\\15Sirio0010 Bx3 Halfa35nm...      15   \n",
       "16           NaN  datos/imagenes\\Sirio\\16Sirio0012 Bx3 Halfa35nm...      16   \n",
       "17           NaN  datos/imagenes\\Sirio\\17Sirio0014 Bx3 Halfa35nm...      17   \n",
       "18           NaN  datos/imagenes\\Sirio\\18Sirio0016 Bx3 Hbeta 8.5...      18   \n",
       "19           NaN  datos/imagenes\\Sirio\\19Sirio0001 Bx3 Halfa35nm...      19   \n",
       "20           NaN  datos/imagenes\\Sirio\\20Sirio0002 Bx3 Hbeta8.5n...      20   \n",
       "21           NaN  datos/imagenes\\Sirio\\21Sirio0004  Bx3 Halfa35n...      21   \n",
       "22           NaN  datos/imagenes\\Sirio\\22Sirio0006  Bx3 Halfa35n...      22   \n",
       "23           NaN  datos/imagenes\\Sirio\\23Sirio0007 Bx3 Hbeta8.5n...      23   \n",
       "24           NaN  datos/imagenes\\Gamma Leo\\24Gamma Leo0003 Bx3 H...      24   \n",
       "25      Estrella  datos/imagenes\\Gamma Leo\\25Gamma Leo0001 Bx3 s...      25   \n",
       "\n",
       "        ...      DATE  DAY      HOUR  V_media_antigua S_antigua S_tip_antigua  \\\n",
       "Imagen  ...                                                                     \n",
       "1       ...  17-03-10   10  20:48:51         0.094463  0.017632      0.010180   \n",
       "2       ...  17-03-10   10  20:54:18         0.033639  0.014732      0.008506   \n",
       "3       ...  17-03-10   10  21:05:53         0.277885  0.002123      0.001226   \n",
       "4       ...  17-03-15   15  20:38:22         0.096563  0.003182      0.001837   \n",
       "5       ...  17-03-15   15  20:43:57              NaN       NaN           NaN   \n",
       "6       ...  17-03-15   15  21:14:55         0.439454  0.007861      0.004539   \n",
       "7       ...  17-03-15   15  21:19:47         0.144100  0.008017      0.004628   \n",
       "8       ...  17-03-15   15  21:41:53         0.641222  0.008581      0.004954   \n",
       "9       ...  17-03-15   15  21:51:31         0.483885  0.015082      0.008708   \n",
       "10      ...  17-03-15   15  22:01:11         0.322587  0.003800      0.002194   \n",
       "11      ...  17-03-15   15  22:05:53         0.211979  0.018689      0.010790   \n",
       "12      ...  17-03-16   16  21:47:29         0.342583  0.000277      0.000160   \n",
       "13      ...  17-03-23   23  20:46:30         0.308249  0.003382      0.001953   \n",
       "14      ...  17-03-23   23  21:15:50         0.015108  0.001886      0.001089   \n",
       "15      ...  17-03-23   23  21:20:55         0.268869  0.013899      0.008025   \n",
       "16      ...  17-03-23   23  21:29:27         0.139991  0.021037      0.012146   \n",
       "17      ...  17-03-23   23  21:35:19         0.205609  0.051177      0.029547   \n",
       "18      ...  17-03-23   23  21:44:25         0.060419  0.002892      0.001669   \n",
       "19      ...  17-03-29   29  21:32:34         0.372131  0.017874      0.010320   \n",
       "20      ...  17-03-29   29  21:36:56         0.072809  0.004383      0.002530   \n",
       "21      ...  17-03-29   29  21:45:14         0.138379  0.003587      0.002071   \n",
       "22      ...  17-03-29   29  21:48:54         0.226591  0.002237      0.001291   \n",
       "23      ...  17-03-29   29  21:51:23         0.139635  0.002157      0.001246   \n",
       "24      ...  17-04-07    7  23:00:37              NaN       NaN           NaN   \n",
       "25      ...  17-04-07    7  22:45:11              NaN       NaN           NaN   \n",
       "\n",
       "         V_media         S     S_tip     E_acc  \n",
       "Imagen                                          \n",
       "1       0.094463  0.017632  0.010180  0.101035  \n",
       "2       0.033639  0.014732  0.008506  0.084420  \n",
       "3       0.277885  0.002123  0.001226  0.012167  \n",
       "4       0.096563  0.003182  0.001837  0.018232  \n",
       "5            NaN       NaN       NaN       NaN  \n",
       "6       0.439454  0.007861  0.004539  0.045045  \n",
       "7       0.144100  0.008017  0.004628  0.045938  \n",
       "8       0.641222  0.008581  0.004954  0.049168  \n",
       "9       0.483885  0.015082  0.008708  0.086422  \n",
       "10      0.322587  0.003800  0.002194  0.021777  \n",
       "11      0.211979  0.018689  0.010790  0.107091  \n",
       "12      0.342583  0.000277  0.000160  0.001589  \n",
       "13      0.308249  0.003382  0.001953  0.019379  \n",
       "14      0.015108  0.001886  0.001089  0.010804  \n",
       "15      0.268869  0.013899  0.008025  0.079645  \n",
       "16      0.139991  0.021037  0.012146  0.120546  \n",
       "17      0.205609  0.051177  0.029547  0.293257  \n",
       "18      0.060419  0.002892  0.001669  0.016569  \n",
       "19      0.372131  0.017874  0.010320  0.102422  \n",
       "20      0.072809  0.004383  0.002530  0.025113  \n",
       "21      0.138379  0.003587  0.002071  0.020552  \n",
       "22      0.226591  0.002237  0.001291  0.012818  \n",
       "23      0.139635  0.002157  0.001246  0.012362  \n",
       "24           NaN       NaN       NaN       NaN  \n",
       "25           NaN       NaN       NaN       NaN  \n",
       "\n",
       "[25 rows x 26 columns]"
      ]
     },
     "execution_count": 115,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "id": "2d10884f",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\ivian\\AppData\\Local\\Temp\\ipykernel_22484\\850098308.py:1: PerformanceWarning: \n",
      "your performance may suffer as PyTables will pickle object types that it cannot\n",
      "map directly to c-types [inferred_type->mixed,key->block2_values] [items->Index(['Objeto', 'Filtro', 'Disco', 'Notas', 'PATH', 'filtername', 'starname',\n",
      "       'DATE', 'HOUR'],\n",
      "      dtype='object')]\n",
      "\n",
      "  df3.to_hdf('intermedio/tabla.h5',key='df', mode='w')\n"
     ]
    }
   ],
   "source": [
    "df3.to_hdf('intermedio/tabla.h5',key='df', mode='w')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "id": "2102860d",
   "metadata": {},
   "outputs": [],
   "source": [
    "if not os.path.isdir(\"productos/\"):\n",
    "    os.makedirs(\"productos/\")\n",
    "df3.to_excel(\"productos/tabla_excel.xlsx\",engine=\"openpyxl\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "87473035",
   "metadata": {},
   "source": []
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "7288f5eed9f0569b2edb372878a9e89d03676e3e8c663c8588401b9f637de2da"
  },
  "kernelspec": {
   "display_name": "Python 3.10.4 ('interf2')",
   "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.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}