project 01 data analysis of weather .ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "f26d7018",
   "metadata": {},
   "source": [
    "# Data analysis of weather \n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3e4402d7",
   "metadata": {},
   "source": [
    "## The weather dataset"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6d8ae968",
   "metadata": {},
   "source": [
    "The data is available in CSV file . I am going to analyze it using pandas DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "602bba55",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "17d8b9a2",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_csv(r\"C:\\Users\\utsha\\OneDrive\\Desktop\\Untitled Folder\\dataset\\1. Weather Data.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "064a5d46",
   "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",
       "    <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>8784 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",
       "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",
       "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",
       "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  \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",
       "[8784 rows x 8 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fe4c7cb0",
   "metadata": {},
   "source": [
    "### Exploring data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "85a7110e",
   "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</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": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()    # first five rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "fb2df3d8",
   "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</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": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.tail()   #last five rows"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e5176aa8",
   "metadata": {},
   "source": [
    "#### Checking rows and columns of dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "fe945abe",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(8784, 8)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "a7c81d9a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RangeIndex(start=0, stop=8784, step=1)"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.index "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e81c8b7b",
   "metadata": {},
   "source": [
    "#### Name of columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "bc5f325e",
   "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": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "af8d0b74",
   "metadata": {},
   "source": [
    "#### checking data types of columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "ca3ebbd2",
   "metadata": {},
   "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": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.dtypes"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "881a1dfe",
   "metadata": {},
   "source": [
    "#### checking unique values present in weather columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "605b7b0b",
   "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": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Weather'].unique()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fc0b89d5",
   "metadata": {},
   "source": [
    "#### checking how many unique value are present in weather columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "15e1a2e2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "50"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Weather'].nunique()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "030fb50e",
   "metadata": {},
   "source": [
    "so,50 uniques value are present from around 8k rows"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "26967138",
   "metadata": {},
   "source": [
    "#### lets check it in whole dataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "1496c348",
   "metadata": {},
   "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": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.nunique()\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "dfe16134",
   "metadata": {},
   "source": [
    "#### checking non null values from dataFrame using count() methods"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "f2fac2af",
   "metadata": {},
   "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": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.count()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ad2a64a6",
   "metadata": {},
   "source": [
    "Woah,There are no null values its good news for us"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e539a250",
   "metadata": {},
   "source": [
    "#### Lets see unique values count from a column "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "7d82da2c",
   "metadata": {},
   "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",
       "Freezing Fog                                  4\n",
       "Snow Showers,Fog                              4\n",
       "Moderate Snow                                 4\n",
       "Rain,Snow,Ice Pellets                         4\n",
       "Freezing Rain,Fog                             4\n",
       "Freezing Drizzle,Haze                         3\n",
       "Rain,Haze                                     3\n",
       "Thunderstorms,Rain                            3\n",
       "Thunderstorms,Rain Showers,Fog                3\n",
       "Freezing Rain,Haze                            2\n",
       "Drizzle,Snow                                  2\n",
       "Rain Showers,Snow Showers                     2\n",
       "Thunderstorms                                 2\n",
       "Moderate Snow,Blowing Snow                    2\n",
       "Rain Showers,Fog                              1\n",
       "Thunderstorms,Moderate Rain Showers,Fog       1\n",
       "Snow Pellets                                  1\n",
       "Rain,Snow,Fog                                 1\n",
       "Moderate Rain,Fog                             1\n",
       "Freezing Rain,Ice Pellets,Fog                 1\n",
       "Drizzle,Ice Pellets,Fog                       1\n",
       "Thunderstorms,Rain,Fog                        1\n",
       "Rain,Ice Pellets                              1\n",
       "Rain,Snow Grains                              1\n",
       "Thunderstorms,Heavy Rain Showers              1\n",
       "Freezing Rain,Snow Grains                     1\n",
       "Name: Weather, dtype: int64"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Weather'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "40183171",
   "metadata": {},
   "source": [
    "#### Wow,Out of 8784 times weather is mainly clear 2106 times"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "95ef552e",
   "metadata": {},
   "source": [
    "#### Let see basic information on data frame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "d05c8902",
   "metadata": {},
   "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": [
    "data.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c7ae3de7",
   "metadata": {},
   "source": [
    "## Now,time for solving some questions "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d653e78b",
   "metadata": {},
   "source": [
    "#### 1. Find all the unique 'Wind Speed' values in the data."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "71e1462a",
   "metadata": {},
   "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": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Wind Speed_km/h'].unique()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cdbaae80",
   "metadata": {},
   "source": [
    "#### 2.Find the number of times when the weather is exactly clear\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "43d4fca3",
   "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</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",
       "  </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",
       "\n",
       "   Visibility_km  Press_kPa Weather  \n",
       "0            8.0     101.24     Fog  \n",
       "1            8.0     101.24     Fog  "
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "e4d1c0b3",
   "metadata": {},
   "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",
       "Freezing Fog                                  4\n",
       "Snow Showers,Fog                              4\n",
       "Moderate Snow                                 4\n",
       "Rain,Snow,Ice Pellets                         4\n",
       "Freezing Rain,Fog                             4\n",
       "Freezing Drizzle,Haze                         3\n",
       "Rain,Haze                                     3\n",
       "Thunderstorms,Rain                            3\n",
       "Thunderstorms,Rain Showers,Fog                3\n",
       "Freezing Rain,Haze                            2\n",
       "Drizzle,Snow                                  2\n",
       "Rain Showers,Snow Showers                     2\n",
       "Thunderstorms                                 2\n",
       "Moderate Snow,Blowing Snow                    2\n",
       "Rain Showers,Fog                              1\n",
       "Thunderstorms,Moderate Rain Showers,Fog       1\n",
       "Snow Pellets                                  1\n",
       "Rain,Snow,Fog                                 1\n",
       "Moderate Rain,Fog                             1\n",
       "Freezing Rain,Ice Pellets,Fog                 1\n",
       "Drizzle,Ice Pellets,Fog                       1\n",
       "Thunderstorms,Rain,Fog                        1\n",
       "Rain,Ice Pellets                              1\n",
       "Rain,Snow Grains                              1\n",
       "Thunderstorms,Heavy Rain Showers              1\n",
       "Freezing Rain,Snow Grains                     1\n",
       "Name: Weather, dtype: int64"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Weather'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "695309ad",
   "metadata": {},
   "source": [
    "Weather is clear 1326 times"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "85e60be1",
   "metadata": {},
   "source": [
    "#### Getting data frame when weather is clear"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "71663740",
   "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</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": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.Weather == 'Clear']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fe7dd41b",
   "metadata": {},
   "source": [
    "#### 3.Finding out number of times when the wind speed was exactly 4 km/h."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "324ba019",
   "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</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",
       "  </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",
       "\n",
       "   Visibility_km  Press_kPa Weather  \n",
       "0            8.0     101.24     Fog  \n",
       "1            8.0     101.24     Fog  "
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "16a91510",
   "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</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>96</th>\n",
       "      <td>1/5/2012 0:00</td>\n",
       "      <td>-8.8</td>\n",
       "      <td>-11.7</td>\n",
       "      <td>79</td>\n",
       "      <td>4</td>\n",
       "      <td>9.7</td>\n",
       "      <td>100.32</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>1/5/2012 5:00</td>\n",
       "      <td>-7.0</td>\n",
       "      <td>-9.5</td>\n",
       "      <td>82</td>\n",
       "      <td>4</td>\n",
       "      <td>4.0</td>\n",
       "      <td>100.19</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>1/7/2012 2:00</td>\n",
       "      <td>-8.1</td>\n",
       "      <td>-11.1</td>\n",
       "      <td>79</td>\n",
       "      <td>4</td>\n",
       "      <td>19.3</td>\n",
       "      <td>100.15</td>\n",
       "      <td>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>8768</th>\n",
       "      <td>12/31/2012 8:00</td>\n",
       "      <td>-8.6</td>\n",
       "      <td>-10.3</td>\n",
       "      <td>87</td>\n",
       "      <td>4</td>\n",
       "      <td>3.2</td>\n",
       "      <td>101.14</td>\n",
       "      <td>Snow Showers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8769</th>\n",
       "      <td>12/31/2012 9:00</td>\n",
       "      <td>-8.1</td>\n",
       "      <td>-9.6</td>\n",
       "      <td>89</td>\n",
       "      <td>4</td>\n",
       "      <td>2.4</td>\n",
       "      <td>101.09</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8770</th>\n",
       "      <td>12/31/2012 10:00</td>\n",
       "      <td>-7.4</td>\n",
       "      <td>-8.9</td>\n",
       "      <td>89</td>\n",
       "      <td>4</td>\n",
       "      <td>6.4</td>\n",
       "      <td>101.05</td>\n",
       "      <td>Snow,Fog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8772</th>\n",
       "      <td>12/31/2012 12:00</td>\n",
       "      <td>-5.8</td>\n",
       "      <td>-7.5</td>\n",
       "      <td>88</td>\n",
       "      <td>4</td>\n",
       "      <td>12.9</td>\n",
       "      <td>100.78</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8773</th>\n",
       "      <td>12/31/2012 13:00</td>\n",
       "      <td>-4.6</td>\n",
       "      <td>-6.6</td>\n",
       "      <td>86</td>\n",
       "      <td>4</td>\n",
       "      <td>12.9</td>\n",
       "      <td>100.63</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>474 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",
       "96       1/5/2012 0:00    -8.8             -11.7         79                4   \n",
       "101      1/5/2012 5:00    -7.0              -9.5         82                4   \n",
       "146      1/7/2012 2:00    -8.1             -11.1         79                4   \n",
       "...                ...     ...               ...        ...              ...   \n",
       "8768   12/31/2012 8:00    -8.6             -10.3         87                4   \n",
       "8769   12/31/2012 9:00    -8.1              -9.6         89                4   \n",
       "8770  12/31/2012 10:00    -7.4              -8.9         89                4   \n",
       "8772  12/31/2012 12:00    -5.8              -7.5         88                4   \n",
       "8773  12/31/2012 13:00    -4.6              -6.6         86                4   \n",
       "\n",
       "      Visibility_km  Press_kPa       Weather  \n",
       "0               8.0     101.24           Fog  \n",
       "1               8.0     101.24           Fog  \n",
       "96              9.7     100.32          Snow  \n",
       "101             4.0     100.19          Snow  \n",
       "146            19.3     100.15        Cloudy  \n",
       "...             ...        ...           ...  \n",
       "8768            3.2     101.14  Snow Showers  \n",
       "8769            2.4     101.09          Snow  \n",
       "8770            6.4     101.05      Snow,Fog  \n",
       "8772           12.9     100.78          Snow  \n",
       "8773           12.9     100.63          Snow  \n",
       "\n",
       "[474 rows x 8 columns]"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.groupby('Wind Speed_km/h').get_group(4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "e434ffd5",
   "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</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>96</th>\n",
       "      <td>1/5/2012 0:00</td>\n",
       "      <td>-8.8</td>\n",
       "      <td>-11.7</td>\n",
       "      <td>79</td>\n",
       "      <td>4</td>\n",
       "      <td>9.7</td>\n",
       "      <td>100.32</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>1/5/2012 5:00</td>\n",
       "      <td>-7.0</td>\n",
       "      <td>-9.5</td>\n",
       "      <td>82</td>\n",
       "      <td>4</td>\n",
       "      <td>4.0</td>\n",
       "      <td>100.19</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>1/7/2012 2:00</td>\n",
       "      <td>-8.1</td>\n",
       "      <td>-11.1</td>\n",
       "      <td>79</td>\n",
       "      <td>4</td>\n",
       "      <td>19.3</td>\n",
       "      <td>100.15</td>\n",
       "      <td>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>8768</th>\n",
       "      <td>12/31/2012 8:00</td>\n",
       "      <td>-8.6</td>\n",
       "      <td>-10.3</td>\n",
       "      <td>87</td>\n",
       "      <td>4</td>\n",
       "      <td>3.2</td>\n",
       "      <td>101.14</td>\n",
       "      <td>Snow Showers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8769</th>\n",
       "      <td>12/31/2012 9:00</td>\n",
       "      <td>-8.1</td>\n",
       "      <td>-9.6</td>\n",
       "      <td>89</td>\n",
       "      <td>4</td>\n",
       "      <td>2.4</td>\n",
       "      <td>101.09</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8770</th>\n",
       "      <td>12/31/2012 10:00</td>\n",
       "      <td>-7.4</td>\n",
       "      <td>-8.9</td>\n",
       "      <td>89</td>\n",
       "      <td>4</td>\n",
       "      <td>6.4</td>\n",
       "      <td>101.05</td>\n",
       "      <td>Snow,Fog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8772</th>\n",
       "      <td>12/31/2012 12:00</td>\n",
       "      <td>-5.8</td>\n",
       "      <td>-7.5</td>\n",
       "      <td>88</td>\n",
       "      <td>4</td>\n",
       "      <td>12.9</td>\n",
       "      <td>100.78</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8773</th>\n",
       "      <td>12/31/2012 13:00</td>\n",
       "      <td>-4.6</td>\n",
       "      <td>-6.6</td>\n",
       "      <td>86</td>\n",
       "      <td>4</td>\n",
       "      <td>12.9</td>\n",
       "      <td>100.63</td>\n",
       "      <td>Snow</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>474 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",
       "96       1/5/2012 0:00    -8.8             -11.7         79                4   \n",
       "101      1/5/2012 5:00    -7.0              -9.5         82                4   \n",
       "146      1/7/2012 2:00    -8.1             -11.1         79                4   \n",
       "...                ...     ...               ...        ...              ...   \n",
       "8768   12/31/2012 8:00    -8.6             -10.3         87                4   \n",
       "8769   12/31/2012 9:00    -8.1              -9.6         89                4   \n",
       "8770  12/31/2012 10:00    -7.4              -8.9         89                4   \n",
       "8772  12/31/2012 12:00    -5.8              -7.5         88                4   \n",
       "8773  12/31/2012 13:00    -4.6              -6.6         86                4   \n",
       "\n",
       "      Visibility_km  Press_kPa       Weather  \n",
       "0               8.0     101.24           Fog  \n",
       "1               8.0     101.24           Fog  \n",
       "96              9.7     100.32          Snow  \n",
       "101             4.0     100.19          Snow  \n",
       "146            19.3     100.15        Cloudy  \n",
       "...             ...        ...           ...  \n",
       "8768            3.2     101.14  Snow Showers  \n",
       "8769            2.4     101.09          Snow  \n",
       "8770            6.4     101.05      Snow,Fog  \n",
       "8772           12.9     100.78          Snow  \n",
       "8773           12.9     100.63          Snow  \n",
       "\n",
       "[474 rows x 8 columns]"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data['Wind Speed_km/h'] == 4]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f3824148",
   "metadata": {},
   "source": [
    "Hence,Wind speed is 4km/h 474 times."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7df6e7af",
   "metadata": {},
   "source": [
    "#### 4.Find out the null values in the data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "c10a28b4",
   "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": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.isnull().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9123e62b",
   "metadata": {},
   "source": [
    "Hence, There are no null values"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "bd0094b5",
   "metadata": {},
   "source": [
    "#### 5.Rename the column name 'Weather' of the dataframe to 'Weather Condition'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "026c97af",
   "metadata": {},
   "outputs": [],
   "source": [
    "data.rename(columns = {'Weather' : 'Weather Condition'},inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "f2a4f002",
   "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",
       "  </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",
       "\n",
       "   Visibility_km  Press_kPa Weather Condition  \n",
       "0            8.0     101.24               Fog  \n",
       "1            8.0     101.24               Fog  "
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head(2)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c0cdb4ae",
   "metadata": {},
   "source": [
    "#### 6. Find the mean of Visibility_km."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "07f76b38",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "27.66444672131151"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Visibility_km'].mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ce04fa6c",
   "metadata": {},
   "source": [
    "Hence, The average visiblity is 27.66444672131151"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b3323636",
   "metadata": {},
   "source": [
    "#### 7. What is the standard deviation of pressure in the data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "befb169e",
   "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",
       "  </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",
       "\n",
       "   Visibility_km  Press_kPa Weather Condition  \n",
       "0            8.0     101.24               Fog  \n",
       "1            8.0     101.24               Fog  "
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "a97858ea",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.8440047459486474"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Press_kPa'].std()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "85841d17",
   "metadata": {},
   "source": [
    "The deviation between  pressure is 0.8440047459486474"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "aac64f11",
   "metadata": {},
   "source": [
    "#### 8.What is the variance of \"Relative Humidity\" in data ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "45c72871",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "286.2485501984998"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Rel Hum_%'].var()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "39a0f9f9",
   "metadata": {},
   "source": [
    "There is high fluctuation in humidity and its variance is 286.2485501984998"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b192c22c",
   "metadata": {},
   "source": [
    "#### 9. Find all the instances when snow was recorded"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "id": "0a86e283",
   "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",
       "  </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",
       "\n",
       "   Visibility_km  Press_kPa Weather Condition  \n",
       "0            8.0     101.24               Fog  \n",
       "1            8.0     101.24               Fog  "
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "id": "ee55983d",
   "metadata": {},
   "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",
       "Freezing Fog                                  4\n",
       "Snow Showers,Fog                              4\n",
       "Moderate Snow                                 4\n",
       "Rain,Snow,Ice Pellets                         4\n",
       "Freezing Rain,Fog                             4\n",
       "Freezing Drizzle,Haze                         3\n",
       "Rain,Haze                                     3\n",
       "Thunderstorms,Rain                            3\n",
       "Thunderstorms,Rain Showers,Fog                3\n",
       "Freezing Rain,Haze                            2\n",
       "Drizzle,Snow                                  2\n",
       "Rain Showers,Snow Showers                     2\n",
       "Thunderstorms                                 2\n",
       "Moderate Snow,Blowing Snow                    2\n",
       "Rain Showers,Fog                              1\n",
       "Thunderstorms,Moderate Rain Showers,Fog       1\n",
       "Snow Pellets                                  1\n",
       "Rain,Snow,Fog                                 1\n",
       "Moderate Rain,Fog                             1\n",
       "Freezing Rain,Ice Pellets,Fog                 1\n",
       "Drizzle,Ice Pellets,Fog                       1\n",
       "Thunderstorms,Rain,Fog                        1\n",
       "Rain,Ice Pellets                              1\n",
       "Rain,Snow Grains                              1\n",
       "Thunderstorms,Heavy Rain Showers              1\n",
       "Freezing Rain,Snow Grains                     1\n",
       "Name: Weather Condition, dtype: int64"
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Weather Condition'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "828ce6e3",
   "metadata": {},
   "source": [
    "Snow was recorded 390 times "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "37f8112c",
   "metadata": {},
   "source": [
    "#### 10. Find all the instances when 'Wind Speed is above 24 'and 'visiblity is 25'."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "id": "ee83efae",
   "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",
       "  </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",
       "\n",
       "   Visibility_km  Press_kPa Weather Condition  \n",
       "0            8.0     101.24               Fog  \n",
       "1            8.0     101.24               Fog  "
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "id": "a4af9a7c",
   "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>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>8705</th>\n",
       "      <td>12/28/2012 17:00</td>\n",
       "      <td>-8.6</td>\n",
       "      <td>-12.0</td>\n",
       "      <td>76</td>\n",
       "      <td>26</td>\n",
       "      <td>25.0</td>\n",
       "      <td>101.34</td>\n",
       "      <td>Mainly Clear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8753</th>\n",
       "      <td>12/30/2012 17:00</td>\n",
       "      <td>-12.1</td>\n",
       "      <td>-15.8</td>\n",
       "      <td>74</td>\n",
       "      <td>28</td>\n",
       "      <td>25.0</td>\n",
       "      <td>101.26</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>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>308 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",
       "8705  12/28/2012 17:00    -8.6             -12.0         76               26   \n",
       "8753  12/30/2012 17:00   -12.1             -15.8         74               28   \n",
       "8755  12/30/2012 19:00   -13.4             -16.5         77               26   \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",
       "8705           25.0     101.34      Mainly Clear  \n",
       "8753           25.0     101.26      Mainly Clear  \n",
       "8755           25.0     101.47      Mainly Clear  \n",
       "8759           25.0     101.52     Mostly Cloudy  \n",
       "8760           25.0     101.51            Cloudy  \n",
       "\n",
       "[308 rows x 8 columns]"
      ]
     },
     "execution_count": 96,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[(data['Wind Speed_km/h'] > 24) & (data['Visibility_km'] == 25)]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "abb949ee",
   "metadata": {},
   "source": [
    "hence, 308 times 'Wind Speed is above 24 'and 'visiblity is 25'.¶"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ff2ddb52",
   "metadata": {},
   "source": [
    "#### 11.What is the Mean value of each column against each 'Weather Condition'."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "id": "65f67745",
   "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>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": 99,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.groupby('Weather Condition').mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "id": "93fa79e9",
   "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",
       "    <tr>\n",
       "      <th>Drizzle,Snow</th>\n",
       "      <td>12/17/2012 15:00</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.1</td>\n",
       "      <td>92</td>\n",
       "      <td>9</td>\n",
       "      <td>9.7</td>\n",
       "      <td>100.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drizzle,Snow,Fog</th>\n",
       "      <td>12/18/2012 21:00</td>\n",
       "      <td>0.3</td>\n",
       "      <td>-0.1</td>\n",
       "      <td>92</td>\n",
       "      <td>7</td>\n",
       "      <td>2.4</td>\n",
       "      <td>97.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fog</th>\n",
       "      <td>1/1/2012 0:00</td>\n",
       "      <td>-16.0</td>\n",
       "      <td>-17.2</td>\n",
       "      <td>80</td>\n",
       "      <td>0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>98.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Drizzle</th>\n",
       "      <td>1/13/2012 10:00</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>-12.2</td>\n",
       "      <td>78</td>\n",
       "      <td>6</td>\n",
       "      <td>4.8</td>\n",
       "      <td>98.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Drizzle,Fog</th>\n",
       "      <td>1/1/2012 2:00</td>\n",
       "      <td>-6.4</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>82</td>\n",
       "      <td>6</td>\n",
       "      <td>3.6</td>\n",
       "      <td>98.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Drizzle,Haze</th>\n",
       "      <td>2/1/2012 11:00</td>\n",
       "      <td>-5.8</td>\n",
       "      <td>-8.3</td>\n",
       "      <td>81</td>\n",
       "      <td>9</td>\n",
       "      <td>2.0</td>\n",
       "      <td>100.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Drizzle,Snow</th>\n",
       "      <td>1/13/2012 3:00</td>\n",
       "      <td>-8.3</td>\n",
       "      <td>-10.4</td>\n",
       "      <td>79</td>\n",
       "      <td>6</td>\n",
       "      <td>2.4</td>\n",
       "      <td>99.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Fog</th>\n",
       "      <td>1/22/2012 6:00</td>\n",
       "      <td>-19.0</td>\n",
       "      <td>-22.9</td>\n",
       "      <td>71</td>\n",
       "      <td>0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>101.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Rain</th>\n",
       "      <td>1/13/2012 11:00</td>\n",
       "      <td>-6.5</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>81</td>\n",
       "      <td>7</td>\n",
       "      <td>2.8</td>\n",
       "      <td>98.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Rain,Fog</th>\n",
       "      <td>1/17/2012 23:00</td>\n",
       "      <td>-6.1</td>\n",
       "      <td>-8.7</td>\n",
       "      <td>82</td>\n",
       "      <td>7</td>\n",
       "      <td>2.8</td>\n",
       "      <td>98.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freezing Rain,Haze</th>\n",
       "      <td>2/1/2012 14:00</td>\n",
       "      <td>-4.9</td>\n",
       "      <td>-7.5</td>\n",
       "      <td>82</td>\n",
       "      <td>6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>100.34</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>1/22/2012 12:00</td>\n",
       "      <td>-11.5</td>\n",
       "      <td>-16.0</td>\n",
       "      <td>68</td>\n",
       "      <td>0</td>\n",
       "      <td>4.8</td>\n",
       "      <td>100.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mainly Clear</th>\n",
       "      <td>1/10/2012 11:00</td>\n",
       "      <td>-22.8</td>\n",
       "      <td>-28.0</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>12.9</td>\n",
       "      <td>98.67</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>1/12/2012 15:00</td>\n",
       "      <td>-6.3</td>\n",
       "      <td>-7.6</td>\n",
       "      <td>83</td>\n",
       "      <td>26</td>\n",
       "      <td>0.6</td>\n",
       "      <td>99.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Moderate Snow,Blowing Snow</th>\n",
       "      <td>12/27/2012 10:00</td>\n",
       "      <td>-5.5</td>\n",
       "      <td>-6.6</td>\n",
       "      <td>92</td>\n",
       "      <td>39</td>\n",
       "      <td>0.6</td>\n",
       "      <td>100.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mostly Cloudy</th>\n",
       "      <td>1/1/2012 16:00</td>\n",
       "      <td>-23.2</td>\n",
       "      <td>-28.5</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>11.3</td>\n",
       "      <td>98.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain</th>\n",
       "      <td>1/1/2012 18:00</td>\n",
       "      <td>0.3</td>\n",
       "      <td>-5.7</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>97.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain Showers</th>\n",
       "      <td>1/1/2012 22:00</td>\n",
       "      <td>1.6</td>\n",
       "      <td>-7.2</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>6.4</td>\n",
       "      <td>98.51</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>11/4/2012 8:00</td>\n",
       "      <td>2.1</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>75</td>\n",
       "      <td>17</td>\n",
       "      <td>19.3</td>\n",
       "      <td>101.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain,Fog</th>\n",
       "      <td>1/23/2012 18:00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.2</td>\n",
       "      <td>83</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>98.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rain,Haze</th>\n",
       "      <td>3/13/2012 7:00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>81</td>\n",
       "      <td>7</td>\n",
       "      <td>4.0</td>\n",
       "      <td>100.50</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>1/10/2012 5:00</td>\n",
       "      <td>0.6</td>\n",
       "      <td>-1.7</td>\n",
       "      <td>81</td>\n",
       "      <td>13</td>\n",
       "      <td>2.4</td>\n",
       "      <td>98.18</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 1:00</td>\n",
       "      <td>0.9</td>\n",
       "      <td>-0.7</td>\n",
       "      <td>88</td>\n",
       "      <td>17</td>\n",
       "      <td>4.8</td>\n",
       "      <td>99.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow</th>\n",
       "      <td>1/10/2012 1:00</td>\n",
       "      <td>-16.7</td>\n",
       "      <td>-24.6</td>\n",
       "      <td>41</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>97.75</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>1/12/2012 7:00</td>\n",
       "      <td>-13.3</td>\n",
       "      <td>-19.3</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "      <td>2.4</td>\n",
       "      <td>99.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow Showers,Fog</th>\n",
       "      <td>12/26/2012 9:00</td>\n",
       "      <td>-11.3</td>\n",
       "      <td>-12.7</td>\n",
       "      <td>89</td>\n",
       "      <td>7</td>\n",
       "      <td>4.0</td>\n",
       "      <td>100.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow,Blowing Snow</th>\n",
       "      <td>1/13/2012 21:00</td>\n",
       "      <td>-12.0</td>\n",
       "      <td>-16.2</td>\n",
       "      <td>70</td>\n",
       "      <td>24</td>\n",
       "      <td>0.6</td>\n",
       "      <td>98.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow,Fog</th>\n",
       "      <td>12/16/2012 15:00</td>\n",
       "      <td>-10.1</td>\n",
       "      <td>-12.0</td>\n",
       "      <td>77</td>\n",
       "      <td>4</td>\n",
       "      <td>1.2</td>\n",
       "      <td>99.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow,Haze</th>\n",
       "      <td>2/1/2012 17:00</td>\n",
       "      <td>-4.3</td>\n",
       "      <td>-7.2</td>\n",
       "      <td>80</td>\n",
       "      <td>0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>100.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Snow,Ice Pellets</th>\n",
       "      <td>12/10/2012 3:00</td>\n",
       "      <td>-4.3</td>\n",
       "      <td>-5.9</td>\n",
       "      <td>76</td>\n",
       "      <td>19</td>\n",
       "      <td>2.8</td>\n",
       "      <td>99.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thunderstorms</th>\n",
       "      <td>7/16/2012 1:00</td>\n",
       "      <td>21.6</td>\n",
       "      <td>19.4</td>\n",
       "      <td>67</td>\n",
       "      <td>0</td>\n",
       "      <td>24.1</td>\n",
       "      <td>99.84</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>5/25/2012 20:00</td>\n",
       "      <td>19.4</td>\n",
       "      <td>18.2</td>\n",
       "      <td>83</td>\n",
       "      <td>4</td>\n",
       "      <td>16.1</td>\n",
       "      <td>100.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thunderstorms,Rain Showers</th>\n",
       "      <td>5/29/2012 16:00</td>\n",
       "      <td>11.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>68</td>\n",
       "      <td>7</td>\n",
       "      <td>6.4</td>\n",
       "      <td>99.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thunderstorms,Rain Showers,Fog</th>\n",
       "      <td>6/29/2012 3:00</td>\n",
       "      <td>19.5</td>\n",
       "      <td>16.1</td>\n",
       "      <td>80</td>\n",
       "      <td>7</td>\n",
       "      <td>9.7</td>\n",
       "      <td>99.71</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                                      1/11/2012 1:00   -23.3   \n",
       "Cloudy                                     1/1/2012 17:00   -21.4   \n",
       "Drizzle                                   1/23/2012 21:00     1.1   \n",
       "Drizzle,Fog                               1/23/2012 20:00     0.0   \n",
       "Drizzle,Ice Pellets,Fog                   12/17/2012 9:00     0.4   \n",
       "Drizzle,Snow                             12/17/2012 15:00     0.9   \n",
       "Drizzle,Snow,Fog                         12/18/2012 21:00     0.3   \n",
       "Fog                                         1/1/2012 0:00   -16.0   \n",
       "Freezing Drizzle                          1/13/2012 10:00    -9.0   \n",
       "Freezing Drizzle,Fog                        1/1/2012 2:00    -6.4   \n",
       "Freezing Drizzle,Haze                      2/1/2012 11:00    -5.8   \n",
       "Freezing Drizzle,Snow                      1/13/2012 3:00    -8.3   \n",
       "Freezing Fog                               1/22/2012 6:00   -19.0   \n",
       "Freezing Rain                             1/13/2012 11:00    -6.5   \n",
       "Freezing Rain,Fog                         1/17/2012 23:00    -6.1   \n",
       "Freezing Rain,Haze                         2/1/2012 14: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                                      1/22/2012 12:00   -11.5   \n",
       "Mainly Clear                              1/10/2012 11:00   -22.8   \n",
       "Moderate Rain,Fog                         12/10/2012 8:00     1.7   \n",
       "Moderate Snow                             1/12/2012 15:00    -6.3   \n",
       "Moderate Snow,Blowing Snow               12/27/2012 10:00    -5.5   \n",
       "Mostly Cloudy                              1/1/2012 16:00   -23.2   \n",
       "Rain                                       1/1/2012 18:00     0.3   \n",
       "Rain Showers                               1/1/2012 22:00     1.6   \n",
       "Rain Showers,Fog                          10/20/2012 3:00    12.8   \n",
       "Rain Showers,Snow Showers                  11/4/2012 8:00     2.1   \n",
       "Rain,Fog                                  1/23/2012 18:00     0.0   \n",
       "Rain,Haze                                  3/13/2012 7:00     4.0   \n",
       "Rain,Ice Pellets                          12/18/2012 5:00     0.6   \n",
       "Rain,Snow                                  1/10/2012 5:00     0.6   \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 1:00     0.9   \n",
       "Snow                                       1/10/2012 1:00   -16.7   \n",
       "Snow Pellets                             11/24/2012 15:00     0.7   \n",
       "Snow Showers                               1/12/2012 7:00   -13.3   \n",
       "Snow Showers,Fog                          12/26/2012 9:00   -11.3   \n",
       "Snow,Blowing Snow                         1/13/2012 21:00   -12.0   \n",
       "Snow,Fog                                 12/16/2012 15:00   -10.1   \n",
       "Snow,Haze                                  2/1/2012 17:00    -4.3   \n",
       "Snow,Ice Pellets                          12/10/2012 3:00    -4.3   \n",
       "Thunderstorms                              7/16/2012 1:00    21.6   \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                        5/25/2012 20:00    19.4   \n",
       "Thunderstorms,Rain Showers                5/29/2012 16:00    11.0   \n",
       "Thunderstorms,Rain Showers,Fog             6/29/2012 3:00    19.5   \n",
       "Thunderstorms,Rain,Fog                     7/17/2012 5:00    20.6   \n",
       "\n",
       "                                         Dew Point Temp_C  Rel Hum_%  \\\n",
       "Weather Condition                                                      \n",
       "Clear                                               -28.5         20   \n",
       "Cloudy                                              -26.8         18   \n",
       "Drizzle                                              -0.2         74   \n",
       "Drizzle,Fog                                          -1.6         85   \n",
       "Drizzle,Ice Pellets,Fog                              -0.7         92   \n",
       "Drizzle,Snow                                          0.1         92   \n",
       "Drizzle,Snow,Fog                                     -0.1         92   \n",
       "Fog                                                 -17.2         80   \n",
       "Freezing Drizzle                                    -12.2         78   \n",
       "Freezing Drizzle,Fog                                 -9.0         82   \n",
       "Freezing Drizzle,Haze                                -8.3         81   \n",
       "Freezing Drizzle,Snow                               -10.4         79   \n",
       "Freezing Fog                                        -22.9         71   \n",
       "Freezing Rain                                        -9.0         81   \n",
       "Freezing Rain,Fog                                    -8.7         82   \n",
       "Freezing Rain,Haze                                   -7.5         82   \n",
       "Freezing Rain,Ice Pellets,Fog                        -3.7         92   \n",
       "Freezing Rain,Snow Grains                            -7.3         84   \n",
       "Haze                                                -16.0         68   \n",
       "Mainly Clear                                        -28.0         20   \n",
       "Moderate Rain,Fog                                     0.8         94   \n",
       "Moderate Snow                                        -7.6         83   \n",
       "Moderate Snow,Blowing Snow                           -6.6         92   \n",
       "Mostly Cloudy                                       -28.5         18   \n",
       "Rain                                                 -5.7         40   \n",
       "Rain Showers                                         -7.2         37   \n",
       "Rain Showers,Fog                                     12.1         96   \n",
       "Rain Showers,Snow Showers                            -1.8         75   \n",
       "Rain,Fog                                             -1.2         83   \n",
       "Rain,Haze                                             1.0         81   \n",
       "Rain,Ice Pellets                                     -0.6         92   \n",
       "Rain,Snow                                            -1.7         81   \n",
       "Rain,Snow Grains                                     -2.1         75   \n",
       "Rain,Snow,Fog                                         0.3         96   \n",
       "Rain,Snow,Ice Pellets                                -0.7         88   \n",
       "Snow                                                -24.6         41   \n",
       "Snow Pellets                                         -6.4         59   \n",
       "Snow Showers                                        -19.3         52   \n",
       "Snow Showers,Fog                                    -12.7         89   \n",
       "Snow,Blowing Snow                                   -16.2         70   \n",
       "Snow,Fog                                            -12.0         77   \n",
       "Snow,Haze                                            -7.2         80   \n",
       "Snow,Ice Pellets                                     -5.9         76   \n",
       "Thunderstorms                                        19.4         67   \n",
       "Thunderstorms,Heavy Rain Showers                      9.0         88   \n",
       "Thunderstorms,Moderate Rain Showers,Fog              18.5         93   \n",
       "Thunderstorms,Rain                                   18.2         83   \n",
       "Thunderstorms,Rain Showers                            7.0         68   \n",
       "Thunderstorms,Rain Showers,Fog                       16.1         80   \n",
       "Thunderstorms,Rain,Fog                               18.6         88   \n",
       "\n",
       "                                         Wind Speed_km/h  Visibility_km  \\\n",
       "Weather Condition                                                         \n",
       "Clear                                                  0           11.3   \n",
       "Cloudy                                                 0           11.3   \n",
       "Drizzle                                                0            6.4   \n",
       "Drizzle,Fog                                            0            1.0   \n",
       "Drizzle,Ice Pellets,Fog                               20            4.0   \n",
       "Drizzle,Snow                                           9            9.7   \n",
       "Drizzle,Snow,Fog                                       7            2.4   \n",
       "Fog                                                    0            0.2   \n",
       "Freezing Drizzle                                       6            4.8   \n",
       "Freezing Drizzle,Fog                                   6            3.6   \n",
       "Freezing Drizzle,Haze                                  9            2.0   \n",
       "Freezing Drizzle,Snow                                  6            2.4   \n",
       "Freezing Fog                                           0            0.2   \n",
       "Freezing Rain                                          7            2.8   \n",
       "Freezing Rain,Fog                                      7            2.8   \n",
       "Freezing Rain,Haze                                     6            2.0   \n",
       "Freezing Rain,Ice Pellets,Fog                         28            8.0   \n",
       "Freezing Rain,Snow Grains                             32            4.8   \n",
       "Haze                                                   0            4.8   \n",
       "Mainly Clear                                           0           12.9   \n",
       "Moderate Rain,Fog                                     17            6.4   \n",
       "Moderate Snow                                         26            0.6   \n",
       "Moderate Snow,Blowing Snow                            39            0.6   \n",
       "Mostly Cloudy                                          0           11.3   \n",
       "Rain                                                   0            4.0   \n",
       "Rain Showers                                           0            6.4   \n",
       "Rain Showers,Fog                                      13            6.4   \n",
       "Rain Showers,Snow Showers                             17           19.3   \n",
       "Rain,Fog                                               0            2.0   \n",
       "Rain,Haze                                              7            4.0   \n",
       "Rain,Ice Pellets                                      24            9.7   \n",
       "Rain,Snow                                             13            2.4   \n",
       "Rain,Snow Grains                                      26           25.0   \n",
       "Rain,Snow,Fog                                          9            6.4   \n",
       "Rain,Snow,Ice Pellets                                 17            4.8   \n",
       "Snow                                                   0            1.0   \n",
       "Snow Pellets                                          35            2.4   \n",
       "Snow Showers                                           0            2.4   \n",
       "Snow Showers,Fog                                       7            4.0   \n",
       "Snow,Blowing Snow                                     24            0.6   \n",
       "Snow,Fog                                               4            1.2   \n",
       "Snow,Haze                                              0            4.0   \n",
       "Snow,Ice Pellets                                      19            2.8   \n",
       "Thunderstorms                                          0           24.1   \n",
       "Thunderstorms,Heavy Rain Showers                       9            2.4   \n",
       "Thunderstorms,Moderate Rain Showers,Fog               15            3.2   \n",
       "Thunderstorms,Rain                                     4           16.1   \n",
       "Thunderstorms,Rain Showers                             7            6.4   \n",
       "Thunderstorms,Rain Showers,Fog                         7            9.7   \n",
       "Thunderstorms,Rain,Fog                                19            4.8   \n",
       "\n",
       "                                         Press_kPa  \n",
       "Weather Condition                                   \n",
       "Clear                                        99.52  \n",
       "Cloudy                                       98.39  \n",
       "Drizzle                                      97.84  \n",
       "Drizzle,Fog                                  98.65  \n",
       "Drizzle,Ice Pellets,Fog                     100.79  \n",
       "Drizzle,Snow                                100.63  \n",
       "Drizzle,Snow,Fog                             97.79  \n",
       "Fog                                          98.31  \n",
       "Freezing Drizzle                             98.44  \n",
       "Freezing Drizzle,Fog                         98.74  \n",
       "Freezing Drizzle,Haze                       100.28  \n",
       "Freezing Drizzle,Snow                        99.19  \n",
       "Freezing Fog                                101.97  \n",
       "Freezing Rain                                98.22  \n",
       "Freezing Rain,Fog                            98.32  \n",
       "Freezing Rain,Haze                          100.34  \n",
       "Freezing Rain,Ice Pellets,Fog               100.95  \n",
       "Freezing Rain,Snow Grains                    98.56  \n",
       "Haze                                        100.35  \n",
       "Mainly Clear                                 98.67  \n",
       "Moderate Rain,Fog                            99.98  \n",
       "Moderate Snow                                99.88  \n",
       "Moderate Snow,Blowing Snow                  100.50  \n",
       "Mostly Cloudy                                98.36  \n",
       "Rain                                         97.52  \n",
       "Rain Showers                                 98.51  \n",
       "Rain Showers,Fog                             99.83  \n",
       "Rain Showers,Snow Showers                   101.09  \n",
       "Rain,Fog                                     98.61  \n",
       "Rain,Haze                                   100.50  \n",
       "Rain,Ice Pellets                            100.12  \n",
       "Rain,Snow                                    98.18  \n",
       "Rain,Snow Grains                            100.60  \n",
       "Rain,Snow,Fog                               100.73  \n",
       "Rain,Snow,Ice Pellets                        99.85  \n",
       "Snow                                         97.75  \n",
       "Snow Pellets                                 99.70  \n",
       "Snow Showers                                 99.49  \n",
       "Snow Showers,Fog                            100.63  \n",
       "Snow,Blowing Snow                            98.11  \n",
       "Snow,Fog                                     99.38  \n",
       "Snow,Haze                                   100.61  \n",
       "Snow,Ice Pellets                             99.40  \n",
       "Thunderstorms                                99.84  \n",
       "Thunderstorms,Heavy Rain Showers            100.26  \n",
       "Thunderstorms,Moderate Rain Showers,Fog     100.01  \n",
       "Thunderstorms,Rain                          100.19  \n",
       "Thunderstorms,Rain Showers                   99.65  \n",
       "Thunderstorms,Rain Showers,Fog               99.71  \n",
       "Thunderstorms,Rain,Fog                      100.08  "
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.groupby('Weather Condition').min()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c71ab6df",
   "metadata": {},
   "source": [
    "#### 12. What is the Minimum & Maximum value of each column against each 'Weather Condition ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "id": "7e129336",
   "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>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": 102,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.groupby('Weather Condition').max()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "370b829d",
   "metadata": {},
   "source": [
    "#### 13.Show all the Records where Weather Condition is Fog."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "id": "72e88948",
   "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>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": 104,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data['Weather Condition'] == 'Fog']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0d9b50f4",
   "metadata": {},
   "source": [
    "#### 14. Find all instances when 'Weather is Clear' or 'Visibility is above 40'."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "id": "dd9f7574",
   "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>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": 108,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[(data['Weather Condition'] == 'Clear') | (data['Visibility_km'] > 40)]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c40f9f3f",
   "metadata": {},
   "source": [
    "#### 15.  Find all instances when :\n",
    "#### A. 'Weather is Clear' and 'Relative Humidity is greater than 50'\n",
    "#### or\n",
    "#### B. 'Visibility is above 40'\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "id": "3c766fb7",
   "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",
       "  </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",
       "\n",
       "   Visibility_km  Press_kPa Weather Condition  \n",
       "0            8.0     101.24               Fog  \n",
       "1            8.0     101.24               Fog  "
      ]
     },
     "execution_count": 107,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "id": "a530a73b",
   "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>8748</th>\n",
       "      <td>12/30/2012 12:00</td>\n",
       "      <td>-12.2</td>\n",
       "      <td>-15.7</td>\n",
       "      <td>75</td>\n",
       "      <td>26</td>\n",
       "      <td>48.3</td>\n",
       "      <td>100.91</td>\n",
       "      <td>Mostly Cloudy</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",
       "  </tbody>\n",
       "</table>\n",
       "<p>2014 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",
       "8748  12/30/2012 12:00   -12.2             -15.7         75               26   \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",
       "\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",
       "8748           48.3     100.91     Mostly Cloudy  \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",
       "\n",
       "[2014 rows x 8 columns]"
      ]
     },
     "execution_count": 109,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[((data['Weather Condition'] == 'clear') & (data['Rel Hum_%'] > 50 )) | (data['Visibility_km'] > 40)]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "16a4b389",
   "metadata": {},
   "source": [
    "## Thanks for watching this projects to the end"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}