createAirlinesCsv.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import math\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from datetime import datetime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "pd.set_option('display.max_columns', None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "path = r'C:\\Users\\kosma\\Desktop\\MAGISTER\\\\DataExpo2009\\csv\\2007.csv'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "frame = pd.read_csv(path, index_col=None, sep = ',')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Year                 7453215\n",
       "Month                7453215\n",
       "DayofMonth           7453215\n",
       "DayOfWeek            7453215\n",
       "DepTime              7292467\n",
       "CRSDepTime           7453215\n",
       "ArrTime              7275288\n",
       "CRSArrTime           7453215\n",
       "UniqueCarrier        7453215\n",
       "FlightNum            7453215\n",
       "TailNum              7453193\n",
       "ActualElapsedTime    7275288\n",
       "CRSElapsedTime       7452221\n",
       "AirTime              7275288\n",
       "ArrDelay             7275288\n",
       "DepDelay             7292467\n",
       "Origin               7453215\n",
       "Dest                 7453215\n",
       "Distance             7453215\n",
       "TaxiIn               7453215\n",
       "TaxiOut              7453215\n",
       "Cancelled            7453215\n",
       "CancellationCode      160749\n",
       "Diverted             7453215\n",
       "CarrierDelay         7453215\n",
       "WeatherDelay         7453215\n",
       "NASDelay             7453215\n",
       "SecurityDelay        7453215\n",
       "LateAircraftDelay    7453215\n",
       "dtype: int64"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frame.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Year                 7453188\n",
       "Month                7453188\n",
       "DayofMonth           7453188\n",
       "DayOfWeek            7453188\n",
       "DepTime              7292440\n",
       "CRSDepTime           7453188\n",
       "ArrTime              7275261\n",
       "CRSArrTime           7453188\n",
       "UniqueCarrier        7453188\n",
       "FlightNum            7453188\n",
       "TailNum              7453166\n",
       "ActualElapsedTime    7275261\n",
       "CRSElapsedTime       7452194\n",
       "AirTime              7275261\n",
       "ArrDelay             7275261\n",
       "DepDelay             7292440\n",
       "Origin               7453188\n",
       "Dest                 7453188\n",
       "Distance             7453188\n",
       "TaxiIn               7453188\n",
       "TaxiOut              7453188\n",
       "Cancelled            7453188\n",
       "CancellationCode      160749\n",
       "Diverted             7453188\n",
       "CarrierDelay         7453188\n",
       "WeatherDelay         7453188\n",
       "NASDelay             7453188\n",
       "SecurityDelay        7453188\n",
       "LateAircraftDelay    7453188\n",
       "dtype: int64"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frame.drop_duplicates().count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>TailNum</th>\n",
       "      <th>ActualElapsedTime</th>\n",
       "      <th>CRSElapsedTime</th>\n",
       "      <th>AirTime</th>\n",
       "      <th>ArrDelay</th>\n",
       "      <th>DepDelay</th>\n",
       "      <th>Origin</th>\n",
       "      <th>Dest</th>\n",
       "      <th>Distance</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>0</th>\n",
       "      <td>2007</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1232.0</td>\n",
       "      <td>1225</td>\n",
       "      <td>1341.0</td>\n",
       "      <td>1340</td>\n",
       "      <td>WN</td>\n",
       "      <td>2891</td>\n",
       "      <td>N351</td>\n",
       "      <td>69.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>SMF</td>\n",
       "      <td>ONT</td>\n",
       "      <td>389</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2007</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1918.0</td>\n",
       "      <td>1905</td>\n",
       "      <td>2043.0</td>\n",
       "      <td>2035</td>\n",
       "      <td>WN</td>\n",
       "      <td>462</td>\n",
       "      <td>N370</td>\n",
       "      <td>85.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>SMF</td>\n",
       "      <td>PDX</td>\n",
       "      <td>479</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2007</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2206.0</td>\n",
       "      <td>2130</td>\n",
       "      <td>2334.0</td>\n",
       "      <td>2300</td>\n",
       "      <td>WN</td>\n",
       "      <td>1229</td>\n",
       "      <td>N685</td>\n",
       "      <td>88.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>SMF</td>\n",
       "      <td>PDX</td>\n",
       "      <td>479</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2007</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1230.0</td>\n",
       "      <td>1200</td>\n",
       "      <td>1356.0</td>\n",
       "      <td>1330</td>\n",
       "      <td>WN</td>\n",
       "      <td>1355</td>\n",
       "      <td>N364</td>\n",
       "      <td>86.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>SMF</td>\n",
       "      <td>PDX</td>\n",
       "      <td>479</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2007</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>831.0</td>\n",
       "      <td>830</td>\n",
       "      <td>957.0</td>\n",
       "      <td>1000</td>\n",
       "      <td>WN</td>\n",
       "      <td>2278</td>\n",
       "      <td>N480</td>\n",
       "      <td>86.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>SMF</td>\n",
       "      <td>PDX</td>\n",
       "      <td>479</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>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",
       "      <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>7453210</th>\n",
       "      <td>2007</td>\n",
       "      <td>12</td>\n",
       "      <td>15</td>\n",
       "      <td>6</td>\n",
       "      <td>1558.0</td>\n",
       "      <td>1605</td>\n",
       "      <td>1749.0</td>\n",
       "      <td>1736</td>\n",
       "      <td>DL</td>\n",
       "      <td>58</td>\n",
       "      <td>N670DN</td>\n",
       "      <td>111.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>-7.0</td>\n",
       "      <td>MCO</td>\n",
       "      <td>ATL</td>\n",
       "      <td>403</td>\n",
       "      <td>14</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7453211</th>\n",
       "      <td>2007</td>\n",
       "      <td>12</td>\n",
       "      <td>15</td>\n",
       "      <td>6</td>\n",
       "      <td>1902.0</td>\n",
       "      <td>1851</td>\n",
       "      <td>2110.0</td>\n",
       "      <td>2105</td>\n",
       "      <td>DL</td>\n",
       "      <td>59</td>\n",
       "      <td>N829MH</td>\n",
       "      <td>248.0</td>\n",
       "      <td>254.0</td>\n",
       "      <td>221.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>ATL</td>\n",
       "      <td>SLC</td>\n",
       "      <td>1589</td>\n",
       "      <td>6</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7453212</th>\n",
       "      <td>2007</td>\n",
       "      <td>12</td>\n",
       "      <td>15</td>\n",
       "      <td>6</td>\n",
       "      <td>1024.0</td>\n",
       "      <td>1025</td>\n",
       "      <td>1750.0</td>\n",
       "      <td>1735</td>\n",
       "      <td>DL</td>\n",
       "      <td>61</td>\n",
       "      <td>N623DL</td>\n",
       "      <td>266.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>233.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>LAX</td>\n",
       "      <td>ATL</td>\n",
       "      <td>1946</td>\n",
       "      <td>14</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7453213</th>\n",
       "      <td>2007</td>\n",
       "      <td>12</td>\n",
       "      <td>15</td>\n",
       "      <td>6</td>\n",
       "      <td>1353.0</td>\n",
       "      <td>1315</td>\n",
       "      <td>1658.0</td>\n",
       "      <td>1622</td>\n",
       "      <td>DL</td>\n",
       "      <td>62</td>\n",
       "      <td>N970DL</td>\n",
       "      <td>125.0</td>\n",
       "      <td>127.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>DFW</td>\n",
       "      <td>ATL</td>\n",
       "      <td>732</td>\n",
       "      <td>11</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7453214</th>\n",
       "      <td>2007</td>\n",
       "      <td>12</td>\n",
       "      <td>15</td>\n",
       "      <td>6</td>\n",
       "      <td>1824.0</td>\n",
       "      <td>1800</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>1928</td>\n",
       "      <td>DL</td>\n",
       "      <td>63</td>\n",
       "      <td>N628DL</td>\n",
       "      <td>97.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>ATL</td>\n",
       "      <td>MCO</td>\n",
       "      <td>403</td>\n",
       "      <td>10</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7453215 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         Year  Month  DayofMonth  DayOfWeek  DepTime  CRSDepTime  ArrTime  \\\n",
       "0        2007      1           1          1   1232.0        1225   1341.0   \n",
       "1        2007      1           1          1   1918.0        1905   2043.0   \n",
       "2        2007      1           1          1   2206.0        2130   2334.0   \n",
       "3        2007      1           1          1   1230.0        1200   1356.0   \n",
       "4        2007      1           1          1    831.0         830    957.0   \n",
       "...       ...    ...         ...        ...      ...         ...      ...   \n",
       "7453210  2007     12          15          6   1558.0        1605   1749.0   \n",
       "7453211  2007     12          15          6   1902.0        1851   2110.0   \n",
       "7453212  2007     12          15          6   1024.0        1025   1750.0   \n",
       "7453213  2007     12          15          6   1353.0        1315   1658.0   \n",
       "7453214  2007     12          15          6   1824.0        1800   2001.0   \n",
       "\n",
       "         CRSArrTime UniqueCarrier  FlightNum TailNum  ActualElapsedTime  \\\n",
       "0              1340            WN       2891    N351               69.0   \n",
       "1              2035            WN        462    N370               85.0   \n",
       "2              2300            WN       1229    N685               88.0   \n",
       "3              1330            WN       1355    N364               86.0   \n",
       "4              1000            WN       2278    N480               86.0   \n",
       "...             ...           ...        ...     ...                ...   \n",
       "7453210        1736            DL         58  N670DN              111.0   \n",
       "7453211        2105            DL         59  N829MH              248.0   \n",
       "7453212        1735            DL         61  N623DL              266.0   \n",
       "7453213        1622            DL         62  N970DL              125.0   \n",
       "7453214        1928            DL         63  N628DL               97.0   \n",
       "\n",
       "         CRSElapsedTime  AirTime  ArrDelay  DepDelay Origin Dest  Distance  \\\n",
       "0                  75.0     54.0       1.0       7.0    SMF  ONT       389   \n",
       "1                  90.0     74.0       8.0      13.0    SMF  PDX       479   \n",
       "2                  90.0     73.0      34.0      36.0    SMF  PDX       479   \n",
       "3                  90.0     75.0      26.0      30.0    SMF  PDX       479   \n",
       "4                  90.0     74.0      -3.0       1.0    SMF  PDX       479   \n",
       "...                 ...      ...       ...       ...    ...  ...       ...   \n",
       "7453210            91.0     80.0      13.0      -7.0    MCO  ATL       403   \n",
       "7453211           254.0    221.0       5.0      11.0    ATL  SLC      1589   \n",
       "7453212           250.0    233.0      15.0      -1.0    LAX  ATL      1946   \n",
       "7453213           127.0    100.0      36.0      38.0    DFW  ATL       732   \n",
       "7453214            88.0     61.0      33.0      24.0    ATL  MCO       403   \n",
       "\n",
       "         TaxiIn  TaxiOut  Cancelled CancellationCode  Diverted  CarrierDelay  \\\n",
       "0             4       11          0              NaN         0             0   \n",
       "1             5        6          0              NaN         0             0   \n",
       "2             6        9          0              NaN         0             3   \n",
       "3             3        8          0              NaN         0            23   \n",
       "4             3        9          0              NaN         0             0   \n",
       "...         ...      ...        ...              ...       ...           ...   \n",
       "7453210      14       17          0              NaN         0             0   \n",
       "7453211       6       21          0              NaN         0             0   \n",
       "7453212      14       19          0              NaN         0             0   \n",
       "7453213      11       14          0              NaN         0             0   \n",
       "7453214      10       26          0              NaN         0            24   \n",
       "\n",
       "         WeatherDelay  NASDelay  SecurityDelay  LateAircraftDelay  \n",
       "0                   0         0              0                  0  \n",
       "1                   0         0              0                  0  \n",
       "2                   0         0              0                 31  \n",
       "3                   0         0              0                  3  \n",
       "4                   0         0              0                  0  \n",
       "...               ...       ...            ...                ...  \n",
       "7453210             0         0              0                  0  \n",
       "7453211             0         0              0                  0  \n",
       "7453212             0        15              0                  0  \n",
       "7453213             0         0              0                 36  \n",
       "7453214             0         9              0                  0  \n",
       "\n",
       "[7453215 rows x 29 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " 4.0,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " 11.0,\n",
       " 17.0,\n",
       " 10.0,\n",
       " 19.0,\n",
       " 16.0,\n",
       " 18.0,\n",
       " 22.0,\n",
       " 20.0,\n",
       " 3.0,\n",
       " 23.0,\n",
       " 5.0,\n",
       " 24.0,\n",
       " 28.0,\n",
       " 25.0,\n",
       " 30.0,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " 33.0,\n",
       " nan,\n",
       " 32.0,\n",
       " 36.0,\n",
       " 43.0,\n",
       " 44.0,\n",
       " 45.0,\n",
       " 46.0,\n",
       " 47.0,\n",
       " 8.0,\n",
       " 40.0,\n",
       " 50.0,\n",
       " 48.0,\n",
       " 52.0,\n",
       " 53.0,\n",
       " 9.0,\n",
       " 55.0,\n",
       " 2.0,\n",
       " 57.0,\n",
       " 51.0,\n",
       " 54.0,\n",
       " 56.0,\n",
       " 12.0,\n",
       " 59.0,\n",
       " 58.0,\n",
       " nan,\n",
       " 13.0,\n",
       " 14.0,\n",
       " 15.0,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " 100.0,\n",
       " 101.0,\n",
       " 102.0,\n",
       " 103.0,\n",
       " 104.0,\n",
       " 105.0,\n",
       " 106.0,\n",
       " 107.0,\n",
       " 108.0,\n",
       " 21.0,\n",
       " 110.0,\n",
       " 111.0,\n",
       " 112.0,\n",
       " 113.0,\n",
       " 114.0,\n",
       " 115.0,\n",
       " 116.0,\n",
       " 117.0,\n",
       " 118.0,\n",
       " 119.0,\n",
       " 120.0,\n",
       " 121.0,\n",
       " 122.0,\n",
       " 123.0,\n",
       " 124.0,\n",
       " 125.0,\n",
       " 126.0,\n",
       " 127.0,\n",
       " 128.0,\n",
       " 129.0,\n",
       " 130.0,\n",
       " 131.0,\n",
       " 132.0,\n",
       " 133.0,\n",
       " 26.0,\n",
       " 135.0,\n",
       " 27.0,\n",
       " 136.0,\n",
       " 138.0,\n",
       " 139.0,\n",
       " 140.0,\n",
       " 137.0,\n",
       " 142.0,\n",
       " 143.0,\n",
       " 144.0,\n",
       " 145.0,\n",
       " 146.0,\n",
       " 147.0,\n",
       " 29.0,\n",
       " 149.0,\n",
       " 150.0,\n",
       " 151.0,\n",
       " 152.0,\n",
       " 153.0,\n",
       " 154.0,\n",
       " 155.0,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " 159.0,\n",
       " 158.0,\n",
       " 34.0,\n",
       " 35.0,\n",
       " 7.0,\n",
       " 37.0,\n",
       " 38.0,\n",
       " 39.0,\n",
       " 200.0,\n",
       " 201.0,\n",
       " 202.0,\n",
       " 203.0,\n",
       " 204.0,\n",
       " 205.0,\n",
       " 206.0,\n",
       " 41.0,\n",
       " 207.0,\n",
       " 209.0,\n",
       " 210.0,\n",
       " 211.0,\n",
       " 212.0,\n",
       " 213.0,\n",
       " 214.0,\n",
       " 215.0,\n",
       " 42.0,\n",
       " 216.0,\n",
       " 218.0,\n",
       " 219.0,\n",
       " 217.0,\n",
       " 221.0,\n",
       " 222.0,\n",
       " 223.0,\n",
       " 224.0,\n",
       " 220.0,\n",
       " 226.0,\n",
       " 227.0,\n",
       " 228.0,\n",
       " 229.0,\n",
       " 230.0,\n",
       " 231.0,\n",
       " 232.0,\n",
       " 233.0,\n",
       " 234.0,\n",
       " 235.0,\n",
       " 236.0,\n",
       " 237.0,\n",
       " 238.0,\n",
       " 239.0,\n",
       " 240.0,\n",
       " 241.0,\n",
       " 242.0,\n",
       " 243.0,\n",
       " 244.0,\n",
       " 245.0,\n",
       " 246.0,\n",
       " 49.0,\n",
       " 247.0,\n",
       " 249.0,\n",
       " 250.0,\n",
       " 251.0,\n",
       " 248.0,\n",
       " 253.0,\n",
       " 254.0,\n",
       " 255.0,\n",
       " 256.0,\n",
       " 257.0,\n",
       " 258.0,\n",
       " 259.0,\n",
       " 252.0,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " 300.0,\n",
       " 301.0,\n",
       " 302.0,\n",
       " 303.0,\n",
       " 304.0,\n",
       " 305.0,\n",
       " 306.0,\n",
       " 307.0,\n",
       " 308.0,\n",
       " 309.0,\n",
       " 310.0,\n",
       " 311.0,\n",
       " 312.0,\n",
       " 313.0,\n",
       " 314.0,\n",
       " 315.0,\n",
       " 316.0,\n",
       " 317.0,\n",
       " 318.0,\n",
       " 319.0,\n",
       " 320.0,\n",
       " 321.0,\n",
       " 322.0,\n",
       " 323.0,\n",
       " 324.0,\n",
       " 325.0,\n",
       " 326.0,\n",
       " 327.0,\n",
       " 328.0,\n",
       " 329.0,\n",
       " 330.0,\n",
       " 331.0,\n",
       " 332.0,\n",
       " 333.0,\n",
       " 334.0,\n",
       " 335.0,\n",
       " 336.0,\n",
       " 337.0,\n",
       " 338.0,\n",
       " 339.0,\n",
       " 340.0,\n",
       " 341.0,\n",
       " 343.0,\n",
       " 344.0,\n",
       " 345.0,\n",
       " 346.0,\n",
       " 347.0,\n",
       " 348.0,\n",
       " 349.0,\n",
       " 350.0,\n",
       " 351.0,\n",
       " 352.0,\n",
       " 353.0,\n",
       " 354.0,\n",
       " 355.0,\n",
       " 356.0,\n",
       " 357.0,\n",
       " 358.0,\n",
       " 359.0,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " 400.0,\n",
       " 401.0,\n",
       " 402.0,\n",
       " 403.0,\n",
       " 404.0,\n",
       " 405.0,\n",
       " 406.0,\n",
       " 407.0,\n",
       " 408.0,\n",
       " 409.0,\n",
       " 410.0,\n",
       " 411.0,\n",
       " 412.0,\n",
       " 413.0,\n",
       " 414.0,\n",
       " 415.0,\n",
       " 416.0,\n",
       " 417.0,\n",
       " 418.0,\n",
       " 419.0,\n",
       " 420.0,\n",
       " 421.0,\n",
       " 422.0,\n",
       " 423.0,\n",
       " 424.0,\n",
       " 425.0,\n",
       " 426.0,\n",
       " 427.0,\n",
       " 428.0,\n",
       " 429.0,\n",
       " 430.0,\n",
       " 431.0,\n",
       " 432.0,\n",
       " 433.0,\n",
       " 434.0,\n",
       " 435.0,\n",
       " 436.0,\n",
       " 437.0,\n",
       " 438.0,\n",
       " 439.0,\n",
       " 440.0,\n",
       " 441.0,\n",
       " 442.0,\n",
       " 443.0,\n",
       " 444.0,\n",
       " 445.0,\n",
       " 446.0,\n",
       " 447.0,\n",
       " 448.0,\n",
       " 449.0,\n",
       " 450.0,\n",
       " 451.0,\n",
       " 452.0,\n",
       " 453.0,\n",
       " 454.0,\n",
       " 455.0,\n",
       " 456.0,\n",
       " 457.0,\n",
       " 458.0,\n",
       " 459.0,\n",
       " 500.0,\n",
       " 501.0,\n",
       " 502.0,\n",
       " 503.0,\n",
       " 504.0,\n",
       " 505.0,\n",
       " 506.0,\n",
       " 507.0,\n",
       " 508.0,\n",
       " 509.0,\n",
       " 510.0,\n",
       " 511.0,\n",
       " 512.0,\n",
       " 513.0,\n",
       " 514.0,\n",
       " 515.0,\n",
       " 516.0,\n",
       " 517.0,\n",
       " 518.0,\n",
       " 519.0,\n",
       " 520.0,\n",
       " 521.0,\n",
       " 522.0,\n",
       " 523.0,\n",
       " 524.0,\n",
       " 525.0,\n",
       " 526.0,\n",
       " 527.0,\n",
       " 528.0,\n",
       " 529.0,\n",
       " 530.0,\n",
       " 531.0,\n",
       " 532.0,\n",
       " 533.0,\n",
       " 534.0,\n",
       " 535.0,\n",
       " 536.0,\n",
       " 537.0,\n",
       " 538.0,\n",
       " 539.0,\n",
       " 540.0,\n",
       " 541.0,\n",
       " 542.0,\n",
       " 543.0,\n",
       " 544.0,\n",
       " 545.0,\n",
       " 546.0,\n",
       " 547.0,\n",
       " 548.0,\n",
       " 549.0,\n",
       " 550.0,\n",
       " 551.0,\n",
       " 552.0,\n",
       " 553.0,\n",
       " 554.0,\n",
       " 555.0,\n",
       " 556.0,\n",
       " 557.0,\n",
       " 558.0,\n",
       " 559.0,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " 600.0,\n",
       " 601.0,\n",
       " 602.0,\n",
       " 603.0,\n",
       " 604.0,\n",
       " 605.0,\n",
       " 606.0,\n",
       " 607.0,\n",
       " 608.0,\n",
       " 609.0,\n",
       " 610.0,\n",
       " 611.0,\n",
       " 612.0,\n",
       " 613.0,\n",
       " 614.0,\n",
       " 615.0,\n",
       " 616.0,\n",
       " 617.0,\n",
       " 618.0,\n",
       " 619.0,\n",
       " 620.0,\n",
       " 621.0,\n",
       " 622.0,\n",
       " 623.0,\n",
       " 624.0,\n",
       " 625.0,\n",
       " 626.0,\n",
       " 627.0,\n",
       " 628.0,\n",
       " 629.0,\n",
       " 630.0,\n",
       " 631.0,\n",
       " 632.0,\n",
       " 633.0,\n",
       " 634.0,\n",
       " 635.0,\n",
       " 636.0,\n",
       " 637.0,\n",
       " 638.0,\n",
       " 639.0,\n",
       " 640.0,\n",
       " 641.0,\n",
       " 642.0,\n",
       " 643.0,\n",
       " 644.0,\n",
       " 645.0,\n",
       " 646.0,\n",
       " 647.0,\n",
       " 648.0,\n",
       " 649.0,\n",
       " 650.0,\n",
       " 651.0,\n",
       " 652.0,\n",
       " 653.0,\n",
       " 654.0,\n",
       " 655.0,\n",
       " 656.0,\n",
       " 657.0,\n",
       " 658.0,\n",
       " 659.0,\n",
       " 134.0,\n",
       " 700.0,\n",
       " 701.0,\n",
       " 702.0,\n",
       " 703.0,\n",
       " 704.0,\n",
       " 705.0,\n",
       " 706.0,\n",
       " 707.0,\n",
       " 708.0,\n",
       " 709.0,\n",
       " 710.0,\n",
       " 711.0,\n",
       " 712.0,\n",
       " 713.0,\n",
       " 714.0,\n",
       " 715.0,\n",
       " 716.0,\n",
       " 717.0,\n",
       " 718.0,\n",
       " 719.0,\n",
       " 720.0,\n",
       " 721.0,\n",
       " 722.0,\n",
       " 723.0,\n",
       " 724.0,\n",
       " 725.0,\n",
       " 726.0,\n",
       " 727.0,\n",
       " 728.0,\n",
       " 729.0,\n",
       " 730.0,\n",
       " 731.0,\n",
       " 732.0,\n",
       " 733.0,\n",
       " 734.0,\n",
       " 735.0,\n",
       " 736.0,\n",
       " 737.0,\n",
       " 738.0,\n",
       " 739.0,\n",
       " 740.0,\n",
       " 741.0,\n",
       " 742.0,\n",
       " 743.0,\n",
       " 744.0,\n",
       " 745.0,\n",
       " 746.0,\n",
       " 747.0,\n",
       " 748.0,\n",
       " 749.0,\n",
       " 750.0,\n",
       " 751.0,\n",
       " 752.0,\n",
       " 753.0,\n",
       " 754.0,\n",
       " 755.0,\n",
       " 756.0,\n",
       " 757.0,\n",
       " 758.0,\n",
       " 759.0,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " 157.0,\n",
       " 156.0,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " 800.0,\n",
       " 801.0,\n",
       " 802.0,\n",
       " 803.0,\n",
       " 804.0,\n",
       " 805.0,\n",
       " 806.0,\n",
       " 807.0,\n",
       " 808.0,\n",
       " 809.0,\n",
       " 810.0,\n",
       " 811.0,\n",
       " 812.0,\n",
       " 813.0,\n",
       " 814.0,\n",
       " 815.0,\n",
       " 816.0,\n",
       " 817.0,\n",
       " 818.0,\n",
       " 819.0,\n",
       " 820.0,\n",
       " 821.0,\n",
       " 822.0,\n",
       " 823.0,\n",
       " 824.0,\n",
       " 825.0,\n",
       " 826.0,\n",
       " 827.0,\n",
       " 828.0,\n",
       " 829.0,\n",
       " 830.0,\n",
       " 831.0,\n",
       " 832.0,\n",
       " 833.0,\n",
       " 834.0,\n",
       " 835.0,\n",
       " 836.0,\n",
       " 837.0,\n",
       " 838.0,\n",
       " 839.0,\n",
       " 840.0,\n",
       " 841.0,\n",
       " 842.0,\n",
       " 843.0,\n",
       " 844.0,\n",
       " 845.0,\n",
       " 846.0,\n",
       " 847.0,\n",
       " 848.0,\n",
       " 849.0,\n",
       " 850.0,\n",
       " 851.0,\n",
       " 852.0,\n",
       " 853.0,\n",
       " 854.0,\n",
       " 855.0,\n",
       " 856.0,\n",
       " 857.0,\n",
       " 858.0,\n",
       " 859.0,\n",
       " 900.0,\n",
       " 901.0,\n",
       " 902.0,\n",
       " 903.0,\n",
       " 904.0,\n",
       " 905.0,\n",
       " 906.0,\n",
       " 907.0,\n",
       " 908.0,\n",
       " 909.0,\n",
       " 910.0,\n",
       " 911.0,\n",
       " 912.0,\n",
       " 913.0,\n",
       " 914.0,\n",
       " 915.0,\n",
       " 916.0,\n",
       " 917.0,\n",
       " 918.0,\n",
       " 919.0,\n",
       " 920.0,\n",
       " 921.0,\n",
       " 922.0,\n",
       " 923.0,\n",
       " 924.0,\n",
       " 925.0,\n",
       " 926.0,\n",
       " 927.0,\n",
       " 928.0,\n",
       " 929.0,\n",
       " 930.0,\n",
       " 931.0,\n",
       " 932.0,\n",
       " 933.0,\n",
       " 934.0,\n",
       " 935.0,\n",
       " 936.0,\n",
       " 937.0,\n",
       " 938.0,\n",
       " 939.0,\n",
       " 940.0,\n",
       " 941.0,\n",
       " 942.0,\n",
       " 943.0,\n",
       " 944.0,\n",
       " 945.0,\n",
       " 946.0,\n",
       " 947.0,\n",
       " 948.0,\n",
       " 949.0,\n",
       " 950.0,\n",
       " 951.0,\n",
       " 952.0,\n",
       " 953.0,\n",
       " 954.0,\n",
       " 955.0,\n",
       " 956.0,\n",
       " 957.0,\n",
       " 958.0,\n",
       " 959.0,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " 1000.0,\n",
       " 1001.0,\n",
       " 1002.0,\n",
       " 1003.0,\n",
       " 1004.0,\n",
       " 1005.0,\n",
       " 1006.0,\n",
       " 1007.0,\n",
       " 1008.0,\n",
       " 1009.0,\n",
       " 1010.0,\n",
       " 1011.0,\n",
       " 1012.0,\n",
       " 1013.0,\n",
       " 1014.0,\n",
       " 1015.0,\n",
       " 1016.0,\n",
       " 1017.0,\n",
       " 1018.0,\n",
       " 1019.0,\n",
       " 1020.0,\n",
       " 1021.0,\n",
       " 1022.0,\n",
       " 1023.0,\n",
       " 1024.0,\n",
       " 1025.0,\n",
       " 1026.0,\n",
       " 1027.0,\n",
       " 1028.0,\n",
       " 1029.0,\n",
       " 1030.0,\n",
       " 1031.0,\n",
       " 1032.0,\n",
       " 1033.0,\n",
       " 1034.0,\n",
       " 1035.0,\n",
       " 1036.0,\n",
       " 1037.0,\n",
       " 1038.0,\n",
       " 1039.0,\n",
       " 1040.0,\n",
       " 1041.0,\n",
       " 1042.0,\n",
       " 1043.0,\n",
       " 1044.0,\n",
       " 1045.0,\n",
       " 1046.0,\n",
       " 1047.0,\n",
       " 1048.0,\n",
       " 1049.0,\n",
       " 1050.0,\n",
       " 1051.0,\n",
       " 1052.0,\n",
       " 1053.0,\n",
       " 1054.0,\n",
       " 1055.0,\n",
       " 1056.0,\n",
       " 1057.0,\n",
       " 1058.0,\n",
       " 1059.0,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " 1100.0,\n",
       " 1101.0,\n",
       " 1102.0,\n",
       " 1103.0,\n",
       " 1104.0,\n",
       " 1105.0,\n",
       " 1106.0,\n",
       " 1107.0,\n",
       " 1108.0,\n",
       " 1109.0,\n",
       " 1110.0,\n",
       " 1111.0,\n",
       " 1112.0,\n",
       " 1113.0,\n",
       " 1114.0,\n",
       " 1115.0,\n",
       " 1116.0,\n",
       " 1117.0,\n",
       " 1118.0,\n",
       " 1119.0,\n",
       " 1120.0,\n",
       " 1121.0,\n",
       " 1122.0,\n",
       " 1123.0,\n",
       " 1124.0,\n",
       " 1125.0,\n",
       " 1126.0,\n",
       " 1127.0,\n",
       " 1128.0,\n",
       " 1129.0,\n",
       " 1130.0,\n",
       " 1131.0,\n",
       " 1132.0,\n",
       " 1133.0,\n",
       " 1134.0,\n",
       " 1135.0,\n",
       " 1136.0,\n",
       " 1137.0,\n",
       " 1138.0,\n",
       " 1139.0,\n",
       " 1140.0,\n",
       " 1141.0,\n",
       " 1142.0,\n",
       " 1143.0,\n",
       " 1144.0,\n",
       " 1145.0,\n",
       " 1146.0,\n",
       " 1147.0,\n",
       " 1148.0,\n",
       " 1149.0,\n",
       " 1150.0,\n",
       " 1151.0,\n",
       " 1152.0,\n",
       " 1153.0,\n",
       " 1154.0,\n",
       " 1155.0,\n",
       " 1156.0,\n",
       " 1157.0,\n",
       " 1158.0,\n",
       " 1159.0,\n",
       " 1200.0,\n",
       " 1201.0,\n",
       " 1202.0,\n",
       " 1203.0,\n",
       " 1204.0,\n",
       " 1205.0,\n",
       " 1206.0,\n",
       " 1207.0,\n",
       " 1208.0,\n",
       " 1209.0,\n",
       " 1210.0,\n",
       " 1211.0,\n",
       " 1212.0,\n",
       " 1213.0,\n",
       " 1214.0,\n",
       " 1215.0,\n",
       " 1216.0,\n",
       " 1217.0,\n",
       " 1218.0,\n",
       " 1219.0,\n",
       " 1220.0,\n",
       " 1221.0,\n",
       " 1222.0,\n",
       " 1223.0,\n",
       " 1224.0,\n",
       " 1225.0,\n",
       " 1226.0,\n",
       " 1227.0,\n",
       " 1228.0,\n",
       " 1229.0,\n",
       " 1230.0,\n",
       " 1231.0,\n",
       " 1232.0,\n",
       " 1233.0,\n",
       " 1234.0,\n",
       " 1235.0,\n",
       " 1236.0,\n",
       " 1237.0,\n",
       " 1238.0,\n",
       " 1239.0,\n",
       " 1240.0,\n",
       " 1241.0,\n",
       " 1242.0,\n",
       " 1243.0,\n",
       " 1244.0,\n",
       " 1245.0,\n",
       " 1246.0,\n",
       " 1247.0,\n",
       " 1248.0,\n",
       " 1249.0,\n",
       " 1250.0,\n",
       " 1251.0,\n",
       " 1252.0,\n",
       " 1253.0,\n",
       " 1254.0,\n",
       " 1255.0,\n",
       " 1256.0,\n",
       " 1257.0,\n",
       " 1258.0,\n",
       " 1259.0,\n",
       " 1300.0,\n",
       " 1301.0,\n",
       " 1302.0,\n",
       " 1303.0,\n",
       " 1304.0,\n",
       " 1305.0,\n",
       " 1306.0,\n",
       " 1307.0,\n",
       " 1308.0,\n",
       " 1309.0,\n",
       " 1310.0,\n",
       " 1311.0,\n",
       " 1312.0,\n",
       " 1313.0,\n",
       " 1314.0,\n",
       " 1315.0,\n",
       " 1316.0,\n",
       " 1317.0,\n",
       " 1318.0,\n",
       " 1319.0,\n",
       " 1320.0,\n",
       " 1321.0,\n",
       " 1322.0,\n",
       " 1323.0,\n",
       " 1324.0,\n",
       " 1325.0,\n",
       " 1326.0,\n",
       " 1327.0,\n",
       " 1328.0,\n",
       " 1329.0,\n",
       " 1330.0,\n",
       " 1331.0,\n",
       " 1332.0,\n",
       " 1333.0,\n",
       " 1334.0,\n",
       " 1335.0,\n",
       " 1336.0,\n",
       " 1337.0,\n",
       " 1338.0,\n",
       " 1339.0,\n",
       " 1340.0,\n",
       " 1341.0,\n",
       " 1342.0,\n",
       " 1343.0,\n",
       " 1344.0,\n",
       " 1345.0,\n",
       " 1346.0,\n",
       " 1347.0,\n",
       " 1348.0,\n",
       " 1349.0,\n",
       " 1350.0,\n",
       " 1351.0,\n",
       " 1352.0,\n",
       " 1353.0,\n",
       " 1354.0,\n",
       " 1355.0,\n",
       " 1356.0,\n",
       " 1357.0,\n",
       " 1358.0,\n",
       " 1359.0,\n",
       " nan,\n",
       " ...}"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "set(frame['DepTime'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "path = r'C:\\Users\\kosma\\Desktop\\2007_14col.data'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "frame = pd.read_csv(path, index_col=None, sep = ',')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>2007</th>\n",
       "      <th>1</th>\n",
       "      <th>1.1</th>\n",
       "      <th>1.2</th>\n",
       "      <th>10</th>\n",
       "      <th>738</th>\n",
       "      <th>NW</th>\n",
       "      <th>336</th>\n",
       "      <th>270</th>\n",
       "      <th>LAX</th>\n",
       "      <th>DTW</th>\n",
       "      <th>1979</th>\n",
       "      <th>0</th>\n",
       "      <th>-4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2007</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>633</td>\n",
       "      <td>US</td>\n",
       "      <td>1198</td>\n",
       "      <td>259</td>\n",
       "      <td>PHX</td>\n",
       "      <td>PHL</td>\n",
       "      <td>2075</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2007</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>510</td>\n",
       "      <td>AA</td>\n",
       "      <td>2402</td>\n",
       "      <td>162</td>\n",
       "      <td>LAX</td>\n",
       "      <td>DFW</td>\n",
       "      <td>1235</td>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2007</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>535</td>\n",
       "      <td>AA</td>\n",
       "      <td>872</td>\n",
       "      <td>187</td>\n",
       "      <td>SMF</td>\n",
       "      <td>DFW</td>\n",
       "      <td>1431</td>\n",
       "      <td>0</td>\n",
       "      <td>-3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2007</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>545</td>\n",
       "      <td>AA</td>\n",
       "      <td>530</td>\n",
       "      <td>191</td>\n",
       "      <td>SFO</td>\n",
       "      <td>DFW</td>\n",
       "      <td>1464</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2007</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>556</td>\n",
       "      <td>CO</td>\n",
       "      <td>1743</td>\n",
       "      <td>202</td>\n",
       "      <td>SFO</td>\n",
       "      <td>IAH</td>\n",
       "      <td>1635</td>\n",
       "      <td>0</td>\n",
       "      <td>-13</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7275282</th>\n",
       "      <td>2007</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>2359</td>\n",
       "      <td>616</td>\n",
       "      <td>DL</td>\n",
       "      <td>1664</td>\n",
       "      <td>256</td>\n",
       "      <td>SLC</td>\n",
       "      <td>JFK</td>\n",
       "      <td>1989</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7275283</th>\n",
       "      <td>2007</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>2359</td>\n",
       "      <td>619</td>\n",
       "      <td>B6</td>\n",
       "      <td>106</td>\n",
       "      <td>242</td>\n",
       "      <td>TUS</td>\n",
       "      <td>JFK</td>\n",
       "      <td>2136</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7275284</th>\n",
       "      <td>2007</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>2359</td>\n",
       "      <td>729</td>\n",
       "      <td>US</td>\n",
       "      <td>1734</td>\n",
       "      <td>202</td>\n",
       "      <td>LAS</td>\n",
       "      <td>ATL</td>\n",
       "      <td>1747</td>\n",
       "      <td>0</td>\n",
       "      <td>-55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7275285</th>\n",
       "      <td>2007</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>2359</td>\n",
       "      <td>756</td>\n",
       "      <td>US</td>\n",
       "      <td>219</td>\n",
       "      <td>256</td>\n",
       "      <td>LAS</td>\n",
       "      <td>EWR</td>\n",
       "      <td>2227</td>\n",
       "      <td>0</td>\n",
       "      <td>-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7275286</th>\n",
       "      <td>2007</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>2359</td>\n",
       "      <td>800</td>\n",
       "      <td>B6</td>\n",
       "      <td>86</td>\n",
       "      <td>286</td>\n",
       "      <td>SEA</td>\n",
       "      <td>JFK</td>\n",
       "      <td>2421</td>\n",
       "      <td>0</td>\n",
       "      <td>-15</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7275287 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         2007   1  1.1  1.2    10  738  NW   336  270  LAX  DTW  1979  0  -4\n",
       "0        2007   1    1    1    15  633  US  1198  259  PHX  PHL  2075  0  25\n",
       "1        2007   1    1    1    25  510  AA  2402  162  LAX  DFW  1235  0  36\n",
       "2        2007   1    1    1    30  535  AA   872  187  SMF  DFW  1431  0  -3\n",
       "3        2007   1    1    1    30  545  AA   530  191  SFO  DFW  1464  0  42\n",
       "4        2007   1    1    1    30  556  CO  1743  202  SFO  IAH  1635  0 -13\n",
       "...       ...  ..  ...  ...   ...  ...  ..   ...  ...  ...  ...   ... ..  ..\n",
       "7275282  2007  12   31    1  2359  616  DL  1664  256  SLC  JFK  1989  0   4\n",
       "7275283  2007  12   31    1  2359  619  B6   106  242  TUS  JFK  2136  0   2\n",
       "7275284  2007  12   31    1  2359  729  US  1734  202  LAS  ATL  1747  0 -55\n",
       "7275285  2007  12   31    1  2359  756  US   219  256  LAS  EWR  2227  0 -31\n",
       "7275286  2007  12   31    1  2359  800  B6    86  286  SEA  JFK  2421  0 -15\n",
       "\n",
       "[7275287 rows x 14 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "local-venv",
   "language": "python",
   "name": "local-venv"
  },
  "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.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}