Task2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "3811dafe-d6ee-436b-ad6a-9e888cdd25dc",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "0bbbb43e-631c-48df-8ae0-19a93b57a143",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Observation</th>\n",
       "      <th>Y-Kappa</th>\n",
       "      <th>ChipRate</th>\n",
       "      <th>BF-CMratio</th>\n",
       "      <th>BlowFlow</th>\n",
       "      <th>ChipLevel4</th>\n",
       "      <th>T-upperExt-2</th>\n",
       "      <th>T-lowerExt-2</th>\n",
       "      <th>UCZAA</th>\n",
       "      <th>WhiteFlow-4</th>\n",
       "      <th>...</th>\n",
       "      <th>SteamFlow-4</th>\n",
       "      <th>Lower-HeatT-3</th>\n",
       "      <th>Upper-HeatT-3</th>\n",
       "      <th>ChipMass-4</th>\n",
       "      <th>WeakLiquorF</th>\n",
       "      <th>BlackFlow-2</th>\n",
       "      <th>WeakWashF</th>\n",
       "      <th>SteamHeatF-3</th>\n",
       "      <th>T-Top-Chips-4</th>\n",
       "      <th>SulphidityL-4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>31-00:00</td>\n",
       "      <td>23.10</td>\n",
       "      <td>16.520</td>\n",
       "      <td>121.717</td>\n",
       "      <td>1177.607</td>\n",
       "      <td>169.805</td>\n",
       "      <td>358.282</td>\n",
       "      <td>329.545</td>\n",
       "      <td>1.443</td>\n",
       "      <td>599.253</td>\n",
       "      <td>...</td>\n",
       "      <td>67.122</td>\n",
       "      <td>329.432</td>\n",
       "      <td>303.099</td>\n",
       "      <td>175.964</td>\n",
       "      <td>1127.197</td>\n",
       "      <td>1319.039</td>\n",
       "      <td>257.325</td>\n",
       "      <td>54.612</td>\n",
       "      <td>252.077</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>31-01:00</td>\n",
       "      <td>27.60</td>\n",
       "      <td>16.810</td>\n",
       "      <td>79.022</td>\n",
       "      <td>1328.360</td>\n",
       "      <td>341.327</td>\n",
       "      <td>351.050</td>\n",
       "      <td>329.067</td>\n",
       "      <td>1.549</td>\n",
       "      <td>537.201</td>\n",
       "      <td>...</td>\n",
       "      <td>60.012</td>\n",
       "      <td>330.823</td>\n",
       "      <td>304.879</td>\n",
       "      <td>163.202</td>\n",
       "      <td>665.975</td>\n",
       "      <td>1297.317</td>\n",
       "      <td>241.182</td>\n",
       "      <td>46.603</td>\n",
       "      <td>251.406</td>\n",
       "      <td>29.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>31-02:00</td>\n",
       "      <td>23.19</td>\n",
       "      <td>16.709</td>\n",
       "      <td>79.562</td>\n",
       "      <td>1329.407</td>\n",
       "      <td>239.161</td>\n",
       "      <td>350.022</td>\n",
       "      <td>329.260</td>\n",
       "      <td>1.600</td>\n",
       "      <td>549.611</td>\n",
       "      <td>...</td>\n",
       "      <td>61.304</td>\n",
       "      <td>329.140</td>\n",
       "      <td>303.383</td>\n",
       "      <td>164.013</td>\n",
       "      <td>677.534</td>\n",
       "      <td>1327.072</td>\n",
       "      <td>237.272</td>\n",
       "      <td>51.795</td>\n",
       "      <td>251.335</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>31-03:00</td>\n",
       "      <td>23.60</td>\n",
       "      <td>16.478</td>\n",
       "      <td>81.011</td>\n",
       "      <td>1334.877</td>\n",
       "      <td>213.527</td>\n",
       "      <td>350.938</td>\n",
       "      <td>331.142</td>\n",
       "      <td>1.604</td>\n",
       "      <td>623.362</td>\n",
       "      <td>...</td>\n",
       "      <td>68.496</td>\n",
       "      <td>328.875</td>\n",
       "      <td>302.254</td>\n",
       "      <td>181.487</td>\n",
       "      <td>767.853</td>\n",
       "      <td>1324.461</td>\n",
       "      <td>239.478</td>\n",
       "      <td>54.846</td>\n",
       "      <td>250.312</td>\n",
       "      <td>29.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>31-04:00</td>\n",
       "      <td>22.90</td>\n",
       "      <td>15.618</td>\n",
       "      <td>93.244</td>\n",
       "      <td>1334.168</td>\n",
       "      <td>243.131</td>\n",
       "      <td>351.640</td>\n",
       "      <td>332.709</td>\n",
       "      <td>NaN</td>\n",
       "      <td>638.672</td>\n",
       "      <td>...</td>\n",
       "      <td>70.022</td>\n",
       "      <td>328.352</td>\n",
       "      <td>300.954</td>\n",
       "      <td>183.929</td>\n",
       "      <td>888.448</td>\n",
       "      <td>1343.424</td>\n",
       "      <td>215.372</td>\n",
       "      <td>54.186</td>\n",
       "      <td>249.916</td>\n",
       "      <td>29.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>10-16:00</td>\n",
       "      <td>23.75</td>\n",
       "      <td>12.667</td>\n",
       "      <td>93.450</td>\n",
       "      <td>1178.252</td>\n",
       "      <td>276.955</td>\n",
       "      <td>347.286</td>\n",
       "      <td>310.970</td>\n",
       "      <td>1.523</td>\n",
       "      <td>513.956</td>\n",
       "      <td>...</td>\n",
       "      <td>61.141</td>\n",
       "      <td>330.117</td>\n",
       "      <td>304.006</td>\n",
       "      <td>148.174</td>\n",
       "      <td>1027.201</td>\n",
       "      <td>1357.271</td>\n",
       "      <td>381.643</td>\n",
       "      <td>45.264</td>\n",
       "      <td>252.947</td>\n",
       "      <td>30.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320</th>\n",
       "      <td>9-19:00</td>\n",
       "      <td>19.80</td>\n",
       "      <td>12.558</td>\n",
       "      <td>94.352</td>\n",
       "      <td>1184.119</td>\n",
       "      <td>297.071</td>\n",
       "      <td>399.135</td>\n",
       "      <td>319.576</td>\n",
       "      <td>1.451</td>\n",
       "      <td>570.058</td>\n",
       "      <td>...</td>\n",
       "      <td>67.667</td>\n",
       "      <td>330.848</td>\n",
       "      <td>304.616</td>\n",
       "      <td>165.178</td>\n",
       "      <td>906.962</td>\n",
       "      <td>1311.177</td>\n",
       "      <td>25.494</td>\n",
       "      <td>50.528</td>\n",
       "      <td>252.092</td>\n",
       "      <td>30.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321</th>\n",
       "      <td>9-20:00</td>\n",
       "      <td>23.01</td>\n",
       "      <td>12.550</td>\n",
       "      <td>90.842</td>\n",
       "      <td>1188.517</td>\n",
       "      <td>289.826</td>\n",
       "      <td>373.633</td>\n",
       "      <td>314.591</td>\n",
       "      <td>1.457</td>\n",
       "      <td>549.306</td>\n",
       "      <td>...</td>\n",
       "      <td>66.446</td>\n",
       "      <td>330.226</td>\n",
       "      <td>304.686</td>\n",
       "      <td>160.841</td>\n",
       "      <td>887.125</td>\n",
       "      <td>1319.226</td>\n",
       "      <td>0.638</td>\n",
       "      <td>45.549</td>\n",
       "      <td>252.438</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>322</th>\n",
       "      <td>9-21:00</td>\n",
       "      <td>24.32</td>\n",
       "      <td>13.083</td>\n",
       "      <td>88.910</td>\n",
       "      <td>1192.879</td>\n",
       "      <td>318.006</td>\n",
       "      <td>364.081</td>\n",
       "      <td>308.559</td>\n",
       "      <td>1.523</td>\n",
       "      <td>504.852</td>\n",
       "      <td>...</td>\n",
       "      <td>61.054</td>\n",
       "      <td>327.346</td>\n",
       "      <td>304.363</td>\n",
       "      <td>147.589</td>\n",
       "      <td>804.423</td>\n",
       "      <td>1320.225</td>\n",
       "      <td>0.000</td>\n",
       "      <td>43.725</td>\n",
       "      <td>253.176</td>\n",
       "      <td>31.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323</th>\n",
       "      <td>9-22:00</td>\n",
       "      <td>25.75</td>\n",
       "      <td>13.417</td>\n",
       "      <td>85.451</td>\n",
       "      <td>1186.342</td>\n",
       "      <td>248.312</td>\n",
       "      <td>356.289</td>\n",
       "      <td>310.482</td>\n",
       "      <td>1.474</td>\n",
       "      <td>497.375</td>\n",
       "      <td>...</td>\n",
       "      <td>58.247</td>\n",
       "      <td>328.092</td>\n",
       "      <td>304.093</td>\n",
       "      <td>144.218</td>\n",
       "      <td>828.328</td>\n",
       "      <td>1320.848</td>\n",
       "      <td>1.276</td>\n",
       "      <td>43.840</td>\n",
       "      <td>253.216</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>324 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Observation  Y-Kappa  ChipRate  BF-CMratio  BlowFlow  ChipLevel4   \\\n",
       "0      31-00:00    23.10    16.520     121.717  1177.607      169.805   \n",
       "1      31-01:00    27.60    16.810      79.022  1328.360      341.327   \n",
       "2      31-02:00    23.19    16.709      79.562  1329.407      239.161   \n",
       "3      31-03:00    23.60    16.478      81.011  1334.877      213.527   \n",
       "4      31-04:00    22.90    15.618      93.244  1334.168      243.131   \n",
       "..          ...      ...       ...         ...       ...          ...   \n",
       "319    10-16:00    23.75    12.667      93.450  1178.252      276.955   \n",
       "320     9-19:00    19.80    12.558      94.352  1184.119      297.071   \n",
       "321     9-20:00    23.01    12.550      90.842  1188.517      289.826   \n",
       "322     9-21:00    24.32    13.083      88.910  1192.879      318.006   \n",
       "323     9-22:00    25.75    13.417      85.451  1186.342      248.312   \n",
       "\n",
       "     T-upperExt-2   T-lowerExt-2    UCZAA  WhiteFlow-4   ...  SteamFlow-4   \\\n",
       "0          358.282         329.545  1.443       599.253  ...        67.122   \n",
       "1          351.050         329.067  1.549       537.201  ...        60.012   \n",
       "2          350.022         329.260  1.600       549.611  ...        61.304   \n",
       "3          350.938         331.142  1.604       623.362  ...        68.496   \n",
       "4          351.640         332.709    NaN       638.672  ...        70.022   \n",
       "..             ...             ...    ...           ...  ...           ...   \n",
       "319        347.286         310.970  1.523       513.956  ...        61.141   \n",
       "320        399.135         319.576  1.451       570.058  ...        67.667   \n",
       "321        373.633         314.591  1.457       549.306  ...        66.446   \n",
       "322        364.081         308.559  1.523       504.852  ...        61.054   \n",
       "323        356.289         310.482  1.474       497.375  ...        58.247   \n",
       "\n",
       "     Lower-HeatT-3  Upper-HeatT-3   ChipMass-4   WeakLiquorF   BlackFlow-2   \\\n",
       "0          329.432         303.099      175.964      1127.197      1319.039   \n",
       "1          330.823         304.879      163.202       665.975      1297.317   \n",
       "2          329.140         303.383      164.013       677.534      1327.072   \n",
       "3          328.875         302.254      181.487       767.853      1324.461   \n",
       "4          328.352         300.954      183.929       888.448      1343.424   \n",
       "..             ...             ...          ...           ...           ...   \n",
       "319        330.117         304.006      148.174      1027.201      1357.271   \n",
       "320        330.848         304.616      165.178       906.962      1311.177   \n",
       "321        330.226         304.686      160.841       887.125      1319.226   \n",
       "322        327.346         304.363      147.589       804.423      1320.225   \n",
       "323        328.092         304.093      144.218       828.328      1320.848   \n",
       "\n",
       "     WeakWashF   SteamHeatF-3   T-Top-Chips-4   SulphidityL-4   \n",
       "0       257.325         54.612         252.077             NaN  \n",
       "1       241.182         46.603         251.406           29.11  \n",
       "2       237.272         51.795         251.335             NaN  \n",
       "3       239.478         54.846         250.312           29.02  \n",
       "4       215.372         54.186         249.916           29.01  \n",
       "..          ...            ...             ...             ...  \n",
       "319     381.643         45.264         252.947           30.86  \n",
       "320      25.494         50.528         252.092           30.70  \n",
       "321       0.638         45.549         252.438             NaN  \n",
       "322       0.000         43.725         253.176           31.13  \n",
       "323       1.276         43.840         253.216             NaN  \n",
       "\n",
       "[324 rows x 23 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data=pd.read_csv(\"C:\\\\Users\\\\shanm\\\\OneDrive\\\\Desktop\\\\Python pro\\\\01.Data Cleaning and Preprocessing.csv\")\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "80ce676c-231c-48fb-b034-9684635e3728",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.frame.DataFrame"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "7055c1cb-e697-41ef-97d4-07f316174833",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method DataFrame.info of     Observation  Y-Kappa  ChipRate  BF-CMratio  BlowFlow  ChipLevel4   \\\n",
       "0      31-00:00    23.10    16.520     121.717  1177.607      169.805   \n",
       "1      31-01:00    27.60    16.810      79.022  1328.360      341.327   \n",
       "2      31-02:00    23.19    16.709      79.562  1329.407      239.161   \n",
       "3      31-03:00    23.60    16.478      81.011  1334.877      213.527   \n",
       "4      31-04:00    22.90    15.618      93.244  1334.168      243.131   \n",
       "..          ...      ...       ...         ...       ...          ...   \n",
       "319    10-16:00    23.75    12.667      93.450  1178.252      276.955   \n",
       "320     9-19:00    19.80    12.558      94.352  1184.119      297.071   \n",
       "321     9-20:00    23.01    12.550      90.842  1188.517      289.826   \n",
       "322     9-21:00    24.32    13.083      88.910  1192.879      318.006   \n",
       "323     9-22:00    25.75    13.417      85.451  1186.342      248.312   \n",
       "\n",
       "     T-upperExt-2   T-lowerExt-2    UCZAA  WhiteFlow-4   ...  SteamFlow-4   \\\n",
       "0          358.282         329.545  1.443       599.253  ...        67.122   \n",
       "1          351.050         329.067  1.549       537.201  ...        60.012   \n",
       "2          350.022         329.260  1.600       549.611  ...        61.304   \n",
       "3          350.938         331.142  1.604       623.362  ...        68.496   \n",
       "4          351.640         332.709    NaN       638.672  ...        70.022   \n",
       "..             ...             ...    ...           ...  ...           ...   \n",
       "319        347.286         310.970  1.523       513.956  ...        61.141   \n",
       "320        399.135         319.576  1.451       570.058  ...        67.667   \n",
       "321        373.633         314.591  1.457       549.306  ...        66.446   \n",
       "322        364.081         308.559  1.523       504.852  ...        61.054   \n",
       "323        356.289         310.482  1.474       497.375  ...        58.247   \n",
       "\n",
       "     Lower-HeatT-3  Upper-HeatT-3   ChipMass-4   WeakLiquorF   BlackFlow-2   \\\n",
       "0          329.432         303.099      175.964      1127.197      1319.039   \n",
       "1          330.823         304.879      163.202       665.975      1297.317   \n",
       "2          329.140         303.383      164.013       677.534      1327.072   \n",
       "3          328.875         302.254      181.487       767.853      1324.461   \n",
       "4          328.352         300.954      183.929       888.448      1343.424   \n",
       "..             ...             ...          ...           ...           ...   \n",
       "319        330.117         304.006      148.174      1027.201      1357.271   \n",
       "320        330.848         304.616      165.178       906.962      1311.177   \n",
       "321        330.226         304.686      160.841       887.125      1319.226   \n",
       "322        327.346         304.363      147.589       804.423      1320.225   \n",
       "323        328.092         304.093      144.218       828.328      1320.848   \n",
       "\n",
       "     WeakWashF   SteamHeatF-3   T-Top-Chips-4   SulphidityL-4   \n",
       "0       257.325         54.612         252.077             NaN  \n",
       "1       241.182         46.603         251.406           29.11  \n",
       "2       237.272         51.795         251.335             NaN  \n",
       "3       239.478         54.846         250.312           29.02  \n",
       "4       215.372         54.186         249.916           29.01  \n",
       "..          ...            ...             ...             ...  \n",
       "319     381.643         45.264         252.947           30.86  \n",
       "320      25.494         50.528         252.092           30.70  \n",
       "321       0.638         45.549         252.438             NaN  \n",
       "322       0.000         43.725         253.176           31.13  \n",
       "323       1.276         43.840         253.216             NaN  \n",
       "\n",
       "[324 rows x 23 columns]>"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.info"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "fb508435-ca0f-4ed5-a28c-4fff85bae985",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Y-Kappa</th>\n",
       "      <th>ChipRate</th>\n",
       "      <th>BF-CMratio</th>\n",
       "      <th>BlowFlow</th>\n",
       "      <th>ChipLevel4</th>\n",
       "      <th>T-upperExt-2</th>\n",
       "      <th>T-lowerExt-2</th>\n",
       "      <th>UCZAA</th>\n",
       "      <th>WhiteFlow-4</th>\n",
       "      <th>AAWhiteSt-4</th>\n",
       "      <th>...</th>\n",
       "      <th>SteamFlow-4</th>\n",
       "      <th>Lower-HeatT-3</th>\n",
       "      <th>Upper-HeatT-3</th>\n",
       "      <th>ChipMass-4</th>\n",
       "      <th>WeakLiquorF</th>\n",
       "      <th>BlackFlow-2</th>\n",
       "      <th>WeakWashF</th>\n",
       "      <th>SteamHeatF-3</th>\n",
       "      <th>T-Top-Chips-4</th>\n",
       "      <th>SulphidityL-4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>324.000000</td>\n",
       "      <td>319.000000</td>\n",
       "      <td>307.000000</td>\n",
       "      <td>308.000000</td>\n",
       "      <td>323.000000</td>\n",
       "      <td>322.000000</td>\n",
       "      <td>322.000000</td>\n",
       "      <td>299.000000</td>\n",
       "      <td>323.000000</td>\n",
       "      <td>173.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>323.000000</td>\n",
       "      <td>322.000000</td>\n",
       "      <td>322.000000</td>\n",
       "      <td>323.000000</td>\n",
       "      <td>323.000000</td>\n",
       "      <td>322.000000</td>\n",
       "      <td>323.000000</td>\n",
       "      <td>322.000000</td>\n",
       "      <td>323.000000</td>\n",
       "      <td>173.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>20.635370</td>\n",
       "      <td>14.347937</td>\n",
       "      <td>87.464456</td>\n",
       "      <td>1237.837614</td>\n",
       "      <td>258.164483</td>\n",
       "      <td>356.904295</td>\n",
       "      <td>324.020180</td>\n",
       "      <td>1.492010</td>\n",
       "      <td>591.732260</td>\n",
       "      <td>6.140410</td>\n",
       "      <td>...</td>\n",
       "      <td>66.668285</td>\n",
       "      <td>325.567820</td>\n",
       "      <td>300.525699</td>\n",
       "      <td>162.222322</td>\n",
       "      <td>873.828941</td>\n",
       "      <td>1175.917016</td>\n",
       "      <td>263.543068</td>\n",
       "      <td>49.696907</td>\n",
       "      <td>251.240087</td>\n",
       "      <td>30.411671</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>3.070036</td>\n",
       "      <td>1.499095</td>\n",
       "      <td>7.995012</td>\n",
       "      <td>100.593735</td>\n",
       "      <td>87.987452</td>\n",
       "      <td>9.209290</td>\n",
       "      <td>7.621402</td>\n",
       "      <td>0.105923</td>\n",
       "      <td>67.016351</td>\n",
       "      <td>0.081609</td>\n",
       "      <td>...</td>\n",
       "      <td>5.708587</td>\n",
       "      <td>4.609862</td>\n",
       "      <td>4.568484</td>\n",
       "      <td>14.160688</td>\n",
       "      <td>122.073521</td>\n",
       "      <td>149.334010</td>\n",
       "      <td>163.666942</td>\n",
       "      <td>4.551909</td>\n",
       "      <td>1.283432</td>\n",
       "      <td>0.701317</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>12.170000</td>\n",
       "      <td>9.983000</td>\n",
       "      <td>68.645000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>339.168000</td>\n",
       "      <td>284.633000</td>\n",
       "      <td>1.182000</td>\n",
       "      <td>405.111000</td>\n",
       "      <td>5.890000</td>\n",
       "      <td>...</td>\n",
       "      <td>48.568000</td>\n",
       "      <td>318.051000</td>\n",
       "      <td>293.312000</td>\n",
       "      <td>113.922000</td>\n",
       "      <td>486.938000</td>\n",
       "      <td>838.948000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>35.510000</td>\n",
       "      <td>248.359000</td>\n",
       "      <td>29.010000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>18.382500</td>\n",
       "      <td>13.358000</td>\n",
       "      <td>81.823000</td>\n",
       "      <td>1193.215250</td>\n",
       "      <td>213.527000</td>\n",
       "      <td>350.241250</td>\n",
       "      <td>321.420000</td>\n",
       "      <td>1.431500</td>\n",
       "      <td>540.989500</td>\n",
       "      <td>6.089000</td>\n",
       "      <td>...</td>\n",
       "      <td>62.518000</td>\n",
       "      <td>321.385500</td>\n",
       "      <td>296.513250</td>\n",
       "      <td>153.032500</td>\n",
       "      <td>792.019500</td>\n",
       "      <td>1044.817500</td>\n",
       "      <td>134.649000</td>\n",
       "      <td>46.389750</td>\n",
       "      <td>250.312000</td>\n",
       "      <td>29.970000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>20.845000</td>\n",
       "      <td>14.308000</td>\n",
       "      <td>86.739000</td>\n",
       "      <td>1273.138500</td>\n",
       "      <td>271.792000</td>\n",
       "      <td>356.843000</td>\n",
       "      <td>325.669000</td>\n",
       "      <td>1.498000</td>\n",
       "      <td>592.895000</td>\n",
       "      <td>6.135000</td>\n",
       "      <td>...</td>\n",
       "      <td>67.429000</td>\n",
       "      <td>324.741000</td>\n",
       "      <td>299.126000</td>\n",
       "      <td>163.690000</td>\n",
       "      <td>865.254000</td>\n",
       "      <td>1150.221500</td>\n",
       "      <td>269.193000</td>\n",
       "      <td>50.277000</td>\n",
       "      <td>251.380000</td>\n",
       "      <td>30.370000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>23.032500</td>\n",
       "      <td>15.517000</td>\n",
       "      <td>92.372000</td>\n",
       "      <td>1289.196000</td>\n",
       "      <td>321.680000</td>\n",
       "      <td>362.242250</td>\n",
       "      <td>329.175000</td>\n",
       "      <td>1.560500</td>\n",
       "      <td>639.480500</td>\n",
       "      <td>6.199000</td>\n",
       "      <td>...</td>\n",
       "      <td>71.522000</td>\n",
       "      <td>329.845250</td>\n",
       "      <td>304.244750</td>\n",
       "      <td>172.555000</td>\n",
       "      <td>965.286500</td>\n",
       "      <td>1319.021250</td>\n",
       "      <td>405.563000</td>\n",
       "      <td>53.294250</td>\n",
       "      <td>252.323500</td>\n",
       "      <td>30.820000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>27.600000</td>\n",
       "      <td>16.958000</td>\n",
       "      <td>121.717000</td>\n",
       "      <td>1351.240000</td>\n",
       "      <td>419.014000</td>\n",
       "      <td>399.135000</td>\n",
       "      <td>337.012000</td>\n",
       "      <td>1.747000</td>\n",
       "      <td>731.394000</td>\n",
       "      <td>6.340000</td>\n",
       "      <td>...</td>\n",
       "      <td>76.147000</td>\n",
       "      <td>333.854000</td>\n",
       "      <td>311.146000</td>\n",
       "      <td>189.268000</td>\n",
       "      <td>1226.277000</td>\n",
       "      <td>1395.767000</td>\n",
       "      <td>715.715000</td>\n",
       "      <td>63.332000</td>\n",
       "      <td>254.122000</td>\n",
       "      <td>32.840000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          Y-Kappa    ChipRate  BF-CMratio     BlowFlow  ChipLevel4   \\\n",
       "count  324.000000  319.000000  307.000000   308.000000   323.000000   \n",
       "mean    20.635370   14.347937   87.464456  1237.837614   258.164483   \n",
       "std      3.070036    1.499095    7.995012   100.593735    87.987452   \n",
       "min     12.170000    9.983000   68.645000     0.000000     0.000000   \n",
       "25%     18.382500   13.358000   81.823000  1193.215250   213.527000   \n",
       "50%     20.845000   14.308000   86.739000  1273.138500   271.792000   \n",
       "75%     23.032500   15.517000   92.372000  1289.196000   321.680000   \n",
       "max     27.600000   16.958000  121.717000  1351.240000   419.014000   \n",
       "\n",
       "       T-upperExt-2   T-lowerExt-2         UCZAA  WhiteFlow-4   AAWhiteSt-4   \\\n",
       "count     322.000000      322.000000  299.000000    323.000000    173.000000   \n",
       "mean      356.904295      324.020180    1.492010    591.732260      6.140410   \n",
       "std         9.209290        7.621402    0.105923     67.016351      0.081609   \n",
       "min       339.168000      284.633000    1.182000    405.111000      5.890000   \n",
       "25%       350.241250      321.420000    1.431500    540.989500      6.089000   \n",
       "50%       356.843000      325.669000    1.498000    592.895000      6.135000   \n",
       "75%       362.242250      329.175000    1.560500    639.480500      6.199000   \n",
       "max       399.135000      337.012000    1.747000    731.394000      6.340000   \n",
       "\n",
       "       ...  SteamFlow-4   Lower-HeatT-3  Upper-HeatT-3   ChipMass-4   \\\n",
       "count  ...    323.000000     322.000000      322.000000   323.000000   \n",
       "mean   ...     66.668285     325.567820      300.525699   162.222322   \n",
       "std    ...      5.708587       4.609862        4.568484    14.160688   \n",
       "min    ...     48.568000     318.051000      293.312000   113.922000   \n",
       "25%    ...     62.518000     321.385500      296.513250   153.032500   \n",
       "50%    ...     67.429000     324.741000      299.126000   163.690000   \n",
       "75%    ...     71.522000     329.845250      304.244750   172.555000   \n",
       "max    ...     76.147000     333.854000      311.146000   189.268000   \n",
       "\n",
       "       WeakLiquorF   BlackFlow-2   WeakWashF   SteamHeatF-3   T-Top-Chips-4   \\\n",
       "count    323.000000    322.000000  323.000000     322.000000      323.000000   \n",
       "mean     873.828941   1175.917016  263.543068      49.696907      251.240087   \n",
       "std      122.073521    149.334010  163.666942       4.551909        1.283432   \n",
       "min      486.938000    838.948000    0.000000      35.510000      248.359000   \n",
       "25%      792.019500   1044.817500  134.649000      46.389750      250.312000   \n",
       "50%      865.254000   1150.221500  269.193000      50.277000      251.380000   \n",
       "75%      965.286500   1319.021250  405.563000      53.294250      252.323500   \n",
       "max     1226.277000   1395.767000  715.715000      63.332000      254.122000   \n",
       "\n",
       "       SulphidityL-4   \n",
       "count      173.000000  \n",
       "mean        30.411671  \n",
       "std          0.701317  \n",
       "min         29.010000  \n",
       "25%         29.970000  \n",
       "50%         30.370000  \n",
       "75%         30.820000  \n",
       "max         32.840000  \n",
       "\n",
       "[8 rows x 22 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "a09ac954-5625-47ba-b957-51dbecf9c75a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Observation</th>\n",
       "      <th>Y-Kappa</th>\n",
       "      <th>ChipRate</th>\n",
       "      <th>BF-CMratio</th>\n",
       "      <th>BlowFlow</th>\n",
       "      <th>ChipLevel4</th>\n",
       "      <th>T-upperExt-2</th>\n",
       "      <th>T-lowerExt-2</th>\n",
       "      <th>UCZAA</th>\n",
       "      <th>WhiteFlow-4</th>\n",
       "      <th>...</th>\n",
       "      <th>SteamFlow-4</th>\n",
       "      <th>Lower-HeatT-3</th>\n",
       "      <th>Upper-HeatT-3</th>\n",
       "      <th>ChipMass-4</th>\n",
       "      <th>WeakLiquorF</th>\n",
       "      <th>BlackFlow-2</th>\n",
       "      <th>WeakWashF</th>\n",
       "      <th>SteamHeatF-3</th>\n",
       "      <th>T-Top-Chips-4</th>\n",
       "      <th>SulphidityL-4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>31-00:00</td>\n",
       "      <td>23.10</td>\n",
       "      <td>16.520</td>\n",
       "      <td>121.717</td>\n",
       "      <td>1177.607</td>\n",
       "      <td>169.805</td>\n",
       "      <td>358.282</td>\n",
       "      <td>329.545</td>\n",
       "      <td>1.443</td>\n",
       "      <td>599.253</td>\n",
       "      <td>...</td>\n",
       "      <td>67.122</td>\n",
       "      <td>329.432</td>\n",
       "      <td>303.099</td>\n",
       "      <td>175.964</td>\n",
       "      <td>1127.197</td>\n",
       "      <td>1319.039</td>\n",
       "      <td>257.325</td>\n",
       "      <td>54.612</td>\n",
       "      <td>252.077</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>31-01:00</td>\n",
       "      <td>27.60</td>\n",
       "      <td>16.810</td>\n",
       "      <td>79.022</td>\n",
       "      <td>1328.360</td>\n",
       "      <td>341.327</td>\n",
       "      <td>351.050</td>\n",
       "      <td>329.067</td>\n",
       "      <td>1.549</td>\n",
       "      <td>537.201</td>\n",
       "      <td>...</td>\n",
       "      <td>60.012</td>\n",
       "      <td>330.823</td>\n",
       "      <td>304.879</td>\n",
       "      <td>163.202</td>\n",
       "      <td>665.975</td>\n",
       "      <td>1297.317</td>\n",
       "      <td>241.182</td>\n",
       "      <td>46.603</td>\n",
       "      <td>251.406</td>\n",
       "      <td>29.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>31-02:00</td>\n",
       "      <td>23.19</td>\n",
       "      <td>16.709</td>\n",
       "      <td>79.562</td>\n",
       "      <td>1329.407</td>\n",
       "      <td>239.161</td>\n",
       "      <td>350.022</td>\n",
       "      <td>329.260</td>\n",
       "      <td>1.600</td>\n",
       "      <td>549.611</td>\n",
       "      <td>...</td>\n",
       "      <td>61.304</td>\n",
       "      <td>329.140</td>\n",
       "      <td>303.383</td>\n",
       "      <td>164.013</td>\n",
       "      <td>677.534</td>\n",
       "      <td>1327.072</td>\n",
       "      <td>237.272</td>\n",
       "      <td>51.795</td>\n",
       "      <td>251.335</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>31-03:00</td>\n",
       "      <td>23.60</td>\n",
       "      <td>16.478</td>\n",
       "      <td>81.011</td>\n",
       "      <td>1334.877</td>\n",
       "      <td>213.527</td>\n",
       "      <td>350.938</td>\n",
       "      <td>331.142</td>\n",
       "      <td>1.604</td>\n",
       "      <td>623.362</td>\n",
       "      <td>...</td>\n",
       "      <td>68.496</td>\n",
       "      <td>328.875</td>\n",
       "      <td>302.254</td>\n",
       "      <td>181.487</td>\n",
       "      <td>767.853</td>\n",
       "      <td>1324.461</td>\n",
       "      <td>239.478</td>\n",
       "      <td>54.846</td>\n",
       "      <td>250.312</td>\n",
       "      <td>29.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>31-04:00</td>\n",
       "      <td>22.90</td>\n",
       "      <td>15.618</td>\n",
       "      <td>93.244</td>\n",
       "      <td>1334.168</td>\n",
       "      <td>243.131</td>\n",
       "      <td>351.640</td>\n",
       "      <td>332.709</td>\n",
       "      <td>NaN</td>\n",
       "      <td>638.672</td>\n",
       "      <td>...</td>\n",
       "      <td>70.022</td>\n",
       "      <td>328.352</td>\n",
       "      <td>300.954</td>\n",
       "      <td>183.929</td>\n",
       "      <td>888.448</td>\n",
       "      <td>1343.424</td>\n",
       "      <td>215.372</td>\n",
       "      <td>54.186</td>\n",
       "      <td>249.916</td>\n",
       "      <td>29.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>12-09:00</td>\n",
       "      <td>20.90</td>\n",
       "      <td>15.167</td>\n",
       "      <td>84.640</td>\n",
       "      <td>1283.706</td>\n",
       "      <td>339.440</td>\n",
       "      <td>354.803</td>\n",
       "      <td>311.041</td>\n",
       "      <td>1.635</td>\n",
       "      <td>532.419</td>\n",
       "      <td>...</td>\n",
       "      <td>65.561</td>\n",
       "      <td>332.924</td>\n",
       "      <td>307.626</td>\n",
       "      <td>145.299</td>\n",
       "      <td>832.906</td>\n",
       "      <td>1344.708</td>\n",
       "      <td>388.911</td>\n",
       "      <td>49.524</td>\n",
       "      <td>251.833</td>\n",
       "      <td>30.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>12-10:00</td>\n",
       "      <td>24.98</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85.034</td>\n",
       "      <td>1278.345</td>\n",
       "      <td>368.564</td>\n",
       "      <td>357.723</td>\n",
       "      <td>321.387</td>\n",
       "      <td>NaN</td>\n",
       "      <td>520.365</td>\n",
       "      <td>...</td>\n",
       "      <td>65.729</td>\n",
       "      <td>332.523</td>\n",
       "      <td>307.169</td>\n",
       "      <td>151.544</td>\n",
       "      <td>905.639</td>\n",
       "      <td>1344.469</td>\n",
       "      <td>418.979</td>\n",
       "      <td>48.135</td>\n",
       "      <td>251.614</td>\n",
       "      <td>30.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300</th>\n",
       "      <td>12-11:00</td>\n",
       "      <td>21.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88.013</td>\n",
       "      <td>1307.722</td>\n",
       "      <td>278.842</td>\n",
       "      <td>357.438</td>\n",
       "      <td>323.757</td>\n",
       "      <td>NaN</td>\n",
       "      <td>553.070</td>\n",
       "      <td>...</td>\n",
       "      <td>65.795</td>\n",
       "      <td>331.263</td>\n",
       "      <td>306.400</td>\n",
       "      <td>157.954</td>\n",
       "      <td>908.691</td>\n",
       "      <td>1344.588</td>\n",
       "      <td>462.712</td>\n",
       "      <td>54.373</td>\n",
       "      <td>251.197</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>12-12:00</td>\n",
       "      <td>21.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85.490</td>\n",
       "      <td>1255.986</td>\n",
       "      <td>273.484</td>\n",
       "      <td>361.365</td>\n",
       "      <td>322.689</td>\n",
       "      <td>NaN</td>\n",
       "      <td>590.199</td>\n",
       "      <td>...</td>\n",
       "      <td>71.456</td>\n",
       "      <td>333.032</td>\n",
       "      <td>308.732</td>\n",
       "      <td>174.069</td>\n",
       "      <td>986.206</td>\n",
       "      <td>1348.747</td>\n",
       "      <td>457.313</td>\n",
       "      <td>53.194</td>\n",
       "      <td>251.324</td>\n",
       "      <td>30.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>307</th>\n",
       "      <td>31-05:00</td>\n",
       "      <td>20.89</td>\n",
       "      <td>14.308</td>\n",
       "      <td>94.172</td>\n",
       "      <td>1327.832</td>\n",
       "      <td>251.120</td>\n",
       "      <td>351.263</td>\n",
       "      <td>332.485</td>\n",
       "      <td>1.522</td>\n",
       "      <td>631.514</td>\n",
       "      <td>...</td>\n",
       "      <td>71.286</td>\n",
       "      <td>328.699</td>\n",
       "      <td>300.706</td>\n",
       "      <td>180.229</td>\n",
       "      <td>903.605</td>\n",
       "      <td>1323.082</td>\n",
       "      <td>232.729</td>\n",
       "      <td>54.503</td>\n",
       "      <td>250.084</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>301 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Observation  Y-Kappa  ChipRate  BF-CMratio  BlowFlow  ChipLevel4   \\\n",
       "0      31-00:00    23.10    16.520     121.717  1177.607      169.805   \n",
       "1      31-01:00    27.60    16.810      79.022  1328.360      341.327   \n",
       "2      31-02:00    23.19    16.709      79.562  1329.407      239.161   \n",
       "3      31-03:00    23.60    16.478      81.011  1334.877      213.527   \n",
       "4      31-04:00    22.90    15.618      93.244  1334.168      243.131   \n",
       "..          ...      ...       ...         ...       ...          ...   \n",
       "298    12-09:00    20.90    15.167      84.640  1283.706      339.440   \n",
       "299    12-10:00    24.98       NaN      85.034  1278.345      368.564   \n",
       "300    12-11:00    21.00       NaN      88.013  1307.722      278.842   \n",
       "301    12-12:00    21.40       NaN      85.490  1255.986      273.484   \n",
       "307    31-05:00    20.89    14.308      94.172  1327.832      251.120   \n",
       "\n",
       "     T-upperExt-2   T-lowerExt-2    UCZAA  WhiteFlow-4   ...  SteamFlow-4   \\\n",
       "0          358.282         329.545  1.443       599.253  ...        67.122   \n",
       "1          351.050         329.067  1.549       537.201  ...        60.012   \n",
       "2          350.022         329.260  1.600       549.611  ...        61.304   \n",
       "3          350.938         331.142  1.604       623.362  ...        68.496   \n",
       "4          351.640         332.709    NaN       638.672  ...        70.022   \n",
       "..             ...             ...    ...           ...  ...           ...   \n",
       "298        354.803         311.041  1.635       532.419  ...        65.561   \n",
       "299        357.723         321.387    NaN       520.365  ...        65.729   \n",
       "300        357.438         323.757    NaN       553.070  ...        65.795   \n",
       "301        361.365         322.689    NaN       590.199  ...        71.456   \n",
       "307        351.263         332.485  1.522       631.514  ...        71.286   \n",
       "\n",
       "     Lower-HeatT-3  Upper-HeatT-3   ChipMass-4   WeakLiquorF   BlackFlow-2   \\\n",
       "0          329.432         303.099      175.964      1127.197      1319.039   \n",
       "1          330.823         304.879      163.202       665.975      1297.317   \n",
       "2          329.140         303.383      164.013       677.534      1327.072   \n",
       "3          328.875         302.254      181.487       767.853      1324.461   \n",
       "4          328.352         300.954      183.929       888.448      1343.424   \n",
       "..             ...             ...          ...           ...           ...   \n",
       "298        332.924         307.626      145.299       832.906      1344.708   \n",
       "299        332.523         307.169      151.544       905.639      1344.469   \n",
       "300        331.263         306.400      157.954       908.691      1344.588   \n",
       "301        333.032         308.732      174.069       986.206      1348.747   \n",
       "307        328.699         300.706      180.229       903.605      1323.082   \n",
       "\n",
       "     WeakWashF   SteamHeatF-3   T-Top-Chips-4   SulphidityL-4   \n",
       "0       257.325         54.612         252.077             NaN  \n",
       "1       241.182         46.603         251.406           29.11  \n",
       "2       237.272         51.795         251.335             NaN  \n",
       "3       239.478         54.846         250.312           29.02  \n",
       "4       215.372         54.186         249.916           29.01  \n",
       "..          ...            ...             ...             ...  \n",
       "298     388.911         49.524         251.833           30.29  \n",
       "299     418.979         48.135         251.614           30.47  \n",
       "300     462.712         54.373         251.197             NaN  \n",
       "301     457.313         53.194         251.324           30.46  \n",
       "307     232.729         54.503         250.084             NaN  \n",
       "\n",
       "[301 rows x 23 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data=data.drop_duplicates()\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "d8253fba-a3d6-4b2c-9290-2799e7a71a89",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Observation</th>\n",
       "      <th>Y-Kappa</th>\n",
       "      <th>ChipRate</th>\n",
       "      <th>BF-CMratio</th>\n",
       "      <th>BlowFlow</th>\n",
       "      <th>ChipLevel4</th>\n",
       "      <th>T-upperExt-2</th>\n",
       "      <th>T-lowerExt-2</th>\n",
       "      <th>UCZAA</th>\n",
       "      <th>WhiteFlow-4</th>\n",
       "      <th>...</th>\n",
       "      <th>SteamFlow-4</th>\n",
       "      <th>Lower-HeatT-3</th>\n",
       "      <th>Upper-HeatT-3</th>\n",
       "      <th>ChipMass-4</th>\n",
       "      <th>WeakLiquorF</th>\n",
       "      <th>BlackFlow-2</th>\n",
       "      <th>WeakWashF</th>\n",
       "      <th>SteamHeatF-3</th>\n",
       "      <th>T-Top-Chips-4</th>\n",
       "      <th>SulphidityL-4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>307</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>301 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Observation  Y-Kappa  ChipRate  BF-CMratio  BlowFlow  ChipLevel4   \\\n",
       "0          False    False     False       False     False        False   \n",
       "1          False    False     False       False     False        False   \n",
       "2          False    False     False       False     False        False   \n",
       "3          False    False     False       False     False        False   \n",
       "4          False    False     False       False     False        False   \n",
       "..           ...      ...       ...         ...       ...          ...   \n",
       "298        False    False     False       False     False        False   \n",
       "299        False    False      True       False     False        False   \n",
       "300        False    False      True       False     False        False   \n",
       "301        False    False      True       False     False        False   \n",
       "307        False    False     False       False     False        False   \n",
       "\n",
       "     T-upperExt-2   T-lowerExt-2    UCZAA  WhiteFlow-4   ...  SteamFlow-4   \\\n",
       "0            False           False  False         False  ...         False   \n",
       "1            False           False  False         False  ...         False   \n",
       "2            False           False  False         False  ...         False   \n",
       "3            False           False  False         False  ...         False   \n",
       "4            False           False   True         False  ...         False   \n",
       "..             ...             ...    ...           ...  ...           ...   \n",
       "298          False           False  False         False  ...         False   \n",
       "299          False           False   True         False  ...         False   \n",
       "300          False           False   True         False  ...         False   \n",
       "301          False           False   True         False  ...         False   \n",
       "307          False           False  False         False  ...         False   \n",
       "\n",
       "     Lower-HeatT-3  Upper-HeatT-3   ChipMass-4   WeakLiquorF   BlackFlow-2   \\\n",
       "0            False           False        False         False         False   \n",
       "1            False           False        False         False         False   \n",
       "2            False           False        False         False         False   \n",
       "3            False           False        False         False         False   \n",
       "4            False           False        False         False         False   \n",
       "..             ...             ...          ...           ...           ...   \n",
       "298          False           False        False         False         False   \n",
       "299          False           False        False         False         False   \n",
       "300          False           False        False         False         False   \n",
       "301          False           False        False         False         False   \n",
       "307          False           False        False         False         False   \n",
       "\n",
       "     WeakWashF   SteamHeatF-3   T-Top-Chips-4   SulphidityL-4   \n",
       "0         False          False           False            True  \n",
       "1         False          False           False           False  \n",
       "2         False          False           False            True  \n",
       "3         False          False           False           False  \n",
       "4         False          False           False           False  \n",
       "..          ...            ...             ...             ...  \n",
       "298       False          False           False           False  \n",
       "299       False          False           False           False  \n",
       "300       False          False           False            True  \n",
       "301       False          False           False           False  \n",
       "307       False          False           False            True  \n",
       "\n",
       "[301 rows x 23 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.isnull()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "2245a550-a6f5-47db-aad6-b591e661a236",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Observation          0\n",
       "Y-Kappa              0\n",
       "ChipRate             4\n",
       "BF-CMratio          14\n",
       "BlowFlow            13\n",
       "ChipLevel4           1\n",
       "T-upperExt-2         1\n",
       "T-lowerExt-2         1\n",
       "UCZAA               24\n",
       "WhiteFlow-4          1\n",
       "AAWhiteSt-4        141\n",
       "AA-Wood-4            1\n",
       "ChipMoisture-4       1\n",
       "SteamFlow-4          1\n",
       "Lower-HeatT-3        1\n",
       "Upper-HeatT-3        1\n",
       "ChipMass-4           1\n",
       "WeakLiquorF          1\n",
       "BlackFlow-2          1\n",
       "WeakWashF            1\n",
       "SteamHeatF-3         1\n",
       "T-Top-Chips-4        1\n",
       "SulphidityL-4      141\n",
       "dtype: int64"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "b17175ac-c3c5-46f2-852c-e1eef66d4d39",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Observation</th>\n",
       "      <th>Y-Kappa</th>\n",
       "      <th>ChipRate</th>\n",
       "      <th>BF-CMratio</th>\n",
       "      <th>BlowFlow</th>\n",
       "      <th>ChipLevel4</th>\n",
       "      <th>T-upperExt-2</th>\n",
       "      <th>T-lowerExt-2</th>\n",
       "      <th>UCZAA</th>\n",
       "      <th>WhiteFlow-4</th>\n",
       "      <th>...</th>\n",
       "      <th>SteamFlow-4</th>\n",
       "      <th>Lower-HeatT-3</th>\n",
       "      <th>Upper-HeatT-3</th>\n",
       "      <th>ChipMass-4</th>\n",
       "      <th>WeakLiquorF</th>\n",
       "      <th>BlackFlow-2</th>\n",
       "      <th>WeakWashF</th>\n",
       "      <th>SteamHeatF-3</th>\n",
       "      <th>T-Top-Chips-4</th>\n",
       "      <th>SulphidityL-4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>307</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>301 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Observation  Y-Kappa  ChipRate  BF-CMratio  BlowFlow  ChipLevel4   \\\n",
       "0           True     True      True        True      True         True   \n",
       "1           True     True      True        True      True         True   \n",
       "2           True     True      True        True      True         True   \n",
       "3           True     True      True        True      True         True   \n",
       "4           True     True      True        True      True         True   \n",
       "..           ...      ...       ...         ...       ...          ...   \n",
       "298         True     True      True        True      True         True   \n",
       "299         True     True     False        True      True         True   \n",
       "300         True     True     False        True      True         True   \n",
       "301         True     True     False        True      True         True   \n",
       "307         True     True      True        True      True         True   \n",
       "\n",
       "     T-upperExt-2   T-lowerExt-2    UCZAA  WhiteFlow-4   ...  SteamFlow-4   \\\n",
       "0             True            True   True          True  ...          True   \n",
       "1             True            True   True          True  ...          True   \n",
       "2             True            True   True          True  ...          True   \n",
       "3             True            True   True          True  ...          True   \n",
       "4             True            True  False          True  ...          True   \n",
       "..             ...             ...    ...           ...  ...           ...   \n",
       "298           True            True   True          True  ...          True   \n",
       "299           True            True  False          True  ...          True   \n",
       "300           True            True  False          True  ...          True   \n",
       "301           True            True  False          True  ...          True   \n",
       "307           True            True   True          True  ...          True   \n",
       "\n",
       "     Lower-HeatT-3  Upper-HeatT-3   ChipMass-4   WeakLiquorF   BlackFlow-2   \\\n",
       "0             True            True         True          True          True   \n",
       "1             True            True         True          True          True   \n",
       "2             True            True         True          True          True   \n",
       "3             True            True         True          True          True   \n",
       "4             True            True         True          True          True   \n",
       "..             ...             ...          ...           ...           ...   \n",
       "298           True            True         True          True          True   \n",
       "299           True            True         True          True          True   \n",
       "300           True            True         True          True          True   \n",
       "301           True            True         True          True          True   \n",
       "307           True            True         True          True          True   \n",
       "\n",
       "     WeakWashF   SteamHeatF-3   T-Top-Chips-4   SulphidityL-4   \n",
       "0          True           True            True           False  \n",
       "1          True           True            True            True  \n",
       "2          True           True            True           False  \n",
       "3          True           True            True            True  \n",
       "4          True           True            True            True  \n",
       "..          ...            ...             ...             ...  \n",
       "298        True           True            True            True  \n",
       "299        True           True            True            True  \n",
       "300        True           True            True           False  \n",
       "301        True           True            True            True  \n",
       "307        True           True            True           False  \n",
       "\n",
       "[301 rows x 23 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.notnull()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "6bd3ca0b-cd56-4840-8dd0-1811b8ea3d5d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "352"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.isnull().sum().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "a08cd664-702f-476e-be5b-a366a051c46d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Observation</th>\n",
       "      <th>Y-Kappa</th>\n",
       "      <th>ChipRate</th>\n",
       "      <th>BF-CMratio</th>\n",
       "      <th>BlowFlow</th>\n",
       "      <th>ChipLevel4</th>\n",
       "      <th>T-upperExt-2</th>\n",
       "      <th>T-lowerExt-2</th>\n",
       "      <th>UCZAA</th>\n",
       "      <th>WhiteFlow-4</th>\n",
       "      <th>...</th>\n",
       "      <th>SteamFlow-4</th>\n",
       "      <th>Lower-HeatT-3</th>\n",
       "      <th>Upper-HeatT-3</th>\n",
       "      <th>ChipMass-4</th>\n",
       "      <th>WeakLiquorF</th>\n",
       "      <th>BlackFlow-2</th>\n",
       "      <th>WeakWashF</th>\n",
       "      <th>SteamHeatF-3</th>\n",
       "      <th>T-Top-Chips-4</th>\n",
       "      <th>SulphidityL-4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>31-00:00</td>\n",
       "      <td>23.10</td>\n",
       "      <td>16.520</td>\n",
       "      <td>121.717</td>\n",
       "      <td>1177.607</td>\n",
       "      <td>169.805</td>\n",
       "      <td>358.282</td>\n",
       "      <td>329.545</td>\n",
       "      <td>1.443</td>\n",
       "      <td>599.253</td>\n",
       "      <td>...</td>\n",
       "      <td>67.122</td>\n",
       "      <td>329.432</td>\n",
       "      <td>303.099</td>\n",
       "      <td>175.964</td>\n",
       "      <td>1127.197</td>\n",
       "      <td>1319.039</td>\n",
       "      <td>257.325</td>\n",
       "      <td>54.612</td>\n",
       "      <td>252.077</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>31-01:00</td>\n",
       "      <td>27.60</td>\n",
       "      <td>16.810</td>\n",
       "      <td>79.022</td>\n",
       "      <td>1328.360</td>\n",
       "      <td>341.327</td>\n",
       "      <td>351.050</td>\n",
       "      <td>329.067</td>\n",
       "      <td>1.549</td>\n",
       "      <td>537.201</td>\n",
       "      <td>...</td>\n",
       "      <td>60.012</td>\n",
       "      <td>330.823</td>\n",
       "      <td>304.879</td>\n",
       "      <td>163.202</td>\n",
       "      <td>665.975</td>\n",
       "      <td>1297.317</td>\n",
       "      <td>241.182</td>\n",
       "      <td>46.603</td>\n",
       "      <td>251.406</td>\n",
       "      <td>29.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>31-02:00</td>\n",
       "      <td>23.19</td>\n",
       "      <td>16.709</td>\n",
       "      <td>79.562</td>\n",
       "      <td>1329.407</td>\n",
       "      <td>239.161</td>\n",
       "      <td>350.022</td>\n",
       "      <td>329.260</td>\n",
       "      <td>1.600</td>\n",
       "      <td>549.611</td>\n",
       "      <td>...</td>\n",
       "      <td>61.304</td>\n",
       "      <td>329.140</td>\n",
       "      <td>303.383</td>\n",
       "      <td>164.013</td>\n",
       "      <td>677.534</td>\n",
       "      <td>1327.072</td>\n",
       "      <td>237.272</td>\n",
       "      <td>51.795</td>\n",
       "      <td>251.335</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>31-03:00</td>\n",
       "      <td>23.60</td>\n",
       "      <td>16.478</td>\n",
       "      <td>81.011</td>\n",
       "      <td>1334.877</td>\n",
       "      <td>213.527</td>\n",
       "      <td>350.938</td>\n",
       "      <td>331.142</td>\n",
       "      <td>1.604</td>\n",
       "      <td>623.362</td>\n",
       "      <td>...</td>\n",
       "      <td>68.496</td>\n",
       "      <td>328.875</td>\n",
       "      <td>302.254</td>\n",
       "      <td>181.487</td>\n",
       "      <td>767.853</td>\n",
       "      <td>1324.461</td>\n",
       "      <td>239.478</td>\n",
       "      <td>54.846</td>\n",
       "      <td>250.312</td>\n",
       "      <td>29.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>31-04:00</td>\n",
       "      <td>22.90</td>\n",
       "      <td>15.618</td>\n",
       "      <td>93.244</td>\n",
       "      <td>1334.168</td>\n",
       "      <td>243.131</td>\n",
       "      <td>351.640</td>\n",
       "      <td>332.709</td>\n",
       "      <td>0.000</td>\n",
       "      <td>638.672</td>\n",
       "      <td>...</td>\n",
       "      <td>70.022</td>\n",
       "      <td>328.352</td>\n",
       "      <td>300.954</td>\n",
       "      <td>183.929</td>\n",
       "      <td>888.448</td>\n",
       "      <td>1343.424</td>\n",
       "      <td>215.372</td>\n",
       "      <td>54.186</td>\n",
       "      <td>249.916</td>\n",
       "      <td>29.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>12-09:00</td>\n",
       "      <td>20.90</td>\n",
       "      <td>15.167</td>\n",
       "      <td>84.640</td>\n",
       "      <td>1283.706</td>\n",
       "      <td>339.440</td>\n",
       "      <td>354.803</td>\n",
       "      <td>311.041</td>\n",
       "      <td>1.635</td>\n",
       "      <td>532.419</td>\n",
       "      <td>...</td>\n",
       "      <td>65.561</td>\n",
       "      <td>332.924</td>\n",
       "      <td>307.626</td>\n",
       "      <td>145.299</td>\n",
       "      <td>832.906</td>\n",
       "      <td>1344.708</td>\n",
       "      <td>388.911</td>\n",
       "      <td>49.524</td>\n",
       "      <td>251.833</td>\n",
       "      <td>30.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>12-10:00</td>\n",
       "      <td>24.98</td>\n",
       "      <td>0.000</td>\n",
       "      <td>85.034</td>\n",
       "      <td>1278.345</td>\n",
       "      <td>368.564</td>\n",
       "      <td>357.723</td>\n",
       "      <td>321.387</td>\n",
       "      <td>0.000</td>\n",
       "      <td>520.365</td>\n",
       "      <td>...</td>\n",
       "      <td>65.729</td>\n",
       "      <td>332.523</td>\n",
       "      <td>307.169</td>\n",
       "      <td>151.544</td>\n",
       "      <td>905.639</td>\n",
       "      <td>1344.469</td>\n",
       "      <td>418.979</td>\n",
       "      <td>48.135</td>\n",
       "      <td>251.614</td>\n",
       "      <td>30.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300</th>\n",
       "      <td>12-11:00</td>\n",
       "      <td>21.00</td>\n",
       "      <td>0.000</td>\n",
       "      <td>88.013</td>\n",
       "      <td>1307.722</td>\n",
       "      <td>278.842</td>\n",
       "      <td>357.438</td>\n",
       "      <td>323.757</td>\n",
       "      <td>0.000</td>\n",
       "      <td>553.070</td>\n",
       "      <td>...</td>\n",
       "      <td>65.795</td>\n",
       "      <td>331.263</td>\n",
       "      <td>306.400</td>\n",
       "      <td>157.954</td>\n",
       "      <td>908.691</td>\n",
       "      <td>1344.588</td>\n",
       "      <td>462.712</td>\n",
       "      <td>54.373</td>\n",
       "      <td>251.197</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>12-12:00</td>\n",
       "      <td>21.40</td>\n",
       "      <td>0.000</td>\n",
       "      <td>85.490</td>\n",
       "      <td>1255.986</td>\n",
       "      <td>273.484</td>\n",
       "      <td>361.365</td>\n",
       "      <td>322.689</td>\n",
       "      <td>0.000</td>\n",
       "      <td>590.199</td>\n",
       "      <td>...</td>\n",
       "      <td>71.456</td>\n",
       "      <td>333.032</td>\n",
       "      <td>308.732</td>\n",
       "      <td>174.069</td>\n",
       "      <td>986.206</td>\n",
       "      <td>1348.747</td>\n",
       "      <td>457.313</td>\n",
       "      <td>53.194</td>\n",
       "      <td>251.324</td>\n",
       "      <td>30.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>307</th>\n",
       "      <td>31-05:00</td>\n",
       "      <td>20.89</td>\n",
       "      <td>14.308</td>\n",
       "      <td>94.172</td>\n",
       "      <td>1327.832</td>\n",
       "      <td>251.120</td>\n",
       "      <td>351.263</td>\n",
       "      <td>332.485</td>\n",
       "      <td>1.522</td>\n",
       "      <td>631.514</td>\n",
       "      <td>...</td>\n",
       "      <td>71.286</td>\n",
       "      <td>328.699</td>\n",
       "      <td>300.706</td>\n",
       "      <td>180.229</td>\n",
       "      <td>903.605</td>\n",
       "      <td>1323.082</td>\n",
       "      <td>232.729</td>\n",
       "      <td>54.503</td>\n",
       "      <td>250.084</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>301 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Observation  Y-Kappa  ChipRate  BF-CMratio  BlowFlow  ChipLevel4   \\\n",
       "0      31-00:00    23.10    16.520     121.717  1177.607      169.805   \n",
       "1      31-01:00    27.60    16.810      79.022  1328.360      341.327   \n",
       "2      31-02:00    23.19    16.709      79.562  1329.407      239.161   \n",
       "3      31-03:00    23.60    16.478      81.011  1334.877      213.527   \n",
       "4      31-04:00    22.90    15.618      93.244  1334.168      243.131   \n",
       "..          ...      ...       ...         ...       ...          ...   \n",
       "298    12-09:00    20.90    15.167      84.640  1283.706      339.440   \n",
       "299    12-10:00    24.98     0.000      85.034  1278.345      368.564   \n",
       "300    12-11:00    21.00     0.000      88.013  1307.722      278.842   \n",
       "301    12-12:00    21.40     0.000      85.490  1255.986      273.484   \n",
       "307    31-05:00    20.89    14.308      94.172  1327.832      251.120   \n",
       "\n",
       "     T-upperExt-2   T-lowerExt-2    UCZAA  WhiteFlow-4   ...  SteamFlow-4   \\\n",
       "0          358.282         329.545  1.443       599.253  ...        67.122   \n",
       "1          351.050         329.067  1.549       537.201  ...        60.012   \n",
       "2          350.022         329.260  1.600       549.611  ...        61.304   \n",
       "3          350.938         331.142  1.604       623.362  ...        68.496   \n",
       "4          351.640         332.709  0.000       638.672  ...        70.022   \n",
       "..             ...             ...    ...           ...  ...           ...   \n",
       "298        354.803         311.041  1.635       532.419  ...        65.561   \n",
       "299        357.723         321.387  0.000       520.365  ...        65.729   \n",
       "300        357.438         323.757  0.000       553.070  ...        65.795   \n",
       "301        361.365         322.689  0.000       590.199  ...        71.456   \n",
       "307        351.263         332.485  1.522       631.514  ...        71.286   \n",
       "\n",
       "     Lower-HeatT-3  Upper-HeatT-3   ChipMass-4   WeakLiquorF   BlackFlow-2   \\\n",
       "0          329.432         303.099      175.964      1127.197      1319.039   \n",
       "1          330.823         304.879      163.202       665.975      1297.317   \n",
       "2          329.140         303.383      164.013       677.534      1327.072   \n",
       "3          328.875         302.254      181.487       767.853      1324.461   \n",
       "4          328.352         300.954      183.929       888.448      1343.424   \n",
       "..             ...             ...          ...           ...           ...   \n",
       "298        332.924         307.626      145.299       832.906      1344.708   \n",
       "299        332.523         307.169      151.544       905.639      1344.469   \n",
       "300        331.263         306.400      157.954       908.691      1344.588   \n",
       "301        333.032         308.732      174.069       986.206      1348.747   \n",
       "307        328.699         300.706      180.229       903.605      1323.082   \n",
       "\n",
       "     WeakWashF   SteamHeatF-3   T-Top-Chips-4   SulphidityL-4   \n",
       "0       257.325         54.612         252.077            0.00  \n",
       "1       241.182         46.603         251.406           29.11  \n",
       "2       237.272         51.795         251.335            0.00  \n",
       "3       239.478         54.846         250.312           29.02  \n",
       "4       215.372         54.186         249.916           29.01  \n",
       "..          ...            ...             ...             ...  \n",
       "298     388.911         49.524         251.833           30.29  \n",
       "299     418.979         48.135         251.614           30.47  \n",
       "300     462.712         54.373         251.197            0.00  \n",
       "301     457.313         53.194         251.324           30.46  \n",
       "307     232.729         54.503         250.084            0.00  \n",
       "\n",
       "[301 rows x 23 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data1=data.fillna(value=0)\n",
    "data1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "e14a6df0-dbaf-4a7d-82a0-842a97107739",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data1.isnull().sum().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "094e9cd8-8cd7-404f-b9a8-af9a1cd6bd47",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Observation</th>\n",
       "      <th>Y-Kappa</th>\n",
       "      <th>ChipRate</th>\n",
       "      <th>BF-CMratio</th>\n",
       "      <th>BlowFlow</th>\n",
       "      <th>ChipLevel4</th>\n",
       "      <th>T-upperExt-2</th>\n",
       "      <th>T-lowerExt-2</th>\n",
       "      <th>UCZAA</th>\n",
       "      <th>WhiteFlow-4</th>\n",
       "      <th>...</th>\n",
       "      <th>SteamFlow-4</th>\n",
       "      <th>Lower-HeatT-3</th>\n",
       "      <th>Upper-HeatT-3</th>\n",
       "      <th>ChipMass-4</th>\n",
       "      <th>WeakLiquorF</th>\n",
       "      <th>BlackFlow-2</th>\n",
       "      <th>WeakWashF</th>\n",
       "      <th>SteamHeatF-3</th>\n",
       "      <th>T-Top-Chips-4</th>\n",
       "      <th>SulphidityL-4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>31-00:00</td>\n",
       "      <td>23.10</td>\n",
       "      <td>16.520</td>\n",
       "      <td>121.717</td>\n",
       "      <td>1177.607</td>\n",
       "      <td>169.805</td>\n",
       "      <td>358.282</td>\n",
       "      <td>329.545</td>\n",
       "      <td>1.443</td>\n",
       "      <td>599.253</td>\n",
       "      <td>...</td>\n",
       "      <td>67.122</td>\n",
       "      <td>329.432</td>\n",
       "      <td>303.099</td>\n",
       "      <td>175.964</td>\n",
       "      <td>1127.197</td>\n",
       "      <td>1319.039</td>\n",
       "      <td>257.325</td>\n",
       "      <td>54.612</td>\n",
       "      <td>252.077</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>31-01:00</td>\n",
       "      <td>27.60</td>\n",
       "      <td>16.810</td>\n",
       "      <td>79.022</td>\n",
       "      <td>1328.360</td>\n",
       "      <td>341.327</td>\n",
       "      <td>351.050</td>\n",
       "      <td>329.067</td>\n",
       "      <td>1.549</td>\n",
       "      <td>537.201</td>\n",
       "      <td>...</td>\n",
       "      <td>60.012</td>\n",
       "      <td>330.823</td>\n",
       "      <td>304.879</td>\n",
       "      <td>163.202</td>\n",
       "      <td>665.975</td>\n",
       "      <td>1297.317</td>\n",
       "      <td>241.182</td>\n",
       "      <td>46.603</td>\n",
       "      <td>251.406</td>\n",
       "      <td>29.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>31-02:00</td>\n",
       "      <td>23.19</td>\n",
       "      <td>16.709</td>\n",
       "      <td>79.562</td>\n",
       "      <td>1329.407</td>\n",
       "      <td>239.161</td>\n",
       "      <td>350.022</td>\n",
       "      <td>329.260</td>\n",
       "      <td>1.600</td>\n",
       "      <td>549.611</td>\n",
       "      <td>...</td>\n",
       "      <td>61.304</td>\n",
       "      <td>329.140</td>\n",
       "      <td>303.383</td>\n",
       "      <td>164.013</td>\n",
       "      <td>677.534</td>\n",
       "      <td>1327.072</td>\n",
       "      <td>237.272</td>\n",
       "      <td>51.795</td>\n",
       "      <td>251.335</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>31-03:00</td>\n",
       "      <td>23.60</td>\n",
       "      <td>16.478</td>\n",
       "      <td>81.011</td>\n",
       "      <td>1334.877</td>\n",
       "      <td>213.527</td>\n",
       "      <td>350.938</td>\n",
       "      <td>331.142</td>\n",
       "      <td>1.604</td>\n",
       "      <td>623.362</td>\n",
       "      <td>...</td>\n",
       "      <td>68.496</td>\n",
       "      <td>328.875</td>\n",
       "      <td>302.254</td>\n",
       "      <td>181.487</td>\n",
       "      <td>767.853</td>\n",
       "      <td>1324.461</td>\n",
       "      <td>239.478</td>\n",
       "      <td>54.846</td>\n",
       "      <td>250.312</td>\n",
       "      <td>29.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>31-04:00</td>\n",
       "      <td>22.90</td>\n",
       "      <td>15.618</td>\n",
       "      <td>93.244</td>\n",
       "      <td>1334.168</td>\n",
       "      <td>243.131</td>\n",
       "      <td>351.640</td>\n",
       "      <td>332.709</td>\n",
       "      <td>NaN</td>\n",
       "      <td>638.672</td>\n",
       "      <td>...</td>\n",
       "      <td>70.022</td>\n",
       "      <td>328.352</td>\n",
       "      <td>300.954</td>\n",
       "      <td>183.929</td>\n",
       "      <td>888.448</td>\n",
       "      <td>1343.424</td>\n",
       "      <td>215.372</td>\n",
       "      <td>54.186</td>\n",
       "      <td>249.916</td>\n",
       "      <td>29.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>12-09:00</td>\n",
       "      <td>20.90</td>\n",
       "      <td>15.167</td>\n",
       "      <td>84.640</td>\n",
       "      <td>1283.706</td>\n",
       "      <td>339.440</td>\n",
       "      <td>354.803</td>\n",
       "      <td>311.041</td>\n",
       "      <td>1.635</td>\n",
       "      <td>532.419</td>\n",
       "      <td>...</td>\n",
       "      <td>65.561</td>\n",
       "      <td>332.924</td>\n",
       "      <td>307.626</td>\n",
       "      <td>145.299</td>\n",
       "      <td>832.906</td>\n",
       "      <td>1344.708</td>\n",
       "      <td>388.911</td>\n",
       "      <td>49.524</td>\n",
       "      <td>251.833</td>\n",
       "      <td>30.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>12-10:00</td>\n",
       "      <td>24.98</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85.034</td>\n",
       "      <td>1278.345</td>\n",
       "      <td>368.564</td>\n",
       "      <td>357.723</td>\n",
       "      <td>321.387</td>\n",
       "      <td>NaN</td>\n",
       "      <td>520.365</td>\n",
       "      <td>...</td>\n",
       "      <td>65.729</td>\n",
       "      <td>332.523</td>\n",
       "      <td>307.169</td>\n",
       "      <td>151.544</td>\n",
       "      <td>905.639</td>\n",
       "      <td>1344.469</td>\n",
       "      <td>418.979</td>\n",
       "      <td>48.135</td>\n",
       "      <td>251.614</td>\n",
       "      <td>30.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300</th>\n",
       "      <td>12-11:00</td>\n",
       "      <td>21.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88.013</td>\n",
       "      <td>1307.722</td>\n",
       "      <td>278.842</td>\n",
       "      <td>357.438</td>\n",
       "      <td>323.757</td>\n",
       "      <td>NaN</td>\n",
       "      <td>553.070</td>\n",
       "      <td>...</td>\n",
       "      <td>65.795</td>\n",
       "      <td>331.263</td>\n",
       "      <td>306.400</td>\n",
       "      <td>157.954</td>\n",
       "      <td>908.691</td>\n",
       "      <td>1344.588</td>\n",
       "      <td>462.712</td>\n",
       "      <td>54.373</td>\n",
       "      <td>251.197</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>12-12:00</td>\n",
       "      <td>21.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85.490</td>\n",
       "      <td>1255.986</td>\n",
       "      <td>273.484</td>\n",
       "      <td>361.365</td>\n",
       "      <td>322.689</td>\n",
       "      <td>NaN</td>\n",
       "      <td>590.199</td>\n",
       "      <td>...</td>\n",
       "      <td>71.456</td>\n",
       "      <td>333.032</td>\n",
       "      <td>308.732</td>\n",
       "      <td>174.069</td>\n",
       "      <td>986.206</td>\n",
       "      <td>1348.747</td>\n",
       "      <td>457.313</td>\n",
       "      <td>53.194</td>\n",
       "      <td>251.324</td>\n",
       "      <td>30.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>307</th>\n",
       "      <td>31-05:00</td>\n",
       "      <td>20.89</td>\n",
       "      <td>14.308</td>\n",
       "      <td>94.172</td>\n",
       "      <td>1327.832</td>\n",
       "      <td>251.120</td>\n",
       "      <td>351.263</td>\n",
       "      <td>332.485</td>\n",
       "      <td>1.522</td>\n",
       "      <td>631.514</td>\n",
       "      <td>...</td>\n",
       "      <td>71.286</td>\n",
       "      <td>328.699</td>\n",
       "      <td>300.706</td>\n",
       "      <td>180.229</td>\n",
       "      <td>903.605</td>\n",
       "      <td>1323.082</td>\n",
       "      <td>232.729</td>\n",
       "      <td>54.503</td>\n",
       "      <td>250.084</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>301 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Observation  Y-Kappa  ChipRate  BF-CMratio  BlowFlow  ChipLevel4   \\\n",
       "0      31-00:00    23.10    16.520     121.717  1177.607      169.805   \n",
       "1      31-01:00    27.60    16.810      79.022  1328.360      341.327   \n",
       "2      31-02:00    23.19    16.709      79.562  1329.407      239.161   \n",
       "3      31-03:00    23.60    16.478      81.011  1334.877      213.527   \n",
       "4      31-04:00    22.90    15.618      93.244  1334.168      243.131   \n",
       "..          ...      ...       ...         ...       ...          ...   \n",
       "298    12-09:00    20.90    15.167      84.640  1283.706      339.440   \n",
       "299    12-10:00    24.98       NaN      85.034  1278.345      368.564   \n",
       "300    12-11:00    21.00       NaN      88.013  1307.722      278.842   \n",
       "301    12-12:00    21.40       NaN      85.490  1255.986      273.484   \n",
       "307    31-05:00    20.89    14.308      94.172  1327.832      251.120   \n",
       "\n",
       "     T-upperExt-2   T-lowerExt-2    UCZAA  WhiteFlow-4   ...  SteamFlow-4   \\\n",
       "0          358.282         329.545  1.443       599.253  ...        67.122   \n",
       "1          351.050         329.067  1.549       537.201  ...        60.012   \n",
       "2          350.022         329.260  1.600       549.611  ...        61.304   \n",
       "3          350.938         331.142  1.604       623.362  ...        68.496   \n",
       "4          351.640         332.709    NaN       638.672  ...        70.022   \n",
       "..             ...             ...    ...           ...  ...           ...   \n",
       "298        354.803         311.041  1.635       532.419  ...        65.561   \n",
       "299        357.723         321.387    NaN       520.365  ...        65.729   \n",
       "300        357.438         323.757    NaN       553.070  ...        65.795   \n",
       "301        361.365         322.689    NaN       590.199  ...        71.456   \n",
       "307        351.263         332.485  1.522       631.514  ...        71.286   \n",
       "\n",
       "     Lower-HeatT-3  Upper-HeatT-3   ChipMass-4   WeakLiquorF   BlackFlow-2   \\\n",
       "0          329.432         303.099      175.964      1127.197      1319.039   \n",
       "1          330.823         304.879      163.202       665.975      1297.317   \n",
       "2          329.140         303.383      164.013       677.534      1327.072   \n",
       "3          328.875         302.254      181.487       767.853      1324.461   \n",
       "4          328.352         300.954      183.929       888.448      1343.424   \n",
       "..             ...             ...          ...           ...           ...   \n",
       "298        332.924         307.626      145.299       832.906      1344.708   \n",
       "299        332.523         307.169      151.544       905.639      1344.469   \n",
       "300        331.263         306.400      157.954       908.691      1344.588   \n",
       "301        333.032         308.732      174.069       986.206      1348.747   \n",
       "307        328.699         300.706      180.229       903.605      1323.082   \n",
       "\n",
       "     WeakWashF   SteamHeatF-3   T-Top-Chips-4   SulphidityL-4   \n",
       "0       257.325         54.612         252.077             NaN  \n",
       "1       241.182         46.603         251.406           29.11  \n",
       "2       237.272         51.795         251.335             NaN  \n",
       "3       239.478         54.846         250.312           29.02  \n",
       "4       215.372         54.186         249.916           29.01  \n",
       "..          ...            ...             ...             ...  \n",
       "298     388.911         49.524         251.833           30.29  \n",
       "299     418.979         48.135         251.614           30.47  \n",
       "300     462.712         54.373         251.197             NaN  \n",
       "301     457.313         53.194         251.324           30.46  \n",
       "307     232.729         54.503         250.084             NaN  \n",
       "\n",
       "[301 rows x 23 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "78b7daac-4405-4999-8d46-e94e9f189b2d",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\shanm\\AppData\\Local\\Temp\\ipykernel_10364\\1171554614.py:1: FutureWarning: DataFrame.fillna with 'method' is deprecated and will raise in a future version. Use obj.ffill() or obj.bfill() instead.\n",
      "  data2=data.fillna(method='pad')\n"
     ]
    },
    {
     "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>Observation</th>\n",
       "      <th>Y-Kappa</th>\n",
       "      <th>ChipRate</th>\n",
       "      <th>BF-CMratio</th>\n",
       "      <th>BlowFlow</th>\n",
       "      <th>ChipLevel4</th>\n",
       "      <th>T-upperExt-2</th>\n",
       "      <th>T-lowerExt-2</th>\n",
       "      <th>UCZAA</th>\n",
       "      <th>WhiteFlow-4</th>\n",
       "      <th>...</th>\n",
       "      <th>SteamFlow-4</th>\n",
       "      <th>Lower-HeatT-3</th>\n",
       "      <th>Upper-HeatT-3</th>\n",
       "      <th>ChipMass-4</th>\n",
       "      <th>WeakLiquorF</th>\n",
       "      <th>BlackFlow-2</th>\n",
       "      <th>WeakWashF</th>\n",
       "      <th>SteamHeatF-3</th>\n",
       "      <th>T-Top-Chips-4</th>\n",
       "      <th>SulphidityL-4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>31-00:00</td>\n",
       "      <td>23.10</td>\n",
       "      <td>16.520</td>\n",
       "      <td>121.717</td>\n",
       "      <td>1177.607</td>\n",
       "      <td>169.805</td>\n",
       "      <td>358.282</td>\n",
       "      <td>329.545</td>\n",
       "      <td>1.443</td>\n",
       "      <td>599.253</td>\n",
       "      <td>...</td>\n",
       "      <td>67.122</td>\n",
       "      <td>329.432</td>\n",
       "      <td>303.099</td>\n",
       "      <td>175.964</td>\n",
       "      <td>1127.197</td>\n",
       "      <td>1319.039</td>\n",
       "      <td>257.325</td>\n",
       "      <td>54.612</td>\n",
       "      <td>252.077</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>31-01:00</td>\n",
       "      <td>27.60</td>\n",
       "      <td>16.810</td>\n",
       "      <td>79.022</td>\n",
       "      <td>1328.360</td>\n",
       "      <td>341.327</td>\n",
       "      <td>351.050</td>\n",
       "      <td>329.067</td>\n",
       "      <td>1.549</td>\n",
       "      <td>537.201</td>\n",
       "      <td>...</td>\n",
       "      <td>60.012</td>\n",
       "      <td>330.823</td>\n",
       "      <td>304.879</td>\n",
       "      <td>163.202</td>\n",
       "      <td>665.975</td>\n",
       "      <td>1297.317</td>\n",
       "      <td>241.182</td>\n",
       "      <td>46.603</td>\n",
       "      <td>251.406</td>\n",
       "      <td>29.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>31-02:00</td>\n",
       "      <td>23.19</td>\n",
       "      <td>16.709</td>\n",
       "      <td>79.562</td>\n",
       "      <td>1329.407</td>\n",
       "      <td>239.161</td>\n",
       "      <td>350.022</td>\n",
       "      <td>329.260</td>\n",
       "      <td>1.600</td>\n",
       "      <td>549.611</td>\n",
       "      <td>...</td>\n",
       "      <td>61.304</td>\n",
       "      <td>329.140</td>\n",
       "      <td>303.383</td>\n",
       "      <td>164.013</td>\n",
       "      <td>677.534</td>\n",
       "      <td>1327.072</td>\n",
       "      <td>237.272</td>\n",
       "      <td>51.795</td>\n",
       "      <td>251.335</td>\n",
       "      <td>29.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>31-03:00</td>\n",
       "      <td>23.60</td>\n",
       "      <td>16.478</td>\n",
       "      <td>81.011</td>\n",
       "      <td>1334.877</td>\n",
       "      <td>213.527</td>\n",
       "      <td>350.938</td>\n",
       "      <td>331.142</td>\n",
       "      <td>1.604</td>\n",
       "      <td>623.362</td>\n",
       "      <td>...</td>\n",
       "      <td>68.496</td>\n",
       "      <td>328.875</td>\n",
       "      <td>302.254</td>\n",
       "      <td>181.487</td>\n",
       "      <td>767.853</td>\n",
       "      <td>1324.461</td>\n",
       "      <td>239.478</td>\n",
       "      <td>54.846</td>\n",
       "      <td>250.312</td>\n",
       "      <td>29.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>31-04:00</td>\n",
       "      <td>22.90</td>\n",
       "      <td>15.618</td>\n",
       "      <td>93.244</td>\n",
       "      <td>1334.168</td>\n",
       "      <td>243.131</td>\n",
       "      <td>351.640</td>\n",
       "      <td>332.709</td>\n",
       "      <td>1.604</td>\n",
       "      <td>638.672</td>\n",
       "      <td>...</td>\n",
       "      <td>70.022</td>\n",
       "      <td>328.352</td>\n",
       "      <td>300.954</td>\n",
       "      <td>183.929</td>\n",
       "      <td>888.448</td>\n",
       "      <td>1343.424</td>\n",
       "      <td>215.372</td>\n",
       "      <td>54.186</td>\n",
       "      <td>249.916</td>\n",
       "      <td>29.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>12-09:00</td>\n",
       "      <td>20.90</td>\n",
       "      <td>15.167</td>\n",
       "      <td>84.640</td>\n",
       "      <td>1283.706</td>\n",
       "      <td>339.440</td>\n",
       "      <td>354.803</td>\n",
       "      <td>311.041</td>\n",
       "      <td>1.635</td>\n",
       "      <td>532.419</td>\n",
       "      <td>...</td>\n",
       "      <td>65.561</td>\n",
       "      <td>332.924</td>\n",
       "      <td>307.626</td>\n",
       "      <td>145.299</td>\n",
       "      <td>832.906</td>\n",
       "      <td>1344.708</td>\n",
       "      <td>388.911</td>\n",
       "      <td>49.524</td>\n",
       "      <td>251.833</td>\n",
       "      <td>30.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>12-10:00</td>\n",
       "      <td>24.98</td>\n",
       "      <td>15.167</td>\n",
       "      <td>85.034</td>\n",
       "      <td>1278.345</td>\n",
       "      <td>368.564</td>\n",
       "      <td>357.723</td>\n",
       "      <td>321.387</td>\n",
       "      <td>1.635</td>\n",
       "      <td>520.365</td>\n",
       "      <td>...</td>\n",
       "      <td>65.729</td>\n",
       "      <td>332.523</td>\n",
       "      <td>307.169</td>\n",
       "      <td>151.544</td>\n",
       "      <td>905.639</td>\n",
       "      <td>1344.469</td>\n",
       "      <td>418.979</td>\n",
       "      <td>48.135</td>\n",
       "      <td>251.614</td>\n",
       "      <td>30.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300</th>\n",
       "      <td>12-11:00</td>\n",
       "      <td>21.00</td>\n",
       "      <td>15.167</td>\n",
       "      <td>88.013</td>\n",
       "      <td>1307.722</td>\n",
       "      <td>278.842</td>\n",
       "      <td>357.438</td>\n",
       "      <td>323.757</td>\n",
       "      <td>1.635</td>\n",
       "      <td>553.070</td>\n",
       "      <td>...</td>\n",
       "      <td>65.795</td>\n",
       "      <td>331.263</td>\n",
       "      <td>306.400</td>\n",
       "      <td>157.954</td>\n",
       "      <td>908.691</td>\n",
       "      <td>1344.588</td>\n",
       "      <td>462.712</td>\n",
       "      <td>54.373</td>\n",
       "      <td>251.197</td>\n",
       "      <td>30.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>12-12:00</td>\n",
       "      <td>21.40</td>\n",
       "      <td>15.167</td>\n",
       "      <td>85.490</td>\n",
       "      <td>1255.986</td>\n",
       "      <td>273.484</td>\n",
       "      <td>361.365</td>\n",
       "      <td>322.689</td>\n",
       "      <td>1.635</td>\n",
       "      <td>590.199</td>\n",
       "      <td>...</td>\n",
       "      <td>71.456</td>\n",
       "      <td>333.032</td>\n",
       "      <td>308.732</td>\n",
       "      <td>174.069</td>\n",
       "      <td>986.206</td>\n",
       "      <td>1348.747</td>\n",
       "      <td>457.313</td>\n",
       "      <td>53.194</td>\n",
       "      <td>251.324</td>\n",
       "      <td>30.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>307</th>\n",
       "      <td>31-05:00</td>\n",
       "      <td>20.89</td>\n",
       "      <td>14.308</td>\n",
       "      <td>94.172</td>\n",
       "      <td>1327.832</td>\n",
       "      <td>251.120</td>\n",
       "      <td>351.263</td>\n",
       "      <td>332.485</td>\n",
       "      <td>1.522</td>\n",
       "      <td>631.514</td>\n",
       "      <td>...</td>\n",
       "      <td>71.286</td>\n",
       "      <td>328.699</td>\n",
       "      <td>300.706</td>\n",
       "      <td>180.229</td>\n",
       "      <td>903.605</td>\n",
       "      <td>1323.082</td>\n",
       "      <td>232.729</td>\n",
       "      <td>54.503</td>\n",
       "      <td>250.084</td>\n",
       "      <td>30.46</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>301 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Observation  Y-Kappa  ChipRate  BF-CMratio  BlowFlow  ChipLevel4   \\\n",
       "0      31-00:00    23.10    16.520     121.717  1177.607      169.805   \n",
       "1      31-01:00    27.60    16.810      79.022  1328.360      341.327   \n",
       "2      31-02:00    23.19    16.709      79.562  1329.407      239.161   \n",
       "3      31-03:00    23.60    16.478      81.011  1334.877      213.527   \n",
       "4      31-04:00    22.90    15.618      93.244  1334.168      243.131   \n",
       "..          ...      ...       ...         ...       ...          ...   \n",
       "298    12-09:00    20.90    15.167      84.640  1283.706      339.440   \n",
       "299    12-10:00    24.98    15.167      85.034  1278.345      368.564   \n",
       "300    12-11:00    21.00    15.167      88.013  1307.722      278.842   \n",
       "301    12-12:00    21.40    15.167      85.490  1255.986      273.484   \n",
       "307    31-05:00    20.89    14.308      94.172  1327.832      251.120   \n",
       "\n",
       "     T-upperExt-2   T-lowerExt-2    UCZAA  WhiteFlow-4   ...  SteamFlow-4   \\\n",
       "0          358.282         329.545  1.443       599.253  ...        67.122   \n",
       "1          351.050         329.067  1.549       537.201  ...        60.012   \n",
       "2          350.022         329.260  1.600       549.611  ...        61.304   \n",
       "3          350.938         331.142  1.604       623.362  ...        68.496   \n",
       "4          351.640         332.709  1.604       638.672  ...        70.022   \n",
       "..             ...             ...    ...           ...  ...           ...   \n",
       "298        354.803         311.041  1.635       532.419  ...        65.561   \n",
       "299        357.723         321.387  1.635       520.365  ...        65.729   \n",
       "300        357.438         323.757  1.635       553.070  ...        65.795   \n",
       "301        361.365         322.689  1.635       590.199  ...        71.456   \n",
       "307        351.263         332.485  1.522       631.514  ...        71.286   \n",
       "\n",
       "     Lower-HeatT-3  Upper-HeatT-3   ChipMass-4   WeakLiquorF   BlackFlow-2   \\\n",
       "0          329.432         303.099      175.964      1127.197      1319.039   \n",
       "1          330.823         304.879      163.202       665.975      1297.317   \n",
       "2          329.140         303.383      164.013       677.534      1327.072   \n",
       "3          328.875         302.254      181.487       767.853      1324.461   \n",
       "4          328.352         300.954      183.929       888.448      1343.424   \n",
       "..             ...             ...          ...           ...           ...   \n",
       "298        332.924         307.626      145.299       832.906      1344.708   \n",
       "299        332.523         307.169      151.544       905.639      1344.469   \n",
       "300        331.263         306.400      157.954       908.691      1344.588   \n",
       "301        333.032         308.732      174.069       986.206      1348.747   \n",
       "307        328.699         300.706      180.229       903.605      1323.082   \n",
       "\n",
       "     WeakWashF   SteamHeatF-3   T-Top-Chips-4   SulphidityL-4   \n",
       "0       257.325         54.612         252.077             NaN  \n",
       "1       241.182         46.603         251.406           29.11  \n",
       "2       237.272         51.795         251.335           29.11  \n",
       "3       239.478         54.846         250.312           29.02  \n",
       "4       215.372         54.186         249.916           29.01  \n",
       "..          ...            ...             ...             ...  \n",
       "298     388.911         49.524         251.833           30.29  \n",
       "299     418.979         48.135         251.614           30.47  \n",
       "300     462.712         54.373         251.197           30.47  \n",
       "301     457.313         53.194         251.324           30.46  \n",
       "307     232.729         54.503         250.084           30.46  \n",
       "\n",
       "[301 rows x 23 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data2=data.fillna(method='pad')\n",
    "data2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "b528d8af-e42a-485a-8ec3-7843f068d4c1",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\shanm\\AppData\\Local\\Temp\\ipykernel_10364\\3254375401.py:1: FutureWarning: DataFrame.fillna with 'method' is deprecated and will raise in a future version. Use obj.ffill() or obj.bfill() instead.\n",
      "  data3=data.fillna(method='bfill')\n"
     ]
    },
    {
     "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>Observation</th>\n",
       "      <th>Y-Kappa</th>\n",
       "      <th>ChipRate</th>\n",
       "      <th>BF-CMratio</th>\n",
       "      <th>BlowFlow</th>\n",
       "      <th>ChipLevel4</th>\n",
       "      <th>T-upperExt-2</th>\n",
       "      <th>T-lowerExt-2</th>\n",
       "      <th>UCZAA</th>\n",
       "      <th>WhiteFlow-4</th>\n",
       "      <th>...</th>\n",
       "      <th>SteamFlow-4</th>\n",
       "      <th>Lower-HeatT-3</th>\n",
       "      <th>Upper-HeatT-3</th>\n",
       "      <th>ChipMass-4</th>\n",
       "      <th>WeakLiquorF</th>\n",
       "      <th>BlackFlow-2</th>\n",
       "      <th>WeakWashF</th>\n",
       "      <th>SteamHeatF-3</th>\n",
       "      <th>T-Top-Chips-4</th>\n",
       "      <th>SulphidityL-4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>31-00:00</td>\n",
       "      <td>23.10</td>\n",
       "      <td>16.520</td>\n",
       "      <td>121.717</td>\n",
       "      <td>1177.607</td>\n",
       "      <td>169.805</td>\n",
       "      <td>358.282</td>\n",
       "      <td>329.545</td>\n",
       "      <td>1.443</td>\n",
       "      <td>599.253</td>\n",
       "      <td>...</td>\n",
       "      <td>67.122</td>\n",
       "      <td>329.432</td>\n",
       "      <td>303.099</td>\n",
       "      <td>175.964</td>\n",
       "      <td>1127.197</td>\n",
       "      <td>1319.039</td>\n",
       "      <td>257.325</td>\n",
       "      <td>54.612</td>\n",
       "      <td>252.077</td>\n",
       "      <td>29.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>31-01:00</td>\n",
       "      <td>27.60</td>\n",
       "      <td>16.810</td>\n",
       "      <td>79.022</td>\n",
       "      <td>1328.360</td>\n",
       "      <td>341.327</td>\n",
       "      <td>351.050</td>\n",
       "      <td>329.067</td>\n",
       "      <td>1.549</td>\n",
       "      <td>537.201</td>\n",
       "      <td>...</td>\n",
       "      <td>60.012</td>\n",
       "      <td>330.823</td>\n",
       "      <td>304.879</td>\n",
       "      <td>163.202</td>\n",
       "      <td>665.975</td>\n",
       "      <td>1297.317</td>\n",
       "      <td>241.182</td>\n",
       "      <td>46.603</td>\n",
       "      <td>251.406</td>\n",
       "      <td>29.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>31-02:00</td>\n",
       "      <td>23.19</td>\n",
       "      <td>16.709</td>\n",
       "      <td>79.562</td>\n",
       "      <td>1329.407</td>\n",
       "      <td>239.161</td>\n",
       "      <td>350.022</td>\n",
       "      <td>329.260</td>\n",
       "      <td>1.600</td>\n",
       "      <td>549.611</td>\n",
       "      <td>...</td>\n",
       "      <td>61.304</td>\n",
       "      <td>329.140</td>\n",
       "      <td>303.383</td>\n",
       "      <td>164.013</td>\n",
       "      <td>677.534</td>\n",
       "      <td>1327.072</td>\n",
       "      <td>237.272</td>\n",
       "      <td>51.795</td>\n",
       "      <td>251.335</td>\n",
       "      <td>29.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>31-03:00</td>\n",
       "      <td>23.60</td>\n",
       "      <td>16.478</td>\n",
       "      <td>81.011</td>\n",
       "      <td>1334.877</td>\n",
       "      <td>213.527</td>\n",
       "      <td>350.938</td>\n",
       "      <td>331.142</td>\n",
       "      <td>1.604</td>\n",
       "      <td>623.362</td>\n",
       "      <td>...</td>\n",
       "      <td>68.496</td>\n",
       "      <td>328.875</td>\n",
       "      <td>302.254</td>\n",
       "      <td>181.487</td>\n",
       "      <td>767.853</td>\n",
       "      <td>1324.461</td>\n",
       "      <td>239.478</td>\n",
       "      <td>54.846</td>\n",
       "      <td>250.312</td>\n",
       "      <td>29.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>31-04:00</td>\n",
       "      <td>22.90</td>\n",
       "      <td>15.618</td>\n",
       "      <td>93.244</td>\n",
       "      <td>1334.168</td>\n",
       "      <td>243.131</td>\n",
       "      <td>351.640</td>\n",
       "      <td>332.709</td>\n",
       "      <td>1.436</td>\n",
       "      <td>638.672</td>\n",
       "      <td>...</td>\n",
       "      <td>70.022</td>\n",
       "      <td>328.352</td>\n",
       "      <td>300.954</td>\n",
       "      <td>183.929</td>\n",
       "      <td>888.448</td>\n",
       "      <td>1343.424</td>\n",
       "      <td>215.372</td>\n",
       "      <td>54.186</td>\n",
       "      <td>249.916</td>\n",
       "      <td>29.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>12-09:00</td>\n",
       "      <td>20.90</td>\n",
       "      <td>15.167</td>\n",
       "      <td>84.640</td>\n",
       "      <td>1283.706</td>\n",
       "      <td>339.440</td>\n",
       "      <td>354.803</td>\n",
       "      <td>311.041</td>\n",
       "      <td>1.635</td>\n",
       "      <td>532.419</td>\n",
       "      <td>...</td>\n",
       "      <td>65.561</td>\n",
       "      <td>332.924</td>\n",
       "      <td>307.626</td>\n",
       "      <td>145.299</td>\n",
       "      <td>832.906</td>\n",
       "      <td>1344.708</td>\n",
       "      <td>388.911</td>\n",
       "      <td>49.524</td>\n",
       "      <td>251.833</td>\n",
       "      <td>30.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>12-10:00</td>\n",
       "      <td>24.98</td>\n",
       "      <td>14.308</td>\n",
       "      <td>85.034</td>\n",
       "      <td>1278.345</td>\n",
       "      <td>368.564</td>\n",
       "      <td>357.723</td>\n",
       "      <td>321.387</td>\n",
       "      <td>1.522</td>\n",
       "      <td>520.365</td>\n",
       "      <td>...</td>\n",
       "      <td>65.729</td>\n",
       "      <td>332.523</td>\n",
       "      <td>307.169</td>\n",
       "      <td>151.544</td>\n",
       "      <td>905.639</td>\n",
       "      <td>1344.469</td>\n",
       "      <td>418.979</td>\n",
       "      <td>48.135</td>\n",
       "      <td>251.614</td>\n",
       "      <td>30.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300</th>\n",
       "      <td>12-11:00</td>\n",
       "      <td>21.00</td>\n",
       "      <td>14.308</td>\n",
       "      <td>88.013</td>\n",
       "      <td>1307.722</td>\n",
       "      <td>278.842</td>\n",
       "      <td>357.438</td>\n",
       "      <td>323.757</td>\n",
       "      <td>1.522</td>\n",
       "      <td>553.070</td>\n",
       "      <td>...</td>\n",
       "      <td>65.795</td>\n",
       "      <td>331.263</td>\n",
       "      <td>306.400</td>\n",
       "      <td>157.954</td>\n",
       "      <td>908.691</td>\n",
       "      <td>1344.588</td>\n",
       "      <td>462.712</td>\n",
       "      <td>54.373</td>\n",
       "      <td>251.197</td>\n",
       "      <td>30.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>12-12:00</td>\n",
       "      <td>21.40</td>\n",
       "      <td>14.308</td>\n",
       "      <td>85.490</td>\n",
       "      <td>1255.986</td>\n",
       "      <td>273.484</td>\n",
       "      <td>361.365</td>\n",
       "      <td>322.689</td>\n",
       "      <td>1.522</td>\n",
       "      <td>590.199</td>\n",
       "      <td>...</td>\n",
       "      <td>71.456</td>\n",
       "      <td>333.032</td>\n",
       "      <td>308.732</td>\n",
       "      <td>174.069</td>\n",
       "      <td>986.206</td>\n",
       "      <td>1348.747</td>\n",
       "      <td>457.313</td>\n",
       "      <td>53.194</td>\n",
       "      <td>251.324</td>\n",
       "      <td>30.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>307</th>\n",
       "      <td>31-05:00</td>\n",
       "      <td>20.89</td>\n",
       "      <td>14.308</td>\n",
       "      <td>94.172</td>\n",
       "      <td>1327.832</td>\n",
       "      <td>251.120</td>\n",
       "      <td>351.263</td>\n",
       "      <td>332.485</td>\n",
       "      <td>1.522</td>\n",
       "      <td>631.514</td>\n",
       "      <td>...</td>\n",
       "      <td>71.286</td>\n",
       "      <td>328.699</td>\n",
       "      <td>300.706</td>\n",
       "      <td>180.229</td>\n",
       "      <td>903.605</td>\n",
       "      <td>1323.082</td>\n",
       "      <td>232.729</td>\n",
       "      <td>54.503</td>\n",
       "      <td>250.084</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>301 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Observation  Y-Kappa  ChipRate  BF-CMratio  BlowFlow  ChipLevel4   \\\n",
       "0      31-00:00    23.10    16.520     121.717  1177.607      169.805   \n",
       "1      31-01:00    27.60    16.810      79.022  1328.360      341.327   \n",
       "2      31-02:00    23.19    16.709      79.562  1329.407      239.161   \n",
       "3      31-03:00    23.60    16.478      81.011  1334.877      213.527   \n",
       "4      31-04:00    22.90    15.618      93.244  1334.168      243.131   \n",
       "..          ...      ...       ...         ...       ...          ...   \n",
       "298    12-09:00    20.90    15.167      84.640  1283.706      339.440   \n",
       "299    12-10:00    24.98    14.308      85.034  1278.345      368.564   \n",
       "300    12-11:00    21.00    14.308      88.013  1307.722      278.842   \n",
       "301    12-12:00    21.40    14.308      85.490  1255.986      273.484   \n",
       "307    31-05:00    20.89    14.308      94.172  1327.832      251.120   \n",
       "\n",
       "     T-upperExt-2   T-lowerExt-2    UCZAA  WhiteFlow-4   ...  SteamFlow-4   \\\n",
       "0          358.282         329.545  1.443       599.253  ...        67.122   \n",
       "1          351.050         329.067  1.549       537.201  ...        60.012   \n",
       "2          350.022         329.260  1.600       549.611  ...        61.304   \n",
       "3          350.938         331.142  1.604       623.362  ...        68.496   \n",
       "4          351.640         332.709  1.436       638.672  ...        70.022   \n",
       "..             ...             ...    ...           ...  ...           ...   \n",
       "298        354.803         311.041  1.635       532.419  ...        65.561   \n",
       "299        357.723         321.387  1.522       520.365  ...        65.729   \n",
       "300        357.438         323.757  1.522       553.070  ...        65.795   \n",
       "301        361.365         322.689  1.522       590.199  ...        71.456   \n",
       "307        351.263         332.485  1.522       631.514  ...        71.286   \n",
       "\n",
       "     Lower-HeatT-3  Upper-HeatT-3   ChipMass-4   WeakLiquorF   BlackFlow-2   \\\n",
       "0          329.432         303.099      175.964      1127.197      1319.039   \n",
       "1          330.823         304.879      163.202       665.975      1297.317   \n",
       "2          329.140         303.383      164.013       677.534      1327.072   \n",
       "3          328.875         302.254      181.487       767.853      1324.461   \n",
       "4          328.352         300.954      183.929       888.448      1343.424   \n",
       "..             ...             ...          ...           ...           ...   \n",
       "298        332.924         307.626      145.299       832.906      1344.708   \n",
       "299        332.523         307.169      151.544       905.639      1344.469   \n",
       "300        331.263         306.400      157.954       908.691      1344.588   \n",
       "301        333.032         308.732      174.069       986.206      1348.747   \n",
       "307        328.699         300.706      180.229       903.605      1323.082   \n",
       "\n",
       "     WeakWashF   SteamHeatF-3   T-Top-Chips-4   SulphidityL-4   \n",
       "0       257.325         54.612         252.077           29.11  \n",
       "1       241.182         46.603         251.406           29.11  \n",
       "2       237.272         51.795         251.335           29.02  \n",
       "3       239.478         54.846         250.312           29.02  \n",
       "4       215.372         54.186         249.916           29.01  \n",
       "..          ...            ...             ...             ...  \n",
       "298     388.911         49.524         251.833           30.29  \n",
       "299     418.979         48.135         251.614           30.47  \n",
       "300     462.712         54.373         251.197           30.46  \n",
       "301     457.313         53.194         251.324           30.46  \n",
       "307     232.729         54.503         250.084             NaN  \n",
       "\n",
       "[301 rows x 23 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data3=data.fillna(method='bfill')\n",
    "data3"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}