WeatherForecastingAnjaliGondse.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "9d95ee8f",
   "metadata": {},
   "source": [
    "# <center> **Weather Report Forecasting Analysis** </center>\n",
    "## <center> **Module 1: Pre-processing, Analysing Data using Python** </center>\n"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "id": "8c3729c2",
   "metadata": {},
   "source": [
    "***\n",
    "## Introduction :\n",
    "\n",
    "Weather prediction helps to determine future climate changes. It has a great impact on various aspects of human life. Weather forecasting is done by collecting data on the current state of the atmosphere and applying a scientific understanding of atmospheric processes to predict and analyse atmospheric progression. In the project, we have been provided with day wise weather data from Jan 2022 to July 2033 which is a predicted\n",
    "data. \n",
    "\n",
    "![download.gif](https://cdn.dribbble.com/users/1046127/screenshots/3987643/media/f8536f8486d6a831bc8ceff562e6e6e6.gif)\n",
    "\n",
    "\n",
    "### Objectives of Module 1 :\n",
    "\n",
    "• Handling null values, deletion or transformation of irrelevant values.\n",
    "\n",
    "• Datatype transformation, formatting, removing duplicates.\n",
    "\n",
    "• To Correct the years for given data set\n",
    "\n",
    "• Encoding data into suitable format i.e. UTF8\n",
    "\n",
    "• To get a cleaned dataset csv file\n",
    "\n",
    "\n",
    "### Variables present in the dataset :\n",
    "\n",
    "Columns i.e. attributes present in the dataset are as follows :\n",
    "\n",
    "\n",
    "• Date- Date for which predicted data is given\n",
    "\n",
    "• Average temperature (°F) - Avg. temperature at the given day in °F\n",
    "\n",
    "• Average humidity (%) - Avg. humidity at the given day in %\n",
    "\n",
    "• Average dewpoint (°F) - Avg. dewpoint at the given day in °F\n",
    "\n",
    "• Average barometer (in) - Avg. barometer reading at the given day. Barometers predict the weather by detecting changes in the air pressure\n",
    "\n",
    "• Average windspeed (mph) - Avg. windspeed at the given day\n",
    "\n",
    "• Average gust speed (mph) -  Avg. gust speed at the given date It is a sudden, brief increase in speed of the wind, usually less than 20 seconds\n",
    "\n",
    "• Average direction (°degree) - Avg. direction of the wind in degree\n",
    "\n",
    "• Rainfall for month (in) - Rainfall predicted for  the month\n",
    "\n",
    "• Rainfall for year (in) - Rainfall predicted for the year\n",
    "\n",
    "• Maximum rain per minute - Max. rain per minute\n",
    "\n",
    "• Maximum temperature (°F) - Max. temperature predicted for the given day\n",
    "\n",
    "• Minimum temperature (°F) -Min. temperature predicted for the given day\n",
    "\n",
    "• Maximum humidity (%) - Max. humidity predicted for the given day\n",
    "\n",
    "• Minimum humidity (%) - Min. humidity predicted for the given day\n",
    "\n",
    "• Maximum pressure - Max. pressure predicted for the given day\n",
    "\n",
    "• Minimum pressure - Min. pressure predicted for the given day\n",
    "\n",
    "• Maximum wind speed (mph) - Max. wind speed predicted in mph\n",
    "\n",
    "• Maximum gust speed (mph) - Max. gust speed predicted in mph\n",
    "\n",
    "• Maximum heat index (°F) - Max. heat index\n",
    "\n",
    "• Diff pressure - Diff presupressure predicted\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7821847e",
   "metadata": {},
   "source": [
    "### Importing necessary libraries :\n",
    "\n",
    "We will import the required libraries such as pandas, numpy. Pandas will help in data analysis and manipulation, while numpy works with the arrays use for scientific computing. It provides a high-performance multidimensional array object, and tools."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "46fbd81f",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np                              #importing numpy as np\n",
    "import pandas as pd                             #importing pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "16a06dd6",
   "metadata": {},
   "source": [
    "### To read csv dataset :\n",
    "\n",
    "We will import our data into the jupyter noterbook and use pandas to read csv file and to store it in a dataframe in order to clean and analyse as follows:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "9e3bc05f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Temperature</th>\n",
       "      <th>Average humidity (%</th>\n",
       "      <th>Average dewpoint (°F</th>\n",
       "      <th>Average barometer (in</th>\n",
       "      <th>Average windspeed (mph</th>\n",
       "      <th>Average gustspeed (mph</th>\n",
       "      <th>Average direction (°deg</th>\n",
       "      <th>Rainfall for month (in</th>\n",
       "      <th>Rainfall for year (in</th>\n",
       "      <th>Maximum rain per minute</th>\n",
       "      <th>Maximum temperature (°F</th>\n",
       "      <th>Minimum temperature (°F</th>\n",
       "      <th>Maximum humidity (%</th>\n",
       "      <th>Minimum humidity (%</th>\n",
       "      <th>Maximum pressure</th>\n",
       "      <th>Minimum pressure</th>\n",
       "      <th>Maximum windspeed (mph</th>\n",
       "      <th>Maximum gust speed (mph</th>\n",
       "      <th>Maximum heat index (°F</th>\n",
       "      <th>Date1</th>\n",
       "      <th>Month</th>\n",
       "      <th>diff_pressure</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>'37.8'</td>\n",
       "      <td>'35.0'</td>\n",
       "      <td>'12.7'</td>\n",
       "      <td>'29.7'</td>\n",
       "      <td>'26.4'</td>\n",
       "      <td>'36.8'</td>\n",
       "      <td>'274.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'40.0'</td>\n",
       "      <td>'34.0'</td>\n",
       "      <td>'4.0'</td>\n",
       "      <td>'27.0'</td>\n",
       "      <td>'29.762'</td>\n",
       "      <td>'29.596'</td>\n",
       "      <td>'41.4'</td>\n",
       "      <td>'59.0'</td>\n",
       "      <td>'40.0'</td>\n",
       "      <td>'2022-01-01'</td>\n",
       "      <td>'01'</td>\n",
       "      <td>'0.16600000000000037'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-01-02'</td>\n",
       "      <td>'43.2'</td>\n",
       "      <td>'32.0'</td>\n",
       "      <td>'14.7'</td>\n",
       "      <td>'29.5'</td>\n",
       "      <td>'12.8'</td>\n",
       "      <td>'18.0'</td>\n",
       "      <td>'240.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'52.0'</td>\n",
       "      <td>'37.0'</td>\n",
       "      <td>'4.0'</td>\n",
       "      <td>'16.0'</td>\n",
       "      <td>'29.669'</td>\n",
       "      <td>'29.268'</td>\n",
       "      <td>'35.7'</td>\n",
       "      <td>'51.0'</td>\n",
       "      <td>'52.0'</td>\n",
       "      <td>'2022-01-02'</td>\n",
       "      <td>'01'</td>\n",
       "      <td>'0.4009999999999998'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-01-03'</td>\n",
       "      <td>'25.7'</td>\n",
       "      <td>'60.0'</td>\n",
       "      <td>'12.7'</td>\n",
       "      <td>'29.7'</td>\n",
       "      <td>'8.3'</td>\n",
       "      <td>'12.2'</td>\n",
       "      <td>'290.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'41.0'</td>\n",
       "      <td>'6.0'</td>\n",
       "      <td>'8.0'</td>\n",
       "      <td>'35.0'</td>\n",
       "      <td>'30.232'</td>\n",
       "      <td>'29.26'</td>\n",
       "      <td>'25.3'</td>\n",
       "      <td>'38.0'</td>\n",
       "      <td>'41.0'</td>\n",
       "      <td>'2022-01-03'</td>\n",
       "      <td>'01'</td>\n",
       "      <td>'0.9719999999999978'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-01-04'</td>\n",
       "      <td>'9.3'</td>\n",
       "      <td>'67.0'</td>\n",
       "      <td>'0.1'</td>\n",
       "      <td>'30.4'</td>\n",
       "      <td>'2.9'</td>\n",
       "      <td>'4.5'</td>\n",
       "      <td>'47.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'19.0'</td>\n",
       "      <td>'-0.0'</td>\n",
       "      <td>'7.0'</td>\n",
       "      <td>'35.0'</td>\n",
       "      <td>'30.566'</td>\n",
       "      <td>'30.227'</td>\n",
       "      <td>'12.7'</td>\n",
       "      <td>'20.0'</td>\n",
       "      <td>'32.0'</td>\n",
       "      <td>'2022-01-04'</td>\n",
       "      <td>'01'</td>\n",
       "      <td>'0.33899999999999864'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-01-05'</td>\n",
       "      <td>'23.5'</td>\n",
       "      <td>'30.0'</td>\n",
       "      <td>'-5.3'</td>\n",
       "      <td>'29.9'</td>\n",
       "      <td>'16.7'</td>\n",
       "      <td>'23.1'</td>\n",
       "      <td>'265.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'30.0'</td>\n",
       "      <td>'15.0'</td>\n",
       "      <td>'5.0'</td>\n",
       "      <td>'13.0'</td>\n",
       "      <td>'30.233'</td>\n",
       "      <td>'29.568'</td>\n",
       "      <td>'38.0'</td>\n",
       "      <td>'53.0'</td>\n",
       "      <td>'32.0'</td>\n",
       "      <td>'2022-01-05'</td>\n",
       "      <td>'01'</td>\n",
       "      <td>'0.6649999999999991'</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Date  Temperature  Average humidity (%  Average dewpoint (°F  \\\n",
       "0   2022-01-01       '37.8'               '35.0'                '12.7'   \n",
       "1  2022-01-02'       '43.2'               '32.0'                '14.7'   \n",
       "2  2022-01-03'       '25.7'               '60.0'                '12.7'   \n",
       "3  2022-01-04'        '9.3'               '67.0'                 '0.1'   \n",
       "4  2022-01-05'       '23.5'               '30.0'                '-5.3'   \n",
       "\n",
       "   Average barometer (in  Average windspeed (mph  Average gustspeed (mph  \\\n",
       "0                 '29.7'                  '26.4'                  '36.8'   \n",
       "1                 '29.5'                  '12.8'                  '18.0'   \n",
       "2                 '29.7'                   '8.3'                  '12.2'   \n",
       "3                 '30.4'                   '2.9'                   '4.5'   \n",
       "4                 '29.9'                  '16.7'                  '23.1'   \n",
       "\n",
       "   Average direction (°deg  Rainfall for month (in Rainfall for year (in  \\\n",
       "0                  '274.0'                   '0.0'                 '0.0'   \n",
       "1                  '240.0'                   '0.0'                 '0.0'   \n",
       "2                  '290.0'                   '0.0'                 '0.0'   \n",
       "3                   '47.0'                   '0.0'                 '0.0'   \n",
       "4                  '265.0'                   '0.0'                 '0.0'   \n",
       "\n",
       "   Maximum rain per minute  Maximum temperature (°F  Minimum temperature (°F  \\\n",
       "0                    '0.0'                   '40.0'                   '34.0'   \n",
       "1                    '0.0'                   '52.0'                   '37.0'   \n",
       "2                    '0.0'                   '41.0'                    '6.0'   \n",
       "3                    '0.0'                   '19.0'                   '-0.0'   \n",
       "4                    '0.0'                   '30.0'                   '15.0'   \n",
       "\n",
       "   Maximum humidity (%  Minimum humidity (%  Maximum pressure  \\\n",
       "0                '4.0'               '27.0'          '29.762'   \n",
       "1                '4.0'               '16.0'          '29.669'   \n",
       "2                '8.0'               '35.0'          '30.232'   \n",
       "3                '7.0'               '35.0'          '30.566'   \n",
       "4                '5.0'               '13.0'          '30.233'   \n",
       "\n",
       "   Minimum pressure  Maximum windspeed (mph  Maximum gust speed (mph  \\\n",
       "0          '29.596'                  '41.4'                   '59.0'   \n",
       "1          '29.268'                  '35.7'                   '51.0'   \n",
       "2           '29.26'                  '25.3'                   '38.0'   \n",
       "3          '30.227'                  '12.7'                   '20.0'   \n",
       "4          '29.568'                  '38.0'                   '53.0'   \n",
       "\n",
       "   Maximum heat index (°F         Date1  Month          diff_pressure  \n",
       "0                  '40.0'  '2022-01-01'   '01'  '0.16600000000000037'  \n",
       "1                  '52.0'  '2022-01-02'   '01'   '0.4009999999999998'  \n",
       "2                  '41.0'  '2022-01-03'   '01'   '0.9719999999999978'  \n",
       "3                  '32.0'  '2022-01-04'   '01'  '0.33899999999999864'  \n",
       "4                  '32.0'  '2022-01-05'   '01'   '0.6649999999999991'  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_excel ('weather_dataset_stage1.xls', skiprows=28)   #to read the csv file\n",
    "pd.pandas.set_option('display.max_columns', None)                #to print the all columns\n",
    "df.head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "084309d1",
   "metadata": {},
   "source": [
    "### Basic Exploration of the dataset :\n",
    "We will perform basic exploration of the dataset to understand data given."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "df16e555",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(3903, 23)"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#To know the size of database using shape function\n",
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "07b61eef",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Temperature</th>\n",
       "      <th>Average humidity (%</th>\n",
       "      <th>Average dewpoint (°F</th>\n",
       "      <th>Average barometer (in</th>\n",
       "      <th>Average windspeed (mph</th>\n",
       "      <th>Average gustspeed (mph</th>\n",
       "      <th>Average direction (°deg</th>\n",
       "      <th>Rainfall for month (in</th>\n",
       "      <th>Rainfall for year (in</th>\n",
       "      <th>Maximum rain per minute</th>\n",
       "      <th>Maximum temperature (°F</th>\n",
       "      <th>Minimum temperature (°F</th>\n",
       "      <th>Maximum humidity (%</th>\n",
       "      <th>Minimum humidity (%</th>\n",
       "      <th>Maximum pressure</th>\n",
       "      <th>Minimum pressure</th>\n",
       "      <th>Maximum windspeed (mph</th>\n",
       "      <th>Maximum gust speed (mph</th>\n",
       "      <th>Maximum heat index (°F</th>\n",
       "      <th>Date1</th>\n",
       "      <th>Month</th>\n",
       "      <th>diff_pressure</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>'37.8'</td>\n",
       "      <td>'35.0'</td>\n",
       "      <td>'12.7'</td>\n",
       "      <td>'29.7'</td>\n",
       "      <td>'26.4'</td>\n",
       "      <td>'36.8'</td>\n",
       "      <td>'274.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'40.0'</td>\n",
       "      <td>'34.0'</td>\n",
       "      <td>'4.0'</td>\n",
       "      <td>'27.0'</td>\n",
       "      <td>'29.762'</td>\n",
       "      <td>'29.596'</td>\n",
       "      <td>'41.4'</td>\n",
       "      <td>'59.0'</td>\n",
       "      <td>'40.0'</td>\n",
       "      <td>'2022-01-01'</td>\n",
       "      <td>'01'</td>\n",
       "      <td>'0.16600000000000037'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-01-02'</td>\n",
       "      <td>'43.2'</td>\n",
       "      <td>'32.0'</td>\n",
       "      <td>'14.7'</td>\n",
       "      <td>'29.5'</td>\n",
       "      <td>'12.8'</td>\n",
       "      <td>'18.0'</td>\n",
       "      <td>'240.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'52.0'</td>\n",
       "      <td>'37.0'</td>\n",
       "      <td>'4.0'</td>\n",
       "      <td>'16.0'</td>\n",
       "      <td>'29.669'</td>\n",
       "      <td>'29.268'</td>\n",
       "      <td>'35.7'</td>\n",
       "      <td>'51.0'</td>\n",
       "      <td>'52.0'</td>\n",
       "      <td>'2022-01-02'</td>\n",
       "      <td>'01'</td>\n",
       "      <td>'0.4009999999999998'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-01-03'</td>\n",
       "      <td>'25.7'</td>\n",
       "      <td>'60.0'</td>\n",
       "      <td>'12.7'</td>\n",
       "      <td>'29.7'</td>\n",
       "      <td>'8.3'</td>\n",
       "      <td>'12.2'</td>\n",
       "      <td>'290.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'41.0'</td>\n",
       "      <td>'6.0'</td>\n",
       "      <td>'8.0'</td>\n",
       "      <td>'35.0'</td>\n",
       "      <td>'30.232'</td>\n",
       "      <td>'29.26'</td>\n",
       "      <td>'25.3'</td>\n",
       "      <td>'38.0'</td>\n",
       "      <td>'41.0'</td>\n",
       "      <td>'2022-01-03'</td>\n",
       "      <td>'01'</td>\n",
       "      <td>'0.9719999999999978'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-01-04'</td>\n",
       "      <td>'9.3'</td>\n",
       "      <td>'67.0'</td>\n",
       "      <td>'0.1'</td>\n",
       "      <td>'30.4'</td>\n",
       "      <td>'2.9'</td>\n",
       "      <td>'4.5'</td>\n",
       "      <td>'47.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'19.0'</td>\n",
       "      <td>'-0.0'</td>\n",
       "      <td>'7.0'</td>\n",
       "      <td>'35.0'</td>\n",
       "      <td>'30.566'</td>\n",
       "      <td>'30.227'</td>\n",
       "      <td>'12.7'</td>\n",
       "      <td>'20.0'</td>\n",
       "      <td>'32.0'</td>\n",
       "      <td>'2022-01-04'</td>\n",
       "      <td>'01'</td>\n",
       "      <td>'0.33899999999999864'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-01-05'</td>\n",
       "      <td>'23.5'</td>\n",
       "      <td>'30.0'</td>\n",
       "      <td>'-5.3'</td>\n",
       "      <td>'29.9'</td>\n",
       "      <td>'16.7'</td>\n",
       "      <td>'23.1'</td>\n",
       "      <td>'265.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'30.0'</td>\n",
       "      <td>'15.0'</td>\n",
       "      <td>'5.0'</td>\n",
       "      <td>'13.0'</td>\n",
       "      <td>'30.233'</td>\n",
       "      <td>'29.568'</td>\n",
       "      <td>'38.0'</td>\n",
       "      <td>'53.0'</td>\n",
       "      <td>'32.0'</td>\n",
       "      <td>'2022-01-05'</td>\n",
       "      <td>'01'</td>\n",
       "      <td>'0.6649999999999991'</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Date  Temperature  Average humidity (%  Average dewpoint (°F  \\\n",
       "0   2022-01-01       '37.8'               '35.0'                '12.7'   \n",
       "1  2022-01-02'       '43.2'               '32.0'                '14.7'   \n",
       "2  2022-01-03'       '25.7'               '60.0'                '12.7'   \n",
       "3  2022-01-04'        '9.3'               '67.0'                 '0.1'   \n",
       "4  2022-01-05'       '23.5'               '30.0'                '-5.3'   \n",
       "\n",
       "   Average barometer (in  Average windspeed (mph  Average gustspeed (mph  \\\n",
       "0                 '29.7'                  '26.4'                  '36.8'   \n",
       "1                 '29.5'                  '12.8'                  '18.0'   \n",
       "2                 '29.7'                   '8.3'                  '12.2'   \n",
       "3                 '30.4'                   '2.9'                   '4.5'   \n",
       "4                 '29.9'                  '16.7'                  '23.1'   \n",
       "\n",
       "   Average direction (°deg  Rainfall for month (in Rainfall for year (in  \\\n",
       "0                  '274.0'                   '0.0'                 '0.0'   \n",
       "1                  '240.0'                   '0.0'                 '0.0'   \n",
       "2                  '290.0'                   '0.0'                 '0.0'   \n",
       "3                   '47.0'                   '0.0'                 '0.0'   \n",
       "4                  '265.0'                   '0.0'                 '0.0'   \n",
       "\n",
       "   Maximum rain per minute  Maximum temperature (°F  Minimum temperature (°F  \\\n",
       "0                    '0.0'                   '40.0'                   '34.0'   \n",
       "1                    '0.0'                   '52.0'                   '37.0'   \n",
       "2                    '0.0'                   '41.0'                    '6.0'   \n",
       "3                    '0.0'                   '19.0'                   '-0.0'   \n",
       "4                    '0.0'                   '30.0'                   '15.0'   \n",
       "\n",
       "   Maximum humidity (%  Minimum humidity (%  Maximum pressure  \\\n",
       "0                '4.0'               '27.0'          '29.762'   \n",
       "1                '4.0'               '16.0'          '29.669'   \n",
       "2                '8.0'               '35.0'          '30.232'   \n",
       "3                '7.0'               '35.0'          '30.566'   \n",
       "4                '5.0'               '13.0'          '30.233'   \n",
       "\n",
       "   Minimum pressure  Maximum windspeed (mph  Maximum gust speed (mph  \\\n",
       "0          '29.596'                  '41.4'                   '59.0'   \n",
       "1          '29.268'                  '35.7'                   '51.0'   \n",
       "2           '29.26'                  '25.3'                   '38.0'   \n",
       "3          '30.227'                  '12.7'                   '20.0'   \n",
       "4          '29.568'                  '38.0'                   '53.0'   \n",
       "\n",
       "   Maximum heat index (°F         Date1  Month          diff_pressure  \n",
       "0                  '40.0'  '2022-01-01'   '01'  '0.16600000000000037'  \n",
       "1                  '52.0'  '2022-01-02'   '01'   '0.4009999999999998'  \n",
       "2                  '41.0'  '2022-01-03'   '01'   '0.9719999999999978'  \n",
       "3                  '32.0'  '2022-01-04'   '01'  '0.33899999999999864'  \n",
       "4                  '32.0'  '2022-01-05'   '01'   '0.6649999999999991'  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Exploring first 10 rows of the dataset using head function\n",
    "df.head(5) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "8d008a53",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Temperature</th>\n",
       "      <th>Average humidity (%</th>\n",
       "      <th>Average dewpoint (°F</th>\n",
       "      <th>Average barometer (in</th>\n",
       "      <th>Average windspeed (mph</th>\n",
       "      <th>Average gustspeed (mph</th>\n",
       "      <th>Average direction (°deg</th>\n",
       "      <th>Rainfall for month (in</th>\n",
       "      <th>Rainfall for year (in</th>\n",
       "      <th>Maximum rain per minute</th>\n",
       "      <th>Maximum temperature (°F</th>\n",
       "      <th>Minimum temperature (°F</th>\n",
       "      <th>Maximum humidity (%</th>\n",
       "      <th>Minimum humidity (%</th>\n",
       "      <th>Maximum pressure</th>\n",
       "      <th>Minimum pressure</th>\n",
       "      <th>Maximum windspeed (mph</th>\n",
       "      <th>Maximum gust speed (mph</th>\n",
       "      <th>Maximum heat index (°F</th>\n",
       "      <th>Date1</th>\n",
       "      <th>Month</th>\n",
       "      <th>diff_pressure</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3898</th>\n",
       "      <td>2022-07-25'</td>\n",
       "      <td>'62.8'</td>\n",
       "      <td>'60.0'</td>\n",
       "      <td>'48.1'</td>\n",
       "      <td>'29.7'</td>\n",
       "      <td>'2.5'</td>\n",
       "      <td>'4.0'</td>\n",
       "      <td>'242.0'</td>\n",
       "      <td>'0.33'</td>\n",
       "      <td>'4.47'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'69.2'</td>\n",
       "      <td>'55.1'</td>\n",
       "      <td>'90.0'</td>\n",
       "      <td>'36.0'</td>\n",
       "      <td>'29.781'</td>\n",
       "      <td>'29.645'</td>\n",
       "      <td>'8.1'</td>\n",
       "      <td>'17.3'</td>\n",
       "      <td>'77.5'</td>\n",
       "      <td>'2022-07-25'</td>\n",
       "      <td>'07'</td>\n",
       "      <td>'0.13599999999999923'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3899</th>\n",
       "      <td>2022-07-26'</td>\n",
       "      <td>'60.6'</td>\n",
       "      <td>'68.0'</td>\n",
       "      <td>'48.9'</td>\n",
       "      <td>'29.8'</td>\n",
       "      <td>'1.7'</td>\n",
       "      <td>'2.9'</td>\n",
       "      <td>'357.0'</td>\n",
       "      <td>'0.33'</td>\n",
       "      <td>'4.47'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'71.9'</td>\n",
       "      <td>'50.5'</td>\n",
       "      <td>'90.0'</td>\n",
       "      <td>'40.0'</td>\n",
       "      <td>'29.93'</td>\n",
       "      <td>'29.745'</td>\n",
       "      <td>'11.5'</td>\n",
       "      <td>'15.0'</td>\n",
       "      <td>'77.5'</td>\n",
       "      <td>'2022-07-26'</td>\n",
       "      <td>'07'</td>\n",
       "      <td>'0.18499999999999872'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3900</th>\n",
       "      <td>2022-07-27'</td>\n",
       "      <td>'61.7'</td>\n",
       "      <td>'64.0'</td>\n",
       "      <td>'47.4'</td>\n",
       "      <td>'29.9'</td>\n",
       "      <td>'2.2'</td>\n",
       "      <td>'4.0'</td>\n",
       "      <td>'66.0'</td>\n",
       "      <td>'0.33'</td>\n",
       "      <td>'4.47'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'77.3'</td>\n",
       "      <td>'43.6'</td>\n",
       "      <td>'96.0'</td>\n",
       "      <td>'35.0'</td>\n",
       "      <td>'29.941'</td>\n",
       "      <td>'29.781'</td>\n",
       "      <td>'13.8'</td>\n",
       "      <td>'18.4'</td>\n",
       "      <td>'78.2'</td>\n",
       "      <td>'2022-07-27'</td>\n",
       "      <td>'07'</td>\n",
       "      <td>'0.16000000000000014'</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3901</th>\n",
       "      <td>2022-07-28'</td>\n",
       "      <td>'60.5'</td>\n",
       "      <td>'61.0'</td>\n",
       "      <td>'45.3'</td>\n",
       "      <td>'29.7'</td>\n",
       "      <td>'4.0'</td>\n",
       "      <td>'6.2'</td>\n",
       "      <td>'248.0'</td>\n",
       "      <td>'0.35'</td>\n",
       "      <td>'4.49'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'75.6'</td>\n",
       "      <td>'46.0'</td>\n",
       "      <td>'94.0'</td>\n",
       "      <td>'35.0'</td>\n",
       "      <td>'29.792'</td>\n",
       "      <td>'29.675'</td>\n",
       "      <td>'17.3'</td>\n",
       "      <td>'26.5'</td>\n",
       "      <td>'77.6'</td>\n",
       "      <td>'2022-07-28'</td>\n",
       "      <td>'07'</td>\n",
       "      <td>'0.11700000000000088';</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3902</th>\n",
       "      <td>2022-07-28'</td>\n",
       "      <td>'60.5'</td>\n",
       "      <td>'61.0'</td>\n",
       "      <td>'45.3'</td>\n",
       "      <td>'29.7'</td>\n",
       "      <td>'4.0'</td>\n",
       "      <td>'6.2'</td>\n",
       "      <td>'248.0'</td>\n",
       "      <td>'0.35'</td>\n",
       "      <td>'4.49'</td>\n",
       "      <td>'0.0'</td>\n",
       "      <td>'75.6'</td>\n",
       "      <td>'46.0'</td>\n",
       "      <td>'94.0'</td>\n",
       "      <td>'35.0'</td>\n",
       "      <td>'29.792'</td>\n",
       "      <td>'29.675'</td>\n",
       "      <td>'17.3'</td>\n",
       "      <td>'26.5'</td>\n",
       "      <td>'77.6'</td>\n",
       "      <td>'2022-07-28'</td>\n",
       "      <td>'07'</td>\n",
       "      <td>'0.11700000000000088';</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Date  Temperature  Average humidity (%  Average dewpoint (°F  \\\n",
       "3898  2022-07-25'       '62.8'               '60.0'                '48.1'   \n",
       "3899  2022-07-26'       '60.6'               '68.0'                '48.9'   \n",
       "3900  2022-07-27'       '61.7'               '64.0'                '47.4'   \n",
       "3901  2022-07-28'       '60.5'               '61.0'                '45.3'   \n",
       "3902  2022-07-28'       '60.5'               '61.0'                '45.3'   \n",
       "\n",
       "      Average barometer (in  Average windspeed (mph  Average gustspeed (mph  \\\n",
       "3898                 '29.7'                   '2.5'                   '4.0'   \n",
       "3899                 '29.8'                   '1.7'                   '2.9'   \n",
       "3900                 '29.9'                   '2.2'                   '4.0'   \n",
       "3901                 '29.7'                   '4.0'                   '6.2'   \n",
       "3902                 '29.7'                   '4.0'                   '6.2'   \n",
       "\n",
       "      Average direction (°deg  Rainfall for month (in Rainfall for year (in  \\\n",
       "3898                  '242.0'                  '0.33'                '4.47'   \n",
       "3899                  '357.0'                  '0.33'                '4.47'   \n",
       "3900                   '66.0'                  '0.33'                '4.47'   \n",
       "3901                  '248.0'                  '0.35'                '4.49'   \n",
       "3902                  '248.0'                  '0.35'                '4.49'   \n",
       "\n",
       "      Maximum rain per minute  Maximum temperature (°F  \\\n",
       "3898                    '0.0'                   '69.2'   \n",
       "3899                    '0.0'                   '71.9'   \n",
       "3900                    '0.0'                   '77.3'   \n",
       "3901                    '0.0'                   '75.6'   \n",
       "3902                    '0.0'                   '75.6'   \n",
       "\n",
       "      Minimum temperature (°F  Maximum humidity (%  Minimum humidity (%  \\\n",
       "3898                   '55.1'               '90.0'               '36.0'   \n",
       "3899                   '50.5'               '90.0'               '40.0'   \n",
       "3900                   '43.6'               '96.0'               '35.0'   \n",
       "3901                   '46.0'               '94.0'               '35.0'   \n",
       "3902                   '46.0'               '94.0'               '35.0'   \n",
       "\n",
       "      Maximum pressure  Minimum pressure  Maximum windspeed (mph  \\\n",
       "3898          '29.781'          '29.645'                   '8.1'   \n",
       "3899           '29.93'          '29.745'                  '11.5'   \n",
       "3900          '29.941'          '29.781'                  '13.8'   \n",
       "3901          '29.792'          '29.675'                  '17.3'   \n",
       "3902          '29.792'          '29.675'                  '17.3'   \n",
       "\n",
       "      Maximum gust speed (mph  Maximum heat index (°F         Date1  Month  \\\n",
       "3898                   '17.3'                  '77.5'  '2022-07-25'   '07'   \n",
       "3899                   '15.0'                  '77.5'  '2022-07-26'   '07'   \n",
       "3900                   '18.4'                  '78.2'  '2022-07-27'   '07'   \n",
       "3901                   '26.5'                  '77.6'  '2022-07-28'   '07'   \n",
       "3902                   '26.5'                  '77.6'  '2022-07-28'   '07'   \n",
       "\n",
       "               diff_pressure  \n",
       "3898   '0.13599999999999923'  \n",
       "3899   '0.18499999999999872'  \n",
       "3900   '0.16000000000000014'  \n",
       "3901  '0.11700000000000088';  \n",
       "3902  '0.11700000000000088';  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Exploring last 10 rows of dataset using tail function.\n",
    "df.tail(5) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "34075833",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 3903 entries, 0 to 3902\n",
      "Data columns (total 23 columns):\n",
      " #   Column                    Non-Null Count  Dtype \n",
      "---  ------                    --------------  ----- \n",
      " 0   Date                      3903 non-null   object\n",
      " 1    Temperature              3903 non-null   object\n",
      " 2    Average humidity (%      3903 non-null   object\n",
      " 3    Average dewpoint (°F     3903 non-null   object\n",
      " 4    Average barometer (in    3903 non-null   object\n",
      " 5    Average windspeed (mph   3903 non-null   object\n",
      " 6    Average gustspeed (mph   3903 non-null   object\n",
      " 7    Average direction (°deg  3903 non-null   object\n",
      " 8    Rainfall for month (in   3903 non-null   object\n",
      " 9   Rainfall for year (in     3903 non-null   object\n",
      " 10   Maximum rain per minute  3903 non-null   object\n",
      " 11   Maximum temperature (°F  3903 non-null   object\n",
      " 12   Minimum temperature (°F  3903 non-null   object\n",
      " 13   Maximum humidity (%      3903 non-null   object\n",
      " 14   Minimum humidity (%      3903 non-null   object\n",
      " 15   Maximum pressure         3903 non-null   object\n",
      " 16   Minimum pressure         3903 non-null   object\n",
      " 17   Maximum windspeed (mph   3903 non-null   object\n",
      " 18   Maximum gust speed (mph  3903 non-null   object\n",
      " 19   Maximum heat index (°F   3903 non-null   object\n",
      " 20  Date1                     3903 non-null   object\n",
      " 21   Month                    3903 non-null   object\n",
      " 22   diff_pressure            3903 non-null   object\n",
      "dtypes: object(23)\n",
      "memory usage: 701.4+ KB\n"
     ]
    }
   ],
   "source": [
    "#To check for basic information of the dataset such as null elements and datatypes of column, memory usage by data\n",
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "37e559f6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date                        0\n",
       " Temperature                0\n",
       " Average humidity (%        0\n",
       " Average dewpoint (°F       0\n",
       " Average barometer (in      0\n",
       " Average windspeed (mph     0\n",
       " Average gustspeed (mph     0\n",
       " Average direction (°deg    0\n",
       " Rainfall for month (in     0\n",
       "Rainfall for year (in       0\n",
       " Maximum rain per minute    0\n",
       " Maximum temperature (°F    0\n",
       " Minimum temperature (°F    0\n",
       " Maximum humidity (%        0\n",
       " Minimum humidity (%        0\n",
       " Maximum pressure           0\n",
       " Minimum pressure           0\n",
       " Maximum windspeed (mph     0\n",
       " Maximum gust speed (mph    0\n",
       " Maximum heat index (°F     0\n",
       "Date1                       0\n",
       " Month                      0\n",
       " diff_pressure              0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#to check which column have missing values using isna()\n",
    "df.isna().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "972a3ad7",
   "metadata": {},
   "source": [
    "Using info(),isna() function we get to know following information about the given dataset:\n",
    "\n",
    "• There are total 3902 entries i.e. there are 8618 rows and 23 columns.\n",
    "\n",
    "• All column's datatypes are reading as object type which is incorrect.\n",
    "\n",
    "• There are no null values present in dataset."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6b592362",
   "metadata": {},
   "source": [
    "## Pre-processing and Data Cleaning using Python :\n",
    "\n",
    "As a Data Analyst, data cleaning is inevitable process. It is the process of handling or removing incorrect, corrupted, incorrectly formatted, duplicate, or incomplete data within a dataset. It is a part of the data preparation process. Data cleansing allows for accurate, defensible data that generates reliable visualizations, models, and business decisions.\n",
    "\n",
    "In our given raw dataset, there are some duplicates, trailed whitespaces, missing data and incorrect data. We will further process data cleaning part."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "0bd0bc2f",
   "metadata": {},
   "outputs": [],
   "source": [
    "#to strip unnecessary char from both ends\n",
    "df = df.apply(lambda x:x.str.strip(\"';'\"))                      "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "9a814ba7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Temperature</th>\n",
       "      <th>Average humidity (%</th>\n",
       "      <th>Average dewpoint (°F</th>\n",
       "      <th>Average barometer (in</th>\n",
       "      <th>Average windspeed (mph</th>\n",
       "      <th>Average gustspeed (mph</th>\n",
       "      <th>Average direction (°deg</th>\n",
       "      <th>Rainfall for month (in</th>\n",
       "      <th>Rainfall for year (in</th>\n",
       "      <th>Maximum rain per minute</th>\n",
       "      <th>Maximum temperature (°F</th>\n",
       "      <th>Minimum temperature (°F</th>\n",
       "      <th>Maximum humidity (%</th>\n",
       "      <th>Minimum humidity (%</th>\n",
       "      <th>Maximum pressure</th>\n",
       "      <th>Minimum pressure</th>\n",
       "      <th>Maximum windspeed (mph</th>\n",
       "      <th>Maximum gust speed (mph</th>\n",
       "      <th>Maximum heat index (°F</th>\n",
       "      <th>Date1</th>\n",
       "      <th>Month</th>\n",
       "      <th>diff_pressure</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3898</th>\n",
       "      <td>2022-07-25</td>\n",
       "      <td>62.8</td>\n",
       "      <td>60.0</td>\n",
       "      <td>48.1</td>\n",
       "      <td>29.7</td>\n",
       "      <td>2.5</td>\n",
       "      <td>4.0</td>\n",
       "      <td>242.0</td>\n",
       "      <td>0.33</td>\n",
       "      <td>4.47</td>\n",
       "      <td>0.0</td>\n",
       "      <td>69.2</td>\n",
       "      <td>55.1</td>\n",
       "      <td>90.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>29.781</td>\n",
       "      <td>29.645</td>\n",
       "      <td>8.1</td>\n",
       "      <td>17.3</td>\n",
       "      <td>77.5</td>\n",
       "      <td>2022-07-25</td>\n",
       "      <td>07</td>\n",
       "      <td>0.13599999999999923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3899</th>\n",
       "      <td>2022-07-26</td>\n",
       "      <td>60.6</td>\n",
       "      <td>68.0</td>\n",
       "      <td>48.9</td>\n",
       "      <td>29.8</td>\n",
       "      <td>1.7</td>\n",
       "      <td>2.9</td>\n",
       "      <td>357.0</td>\n",
       "      <td>0.33</td>\n",
       "      <td>4.47</td>\n",
       "      <td>0.0</td>\n",
       "      <td>71.9</td>\n",
       "      <td>50.5</td>\n",
       "      <td>90.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>29.93</td>\n",
       "      <td>29.745</td>\n",
       "      <td>11.5</td>\n",
       "      <td>15.0</td>\n",
       "      <td>77.5</td>\n",
       "      <td>2022-07-26</td>\n",
       "      <td>07</td>\n",
       "      <td>0.18499999999999872</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3900</th>\n",
       "      <td>2022-07-27</td>\n",
       "      <td>61.7</td>\n",
       "      <td>64.0</td>\n",
       "      <td>47.4</td>\n",
       "      <td>29.9</td>\n",
       "      <td>2.2</td>\n",
       "      <td>4.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.33</td>\n",
       "      <td>4.47</td>\n",
       "      <td>0.0</td>\n",
       "      <td>77.3</td>\n",
       "      <td>43.6</td>\n",
       "      <td>96.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>29.941</td>\n",
       "      <td>29.781</td>\n",
       "      <td>13.8</td>\n",
       "      <td>18.4</td>\n",
       "      <td>78.2</td>\n",
       "      <td>2022-07-27</td>\n",
       "      <td>07</td>\n",
       "      <td>0.16000000000000014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3901</th>\n",
       "      <td>2022-07-28</td>\n",
       "      <td>60.5</td>\n",
       "      <td>61.0</td>\n",
       "      <td>45.3</td>\n",
       "      <td>29.7</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.2</td>\n",
       "      <td>248.0</td>\n",
       "      <td>0.35</td>\n",
       "      <td>4.49</td>\n",
       "      <td>0.0</td>\n",
       "      <td>75.6</td>\n",
       "      <td>46.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>29.792</td>\n",
       "      <td>29.675</td>\n",
       "      <td>17.3</td>\n",
       "      <td>26.5</td>\n",
       "      <td>77.6</td>\n",
       "      <td>2022-07-28</td>\n",
       "      <td>07</td>\n",
       "      <td>0.11700000000000088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3902</th>\n",
       "      <td>2022-07-28</td>\n",
       "      <td>60.5</td>\n",
       "      <td>61.0</td>\n",
       "      <td>45.3</td>\n",
       "      <td>29.7</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.2</td>\n",
       "      <td>248.0</td>\n",
       "      <td>0.35</td>\n",
       "      <td>4.49</td>\n",
       "      <td>0.0</td>\n",
       "      <td>75.6</td>\n",
       "      <td>46.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>29.792</td>\n",
       "      <td>29.675</td>\n",
       "      <td>17.3</td>\n",
       "      <td>26.5</td>\n",
       "      <td>77.6</td>\n",
       "      <td>2022-07-28</td>\n",
       "      <td>07</td>\n",
       "      <td>0.11700000000000088</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Date  Temperature  Average humidity (%  Average dewpoint (°F  \\\n",
       "3898  2022-07-25         62.8                 60.0                  48.1   \n",
       "3899  2022-07-26         60.6                 68.0                  48.9   \n",
       "3900  2022-07-27         61.7                 64.0                  47.4   \n",
       "3901  2022-07-28         60.5                 61.0                  45.3   \n",
       "3902  2022-07-28         60.5                 61.0                  45.3   \n",
       "\n",
       "      Average barometer (in  Average windspeed (mph  Average gustspeed (mph  \\\n",
       "3898                   29.7                     2.5                     4.0   \n",
       "3899                   29.8                     1.7                     2.9   \n",
       "3900                   29.9                     2.2                     4.0   \n",
       "3901                   29.7                     4.0                     6.2   \n",
       "3902                   29.7                     4.0                     6.2   \n",
       "\n",
       "      Average direction (°deg  Rainfall for month (in Rainfall for year (in  \\\n",
       "3898                    242.0                    0.33                  4.47   \n",
       "3899                    357.0                    0.33                  4.47   \n",
       "3900                     66.0                    0.33                  4.47   \n",
       "3901                    248.0                    0.35                  4.49   \n",
       "3902                    248.0                    0.35                  4.49   \n",
       "\n",
       "      Maximum rain per minute  Maximum temperature (°F  \\\n",
       "3898                      0.0                     69.2   \n",
       "3899                      0.0                     71.9   \n",
       "3900                      0.0                     77.3   \n",
       "3901                      0.0                     75.6   \n",
       "3902                      0.0                     75.6   \n",
       "\n",
       "      Minimum temperature (°F  Maximum humidity (%  Minimum humidity (%  \\\n",
       "3898                     55.1                 90.0                 36.0   \n",
       "3899                     50.5                 90.0                 40.0   \n",
       "3900                     43.6                 96.0                 35.0   \n",
       "3901                     46.0                 94.0                 35.0   \n",
       "3902                     46.0                 94.0                 35.0   \n",
       "\n",
       "      Maximum pressure  Minimum pressure  Maximum windspeed (mph  \\\n",
       "3898            29.781            29.645                     8.1   \n",
       "3899             29.93            29.745                    11.5   \n",
       "3900            29.941            29.781                    13.8   \n",
       "3901            29.792            29.675                    17.3   \n",
       "3902            29.792            29.675                    17.3   \n",
       "\n",
       "      Maximum gust speed (mph  Maximum heat index (°F       Date1  Month  \\\n",
       "3898                     17.3                    77.5  2022-07-25     07   \n",
       "3899                     15.0                    77.5  2022-07-26     07   \n",
       "3900                     18.4                    78.2  2022-07-27     07   \n",
       "3901                     26.5                    77.6  2022-07-28     07   \n",
       "3902                     26.5                    77.6  2022-07-28     07   \n",
       "\n",
       "            diff_pressure  \n",
       "3898  0.13599999999999923  \n",
       "3899  0.18499999999999872  \n",
       "3900  0.16000000000000014  \n",
       "3901  0.11700000000000088  \n",
       "3902  0.11700000000000088  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "1a64cc46",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Temperature</th>\n",
       "      <th>Average humidity (%</th>\n",
       "      <th>Average dewpoint (°F</th>\n",
       "      <th>Average barometer (in</th>\n",
       "      <th>Average windspeed (mph</th>\n",
       "      <th>Average gustspeed (mph</th>\n",
       "      <th>Average direction (°deg</th>\n",
       "      <th>Rainfall for month (in</th>\n",
       "      <th>Rainfall for year (in</th>\n",
       "      <th>Maximum rain per minute</th>\n",
       "      <th>Maximum temperature (°F</th>\n",
       "      <th>Minimum temperature (°F</th>\n",
       "      <th>Maximum humidity (%</th>\n",
       "      <th>Minimum humidity (%</th>\n",
       "      <th>Maximum pressure</th>\n",
       "      <th>Minimum pressure</th>\n",
       "      <th>Maximum windspeed (mph</th>\n",
       "      <th>Maximum gust speed (mph</th>\n",
       "      <th>Maximum heat index (°F</th>\n",
       "      <th>Date1</th>\n",
       "      <th>Month</th>\n",
       "      <th>diff_pressure</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>37.8</td>\n",
       "      <td>35.0</td>\n",
       "      <td>12.7</td>\n",
       "      <td>29.7</td>\n",
       "      <td>26.4</td>\n",
       "      <td>36.8</td>\n",
       "      <td>274.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>29.762</td>\n",
       "      <td>29.596</td>\n",
       "      <td>41.4</td>\n",
       "      <td>59.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>01</td>\n",
       "      <td>0.16600000000000037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-01-02</td>\n",
       "      <td>43.2</td>\n",
       "      <td>32.0</td>\n",
       "      <td>14.7</td>\n",
       "      <td>29.5</td>\n",
       "      <td>12.8</td>\n",
       "      <td>18.0</td>\n",
       "      <td>240.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>29.669</td>\n",
       "      <td>29.268</td>\n",
       "      <td>35.7</td>\n",
       "      <td>51.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>2022-01-02</td>\n",
       "      <td>01</td>\n",
       "      <td>0.4009999999999998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-01-03</td>\n",
       "      <td>25.7</td>\n",
       "      <td>60.0</td>\n",
       "      <td>12.7</td>\n",
       "      <td>29.7</td>\n",
       "      <td>8.3</td>\n",
       "      <td>12.2</td>\n",
       "      <td>290.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>30.232</td>\n",
       "      <td>29.26</td>\n",
       "      <td>25.3</td>\n",
       "      <td>38.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>2022-01-03</td>\n",
       "      <td>01</td>\n",
       "      <td>0.9719999999999978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-01-04</td>\n",
       "      <td>9.3</td>\n",
       "      <td>67.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>30.4</td>\n",
       "      <td>2.9</td>\n",
       "      <td>4.5</td>\n",
       "      <td>47.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>30.566</td>\n",
       "      <td>30.227</td>\n",
       "      <td>12.7</td>\n",
       "      <td>20.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>2022-01-04</td>\n",
       "      <td>01</td>\n",
       "      <td>0.33899999999999864</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-01-05</td>\n",
       "      <td>23.5</td>\n",
       "      <td>30.0</td>\n",
       "      <td>-5.3</td>\n",
       "      <td>29.9</td>\n",
       "      <td>16.7</td>\n",
       "      <td>23.1</td>\n",
       "      <td>265.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>30.233</td>\n",
       "      <td>29.568</td>\n",
       "      <td>38.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>2022-01-05</td>\n",
       "      <td>01</td>\n",
       "      <td>0.6649999999999991</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Date  Temperature  Average humidity (%  Average dewpoint (°F  \\\n",
       "0  2022-01-01         37.8                 35.0                  12.7   \n",
       "1  2022-01-02         43.2                 32.0                  14.7   \n",
       "2  2022-01-03         25.7                 60.0                  12.7   \n",
       "3  2022-01-04          9.3                 67.0                   0.1   \n",
       "4  2022-01-05         23.5                 30.0                  -5.3   \n",
       "\n",
       "   Average barometer (in  Average windspeed (mph  Average gustspeed (mph  \\\n",
       "0                   29.7                    26.4                    36.8   \n",
       "1                   29.5                    12.8                    18.0   \n",
       "2                   29.7                     8.3                    12.2   \n",
       "3                   30.4                     2.9                     4.5   \n",
       "4                   29.9                    16.7                    23.1   \n",
       "\n",
       "   Average direction (°deg  Rainfall for month (in Rainfall for year (in  \\\n",
       "0                    274.0                     0.0                   0.0   \n",
       "1                    240.0                     0.0                   0.0   \n",
       "2                    290.0                     0.0                   0.0   \n",
       "3                     47.0                     0.0                   0.0   \n",
       "4                    265.0                     0.0                   0.0   \n",
       "\n",
       "   Maximum rain per minute  Maximum temperature (°F  Minimum temperature (°F  \\\n",
       "0                      0.0                     40.0                     34.0   \n",
       "1                      0.0                     52.0                     37.0   \n",
       "2                      0.0                     41.0                      6.0   \n",
       "3                      0.0                     19.0                     -0.0   \n",
       "4                      0.0                     30.0                     15.0   \n",
       "\n",
       "   Maximum humidity (%  Minimum humidity (%  Maximum pressure  \\\n",
       "0                  4.0                 27.0            29.762   \n",
       "1                  4.0                 16.0            29.669   \n",
       "2                  8.0                 35.0            30.232   \n",
       "3                  7.0                 35.0            30.566   \n",
       "4                  5.0                 13.0            30.233   \n",
       "\n",
       "   Minimum pressure  Maximum windspeed (mph  Maximum gust speed (mph  \\\n",
       "0            29.596                    41.4                     59.0   \n",
       "1            29.268                    35.7                     51.0   \n",
       "2             29.26                    25.3                     38.0   \n",
       "3            30.227                    12.7                     20.0   \n",
       "4            29.568                    38.0                     53.0   \n",
       "\n",
       "   Maximum heat index (°F       Date1  Month        diff_pressure  \n",
       "0                    40.0  2022-01-01     01  0.16600000000000037  \n",
       "1                    52.0  2022-01-02     01   0.4009999999999998  \n",
       "2                    41.0  2022-01-03     01   0.9719999999999978  \n",
       "3                    32.0  2022-01-04     01  0.33899999999999864  \n",
       "4                    32.0  2022-01-05     01   0.6649999999999991  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "57cf34ef",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Temperature</th>\n",
       "      <th>Average humidity (%</th>\n",
       "      <th>Average dewpoint (°F</th>\n",
       "      <th>Average barometer (in</th>\n",
       "      <th>Average windspeed (mph</th>\n",
       "      <th>Average gustspeed (mph</th>\n",
       "      <th>Average direction (°deg</th>\n",
       "      <th>Rainfall for month (in</th>\n",
       "      <th>Rainfall for year (in</th>\n",
       "      <th>Maximum rain per minute</th>\n",
       "      <th>Maximum temperature (°F</th>\n",
       "      <th>Minimum temperature (°F</th>\n",
       "      <th>Maximum humidity (%</th>\n",
       "      <th>Minimum humidity (%</th>\n",
       "      <th>Maximum pressure</th>\n",
       "      <th>Minimum pressure</th>\n",
       "      <th>Maximum windspeed (mph</th>\n",
       "      <th>Maximum gust speed (mph</th>\n",
       "      <th>Maximum heat index (°F</th>\n",
       "      <th>Date1</th>\n",
       "      <th>Month</th>\n",
       "      <th>diff_pressure</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>37.8</td>\n",
       "      <td>35.0</td>\n",
       "      <td>12.7</td>\n",
       "      <td>29.7</td>\n",
       "      <td>26.4</td>\n",
       "      <td>36.8</td>\n",
       "      <td>274.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>29.762</td>\n",
       "      <td>29.596</td>\n",
       "      <td>41.4</td>\n",
       "      <td>59.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>01</td>\n",
       "      <td>0.16600000000000037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-01-02</td>\n",
       "      <td>43.2</td>\n",
       "      <td>32.0</td>\n",
       "      <td>14.7</td>\n",
       "      <td>29.5</td>\n",
       "      <td>12.8</td>\n",
       "      <td>18.0</td>\n",
       "      <td>240.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>29.669</td>\n",
       "      <td>29.268</td>\n",
       "      <td>35.7</td>\n",
       "      <td>51.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>2022-01-02</td>\n",
       "      <td>01</td>\n",
       "      <td>0.4009999999999998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-01-03</td>\n",
       "      <td>25.7</td>\n",
       "      <td>60.0</td>\n",
       "      <td>12.7</td>\n",
       "      <td>29.7</td>\n",
       "      <td>8.3</td>\n",
       "      <td>12.2</td>\n",
       "      <td>290.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>30.232</td>\n",
       "      <td>29.26</td>\n",
       "      <td>25.3</td>\n",
       "      <td>38.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>2022-01-03</td>\n",
       "      <td>01</td>\n",
       "      <td>0.9719999999999978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-01-04</td>\n",
       "      <td>9.3</td>\n",
       "      <td>67.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>30.4</td>\n",
       "      <td>2.9</td>\n",
       "      <td>4.5</td>\n",
       "      <td>47.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>30.566</td>\n",
       "      <td>30.227</td>\n",
       "      <td>12.7</td>\n",
       "      <td>20.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>2022-01-04</td>\n",
       "      <td>01</td>\n",
       "      <td>0.33899999999999864</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-01-05</td>\n",
       "      <td>23.5</td>\n",
       "      <td>30.0</td>\n",
       "      <td>-5.3</td>\n",
       "      <td>29.9</td>\n",
       "      <td>16.7</td>\n",
       "      <td>23.1</td>\n",
       "      <td>265.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>30.233</td>\n",
       "      <td>29.568</td>\n",
       "      <td>38.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>2022-01-05</td>\n",
       "      <td>01</td>\n",
       "      <td>0.6649999999999991</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Date  Temperature  Average humidity (%  Average dewpoint (°F  \\\n",
       "0  2022-01-01         37.8                 35.0                  12.7   \n",
       "1  2022-01-02         43.2                 32.0                  14.7   \n",
       "2  2022-01-03         25.7                 60.0                  12.7   \n",
       "3  2022-01-04          9.3                 67.0                   0.1   \n",
       "4  2022-01-05         23.5                 30.0                  -5.3   \n",
       "\n",
       "   Average barometer (in  Average windspeed (mph  Average gustspeed (mph  \\\n",
       "0                   29.7                    26.4                    36.8   \n",
       "1                   29.5                    12.8                    18.0   \n",
       "2                   29.7                     8.3                    12.2   \n",
       "3                   30.4                     2.9                     4.5   \n",
       "4                   29.9                    16.7                    23.1   \n",
       "\n",
       "   Average direction (°deg  Rainfall for month (in Rainfall for year (in  \\\n",
       "0                    274.0                     0.0                   0.0   \n",
       "1                    240.0                     0.0                   0.0   \n",
       "2                    290.0                     0.0                   0.0   \n",
       "3                     47.0                     0.0                   0.0   \n",
       "4                    265.0                     0.0                   0.0   \n",
       "\n",
       "   Maximum rain per minute  Maximum temperature (°F  Minimum temperature (°F  \\\n",
       "0                      0.0                     40.0                     34.0   \n",
       "1                      0.0                     52.0                     37.0   \n",
       "2                      0.0                     41.0                      6.0   \n",
       "3                      0.0                     19.0                     -0.0   \n",
       "4                      0.0                     30.0                     15.0   \n",
       "\n",
       "   Maximum humidity (%  Minimum humidity (%  Maximum pressure  \\\n",
       "0                  4.0                 27.0            29.762   \n",
       "1                  4.0                 16.0            29.669   \n",
       "2                  8.0                 35.0            30.232   \n",
       "3                  7.0                 35.0            30.566   \n",
       "4                  5.0                 13.0            30.233   \n",
       "\n",
       "   Minimum pressure  Maximum windspeed (mph  Maximum gust speed (mph  \\\n",
       "0            29.596                    41.4                     59.0   \n",
       "1            29.268                    35.7                     51.0   \n",
       "2             29.26                    25.3                     38.0   \n",
       "3            30.227                    12.7                     20.0   \n",
       "4            29.568                    38.0                     53.0   \n",
       "\n",
       "   Maximum heat index (°F       Date1  Month        diff_pressure  \n",
       "0                    40.0  2022-01-01     01  0.16600000000000037  \n",
       "1                    52.0  2022-01-02     01   0.4009999999999998  \n",
       "2                    41.0  2022-01-03     01   0.9719999999999978  \n",
       "3                    32.0  2022-01-04     01  0.33899999999999864  \n",
       "4                    32.0  2022-01-05     01   0.6649999999999991  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#to strip whitespaces if present from both end\n",
    "df = df.apply(lambda x:x.str.strip())            \n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "bf91bb45",
   "metadata": {},
   "source": [
    "### Exploring  and handling columns :"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "8af0c58c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Date', ' Temperature', ' Average humidity (%', ' Average dewpoint (°F',\n",
       "       ' Average barometer (in', ' Average windspeed (mph',\n",
       "       ' Average gustspeed (mph', ' Average direction (°deg',\n",
       "       ' Rainfall for month (in', 'Rainfall for year (in',\n",
       "       ' Maximum rain per minute', ' Maximum temperature (°F',\n",
       "       ' Minimum temperature (°F', ' Maximum humidity (%',\n",
       "       ' Minimum humidity (%', ' Maximum pressure', ' Minimum pressure',\n",
       "       ' Maximum windspeed (mph', ' Maximum gust speed (mph',\n",
       "       ' Maximum heat index (°F', 'Date1', ' Month', ' diff_pressure'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#to explore columns present\n",
    "df.columns                      "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ee9d4111",
   "metadata": {},
   "source": [
    "We will rename column names using .rename() for better readiablity."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "7a448c08",
   "metadata": {},
   "outputs": [],
   "source": [
    "#to rename columns\n",
    "df.rename(columns={\n",
    "  'Date': 'Date',\n",
    "  ' Temperature': 'Average_temperature',\n",
    "  ' Average humidity (%': 'Average_humidity',\n",
    "  ' Average dewpoint (°F': 'Average_dewpoint',\n",
    "  ' Average barometer (in': 'Average_barometer',\n",
    "  ' Average windspeed (mph': 'Average_windspeed',\n",
    "  ' Average gustspeed (mph': 'Average_gust_speed',\n",
    "  ' Average direction (°deg': 'Average_direction_degree',\n",
    "  ' Rainfall for month (in': 'Rainfall_for_month',\n",
    "  'Rainfall for year (in': 'Rainfall_for_year',\n",
    "  ' Maximum rain per minute': 'Maximum_rain_per_minute',\n",
    "  ' Maximum temperature (°F': 'Maximum_temperature',\n",
    "  ' Minimum temperature (°F': 'Minimum_temperature',\n",
    "  ' Maximum humidity (%': 'Maximum_humidity',\n",
    "  ' Minimum humidity (%': 'Minimum_humidity',\n",
    "  ' Maximum pressure': 'Maximum_pressure',\n",
    "  ' Minimum pressure': 'Minimum_pressure',\n",
    "  ' Maximum windspeed (mph': 'Maximum_windspeed',\n",
    "  ' Maximum gust speed (mph': 'Maximum_gust_speed',\n",
    "  ' Maximum heat index (°F': 'Maximum_heat_index',\n",
    "  'Date1': 'Date1',\n",
    "  ' Month': 'Month',\n",
    "  ' diff_pressure': 'Diff_pressure'\n",
    "}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "787edd09",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Date', 'Average_temperature', 'Average_humidity', 'Average_dewpoint',\n",
       "       'Average_barometer', 'Average_windspeed', 'Average_gust_speed',\n",
       "       'Average_direction_degree', 'Rainfall_for_month', 'Rainfall_for_year',\n",
       "       'Maximum_rain_per_minute', 'Maximum_temperature', 'Minimum_temperature',\n",
       "       'Maximum_humidity', 'Minimum_humidity', 'Maximum_pressure',\n",
       "       'Minimum_pressure', 'Maximum_windspeed', 'Maximum_gust_speed',\n",
       "       'Maximum_heat_index', 'Date1', 'Month', 'Diff_pressure'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#to check new column names\n",
    "df.columns            "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "f41ba393",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Average_temperature</th>\n",
       "      <th>Average_humidity</th>\n",
       "      <th>Average_dewpoint</th>\n",
       "      <th>Average_barometer</th>\n",
       "      <th>Average_windspeed</th>\n",
       "      <th>Average_gust_speed</th>\n",
       "      <th>Average_direction_degree</th>\n",
       "      <th>Rainfall_for_month</th>\n",
       "      <th>Rainfall_for_year</th>\n",
       "      <th>Maximum_rain_per_minute</th>\n",
       "      <th>Maximum_temperature</th>\n",
       "      <th>Minimum_temperature</th>\n",
       "      <th>Maximum_humidity</th>\n",
       "      <th>Minimum_humidity</th>\n",
       "      <th>Maximum_pressure</th>\n",
       "      <th>Minimum_pressure</th>\n",
       "      <th>Maximum_windspeed</th>\n",
       "      <th>Maximum_gust_speed</th>\n",
       "      <th>Maximum_heat_index</th>\n",
       "      <th>Date1</th>\n",
       "      <th>Month</th>\n",
       "      <th>Diff_pressure</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>37.8</td>\n",
       "      <td>35.0</td>\n",
       "      <td>12.7</td>\n",
       "      <td>29.7</td>\n",
       "      <td>26.4</td>\n",
       "      <td>36.8</td>\n",
       "      <td>274.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>29.762</td>\n",
       "      <td>29.596</td>\n",
       "      <td>41.4</td>\n",
       "      <td>59.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>01</td>\n",
       "      <td>0.16600000000000037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-01-02</td>\n",
       "      <td>43.2</td>\n",
       "      <td>32.0</td>\n",
       "      <td>14.7</td>\n",
       "      <td>29.5</td>\n",
       "      <td>12.8</td>\n",
       "      <td>18.0</td>\n",
       "      <td>240.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>29.669</td>\n",
       "      <td>29.268</td>\n",
       "      <td>35.7</td>\n",
       "      <td>51.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>2022-01-02</td>\n",
       "      <td>01</td>\n",
       "      <td>0.4009999999999998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-01-03</td>\n",
       "      <td>25.7</td>\n",
       "      <td>60.0</td>\n",
       "      <td>12.7</td>\n",
       "      <td>29.7</td>\n",
       "      <td>8.3</td>\n",
       "      <td>12.2</td>\n",
       "      <td>290.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>30.232</td>\n",
       "      <td>29.26</td>\n",
       "      <td>25.3</td>\n",
       "      <td>38.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>2022-01-03</td>\n",
       "      <td>01</td>\n",
       "      <td>0.9719999999999978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-01-04</td>\n",
       "      <td>9.3</td>\n",
       "      <td>67.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>30.4</td>\n",
       "      <td>2.9</td>\n",
       "      <td>4.5</td>\n",
       "      <td>47.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>30.566</td>\n",
       "      <td>30.227</td>\n",
       "      <td>12.7</td>\n",
       "      <td>20.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>2022-01-04</td>\n",
       "      <td>01</td>\n",
       "      <td>0.33899999999999864</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-01-05</td>\n",
       "      <td>23.5</td>\n",
       "      <td>30.0</td>\n",
       "      <td>-5.3</td>\n",
       "      <td>29.9</td>\n",
       "      <td>16.7</td>\n",
       "      <td>23.1</td>\n",
       "      <td>265.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>30.233</td>\n",
       "      <td>29.568</td>\n",
       "      <td>38.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>2022-01-05</td>\n",
       "      <td>01</td>\n",
       "      <td>0.6649999999999991</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Date Average_temperature Average_humidity Average_dewpoint  \\\n",
       "0  2022-01-01                37.8             35.0             12.7   \n",
       "1  2022-01-02                43.2             32.0             14.7   \n",
       "2  2022-01-03                25.7             60.0             12.7   \n",
       "3  2022-01-04                 9.3             67.0              0.1   \n",
       "4  2022-01-05                23.5             30.0             -5.3   \n",
       "\n",
       "  Average_barometer Average_windspeed Average_gust_speed  \\\n",
       "0              29.7              26.4               36.8   \n",
       "1              29.5              12.8               18.0   \n",
       "2              29.7               8.3               12.2   \n",
       "3              30.4               2.9                4.5   \n",
       "4              29.9              16.7               23.1   \n",
       "\n",
       "  Average_direction_degree Rainfall_for_month Rainfall_for_year  \\\n",
       "0                    274.0                0.0               0.0   \n",
       "1                    240.0                0.0               0.0   \n",
       "2                    290.0                0.0               0.0   \n",
       "3                     47.0                0.0               0.0   \n",
       "4                    265.0                0.0               0.0   \n",
       "\n",
       "  Maximum_rain_per_minute Maximum_temperature Minimum_temperature  \\\n",
       "0                     0.0                40.0                34.0   \n",
       "1                     0.0                52.0                37.0   \n",
       "2                     0.0                41.0                 6.0   \n",
       "3                     0.0                19.0                -0.0   \n",
       "4                     0.0                30.0                15.0   \n",
       "\n",
       "  Maximum_humidity Minimum_humidity Maximum_pressure Minimum_pressure  \\\n",
       "0              4.0             27.0           29.762           29.596   \n",
       "1              4.0             16.0           29.669           29.268   \n",
       "2              8.0             35.0           30.232            29.26   \n",
       "3              7.0             35.0           30.566           30.227   \n",
       "4              5.0             13.0           30.233           29.568   \n",
       "\n",
       "  Maximum_windspeed Maximum_gust_speed Maximum_heat_index       Date1 Month  \\\n",
       "0              41.4               59.0               40.0  2022-01-01    01   \n",
       "1              35.7               51.0               52.0  2022-01-02    01   \n",
       "2              25.3               38.0               41.0  2022-01-03    01   \n",
       "3              12.7               20.0               32.0  2022-01-04    01   \n",
       "4              38.0               53.0               32.0  2022-01-05    01   \n",
       "\n",
       "         Diff_pressure  \n",
       "0  0.16600000000000037  \n",
       "1   0.4009999999999998  \n",
       "2   0.9719999999999978  \n",
       "3  0.33899999999999864  \n",
       "4   0.6649999999999991  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()           "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "12723bb4",
   "metadata": {},
   "source": [
    "### Fixing Data Types of Columns :\n",
    "\n",
    "We will change the data types of Date column to Datetime and other columns as Float."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "50694039",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('<M8[ns]')"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#changing Date column to datetime\n",
    "df['Date'] = pd.to_datetime(df['Date'], format='%Y-%m-%d', errors='coerce')\n",
    "df['Date'].dtype"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "0613cbc4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 3903 entries, 0 to 3902\n",
      "Data columns (total 23 columns):\n",
      " #   Column                    Non-Null Count  Dtype         \n",
      "---  ------                    --------------  -----         \n",
      " 0   Date                      3901 non-null   datetime64[ns]\n",
      " 1   Average_temperature       3903 non-null   object        \n",
      " 2   Average_humidity          3903 non-null   object        \n",
      " 3   Average_dewpoint          3903 non-null   object        \n",
      " 4   Average_barometer         3903 non-null   object        \n",
      " 5   Average_windspeed         3903 non-null   object        \n",
      " 6   Average_gust_speed        3903 non-null   object        \n",
      " 7   Average_direction_degree  3903 non-null   object        \n",
      " 8   Rainfall_for_month        3903 non-null   object        \n",
      " 9   Rainfall_for_year         3903 non-null   object        \n",
      " 10  Maximum_rain_per_minute   3903 non-null   object        \n",
      " 11  Maximum_temperature       3903 non-null   object        \n",
      " 12  Minimum_temperature       3903 non-null   object        \n",
      " 13  Maximum_humidity          3903 non-null   object        \n",
      " 14  Minimum_humidity          3903 non-null   object        \n",
      " 15  Maximum_pressure          3903 non-null   object        \n",
      " 16  Minimum_pressure          3903 non-null   object        \n",
      " 17  Maximum_windspeed         3903 non-null   object        \n",
      " 18  Maximum_gust_speed        3903 non-null   object        \n",
      " 19  Maximum_heat_index        3903 non-null   object        \n",
      " 20  Date1                     3903 non-null   object        \n",
      " 21  Month                     3903 non-null   object        \n",
      " 22  Diff_pressure             3903 non-null   object        \n",
      "dtypes: datetime64[ns](1), object(22)\n",
      "memory usage: 701.4+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()          #to check column info"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0ea6f4e1",
   "metadata": {},
   "source": [
    "We can see Date1 and Month are unnecessary columns we can drop them."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "6a029aa1",
   "metadata": {},
   "outputs": [],
   "source": [
    "#to drop columns\n",
    "df = df.drop(columns=['Date1', 'Month'])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6af1cc95",
   "metadata": {},
   "source": [
    "Now, we will change the data types of remaining columns excluding Date column."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "022dbba5",
   "metadata": {},
   "outputs": [],
   "source": [
    "exclude_col = ['Date']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "1ad26eca",
   "metadata": {},
   "outputs": [],
   "source": [
    "# to  get a list of all column names, except for the excluded column\n",
    "cols = [col for col in df.columns if col not in exclude_col]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "99b69ae8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Average_temperature',\n",
       " 'Average_humidity',\n",
       " 'Average_dewpoint',\n",
       " 'Average_barometer',\n",
       " 'Average_windspeed',\n",
       " 'Average_gust_speed',\n",
       " 'Average_direction_degree',\n",
       " 'Rainfall_for_month',\n",
       " 'Rainfall_for_year',\n",
       " 'Maximum_rain_per_minute',\n",
       " 'Maximum_temperature',\n",
       " 'Minimum_temperature',\n",
       " 'Maximum_humidity',\n",
       " 'Minimum_humidity',\n",
       " 'Maximum_pressure',\n",
       " 'Minimum_pressure',\n",
       " 'Maximum_windspeed',\n",
       " 'Maximum_gust_speed',\n",
       " 'Maximum_heat_index',\n",
       " 'Diff_pressure']"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cols"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "c51eca72",
   "metadata": {},
   "outputs": [],
   "source": [
    "df[cols] = df[cols].apply(lambda x: x.astype(float))             #changing datatypes to float"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "f425496a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 3903 entries, 0 to 3902\n",
      "Data columns (total 21 columns):\n",
      " #   Column                    Non-Null Count  Dtype         \n",
      "---  ------                    --------------  -----         \n",
      " 0   Date                      3901 non-null   datetime64[ns]\n",
      " 1   Average_temperature       3903 non-null   float64       \n",
      " 2   Average_humidity          3903 non-null   float64       \n",
      " 3   Average_dewpoint          3903 non-null   float64       \n",
      " 4   Average_barometer         3903 non-null   float64       \n",
      " 5   Average_windspeed         3903 non-null   float64       \n",
      " 6   Average_gust_speed        3903 non-null   float64       \n",
      " 7   Average_direction_degree  3903 non-null   float64       \n",
      " 8   Rainfall_for_month        3903 non-null   float64       \n",
      " 9   Rainfall_for_year         3903 non-null   float64       \n",
      " 10  Maximum_rain_per_minute   3903 non-null   float64       \n",
      " 11  Maximum_temperature       3903 non-null   float64       \n",
      " 12  Minimum_temperature       3903 non-null   float64       \n",
      " 13  Maximum_humidity          3903 non-null   float64       \n",
      " 14  Minimum_humidity          3903 non-null   float64       \n",
      " 15  Maximum_pressure          3903 non-null   float64       \n",
      " 16  Minimum_pressure          3903 non-null   float64       \n",
      " 17  Maximum_windspeed         3903 non-null   float64       \n",
      " 18  Maximum_gust_speed        3903 non-null   float64       \n",
      " 19  Maximum_heat_index        3903 non-null   float64       \n",
      " 20  Diff_pressure             3903 non-null   float64       \n",
      "dtypes: datetime64[ns](1), float64(20)\n",
      "memory usage: 640.5 KB\n"
     ]
    }
   ],
   "source": [
    "df.info()           #successfully changed"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "17a47445",
   "metadata": {},
   "source": [
    "### To fix incorrect year in Date column :\n",
    "This is most challenging task in this dataset. In our raw dataset, Date column is corrupted. We can see only 2022 year throughout the year. But the given data is day wise weather attributes from 2022 to July 2033 (predicted\n",
    "data). We have to change year from 2022 to 2033.\n",
    "\n",
    "First we will assign target_date as '2022-01-01'. Whenever we will find 2022-01-01, we will increment a year.\n",
    "Replace for all rows with a new year,till we encounter '2022-01-01' and continue till the end. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "fb6fa01d",
   "metadata": {},
   "outputs": [],
   "source": [
    "target_date = '2022-01-01'                         \n",
    "target_date = pd.to_datetime(target_date)\n",
    "index = df.index[df['Date'] == target_date].tolist()\n",
    "year = 2021\n",
    "max_year = 2033\n",
    "\n",
    "for i in range(index[0], df.shape[0]):\n",
    "    if df.at[i, 'Date'] == target_date:\n",
    "        year += 1\n",
    "        if year > max_year:\n",
    "            break\n",
    "    df.at[i, 'Date'] = df.at[i, 'Date'].replace(year=year)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "dbb93bb2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Average_temperature</th>\n",
       "      <th>Average_humidity</th>\n",
       "      <th>Average_dewpoint</th>\n",
       "      <th>Average_barometer</th>\n",
       "      <th>Average_windspeed</th>\n",
       "      <th>Average_gust_speed</th>\n",
       "      <th>Average_direction_degree</th>\n",
       "      <th>Rainfall_for_month</th>\n",
       "      <th>Rainfall_for_year</th>\n",
       "      <th>Maximum_rain_per_minute</th>\n",
       "      <th>Maximum_temperature</th>\n",
       "      <th>Minimum_temperature</th>\n",
       "      <th>Maximum_humidity</th>\n",
       "      <th>Minimum_humidity</th>\n",
       "      <th>Maximum_pressure</th>\n",
       "      <th>Minimum_pressure</th>\n",
       "      <th>Maximum_windspeed</th>\n",
       "      <th>Maximum_gust_speed</th>\n",
       "      <th>Maximum_heat_index</th>\n",
       "      <th>Diff_pressure</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3853</th>\n",
       "      <td>2033-06-10</td>\n",
       "      <td>51.9</td>\n",
       "      <td>40.0</td>\n",
       "      <td>27.6</td>\n",
       "      <td>30.0</td>\n",
       "      <td>6.7</td>\n",
       "      <td>10.5</td>\n",
       "      <td>239.0</td>\n",
       "      <td>0.15</td>\n",
       "      <td>3.55</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.4</td>\n",
       "      <td>44.8</td>\n",
       "      <td>52.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>30.017</td>\n",
       "      <td>29.859</td>\n",
       "      <td>18.4</td>\n",
       "      <td>33.4</td>\n",
       "      <td>64.4</td>\n",
       "      <td>0.1580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3854</th>\n",
       "      <td>2033-06-11</td>\n",
       "      <td>55.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>30.2</td>\n",
       "      <td>30.1</td>\n",
       "      <td>2.4</td>\n",
       "      <td>4.4</td>\n",
       "      <td>129.0</td>\n",
       "      <td>0.15</td>\n",
       "      <td>3.55</td>\n",
       "      <td>0.0</td>\n",
       "      <td>71.3</td>\n",
       "      <td>32.6</td>\n",
       "      <td>80.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>30.137</td>\n",
       "      <td>30.005</td>\n",
       "      <td>12.7</td>\n",
       "      <td>17.3</td>\n",
       "      <td>76.0</td>\n",
       "      <td>0.1320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3855</th>\n",
       "      <td>2033-06-12</td>\n",
       "      <td>61.5</td>\n",
       "      <td>39.0</td>\n",
       "      <td>31.7</td>\n",
       "      <td>30.0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>5.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>0.15</td>\n",
       "      <td>3.55</td>\n",
       "      <td>0.0</td>\n",
       "      <td>80.7</td>\n",
       "      <td>36.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>30.137</td>\n",
       "      <td>29.826</td>\n",
       "      <td>13.8</td>\n",
       "      <td>20.7</td>\n",
       "      <td>79.0</td>\n",
       "      <td>0.3110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3856</th>\n",
       "      <td>2033-06-13</td>\n",
       "      <td>61.2</td>\n",
       "      <td>45.0</td>\n",
       "      <td>37.6</td>\n",
       "      <td>29.7</td>\n",
       "      <td>3.8</td>\n",
       "      <td>6.2</td>\n",
       "      <td>255.0</td>\n",
       "      <td>0.20</td>\n",
       "      <td>3.60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>80.2</td>\n",
       "      <td>41.1</td>\n",
       "      <td>77.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>29.838</td>\n",
       "      <td>29.545</td>\n",
       "      <td>19.6</td>\n",
       "      <td>32.2</td>\n",
       "      <td>78.6</td>\n",
       "      <td>0.2930</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3857</th>\n",
       "      <td>2033-06-14</td>\n",
       "      <td>65.7</td>\n",
       "      <td>26.0</td>\n",
       "      <td>25.6</td>\n",
       "      <td>29.5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>11.7</td>\n",
       "      <td>226.0</td>\n",
       "      <td>0.20</td>\n",
       "      <td>3.60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>78.7</td>\n",
       "      <td>49.3</td>\n",
       "      <td>55.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>29.592</td>\n",
       "      <td>29.446</td>\n",
       "      <td>28.8</td>\n",
       "      <td>40.3</td>\n",
       "      <td>77.3</td>\n",
       "      <td>0.1460</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3858</th>\n",
       "      <td>2033-06-15</td>\n",
       "      <td>59.9</td>\n",
       "      <td>30.0</td>\n",
       "      <td>25.3</td>\n",
       "      <td>29.7</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.6</td>\n",
       "      <td>297.0</td>\n",
       "      <td>0.20</td>\n",
       "      <td>3.60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>82.4</td>\n",
       "      <td>39.2</td>\n",
       "      <td>54.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>29.796</td>\n",
       "      <td>29.598</td>\n",
       "      <td>11.5</td>\n",
       "      <td>19.6</td>\n",
       "      <td>79.9</td>\n",
       "      <td>0.1980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3859</th>\n",
       "      <td>2033-06-16</td>\n",
       "      <td>65.3</td>\n",
       "      <td>28.0</td>\n",
       "      <td>27.2</td>\n",
       "      <td>29.5</td>\n",
       "      <td>6.2</td>\n",
       "      <td>9.6</td>\n",
       "      <td>245.0</td>\n",
       "      <td>0.20</td>\n",
       "      <td>3.60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>81.5</td>\n",
       "      <td>40.8</td>\n",
       "      <td>63.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>29.688</td>\n",
       "      <td>29.397</td>\n",
       "      <td>19.6</td>\n",
       "      <td>28.8</td>\n",
       "      <td>79.3</td>\n",
       "      <td>0.2910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3860</th>\n",
       "      <td>2033-06-17</td>\n",
       "      <td>64.4</td>\n",
       "      <td>28.0</td>\n",
       "      <td>26.1</td>\n",
       "      <td>29.4</td>\n",
       "      <td>6.2</td>\n",
       "      <td>9.5</td>\n",
       "      <td>251.0</td>\n",
       "      <td>0.20</td>\n",
       "      <td>3.60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>42.6</td>\n",
       "      <td>58.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>29.517</td>\n",
       "      <td>29.404</td>\n",
       "      <td>19.6</td>\n",
       "      <td>26.5</td>\n",
       "      <td>79.6</td>\n",
       "      <td>0.1130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3861</th>\n",
       "      <td>2033-06-18</td>\n",
       "      <td>53.2</td>\n",
       "      <td>56.0</td>\n",
       "      <td>36.6</td>\n",
       "      <td>29.7</td>\n",
       "      <td>3.7</td>\n",
       "      <td>6.5</td>\n",
       "      <td>72.0</td>\n",
       "      <td>0.27</td>\n",
       "      <td>3.67</td>\n",
       "      <td>0.0</td>\n",
       "      <td>62.3</td>\n",
       "      <td>44.4</td>\n",
       "      <td>91.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>29.873</td>\n",
       "      <td>29.518</td>\n",
       "      <td>12.7</td>\n",
       "      <td>19.6</td>\n",
       "      <td>62.3</td>\n",
       "      <td>0.3550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3862</th>\n",
       "      <td>2033-06-19</td>\n",
       "      <td>48.8</td>\n",
       "      <td>81.0</td>\n",
       "      <td>43.1</td>\n",
       "      <td>29.9</td>\n",
       "      <td>2.2</td>\n",
       "      <td>3.8</td>\n",
       "      <td>48.0</td>\n",
       "      <td>0.52</td>\n",
       "      <td>3.92</td>\n",
       "      <td>0.0</td>\n",
       "      <td>56.3</td>\n",
       "      <td>41.6</td>\n",
       "      <td>94.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>29.898</td>\n",
       "      <td>29.804</td>\n",
       "      <td>20.7</td>\n",
       "      <td>31.1</td>\n",
       "      <td>56.3</td>\n",
       "      <td>0.0940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3863</th>\n",
       "      <td>2033-06-20</td>\n",
       "      <td>56.3</td>\n",
       "      <td>49.0</td>\n",
       "      <td>31.2</td>\n",
       "      <td>29.8</td>\n",
       "      <td>3.8</td>\n",
       "      <td>6.3</td>\n",
       "      <td>252.0</td>\n",
       "      <td>0.53</td>\n",
       "      <td>3.93</td>\n",
       "      <td>0.0</td>\n",
       "      <td>77.6</td>\n",
       "      <td>32.2</td>\n",
       "      <td>96.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>29.941</td>\n",
       "      <td>29.752</td>\n",
       "      <td>18.4</td>\n",
       "      <td>24.2</td>\n",
       "      <td>76.7</td>\n",
       "      <td>0.1890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3864</th>\n",
       "      <td>2033-06-21</td>\n",
       "      <td>58.9</td>\n",
       "      <td>48.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>29.7</td>\n",
       "      <td>3.4</td>\n",
       "      <td>5.4</td>\n",
       "      <td>252.0</td>\n",
       "      <td>0.55</td>\n",
       "      <td>3.95</td>\n",
       "      <td>0.0</td>\n",
       "      <td>71.5</td>\n",
       "      <td>47.7</td>\n",
       "      <td>78.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>29.753</td>\n",
       "      <td>29.608</td>\n",
       "      <td>13.8</td>\n",
       "      <td>29.9</td>\n",
       "      <td>77.0</td>\n",
       "      <td>0.1450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3865</th>\n",
       "      <td>2033-06-22</td>\n",
       "      <td>57.1</td>\n",
       "      <td>62.0</td>\n",
       "      <td>43.2</td>\n",
       "      <td>29.8</td>\n",
       "      <td>2.5</td>\n",
       "      <td>4.3</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.55</td>\n",
       "      <td>3.95</td>\n",
       "      <td>0.0</td>\n",
       "      <td>70.2</td>\n",
       "      <td>39.8</td>\n",
       "      <td>93.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>29.913</td>\n",
       "      <td>29.734</td>\n",
       "      <td>13.8</td>\n",
       "      <td>18.4</td>\n",
       "      <td>77.5</td>\n",
       "      <td>0.1790</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3866</th>\n",
       "      <td>2033-06-23</td>\n",
       "      <td>58.8</td>\n",
       "      <td>64.0</td>\n",
       "      <td>45.1</td>\n",
       "      <td>29.8</td>\n",
       "      <td>2.4</td>\n",
       "      <td>3.9</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.63</td>\n",
       "      <td>4.03</td>\n",
       "      <td>0.0</td>\n",
       "      <td>75.6</td>\n",
       "      <td>42.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>29.930</td>\n",
       "      <td>29.733</td>\n",
       "      <td>17.3</td>\n",
       "      <td>21.9</td>\n",
       "      <td>77.4</td>\n",
       "      <td>0.1970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3867</th>\n",
       "      <td>2033-06-24</td>\n",
       "      <td>59.7</td>\n",
       "      <td>63.0</td>\n",
       "      <td>44.1</td>\n",
       "      <td>29.7</td>\n",
       "      <td>2.8</td>\n",
       "      <td>4.5</td>\n",
       "      <td>313.0</td>\n",
       "      <td>0.73</td>\n",
       "      <td>4.13</td>\n",
       "      <td>0.0</td>\n",
       "      <td>81.4</td>\n",
       "      <td>40.7</td>\n",
       "      <td>96.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>29.787</td>\n",
       "      <td>29.641</td>\n",
       "      <td>15.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>79.9</td>\n",
       "      <td>0.1460</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3868</th>\n",
       "      <td>2033-06-25</td>\n",
       "      <td>62.6</td>\n",
       "      <td>50.0</td>\n",
       "      <td>38.9</td>\n",
       "      <td>29.6</td>\n",
       "      <td>3.9</td>\n",
       "      <td>6.2</td>\n",
       "      <td>242.0</td>\n",
       "      <td>0.73</td>\n",
       "      <td>4.13</td>\n",
       "      <td>0.0</td>\n",
       "      <td>81.8</td>\n",
       "      <td>40.7</td>\n",
       "      <td>95.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>29.731</td>\n",
       "      <td>29.599</td>\n",
       "      <td>24.2</td>\n",
       "      <td>33.4</td>\n",
       "      <td>79.6</td>\n",
       "      <td>0.1320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3869</th>\n",
       "      <td>2033-06-26</td>\n",
       "      <td>57.8</td>\n",
       "      <td>66.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>29.7</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.8</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.74</td>\n",
       "      <td>4.14</td>\n",
       "      <td>0.0</td>\n",
       "      <td>72.5</td>\n",
       "      <td>44.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>29.809</td>\n",
       "      <td>29.660</td>\n",
       "      <td>17.3</td>\n",
       "      <td>27.6</td>\n",
       "      <td>77.4</td>\n",
       "      <td>0.1490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3870</th>\n",
       "      <td>2033-06-27</td>\n",
       "      <td>64.5</td>\n",
       "      <td>36.0</td>\n",
       "      <td>35.1</td>\n",
       "      <td>29.6</td>\n",
       "      <td>5.6</td>\n",
       "      <td>8.8</td>\n",
       "      <td>238.0</td>\n",
       "      <td>0.74</td>\n",
       "      <td>4.14</td>\n",
       "      <td>0.0</td>\n",
       "      <td>78.5</td>\n",
       "      <td>47.4</td>\n",
       "      <td>78.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>29.762</td>\n",
       "      <td>29.406</td>\n",
       "      <td>21.9</td>\n",
       "      <td>33.4</td>\n",
       "      <td>77.8</td>\n",
       "      <td>0.3560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3871</th>\n",
       "      <td>2033-06-28</td>\n",
       "      <td>66.1</td>\n",
       "      <td>34.0</td>\n",
       "      <td>36.1</td>\n",
       "      <td>29.3</td>\n",
       "      <td>5.5</td>\n",
       "      <td>8.8</td>\n",
       "      <td>234.0</td>\n",
       "      <td>0.74</td>\n",
       "      <td>4.14</td>\n",
       "      <td>0.0</td>\n",
       "      <td>76.3</td>\n",
       "      <td>49.6</td>\n",
       "      <td>58.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>29.406</td>\n",
       "      <td>29.222</td>\n",
       "      <td>19.6</td>\n",
       "      <td>33.4</td>\n",
       "      <td>77.4</td>\n",
       "      <td>0.1840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3872</th>\n",
       "      <td>2033-06-29</td>\n",
       "      <td>65.3</td>\n",
       "      <td>38.0</td>\n",
       "      <td>34.7</td>\n",
       "      <td>29.3</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.5</td>\n",
       "      <td>243.0</td>\n",
       "      <td>0.74</td>\n",
       "      <td>4.14</td>\n",
       "      <td>0.0</td>\n",
       "      <td>86.2</td>\n",
       "      <td>42.7</td>\n",
       "      <td>81.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>29.351</td>\n",
       "      <td>29.214</td>\n",
       "      <td>19.6</td>\n",
       "      <td>31.1</td>\n",
       "      <td>82.8</td>\n",
       "      <td>0.1370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3873</th>\n",
       "      <td>2033-06-30</td>\n",
       "      <td>58.6</td>\n",
       "      <td>34.0</td>\n",
       "      <td>28.3</td>\n",
       "      <td>29.4</td>\n",
       "      <td>10.6</td>\n",
       "      <td>16.0</td>\n",
       "      <td>237.0</td>\n",
       "      <td>0.74</td>\n",
       "      <td>4.14</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66.3</td>\n",
       "      <td>49.7</td>\n",
       "      <td>56.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>29.678</td>\n",
       "      <td>29.254</td>\n",
       "      <td>27.6</td>\n",
       "      <td>39.1</td>\n",
       "      <td>66.3</td>\n",
       "      <td>0.4240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3874</th>\n",
       "      <td>2033-07-01</td>\n",
       "      <td>59.9</td>\n",
       "      <td>33.0</td>\n",
       "      <td>26.7</td>\n",
       "      <td>29.7</td>\n",
       "      <td>4.2</td>\n",
       "      <td>7.1</td>\n",
       "      <td>217.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4.14</td>\n",
       "      <td>0.0</td>\n",
       "      <td>76.5</td>\n",
       "      <td>37.7</td>\n",
       "      <td>67.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>29.774</td>\n",
       "      <td>29.626</td>\n",
       "      <td>19.6</td>\n",
       "      <td>29.9</td>\n",
       "      <td>76.2</td>\n",
       "      <td>0.1480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3875</th>\n",
       "      <td>2033-07-02</td>\n",
       "      <td>64.2</td>\n",
       "      <td>34.0</td>\n",
       "      <td>29.5</td>\n",
       "      <td>29.7</td>\n",
       "      <td>3.9</td>\n",
       "      <td>6.3</td>\n",
       "      <td>233.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4.14</td>\n",
       "      <td>0.0</td>\n",
       "      <td>83.4</td>\n",
       "      <td>38.9</td>\n",
       "      <td>73.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>29.790</td>\n",
       "      <td>29.661</td>\n",
       "      <td>16.1</td>\n",
       "      <td>26.5</td>\n",
       "      <td>80.7</td>\n",
       "      <td>0.1290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3876</th>\n",
       "      <td>2033-07-03</td>\n",
       "      <td>67.4</td>\n",
       "      <td>37.0</td>\n",
       "      <td>37.7</td>\n",
       "      <td>29.7</td>\n",
       "      <td>3.6</td>\n",
       "      <td>6.1</td>\n",
       "      <td>348.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4.14</td>\n",
       "      <td>0.0</td>\n",
       "      <td>84.5</td>\n",
       "      <td>48.5</td>\n",
       "      <td>62.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>29.826</td>\n",
       "      <td>29.681</td>\n",
       "      <td>23.0</td>\n",
       "      <td>33.4</td>\n",
       "      <td>81.5</td>\n",
       "      <td>0.1450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3877</th>\n",
       "      <td>2033-07-04</td>\n",
       "      <td>62.2</td>\n",
       "      <td>55.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>29.7</td>\n",
       "      <td>3.9</td>\n",
       "      <td>6.1</td>\n",
       "      <td>306.0</td>\n",
       "      <td>0.03</td>\n",
       "      <td>4.17</td>\n",
       "      <td>0.0</td>\n",
       "      <td>85.6</td>\n",
       "      <td>49.6</td>\n",
       "      <td>81.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>29.800</td>\n",
       "      <td>29.662</td>\n",
       "      <td>25.3</td>\n",
       "      <td>39.1</td>\n",
       "      <td>82.5</td>\n",
       "      <td>0.1380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3878</th>\n",
       "      <td>2033-07-05</td>\n",
       "      <td>61.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>42.7</td>\n",
       "      <td>29.8</td>\n",
       "      <td>2.1</td>\n",
       "      <td>3.5</td>\n",
       "      <td>290.0</td>\n",
       "      <td>0.08</td>\n",
       "      <td>4.22</td>\n",
       "      <td>0.0</td>\n",
       "      <td>82.5</td>\n",
       "      <td>40.6</td>\n",
       "      <td>93.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>29.819</td>\n",
       "      <td>29.744</td>\n",
       "      <td>15.0</td>\n",
       "      <td>21.9</td>\n",
       "      <td>80.3</td>\n",
       "      <td>0.0750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3879</th>\n",
       "      <td>2033-07-06</td>\n",
       "      <td>65.1</td>\n",
       "      <td>45.0</td>\n",
       "      <td>38.5</td>\n",
       "      <td>29.7</td>\n",
       "      <td>2.7</td>\n",
       "      <td>4.6</td>\n",
       "      <td>206.0</td>\n",
       "      <td>0.08</td>\n",
       "      <td>4.22</td>\n",
       "      <td>0.0</td>\n",
       "      <td>84.9</td>\n",
       "      <td>42.9</td>\n",
       "      <td>88.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>29.771</td>\n",
       "      <td>29.658</td>\n",
       "      <td>16.1</td>\n",
       "      <td>23.0</td>\n",
       "      <td>81.8</td>\n",
       "      <td>0.1130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3880</th>\n",
       "      <td>2033-07-07</td>\n",
       "      <td>68.6</td>\n",
       "      <td>29.0</td>\n",
       "      <td>28.4</td>\n",
       "      <td>29.6</td>\n",
       "      <td>4.9</td>\n",
       "      <td>7.6</td>\n",
       "      <td>222.0</td>\n",
       "      <td>0.08</td>\n",
       "      <td>4.22</td>\n",
       "      <td>0.0</td>\n",
       "      <td>86.3</td>\n",
       "      <td>44.2</td>\n",
       "      <td>68.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>29.676</td>\n",
       "      <td>29.454</td>\n",
       "      <td>20.7</td>\n",
       "      <td>32.2</td>\n",
       "      <td>82.9</td>\n",
       "      <td>0.2220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3881</th>\n",
       "      <td>2033-07-08</td>\n",
       "      <td>65.5</td>\n",
       "      <td>19.0</td>\n",
       "      <td>17.3</td>\n",
       "      <td>29.5</td>\n",
       "      <td>4.4</td>\n",
       "      <td>7.0</td>\n",
       "      <td>246.0</td>\n",
       "      <td>0.08</td>\n",
       "      <td>4.22</td>\n",
       "      <td>0.0</td>\n",
       "      <td>84.7</td>\n",
       "      <td>39.1</td>\n",
       "      <td>44.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>29.629</td>\n",
       "      <td>29.502</td>\n",
       "      <td>18.4</td>\n",
       "      <td>28.8</td>\n",
       "      <td>81.7</td>\n",
       "      <td>0.1270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3882</th>\n",
       "      <td>2033-07-09</td>\n",
       "      <td>64.1</td>\n",
       "      <td>33.0</td>\n",
       "      <td>30.8</td>\n",
       "      <td>29.7</td>\n",
       "      <td>3.1</td>\n",
       "      <td>5.1</td>\n",
       "      <td>40.0</td>\n",
       "      <td>0.08</td>\n",
       "      <td>4.22</td>\n",
       "      <td>0.0</td>\n",
       "      <td>84.8</td>\n",
       "      <td>40.4</td>\n",
       "      <td>69.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>29.740</td>\n",
       "      <td>29.609</td>\n",
       "      <td>16.1</td>\n",
       "      <td>26.5</td>\n",
       "      <td>81.7</td>\n",
       "      <td>0.1310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3883</th>\n",
       "      <td>2033-07-10</td>\n",
       "      <td>68.7</td>\n",
       "      <td>32.0</td>\n",
       "      <td>24.3</td>\n",
       "      <td>29.8</td>\n",
       "      <td>3.6</td>\n",
       "      <td>6.0</td>\n",
       "      <td>253.0</td>\n",
       "      <td>0.08</td>\n",
       "      <td>4.22</td>\n",
       "      <td>0.0</td>\n",
       "      <td>90.7</td>\n",
       "      <td>43.1</td>\n",
       "      <td>84.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>29.821</td>\n",
       "      <td>29.713</td>\n",
       "      <td>20.7</td>\n",
       "      <td>27.6</td>\n",
       "      <td>86.6</td>\n",
       "      <td>0.1080</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3884</th>\n",
       "      <td>2033-07-11</td>\n",
       "      <td>67.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>32.8</td>\n",
       "      <td>29.8</td>\n",
       "      <td>2.6</td>\n",
       "      <td>4.6</td>\n",
       "      <td>71.0</td>\n",
       "      <td>0.08</td>\n",
       "      <td>4.22</td>\n",
       "      <td>0.0</td>\n",
       "      <td>83.9</td>\n",
       "      <td>44.8</td>\n",
       "      <td>43.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>29.902</td>\n",
       "      <td>29.751</td>\n",
       "      <td>13.8</td>\n",
       "      <td>18.4</td>\n",
       "      <td>81.2</td>\n",
       "      <td>0.1510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3885</th>\n",
       "      <td>2033-07-12</td>\n",
       "      <td>68.3</td>\n",
       "      <td>34.0</td>\n",
       "      <td>35.6</td>\n",
       "      <td>29.7</td>\n",
       "      <td>5.1</td>\n",
       "      <td>8.1</td>\n",
       "      <td>237.0</td>\n",
       "      <td>0.08</td>\n",
       "      <td>4.22</td>\n",
       "      <td>0.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>29.778</td>\n",
       "      <td>29.572</td>\n",
       "      <td>19.6</td>\n",
       "      <td>33.4</td>\n",
       "      <td>81.1</td>\n",
       "      <td>0.2060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3886</th>\n",
       "      <td>2033-07-13</td>\n",
       "      <td>73.4</td>\n",
       "      <td>29.0</td>\n",
       "      <td>38.3</td>\n",
       "      <td>29.5</td>\n",
       "      <td>7.4</td>\n",
       "      <td>11.6</td>\n",
       "      <td>235.0</td>\n",
       "      <td>0.08</td>\n",
       "      <td>4.22</td>\n",
       "      <td>0.0</td>\n",
       "      <td>85.5</td>\n",
       "      <td>64.4</td>\n",
       "      <td>45.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>29.575</td>\n",
       "      <td>29.374</td>\n",
       "      <td>26.5</td>\n",
       "      <td>41.4</td>\n",
       "      <td>82.3</td>\n",
       "      <td>0.2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3887</th>\n",
       "      <td>2033-07-14</td>\n",
       "      <td>62.4</td>\n",
       "      <td>56.0</td>\n",
       "      <td>45.2</td>\n",
       "      <td>29.5</td>\n",
       "      <td>3.2</td>\n",
       "      <td>5.2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.10</td>\n",
       "      <td>4.24</td>\n",
       "      <td>0.0</td>\n",
       "      <td>78.2</td>\n",
       "      <td>53.5</td>\n",
       "      <td>88.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>29.700</td>\n",
       "      <td>29.434</td>\n",
       "      <td>17.3</td>\n",
       "      <td>26.5</td>\n",
       "      <td>78.3</td>\n",
       "      <td>0.2660</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3888</th>\n",
       "      <td>2033-07-15</td>\n",
       "      <td>62.3</td>\n",
       "      <td>65.0</td>\n",
       "      <td>49.6</td>\n",
       "      <td>29.7</td>\n",
       "      <td>3.3</td>\n",
       "      <td>6.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>0.10</td>\n",
       "      <td>4.24</td>\n",
       "      <td>0.0</td>\n",
       "      <td>73.3</td>\n",
       "      <td>47.7</td>\n",
       "      <td>91.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>29.799</td>\n",
       "      <td>29.651</td>\n",
       "      <td>13.8</td>\n",
       "      <td>19.6</td>\n",
       "      <td>77.5</td>\n",
       "      <td>0.1480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3889</th>\n",
       "      <td>2033-07-16</td>\n",
       "      <td>65.7</td>\n",
       "      <td>63.0</td>\n",
       "      <td>52.8</td>\n",
       "      <td>29.7</td>\n",
       "      <td>2.3</td>\n",
       "      <td>4.6</td>\n",
       "      <td>93.0</td>\n",
       "      <td>0.10</td>\n",
       "      <td>4.24</td>\n",
       "      <td>0.0</td>\n",
       "      <td>65.7</td>\n",
       "      <td>65.7</td>\n",
       "      <td>63.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>29.746</td>\n",
       "      <td>29.746</td>\n",
       "      <td>2.3</td>\n",
       "      <td>4.6</td>\n",
       "      <td>65.7</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3890</th>\n",
       "      <td>2033-07-17</td>\n",
       "      <td>65.7</td>\n",
       "      <td>63.0</td>\n",
       "      <td>52.8</td>\n",
       "      <td>29.7</td>\n",
       "      <td>2.3</td>\n",
       "      <td>4.6</td>\n",
       "      <td>79.0</td>\n",
       "      <td>0.10</td>\n",
       "      <td>4.24</td>\n",
       "      <td>0.0</td>\n",
       "      <td>65.7</td>\n",
       "      <td>65.7</td>\n",
       "      <td>63.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>29.746</td>\n",
       "      <td>29.746</td>\n",
       "      <td>2.3</td>\n",
       "      <td>4.6</td>\n",
       "      <td>65.7</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3891</th>\n",
       "      <td>2033-07-18</td>\n",
       "      <td>76.3</td>\n",
       "      <td>24.0</td>\n",
       "      <td>35.5</td>\n",
       "      <td>29.6</td>\n",
       "      <td>7.3</td>\n",
       "      <td>11.4</td>\n",
       "      <td>236.0</td>\n",
       "      <td>0.10</td>\n",
       "      <td>4.24</td>\n",
       "      <td>0.0</td>\n",
       "      <td>87.2</td>\n",
       "      <td>61.2</td>\n",
       "      <td>63.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>29.746</td>\n",
       "      <td>29.537</td>\n",
       "      <td>19.6</td>\n",
       "      <td>31.1</td>\n",
       "      <td>83.6</td>\n",
       "      <td>0.2090</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3892</th>\n",
       "      <td>2033-07-19</td>\n",
       "      <td>66.6</td>\n",
       "      <td>38.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>29.6</td>\n",
       "      <td>3.7</td>\n",
       "      <td>5.7</td>\n",
       "      <td>226.0</td>\n",
       "      <td>0.12</td>\n",
       "      <td>4.26</td>\n",
       "      <td>0.0</td>\n",
       "      <td>80.9</td>\n",
       "      <td>50.2</td>\n",
       "      <td>64.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>29.679</td>\n",
       "      <td>29.602</td>\n",
       "      <td>18.4</td>\n",
       "      <td>25.3</td>\n",
       "      <td>79.1</td>\n",
       "      <td>0.0770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3893</th>\n",
       "      <td>2033-07-20</td>\n",
       "      <td>70.1</td>\n",
       "      <td>35.0</td>\n",
       "      <td>37.4</td>\n",
       "      <td>29.6</td>\n",
       "      <td>4.9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>293.0</td>\n",
       "      <td>0.12</td>\n",
       "      <td>4.26</td>\n",
       "      <td>0.0</td>\n",
       "      <td>85.4</td>\n",
       "      <td>54.4</td>\n",
       "      <td>74.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>29.650</td>\n",
       "      <td>29.505</td>\n",
       "      <td>17.3</td>\n",
       "      <td>27.6</td>\n",
       "      <td>82.3</td>\n",
       "      <td>0.1450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3894</th>\n",
       "      <td>2033-07-21</td>\n",
       "      <td>65.3</td>\n",
       "      <td>60.0</td>\n",
       "      <td>49.8</td>\n",
       "      <td>29.6</td>\n",
       "      <td>3.7</td>\n",
       "      <td>6.3</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.12</td>\n",
       "      <td>4.26</td>\n",
       "      <td>0.0</td>\n",
       "      <td>79.2</td>\n",
       "      <td>46.8</td>\n",
       "      <td>88.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>29.710</td>\n",
       "      <td>29.568</td>\n",
       "      <td>13.8</td>\n",
       "      <td>19.6</td>\n",
       "      <td>79.5</td>\n",
       "      <td>0.1420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3895</th>\n",
       "      <td>2033-07-22</td>\n",
       "      <td>65.4</td>\n",
       "      <td>52.0</td>\n",
       "      <td>42.7</td>\n",
       "      <td>29.6</td>\n",
       "      <td>4.2</td>\n",
       "      <td>6.7</td>\n",
       "      <td>230.0</td>\n",
       "      <td>0.12</td>\n",
       "      <td>4.26</td>\n",
       "      <td>0.0</td>\n",
       "      <td>85.9</td>\n",
       "      <td>46.9</td>\n",
       "      <td>93.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>29.707</td>\n",
       "      <td>29.583</td>\n",
       "      <td>16.1</td>\n",
       "      <td>25.3</td>\n",
       "      <td>82.6</td>\n",
       "      <td>0.1240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3896</th>\n",
       "      <td>2033-07-23</td>\n",
       "      <td>67.1</td>\n",
       "      <td>48.0</td>\n",
       "      <td>45.2</td>\n",
       "      <td>29.6</td>\n",
       "      <td>5.3</td>\n",
       "      <td>8.6</td>\n",
       "      <td>228.0</td>\n",
       "      <td>0.23</td>\n",
       "      <td>4.37</td>\n",
       "      <td>0.0</td>\n",
       "      <td>81.1</td>\n",
       "      <td>54.8</td>\n",
       "      <td>87.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>29.668</td>\n",
       "      <td>29.571</td>\n",
       "      <td>19.6</td>\n",
       "      <td>24.2</td>\n",
       "      <td>79.7</td>\n",
       "      <td>0.0970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3897</th>\n",
       "      <td>2033-07-24</td>\n",
       "      <td>64.1</td>\n",
       "      <td>62.0</td>\n",
       "      <td>49.8</td>\n",
       "      <td>29.6</td>\n",
       "      <td>3.6</td>\n",
       "      <td>5.8</td>\n",
       "      <td>240.0</td>\n",
       "      <td>0.24</td>\n",
       "      <td>4.38</td>\n",
       "      <td>0.0</td>\n",
       "      <td>74.9</td>\n",
       "      <td>55.3</td>\n",
       "      <td>86.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>29.686</td>\n",
       "      <td>29.577</td>\n",
       "      <td>15.0</td>\n",
       "      <td>25.3</td>\n",
       "      <td>77.4</td>\n",
       "      <td>0.1090</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3898</th>\n",
       "      <td>2033-07-25</td>\n",
       "      <td>62.8</td>\n",
       "      <td>60.0</td>\n",
       "      <td>48.1</td>\n",
       "      <td>29.7</td>\n",
       "      <td>2.5</td>\n",
       "      <td>4.0</td>\n",
       "      <td>242.0</td>\n",
       "      <td>0.33</td>\n",
       "      <td>4.47</td>\n",
       "      <td>0.0</td>\n",
       "      <td>69.2</td>\n",
       "      <td>55.1</td>\n",
       "      <td>90.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>29.781</td>\n",
       "      <td>29.645</td>\n",
       "      <td>8.1</td>\n",
       "      <td>17.3</td>\n",
       "      <td>77.5</td>\n",
       "      <td>0.1360</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3899</th>\n",
       "      <td>2033-07-26</td>\n",
       "      <td>60.6</td>\n",
       "      <td>68.0</td>\n",
       "      <td>48.9</td>\n",
       "      <td>29.8</td>\n",
       "      <td>1.7</td>\n",
       "      <td>2.9</td>\n",
       "      <td>357.0</td>\n",
       "      <td>0.33</td>\n",
       "      <td>4.47</td>\n",
       "      <td>0.0</td>\n",
       "      <td>71.9</td>\n",
       "      <td>50.5</td>\n",
       "      <td>90.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>29.930</td>\n",
       "      <td>29.745</td>\n",
       "      <td>11.5</td>\n",
       "      <td>15.0</td>\n",
       "      <td>77.5</td>\n",
       "      <td>0.1850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3900</th>\n",
       "      <td>2033-07-27</td>\n",
       "      <td>61.7</td>\n",
       "      <td>64.0</td>\n",
       "      <td>47.4</td>\n",
       "      <td>29.9</td>\n",
       "      <td>2.2</td>\n",
       "      <td>4.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.33</td>\n",
       "      <td>4.47</td>\n",
       "      <td>0.0</td>\n",
       "      <td>77.3</td>\n",
       "      <td>43.6</td>\n",
       "      <td>96.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>29.941</td>\n",
       "      <td>29.781</td>\n",
       "      <td>13.8</td>\n",
       "      <td>18.4</td>\n",
       "      <td>78.2</td>\n",
       "      <td>0.1600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3901</th>\n",
       "      <td>2033-07-28</td>\n",
       "      <td>60.5</td>\n",
       "      <td>61.0</td>\n",
       "      <td>45.3</td>\n",
       "      <td>29.7</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.2</td>\n",
       "      <td>248.0</td>\n",
       "      <td>0.35</td>\n",
       "      <td>4.49</td>\n",
       "      <td>0.0</td>\n",
       "      <td>75.6</td>\n",
       "      <td>46.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>29.792</td>\n",
       "      <td>29.675</td>\n",
       "      <td>17.3</td>\n",
       "      <td>26.5</td>\n",
       "      <td>77.6</td>\n",
       "      <td>0.1170</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3902</th>\n",
       "      <td>2033-07-28</td>\n",
       "      <td>60.5</td>\n",
       "      <td>61.0</td>\n",
       "      <td>45.3</td>\n",
       "      <td>29.7</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.2</td>\n",
       "      <td>248.0</td>\n",
       "      <td>0.35</td>\n",
       "      <td>4.49</td>\n",
       "      <td>0.0</td>\n",
       "      <td>75.6</td>\n",
       "      <td>46.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>29.792</td>\n",
       "      <td>29.675</td>\n",
       "      <td>17.3</td>\n",
       "      <td>26.5</td>\n",
       "      <td>77.6</td>\n",
       "      <td>0.1170</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Date  Average_temperature  Average_humidity  Average_dewpoint  \\\n",
       "3853 2033-06-10                 51.9              40.0              27.6   \n",
       "3854 2033-06-11                 55.0              43.0              30.2   \n",
       "3855 2033-06-12                 61.5              39.0              31.7   \n",
       "3856 2033-06-13                 61.2              45.0              37.6   \n",
       "3857 2033-06-14                 65.7              26.0              25.6   \n",
       "3858 2033-06-15                 59.9              30.0              25.3   \n",
       "3859 2033-06-16                 65.3              28.0              27.2   \n",
       "3860 2033-06-17                 64.4              28.0              26.1   \n",
       "3861 2033-06-18                 53.2              56.0              36.6   \n",
       "3862 2033-06-19                 48.8              81.0              43.1   \n",
       "3863 2033-06-20                 56.3              49.0              31.2   \n",
       "3864 2033-06-21                 58.9              48.0              38.0   \n",
       "3865 2033-06-22                 57.1              62.0              43.2   \n",
       "3866 2033-06-23                 58.8              64.0              45.1   \n",
       "3867 2033-06-24                 59.7              63.0              44.1   \n",
       "3868 2033-06-25                 62.6              50.0              38.9   \n",
       "3869 2033-06-26                 57.8              66.0              46.0   \n",
       "3870 2033-06-27                 64.5              36.0              35.1   \n",
       "3871 2033-06-28                 66.1              34.0              36.1   \n",
       "3872 2033-06-29                 65.3              38.0              34.7   \n",
       "3873 2033-06-30                 58.6              34.0              28.3   \n",
       "3874 2033-07-01                 59.9              33.0              26.7   \n",
       "3875 2033-07-02                 64.2              34.0              29.5   \n",
       "3876 2033-07-03                 67.4              37.0              37.7   \n",
       "3877 2033-07-04                 62.2              55.0              44.0   \n",
       "3878 2033-07-05                 61.0              57.0              42.7   \n",
       "3879 2033-07-06                 65.1              45.0              38.5   \n",
       "3880 2033-07-07                 68.6              29.0              28.4   \n",
       "3881 2033-07-08                 65.5              19.0              17.3   \n",
       "3882 2033-07-09                 64.1              33.0              30.8   \n",
       "3883 2033-07-10                 68.7              32.0              24.3   \n",
       "3884 2033-07-11                 67.0              29.0              32.8   \n",
       "3885 2033-07-12                 68.3              34.0              35.6   \n",
       "3886 2033-07-13                 73.4              29.0              38.3   \n",
       "3887 2033-07-14                 62.4              56.0              45.2   \n",
       "3888 2033-07-15                 62.3              65.0              49.6   \n",
       "3889 2033-07-16                 65.7              63.0              52.8   \n",
       "3890 2033-07-17                 65.7              63.0              52.8   \n",
       "3891 2033-07-18                 76.3              24.0              35.5   \n",
       "3892 2033-07-19                 66.6              38.0              39.0   \n",
       "3893 2033-07-20                 70.1              35.0              37.4   \n",
       "3894 2033-07-21                 65.3              60.0              49.8   \n",
       "3895 2033-07-22                 65.4              52.0              42.7   \n",
       "3896 2033-07-23                 67.1              48.0              45.2   \n",
       "3897 2033-07-24                 64.1              62.0              49.8   \n",
       "3898 2033-07-25                 62.8              60.0              48.1   \n",
       "3899 2033-07-26                 60.6              68.0              48.9   \n",
       "3900 2033-07-27                 61.7              64.0              47.4   \n",
       "3901 2033-07-28                 60.5              61.0              45.3   \n",
       "3902 2033-07-28                 60.5              61.0              45.3   \n",
       "\n",
       "      Average_barometer  Average_windspeed  Average_gust_speed  \\\n",
       "3853               30.0                6.7                10.5   \n",
       "3854               30.1                2.4                 4.4   \n",
       "3855               30.0                2.9                 5.0   \n",
       "3856               29.7                3.8                 6.2   \n",
       "3857               29.5                8.0                11.7   \n",
       "3858               29.7                2.0                 3.6   \n",
       "3859               29.5                6.2                 9.6   \n",
       "3860               29.4                6.2                 9.5   \n",
       "3861               29.7                3.7                 6.5   \n",
       "3862               29.9                2.2                 3.8   \n",
       "3863               29.8                3.8                 6.3   \n",
       "3864               29.7                3.4                 5.4   \n",
       "3865               29.8                2.5                 4.3   \n",
       "3866               29.8                2.4                 3.9   \n",
       "3867               29.7                2.8                 4.5   \n",
       "3868               29.6                3.9                 6.2   \n",
       "3869               29.7                3.0                 4.8   \n",
       "3870               29.6                5.6                 8.8   \n",
       "3871               29.3                5.5                 8.8   \n",
       "3872               29.3                4.0                 6.5   \n",
       "3873               29.4               10.6                16.0   \n",
       "3874               29.7                4.2                 7.1   \n",
       "3875               29.7                3.9                 6.3   \n",
       "3876               29.7                3.6                 6.1   \n",
       "3877               29.7                3.9                 6.1   \n",
       "3878               29.8                2.1                 3.5   \n",
       "3879               29.7                2.7                 4.6   \n",
       "3880               29.6                4.9                 7.6   \n",
       "3881               29.5                4.4                 7.0   \n",
       "3882               29.7                3.1                 5.1   \n",
       "3883               29.8                3.6                 6.0   \n",
       "3884               29.8                2.6                 4.6   \n",
       "3885               29.7                5.1                 8.1   \n",
       "3886               29.5                7.4                11.6   \n",
       "3887               29.5                3.2                 5.2   \n",
       "3888               29.7                3.3                 6.0   \n",
       "3889               29.7                2.3                 4.6   \n",
       "3890               29.7                2.3                 4.6   \n",
       "3891               29.6                7.3                11.4   \n",
       "3892               29.6                3.7                 5.7   \n",
       "3893               29.6                4.9                 8.0   \n",
       "3894               29.6                3.7                 6.3   \n",
       "3895               29.6                4.2                 6.7   \n",
       "3896               29.6                5.3                 8.6   \n",
       "3897               29.6                3.6                 5.8   \n",
       "3898               29.7                2.5                 4.0   \n",
       "3899               29.8                1.7                 2.9   \n",
       "3900               29.9                2.2                 4.0   \n",
       "3901               29.7                4.0                 6.2   \n",
       "3902               29.7                4.0                 6.2   \n",
       "\n",
       "      Average_direction_degree  Rainfall_for_month  Rainfall_for_year  \\\n",
       "3853                     239.0                0.15               3.55   \n",
       "3854                     129.0                0.15               3.55   \n",
       "3855                      75.0                0.15               3.55   \n",
       "3856                     255.0                0.20               3.60   \n",
       "3857                     226.0                0.20               3.60   \n",
       "3858                     297.0                0.20               3.60   \n",
       "3859                     245.0                0.20               3.60   \n",
       "3860                     251.0                0.20               3.60   \n",
       "3861                      72.0                0.27               3.67   \n",
       "3862                      48.0                0.52               3.92   \n",
       "3863                     252.0                0.53               3.93   \n",
       "3864                     252.0                0.55               3.95   \n",
       "3865                      16.0                0.55               3.95   \n",
       "3866                      18.0                0.63               4.03   \n",
       "3867                     313.0                0.73               4.13   \n",
       "3868                     242.0                0.73               4.13   \n",
       "3869                      13.0                0.74               4.14   \n",
       "3870                     238.0                0.74               4.14   \n",
       "3871                     234.0                0.74               4.14   \n",
       "3872                     243.0                0.74               4.14   \n",
       "3873                     237.0                0.74               4.14   \n",
       "3874                     217.0                0.00               4.14   \n",
       "3875                     233.0                0.00               4.14   \n",
       "3876                     348.0                0.00               4.14   \n",
       "3877                     306.0                0.03               4.17   \n",
       "3878                     290.0                0.08               4.22   \n",
       "3879                     206.0                0.08               4.22   \n",
       "3880                     222.0                0.08               4.22   \n",
       "3881                     246.0                0.08               4.22   \n",
       "3882                      40.0                0.08               4.22   \n",
       "3883                     253.0                0.08               4.22   \n",
       "3884                      71.0                0.08               4.22   \n",
       "3885                     237.0                0.08               4.22   \n",
       "3886                     235.0                0.08               4.22   \n",
       "3887                       2.0                0.10               4.24   \n",
       "3888                      67.0                0.10               4.24   \n",
       "3889                      93.0                0.10               4.24   \n",
       "3890                      79.0                0.10               4.24   \n",
       "3891                     236.0                0.10               4.24   \n",
       "3892                     226.0                0.12               4.26   \n",
       "3893                     293.0                0.12               4.26   \n",
       "3894                      38.0                0.12               4.26   \n",
       "3895                     230.0                0.12               4.26   \n",
       "3896                     228.0                0.23               4.37   \n",
       "3897                     240.0                0.24               4.38   \n",
       "3898                     242.0                0.33               4.47   \n",
       "3899                     357.0                0.33               4.47   \n",
       "3900                      66.0                0.33               4.47   \n",
       "3901                     248.0                0.35               4.49   \n",
       "3902                     248.0                0.35               4.49   \n",
       "\n",
       "      Maximum_rain_per_minute  Maximum_temperature  Minimum_temperature  \\\n",
       "3853                      0.0                 64.4                 44.8   \n",
       "3854                      0.0                 71.3                 32.6   \n",
       "3855                      0.0                 80.7                 36.0   \n",
       "3856                      0.0                 80.2                 41.1   \n",
       "3857                      0.0                 78.7                 49.3   \n",
       "3858                      0.0                 82.4                 39.2   \n",
       "3859                      0.0                 81.5                 40.8   \n",
       "3860                      0.0                 82.0                 42.6   \n",
       "3861                      0.0                 62.3                 44.4   \n",
       "3862                      0.0                 56.3                 41.6   \n",
       "3863                      0.0                 77.6                 32.2   \n",
       "3864                      0.0                 71.5                 47.7   \n",
       "3865                      0.0                 70.2                 39.8   \n",
       "3866                      0.0                 75.6                 42.0   \n",
       "3867                      0.0                 81.4                 40.7   \n",
       "3868                      0.0                 81.8                 40.7   \n",
       "3869                      0.0                 72.5                 44.0   \n",
       "3870                      0.0                 78.5                 47.4   \n",
       "3871                      0.0                 76.3                 49.6   \n",
       "3872                      0.0                 86.2                 42.7   \n",
       "3873                      0.0                 66.3                 49.7   \n",
       "3874                      0.0                 76.5                 37.7   \n",
       "3875                      0.0                 83.4                 38.9   \n",
       "3876                      0.0                 84.5                 48.5   \n",
       "3877                      0.0                 85.6                 49.6   \n",
       "3878                      0.0                 82.5                 40.6   \n",
       "3879                      0.0                 84.9                 42.9   \n",
       "3880                      0.0                 86.3                 44.2   \n",
       "3881                      0.0                 84.7                 39.1   \n",
       "3882                      0.0                 84.8                 40.4   \n",
       "3883                      0.0                 90.7                 43.1   \n",
       "3884                      0.0                 83.9                 44.8   \n",
       "3885                      0.0                 84.0                 46.0   \n",
       "3886                      0.0                 85.5                 64.4   \n",
       "3887                      0.0                 78.2                 53.5   \n",
       "3888                      0.0                 73.3                 47.7   \n",
       "3889                      0.0                 65.7                 65.7   \n",
       "3890                      0.0                 65.7                 65.7   \n",
       "3891                      0.0                 87.2                 61.2   \n",
       "3892                      0.0                 80.9                 50.2   \n",
       "3893                      0.0                 85.4                 54.4   \n",
       "3894                      0.0                 79.2                 46.8   \n",
       "3895                      0.0                 85.9                 46.9   \n",
       "3896                      0.0                 81.1                 54.8   \n",
       "3897                      0.0                 74.9                 55.3   \n",
       "3898                      0.0                 69.2                 55.1   \n",
       "3899                      0.0                 71.9                 50.5   \n",
       "3900                      0.0                 77.3                 43.6   \n",
       "3901                      0.0                 75.6                 46.0   \n",
       "3902                      0.0                 75.6                 46.0   \n",
       "\n",
       "      Maximum_humidity  Minimum_humidity  Maximum_pressure  Minimum_pressure  \\\n",
       "3853              52.0              24.0            30.017            29.859   \n",
       "3854              80.0              18.0            30.137            30.005   \n",
       "3855              80.0              12.0            30.137            29.826   \n",
       "3856              77.0              16.0            29.838            29.545   \n",
       "3857              55.0               9.0            29.592            29.446   \n",
       "3858              54.0              10.0            29.796            29.598   \n",
       "3859              63.0              14.0            29.688            29.397   \n",
       "3860              58.0               9.0            29.517            29.404   \n",
       "3861              91.0              35.0            29.873            29.518   \n",
       "3862              94.0              63.0            29.898            29.804   \n",
       "3863              96.0              13.0            29.941            29.752   \n",
       "3864              78.0              24.0            29.753            29.608   \n",
       "3865              93.0              38.0            29.913            29.734   \n",
       "3866              92.0              31.0            29.930            29.733   \n",
       "3867              96.0              22.0            29.787            29.641   \n",
       "3868              95.0              16.0            29.731            29.599   \n",
       "3869              87.0              42.0            29.809            29.660   \n",
       "3870              78.0              17.0            29.762            29.406   \n",
       "3871              58.0              23.0            29.406            29.222   \n",
       "3872              81.0              13.0            29.351            29.214   \n",
       "3873              56.0              16.0            29.678            29.254   \n",
       "3874              67.0              11.0            29.774            29.626   \n",
       "3875              73.0              10.0            29.790            29.661   \n",
       "3876              62.0              14.0            29.826            29.681   \n",
       "3877              81.0              19.0            29.800            29.662   \n",
       "3878              93.0              21.0            29.819            29.744   \n",
       "3879              88.0              12.0            29.771            29.658   \n",
       "3880              68.0               9.0            29.676            29.454   \n",
       "3881              44.0               7.0            29.629            29.502   \n",
       "3882              69.0               8.0            29.740            29.609   \n",
       "3883              84.0               5.0            29.821            29.713   \n",
       "3884              43.0              18.0            29.902            29.751   \n",
       "3885              69.0              11.0            29.778            29.572   \n",
       "3886              45.0              17.0            29.575            29.374   \n",
       "3887              88.0              27.0            29.700            29.434   \n",
       "3888              91.0              29.0            29.799            29.651   \n",
       "3889              63.0              63.0            29.746            29.746   \n",
       "3890              63.0              63.0            29.746            29.746   \n",
       "3891              63.0              10.0            29.746            29.537   \n",
       "3892              64.0              16.0            29.679            29.602   \n",
       "3893              74.0               9.0            29.650            29.505   \n",
       "3894              88.0              31.0            29.710            29.568   \n",
       "3895              93.0              14.0            29.707            29.583   \n",
       "3896              87.0              26.0            29.668            29.571   \n",
       "3897              86.0              35.0            29.686            29.577   \n",
       "3898              90.0              36.0            29.781            29.645   \n",
       "3899              90.0              40.0            29.930            29.745   \n",
       "3900              96.0              35.0            29.941            29.781   \n",
       "3901              94.0              35.0            29.792            29.675   \n",
       "3902              94.0              35.0            29.792            29.675   \n",
       "\n",
       "      Maximum_windspeed  Maximum_gust_speed  Maximum_heat_index  Diff_pressure  \n",
       "3853               18.4                33.4                64.4         0.1580  \n",
       "3854               12.7                17.3                76.0         0.1320  \n",
       "3855               13.8                20.7                79.0         0.3110  \n",
       "3856               19.6                32.2                78.6         0.2930  \n",
       "3857               28.8                40.3                77.3         0.1460  \n",
       "3858               11.5                19.6                79.9         0.1980  \n",
       "3859               19.6                28.8                79.3         0.2910  \n",
       "3860               19.6                26.5                79.6         0.1130  \n",
       "3861               12.7                19.6                62.3         0.3550  \n",
       "3862               20.7                31.1                56.3         0.0940  \n",
       "3863               18.4                24.2                76.7         0.1890  \n",
       "3864               13.8                29.9                77.0         0.1450  \n",
       "3865               13.8                18.4                77.5         0.1790  \n",
       "3866               17.3                21.9                77.4         0.1970  \n",
       "3867               15.0                23.0                79.9         0.1460  \n",
       "3868               24.2                33.4                79.6         0.1320  \n",
       "3869               17.3                27.6                77.4         0.1490  \n",
       "3870               21.9                33.4                77.8         0.3560  \n",
       "3871               19.6                33.4                77.4         0.1840  \n",
       "3872               19.6                31.1                82.8         0.1370  \n",
       "3873               27.6                39.1                66.3         0.4240  \n",
       "3874               19.6                29.9                76.2         0.1480  \n",
       "3875               16.1                26.5                80.7         0.1290  \n",
       "3876               23.0                33.4                81.5         0.1450  \n",
       "3877               25.3                39.1                82.5         0.1380  \n",
       "3878               15.0                21.9                80.3         0.0750  \n",
       "3879               16.1                23.0                81.8         0.1130  \n",
       "3880               20.7                32.2                82.9         0.2220  \n",
       "3881               18.4                28.8                81.7         0.1270  \n",
       "3882               16.1                26.5                81.7         0.1310  \n",
       "3883               20.7                27.6                86.6         0.1080  \n",
       "3884               13.8                18.4                81.2         0.1510  \n",
       "3885               19.6                33.4                81.1         0.2060  \n",
       "3886               26.5                41.4                82.3         0.2022  \n",
       "3887               17.3                26.5                78.3         0.2660  \n",
       "3888               13.8                19.6                77.5         0.1480  \n",
       "3889                2.3                 4.6                65.7         0.0000  \n",
       "3890                2.3                 4.6                65.7         0.0000  \n",
       "3891               19.6                31.1                83.6         0.2090  \n",
       "3892               18.4                25.3                79.1         0.0770  \n",
       "3893               17.3                27.6                82.3         0.1450  \n",
       "3894               13.8                19.6                79.5         0.1420  \n",
       "3895               16.1                25.3                82.6         0.1240  \n",
       "3896               19.6                24.2                79.7         0.0970  \n",
       "3897               15.0                25.3                77.4         0.1090  \n",
       "3898                8.1                17.3                77.5         0.1360  \n",
       "3899               11.5                15.0                77.5         0.1850  \n",
       "3900               13.8                18.4                78.2         0.1600  \n",
       "3901               17.3                26.5                77.6         0.1170  \n",
       "3902               17.3                26.5                77.6         0.1170  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "2bc79fed",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Average_temperature</th>\n",
       "      <th>Average_humidity</th>\n",
       "      <th>Average_dewpoint</th>\n",
       "      <th>Average_barometer</th>\n",
       "      <th>Average_windspeed</th>\n",
       "      <th>Average_gust_speed</th>\n",
       "      <th>Average_direction_degree</th>\n",
       "      <th>Rainfall_for_month</th>\n",
       "      <th>Rainfall_for_year</th>\n",
       "      <th>Maximum_rain_per_minute</th>\n",
       "      <th>Maximum_temperature</th>\n",
       "      <th>Minimum_temperature</th>\n",
       "      <th>Maximum_humidity</th>\n",
       "      <th>Minimum_humidity</th>\n",
       "      <th>Maximum_pressure</th>\n",
       "      <th>Minimum_pressure</th>\n",
       "      <th>Maximum_windspeed</th>\n",
       "      <th>Maximum_gust_speed</th>\n",
       "      <th>Maximum_heat_index</th>\n",
       "      <th>Diff_pressure</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Date, Average_temperature, Average_humidity, Average_dewpoint, Average_barometer, Average_windspeed, Average_gust_speed, Average_direction_degree, Rainfall_for_month, Rainfall_for_year, Maximum_rain_per_minute, Maximum_temperature, Minimum_temperature, Maximum_humidity, Minimum_humidity, Maximum_pressure, Minimum_pressure, Maximum_windspeed, Maximum_gust_speed, Maximum_heat_index, Diff_pressure]\n",
       "Index: []"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "random_date = '2024-02-29'\n",
    "rows = df.loc[df['Date'] == random_date]                        #to check for any uncommon values present \n",
    "rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "fb130ae5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0      2022-01-01\n",
       "1      2022-01-02\n",
       "2      2022-01-03\n",
       "3      2022-01-04\n",
       "4      2022-01-05\n",
       "          ...    \n",
       "3898   2033-07-25\n",
       "3899   2033-07-26\n",
       "3900   2033-07-27\n",
       "3901   2033-07-28\n",
       "3902   2033-07-28\n",
       "Name: Date, Length: 3903, dtype: datetime64[ns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Date']           #exploring date column"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ab31c217",
   "metadata": {},
   "source": [
    "### Handling Duplicates :"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "802b5871",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Average_temperature</th>\n",
       "      <th>Average_humidity</th>\n",
       "      <th>Average_dewpoint</th>\n",
       "      <th>Average_barometer</th>\n",
       "      <th>Average_windspeed</th>\n",
       "      <th>Average_gust_speed</th>\n",
       "      <th>Average_direction_degree</th>\n",
       "      <th>Rainfall_for_month</th>\n",
       "      <th>Rainfall_for_year</th>\n",
       "      <th>Maximum_rain_per_minute</th>\n",
       "      <th>Maximum_temperature</th>\n",
       "      <th>Minimum_temperature</th>\n",
       "      <th>Maximum_humidity</th>\n",
       "      <th>Minimum_humidity</th>\n",
       "      <th>Maximum_pressure</th>\n",
       "      <th>Minimum_pressure</th>\n",
       "      <th>Maximum_windspeed</th>\n",
       "      <th>Maximum_gust_speed</th>\n",
       "      <th>Maximum_heat_index</th>\n",
       "      <th>Diff_pressure</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3902</th>\n",
       "      <td>2033-07-28</td>\n",
       "      <td>60.5</td>\n",
       "      <td>61.0</td>\n",
       "      <td>45.3</td>\n",
       "      <td>29.7</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.2</td>\n",
       "      <td>248.0</td>\n",
       "      <td>0.35</td>\n",
       "      <td>4.49</td>\n",
       "      <td>0.0</td>\n",
       "      <td>75.6</td>\n",
       "      <td>46.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>29.792</td>\n",
       "      <td>29.675</td>\n",
       "      <td>17.3</td>\n",
       "      <td>26.5</td>\n",
       "      <td>77.6</td>\n",
       "      <td>0.117</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Date  Average_temperature  Average_humidity  Average_dewpoint  \\\n",
       "3902 2033-07-28                 60.5              61.0              45.3   \n",
       "\n",
       "      Average_barometer  Average_windspeed  Average_gust_speed  \\\n",
       "3902               29.7                4.0                 6.2   \n",
       "\n",
       "      Average_direction_degree  Rainfall_for_month  Rainfall_for_year  \\\n",
       "3902                     248.0                0.35               4.49   \n",
       "\n",
       "      Maximum_rain_per_minute  Maximum_temperature  Minimum_temperature  \\\n",
       "3902                      0.0                 75.6                 46.0   \n",
       "\n",
       "      Maximum_humidity  Minimum_humidity  Maximum_pressure  Minimum_pressure  \\\n",
       "3902              94.0              35.0            29.792            29.675   \n",
       "\n",
       "      Maximum_windspeed  Maximum_gust_speed  Maximum_heat_index  Diff_pressure  \n",
       "3902               17.3                26.5                77.6          0.117  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df.duplicated()] #to show duplicate records"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "acbf75e2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Average_temperature</th>\n",
       "      <th>Average_humidity</th>\n",
       "      <th>Average_dewpoint</th>\n",
       "      <th>Average_barometer</th>\n",
       "      <th>Average_windspeed</th>\n",
       "      <th>Average_gust_speed</th>\n",
       "      <th>Average_direction_degree</th>\n",
       "      <th>Rainfall_for_month</th>\n",
       "      <th>Rainfall_for_year</th>\n",
       "      <th>Maximum_rain_per_minute</th>\n",
       "      <th>Maximum_temperature</th>\n",
       "      <th>Minimum_temperature</th>\n",
       "      <th>Maximum_humidity</th>\n",
       "      <th>Minimum_humidity</th>\n",
       "      <th>Maximum_pressure</th>\n",
       "      <th>Minimum_pressure</th>\n",
       "      <th>Maximum_windspeed</th>\n",
       "      <th>Maximum_gust_speed</th>\n",
       "      <th>Maximum_heat_index</th>\n",
       "      <th>Diff_pressure</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3897</th>\n",
       "      <td>2033-07-24</td>\n",
       "      <td>64.1</td>\n",
       "      <td>62.0</td>\n",
       "      <td>49.8</td>\n",
       "      <td>29.6</td>\n",
       "      <td>3.6</td>\n",
       "      <td>5.8</td>\n",
       "      <td>240.0</td>\n",
       "      <td>0.24</td>\n",
       "      <td>4.38</td>\n",
       "      <td>0.0</td>\n",
       "      <td>74.9</td>\n",
       "      <td>55.3</td>\n",
       "      <td>86.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>29.686</td>\n",
       "      <td>29.577</td>\n",
       "      <td>15.0</td>\n",
       "      <td>25.3</td>\n",
       "      <td>77.4</td>\n",
       "      <td>0.109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3898</th>\n",
       "      <td>2033-07-25</td>\n",
       "      <td>62.8</td>\n",
       "      <td>60.0</td>\n",
       "      <td>48.1</td>\n",
       "      <td>29.7</td>\n",
       "      <td>2.5</td>\n",
       "      <td>4.0</td>\n",
       "      <td>242.0</td>\n",
       "      <td>0.33</td>\n",
       "      <td>4.47</td>\n",
       "      <td>0.0</td>\n",
       "      <td>69.2</td>\n",
       "      <td>55.1</td>\n",
       "      <td>90.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>29.781</td>\n",
       "      <td>29.645</td>\n",
       "      <td>8.1</td>\n",
       "      <td>17.3</td>\n",
       "      <td>77.5</td>\n",
       "      <td>0.136</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3899</th>\n",
       "      <td>2033-07-26</td>\n",
       "      <td>60.6</td>\n",
       "      <td>68.0</td>\n",
       "      <td>48.9</td>\n",
       "      <td>29.8</td>\n",
       "      <td>1.7</td>\n",
       "      <td>2.9</td>\n",
       "      <td>357.0</td>\n",
       "      <td>0.33</td>\n",
       "      <td>4.47</td>\n",
       "      <td>0.0</td>\n",
       "      <td>71.9</td>\n",
       "      <td>50.5</td>\n",
       "      <td>90.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>29.930</td>\n",
       "      <td>29.745</td>\n",
       "      <td>11.5</td>\n",
       "      <td>15.0</td>\n",
       "      <td>77.5</td>\n",
       "      <td>0.185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3900</th>\n",
       "      <td>2033-07-27</td>\n",
       "      <td>61.7</td>\n",
       "      <td>64.0</td>\n",
       "      <td>47.4</td>\n",
       "      <td>29.9</td>\n",
       "      <td>2.2</td>\n",
       "      <td>4.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.33</td>\n",
       "      <td>4.47</td>\n",
       "      <td>0.0</td>\n",
       "      <td>77.3</td>\n",
       "      <td>43.6</td>\n",
       "      <td>96.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>29.941</td>\n",
       "      <td>29.781</td>\n",
       "      <td>13.8</td>\n",
       "      <td>18.4</td>\n",
       "      <td>78.2</td>\n",
       "      <td>0.160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3901</th>\n",
       "      <td>2033-07-28</td>\n",
       "      <td>60.5</td>\n",
       "      <td>61.0</td>\n",
       "      <td>45.3</td>\n",
       "      <td>29.7</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.2</td>\n",
       "      <td>248.0</td>\n",
       "      <td>0.35</td>\n",
       "      <td>4.49</td>\n",
       "      <td>0.0</td>\n",
       "      <td>75.6</td>\n",
       "      <td>46.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>29.792</td>\n",
       "      <td>29.675</td>\n",
       "      <td>17.3</td>\n",
       "      <td>26.5</td>\n",
       "      <td>77.6</td>\n",
       "      <td>0.117</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Date  Average_temperature  Average_humidity  Average_dewpoint  \\\n",
       "3897 2033-07-24                 64.1              62.0              49.8   \n",
       "3898 2033-07-25                 62.8              60.0              48.1   \n",
       "3899 2033-07-26                 60.6              68.0              48.9   \n",
       "3900 2033-07-27                 61.7              64.0              47.4   \n",
       "3901 2033-07-28                 60.5              61.0              45.3   \n",
       "\n",
       "      Average_barometer  Average_windspeed  Average_gust_speed  \\\n",
       "3897               29.6                3.6                 5.8   \n",
       "3898               29.7                2.5                 4.0   \n",
       "3899               29.8                1.7                 2.9   \n",
       "3900               29.9                2.2                 4.0   \n",
       "3901               29.7                4.0                 6.2   \n",
       "\n",
       "      Average_direction_degree  Rainfall_for_month  Rainfall_for_year  \\\n",
       "3897                     240.0                0.24               4.38   \n",
       "3898                     242.0                0.33               4.47   \n",
       "3899                     357.0                0.33               4.47   \n",
       "3900                      66.0                0.33               4.47   \n",
       "3901                     248.0                0.35               4.49   \n",
       "\n",
       "      Maximum_rain_per_minute  Maximum_temperature  Minimum_temperature  \\\n",
       "3897                      0.0                 74.9                 55.3   \n",
       "3898                      0.0                 69.2                 55.1   \n",
       "3899                      0.0                 71.9                 50.5   \n",
       "3900                      0.0                 77.3                 43.6   \n",
       "3901                      0.0                 75.6                 46.0   \n",
       "\n",
       "      Maximum_humidity  Minimum_humidity  Maximum_pressure  Minimum_pressure  \\\n",
       "3897              86.0              35.0            29.686            29.577   \n",
       "3898              90.0              36.0            29.781            29.645   \n",
       "3899              90.0              40.0            29.930            29.745   \n",
       "3900              96.0              35.0            29.941            29.781   \n",
       "3901              94.0              35.0            29.792            29.675   \n",
       "\n",
       "      Maximum_windspeed  Maximum_gust_speed  Maximum_heat_index  Diff_pressure  \n",
       "3897               15.0                25.3                77.4          0.109  \n",
       "3898                8.1                17.3                77.5          0.136  \n",
       "3899               11.5                15.0                77.5          0.185  \n",
       "3900               13.8                18.4                78.2          0.160  \n",
       "3901               17.3                26.5                77.6          0.117  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#dropping all duplicates from df\n",
    "df.drop_duplicates(inplace=True)\n",
    "df.tail()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7f54db88",
   "metadata": {},
   "source": [
    "Here we have ssuccessfully dropped the duplicates!\n",
    "\n",
    "Now we will check for the leap year data "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "b54697da",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Average_temperature</th>\n",
       "      <th>Average_humidity</th>\n",
       "      <th>Average_dewpoint</th>\n",
       "      <th>Average_barometer</th>\n",
       "      <th>Average_windspeed</th>\n",
       "      <th>Average_gust_speed</th>\n",
       "      <th>Average_direction_degree</th>\n",
       "      <th>Rainfall_for_month</th>\n",
       "      <th>Rainfall_for_year</th>\n",
       "      <th>Maximum_rain_per_minute</th>\n",
       "      <th>Maximum_temperature</th>\n",
       "      <th>Minimum_temperature</th>\n",
       "      <th>Maximum_humidity</th>\n",
       "      <th>Minimum_humidity</th>\n",
       "      <th>Maximum_pressure</th>\n",
       "      <th>Minimum_pressure</th>\n",
       "      <th>Maximum_windspeed</th>\n",
       "      <th>Maximum_gust_speed</th>\n",
       "      <th>Maximum_heat_index</th>\n",
       "      <th>Diff_pressure</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Date, Average_temperature, Average_humidity, Average_dewpoint, Average_barometer, Average_windspeed, Average_gust_speed, Average_direction_degree, Rainfall_for_month, Rainfall_for_year, Maximum_rain_per_minute, Maximum_temperature, Minimum_temperature, Maximum_humidity, Minimum_humidity, Maximum_pressure, Minimum_pressure, Maximum_windspeed, Maximum_gust_speed, Maximum_heat_index, Diff_pressure]\n",
       "Index: []"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[(df['Date'].dt.month == 2) & (df['Date'].dt.day == 29)]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e31c157f",
   "metadata": {},
   "source": [
    "We will change format of date column to date-only."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "f9a66a70",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Date'].dtype\n",
    "df['Date'] = df['Date'].dt.date #to convert the datetime column to a date-only format"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "aade72a7",
   "metadata": {},
   "source": [
    "### Dealing with null values :"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "68e3570f",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date                        2\n",
       "Average_temperature         0\n",
       "Average_humidity            0\n",
       "Average_dewpoint            0\n",
       "Average_barometer           0\n",
       "Average_windspeed           0\n",
       "Average_gust_speed          0\n",
       "Average_direction_degree    0\n",
       "Rainfall_for_month          0\n",
       "Rainfall_for_year           0\n",
       "Maximum_rain_per_minute     0\n",
       "Maximum_temperature         0\n",
       "Minimum_temperature         0\n",
       "Maximum_humidity            0\n",
       "Minimum_humidity            0\n",
       "Maximum_pressure            0\n",
       "Minimum_pressure            0\n",
       "Maximum_windspeed           0\n",
       "Maximum_gust_speed          0\n",
       "Maximum_heat_index          0\n",
       "Diff_pressure               0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum()            #to check for null values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "3b5fcb8d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Average_temperature</th>\n",
       "      <th>Average_humidity</th>\n",
       "      <th>Average_dewpoint</th>\n",
       "      <th>Average_barometer</th>\n",
       "      <th>Average_windspeed</th>\n",
       "      <th>Average_gust_speed</th>\n",
       "      <th>Average_direction_degree</th>\n",
       "      <th>Rainfall_for_month</th>\n",
       "      <th>Rainfall_for_year</th>\n",
       "      <th>Maximum_rain_per_minute</th>\n",
       "      <th>Maximum_temperature</th>\n",
       "      <th>Minimum_temperature</th>\n",
       "      <th>Maximum_humidity</th>\n",
       "      <th>Minimum_humidity</th>\n",
       "      <th>Maximum_pressure</th>\n",
       "      <th>Minimum_pressure</th>\n",
       "      <th>Maximum_windspeed</th>\n",
       "      <th>Maximum_gust_speed</th>\n",
       "      <th>Maximum_heat_index</th>\n",
       "      <th>Diff_pressure</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2366</th>\n",
       "      <td>NaT</td>\n",
       "      <td>38.1</td>\n",
       "      <td>36.0</td>\n",
       "      <td>12.3</td>\n",
       "      <td>29.8</td>\n",
       "      <td>11.5</td>\n",
       "      <td>17.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>0.16</td>\n",
       "      <td>0.36</td>\n",
       "      <td>0.0</td>\n",
       "      <td>45.9</td>\n",
       "      <td>27.9</td>\n",
       "      <td>73.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>30.023</td>\n",
       "      <td>29.702</td>\n",
       "      <td>29.9</td>\n",
       "      <td>39.1</td>\n",
       "      <td>45.9</td>\n",
       "      <td>0.321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3751</th>\n",
       "      <td>NaT</td>\n",
       "      <td>37.6</td>\n",
       "      <td>31.0</td>\n",
       "      <td>8.7</td>\n",
       "      <td>29.8</td>\n",
       "      <td>8.0</td>\n",
       "      <td>11.6</td>\n",
       "      <td>236.0</td>\n",
       "      <td>0.48</td>\n",
       "      <td>0.49</td>\n",
       "      <td>0.0</td>\n",
       "      <td>48.1</td>\n",
       "      <td>26.1</td>\n",
       "      <td>57.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>29.972</td>\n",
       "      <td>29.647</td>\n",
       "      <td>19.6</td>\n",
       "      <td>31.1</td>\n",
       "      <td>48.1</td>\n",
       "      <td>0.325</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Date  Average_temperature  Average_humidity  Average_dewpoint  \\\n",
       "2366  NaT                 38.1              36.0              12.3   \n",
       "3751  NaT                 37.6              31.0               8.7   \n",
       "\n",
       "      Average_barometer  Average_windspeed  Average_gust_speed  \\\n",
       "2366               29.8               11.5                17.0   \n",
       "3751               29.8                8.0                11.6   \n",
       "\n",
       "      Average_direction_degree  Rainfall_for_month  Rainfall_for_year  \\\n",
       "2366                      77.0                0.16               0.36   \n",
       "3751                     236.0                0.48               0.49   \n",
       "\n",
       "      Maximum_rain_per_minute  Maximum_temperature  Minimum_temperature  \\\n",
       "2366                      0.0                 45.9                 27.9   \n",
       "3751                      0.0                 48.1                 26.1   \n",
       "\n",
       "      Maximum_humidity  Minimum_humidity  Maximum_pressure  Minimum_pressure  \\\n",
       "2366              73.0              22.0            30.023            29.702   \n",
       "3751              57.0              20.0            29.972            29.647   \n",
       "\n",
       "      Maximum_windspeed  Maximum_gust_speed  Maximum_heat_index  Diff_pressure  \n",
       "2366               29.9                39.1                45.9          0.321  \n",
       "3751               19.6                31.1                48.1          0.325  "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df.isna().any(axis=1)]            #exploring for null values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "53378338",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Average_temperature</th>\n",
       "      <th>Average_humidity</th>\n",
       "      <th>Average_dewpoint</th>\n",
       "      <th>Average_barometer</th>\n",
       "      <th>Average_windspeed</th>\n",
       "      <th>Average_gust_speed</th>\n",
       "      <th>Average_direction_degree</th>\n",
       "      <th>Rainfall_for_month</th>\n",
       "      <th>Rainfall_for_year</th>\n",
       "      <th>Maximum_rain_per_minute</th>\n",
       "      <th>Maximum_temperature</th>\n",
       "      <th>Minimum_temperature</th>\n",
       "      <th>Maximum_humidity</th>\n",
       "      <th>Minimum_humidity</th>\n",
       "      <th>Maximum_pressure</th>\n",
       "      <th>Minimum_pressure</th>\n",
       "      <th>Maximum_windspeed</th>\n",
       "      <th>Maximum_gust_speed</th>\n",
       "      <th>Maximum_heat_index</th>\n",
       "      <th>Diff_pressure</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2365</th>\n",
       "      <td>2029-02-28</td>\n",
       "      <td>42.2</td>\n",
       "      <td>25.0</td>\n",
       "      <td>7.1</td>\n",
       "      <td>29.9</td>\n",
       "      <td>8.7</td>\n",
       "      <td>13.2</td>\n",
       "      <td>58.0</td>\n",
       "      <td>0.16</td>\n",
       "      <td>0.36</td>\n",
       "      <td>0.0</td>\n",
       "      <td>53.6</td>\n",
       "      <td>31.5</td>\n",
       "      <td>44.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>29.942</td>\n",
       "      <td>29.749</td>\n",
       "      <td>25.3</td>\n",
       "      <td>36.8</td>\n",
       "      <td>53.6</td>\n",
       "      <td>0.193</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2366</th>\n",
       "      <td>NaT</td>\n",
       "      <td>38.1</td>\n",
       "      <td>36.0</td>\n",
       "      <td>12.3</td>\n",
       "      <td>29.8</td>\n",
       "      <td>11.5</td>\n",
       "      <td>17.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>0.16</td>\n",
       "      <td>0.36</td>\n",
       "      <td>0.0</td>\n",
       "      <td>45.9</td>\n",
       "      <td>27.9</td>\n",
       "      <td>73.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>30.023</td>\n",
       "      <td>29.702</td>\n",
       "      <td>29.9</td>\n",
       "      <td>39.1</td>\n",
       "      <td>45.9</td>\n",
       "      <td>0.321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2367</th>\n",
       "      <td>2029-03-01</td>\n",
       "      <td>36.4</td>\n",
       "      <td>30.0</td>\n",
       "      <td>7.6</td>\n",
       "      <td>30.0</td>\n",
       "      <td>7.9</td>\n",
       "      <td>12.5</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.21</td>\n",
       "      <td>0.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>24.5</td>\n",
       "      <td>51.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>30.125</td>\n",
       "      <td>29.817</td>\n",
       "      <td>24.2</td>\n",
       "      <td>34.5</td>\n",
       "      <td>47.0</td>\n",
       "      <td>0.308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3750</th>\n",
       "      <td>2033-02-28</td>\n",
       "      <td>37.7</td>\n",
       "      <td>30.0</td>\n",
       "      <td>8.3</td>\n",
       "      <td>30.1</td>\n",
       "      <td>11.0</td>\n",
       "      <td>15.9</td>\n",
       "      <td>224.0</td>\n",
       "      <td>0.48</td>\n",
       "      <td>0.49</td>\n",
       "      <td>0.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>29.5</td>\n",
       "      <td>38.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>30.194</td>\n",
       "      <td>29.970</td>\n",
       "      <td>24.2</td>\n",
       "      <td>42.6</td>\n",
       "      <td>47.0</td>\n",
       "      <td>0.224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3751</th>\n",
       "      <td>NaT</td>\n",
       "      <td>37.6</td>\n",
       "      <td>31.0</td>\n",
       "      <td>8.7</td>\n",
       "      <td>29.8</td>\n",
       "      <td>8.0</td>\n",
       "      <td>11.6</td>\n",
       "      <td>236.0</td>\n",
       "      <td>0.48</td>\n",
       "      <td>0.49</td>\n",
       "      <td>0.0</td>\n",
       "      <td>48.1</td>\n",
       "      <td>26.1</td>\n",
       "      <td>57.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>29.972</td>\n",
       "      <td>29.647</td>\n",
       "      <td>19.6</td>\n",
       "      <td>31.1</td>\n",
       "      <td>48.1</td>\n",
       "      <td>0.325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3752</th>\n",
       "      <td>2033-03-01</td>\n",
       "      <td>28.7</td>\n",
       "      <td>66.0</td>\n",
       "      <td>17.8</td>\n",
       "      <td>29.7</td>\n",
       "      <td>4.1</td>\n",
       "      <td>6.5</td>\n",
       "      <td>34.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.49</td>\n",
       "      <td>0.0</td>\n",
       "      <td>38.2</td>\n",
       "      <td>17.1</td>\n",
       "      <td>90.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>29.903</td>\n",
       "      <td>29.622</td>\n",
       "      <td>16.1</td>\n",
       "      <td>23.0</td>\n",
       "      <td>38.2</td>\n",
       "      <td>0.281</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Date  Average_temperature  Average_humidity  Average_dewpoint  \\\n",
       "2365  2029-02-28                 42.2              25.0               7.1   \n",
       "2366         NaT                 38.1              36.0              12.3   \n",
       "2367  2029-03-01                 36.4              30.0               7.6   \n",
       "3750  2033-02-28                 37.7              30.0               8.3   \n",
       "3751         NaT                 37.6              31.0               8.7   \n",
       "3752  2033-03-01                 28.7              66.0              17.8   \n",
       "\n",
       "      Average_barometer  Average_windspeed  Average_gust_speed  \\\n",
       "2365               29.9                8.7                13.2   \n",
       "2366               29.8               11.5                17.0   \n",
       "2367               30.0                7.9                12.5   \n",
       "3750               30.1               11.0                15.9   \n",
       "3751               29.8                8.0                11.6   \n",
       "3752               29.7                4.1                 6.5   \n",
       "\n",
       "      Average_direction_degree  Rainfall_for_month  Rainfall_for_year  \\\n",
       "2365                      58.0                0.16               0.36   \n",
       "2366                      77.0                0.16               0.36   \n",
       "2367                      23.0                0.00               0.21   \n",
       "3750                     224.0                0.48               0.49   \n",
       "3751                     236.0                0.48               0.49   \n",
       "3752                      34.0                0.00               0.49   \n",
       "\n",
       "      Maximum_rain_per_minute  Maximum_temperature  Minimum_temperature  \\\n",
       "2365                      0.0                 53.6                 31.5   \n",
       "2366                      0.0                 45.9                 27.9   \n",
       "2367                      0.0                 47.0                 24.5   \n",
       "3750                      0.0                 47.0                 29.5   \n",
       "3751                      0.0                 48.1                 26.1   \n",
       "3752                      0.0                 38.2                 17.1   \n",
       "\n",
       "      Maximum_humidity  Minimum_humidity  Maximum_pressure  Minimum_pressure  \\\n",
       "2365              44.0              11.0            29.942            29.749   \n",
       "2366              73.0              22.0            30.023            29.702   \n",
       "2367              51.0              22.0            30.125            29.817   \n",
       "3750              38.0              21.0            30.194            29.970   \n",
       "3751              57.0              20.0            29.972            29.647   \n",
       "3752              90.0              36.0            29.903            29.622   \n",
       "\n",
       "      Maximum_windspeed  Maximum_gust_speed  Maximum_heat_index  Diff_pressure  \n",
       "2365               25.3                36.8                53.6          0.193  \n",
       "2366               29.9                39.1                45.9          0.321  \n",
       "2367               24.2                34.5                47.0          0.308  \n",
       "3750               24.2                42.6                47.0          0.224  \n",
       "3751               19.6                31.1                48.1          0.325  \n",
       "3752               16.1                23.0                38.2          0.281  "
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[[2365,2366,2367,3750,3751,3752]]     #exploring more about null values"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5abda354",
   "metadata": {},
   "source": [
    "As we can see above, null values are for the date where 29th day was present in the feb for non leap year. We can drop it."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "6217a7e1",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.dropna(inplace=True)    #dropping rows having NaT values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "a1bf9c9b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Average_temperature</th>\n",
       "      <th>Average_humidity</th>\n",
       "      <th>Average_dewpoint</th>\n",
       "      <th>Average_barometer</th>\n",
       "      <th>Average_windspeed</th>\n",
       "      <th>Average_gust_speed</th>\n",
       "      <th>Average_direction_degree</th>\n",
       "      <th>Rainfall_for_month</th>\n",
       "      <th>Rainfall_for_year</th>\n",
       "      <th>Maximum_rain_per_minute</th>\n",
       "      <th>Maximum_temperature</th>\n",
       "      <th>Minimum_temperature</th>\n",
       "      <th>Maximum_humidity</th>\n",
       "      <th>Minimum_humidity</th>\n",
       "      <th>Maximum_pressure</th>\n",
       "      <th>Minimum_pressure</th>\n",
       "      <th>Maximum_windspeed</th>\n",
       "      <th>Maximum_gust_speed</th>\n",
       "      <th>Maximum_heat_index</th>\n",
       "      <th>Diff_pressure</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Date, Average_temperature, Average_humidity, Average_dewpoint, Average_barometer, Average_windspeed, Average_gust_speed, Average_direction_degree, Rainfall_for_month, Rainfall_for_year, Maximum_rain_per_minute, Maximum_temperature, Minimum_temperature, Maximum_humidity, Minimum_humidity, Maximum_pressure, Minimum_pressure, Maximum_windspeed, Maximum_gust_speed, Maximum_heat_index, Diff_pressure]\n",
       "Index: []"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df.isna().any(axis=1)]             #successfully dropped"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "90e3b702",
   "metadata": {},
   "source": [
    "We have completed all preprocessing and data cleaning. Final shape of our dataset is: "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "5ac11c43",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(3900, 21)"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "273a4a1a",
   "metadata": {},
   "source": [
    "## To Export Clean Dataset into csv File :"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "e40abcd4",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('weather_datasetcleaned.csv', index=False, encoding='utf-8')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cc3343f9",
   "metadata": {},
   "source": [
    "***\n",
    "## Conclusion :\n",
    "\n",
    "- We have done all pre-processing using python alone with the help of Pandas and Numpy. \n",
    "- Corruped data, duplicates and missed data handled and fixed successfully."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}