EDA on Weather.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "e9209e98",
   "metadata": {},
   "source": [
    "# <font color=hotpink> Exploratory Data Analysis </font>"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "73c0b019",
   "metadata": {},
   "source": [
    "## Instructions\n",
    "    - The data required for this task has been provided in the file 'data.csv'\n",
    "    - Read the questions provided for each cell and assign your answers to respective variables provided in the following cell.\n",
    "    - If answers are floating point numbers round of updo two floating point after the decimal\n",
    "    - For example 10.546 should be read as 10.55, 10.544 as 10.54 and 10.1 as 10.10"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "7ce6c998",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "e0300958",
   "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>Day</th>\n",
       "      <th>Average temperature (°F)</th>\n",
       "      <th>Average humidity (%)</th>\n",
       "      <th>Average dewpoint (°F)</th>\n",
       "      <th>Average barometer (in)</th>\n",
       "      <th>Average windspeed (mph)</th>\n",
       "      <th>Average gustspeed (mph)</th>\n",
       "      <th>Average direction (°deg)</th>\n",
       "      <th>Rainfall for month (in)</th>\n",
       "      <th>Rainfall for year (in)</th>\n",
       "      <th>Maximum rain per minute</th>\n",
       "      <th>Maximum temperature (°F)</th>\n",
       "      <th>Minimum temperature (°F)</th>\n",
       "      <th>Maximum humidity (%)</th>\n",
       "      <th>Minimum humidity (%)</th>\n",
       "      <th>Maximum pressure</th>\n",
       "      <th>Minimum pressure</th>\n",
       "      <th>Maximum windspeed (mph)</th>\n",
       "      <th>Maximum gust speed (mph)</th>\n",
       "      <th>Maximum heat index (°F)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2009-01-01</td>\n",
       "      <td>37.8</td>\n",
       "      <td>35</td>\n",
       "      <td>12.7</td>\n",
       "      <td>29.7</td>\n",
       "      <td>26.4</td>\n",
       "      <td>36.8</td>\n",
       "      <td>274</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>40.1</td>\n",
       "      <td>34.5</td>\n",
       "      <td>44</td>\n",
       "      <td>27</td>\n",
       "      <td>29.762</td>\n",
       "      <td>29.596</td>\n",
       "      <td>41.4</td>\n",
       "      <td>59.0</td>\n",
       "      <td>40.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2009-01-02</td>\n",
       "      <td>43.2</td>\n",
       "      <td>32</td>\n",
       "      <td>14.7</td>\n",
       "      <td>29.5</td>\n",
       "      <td>12.8</td>\n",
       "      <td>18.0</td>\n",
       "      <td>240</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52.8</td>\n",
       "      <td>37.5</td>\n",
       "      <td>43</td>\n",
       "      <td>16</td>\n",
       "      <td>29.669</td>\n",
       "      <td>29.268</td>\n",
       "      <td>35.7</td>\n",
       "      <td>51.0</td>\n",
       "      <td>52.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2009-01-03</td>\n",
       "      <td>25.7</td>\n",
       "      <td>60</td>\n",
       "      <td>12.7</td>\n",
       "      <td>29.7</td>\n",
       "      <td>8.3</td>\n",
       "      <td>12.2</td>\n",
       "      <td>290</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>41.2</td>\n",
       "      <td>6.7</td>\n",
       "      <td>89</td>\n",
       "      <td>35</td>\n",
       "      <td>30.232</td>\n",
       "      <td>29.260</td>\n",
       "      <td>25.3</td>\n",
       "      <td>38.0</td>\n",
       "      <td>41.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2009-01-04</td>\n",
       "      <td>9.3</td>\n",
       "      <td>67</td>\n",
       "      <td>0.1</td>\n",
       "      <td>30.4</td>\n",
       "      <td>2.9</td>\n",
       "      <td>4.5</td>\n",
       "      <td>47</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.4</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>79</td>\n",
       "      <td>35</td>\n",
       "      <td>30.566</td>\n",
       "      <td>30.227</td>\n",
       "      <td>12.7</td>\n",
       "      <td>20.0</td>\n",
       "      <td>32.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2009-01-05</td>\n",
       "      <td>23.5</td>\n",
       "      <td>30</td>\n",
       "      <td>-5.3</td>\n",
       "      <td>29.9</td>\n",
       "      <td>16.7</td>\n",
       "      <td>23.1</td>\n",
       "      <td>265</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.3</td>\n",
       "      <td>15.1</td>\n",
       "      <td>56</td>\n",
       "      <td>13</td>\n",
       "      <td>30.233</td>\n",
       "      <td>29.568</td>\n",
       "      <td>38.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>32.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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3275</th>\n",
       "      <td>2018-10-24</td>\n",
       "      <td>45.9</td>\n",
       "      <td>53</td>\n",
       "      <td>27.5</td>\n",
       "      <td>29.8</td>\n",
       "      <td>2.7</td>\n",
       "      <td>4.6</td>\n",
       "      <td>282</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.86</td>\n",
       "      <td>0.0</td>\n",
       "      <td>57.3</td>\n",
       "      <td>35.9</td>\n",
       "      <td>81</td>\n",
       "      <td>23</td>\n",
       "      <td>29.947</td>\n",
       "      <td>29.710</td>\n",
       "      <td>12.7</td>\n",
       "      <td>19.6</td>\n",
       "      <td>57.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3276</th>\n",
       "      <td>2018-10-25</td>\n",
       "      <td>46.7</td>\n",
       "      <td>40</td>\n",
       "      <td>22.7</td>\n",
       "      <td>29.8</td>\n",
       "      <td>4.5</td>\n",
       "      <td>7.2</td>\n",
       "      <td>283</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.86</td>\n",
       "      <td>0.0</td>\n",
       "      <td>61.8</td>\n",
       "      <td>35.0</td>\n",
       "      <td>60</td>\n",
       "      <td>19</td>\n",
       "      <td>29.933</td>\n",
       "      <td>29.682</td>\n",
       "      <td>13.8</td>\n",
       "      <td>19.6</td>\n",
       "      <td>61.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3277</th>\n",
       "      <td>2018-10-26</td>\n",
       "      <td>48.4</td>\n",
       "      <td>35</td>\n",
       "      <td>21.6</td>\n",
       "      <td>29.8</td>\n",
       "      <td>9.7</td>\n",
       "      <td>14.4</td>\n",
       "      <td>283</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.86</td>\n",
       "      <td>0.0</td>\n",
       "      <td>58.7</td>\n",
       "      <td>42.6</td>\n",
       "      <td>48</td>\n",
       "      <td>19</td>\n",
       "      <td>29.979</td>\n",
       "      <td>29.759</td>\n",
       "      <td>20.7</td>\n",
       "      <td>31.1</td>\n",
       "      <td>58.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3278</th>\n",
       "      <td>2018-10-27</td>\n",
       "      <td>53.3</td>\n",
       "      <td>37</td>\n",
       "      <td>26.6</td>\n",
       "      <td>29.8</td>\n",
       "      <td>10.3</td>\n",
       "      <td>14.8</td>\n",
       "      <td>282</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.86</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.5</td>\n",
       "      <td>38.3</td>\n",
       "      <td>78</td>\n",
       "      <td>24</td>\n",
       "      <td>29.935</td>\n",
       "      <td>29.650</td>\n",
       "      <td>28.8</td>\n",
       "      <td>38.0</td>\n",
       "      <td>64.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3279</th>\n",
       "      <td>2018-10-28</td>\n",
       "      <td>49.4</td>\n",
       "      <td>48</td>\n",
       "      <td>25.2</td>\n",
       "      <td>29.9</td>\n",
       "      <td>5.3</td>\n",
       "      <td>7.6</td>\n",
       "      <td>282</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.86</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67.3</td>\n",
       "      <td>30.9</td>\n",
       "      <td>90</td>\n",
       "      <td>19</td>\n",
       "      <td>30.040</td>\n",
       "      <td>29.663</td>\n",
       "      <td>18.4</td>\n",
       "      <td>25.3</td>\n",
       "      <td>67.3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3280 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Day  Average temperature (°F)  Average humidity (%)  \\\n",
       "0    2009-01-01                      37.8                    35   \n",
       "1    2009-01-02                      43.2                    32   \n",
       "2    2009-01-03                      25.7                    60   \n",
       "3    2009-01-04                       9.3                    67   \n",
       "4    2009-01-05                      23.5                    30   \n",
       "...         ...                       ...                   ...   \n",
       "3275 2018-10-24                      45.9                    53   \n",
       "3276 2018-10-25                      46.7                    40   \n",
       "3277 2018-10-26                      48.4                    35   \n",
       "3278 2018-10-27                      53.3                    37   \n",
       "3279 2018-10-28                      49.4                    48   \n",
       "\n",
       "      Average dewpoint (°F)  Average barometer (in)  Average windspeed (mph)  \\\n",
       "0                      12.7                    29.7                     26.4   \n",
       "1                      14.7                    29.5                     12.8   \n",
       "2                      12.7                    29.7                      8.3   \n",
       "3                       0.1                    30.4                      2.9   \n",
       "4                      -5.3                    29.9                     16.7   \n",
       "...                     ...                     ...                      ...   \n",
       "3275                   27.5                    29.8                      2.7   \n",
       "3276                   22.7                    29.8                      4.5   \n",
       "3277                   21.6                    29.8                      9.7   \n",
       "3278                   26.6                    29.8                     10.3   \n",
       "3279                   25.2                    29.9                      5.3   \n",
       "\n",
       "      Average gustspeed (mph)  Average direction (°deg)  \\\n",
       "0                        36.8                       274   \n",
       "1                        18.0                       240   \n",
       "2                        12.2                       290   \n",
       "3                         4.5                        47   \n",
       "4                        23.1                       265   \n",
       "...                       ...                       ...   \n",
       "3275                      4.6                       282   \n",
       "3276                      7.2                       283   \n",
       "3277                     14.4                       283   \n",
       "3278                     14.8                       282   \n",
       "3279                      7.6                       282   \n",
       "\n",
       "      Rainfall for month (in)  Rainfall for year (in)  \\\n",
       "0                        0.00                    0.00   \n",
       "1                        0.00                    0.00   \n",
       "2                        0.00                    0.00   \n",
       "3                        0.00                    0.00   \n",
       "4                        0.00                    0.00   \n",
       "...                       ...                     ...   \n",
       "3275                     0.85                    6.86   \n",
       "3276                     0.85                    6.86   \n",
       "3277                     0.85                    6.86   \n",
       "3278                     0.85                    6.86   \n",
       "3279                     0.85                    6.86   \n",
       "\n",
       "      Maximum rain per minute   Maximum temperature (°F)  \\\n",
       "0                          0.0                      40.1   \n",
       "1                          0.0                      52.8   \n",
       "2                          0.0                      41.2   \n",
       "3                          0.0                      19.4   \n",
       "4                          0.0                      30.3   \n",
       "...                        ...                       ...   \n",
       "3275                       0.0                      57.3   \n",
       "3276                       0.0                      61.8   \n",
       "3277                       0.0                      58.7   \n",
       "3278                       0.0                      64.5   \n",
       "3279                       0.0                      67.3   \n",
       "\n",
       "      Minimum temperature (°F)  Maximum humidity (%)  Minimum humidity (%)  \\\n",
       "0                         34.5                    44                    27   \n",
       "1                         37.5                    43                    16   \n",
       "2                          6.7                    89                    35   \n",
       "3                         -0.0                    79                    35   \n",
       "4                         15.1                    56                    13   \n",
       "...                        ...                   ...                   ...   \n",
       "3275                      35.9                    81                    23   \n",
       "3276                      35.0                    60                    19   \n",
       "3277                      42.6                    48                    19   \n",
       "3278                      38.3                    78                    24   \n",
       "3279                      30.9                    90                    19   \n",
       "\n",
       "      Maximum pressure   Minimum pressure   Maximum windspeed (mph)  \\\n",
       "0                29.762             29.596                     41.4   \n",
       "1                29.669             29.268                     35.7   \n",
       "2                30.232             29.260                     25.3   \n",
       "3                30.566             30.227                     12.7   \n",
       "4                30.233             29.568                     38.0   \n",
       "...                 ...                ...                      ...   \n",
       "3275             29.947             29.710                     12.7   \n",
       "3276             29.933             29.682                     13.8   \n",
       "3277             29.979             29.759                     20.7   \n",
       "3278             29.935             29.650                     28.8   \n",
       "3279             30.040             29.663                     18.4   \n",
       "\n",
       "      Maximum gust speed (mph)  Maximum heat index (°F)  \n",
       "0                         59.0                     40.1  \n",
       "1                         51.0                     52.8  \n",
       "2                         38.0                     41.2  \n",
       "3                         20.0                     32.0  \n",
       "4                         53.0                     32.0  \n",
       "...                        ...                      ...  \n",
       "3275                      19.6                     57.2  \n",
       "3276                      19.6                     61.8  \n",
       "3277                      31.1                     58.7  \n",
       "3278                      38.0                     64.5  \n",
       "3279                      25.3                     67.3  \n",
       "\n",
       "[3280 rows x 20 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"./datasets/data_weather.csv\", parse_dates = [\"Day\"], dayfirst = True)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "71ed1b38",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 3280 entries, 0 to 3279\n",
      "Data columns (total 20 columns):\n",
      " #   Column                    Non-Null Count  Dtype         \n",
      "---  ------                    --------------  -----         \n",
      " 0   Day                       3280 non-null   datetime64[ns]\n",
      " 1   Average temperature (°F)  3280 non-null   float64       \n",
      " 2   Average humidity (%)      3280 non-null   int64         \n",
      " 3   Average dewpoint (°F)     3280 non-null   float64       \n",
      " 4   Average barometer (in)    3280 non-null   float64       \n",
      " 5   Average windspeed (mph)   3280 non-null   float64       \n",
      " 6   Average gustspeed (mph)   3280 non-null   float64       \n",
      " 7   Average direction (°deg)  3280 non-null   int64         \n",
      " 8   Rainfall for month (in)   3280 non-null   float64       \n",
      " 9   Rainfall for year (in)    3280 non-null   float64       \n",
      " 10  Maximum rain per minute   3280 non-null   float64       \n",
      " 11  Maximum temperature (°F)  3280 non-null   float64       \n",
      " 12  Minimum temperature (°F)  3280 non-null   float64       \n",
      " 13  Maximum humidity (%)      3280 non-null   int64         \n",
      " 14  Minimum humidity (%)      3280 non-null   int64         \n",
      " 15  Maximum pressure          3280 non-null   float64       \n",
      " 16  Minimum pressure          3280 non-null   float64       \n",
      " 17  Maximum windspeed (mph)   3280 non-null   float64       \n",
      " 18  Maximum gust speed (mph)  3280 non-null   float64       \n",
      " 19  Maximum heat index (°F)   3280 non-null   float64       \n",
      "dtypes: datetime64[ns](1), float64(15), int64(4)\n",
      "memory usage: 512.6 KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "6e95ad44",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Day                         0\n",
       "Average temperature (°F)    0\n",
       "Average humidity (%)        0\n",
       "Average dewpoint (°F)       0\n",
       "Average barometer (in)      0\n",
       "Average windspeed (mph)     0\n",
       "Average gustspeed (mph)     0\n",
       "Average direction (°deg)    0\n",
       "Rainfall for month (in)     0\n",
       "Rainfall for year (in)      0\n",
       "Maximum rain per minute     0\n",
       "Maximum temperature (°F)    0\n",
       "Minimum temperature (°F)    0\n",
       "Maximum humidity (%)        0\n",
       "Minimum humidity (%)        0\n",
       "Maximum pressure            0\n",
       "Minimum pressure            0\n",
       "Maximum windspeed (mph)     0\n",
       "Maximum gust speed (mph)    0\n",
       "Maximum heat index (°F)     0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e7624a97",
   "metadata": {},
   "source": [
    "### What is the standard deviation of maximum windspeed across all the days"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "29a45ce4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "13.06"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "q1 = df[\"Maximum windspeed (mph)\"].std().round(2)\n",
    "q1"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "55245579",
   "metadata": {},
   "source": [
    "### What is the difference between 50th percentile and 75th percentile of average temperature"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "ccef03ff",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([45.9, 58.1])"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np.percentile(df[\"Average temperature (°F)\"], [50, 75])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "52f025df",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "12.2"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "perc_50, perc_75 = np.percentile(df[\"Average temperature (°F)\"], [50, 75])\n",
    "q2 = round(perc_75 - perc_50, 2)\n",
    "q2"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f5c2139c",
   "metadata": {},
   "source": [
    "### What is the pearson correlation between average dew point and average temperature"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "2238f9fd",
   "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>Average dewpoint (°F)</th>\n",
       "      <th>Average temperature (°F)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Average dewpoint (°F)</th>\n",
       "      <td>1.00</td>\n",
       "      <td>0.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Average temperature (°F)</th>\n",
       "      <td>0.76</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                          Average dewpoint (°F)  Average temperature (°F)\n",
       "Average dewpoint (°F)                      1.00                      0.76\n",
       "Average temperature (°F)                   0.76                      1.00"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "corr_dew_temp = df[ [\"Average dewpoint (°F)\", \"Average temperature (°F)\"] ].corr().round(2)\n",
    "corr_dew_temp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "4f8bb3f4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.76"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "q3 = corr_dew_temp.iloc[0, 1]\n",
    "q3"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8307e19a",
   "metadata": {},
   "source": [
    "### Out of all the available records which month has the lowest average humidity.\n",
    "    - Assign your answer as month index, for example if its July index is 7"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "1ac29778",
   "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>Day</th>\n",
       "      <th>Average humidity (%)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1300</th>\n",
       "      <td>2013-01-22</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Day  Average humidity (%)\n",
       "1300 2013-01-22                     9"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_day_humidity = df[ [\"Day\", \"Average humidity (%)\"] ].nsmallest(1, \"Average humidity (%)\")\n",
    "df_day_humidity"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "b09ad788",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timestamp('2013-01-22 00:00:00')"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_day_humidity.iloc[0, 0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "99f03a98",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "q4 = df_day_humidity.iloc[0, 0].month\n",
    "q4"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5362c0d1",
   "metadata": {},
   "source": [
    "### Which month has the highest median for maximum_gust_speed out of all the available records. Also find the respective value\n",
    "    - hint: group by month"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "42653ee6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pandas.core.groupby.generic.DataFrameGroupBy object at 0x0000001B8826D450>"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "grpby_day_maxgust = df[ [\"Day\", \"Maximum gust speed (mph)\"]].groupby(by = df[\"Day\"].dt.month)\n",
    "grpby_day_maxgust"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "d8a25e42",
   "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>Maximum gust speed (mph)</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Day</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>32.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>34.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>31.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>27.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>26.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>24.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>24.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>24.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>26.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>32.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>33.4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Maximum gust speed (mph)\n",
       "Day                          \n",
       "1                        32.2\n",
       "2                        34.5\n",
       "3                        31.1\n",
       "4                        27.6\n",
       "5                        26.0\n",
       "6                        26.5\n",
       "7                        24.2\n",
       "8                        24.2\n",
       "9                        24.2\n",
       "10                       26.5\n",
       "11                       32.2\n",
       "12                       33.4"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "grpby_day_maxgust.median(numeric_only = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "8b8bb6d0",
   "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>Maximum gust speed (mph)</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Day</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>34.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Maximum gust speed (mph)\n",
       "Day                          \n",
       "2                        34.5"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "day_gust = grpby_day_maxgust.median(numeric_only = True).nlargest(1, \"Maximum gust speed (mph)\")\n",
    "day_gust"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "fd558d3f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "q5 = day_gust.index[0]\n",
    "q5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "d2df15f2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "34.5"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "q6 = day_gust.iloc[0, 0]\n",
    "q6"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6b33f517",
   "metadata": {},
   "source": [
    "###### Determine the average temperature between the months of March 2010 to May 2012 (including both the months)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "18c2a726",
   "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>Day</th>\n",
       "      <th>Average temperature (°F)</th>\n",
       "      <th>Average humidity (%)</th>\n",
       "      <th>Average dewpoint (°F)</th>\n",
       "      <th>Average barometer (in)</th>\n",
       "      <th>Average windspeed (mph)</th>\n",
       "      <th>Average gustspeed (mph)</th>\n",
       "      <th>Average direction (°deg)</th>\n",
       "      <th>Rainfall for month (in)</th>\n",
       "      <th>Rainfall for year (in)</th>\n",
       "      <th>Maximum rain per minute</th>\n",
       "      <th>Maximum temperature (°F)</th>\n",
       "      <th>Minimum temperature (°F)</th>\n",
       "      <th>Maximum humidity (%)</th>\n",
       "      <th>Minimum humidity (%)</th>\n",
       "      <th>Maximum pressure</th>\n",
       "      <th>Minimum pressure</th>\n",
       "      <th>Maximum windspeed (mph)</th>\n",
       "      <th>Maximum gust speed (mph)</th>\n",
       "      <th>Maximum heat index (°F)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>390</th>\n",
       "      <td>2010-03-01</td>\n",
       "      <td>26.1</td>\n",
       "      <td>74</td>\n",
       "      <td>18.4</td>\n",
       "      <td>30.2</td>\n",
       "      <td>2.2</td>\n",
       "      <td>3.4</td>\n",
       "      <td>53</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.59</td>\n",
       "      <td>0.01</td>\n",
       "      <td>39.1</td>\n",
       "      <td>14.3</td>\n",
       "      <td>90</td>\n",
       "      <td>40</td>\n",
       "      <td>30.375</td>\n",
       "      <td>30.086</td>\n",
       "      <td>15.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>39.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>2010-03-02</td>\n",
       "      <td>27.8</td>\n",
       "      <td>58</td>\n",
       "      <td>12.9</td>\n",
       "      <td>30.2</td>\n",
       "      <td>1.4</td>\n",
       "      <td>2.4</td>\n",
       "      <td>91</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.59</td>\n",
       "      <td>0.00</td>\n",
       "      <td>48.8</td>\n",
       "      <td>10.5</td>\n",
       "      <td>86</td>\n",
       "      <td>21</td>\n",
       "      <td>30.387</td>\n",
       "      <td>30.012</td>\n",
       "      <td>10.4</td>\n",
       "      <td>14.0</td>\n",
       "      <td>48.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>392</th>\n",
       "      <td>2010-03-03</td>\n",
       "      <td>31.4</td>\n",
       "      <td>56</td>\n",
       "      <td>15.5</td>\n",
       "      <td>30.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>6.4</td>\n",
       "      <td>315</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.59</td>\n",
       "      <td>0.00</td>\n",
       "      <td>48.3</td>\n",
       "      <td>15.4</td>\n",
       "      <td>84</td>\n",
       "      <td>23</td>\n",
       "      <td>30.180</td>\n",
       "      <td>29.942</td>\n",
       "      <td>18.4</td>\n",
       "      <td>26.0</td>\n",
       "      <td>48.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393</th>\n",
       "      <td>2010-03-04</td>\n",
       "      <td>29.9</td>\n",
       "      <td>63</td>\n",
       "      <td>17.9</td>\n",
       "      <td>30.0</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2.9</td>\n",
       "      <td>191</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.59</td>\n",
       "      <td>0.00</td>\n",
       "      <td>44.6</td>\n",
       "      <td>16.4</td>\n",
       "      <td>83</td>\n",
       "      <td>32</td>\n",
       "      <td>30.138</td>\n",
       "      <td>29.787</td>\n",
       "      <td>6.9</td>\n",
       "      <td>255.0</td>\n",
       "      <td>44.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>394</th>\n",
       "      <td>2010-03-05</td>\n",
       "      <td>29.9</td>\n",
       "      <td>59</td>\n",
       "      <td>16.3</td>\n",
       "      <td>29.9</td>\n",
       "      <td>10.1</td>\n",
       "      <td>14.2</td>\n",
       "      <td>316</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.59</td>\n",
       "      <td>0.00</td>\n",
       "      <td>36.9</td>\n",
       "      <td>20.0</td>\n",
       "      <td>85</td>\n",
       "      <td>34</td>\n",
       "      <td>29.949</td>\n",
       "      <td>29.693</td>\n",
       "      <td>24.2</td>\n",
       "      <td>36.0</td>\n",
       "      <td>36.9</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1060</th>\n",
       "      <td>2012-05-27</td>\n",
       "      <td>49.4</td>\n",
       "      <td>19</td>\n",
       "      <td>8.1</td>\n",
       "      <td>29.6</td>\n",
       "      <td>11.7</td>\n",
       "      <td>17.3</td>\n",
       "      <td>241</td>\n",
       "      <td>1.22</td>\n",
       "      <td>2.14</td>\n",
       "      <td>0.00</td>\n",
       "      <td>58.3</td>\n",
       "      <td>42.5</td>\n",
       "      <td>37</td>\n",
       "      <td>10</td>\n",
       "      <td>29.801</td>\n",
       "      <td>29.296</td>\n",
       "      <td>28.8</td>\n",
       "      <td>38.0</td>\n",
       "      <td>58.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1061</th>\n",
       "      <td>2012-05-28</td>\n",
       "      <td>52.8</td>\n",
       "      <td>23</td>\n",
       "      <td>14.6</td>\n",
       "      <td>29.8</td>\n",
       "      <td>12.6</td>\n",
       "      <td>18.4</td>\n",
       "      <td>245</td>\n",
       "      <td>1.22</td>\n",
       "      <td>2.14</td>\n",
       "      <td>0.00</td>\n",
       "      <td>65.2</td>\n",
       "      <td>43.1</td>\n",
       "      <td>37</td>\n",
       "      <td>10</td>\n",
       "      <td>29.908</td>\n",
       "      <td>29.641</td>\n",
       "      <td>29.9</td>\n",
       "      <td>43.7</td>\n",
       "      <td>71.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1062</th>\n",
       "      <td>2012-05-29</td>\n",
       "      <td>51.0</td>\n",
       "      <td>35</td>\n",
       "      <td>21.7</td>\n",
       "      <td>29.9</td>\n",
       "      <td>2.3</td>\n",
       "      <td>4.1</td>\n",
       "      <td>318</td>\n",
       "      <td>1.22</td>\n",
       "      <td>2.14</td>\n",
       "      <td>0.00</td>\n",
       "      <td>69.9</td>\n",
       "      <td>30.1</td>\n",
       "      <td>60</td>\n",
       "      <td>12</td>\n",
       "      <td>30.028</td>\n",
       "      <td>29.755</td>\n",
       "      <td>13.8</td>\n",
       "      <td>24.2</td>\n",
       "      <td>75.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1063</th>\n",
       "      <td>2012-05-30</td>\n",
       "      <td>55.2</td>\n",
       "      <td>39</td>\n",
       "      <td>26.3</td>\n",
       "      <td>29.8</td>\n",
       "      <td>4.4</td>\n",
       "      <td>7.1</td>\n",
       "      <td>286</td>\n",
       "      <td>1.22</td>\n",
       "      <td>2.14</td>\n",
       "      <td>0.00</td>\n",
       "      <td>73.5</td>\n",
       "      <td>34.1</td>\n",
       "      <td>69</td>\n",
       "      <td>13</td>\n",
       "      <td>29.884</td>\n",
       "      <td>29.669</td>\n",
       "      <td>18.4</td>\n",
       "      <td>26.5</td>\n",
       "      <td>76.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1064</th>\n",
       "      <td>2012-05-31</td>\n",
       "      <td>51.3</td>\n",
       "      <td>55</td>\n",
       "      <td>34.6</td>\n",
       "      <td>29.9</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>59</td>\n",
       "      <td>1.22</td>\n",
       "      <td>2.14</td>\n",
       "      <td>0.00</td>\n",
       "      <td>64.2</td>\n",
       "      <td>34.9</td>\n",
       "      <td>83</td>\n",
       "      <td>33</td>\n",
       "      <td>29.946</td>\n",
       "      <td>29.807</td>\n",
       "      <td>13.8</td>\n",
       "      <td>19.6</td>\n",
       "      <td>64.2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>675 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Day  Average temperature (°F)  Average humidity (%)  \\\n",
       "390  2010-03-01                      26.1                    74   \n",
       "391  2010-03-02                      27.8                    58   \n",
       "392  2010-03-03                      31.4                    56   \n",
       "393  2010-03-04                      29.9                    63   \n",
       "394  2010-03-05                      29.9                    59   \n",
       "...         ...                       ...                   ...   \n",
       "1060 2012-05-27                      49.4                    19   \n",
       "1061 2012-05-28                      52.8                    23   \n",
       "1062 2012-05-29                      51.0                    35   \n",
       "1063 2012-05-30                      55.2                    39   \n",
       "1064 2012-05-31                      51.3                    55   \n",
       "\n",
       "      Average dewpoint (°F)  Average barometer (in)  Average windspeed (mph)  \\\n",
       "390                    18.4                    30.2                      2.2   \n",
       "391                    12.9                    30.2                      1.4   \n",
       "392                    15.5                    30.0                      4.5   \n",
       "393                    17.9                    30.0                      1.6   \n",
       "394                    16.3                    29.9                     10.1   \n",
       "...                     ...                     ...                      ...   \n",
       "1060                    8.1                    29.6                     11.7   \n",
       "1061                   14.6                    29.8                     12.6   \n",
       "1062                   21.7                    29.9                      2.3   \n",
       "1063                   26.3                    29.8                      4.4   \n",
       "1064                   34.6                    29.9                      3.0   \n",
       "\n",
       "      Average gustspeed (mph)  Average direction (°deg)  \\\n",
       "390                       3.4                        53   \n",
       "391                       2.4                        91   \n",
       "392                       6.4                       315   \n",
       "393                       2.9                       191   \n",
       "394                      14.2                       316   \n",
       "...                       ...                       ...   \n",
       "1060                     17.3                       241   \n",
       "1061                     18.4                       245   \n",
       "1062                      4.1                       318   \n",
       "1063                      7.1                       286   \n",
       "1064                      4.9                        59   \n",
       "\n",
       "      Rainfall for month (in)  Rainfall for year (in)  \\\n",
       "390                      0.02                    0.59   \n",
       "391                      0.02                    0.59   \n",
       "392                      0.02                    0.59   \n",
       "393                      0.02                    0.59   \n",
       "394                      0.02                    0.59   \n",
       "...                       ...                     ...   \n",
       "1060                     1.22                    2.14   \n",
       "1061                     1.22                    2.14   \n",
       "1062                     1.22                    2.14   \n",
       "1063                     1.22                    2.14   \n",
       "1064                     1.22                    2.14   \n",
       "\n",
       "      Maximum rain per minute   Maximum temperature (°F)  \\\n",
       "390                       0.01                      39.1   \n",
       "391                       0.00                      48.8   \n",
       "392                       0.00                      48.3   \n",
       "393                       0.00                      44.6   \n",
       "394                       0.00                      36.9   \n",
       "...                        ...                       ...   \n",
       "1060                      0.00                      58.3   \n",
       "1061                      0.00                      65.2   \n",
       "1062                      0.00                      69.9   \n",
       "1063                      0.00                      73.5   \n",
       "1064                      0.00                      64.2   \n",
       "\n",
       "      Minimum temperature (°F)  Maximum humidity (%)  Minimum humidity (%)  \\\n",
       "390                       14.3                    90                    40   \n",
       "391                       10.5                    86                    21   \n",
       "392                       15.4                    84                    23   \n",
       "393                       16.4                    83                    32   \n",
       "394                       20.0                    85                    34   \n",
       "...                        ...                   ...                   ...   \n",
       "1060                      42.5                    37                    10   \n",
       "1061                      43.1                    37                    10   \n",
       "1062                      30.1                    60                    12   \n",
       "1063                      34.1                    69                    13   \n",
       "1064                      34.9                    83                    33   \n",
       "\n",
       "      Maximum pressure   Minimum pressure   Maximum windspeed (mph)  \\\n",
       "390              30.375             30.086                     15.0   \n",
       "391              30.387             30.012                     10.4   \n",
       "392              30.180             29.942                     18.4   \n",
       "393              30.138             29.787                      6.9   \n",
       "394              29.949             29.693                     24.2   \n",
       "...                 ...                ...                      ...   \n",
       "1060             29.801             29.296                     28.8   \n",
       "1061             29.908             29.641                     29.9   \n",
       "1062             30.028             29.755                     13.8   \n",
       "1063             29.884             29.669                     18.4   \n",
       "1064             29.946             29.807                     13.8   \n",
       "\n",
       "      Maximum gust speed (mph)  Maximum heat index (°F)  \n",
       "390                       22.0                     39.1  \n",
       "391                       14.0                     48.8  \n",
       "392                       26.0                     48.3  \n",
       "393                      255.0                     44.6  \n",
       "394                       36.0                     36.9  \n",
       "...                        ...                      ...  \n",
       "1060                      38.0                     58.3  \n",
       "1061                      43.7                     71.0  \n",
       "1062                      24.2                     75.6  \n",
       "1063                      26.5                     76.8  \n",
       "1064                      19.6                     64.2  \n",
       "\n",
       "[675 rows x 20 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mask = df[\"Day\"].between(pd.to_datetime(\"1st March, 2010\"), pd.to_datetime(\"31st May, 2012\"))\n",
    "df[mask]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "49e9cc24",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "45.33"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "q7 = df[mask].get(\"Average temperature (°F)\").mean().round(2)\n",
    "q7"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cfcbfe56",
   "metadata": {},
   "source": [
    "### Find the range of average temperature  on Dec 2010 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "d83e8c2b",
   "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>Day</th>\n",
       "      <th>Average temperature (°F)</th>\n",
       "      <th>Average humidity (%)</th>\n",
       "      <th>Average dewpoint (°F)</th>\n",
       "      <th>Average barometer (in)</th>\n",
       "      <th>Average windspeed (mph)</th>\n",
       "      <th>Average gustspeed (mph)</th>\n",
       "      <th>Average direction (°deg)</th>\n",
       "      <th>Rainfall for month (in)</th>\n",
       "      <th>Rainfall for year (in)</th>\n",
       "      <th>Maximum rain per minute</th>\n",
       "      <th>Maximum temperature (°F)</th>\n",
       "      <th>Minimum temperature (°F)</th>\n",
       "      <th>Maximum humidity (%)</th>\n",
       "      <th>Minimum humidity (%)</th>\n",
       "      <th>Maximum pressure</th>\n",
       "      <th>Minimum pressure</th>\n",
       "      <th>Maximum windspeed (mph)</th>\n",
       "      <th>Maximum gust speed (mph)</th>\n",
       "      <th>Maximum heat index (°F)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>662</th>\n",
       "      <td>2010-12-02</td>\n",
       "      <td>42.2</td>\n",
       "      <td>39</td>\n",
       "      <td>18.2</td>\n",
       "      <td>30.0</td>\n",
       "      <td>12.6</td>\n",
       "      <td>19.0</td>\n",
       "      <td>310</td>\n",
       "      <td>0.00</td>\n",
       "      <td>12.69</td>\n",
       "      <td>0.00</td>\n",
       "      <td>48.8</td>\n",
       "      <td>36.4</td>\n",
       "      <td>58</td>\n",
       "      <td>28</td>\n",
       "      <td>30.126</td>\n",
       "      <td>29.826</td>\n",
       "      <td>31.1</td>\n",
       "      <td>43.7</td>\n",
       "      <td>48.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>663</th>\n",
       "      <td>2010-12-03</td>\n",
       "      <td>44.8</td>\n",
       "      <td>31</td>\n",
       "      <td>15.9</td>\n",
       "      <td>29.8</td>\n",
       "      <td>13.8</td>\n",
       "      <td>17.1</td>\n",
       "      <td>301</td>\n",
       "      <td>0.00</td>\n",
       "      <td>12.69</td>\n",
       "      <td>0.00</td>\n",
       "      <td>46.2</td>\n",
       "      <td>42.3</td>\n",
       "      <td>41</td>\n",
       "      <td>28</td>\n",
       "      <td>29.851</td>\n",
       "      <td>29.802</td>\n",
       "      <td>31.1</td>\n",
       "      <td>44.9</td>\n",
       "      <td>46.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>664</th>\n",
       "      <td>2010-12-04</td>\n",
       "      <td>31.3</td>\n",
       "      <td>62</td>\n",
       "      <td>18.0</td>\n",
       "      <td>30.2</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7.9</td>\n",
       "      <td>320</td>\n",
       "      <td>0.00</td>\n",
       "      <td>12.69</td>\n",
       "      <td>0.00</td>\n",
       "      <td>46.0</td>\n",
       "      <td>21.8</td>\n",
       "      <td>89</td>\n",
       "      <td>28</td>\n",
       "      <td>30.430</td>\n",
       "      <td>29.828</td>\n",
       "      <td>16.1</td>\n",
       "      <td>20.7</td>\n",
       "      <td>46.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>665</th>\n",
       "      <td>2010-12-05</td>\n",
       "      <td>28.8</td>\n",
       "      <td>67</td>\n",
       "      <td>18.9</td>\n",
       "      <td>30.4</td>\n",
       "      <td>2.7</td>\n",
       "      <td>4.1</td>\n",
       "      <td>68</td>\n",
       "      <td>0.00</td>\n",
       "      <td>12.69</td>\n",
       "      <td>0.00</td>\n",
       "      <td>43.1</td>\n",
       "      <td>18.8</td>\n",
       "      <td>86</td>\n",
       "      <td>45</td>\n",
       "      <td>30.487</td>\n",
       "      <td>30.267</td>\n",
       "      <td>11.5</td>\n",
       "      <td>13.8</td>\n",
       "      <td>43.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>666</th>\n",
       "      <td>2010-12-06</td>\n",
       "      <td>34.3</td>\n",
       "      <td>62</td>\n",
       "      <td>21.4</td>\n",
       "      <td>30.3</td>\n",
       "      <td>4.6</td>\n",
       "      <td>7.0</td>\n",
       "      <td>318</td>\n",
       "      <td>0.00</td>\n",
       "      <td>12.69</td>\n",
       "      <td>0.00</td>\n",
       "      <td>48.1</td>\n",
       "      <td>18.1</td>\n",
       "      <td>87</td>\n",
       "      <td>27</td>\n",
       "      <td>30.465</td>\n",
       "      <td>30.008</td>\n",
       "      <td>17.3</td>\n",
       "      <td>26.5</td>\n",
       "      <td>48.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>667</th>\n",
       "      <td>2010-12-07</td>\n",
       "      <td>34.3</td>\n",
       "      <td>40</td>\n",
       "      <td>12.0</td>\n",
       "      <td>30.2</td>\n",
       "      <td>7.8</td>\n",
       "      <td>11.9</td>\n",
       "      <td>322</td>\n",
       "      <td>0.00</td>\n",
       "      <td>12.69</td>\n",
       "      <td>0.00</td>\n",
       "      <td>46.2</td>\n",
       "      <td>23.0</td>\n",
       "      <td>60</td>\n",
       "      <td>23</td>\n",
       "      <td>30.382</td>\n",
       "      <td>29.951</td>\n",
       "      <td>25.3</td>\n",
       "      <td>34.5</td>\n",
       "      <td>46.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>668</th>\n",
       "      <td>2010-12-08</td>\n",
       "      <td>40.4</td>\n",
       "      <td>26</td>\n",
       "      <td>7.4</td>\n",
       "      <td>30.1</td>\n",
       "      <td>10.6</td>\n",
       "      <td>15.5</td>\n",
       "      <td>308</td>\n",
       "      <td>0.00</td>\n",
       "      <td>12.69</td>\n",
       "      <td>0.00</td>\n",
       "      <td>49.2</td>\n",
       "      <td>23.9</td>\n",
       "      <td>41</td>\n",
       "      <td>15</td>\n",
       "      <td>30.282</td>\n",
       "      <td>29.817</td>\n",
       "      <td>26.5</td>\n",
       "      <td>36.8</td>\n",
       "      <td>49.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>669</th>\n",
       "      <td>2010-12-09</td>\n",
       "      <td>39.6</td>\n",
       "      <td>37</td>\n",
       "      <td>14.9</td>\n",
       "      <td>29.9</td>\n",
       "      <td>15.3</td>\n",
       "      <td>22.5</td>\n",
       "      <td>315</td>\n",
       "      <td>0.00</td>\n",
       "      <td>12.69</td>\n",
       "      <td>0.00</td>\n",
       "      <td>44.0</td>\n",
       "      <td>29.5</td>\n",
       "      <td>57</td>\n",
       "      <td>25</td>\n",
       "      <td>29.998</td>\n",
       "      <td>29.766</td>\n",
       "      <td>34.5</td>\n",
       "      <td>49.5</td>\n",
       "      <td>44.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>670</th>\n",
       "      <td>2010-12-10</td>\n",
       "      <td>35.9</td>\n",
       "      <td>47</td>\n",
       "      <td>17.5</td>\n",
       "      <td>29.8</td>\n",
       "      <td>10.4</td>\n",
       "      <td>16.0</td>\n",
       "      <td>321</td>\n",
       "      <td>0.00</td>\n",
       "      <td>12.69</td>\n",
       "      <td>0.00</td>\n",
       "      <td>43.4</td>\n",
       "      <td>28.1</td>\n",
       "      <td>85</td>\n",
       "      <td>32</td>\n",
       "      <td>29.998</td>\n",
       "      <td>29.645</td>\n",
       "      <td>25.3</td>\n",
       "      <td>38.0</td>\n",
       "      <td>43.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>671</th>\n",
       "      <td>2010-12-11</td>\n",
       "      <td>25.2</td>\n",
       "      <td>41</td>\n",
       "      <td>4.6</td>\n",
       "      <td>30.2</td>\n",
       "      <td>7.2</td>\n",
       "      <td>11.4</td>\n",
       "      <td>329</td>\n",
       "      <td>0.00</td>\n",
       "      <td>12.69</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>57</td>\n",
       "      <td>31</td>\n",
       "      <td>30.425</td>\n",
       "      <td>29.947</td>\n",
       "      <td>16.1</td>\n",
       "      <td>26.5</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>672</th>\n",
       "      <td>2010-12-12</td>\n",
       "      <td>34.8</td>\n",
       "      <td>50</td>\n",
       "      <td>17.4</td>\n",
       "      <td>30.2</td>\n",
       "      <td>10.4</td>\n",
       "      <td>15.5</td>\n",
       "      <td>320</td>\n",
       "      <td>0.00</td>\n",
       "      <td>12.69</td>\n",
       "      <td>0.00</td>\n",
       "      <td>46.7</td>\n",
       "      <td>16.7</td>\n",
       "      <td>66</td>\n",
       "      <td>31</td>\n",
       "      <td>30.425</td>\n",
       "      <td>29.856</td>\n",
       "      <td>28.8</td>\n",
       "      <td>46.0</td>\n",
       "      <td>46.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>673</th>\n",
       "      <td>2010-12-13</td>\n",
       "      <td>45.8</td>\n",
       "      <td>27</td>\n",
       "      <td>13.6</td>\n",
       "      <td>29.9</td>\n",
       "      <td>19.5</td>\n",
       "      <td>28.5</td>\n",
       "      <td>315</td>\n",
       "      <td>0.00</td>\n",
       "      <td>12.69</td>\n",
       "      <td>0.00</td>\n",
       "      <td>53.2</td>\n",
       "      <td>42.6</td>\n",
       "      <td>42</td>\n",
       "      <td>16</td>\n",
       "      <td>29.975</td>\n",
       "      <td>29.770</td>\n",
       "      <td>35.7</td>\n",
       "      <td>57.5</td>\n",
       "      <td>53.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>674</th>\n",
       "      <td>2010-12-14</td>\n",
       "      <td>46.3</td>\n",
       "      <td>26</td>\n",
       "      <td>12.3</td>\n",
       "      <td>29.6</td>\n",
       "      <td>18.5</td>\n",
       "      <td>32.6</td>\n",
       "      <td>314</td>\n",
       "      <td>0.00</td>\n",
       "      <td>12.69</td>\n",
       "      <td>0.00</td>\n",
       "      <td>52.2</td>\n",
       "      <td>42.1</td>\n",
       "      <td>41</td>\n",
       "      <td>18</td>\n",
       "      <td>29.793</td>\n",
       "      <td>29.220</td>\n",
       "      <td>169.1</td>\n",
       "      <td>255.3</td>\n",
       "      <td>52.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>675</th>\n",
       "      <td>2010-12-15</td>\n",
       "      <td>34.1</td>\n",
       "      <td>55</td>\n",
       "      <td>18.5</td>\n",
       "      <td>29.6</td>\n",
       "      <td>10.2</td>\n",
       "      <td>14.7</td>\n",
       "      <td>313</td>\n",
       "      <td>0.01</td>\n",
       "      <td>12.70</td>\n",
       "      <td>0.01</td>\n",
       "      <td>44.3</td>\n",
       "      <td>22.9</td>\n",
       "      <td>88</td>\n",
       "      <td>27</td>\n",
       "      <td>29.942</td>\n",
       "      <td>29.362</td>\n",
       "      <td>27.6</td>\n",
       "      <td>42.6</td>\n",
       "      <td>44.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>676</th>\n",
       "      <td>2010-12-16</td>\n",
       "      <td>20.2</td>\n",
       "      <td>62</td>\n",
       "      <td>8.5</td>\n",
       "      <td>30.1</td>\n",
       "      <td>3.7</td>\n",
       "      <td>6.1</td>\n",
       "      <td>88</td>\n",
       "      <td>0.01</td>\n",
       "      <td>12.70</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.1</td>\n",
       "      <td>10.5</td>\n",
       "      <td>84</td>\n",
       "      <td>33</td>\n",
       "      <td>30.317</td>\n",
       "      <td>29.936</td>\n",
       "      <td>19.6</td>\n",
       "      <td>29.9</td>\n",
       "      <td>29.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>677</th>\n",
       "      <td>2010-12-17</td>\n",
       "      <td>15.7</td>\n",
       "      <td>73</td>\n",
       "      <td>8.5</td>\n",
       "      <td>30.2</td>\n",
       "      <td>1.7</td>\n",
       "      <td>3.1</td>\n",
       "      <td>111</td>\n",
       "      <td>0.01</td>\n",
       "      <td>12.70</td>\n",
       "      <td>0.00</td>\n",
       "      <td>24.1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>83</td>\n",
       "      <td>53</td>\n",
       "      <td>30.329</td>\n",
       "      <td>30.131</td>\n",
       "      <td>8.1</td>\n",
       "      <td>11.5</td>\n",
       "      <td>24.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>678</th>\n",
       "      <td>2010-12-18</td>\n",
       "      <td>29.7</td>\n",
       "      <td>61</td>\n",
       "      <td>17.5</td>\n",
       "      <td>29.9</td>\n",
       "      <td>6.1</td>\n",
       "      <td>8.9</td>\n",
       "      <td>326</td>\n",
       "      <td>0.01</td>\n",
       "      <td>12.70</td>\n",
       "      <td>0.00</td>\n",
       "      <td>38.9</td>\n",
       "      <td>11.1</td>\n",
       "      <td>83</td>\n",
       "      <td>40</td>\n",
       "      <td>30.166</td>\n",
       "      <td>29.685</td>\n",
       "      <td>19.6</td>\n",
       "      <td>25.3</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>679</th>\n",
       "      <td>2010-12-19</td>\n",
       "      <td>36.5</td>\n",
       "      <td>71</td>\n",
       "      <td>27.8</td>\n",
       "      <td>29.6</td>\n",
       "      <td>4.5</td>\n",
       "      <td>6.5</td>\n",
       "      <td>311</td>\n",
       "      <td>0.13</td>\n",
       "      <td>12.82</td>\n",
       "      <td>0.01</td>\n",
       "      <td>41.8</td>\n",
       "      <td>32.3</td>\n",
       "      <td>93</td>\n",
       "      <td>52</td>\n",
       "      <td>29.720</td>\n",
       "      <td>29.418</td>\n",
       "      <td>16.1</td>\n",
       "      <td>21.9</td>\n",
       "      <td>41.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>680</th>\n",
       "      <td>2010-12-20</td>\n",
       "      <td>33.9</td>\n",
       "      <td>83</td>\n",
       "      <td>29.2</td>\n",
       "      <td>29.6</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>88</td>\n",
       "      <td>0.42</td>\n",
       "      <td>13.11</td>\n",
       "      <td>0.01</td>\n",
       "      <td>37.5</td>\n",
       "      <td>28.1</td>\n",
       "      <td>92</td>\n",
       "      <td>54</td>\n",
       "      <td>29.879</td>\n",
       "      <td>29.388</td>\n",
       "      <td>10.4</td>\n",
       "      <td>13.8</td>\n",
       "      <td>37.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>681</th>\n",
       "      <td>2010-12-21</td>\n",
       "      <td>25.0</td>\n",
       "      <td>79</td>\n",
       "      <td>19.3</td>\n",
       "      <td>30.1</td>\n",
       "      <td>2.3</td>\n",
       "      <td>3.6</td>\n",
       "      <td>86</td>\n",
       "      <td>0.49</td>\n",
       "      <td>13.18</td>\n",
       "      <td>0.01</td>\n",
       "      <td>28.7</td>\n",
       "      <td>22.3</td>\n",
       "      <td>87</td>\n",
       "      <td>54</td>\n",
       "      <td>30.318</td>\n",
       "      <td>29.846</td>\n",
       "      <td>8.1</td>\n",
       "      <td>11.5</td>\n",
       "      <td>28.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>682</th>\n",
       "      <td>2010-12-22</td>\n",
       "      <td>25.1</td>\n",
       "      <td>84</td>\n",
       "      <td>20.8</td>\n",
       "      <td>30.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.8</td>\n",
       "      <td>37</td>\n",
       "      <td>0.57</td>\n",
       "      <td>13.26</td>\n",
       "      <td>0.02</td>\n",
       "      <td>39.2</td>\n",
       "      <td>17.7</td>\n",
       "      <td>90</td>\n",
       "      <td>68</td>\n",
       "      <td>30.406</td>\n",
       "      <td>30.072</td>\n",
       "      <td>11.5</td>\n",
       "      <td>16.1</td>\n",
       "      <td>39.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>683</th>\n",
       "      <td>2010-12-23</td>\n",
       "      <td>32.9</td>\n",
       "      <td>71</td>\n",
       "      <td>24.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>7.4</td>\n",
       "      <td>341</td>\n",
       "      <td>0.57</td>\n",
       "      <td>13.26</td>\n",
       "      <td>0.00</td>\n",
       "      <td>46.0</td>\n",
       "      <td>19.2</td>\n",
       "      <td>92</td>\n",
       "      <td>44</td>\n",
       "      <td>30.191</td>\n",
       "      <td>29.850</td>\n",
       "      <td>170.2</td>\n",
       "      <td>255.3</td>\n",
       "      <td>46.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>684</th>\n",
       "      <td>2010-12-24</td>\n",
       "      <td>24.4</td>\n",
       "      <td>80</td>\n",
       "      <td>18.7</td>\n",
       "      <td>30.4</td>\n",
       "      <td>1.2</td>\n",
       "      <td>2.1</td>\n",
       "      <td>52</td>\n",
       "      <td>0.58</td>\n",
       "      <td>13.27</td>\n",
       "      <td>0.01</td>\n",
       "      <td>38.2</td>\n",
       "      <td>14.1</td>\n",
       "      <td>89</td>\n",
       "      <td>57</td>\n",
       "      <td>30.598</td>\n",
       "      <td>30.185</td>\n",
       "      <td>6.9</td>\n",
       "      <td>10.4</td>\n",
       "      <td>38.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>685</th>\n",
       "      <td>2010-12-25</td>\n",
       "      <td>24.1</td>\n",
       "      <td>63</td>\n",
       "      <td>10.7</td>\n",
       "      <td>30.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.4</td>\n",
       "      <td>78</td>\n",
       "      <td>0.58</td>\n",
       "      <td>13.27</td>\n",
       "      <td>0.00</td>\n",
       "      <td>51.4</td>\n",
       "      <td>8.4</td>\n",
       "      <td>86</td>\n",
       "      <td>17</td>\n",
       "      <td>30.719</td>\n",
       "      <td>30.255</td>\n",
       "      <td>5.8</td>\n",
       "      <td>10.4</td>\n",
       "      <td>51.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>686</th>\n",
       "      <td>2010-12-26</td>\n",
       "      <td>35.4</td>\n",
       "      <td>40</td>\n",
       "      <td>11.2</td>\n",
       "      <td>30.0</td>\n",
       "      <td>8.1</td>\n",
       "      <td>17.9</td>\n",
       "      <td>325</td>\n",
       "      <td>0.58</td>\n",
       "      <td>13.27</td>\n",
       "      <td>0.00</td>\n",
       "      <td>51.7</td>\n",
       "      <td>16.5</td>\n",
       "      <td>77</td>\n",
       "      <td>15</td>\n",
       "      <td>30.255</td>\n",
       "      <td>29.712</td>\n",
       "      <td>120.8</td>\n",
       "      <td>255.3</td>\n",
       "      <td>51.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>687</th>\n",
       "      <td>2010-12-27</td>\n",
       "      <td>31.4</td>\n",
       "      <td>34</td>\n",
       "      <td>5.9</td>\n",
       "      <td>30.0</td>\n",
       "      <td>14.3</td>\n",
       "      <td>21.2</td>\n",
       "      <td>327</td>\n",
       "      <td>0.58</td>\n",
       "      <td>13.27</td>\n",
       "      <td>0.00</td>\n",
       "      <td>36.9</td>\n",
       "      <td>27.6</td>\n",
       "      <td>50</td>\n",
       "      <td>24</td>\n",
       "      <td>30.177</td>\n",
       "      <td>29.752</td>\n",
       "      <td>27.6</td>\n",
       "      <td>41.4</td>\n",
       "      <td>36.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>688</th>\n",
       "      <td>2010-12-28</td>\n",
       "      <td>31.7</td>\n",
       "      <td>28</td>\n",
       "      <td>1.1</td>\n",
       "      <td>29.9</td>\n",
       "      <td>9.5</td>\n",
       "      <td>13.6</td>\n",
       "      <td>319</td>\n",
       "      <td>0.58</td>\n",
       "      <td>13.27</td>\n",
       "      <td>0.00</td>\n",
       "      <td>41.5</td>\n",
       "      <td>18.0</td>\n",
       "      <td>51</td>\n",
       "      <td>17</td>\n",
       "      <td>30.149</td>\n",
       "      <td>29.592</td>\n",
       "      <td>24.2</td>\n",
       "      <td>32.2</td>\n",
       "      <td>41.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>689</th>\n",
       "      <td>2010-12-29</td>\n",
       "      <td>35.5</td>\n",
       "      <td>37</td>\n",
       "      <td>10.5</td>\n",
       "      <td>29.2</td>\n",
       "      <td>16.1</td>\n",
       "      <td>25.4</td>\n",
       "      <td>315</td>\n",
       "      <td>0.58</td>\n",
       "      <td>13.27</td>\n",
       "      <td>0.00</td>\n",
       "      <td>39.3</td>\n",
       "      <td>32.8</td>\n",
       "      <td>50</td>\n",
       "      <td>15</td>\n",
       "      <td>29.592</td>\n",
       "      <td>29.036</td>\n",
       "      <td>170.2</td>\n",
       "      <td>255.3</td>\n",
       "      <td>39.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>690</th>\n",
       "      <td>2010-12-30</td>\n",
       "      <td>17.5</td>\n",
       "      <td>71</td>\n",
       "      <td>9.3</td>\n",
       "      <td>29.4</td>\n",
       "      <td>3.7</td>\n",
       "      <td>5.7</td>\n",
       "      <td>102</td>\n",
       "      <td>0.58</td>\n",
       "      <td>13.27</td>\n",
       "      <td>0.00</td>\n",
       "      <td>33.4</td>\n",
       "      <td>-1.2</td>\n",
       "      <td>85</td>\n",
       "      <td>44</td>\n",
       "      <td>29.748</td>\n",
       "      <td>29.126</td>\n",
       "      <td>12.7</td>\n",
       "      <td>18.4</td>\n",
       "      <td>33.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>691</th>\n",
       "      <td>2010-12-31</td>\n",
       "      <td>1.5</td>\n",
       "      <td>53</td>\n",
       "      <td>-12.5</td>\n",
       "      <td>30.0</td>\n",
       "      <td>9.9</td>\n",
       "      <td>14.3</td>\n",
       "      <td>319</td>\n",
       "      <td>0.58</td>\n",
       "      <td>13.27</td>\n",
       "      <td>0.00</td>\n",
       "      <td>5.4</td>\n",
       "      <td>-1.4</td>\n",
       "      <td>76</td>\n",
       "      <td>34</td>\n",
       "      <td>30.167</td>\n",
       "      <td>29.735</td>\n",
       "      <td>27.6</td>\n",
       "      <td>40.3</td>\n",
       "      <td>5.4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Day  Average temperature (°F)  Average humidity (%)  \\\n",
       "662 2010-12-02                      42.2                    39   \n",
       "663 2010-12-03                      44.8                    31   \n",
       "664 2010-12-04                      31.3                    62   \n",
       "665 2010-12-05                      28.8                    67   \n",
       "666 2010-12-06                      34.3                    62   \n",
       "667 2010-12-07                      34.3                    40   \n",
       "668 2010-12-08                      40.4                    26   \n",
       "669 2010-12-09                      39.6                    37   \n",
       "670 2010-12-10                      35.9                    47   \n",
       "671 2010-12-11                      25.2                    41   \n",
       "672 2010-12-12                      34.8                    50   \n",
       "673 2010-12-13                      45.8                    27   \n",
       "674 2010-12-14                      46.3                    26   \n",
       "675 2010-12-15                      34.1                    55   \n",
       "676 2010-12-16                      20.2                    62   \n",
       "677 2010-12-17                      15.7                    73   \n",
       "678 2010-12-18                      29.7                    61   \n",
       "679 2010-12-19                      36.5                    71   \n",
       "680 2010-12-20                      33.9                    83   \n",
       "681 2010-12-21                      25.0                    79   \n",
       "682 2010-12-22                      25.1                    84   \n",
       "683 2010-12-23                      32.9                    71   \n",
       "684 2010-12-24                      24.4                    80   \n",
       "685 2010-12-25                      24.1                    63   \n",
       "686 2010-12-26                      35.4                    40   \n",
       "687 2010-12-27                      31.4                    34   \n",
       "688 2010-12-28                      31.7                    28   \n",
       "689 2010-12-29                      35.5                    37   \n",
       "690 2010-12-30                      17.5                    71   \n",
       "691 2010-12-31                       1.5                    53   \n",
       "\n",
       "     Average dewpoint (°F)  Average barometer (in)  Average windspeed (mph)  \\\n",
       "662                   18.2                    30.0                     12.6   \n",
       "663                   15.9                    29.8                     13.8   \n",
       "664                   18.0                    30.2                      6.0   \n",
       "665                   18.9                    30.4                      2.7   \n",
       "666                   21.4                    30.3                      4.6   \n",
       "667                   12.0                    30.2                      7.8   \n",
       "668                    7.4                    30.1                     10.6   \n",
       "669                   14.9                    29.9                     15.3   \n",
       "670                   17.5                    29.8                     10.4   \n",
       "671                    4.6                    30.2                      7.2   \n",
       "672                   17.4                    30.2                     10.4   \n",
       "673                   13.6                    29.9                     19.5   \n",
       "674                   12.3                    29.6                     18.5   \n",
       "675                   18.5                    29.6                     10.2   \n",
       "676                    8.5                    30.1                      3.7   \n",
       "677                    8.5                    30.2                      1.7   \n",
       "678                   17.5                    29.9                      6.1   \n",
       "679                   27.8                    29.6                      4.5   \n",
       "680                   29.2                    29.6                      3.0   \n",
       "681                   19.3                    30.1                      2.3   \n",
       "682                   20.8                    30.3                      1.3   \n",
       "683                   24.0                    30.0                      3.1   \n",
       "684                   18.7                    30.4                      1.2   \n",
       "685                   10.7                    30.5                      0.6   \n",
       "686                   11.2                    30.0                      8.1   \n",
       "687                    5.9                    30.0                     14.3   \n",
       "688                    1.1                    29.9                      9.5   \n",
       "689                   10.5                    29.2                     16.1   \n",
       "690                    9.3                    29.4                      3.7   \n",
       "691                  -12.5                    30.0                      9.9   \n",
       "\n",
       "     Average gustspeed (mph)  Average direction (°deg)  \\\n",
       "662                     19.0                       310   \n",
       "663                     17.1                       301   \n",
       "664                      7.9                       320   \n",
       "665                      4.1                        68   \n",
       "666                      7.0                       318   \n",
       "667                     11.9                       322   \n",
       "668                     15.5                       308   \n",
       "669                     22.5                       315   \n",
       "670                     16.0                       321   \n",
       "671                     11.4                       329   \n",
       "672                     15.5                       320   \n",
       "673                     28.5                       315   \n",
       "674                     32.6                       314   \n",
       "675                     14.7                       313   \n",
       "676                      6.1                        88   \n",
       "677                      3.1                       111   \n",
       "678                      8.9                       326   \n",
       "679                      6.5                       311   \n",
       "680                      4.9                        88   \n",
       "681                      3.6                        86   \n",
       "682                      1.8                        37   \n",
       "683                      7.4                       341   \n",
       "684                      2.1                        52   \n",
       "685                      1.4                        78   \n",
       "686                     17.9                       325   \n",
       "687                     21.2                       327   \n",
       "688                     13.6                       319   \n",
       "689                     25.4                       315   \n",
       "690                      5.7                       102   \n",
       "691                     14.3                       319   \n",
       "\n",
       "     Rainfall for month (in)  Rainfall for year (in)  \\\n",
       "662                     0.00                   12.69   \n",
       "663                     0.00                   12.69   \n",
       "664                     0.00                   12.69   \n",
       "665                     0.00                   12.69   \n",
       "666                     0.00                   12.69   \n",
       "667                     0.00                   12.69   \n",
       "668                     0.00                   12.69   \n",
       "669                     0.00                   12.69   \n",
       "670                     0.00                   12.69   \n",
       "671                     0.00                   12.69   \n",
       "672                     0.00                   12.69   \n",
       "673                     0.00                   12.69   \n",
       "674                     0.00                   12.69   \n",
       "675                     0.01                   12.70   \n",
       "676                     0.01                   12.70   \n",
       "677                     0.01                   12.70   \n",
       "678                     0.01                   12.70   \n",
       "679                     0.13                   12.82   \n",
       "680                     0.42                   13.11   \n",
       "681                     0.49                   13.18   \n",
       "682                     0.57                   13.26   \n",
       "683                     0.57                   13.26   \n",
       "684                     0.58                   13.27   \n",
       "685                     0.58                   13.27   \n",
       "686                     0.58                   13.27   \n",
       "687                     0.58                   13.27   \n",
       "688                     0.58                   13.27   \n",
       "689                     0.58                   13.27   \n",
       "690                     0.58                   13.27   \n",
       "691                     0.58                   13.27   \n",
       "\n",
       "     Maximum rain per minute   Maximum temperature (°F)  \\\n",
       "662                      0.00                      48.8   \n",
       "663                      0.00                      46.2   \n",
       "664                      0.00                      46.0   \n",
       "665                      0.00                      43.1   \n",
       "666                      0.00                      48.1   \n",
       "667                      0.00                      46.2   \n",
       "668                      0.00                      49.2   \n",
       "669                      0.00                      44.0   \n",
       "670                      0.00                      43.4   \n",
       "671                      0.00                      29.0   \n",
       "672                      0.00                      46.7   \n",
       "673                      0.00                      53.2   \n",
       "674                      0.00                      52.2   \n",
       "675                      0.01                      44.3   \n",
       "676                      0.00                      29.1   \n",
       "677                      0.00                      24.1   \n",
       "678                      0.00                      38.9   \n",
       "679                      0.01                      41.8   \n",
       "680                      0.01                      37.5   \n",
       "681                      0.01                      28.7   \n",
       "682                      0.02                      39.2   \n",
       "683                      0.00                      46.0   \n",
       "684                      0.01                      38.2   \n",
       "685                      0.00                      51.4   \n",
       "686                      0.00                      51.7   \n",
       "687                      0.00                      36.9   \n",
       "688                      0.00                      41.5   \n",
       "689                      0.00                      39.3   \n",
       "690                      0.00                      33.4   \n",
       "691                      0.00                       5.4   \n",
       "\n",
       "     Minimum temperature (°F)  Maximum humidity (%)  Minimum humidity (%)  \\\n",
       "662                      36.4                    58                    28   \n",
       "663                      42.3                    41                    28   \n",
       "664                      21.8                    89                    28   \n",
       "665                      18.8                    86                    45   \n",
       "666                      18.1                    87                    27   \n",
       "667                      23.0                    60                    23   \n",
       "668                      23.9                    41                    15   \n",
       "669                      29.5                    57                    25   \n",
       "670                      28.1                    85                    32   \n",
       "671                      17.0                    57                    31   \n",
       "672                      16.7                    66                    31   \n",
       "673                      42.6                    42                    16   \n",
       "674                      42.1                    41                    18   \n",
       "675                      22.9                    88                    27   \n",
       "676                      10.5                    84                    33   \n",
       "677                      10.0                    83                    53   \n",
       "678                      11.1                    83                    40   \n",
       "679                      32.3                    93                    52   \n",
       "680                      28.1                    92                    54   \n",
       "681                      22.3                    87                    54   \n",
       "682                      17.7                    90                    68   \n",
       "683                      19.2                    92                    44   \n",
       "684                      14.1                    89                    57   \n",
       "685                       8.4                    86                    17   \n",
       "686                      16.5                    77                    15   \n",
       "687                      27.6                    50                    24   \n",
       "688                      18.0                    51                    17   \n",
       "689                      32.8                    50                    15   \n",
       "690                      -1.2                    85                    44   \n",
       "691                      -1.4                    76                    34   \n",
       "\n",
       "     Maximum pressure   Minimum pressure   Maximum windspeed (mph)  \\\n",
       "662             30.126             29.826                     31.1   \n",
       "663             29.851             29.802                     31.1   \n",
       "664             30.430             29.828                     16.1   \n",
       "665             30.487             30.267                     11.5   \n",
       "666             30.465             30.008                     17.3   \n",
       "667             30.382             29.951                     25.3   \n",
       "668             30.282             29.817                     26.5   \n",
       "669             29.998             29.766                     34.5   \n",
       "670             29.998             29.645                     25.3   \n",
       "671             30.425             29.947                     16.1   \n",
       "672             30.425             29.856                     28.8   \n",
       "673             29.975             29.770                     35.7   \n",
       "674             29.793             29.220                    169.1   \n",
       "675             29.942             29.362                     27.6   \n",
       "676             30.317             29.936                     19.6   \n",
       "677             30.329             30.131                      8.1   \n",
       "678             30.166             29.685                     19.6   \n",
       "679             29.720             29.418                     16.1   \n",
       "680             29.879             29.388                     10.4   \n",
       "681             30.318             29.846                      8.1   \n",
       "682             30.406             30.072                     11.5   \n",
       "683             30.191             29.850                    170.2   \n",
       "684             30.598             30.185                      6.9   \n",
       "685             30.719             30.255                      5.8   \n",
       "686             30.255             29.712                    120.8   \n",
       "687             30.177             29.752                     27.6   \n",
       "688             30.149             29.592                     24.2   \n",
       "689             29.592             29.036                    170.2   \n",
       "690             29.748             29.126                     12.7   \n",
       "691             30.167             29.735                     27.6   \n",
       "\n",
       "     Maximum gust speed (mph)  Maximum heat index (°F)  \n",
       "662                      43.7                     48.8  \n",
       "663                      44.9                     46.2  \n",
       "664                      20.7                     46.0  \n",
       "665                      13.8                     43.1  \n",
       "666                      26.5                     48.1  \n",
       "667                      34.5                     46.2  \n",
       "668                      36.8                     49.2  \n",
       "669                      49.5                     44.0  \n",
       "670                      38.0                     43.4  \n",
       "671                      26.5                     29.0  \n",
       "672                      46.0                     46.7  \n",
       "673                      57.5                     53.2  \n",
       "674                     255.3                     52.2  \n",
       "675                      42.6                     44.3  \n",
       "676                      29.9                     29.1  \n",
       "677                      11.5                     24.1  \n",
       "678                      25.3                     38.9  \n",
       "679                      21.9                     41.8  \n",
       "680                      13.8                     37.5  \n",
       "681                      11.5                     28.7  \n",
       "682                      16.1                     39.2  \n",
       "683                     255.3                     46.0  \n",
       "684                      10.4                     38.2  \n",
       "685                      10.4                     51.4  \n",
       "686                     255.3                     51.7  \n",
       "687                      41.4                     36.9  \n",
       "688                      32.2                     41.5  \n",
       "689                     255.3                     39.3  \n",
       "690                      18.4                     33.4  \n",
       "691                      40.3                      5.4  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mask = df[\"Day\"].between(pd.to_datetime(\"1st Dec, 2010\"), pd.to_datetime(\"31st Dec, 2010\"))\n",
    "df[mask]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "76dfaf72",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "44.8"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# np.ptp means peak to peak \n",
    "\n",
    "q8 = np.ptp(df[mask].get(\"Average temperature (°F)\")).round(2)\n",
    "q8"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f0185b35",
   "metadata": {},
   "source": [
    "### Out of all available records which day has the highest difference between maximum_pressure and minimum_pressure\n",
    "    - assign the date in string format as 'yyyy-mm-dd'. Make sure you enclose it with single quote"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "b763f4db",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "15"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "maximum_pressure_col_index = -1\n",
    "\n",
    "for col in df.columns[:]:\n",
    "    maximum_pressure_col_index += 1\n",
    "    if col == \"Maximum pressure \":\n",
    "        break\n",
    "\n",
    "maximum_pressure_col_index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "4f5308e5",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       0.166\n",
       "1       0.401\n",
       "2       0.972\n",
       "3       0.339\n",
       "4       0.665\n",
       "        ...  \n",
       "3275    0.237\n",
       "3276    0.251\n",
       "3277    0.220\n",
       "3278    0.285\n",
       "3279    0.377\n",
       "Length: 3280, dtype: float64"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pressure_max_min = abs(df[\"Maximum pressure \"]  - df[\"Minimum pressure \"])\n",
    "pressure_max_min"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "8c18bbe0",
   "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>Day</th>\n",
       "      <th>Average temperature (°F)</th>\n",
       "      <th>Average humidity (%)</th>\n",
       "      <th>Average dewpoint (°F)</th>\n",
       "      <th>Average barometer (in)</th>\n",
       "      <th>Average windspeed (mph)</th>\n",
       "      <th>Average gustspeed (mph)</th>\n",
       "      <th>Average direction (°deg)</th>\n",
       "      <th>Rainfall for month (in)</th>\n",
       "      <th>Rainfall for year (in)</th>\n",
       "      <th>...</th>\n",
       "      <th>Maximum temperature (°F)</th>\n",
       "      <th>Minimum temperature (°F)</th>\n",
       "      <th>Maximum humidity (%)</th>\n",
       "      <th>Minimum humidity (%)</th>\n",
       "      <th>Maximum pressure</th>\n",
       "      <th>Minimum pressure</th>\n",
       "      <th>abs(Max_Pressure - Min_Pressure)</th>\n",
       "      <th>Maximum windspeed (mph)</th>\n",
       "      <th>Maximum gust speed (mph)</th>\n",
       "      <th>Maximum heat index (°F)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2009-01-01</td>\n",
       "      <td>37.8</td>\n",
       "      <td>35</td>\n",
       "      <td>12.7</td>\n",
       "      <td>29.7</td>\n",
       "      <td>26.4</td>\n",
       "      <td>36.8</td>\n",
       "      <td>274</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>40.1</td>\n",
       "      <td>34.5</td>\n",
       "      <td>44</td>\n",
       "      <td>27</td>\n",
       "      <td>29.762</td>\n",
       "      <td>29.596</td>\n",
       "      <td>0.166</td>\n",
       "      <td>41.4</td>\n",
       "      <td>59.0</td>\n",
       "      <td>40.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2009-01-02</td>\n",
       "      <td>43.2</td>\n",
       "      <td>32</td>\n",
       "      <td>14.7</td>\n",
       "      <td>29.5</td>\n",
       "      <td>12.8</td>\n",
       "      <td>18.0</td>\n",
       "      <td>240</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>52.8</td>\n",
       "      <td>37.5</td>\n",
       "      <td>43</td>\n",
       "      <td>16</td>\n",
       "      <td>29.669</td>\n",
       "      <td>29.268</td>\n",
       "      <td>0.401</td>\n",
       "      <td>35.7</td>\n",
       "      <td>51.0</td>\n",
       "      <td>52.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2009-01-03</td>\n",
       "      <td>25.7</td>\n",
       "      <td>60</td>\n",
       "      <td>12.7</td>\n",
       "      <td>29.7</td>\n",
       "      <td>8.3</td>\n",
       "      <td>12.2</td>\n",
       "      <td>290</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>41.2</td>\n",
       "      <td>6.7</td>\n",
       "      <td>89</td>\n",
       "      <td>35</td>\n",
       "      <td>30.232</td>\n",
       "      <td>29.260</td>\n",
       "      <td>0.972</td>\n",
       "      <td>25.3</td>\n",
       "      <td>38.0</td>\n",
       "      <td>41.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2009-01-04</td>\n",
       "      <td>9.3</td>\n",
       "      <td>67</td>\n",
       "      <td>0.1</td>\n",
       "      <td>30.4</td>\n",
       "      <td>2.9</td>\n",
       "      <td>4.5</td>\n",
       "      <td>47</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>19.4</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>79</td>\n",
       "      <td>35</td>\n",
       "      <td>30.566</td>\n",
       "      <td>30.227</td>\n",
       "      <td>0.339</td>\n",
       "      <td>12.7</td>\n",
       "      <td>20.0</td>\n",
       "      <td>32.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2009-01-05</td>\n",
       "      <td>23.5</td>\n",
       "      <td>30</td>\n",
       "      <td>-5.3</td>\n",
       "      <td>29.9</td>\n",
       "      <td>16.7</td>\n",
       "      <td>23.1</td>\n",
       "      <td>265</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>30.3</td>\n",
       "      <td>15.1</td>\n",
       "      <td>56</td>\n",
       "      <td>13</td>\n",
       "      <td>30.233</td>\n",
       "      <td>29.568</td>\n",
       "      <td>0.665</td>\n",
       "      <td>38.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>32.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3275</th>\n",
       "      <td>2018-10-24</td>\n",
       "      <td>45.9</td>\n",
       "      <td>53</td>\n",
       "      <td>27.5</td>\n",
       "      <td>29.8</td>\n",
       "      <td>2.7</td>\n",
       "      <td>4.6</td>\n",
       "      <td>282</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.86</td>\n",
       "      <td>...</td>\n",
       "      <td>57.3</td>\n",
       "      <td>35.9</td>\n",
       "      <td>81</td>\n",
       "      <td>23</td>\n",
       "      <td>29.947</td>\n",
       "      <td>29.710</td>\n",
       "      <td>0.237</td>\n",
       "      <td>12.7</td>\n",
       "      <td>19.6</td>\n",
       "      <td>57.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3276</th>\n",
       "      <td>2018-10-25</td>\n",
       "      <td>46.7</td>\n",
       "      <td>40</td>\n",
       "      <td>22.7</td>\n",
       "      <td>29.8</td>\n",
       "      <td>4.5</td>\n",
       "      <td>7.2</td>\n",
       "      <td>283</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.86</td>\n",
       "      <td>...</td>\n",
       "      <td>61.8</td>\n",
       "      <td>35.0</td>\n",
       "      <td>60</td>\n",
       "      <td>19</td>\n",
       "      <td>29.933</td>\n",
       "      <td>29.682</td>\n",
       "      <td>0.251</td>\n",
       "      <td>13.8</td>\n",
       "      <td>19.6</td>\n",
       "      <td>61.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3277</th>\n",
       "      <td>2018-10-26</td>\n",
       "      <td>48.4</td>\n",
       "      <td>35</td>\n",
       "      <td>21.6</td>\n",
       "      <td>29.8</td>\n",
       "      <td>9.7</td>\n",
       "      <td>14.4</td>\n",
       "      <td>283</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.86</td>\n",
       "      <td>...</td>\n",
       "      <td>58.7</td>\n",
       "      <td>42.6</td>\n",
       "      <td>48</td>\n",
       "      <td>19</td>\n",
       "      <td>29.979</td>\n",
       "      <td>29.759</td>\n",
       "      <td>0.220</td>\n",
       "      <td>20.7</td>\n",
       "      <td>31.1</td>\n",
       "      <td>58.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3278</th>\n",
       "      <td>2018-10-27</td>\n",
       "      <td>53.3</td>\n",
       "      <td>37</td>\n",
       "      <td>26.6</td>\n",
       "      <td>29.8</td>\n",
       "      <td>10.3</td>\n",
       "      <td>14.8</td>\n",
       "      <td>282</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.86</td>\n",
       "      <td>...</td>\n",
       "      <td>64.5</td>\n",
       "      <td>38.3</td>\n",
       "      <td>78</td>\n",
       "      <td>24</td>\n",
       "      <td>29.935</td>\n",
       "      <td>29.650</td>\n",
       "      <td>0.285</td>\n",
       "      <td>28.8</td>\n",
       "      <td>38.0</td>\n",
       "      <td>64.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3279</th>\n",
       "      <td>2018-10-28</td>\n",
       "      <td>49.4</td>\n",
       "      <td>48</td>\n",
       "      <td>25.2</td>\n",
       "      <td>29.9</td>\n",
       "      <td>5.3</td>\n",
       "      <td>7.6</td>\n",
       "      <td>282</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.86</td>\n",
       "      <td>...</td>\n",
       "      <td>67.3</td>\n",
       "      <td>30.9</td>\n",
       "      <td>90</td>\n",
       "      <td>19</td>\n",
       "      <td>30.040</td>\n",
       "      <td>29.663</td>\n",
       "      <td>0.377</td>\n",
       "      <td>18.4</td>\n",
       "      <td>25.3</td>\n",
       "      <td>67.3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3280 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Day  Average temperature (°F)  Average humidity (%)  \\\n",
       "0    2009-01-01                      37.8                    35   \n",
       "1    2009-01-02                      43.2                    32   \n",
       "2    2009-01-03                      25.7                    60   \n",
       "3    2009-01-04                       9.3                    67   \n",
       "4    2009-01-05                      23.5                    30   \n",
       "...         ...                       ...                   ...   \n",
       "3275 2018-10-24                      45.9                    53   \n",
       "3276 2018-10-25                      46.7                    40   \n",
       "3277 2018-10-26                      48.4                    35   \n",
       "3278 2018-10-27                      53.3                    37   \n",
       "3279 2018-10-28                      49.4                    48   \n",
       "\n",
       "      Average dewpoint (°F)  Average barometer (in)  Average windspeed (mph)  \\\n",
       "0                      12.7                    29.7                     26.4   \n",
       "1                      14.7                    29.5                     12.8   \n",
       "2                      12.7                    29.7                      8.3   \n",
       "3                       0.1                    30.4                      2.9   \n",
       "4                      -5.3                    29.9                     16.7   \n",
       "...                     ...                     ...                      ...   \n",
       "3275                   27.5                    29.8                      2.7   \n",
       "3276                   22.7                    29.8                      4.5   \n",
       "3277                   21.6                    29.8                      9.7   \n",
       "3278                   26.6                    29.8                     10.3   \n",
       "3279                   25.2                    29.9                      5.3   \n",
       "\n",
       "      Average gustspeed (mph)  Average direction (°deg)  \\\n",
       "0                        36.8                       274   \n",
       "1                        18.0                       240   \n",
       "2                        12.2                       290   \n",
       "3                         4.5                        47   \n",
       "4                        23.1                       265   \n",
       "...                       ...                       ...   \n",
       "3275                      4.6                       282   \n",
       "3276                      7.2                       283   \n",
       "3277                     14.4                       283   \n",
       "3278                     14.8                       282   \n",
       "3279                      7.6                       282   \n",
       "\n",
       "      Rainfall for month (in)  Rainfall for year (in)  ...  \\\n",
       "0                        0.00                    0.00  ...   \n",
       "1                        0.00                    0.00  ...   \n",
       "2                        0.00                    0.00  ...   \n",
       "3                        0.00                    0.00  ...   \n",
       "4                        0.00                    0.00  ...   \n",
       "...                       ...                     ...  ...   \n",
       "3275                     0.85                    6.86  ...   \n",
       "3276                     0.85                    6.86  ...   \n",
       "3277                     0.85                    6.86  ...   \n",
       "3278                     0.85                    6.86  ...   \n",
       "3279                     0.85                    6.86  ...   \n",
       "\n",
       "      Maximum temperature (°F)  Minimum temperature (°F)  \\\n",
       "0                         40.1                      34.5   \n",
       "1                         52.8                      37.5   \n",
       "2                         41.2                       6.7   \n",
       "3                         19.4                      -0.0   \n",
       "4                         30.3                      15.1   \n",
       "...                        ...                       ...   \n",
       "3275                      57.3                      35.9   \n",
       "3276                      61.8                      35.0   \n",
       "3277                      58.7                      42.6   \n",
       "3278                      64.5                      38.3   \n",
       "3279                      67.3                      30.9   \n",
       "\n",
       "      Maximum humidity (%)  Minimum humidity (%)  Maximum pressure   \\\n",
       "0                       44                    27             29.762   \n",
       "1                       43                    16             29.669   \n",
       "2                       89                    35             30.232   \n",
       "3                       79                    35             30.566   \n",
       "4                       56                    13             30.233   \n",
       "...                    ...                   ...                ...   \n",
       "3275                    81                    23             29.947   \n",
       "3276                    60                    19             29.933   \n",
       "3277                    48                    19             29.979   \n",
       "3278                    78                    24             29.935   \n",
       "3279                    90                    19             30.040   \n",
       "\n",
       "      Minimum pressure   abs(Max_Pressure - Min_Pressure)  \\\n",
       "0                29.596                             0.166   \n",
       "1                29.268                             0.401   \n",
       "2                29.260                             0.972   \n",
       "3                30.227                             0.339   \n",
       "4                29.568                             0.665   \n",
       "...                 ...                               ...   \n",
       "3275             29.710                             0.237   \n",
       "3276             29.682                             0.251   \n",
       "3277             29.759                             0.220   \n",
       "3278             29.650                             0.285   \n",
       "3279             29.663                             0.377   \n",
       "\n",
       "      Maximum windspeed (mph)  Maximum gust speed (mph)  \\\n",
       "0                        41.4                      59.0   \n",
       "1                        35.7                      51.0   \n",
       "2                        25.3                      38.0   \n",
       "3                        12.7                      20.0   \n",
       "4                        38.0                      53.0   \n",
       "...                       ...                       ...   \n",
       "3275                     12.7                      19.6   \n",
       "3276                     13.8                      19.6   \n",
       "3277                     20.7                      31.1   \n",
       "3278                     28.8                      38.0   \n",
       "3279                     18.4                      25.3   \n",
       "\n",
       "      Maximum heat index (°F)  \n",
       "0                        40.1  \n",
       "1                        52.8  \n",
       "2                        41.2  \n",
       "3                        32.0  \n",
       "4                        32.0  \n",
       "...                       ...  \n",
       "3275                     57.2  \n",
       "3276                     61.8  \n",
       "3277                     58.7  \n",
       "3278                     64.5  \n",
       "3279                     67.3  \n",
       "\n",
       "[3280 rows x 21 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# df.drop(columns = \"abs(Max_Pressure - Min_Pressure)\", inplace = True)\n",
    "df.insert(loc = 17, column = \"abs(Max_Pressure - Min_Pressure)\", value = pressure_max_min)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "3efe895c",
   "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>Day</th>\n",
       "      <th>abs(Max_Pressure - Min_Pressure)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3067</th>\n",
       "      <td>2018-03-23</td>\n",
       "      <td>16.602</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Day  abs(Max_Pressure - Min_Pressure)\n",
       "3067 2018-03-23                            16.602"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[ [\"Day\", \"abs(Max_Pressure - Min_Pressure)\"] ].nlargest(1, \"abs(Max_Pressure - Min_Pressure)\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "a63bc130",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2018-03-23'"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "q9 = df[ [\"Day\", \"abs(Max_Pressure - Min_Pressure)\"] ].nlargest(1, \"abs(Max_Pressure - Min_Pressure)\").iloc[0, 0]\n",
    "str(q9.date())"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b16fefb8",
   "metadata": {},
   "source": [
    "### How many days falls under median (i.e equal to median value) of barrometer reading."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "b051ce36",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "534"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "q10 = sum( df[\"Average barometer (in)\"] == df[\"Average barometer (in)\"].median() )\n",
    "q10"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1d79c0d9",
   "metadata": {},
   "source": [
    "### Out of all the available records how many days are within one standard deviation of average temperature\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "8a827764",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "45.16"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mean_1 = df[\"Average temperature (°F)\"].mean().round(2)\n",
    "mean_1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "bd7cb458",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "15.19"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "std_1 = df[\"Average temperature (°F)\"].std().round(2)\n",
    "std_1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "c81b930d",
   "metadata": {},
   "outputs": [],
   "source": [
    "right_deviated = df[\"Average temperature (°F)\"].round(2) <= (mean_1 + std_1)\n",
    "left_deviated = df[\"Average temperature (°F)\"].round(2) >= (mean_1 - std_1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "b2f213a6",
   "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>Day</th>\n",
       "      <th>Average temperature (°F)</th>\n",
       "      <th>Average humidity (%)</th>\n",
       "      <th>Average dewpoint (°F)</th>\n",
       "      <th>Average barometer (in)</th>\n",
       "      <th>Average windspeed (mph)</th>\n",
       "      <th>Average gustspeed (mph)</th>\n",
       "      <th>Average direction (°deg)</th>\n",
       "      <th>Rainfall for month (in)</th>\n",
       "      <th>Rainfall for year (in)</th>\n",
       "      <th>...</th>\n",
       "      <th>Maximum temperature (°F)</th>\n",
       "      <th>Minimum temperature (°F)</th>\n",
       "      <th>Maximum humidity (%)</th>\n",
       "      <th>Minimum humidity (%)</th>\n",
       "      <th>Maximum pressure</th>\n",
       "      <th>Minimum pressure</th>\n",
       "      <th>abs(Max_Pressure - Min_Pressure)</th>\n",
       "      <th>Maximum windspeed (mph)</th>\n",
       "      <th>Maximum gust speed (mph)</th>\n",
       "      <th>Maximum heat index (°F)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2009-01-01</td>\n",
       "      <td>37.8</td>\n",
       "      <td>35</td>\n",
       "      <td>12.7</td>\n",
       "      <td>29.7</td>\n",
       "      <td>26.4</td>\n",
       "      <td>36.8</td>\n",
       "      <td>274</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>40.1</td>\n",
       "      <td>34.5</td>\n",
       "      <td>44</td>\n",
       "      <td>27</td>\n",
       "      <td>29.762</td>\n",
       "      <td>29.596</td>\n",
       "      <td>0.166</td>\n",
       "      <td>41.4</td>\n",
       "      <td>59.0</td>\n",
       "      <td>40.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2009-01-02</td>\n",
       "      <td>43.2</td>\n",
       "      <td>32</td>\n",
       "      <td>14.7</td>\n",
       "      <td>29.5</td>\n",
       "      <td>12.8</td>\n",
       "      <td>18.0</td>\n",
       "      <td>240</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>52.8</td>\n",
       "      <td>37.5</td>\n",
       "      <td>43</td>\n",
       "      <td>16</td>\n",
       "      <td>29.669</td>\n",
       "      <td>29.268</td>\n",
       "      <td>0.401</td>\n",
       "      <td>35.7</td>\n",
       "      <td>51.0</td>\n",
       "      <td>52.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2009-01-07</td>\n",
       "      <td>34.2</td>\n",
       "      <td>60</td>\n",
       "      <td>21.6</td>\n",
       "      <td>29.7</td>\n",
       "      <td>20.4</td>\n",
       "      <td>30.0</td>\n",
       "      <td>276</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>39.1</td>\n",
       "      <td>27.3</td>\n",
       "      <td>86</td>\n",
       "      <td>46</td>\n",
       "      <td>29.860</td>\n",
       "      <td>29.602</td>\n",
       "      <td>0.258</td>\n",
       "      <td>38.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>39.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2009-01-08</td>\n",
       "      <td>42.1</td>\n",
       "      <td>41</td>\n",
       "      <td>20.0</td>\n",
       "      <td>29.8</td>\n",
       "      <td>17.5</td>\n",
       "      <td>25.2</td>\n",
       "      <td>265</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>51.3</td>\n",
       "      <td>36.9</td>\n",
       "      <td>53</td>\n",
       "      <td>28</td>\n",
       "      <td>29.883</td>\n",
       "      <td>29.627</td>\n",
       "      <td>0.256</td>\n",
       "      <td>35.7</td>\n",
       "      <td>49.0</td>\n",
       "      <td>51.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2009-01-09</td>\n",
       "      <td>30.3</td>\n",
       "      <td>46</td>\n",
       "      <td>11.4</td>\n",
       "      <td>30.0</td>\n",
       "      <td>6.9</td>\n",
       "      <td>10.6</td>\n",
       "      <td>292</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>41.5</td>\n",
       "      <td>19.2</td>\n",
       "      <td>82</td>\n",
       "      <td>27</td>\n",
       "      <td>30.446</td>\n",
       "      <td>29.575</td>\n",
       "      <td>0.871</td>\n",
       "      <td>24.2</td>\n",
       "      <td>36.0</td>\n",
       "      <td>41.5</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>3275</th>\n",
       "      <td>2018-10-24</td>\n",
       "      <td>45.9</td>\n",
       "      <td>53</td>\n",
       "      <td>27.5</td>\n",
       "      <td>29.8</td>\n",
       "      <td>2.7</td>\n",
       "      <td>4.6</td>\n",
       "      <td>282</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.86</td>\n",
       "      <td>...</td>\n",
       "      <td>57.3</td>\n",
       "      <td>35.9</td>\n",
       "      <td>81</td>\n",
       "      <td>23</td>\n",
       "      <td>29.947</td>\n",
       "      <td>29.710</td>\n",
       "      <td>0.237</td>\n",
       "      <td>12.7</td>\n",
       "      <td>19.6</td>\n",
       "      <td>57.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3276</th>\n",
       "      <td>2018-10-25</td>\n",
       "      <td>46.7</td>\n",
       "      <td>40</td>\n",
       "      <td>22.7</td>\n",
       "      <td>29.8</td>\n",
       "      <td>4.5</td>\n",
       "      <td>7.2</td>\n",
       "      <td>283</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.86</td>\n",
       "      <td>...</td>\n",
       "      <td>61.8</td>\n",
       "      <td>35.0</td>\n",
       "      <td>60</td>\n",
       "      <td>19</td>\n",
       "      <td>29.933</td>\n",
       "      <td>29.682</td>\n",
       "      <td>0.251</td>\n",
       "      <td>13.8</td>\n",
       "      <td>19.6</td>\n",
       "      <td>61.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3277</th>\n",
       "      <td>2018-10-26</td>\n",
       "      <td>48.4</td>\n",
       "      <td>35</td>\n",
       "      <td>21.6</td>\n",
       "      <td>29.8</td>\n",
       "      <td>9.7</td>\n",
       "      <td>14.4</td>\n",
       "      <td>283</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.86</td>\n",
       "      <td>...</td>\n",
       "      <td>58.7</td>\n",
       "      <td>42.6</td>\n",
       "      <td>48</td>\n",
       "      <td>19</td>\n",
       "      <td>29.979</td>\n",
       "      <td>29.759</td>\n",
       "      <td>0.220</td>\n",
       "      <td>20.7</td>\n",
       "      <td>31.1</td>\n",
       "      <td>58.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3278</th>\n",
       "      <td>2018-10-27</td>\n",
       "      <td>53.3</td>\n",
       "      <td>37</td>\n",
       "      <td>26.6</td>\n",
       "      <td>29.8</td>\n",
       "      <td>10.3</td>\n",
       "      <td>14.8</td>\n",
       "      <td>282</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.86</td>\n",
       "      <td>...</td>\n",
       "      <td>64.5</td>\n",
       "      <td>38.3</td>\n",
       "      <td>78</td>\n",
       "      <td>24</td>\n",
       "      <td>29.935</td>\n",
       "      <td>29.650</td>\n",
       "      <td>0.285</td>\n",
       "      <td>28.8</td>\n",
       "      <td>38.0</td>\n",
       "      <td>64.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3279</th>\n",
       "      <td>2018-10-28</td>\n",
       "      <td>49.4</td>\n",
       "      <td>48</td>\n",
       "      <td>25.2</td>\n",
       "      <td>29.9</td>\n",
       "      <td>5.3</td>\n",
       "      <td>7.6</td>\n",
       "      <td>282</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.86</td>\n",
       "      <td>...</td>\n",
       "      <td>67.3</td>\n",
       "      <td>30.9</td>\n",
       "      <td>90</td>\n",
       "      <td>19</td>\n",
       "      <td>30.040</td>\n",
       "      <td>29.663</td>\n",
       "      <td>0.377</td>\n",
       "      <td>18.4</td>\n",
       "      <td>25.3</td>\n",
       "      <td>67.3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2092 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Day  Average temperature (°F)  Average humidity (%)  \\\n",
       "0    2009-01-01                      37.8                    35   \n",
       "1    2009-01-02                      43.2                    32   \n",
       "6    2009-01-07                      34.2                    60   \n",
       "7    2009-01-08                      42.1                    41   \n",
       "8    2009-01-09                      30.3                    46   \n",
       "...         ...                       ...                   ...   \n",
       "3275 2018-10-24                      45.9                    53   \n",
       "3276 2018-10-25                      46.7                    40   \n",
       "3277 2018-10-26                      48.4                    35   \n",
       "3278 2018-10-27                      53.3                    37   \n",
       "3279 2018-10-28                      49.4                    48   \n",
       "\n",
       "      Average dewpoint (°F)  Average barometer (in)  Average windspeed (mph)  \\\n",
       "0                      12.7                    29.7                     26.4   \n",
       "1                      14.7                    29.5                     12.8   \n",
       "6                      21.6                    29.7                     20.4   \n",
       "7                      20.0                    29.8                     17.5   \n",
       "8                      11.4                    30.0                      6.9   \n",
       "...                     ...                     ...                      ...   \n",
       "3275                   27.5                    29.8                      2.7   \n",
       "3276                   22.7                    29.8                      4.5   \n",
       "3277                   21.6                    29.8                      9.7   \n",
       "3278                   26.6                    29.8                     10.3   \n",
       "3279                   25.2                    29.9                      5.3   \n",
       "\n",
       "      Average gustspeed (mph)  Average direction (°deg)  \\\n",
       "0                        36.8                       274   \n",
       "1                        18.0                       240   \n",
       "6                        30.0                       276   \n",
       "7                        25.2                       265   \n",
       "8                        10.6                       292   \n",
       "...                       ...                       ...   \n",
       "3275                      4.6                       282   \n",
       "3276                      7.2                       283   \n",
       "3277                     14.4                       283   \n",
       "3278                     14.8                       282   \n",
       "3279                      7.6                       282   \n",
       "\n",
       "      Rainfall for month (in)  Rainfall for year (in)  ...  \\\n",
       "0                        0.00                    0.00  ...   \n",
       "1                        0.00                    0.00  ...   \n",
       "6                        0.00                    0.00  ...   \n",
       "7                        0.00                    0.00  ...   \n",
       "8                        0.00                    0.00  ...   \n",
       "...                       ...                     ...  ...   \n",
       "3275                     0.85                    6.86  ...   \n",
       "3276                     0.85                    6.86  ...   \n",
       "3277                     0.85                    6.86  ...   \n",
       "3278                     0.85                    6.86  ...   \n",
       "3279                     0.85                    6.86  ...   \n",
       "\n",
       "      Maximum temperature (°F)  Minimum temperature (°F)  \\\n",
       "0                         40.1                      34.5   \n",
       "1                         52.8                      37.5   \n",
       "6                         39.1                      27.3   \n",
       "7                         51.3                      36.9   \n",
       "8                         41.5                      19.2   \n",
       "...                        ...                       ...   \n",
       "3275                      57.3                      35.9   \n",
       "3276                      61.8                      35.0   \n",
       "3277                      58.7                      42.6   \n",
       "3278                      64.5                      38.3   \n",
       "3279                      67.3                      30.9   \n",
       "\n",
       "      Maximum humidity (%)  Minimum humidity (%)  Maximum pressure   \\\n",
       "0                       44                    27             29.762   \n",
       "1                       43                    16             29.669   \n",
       "6                       86                    46             29.860   \n",
       "7                       53                    28             29.883   \n",
       "8                       82                    27             30.446   \n",
       "...                    ...                   ...                ...   \n",
       "3275                    81                    23             29.947   \n",
       "3276                    60                    19             29.933   \n",
       "3277                    48                    19             29.979   \n",
       "3278                    78                    24             29.935   \n",
       "3279                    90                    19             30.040   \n",
       "\n",
       "      Minimum pressure   abs(Max_Pressure - Min_Pressure)  \\\n",
       "0                29.596                             0.166   \n",
       "1                29.268                             0.401   \n",
       "6                29.602                             0.258   \n",
       "7                29.627                             0.256   \n",
       "8                29.575                             0.871   \n",
       "...                 ...                               ...   \n",
       "3275             29.710                             0.237   \n",
       "3276             29.682                             0.251   \n",
       "3277             29.759                             0.220   \n",
       "3278             29.650                             0.285   \n",
       "3279             29.663                             0.377   \n",
       "\n",
       "      Maximum windspeed (mph)  Maximum gust speed (mph)  \\\n",
       "0                        41.4                      59.0   \n",
       "1                        35.7                      51.0   \n",
       "6                        38.0                      54.0   \n",
       "7                        35.7                      49.0   \n",
       "8                        24.2                      36.0   \n",
       "...                       ...                       ...   \n",
       "3275                     12.7                      19.6   \n",
       "3276                     13.8                      19.6   \n",
       "3277                     20.7                      31.1   \n",
       "3278                     28.8                      38.0   \n",
       "3279                     18.4                      25.3   \n",
       "\n",
       "      Maximum heat index (°F)  \n",
       "0                        40.1  \n",
       "1                        52.8  \n",
       "6                        39.1  \n",
       "7                        51.3  \n",
       "8                        41.5  \n",
       "...                       ...  \n",
       "3275                     57.2  \n",
       "3276                     61.8  \n",
       "3277                     58.7  \n",
       "3278                     64.5  \n",
       "3279                     67.3  \n",
       "\n",
       "[2092 rows x 21 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[right_deviated & left_deviated]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "89d651ce",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2092"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "q11 = len( df[right_deviated & left_deviated] )\n",
    "q11"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9d2db57b",
   "metadata": {},
   "source": [
    "###### Answers\n",
    "- q1 = 13.06\n",
    "- q2 = 12.20\n",
    "- q3 = 0.76\n",
    "- q4 = 1\n",
    "- q5 = 34.50\n",
    "- q6 = 2\n",
    "- q7 = 45.33\n",
    "- q8 = 44.80\n",
    "- q9 = '2018-03-23'\n",
    "- q10 = 534\n",
    "- q11 = 2092"
   ]
  }
 ],
 "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.10.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}