07Intro Pandas_gestion de info duplicada y faltante.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "c6b172c2",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "df = pd.read_csv(\"C:/Users/dd_18/Documents/Python_para_data_science/DataScience_notes/2008.csv\", nrows=1e6)\n",
    "# Carga un millon de datos nrows = 1e6"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "c5429cd6",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfduplicate = pd.concat([df, df])\n",
    "#dfduplicate = df.append(df) #data frame con todos los datos duplicados\n",
    "\n",
    "#NOTA: debido a que el método append fue deprecado desde pandas 2.0, se usa en su lugar la función concat()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "79546ef9",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfduplicate = dfduplicate.sample(frac=1) #reordenado"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "d173d835",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Gestion de datos duplicados\n",
    "dfclean = dfduplicate.drop_duplicates() # eliminando los datos duplicados del data frame y asignandolo a uno nuevo"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "95841514",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(dfclean) == len(df) # El numero de filas del nuevo data frame es distinto al numero de filas del original"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "c238fc9a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "999996"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(dfclean) # el nuevo df tiene 4 filas menos que el original\n",
    "# Estos se debe a que el original tenia en si mismo datos duplicados"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "ffaf5637",
   "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>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th>DayofMonth</th>\n",
       "      <th>DayOfWeek</th>\n",
       "      <th>DepTime</th>\n",
       "      <th>CRSDepTime</th>\n",
       "      <th>ArrTime</th>\n",
       "      <th>CRSArrTime</th>\n",
       "      <th>UniqueCarrier</th>\n",
       "      <th>FlightNum</th>\n",
       "      <th>...</th>\n",
       "      <th>TaxiIn</th>\n",
       "      <th>TaxiOut</th>\n",
       "      <th>Cancelled</th>\n",
       "      <th>CancellationCode</th>\n",
       "      <th>Diverted</th>\n",
       "      <th>CarrierDelay</th>\n",
       "      <th>WeatherDelay</th>\n",
       "      <th>NASDelay</th>\n",
       "      <th>SecurityDelay</th>\n",
       "      <th>LateAircraftDelay</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>184381</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>945.0</td>\n",
       "      <td>908</td>\n",
       "      <td>1035.0</td>\n",
       "      <td>959</td>\n",
       "      <td>OO</td>\n",
       "      <td>5432</td>\n",
       "      <td>...</td>\n",
       "      <td>8.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>36.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>680750</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>1838.0</td>\n",
       "      <td>1835</td>\n",
       "      <td>1958.0</td>\n",
       "      <td>2000</td>\n",
       "      <td>WN</td>\n",
       "      <td>1573</td>\n",
       "      <td>...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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>697120</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>1318.0</td>\n",
       "      <td>1300</td>\n",
       "      <td>1552.0</td>\n",
       "      <td>1540</td>\n",
       "      <td>XE</td>\n",
       "      <td>24</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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>155422</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>1700.0</td>\n",
       "      <td>1650</td>\n",
       "      <td>1815.0</td>\n",
       "      <td>1808</td>\n",
       "      <td>OH</td>\n",
       "      <td>5105</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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>112283</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>600.0</td>\n",
       "      <td>600</td>\n",
       "      <td>833.0</td>\n",
       "      <td>810</td>\n",
       "      <td>XE</td>\n",
       "      <td>2921</td>\n",
       "      <td>...</td>\n",
       "      <td>11.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>794449</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>19</td>\n",
       "      <td>2</td>\n",
       "      <td>1459.0</td>\n",
       "      <td>1429</td>\n",
       "      <td>1634.0</td>\n",
       "      <td>1619</td>\n",
       "      <td>OO</td>\n",
       "      <td>6226</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>938492</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>29</td>\n",
       "      <td>5</td>\n",
       "      <td>652.0</td>\n",
       "      <td>700</td>\n",
       "      <td>832.0</td>\n",
       "      <td>843</td>\n",
       "      <td>F9</td>\n",
       "      <td>868</td>\n",
       "      <td>...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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>341209</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>1950.0</td>\n",
       "      <td>1850</td>\n",
       "      <td>1948.0</td>\n",
       "      <td>1844</td>\n",
       "      <td>EV</td>\n",
       "      <td>4755</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>860507</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>2000</td>\n",
       "      <td>2128.0</td>\n",
       "      <td>2143</td>\n",
       "      <td>US</td>\n",
       "      <td>1528</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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>675835</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>24</td>\n",
       "      <td>7</td>\n",
       "      <td>2043.0</td>\n",
       "      <td>2005</td>\n",
       "      <td>2143.0</td>\n",
       "      <td>2105</td>\n",
       "      <td>WN</td>\n",
       "      <td>3771</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>302260</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>806.0</td>\n",
       "      <td>805</td>\n",
       "      <td>822.0</td>\n",
       "      <td>820</td>\n",
       "      <td>WN</td>\n",
       "      <td>614</td>\n",
       "      <td>...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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>946243</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>1133.0</td>\n",
       "      <td>1117</td>\n",
       "      <td>1423.0</td>\n",
       "      <td>1412</td>\n",
       "      <td>FL</td>\n",
       "      <td>296</td>\n",
       "      <td>...</td>\n",
       "      <td>11.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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>175552</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>813.0</td>\n",
       "      <td>810</td>\n",
       "      <td>950.0</td>\n",
       "      <td>929</td>\n",
       "      <td>OO</td>\n",
       "      <td>6499</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>264430</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>1610.0</td>\n",
       "      <td>1611</td>\n",
       "      <td>1826.0</td>\n",
       "      <td>1835</td>\n",
       "      <td>US</td>\n",
       "      <td>514</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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>560417</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>7</td>\n",
       "      <td>1929.0</td>\n",
       "      <td>1830</td>\n",
       "      <td>2121.0</td>\n",
       "      <td>2115</td>\n",
       "      <td>B6</td>\n",
       "      <td>115</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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>929448</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>1548.0</td>\n",
       "      <td>1545</td>\n",
       "      <td>1819.0</td>\n",
       "      <td>1809</td>\n",
       "      <td>EV</td>\n",
       "      <td>4853</td>\n",
       "      <td>...</td>\n",
       "      <td>27.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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>665084</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>20</td>\n",
       "      <td>3</td>\n",
       "      <td>617.0</td>\n",
       "      <td>615</td>\n",
       "      <td>837.0</td>\n",
       "      <td>850</td>\n",
       "      <td>WN</td>\n",
       "      <td>3603</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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>925098</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "      <td>6</td>\n",
       "      <td>1640.0</td>\n",
       "      <td>1645</td>\n",
       "      <td>1838.0</td>\n",
       "      <td>1847</td>\n",
       "      <td>EV</td>\n",
       "      <td>4690</td>\n",
       "      <td>...</td>\n",
       "      <td>9.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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>148948</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>1100</td>\n",
       "      <td>1253.0</td>\n",
       "      <td>1318</td>\n",
       "      <td>YV</td>\n",
       "      <td>2950</td>\n",
       "      <td>...</td>\n",
       "      <td>8.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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>63525</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>2</td>\n",
       "      <td>746.0</td>\n",
       "      <td>745</td>\n",
       "      <td>1057.0</td>\n",
       "      <td>1115</td>\n",
       "      <td>WN</td>\n",
       "      <td>3857</td>\n",
       "      <td>...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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>367488</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>1555.0</td>\n",
       "      <td>1559</td>\n",
       "      <td>1658.0</td>\n",
       "      <td>1703</td>\n",
       "      <td>FL</td>\n",
       "      <td>310</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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>916594</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>1633.0</td>\n",
       "      <td>1619</td>\n",
       "      <td>1734.0</td>\n",
       "      <td>1734</td>\n",
       "      <td>EV</td>\n",
       "      <td>4393</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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>466006</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>7</td>\n",
       "      <td>1421.0</td>\n",
       "      <td>1425</td>\n",
       "      <td>1542.0</td>\n",
       "      <td>1557</td>\n",
       "      <td>9E</td>\n",
       "      <td>5646</td>\n",
       "      <td>...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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>564096</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2051.0</td>\n",
       "      <td>2050</td>\n",
       "      <td>2329.0</td>\n",
       "      <td>2258</td>\n",
       "      <td>CO</td>\n",
       "      <td>507</td>\n",
       "      <td>...</td>\n",
       "      <td>11.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>316007</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>26</td>\n",
       "      <td>6</td>\n",
       "      <td>1558.0</td>\n",
       "      <td>1330</td>\n",
       "      <td>1808.0</td>\n",
       "      <td>1556</td>\n",
       "      <td>DL</td>\n",
       "      <td>644</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>672993</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>23</td>\n",
       "      <td>6</td>\n",
       "      <td>609.0</td>\n",
       "      <td>610</td>\n",
       "      <td>806.0</td>\n",
       "      <td>815</td>\n",
       "      <td>WN</td>\n",
       "      <td>799</td>\n",
       "      <td>...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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>305184</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>4</td>\n",
       "      <td>1257.0</td>\n",
       "      <td>1245</td>\n",
       "      <td>1431.0</td>\n",
       "      <td>1411</td>\n",
       "      <td>DL</td>\n",
       "      <td>961</td>\n",
       "      <td>...</td>\n",
       "      <td>8.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35726</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>1208.0</td>\n",
       "      <td>1210</td>\n",
       "      <td>1439.0</td>\n",
       "      <td>1455</td>\n",
       "      <td>WN</td>\n",
       "      <td>184</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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>217856</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>31</td>\n",
       "      <td>4</td>\n",
       "      <td>1338.0</td>\n",
       "      <td>1106</td>\n",
       "      <td>1520.0</td>\n",
       "      <td>1236</td>\n",
       "      <td>OO</td>\n",
       "      <td>6404</td>\n",
       "      <td>...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>164.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221636</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "      <td>2309.0</td>\n",
       "      <td>2310</td>\n",
       "      <td>457.0</td>\n",
       "      <td>501</td>\n",
       "      <td>UA</td>\n",
       "      <td>126</td>\n",
       "      <td>...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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>87600</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>700</td>\n",
       "      <td>NaN</td>\n",
       "      <td>805</td>\n",
       "      <td>WN</td>\n",
       "      <td>1918</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>B</td>\n",
       "      <td>0</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>31 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Year  Month  DayofMonth  DayOfWeek  DepTime  CRSDepTime  ArrTime   \n",
       "184381  2008      1          10          4    945.0         908   1035.0  \\\n",
       "680750  2008      2          25          1   1838.0        1835   1958.0   \n",
       "697120  2008      2           8          5   1318.0        1300   1552.0   \n",
       "155422  2008      1           9          3   1700.0        1650   1815.0   \n",
       "112283  2008      1           5          6    600.0         600    833.0   \n",
       "794449  2008      2          19          2   1459.0        1429   1634.0   \n",
       "938492  2008      2          29          5    652.0         700    832.0   \n",
       "341209  2008      1           2          3   1950.0        1850   1948.0   \n",
       "860507  2008      2          11          1   2000.0        2000   2128.0   \n",
       "675835  2008      2          24          7   2043.0        2005   2143.0   \n",
       "302260  2008      1           3          4    806.0         805    822.0   \n",
       "946243  2008      2          12          2   1133.0        1117   1423.0   \n",
       "175552  2008      1           4          5    813.0         810    950.0   \n",
       "264430  2008      1           7          1   1610.0        1611   1826.0   \n",
       "560417  2008      1          27          7   1929.0        1830   2121.0   \n",
       "929448  2008      2          18          1   1548.0        1545   1819.0   \n",
       "665084  2008      2          20          3    617.0         615    837.0   \n",
       "925098  2008      2          16          6   1640.0        1645   1838.0   \n",
       "148948  2008      1          28          1   1050.0        1100   1253.0   \n",
       "63525   2008      1          22          2    746.0         745   1057.0   \n",
       "367488  2008      1          21          1   1555.0        1559   1658.0   \n",
       "916594  2008      2           6          3   1633.0        1619   1734.0   \n",
       "466006  2008      1          13          7   1421.0        1425   1542.0   \n",
       "564096  2008      1           1          2   2051.0        2050   2329.0   \n",
       "316007  2008      1          26          6   1558.0        1330   1808.0   \n",
       "672993  2008      2          23          6    609.0         610    806.0   \n",
       "305184  2008      1          17          4   1257.0        1245   1431.0   \n",
       "35726   2008      1          14          1   1208.0        1210   1439.0   \n",
       "217856  2008      1          31          4   1338.0        1106   1520.0   \n",
       "221636  2008      1          15          2   2309.0        2310    457.0   \n",
       "87600   2008      1          30          3      NaN         700      NaN   \n",
       "\n",
       "        CRSArrTime UniqueCarrier  FlightNum  ... TaxiIn  TaxiOut  Cancelled   \n",
       "184381         959            OO       5432  ...    8.0     13.0          0  \\\n",
       "680750        2000            WN       1573  ...    6.0     11.0          0   \n",
       "697120        1540            XE         24  ...    4.0      9.0          0   \n",
       "155422        1808            OH       5105  ...    5.0      9.0          0   \n",
       "112283         810            XE       2921  ...   11.0     30.0          0   \n",
       "794449        1619            OO       6226  ...    5.0     14.0          0   \n",
       "938492         843            F9        868  ...    6.0      9.0          0   \n",
       "341209        1844            EV       4755  ...    2.0     26.0          0   \n",
       "860507        2143            US       1528  ...    4.0     17.0          0   \n",
       "675835        2105            WN       3771  ...    5.0     11.0          0   \n",
       "302260         820            WN        614  ...    6.0     17.0          0   \n",
       "946243        1412            FL        296  ...   11.0      8.0          0   \n",
       "175552         929            OO       6499  ...    5.0     19.0          0   \n",
       "264430        1835            US        514  ...    4.0     29.0          0   \n",
       "560417        2115            B6        115  ...    3.0     16.0          0   \n",
       "929448        1809            EV       4853  ...   27.0      7.0          0   \n",
       "665084         850            WN       3603  ...    4.0      5.0          0   \n",
       "925098        1847            EV       4690  ...    9.0     10.0          0   \n",
       "148948        1318            YV       2950  ...    8.0     11.0          0   \n",
       "63525         1115            WN       3857  ...    6.0     11.0          0   \n",
       "367488        1703            FL        310  ...    4.0     18.0          0   \n",
       "916594        1734            EV       4393  ...    3.0     12.0          0   \n",
       "466006        1557            9E       5646  ...    6.0     12.0          0   \n",
       "564096        2258            CO        507  ...   11.0     53.0          0   \n",
       "316007        1556            DL        644  ...    5.0     12.0          0   \n",
       "672993         815            WN        799  ...    6.0      9.0          0   \n",
       "305184        1411            DL        961  ...    8.0     21.0          0   \n",
       "35726         1455            WN        184  ...    3.0      9.0          0   \n",
       "217856        1236            OO       6404  ...    6.0     12.0          0   \n",
       "221636         501            UA        126  ...    6.0     21.0          0   \n",
       "87600          805            WN       1918  ...    NaN      NaN          1   \n",
       "\n",
       "        CancellationCode  Diverted  CarrierDelay WeatherDelay NASDelay   \n",
       "184381               NaN         0           0.0          0.0      0.0  \\\n",
       "680750               NaN         0           NaN          NaN      NaN   \n",
       "697120               NaN         0           NaN          NaN      NaN   \n",
       "155422               NaN         0           NaN          NaN      NaN   \n",
       "112283               NaN         0           0.0          0.0     23.0   \n",
       "794449               NaN         0           0.0          0.0      0.0   \n",
       "938492               NaN         0           NaN          NaN      NaN   \n",
       "341209               NaN         0          60.0          0.0      4.0   \n",
       "860507               NaN         0           NaN          NaN      NaN   \n",
       "675835               NaN         0           0.0          0.0      0.0   \n",
       "302260               NaN         0           NaN          NaN      NaN   \n",
       "946243               NaN         0           NaN          NaN      NaN   \n",
       "175552               NaN         0           0.0          0.0      0.0   \n",
       "264430               NaN         0           NaN          NaN      NaN   \n",
       "560417               NaN         0           NaN          NaN      NaN   \n",
       "929448               NaN         0           NaN          NaN      NaN   \n",
       "665084               NaN         0           NaN          NaN      NaN   \n",
       "925098               NaN         0           NaN          NaN      NaN   \n",
       "148948               NaN         0           NaN          NaN      NaN   \n",
       "63525                NaN         0           NaN          NaN      NaN   \n",
       "367488               NaN         0           NaN          NaN      NaN   \n",
       "916594               NaN         0           NaN          NaN      NaN   \n",
       "466006               NaN         0           NaN          NaN      NaN   \n",
       "564096               NaN         0           0.0          0.0     31.0   \n",
       "316007               NaN         0         132.0          0.0      0.0   \n",
       "672993               NaN         0           NaN          NaN      NaN   \n",
       "305184               NaN         0           0.0          3.0      8.0   \n",
       "35726                NaN         0           NaN          NaN      NaN   \n",
       "217856               NaN         0           0.0          0.0    164.0   \n",
       "221636               NaN         0           NaN          NaN      NaN   \n",
       "87600                  B         0           NaN          NaN      NaN   \n",
       "\n",
       "        SecurityDelay  LateAircraftDelay  \n",
       "184381            0.0               36.0  \n",
       "680750            NaN                NaN  \n",
       "697120            NaN                NaN  \n",
       "155422            NaN                NaN  \n",
       "112283            0.0                0.0  \n",
       "794449            0.0               15.0  \n",
       "938492            NaN                NaN  \n",
       "341209            0.0                0.0  \n",
       "860507            NaN                NaN  \n",
       "675835            0.0               38.0  \n",
       "302260            NaN                NaN  \n",
       "946243            NaN                NaN  \n",
       "175552            0.0               21.0  \n",
       "264430            NaN                NaN  \n",
       "560417            NaN                NaN  \n",
       "929448            NaN                NaN  \n",
       "665084            NaN                NaN  \n",
       "925098            NaN                NaN  \n",
       "148948            NaN                NaN  \n",
       "63525             NaN                NaN  \n",
       "367488            NaN                NaN  \n",
       "916594            NaN                NaN  \n",
       "466006            NaN                NaN  \n",
       "564096            0.0                0.0  \n",
       "316007            0.0                0.0  \n",
       "672993            NaN                NaN  \n",
       "305184            0.0                9.0  \n",
       "35726             NaN                NaN  \n",
       "217856            0.0                0.0  \n",
       "221636            NaN                NaN  \n",
       "87600             NaN                NaN  \n",
       "\n",
       "[31 rows x 29 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfclean.drop_duplicates(subset= \"DayofMonth\") # El parametro subset le indica la columna sobre la que busca duplicados\n",
    "#Unicamente eliminará filas en las que el dato de DayofMonth esta duplicado  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "c825d6e7",
   "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>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th>DayofMonth</th>\n",
       "      <th>DayOfWeek</th>\n",
       "      <th>DepTime</th>\n",
       "      <th>CRSDepTime</th>\n",
       "      <th>ArrTime</th>\n",
       "      <th>CRSArrTime</th>\n",
       "      <th>UniqueCarrier</th>\n",
       "      <th>FlightNum</th>\n",
       "      <th>...</th>\n",
       "      <th>TaxiIn</th>\n",
       "      <th>TaxiOut</th>\n",
       "      <th>Cancelled</th>\n",
       "      <th>CancellationCode</th>\n",
       "      <th>Diverted</th>\n",
       "      <th>CarrierDelay</th>\n",
       "      <th>WeatherDelay</th>\n",
       "      <th>NASDelay</th>\n",
       "      <th>SecurityDelay</th>\n",
       "      <th>LateAircraftDelay</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>0 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Year, Month, DayofMonth, DayOfWeek, DepTime, CRSDepTime, ArrTime, CRSArrTime, UniqueCarrier, FlightNum, TailNum, ActualElapsedTime, CRSElapsedTime, AirTime, ArrDelay, DepDelay, Origin, Dest, Distance, TaxiIn, TaxiOut, Cancelled, CancellationCode, Diverted, CarrierDelay, WeatherDelay, NASDelay, SecurityDelay, LateAircraftDelay]\n",
       "Index: []\n",
       "\n",
       "[0 rows x 29 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Gestion de datos faltantes\n",
    "df.dropna() # se obtiene un data frame vacio porque todas las filas tienen al menos un dato faltente\n",
    "# porque si el vuelo esta cancelado no tiene hora de llegada y si tiene hora de llegada no esta cancelado"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "dfef820d",
   "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>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th>DayofMonth</th>\n",
       "      <th>DayOfWeek</th>\n",
       "      <th>DepTime</th>\n",
       "      <th>CRSDepTime</th>\n",
       "      <th>ArrTime</th>\n",
       "      <th>CRSArrTime</th>\n",
       "      <th>UniqueCarrier</th>\n",
       "      <th>FlightNum</th>\n",
       "      <th>...</th>\n",
       "      <th>TaxiIn</th>\n",
       "      <th>TaxiOut</th>\n",
       "      <th>Cancelled</th>\n",
       "      <th>CancellationCode</th>\n",
       "      <th>Diverted</th>\n",
       "      <th>CarrierDelay</th>\n",
       "      <th>WeatherDelay</th>\n",
       "      <th>NASDelay</th>\n",
       "      <th>SecurityDelay</th>\n",
       "      <th>LateAircraftDelay</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1829.0</td>\n",
       "      <td>1755</td>\n",
       "      <td>1959.0</td>\n",
       "      <td>1925</td>\n",
       "      <td>WN</td>\n",
       "      <td>3920</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>32.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1937.0</td>\n",
       "      <td>1830</td>\n",
       "      <td>2037.0</td>\n",
       "      <td>1940</td>\n",
       "      <td>WN</td>\n",
       "      <td>509</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>47.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1644.0</td>\n",
       "      <td>1510</td>\n",
       "      <td>1845.0</td>\n",
       "      <td>1725</td>\n",
       "      <td>WN</td>\n",
       "      <td>1333</td>\n",
       "      <td>...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>72.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1452.0</td>\n",
       "      <td>1425</td>\n",
       "      <td>1640.0</td>\n",
       "      <td>1625</td>\n",
       "      <td>WN</td>\n",
       "      <td>675</td>\n",
       "      <td>...</td>\n",
       "      <td>7.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1323.0</td>\n",
       "      <td>1255</td>\n",
       "      <td>1526.0</td>\n",
       "      <td>1510</td>\n",
       "      <td>WN</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</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",
       "      <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>999973</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>23</td>\n",
       "      <td>6</td>\n",
       "      <td>1306.0</td>\n",
       "      <td>1235</td>\n",
       "      <td>1514.0</td>\n",
       "      <td>1415</td>\n",
       "      <td>MQ</td>\n",
       "      <td>4694</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999983</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>28</td>\n",
       "      <td>4</td>\n",
       "      <td>1458.0</td>\n",
       "      <td>1235</td>\n",
       "      <td>1645.0</td>\n",
       "      <td>1415</td>\n",
       "      <td>MQ</td>\n",
       "      <td>4694</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>143.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999988</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1754.0</td>\n",
       "      <td>1655</td>\n",
       "      <td>2056.0</td>\n",
       "      <td>2005</td>\n",
       "      <td>MQ</td>\n",
       "      <td>4695</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>51.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999989</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>1812.0</td>\n",
       "      <td>1655</td>\n",
       "      <td>2129.0</td>\n",
       "      <td>2005</td>\n",
       "      <td>MQ</td>\n",
       "      <td>4695</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999994</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>1717.0</td>\n",
       "      <td>1655</td>\n",
       "      <td>2030.0</td>\n",
       "      <td>2005</td>\n",
       "      <td>MQ</td>\n",
       "      <td>4695</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>254596 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Year  Month  DayofMonth  DayOfWeek  DepTime  CRSDepTime  ArrTime   \n",
       "4       2008      1           3          4   1829.0        1755   1959.0  \\\n",
       "6       2008      1           3          4   1937.0        1830   2037.0   \n",
       "11      2008      1           3          4   1644.0        1510   1845.0   \n",
       "16      2008      1           3          4   1452.0        1425   1640.0   \n",
       "18      2008      1           3          4   1323.0        1255   1526.0   \n",
       "...      ...    ...         ...        ...      ...         ...      ...   \n",
       "999973  2008      2          23          6   1306.0        1235   1514.0   \n",
       "999983  2008      2          28          4   1458.0        1235   1645.0   \n",
       "999988  2008      2           4          1   1754.0        1655   2056.0   \n",
       "999989  2008      2           5          2   1812.0        1655   2129.0   \n",
       "999994  2008      2          11          1   1717.0        1655   2030.0   \n",
       "\n",
       "        CRSArrTime UniqueCarrier  FlightNum  ... TaxiIn  TaxiOut  Cancelled   \n",
       "4             1925            WN       3920  ...    3.0     10.0          0  \\\n",
       "6             1940            WN        509  ...    3.0      7.0          0   \n",
       "11            1725            WN       1333  ...    6.0      8.0          0   \n",
       "16            1625            WN        675  ...    7.0      8.0          0   \n",
       "18            1510            WN          4  ...    4.0      9.0          0   \n",
       "...            ...           ...        ...  ...    ...      ...        ...   \n",
       "999973        1415            MQ       4694  ...    3.0     50.0          0   \n",
       "999983        1415            MQ       4694  ...    3.0     37.0          0   \n",
       "999988        2005            MQ       4695  ...    2.0      9.0          0   \n",
       "999989        2005            MQ       4695  ...    4.0     12.0          0   \n",
       "999994        2005            MQ       4695  ...    4.0     23.0          0   \n",
       "\n",
       "        CancellationCode  Diverted  CarrierDelay WeatherDelay NASDelay   \n",
       "4                    NaN         0           2.0          0.0      0.0  \\\n",
       "6                    NaN         0          10.0          0.0      0.0   \n",
       "11                   NaN         0           8.0          0.0      0.0   \n",
       "16                   NaN         0           3.0          0.0      0.0   \n",
       "18                   NaN         0           0.0          0.0      0.0   \n",
       "...                  ...       ...           ...          ...      ...   \n",
       "999973               NaN         0          31.0          0.0     28.0   \n",
       "999983               NaN         0           0.0          0.0      7.0   \n",
       "999988               NaN         0           0.0          0.0      0.0   \n",
       "999989               NaN         0          10.0          0.0      7.0   \n",
       "999994               NaN         0           0.0          0.0      3.0   \n",
       "\n",
       "        SecurityDelay  LateAircraftDelay  \n",
       "4                 0.0               32.0  \n",
       "6                 0.0               47.0  \n",
       "11                0.0               72.0  \n",
       "16                0.0               12.0  \n",
       "18                0.0               16.0  \n",
       "...               ...                ...  \n",
       "999973            0.0                0.0  \n",
       "999983            0.0              143.0  \n",
       "999988            0.0               51.0  \n",
       "999989            0.0               67.0  \n",
       "999994            0.0               22.0  \n",
       "\n",
       "[254596 rows x 29 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dropna(thresh= 25) \n",
    "# thres especifica cuantas entradas de todas las columnas queremos que esten llenas de informacion relevante"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "b312537a",
   "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>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th>DayofMonth</th>\n",
       "      <th>DayOfWeek</th>\n",
       "      <th>DepTime</th>\n",
       "      <th>CRSDepTime</th>\n",
       "      <th>ArrTime</th>\n",
       "      <th>CRSArrTime</th>\n",
       "      <th>UniqueCarrier</th>\n",
       "      <th>FlightNum</th>\n",
       "      <th>...</th>\n",
       "      <th>TaxiIn</th>\n",
       "      <th>TaxiOut</th>\n",
       "      <th>Cancelled</th>\n",
       "      <th>CancellationCode</th>\n",
       "      <th>Diverted</th>\n",
       "      <th>CarrierDelay</th>\n",
       "      <th>WeatherDelay</th>\n",
       "      <th>NASDelay</th>\n",
       "      <th>SecurityDelay</th>\n",
       "      <th>LateAircraftDelay</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1829.0</td>\n",
       "      <td>1755</td>\n",
       "      <td>1959.0</td>\n",
       "      <td>1925</td>\n",
       "      <td>WN</td>\n",
       "      <td>3920</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>32.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1937.0</td>\n",
       "      <td>1830</td>\n",
       "      <td>2037.0</td>\n",
       "      <td>1940</td>\n",
       "      <td>WN</td>\n",
       "      <td>509</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>47.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1644.0</td>\n",
       "      <td>1510</td>\n",
       "      <td>1845.0</td>\n",
       "      <td>1725</td>\n",
       "      <td>WN</td>\n",
       "      <td>1333</td>\n",
       "      <td>...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>72.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1452.0</td>\n",
       "      <td>1425</td>\n",
       "      <td>1640.0</td>\n",
       "      <td>1625</td>\n",
       "      <td>WN</td>\n",
       "      <td>675</td>\n",
       "      <td>...</td>\n",
       "      <td>7.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1323.0</td>\n",
       "      <td>1255</td>\n",
       "      <td>1526.0</td>\n",
       "      <td>1510</td>\n",
       "      <td>WN</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</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",
       "      <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>999973</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>23</td>\n",
       "      <td>6</td>\n",
       "      <td>1306.0</td>\n",
       "      <td>1235</td>\n",
       "      <td>1514.0</td>\n",
       "      <td>1415</td>\n",
       "      <td>MQ</td>\n",
       "      <td>4694</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999983</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>28</td>\n",
       "      <td>4</td>\n",
       "      <td>1458.0</td>\n",
       "      <td>1235</td>\n",
       "      <td>1645.0</td>\n",
       "      <td>1415</td>\n",
       "      <td>MQ</td>\n",
       "      <td>4694</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>143.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999988</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1754.0</td>\n",
       "      <td>1655</td>\n",
       "      <td>2056.0</td>\n",
       "      <td>2005</td>\n",
       "      <td>MQ</td>\n",
       "      <td>4695</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>51.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999989</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>1812.0</td>\n",
       "      <td>1655</td>\n",
       "      <td>2129.0</td>\n",
       "      <td>2005</td>\n",
       "      <td>MQ</td>\n",
       "      <td>4695</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999994</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>1717.0</td>\n",
       "      <td>1655</td>\n",
       "      <td>2030.0</td>\n",
       "      <td>2005</td>\n",
       "      <td>MQ</td>\n",
       "      <td>4695</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>254596 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Year  Month  DayofMonth  DayOfWeek  DepTime  CRSDepTime  ArrTime   \n",
       "4       2008      1           3          4   1829.0        1755   1959.0  \\\n",
       "6       2008      1           3          4   1937.0        1830   2037.0   \n",
       "11      2008      1           3          4   1644.0        1510   1845.0   \n",
       "16      2008      1           3          4   1452.0        1425   1640.0   \n",
       "18      2008      1           3          4   1323.0        1255   1526.0   \n",
       "...      ...    ...         ...        ...      ...         ...      ...   \n",
       "999973  2008      2          23          6   1306.0        1235   1514.0   \n",
       "999983  2008      2          28          4   1458.0        1235   1645.0   \n",
       "999988  2008      2           4          1   1754.0        1655   2056.0   \n",
       "999989  2008      2           5          2   1812.0        1655   2129.0   \n",
       "999994  2008      2          11          1   1717.0        1655   2030.0   \n",
       "\n",
       "        CRSArrTime UniqueCarrier  FlightNum  ... TaxiIn  TaxiOut  Cancelled   \n",
       "4             1925            WN       3920  ...    3.0     10.0          0  \\\n",
       "6             1940            WN        509  ...    3.0      7.0          0   \n",
       "11            1725            WN       1333  ...    6.0      8.0          0   \n",
       "16            1625            WN        675  ...    7.0      8.0          0   \n",
       "18            1510            WN          4  ...    4.0      9.0          0   \n",
       "...            ...           ...        ...  ...    ...      ...        ...   \n",
       "999973        1415            MQ       4694  ...    3.0     50.0          0   \n",
       "999983        1415            MQ       4694  ...    3.0     37.0          0   \n",
       "999988        2005            MQ       4695  ...    2.0      9.0          0   \n",
       "999989        2005            MQ       4695  ...    4.0     12.0          0   \n",
       "999994        2005            MQ       4695  ...    4.0     23.0          0   \n",
       "\n",
       "        CancellationCode  Diverted  CarrierDelay WeatherDelay NASDelay   \n",
       "4                    NaN         0           2.0          0.0      0.0  \\\n",
       "6                    NaN         0          10.0          0.0      0.0   \n",
       "11                   NaN         0           8.0          0.0      0.0   \n",
       "16                   NaN         0           3.0          0.0      0.0   \n",
       "18                   NaN         0           0.0          0.0      0.0   \n",
       "...                  ...       ...           ...          ...      ...   \n",
       "999973               NaN         0          31.0          0.0     28.0   \n",
       "999983               NaN         0           0.0          0.0      7.0   \n",
       "999988               NaN         0           0.0          0.0      0.0   \n",
       "999989               NaN         0          10.0          0.0      7.0   \n",
       "999994               NaN         0           0.0          0.0      3.0   \n",
       "\n",
       "        SecurityDelay  LateAircraftDelay  \n",
       "4                 0.0               32.0  \n",
       "6                 0.0               47.0  \n",
       "11                0.0               72.0  \n",
       "16                0.0               12.0  \n",
       "18                0.0               16.0  \n",
       "...               ...                ...  \n",
       "999973            0.0                0.0  \n",
       "999983            0.0              143.0  \n",
       "999988            0.0               51.0  \n",
       "999989            0.0               67.0  \n",
       "999994            0.0               22.0  \n",
       "\n",
       "[254596 rows x 29 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dropna(thresh=len(df.columns)-2) # maximo dos valores faltantes "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "3ab8eb94",
   "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>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th>DayofMonth</th>\n",
       "      <th>DayOfWeek</th>\n",
       "      <th>DepTime</th>\n",
       "      <th>CRSDepTime</th>\n",
       "      <th>ArrTime</th>\n",
       "      <th>CRSArrTime</th>\n",
       "      <th>UniqueCarrier</th>\n",
       "      <th>FlightNum</th>\n",
       "      <th>...</th>\n",
       "      <th>TaxiIn</th>\n",
       "      <th>TaxiOut</th>\n",
       "      <th>Cancelled</th>\n",
       "      <th>CancellationCode</th>\n",
       "      <th>Diverted</th>\n",
       "      <th>CarrierDelay</th>\n",
       "      <th>WeatherDelay</th>\n",
       "      <th>NASDelay</th>\n",
       "      <th>SecurityDelay</th>\n",
       "      <th>LateAircraftDelay</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>700</td>\n",
       "      <td>NaN</td>\n",
       "      <td>830</td>\n",
       "      <td>WN</td>\n",
       "      <td>126</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>A</td>\n",
       "      <td>0</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>373</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1215</td>\n",
       "      <td>WN</td>\n",
       "      <td>1146</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>A</td>\n",
       "      <td>0</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>399</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>905</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1025</td>\n",
       "      <td>WN</td>\n",
       "      <td>469</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>A</td>\n",
       "      <td>0</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>401</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1620</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1740</td>\n",
       "      <td>WN</td>\n",
       "      <td>618</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>C</td>\n",
       "      <td>0</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>415</th>\n",
       "      <td>2008</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1930</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2035</td>\n",
       "      <td>WN</td>\n",
       "      <td>2528</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>A</td>\n",
       "      <td>0</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>...</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",
       "      <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>999913</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>855</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1210</td>\n",
       "      <td>MQ</td>\n",
       "      <td>4693</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>A</td>\n",
       "      <td>0</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>999919</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>17</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>855</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1210</td>\n",
       "      <td>MQ</td>\n",
       "      <td>4693</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>B</td>\n",
       "      <td>0</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>999961</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>17</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1445</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1630</td>\n",
       "      <td>MQ</td>\n",
       "      <td>4694</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>B</td>\n",
       "      <td>0</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>999971</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>22</td>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1235</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1415</td>\n",
       "      <td>MQ</td>\n",
       "      <td>4694</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>B</td>\n",
       "      <td>0</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>999999</th>\n",
       "      <td>2008</td>\n",
       "      <td>2</td>\n",
       "      <td>17</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1655</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2005</td>\n",
       "      <td>MQ</td>\n",
       "      <td>4695</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>B</td>\n",
       "      <td>0</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>32133 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Year  Month  DayofMonth  DayOfWeek  DepTime  CRSDepTime  ArrTime   \n",
       "178     2008      1           3          4      NaN         700      NaN  \\\n",
       "373     2008      1           3          4      NaN        1100      NaN   \n",
       "399     2008      1           3          4      NaN         905      NaN   \n",
       "401     2008      1           3          4      NaN        1620      NaN   \n",
       "415     2008      1           3          4      NaN        1930      NaN   \n",
       "...      ...    ...         ...        ...      ...         ...      ...   \n",
       "999913  2008      2          11          1      NaN         855      NaN   \n",
       "999919  2008      2          17          7      NaN         855      NaN   \n",
       "999961  2008      2          17          7      NaN        1445      NaN   \n",
       "999971  2008      2          22          5      NaN        1235      NaN   \n",
       "999999  2008      2          17          7      NaN        1655      NaN   \n",
       "\n",
       "        CRSArrTime UniqueCarrier  FlightNum  ... TaxiIn  TaxiOut  Cancelled   \n",
       "178            830            WN        126  ...    NaN      NaN          1  \\\n",
       "373           1215            WN       1146  ...    NaN      NaN          1   \n",
       "399           1025            WN        469  ...    NaN      NaN          1   \n",
       "401           1740            WN        618  ...    NaN      NaN          1   \n",
       "415           2035            WN       2528  ...    NaN      NaN          1   \n",
       "...            ...           ...        ...  ...    ...      ...        ...   \n",
       "999913        1210            MQ       4693  ...    NaN      NaN          1   \n",
       "999919        1210            MQ       4693  ...    NaN      NaN          1   \n",
       "999961        1630            MQ       4694  ...    NaN      NaN          1   \n",
       "999971        1415            MQ       4694  ...    NaN      NaN          1   \n",
       "999999        2005            MQ       4695  ...    NaN      NaN          1   \n",
       "\n",
       "        CancellationCode  Diverted  CarrierDelay WeatherDelay NASDelay   \n",
       "178                    A         0           NaN          NaN      NaN  \\\n",
       "373                    A         0           NaN          NaN      NaN   \n",
       "399                    A         0           NaN          NaN      NaN   \n",
       "401                    C         0           NaN          NaN      NaN   \n",
       "415                    A         0           NaN          NaN      NaN   \n",
       "...                  ...       ...           ...          ...      ...   \n",
       "999913                 A         0           NaN          NaN      NaN   \n",
       "999919                 B         0           NaN          NaN      NaN   \n",
       "999961                 B         0           NaN          NaN      NaN   \n",
       "999971                 B         0           NaN          NaN      NaN   \n",
       "999999                 B         0           NaN          NaN      NaN   \n",
       "\n",
       "        SecurityDelay  LateAircraftDelay  \n",
       "178               NaN                NaN  \n",
       "373               NaN                NaN  \n",
       "399               NaN                NaN  \n",
       "401               NaN                NaN  \n",
       "415               NaN                NaN  \n",
       "...               ...                ...  \n",
       "999913            NaN                NaN  \n",
       "999919            NaN                NaN  \n",
       "999961            NaN                NaN  \n",
       "999971            NaN                NaN  \n",
       "999999            NaN                NaN  \n",
       "\n",
       "[32133 rows x 29 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dropna(subset= [\"CancellationCode\"]) # con subset le especificas la columna en la que no quieres datos faltantes"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}