Model Training using Ridge.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "e8eae9fc",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: pandas in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (2.2.2)\n",
      "Requirement already satisfied: numpy>=1.26.0 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from pandas) (1.26.4)\n",
      "Requirement already satisfied: python-dateutil>=2.8.2 in c:\\users\\vaishnavi daule\\appdata\\roaming\\python\\python312\\site-packages (from pandas) (2.9.0.post0)\n",
      "Requirement already satisfied: pytz>=2020.1 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from pandas) (2024.1)\n",
      "Requirement already satisfied: tzdata>=2022.7 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from pandas) (2024.1)\n",
      "Requirement already satisfied: six>=1.5 in c:\\users\\vaishnavi daule\\appdata\\roaming\\python\\python312\\site-packages (from python-dateutil>=2.8.2->pandas) (1.16.0)\n",
      "Note: you may need to restart the kernel to use updated packages.\n"
     ]
    }
   ],
   "source": [
    "pip install pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "83bf822c",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: matplotlib in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (3.9.0)\n",
      "Requirement already satisfied: contourpy>=1.0.1 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from matplotlib) (1.2.1)\n",
      "Requirement already satisfied: cycler>=0.10 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from matplotlib) (0.12.1)\n",
      "Requirement already satisfied: fonttools>=4.22.0 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from matplotlib) (4.53.0)\n",
      "Requirement already satisfied: kiwisolver>=1.3.1 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from matplotlib) (1.4.5)\n",
      "Requirement already satisfied: numpy>=1.23 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from matplotlib) (1.26.4)\n",
      "Requirement already satisfied: packaging>=20.0 in c:\\users\\vaishnavi daule\\appdata\\roaming\\python\\python312\\site-packages (from matplotlib) (24.0)\n",
      "Requirement already satisfied: pillow>=8 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from matplotlib) (10.3.0)\n",
      "Requirement already satisfied: pyparsing>=2.3.1 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from matplotlib) (3.1.2)\n",
      "Requirement already satisfied: python-dateutil>=2.7 in c:\\users\\vaishnavi daule\\appdata\\roaming\\python\\python312\\site-packages (from matplotlib) (2.9.0.post0)\n",
      "Requirement already satisfied: six>=1.5 in c:\\users\\vaishnavi daule\\appdata\\roaming\\python\\python312\\site-packages (from python-dateutil>=2.7->matplotlib) (1.16.0)\n",
      "Note: you may need to restart the kernel to use updated packages.\n"
     ]
    }
   ],
   "source": [
    "pip install matplotlib"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "e78d9078",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: seaborn in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (0.13.2)\n",
      "Requirement already satisfied: numpy!=1.24.0,>=1.20 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from seaborn) (1.26.4)\n",
      "Requirement already satisfied: pandas>=1.2 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from seaborn) (2.2.2)\n",
      "Requirement already satisfied: matplotlib!=3.6.1,>=3.4 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from seaborn) (3.9.0)\n",
      "Requirement already satisfied: contourpy>=1.0.1 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from matplotlib!=3.6.1,>=3.4->seaborn) (1.2.1)\n",
      "Requirement already satisfied: cycler>=0.10 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from matplotlib!=3.6.1,>=3.4->seaborn) (0.12.1)\n",
      "Requirement already satisfied: fonttools>=4.22.0 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from matplotlib!=3.6.1,>=3.4->seaborn) (4.53.0)\n",
      "Requirement already satisfied: kiwisolver>=1.3.1 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from matplotlib!=3.6.1,>=3.4->seaborn) (1.4.5)\n",
      "Requirement already satisfied: packaging>=20.0 in c:\\users\\vaishnavi daule\\appdata\\roaming\\python\\python312\\site-packages (from matplotlib!=3.6.1,>=3.4->seaborn) (24.0)\n",
      "Requirement already satisfied: pillow>=8 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from matplotlib!=3.6.1,>=3.4->seaborn) (10.3.0)\n",
      "Requirement already satisfied: pyparsing>=2.3.1 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from matplotlib!=3.6.1,>=3.4->seaborn) (3.1.2)\n",
      "Requirement already satisfied: python-dateutil>=2.7 in c:\\users\\vaishnavi daule\\appdata\\roaming\\python\\python312\\site-packages (from matplotlib!=3.6.1,>=3.4->seaborn) (2.9.0.post0)\n",
      "Requirement already satisfied: pytz>=2020.1 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from pandas>=1.2->seaborn) (2024.1)\n",
      "Requirement already satisfied: tzdata>=2022.7 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from pandas>=1.2->seaborn) (2024.1)\n",
      "Requirement already satisfied: six>=1.5 in c:\\users\\vaishnavi daule\\appdata\\roaming\\python\\python312\\site-packages (from python-dateutil>=2.7->matplotlib!=3.6.1,>=3.4->seaborn) (1.16.0)\n",
      "Note: you may need to restart the kernel to use updated packages.\n"
     ]
    }
   ],
   "source": [
    "pip install seaborn"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "b7b486d0",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: plotly in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (5.22.0)\n",
      "Requirement already satisfied: tenacity>=6.2.0 in c:\\users\\vaishnavi daule\\appdata\\local\\programs\\python\\python312\\lib\\site-packages (from plotly) (8.3.0)\n",
      "Requirement already satisfied: packaging in c:\\users\\vaishnavi daule\\appdata\\roaming\\python\\python312\\site-packages (from plotly) (24.0)\n",
      "Note: you may need to restart the kernel to use updated packages.\n"
     ]
    }
   ],
   "source": [
    "pip install plotly"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "952d4266",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns \n",
    "import warnings\n",
    "import plotly.express as px\n",
    "warnings.filterwarnings('ignore')\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "ed79306f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv(\"IndianWeatherRepository.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "f9e81d7a",
   "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>country</th>\n",
       "      <th>location_name</th>\n",
       "      <th>region</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>timezone</th>\n",
       "      <th>last_updated_epoch</th>\n",
       "      <th>last_updated</th>\n",
       "      <th>temperature_celsius</th>\n",
       "      <th>temperature_fahrenheit</th>\n",
       "      <th>...</th>\n",
       "      <th>air_quality_PM2.5</th>\n",
       "      <th>air_quality_PM10</th>\n",
       "      <th>air_quality_us-epa-index</th>\n",
       "      <th>air_quality_gb-defra-index</th>\n",
       "      <th>sunrise</th>\n",
       "      <th>sunset</th>\n",
       "      <th>moonrise</th>\n",
       "      <th>moonset</th>\n",
       "      <th>moon_phase</th>\n",
       "      <th>moon_illumination</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>India</td>\n",
       "      <td>Ashoknagar</td>\n",
       "      <td>Madhya Pradesh</td>\n",
       "      <td>24.57</td>\n",
       "      <td>77.72</td>\n",
       "      <td>Asia/Kolkata</td>\n",
       "      <td>1693286100</td>\n",
       "      <td>2023-08-29 10:45</td>\n",
       "      <td>27.5</td>\n",
       "      <td>81.5</td>\n",
       "      <td>...</td>\n",
       "      <td>12.6</td>\n",
       "      <td>18.5</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>05:59 AM</td>\n",
       "      <td>06:41 PM</td>\n",
       "      <td>05:42 PM</td>\n",
       "      <td>03:38 AM</td>\n",
       "      <td>Waxing Gibbous</td>\n",
       "      <td>93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>India</td>\n",
       "      <td>Raisen</td>\n",
       "      <td>Madhya Pradesh</td>\n",
       "      <td>23.33</td>\n",
       "      <td>77.80</td>\n",
       "      <td>Asia/Kolkata</td>\n",
       "      <td>1693286100</td>\n",
       "      <td>2023-08-29 10:45</td>\n",
       "      <td>27.5</td>\n",
       "      <td>81.5</td>\n",
       "      <td>...</td>\n",
       "      <td>10.7</td>\n",
       "      <td>14.2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>06:00 AM</td>\n",
       "      <td>06:40 PM</td>\n",
       "      <td>05:39 PM</td>\n",
       "      <td>03:41 AM</td>\n",
       "      <td>Waxing Gibbous</td>\n",
       "      <td>93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>India</td>\n",
       "      <td>Chhindwara</td>\n",
       "      <td>Madhya Pradesh</td>\n",
       "      <td>22.07</td>\n",
       "      <td>78.93</td>\n",
       "      <td>Asia/Kolkata</td>\n",
       "      <td>1693286100</td>\n",
       "      <td>2023-08-29 10:45</td>\n",
       "      <td>26.3</td>\n",
       "      <td>79.3</td>\n",
       "      <td>...</td>\n",
       "      <td>16.8</td>\n",
       "      <td>20.7</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>05:56 AM</td>\n",
       "      <td>06:34 PM</td>\n",
       "      <td>05:32 PM</td>\n",
       "      <td>03:39 AM</td>\n",
       "      <td>Waxing Gibbous</td>\n",
       "      <td>93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>India</td>\n",
       "      <td>Betul</td>\n",
       "      <td>Madhya Pradesh</td>\n",
       "      <td>21.86</td>\n",
       "      <td>77.93</td>\n",
       "      <td>Asia/Kolkata</td>\n",
       "      <td>1693286100</td>\n",
       "      <td>2023-08-29 10:45</td>\n",
       "      <td>25.6</td>\n",
       "      <td>78.1</td>\n",
       "      <td>...</td>\n",
       "      <td>4.9</td>\n",
       "      <td>6.6</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>06:00 AM</td>\n",
       "      <td>06:38 PM</td>\n",
       "      <td>05:36 PM</td>\n",
       "      <td>03:43 AM</td>\n",
       "      <td>Waxing Gibbous</td>\n",
       "      <td>93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>India</td>\n",
       "      <td>Hoshangabad</td>\n",
       "      <td>Madhya Pradesh</td>\n",
       "      <td>22.75</td>\n",
       "      <td>77.72</td>\n",
       "      <td>Asia/Kolkata</td>\n",
       "      <td>1693286100</td>\n",
       "      <td>2023-08-29 10:45</td>\n",
       "      <td>27.2</td>\n",
       "      <td>81.0</td>\n",
       "      <td>...</td>\n",
       "      <td>11.4</td>\n",
       "      <td>14.8</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>06:01 AM</td>\n",
       "      <td>06:39 PM</td>\n",
       "      <td>05:38 PM</td>\n",
       "      <td>03:42 AM</td>\n",
       "      <td>Waxing Gibbous</td>\n",
       "      <td>93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115557</th>\n",
       "      <td>India</td>\n",
       "      <td>Niwari</td>\n",
       "      <td>Uttar Pradesh</td>\n",
       "      <td>28.88</td>\n",
       "      <td>77.53</td>\n",
       "      <td>Asia/Kolkata</td>\n",
       "      <td>1711815300</td>\n",
       "      <td>2024-03-30 21:45</td>\n",
       "      <td>29.0</td>\n",
       "      <td>84.2</td>\n",
       "      <td>...</td>\n",
       "      <td>50.5</td>\n",
       "      <td>129.9</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>06:12 AM</td>\n",
       "      <td>06:37 PM</td>\n",
       "      <td>11:28 PM</td>\n",
       "      <td>08:52 AM</td>\n",
       "      <td>Waning Gibbous</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115558</th>\n",
       "      <td>India</td>\n",
       "      <td>Saitual</td>\n",
       "      <td>Mizoram</td>\n",
       "      <td>23.97</td>\n",
       "      <td>92.58</td>\n",
       "      <td>Asia/Kolkata</td>\n",
       "      <td>1711815300</td>\n",
       "      <td>2024-03-30 21:45</td>\n",
       "      <td>18.3</td>\n",
       "      <td>64.9</td>\n",
       "      <td>...</td>\n",
       "      <td>16.2</td>\n",
       "      <td>18.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>05:14 AM</td>\n",
       "      <td>05:35 PM</td>\n",
       "      <td>10:11 PM</td>\n",
       "      <td>08:02 AM</td>\n",
       "      <td>Waning Gibbous</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115559</th>\n",
       "      <td>India</td>\n",
       "      <td>Ranipet</td>\n",
       "      <td>Tamil Nadu</td>\n",
       "      <td>12.93</td>\n",
       "      <td>79.33</td>\n",
       "      <td>Asia/Kolkata</td>\n",
       "      <td>1711815300</td>\n",
       "      <td>2024-03-30 21:45</td>\n",
       "      <td>25.4</td>\n",
       "      <td>77.8</td>\n",
       "      <td>...</td>\n",
       "      <td>8.2</td>\n",
       "      <td>13.2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>06:10 AM</td>\n",
       "      <td>06:24 PM</td>\n",
       "      <td>10:41 PM</td>\n",
       "      <td>09:21 AM</td>\n",
       "      <td>Waning Gibbous</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115560</th>\n",
       "      <td>India</td>\n",
       "      <td>Tenkasi</td>\n",
       "      <td>Tamil Nadu</td>\n",
       "      <td>8.97</td>\n",
       "      <td>77.30</td>\n",
       "      <td>Asia/Kolkata</td>\n",
       "      <td>1711815300</td>\n",
       "      <td>2024-03-30 21:45</td>\n",
       "      <td>31.0</td>\n",
       "      <td>87.8</td>\n",
       "      <td>...</td>\n",
       "      <td>9.4</td>\n",
       "      <td>11.8</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>06:19 AM</td>\n",
       "      <td>06:31 PM</td>\n",
       "      <td>10:41 PM</td>\n",
       "      <td>09:37 AM</td>\n",
       "      <td>Waning Gibbous</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115561</th>\n",
       "      <td>India</td>\n",
       "      <td>Pendra</td>\n",
       "      <td>Maharashtra</td>\n",
       "      <td>21.93</td>\n",
       "      <td>74.15</td>\n",
       "      <td>Asia/Kolkata</td>\n",
       "      <td>1711815300</td>\n",
       "      <td>2024-03-30 21:45</td>\n",
       "      <td>27.8</td>\n",
       "      <td>82.0</td>\n",
       "      <td>...</td>\n",
       "      <td>21.3</td>\n",
       "      <td>28.8</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>06:28 AM</td>\n",
       "      <td>06:48 PM</td>\n",
       "      <td>11:23 PM</td>\n",
       "      <td>09:23 AM</td>\n",
       "      <td>Waning Gibbous</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>115562 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       country location_name          region  latitude  longitude  \\\n",
       "0        India    Ashoknagar  Madhya Pradesh     24.57      77.72   \n",
       "1        India        Raisen  Madhya Pradesh     23.33      77.80   \n",
       "2        India    Chhindwara  Madhya Pradesh     22.07      78.93   \n",
       "3        India         Betul  Madhya Pradesh     21.86      77.93   \n",
       "4        India   Hoshangabad  Madhya Pradesh     22.75      77.72   \n",
       "...        ...           ...             ...       ...        ...   \n",
       "115557   India        Niwari   Uttar Pradesh     28.88      77.53   \n",
       "115558   India       Saitual         Mizoram     23.97      92.58   \n",
       "115559   India       Ranipet      Tamil Nadu     12.93      79.33   \n",
       "115560   India       Tenkasi      Tamil Nadu      8.97      77.30   \n",
       "115561   India        Pendra     Maharashtra     21.93      74.15   \n",
       "\n",
       "            timezone  last_updated_epoch      last_updated  \\\n",
       "0       Asia/Kolkata          1693286100  2023-08-29 10:45   \n",
       "1       Asia/Kolkata          1693286100  2023-08-29 10:45   \n",
       "2       Asia/Kolkata          1693286100  2023-08-29 10:45   \n",
       "3       Asia/Kolkata          1693286100  2023-08-29 10:45   \n",
       "4       Asia/Kolkata          1693286100  2023-08-29 10:45   \n",
       "...              ...                 ...               ...   \n",
       "115557  Asia/Kolkata          1711815300  2024-03-30 21:45   \n",
       "115558  Asia/Kolkata          1711815300  2024-03-30 21:45   \n",
       "115559  Asia/Kolkata          1711815300  2024-03-30 21:45   \n",
       "115560  Asia/Kolkata          1711815300  2024-03-30 21:45   \n",
       "115561  Asia/Kolkata          1711815300  2024-03-30 21:45   \n",
       "\n",
       "        temperature_celsius  temperature_fahrenheit  ... air_quality_PM2.5  \\\n",
       "0                      27.5                    81.5  ...              12.6   \n",
       "1                      27.5                    81.5  ...              10.7   \n",
       "2                      26.3                    79.3  ...              16.8   \n",
       "3                      25.6                    78.1  ...               4.9   \n",
       "4                      27.2                    81.0  ...              11.4   \n",
       "...                     ...                     ...  ...               ...   \n",
       "115557                 29.0                    84.2  ...              50.5   \n",
       "115558                 18.3                    64.9  ...              16.2   \n",
       "115559                 25.4                    77.8  ...               8.2   \n",
       "115560                 31.0                    87.8  ...               9.4   \n",
       "115561                 27.8                    82.0  ...              21.3   \n",
       "\n",
       "        air_quality_PM10  air_quality_us-epa-index  \\\n",
       "0                   18.5                         1   \n",
       "1                   14.2                         1   \n",
       "2                   20.7                         2   \n",
       "3                    6.6                         1   \n",
       "4                   14.8                         1   \n",
       "...                  ...                       ...   \n",
       "115557             129.9                         3   \n",
       "115558              18.0                         2   \n",
       "115559              13.2                         1   \n",
       "115560              11.8                         1   \n",
       "115561              28.8                         2   \n",
       "\n",
       "        air_quality_gb-defra-index   sunrise    sunset  moonrise   moonset  \\\n",
       "0                                2  05:59 AM  06:41 PM  05:42 PM  03:38 AM   \n",
       "1                                1  06:00 AM  06:40 PM  05:39 PM  03:41 AM   \n",
       "2                                2  05:56 AM  06:34 PM  05:32 PM  03:39 AM   \n",
       "3                                1  06:00 AM  06:38 PM  05:36 PM  03:43 AM   \n",
       "4                                1  06:01 AM  06:39 PM  05:38 PM  03:42 AM   \n",
       "...                            ...       ...       ...       ...       ...   \n",
       "115557                           6  06:12 AM  06:37 PM  11:28 PM  08:52 AM   \n",
       "115558                           2  05:14 AM  05:35 PM  10:11 PM  08:02 AM   \n",
       "115559                           1  06:10 AM  06:24 PM  10:41 PM  09:21 AM   \n",
       "115560                           1  06:19 AM  06:31 PM  10:41 PM  09:37 AM   \n",
       "115561                           2  06:28 AM  06:48 PM  11:23 PM  09:23 AM   \n",
       "\n",
       "            moon_phase  moon_illumination  \n",
       "0       Waxing Gibbous                 93  \n",
       "1       Waxing Gibbous                 93  \n",
       "2       Waxing Gibbous                 93  \n",
       "3       Waxing Gibbous                 93  \n",
       "4       Waxing Gibbous                 93  \n",
       "...                ...                ...  \n",
       "115557  Waning Gibbous                 80  \n",
       "115558  Waning Gibbous                 80  \n",
       "115559  Waning Gibbous                 80  \n",
       "115560  Waning Gibbous                 80  \n",
       "115561  Waning Gibbous                 80  \n",
       "\n",
       "[115562 rows x 42 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "83813f87",
   "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>location_name</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>last_updated</th>\n",
       "      <th>temperature_celsius</th>\n",
       "      <th>condition_text</th>\n",
       "      <th>wind_mph</th>\n",
       "      <th>pressure_mb</th>\n",
       "      <th>precip_mm</th>\n",
       "      <th>humidity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ashoknagar</td>\n",
       "      <td>24.57</td>\n",
       "      <td>77.72</td>\n",
       "      <td>2023-08-29 10:45</td>\n",
       "      <td>27.5</td>\n",
       "      <td>Partly cloudy</td>\n",
       "      <td>12.8</td>\n",
       "      <td>1008.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Raisen</td>\n",
       "      <td>23.33</td>\n",
       "      <td>77.80</td>\n",
       "      <td>2023-08-29 10:45</td>\n",
       "      <td>27.5</td>\n",
       "      <td>Sunny</td>\n",
       "      <td>9.6</td>\n",
       "      <td>1008.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Chhindwara</td>\n",
       "      <td>22.07</td>\n",
       "      <td>78.93</td>\n",
       "      <td>2023-08-29 10:45</td>\n",
       "      <td>26.3</td>\n",
       "      <td>Partly cloudy</td>\n",
       "      <td>11.4</td>\n",
       "      <td>1009.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Betul</td>\n",
       "      <td>21.86</td>\n",
       "      <td>77.93</td>\n",
       "      <td>2023-08-29 10:45</td>\n",
       "      <td>25.6</td>\n",
       "      <td>Cloudy</td>\n",
       "      <td>10.5</td>\n",
       "      <td>1009.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Hoshangabad</td>\n",
       "      <td>22.75</td>\n",
       "      <td>77.72</td>\n",
       "      <td>2023-08-29 10:45</td>\n",
       "      <td>27.2</td>\n",
       "      <td>Cloudy</td>\n",
       "      <td>10.1</td>\n",
       "      <td>1009.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115557</th>\n",
       "      <td>Niwari</td>\n",
       "      <td>28.88</td>\n",
       "      <td>77.53</td>\n",
       "      <td>2024-03-30 21:45</td>\n",
       "      <td>29.0</td>\n",
       "      <td>Mist</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1011.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115558</th>\n",
       "      <td>Saitual</td>\n",
       "      <td>23.97</td>\n",
       "      <td>92.58</td>\n",
       "      <td>2024-03-30 21:45</td>\n",
       "      <td>18.3</td>\n",
       "      <td>Clear</td>\n",
       "      <td>3.6</td>\n",
       "      <td>1014.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115559</th>\n",
       "      <td>Ranipet</td>\n",
       "      <td>12.93</td>\n",
       "      <td>79.33</td>\n",
       "      <td>2024-03-30 21:45</td>\n",
       "      <td>25.4</td>\n",
       "      <td>Clear</td>\n",
       "      <td>6.3</td>\n",
       "      <td>1014.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115560</th>\n",
       "      <td>Tenkasi</td>\n",
       "      <td>8.97</td>\n",
       "      <td>77.30</td>\n",
       "      <td>2024-03-30 21:45</td>\n",
       "      <td>31.0</td>\n",
       "      <td>Mist</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1013.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115561</th>\n",
       "      <td>Pendra</td>\n",
       "      <td>21.93</td>\n",
       "      <td>74.15</td>\n",
       "      <td>2024-03-30 21:45</td>\n",
       "      <td>27.8</td>\n",
       "      <td>Clear</td>\n",
       "      <td>6.7</td>\n",
       "      <td>1012.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>115562 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       location_name  latitude  longitude      last_updated  \\\n",
       "0         Ashoknagar     24.57      77.72  2023-08-29 10:45   \n",
       "1             Raisen     23.33      77.80  2023-08-29 10:45   \n",
       "2         Chhindwara     22.07      78.93  2023-08-29 10:45   \n",
       "3              Betul     21.86      77.93  2023-08-29 10:45   \n",
       "4        Hoshangabad     22.75      77.72  2023-08-29 10:45   \n",
       "...              ...       ...        ...               ...   \n",
       "115557        Niwari     28.88      77.53  2024-03-30 21:45   \n",
       "115558       Saitual     23.97      92.58  2024-03-30 21:45   \n",
       "115559       Ranipet     12.93      79.33  2024-03-30 21:45   \n",
       "115560       Tenkasi      8.97      77.30  2024-03-30 21:45   \n",
       "115561        Pendra     21.93      74.15  2024-03-30 21:45   \n",
       "\n",
       "        temperature_celsius condition_text  wind_mph  pressure_mb  precip_mm  \\\n",
       "0                      27.5  Partly cloudy      12.8       1008.0        0.0   \n",
       "1                      27.5          Sunny       9.6       1008.0        0.0   \n",
       "2                      26.3  Partly cloudy      11.4       1009.0        0.0   \n",
       "3                      25.6         Cloudy      10.5       1009.0        0.0   \n",
       "4                      27.2         Cloudy      10.1       1009.0        0.0   \n",
       "...                     ...            ...       ...          ...        ...   \n",
       "115557                 29.0           Mist       2.2       1011.0        0.0   \n",
       "115558                 18.3         Clear        3.6       1014.0        0.0   \n",
       "115559                 25.4         Clear        6.3       1014.0        0.0   \n",
       "115560                 31.0           Mist       2.2       1013.0        0.0   \n",
       "115561                 27.8         Clear        6.7       1012.0        0.0   \n",
       "\n",
       "        humidity  \n",
       "0             67  \n",
       "1             70  \n",
       "2             70  \n",
       "3             76  \n",
       "4             74  \n",
       "...          ...  \n",
       "115557        45  \n",
       "115558        79  \n",
       "115559        57  \n",
       "115560        66  \n",
       "115561        23  \n",
       "\n",
       "[115562 rows x 10 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "columns_to_drop = ['cloud','visibility_km','uv_index','country','region','timezone','last_updated_epoch','temperature_fahrenheit','wind_direction','wind_kph','wind_degree','pressure_in','precip_in','feels_like_fahrenheit','feels_like_celsius','visibility_miles','gust_mph', 'gust_kph', 'air_quality_Carbon_Monoxide', 'air_quality_Ozone', 'air_quality_Nitrogen_dioxide', 'air_quality_Sulphur_dioxide', 'air_quality_PM2.5', 'air_quality_PM10', 'air_quality_us-epa-index', 'air_quality_gb-defra-index', 'sunrise', 'sunset', 'moonrise', 'moonset', 'moon_phase', 'moon_illumination']\n",
    "df.drop(columns= columns_to_drop,inplace = True)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "e607b6a9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['location_name', 'last_updated', 'condition_text'], dtype='object')"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cat_cols= df.select_dtypes(include = ['object']).columns\n",
    "cat_cols"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "1e4fa2b5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['latitude', 'longitude', 'temperature_celsius', 'wind_mph',\n",
       "       'pressure_mb', 'precip_mm', 'humidity'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "num_cols = df.select_dtypes(include = ['number']).columns\n",
    "num_cols"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "3c3174e8",
   "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>location_name</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>last_updated</th>\n",
       "      <th>temperature_celsius</th>\n",
       "      <th>condition_text</th>\n",
       "      <th>wind_mph</th>\n",
       "      <th>pressure_mb</th>\n",
       "      <th>precip_mm</th>\n",
       "      <th>humidity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>573</th>\n",
       "      <td>Seoni</td>\n",
       "      <td>22.08</td>\n",
       "      <td>79.53</td>\n",
       "      <td>2023-08-30 08:45</td>\n",
       "      <td>21.6</td>\n",
       "      <td>Clear</td>\n",
       "      <td>5.4</td>\n",
       "      <td>1007.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1095</th>\n",
       "      <td>Chhindwara</td>\n",
       "      <td>22.07</td>\n",
       "      <td>78.93</td>\n",
       "      <td>2023-08-31 05:15</td>\n",
       "      <td>21.4</td>\n",
       "      <td>Clear</td>\n",
       "      <td>4.7</td>\n",
       "      <td>1009.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1096</th>\n",
       "      <td>Betul</td>\n",
       "      <td>21.86</td>\n",
       "      <td>77.93</td>\n",
       "      <td>2023-08-31 05:15</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Clear</td>\n",
       "      <td>2.7</td>\n",
       "      <td>1009.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1097</th>\n",
       "      <td>Hoshangabad</td>\n",
       "      <td>22.75</td>\n",
       "      <td>77.72</td>\n",
       "      <td>2023-08-31 05:15</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Clear</td>\n",
       "      <td>5.4</td>\n",
       "      <td>1008.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1099</th>\n",
       "      <td>Jabalpur</td>\n",
       "      <td>23.17</td>\n",
       "      <td>79.95</td>\n",
       "      <td>2023-08-31 05:15</td>\n",
       "      <td>22.7</td>\n",
       "      <td>Clear</td>\n",
       "      <td>3.1</td>\n",
       "      <td>1008.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115130</th>\n",
       "      <td>West Godavari</td>\n",
       "      <td>16.70</td>\n",
       "      <td>81.10</td>\n",
       "      <td>2024-03-30 21:30</td>\n",
       "      <td>29.0</td>\n",
       "      <td>Clear</td>\n",
       "      <td>3.8</td>\n",
       "      <td>1012.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115254</th>\n",
       "      <td>Nandi Hills</td>\n",
       "      <td>13.33</td>\n",
       "      <td>77.65</td>\n",
       "      <td>2024-03-30 21:30</td>\n",
       "      <td>28.0</td>\n",
       "      <td>Clear</td>\n",
       "      <td>11.9</td>\n",
       "      <td>1018.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115340</th>\n",
       "      <td>Kolar</td>\n",
       "      <td>13.13</td>\n",
       "      <td>78.13</td>\n",
       "      <td>2024-03-30 21:30</td>\n",
       "      <td>28.0</td>\n",
       "      <td>Clear</td>\n",
       "      <td>11.9</td>\n",
       "      <td>1018.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115350</th>\n",
       "      <td>Bangalore</td>\n",
       "      <td>12.98</td>\n",
       "      <td>77.58</td>\n",
       "      <td>2024-03-30 21:30</td>\n",
       "      <td>28.0</td>\n",
       "      <td>Clear</td>\n",
       "      <td>11.9</td>\n",
       "      <td>1018.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115351</th>\n",
       "      <td>Tumkur</td>\n",
       "      <td>13.34</td>\n",
       "      <td>77.10</td>\n",
       "      <td>2024-03-30 21:30</td>\n",
       "      <td>28.0</td>\n",
       "      <td>Clear</td>\n",
       "      <td>11.9</td>\n",
       "      <td>1018.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>46245 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        location_name  latitude  longitude      last_updated  \\\n",
       "573             Seoni     22.08      79.53  2023-08-30 08:45   \n",
       "1095       Chhindwara     22.07      78.93  2023-08-31 05:15   \n",
       "1096            Betul     21.86      77.93  2023-08-31 05:15   \n",
       "1097      Hoshangabad     22.75      77.72  2023-08-31 05:15   \n",
       "1099         Jabalpur     23.17      79.95  2023-08-31 05:15   \n",
       "...               ...       ...        ...               ...   \n",
       "115130  West Godavari     16.70      81.10  2024-03-30 21:30   \n",
       "115254    Nandi Hills     13.33      77.65  2024-03-30 21:30   \n",
       "115340          Kolar     13.13      78.13  2024-03-30 21:30   \n",
       "115350      Bangalore     12.98      77.58  2024-03-30 21:30   \n",
       "115351         Tumkur     13.34      77.10  2024-03-30 21:30   \n",
       "\n",
       "        temperature_celsius condition_text  wind_mph  pressure_mb  precip_mm  \\\n",
       "573                    21.6          Clear       5.4       1007.0        0.0   \n",
       "1095                   21.4          Clear       4.7       1009.0        0.0   \n",
       "1096                   21.0          Clear       2.7       1009.0        0.0   \n",
       "1097                   23.0          Clear       5.4       1008.0        0.0   \n",
       "1099                   22.7          Clear       3.1       1008.0        0.0   \n",
       "...                     ...            ...       ...          ...        ...   \n",
       "115130                 29.0          Clear       3.8       1012.0        0.0   \n",
       "115254                 28.0          Clear      11.9       1018.0        0.0   \n",
       "115340                 28.0          Clear      11.9       1018.0        0.0   \n",
       "115350                 28.0          Clear      11.9       1018.0        0.0   \n",
       "115351                 28.0          Clear      11.9       1018.0        0.0   \n",
       "\n",
       "        humidity  \n",
       "573           91  \n",
       "1095          75  \n",
       "1096          87  \n",
       "1097          84  \n",
       "1099          79  \n",
       "...          ...  \n",
       "115130        79  \n",
       "115254        25  \n",
       "115340        25  \n",
       "115350        25  \n",
       "115351        25  \n",
       "\n",
       "[46245 rows x 10 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "clear_data = df[df['condition_text'] == 'Clear']\n",
    "\n",
    "clear_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "9380a6ae",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "condition_text\n",
       "Clear                                          46245\n",
       "Clear                                          23055\n",
       "Mist                                           16371\n",
       "Partly cloudy                                   9181\n",
       "Patchy rain possible                            5126\n",
       "Light rain shower                               2914\n",
       "Partly Cloudy                                   2128\n",
       "Fog                                             2014\n",
       "Overcast                                        1816\n",
       "Cloudy                                          1367\n",
       "Patchy rain nearby                              1260\n",
       "Sunny                                            772\n",
       "Light rain                                       497\n",
       "Moderate or heavy rain shower                    402\n",
       "Overcast                                         332\n",
       "Light drizzle                                    270\n",
       "Cloudy                                           253\n",
       "Moderate or heavy rain with thunder              236\n",
       "Patchy light drizzle                             233\n",
       "Moderate rain                                    175\n",
       "Patchy light rain                                145\n",
       "Patchy light rain with thunder                   112\n",
       "Moderate rain at times                            93\n",
       "Thundery outbreaks possible                       74\n",
       "Light freezing rain                               65\n",
       "Heavy rain                                        57\n",
       "Moderate or heavy snow showers                    45\n",
       "Patchy light rain in area with thunder            39\n",
       "Torrential rain shower                            34\n",
       "Heavy snow                                        33\n",
       "Thundery outbreaks in nearby                      32\n",
       "Light snow showers                                30\n",
       "Patchy snow nearby                                26\n",
       "Patchy light snow                                 25\n",
       "Light snow                                        18\n",
       "Light sleet                                       15\n",
       "Patchy moderate snow                              14\n",
       "Moderate or heavy snow in area with thunder       11\n",
       "Light sleet showers                                8\n",
       "Patchy heavy snow                                  6\n",
       "Patchy light snow with thunder                     6\n",
       "Moderate or heavy sleet                            5\n",
       "Patchy sleet nearby                                5\n",
       "Patchy snow possible                               5\n",
       "Patchy light snow in area with thunder             4\n",
       "Heavy rain at times                                4\n",
       "Moderate snow                                      2\n",
       "Moderate or heavy rain in area with thunder        1\n",
       "Moderate or heavy snow with thunder                1\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "count = df[\"condition_text\"].value_counts()\n",
    "count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "13ed9b0c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "49"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"condition_text\"].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "bd8755fe",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Partly cloudy' 'Sunny' 'Cloudy' 'Mist' 'Patchy rain possible' 'Overcast'\n",
      " 'Patchy light rain with thunder' 'Light rain shower'\n",
      " 'Moderate or heavy rain shower' 'Clear' 'Light rain'\n",
      " 'Torrential rain shower' 'Fog' 'Thundery outbreaks possible'\n",
      " 'Patchy light drizzle' 'Moderate rain' 'Patchy light rain'\n",
      " 'Moderate rain at times' 'Heavy rain' 'Heavy rain at times'\n",
      " 'Light drizzle' 'Moderate or heavy rain with thunder'\n",
      " 'Patchy snow possible' 'Moderate or heavy snow showers'\n",
      " 'Light snow showers' 'Moderate or heavy snow with thunder'\n",
      " 'Patchy light snow with thunder' 'Light sleet' 'Light freezing rain'\n",
      " 'Patchy light snow' 'Patchy moderate snow' 'Light snow' 'Moderate snow'\n",
      " 'Overcast ' 'Clear ' 'Cloudy ' 'Partly Cloudy ' 'Patchy rain nearby'\n",
      " 'Thundery outbreaks in nearby' 'Heavy snow'\n",
      " 'Patchy light snow in area with thunder'\n",
      " 'Patchy light rain in area with thunder' 'Light sleet showers'\n",
      " 'Moderate or heavy snow in area with thunder'\n",
      " 'Moderate or heavy rain in area with thunder' 'Patchy heavy snow'\n",
      " 'Patchy snow nearby' 'Patchy sleet nearby' 'Moderate or heavy sleet']\n"
     ]
    }
   ],
   "source": [
    "count = df[\"condition_text\"].str.strip().value_counts()\n",
    "unique_values = df[\"condition_text\"].unique()\n",
    "df['condition_text'] = df['condition_text'].str.lower()\n",
    "print(unique_values)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "ffaf3034",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Clear', 'Mist', 'Partly cloudy', 'Patchy rain possible',\n",
       "       'Light rain shower', 'Overcast', 'Partly Cloudy', 'Fog', 'Cloudy',\n",
       "       'Patchy rain nearby'],\n",
       "      dtype='object', name='condition_text')"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "threshold = 1000\n",
    "repl = count [count>=threshold].index\n",
    "repl"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "a2668124",
   "metadata": {},
   "outputs": [
    {
     "ename": "ModuleNotFoundError",
     "evalue": "No module named 'sklearn'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mModuleNotFoundError\u001b[0m                       Traceback (most recent call last)",
      "Cell \u001b[1;32mIn[32], line 1\u001b[0m\n\u001b[1;32m----> 1\u001b[0m \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01msklearn\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mpreprocessing\u001b[39;00m \u001b[38;5;28;01mimport\u001b[39;00m LabelEncoder\n",
      "\u001b[1;31mModuleNotFoundError\u001b[0m: No module named 'sklearn'"
     ]
    }
   ],
   "source": [
    "from sklearn.preprocessing import LabelEncoder"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "266880c9",
   "metadata": {},
   "outputs": [],
   "source": [
    "le=LabelEncoder()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c6234c26",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>#sk-container-id-2 {color: black;}#sk-container-id-2 pre{padding: 0;}#sk-container-id-2 div.sk-toggleable {background-color: white;}#sk-container-id-2 label.sk-toggleable__label {cursor: pointer;display: block;width: 100%;margin-bottom: 0;padding: 0.3em;box-sizing: border-box;text-align: center;}#sk-container-id-2 label.sk-toggleable__label-arrow:before {content: \"▸\";float: left;margin-right: 0.25em;color: #696969;}#sk-container-id-2 label.sk-toggleable__label-arrow:hover:before {color: black;}#sk-container-id-2 div.sk-estimator:hover label.sk-toggleable__label-arrow:before {color: black;}#sk-container-id-2 div.sk-toggleable__content {max-height: 0;max-width: 0;overflow: hidden;text-align: left;background-color: #f0f8ff;}#sk-container-id-2 div.sk-toggleable__content pre {margin: 0.2em;color: black;border-radius: 0.25em;background-color: #f0f8ff;}#sk-container-id-2 input.sk-toggleable__control:checked~div.sk-toggleable__content {max-height: 200px;max-width: 100%;overflow: auto;}#sk-container-id-2 input.sk-toggleable__control:checked~label.sk-toggleable__label-arrow:before {content: \"▾\";}#sk-container-id-2 div.sk-estimator input.sk-toggleable__control:checked~label.sk-toggleable__label {background-color: #d4ebff;}#sk-container-id-2 div.sk-label input.sk-toggleable__control:checked~label.sk-toggleable__label {background-color: #d4ebff;}#sk-container-id-2 input.sk-hidden--visually {border: 0;clip: rect(1px 1px 1px 1px);clip: rect(1px, 1px, 1px, 1px);height: 1px;margin: -1px;overflow: hidden;padding: 0;position: absolute;width: 1px;}#sk-container-id-2 div.sk-estimator {font-family: monospace;background-color: #f0f8ff;border: 1px dotted black;border-radius: 0.25em;box-sizing: border-box;margin-bottom: 0.5em;}#sk-container-id-2 div.sk-estimator:hover {background-color: #d4ebff;}#sk-container-id-2 div.sk-parallel-item::after {content: \"\";width: 100%;border-bottom: 1px solid gray;flex-grow: 1;}#sk-container-id-2 div.sk-label:hover label.sk-toggleable__label {background-color: #d4ebff;}#sk-container-id-2 div.sk-serial::before {content: \"\";position: absolute;border-left: 1px solid gray;box-sizing: border-box;top: 0;bottom: 0;left: 50%;z-index: 0;}#sk-container-id-2 div.sk-serial {display: flex;flex-direction: column;align-items: center;background-color: white;padding-right: 0.2em;padding-left: 0.2em;position: relative;}#sk-container-id-2 div.sk-item {position: relative;z-index: 1;}#sk-container-id-2 div.sk-parallel {display: flex;align-items: stretch;justify-content: center;background-color: white;position: relative;}#sk-container-id-2 div.sk-item::before, #sk-container-id-2 div.sk-parallel-item::before {content: \"\";position: absolute;border-left: 1px solid gray;box-sizing: border-box;top: 0;bottom: 0;left: 50%;z-index: -1;}#sk-container-id-2 div.sk-parallel-item {display: flex;flex-direction: column;z-index: 1;position: relative;background-color: white;}#sk-container-id-2 div.sk-parallel-item:first-child::after {align-self: flex-end;width: 50%;}#sk-container-id-2 div.sk-parallel-item:last-child::after {align-self: flex-start;width: 50%;}#sk-container-id-2 div.sk-parallel-item:only-child::after {width: 0;}#sk-container-id-2 div.sk-dashed-wrapped {border: 1px dashed gray;margin: 0 0.4em 0.5em 0.4em;box-sizing: border-box;padding-bottom: 0.4em;background-color: white;}#sk-container-id-2 div.sk-label label {font-family: monospace;font-weight: bold;display: inline-block;line-height: 1.2em;}#sk-container-id-2 div.sk-label-container {text-align: center;}#sk-container-id-2 div.sk-container {/* jupyter's `normalize.less` sets `[hidden] { display: none; }` but bootstrap.min.css set `[hidden] { display: none !important; }` so we also need the `!important` here to be able to override the default hidden behavior on the sphinx rendered scikit-learn.org. See: https://github.com/scikit-learn/scikit-learn/issues/21755 */display: inline-block !important;position: relative;}#sk-container-id-2 div.sk-text-repr-fallback {display: none;}</style><div id=\"sk-container-id-2\" class=\"sk-top-container\"><div class=\"sk-text-repr-fallback\"><pre>LabelEncoder()</pre><b>In a Jupyter environment, please rerun this cell to show the HTML representation or trust the notebook. <br />On GitHub, the HTML representation is unable to render, please try loading this page with nbviewer.org.</b></div><div class=\"sk-container\" hidden><div class=\"sk-item\"><div class=\"sk-estimator sk-toggleable\"><input class=\"sk-toggleable__control sk-hidden--visually\" id=\"sk-estimator-id-2\" type=\"checkbox\" checked><label for=\"sk-estimator-id-2\" class=\"sk-toggleable__label sk-toggleable__label-arrow\">LabelEncoder</label><div class=\"sk-toggleable__content\"><pre>LabelEncoder()</pre></div></div></div></div></div>"
      ],
      "text/plain": [
       "LabelEncoder()"
      ]
     },
     "execution_count": 115,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "le.fit(repl)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "960c85a1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([0, 4, 7, 9, 3, 5, 6, 2, 1, 8])"
      ]
     },
     "execution_count": 116,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "le.transform(repl)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3222a7eb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Clear', 'Cloudy', 'Fog', 'Light rain shower', 'Mist', 'Overcast',\n",
       "       'Partly Cloudy', 'Partly cloudy', 'Patchy rain nearby',\n",
       "       'Patchy rain possible'], dtype=object)"
      ]
     },
     "execution_count": 117,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "le.classes_"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "926b2fd9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "location_name           object\n",
       "latitude               float64\n",
       "longitude              float64\n",
       "last_updated            object\n",
       "temperature_celsius    float64\n",
       "condition_text          object\n",
       "wind_mph               float64\n",
       "pressure_mb            float64\n",
       "precip_mm              float64\n",
       "humidity                 int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 118,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f436fd6e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RangeIndex(start=0, stop=115562, step=1)"
      ]
     },
     "execution_count": 119,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "226b94e1",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['last_updated']=pd.to_datetime(df['last_updated'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6813b154",
   "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>location_name</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>last_updated</th>\n",
       "      <th>temperature_celsius</th>\n",
       "      <th>condition_text</th>\n",
       "      <th>wind_mph</th>\n",
       "      <th>pressure_mb</th>\n",
       "      <th>precip_mm</th>\n",
       "      <th>humidity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ashoknagar</td>\n",
       "      <td>24.57</td>\n",
       "      <td>77.72</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>27.5</td>\n",
       "      <td>partly cloudy</td>\n",
       "      <td>12.8</td>\n",
       "      <td>1008.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Raisen</td>\n",
       "      <td>23.33</td>\n",
       "      <td>77.80</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>27.5</td>\n",
       "      <td>sunny</td>\n",
       "      <td>9.6</td>\n",
       "      <td>1008.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Chhindwara</td>\n",
       "      <td>22.07</td>\n",
       "      <td>78.93</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>26.3</td>\n",
       "      <td>partly cloudy</td>\n",
       "      <td>11.4</td>\n",
       "      <td>1009.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Betul</td>\n",
       "      <td>21.86</td>\n",
       "      <td>77.93</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>25.6</td>\n",
       "      <td>cloudy</td>\n",
       "      <td>10.5</td>\n",
       "      <td>1009.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Hoshangabad</td>\n",
       "      <td>22.75</td>\n",
       "      <td>77.72</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>27.2</td>\n",
       "      <td>cloudy</td>\n",
       "      <td>10.1</td>\n",
       "      <td>1009.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115557</th>\n",
       "      <td>Niwari</td>\n",
       "      <td>28.88</td>\n",
       "      <td>77.53</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>29.0</td>\n",
       "      <td>mist</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1011.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115558</th>\n",
       "      <td>Saitual</td>\n",
       "      <td>23.97</td>\n",
       "      <td>92.58</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>18.3</td>\n",
       "      <td>clear</td>\n",
       "      <td>3.6</td>\n",
       "      <td>1014.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115559</th>\n",
       "      <td>Ranipet</td>\n",
       "      <td>12.93</td>\n",
       "      <td>79.33</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>25.4</td>\n",
       "      <td>clear</td>\n",
       "      <td>6.3</td>\n",
       "      <td>1014.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115560</th>\n",
       "      <td>Tenkasi</td>\n",
       "      <td>8.97</td>\n",
       "      <td>77.30</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>31.0</td>\n",
       "      <td>mist</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1013.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115561</th>\n",
       "      <td>Pendra</td>\n",
       "      <td>21.93</td>\n",
       "      <td>74.15</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>27.8</td>\n",
       "      <td>clear</td>\n",
       "      <td>6.7</td>\n",
       "      <td>1012.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>115562 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       location_name  latitude  longitude        last_updated  \\\n",
       "0         Ashoknagar     24.57      77.72 2023-08-29 10:45:00   \n",
       "1             Raisen     23.33      77.80 2023-08-29 10:45:00   \n",
       "2         Chhindwara     22.07      78.93 2023-08-29 10:45:00   \n",
       "3              Betul     21.86      77.93 2023-08-29 10:45:00   \n",
       "4        Hoshangabad     22.75      77.72 2023-08-29 10:45:00   \n",
       "...              ...       ...        ...                 ...   \n",
       "115557        Niwari     28.88      77.53 2024-03-30 21:45:00   \n",
       "115558       Saitual     23.97      92.58 2024-03-30 21:45:00   \n",
       "115559       Ranipet     12.93      79.33 2024-03-30 21:45:00   \n",
       "115560       Tenkasi      8.97      77.30 2024-03-30 21:45:00   \n",
       "115561        Pendra     21.93      74.15 2024-03-30 21:45:00   \n",
       "\n",
       "        temperature_celsius condition_text  wind_mph  pressure_mb  precip_mm  \\\n",
       "0                      27.5  partly cloudy      12.8       1008.0        0.0   \n",
       "1                      27.5          sunny       9.6       1008.0        0.0   \n",
       "2                      26.3  partly cloudy      11.4       1009.0        0.0   \n",
       "3                      25.6         cloudy      10.5       1009.0        0.0   \n",
       "4                      27.2         cloudy      10.1       1009.0        0.0   \n",
       "...                     ...            ...       ...          ...        ...   \n",
       "115557                 29.0           mist       2.2       1011.0        0.0   \n",
       "115558                 18.3         clear        3.6       1014.0        0.0   \n",
       "115559                 25.4         clear        6.3       1014.0        0.0   \n",
       "115560                 31.0           mist       2.2       1013.0        0.0   \n",
       "115561                 27.8         clear        6.7       1012.0        0.0   \n",
       "\n",
       "        humidity  \n",
       "0             67  \n",
       "1             70  \n",
       "2             70  \n",
       "3             76  \n",
       "4             74  \n",
       "...          ...  \n",
       "115557        45  \n",
       "115558        79  \n",
       "115559        57  \n",
       "115560        66  \n",
       "115561        23  \n",
       "\n",
       "[115562 rows x 10 columns]"
      ]
     },
     "execution_count": 121,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ed6fcce2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "location_name                  object\n",
       "latitude                      float64\n",
       "longitude                     float64\n",
       "last_updated           datetime64[ns]\n",
       "temperature_celsius           float64\n",
       "condition_text                 object\n",
       "wind_mph                      float64\n",
       "pressure_mb                   float64\n",
       "precip_mm                     float64\n",
       "humidity                        int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 122,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6eb5193f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0         2023\n",
       "1         2023\n",
       "2         2023\n",
       "3         2023\n",
       "4         2023\n",
       "          ... \n",
       "115557    2024\n",
       "115558    2024\n",
       "115559    2024\n",
       "115560    2024\n",
       "115561    2024\n",
       "Name: last_updated, Length: 115562, dtype: int32"
      ]
     },
     "execution_count": 123,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['last_updated'].dt.year"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "71222f70",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Target']=df.shift(-1)['temperature_celsius']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "87e49b91",
   "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>location_name</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>last_updated</th>\n",
       "      <th>temperature_celsius</th>\n",
       "      <th>condition_text</th>\n",
       "      <th>wind_mph</th>\n",
       "      <th>pressure_mb</th>\n",
       "      <th>precip_mm</th>\n",
       "      <th>humidity</th>\n",
       "      <th>Target</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ashoknagar</td>\n",
       "      <td>24.57</td>\n",
       "      <td>77.72</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>27.5</td>\n",
       "      <td>partly cloudy</td>\n",
       "      <td>12.8</td>\n",
       "      <td>1008.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67</td>\n",
       "      <td>27.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Raisen</td>\n",
       "      <td>23.33</td>\n",
       "      <td>77.80</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>27.5</td>\n",
       "      <td>sunny</td>\n",
       "      <td>9.6</td>\n",
       "      <td>1008.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>70</td>\n",
       "      <td>26.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Chhindwara</td>\n",
       "      <td>22.07</td>\n",
       "      <td>78.93</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>26.3</td>\n",
       "      <td>partly cloudy</td>\n",
       "      <td>11.4</td>\n",
       "      <td>1009.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>70</td>\n",
       "      <td>25.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Betul</td>\n",
       "      <td>21.86</td>\n",
       "      <td>77.93</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>25.6</td>\n",
       "      <td>cloudy</td>\n",
       "      <td>10.5</td>\n",
       "      <td>1009.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>76</td>\n",
       "      <td>27.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Hoshangabad</td>\n",
       "      <td>22.75</td>\n",
       "      <td>77.72</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>27.2</td>\n",
       "      <td>cloudy</td>\n",
       "      <td>10.1</td>\n",
       "      <td>1009.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>74</td>\n",
       "      <td>25.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115557</th>\n",
       "      <td>Niwari</td>\n",
       "      <td>28.88</td>\n",
       "      <td>77.53</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>29.0</td>\n",
       "      <td>mist</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1011.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>45</td>\n",
       "      <td>18.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115558</th>\n",
       "      <td>Saitual</td>\n",
       "      <td>23.97</td>\n",
       "      <td>92.58</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>18.3</td>\n",
       "      <td>clear</td>\n",
       "      <td>3.6</td>\n",
       "      <td>1014.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>79</td>\n",
       "      <td>25.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115559</th>\n",
       "      <td>Ranipet</td>\n",
       "      <td>12.93</td>\n",
       "      <td>79.33</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>25.4</td>\n",
       "      <td>clear</td>\n",
       "      <td>6.3</td>\n",
       "      <td>1014.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>57</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115560</th>\n",
       "      <td>Tenkasi</td>\n",
       "      <td>8.97</td>\n",
       "      <td>77.30</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>31.0</td>\n",
       "      <td>mist</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1013.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66</td>\n",
       "      <td>27.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115561</th>\n",
       "      <td>Pendra</td>\n",
       "      <td>21.93</td>\n",
       "      <td>74.15</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>27.8</td>\n",
       "      <td>clear</td>\n",
       "      <td>6.7</td>\n",
       "      <td>1012.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>115562 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       location_name  latitude  longitude        last_updated  \\\n",
       "0         Ashoknagar     24.57      77.72 2023-08-29 10:45:00   \n",
       "1             Raisen     23.33      77.80 2023-08-29 10:45:00   \n",
       "2         Chhindwara     22.07      78.93 2023-08-29 10:45:00   \n",
       "3              Betul     21.86      77.93 2023-08-29 10:45:00   \n",
       "4        Hoshangabad     22.75      77.72 2023-08-29 10:45:00   \n",
       "...              ...       ...        ...                 ...   \n",
       "115557        Niwari     28.88      77.53 2024-03-30 21:45:00   \n",
       "115558       Saitual     23.97      92.58 2024-03-30 21:45:00   \n",
       "115559       Ranipet     12.93      79.33 2024-03-30 21:45:00   \n",
       "115560       Tenkasi      8.97      77.30 2024-03-30 21:45:00   \n",
       "115561        Pendra     21.93      74.15 2024-03-30 21:45:00   \n",
       "\n",
       "        temperature_celsius condition_text  wind_mph  pressure_mb  precip_mm  \\\n",
       "0                      27.5  partly cloudy      12.8       1008.0        0.0   \n",
       "1                      27.5          sunny       9.6       1008.0        0.0   \n",
       "2                      26.3  partly cloudy      11.4       1009.0        0.0   \n",
       "3                      25.6         cloudy      10.5       1009.0        0.0   \n",
       "4                      27.2         cloudy      10.1       1009.0        0.0   \n",
       "...                     ...            ...       ...          ...        ...   \n",
       "115557                 29.0           mist       2.2       1011.0        0.0   \n",
       "115558                 18.3         clear        3.6       1014.0        0.0   \n",
       "115559                 25.4         clear        6.3       1014.0        0.0   \n",
       "115560                 31.0           mist       2.2       1013.0        0.0   \n",
       "115561                 27.8         clear        6.7       1012.0        0.0   \n",
       "\n",
       "        humidity  Target  \n",
       "0             67    27.5  \n",
       "1             70    26.3  \n",
       "2             70    25.6  \n",
       "3             76    27.2  \n",
       "4             74    25.9  \n",
       "...          ...     ...  \n",
       "115557        45    18.3  \n",
       "115558        79    25.4  \n",
       "115559        57    31.0  \n",
       "115560        66    27.8  \n",
       "115561        23     NaN  \n",
       "\n",
       "[115562 rows x 11 columns]"
      ]
     },
     "execution_count": 125,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "278e42e6",
   "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>location_name</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>last_updated</th>\n",
       "      <th>temperature_celsius</th>\n",
       "      <th>condition_text</th>\n",
       "      <th>wind_mph</th>\n",
       "      <th>pressure_mb</th>\n",
       "      <th>precip_mm</th>\n",
       "      <th>humidity</th>\n",
       "      <th>Target</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ashoknagar</td>\n",
       "      <td>24.57</td>\n",
       "      <td>77.72</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>27.5</td>\n",
       "      <td>partly cloudy</td>\n",
       "      <td>12.8</td>\n",
       "      <td>1008.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67</td>\n",
       "      <td>27.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Raisen</td>\n",
       "      <td>23.33</td>\n",
       "      <td>77.80</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>27.5</td>\n",
       "      <td>sunny</td>\n",
       "      <td>9.6</td>\n",
       "      <td>1008.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>70</td>\n",
       "      <td>26.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Chhindwara</td>\n",
       "      <td>22.07</td>\n",
       "      <td>78.93</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>26.3</td>\n",
       "      <td>partly cloudy</td>\n",
       "      <td>11.4</td>\n",
       "      <td>1009.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>70</td>\n",
       "      <td>25.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Betul</td>\n",
       "      <td>21.86</td>\n",
       "      <td>77.93</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>25.6</td>\n",
       "      <td>cloudy</td>\n",
       "      <td>10.5</td>\n",
       "      <td>1009.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>76</td>\n",
       "      <td>27.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Hoshangabad</td>\n",
       "      <td>22.75</td>\n",
       "      <td>77.72</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>27.2</td>\n",
       "      <td>cloudy</td>\n",
       "      <td>10.1</td>\n",
       "      <td>1009.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>74</td>\n",
       "      <td>25.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115557</th>\n",
       "      <td>Niwari</td>\n",
       "      <td>28.88</td>\n",
       "      <td>77.53</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>29.0</td>\n",
       "      <td>mist</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1011.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>45</td>\n",
       "      <td>18.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115558</th>\n",
       "      <td>Saitual</td>\n",
       "      <td>23.97</td>\n",
       "      <td>92.58</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>18.3</td>\n",
       "      <td>clear</td>\n",
       "      <td>3.6</td>\n",
       "      <td>1014.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>79</td>\n",
       "      <td>25.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115559</th>\n",
       "      <td>Ranipet</td>\n",
       "      <td>12.93</td>\n",
       "      <td>79.33</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>25.4</td>\n",
       "      <td>clear</td>\n",
       "      <td>6.3</td>\n",
       "      <td>1014.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>57</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115560</th>\n",
       "      <td>Tenkasi</td>\n",
       "      <td>8.97</td>\n",
       "      <td>77.30</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>31.0</td>\n",
       "      <td>mist</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1013.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66</td>\n",
       "      <td>27.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115561</th>\n",
       "      <td>Pendra</td>\n",
       "      <td>21.93</td>\n",
       "      <td>74.15</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>27.8</td>\n",
       "      <td>clear</td>\n",
       "      <td>6.7</td>\n",
       "      <td>1012.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23</td>\n",
       "      <td>27.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>115562 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       location_name  latitude  longitude        last_updated  \\\n",
       "0         Ashoknagar     24.57      77.72 2023-08-29 10:45:00   \n",
       "1             Raisen     23.33      77.80 2023-08-29 10:45:00   \n",
       "2         Chhindwara     22.07      78.93 2023-08-29 10:45:00   \n",
       "3              Betul     21.86      77.93 2023-08-29 10:45:00   \n",
       "4        Hoshangabad     22.75      77.72 2023-08-29 10:45:00   \n",
       "...              ...       ...        ...                 ...   \n",
       "115557        Niwari     28.88      77.53 2024-03-30 21:45:00   \n",
       "115558       Saitual     23.97      92.58 2024-03-30 21:45:00   \n",
       "115559       Ranipet     12.93      79.33 2024-03-30 21:45:00   \n",
       "115560       Tenkasi      8.97      77.30 2024-03-30 21:45:00   \n",
       "115561        Pendra     21.93      74.15 2024-03-30 21:45:00   \n",
       "\n",
       "        temperature_celsius condition_text  wind_mph  pressure_mb  precip_mm  \\\n",
       "0                      27.5  partly cloudy      12.8       1008.0        0.0   \n",
       "1                      27.5          sunny       9.6       1008.0        0.0   \n",
       "2                      26.3  partly cloudy      11.4       1009.0        0.0   \n",
       "3                      25.6         cloudy      10.5       1009.0        0.0   \n",
       "4                      27.2         cloudy      10.1       1009.0        0.0   \n",
       "...                     ...            ...       ...          ...        ...   \n",
       "115557                 29.0           mist       2.2       1011.0        0.0   \n",
       "115558                 18.3         clear        3.6       1014.0        0.0   \n",
       "115559                 25.4         clear        6.3       1014.0        0.0   \n",
       "115560                 31.0           mist       2.2       1013.0        0.0   \n",
       "115561                 27.8         clear        6.7       1012.0        0.0   \n",
       "\n",
       "        humidity  Target  \n",
       "0             67    27.5  \n",
       "1             70    26.3  \n",
       "2             70    25.6  \n",
       "3             76    27.2  \n",
       "4             74    25.9  \n",
       "...          ...     ...  \n",
       "115557        45    18.3  \n",
       "115558        79    25.4  \n",
       "115559        57    31.0  \n",
       "115560        66    27.8  \n",
       "115561        23    27.8  \n",
       "\n",
       "[115562 rows x 11 columns]"
      ]
     },
     "execution_count": 126,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.ffill()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "fc8f0bed",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.linear_model import Ridge"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "515a4f33",
   "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>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>temperature_celsius</th>\n",
       "      <th>wind_mph</th>\n",
       "      <th>pressure_mb</th>\n",
       "      <th>precip_mm</th>\n",
       "      <th>humidity</th>\n",
       "      <th>Target</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>latitude</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.076130</td>\n",
       "      <td>-0.508373</td>\n",
       "      <td>-0.184791</td>\n",
       "      <td>0.198815</td>\n",
       "      <td>-0.064091</td>\n",
       "      <td>-0.306976</td>\n",
       "      <td>-0.392312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>longitude</th>\n",
       "      <td>0.076130</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.109316</td>\n",
       "      <td>-0.267551</td>\n",
       "      <td>-0.013229</td>\n",
       "      <td>0.041448</td>\n",
       "      <td>0.291353</td>\n",
       "      <td>-0.078985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>temperature_celsius</th>\n",
       "      <td>-0.508373</td>\n",
       "      <td>-0.109316</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.249179</td>\n",
       "      <td>-0.716753</td>\n",
       "      <td>0.061829</td>\n",
       "      <td>0.088251</td>\n",
       "      <td>0.717651</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>wind_mph</th>\n",
       "      <td>-0.184791</td>\n",
       "      <td>-0.267551</td>\n",
       "      <td>0.249179</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.180021</td>\n",
       "      <td>0.057535</td>\n",
       "      <td>-0.098117</td>\n",
       "      <td>0.185023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pressure_mb</th>\n",
       "      <td>0.198815</td>\n",
       "      <td>-0.013229</td>\n",
       "      <td>-0.716753</td>\n",
       "      <td>-0.180021</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.165893</td>\n",
       "      <td>-0.301725</td>\n",
       "      <td>-0.570380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>precip_mm</th>\n",
       "      <td>-0.064091</td>\n",
       "      <td>0.041448</td>\n",
       "      <td>0.061829</td>\n",
       "      <td>0.057535</td>\n",
       "      <td>-0.165893</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.174666</td>\n",
       "      <td>0.065227</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>humidity</th>\n",
       "      <td>-0.306976</td>\n",
       "      <td>0.291353</td>\n",
       "      <td>0.088251</td>\n",
       "      <td>-0.098117</td>\n",
       "      <td>-0.301725</td>\n",
       "      <td>0.174666</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.133852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Target</th>\n",
       "      <td>-0.392312</td>\n",
       "      <td>-0.078985</td>\n",
       "      <td>0.717651</td>\n",
       "      <td>0.185023</td>\n",
       "      <td>-0.570380</td>\n",
       "      <td>0.065227</td>\n",
       "      <td>0.133852</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     latitude  longitude  temperature_celsius  wind_mph  \\\n",
       "latitude             1.000000   0.076130            -0.508373 -0.184791   \n",
       "longitude            0.076130   1.000000            -0.109316 -0.267551   \n",
       "temperature_celsius -0.508373  -0.109316             1.000000  0.249179   \n",
       "wind_mph            -0.184791  -0.267551             0.249179  1.000000   \n",
       "pressure_mb          0.198815  -0.013229            -0.716753 -0.180021   \n",
       "precip_mm           -0.064091   0.041448             0.061829  0.057535   \n",
       "humidity            -0.306976   0.291353             0.088251 -0.098117   \n",
       "Target              -0.392312  -0.078985             0.717651  0.185023   \n",
       "\n",
       "                     pressure_mb  precip_mm  humidity    Target  \n",
       "latitude                0.198815  -0.064091 -0.306976 -0.392312  \n",
       "longitude              -0.013229   0.041448  0.291353 -0.078985  \n",
       "temperature_celsius    -0.716753   0.061829  0.088251  0.717651  \n",
       "wind_mph               -0.180021   0.057535 -0.098117  0.185023  \n",
       "pressure_mb             1.000000  -0.165893 -0.301725 -0.570380  \n",
       "precip_mm              -0.165893   1.000000  0.174666  0.065227  \n",
       "humidity               -0.301725   0.174666  1.000000  0.133852  \n",
       "Target                 -0.570380   0.065227  0.133852  1.000000  "
      ]
     },
     "execution_count": 128,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.corr(numeric_only=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "71022914",
   "metadata": {},
   "outputs": [],
   "source": [
    "rr=Ridge(alpha=.1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "01655736",
   "metadata": {},
   "outputs": [],
   "source": [
    "predictor=df.columns[~df.columns.isin(['location_name','latitude','condition_text','longitude','last_updated','precip_mm','Target'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4e6f934f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['temperature_celsius', 'wind_mph', 'pressure_mb', 'humidity'], dtype='object')"
      ]
     },
     "execution_count": 131,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "predictor"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "76d2e555",
   "metadata": {},
   "outputs": [],
   "source": [
    "def backtest(df,model,predictor,start=3650,step=90):\n",
    "    all_prediction=[]\n",
    "    for i in range(start,df.shape[0],step):\n",
    "        train=df.iloc[:i,:]\n",
    "        test=df.iloc[i:(i+step),:]\n",
    "        \n",
    "        model.fit(train[predictor],train['Target'])\n",
    "        \n",
    "        preds=model.predict(test[predictor])\n",
    "        \n",
    "        preds=pd.Series(preds,index=test.index)\n",
    "        combined=pd.concat([test['Target'],preds],axis=1)\n",
    "        \n",
    "        combined.columns=['actual','prediction']\n",
    "        \n",
    "        combined['diff']=(combined['prediction']-combined['actual']).abs()\n",
    "        \n",
    "        all_prediction.append(round(combined))\n",
    "    return pd.concat(all_prediction)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e392de6a",
   "metadata": {},
   "outputs": [],
   "source": [
    "prediction=backtest(df,rr,predictor)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "af7c695d",
   "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>actual</th>\n",
       "      <th>prediction</th>\n",
       "      <th>diff</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3650</th>\n",
       "      <td>22.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3651</th>\n",
       "      <td>24.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3652</th>\n",
       "      <td>26.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3653</th>\n",
       "      <td>26.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3654</th>\n",
       "      <td>25.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115557</th>\n",
       "      <td>18.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115558</th>\n",
       "      <td>25.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115559</th>\n",
       "      <td>31.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115560</th>\n",
       "      <td>28.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115561</th>\n",
       "      <td>NaN</td>\n",
       "      <td>25.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>111912 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        actual  prediction  diff\n",
       "3650      22.0        24.0   2.0\n",
       "3651      24.0        23.0   2.0\n",
       "3652      26.0        24.0   2.0\n",
       "3653      26.0        24.0   2.0\n",
       "3654      25.0        24.0   1.0\n",
       "...        ...         ...   ...\n",
       "115557    18.0        26.0   7.0\n",
       "115558    25.0        19.0   6.0\n",
       "115559    31.0        23.0   8.0\n",
       "115560    28.0        27.0   1.0\n",
       "115561     NaN        25.0   NaN\n",
       "\n",
       "[111912 rows x 3 columns]"
      ]
     },
     "execution_count": 134,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "prediction"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "bce56e10",
   "metadata": {},
   "outputs": [],
   "source": [
    "prediction.ffill(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e0a43b21",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2.9252090928586747"
      ]
     },
     "execution_count": 136,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn.metrics import mean_absolute_error\n",
    "mean_absolute_error(prediction['actual'],prediction['prediction'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b6bf85c0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2.914102151690614"
      ]
     },
     "execution_count": 137,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "prediction['diff'].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f86c7f7f",
   "metadata": {},
   "outputs": [],
   "source": [
    "def pct_diff(old,new):\n",
    "    return round((new-old)/old)\n",
    "\n",
    "def compute_rolling(df,horizon,col):\n",
    "    label=f'rolling_{horizon}_{col}'\n",
    "    \n",
    "    df[label]=round(df[col].rolling(horizon).mean())\n",
    "    df[f\"{label}_pct\"]=round(pct_diff(df[label],df[col]))\n",
    "    return df\n",
    "\n",
    "rolling_horizons=[3,14]\n",
    "\n",
    "for horizon in rolling_horizons:\n",
    "    for col in ['temperature_celsius', 'wind_mph', 'pressure_mb', 'humidity']:\n",
    "        df=compute_rolling(df,horizon,col)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ceec558a",
   "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>location_name</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>last_updated</th>\n",
       "      <th>temperature_celsius</th>\n",
       "      <th>condition_text</th>\n",
       "      <th>wind_mph</th>\n",
       "      <th>pressure_mb</th>\n",
       "      <th>precip_mm</th>\n",
       "      <th>humidity</th>\n",
       "      <th>...</th>\n",
       "      <th>rolling_14_humidity</th>\n",
       "      <th>rolling_14_humidity_pct</th>\n",
       "      <th>month_avg_temperature_celsius</th>\n",
       "      <th>day_avg_temperature_celsius</th>\n",
       "      <th>month_avg_wind_mph</th>\n",
       "      <th>day_avg_wind_mph</th>\n",
       "      <th>month_avg_pressure_mb</th>\n",
       "      <th>day_avg_pressure_mb</th>\n",
       "      <th>month_avg_humidity</th>\n",
       "      <th>day_avg_humidity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Bhind</td>\n",
       "      <td>26.56</td>\n",
       "      <td>78.79</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>32.4</td>\n",
       "      <td>patchy rain possible</td>\n",
       "      <td>12.8</td>\n",
       "      <td>1005.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>50</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32.400000</td>\n",
       "      <td>32.400000</td>\n",
       "      <td>12.800000</td>\n",
       "      <td>12.800000</td>\n",
       "      <td>1005.000000</td>\n",
       "      <td>1005.000000</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>50.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Jhabua</td>\n",
       "      <td>22.77</td>\n",
       "      <td>74.60</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>27.3</td>\n",
       "      <td>cloudy</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1009.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29.850000</td>\n",
       "      <td>29.850000</td>\n",
       "      <td>12.900000</td>\n",
       "      <td>12.900000</td>\n",
       "      <td>1007.000000</td>\n",
       "      <td>1007.000000</td>\n",
       "      <td>56.500000</td>\n",
       "      <td>56.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Seoni</td>\n",
       "      <td>22.08</td>\n",
       "      <td>79.53</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>26.7</td>\n",
       "      <td>partly cloudy</td>\n",
       "      <td>10.7</td>\n",
       "      <td>1008.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>69</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.800000</td>\n",
       "      <td>28.800000</td>\n",
       "      <td>12.166667</td>\n",
       "      <td>12.166667</td>\n",
       "      <td>1007.333333</td>\n",
       "      <td>1007.333333</td>\n",
       "      <td>60.666667</td>\n",
       "      <td>60.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Khandwa</td>\n",
       "      <td>21.83</td>\n",
       "      <td>76.33</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>28.2</td>\n",
       "      <td>cloudy</td>\n",
       "      <td>10.1</td>\n",
       "      <td>1009.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.650000</td>\n",
       "      <td>28.650000</td>\n",
       "      <td>11.650000</td>\n",
       "      <td>11.650000</td>\n",
       "      <td>1007.750000</td>\n",
       "      <td>1007.750000</td>\n",
       "      <td>61.500000</td>\n",
       "      <td>61.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Umaria</td>\n",
       "      <td>23.53</td>\n",
       "      <td>80.83</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>27.0</td>\n",
       "      <td>patchy rain possible</td>\n",
       "      <td>9.6</td>\n",
       "      <td>1007.0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>74</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.320000</td>\n",
       "      <td>28.320000</td>\n",
       "      <td>11.240000</td>\n",
       "      <td>11.240000</td>\n",
       "      <td>1007.600000</td>\n",
       "      <td>1007.600000</td>\n",
       "      <td>64.000000</td>\n",
       "      <td>64.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115557</th>\n",
       "      <td>Niwari</td>\n",
       "      <td>28.88</td>\n",
       "      <td>77.53</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>29.0</td>\n",
       "      <td>mist</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1011.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>45</td>\n",
       "      <td>...</td>\n",
       "      <td>56.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>23.314576</td>\n",
       "      <td>27.018635</td>\n",
       "      <td>5.973272</td>\n",
       "      <td>6.814576</td>\n",
       "      <td>1012.943754</td>\n",
       "      <td>1011.747232</td>\n",
       "      <td>44.733090</td>\n",
       "      <td>47.461255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115558</th>\n",
       "      <td>Saitual</td>\n",
       "      <td>23.97</td>\n",
       "      <td>92.58</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>18.3</td>\n",
       "      <td>clear</td>\n",
       "      <td>3.6</td>\n",
       "      <td>1014.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>79</td>\n",
       "      <td>...</td>\n",
       "      <td>58.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23.314271</td>\n",
       "      <td>27.002578</td>\n",
       "      <td>5.973128</td>\n",
       "      <td>6.808656</td>\n",
       "      <td>1012.943818</td>\n",
       "      <td>1011.751381</td>\n",
       "      <td>44.735178</td>\n",
       "      <td>47.519337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115559</th>\n",
       "      <td>Ranipet</td>\n",
       "      <td>12.93</td>\n",
       "      <td>79.33</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>25.4</td>\n",
       "      <td>clear</td>\n",
       "      <td>6.3</td>\n",
       "      <td>1014.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>57</td>\n",
       "      <td>...</td>\n",
       "      <td>59.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>23.314398</td>\n",
       "      <td>26.999632</td>\n",
       "      <td>5.973148</td>\n",
       "      <td>6.807721</td>\n",
       "      <td>1012.943883</td>\n",
       "      <td>1011.755515</td>\n",
       "      <td>44.735925</td>\n",
       "      <td>47.536765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115560</th>\n",
       "      <td>Tenkasi</td>\n",
       "      <td>8.97</td>\n",
       "      <td>77.30</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>31.0</td>\n",
       "      <td>mist</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1013.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66</td>\n",
       "      <td>...</td>\n",
       "      <td>62.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23.314866</td>\n",
       "      <td>27.006972</td>\n",
       "      <td>5.972918</td>\n",
       "      <td>6.799266</td>\n",
       "      <td>1012.943886</td>\n",
       "      <td>1011.757798</td>\n",
       "      <td>44.737220</td>\n",
       "      <td>47.570642</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115561</th>\n",
       "      <td>Pendra</td>\n",
       "      <td>21.93</td>\n",
       "      <td>74.15</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>27.8</td>\n",
       "      <td>clear</td>\n",
       "      <td>6.7</td>\n",
       "      <td>1012.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23</td>\n",
       "      <td>...</td>\n",
       "      <td>58.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>23.315140</td>\n",
       "      <td>27.008425</td>\n",
       "      <td>5.972962</td>\n",
       "      <td>6.799084</td>\n",
       "      <td>1012.943828</td>\n",
       "      <td>1011.758242</td>\n",
       "      <td>44.735896</td>\n",
       "      <td>47.525641</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>115534 rows × 35 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       location_name  latitude  longitude        last_updated  \\\n",
       "28             Bhind     26.56      78.79 2023-08-29 10:45:00   \n",
       "29            Jhabua     22.77      74.60 2023-08-29 10:45:00   \n",
       "30             Seoni     22.08      79.53 2023-08-29 10:45:00   \n",
       "31           Khandwa     21.83      76.33 2023-08-29 10:45:00   \n",
       "32            Umaria     23.53      80.83 2023-08-29 10:45:00   \n",
       "...              ...       ...        ...                 ...   \n",
       "115557        Niwari     28.88      77.53 2024-03-30 21:45:00   \n",
       "115558       Saitual     23.97      92.58 2024-03-30 21:45:00   \n",
       "115559       Ranipet     12.93      79.33 2024-03-30 21:45:00   \n",
       "115560       Tenkasi      8.97      77.30 2024-03-30 21:45:00   \n",
       "115561        Pendra     21.93      74.15 2024-03-30 21:45:00   \n",
       "\n",
       "        temperature_celsius        condition_text  wind_mph  pressure_mb  \\\n",
       "28                     32.4  patchy rain possible      12.8       1005.0   \n",
       "29                     27.3                cloudy      13.0       1009.0   \n",
       "30                     26.7         partly cloudy      10.7       1008.0   \n",
       "31                     28.2                cloudy      10.1       1009.0   \n",
       "32                     27.0  patchy rain possible       9.6       1007.0   \n",
       "...                     ...                   ...       ...          ...   \n",
       "115557                 29.0                  mist       2.2       1011.0   \n",
       "115558                 18.3                clear        3.6       1014.0   \n",
       "115559                 25.4                clear        6.3       1014.0   \n",
       "115560                 31.0                  mist       2.2       1013.0   \n",
       "115561                 27.8                clear        6.7       1012.0   \n",
       "\n",
       "        precip_mm  humidity  ...  rolling_14_humidity  \\\n",
       "28            0.1        50  ...                  NaN   \n",
       "29            0.0        63  ...                  NaN   \n",
       "30            0.0        69  ...                  NaN   \n",
       "31            0.0        64  ...                  NaN   \n",
       "32            0.2        74  ...                  NaN   \n",
       "...           ...       ...  ...                  ...   \n",
       "115557        0.0        45  ...                 56.0   \n",
       "115558        0.0        79  ...                 58.0   \n",
       "115559        0.0        57  ...                 59.0   \n",
       "115560        0.0        66  ...                 62.0   \n",
       "115561        0.0        23  ...                 58.0   \n",
       "\n",
       "        rolling_14_humidity_pct  month_avg_temperature_celsius  \\\n",
       "28                          NaN                      32.400000   \n",
       "29                          NaN                      29.850000   \n",
       "30                          NaN                      28.800000   \n",
       "31                          NaN                      28.650000   \n",
       "32                          NaN                      28.320000   \n",
       "...                         ...                            ...   \n",
       "115557                     -0.0                      23.314576   \n",
       "115558                      0.0                      23.314271   \n",
       "115559                     -0.0                      23.314398   \n",
       "115560                      0.0                      23.314866   \n",
       "115561                     -1.0                      23.315140   \n",
       "\n",
       "        day_avg_temperature_celsius  month_avg_wind_mph  day_avg_wind_mph  \\\n",
       "28                        32.400000           12.800000         12.800000   \n",
       "29                        29.850000           12.900000         12.900000   \n",
       "30                        28.800000           12.166667         12.166667   \n",
       "31                        28.650000           11.650000         11.650000   \n",
       "32                        28.320000           11.240000         11.240000   \n",
       "...                             ...                 ...               ...   \n",
       "115557                    27.018635            5.973272          6.814576   \n",
       "115558                    27.002578            5.973128          6.808656   \n",
       "115559                    26.999632            5.973148          6.807721   \n",
       "115560                    27.006972            5.972918          6.799266   \n",
       "115561                    27.008425            5.972962          6.799084   \n",
       "\n",
       "        month_avg_pressure_mb  day_avg_pressure_mb  month_avg_humidity  \\\n",
       "28                1005.000000          1005.000000           50.000000   \n",
       "29                1007.000000          1007.000000           56.500000   \n",
       "30                1007.333333          1007.333333           60.666667   \n",
       "31                1007.750000          1007.750000           61.500000   \n",
       "32                1007.600000          1007.600000           64.000000   \n",
       "...                       ...                  ...                 ...   \n",
       "115557            1012.943754          1011.747232           44.733090   \n",
       "115558            1012.943818          1011.751381           44.735178   \n",
       "115559            1012.943883          1011.755515           44.735925   \n",
       "115560            1012.943886          1011.757798           44.737220   \n",
       "115561            1012.943828          1011.758242           44.735896   \n",
       "\n",
       "        day_avg_humidity  \n",
       "28             50.000000  \n",
       "29             56.500000  \n",
       "30             60.666667  \n",
       "31             61.500000  \n",
       "32             64.000000  \n",
       "...                  ...  \n",
       "115557         47.461255  \n",
       "115558         47.519337  \n",
       "115559         47.536765  \n",
       "115560         47.570642  \n",
       "115561         47.525641  \n",
       "\n",
       "[115534 rows x 35 columns]"
      ]
     },
     "execution_count": 96,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "07f0c5d8",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=df.iloc[14:,:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3ed9634f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "31f33bcc",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 115534 entries, 28 to 115561\n",
      "Data columns (total 35 columns):\n",
      " #   Column                              Non-Null Count   Dtype         \n",
      "---  ------                              --------------   -----         \n",
      " 0   location_name                       115534 non-null  object        \n",
      " 1   latitude                            115534 non-null  float64       \n",
      " 2   longitude                           115534 non-null  float64       \n",
      " 3   last_updated                        115534 non-null  datetime64[ns]\n",
      " 4   temperature_celsius                 115534 non-null  float64       \n",
      " 5   condition_text                      115534 non-null  object        \n",
      " 6   wind_mph                            115534 non-null  float64       \n",
      " 7   pressure_mb                         115534 non-null  float64       \n",
      " 8   precip_mm                           115534 non-null  float64       \n",
      " 9   humidity                            115534 non-null  int64         \n",
      " 10  Target                              115533 non-null  float64       \n",
      " 11  rolling_3_temperature_celsius       115534 non-null  float64       \n",
      " 12  rolling_3_temperature_celsius_pct   115534 non-null  float64       \n",
      " 13  rolling_3_wind_mph                  115534 non-null  float64       \n",
      " 14  rolling_3_wind_mph_pct              115534 non-null  float64       \n",
      " 15  rolling_3_pressure_mb               115534 non-null  float64       \n",
      " 16  rolling_3_pressure_mb_pct           115534 non-null  float64       \n",
      " 17  rolling_3_humidity                  115534 non-null  float64       \n",
      " 18  rolling_3_humidity_pct              115534 non-null  float64       \n",
      " 19  rolling_14_temperature_celsius      115534 non-null  float64       \n",
      " 20  rolling_14_temperature_celsius_pct  115534 non-null  float64       \n",
      " 21  rolling_14_wind_mph                 115534 non-null  float64       \n",
      " 22  rolling_14_wind_mph_pct             115534 non-null  float64       \n",
      " 23  rolling_14_pressure_mb              115534 non-null  float64       \n",
      " 24  rolling_14_pressure_mb_pct          115534 non-null  float64       \n",
      " 25  rolling_14_humidity                 115534 non-null  float64       \n",
      " 26  rolling_14_humidity_pct             115534 non-null  float64       \n",
      " 27  month_avg_temperature_celsius       115534 non-null  float64       \n",
      " 28  day_avg_temperature_celsius         115534 non-null  float64       \n",
      " 29  month_avg_wind_mph                  115534 non-null  float64       \n",
      " 30  day_avg_wind_mph                    115534 non-null  float64       \n",
      " 31  month_avg_pressure_mb               115534 non-null  float64       \n",
      " 32  day_avg_pressure_mb                 115534 non-null  float64       \n",
      " 33  month_avg_humidity                  115534 non-null  float64       \n",
      " 34  day_avg_humidity                    115534 non-null  float64       \n",
      "dtypes: datetime64[ns](1), float64(31), int64(1), object(2)\n",
      "memory usage: 30.9+ MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f6c12902",
   "metadata": {},
   "outputs": [],
   "source": [
    "def expand_mean(df1):\n",
    "    return df1.expanding(1).mean()\n",
    "for col in ['temperature_celsius', 'wind_mph', 'pressure_mb', 'humidity']:\n",
    "    df[f\"month_avg_{col}\"]=df[col].groupby(df['last_updated'].dt.month,group_keys=False).apply(expand_mean)\n",
    "    df[f\"day_avg_{col}\"]=df[col].groupby(df['last_updated'].dt.day_of_year,group_keys=False).apply(expand_mean)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "fea62788",
   "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>location_name</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>last_updated</th>\n",
       "      <th>temperature_celsius</th>\n",
       "      <th>condition_text</th>\n",
       "      <th>wind_mph</th>\n",
       "      <th>pressure_mb</th>\n",
       "      <th>precip_mm</th>\n",
       "      <th>humidity</th>\n",
       "      <th>...</th>\n",
       "      <th>rolling_14_humidity</th>\n",
       "      <th>rolling_14_humidity_pct</th>\n",
       "      <th>month_avg_temperature_celsius</th>\n",
       "      <th>day_avg_temperature_celsius</th>\n",
       "      <th>month_avg_wind_mph</th>\n",
       "      <th>day_avg_wind_mph</th>\n",
       "      <th>month_avg_pressure_mb</th>\n",
       "      <th>day_avg_pressure_mb</th>\n",
       "      <th>month_avg_humidity</th>\n",
       "      <th>day_avg_humidity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Bhind</td>\n",
       "      <td>26.56</td>\n",
       "      <td>78.79</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>32.4</td>\n",
       "      <td>patchy rain possible</td>\n",
       "      <td>12.8</td>\n",
       "      <td>1005.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>50</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32.400000</td>\n",
       "      <td>32.400000</td>\n",
       "      <td>12.800000</td>\n",
       "      <td>12.800000</td>\n",
       "      <td>1005.000000</td>\n",
       "      <td>1005.000000</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>50.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Jhabua</td>\n",
       "      <td>22.77</td>\n",
       "      <td>74.60</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>27.3</td>\n",
       "      <td>cloudy</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1009.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29.850000</td>\n",
       "      <td>29.850000</td>\n",
       "      <td>12.900000</td>\n",
       "      <td>12.900000</td>\n",
       "      <td>1007.000000</td>\n",
       "      <td>1007.000000</td>\n",
       "      <td>56.500000</td>\n",
       "      <td>56.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Seoni</td>\n",
       "      <td>22.08</td>\n",
       "      <td>79.53</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>26.7</td>\n",
       "      <td>partly cloudy</td>\n",
       "      <td>10.7</td>\n",
       "      <td>1008.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>69</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.800000</td>\n",
       "      <td>28.800000</td>\n",
       "      <td>12.166667</td>\n",
       "      <td>12.166667</td>\n",
       "      <td>1007.333333</td>\n",
       "      <td>1007.333333</td>\n",
       "      <td>60.666667</td>\n",
       "      <td>60.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Khandwa</td>\n",
       "      <td>21.83</td>\n",
       "      <td>76.33</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>28.2</td>\n",
       "      <td>cloudy</td>\n",
       "      <td>10.1</td>\n",
       "      <td>1009.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.650000</td>\n",
       "      <td>28.650000</td>\n",
       "      <td>11.650000</td>\n",
       "      <td>11.650000</td>\n",
       "      <td>1007.750000</td>\n",
       "      <td>1007.750000</td>\n",
       "      <td>61.500000</td>\n",
       "      <td>61.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Umaria</td>\n",
       "      <td>23.53</td>\n",
       "      <td>80.83</td>\n",
       "      <td>2023-08-29 10:45:00</td>\n",
       "      <td>27.0</td>\n",
       "      <td>patchy rain possible</td>\n",
       "      <td>9.6</td>\n",
       "      <td>1007.0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>74</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.320000</td>\n",
       "      <td>28.320000</td>\n",
       "      <td>11.240000</td>\n",
       "      <td>11.240000</td>\n",
       "      <td>1007.600000</td>\n",
       "      <td>1007.600000</td>\n",
       "      <td>64.000000</td>\n",
       "      <td>64.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115557</th>\n",
       "      <td>Niwari</td>\n",
       "      <td>28.88</td>\n",
       "      <td>77.53</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>29.0</td>\n",
       "      <td>mist</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1011.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>45</td>\n",
       "      <td>...</td>\n",
       "      <td>56.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>23.314576</td>\n",
       "      <td>27.018635</td>\n",
       "      <td>5.973272</td>\n",
       "      <td>6.814576</td>\n",
       "      <td>1012.943754</td>\n",
       "      <td>1011.747232</td>\n",
       "      <td>44.733090</td>\n",
       "      <td>47.461255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115558</th>\n",
       "      <td>Saitual</td>\n",
       "      <td>23.97</td>\n",
       "      <td>92.58</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>18.3</td>\n",
       "      <td>clear</td>\n",
       "      <td>3.6</td>\n",
       "      <td>1014.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>79</td>\n",
       "      <td>...</td>\n",
       "      <td>58.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23.314271</td>\n",
       "      <td>27.002578</td>\n",
       "      <td>5.973128</td>\n",
       "      <td>6.808656</td>\n",
       "      <td>1012.943818</td>\n",
       "      <td>1011.751381</td>\n",
       "      <td>44.735178</td>\n",
       "      <td>47.519337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115559</th>\n",
       "      <td>Ranipet</td>\n",
       "      <td>12.93</td>\n",
       "      <td>79.33</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>25.4</td>\n",
       "      <td>clear</td>\n",
       "      <td>6.3</td>\n",
       "      <td>1014.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>57</td>\n",
       "      <td>...</td>\n",
       "      <td>59.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>23.314398</td>\n",
       "      <td>26.999632</td>\n",
       "      <td>5.973148</td>\n",
       "      <td>6.807721</td>\n",
       "      <td>1012.943883</td>\n",
       "      <td>1011.755515</td>\n",
       "      <td>44.735925</td>\n",
       "      <td>47.536765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115560</th>\n",
       "      <td>Tenkasi</td>\n",
       "      <td>8.97</td>\n",
       "      <td>77.30</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>31.0</td>\n",
       "      <td>mist</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1013.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66</td>\n",
       "      <td>...</td>\n",
       "      <td>62.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23.314866</td>\n",
       "      <td>27.006972</td>\n",
       "      <td>5.972918</td>\n",
       "      <td>6.799266</td>\n",
       "      <td>1012.943886</td>\n",
       "      <td>1011.757798</td>\n",
       "      <td>44.737220</td>\n",
       "      <td>47.570642</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115561</th>\n",
       "      <td>Pendra</td>\n",
       "      <td>21.93</td>\n",
       "      <td>74.15</td>\n",
       "      <td>2024-03-30 21:45:00</td>\n",
       "      <td>27.8</td>\n",
       "      <td>clear</td>\n",
       "      <td>6.7</td>\n",
       "      <td>1012.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23</td>\n",
       "      <td>...</td>\n",
       "      <td>58.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>23.315140</td>\n",
       "      <td>27.008425</td>\n",
       "      <td>5.972962</td>\n",
       "      <td>6.799084</td>\n",
       "      <td>1012.943828</td>\n",
       "      <td>1011.758242</td>\n",
       "      <td>44.735896</td>\n",
       "      <td>47.525641</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>115534 rows × 35 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       location_name  latitude  longitude        last_updated  \\\n",
       "28             Bhind     26.56      78.79 2023-08-29 10:45:00   \n",
       "29            Jhabua     22.77      74.60 2023-08-29 10:45:00   \n",
       "30             Seoni     22.08      79.53 2023-08-29 10:45:00   \n",
       "31           Khandwa     21.83      76.33 2023-08-29 10:45:00   \n",
       "32            Umaria     23.53      80.83 2023-08-29 10:45:00   \n",
       "...              ...       ...        ...                 ...   \n",
       "115557        Niwari     28.88      77.53 2024-03-30 21:45:00   \n",
       "115558       Saitual     23.97      92.58 2024-03-30 21:45:00   \n",
       "115559       Ranipet     12.93      79.33 2024-03-30 21:45:00   \n",
       "115560       Tenkasi      8.97      77.30 2024-03-30 21:45:00   \n",
       "115561        Pendra     21.93      74.15 2024-03-30 21:45:00   \n",
       "\n",
       "        temperature_celsius        condition_text  wind_mph  pressure_mb  \\\n",
       "28                     32.4  patchy rain possible      12.8       1005.0   \n",
       "29                     27.3                cloudy      13.0       1009.0   \n",
       "30                     26.7         partly cloudy      10.7       1008.0   \n",
       "31                     28.2                cloudy      10.1       1009.0   \n",
       "32                     27.0  patchy rain possible       9.6       1007.0   \n",
       "...                     ...                   ...       ...          ...   \n",
       "115557                 29.0                  mist       2.2       1011.0   \n",
       "115558                 18.3                clear        3.6       1014.0   \n",
       "115559                 25.4                clear        6.3       1014.0   \n",
       "115560                 31.0                  mist       2.2       1013.0   \n",
       "115561                 27.8                clear        6.7       1012.0   \n",
       "\n",
       "        precip_mm  humidity  ...  rolling_14_humidity  \\\n",
       "28            0.1        50  ...                  NaN   \n",
       "29            0.0        63  ...                  NaN   \n",
       "30            0.0        69  ...                  NaN   \n",
       "31            0.0        64  ...                  NaN   \n",
       "32            0.2        74  ...                  NaN   \n",
       "...           ...       ...  ...                  ...   \n",
       "115557        0.0        45  ...                 56.0   \n",
       "115558        0.0        79  ...                 58.0   \n",
       "115559        0.0        57  ...                 59.0   \n",
       "115560        0.0        66  ...                 62.0   \n",
       "115561        0.0        23  ...                 58.0   \n",
       "\n",
       "        rolling_14_humidity_pct  month_avg_temperature_celsius  \\\n",
       "28                          NaN                      32.400000   \n",
       "29                          NaN                      29.850000   \n",
       "30                          NaN                      28.800000   \n",
       "31                          NaN                      28.650000   \n",
       "32                          NaN                      28.320000   \n",
       "...                         ...                            ...   \n",
       "115557                     -0.0                      23.314576   \n",
       "115558                      0.0                      23.314271   \n",
       "115559                     -0.0                      23.314398   \n",
       "115560                      0.0                      23.314866   \n",
       "115561                     -1.0                      23.315140   \n",
       "\n",
       "        day_avg_temperature_celsius  month_avg_wind_mph  day_avg_wind_mph  \\\n",
       "28                        32.400000           12.800000         12.800000   \n",
       "29                        29.850000           12.900000         12.900000   \n",
       "30                        28.800000           12.166667         12.166667   \n",
       "31                        28.650000           11.650000         11.650000   \n",
       "32                        28.320000           11.240000         11.240000   \n",
       "...                             ...                 ...               ...   \n",
       "115557                    27.018635            5.973272          6.814576   \n",
       "115558                    27.002578            5.973128          6.808656   \n",
       "115559                    26.999632            5.973148          6.807721   \n",
       "115560                    27.006972            5.972918          6.799266   \n",
       "115561                    27.008425            5.972962          6.799084   \n",
       "\n",
       "        month_avg_pressure_mb  day_avg_pressure_mb  month_avg_humidity  \\\n",
       "28                1005.000000          1005.000000           50.000000   \n",
       "29                1007.000000          1007.000000           56.500000   \n",
       "30                1007.333333          1007.333333           60.666667   \n",
       "31                1007.750000          1007.750000           61.500000   \n",
       "32                1007.600000          1007.600000           64.000000   \n",
       "...                       ...                  ...                 ...   \n",
       "115557            1012.943754          1011.747232           44.733090   \n",
       "115558            1012.943818          1011.751381           44.735178   \n",
       "115559            1012.943883          1011.755515           44.735925   \n",
       "115560            1012.943886          1011.757798           44.737220   \n",
       "115561            1012.943828          1011.758242           44.735896   \n",
       "\n",
       "        day_avg_humidity  \n",
       "28             50.000000  \n",
       "29             56.500000  \n",
       "30             60.666667  \n",
       "31             61.500000  \n",
       "32             64.000000  \n",
       "...                  ...  \n",
       "115557         47.461255  \n",
       "115558         47.519337  \n",
       "115559         47.536765  \n",
       "115560         47.570642  \n",
       "115561         47.525641  \n",
       "\n",
       "[115534 rows x 35 columns]"
      ]
     },
     "execution_count": 98,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f17d9795",
   "metadata": {},
   "outputs": [],
   "source": [
    "predictor=df.columns[~df.columns.isin(['location_name','latitude','condition_text','longitude','last_updated','precip_mm','Target'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "99300894",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['temperature_celsius', 'wind_mph', 'pressure_mb', 'humidity',\n",
       "       'rolling_3_temperature_celsius', 'rolling_3_temperature_celsius_pct',\n",
       "       'rolling_3_wind_mph', 'rolling_3_wind_mph_pct', 'rolling_3_pressure_mb',\n",
       "       'rolling_3_pressure_mb_pct', 'rolling_3_humidity',\n",
       "       'rolling_3_humidity_pct', 'rolling_14_temperature_celsius',\n",
       "       'rolling_14_temperature_celsius_pct', 'rolling_14_wind_mph',\n",
       "       'rolling_14_wind_mph_pct', 'rolling_14_pressure_mb',\n",
       "       'rolling_14_pressure_mb_pct', 'rolling_14_humidity',\n",
       "       'rolling_14_humidity_pct', 'month_avg_temperature_celsius',\n",
       "       'day_avg_temperature_celsius', 'month_avg_wind_mph', 'day_avg_wind_mph',\n",
       "       'month_avg_pressure_mb', 'day_avg_pressure_mb', 'month_avg_humidity',\n",
       "       'day_avg_humidity'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 100,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "predictor"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "7da8247e",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "cabcdbd1",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "737b85bb",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "52b12111",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8667cb86",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.12.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}