IS362Week5.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "0746575f-48b1-47a1-8f30-33e18da8739f",
   "metadata": {},
   "source": [
    "<h1> IS362 Week 5 airports </h1> \n",
    "<h2>In order to see where in Carmen Sandiego these airports are I used ArcGIS from another class:\n",
    "    https://www.arcgis.com/apps/mapviewer/index.html?webmap=727d713c490a4a468bba270b228136a7 \n",
    "\n",
    "<h3> First print description of the map and a plot</h3>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "fa295da1-763c-462d-af63-f447e88dbbb3",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "SUMMARY                lat          lon          alt           tz\n",
      "count  1458.000000  1458.000000  1458.000000  1458.000000\n",
      "mean     41.648008  -103.392289  1001.415638    -6.518519\n",
      "std      10.449509    29.843118  1523.626105     1.623016\n",
      "min      19.721375  -176.646000   -54.000000   -10.000000\n",
      "25%      34.257539  -119.185652    70.250000    -8.000000\n",
      "50%      40.087722   -94.661854   473.000000    -6.000000\n",
      "75%      45.067150   -82.516717  1062.500000    -5.000000\n",
      "max      72.270833   174.113620  9078.000000     8.000000\n",
      "TOP TEN ALTITUDE       faa                              name        lat         lon   alt  tz  \\\n",
      "1304  TEX                         Telluride  37.953759 -107.908480  9078  -7   \n",
      "1340  TVL                Lake Tahoe Airport  38.893889 -119.995278  8544  -8   \n",
      "149   ASE   Aspen Pitkin County Sardy Field  39.223200 -106.869000  7820  -7   \n",
      "568   GUC          Gunnison - Crested Butte  38.533889 -106.933056  7678  -7   \n",
      "173   BCE                      Bryce Canyon  37.706444 -112.145806  7590  -7   \n",
      "122   ALS  San Luis Valley Regional Airport  37.435000 -105.866667  7539  -7   \n",
      "767   LAR          Laramie Regional Airport  41.312100 -105.675000  7284  -7   \n",
      "765   LAM                Los Alamos Airport  35.879802 -106.269415  7171  -7   \n",
      "456   EVW       Evanston-Uinta CO Burns Fld  41.164900 -111.020800  7143  -7   \n",
      "897   MMH          Mammoth Yosemite Airport  37.624049 -118.837772  7128  -8   \n",
      "\n",
      "     dst                tzone  \n",
      "1304   A       America/Denver  \n",
      "1340   A  America/Los_Angeles  \n",
      "149    A       America/Denver  \n",
      "568    A       America/Denver  \n",
      "173    A       America/Denver  \n",
      "122    A       America/Denver  \n",
      "767    A       America/Denver  \n",
      "765    A       America/Denver  \n",
      "456    A       America/Denver  \n",
      "897    A  America/Los_Angeles  \n",
      "TIMEZONE       faa                           name        lat         lon   alt  tz dst  \\\n",
      "794   LIH                          Lihue  21.975983 -159.338958   153 -10   N   \n",
      "1403  WKL              Waikoloa Heliport  19.913600 -155.864000   109 -10   N   \n",
      "587   HHI                    Wheeler Aaf  21.483500 -158.039667   837 -10   A   \n",
      "231   BSF                   Bradshaw Aaf  19.760056 -155.553717  6190 -10   A   \n",
      "884   MKK                        Molokai  21.152886 -157.096256   454 -10   N   \n",
      "...   ...                            ...        ...         ...   ...  ..  ..   \n",
      "683   IZG        Eastern Slopes Regional  43.991139  -70.947889   455  -5   A   \n",
      "658   ILN    Wilmington Airborne Airpark  39.427920  -83.792118  1077  -5   U   \n",
      "1457  ZYP                   Penn Station  40.750500  -73.993500    35  -5   A   \n",
      "942   MYF               Montgomery Field  32.475900  117.759000    17   8   A   \n",
      "396   DVT  Deer Valley Municipal Airport  33.411700  112.457000  1478   8   A   \n",
      "\n",
      "                 tzone  \n",
      "794   Pacific/Honolulu  \n",
      "1403  Pacific/Honolulu  \n",
      "587   Pacific/Honolulu  \n",
      "231   Pacific/Honolulu  \n",
      "884   Pacific/Honolulu  \n",
      "...                ...  \n",
      "683   America/New_York  \n",
      "658   America/New_York  \n",
      "1457  America/New_York  \n",
      "942     Asia/Chongqing  \n",
      "396     Asia/Chongqing  \n",
      "\n",
      "[1458 rows x 8 columns]\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "#Load CSV file. Use \"r\" for raw in front of CSV file directory.\n",
    "airports = r\"C:\\Users\\turin\\Downloads\\airports.csv\"\n",
    "#load the csv file in data frame\n",
    "df= pd.read_csv(airports)\n",
    "#See the airports with the top ten altitudes.\n",
    "print(\"SUMMARY\", df.describe())\n",
    "print(\"TOP TEN ALTITUDE\",df.nlargest(10,'alt'))\n",
    "print(\"TIMEZONE\",df.sort_values(by='tz') )"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a430f670-2f24-4674-af9a-358732e57683",
   "metadata": {},
   "source": [
    "<h1>  What is the northernmost airport in the United States?</h1>\n",
    "<h2> Referencing the map its in Alaska:  https://www.arcgis.com/apps/mapviewer/index.html?webmap=727d713c490a4a468bba270b228136a7 </h2>\n",
    "   <h3> first categorize by time zone to filter for airports in Anchorage Tzone.</h3>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "79e40382-d05f-4b49-96a1-86d94e4392f7",
   "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></th>\n",
       "      <th>tzone</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tz</th>\n",
       "      <th>tzone</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>-10</th>\n",
       "      <th>Pacific/Honolulu</th>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-9</th>\n",
       "      <th>America/Anchorage</th>\n",
       "      <td>239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">-8</th>\n",
       "      <th>America/Los_Angeles</th>\n",
       "      <td>176</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>America/Vancouver</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">-7</th>\n",
       "      <th>America/Denver</th>\n",
       "      <td>119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>America/Phoenix</th>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-6</th>\n",
       "      <th>America/Chicago</th>\n",
       "      <td>342</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-5</th>\n",
       "      <th>America/New_York</th>\n",
       "      <td>519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <th>Asia/Chongqing</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         tzone\n",
       "tz  tzone                     \n",
       "-10 Pacific/Honolulu        18\n",
       "-9  America/Anchorage      239\n",
       "-8  America/Los_Angeles    176\n",
       "    America/Vancouver        2\n",
       "-7  America/Denver         119\n",
       "    America/Phoenix         38\n",
       "-6  America/Chicago        342\n",
       "-5  America/New_York       519\n",
       " 8  Asia/Chongqing           2"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby(['tz','tzone']).agg({'tzone':'count'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "7c27fe52-9438-4374-82e8-f28c415c8606",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>faa</th>\n",
       "      <th>name</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>alt</th>\n",
       "      <th>tz</th>\n",
       "      <th>dst</th>\n",
       "      <th>tzone</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>BRW</td>\n",
       "      <td>Wiley Post Will Rogers Mem</td>\n",
       "      <td>71.285446</td>\n",
       "      <td>-156.766003</td>\n",
       "      <td>44</td>\n",
       "      <td>-9</td>\n",
       "      <td>A</td>\n",
       "      <td>America/Anchorage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>AIN</td>\n",
       "      <td>Wainwright Airport</td>\n",
       "      <td>70.638056</td>\n",
       "      <td>-159.994722</td>\n",
       "      <td>41</td>\n",
       "      <td>-9</td>\n",
       "      <td>A</td>\n",
       "      <td>America/Anchorage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>708</th>\n",
       "      <td>K03</td>\n",
       "      <td>Wainwright As</td>\n",
       "      <td>70.613378</td>\n",
       "      <td>-159.860350</td>\n",
       "      <td>35</td>\n",
       "      <td>-9</td>\n",
       "      <td>A</td>\n",
       "      <td>America/Anchorage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>ATK</td>\n",
       "      <td>Atqasuk Edward Burnell Sr Memorial Airport</td>\n",
       "      <td>70.467300</td>\n",
       "      <td>-157.436000</td>\n",
       "      <td>96</td>\n",
       "      <td>-9</td>\n",
       "      <td>A</td>\n",
       "      <td>America/Anchorage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1363</th>\n",
       "      <td>UUK</td>\n",
       "      <td>Ugnu-Kuparuk Airport</td>\n",
       "      <td>70.330833</td>\n",
       "      <td>-149.597500</td>\n",
       "      <td>67</td>\n",
       "      <td>-9</td>\n",
       "      <td>A</td>\n",
       "      <td>America/Anchorage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>982</th>\n",
       "      <td>NUI</td>\n",
       "      <td>Nuiqsut Airport</td>\n",
       "      <td>70.210000</td>\n",
       "      <td>-151.005556</td>\n",
       "      <td>38</td>\n",
       "      <td>-9</td>\n",
       "      <td>A</td>\n",
       "      <td>America/Anchorage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1197</th>\n",
       "      <td>SCC</td>\n",
       "      <td>Deadhorse</td>\n",
       "      <td>70.194750</td>\n",
       "      <td>-148.465167</td>\n",
       "      <td>64</td>\n",
       "      <td>-9</td>\n",
       "      <td>A</td>\n",
       "      <td>America/Anchorage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>BTI</td>\n",
       "      <td>Barter Island Lrrs</td>\n",
       "      <td>70.133989</td>\n",
       "      <td>-143.581867</td>\n",
       "      <td>2</td>\n",
       "      <td>-9</td>\n",
       "      <td>A</td>\n",
       "      <td>America/Anchorage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1084</th>\n",
       "      <td>PIZ</td>\n",
       "      <td>Point Lay Lrrs</td>\n",
       "      <td>69.732875</td>\n",
       "      <td>-163.005342</td>\n",
       "      <td>25</td>\n",
       "      <td>-9</td>\n",
       "      <td>A</td>\n",
       "      <td>America/Anchorage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>824</th>\n",
       "      <td>LUR</td>\n",
       "      <td>Cape Lisburne Lrrs</td>\n",
       "      <td>68.875133</td>\n",
       "      <td>-166.110022</td>\n",
       "      <td>12</td>\n",
       "      <td>-9</td>\n",
       "      <td>A</td>\n",
       "      <td>America/Anchorage</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      faa                                        name        lat         lon  \\\n",
       "230   BRW                  Wiley Post Will Rogers Mem  71.285446 -156.766003   \n",
       "110   AIN                          Wainwright Airport  70.638056 -159.994722   \n",
       "708   K03                               Wainwright As  70.613378 -159.860350   \n",
       "152   ATK  Atqasuk Edward Burnell Sr Memorial Airport  70.467300 -157.436000   \n",
       "1363  UUK                        Ugnu-Kuparuk Airport  70.330833 -149.597500   \n",
       "982   NUI                             Nuiqsut Airport  70.210000 -151.005556   \n",
       "1197  SCC                                   Deadhorse  70.194750 -148.465167   \n",
       "232   BTI                          Barter Island Lrrs  70.133989 -143.581867   \n",
       "1084  PIZ                              Point Lay Lrrs  69.732875 -163.005342   \n",
       "824   LUR                          Cape Lisburne Lrrs  68.875133 -166.110022   \n",
       "\n",
       "      alt  tz dst              tzone  \n",
       "230    44  -9   A  America/Anchorage  \n",
       "110    41  -9   A  America/Anchorage  \n",
       "708    35  -9   A  America/Anchorage  \n",
       "152    96  -9   A  America/Anchorage  \n",
       "1363   67  -9   A  America/Anchorage  \n",
       "982    38  -9   A  America/Anchorage  \n",
       "1197   64  -9   A  America/Anchorage  \n",
       "232     2  -9   A  America/Anchorage  \n",
       "1084   25  -9   A  America/Anchorage  \n",
       "824    12  -9   A  America/Anchorage  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Show airports in Alaska Time zone\n",
    "df.loc[(df['tz'] == -9)].nlargest(10,'lat')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9ddeb4dd-bc9d-4735-b992-136e58a69c1b",
   "metadata": {},
   "source": [
    "<h1> The Northernmost airport in the US is Wiley Post Will Rogers Mem </h1>\n",
    "\n",
    "<h4> Note just using the .nlargest for 'lat' does not show this result (Dillant Hopkins airport) But using the map and time zone filter shows the northern most airport. ANother way to find this is using standard deviation to note that largest latitude may not mean northern most airport in the US </h4> "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "bfbefa7a-d186-4d32-b2d6-95299a86b804",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>faa</th>\n",
       "      <th>name</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>alt</th>\n",
       "      <th>tz</th>\n",
       "      <th>dst</th>\n",
       "      <th>tzone</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>BRW</td>\n",
       "      <td>Wiley Post Will Rogers Mem</td>\n",
       "      <td>71.285446</td>\n",
       "      <td>-156.766003</td>\n",
       "      <td>44</td>\n",
       "      <td>-9</td>\n",
       "      <td>A</td>\n",
       "      <td>America/Anchorage</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     faa                        name        lat         lon  alt  tz dst  \\\n",
       "230  BRW  Wiley Post Will Rogers Mem  71.285446 -156.766003   44  -9   A   \n",
       "\n",
       "                 tzone  \n",
       "230  America/Anchorage  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Show northern most airport \n",
    "df.loc[(df['tz'] == -9)].nlargest(1,'lat')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2d1d0e19-ea94-46a4-b663-1411d0460f8b",
   "metadata": {},
   "source": [
    "<h1> What is the Easternmost airport in the US</h1> \n",
    "\n",
    "<h3> It is debatable what is meant easternmost airport in United States in reference to what?</h3> \n",
    "\n",
    "While North has the north pole and south the south pole, east and west depends on what latitude and longitude is defined as the center of reference. Since the question states center of the United States, the assumption is the center of the United States is the referenced base map, and not the global map. \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "62279889-2499-445f-acea-79486036b12c",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>faa</th>\n",
       "      <th>name</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>alt</th>\n",
       "      <th>tz</th>\n",
       "      <th>dst</th>\n",
       "      <th>tzone</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>BGR</td>\n",
       "      <td>Bangor Intl</td>\n",
       "      <td>44.807444</td>\n",
       "      <td>-68.828139</td>\n",
       "      <td>192</td>\n",
       "      <td>-5</td>\n",
       "      <td>A</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>BHB</td>\n",
       "      <td>Hancock County - Bar Harbor</td>\n",
       "      <td>44.449769</td>\n",
       "      <td>-68.361565</td>\n",
       "      <td>83</td>\n",
       "      <td>-5</td>\n",
       "      <td>A</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>CAR</td>\n",
       "      <td>Caribou Muni</td>\n",
       "      <td>46.871500</td>\n",
       "      <td>-68.017917</td>\n",
       "      <td>626</td>\n",
       "      <td>-5</td>\n",
       "      <td>A</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>444</th>\n",
       "      <td>EPM</td>\n",
       "      <td>Eastport Municipal Airport</td>\n",
       "      <td>44.910111</td>\n",
       "      <td>-67.012694</td>\n",
       "      <td>45</td>\n",
       "      <td>-5</td>\n",
       "      <td>A</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>624</th>\n",
       "      <td>HUL</td>\n",
       "      <td>Houlton Intl</td>\n",
       "      <td>46.123083</td>\n",
       "      <td>-67.792056</td>\n",
       "      <td>489</td>\n",
       "      <td>-5</td>\n",
       "      <td>A</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>856</th>\n",
       "      <td>ME5</td>\n",
       "      <td>Banks Airport</td>\n",
       "      <td>44.165389</td>\n",
       "      <td>-68.428167</td>\n",
       "      <td>100</td>\n",
       "      <td>-5</td>\n",
       "      <td>A</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>894</th>\n",
       "      <td>MLT</td>\n",
       "      <td>Millinocket Muni</td>\n",
       "      <td>45.647836</td>\n",
       "      <td>-68.685561</td>\n",
       "      <td>408</td>\n",
       "      <td>-5</td>\n",
       "      <td>A</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1101</th>\n",
       "      <td>PQI</td>\n",
       "      <td>Northern Maine Rgnl At Presque Isle</td>\n",
       "      <td>46.688958</td>\n",
       "      <td>-68.044797</td>\n",
       "      <td>534</td>\n",
       "      <td>-5</td>\n",
       "      <td>A</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1398</th>\n",
       "      <td>WFK</td>\n",
       "      <td>Northern Aroostook Regional Airport</td>\n",
       "      <td>47.285556</td>\n",
       "      <td>-68.312778</td>\n",
       "      <td>988</td>\n",
       "      <td>-5</td>\n",
       "      <td>A</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      faa                                 name        lat        lon  alt  tz  \\\n",
       "191   BGR                          Bangor Intl  44.807444 -68.828139  192  -5   \n",
       "192   BHB          Hancock County - Bar Harbor  44.449769 -68.361565   83  -5   \n",
       "259   CAR                         Caribou Muni  46.871500 -68.017917  626  -5   \n",
       "444   EPM           Eastport Municipal Airport  44.910111 -67.012694   45  -5   \n",
       "624   HUL                         Houlton Intl  46.123083 -67.792056  489  -5   \n",
       "856   ME5                        Banks Airport  44.165389 -68.428167  100  -5   \n",
       "894   MLT                     Millinocket Muni  45.647836 -68.685561  408  -5   \n",
       "1101  PQI  Northern Maine Rgnl At Presque Isle  46.688958 -68.044797  534  -5   \n",
       "1398  WFK  Northern Aroostook Regional Airport  47.285556 -68.312778  988  -5   \n",
       "\n",
       "     dst             tzone  \n",
       "191    A  America/New_York  \n",
       "192    A  America/New_York  \n",
       "259    A  America/New_York  \n",
       "444    A  America/New_York  \n",
       "624    A  America/New_York  \n",
       "856    A  America/New_York  \n",
       "894    A  America/New_York  \n",
       "1101   A  America/New_York  \n",
       "1398   A  America/New_York  "
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#The center of the United States map is 39.82844474413941, -98.57855702371702 (Per Google Maps.)\n",
    "#Eastward of this point is going to the East Coast. This can be found in tz =-5.  \n",
    "df.loc[((df['lon'] <= -50) & (df['lon'] > -69)&(df['tz']==-5))]\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f3dd8693-6743-4406-989e-dc8a9f2161a5",
   "metadata": {},
   "source": [
    "<h1> Eastport Municipal Airport is the Easternmost airport in the US.</h1>\n",
    "\n",
    "As before just using the nlargest won't work. And exploring the ranges of latitude and longitude to find the East coast of the United States using the lat 39 and lon-98 as the center point of reference. (Assuming only the US map is being looked at, not worldwide.)\n",
    "\n",
    "We find the East coast of the US in terms of ranges for latitude and longitude. This can be easily found using tzone as America/New York. Then find the largest longitude in this subset to find the easternmost airport.   "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "25956548-259f-4882-a465-e725888ff0d9",
   "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>faa</th>\n",
       "      <th>name</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>alt</th>\n",
       "      <th>tz</th>\n",
       "      <th>dst</th>\n",
       "      <th>tzone</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>444</th>\n",
       "      <td>EPM</td>\n",
       "      <td>Eastport Municipal Airport</td>\n",
       "      <td>44.910111</td>\n",
       "      <td>-67.012694</td>\n",
       "      <td>45</td>\n",
       "      <td>-5</td>\n",
       "      <td>A</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     faa                        name        lat        lon  alt  tz dst  \\\n",
       "444  EPM  Eastport Municipal Airport  44.910111 -67.012694   45  -5   A   \n",
       "\n",
       "                tzone  \n",
       "444  America/New_York  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[((df['lon'] <= -50) & (df['lon'] > -69)&(df['tz']==-5))].nlargest(1,'lon')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "bc8c857b-faad-4f3a-b063-81726cffdc29",
   "metadata": {},
   "source": [
    "<h1> On February 12th, 2013, which New York area airport had the windiest weather?</h1>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "f4ff647c-fb69-469e-b11a-4ed143fc23e6",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>hour</th>\n",
       "      <th>temp</th>\n",
       "      <th>dewp</th>\n",
       "      <th>humid</th>\n",
       "      <th>wind_dir</th>\n",
       "      <th>wind_speed</th>\n",
       "      <th>wind_gust</th>\n",
       "      <th>precip</th>\n",
       "      <th>pressure</th>\n",
       "      <th>visib</th>\n",
       "      <th>time_hour</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>origin</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>EWR</th>\n",
       "      <td>8703</td>\n",
       "      <td>8703</td>\n",
       "      <td>8703</td>\n",
       "      <td>8703</td>\n",
       "      <td>8702</td>\n",
       "      <td>8702</td>\n",
       "      <td>8702</td>\n",
       "      <td>8447</td>\n",
       "      <td>8702</td>\n",
       "      <td>1802</td>\n",
       "      <td>8703</td>\n",
       "      <td>7768</td>\n",
       "      <td>8703</td>\n",
       "      <td>8703</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JFK</th>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8655</td>\n",
       "      <td>8703</td>\n",
       "      <td>1507</td>\n",
       "      <td>8706</td>\n",
       "      <td>7875</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LGA</th>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8553</td>\n",
       "      <td>8706</td>\n",
       "      <td>2028</td>\n",
       "      <td>8706</td>\n",
       "      <td>7743</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        year  month   day  hour  temp  dewp  humid  wind_dir  wind_speed  \\\n",
       "origin                                                                     \n",
       "EWR     8703   8703  8703  8703  8702  8702   8702      8447        8702   \n",
       "JFK     8706   8706  8706  8706  8706  8706   8706      8655        8703   \n",
       "LGA     8706   8706  8706  8706  8706  8706   8706      8553        8706   \n",
       "\n",
       "        wind_gust  precip  pressure  visib  time_hour  \n",
       "origin                                                 \n",
       "EWR          1802    8703      7768   8703       8703  \n",
       "JFK          1507    8706      7875   8706       8706  \n",
       "LGA          2028    8706      7743   8706       8706  "
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Load the weather CSV file.\n",
    "weather = r\"C:\\Users\\turin\\Downloads\\weather.csv\"\n",
    "wdf= pd.read_csv(weather)\n",
    "#Explore the connection of weather and airports dataframes.\n",
    "#print(wdf.head(),df.head())\n",
    "wdf.groupby(['origin']).count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "id": "5a9365e3-5d2e-4d41-a9c6-f2a174592f94",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>hour</th>\n",
       "      <th>temp</th>\n",
       "      <th>dewp</th>\n",
       "      <th>humid</th>\n",
       "      <th>wind_dir</th>\n",
       "      <th>wind_speed</th>\n",
       "      <th>wind_gust</th>\n",
       "      <th>...</th>\n",
       "      <th>visib</th>\n",
       "      <th>time_hour</th>\n",
       "      <th>faa</th>\n",
       "      <th>name</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>alt</th>\n",
       "      <th>tz</th>\n",
       "      <th>dst</th>\n",
       "      <th>tzone</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>origin</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>EWR</th>\n",
       "      <td>8703</td>\n",
       "      <td>8703</td>\n",
       "      <td>8703</td>\n",
       "      <td>8703</td>\n",
       "      <td>8702</td>\n",
       "      <td>8702</td>\n",
       "      <td>8702</td>\n",
       "      <td>8447</td>\n",
       "      <td>8702</td>\n",
       "      <td>1802</td>\n",
       "      <td>...</td>\n",
       "      <td>8703</td>\n",
       "      <td>8703</td>\n",
       "      <td>8703</td>\n",
       "      <td>8703</td>\n",
       "      <td>8703</td>\n",
       "      <td>8703</td>\n",
       "      <td>8703</td>\n",
       "      <td>8703</td>\n",
       "      <td>8703</td>\n",
       "      <td>8703</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JFK</th>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8655</td>\n",
       "      <td>8703</td>\n",
       "      <td>1507</td>\n",
       "      <td>...</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LGA</th>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8553</td>\n",
       "      <td>8706</td>\n",
       "      <td>2028</td>\n",
       "      <td>...</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "      <td>8706</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        year  month   day  hour  temp  dewp  humid  wind_dir  wind_speed  \\\n",
       "origin                                                                     \n",
       "EWR     8703   8703  8703  8703  8702  8702   8702      8447        8702   \n",
       "JFK     8706   8706  8706  8706  8706  8706   8706      8655        8703   \n",
       "LGA     8706   8706  8706  8706  8706  8706   8706      8553        8706   \n",
       "\n",
       "        wind_gust  ...  visib  time_hour   faa  name   lat   lon   alt    tz  \\\n",
       "origin             ...                                                         \n",
       "EWR          1802  ...   8703       8703  8703  8703  8703  8703  8703  8703   \n",
       "JFK          1507  ...   8706       8706  8706  8706  8706  8706  8706  8706   \n",
       "LGA          2028  ...   8706       8706  8706  8706  8706  8706  8706  8706   \n",
       "\n",
       "         dst  tzone  \n",
       "origin               \n",
       "EWR     8703   8703  \n",
       "JFK     8706   8706  \n",
       "LGA     8706   8706  \n",
       "\n",
       "[3 rows x 22 columns]"
      ]
     },
     "execution_count": 89,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#The only matching column is origin from Weather table and faa from airports table.\n",
    "#Since weather.csv only has NYC airports, filter airports to show only these airports.\n",
    "nyairports= df.query('faa == [\"EWR\", \"JFK\", \"LGA\"]') \n",
    "#use merge to combine the airports and weather table\n",
    "wdf.rename(columns = {'origin ':'faa'}, inplace = True)\n",
    "#This took a long time and lot of adjustments to get working.\n",
    "weatherairports= wdf.merge(nyairports, left_on='origin',right_on='faa')\n",
    "weatherairports.groupby(['origin']).count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "id": "2cd9e486-9c23-4098-8ee9-df970198e20a",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>origin</th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>hour</th>\n",
       "      <th>temp</th>\n",
       "      <th>dewp</th>\n",
       "      <th>humid</th>\n",
       "      <th>wind_dir</th>\n",
       "      <th>wind_speed</th>\n",
       "      <th>...</th>\n",
       "      <th>visib</th>\n",
       "      <th>time_hour</th>\n",
       "      <th>faa</th>\n",
       "      <th>name</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>alt</th>\n",
       "      <th>tz</th>\n",
       "      <th>dst</th>\n",
       "      <th>tzone</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1006</th>\n",
       "      <td>EWR</td>\n",
       "      <td>2013</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>39.92</td>\n",
       "      <td>39.02</td>\n",
       "      <td>96.55</td>\n",
       "      <td>240.0</td>\n",
       "      <td>6.90468</td>\n",
       "      <td>...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2013-02-12T05:00:00Z</td>\n",
       "      <td>EWR</td>\n",
       "      <td>Newark Liberty Intl</td>\n",
       "      <td>40.692500</td>\n",
       "      <td>-74.168667</td>\n",
       "      <td>18</td>\n",
       "      <td>-5</td>\n",
       "      <td>A</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1007</th>\n",
       "      <td>EWR</td>\n",
       "      <td>2013</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>39.92</td>\n",
       "      <td>37.94</td>\n",
       "      <td>92.56</td>\n",
       "      <td>250.0</td>\n",
       "      <td>9.20624</td>\n",
       "      <td>...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2013-02-12T06:00:00Z</td>\n",
       "      <td>EWR</td>\n",
       "      <td>Newark Liberty Intl</td>\n",
       "      <td>40.692500</td>\n",
       "      <td>-74.168667</td>\n",
       "      <td>18</td>\n",
       "      <td>-5</td>\n",
       "      <td>A</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1008</th>\n",
       "      <td>EWR</td>\n",
       "      <td>2013</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>39.92</td>\n",
       "      <td>28.04</td>\n",
       "      <td>62.21</td>\n",
       "      <td>270.0</td>\n",
       "      <td>20.71404</td>\n",
       "      <td>...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2013-02-12T07:00:00Z</td>\n",
       "      <td>EWR</td>\n",
       "      <td>Newark Liberty Intl</td>\n",
       "      <td>40.692500</td>\n",
       "      <td>-74.168667</td>\n",
       "      <td>18</td>\n",
       "      <td>-5</td>\n",
       "      <td>A</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1009</th>\n",
       "      <td>EWR</td>\n",
       "      <td>2013</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>39.02</td>\n",
       "      <td>26.96</td>\n",
       "      <td>61.63</td>\n",
       "      <td>260.0</td>\n",
       "      <td>1048.36058</td>\n",
       "      <td>...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2013-02-12T08:00:00Z</td>\n",
       "      <td>EWR</td>\n",
       "      <td>Newark Liberty Intl</td>\n",
       "      <td>40.692500</td>\n",
       "      <td>-74.168667</td>\n",
       "      <td>18</td>\n",
       "      <td>-5</td>\n",
       "      <td>A</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1010</th>\n",
       "      <td>EWR</td>\n",
       "      <td>2013</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>39.02</td>\n",
       "      <td>26.96</td>\n",
       "      <td>64.29</td>\n",
       "      <td>280.0</td>\n",
       "      <td>12.65858</td>\n",
       "      <td>...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2013-02-12T09:00:00Z</td>\n",
       "      <td>EWR</td>\n",
       "      <td>Newark Liberty Intl</td>\n",
       "      <td>40.692500</td>\n",
       "      <td>-74.168667</td>\n",
       "      <td>18</td>\n",
       "      <td>-5</td>\n",
       "      <td>A</td>\n",
       "      <td>America/New_York</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>18434</th>\n",
       "      <td>LGA</td>\n",
       "      <td>2013</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>19</td>\n",
       "      <td>41.00</td>\n",
       "      <td>21.92</td>\n",
       "      <td>46.23</td>\n",
       "      <td>260.0</td>\n",
       "      <td>14.96014</td>\n",
       "      <td>...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2013-02-13T00:00:00Z</td>\n",
       "      <td>LGA</td>\n",
       "      <td>La Guardia</td>\n",
       "      <td>40.777245</td>\n",
       "      <td>-73.872608</td>\n",
       "      <td>22</td>\n",
       "      <td>-5</td>\n",
       "      <td>A</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18435</th>\n",
       "      <td>LGA</td>\n",
       "      <td>2013</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>20</td>\n",
       "      <td>39.92</td>\n",
       "      <td>23.00</td>\n",
       "      <td>50.46</td>\n",
       "      <td>290.0</td>\n",
       "      <td>10.35702</td>\n",
       "      <td>...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2013-02-13T01:00:00Z</td>\n",
       "      <td>LGA</td>\n",
       "      <td>La Guardia</td>\n",
       "      <td>40.777245</td>\n",
       "      <td>-73.872608</td>\n",
       "      <td>22</td>\n",
       "      <td>-5</td>\n",
       "      <td>A</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18436</th>\n",
       "      <td>LGA</td>\n",
       "      <td>2013</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>21</td>\n",
       "      <td>39.02</td>\n",
       "      <td>21.92</td>\n",
       "      <td>49.93</td>\n",
       "      <td>310.0</td>\n",
       "      <td>10.35702</td>\n",
       "      <td>...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2013-02-13T02:00:00Z</td>\n",
       "      <td>LGA</td>\n",
       "      <td>La Guardia</td>\n",
       "      <td>40.777245</td>\n",
       "      <td>-73.872608</td>\n",
       "      <td>22</td>\n",
       "      <td>-5</td>\n",
       "      <td>A</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18437</th>\n",
       "      <td>LGA</td>\n",
       "      <td>2013</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>22</td>\n",
       "      <td>39.02</td>\n",
       "      <td>23.00</td>\n",
       "      <td>52.26</td>\n",
       "      <td>310.0</td>\n",
       "      <td>11.50780</td>\n",
       "      <td>...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2013-02-13T03:00:00Z</td>\n",
       "      <td>LGA</td>\n",
       "      <td>La Guardia</td>\n",
       "      <td>40.777245</td>\n",
       "      <td>-73.872608</td>\n",
       "      <td>22</td>\n",
       "      <td>-5</td>\n",
       "      <td>A</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18438</th>\n",
       "      <td>LGA</td>\n",
       "      <td>2013</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>23</td>\n",
       "      <td>37.94</td>\n",
       "      <td>23.00</td>\n",
       "      <td>54.51</td>\n",
       "      <td>300.0</td>\n",
       "      <td>9.20624</td>\n",
       "      <td>...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2013-02-13T04:00:00Z</td>\n",
       "      <td>LGA</td>\n",
       "      <td>La Guardia</td>\n",
       "      <td>40.777245</td>\n",
       "      <td>-73.872608</td>\n",
       "      <td>22</td>\n",
       "      <td>-5</td>\n",
       "      <td>A</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>72 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      origin  year  month  day  hour   temp   dewp  humid  wind_dir  \\\n",
       "1006     EWR  2013      2   12     0  39.92  39.02  96.55     240.0   \n",
       "1007     EWR  2013      2   12     1  39.92  37.94  92.56     250.0   \n",
       "1008     EWR  2013      2   12     2  39.92  28.04  62.21     270.0   \n",
       "1009     EWR  2013      2   12     3  39.02  26.96  61.63     260.0   \n",
       "1010     EWR  2013      2   12     4  39.02  26.96  64.29     280.0   \n",
       "...      ...   ...    ...  ...   ...    ...    ...    ...       ...   \n",
       "18434    LGA  2013      2   12    19  41.00  21.92  46.23     260.0   \n",
       "18435    LGA  2013      2   12    20  39.92  23.00  50.46     290.0   \n",
       "18436    LGA  2013      2   12    21  39.02  21.92  49.93     310.0   \n",
       "18437    LGA  2013      2   12    22  39.02  23.00  52.26     310.0   \n",
       "18438    LGA  2013      2   12    23  37.94  23.00  54.51     300.0   \n",
       "\n",
       "       wind_speed  ...  visib             time_hour  faa                 name  \\\n",
       "1006      6.90468  ...   10.0  2013-02-12T05:00:00Z  EWR  Newark Liberty Intl   \n",
       "1007      9.20624  ...   10.0  2013-02-12T06:00:00Z  EWR  Newark Liberty Intl   \n",
       "1008     20.71404  ...   10.0  2013-02-12T07:00:00Z  EWR  Newark Liberty Intl   \n",
       "1009   1048.36058  ...   10.0  2013-02-12T08:00:00Z  EWR  Newark Liberty Intl   \n",
       "1010     12.65858  ...   10.0  2013-02-12T09:00:00Z  EWR  Newark Liberty Intl   \n",
       "...           ...  ...    ...                   ...  ...                  ...   \n",
       "18434    14.96014  ...   10.0  2013-02-13T00:00:00Z  LGA           La Guardia   \n",
       "18435    10.35702  ...   10.0  2013-02-13T01:00:00Z  LGA           La Guardia   \n",
       "18436    10.35702  ...   10.0  2013-02-13T02:00:00Z  LGA           La Guardia   \n",
       "18437    11.50780  ...   10.0  2013-02-13T03:00:00Z  LGA           La Guardia   \n",
       "18438     9.20624  ...   10.0  2013-02-13T04:00:00Z  LGA           La Guardia   \n",
       "\n",
       "             lat        lon alt  tz  dst             tzone  \n",
       "1006   40.692500 -74.168667  18  -5    A  America/New_York  \n",
       "1007   40.692500 -74.168667  18  -5    A  America/New_York  \n",
       "1008   40.692500 -74.168667  18  -5    A  America/New_York  \n",
       "1009   40.692500 -74.168667  18  -5    A  America/New_York  \n",
       "1010   40.692500 -74.168667  18  -5    A  America/New_York  \n",
       "...          ...        ...  ..  ..  ...               ...  \n",
       "18434  40.777245 -73.872608  22  -5    A  America/New_York  \n",
       "18435  40.777245 -73.872608  22  -5    A  America/New_York  \n",
       "18436  40.777245 -73.872608  22  -5    A  America/New_York  \n",
       "18437  40.777245 -73.872608  22  -5    A  America/New_York  \n",
       "18438  40.777245 -73.872608  22  -5    A  America/New_York  \n",
       "\n",
       "[72 rows x 23 columns]"
      ]
     },
     "execution_count": 96,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Find the weather at the three airports (EWR, JFK, LGA) on the date of February 12, 2013.\n",
    "windynyc=weatherairports.loc[(weatherairports['month']==2) & (weatherairports['day']==12) & (weatherairports['year']==2013)]\n",
    "windynyc"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "656e735d-f00b-41cd-a9b5-d3c0a9ec6e35",
   "metadata": {},
   "source": [
    "<h1> The windiest airport on February 12, 2013 in NY was Newark Liberty Airport</h1>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "id": "bb7c12c3-4cb3-45ee-925d-517f246d878b",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>origin</th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>hour</th>\n",
       "      <th>temp</th>\n",
       "      <th>dewp</th>\n",
       "      <th>humid</th>\n",
       "      <th>wind_dir</th>\n",
       "      <th>wind_speed</th>\n",
       "      <th>...</th>\n",
       "      <th>visib</th>\n",
       "      <th>time_hour</th>\n",
       "      <th>faa</th>\n",
       "      <th>name</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>alt</th>\n",
       "      <th>tz</th>\n",
       "      <th>dst</th>\n",
       "      <th>tzone</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1009</th>\n",
       "      <td>EWR</td>\n",
       "      <td>2013</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>39.02</td>\n",
       "      <td>26.96</td>\n",
       "      <td>61.63</td>\n",
       "      <td>260.0</td>\n",
       "      <td>1048.36058</td>\n",
       "      <td>...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2013-02-12T08:00:00Z</td>\n",
       "      <td>EWR</td>\n",
       "      <td>Newark Liberty Intl</td>\n",
       "      <td>40.6925</td>\n",
       "      <td>-74.168667</td>\n",
       "      <td>18</td>\n",
       "      <td>-5</td>\n",
       "      <td>A</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     origin  year  month  day  hour   temp   dewp  humid  wind_dir  \\\n",
       "1009    EWR  2013      2   12     3  39.02  26.96  61.63     260.0   \n",
       "\n",
       "      wind_speed  ...  visib             time_hour  faa                 name  \\\n",
       "1009  1048.36058  ...   10.0  2013-02-12T08:00:00Z  EWR  Newark Liberty Intl   \n",
       "\n",
       "          lat        lon alt  tz  dst             tzone  \n",
       "1009  40.6925 -74.168667  18  -5    A  America/New_York  \n",
       "\n",
       "[1 rows x 23 columns]"
      ]
     },
     "execution_count": 105,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "windynyc.nlargest(1,'wind_speed') "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f1f0a761-7b30-4114-81ec-5b831398a8f2",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.11.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}