Shell Data.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "toc": true
   },
   "source": [
    "<h1>Table of Contents<span class=\"tocSkip\"></span></h1>\n",
    "<div class=\"toc\"><ul class=\"toc-item\"></ul></div>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from matplotlib import pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\ProgramData\\Anaconda3\\lib\\site-packages\\IPython\\core\\interactiveshell.py:3049: DtypeWarning: Columns (0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    }
   ],
   "source": [
    "# Load the data (will take a short while)\n",
    "clean_data = pd.read_csv(\"shell_data/clean_dataset.csv\")\n",
    "raw_data = pd.read_csv(\"shell_data/raw_dataset.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": true
   },
   "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>Temperature Indicating 0</th>\n",
       "      <th>Flow Rate Difference 1</th>\n",
       "      <th>Flow Rate Indicating 2</th>\n",
       "      <th>Flow Rate Indicating 3</th>\n",
       "      <th>Flow Rate Indicating 4</th>\n",
       "      <th>Flow Rate Indicating 5</th>\n",
       "      <th>Flow Rate Indicating 6</th>\n",
       "      <th>Flow Rate Indicating 7</th>\n",
       "      <th>Flow Rate Indicating 8</th>\n",
       "      <th>Flow Rate Transmitting 9</th>\n",
       "      <th>...</th>\n",
       "      <th>Pressure Indicating 353</th>\n",
       "      <th>Pressure Emergency Action 354</th>\n",
       "      <th>Temperature Controller 355</th>\n",
       "      <th>Temperature Indicating 356</th>\n",
       "      <th>Temperature Indicating 357</th>\n",
       "      <th>Temperature Indicating 358</th>\n",
       "      <th>Temperature Indicating 359</th>\n",
       "      <th>Temperature Indicating 360</th>\n",
       "      <th>Pressure Emergency Action 361</th>\n",
       "      <th>original_index</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>96.026969</td>\n",
       "      <td>134.058575</td>\n",
       "      <td>3.016896</td>\n",
       "      <td>5.499815</td>\n",
       "      <td>27221.60098</td>\n",
       "      <td>72829.95047</td>\n",
       "      <td>227.437532</td>\n",
       "      <td>5.672353</td>\n",
       "      <td>8.660389</td>\n",
       "      <td>259.164053</td>\n",
       "      <td>...</td>\n",
       "      <td>44.119015</td>\n",
       "      <td>44.053790</td>\n",
       "      <td>29.662350</td>\n",
       "      <td>54.554506</td>\n",
       "      <td>64.945662</td>\n",
       "      <td>25.450283</td>\n",
       "      <td>63.617557</td>\n",
       "      <td>64.978109</td>\n",
       "      <td>43.724690</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>95.987510</td>\n",
       "      <td>134.592346</td>\n",
       "      <td>3.020742</td>\n",
       "      <td>5.600833</td>\n",
       "      <td>27179.00250</td>\n",
       "      <td>71681.45082</td>\n",
       "      <td>227.170568</td>\n",
       "      <td>5.670112</td>\n",
       "      <td>8.642001</td>\n",
       "      <td>262.580608</td>\n",
       "      <td>...</td>\n",
       "      <td>44.053370</td>\n",
       "      <td>44.047508</td>\n",
       "      <td>29.694455</td>\n",
       "      <td>54.828519</td>\n",
       "      <td>64.916624</td>\n",
       "      <td>25.474713</td>\n",
       "      <td>63.724127</td>\n",
       "      <td>65.082058</td>\n",
       "      <td>43.772990</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>96.099651</td>\n",
       "      <td>133.920536</td>\n",
       "      <td>3.013397</td>\n",
       "      <td>5.797500</td>\n",
       "      <td>27383.78150</td>\n",
       "      <td>72524.83458</td>\n",
       "      <td>226.903604</td>\n",
       "      <td>5.664165</td>\n",
       "      <td>8.644843</td>\n",
       "      <td>259.783251</td>\n",
       "      <td>...</td>\n",
       "      <td>44.104163</td>\n",
       "      <td>43.991800</td>\n",
       "      <td>29.750101</td>\n",
       "      <td>54.721836</td>\n",
       "      <td>64.922810</td>\n",
       "      <td>25.478107</td>\n",
       "      <td>63.597104</td>\n",
       "      <td>64.966048</td>\n",
       "      <td>43.787082</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>96.035449</td>\n",
       "      <td>134.231352</td>\n",
       "      <td>3.015035</td>\n",
       "      <td>5.701667</td>\n",
       "      <td>27379.02161</td>\n",
       "      <td>72950.02499</td>\n",
       "      <td>226.636640</td>\n",
       "      <td>5.674515</td>\n",
       "      <td>8.654543</td>\n",
       "      <td>261.888867</td>\n",
       "      <td>...</td>\n",
       "      <td>44.154805</td>\n",
       "      <td>43.980715</td>\n",
       "      <td>29.716741</td>\n",
       "      <td>54.590356</td>\n",
       "      <td>64.966617</td>\n",
       "      <td>25.459767</td>\n",
       "      <td>63.680943</td>\n",
       "      <td>65.015700</td>\n",
       "      <td>43.810581</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>96.067453</td>\n",
       "      <td>133.592223</td>\n",
       "      <td>3.009237</td>\n",
       "      <td>5.802500</td>\n",
       "      <td>26758.24220</td>\n",
       "      <td>71980.98191</td>\n",
       "      <td>226.369675</td>\n",
       "      <td>5.705325</td>\n",
       "      <td>8.667772</td>\n",
       "      <td>256.294601</td>\n",
       "      <td>...</td>\n",
       "      <td>44.042264</td>\n",
       "      <td>43.994559</td>\n",
       "      <td>29.790411</td>\n",
       "      <td>54.697244</td>\n",
       "      <td>64.887116</td>\n",
       "      <td>25.441427</td>\n",
       "      <td>63.648130</td>\n",
       "      <td>64.955505</td>\n",
       "      <td>43.746895</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 363 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Temperature Indicating 0  Flow Rate Difference 1  Flow Rate Indicating 2  \\\n",
       "0                 96.026969              134.058575                3.016896   \n",
       "1                 95.987510              134.592346                3.020742   \n",
       "2                 96.099651              133.920536                3.013397   \n",
       "3                 96.035449              134.231352                3.015035   \n",
       "4                 96.067453              133.592223                3.009237   \n",
       "\n",
       "   Flow Rate Indicating 3  Flow Rate Indicating 4  Flow Rate Indicating 5  \\\n",
       "0                5.499815             27221.60098             72829.95047   \n",
       "1                5.600833             27179.00250             71681.45082   \n",
       "2                5.797500             27383.78150             72524.83458   \n",
       "3                5.701667             27379.02161             72950.02499   \n",
       "4                5.802500             26758.24220             71980.98191   \n",
       "\n",
       "   Flow Rate Indicating 6  Flow Rate Indicating 7  Flow Rate Indicating 8  \\\n",
       "0              227.437532                5.672353                8.660389   \n",
       "1              227.170568                5.670112                8.642001   \n",
       "2              226.903604                5.664165                8.644843   \n",
       "3              226.636640                5.674515                8.654543   \n",
       "4              226.369675                5.705325                8.667772   \n",
       "\n",
       "   Flow Rate Transmitting 9  ...  Pressure Indicating 353  \\\n",
       "0                259.164053  ...                44.119015   \n",
       "1                262.580608  ...                44.053370   \n",
       "2                259.783251  ...                44.104163   \n",
       "3                261.888867  ...                44.154805   \n",
       "4                256.294601  ...                44.042264   \n",
       "\n",
       "   Pressure Emergency Action 354  Temperature Controller 355  \\\n",
       "0                      44.053790                   29.662350   \n",
       "1                      44.047508                   29.694455   \n",
       "2                      43.991800                   29.750101   \n",
       "3                      43.980715                   29.716741   \n",
       "4                      43.994559                   29.790411   \n",
       "\n",
       "   Temperature Indicating 356  Temperature Indicating 357  \\\n",
       "0                   54.554506                   64.945662   \n",
       "1                   54.828519                   64.916624   \n",
       "2                   54.721836                   64.922810   \n",
       "3                   54.590356                   64.966617   \n",
       "4                   54.697244                   64.887116   \n",
       "\n",
       "   Temperature Indicating 358  Temperature Indicating 359  \\\n",
       "0                   25.450283                   63.617557   \n",
       "1                   25.474713                   63.724127   \n",
       "2                   25.478107                   63.597104   \n",
       "3                   25.459767                   63.680943   \n",
       "4                   25.441427                   63.648130   \n",
       "\n",
       "   Temperature Indicating 360  Pressure Emergency Action 361  original_index  \n",
       "0                   64.978109                      43.724690               0  \n",
       "1                   65.082058                      43.772990               1  \n",
       "2                   64.966048                      43.787082               2  \n",
       "3                   65.015700                      43.810581               3  \n",
       "4                   64.955505                      43.746895               4  \n",
       "\n",
       "[5 rows x 363 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "clean_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Temperature Indicating 0\n",
      "Flow Rate Difference 1\n",
      "Flow Rate Indicating 2\n",
      "Flow Rate Indicating 3\n",
      "Flow Rate Indicating 4\n",
      "Flow Rate Indicating 5\n",
      "Flow Rate Indicating 6\n",
      "Flow Rate Indicating 7\n",
      "Flow Rate Indicating 8\n",
      "Flow Rate Transmitting 9\n",
      "Flow Rate Transmitting 10\n",
      "Flow Rate Transmitting 11\n",
      "Flow Rate Transmitting 12\n",
      "Flow Rate Actuating Element 13\n",
      "Flow Rate Solenoid 14\n",
      "Gauging Difference 15\n",
      "Time Control Unknown 16\n",
      "Level Indicating 17\n",
      "Level Indicating 18\n",
      "Pressure Controller 19\n",
      "Pressure Difference 20\n",
      "Pressure Difference 21\n",
      "Pressure Difference 22\n",
      "Pressure Difference 23\n",
      "Pressure Difference 24\n",
      "Pressure Difference 25\n",
      "Pressure Difference 26\n",
      "Pressure Difference 27\n",
      "Pressure Difference 28\n",
      "Pressure Difference 29\n",
      "Pressure Difference 30\n",
      "Pressure Difference 31\n",
      "Pressure Difference 32\n",
      "Pressure Indicating 33\n",
      "Pressure Indicating 34\n",
      "Pressure Indicating 35\n",
      "Pressure Indicating 36\n",
      "Pressure Indicating 37\n",
      "Pressure Indicating 38\n",
      "Pressure Indicating 39\n",
      "Pressure Indicating 40\n",
      "Pressure Indicating 41\n",
      "Pressure Indicating 42\n",
      "Pressure Indicating 43\n",
      "Pressure Indicating 44\n",
      "Pressure Indicating 45\n",
      "Pressure Indicating 46\n",
      "Pressure Indicating 47\n",
      "Pressure Indicating 48\n",
      "Pressure Indicating 49\n",
      "Pressure Indicating 50\n",
      "Pressure Indicating 51\n",
      "Pressure Indicating 52\n",
      "Pressure Indicating 53\n",
      "Pressure Indicating 54\n",
      "Pressure Indicating 55\n",
      "Pressure Indicating 56\n",
      "Pressure Transmitting 57\n",
      "Pressure Transmitting 58\n",
      "Pressure Solenoid 59\n",
      "Pressure Emergency Action 60\n",
      "Pressure Emergency Action 61\n",
      "Pressure Emergency Action 62\n",
      "Pressure Emergency Action 63\n",
      "Pressure Emergency Action 64\n",
      "Pressure Emergency Action 65\n",
      "Pressure Emergency Action 66\n",
      "Pressure Emergency Action 67\n",
      "Pressure Emergency Action 68\n",
      "Speed Element 69\n",
      "Speed Indicating 70\n",
      "Speed Indicating 71\n",
      "Speed Indicating 72\n",
      "Speed Indicating 73\n",
      "Temperature Difference 74\n",
      "Temperature Difference 75\n",
      "Temperature Indicating 76\n",
      "Temperature Indicating 77\n",
      "Temperature Indicating 78\n",
      "Temperature Indicating 79\n",
      "Temperature Indicating 80\n",
      "Temperature Indicating 81\n",
      "Temperature Indicating 82\n",
      "Temperature Indicating 83\n",
      "Temperature Indicating 84\n",
      "Temperature Indicating 85\n",
      "Temperature Indicating 86\n",
      "Temperature Indicating 87\n",
      "Temperature Indicating 88\n",
      "Temperature Indicating 89\n",
      "Temperature Indicating 90\n",
      "Temperature Indicating 91\n",
      "Temperature Indicating 92\n",
      "Temperature Indicating 93\n",
      "Temperature Indicating 94\n",
      "Temperature Indicating 95\n",
      "Temperature Indicating 96\n",
      "Temperature Indicating 97\n",
      "Temperature Indicating 98\n",
      "Temperature Indicating 99\n",
      "Temperature Indicating 100\n",
      "Temperature Indicating 101\n",
      "Temperature Indicating 102\n",
      "Temperature Indicating 103\n",
      "Temperature Indicating 104\n",
      "Temperature Indicating 105\n",
      "Temperature Indicating 106\n",
      "Temperature Indicating 107\n",
      "Temperature Indicating 108\n",
      "Temperature Indicating 109\n",
      "Temperature Indicating 110\n",
      "Temperature Indicating 111\n",
      "Temperature Indicating 112\n",
      "Temperature Indicating 113\n",
      "Temperature Indicating 114\n",
      "Temperature Indicating 115\n",
      "Temperature Indicating 116\n",
      "Temperature Indicating 117\n",
      "Temperature Indicating 118\n",
      "Temperature Indicating 119\n",
      "Temperature Indicating 120\n",
      "Temperature Indicating 121\n",
      "Temperature Emergency Action 122\n",
      "Temperature Emergency Action 123\n",
      "Temperature Emergency Action 124\n",
      "Unknown Computing 125\n",
      "Unknown Computing 126\n",
      "Unknown Computing 127\n",
      "Unknown Computing 128\n",
      "Unknown Computing 129\n",
      "Unknown Computing 130\n",
      "Unknown Computing 131\n",
      "Unknown Computing 132\n",
      "Unknown Computing 133\n",
      "Unknown Computing 134\n",
      "Unknown Computing 135\n",
      "Unknown Computing 136\n",
      "Unknown Computing 137\n",
      "Unknown Computing 138\n",
      "Unknown Computing 139\n",
      "Unknown Computing 140\n",
      "Unknown Computing 141\n",
      "Unknown Computing 142\n",
      "Unknown Computing 143\n",
      "Unknown Computing 144\n",
      "Unknown Computing 145\n",
      "Unknown Computing 146\n",
      "Unknown Solenoid 147\n",
      "Unknown Solenoid 148\n",
      "Unknown Solenoid 149\n",
      "Unknown Solenoid 150\n",
      "Unknown Solenoid 151\n",
      "Unknown Solenoid 152\n",
      "Unknown Solenoid 153\n",
      "Unknown Solenoid 154\n",
      "Unknown Solenoid 155\n",
      "Unknown Solenoid 156\n",
      "Unknown Solenoid 157\n",
      "Unknown Solenoid 158\n",
      "Unknown Solenoid 159\n",
      "Unknown Solenoid 160\n",
      "Unknown Solenoid 161\n",
      "Unknown Solenoid 162\n",
      "Unknown Solenoid 163\n",
      "Unknown Solenoid 164\n",
      "Unknown Solenoid 165\n",
      "Unknown Solenoid 166\n",
      "Unknown Solenoid 167\n",
      "Unknown Solenoid 168\n",
      "Unknown Emergency Action 169\n",
      "Unknown Emergency Action 170\n",
      "Unknown Emergency Action 171\n",
      "Unknown Emergency Action 172\n",
      "Unknown Emergency Action 173\n",
      "Unknown Emergency Action 174\n",
      "Unknown Emergency Action 175\n",
      "Unknown Emergency Action 176\n",
      "Unknown Emergency Action 177\n",
      "Unknown Emergency Action 178\n",
      "Unknown Emergency Action 179\n",
      "Classified Difference 180\n",
      "Classified Indicating 181\n",
      "Classified Indicating 182\n",
      "Classified Indicating 183\n",
      "Classified Indicating 184\n",
      "Classified Indicating 185\n",
      "Classified Indicating 186\n",
      "Classified Indicating 187\n",
      "Classified Indicating 188\n",
      "Classified Solenoid 189\n",
      "Pressure Indicating 190\n",
      "Flow Rate Transmitting 191\n",
      "Level High 192\n",
      "Level Indicating 193\n",
      "Level Indicating 194\n",
      "Level Indicating 195\n",
      "Pressure Controller 196\n",
      "Pressure Difference 197\n",
      "Pressure Difference 198\n",
      "Pressure Difference 199\n",
      "Pressure Difference 200\n",
      "Pressure Difference 201\n",
      "Pressure Difference 202\n",
      "Pressure Indicating 203\n",
      "Pressure Indicating 204\n",
      "Temperature Controller 205\n",
      "Temperature Controller 206\n",
      "Temperature Indicating 207\n",
      "Temperature Indicating 208\n",
      "Temperature Indicating 209\n",
      "Temperature Indicating 210\n",
      "Flow Rate Difference 211\n",
      "Flow Rate Difference 212\n",
      "Flow Rate Indicating 213\n",
      "Flow Rate Summation 214\n",
      "Flow Rate Summation 215\n",
      "Flow Rate Transmitting 216\n",
      "Flow Rate Transmitting 217\n",
      "Flow Rate Transmitting 218\n",
      "Flow Rate Transmitting 219\n",
      "Flow Rate Solenoid 220\n",
      "Flow Rate Solenoid 221\n",
      "Flow Rate Solenoid 222\n",
      "Gauging Difference 223\n",
      "Gauging Difference 224\n",
      "Time Control Unknown 225\n",
      "Time Control Unknown 226\n",
      "Level Indicating 227\n",
      "Pressure Difference 228\n",
      "Pressure Difference 229\n",
      "Pressure Difference 230\n",
      "Pressure Difference 231\n",
      "Pressure Difference 232\n",
      "Pressure Difference 233\n",
      "Pressure Difference 234\n",
      "Pressure Indicating 235\n",
      "Pressure Indicating 236\n",
      "Pressure Indicating 237\n",
      "Pressure Indicating 238\n",
      "Pressure Indicating 239\n",
      "Pressure Indicating 240\n",
      "Pressure Indicating 241\n",
      "Pressure Indicating 242\n",
      "Pressure Indicating 243\n",
      "Pressure Indicating 244\n",
      "Pressure Transmitting 245\n",
      "Pressure Solenoid 246\n",
      "Pressure Emergency Action 247\n",
      "Pressure Emergency Action 248\n",
      "Pressure Emergency Action 249\n",
      "Pressure Emergency Action 250\n",
      "Speed Indicating 251\n",
      "Speed Indicating 252\n",
      "Speed Indicating 253\n",
      "Speed Indicating 254\n",
      "Speed Indicating 255\n",
      "Speed Indicating 256\n",
      "Speed Solenoid 257\n",
      "Speed Solenoid 258\n",
      "Speed Solenoid 259\n",
      "Temperature Difference 260\n",
      "Temperature Indicating 261\n",
      "Temperature Indicating 262\n",
      "Temperature Indicating 263\n",
      "Temperature Indicating 264\n",
      "Temperature Indicating 265\n",
      "Temperature Indicating 266\n",
      "Temperature Indicating 267\n",
      "Temperature Indicating 268\n",
      "Temperature Indicating 269\n",
      "Temperature Indicating 270\n",
      "Temperature Indicating 271\n",
      "Temperature Indicating 272\n",
      "Temperature Indicating 273\n",
      "Temperature Indicating 274\n",
      "Temperature Indicating 275\n",
      "Temperature Indicating 276\n",
      "Temperature Indicating 277\n",
      "Temperature Indicating 278\n",
      "Temperature Indicating 279\n",
      "Temperature Indicating 280\n",
      "Temperature Indicating 281\n",
      "Temperature Indicating 282\n",
      "Temperature Indicating 283\n",
      "Temperature Indicating 284\n",
      "Temperature Indicating 285\n",
      "Temperature Indicating 286\n",
      "Temperature Indicating 287\n",
      "Temperature Indicating 288\n",
      "Temperature Indicating 289\n",
      "Temperature Indicating 290\n",
      "Temperature Indicating 291\n",
      "Temperature Indicating 292\n",
      "Temperature Indicating 293\n",
      "Temperature Indicating 294\n",
      "Temperature Indicating 295\n",
      "Temperature Indicating 296\n",
      "Temperature Indicating 297\n",
      "Temperature Indicating 298\n",
      "Temperature Indicating 299\n",
      "Temperature Indicating 300\n",
      "Temperature Indicating 301\n",
      "Temperature Indicating 302\n",
      "Temperature Indicating 303\n",
      "Temperature Emergency Action 304\n",
      "Temperature Emergency Action 305\n",
      "Unknown Computing 306\n",
      "Unknown Computing 307\n",
      "Unknown Computing 308\n",
      "Unknown Computing 309\n",
      "Unknown Computing 310\n",
      "Unknown Computing 311\n",
      "Unknown Computing 312\n",
      "Unknown Computing 313\n",
      "Unknown Computing 314\n",
      "Unknown Computing 315\n",
      "Unknown Computing 316\n",
      "Unknown Solenoid 317\n",
      "Unknown Solenoid 318\n",
      "Unknown Solenoid 319\n",
      "Unknown Solenoid 320\n",
      "Unknown Solenoid 321\n",
      "Unknown Solenoid 322\n",
      "Unknown Solenoid 323\n",
      "Unknown Solenoid 324\n",
      "Unknown Solenoid 325\n",
      "Unknown Solenoid 326\n",
      "Unknown Solenoid 327\n",
      "Classified Status 328\n",
      "Classified Indicating 329\n",
      "Classified Indicating 330\n",
      "Classified Indicating 331\n",
      "Classified Indicating 332\n",
      "Classified Indicating 333\n",
      "Classified Indicating 334\n",
      "Classified Indicating 335\n",
      "Classified Indicating 336\n",
      "Unknown Indicating 337\n",
      "Unknown Indicating 338\n",
      "Unknown Indicating 339\n",
      "Unknown Indicating 340\n",
      "Unknown Indicating 341\n",
      "Unknown Indicating 342\n",
      "Flow Rate Difference 343\n",
      "Flow Rate Indicating 344\n",
      "Flow Rate Actuating Element 345\n",
      "Level Emergency Action 346\n",
      "Pressure Difference 347\n",
      "Pressure Difference 348\n",
      "Pressure Difference 349\n",
      "Pressure Difference 350\n",
      "Pressure Indicating 351\n",
      "Pressure Indicating 352\n",
      "Pressure Indicating 353\n",
      "Pressure Emergency Action 354\n",
      "Temperature Controller 355\n",
      "Temperature Indicating 356\n",
      "Temperature Indicating 357\n",
      "Temperature Indicating 358\n",
      "Temperature Indicating 359\n",
      "Temperature Indicating 360\n",
      "Pressure Emergency Action 361\n",
      "original_index\n"
     ]
    }
   ],
   "source": [
    "for x in clean_data.columns:\n",
    "    print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": true
   },
   "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>Temperature Indicating 1</th>\n",
       "      <th>Flow Rate Difference 2</th>\n",
       "      <th>Flow Rate Indicating 3</th>\n",
       "      <th>Flow Rate Indicating 4</th>\n",
       "      <th>Flow Rate Indicating 5</th>\n",
       "      <th>Flow Rate Indicating 6</th>\n",
       "      <th>Flow Rate Indicating 7</th>\n",
       "      <th>Flow Rate Indicating 8</th>\n",
       "      <th>Flow Rate Indicating 9</th>\n",
       "      <th>Flow Rate Transmitting 10</th>\n",
       "      <th>...</th>\n",
       "      <th>Pressure Indicating 396</th>\n",
       "      <th>Pressure Indicating 397</th>\n",
       "      <th>Pressure Emergency Action 398</th>\n",
       "      <th>Temperature Controller 399</th>\n",
       "      <th>Temperature Indicating 400</th>\n",
       "      <th>Temperature Indicating 401</th>\n",
       "      <th>Temperature Indicating 402</th>\n",
       "      <th>Temperature Indicating 403</th>\n",
       "      <th>Temperature Indicating 404</th>\n",
       "      <th>Pressure Alarm 405</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>96.027</td>\n",
       "      <td>134.059</td>\n",
       "      <td>3.0169</td>\n",
       "      <td>5.4998148</td>\n",
       "      <td>27221.6</td>\n",
       "      <td>72830</td>\n",
       "      <td>227.438</td>\n",
       "      <td>5.67235</td>\n",
       "      <td>8.66039</td>\n",
       "      <td>259.164</td>\n",
       "      <td>...</td>\n",
       "      <td>27.957</td>\n",
       "      <td>44.1190151</td>\n",
       "      <td>44.0538</td>\n",
       "      <td>29.6624</td>\n",
       "      <td>54.5545</td>\n",
       "      <td>64.9457</td>\n",
       "      <td>25.4503</td>\n",
       "      <td>63.6176</td>\n",
       "      <td>64.9781</td>\n",
       "      <td>43.7247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>95.9875</td>\n",
       "      <td>134.592</td>\n",
       "      <td>3.02074</td>\n",
       "      <td>5.6008333</td>\n",
       "      <td>27179</td>\n",
       "      <td>71681.5</td>\n",
       "      <td>227.171</td>\n",
       "      <td>5.67011</td>\n",
       "      <td>8.642</td>\n",
       "      <td>262.581</td>\n",
       "      <td>...</td>\n",
       "      <td>27.9507</td>\n",
       "      <td>44.0533698</td>\n",
       "      <td>44.0475</td>\n",
       "      <td>29.6945</td>\n",
       "      <td>54.8285</td>\n",
       "      <td>64.9166</td>\n",
       "      <td>25.4747</td>\n",
       "      <td>63.7241</td>\n",
       "      <td>65.0821</td>\n",
       "      <td>43.773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>96.0997</td>\n",
       "      <td>133.921</td>\n",
       "      <td>3.0134</td>\n",
       "      <td>5.7975</td>\n",
       "      <td>27383.8</td>\n",
       "      <td>72524.8</td>\n",
       "      <td>226.904</td>\n",
       "      <td>5.66417</td>\n",
       "      <td>8.64484</td>\n",
       "      <td>259.783</td>\n",
       "      <td>...</td>\n",
       "      <td>28.0306</td>\n",
       "      <td>44.1041635</td>\n",
       "      <td>43.9918</td>\n",
       "      <td>29.7501</td>\n",
       "      <td>54.7218</td>\n",
       "      <td>64.9228</td>\n",
       "      <td>25.4781</td>\n",
       "      <td>63.5971</td>\n",
       "      <td>64.966</td>\n",
       "      <td>43.7871</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>96.0354</td>\n",
       "      <td>134.231</td>\n",
       "      <td>3.01504</td>\n",
       "      <td>5.7016667</td>\n",
       "      <td>27379</td>\n",
       "      <td>72950</td>\n",
       "      <td>226.637</td>\n",
       "      <td>5.67452</td>\n",
       "      <td>8.65454</td>\n",
       "      <td>261.889</td>\n",
       "      <td>...</td>\n",
       "      <td>27.9909</td>\n",
       "      <td>44.1548052</td>\n",
       "      <td>43.9807</td>\n",
       "      <td>29.7167</td>\n",
       "      <td>54.5904</td>\n",
       "      <td>64.9666</td>\n",
       "      <td>25.4598</td>\n",
       "      <td>63.6809</td>\n",
       "      <td>65.0157</td>\n",
       "      <td>43.8106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>96.0675</td>\n",
       "      <td>133.592</td>\n",
       "      <td>3.00924</td>\n",
       "      <td>5.8025</td>\n",
       "      <td>26758.2</td>\n",
       "      <td>71981</td>\n",
       "      <td>226.37</td>\n",
       "      <td>5.70532</td>\n",
       "      <td>8.66777</td>\n",
       "      <td>256.295</td>\n",
       "      <td>...</td>\n",
       "      <td>27.9945</td>\n",
       "      <td>44.042264</td>\n",
       "      <td>43.9946</td>\n",
       "      <td>29.7904</td>\n",
       "      <td>54.6972</td>\n",
       "      <td>64.8871</td>\n",
       "      <td>25.4414</td>\n",
       "      <td>63.6481</td>\n",
       "      <td>64.9555</td>\n",
       "      <td>43.7469</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 405 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Temperature Indicating 1 Flow Rate Difference 2 Flow Rate Indicating 3  \\\n",
       "0                   96.027                134.059                 3.0169   \n",
       "1                  95.9875                134.592                3.02074   \n",
       "2                  96.0997                133.921                 3.0134   \n",
       "3                  96.0354                134.231                3.01504   \n",
       "4                  96.0675                133.592                3.00924   \n",
       "\n",
       "  Flow Rate Indicating 4 Flow Rate Indicating 5 Flow Rate Indicating 6  \\\n",
       "0              5.4998148                27221.6                  72830   \n",
       "1              5.6008333                  27179                71681.5   \n",
       "2                 5.7975                27383.8                72524.8   \n",
       "3              5.7016667                  27379                  72950   \n",
       "4                 5.8025                26758.2                  71981   \n",
       "\n",
       "  Flow Rate Indicating 7 Flow Rate Indicating 8 Flow Rate Indicating 9  \\\n",
       "0                227.438                5.67235                8.66039   \n",
       "1                227.171                5.67011                  8.642   \n",
       "2                226.904                5.66417                8.64484   \n",
       "3                226.637                5.67452                8.65454   \n",
       "4                 226.37                5.70532                8.66777   \n",
       "\n",
       "  Flow Rate Transmitting 10  ... Pressure Indicating 396  \\\n",
       "0                   259.164  ...                  27.957   \n",
       "1                   262.581  ...                 27.9507   \n",
       "2                   259.783  ...                 28.0306   \n",
       "3                   261.889  ...                 27.9909   \n",
       "4                   256.295  ...                 27.9945   \n",
       "\n",
       "  Pressure Indicating 397 Pressure Emergency Action 398  \\\n",
       "0              44.1190151                       44.0538   \n",
       "1              44.0533698                       44.0475   \n",
       "2              44.1041635                       43.9918   \n",
       "3              44.1548052                       43.9807   \n",
       "4               44.042264                       43.9946   \n",
       "\n",
       "  Temperature Controller 399 Temperature Indicating 400  \\\n",
       "0                    29.6624                    54.5545   \n",
       "1                    29.6945                    54.8285   \n",
       "2                    29.7501                    54.7218   \n",
       "3                    29.7167                    54.5904   \n",
       "4                    29.7904                    54.6972   \n",
       "\n",
       "  Temperature Indicating 401 Temperature Indicating 402  \\\n",
       "0                    64.9457                    25.4503   \n",
       "1                    64.9166                    25.4747   \n",
       "2                    64.9228                    25.4781   \n",
       "3                    64.9666                    25.4598   \n",
       "4                    64.8871                    25.4414   \n",
       "\n",
       "  Temperature Indicating 403 Temperature Indicating 404 Pressure Alarm 405  \n",
       "0                    63.6176                    64.9781            43.7247  \n",
       "1                    63.7241                    65.0821             43.773  \n",
       "2                    63.5971                     64.966            43.7871  \n",
       "3                    63.6809                    65.0157            43.8106  \n",
       "4                    63.6481                    64.9555            43.7469  \n",
       "\n",
       "[5 rows x 405 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "raw_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Temperature Indicating 1\n",
      "Flow Rate Difference 2\n",
      "Flow Rate Indicating 3\n",
      "Flow Rate Indicating 4\n",
      "Flow Rate Indicating 5\n",
      "Flow Rate Indicating 6\n",
      "Flow Rate Indicating 7\n",
      "Flow Rate Indicating 8\n",
      "Flow Rate Indicating 9\n",
      "Flow Rate Transmitting 10\n",
      "Flow Rate Transmitting 11\n",
      "Flow Rate Transmitting 12\n",
      "Flow Rate Transmitting 13\n",
      "Flow Rate Actuating Element 14\n",
      "Flow Rate Solenoid 15\n",
      "Gauging Difference 16\n",
      "Time Control Unknown 17\n",
      "Time Control Unknown 18\n",
      "Level Indicating 19\n",
      "Level Indicating 20\n",
      "Pressure Controller 21\n",
      "Pressure Difference 22\n",
      "Pressure Difference 23\n",
      "Pressure Difference 24\n",
      "Pressure Difference 25\n",
      "Pressure Difference 26\n",
      "Pressure Difference 27\n",
      "Pressure Difference 28\n",
      "Pressure Difference 29\n",
      "Pressure Difference 30\n",
      "Pressure Difference 31\n",
      "Pressure Difference 32\n",
      "Pressure Difference 33\n",
      "Pressure Difference 34\n",
      "Pressure Difference 35\n",
      "Pressure Difference 36\n",
      "Pressure Indicating 37\n",
      "Pressure Indicating 38\n",
      "Pressure Indicating 39\n",
      "Pressure Indicating 40\n",
      "Pressure Indicating 41\n",
      "Pressure Indicating 42\n",
      "Pressure Indicating 43\n",
      "Pressure Indicating 44\n",
      "Pressure Indicating 45\n",
      "Pressure Indicating 46\n",
      "Pressure Indicating 47\n",
      "Pressure Indicating 48\n",
      "Pressure Indicating 49\n",
      "Pressure Indicating 50\n",
      "Pressure Indicating 51\n",
      "Pressure Indicating 52\n",
      "Pressure Indicating 53\n",
      "Pressure Indicating 54\n",
      "Pressure Indicating 55\n",
      "Pressure Indicating 56\n",
      "Pressure Indicating 57\n",
      "Pressure Indicating 58\n",
      "Pressure Indicating 59\n",
      "Pressure Indicating 60\n",
      "Pressure Transmitting 61\n",
      "Pressure Transmitting 62\n",
      "Pressure Transmitting 63\n",
      "Pressure Solenoid 64\n",
      "Pressure Emergency Action 65\n",
      "Pressure Emergency Action 66\n",
      "Pressure Emergency Action 67\n",
      "Pressure Emergency Action 68\n",
      "Pressure Emergency Action 69\n",
      "Pressure Emergency Action 70\n",
      "Pressure Emergency Action 71\n",
      "Pressure Emergency Action 72\n",
      "Pressure Emergency Action 73\n",
      "Speed Element 74\n",
      "Speed Indicating 75\n",
      "Speed Indicating 76\n",
      "Speed Indicating 77\n",
      "Speed Indicating 78\n",
      "Temperature Difference 79\n",
      "Temperature Difference 80\n",
      "Temperature Indicating 81\n",
      "Temperature Indicating 82\n",
      "Temperature Indicating 83\n",
      "Temperature Indicating 84\n",
      "Temperature Indicating 85\n",
      "Temperature Indicating 86\n",
      "Temperature Indicating 87\n",
      "Temperature Indicating 88\n",
      "Temperature Indicating 89\n",
      "Temperature Indicating 90\n",
      "Temperature Indicating 91\n",
      "Temperature Indicating 92\n",
      "Temperature Indicating 93\n",
      "Temperature Indicating 94\n",
      "Temperature Indicating 95\n",
      "Temperature Indicating 96\n",
      "Temperature Indicating 97\n",
      "Temperature Indicating 98\n",
      "Temperature Indicating 99\n",
      "Temperature Indicating 100\n",
      "Temperature Indicating 101\n",
      "Temperature Indicating 102\n",
      "Temperature Indicating 103\n",
      "Temperature Indicating 104\n",
      "Temperature Indicating 105\n",
      "Temperature Indicating 106\n",
      "Temperature Indicating 107\n",
      "Temperature Indicating 108\n",
      "Temperature Indicating 109\n",
      "Temperature Indicating 110\n",
      "Temperature Indicating 111\n",
      "Temperature Indicating 112\n",
      "Temperature Indicating 113\n",
      "Temperature Indicating 114\n",
      "Temperature Indicating 115\n",
      "Temperature Indicating 116\n",
      "Temperature Indicating 117\n",
      "Temperature Indicating 118\n",
      "Temperature Indicating 119\n",
      "Temperature Indicating 120\n",
      "Temperature Indicating 121\n",
      "Temperature Indicating 122\n",
      "Temperature Indicating 123\n",
      "Temperature Indicating 124\n",
      "Temperature Indicating 125\n",
      "Temperature Indicating 126\n",
      "Temperature Indicating 127\n",
      "Temperature Indicating 128\n",
      "Temperature Indicating 129\n",
      "Temperature Indicating 130\n",
      "Temperature Indicating 131\n",
      "Temperature Indicating 132\n",
      "Temperature Emergency Action 133\n",
      "Temperature Emergency Action 134\n",
      "Temperature Emergency Action 135\n",
      "Temperature Emergency Action 136\n",
      "Unknown Computing 137\n",
      "Unknown Computing 138\n",
      "Unknown Computing 139\n",
      "Unknown Computing 140\n",
      "Unknown Computing 141\n",
      "Unknown Computing 142\n",
      "Unknown Computing 143\n",
      "Unknown Computing 144\n",
      "Unknown Computing 145\n",
      "Unknown Computing 146\n",
      "Unknown Computing 147\n",
      "Unknown Computing 148\n",
      "Unknown Computing 149\n",
      "Unknown Computing 150\n",
      "Unknown Computing 151\n",
      "Unknown Computing 152\n",
      "Unknown Computing 153\n",
      "Unknown Computing 154\n",
      "Unknown Computing 155\n",
      "Unknown Computing 156\n",
      "Unknown Computing 157\n",
      "Unknown Computing 158\n",
      "Unknown Solenoid 159\n",
      "Unknown Solenoid 160\n",
      "Unknown Solenoid 161\n",
      "Unknown Solenoid 162\n",
      "Unknown Solenoid 163\n",
      "Unknown Solenoid 164\n",
      "Unknown Solenoid 165\n",
      "Unknown Solenoid 166\n",
      "Unknown Solenoid 167\n",
      "Unknown Solenoid 168\n",
      "Unknown Solenoid 169\n",
      "Unknown Solenoid 170\n",
      "Unknown Solenoid 171\n",
      "Unknown Solenoid 172\n",
      "Unknown Solenoid 173\n",
      "Unknown Solenoid 174\n",
      "Unknown Solenoid 175\n",
      "Unknown Solenoid 176\n",
      "Unknown Solenoid 177\n",
      "Unknown Solenoid 178\n",
      "Unknown Solenoid 179\n",
      "Unknown Solenoid 180\n",
      "Unknown Emergency Action 181\n",
      "Unknown Emergency Action 182\n",
      "Unknown Emergency Action 183\n",
      "Unknown Emergency Action 184\n",
      "Unknown Emergency Action 185\n",
      "Unknown Emergency Action 186\n",
      "Unknown Emergency Action 187\n",
      "Unknown Emergency Action 188\n",
      "Unknown Emergency Action 189\n",
      "Unknown Emergency Action 190\n",
      "Unknown Emergency Action 191\n",
      "Unknown Emergency Action 192\n",
      "Classified Difference 193\n",
      "Classified Indicating 194\n",
      "Classified Indicating 195\n",
      "Classified Indicating 196\n",
      "Classified Indicating 197\n",
      "Classified Indicating 198\n",
      "Classified Indicating 199\n",
      "Classified Indicating 200\n",
      "Classified Indicating 201\n",
      "Classified Indicating 202\n",
      "Classified Solenoid 203\n",
      "Pressure Indicating 204\n",
      "Flow Rate Indicating 205\n",
      "Flow Rate Indicating 206\n",
      "Flow Rate Transmitting 207\n",
      "Level High 208\n",
      "Level Indicating 209\n",
      "Level Indicating 210\n",
      "Level Indicating 211\n",
      "Level Indicating 212\n",
      "Level Indicating 213\n",
      "Level Indicating 214\n",
      "Pressure Controller 215\n",
      "Pressure Difference 216\n",
      "Pressure Difference 217\n",
      "Pressure Difference 218\n",
      "Pressure Difference 219\n",
      "Pressure Difference 220\n",
      "Pressure Difference 221\n",
      "Pressure Indicating 222\n",
      "Pressure Indicating 223\n",
      "Pressure Indicating 224\n",
      "Temperature Controller 225\n",
      "Temperature Controller 226\n",
      "Temperature Indicating 227\n",
      "Temperature Indicating 228\n",
      "Temperature Indicating 229\n",
      "Temperature Indicating 230\n",
      "Temperature Indicating 231\n",
      "Temperature Emergency Action 232\n",
      "Electrical Element 233\n",
      "Flow Rate Difference 234\n",
      "Flow Rate Difference 235\n",
      "Flow Rate Indicating 236\n",
      "Flow Rate Indicating 237\n",
      "Flow Rate Indicating 238\n",
      "Flow Rate Indicating 239\n",
      "Flow Rate Summation 240\n",
      "Flow Rate Summation 241\n",
      "Flow Rate Transmitting 242\n",
      "Flow Rate Transmitting 243\n",
      "Flow Rate Transmitting 244\n",
      "Flow Rate Transmitting 245\n",
      "Flow Rate Solenoid 246\n",
      "Flow Rate Solenoid 247\n",
      "Flow Rate Solenoid 248\n",
      "Gauging Difference 249\n",
      "Gauging Difference 250\n",
      "Time Control Unknown 251\n",
      "Time Control Unknown 252\n",
      "Time Control Unknown 253\n",
      "Time Control Unknown 254\n",
      "Time Control Unknown 255\n",
      "Time Control Unknown 256\n",
      "Time Control Unknown 257\n",
      "Level Indicating 258\n",
      "Pressure Difference 259\n",
      "Pressure Difference 260\n",
      "Pressure Difference 261\n",
      "Pressure Difference 262\n",
      "Pressure Difference 263\n",
      "Pressure Difference 264\n",
      "Pressure Difference 265\n",
      "Pressure Difference 266\n",
      "Pressure Difference 267\n",
      "Pressure Difference 268\n",
      "Pressure Difference 269\n",
      "Pressure Difference 270\n",
      "Pressure Indicating 271\n",
      "Pressure Indicating 272\n",
      "Pressure Indicating 273\n",
      "Pressure Indicating 274\n",
      "Pressure Indicating 275\n",
      "Pressure Indicating 276\n",
      "Pressure Indicating 277\n",
      "Pressure Indicating 278\n",
      "Pressure Indicating 279\n",
      "Pressure Indicating 280\n",
      "Pressure Indicating 281\n",
      "Pressure Transmitting 282\n",
      "Pressure Solenoid 283\n",
      "Pressure Emergency Action 284\n",
      "Pressure Emergency Action 285\n",
      "Pressure Emergency Action 286\n",
      "Pressure Emergency Action 287\n",
      "Speed Indicating 288\n",
      "Speed Indicating 289\n",
      "Speed Indicating 290\n",
      "Speed Indicating 291\n",
      "Speed Indicating 292\n",
      "Speed Indicating 293\n",
      "Speed Solenoid 294\n",
      "Speed Solenoid 295\n",
      "Speed Solenoid 296\n",
      "Temperature Difference 297\n",
      "Temperature Indicating 298\n",
      "Temperature Indicating 299\n",
      "Temperature Indicating 300\n",
      "Temperature Indicating 301\n",
      "Temperature Indicating 302\n",
      "Temperature Indicating 303\n",
      "Temperature Indicating 304\n",
      "Temperature Indicating 305\n",
      "Temperature Indicating 306\n",
      "Temperature Indicating 307\n",
      "Temperature Indicating 308\n",
      "Temperature Indicating 309\n",
      "Temperature Indicating 310\n",
      "Temperature Indicating 311\n",
      "Temperature Indicating 312\n",
      "Temperature Indicating 313\n",
      "Temperature Indicating 314\n",
      "Temperature Indicating 315\n",
      "Temperature Indicating 316\n",
      "Temperature Indicating 317\n",
      "Temperature Indicating 318\n",
      "Temperature Indicating 319\n",
      "Temperature Indicating 320\n",
      "Temperature Indicating 321\n",
      "Temperature Indicating 322\n",
      "Temperature Indicating 323\n",
      "Temperature Indicating 324\n",
      "Temperature Indicating 325\n",
      "Temperature Indicating 326\n",
      "Temperature Indicating 327\n",
      "Temperature Indicating 328\n",
      "Temperature Indicating 329\n",
      "Temperature Indicating 330\n",
      "Temperature Indicating 331\n",
      "Temperature Indicating 332\n",
      "Temperature Indicating 333\n",
      "Temperature Indicating 334\n",
      "Temperature Indicating 335\n",
      "Temperature Indicating 336\n",
      "Temperature Indicating 337\n",
      "Temperature Indicating 338\n",
      "Temperature Indicating 339\n",
      "Temperature Indicating 340\n",
      "Temperature Indicating 341\n",
      "Temperature Indicating 342\n",
      "Temperature Indicating 343\n",
      "Temperature Emergency Action 344\n",
      "Temperature Emergency Action 345\n",
      "Unknown Computing 346\n",
      "Unknown Computing 347\n",
      "Unknown Computing 348\n",
      "Unknown Computing 349\n",
      "Unknown Computing 350\n",
      "Unknown Computing 351\n",
      "Unknown Computing 352\n",
      "Unknown Computing 353\n",
      "Unknown Computing 354\n",
      "Unknown Computing 355\n",
      "Unknown Computing 356\n",
      "Unknown Solenoid 357\n",
      "Unknown Solenoid 358\n",
      "Unknown Solenoid 359\n",
      "Unknown Solenoid 360\n",
      "Unknown Solenoid 361\n",
      "Unknown Solenoid 362\n",
      "Unknown Solenoid 363\n",
      "Unknown Solenoid 364\n",
      "Unknown Solenoid 365\n",
      "Unknown Solenoid 366\n",
      "Unknown Solenoid 367\n",
      "Classified Status 368\n",
      "Classified Indicating 369\n",
      "Classified Indicating 370\n",
      "Classified Indicating 371\n",
      "Classified Indicating 372\n",
      "Classified Indicating 373\n",
      "Classified Indicating 374\n",
      "Classified Indicating 375\n",
      "Classified Indicating 376\n",
      "Classified Indicating 377\n",
      "Unknown Indicating 378\n",
      "Unknown Indicating 379\n",
      "Unknown Indicating 380\n",
      "Unknown Indicating 381\n",
      "Unknown Indicating 382\n",
      "Unknown Indicating 383\n",
      "Flow Rate Difference 384\n",
      "Flow Rate Indicating 385\n",
      "Flow Rate Actuating Element 386\n",
      "Level Emergency Action 387\n",
      "Pressure Difference 388\n",
      "Pressure Difference 389\n",
      "Pressure Difference 390\n",
      "Pressure Difference 391\n",
      "Pressure Difference 392\n",
      "Pressure Indicating 393\n",
      "Pressure Indicating 394\n",
      "Pressure Indicating 395\n",
      "Pressure Indicating 396\n",
      "Pressure Indicating 397\n",
      "Pressure Emergency Action 398\n",
      "Temperature Controller 399\n",
      "Temperature Indicating 400\n",
      "Temperature Indicating 401\n",
      "Temperature Indicating 402\n",
      "Temperature Indicating 403\n",
      "Temperature Indicating 404\n",
      "Pressure Alarm 405\n"
     ]
    }
   ],
   "source": [
    "for x in raw_data.columns:\n",
    "    print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.7.3"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": true,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": true
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}