Weather  Data Exploration With Python.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "827066bd",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "e3b6d6bf",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(r\"C:\\Users\\Henry Oguns\\Desktop\\DATA ANALYSIS\\Portfolio Projects\\PortfolioProjects\\Project _Datasets\\file (1).csv\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "ac6103ce",
   "metadata": {
    "scrolled": true
   },
   "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>Date/Time</th>\n",
       "      <th>Temp_C</th>\n",
       "      <th>Dew Point Temp_C</th>\n",
       "      <th>Rel Hum_%</th>\n",
       "      <th>Wind Speed_km/h</th>\n",
       "      <th>Visibility_km</th>\n",
       "      <th>Press_kPa</th>\n",
       "      <th>Weather</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1/1/2012 0:00</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>-3.9</td>\n",
       "      <td>86</td>\n",
       "      <td>4</td>\n",
       "      <td>8.0</td>\n",
       "      <td>101.24</td>\n",
       "      <td>Fog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1/1/2012 1:00</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>-3.7</td>\n",
       "      <td>87</td>\n",
       "      <td>4</td>\n",
       "      <td>8.0</td>\n",
       "      <td>101.24</td>\n",
       "      <td>Fog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1/1/2012 2:00</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>-3.4</td>\n",
       "      <td>89</td>\n",
       "      <td>7</td>\n",
       "      <td>4.0</td>\n",
       "      <td>101.26</td>\n",
       "      <td>Freezing Drizzle,Fog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1/1/2012 3:00</td>\n",
       "      <td>-1.5</td>\n",
       "      <td>-3.2</td>\n",
       "      <td>88</td>\n",
       "      <td>6</td>\n",
       "      <td>4.0</td>\n",
       "      <td>101.27</td>\n",
       "      <td>Freezing Drizzle,Fog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1/1/2012 4:00</td>\n",
       "      <td>-1.5</td>\n",
       "      <td>-3.3</td>\n",
       "      <td>88</td>\n",
       "      <td>7</td>\n",
       "      <td>4.8</td>\n",
       "      <td>101.23</td>\n",
       "      <td>Fog</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Date/Time  Temp_C  Dew Point Temp_C  Rel Hum_%  Wind Speed_km/h  \\\n",
       "0  1/1/2012 0:00    -1.8              -3.9         86                4   \n",
       "1  1/1/2012 1:00    -1.8              -3.7         87                4   \n",
       "2  1/1/2012 2:00    -1.8              -3.4         89                7   \n",
       "3  1/1/2012 3:00    -1.5              -3.2         88                6   \n",
       "4  1/1/2012 4:00    -1.5              -3.3         88                7   \n",
       "\n",
       "   Visibility_km  Press_kPa               Weather  \n",
       "0            8.0     101.24                   Fog  \n",
       "1            8.0     101.24                   Fog  \n",
       "2            4.0     101.26  Freezing Drizzle,Fog  \n",
       "3            4.0     101.27  Freezing Drizzle,Fog  \n",
       "4            4.8     101.23                   Fog  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Get 5 first and last rows\n",
    "\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "c19ee370",
   "metadata": {
    "scrolled": true
   },
   "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>Date/Time</th>\n",
       "      <th>Temp_C</th>\n",
       "      <th>Dew Point Temp_C</th>\n",
       "      <th>Rel Hum_%</th>\n",
       "      <th>Wind Speed_km/h</th>\n",
       "      <th>Visibility_km</th>\n",
       "      <th>Press_kPa</th>\n",
       "      <th>Weather</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8779</th>\n",
       "      <td>12/31/2012 19:00</td>\n",
       "      <td>0.1</td>\n",
       "      <td>-2.7</td>\n",
       "      <td>81</td>\n",
       "      <td>30</td>\n",
       "      <td>9.7</td>\n",
       "      <td>100.13</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8780</th>\n",
       "      <td>12/31/2012 20:00</td>\n",
       "      <td>0.2</td>\n",
       "      <td>-2.4</td>\n",
       "      <td>83</td>\n",
       "      <td>24</td>\n",
       "      <td>9.7</td>\n",
       "      <td>100.03</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8781</th>\n",
       "      <td>12/31/2012 21:00</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>-1.5</td>\n",
       "      <td>93</td>\n",
       "      <td>28</td>\n",
       "      <td>4.8</td>\n",
       "      <td>99.95</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8782</th>\n",
       "      <td>12/31/2012 22:00</td>\n",
       "      <td>-0.2</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>89</td>\n",
       "      <td>28</td>\n",
       "      <td>9.7</td>\n",
       "      <td>99.91</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8783</th>\n",
       "      <td>12/31/2012 23:00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-2.1</td>\n",
       "      <td>86</td>\n",
       "      <td>30</td>\n",
       "      <td>11.3</td>\n",
       "      <td>99.89</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Date/Time  Temp_C  Dew Point Temp_C  Rel Hum_%  Wind Speed_km/h  \\\n",
       "8779  12/31/2012 19:00     0.1              -2.7         81               30   \n",
       "8780  12/31/2012 20:00     0.2              -2.4         83               24   \n",
       "8781  12/31/2012 21:00    -0.5              -1.5         93               28   \n",
       "8782  12/31/2012 22:00    -0.2              -1.8         89               28   \n",
       "8783  12/31/2012 23:00     0.0              -2.1         86               30   \n",
       "\n",
       "      Visibility_km  Press_kPa Weather  \n",
       "8779            9.7     100.13    Snow  \n",
       "8780            9.7     100.03    Snow  \n",
       "8781            4.8      99.95    Snow  \n",
       "8782            9.7      99.91    Snow  \n",
       "8783           11.3      99.89    Snow  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "a1631a08",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(8784, 8)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "1588c9d6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RangeIndex(start=0, stop=8784, step=1)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "203c03a9",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date/Time            object\n",
       "Temp_C              float64\n",
       "Dew Point Temp_C    float64\n",
       "Rel Hum_%             int64\n",
       "Wind Speed_km/h       int64\n",
       "Visibility_km       float64\n",
       "Press_kPa           float64\n",
       "Weather              object\n",
       "dtype: object"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "7474cd52",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Fog', 'Freezing Drizzle,Fog', 'Mostly Cloudy', 'Cloudy', 'Rain',\n",
       "       'Rain Showers', 'Mainly Clear', 'Snow Showers', 'Snow', 'Clear',\n",
       "       'Freezing Rain,Fog', 'Freezing Rain', 'Freezing Drizzle',\n",
       "       'Rain,Snow', 'Moderate Snow', 'Freezing Drizzle,Snow',\n",
       "       'Freezing Rain,Snow Grains', 'Snow,Blowing Snow', 'Freezing Fog',\n",
       "       'Haze', 'Rain,Fog', 'Drizzle,Fog', 'Drizzle',\n",
       "       'Freezing Drizzle,Haze', 'Freezing Rain,Haze', 'Snow,Haze',\n",
       "       'Snow,Fog', 'Snow,Ice Pellets', 'Rain,Haze', 'Thunderstorms,Rain',\n",
       "       'Thunderstorms,Rain Showers', 'Thunderstorms,Heavy Rain Showers',\n",
       "       'Thunderstorms,Rain Showers,Fog', 'Thunderstorms',\n",
       "       'Thunderstorms,Rain,Fog',\n",
       "       'Thunderstorms,Moderate Rain Showers,Fog', 'Rain Showers,Fog',\n",
       "       'Rain Showers,Snow Showers', 'Snow Pellets', 'Rain,Snow,Fog',\n",
       "       'Moderate Rain,Fog', 'Freezing Rain,Ice Pellets,Fog',\n",
       "       'Drizzle,Ice Pellets,Fog', 'Drizzle,Snow', 'Rain,Ice Pellets',\n",
       "       'Drizzle,Snow,Fog', 'Rain,Snow Grains', 'Rain,Snow,Ice Pellets',\n",
       "       'Snow Showers,Fog', 'Moderate Snow,Blowing Snow'], dtype=object)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Weather'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "03d680f8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "50"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Weather'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "41dbb4ac",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date/Time           8784\n",
       "Temp_C              8784\n",
       "Dew Point Temp_C    8784\n",
       "Rel Hum_%           8784\n",
       "Wind Speed_km/h     8784\n",
       "Visibility_km       8784\n",
       "Press_kPa           8784\n",
       "Weather             8784\n",
       "dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "a384a5d7",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Mainly Clear                               2106\n",
       "Mostly Cloudy                              2069\n",
       "Cloudy                                     1728\n",
       "Clear                                      1326\n",
       "Snow                                        390\n",
       "Rain                                        306\n",
       "Rain Showers                                188\n",
       "Fog                                         150\n",
       "Rain,Fog                                    116\n",
       "Drizzle,Fog                                  80\n",
       "Snow Showers                                 60\n",
       "Drizzle                                      41\n",
       "Snow,Fog                                     37\n",
       "Snow,Blowing Snow                            19\n",
       "Rain,Snow                                    18\n",
       "Thunderstorms,Rain Showers                   16\n",
       "Haze                                         16\n",
       "Drizzle,Snow,Fog                             15\n",
       "Freezing Rain                                14\n",
       "Freezing Drizzle,Snow                        11\n",
       "Freezing Drizzle                              7\n",
       "Snow,Ice Pellets                              6\n",
       "Freezing Drizzle,Fog                          6\n",
       "Snow,Haze                                     5\n",
       "Snow Showers,Fog                              4\n",
       "Moderate Snow                                 4\n",
       "Freezing Fog                                  4\n",
       "Freezing Rain,Fog                             4\n",
       "Rain,Snow,Ice Pellets                         4\n",
       "Thunderstorms,Rain Showers,Fog                3\n",
       "Rain,Haze                                     3\n",
       "Freezing Drizzle,Haze                         3\n",
       "Thunderstorms,Rain                            3\n",
       "Drizzle,Snow                                  2\n",
       "Thunderstorms                                 2\n",
       "Freezing Rain,Haze                            2\n",
       "Moderate Snow,Blowing Snow                    2\n",
       "Rain Showers,Snow Showers                     2\n",
       "Moderate Rain,Fog                             1\n",
       "Freezing Rain,Snow Grains                     1\n",
       "Rain,Ice Pellets                              1\n",
       "Drizzle,Ice Pellets,Fog                       1\n",
       "Thunderstorms,Moderate Rain Showers,Fog       1\n",
       "Freezing Rain,Ice Pellets,Fog                 1\n",
       "Rain,Snow Grains                              1\n",
       "Thunderstorms,Rain,Fog                        1\n",
       "Rain,Snow,Fog                                 1\n",
       "Rain Showers,Fog                              1\n",
       "Thunderstorms,Heavy Rain Showers              1\n",
       "Snow Pellets                                  1\n",
       "Name: Weather, dtype: int64"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Weather'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "d150e2bf",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 8784 entries, 0 to 8783\n",
      "Data columns (total 8 columns):\n",
      " #   Column            Non-Null Count  Dtype  \n",
      "---  ------            --------------  -----  \n",
      " 0   Date/Time         8784 non-null   object \n",
      " 1   Temp_C            8784 non-null   float64\n",
      " 2   Dew Point Temp_C  8784 non-null   float64\n",
      " 3   Rel Hum_%         8784 non-null   int64  \n",
      " 4   Wind Speed_km/h   8784 non-null   int64  \n",
      " 5   Visibility_km     8784 non-null   float64\n",
      " 6   Press_kPa         8784 non-null   float64\n",
      " 7   Weather           8784 non-null   object \n",
      "dtypes: float64(4), int64(2), object(2)\n",
      "memory usage: 549.1+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "51b05456",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Date/Time', 'Temp_C', 'Dew Point Temp_C', 'Rel Hum_%',\n",
       "       'Wind Speed_km/h', 'Visibility_km', 'Press_kPa', 'Weather'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "0aeead47",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Date/Time', 'Temp_C', 'Dew Point Temp_C', 'Rel Hum_%',\n",
       "       'Wind Speed_km/h', 'Visibility_km', 'Press_kPa', 'Weather'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# find all the unique Wind Speed values in the data\n",
    "\n",
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "c70c1473",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date/Time           8784\n",
       "Temp_C               533\n",
       "Dew Point Temp_C     489\n",
       "Rel Hum_%             83\n",
       "Wind Speed_km/h       34\n",
       "Visibility_km         24\n",
       "Press_kPa            518\n",
       "Weather               50\n",
       "dtype: int64"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "7b0c1122",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "34"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Wind Speed_km/h'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "32a08294",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([ 4,  7,  6,  9, 15, 13, 20, 22, 19, 24, 30, 35, 39, 32, 33, 26, 44,\n",
       "       43, 48, 37, 28, 17, 11,  0, 83, 70, 57, 46, 41, 52, 50, 63, 54,  2],\n",
       "      dtype=int64)"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Wind Speed_km/h'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "7dae5817",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Mainly Clear                               2106\n",
       "Mostly Cloudy                              2069\n",
       "Cloudy                                     1728\n",
       "Clear                                      1326\n",
       "Snow                                        390\n",
       "Rain                                        306\n",
       "Rain Showers                                188\n",
       "Fog                                         150\n",
       "Rain,Fog                                    116\n",
       "Drizzle,Fog                                  80\n",
       "Snow Showers                                 60\n",
       "Drizzle                                      41\n",
       "Snow,Fog                                     37\n",
       "Snow,Blowing Snow                            19\n",
       "Rain,Snow                                    18\n",
       "Thunderstorms,Rain Showers                   16\n",
       "Haze                                         16\n",
       "Drizzle,Snow,Fog                             15\n",
       "Freezing Rain                                14\n",
       "Freezing Drizzle,Snow                        11\n",
       "Freezing Drizzle                              7\n",
       "Snow,Ice Pellets                              6\n",
       "Freezing Drizzle,Fog                          6\n",
       "Snow,Haze                                     5\n",
       "Snow Showers,Fog                              4\n",
       "Moderate Snow                                 4\n",
       "Freezing Fog                                  4\n",
       "Freezing Rain,Fog                             4\n",
       "Rain,Snow,Ice Pellets                         4\n",
       "Thunderstorms,Rain Showers,Fog                3\n",
       "Rain,Haze                                     3\n",
       "Freezing Drizzle,Haze                         3\n",
       "Thunderstorms,Rain                            3\n",
       "Drizzle,Snow                                  2\n",
       "Thunderstorms                                 2\n",
       "Freezing Rain,Haze                            2\n",
       "Moderate Snow,Blowing Snow                    2\n",
       "Rain Showers,Snow Showers                     2\n",
       "Moderate Rain,Fog                             1\n",
       "Freezing Rain,Snow Grains                     1\n",
       "Rain,Ice Pellets                              1\n",
       "Drizzle,Ice Pellets,Fog                       1\n",
       "Thunderstorms,Moderate Rain Showers,Fog       1\n",
       "Freezing Rain,Ice Pellets,Fog                 1\n",
       "Rain,Snow Grains                              1\n",
       "Thunderstorms,Rain,Fog                        1\n",
       "Rain,Snow,Fog                                 1\n",
       "Rain Showers,Fog                              1\n",
       "Thunderstorms,Heavy Rain Showers              1\n",
       "Snow Pellets                                  1\n",
       "Name: Weather, dtype: int64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Find the number of times when the Weather is exactly Clear\n",
    "\n",
    "\n",
    "df['Weather'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "f453f4de",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1326"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df[df['Weather']=='Clear'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "263d82fb",
   "metadata": {
    "scrolled": true
   },
   "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>Date/Time</th>\n",
       "      <th>Temp_C</th>\n",
       "      <th>Dew Point Temp_C</th>\n",
       "      <th>Rel Hum_%</th>\n",
       "      <th>Wind Speed_km/h</th>\n",
       "      <th>Visibility_km</th>\n",
       "      <th>Press_kPa</th>\n",
       "      <th>Weather</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>1/3/2012 19:00</td>\n",
       "      <td>-16.9</td>\n",
       "      <td>-24.8</td>\n",
       "      <td>50</td>\n",
       "      <td>24</td>\n",
       "      <td>25.0</td>\n",
       "      <td>101.74</td>\n",
       "      <td>Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>1/5/2012 18:00</td>\n",
       "      <td>-7.1</td>\n",
       "      <td>-14.4</td>\n",
       "      <td>56</td>\n",
       "      <td>11</td>\n",
       "      <td>25.0</td>\n",
       "      <td>100.71</td>\n",
       "      <td>Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>1/5/2012 19:00</td>\n",
       "      <td>-9.2</td>\n",
       "      <td>-15.4</td>\n",
       "      <td>61</td>\n",
       "      <td>7</td>\n",
       "      <td>25.0</td>\n",
       "      <td>100.80</td>\n",
       "      <td>Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>1/5/2012 20:00</td>\n",
       "      <td>-9.8</td>\n",
       "      <td>-15.7</td>\n",
       "      <td>62</td>\n",
       "      <td>9</td>\n",
       "      <td>25.0</td>\n",
       "      <td>100.83</td>\n",
       "      <td>Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>1/5/2012 21:00</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>-14.8</td>\n",
       "      <td>63</td>\n",
       "      <td>13</td>\n",
       "      <td>25.0</td>\n",
       "      <td>100.83</td>\n",
       "      <td>Clear</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8646</th>\n",
       "      <td>12/26/2012 6:00</td>\n",
       "      <td>-13.4</td>\n",
       "      <td>-14.8</td>\n",
       "      <td>89</td>\n",
       "      <td>4</td>\n",
       "      <td>25.0</td>\n",
       "      <td>102.47</td>\n",
       "      <td>Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8698</th>\n",
       "      <td>12/28/2012 10:00</td>\n",
       "      <td>-6.1</td>\n",
       "      <td>-8.6</td>\n",
       "      <td>82</td>\n",
       "      <td>19</td>\n",
       "      <td>24.1</td>\n",
       "      <td>101.27</td>\n",
       "      <td>Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8713</th>\n",
       "      <td>12/29/2012 1:00</td>\n",
       "      <td>-11.9</td>\n",
       "      <td>-13.6</td>\n",
       "      <td>87</td>\n",
       "      <td>11</td>\n",
       "      <td>25.0</td>\n",
       "      <td>101.31</td>\n",
       "      <td>Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8714</th>\n",
       "      <td>12/29/2012 2:00</td>\n",
       "      <td>-11.8</td>\n",
       "      <td>-13.1</td>\n",
       "      <td>90</td>\n",
       "      <td>13</td>\n",
       "      <td>25.0</td>\n",
       "      <td>101.33</td>\n",
       "      <td>Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8756</th>\n",
       "      <td>12/30/2012 20:00</td>\n",
       "      <td>-13.8</td>\n",
       "      <td>-16.5</td>\n",
       "      <td>80</td>\n",
       "      <td>24</td>\n",
       "      <td>25.0</td>\n",
       "      <td>101.52</td>\n",
       "      <td>Clear</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1326 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Date/Time  Temp_C  Dew Point Temp_C  Rel Hum_%  Wind Speed_km/h  \\\n",
       "67      1/3/2012 19:00   -16.9             -24.8         50               24   \n",
       "114     1/5/2012 18:00    -7.1             -14.4         56               11   \n",
       "115     1/5/2012 19:00    -9.2             -15.4         61                7   \n",
       "116     1/5/2012 20:00    -9.8             -15.7         62                9   \n",
       "117     1/5/2012 21:00    -9.0             -14.8         63               13   \n",
       "...                ...     ...               ...        ...              ...   \n",
       "8646   12/26/2012 6:00   -13.4             -14.8         89                4   \n",
       "8698  12/28/2012 10:00    -6.1              -8.6         82               19   \n",
       "8713   12/29/2012 1:00   -11.9             -13.6         87               11   \n",
       "8714   12/29/2012 2:00   -11.8             -13.1         90               13   \n",
       "8756  12/30/2012 20:00   -13.8             -16.5         80               24   \n",
       "\n",
       "      Visibility_km  Press_kPa Weather  \n",
       "67             25.0     101.74   Clear  \n",
       "114            25.0     100.71   Clear  \n",
       "115            25.0     100.80   Clear  \n",
       "116            25.0     100.83   Clear  \n",
       "117            25.0     100.83   Clear  \n",
       "...             ...        ...     ...  \n",
       "8646           25.0     102.47   Clear  \n",
       "8698           24.1     101.27   Clear  \n",
       "8713           25.0     101.31   Clear  \n",
       "8714           25.0     101.33   Clear  \n",
       "8756           25.0     101.52   Clear  \n",
       "\n",
       "[1326 rows x 8 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby('Weather').get_group('Clear')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f0f4cc19",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "542b3669",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Date/Time', 'Temp_C', 'Dew Point Temp_C', 'Rel Hum_%',\n",
       "       'Wind Speed_km/h', 'Visibility_km', 'Press_kPa', 'Weather'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# find the number of times when the Wind speed was exactly 4 km|h\n",
    "\n",
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "012dd4fc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "474"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df[df['Wind Speed_km/h']==4])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b6492281",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "9a2116f3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date/Time           0\n",
       "Temp_C              0\n",
       "Dew Point Temp_C    0\n",
       "Rel Hum_%           0\n",
       "Wind Speed_km/h     0\n",
       "Visibility_km       0\n",
       "Press_kPa           0\n",
       "Weather             0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# find out all the Null values in the data\n",
    "\n",
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f21459ed",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "a63acae5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Date/Time', 'Temp_C', 'Dew Point Temp_C', 'Rel Hum_%',\n",
       "       'Wind Speed_km/h', 'Visibility_km', 'Press_kPa', 'Weather'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Rename the column name Weather to the dataframe Weather Condition\n",
    "\n",
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "75c17e97",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "df.rename(columns = {'Weather' : 'Weather Condition'}, inplace= True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "29410c92",
   "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>Date/Time</th>\n",
       "      <th>Temp_C</th>\n",
       "      <th>Dew Point Temp_C</th>\n",
       "      <th>Rel Hum_%</th>\n",
       "      <th>Wind Speed_km/h</th>\n",
       "      <th>Visibility_km</th>\n",
       "      <th>Press_kPa</th>\n",
       "      <th>Weather Condition</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1/1/2012 0:00</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>-3.9</td>\n",
       "      <td>86</td>\n",
       "      <td>4</td>\n",
       "      <td>8.0</td>\n",
       "      <td>101.24</td>\n",
       "      <td>Fog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1/1/2012 1:00</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>-3.7</td>\n",
       "      <td>87</td>\n",
       "      <td>4</td>\n",
       "      <td>8.0</td>\n",
       "      <td>101.24</td>\n",
       "      <td>Fog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1/1/2012 2:00</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>-3.4</td>\n",
       "      <td>89</td>\n",
       "      <td>7</td>\n",
       "      <td>4.0</td>\n",
       "      <td>101.26</td>\n",
       "      <td>Freezing Drizzle,Fog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1/1/2012 3:00</td>\n",
       "      <td>-1.5</td>\n",
       "      <td>-3.2</td>\n",
       "      <td>88</td>\n",
       "      <td>6</td>\n",
       "      <td>4.0</td>\n",
       "      <td>101.27</td>\n",
       "      <td>Freezing Drizzle,Fog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1/1/2012 4:00</td>\n",
       "      <td>-1.5</td>\n",
       "      <td>-3.3</td>\n",
       "      <td>88</td>\n",
       "      <td>7</td>\n",
       "      <td>4.8</td>\n",
       "      <td>101.23</td>\n",
       "      <td>Fog</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Date/Time  Temp_C  Dew Point Temp_C  Rel Hum_%  Wind Speed_km/h  \\\n",
       "0  1/1/2012 0:00    -1.8              -3.9         86                4   \n",
       "1  1/1/2012 1:00    -1.8              -3.7         87                4   \n",
       "2  1/1/2012 2:00    -1.8              -3.4         89                7   \n",
       "3  1/1/2012 3:00    -1.5              -3.2         88                6   \n",
       "4  1/1/2012 4:00    -1.5              -3.3         88                7   \n",
       "\n",
       "   Visibility_km  Press_kPa     Weather Condition  \n",
       "0            8.0     101.24                   Fog  \n",
       "1            8.0     101.24                   Fog  \n",
       "2            4.0     101.26  Freezing Drizzle,Fog  \n",
       "3            4.0     101.27  Freezing Drizzle,Fog  \n",
       "4            4.8     101.23                   Fog  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "bbbd5fdf",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Date/Time', 'Temp_C', 'Dew Point Temp_C', 'Rel Hum_%',\n",
       "       'Wind Speed_km/h', 'Visibility_km', 'Press_kPa', 'Weather Condition'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# what is the mean visibility\n",
    "\n",
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "3da8e66a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "27.66444672131151"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Visibility_km'].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "10501604",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "27.66444672131151"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.Visibility_km.mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "71b1c821",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "70c9ede8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.8440047459486474"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# what is the standard deviation of Pressure in this data\n",
    "\n",
    "df.Press_kPa.std()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ce03f24a",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "823ad134",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "286.2485501984998"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# what is the variance of the relative humidty in this data\n",
    "\n",
    "df['Rel Hum_%'].var()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "26e2e2ae",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "dc796946",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Date/Time', 'Temp_C', 'Dew Point Temp_C', 'Rel Hum_%',\n",
       "       'Wind Speed_km/h', 'Visibility_km', 'Press_kPa', 'Weather Condition'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Find all instance when snow was recorded\n",
    "\n",
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "bdfb432f",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Mainly Clear                               2106\n",
       "Mostly Cloudy                              2069\n",
       "Cloudy                                     1728\n",
       "Clear                                      1326\n",
       "Snow                                        390\n",
       "Rain                                        306\n",
       "Rain Showers                                188\n",
       "Fog                                         150\n",
       "Rain,Fog                                    116\n",
       "Drizzle,Fog                                  80\n",
       "Snow Showers                                 60\n",
       "Drizzle                                      41\n",
       "Snow,Fog                                     37\n",
       "Snow,Blowing Snow                            19\n",
       "Rain,Snow                                    18\n",
       "Thunderstorms,Rain Showers                   16\n",
       "Haze                                         16\n",
       "Drizzle,Snow,Fog                             15\n",
       "Freezing Rain                                14\n",
       "Freezing Drizzle,Snow                        11\n",
       "Freezing Drizzle                              7\n",
       "Snow,Ice Pellets                              6\n",
       "Freezing Drizzle,Fog                          6\n",
       "Snow,Haze                                     5\n",
       "Snow Showers,Fog                              4\n",
       "Moderate Snow                                 4\n",
       "Freezing Fog                                  4\n",
       "Freezing Rain,Fog                             4\n",
       "Rain,Snow,Ice Pellets                         4\n",
       "Thunderstorms,Rain Showers,Fog                3\n",
       "Rain,Haze                                     3\n",
       "Freezing Drizzle,Haze                         3\n",
       "Thunderstorms,Rain                            3\n",
       "Drizzle,Snow                                  2\n",
       "Thunderstorms                                 2\n",
       "Freezing Rain,Haze                            2\n",
       "Moderate Snow,Blowing Snow                    2\n",
       "Rain Showers,Snow Showers                     2\n",
       "Moderate Rain,Fog                             1\n",
       "Freezing Rain,Snow Grains                     1\n",
       "Rain,Ice Pellets                              1\n",
       "Drizzle,Ice Pellets,Fog                       1\n",
       "Thunderstorms,Moderate Rain Showers,Fog       1\n",
       "Freezing Rain,Ice Pellets,Fog                 1\n",
       "Rain,Snow Grains                              1\n",
       "Thunderstorms,Rain,Fog                        1\n",
       "Rain,Snow,Fog                                 1\n",
       "Rain Showers,Fog                              1\n",
       "Thunderstorms,Heavy Rain Showers              1\n",
       "Snow Pellets                                  1\n",
       "Name: Weather Condition, dtype: int64"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Weather Condition'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "403c5e3d",
   "metadata": {
    "scrolled": true
   },
   "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>Date/Time</th>\n",
       "      <th>Temp_C</th>\n",
       "      <th>Dew Point Temp_C</th>\n",
       "      <th>Rel Hum_%</th>\n",
       "      <th>Wind Speed_km/h</th>\n",
       "      <th>Visibility_km</th>\n",
       "      <th>Press_kPa</th>\n",
       "      <th>Weather Condition</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>1/3/2012 7:00</td>\n",
       "      <td>-14.0</td>\n",
       "      <td>-19.5</td>\n",
       "      <td>63</td>\n",
       "      <td>19</td>\n",
       "      <td>25.0</td>\n",
       "      <td>100.95</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>1/4/2012 12:00</td>\n",
       "      <td>-13.7</td>\n",
       "      <td>-21.7</td>\n",
       "      <td>51</td>\n",
       "      <td>11</td>\n",
       "      <td>24.1</td>\n",
       "      <td>101.25</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>1/4/2012 14:00</td>\n",
       "      <td>-11.3</td>\n",
       "      <td>-19.0</td>\n",
       "      <td>53</td>\n",
       "      <td>7</td>\n",
       "      <td>19.3</td>\n",
       "      <td>100.97</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>1/4/2012 15:00</td>\n",
       "      <td>-10.2</td>\n",
       "      <td>-16.3</td>\n",
       "      <td>61</td>\n",
       "      <td>11</td>\n",
       "      <td>9.7</td>\n",
       "      <td>100.89</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>1/4/2012 16:00</td>\n",
       "      <td>-9.4</td>\n",
       "      <td>-15.5</td>\n",
       "      <td>61</td>\n",
       "      <td>13</td>\n",
       "      <td>19.3</td>\n",
       "      <td>100.79</td>\n",
       "      <td>Snow</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8779</th>\n",
       "      <td>12/31/2012 19:00</td>\n",
       "      <td>0.1</td>\n",
       "      <td>-2.7</td>\n",
       "      <td>81</td>\n",
       "      <td>30</td>\n",
       "      <td>9.7</td>\n",
       "      <td>100.13</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8780</th>\n",
       "      <td>12/31/2012 20:00</td>\n",
       "      <td>0.2</td>\n",
       "      <td>-2.4</td>\n",
       "      <td>83</td>\n",
       "      <td>24</td>\n",
       "      <td>9.7</td>\n",
       "      <td>100.03</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8781</th>\n",
       "      <td>12/31/2012 21:00</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>-1.5</td>\n",
       "      <td>93</td>\n",
       "      <td>28</td>\n",
       "      <td>4.8</td>\n",
       "      <td>99.95</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8782</th>\n",
       "      <td>12/31/2012 22:00</td>\n",
       "      <td>-0.2</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>89</td>\n",
       "      <td>28</td>\n",
       "      <td>9.7</td>\n",
       "      <td>99.91</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8783</th>\n",
       "      <td>12/31/2012 23:00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-2.1</td>\n",
       "      <td>86</td>\n",
       "      <td>30</td>\n",
       "      <td>11.3</td>\n",
       "      <td>99.89</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>390 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Date/Time  Temp_C  Dew Point Temp_C  Rel Hum_%  Wind Speed_km/h  \\\n",
       "55       1/3/2012 7:00   -14.0             -19.5         63               19   \n",
       "84      1/4/2012 12:00   -13.7             -21.7         51               11   \n",
       "86      1/4/2012 14:00   -11.3             -19.0         53                7   \n",
       "87      1/4/2012 15:00   -10.2             -16.3         61               11   \n",
       "88      1/4/2012 16:00    -9.4             -15.5         61               13   \n",
       "...                ...     ...               ...        ...              ...   \n",
       "8779  12/31/2012 19:00     0.1              -2.7         81               30   \n",
       "8780  12/31/2012 20:00     0.2              -2.4         83               24   \n",
       "8781  12/31/2012 21:00    -0.5              -1.5         93               28   \n",
       "8782  12/31/2012 22:00    -0.2              -1.8         89               28   \n",
       "8783  12/31/2012 23:00     0.0              -2.1         86               30   \n",
       "\n",
       "      Visibility_km  Press_kPa Weather Condition  \n",
       "55             25.0     100.95              Snow  \n",
       "84             24.1     101.25              Snow  \n",
       "86             19.3     100.97              Snow  \n",
       "87              9.7     100.89              Snow  \n",
       "88             19.3     100.79              Snow  \n",
       "...             ...        ...               ...  \n",
       "8779            9.7     100.13              Snow  \n",
       "8780            9.7     100.03              Snow  \n",
       "8781            4.8      99.95              Snow  \n",
       "8782            9.7      99.91              Snow  \n",
       "8783           11.3      99.89              Snow  \n",
       "\n",
       "[390 rows x 8 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Weather Condition']=='Snow']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "7bed568a",
   "metadata": {
    "scrolled": true
   },
   "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>Date/Time</th>\n",
       "      <th>Temp_C</th>\n",
       "      <th>Dew Point Temp_C</th>\n",
       "      <th>Rel Hum_%</th>\n",
       "      <th>Wind Speed_km/h</th>\n",
       "      <th>Visibility_km</th>\n",
       "      <th>Press_kPa</th>\n",
       "      <th>Weather Condition</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>1/2/2012 17:00</td>\n",
       "      <td>-2.1</td>\n",
       "      <td>-9.5</td>\n",
       "      <td>57</td>\n",
       "      <td>22</td>\n",
       "      <td>25.0</td>\n",
       "      <td>99.66</td>\n",
       "      <td>Snow Showers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>1/2/2012 20:00</td>\n",
       "      <td>-5.6</td>\n",
       "      <td>-13.4</td>\n",
       "      <td>54</td>\n",
       "      <td>24</td>\n",
       "      <td>25.0</td>\n",
       "      <td>100.07</td>\n",
       "      <td>Snow Showers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>1/2/2012 21:00</td>\n",
       "      <td>-5.8</td>\n",
       "      <td>-12.8</td>\n",
       "      <td>58</td>\n",
       "      <td>26</td>\n",
       "      <td>25.0</td>\n",
       "      <td>100.15</td>\n",
       "      <td>Snow Showers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>1/2/2012 23:00</td>\n",
       "      <td>-7.4</td>\n",
       "      <td>-14.1</td>\n",
       "      <td>59</td>\n",
       "      <td>17</td>\n",
       "      <td>19.3</td>\n",
       "      <td>100.27</td>\n",
       "      <td>Snow Showers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>1/3/2012 0:00</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>-16.0</td>\n",
       "      <td>57</td>\n",
       "      <td>28</td>\n",
       "      <td>25.0</td>\n",
       "      <td>100.35</td>\n",
       "      <td>Snow Showers</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8779</th>\n",
       "      <td>12/31/2012 19:00</td>\n",
       "      <td>0.1</td>\n",
       "      <td>-2.7</td>\n",
       "      <td>81</td>\n",
       "      <td>30</td>\n",
       "      <td>9.7</td>\n",
       "      <td>100.13</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8780</th>\n",
       "      <td>12/31/2012 20:00</td>\n",
       "      <td>0.2</td>\n",
       "      <td>-2.4</td>\n",
       "      <td>83</td>\n",
       "      <td>24</td>\n",
       "      <td>9.7</td>\n",
       "      <td>100.03</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8781</th>\n",
       "      <td>12/31/2012 21:00</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>-1.5</td>\n",
       "      <td>93</td>\n",
       "      <td>28</td>\n",
       "      <td>4.8</td>\n",
       "      <td>99.95</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8782</th>\n",
       "      <td>12/31/2012 22:00</td>\n",
       "      <td>-0.2</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>89</td>\n",
       "      <td>28</td>\n",
       "      <td>9.7</td>\n",
       "      <td>99.91</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8783</th>\n",
       "      <td>12/31/2012 23:00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-2.1</td>\n",
       "      <td>86</td>\n",
       "      <td>30</td>\n",
       "      <td>11.3</td>\n",
       "      <td>99.89</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>583 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Date/Time  Temp_C  Dew Point Temp_C  Rel Hum_%  Wind Speed_km/h  \\\n",
       "41      1/2/2012 17:00    -2.1              -9.5         57               22   \n",
       "44      1/2/2012 20:00    -5.6             -13.4         54               24   \n",
       "45      1/2/2012 21:00    -5.8             -12.8         58               26   \n",
       "47      1/2/2012 23:00    -7.4             -14.1         59               17   \n",
       "48       1/3/2012 0:00    -9.0             -16.0         57               28   \n",
       "...                ...     ...               ...        ...              ...   \n",
       "8779  12/31/2012 19:00     0.1              -2.7         81               30   \n",
       "8780  12/31/2012 20:00     0.2              -2.4         83               24   \n",
       "8781  12/31/2012 21:00    -0.5              -1.5         93               28   \n",
       "8782  12/31/2012 22:00    -0.2              -1.8         89               28   \n",
       "8783  12/31/2012 23:00     0.0              -2.1         86               30   \n",
       "\n",
       "      Visibility_km  Press_kPa Weather Condition  \n",
       "41             25.0      99.66      Snow Showers  \n",
       "44             25.0     100.07      Snow Showers  \n",
       "45             25.0     100.15      Snow Showers  \n",
       "47             19.3     100.27      Snow Showers  \n",
       "48             25.0     100.35      Snow Showers  \n",
       "...             ...        ...               ...  \n",
       "8779            9.7     100.13              Snow  \n",
       "8780            9.7     100.03              Snow  \n",
       "8781            4.8      99.95              Snow  \n",
       "8782            9.7      99.91              Snow  \n",
       "8783           11.3      99.89              Snow  \n",
       "\n",
       "[583 rows x 8 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Weather Condition'].str.contains('Snow')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "93dd20d9",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "50af68e9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Date/Time', 'Temp_C', 'Dew Point Temp_C', 'Rel Hum_%',\n",
       "       'Wind Speed_km/h', 'Visibility_km', 'Press_kPa', 'Weather Condition'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# find all instance when wind speed is above 24 and visibility is 25\n",
    "\n",
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "5d1b0e1a",
   "metadata": {
    "scrolled": true
   },
   "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>Date/Time</th>\n",
       "      <th>Temp_C</th>\n",
       "      <th>Dew Point Temp_C</th>\n",
       "      <th>Rel Hum_%</th>\n",
       "      <th>Wind Speed_km/h</th>\n",
       "      <th>Visibility_km</th>\n",
       "      <th>Press_kPa</th>\n",
       "      <th>Weather Condition</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1/1/2012 23:00</td>\n",
       "      <td>5.3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>79</td>\n",
       "      <td>30</td>\n",
       "      <td>25.0</td>\n",
       "      <td>99.31</td>\n",
       "      <td>Cloudy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1/2/2012 0:00</td>\n",
       "      <td>5.2</td>\n",
       "      <td>1.5</td>\n",
       "      <td>77</td>\n",
       "      <td>35</td>\n",
       "      <td>25.0</td>\n",
       "      <td>99.26</td>\n",
       "      <td>Rain Showers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1/2/2012 1:00</td>\n",
       "      <td>4.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>72</td>\n",
       "      <td>39</td>\n",
       "      <td>25.0</td>\n",
       "      <td>99.26</td>\n",
       "      <td>Cloudy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1/2/2012 2:00</td>\n",
       "      <td>3.9</td>\n",
       "      <td>-0.9</td>\n",
       "      <td>71</td>\n",
       "      <td>32</td>\n",
       "      <td>25.0</td>\n",
       "      <td>99.26</td>\n",
       "      <td>Mostly Cloudy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1/2/2012 3:00</td>\n",
       "      <td>3.7</td>\n",
       "      <td>-1.5</td>\n",
       "      <td>69</td>\n",
       "      <td>33</td>\n",
       "      <td>25.0</td>\n",
       "      <td>99.30</td>\n",
       "      <td>Mostly Cloudy</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8754</th>\n",
       "      <td>12/30/2012 18:00</td>\n",
       "      <td>-12.6</td>\n",
       "      <td>-16.0</td>\n",
       "      <td>76</td>\n",
       "      <td>24</td>\n",
       "      <td>25.0</td>\n",
       "      <td>101.36</td>\n",
       "      <td>Mainly Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8755</th>\n",
       "      <td>12/30/2012 19:00</td>\n",
       "      <td>-13.4</td>\n",
       "      <td>-16.5</td>\n",
       "      <td>77</td>\n",
       "      <td>26</td>\n",
       "      <td>25.0</td>\n",
       "      <td>101.47</td>\n",
       "      <td>Mainly Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8756</th>\n",
       "      <td>12/30/2012 20:00</td>\n",
       "      <td>-13.8</td>\n",
       "      <td>-16.5</td>\n",
       "      <td>80</td>\n",
       "      <td>24</td>\n",
       "      <td>25.0</td>\n",
       "      <td>101.52</td>\n",
       "      <td>Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8759</th>\n",
       "      <td>12/30/2012 23:00</td>\n",
       "      <td>-12.1</td>\n",
       "      <td>-15.1</td>\n",
       "      <td>78</td>\n",
       "      <td>28</td>\n",
       "      <td>25.0</td>\n",
       "      <td>101.52</td>\n",
       "      <td>Mostly Cloudy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8760</th>\n",
       "      <td>12/31/2012 0:00</td>\n",
       "      <td>-11.1</td>\n",
       "      <td>-14.4</td>\n",
       "      <td>77</td>\n",
       "      <td>26</td>\n",
       "      <td>25.0</td>\n",
       "      <td>101.51</td>\n",
       "      <td>Cloudy</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>415 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Date/Time  Temp_C  Dew Point Temp_C  Rel Hum_%  Wind Speed_km/h  \\\n",
       "23      1/1/2012 23:00     5.3               2.0         79               30   \n",
       "24       1/2/2012 0:00     5.2               1.5         77               35   \n",
       "25       1/2/2012 1:00     4.6               0.0         72               39   \n",
       "26       1/2/2012 2:00     3.9              -0.9         71               32   \n",
       "27       1/2/2012 3:00     3.7              -1.5         69               33   \n",
       "...                ...     ...               ...        ...              ...   \n",
       "8754  12/30/2012 18:00   -12.6             -16.0         76               24   \n",
       "8755  12/30/2012 19:00   -13.4             -16.5         77               26   \n",
       "8756  12/30/2012 20:00   -13.8             -16.5         80               24   \n",
       "8759  12/30/2012 23:00   -12.1             -15.1         78               28   \n",
       "8760   12/31/2012 0:00   -11.1             -14.4         77               26   \n",
       "\n",
       "      Visibility_km  Press_kPa Weather Condition  \n",
       "23             25.0      99.31            Cloudy  \n",
       "24             25.0      99.26      Rain Showers  \n",
       "25             25.0      99.26            Cloudy  \n",
       "26             25.0      99.26     Mostly Cloudy  \n",
       "27             25.0      99.30     Mostly Cloudy  \n",
       "...             ...        ...               ...  \n",
       "8754           25.0     101.36      Mainly Clear  \n",
       "8755           25.0     101.47      Mainly Clear  \n",
       "8756           25.0     101.52             Clear  \n",
       "8759           25.0     101.52     Mostly Cloudy  \n",
       "8760           25.0     101.51            Cloudy  \n",
       "\n",
       "[415 rows x 8 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[(df['Wind Speed_km/h']>=24) & (df['Visibility_km']==25)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4fd62eeb",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "a4696bdc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Date/Time', 'Temp_C', 'Dew Point Temp_C', 'Rel Hum_%',\n",
       "       'Wind Speed_km/h', 'Visibility_km', 'Press_kPa', 'Weather Condition'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# what is the mean value of each column against each weather condition\n",
    "\n",
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "85f71901",
   "metadata": {
    "scrolled": true
   },
   "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>Temp_C</th>\n",
       "      <th>Dew Point Temp_C</th>\n",
       "      <th>Rel Hum_%</th>\n",
       "      <th>Wind Speed_km/h</th>\n",
       "      <th>Visibility_km</th>\n",
       "      <th>Press_kPa</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Weather Condition</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Clear</th>\n",
       "      <td>6.825716</td>\n",
       "      <td>0.089367</td>\n",
       "      <td>64.497738</td>\n",
       "      <td>10.557315</td>\n",
       "      <td>30.153243</td>\n",
       "      <td>101.587443</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cloudy</th>\n",
       "      <td>7.970544</td>\n",
       "      <td>2.375810</td>\n",
       "      <td>69.592593</td>\n",
       "      <td>16.127315</td>\n",
       "      <td>26.625752</td>\n",
       "      <td>100.911441</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drizzle</th>\n",
       "      <td>7.353659</td>\n",
       "      <td>5.504878</td>\n",
       "      <td>88.243902</td>\n",
       "      <td>16.097561</td>\n",
       "      <td>17.931707</td>\n",
       "      <td>100.435366</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drizzle,Fog</th>\n",
       "      <td>8.067500</td>\n",
       "      <td>7.033750</td>\n",
       "      <td>93.275000</td>\n",
       "      <td>11.862500</td>\n",
       "      <td>5.257500</td>\n",
       "      <td>100.786625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drizzle,Ice Pellets,Fog</th>\n",
       "      <td>0.400000</td>\n",
       "      <td>-0.700000</td>\n",
       "      <td>92.000000</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>100.790000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drizzle,Snow</th>\n",
       "      <td>1.050000</td>\n",
       "      <td>0.150000</td>\n",
       "      <td>93.500000</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>10.500000</td>\n",
       "      <td>100.890000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drizzle,Snow,Fog</th>\n",
       "      <td>0.693333</td>\n",
       "      <td>0.120000</td>\n",
       "      <td>95.866667</td>\n",
       "      <td>15.533333</td>\n",
       "      <td>5.513333</td>\n",
       "      <td>99.281333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fog</th>\n",
       "      <td>4.303333</td>\n",
       "      <td>3.159333</td>\n",
       "      <td>92.286667</td>\n",
       "      <td>7.946667</td>\n",
       "      <td>6.248000</td>\n",
       "      <td>101.184067</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Drizzle</th>\n",
       "      <td>-5.657143</td>\n",
       "      <td>-8.000000</td>\n",
       "      <td>83.571429</td>\n",
       "      <td>16.571429</td>\n",
       "      <td>9.200000</td>\n",
       "      <td>100.202857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Drizzle,Fog</th>\n",
       "      <td>-2.533333</td>\n",
       "      <td>-4.183333</td>\n",
       "      <td>88.500000</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>5.266667</td>\n",
       "      <td>100.441667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Drizzle,Haze</th>\n",
       "      <td>-5.433333</td>\n",
       "      <td>-8.000000</td>\n",
       "      <td>82.000000</td>\n",
       "      <td>10.333333</td>\n",
       "      <td>2.666667</td>\n",
       "      <td>100.316667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Drizzle,Snow</th>\n",
       "      <td>-5.109091</td>\n",
       "      <td>-7.072727</td>\n",
       "      <td>86.090909</td>\n",
       "      <td>16.272727</td>\n",
       "      <td>5.872727</td>\n",
       "      <td>100.520909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Fog</th>\n",
       "      <td>-7.575000</td>\n",
       "      <td>-9.250000</td>\n",
       "      <td>87.750000</td>\n",
       "      <td>4.750000</td>\n",
       "      <td>0.650000</td>\n",
       "      <td>102.320000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Rain</th>\n",
       "      <td>-3.885714</td>\n",
       "      <td>-6.078571</td>\n",
       "      <td>84.642857</td>\n",
       "      <td>19.214286</td>\n",
       "      <td>8.242857</td>\n",
       "      <td>99.647143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Rain,Fog</th>\n",
       "      <td>-2.225000</td>\n",
       "      <td>-3.750000</td>\n",
       "      <td>89.500000</td>\n",
       "      <td>15.500000</td>\n",
       "      <td>7.550000</td>\n",
       "      <td>99.945000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Rain,Haze</th>\n",
       "      <td>-4.900000</td>\n",
       "      <td>-7.450000</td>\n",
       "      <td>82.500000</td>\n",
       "      <td>7.500000</td>\n",
       "      <td>2.400000</td>\n",
       "      <td>100.375000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Rain,Ice Pellets,Fog</th>\n",
       "      <td>-2.600000</td>\n",
       "      <td>-3.700000</td>\n",
       "      <td>92.000000</td>\n",
       "      <td>28.000000</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>100.950000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Rain,Snow Grains</th>\n",
       "      <td>-5.000000</td>\n",
       "      <td>-7.300000</td>\n",
       "      <td>84.000000</td>\n",
       "      <td>32.000000</td>\n",
       "      <td>4.800000</td>\n",
       "      <td>98.560000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Haze</th>\n",
       "      <td>-0.200000</td>\n",
       "      <td>-2.975000</td>\n",
       "      <td>81.625000</td>\n",
       "      <td>10.437500</td>\n",
       "      <td>7.831250</td>\n",
       "      <td>101.482500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mainly Clear</th>\n",
       "      <td>12.558927</td>\n",
       "      <td>4.581671</td>\n",
       "      <td>60.667142</td>\n",
       "      <td>14.144824</td>\n",
       "      <td>34.264862</td>\n",
       "      <td>101.248832</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Moderate Rain,Fog</th>\n",
       "      <td>1.700000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>94.000000</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>6.400000</td>\n",
       "      <td>99.980000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Moderate Snow</th>\n",
       "      <td>-5.525000</td>\n",
       "      <td>-7.250000</td>\n",
       "      <td>87.750000</td>\n",
       "      <td>33.750000</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>100.275000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Moderate Snow,Blowing Snow</th>\n",
       "      <td>-5.450000</td>\n",
       "      <td>-6.500000</td>\n",
       "      <td>92.500000</td>\n",
       "      <td>40.000000</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>100.570000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mostly Cloudy</th>\n",
       "      <td>10.574287</td>\n",
       "      <td>3.131174</td>\n",
       "      <td>62.102465</td>\n",
       "      <td>15.813920</td>\n",
       "      <td>31.253842</td>\n",
       "      <td>101.025288</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain</th>\n",
       "      <td>9.786275</td>\n",
       "      <td>7.042810</td>\n",
       "      <td>83.624183</td>\n",
       "      <td>19.254902</td>\n",
       "      <td>18.856536</td>\n",
       "      <td>100.233333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain Showers</th>\n",
       "      <td>13.722340</td>\n",
       "      <td>9.187766</td>\n",
       "      <td>75.159574</td>\n",
       "      <td>17.132979</td>\n",
       "      <td>22.816489</td>\n",
       "      <td>100.404043</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain Showers,Fog</th>\n",
       "      <td>12.800000</td>\n",
       "      <td>12.100000</td>\n",
       "      <td>96.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>6.400000</td>\n",
       "      <td>99.830000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain Showers,Snow Showers</th>\n",
       "      <td>2.150000</td>\n",
       "      <td>-1.500000</td>\n",
       "      <td>76.500000</td>\n",
       "      <td>22.500000</td>\n",
       "      <td>21.700000</td>\n",
       "      <td>101.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain,Fog</th>\n",
       "      <td>8.273276</td>\n",
       "      <td>7.219828</td>\n",
       "      <td>93.189655</td>\n",
       "      <td>14.793103</td>\n",
       "      <td>6.873276</td>\n",
       "      <td>100.500862</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain,Haze</th>\n",
       "      <td>4.633333</td>\n",
       "      <td>2.066667</td>\n",
       "      <td>83.333333</td>\n",
       "      <td>11.666667</td>\n",
       "      <td>6.700000</td>\n",
       "      <td>100.540000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain,Ice Pellets</th>\n",
       "      <td>0.600000</td>\n",
       "      <td>-0.600000</td>\n",
       "      <td>92.000000</td>\n",
       "      <td>24.000000</td>\n",
       "      <td>9.700000</td>\n",
       "      <td>100.120000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain,Snow</th>\n",
       "      <td>1.055556</td>\n",
       "      <td>-0.566667</td>\n",
       "      <td>89.000000</td>\n",
       "      <td>28.388889</td>\n",
       "      <td>11.672222</td>\n",
       "      <td>99.951111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain,Snow Grains</th>\n",
       "      <td>1.900000</td>\n",
       "      <td>-2.100000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>100.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain,Snow,Fog</th>\n",
       "      <td>0.800000</td>\n",
       "      <td>0.300000</td>\n",
       "      <td>96.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>6.400000</td>\n",
       "      <td>100.730000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain,Snow,Ice Pellets</th>\n",
       "      <td>1.100000</td>\n",
       "      <td>-0.175000</td>\n",
       "      <td>91.500000</td>\n",
       "      <td>23.250000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>100.105000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow</th>\n",
       "      <td>-4.524103</td>\n",
       "      <td>-7.623333</td>\n",
       "      <td>79.307692</td>\n",
       "      <td>20.038462</td>\n",
       "      <td>11.171795</td>\n",
       "      <td>100.536103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow Pellets</th>\n",
       "      <td>0.700000</td>\n",
       "      <td>-6.400000</td>\n",
       "      <td>59.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>2.400000</td>\n",
       "      <td>99.700000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow Showers</th>\n",
       "      <td>-3.506667</td>\n",
       "      <td>-7.866667</td>\n",
       "      <td>72.350000</td>\n",
       "      <td>19.233333</td>\n",
       "      <td>20.158333</td>\n",
       "      <td>100.963500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow Showers,Fog</th>\n",
       "      <td>-10.675000</td>\n",
       "      <td>-11.900000</td>\n",
       "      <td>90.750000</td>\n",
       "      <td>13.750000</td>\n",
       "      <td>7.025000</td>\n",
       "      <td>101.292500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow,Blowing Snow</th>\n",
       "      <td>-5.410526</td>\n",
       "      <td>-7.621053</td>\n",
       "      <td>84.473684</td>\n",
       "      <td>34.842105</td>\n",
       "      <td>4.105263</td>\n",
       "      <td>99.704737</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow,Fog</th>\n",
       "      <td>-5.075676</td>\n",
       "      <td>-6.364865</td>\n",
       "      <td>90.675676</td>\n",
       "      <td>17.324324</td>\n",
       "      <td>4.537838</td>\n",
       "      <td>100.688649</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow,Haze</th>\n",
       "      <td>-4.020000</td>\n",
       "      <td>-6.860000</td>\n",
       "      <td>80.600000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>4.640000</td>\n",
       "      <td>100.782000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow,Ice Pellets</th>\n",
       "      <td>-1.883333</td>\n",
       "      <td>-3.666667</td>\n",
       "      <td>87.666667</td>\n",
       "      <td>23.833333</td>\n",
       "      <td>7.416667</td>\n",
       "      <td>100.548333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thunderstorms</th>\n",
       "      <td>24.150000</td>\n",
       "      <td>19.750000</td>\n",
       "      <td>77.000000</td>\n",
       "      <td>7.500000</td>\n",
       "      <td>24.550000</td>\n",
       "      <td>100.230000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thunderstorms,Heavy Rain Showers</th>\n",
       "      <td>10.900000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>88.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>2.400000</td>\n",
       "      <td>100.260000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thunderstorms,Moderate Rain Showers,Fog</th>\n",
       "      <td>19.600000</td>\n",
       "      <td>18.500000</td>\n",
       "      <td>93.000000</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>3.200000</td>\n",
       "      <td>100.010000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thunderstorms,Rain</th>\n",
       "      <td>20.433333</td>\n",
       "      <td>18.533333</td>\n",
       "      <td>89.000000</td>\n",
       "      <td>15.666667</td>\n",
       "      <td>19.833333</td>\n",
       "      <td>100.420000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thunderstorms,Rain Showers</th>\n",
       "      <td>20.037500</td>\n",
       "      <td>17.618750</td>\n",
       "      <td>86.375000</td>\n",
       "      <td>18.312500</td>\n",
       "      <td>15.893750</td>\n",
       "      <td>100.233750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thunderstorms,Rain Showers,Fog</th>\n",
       "      <td>21.600000</td>\n",
       "      <td>18.700000</td>\n",
       "      <td>84.000000</td>\n",
       "      <td>19.666667</td>\n",
       "      <td>9.700000</td>\n",
       "      <td>100.063333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thunderstorms,Rain,Fog</th>\n",
       "      <td>20.600000</td>\n",
       "      <td>18.600000</td>\n",
       "      <td>88.000000</td>\n",
       "      <td>19.000000</td>\n",
       "      <td>4.800000</td>\n",
       "      <td>100.080000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            Temp_C  Dew Point Temp_C  \\\n",
       "Weather Condition                                                      \n",
       "Clear                                     6.825716          0.089367   \n",
       "Cloudy                                    7.970544          2.375810   \n",
       "Drizzle                                   7.353659          5.504878   \n",
       "Drizzle,Fog                               8.067500          7.033750   \n",
       "Drizzle,Ice Pellets,Fog                   0.400000         -0.700000   \n",
       "Drizzle,Snow                              1.050000          0.150000   \n",
       "Drizzle,Snow,Fog                          0.693333          0.120000   \n",
       "Fog                                       4.303333          3.159333   \n",
       "Freezing Drizzle                         -5.657143         -8.000000   \n",
       "Freezing Drizzle,Fog                     -2.533333         -4.183333   \n",
       "Freezing Drizzle,Haze                    -5.433333         -8.000000   \n",
       "Freezing Drizzle,Snow                    -5.109091         -7.072727   \n",
       "Freezing Fog                             -7.575000         -9.250000   \n",
       "Freezing Rain                            -3.885714         -6.078571   \n",
       "Freezing Rain,Fog                        -2.225000         -3.750000   \n",
       "Freezing Rain,Haze                       -4.900000         -7.450000   \n",
       "Freezing Rain,Ice Pellets,Fog            -2.600000         -3.700000   \n",
       "Freezing Rain,Snow Grains                -5.000000         -7.300000   \n",
       "Haze                                     -0.200000         -2.975000   \n",
       "Mainly Clear                             12.558927          4.581671   \n",
       "Moderate Rain,Fog                         1.700000          0.800000   \n",
       "Moderate Snow                            -5.525000         -7.250000   \n",
       "Moderate Snow,Blowing Snow               -5.450000         -6.500000   \n",
       "Mostly Cloudy                            10.574287          3.131174   \n",
       "Rain                                      9.786275          7.042810   \n",
       "Rain Showers                             13.722340          9.187766   \n",
       "Rain Showers,Fog                         12.800000         12.100000   \n",
       "Rain Showers,Snow Showers                 2.150000         -1.500000   \n",
       "Rain,Fog                                  8.273276          7.219828   \n",
       "Rain,Haze                                 4.633333          2.066667   \n",
       "Rain,Ice Pellets                          0.600000         -0.600000   \n",
       "Rain,Snow                                 1.055556         -0.566667   \n",
       "Rain,Snow Grains                          1.900000         -2.100000   \n",
       "Rain,Snow,Fog                             0.800000          0.300000   \n",
       "Rain,Snow,Ice Pellets                     1.100000         -0.175000   \n",
       "Snow                                     -4.524103         -7.623333   \n",
       "Snow Pellets                              0.700000         -6.400000   \n",
       "Snow Showers                             -3.506667         -7.866667   \n",
       "Snow Showers,Fog                        -10.675000        -11.900000   \n",
       "Snow,Blowing Snow                        -5.410526         -7.621053   \n",
       "Snow,Fog                                 -5.075676         -6.364865   \n",
       "Snow,Haze                                -4.020000         -6.860000   \n",
       "Snow,Ice Pellets                         -1.883333         -3.666667   \n",
       "Thunderstorms                            24.150000         19.750000   \n",
       "Thunderstorms,Heavy Rain Showers         10.900000          9.000000   \n",
       "Thunderstorms,Moderate Rain Showers,Fog  19.600000         18.500000   \n",
       "Thunderstorms,Rain                       20.433333         18.533333   \n",
       "Thunderstorms,Rain Showers               20.037500         17.618750   \n",
       "Thunderstorms,Rain Showers,Fog           21.600000         18.700000   \n",
       "Thunderstorms,Rain,Fog                   20.600000         18.600000   \n",
       "\n",
       "                                         Rel Hum_%  Wind Speed_km/h  \\\n",
       "Weather Condition                                                     \n",
       "Clear                                    64.497738        10.557315   \n",
       "Cloudy                                   69.592593        16.127315   \n",
       "Drizzle                                  88.243902        16.097561   \n",
       "Drizzle,Fog                              93.275000        11.862500   \n",
       "Drizzle,Ice Pellets,Fog                  92.000000        20.000000   \n",
       "Drizzle,Snow                             93.500000        14.000000   \n",
       "Drizzle,Snow,Fog                         95.866667        15.533333   \n",
       "Fog                                      92.286667         7.946667   \n",
       "Freezing Drizzle                         83.571429        16.571429   \n",
       "Freezing Drizzle,Fog                     88.500000        17.000000   \n",
       "Freezing Drizzle,Haze                    82.000000        10.333333   \n",
       "Freezing Drizzle,Snow                    86.090909        16.272727   \n",
       "Freezing Fog                             87.750000         4.750000   \n",
       "Freezing Rain                            84.642857        19.214286   \n",
       "Freezing Rain,Fog                        89.500000        15.500000   \n",
       "Freezing Rain,Haze                       82.500000         7.500000   \n",
       "Freezing Rain,Ice Pellets,Fog            92.000000        28.000000   \n",
       "Freezing Rain,Snow Grains                84.000000        32.000000   \n",
       "Haze                                     81.625000        10.437500   \n",
       "Mainly Clear                             60.667142        14.144824   \n",
       "Moderate Rain,Fog                        94.000000        17.000000   \n",
       "Moderate Snow                            87.750000        33.750000   \n",
       "Moderate Snow,Blowing Snow               92.500000        40.000000   \n",
       "Mostly Cloudy                            62.102465        15.813920   \n",
       "Rain                                     83.624183        19.254902   \n",
       "Rain Showers                             75.159574        17.132979   \n",
       "Rain Showers,Fog                         96.000000        13.000000   \n",
       "Rain Showers,Snow Showers                76.500000        22.500000   \n",
       "Rain,Fog                                 93.189655        14.793103   \n",
       "Rain,Haze                                83.333333        11.666667   \n",
       "Rain,Ice Pellets                         92.000000        24.000000   \n",
       "Rain,Snow                                89.000000        28.388889   \n",
       "Rain,Snow Grains                         75.000000        26.000000   \n",
       "Rain,Snow,Fog                            96.000000         9.000000   \n",
       "Rain,Snow,Ice Pellets                    91.500000        23.250000   \n",
       "Snow                                     79.307692        20.038462   \n",
       "Snow Pellets                             59.000000        35.000000   \n",
       "Snow Showers                             72.350000        19.233333   \n",
       "Snow Showers,Fog                         90.750000        13.750000   \n",
       "Snow,Blowing Snow                        84.473684        34.842105   \n",
       "Snow,Fog                                 90.675676        17.324324   \n",
       "Snow,Haze                                80.600000         5.000000   \n",
       "Snow,Ice Pellets                         87.666667        23.833333   \n",
       "Thunderstorms                            77.000000         7.500000   \n",
       "Thunderstorms,Heavy Rain Showers         88.000000         9.000000   \n",
       "Thunderstorms,Moderate Rain Showers,Fog  93.000000        15.000000   \n",
       "Thunderstorms,Rain                       89.000000        15.666667   \n",
       "Thunderstorms,Rain Showers               86.375000        18.312500   \n",
       "Thunderstorms,Rain Showers,Fog           84.000000        19.666667   \n",
       "Thunderstorms,Rain,Fog                   88.000000        19.000000   \n",
       "\n",
       "                                         Visibility_km   Press_kPa  \n",
       "Weather Condition                                                   \n",
       "Clear                                        30.153243  101.587443  \n",
       "Cloudy                                       26.625752  100.911441  \n",
       "Drizzle                                      17.931707  100.435366  \n",
       "Drizzle,Fog                                   5.257500  100.786625  \n",
       "Drizzle,Ice Pellets,Fog                       4.000000  100.790000  \n",
       "Drizzle,Snow                                 10.500000  100.890000  \n",
       "Drizzle,Snow,Fog                              5.513333   99.281333  \n",
       "Fog                                           6.248000  101.184067  \n",
       "Freezing Drizzle                              9.200000  100.202857  \n",
       "Freezing Drizzle,Fog                          5.266667  100.441667  \n",
       "Freezing Drizzle,Haze                         2.666667  100.316667  \n",
       "Freezing Drizzle,Snow                         5.872727  100.520909  \n",
       "Freezing Fog                                  0.650000  102.320000  \n",
       "Freezing Rain                                 8.242857   99.647143  \n",
       "Freezing Rain,Fog                             7.550000   99.945000  \n",
       "Freezing Rain,Haze                            2.400000  100.375000  \n",
       "Freezing Rain,Ice Pellets,Fog                 8.000000  100.950000  \n",
       "Freezing Rain,Snow Grains                     4.800000   98.560000  \n",
       "Haze                                          7.831250  101.482500  \n",
       "Mainly Clear                                 34.264862  101.248832  \n",
       "Moderate Rain,Fog                             6.400000   99.980000  \n",
       "Moderate Snow                                 0.750000  100.275000  \n",
       "Moderate Snow,Blowing Snow                    0.600000  100.570000  \n",
       "Mostly Cloudy                                31.253842  101.025288  \n",
       "Rain                                         18.856536  100.233333  \n",
       "Rain Showers                                 22.816489  100.404043  \n",
       "Rain Showers,Fog                              6.400000   99.830000  \n",
       "Rain Showers,Snow Showers                    21.700000  101.100000  \n",
       "Rain,Fog                                      6.873276  100.500862  \n",
       "Rain,Haze                                     6.700000  100.540000  \n",
       "Rain,Ice Pellets                              9.700000  100.120000  \n",
       "Rain,Snow                                    11.672222   99.951111  \n",
       "Rain,Snow Grains                             25.000000  100.600000  \n",
       "Rain,Snow,Fog                                 6.400000  100.730000  \n",
       "Rain,Snow,Ice Pellets                         6.000000  100.105000  \n",
       "Snow                                         11.171795  100.536103  \n",
       "Snow Pellets                                  2.400000   99.700000  \n",
       "Snow Showers                                 20.158333  100.963500  \n",
       "Snow Showers,Fog                              7.025000  101.292500  \n",
       "Snow,Blowing Snow                             4.105263   99.704737  \n",
       "Snow,Fog                                      4.537838  100.688649  \n",
       "Snow,Haze                                     4.640000  100.782000  \n",
       "Snow,Ice Pellets                              7.416667  100.548333  \n",
       "Thunderstorms                                24.550000  100.230000  \n",
       "Thunderstorms,Heavy Rain Showers              2.400000  100.260000  \n",
       "Thunderstorms,Moderate Rain Showers,Fog       3.200000  100.010000  \n",
       "Thunderstorms,Rain                           19.833333  100.420000  \n",
       "Thunderstorms,Rain Showers                   15.893750  100.233750  \n",
       "Thunderstorms,Rain Showers,Fog                9.700000  100.063333  \n",
       "Thunderstorms,Rain,Fog                        4.800000  100.080000  "
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby('Weather Condition').mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "81659d37",
   "metadata": {
    "scrolled": true
   },
   "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>Date/Time</th>\n",
       "      <th>Temp_C</th>\n",
       "      <th>Dew Point Temp_C</th>\n",
       "      <th>Rel Hum_%</th>\n",
       "      <th>Wind Speed_km/h</th>\n",
       "      <th>Visibility_km</th>\n",
       "      <th>Press_kPa</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Weather Condition</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Clear</th>\n",
       "      <td>9/9/2012 5:00</td>\n",
       "      <td>32.8</td>\n",
       "      <td>20.4</td>\n",
       "      <td>99</td>\n",
       "      <td>33</td>\n",
       "      <td>48.3</td>\n",
       "      <td>103.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cloudy</th>\n",
       "      <td>9/9/2012 23:00</td>\n",
       "      <td>30.5</td>\n",
       "      <td>22.6</td>\n",
       "      <td>99</td>\n",
       "      <td>54</td>\n",
       "      <td>48.3</td>\n",
       "      <td>103.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drizzle</th>\n",
       "      <td>9/30/2012 3:00</td>\n",
       "      <td>18.8</td>\n",
       "      <td>17.7</td>\n",
       "      <td>96</td>\n",
       "      <td>30</td>\n",
       "      <td>25.0</td>\n",
       "      <td>101.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drizzle,Fog</th>\n",
       "      <td>9/30/2012 2:00</td>\n",
       "      <td>19.9</td>\n",
       "      <td>19.1</td>\n",
       "      <td>100</td>\n",
       "      <td>28</td>\n",
       "      <td>9.7</td>\n",
       "      <td>102.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drizzle,Ice Pellets,Fog</th>\n",
       "      <td>12/17/2012 9:00</td>\n",
       "      <td>0.4</td>\n",
       "      <td>-0.7</td>\n",
       "      <td>92</td>\n",
       "      <td>20</td>\n",
       "      <td>4.0</td>\n",
       "      <td>100.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drizzle,Snow</th>\n",
       "      <td>12/19/2012 18:00</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.2</td>\n",
       "      <td>95</td>\n",
       "      <td>19</td>\n",
       "      <td>11.3</td>\n",
       "      <td>101.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drizzle,Snow,Fog</th>\n",
       "      <td>12/22/2012 3:00</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.6</td>\n",
       "      <td>98</td>\n",
       "      <td>32</td>\n",
       "      <td>9.7</td>\n",
       "      <td>100.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fog</th>\n",
       "      <td>9/22/2012 0:00</td>\n",
       "      <td>20.8</td>\n",
       "      <td>19.6</td>\n",
       "      <td>100</td>\n",
       "      <td>22</td>\n",
       "      <td>9.7</td>\n",
       "      <td>103.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Drizzle</th>\n",
       "      <td>2/1/2012 5:00</td>\n",
       "      <td>-2.3</td>\n",
       "      <td>-3.3</td>\n",
       "      <td>93</td>\n",
       "      <td>26</td>\n",
       "      <td>12.9</td>\n",
       "      <td>101.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Drizzle,Fog</th>\n",
       "      <td>12/10/2012 5:00</td>\n",
       "      <td>-0.3</td>\n",
       "      <td>-2.3</td>\n",
       "      <td>94</td>\n",
       "      <td>33</td>\n",
       "      <td>8.0</td>\n",
       "      <td>101.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Drizzle,Haze</th>\n",
       "      <td>2/1/2012 13:00</td>\n",
       "      <td>-5.0</td>\n",
       "      <td>-7.7</td>\n",
       "      <td>83</td>\n",
       "      <td>11</td>\n",
       "      <td>4.0</td>\n",
       "      <td>100.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Drizzle,Snow</th>\n",
       "      <td>3/2/2012 12:00</td>\n",
       "      <td>-3.3</td>\n",
       "      <td>-4.6</td>\n",
       "      <td>94</td>\n",
       "      <td>24</td>\n",
       "      <td>12.9</td>\n",
       "      <td>101.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Fog</th>\n",
       "      <td>3/17/2012 6:00</td>\n",
       "      <td>-0.1</td>\n",
       "      <td>-0.3</td>\n",
       "      <td>99</td>\n",
       "      <td>9</td>\n",
       "      <td>0.8</td>\n",
       "      <td>102.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Rain</th>\n",
       "      <td>2/1/2012 7:00</td>\n",
       "      <td>0.3</td>\n",
       "      <td>-1.7</td>\n",
       "      <td>92</td>\n",
       "      <td>28</td>\n",
       "      <td>16.1</td>\n",
       "      <td>101.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Rain,Fog</th>\n",
       "      <td>12/17/2012 1:00</td>\n",
       "      <td>0.1</td>\n",
       "      <td>-0.9</td>\n",
       "      <td>93</td>\n",
       "      <td>26</td>\n",
       "      <td>9.7</td>\n",
       "      <td>101.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Rain,Haze</th>\n",
       "      <td>2/1/2012 15:00</td>\n",
       "      <td>-4.9</td>\n",
       "      <td>-7.4</td>\n",
       "      <td>83</td>\n",
       "      <td>9</td>\n",
       "      <td>2.8</td>\n",
       "      <td>100.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Rain,Ice Pellets,Fog</th>\n",
       "      <td>12/17/2012 3:00</td>\n",
       "      <td>-2.6</td>\n",
       "      <td>-3.7</td>\n",
       "      <td>92</td>\n",
       "      <td>28</td>\n",
       "      <td>8.0</td>\n",
       "      <td>100.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Rain,Snow Grains</th>\n",
       "      <td>1/13/2012 9:00</td>\n",
       "      <td>-5.0</td>\n",
       "      <td>-7.3</td>\n",
       "      <td>84</td>\n",
       "      <td>32</td>\n",
       "      <td>4.8</td>\n",
       "      <td>98.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Haze</th>\n",
       "      <td>3/13/2012 23:00</td>\n",
       "      <td>14.1</td>\n",
       "      <td>11.1</td>\n",
       "      <td>86</td>\n",
       "      <td>17</td>\n",
       "      <td>9.7</td>\n",
       "      <td>102.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mainly Clear</th>\n",
       "      <td>9/9/2012 9:00</td>\n",
       "      <td>33.0</td>\n",
       "      <td>21.2</td>\n",
       "      <td>99</td>\n",
       "      <td>63</td>\n",
       "      <td>48.3</td>\n",
       "      <td>103.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Moderate Rain,Fog</th>\n",
       "      <td>12/10/2012 8:00</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0.8</td>\n",
       "      <td>94</td>\n",
       "      <td>17</td>\n",
       "      <td>6.4</td>\n",
       "      <td>99.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Moderate Snow</th>\n",
       "      <td>12/27/2012 9:00</td>\n",
       "      <td>-4.9</td>\n",
       "      <td>-6.7</td>\n",
       "      <td>93</td>\n",
       "      <td>39</td>\n",
       "      <td>0.8</td>\n",
       "      <td>100.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Moderate Snow,Blowing Snow</th>\n",
       "      <td>12/27/2012 12:00</td>\n",
       "      <td>-5.4</td>\n",
       "      <td>-6.4</td>\n",
       "      <td>93</td>\n",
       "      <td>41</td>\n",
       "      <td>0.6</td>\n",
       "      <td>100.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mostly Cloudy</th>\n",
       "      <td>9/9/2012 2:00</td>\n",
       "      <td>32.4</td>\n",
       "      <td>24.4</td>\n",
       "      <td>100</td>\n",
       "      <td>83</td>\n",
       "      <td>48.3</td>\n",
       "      <td>103.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain</th>\n",
       "      <td>9/5/2012 2:00</td>\n",
       "      <td>22.8</td>\n",
       "      <td>20.4</td>\n",
       "      <td>99</td>\n",
       "      <td>52</td>\n",
       "      <td>48.3</td>\n",
       "      <td>102.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain Showers</th>\n",
       "      <td>9/8/2012 16:00</td>\n",
       "      <td>26.4</td>\n",
       "      <td>23.0</td>\n",
       "      <td>97</td>\n",
       "      <td>41</td>\n",
       "      <td>48.3</td>\n",
       "      <td>102.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain Showers,Fog</th>\n",
       "      <td>10/20/2012 3:00</td>\n",
       "      <td>12.8</td>\n",
       "      <td>12.1</td>\n",
       "      <td>96</td>\n",
       "      <td>13</td>\n",
       "      <td>6.4</td>\n",
       "      <td>99.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain Showers,Snow Showers</th>\n",
       "      <td>12/5/2012 10:00</td>\n",
       "      <td>2.2</td>\n",
       "      <td>-1.2</td>\n",
       "      <td>78</td>\n",
       "      <td>28</td>\n",
       "      <td>24.1</td>\n",
       "      <td>101.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain,Fog</th>\n",
       "      <td>9/30/2012 23:00</td>\n",
       "      <td>21.7</td>\n",
       "      <td>19.5</td>\n",
       "      <td>100</td>\n",
       "      <td>46</td>\n",
       "      <td>9.7</td>\n",
       "      <td>101.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain,Haze</th>\n",
       "      <td>3/13/2012 9:00</td>\n",
       "      <td>5.5</td>\n",
       "      <td>2.9</td>\n",
       "      <td>86</td>\n",
       "      <td>17</td>\n",
       "      <td>9.7</td>\n",
       "      <td>100.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain,Ice Pellets</th>\n",
       "      <td>12/18/2012 5:00</td>\n",
       "      <td>0.6</td>\n",
       "      <td>-0.6</td>\n",
       "      <td>92</td>\n",
       "      <td>24</td>\n",
       "      <td>9.7</td>\n",
       "      <td>100.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain,Snow</th>\n",
       "      <td>4/23/2012 3:00</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0.5</td>\n",
       "      <td>94</td>\n",
       "      <td>52</td>\n",
       "      <td>25.0</td>\n",
       "      <td>101.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain,Snow Grains</th>\n",
       "      <td>12/21/2012 0:00</td>\n",
       "      <td>1.9</td>\n",
       "      <td>-2.1</td>\n",
       "      <td>75</td>\n",
       "      <td>26</td>\n",
       "      <td>25.0</td>\n",
       "      <td>100.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain,Snow,Fog</th>\n",
       "      <td>12/8/2012 21:00</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.3</td>\n",
       "      <td>96</td>\n",
       "      <td>9</td>\n",
       "      <td>6.4</td>\n",
       "      <td>100.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain,Snow,Ice Pellets</th>\n",
       "      <td>12/21/2012 5:00</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.1</td>\n",
       "      <td>94</td>\n",
       "      <td>28</td>\n",
       "      <td>6.4</td>\n",
       "      <td>100.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow</th>\n",
       "      <td>4/27/2012 9:00</td>\n",
       "      <td>3.7</td>\n",
       "      <td>0.3</td>\n",
       "      <td>96</td>\n",
       "      <td>57</td>\n",
       "      <td>25.0</td>\n",
       "      <td>102.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow Pellets</th>\n",
       "      <td>11/24/2012 15:00</td>\n",
       "      <td>0.7</td>\n",
       "      <td>-6.4</td>\n",
       "      <td>59</td>\n",
       "      <td>35</td>\n",
       "      <td>2.4</td>\n",
       "      <td>99.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow Showers</th>\n",
       "      <td>3/4/2012 21:00</td>\n",
       "      <td>2.9</td>\n",
       "      <td>-0.7</td>\n",
       "      <td>94</td>\n",
       "      <td>37</td>\n",
       "      <td>48.3</td>\n",
       "      <td>102.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow Showers,Fog</th>\n",
       "      <td>12/29/2012 13:00</td>\n",
       "      <td>-10.0</td>\n",
       "      <td>-11.1</td>\n",
       "      <td>92</td>\n",
       "      <td>22</td>\n",
       "      <td>9.7</td>\n",
       "      <td>102.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow,Blowing Snow</th>\n",
       "      <td>2/25/2012 9:00</td>\n",
       "      <td>-1.4</td>\n",
       "      <td>-2.9</td>\n",
       "      <td>91</td>\n",
       "      <td>48</td>\n",
       "      <td>9.7</td>\n",
       "      <td>100.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow,Fog</th>\n",
       "      <td>3/14/2012 19:00</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.8</td>\n",
       "      <td>99</td>\n",
       "      <td>35</td>\n",
       "      <td>9.7</td>\n",
       "      <td>102.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow,Haze</th>\n",
       "      <td>2/1/2012 21:00</td>\n",
       "      <td>-3.6</td>\n",
       "      <td>-6.4</td>\n",
       "      <td>81</td>\n",
       "      <td>15</td>\n",
       "      <td>6.4</td>\n",
       "      <td>100.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow,Ice Pellets</th>\n",
       "      <td>3/3/2012 4:00</td>\n",
       "      <td>0.8</td>\n",
       "      <td>-1.7</td>\n",
       "      <td>92</td>\n",
       "      <td>33</td>\n",
       "      <td>11.3</td>\n",
       "      <td>100.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thunderstorms</th>\n",
       "      <td>7/4/2012 16:00</td>\n",
       "      <td>26.7</td>\n",
       "      <td>20.1</td>\n",
       "      <td>87</td>\n",
       "      <td>15</td>\n",
       "      <td>25.0</td>\n",
       "      <td>100.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thunderstorms,Heavy Rain Showers</th>\n",
       "      <td>5/29/2012 6:00</td>\n",
       "      <td>10.9</td>\n",
       "      <td>9.0</td>\n",
       "      <td>88</td>\n",
       "      <td>9</td>\n",
       "      <td>2.4</td>\n",
       "      <td>100.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thunderstorms,Moderate Rain Showers,Fog</th>\n",
       "      <td>7/17/2012 6:00</td>\n",
       "      <td>19.6</td>\n",
       "      <td>18.5</td>\n",
       "      <td>93</td>\n",
       "      <td>15</td>\n",
       "      <td>3.2</td>\n",
       "      <td>100.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thunderstorms,Rain</th>\n",
       "      <td>7/23/2012 18:00</td>\n",
       "      <td>21.3</td>\n",
       "      <td>19.1</td>\n",
       "      <td>93</td>\n",
       "      <td>30</td>\n",
       "      <td>24.1</td>\n",
       "      <td>100.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thunderstorms,Rain Showers</th>\n",
       "      <td>9/8/2012 4:00</td>\n",
       "      <td>25.5</td>\n",
       "      <td>23.1</td>\n",
       "      <td>98</td>\n",
       "      <td>32</td>\n",
       "      <td>25.0</td>\n",
       "      <td>101.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thunderstorms,Rain Showers,Fog</th>\n",
       "      <td>7/31/2012 20:00</td>\n",
       "      <td>22.9</td>\n",
       "      <td>21.3</td>\n",
       "      <td>91</td>\n",
       "      <td>35</td>\n",
       "      <td>9.7</td>\n",
       "      <td>100.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thunderstorms,Rain,Fog</th>\n",
       "      <td>7/17/2012 5:00</td>\n",
       "      <td>20.6</td>\n",
       "      <td>18.6</td>\n",
       "      <td>88</td>\n",
       "      <td>19</td>\n",
       "      <td>4.8</td>\n",
       "      <td>100.08</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                Date/Time  Temp_C  \\\n",
       "Weather Condition                                                   \n",
       "Clear                                       9/9/2012 5:00    32.8   \n",
       "Cloudy                                     9/9/2012 23:00    30.5   \n",
       "Drizzle                                    9/30/2012 3:00    18.8   \n",
       "Drizzle,Fog                                9/30/2012 2:00    19.9   \n",
       "Drizzle,Ice Pellets,Fog                   12/17/2012 9:00     0.4   \n",
       "Drizzle,Snow                             12/19/2012 18:00     1.2   \n",
       "Drizzle,Snow,Fog                          12/22/2012 3:00     1.1   \n",
       "Fog                                        9/22/2012 0:00    20.8   \n",
       "Freezing Drizzle                            2/1/2012 5:00    -2.3   \n",
       "Freezing Drizzle,Fog                      12/10/2012 5:00    -0.3   \n",
       "Freezing Drizzle,Haze                      2/1/2012 13:00    -5.0   \n",
       "Freezing Drizzle,Snow                      3/2/2012 12:00    -3.3   \n",
       "Freezing Fog                               3/17/2012 6:00    -0.1   \n",
       "Freezing Rain                               2/1/2012 7:00     0.3   \n",
       "Freezing Rain,Fog                         12/17/2012 1:00     0.1   \n",
       "Freezing Rain,Haze                         2/1/2012 15:00    -4.9   \n",
       "Freezing Rain,Ice Pellets,Fog             12/17/2012 3:00    -2.6   \n",
       "Freezing Rain,Snow Grains                  1/13/2012 9:00    -5.0   \n",
       "Haze                                      3/13/2012 23:00    14.1   \n",
       "Mainly Clear                                9/9/2012 9:00    33.0   \n",
       "Moderate Rain,Fog                         12/10/2012 8:00     1.7   \n",
       "Moderate Snow                             12/27/2012 9:00    -4.9   \n",
       "Moderate Snow,Blowing Snow               12/27/2012 12:00    -5.4   \n",
       "Mostly Cloudy                               9/9/2012 2:00    32.4   \n",
       "Rain                                        9/5/2012 2:00    22.8   \n",
       "Rain Showers                               9/8/2012 16:00    26.4   \n",
       "Rain Showers,Fog                          10/20/2012 3:00    12.8   \n",
       "Rain Showers,Snow Showers                 12/5/2012 10:00     2.2   \n",
       "Rain,Fog                                  9/30/2012 23:00    21.7   \n",
       "Rain,Haze                                  3/13/2012 9:00     5.5   \n",
       "Rain,Ice Pellets                          12/18/2012 5:00     0.6   \n",
       "Rain,Snow                                  4/23/2012 3:00     1.7   \n",
       "Rain,Snow Grains                          12/21/2012 0:00     1.9   \n",
       "Rain,Snow,Fog                             12/8/2012 21:00     0.8   \n",
       "Rain,Snow,Ice Pellets                     12/21/2012 5:00     1.3   \n",
       "Snow                                       4/27/2012 9:00     3.7   \n",
       "Snow Pellets                             11/24/2012 15:00     0.7   \n",
       "Snow Showers                               3/4/2012 21:00     2.9   \n",
       "Snow Showers,Fog                         12/29/2012 13:00   -10.0   \n",
       "Snow,Blowing Snow                          2/25/2012 9:00    -1.4   \n",
       "Snow,Fog                                  3/14/2012 19:00     1.1   \n",
       "Snow,Haze                                  2/1/2012 21:00    -3.6   \n",
       "Snow,Ice Pellets                            3/3/2012 4:00     0.8   \n",
       "Thunderstorms                              7/4/2012 16:00    26.7   \n",
       "Thunderstorms,Heavy Rain Showers           5/29/2012 6:00    10.9   \n",
       "Thunderstorms,Moderate Rain Showers,Fog    7/17/2012 6:00    19.6   \n",
       "Thunderstorms,Rain                        7/23/2012 18:00    21.3   \n",
       "Thunderstorms,Rain Showers                  9/8/2012 4:00    25.5   \n",
       "Thunderstorms,Rain Showers,Fog            7/31/2012 20:00    22.9   \n",
       "Thunderstorms,Rain,Fog                     7/17/2012 5:00    20.6   \n",
       "\n",
       "                                         Dew Point Temp_C  Rel Hum_%  \\\n",
       "Weather Condition                                                      \n",
       "Clear                                                20.4         99   \n",
       "Cloudy                                               22.6         99   \n",
       "Drizzle                                              17.7         96   \n",
       "Drizzle,Fog                                          19.1        100   \n",
       "Drizzle,Ice Pellets,Fog                              -0.7         92   \n",
       "Drizzle,Snow                                          0.2         95   \n",
       "Drizzle,Snow,Fog                                      0.6         98   \n",
       "Fog                                                  19.6        100   \n",
       "Freezing Drizzle                                     -3.3         93   \n",
       "Freezing Drizzle,Fog                                 -2.3         94   \n",
       "Freezing Drizzle,Haze                                -7.7         83   \n",
       "Freezing Drizzle,Snow                                -4.6         94   \n",
       "Freezing Fog                                         -0.3         99   \n",
       "Freezing Rain                                        -1.7         92   \n",
       "Freezing Rain,Fog                                    -0.9         93   \n",
       "Freezing Rain,Haze                                   -7.4         83   \n",
       "Freezing Rain,Ice Pellets,Fog                        -3.7         92   \n",
       "Freezing Rain,Snow Grains                            -7.3         84   \n",
       "Haze                                                 11.1         86   \n",
       "Mainly Clear                                         21.2         99   \n",
       "Moderate Rain,Fog                                     0.8         94   \n",
       "Moderate Snow                                        -6.7         93   \n",
       "Moderate Snow,Blowing Snow                           -6.4         93   \n",
       "Mostly Cloudy                                        24.4        100   \n",
       "Rain                                                 20.4         99   \n",
       "Rain Showers                                         23.0         97   \n",
       "Rain Showers,Fog                                     12.1         96   \n",
       "Rain Showers,Snow Showers                            -1.2         78   \n",
       "Rain,Fog                                             19.5        100   \n",
       "Rain,Haze                                             2.9         86   \n",
       "Rain,Ice Pellets                                     -0.6         92   \n",
       "Rain,Snow                                             0.5         94   \n",
       "Rain,Snow Grains                                     -2.1         75   \n",
       "Rain,Snow,Fog                                         0.3         96   \n",
       "Rain,Snow,Ice Pellets                                 0.1         94   \n",
       "Snow                                                  0.3         96   \n",
       "Snow Pellets                                         -6.4         59   \n",
       "Snow Showers                                         -0.7         94   \n",
       "Snow Showers,Fog                                    -11.1         92   \n",
       "Snow,Blowing Snow                                    -2.9         91   \n",
       "Snow,Fog                                              0.8         99   \n",
       "Snow,Haze                                            -6.4         81   \n",
       "Snow,Ice Pellets                                     -1.7         92   \n",
       "Thunderstorms                                        20.1         87   \n",
       "Thunderstorms,Heavy Rain Showers                      9.0         88   \n",
       "Thunderstorms,Moderate Rain Showers,Fog              18.5         93   \n",
       "Thunderstorms,Rain                                   19.1         93   \n",
       "Thunderstorms,Rain Showers                           23.1         98   \n",
       "Thunderstorms,Rain Showers,Fog                       21.3         91   \n",
       "Thunderstorms,Rain,Fog                               18.6         88   \n",
       "\n",
       "                                         Wind Speed_km/h  Visibility_km  \\\n",
       "Weather Condition                                                         \n",
       "Clear                                                 33           48.3   \n",
       "Cloudy                                                54           48.3   \n",
       "Drizzle                                               30           25.0   \n",
       "Drizzle,Fog                                           28            9.7   \n",
       "Drizzle,Ice Pellets,Fog                               20            4.0   \n",
       "Drizzle,Snow                                          19           11.3   \n",
       "Drizzle,Snow,Fog                                      32            9.7   \n",
       "Fog                                                   22            9.7   \n",
       "Freezing Drizzle                                      26           12.9   \n",
       "Freezing Drizzle,Fog                                  33            8.0   \n",
       "Freezing Drizzle,Haze                                 11            4.0   \n",
       "Freezing Drizzle,Snow                                 24           12.9   \n",
       "Freezing Fog                                           9            0.8   \n",
       "Freezing Rain                                         28           16.1   \n",
       "Freezing Rain,Fog                                     26            9.7   \n",
       "Freezing Rain,Haze                                     9            2.8   \n",
       "Freezing Rain,Ice Pellets,Fog                         28            8.0   \n",
       "Freezing Rain,Snow Grains                             32            4.8   \n",
       "Haze                                                  17            9.7   \n",
       "Mainly Clear                                          63           48.3   \n",
       "Moderate Rain,Fog                                     17            6.4   \n",
       "Moderate Snow                                         39            0.8   \n",
       "Moderate Snow,Blowing Snow                            41            0.6   \n",
       "Mostly Cloudy                                         83           48.3   \n",
       "Rain                                                  52           48.3   \n",
       "Rain Showers                                          41           48.3   \n",
       "Rain Showers,Fog                                      13            6.4   \n",
       "Rain Showers,Snow Showers                             28           24.1   \n",
       "Rain,Fog                                              46            9.7   \n",
       "Rain,Haze                                             17            9.7   \n",
       "Rain,Ice Pellets                                      24            9.7   \n",
       "Rain,Snow                                             52           25.0   \n",
       "Rain,Snow Grains                                      26           25.0   \n",
       "Rain,Snow,Fog                                          9            6.4   \n",
       "Rain,Snow,Ice Pellets                                 28            6.4   \n",
       "Snow                                                  57           25.0   \n",
       "Snow Pellets                                          35            2.4   \n",
       "Snow Showers                                          37           48.3   \n",
       "Snow Showers,Fog                                      22            9.7   \n",
       "Snow,Blowing Snow                                     48            9.7   \n",
       "Snow,Fog                                              35            9.7   \n",
       "Snow,Haze                                             15            6.4   \n",
       "Snow,Ice Pellets                                      33           11.3   \n",
       "Thunderstorms                                         15           25.0   \n",
       "Thunderstorms,Heavy Rain Showers                       9            2.4   \n",
       "Thunderstorms,Moderate Rain Showers,Fog               15            3.2   \n",
       "Thunderstorms,Rain                                    30           24.1   \n",
       "Thunderstorms,Rain Showers                            32           25.0   \n",
       "Thunderstorms,Rain Showers,Fog                        35            9.7   \n",
       "Thunderstorms,Rain,Fog                                19            4.8   \n",
       "\n",
       "                                         Press_kPa  \n",
       "Weather Condition                                   \n",
       "Clear                                       103.63  \n",
       "Cloudy                                      103.65  \n",
       "Drizzle                                     101.56  \n",
       "Drizzle,Fog                                 102.07  \n",
       "Drizzle,Ice Pellets,Fog                     100.79  \n",
       "Drizzle,Snow                                101.15  \n",
       "Drizzle,Snow,Fog                            100.15  \n",
       "Fog                                         103.04  \n",
       "Freezing Drizzle                            101.02  \n",
       "Freezing Drizzle,Fog                        101.27  \n",
       "Freezing Drizzle,Haze                       100.36  \n",
       "Freezing Drizzle,Snow                       101.18  \n",
       "Freezing Fog                                102.85  \n",
       "Freezing Rain                               101.00  \n",
       "Freezing Rain,Fog                           101.01  \n",
       "Freezing Rain,Haze                          100.41  \n",
       "Freezing Rain,Ice Pellets,Fog               100.95  \n",
       "Freezing Rain,Snow Grains                    98.56  \n",
       "Haze                                        102.97  \n",
       "Mainly Clear                                103.59  \n",
       "Moderate Rain,Fog                            99.98  \n",
       "Moderate Snow                               100.67  \n",
       "Moderate Snow,Blowing Snow                  100.64  \n",
       "Mostly Cloudy                               103.65  \n",
       "Rain                                        102.26  \n",
       "Rain Showers                                102.31  \n",
       "Rain Showers,Fog                             99.83  \n",
       "Rain Showers,Snow Showers                   101.11  \n",
       "Rain,Fog                                    101.77  \n",
       "Rain,Haze                                   100.61  \n",
       "Rain,Ice Pellets                            100.12  \n",
       "Rain,Snow                                   101.07  \n",
       "Rain,Snow Grains                            100.60  \n",
       "Rain,Snow,Fog                               100.73  \n",
       "Rain,Snow,Ice Pellets                       100.47  \n",
       "Snow                                        102.73  \n",
       "Snow Pellets                                 99.70  \n",
       "Snow Showers                                102.50  \n",
       "Snow Showers,Fog                            102.52  \n",
       "Snow,Blowing Snow                           100.62  \n",
       "Snow,Fog                                    102.07  \n",
       "Snow,Haze                                   100.99  \n",
       "Snow,Ice Pellets                            100.96  \n",
       "Thunderstorms                               100.62  \n",
       "Thunderstorms,Heavy Rain Showers            100.26  \n",
       "Thunderstorms,Moderate Rain Showers,Fog     100.01  \n",
       "Thunderstorms,Rain                          100.83  \n",
       "Thunderstorms,Rain Showers                  101.06  \n",
       "Thunderstorms,Rain Showers,Fog              100.64  \n",
       "Thunderstorms,Rain,Fog                      100.08  "
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# what is the minimum and maximum value of each column against each weather condition\n",
    "\n",
    "df.groupby('Weather Condition').max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "21e9063f",
   "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>Date/Time</th>\n",
       "      <th>Temp_C</th>\n",
       "      <th>Dew Point Temp_C</th>\n",
       "      <th>Rel Hum_%</th>\n",
       "      <th>Wind Speed_km/h</th>\n",
       "      <th>Visibility_km</th>\n",
       "      <th>Press_kPa</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Weather Condition</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Clear</th>\n",
       "      <td>1/11/2012 1:00</td>\n",
       "      <td>-23.3</td>\n",
       "      <td>-28.5</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>11.3</td>\n",
       "      <td>99.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cloudy</th>\n",
       "      <td>1/1/2012 17:00</td>\n",
       "      <td>-21.4</td>\n",
       "      <td>-26.8</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>11.3</td>\n",
       "      <td>98.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drizzle</th>\n",
       "      <td>1/23/2012 21:00</td>\n",
       "      <td>1.1</td>\n",
       "      <td>-0.2</td>\n",
       "      <td>74</td>\n",
       "      <td>0</td>\n",
       "      <td>6.4</td>\n",
       "      <td>97.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drizzle,Fog</th>\n",
       "      <td>1/23/2012 20:00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.6</td>\n",
       "      <td>85</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>98.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drizzle,Ice Pellets,Fog</th>\n",
       "      <td>12/17/2012 9:00</td>\n",
       "      <td>0.4</td>\n",
       "      <td>-0.7</td>\n",
       "      <td>92</td>\n",
       "      <td>20</td>\n",
       "      <td>4.0</td>\n",
       "      <td>100.79</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               Date/Time  Temp_C  Dew Point Temp_C  Rel Hum_%  \\\n",
       "Weather Condition                                                               \n",
       "Clear                     1/11/2012 1:00   -23.3             -28.5         20   \n",
       "Cloudy                    1/1/2012 17:00   -21.4             -26.8         18   \n",
       "Drizzle                  1/23/2012 21:00     1.1              -0.2         74   \n",
       "Drizzle,Fog              1/23/2012 20:00     0.0              -1.6         85   \n",
       "Drizzle,Ice Pellets,Fog  12/17/2012 9:00     0.4              -0.7         92   \n",
       "\n",
       "                         Wind Speed_km/h  Visibility_km  Press_kPa  \n",
       "Weather Condition                                                   \n",
       "Clear                                  0           11.3      99.52  \n",
       "Cloudy                                 0           11.3      98.39  \n",
       "Drizzle                                0            6.4      97.84  \n",
       "Drizzle,Fog                            0            1.0      98.65  \n",
       "Drizzle,Ice Pellets,Fog               20            4.0     100.79  "
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby('Weather Condition').min().head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3d7a629f",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "cac093f6",
   "metadata": {
    "scrolled": true
   },
   "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>Date/Time</th>\n",
       "      <th>Temp_C</th>\n",
       "      <th>Dew Point Temp_C</th>\n",
       "      <th>Rel Hum_%</th>\n",
       "      <th>Wind Speed_km/h</th>\n",
       "      <th>Visibility_km</th>\n",
       "      <th>Press_kPa</th>\n",
       "      <th>Weather Condition</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1/1/2012 0:00</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>-3.9</td>\n",
       "      <td>86</td>\n",
       "      <td>4</td>\n",
       "      <td>8.0</td>\n",
       "      <td>101.24</td>\n",
       "      <td>Fog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1/1/2012 1:00</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>-3.7</td>\n",
       "      <td>87</td>\n",
       "      <td>4</td>\n",
       "      <td>8.0</td>\n",
       "      <td>101.24</td>\n",
       "      <td>Fog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1/1/2012 4:00</td>\n",
       "      <td>-1.5</td>\n",
       "      <td>-3.3</td>\n",
       "      <td>88</td>\n",
       "      <td>7</td>\n",
       "      <td>4.8</td>\n",
       "      <td>101.23</td>\n",
       "      <td>Fog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1/1/2012 5:00</td>\n",
       "      <td>-1.4</td>\n",
       "      <td>-3.3</td>\n",
       "      <td>87</td>\n",
       "      <td>9</td>\n",
       "      <td>6.4</td>\n",
       "      <td>101.27</td>\n",
       "      <td>Fog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1/1/2012 6:00</td>\n",
       "      <td>-1.5</td>\n",
       "      <td>-3.1</td>\n",
       "      <td>89</td>\n",
       "      <td>7</td>\n",
       "      <td>6.4</td>\n",
       "      <td>101.29</td>\n",
       "      <td>Fog</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8716</th>\n",
       "      <td>12/29/2012 4:00</td>\n",
       "      <td>-16.0</td>\n",
       "      <td>-17.2</td>\n",
       "      <td>90</td>\n",
       "      <td>6</td>\n",
       "      <td>9.7</td>\n",
       "      <td>101.25</td>\n",
       "      <td>Fog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8717</th>\n",
       "      <td>12/29/2012 5:00</td>\n",
       "      <td>-14.8</td>\n",
       "      <td>-15.9</td>\n",
       "      <td>91</td>\n",
       "      <td>4</td>\n",
       "      <td>6.4</td>\n",
       "      <td>101.25</td>\n",
       "      <td>Fog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8718</th>\n",
       "      <td>12/29/2012 6:00</td>\n",
       "      <td>-13.8</td>\n",
       "      <td>-15.3</td>\n",
       "      <td>88</td>\n",
       "      <td>4</td>\n",
       "      <td>9.7</td>\n",
       "      <td>101.25</td>\n",
       "      <td>Fog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8719</th>\n",
       "      <td>12/29/2012 7:00</td>\n",
       "      <td>-14.8</td>\n",
       "      <td>-16.4</td>\n",
       "      <td>88</td>\n",
       "      <td>7</td>\n",
       "      <td>8.0</td>\n",
       "      <td>101.22</td>\n",
       "      <td>Fog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8722</th>\n",
       "      <td>12/29/2012 10:00</td>\n",
       "      <td>-12.0</td>\n",
       "      <td>-13.3</td>\n",
       "      <td>90</td>\n",
       "      <td>7</td>\n",
       "      <td>6.4</td>\n",
       "      <td>101.15</td>\n",
       "      <td>Fog</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>150 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Date/Time  Temp_C  Dew Point Temp_C  Rel Hum_%  Wind Speed_km/h  \\\n",
       "0        1/1/2012 0:00    -1.8              -3.9         86                4   \n",
       "1        1/1/2012 1:00    -1.8              -3.7         87                4   \n",
       "4        1/1/2012 4:00    -1.5              -3.3         88                7   \n",
       "5        1/1/2012 5:00    -1.4              -3.3         87                9   \n",
       "6        1/1/2012 6:00    -1.5              -3.1         89                7   \n",
       "...                ...     ...               ...        ...              ...   \n",
       "8716   12/29/2012 4:00   -16.0             -17.2         90                6   \n",
       "8717   12/29/2012 5:00   -14.8             -15.9         91                4   \n",
       "8718   12/29/2012 6:00   -13.8             -15.3         88                4   \n",
       "8719   12/29/2012 7:00   -14.8             -16.4         88                7   \n",
       "8722  12/29/2012 10:00   -12.0             -13.3         90                7   \n",
       "\n",
       "      Visibility_km  Press_kPa Weather Condition  \n",
       "0               8.0     101.24               Fog  \n",
       "1               8.0     101.24               Fog  \n",
       "4               4.8     101.23               Fog  \n",
       "5               6.4     101.27               Fog  \n",
       "6               6.4     101.29               Fog  \n",
       "...             ...        ...               ...  \n",
       "8716            9.7     101.25               Fog  \n",
       "8717            6.4     101.25               Fog  \n",
       "8718            9.7     101.25               Fog  \n",
       "8719            8.0     101.22               Fog  \n",
       "8722            6.4     101.15               Fog  \n",
       "\n",
       "[150 rows x 8 columns]"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# show all the records where weather is fog\n",
    "\n",
    "df[df['Weather Condition']=='Fog']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "5449547e",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "b7c90836",
   "metadata": {
    "scrolled": false
   },
   "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>Date/Time</th>\n",
       "      <th>Temp_C</th>\n",
       "      <th>Dew Point Temp_C</th>\n",
       "      <th>Rel Hum_%</th>\n",
       "      <th>Wind Speed_km/h</th>\n",
       "      <th>Visibility_km</th>\n",
       "      <th>Press_kPa</th>\n",
       "      <th>Weather Condition</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>1/3/2012 19:00</td>\n",
       "      <td>-16.9</td>\n",
       "      <td>-24.8</td>\n",
       "      <td>50</td>\n",
       "      <td>24</td>\n",
       "      <td>25.0</td>\n",
       "      <td>101.74</td>\n",
       "      <td>Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>1/5/2012 10:00</td>\n",
       "      <td>-6.0</td>\n",
       "      <td>-10.0</td>\n",
       "      <td>73</td>\n",
       "      <td>17</td>\n",
       "      <td>48.3</td>\n",
       "      <td>100.45</td>\n",
       "      <td>Mainly Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>1/5/2012 11:00</td>\n",
       "      <td>-5.6</td>\n",
       "      <td>-10.2</td>\n",
       "      <td>70</td>\n",
       "      <td>22</td>\n",
       "      <td>48.3</td>\n",
       "      <td>100.41</td>\n",
       "      <td>Mainly Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>1/5/2012 12:00</td>\n",
       "      <td>-4.7</td>\n",
       "      <td>-9.6</td>\n",
       "      <td>69</td>\n",
       "      <td>20</td>\n",
       "      <td>48.3</td>\n",
       "      <td>100.38</td>\n",
       "      <td>Mainly Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>1/5/2012 13:00</td>\n",
       "      <td>-4.4</td>\n",
       "      <td>-9.7</td>\n",
       "      <td>66</td>\n",
       "      <td>26</td>\n",
       "      <td>48.3</td>\n",
       "      <td>100.40</td>\n",
       "      <td>Mainly Clear</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8749</th>\n",
       "      <td>12/30/2012 13:00</td>\n",
       "      <td>-12.4</td>\n",
       "      <td>-16.2</td>\n",
       "      <td>73</td>\n",
       "      <td>37</td>\n",
       "      <td>48.3</td>\n",
       "      <td>100.92</td>\n",
       "      <td>Mostly Cloudy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8750</th>\n",
       "      <td>12/30/2012 14:00</td>\n",
       "      <td>-11.8</td>\n",
       "      <td>-16.1</td>\n",
       "      <td>70</td>\n",
       "      <td>37</td>\n",
       "      <td>48.3</td>\n",
       "      <td>100.96</td>\n",
       "      <td>Mainly Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8751</th>\n",
       "      <td>12/30/2012 15:00</td>\n",
       "      <td>-11.3</td>\n",
       "      <td>-15.6</td>\n",
       "      <td>70</td>\n",
       "      <td>32</td>\n",
       "      <td>48.3</td>\n",
       "      <td>101.05</td>\n",
       "      <td>Mainly Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8752</th>\n",
       "      <td>12/30/2012 16:00</td>\n",
       "      <td>-11.4</td>\n",
       "      <td>-15.5</td>\n",
       "      <td>72</td>\n",
       "      <td>26</td>\n",
       "      <td>48.3</td>\n",
       "      <td>101.15</td>\n",
       "      <td>Mainly Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8756</th>\n",
       "      <td>12/30/2012 20:00</td>\n",
       "      <td>-13.8</td>\n",
       "      <td>-16.5</td>\n",
       "      <td>80</td>\n",
       "      <td>24</td>\n",
       "      <td>25.0</td>\n",
       "      <td>101.52</td>\n",
       "      <td>Clear</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3027 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Date/Time  Temp_C  Dew Point Temp_C  Rel Hum_%  Wind Speed_km/h  \\\n",
       "67      1/3/2012 19:00   -16.9             -24.8         50               24   \n",
       "106     1/5/2012 10:00    -6.0             -10.0         73               17   \n",
       "107     1/5/2012 11:00    -5.6             -10.2         70               22   \n",
       "108     1/5/2012 12:00    -4.7              -9.6         69               20   \n",
       "109     1/5/2012 13:00    -4.4              -9.7         66               26   \n",
       "...                ...     ...               ...        ...              ...   \n",
       "8749  12/30/2012 13:00   -12.4             -16.2         73               37   \n",
       "8750  12/30/2012 14:00   -11.8             -16.1         70               37   \n",
       "8751  12/30/2012 15:00   -11.3             -15.6         70               32   \n",
       "8752  12/30/2012 16:00   -11.4             -15.5         72               26   \n",
       "8756  12/30/2012 20:00   -13.8             -16.5         80               24   \n",
       "\n",
       "      Visibility_km  Press_kPa Weather Condition  \n",
       "67             25.0     101.74             Clear  \n",
       "106            48.3     100.45      Mainly Clear  \n",
       "107            48.3     100.41      Mainly Clear  \n",
       "108            48.3     100.38      Mainly Clear  \n",
       "109            48.3     100.40      Mainly Clear  \n",
       "...             ...        ...               ...  \n",
       "8749           48.3     100.92     Mostly Cloudy  \n",
       "8750           48.3     100.96      Mainly Clear  \n",
       "8751           48.3     101.05      Mainly Clear  \n",
       "8752           48.3     101.15      Mainly Clear  \n",
       "8756           25.0     101.52             Clear  \n",
       "\n",
       "[3027 rows x 8 columns]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# find all instance when Weather is Clear or visibility is above 40\n",
    "\n",
    "\n",
    "df[(df['Weather Condition']=='Clear') | (df['Visibility_km']>40)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "1be4081d",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "5db48fad",
   "metadata": {},
   "source": [
    "# find all instance when \n",
    "A. Weather is clear and relative humidity is greater than 50\n",
    "\n",
    "or\n",
    "\n",
    "B. Visibility is above 40"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "41769a43",
   "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>Date/Time</th>\n",
       "      <th>Temp_C</th>\n",
       "      <th>Dew Point Temp_C</th>\n",
       "      <th>Rel Hum_%</th>\n",
       "      <th>Wind Speed_km/h</th>\n",
       "      <th>Visibility_km</th>\n",
       "      <th>Press_kPa</th>\n",
       "      <th>Weather Condition</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>1/5/2012 10:00</td>\n",
       "      <td>-6.0</td>\n",
       "      <td>-10.0</td>\n",
       "      <td>73</td>\n",
       "      <td>17</td>\n",
       "      <td>48.3</td>\n",
       "      <td>100.45</td>\n",
       "      <td>Mainly Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>1/5/2012 11:00</td>\n",
       "      <td>-5.6</td>\n",
       "      <td>-10.2</td>\n",
       "      <td>70</td>\n",
       "      <td>22</td>\n",
       "      <td>48.3</td>\n",
       "      <td>100.41</td>\n",
       "      <td>Mainly Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>1/5/2012 12:00</td>\n",
       "      <td>-4.7</td>\n",
       "      <td>-9.6</td>\n",
       "      <td>69</td>\n",
       "      <td>20</td>\n",
       "      <td>48.3</td>\n",
       "      <td>100.38</td>\n",
       "      <td>Mainly Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>1/5/2012 13:00</td>\n",
       "      <td>-4.4</td>\n",
       "      <td>-9.7</td>\n",
       "      <td>66</td>\n",
       "      <td>26</td>\n",
       "      <td>48.3</td>\n",
       "      <td>100.40</td>\n",
       "      <td>Mainly Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>1/5/2012 14:00</td>\n",
       "      <td>-5.1</td>\n",
       "      <td>-10.7</td>\n",
       "      <td>65</td>\n",
       "      <td>22</td>\n",
       "      <td>48.3</td>\n",
       "      <td>100.46</td>\n",
       "      <td>Mainly Clear</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8749</th>\n",
       "      <td>12/30/2012 13:00</td>\n",
       "      <td>-12.4</td>\n",
       "      <td>-16.2</td>\n",
       "      <td>73</td>\n",
       "      <td>37</td>\n",
       "      <td>48.3</td>\n",
       "      <td>100.92</td>\n",
       "      <td>Mostly Cloudy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8750</th>\n",
       "      <td>12/30/2012 14:00</td>\n",
       "      <td>-11.8</td>\n",
       "      <td>-16.1</td>\n",
       "      <td>70</td>\n",
       "      <td>37</td>\n",
       "      <td>48.3</td>\n",
       "      <td>100.96</td>\n",
       "      <td>Mainly Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8751</th>\n",
       "      <td>12/30/2012 15:00</td>\n",
       "      <td>-11.3</td>\n",
       "      <td>-15.6</td>\n",
       "      <td>70</td>\n",
       "      <td>32</td>\n",
       "      <td>48.3</td>\n",
       "      <td>101.05</td>\n",
       "      <td>Mainly Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8752</th>\n",
       "      <td>12/30/2012 16:00</td>\n",
       "      <td>-11.4</td>\n",
       "      <td>-15.5</td>\n",
       "      <td>72</td>\n",
       "      <td>26</td>\n",
       "      <td>48.3</td>\n",
       "      <td>101.15</td>\n",
       "      <td>Mainly Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8756</th>\n",
       "      <td>12/30/2012 20:00</td>\n",
       "      <td>-13.8</td>\n",
       "      <td>-16.5</td>\n",
       "      <td>80</td>\n",
       "      <td>24</td>\n",
       "      <td>25.0</td>\n",
       "      <td>101.52</td>\n",
       "      <td>Clear</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2921 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Date/Time  Temp_C  Dew Point Temp_C  Rel Hum_%  Wind Speed_km/h  \\\n",
       "106     1/5/2012 10:00    -6.0             -10.0         73               17   \n",
       "107     1/5/2012 11:00    -5.6             -10.2         70               22   \n",
       "108     1/5/2012 12:00    -4.7              -9.6         69               20   \n",
       "109     1/5/2012 13:00    -4.4              -9.7         66               26   \n",
       "110     1/5/2012 14:00    -5.1             -10.7         65               22   \n",
       "...                ...     ...               ...        ...              ...   \n",
       "8749  12/30/2012 13:00   -12.4             -16.2         73               37   \n",
       "8750  12/30/2012 14:00   -11.8             -16.1         70               37   \n",
       "8751  12/30/2012 15:00   -11.3             -15.6         70               32   \n",
       "8752  12/30/2012 16:00   -11.4             -15.5         72               26   \n",
       "8756  12/30/2012 20:00   -13.8             -16.5         80               24   \n",
       "\n",
       "      Visibility_km  Press_kPa Weather Condition  \n",
       "106            48.3     100.45      Mainly Clear  \n",
       "107            48.3     100.41      Mainly Clear  \n",
       "108            48.3     100.38      Mainly Clear  \n",
       "109            48.3     100.40      Mainly Clear  \n",
       "110            48.3     100.46      Mainly Clear  \n",
       "...             ...        ...               ...  \n",
       "8749           48.3     100.92     Mostly Cloudy  \n",
       "8750           48.3     100.96      Mainly Clear  \n",
       "8751           48.3     101.05      Mainly Clear  \n",
       "8752           48.3     101.15      Mainly Clear  \n",
       "8756           25.0     101.52             Clear  \n",
       "\n",
       "[2921 rows x 8 columns]"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[(df['Weather Condition']=='Clear') & (df['Rel Hum_%']>50)|(df['Visibility_km']>40)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "51e77c27",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "94f711ce",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "7af80cd5",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}