predict.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 136,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('idsc_train.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "metadata": {},
   "outputs": [],
   "source": [
    "colunas = ['dt_dep', 'dt_arr','hora_ref', 'hora_esperas', 'hora_metar', 'hora_metaf', 'hora_tcp']\n",
    "\n",
    "# 1. Converter as colunas para datetime de uma só vez\n",
    "df[colunas] = df[colunas].apply(pd.to_datetime)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 139,
   "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>0</th>\n",
       "      <th>1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>flightid</th>\n",
       "      <td>2127312fea57d093815e49b5aefee46d</td>\n",
       "      <td>e20845be25ed24b87131066d865cd9bc</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>origem</th>\n",
       "      <td>SBBR</td>\n",
       "      <td>SBFL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>destino</th>\n",
       "      <td>SBGL</td>\n",
       "      <td>SBSP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dt_dep</th>\n",
       "      <td>2022-06-01 08:08:46</td>\n",
       "      <td>2022-06-01 09:12:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dt_arr</th>\n",
       "      <td>2022-06-01 09:27:43</td>\n",
       "      <td>2022-06-01 10:01:07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hora_ref</th>\n",
       "      <td>2022-06-01 08:00:00</td>\n",
       "      <td>2022-06-01 09:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>esperas</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hora_esperas</th>\n",
       "      <td>2022-06-01 07:00:00</td>\n",
       "      <td>2022-06-01 08:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_esperas</th>\n",
       "      <td>SBGL</td>\n",
       "      <td>SBSP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hora_metaf</th>\n",
       "      <td>2022-06-01 09:00:00</td>\n",
       "      <td>2022-06-01 10:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>metaf</th>\n",
       "      <td>METAF SBGL 011200Z  15002KT 2000     BR BKN033...</td>\n",
       "      <td>METAF SBSP 011300Z 07004KT 4000     BR OVC033 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_metaf</th>\n",
       "      <td>SBGL</td>\n",
       "      <td>SBSP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hora_metar</th>\n",
       "      <td>2022-06-01 08:00:00</td>\n",
       "      <td>2022-06-01 09:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>metar</th>\n",
       "      <td>METAR SBGL 011100Z 10003KT 070V130 7000 FEW009...</td>\n",
       "      <td>METAR SBSP 011200Z 08003KT 030V130 9999 -RA SC...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_metar</th>\n",
       "      <td>SBGL</td>\n",
       "      <td>SBSP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hora_tcp</th>\n",
       "      <td>2022-06-01 09:00:00</td>\n",
       "      <td>2022-06-01 10:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>troca</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_tcp</th>\n",
       "      <td>SBGL</td>\n",
       "      <td>SBSP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>duracao</th>\n",
       "      <td>4737.0</td>\n",
       "      <td>2918.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                              0  \\\n",
       "flightid                       2127312fea57d093815e49b5aefee46d   \n",
       "origem                                                     SBBR   \n",
       "destino                                                    SBGL   \n",
       "dt_dep                                      2022-06-01 08:08:46   \n",
       "dt_arr                                      2022-06-01 09:27:43   \n",
       "hora_ref                                    2022-06-01 08:00:00   \n",
       "esperas                                                       0   \n",
       "hora_esperas                                2022-06-01 07:00:00   \n",
       "aero_esperas                                               SBGL   \n",
       "hora_metaf                                  2022-06-01 09:00:00   \n",
       "metaf         METAF SBGL 011200Z  15002KT 2000     BR BKN033...   \n",
       "aero_metaf                                                 SBGL   \n",
       "hora_metar                                  2022-06-01 08:00:00   \n",
       "metar         METAR SBGL 011100Z 10003KT 070V130 7000 FEW009...   \n",
       "aero_metar                                                 SBGL   \n",
       "hora_tcp                                    2022-06-01 09:00:00   \n",
       "troca                                                         0   \n",
       "aero_tcp                                                   SBGL   \n",
       "duracao                                                  4737.0   \n",
       "\n",
       "                                                              1  \n",
       "flightid                       e20845be25ed24b87131066d865cd9bc  \n",
       "origem                                                     SBFL  \n",
       "destino                                                    SBSP  \n",
       "dt_dep                                      2022-06-01 09:12:29  \n",
       "dt_arr                                      2022-06-01 10:01:07  \n",
       "hora_ref                                    2022-06-01 09:00:00  \n",
       "esperas                                                       0  \n",
       "hora_esperas                                2022-06-01 08:00:00  \n",
       "aero_esperas                                               SBSP  \n",
       "hora_metaf                                  2022-06-01 10:00:00  \n",
       "metaf         METAF SBSP 011300Z 07004KT 4000     BR OVC033 ...  \n",
       "aero_metaf                                                 SBSP  \n",
       "hora_metar                                  2022-06-01 09:00:00  \n",
       "metar         METAR SBSP 011200Z 08003KT 030V130 9999 -RA SC...  \n",
       "aero_metar                                                 SBSP  \n",
       "hora_tcp                                    2022-06-01 10:00:00  \n",
       "troca                                                         0  \n",
       "aero_tcp                                                   SBSP  \n",
       "duracao                                                  2918.0  "
      ]
     },
     "execution_count": 139,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['duracao'] = (df['dt_arr']-df['dt_dep']).dt.total_seconds()\n",
    "df.head(2).T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 140,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.drop(colunas, axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 141,
   "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>0</th>\n",
       "      <th>1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>flightid</th>\n",
       "      <td>2127312fea57d093815e49b5aefee46d</td>\n",
       "      <td>e20845be25ed24b87131066d865cd9bc</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>origem</th>\n",
       "      <td>SBBR</td>\n",
       "      <td>SBFL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>destino</th>\n",
       "      <td>SBGL</td>\n",
       "      <td>SBSP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>esperas</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_esperas</th>\n",
       "      <td>SBGL</td>\n",
       "      <td>SBSP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>metaf</th>\n",
       "      <td>METAF SBGL 011200Z  15002KT 2000     BR BKN033...</td>\n",
       "      <td>METAF SBSP 011300Z 07004KT 4000     BR OVC033 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_metaf</th>\n",
       "      <td>SBGL</td>\n",
       "      <td>SBSP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>metar</th>\n",
       "      <td>METAR SBGL 011100Z 10003KT 070V130 7000 FEW009...</td>\n",
       "      <td>METAR SBSP 011200Z 08003KT 030V130 9999 -RA SC...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_metar</th>\n",
       "      <td>SBGL</td>\n",
       "      <td>SBSP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>troca</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_tcp</th>\n",
       "      <td>SBGL</td>\n",
       "      <td>SBSP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>duracao</th>\n",
       "      <td>4737.0</td>\n",
       "      <td>2918.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                              0  \\\n",
       "flightid                       2127312fea57d093815e49b5aefee46d   \n",
       "origem                                                     SBBR   \n",
       "destino                                                    SBGL   \n",
       "esperas                                                       0   \n",
       "aero_esperas                                               SBGL   \n",
       "metaf         METAF SBGL 011200Z  15002KT 2000     BR BKN033...   \n",
       "aero_metaf                                                 SBGL   \n",
       "metar         METAR SBGL 011100Z 10003KT 070V130 7000 FEW009...   \n",
       "aero_metar                                                 SBGL   \n",
       "troca                                                         0   \n",
       "aero_tcp                                                   SBGL   \n",
       "duracao                                                  4737.0   \n",
       "\n",
       "                                                              1  \n",
       "flightid                       e20845be25ed24b87131066d865cd9bc  \n",
       "origem                                                     SBFL  \n",
       "destino                                                    SBSP  \n",
       "esperas                                                       0  \n",
       "aero_esperas                                               SBSP  \n",
       "metaf         METAF SBSP 011300Z 07004KT 4000     BR OVC033 ...  \n",
       "aero_metaf                                                 SBSP  \n",
       "metar         METAR SBSP 011200Z 08003KT 030V130 9999 -RA SC...  \n",
       "aero_metar                                                 SBSP  \n",
       "troca                                                         0  \n",
       "aero_tcp                                                   SBSP  \n",
       "duracao                                                  2918.0  "
      ]
     },
     "execution_count": 141,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(2).T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "metadata": {},
   "outputs": [],
   "source": [
    "from geopy.distance import geodesic\n",
    "\n",
    "# Coordenadas dos aeroportos (latitude, longitude)\n",
    "coordenadas = {\n",
    "    'SBBR': (-15.8697, -47.9207),  # Brasília\n",
    "    'SBFL': (-27.6703, -48.5525),  # Florianópolis\n",
    "    'SBCT': (-25.5282, -49.1758),  # Curitiba\n",
    "    'SBRJ': (-22.9102, -43.1631),  # Rio de Janeiro (Santos Dumont)\n",
    "    'SBCF': (-19.6328, -43.9634),  # Belo Horizonte (Confins)\n",
    "    'SBPA': (-29.9936, -51.1770),  # Porto Alegre\n",
    "    'SBSP': (-23.6261, -46.6566),  # São Paulo (Congonhas)\n",
    "    'SBRF': (-8.1264, -34.9240),   # Recife\n",
    "    'SBSV': (-12.9105, -38.3311),  # Salvador\n",
    "    'SBKP': (-23.0074, -47.1345),  # Campinas (Viracopos)\n",
    "    'SBGR': (-23.4322, -46.4695),  # São Paulo (Guarulhos)\n",
    "    'SBGL': (-22.8076, -43.2506)   # Rio de Janeiro (Galeão)\n",
    "}\n",
    "\n",
    "# Calcular distância entre todos os pares de aeroportos\n",
    "for aeroporto1 in coordenadas:\n",
    "    for aeroporto2 in coordenadas:\n",
    "        if aeroporto1 != aeroporto2:\n",
    "            distancia = geodesic(coordenadas[aeroporto1], coordenadas[aeroporto2]).kilometers\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 143,
   "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>flightid</th>\n",
       "      <th>origem</th>\n",
       "      <th>destino</th>\n",
       "      <th>esperas</th>\n",
       "      <th>aero_esperas</th>\n",
       "      <th>metaf</th>\n",
       "      <th>aero_metaf</th>\n",
       "      <th>metar</th>\n",
       "      <th>aero_metar</th>\n",
       "      <th>troca</th>\n",
       "      <th>aero_tcp</th>\n",
       "      <th>duracao</th>\n",
       "      <th>distancia</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2127312fea57d093815e49b5aefee46d</td>\n",
       "      <td>SBBR</td>\n",
       "      <td>SBGL</td>\n",
       "      <td>0</td>\n",
       "      <td>SBGL</td>\n",
       "      <td>METAF SBGL 011200Z  15002KT 2000     BR BKN033...</td>\n",
       "      <td>SBGL</td>\n",
       "      <td>METAR SBGL 011100Z 10003KT 070V130 7000 FEW009...</td>\n",
       "      <td>SBGL</td>\n",
       "      <td>0</td>\n",
       "      <td>SBGL</td>\n",
       "      <td>4737.0</td>\n",
       "      <td>911.166170</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>e20845be25ed24b87131066d865cd9bc</td>\n",
       "      <td>SBFL</td>\n",
       "      <td>SBSP</td>\n",
       "      <td>0</td>\n",
       "      <td>SBSP</td>\n",
       "      <td>METAF SBSP 011300Z 07004KT 4000     BR OVC033 ...</td>\n",
       "      <td>SBSP</td>\n",
       "      <td>METAR SBSP 011200Z 08003KT 030V130 9999 -RA SC...</td>\n",
       "      <td>SBSP</td>\n",
       "      <td>0</td>\n",
       "      <td>SBSP</td>\n",
       "      <td>2918.0</td>\n",
       "      <td>486.770907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>79ffad2c4f0b8f0d6a25977140daf9a9</td>\n",
       "      <td>SBCT</td>\n",
       "      <td>SBSP</td>\n",
       "      <td>0</td>\n",
       "      <td>SBSP</td>\n",
       "      <td>METAF SBSP 011300Z 07004KT 4000     BR OVC033 ...</td>\n",
       "      <td>SBSP</td>\n",
       "      <td>METAR SBSP 011200Z 08003KT 030V130 9999 -RA SC...</td>\n",
       "      <td>SBSP</td>\n",
       "      <td>0</td>\n",
       "      <td>SBSP</td>\n",
       "      <td>2712.0</td>\n",
       "      <td>330.898357</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2b846c207720b4eb92a3da158ac6cf68</td>\n",
       "      <td>SBCT</td>\n",
       "      <td>SBSP</td>\n",
       "      <td>0</td>\n",
       "      <td>SBSP</td>\n",
       "      <td>METAF SBSP 011300Z 07004KT 4000     BR OVC033 ...</td>\n",
       "      <td>SBSP</td>\n",
       "      <td>METAR SBSP 011200Z 08003KT 030V130 9999 -RA SC...</td>\n",
       "      <td>SBSP</td>\n",
       "      <td>0</td>\n",
       "      <td>SBSP</td>\n",
       "      <td>2748.0</td>\n",
       "      <td>330.898357</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>f51e68eeabfa16c625e7454a8974333e</td>\n",
       "      <td>SBRJ</td>\n",
       "      <td>SBSP</td>\n",
       "      <td>0</td>\n",
       "      <td>SBSP</td>\n",
       "      <td>METAF SBSP 011300Z 07004KT 4000     BR OVC033 ...</td>\n",
       "      <td>SBSP</td>\n",
       "      <td>METAR SBSP 011200Z 08003KT 030V130 9999 -RA SC...</td>\n",
       "      <td>SBSP</td>\n",
       "      <td>0</td>\n",
       "      <td>SBSP</td>\n",
       "      <td>2678.0</td>\n",
       "      <td>366.126382</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152430</th>\n",
       "      <td>9ff5febb9d79c517679bf20050066027</td>\n",
       "      <td>SBPA</td>\n",
       "      <td>SBKP</td>\n",
       "      <td>0</td>\n",
       "      <td>SBKP</td>\n",
       "      <td>METAF SBKP 131400Z  12006KT CAVOK 19/10 Q1020=\\n</td>\n",
       "      <td>SBKP</td>\n",
       "      <td>METAR SBKP 131300Z 13011KT CAVOK 18/10 Q1021=</td>\n",
       "      <td>SBKP</td>\n",
       "      <td>0</td>\n",
       "      <td>SBKP</td>\n",
       "      <td>4878.0</td>\n",
       "      <td>872.461572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152431</th>\n",
       "      <td>49681283735fdda95885adaebdad245e</td>\n",
       "      <td>SBRJ</td>\n",
       "      <td>SBBR</td>\n",
       "      <td>0</td>\n",
       "      <td>SBBR</td>\n",
       "      <td>METAF SBBR 131700Z  18003KT CAVOK 27/11 Q1014=\\n</td>\n",
       "      <td>SBBR</td>\n",
       "      <td>METAR SBBR 131600Z 14003KT 9999 FEW040 26/14 Q...</td>\n",
       "      <td>SBBR</td>\n",
       "      <td>0</td>\n",
       "      <td>SBBR</td>\n",
       "      <td>5202.0</td>\n",
       "      <td>925.595955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152432</th>\n",
       "      <td>0ea8f882431d6fbe1f431a0593bbf54d</td>\n",
       "      <td>SBKP</td>\n",
       "      <td>SBBR</td>\n",
       "      <td>0</td>\n",
       "      <td>SBBR</td>\n",
       "      <td>METAF SBBR 131700Z  18003KT CAVOK 27/11 Q1014=\\n</td>\n",
       "      <td>SBBR</td>\n",
       "      <td>METAR SBBR 131600Z 14003KT 9999 FEW040 26/14 Q...</td>\n",
       "      <td>SBBR</td>\n",
       "      <td>0</td>\n",
       "      <td>SBBR</td>\n",
       "      <td>4501.0</td>\n",
       "      <td>794.426702</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152433</th>\n",
       "      <td>b4251c41bdc3e827ec18c89a40bbd45c</td>\n",
       "      <td>SBGR</td>\n",
       "      <td>SBGL</td>\n",
       "      <td>0</td>\n",
       "      <td>SBGL</td>\n",
       "      <td>METAF SBGL 132100Z  16006KT 9999       OVC033 ...</td>\n",
       "      <td>SBGL</td>\n",
       "      <td>METAR SBGL 132000Z 14008KT 9999 SCT023 BKN040 ...</td>\n",
       "      <td>SBGL</td>\n",
       "      <td>0</td>\n",
       "      <td>SBGL</td>\n",
       "      <td>2229.0</td>\n",
       "      <td>336.886260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152434</th>\n",
       "      <td>f7e7a2104137d2d6b9bd89ba2ab9a433</td>\n",
       "      <td>SBRF</td>\n",
       "      <td>SBGL</td>\n",
       "      <td>0</td>\n",
       "      <td>SBGL</td>\n",
       "      <td>METAF SBGL 132200Z  15005KT 9999       OVC033 ...</td>\n",
       "      <td>SBGL</td>\n",
       "      <td>METAR SBGL 132100Z 13006KT 9999 SCT023 BKN040 ...</td>\n",
       "      <td>SBGL</td>\n",
       "      <td>0</td>\n",
       "      <td>SBGL</td>\n",
       "      <td>9598.0</td>\n",
       "      <td>1852.647674</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>152435 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                flightid origem destino  esperas aero_esperas  \\\n",
       "0       2127312fea57d093815e49b5aefee46d   SBBR    SBGL        0         SBGL   \n",
       "1       e20845be25ed24b87131066d865cd9bc   SBFL    SBSP        0         SBSP   \n",
       "2       79ffad2c4f0b8f0d6a25977140daf9a9   SBCT    SBSP        0         SBSP   \n",
       "3       2b846c207720b4eb92a3da158ac6cf68   SBCT    SBSP        0         SBSP   \n",
       "4       f51e68eeabfa16c625e7454a8974333e   SBRJ    SBSP        0         SBSP   \n",
       "...                                  ...    ...     ...      ...          ...   \n",
       "152430  9ff5febb9d79c517679bf20050066027   SBPA    SBKP        0         SBKP   \n",
       "152431  49681283735fdda95885adaebdad245e   SBRJ    SBBR        0         SBBR   \n",
       "152432  0ea8f882431d6fbe1f431a0593bbf54d   SBKP    SBBR        0         SBBR   \n",
       "152433  b4251c41bdc3e827ec18c89a40bbd45c   SBGR    SBGL        0         SBGL   \n",
       "152434  f7e7a2104137d2d6b9bd89ba2ab9a433   SBRF    SBGL        0         SBGL   \n",
       "\n",
       "                                                    metaf aero_metaf  \\\n",
       "0       METAF SBGL 011200Z  15002KT 2000     BR BKN033...       SBGL   \n",
       "1       METAF SBSP 011300Z 07004KT 4000     BR OVC033 ...       SBSP   \n",
       "2       METAF SBSP 011300Z 07004KT 4000     BR OVC033 ...       SBSP   \n",
       "3       METAF SBSP 011300Z 07004KT 4000     BR OVC033 ...       SBSP   \n",
       "4       METAF SBSP 011300Z 07004KT 4000     BR OVC033 ...       SBSP   \n",
       "...                                                   ...        ...   \n",
       "152430   METAF SBKP 131400Z  12006KT CAVOK 19/10 Q1020=\\n       SBKP   \n",
       "152431   METAF SBBR 131700Z  18003KT CAVOK 27/11 Q1014=\\n       SBBR   \n",
       "152432   METAF SBBR 131700Z  18003KT CAVOK 27/11 Q1014=\\n       SBBR   \n",
       "152433  METAF SBGL 132100Z  16006KT 9999       OVC033 ...       SBGL   \n",
       "152434  METAF SBGL 132200Z  15005KT 9999       OVC033 ...       SBGL   \n",
       "\n",
       "                                                    metar aero_metar  troca  \\\n",
       "0       METAR SBGL 011100Z 10003KT 070V130 7000 FEW009...       SBGL      0   \n",
       "1       METAR SBSP 011200Z 08003KT 030V130 9999 -RA SC...       SBSP      0   \n",
       "2       METAR SBSP 011200Z 08003KT 030V130 9999 -RA SC...       SBSP      0   \n",
       "3       METAR SBSP 011200Z 08003KT 030V130 9999 -RA SC...       SBSP      0   \n",
       "4       METAR SBSP 011200Z 08003KT 030V130 9999 -RA SC...       SBSP      0   \n",
       "...                                                   ...        ...    ...   \n",
       "152430      METAR SBKP 131300Z 13011KT CAVOK 18/10 Q1021=       SBKP      0   \n",
       "152431  METAR SBBR 131600Z 14003KT 9999 FEW040 26/14 Q...       SBBR      0   \n",
       "152432  METAR SBBR 131600Z 14003KT 9999 FEW040 26/14 Q...       SBBR      0   \n",
       "152433  METAR SBGL 132000Z 14008KT 9999 SCT023 BKN040 ...       SBGL      0   \n",
       "152434  METAR SBGL 132100Z 13006KT 9999 SCT023 BKN040 ...       SBGL      0   \n",
       "\n",
       "       aero_tcp  duracao    distancia  \n",
       "0          SBGL   4737.0   911.166170  \n",
       "1          SBSP   2918.0   486.770907  \n",
       "2          SBSP   2712.0   330.898357  \n",
       "3          SBSP   2748.0   330.898357  \n",
       "4          SBSP   2678.0   366.126382  \n",
       "...         ...      ...          ...  \n",
       "152430     SBKP   4878.0   872.461572  \n",
       "152431     SBBR   5202.0   925.595955  \n",
       "152432     SBBR   4501.0   794.426702  \n",
       "152433     SBGL   2229.0   336.886260  \n",
       "152434     SBGL   9598.0  1852.647674  \n",
       "\n",
       "[152435 rows x 13 columns]"
      ]
     },
     "execution_count": 143,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def distancia(row):\n",
    "     return geodesic(coordenadas[row['origem']], coordenadas[row['destino']]).kilometers\n",
    "\n",
    "df['distancia'] = df.apply(distancia, axis=1)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "metadata": {},
   "outputs": [],
   "source": [
    "from metar import Metar"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "- temp\n",
    "- vis\n",
    "- max_vis\n",
    "- wind_speed\n",
    "- wind_gust\n",
    "- dewpt\n",
    "- press\n",
    "- wind_speed_peak\n",
    "- press_sea_level\n",
    "- precip_1hr "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 160,
   "metadata": {},
   "outputs": [],
   "source": [
    "def download(row, met, tipo):\n",
    "    meta = row[tipo]\n",
    "    if tipo == 'metaf':\n",
    "        meta = meta.replace('METAF', 'METAR').split('\\n')[0]\n",
    "\n",
    "    obs = Metar.Metar(meta)\n",
    "    metodo = getattr(obs, met, None)\n",
    "    if metodo == None:\n",
    "        print(f'Id: {row.flightid}\\nParametro: {met}')\n",
    "        return 0\n",
    "    return metodo.value()\n",
    "\n",
    "def extracao_meta(df, tipo = 'metar'):\n",
    "    sufixo = '_'+ tipo\n",
    "    dados = [\n",
    "    \"temp\",\n",
    "    \"vis\",\n",
    "    \"wind_speed\",\n",
    "    \"dewpt\",\n",
    "    \"press\",\n",
    "    ]\n",
    "    for met in dados:\n",
    "        df[met+sufixo] = df.apply(download, axis=1, args=(met,tipo,))\n",
    "\n",
    "    return df.copy()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 154,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1b6a0449ff56f8db04cd97e005f6482f \n",
      " press\n"
     ]
    }
   ],
   "source": [
    "train = extracao_meta(df, 'metar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 155,
   "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>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>flightid</th>\n",
       "      <td>2127312fea57d093815e49b5aefee46d</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>origem</th>\n",
       "      <td>SBBR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>destino</th>\n",
       "      <td>SBGL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>esperas</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_esperas</th>\n",
       "      <td>SBGL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>metaf</th>\n",
       "      <td>METAF SBGL 011200Z  15002KT 2000     BR BKN033...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_metaf</th>\n",
       "      <td>SBGL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>metar</th>\n",
       "      <td>METAR SBGL 011100Z 10003KT 070V130 7000 FEW009...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_metar</th>\n",
       "      <td>SBGL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>troca</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_tcp</th>\n",
       "      <td>SBGL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>duracao</th>\n",
       "      <td>4737.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>distancia</th>\n",
       "      <td>911.16617</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>temp_metar</th>\n",
       "      <td>23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>vis_metar</th>\n",
       "      <td>7000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>wind_speed_metar</th>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dewpt_metar</th>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>press_metar</th>\n",
       "      <td>1016.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                  0\n",
       "flightid                           2127312fea57d093815e49b5aefee46d\n",
       "origem                                                         SBBR\n",
       "destino                                                        SBGL\n",
       "esperas                                                           0\n",
       "aero_esperas                                                   SBGL\n",
       "metaf             METAF SBGL 011200Z  15002KT 2000     BR BKN033...\n",
       "aero_metaf                                                     SBGL\n",
       "metar             METAR SBGL 011100Z 10003KT 070V130 7000 FEW009...\n",
       "aero_metar                                                     SBGL\n",
       "troca                                                             0\n",
       "aero_tcp                                                       SBGL\n",
       "duracao                                                      4737.0\n",
       "distancia                                                 911.16617\n",
       "temp_metar                                                     23.0\n",
       "vis_metar                                                    7000.0\n",
       "wind_speed_metar                                                3.0\n",
       "dewpt_metar                                                    21.0\n",
       "press_metar                                                  1016.0"
      ]
     },
     "execution_count": 155,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train.head(1).T"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### TEste"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 173,
   "metadata": {},
   "outputs": [],
   "source": [
    "from datetime import datetime, timedelta\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 174,
   "metadata": {},
   "outputs": [],
   "source": [
    "test = pd.read_csv('idsc_test.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 175,
   "metadata": {},
   "outputs": [],
   "source": [
    "colunas = ['dt_dep', 'hora_ref', 'hora_esperas', 'hora_metar', 'hora_metaf', 'hora_tcp']\n",
    "\n",
    "# 1. Converter as colunas para datetime de uma só vez\n",
    "test[colunas] = test[colunas].apply(pd.to_datetime)\n",
    "\n",
    "# 2. Encontrar índices de linhas com 'hora_metaf' nula\n",
    "null_indices = test.index[test['hora_metaf'].isna()]\n",
    "\n",
    "# 3. Atualizar as colunas com base nas colunas 'hora_metar' e 'metar'\n",
    "test.loc[null_indices, 'hora_metaf'] = test.loc[null_indices, 'hora_metar'] + timedelta(hours=1)\n",
    "test.loc[null_indices, 'metaf'] = test.loc[null_indices, 'metar']\n",
    "test.loc[null_indices, 'aero_metaf'] = test.loc[null_indices, 'aero_metar']\n",
    "\n",
    "# 4. Converter as colunas para valores inteiros UNIX timestamp\n",
    "# df[colunas] = df[colunas].apply(lambda x: x.dt.timestamp()).astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 176,
   "metadata": {},
   "outputs": [],
   "source": [
    "test = extracao_meta(test, 'metar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 177,
   "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>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>flightid</th>\n",
       "      <td>7945735584a3297121c4f5ae0de8ecd1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>origem</th>\n",
       "      <td>SBKP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>destino</th>\n",
       "      <td>SBSV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dt_dep</th>\n",
       "      <td>2023-05-30 11:36:03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hora_ref</th>\n",
       "      <td>2023-05-30 11:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>snapshot_radar</th>\n",
       "      <td>MULTIPOINT ((-0.8807200448127578 -0.5148453155...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>path</th>\n",
       "      <td>http://satelite.cptec.inpe.br/repositoriogoes/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hora_esperas</th>\n",
       "      <td>2023-05-30 10:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>esperas</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_esperas</th>\n",
       "      <td>SBSV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hora_metaf</th>\n",
       "      <td>2023-05-30 12:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>metaf</th>\n",
       "      <td>METAR SBSV 301100Z 12009KT 9999 FEW023 28/21 Q...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_metaf</th>\n",
       "      <td>SBSV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hora_metar</th>\n",
       "      <td>2023-05-30 11:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>metar</th>\n",
       "      <td>METAR SBSV 301100Z 12009KT 9999 FEW023 28/21 Q...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_metar</th>\n",
       "      <td>SBSV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hora_tcp</th>\n",
       "      <td>2023-05-30 12:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>troca</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_tcp</th>\n",
       "      <td>SBSV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hora_tcr</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_tcr</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>temp_metar</th>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>vis_metar</th>\n",
       "      <td>10000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>wind_speed_metar</th>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dewpt_metar</th>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>press_metar</th>\n",
       "      <td>1019.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                  0\n",
       "flightid                           7945735584a3297121c4f5ae0de8ecd1\n",
       "origem                                                         SBKP\n",
       "destino                                                        SBSV\n",
       "dt_dep                                          2023-05-30 11:36:03\n",
       "hora_ref                                        2023-05-30 11:00:00\n",
       "snapshot_radar    MULTIPOINT ((-0.8807200448127578 -0.5148453155...\n",
       "path              http://satelite.cptec.inpe.br/repositoriogoes/...\n",
       "hora_esperas                                    2023-05-30 10:00:00\n",
       "esperas                                                           0\n",
       "aero_esperas                                                   SBSV\n",
       "hora_metaf                                      2023-05-30 12:00:00\n",
       "metaf             METAR SBSV 301100Z 12009KT 9999 FEW023 28/21 Q...\n",
       "aero_metaf                                                     SBSV\n",
       "hora_metar                                      2023-05-30 11:00:00\n",
       "metar             METAR SBSV 301100Z 12009KT 9999 FEW023 28/21 Q...\n",
       "aero_metar                                                     SBSV\n",
       "hora_tcp                                        2023-05-30 12:00:00\n",
       "troca                                                             0\n",
       "aero_tcp                                                       SBSV\n",
       "hora_tcr                                                        NaN\n",
       "aero_tcr                                                        NaN\n",
       "temp_metar                                                     28.0\n",
       "vis_metar                                                   10000.0\n",
       "wind_speed_metar                                                9.0\n",
       "dewpt_metar                                                    21.0\n",
       "press_metar                                                  1019.0"
      ]
     },
     "execution_count": 177,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test.head(1).T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 183,
   "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>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>flightid</th>\n",
       "      <td>7945735584a3297121c4f5ae0de8ecd1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>origem</th>\n",
       "      <td>SBKP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>destino</th>\n",
       "      <td>SBSV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dt_dep</th>\n",
       "      <td>2023-05-30 11:36:03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hora_ref</th>\n",
       "      <td>2023-05-30 11:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>snapshot_radar</th>\n",
       "      <td>MULTIPOINT ((-0.8807200448127578 -0.5148453155...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>path</th>\n",
       "      <td>http://satelite.cptec.inpe.br/repositoriogoes/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hora_esperas</th>\n",
       "      <td>2023-05-30 10:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>esperas</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_esperas</th>\n",
       "      <td>SBSV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hora_metaf</th>\n",
       "      <td>2023-05-30 12:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>metaf</th>\n",
       "      <td>METAR SBSV 301100Z 12009KT 9999 FEW023 28/21 Q...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_metaf</th>\n",
       "      <td>SBSV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hora_metar</th>\n",
       "      <td>2023-05-30 11:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>metar</th>\n",
       "      <td>METAR SBSV 301100Z 12009KT 9999 FEW023 28/21 Q...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_metar</th>\n",
       "      <td>SBSV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hora_tcp</th>\n",
       "      <td>2023-05-30 12:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>troca</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_tcp</th>\n",
       "      <td>SBSV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hora_tcr</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aero_tcr</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>temp_metar</th>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>vis_metar</th>\n",
       "      <td>10000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>wind_speed_metar</th>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dewpt_metar</th>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>press_metar</th>\n",
       "      <td>1019.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>temp_metaf</th>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>vis_metaf</th>\n",
       "      <td>10000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>wind_speed_metaf</th>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dewpt_metaf</th>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>press_metaf</th>\n",
       "      <td>1019.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                  0\n",
       "flightid                           7945735584a3297121c4f5ae0de8ecd1\n",
       "origem                                                         SBKP\n",
       "destino                                                        SBSV\n",
       "dt_dep                                          2023-05-30 11:36:03\n",
       "hora_ref                                        2023-05-30 11:00:00\n",
       "snapshot_radar    MULTIPOINT ((-0.8807200448127578 -0.5148453155...\n",
       "path              http://satelite.cptec.inpe.br/repositoriogoes/...\n",
       "hora_esperas                                    2023-05-30 10:00:00\n",
       "esperas                                                           0\n",
       "aero_esperas                                                   SBSV\n",
       "hora_metaf                                      2023-05-30 12:00:00\n",
       "metaf             METAR SBSV 301100Z 12009KT 9999 FEW023 28/21 Q...\n",
       "aero_metaf                                                     SBSV\n",
       "hora_metar                                      2023-05-30 11:00:00\n",
       "metar             METAR SBSV 301100Z 12009KT 9999 FEW023 28/21 Q...\n",
       "aero_metar                                                     SBSV\n",
       "hora_tcp                                        2023-05-30 12:00:00\n",
       "troca                                                             0\n",
       "aero_tcp                                                       SBSV\n",
       "hora_tcr                                                        NaN\n",
       "aero_tcr                                                        NaN\n",
       "temp_metar                                                     28.0\n",
       "vis_metar                                                   10000.0\n",
       "wind_speed_metar                                                9.0\n",
       "dewpt_metar                                                    21.0\n",
       "press_metar                                                  1019.0\n",
       "temp_metaf                                                     28.0\n",
       "vis_metaf                                                   10000.0\n",
       "wind_speed_metaf                                                9.0\n",
       "dewpt_metaf                                                    21.0\n",
       "press_metaf                                                  1019.0"
      ]
     },
     "execution_count": 183,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "extracao_meta(test, 'metaf').head(1).T"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.4"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}