air_quality_t.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "air_quality_t.ipynb",
      "version": "0.3.2",
      "provenance": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "display_name": "Python 3",
      "language": "python",
      "name": "python3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/ndk03/Air-Quality-Prediction/blob/master/air_quality_t.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "metadata": {
        "id": "jLERY6mWUGyi",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n",
        "import matplotlib.pyplot as plt\n",
        "%matplotlib inline\n",
        "import seaborn as snc\n",
        "import tensorflow as tf\n",
        "from tensorflow.python.keras.models import Sequential\n",
        "from tensorflow.python.keras.layers import Dense\n",
        "from tensorflow.python.keras.wrappers.scikit_learn import KerasRegressor\n",
        "from sklearn.model_selection import KFold\n",
        "from sklearn.model_selection import cross_val_score\n",
        "from tensorflow.python.keras.layers.core import Dense, Activation"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "3o7fUpSvUGys",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "air_quality = pd.read_csv(\"AirQualityUCI.csv\", sep=\";\", decimal=\",\")"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "t1SeKcSgUGyx",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "air_quality.dropna(axis=0, how= 'all', inplace=True)\n",
        "air_quality.dropna(axis=1, inplace=True)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "scrolled": true,
        "id": "VB4uXK09UGy3",
        "colab_type": "code",
        "colab": {},
        "outputId": "d9dd1608-3024-49e0-fbdf-4751841f8310"
      },
      "cell_type": "code",
      "source": [
        "air_quality.replace(to_replace= -200, value= np.NaN, inplace= True)\n",
        "air_quality"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Date</th>\n",
              "      <th>Time</th>\n",
              "      <th>CO(GT)</th>\n",
              "      <th>PT08.S1(CO)</th>\n",
              "      <th>NMHC(GT)</th>\n",
              "      <th>C6H6(GT)</th>\n",
              "      <th>PT08.S2(NMHC)</th>\n",
              "      <th>NOx(GT)</th>\n",
              "      <th>PT08.S3(NOx)</th>\n",
              "      <th>NO2(GT)</th>\n",
              "      <th>PT08.S4(NO2)</th>\n",
              "      <th>PT08.S5(O3)</th>\n",
              "      <th>T</th>\n",
              "      <th>RH</th>\n",
              "      <th>AH</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>10/03/2004</td>\n",
              "      <td>18.00.00</td>\n",
              "      <td>2.6</td>\n",
              "      <td>1360.0</td>\n",
              "      <td>150.0</td>\n",
              "      <td>11.9</td>\n",
              "      <td>1046.0</td>\n",
              "      <td>166.0</td>\n",
              "      <td>1056.0</td>\n",
              "      <td>113.0</td>\n",
              "      <td>1692.0</td>\n",
              "      <td>1268.0</td>\n",
              "      <td>13.6</td>\n",
              "      <td>48.9</td>\n",
              "      <td>0.7578</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>10/03/2004</td>\n",
              "      <td>19.00.00</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1292.0</td>\n",
              "      <td>112.0</td>\n",
              "      <td>9.4</td>\n",
              "      <td>955.0</td>\n",
              "      <td>103.0</td>\n",
              "      <td>1174.0</td>\n",
              "      <td>92.0</td>\n",
              "      <td>1559.0</td>\n",
              "      <td>972.0</td>\n",
              "      <td>13.3</td>\n",
              "      <td>47.7</td>\n",
              "      <td>0.7255</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>10/03/2004</td>\n",
              "      <td>20.00.00</td>\n",
              "      <td>2.2</td>\n",
              "      <td>1402.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>939.0</td>\n",
              "      <td>131.0</td>\n",
              "      <td>1140.0</td>\n",
              "      <td>114.0</td>\n",
              "      <td>1555.0</td>\n",
              "      <td>1074.0</td>\n",
              "      <td>11.9</td>\n",
              "      <td>54.0</td>\n",
              "      <td>0.7502</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>10/03/2004</td>\n",
              "      <td>21.00.00</td>\n",
              "      <td>2.2</td>\n",
              "      <td>1376.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>9.2</td>\n",
              "      <td>948.0</td>\n",
              "      <td>172.0</td>\n",
              "      <td>1092.0</td>\n",
              "      <td>122.0</td>\n",
              "      <td>1584.0</td>\n",
              "      <td>1203.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>60.0</td>\n",
              "      <td>0.7867</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>10/03/2004</td>\n",
              "      <td>22.00.00</td>\n",
              "      <td>1.6</td>\n",
              "      <td>1272.0</td>\n",
              "      <td>51.0</td>\n",
              "      <td>6.5</td>\n",
              "      <td>836.0</td>\n",
              "      <td>131.0</td>\n",
              "      <td>1205.0</td>\n",
              "      <td>116.0</td>\n",
              "      <td>1490.0</td>\n",
              "      <td>1110.0</td>\n",
              "      <td>11.2</td>\n",
              "      <td>59.6</td>\n",
              "      <td>0.7888</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>10/03/2004</td>\n",
              "      <td>23.00.00</td>\n",
              "      <td>1.2</td>\n",
              "      <td>1197.0</td>\n",
              "      <td>38.0</td>\n",
              "      <td>4.7</td>\n",
              "      <td>750.0</td>\n",
              "      <td>89.0</td>\n",
              "      <td>1337.0</td>\n",
              "      <td>96.0</td>\n",
              "      <td>1393.0</td>\n",
              "      <td>949.0</td>\n",
              "      <td>11.2</td>\n",
              "      <td>59.2</td>\n",
              "      <td>0.7848</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>00.00.00</td>\n",
              "      <td>1.2</td>\n",
              "      <td>1185.0</td>\n",
              "      <td>31.0</td>\n",
              "      <td>3.6</td>\n",
              "      <td>690.0</td>\n",
              "      <td>62.0</td>\n",
              "      <td>1462.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>1333.0</td>\n",
              "      <td>733.0</td>\n",
              "      <td>11.3</td>\n",
              "      <td>56.8</td>\n",
              "      <td>0.7603</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>01.00.00</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1136.0</td>\n",
              "      <td>31.0</td>\n",
              "      <td>3.3</td>\n",
              "      <td>672.0</td>\n",
              "      <td>62.0</td>\n",
              "      <td>1453.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>1333.0</td>\n",
              "      <td>730.0</td>\n",
              "      <td>10.7</td>\n",
              "      <td>60.0</td>\n",
              "      <td>0.7702</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>02.00.00</td>\n",
              "      <td>0.9</td>\n",
              "      <td>1094.0</td>\n",
              "      <td>24.0</td>\n",
              "      <td>2.3</td>\n",
              "      <td>609.0</td>\n",
              "      <td>45.0</td>\n",
              "      <td>1579.0</td>\n",
              "      <td>60.0</td>\n",
              "      <td>1276.0</td>\n",
              "      <td>620.0</td>\n",
              "      <td>10.7</td>\n",
              "      <td>59.7</td>\n",
              "      <td>0.7648</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>03.00.00</td>\n",
              "      <td>0.6</td>\n",
              "      <td>1010.0</td>\n",
              "      <td>19.0</td>\n",
              "      <td>1.7</td>\n",
              "      <td>561.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1705.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1235.0</td>\n",
              "      <td>501.0</td>\n",
              "      <td>10.3</td>\n",
              "      <td>60.2</td>\n",
              "      <td>0.7517</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>04.00.00</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1011.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>1.3</td>\n",
              "      <td>527.0</td>\n",
              "      <td>21.0</td>\n",
              "      <td>1818.0</td>\n",
              "      <td>34.0</td>\n",
              "      <td>1197.0</td>\n",
              "      <td>445.0</td>\n",
              "      <td>10.1</td>\n",
              "      <td>60.5</td>\n",
              "      <td>0.7465</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>05.00.00</td>\n",
              "      <td>0.7</td>\n",
              "      <td>1066.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>1.1</td>\n",
              "      <td>512.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>1918.0</td>\n",
              "      <td>28.0</td>\n",
              "      <td>1182.0</td>\n",
              "      <td>422.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>56.2</td>\n",
              "      <td>0.7366</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>06.00.00</td>\n",
              "      <td>0.7</td>\n",
              "      <td>1052.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>1.6</td>\n",
              "      <td>553.0</td>\n",
              "      <td>34.0</td>\n",
              "      <td>1738.0</td>\n",
              "      <td>48.0</td>\n",
              "      <td>1221.0</td>\n",
              "      <td>472.0</td>\n",
              "      <td>10.5</td>\n",
              "      <td>58.1</td>\n",
              "      <td>0.7353</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>07.00.00</td>\n",
              "      <td>1.1</td>\n",
              "      <td>1144.0</td>\n",
              "      <td>29.0</td>\n",
              "      <td>3.2</td>\n",
              "      <td>667.0</td>\n",
              "      <td>98.0</td>\n",
              "      <td>1490.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>1339.0</td>\n",
              "      <td>730.0</td>\n",
              "      <td>10.2</td>\n",
              "      <td>59.6</td>\n",
              "      <td>0.7417</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>08.00.00</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1333.0</td>\n",
              "      <td>64.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>900.0</td>\n",
              "      <td>174.0</td>\n",
              "      <td>1136.0</td>\n",
              "      <td>112.0</td>\n",
              "      <td>1517.0</td>\n",
              "      <td>1102.0</td>\n",
              "      <td>10.8</td>\n",
              "      <td>57.4</td>\n",
              "      <td>0.7408</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>09.00.00</td>\n",
              "      <td>2.2</td>\n",
              "      <td>1351.0</td>\n",
              "      <td>87.0</td>\n",
              "      <td>9.5</td>\n",
              "      <td>960.0</td>\n",
              "      <td>129.0</td>\n",
              "      <td>1079.0</td>\n",
              "      <td>101.0</td>\n",
              "      <td>1583.0</td>\n",
              "      <td>1028.0</td>\n",
              "      <td>10.5</td>\n",
              "      <td>60.6</td>\n",
              "      <td>0.7691</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>10.00.00</td>\n",
              "      <td>1.7</td>\n",
              "      <td>1233.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>6.3</td>\n",
              "      <td>827.0</td>\n",
              "      <td>112.0</td>\n",
              "      <td>1218.0</td>\n",
              "      <td>98.0</td>\n",
              "      <td>1446.0</td>\n",
              "      <td>860.0</td>\n",
              "      <td>10.8</td>\n",
              "      <td>58.4</td>\n",
              "      <td>0.7552</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>11.00.00</td>\n",
              "      <td>1.5</td>\n",
              "      <td>1179.0</td>\n",
              "      <td>43.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>762.0</td>\n",
              "      <td>95.0</td>\n",
              "      <td>1328.0</td>\n",
              "      <td>92.0</td>\n",
              "      <td>1362.0</td>\n",
              "      <td>671.0</td>\n",
              "      <td>10.5</td>\n",
              "      <td>57.9</td>\n",
              "      <td>0.7352</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>12.00.00</td>\n",
              "      <td>1.6</td>\n",
              "      <td>1236.0</td>\n",
              "      <td>61.0</td>\n",
              "      <td>5.2</td>\n",
              "      <td>774.0</td>\n",
              "      <td>104.0</td>\n",
              "      <td>1301.0</td>\n",
              "      <td>95.0</td>\n",
              "      <td>1401.0</td>\n",
              "      <td>664.0</td>\n",
              "      <td>9.5</td>\n",
              "      <td>66.8</td>\n",
              "      <td>0.7951</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>13.00.00</td>\n",
              "      <td>1.9</td>\n",
              "      <td>1286.0</td>\n",
              "      <td>63.0</td>\n",
              "      <td>7.3</td>\n",
              "      <td>869.0</td>\n",
              "      <td>146.0</td>\n",
              "      <td>1162.0</td>\n",
              "      <td>112.0</td>\n",
              "      <td>1537.0</td>\n",
              "      <td>799.0</td>\n",
              "      <td>8.3</td>\n",
              "      <td>76.4</td>\n",
              "      <td>0.8393</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>14.00.00</td>\n",
              "      <td>2.9</td>\n",
              "      <td>1371.0</td>\n",
              "      <td>164.0</td>\n",
              "      <td>11.5</td>\n",
              "      <td>1034.0</td>\n",
              "      <td>207.0</td>\n",
              "      <td>983.0</td>\n",
              "      <td>128.0</td>\n",
              "      <td>1730.0</td>\n",
              "      <td>1037.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>81.1</td>\n",
              "      <td>0.8736</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>15.00.00</td>\n",
              "      <td>2.2</td>\n",
              "      <td>1310.0</td>\n",
              "      <td>79.0</td>\n",
              "      <td>8.8</td>\n",
              "      <td>933.0</td>\n",
              "      <td>184.0</td>\n",
              "      <td>1082.0</td>\n",
              "      <td>126.0</td>\n",
              "      <td>1647.0</td>\n",
              "      <td>946.0</td>\n",
              "      <td>8.3</td>\n",
              "      <td>79.8</td>\n",
              "      <td>0.8778</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>16.00.00</td>\n",
              "      <td>2.2</td>\n",
              "      <td>1292.0</td>\n",
              "      <td>95.0</td>\n",
              "      <td>8.3</td>\n",
              "      <td>912.0</td>\n",
              "      <td>193.0</td>\n",
              "      <td>1103.0</td>\n",
              "      <td>131.0</td>\n",
              "      <td>1591.0</td>\n",
              "      <td>957.0</td>\n",
              "      <td>9.7</td>\n",
              "      <td>71.2</td>\n",
              "      <td>0.8569</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>17.00.00</td>\n",
              "      <td>2.9</td>\n",
              "      <td>1383.0</td>\n",
              "      <td>150.0</td>\n",
              "      <td>11.2</td>\n",
              "      <td>1020.0</td>\n",
              "      <td>243.0</td>\n",
              "      <td>1008.0</td>\n",
              "      <td>135.0</td>\n",
              "      <td>1719.0</td>\n",
              "      <td>1104.0</td>\n",
              "      <td>9.8</td>\n",
              "      <td>67.6</td>\n",
              "      <td>0.8185</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>18.00.00</td>\n",
              "      <td>4.8</td>\n",
              "      <td>1581.0</td>\n",
              "      <td>307.0</td>\n",
              "      <td>20.8</td>\n",
              "      <td>1319.0</td>\n",
              "      <td>281.0</td>\n",
              "      <td>799.0</td>\n",
              "      <td>151.0</td>\n",
              "      <td>2083.0</td>\n",
              "      <td>1409.0</td>\n",
              "      <td>10.3</td>\n",
              "      <td>64.2</td>\n",
              "      <td>0.8065</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>19.00.00</td>\n",
              "      <td>6.9</td>\n",
              "      <td>1776.0</td>\n",
              "      <td>461.0</td>\n",
              "      <td>27.4</td>\n",
              "      <td>1488.0</td>\n",
              "      <td>383.0</td>\n",
              "      <td>702.0</td>\n",
              "      <td>172.0</td>\n",
              "      <td>2333.0</td>\n",
              "      <td>1704.0</td>\n",
              "      <td>9.7</td>\n",
              "      <td>69.3</td>\n",
              "      <td>0.8319</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>20.00.00</td>\n",
              "      <td>6.1</td>\n",
              "      <td>1640.0</td>\n",
              "      <td>401.0</td>\n",
              "      <td>24.0</td>\n",
              "      <td>1404.0</td>\n",
              "      <td>351.0</td>\n",
              "      <td>743.0</td>\n",
              "      <td>165.0</td>\n",
              "      <td>2191.0</td>\n",
              "      <td>1654.0</td>\n",
              "      <td>9.6</td>\n",
              "      <td>67.8</td>\n",
              "      <td>0.8133</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>21.00.00</td>\n",
              "      <td>3.9</td>\n",
              "      <td>1313.0</td>\n",
              "      <td>197.0</td>\n",
              "      <td>12.8</td>\n",
              "      <td>1076.0</td>\n",
              "      <td>240.0</td>\n",
              "      <td>957.0</td>\n",
              "      <td>136.0</td>\n",
              "      <td>1707.0</td>\n",
              "      <td>1285.0</td>\n",
              "      <td>9.1</td>\n",
              "      <td>64.0</td>\n",
              "      <td>0.7419</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>22.00.00</td>\n",
              "      <td>1.5</td>\n",
              "      <td>965.0</td>\n",
              "      <td>61.0</td>\n",
              "      <td>4.7</td>\n",
              "      <td>749.0</td>\n",
              "      <td>94.0</td>\n",
              "      <td>1325.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>1333.0</td>\n",
              "      <td>821.0</td>\n",
              "      <td>8.2</td>\n",
              "      <td>63.4</td>\n",
              "      <td>0.6905</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>11/03/2004</td>\n",
              "      <td>23.00.00</td>\n",
              "      <td>1.0</td>\n",
              "      <td>913.0</td>\n",
              "      <td>26.0</td>\n",
              "      <td>2.6</td>\n",
              "      <td>629.0</td>\n",
              "      <td>47.0</td>\n",
              "      <td>1565.0</td>\n",
              "      <td>53.0</td>\n",
              "      <td>1252.0</td>\n",
              "      <td>552.0</td>\n",
              "      <td>8.2</td>\n",
              "      <td>60.8</td>\n",
              "      <td>0.6657</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9327</th>\n",
              "      <td>03/04/2005</td>\n",
              "      <td>09.00.00</td>\n",
              "      <td>1.2</td>\n",
              "      <td>1022.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4.1</td>\n",
              "      <td>715.0</td>\n",
              "      <td>192.0</td>\n",
              "      <td>806.0</td>\n",
              "      <td>118.0</td>\n",
              "      <td>1004.0</td>\n",
              "      <td>831.0</td>\n",
              "      <td>17.8</td>\n",
              "      <td>30.7</td>\n",
              "      <td>0.6205</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9328</th>\n",
              "      <td>03/04/2005</td>\n",
              "      <td>10.00.00</td>\n",
              "      <td>1.4</td>\n",
              "      <td>970.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.4</td>\n",
              "      <td>677.0</td>\n",
              "      <td>166.0</td>\n",
              "      <td>888.0</td>\n",
              "      <td>113.0</td>\n",
              "      <td>931.0</td>\n",
              "      <td>613.0</td>\n",
              "      <td>21.1</td>\n",
              "      <td>23.7</td>\n",
              "      <td>0.5875</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9329</th>\n",
              "      <td>03/04/2005</td>\n",
              "      <td>11.00.00</td>\n",
              "      <td>1.3</td>\n",
              "      <td>1000.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.3</td>\n",
              "      <td>779.0</td>\n",
              "      <td>171.0</td>\n",
              "      <td>805.0</td>\n",
              "      <td>115.0</td>\n",
              "      <td>1001.0</td>\n",
              "      <td>640.0</td>\n",
              "      <td>24.0</td>\n",
              "      <td>19.3</td>\n",
              "      <td>0.5673</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9330</th>\n",
              "      <td>03/04/2005</td>\n",
              "      <td>12.00.00</td>\n",
              "      <td>1.4</td>\n",
              "      <td>996.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.3</td>\n",
              "      <td>781.0</td>\n",
              "      <td>177.0</td>\n",
              "      <td>806.0</td>\n",
              "      <td>124.0</td>\n",
              "      <td>985.0</td>\n",
              "      <td>631.0</td>\n",
              "      <td>26.5</td>\n",
              "      <td>16.4</td>\n",
              "      <td>0.5594</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9331</th>\n",
              "      <td>03/04/2005</td>\n",
              "      <td>13.00.00</td>\n",
              "      <td>1.0</td>\n",
              "      <td>928.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.8</td>\n",
              "      <td>701.0</td>\n",
              "      <td>119.0</td>\n",
              "      <td>926.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>902.0</td>\n",
              "      <td>456.0</td>\n",
              "      <td>28.7</td>\n",
              "      <td>13.7</td>\n",
              "      <td>0.5302</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9332</th>\n",
              "      <td>03/04/2005</td>\n",
              "      <td>14.00.00</td>\n",
              "      <td>1.0</td>\n",
              "      <td>933.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4.2</td>\n",
              "      <td>722.0</td>\n",
              "      <td>121.0</td>\n",
              "      <td>899.0</td>\n",
              "      <td>87.0</td>\n",
              "      <td>890.0</td>\n",
              "      <td>450.0</td>\n",
              "      <td>28.5</td>\n",
              "      <td>13.1</td>\n",
              "      <td>0.5002</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9333</th>\n",
              "      <td>03/04/2005</td>\n",
              "      <td>15.00.00</td>\n",
              "      <td>1.1</td>\n",
              "      <td>956.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.4</td>\n",
              "      <td>783.0</td>\n",
              "      <td>142.0</td>\n",
              "      <td>857.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>896.0</td>\n",
              "      <td>516.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>11.1</td>\n",
              "      <td>0.4624</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9334</th>\n",
              "      <td>03/04/2005</td>\n",
              "      <td>16.00.00</td>\n",
              "      <td>1.3</td>\n",
              "      <td>968.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6.3</td>\n",
              "      <td>826.0</td>\n",
              "      <td>197.0</td>\n",
              "      <td>867.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>898.0</td>\n",
              "      <td>548.0</td>\n",
              "      <td>29.4</td>\n",
              "      <td>10.4</td>\n",
              "      <td>0.4192</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9335</th>\n",
              "      <td>03/04/2005</td>\n",
              "      <td>17.00.00</td>\n",
              "      <td>1.4</td>\n",
              "      <td>953.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6.1</td>\n",
              "      <td>817.0</td>\n",
              "      <td>242.0</td>\n",
              "      <td>872.0</td>\n",
              "      <td>156.0</td>\n",
              "      <td>891.0</td>\n",
              "      <td>603.0</td>\n",
              "      <td>28.9</td>\n",
              "      <td>9.9</td>\n",
              "      <td>0.3866</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9336</th>\n",
              "      <td>03/04/2005</td>\n",
              "      <td>18.00.00</td>\n",
              "      <td>1.2</td>\n",
              "      <td>1015.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4.6</td>\n",
              "      <td>743.0</td>\n",
              "      <td>190.0</td>\n",
              "      <td>851.0</td>\n",
              "      <td>138.0</td>\n",
              "      <td>981.0</td>\n",
              "      <td>597.0</td>\n",
              "      <td>22.8</td>\n",
              "      <td>21.7</td>\n",
              "      <td>0.5945</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9337</th>\n",
              "      <td>03/04/2005</td>\n",
              "      <td>19.00.00</td>\n",
              "      <td>2.7</td>\n",
              "      <td>1248.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>11.1</td>\n",
              "      <td>1018.0</td>\n",
              "      <td>367.0</td>\n",
              "      <td>599.0</td>\n",
              "      <td>181.0</td>\n",
              "      <td>1289.0</td>\n",
              "      <td>1167.0</td>\n",
              "      <td>19.9</td>\n",
              "      <td>33.0</td>\n",
              "      <td>0.7608</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9338</th>\n",
              "      <td>03/04/2005</td>\n",
              "      <td>20.00.00</td>\n",
              "      <td>2.5</td>\n",
              "      <td>1180.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7.9</td>\n",
              "      <td>894.0</td>\n",
              "      <td>355.0</td>\n",
              "      <td>636.0</td>\n",
              "      <td>187.0</td>\n",
              "      <td>1200.0</td>\n",
              "      <td>1372.0</td>\n",
              "      <td>17.5</td>\n",
              "      <td>40.7</td>\n",
              "      <td>0.8073</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9339</th>\n",
              "      <td>03/04/2005</td>\n",
              "      <td>21.00.00</td>\n",
              "      <td>1.5</td>\n",
              "      <td>1102.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6.0</td>\n",
              "      <td>812.0</td>\n",
              "      <td>235.0</td>\n",
              "      <td>693.0</td>\n",
              "      <td>158.0</td>\n",
              "      <td>1178.0</td>\n",
              "      <td>1042.0</td>\n",
              "      <td>16.4</td>\n",
              "      <td>46.6</td>\n",
              "      <td>0.8642</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9340</th>\n",
              "      <td>03/04/2005</td>\n",
              "      <td>22.00.00</td>\n",
              "      <td>1.6</td>\n",
              "      <td>1116.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.8</td>\n",
              "      <td>803.0</td>\n",
              "      <td>233.0</td>\n",
              "      <td>696.0</td>\n",
              "      <td>153.0</td>\n",
              "      <td>1173.0</td>\n",
              "      <td>1055.0</td>\n",
              "      <td>15.5</td>\n",
              "      <td>49.0</td>\n",
              "      <td>0.8579</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9341</th>\n",
              "      <td>03/04/2005</td>\n",
              "      <td>23.00.00</td>\n",
              "      <td>1.2</td>\n",
              "      <td>1100.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.1</td>\n",
              "      <td>769.0</td>\n",
              "      <td>170.0</td>\n",
              "      <td>722.0</td>\n",
              "      <td>128.0</td>\n",
              "      <td>1147.0</td>\n",
              "      <td>1049.0</td>\n",
              "      <td>14.3</td>\n",
              "      <td>52.5</td>\n",
              "      <td>0.8497</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9342</th>\n",
              "      <td>04/04/2005</td>\n",
              "      <td>00.00.00</td>\n",
              "      <td>0.9</td>\n",
              "      <td>1012.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.5</td>\n",
              "      <td>683.0</td>\n",
              "      <td>117.0</td>\n",
              "      <td>801.0</td>\n",
              "      <td>93.0</td>\n",
              "      <td>1073.0</td>\n",
              "      <td>816.0</td>\n",
              "      <td>14.2</td>\n",
              "      <td>51.4</td>\n",
              "      <td>0.8275</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9343</th>\n",
              "      <td>04/04/2005</td>\n",
              "      <td>01.00.00</td>\n",
              "      <td>0.6</td>\n",
              "      <td>944.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.9</td>\n",
              "      <td>579.0</td>\n",
              "      <td>70.0</td>\n",
              "      <td>925.0</td>\n",
              "      <td>58.0</td>\n",
              "      <td>1002.0</td>\n",
              "      <td>598.0</td>\n",
              "      <td>13.8</td>\n",
              "      <td>51.2</td>\n",
              "      <td>0.8058</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9344</th>\n",
              "      <td>04/04/2005</td>\n",
              "      <td>02.00.00</td>\n",
              "      <td>0.5</td>\n",
              "      <td>912.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.5</td>\n",
              "      <td>544.0</td>\n",
              "      <td>69.0</td>\n",
              "      <td>959.0</td>\n",
              "      <td>55.0</td>\n",
              "      <td>1002.0</td>\n",
              "      <td>573.0</td>\n",
              "      <td>12.1</td>\n",
              "      <td>56.3</td>\n",
              "      <td>0.7927</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9345</th>\n",
              "      <td>04/04/2005</td>\n",
              "      <td>03.00.00</td>\n",
              "      <td>0.4</td>\n",
              "      <td>887.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.1</td>\n",
              "      <td>508.0</td>\n",
              "      <td>62.0</td>\n",
              "      <td>1047.0</td>\n",
              "      <td>51.0</td>\n",
              "      <td>974.0</td>\n",
              "      <td>549.0</td>\n",
              "      <td>11.3</td>\n",
              "      <td>58.9</td>\n",
              "      <td>0.7888</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9346</th>\n",
              "      <td>04/04/2005</td>\n",
              "      <td>04.00.00</td>\n",
              "      <td>NaN</td>\n",
              "      <td>864.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.8</td>\n",
              "      <td>478.0</td>\n",
              "      <td>52.0</td>\n",
              "      <td>1116.0</td>\n",
              "      <td>43.0</td>\n",
              "      <td>958.0</td>\n",
              "      <td>489.0</td>\n",
              "      <td>11.8</td>\n",
              "      <td>56.0</td>\n",
              "      <td>0.7743</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9347</th>\n",
              "      <td>04/04/2005</td>\n",
              "      <td>05.00.00</td>\n",
              "      <td>0.5</td>\n",
              "      <td>888.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.3</td>\n",
              "      <td>528.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>1077.0</td>\n",
              "      <td>53.0</td>\n",
              "      <td>987.0</td>\n",
              "      <td>578.0</td>\n",
              "      <td>10.4</td>\n",
              "      <td>59.9</td>\n",
              "      <td>0.7550</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9348</th>\n",
              "      <td>04/04/2005</td>\n",
              "      <td>06.00.00</td>\n",
              "      <td>1.1</td>\n",
              "      <td>1031.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4.4</td>\n",
              "      <td>730.0</td>\n",
              "      <td>182.0</td>\n",
              "      <td>760.0</td>\n",
              "      <td>93.0</td>\n",
              "      <td>1129.0</td>\n",
              "      <td>905.0</td>\n",
              "      <td>9.5</td>\n",
              "      <td>63.1</td>\n",
              "      <td>0.7531</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9349</th>\n",
              "      <td>04/04/2005</td>\n",
              "      <td>07.00.00</td>\n",
              "      <td>4.0</td>\n",
              "      <td>1384.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>17.4</td>\n",
              "      <td>1221.0</td>\n",
              "      <td>594.0</td>\n",
              "      <td>470.0</td>\n",
              "      <td>155.0</td>\n",
              "      <td>1600.0</td>\n",
              "      <td>1457.0</td>\n",
              "      <td>9.7</td>\n",
              "      <td>61.9</td>\n",
              "      <td>0.7446</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9350</th>\n",
              "      <td>04/04/2005</td>\n",
              "      <td>08.00.00</td>\n",
              "      <td>5.0</td>\n",
              "      <td>1446.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22.4</td>\n",
              "      <td>1362.0</td>\n",
              "      <td>586.0</td>\n",
              "      <td>415.0</td>\n",
              "      <td>174.0</td>\n",
              "      <td>1777.0</td>\n",
              "      <td>1705.0</td>\n",
              "      <td>13.5</td>\n",
              "      <td>48.9</td>\n",
              "      <td>0.7553</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9351</th>\n",
              "      <td>04/04/2005</td>\n",
              "      <td>09.00.00</td>\n",
              "      <td>3.9</td>\n",
              "      <td>1297.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>13.6</td>\n",
              "      <td>1102.0</td>\n",
              "      <td>523.0</td>\n",
              "      <td>507.0</td>\n",
              "      <td>187.0</td>\n",
              "      <td>1375.0</td>\n",
              "      <td>1583.0</td>\n",
              "      <td>18.2</td>\n",
              "      <td>36.3</td>\n",
              "      <td>0.7487</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9352</th>\n",
              "      <td>04/04/2005</td>\n",
              "      <td>10.00.00</td>\n",
              "      <td>3.1</td>\n",
              "      <td>1314.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>13.5</td>\n",
              "      <td>1101.0</td>\n",
              "      <td>472.0</td>\n",
              "      <td>539.0</td>\n",
              "      <td>190.0</td>\n",
              "      <td>1374.0</td>\n",
              "      <td>1729.0</td>\n",
              "      <td>21.9</td>\n",
              "      <td>29.3</td>\n",
              "      <td>0.7568</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9353</th>\n",
              "      <td>04/04/2005</td>\n",
              "      <td>11.00.00</td>\n",
              "      <td>2.4</td>\n",
              "      <td>1163.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>11.4</td>\n",
              "      <td>1027.0</td>\n",
              "      <td>353.0</td>\n",
              "      <td>604.0</td>\n",
              "      <td>179.0</td>\n",
              "      <td>1264.0</td>\n",
              "      <td>1269.0</td>\n",
              "      <td>24.3</td>\n",
              "      <td>23.7</td>\n",
              "      <td>0.7119</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9354</th>\n",
              "      <td>04/04/2005</td>\n",
              "      <td>12.00.00</td>\n",
              "      <td>2.4</td>\n",
              "      <td>1142.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12.4</td>\n",
              "      <td>1063.0</td>\n",
              "      <td>293.0</td>\n",
              "      <td>603.0</td>\n",
              "      <td>175.0</td>\n",
              "      <td>1241.0</td>\n",
              "      <td>1092.0</td>\n",
              "      <td>26.9</td>\n",
              "      <td>18.3</td>\n",
              "      <td>0.6406</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9355</th>\n",
              "      <td>04/04/2005</td>\n",
              "      <td>13.00.00</td>\n",
              "      <td>2.1</td>\n",
              "      <td>1003.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>9.5</td>\n",
              "      <td>961.0</td>\n",
              "      <td>235.0</td>\n",
              "      <td>702.0</td>\n",
              "      <td>156.0</td>\n",
              "      <td>1041.0</td>\n",
              "      <td>770.0</td>\n",
              "      <td>28.3</td>\n",
              "      <td>13.5</td>\n",
              "      <td>0.5139</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9356</th>\n",
              "      <td>04/04/2005</td>\n",
              "      <td>14.00.00</td>\n",
              "      <td>2.2</td>\n",
              "      <td>1071.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>11.9</td>\n",
              "      <td>1047.0</td>\n",
              "      <td>265.0</td>\n",
              "      <td>654.0</td>\n",
              "      <td>168.0</td>\n",
              "      <td>1129.0</td>\n",
              "      <td>816.0</td>\n",
              "      <td>28.5</td>\n",
              "      <td>13.1</td>\n",
              "      <td>0.5028</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>9357 rows × 15 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "            Date      Time  CO(GT)  PT08.S1(CO)  NMHC(GT)  C6H6(GT)  \\\n",
              "0     10/03/2004  18.00.00     2.6       1360.0     150.0      11.9   \n",
              "1     10/03/2004  19.00.00     2.0       1292.0     112.0       9.4   \n",
              "2     10/03/2004  20.00.00     2.2       1402.0      88.0       9.0   \n",
              "3     10/03/2004  21.00.00     2.2       1376.0      80.0       9.2   \n",
              "4     10/03/2004  22.00.00     1.6       1272.0      51.0       6.5   \n",
              "5     10/03/2004  23.00.00     1.2       1197.0      38.0       4.7   \n",
              "6     11/03/2004  00.00.00     1.2       1185.0      31.0       3.6   \n",
              "7     11/03/2004  01.00.00     1.0       1136.0      31.0       3.3   \n",
              "8     11/03/2004  02.00.00     0.9       1094.0      24.0       2.3   \n",
              "9     11/03/2004  03.00.00     0.6       1010.0      19.0       1.7   \n",
              "10    11/03/2004  04.00.00     NaN       1011.0      14.0       1.3   \n",
              "11    11/03/2004  05.00.00     0.7       1066.0       8.0       1.1   \n",
              "12    11/03/2004  06.00.00     0.7       1052.0      16.0       1.6   \n",
              "13    11/03/2004  07.00.00     1.1       1144.0      29.0       3.2   \n",
              "14    11/03/2004  08.00.00     2.0       1333.0      64.0       8.0   \n",
              "15    11/03/2004  09.00.00     2.2       1351.0      87.0       9.5   \n",
              "16    11/03/2004  10.00.00     1.7       1233.0      77.0       6.3   \n",
              "17    11/03/2004  11.00.00     1.5       1179.0      43.0       5.0   \n",
              "18    11/03/2004  12.00.00     1.6       1236.0      61.0       5.2   \n",
              "19    11/03/2004  13.00.00     1.9       1286.0      63.0       7.3   \n",
              "20    11/03/2004  14.00.00     2.9       1371.0     164.0      11.5   \n",
              "21    11/03/2004  15.00.00     2.2       1310.0      79.0       8.8   \n",
              "22    11/03/2004  16.00.00     2.2       1292.0      95.0       8.3   \n",
              "23    11/03/2004  17.00.00     2.9       1383.0     150.0      11.2   \n",
              "24    11/03/2004  18.00.00     4.8       1581.0     307.0      20.8   \n",
              "25    11/03/2004  19.00.00     6.9       1776.0     461.0      27.4   \n",
              "26    11/03/2004  20.00.00     6.1       1640.0     401.0      24.0   \n",
              "27    11/03/2004  21.00.00     3.9       1313.0     197.0      12.8   \n",
              "28    11/03/2004  22.00.00     1.5        965.0      61.0       4.7   \n",
              "29    11/03/2004  23.00.00     1.0        913.0      26.0       2.6   \n",
              "...          ...       ...     ...          ...       ...       ...   \n",
              "9327  03/04/2005  09.00.00     1.2       1022.0       NaN       4.1   \n",
              "9328  03/04/2005  10.00.00     1.4        970.0       NaN       3.4   \n",
              "9329  03/04/2005  11.00.00     1.3       1000.0       NaN       5.3   \n",
              "9330  03/04/2005  12.00.00     1.4        996.0       NaN       5.3   \n",
              "9331  03/04/2005  13.00.00     1.0        928.0       NaN       3.8   \n",
              "9332  03/04/2005  14.00.00     1.0        933.0       NaN       4.2   \n",
              "9333  03/04/2005  15.00.00     1.1        956.0       NaN       5.4   \n",
              "9334  03/04/2005  16.00.00     1.3        968.0       NaN       6.3   \n",
              "9335  03/04/2005  17.00.00     1.4        953.0       NaN       6.1   \n",
              "9336  03/04/2005  18.00.00     1.2       1015.0       NaN       4.6   \n",
              "9337  03/04/2005  19.00.00     2.7       1248.0       NaN      11.1   \n",
              "9338  03/04/2005  20.00.00     2.5       1180.0       NaN       7.9   \n",
              "9339  03/04/2005  21.00.00     1.5       1102.0       NaN       6.0   \n",
              "9340  03/04/2005  22.00.00     1.6       1116.0       NaN       5.8   \n",
              "9341  03/04/2005  23.00.00     1.2       1100.0       NaN       5.1   \n",
              "9342  04/04/2005  00.00.00     0.9       1012.0       NaN       3.5   \n",
              "9343  04/04/2005  01.00.00     0.6        944.0       NaN       1.9   \n",
              "9344  04/04/2005  02.00.00     0.5        912.0       NaN       1.5   \n",
              "9345  04/04/2005  03.00.00     0.4        887.0       NaN       1.1   \n",
              "9346  04/04/2005  04.00.00     NaN        864.0       NaN       0.8   \n",
              "9347  04/04/2005  05.00.00     0.5        888.0       NaN       1.3   \n",
              "9348  04/04/2005  06.00.00     1.1       1031.0       NaN       4.4   \n",
              "9349  04/04/2005  07.00.00     4.0       1384.0       NaN      17.4   \n",
              "9350  04/04/2005  08.00.00     5.0       1446.0       NaN      22.4   \n",
              "9351  04/04/2005  09.00.00     3.9       1297.0       NaN      13.6   \n",
              "9352  04/04/2005  10.00.00     3.1       1314.0       NaN      13.5   \n",
              "9353  04/04/2005  11.00.00     2.4       1163.0       NaN      11.4   \n",
              "9354  04/04/2005  12.00.00     2.4       1142.0       NaN      12.4   \n",
              "9355  04/04/2005  13.00.00     2.1       1003.0       NaN       9.5   \n",
              "9356  04/04/2005  14.00.00     2.2       1071.0       NaN      11.9   \n",
              "\n",
              "      PT08.S2(NMHC)  NOx(GT)  PT08.S3(NOx)  NO2(GT)  PT08.S4(NO2)  \\\n",
              "0            1046.0    166.0        1056.0    113.0        1692.0   \n",
              "1             955.0    103.0        1174.0     92.0        1559.0   \n",
              "2             939.0    131.0        1140.0    114.0        1555.0   \n",
              "3             948.0    172.0        1092.0    122.0        1584.0   \n",
              "4             836.0    131.0        1205.0    116.0        1490.0   \n",
              "5             750.0     89.0        1337.0     96.0        1393.0   \n",
              "6             690.0     62.0        1462.0     77.0        1333.0   \n",
              "7             672.0     62.0        1453.0     76.0        1333.0   \n",
              "8             609.0     45.0        1579.0     60.0        1276.0   \n",
              "9             561.0      NaN        1705.0      NaN        1235.0   \n",
              "10            527.0     21.0        1818.0     34.0        1197.0   \n",
              "11            512.0     16.0        1918.0     28.0        1182.0   \n",
              "12            553.0     34.0        1738.0     48.0        1221.0   \n",
              "13            667.0     98.0        1490.0     82.0        1339.0   \n",
              "14            900.0    174.0        1136.0    112.0        1517.0   \n",
              "15            960.0    129.0        1079.0    101.0        1583.0   \n",
              "16            827.0    112.0        1218.0     98.0        1446.0   \n",
              "17            762.0     95.0        1328.0     92.0        1362.0   \n",
              "18            774.0    104.0        1301.0     95.0        1401.0   \n",
              "19            869.0    146.0        1162.0    112.0        1537.0   \n",
              "20           1034.0    207.0         983.0    128.0        1730.0   \n",
              "21            933.0    184.0        1082.0    126.0        1647.0   \n",
              "22            912.0    193.0        1103.0    131.0        1591.0   \n",
              "23           1020.0    243.0        1008.0    135.0        1719.0   \n",
              "24           1319.0    281.0         799.0    151.0        2083.0   \n",
              "25           1488.0    383.0         702.0    172.0        2333.0   \n",
              "26           1404.0    351.0         743.0    165.0        2191.0   \n",
              "27           1076.0    240.0         957.0    136.0        1707.0   \n",
              "28            749.0     94.0        1325.0     85.0        1333.0   \n",
              "29            629.0     47.0        1565.0     53.0        1252.0   \n",
              "...             ...      ...           ...      ...           ...   \n",
              "9327          715.0    192.0         806.0    118.0        1004.0   \n",
              "9328          677.0    166.0         888.0    113.0         931.0   \n",
              "9329          779.0    171.0         805.0    115.0        1001.0   \n",
              "9330          781.0    177.0         806.0    124.0         985.0   \n",
              "9331          701.0    119.0         926.0     86.0         902.0   \n",
              "9332          722.0    121.0         899.0     87.0         890.0   \n",
              "9333          783.0    142.0         857.0    100.0         896.0   \n",
              "9334          826.0    197.0         867.0    132.0         898.0   \n",
              "9335          817.0    242.0         872.0    156.0         891.0   \n",
              "9336          743.0    190.0         851.0    138.0         981.0   \n",
              "9337         1018.0    367.0         599.0    181.0        1289.0   \n",
              "9338          894.0    355.0         636.0    187.0        1200.0   \n",
              "9339          812.0    235.0         693.0    158.0        1178.0   \n",
              "9340          803.0    233.0         696.0    153.0        1173.0   \n",
              "9341          769.0    170.0         722.0    128.0        1147.0   \n",
              "9342          683.0    117.0         801.0     93.0        1073.0   \n",
              "9343          579.0     70.0         925.0     58.0        1002.0   \n",
              "9344          544.0     69.0         959.0     55.0        1002.0   \n",
              "9345          508.0     62.0        1047.0     51.0         974.0   \n",
              "9346          478.0     52.0        1116.0     43.0         958.0   \n",
              "9347          528.0     77.0        1077.0     53.0         987.0   \n",
              "9348          730.0    182.0         760.0     93.0        1129.0   \n",
              "9349         1221.0    594.0         470.0    155.0        1600.0   \n",
              "9350         1362.0    586.0         415.0    174.0        1777.0   \n",
              "9351         1102.0    523.0         507.0    187.0        1375.0   \n",
              "9352         1101.0    472.0         539.0    190.0        1374.0   \n",
              "9353         1027.0    353.0         604.0    179.0        1264.0   \n",
              "9354         1063.0    293.0         603.0    175.0        1241.0   \n",
              "9355          961.0    235.0         702.0    156.0        1041.0   \n",
              "9356         1047.0    265.0         654.0    168.0        1129.0   \n",
              "\n",
              "      PT08.S5(O3)     T    RH      AH  \n",
              "0          1268.0  13.6  48.9  0.7578  \n",
              "1           972.0  13.3  47.7  0.7255  \n",
              "2          1074.0  11.9  54.0  0.7502  \n",
              "3          1203.0  11.0  60.0  0.7867  \n",
              "4          1110.0  11.2  59.6  0.7888  \n",
              "5           949.0  11.2  59.2  0.7848  \n",
              "6           733.0  11.3  56.8  0.7603  \n",
              "7           730.0  10.7  60.0  0.7702  \n",
              "8           620.0  10.7  59.7  0.7648  \n",
              "9           501.0  10.3  60.2  0.7517  \n",
              "10          445.0  10.1  60.5  0.7465  \n",
              "11          422.0  11.0  56.2  0.7366  \n",
              "12          472.0  10.5  58.1  0.7353  \n",
              "13          730.0  10.2  59.6  0.7417  \n",
              "14         1102.0  10.8  57.4  0.7408  \n",
              "15         1028.0  10.5  60.6  0.7691  \n",
              "16          860.0  10.8  58.4  0.7552  \n",
              "17          671.0  10.5  57.9  0.7352  \n",
              "18          664.0   9.5  66.8  0.7951  \n",
              "19          799.0   8.3  76.4  0.8393  \n",
              "20         1037.0   8.0  81.1  0.8736  \n",
              "21          946.0   8.3  79.8  0.8778  \n",
              "22          957.0   9.7  71.2  0.8569  \n",
              "23         1104.0   9.8  67.6  0.8185  \n",
              "24         1409.0  10.3  64.2  0.8065  \n",
              "25         1704.0   9.7  69.3  0.8319  \n",
              "26         1654.0   9.6  67.8  0.8133  \n",
              "27         1285.0   9.1  64.0  0.7419  \n",
              "28          821.0   8.2  63.4  0.6905  \n",
              "29          552.0   8.2  60.8  0.6657  \n",
              "...           ...   ...   ...     ...  \n",
              "9327        831.0  17.8  30.7  0.6205  \n",
              "9328        613.0  21.1  23.7  0.5875  \n",
              "9329        640.0  24.0  19.3  0.5673  \n",
              "9330        631.0  26.5  16.4  0.5594  \n",
              "9331        456.0  28.7  13.7  0.5302  \n",
              "9332        450.0  28.5  13.1  0.5002  \n",
              "9333        516.0  30.0  11.1  0.4624  \n",
              "9334        548.0  29.4  10.4  0.4192  \n",
              "9335        603.0  28.9   9.9  0.3866  \n",
              "9336        597.0  22.8  21.7  0.5945  \n",
              "9337       1167.0  19.9  33.0  0.7608  \n",
              "9338       1372.0  17.5  40.7  0.8073  \n",
              "9339       1042.0  16.4  46.6  0.8642  \n",
              "9340       1055.0  15.5  49.0  0.8579  \n",
              "9341       1049.0  14.3  52.5  0.8497  \n",
              "9342        816.0  14.2  51.4  0.8275  \n",
              "9343        598.0  13.8  51.2  0.8058  \n",
              "9344        573.0  12.1  56.3  0.7927  \n",
              "9345        549.0  11.3  58.9  0.7888  \n",
              "9346        489.0  11.8  56.0  0.7743  \n",
              "9347        578.0  10.4  59.9  0.7550  \n",
              "9348        905.0   9.5  63.1  0.7531  \n",
              "9349       1457.0   9.7  61.9  0.7446  \n",
              "9350       1705.0  13.5  48.9  0.7553  \n",
              "9351       1583.0  18.2  36.3  0.7487  \n",
              "9352       1729.0  21.9  29.3  0.7568  \n",
              "9353       1269.0  24.3  23.7  0.7119  \n",
              "9354       1092.0  26.9  18.3  0.6406  \n",
              "9355        770.0  28.3  13.5  0.5139  \n",
              "9356        816.0  28.5  13.1  0.5028  \n",
              "\n",
              "[9357 rows x 15 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 4
        }
      ]
    },
    {
      "metadata": {
        "id": "gpdIq1PgUGzA",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "air_quality.fillna(air_quality.mean(), inplace= True)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "rqfH-rILUGzF",
        "colab_type": "code",
        "colab": {},
        "outputId": "58963162-ddce-4799-e072-b1cc1baf85e9"
      },
      "cell_type": "code",
      "source": [
        "air_quality.loc[:,'Date']=air_quality['Date']\n",
        "air_quality.head()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Date</th>\n",
              "      <th>Time</th>\n",
              "      <th>CO(GT)</th>\n",
              "      <th>PT08.S1(CO)</th>\n",
              "      <th>NMHC(GT)</th>\n",
              "      <th>C6H6(GT)</th>\n",
              "      <th>PT08.S2(NMHC)</th>\n",
              "      <th>NOx(GT)</th>\n",
              "      <th>PT08.S3(NOx)</th>\n",
              "      <th>NO2(GT)</th>\n",
              "      <th>PT08.S4(NO2)</th>\n",
              "      <th>PT08.S5(O3)</th>\n",
              "      <th>T</th>\n",
              "      <th>RH</th>\n",
              "      <th>AH</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>10/03/2004</td>\n",
              "      <td>18.00.00</td>\n",
              "      <td>2.6</td>\n",
              "      <td>1360.0</td>\n",
              "      <td>150.0</td>\n",
              "      <td>11.9</td>\n",
              "      <td>1046.0</td>\n",
              "      <td>166.0</td>\n",
              "      <td>1056.0</td>\n",
              "      <td>113.0</td>\n",
              "      <td>1692.0</td>\n",
              "      <td>1268.0</td>\n",
              "      <td>13.6</td>\n",
              "      <td>48.9</td>\n",
              "      <td>0.7578</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>10/03/2004</td>\n",
              "      <td>19.00.00</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1292.0</td>\n",
              "      <td>112.0</td>\n",
              "      <td>9.4</td>\n",
              "      <td>955.0</td>\n",
              "      <td>103.0</td>\n",
              "      <td>1174.0</td>\n",
              "      <td>92.0</td>\n",
              "      <td>1559.0</td>\n",
              "      <td>972.0</td>\n",
              "      <td>13.3</td>\n",
              "      <td>47.7</td>\n",
              "      <td>0.7255</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>10/03/2004</td>\n",
              "      <td>20.00.00</td>\n",
              "      <td>2.2</td>\n",
              "      <td>1402.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>939.0</td>\n",
              "      <td>131.0</td>\n",
              "      <td>1140.0</td>\n",
              "      <td>114.0</td>\n",
              "      <td>1555.0</td>\n",
              "      <td>1074.0</td>\n",
              "      <td>11.9</td>\n",
              "      <td>54.0</td>\n",
              "      <td>0.7502</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>10/03/2004</td>\n",
              "      <td>21.00.00</td>\n",
              "      <td>2.2</td>\n",
              "      <td>1376.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>9.2</td>\n",
              "      <td>948.0</td>\n",
              "      <td>172.0</td>\n",
              "      <td>1092.0</td>\n",
              "      <td>122.0</td>\n",
              "      <td>1584.0</td>\n",
              "      <td>1203.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>60.0</td>\n",
              "      <td>0.7867</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>10/03/2004</td>\n",
              "      <td>22.00.00</td>\n",
              "      <td>1.6</td>\n",
              "      <td>1272.0</td>\n",
              "      <td>51.0</td>\n",
              "      <td>6.5</td>\n",
              "      <td>836.0</td>\n",
              "      <td>131.0</td>\n",
              "      <td>1205.0</td>\n",
              "      <td>116.0</td>\n",
              "      <td>1490.0</td>\n",
              "      <td>1110.0</td>\n",
              "      <td>11.2</td>\n",
              "      <td>59.6</td>\n",
              "      <td>0.7888</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "         Date      Time  CO(GT)  PT08.S1(CO)  NMHC(GT)  C6H6(GT)  \\\n",
              "0  10/03/2004  18.00.00     2.6       1360.0     150.0      11.9   \n",
              "1  10/03/2004  19.00.00     2.0       1292.0     112.0       9.4   \n",
              "2  10/03/2004  20.00.00     2.2       1402.0      88.0       9.0   \n",
              "3  10/03/2004  21.00.00     2.2       1376.0      80.0       9.2   \n",
              "4  10/03/2004  22.00.00     1.6       1272.0      51.0       6.5   \n",
              "\n",
              "   PT08.S2(NMHC)  NOx(GT)  PT08.S3(NOx)  NO2(GT)  PT08.S4(NO2)  PT08.S5(O3)  \\\n",
              "0         1046.0    166.0        1056.0    113.0        1692.0       1268.0   \n",
              "1          955.0    103.0        1174.0     92.0        1559.0        972.0   \n",
              "2          939.0    131.0        1140.0    114.0        1555.0       1074.0   \n",
              "3          948.0    172.0        1092.0    122.0        1584.0       1203.0   \n",
              "4          836.0    131.0        1205.0    116.0        1490.0       1110.0   \n",
              "\n",
              "      T    RH      AH  \n",
              "0  13.6  48.9  0.7578  \n",
              "1  13.3  47.7  0.7255  \n",
              "2  11.9  54.0  0.7502  \n",
              "3  11.0  60.0  0.7867  \n",
              "4  11.2  59.6  0.7888  "
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 6
        }
      ]
    },
    {
      "metadata": {
        "id": "12YrXXbmUGzL",
        "colab_type": "code",
        "colab": {},
        "outputId": "17569eac-7872-4209-f5a6-a3000c450275"
      },
      "cell_type": "code",
      "source": [
        "from datetime import datetime\n",
        "Date= []\n",
        "for i in air_quality['Date']:\n",
        "    Date.append(datetime.strptime(i,'%d/%m/%Y'))\n",
        "air_quality.dtypes"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Date              object\n",
              "Time              object\n",
              "CO(GT)           float64\n",
              "PT08.S1(CO)      float64\n",
              "NMHC(GT)         float64\n",
              "C6H6(GT)         float64\n",
              "PT08.S2(NMHC)    float64\n",
              "NOx(GT)          float64\n",
              "PT08.S3(NOx)     float64\n",
              "NO2(GT)          float64\n",
              "PT08.S4(NO2)     float64\n",
              "PT08.S5(O3)      float64\n",
              "T                float64\n",
              "RH               float64\n",
              "AH               float64\n",
              "dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 7
        }
      ]
    },
    {
      "metadata": {
        "id": "7bovCwHPUGzP",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "date=pd.Series(Date)\n",
        "air_quality['Date']=pd.to_numeric(date)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "Mnna4n8MUGzS",
        "colab_type": "code",
        "colab": {},
        "outputId": "5211d45f-b5c1-40c2-c62f-d33fbde1447e"
      },
      "cell_type": "code",
      "source": [
        "air_quality['Date']=air_quality['Date'].astype(float)\n",
        "air_quality.dtypes\n",
        "air_quality"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Date</th>\n",
              "      <th>Time</th>\n",
              "      <th>CO(GT)</th>\n",
              "      <th>PT08.S1(CO)</th>\n",
              "      <th>NMHC(GT)</th>\n",
              "      <th>C6H6(GT)</th>\n",
              "      <th>PT08.S2(NMHC)</th>\n",
              "      <th>NOx(GT)</th>\n",
              "      <th>PT08.S3(NOx)</th>\n",
              "      <th>NO2(GT)</th>\n",
              "      <th>PT08.S4(NO2)</th>\n",
              "      <th>PT08.S5(O3)</th>\n",
              "      <th>T</th>\n",
              "      <th>RH</th>\n",
              "      <th>AH</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1.078877e+18</td>\n",
              "      <td>18.00.00</td>\n",
              "      <td>2.60000</td>\n",
              "      <td>1360.0</td>\n",
              "      <td>150.000000</td>\n",
              "      <td>11.9</td>\n",
              "      <td>1046.0</td>\n",
              "      <td>166.000000</td>\n",
              "      <td>1056.0</td>\n",
              "      <td>113.000000</td>\n",
              "      <td>1692.0</td>\n",
              "      <td>1268.0</td>\n",
              "      <td>13.6</td>\n",
              "      <td>48.9</td>\n",
              "      <td>0.7578</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1.078877e+18</td>\n",
              "      <td>19.00.00</td>\n",
              "      <td>2.00000</td>\n",
              "      <td>1292.0</td>\n",
              "      <td>112.000000</td>\n",
              "      <td>9.4</td>\n",
              "      <td>955.0</td>\n",
              "      <td>103.000000</td>\n",
              "      <td>1174.0</td>\n",
              "      <td>92.000000</td>\n",
              "      <td>1559.0</td>\n",
              "      <td>972.0</td>\n",
              "      <td>13.3</td>\n",
              "      <td>47.7</td>\n",
              "      <td>0.7255</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1.078877e+18</td>\n",
              "      <td>20.00.00</td>\n",
              "      <td>2.20000</td>\n",
              "      <td>1402.0</td>\n",
              "      <td>88.000000</td>\n",
              "      <td>9.0</td>\n",
              "      <td>939.0</td>\n",
              "      <td>131.000000</td>\n",
              "      <td>1140.0</td>\n",
              "      <td>114.000000</td>\n",
              "      <td>1555.0</td>\n",
              "      <td>1074.0</td>\n",
              "      <td>11.9</td>\n",
              "      <td>54.0</td>\n",
              "      <td>0.7502</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1.078877e+18</td>\n",
              "      <td>21.00.00</td>\n",
              "      <td>2.20000</td>\n",
              "      <td>1376.0</td>\n",
              "      <td>80.000000</td>\n",
              "      <td>9.2</td>\n",
              "      <td>948.0</td>\n",
              "      <td>172.000000</td>\n",
              "      <td>1092.0</td>\n",
              "      <td>122.000000</td>\n",
              "      <td>1584.0</td>\n",
              "      <td>1203.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>60.0</td>\n",
              "      <td>0.7867</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1.078877e+18</td>\n",
              "      <td>22.00.00</td>\n",
              "      <td>1.60000</td>\n",
              "      <td>1272.0</td>\n",
              "      <td>51.000000</td>\n",
              "      <td>6.5</td>\n",
              "      <td>836.0</td>\n",
              "      <td>131.000000</td>\n",
              "      <td>1205.0</td>\n",
              "      <td>116.000000</td>\n",
              "      <td>1490.0</td>\n",
              "      <td>1110.0</td>\n",
              "      <td>11.2</td>\n",
              "      <td>59.6</td>\n",
              "      <td>0.7888</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>1.078877e+18</td>\n",
              "      <td>23.00.00</td>\n",
              "      <td>1.20000</td>\n",
              "      <td>1197.0</td>\n",
              "      <td>38.000000</td>\n",
              "      <td>4.7</td>\n",
              "      <td>750.0</td>\n",
              "      <td>89.000000</td>\n",
              "      <td>1337.0</td>\n",
              "      <td>96.000000</td>\n",
              "      <td>1393.0</td>\n",
              "      <td>949.0</td>\n",
              "      <td>11.2</td>\n",
              "      <td>59.2</td>\n",
              "      <td>0.7848</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>00.00.00</td>\n",
              "      <td>1.20000</td>\n",
              "      <td>1185.0</td>\n",
              "      <td>31.000000</td>\n",
              "      <td>3.6</td>\n",
              "      <td>690.0</td>\n",
              "      <td>62.000000</td>\n",
              "      <td>1462.0</td>\n",
              "      <td>77.000000</td>\n",
              "      <td>1333.0</td>\n",
              "      <td>733.0</td>\n",
              "      <td>11.3</td>\n",
              "      <td>56.8</td>\n",
              "      <td>0.7603</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>01.00.00</td>\n",
              "      <td>1.00000</td>\n",
              "      <td>1136.0</td>\n",
              "      <td>31.000000</td>\n",
              "      <td>3.3</td>\n",
              "      <td>672.0</td>\n",
              "      <td>62.000000</td>\n",
              "      <td>1453.0</td>\n",
              "      <td>76.000000</td>\n",
              "      <td>1333.0</td>\n",
              "      <td>730.0</td>\n",
              "      <td>10.7</td>\n",
              "      <td>60.0</td>\n",
              "      <td>0.7702</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>02.00.00</td>\n",
              "      <td>0.90000</td>\n",
              "      <td>1094.0</td>\n",
              "      <td>24.000000</td>\n",
              "      <td>2.3</td>\n",
              "      <td>609.0</td>\n",
              "      <td>45.000000</td>\n",
              "      <td>1579.0</td>\n",
              "      <td>60.000000</td>\n",
              "      <td>1276.0</td>\n",
              "      <td>620.0</td>\n",
              "      <td>10.7</td>\n",
              "      <td>59.7</td>\n",
              "      <td>0.7648</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>03.00.00</td>\n",
              "      <td>0.60000</td>\n",
              "      <td>1010.0</td>\n",
              "      <td>19.000000</td>\n",
              "      <td>1.7</td>\n",
              "      <td>561.0</td>\n",
              "      <td>246.896735</td>\n",
              "      <td>1705.0</td>\n",
              "      <td>113.091251</td>\n",
              "      <td>1235.0</td>\n",
              "      <td>501.0</td>\n",
              "      <td>10.3</td>\n",
              "      <td>60.2</td>\n",
              "      <td>0.7517</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>04.00.00</td>\n",
              "      <td>2.15275</td>\n",
              "      <td>1011.0</td>\n",
              "      <td>14.000000</td>\n",
              "      <td>1.3</td>\n",
              "      <td>527.0</td>\n",
              "      <td>21.000000</td>\n",
              "      <td>1818.0</td>\n",
              "      <td>34.000000</td>\n",
              "      <td>1197.0</td>\n",
              "      <td>445.0</td>\n",
              "      <td>10.1</td>\n",
              "      <td>60.5</td>\n",
              "      <td>0.7465</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>05.00.00</td>\n",
              "      <td>0.70000</td>\n",
              "      <td>1066.0</td>\n",
              "      <td>8.000000</td>\n",
              "      <td>1.1</td>\n",
              "      <td>512.0</td>\n",
              "      <td>16.000000</td>\n",
              "      <td>1918.0</td>\n",
              "      <td>28.000000</td>\n",
              "      <td>1182.0</td>\n",
              "      <td>422.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>56.2</td>\n",
              "      <td>0.7366</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>06.00.00</td>\n",
              "      <td>0.70000</td>\n",
              "      <td>1052.0</td>\n",
              "      <td>16.000000</td>\n",
              "      <td>1.6</td>\n",
              "      <td>553.0</td>\n",
              "      <td>34.000000</td>\n",
              "      <td>1738.0</td>\n",
              "      <td>48.000000</td>\n",
              "      <td>1221.0</td>\n",
              "      <td>472.0</td>\n",
              "      <td>10.5</td>\n",
              "      <td>58.1</td>\n",
              "      <td>0.7353</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>07.00.00</td>\n",
              "      <td>1.10000</td>\n",
              "      <td>1144.0</td>\n",
              "      <td>29.000000</td>\n",
              "      <td>3.2</td>\n",
              "      <td>667.0</td>\n",
              "      <td>98.000000</td>\n",
              "      <td>1490.0</td>\n",
              "      <td>82.000000</td>\n",
              "      <td>1339.0</td>\n",
              "      <td>730.0</td>\n",
              "      <td>10.2</td>\n",
              "      <td>59.6</td>\n",
              "      <td>0.7417</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>08.00.00</td>\n",
              "      <td>2.00000</td>\n",
              "      <td>1333.0</td>\n",
              "      <td>64.000000</td>\n",
              "      <td>8.0</td>\n",
              "      <td>900.0</td>\n",
              "      <td>174.000000</td>\n",
              "      <td>1136.0</td>\n",
              "      <td>112.000000</td>\n",
              "      <td>1517.0</td>\n",
              "      <td>1102.0</td>\n",
              "      <td>10.8</td>\n",
              "      <td>57.4</td>\n",
              "      <td>0.7408</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>09.00.00</td>\n",
              "      <td>2.20000</td>\n",
              "      <td>1351.0</td>\n",
              "      <td>87.000000</td>\n",
              "      <td>9.5</td>\n",
              "      <td>960.0</td>\n",
              "      <td>129.000000</td>\n",
              "      <td>1079.0</td>\n",
              "      <td>101.000000</td>\n",
              "      <td>1583.0</td>\n",
              "      <td>1028.0</td>\n",
              "      <td>10.5</td>\n",
              "      <td>60.6</td>\n",
              "      <td>0.7691</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>10.00.00</td>\n",
              "      <td>1.70000</td>\n",
              "      <td>1233.0</td>\n",
              "      <td>77.000000</td>\n",
              "      <td>6.3</td>\n",
              "      <td>827.0</td>\n",
              "      <td>112.000000</td>\n",
              "      <td>1218.0</td>\n",
              "      <td>98.000000</td>\n",
              "      <td>1446.0</td>\n",
              "      <td>860.0</td>\n",
              "      <td>10.8</td>\n",
              "      <td>58.4</td>\n",
              "      <td>0.7552</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>11.00.00</td>\n",
              "      <td>1.50000</td>\n",
              "      <td>1179.0</td>\n",
              "      <td>43.000000</td>\n",
              "      <td>5.0</td>\n",
              "      <td>762.0</td>\n",
              "      <td>95.000000</td>\n",
              "      <td>1328.0</td>\n",
              "      <td>92.000000</td>\n",
              "      <td>1362.0</td>\n",
              "      <td>671.0</td>\n",
              "      <td>10.5</td>\n",
              "      <td>57.9</td>\n",
              "      <td>0.7352</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>12.00.00</td>\n",
              "      <td>1.60000</td>\n",
              "      <td>1236.0</td>\n",
              "      <td>61.000000</td>\n",
              "      <td>5.2</td>\n",
              "      <td>774.0</td>\n",
              "      <td>104.000000</td>\n",
              "      <td>1301.0</td>\n",
              "      <td>95.000000</td>\n",
              "      <td>1401.0</td>\n",
              "      <td>664.0</td>\n",
              "      <td>9.5</td>\n",
              "      <td>66.8</td>\n",
              "      <td>0.7951</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>13.00.00</td>\n",
              "      <td>1.90000</td>\n",
              "      <td>1286.0</td>\n",
              "      <td>63.000000</td>\n",
              "      <td>7.3</td>\n",
              "      <td>869.0</td>\n",
              "      <td>146.000000</td>\n",
              "      <td>1162.0</td>\n",
              "      <td>112.000000</td>\n",
              "      <td>1537.0</td>\n",
              "      <td>799.0</td>\n",
              "      <td>8.3</td>\n",
              "      <td>76.4</td>\n",
              "      <td>0.8393</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>14.00.00</td>\n",
              "      <td>2.90000</td>\n",
              "      <td>1371.0</td>\n",
              "      <td>164.000000</td>\n",
              "      <td>11.5</td>\n",
              "      <td>1034.0</td>\n",
              "      <td>207.000000</td>\n",
              "      <td>983.0</td>\n",
              "      <td>128.000000</td>\n",
              "      <td>1730.0</td>\n",
              "      <td>1037.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>81.1</td>\n",
              "      <td>0.8736</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>15.00.00</td>\n",
              "      <td>2.20000</td>\n",
              "      <td>1310.0</td>\n",
              "      <td>79.000000</td>\n",
              "      <td>8.8</td>\n",
              "      <td>933.0</td>\n",
              "      <td>184.000000</td>\n",
              "      <td>1082.0</td>\n",
              "      <td>126.000000</td>\n",
              "      <td>1647.0</td>\n",
              "      <td>946.0</td>\n",
              "      <td>8.3</td>\n",
              "      <td>79.8</td>\n",
              "      <td>0.8778</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>16.00.00</td>\n",
              "      <td>2.20000</td>\n",
              "      <td>1292.0</td>\n",
              "      <td>95.000000</td>\n",
              "      <td>8.3</td>\n",
              "      <td>912.0</td>\n",
              "      <td>193.000000</td>\n",
              "      <td>1103.0</td>\n",
              "      <td>131.000000</td>\n",
              "      <td>1591.0</td>\n",
              "      <td>957.0</td>\n",
              "      <td>9.7</td>\n",
              "      <td>71.2</td>\n",
              "      <td>0.8569</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>17.00.00</td>\n",
              "      <td>2.90000</td>\n",
              "      <td>1383.0</td>\n",
              "      <td>150.000000</td>\n",
              "      <td>11.2</td>\n",
              "      <td>1020.0</td>\n",
              "      <td>243.000000</td>\n",
              "      <td>1008.0</td>\n",
              "      <td>135.000000</td>\n",
              "      <td>1719.0</td>\n",
              "      <td>1104.0</td>\n",
              "      <td>9.8</td>\n",
              "      <td>67.6</td>\n",
              "      <td>0.8185</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>18.00.00</td>\n",
              "      <td>4.80000</td>\n",
              "      <td>1581.0</td>\n",
              "      <td>307.000000</td>\n",
              "      <td>20.8</td>\n",
              "      <td>1319.0</td>\n",
              "      <td>281.000000</td>\n",
              "      <td>799.0</td>\n",
              "      <td>151.000000</td>\n",
              "      <td>2083.0</td>\n",
              "      <td>1409.0</td>\n",
              "      <td>10.3</td>\n",
              "      <td>64.2</td>\n",
              "      <td>0.8065</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>19.00.00</td>\n",
              "      <td>6.90000</td>\n",
              "      <td>1776.0</td>\n",
              "      <td>461.000000</td>\n",
              "      <td>27.4</td>\n",
              "      <td>1488.0</td>\n",
              "      <td>383.000000</td>\n",
              "      <td>702.0</td>\n",
              "      <td>172.000000</td>\n",
              "      <td>2333.0</td>\n",
              "      <td>1704.0</td>\n",
              "      <td>9.7</td>\n",
              "      <td>69.3</td>\n",
              "      <td>0.8319</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>20.00.00</td>\n",
              "      <td>6.10000</td>\n",
              "      <td>1640.0</td>\n",
              "      <td>401.000000</td>\n",
              "      <td>24.0</td>\n",
              "      <td>1404.0</td>\n",
              "      <td>351.000000</td>\n",
              "      <td>743.0</td>\n",
              "      <td>165.000000</td>\n",
              "      <td>2191.0</td>\n",
              "      <td>1654.0</td>\n",
              "      <td>9.6</td>\n",
              "      <td>67.8</td>\n",
              "      <td>0.8133</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>21.00.00</td>\n",
              "      <td>3.90000</td>\n",
              "      <td>1313.0</td>\n",
              "      <td>197.000000</td>\n",
              "      <td>12.8</td>\n",
              "      <td>1076.0</td>\n",
              "      <td>240.000000</td>\n",
              "      <td>957.0</td>\n",
              "      <td>136.000000</td>\n",
              "      <td>1707.0</td>\n",
              "      <td>1285.0</td>\n",
              "      <td>9.1</td>\n",
              "      <td>64.0</td>\n",
              "      <td>0.7419</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>22.00.00</td>\n",
              "      <td>1.50000</td>\n",
              "      <td>965.0</td>\n",
              "      <td>61.000000</td>\n",
              "      <td>4.7</td>\n",
              "      <td>749.0</td>\n",
              "      <td>94.000000</td>\n",
              "      <td>1325.0</td>\n",
              "      <td>85.000000</td>\n",
              "      <td>1333.0</td>\n",
              "      <td>821.0</td>\n",
              "      <td>8.2</td>\n",
              "      <td>63.4</td>\n",
              "      <td>0.6905</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>1.078963e+18</td>\n",
              "      <td>23.00.00</td>\n",
              "      <td>1.00000</td>\n",
              "      <td>913.0</td>\n",
              "      <td>26.000000</td>\n",
              "      <td>2.6</td>\n",
              "      <td>629.0</td>\n",
              "      <td>47.000000</td>\n",
              "      <td>1565.0</td>\n",
              "      <td>53.000000</td>\n",
              "      <td>1252.0</td>\n",
              "      <td>552.0</td>\n",
              "      <td>8.2</td>\n",
              "      <td>60.8</td>\n",
              "      <td>0.6657</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9327</th>\n",
              "      <td>1.112486e+18</td>\n",
              "      <td>09.00.00</td>\n",
              "      <td>1.20000</td>\n",
              "      <td>1022.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>4.1</td>\n",
              "      <td>715.0</td>\n",
              "      <td>192.000000</td>\n",
              "      <td>806.0</td>\n",
              "      <td>118.000000</td>\n",
              "      <td>1004.0</td>\n",
              "      <td>831.0</td>\n",
              "      <td>17.8</td>\n",
              "      <td>30.7</td>\n",
              "      <td>0.6205</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9328</th>\n",
              "      <td>1.112486e+18</td>\n",
              "      <td>10.00.00</td>\n",
              "      <td>1.40000</td>\n",
              "      <td>970.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>3.4</td>\n",
              "      <td>677.0</td>\n",
              "      <td>166.000000</td>\n",
              "      <td>888.0</td>\n",
              "      <td>113.000000</td>\n",
              "      <td>931.0</td>\n",
              "      <td>613.0</td>\n",
              "      <td>21.1</td>\n",
              "      <td>23.7</td>\n",
              "      <td>0.5875</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9329</th>\n",
              "      <td>1.112486e+18</td>\n",
              "      <td>11.00.00</td>\n",
              "      <td>1.30000</td>\n",
              "      <td>1000.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>5.3</td>\n",
              "      <td>779.0</td>\n",
              "      <td>171.000000</td>\n",
              "      <td>805.0</td>\n",
              "      <td>115.000000</td>\n",
              "      <td>1001.0</td>\n",
              "      <td>640.0</td>\n",
              "      <td>24.0</td>\n",
              "      <td>19.3</td>\n",
              "      <td>0.5673</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9330</th>\n",
              "      <td>1.112486e+18</td>\n",
              "      <td>12.00.00</td>\n",
              "      <td>1.40000</td>\n",
              "      <td>996.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>5.3</td>\n",
              "      <td>781.0</td>\n",
              "      <td>177.000000</td>\n",
              "      <td>806.0</td>\n",
              "      <td>124.000000</td>\n",
              "      <td>985.0</td>\n",
              "      <td>631.0</td>\n",
              "      <td>26.5</td>\n",
              "      <td>16.4</td>\n",
              "      <td>0.5594</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9331</th>\n",
              "      <td>1.112486e+18</td>\n",
              "      <td>13.00.00</td>\n",
              "      <td>1.00000</td>\n",
              "      <td>928.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>3.8</td>\n",
              "      <td>701.0</td>\n",
              "      <td>119.000000</td>\n",
              "      <td>926.0</td>\n",
              "      <td>86.000000</td>\n",
              "      <td>902.0</td>\n",
              "      <td>456.0</td>\n",
              "      <td>28.7</td>\n",
              "      <td>13.7</td>\n",
              "      <td>0.5302</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9332</th>\n",
              "      <td>1.112486e+18</td>\n",
              "      <td>14.00.00</td>\n",
              "      <td>1.00000</td>\n",
              "      <td>933.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>4.2</td>\n",
              "      <td>722.0</td>\n",
              "      <td>121.000000</td>\n",
              "      <td>899.0</td>\n",
              "      <td>87.000000</td>\n",
              "      <td>890.0</td>\n",
              "      <td>450.0</td>\n",
              "      <td>28.5</td>\n",
              "      <td>13.1</td>\n",
              "      <td>0.5002</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9333</th>\n",
              "      <td>1.112486e+18</td>\n",
              "      <td>15.00.00</td>\n",
              "      <td>1.10000</td>\n",
              "      <td>956.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>5.4</td>\n",
              "      <td>783.0</td>\n",
              "      <td>142.000000</td>\n",
              "      <td>857.0</td>\n",
              "      <td>100.000000</td>\n",
              "      <td>896.0</td>\n",
              "      <td>516.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>11.1</td>\n",
              "      <td>0.4624</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9334</th>\n",
              "      <td>1.112486e+18</td>\n",
              "      <td>16.00.00</td>\n",
              "      <td>1.30000</td>\n",
              "      <td>968.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>6.3</td>\n",
              "      <td>826.0</td>\n",
              "      <td>197.000000</td>\n",
              "      <td>867.0</td>\n",
              "      <td>132.000000</td>\n",
              "      <td>898.0</td>\n",
              "      <td>548.0</td>\n",
              "      <td>29.4</td>\n",
              "      <td>10.4</td>\n",
              "      <td>0.4192</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9335</th>\n",
              "      <td>1.112486e+18</td>\n",
              "      <td>17.00.00</td>\n",
              "      <td>1.40000</td>\n",
              "      <td>953.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>6.1</td>\n",
              "      <td>817.0</td>\n",
              "      <td>242.000000</td>\n",
              "      <td>872.0</td>\n",
              "      <td>156.000000</td>\n",
              "      <td>891.0</td>\n",
              "      <td>603.0</td>\n",
              "      <td>28.9</td>\n",
              "      <td>9.9</td>\n",
              "      <td>0.3866</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9336</th>\n",
              "      <td>1.112486e+18</td>\n",
              "      <td>18.00.00</td>\n",
              "      <td>1.20000</td>\n",
              "      <td>1015.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>4.6</td>\n",
              "      <td>743.0</td>\n",
              "      <td>190.000000</td>\n",
              "      <td>851.0</td>\n",
              "      <td>138.000000</td>\n",
              "      <td>981.0</td>\n",
              "      <td>597.0</td>\n",
              "      <td>22.8</td>\n",
              "      <td>21.7</td>\n",
              "      <td>0.5945</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9337</th>\n",
              "      <td>1.112486e+18</td>\n",
              "      <td>19.00.00</td>\n",
              "      <td>2.70000</td>\n",
              "      <td>1248.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>11.1</td>\n",
              "      <td>1018.0</td>\n",
              "      <td>367.000000</td>\n",
              "      <td>599.0</td>\n",
              "      <td>181.000000</td>\n",
              "      <td>1289.0</td>\n",
              "      <td>1167.0</td>\n",
              "      <td>19.9</td>\n",
              "      <td>33.0</td>\n",
              "      <td>0.7608</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9338</th>\n",
              "      <td>1.112486e+18</td>\n",
              "      <td>20.00.00</td>\n",
              "      <td>2.50000</td>\n",
              "      <td>1180.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>7.9</td>\n",
              "      <td>894.0</td>\n",
              "      <td>355.000000</td>\n",
              "      <td>636.0</td>\n",
              "      <td>187.000000</td>\n",
              "      <td>1200.0</td>\n",
              "      <td>1372.0</td>\n",
              "      <td>17.5</td>\n",
              "      <td>40.7</td>\n",
              "      <td>0.8073</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9339</th>\n",
              "      <td>1.112486e+18</td>\n",
              "      <td>21.00.00</td>\n",
              "      <td>1.50000</td>\n",
              "      <td>1102.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>6.0</td>\n",
              "      <td>812.0</td>\n",
              "      <td>235.000000</td>\n",
              "      <td>693.0</td>\n",
              "      <td>158.000000</td>\n",
              "      <td>1178.0</td>\n",
              "      <td>1042.0</td>\n",
              "      <td>16.4</td>\n",
              "      <td>46.6</td>\n",
              "      <td>0.8642</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9340</th>\n",
              "      <td>1.112486e+18</td>\n",
              "      <td>22.00.00</td>\n",
              "      <td>1.60000</td>\n",
              "      <td>1116.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>5.8</td>\n",
              "      <td>803.0</td>\n",
              "      <td>233.000000</td>\n",
              "      <td>696.0</td>\n",
              "      <td>153.000000</td>\n",
              "      <td>1173.0</td>\n",
              "      <td>1055.0</td>\n",
              "      <td>15.5</td>\n",
              "      <td>49.0</td>\n",
              "      <td>0.8579</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9341</th>\n",
              "      <td>1.112486e+18</td>\n",
              "      <td>23.00.00</td>\n",
              "      <td>1.20000</td>\n",
              "      <td>1100.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>5.1</td>\n",
              "      <td>769.0</td>\n",
              "      <td>170.000000</td>\n",
              "      <td>722.0</td>\n",
              "      <td>128.000000</td>\n",
              "      <td>1147.0</td>\n",
              "      <td>1049.0</td>\n",
              "      <td>14.3</td>\n",
              "      <td>52.5</td>\n",
              "      <td>0.8497</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9342</th>\n",
              "      <td>1.112573e+18</td>\n",
              "      <td>00.00.00</td>\n",
              "      <td>0.90000</td>\n",
              "      <td>1012.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>3.5</td>\n",
              "      <td>683.0</td>\n",
              "      <td>117.000000</td>\n",
              "      <td>801.0</td>\n",
              "      <td>93.000000</td>\n",
              "      <td>1073.0</td>\n",
              "      <td>816.0</td>\n",
              "      <td>14.2</td>\n",
              "      <td>51.4</td>\n",
              "      <td>0.8275</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9343</th>\n",
              "      <td>1.112573e+18</td>\n",
              "      <td>01.00.00</td>\n",
              "      <td>0.60000</td>\n",
              "      <td>944.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>1.9</td>\n",
              "      <td>579.0</td>\n",
              "      <td>70.000000</td>\n",
              "      <td>925.0</td>\n",
              "      <td>58.000000</td>\n",
              "      <td>1002.0</td>\n",
              "      <td>598.0</td>\n",
              "      <td>13.8</td>\n",
              "      <td>51.2</td>\n",
              "      <td>0.8058</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9344</th>\n",
              "      <td>1.112573e+18</td>\n",
              "      <td>02.00.00</td>\n",
              "      <td>0.50000</td>\n",
              "      <td>912.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>1.5</td>\n",
              "      <td>544.0</td>\n",
              "      <td>69.000000</td>\n",
              "      <td>959.0</td>\n",
              "      <td>55.000000</td>\n",
              "      <td>1002.0</td>\n",
              "      <td>573.0</td>\n",
              "      <td>12.1</td>\n",
              "      <td>56.3</td>\n",
              "      <td>0.7927</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9345</th>\n",
              "      <td>1.112573e+18</td>\n",
              "      <td>03.00.00</td>\n",
              "      <td>0.40000</td>\n",
              "      <td>887.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>1.1</td>\n",
              "      <td>508.0</td>\n",
              "      <td>62.000000</td>\n",
              "      <td>1047.0</td>\n",
              "      <td>51.000000</td>\n",
              "      <td>974.0</td>\n",
              "      <td>549.0</td>\n",
              "      <td>11.3</td>\n",
              "      <td>58.9</td>\n",
              "      <td>0.7888</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9346</th>\n",
              "      <td>1.112573e+18</td>\n",
              "      <td>04.00.00</td>\n",
              "      <td>2.15275</td>\n",
              "      <td>864.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>0.8</td>\n",
              "      <td>478.0</td>\n",
              "      <td>52.000000</td>\n",
              "      <td>1116.0</td>\n",
              "      <td>43.000000</td>\n",
              "      <td>958.0</td>\n",
              "      <td>489.0</td>\n",
              "      <td>11.8</td>\n",
              "      <td>56.0</td>\n",
              "      <td>0.7743</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9347</th>\n",
              "      <td>1.112573e+18</td>\n",
              "      <td>05.00.00</td>\n",
              "      <td>0.50000</td>\n",
              "      <td>888.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>1.3</td>\n",
              "      <td>528.0</td>\n",
              "      <td>77.000000</td>\n",
              "      <td>1077.0</td>\n",
              "      <td>53.000000</td>\n",
              "      <td>987.0</td>\n",
              "      <td>578.0</td>\n",
              "      <td>10.4</td>\n",
              "      <td>59.9</td>\n",
              "      <td>0.7550</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9348</th>\n",
              "      <td>1.112573e+18</td>\n",
              "      <td>06.00.00</td>\n",
              "      <td>1.10000</td>\n",
              "      <td>1031.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>4.4</td>\n",
              "      <td>730.0</td>\n",
              "      <td>182.000000</td>\n",
              "      <td>760.0</td>\n",
              "      <td>93.000000</td>\n",
              "      <td>1129.0</td>\n",
              "      <td>905.0</td>\n",
              "      <td>9.5</td>\n",
              "      <td>63.1</td>\n",
              "      <td>0.7531</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9349</th>\n",
              "      <td>1.112573e+18</td>\n",
              "      <td>07.00.00</td>\n",
              "      <td>4.00000</td>\n",
              "      <td>1384.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>17.4</td>\n",
              "      <td>1221.0</td>\n",
              "      <td>594.000000</td>\n",
              "      <td>470.0</td>\n",
              "      <td>155.000000</td>\n",
              "      <td>1600.0</td>\n",
              "      <td>1457.0</td>\n",
              "      <td>9.7</td>\n",
              "      <td>61.9</td>\n",
              "      <td>0.7446</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9350</th>\n",
              "      <td>1.112573e+18</td>\n",
              "      <td>08.00.00</td>\n",
              "      <td>5.00000</td>\n",
              "      <td>1446.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>22.4</td>\n",
              "      <td>1362.0</td>\n",
              "      <td>586.000000</td>\n",
              "      <td>415.0</td>\n",
              "      <td>174.000000</td>\n",
              "      <td>1777.0</td>\n",
              "      <td>1705.0</td>\n",
              "      <td>13.5</td>\n",
              "      <td>48.9</td>\n",
              "      <td>0.7553</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9351</th>\n",
              "      <td>1.112573e+18</td>\n",
              "      <td>09.00.00</td>\n",
              "      <td>3.90000</td>\n",
              "      <td>1297.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>13.6</td>\n",
              "      <td>1102.0</td>\n",
              "      <td>523.000000</td>\n",
              "      <td>507.0</td>\n",
              "      <td>187.000000</td>\n",
              "      <td>1375.0</td>\n",
              "      <td>1583.0</td>\n",
              "      <td>18.2</td>\n",
              "      <td>36.3</td>\n",
              "      <td>0.7487</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9352</th>\n",
              "      <td>1.112573e+18</td>\n",
              "      <td>10.00.00</td>\n",
              "      <td>3.10000</td>\n",
              "      <td>1314.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>13.5</td>\n",
              "      <td>1101.0</td>\n",
              "      <td>472.000000</td>\n",
              "      <td>539.0</td>\n",
              "      <td>190.000000</td>\n",
              "      <td>1374.0</td>\n",
              "      <td>1729.0</td>\n",
              "      <td>21.9</td>\n",
              "      <td>29.3</td>\n",
              "      <td>0.7568</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9353</th>\n",
              "      <td>1.112573e+18</td>\n",
              "      <td>11.00.00</td>\n",
              "      <td>2.40000</td>\n",
              "      <td>1163.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>11.4</td>\n",
              "      <td>1027.0</td>\n",
              "      <td>353.000000</td>\n",
              "      <td>604.0</td>\n",
              "      <td>179.000000</td>\n",
              "      <td>1264.0</td>\n",
              "      <td>1269.0</td>\n",
              "      <td>24.3</td>\n",
              "      <td>23.7</td>\n",
              "      <td>0.7119</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9354</th>\n",
              "      <td>1.112573e+18</td>\n",
              "      <td>12.00.00</td>\n",
              "      <td>2.40000</td>\n",
              "      <td>1142.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>12.4</td>\n",
              "      <td>1063.0</td>\n",
              "      <td>293.000000</td>\n",
              "      <td>603.0</td>\n",
              "      <td>175.000000</td>\n",
              "      <td>1241.0</td>\n",
              "      <td>1092.0</td>\n",
              "      <td>26.9</td>\n",
              "      <td>18.3</td>\n",
              "      <td>0.6406</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9355</th>\n",
              "      <td>1.112573e+18</td>\n",
              "      <td>13.00.00</td>\n",
              "      <td>2.10000</td>\n",
              "      <td>1003.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>9.5</td>\n",
              "      <td>961.0</td>\n",
              "      <td>235.000000</td>\n",
              "      <td>702.0</td>\n",
              "      <td>156.000000</td>\n",
              "      <td>1041.0</td>\n",
              "      <td>770.0</td>\n",
              "      <td>28.3</td>\n",
              "      <td>13.5</td>\n",
              "      <td>0.5139</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9356</th>\n",
              "      <td>1.112573e+18</td>\n",
              "      <td>14.00.00</td>\n",
              "      <td>2.20000</td>\n",
              "      <td>1071.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>11.9</td>\n",
              "      <td>1047.0</td>\n",
              "      <td>265.000000</td>\n",
              "      <td>654.0</td>\n",
              "      <td>168.000000</td>\n",
              "      <td>1129.0</td>\n",
              "      <td>816.0</td>\n",
              "      <td>28.5</td>\n",
              "      <td>13.1</td>\n",
              "      <td>0.5028</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>9357 rows × 15 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "              Date      Time   CO(GT)  PT08.S1(CO)    NMHC(GT)  C6H6(GT)  \\\n",
              "0     1.078877e+18  18.00.00  2.60000       1360.0  150.000000      11.9   \n",
              "1     1.078877e+18  19.00.00  2.00000       1292.0  112.000000       9.4   \n",
              "2     1.078877e+18  20.00.00  2.20000       1402.0   88.000000       9.0   \n",
              "3     1.078877e+18  21.00.00  2.20000       1376.0   80.000000       9.2   \n",
              "4     1.078877e+18  22.00.00  1.60000       1272.0   51.000000       6.5   \n",
              "5     1.078877e+18  23.00.00  1.20000       1197.0   38.000000       4.7   \n",
              "6     1.078963e+18  00.00.00  1.20000       1185.0   31.000000       3.6   \n",
              "7     1.078963e+18  01.00.00  1.00000       1136.0   31.000000       3.3   \n",
              "8     1.078963e+18  02.00.00  0.90000       1094.0   24.000000       2.3   \n",
              "9     1.078963e+18  03.00.00  0.60000       1010.0   19.000000       1.7   \n",
              "10    1.078963e+18  04.00.00  2.15275       1011.0   14.000000       1.3   \n",
              "11    1.078963e+18  05.00.00  0.70000       1066.0    8.000000       1.1   \n",
              "12    1.078963e+18  06.00.00  0.70000       1052.0   16.000000       1.6   \n",
              "13    1.078963e+18  07.00.00  1.10000       1144.0   29.000000       3.2   \n",
              "14    1.078963e+18  08.00.00  2.00000       1333.0   64.000000       8.0   \n",
              "15    1.078963e+18  09.00.00  2.20000       1351.0   87.000000       9.5   \n",
              "16    1.078963e+18  10.00.00  1.70000       1233.0   77.000000       6.3   \n",
              "17    1.078963e+18  11.00.00  1.50000       1179.0   43.000000       5.0   \n",
              "18    1.078963e+18  12.00.00  1.60000       1236.0   61.000000       5.2   \n",
              "19    1.078963e+18  13.00.00  1.90000       1286.0   63.000000       7.3   \n",
              "20    1.078963e+18  14.00.00  2.90000       1371.0  164.000000      11.5   \n",
              "21    1.078963e+18  15.00.00  2.20000       1310.0   79.000000       8.8   \n",
              "22    1.078963e+18  16.00.00  2.20000       1292.0   95.000000       8.3   \n",
              "23    1.078963e+18  17.00.00  2.90000       1383.0  150.000000      11.2   \n",
              "24    1.078963e+18  18.00.00  4.80000       1581.0  307.000000      20.8   \n",
              "25    1.078963e+18  19.00.00  6.90000       1776.0  461.000000      27.4   \n",
              "26    1.078963e+18  20.00.00  6.10000       1640.0  401.000000      24.0   \n",
              "27    1.078963e+18  21.00.00  3.90000       1313.0  197.000000      12.8   \n",
              "28    1.078963e+18  22.00.00  1.50000        965.0   61.000000       4.7   \n",
              "29    1.078963e+18  23.00.00  1.00000        913.0   26.000000       2.6   \n",
              "...            ...       ...      ...          ...         ...       ...   \n",
              "9327  1.112486e+18  09.00.00  1.20000       1022.0  218.811816       4.1   \n",
              "9328  1.112486e+18  10.00.00  1.40000        970.0  218.811816       3.4   \n",
              "9329  1.112486e+18  11.00.00  1.30000       1000.0  218.811816       5.3   \n",
              "9330  1.112486e+18  12.00.00  1.40000        996.0  218.811816       5.3   \n",
              "9331  1.112486e+18  13.00.00  1.00000        928.0  218.811816       3.8   \n",
              "9332  1.112486e+18  14.00.00  1.00000        933.0  218.811816       4.2   \n",
              "9333  1.112486e+18  15.00.00  1.10000        956.0  218.811816       5.4   \n",
              "9334  1.112486e+18  16.00.00  1.30000        968.0  218.811816       6.3   \n",
              "9335  1.112486e+18  17.00.00  1.40000        953.0  218.811816       6.1   \n",
              "9336  1.112486e+18  18.00.00  1.20000       1015.0  218.811816       4.6   \n",
              "9337  1.112486e+18  19.00.00  2.70000       1248.0  218.811816      11.1   \n",
              "9338  1.112486e+18  20.00.00  2.50000       1180.0  218.811816       7.9   \n",
              "9339  1.112486e+18  21.00.00  1.50000       1102.0  218.811816       6.0   \n",
              "9340  1.112486e+18  22.00.00  1.60000       1116.0  218.811816       5.8   \n",
              "9341  1.112486e+18  23.00.00  1.20000       1100.0  218.811816       5.1   \n",
              "9342  1.112573e+18  00.00.00  0.90000       1012.0  218.811816       3.5   \n",
              "9343  1.112573e+18  01.00.00  0.60000        944.0  218.811816       1.9   \n",
              "9344  1.112573e+18  02.00.00  0.50000        912.0  218.811816       1.5   \n",
              "9345  1.112573e+18  03.00.00  0.40000        887.0  218.811816       1.1   \n",
              "9346  1.112573e+18  04.00.00  2.15275        864.0  218.811816       0.8   \n",
              "9347  1.112573e+18  05.00.00  0.50000        888.0  218.811816       1.3   \n",
              "9348  1.112573e+18  06.00.00  1.10000       1031.0  218.811816       4.4   \n",
              "9349  1.112573e+18  07.00.00  4.00000       1384.0  218.811816      17.4   \n",
              "9350  1.112573e+18  08.00.00  5.00000       1446.0  218.811816      22.4   \n",
              "9351  1.112573e+18  09.00.00  3.90000       1297.0  218.811816      13.6   \n",
              "9352  1.112573e+18  10.00.00  3.10000       1314.0  218.811816      13.5   \n",
              "9353  1.112573e+18  11.00.00  2.40000       1163.0  218.811816      11.4   \n",
              "9354  1.112573e+18  12.00.00  2.40000       1142.0  218.811816      12.4   \n",
              "9355  1.112573e+18  13.00.00  2.10000       1003.0  218.811816       9.5   \n",
              "9356  1.112573e+18  14.00.00  2.20000       1071.0  218.811816      11.9   \n",
              "\n",
              "      PT08.S2(NMHC)     NOx(GT)  PT08.S3(NOx)     NO2(GT)  PT08.S4(NO2)  \\\n",
              "0            1046.0  166.000000        1056.0  113.000000        1692.0   \n",
              "1             955.0  103.000000        1174.0   92.000000        1559.0   \n",
              "2             939.0  131.000000        1140.0  114.000000        1555.0   \n",
              "3             948.0  172.000000        1092.0  122.000000        1584.0   \n",
              "4             836.0  131.000000        1205.0  116.000000        1490.0   \n",
              "5             750.0   89.000000        1337.0   96.000000        1393.0   \n",
              "6             690.0   62.000000        1462.0   77.000000        1333.0   \n",
              "7             672.0   62.000000        1453.0   76.000000        1333.0   \n",
              "8             609.0   45.000000        1579.0   60.000000        1276.0   \n",
              "9             561.0  246.896735        1705.0  113.091251        1235.0   \n",
              "10            527.0   21.000000        1818.0   34.000000        1197.0   \n",
              "11            512.0   16.000000        1918.0   28.000000        1182.0   \n",
              "12            553.0   34.000000        1738.0   48.000000        1221.0   \n",
              "13            667.0   98.000000        1490.0   82.000000        1339.0   \n",
              "14            900.0  174.000000        1136.0  112.000000        1517.0   \n",
              "15            960.0  129.000000        1079.0  101.000000        1583.0   \n",
              "16            827.0  112.000000        1218.0   98.000000        1446.0   \n",
              "17            762.0   95.000000        1328.0   92.000000        1362.0   \n",
              "18            774.0  104.000000        1301.0   95.000000        1401.0   \n",
              "19            869.0  146.000000        1162.0  112.000000        1537.0   \n",
              "20           1034.0  207.000000         983.0  128.000000        1730.0   \n",
              "21            933.0  184.000000        1082.0  126.000000        1647.0   \n",
              "22            912.0  193.000000        1103.0  131.000000        1591.0   \n",
              "23           1020.0  243.000000        1008.0  135.000000        1719.0   \n",
              "24           1319.0  281.000000         799.0  151.000000        2083.0   \n",
              "25           1488.0  383.000000         702.0  172.000000        2333.0   \n",
              "26           1404.0  351.000000         743.0  165.000000        2191.0   \n",
              "27           1076.0  240.000000         957.0  136.000000        1707.0   \n",
              "28            749.0   94.000000        1325.0   85.000000        1333.0   \n",
              "29            629.0   47.000000        1565.0   53.000000        1252.0   \n",
              "...             ...         ...           ...         ...           ...   \n",
              "9327          715.0  192.000000         806.0  118.000000        1004.0   \n",
              "9328          677.0  166.000000         888.0  113.000000         931.0   \n",
              "9329          779.0  171.000000         805.0  115.000000        1001.0   \n",
              "9330          781.0  177.000000         806.0  124.000000         985.0   \n",
              "9331          701.0  119.000000         926.0   86.000000         902.0   \n",
              "9332          722.0  121.000000         899.0   87.000000         890.0   \n",
              "9333          783.0  142.000000         857.0  100.000000         896.0   \n",
              "9334          826.0  197.000000         867.0  132.000000         898.0   \n",
              "9335          817.0  242.000000         872.0  156.000000         891.0   \n",
              "9336          743.0  190.000000         851.0  138.000000         981.0   \n",
              "9337         1018.0  367.000000         599.0  181.000000        1289.0   \n",
              "9338          894.0  355.000000         636.0  187.000000        1200.0   \n",
              "9339          812.0  235.000000         693.0  158.000000        1178.0   \n",
              "9340          803.0  233.000000         696.0  153.000000        1173.0   \n",
              "9341          769.0  170.000000         722.0  128.000000        1147.0   \n",
              "9342          683.0  117.000000         801.0   93.000000        1073.0   \n",
              "9343          579.0   70.000000         925.0   58.000000        1002.0   \n",
              "9344          544.0   69.000000         959.0   55.000000        1002.0   \n",
              "9345          508.0   62.000000        1047.0   51.000000         974.0   \n",
              "9346          478.0   52.000000        1116.0   43.000000         958.0   \n",
              "9347          528.0   77.000000        1077.0   53.000000         987.0   \n",
              "9348          730.0  182.000000         760.0   93.000000        1129.0   \n",
              "9349         1221.0  594.000000         470.0  155.000000        1600.0   \n",
              "9350         1362.0  586.000000         415.0  174.000000        1777.0   \n",
              "9351         1102.0  523.000000         507.0  187.000000        1375.0   \n",
              "9352         1101.0  472.000000         539.0  190.000000        1374.0   \n",
              "9353         1027.0  353.000000         604.0  179.000000        1264.0   \n",
              "9354         1063.0  293.000000         603.0  175.000000        1241.0   \n",
              "9355          961.0  235.000000         702.0  156.000000        1041.0   \n",
              "9356         1047.0  265.000000         654.0  168.000000        1129.0   \n",
              "\n",
              "      PT08.S5(O3)     T    RH      AH  \n",
              "0          1268.0  13.6  48.9  0.7578  \n",
              "1           972.0  13.3  47.7  0.7255  \n",
              "2          1074.0  11.9  54.0  0.7502  \n",
              "3          1203.0  11.0  60.0  0.7867  \n",
              "4          1110.0  11.2  59.6  0.7888  \n",
              "5           949.0  11.2  59.2  0.7848  \n",
              "6           733.0  11.3  56.8  0.7603  \n",
              "7           730.0  10.7  60.0  0.7702  \n",
              "8           620.0  10.7  59.7  0.7648  \n",
              "9           501.0  10.3  60.2  0.7517  \n",
              "10          445.0  10.1  60.5  0.7465  \n",
              "11          422.0  11.0  56.2  0.7366  \n",
              "12          472.0  10.5  58.1  0.7353  \n",
              "13          730.0  10.2  59.6  0.7417  \n",
              "14         1102.0  10.8  57.4  0.7408  \n",
              "15         1028.0  10.5  60.6  0.7691  \n",
              "16          860.0  10.8  58.4  0.7552  \n",
              "17          671.0  10.5  57.9  0.7352  \n",
              "18          664.0   9.5  66.8  0.7951  \n",
              "19          799.0   8.3  76.4  0.8393  \n",
              "20         1037.0   8.0  81.1  0.8736  \n",
              "21          946.0   8.3  79.8  0.8778  \n",
              "22          957.0   9.7  71.2  0.8569  \n",
              "23         1104.0   9.8  67.6  0.8185  \n",
              "24         1409.0  10.3  64.2  0.8065  \n",
              "25         1704.0   9.7  69.3  0.8319  \n",
              "26         1654.0   9.6  67.8  0.8133  \n",
              "27         1285.0   9.1  64.0  0.7419  \n",
              "28          821.0   8.2  63.4  0.6905  \n",
              "29          552.0   8.2  60.8  0.6657  \n",
              "...           ...   ...   ...     ...  \n",
              "9327        831.0  17.8  30.7  0.6205  \n",
              "9328        613.0  21.1  23.7  0.5875  \n",
              "9329        640.0  24.0  19.3  0.5673  \n",
              "9330        631.0  26.5  16.4  0.5594  \n",
              "9331        456.0  28.7  13.7  0.5302  \n",
              "9332        450.0  28.5  13.1  0.5002  \n",
              "9333        516.0  30.0  11.1  0.4624  \n",
              "9334        548.0  29.4  10.4  0.4192  \n",
              "9335        603.0  28.9   9.9  0.3866  \n",
              "9336        597.0  22.8  21.7  0.5945  \n",
              "9337       1167.0  19.9  33.0  0.7608  \n",
              "9338       1372.0  17.5  40.7  0.8073  \n",
              "9339       1042.0  16.4  46.6  0.8642  \n",
              "9340       1055.0  15.5  49.0  0.8579  \n",
              "9341       1049.0  14.3  52.5  0.8497  \n",
              "9342        816.0  14.2  51.4  0.8275  \n",
              "9343        598.0  13.8  51.2  0.8058  \n",
              "9344        573.0  12.1  56.3  0.7927  \n",
              "9345        549.0  11.3  58.9  0.7888  \n",
              "9346        489.0  11.8  56.0  0.7743  \n",
              "9347        578.0  10.4  59.9  0.7550  \n",
              "9348        905.0   9.5  63.1  0.7531  \n",
              "9349       1457.0   9.7  61.9  0.7446  \n",
              "9350       1705.0  13.5  48.9  0.7553  \n",
              "9351       1583.0  18.2  36.3  0.7487  \n",
              "9352       1729.0  21.9  29.3  0.7568  \n",
              "9353       1269.0  24.3  23.7  0.7119  \n",
              "9354       1092.0  26.9  18.3  0.6406  \n",
              "9355        770.0  28.3  13.5  0.5139  \n",
              "9356        816.0  28.5  13.1  0.5028  \n",
              "\n",
              "[9357 rows x 15 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "metadata": {
        "id": "SlXtpaufUGzX",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        " air_quality.loc[:,'Time']=air_quality['Time']"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "jKVIJ4jIUGza",
        "colab_type": "code",
        "colab": {},
        "outputId": "d18605ad-83b8-46d6-834a-7d8f492a325b"
      },
      "cell_type": "code",
      "source": [
        "from datetime import datetime\n",
        "Time= []\n",
        "for i in air_quality['Time']:\n",
        "    Time.append(datetime.strptime(i,'%H.%M.%S'))\n",
        "air_quality.dtypes"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Date             float64\n",
              "Time              object\n",
              "CO(GT)           float64\n",
              "PT08.S1(CO)      float64\n",
              "NMHC(GT)         float64\n",
              "C6H6(GT)         float64\n",
              "PT08.S2(NMHC)    float64\n",
              "NOx(GT)          float64\n",
              "PT08.S3(NOx)     float64\n",
              "NO2(GT)          float64\n",
              "PT08.S4(NO2)     float64\n",
              "PT08.S5(O3)      float64\n",
              "T                float64\n",
              "RH               float64\n",
              "AH               float64\n",
              "dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 11
        }
      ]
    },
    {
      "metadata": {
        "id": "GeToC78LUGze",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "time=pd.Series(Time)\n",
        "air_quality['Time']=pd.to_numeric(time)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "95zm5r9nUGzh",
        "colab_type": "code",
        "colab": {},
        "outputId": "d304d8c1-d521-43f9-9132-cbf2b44b5adb"
      },
      "cell_type": "code",
      "source": [
        "air_quality['Time']=air_quality['Time'].astype(float)\n",
        "air_quality.dtypes"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Date             float64\n",
              "Time             float64\n",
              "CO(GT)           float64\n",
              "PT08.S1(CO)      float64\n",
              "NMHC(GT)         float64\n",
              "C6H6(GT)         float64\n",
              "PT08.S2(NMHC)    float64\n",
              "NOx(GT)          float64\n",
              "PT08.S3(NOx)     float64\n",
              "NO2(GT)          float64\n",
              "PT08.S4(NO2)     float64\n",
              "PT08.S5(O3)      float64\n",
              "T                float64\n",
              "RH               float64\n",
              "AH               float64\n",
              "dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 13
        }
      ]
    },
    {
      "metadata": {
        "id": "xaXEkqa2UGzn",
        "colab_type": "code",
        "colab": {},
        "outputId": "267bd99e-5857-4679-f623-8a7e01eecfc9"
      },
      "cell_type": "code",
      "source": [
        "air_quality.tail()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Date</th>\n",
              "      <th>Time</th>\n",
              "      <th>CO(GT)</th>\n",
              "      <th>PT08.S1(CO)</th>\n",
              "      <th>NMHC(GT)</th>\n",
              "      <th>C6H6(GT)</th>\n",
              "      <th>PT08.S2(NMHC)</th>\n",
              "      <th>NOx(GT)</th>\n",
              "      <th>PT08.S3(NOx)</th>\n",
              "      <th>NO2(GT)</th>\n",
              "      <th>PT08.S4(NO2)</th>\n",
              "      <th>PT08.S5(O3)</th>\n",
              "      <th>T</th>\n",
              "      <th>RH</th>\n",
              "      <th>AH</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>9352</th>\n",
              "      <td>1.112573e+18</td>\n",
              "      <td>-2.208953e+18</td>\n",
              "      <td>3.1</td>\n",
              "      <td>1314.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>13.5</td>\n",
              "      <td>1101.0</td>\n",
              "      <td>472.0</td>\n",
              "      <td>539.0</td>\n",
              "      <td>190.0</td>\n",
              "      <td>1374.0</td>\n",
              "      <td>1729.0</td>\n",
              "      <td>21.9</td>\n",
              "      <td>29.3</td>\n",
              "      <td>0.7568</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9353</th>\n",
              "      <td>1.112573e+18</td>\n",
              "      <td>-2.208949e+18</td>\n",
              "      <td>2.4</td>\n",
              "      <td>1163.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>11.4</td>\n",
              "      <td>1027.0</td>\n",
              "      <td>353.0</td>\n",
              "      <td>604.0</td>\n",
              "      <td>179.0</td>\n",
              "      <td>1264.0</td>\n",
              "      <td>1269.0</td>\n",
              "      <td>24.3</td>\n",
              "      <td>23.7</td>\n",
              "      <td>0.7119</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9354</th>\n",
              "      <td>1.112573e+18</td>\n",
              "      <td>-2.208946e+18</td>\n",
              "      <td>2.4</td>\n",
              "      <td>1142.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>12.4</td>\n",
              "      <td>1063.0</td>\n",
              "      <td>293.0</td>\n",
              "      <td>603.0</td>\n",
              "      <td>175.0</td>\n",
              "      <td>1241.0</td>\n",
              "      <td>1092.0</td>\n",
              "      <td>26.9</td>\n",
              "      <td>18.3</td>\n",
              "      <td>0.6406</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9355</th>\n",
              "      <td>1.112573e+18</td>\n",
              "      <td>-2.208942e+18</td>\n",
              "      <td>2.1</td>\n",
              "      <td>1003.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>9.5</td>\n",
              "      <td>961.0</td>\n",
              "      <td>235.0</td>\n",
              "      <td>702.0</td>\n",
              "      <td>156.0</td>\n",
              "      <td>1041.0</td>\n",
              "      <td>770.0</td>\n",
              "      <td>28.3</td>\n",
              "      <td>13.5</td>\n",
              "      <td>0.5139</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9356</th>\n",
              "      <td>1.112573e+18</td>\n",
              "      <td>-2.208938e+18</td>\n",
              "      <td>2.2</td>\n",
              "      <td>1071.0</td>\n",
              "      <td>218.811816</td>\n",
              "      <td>11.9</td>\n",
              "      <td>1047.0</td>\n",
              "      <td>265.0</td>\n",
              "      <td>654.0</td>\n",
              "      <td>168.0</td>\n",
              "      <td>1129.0</td>\n",
              "      <td>816.0</td>\n",
              "      <td>28.5</td>\n",
              "      <td>13.1</td>\n",
              "      <td>0.5028</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "              Date          Time  CO(GT)  PT08.S1(CO)    NMHC(GT)  C6H6(GT)  \\\n",
              "9352  1.112573e+18 -2.208953e+18     3.1       1314.0  218.811816      13.5   \n",
              "9353  1.112573e+18 -2.208949e+18     2.4       1163.0  218.811816      11.4   \n",
              "9354  1.112573e+18 -2.208946e+18     2.4       1142.0  218.811816      12.4   \n",
              "9355  1.112573e+18 -2.208942e+18     2.1       1003.0  218.811816       9.5   \n",
              "9356  1.112573e+18 -2.208938e+18     2.2       1071.0  218.811816      11.9   \n",
              "\n",
              "      PT08.S2(NMHC)  NOx(GT)  PT08.S3(NOx)  NO2(GT)  PT08.S4(NO2)  \\\n",
              "9352         1101.0    472.0         539.0    190.0        1374.0   \n",
              "9353         1027.0    353.0         604.0    179.0        1264.0   \n",
              "9354         1063.0    293.0         603.0    175.0        1241.0   \n",
              "9355          961.0    235.0         702.0    156.0        1041.0   \n",
              "9356         1047.0    265.0         654.0    168.0        1129.0   \n",
              "\n",
              "      PT08.S5(O3)     T    RH      AH  \n",
              "9352       1729.0  21.9  29.3  0.7568  \n",
              "9353       1269.0  24.3  23.7  0.7119  \n",
              "9354       1092.0  26.9  18.3  0.6406  \n",
              "9355        770.0  28.3  13.5  0.5139  \n",
              "9356        816.0  28.5  13.1  0.5028  "
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 14
        }
      ]
    },
    {
      "metadata": {
        "id": "UfI0JIj6UGzr",
        "colab_type": "code",
        "colab": {},
        "outputId": "2dd55a18-bf31-49d2-a3fa-d85813c30169"
      },
      "cell_type": "code",
      "source": [
        "air_quality2=air_quality.corr('pearson')\n",
        "air_quality2"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Date</th>\n",
              "      <th>Time</th>\n",
              "      <th>CO(GT)</th>\n",
              "      <th>PT08.S1(CO)</th>\n",
              "      <th>NMHC(GT)</th>\n",
              "      <th>C6H6(GT)</th>\n",
              "      <th>PT08.S2(NMHC)</th>\n",
              "      <th>NOx(GT)</th>\n",
              "      <th>PT08.S3(NOx)</th>\n",
              "      <th>NO2(GT)</th>\n",
              "      <th>PT08.S4(NO2)</th>\n",
              "      <th>PT08.S5(O3)</th>\n",
              "      <th>T</th>\n",
              "      <th>RH</th>\n",
              "      <th>AH</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>Date</th>\n",
              "      <td>1.000000</td>\n",
              "      <td>-0.003249</td>\n",
              "      <td>0.041514</td>\n",
              "      <td>-0.003232</td>\n",
              "      <td>0.008010</td>\n",
              "      <td>-0.064007</td>\n",
              "      <td>-0.083633</td>\n",
              "      <td>0.401280</td>\n",
              "      <td>-0.251775</td>\n",
              "      <td>0.349315</td>\n",
              "      <td>-0.517637</td>\n",
              "      <td>0.103508</td>\n",
              "      <td>-0.450032</td>\n",
              "      <td>0.212245</td>\n",
              "      <td>-0.310146</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Time</th>\n",
              "      <td>-0.003249</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.323944</td>\n",
              "      <td>0.321097</td>\n",
              "      <td>0.102758</td>\n",
              "      <td>0.336890</td>\n",
              "      <td>0.380964</td>\n",
              "      <td>0.200493</td>\n",
              "      <td>-0.316828</td>\n",
              "      <td>0.327673</td>\n",
              "      <td>0.216572</td>\n",
              "      <td>0.239880</td>\n",
              "      <td>0.202272</td>\n",
              "      <td>-0.289543</td>\n",
              "      <td>-0.018233</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>CO(GT)</th>\n",
              "      <td>0.041514</td>\n",
              "      <td>0.323944</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.773394</td>\n",
              "      <td>0.289975</td>\n",
              "      <td>0.812361</td>\n",
              "      <td>0.795578</td>\n",
              "      <td>0.762273</td>\n",
              "      <td>-0.613877</td>\n",
              "      <td>0.646349</td>\n",
              "      <td>0.558232</td>\n",
              "      <td>0.759027</td>\n",
              "      <td>0.020257</td>\n",
              "      <td>0.043198</td>\n",
              "      <td>0.043274</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PT08.S1(CO)</th>\n",
              "      <td>-0.003232</td>\n",
              "      <td>0.321097</td>\n",
              "      <td>0.773394</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.278282</td>\n",
              "      <td>0.883795</td>\n",
              "      <td>0.892964</td>\n",
              "      <td>0.615941</td>\n",
              "      <td>-0.771938</td>\n",
              "      <td>0.562843</td>\n",
              "      <td>0.682881</td>\n",
              "      <td>0.899324</td>\n",
              "      <td>0.048627</td>\n",
              "      <td>0.114606</td>\n",
              "      <td>0.135324</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>NMHC(GT)</th>\n",
              "      <td>0.008010</td>\n",
              "      <td>0.102758</td>\n",
              "      <td>0.289975</td>\n",
              "      <td>0.278282</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.281928</td>\n",
              "      <td>0.279761</td>\n",
              "      <td>0.098180</td>\n",
              "      <td>-0.261997</td>\n",
              "      <td>0.156510</td>\n",
              "      <td>0.232979</td>\n",
              "      <td>0.240592</td>\n",
              "      <td>0.066782</td>\n",
              "      <td>-0.052784</td>\n",
              "      <td>0.037173</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>C6H6(GT)</th>\n",
              "      <td>-0.064007</td>\n",
              "      <td>0.336890</td>\n",
              "      <td>0.812361</td>\n",
              "      <td>0.883795</td>\n",
              "      <td>0.281928</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.981950</td>\n",
              "      <td>0.616801</td>\n",
              "      <td>-0.735744</td>\n",
              "      <td>0.535919</td>\n",
              "      <td>0.765731</td>\n",
              "      <td>0.865689</td>\n",
              "      <td>0.198956</td>\n",
              "      <td>-0.061681</td>\n",
              "      <td>0.167972</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PT08.S2(NMHC)</th>\n",
              "      <td>-0.083633</td>\n",
              "      <td>0.380964</td>\n",
              "      <td>0.795578</td>\n",
              "      <td>0.892964</td>\n",
              "      <td>0.279761</td>\n",
              "      <td>0.981950</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.601773</td>\n",
              "      <td>-0.796703</td>\n",
              "      <td>0.561180</td>\n",
              "      <td>0.777254</td>\n",
              "      <td>0.880578</td>\n",
              "      <td>0.241373</td>\n",
              "      <td>-0.090380</td>\n",
              "      <td>0.186933</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>NOx(GT)</th>\n",
              "      <td>0.401280</td>\n",
              "      <td>0.200493</td>\n",
              "      <td>0.762273</td>\n",
              "      <td>0.615941</td>\n",
              "      <td>0.098180</td>\n",
              "      <td>0.616801</td>\n",
              "      <td>0.601773</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>-0.563270</td>\n",
              "      <td>0.763074</td>\n",
              "      <td>0.205485</td>\n",
              "      <td>0.688205</td>\n",
              "      <td>-0.235636</td>\n",
              "      <td>0.192587</td>\n",
              "      <td>-0.126868</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PT08.S3(NOx)</th>\n",
              "      <td>-0.251775</td>\n",
              "      <td>-0.316828</td>\n",
              "      <td>-0.613877</td>\n",
              "      <td>-0.771938</td>\n",
              "      <td>-0.261997</td>\n",
              "      <td>-0.735744</td>\n",
              "      <td>-0.796703</td>\n",
              "      <td>-0.563270</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>-0.569479</td>\n",
              "      <td>-0.538468</td>\n",
              "      <td>-0.796569</td>\n",
              "      <td>-0.145112</td>\n",
              "      <td>-0.056740</td>\n",
              "      <td>-0.232017</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>NO2(GT)</th>\n",
              "      <td>0.349315</td>\n",
              "      <td>0.327673</td>\n",
              "      <td>0.646349</td>\n",
              "      <td>0.562843</td>\n",
              "      <td>0.156510</td>\n",
              "      <td>0.535919</td>\n",
              "      <td>0.561180</td>\n",
              "      <td>0.763074</td>\n",
              "      <td>-0.569479</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.140655</td>\n",
              "      <td>0.629443</td>\n",
              "      <td>-0.165466</td>\n",
              "      <td>-0.080569</td>\n",
              "      <td>-0.291392</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PT08.S4(NO2)</th>\n",
              "      <td>-0.517637</td>\n",
              "      <td>0.216572</td>\n",
              "      <td>0.558232</td>\n",
              "      <td>0.682881</td>\n",
              "      <td>0.232979</td>\n",
              "      <td>0.765731</td>\n",
              "      <td>0.777254</td>\n",
              "      <td>0.205485</td>\n",
              "      <td>-0.538468</td>\n",
              "      <td>0.140655</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.591144</td>\n",
              "      <td>0.561270</td>\n",
              "      <td>-0.032188</td>\n",
              "      <td>0.629641</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>PT08.S5(O3)</th>\n",
              "      <td>0.103508</td>\n",
              "      <td>0.239880</td>\n",
              "      <td>0.759027</td>\n",
              "      <td>0.899324</td>\n",
              "      <td>0.240592</td>\n",
              "      <td>0.865689</td>\n",
              "      <td>0.880578</td>\n",
              "      <td>0.688205</td>\n",
              "      <td>-0.796569</td>\n",
              "      <td>0.629443</td>\n",
              "      <td>0.591144</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>-0.027172</td>\n",
              "      <td>0.124956</td>\n",
              "      <td>0.070751</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>T</th>\n",
              "      <td>-0.450032</td>\n",
              "      <td>0.202272</td>\n",
              "      <td>0.020257</td>\n",
              "      <td>0.048627</td>\n",
              "      <td>0.066782</td>\n",
              "      <td>0.198956</td>\n",
              "      <td>0.241373</td>\n",
              "      <td>-0.235636</td>\n",
              "      <td>-0.145112</td>\n",
              "      <td>-0.165466</td>\n",
              "      <td>0.561270</td>\n",
              "      <td>-0.027172</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>-0.578621</td>\n",
              "      <td>0.656397</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>RH</th>\n",
              "      <td>0.212245</td>\n",
              "      <td>-0.289543</td>\n",
              "      <td>0.043198</td>\n",
              "      <td>0.114606</td>\n",
              "      <td>-0.052784</td>\n",
              "      <td>-0.061681</td>\n",
              "      <td>-0.090380</td>\n",
              "      <td>0.192587</td>\n",
              "      <td>-0.056740</td>\n",
              "      <td>-0.080569</td>\n",
              "      <td>-0.032188</td>\n",
              "      <td>0.124956</td>\n",
              "      <td>-0.578621</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.167971</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>AH</th>\n",
              "      <td>-0.310146</td>\n",
              "      <td>-0.018233</td>\n",
              "      <td>0.043274</td>\n",
              "      <td>0.135324</td>\n",
              "      <td>0.037173</td>\n",
              "      <td>0.167972</td>\n",
              "      <td>0.186933</td>\n",
              "      <td>-0.126868</td>\n",
              "      <td>-0.232017</td>\n",
              "      <td>-0.291392</td>\n",
              "      <td>0.629641</td>\n",
              "      <td>0.070751</td>\n",
              "      <td>0.656397</td>\n",
              "      <td>0.167971</td>\n",
              "      <td>1.000000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                   Date      Time    CO(GT)  PT08.S1(CO)  NMHC(GT)  C6H6(GT)  \\\n",
              "Date           1.000000 -0.003249  0.041514    -0.003232  0.008010 -0.064007   \n",
              "Time          -0.003249  1.000000  0.323944     0.321097  0.102758  0.336890   \n",
              "CO(GT)         0.041514  0.323944  1.000000     0.773394  0.289975  0.812361   \n",
              "PT08.S1(CO)   -0.003232  0.321097  0.773394     1.000000  0.278282  0.883795   \n",
              "NMHC(GT)       0.008010  0.102758  0.289975     0.278282  1.000000  0.281928   \n",
              "C6H6(GT)      -0.064007  0.336890  0.812361     0.883795  0.281928  1.000000   \n",
              "PT08.S2(NMHC) -0.083633  0.380964  0.795578     0.892964  0.279761  0.981950   \n",
              "NOx(GT)        0.401280  0.200493  0.762273     0.615941  0.098180  0.616801   \n",
              "PT08.S3(NOx)  -0.251775 -0.316828 -0.613877    -0.771938 -0.261997 -0.735744   \n",
              "NO2(GT)        0.349315  0.327673  0.646349     0.562843  0.156510  0.535919   \n",
              "PT08.S4(NO2)  -0.517637  0.216572  0.558232     0.682881  0.232979  0.765731   \n",
              "PT08.S5(O3)    0.103508  0.239880  0.759027     0.899324  0.240592  0.865689   \n",
              "T             -0.450032  0.202272  0.020257     0.048627  0.066782  0.198956   \n",
              "RH             0.212245 -0.289543  0.043198     0.114606 -0.052784 -0.061681   \n",
              "AH            -0.310146 -0.018233  0.043274     0.135324  0.037173  0.167972   \n",
              "\n",
              "               PT08.S2(NMHC)   NOx(GT)  PT08.S3(NOx)   NO2(GT)  PT08.S4(NO2)  \\\n",
              "Date               -0.083633  0.401280     -0.251775  0.349315     -0.517637   \n",
              "Time                0.380964  0.200493     -0.316828  0.327673      0.216572   \n",
              "CO(GT)              0.795578  0.762273     -0.613877  0.646349      0.558232   \n",
              "PT08.S1(CO)         0.892964  0.615941     -0.771938  0.562843      0.682881   \n",
              "NMHC(GT)            0.279761  0.098180     -0.261997  0.156510      0.232979   \n",
              "C6H6(GT)            0.981950  0.616801     -0.735744  0.535919      0.765731   \n",
              "PT08.S2(NMHC)       1.000000  0.601773     -0.796703  0.561180      0.777254   \n",
              "NOx(GT)             0.601773  1.000000     -0.563270  0.763074      0.205485   \n",
              "PT08.S3(NOx)       -0.796703 -0.563270      1.000000 -0.569479     -0.538468   \n",
              "NO2(GT)             0.561180  0.763074     -0.569479  1.000000      0.140655   \n",
              "PT08.S4(NO2)        0.777254  0.205485     -0.538468  0.140655      1.000000   \n",
              "PT08.S5(O3)         0.880578  0.688205     -0.796569  0.629443      0.591144   \n",
              "T                   0.241373 -0.235636     -0.145112 -0.165466      0.561270   \n",
              "RH                 -0.090380  0.192587     -0.056740 -0.080569     -0.032188   \n",
              "AH                  0.186933 -0.126868     -0.232017 -0.291392      0.629641   \n",
              "\n",
              "               PT08.S5(O3)         T        RH        AH  \n",
              "Date              0.103508 -0.450032  0.212245 -0.310146  \n",
              "Time              0.239880  0.202272 -0.289543 -0.018233  \n",
              "CO(GT)            0.759027  0.020257  0.043198  0.043274  \n",
              "PT08.S1(CO)       0.899324  0.048627  0.114606  0.135324  \n",
              "NMHC(GT)          0.240592  0.066782 -0.052784  0.037173  \n",
              "C6H6(GT)          0.865689  0.198956 -0.061681  0.167972  \n",
              "PT08.S2(NMHC)     0.880578  0.241373 -0.090380  0.186933  \n",
              "NOx(GT)           0.688205 -0.235636  0.192587 -0.126868  \n",
              "PT08.S3(NOx)     -0.796569 -0.145112 -0.056740 -0.232017  \n",
              "NO2(GT)           0.629443 -0.165466 -0.080569 -0.291392  \n",
              "PT08.S4(NO2)      0.591144  0.561270 -0.032188  0.629641  \n",
              "PT08.S5(O3)       1.000000 -0.027172  0.124956  0.070751  \n",
              "T                -0.027172  1.000000 -0.578621  0.656397  \n",
              "RH                0.124956 -0.578621  1.000000  0.167971  \n",
              "AH                0.070751  0.656397  0.167971  1.000000  "
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 15
        }
      ]
    },
    {
      "metadata": {
        "scrolled": false,
        "id": "xDjGHlq-UGzv",
        "colab_type": "code",
        "colab": {},
        "outputId": "0af48ea2-d9db-470b-8d35-5457209d05ba"
      },
      "cell_type": "code",
      "source": [
        "abs(air_quality2['T']).sort_values(ascending=False)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "T                1.000000\n",
              "AH               0.656397\n",
              "RH               0.578621\n",
              "PT08.S4(NO2)     0.561270\n",
              "Date             0.450032\n",
              "PT08.S2(NMHC)    0.241373\n",
              "NOx(GT)          0.235636\n",
              "Time             0.202272\n",
              "C6H6(GT)         0.198956\n",
              "NO2(GT)          0.165466\n",
              "PT08.S3(NOx)     0.145112\n",
              "NMHC(GT)         0.066782\n",
              "PT08.S1(CO)      0.048627\n",
              "PT08.S5(O3)      0.027172\n",
              "CO(GT)           0.020257\n",
              "Name: T, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 16
        }
      ]
    },
    {
      "metadata": {
        "id": "x2oCld1KUGz0",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "from sklearn.preprocessing import MinMaxScaler"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "S8HMqX_0UGz3",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "# num = air_quality.keys()\n",
        "# scaler = MinMaxScaler()\n",
        "# scaler.fit(air_quality[num])\n",
        "# air_quality[num] = scaler.transform(air_quality[num])"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "IFH-WYRRUGz7",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "features=air_quality\n",
        "target=air_quality['T']"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "scrolled": true,
        "id": "X9v1VOZAUGz-",
        "colab_type": "code",
        "colab": {},
        "outputId": "5152a71c-ce6f-4544-82e6-14ecec9ab66c"
      },
      "cell_type": "code",
      "source": [
        "features=features.drop('Date',axis=1)\n",
        "features=features.drop('Time',axis=1)\n",
        "features=features.drop('T',axis=1)\n",
        "features=features.drop('CO(GT)',axis=1)\n",
        "features=features.drop('PT08.S5(O3)',axis=1)\n",
        "features=features.drop('NMHC(GT)',axis=1)\n",
        "features=features.drop('PT08.S1(CO)',axis=1)\n",
        "features.tail()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>C6H6(GT)</th>\n",
              "      <th>PT08.S2(NMHC)</th>\n",
              "      <th>NOx(GT)</th>\n",
              "      <th>PT08.S3(NOx)</th>\n",
              "      <th>NO2(GT)</th>\n",
              "      <th>PT08.S4(NO2)</th>\n",
              "      <th>RH</th>\n",
              "      <th>AH</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>9352</th>\n",
              "      <td>13.5</td>\n",
              "      <td>1101.0</td>\n",
              "      <td>472.0</td>\n",
              "      <td>539.0</td>\n",
              "      <td>190.0</td>\n",
              "      <td>1374.0</td>\n",
              "      <td>29.3</td>\n",
              "      <td>0.7568</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9353</th>\n",
              "      <td>11.4</td>\n",
              "      <td>1027.0</td>\n",
              "      <td>353.0</td>\n",
              "      <td>604.0</td>\n",
              "      <td>179.0</td>\n",
              "      <td>1264.0</td>\n",
              "      <td>23.7</td>\n",
              "      <td>0.7119</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9354</th>\n",
              "      <td>12.4</td>\n",
              "      <td>1063.0</td>\n",
              "      <td>293.0</td>\n",
              "      <td>603.0</td>\n",
              "      <td>175.0</td>\n",
              "      <td>1241.0</td>\n",
              "      <td>18.3</td>\n",
              "      <td>0.6406</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9355</th>\n",
              "      <td>9.5</td>\n",
              "      <td>961.0</td>\n",
              "      <td>235.0</td>\n",
              "      <td>702.0</td>\n",
              "      <td>156.0</td>\n",
              "      <td>1041.0</td>\n",
              "      <td>13.5</td>\n",
              "      <td>0.5139</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9356</th>\n",
              "      <td>11.9</td>\n",
              "      <td>1047.0</td>\n",
              "      <td>265.0</td>\n",
              "      <td>654.0</td>\n",
              "      <td>168.0</td>\n",
              "      <td>1129.0</td>\n",
              "      <td>13.1</td>\n",
              "      <td>0.5028</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      C6H6(GT)  PT08.S2(NMHC)  NOx(GT)  PT08.S3(NOx)  NO2(GT)  PT08.S4(NO2)  \\\n",
              "9352      13.5         1101.0    472.0         539.0    190.0        1374.0   \n",
              "9353      11.4         1027.0    353.0         604.0    179.0        1264.0   \n",
              "9354      12.4         1063.0    293.0         603.0    175.0        1241.0   \n",
              "9355       9.5          961.0    235.0         702.0    156.0        1041.0   \n",
              "9356      11.9         1047.0    265.0         654.0    168.0        1129.0   \n",
              "\n",
              "        RH      AH  \n",
              "9352  29.3  0.7568  \n",
              "9353  23.7  0.7119  \n",
              "9354  18.3  0.6406  \n",
              "9355  13.5  0.5139  \n",
              "9356  13.1  0.5028  "
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 20
        }
      ]
    },
    {
      "metadata": {
        "id": "FJwYma6KUG0C",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "from sklearn.model_selection import train_test_split"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "scrolled": true,
        "id": "aaQgsY0DUG0F",
        "colab_type": "code",
        "colab": {},
        "outputId": "b533b3f2-b643-49a7-e83d-45e38bd378e5"
      },
      "cell_type": "code",
      "source": [
        "X_train, X_test, y_train, y_test = train_test_split(features, target)\n",
        "y_test.tail()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "5249    24.400000\n",
              "2389    20.800000\n",
              "8618     8.400000\n",
              "4050    18.317829\n",
              "8626     4.400000\n",
              "Name: T, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 22
        }
      ]
    },
    {
      "metadata": {
        "id": "M4z2U3VPUG0J",
        "colab_type": "text"
      },
      "cell_type": "markdown",
      "source": [
        "# Linear Regression"
      ]
    },
    {
      "metadata": {
        "id": "baHafcc7UG0K",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "from sklearn.linear_model import LinearRegression"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "LJLl-fc8UG0N",
        "colab_type": "code",
        "colab": {},
        "outputId": "8a7510ab-276f-42d3-9b01-20d96e974b88"
      },
      "cell_type": "code",
      "source": [
        "regressor = LinearRegression(normalize=True)\n",
        "regressor.fit(X_train, y_train)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "LinearRegression(copy_X=True, fit_intercept=True, n_jobs=None, normalize=True)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 24
        }
      ]
    },
    {
      "metadata": {
        "id": "eKEzKsMpUG0R",
        "colab_type": "code",
        "colab": {},
        "outputId": "cfaf5f5f-0c53-41e4-c5c2-6a31b7f36b68"
      },
      "cell_type": "code",
      "source": [
        "print(\"Predicted values:\", regressor.predict(X_test))\n",
        "y_pred = regressor.predict(X_test)\n",
        "y_pred.shape\n"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Predicted values: [19.00833068 18.74443623 13.19138122 ...  9.28185968 18.25538022\n",
            "  3.98838093]\n"
          ],
          "name": "stdout"
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(2340,)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 25
        }
      ]
    },
    {
      "metadata": {
        "id": "Bhsqvk3qUG0U",
        "colab_type": "code",
        "colab": {},
        "outputId": "8d8329df-d4d9-4c9e-a10e-5fa1971aca86"
      },
      "cell_type": "code",
      "source": [
        "print(\"R^2 score for liner regression: \", regressor.score(X_test, y_test))"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "R^2 score for liner regression:  0.9288505701939468\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "scrolled": true,
        "id": "zGm0z-d9UG0Y",
        "colab_type": "code",
        "colab": {},
        "outputId": "129a2a80-a56b-414a-e879-ccb6c76a8d92"
      },
      "cell_type": "code",
      "source": [
        "plt.scatter(y_test,y_pred,color='black')\n",
        "plt.show()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXQAAAD8CAYAAABn919SAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvOIA7rQAAIABJREFUeJzt3V1sY+d5J/D/Qw5p+1AJHB85WcPOHKWwL2Is2gQeZFN4Fwg8KdadGk0uGiNZSSPYWSjidBcqtt2us7wIWoBAc9NEF5VtoZmpPOegcdoUm6AYICjGKWr4wq2cpB+BUcQNpLEbIx5pJvDMyLY04rMX5OFQ1Pkiecjz9f8BByNSh4fvHHsevnzf531eUVUQEVH2lZJuABERxYMBnYgoJxjQiYhyggGdiCgnGNCJiHKCAZ2IKCcY0ImIcoIBnYgoJxjQiYhy4tgk32x6elpnZmYm+ZZERJn3yiuvbKvq3WHnTTSgz8zMYGNjY5JvSUSUeSKyFeU8DrkQEeUEAzoRUU4woBMR5QQDOhFRTjCgExHlBAM6EWWO4ziYmZlBqVTCzMwMHMdJukmpEDmgi0hZRH4oIn/defwREXlZRH4iIs+LSHV8zSQianMcB4uLi9ja2oKqYmtrC4uLiwzqGKyHvgzg1Z7HXwXwNVV9AMBVAF+Ms2FERF4ajQZ2d3cPPbe7u4tGo5FQi9IjUkAXkfsA/AaAP+08FgCPAPjLzinrAD47jgYSEfW6dOnSQM8XSdQe+tcB/D6AVuexCeAXqnqz8/gNAPfG3DYioiOOHz8+0PNFEhrQReQxAG+p6iu9T3ucqj6vXxSRDRHZuHz58pDNJCJqazabMAzj0HOGYaDZbCbUovSI0kN/GMBvisgmgG+iPdTydQB3iohbC+Y+AD/zerGqrqnqCVU9cffdobVliIiO6M1qaTQaWFhYgGVZEBFYloW1tTXMzs4m3czEiapnx9r7ZJFPAfg9VX1MRP4CwLdV9Zsi8gyAf1LV1aDXnzhxQlmci4gG4Wa19E6EGoZRqCAuIq+o6omw80bJQ/8/AP6XiLyG9pj6N0a4FhHRIW6vfG5ubixZLXnMZR8ooKvq36rqY52ff6qqn1DV+1X1c6r63niaSERF05tr7ufSpUtDB+W85rIPNOQyKg65EFEUMzMzgcEcAEzTxDvvvDPUUIzf9S3Lwubm5lBtHqdJDLkQEcWiv6cdFszdLJdhh2LymsvOgE5EifIa/mivXfS3u7uLnZ0dz99FCcp5zWVnQCeiRHkt5R9lKLhUKoWOqec1l50BnYgSFfcwx8HBQehE5+zsLNbW1nKXy85JUSJKVJQx81GkdaJzEJwUJaJM8Br+iFPWJzoHwYBORBPVn9ECoDv8ASB0QnRQqpqbhUNhGNCJaGL8FvQAwObmJizLGmlC1O/DIC8Lh8JwDJ2IJiZsQU+U3rmIBAb9Wq2GGzdueP4uq+PpHEMnotiELbGPugQ/aEFP1N6zqgYG/nfffdf397kfT1fViR0PPfSQElG22Lat1WpV0d7zQAFotVpV27a7vzcM49Dv3cM0ze55qqqWZXmeZ1mW7++GOYKuZVnWoTZlAYANjRBjGdCJKJBpmr7BWtU/SEcN/oZhqG3bKiKRA3bQueVyOfBDxm2TaZoqIpkI8FEDOodciCiQ3xJ79/mwYYy9vb1ufRV3QY9pmt3f33HHHQAGW3avAWPoi4uLhxYO+bVpZ2cnV5UWAbCHTpRntm2rZVlD90Rt2w7sKav69+DR16N22wKfHnatVjsytDPocfLkySN/36g9f8uyxvBfIB7gkAtRsQUNbwS9xg2IU1NTgQHQHXKJEtBN0wwcAnGPSqXSHQopl8sDBXOv9zAMI1L73A+ZtIoa0DnkQpRTXkWvgsrL9ueIX79+3ffalUoFKysrAIArV64EtqNarXbfO8z+/j6mpqbQarWwuLh4JFslKLvl2rVrnn9fAJFWoo5SaTE1ux9FifpxHeyhE02O31CDX090kCyTKJkr6AyjhA3beLXP69vFIJOmXtcLOifsm0uQYb4JDQocciEqNr9AWy6XPcfUBxlrtm1ba7VapGAaNnTjdf04UxhN0wy8npsV4ydsHiIoFTMuDOhEBReWutffk4wSREVE6/W6lkql2AKuV3uG7Y0P+36D3MP+1wz6TWgYDOhEdKh36TfJ6PYko3wADNrbjnJ4fWMYtIc+zAdAuVzWer0eeP+i9L7ZQyeiiYvSkxx0vHtcPeSovXT3g6Berw/1/l4LjHo/BIPet7etfr34UdNGXQzoRHRIlJ6kbdsDpwsOe/SXBegX9vr+HnAcbapUKpFy4fvf2ytwxzlZyoBORIeEBZgoQy5hx2233RapV+3XK3c/dMI+VLwC4yQ+hNwjbKhGNd6hGAZ0ooIY5Gt90LmjZpacPHky8qpRr3ZF/TBxUyH7RV1AFMcRpacd52QpAzpRAfgFwrDhDC+jZpZUKpVI53n1UAf5MPHr4dq2HbkNcRxhPW320IloIEGBcNDx2jhzvwdt06CVFv3U6/XucI2IDPwhFXUMPawdqvEuOGJAJyqAsIAVZfKu93fjzv+empryzCiJo2c86hyA+60mrIjYID1tZrkQkS/btg+NFYct8ImaXucaZzDvP6rV6khDJHHPAXgF6P777Xffxo0BnSjj+nt39Xp9qPKybuDzC3hhS+PTfPQG1jiuF/W/xaQ3xGBAJ8qwOFIIe49J5ZYncbgBNiirJMp1/NIp0yBqQJf2uZNx4sQJ3djYmNj7EWWJ4zhoNBq4dOkSSqUSDg4Okm5SZpim6buzEgCUSiW0Wq3Q61iWhc3NzRhbFg8ReUVVT4Sdd2wSjSGiYI7j4IknnsD+/j4AMJgPKCiYA0Cr1UK1WsX73vc+XLlyBX4d2bDt9NKOG1wQpcDy8nI3mGdNuVxOugmR7O3tdTfPsHz2Gh1lk4s0YEAnSkjvLjdhPcw0y9K3CbcH3mw2j+xiZBgGms1mEs2KDQM6UQL6t3tLm6Ct3rLM7YHPzs5ibW0NlmVBRGBZFtbW1jA7O5twC0fDSVGiBMzMzGBrayvpZhximmZ3n9Dl5eVMf2vwY9t2JoN21ElR9tCJEpC2yTc3mL/00kuYn59PfTCvVCoTeZ/UbP4cVVheI4DbAfw9gH8E8GMAf9B5/iMAXgbwEwDPA6iGXYt56ERtaVzIM8yipSSOsIVSQUfY/qG9vNYCVCqVIxtiTAIi5qFH6aG/B+ARVf0VAB8D8KiIfBLAVwF8TVUfAHAVwBcjXIuo8BzHwfXr15NuxhF7e3sTeR83K2bQcXrDMGDbNjY3N/HSSy/h9ddfP3JOtVpFrVbzvcbBwQEWFxcj9bQbjQZ2d3cPPbe/v4+dnR2oKra2tiJfa2KiRH33AGAA+AGA/wRgG8CxzvO/CuB7Ya9nD52KbtIlXsd9lEqlgXr2lUrl0IYaYb3sUql0pDfst91cb530sNroUQprRV1hGufeoX4Q59J/AGUAPwJwHe2e+TSA13p+/2EA/+Lz2kUAGwA2jh8/Pva/OFGaTXIThkkc1WpV6/V6pOqE7vn9wxRBQd1rZyC/Mgblcrl7TljphCibTEQd0hlmw4pBxRrQ9VZwvhPA9wH8F4+A/s9hr2cPnYou6QA8bNAOCm5uD9W2ba3VaqHXK5fLh3rdQR8CXmPeQdfuFbQ/atTSt1Hq6WSuh37oBcBXAPxvcMiFaCC2bScenAc9KpXKoR6431Gv14cqJmYYRui3FsMwum0ICv6lUsnzno+yyURvlUXTNI8ML02qjG5sAR3A3QDu7Px8B4AXATwG4C8AfL7z/DMAzoRdiwGdisivpnYWjqiBepSNMaLuQxp2Tq1W873/cZW+TaqMbtSAHrqwSER+GcA62uPoJQDfUtU/FJFfAvBNAHcB+CGAOVV9L+haXFhEReM4Dp588smJZZDEqVwu48477xx7TrqIICwORb1OlIqKWRRbtUVV/ScAH/d4/qcAPjFc84jyz3EczM/PxxKsknBwcDCRBUbucvxRV85mvbBWHLhSlGgMHMfB6dOnMxvM42aaJk6ePHkk99wtiOVVLMsVJV89D4W14sCATjQGy8vLiX/9L5Um989bRDwDtuvtt9/Giy++eOgDTkSwsLCA2dnZQ8WygFuLjyzLwtLS0pFgX6lUYJpmrgprxSLKQHtcBydFKc96J8yQggnNSR/uvqdhG1f3HqZpDnxvk9jTM2ngFnREk+OWw+1fKl401Wp14AngrFZAnCRWWySaIK+6H1lhmmZs1xomm2dhYSE71QxTjgGdaEi9pVXTVtt8EEmXyj04OIBqSotdZQwDOtEQ0r7j0LgMu5ORaZqRvgns7u6i0WgM9R7EgE40lCwPsQyrXC6HfnhVq1XfzScef/xx39TEXmnb/CNLGNCJhpDlIZZhiEikzaD39vbw/ve//0hN8p2dHayvr2NhYaG7j6ebmtiPC4SGx4BONADHcTA9PZ10MyZOVbs54mF2dnY8v73s7u7iwoUL2NzcRKvVwvr6+pEeOxcIjYYBnSgid9w86UnEuJimGXnxkWmagas5+/kNzfQOp/QuJhp2gVDm9vwctyjJ6nEdXFhEWZbGfUCHPURE6/V65EqQ7sYUw+7l6R5x1g4ftTRulmBc9dBHORjQKcuSDsLjCOr928GJiO9Kz95gHGU1bP85cQdbvw+WSWw4MWlRAzqHXIhCZGXcXEQGWiSkqt0UwdnZ2e7YtvoMl2xtbXWHNMImLg3DwNLS0kjDKWH8smGKnCUTWj6XqMiyVM9cVXHt2rWBXuMV/I4fP+6bxbO4uAgAaDabR0oduHXNLctCs9kc+3J+v3YWOksmSjc+roNDLpQ1Wd1pKOrhNTwRtpdm7x6iSRbM4hg6x9CJIsviHqB+h9dmyUHBL+jvPold7qNK+kNlUhjQiSLyCwp5ymrpzVCJGvyKNOmYdgzoRBEEfW1POgh7HfV6XWu12kCvGTYA1+v1sWeqUDQM6EQR+PVCBw2akzh6N4OIOrY/bAD2G0c/efJknLefIooa0Jm2SIXml+J248aNCbck3MrKSvfnK1eu+J5XLpe7KYx33HEH5ufnB15F6Vd87IUXXuBqzBTjjkVUaNPT05lZyt/7b3VmZsYzZU9EcP78eQA4klZoGEbkXPBSqQS/2GBZFjY3NwdsPY2COxYR+eit/3H16tWkmxNJf2Esr7oqIoKlpSXMzs569rAHqTUelMtd5IU7aceAToXSvzFFq9VKukmhRASnTp069JxXYavz589jdXUVwOirKJvNpu9mFoVeuJN2UQba4zo4KUpJsm3bMx87C0f/5GZYCmIcKYfMckkPMMuF6Jaw1Y9ZOHpXaPqlWvZWQ4wjGBdl4U7aRQ3onBSlQpiamkpl5gpwa+x7fX09cFs7EUGr1fKdEDVNE++8806i9VVoPKJOirI4F+XemTNnUh/MV1dX8fDDD6PRaPgWxnLHrv3Gwb2yddxgzqyUYuCkKOXe2tpaou9fr9e7+2eKCKampjwnMt0StrZtB27NNuikJLNSioMBnXIvyubG41IqlfDwww/j5s2bUFWcP38+tGZ52NZsg2wFBzArpVCiDLTHdXBSlCahdyJvamoq8clMd3LSNE2tVCqxZI1E3QqOWSn5AE6KUhG5eeZBk4tpM8oYt98EqXtdToTmA1eKUiH51SBJs1HGuL2GXwzDgG3b2NzcZDAvGAZ0ygV330+/3mqaDTvG7ThO9wPMnXQdx96dlB1MW6TMcxwHp0+fTmQZf7lcHmnStTd7ZRD9Q0sHBwfdazGYFxd76JRpjuNgbm4ukWBuGAYWFxePDHlUKpVuJkt/PZRqtQrTND2zVwYxavEtyicGdMoct1qiiGBubi6xdqytrWF1dfVIiuG5c+ewvb3dTVPs/d3Zs2exvb2NVqs10hj3qMW3KJ9Cs1xE5MMAngPwHwC0AKyp6oqI3AXgeQAzADYBPK6qgbVImeVCo/r0pz+NixcvJt0MAPCtFz4JftktXBWaT3FmudwE8Luq+lEAnwTw2yLyIICnAFxU1QcAXOw8JhqbM2fOpCaYJ80vu2WY8XjKj9CArqpvquoPOj9fA/AqgHsBfAbAeue0dQCfHVcjqZh6h1ZEBE8//XTSTeoKW+05bmGrSamYBspyEZEZAB8H8DKAD6nqm0A76IvIB2NvHRVW2hcIPf7440k3AbOzswzgdEjkSVERmQLwbQC/o6pvD/C6RRHZEJGNy5cvD9NGKoDebeFmZmawvLyc2mAOABcuXEi6CURHROqhi0gF7WDuqOpfdZ7+uYjc0+md3wPgLa/XquoagDWgPSkaQ5spZ/p741lYHMRsEkqj0B66tBNpvwHgVVX9455ffRfAQufnBQDfib95VARpXK5fLpchIt0VmP1YwZDSKMqQy8MA5gE8IiI/6hynAPwRgF8TkZ8A+LXOYyJfvZOcx44dg4gEFpdKimEYWF9fR6vVwvr6OrNJKDuilGSM62D53OKybVur1WripWz9DrfErde+mdxXk5IGls+lNJmenvbcIi0tuCCH0ozlcylV0hzMAU5yUj4woNPY9KYipkGtVvNdEMRJTsqDdPxLo9xxUxG3trYSrXliWVZ3fPH69etYWVnhJCflFgM6jUUaUhG9AjWXzFOecVKUxqJUKiXaMy+Xy1hfX2egplzgpCglxnGcxMfNW60WgzkVDgM6xcZxHExNTWFubm6kbdniwElOKiIGdIrFmTNnMDc3hxs3biTdFE5yUmExoNNIHMfB9PR0amqVc5KTiowBnXz1l7R1HOfQ791eeRoWDVUqFdi2PdI+nURZx4BeYEEB23EcPPHEE9088q2tLZw+fRrT09MolUqp6pWbpolz584xkFPhDbRjEeWHVw3yxcVFAO1c7eXlZezv7x96TavV6vbGk+6V1+t1rK6uJtoGorRhHnpB+ZWtNU0TU1NTqStp22tqagrXrl1LuhlEExM1D5099ILyK0a1s7OTeO87iGEYeOaZZ5JuBlEqcQy9oLKYp10qlZjBQhSAAT3HgiY9m83mkSJVaffcc88xmBMFYEDPITc3fG5u7lCWyvz8fHfbNwBYWFhIfIl+VPV6ncGcKATH0HOmP3ullzsB7qYgtlqtSTdvKMxoIYomG90ziixq2dosBHPTNGHbNoM5UUTsoedMXrZSY6+caHDsoedMFrNX+jGYEw2HAT1nTp06BRFJuhlDqdVqUFUGc6IhccglJxzHwdLSEq5fv550U4b27LPPJt0EokxjQM8Bx3Hw5JNPYm9vL+mmjIRpiUSj4ZBLDiwvL2c+mFuWlXQTiDKPAT1D3AVDInLoSHPtlSi4wxBRPDjkkhGO42BhYSHxvTrjVi6XWZ+FKCbsoWfE8vJy7oK5YRhYX19nMCeKCQN6yvQPq0xPT8NxnMwPq/QzTZM9c6KYccglRbyyVXZ2djA3N5dgq8Zje3s76SYQ5Q576BMStuEy0K7DkvVslShM00y6CUS5xB76BITt3+nKSx2WMCsrK0k3gSiX2EMfg/7e+PLy8pEKiLu7u5ibmzvUW89DHZYwJ0+e5Lg50Zhwk+iYBdUj92MYBtbW1gAgFys+vZTLZSwuLrJOC9EQom4SzYAes5mZGWxtbQ38ulKphA984AO5y2YB2qtANzc3k24GUWZFDegccomR4zhDBXOgveFEHoM5V4ESTQ4Dep/e8e/p6WlMT08HZqb0vs6d6PRimmbh6pVYlsVcc6IJCs1yEZGzAB4D8Jaq/sfOc3cBeB7ADIBNAI+r6tXxNXMy+se/e3vMfpkpjuOg0WgE9sx7661Uq9VcjpH34zAL0eRF6aH/GYBH+557CsBFVX0AwMXO48wL249zd3cXjUaj+9j9AAgbZnHnKXZ2dgoRzDnMQpSM0ICuqn8H4Erf058BsN75eR3AZ2NuVyKi5IH3nhN1Q+Yi4TALUXKGHUP/kKq+CQCdPz8YX5Mmw2vlZpQ8cFXtnj/sBGheqSo2NzcZzIkSMvZJURFZFJENEdm4fPnyuN8ukBvERQTz8/PY2tqCqmJrawvz8/O4//77YRhG6HW2trawsLAwgRYTEUU3bED/uYjcAwCdP9/yO1FV11T1hKqeuPvuu4d8u9H1j3f359+rKl544QUsLCzAsiyICEzT9K07krdStkSUfcMG9O8CcLuoCwC+E09zhhO18FXYeLeq4sKFC9jc3ESr1cL29jarAkbEgltEyYuStvjnAD4FYFpE3gDwFQB/BOBbIvJFAJcAfG6cjQwSd+GrohTIilO5XGbBLaIUiJLl8gVVvUdVK6p6n6p+Q1V3VPWkqj7Q+bM/C2ZivHre/emFQPTCV17n1Wq14RuYI5VKBfV6/VBv3DRN7jpElBKZXynq16Puf77ZbIZOePrlT4vI8A3MCcuycO7cOayurmJ7exuqClXF9vY2gzlRSmQ+oPv1vPufn52dxdraWnfC07Is1Ov1Q4+98qcdx8H169fH1v4sEBGmIxJlgdvTmsTx0EMPadxs21bDMBRA9zAMQ23b7v7esiwVEbUsq/v8sNcu4mFZVuz/3YgoOgAbGiHGZj6gq/oH7bBgH8ayrMSDadJHtVod6EOQiOIXNaDnuh66X23yqIWjSqXSkXz1IjFNEysrKxxqIUpYoeqh++WhR50w9brO9PR0ISdDy+UybNvmhCdRBmV+k+igPPTjx4979tC9JlKDSucWCVMQibIr8z30oDx0r1RFv9REVk5sD7EwmBNlV+YDetCwileqol9p1yKtEPUaSjIMg6s9iTIu8wE9LA99dna2W5slKJc66krSPDh27FikHHwiypbMBHS/ic9BhlWCFGmHnf39/UNFyLhoiCgnouQ2xnUMm4c+zsVDvTDhHO8kDxEZ6h4R0eQhT3noo+aTj/o+ecRNnImyI1d56IPmkw+rSMMuRfq7EhVFJgJ61AJco5qdnS1EqVymJxLlU+oDul+1w2EmPsPeZ2ZmBjdu3IjtmmnE9ESi/Ep1QHdXb/av2qzVarGm2Z05c6a7aXTe1Go1picSFUSql/77rd6Mc0Wn4zh45plnclmEyzAMPPvsswzgRAWR6h6636Snqh7ZYs5Pf/76mTNnDj1eXl7OZTAvlUrsjRMVTKrTFoPSCEUErVbL83eO46DRaORyCCWKarWKs2fPMpgT5UQu0habzaZvCVu/DBd33H2cwbxcLgPAoc2S08KyLAZzooJKdUCfnZ3F0tLSkaAelOESd9XEWq3WnVB064TfvHkTtm3jnXfeie194qCqXMZPVGCpDugAsLq6ivPnz0fO1Ih7sdH+/j7uuusuXLp0CY1Go1tDJm3ldi3LSroJRJSwVI+hD2Pcy/dFJHWTqJVKBefOnWPPnCincjGGPgyv6otxSlswL5VKDOZEBCCHAb13U4u8MwwDzz33HIM5EQHIYUAHbm1qkaegbhgGN6UgokCpXik6qmaziSeffBJ7e3tDvd40TVy9etU33x24VYbWL70yDpZlodlsMngTUaBcB3Q3AJ4+fTowKPt59913Q193//3349ix+G9juVzG4uIiVldXY782EeVTrgM6cCuoLy4uDpxmGFZ58bbbbsPFixeHbpuftE28ElE25HIMvV/vRKk7/lwqjfZXNwwD+/v7MbWQiGh0hQjowK2JUndT5C996UsjXW9hYWGoYZwwRdhgg4jGI/dDLn7csem1tTUcHBwM/Pqnn3467iYBAG6//faxXJeI8q8wPXQvq6uruHnzJlQVtm2PdUFSVFeuXEm6CUSUUYUO6L210huNBhYWFkYeW/djmiaq1WroeXHvk0pExVHIIRfHcbC8vHxoa7utrS2sr6/DMAzPPUxH4QbysHz4uPdJJaJiKVwP3W+fUqC9tV3cwRxoB3Kv9+vFlZ9ENKrC9dCHLXtrWdZYqji6K02JiEY1Ug9dRB4VkX8VkddE5Km4GjVOYfXSTdM8MjnqDoWMskNR0HWJiOIwdEAXkTKAPwHw6wAeBPAFEXkwroaNS9Cko2EYWFlZObIIyR0KCVs5Oux1iYhioapDHQB+FcD3eh5/GcCXg17z0EMPadJs21bDMBTAocM0TbVtO/B1/a+JcpTL5cDrEhGFAbChEeLyKEMu9wJ4vefxG53nDhGRRRHZEJGNy5cvj/B28fAqA2DbNra3twN7y41GI/C6fkMq6+vr7IUT0UQMvQWdiHwOwH9V1f/eeTwP4BOq+j/9XjOJLejGpVQqBRbNsm0bQDvwX7p0CcePH2fJWyKKRdQt6EbJcnkDwId7Ht8H4GcjXC9VHMc5FJwNw/AdQ5+amuoGbgZwIkrKKAH9HwA8ICIfAfDvAD4P4L/F0qqEubnqbnpjWLrisJOlRERxGjqgq+pNEfkfAL4HoAzgrKr+OLaWJWjQXHUu1yeiNBhpYZGqXgBwIaa2pEZYrnovEWEuORGlQuGW/kfh1+Pu3zdURLC0tMRxcyJKBQZ0HK66ODMzg1OnTnmmIC4tLR1Kdzx//jz3/CSi1ChcLZd+XhOg6+vrWFhYwIULF5iCSESZUfiA7jUBuru7iwsXLrBoFhFlSuGHXPwmQAeZGCUiSoPCB3S/CVCmIhJR1hQ+oDebTZa1JaJcKHxA9yrWxbK2RJRFQxfnGkaWi3MRESUlanGuwvfQiYjyggGdiCgnGNCJiHKCAZ2IKCcY0ImIcmKiWS4ichlA8G4Ro5kGsD3G62cJ78UtvBdtvA+3ZO1eWKp6d9hJEw3o4yYiG1FSe4qA9+IW3os23odb8novOORCRJQTDOhERDmRt4C+lnQDUoT34hbeizbeh1tyeS9yNYZORFRkeeuhExEVVm4Cuog8KiL/KiKvichTSbdnkkTkrIi8JSL/0vPcXSLyNyLyk86fH0iyjZMgIh8Wke+LyKsi8mMRWe48X8R7cbuI/L2I/GPnXvxB5/mPiMjLnXvxvIhUk27rJIhIWUR+KCJ/3Xmcy/uQi4AuImUAfwLg1wE8COALIvJgsq2aqD8D8Gjfc08BuKiqDwC42HmcdzcB/K6qfhTAJwH8duf/gyLei/cAPKKqvwLgYwAeFZFPAvgqgK917sVVAF9MsI2TtAzg1Z7HubwPuQjoAD4B4DVV/amq7gH4JoDPJNymiVHVvwNwpe/pzwBY7/y8DuDbvjXvAAACEUlEQVSzE21UAlT1TVX9Qefna2j/A74XxbwXqqrXOw8rnUMBPALgLzvPF+JeiMh9AH4DwJ92Hgtyeh/yEtDvBfB6z+M3Os8V2YdU9U2gHegAfDDh9kyUiMwA+DiAl1HQe9EZZvgRgLcA/A2AfwPwC1W92TmlKP9Ovg7g9wG0Oo9N5PQ+5CWgi8dzTN8pKBGZAvBtAL+jqm8n3Z6kqOqBqn4MwH1of4v9qNdpk23VZInIYwDeUtVXep/2ODUX9+FY0g2IyRsAPtzz+D4AP0uoLWnxcxG5R1XfFJF70O6l5Z6IVNAO5o6q/lXn6ULeC5eq/kJE/hbteYU7ReRYp3dahH8nDwP4TRE5BeB2AO9Hu8eey/uQlx76PwB4oDNzXQXweQDfTbhNSfsugIXOzwsAvpNgWyaiMzb6DQCvquof9/yqiPfibhG5s/PzHQA+jfacwvcB/FbntNzfC1X9sqrep6ozaMeFF1R1Fjm9D7lZWNT5BP46gDKAs6raTLhJEyMifw7gU2hXkPs5gK8A+H8AvgXgOIBLAD6nqv0Tp7kiIv8ZwIsA/hm3xkv/L9rj6EW7F7+M9mRfGe2O27dU9Q9F5JfQThq4C8APAcyp6nvJtXRyRORTAH5PVR/L633ITUAnIiq6vAy5EBEVHgM6EVFOMKATEeUEAzoRUU4woBMR5QQDOhFRTjCgExHlBAM6EVFO/H9qDDkIxzaENgAAAABJRU5ErkJggg==\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "metadata": {
        "id": "KKnZYSG8UG0b",
        "colab_type": "text"
      },
      "cell_type": "markdown",
      "source": [
        "# Lasso regression"
      ]
    },
    {
      "metadata": {
        "id": "gbVriJ4NUG0c",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "from sklearn.linear_model import Lasso"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "lK7qm1QvUG0e",
        "colab_type": "code",
        "colab": {},
        "outputId": "277ba791-e82b-409a-c9e9-c0ba50b5aa34"
      },
      "cell_type": "code",
      "source": [
        "a=Lasso(alpha=0.5)\n",
        "a.fit(X_train, y_train)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Lasso(alpha=0.5, copy_X=True, fit_intercept=True, max_iter=1000,\n",
              "   normalize=False, positive=False, precompute=False, random_state=None,\n",
              "   selection='cyclic', tol=0.0001, warm_start=False)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 29
        }
      ]
    },
    {
      "metadata": {
        "id": "uttmoY1WUG0j",
        "colab_type": "code",
        "colab": {},
        "outputId": "8e4f2b89-fa57-4109-bb2a-ee995188c140"
      },
      "cell_type": "code",
      "source": [
        "print(\"R^2 on train set : {}\".format(a.score(X_train, y_train)))"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "R^2 on train set : 0.8424337687413078\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "9RC8buZtUG0p",
        "colab_type": "code",
        "colab": {},
        "outputId": "7b3dbae1-8a55-4c8e-ca1c-5157c0f0a64e"
      },
      "cell_type": "code",
      "source": [
        "print(\"R^2 on train set : {}\".format(a.score(X_test, y_test)))"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "R^2 on train set : 0.8501553916282969\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "Q-mZdBdLUG0s",
        "colab_type": "text"
      },
      "cell_type": "markdown",
      "source": [
        "# decision tree regression"
      ]
    },
    {
      "metadata": {
        "id": "0ASlW2OZUG0s",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "from sklearn.tree import DecisionTreeRegressor"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "Gxx8uO6IUG0v",
        "colab_type": "code",
        "colab": {},
        "outputId": "4c778a11-78d9-430f-e601-f376ebc29726"
      },
      "cell_type": "code",
      "source": [
        "dtr = DecisionTreeRegressor()\n",
        "dtr.fit(X_train, y_train)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "DecisionTreeRegressor(criterion='mse', max_depth=None, max_features=None,\n",
              "           max_leaf_nodes=None, min_impurity_decrease=0.0,\n",
              "           min_impurity_split=None, min_samples_leaf=1,\n",
              "           min_samples_split=2, min_weight_fraction_leaf=0.0,\n",
              "           presort=False, random_state=None, splitter='best')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 33
        }
      ]
    },
    {
      "metadata": {
        "id": "jE6g6qFAUG0z",
        "colab_type": "code",
        "colab": {},
        "outputId": "3047794c-6bae-4655-e041-38d0c62559c8"
      },
      "cell_type": "code",
      "source": [
        "print(\"Coefficient of determination R^2 <-- on train set: {}\".format(dtr.score(X_train, y_train)))"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Coefficient of determination R^2 <-- on train set: 1.0\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "Uy_U1CXaUG04",
        "colab_type": "code",
        "colab": {},
        "outputId": "558bac38-91c3-42ad-cba0-e69378e10dc8"
      },
      "cell_type": "code",
      "source": [
        "print(\"Coefficient of determination R^2 <-- on train set: {}\".format(dtr.score(X_test, y_test)))"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Coefficient of determination R^2 <-- on train set: 0.9964315525768502\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "cZ_zdQ-mUG08",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        ""
      ],
      "execution_count": 0,
      "outputs": []
    }
  ]
}