Weather Data.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Untitled6.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "authorship_tag": "ABX9TyPYnZap/JkhZWxYw6kKxYms",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/ephemerno/testing/blob/master/Weather%20Data.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "HZB0NHT7oUaD"
      },
      "source": [
        "import pandas as pd\r\n",
        "data = pd.read_csv('/content/1. Weather Data(1).csv')"
      ],
      "execution_count": 4,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Eju_poXip1ro"
      },
      "source": [
        "data"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "gc3znRj9p-0w"
      },
      "source": [
        "data.head()"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "T9iYHsuuqH32"
      },
      "source": [
        "data.shape"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "fuJOJU1LqPVQ"
      },
      "source": [
        "data.index"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "FMzAgZaFqYCL"
      },
      "source": [
        "data.columns"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ppqZdPFFrRAP"
      },
      "source": [
        "data.dtypes"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Rx1kzx0BreHM"
      },
      "source": [
        "data['Weather'].unique()"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "_b22zPihr1zV"
      },
      "source": [
        "data.nunique()"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "EeU1_9TvsA9G"
      },
      "source": [
        "data.count()"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "DuIZqc89ulq8"
      },
      "source": [
        "data['Weather'].value_counts()"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "0P4Mbuksu1w0"
      },
      "source": [
        "data.info()"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "duMrBVXSvD8Y"
      },
      "source": [
        "data.head(2)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "XwF-AyqCvJ6q"
      },
      "source": [
        "data.nunique()"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ZQC1hW-6vQyY"
      },
      "source": [
        "data['Wind Speed_km/h'].nunique()"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Jrn2Hb38vfiN"
      },
      "source": [
        "data['Wind Speed_km/h'].unique()"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "EcCzZd9xycz-"
      },
      "source": [
        "**Find the number of times when the \"Weather is exactly Clear**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "zG2ZstHmzLZa"
      },
      "source": [
        "data.head(2)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "HbdbTQLPzRVO"
      },
      "source": [
        "#value_counts()\r\n",
        "data.Weather.value_counts()"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "E-FKHzlw0ok4"
      },
      "source": [
        "#data.head(2)\r\n",
        "data[data.Weather == 'Clear']"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Esze6Pbx_jYy"
      },
      "source": [
        "#data.head(2)\r\n",
        "data.groupby('Weather').get_group('Clear')"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "1gU-bdo7AG72"
      },
      "source": [
        "**Find the number of times when the 'Wind Speed was exactly 4 km/h**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "7swoDwtrAQ91",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 528
        },
        "outputId": "4d072d4f-c2b8-4840-e4fa-e7eb24fcb4b7"
      },
      "source": [
        "data.head(2)\r\n",
        "data[data['Wind Speed_km/h'] == 4]"
      ],
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "execute_result",
          "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  ...  Press_kPa       Weather\n",
              "0        1/1/2012 0:00    -1.8  ...     101.24           Fog\n",
              "1        1/1/2012 1:00    -1.8  ...     101.24           Fog\n",
              "96       1/5/2012 0:00    -8.8  ...     100.32          Snow\n",
              "101      1/5/2012 5:00    -7.0  ...     100.19          Snow\n",
              "146      1/7/2012 2:00    -8.1  ...     100.15        Cloudy\n",
              "...                ...     ...  ...        ...           ...\n",
              "8768   12/31/2012 8:00    -8.6  ...     101.14  Snow Showers\n",
              "8769   12/31/2012 9:00    -8.1  ...     101.09          Snow\n",
              "8770  12/31/2012 10:00    -7.4  ...     101.05      Snow,Fog\n",
              "8772  12/31/2012 12:00    -5.8  ...     100.78          Snow\n",
              "8773  12/31/2012 13:00    -4.6  ...     100.63          Snow\n",
              "\n",
              "[474 rows x 8 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "YRNATl2Mwgyu"
      },
      "source": [
        "**Find out all the Null Values in the data**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "mrbkhNltwi3O",
        "outputId": "42c05b9c-3312-4b68-e23e-b845bdf8681d"
      },
      "source": [
        "data.isnull().sum()"
      ],
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "execute_result",
          "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"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "jjmQ2bk4w0md"
      },
      "source": [
        "**Rename the column name \"Weater\" of the dataframe to \"Weather Condition\"**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "USNbnqGtw-cX"
      },
      "source": [
        "#data.head(2)\r\n",
        "data.rename(columns = {'Weather' : 'Weather Condition'}, inplace = True) "
      ],
      "execution_count": 12,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 310
        },
        "id": "2tXnKyH0xe6j",
        "outputId": "2b5e799b-7b46-4456-e962-9e5878f55870"
      },
      "source": [
        "data.head()\r\n"
      ],
      "execution_count": 13,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Date/Time</th>\n",
              "      <th>Temp_C</th>\n",
              "      <th>Dew Point Temp_C</th>\n",
              "      <th>Rel Hum_%</th>\n",
              "      <th>Wind Speed_km/h</th>\n",
              "      <th>Visibility_km</th>\n",
              "      <th>Press_kPa</th>\n",
              "      <th>Weather Condition</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1/1/2012 0:00</td>\n",
              "      <td>-1.8</td>\n",
              "      <td>-3.9</td>\n",
              "      <td>86</td>\n",
              "      <td>4</td>\n",
              "      <td>8.0</td>\n",
              "      <td>101.24</td>\n",
              "      <td>Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1/1/2012 1:00</td>\n",
              "      <td>-1.8</td>\n",
              "      <td>-3.7</td>\n",
              "      <td>87</td>\n",
              "      <td>4</td>\n",
              "      <td>8.0</td>\n",
              "      <td>101.24</td>\n",
              "      <td>Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1/1/2012 2:00</td>\n",
              "      <td>-1.8</td>\n",
              "      <td>-3.4</td>\n",
              "      <td>89</td>\n",
              "      <td>7</td>\n",
              "      <td>4.0</td>\n",
              "      <td>101.26</td>\n",
              "      <td>Freezing Drizzle,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1/1/2012 3:00</td>\n",
              "      <td>-1.5</td>\n",
              "      <td>-3.2</td>\n",
              "      <td>88</td>\n",
              "      <td>6</td>\n",
              "      <td>4.0</td>\n",
              "      <td>101.27</td>\n",
              "      <td>Freezing Drizzle,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1/1/2012 4:00</td>\n",
              "      <td>-1.5</td>\n",
              "      <td>-3.3</td>\n",
              "      <td>88</td>\n",
              "      <td>7</td>\n",
              "      <td>4.8</td>\n",
              "      <td>101.23</td>\n",
              "      <td>Fog</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "       Date/Time  Temp_C  ...  Press_kPa     Weather Condition\n",
              "0  1/1/2012 0:00    -1.8  ...     101.24                   Fog\n",
              "1  1/1/2012 1:00    -1.8  ...     101.24                   Fog\n",
              "2  1/1/2012 2:00    -1.8  ...     101.26  Freezing Drizzle,Fog\n",
              "3  1/1/2012 3:00    -1.5  ...     101.27  Freezing Drizzle,Fog\n",
              "4  1/1/2012 4:00    -1.5  ...     101.23                   Fog\n",
              "\n",
              "[5 rows x 8 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "TqktfHhox694"
      },
      "source": [
        "**What is the mean 'Visibility'?**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Ogp915EZx8Xy",
        "outputId": "f438cc9d-679a-4f4f-9e27-ef86a610e128"
      },
      "source": [
        "data.head(2)\r\n",
        "data.Visibility_km.mean()"
      ],
      "execution_count": 15,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "27.66444672131151"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "IALIm49GyNPN"
      },
      "source": [
        "**What is the Standart Deviation of 'Pressure' in this data?**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "dAJ19iVEyV7o",
        "outputId": "a5331227-e44e-4398-d498-f0cee458b711"
      },
      "source": [
        "data.Press_kPa.std()"
      ],
      "execution_count": 16,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0.8440047459486474"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "1jj0QazKykgB"
      },
      "source": [
        "**Whats is the Variance of 'Relative Humidity' in this data?**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "jPbQWp7vyrsb",
        "outputId": "e3ba36d8-0270-4b26-d40a-e743d2428da6"
      },
      "source": [
        "data['Rel Hum_%'].var()"
      ],
      "execution_count": 18,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "286.2485501984998"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 18
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "egiiC_tMzPhe"
      },
      "source": [
        "**Find all instances when 'Snow' was recorded**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "RB1P3CbDz817",
        "outputId": "f59e44fc-3446-403c-ed8b-c8219f6fe071"
      },
      "source": [
        "#value_counts()\r\n",
        "#data.head(2)\r\n",
        "data['Weather Condition'].value_counts()"
      ],
      "execution_count": 20,
      "outputs": [
        {
          "output_type": "execute_result",
          "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",
              "Moderate Snow                                 4\n",
              "Freezing Rain,Fog                             4\n",
              "Snow Showers,Fog                              4\n",
              "Rain,Snow,Ice Pellets                         4\n",
              "Freezing Fog                                  4\n",
              "Freezing Drizzle,Haze                         3\n",
              "Thunderstorms,Rain Showers,Fog                3\n",
              "Thunderstorms,Rain                            3\n",
              "Rain,Haze                                     3\n",
              "Thunderstorms                                 2\n",
              "Rain Showers,Snow Showers                     2\n",
              "Drizzle,Snow                                  2\n",
              "Moderate Snow,Blowing Snow                    2\n",
              "Freezing Rain,Haze                            2\n",
              "Moderate Rain,Fog                             1\n",
              "Snow Pellets                                  1\n",
              "Thunderstorms,Heavy Rain Showers              1\n",
              "Rain,Ice Pellets                              1\n",
              "Rain,Snow,Fog                                 1\n",
              "Drizzle,Ice Pellets,Fog                       1\n",
              "Rain Showers,Fog                              1\n",
              "Rain,Snow Grains                              1\n",
              "Thunderstorms,Moderate Rain Showers,Fog       1\n",
              "Freezing Rain,Snow Grains                     1\n",
              "Freezing Rain,Ice Pellets,Fog                 1\n",
              "Thunderstorms,Rain,Fog                        1\n",
              "Name: Weather Condition, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 20
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 597
        },
        "id": "gCDsgT5y0HsQ",
        "outputId": "418f3ae9-59eb-4266-aeea-e94ef314a07b"
      },
      "source": [
        "#filtering\r\n",
        "data[data['Weather Condition'] == 'Snow']"
      ],
      "execution_count": 21,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Date/Time</th>\n",
              "      <th>Temp_C</th>\n",
              "      <th>Dew Point Temp_C</th>\n",
              "      <th>Rel Hum_%</th>\n",
              "      <th>Wind Speed_km/h</th>\n",
              "      <th>Visibility_km</th>\n",
              "      <th>Press_kPa</th>\n",
              "      <th>Weather Condition</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>55</th>\n",
              "      <td>1/3/2012 7:00</td>\n",
              "      <td>-14.0</td>\n",
              "      <td>-19.5</td>\n",
              "      <td>63</td>\n",
              "      <td>19</td>\n",
              "      <td>25.0</td>\n",
              "      <td>100.95</td>\n",
              "      <td>Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>84</th>\n",
              "      <td>1/4/2012 12:00</td>\n",
              "      <td>-13.7</td>\n",
              "      <td>-21.7</td>\n",
              "      <td>51</td>\n",
              "      <td>11</td>\n",
              "      <td>24.1</td>\n",
              "      <td>101.25</td>\n",
              "      <td>Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>86</th>\n",
              "      <td>1/4/2012 14:00</td>\n",
              "      <td>-11.3</td>\n",
              "      <td>-19.0</td>\n",
              "      <td>53</td>\n",
              "      <td>7</td>\n",
              "      <td>19.3</td>\n",
              "      <td>100.97</td>\n",
              "      <td>Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>87</th>\n",
              "      <td>1/4/2012 15:00</td>\n",
              "      <td>-10.2</td>\n",
              "      <td>-16.3</td>\n",
              "      <td>61</td>\n",
              "      <td>11</td>\n",
              "      <td>9.7</td>\n",
              "      <td>100.89</td>\n",
              "      <td>Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>88</th>\n",
              "      <td>1/4/2012 16:00</td>\n",
              "      <td>-9.4</td>\n",
              "      <td>-15.5</td>\n",
              "      <td>61</td>\n",
              "      <td>13</td>\n",
              "      <td>19.3</td>\n",
              "      <td>100.79</td>\n",
              "      <td>Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8779</th>\n",
              "      <td>12/31/2012 19:00</td>\n",
              "      <td>0.1</td>\n",
              "      <td>-2.7</td>\n",
              "      <td>81</td>\n",
              "      <td>30</td>\n",
              "      <td>9.7</td>\n",
              "      <td>100.13</td>\n",
              "      <td>Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8780</th>\n",
              "      <td>12/31/2012 20:00</td>\n",
              "      <td>0.2</td>\n",
              "      <td>-2.4</td>\n",
              "      <td>83</td>\n",
              "      <td>24</td>\n",
              "      <td>9.7</td>\n",
              "      <td>100.03</td>\n",
              "      <td>Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8781</th>\n",
              "      <td>12/31/2012 21:00</td>\n",
              "      <td>-0.5</td>\n",
              "      <td>-1.5</td>\n",
              "      <td>93</td>\n",
              "      <td>28</td>\n",
              "      <td>4.8</td>\n",
              "      <td>99.95</td>\n",
              "      <td>Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8782</th>\n",
              "      <td>12/31/2012 22:00</td>\n",
              "      <td>-0.2</td>\n",
              "      <td>-1.8</td>\n",
              "      <td>89</td>\n",
              "      <td>28</td>\n",
              "      <td>9.7</td>\n",
              "      <td>99.91</td>\n",
              "      <td>Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8783</th>\n",
              "      <td>12/31/2012 23:00</td>\n",
              "      <td>0.0</td>\n",
              "      <td>-2.1</td>\n",
              "      <td>86</td>\n",
              "      <td>30</td>\n",
              "      <td>11.3</td>\n",
              "      <td>99.89</td>\n",
              "      <td>Snow</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>390 rows × 8 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             Date/Time  Temp_C  ...  Press_kPa  Weather Condition\n",
              "55       1/3/2012 7:00   -14.0  ...     100.95               Snow\n",
              "84      1/4/2012 12:00   -13.7  ...     101.25               Snow\n",
              "86      1/4/2012 14:00   -11.3  ...     100.97               Snow\n",
              "87      1/4/2012 15:00   -10.2  ...     100.89               Snow\n",
              "88      1/4/2012 16:00    -9.4  ...     100.79               Snow\n",
              "...                ...     ...  ...        ...                ...\n",
              "8779  12/31/2012 19:00     0.1  ...     100.13               Snow\n",
              "8780  12/31/2012 20:00     0.2  ...     100.03               Snow\n",
              "8781  12/31/2012 21:00    -0.5  ...      99.95               Snow\n",
              "8782  12/31/2012 22:00    -0.2  ...      99.91               Snow\n",
              "8783  12/31/2012 23:00     0.0  ...      99.89               Snow\n",
              "\n",
              "[390 rows x 8 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 21
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "rzVtX2RK0eH7",
        "outputId": "39784482-8a32-4fb5-fa1d-e955cc6159f4"
      },
      "source": [
        "#str.contains\r\n",
        "data[data['Weather Condition'].str.contains('Snow')].tail(50)"
      ],
      "execution_count": 25,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>8680</th>\n",
              "      <td>12/27/2012 16:00</td>\n",
              "      <td>-4.5</td>\n",
              "      <td>-6.2</td>\n",
              "      <td>88</td>\n",
              "      <td>37</td>\n",
              "      <td>2.0</td>\n",
              "      <td>100.44</td>\n",
              "      <td>Snow,Blowing Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8681</th>\n",
              "      <td>12/27/2012 17:00</td>\n",
              "      <td>-4.2</td>\n",
              "      <td>-5.9</td>\n",
              "      <td>88</td>\n",
              "      <td>32</td>\n",
              "      <td>3.2</td>\n",
              "      <td>100.47</td>\n",
              "      <td>Snow,Blowing Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8682</th>\n",
              "      <td>12/27/2012 18:00</td>\n",
              "      <td>-4.0</td>\n",
              "      <td>-5.7</td>\n",
              "      <td>88</td>\n",
              "      <td>28</td>\n",
              "      <td>8.0</td>\n",
              "      <td>100.49</td>\n",
              "      <td>Snow,Blowing Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8683</th>\n",
              "      <td>12/27/2012 19:00</td>\n",
              "      <td>-3.9</td>\n",
              "      <td>-5.6</td>\n",
              "      <td>88</td>\n",
              "      <td>26</td>\n",
              "      <td>9.7</td>\n",
              "      <td>100.52</td>\n",
              "      <td>Snow,Blowing Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8684</th>\n",
              "      <td>12/27/2012 20:00</td>\n",
              "      <td>-3.7</td>\n",
              "      <td>-5.3</td>\n",
              "      <td>89</td>\n",
              "      <td>37</td>\n",
              "      <td>16.1</td>\n",
              "      <td>100.58</td>\n",
              "      <td>Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8685</th>\n",
              "      <td>12/27/2012 21:00</td>\n",
              "      <td>-3.7</td>\n",
              "      <td>-4.8</td>\n",
              "      <td>92</td>\n",
              "      <td>24</td>\n",
              "      <td>4.8</td>\n",
              "      <td>100.62</td>\n",
              "      <td>Freezing Drizzle,Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8686</th>\n",
              "      <td>12/27/2012 22:00</td>\n",
              "      <td>-3.8</td>\n",
              "      <td>-4.6</td>\n",
              "      <td>94</td>\n",
              "      <td>20</td>\n",
              "      <td>4.8</td>\n",
              "      <td>100.65</td>\n",
              "      <td>Freezing Drizzle,Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8687</th>\n",
              "      <td>12/27/2012 23:00</td>\n",
              "      <td>-4.0</td>\n",
              "      <td>-5.6</td>\n",
              "      <td>89</td>\n",
              "      <td>24</td>\n",
              "      <td>9.7</td>\n",
              "      <td>100.70</td>\n",
              "      <td>Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8688</th>\n",
              "      <td>12/28/2012 0:00</td>\n",
              "      <td>-4.2</td>\n",
              "      <td>-5.7</td>\n",
              "      <td>89</td>\n",
              "      <td>19</td>\n",
              "      <td>8.0</td>\n",
              "      <td>100.78</td>\n",
              "      <td>Freezing Drizzle,Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8689</th>\n",
              "      <td>12/28/2012 1:00</td>\n",
              "      <td>-4.4</td>\n",
              "      <td>-6.6</td>\n",
              "      <td>85</td>\n",
              "      <td>15</td>\n",
              "      <td>6.4</td>\n",
              "      <td>100.83</td>\n",
              "      <td>Freezing Drizzle,Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8690</th>\n",
              "      <td>12/28/2012 2:00</td>\n",
              "      <td>-4.3</td>\n",
              "      <td>-6.3</td>\n",
              "      <td>86</td>\n",
              "      <td>11</td>\n",
              "      <td>12.9</td>\n",
              "      <td>100.93</td>\n",
              "      <td>Freezing Drizzle,Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8691</th>\n",
              "      <td>12/28/2012 3:00</td>\n",
              "      <td>-4.6</td>\n",
              "      <td>-5.9</td>\n",
              "      <td>91</td>\n",
              "      <td>13</td>\n",
              "      <td>4.0</td>\n",
              "      <td>101.01</td>\n",
              "      <td>Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8692</th>\n",
              "      <td>12/28/2012 4:00</td>\n",
              "      <td>-4.9</td>\n",
              "      <td>-5.9</td>\n",
              "      <td>93</td>\n",
              "      <td>9</td>\n",
              "      <td>9.7</td>\n",
              "      <td>101.00</td>\n",
              "      <td>Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8723</th>\n",
              "      <td>12/29/2012 11:00</td>\n",
              "      <td>-10.9</td>\n",
              "      <td>-12.2</td>\n",
              "      <td>90</td>\n",
              "      <td>7</td>\n",
              "      <td>6.4</td>\n",
              "      <td>101.09</td>\n",
              "      <td>Snow Showers,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8724</th>\n",
              "      <td>12/29/2012 12:00</td>\n",
              "      <td>-10.5</td>\n",
              "      <td>-11.6</td>\n",
              "      <td>92</td>\n",
              "      <td>11</td>\n",
              "      <td>8.0</td>\n",
              "      <td>100.93</td>\n",
              "      <td>Snow Showers,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8725</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>100.63</td>\n",
              "      <td>Snow Showers,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8726</th>\n",
              "      <td>12/29/2012 14:00</td>\n",
              "      <td>-9.3</td>\n",
              "      <td>-10.5</td>\n",
              "      <td>91</td>\n",
              "      <td>22</td>\n",
              "      <td>4.8</td>\n",
              "      <td>100.60</td>\n",
              "      <td>Snow,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8727</th>\n",
              "      <td>12/29/2012 15:00</td>\n",
              "      <td>-8.8</td>\n",
              "      <td>-10.0</td>\n",
              "      <td>91</td>\n",
              "      <td>20</td>\n",
              "      <td>1.2</td>\n",
              "      <td>100.55</td>\n",
              "      <td>Snow,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8728</th>\n",
              "      <td>12/29/2012 16:00</td>\n",
              "      <td>-8.5</td>\n",
              "      <td>-9.9</td>\n",
              "      <td>90</td>\n",
              "      <td>24</td>\n",
              "      <td>1.2</td>\n",
              "      <td>100.49</td>\n",
              "      <td>Snow,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8729</th>\n",
              "      <td>12/29/2012 17:00</td>\n",
              "      <td>-9.0</td>\n",
              "      <td>-10.4</td>\n",
              "      <td>90</td>\n",
              "      <td>19</td>\n",
              "      <td>2.4</td>\n",
              "      <td>100.46</td>\n",
              "      <td>Snow,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8730</th>\n",
              "      <td>12/29/2012 18:00</td>\n",
              "      <td>-9.3</td>\n",
              "      <td>-10.9</td>\n",
              "      <td>88</td>\n",
              "      <td>26</td>\n",
              "      <td>6.4</td>\n",
              "      <td>100.38</td>\n",
              "      <td>Snow,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8731</th>\n",
              "      <td>12/29/2012 19:00</td>\n",
              "      <td>-9.5</td>\n",
              "      <td>-11.2</td>\n",
              "      <td>87</td>\n",
              "      <td>26</td>\n",
              "      <td>3.2</td>\n",
              "      <td>100.33</td>\n",
              "      <td>Snow,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8732</th>\n",
              "      <td>12/29/2012 20:00</td>\n",
              "      <td>-9.7</td>\n",
              "      <td>-11.6</td>\n",
              "      <td>86</td>\n",
              "      <td>24</td>\n",
              "      <td>9.7</td>\n",
              "      <td>100.25</td>\n",
              "      <td>Snow,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8733</th>\n",
              "      <td>12/29/2012 21:00</td>\n",
              "      <td>-9.8</td>\n",
              "      <td>-11.8</td>\n",
              "      <td>85</td>\n",
              "      <td>24</td>\n",
              "      <td>8.0</td>\n",
              "      <td>100.24</td>\n",
              "      <td>Snow,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8734</th>\n",
              "      <td>12/29/2012 22:00</td>\n",
              "      <td>-10.1</td>\n",
              "      <td>-11.6</td>\n",
              "      <td>89</td>\n",
              "      <td>15</td>\n",
              "      <td>2.4</td>\n",
              "      <td>100.20</td>\n",
              "      <td>Snow,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8735</th>\n",
              "      <td>12/29/2012 23:00</td>\n",
              "      <td>-10.0</td>\n",
              "      <td>-12.0</td>\n",
              "      <td>85</td>\n",
              "      <td>20</td>\n",
              "      <td>6.4</td>\n",
              "      <td>100.19</td>\n",
              "      <td>Snow,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8736</th>\n",
              "      <td>12/30/2012 0:00</td>\n",
              "      <td>-9.6</td>\n",
              "      <td>-11.3</td>\n",
              "      <td>87</td>\n",
              "      <td>13</td>\n",
              "      <td>3.2</td>\n",
              "      <td>100.23</td>\n",
              "      <td>Snow,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8737</th>\n",
              "      <td>12/30/2012 1:00</td>\n",
              "      <td>-9.4</td>\n",
              "      <td>-10.5</td>\n",
              "      <td>92</td>\n",
              "      <td>9</td>\n",
              "      <td>2.4</td>\n",
              "      <td>100.22</td>\n",
              "      <td>Snow,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8738</th>\n",
              "      <td>12/30/2012 2:00</td>\n",
              "      <td>-9.3</td>\n",
              "      <td>-10.4</td>\n",
              "      <td>92</td>\n",
              "      <td>9</td>\n",
              "      <td>4.0</td>\n",
              "      <td>100.28</td>\n",
              "      <td>Snow,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8739</th>\n",
              "      <td>12/30/2012 3:00</td>\n",
              "      <td>-9.1</td>\n",
              "      <td>-10.4</td>\n",
              "      <td>90</td>\n",
              "      <td>11</td>\n",
              "      <td>3.6</td>\n",
              "      <td>100.30</td>\n",
              "      <td>Snow,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8740</th>\n",
              "      <td>12/30/2012 4:00</td>\n",
              "      <td>-9.3</td>\n",
              "      <td>-10.6</td>\n",
              "      <td>90</td>\n",
              "      <td>13</td>\n",
              "      <td>9.7</td>\n",
              "      <td>100.28</td>\n",
              "      <td>Snow,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8741</th>\n",
              "      <td>12/30/2012 5:00</td>\n",
              "      <td>-9.1</td>\n",
              "      <td>-10.4</td>\n",
              "      <td>90</td>\n",
              "      <td>11</td>\n",
              "      <td>4.0</td>\n",
              "      <td>100.32</td>\n",
              "      <td>Snow,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8742</th>\n",
              "      <td>12/30/2012 6:00</td>\n",
              "      <td>-9.3</td>\n",
              "      <td>-10.8</td>\n",
              "      <td>89</td>\n",
              "      <td>17</td>\n",
              "      <td>8.0</td>\n",
              "      <td>100.39</td>\n",
              "      <td>Snow,Fog</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8767</th>\n",
              "      <td>12/31/2012 7:00</td>\n",
              "      <td>-9.3</td>\n",
              "      <td>-11.3</td>\n",
              "      <td>85</td>\n",
              "      <td>0</td>\n",
              "      <td>19.3</td>\n",
              "      <td>101.19</td>\n",
              "      <td>Snow Showers</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>8771</th>\n",
              "      <td>12/31/2012 11:00</td>\n",
              "      <td>-6.7</td>\n",
              "      <td>-7.9</td>\n",
              "      <td>91</td>\n",
              "      <td>9</td>\n",
              "      <td>9.7</td>\n",
              "      <td>100.93</td>\n",
              "      <td>Snow</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",
              "    <tr>\n",
              "      <th>8774</th>\n",
              "      <td>12/31/2012 14:00</td>\n",
              "      <td>-3.4</td>\n",
              "      <td>-5.7</td>\n",
              "      <td>84</td>\n",
              "      <td>6</td>\n",
              "      <td>11.3</td>\n",
              "      <td>100.57</td>\n",
              "      <td>Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8775</th>\n",
              "      <td>12/31/2012 15:00</td>\n",
              "      <td>-2.3</td>\n",
              "      <td>-4.6</td>\n",
              "      <td>84</td>\n",
              "      <td>9</td>\n",
              "      <td>9.7</td>\n",
              "      <td>100.47</td>\n",
              "      <td>Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8776</th>\n",
              "      <td>12/31/2012 16:00</td>\n",
              "      <td>-1.4</td>\n",
              "      <td>-4.0</td>\n",
              "      <td>82</td>\n",
              "      <td>13</td>\n",
              "      <td>12.9</td>\n",
              "      <td>100.40</td>\n",
              "      <td>Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8777</th>\n",
              "      <td>12/31/2012 17:00</td>\n",
              "      <td>-1.1</td>\n",
              "      <td>-3.3</td>\n",
              "      <td>85</td>\n",
              "      <td>19</td>\n",
              "      <td>9.7</td>\n",
              "      <td>100.30</td>\n",
              "      <td>Snow</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8778</th>\n",
              "      <td>12/31/2012 18:00</td>\n",
              "      <td>-1.3</td>\n",
              "      <td>-3.1</td>\n",
              "      <td>88</td>\n",
              "      <td>17</td>\n",
              "      <td>9.7</td>\n",
              "      <td>100.19</td>\n",
              "      <td>Snow</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",
              "</div>"
            ],
            "text/plain": [
              "             Date/Time  Temp_C  ...  Press_kPa      Weather Condition\n",
              "8680  12/27/2012 16:00    -4.5  ...     100.44      Snow,Blowing Snow\n",
              "8681  12/27/2012 17:00    -4.2  ...     100.47      Snow,Blowing Snow\n",
              "8682  12/27/2012 18:00    -4.0  ...     100.49      Snow,Blowing Snow\n",
              "8683  12/27/2012 19:00    -3.9  ...     100.52      Snow,Blowing Snow\n",
              "8684  12/27/2012 20:00    -3.7  ...     100.58                   Snow\n",
              "8685  12/27/2012 21:00    -3.7  ...     100.62  Freezing Drizzle,Snow\n",
              "8686  12/27/2012 22:00    -3.8  ...     100.65  Freezing Drizzle,Snow\n",
              "8687  12/27/2012 23:00    -4.0  ...     100.70                   Snow\n",
              "8688   12/28/2012 0:00    -4.2  ...     100.78  Freezing Drizzle,Snow\n",
              "8689   12/28/2012 1:00    -4.4  ...     100.83  Freezing Drizzle,Snow\n",
              "8690   12/28/2012 2:00    -4.3  ...     100.93  Freezing Drizzle,Snow\n",
              "8691   12/28/2012 3:00    -4.6  ...     101.01                   Snow\n",
              "8692   12/28/2012 4:00    -4.9  ...     101.00                   Snow\n",
              "8723  12/29/2012 11:00   -10.9  ...     101.09       Snow Showers,Fog\n",
              "8724  12/29/2012 12:00   -10.5  ...     100.93       Snow Showers,Fog\n",
              "8725  12/29/2012 13:00   -10.0  ...     100.63       Snow Showers,Fog\n",
              "8726  12/29/2012 14:00    -9.3  ...     100.60               Snow,Fog\n",
              "8727  12/29/2012 15:00    -8.8  ...     100.55               Snow,Fog\n",
              "8728  12/29/2012 16:00    -8.5  ...     100.49               Snow,Fog\n",
              "8729  12/29/2012 17:00    -9.0  ...     100.46               Snow,Fog\n",
              "8730  12/29/2012 18:00    -9.3  ...     100.38               Snow,Fog\n",
              "8731  12/29/2012 19:00    -9.5  ...     100.33               Snow,Fog\n",
              "8732  12/29/2012 20:00    -9.7  ...     100.25               Snow,Fog\n",
              "8733  12/29/2012 21:00    -9.8  ...     100.24               Snow,Fog\n",
              "8734  12/29/2012 22:00   -10.1  ...     100.20               Snow,Fog\n",
              "8735  12/29/2012 23:00   -10.0  ...     100.19               Snow,Fog\n",
              "8736   12/30/2012 0:00    -9.6  ...     100.23               Snow,Fog\n",
              "8737   12/30/2012 1:00    -9.4  ...     100.22               Snow,Fog\n",
              "8738   12/30/2012 2:00    -9.3  ...     100.28               Snow,Fog\n",
              "8739   12/30/2012 3:00    -9.1  ...     100.30               Snow,Fog\n",
              "8740   12/30/2012 4:00    -9.3  ...     100.28               Snow,Fog\n",
              "8741   12/30/2012 5:00    -9.1  ...     100.32               Snow,Fog\n",
              "8742   12/30/2012 6:00    -9.3  ...     100.39               Snow,Fog\n",
              "8767   12/31/2012 7:00    -9.3  ...     101.19           Snow Showers\n",
              "8768   12/31/2012 8:00    -8.6  ...     101.14           Snow Showers\n",
              "8769   12/31/2012 9:00    -8.1  ...     101.09                   Snow\n",
              "8770  12/31/2012 10:00    -7.4  ...     101.05               Snow,Fog\n",
              "8771  12/31/2012 11:00    -6.7  ...     100.93                   Snow\n",
              "8772  12/31/2012 12:00    -5.8  ...     100.78                   Snow\n",
              "8773  12/31/2012 13:00    -4.6  ...     100.63                   Snow\n",
              "8774  12/31/2012 14:00    -3.4  ...     100.57                   Snow\n",
              "8775  12/31/2012 15:00    -2.3  ...     100.47                   Snow\n",
              "8776  12/31/2012 16:00    -1.4  ...     100.40                   Snow\n",
              "8777  12/31/2012 17:00    -1.1  ...     100.30                   Snow\n",
              "8778  12/31/2012 18:00    -1.3  ...     100.19                   Snow\n",
              "8779  12/31/2012 19:00     0.1  ...     100.13                   Snow\n",
              "8780  12/31/2012 20:00     0.2  ...     100.03                   Snow\n",
              "8781  12/31/2012 21:00    -0.5  ...      99.95                   Snow\n",
              "8782  12/31/2012 22:00    -0.2  ...      99.91                   Snow\n",
              "8783  12/31/2012 23:00     0.0  ...      99.89                   Snow\n",
              "\n",
              "[50 rows x 8 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 25
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "tmv5TPLG1Gs_"
      },
      "source": [
        "**Find all instances when 'Wind Speed is above 24' and 'Visibility is 25'**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "4YFbYe8f1YUr"
      },
      "source": [
        "data.head(2)\r\n"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 545
        },
        "id": "dzpa7Mxg2Ddb",
        "outputId": "3026a0e9-7c63-487a-9611-d7917ba54e12"
      },
      "source": [
        "data[(data['Wind Speed_km/h'] > 24) & (data['Visibility_km'] == 25)]"
      ],
      "execution_count": 29,
      "outputs": [
        {
          "output_type": "execute_result",
          "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  ...  Press_kPa  Weather Condition\n",
              "23      1/1/2012 23:00     5.3  ...      99.31             Cloudy\n",
              "24       1/2/2012 0:00     5.2  ...      99.26       Rain Showers\n",
              "25       1/2/2012 1:00     4.6  ...      99.26             Cloudy\n",
              "26       1/2/2012 2:00     3.9  ...      99.26      Mostly Cloudy\n",
              "27       1/2/2012 3:00     3.7  ...      99.30      Mostly Cloudy\n",
              "...                ...     ...  ...        ...                ...\n",
              "8705  12/28/2012 17:00    -8.6  ...     101.34       Mainly Clear\n",
              "8753  12/30/2012 17:00   -12.1  ...     101.26       Mainly Clear\n",
              "8755  12/30/2012 19:00   -13.4  ...     101.47       Mainly Clear\n",
              "8759  12/30/2012 23:00   -12.1  ...     101.52      Mostly Cloudy\n",
              "8760   12/31/2012 0:00   -11.1  ...     101.51             Cloudy\n",
              "\n",
              "[308 rows x 8 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 29
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "5nxjDak23L6p"
      },
      "source": [
        "**What is the Mean value of each column against each 'Weather Condition'?**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "GW5tOMtw4NHb",
        "outputId": "a84da597-a7fd-4229-b2ae-56774278ac29"
      },
      "source": [
        "data.head(2)\r\n",
        "data.groupby('Weather Condition').mean()"
      ],
      "execution_count": 31,
      "outputs": [
        {
          "output_type": "execute_result",
          "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  ...   Press_kPa\n",
              "Weather Condition                                   ...            \n",
              "Clear                                     6.825716  ...  101.587443\n",
              "Cloudy                                    7.970544  ...  100.911441\n",
              "Drizzle                                   7.353659  ...  100.435366\n",
              "Drizzle,Fog                               8.067500  ...  100.786625\n",
              "Drizzle,Ice Pellets,Fog                   0.400000  ...  100.790000\n",
              "Drizzle,Snow                              1.050000  ...  100.890000\n",
              "Drizzle,Snow,Fog                          0.693333  ...   99.281333\n",
              "Fog                                       4.303333  ...  101.184067\n",
              "Freezing Drizzle                         -5.657143  ...  100.202857\n",
              "Freezing Drizzle,Fog                     -2.533333  ...  100.441667\n",
              "Freezing Drizzle,Haze                    -5.433333  ...  100.316667\n",
              "Freezing Drizzle,Snow                    -5.109091  ...  100.520909\n",
              "Freezing Fog                             -7.575000  ...  102.320000\n",
              "Freezing Rain                            -3.885714  ...   99.647143\n",
              "Freezing Rain,Fog                        -2.225000  ...   99.945000\n",
              "Freezing Rain,Haze                       -4.900000  ...  100.375000\n",
              "Freezing Rain,Ice Pellets,Fog            -2.600000  ...  100.950000\n",
              "Freezing Rain,Snow Grains                -5.000000  ...   98.560000\n",
              "Haze                                     -0.200000  ...  101.482500\n",
              "Mainly Clear                             12.558927  ...  101.248832\n",
              "Moderate Rain,Fog                         1.700000  ...   99.980000\n",
              "Moderate Snow                            -5.525000  ...  100.275000\n",
              "Moderate Snow,Blowing Snow               -5.450000  ...  100.570000\n",
              "Mostly Cloudy                            10.574287  ...  101.025288\n",
              "Rain                                      9.786275  ...  100.233333\n",
              "Rain Showers                             13.722340  ...  100.404043\n",
              "Rain Showers,Fog                         12.800000  ...   99.830000\n",
              "Rain Showers,Snow Showers                 2.150000  ...  101.100000\n",
              "Rain,Fog                                  8.273276  ...  100.500862\n",
              "Rain,Haze                                 4.633333  ...  100.540000\n",
              "Rain,Ice Pellets                          0.600000  ...  100.120000\n",
              "Rain,Snow                                 1.055556  ...   99.951111\n",
              "Rain,Snow Grains                          1.900000  ...  100.600000\n",
              "Rain,Snow,Fog                             0.800000  ...  100.730000\n",
              "Rain,Snow,Ice Pellets                     1.100000  ...  100.105000\n",
              "Snow                                     -4.524103  ...  100.536103\n",
              "Snow Pellets                              0.700000  ...   99.700000\n",
              "Snow Showers                             -3.506667  ...  100.963500\n",
              "Snow Showers,Fog                        -10.675000  ...  101.292500\n",
              "Snow,Blowing Snow                        -5.410526  ...   99.704737\n",
              "Snow,Fog                                 -5.075676  ...  100.688649\n",
              "Snow,Haze                                -4.020000  ...  100.782000\n",
              "Snow,Ice Pellets                         -1.883333  ...  100.548333\n",
              "Thunderstorms                            24.150000  ...  100.230000\n",
              "Thunderstorms,Heavy Rain Showers         10.900000  ...  100.260000\n",
              "Thunderstorms,Moderate Rain Showers,Fog  19.600000  ...  100.010000\n",
              "Thunderstorms,Rain                       20.433333  ...  100.420000\n",
              "Thunderstorms,Rain Showers               20.037500  ...  100.233750\n",
              "Thunderstorms,Rain Showers,Fog           21.600000  ...  100.063333\n",
              "Thunderstorms,Rain,Fog                   20.600000  ...  100.080000\n",
              "\n",
              "[50 rows x 6 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 31
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "OYNF5TZ94z2Q"
      },
      "source": [
        "**What is the Minimum & Maximum value of each column against each 'Weather Condition'**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "1hZk-wdH5Aim"
      },
      "source": [
        "data.groupby('Weather Condition').max()"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "afDV58eK7TT_"
      },
      "source": [
        "data.groupby('Weather Condition').min()"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "ffyW_NCk7V10"
      },
      "source": [
        "**Show all the Records where Weather Condition is Fog**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 528
        },
        "id": "tW2duNoA7m9l",
        "outputId": "f204647e-2ddc-42c6-ca9d-27e62ca3f7b2"
      },
      "source": [
        "data[data['Weather Condition'] == 'Fog']"
      ],
      "execution_count": 34,
      "outputs": [
        {
          "output_type": "execute_result",
          "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  ...  Press_kPa  Weather Condition\n",
              "0        1/1/2012 0:00    -1.8  ...     101.24                Fog\n",
              "1        1/1/2012 1:00    -1.8  ...     101.24                Fog\n",
              "4        1/1/2012 4:00    -1.5  ...     101.23                Fog\n",
              "5        1/1/2012 5:00    -1.4  ...     101.27                Fog\n",
              "6        1/1/2012 6:00    -1.5  ...     101.29                Fog\n",
              "...                ...     ...  ...        ...                ...\n",
              "8716   12/29/2012 4:00   -16.0  ...     101.25                Fog\n",
              "8717   12/29/2012 5:00   -14.8  ...     101.25                Fog\n",
              "8718   12/29/2012 6:00   -13.8  ...     101.25                Fog\n",
              "8719   12/29/2012 7:00   -14.8  ...     101.22                Fog\n",
              "8722  12/29/2012 10:00   -12.0  ...     101.15                Fog\n",
              "\n",
              "[150 rows x 8 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 34
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "N3XJYndY79fR"
      },
      "source": [
        "**Find all instances when 'Weather is Clear' or 'Visibility is above 40'**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 597
        },
        "id": "0_BVYkl38Frp",
        "outputId": "ef2e290d-9b86-435b-995b-631176dc5c72"
      },
      "source": [
        "data[(data['Weather Condition'] == 'Clear') |(data['Visibility_km'] > 40)]"
      ],
      "execution_count": 37,
      "outputs": [
        {
          "output_type": "execute_result",
          "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  ...  Press_kPa  Weather Condition\n",
              "67      1/3/2012 19:00   -16.9  ...     101.74              Clear\n",
              "106     1/5/2012 10:00    -6.0  ...     100.45       Mainly Clear\n",
              "107     1/5/2012 11:00    -5.6  ...     100.41       Mainly Clear\n",
              "108     1/5/2012 12:00    -4.7  ...     100.38       Mainly Clear\n",
              "109     1/5/2012 13:00    -4.4  ...     100.40       Mainly Clear\n",
              "...                ...     ...  ...        ...                ...\n",
              "8749  12/30/2012 13:00   -12.4  ...     100.92      Mostly Cloudy\n",
              "8750  12/30/2012 14:00   -11.8  ...     100.96       Mainly Clear\n",
              "8751  12/30/2012 15:00   -11.3  ...     101.05       Mainly Clear\n",
              "8752  12/30/2012 16:00   -11.4  ...     101.15       Mainly Clear\n",
              "8756  12/30/2012 20:00   -13.8  ...     101.52              Clear\n",
              "\n",
              "[3027 rows x 8 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 37
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "twGrkkep8z01"
      },
      "source": [
        "**Find all instances when :**"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "-6Ga8kzF9n9I"
      },
      "source": [
        "Find all instances when:\r\n",
        "A. 'Weather is Clear' and 'Relative Humidity' is greater than 50'\r\n",
        "or\r\n",
        "B. 'Visibility is above 40'"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 597
        },
        "id": "2GVu9-AK984N",
        "outputId": "4c801f38-9dc0-4449-b429-995553919062"
      },
      "source": [
        "data.head(2)\r\n",
        "data[(data['Weather Condition'] == 'Clear') & (data['Rel Hum_%'] > 50) | (data['Visibility_km'] > 40)]"
      ],
      "execution_count": 39,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Date/Time</th>\n",
              "      <th>Temp_C</th>\n",
              "      <th>Dew Point Temp_C</th>\n",
              "      <th>Rel Hum_%</th>\n",
              "      <th>Wind Speed_km/h</th>\n",
              "      <th>Visibility_km</th>\n",
              "      <th>Press_kPa</th>\n",
              "      <th>Weather Condition</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>106</th>\n",
              "      <td>1/5/2012 10:00</td>\n",
              "      <td>-6.0</td>\n",
              "      <td>-10.0</td>\n",
              "      <td>73</td>\n",
              "      <td>17</td>\n",
              "      <td>48.3</td>\n",
              "      <td>100.45</td>\n",
              "      <td>Mainly Clear</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>107</th>\n",
              "      <td>1/5/2012 11:00</td>\n",
              "      <td>-5.6</td>\n",
              "      <td>-10.2</td>\n",
              "      <td>70</td>\n",
              "      <td>22</td>\n",
              "      <td>48.3</td>\n",
              "      <td>100.41</td>\n",
              "      <td>Mainly Clear</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>108</th>\n",
              "      <td>1/5/2012 12:00</td>\n",
              "      <td>-4.7</td>\n",
              "      <td>-9.6</td>\n",
              "      <td>69</td>\n",
              "      <td>20</td>\n",
              "      <td>48.3</td>\n",
              "      <td>100.38</td>\n",
              "      <td>Mainly Clear</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>109</th>\n",
              "      <td>1/5/2012 13:00</td>\n",
              "      <td>-4.4</td>\n",
              "      <td>-9.7</td>\n",
              "      <td>66</td>\n",
              "      <td>26</td>\n",
              "      <td>48.3</td>\n",
              "      <td>100.40</td>\n",
              "      <td>Mainly Clear</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>110</th>\n",
              "      <td>1/5/2012 14:00</td>\n",
              "      <td>-5.1</td>\n",
              "      <td>-10.7</td>\n",
              "      <td>65</td>\n",
              "      <td>22</td>\n",
              "      <td>48.3</td>\n",
              "      <td>100.46</td>\n",
              "      <td>Mainly Clear</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8749</th>\n",
              "      <td>12/30/2012 13:00</td>\n",
              "      <td>-12.4</td>\n",
              "      <td>-16.2</td>\n",
              "      <td>73</td>\n",
              "      <td>37</td>\n",
              "      <td>48.3</td>\n",
              "      <td>100.92</td>\n",
              "      <td>Mostly Cloudy</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8750</th>\n",
              "      <td>12/30/2012 14:00</td>\n",
              "      <td>-11.8</td>\n",
              "      <td>-16.1</td>\n",
              "      <td>70</td>\n",
              "      <td>37</td>\n",
              "      <td>48.3</td>\n",
              "      <td>100.96</td>\n",
              "      <td>Mainly Clear</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8751</th>\n",
              "      <td>12/30/2012 15:00</td>\n",
              "      <td>-11.3</td>\n",
              "      <td>-15.6</td>\n",
              "      <td>70</td>\n",
              "      <td>32</td>\n",
              "      <td>48.3</td>\n",
              "      <td>101.05</td>\n",
              "      <td>Mainly Clear</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8752</th>\n",
              "      <td>12/30/2012 16:00</td>\n",
              "      <td>-11.4</td>\n",
              "      <td>-15.5</td>\n",
              "      <td>72</td>\n",
              "      <td>26</td>\n",
              "      <td>48.3</td>\n",
              "      <td>101.15</td>\n",
              "      <td>Mainly Clear</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8756</th>\n",
              "      <td>12/30/2012 20:00</td>\n",
              "      <td>-13.8</td>\n",
              "      <td>-16.5</td>\n",
              "      <td>80</td>\n",
              "      <td>24</td>\n",
              "      <td>25.0</td>\n",
              "      <td>101.52</td>\n",
              "      <td>Clear</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>2921 rows × 8 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             Date/Time  Temp_C  ...  Press_kPa  Weather Condition\n",
              "106     1/5/2012 10:00    -6.0  ...     100.45       Mainly Clear\n",
              "107     1/5/2012 11:00    -5.6  ...     100.41       Mainly Clear\n",
              "108     1/5/2012 12:00    -4.7  ...     100.38       Mainly Clear\n",
              "109     1/5/2012 13:00    -4.4  ...     100.40       Mainly Clear\n",
              "110     1/5/2012 14:00    -5.1  ...     100.46       Mainly Clear\n",
              "...                ...     ...  ...        ...                ...\n",
              "8749  12/30/2012 13:00   -12.4  ...     100.92      Mostly Cloudy\n",
              "8750  12/30/2012 14:00   -11.8  ...     100.96       Mainly Clear\n",
              "8751  12/30/2012 15:00   -11.3  ...     101.05       Mainly Clear\n",
              "8752  12/30/2012 16:00   -11.4  ...     101.15       Mainly Clear\n",
              "8756  12/30/2012 20:00   -13.8  ...     101.52              Clear\n",
              "\n",
              "[2921 rows x 8 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 39
        }
      ]
    }
  ]
}